[Home] [Help]
109: l_text varchar2(2000);
110: l_message varchar2(10);
111: --
112: cursor get_seq is
113: select per_wf_events_s.nextval from dual;
114: --
115: l_proc varchar2(72):=' hr_assignment_beM.update_cwk_asg_a';
116: begin
117: hr_utility.set_location('Entering: '||l_proc,10);
116: begin
117: hr_utility.set_location('Entering: '||l_proc,10);
118: -- check the status of the business event
119: l_event_name:='oracle.apps.per.api.assignment.update_cwk_asg';
120: l_message:=wf_event.test(l_event_name);
121: --
122: if (l_message='MESSAGE') then
123: hr_utility.set_location(l_proc,20);
124: --
563: if p_effective_start_date is not NULL and
564: p_effective_start_date > trunc(SYSDATE) and
565: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
566: -- raise the event with the event data, with send date set to effective date
567: wf_event.raise(p_event_name=>l_event_name
568: ,p_event_key=>l_event_key
569: ,p_event_data=>l_event_data
570: ,p_send_date => p_effective_start_date);
571: --
570: ,p_send_date => p_effective_start_date);
571: --
572: else
573: -- raise the event with the event data
574: wf_event.raise(p_event_name=>l_event_name
575: ,p_event_key=>l_event_key
576: ,p_event_data=>l_event_data);
577: end if;
578: elsif (l_message='KEY') then
585: p_effective_start_date > trunc(SYSDATE) and
586: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
587: -- this is a key event, so just raise the event
588: -- without the event data, with send date set to effective date
589: wf_event.raise(p_event_name=>l_event_name
590: ,p_event_key=>l_event_key
591: ,p_send_date => p_effective_start_date);
592: --
593: else
592: --
593: else
594: -- this is a key event, so just raise the event
595: -- without the event data
596: wf_event.raise(p_event_name=>l_event_name
597: ,p_event_key=>l_event_key);
598: end if;
599: elsif (l_message='NONE') then
600: hr_utility.set_location(l_proc,40);