1906: -- Archive attribute_values_tlp
1907: LOOP
1908: l_progress := '190';
1909:
1910: -- SQL What: Insert data into PO_ATTR_VALUES_TLP_ARCHIVE
1911: -- SQL Why : To archive Attr TLP values
1912: -- SQL Join: po_line_id
1913: FORALL i IN l_start_index .. l_end_index
1914: INSERT INTO PO_ATTR_VALUES_TLP_ARCHIVE
1910: -- SQL What: Insert data into PO_ATTR_VALUES_TLP_ARCHIVE
1911: -- SQL Why : To archive Attr TLP values
1912: -- SQL Join: po_line_id
1913: FORALL i IN l_start_index .. l_end_index
1914: INSERT INTO PO_ATTR_VALUES_TLP_ARCHIVE
1915: (
1916: attribute_values_tlp_id,
1917: revision_num,
1918: latest_external_flag,
2268: FROM PO_ATTRIBUTE_VALUES_TLP POTLP
2269: WHERE po_line_id = l_po_line_ids(i)
2270: AND NOT EXISTS
2271: (SELECT 'Archive record for TLP already exists'
2272: FROM PO_ATTR_VALUES_TLP_ARCHIVE POAVTA2
2273: WHERE POAVTA2.po_line_id = POTLP.po_line_id
2274: AND POAVTA2.language = POTLP.language);
2275:
2276: l_progress := '200';