APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on PO_ATTR_VALUES_ARCHIVE

Line 1207: -- SQL What: Insert data into PO_ATTR_VALUES_ARCHIVE

1203: -- Archive attribute_values
1204: LOOP
1205: l_progress := '140';
1206:
1207: -- SQL What: Insert data into PO_ATTR_VALUES_ARCHIVE
1208: -- SQL Why : To archive Attr values
1209: -- SQL Join: po_line_id
1210: FORALL i IN l_start_index .. l_end_index
1211: INSERT INTO PO_ATTR_VALUES_ARCHIVE

Line 1211: INSERT INTO PO_ATTR_VALUES_ARCHIVE

1207: -- SQL What: Insert data into PO_ATTR_VALUES_ARCHIVE
1208: -- SQL Why : To archive Attr values
1209: -- SQL Join: po_line_id
1210: FORALL i IN l_start_index .. l_end_index
1211: INSERT INTO PO_ATTR_VALUES_ARCHIVE
1212: (
1213: attribute_values_id,
1214: revision_num,
1215: po_line_id,

Line 1873: FROM PO_ATTR_VALUES_ARCHIVE POAVA2

1869: FROM PO_ATTRIBUTE_VALUES
1870: WHERE po_line_id = l_po_line_ids(i)
1871: AND NOT EXISTS
1872: (SELECT 'Archive record for Attr already exists'
1873: FROM PO_ATTR_VALUES_ARCHIVE POAVA2
1874: WHERE POAVA2.po_line_id = l_po_line_ids(i));
1875:
1876: l_progress := '150';
1877: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of attr archive records inserted='||SQL%rowcount); END IF;