APPS.PO_COMPARE_REVISIONS dependencies on PO_HEADERS

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

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

Line 432: v_po_num po_headers.segment1%TYPE;

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

Line 441: FROM po_headers

437: v_progress := '100';
438:
439: SELECT segment1
440: INTO v_po_num
441: FROM po_headers
442: WHERE po_header_id = p_header_id;
443:
444: RETURN v_po_num;
445:

Line 899: p_po_from in po_headers_archive%ROWTYPE,

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

Line 900: p_po_to in po_headers_archive%ROWTYPE,

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

Line 910: c_po_num po_headers_archive.segment1%TYPE;

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;
912: c_release_id NUMBER := NULL;
913: c_line_id NUMBER := NULL;
914: c_line_num NUMBER := NULL;

Line 1552: c_po_num po_headers_archive.segment1%TYPE;

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;
1554: c_revision_num NUMBER;
1555: c_line_id NUMBER := NULL;
1556: c_line_num NUMBER := NULL;

Line 1564: v_po_num po_headers_archive.segment1%TYPE;

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

Line 1584: FROM po_headers_archive

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

Line 1882: c_po_num po_headers_archive.segment1%TYPE;

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;
1883: c_line_id NUMBER;
1884: c_line_num NUMBER;
1885: c_revision_num NUMBER;
1886: c_location_id NUMBER := NULL;

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

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;
2583: c_line_id NUMBER;
2584: c_line_num NUMBER := NULL;
2585: c_location_id NUMBER;
2586: c_location_num NUMBER;

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

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;
2978: c_line_id NUMBER;
2979: c_line_num NUMBER := NULL;
2980: c_location_id NUMBER;
2981: c_location_num NUMBER := NULL;