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