DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS2 dependencies on PO_PDOI_CONSTANTS

Line 169: AND Nvl(process_code,PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)

165: WHERE p_document_num_tbl(i) IS NOT NULL AND --8688769 bug
166: ( EXISTS (SELECT 1
167: FROM po_headers_interface
168: WHERE document_num =p_document_num_tbl(i)
169: AND Nvl(process_code,PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
170: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
171: GROUP BY document_num,org_id HAVING Count(document_num)>1) --14641487 bug
172: OR
173: EXISTS(SELECT 1

Line 170: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)

166: ( EXISTS (SELECT 1
167: FROM po_headers_interface
168: WHERE document_num =p_document_num_tbl(i)
169: AND Nvl(process_code,PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
170: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,PO_PDOI_CONSTANTS.g_process_code_IN_PROCESS)
171: GROUP BY document_num,org_id HAVING Count(document_num)>1) --14641487 bug
172: OR
173: EXISTS(SELECT 1
174: FROM po_headers