APPS.PO_COMPARE_REVISIONS dependencies on PO_HEADERS

Line 424: * p_header_id Unique identifier for PO in PO_HEADERS table.

420: * PURPOSE
421: * Resolves the source quotation PO number.
422: *
423: * ARGUMENTS
424: * p_header_id Unique identifier for PO in PO_HEADERS table.
425: *
426: * NOTES
427: * Return NULL if no matching records were found.
428: *

Line 435: v_po_num po_headers.segment1%TYPE;

431: ********************************************************************/
432: FUNCTION get_source_quotation_header( p_header_id in number )
433: RETURN VARCHAR2 AS
434:
435: v_po_num po_headers.segment1%TYPE;
436: v_progress varchar2(3);
437:
438: BEGIN
439:

Line 444: FROM po_headers

440: v_progress := '100';
441:
442: SELECT segment1
443: INTO v_po_num
444: FROM po_headers
445: WHERE po_header_id = p_header_id;
446:
447: RETURN v_po_num;
448:

Line 902: p_po_from in po_headers_archive%ROWTYPE,

898: * 08-AUG-97 Nilo Paredes Created.
899: * 22-SEP-97 Rami Haddad Added buyer comparison.
900: ********************************************************************/
901: PROCEDURE compare_headers(
902: p_po_from in po_headers_archive%ROWTYPE,
903: p_po_to in po_headers_archive%ROWTYPE,
904: p_sequence in number
905: ) AS
906:

Line 903: p_po_to in po_headers_archive%ROWTYPE,

899: * 22-SEP-97 Rami Haddad Added buyer comparison.
900: ********************************************************************/
901: PROCEDURE compare_headers(
902: p_po_from in po_headers_archive%ROWTYPE,
903: p_po_to in po_headers_archive%ROWTYPE,
904: p_sequence in number
905: ) AS
906:
907: /*

Line 913: c_po_num po_headers_archive.segment1%TYPE;

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;
915: c_release_id NUMBER := NULL;
916: c_line_id NUMBER := NULL;
917: c_line_num NUMBER := NULL;

Line 1555: c_po_num po_headers_archive.segment1%TYPE;

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;
1557: c_revision_num NUMBER;
1558: c_line_id NUMBER := NULL;
1559: c_line_num NUMBER := NULL;

Line 1567: v_po_num po_headers_archive.segment1%TYPE;

1563: c_distribution_num NUMBER := NULL;
1564: c_item_id NUMBER := NULL;
1565: v_progress VARCHAR2(3);
1566:
1567: v_po_num po_headers_archive.segment1%TYPE;
1568:
1569: BEGIN
1570:
1571: /*

Line 1587: FROM po_headers_archive

1583: v_progress := '320';
1584:
1585: SELECT segment1
1586: INTO v_po_num
1587: FROM po_headers_archive
1588: WHERE
1589: po_header_id = p_release_to.po_header_id
1590: AND latest_external_flag = 'Y';
1591:

Line 1885: c_po_num po_headers_archive.segment1%TYPE;

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;
1886: c_line_id NUMBER;
1887: c_line_num NUMBER;
1888: c_revision_num NUMBER;
1889: c_location_id NUMBER := NULL;

Line 2585: c_po_num po_headers_archive.segment1%TYPE := NULL;

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;
2586: c_line_id NUMBER;
2587: c_line_num NUMBER := NULL;
2588: c_location_id NUMBER;
2589: c_location_num NUMBER;

Line 2980: c_po_num po_headers_archive.segment1%TYPE := NULL;

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;
2981: c_line_id NUMBER;
2982: c_line_num NUMBER := NULL;
2983: c_location_id NUMBER;
2984: c_location_num NUMBER := NULL;