APPS.IRC_PENDING_DATA_BE3 dependencies on WF_EVENT

Line 13: select per_wf_events_s.nextval from dual;

9: l_text varchar2(2000);
10: l_message varchar2(10);
11: --
12: cursor get_seq is
13: select per_wf_events_s.nextval from dual;
14: --
15: l_proc varchar2(72):=' irc_pending_data_be3.delete_pending_data_a';
16: begin
17: hr_utility.set_location('Entering: '||l_proc,10);

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

16: begin
17: hr_utility.set_location('Entering: '||l_proc,10);
18: -- check the status of the business event
19: l_event_name:='oracle.apps.per.irc.api.pending_data.delete_pending_data';
20: l_message:=wf_event.test(l_event_name);
21: --
22: if (l_message='MESSAGE') then
23: hr_utility.set_location(l_proc,20);
24: --

Line 48: wf_event.raise(p_event_name=>l_event_name

44: --
45: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
46: --
47: -- raise the event with the event data
48: wf_event.raise(p_event_name=>l_event_name
49: ,p_event_key=>l_event_key
50: ,p_event_data=>l_event_data);
51: --
52: elsif (l_message='KEY') then

Line 60: wf_event.raise(p_event_name=>l_event_name

56: fetch get_seq into l_event_key;
57: close get_seq;
58: -- this is a key event, so just raise the event
59: -- without the event data
60: wf_event.raise(p_event_name=>l_event_name
61: ,p_event_key=>l_event_key);
62: --
63: elsif (l_message='NONE') then
64: hr_utility.set_location(l_proc,40);