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.ENG_CHANGE_IMPORT_UTIL dependencies on EGO_USER_ATTRS_DATA_PVT

Line 5845: 0, EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE,

5841: AND NVL (pk2_value, 9.97e125) =
5842: NVL (uai2.pk2_value, 9.97e125)
5843: AND NVL (revision_id, 9.97e125) =
5844: NVL (uai2.revision_id, 9.97e125)),
5845: 0, EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE,
5846: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE
5847: )
5848: WHERE uai2.data_set_id = p_data_set_id
5849: AND transaction_id IS NOT NULL

Line 5846: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE

5842: NVL (uai2.pk2_value, 9.97e125)
5843: AND NVL (revision_id, 9.97e125) =
5844: NVL (uai2.revision_id, 9.97e125)),
5845: 0, EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE,
5846: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE
5847: )
5848: WHERE uai2.data_set_id = p_data_set_id
5849: AND transaction_id IS NOT NULL
5850: AND uai2.attr_group_type =p_attr_group_type

Line 5852: AND uai2.transaction_type in (EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE,EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE)

5848: WHERE uai2.data_set_id = p_data_set_id
5849: AND transaction_id IS NOT NULL
5850: AND uai2.attr_group_type =p_attr_group_type
5851: AND uai2.process_status = 5
5852: AND uai2.transaction_type in (EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE,EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE)
5853: AND NVL (uai2.data_level_id,9.97e125) = l_item_rev_dl_id
5854: AND (SELECT multi_row
5855: FROM ego_fnd_dsc_flx_ctx_ext flx_ext
5856: WHERE descriptive_flex_context_code = uai2.attr_group_int_name

Line 5886: EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||''''

5882: FROM EGO_ITM_USR_ATTR_INTRFC UAI1
5883: WHERE DATA_SET_ID = :data_set_id AND data_level_id = '||l_item_rev_dl_id||'
5884: AND transaction_id IS NOT NULL
5885: AND UAI1.PROCESS_STATUS = 5 AND UAI1.TRANSACTION_TYPE = '''||
5886: EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||''''
5887: USING p_data_set_id;
5888: LOOP
5889: FETCH l_dynamic_dist_ag_cursor INTO l_attr_group_intf_rec;
5890: EXIT WHEN l_dynamic_dist_ag_cursor%NOTFOUND;

Line 6025: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||

6021: --------------------------------------------------
6022: l_dynamic_sql :=
6023: ' UPDATE ego_itm_usr_attr_intrfc UAI1
6024: SET UAI1.TRANSACTION_TYPE = DECODE((SELECT COUNT(*) FROM '||l_ext_table_select||'),0,'''||
6025: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
6026: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
6027: WHERE UAI1.transaction_id IS NOT NULL AND UAI1.DATA_SET_ID = '||p_data_set_id||
6028: ' AND NVL(UAI1.DATA_LEVEL_ID,'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM ||') = '||l_item_rev_dl_id ||
6029: ' AND UAI1.ATTR_GROUP_INT_NAME = '''||l_attr_group_metadata_obj.ATTR_GROUP_NAME||

Line 6026: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')

6022: l_dynamic_sql :=
6023: ' UPDATE ego_itm_usr_attr_intrfc UAI1
6024: SET UAI1.TRANSACTION_TYPE = DECODE((SELECT COUNT(*) FROM '||l_ext_table_select||'),0,'''||
6025: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
6026: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
6027: WHERE UAI1.transaction_id IS NOT NULL AND UAI1.DATA_SET_ID = '||p_data_set_id||
6028: ' AND NVL(UAI1.DATA_LEVEL_ID,'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM ||') = '||l_item_rev_dl_id ||
6029: ' AND UAI1.ATTR_GROUP_INT_NAME = '''||l_attr_group_metadata_obj.ATTR_GROUP_NAME||
6030: ''' AND UAI1.PROCESS_STATUS = 5 AND UAI1.TRANSACTION_TYPE IN ('''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||''', '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE ||''')';

Line 6030: ''' AND UAI1.PROCESS_STATUS = 5 AND UAI1.TRANSACTION_TYPE IN ('''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||''', '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE ||''')';

6026: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
6027: WHERE UAI1.transaction_id IS NOT NULL AND UAI1.DATA_SET_ID = '||p_data_set_id||
6028: ' AND NVL(UAI1.DATA_LEVEL_ID,'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM ||') = '||l_item_rev_dl_id ||
6029: ' AND UAI1.ATTR_GROUP_INT_NAME = '''||l_attr_group_metadata_obj.ATTR_GROUP_NAME||
6030: ''' AND UAI1.PROCESS_STATUS = 5 AND UAI1.TRANSACTION_TYPE IN ('''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||''', '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE ||''')';
6031: code_debug('l_dynamic_sql FOR MR '||l_attr_group_intf_rec.ATTR_GROUP_INT_NAME || ' IS:' ||l_dynamic_sql ,2);
6032: EXECUTE IMMEDIATE l_dynamic_sql;
6033: END IF;
6034: END LOOP;