DBA Data[Home] [Help]

APPS.IRC_RECRUITING_SITES_BE2 dependencies on WF_EVENT

Line 62: select per_wf_events_s.nextval from dual;

58: l_text varchar2(2000);
59: l_message varchar2(10);
60: --
61: cursor get_seq is
62: select per_wf_events_s.nextval from dual;
63: --
64: l_proc varchar2(72):=' irc_recruiting_sites_be2.update_recruiting_site_a';
65: begin
66: hr_utility.set_location('Entering: '||l_proc,10);

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

65: begin
66: hr_utility.set_location('Entering: '||l_proc,10);
67: -- check the status of the business event
68: l_event_name:='oracle.apps.per.irc.api.recruiting_sites.update_recruiting_site';
69: l_message:=wf_event.test(l_event_name);
70: --
71: if (l_message='MESSAGE') then
72: hr_utility.set_location(l_proc,20);
73: --

Line 293: wf_event.raise(p_event_name=>l_event_name

289: --
290: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
291: --
292: -- raise the event with the event data
293: wf_event.raise(p_event_name=>l_event_name
294: ,p_event_key=>l_event_key
295: ,p_event_data=>l_event_data);
296: elsif (l_message='KEY') then
297: hr_utility.set_location(l_proc,30);

Line 304: wf_event.raise(p_event_name=>l_event_name

300: fetch get_seq into l_event_key;
301: close get_seq;
302: -- this is a key event, so just raise the event
303: -- without the event data
304: wf_event.raise(p_event_name=>l_event_name
305: ,p_event_key=>l_event_key);
306: elsif (l_message='NONE') then
307: hr_utility.set_location(l_proc,40);
308: -- no event is required, so do nothing