DBA Data[Home] [Help]

APPS.AMS_CAMPAIGN_SCHEDULES_B_PKG dependencies on FND_GLOBAL

Line 297: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),

293: ) VALUES (
294: DECODE( px_schedule_id, FND_API.g_miss_num, NULL, px_schedule_id),
295: -- last updated by, created by, last update login modified by soagrawa on 12-jun-2002 for ATT bug 2376329
296: DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date),
297: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
298: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
299: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by),
300: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.LOGIN_ID, p_last_update_login),
301: /*

Line 299: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by),

295: -- last updated by, created by, last update login modified by soagrawa on 12-jun-2002 for ATT bug 2376329
296: DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date),
297: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
298: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
299: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by),
300: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.LOGIN_ID, p_last_update_login),
301: /*
302: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
303: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 300: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.LOGIN_ID, p_last_update_login),

296: DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date),
297: DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
298: DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date),
299: DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by),
300: DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.LOGIN_ID, p_last_update_login),
301: /*
302: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
303: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
304: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 430: FND_GLOBAL.user_id,

426: SELECT
427: DECODE( px_schedule_id, FND_API.g_miss_num, NULL, px_schedule_id),
428: l.language_code,
429: SYSDATE,
430: FND_GLOBAL.user_id,
431: SYSDATE,
432: FND_GLOBAL.user_id,
433: FND_GLOBAL.conc_login_id,
434: USERENV('LANG'),

Line 432: FND_GLOBAL.user_id,

428: l.language_code,
429: SYSDATE,
430: FND_GLOBAL.user_id,
431: SYSDATE,
432: FND_GLOBAL.user_id,
433: FND_GLOBAL.conc_login_id,
434: USERENV('LANG'),
435: DECODE( p_schedule_name, FND_API.g_miss_char, NULL, p_schedule_name),
436: DECODE( p_schedule_description, FND_API.g_miss_char, NULL, p_schedule_description),

Line 433: FND_GLOBAL.conc_login_id,

429: SYSDATE,
430: FND_GLOBAL.user_id,
431: SYSDATE,
432: FND_GLOBAL.user_id,
433: FND_GLOBAL.conc_login_id,
434: USERENV('LANG'),
435: DECODE( p_schedule_name, FND_API.g_miss_char, NULL, p_schedule_name),
436: DECODE( p_schedule_description, FND_API.g_miss_char, NULL, p_schedule_description),
437: -- removed by soagrawa on 24-sep-2001

Line 614: last_updated_by = FND_GLOBAL.USER_ID,

610: UPDATE ams_campaign_schedules_b
611: SET schedule_id = DECODE( p_schedule_id, FND_API.g_miss_num, schedule_id, p_schedule_id),
612: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
613: -- last update date modified by soagrawa on 31-jan-2002 for bug# 2160058, 2204087
614: last_updated_by = FND_GLOBAL.USER_ID,
615: -- last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
616: -- removed by aranka on 26-dec-2001
617: -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
618: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),