APPS.HR_COMPETENCE_ELEMENT_BE2 dependencies on WF_EVENT

Line 80: select per_wf_events_s.nextval from dual;

76: l_text varchar2(2000);
77: l_message varchar2(10);
78: --
79: cursor get_seq is
80: select per_wf_events_s.nextval from dual;
81: --
82: l_proc varchar2(72):=' hr_competence_element_be2.update_competence_element_a';
83: begin
84: hr_utility.set_location('Entering: '||l_proc,10);

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

83: begin
84: hr_utility.set_location('Entering: '||l_proc,10);
85: -- check the status of the business event
86: l_event_name:='oracle.apps.per.api.competence_element.update_competence_element';
87: l_message:=wf_event.test(l_event_name);
88: --
89: if (l_message='MESSAGE') then
90: hr_utility.set_location(l_proc,20);
91: --

Line 383: wf_event.raise(p_event_name=>l_event_name

379: --
380: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
381: --
382: -- raise the event with the event data
383: wf_event.raise(p_event_name=>l_event_name
384: ,p_event_key=>l_event_key
385: ,p_event_data=>l_event_data);
386: --
387: elsif (l_message='KEY') then

Line 395: wf_event.raise(p_event_name=>l_event_name

391: fetch get_seq into l_event_key;
392: close get_seq;
393: -- this is a key event, so just raise the event
394: -- without the event data
395: wf_event.raise(p_event_name=>l_event_name
396: ,p_event_key=>l_event_key);
397: --
398: elsif (l_message='NONE') then
399: hr_utility.set_location(l_proc,40);