APPS.PO_COMPARE_REVISIONS dependencies on ICX_PO_REVISIONS_TEMP

Line 9: * Delete records from the temp table, ICX_PO_REVISIONS_TEMP, where

5: * NAME
6: * purge
7: *
8: * PURPOSE
9: * Delete records from the temp table, ICX_PO_REVISIONS_TEMP, where
10: * all the records for differences are stored.
11: *
12: * ARGUMENTS
13: * p_date Purges all records that are older than this date. The

Line 38: DELETE icx_po_revisions_temp

34: errbuf := '';
35:
36: v_progress := '010';
37:
38: DELETE icx_po_revisions_temp
39: WHERE creation_date < NVL( to_date(p_date, 'YYYY/MM/DD HH24:MI:SS'),SYSDATE - 1/12 );
40:
41: COMMIT;
42:

Line 730: icx_po_revisions_temp(

726:
727: v_progress := '900';
728:
729: INSERT INTO
730: icx_po_revisions_temp(
731: line_seq,
732: creation_date,
733: header_id,
734: release_id,

Line 789: * Insert a line in the ICX_PO_REVISIONS_TEMP table indicating that

785: * NAME
786: * verify_no_differences
787: *
788: * PURPOSE
789: * Insert a line in the ICX_PO_REVISIONS_TEMP table indicating that
790: * there are no differences between the compared records.
791: *
792: * ARGUMENTS
793: * p_line_seq Sequence number to identify the comparison

Line 819: FROM icx_po_revisions_temp

815: v_progress := '130';
816:
817: SELECT COUNT(*)
818: INTO records_exist
819: FROM icx_po_revisions_temp
820: WHERE line_seq = p_line_seq;
821:
822: IF records_exist = 0 THEN
823: insert_changes(

Line 910: c_level_altered icx_po_revisions_temp.level_altered%TYPE

906:
907: /*
908: * Constant variables to pass for insert_changes
909: */
910: c_level_altered icx_po_revisions_temp.level_altered%TYPE
911: := 'ICX_HEADER';
912: c_po_header_id NUMBER;
913: c_po_num po_headers_archive.segment1%TYPE;
914: c_revision_num NUMBER;

Line 1552: c_level_altered icx_po_revisions_temp.level_altered%TYPE

1548:
1549: /*
1550: * Constant variables to pass for insert_changes
1551: */
1552: c_level_altered icx_po_revisions_temp.level_altered%TYPE
1553: := 'ICX_HEADER';
1554: c_po_header_id NUMBER;
1555: c_po_num po_headers_archive.segment1%TYPE;
1556: c_release_id NUMBER;

Line 1881: c_level_altered icx_po_revisions_temp.level_altered%TYPE

1877:
1878: /*
1879: * Constant variables to pass for insert_changes
1880: */
1881: c_level_altered icx_po_revisions_temp.level_altered%TYPE
1882: := 'ICX_LINE';
1883: c_po_header_id NUMBER;
1884: c_release_id NUMBER := NULL;
1885: c_po_num po_headers_archive.segment1%TYPE;

Line 2581: c_level_altered icx_po_revisions_temp.level_altered%TYPE

2577: p_sequence IN NUMBER
2578: ) AS
2579:
2580: /* Constant variables to pass for insert_changes */
2581: c_level_altered icx_po_revisions_temp.level_altered%TYPE
2582: := 'ICX_SHIPMENT';
2583: c_po_header_id NUMBER;
2584: c_release_id NUMBER;
2585: c_po_num po_headers_archive.segment1%TYPE := NULL;

Line 2976: c_level_altered icx_po_revisions_temp.level_altered%TYPE

2972:
2973: /*
2974: * Constant variables to pass for insert_changes
2975: */
2976: c_level_altered icx_po_revisions_temp.level_altered%TYPE
2977: := 'ICX_DISTRIBUTION';
2978: c_po_header_id NUMBER;
2979: c_release_id NUMBER;
2980: c_po_num po_headers_archive.segment1%TYPE := NULL;