Replies posted by Ramitha_M

1 Reply

R
Do Gooder (Partner)
Ramitha_MDo Gooder (Partner)
asked in Supply Chain

Set FALSE if the value IS NULL.

Hi @ShawnBerk @Richardson69,This is Resolved now.I created an Event for the  Project_Cost_ELement Tab. The action will trigger when the user creates a new record and call Modify method for the Proj_C_Cost_El_Code_P_Dem window and pass the value ‘FALSE’ to the desired column. DECLARE  attr_       VARCHAR2(32000);  sql_msg_    VARCHAR2(32000);  stmt_       VARCHAR2(32000);  job_id_     NUMBER;  BEGIN  stmt_ := 'DECLAREinfo_        VARCHAR2(32000);attr_        VARCHAR2(32000);objid_       VARCHAR2(32000);objversion_  VARCHAR2(32000);CURSOR get_objid ISselect t.objid, t.objversion from proj_c_cost_el_code_p_dem twhere t.project_cost_element = ''&NEW:PROJECT_COST_ELEMENT'';BEGINOPEN get_objid;FETCH get_objid INTO objid_, objversion_;CLOSE get_objid; Client_SYS.Clear_Attr(attr_);   Client_SYS.Add_To_Attr(''C_EXCLUDE_FROM_B_C'',''FALSE'',  attr_);   proj_c_cost_el_code_p_dem_API.Modify__(info_, objid_, objversion_, attr_, ''DO'');COMMIT;END;';  sql_msg_ := Message_SYS.Construct('UPD');  M

3
R
Do Gooder (Partner)
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings