APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on PO_LINES_ARCHIVE_ALL

Line 863: -- SQL What: Insert data into PO_LINES_ARCHIVE_ALL

859: -- Archive lines
860: LOOP
861: l_progress := '080';
862:
863: -- SQL What: Insert data into PO_LINES_ARCHIVE_ALL
864: -- SQL Why : To archive GBPA lines
865: -- SQL Join: po_line_id
866: FORALL i IN l_start_index .. l_end_index
867: INSERT INTO PO_LINES_ARCHIVE_ALL

Line 867: INSERT INTO PO_LINES_ARCHIVE_ALL

863: -- SQL What: Insert data into PO_LINES_ARCHIVE_ALL
864: -- SQL Why : To archive GBPA lines
865: -- SQL Join: po_line_id
866: FORALL i IN l_start_index .. l_end_index
867: INSERT INTO PO_LINES_ARCHIVE_ALL
868: (
869: allow_price_override_flag,
870: attribute1,
871: attribute10,

Line 1169: FROM PO_LINES_ARCHIVE_ALL POLA2

1165: FROM PO_LINES_ALL POL
1166: WHERE POL.po_line_id = l_po_line_ids(i)
1167: AND NOT EXISTS
1168: (SELECT 'Archive record for Line already exists'
1169: FROM PO_LINES_ARCHIVE_ALL POLA2
1170: WHERE POLA2.po_line_id = l_po_line_ids(i));
1171:
1172: l_progress := '090';
1173: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of line archive records inserted='||SQL%rowcount); END IF;