DBA Data[Home] [Help]

APPS.HR_PERSON_ADDRESS_BE1 dependencies on WF_EVENT

Line 66: select per_wf_events_s.nextval from dual;

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

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

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

Line 321: wf_event.raise(p_event_name=>l_event_name

317: --
318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
319: --
320: -- raise the event with the event data
321: wf_event.raise(p_event_name=>l_event_name
322: ,p_event_key=>l_event_key
323: ,p_event_data=>l_event_data);
324: elsif (l_message='KEY') then
325: hr_utility.set_location(l_proc,30);

Line 332: wf_event.raise(p_event_name=>l_event_name

328: fetch get_seq into l_event_key;
329: close get_seq;
330: -- this is a key event, so just raise the event
331: -- without the event data
332: wf_event.raise(p_event_name=>l_event_name
333: ,p_event_key=>l_event_key);
334: elsif (l_message='NONE') then
335: hr_utility.set_location(l_proc,40);
336: -- no event is required, so do nothing