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_COPYDOC_SUB dependencies on PO_DISTRIBUTIONS

Line 26: CURSOR po_distribution_cursor(x_line_location_id po_distributions.line_location_id%TYPE) IS

22: WHERE po_line_id = x_po_line_id
23: AND shipment_type not in ('BLANKET','SCHEDULED')
24: ORDER BY shipment_num;
25:
26: CURSOR po_distribution_cursor(x_line_location_id po_distributions.line_location_id%TYPE) IS
27: SELECT *
28: FROM PO_DISTRIBUTIONS POD
29: WHERE POD.line_location_id = x_line_location_id
30: AND POD.distribution_type <> 'AGREEMENT' --

Line 28: FROM PO_DISTRIBUTIONS POD

24: ORDER BY shipment_num;
25:
26: CURSOR po_distribution_cursor(x_line_location_id po_distributions.line_location_id%TYPE) IS
27: SELECT *
28: FROM PO_DISTRIBUTIONS POD
29: WHERE POD.line_location_id = x_line_location_id
30: AND POD.distribution_type <> 'AGREEMENT' --
31: ORDER BY distribution_num;
32:

Line 34: CURSOR pa_distribution_cursor(x_po_header_id po_distributions.po_header_id%TYPE) IS

30: AND POD.distribution_type <> 'AGREEMENT' --
31: ORDER BY distribution_num;
32:
33: --
34: CURSOR pa_distribution_cursor(x_po_header_id po_distributions.po_header_id%TYPE) IS
35: SELECT *
36: FROM PO_DISTRIBUTIONS POD
37: WHERE POD.po_header_id = x_po_header_id
38: AND POD.distribution_type = 'AGREEMENT'

Line 36: FROM PO_DISTRIBUTIONS POD

32:
33: --
34: CURSOR pa_distribution_cursor(x_po_header_id po_distributions.po_header_id%TYPE) IS
35: SELECT *
36: FROM PO_DISTRIBUTIONS POD
37: WHERE POD.po_header_id = x_po_header_id
38: AND POD.distribution_type = 'AGREEMENT'
39: ORDER BY distribution_num;
40:

Line 129: x_project_id IN OUT NOCOPY po_distributions.project_id%TYPE,

125: x_return_code OUT NOCOPY NUMBER
126: );
127:
128: PROCEDURE validate_project_id(
129: x_project_id IN OUT NOCOPY po_distributions.project_id%TYPE,
130: --
131: -- Removed the x_destination_type_code and x_ship_to_organization_id arguments.
132: -- Added NOCOPY to x_project_id and x_sequence.
133: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,

Line 133: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,

129: x_project_id IN OUT NOCOPY po_distributions.project_id%TYPE,
130: --
131: -- Removed the x_destination_type_code and x_ship_to_organization_id arguments.
132: -- Added NOCOPY to x_project_id and x_sequence.
133: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
134: -- x_ship_to_organization_id IN NUMBER,
135: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
136: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
137: x_line_num IN po_online_report_text.line_num%TYPE,

Line 165: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,

161: x_distribution_num IN po_online_report_text.distribution_num%TYPE
162: );
163:
164: PROCEDURE validate_destination_type_code(
165: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
166: x_item_id IN po_lines.item_id%TYPE,
167: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
168: x_accrue_on_receipt_flag IN varchar2,
169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 180: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,

176: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
177: );
178:
179: PROCEDURE validate_deliver_to_person_id(
180: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
181: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
182: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
183: x_line_num IN po_online_report_text.line_num%TYPE,
184: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 201: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,

197: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
198: x_distribution_num IN po_online_report_text.distribution_num%TYPE);
199:
200: PROCEDURE validate_deliver_to_loc_id(
201: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
202: x_ship_to_organization_id IN NUMBER,
203: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
204: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
205: x_line_num IN po_online_report_text.line_num%TYPE,

Line 211: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,

207: x_distribution_num IN po_online_report_text.distribution_num%TYPE
208: );
209:
210: PROCEDURE validate_dest_subinventory(
211: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
212: x_ship_to_organization_id IN NUMBER,
213: x_item_id IN po_lines.item_id%TYPE,
214: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
215: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

Line 302: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,

298: );
299:
300: PROCEDURE validate_exp_type(
301: x_project_id IN NUMBER,
302: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
303: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
304: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
305: x_line_num IN po_online_report_text.line_num%TYPE,
306: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 1267: x_project_id IN OUT NOCOPY po_distributions.project_id%TYPE,

1263: * PO_ONLINE_REPORT_TEXT.
1264: * Returns: none
1265: */
1266: PROCEDURE validate_project_id(
1267: x_project_id IN OUT NOCOPY po_distributions.project_id%TYPE,
1268: --
1269: -- Removed the x_destination_type_code and x_ship_to_organization_id arguments.
1270: -- Added NOCOPY to x_project_id and x_sequence.
1271: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,

Line 1271: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,

1267: x_project_id IN OUT NOCOPY po_distributions.project_id%TYPE,
1268: --
1269: -- Removed the x_destination_type_code and x_ship_to_organization_id arguments.
1270: -- Added NOCOPY to x_project_id and x_sequence.
1271: -- x_destination_type_code IN po_distributions.destination_type_code%TYPE,
1272: -- x_ship_to_organization_id IN NUMBER,
1273: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1274: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1275: x_line_num IN po_online_report_text.line_num%TYPE,

Line 1438: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,

1434: END validate_exp_item_date;
1435:
1436: PROCEDURE validate_exp_type(
1437: x_project_id IN NUMBER,
1438: x_exp_type IN OUT NOCOPY po_distributions.expenditure_type%TYPE,
1439: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1440: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1441: x_line_num IN po_online_report_text.line_num%TYPE,
1442: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 1524: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,

1520: -- End Bug 3488117
1521:
1522:
1523: PROCEDURE validate_destination_type_code(
1524: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
1525: x_item_id IN po_lines.item_id%TYPE,
1526: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
1527: x_accrue_on_receipt_flag IN varchar2,
1528: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 1690: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,

1686: END validate_destination_type_code;
1687:
1688: /* deliver_to_person = Requestor */
1689: PROCEDURE validate_deliver_to_person_id(
1690: x_deliver_to_person_id IN OUT NOCOPY po_distributions.deliver_to_person_id%TYPE,
1691: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1692: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1693: x_line_num IN po_online_report_text.line_num%TYPE,
1694: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 1898: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,

1894: END;
1895:
1896: /* Deliver To Location */
1897: PROCEDURE validate_deliver_to_loc_id(
1898: x_deliver_to_location_id IN OUT NOCOPY po_distributions.deliver_to_location_id%TYPE,
1899: x_ship_to_organization_id IN NUMBER,
1900: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1901: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
1902: x_line_num IN po_online_report_text.line_num%TYPE,

Line 1958: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,

1954:
1955: END validate_deliver_to_loc_id;
1956:
1957: PROCEDURE validate_dest_subinventory(
1958: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
1959: x_ship_to_organization_id IN NUMBER,
1960: x_item_id IN po_lines.item_id%TYPE,
1961: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1962: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

Line 2279: x_po_distribution_record po_distributions%ROWTYPE;

2275:
2276: x_po_header_record po_headers%ROWTYPE;
2277: x_po_line_record po_lines%ROWTYPE;
2278: x_po_shipment_record po_line_locations%ROWTYPE;
2279: x_po_distribution_record po_distributions%ROWTYPE;
2280:
2281: x_line_num po_online_report_text.line_num%TYPE := NULL;
2282: x_shipment_num po_online_report_text.shipment_num%TYPE := NULL;
2283: x_distribution_num po_online_report_text.distribution_num%TYPE := NULL;