DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on PO_LINES_ALL

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 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 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 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 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: )