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 1022: p_po_from in po_headers_archive_all%ROWTYPE,

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

Line 1023: p_po_to in po_headers_archive_all%ROWTYPE,

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

Line 1034: c_po_num po_headers_archive_all.segment1%TYPE;

1030: */
1031: c_level_altered pos_po_revisions_gt.level_altered%TYPE
1032: := 'ICX_HEADER';
1033: c_po_header_id NUMBER;
1034: c_po_num po_headers_archive_all.segment1%TYPE;
1035: c_revision_num NUMBER;
1036: c_release_id NUMBER := NULL;
1037: c_line_id NUMBER := NULL;
1038: c_line_num NUMBER := NULL;

Line 1838: c_po_num po_headers_archive_all.segment1%TYPE;

1834: */
1835: c_level_altered pos_po_revisions_gt.level_altered%TYPE
1836: := 'ICX_HEADER';
1837: c_po_header_id NUMBER;
1838: c_po_num po_headers_archive_all.segment1%TYPE;
1839: c_release_id NUMBER;
1840: c_revision_num NUMBER;
1841: c_line_id NUMBER := NULL;c_line_num NUMBER := NULL;
1842: c_location_id NUMBER := NULL;

Line 1850: v_po_num po_headers_archive_all.segment1%TYPE;

1846: c_item_id NUMBER := NULL;
1847: v_progress VARCHAR2(3);
1848: v_amount_from NUMBER;
1849: v_amount_to NUMBER;
1850: v_po_num po_headers_archive_all.segment1%TYPE;
1851:
1852: BEGIN
1853:
1854: /*

Line 1870: FROM po_headers_archive_all

1866: v_progress := '320';
1867:
1868: SELECT segment1
1869: INTO v_po_num
1870: FROM po_headers_archive_all
1871: WHERE
1872: po_header_id = p_release_to.po_header_id
1873: AND latest_external_flag = 'Y';
1874:

Line 2162: c_po_num po_headers_archive_all.segment1%TYPE;

2158: ) AS
2159:
2160: c_level_altered pos_po_revisions_gt.level_altered%TYPE := 'ICX_HEADER';
2161: c_po_header_id NUMBER;
2162: c_po_num po_headers_archive_all.segment1%TYPE;
2163: c_release_id NUMBER;
2164: c_revision_num NUMBER;
2165: c_line_id NUMBER := NULL;
2166: c_line_num NUMBER := NULL;

Line 2174: v_po_num po_headers_archive_all.segment1%TYPE;

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

Line 2430: c_po_num po_headers_archive_all.segment1%TYPE;

2426:
2427: c_level_altered pos_po_revisions_gt.level_altered%TYPE
2428: := 'ICX_HEADER';
2429: c_po_header_id NUMBER;
2430: c_po_num po_headers_archive_all.segment1%TYPE;
2431: c_release_id NUMBER;
2432: c_revision_num NUMBER;
2433: c_line_id NUMBER := NULL;
2434: c_line_num NUMBER := NULL;

Line 2442: v_po_num po_headers_archive_all.segment1%TYPE;

2438: c_distribution_num NUMBER := NULL;
2439: c_item_id NUMBER := NULL;
2440: v_progress VARCHAR2(3);
2441:
2442: v_po_num po_headers_archive_all.segment1%TYPE;
2443: c_org_name hr_all_organization_units_tl.name%TYPE;
2444: c_enabled_org_id NUMBER;
2445:
2446: BEGIN

Line 2461: FROM po_headers_archive_all

2457:
2458:
2459: SELECT segment1
2460: INTO c_po_num
2461: FROM po_headers_archive_all
2462: WHERE
2463: po_header_id = p_ga_ass_to.po_header_id
2464: AND latest_external_flag = 'Y';
2465:

Line 2644: c_po_num po_headers_archive_all.segment1%TYPE;

2640: c_level_altered pos_po_revisions_gt.level_altered%TYPE
2641: := 'ICX_LINE';
2642: c_po_header_id NUMBER;
2643: c_release_id NUMBER := NULL;
2644: c_po_num po_headers_archive_all.segment1%TYPE;
2645: c_line_id NUMBER;
2646: c_line_num NUMBER;
2647: c_revision_num NUMBER;
2648: c_location_id NUMBER := NULL;

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

3868: c_level_altered pos_po_revisions_gt.level_altered%TYPE
3869: := 'ICX_SHIPMENT';
3870: c_po_header_id NUMBER;
3871: c_release_id NUMBER;
3872: c_po_num po_headers_archive_all.segment1%TYPE := NULL;
3873: c_line_id NUMBER;
3874: c_line_num NUMBER := NULL;
3875: c_location_id NUMBER;
3876: c_location_num NUMBER;

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

4680: c_level_altered pos_po_revisions_gt.level_altered%TYPE
4681: := 'ICX_DISTRIBUTION';
4682: c_po_header_id NUMBER;
4683: c_release_id NUMBER;
4684: c_po_num po_headers_archive_all.segment1%TYPE := NULL;
4685: c_line_id NUMBER;
4686: c_line_num NUMBER := NULL;
4687: c_location_id NUMBER;
4688: c_location_num NUMBER := NULL;