[Home] [Help]
100: l_text varchar2(2000);
101: l_message varchar2(10);
102: --
103: cursor get_seq is
104: select per_wf_events_s.nextval from dual;
105: --
106: l_proc varchar2(72):=' pay_element_types_be2.update_element_type_a';
107: begin
108: hr_utility.set_location('Entering: '||l_proc,10);
107: begin
108: hr_utility.set_location('Entering: '||l_proc,10);
109: -- check the status of the business event
110: l_event_name:='oracle.apps.pay.api.element_types.update_element_type';
111: l_message:=wf_event.test(l_event_name);
112: --
113: if (l_message='MESSAGE') then
114: hr_utility.set_location(l_proc,20);
115: --
514: if p_effective_start_date is not NULL and
515: p_effective_start_date > trunc(SYSDATE) and
516: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
517: -- raise the event with the event data, with send date set to effective date
518: wf_event.raise(p_event_name=>l_event_name
519: ,p_event_key=>l_event_key
520: ,p_event_data=>l_event_data
521: ,p_send_date => p_effective_start_date);
522: --
521: ,p_send_date => p_effective_start_date);
522: --
523: else
524: -- raise the event with the event data
525: wf_event.raise(p_event_name=>l_event_name
526: ,p_event_key=>l_event_key
527: ,p_event_data=>l_event_data);
528: end if;
529: elsif (l_message='KEY') then
536: p_effective_start_date > trunc(SYSDATE) and
537: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
538: -- this is a key event, so just raise the event
539: -- without the event data, with send date set to effective date
540: wf_event.raise(p_event_name=>l_event_name
541: ,p_event_key=>l_event_key
542: ,p_send_date => p_effective_start_date);
543: --
544: else
543: --
544: else
545: -- this is a key event, so just raise the event
546: -- without the event data
547: wf_event.raise(p_event_name=>l_event_name
548: ,p_event_key=>l_event_key);
549: end if;
550: elsif (l_message='NONE') then
551: hr_utility.set_location(l_proc,40);