41: ON (ffv.flex_value_id = entity.entity_id)
42: WHEN MATCHED THEN
43: UPDATE SET flex_value = entity.entity_display_code,
44: last_update_date = sysdate,
45: last_updated_by = fnd_global.user_id,
46: last_update_login = fnd_global.login_id
47: WHEN NOT MATCHED THEN
48: INSERT(flex_value_set_id,
49: flex_value_id,
42: WHEN MATCHED THEN
43: UPDATE SET flex_value = entity.entity_display_code,
44: last_update_date = sysdate,
45: last_updated_by = fnd_global.user_id,
46: last_update_login = fnd_global.login_id
47: WHEN NOT MATCHED THEN
48: INSERT(flex_value_set_id,
49: flex_value_id,
50: flex_value,
60: entity.entity_display_code,
61: 'Y',
62: entity.summary_flag,
63: sysdate,
64: fnd_global.user_id,
65: sysdate,
66: fnd_global.user_id,
67: fnd_global.login_id);
68:
62: entity.summary_flag,
63: sysdate,
64: fnd_global.user_id,
65: sysdate,
66: fnd_global.user_id,
67: fnd_global.login_id);
68:
69: MERGE INTO fnd_flex_values_tl ffvt
70: USING (SELECT fet.entity_id,
63: sysdate,
64: fnd_global.user_id,
65: sysdate,
66: fnd_global.user_id,
67: fnd_global.login_id);
68:
69: MERGE INTO fnd_flex_values_tl ffvt
70: USING (SELECT fet.entity_id,
71: fet.entity_name,
80: WHEN MATCHED THEN
81: UPDATE SET flex_value_meaning = entity.entity_name,
82: description = entity.entity_name,
83: last_update_date = sysdate,
84: last_updated_by = fnd_global.user_id,
85: last_update_login = fnd_global.login_id
86: WHEN NOT MATCHED THEN
87: INSERT(flex_value_id,
88: language,
81: UPDATE SET flex_value_meaning = entity.entity_name,
82: description = entity.entity_name,
83: last_update_date = sysdate,
84: last_updated_by = fnd_global.user_id,
85: last_update_login = fnd_global.login_id
86: WHEN NOT MATCHED THEN
87: INSERT(flex_value_id,
88: language,
89: source_lang,
99: entity.source_lang,
100: entity.entity_name,
101: entity.entity_name,
102: sysdate,
103: fnd_global.user_id,
104: sysdate,
105: fnd_global.user_id,
106: fnd_global.login_id);
107:
101: entity.entity_name,
102: sysdate,
103: fnd_global.user_id,
104: sysdate,
105: fnd_global.user_id,
106: fnd_global.login_id);
107:
108: COMMIT;
109:
102: sysdate,
103: fnd_global.user_id,
104: sysdate,
105: fnd_global.user_id,
106: fnd_global.login_id);
107:
108: COMMIT;
109:
110: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
172: 'C'),
173: v_temp.child_entity_display_code,
174: v_temp.child_entity_display_code,
175: sysdate,
176: fnd_global.user_id,
177: sysdate,
178: fnd_global.user_id,
179: fnd_global.login_id,
180: null,
174: v_temp.child_entity_display_code,
175: sysdate,
176: fnd_global.user_id,
177: sysdate,
178: fnd_global.user_id,
179: fnd_global.login_id,
180: null,
181: null);
182:
175: sysdate,
176: fnd_global.user_id,
177: sysdate,
178: fnd_global.user_id,
179: fnd_global.login_id,
180: null,
181: null);
182:
183: IF (v_temp.child_entity_type_code = 'C') THEN