DBA Data[Home] [Help]

APPS.PER_QUALIFICATIONS_BE1 dependencies on WF_EVENT

Line 86: select per_wf_events_s.nextval from dual;

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

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

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

Line 413: wf_event.raise(p_event_name=>l_event_name

409: --
410: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
411: --
412: -- raise the event with the event data
413: wf_event.raise(p_event_name=>l_event_name
414: ,p_event_key=>l_event_key
415: ,p_event_data=>l_event_data);
416: elsif (l_message='KEY') then
417: hr_utility.set_location(l_proc,30);

Line 424: wf_event.raise(p_event_name=>l_event_name

420: fetch get_seq into l_event_key;
421: close get_seq;
422: -- this is a key event, so just raise the event
423: -- without the event data
424: wf_event.raise(p_event_name=>l_event_name
425: ,p_event_key=>l_event_key);
426: elsif (l_message='NONE') then
427: hr_utility.set_location(l_proc,40);
428: -- no event is required, so do nothing