eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_PUB_ICC dependencies on WF_ENGINE

Line 112: WF_ENGINE.CreateProcess(wftype, l_batch_id,wfname);

108: /**
109: *If system is valid, start a workflow process to send notification to receiver defined in the event subscription
110: */
111: if is_valid_system(l_batch_id,l_system)=true then
112: WF_ENGINE.CreateProcess(wftype, l_batch_id,wfname);
113: WF_ENGINE.SetItemAttrNumber(wftype, l_batch_id, 'BATCH_ID', l_batch_id);
114: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'MAIL_TO', l_mail_to);
115: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'WF_ADMINISTRATOR', l_wf_admin);
116: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'PUB_SYSTEM', l_system);

Line 113: WF_ENGINE.SetItemAttrNumber(wftype, l_batch_id, 'BATCH_ID', l_batch_id);

109: *If system is valid, start a workflow process to send notification to receiver defined in the event subscription
110: */
111: if is_valid_system(l_batch_id,l_system)=true then
112: WF_ENGINE.CreateProcess(wftype, l_batch_id,wfname);
113: WF_ENGINE.SetItemAttrNumber(wftype, l_batch_id, 'BATCH_ID', l_batch_id);
114: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'MAIL_TO', l_mail_to);
115: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'WF_ADMINISTRATOR', l_wf_admin);
116: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'PUB_SYSTEM', l_system);
117: WF_ENGINE.StartProcess(wftype, l_batch_id);

Line 114: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'MAIL_TO', l_mail_to);

110: */
111: if is_valid_system(l_batch_id,l_system)=true then
112: WF_ENGINE.CreateProcess(wftype, l_batch_id,wfname);
113: WF_ENGINE.SetItemAttrNumber(wftype, l_batch_id, 'BATCH_ID', l_batch_id);
114: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'MAIL_TO', l_mail_to);
115: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'WF_ADMINISTRATOR', l_wf_admin);
116: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'PUB_SYSTEM', l_system);
117: WF_ENGINE.StartProcess(wftype, l_batch_id);
118: end if;

Line 115: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'WF_ADMINISTRATOR', l_wf_admin);

111: if is_valid_system(l_batch_id,l_system)=true then
112: WF_ENGINE.CreateProcess(wftype, l_batch_id,wfname);
113: WF_ENGINE.SetItemAttrNumber(wftype, l_batch_id, 'BATCH_ID', l_batch_id);
114: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'MAIL_TO', l_mail_to);
115: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'WF_ADMINISTRATOR', l_wf_admin);
116: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'PUB_SYSTEM', l_system);
117: WF_ENGINE.StartProcess(wftype, l_batch_id);
118: end if;
119: return('SUCCESS');

Line 116: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'PUB_SYSTEM', l_system);

112: WF_ENGINE.CreateProcess(wftype, l_batch_id,wfname);
113: WF_ENGINE.SetItemAttrNumber(wftype, l_batch_id, 'BATCH_ID', l_batch_id);
114: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'MAIL_TO', l_mail_to);
115: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'WF_ADMINISTRATOR', l_wf_admin);
116: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'PUB_SYSTEM', l_system);
117: WF_ENGINE.StartProcess(wftype, l_batch_id);
118: end if;
119: return('SUCCESS');
120: EXCEPTION

Line 117: WF_ENGINE.StartProcess(wftype, l_batch_id);

113: WF_ENGINE.SetItemAttrNumber(wftype, l_batch_id, 'BATCH_ID', l_batch_id);
114: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'MAIL_TO', l_mail_to);
115: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'WF_ADMINISTRATOR', l_wf_admin);
116: WF_ENGINE.SetItemAttrText(wftype, l_batch_id, 'PUB_SYSTEM', l_system);
117: WF_ENGINE.StartProcess(wftype, l_batch_id);
118: end if;
119: return('SUCCESS');
120: EXCEPTION
121: WHEN OTHERS THEN

Line 156: l_receiver:=wf_engine.GetItemAttrText(itemtype => itemtype

152: l_name varchar2(50);
153: l_user_name varchar2(50);
154: l_group_id number;
155: begin
156: l_receiver:=wf_engine.GetItemAttrText(itemtype => itemtype
157: ,itemkey => itemkey
158: ,aname => 'MAIL_TO');
159: /**
160: *Definition of l_receiver varias for different receiver type, the receiver can either be people or group of people

Line 165: resultout := wf_engine.eng_completed||':'||wf_no;

161: *PER: , is the login user name of the application
162: *HZ_GROUP:, is the name of the user group
163: */
164: if l_receiver=null then
165: resultout := wf_engine.eng_completed||':'||wf_no;
166: return;
167: end if;
168:
169: select instr(l_receiver,':',1) INTO l_sep_index from dual;

Line 173: resultout := wf_engine.eng_completed||':'||wf_no;

169: select instr(l_receiver,':',1) INTO l_sep_index from dual;
170:
171: if l_sep_index =0 then
172: --If the seperator does not exist, it mean that no receiver type is specified ,that is incorrect
173: resultout := wf_engine.eng_completed||':'||wf_no;
174: return;
175: else
176: l_receiver:=CONVERT_PERFORMER(l_receiver);
177: end if;

Line 180: wf_engine.SetItemAttrText(itemtype => itemtype

176: l_receiver:=CONVERT_PERFORMER(l_receiver);
177: end if;
178:
179: if l_receiver IS NOT NULL then
180: wf_engine.SetItemAttrText(itemtype => itemtype
181: ,itemkey => itemkey
182: ,aname => 'MAIL_TO'
183: ,avalue =>l_receiver);
184:

Line 185: resultout := wf_engine.eng_completed||':'||wf_yes;

181: ,itemkey => itemkey
182: ,aname => 'MAIL_TO'
183: ,avalue =>l_receiver);
184:
185: resultout := wf_engine.eng_completed||':'||wf_yes;
186: else
187: resultout := wf_engine.eng_completed||':'||wf_no;
188: end if;
189: return;

Line 187: resultout := wf_engine.eng_completed||':'||wf_no;

183: ,avalue =>l_receiver);
184:
185: resultout := wf_engine.eng_completed||':'||wf_yes;
186: else
187: resultout := wf_engine.eng_completed||':'||wf_no;
188: end if;
189: return;
190:
191: Exception

Line 290: l_batch_id:=wf_engine.GetItemAttrNumber(itemtype => itemtype

286: l_message varchar2(200);
287: l_icc_name varchar2(100);
288: l_sys_status varchar2(10);
289: BEGIN
290: l_batch_id:=wf_engine.GetItemAttrNumber(itemtype => itemtype
291: ,itemkey => itemkey
292: ,aname => 'BATCH_ID');
293: l_pub_system:=wf_engine.GetItemAttrText(itemtype => itemtype
294: ,itemkey => itemkey

Line 293: l_pub_system:=wf_engine.GetItemAttrText(itemtype => itemtype

289: BEGIN
290: l_batch_id:=wf_engine.GetItemAttrNumber(itemtype => itemtype
291: ,itemkey => itemkey
292: ,aname => 'BATCH_ID');
293: l_pub_system:=wf_engine.GetItemAttrText(itemtype => itemtype
294: ,itemkey => itemkey
295: ,aname => 'PUB_SYSTEM');
296: l_sys_status:=wf_engine.GetItemAttrText(itemtype => itemtype
297: ,itemkey => itemkey

Line 296: l_sys_status:=wf_engine.GetItemAttrText(itemtype => itemtype

292: ,aname => 'BATCH_ID');
293: l_pub_system:=wf_engine.GetItemAttrText(itemtype => itemtype
294: ,itemkey => itemkey
295: ,aname => 'PUB_SYSTEM');
296: l_sys_status:=wf_engine.GetItemAttrText(itemtype => itemtype
297: ,itemkey => itemkey
298: ,aname => 'SYSTEM_STATUS');
299: if l_sys_status = 'S' then
300: l_message:='Email notification has been successfully sent.';

Line 311: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

307: message =l_message
308: where batch_id=l_batch_id
309: and system_code=l_pub_system;
310:
311: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
312: return;
313:
314: exception
315: when others then