DBA Data[Home] [Help]

APPS.IRC_POSTING_CONTENT_BE2 dependencies on WF_EVENT

Line 92: select per_wf_events_s.nextval from dual;

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

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

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

Line 443: wf_event.raise(p_event_name=>l_event_name

439: --
440: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
441: --
442: -- raise the event with the event data
443: wf_event.raise(p_event_name=>l_event_name
444: ,p_event_key=>l_event_key
445: ,p_event_data=>l_event_data);
446: --
447: elsif (l_message='KEY') then

Line 455: wf_event.raise(p_event_name=>l_event_name

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