172: -- added by ptendulk on 26-sep-2001
173: -- for storing time correctly in the database
174: -- DBMS_OUTPUT.PUT_LINE('Start date : '||TO_CHAR(p_start_date_time,'DDMMYY HH:MI:SS PM'));
175:
176: IF p_start_date_time = FND_API.g_miss_date THEN
177: l_start_date := NULL ;
178: ELSE
179: l_start_date := p_start_date_time ;
180: END IF ;
178: ELSE
179: l_start_date := p_start_date_time ;
180: END IF ;
181:
182: IF p_end_date_time = FND_API.g_miss_date THEN
183: l_end_date := null ;
184: ELSE
185: l_end_date := p_end_date_time ;
186: END IF ;
290: notify_on_activation_flag,
291: sender_display_name,
292: delivery_mode
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),
292: delivery_mode
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),
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: /*
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: /*
302: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
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),
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),
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),
305: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
306: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
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),
305: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
306: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
307: */
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),
305: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
306: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
307: */
308: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
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),
305: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
306: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
307: */
308: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
309: DECODE( p_campaign_id, FND_API.g_miss_num, NULL, p_campaign_id),
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),
305: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
306: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
307: */
308: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
309: DECODE( p_campaign_id, FND_API.g_miss_num, NULL, p_campaign_id),
310: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
304: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
305: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
306: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
307: */
308: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
309: DECODE( p_campaign_id, FND_API.g_miss_num, NULL, p_campaign_id),
310: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
311: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
312: DECODE( p_status_date, FND_API.g_miss_date, SYSDATE, p_status_date),
305: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
306: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
307: */
308: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
309: DECODE( p_campaign_id, FND_API.g_miss_num, NULL, p_campaign_id),
310: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
311: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
312: DECODE( p_status_date, FND_API.g_miss_date, SYSDATE, p_status_date),
313: DECODE( p_source_code, FND_API.g_miss_char, NULL, p_source_code),
306: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
307: */
308: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
309: DECODE( p_campaign_id, FND_API.g_miss_num, NULL, p_campaign_id),
310: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
311: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
312: DECODE( p_status_date, FND_API.g_miss_date, SYSDATE, p_status_date),
313: DECODE( p_source_code, FND_API.g_miss_char, NULL, p_source_code),
314: DECODE( p_use_parent_code_flag, FND_API.g_miss_char, 'N', p_use_parent_code_flag),
307: */
308: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
309: DECODE( p_campaign_id, FND_API.g_miss_num, NULL, p_campaign_id),
310: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
311: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
312: DECODE( p_status_date, FND_API.g_miss_date, SYSDATE, p_status_date),
313: DECODE( p_source_code, FND_API.g_miss_char, NULL, p_source_code),
314: DECODE( p_use_parent_code_flag, FND_API.g_miss_char, 'N', p_use_parent_code_flag),
315: -- date stuff modified by ptendulk on 26-sep-2001
308: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
309: DECODE( p_campaign_id, FND_API.g_miss_num, NULL, p_campaign_id),
310: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
311: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
312: DECODE( p_status_date, FND_API.g_miss_date, SYSDATE, p_status_date),
313: DECODE( p_source_code, FND_API.g_miss_char, NULL, p_source_code),
314: DECODE( p_use_parent_code_flag, FND_API.g_miss_char, 'N', p_use_parent_code_flag),
315: -- date stuff modified by ptendulk on 26-sep-2001
316: -- as the time was not being saved from the api.
309: DECODE( p_campaign_id, FND_API.g_miss_num, NULL, p_campaign_id),
310: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
311: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
312: DECODE( p_status_date, FND_API.g_miss_date, SYSDATE, p_status_date),
313: DECODE( p_source_code, FND_API.g_miss_char, NULL, p_source_code),
314: DECODE( p_use_parent_code_flag, FND_API.g_miss_char, 'N', p_use_parent_code_flag),
315: -- date stuff modified by ptendulk on 26-sep-2001
316: -- as the time was not being saved from the api.
317: --DECODE( p_start_date_time, FND_API.g_miss_date, NULL, TO_DATE(TO_CHAR(p_start_date_time,'DDMMRRRR HH:MI:SS PM'),'DDMMRRRR HH:MI:SS PM')),
310: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
311: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
312: DECODE( p_status_date, FND_API.g_miss_date, SYSDATE, p_status_date),
313: DECODE( p_source_code, FND_API.g_miss_char, NULL, p_source_code),
314: DECODE( p_use_parent_code_flag, FND_API.g_miss_char, 'N', p_use_parent_code_flag),
315: -- date stuff modified by ptendulk on 26-sep-2001
316: -- as the time was not being saved from the api.
317: --DECODE( p_start_date_time, FND_API.g_miss_date, NULL, TO_DATE(TO_CHAR(p_start_date_time,'DDMMRRRR HH:MI:SS PM'),'DDMMRRRR HH:MI:SS PM')),
318: --TO_DATE(TO_CHAR(p_start_date_time,'DDMMRRRR HH:MI:SS PM'),'DDMMRRRR HH:MI:SS PM'),
313: DECODE( p_source_code, FND_API.g_miss_char, NULL, p_source_code),
314: DECODE( p_use_parent_code_flag, FND_API.g_miss_char, 'N', p_use_parent_code_flag),
315: -- date stuff modified by ptendulk on 26-sep-2001
316: -- as the time was not being saved from the api.
317: --DECODE( p_start_date_time, FND_API.g_miss_date, NULL, TO_DATE(TO_CHAR(p_start_date_time,'DDMMRRRR HH:MI:SS PM'),'DDMMRRRR HH:MI:SS PM')),
318: --TO_DATE(TO_CHAR(p_start_date_time,'DDMMRRRR HH:MI:SS PM'),'DDMMRRRR HH:MI:SS PM'),
319: l_start_date,
320: --DECODE( p_end_date_time, FND_API.g_miss_date, NULL, p_end_date_time),
321: l_end_date,
316: -- as the time was not being saved from the api.
317: --DECODE( p_start_date_time, FND_API.g_miss_date, NULL, TO_DATE(TO_CHAR(p_start_date_time,'DDMMRRRR HH:MI:SS PM'),'DDMMRRRR HH:MI:SS PM')),
318: --TO_DATE(TO_CHAR(p_start_date_time,'DDMMRRRR HH:MI:SS PM'),'DDMMRRRR HH:MI:SS PM'),
319: l_start_date,
320: --DECODE( p_end_date_time, FND_API.g_miss_date, NULL, p_end_date_time),
321: l_end_date,
322: DECODE( p_timezone_id, FND_API.g_miss_num, NULL, p_timezone_id),
323: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
324: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
318: --TO_DATE(TO_CHAR(p_start_date_time,'DDMMRRRR HH:MI:SS PM'),'DDMMRRRR HH:MI:SS PM'),
319: l_start_date,
320: --DECODE( p_end_date_time, FND_API.g_miss_date, NULL, p_end_date_time),
321: l_end_date,
322: DECODE( p_timezone_id, FND_API.g_miss_num, NULL, p_timezone_id),
323: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
324: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
325: DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, NULL, p_arc_marketing_medium_from),
326: DECODE( p_marketing_medium_id, FND_API.g_miss_num, NULL, p_marketing_medium_id),
319: l_start_date,
320: --DECODE( p_end_date_time, FND_API.g_miss_date, NULL, p_end_date_time),
321: l_end_date,
322: DECODE( p_timezone_id, FND_API.g_miss_num, NULL, p_timezone_id),
323: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
324: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
325: DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, NULL, p_arc_marketing_medium_from),
326: DECODE( p_marketing_medium_id, FND_API.g_miss_num, NULL, p_marketing_medium_id),
327: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
320: --DECODE( p_end_date_time, FND_API.g_miss_date, NULL, p_end_date_time),
321: l_end_date,
322: DECODE( p_timezone_id, FND_API.g_miss_num, NULL, p_timezone_id),
323: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
324: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
325: DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, NULL, p_arc_marketing_medium_from),
326: DECODE( p_marketing_medium_id, FND_API.g_miss_num, NULL, p_marketing_medium_id),
327: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
328: DECODE( p_triggerable_flag, FND_API.g_miss_char, 'N', p_triggerable_flag),
321: l_end_date,
322: DECODE( p_timezone_id, FND_API.g_miss_num, NULL, p_timezone_id),
323: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
324: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
325: DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, NULL, p_arc_marketing_medium_from),
326: DECODE( p_marketing_medium_id, FND_API.g_miss_num, NULL, p_marketing_medium_id),
327: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
328: DECODE( p_triggerable_flag, FND_API.g_miss_char, 'N', p_triggerable_flag),
329: DECODE( p_trigger_id, FND_API.g_miss_num, NULL, p_trigger_id),
322: DECODE( p_timezone_id, FND_API.g_miss_num, NULL, p_timezone_id),
323: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
324: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
325: DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, NULL, p_arc_marketing_medium_from),
326: DECODE( p_marketing_medium_id, FND_API.g_miss_num, NULL, p_marketing_medium_id),
327: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
328: DECODE( p_triggerable_flag, FND_API.g_miss_char, 'N', p_triggerable_flag),
329: DECODE( p_trigger_id, FND_API.g_miss_num, NULL, p_trigger_id),
330: DECODE( p_notify_user_id, FND_API.g_miss_num, NULL, p_notify_user_id),
323: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
324: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
325: DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, NULL, p_arc_marketing_medium_from),
326: DECODE( p_marketing_medium_id, FND_API.g_miss_num, NULL, p_marketing_medium_id),
327: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
328: DECODE( p_triggerable_flag, FND_API.g_miss_char, 'N', p_triggerable_flag),
329: DECODE( p_trigger_id, FND_API.g_miss_num, NULL, p_trigger_id),
330: DECODE( p_notify_user_id, FND_API.g_miss_num, NULL, p_notify_user_id),
331: DECODE( p_approver_user_id, FND_API.g_miss_num, NULL, p_approver_user_id),
324: DECODE( p_activity_id, FND_API.g_miss_num, NULL, p_activity_id),
325: DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, NULL, p_arc_marketing_medium_from),
326: DECODE( p_marketing_medium_id, FND_API.g_miss_num, NULL, p_marketing_medium_id),
327: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
328: DECODE( p_triggerable_flag, FND_API.g_miss_char, 'N', p_triggerable_flag),
329: DECODE( p_trigger_id, FND_API.g_miss_num, NULL, p_trigger_id),
330: DECODE( p_notify_user_id, FND_API.g_miss_num, NULL, p_notify_user_id),
331: DECODE( p_approver_user_id, FND_API.g_miss_num, NULL, p_approver_user_id),
332: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
325: DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, NULL, p_arc_marketing_medium_from),
326: DECODE( p_marketing_medium_id, FND_API.g_miss_num, NULL, p_marketing_medium_id),
327: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
328: DECODE( p_triggerable_flag, FND_API.g_miss_char, 'N', p_triggerable_flag),
329: DECODE( p_trigger_id, FND_API.g_miss_num, NULL, p_trigger_id),
330: DECODE( p_notify_user_id, FND_API.g_miss_num, NULL, p_notify_user_id),
331: DECODE( p_approver_user_id, FND_API.g_miss_num, NULL, p_approver_user_id),
332: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
333: DECODE( p_active_flag, FND_API.g_miss_char, 'Y', p_active_flag),
326: DECODE( p_marketing_medium_id, FND_API.g_miss_num, NULL, p_marketing_medium_id),
327: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
328: DECODE( p_triggerable_flag, FND_API.g_miss_char, 'N', p_triggerable_flag),
329: DECODE( p_trigger_id, FND_API.g_miss_num, NULL, p_trigger_id),
330: DECODE( p_notify_user_id, FND_API.g_miss_num, NULL, p_notify_user_id),
331: DECODE( p_approver_user_id, FND_API.g_miss_num, NULL, p_approver_user_id),
332: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
333: DECODE( p_active_flag, FND_API.g_miss_char, 'Y', p_active_flag),
334: DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id),
327: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
328: DECODE( p_triggerable_flag, FND_API.g_miss_char, 'N', p_triggerable_flag),
329: DECODE( p_trigger_id, FND_API.g_miss_num, NULL, p_trigger_id),
330: DECODE( p_notify_user_id, FND_API.g_miss_num, NULL, p_notify_user_id),
331: DECODE( p_approver_user_id, FND_API.g_miss_num, NULL, p_approver_user_id),
332: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
333: DECODE( p_active_flag, FND_API.g_miss_char, 'Y', p_active_flag),
334: DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id),
335: DECODE( p_reply_to_mail, FND_API.g_miss_char, NULL, p_reply_to_mail),
328: DECODE( p_triggerable_flag, FND_API.g_miss_char, 'N', p_triggerable_flag),
329: DECODE( p_trigger_id, FND_API.g_miss_num, NULL, p_trigger_id),
330: DECODE( p_notify_user_id, FND_API.g_miss_num, NULL, p_notify_user_id),
331: DECODE( p_approver_user_id, FND_API.g_miss_num, NULL, p_approver_user_id),
332: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
333: DECODE( p_active_flag, FND_API.g_miss_char, 'Y', p_active_flag),
334: DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id),
335: DECODE( p_reply_to_mail, FND_API.g_miss_char, NULL, p_reply_to_mail),
336: DECODE( p_mail_sender_name, FND_API.g_miss_char, NULL, p_mail_sender_name),
329: DECODE( p_trigger_id, FND_API.g_miss_num, NULL, p_trigger_id),
330: DECODE( p_notify_user_id, FND_API.g_miss_num, NULL, p_notify_user_id),
331: DECODE( p_approver_user_id, FND_API.g_miss_num, NULL, p_approver_user_id),
332: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
333: DECODE( p_active_flag, FND_API.g_miss_char, 'Y', p_active_flag),
334: DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id),
335: DECODE( p_reply_to_mail, FND_API.g_miss_char, NULL, p_reply_to_mail),
336: DECODE( p_mail_sender_name, FND_API.g_miss_char, NULL, p_mail_sender_name),
337: DECODE( p_mail_subject, FND_API.g_miss_char, NULL, p_mail_subject),
330: DECODE( p_notify_user_id, FND_API.g_miss_num, NULL, p_notify_user_id),
331: DECODE( p_approver_user_id, FND_API.g_miss_num, NULL, p_approver_user_id),
332: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
333: DECODE( p_active_flag, FND_API.g_miss_char, 'Y', p_active_flag),
334: DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id),
335: DECODE( p_reply_to_mail, FND_API.g_miss_char, NULL, p_reply_to_mail),
336: DECODE( p_mail_sender_name, FND_API.g_miss_char, NULL, p_mail_sender_name),
337: DECODE( p_mail_subject, FND_API.g_miss_char, NULL, p_mail_subject),
338: DECODE( p_from_fax_no, FND_API.g_miss_char, NULL, p_from_fax_no),
331: DECODE( p_approver_user_id, FND_API.g_miss_num, NULL, p_approver_user_id),
332: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
333: DECODE( p_active_flag, FND_API.g_miss_char, 'Y', p_active_flag),
334: DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id),
335: DECODE( p_reply_to_mail, FND_API.g_miss_char, NULL, p_reply_to_mail),
336: DECODE( p_mail_sender_name, FND_API.g_miss_char, NULL, p_mail_sender_name),
337: DECODE( p_mail_subject, FND_API.g_miss_char, NULL, p_mail_subject),
338: DECODE( p_from_fax_no, FND_API.g_miss_char, NULL, p_from_fax_no),
339: DECODE( p_accounts_closed_flag, FND_API.g_miss_char, 'N', p_accounts_closed_flag),
332: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
333: DECODE( p_active_flag, FND_API.g_miss_char, 'Y', p_active_flag),
334: DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id),
335: DECODE( p_reply_to_mail, FND_API.g_miss_char, NULL, p_reply_to_mail),
336: DECODE( p_mail_sender_name, FND_API.g_miss_char, NULL, p_mail_sender_name),
337: DECODE( p_mail_subject, FND_API.g_miss_char, NULL, p_mail_subject),
338: DECODE( p_from_fax_no, FND_API.g_miss_char, NULL, p_from_fax_no),
339: DECODE( p_accounts_closed_flag, FND_API.g_miss_char, 'N', p_accounts_closed_flag),
340: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
333: DECODE( p_active_flag, FND_API.g_miss_char, 'Y', p_active_flag),
334: DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id),
335: DECODE( p_reply_to_mail, FND_API.g_miss_char, NULL, p_reply_to_mail),
336: DECODE( p_mail_sender_name, FND_API.g_miss_char, NULL, p_mail_sender_name),
337: DECODE( p_mail_subject, FND_API.g_miss_char, NULL, p_mail_subject),
338: DECODE( p_from_fax_no, FND_API.g_miss_char, NULL, p_from_fax_no),
339: DECODE( p_accounts_closed_flag, FND_API.g_miss_char, 'N', p_accounts_closed_flag),
340: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
341: DECODE( p_objective_code, FND_API.g_miss_char, NULL, p_objective_code),
334: DECODE( p_cover_letter_id, FND_API.g_miss_num, NULL, p_cover_letter_id),
335: DECODE( p_reply_to_mail, FND_API.g_miss_char, NULL, p_reply_to_mail),
336: DECODE( p_mail_sender_name, FND_API.g_miss_char, NULL, p_mail_sender_name),
337: DECODE( p_mail_subject, FND_API.g_miss_char, NULL, p_mail_subject),
338: DECODE( p_from_fax_no, FND_API.g_miss_char, NULL, p_from_fax_no),
339: DECODE( p_accounts_closed_flag, FND_API.g_miss_char, 'N', p_accounts_closed_flag),
340: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
341: DECODE( p_objective_code, FND_API.g_miss_char, NULL, p_objective_code),
342: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
335: DECODE( p_reply_to_mail, FND_API.g_miss_char, NULL, p_reply_to_mail),
336: DECODE( p_mail_sender_name, FND_API.g_miss_char, NULL, p_mail_sender_name),
337: DECODE( p_mail_subject, FND_API.g_miss_char, NULL, p_mail_subject),
338: DECODE( p_from_fax_no, FND_API.g_miss_char, NULL, p_from_fax_no),
339: DECODE( p_accounts_closed_flag, FND_API.g_miss_char, 'N', p_accounts_closed_flag),
340: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
341: DECODE( p_objective_code, FND_API.g_miss_char, NULL, p_objective_code),
342: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
343: DECODE( p_campaign_calendar, FND_API.g_miss_char, NULL, p_campaign_calendar),
336: DECODE( p_mail_sender_name, FND_API.g_miss_char, NULL, p_mail_sender_name),
337: DECODE( p_mail_subject, FND_API.g_miss_char, NULL, p_mail_subject),
338: DECODE( p_from_fax_no, FND_API.g_miss_char, NULL, p_from_fax_no),
339: DECODE( p_accounts_closed_flag, FND_API.g_miss_char, 'N', p_accounts_closed_flag),
340: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
341: DECODE( p_objective_code, FND_API.g_miss_char, NULL, p_objective_code),
342: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
343: DECODE( p_campaign_calendar, FND_API.g_miss_char, NULL, p_campaign_calendar),
344: DECODE( p_start_period_name, FND_API.g_miss_char, NULL, p_start_period_name),
337: DECODE( p_mail_subject, FND_API.g_miss_char, NULL, p_mail_subject),
338: DECODE( p_from_fax_no, FND_API.g_miss_char, NULL, p_from_fax_no),
339: DECODE( p_accounts_closed_flag, FND_API.g_miss_char, 'N', p_accounts_closed_flag),
340: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
341: DECODE( p_objective_code, FND_API.g_miss_char, NULL, p_objective_code),
342: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
343: DECODE( p_campaign_calendar, FND_API.g_miss_char, NULL, p_campaign_calendar),
344: DECODE( p_start_period_name, FND_API.g_miss_char, NULL, p_start_period_name),
345: DECODE( p_end_period_name, FND_API.g_miss_char, NULL, p_end_period_name),
338: DECODE( p_from_fax_no, FND_API.g_miss_char, NULL, p_from_fax_no),
339: DECODE( p_accounts_closed_flag, FND_API.g_miss_char, 'N', p_accounts_closed_flag),
340: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
341: DECODE( p_objective_code, FND_API.g_miss_char, NULL, p_objective_code),
342: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
343: DECODE( p_campaign_calendar, FND_API.g_miss_char, NULL, p_campaign_calendar),
344: DECODE( p_start_period_name, FND_API.g_miss_char, NULL, p_start_period_name),
345: DECODE( p_end_period_name, FND_API.g_miss_char, NULL, p_end_period_name),
346: DECODE( p_priority, FND_API.g_miss_char, NULL, p_priority),
339: DECODE( p_accounts_closed_flag, FND_API.g_miss_char, 'N', p_accounts_closed_flag),
340: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
341: DECODE( p_objective_code, FND_API.g_miss_char, NULL, p_objective_code),
342: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
343: DECODE( p_campaign_calendar, FND_API.g_miss_char, NULL, p_campaign_calendar),
344: DECODE( p_start_period_name, FND_API.g_miss_char, NULL, p_start_period_name),
345: DECODE( p_end_period_name, FND_API.g_miss_char, NULL, p_end_period_name),
346: DECODE( p_priority, FND_API.g_miss_char, NULL, p_priority),
347: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
340: DECODE( px_org_id, FND_API.g_miss_num, NULL, px_org_id),
341: DECODE( p_objective_code, FND_API.g_miss_char, NULL, p_objective_code),
342: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
343: DECODE( p_campaign_calendar, FND_API.g_miss_char, NULL, p_campaign_calendar),
344: DECODE( p_start_period_name, FND_API.g_miss_char, NULL, p_start_period_name),
345: DECODE( p_end_period_name, FND_API.g_miss_char, NULL, p_end_period_name),
346: DECODE( p_priority, FND_API.g_miss_char, NULL, p_priority),
347: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
348: DECODE( p_transaction_currency_code, FND_API.g_miss_char, NULL, p_transaction_currency_code),
341: DECODE( p_objective_code, FND_API.g_miss_char, NULL, p_objective_code),
342: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
343: DECODE( p_campaign_calendar, FND_API.g_miss_char, NULL, p_campaign_calendar),
344: DECODE( p_start_period_name, FND_API.g_miss_char, NULL, p_start_period_name),
345: DECODE( p_end_period_name, FND_API.g_miss_char, NULL, p_end_period_name),
346: DECODE( p_priority, FND_API.g_miss_char, NULL, p_priority),
347: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
348: DECODE( p_transaction_currency_code, FND_API.g_miss_char, NULL, p_transaction_currency_code),
349: DECODE( p_functional_currency_code, FND_API.g_miss_char, NULL, p_functional_currency_code),
342: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
343: DECODE( p_campaign_calendar, FND_API.g_miss_char, NULL, p_campaign_calendar),
344: DECODE( p_start_period_name, FND_API.g_miss_char, NULL, p_start_period_name),
345: DECODE( p_end_period_name, FND_API.g_miss_char, NULL, p_end_period_name),
346: DECODE( p_priority, FND_API.g_miss_char, NULL, p_priority),
347: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
348: DECODE( p_transaction_currency_code, FND_API.g_miss_char, NULL, p_transaction_currency_code),
349: DECODE( p_functional_currency_code, FND_API.g_miss_char, NULL, p_functional_currency_code),
350: DECODE( p_budget_amount_tc ,FND_API.g_miss_num,NULL,p_budget_amount_tc),
343: DECODE( p_campaign_calendar, FND_API.g_miss_char, NULL, p_campaign_calendar),
344: DECODE( p_start_period_name, FND_API.g_miss_char, NULL, p_start_period_name),
345: DECODE( p_end_period_name, FND_API.g_miss_char, NULL, p_end_period_name),
346: DECODE( p_priority, FND_API.g_miss_char, NULL, p_priority),
347: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
348: DECODE( p_transaction_currency_code, FND_API.g_miss_char, NULL, p_transaction_currency_code),
349: DECODE( p_functional_currency_code, FND_API.g_miss_char, NULL, p_functional_currency_code),
350: DECODE( p_budget_amount_tc ,FND_API.g_miss_num,NULL,p_budget_amount_tc),
351: DECODE( p_budget_amount_fc ,FND_API.g_miss_num,NULL,p_budget_amount_fc),
344: DECODE( p_start_period_name, FND_API.g_miss_char, NULL, p_start_period_name),
345: DECODE( p_end_period_name, FND_API.g_miss_char, NULL, p_end_period_name),
346: DECODE( p_priority, FND_API.g_miss_char, NULL, p_priority),
347: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
348: DECODE( p_transaction_currency_code, FND_API.g_miss_char, NULL, p_transaction_currency_code),
349: DECODE( p_functional_currency_code, FND_API.g_miss_char, NULL, p_functional_currency_code),
350: DECODE( p_budget_amount_tc ,FND_API.g_miss_num,NULL,p_budget_amount_tc),
351: DECODE( p_budget_amount_fc ,FND_API.g_miss_num,NULL,p_budget_amount_fc),
352: DECODE( p_language_code ,FND_API.g_miss_char,NULL,p_language_code),
345: DECODE( p_end_period_name, FND_API.g_miss_char, NULL, p_end_period_name),
346: DECODE( p_priority, FND_API.g_miss_char, NULL, p_priority),
347: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
348: DECODE( p_transaction_currency_code, FND_API.g_miss_char, NULL, p_transaction_currency_code),
349: DECODE( p_functional_currency_code, FND_API.g_miss_char, NULL, p_functional_currency_code),
350: DECODE( p_budget_amount_tc ,FND_API.g_miss_num,NULL,p_budget_amount_tc),
351: DECODE( p_budget_amount_fc ,FND_API.g_miss_num,NULL,p_budget_amount_fc),
352: DECODE( p_language_code ,FND_API.g_miss_char,NULL,p_language_code),
353: DECODE( p_task_id ,FND_API.g_miss_num,NULL,p_task_id),
346: DECODE( p_priority, FND_API.g_miss_char, NULL, p_priority),
347: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
348: DECODE( p_transaction_currency_code, FND_API.g_miss_char, NULL, p_transaction_currency_code),
349: DECODE( p_functional_currency_code, FND_API.g_miss_char, NULL, p_functional_currency_code),
350: DECODE( p_budget_amount_tc ,FND_API.g_miss_num,NULL,p_budget_amount_tc),
351: DECODE( p_budget_amount_fc ,FND_API.g_miss_num,NULL,p_budget_amount_fc),
352: DECODE( p_language_code ,FND_API.g_miss_char,NULL,p_language_code),
353: DECODE( p_task_id ,FND_API.g_miss_num,NULL,p_task_id),
354: DECODE( p_related_event_from ,FND_API.g_miss_char,NULL,p_related_event_from),
347: DECODE( p_workflow_item_key, FND_API.g_miss_char, NULL, p_workflow_item_key),
348: DECODE( p_transaction_currency_code, FND_API.g_miss_char, NULL, p_transaction_currency_code),
349: DECODE( p_functional_currency_code, FND_API.g_miss_char, NULL, p_functional_currency_code),
350: DECODE( p_budget_amount_tc ,FND_API.g_miss_num,NULL,p_budget_amount_tc),
351: DECODE( p_budget_amount_fc ,FND_API.g_miss_num,NULL,p_budget_amount_fc),
352: DECODE( p_language_code ,FND_API.g_miss_char,NULL,p_language_code),
353: DECODE( p_task_id ,FND_API.g_miss_num,NULL,p_task_id),
354: DECODE( p_related_event_from ,FND_API.g_miss_char,NULL,p_related_event_from),
355: DECODE( p_related_event_id ,FND_API.g_miss_num,NULL,p_related_event_id),
348: DECODE( p_transaction_currency_code, FND_API.g_miss_char, NULL, p_transaction_currency_code),
349: DECODE( p_functional_currency_code, FND_API.g_miss_char, NULL, p_functional_currency_code),
350: DECODE( p_budget_amount_tc ,FND_API.g_miss_num,NULL,p_budget_amount_tc),
351: DECODE( p_budget_amount_fc ,FND_API.g_miss_num,NULL,p_budget_amount_fc),
352: DECODE( p_language_code ,FND_API.g_miss_char,NULL,p_language_code),
353: DECODE( p_task_id ,FND_API.g_miss_num,NULL,p_task_id),
354: DECODE( p_related_event_from ,FND_API.g_miss_char,NULL,p_related_event_from),
355: DECODE( p_related_event_id ,FND_API.g_miss_num,NULL,p_related_event_id),
356: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
349: DECODE( p_functional_currency_code, FND_API.g_miss_char, NULL, p_functional_currency_code),
350: DECODE( p_budget_amount_tc ,FND_API.g_miss_num,NULL,p_budget_amount_tc),
351: DECODE( p_budget_amount_fc ,FND_API.g_miss_num,NULL,p_budget_amount_fc),
352: DECODE( p_language_code ,FND_API.g_miss_char,NULL,p_language_code),
353: DECODE( p_task_id ,FND_API.g_miss_num,NULL,p_task_id),
354: DECODE( p_related_event_from ,FND_API.g_miss_char,NULL,p_related_event_from),
355: DECODE( p_related_event_id ,FND_API.g_miss_num,NULL,p_related_event_id),
356: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
357: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
350: DECODE( p_budget_amount_tc ,FND_API.g_miss_num,NULL,p_budget_amount_tc),
351: DECODE( p_budget_amount_fc ,FND_API.g_miss_num,NULL,p_budget_amount_fc),
352: DECODE( p_language_code ,FND_API.g_miss_char,NULL,p_language_code),
353: DECODE( p_task_id ,FND_API.g_miss_num,NULL,p_task_id),
354: DECODE( p_related_event_from ,FND_API.g_miss_char,NULL,p_related_event_from),
355: DECODE( p_related_event_id ,FND_API.g_miss_num,NULL,p_related_event_id),
356: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
357: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
358: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
351: DECODE( p_budget_amount_fc ,FND_API.g_miss_num,NULL,p_budget_amount_fc),
352: DECODE( p_language_code ,FND_API.g_miss_char,NULL,p_language_code),
353: DECODE( p_task_id ,FND_API.g_miss_num,NULL,p_task_id),
354: DECODE( p_related_event_from ,FND_API.g_miss_char,NULL,p_related_event_from),
355: DECODE( p_related_event_id ,FND_API.g_miss_num,NULL,p_related_event_id),
356: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
357: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
358: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
359: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
352: DECODE( p_language_code ,FND_API.g_miss_char,NULL,p_language_code),
353: DECODE( p_task_id ,FND_API.g_miss_num,NULL,p_task_id),
354: DECODE( p_related_event_from ,FND_API.g_miss_char,NULL,p_related_event_from),
355: DECODE( p_related_event_id ,FND_API.g_miss_num,NULL,p_related_event_id),
356: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
357: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
358: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
359: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
360: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
353: DECODE( p_task_id ,FND_API.g_miss_num,NULL,p_task_id),
354: DECODE( p_related_event_from ,FND_API.g_miss_char,NULL,p_related_event_from),
355: DECODE( p_related_event_id ,FND_API.g_miss_num,NULL,p_related_event_id),
356: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
357: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
358: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
359: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
360: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
361: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
354: DECODE( p_related_event_from ,FND_API.g_miss_char,NULL,p_related_event_from),
355: DECODE( p_related_event_id ,FND_API.g_miss_num,NULL,p_related_event_id),
356: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
357: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
358: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
359: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
360: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
361: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
362: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
355: DECODE( p_related_event_id ,FND_API.g_miss_num,NULL,p_related_event_id),
356: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
357: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
358: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
359: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
360: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
361: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
362: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
363: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
356: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
357: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
358: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
359: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
360: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
361: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
362: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
363: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
364: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
357: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
358: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
359: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
360: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
361: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
362: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
363: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
364: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
365: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
358: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
359: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
360: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
361: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
362: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
363: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
364: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
365: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
366: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
359: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
360: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
361: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
362: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
363: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
364: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
365: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
366: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
367: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
360: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
361: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
362: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
363: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
364: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
365: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
366: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
367: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
368: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
361: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
362: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
363: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
364: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
365: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
366: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
367: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
368: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
369: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
362: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
363: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
364: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
365: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
366: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
367: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
368: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
369: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
370: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
363: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
364: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
365: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
366: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
367: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
368: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
369: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
370: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
371: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
364: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
365: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
366: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
367: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
368: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
369: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
370: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
371: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
372: DECODE( p_activity_attribute_category, FND_API.g_miss_char, NULL, p_activity_attribute_category),
365: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
366: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
367: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
368: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
369: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
370: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
371: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
372: DECODE( p_activity_attribute_category, FND_API.g_miss_char, NULL, p_activity_attribute_category),
373: DECODE( p_activity_attribute1, FND_API.g_miss_char, NULL, p_activity_attribute1),
366: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
367: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
368: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
369: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
370: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
371: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
372: DECODE( p_activity_attribute_category, FND_API.g_miss_char, NULL, p_activity_attribute_category),
373: DECODE( p_activity_attribute1, FND_API.g_miss_char, NULL, p_activity_attribute1),
374: DECODE( p_activity_attribute2, FND_API.g_miss_char, NULL, p_activity_attribute2),
367: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
368: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
369: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
370: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
371: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
372: DECODE( p_activity_attribute_category, FND_API.g_miss_char, NULL, p_activity_attribute_category),
373: DECODE( p_activity_attribute1, FND_API.g_miss_char, NULL, p_activity_attribute1),
374: DECODE( p_activity_attribute2, FND_API.g_miss_char, NULL, p_activity_attribute2),
375: DECODE( p_activity_attribute3, FND_API.g_miss_char, NULL, p_activity_attribute3),
368: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
369: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
370: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
371: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
372: DECODE( p_activity_attribute_category, FND_API.g_miss_char, NULL, p_activity_attribute_category),
373: DECODE( p_activity_attribute1, FND_API.g_miss_char, NULL, p_activity_attribute1),
374: DECODE( p_activity_attribute2, FND_API.g_miss_char, NULL, p_activity_attribute2),
375: DECODE( p_activity_attribute3, FND_API.g_miss_char, NULL, p_activity_attribute3),
376: DECODE( p_activity_attribute4, FND_API.g_miss_char, NULL, p_activity_attribute4),
369: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
370: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
371: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
372: DECODE( p_activity_attribute_category, FND_API.g_miss_char, NULL, p_activity_attribute_category),
373: DECODE( p_activity_attribute1, FND_API.g_miss_char, NULL, p_activity_attribute1),
374: DECODE( p_activity_attribute2, FND_API.g_miss_char, NULL, p_activity_attribute2),
375: DECODE( p_activity_attribute3, FND_API.g_miss_char, NULL, p_activity_attribute3),
376: DECODE( p_activity_attribute4, FND_API.g_miss_char, NULL, p_activity_attribute4),
377: DECODE( p_activity_attribute5, FND_API.g_miss_char, NULL, p_activity_attribute5),
370: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
371: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
372: DECODE( p_activity_attribute_category, FND_API.g_miss_char, NULL, p_activity_attribute_category),
373: DECODE( p_activity_attribute1, FND_API.g_miss_char, NULL, p_activity_attribute1),
374: DECODE( p_activity_attribute2, FND_API.g_miss_char, NULL, p_activity_attribute2),
375: DECODE( p_activity_attribute3, FND_API.g_miss_char, NULL, p_activity_attribute3),
376: DECODE( p_activity_attribute4, FND_API.g_miss_char, NULL, p_activity_attribute4),
377: DECODE( p_activity_attribute5, FND_API.g_miss_char, NULL, p_activity_attribute5),
378: DECODE( p_activity_attribute6, FND_API.g_miss_char, NULL, p_activity_attribute6),
371: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
372: DECODE( p_activity_attribute_category, FND_API.g_miss_char, NULL, p_activity_attribute_category),
373: DECODE( p_activity_attribute1, FND_API.g_miss_char, NULL, p_activity_attribute1),
374: DECODE( p_activity_attribute2, FND_API.g_miss_char, NULL, p_activity_attribute2),
375: DECODE( p_activity_attribute3, FND_API.g_miss_char, NULL, p_activity_attribute3),
376: DECODE( p_activity_attribute4, FND_API.g_miss_char, NULL, p_activity_attribute4),
377: DECODE( p_activity_attribute5, FND_API.g_miss_char, NULL, p_activity_attribute5),
378: DECODE( p_activity_attribute6, FND_API.g_miss_char, NULL, p_activity_attribute6),
379: DECODE( p_activity_attribute7, FND_API.g_miss_char, NULL, p_activity_attribute7),
372: DECODE( p_activity_attribute_category, FND_API.g_miss_char, NULL, p_activity_attribute_category),
373: DECODE( p_activity_attribute1, FND_API.g_miss_char, NULL, p_activity_attribute1),
374: DECODE( p_activity_attribute2, FND_API.g_miss_char, NULL, p_activity_attribute2),
375: DECODE( p_activity_attribute3, FND_API.g_miss_char, NULL, p_activity_attribute3),
376: DECODE( p_activity_attribute4, FND_API.g_miss_char, NULL, p_activity_attribute4),
377: DECODE( p_activity_attribute5, FND_API.g_miss_char, NULL, p_activity_attribute5),
378: DECODE( p_activity_attribute6, FND_API.g_miss_char, NULL, p_activity_attribute6),
379: DECODE( p_activity_attribute7, FND_API.g_miss_char, NULL, p_activity_attribute7),
380: DECODE( p_activity_attribute8, FND_API.g_miss_char, NULL, p_activity_attribute8),
373: DECODE( p_activity_attribute1, FND_API.g_miss_char, NULL, p_activity_attribute1),
374: DECODE( p_activity_attribute2, FND_API.g_miss_char, NULL, p_activity_attribute2),
375: DECODE( p_activity_attribute3, FND_API.g_miss_char, NULL, p_activity_attribute3),
376: DECODE( p_activity_attribute4, FND_API.g_miss_char, NULL, p_activity_attribute4),
377: DECODE( p_activity_attribute5, FND_API.g_miss_char, NULL, p_activity_attribute5),
378: DECODE( p_activity_attribute6, FND_API.g_miss_char, NULL, p_activity_attribute6),
379: DECODE( p_activity_attribute7, FND_API.g_miss_char, NULL, p_activity_attribute7),
380: DECODE( p_activity_attribute8, FND_API.g_miss_char, NULL, p_activity_attribute8),
381: DECODE( p_activity_attribute9, FND_API.g_miss_char, NULL, p_activity_attribute9),
374: DECODE( p_activity_attribute2, FND_API.g_miss_char, NULL, p_activity_attribute2),
375: DECODE( p_activity_attribute3, FND_API.g_miss_char, NULL, p_activity_attribute3),
376: DECODE( p_activity_attribute4, FND_API.g_miss_char, NULL, p_activity_attribute4),
377: DECODE( p_activity_attribute5, FND_API.g_miss_char, NULL, p_activity_attribute5),
378: DECODE( p_activity_attribute6, FND_API.g_miss_char, NULL, p_activity_attribute6),
379: DECODE( p_activity_attribute7, FND_API.g_miss_char, NULL, p_activity_attribute7),
380: DECODE( p_activity_attribute8, FND_API.g_miss_char, NULL, p_activity_attribute8),
381: DECODE( p_activity_attribute9, FND_API.g_miss_char, NULL, p_activity_attribute9),
382: DECODE( p_activity_attribute10, FND_API.g_miss_char, NULL, p_activity_attribute10),
375: DECODE( p_activity_attribute3, FND_API.g_miss_char, NULL, p_activity_attribute3),
376: DECODE( p_activity_attribute4, FND_API.g_miss_char, NULL, p_activity_attribute4),
377: DECODE( p_activity_attribute5, FND_API.g_miss_char, NULL, p_activity_attribute5),
378: DECODE( p_activity_attribute6, FND_API.g_miss_char, NULL, p_activity_attribute6),
379: DECODE( p_activity_attribute7, FND_API.g_miss_char, NULL, p_activity_attribute7),
380: DECODE( p_activity_attribute8, FND_API.g_miss_char, NULL, p_activity_attribute8),
381: DECODE( p_activity_attribute9, FND_API.g_miss_char, NULL, p_activity_attribute9),
382: DECODE( p_activity_attribute10, FND_API.g_miss_char, NULL, p_activity_attribute10),
383: DECODE( p_activity_attribute11, FND_API.g_miss_char, NULL, p_activity_attribute11),
376: DECODE( p_activity_attribute4, FND_API.g_miss_char, NULL, p_activity_attribute4),
377: DECODE( p_activity_attribute5, FND_API.g_miss_char, NULL, p_activity_attribute5),
378: DECODE( p_activity_attribute6, FND_API.g_miss_char, NULL, p_activity_attribute6),
379: DECODE( p_activity_attribute7, FND_API.g_miss_char, NULL, p_activity_attribute7),
380: DECODE( p_activity_attribute8, FND_API.g_miss_char, NULL, p_activity_attribute8),
381: DECODE( p_activity_attribute9, FND_API.g_miss_char, NULL, p_activity_attribute9),
382: DECODE( p_activity_attribute10, FND_API.g_miss_char, NULL, p_activity_attribute10),
383: DECODE( p_activity_attribute11, FND_API.g_miss_char, NULL, p_activity_attribute11),
384: DECODE( p_activity_attribute12, FND_API.g_miss_char, NULL, p_activity_attribute12),
377: DECODE( p_activity_attribute5, FND_API.g_miss_char, NULL, p_activity_attribute5),
378: DECODE( p_activity_attribute6, FND_API.g_miss_char, NULL, p_activity_attribute6),
379: DECODE( p_activity_attribute7, FND_API.g_miss_char, NULL, p_activity_attribute7),
380: DECODE( p_activity_attribute8, FND_API.g_miss_char, NULL, p_activity_attribute8),
381: DECODE( p_activity_attribute9, FND_API.g_miss_char, NULL, p_activity_attribute9),
382: DECODE( p_activity_attribute10, FND_API.g_miss_char, NULL, p_activity_attribute10),
383: DECODE( p_activity_attribute11, FND_API.g_miss_char, NULL, p_activity_attribute11),
384: DECODE( p_activity_attribute12, FND_API.g_miss_char, NULL, p_activity_attribute12),
385: DECODE( p_activity_attribute13, FND_API.g_miss_char, NULL, p_activity_attribute13),
378: DECODE( p_activity_attribute6, FND_API.g_miss_char, NULL, p_activity_attribute6),
379: DECODE( p_activity_attribute7, FND_API.g_miss_char, NULL, p_activity_attribute7),
380: DECODE( p_activity_attribute8, FND_API.g_miss_char, NULL, p_activity_attribute8),
381: DECODE( p_activity_attribute9, FND_API.g_miss_char, NULL, p_activity_attribute9),
382: DECODE( p_activity_attribute10, FND_API.g_miss_char, NULL, p_activity_attribute10),
383: DECODE( p_activity_attribute11, FND_API.g_miss_char, NULL, p_activity_attribute11),
384: DECODE( p_activity_attribute12, FND_API.g_miss_char, NULL, p_activity_attribute12),
385: DECODE( p_activity_attribute13, FND_API.g_miss_char, NULL, p_activity_attribute13),
386: DECODE( p_activity_attribute14, FND_API.g_miss_char, NULL, p_activity_attribute14),
379: DECODE( p_activity_attribute7, FND_API.g_miss_char, NULL, p_activity_attribute7),
380: DECODE( p_activity_attribute8, FND_API.g_miss_char, NULL, p_activity_attribute8),
381: DECODE( p_activity_attribute9, FND_API.g_miss_char, NULL, p_activity_attribute9),
382: DECODE( p_activity_attribute10, FND_API.g_miss_char, NULL, p_activity_attribute10),
383: DECODE( p_activity_attribute11, FND_API.g_miss_char, NULL, p_activity_attribute11),
384: DECODE( p_activity_attribute12, FND_API.g_miss_char, NULL, p_activity_attribute12),
385: DECODE( p_activity_attribute13, FND_API.g_miss_char, NULL, p_activity_attribute13),
386: DECODE( p_activity_attribute14, FND_API.g_miss_char, NULL, p_activity_attribute14),
387: DECODE( p_activity_attribute15, FND_API.g_miss_char, NULL, p_activity_attribute15),
380: DECODE( p_activity_attribute8, FND_API.g_miss_char, NULL, p_activity_attribute8),
381: DECODE( p_activity_attribute9, FND_API.g_miss_char, NULL, p_activity_attribute9),
382: DECODE( p_activity_attribute10, FND_API.g_miss_char, NULL, p_activity_attribute10),
383: DECODE( p_activity_attribute11, FND_API.g_miss_char, NULL, p_activity_attribute11),
384: DECODE( p_activity_attribute12, FND_API.g_miss_char, NULL, p_activity_attribute12),
385: DECODE( p_activity_attribute13, FND_API.g_miss_char, NULL, p_activity_attribute13),
386: DECODE( p_activity_attribute14, FND_API.g_miss_char, NULL, p_activity_attribute14),
387: DECODE( p_activity_attribute15, FND_API.g_miss_char, NULL, p_activity_attribute15),
388: -- removed by soagrawa on 24-sep-2001
381: DECODE( p_activity_attribute9, FND_API.g_miss_char, NULL, p_activity_attribute9),
382: DECODE( p_activity_attribute10, FND_API.g_miss_char, NULL, p_activity_attribute10),
383: DECODE( p_activity_attribute11, FND_API.g_miss_char, NULL, p_activity_attribute11),
384: DECODE( p_activity_attribute12, FND_API.g_miss_char, NULL, p_activity_attribute12),
385: DECODE( p_activity_attribute13, FND_API.g_miss_char, NULL, p_activity_attribute13),
386: DECODE( p_activity_attribute14, FND_API.g_miss_char, NULL, p_activity_attribute14),
387: DECODE( p_activity_attribute15, FND_API.g_miss_char, NULL, p_activity_attribute15),
388: -- removed by soagrawa on 24-sep-2001
389: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
382: DECODE( p_activity_attribute10, FND_API.g_miss_char, NULL, p_activity_attribute10),
383: DECODE( p_activity_attribute11, FND_API.g_miss_char, NULL, p_activity_attribute11),
384: DECODE( p_activity_attribute12, FND_API.g_miss_char, NULL, p_activity_attribute12),
385: DECODE( p_activity_attribute13, FND_API.g_miss_char, NULL, p_activity_attribute13),
386: DECODE( p_activity_attribute14, FND_API.g_miss_char, NULL, p_activity_attribute14),
387: DECODE( p_activity_attribute15, FND_API.g_miss_char, NULL, p_activity_attribute15),
388: -- removed by soagrawa on 24-sep-2001
389: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
390: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
383: DECODE( p_activity_attribute11, FND_API.g_miss_char, NULL, p_activity_attribute11),
384: DECODE( p_activity_attribute12, FND_API.g_miss_char, NULL, p_activity_attribute12),
385: DECODE( p_activity_attribute13, FND_API.g_miss_char, NULL, p_activity_attribute13),
386: DECODE( p_activity_attribute14, FND_API.g_miss_char, NULL, p_activity_attribute14),
387: DECODE( p_activity_attribute15, FND_API.g_miss_char, NULL, p_activity_attribute15),
388: -- removed by soagrawa on 24-sep-2001
389: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
390: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
391: DECODE( p_include_content_flag, FND_API.g_miss_char,NULL,p_include_content_flag),
385: DECODE( p_activity_attribute13, FND_API.g_miss_char, NULL, p_activity_attribute13),
386: DECODE( p_activity_attribute14, FND_API.g_miss_char, NULL, p_activity_attribute14),
387: DECODE( p_activity_attribute15, FND_API.g_miss_char, NULL, p_activity_attribute15),
388: -- removed by soagrawa on 24-sep-2001
389: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
390: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
391: DECODE( p_include_content_flag, FND_API.g_miss_char,NULL,p_include_content_flag),
392: DECODE( p_content_type, FND_API.g_miss_char,NULL,p_content_type),
393: DECODE( p_test_email_address, FND_API.g_miss_char,NULL,p_test_email_address),
386: DECODE( p_activity_attribute14, FND_API.g_miss_char, NULL, p_activity_attribute14),
387: DECODE( p_activity_attribute15, FND_API.g_miss_char, NULL, p_activity_attribute15),
388: -- removed by soagrawa on 24-sep-2001
389: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
390: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
391: DECODE( p_include_content_flag, FND_API.g_miss_char,NULL,p_include_content_flag),
392: DECODE( p_content_type, FND_API.g_miss_char,NULL,p_content_type),
393: DECODE( p_test_email_address, FND_API.g_miss_char,NULL,p_test_email_address),
394: --added by anchaudh on 30-apr-2003
387: DECODE( p_activity_attribute15, FND_API.g_miss_char, NULL, p_activity_attribute15),
388: -- removed by soagrawa on 24-sep-2001
389: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
390: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
391: DECODE( p_include_content_flag, FND_API.g_miss_char,NULL,p_include_content_flag),
392: DECODE( p_content_type, FND_API.g_miss_char,NULL,p_content_type),
393: DECODE( p_test_email_address, FND_API.g_miss_char,NULL,p_test_email_address),
394: --added by anchaudh on 30-apr-2003
395: DECODE( p_trig_repeat_flag, FND_API.g_miss_char, 'N',p_trig_repeat_flag),
388: -- removed by soagrawa on 24-sep-2001
389: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
390: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
391: DECODE( p_include_content_flag, FND_API.g_miss_char,NULL,p_include_content_flag),
392: DECODE( p_content_type, FND_API.g_miss_char,NULL,p_content_type),
393: DECODE( p_test_email_address, FND_API.g_miss_char,NULL,p_test_email_address),
394: --added by anchaudh on 30-apr-2003
395: DECODE( p_trig_repeat_flag, FND_API.g_miss_char, 'N',p_trig_repeat_flag),
396: DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, 'N', p_tgrp_exclude_prev_flag),
389: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
390: DECODE( p_query_id, FND_API.g_miss_num, NULL, p_query_id),
391: DECODE( p_include_content_flag, FND_API.g_miss_char,NULL,p_include_content_flag),
392: DECODE( p_content_type, FND_API.g_miss_char,NULL,p_content_type),
393: DECODE( p_test_email_address, FND_API.g_miss_char,NULL,p_test_email_address),
394: --added by anchaudh on 30-apr-2003
395: DECODE( p_trig_repeat_flag, FND_API.g_miss_char, 'N',p_trig_repeat_flag),
396: DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, 'N', p_tgrp_exclude_prev_flag),
397: --added by anchaudh on 06-may-2003
391: DECODE( p_include_content_flag, FND_API.g_miss_char,NULL,p_include_content_flag),
392: DECODE( p_content_type, FND_API.g_miss_char,NULL,p_content_type),
393: DECODE( p_test_email_address, FND_API.g_miss_char,NULL,p_test_email_address),
394: --added by anchaudh on 30-apr-2003
395: DECODE( p_trig_repeat_flag, FND_API.g_miss_char, 'N',p_trig_repeat_flag),
396: DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, 'N', p_tgrp_exclude_prev_flag),
397: --added by anchaudh on 06-may-2003
398: DECODE( p_orig_csch_id, FND_API.g_miss_num, NULL, p_orig_csch_id),
399: DECODE( p_cover_letter_version, FND_API.g_miss_num, NULL, p_cover_letter_version),
392: DECODE( p_content_type, FND_API.g_miss_char,NULL,p_content_type),
393: DECODE( p_test_email_address, FND_API.g_miss_char,NULL,p_test_email_address),
394: --added by anchaudh on 30-apr-2003
395: DECODE( p_trig_repeat_flag, FND_API.g_miss_char, 'N',p_trig_repeat_flag),
396: DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, 'N', p_tgrp_exclude_prev_flag),
397: --added by anchaudh on 06-may-2003
398: DECODE( p_orig_csch_id, FND_API.g_miss_num, NULL, p_orig_csch_id),
399: DECODE( p_cover_letter_version, FND_API.g_miss_num, NULL, p_cover_letter_version),
400: DECODE( p_usage, FND_API.g_miss_char,NULL,p_usage),
394: --added by anchaudh on 30-apr-2003
395: DECODE( p_trig_repeat_flag, FND_API.g_miss_char, 'N',p_trig_repeat_flag),
396: DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, 'N', p_tgrp_exclude_prev_flag),
397: --added by anchaudh on 06-may-2003
398: DECODE( p_orig_csch_id, FND_API.g_miss_num, NULL, p_orig_csch_id),
399: DECODE( p_cover_letter_version, FND_API.g_miss_num, NULL, p_cover_letter_version),
400: DECODE( p_usage, FND_API.g_miss_char,NULL,p_usage),
401: DECODE( p_purpose, FND_API.g_miss_char,NULL,p_purpose),
402: DECODE( p_last_activation_date, FND_API.g_miss_date,NULL,p_last_activation_date),
395: DECODE( p_trig_repeat_flag, FND_API.g_miss_char, 'N',p_trig_repeat_flag),
396: DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, 'N', p_tgrp_exclude_prev_flag),
397: --added by anchaudh on 06-may-2003
398: DECODE( p_orig_csch_id, FND_API.g_miss_num, NULL, p_orig_csch_id),
399: DECODE( p_cover_letter_version, FND_API.g_miss_num, NULL, p_cover_letter_version),
400: DECODE( p_usage, FND_API.g_miss_char,NULL,p_usage),
401: DECODE( p_purpose, FND_API.g_miss_char,NULL,p_purpose),
402: DECODE( p_last_activation_date, FND_API.g_miss_date,NULL,p_last_activation_date),
403: DECODE( p_sales_methodology_id, FND_API.g_miss_num,NULL,p_sales_methodology_id),
396: DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, 'N', p_tgrp_exclude_prev_flag),
397: --added by anchaudh on 06-may-2003
398: DECODE( p_orig_csch_id, FND_API.g_miss_num, NULL, p_orig_csch_id),
399: DECODE( p_cover_letter_version, FND_API.g_miss_num, NULL, p_cover_letter_version),
400: DECODE( p_usage, FND_API.g_miss_char,NULL,p_usage),
401: DECODE( p_purpose, FND_API.g_miss_char,NULL,p_purpose),
402: DECODE( p_last_activation_date, FND_API.g_miss_date,NULL,p_last_activation_date),
403: DECODE( p_sales_methodology_id, FND_API.g_miss_num,NULL,p_sales_methodology_id),
404: DECODE( p_printer_address, FND_API.g_miss_char,NULL,p_printer_address),
397: --added by anchaudh on 06-may-2003
398: DECODE( p_orig_csch_id, FND_API.g_miss_num, NULL, p_orig_csch_id),
399: DECODE( p_cover_letter_version, FND_API.g_miss_num, NULL, p_cover_letter_version),
400: DECODE( p_usage, FND_API.g_miss_char,NULL,p_usage),
401: DECODE( p_purpose, FND_API.g_miss_char,NULL,p_purpose),
402: DECODE( p_last_activation_date, FND_API.g_miss_date,NULL,p_last_activation_date),
403: DECODE( p_sales_methodology_id, FND_API.g_miss_num,NULL,p_sales_methodology_id),
404: DECODE( p_printer_address, FND_API.g_miss_char,NULL,p_printer_address),
405: DECODE( p_notify_on_activation_flag, FND_API.g_miss_char,NULL,p_notify_on_activation_flag),
398: DECODE( p_orig_csch_id, FND_API.g_miss_num, NULL, p_orig_csch_id),
399: DECODE( p_cover_letter_version, FND_API.g_miss_num, NULL, p_cover_letter_version),
400: DECODE( p_usage, FND_API.g_miss_char,NULL,p_usage),
401: DECODE( p_purpose, FND_API.g_miss_char,NULL,p_purpose),
402: DECODE( p_last_activation_date, FND_API.g_miss_date,NULL,p_last_activation_date),
403: DECODE( p_sales_methodology_id, FND_API.g_miss_num,NULL,p_sales_methodology_id),
404: DECODE( p_printer_address, FND_API.g_miss_char,NULL,p_printer_address),
405: DECODE( p_notify_on_activation_flag, FND_API.g_miss_char,NULL,p_notify_on_activation_flag),
406: DECODE( p_sender_display_name, FND_API.g_miss_char,NULL,p_sender_display_name)--anchaudh
399: DECODE( p_cover_letter_version, FND_API.g_miss_num, NULL, p_cover_letter_version),
400: DECODE( p_usage, FND_API.g_miss_char,NULL,p_usage),
401: DECODE( p_purpose, FND_API.g_miss_char,NULL,p_purpose),
402: DECODE( p_last_activation_date, FND_API.g_miss_date,NULL,p_last_activation_date),
403: DECODE( p_sales_methodology_id, FND_API.g_miss_num,NULL,p_sales_methodology_id),
404: DECODE( p_printer_address, FND_API.g_miss_char,NULL,p_printer_address),
405: DECODE( p_notify_on_activation_flag, FND_API.g_miss_char,NULL,p_notify_on_activation_flag),
406: DECODE( p_sender_display_name, FND_API.g_miss_char,NULL,p_sender_display_name)--anchaudh
407: ,DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)
400: DECODE( p_usage, FND_API.g_miss_char,NULL,p_usage),
401: DECODE( p_purpose, FND_API.g_miss_char,NULL,p_purpose),
402: DECODE( p_last_activation_date, FND_API.g_miss_date,NULL,p_last_activation_date),
403: DECODE( p_sales_methodology_id, FND_API.g_miss_num,NULL,p_sales_methodology_id),
404: DECODE( p_printer_address, FND_API.g_miss_char,NULL,p_printer_address),
405: DECODE( p_notify_on_activation_flag, FND_API.g_miss_char,NULL,p_notify_on_activation_flag),
406: DECODE( p_sender_display_name, FND_API.g_miss_char,NULL,p_sender_display_name)--anchaudh
407: ,DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)
408: );
401: DECODE( p_purpose, FND_API.g_miss_char,NULL,p_purpose),
402: DECODE( p_last_activation_date, FND_API.g_miss_date,NULL,p_last_activation_date),
403: DECODE( p_sales_methodology_id, FND_API.g_miss_num,NULL,p_sales_methodology_id),
404: DECODE( p_printer_address, FND_API.g_miss_char,NULL,p_printer_address),
405: DECODE( p_notify_on_activation_flag, FND_API.g_miss_char,NULL,p_notify_on_activation_flag),
406: DECODE( p_sender_display_name, FND_API.g_miss_char,NULL,p_sender_display_name)--anchaudh
407: ,DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)
408: );
409:
402: DECODE( p_last_activation_date, FND_API.g_miss_date,NULL,p_last_activation_date),
403: DECODE( p_sales_methodology_id, FND_API.g_miss_num,NULL,p_sales_methodology_id),
404: DECODE( p_printer_address, FND_API.g_miss_char,NULL,p_printer_address),
405: DECODE( p_notify_on_activation_flag, FND_API.g_miss_char,NULL,p_notify_on_activation_flag),
406: DECODE( p_sender_display_name, FND_API.g_miss_char,NULL,p_sender_display_name)--anchaudh
407: ,DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)
408: );
409:
410: INSERT INTO AMS_CAMPAIGN_SCHEDULES_TL(
403: DECODE( p_sales_methodology_id, FND_API.g_miss_num,NULL,p_sales_methodology_id),
404: DECODE( p_printer_address, FND_API.g_miss_char,NULL,p_printer_address),
405: DECODE( p_notify_on_activation_flag, FND_API.g_miss_char,NULL,p_notify_on_activation_flag),
406: DECODE( p_sender_display_name, FND_API.g_miss_char,NULL,p_sender_display_name)--anchaudh
407: ,DECODE( p_delivery_mode, FND_API.g_miss_char, NULL, p_delivery_mode)
408: );
409:
410: INSERT INTO AMS_CAMPAIGN_SCHEDULES_TL(
411: schedule_id,
423: greeting_text,
424: footer_text
425: )
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,
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
438: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
439: DECODE( p_greeting_text, FND_API.g_miss_char, NULL, p_greeting_text),
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
438: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
439: DECODE( p_greeting_text, FND_API.g_miss_char, NULL, p_greeting_text),
440: DECODE( p_footer_text, FND_API.g_miss_char, NULL, p_footer_text)
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
438: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
439: DECODE( p_greeting_text, FND_API.g_miss_char, NULL, p_greeting_text),
440: DECODE( p_footer_text, FND_API.g_miss_char, NULL, p_footer_text)
441: FROM fnd_languages l
442: WHERE l.installed_flag IN ('I','B')
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
438: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
439: DECODE( p_greeting_text, FND_API.g_miss_char, NULL, p_greeting_text),
440: DECODE( p_footer_text, FND_API.g_miss_char, NULL, p_footer_text)
441: FROM fnd_languages l
442: WHERE l.installed_flag IN ('I','B')
443: AND NOT EXISTS(
436: DECODE( p_schedule_description, FND_API.g_miss_char, NULL, p_schedule_description),
437: -- removed by soagrawa on 24-sep-2001
438: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
439: DECODE( p_greeting_text, FND_API.g_miss_char, NULL, p_greeting_text),
440: DECODE( p_footer_text, FND_API.g_miss_char, NULL, p_footer_text)
441: FROM fnd_languages l
442: WHERE l.installed_flag IN ('I','B')
443: AND NOT EXISTS(
444: SELECT NULL
442: WHERE l.installed_flag IN ('I','B')
443: AND NOT EXISTS(
444: SELECT NULL
445: FROM ams_campaign_schedules_tl t
446: WHERE t.schedule_id = DECODE( px_schedule_id, FND_API.g_miss_num, NULL, px_schedule_id)
447: AND t.language = l.language_code ) ;
448:
449:
450:
591: -- added by soagrawa on 26-sep-2001
592: -- for storing time correctly in the database
593: -- DBMS_OUTPUT.PUT_LINE('Start date : '||TO_CHAR(p_start_date_time,'DDMMYY HH:MI:SS PM'));
594:
595: IF p_start_date_time = FND_API.g_miss_date THEN
596: l_start_date := NULL ;
597: ELSE
598: l_start_date := p_start_date_time ;
599: END IF ;
597: ELSE
598: l_start_date := p_start_date_time ;
599: END IF ;
600:
601: IF p_end_date_time = FND_API.g_miss_date THEN
602: l_end_date := null ;
603: ELSE
604: l_end_date := p_end_date_time ;
605: END IF ;
607: -- end soagrawa 26-sep-2001
608: -- Debug Message Commented by ptendulk Bug 2767243
609: -- ams_utility_pvt.debug_message('Transaction currency :: '||p_transaction_currency_code);
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),
608: -- Debug Message Commented by ptendulk Bug 2767243
609: -- ams_utility_pvt.debug_message('Transaction currency :: '||p_transaction_currency_code);
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
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),
619: -- removed by aranka on 26-dec-2001
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),
619: -- removed by aranka on 26-dec-2001
620: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
621: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+ 1),
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),
619: -- removed by aranka on 26-dec-2001
620: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
621: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+ 1),
622: campaign_id = DECODE( p_campaign_id, FND_API.g_miss_num, campaign_id, p_campaign_id),
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),
619: -- removed by aranka on 26-dec-2001
620: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
621: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+ 1),
622: campaign_id = DECODE( p_campaign_id, FND_API.g_miss_num, campaign_id, p_campaign_id),
623: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
624: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
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),
619: -- removed by aranka on 26-dec-2001
620: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
621: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+ 1),
622: campaign_id = DECODE( p_campaign_id, FND_API.g_miss_num, campaign_id, p_campaign_id),
623: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
624: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
625: status_date = DECODE( p_status_date, FND_API.g_miss_date, status_date, p_status_date),
618: -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
619: -- removed by aranka on 26-dec-2001
620: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
621: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+ 1),
622: campaign_id = DECODE( p_campaign_id, FND_API.g_miss_num, campaign_id, p_campaign_id),
623: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
624: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
625: status_date = DECODE( p_status_date, FND_API.g_miss_date, status_date, p_status_date),
626: source_code = DECODE( p_source_code, FND_API.g_miss_char, source_code, p_source_code),
619: -- removed by aranka on 26-dec-2001
620: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
621: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+ 1),
622: campaign_id = DECODE( p_campaign_id, FND_API.g_miss_num, campaign_id, p_campaign_id),
623: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
624: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
625: status_date = DECODE( p_status_date, FND_API.g_miss_date, status_date, p_status_date),
626: source_code = DECODE( p_source_code, FND_API.g_miss_char, source_code, p_source_code),
627: use_parent_code_flag = DECODE( p_use_parent_code_flag, FND_API.g_miss_char, use_parent_code_flag, p_use_parent_code_flag),
620: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
621: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+ 1),
622: campaign_id = DECODE( p_campaign_id, FND_API.g_miss_num, campaign_id, p_campaign_id),
623: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
624: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
625: status_date = DECODE( p_status_date, FND_API.g_miss_date, status_date, p_status_date),
626: source_code = DECODE( p_source_code, FND_API.g_miss_char, source_code, p_source_code),
627: use_parent_code_flag = DECODE( p_use_parent_code_flag, FND_API.g_miss_char, use_parent_code_flag, p_use_parent_code_flag),
628: -- date stuff modified by soagrawa on 26-sep-2001 to save time as well, decode messes time up
621: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+ 1),
622: campaign_id = DECODE( p_campaign_id, FND_API.g_miss_num, campaign_id, p_campaign_id),
623: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
624: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
625: status_date = DECODE( p_status_date, FND_API.g_miss_date, status_date, p_status_date),
626: source_code = DECODE( p_source_code, FND_API.g_miss_char, source_code, p_source_code),
627: use_parent_code_flag = DECODE( p_use_parent_code_flag, FND_API.g_miss_char, use_parent_code_flag, p_use_parent_code_flag),
628: -- date stuff modified by soagrawa on 26-sep-2001 to save time as well, decode messes time up
629: -- start_date_time = DECODE( p_start_date_time, FND_API.g_miss_date, start_date_time, p_start_date_time),
622: campaign_id = DECODE( p_campaign_id, FND_API.g_miss_num, campaign_id, p_campaign_id),
623: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
624: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
625: status_date = DECODE( p_status_date, FND_API.g_miss_date, status_date, p_status_date),
626: source_code = DECODE( p_source_code, FND_API.g_miss_char, source_code, p_source_code),
627: use_parent_code_flag = DECODE( p_use_parent_code_flag, FND_API.g_miss_char, use_parent_code_flag, p_use_parent_code_flag),
628: -- date stuff modified by soagrawa on 26-sep-2001 to save time as well, decode messes time up
629: -- start_date_time = DECODE( p_start_date_time, FND_API.g_miss_date, start_date_time, p_start_date_time),
630: -- end_date_time = DECODE( p_end_date_time, FND_API.g_miss_date, end_date_time, p_end_date_time),
623: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
624: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
625: status_date = DECODE( p_status_date, FND_API.g_miss_date, status_date, p_status_date),
626: source_code = DECODE( p_source_code, FND_API.g_miss_char, source_code, p_source_code),
627: use_parent_code_flag = DECODE( p_use_parent_code_flag, FND_API.g_miss_char, use_parent_code_flag, p_use_parent_code_flag),
628: -- date stuff modified by soagrawa on 26-sep-2001 to save time as well, decode messes time up
629: -- start_date_time = DECODE( p_start_date_time, FND_API.g_miss_date, start_date_time, p_start_date_time),
630: -- end_date_time = DECODE( p_end_date_time, FND_API.g_miss_date, end_date_time, p_end_date_time),
631: start_date_time = l_start_date,
625: status_date = DECODE( p_status_date, FND_API.g_miss_date, status_date, p_status_date),
626: source_code = DECODE( p_source_code, FND_API.g_miss_char, source_code, p_source_code),
627: use_parent_code_flag = DECODE( p_use_parent_code_flag, FND_API.g_miss_char, use_parent_code_flag, p_use_parent_code_flag),
628: -- date stuff modified by soagrawa on 26-sep-2001 to save time as well, decode messes time up
629: -- start_date_time = DECODE( p_start_date_time, FND_API.g_miss_date, start_date_time, p_start_date_time),
630: -- end_date_time = DECODE( p_end_date_time, FND_API.g_miss_date, end_date_time, p_end_date_time),
631: start_date_time = l_start_date,
632: end_date_time = l_end_date,
633: timezone_id = DECODE( p_timezone_id, FND_API.g_miss_num, timezone_id, p_timezone_id),
626: source_code = DECODE( p_source_code, FND_API.g_miss_char, source_code, p_source_code),
627: use_parent_code_flag = DECODE( p_use_parent_code_flag, FND_API.g_miss_char, use_parent_code_flag, p_use_parent_code_flag),
628: -- date stuff modified by soagrawa on 26-sep-2001 to save time as well, decode messes time up
629: -- start_date_time = DECODE( p_start_date_time, FND_API.g_miss_date, start_date_time, p_start_date_time),
630: -- end_date_time = DECODE( p_end_date_time, FND_API.g_miss_date, end_date_time, p_end_date_time),
631: start_date_time = l_start_date,
632: end_date_time = l_end_date,
633: timezone_id = DECODE( p_timezone_id, FND_API.g_miss_num, timezone_id, p_timezone_id),
634: activity_type_code = DECODE( p_activity_type_code, FND_API.g_miss_char, activity_type_code, p_activity_type_code),
629: -- start_date_time = DECODE( p_start_date_time, FND_API.g_miss_date, start_date_time, p_start_date_time),
630: -- end_date_time = DECODE( p_end_date_time, FND_API.g_miss_date, end_date_time, p_end_date_time),
631: start_date_time = l_start_date,
632: end_date_time = l_end_date,
633: timezone_id = DECODE( p_timezone_id, FND_API.g_miss_num, timezone_id, p_timezone_id),
634: activity_type_code = DECODE( p_activity_type_code, FND_API.g_miss_char, activity_type_code, p_activity_type_code),
635: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
636: arc_marketing_medium_from = DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, arc_marketing_medium_from, p_arc_marketing_medium_from),
637: marketing_medium_id = DECODE( p_marketing_medium_id, FND_API.g_miss_num, marketing_medium_id, p_marketing_medium_id),
630: -- end_date_time = DECODE( p_end_date_time, FND_API.g_miss_date, end_date_time, p_end_date_time),
631: start_date_time = l_start_date,
632: end_date_time = l_end_date,
633: timezone_id = DECODE( p_timezone_id, FND_API.g_miss_num, timezone_id, p_timezone_id),
634: activity_type_code = DECODE( p_activity_type_code, FND_API.g_miss_char, activity_type_code, p_activity_type_code),
635: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
636: arc_marketing_medium_from = DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, arc_marketing_medium_from, p_arc_marketing_medium_from),
637: marketing_medium_id = DECODE( p_marketing_medium_id, FND_API.g_miss_num, marketing_medium_id, p_marketing_medium_id),
638: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
631: start_date_time = l_start_date,
632: end_date_time = l_end_date,
633: timezone_id = DECODE( p_timezone_id, FND_API.g_miss_num, timezone_id, p_timezone_id),
634: activity_type_code = DECODE( p_activity_type_code, FND_API.g_miss_char, activity_type_code, p_activity_type_code),
635: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
636: arc_marketing_medium_from = DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, arc_marketing_medium_from, p_arc_marketing_medium_from),
637: marketing_medium_id = DECODE( p_marketing_medium_id, FND_API.g_miss_num, marketing_medium_id, p_marketing_medium_id),
638: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
639: triggerable_flag = DECODE( p_triggerable_flag, FND_API.g_miss_char, triggerable_flag, p_triggerable_flag),
632: end_date_time = l_end_date,
633: timezone_id = DECODE( p_timezone_id, FND_API.g_miss_num, timezone_id, p_timezone_id),
634: activity_type_code = DECODE( p_activity_type_code, FND_API.g_miss_char, activity_type_code, p_activity_type_code),
635: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
636: arc_marketing_medium_from = DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, arc_marketing_medium_from, p_arc_marketing_medium_from),
637: marketing_medium_id = DECODE( p_marketing_medium_id, FND_API.g_miss_num, marketing_medium_id, p_marketing_medium_id),
638: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
639: triggerable_flag = DECODE( p_triggerable_flag, FND_API.g_miss_char, triggerable_flag, p_triggerable_flag),
640: trigger_id = DECODE( p_trigger_id, FND_API.g_miss_num, trigger_id, p_trigger_id),
633: timezone_id = DECODE( p_timezone_id, FND_API.g_miss_num, timezone_id, p_timezone_id),
634: activity_type_code = DECODE( p_activity_type_code, FND_API.g_miss_char, activity_type_code, p_activity_type_code),
635: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
636: arc_marketing_medium_from = DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, arc_marketing_medium_from, p_arc_marketing_medium_from),
637: marketing_medium_id = DECODE( p_marketing_medium_id, FND_API.g_miss_num, marketing_medium_id, p_marketing_medium_id),
638: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
639: triggerable_flag = DECODE( p_triggerable_flag, FND_API.g_miss_char, triggerable_flag, p_triggerable_flag),
640: trigger_id = DECODE( p_trigger_id, FND_API.g_miss_num, trigger_id, p_trigger_id),
641: notify_user_id = DECODE( p_notify_user_id, FND_API.g_miss_num, notify_user_id, p_notify_user_id),
634: activity_type_code = DECODE( p_activity_type_code, FND_API.g_miss_char, activity_type_code, p_activity_type_code),
635: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
636: arc_marketing_medium_from = DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, arc_marketing_medium_from, p_arc_marketing_medium_from),
637: marketing_medium_id = DECODE( p_marketing_medium_id, FND_API.g_miss_num, marketing_medium_id, p_marketing_medium_id),
638: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
639: triggerable_flag = DECODE( p_triggerable_flag, FND_API.g_miss_char, triggerable_flag, p_triggerable_flag),
640: trigger_id = DECODE( p_trigger_id, FND_API.g_miss_num, trigger_id, p_trigger_id),
641: notify_user_id = DECODE( p_notify_user_id, FND_API.g_miss_num, notify_user_id, p_notify_user_id),
642: approver_user_id = DECODE( p_approver_user_id, FND_API.g_miss_num, approver_user_id, p_approver_user_id),
635: activity_id = DECODE( p_activity_id, FND_API.g_miss_num, activity_id, p_activity_id),
636: arc_marketing_medium_from = DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, arc_marketing_medium_from, p_arc_marketing_medium_from),
637: marketing_medium_id = DECODE( p_marketing_medium_id, FND_API.g_miss_num, marketing_medium_id, p_marketing_medium_id),
638: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
639: triggerable_flag = DECODE( p_triggerable_flag, FND_API.g_miss_char, triggerable_flag, p_triggerable_flag),
640: trigger_id = DECODE( p_trigger_id, FND_API.g_miss_num, trigger_id, p_trigger_id),
641: notify_user_id = DECODE( p_notify_user_id, FND_API.g_miss_num, notify_user_id, p_notify_user_id),
642: approver_user_id = DECODE( p_approver_user_id, FND_API.g_miss_num, approver_user_id, p_approver_user_id),
643: owner_user_id = DECODE( p_owner_user_id, FND_API.g_miss_num, owner_user_id, p_owner_user_id),
636: arc_marketing_medium_from = DECODE( p_arc_marketing_medium_from, FND_API.g_miss_char, arc_marketing_medium_from, p_arc_marketing_medium_from),
637: marketing_medium_id = DECODE( p_marketing_medium_id, FND_API.g_miss_num, marketing_medium_id, p_marketing_medium_id),
638: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
639: triggerable_flag = DECODE( p_triggerable_flag, FND_API.g_miss_char, triggerable_flag, p_triggerable_flag),
640: trigger_id = DECODE( p_trigger_id, FND_API.g_miss_num, trigger_id, p_trigger_id),
641: notify_user_id = DECODE( p_notify_user_id, FND_API.g_miss_num, notify_user_id, p_notify_user_id),
642: approver_user_id = DECODE( p_approver_user_id, FND_API.g_miss_num, approver_user_id, p_approver_user_id),
643: owner_user_id = DECODE( p_owner_user_id, FND_API.g_miss_num, owner_user_id, p_owner_user_id),
644: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
637: marketing_medium_id = DECODE( p_marketing_medium_id, FND_API.g_miss_num, marketing_medium_id, p_marketing_medium_id),
638: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
639: triggerable_flag = DECODE( p_triggerable_flag, FND_API.g_miss_char, triggerable_flag, p_triggerable_flag),
640: trigger_id = DECODE( p_trigger_id, FND_API.g_miss_num, trigger_id, p_trigger_id),
641: notify_user_id = DECODE( p_notify_user_id, FND_API.g_miss_num, notify_user_id, p_notify_user_id),
642: approver_user_id = DECODE( p_approver_user_id, FND_API.g_miss_num, approver_user_id, p_approver_user_id),
643: owner_user_id = DECODE( p_owner_user_id, FND_API.g_miss_num, owner_user_id, p_owner_user_id),
644: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
645: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
638: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
639: triggerable_flag = DECODE( p_triggerable_flag, FND_API.g_miss_char, triggerable_flag, p_triggerable_flag),
640: trigger_id = DECODE( p_trigger_id, FND_API.g_miss_num, trigger_id, p_trigger_id),
641: notify_user_id = DECODE( p_notify_user_id, FND_API.g_miss_num, notify_user_id, p_notify_user_id),
642: approver_user_id = DECODE( p_approver_user_id, FND_API.g_miss_num, approver_user_id, p_approver_user_id),
643: owner_user_id = DECODE( p_owner_user_id, FND_API.g_miss_num, owner_user_id, p_owner_user_id),
644: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
645: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
646: reply_to_mail = DECODE( p_reply_to_mail, FND_API.g_miss_char, reply_to_mail, p_reply_to_mail),
639: triggerable_flag = DECODE( p_triggerable_flag, FND_API.g_miss_char, triggerable_flag, p_triggerable_flag),
640: trigger_id = DECODE( p_trigger_id, FND_API.g_miss_num, trigger_id, p_trigger_id),
641: notify_user_id = DECODE( p_notify_user_id, FND_API.g_miss_num, notify_user_id, p_notify_user_id),
642: approver_user_id = DECODE( p_approver_user_id, FND_API.g_miss_num, approver_user_id, p_approver_user_id),
643: owner_user_id = DECODE( p_owner_user_id, FND_API.g_miss_num, owner_user_id, p_owner_user_id),
644: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
645: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
646: reply_to_mail = DECODE( p_reply_to_mail, FND_API.g_miss_char, reply_to_mail, p_reply_to_mail),
647: mail_sender_name = DECODE( p_mail_sender_name, FND_API.g_miss_char, mail_sender_name, p_mail_sender_name),
640: trigger_id = DECODE( p_trigger_id, FND_API.g_miss_num, trigger_id, p_trigger_id),
641: notify_user_id = DECODE( p_notify_user_id, FND_API.g_miss_num, notify_user_id, p_notify_user_id),
642: approver_user_id = DECODE( p_approver_user_id, FND_API.g_miss_num, approver_user_id, p_approver_user_id),
643: owner_user_id = DECODE( p_owner_user_id, FND_API.g_miss_num, owner_user_id, p_owner_user_id),
644: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
645: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
646: reply_to_mail = DECODE( p_reply_to_mail, FND_API.g_miss_char, reply_to_mail, p_reply_to_mail),
647: mail_sender_name = DECODE( p_mail_sender_name, FND_API.g_miss_char, mail_sender_name, p_mail_sender_name),
648: mail_subject = DECODE( p_mail_subject, FND_API.g_miss_char, mail_subject, p_mail_subject),
641: notify_user_id = DECODE( p_notify_user_id, FND_API.g_miss_num, notify_user_id, p_notify_user_id),
642: approver_user_id = DECODE( p_approver_user_id, FND_API.g_miss_num, approver_user_id, p_approver_user_id),
643: owner_user_id = DECODE( p_owner_user_id, FND_API.g_miss_num, owner_user_id, p_owner_user_id),
644: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
645: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
646: reply_to_mail = DECODE( p_reply_to_mail, FND_API.g_miss_char, reply_to_mail, p_reply_to_mail),
647: mail_sender_name = DECODE( p_mail_sender_name, FND_API.g_miss_char, mail_sender_name, p_mail_sender_name),
648: mail_subject = DECODE( p_mail_subject, FND_API.g_miss_char, mail_subject, p_mail_subject),
649: from_fax_no = DECODE( p_from_fax_no, FND_API.g_miss_char, from_fax_no, p_from_fax_no),
642: approver_user_id = DECODE( p_approver_user_id, FND_API.g_miss_num, approver_user_id, p_approver_user_id),
643: owner_user_id = DECODE( p_owner_user_id, FND_API.g_miss_num, owner_user_id, p_owner_user_id),
644: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
645: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
646: reply_to_mail = DECODE( p_reply_to_mail, FND_API.g_miss_char, reply_to_mail, p_reply_to_mail),
647: mail_sender_name = DECODE( p_mail_sender_name, FND_API.g_miss_char, mail_sender_name, p_mail_sender_name),
648: mail_subject = DECODE( p_mail_subject, FND_API.g_miss_char, mail_subject, p_mail_subject),
649: from_fax_no = DECODE( p_from_fax_no, FND_API.g_miss_char, from_fax_no, p_from_fax_no),
650: accounts_closed_flag = DECODE( p_accounts_closed_flag, FND_API.g_miss_char, accounts_closed_flag, p_accounts_closed_flag),
643: owner_user_id = DECODE( p_owner_user_id, FND_API.g_miss_num, owner_user_id, p_owner_user_id),
644: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
645: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
646: reply_to_mail = DECODE( p_reply_to_mail, FND_API.g_miss_char, reply_to_mail, p_reply_to_mail),
647: mail_sender_name = DECODE( p_mail_sender_name, FND_API.g_miss_char, mail_sender_name, p_mail_sender_name),
648: mail_subject = DECODE( p_mail_subject, FND_API.g_miss_char, mail_subject, p_mail_subject),
649: from_fax_no = DECODE( p_from_fax_no, FND_API.g_miss_char, from_fax_no, p_from_fax_no),
650: accounts_closed_flag = DECODE( p_accounts_closed_flag, FND_API.g_miss_char, accounts_closed_flag, p_accounts_closed_flag),
651: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
644: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
645: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
646: reply_to_mail = DECODE( p_reply_to_mail, FND_API.g_miss_char, reply_to_mail, p_reply_to_mail),
647: mail_sender_name = DECODE( p_mail_sender_name, FND_API.g_miss_char, mail_sender_name, p_mail_sender_name),
648: mail_subject = DECODE( p_mail_subject, FND_API.g_miss_char, mail_subject, p_mail_subject),
649: from_fax_no = DECODE( p_from_fax_no, FND_API.g_miss_char, from_fax_no, p_from_fax_no),
650: accounts_closed_flag = DECODE( p_accounts_closed_flag, FND_API.g_miss_char, accounts_closed_flag, p_accounts_closed_flag),
651: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
652: objective_code = DECODE( p_objective_code, FND_API.g_miss_char, objective_code, p_objective_code),
645: cover_letter_id = DECODE( p_cover_letter_id, FND_API.g_miss_num, cover_letter_id, p_cover_letter_id),
646: reply_to_mail = DECODE( p_reply_to_mail, FND_API.g_miss_char, reply_to_mail, p_reply_to_mail),
647: mail_sender_name = DECODE( p_mail_sender_name, FND_API.g_miss_char, mail_sender_name, p_mail_sender_name),
648: mail_subject = DECODE( p_mail_subject, FND_API.g_miss_char, mail_subject, p_mail_subject),
649: from_fax_no = DECODE( p_from_fax_no, FND_API.g_miss_char, from_fax_no, p_from_fax_no),
650: accounts_closed_flag = DECODE( p_accounts_closed_flag, FND_API.g_miss_char, accounts_closed_flag, p_accounts_closed_flag),
651: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
652: objective_code = DECODE( p_objective_code, FND_API.g_miss_char, objective_code, p_objective_code),
653: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
646: reply_to_mail = DECODE( p_reply_to_mail, FND_API.g_miss_char, reply_to_mail, p_reply_to_mail),
647: mail_sender_name = DECODE( p_mail_sender_name, FND_API.g_miss_char, mail_sender_name, p_mail_sender_name),
648: mail_subject = DECODE( p_mail_subject, FND_API.g_miss_char, mail_subject, p_mail_subject),
649: from_fax_no = DECODE( p_from_fax_no, FND_API.g_miss_char, from_fax_no, p_from_fax_no),
650: accounts_closed_flag = DECODE( p_accounts_closed_flag, FND_API.g_miss_char, accounts_closed_flag, p_accounts_closed_flag),
651: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
652: objective_code = DECODE( p_objective_code, FND_API.g_miss_char, objective_code, p_objective_code),
653: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
654: campaign_calendar = DECODE( p_campaign_calendar, FND_API.g_miss_char, campaign_calendar, p_campaign_calendar),
647: mail_sender_name = DECODE( p_mail_sender_name, FND_API.g_miss_char, mail_sender_name, p_mail_sender_name),
648: mail_subject = DECODE( p_mail_subject, FND_API.g_miss_char, mail_subject, p_mail_subject),
649: from_fax_no = DECODE( p_from_fax_no, FND_API.g_miss_char, from_fax_no, p_from_fax_no),
650: accounts_closed_flag = DECODE( p_accounts_closed_flag, FND_API.g_miss_char, accounts_closed_flag, p_accounts_closed_flag),
651: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
652: objective_code = DECODE( p_objective_code, FND_API.g_miss_char, objective_code, p_objective_code),
653: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
654: campaign_calendar = DECODE( p_campaign_calendar, FND_API.g_miss_char, campaign_calendar, p_campaign_calendar),
655: start_period_name = DECODE( p_start_period_name, FND_API.g_miss_char, start_period_name, p_start_period_name),
648: mail_subject = DECODE( p_mail_subject, FND_API.g_miss_char, mail_subject, p_mail_subject),
649: from_fax_no = DECODE( p_from_fax_no, FND_API.g_miss_char, from_fax_no, p_from_fax_no),
650: accounts_closed_flag = DECODE( p_accounts_closed_flag, FND_API.g_miss_char, accounts_closed_flag, p_accounts_closed_flag),
651: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
652: objective_code = DECODE( p_objective_code, FND_API.g_miss_char, objective_code, p_objective_code),
653: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
654: campaign_calendar = DECODE( p_campaign_calendar, FND_API.g_miss_char, campaign_calendar, p_campaign_calendar),
655: start_period_name = DECODE( p_start_period_name, FND_API.g_miss_char, start_period_name, p_start_period_name),
656: end_period_name = DECODE( p_end_period_name, FND_API.g_miss_char, end_period_name, p_end_period_name),
649: from_fax_no = DECODE( p_from_fax_no, FND_API.g_miss_char, from_fax_no, p_from_fax_no),
650: accounts_closed_flag = DECODE( p_accounts_closed_flag, FND_API.g_miss_char, accounts_closed_flag, p_accounts_closed_flag),
651: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
652: objective_code = DECODE( p_objective_code, FND_API.g_miss_char, objective_code, p_objective_code),
653: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
654: campaign_calendar = DECODE( p_campaign_calendar, FND_API.g_miss_char, campaign_calendar, p_campaign_calendar),
655: start_period_name = DECODE( p_start_period_name, FND_API.g_miss_char, start_period_name, p_start_period_name),
656: end_period_name = DECODE( p_end_period_name, FND_API.g_miss_char, end_period_name, p_end_period_name),
657: priority = DECODE( p_priority, FND_API.g_miss_char, priority, p_priority),
650: accounts_closed_flag = DECODE( p_accounts_closed_flag, FND_API.g_miss_char, accounts_closed_flag, p_accounts_closed_flag),
651: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
652: objective_code = DECODE( p_objective_code, FND_API.g_miss_char, objective_code, p_objective_code),
653: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
654: campaign_calendar = DECODE( p_campaign_calendar, FND_API.g_miss_char, campaign_calendar, p_campaign_calendar),
655: start_period_name = DECODE( p_start_period_name, FND_API.g_miss_char, start_period_name, p_start_period_name),
656: end_period_name = DECODE( p_end_period_name, FND_API.g_miss_char, end_period_name, p_end_period_name),
657: priority = DECODE( p_priority, FND_API.g_miss_char, priority, p_priority),
658: workflow_item_key = DECODE( p_workflow_item_key, FND_API.g_miss_char, workflow_item_key, p_workflow_item_key),
651: org_id = DECODE( p_org_id, FND_API.g_miss_num, org_id, p_org_id),
652: objective_code = DECODE( p_objective_code, FND_API.g_miss_char, objective_code, p_objective_code),
653: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
654: campaign_calendar = DECODE( p_campaign_calendar, FND_API.g_miss_char, campaign_calendar, p_campaign_calendar),
655: start_period_name = DECODE( p_start_period_name, FND_API.g_miss_char, start_period_name, p_start_period_name),
656: end_period_name = DECODE( p_end_period_name, FND_API.g_miss_char, end_period_name, p_end_period_name),
657: priority = DECODE( p_priority, FND_API.g_miss_char, priority, p_priority),
658: workflow_item_key = DECODE( p_workflow_item_key, FND_API.g_miss_char, workflow_item_key, p_workflow_item_key),
659: transaction_currency_code = DECODE(p_transaction_currency_code,FND_API.g_miss_char,transaction_currency_code,p_transaction_currency_code),
652: objective_code = DECODE( p_objective_code, FND_API.g_miss_char, objective_code, p_objective_code),
653: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
654: campaign_calendar = DECODE( p_campaign_calendar, FND_API.g_miss_char, campaign_calendar, p_campaign_calendar),
655: start_period_name = DECODE( p_start_period_name, FND_API.g_miss_char, start_period_name, p_start_period_name),
656: end_period_name = DECODE( p_end_period_name, FND_API.g_miss_char, end_period_name, p_end_period_name),
657: priority = DECODE( p_priority, FND_API.g_miss_char, priority, p_priority),
658: workflow_item_key = DECODE( p_workflow_item_key, FND_API.g_miss_char, workflow_item_key, p_workflow_item_key),
659: transaction_currency_code = DECODE(p_transaction_currency_code,FND_API.g_miss_char,transaction_currency_code,p_transaction_currency_code),
660: functional_currency_code = DECODE(p_functional_currency_code,FND_API.g_miss_char,functional_currency_code,p_functional_currency_code),
653: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
654: campaign_calendar = DECODE( p_campaign_calendar, FND_API.g_miss_char, campaign_calendar, p_campaign_calendar),
655: start_period_name = DECODE( p_start_period_name, FND_API.g_miss_char, start_period_name, p_start_period_name),
656: end_period_name = DECODE( p_end_period_name, FND_API.g_miss_char, end_period_name, p_end_period_name),
657: priority = DECODE( p_priority, FND_API.g_miss_char, priority, p_priority),
658: workflow_item_key = DECODE( p_workflow_item_key, FND_API.g_miss_char, workflow_item_key, p_workflow_item_key),
659: transaction_currency_code = DECODE(p_transaction_currency_code,FND_API.g_miss_char,transaction_currency_code,p_transaction_currency_code),
660: functional_currency_code = DECODE(p_functional_currency_code,FND_API.g_miss_char,functional_currency_code,p_functional_currency_code),
661: budget_amount_tc = DECODE( p_budget_amount_tc ,FND_API.g_miss_num,budget_amount_tc,p_budget_amount_tc),
654: campaign_calendar = DECODE( p_campaign_calendar, FND_API.g_miss_char, campaign_calendar, p_campaign_calendar),
655: start_period_name = DECODE( p_start_period_name, FND_API.g_miss_char, start_period_name, p_start_period_name),
656: end_period_name = DECODE( p_end_period_name, FND_API.g_miss_char, end_period_name, p_end_period_name),
657: priority = DECODE( p_priority, FND_API.g_miss_char, priority, p_priority),
658: workflow_item_key = DECODE( p_workflow_item_key, FND_API.g_miss_char, workflow_item_key, p_workflow_item_key),
659: transaction_currency_code = DECODE(p_transaction_currency_code,FND_API.g_miss_char,transaction_currency_code,p_transaction_currency_code),
660: functional_currency_code = DECODE(p_functional_currency_code,FND_API.g_miss_char,functional_currency_code,p_functional_currency_code),
661: budget_amount_tc = DECODE( p_budget_amount_tc ,FND_API.g_miss_num,budget_amount_tc,p_budget_amount_tc),
662: budget_amount_fc = DECODE( p_budget_amount_fc ,FND_API.g_miss_num,budget_amount_fc,p_budget_amount_fc),
655: start_period_name = DECODE( p_start_period_name, FND_API.g_miss_char, start_period_name, p_start_period_name),
656: end_period_name = DECODE( p_end_period_name, FND_API.g_miss_char, end_period_name, p_end_period_name),
657: priority = DECODE( p_priority, FND_API.g_miss_char, priority, p_priority),
658: workflow_item_key = DECODE( p_workflow_item_key, FND_API.g_miss_char, workflow_item_key, p_workflow_item_key),
659: transaction_currency_code = DECODE(p_transaction_currency_code,FND_API.g_miss_char,transaction_currency_code,p_transaction_currency_code),
660: functional_currency_code = DECODE(p_functional_currency_code,FND_API.g_miss_char,functional_currency_code,p_functional_currency_code),
661: budget_amount_tc = DECODE( p_budget_amount_tc ,FND_API.g_miss_num,budget_amount_tc,p_budget_amount_tc),
662: budget_amount_fc = DECODE( p_budget_amount_fc ,FND_API.g_miss_num,budget_amount_fc,p_budget_amount_fc),
663: language_code = DECODE( p_language_code ,FND_API.g_miss_char,language_code,p_language_code),
656: end_period_name = DECODE( p_end_period_name, FND_API.g_miss_char, end_period_name, p_end_period_name),
657: priority = DECODE( p_priority, FND_API.g_miss_char, priority, p_priority),
658: workflow_item_key = DECODE( p_workflow_item_key, FND_API.g_miss_char, workflow_item_key, p_workflow_item_key),
659: transaction_currency_code = DECODE(p_transaction_currency_code,FND_API.g_miss_char,transaction_currency_code,p_transaction_currency_code),
660: functional_currency_code = DECODE(p_functional_currency_code,FND_API.g_miss_char,functional_currency_code,p_functional_currency_code),
661: budget_amount_tc = DECODE( p_budget_amount_tc ,FND_API.g_miss_num,budget_amount_tc,p_budget_amount_tc),
662: budget_amount_fc = DECODE( p_budget_amount_fc ,FND_API.g_miss_num,budget_amount_fc,p_budget_amount_fc),
663: language_code = DECODE( p_language_code ,FND_API.g_miss_char,language_code,p_language_code),
664: task_id = DECODE( p_task_id ,FND_API.g_miss_num,task_id,p_task_id),
657: priority = DECODE( p_priority, FND_API.g_miss_char, priority, p_priority),
658: workflow_item_key = DECODE( p_workflow_item_key, FND_API.g_miss_char, workflow_item_key, p_workflow_item_key),
659: transaction_currency_code = DECODE(p_transaction_currency_code,FND_API.g_miss_char,transaction_currency_code,p_transaction_currency_code),
660: functional_currency_code = DECODE(p_functional_currency_code,FND_API.g_miss_char,functional_currency_code,p_functional_currency_code),
661: budget_amount_tc = DECODE( p_budget_amount_tc ,FND_API.g_miss_num,budget_amount_tc,p_budget_amount_tc),
662: budget_amount_fc = DECODE( p_budget_amount_fc ,FND_API.g_miss_num,budget_amount_fc,p_budget_amount_fc),
663: language_code = DECODE( p_language_code ,FND_API.g_miss_char,language_code,p_language_code),
664: task_id = DECODE( p_task_id ,FND_API.g_miss_num,task_id,p_task_id),
665: related_event_from = DECODE( p_related_event_from ,FND_API.g_miss_char,related_event_from,p_related_event_from),
658: workflow_item_key = DECODE( p_workflow_item_key, FND_API.g_miss_char, workflow_item_key, p_workflow_item_key),
659: transaction_currency_code = DECODE(p_transaction_currency_code,FND_API.g_miss_char,transaction_currency_code,p_transaction_currency_code),
660: functional_currency_code = DECODE(p_functional_currency_code,FND_API.g_miss_char,functional_currency_code,p_functional_currency_code),
661: budget_amount_tc = DECODE( p_budget_amount_tc ,FND_API.g_miss_num,budget_amount_tc,p_budget_amount_tc),
662: budget_amount_fc = DECODE( p_budget_amount_fc ,FND_API.g_miss_num,budget_amount_fc,p_budget_amount_fc),
663: language_code = DECODE( p_language_code ,FND_API.g_miss_char,language_code,p_language_code),
664: task_id = DECODE( p_task_id ,FND_API.g_miss_num,task_id,p_task_id),
665: related_event_from = DECODE( p_related_event_from ,FND_API.g_miss_char,related_event_from,p_related_event_from),
666: related_event_id = DECODE( p_related_event_id ,FND_API.g_miss_num,related_event_id,p_related_event_id),
659: transaction_currency_code = DECODE(p_transaction_currency_code,FND_API.g_miss_char,transaction_currency_code,p_transaction_currency_code),
660: functional_currency_code = DECODE(p_functional_currency_code,FND_API.g_miss_char,functional_currency_code,p_functional_currency_code),
661: budget_amount_tc = DECODE( p_budget_amount_tc ,FND_API.g_miss_num,budget_amount_tc,p_budget_amount_tc),
662: budget_amount_fc = DECODE( p_budget_amount_fc ,FND_API.g_miss_num,budget_amount_fc,p_budget_amount_fc),
663: language_code = DECODE( p_language_code ,FND_API.g_miss_char,language_code,p_language_code),
664: task_id = DECODE( p_task_id ,FND_API.g_miss_num,task_id,p_task_id),
665: related_event_from = DECODE( p_related_event_from ,FND_API.g_miss_char,related_event_from,p_related_event_from),
666: related_event_id = DECODE( p_related_event_id ,FND_API.g_miss_num,related_event_id,p_related_event_id),
667: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
660: functional_currency_code = DECODE(p_functional_currency_code,FND_API.g_miss_char,functional_currency_code,p_functional_currency_code),
661: budget_amount_tc = DECODE( p_budget_amount_tc ,FND_API.g_miss_num,budget_amount_tc,p_budget_amount_tc),
662: budget_amount_fc = DECODE( p_budget_amount_fc ,FND_API.g_miss_num,budget_amount_fc,p_budget_amount_fc),
663: language_code = DECODE( p_language_code ,FND_API.g_miss_char,language_code,p_language_code),
664: task_id = DECODE( p_task_id ,FND_API.g_miss_num,task_id,p_task_id),
665: related_event_from = DECODE( p_related_event_from ,FND_API.g_miss_char,related_event_from,p_related_event_from),
666: related_event_id = DECODE( p_related_event_id ,FND_API.g_miss_num,related_event_id,p_related_event_id),
667: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
668: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
661: budget_amount_tc = DECODE( p_budget_amount_tc ,FND_API.g_miss_num,budget_amount_tc,p_budget_amount_tc),
662: budget_amount_fc = DECODE( p_budget_amount_fc ,FND_API.g_miss_num,budget_amount_fc,p_budget_amount_fc),
663: language_code = DECODE( p_language_code ,FND_API.g_miss_char,language_code,p_language_code),
664: task_id = DECODE( p_task_id ,FND_API.g_miss_num,task_id,p_task_id),
665: related_event_from = DECODE( p_related_event_from ,FND_API.g_miss_char,related_event_from,p_related_event_from),
666: related_event_id = DECODE( p_related_event_id ,FND_API.g_miss_num,related_event_id,p_related_event_id),
667: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
668: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
669: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
662: budget_amount_fc = DECODE( p_budget_amount_fc ,FND_API.g_miss_num,budget_amount_fc,p_budget_amount_fc),
663: language_code = DECODE( p_language_code ,FND_API.g_miss_char,language_code,p_language_code),
664: task_id = DECODE( p_task_id ,FND_API.g_miss_num,task_id,p_task_id),
665: related_event_from = DECODE( p_related_event_from ,FND_API.g_miss_char,related_event_from,p_related_event_from),
666: related_event_id = DECODE( p_related_event_id ,FND_API.g_miss_num,related_event_id,p_related_event_id),
667: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
668: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
669: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
670: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
663: language_code = DECODE( p_language_code ,FND_API.g_miss_char,language_code,p_language_code),
664: task_id = DECODE( p_task_id ,FND_API.g_miss_num,task_id,p_task_id),
665: related_event_from = DECODE( p_related_event_from ,FND_API.g_miss_char,related_event_from,p_related_event_from),
666: related_event_id = DECODE( p_related_event_id ,FND_API.g_miss_num,related_event_id,p_related_event_id),
667: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
668: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
669: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
670: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
671: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
664: task_id = DECODE( p_task_id ,FND_API.g_miss_num,task_id,p_task_id),
665: related_event_from = DECODE( p_related_event_from ,FND_API.g_miss_char,related_event_from,p_related_event_from),
666: related_event_id = DECODE( p_related_event_id ,FND_API.g_miss_num,related_event_id,p_related_event_id),
667: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
668: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
669: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
670: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
671: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
672: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
665: related_event_from = DECODE( p_related_event_from ,FND_API.g_miss_char,related_event_from,p_related_event_from),
666: related_event_id = DECODE( p_related_event_id ,FND_API.g_miss_num,related_event_id,p_related_event_id),
667: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
668: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
669: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
670: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
671: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
672: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
673: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
666: related_event_id = DECODE( p_related_event_id ,FND_API.g_miss_num,related_event_id,p_related_event_id),
667: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
668: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
669: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
670: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
671: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
672: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
673: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
674: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
667: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
668: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
669: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
670: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
671: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
672: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
673: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
674: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
675: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
668: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
669: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
670: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
671: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
672: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
673: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
674: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
675: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
676: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
669: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
670: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
671: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
672: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
673: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
674: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
675: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
676: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
677: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
670: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
671: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
672: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
673: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
674: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
675: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
676: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
677: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
678: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
671: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
672: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
673: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
674: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
675: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
676: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
677: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
678: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
679: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
672: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
673: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
674: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
675: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
676: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
677: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
678: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
679: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
680: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
673: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
674: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
675: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
676: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
677: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
678: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
679: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
680: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
681: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
674: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
675: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
676: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
677: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
678: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
679: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
680: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
681: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
682: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
675: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
676: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
677: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
678: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
679: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
680: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
681: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
682: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
683: activity_attribute_category = DECODE( p_activity_attribute_category, FND_API.g_miss_char, activity_attribute_category, p_activity_attribute_category),
676: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
677: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
678: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
679: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
680: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
681: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
682: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
683: activity_attribute_category = DECODE( p_activity_attribute_category, FND_API.g_miss_char, activity_attribute_category, p_activity_attribute_category),
684: activity_attribute1 = DECODE( p_activity_attribute1, FND_API.g_miss_char, activity_attribute1, p_activity_attribute1),
677: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
678: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
679: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
680: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
681: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
682: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
683: activity_attribute_category = DECODE( p_activity_attribute_category, FND_API.g_miss_char, activity_attribute_category, p_activity_attribute_category),
684: activity_attribute1 = DECODE( p_activity_attribute1, FND_API.g_miss_char, activity_attribute1, p_activity_attribute1),
685: activity_attribute2 = DECODE( p_activity_attribute2, FND_API.g_miss_char, activity_attribute2, p_activity_attribute2),
678: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
679: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
680: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
681: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
682: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
683: activity_attribute_category = DECODE( p_activity_attribute_category, FND_API.g_miss_char, activity_attribute_category, p_activity_attribute_category),
684: activity_attribute1 = DECODE( p_activity_attribute1, FND_API.g_miss_char, activity_attribute1, p_activity_attribute1),
685: activity_attribute2 = DECODE( p_activity_attribute2, FND_API.g_miss_char, activity_attribute2, p_activity_attribute2),
686: activity_attribute3 = DECODE( p_activity_attribute3, FND_API.g_miss_char, activity_attribute3, p_activity_attribute3),
679: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
680: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
681: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
682: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
683: activity_attribute_category = DECODE( p_activity_attribute_category, FND_API.g_miss_char, activity_attribute_category, p_activity_attribute_category),
684: activity_attribute1 = DECODE( p_activity_attribute1, FND_API.g_miss_char, activity_attribute1, p_activity_attribute1),
685: activity_attribute2 = DECODE( p_activity_attribute2, FND_API.g_miss_char, activity_attribute2, p_activity_attribute2),
686: activity_attribute3 = DECODE( p_activity_attribute3, FND_API.g_miss_char, activity_attribute3, p_activity_attribute3),
687: activity_attribute4 = DECODE( p_activity_attribute4, FND_API.g_miss_char, activity_attribute4, p_activity_attribute4),
680: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
681: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
682: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
683: activity_attribute_category = DECODE( p_activity_attribute_category, FND_API.g_miss_char, activity_attribute_category, p_activity_attribute_category),
684: activity_attribute1 = DECODE( p_activity_attribute1, FND_API.g_miss_char, activity_attribute1, p_activity_attribute1),
685: activity_attribute2 = DECODE( p_activity_attribute2, FND_API.g_miss_char, activity_attribute2, p_activity_attribute2),
686: activity_attribute3 = DECODE( p_activity_attribute3, FND_API.g_miss_char, activity_attribute3, p_activity_attribute3),
687: activity_attribute4 = DECODE( p_activity_attribute4, FND_API.g_miss_char, activity_attribute4, p_activity_attribute4),
688: activity_attribute5 = DECODE( p_activity_attribute5, FND_API.g_miss_char, activity_attribute5, p_activity_attribute5),
681: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
682: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
683: activity_attribute_category = DECODE( p_activity_attribute_category, FND_API.g_miss_char, activity_attribute_category, p_activity_attribute_category),
684: activity_attribute1 = DECODE( p_activity_attribute1, FND_API.g_miss_char, activity_attribute1, p_activity_attribute1),
685: activity_attribute2 = DECODE( p_activity_attribute2, FND_API.g_miss_char, activity_attribute2, p_activity_attribute2),
686: activity_attribute3 = DECODE( p_activity_attribute3, FND_API.g_miss_char, activity_attribute3, p_activity_attribute3),
687: activity_attribute4 = DECODE( p_activity_attribute4, FND_API.g_miss_char, activity_attribute4, p_activity_attribute4),
688: activity_attribute5 = DECODE( p_activity_attribute5, FND_API.g_miss_char, activity_attribute5, p_activity_attribute5),
689: activity_attribute6 = DECODE( p_activity_attribute6, FND_API.g_miss_char, activity_attribute6, p_activity_attribute6),
682: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
683: activity_attribute_category = DECODE( p_activity_attribute_category, FND_API.g_miss_char, activity_attribute_category, p_activity_attribute_category),
684: activity_attribute1 = DECODE( p_activity_attribute1, FND_API.g_miss_char, activity_attribute1, p_activity_attribute1),
685: activity_attribute2 = DECODE( p_activity_attribute2, FND_API.g_miss_char, activity_attribute2, p_activity_attribute2),
686: activity_attribute3 = DECODE( p_activity_attribute3, FND_API.g_miss_char, activity_attribute3, p_activity_attribute3),
687: activity_attribute4 = DECODE( p_activity_attribute4, FND_API.g_miss_char, activity_attribute4, p_activity_attribute4),
688: activity_attribute5 = DECODE( p_activity_attribute5, FND_API.g_miss_char, activity_attribute5, p_activity_attribute5),
689: activity_attribute6 = DECODE( p_activity_attribute6, FND_API.g_miss_char, activity_attribute6, p_activity_attribute6),
690: activity_attribute7 = DECODE( p_activity_attribute7, FND_API.g_miss_char, activity_attribute7, p_activity_attribute7),
683: activity_attribute_category = DECODE( p_activity_attribute_category, FND_API.g_miss_char, activity_attribute_category, p_activity_attribute_category),
684: activity_attribute1 = DECODE( p_activity_attribute1, FND_API.g_miss_char, activity_attribute1, p_activity_attribute1),
685: activity_attribute2 = DECODE( p_activity_attribute2, FND_API.g_miss_char, activity_attribute2, p_activity_attribute2),
686: activity_attribute3 = DECODE( p_activity_attribute3, FND_API.g_miss_char, activity_attribute3, p_activity_attribute3),
687: activity_attribute4 = DECODE( p_activity_attribute4, FND_API.g_miss_char, activity_attribute4, p_activity_attribute4),
688: activity_attribute5 = DECODE( p_activity_attribute5, FND_API.g_miss_char, activity_attribute5, p_activity_attribute5),
689: activity_attribute6 = DECODE( p_activity_attribute6, FND_API.g_miss_char, activity_attribute6, p_activity_attribute6),
690: activity_attribute7 = DECODE( p_activity_attribute7, FND_API.g_miss_char, activity_attribute7, p_activity_attribute7),
691: activity_attribute8 = DECODE( p_activity_attribute8, FND_API.g_miss_char, activity_attribute8, p_activity_attribute8),
684: activity_attribute1 = DECODE( p_activity_attribute1, FND_API.g_miss_char, activity_attribute1, p_activity_attribute1),
685: activity_attribute2 = DECODE( p_activity_attribute2, FND_API.g_miss_char, activity_attribute2, p_activity_attribute2),
686: activity_attribute3 = DECODE( p_activity_attribute3, FND_API.g_miss_char, activity_attribute3, p_activity_attribute3),
687: activity_attribute4 = DECODE( p_activity_attribute4, FND_API.g_miss_char, activity_attribute4, p_activity_attribute4),
688: activity_attribute5 = DECODE( p_activity_attribute5, FND_API.g_miss_char, activity_attribute5, p_activity_attribute5),
689: activity_attribute6 = DECODE( p_activity_attribute6, FND_API.g_miss_char, activity_attribute6, p_activity_attribute6),
690: activity_attribute7 = DECODE( p_activity_attribute7, FND_API.g_miss_char, activity_attribute7, p_activity_attribute7),
691: activity_attribute8 = DECODE( p_activity_attribute8, FND_API.g_miss_char, activity_attribute8, p_activity_attribute8),
692: activity_attribute9 = DECODE( p_activity_attribute9, FND_API.g_miss_char, activity_attribute9, p_activity_attribute9),
685: activity_attribute2 = DECODE( p_activity_attribute2, FND_API.g_miss_char, activity_attribute2, p_activity_attribute2),
686: activity_attribute3 = DECODE( p_activity_attribute3, FND_API.g_miss_char, activity_attribute3, p_activity_attribute3),
687: activity_attribute4 = DECODE( p_activity_attribute4, FND_API.g_miss_char, activity_attribute4, p_activity_attribute4),
688: activity_attribute5 = DECODE( p_activity_attribute5, FND_API.g_miss_char, activity_attribute5, p_activity_attribute5),
689: activity_attribute6 = DECODE( p_activity_attribute6, FND_API.g_miss_char, activity_attribute6, p_activity_attribute6),
690: activity_attribute7 = DECODE( p_activity_attribute7, FND_API.g_miss_char, activity_attribute7, p_activity_attribute7),
691: activity_attribute8 = DECODE( p_activity_attribute8, FND_API.g_miss_char, activity_attribute8, p_activity_attribute8),
692: activity_attribute9 = DECODE( p_activity_attribute9, FND_API.g_miss_char, activity_attribute9, p_activity_attribute9),
693: activity_attribute10 = DECODE( p_activity_attribute10, FND_API.g_miss_char, activity_attribute10, p_activity_attribute10),
686: activity_attribute3 = DECODE( p_activity_attribute3, FND_API.g_miss_char, activity_attribute3, p_activity_attribute3),
687: activity_attribute4 = DECODE( p_activity_attribute4, FND_API.g_miss_char, activity_attribute4, p_activity_attribute4),
688: activity_attribute5 = DECODE( p_activity_attribute5, FND_API.g_miss_char, activity_attribute5, p_activity_attribute5),
689: activity_attribute6 = DECODE( p_activity_attribute6, FND_API.g_miss_char, activity_attribute6, p_activity_attribute6),
690: activity_attribute7 = DECODE( p_activity_attribute7, FND_API.g_miss_char, activity_attribute7, p_activity_attribute7),
691: activity_attribute8 = DECODE( p_activity_attribute8, FND_API.g_miss_char, activity_attribute8, p_activity_attribute8),
692: activity_attribute9 = DECODE( p_activity_attribute9, FND_API.g_miss_char, activity_attribute9, p_activity_attribute9),
693: activity_attribute10 = DECODE( p_activity_attribute10, FND_API.g_miss_char, activity_attribute10, p_activity_attribute10),
694: activity_attribute11 = DECODE( p_activity_attribute11, FND_API.g_miss_char, activity_attribute11, p_activity_attribute11),
687: activity_attribute4 = DECODE( p_activity_attribute4, FND_API.g_miss_char, activity_attribute4, p_activity_attribute4),
688: activity_attribute5 = DECODE( p_activity_attribute5, FND_API.g_miss_char, activity_attribute5, p_activity_attribute5),
689: activity_attribute6 = DECODE( p_activity_attribute6, FND_API.g_miss_char, activity_attribute6, p_activity_attribute6),
690: activity_attribute7 = DECODE( p_activity_attribute7, FND_API.g_miss_char, activity_attribute7, p_activity_attribute7),
691: activity_attribute8 = DECODE( p_activity_attribute8, FND_API.g_miss_char, activity_attribute8, p_activity_attribute8),
692: activity_attribute9 = DECODE( p_activity_attribute9, FND_API.g_miss_char, activity_attribute9, p_activity_attribute9),
693: activity_attribute10 = DECODE( p_activity_attribute10, FND_API.g_miss_char, activity_attribute10, p_activity_attribute10),
694: activity_attribute11 = DECODE( p_activity_attribute11, FND_API.g_miss_char, activity_attribute11, p_activity_attribute11),
695: activity_attribute12 = DECODE( p_activity_attribute12, FND_API.g_miss_char, activity_attribute12, p_activity_attribute12),
688: activity_attribute5 = DECODE( p_activity_attribute5, FND_API.g_miss_char, activity_attribute5, p_activity_attribute5),
689: activity_attribute6 = DECODE( p_activity_attribute6, FND_API.g_miss_char, activity_attribute6, p_activity_attribute6),
690: activity_attribute7 = DECODE( p_activity_attribute7, FND_API.g_miss_char, activity_attribute7, p_activity_attribute7),
691: activity_attribute8 = DECODE( p_activity_attribute8, FND_API.g_miss_char, activity_attribute8, p_activity_attribute8),
692: activity_attribute9 = DECODE( p_activity_attribute9, FND_API.g_miss_char, activity_attribute9, p_activity_attribute9),
693: activity_attribute10 = DECODE( p_activity_attribute10, FND_API.g_miss_char, activity_attribute10, p_activity_attribute10),
694: activity_attribute11 = DECODE( p_activity_attribute11, FND_API.g_miss_char, activity_attribute11, p_activity_attribute11),
695: activity_attribute12 = DECODE( p_activity_attribute12, FND_API.g_miss_char, activity_attribute12, p_activity_attribute12),
696: activity_attribute13 = DECODE( p_activity_attribute13, FND_API.g_miss_char, activity_attribute13, p_activity_attribute13),
689: activity_attribute6 = DECODE( p_activity_attribute6, FND_API.g_miss_char, activity_attribute6, p_activity_attribute6),
690: activity_attribute7 = DECODE( p_activity_attribute7, FND_API.g_miss_char, activity_attribute7, p_activity_attribute7),
691: activity_attribute8 = DECODE( p_activity_attribute8, FND_API.g_miss_char, activity_attribute8, p_activity_attribute8),
692: activity_attribute9 = DECODE( p_activity_attribute9, FND_API.g_miss_char, activity_attribute9, p_activity_attribute9),
693: activity_attribute10 = DECODE( p_activity_attribute10, FND_API.g_miss_char, activity_attribute10, p_activity_attribute10),
694: activity_attribute11 = DECODE( p_activity_attribute11, FND_API.g_miss_char, activity_attribute11, p_activity_attribute11),
695: activity_attribute12 = DECODE( p_activity_attribute12, FND_API.g_miss_char, activity_attribute12, p_activity_attribute12),
696: activity_attribute13 = DECODE( p_activity_attribute13, FND_API.g_miss_char, activity_attribute13, p_activity_attribute13),
697: activity_attribute14 = DECODE( p_activity_attribute14, FND_API.g_miss_char, activity_attribute14, p_activity_attribute14),
690: activity_attribute7 = DECODE( p_activity_attribute7, FND_API.g_miss_char, activity_attribute7, p_activity_attribute7),
691: activity_attribute8 = DECODE( p_activity_attribute8, FND_API.g_miss_char, activity_attribute8, p_activity_attribute8),
692: activity_attribute9 = DECODE( p_activity_attribute9, FND_API.g_miss_char, activity_attribute9, p_activity_attribute9),
693: activity_attribute10 = DECODE( p_activity_attribute10, FND_API.g_miss_char, activity_attribute10, p_activity_attribute10),
694: activity_attribute11 = DECODE( p_activity_attribute11, FND_API.g_miss_char, activity_attribute11, p_activity_attribute11),
695: activity_attribute12 = DECODE( p_activity_attribute12, FND_API.g_miss_char, activity_attribute12, p_activity_attribute12),
696: activity_attribute13 = DECODE( p_activity_attribute13, FND_API.g_miss_char, activity_attribute13, p_activity_attribute13),
697: activity_attribute14 = DECODE( p_activity_attribute14, FND_API.g_miss_char, activity_attribute14, p_activity_attribute14),
698: activity_attribute15 = DECODE( p_activity_attribute15, FND_API.g_miss_char, activity_attribute15, p_activity_attribute15),
691: activity_attribute8 = DECODE( p_activity_attribute8, FND_API.g_miss_char, activity_attribute8, p_activity_attribute8),
692: activity_attribute9 = DECODE( p_activity_attribute9, FND_API.g_miss_char, activity_attribute9, p_activity_attribute9),
693: activity_attribute10 = DECODE( p_activity_attribute10, FND_API.g_miss_char, activity_attribute10, p_activity_attribute10),
694: activity_attribute11 = DECODE( p_activity_attribute11, FND_API.g_miss_char, activity_attribute11, p_activity_attribute11),
695: activity_attribute12 = DECODE( p_activity_attribute12, FND_API.g_miss_char, activity_attribute12, p_activity_attribute12),
696: activity_attribute13 = DECODE( p_activity_attribute13, FND_API.g_miss_char, activity_attribute13, p_activity_attribute13),
697: activity_attribute14 = DECODE( p_activity_attribute14, FND_API.g_miss_char, activity_attribute14, p_activity_attribute14),
698: activity_attribute15 = DECODE( p_activity_attribute15, FND_API.g_miss_char, activity_attribute15, p_activity_attribute15),
699: -- removed by soagrawa on 24-sep-2001
692: activity_attribute9 = DECODE( p_activity_attribute9, FND_API.g_miss_char, activity_attribute9, p_activity_attribute9),
693: activity_attribute10 = DECODE( p_activity_attribute10, FND_API.g_miss_char, activity_attribute10, p_activity_attribute10),
694: activity_attribute11 = DECODE( p_activity_attribute11, FND_API.g_miss_char, activity_attribute11, p_activity_attribute11),
695: activity_attribute12 = DECODE( p_activity_attribute12, FND_API.g_miss_char, activity_attribute12, p_activity_attribute12),
696: activity_attribute13 = DECODE( p_activity_attribute13, FND_API.g_miss_char, activity_attribute13, p_activity_attribute13),
697: activity_attribute14 = DECODE( p_activity_attribute14, FND_API.g_miss_char, activity_attribute14, p_activity_attribute14),
698: activity_attribute15 = DECODE( p_activity_attribute15, FND_API.g_miss_char, activity_attribute15, p_activity_attribute15),
699: -- removed by soagrawa on 24-sep-2001
700: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
693: activity_attribute10 = DECODE( p_activity_attribute10, FND_API.g_miss_char, activity_attribute10, p_activity_attribute10),
694: activity_attribute11 = DECODE( p_activity_attribute11, FND_API.g_miss_char, activity_attribute11, p_activity_attribute11),
695: activity_attribute12 = DECODE( p_activity_attribute12, FND_API.g_miss_char, activity_attribute12, p_activity_attribute12),
696: activity_attribute13 = DECODE( p_activity_attribute13, FND_API.g_miss_char, activity_attribute13, p_activity_attribute13),
697: activity_attribute14 = DECODE( p_activity_attribute14, FND_API.g_miss_char, activity_attribute14, p_activity_attribute14),
698: activity_attribute15 = DECODE( p_activity_attribute15, FND_API.g_miss_char, activity_attribute15, p_activity_attribute15),
699: -- removed by soagrawa on 24-sep-2001
700: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
701: query_id = DECODE( p_query_id, FND_API.g_miss_num, query_id, p_query_id),
694: activity_attribute11 = DECODE( p_activity_attribute11, FND_API.g_miss_char, activity_attribute11, p_activity_attribute11),
695: activity_attribute12 = DECODE( p_activity_attribute12, FND_API.g_miss_char, activity_attribute12, p_activity_attribute12),
696: activity_attribute13 = DECODE( p_activity_attribute13, FND_API.g_miss_char, activity_attribute13, p_activity_attribute13),
697: activity_attribute14 = DECODE( p_activity_attribute14, FND_API.g_miss_char, activity_attribute14, p_activity_attribute14),
698: activity_attribute15 = DECODE( p_activity_attribute15, FND_API.g_miss_char, activity_attribute15, p_activity_attribute15),
699: -- removed by soagrawa on 24-sep-2001
700: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
701: query_id = DECODE( p_query_id, FND_API.g_miss_num, query_id, p_query_id),
702: include_content_flag = DECODE( p_include_content_flag, FND_API.g_miss_char, include_content_flag, p_include_content_flag),
696: activity_attribute13 = DECODE( p_activity_attribute13, FND_API.g_miss_char, activity_attribute13, p_activity_attribute13),
697: activity_attribute14 = DECODE( p_activity_attribute14, FND_API.g_miss_char, activity_attribute14, p_activity_attribute14),
698: activity_attribute15 = DECODE( p_activity_attribute15, FND_API.g_miss_char, activity_attribute15, p_activity_attribute15),
699: -- removed by soagrawa on 24-sep-2001
700: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
701: query_id = DECODE( p_query_id, FND_API.g_miss_num, query_id, p_query_id),
702: include_content_flag = DECODE( p_include_content_flag, FND_API.g_miss_char, include_content_flag, p_include_content_flag),
703: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
704: test_email_address = DECODE( p_test_email_address, FND_API.g_miss_char, test_email_address, p_test_email_address),
697: activity_attribute14 = DECODE( p_activity_attribute14, FND_API.g_miss_char, activity_attribute14, p_activity_attribute14),
698: activity_attribute15 = DECODE( p_activity_attribute15, FND_API.g_miss_char, activity_attribute15, p_activity_attribute15),
699: -- removed by soagrawa on 24-sep-2001
700: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
701: query_id = DECODE( p_query_id, FND_API.g_miss_num, query_id, p_query_id),
702: include_content_flag = DECODE( p_include_content_flag, FND_API.g_miss_char, include_content_flag, p_include_content_flag),
703: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
704: test_email_address = DECODE( p_test_email_address, FND_API.g_miss_char, test_email_address, p_test_email_address),
705: --added by anchaudh on 30-apr-2003
698: activity_attribute15 = DECODE( p_activity_attribute15, FND_API.g_miss_char, activity_attribute15, p_activity_attribute15),
699: -- removed by soagrawa on 24-sep-2001
700: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
701: query_id = DECODE( p_query_id, FND_API.g_miss_num, query_id, p_query_id),
702: include_content_flag = DECODE( p_include_content_flag, FND_API.g_miss_char, include_content_flag, p_include_content_flag),
703: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
704: test_email_address = DECODE( p_test_email_address, FND_API.g_miss_char, test_email_address, p_test_email_address),
705: --added by anchaudh on 30-apr-2003
706: trig_repeat_flag = DECODE( p_trig_repeat_flag, FND_API.g_miss_char,trig_repeat_flag ,p_trig_repeat_flag),
699: -- removed by soagrawa on 24-sep-2001
700: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
701: query_id = DECODE( p_query_id, FND_API.g_miss_num, query_id, p_query_id),
702: include_content_flag = DECODE( p_include_content_flag, FND_API.g_miss_char, include_content_flag, p_include_content_flag),
703: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
704: test_email_address = DECODE( p_test_email_address, FND_API.g_miss_char, test_email_address, p_test_email_address),
705: --added by anchaudh on 30-apr-2003
706: trig_repeat_flag = DECODE( p_trig_repeat_flag, FND_API.g_miss_char,trig_repeat_flag ,p_trig_repeat_flag),
707: tgrp_exclude_prev_flag = DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, tgrp_exclude_prev_flag, p_tgrp_exclude_prev_flag),
700: -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
701: query_id = DECODE( p_query_id, FND_API.g_miss_num, query_id, p_query_id),
702: include_content_flag = DECODE( p_include_content_flag, FND_API.g_miss_char, include_content_flag, p_include_content_flag),
703: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
704: test_email_address = DECODE( p_test_email_address, FND_API.g_miss_char, test_email_address, p_test_email_address),
705: --added by anchaudh on 30-apr-2003
706: trig_repeat_flag = DECODE( p_trig_repeat_flag, FND_API.g_miss_char,trig_repeat_flag ,p_trig_repeat_flag),
707: tgrp_exclude_prev_flag = DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, tgrp_exclude_prev_flag, p_tgrp_exclude_prev_flag),
708: --added by anchaudh on 06-may-2003
702: include_content_flag = DECODE( p_include_content_flag, FND_API.g_miss_char, include_content_flag, p_include_content_flag),
703: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
704: test_email_address = DECODE( p_test_email_address, FND_API.g_miss_char, test_email_address, p_test_email_address),
705: --added by anchaudh on 30-apr-2003
706: trig_repeat_flag = DECODE( p_trig_repeat_flag, FND_API.g_miss_char,trig_repeat_flag ,p_trig_repeat_flag),
707: tgrp_exclude_prev_flag = DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, tgrp_exclude_prev_flag, p_tgrp_exclude_prev_flag),
708: --added by anchaudh on 06-may-2003
709: orig_csch_id = DECODE( p_orig_csch_id, FND_API.g_miss_num, orig_csch_id, p_orig_csch_id),
710: cover_letter_version = DECODE( p_cover_letter_version, FND_API.g_miss_num, cover_letter_version, p_cover_letter_version),
703: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
704: test_email_address = DECODE( p_test_email_address, FND_API.g_miss_char, test_email_address, p_test_email_address),
705: --added by anchaudh on 30-apr-2003
706: trig_repeat_flag = DECODE( p_trig_repeat_flag, FND_API.g_miss_char,trig_repeat_flag ,p_trig_repeat_flag),
707: tgrp_exclude_prev_flag = DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, tgrp_exclude_prev_flag, p_tgrp_exclude_prev_flag),
708: --added by anchaudh on 06-may-2003
709: orig_csch_id = DECODE( p_orig_csch_id, FND_API.g_miss_num, orig_csch_id, p_orig_csch_id),
710: cover_letter_version = DECODE( p_cover_letter_version, FND_API.g_miss_num, cover_letter_version, p_cover_letter_version),
711: --added by dbiswas on 12-aug-2003
705: --added by anchaudh on 30-apr-2003
706: trig_repeat_flag = DECODE( p_trig_repeat_flag, FND_API.g_miss_char,trig_repeat_flag ,p_trig_repeat_flag),
707: tgrp_exclude_prev_flag = DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, tgrp_exclude_prev_flag, p_tgrp_exclude_prev_flag),
708: --added by anchaudh on 06-may-2003
709: orig_csch_id = DECODE( p_orig_csch_id, FND_API.g_miss_num, orig_csch_id, p_orig_csch_id),
710: cover_letter_version = DECODE( p_cover_letter_version, FND_API.g_miss_num, cover_letter_version, p_cover_letter_version),
711: --added by dbiswas on 12-aug-2003
712: usage = DECODE( p_usage, FND_API.g_miss_char,usage ,p_usage),
713: purpose = DECODE( p_purpose, FND_API.g_miss_char, purpose, p_purpose),
706: trig_repeat_flag = DECODE( p_trig_repeat_flag, FND_API.g_miss_char,trig_repeat_flag ,p_trig_repeat_flag),
707: tgrp_exclude_prev_flag = DECODE( p_tgrp_exclude_prev_flag, FND_API.g_miss_char, tgrp_exclude_prev_flag, p_tgrp_exclude_prev_flag),
708: --added by anchaudh on 06-may-2003
709: orig_csch_id = DECODE( p_orig_csch_id, FND_API.g_miss_num, orig_csch_id, p_orig_csch_id),
710: cover_letter_version = DECODE( p_cover_letter_version, FND_API.g_miss_num, cover_letter_version, p_cover_letter_version),
711: --added by dbiswas on 12-aug-2003
712: usage = DECODE( p_usage, FND_API.g_miss_char,usage ,p_usage),
713: purpose = DECODE( p_purpose, FND_API.g_miss_char, purpose, p_purpose),
714: last_activation_date = DECODE( p_last_activation_date, FND_API.g_miss_date, last_activation_date, p_last_activation_date),
708: --added by anchaudh on 06-may-2003
709: orig_csch_id = DECODE( p_orig_csch_id, FND_API.g_miss_num, orig_csch_id, p_orig_csch_id),
710: cover_letter_version = DECODE( p_cover_letter_version, FND_API.g_miss_num, cover_letter_version, p_cover_letter_version),
711: --added by dbiswas on 12-aug-2003
712: usage = DECODE( p_usage, FND_API.g_miss_char,usage ,p_usage),
713: purpose = DECODE( p_purpose, FND_API.g_miss_char, purpose, p_purpose),
714: last_activation_date = DECODE( p_last_activation_date, FND_API.g_miss_date, last_activation_date, p_last_activation_date),
715: sales_methodology_id = DECODE( p_sales_methodology_id, FND_API.g_miss_num, sales_methodology_id, p_sales_methodology_id),
716: printer_address = DECODE( p_printer_address, FND_API.g_miss_char, printer_address, p_printer_address),
709: orig_csch_id = DECODE( p_orig_csch_id, FND_API.g_miss_num, orig_csch_id, p_orig_csch_id),
710: cover_letter_version = DECODE( p_cover_letter_version, FND_API.g_miss_num, cover_letter_version, p_cover_letter_version),
711: --added by dbiswas on 12-aug-2003
712: usage = DECODE( p_usage, FND_API.g_miss_char,usage ,p_usage),
713: purpose = DECODE( p_purpose, FND_API.g_miss_char, purpose, p_purpose),
714: last_activation_date = DECODE( p_last_activation_date, FND_API.g_miss_date, last_activation_date, p_last_activation_date),
715: sales_methodology_id = DECODE( p_sales_methodology_id, FND_API.g_miss_num, sales_methodology_id, p_sales_methodology_id),
716: printer_address = DECODE( p_printer_address, FND_API.g_miss_char, printer_address, p_printer_address),
717: notify_on_activation_flag = DECODE( p_notify_on_activation_flag, FND_API.g_miss_char, notify_on_activation_flag, p_notify_on_activation_flag),
710: cover_letter_version = DECODE( p_cover_letter_version, FND_API.g_miss_num, cover_letter_version, p_cover_letter_version),
711: --added by dbiswas on 12-aug-2003
712: usage = DECODE( p_usage, FND_API.g_miss_char,usage ,p_usage),
713: purpose = DECODE( p_purpose, FND_API.g_miss_char, purpose, p_purpose),
714: last_activation_date = DECODE( p_last_activation_date, FND_API.g_miss_date, last_activation_date, p_last_activation_date),
715: sales_methodology_id = DECODE( p_sales_methodology_id, FND_API.g_miss_num, sales_methodology_id, p_sales_methodology_id),
716: printer_address = DECODE( p_printer_address, FND_API.g_miss_char, printer_address, p_printer_address),
717: notify_on_activation_flag = DECODE( p_notify_on_activation_flag, FND_API.g_miss_char, notify_on_activation_flag, p_notify_on_activation_flag),
718: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),
711: --added by dbiswas on 12-aug-2003
712: usage = DECODE( p_usage, FND_API.g_miss_char,usage ,p_usage),
713: purpose = DECODE( p_purpose, FND_API.g_miss_char, purpose, p_purpose),
714: last_activation_date = DECODE( p_last_activation_date, FND_API.g_miss_date, last_activation_date, p_last_activation_date),
715: sales_methodology_id = DECODE( p_sales_methodology_id, FND_API.g_miss_num, sales_methodology_id, p_sales_methodology_id),
716: printer_address = DECODE( p_printer_address, FND_API.g_miss_char, printer_address, p_printer_address),
717: notify_on_activation_flag = DECODE( p_notify_on_activation_flag, FND_API.g_miss_char, notify_on_activation_flag, p_notify_on_activation_flag),
718: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),
719: delivery_mode = DECODE( p_delivery_mode, FND_API.g_miss_char, delivery_mode, p_delivery_mode)
712: usage = DECODE( p_usage, FND_API.g_miss_char,usage ,p_usage),
713: purpose = DECODE( p_purpose, FND_API.g_miss_char, purpose, p_purpose),
714: last_activation_date = DECODE( p_last_activation_date, FND_API.g_miss_date, last_activation_date, p_last_activation_date),
715: sales_methodology_id = DECODE( p_sales_methodology_id, FND_API.g_miss_num, sales_methodology_id, p_sales_methodology_id),
716: printer_address = DECODE( p_printer_address, FND_API.g_miss_char, printer_address, p_printer_address),
717: notify_on_activation_flag = DECODE( p_notify_on_activation_flag, FND_API.g_miss_char, notify_on_activation_flag, p_notify_on_activation_flag),
718: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),
719: delivery_mode = DECODE( p_delivery_mode, FND_API.g_miss_char, delivery_mode, p_delivery_mode)
720: WHERE schedule_id = p_schedule_id
713: purpose = DECODE( p_purpose, FND_API.g_miss_char, purpose, p_purpose),
714: last_activation_date = DECODE( p_last_activation_date, FND_API.g_miss_date, last_activation_date, p_last_activation_date),
715: sales_methodology_id = DECODE( p_sales_methodology_id, FND_API.g_miss_num, sales_methodology_id, p_sales_methodology_id),
716: printer_address = DECODE( p_printer_address, FND_API.g_miss_char, printer_address, p_printer_address),
717: notify_on_activation_flag = DECODE( p_notify_on_activation_flag, FND_API.g_miss_char, notify_on_activation_flag, p_notify_on_activation_flag),
718: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),
719: delivery_mode = DECODE( p_delivery_mode, FND_API.g_miss_char, delivery_mode, p_delivery_mode)
720: WHERE schedule_id = p_schedule_id
721: AND object_version_number = p_object_version_number;
714: last_activation_date = DECODE( p_last_activation_date, FND_API.g_miss_date, last_activation_date, p_last_activation_date),
715: sales_methodology_id = DECODE( p_sales_methodology_id, FND_API.g_miss_num, sales_methodology_id, p_sales_methodology_id),
716: printer_address = DECODE( p_printer_address, FND_API.g_miss_char, printer_address, p_printer_address),
717: notify_on_activation_flag = DECODE( p_notify_on_activation_flag, FND_API.g_miss_char, notify_on_activation_flag, p_notify_on_activation_flag),
718: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),
719: delivery_mode = DECODE( p_delivery_mode, FND_API.g_miss_char, delivery_mode, p_delivery_mode)
720: WHERE schedule_id = p_schedule_id
721: AND object_version_number = p_object_version_number;
722: -- Debug Message Commented by ptendulk Bug 2767243
715: sales_methodology_id = DECODE( p_sales_methodology_id, FND_API.g_miss_num, sales_methodology_id, p_sales_methodology_id),
716: printer_address = DECODE( p_printer_address, FND_API.g_miss_char, printer_address, p_printer_address),
717: notify_on_activation_flag = DECODE( p_notify_on_activation_flag, FND_API.g_miss_char, notify_on_activation_flag, p_notify_on_activation_flag),
718: sender_display_name = DECODE( p_sender_display_name, FND_API.g_miss_char, sender_display_name, p_sender_display_name),
719: delivery_mode = DECODE( p_delivery_mode, FND_API.g_miss_char, delivery_mode, p_delivery_mode)
720: WHERE schedule_id = p_schedule_id
721: AND object_version_number = p_object_version_number;
722: -- Debug Message Commented by ptendulk Bug 2767243
723: -- AMS_UTILITY_PVT.debug_message('Start Update Table Handler');
721: AND object_version_number = p_object_version_number;
722: -- Debug Message Commented by ptendulk Bug 2767243
723: -- AMS_UTILITY_PVT.debug_message('Start Update Table Handler');
724: IF (SQL%NOTFOUND) THEN
725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
726: END IF;
727:
728: UPDATE ams_campaign_schedules_tl
729: SET schedule_name = DECODE(p_schedule_name,FND_API.g_miss_char,schedule_name,p_schedule_name),
725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
726: END IF;
727:
728: UPDATE ams_campaign_schedules_tl
729: SET schedule_name = DECODE(p_schedule_name,FND_API.g_miss_char,schedule_name,p_schedule_name),
730: description = DECODE(p_schedule_description,FND_API.g_miss_char,description,p_schedule_description),
731: greeting_text = DECODE(p_greeting_text,FND_API.g_miss_char,greeting_text,p_greeting_text),
732: footer_text = DECODE(p_footer_text,FND_API.g_miss_char,footer_text,p_footer_text),
733: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
726: END IF;
727:
728: UPDATE ams_campaign_schedules_tl
729: SET schedule_name = DECODE(p_schedule_name,FND_API.g_miss_char,schedule_name,p_schedule_name),
730: description = DECODE(p_schedule_description,FND_API.g_miss_char,description,p_schedule_description),
731: greeting_text = DECODE(p_greeting_text,FND_API.g_miss_char,greeting_text,p_greeting_text),
732: footer_text = DECODE(p_footer_text,FND_API.g_miss_char,footer_text,p_footer_text),
733: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
734: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
727:
728: UPDATE ams_campaign_schedules_tl
729: SET schedule_name = DECODE(p_schedule_name,FND_API.g_miss_char,schedule_name,p_schedule_name),
730: description = DECODE(p_schedule_description,FND_API.g_miss_char,description,p_schedule_description),
731: greeting_text = DECODE(p_greeting_text,FND_API.g_miss_char,greeting_text,p_greeting_text),
732: footer_text = DECODE(p_footer_text,FND_API.g_miss_char,footer_text,p_footer_text),
733: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
734: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
735: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
728: UPDATE ams_campaign_schedules_tl
729: SET schedule_name = DECODE(p_schedule_name,FND_API.g_miss_char,schedule_name,p_schedule_name),
730: description = DECODE(p_schedule_description,FND_API.g_miss_char,description,p_schedule_description),
731: greeting_text = DECODE(p_greeting_text,FND_API.g_miss_char,greeting_text,p_greeting_text),
732: footer_text = DECODE(p_footer_text,FND_API.g_miss_char,footer_text,p_footer_text),
733: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
734: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
735: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
736: source_lang = USERENV('LANG')
729: SET schedule_name = DECODE(p_schedule_name,FND_API.g_miss_char,schedule_name,p_schedule_name),
730: description = DECODE(p_schedule_description,FND_API.g_miss_char,description,p_schedule_description),
731: greeting_text = DECODE(p_greeting_text,FND_API.g_miss_char,greeting_text,p_greeting_text),
732: footer_text = DECODE(p_footer_text,FND_API.g_miss_char,footer_text,p_footer_text),
733: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
734: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
735: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
736: source_lang = USERENV('LANG')
737: WHERE schedule_id = p_schedule_id
730: description = DECODE(p_schedule_description,FND_API.g_miss_char,description,p_schedule_description),
731: greeting_text = DECODE(p_greeting_text,FND_API.g_miss_char,greeting_text,p_greeting_text),
732: footer_text = DECODE(p_footer_text,FND_API.g_miss_char,footer_text,p_footer_text),
733: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
734: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
735: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
736: source_lang = USERENV('LANG')
737: WHERE schedule_id = p_schedule_id
738: AND USERENV('LANG') IN (language, source_lang);
731: greeting_text = DECODE(p_greeting_text,FND_API.g_miss_char,greeting_text,p_greeting_text),
732: footer_text = DECODE(p_footer_text,FND_API.g_miss_char,footer_text,p_footer_text),
733: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
734: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
735: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
736: source_lang = USERENV('LANG')
737: WHERE schedule_id = p_schedule_id
738: AND USERENV('LANG') IN (language, source_lang);
739:
737: WHERE schedule_id = p_schedule_id
738: AND USERENV('LANG') IN (language, source_lang);
739:
740: IF (SQL%NOTFOUND) THEN
741: RAISE FND_API.g_exc_error;
742: END IF;
743:
744: END Update_Row;
745:
762:
763: DELETE FROM ams_campaign_schedules_b
764: WHERE schedule_id = p_schedule_id;
765: If (SQL%NOTFOUND) THEN
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: End If;
768:
769: END Delete_Row ;
770: