DBA Data[Home] [Help]

APPS.HR_PREVIOUS_EMPLOYMENT_BE2 dependencies on WF_EVENT

Line 89: select per_wf_events_s.nextval from dual;

85: l_text varchar2(2000);
86: l_message varchar2(10);
87: --
88: cursor get_seq is
89: select per_wf_events_s.nextval from dual;
90: --
91: l_proc varchar2(72):=' hr_previous_employment_be2.update_previous_employer_a';
92: begin
93: hr_utility.set_location('Entering: '||l_proc,10);

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

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

Line 428: wf_event.raise(p_event_name=>l_event_name

424: --
425: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
426: --
427: -- raise the event with the event data
428: wf_event.raise(p_event_name=>l_event_name
429: ,p_event_key=>l_event_key
430: ,p_event_data=>l_event_data);
431: elsif (l_message='KEY') then
432: hr_utility.set_location(l_proc,30);

Line 439: wf_event.raise(p_event_name=>l_event_name

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