eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_CHANGE_REQUESTS

Line 7: TYPE change_rec_type IS RECORD(action_type po_change_requests.action_type%TYPE,

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,

Line 8: initiator po_change_requests.initiator%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,

Line 9: request_reason po_change_requests.request_reason%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,

Line 10: document_type po_change_requests.document_type%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,

Line 11: request_level po_change_requests.request_level%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,

Line 12: request_status po_change_requests.request_status%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,

Line 13: document_header_id po_change_requests.document_header_id%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,

Line 14: po_release_id po_change_requests.po_release_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,

Line 15: document_num po_change_requests.document_num%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,

Line 16: document_revision_num po_change_requests.document_revision_num%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,

Line 17: document_line_id po_change_requests.document_line_id%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,

Line 18: document_line_number po_change_requests.document_line_number%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,

Line 19: document_line_location_id po_change_requests.document_line_location_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,
23: parent_line_location_id po_change_requests.parent_line_location_id%TYPE,

Line 20: document_shipment_number po_change_requests.document_shipment_number%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,

Line 21: document_distribution_id po_change_requests.document_distribution_id%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,

Line 22: document_distribution_number po_change_requests.document_distribution_number%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,

Line 23: parent_line_location_id po_change_requests.parent_line_location_id%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,

Line 24: old_quantity po_change_requests.old_quantity%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,

Line 25: new_quantity po_change_requests.new_quantity%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,

Line 26: old_date po_change_requests.old_need_by_date%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,

Line 27: new_date po_change_requests.new_need_by_date%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,

Line 28: old_supplier_part_number po_change_requests.old_supplier_part_number%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,

Line 29: new_supplier_part_number po_change_requests.new_supplier_part_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,

Line 30: old_price po_change_requests.old_price%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,

Line 31: new_price po_change_requests.new_price%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,
35: old_currency_unit_price po_change_requests.old_currency_unit_price%TYPE,

Line 32: old_supplier_reference_number po_change_requests.old_supplier_reference_number%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,

Line 33: new_supplier_reference_number po_change_requests.new_supplier_reference_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,
37: recoverable_tax po_change_requests.recoverable_tax%TYPE,

Line 35: old_currency_unit_price po_change_requests.old_currency_unit_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,
38: non_recoverable_tax po_change_requests.nonrecoverable_tax%TYPE,
39: requester_id po_change_requests.requester_id%TYPE,

Line 36: new_currency_unit_price po_change_requests.new_currency_unit_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,
40: referenced_po_header_id NUMBER,

Line 37: recoverable_tax po_change_requests.recoverable_tax%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,
41: referenced_po_document_num po_change_requests.ref_po_num%TYPE,

Line 38: non_recoverable_tax po_change_requests.nonrecoverable_tax%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,

Line 39: requester_id po_change_requests.requester_id%TYPE,

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,

Line 41: referenced_po_document_num po_change_requests.ref_po_num%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,
44: old_start_date DATE,
45: new_start_date DATE,