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_BULK_PVT

Line 5912: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;

5908: IF (l_attr_metadata_table(i).UNIQUE_KEY_FLAG = 'Y' ) THEN
5909:
5910: IF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE ) THEN
5911: l_intf_column_name := ' ATTR_VALUE_NUM ';
5912: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5913: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN
5914: l_intf_column_name := ' ATTR_VALUE_DATE ';
5915: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5916: ELSE

Line 5915: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;

5911: l_intf_column_name := ' ATTR_VALUE_NUM ';
5912: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5913: ELSIF (l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR l_attr_metadata_table(i).DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) THEN
5914: l_intf_column_name := ' ATTR_VALUE_DATE ';
5915: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5916: ELSE
5917: l_intf_column_name := ' ATTR_VALUE_STR ';
5918: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
5919: END IF;

Line 5918: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

5914: l_intf_column_name := ' ATTR_VALUE_DATE ';
5915: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5916: ELSE
5917: l_intf_column_name := ' ATTR_VALUE_STR ';
5918: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
5919: END IF;
5920:
5921: l_intf_tbl_select :=
5922: ' (SELECT '||l_intf_column_name||' FROM EGO_ITM_USR_ATTR_INTRFC WHERE DATA_SET_ID = '||p_data_set_id||

Line 5952: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.DATA_LEVEL_ID,'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||') '||

5948: IF (l_pk5_column_name IS NOT NULL) THEN
5949: l_ext_table_select := l_ext_table_select || ' AND EXTVL1.'||l_pk5_column_name||' = UAI1.'||l_pk5_column_name;
5950: END IF;
5951:
5952: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.DATA_LEVEL_ID,'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||') '||
5953: ' = NVL(UAI1.DATA_LEVEL_ID,'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||')';
5954:
5955: /* Append data level PK condition for Rev Item level - 43106*/
5956: IF (l_data_level_metadata_obj.PK_COLUMN_NAME1 IS NOT NULL AND l_data_level_metadata_obj.PK_COLUMN_NAME1 <> 'NONE'

Line 5953: ' = NVL(UAI1.DATA_LEVEL_ID,'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||')';

5949: l_ext_table_select := l_ext_table_select || ' AND EXTVL1.'||l_pk5_column_name||' = UAI1.'||l_pk5_column_name;
5950: END IF;
5951:
5952: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.DATA_LEVEL_ID,'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||') '||
5953: ' = NVL(UAI1.DATA_LEVEL_ID,'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM||')';
5954:
5955: /* Append data level PK condition for Rev Item level - 43106*/
5956: IF (l_data_level_metadata_obj.PK_COLUMN_NAME1 IS NOT NULL AND l_data_level_metadata_obj.PK_COLUMN_NAME1 <> 'NONE'
5957: AND INSTR(l_ext_table_select,l_data_level_metadata_obj.PK_COLUMN_NAME1) = 0) THEN

Line 5960: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;

5956: IF (l_data_level_metadata_obj.PK_COLUMN_NAME1 IS NOT NULL AND l_data_level_metadata_obj.PK_COLUMN_NAME1 <> 'NONE'
5957: AND INSTR(l_ext_table_select,l_data_level_metadata_obj.PK_COLUMN_NAME1) = 0) THEN
5958:
5959: IF(l_data_level_metadata_obj.PK_COLUMN_TYPE1 = 'NUMBER') THEN
5960: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5961: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE1 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE1 = 'DATETIME') THEN
5962: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5963: ELSE
5964: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

Line 5962: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;

5958:
5959: IF(l_data_level_metadata_obj.PK_COLUMN_TYPE1 = 'NUMBER') THEN
5960: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5961: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE1 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE1 = 'DATETIME') THEN
5962: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5963: ELSE
5964: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
5965: END IF;
5966: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.'||l_data_level_metadata_obj.PK_COLUMN_NAME1||','||wierd_constant||') '||

Line 5964: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

5960: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5961: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE1 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE1 = 'DATETIME') THEN
5962: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5963: ELSE
5964: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
5965: END IF;
5966: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.'||l_data_level_metadata_obj.PK_COLUMN_NAME1||','||wierd_constant||') '||
5967: ' = NVL(UAI1.'||l_data_level_metadata_obj.PK_COLUMN_NAME1||','||wierd_constant||')';
5968: END IF;

Line 5972: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;

5968: END IF;
5969: IF (l_data_level_metadata_obj.PK_COLUMN_NAME2 IS NOT NULL AND l_data_level_metadata_obj.PK_COLUMN_NAME2 <> 'NONE'
5970: AND INSTR(l_ext_table_select,l_data_level_metadata_obj.PK_COLUMN_NAME2) = 0) THEN
5971: IF(l_data_level_metadata_obj.PK_COLUMN_TYPE2 = 'NUMBER') THEN
5972: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5973: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE2 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE2 = 'DATETIME') THEN
5974: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5975: ELSE
5976: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

Line 5974: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;

5970: AND INSTR(l_ext_table_select,l_data_level_metadata_obj.PK_COLUMN_NAME2) = 0) THEN
5971: IF(l_data_level_metadata_obj.PK_COLUMN_TYPE2 = 'NUMBER') THEN
5972: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5973: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE2 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE2 = 'DATETIME') THEN
5974: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5975: ELSE
5976: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
5977: END IF;
5978: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.'||l_data_level_metadata_obj.PK_COLUMN_NAME2||','||wierd_constant||') '||

Line 5976: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

5972: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5973: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE2 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE2 = 'DATETIME') THEN
5974: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5975: ELSE
5976: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
5977: END IF;
5978: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.'||l_data_level_metadata_obj.PK_COLUMN_NAME2||','||wierd_constant||') '||
5979: ' = NVL(UAI1.'||l_data_level_metadata_obj.PK_COLUMN_NAME2||','||wierd_constant||')';
5980: END IF;

Line 5984: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;

5980: END IF;
5981: IF (l_data_level_metadata_obj.PK_COLUMN_NAME3 IS NOT NULL AND l_data_level_metadata_obj.PK_COLUMN_NAME3 <> 'NONE'
5982: AND INSTR(l_ext_table_select,l_data_level_metadata_obj.PK_COLUMN_NAME3) = 0) THEN
5983: IF(l_data_level_metadata_obj.PK_COLUMN_TYPE3 = 'NUMBER') THEN
5984: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5985: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE3 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE3 = 'DATETIME') THEN
5986: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5987: ELSE
5988: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

Line 5986: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;

5982: AND INSTR(l_ext_table_select,l_data_level_metadata_obj.PK_COLUMN_NAME3) = 0) THEN
5983: IF(l_data_level_metadata_obj.PK_COLUMN_TYPE3 = 'NUMBER') THEN
5984: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5985: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE3 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE3 = 'DATETIME') THEN
5986: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5987: ELSE
5988: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
5989: END IF;
5990: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.'||l_data_level_metadata_obj.PK_COLUMN_NAME3||','||wierd_constant||') '||

Line 5988: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

5984: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5985: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE3 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE3 = 'DATETIME') THEN
5986: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5987: ELSE
5988: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
5989: END IF;
5990: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.'||l_data_level_metadata_obj.PK_COLUMN_NAME3||','||wierd_constant||') '||
5991: ' = NVL(UAI1.'||l_data_level_metadata_obj.PK_COLUMN_NAME3||','||wierd_constant||')';
5992: END IF;

Line 5996: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;

5992: END IF;
5993: IF (l_data_level_metadata_obj.PK_COLUMN_NAME4 IS NOT NULL AND l_data_level_metadata_obj.PK_COLUMN_NAME4 <> 'NONE'
5994: AND INSTR(l_ext_table_select,l_data_level_metadata_obj.PK_COLUMN_NAME4) = 0) THEN
5995: IF(l_data_level_metadata_obj.PK_COLUMN_TYPE4 = 'NUMBER') THEN
5996: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5997: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE4 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE4 = 'DATETIME') THEN
5998: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5999: ELSE
6000: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

Line 5998: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;

5994: AND INSTR(l_ext_table_select,l_data_level_metadata_obj.PK_COLUMN_NAME4) = 0) THEN
5995: IF(l_data_level_metadata_obj.PK_COLUMN_TYPE4 = 'NUMBER') THEN
5996: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5997: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE4 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE4 = 'DATETIME') THEN
5998: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5999: ELSE
6000: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
6001: END IF;
6002: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.'||l_data_level_metadata_obj.PK_COLUMN_NAME4||','||wierd_constant||') '||

Line 6000: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

5996: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
5997: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE4 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE4 = 'DATETIME') THEN
5998: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
5999: ELSE
6000: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
6001: END IF;
6002: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.'||l_data_level_metadata_obj.PK_COLUMN_NAME4||','||wierd_constant||') '||
6003: ' = NVL(UAI1.'||l_data_level_metadata_obj.PK_COLUMN_NAME4||','||wierd_constant||')';
6004: END IF;

Line 6008: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;

6004: END IF;
6005: IF (l_data_level_metadata_obj.PK_COLUMN_NAME5 IS NOT NULL AND l_data_level_metadata_obj.PK_COLUMN_NAME5 <> 'NONE'
6006: AND INSTR(l_ext_table_select,l_data_level_metadata_obj.PK_COLUMN_NAME5) = 0) THEN
6007: IF(l_data_level_metadata_obj.PK_COLUMN_TYPE5 = 'NUMBER') THEN
6008: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
6009: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE5 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE5 = 'DATETIME') THEN
6010: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
6011: ELSE
6012: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

Line 6010: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;

6006: AND INSTR(l_ext_table_select,l_data_level_metadata_obj.PK_COLUMN_NAME5) = 0) THEN
6007: IF(l_data_level_metadata_obj.PK_COLUMN_TYPE5 = 'NUMBER') THEN
6008: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
6009: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE5 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE5 = 'DATETIME') THEN
6010: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
6011: ELSE
6012: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
6013: END IF;
6014: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.'||l_data_level_metadata_obj.PK_COLUMN_NAME5||','||wierd_constant||') '||

Line 6012: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;

6008: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM;
6009: ELSIF (l_data_level_metadata_obj.PK_COLUMN_TYPE5 = 'DATE' OR l_data_level_metadata_obj.PK_COLUMN_TYPE5 = 'DATETIME') THEN
6010: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_DATE;
6011: ELSE
6012: wierd_constant := EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_STR;
6013: END IF;
6014: l_ext_table_select := l_ext_table_select || ' AND NVL(EXTVL1.'||l_data_level_metadata_obj.PK_COLUMN_NAME5||','||wierd_constant||') '||
6015: ' = NVL(UAI1.'||l_data_level_metadata_obj.PK_COLUMN_NAME5||','||wierd_constant||')';
6016: END IF;

Line 6028: ' AND NVL(UAI1.DATA_LEVEL_ID,'||EGO_USER_ATTRS_BULK_PVT.G_NULL_TOKEN_NUM ||') = '||l_item_rev_dl_id ||

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 ||''')';
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;