DBA Data[Home] [Help]

APPS.HR_APPLICATION_BE1 dependencies on WF_EVENT

Line 40: select per_wf_events_s.nextval from dual;

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

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

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

Line 183: wf_event.raise(p_event_name=>l_event_name

179: --
180: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
181: --
182: -- raise the event with the event data
183: wf_event.raise(p_event_name=>l_event_name
184: ,p_event_key=>l_event_key
185: ,p_event_data=>l_event_data);
186: --
187: elsif (l_message='KEY') then

Line 195: wf_event.raise(p_event_name=>l_event_name

191: fetch get_seq into l_event_key;
192: close get_seq;
193: -- this is a key event, so just raise the event
194: -- without the event data
195: wf_event.raise(p_event_name=>l_event_name
196: ,p_event_key=>l_event_key);
197: --
198: elsif (l_message='NONE') then
199: hr_utility.set_location(l_proc,40);