APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_DRAFTS

Line 59: PO_DRAFTS PD

55: -- SQL What: Select record from Draft which has been copied from Archive
56: -- SQL Why : Check if the document has already been synced from archive to Draft
57: SELECT 'Y' INTO x_return_status
58: FROM PO_HEADERS_ARCHIVE_ALL PHA,
59: PO_DRAFTS PD
60: WHERE pha.po_header_id = p_document_id
61: AND pha.revision_num = p_revision_num
62: AND pd.document_id = pha.po_header_id (+)
63: AND pd.draft_id = p_draft_id; --Always passed as 0 for Revision 0 Documents

Line 94: -- PO_DRAFTS

90: --Name: DELETE_DUMMY_DATA_FROM_DRAFT
91: --Pre-reqs:
92: -- None.
93: --Modifies:
94: -- PO_DRAFTS
95: --Locks:
96: -- None.
97: --Function:
98: -- Deletes the Data from Draft Tables for the given Documnt ID, and Draft Id = 0

Line 128: --Deleting from po_drafts

124: IF (PO_LOG.d_proc) THEN
125: PO_LOG.proc_begin(d_module,'Delete all entries from DRAFT Tables having draft_id: ',p_draft_id);
126: END IF;
127:
128: --Deleting from po_drafts
129: DELETE FROM po_drafts
130: WHERE draft_id = p_draft_id;
131:
132: --Start Deleting Headers/Lines/Shipments/Distributions

Line 129: DELETE FROM po_drafts

125: PO_LOG.proc_begin(d_module,'Delete all entries from DRAFT Tables having draft_id: ',p_draft_id);
126: END IF;
127:
128: --Deleting from po_drafts
129: DELETE FROM po_drafts
130: WHERE draft_id = p_draft_id;
131:
132: --Start Deleting Headers/Lines/Shipments/Distributions
133: DELETE FROM po_headers_draft_all

Line 222: -- PO_DRAFTS

218: --Name: CREATE_DUMMY_ROW_IN_DRAFT
219: --Pre-reqs:
220: -- None.
221: --Modifies:
222: -- PO_DRAFTS
223: --Locks:
224: -- None.
225: --Function:
226: -- Creates a dummy row in PO_DRAFTS with the given draft_id (0 in case of View Base Document)

Line 226: -- Creates a dummy row in PO_DRAFTS with the given draft_id (0 in case of View Base Document)

222: -- PO_DRAFTS
223: --Locks:
224: -- None.
225: --Function:
226: -- Creates a dummy row in PO_DRAFTS with the given draft_id (0 in case of View Base Document)
227: --Parameters:
228: --IN:
229: --p_document_id
230: -- The id of the document for which the 'View Base Document' action is being handled

Line 257: PO_LOG.stmt(d_module, d_position, 'Insert Dummy row in PO_DRAFTS with DRAFT_ID = 0');

253: END IF;
254:
255: d_position := 10;
256: IF (PO_LOG.d_stmt) THEN
257: PO_LOG.stmt(d_module, d_position, 'Insert Dummy row in PO_DRAFTS with DRAFT_ID = 0');
258: END IF;
259:
260: INSERT INTO po_drafts
261: (draft_id,

Line 260: INSERT INTO po_drafts

256: IF (PO_LOG.d_stmt) THEN
257: PO_LOG.stmt(d_module, d_position, 'Insert Dummy row in PO_DRAFTS with DRAFT_ID = 0');
258: END IF;
259:
260: INSERT INTO po_drafts
261: (draft_id,
262: document_id,
263: owner_user_id,
264: owner_role,

Line 289: PO_LOG.stmt(d_module, d_position, 'Row inserted into PO_DRAFTS');

285: );
286:
287: d_position := 20;
288: IF (PO_LOG.d_stmt) THEN
289: PO_LOG.stmt(d_module, d_position, 'Row inserted into PO_DRAFTS');
290: END IF;
291:
292: d_position := 30;
293: IF (PO_LOG.d_proc) THEN