APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_HEADERS_ARCHIVE_ALL

Line 129: PO_HEADERS_ARCHIVE_ALL PHA

125: SELECT NVL(ph.revision_num, 0),
126: NVL(pha.revision_num, -1)
127: INTO x_revision_num, l_arch_revision_num
128: FROM PO_HEADERS_ALL PH,
129: PO_HEADERS_ARCHIVE_ALL PHA
130: WHERE ph.po_header_id = p_document_id
131: AND ph.approved_date IS NOT NULL
132: AND ph.approved_flag = 'Y'
133: AND ph.po_header_id = pha.po_header_id (+)

Line 280: UPDATE PO_HEADERS_ARCHIVE_ALL

276: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
277: 'Update PO_HEADERS_ARCHIVE to reset latest_external_flag');
278: END IF;
279:
280: UPDATE PO_HEADERS_ARCHIVE_ALL
281: SET latest_external_flag = 'N'
282: WHERE po_header_id = p_document_id
283: AND latest_external_flag = 'Y';
284:

Line 292: INSERT INTO PO_HEADERS_ARCHIVE_ALL

288: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
289: 'Insert PO_HEADERS_ARCHIVE ');
290: END IF;
291:
292: INSERT INTO PO_HEADERS_ARCHIVE_ALL
293: (acceptance_due_date ,
294: acceptance_required_flag ,
295: agent_id ,
296: amount_limit ,

Line 7071: -- HeaderId = DraftId generated and stored in PO_HEADERS_ARCHIVE_ALL

7067: -- None.
7068: --Function:
7069: -- In order to view contract terms while handling View Base Document,
7070: -- Contract Terms on the Base Document are duplicated with a new
7071: -- HeaderId = DraftId generated and stored in PO_HEADERS_ARCHIVE_ALL
7072: -- This DRAFT_ID uniquely identifies the 0th revision of the PO for Contracts
7073: --Parameters:
7074: --IN:
7075: --p_po_header_id

Line 7101: l_draft_id PO_HEADERS_ARCHIVE_ALL.DRAFT_ID%TYPE;

7097: d_mod CONSTANT VARCHAR2(100) := 'sync_contract_terms_to_draft';
7098: l_progress VARCHAR2(4) := '000';
7099:
7100: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
7101: l_draft_id PO_HEADERS_ARCHIVE_ALL.DRAFT_ID%TYPE;
7102: l_return_status VARCHAR2(1);
7103:
7104:
7105: BEGIN

Line 7129: 'ConTerms Exist. Generate and store a new Draft Id in PO_HEADERS_ARCHIVE_ALL');

7125: IF (l_conterms_exist_flag = 'Y') THEN
7126: l_progress := '020';
7127: IF PO_LOG.d_stmt THEN
7128: PO_LOG.stmt(d_mod,l_progress,
7129: 'ConTerms Exist. Generate and store a new Draft Id in PO_HEADERS_ARCHIVE_ALL');
7130: END IF;
7131:
7132: --Generate new Draft Id and store in PO_HEADERS_ARCHIVE_ALL
7133: --This is generated to uniquely identify the 0th revision of the PO for Contracts

Line 7132: --Generate new Draft Id and store in PO_HEADERS_ARCHIVE_ALL

7128: PO_LOG.stmt(d_mod,l_progress,
7129: 'ConTerms Exist. Generate and store a new Draft Id in PO_HEADERS_ARCHIVE_ALL');
7130: END IF;
7131:
7132: --Generate new Draft Id and store in PO_HEADERS_ARCHIVE_ALL
7133: --This is generated to uniquely identify the 0th revision of the PO for Contracts
7134: l_draft_id := PO_DRAFTS_PVT.draft_id_nextval;
7135:
7136: --Update PO_HEADERS_ARCHIVE_ALL with this DRAFT_ID

Line 7136: --Update PO_HEADERS_ARCHIVE_ALL with this DRAFT_ID

7132: --Generate new Draft Id and store in PO_HEADERS_ARCHIVE_ALL
7133: --This is generated to uniquely identify the 0th revision of the PO for Contracts
7134: l_draft_id := PO_DRAFTS_PVT.draft_id_nextval;
7135:
7136: --Update PO_HEADERS_ARCHIVE_ALL with this DRAFT_ID
7137: UPDATE PO_HEADERS_ARCHIVE_ALL
7138: SET draft_id = l_draft_id
7139: WHERE po_header_id = p_po_header_id
7140: AND revision_num = p_revision_num;

Line 7137: UPDATE PO_HEADERS_ARCHIVE_ALL

7133: --This is generated to uniquely identify the 0th revision of the PO for Contracts
7134: l_draft_id := PO_DRAFTS_PVT.draft_id_nextval;
7135:
7136: --Update PO_HEADERS_ARCHIVE_ALL with this DRAFT_ID
7137: UPDATE PO_HEADERS_ARCHIVE_ALL
7138: SET draft_id = l_draft_id
7139: WHERE po_header_id = p_po_header_id
7140: AND revision_num = p_revision_num;
7141: