APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_ATTR_VALUES_ARCHIVE

Line 3944: -- PO_ATTR_VALUES_ARCHIVE

3940: --Name: archive_attribute_values
3941: --Pre-reqs:
3942: -- None.
3943: --Modifies:
3944: -- PO_ATTR_VALUES_ARCHIVE
3945: --Locks:
3946: -- None.
3947: --Function:
3948: -- Archive Item Attribute Values

Line 3991: INSERT INTO PO_ATTR_VALUES_ARCHIVE

3987: LOOP
3988: FETCH c INTO l_po_line_id;
3989: EXIT WHEN c%notfound;
3990:
3991: INSERT INTO PO_ATTR_VALUES_ARCHIVE
3992: (
3993: attribute_values_id,
3994: revision_num,
3995: po_line_id,

Line 4664: UPDATE PO_ATTR_VALUES_ARCHIVE PAVA1

4660: LOOP
4661: FETCH c INTO l_po_line_id;
4662: EXIT WHEN c%notfound;
4663:
4664: UPDATE PO_ATTR_VALUES_ARCHIVE PAVA1
4665: SET PAVA1.latest_external_flag = 'N'
4666: WHERE PAVA1.po_line_id = l_po_line_id
4667: AND PAVA1.latest_external_flag = 'Y'
4668: AND PAVA1.revision_num < p_revision_num

Line 4671: FROM PO_ATTR_VALUES_ARCHIVE PAVA2

4667: AND PAVA1.latest_external_flag = 'Y'
4668: AND PAVA1.revision_num < p_revision_num
4669: AND EXISTS
4670: (SELECT 'A new archived row'
4671: FROM PO_ATTR_VALUES_ARCHIVE PAVA2
4672: WHERE PAVA2.po_line_id = PAVA1.po_line_id
4673: AND PAVA2.latest_external_flag = 'Y'
4674: AND PAVA2.revision_num = p_revision_num);
4675: END LOOP;