DBA Data[Home] [Help]

APPS.POS_REVISION_DIFFERENCES dependencies on PO_HEADERS_ARCHIVE_ALL

Line 13: * PO_HEADERS_ARCHIVE_ALL table

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

Line 108: * PO_HEADERS_ARCHIVE_ALL table

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

Line 205: * PO_HEADERS_ARCHIVE_ALL table

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

Line 301: * PO_HEADERS_ARCHIVE_ALL table

297: * Call the procedure COMPARE_PO with the LASTSIGN as comparison flag.
298: *
299: * ARGUMENTS
300: * p_header_id Unique identified for the current PO in
301: * PO_HEADERS_ARCHIVE_ALL table
302: * p_release_id Unique identifier for the PO release in
303: * PO_RELEASES_ARCHIVE_ALL table
304: * p_revision_num Current PO revision number
305: * p_dummy_in4 Not required

Line 397: * PO_HEADERS_ARCHIVE_ALL table

393: * revision---including all lines, shipments, and distributions.
394: *
395: * ARGUMENTS
396: * p_header_id Unique identified for the current PO in
397: * PO_HEADERS_ARCHIVE_ALL table
398: * p_release_id Unique identifier for the PO release in
399: * PO_RELEASES_ARCHIVE_ALL table
400: * p_revision_num Current PO revision number
401: * p_comparison_flag Indicator to compare the PO with the previous

Line 559: * PO_HEADERS_ARCHIVE_ALL table

555: * previous revision (P_REVISION_NUM - 1 ).
556: *
557: * ARGUMENTS
558: * p_header_id Unique identified for the PO in
559: * PO_HEADERS_ARCHIVE_ALL table
560: * p_release_id Unique identifier for the PO release in
561: * PO_RELEASES_ARCHIVE_ALL table
562: * p_revision_num Current PO revision number
563: * p_comparison_flag Indicator to compare the PO with the previous

Line 584: v_header_from po_headers_archive_all%ROWTYPE;

580: p_sequence_num IN NUMBER,
581: p_comparison_flag_org IN VARCHAR2
582: ) AS
583:
584: v_header_from po_headers_archive_all%ROWTYPE;
585: v_header_to po_headers_archive_all%ROWTYPE;
586:
587: v_release_from po_releases_archive_all%ROWTYPE;
588: v_release_to po_releases_archive_all%ROWTYPE;

Line 585: v_header_to po_headers_archive_all%ROWTYPE;

581: p_comparison_flag_org IN VARCHAR2
582: ) AS
583:
584: v_header_from po_headers_archive_all%ROWTYPE;
585: v_header_to po_headers_archive_all%ROWTYPE;
586:
587: v_release_from po_releases_archive_all%ROWTYPE;
588: v_release_to po_releases_archive_all%ROWTYPE;
589:

Line 642: FROM po_headers_archive_all

638:
639: v_progress := '110';
640: SELECT *
641: INTO v_header_to
642: FROM po_headers_archive_all
643: WHERE
644: po_header_id = p_header_id
645: AND revision_num = p_revision_num;
646:

Line 658: FROM po_headers_archive_all

654:
655: v_progress := '120';
656: SELECT *
657: INTO v_header_from
658: FROM po_headers_archive_all
659: WHERE
660: po_header_id = p_header_id
661: AND revision_num = v_previous_revision_num;
662:

Line 742: * PO_HEADERS_ARCHIVE_ALL table

738: * PURPOSE
739: * Compare Global Agreement Org Assignments for a Global Agreement
740: * ARGUMENTS
741: * p_header_id Unique identified for the PO in
742: * PO_HEADERS_ARCHIVE_ALL table
743: * p_release_id Unique identifier for the PO release in
744: * PO_RELEASES_ARCHIVE_ALL table
745: * p_revision_num Current PO revision number
746: * p_comparison_flag Indicator to compare the PO with the previous

Line 864: * PO_HEADERS_ARCHIVE_ALL table

860: * previous revision (P_REVISION_NUM - 1 ).
861: *
862: * ARGUMENTS
863: * p_header_id Unique identified for the PO in
864: * PO_HEADERS_ARCHIVE_ALL table
865: * p_release_id Unique identifier for the PO release in
866: * PO_RELEASES_ARCHIVE_ALL table
867: * p_revision_num Current PO revision number
868: * p_comparison_flag Indicator to compare the PO with the previous

Line 1231: * PO_HEADERS_ARCHIVE_ALL table

1227: * previous revision (P_REVISION_NUM - 1 ).
1228: *
1229: * ARGUMENTS
1230: * p_header_id Unique identified for the PO in
1231: * PO_HEADERS_ARCHIVE_ALL table
1232: * p_release_id Unique identifier for the PO release in
1233: * PO_RELEASES_ARCHIVE_ALL table
1234: * p_revision_num Current PO revision number
1235: * p_comparison_flag Indicator to compare the PO with the previous

Line 1365: * PO_HEADERS_ARCHIVE_ALL table

1361: * 0), or the previous revision (P_REVISION_NUM - 1 ).
1362: *
1363: * ARGUMENTS
1364: * p_header_id Unique identified for the PO in
1365: * PO_HEADERS_ARCHIVE_ALL table
1366: * p_release_id Unique identifier for the PO release in
1367: * PO_RELEASES_ARCHIVE_ALL table
1368: * p_revision_num Current PO revision number
1369: * p_comparison_flag Indicator to compare the PO with the previous