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_LINES

Line 6: CURSOR po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS

2: /* $Header: POXCPSUB.pls 120.6.12010000.2 2008/09/15 12:24:57 lswamina ship $*/
3:
4: -- Cursor definitions:
5:
6: CURSOR po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS
7: SELECT *
8: FROM PO_LINES
9: WHERE po_header_id = x_po_header_id
10: ORDER BY line_num;

Line 8: FROM PO_LINES

4: -- Cursor definitions:
5:
6: CURSOR po_line_cursor(x_po_header_id po_lines.po_header_id%TYPE) IS
7: SELECT *
8: FROM PO_LINES
9: WHERE po_header_id = x_po_header_id
10: ORDER BY line_num;
11:
12: /* Bug# 3528563, We only need to consider the PRICE BREAKS while

Line 15: * Blankets and Releases share the po_line_id in PO_LINES_ALL.

11:
12: /* Bug# 3528563, We only need to consider the PRICE BREAKS while
13: * validating Blankets. Without the condition on the shipment_type
14: * it was also picking the Release while doing the validations since
15: * Blankets and Releases share the po_line_id in PO_LINES_ALL.
16: * This happened when Releases were entered for a BPA and the BPA
17: * had to be re-approved after being REJECTED.
18: * The same has to be done for Scheculed Relases too. */
19: CURSOR po_shipment_cursor(x_po_line_id po_line_locations.po_line_id%TYPE) IS

Line 116: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,

112: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
113: );
114:
115: PROCEDURE validate_item(
116: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
117: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
118: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
119: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
120: x_line_type_id IN po_lines.line_type_id%TYPE,

Line 117: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,

113: );
114:
115: PROCEDURE validate_item(
116: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
117: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
118: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
119: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
120: x_line_type_id IN po_lines.line_type_id%TYPE,
121: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 118: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,

114:
115: PROCEDURE validate_item(
116: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
117: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
118: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
119: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
120: x_line_type_id IN po_lines.line_type_id%TYPE,
121: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
122: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 119: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,

115: PROCEDURE validate_item(
116: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
117: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
118: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
119: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
120: x_line_type_id IN po_lines.line_type_id%TYPE,
121: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
122: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
123: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

Line 120: x_line_type_id IN po_lines.line_type_id%TYPE,

116: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
117: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
118: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
119: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
120: x_line_type_id IN po_lines.line_type_id%TYPE,
121: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
122: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
123: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
124: x_line_num IN po_online_report_text.line_num%TYPE,

Line 166: x_item_id IN po_lines.item_id%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,
170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

Line 175: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910 Additional Input Parameter PO LINE ID

171: x_line_num IN po_online_report_text.line_num%TYPE,
172: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
173: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
174: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
175: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910 Additional Input Parameter PO LINE ID
176: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
177: );
178:
179: PROCEDURE validate_deliver_to_person_id(

Line 213: x_item_id IN po_lines.item_id%TYPE,

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,
216: x_line_num IN po_online_report_text.line_num%TYPE,
217: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 225: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --

221: --
222: -- this is now added to regular submission check (POXVDCKB.pls 115.30)
223:
224: PROCEDURE validate_contract_num(
225: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
226: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
227: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
228: x_line_num IN po_online_report_text.line_num%TYPE
229: );

Line 236: p_from_line_id IN po_lines_all.po_line_id%TYPE,

232: --Procedure that validate that the referenced global agreement is not cancelled or
233: --finally closed
234: PROCEDURE validate_global_ref(
235: p_from_header_id IN po_headers_all.po_header_id%TYPE,
236: p_from_line_id IN po_lines_all.po_line_id%TYPE,
237: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
238: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
239: p_line_num IN po_online_report_text.line_num%TYPE
240: );

Line 244: -- Procedure to validate the temp labor Job on PO lines

240: );
241: --
242:
243: -- SERVICES FPJ Start
244: -- Procedure to validate the temp labor Job on PO lines
245:
246: PROCEDURE validate_job(
247: p_job_id IN po_lines.job_id%TYPE,
248: p_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 247: p_job_id IN po_lines.job_id%TYPE,

243: -- SERVICES FPJ Start
244: -- Procedure to validate the temp labor Job on PO lines
245:
246: PROCEDURE validate_job(
247: p_job_id IN po_lines.job_id%TYPE,
248: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
249: p_line_num IN po_online_report_text.line_num%TYPE,
250: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
251: );

Line 868: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,

864: END validate_location_terms;
865:
866:
867: PROCEDURE validate_item(
868: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
869: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
870: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
871: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
872: x_line_type_id IN po_lines.line_type_id%TYPE,

Line 869: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,

865:
866:
867: PROCEDURE validate_item(
868: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
869: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
870: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
871: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
872: x_line_type_id IN po_lines.line_type_id%TYPE,
873: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 870: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,

866:
867: PROCEDURE validate_item(
868: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
869: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
870: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
871: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
872: x_line_type_id IN po_lines.line_type_id%TYPE,
873: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
874: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 871: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,

867: PROCEDURE validate_item(
868: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
869: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
870: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
871: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
872: x_line_type_id IN po_lines.line_type_id%TYPE,
873: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
874: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
875: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

Line 872: x_line_type_id IN po_lines.line_type_id%TYPE,

868: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
869: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
870: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
871: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
872: x_line_type_id IN po_lines.line_type_id%TYPE,
873: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
874: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
875: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
876: x_line_num IN po_online_report_text.line_num%TYPE,

Line 1525: x_item_id IN po_lines.item_id%TYPE,

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,
1529: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

Line 1534: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910

1530: x_line_num IN po_online_report_text.line_num%TYPE,
1531: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1532: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1533: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1534: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910
1535: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
1536: ) IS
1537:
1538: x_valid_flag VARCHAR2(2);

Line 1597: FROM PO_LINE_TYPES PLT, PO_LINES POL

1593: BEGIN
1594:
1595: SELECT NVL(PLT.OUTSIDE_OPERATION_FLAG,'N')
1596: INTO x_osp_line_flag
1597: FROM PO_LINE_TYPES PLT, PO_LINES POL
1598: WHERE PLT.LINE_TYPE_ID = POL.LINE_TYPE_ID
1599: AND POL.PO_LINE_ID = x_po_line_id;
1600:
1601: EXCEPTION

Line 1960: x_item_id IN po_lines.item_id%TYPE,

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,
1963: x_line_num IN po_online_report_text.line_num%TYPE,
1964: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

Line 2023: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --

2019: END validate_dest_subinventory;
2020:
2021:
2022: PROCEDURE validate_contract_num(
2023: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
2024: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2025: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2026: x_line_num IN po_online_report_text.line_num%TYPE
2027: ) IS

Line 2092: p_from_line_id IN po_lines_all.po_line_id%TYPE,

2088: --Private procedure that validate that the referenced global agreement is not cancelled or
2089: --finally closed
2090: PROCEDURE validate_global_ref(
2091: p_from_header_id IN po_headers_all.po_header_id%TYPE,
2092: p_from_line_id IN po_lines_all.po_line_id%TYPE,
2093: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2094: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2095: p_line_num IN po_online_report_text.line_num%TYPE
2096: ) IS

Line 2161: p_job_id IN po_lines.job_id%TYPE,

2157: --Testing: -
2158: --End of Comments
2159: -------------------------------------------------------------------------------------------------
2160: PROCEDURE validate_job(
2161: p_job_id IN po_lines.job_id%TYPE,
2162: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2163: p_line_num IN po_online_report_text.line_num%TYPE,
2164: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
2165: ) IS

Line 2277: x_po_line_record po_lines%ROWTYPE;

2273: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2274: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE) IS
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;