APPS.POS_COMPARE_REVISIONS dependencies on POS_PO_REVISIONS_GT

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

5: * NAME
6: * purge
7: *
8: * PURPOSE
9: * Delete records from the temp table, POS_PO_REVISIONS_GT, 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 pos_po_revisions_gt

34: errbuf := '';
35:
36: v_progress := '010';
37:
38: DELETE pos_po_revisions_gt
39: WHERE creation_date < NVL( p_date, SYSDATE - 1/12 );
40:
41: COMMIT;
42:

Line 840: pos_po_revisions_gt(

836:
837: v_progress := '900';
838:
839: INSERT INTO
840: pos_po_revisions_gt(
841: line_seq,
842: creation_date,
843: header_id,
844: release_id,

Line 911: * Insert a line in the POS_PO_REVISIONS_GT table indicating that

907: * NAME
908: * verify_no_differences
909: *
910: * PURPOSE
911: * Insert a line in the POS_PO_REVISIONS_GT table indicating that
912: * there are no differences between the compared records.
913: *
914: * ARGUMENTS
915: * p_line_seq Sequence number to identify the comparison

Line 941: FROM pos_po_revisions_gt

937: v_progress := '130';
938:
939: SELECT COUNT(*)
940: INTO records_exist
941: FROM pos_po_revisions_gt
942: WHERE line_seq = p_line_seq;
943:
944: IF records_exist = 0 THEN
945: insert_changes(

Line 1035: c_level_altered pos_po_revisions_gt.level_altered%TYPE

1031:
1032: /*
1033: * Constant variables to pass for insert_changes
1034: */
1035: c_level_altered pos_po_revisions_gt.level_altered%TYPE
1036: := 'ICX_HEADER';
1037: c_po_header_id NUMBER;
1038: c_po_num po_headers_archive_all.segment1%TYPE;
1039: c_revision_num NUMBER;

Line 1839: c_level_altered pos_po_revisions_gt.level_altered%TYPE

1835:
1836: /*
1837: * Constant variables to pass for insert_changes
1838: */
1839: c_level_altered pos_po_revisions_gt.level_altered%TYPE
1840: := 'ICX_HEADER';
1841: c_po_header_id NUMBER;
1842: c_po_num po_headers_archive_all.segment1%TYPE;
1843: c_release_id NUMBER;

Line 2164: c_level_altered pos_po_revisions_gt.level_altered%TYPE := 'ICX_HEADER';

2160: p_pdiffs_to in po_price_differentials_archive%ROWTYPE,
2161: p_sequence IN NUMBER
2162: ) AS
2163:
2164: c_level_altered pos_po_revisions_gt.level_altered%TYPE := 'ICX_HEADER';
2165: c_po_header_id NUMBER;
2166: c_po_num po_headers_archive_all.segment1%TYPE;
2167: c_release_id NUMBER;
2168: c_revision_num NUMBER;

Line 2431: c_level_altered pos_po_revisions_gt.level_altered%TYPE

2427: p_ga_ass_to in po_ga_org_assignments_archive%ROWTYPE,
2428: p_sequence IN NUMBER
2429: ) AS
2430:
2431: c_level_altered pos_po_revisions_gt.level_altered%TYPE
2432: := 'ICX_HEADER';
2433: c_po_header_id NUMBER;
2434: c_po_num po_headers_archive_all.segment1%TYPE;
2435: c_release_id NUMBER;

Line 2644: c_level_altered pos_po_revisions_gt.level_altered%TYPE

2640:
2641: /*
2642: * Constant variables to pass for insert_changes
2643: */
2644: c_level_altered pos_po_revisions_gt.level_altered%TYPE
2645: := 'ICX_LINE';
2646: c_po_header_id NUMBER;
2647: c_release_id NUMBER := NULL;
2648: c_po_num po_headers_archive_all.segment1%TYPE;

Line 3872: c_level_altered pos_po_revisions_gt.level_altered%TYPE

3868: p_sequence IN NUMBER
3869: ) AS
3870:
3871: /* Constant variables to pass for insert_changes */
3872: c_level_altered pos_po_revisions_gt.level_altered%TYPE
3873: := 'ICX_SHIPMENT';
3874: c_po_header_id NUMBER;
3875: c_release_id NUMBER;
3876: c_po_num po_headers_archive_all.segment1%TYPE := NULL;

Line 4686: c_level_altered pos_po_revisions_gt.level_altered%TYPE

4682:
4683: /*
4684: * Constant variables to pass for insert_changes
4685: */
4686: c_level_altered pos_po_revisions_gt.level_altered%TYPE
4687: := 'ICX_DISTRIBUTION';
4688: c_po_header_id NUMBER;
4689: c_release_id NUMBER;
4690: c_po_num po_headers_archive_all.segment1%TYPE := NULL;