DBA Data[Home] [Help]

APPS.OKE_DELIVERABLE_ACTIONS_PKG dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 774: DELETE FROM po_requisitions_interface_all

770: L_Description := substr(PA_DELIVERABLE_UTILS.Get_Dlv_Description ( p_action_ver_id => c2info.pa_action_id ), 1, 240);
771: END IF;
772:
773: IF c2info.reference1>0 THEN
774: DELETE FROM po_requisitions_interface_all
775: WHERE oke_contract_deliverable_id = c2info.action_id
776: AND batch_id = c2info.reference1;
777: END IF;
778:

Line 779: INSERT INTO po_requisitions_interface_all(

775: WHERE oke_contract_deliverable_id = c2info.action_id
776: AND batch_id = c2info.reference1;
777: END IF;
778:
779: INSERT INTO po_requisitions_interface_all(
780: last_updated_by,
781: last_update_login,
782: last_update_date,
783: creation_date,