9: * Call the procedure COMPARE_PO with ALL as comparison flag.
10: *
11: * ARGUMENTS
12: * p_header_id Unique identified for the current PO in
13: * PO_HEADERS_ARCHIVE_ALL table
14: * p_release_id Unique identifier for the PO release in
15: * PO_RELEASES_ARCHIVE_ALL table
16: * p_revision_num Current PO revision number
17: * p_dummy_in4 Not required
104: * Call the procedure COMPARE_PO with the ORIGINAL as comparison flag.
105: *
106: * ARGUMENTS
107: * p_header_id Unique identified for the current PO in
108: * PO_HEADERS_ARCHIVE_ALL table
109: * p_release_id Unique identifier for the PO release in
110: * PO_RELEASES_ARCHIVE_ALL table
111: * p_revision_num Current PO revision number
112: * p_dummy_in4 Not required
201: * Call the procedure COMPARE_PO with the PREVIOUS as comparison flag.
202: *
203: * ARGUMENTS
204: * p_header_id Unique identified for the current PO in
205: * PO_HEADERS_ARCHIVE_ALL table
206: * p_release_id Unique identifier for the PO release in
207: * PO_RELEASES_ARCHIVE_ALL table
208: * p_revision_num Current PO revision number
209: * p_dummy_in4 Not required
299: * revision---including all lines, shipments, and distributions.
300: *
301: * ARGUMENTS
302: * p_header_id Unique identified for the current PO in
303: * PO_HEADERS_ARCHIVE_ALL table
304: * p_release_id Unique identifier for the PO release in
305: * PO_RELEASES_ARCHIVE_ALL table
306: * p_revision_num Current PO revision number
307: * p_comparison_flag Indicator to compare the PO with the previous
419: * previous revision (P_REVISION_NUM - 1 ).
420: *
421: * ARGUMENTS
422: * p_header_id Unique identified for the PO in
423: * PO_HEADERS_ARCHIVE_ALL table
424: * p_release_id Unique identifier for the PO release in
425: * PO_RELEASES_ARCHIVE_ALL table
426: * p_revision_num Current PO revision number
427: * p_comparison_flag Indicator to compare the PO with the previous
443: p_comparison_flag IN VARCHAR2,
444: p_sequence_num IN NUMBER
445: ) AS
446:
447: v_header_from po_headers_archive%ROWTYPE;
448: v_header_to po_headers_archive%ROWTYPE;
449:
450: v_release_from po_releases_archive%ROWTYPE;
451: v_release_to po_releases_archive%ROWTYPE;
444: p_sequence_num IN NUMBER
445: ) AS
446:
447: v_header_from po_headers_archive%ROWTYPE;
448: v_header_to po_headers_archive%ROWTYPE;
449:
450: v_release_from po_releases_archive%ROWTYPE;
451: v_release_to po_releases_archive%ROWTYPE;
452:
476:
477: v_progress := '110';
478: SELECT *
479: INTO v_header_to
480: FROM po_headers_archive
481: WHERE
482: po_header_id = p_header_id
483: AND revision_num = p_revision_num;
484:
492:
493: v_progress := '120';
494: SELECT *
495: INTO v_header_from
496: FROM po_headers_archive
497: WHERE
498: po_header_id = p_header_id
499: AND revision_num = v_previous_revision_num;
500:
575: * previous revision (P_REVISION_NUM - 1 ).
576: *
577: * ARGUMENTS
578: * p_header_id Unique identified for the PO in
579: * PO_HEADERS_ARCHIVE_ALL table
580: * p_release_id Unique identifier for the PO release in
581: * PO_RELEASES_ARCHIVE_ALL table
582: * p_revision_num Current PO revision number
583: * p_comparison_flag Indicator to compare the PO with the previous
705: * previous revision (P_REVISION_NUM - 1 ).
706: *
707: * ARGUMENTS
708: * p_header_id Unique identified for the PO in
709: * PO_HEADERS_ARCHIVE_ALL table
710: * p_release_id Unique identifier for the PO release in
711: * PO_RELEASES_ARCHIVE_ALL table
712: * p_revision_num Current PO revision number
713: * p_comparison_flag Indicator to compare the PO with the previous
839: * 0), or the previous revision (P_REVISION_NUM - 1 ).
840: *
841: * ARGUMENTS
842: * p_header_id Unique identified for the PO in
843: * PO_HEADERS_ARCHIVE_ALL table
844: * p_release_id Unique identifier for the PO release in
845: * PO_RELEASES_ARCHIVE_ALL table
846: * p_revision_num Current PO revision number
847: * p_comparison_flag Indicator to compare the PO with the previous