12: -- 5. Task assignment status should be of 'CSF: Default Assigned task status' profile value
13: -- at the application level
14:
15: function checkForAlerts (p_subscription_guid in raw,
16: p_event in out nocopy WF_EVENT_T) return varchar2 is
17:
18: l_event_name varchar2(100);
19: l_event_key varchar2(100);
20: l_task_asgn_id number;
291: l_resource_type_code,
292: l_task_asgn_id,
293: p_event.getEventKey());
294:
295: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
296: p_event_key => l_event_key,
297: p_parameters => l_wf_parameter_list_t,
298: p_send_date => l_send_date);
299:
331: l_resource_type_code,
332: l_task_asgn_id,
333: p_event.getEventKey());
334:
335: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
336: p_event_key => l_event_key,
337: p_parameters => l_wf_parameter_list_t,
338: p_send_date => l_send_date);
339:
390: l_new_resource_type,
391: l_task_asgn_id,
392: p_event.getEventKey());
393:
394: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
395: p_event_key => l_event_key,
396: p_parameters => l_wf_parameter_list_t,
397: p_send_date => l_send_date
398: );
412: l_old_resource_type,
413: l_task_asgn_id,
414: p_event.getEventKey());
415:
416: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
417: p_event_key => l_event_key,
418: p_parameters => l_wf_parameter_list_t,
419: p_send_date => l_send_date);
420:
461: l_resource_type_code,
462: l_task_asgn_id,
463: p_event.getEventKey());
464:
465: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
466: p_event_key => l_event_key,
467: p_parameters => l_wf_parameter_list_t,
468: p_send_date => l_send_date);
469:
499: l_resource_type_code,
500: l_task_asgn_id,
501: p_event.getEventKey());
502:
503: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
504: p_event_key => l_event_key,
505: p_parameters => l_wf_parameter_list_t,
506: p_send_date => l_send_date
507: );
582: l_resource_type_code,
583: l_task_asgn_id,
584: p_event.getEventKey());
585:
586: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
587: p_event_key => l_event_key,
588: p_parameters => l_wf_parameter_list_t,
589: p_send_date => l_send_date
590: );
609: l_resource_type_code,
610: l_task_asgn_id,
611: p_event.getEventKey());
612:
613: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
614: p_event_key => l_event_key,
615: p_parameters => l_wf_parameter_list_t,
616: p_send_date => l_send_date
617: );
631:
632: end;
633:
634: function sendNotification (p_subscription_guid in raw,
635: p_event in out nocopy WF_EVENT_T) return varchar2 is
636:
637: l_msg_subject varchar(1000);
638: l_msg_subject2 varchar(1000);
639: