DBA Data[Home] [Help]

APPS.GCS_VALUE_SET_PKG dependencies on FND_GLOBAL

Line 45: last_updated_by = fnd_global.user_id,

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,

Line 46: last_update_login = fnd_global.login_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,

Line 64: fnd_global.user_id,

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:

Line 66: fnd_global.user_id,

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,

Line 67: fnd_global.login_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,

Line 84: last_updated_by = fnd_global.user_id,

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,

Line 85: last_update_login = fnd_global.login_id

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,

Line 103: fnd_global.user_id,

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:

Line 105: fnd_global.user_id,

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:

Line 106: fnd_global.login_id);

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

Line 176: fnd_global.user_id,

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,

Line 178: fnd_global.user_id,

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:

Line 179: fnd_global.login_id,

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