3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_RCO_VALIDATION_PVT';
5: g_file_name CONSTANT VARCHAR2(30) := 'POXVRCVS.pls';
6:
7: TYPE change_rec_type IS RECORD(action_type po_change_requests.action_type%TYPE,
8: initiator po_change_requests.initiator%TYPE,
9: request_reason po_change_requests.request_reason%TYPE,
10: document_type po_change_requests.document_type%TYPE,
11: request_level po_change_requests.request_level%TYPE,
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_RCO_VALIDATION_PVT';
5: g_file_name CONSTANT VARCHAR2(30) := 'POXVRCVS.pls';
6:
7: TYPE change_rec_type IS RECORD(action_type po_change_requests.action_type%TYPE,
8: initiator po_change_requests.initiator%TYPE,
9: request_reason po_change_requests.request_reason%TYPE,
10: document_type po_change_requests.document_type%TYPE,
11: request_level po_change_requests.request_level%TYPE,
12: request_status po_change_requests.request_status%TYPE,
5: g_file_name CONSTANT VARCHAR2(30) := 'POXVRCVS.pls';
6:
7: TYPE change_rec_type IS RECORD(action_type po_change_requests.action_type%TYPE,
8: initiator po_change_requests.initiator%TYPE,
9: request_reason po_change_requests.request_reason%TYPE,
10: document_type po_change_requests.document_type%TYPE,
11: request_level po_change_requests.request_level%TYPE,
12: request_status po_change_requests.request_status%TYPE,
13: document_header_id po_change_requests.document_header_id%TYPE,
6:
7: TYPE change_rec_type IS RECORD(action_type po_change_requests.action_type%TYPE,
8: initiator po_change_requests.initiator%TYPE,
9: request_reason po_change_requests.request_reason%TYPE,
10: document_type po_change_requests.document_type%TYPE,
11: request_level po_change_requests.request_level%TYPE,
12: request_status po_change_requests.request_status%TYPE,
13: document_header_id po_change_requests.document_header_id%TYPE,
14: po_release_id po_change_requests.po_release_id%TYPE,
7: TYPE change_rec_type IS RECORD(action_type po_change_requests.action_type%TYPE,
8: initiator po_change_requests.initiator%TYPE,
9: request_reason po_change_requests.request_reason%TYPE,
10: document_type po_change_requests.document_type%TYPE,
11: request_level po_change_requests.request_level%TYPE,
12: request_status po_change_requests.request_status%TYPE,
13: document_header_id po_change_requests.document_header_id%TYPE,
14: po_release_id po_change_requests.po_release_id%TYPE,
15: document_num po_change_requests.document_num%TYPE,
8: initiator po_change_requests.initiator%TYPE,
9: request_reason po_change_requests.request_reason%TYPE,
10: document_type po_change_requests.document_type%TYPE,
11: request_level po_change_requests.request_level%TYPE,
12: request_status po_change_requests.request_status%TYPE,
13: document_header_id po_change_requests.document_header_id%TYPE,
14: po_release_id po_change_requests.po_release_id%TYPE,
15: document_num po_change_requests.document_num%TYPE,
16: document_revision_num po_change_requests.document_revision_num%TYPE,
9: request_reason po_change_requests.request_reason%TYPE,
10: document_type po_change_requests.document_type%TYPE,
11: request_level po_change_requests.request_level%TYPE,
12: request_status po_change_requests.request_status%TYPE,
13: document_header_id po_change_requests.document_header_id%TYPE,
14: po_release_id po_change_requests.po_release_id%TYPE,
15: document_num po_change_requests.document_num%TYPE,
16: document_revision_num po_change_requests.document_revision_num%TYPE,
17: document_line_id po_change_requests.document_line_id%TYPE,
10: document_type po_change_requests.document_type%TYPE,
11: request_level po_change_requests.request_level%TYPE,
12: request_status po_change_requests.request_status%TYPE,
13: document_header_id po_change_requests.document_header_id%TYPE,
14: po_release_id po_change_requests.po_release_id%TYPE,
15: document_num po_change_requests.document_num%TYPE,
16: document_revision_num po_change_requests.document_revision_num%TYPE,
17: document_line_id po_change_requests.document_line_id%TYPE,
18: document_line_number po_change_requests.document_line_number%TYPE,
11: request_level po_change_requests.request_level%TYPE,
12: request_status po_change_requests.request_status%TYPE,
13: document_header_id po_change_requests.document_header_id%TYPE,
14: po_release_id po_change_requests.po_release_id%TYPE,
15: document_num po_change_requests.document_num%TYPE,
16: document_revision_num po_change_requests.document_revision_num%TYPE,
17: document_line_id po_change_requests.document_line_id%TYPE,
18: document_line_number po_change_requests.document_line_number%TYPE,
19: document_line_location_id po_change_requests.document_line_location_id%TYPE,
12: request_status po_change_requests.request_status%TYPE,
13: document_header_id po_change_requests.document_header_id%TYPE,
14: po_release_id po_change_requests.po_release_id%TYPE,
15: document_num po_change_requests.document_num%TYPE,
16: document_revision_num po_change_requests.document_revision_num%TYPE,
17: document_line_id po_change_requests.document_line_id%TYPE,
18: document_line_number po_change_requests.document_line_number%TYPE,
19: document_line_location_id po_change_requests.document_line_location_id%TYPE,
20: document_shipment_number po_change_requests.document_shipment_number%TYPE,
13: document_header_id po_change_requests.document_header_id%TYPE,
14: po_release_id po_change_requests.po_release_id%TYPE,
15: document_num po_change_requests.document_num%TYPE,
16: document_revision_num po_change_requests.document_revision_num%TYPE,
17: document_line_id po_change_requests.document_line_id%TYPE,
18: document_line_number po_change_requests.document_line_number%TYPE,
19: document_line_location_id po_change_requests.document_line_location_id%TYPE,
20: document_shipment_number po_change_requests.document_shipment_number%TYPE,
21: document_distribution_id po_change_requests.document_distribution_id%TYPE,
14: po_release_id po_change_requests.po_release_id%TYPE,
15: document_num po_change_requests.document_num%TYPE,
16: document_revision_num po_change_requests.document_revision_num%TYPE,
17: document_line_id po_change_requests.document_line_id%TYPE,
18: document_line_number po_change_requests.document_line_number%TYPE,
19: document_line_location_id po_change_requests.document_line_location_id%TYPE,
20: document_shipment_number po_change_requests.document_shipment_number%TYPE,
21: document_distribution_id po_change_requests.document_distribution_id%TYPE,
22: document_distribution_number po_change_requests.document_distribution_number%TYPE,
15: document_num po_change_requests.document_num%TYPE,
16: document_revision_num po_change_requests.document_revision_num%TYPE,
17: document_line_id po_change_requests.document_line_id%TYPE,
18: document_line_number po_change_requests.document_line_number%TYPE,
19: document_line_location_id po_change_requests.document_line_location_id%TYPE,
20: document_shipment_number po_change_requests.document_shipment_number%TYPE,
21: document_distribution_id po_change_requests.document_distribution_id%TYPE,
22: document_distribution_number po_change_requests.document_distribution_number%TYPE,
23: parent_line_location_id po_change_requests.parent_line_location_id%TYPE,
16: document_revision_num po_change_requests.document_revision_num%TYPE,
17: document_line_id po_change_requests.document_line_id%TYPE,
18: document_line_number po_change_requests.document_line_number%TYPE,
19: document_line_location_id po_change_requests.document_line_location_id%TYPE,
20: document_shipment_number po_change_requests.document_shipment_number%TYPE,
21: document_distribution_id po_change_requests.document_distribution_id%TYPE,
22: document_distribution_number po_change_requests.document_distribution_number%TYPE,
23: parent_line_location_id po_change_requests.parent_line_location_id%TYPE,
24: old_quantity po_change_requests.old_quantity%TYPE,
17: document_line_id po_change_requests.document_line_id%TYPE,
18: document_line_number po_change_requests.document_line_number%TYPE,
19: document_line_location_id po_change_requests.document_line_location_id%TYPE,
20: document_shipment_number po_change_requests.document_shipment_number%TYPE,
21: document_distribution_id po_change_requests.document_distribution_id%TYPE,
22: document_distribution_number po_change_requests.document_distribution_number%TYPE,
23: parent_line_location_id po_change_requests.parent_line_location_id%TYPE,
24: old_quantity po_change_requests.old_quantity%TYPE,
25: new_quantity po_change_requests.new_quantity%TYPE,
18: document_line_number po_change_requests.document_line_number%TYPE,
19: document_line_location_id po_change_requests.document_line_location_id%TYPE,
20: document_shipment_number po_change_requests.document_shipment_number%TYPE,
21: document_distribution_id po_change_requests.document_distribution_id%TYPE,
22: document_distribution_number po_change_requests.document_distribution_number%TYPE,
23: parent_line_location_id po_change_requests.parent_line_location_id%TYPE,
24: old_quantity po_change_requests.old_quantity%TYPE,
25: new_quantity po_change_requests.new_quantity%TYPE,
26: old_date po_change_requests.old_need_by_date%TYPE,
19: document_line_location_id po_change_requests.document_line_location_id%TYPE,
20: document_shipment_number po_change_requests.document_shipment_number%TYPE,
21: document_distribution_id po_change_requests.document_distribution_id%TYPE,
22: document_distribution_number po_change_requests.document_distribution_number%TYPE,
23: parent_line_location_id po_change_requests.parent_line_location_id%TYPE,
24: old_quantity po_change_requests.old_quantity%TYPE,
25: new_quantity po_change_requests.new_quantity%TYPE,
26: old_date po_change_requests.old_need_by_date%TYPE,
27: new_date po_change_requests.new_need_by_date%TYPE,
20: document_shipment_number po_change_requests.document_shipment_number%TYPE,
21: document_distribution_id po_change_requests.document_distribution_id%TYPE,
22: document_distribution_number po_change_requests.document_distribution_number%TYPE,
23: parent_line_location_id po_change_requests.parent_line_location_id%TYPE,
24: old_quantity po_change_requests.old_quantity%TYPE,
25: new_quantity po_change_requests.new_quantity%TYPE,
26: old_date po_change_requests.old_need_by_date%TYPE,
27: new_date po_change_requests.new_need_by_date%TYPE,
28: old_supplier_part_number po_change_requests.old_supplier_part_number%TYPE,
21: document_distribution_id po_change_requests.document_distribution_id%TYPE,
22: document_distribution_number po_change_requests.document_distribution_number%TYPE,
23: parent_line_location_id po_change_requests.parent_line_location_id%TYPE,
24: old_quantity po_change_requests.old_quantity%TYPE,
25: new_quantity po_change_requests.new_quantity%TYPE,
26: old_date po_change_requests.old_need_by_date%TYPE,
27: new_date po_change_requests.new_need_by_date%TYPE,
28: old_supplier_part_number po_change_requests.old_supplier_part_number%TYPE,
29: new_supplier_part_number po_change_requests.new_supplier_part_number%TYPE,
22: document_distribution_number po_change_requests.document_distribution_number%TYPE,
23: parent_line_location_id po_change_requests.parent_line_location_id%TYPE,
24: old_quantity po_change_requests.old_quantity%TYPE,
25: new_quantity po_change_requests.new_quantity%TYPE,
26: old_date po_change_requests.old_need_by_date%TYPE,
27: new_date po_change_requests.new_need_by_date%TYPE,
28: old_supplier_part_number po_change_requests.old_supplier_part_number%TYPE,
29: new_supplier_part_number po_change_requests.new_supplier_part_number%TYPE,
30: old_price po_change_requests.old_price%TYPE,
23: parent_line_location_id po_change_requests.parent_line_location_id%TYPE,
24: old_quantity po_change_requests.old_quantity%TYPE,
25: new_quantity po_change_requests.new_quantity%TYPE,
26: old_date po_change_requests.old_need_by_date%TYPE,
27: new_date po_change_requests.new_need_by_date%TYPE,
28: old_supplier_part_number po_change_requests.old_supplier_part_number%TYPE,
29: new_supplier_part_number po_change_requests.new_supplier_part_number%TYPE,
30: old_price po_change_requests.old_price%TYPE,
31: new_price po_change_requests.new_price%TYPE,
24: old_quantity po_change_requests.old_quantity%TYPE,
25: new_quantity po_change_requests.new_quantity%TYPE,
26: old_date po_change_requests.old_need_by_date%TYPE,
27: new_date po_change_requests.new_need_by_date%TYPE,
28: old_supplier_part_number po_change_requests.old_supplier_part_number%TYPE,
29: new_supplier_part_number po_change_requests.new_supplier_part_number%TYPE,
30: old_price po_change_requests.old_price%TYPE,
31: new_price po_change_requests.new_price%TYPE,
32: old_supplier_reference_number po_change_requests.old_supplier_reference_number%TYPE,
25: new_quantity po_change_requests.new_quantity%TYPE,
26: old_date po_change_requests.old_need_by_date%TYPE,
27: new_date po_change_requests.new_need_by_date%TYPE,
28: old_supplier_part_number po_change_requests.old_supplier_part_number%TYPE,
29: new_supplier_part_number po_change_requests.new_supplier_part_number%TYPE,
30: old_price po_change_requests.old_price%TYPE,
31: new_price po_change_requests.new_price%TYPE,
32: old_supplier_reference_number po_change_requests.old_supplier_reference_number%TYPE,
33: new_supplier_reference_number po_change_requests.new_supplier_reference_number%TYPE,
26: old_date po_change_requests.old_need_by_date%TYPE,
27: new_date po_change_requests.new_need_by_date%TYPE,
28: old_supplier_part_number po_change_requests.old_supplier_part_number%TYPE,
29: new_supplier_part_number po_change_requests.new_supplier_part_number%TYPE,
30: old_price po_change_requests.old_price%TYPE,
31: new_price po_change_requests.new_price%TYPE,
32: old_supplier_reference_number po_change_requests.old_supplier_reference_number%TYPE,
33: new_supplier_reference_number po_change_requests.new_supplier_reference_number%TYPE,
34: from_header_id NUMBER,
27: new_date po_change_requests.new_need_by_date%TYPE,
28: old_supplier_part_number po_change_requests.old_supplier_part_number%TYPE,
29: new_supplier_part_number po_change_requests.new_supplier_part_number%TYPE,
30: old_price po_change_requests.old_price%TYPE,
31: new_price po_change_requests.new_price%TYPE,
32: old_supplier_reference_number po_change_requests.old_supplier_reference_number%TYPE,
33: new_supplier_reference_number po_change_requests.new_supplier_reference_number%TYPE,
34: from_header_id NUMBER,
35: old_currency_unit_price po_change_requests.old_currency_unit_price%TYPE,
28: old_supplier_part_number po_change_requests.old_supplier_part_number%TYPE,
29: new_supplier_part_number po_change_requests.new_supplier_part_number%TYPE,
30: old_price po_change_requests.old_price%TYPE,
31: new_price po_change_requests.new_price%TYPE,
32: old_supplier_reference_number po_change_requests.old_supplier_reference_number%TYPE,
33: new_supplier_reference_number po_change_requests.new_supplier_reference_number%TYPE,
34: from_header_id NUMBER,
35: old_currency_unit_price po_change_requests.old_currency_unit_price%TYPE,
36: new_currency_unit_price po_change_requests.new_currency_unit_price%TYPE,
29: new_supplier_part_number po_change_requests.new_supplier_part_number%TYPE,
30: old_price po_change_requests.old_price%TYPE,
31: new_price po_change_requests.new_price%TYPE,
32: old_supplier_reference_number po_change_requests.old_supplier_reference_number%TYPE,
33: new_supplier_reference_number po_change_requests.new_supplier_reference_number%TYPE,
34: from_header_id NUMBER,
35: old_currency_unit_price po_change_requests.old_currency_unit_price%TYPE,
36: new_currency_unit_price po_change_requests.new_currency_unit_price%TYPE,
37: recoverable_tax po_change_requests.recoverable_tax%TYPE,
31: new_price po_change_requests.new_price%TYPE,
32: old_supplier_reference_number po_change_requests.old_supplier_reference_number%TYPE,
33: new_supplier_reference_number po_change_requests.new_supplier_reference_number%TYPE,
34: from_header_id NUMBER,
35: old_currency_unit_price po_change_requests.old_currency_unit_price%TYPE,
36: new_currency_unit_price po_change_requests.new_currency_unit_price%TYPE,
37: recoverable_tax po_change_requests.recoverable_tax%TYPE,
38: non_recoverable_tax po_change_requests.nonrecoverable_tax%TYPE,
39: requester_id po_change_requests.requester_id%TYPE,
32: old_supplier_reference_number po_change_requests.old_supplier_reference_number%TYPE,
33: new_supplier_reference_number po_change_requests.new_supplier_reference_number%TYPE,
34: from_header_id NUMBER,
35: old_currency_unit_price po_change_requests.old_currency_unit_price%TYPE,
36: new_currency_unit_price po_change_requests.new_currency_unit_price%TYPE,
37: recoverable_tax po_change_requests.recoverable_tax%TYPE,
38: non_recoverable_tax po_change_requests.nonrecoverable_tax%TYPE,
39: requester_id po_change_requests.requester_id%TYPE,
40: referenced_po_header_id NUMBER,
33: new_supplier_reference_number po_change_requests.new_supplier_reference_number%TYPE,
34: from_header_id NUMBER,
35: old_currency_unit_price po_change_requests.old_currency_unit_price%TYPE,
36: new_currency_unit_price po_change_requests.new_currency_unit_price%TYPE,
37: recoverable_tax po_change_requests.recoverable_tax%TYPE,
38: non_recoverable_tax po_change_requests.nonrecoverable_tax%TYPE,
39: requester_id po_change_requests.requester_id%TYPE,
40: referenced_po_header_id NUMBER,
41: referenced_po_document_num po_change_requests.ref_po_num%TYPE,
34: from_header_id NUMBER,
35: old_currency_unit_price po_change_requests.old_currency_unit_price%TYPE,
36: new_currency_unit_price po_change_requests.new_currency_unit_price%TYPE,
37: recoverable_tax po_change_requests.recoverable_tax%TYPE,
38: non_recoverable_tax po_change_requests.nonrecoverable_tax%TYPE,
39: requester_id po_change_requests.requester_id%TYPE,
40: referenced_po_header_id NUMBER,
41: referenced_po_document_num po_change_requests.ref_po_num%TYPE,
42: referenced_release_id NUMBER,
35: old_currency_unit_price po_change_requests.old_currency_unit_price%TYPE,
36: new_currency_unit_price po_change_requests.new_currency_unit_price%TYPE,
37: recoverable_tax po_change_requests.recoverable_tax%TYPE,
38: non_recoverable_tax po_change_requests.nonrecoverable_tax%TYPE,
39: requester_id po_change_requests.requester_id%TYPE,
40: referenced_po_header_id NUMBER,
41: referenced_po_document_num po_change_requests.ref_po_num%TYPE,
42: referenced_release_id NUMBER,
43: referenced_release_num NUMBER,
37: recoverable_tax po_change_requests.recoverable_tax%TYPE,
38: non_recoverable_tax po_change_requests.nonrecoverable_tax%TYPE,
39: requester_id po_change_requests.requester_id%TYPE,
40: referenced_po_header_id NUMBER,
41: referenced_po_document_num po_change_requests.ref_po_num%TYPE,
42: referenced_release_id NUMBER,
43: referenced_release_num NUMBER,
44: old_start_date DATE,
45: new_start_date DATE,