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 820: EGO_USER_ATTRS_DATA_PVT.Get_Err_Info_For_UK_Violation

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

Line 827: EGO_USER_ATTRS_DATA_PVT.Get_Err_Info_For_UK_Not_Resp

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

Line 1212: AND '||l_data_type_clause||' IS NOT NULL AND TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''''; -- bug 13774267

1208: AND (PROCESS_STATUS = '||G_PS_IN_PROCESS||' OR PROCESS_STATUS > '||G_PS_BAD_ATTR_OR_AG_METADATA||' )
1209: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
1210: AND ATTR_INT_NAME = '''||p_attr_name||'''
1211: AND ATTR_GROUP_INT_NAME = '''||p_attr_group_name||'''
1212: AND '||l_data_type_clause||' IS NOT NULL AND TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''''; -- bug 13774267
1213: /*
1214: No need to check attribute value against value set in case of Delete. The check is skipped only for ATTR_VALUE*.
1215: The validation need to be done if the user passes ATTR_DISP_VALUE. hence didn't add the condition for l_dynamic_sql_v_type
1216: */

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

1812:
1813: -- Initialize error handler
1814: IF FND_API.To_Boolean(p_init_error_handler) THEN
1815: ERROR_HANDLER.Initialize;
1816: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1817: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
1818: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);
1819: END IF;
1820: -- test the message initialization.

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

1814: IF FND_API.To_Boolean(p_init_error_handler) THEN
1815: ERROR_HANDLER.Initialize;
1816: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1817: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
1818: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);
1819: END IF;
1820: -- test the message initialization.
1821: code_debug('Starting Bulk load concurrent program '||p_data_set_id, 0);
1822: END IF;

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

2265:
2266: IF (FND_API.To_Boolean(p_init_error_handler)) THEN
2267:
2268: ERROR_HANDLER.Initialize();
2269: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
2270:
2271: ---------------------------------------------------
2272: -- If we're debugging, we have to set up a Debug --
2273: -- session (unless our caller already did so) --

Line 2277: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(p_entity_id

2273: -- session (unless our caller already did so) --
2274: ---------------------------------------------------
2275: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
2276:
2277: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(p_entity_id
2278: ,p_entity_code
2279: ,p_debug_level);
2280:
2281: END IF;

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

2619: l_dynamic_sql :=
2620: ' UPDATE '||p_interface_table_name||' UAI1
2621: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2622: DECODE(UAI1.TRANSACTION_TYPE,
2623: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
2624: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2625: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2626: WHERE UAI1.DATA_SET_ID = :data_set_id
2627: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type

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

2620: ' UPDATE '||p_interface_table_name||' UAI1
2621: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2622: DECODE(UAI1.TRANSACTION_TYPE,
2623: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
2624: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2625: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2626: WHERE UAI1.DATA_SET_ID = :data_set_id
2627: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2628: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'

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

2621: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2622: DECODE(UAI1.TRANSACTION_TYPE,
2623: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
2624: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2625: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2626: WHERE UAI1.DATA_SET_ID = :data_set_id
2627: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2628: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2629: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

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

2625: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2626: WHERE UAI1.DATA_SET_ID = :data_set_id
2627: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2628: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2629: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2630: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2631: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI1.ATTR_GROUP_INT_NAME
2632: AND APPLICATION_ID = '||p_application_id||'
2633: AND DESCRIPTIVE_FLEXFIELD_NAME = '''||p_attr_group_type||''') <> ''Y''

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

2732: WHERE UAI2.DATA_SET_ID = :data_set_id
2733: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2734: AND '||l_ext_table_select||'
2735: = DECODE(UAI2.TRANSACTION_TYPE,
2736: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
2737: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2738: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0); '||
2739: '
2740: IF (l_row_ids.Count > 0) THEN

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

2733: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2734: AND '||l_ext_table_select||'
2735: = DECODE(UAI2.TRANSACTION_TYPE,
2736: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
2737: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2738: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0); '||
2739: '
2740: IF (l_row_ids.Count > 0) THEN
2741: FORALL i in l_row_ids.FIRST .. l_row_ids.LAST

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

2734: AND '||l_ext_table_select||'
2735: = DECODE(UAI2.TRANSACTION_TYPE,
2736: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
2737: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2738: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0); '||
2739: '
2740: IF (l_row_ids.Count > 0) THEN
2741: FORALL i in l_row_ids.FIRST .. l_row_ids.LAST
2742: UPDATE '||p_interface_table_name||' UAI1

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

2741: FORALL i in l_row_ids.FIRST .. l_row_ids.LAST
2742: UPDATE '||p_interface_table_name||' UAI1
2743: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2744: DECODE(UAI1.TRANSACTION_TYPE,
2745: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
2746: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2747: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2748: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||'
2749: AND UAI1.ATTR_GROUP_TYPE = '''||p_attr_group_type||'''

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

2742: UPDATE '||p_interface_table_name||' UAI1
2743: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2744: DECODE(UAI1.TRANSACTION_TYPE,
2745: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
2746: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2747: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2748: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||'
2749: AND UAI1.ATTR_GROUP_TYPE = '''||p_attr_group_type||'''
2750: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'

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

2743: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2744: DECODE(UAI1.TRANSACTION_TYPE,
2745: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
2746: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2747: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2748: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||'
2749: AND UAI1.ATTR_GROUP_TYPE = '''||p_attr_group_type||'''
2750: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2751: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

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

2747: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2748: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||'
2749: AND UAI1.ATTR_GROUP_TYPE = '''||p_attr_group_type||'''
2750: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2751: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2752: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2753: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI1.ATTR_GROUP_INT_NAME
2754: AND APPLICATION_ID = '||p_application_id||'
2755: AND DESCRIPTIVE_FLEXFIELD_NAME = '''||p_attr_group_type||''') <> ''Y''

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

2762: -- Bug 9336604 : Start - Commenting
2763: /*
2764: l_dynamic_sql := l_dynamic_sql||' AND '||l_ext_table_select||
2765: ' = DECODE(UAI2.TRANSACTION_TYPE,
2766: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
2767: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2768: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
2769: */
2770: -- Bug 9336604 : End - Commenting

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

2763: /*
2764: l_dynamic_sql := l_dynamic_sql||' AND '||l_ext_table_select||
2765: ' = DECODE(UAI2.TRANSACTION_TYPE,
2766: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
2767: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2768: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
2769: */
2770: -- Bug 9336604 : End - Commenting
2771:

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

2764: l_dynamic_sql := l_dynamic_sql||' AND '||l_ext_table_select||
2765: ' = DECODE(UAI2.TRANSACTION_TYPE,
2766: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
2767: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2768: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
2769: */
2770: -- Bug 9336604 : End - Commenting
2771:
2772: --------------------------------------------------------------------------

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

2802: l_dynamic_sql :=
2803: ' UPDATE '||p_interface_table_name||' UAI1
2804: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2805: DECODE(UAI1.TRANSACTION_TYPE,
2806: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2807: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2808: WHERE UAI1.DATA_SET_ID = :data_set_id
2809: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2810: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'

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

2803: ' UPDATE '||p_interface_table_name||' UAI1
2804: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
2805: DECODE(UAI1.TRANSACTION_TYPE,
2806: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
2807: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2808: WHERE UAI1.DATA_SET_ID = :data_set_id
2809: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2810: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2811: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

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

2807: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||')
2808: WHERE UAI1.DATA_SET_ID = :data_set_id
2809: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2810: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2811: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2812: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
2813: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2814: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI1.ATTR_GROUP_INT_NAME
2815: AND APPLICATION_ID = '||p_application_id||'

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

2808: WHERE UAI1.DATA_SET_ID = :data_set_id
2809: AND UAI1.ATTR_GROUP_TYPE = :attr_group_type
2810: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2811: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2812: AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
2813: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2814: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI1.ATTR_GROUP_INT_NAME
2815: AND APPLICATION_ID = '||p_application_id||'
2816: AND DESCRIPTIVE_FLEXFIELD_NAME = :attr_group_type) <> ''Y''

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

2821: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2822: AND (SELECT COUNT(*) FROM '|| l_ext_vl_name||'
2823: WHERE 1=1 '||l_concat_pk_cols_UAI2||'
2824: AND ROWNUM <2 ) = DECODE(UAI2.TRANSACTION_TYPE,
2825: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2826: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0)
2827: )';
2828: EXECUTE IMMEDIATE l_dynamic_sql
2829: USING p_data_Set_id, p_attr_group_type, p_attr_group_type, p_data_Set_id ;

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

2822: AND (SELECT COUNT(*) FROM '|| l_ext_vl_name||'
2823: WHERE 1=1 '||l_concat_pk_cols_UAI2||'
2824: AND ROWNUM <2 ) = DECODE(UAI2.TRANSACTION_TYPE,
2825: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
2826: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0)
2827: )';
2828: EXECUTE IMMEDIATE l_dynamic_sql
2829: USING p_data_Set_id, p_attr_group_type, p_attr_group_type, p_data_Set_id ;
2830:

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

2860: /*
2861: ' UPDATE '||p_interface_table_name||' UAI2
2862: SET UAI2.TRANSACTION_TYPE = DECODE('||l_ext_table_select||
2863: ',0,'''||
2864: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
2865: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2866: WHERE UAI2.DATA_SET_ID = :data_set_id
2867: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2868: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'

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

2861: ' UPDATE '||p_interface_table_name||' UAI2
2862: SET UAI2.TRANSACTION_TYPE = DECODE('||l_ext_table_select||
2863: ',0,'''||
2864: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
2865: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2866: WHERE UAI2.DATA_SET_ID = :data_set_id
2867: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2868: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2869: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

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

2865: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2866: WHERE UAI2.DATA_SET_ID = :data_set_id
2867: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2868: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2869: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2870: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2871: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI2.ATTR_GROUP_INT_NAME
2872: AND APPLICATION_ID = :application_id
2873: AND DESCRIPTIVE_FLEXFIELD_NAME = :attr_group_type) <> ''Y'' ';

Line 2878: SET UAI2.TRANSACTION_TYPE = Nvl(( SELECT '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||'''

2874: */ -- Tesco - Bug Commenting Done
2875:
2876: /* Bug 13414358 - Start */
2877: ' UPDATE '||p_interface_table_name||' UAI2
2878: SET UAI2.TRANSACTION_TYPE = Nvl(( SELECT '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||'''
2879: FROM DUAL
2880: WHERE EXISTS '||l_ext_table_select1||
2881: '), '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''')
2882: WHERE UAI2.DATA_SET_ID = :data_set_id

Line 2881: '), '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''')

2877: ' UPDATE '||p_interface_table_name||' UAI2
2878: SET UAI2.TRANSACTION_TYPE = Nvl(( SELECT '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||'''
2879: FROM DUAL
2880: WHERE EXISTS '||l_ext_table_select1||
2881: '), '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''')
2882: WHERE UAI2.DATA_SET_ID = :data_set_id
2883: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2884: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2885: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

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

2881: '), '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''')
2882: WHERE UAI2.DATA_SET_ID = :data_set_id
2883: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2884: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2885: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2886: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2887: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI2.ATTR_GROUP_INT_NAME
2888: AND APPLICATION_ID = :application_id
2889: AND DESCRIPTIVE_FLEXFIELD_NAME = :attr_group_type) <> ''Y'' ';

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

2901: l_dynamic_sql :=
2902: ' UPDATE '||p_interface_table_name||' UAI2
2903: SET UAI2.TRANSACTION_TYPE = DECODE((SELECT COUNT(*) FROM '|| l_ext_vl_name ||' WHERE 1=1 '||l_concat_pk_cols_UAI2||' AND ROWNUM<2 )'||
2904: ',0,'''||
2905: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
2906: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2907: WHERE UAI2.DATA_SET_ID = :data_set_id
2908: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2909: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'

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

2902: ' UPDATE '||p_interface_table_name||' UAI2
2903: SET UAI2.TRANSACTION_TYPE = DECODE((SELECT COUNT(*) FROM '|| l_ext_vl_name ||' WHERE 1=1 '||l_concat_pk_cols_UAI2||' AND ROWNUM<2 )'||
2904: ',0,'''||
2905: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
2906: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2907: WHERE UAI2.DATA_SET_ID = :data_set_id
2908: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2909: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2910: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''

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

2906: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
2907: WHERE UAI2.DATA_SET_ID = :data_set_id
2908: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type
2909: AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
2910: AND UAI2.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''
2911: AND (SELECT MULTI_ROW FROM EGO_FND_DSC_FLX_CTX_EXT FLX_EXT
2912: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = UAI2.ATTR_GROUP_INT_NAME
2913: AND APPLICATION_ID = :application_id
2914: AND DESCRIPTIVE_FLEXFIELD_NAME = :attr_group_type) <> ''Y'' ';

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

5073: l_dynamic_sql :=
5074: ' UPDATE /*+ INDEX(UAI1,EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */ '||p_interface_table_name||' UAI1
5075: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
5076: DECODE(UAI1.TRANSACTION_TYPE,
5077: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
5078: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
5079: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||',0)
5080: WHERE UAI1.DATA_SET_ID = :data_set_id '||--p_data_set_id||
5081: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||

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

5074: ' UPDATE /*+ INDEX(UAI1,EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */ '||p_interface_table_name||' UAI1
5075: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
5076: DECODE(UAI1.TRANSACTION_TYPE,
5077: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
5078: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
5079: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||',0)
5080: WHERE UAI1.DATA_SET_ID = :data_set_id '||--p_data_set_id||
5081: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
5082: ' AND UAI1.ATTR_GROUP_TYPE = '''||p_attr_group_type||''' '||

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

5075: SET UAI1.PROCESS_STATUS = PROCESS_STATUS +
5076: DECODE(UAI1.TRANSACTION_TYPE,
5077: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', '||G_PS_BAD_TTYPE_CREATE||',
5078: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', '||G_PS_BAD_TTYPE_UPDATE||',
5079: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||',0)
5080: WHERE UAI1.DATA_SET_ID = :data_set_id '||--p_data_set_id||
5081: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
5082: ' AND UAI1.ATTR_GROUP_TYPE = '''||p_attr_group_type||''' '||
5083: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||

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

5079: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', '||G_PS_BAD_TTYPE_DELETE||',0)
5080: WHERE UAI1.DATA_SET_ID = :data_set_id '||--p_data_set_id||
5081: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
5082: ' AND UAI1.ATTR_GROUP_TYPE = '''||p_attr_group_type||''' '||
5083: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||
5084: ''' AND UAI1.ATTR_GROUP_INT_NAME = '''||
5085: l_attr_group_metadata_obj.ATTR_GROUP_NAME||
5086: ''' AND UAI1.ROW_IDENTIFIER IN (
5087: SELECT DISTINCT UAI2.ROW_IDENTIFIER

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

5090: ' AND UAI2.PROCESS_STATUS = '||G_PS_IN_PROCESS;
5091:
5092: l_dynamic_sql := l_dynamic_sql||' AND (SELECT COUNT(*) FROM '||l_ext_table_select||')
5093: = DECODE(UAI2.TRANSACTION_TYPE,
5094: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
5095: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
5096: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
5097:
5098: EXECUTE IMMEDIATE l_dynamic_sql

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

5091:
5092: l_dynamic_sql := l_dynamic_sql||' AND (SELECT COUNT(*) FROM '||l_ext_table_select||')
5093: = DECODE(UAI2.TRANSACTION_TYPE,
5094: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
5095: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
5096: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
5097:
5098: EXECUTE IMMEDIATE l_dynamic_sql
5099: USING p_data_set_id, p_data_set_id;/*Fix for bug#9678667. Literal to bind*/

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

5092: l_dynamic_sql := l_dynamic_sql||' AND (SELECT COUNT(*) FROM '||l_ext_table_select||')
5093: = DECODE(UAI2.TRANSACTION_TYPE,
5094: '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''', 1,
5095: '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''', 0,
5096: '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||''', 0))';
5097:
5098: EXECUTE IMMEDIATE l_dynamic_sql
5099: USING p_data_set_id, p_data_set_id;/*Fix for bug#9678667. Literal to bind*/
5100: code_debug(' After transaction type validation ' ,2);

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

5105: --------------------------------------------------
5106: l_dynamic_sql :=
5107: ' UPDATE '||p_interface_table_name||' UAI1
5108: SET UAI1.TRANSACTION_TYPE = DECODE((SELECT COUNT(*) FROM '||l_ext_table_select||'),0,'''||
5109: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
5110: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
5111: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||
5112: ' AND UAI1.ATTR_GROUP_INT_NAME = '''||l_attr_group_metadata_obj.ATTR_GROUP_NAME||
5113: ''' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||

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

5106: l_dynamic_sql :=
5107: ' UPDATE '||p_interface_table_name||' UAI1
5108: SET UAI1.TRANSACTION_TYPE = DECODE((SELECT COUNT(*) FROM '||l_ext_table_select||'),0,'''||
5109: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','''||
5110: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
5111: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||
5112: ' AND UAI1.ATTR_GROUP_INT_NAME = '''||l_attr_group_metadata_obj.ATTR_GROUP_NAME||
5113: ''' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
5114: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''';

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

5110: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''')
5111: WHERE UAI1.DATA_SET_ID = '||p_data_set_id||
5112: ' AND UAI1.ATTR_GROUP_INT_NAME = '''||l_attr_group_metadata_obj.ATTR_GROUP_NAME||
5113: ''' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
5114: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||'''';
5115:
5116: --ER 9489112, do not convert SYNC to CREATE/UPDATE for item rev level Multi Row UDA when change order be created
5117: --Current UDA chanage be put in change order controll since rev level UDA will defaulted from
5118: --current revision when new revision created. rev level UDA defauled when the new revision

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

5207: NULL),
5208: DECODE(ATTR_EXT.DATA_TYPE, ''X'', EGO_USER_ATTRS_BULK_PVT.GET_DATE(FL_COL.DEFAULT_VALUE, NULL),
5209: ''Y'', EGO_USER_ATTRS_BULK_PVT.GET_DATE(FL_COL.DEFAULT_VALUE, NULL),
5210: NULL),
5211: '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',
5212: '|| l_concat_pk_cols_sel ||'
5213: ATTR_GROUP_ID,
5214: FND_GLOBAL.USER_ID,
5215: SYSDATE,

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

5226: WHERE DATA_SET_ID = :data_set_id
5227: AND PROCESS_STATUS = '||G_PS_IN_PROCESS|| '
5228: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
5229: AND Bitand(PROCESS_STATUS, 64) = 0
5230: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
5231: AND ATTR_GROUP_TYPE = :attr_group_type
5232: GROUP BY DATA_SET_ID,
5233: ROW_IDENTIFIER,
5234: ATTR_GROUP_INT_NAME,

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

5298: TRANSACTION_TYPE ,'||l_concat_pk_cols_sel||'
5299: ATTR_GROUP_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
5300: SELECT /*+ index(A,EGO_ITM_USR_ATTR_INTRFC_N1) */ /* Fix for bug#9678667 */
5301: /* Bug 9678667 MAX(TRANSACTION_ID),'||G_PS_IN_PROCESS||',DATA_SET_ID,ROW_IDENTIFIER,:attr_group_int_name,:attr_internal_name,
5302: :default_value,'''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','|| l_concat_pk_cols_sel ||'
5303: ATTR_GROUP_ID,MAX(CREATED_BY),SYSDATE,MAX(LAST_UPDATED_BY),SYSDATE
5304: FROM '||p_interface_table_name||' A
5305: WHERE NOT EXISTS (
5306: SELECT /*+ no_unnest index(B,EGO_ITM_USR_ATTR_INTRFC_U1) */ /* Fix for bug#9678667 */

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

5314: AND DATA_SET_ID = :data_set_id
5315: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
5316: AND PROCESS_STATUS = '||G_PS_IN_PROCESS|| '
5317: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
5318: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
5319: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
5320: DBMS_SQL.Parse(l_default_num_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5321: DBMS_SQL.Bind_Variable(l_default_num_cursor_id, ':data_set_id', p_data_set_id);
5322: END IF;

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

5350: TRANSACTION_TYPE ,'||l_concat_pk_cols_sel||'
5351: ATTR_GROUP_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
5352: SELECT /*+ index(A,EGO_ITM_USR_ATTR_INTRFC_N1) */ /* Fix for bug#9678667 */
5353: /* Bug 9678667 MAX(TRANSACTION_ID),'||G_PS_IN_PROCESS||',DATA_SET_ID,ROW_IDENTIFIER,:attr_group_int_name,:attr_internal_name,
5354: :default_value,'''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','|| l_concat_pk_cols_sel ||'
5355: ATTR_GROUP_ID,MAX(CREATED_BY),SYSDATE,MAX(LAST_UPDATED_BY),SYSDATE
5356: FROM '||p_interface_table_name||' A
5357: WHERE NOT EXISTS (
5358: SELECT /*+ no_unnest index(B,EGO_ITM_USR_ATTR_INTRFC_U1) */ /* Fix for bug#9678667 */

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

5366: AND DATA_SET_ID = :data_set_id
5367: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
5368: AND PROCESS_STATUS = '||G_PS_IN_PROCESS|| '
5369: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
5370: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
5371: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
5372: DBMS_SQL.Parse(l_default_date_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5373: DBMS_SQL.Bind_Variable(l_default_date_cursor_id, ':data_set_id', p_data_set_id);
5374: END IF;

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

5403: TRANSACTION_TYPE ,'||l_concat_pk_cols_sel||'
5404: ATTR_GROUP_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
5405: SELECT /*+ index(A,EGO_ITM_USR_ATTR_INTRFC_N1) */ /* Fix for bug#9678667 */
5406: /* Bug 9678667 MAX(TRANSACTION_ID),'||G_PS_IN_PROCESS||',DATA_SET_ID,ROW_IDENTIFIER,:attr_group_int_name,:attr_internal_name,
5407: :default_value,'''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''','|| l_concat_pk_cols_sel ||'
5408: ATTR_GROUP_ID,MAX(CREATED_BY),SYSDATE,MAX(LAST_UPDATED_BY),SYSDATE
5409: FROM '||p_interface_table_name||' A
5410: WHERE NOT EXISTS (
5411: SELECT /*+ no_unnest index(B,EGO_ITM_USR_ATTR_INTRFC_U1) */ /* Fix for bug#9678667 */

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

5419: AND DATA_SET_ID = :data_set_id
5420: AND ATTR_GROUP_INT_NAME = :attr_group_int_name
5421: AND PROCESS_STATUS = '||G_PS_IN_PROCESS|| '
5422: AND BITAND(PROCESS_STATUS, '||G_PS_NO_PRIVILEGES||') = 0
5423: AND TRANSACTION_TYPE = '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''
5424: GROUP BY DATA_SET_ID,ROW_IDENTIFIER,'|| l_concat_pk_cols_sel ||' ATTR_GROUP_ID' ;
5425: DBMS_SQL.Parse(l_default_char_cursor_id, l_dynamic_sql, DBMS_SQL.NATIVE);
5426: DBMS_SQL.Bind_Variable(l_default_char_cursor_id, ':data_set_id', p_data_set_id);
5427: END IF;

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

6309: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post || ' FROM '||p_interface_table_name||' UAI1 ';
6310: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post || ' WHERE UAI1.DATA_SET_ID = :data_set_id '||
6311: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
6312: ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
6313: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||'''';
6314: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post || ' GROUP BY UAI1.ATTR_GROUP_INT_NAME, UAI1.TRANSACTION_TYPE, UAI1.ROW_IDENTIFIER ';
6315:
6316: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post ||' '|| l_dynamic_group_by;
6317:

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

6327:
6328: l_dynamic_sql_1 := l_dynamic_sql_1 ||' AND UAI1.DATA_SET_ID = :data_set_id '||
6329: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
6330: ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
6331: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||'''';
6332:
6333:
6334: l_dynamic_sql_1 := l_dynamic_sql_1 || l_deflatening_sql_where;
6335: l_dynamic_sql_1 := l_dynamic_sql_1 || ' ' || l_group_by_pre || l_dynamic_group_by;

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

6581: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post || ' FROM '||p_interface_table_name||' UAI1 ';
6582: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post || ' WHERE UAI1.DATA_SET_ID = :data_set_id '||
6583: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
6584: ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
6585: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||'''';
6586: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post || ' GROUP BY UAI1.ATTR_GROUP_INT_NAME, UAI1.TRANSACTION_TYPE, UAI1.ROW_IDENTIFIER ';
6587:
6588: l_dynamic_sql_delete_post := l_dynamic_sql_delete_post ||' '|| l_dynamic_group_by;
6589: */

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

6607: l_dynamic_sql := l_dynamic_sql ||' AND UAI1.DATA_SET_ID = :data_set_id '||
6608: ' AND UAI1.PROCESS_STATUS <> '||G_PS_GENERIC_ERROR||
6609: ' AND UAI1.PROCESS_STATUS <> '||G_PS_SUCCESS||
6610: ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
6611: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';
6612: --l_dynamic_sql_1 := l_dynamic_sql_1 ||' AND UAI1.DATA_SET_ID = :data_set_id '||
6613: -- ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
6614: -- ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
6615: -- ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||'''';

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

6611: ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';
6612: --l_dynamic_sql_1 := l_dynamic_sql_1 ||' AND UAI1.DATA_SET_ID = :data_set_id '||
6613: -- ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||
6614: -- ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
6615: -- ' AND UAI1.TRANSACTION_TYPE <> '''||EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||'''';
6616:
6617: l_dynamic_sql := l_dynamic_sql || l_deflatening_sql_where;
6618: l_dynamic_sql := l_dynamic_sql || ' ' || l_group_by_pre || l_dynamic_group_by;
6619:

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

6737: -- Loop through the deflatened string containing the old and new values and
6738: -- prepare the table to be passed in as a parameter to pre-event
6739: l_attr_name_val_str := l_ag_deflatened_row.ATTR_NAME_VALUES;
6740: attr_name_val_pair := EGO_ATTR_TABLE();
6741: WHILE (INSTR(l_attr_name_val_str,'#') <> 0 AND l_ag_deflatened_row.TRANSACTION_TYPE <> EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE)
6742: LOOP
6743: l_attr_name := SUBSTR(l_attr_name_val_str
6744: ,INSTR(l_attr_name_val_str,'#*')+2
6745: ,INSTR(l_attr_name_val_str,'*#')-INSTR(l_attr_name_val_str,'#*')-2

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

6898: l_dynamic_sql := l_dynamic_sql || ' WHERE UAI1.DATA_SET_ID = :data_set_id '||
6899: ' AND UAI1.PROCESS_STATUS <> '||G_PS_GENERIC_ERROR||
6900: ' AND UAI1.PROCESS_STATUS <> '||G_PS_SUCCESS||
6901: ' AND UAI1.ATTR_GROUP_INT_NAME = :attr_group_int_name '||
6902: ' AND UAI1.TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';
6903: l_dynamic_sql := l_dynamic_sql || ' GROUP BY UAI1.ATTR_GROUP_INT_NAME, UAI1.TRANSACTION_TYPE, UAI1.ROW_IDENTIFIER '
6904: || l_dynamic_group_by;
6905:
6906: -------------------------------------------------------------------

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

7344: --where EXT is the actual EXT base table, hence we need to build a seperate where clause for identical check
7345: --i.e. l_rtcq_to_ext_whr_uks_idnt_chk.
7346: l_rtcq_to_ext_where_uks := l_rtcq_to_ext_where_uks||
7347: ' AND NVL(RTCQ.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||','||wierd_constant||')'||
7348: '= DECODE (RTCQ.TRANSACTION_TYPE, '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''' , '||
7349: 'NVL((SELECT NVL(RTCQ.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||','||wierd_constant||') FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM '||
7350: l_ext_tl_table_name||' WHERE EXTENSION_ID = EXT.EXTENSION_ID AND ROWNUM = 1 )), '||wierd_constant_2||' ) '||
7351: ',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||' ) '||
7352: ')';

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

7382: IF (l_attr_metadata_table_sr(d).DATA_TYPE_CODE =
7383: EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
7384:
7385: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
7386: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',DECODE(ATTR_VALUE_NUM,'||wierd_constant||',NULL,ATTR_VALUE_NUM), ATTR_VALUE_NUM)';
7387: -- ...this closes what started above
7388: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||')) '||
7389: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7390:

Line 7395: '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)';

7391: IF (l_attr_metadata_table_sr(d).UNIT_OF_MEASURE_CLASS IS NOT NULL) THEN
7392: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
7393: ',MAX(DECODE(RN,'||l_rn_index_for_ag||',';
7394: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
7395: '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)';
7396: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||')) '||
7397: l_attr_metadata_table_sr(d).DATABASE_COLUMN||'_UOM';
7398: END IF;
7399:

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

7449:
7450: --Bug 4473391(gnanda) : we need to convert the attr_value_date to char in the decode and then convert the final value into
7451: --date otherwise decode would remove the time part from date time attribute.
7452: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
7453: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''',ATTR_VALUE_DATE,TO_DATE(DECODE(ATTR_VALUE_DATE,'||wierd_constant||
7454: ',NULL,TO_CHAR(ATTR_VALUE_DATE,''DD/MM/YYYY HH24:MI:SS'')),''DD/MM/YYYY HH24:MI:SS'') )';
7455: -- ...this closes what started above
7456: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||')) '||
7457: l_attr_metadata_table_sr(d).DATABASE_COLUMN;

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

7480: END IF;
7481: ELSE
7482:
7483: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||
7484: 'DECODE(TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',DECODE(ATTR_VALUE_STR,'||wierd_constant||',NULL,ATTR_VALUE_STR), ATTR_VALUE_STR)';
7485: -- ...this closes what started above
7486: l_row_to_column_query_ag_part := l_row_to_column_query_ag_part||')) '||
7487: l_attr_metadata_table_sr(d).DATABASE_COLUMN;
7488:

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

7800: USING p_data_Set_id, p_attr_group_type;
7801: code_debug(' After DML for inserting dummy rows for dev defined attrs.'||l_dynamic_Sql,2);
7802: EXECUTE IMMEDIATE
7803: 'UPDATE '||p_interface_table_name||' UAI1
7804: SET TRANSACTION_TYPE = '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||'''
7805: WHERE UAI1.DATA_SET_ID = :data_set_id
7806: AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||'
7807: AND ATTR_GROUP_INT_NAME = :attr_grp_int_name
7808: AND ATTR_GROUP_TYPE = :attr_group_type '

Line 7839: EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||

7835: ' EXT, ('||l_row_to_column_query||') RTCQ WHERE 1=1'||
7836: l_rtcq_to_ext_where_base||
7837: l_rtcq_to_ext_where_uks||
7838: ' AND RTCQ.TRANSACTION_TYPE='''||
7839: EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE||
7840: '''; IF (ext_id_tbl.COUNT > 0) THEN
7841: FORALL i IN ext_id_tbl.FIRST .. ext_id_tbl.LAST
7842: DELETE FROM '||l_ext_b_table_name||' EXT
7843: WHERE '||l_db_col_tbl_where_ext_id||

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

7910: ' EXT, ('||l_row_to_column_query||') RTCQ WHERE 1=1'||
7911: l_rtcq_to_ext_where_base||
7912: l_rtcq_to_ext_where_uks||
7913: ' AND RTCQ.TRANSACTION_TYPE='''||
7914: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''' )'||
7915: ' UNION '||
7916: '(SELECT INTF_TL.LANGUAGE LANGUAGE, '|| --Added the following UNIONED Query for R12C.. this wud bring bak
7917: ' INTFRTCQ.EXTENSION_ID EXTENSION_ID '|| --the results from the intf_tl table as well for updating records
7918: l_rtcq_alias_b_cols_list_1 || --in other languages. We assume that the Row_identifier in the itnf table

Line 7930: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''''||

7926: ' EXT, ('||l_row_to_column_query||') RTCQ WHERE 1=1'||
7927: l_rtcq_to_ext_where_base||
7928: l_rtcq_to_ext_where_uks||
7929: ' AND RTCQ.TRANSACTION_TYPE='''||
7930: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''''||
7931: ' ) INTFRTCQ '||
7932: 'WHERE INTF_TL.SET_PROCESS_ID = :data_set_id '||
7933: ' AND UPPER(INTF_TL.TABLE_NAME) = '''||UPPER(p_interface_table_name)||''' '||
7934: ' AND INTF_TL.UNIQUE_ID = INTFRTCQ.ROW_IDENTIFIER ) ;';

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

8055: ' EXT, ('||l_row_to_column_query||') RTCQ WHERE 1=1'||
8056: l_rtcq_to_ext_where_base||
8057: l_rtcq_to_ext_where_uks||
8058: ' AND RTCQ.TRANSACTION_TYPE='''||
8059: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''' )'||
8060: ' UNION '||
8061: '(SELECT INTF_TL.LANGUAGE LANGUAGE, '|| --Added the following UNIONED Query for R12C.. this wud bring bak
8062: ' INTFRTCQ.EXTENSION_ID EXTENSION_ID '|| --the results from the intf_tl table as well for updating records
8063: l_rtcq_alias_b_cols_list_1 || --in other languages. We assume that the Row_identifier in the itnf table

Line 8075: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''''||

8071: ' EXT, ('||l_row_to_column_query||') RTCQ WHERE 1=1'||
8072: l_rtcq_to_ext_where_base||
8073: l_rtcq_to_ext_where_uks||
8074: ' AND RTCQ.TRANSACTION_TYPE='''||
8075: EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||''''||
8076: ' ) INTFRTCQ '||
8077: 'WHERE INTF_TL.SET_PROCESS_ID = :data_set_id '||
8078: ' AND UPPER(INTF_TL.TABLE_NAME) = '''||UPPER(p_interface_table_name)||''' '||
8079: ' AND INTF_TL.UNIQUE_ID = INTFRTCQ.ROW_IDENTIFIER ) ;';

Line 8195: l_column_exists:=EGO_USER_ATTRS_DATA_PVT.HAS_COLUMN_IN_TABLE_VIEW(l_ext_b_table_name,'UNIQUE_VALUE');

8191:
8192: -- Bug 10097738 : Start
8193: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y') THEN
8194: -- The below function returns 'T' or 'F'
8195: l_column_exists:=EGO_USER_ATTRS_DATA_PVT.HAS_COLUMN_IN_TABLE_VIEW(l_ext_b_table_name,'UNIQUE_VALUE');
8196: END IF;
8197:
8198: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y' AND FND_API.TO_BOOLEAN(l_column_exists)) THEN
8199: l_unique_value_col := ', UNIQUE_VALUE ';

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

8237: :current_login_id'||
8238: l_no_alias_b_values_list||
8239: ' FROM ('||l_row_to_column_query||') RTCQ
8240: WHERE RTCQ.TRANSACTION_TYPE = '''||
8241: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';
8242:
8243: code_debug(' Before Inserting into B table ' ,2);
8244: code_debug(' B table Insert DML for AG '||l_attr_group_metadata_obj.ATTR_GROUP_NAME ,3);
8245: code_debug(' :--:'||l_dynamic_sql ,3);

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

8324: AND L.INSTALLED_FLAG IN (''I'', ''B'')'||
8325: l_rtcq_to_ext_where_base||
8326: l_rtcq_to_ext_where_uks||
8327: ' AND RTCQ.TRANSACTION_TYPE='''||
8328: EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||'''';
8329:
8330: code_debug(' TL table Insert DML for AG '||l_attr_group_metadata_obj.ATTR_GROUP_NAME ,3);
8331: code_debug(' :--:'||l_dynamic_sql ,3);
8332:

Line 9601: ' NVL(INTFRTCQ.TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||''') TRANSACTION_TYPE, ';

9597: -- Bug 13414358 : Start
9598: /* Instead of inserting transaction type as CREATE/UPDATE insert as SYNC directly, so that the later part of the
9599: code will take care of resolving the TRANSACTION type. */
9600: -- ' NVL(INTFRTCQ.TRANSACTION_TYPE,NVL2(EXT.EXTENSION_ID,''UPDATE'',''CREATE'')) TRANSACTION_TYPE, ';
9601: ' NVL(INTFRTCQ.TRANSACTION_TYPE,'''||EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE||''') TRANSACTION_TYPE, ';
9602: -- Bug 13414358 : End
9603: IF l_has_data_level_id THEN
9604: l_rows_to_insert_sql := l_rows_to_insert_sql ||' TEMPLRTCQ.DATA_LEVEL_ID, ';
9605: IF l_dl_col_templrtcq_list IS NOT NULL THEN

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

10388: code_debug(l_api_name ||' l_inner_pk_cc_dl_col_list '|| l_inner_pk_cc_dl_col_list );
10389: code_debug(l_api_name ||' l_dynamic_sql '||l_dynamic_sql);
10390:
10391: l_dynamic_sql := l_dynamic_sql ||
10392: ' ,'''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''' '||--TRANSACTION_TYPE
10393: ' ,ENTITYAG_TBL.ATTR_GROUP_ID '||--ATTR_GROUP_ID
10394: ' ,ENTITYAG_TBL.TRANSACTION_ID '||--TRANSACTION_ID
10395: ' ,:current_user_id '||--CREATED_BY
10396: ' ,SYSDATE '||--CREATION_DATE

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

10493:
10494: l_dynamic_sql := ' INSERT INTO '||p_interface_table_name||
10495: ' ( '||l_col_to_insert_list ||' ) '||
10496: l_dynamic_sql;
10497: l_object_id := EGO_USER_ATTRS_DATA_PVT.Get_Object_Id_From_Name(p_object_name);
10498:
10499: code_debug(l_api_name ||' Final SQL ');
10500: code_debug(l_api_name ||l_dynamic_sql);
10501: code_debug(l_api_name ||'params 1: '||p_data_Set_id||' 2: '||FND_GLOBAL.CONC_REQUEST_ID||