DBA Data[Home] [Help]

APPS.HR_ORGANIZATION_BE9 dependencies on WF_EVENT

Line 59: select per_wf_events_s.nextval from dual;

55: l_text varchar2(2000);
56: l_message varchar2(10);
57: --
58: cursor get_seq is
59: select per_wf_events_s.nextval from dual;
60: --
61: l_proc varchar2(72):=' hr_organization_be9.create_hr_organization_a';
62: begin
63: hr_utility.set_location('Entering: '||l_proc,10);

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

62: begin
63: hr_utility.set_location('Entering: '||l_proc,10);
64: -- check the status of the business event
65: l_event_name:='oracle.apps.per.api.organization.create_hr_organization';
66: l_message:=wf_event.test(l_event_name);
67: --
68: if (l_message='MESSAGE') then
69: hr_utility.set_location(l_proc,20);
70: --

Line 282: wf_event.raise(p_event_name=>l_event_name

278: --
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
280: --
281: -- raise the event with the event data
282: wf_event.raise(p_event_name=>l_event_name
283: ,p_event_key=>l_event_key
284: ,p_event_data=>l_event_data);
285: elsif (l_message='KEY') then
286: hr_utility.set_location(l_proc,30);

Line 293: wf_event.raise(p_event_name=>l_event_name

289: fetch get_seq into l_event_key;
290: close get_seq;
291: -- this is a key event, so just raise the event
292: -- without the event data
293: wf_event.raise(p_event_name=>l_event_name
294: ,p_event_key=>l_event_key);
295: elsif (l_message='NONE') then
296: hr_utility.set_location(l_proc,40);
297: -- no event is required, so do nothing