APPS.PO_COPYDOC_SUB dependencies on PO_HEADERS_ALL

Line 237: p_from_header_id IN po_headers_all.po_header_id%TYPE,

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

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

2172: ) IS
2173: x_valid_flag VARCHAR2(2);
2174: x_progress VARCHAR2(4) := NULL;
2175:
2176: l_contract_doc_num PO_HEADERS_ALL.segment1%TYPE; --
2177:
2178: BEGIN
2179:
2180: IF (p_contract_id IS NULL) THEN --

Line 2198: FROM po_headers_all POH

2194: -- SQL Why: This is part of the copy doc submission check
2195:
2196: SELECT 'Y'
2197: INTO x_valid_flag
2198: FROM po_headers_all POH
2199: WHERE POH.po_header_id = p_contract_id
2200: AND POH.type_lookup_code = 'CONTRACT'
2201: AND POH.authorization_status = 'APPROVED'
2202: AND NVL(POH.closed_code, 'OPEN') = 'OPEN'

Line 2237: p_from_header_id IN po_headers_all.po_header_id%TYPE,

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

Line 2256: FROM po_headers_all

2252: l_progress := '001';
2253:
2254: SELECT 'Y'
2255: INTO l_valid_flag
2256: FROM po_headers_all
2257: WHERE po_header_id = p_from_header_id
2258: AND nvl(closed_code,'OPEN') <> 'FINALLY CLOSED'
2259: AND nvl(cancel_flag,'N') <> 'Y';
2260:

Line 3514: FROM po_headers_all POH

3510: to check if source is a valid Quotation.The Status that defines an active Quotation is
3511: status_lookup_code.Hence added that check as well*/
3512: SELECT 'Y'
3513: INTO l_valid_flag
3514: FROM po_headers_all POH
3515: WHERE POH.po_header_id = p_blanket_id
3516: AND ( (POH.type_lookup_code = 'QUOTATION' AND Nvl(poh.STATUS_LOOKUP_CODE,'I') = 'A') --
3517: OR ( POH.type_lookup_code = 'BLANKET' AND Nvl(POH.authorization_status,'INCOMPLETE') = 'APPROVED' ) ) --
3518: AND NVL(POH.closed_code, 'OPEN') = 'OPEN'

Line 3557: FROM po_headers_all poh

3553: -- It should not be closed-out, i.e. frozen_flag = Y
3554: BEGIN
3555: SELECT poh.frozen_flag
3556: INTO l_frozen_flag
3557: FROM po_headers_all poh
3558: WHERE poh.po_header_id = x_po_header_record.clm_source_document_id;
3559: EXCEPTION
3560: WHEN NO_DATA_FOUND THEN -- when there is no source document
3561: l_frozen_flag := 'N';