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 727: icx_po_revisions_temp(

723:
724: v_progress := '900';
725:
726: INSERT INTO
727: icx_po_revisions_temp(
728: line_seq,
729: creation_date,
730: header_id,
731: release_id,

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

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

Line 816: FROM icx_po_revisions_temp

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

Line 907: c_level_altered icx_po_revisions_temp.level_altered%TYPE

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

Line 1549: c_level_altered icx_po_revisions_temp.level_altered%TYPE

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

Line 1878: c_level_altered icx_po_revisions_temp.level_altered%TYPE

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

Line 2578: c_level_altered icx_po_revisions_temp.level_altered%TYPE

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

Line 2973: c_level_altered icx_po_revisions_temp.level_altered%TYPE

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