DBA Data[Home] [Help]

APPS.PER_REQUISITIONS_BE2 dependencies on WF_EVENT

Line 50: select per_wf_events_s.nextval from dual;

46: l_text varchar2(2000);
47: l_message varchar2(10);
48: --
49: cursor get_seq is
50: select per_wf_events_s.nextval from dual;
51: --
52: l_proc varchar2(72):=' per_requisitions_be2.update_requisition_a';
53: begin
54: hr_utility.set_location('Entering: '||l_proc,10);

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

53: begin
54: hr_utility.set_location('Entering: '||l_proc,10);
55: -- check the status of the business event
56: l_event_name:='oracle.apps.per.api.requisitions.update_requisition';
57: l_message:=wf_event.test(l_event_name);
58: --
59: if (l_message='MESSAGE') then
60: hr_utility.set_location(l_proc,20);
61: --

Line 233: wf_event.raise(p_event_name=>l_event_name

229: --
230: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
231: --
232: -- raise the event with the event data
233: wf_event.raise(p_event_name=>l_event_name
234: ,p_event_key=>l_event_key
235: ,p_event_data=>l_event_data);
236: --
237: elsif (l_message='KEY') then

Line 245: wf_event.raise(p_event_name=>l_event_name

241: fetch get_seq into l_event_key;
242: close get_seq;
243: -- this is a key event, so just raise the event
244: -- without the event data
245: wf_event.raise(p_event_name=>l_event_name
246: ,p_event_key=>l_event_key);
247: --
248: elsif (l_message='NONE') then
249: hr_utility.set_location(l_proc,40);