eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_COMPARE_REVISIONS dependencies on PO_HEADERS_ARCHIVE_ALL

Line 1026: p_po_from in po_headers_archive_all%ROWTYPE,

1022: * 08-AUG-97 Nilo Paredes Created.
1023: * 22-SEP-97 Rami Haddad Added buyer comparison.
1024: ********************************************************************/
1025: PROCEDURE compare_headers(
1026: p_po_from in po_headers_archive_all%ROWTYPE,
1027: p_po_to in po_headers_archive_all%ROWTYPE,
1028: p_sequence in number,
1029: p_comparison_flag in varchar2
1030: ) AS

Line 1027: p_po_to in po_headers_archive_all%ROWTYPE,

1023: * 22-SEP-97 Rami Haddad Added buyer comparison.
1024: ********************************************************************/
1025: PROCEDURE compare_headers(
1026: p_po_from in po_headers_archive_all%ROWTYPE,
1027: p_po_to in po_headers_archive_all%ROWTYPE,
1028: p_sequence in number,
1029: p_comparison_flag in varchar2
1030: ) AS
1031:

Line 1038: c_po_num po_headers_archive_all.segment1%TYPE;

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;
1040: c_release_id NUMBER := NULL;
1041: c_line_id NUMBER := NULL;
1042: c_line_num NUMBER := NULL;

Line 1842: c_po_num po_headers_archive_all.segment1%TYPE;

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;
1844: c_revision_num NUMBER;
1845: c_line_id NUMBER := NULL;c_line_num NUMBER := NULL;
1846: c_location_id NUMBER := NULL;

Line 1854: v_po_num po_headers_archive_all.segment1%TYPE;

1850: c_item_id NUMBER := NULL;
1851: v_progress VARCHAR2(3);
1852: v_amount_from NUMBER;
1853: v_amount_to NUMBER;
1854: v_po_num po_headers_archive_all.segment1%TYPE;
1855:
1856: BEGIN
1857:
1858: /*

Line 1874: FROM po_headers_archive_all

1870: v_progress := '320';
1871:
1872: SELECT segment1
1873: INTO v_po_num
1874: FROM po_headers_archive_all
1875: WHERE
1876: po_header_id = p_release_to.po_header_id
1877: AND latest_external_flag = 'Y';
1878:

Line 2166: c_po_num po_headers_archive_all.segment1%TYPE;

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;
2169: c_line_id NUMBER := NULL;
2170: c_line_num NUMBER := NULL;

Line 2178: v_po_num po_headers_archive_all.segment1%TYPE;

2174: c_distribution_num NUMBER := NULL;
2175: c_item_id NUMBER := NULL;
2176: v_progress VARCHAR2(3);
2177:
2178: v_po_num po_headers_archive_all.segment1%TYPE;
2179: c_org_name hr_all_organization_units_tl.name%TYPE;
2180: c_entity_id NUMBER;
2181: c_entity_type po_price_differentials_archive.entity_type%TYPE;
2182: c_price_diff_num po_price_differentials_archive.price_differential_num%TYPE;

Line 2434: c_po_num po_headers_archive_all.segment1%TYPE;

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;
2436: c_revision_num NUMBER;
2437: c_line_id NUMBER := NULL;
2438: c_line_num NUMBER := NULL;

Line 2446: v_po_num po_headers_archive_all.segment1%TYPE;

2442: c_distribution_num NUMBER := NULL;
2443: c_item_id NUMBER := NULL;
2444: v_progress VARCHAR2(3);
2445:
2446: v_po_num po_headers_archive_all.segment1%TYPE;
2447: c_org_name hr_all_organization_units_tl.name%TYPE;
2448: c_enabled_org_id NUMBER;
2449:
2450: BEGIN

Line 2465: FROM po_headers_archive_all

2461:
2462:
2463: SELECT segment1
2464: INTO c_po_num
2465: FROM po_headers_archive_all
2466: WHERE
2467: po_header_id = p_ga_ass_to.po_header_id
2468: AND latest_external_flag = 'Y';
2469:

Line 2648: c_po_num po_headers_archive_all.segment1%TYPE;

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;
2649: c_line_id NUMBER;
2650: c_line_num NUMBER;
2651: c_revision_num NUMBER;
2652: c_location_id NUMBER := NULL;

Line 3876: c_po_num po_headers_archive_all.segment1%TYPE := NULL;

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;
3877: c_line_id NUMBER;
3878: c_line_num NUMBER := NULL;
3879: c_location_id NUMBER;
3880: c_location_num NUMBER;

Line 4690: c_po_num po_headers_archive_all.segment1%TYPE := NULL;

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;
4691: c_line_id NUMBER;
4692: c_line_num NUMBER := NULL;
4693: c_location_id NUMBER;
4694: c_location_num NUMBER := NULL;