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_ATTR_VALUES_INTERFACE

Line 463: PO_ATTR_VALUES_INTERFACE POATRI

459: -- SQL Join: interface_line_id
460: -- Bug 5417386: Added hint, removed join with hdr_id
461: FORALL i IN 1..p_id_tbl.COUNT
462: UPDATE /*+ INDEX(POATRI, PO_ATTR_VALUES_INT_N1) */
463: PO_ATTR_VALUES_INTERFACE POATRI
464: SET POATRI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
465: POATRI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
466: WHERE POATRI.interface_line_id = p_id_tbl(i);
467:

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

464: SET POATRI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
465: POATRI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
466: WHERE POATRI.interface_line_id = p_id_tbl(i);
467:
468: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_INTERFACE='||SQL%rowcount); END IF;
469: ELSIF (p_id_param_type = 'INTERFACE_ATTR_VALUES_ID') THEN
470: l_progress := '030';
471:
472: -- SQL What: Update the process_code and processing_id in the Attr

Line 480: UPDATE PO_ATTR_VALUES_INTERFACE POATRI

476: -- SQL Join: interface_attr_values_id
477: --
478: -- No need of hint as the join is using the primary key interface_attr_values_id.
479: FORALL i IN 1..p_id_tbl.COUNT
480: UPDATE PO_ATTR_VALUES_INTERFACE POATRI
481: SET POATRI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
482: POATRI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
483: WHERE POATRI.interface_attr_values_id = p_id_tbl(i);
484:

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

481: SET POATRI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
482: POATRI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
483: WHERE POATRI.interface_attr_values_id = p_id_tbl(i);
484:
485: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_INTERFACE='||SQL%rowcount); END IF;
486: ELSE
487: l_progress := '040';
488: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Invalid param_type'); END IF;
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 762: PO_ATTR_VALUES_INTERFACE POATRI

758: -- SQL Why : So that these rows are picked up for processing.
759: -- SQL Join: interface_line_id
760: FORALL i IN 1..l_intf_line_id_tbl.COUNT
761: UPDATE /*+ INDEX(POATRI, PO_ATTR_VALUES_INT_N1) */
762: PO_ATTR_VALUES_INTERFACE POATRI
763: SET POATRI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
764: WHERE POATRI.interface_line_id = l_intf_line_id_tbl(i)
765: -- Bug 5345544: Start
766: -- Bug 5417386: Not required after index column re-ordering