eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_R12_CAT_UPG_UTL dependencies on PO_LINES_INTERFACE

Line 348: UPDATE po_lines_interface

344: -- SQL Why : So that they are not picked up from from processing in the
345: -- downstream flows.
346: -- SQL Join: interface_header_id
347: FORALL i IN 1..p_id_tbl.COUNT
348: UPDATE po_lines_interface
349: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
350: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
351: WHERE interface_header_id = p_id_tbl(i)
352: RETURNING interface_header_id, interface_line_id

Line 355: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_LINES_INTERFACE='||SQL%rowcount); END IF;

351: WHERE interface_header_id = p_id_tbl(i)
352: RETURNING interface_header_id, interface_line_id
353: BULK COLLECT INTO l_processed_intf_hdr_id_tbl, l_intf_line_id_tbl;
354:
355: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_LINES_INTERFACE='||SQL%rowcount); END IF;
356: ELSIF (p_id_param_type = 'INTERFACE_LINE_ID') THEN
357: l_progress := '030';
358: -- SQL What: Update the process_code and processing_id in the Lines
359: -- Interface Table to mark error rows.

Line 364: UPDATE po_lines_interface

360: -- SQL Why : So that they are not picked up from from processing in the
361: -- downstream flows.
362: -- SQL Join: interface_line_id
363: FORALL i IN 1..p_id_tbl.COUNT
364: UPDATE po_lines_interface
365: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED
366: --processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
367: WHERE interface_line_id = p_id_tbl(i)
368: RETURNING interface_header_id, interface_line_id

Line 371: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_LINES_INTERFACE='||SQL%rowcount); END IF;

367: WHERE interface_line_id = p_id_tbl(i)
368: RETURNING interface_header_id, interface_line_id
369: BULK COLLECT INTO l_processed_intf_hdr_id_tbl, l_intf_line_id_tbl;
370:
371: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_LINES_INTERFACE='||SQL%rowcount); END IF;
372: ELSE
373: l_progress := '040';
374: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Invalid param_type'); END IF;
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 728: UPDATE po_lines_interface

724: -- SQL What: Assign processing_id to Lines Interface table rows.
725: -- SQL Why : So that these rows are picked up for processing.
726: -- SQL Join: interface_header_id
727: FORALL i IN 1..l_intf_header_id_tbl.COUNT
728: UPDATE po_lines_interface
729: SET processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
730: WHERE interface_header_id = l_intf_header_id_tbl(i)
731: AND processing_id IS NULL
732: RETURNING interface_header_id, interface_line_id