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_TLP_INTERFACE

Line 553: PO_ATTR_VALUES_TLP_INTERFACE POTLPI

549: -- SQL Join: interface_line_id
550: -- Bug 5417386: Added hint, removed join with hdr_id
551: FORALL i IN 1..p_id_tbl.COUNT
552: UPDATE /*+ INDEX(POTLPI, PO_ATTR_VALUES_TLP_INT_N1) */
553: PO_ATTR_VALUES_TLP_INTERFACE POTLPI
554: SET POTLPI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
555: POTLPI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
556: WHERE POTLPI.interface_line_id = p_id_tbl(i);
557:

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

554: SET POTLPI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
555: POTLPI.processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
556: WHERE POTLPI.interface_line_id = p_id_tbl(i);
557:
558: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_TLP_INTERFACE='||SQL%rowcount); END IF;
559: ELSIF (p_id_param_type = 'INTERFACE_ATTR_VALUES_TLP_ID') THEN
560: l_progress := '030';
561:
562: -- SQL What: Update the process_code and processing_id in the Attr TLP

Line 570: UPDATE po_attr_values_tlp_interface

566: -- SQL Join: interface_attr_values_tlp_id
567: --
568: -- No need of hint as the join is using the primary key interface_attr_values_tlp_id.
569: FORALL i IN 1..p_id_tbl.COUNT
570: UPDATE po_attr_values_tlp_interface
571: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
572: processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
573: WHERE interface_attr_values_tlp_id = p_id_tbl(i);
574:

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

571: SET process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_REJECTED,
572: processing_id = -PO_R12_CAT_UPG_PVT.g_processing_id
573: WHERE interface_attr_values_tlp_id = p_id_tbl(i);
574:
575: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows REJECTED in PO_ATTR_VALUES_TLP_INTERFACE='||SQL%rowcount); END IF;
576: ELSE
577: l_progress := '040';
578: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Invalid param_type'); END IF;
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 780: PO_ATTR_VALUES_TLP_INTERFACE POTLPI

776: -- SQL Join: interface_line_id
777: -- Bug 5417386: Added hint
778: FORALL i IN 1..l_intf_line_id_tbl.COUNT
779: UPDATE /*+ INDEX(POTLPI, PO_ATTR_VALUES_TLP_INT_N1) */
780: PO_ATTR_VALUES_TLP_INTERFACE POTLPI
781: SET POTLPI.processing_id = PO_R12_CAT_UPG_PVT.g_processing_id
782: WHERE POTLPI.interface_line_id = l_intf_line_id_tbl(i)
783: -- Bug 5345544: Start
784: -- Bug 5417386: Not required after index column re-ordering