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
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)
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)
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)
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 )
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:
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
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)
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