DBA Data[Home] [Help]

APPS.GCS_ICM_INTG_PROF_PKG dependencies on FND_GLOBAL

Line 46: last_updated_by = fnd_global.user_id,

42: decode(p_force_update,
43: 'Y', p_option_value,
44: profile_option_value)),
45: last_update_date = sysdate,
46: last_updated_by = fnd_global.user_id,
47: last_update_login = fnd_global.login_id
48: WHEN NOT MATCHED THEN
49: INSERT(
50: application_id,

Line 47: last_update_login = fnd_global.login_id

43: 'Y', p_option_value,
44: profile_option_value)),
45: last_update_date = sysdate,
46: last_updated_by = fnd_global.user_id,
47: last_update_login = fnd_global.login_id
48: WHEN NOT MATCHED THEN
49: INSERT(
50: application_id,
51: profile_option_id,

Line 66: fnd_global.user_id,

62: l_profile_option_id,
63: 10001,
64: 0,
65: sysdate,
66: fnd_global.user_id,
67: sysdate,
68: fnd_global.user_id,
69: fnd_global.login_id,
70: p_option_value);

Line 68: fnd_global.user_id,

64: 0,
65: sysdate,
66: fnd_global.user_id,
67: sysdate,
68: fnd_global.user_id,
69: fnd_global.login_id,
70: p_option_value);
71:
72: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 69: fnd_global.login_id,

65: sysdate,
66: fnd_global.user_id,
67: sysdate,
68: fnd_global.user_id,
69: fnd_global.login_id,
70: p_option_value);
71:
72: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 190: ' fnd_global.user_id, ' ||

186: ' object_version_number) ' ||
187: 'SELECT :1, ' ||
188: ' hierarchy_id, ' ||
189: ' sysdate, ' ||
190: ' fnd_global.user_id, ' ||
191: ' sysdate, ' ||
192: ' fnd_global.user_id, ' ||
193: ' fnd_global.login_id, ' ||
194: ' null, ' ||

Line 192: ' fnd_global.user_id, ' ||

188: ' hierarchy_id, ' ||
189: ' sysdate, ' ||
190: ' fnd_global.user_id, ' ||
191: ' sysdate, ' ||
192: ' fnd_global.user_id, ' ||
193: ' fnd_global.login_id, ' ||
194: ' null, ' ||
195: ' 1 ' ||
196: 'FROM gcs_hierarchies_b ' ||

Line 193: ' fnd_global.login_id, ' ||

189: ' sysdate, ' ||
190: ' fnd_global.user_id, ' ||
191: ' sysdate, ' ||
192: ' fnd_global.user_id, ' ||
193: ' fnd_global.login_id, ' ||
194: ' null, ' ||
195: ' 1 ' ||
196: 'FROM gcs_hierarchies_b ' ||
197: 'WHERE certification_flag = ''Y'''