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.GMI_WF_ITEM_ACTIVATION dependencies on WF_ENGINE

Line 60: wf_engine.createprocess (itemtype => l_itemtype,

56: RAISE;
57: END;
58: BEGIN
59: /* create the process */
60: wf_engine.createprocess (itemtype => l_itemtype,
61: itemkey => l_itemkey,
62: process => l_WorkflowProcess);
63: EXCEPTION
64: WHEN DUP_VAL_ON_INDEX THEN

Line 100: wf_engine.setitemattrnumber (itemtype => l_itemtype,

96:
97:
98:
99: /* set the item attributes */
100: wf_engine.setitemattrnumber (itemtype => l_itemtype,
101: itemkey => l_itemkey, aname => 'ITEM_ID',
102: avalue => p_item_id);
103:
104: wf_engine.setitemattrtext(itemtype => l_itemtype,

Line 104: wf_engine.setitemattrtext(itemtype => l_itemtype,

100: wf_engine.setitemattrnumber (itemtype => l_itemtype,
101: itemkey => l_itemkey, aname => 'ITEM_ID',
102: avalue => p_item_id);
103:
104: wf_engine.setitemattrtext(itemtype => l_itemtype,
105: itemkey => l_itemkey, aname => 'ITEM_NO',
106: avalue => p_item_no);
107:
108: wf_engine.setitemattrtext(itemtype => l_itemtype,

Line 108: wf_engine.setitemattrtext(itemtype => l_itemtype,

104: wf_engine.setitemattrtext(itemtype => l_itemtype,
105: itemkey => l_itemkey, aname => 'ITEM_NO',
106: avalue => p_item_no);
107:
108: wf_engine.setitemattrtext(itemtype => l_itemtype,
109: itemkey => l_itemkey, aname => 'ITEM_UM',
110: avalue => p_item_um);
111:
112: wf_engine.setitemattrtext(itemtype => l_itemtype,

Line 112: wf_engine.setitemattrtext(itemtype => l_itemtype,

108: wf_engine.setitemattrtext(itemtype => l_itemtype,
109: itemkey => l_itemkey, aname => 'ITEM_UM',
110: avalue => p_item_um);
111:
112: wf_engine.setitemattrtext(itemtype => l_itemtype,
113: itemkey => l_itemkey, aname => 'ITEM_DESC1',
114: avalue => p_item_desc1);
115:
116: wf_engine.setitemattrtext(itemtype => l_itemtype,

Line 116: wf_engine.setitemattrtext(itemtype => l_itemtype,

112: wf_engine.setitemattrtext(itemtype => l_itemtype,
113: itemkey => l_itemkey, aname => 'ITEM_DESC1',
114: avalue => p_item_desc1);
115:
116: wf_engine.setitemattrtext(itemtype => l_itemtype,
117: itemkey => l_itemkey, aname => 'REQNAME',
118: avalue => l_name);
119:
120: wf_engine.setitemattrtext(itemtype => l_itemtype,

Line 120: wf_engine.setitemattrtext(itemtype => l_itemtype,

116: wf_engine.setitemattrtext(itemtype => l_itemtype,
117: itemkey => l_itemkey, aname => 'REQNAME',
118: avalue => l_name);
119:
120: wf_engine.setitemattrtext(itemtype => l_itemtype,
121: itemkey => l_itemkey,
122: aname => 'REQDISP',
123: avalue => l_display_name);
124:

Line 125: wf_engine.startprocess (itemtype => l_itemtype,

121: itemkey => l_itemkey,
122: aname => 'REQDISP',
123: avalue => l_display_name);
124:
125: wf_engine.startprocess (itemtype => l_itemtype,
126: itemkey =>l_itemkey);
127:
128: /* the inactive_ind on the inventory item */
129: /* is set in the trigger, not here! */

Line 158: wf_engine.getitemattrtext (p_itemtype, p_itemkey,

154: p_result out nocopy varchar2
155: )
156: is
157: l_item_no varchar2(32) :=
158: wf_engine.getitemattrtext (p_itemtype, p_itemkey,
159: 'ITEM_NO');
160: l_requestor_name varchar2(100) :=
161: wf_engine.getitemattrtext (p_itemtype, p_itemkey,
162: 'REQNAME');

Line 161: wf_engine.getitemattrtext (p_itemtype, p_itemkey,

157: l_item_no varchar2(32) :=
158: wf_engine.getitemattrtext (p_itemtype, p_itemkey,
159: 'ITEM_NO');
160: l_requestor_name varchar2(100) :=
161: wf_engine.getitemattrtext (p_itemtype, p_itemkey,
162: 'REQNAME');
163: l_requestor_display_name varchar2(100) :=
164: wf_engine.getitemattrtext (p_itemtype, p_itemkey,
165: 'REQDISP');

Line 164: wf_engine.getitemattrtext (p_itemtype, p_itemkey,

160: l_requestor_name varchar2(100) :=
161: wf_engine.getitemattrtext (p_itemtype, p_itemkey,
162: 'REQNAME');
163: l_requestor_display_name varchar2(100) :=
164: wf_engine.getitemattrtext (p_itemtype, p_itemkey,
165: 'REQDISP');
166: l_approver_name varchar2(100);
167: l_approver_display_name varchar2(100);
168:

Line 213: wf_engine.setitemattrtext(itemtype => p_itemtype,

209: Select ITEM_DESC1 into l_item_desc
210: from IC_ITEM_MST
211: where ITEM_NO=l_ITEM_NO;
212:
213: wf_engine.setitemattrtext(itemtype => p_itemtype,
214: itemkey => p_itemkey, aname => 'ITEM_DESC1',
215: avalue => l_item_desc);
216:
217: wf_engine.setitemattrtext (itemtype => p_itemtype,

Line 217: wf_engine.setitemattrtext (itemtype => p_itemtype,

213: wf_engine.setitemattrtext(itemtype => p_itemtype,
214: itemkey => p_itemkey, aname => 'ITEM_DESC1',
215: avalue => l_item_desc);
216:
217: wf_engine.setitemattrtext (itemtype => p_itemtype,
218: itemkey => p_itemkey,
219: aname => 'APPNM',
220: avalue => l_approver_name);
221:

Line 222: wf_engine.setitemattrtext (itemtype => p_itemtype,

218: itemkey => p_itemkey,
219: aname => 'APPNM',
220: avalue => l_approver_name);
221:
222: wf_engine.setitemattrtext (itemtype => p_itemtype,
223: itemkey => p_itemkey,
224: aname => '#FROM_ROLE',
225: avalue => l_approver_name);
226:

Line 227: wf_engine.setitemattrtext (itemtype => p_itemtype,

223: itemkey => p_itemkey,
224: aname => '#FROM_ROLE',
225: avalue => l_approver_name);
226:
227: wf_engine.setitemattrtext (itemtype => p_itemtype,
228: itemkey => p_itemkey,
229: aname => 'APPDISP',
230: avalue => l_approver_display_name);
231: p_result := 'COMPLETE:FOUND';

Line 245: wf_engine.setitemattrtext (p_itemtype,

241: end if;
242:
243: exception
244: when selection_cancelled then
245: wf_engine.setitemattrtext (p_itemtype,
246: p_itemkey, 'ERRMSG',
247: 'The workflow approver selection process was cancelled for item ' ||
248: l_item_no || '.');
249: p_result := 'COMPLETE:SELERR';

Line 252: wf_engine.setitemattrtext (p_itemtype,

248: l_item_no || '.');
249: p_result := 'COMPLETE:SELERR';
250: return;
251: when selection_timeout then
252: wf_engine.setitemattrtext (p_itemtype,
253: p_itemkey, 'ERRMSG',
254: 'The workflow approver selection process timed out for item ' ||
255: l_item_no || '.');
256: p_result := 'COMPLETE:SELERR';

Line 270: wf_engine.setitemattrtext (itemtype => p_itemtype,

266: select display_name into l_approver_display_name
267: from wf_roles where name =l_approver_name;
268:
269:
270: wf_engine.setitemattrtext (itemtype => p_itemtype,
271: itemkey => p_itemkey,
272: aname => 'APPNM',
273: avalue => l_approver_name);
274:

Line 275: wf_engine.setitemattrtext (itemtype => p_itemtype,

271: itemkey => p_itemkey,
272: aname => 'APPNM',
273: avalue => l_approver_name);
274:
275: wf_engine.setitemattrtext (itemtype => p_itemtype,
276: itemkey => p_itemkey,
277: aname => 'APPDISP',
278: avalue => l_approver_display_name);
279: p_result := 'COMPLETE:FOUND';

Line 296: wf_engine.setitemattrtext (p_itemtype,

292: then
293: l_errname := to_char(sqlcode);
294: l_errmsg := sqlerrm(-sqlcode);
295: end if;
296: wf_engine.setitemattrtext (p_itemtype,
297: p_itemkey, 'ERRMSG',
298: 'A database error occurred in ' ||
299: 'the workflow approver selection ' ||
300: 'process for item ' || l_item_no ||

Line 316: wf_engine.getitemattrnumber (p_itemtype, p_itemkey,

312: p_result out nocopy varchar2
313: )
314: is
315: l_item_id number :=
316: wf_engine.getitemattrnumber (p_itemtype, p_itemkey,
317: 'ITEM_ID');
318: l_item_no varchar2(32) :=
319: wf_engine.getitemattrtext (p_itemtype, p_itemkey,
320: 'ITEM_NO');

Line 319: wf_engine.getitemattrtext (p_itemtype, p_itemkey,

315: l_item_id number :=
316: wf_engine.getitemattrnumber (p_itemtype, p_itemkey,
317: 'ITEM_ID');
318: l_item_no varchar2(32) :=
319: wf_engine.getitemattrtext (p_itemtype, p_itemkey,
320: 'ITEM_NO');
321: l_sqlcode number;
322: l_sqlerrm varchar2(512);
323: l_errname varchar2(30);

Line 358: wf_engine.setitemattrtext (p_itemtype,

354: end if;
355:
356: exception
357: when activate_cancelled then
358: wf_engine.setitemattrtext (p_itemtype,
359: p_itemkey, 'ERRMSG',
360: 'The workflow item activation process was cancelled for item '||
361: l_item_no || '.');
362: p_result := 'ERROR:';

Line 365: wf_engine.setitemattrtext (p_itemtype,

361: l_item_no || '.');
362: p_result := 'ERROR:';
363: return;
364: when activate_timeout then
365: wf_engine.setitemattrtext (p_itemtype,
366: p_itemkey, 'ERRMSG',
367: 'The workflow item activation process timed out for item ' ||
368: l_item_no || '.');
369: p_result := 'ERROR:';

Line 377: wf_engine.setitemattrtext (p_itemtype,

373: return;
374: when others then
375: l_sqlcode := sqlcode;
376: l_sqlerrm := sqlerrm (-l_sqlcode);
377: wf_engine.setitemattrtext (p_itemtype,
378: p_itemkey, 'ERRMSG',
379: 'A database error occurred in ' ||
380: 'the workflow item activation ' ||
381: 'process for item ' || l_item_no ||