APPS.PO_COPYDOC_SUB dependencies on PO_HEADERS_ALL

Line 235: p_from_header_id IN po_headers_all.po_header_id%TYPE,

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

Line 2031: l_contract_doc_num PO_HEADERS_ALL.segment1%TYPE; --

2027: ) IS
2028: x_valid_flag VARCHAR2(2);
2029: x_progress VARCHAR2(4) := NULL;
2030:
2031: l_contract_doc_num PO_HEADERS_ALL.segment1%TYPE; --
2032:
2033: BEGIN
2034:
2035: IF (p_contract_id IS NULL) THEN --

Line 2053: FROM po_headers_all POH

2049: -- SQL Why: This is part of the copy doc submission check
2050:
2051: SELECT 'Y'
2052: INTO x_valid_flag
2053: FROM po_headers_all POH
2054: WHERE POH.po_header_id = p_contract_id
2055: AND POH.type_lookup_code = 'CONTRACT'
2056: AND POH.authorization_status = 'APPROVED'
2057: AND NVL(POH.closed_code, 'OPEN') = 'OPEN'

Line 2091: p_from_header_id IN po_headers_all.po_header_id%TYPE,

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

Line 2110: FROM po_headers_all

2106: l_progress := '001';
2107:
2108: SELECT 'Y'
2109: INTO l_valid_flag
2110: FROM po_headers_all
2111: WHERE po_header_id = p_from_header_id
2112: AND nvl(closed_code,'OPEN') <> 'FINALLY CLOSED'
2113: AND nvl(cancel_flag,'N') <> 'Y';
2114: