61: select per_wf_events_s.nextval from dual;
62: --
63: l_proc varchar2(72):=' irc_recruiting_sites_be1.create_recruiting_site_a';
64: begin
65: hr_utility.set_location('Entering: '||l_proc,10);
66: -- check the status of the business event
67: l_event_name:='oracle.apps.per.irc.api.recruiting_sites.create_recruiting_site';
68: l_message:=wf_event.test(l_event_name);
69: --
67: l_event_name:='oracle.apps.per.irc.api.recruiting_sites.create_recruiting_site';
68: l_message:=wf_event.test(l_event_name);
69: --
70: if (l_message='MESSAGE') then
71: hr_utility.set_location(l_proc,20);
72: --
73: -- get a key for the event
74: --
75: open get_seq;
289: ,p_event_key=>l_event_key
290: ,p_event_data=>l_event_data);
291: --
292: elsif (l_message='KEY') then
293: hr_utility.set_location(l_proc,30);
294: -- get a key for the event
295: open get_seq;
296: fetch get_seq into l_event_key;
297: close get_seq;
300: wf_event.raise(p_event_name=>l_event_name
301: ,p_event_key=>l_event_key);
302: --
303: elsif (l_message='NONE') then
304: hr_utility.set_location(l_proc,40);
305: -- no event is required, so do nothing
306: null;
307: end if;
308: hr_utility.set_location('Leaving: '||l_proc,50);
304: hr_utility.set_location(l_proc,40);
305: -- no event is required, so do nothing
306: null;
307: end if;
308: hr_utility.set_location('Leaving: '||l_proc,50);
309: end create_recruiting_site_a;
310: end irc_recruiting_sites_be1;