APPS.PO_R12_CAT_UPG_PVT dependencies on PO_ATTR_VALUES_INTERFACE

Line 4590: FROM PO_ATTR_VALUES_INTERFACE attrib,

4586: attrib.program_id,
4587: attrib.program_update_date,
4588: attrib.processing_id,
4589: 'N' -- has_errors
4590: FROM PO_ATTR_VALUES_INTERFACE attrib,
4591: PO_LINES_INTERFACE POLI
4592: WHERE attrib.processing_id = request_processing_id
4593: AND attrib.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
4594: AND attrib.action IN (PO_R12_CAT_UPG_PVT.g_action_attr_create, 'UPDATE', 'DELETE')

Line 5771: FROM PO_ATTR_VALUES_INTERFACE POAVI,

5767: p_attr_values_tbl.program_application_id(i),
5768: p_attr_values_tbl.program_id(i),
5769: p_attr_values_tbl.program_update_date(i),
5770: g_R12_MIGRATION_PROGRAM -- last_updated_program
5771: FROM PO_ATTR_VALUES_INTERFACE POAVI,
5772: PO_LINES_INTERFACE POLI -- ECO bug 4738058
5773: WHERE POAVI.interface_attr_values_id = p_attr_values_tbl.interface_attr_values_id(i)
5774: AND p_attr_values_tbl.has_errors(i) = 'N'
5775: AND p_attr_values_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_attr_create

Line 5787: UPDATE PO_ATTR_VALUES_INTERFACE POAVI

5783: -- SQL Why : To mark the rows as successfully inserted
5784: -- SQL Join: interface_attr_values_id
5785: -- Bug 5677911: Added the hint for performance reason.
5786: FORALL i IN 1..p_attr_values_tbl.po_line_id.COUNT
5787: UPDATE PO_ATTR_VALUES_INTERFACE POAVI
5788: SET /*+ INDEX(POAVI, PO_ATTR_VALUES_INT_U1)*/
5789: process_code = g_PROCESS_CODE_PROCESSED
5790: -- ECO bug 4738058
5791: , po_line_id = (SELECT POLI.po_line_id

Line 6195: PO_ATTR_VALUES_INTERFACE POATRI

6191: -- attr/attr_tlp interface tables
6192: -- Bug 5677911: Added the hint for performance reason.
6193: FORALL i IN 1..p_attr_values_tbl.po_line_id.COUNT
6194: UPDATE /*+ INDEX(POATRI, PO_ATTR_VALUES_INT_N3)*/
6195: PO_ATTR_VALUES_INTERFACE POATRI
6196: SET PROCESS_CODE = g_PROCESS_CODE_PROCESSED
6197: WHERE p_attr_values_tbl.has_errors(i) = 'N'
6198: AND p_attr_values_tbl.action(i) = 'UPDATE'
6199: AND po_line_id = p_attr_values_tbl.po_line_id(i)

Line 6270: PO_ATTR_VALUES_INTERFACE POATRI

6266: -- Mark interface attr rows as PROCESSED
6267: -- Bug 5677911: Added the hint for performance reason.
6268: FORALL i IN 1..p_attr_values_tbl.po_line_id.COUNT
6269: UPDATE /*+ INDEX(POATRI, PO_ATTR_VALUES_INT_N3)*/
6270: PO_ATTR_VALUES_INTERFACE POATRI
6271: SET PROCESS_CODE = g_PROCESS_CODE_PROCESSED
6272: WHERE p_attr_values_tbl.has_errors(i) = 'N'
6273: AND p_attr_values_tbl.action(i) = 'DELETE'
6274: AND ( (po_line_id = p_attr_values_tbl.po_line_id(i)