DBA Data[Home] [Help]

APPS.IRC_SEARCH_CRITERIA_BE5 dependencies on WF_EVENT

Line 93: select per_wf_events_s.nextval from dual;

89: l_text varchar2(2000);
90: l_message varchar2(10);
91: --
92: cursor get_seq is
93: select per_wf_events_s.nextval from dual;
94: --
95: l_proc varchar2(72):=' irc_search_criteria_be5.update_vacancy_criteria_a';
96: begin
97: hr_utility.set_location('Entering: '||l_proc,10);

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

96: begin
97: hr_utility.set_location('Entering: '||l_proc,10);
98: -- check the status of the business event
99: l_event_name:='oracle.apps.per.irc.api.search_criteria.update_vacancy_criteria';
100: l_message:=wf_event.test(l_event_name);
101: --
102: if (l_message='MESSAGE') then
103: hr_utility.set_location(l_proc,20);
104: --

Line 448: wf_event.raise(p_event_name=>l_event_name

444: --
445: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
446: --
447: -- raise the event with the event data
448: wf_event.raise(p_event_name=>l_event_name
449: ,p_event_key=>l_event_key
450: ,p_event_data=>l_event_data);
451: --
452: elsif (l_message='KEY') then

Line 460: wf_event.raise(p_event_name=>l_event_name

456: fetch get_seq into l_event_key;
457: close get_seq;
458: -- this is a key event, so just raise the event
459: -- without the event data
460: wf_event.raise(p_event_name=>l_event_name
461: ,p_event_key=>l_event_key);
462: --
463: elsif (l_message='NONE') then
464: hr_utility.set_location(l_proc,40);