DBA Data[Home] [Help]

APPS.IRC_PARTY_BE3 dependencies on WF_EVENT

Line 20: select per_wf_events_s.nextval from dual;

16: l_text varchar2(2000);
17: l_message varchar2(10);
18: --
19: cursor get_seq is
20: select per_wf_events_s.nextval from dual;
21: --
22: l_proc varchar2(72):=' irc_party_be3.registered_user_application_a';
23: begin
24: hr_utility.set_location('Entering: '||l_proc,10);

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

23: begin
24: hr_utility.set_location('Entering: '||l_proc,10);
25: -- check the status of the business event
26: l_event_name:='oracle.apps.per.irc.api.party.registered_user_application';
27: l_message:=wf_event.test(l_event_name);
28: --
29: if (l_message='MESSAGE') then
30: hr_utility.set_location(l_proc,20);
31: --

Line 83: wf_event.raise(p_event_name=>l_event_name

79: --
80: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
81: --
82: -- raise the event with the event data
83: wf_event.raise(p_event_name=>l_event_name
84: ,p_event_key=>l_event_key
85: ,p_event_data=>l_event_data);
86: elsif (l_message='KEY') then
87: hr_utility.set_location(l_proc,30);

Line 94: wf_event.raise(p_event_name=>l_event_name

90: fetch get_seq into l_event_key;
91: close get_seq;
92: -- this is a key event, so just raise the event
93: -- without the event data
94: wf_event.raise(p_event_name=>l_event_name
95: ,p_event_key=>l_event_key);
96: elsif (l_message='NONE') then
97: hr_utility.set_location(l_proc,40);
98: -- no event is required, so do nothing