APPS.PER_ESTAB_ATTENDANCES_BE2 dependencies on WF_EVENT

Line 42: select per_wf_events_s.nextval from dual;

38: l_text varchar2(2000);
39: l_message varchar2(10);
40: --
41: cursor get_seq is
42: select per_wf_events_s.nextval from dual;
43: --
44: l_proc varchar2(72):=' per_estab_attendances_be2.update_attended_estab_a';
45: begin
46: hr_utility.set_location('Entering: '||l_proc,10);

Line 49: l_message:=wf_event.test(l_event_name);

45: begin
46: hr_utility.set_location('Entering: '||l_proc,10);
47: -- check the status of the business event
48: l_event_name:='oracle.apps.per.api.estab_attendances.update_attended_estab';
49: l_message:=wf_event.test(l_event_name);
50: --
51: if (l_message='MESSAGE') then
52: hr_utility.set_location(l_proc,20);
53: --

Line 193: wf_event.raise(p_event_name=>l_event_name

189: --
190: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
191: --
192: -- raise the event with the event data
193: wf_event.raise(p_event_name=>l_event_name
194: ,p_event_key=>l_event_key
195: ,p_event_data=>l_event_data);
196: --
197: elsif (l_message='KEY') then

Line 205: wf_event.raise(p_event_name=>l_event_name

201: fetch get_seq into l_event_key;
202: close get_seq;
203: -- this is a key event, so just raise the event
204: -- without the event data
205: wf_event.raise(p_event_name=>l_event_name
206: ,p_event_key=>l_event_key);
207: --
208: elsif (l_message='NONE') then
209: hr_utility.set_location(l_proc,40);