DBA Data[Home] [Help]

APPS.OKE_DELIVERABLE_ACTIONS_PKG dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 759: DELETE FROM po_requisitions_interface_all

755: L_Context := 'Y';
756: L_Description := substr(PA_DELIVERABLE_UTILS.Get_Dlv_Description ( p_action_ver_id => c2info.pa_action_id ), 1, 240);
757:
758: IF c2info.reference1>0 THEN
759: DELETE FROM po_requisitions_interface_all
760: WHERE oke_contract_deliverable_id = c2info.action_id
761: AND batch_id = c2info.reference1;
762: END IF;
763:

Line 764: INSERT INTO po_requisitions_interface_all(

760: WHERE oke_contract_deliverable_id = c2info.action_id
761: AND batch_id = c2info.reference1;
762: END IF;
763:
764: INSERT INTO po_requisitions_interface_all(
765: last_updated_by,
766: last_update_login,
767: last_update_date,
768: creation_date,