DBA Data[Home] [Help]

APPS.PV_PARTNER_PROGRAM_PKG dependencies on FND_GLOBAL

Line 251: ,FND_GLOBAL.user_id

247: SELECT
248: DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
249: --DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)
250: ,SYSDATE
251: ,FND_GLOBAL.user_id
252: ,SYSDATE
253: ,FND_GLOBAL.user_id
254: ,FND_GLOBAL.conc_login_id
255: ,l.language_code

Line 253: ,FND_GLOBAL.user_id

249: --DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)
250: ,SYSDATE
251: ,FND_GLOBAL.user_id
252: ,SYSDATE
253: ,FND_GLOBAL.user_id
254: ,FND_GLOBAL.conc_login_id
255: ,l.language_code
256: ,USERENV('LANG')
257: ,DECODE( p_program_name, NULL, p_program_name, FND_API.g_miss_char, NULL, p_program_name)

Line 254: ,FND_GLOBAL.conc_login_id

250: ,SYSDATE
251: ,FND_GLOBAL.user_id
252: ,SYSDATE
253: ,FND_GLOBAL.user_id
254: ,FND_GLOBAL.conc_login_id
255: ,l.language_code
256: ,USERENV('LANG')
257: ,DECODE( p_program_name, NULL, p_program_name, FND_API.g_miss_char, NULL, p_program_name)
258: ,DECODE( p_program_description,NULL, p_program_description, FND_API.g_miss_char, NULL, p_program_description)

Line 431: ,last_updated_by = FND_GLOBAL.user_id

427:
428: Update PV_PARTNER_PROGRAM_TL
429: SET
430: last_update_date = SYSDATE
431: ,last_updated_by = FND_GLOBAL.user_id
432: ,last_update_login = FND_GLOBAL.conc_login_id
433: ,source_lang = USERENV('LANG')
434: ,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
435: ,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)

Line 432: ,last_update_login = FND_GLOBAL.conc_login_id

428: Update PV_PARTNER_PROGRAM_TL
429: SET
430: last_update_date = SYSDATE
431: ,last_updated_by = FND_GLOBAL.user_id
432: ,last_update_login = FND_GLOBAL.conc_login_id
433: ,source_lang = USERENV('LANG')
434: ,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
435: ,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
436: ,qsnr_title = DECODE( p_qsnr_title, NULL, qsnr_title , FND_API.g_miss_char, NULL, p_qsnr_title )

Line 480: ,last_updated_by = FND_GLOBAL.user_id

476:
477: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)
478: ,enabled_flag ='N'
479: ,last_update_date = SYSDATE
480: ,last_updated_by = FND_GLOBAL.user_id
481: ,last_update_login = FND_GLOBAL.conc_login_id
482: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)
483:
484:

Line 481: ,last_update_login = FND_GLOBAL.conc_login_id

477: program_id = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num, NULL , p_program_id)
478: ,enabled_flag ='N'
479: ,last_update_date = SYSDATE
480: ,last_updated_by = FND_GLOBAL.user_id
481: ,last_update_login = FND_GLOBAL.conc_login_id
482: ,object_version_number = DECODE( p_object_version_number, NULL ,object_version_number, FND_API.g_miss_num, NULL , p_object_version_number+1)
483:
484:
485: WHERE PROGRAM_ID = p_program_id

Line 499: ,last_updated_by = FND_GLOBAL.user_id

495:
496: Update PV_PARTNER_PROGRAM_TL
497: SET
498: last_update_date = SYSDATE
499: ,last_updated_by = FND_GLOBAL.user_id
500: ,last_update_login = FND_GLOBAL.conc_login_id
501: ,source_lang = USERENV('LANG')
502: --,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
503: --,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)

Line 500: ,last_update_login = FND_GLOBAL.conc_login_id

496: Update PV_PARTNER_PROGRAM_TL
497: SET
498: last_update_date = SYSDATE
499: ,last_updated_by = FND_GLOBAL.user_id
500: ,last_update_login = FND_GLOBAL.conc_login_id
501: ,source_lang = USERENV('LANG')
502: --,program_name = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
503: --,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
504: WHERE PROGRAM_ID = p_program_id