APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_ATTR_VALUES_TLP_ARCHIVE

Line 4693: -- PO_ATTR_VALUES_TLP_ARCHIVE

4689: --Name: archive_attr_values_tlp
4690: --Pre-reqs:
4691: -- None.
4692: --Modifies:
4693: -- PO_ATTR_VALUES_TLP_ARCHIVE
4694: --Locks:
4695: -- None.
4696: --Function:
4697: -- Archive Item Attribute Values TLP

Line 4740: INSERT INTO PO_ATTR_VALUES_TLP_ARCHIVE

4736: LOOP
4737: FETCH c INTO l_po_line_id;
4738: EXIT WHEN c%notfound;
4739:
4740: INSERT INTO PO_ATTR_VALUES_TLP_ARCHIVE
4741: (
4742: attribute_values_tlp_id,
4743: revision_num,
4744: latest_external_flag,

Line 5107: UPDATE PO_ATTR_VALUES_TLP_ARCHIVE PAVTA1

5103: LOOP
5104: FETCH c INTO l_po_line_id;
5105: EXIT WHEN c%notfound;
5106:
5107: UPDATE PO_ATTR_VALUES_TLP_ARCHIVE PAVTA1
5108: SET PAVTA1.latest_external_flag = 'N'
5109: WHERE PAVTA1.po_line_id = l_po_line_id
5110: AND PAVTA1.latest_external_flag = 'Y'
5111: AND PAVTA1.revision_num < p_revision_num

Line 5114: FROM PO_ATTR_VALUES_TLP_ARCHIVE PAVTA2

5110: AND PAVTA1.latest_external_flag = 'Y'
5111: AND PAVTA1.revision_num < p_revision_num
5112: AND EXISTS
5113: (SELECT 'A new archived row'
5114: FROM PO_ATTR_VALUES_TLP_ARCHIVE PAVTA2
5115: WHERE PAVTA2.po_line_id = PAVTA1.po_line_id
5116: AND PAVTA2.latest_external_flag = 'Y'
5117: AND PAVTA2.revision_num = p_revision_num);
5118: END LOOP;