[Home] [Help]
138: l_text varchar2(2000);
139: l_message varchar2(10);
140: --
141: cursor get_seq is
142: select per_wf_events_s.nextval from dual;
143: --
144: l_proc varchar2(72):=' hr_contingent_worker_be1.create_cwk_a';
145: begin
146: hr_utility.set_location('Entering: '||l_proc,10);
145: begin
146: hr_utility.set_location('Entering: '||l_proc,10);
147: -- check the status of the business event
148: l_event_name:='oracle.apps.per.api.contingent_worker.create_cwk';
149: l_message:=wf_event.test(l_event_name);
150: --
151: if (l_message='MESSAGE') then
152: hr_utility.set_location(l_proc,20);
153: --
696: if p_per_effective_start_date is not NULL and
697: p_per_effective_start_date > trunc(SYSDATE) and
698: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
699: -- raise the event with the event data, with send date set to effective date
700: wf_event.raise(p_event_name=>l_event_name
701: ,p_event_key=>l_event_key
702: ,p_event_data=>l_event_data
703: ,p_send_date => p_per_effective_start_date);
704: --
703: ,p_send_date => p_per_effective_start_date);
704: --
705: else
706: -- raise the event with the event data
707: wf_event.raise(p_event_name=>l_event_name
708: ,p_event_key=>l_event_key
709: ,p_event_data=>l_event_data);
710: end if;
711: elsif (l_message='KEY') then
718: p_per_effective_start_date > trunc(SYSDATE) and
719: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
720: -- this is a key event, so just raise the event
721: -- without the event data, with send date set to effective date
722: wf_event.raise(p_event_name=>l_event_name
723: ,p_event_key=>l_event_key
724: ,p_send_date => p_per_effective_start_date);
725: --
726: else
725: --
726: else
727: -- this is a key event, so just raise the event
728: -- without the event data
729: wf_event.raise(p_event_name=>l_event_name
730: ,p_event_key=>l_event_key);
731: end if;
732: elsif (l_message='NONE') then
733: hr_utility.set_location(l_proc,40);