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.15.12020000.5 2013/05/30 11:44:15 gjyothi 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 117: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,

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

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

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

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

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

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

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

Line 121: x_line_type_id IN po_lines.line_type_id%TYPE,

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

Line 126: x_clm_info_flag IN po_lines.clm_info_flag%TYPE, --CLM

122: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
123: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
124: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
125: x_line_num IN po_online_report_text.line_num%TYPE,
126: x_clm_info_flag IN po_lines.clm_info_flag%TYPE, --CLM
127: x_return_code OUT NOCOPY NUMBER
128: );
129:
130: PROCEDURE validate_project_id(

Line 168: x_item_id IN po_lines.item_id%TYPE,

164: );
165:
166: PROCEDURE validate_destination_type_code(
167: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
168: x_item_id IN po_lines.item_id%TYPE,
169: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
170: x_accrue_on_receipt_flag IN varchar2,
171: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
172: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

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

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

Line 215: x_item_id IN po_lines.item_id%TYPE,

211:
212: PROCEDURE validate_dest_subinventory(
213: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
214: x_ship_to_organization_id IN NUMBER,
215: x_item_id IN po_lines.item_id%TYPE,
216: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
217: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
218: x_line_num IN po_online_report_text.line_num%TYPE,
219: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

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

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

Line 238: p_from_line_id IN po_lines_all.po_line_id%TYPE,

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

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

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

Line 249: p_job_id IN po_lines.job_id%TYPE,

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

Line 352: p_blanket_id IN PO_LINES_ALL.from_header_id%TYPE,

348:
349:
350: --
351: PROCEDURE validate_blanket_ref(
352: p_blanket_id IN PO_LINES_ALL.from_header_id%TYPE,
353: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
354: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
355: x_line_num IN po_online_report_text.line_num%TYPE
356: );

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

909: END validate_location_terms;
910:
911:
912: PROCEDURE validate_item(
913: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
914: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
915: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
916: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
917: x_line_type_id IN po_lines.line_type_id%TYPE,

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

910:
911:
912: PROCEDURE validate_item(
913: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
914: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
915: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
916: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
917: x_line_type_id IN po_lines.line_type_id%TYPE,
918: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

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

911:
912: PROCEDURE validate_item(
913: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
914: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
915: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
916: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
917: x_line_type_id IN po_lines.line_type_id%TYPE,
918: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
919: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

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

912: PROCEDURE validate_item(
913: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
914: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
915: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
916: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
917: x_line_type_id IN po_lines.line_type_id%TYPE,
918: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
919: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
920: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

Line 917: x_line_type_id IN po_lines.line_type_id%TYPE,

913: x_item_id IN OUT NOCOPY po_lines.item_id%TYPE,
914: x_item_description IN OUT NOCOPY po_lines.item_description%TYPE,
915: x_item_revision IN OUT NOCOPY po_lines.item_revision%TYPE,
916: x_category_id IN OUT NOCOPY po_lines.category_id%TYPE,
917: x_line_type_id IN po_lines.line_type_id%TYPE,
918: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
919: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
920: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
921: x_line_num IN po_online_report_text.line_num%TYPE,

Line 922: x_clm_info_flag IN po_lines.clm_info_flag%TYPE, --CLM

918: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
919: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
920: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
921: x_line_num IN po_online_report_text.line_num%TYPE,
922: x_clm_info_flag IN po_lines.clm_info_flag%TYPE, --CLM
923: x_return_code OUT NOCOPY NUMBER
924: ) IS
925:
926: x_progress VARCHAR2(4);

Line 1661: x_item_id IN po_lines.item_id%TYPE,

1657:
1658:
1659: PROCEDURE validate_destination_type_code(
1660: x_destination_type_code IN OUT NOCOPY po_distributions.destination_type_code%TYPE,
1661: x_item_id IN po_lines.item_id%TYPE,
1662: x_ship_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
1663: x_accrue_on_receipt_flag IN varchar2,
1664: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
1665: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

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

1666: x_line_num IN po_online_report_text.line_num%TYPE,
1667: x_shipment_num IN po_online_report_text.shipment_num%TYPE,
1668: x_distribution_num IN po_online_report_text.distribution_num%TYPE,
1669: x_line_location_id IN po_line_locations.line_location_id%TYPE, -- CONSIGNED FPI START
1670: x_po_line_id IN po_lines.po_line_id%TYPE, -- Bug 3557910
1671: p_transaction_flow_header_id IN NUMBER --< Bug 3546252 >
1672: ) IS
1673:
1674: x_valid_flag VARCHAR2(2);

Line 1733: FROM PO_LINE_TYPES PLT, PO_LINES POL

1729: BEGIN
1730:
1731: SELECT NVL(PLT.OUTSIDE_OPERATION_FLAG,'N')
1732: INTO x_osp_line_flag
1733: FROM PO_LINE_TYPES PLT, PO_LINES POL
1734: WHERE PLT.LINE_TYPE_ID = POL.LINE_TYPE_ID
1735: AND POL.PO_LINE_ID = x_po_line_id;
1736:
1737: EXCEPTION

Line 2105: x_item_id IN po_lines.item_id%TYPE,

2101:
2102: PROCEDURE validate_dest_subinventory(
2103: x_destination_subinventory IN OUT NOCOPY po_distributions.destination_subinventory%TYPE,
2104: x_ship_to_organization_id IN NUMBER,
2105: x_item_id IN po_lines.item_id%TYPE,
2106: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2107: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2108: x_line_num IN po_online_report_text.line_num%TYPE,
2109: x_shipment_num IN po_online_report_text.shipment_num%TYPE,

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

2164: END validate_dest_subinventory;
2165:
2166:
2167: PROCEDURE validate_contract_num(
2168: p_contract_id IN PO_LINES_ALL.contract_id%TYPE, --
2169: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
2170: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2171: x_line_num IN po_online_report_text.line_num%TYPE
2172: ) IS

Line 2238: p_from_line_id IN po_lines_all.po_line_id%TYPE,

2234: --Private procedure that validate that the referenced global agreement is not cancelled or
2235: --finally closed
2236: PROCEDURE validate_global_ref(
2237: p_from_header_id IN po_headers_all.po_header_id%TYPE,
2238: p_from_line_id IN po_lines_all.po_line_id%TYPE,
2239: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2240: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
2241: p_line_num IN po_online_report_text.line_num%TYPE
2242: ) IS

Line 2307: p_job_id IN po_lines.job_id%TYPE,

2303: --Testing: -
2304: --End of Comments
2305: -------------------------------------------------------------------------------------------------
2306: PROCEDURE validate_job(
2307: p_job_id IN po_lines.job_id%TYPE,
2308: p_online_report_id IN po_online_report_text.online_report_id%TYPE,
2309: p_line_num IN po_online_report_text.line_num%TYPE,
2310: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE
2311: ) IS

Line 2423: x_po_line_record po_lines%ROWTYPE;

2419: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2420: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE) IS
2421:
2422: x_po_header_record po_headers%ROWTYPE;
2423: x_po_line_record po_lines%ROWTYPE;
2424: x_po_shipment_record po_line_locations%ROWTYPE;
2425: x_po_distribution_record po_distributions%ROWTYPE;
2426:
2427: x_line_num po_online_report_text.line_num%TYPE := NULL;

Line 3489: p_blanket_id IN PO_LINES_ALL.from_header_id%TYPE,

3485:
3486: -- Validate the Source Document status at line.
3487: -- It should not be closed, freezed, cancelled, on hold
3488: PROCEDURE validate_blanket_ref(
3489: p_blanket_id IN PO_LINES_ALL.from_header_id%TYPE,
3490: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
3491: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
3492: x_line_num IN po_online_report_text.line_num%TYPE
3493: )