APPS.PO_CLOSEOUT_PVT dependencies on PO_MULTI_MOD_DOCS

Line 1124: FROM po_multi_mod_docs

1120: l_validation_status VARCHAR2(20);
1121:
1122: CURSOR closeoutDocs IS
1123: SELECT document_id
1124: FROM po_multi_mod_docs
1125: WHERE MULTI_MOD_REQUEST_ID = p_req_id;
1126:
1127:
1128: BEGIN

Line 1321: FROM po_multi_mod_docs

1317: l_doc_contr_type VARCHAR2(50);
1318:
1319: CURSOR closeoutDocs IS
1320: SELECT document_id
1321: FROM po_multi_mod_docs
1322: WHERE MULTI_MOD_REQUEST_ID = p_req_id;
1323: BEGIN
1324: IF (PO_LOG.d_proc) THEN PO_LOG.proc_begin(d_module); END IF;
1325: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);

Line 1684: FROM po_multi_mod_docs docs,

1680: --PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_selected_docs ' || p_selected_docs);
1681:
1682: SELECT listagg(DOCUMENT_ID,',') within GROUP (ORDER BY DOCUMENT_ID)
1683: INTO l_doc_ids
1684: FROM po_multi_mod_docs docs,
1685: po_multi_mod_requests req
1686: WHERE docs.MULTI_MOD_REQUEST_ID = req.MULTI_MOD_REQUEST_ID
1687: AND req.MULTI_MOD_REQUEST_TYPE = 'INITIATE_CLOSEOUT'
1688: AND docs.DOCUMENT_ID IN (SELECT *

Line 1925: FROM po_multi_mod_docs pmmd,

1921: l_mod_doc_id_tbl := NEW po_tbl_number();
1922:
1923: SELECT pha.po_header_id,pha.clm_document_number, pmmd.multi_mod_doc_id
1924: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl,l_mod_doc_id_tbl
1925: FROM po_multi_mod_docs pmmd,
1926: po_headers_all pha
1927: WHERE pmmd.multi_mod_request_id = p_req_id
1928: AND pmmd.document_id = pha.po_header_id
1929: AND EXISTS (SELECT 'Open Mod Exists'

Line 1968: FROM po_multi_mod_docs pmmd,

1964: l_mod_doc_id_tbl := NEW po_tbl_number();
1965:
1966: SELECT DISTINCT pha.po_header_id,pha.clm_document_number,pmmd.multi_mod_doc_id
1967: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl,l_mod_doc_id_tbl
1968: FROM po_multi_mod_docs pmmd,
1969: po_headers_all pha
1970: WHERE pmmd.multi_mod_request_id = p_req_id
1971: AND pmmd.document_id = pha.po_header_id
1972: AND pha.type_lookup_code = 'STANDARD'

Line 2008: FROM po_multi_mod_docs pmmd,

2004: l_mod_doc_id_tbl := NEW po_tbl_number();
2005:
2006: SELECT DISTINCT pha.po_header_id,pha.clm_document_number,pmmd.multi_mod_doc_id
2007: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl,l_mod_doc_id_tbl
2008: FROM po_multi_mod_docs pmmd,
2009: po_headers_all pha
2010: WHERE pmmd.multi_mod_request_id = p_req_id
2011: AND pmmd.document_id = pha.po_header_id
2012: AND pha.type_lookup_code = 'STANDARD'

Line 2049: po_multi_mod_docs pmmd

2045: l_module_status := '';
2046: SELECT DISTINCT pha.po_header_id,pha.clm_document_number,pmmd.multi_mod_doc_id
2047: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl,l_mod_doc_id_tbl
2048: FROM po_headers_all pha,
2049: po_multi_mod_docs pmmd
2050: WHERE pmmd.multi_mod_request_id = p_req_id
2051: AND pmmd.document_id = pha.po_header_id
2052: AND pha.type_lookup_code = 'STANDARD'
2053: AND NOT EXISTS (SELECT 1

Line 2087: po_multi_mod_docs pmmd

2083:
2084: SELECT DISTINCT pha.po_header_id,pha.clm_document_number,pmmd.multi_mod_doc_id
2085: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl,l_mod_doc_id_tbl
2086: FROM po_headers_all pha,
2087: po_multi_mod_docs pmmd
2088: WHERE pmmd.multi_mod_request_id = p_req_id
2089: AND pmmd.document_id = pha.po_header_id
2090: AND pha.type_lookup_code = 'STANDARD'
2091: AND EXISTS (SELECT 1