[Home] [Help]
19: l_text varchar2(2000);
20: l_message varchar2(10);
21: --
22: cursor get_seq is
23: select per_wf_events_s.nextval from dual;
24: --
25: l_proc varchar2(72):=' irc_assignment_details_be1.create_assignment_details_a';
26: begin
27: hr_utility.set_location('Entering: '||l_proc,10);
26: begin
27: hr_utility.set_location('Entering: '||l_proc,10);
28: -- check the status of the business event
29: l_event_name:='oracle.apps.per.irc.api.assignment_details.create_assignment_details';
30: l_message:=wf_event.test(l_event_name);
31: --
32: if (l_message='MESSAGE') then
33: hr_utility.set_location(l_proc,20);
34: --
97: if p_effective_start_date is not NULL and
98: p_effective_start_date > trunc(SYSDATE) and
99: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
100: -- raise the event with the event data, with send date set to effective date
101: wf_event.raise(p_event_name=>l_event_name
102: ,p_event_key=>l_event_key
103: ,p_event_data=>l_event_data
104: ,p_send_date => p_effective_start_date);
105: --
104: ,p_send_date => p_effective_start_date);
105: --
106: else
107: -- raise the event with the event data
108: wf_event.raise(p_event_name=>l_event_name
109: ,p_event_key=>l_event_key
110: ,p_event_data=>l_event_data);
111: end if;
112: elsif (l_message='KEY') then
119: p_effective_start_date > trunc(SYSDATE) and
120: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
121: -- this is a key event, so just raise the event
122: -- without the event data, with send date set to effective date
123: wf_event.raise(p_event_name=>l_event_name
124: ,p_event_key=>l_event_key
125: ,p_send_date => p_effective_start_date);
126: --
127: else
126: --
127: else
128: -- this is a key event, so just raise the event
129: -- without the event data
130: wf_event.raise(p_event_name=>l_event_name
131: ,p_event_key=>l_event_key);
132: end if;
133: elsif (l_message='NONE') then
134: hr_utility.set_location(l_proc,40);