DBA Data[Home] [Help]

APPS.IRC_SEARCH_CRITERIA_BE7 dependencies on WF_EVENT

Line 101: select per_wf_events_s.nextval from dual;

97: l_text varchar2(2000);
98: l_message varchar2(10);
99: --
100: cursor get_seq is
101: select per_wf_events_s.nextval from dual;
102: --
103: l_proc varchar2(72):=' irc_search_criteria_be7.create_work_choices_a';
104: begin
105: hr_utility.set_location('Entering: '||l_proc,10);

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

104: begin
105: hr_utility.set_location('Entering: '||l_proc,10);
106: -- check the status of the business event
107: l_event_name:='oracle.apps.per.irc.api.search_criteria.create_work_choices';
108: l_message:=wf_event.test(l_event_name);
109: --
110: if (l_message='MESSAGE') then
111: hr_utility.set_location(l_proc,20);
112: --

Line 488: wf_event.raise(p_event_name=>l_event_name

484: --
485: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
486: --
487: -- raise the event with the event data
488: wf_event.raise(p_event_name=>l_event_name
489: ,p_event_key=>l_event_key
490: ,p_event_data=>l_event_data);
491: --
492: elsif (l_message='KEY') then

Line 500: wf_event.raise(p_event_name=>l_event_name

496: fetch get_seq into l_event_key;
497: close get_seq;
498: -- this is a key event, so just raise the event
499: -- without the event data
500: wf_event.raise(p_event_name=>l_event_name
501: ,p_event_key=>l_event_key);
502: --
503: elsif (l_message='NONE') then
504: hr_utility.set_location(l_proc,40);