APPS.PER_QUALIFICATIONS_BE2 dependencies on WF_EVENT

Line 84: select per_wf_events_s.nextval from dual;

80: l_text varchar2(2000);
81: l_message varchar2(10);
82: --
83: cursor get_seq is
84: select per_wf_events_s.nextval from dual;
85: --
86: l_proc varchar2(72):=' per_qualifications_be2.update_qualification_a';
87: begin
88: hr_utility.set_location('Entering: '||l_proc,10);

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

87: begin
88: hr_utility.set_location('Entering: '||l_proc,10);
89: -- check the status of the business event
90: l_event_name:='oracle.apps.per.api.qualifications.update_qualification';
91: l_message:=wf_event.test(l_event_name);
92: --
93: if (l_message='MESSAGE') then
94: hr_utility.set_location(l_proc,20);
95: --

Line 403: wf_event.raise(p_event_name=>l_event_name

399: --
400: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
401: --
402: -- raise the event with the event data
403: wf_event.raise(p_event_name=>l_event_name
404: ,p_event_key=>l_event_key
405: ,p_event_data=>l_event_data);
406: elsif (l_message='KEY') then
407: hr_utility.set_location(l_proc,30);

Line 414: wf_event.raise(p_event_name=>l_event_name

410: fetch get_seq into l_event_key;
411: close get_seq;
412: -- this is a key event, so just raise the event
413: -- without the event data
414: wf_event.raise(p_event_name=>l_event_name
415: ,p_event_key=>l_event_key);
416: elsif (l_message='NONE') then
417: hr_utility.set_location(l_proc,40);
418: -- no event is required, so do nothing