DBA Data[Home] [Help]

APPS.AMS_USER_STATUSES_PVT dependencies on FND_GLOBAL

Line 198: FND_GLOBAL.User_Id,

194: VALUES (
195: l_user_status_rec.user_status_id,
196: -- standard who columns
197: SYSDATE,
198: FND_GLOBAL.User_Id,
199: SYSDATE,
200: FND_GLOBAL.User_Id,
201: FND_GLOBAL.Conc_Login_Id,
202: 1, -- object_version_number

Line 200: FND_GLOBAL.User_Id,

196: -- standard who columns
197: SYSDATE,
198: FND_GLOBAL.User_Id,
199: SYSDATE,
200: FND_GLOBAL.User_Id,
201: FND_GLOBAL.Conc_Login_Id,
202: 1, -- object_version_number
203: l_user_status_rec.system_status_type,
204: l_user_status_rec.system_status_code,

Line 201: FND_GLOBAL.Conc_Login_Id,

197: SYSDATE,
198: FND_GLOBAL.User_Id,
199: SYSDATE,
200: FND_GLOBAL.User_Id,
201: FND_GLOBAL.Conc_Login_Id,
202: 1, -- object_version_number
203: l_user_status_rec.system_status_type,
204: l_user_status_rec.system_status_code,
205: NVL (l_user_status_rec.enabled_flag, 'Y'), -- Default is 'Y'

Line 210: fnd_global.resp_appl_id -- added to capture application_id

206: NVL (l_user_status_rec.default_flag, 'N'), -- Default is 'N'
207: NVL (l_user_status_rec.seeded_flag, 'N'), -- Default is 'N'
208: l_user_status_rec.start_date_active,
209: l_user_status_rec.end_date_active,
210: fnd_global.resp_appl_id -- added to capture application_id
211: );
212: INSERT INTO ams_user_statuses_tl (
213: user_status_id,
214: language,

Line 228: FND_GLOBAL.User_Id,

224: SELECT l_user_status_rec.user_status_id,
225: l.language_code,
226: -- standard who columns
227: SYSDATE,
228: FND_GLOBAL.User_Id,
229: SYSDATE,
230: FND_GLOBAL.User_Id,
231: FND_GLOBAL.Conc_Login_Id,
232: USERENV('LANG'),

Line 230: FND_GLOBAL.User_Id,

226: -- standard who columns
227: SYSDATE,
228: FND_GLOBAL.User_Id,
229: SYSDATE,
230: FND_GLOBAL.User_Id,
231: FND_GLOBAL.Conc_Login_Id,
232: USERENV('LANG'),
233: l_user_status_rec.name,
234: l_user_status_rec.description

Line 231: FND_GLOBAL.Conc_Login_Id,

227: SYSDATE,
228: FND_GLOBAL.User_Id,
229: SYSDATE,
230: FND_GLOBAL.User_Id,
231: FND_GLOBAL.Conc_Login_Id,
232: USERENV('LANG'),
233: l_user_status_rec.name,
234: l_user_status_rec.description
235: FROM fnd_languages l

Line 412: last_updated_by = FND_GLOBAL.User_Id,

408:
409: UPDATE ams_user_statuses_b
410: SET
411: last_update_date = SYSDATE,
412: last_updated_by = FND_GLOBAL.User_Id,
413: last_update_login = FND_GLOBAL.Conc_Login_Id,
414: object_version_number = object_version_number + 1,
415: system_status_type = l_user_status_rec.system_status_type,
416: system_status_code = l_user_status_rec.system_status_code,

Line 413: last_update_login = FND_GLOBAL.Conc_Login_Id,

409: UPDATE ams_user_statuses_b
410: SET
411: last_update_date = SYSDATE,
412: last_updated_by = FND_GLOBAL.User_Id,
413: last_update_login = FND_GLOBAL.Conc_Login_Id,
414: object_version_number = object_version_number + 1,
415: system_status_type = l_user_status_rec.system_status_type,
416: system_status_code = l_user_status_rec.system_status_code,
417: enabled_flag = NVL (l_user_status_rec.enabled_flag, 'Y'),

Line 434: last_updated_by = FND_GLOBAL.User_Id,

430: END IF;
431: UPDATE ams_user_statuses_tl
432: SET
433: last_update_date = SYSDATE,
434: last_updated_by = FND_GLOBAL.User_Id,
435: last_update_login = FND_GLOBAL.Conc_Login_Id,
436: source_lang = USERENV('LANG'),
437: name = l_user_status_rec.name,
438: description = l_user_status_rec.description

Line 435: last_update_login = FND_GLOBAL.Conc_Login_Id,

431: UPDATE ams_user_statuses_tl
432: SET
433: last_update_date = SYSDATE,
434: last_updated_by = FND_GLOBAL.User_Id,
435: last_update_login = FND_GLOBAL.Conc_Login_Id,
436: source_lang = USERENV('LANG'),
437: name = l_user_status_rec.name,
438: description = l_user_status_rec.description
439: WHERE user_status_id = l_user_status_rec.user_status_id

Line 1336: p_view_application_id => fnd_global.resp_appl_id

1332: */
1333: IF AMS_Utility_PVT.check_lookup_exists(
1334: p_lookup_type => l_system_status_type,
1335: p_lookup_code => p_user_status_rec.system_status_code,
1336: p_view_application_id => fnd_global.resp_appl_id
1337: ) = FND_API.g_false
1338: THEN
1339: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1340: FND_MESSAGE.set_name ('AMS', 'AMS_STATUS_BAD_SYSTEM_STATUS');