DBA Data[Home] [Help]

APPS.HR_EX_EMPLOYEE_BE1 dependencies on WF_EVENT

Line 82: select per_wf_events_s.nextval from dual;

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

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

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

Line 425: wf_event.raise(p_event_name=>l_event_name

421: --
422: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
423: --
424: -- raise the event with the event data
425: wf_event.raise(p_event_name=>l_event_name
426: ,p_event_key=>l_event_key
427: ,p_event_data=>l_event_data);
428: --
429: elsif (l_message='KEY') then

Line 437: wf_event.raise(p_event_name=>l_event_name

433: fetch get_seq into l_event_key;
434: close get_seq;
435: -- this is a key event, so just raise the event
436: -- without the event data
437: wf_event.raise(p_event_name=>l_event_name
438: ,p_event_key=>l_event_key);
439: --
440: elsif (l_message='NONE') then
441: hr_utility.set_location(l_proc,40);