DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on PO_HEADERS_ARCHIVE_ALL

Line 236: UPDATE PO_HEADERS_ARCHIVE_ALL

232: -- be only 1 revision = 0, for the newly created GBPA's)
233: -- SQL Why : PO Number on Archive table and Txn table should be same.
234: -- SQL Join: po_header_id, revision_num
235: FORALL i IN 1.. l_po_header_ids.COUNT
236: UPDATE PO_HEADERS_ARCHIVE_ALL
237: SET authorization_status = 'APPROVED',
238: approved_flag = 'Y',
239: approved_date = sysdate,
240: last_update_date = sysdate,

Line 246: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Number of rows of PO_HEADERS_ARCHIVE_ALL updated='||SQL%rowcount); END IF;

242: last_update_login = FND_GLOBAL.login_id
243: WHERE po_header_id = l_po_header_ids(i)
244: AND revision_num = 0;
245:
246: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_module,l_progress,'Number of rows of PO_HEADERS_ARCHIVE_ALL updated='||SQL%rowcount); END IF;
247:
248: l_progress := '110';
249: IF (l_po_header_ids.COUNT < p_batch_size) THEN
250: EXIT;

Line 485: INSERT INTO PO_HEADERS_ARCHIVE_ALL

481: -- SQL What: Insert into headers archive
482: -- SQL Why : To archive the headers of the new GBPA's
483: -- SQL Join: po_header_id
484: FORALL i IN 1.. p_po_header_ids.COUNT
485: INSERT INTO PO_HEADERS_ARCHIVE_ALL
486: (
487: acceptance_due_date,
488: acceptance_required_flag,
489: agent_id,

Line 809: FROM PO_HEADERS_ARCHIVE_ALL POHA2

805: FROM PO_HEADERS_ALL
806: WHERE po_header_id = p_po_header_ids(i)
807: AND NOT EXISTS
808: (SELECT 'Archive record for Header already exists'
809: FROM PO_HEADERS_ARCHIVE_ALL POHA2
810: WHERE POHA2.po_header_id = p_po_header_ids(i));
811:
812: l_progress := '020';
813: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of header archive records inserted='||SQL%rowcount); END IF;