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

Line 67: -- EGO_USER_ATTRS_DATA_PVT.Debug_Msg(msg , debug_level);

63: null;
64: -- IF (INSTR(msg, 'Insert_Default_Val_Rows') <> 0 ) THEN
65: -- sri_debug('EGOVBUAB '||msg);
66: -- END IF;
67: -- EGO_USER_ATTRS_DATA_PVT.Debug_Msg(msg , debug_level);
68:
69: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
70: IF NVL(FND_GLOBAL.conc_request_id, -1) <> -1 THEN
71:

Line 819: EGO_USER_ATTRS_DATA_PVT.Get_Err_Info_For_UK_Violation

815:
816: IF BITAND(error_rec.PROCESS_STATUS, G_PS_IDENTICAL_ROWS) <> 0 THEN
817:
818: /*
819: EGO_USER_ATTRS_DATA_PVT.Get_Err_Info_For_UK_Violation
820: (p_attr_group_metadata_obj IN -- EGO_ATTR_GROUP_METADATA_OBJ
821: ,p_attr_name_value_pairs IN -- EGO_USER_ATTR_DATA_TABLE
822: ,p_is_err_in_production_table => true -- boolean
823: ,x_unique_key_err_msg => l_err_msg_name

Line 826: EGO_USER_ATTRS_DATA_PVT.Get_Err_Info_For_UK_Not_Resp

822: ,p_is_err_in_production_table => true -- boolean
823: ,x_unique_key_err_msg => l_err_msg_name
824: ,x_token_table => l_err_token_table
825: );
826: EGO_USER_ATTRS_DATA_PVT.Get_Err_Info_For_UK_Not_Resp
827: (p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
828: ,p_is_err_in_production_table IN BOOLEAN
829: ,x_unique_key_err_msg OUT NOCOPY VARCHAR2
830: ,x_token_table OUT NOCOPY ERROR_HANDLER.Token_Tbl_Type

Line 1502: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);

1498:
1499: -- Initialize error handler
1500: IF FND_API.To_Boolean(p_init_error_handler) THEN
1501: ERROR_HANDLER.Initialize;
1502: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1503: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
1504: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);
1505: END IF;
1506: -- test the message initialization.

Line 1504: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);

1500: IF FND_API.To_Boolean(p_init_error_handler) THEN
1501: ERROR_HANDLER.Initialize;
1502: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1503: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
1504: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);
1505: END IF;
1506: -- test the message initialization.
1507: code_debug('Starting Bulk load concurrent program '||p_data_set_id, 0);
1508: END IF;

Line 1954: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);

1950:
1951: IF (FND_API.To_Boolean(p_init_error_handler)) THEN
1952:
1953: ERROR_HANDLER.Initialize();
1954: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1955:
1956: ---------------------------------------------------
1957: -- If we're debugging, we have to set up a Debug --
1958: -- session (unless our caller already did so) --

Line 1962: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(p_entity_id

1958: -- session (unless our caller already did so) --
1959: ---------------------------------------------------
1960: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
1961:
1962: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(p_entity_id
1963: ,p_entity_code
1964: ,p_debug_level);
1965:
1966: END IF;

Line 2303: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',

2299: l_dynamic_sql :=
2300: ' UPDATE '||p_interface_table_name||' UAI1
2301: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2302: DECODE(UAI1.TRANSACTION_TYPE,
2303: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
2304: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2305: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2306: WHERE UAI1.DATA_SET_ID = :data_set_id
2307: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type

Line 2304: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',

2300: ' UPDATE '||p_interface_table_name||' UAI1
2301: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2302: DECODE(UAI1.TRANSACTION_TYPE,
2303: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
2304: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2305: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2306: WHERE UAI1.DATA_SET_ID = :data_set_id
2307: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2308: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'

Line 2305: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')

2301: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2302: DECODE(UAI1.TRANSACTION_TYPE,
2303: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
2304: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2305: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2306: WHERE UAI1.DATA_SET_ID = :data_set_id
2307: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2308: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2309: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

Line 2309: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

2305: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2306: WHERE UAI1.DATA_SET_ID = :data_set_id
2307: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2308: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2309: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2310: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2311: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI1.ATTR_GROUP_INT_NAME
2312: AND APPLICATION_ID = '||p_application_id||'
2313: AND DESCRIPTIVE_FLEXFIELD_NAME = '''||p_attr_group_type||''') <> ''Y''

Line 2404: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,

2400: l_ext_table_select := l_ext_table_select||')';
2401:
2402: l_dynamic_sql := l_dynamic_sql||' AND '||l_ext_table_select||
2403: ' = DECODE(UAI2.TRANSACTION_TYPE,
2404: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
2405: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2406: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
2407:
2408: --------------------------------------------------------------------------

Line 2405: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,

2401:
2402: l_dynamic_sql := l_dynamic_sql||' AND '||l_ext_table_select||
2403: ' = DECODE(UAI2.TRANSACTION_TYPE,
2404: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
2405: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2406: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
2407:
2408: --------------------------------------------------------------------------
2409: -- We do the transaction_type validation only for user defined attributes,

Line 2406: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';

2402: l_dynamic_sql := l_dynamic_sql||' AND '||l_ext_table_select||
2403: ' = DECODE(UAI2.TRANSACTION_TYPE,
2404: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
2405: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2406: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
2407:
2408: --------------------------------------------------------------------------
2409: -- We do the transaction_type validation only for user defined attributes,
2410: -- for developer defined attributes the trans type is updated to UPDATE

Line 2431: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',

2427: l_dynamic_sql :=
2428: ' UPDATE '||p_interface_table_name||' UAI1
2429: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2430: DECODE(UAI1.TRANSACTION_TYPE,
2431: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2432: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2433: WHERE UAI1.DATA_SET_ID = :data_set_id
2434: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2435: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'

Line 2432: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')

2428: ' UPDATE '||p_interface_table_name||' UAI1
2429: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2430: DECODE(UAI1.TRANSACTION_TYPE,
2431: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2432: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2433: WHERE UAI1.DATA_SET_ID = :data_set_id
2434: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2435: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2436: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

Line 2436: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

2432: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2433: WHERE UAI1.DATA_SET_ID = :data_set_id
2434: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2435: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2436: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2437: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
2438: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2439: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI1.ATTR_GROUP_INT_NAME
2440: AND APPLICATION_ID = '||p_application_id||'

Line 2437: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''

2433: WHERE UAI1.DATA_SET_ID = :data_set_id
2434: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2435: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2436: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2437: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
2438: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2439: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI1.ATTR_GROUP_INT_NAME
2440: AND APPLICATION_ID = '||p_application_id||'
2441: AND DESCRIPTIVE_FLEXFIELD_NAME = :attr_group_type) <> ''Y''

Line 2450: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,

2446: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2447: AND (SELECT COUNT(*) FROM '|| l_ext_vl_name||'
2448: WHERE 1=1 '||l_concat_pk_cols_UAI2||'
2449: AND ROWNUM <2 ) = DECODE(UAI2.TRANSACTION_TYPE,
2450: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2451: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0)
2452: )';
2453: EXECUTE IMMEDIATE l_dynamic_sql
2454: USING p_data_Set_id, p_attr_group_type, p_attr_group_type, p_data_Set_id ;

Line 2451: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0)

2447: AND (SELECT COUNT(*) FROM '|| l_ext_vl_name||'
2448: WHERE 1=1 '||l_concat_pk_cols_UAI2||'
2449: AND ROWNUM <2 ) = DECODE(UAI2.TRANSACTION_TYPE,
2450: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2451: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0)
2452: )';
2453: EXECUTE IMMEDIATE l_dynamic_sql
2454: USING p_data_Set_id, p_attr_group_type, p_attr_group_type, p_data_Set_id ;
2455:

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

2471: l_dynamic_sql :=
2472: ' UPDATE '||p_interface_table_name||' UAI2
2473: SET UAI2.TRANSACTION_TYPE = DECODE('||l_ext_table_select||
2474: ',0,'''||
2475: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
2476: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2477: WHERE UAI2.DATA_SET_ID = :data_set_id
2478: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2479: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'

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

2472: ' UPDATE '||p_interface_table_name||' UAI2
2473: SET UAI2.TRANSACTION_TYPE = DECODE('||l_ext_table_select||
2474: ',0,'''||
2475: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
2476: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2477: WHERE UAI2.DATA_SET_ID = :data_set_id
2478: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2479: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2480: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

Line 2480: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

2476: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2477: WHERE UAI2.DATA_SET_ID = :data_set_id
2478: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2479: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2480: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2481: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2482: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI2.ATTR_GROUP_INT_NAME
2483: AND APPLICATION_ID = :application_id
2484: AND DESCRIPTIVE_FLEXFIELD_NAME = :attr_group_type) <> ''Y'' ';

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

2487: l_dynamic_sql :=
2488: ' UPDATE '||p_interface_table_name||' UAI2
2489: SET UAI2.TRANSACTION_TYPE = DECODE((SELECT COUNT(*) FROM '|| l_ext_vl_name ||' WHERE 1=1 '||l_concat_pk_cols_UAI2||' AND ROWNUM<2 )'||
2490: ',0,'''||
2491: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
2492: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2493: WHERE UAI2.DATA_SET_ID = :data_set_id
2494: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2495: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'

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

2488: ' UPDATE '||p_interface_table_name||' UAI2
2489: SET UAI2.TRANSACTION_TYPE = DECODE((SELECT COUNT(*) FROM '|| l_ext_vl_name ||' WHERE 1=1 '||l_concat_pk_cols_UAI2||' AND ROWNUM<2 )'||
2490: ',0,'''||
2491: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
2492: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2493: WHERE UAI2.DATA_SET_ID = :data_set_id
2494: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2495: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2496: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

Line 2496: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

2492: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2493: WHERE UAI2.DATA_SET_ID = :data_set_id
2494: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2495: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2496: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2497: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2498: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI2.ATTR_GROUP_INT_NAME
2499: AND APPLICATION_ID = :application_id
2500: AND DESCRIPTIVE_FLEXFIELD_NAME = :attr_group_type) <> ''Y'' ';

Line 4217: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',

4213: l_dynamic_sql :=
4214: ' UPDATE '||p_interface_table_name||' UAI1
4215: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
4216: DECODE(UAI1.TRANSACTION_TYPE,
4217: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
4218: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
4219: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||',0)
4220: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||
4221: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||

Line 4218: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',

4214: ' UPDATE '||p_interface_table_name||' UAI1
4215: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
4216: DECODE(UAI1.TRANSACTION_TYPE,
4217: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
4218: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
4219: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||',0)
4220: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||
4221: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
4222: ' AND UAI1.ATTR_GROUP_TYPE = '''||p_attr_group_type||''' '||

Line 4219: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||',0)

4215: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
4216: DECODE(UAI1.TRANSACTION_TYPE,
4217: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
4218: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
4219: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||',0)
4220: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||
4221: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
4222: ' AND UAI1.ATTR_GROUP_TYPE = '''||p_attr_group_type||''' '||
4223: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||

Line 4223: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||

4219: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||',0)
4220: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||
4221: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
4222: ' AND UAI1.ATTR_GROUP_TYPE = '''||p_attr_group_type||''' '||
4223: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||
4224: ''' AND UAI1.ATTR_GROUP_INT_NAME = '''||
4225: l_attr_group_metadata_obj.ATTR_GROUP_NAME||
4226: ''' AND UAI1.ROW_IDENTIFIER IN (
4227: SELECT DISTINCT UAI2.ROW_IDENTIFIER

Line 4234: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,

4230: ' AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS;
4231:
4232: l_dynamic_sql := l_dynamic_sql||' AND (SELECT COUNT(*) FROM '||l_ext_table_select||')
4233: = DECODE(UAI2.TRANSACTION_TYPE,
4234: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
4235: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
4236: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
4237:
4238: EXECUTE IMMEDIATE l_dynamic_sql;

Line 4235: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,

4231:
4232: l_dynamic_sql := l_dynamic_sql||' AND (SELECT COUNT(*) FROM '||l_ext_table_select||')
4233: = DECODE(UAI2.TRANSACTION_TYPE,
4234: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
4235: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
4236: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
4237:
4238: EXECUTE IMMEDIATE l_dynamic_sql;
4239: code_debug(' After transaction type validation ' ,2);

Line 4236: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';

4232: l_dynamic_sql := l_dynamic_sql||' AND (SELECT COUNT(*) FROM '||l_ext_table_select||')
4233: = DECODE(UAI2.TRANSACTION_TYPE,
4234: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
4235: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
4236: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
4237:
4238: EXECUTE IMMEDIATE l_dynamic_sql;
4239: code_debug(' After transaction type validation ' ,2);
4240:

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

4244: --------------------------------------------------
4245: l_dynamic_sql :=
4246: ' UPDATE '||p_interface_table_name||' UAI1
4247: SET UAI1.TRANSACTION_TYPE = DECODE((SELECT COUNT(*) FROM '||l_ext_table_select||'),0,'''||
4248: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
4249: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
4250: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||
4251: ' AND UAI1.ATTR_GROUP_INT_NAME = '''||l_attr_group_metadata_obj.ATTR_GROUP_NAME||
4252: ''' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||

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

4245: l_dynamic_sql :=
4246: ' UPDATE '||p_interface_table_name||' UAI1
4247: SET UAI1.TRANSACTION_TYPE = DECODE((SELECT COUNT(*) FROM '||l_ext_table_select||'),0,'''||
4248: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
4249: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
4250: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||
4251: ' AND UAI1.ATTR_GROUP_INT_NAME = '''||l_attr_group_metadata_obj.ATTR_GROUP_NAME||
4252: ''' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
4253: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''';

Line 4253: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''';

4249: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
4250: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||
4251: ' AND UAI1.ATTR_GROUP_INT_NAME = '''||l_attr_group_metadata_obj.ATTR_GROUP_NAME||
4252: ''' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
4253: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''';
4254:
4255: EXECUTE IMMEDIATE l_dynamic_sql;
4256:
4257: code_debug(' After transaction type updation ' ,2);

Line 4295: :default_value,'''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','|| l_concat_pk_cols_sel ||'

4291: ATTR_VALUE_NUM ,
4292: TRANSACTION_TYPE ,'||l_concat_pk_cols_sel||'
4293: ATTR_GROUP_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
4294: SELECT MAX(TRANSACTION_ID),'||G_PS_IN_PROCESS||',DATA_SET_ID,ROW_IDENTIFIER,:attr_group_int_name,:attr_internal_name,
4295: :default_value,'''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','|| l_concat_pk_cols_sel ||'
4296: ATTR_GROUP_ID,MAX(CREATED_BY),SYSDATE,MAX(LAST_UPDATED_BY),SYSDATE
4297: FROM '||p_interface_table_name||' A
4298: WHERE NOT EXISTS (
4299: SELECT NULL

Line 4310: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''

4306: AND DATA_SET_ID = :data_set_id
4307: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
4308: AND PROCESS_STATUS = '||G_PS_IN_PROCESS|| '
4309: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
4310: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
4311: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
4312: DBMS_SQL.Parse(l_default_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4313: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':data_set_id', p_data_set_id);
4314: END IF;

Line 4345: :default_value,'''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','|| l_concat_pk_cols_sel ||'

4341: ATTR_VALUE_DATE ,
4342: TRANSACTION_TYPE ,'||l_concat_pk_cols_sel||'
4343: ATTR_GROUP_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
4344: SELECT MAX(TRANSACTION_ID),'||G_PS_IN_PROCESS||',DATA_SET_ID,ROW_IDENTIFIER,:attr_group_int_name,:attr_internal_name,
4345: :default_value,'''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','|| l_concat_pk_cols_sel ||'
4346: ATTR_GROUP_ID,MAX(CREATED_BY),SYSDATE,MAX(LAST_UPDATED_BY),SYSDATE
4347: FROM '||p_interface_table_name||' A
4348: WHERE NOT EXISTS (
4349: SELECT NULL

Line 4360: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''

4356: AND DATA_SET_ID = :data_set_id
4357: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
4358: AND PROCESS_STATUS = '||G_PS_IN_PROCESS|| '
4359: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
4360: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
4361: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
4362: DBMS_SQL.Parse(l_default_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4363: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':data_set_id', p_data_set_id);
4364: END IF;

Line 4396: :default_value,'''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','|| l_concat_pk_cols_sel ||'

4392: ATTR_VALUE_STR ,
4393: TRANSACTION_TYPE ,'||l_concat_pk_cols_sel||'
4394: ATTR_GROUP_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
4395: SELECT MAX(TRANSACTION_ID),'||G_PS_IN_PROCESS||',DATA_SET_ID,ROW_IDENTIFIER,:attr_group_int_name,:attr_internal_name,
4396: :default_value,'''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','|| l_concat_pk_cols_sel ||'
4397: ATTR_GROUP_ID,MAX(CREATED_BY),SYSDATE,MAX(LAST_UPDATED_BY),SYSDATE
4398: FROM '||p_interface_table_name||' A
4399: WHERE NOT EXISTS (
4400: SELECT NULL

Line 4411: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''

4407: AND DATA_SET_ID = :data_set_id
4408: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
4409: AND PROCESS_STATUS = '||G_PS_IN_PROCESS|| '
4410: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
4411: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
4412: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
4413: DBMS_SQL.Parse(l_default_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
4414: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':data_set_id', p_data_set_id);
4415: END IF;

Line 5210: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||'''';

5206: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post || ' FROM '||p_interface_table_name||' UAI1 ';
5207: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post || ' WHERE UAI1.DATA_SET_ID = :data_set_id '||
5208: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
5209: ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
5210: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||'''';
5211: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post || ' GROUP BY UAI1.ATTR_GROUP_INT_NAME, UAI1.TRANSACTION_TYPE, UAI1.ROW_IDENTIFIER ';
5212:
5213: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post ||' '|| l_dynamic_group_by;
5214: */

Line 5236: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';

5232: l_dynamic_sql := l_dynamic_sql ||' AND UAI1.DATA_SET_ID = :data_set_id '||
5233: ' AND UAI1.PROCESS_STATUS <> '||G_PS_GENERIC_ERROR||
5234: ' AND UAI1.PROCESS_STATUS <> '||G_PS_SUCCESS||
5235: ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
5236: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';
5237: --l_dynamic_sql_1 := l_dynamic_sql_1 ||' AND UAI1.DATA_SET_ID = :data_set_id '||
5238: -- ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
5239: -- ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
5240: -- ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||'''';

Line 5240: -- ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||'''';

5236: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';
5237: --l_dynamic_sql_1 := l_dynamic_sql_1 ||' AND UAI1.DATA_SET_ID = :data_set_id '||
5238: -- ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
5239: -- ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
5240: -- ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||'''';
5241:
5242: l_dynamic_sql := l_dynamic_sql || l_deflatening_sql_where;
5243: l_dynamic_sql := l_dynamic_sql || ' ' || l_group_by_pre || l_dynamic_group_by;
5244:

Line 5349: WHILE (INSTR(l_attr_name_val_str,'#') <> 0 AND l_ag_deflatened_row.TRANSACTION_TYPE <> EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE)

5345: -- Loop through the deflatened string containing the old and new values and
5346: -- prepare the table to be passed in as a parameter to pre-event
5347: l_attr_name_val_str := l_ag_deflatened_row.ATTR_NAME_VALUES;
5348: attr_name_val_pair := EGO_ATTR_TABLE();
5349: WHILE (INSTR(l_attr_name_val_str,'#') <> 0 AND l_ag_deflatened_row.TRANSACTION_TYPE <> EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE)
5350: LOOP
5351: l_attr_name := SUBSTR(l_attr_name_val_str
5352: ,INSTR(l_attr_name_val_str,'#*')+2
5353: ,INSTR(l_attr_name_val_str,'*#')-INSTR(l_attr_name_val_str,'#*')-2

Line 5505: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';

5501: l_dynamic_sql := l_dynamic_sql || ' WHERE UAI1.DATA_SET_ID = :data_set_id '||
5502: ' AND UAI1.PROCESS_STATUS <> '||G_PS_GENERIC_ERROR||
5503: ' AND UAI1.PROCESS_STATUS <> '||G_PS_SUCCESS||
5504: ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
5505: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';
5506: l_dynamic_sql := l_dynamic_sql || ' GROUP BY UAI1.ATTR_GROUP_INT_NAME, UAI1.TRANSACTION_TYPE, UAI1.ROW_IDENTIFIER '
5507: || l_dynamic_group_by;
5508:
5509: -------------------------------------------------------------------

Line 5941: '= DECODE (RTCQ.TRANSACTION_TYPE, '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''' , '||

5937: --where EXT is the actual EXT base table, hence we need to build a seperate where clause for identical check
5938: --i.e. l_rtcq_to_ext_whr_uks_idnt_chk.
5939: l_rtcq_to_ext_where_uks := l_rtcq_to_ext_where_uks||
5940: ' AND NVL(RTCQ.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||','||wierd_constant||')'||
5941: '= DECODE (RTCQ.TRANSACTION_TYPE, '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''' , '||
5942: 'NVL((SELECT NVL(RTCQ.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||','||wierd_constant||') FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM '||
5943: l_ext_tl_table_name||' WHERE EXTENSION_ID = EXT.EXTENSION_ID AND ROWNUM = 1 )), '||wierd_constant_2||' ) '||
5944: ',NVL((SELECT '||l_attr_metadata_table_sr(d).DATABASE_COLUMN || ' FROM '||l_ext_tl_table_name||' WHERE LANGUAGE = USERENV(''LANG'') AND EXTENSION_ID = EXT.EXTENSION_ID),'||wierd_constant||' ) '||
5945: ')';

Line 5979: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',DECODE(ATTR_VALUE_NUM,'||wierd_constant||',NULL,ATTR_VALUE_NUM), ATTR_VALUE_NUM)';

5975: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
5976: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5977:
5978: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
5979: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',DECODE(ATTR_VALUE_NUM,'||wierd_constant||',NULL,ATTR_VALUE_NUM), ATTR_VALUE_NUM)';
5980: -- ...this closes what started above
5981: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||')) '||
5982: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
5983:

Line 5988: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',DECODE(ATTR_VALUE_UOM,'||G_NULL_TOKEN_STR||',NULL,ATTR_VALUE_UOM), ATTR_VALUE_UOM)';

5984: IF (l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_CLASS IS NOT NULL) THEN
5985: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
5986: ',MAX(DECODE(RN,'||l_rn_index_for_ag||',';
5987: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
5988: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',DECODE(ATTR_VALUE_UOM,'||G_NULL_TOKEN_STR||',NULL,ATTR_VALUE_UOM), ATTR_VALUE_UOM)';
5989: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||')) '||
5990: l_attr_metadata_table_sr(d).DATABASE_COLUMN||'_UOM';
5991: END IF;
5992:

Line 6046: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''',ATTR_VALUE_DATE,TO_DATE(DECODE(ATTR_VALUE_DATE,'||wierd_constant||

6042:
6043: --Bug 4473391(gnanda) : we need to convert the attr_value_date to char in the decode and then convert the final value into
6044: --date otherwise decode would remove the time part from date time attribute.
6045: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
6046: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''',ATTR_VALUE_DATE,TO_DATE(DECODE(ATTR_VALUE_DATE,'||wierd_constant||
6047: ',NULL,TO_CHAR(ATTR_VALUE_DATE,''DD/MM/YYYY HH24:MI:SS'')),''DD/MM/YYYY HH24:MI:SS'') )';
6048: -- ...this closes what started above
6049: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||')) '||
6050: l_attr_metadata_table_sr(d).DATABASE_COLUMN;

Line 6075: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',DECODE(ATTR_VALUE_STR,'||wierd_constant||',NULL,ATTR_VALUE_STR), ATTR_VALUE_STR)';

6071: END IF;
6072: ELSE
6073:
6074: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
6075: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',DECODE(ATTR_VALUE_STR,'||wierd_constant||',NULL,ATTR_VALUE_STR), ATTR_VALUE_STR)';
6076: -- ...this closes what started above
6077: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||')) '||
6078: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
6079:

Line 6376: SET TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||'''

6372: USING p_data_Set_id, p_attr_group_type;
6373: code_debug(' After DML for inserting dummy rows for dev defined attrs.'||l_dynamic_Sql,2);
6374: EXECUTE IMMEDIATE
6375: 'UPDATE '||p_interface_table_name||' UAI1
6376: SET TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||'''
6377: WHERE UAI1.DATA_SET_ID = :data_set_id
6378: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
6379: AND ATTR_GROUP_INT_NAME = :attr_grp_int_name
6380: AND ATTR_GROUP_TYPE = :attr_group_type '

Line 6411: EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||

6407: ' EXT, ('||l_row_to_column_query||') RTCQ WHERE 1=1'||
6408: l_rtcq_to_ext_where_base||
6409: l_rtcq_to_ext_where_uks||
6410: ' AND RTCQ.TRANSACTION_TYPE='''||
6411: EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||
6412: '''; IF (ext_id_tbl.COUNT > 0) THEN
6413: FORALL i IN ext_id_tbl.FIRST .. ext_id_tbl.LAST
6414: DELETE FROM '||l_ext_b_table_name||' EXT
6415: WHERE '||l_db_col_tbl_where_ext_id||

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

6480: ' EXT, ('||l_row_to_column_query||') RTCQ WHERE 1=1'||
6481: l_rtcq_to_ext_where_base||
6482: l_rtcq_to_ext_where_uks||
6483: ' AND RTCQ.TRANSACTION_TYPE='''||
6484: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''' )'||
6485: ' UNION '||
6486: '(SELECT INTF_TL.LANGUAGE LANGUAGE, '|| --Added the following UNIONED Query for R12C.. this wud bring bak
6487: ' INTFRTCQ.EXTENSION_ID EXTENSION_ID '|| --the results from the intf_tl table as well for updating records
6488: l_rtcq_alias_b_cols_list_1 || --in other languages. We assume that the Row_identifier in the itnf table

Line 6500: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''''||

6496: ' EXT, ('||l_row_to_column_query||') RTCQ WHERE 1=1'||
6497: l_rtcq_to_ext_where_base||
6498: l_rtcq_to_ext_where_uks||
6499: ' AND RTCQ.TRANSACTION_TYPE='''||
6500: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''''||
6501: ' ) INTFRTCQ '||
6502: 'WHERE INTF_TL.SET_PROCESS_ID = :data_set_id '||
6503: ' AND UPPER(INTF_TL.TABLE_NAME) = '''||UPPER(p_interface_table_name)||''' '||
6504: ' AND INTF_TL.UNIQUE_ID = INTFRTCQ.ROW_IDENTIFIER ) ;';

Line 6646: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';

6642: :current_login_id'||
6643: l_no_alias_b_values_list||
6644: ' FROM ('||l_row_to_column_query||') RTCQ
6645: WHERE RTCQ.TRANSACTION_TYPE = '''||
6646: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';
6647:
6648: code_debug(' Before Inserting into B table ' ,2);
6649: code_debug(' B table Insert DML for AG '||l_attr_group_metadata_obj.ATTR_GROUP_NAME ,3);
6650: code_debug(' :--:'||l_dynamic_sql ,3);

Line 6729: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';

6725: AND L.INSTALLED_FLAG IN (''I'', ''B'')'||
6726: l_rtcq_to_ext_where_base||
6727: l_rtcq_to_ext_where_uks||
6728: ' AND RTCQ.TRANSACTION_TYPE='''||
6729: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';
6730:
6731: code_debug(' TL table Insert DML for AG '||l_attr_group_metadata_obj.ATTR_GROUP_NAME ,3);
6732: code_debug(' :--:'||l_dynamic_sql ,3);
6733:

Line 8655: ' ,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''' '||--TRANSACTION_TYPE

8651: code_debug(l_api_name ||' l_inner_pk_cc_dl_col_list '|| l_inner_pk_cc_dl_col_list );
8652: code_debug(l_api_name ||' l_dynamic_sql '||l_dynamic_sql);
8653:
8654: l_dynamic_sql := l_dynamic_sql ||
8655: ' ,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''' '||--TRANSACTION_TYPE
8656: ' ,ENTITYAG_TBL.ATTR_GROUP_ID '||--ATTR_GROUP_ID
8657: ' ,ENTITYAG_TBL.TRANSACTION_ID '||--TRANSACTION_ID
8658: ' ,:current_user_id '||--CREATED_BY
8659: ' ,SYSDATE '||--CREATION_DATE

Line 8760: l_object_id := EGO_USER_ATTRS_DATA_PVT.Get_Object_Id_From_Name(p_object_name);

8756:
8757: l_dynamic_sql := ' INSERT INTO '||p_interface_table_name||
8758: ' ( '||l_col_to_insert_list ||' ) '||
8759: l_dynamic_sql;
8760: l_object_id := EGO_USER_ATTRS_DATA_PVT.Get_Object_Id_From_Name(p_object_name);
8761:
8762: code_debug(l_api_name ||' Final SQL ');
8763: code_debug(l_api_name ||l_dynamic_sql);
8764: code_debug(l_api_name ||'params 1: '||p_data_Set_id||' 2: '||FND_GLOBAL.CONC_REQUEST_ID||