po
fnd_function.Execute(Function_Name => 'PO_POXPOEPO',
Open_Flag => 'Y',
Session_Flag => 'Y',
Other_Params => 'PO_HEADER_ID=' || :Po.Po_Header_Id || ' '
||' ACCESS_LEVEL_CODE="MODIFY"'
||' POXPOEPO_CALLING_FORM="POXSTNOT"',
so
fnd_function.Execute(Function_Name => 'ONT_OEXOEORD',
Open_Flag => 'Y',
Session_Flag => 'Y',
Other_Params => 'DESKTOP_HEADER_ID="' || :So.So_Header_Id || '"',
Activate_Flag => 'ACTIVATE');
pr
fnd_function.execute(function_name => 'PO_POXRQERQ',
open_flag => 'Y',
session_flag => 'Y',
other_params => 'P_REQUISITION_HEADER_ID='||:CUX_PO_MOVER_ORDER_CREATED_V.REQ_HEADER_ID
|| ' p_mode = VIEW'
);
搬运单
Fnd_Profile.PUT('MFG_ORGANIZATION_ID',:CUX_PO_MOVER_ORDER_CREATED_V.ORGANIZATION_ID);
fnd_function.execute(function_name => 'CUXINVTOMAI',
open_flag => 'Y',
session_flag => 'Y',
other_params => 'HEADER_ID='||:CUX_PO_MOVER_ORDER_CREATED_V.TRANS_MOVER_ORDER_ID
||' org_id='||:CUX_PO_MOVER_ORDER_CREATED_V.ORGANIZATION_ID
||' call_From_Wflow=Y');
工单
fnd_function.execute(function_name => 'WIP_WIPDJMDF_QUERY',
open_flag => 'Y',
session_flag => 'Y',
other_params => 'WIP_ENTITY_ID='||:CUX_BLOCK.WIP_ENTITY_ID
||' org_id='||:CUX_BLOCK.ORGANIZATION_ID );