DBA Data[Home] [Help]

APPS.AMS_LIST_SRC_FIELDS_PKG dependencies on FND_GLOBAL

Line 163: FND_GLOBAL.user_id,

159: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
160: --Modified for bug 5237401. bmuthukr
161: /*
162: sysdate,
163: FND_GLOBAL.user_id,
164: sysdate,
165: FND_GLOBAL.user_id,
166: */
167: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

Line 165: FND_GLOBAL.user_id,

161: /*
162: sysdate,
163: FND_GLOBAL.user_id,
164: sysdate,
165: FND_GLOBAL.user_id,
166: */
167: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
168: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
169: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 172: FND_GLOBAL.conc_login_id

168: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
169: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
170: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
171: --
172: FND_GLOBAL.conc_login_id
173: from FND_LANGUAGES L
174: where L.INSTALLED_FLAG in ('I', 'B')
175: and not exists
176: (select NULL

Line 279: --LAST_UPDATE_BY = FND_GLOBAL.user_id,

275: update AMS_LIST_SRC_FIELDS_TL set
276: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),
277: LAST_UPDATE_DATE = sysdate,
278: -- Modified for bug 5237401. bmuthukr
279: --LAST_UPDATE_BY = FND_GLOBAL.user_id,
280: last_update_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),
281: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
282: SOURCE_LANG = userenv('LANG')
283: where list_source_field_id = p_list_source_field_id

Line 281: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,

277: LAST_UPDATE_DATE = sysdate,
278: -- Modified for bug 5237401. bmuthukr
279: --LAST_UPDATE_BY = FND_GLOBAL.user_id,
280: last_update_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),
281: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
282: SOURCE_LANG = userenv('LANG')
283: where list_source_field_id = p_list_source_field_id
284: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
285:

Line 530: FND_GLOBAL.user_id,

526: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
527: --Added for bug 5237401. bmuthukr
528: /*
529: sysdate,
530: FND_GLOBAL.user_id,
531: sysdate,
532: FND_GLOBAL.user_id,
533: */
534: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

Line 532: FND_GLOBAL.user_id,

528: /*
529: sysdate,
530: FND_GLOBAL.user_id,
531: sysdate,
532: FND_GLOBAL.user_id,
533: */
534: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
535: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
536: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 539: FND_GLOBAL.conc_login_id

535: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
536: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
537: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
538: --
539: FND_GLOBAL.conc_login_id
540: from FND_LANGUAGES L
541: where L.INSTALLED_FLAG in ('I', 'B')
542: and not exists
543: (select NULL

Line 653: --LAST_UPDATE_BY = FND_GLOBAL.user_id,

649: update AMS_LIST_SRC_FIELDS_TL set
650: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),
651: LAST_UPDATE_DATE = sysdate,
652: -- Added for bug 5237401. bmuthukr.
653: --LAST_UPDATE_BY = FND_GLOBAL.user_id,
654: last_update_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),
655: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
656: SOURCE_LANG = userenv('LANG')
657: where list_source_field_id = p_list_source_field_id

Line 655: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,

651: LAST_UPDATE_DATE = sysdate,
652: -- Added for bug 5237401. bmuthukr.
653: --LAST_UPDATE_BY = FND_GLOBAL.user_id,
654: last_update_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),
655: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
656: SOURCE_LANG = userenv('LANG')
657: where list_source_field_id = p_list_source_field_id
658: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
659: