DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_NOTIFICATION_CTRL_DRAFT

Line 189: --Deleting from po_notification_ctrl_draft

185:
186: DELETE FROM po_price_adj_attribs_draft
187: WHERE draft_id = p_draft_id;
188:
189: --Deleting from po_notification_ctrl_draft
190: DELETE FROM po_notification_ctrl_draft
191: WHERE draft_id = p_draft_id;
192:
193: -- Delete from po_exhibit_details_draft -Elins project

Line 190: DELETE FROM po_notification_ctrl_draft

186: DELETE FROM po_price_adj_attribs_draft
187: WHERE draft_id = p_draft_id;
188:
189: --Deleting from po_notification_ctrl_draft
190: DELETE FROM po_notification_ctrl_draft
191: WHERE draft_id = p_draft_id;
192:
193: -- Delete from po_exhibit_details_draft -Elins project
194: DELETE FROM po_exhibit_details_draft

Line 3741: -- po_notification_ctrl_draft

3737: --Start of Comments
3738: --Name: SYNC_NOTIFICATION_CONTROLS
3739: --Pre-reqs: None
3740: --Modifies:
3741: -- po_notification_ctrl_draft
3742: --Locks:
3743: -- None.
3744: --Function:
3745: -- Sync Notification Controls

Line 3780: INSERT INTO po_notification_ctrl_draft

3776: IF (PO_LOG.d_stmt) THEN
3777: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
3778: END IF;
3779:
3780: INSERT INTO po_notification_ctrl_draft
3781: (
3782: draft_id,
3783: delete_flag,
3784: change_accepted_flag,