APPS.PO_R12_CAT_UPG_UTL dependencies on PO_HEADERS_INTERFACE

Line 263: UPDATE po_headers_interface

259: -- SQL Why : So that they are not picked up from from processing in the
260: -- downstream flows.
261: -- SQL Join: interface_header_id
262: FORALL i IN 1..p_id_tbl.COUNT
263: UPDATE po_headers_interface
264: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
265: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
266: WHERE interface_header_id = p_id_tbl(i);
267: ELSE

Line 679: FROM po_headers_interface PHI

675: -- picked up for processing.
676: -- SQL Join: batch_id, org_id, process_code, document_type.
677: CURSOR interface_headers_csr IS
678: SELECT PHI.interface_header_id
679: FROM po_headers_interface PHI
680: WHERE PHI.batch_id = PO_R12_CAT_UPG_PVT.g_job.batch_id
681: AND (PHI.org_id = PO_R12_CAT_UPG_PVT.g_job.org_id OR
682: PO_R12_CAT_UPG_PVT.g_job.org_id IS NULL)
683: AND PHI.processing_id IS NULL

Line 716: UPDATE po_headers_interface

712: -- SQL What: Assign processing_id to Headers Interface table rows.
713: -- SQL Why : So that these rows are picked up for processing.
714: -- SQL Join: interface_header_id
715: FORALL i IN 1..l_intf_header_id_tbl.COUNT
716: UPDATE po_headers_interface
717: SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
718: WHERE interface_header_id = l_intf_header_id_tbl(i)
719: AND processing_id IS NULL;
720: