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