DBA Data[Home] [Help]

APPS.HR_PREVIOUS_EMPLOYMENT_BE7 dependencies on WF_EVENT

Line 64: select per_wf_events_s.nextval from dual;

60: l_text varchar2(2000);
61: l_message varchar2(10);
62: --
63: cursor get_seq is
64: select per_wf_events_s.nextval from dual;
65: --
66: l_proc varchar2(72):=' hr_previous_employment_be7.create_previous_job_usage_a';
67: begin
68: hr_utility.set_location('Entering: '||l_proc,10);

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

67: begin
68: hr_utility.set_location('Entering: '||l_proc,10);
69: -- check the status of the business event
70: l_event_name:='oracle.apps.per.api.previous_employment.create_previous_job_usage';
71: l_message:=wf_event.test(l_event_name);
72: --
73: if (l_message='MESSAGE') then
74: hr_utility.set_location(l_proc,20);
75: --

Line 303: wf_event.raise(p_event_name=>l_event_name

299: --
300: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
301: --
302: -- raise the event with the event data
303: wf_event.raise(p_event_name=>l_event_name
304: ,p_event_key=>l_event_key
305: ,p_event_data=>l_event_data);
306: elsif (l_message='KEY') then
307: hr_utility.set_location(l_proc,30);

Line 314: wf_event.raise(p_event_name=>l_event_name

310: fetch get_seq into l_event_key;
311: close get_seq;
312: -- this is a key event, so just raise the event
313: -- without the event data
314: wf_event.raise(p_event_name=>l_event_name
315: ,p_event_key=>l_event_key);
316: elsif (l_message='NONE') then
317: hr_utility.set_location(l_proc,40);
318: -- no event is required, so do nothing