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_LOT_EXPIRY dependencies on WF_ENGINE

Line 28: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;

24: l_default_expiry_interval NUMBER(3) :=7;
25: /* make sure that process runs with background engine
26: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
27: the 'magic value' to use for this is -1 */
28: l_run_wf_in_background CONSTANT WF_ENGINE.THRESHOLD%TYPE := -1;
29:
30: l_expire_notify_date DATE ;
31: l_wf_start_date DATE ;
32:

Line 98: wf_engine.abortprocess (itemtype=> l_itemtype, itemkey=> l_itemkey, process=> l_workflowprocess);

94: /* Check the status of the root activity */
95: wf_item_activity_status.root_status (l_itemtype, l_itemkey, l_status, l_result);
96: /* If it is not completed then abort the process */
97: IF (l_status <> 'COMPLETE')THEN
98: wf_engine.abortprocess (itemtype=> l_itemtype, itemkey=> l_itemkey, process=> l_workflowprocess);
99: END IF;
100: /* Purge the workflow data for workflow key */
101: wf_purge.total (itemtype=> l_itemtype, itemkey=> l_itemkey, docommit=> FALSE);
102: END IF;

Line 112: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype, itemkey => l_itemkey, process => l_WorkflowProcess) ;

108: /*END BUG#2134597*/
109:
110: BEGIN
111: /* create the process */
112: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype, itemkey => l_itemkey, process => l_WorkflowProcess) ;
113: EXCEPTION
114: WHEN DUP_VAL_ON_INDEX THEN
115: RAISE wf_item_already_exists ;
116: END ;

Line 119: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

115: RAISE wf_item_already_exists ;
116: END ;
117:
118: /* make sure that process runs with background engine */
119: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
120:
121: /* set the item attributes */
122: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,
123: itemkey => l_itemkey,

Line 122: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,

118: /* make sure that process runs with background engine */
119: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
120:
121: /* set the item attributes */
122: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,
123: itemkey => l_itemkey,
124: aname => 'LOT_ID',
125: avalue => p_lot_id);
126:

Line 127: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

123: itemkey => l_itemkey,
124: aname => 'LOT_ID',
125: avalue => p_lot_id);
126:
127: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
128: itemkey => l_itemkey,
129: aname => 'LOT_NO',
130: avalue => p_lot_no);
131:

Line 132: WF_ENGINE.SETITEMATTRTEXT (itemtype => l_itemtype,

128: itemkey => l_itemkey,
129: aname => 'LOT_NO',
130: avalue => p_lot_no);
131:
132: WF_ENGINE.SETITEMATTRTEXT (itemtype => l_itemtype,
133: itemkey => l_itemkey,
134: aname => 'SUBLOT_NO',
135: avalue => p_sublot_no);
136:

Line 137: WF_ENGINE.SETITEMATTRDATE (itemtype => l_itemtype,

133: itemkey => l_itemkey,
134: aname => 'SUBLOT_NO',
135: avalue => p_sublot_no);
136:
137: WF_ENGINE.SETITEMATTRDATE (itemtype => l_itemtype,
138: itemkey => l_itemkey,
139: aname => 'EXPIRE_DATE',
140: avalue => p_expire_date);
141:

Line 175: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

171: END LOOP;
172: END IF;
173: close c_item_role;
174: IF l_role_name is NULL THEN
175: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
176: itemkey => l_itemkey,
177: aname => 'PERNAME',
178: avalue => l_performer_name);
179: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

Line 179: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

175: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
176: itemkey => l_itemkey,
177: aname => 'PERNAME',
178: avalue => l_performer_name);
179: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
180: itemkey => l_itemkey,
181: aname => 'PERDISP',
182: avalue => l_performer_display_name);
183:

Line 185: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

181: aname => 'PERDISP',
182: avalue => l_performer_display_name);
183:
184: /*Added FROM_ROLE attribute for BLAF standard */
185: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
186: itemkey => l_itemkey,
187: aname => '#FROM_ROLE',
188: avalue => l_performer_name) ;
189: ELSE

Line 190: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

186: itemkey => l_itemkey,
187: aname => '#FROM_ROLE',
188: avalue => l_performer_name) ;
189: ELSE
190: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
191: itemkey => l_itemkey,
192: aname => 'PERNAME',
193: avalue => l_role_name) ;
194:

Line 195: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

191: itemkey => l_itemkey,
192: aname => 'PERNAME',
193: avalue => l_role_name) ;
194:
195: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
196: itemkey => l_itemkey,
197: aname => 'PERDISP',
198: avalue => l_role_display_name) ;
199:

Line 201: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

197: aname => 'PERDISP',
198: avalue => l_role_display_name) ;
199:
200: /*Added FROM_ROLE attribute for BLAF standard */
201: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
202: itemkey => l_itemkey,
203: aname => '#FROM_ROLE',
204: avalue => l_role_name) ;
205: END IF;

Line 207: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

203: aname => '#FROM_ROLE',
204: avalue => l_role_name) ;
205: END IF;
206:
207: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
208: itemkey => l_itemkey,
209: aname => 'ITEM_NO',
210: avalue => l_item_no);
211:

Line 212: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

208: itemkey => l_itemkey,
209: aname => 'ITEM_NO',
210: avalue => l_item_no);
211:
212: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
213: itemkey => l_itemkey,
214: aname => 'ITEM_DESC1',
215: avalue => l_item_desc1);
216:

Line 217: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

213: itemkey => l_itemkey,
214: aname => 'ITEM_DESC1',
215: avalue => l_item_desc1);
216:
217: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
218: itemkey => l_itemkey,
219: aname => 'ITEM_UM',
220: avalue => l_item_um);
221:

Line 222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,

218: itemkey => l_itemkey,
219: aname => 'ITEM_UM',
220: avalue => l_item_um);
221:
222: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
223: itemkey => l_itemkey,
224: aname => 'ITEM_UM2',
225: avalue => l_item_um2);
226:

Line 227: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,

223: itemkey => l_itemkey,
224: aname => 'ITEM_UM2',
225: avalue => l_item_um2);
226:
227: WF_ENGINE.SETITEMATTRNUMBER(itemtype => l_itemtype,
228: itemkey => l_itemkey,
229: aname => 'DUALUM_IND',
230: avalue => l_dualum_ind);
231:

Line 232: WF_ENGINE.SETITEMATTRDATE(itemtype => l_itemtype,

228: itemkey => l_itemkey,
229: aname => 'DUALUM_IND',
230: avalue => l_dualum_ind);
231:
232: WF_ENGINE.SETITEMATTRDATE(itemtype => l_itemtype,
233: itemkey => l_itemkey,
234: aname => 'WF_START_DATE',
235: avalue => l_wf_start_date) ;
236:

Line 259: WF_ENGINE.SETITEMATTRDATE (itemtype => l_itemtype,

255: IF (l_expire_notify_date < l_wf_start_date) THEN
256: l_expire_notify_date := l_wf_start_date ;
257: END IF ;
258:
259: WF_ENGINE.SETITEMATTRDATE (itemtype => l_itemtype,
260: itemkey => l_itemkey,
261: aname => 'EXPIRE_NOTIFY_DATE',
262: avalue => l_expire_notify_date);
263:

Line 264: WF_ENGINE.SETITEMATTRDATE (itemtype => l_itemtype,

260: itemkey => l_itemkey,
261: aname => 'EXPIRE_NOTIFY_DATE',
262: avalue => l_expire_notify_date);
263:
264: WF_ENGINE.SETITEMATTRDATE (itemtype => l_itemtype,
265: itemkey => l_itemkey,
266: aname => 'EXPIRE_NOTIFY_TIME',
267: avalue => l_expire_notify_date ) ;
268:

Line 271: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,

267: avalue => l_expire_notify_date ) ;
268:
269: /* start the Workflow process */
270:
271: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,
272: itemkey => l_itemkey);
273:
274: EXCEPTION
275:

Line 351: WF_ENGINE.SETITEMATTRNUMBER (itemtype => p_itemtype,

347: p_resultout := 'COMPLETE:INVEXIST';
348: END IF ;
349:
350: /* save inventory quantities in WF item attributes */
351: WF_ENGINE.SETITEMATTRNUMBER (itemtype => p_itemtype,
352: itemkey => p_itemkey,
353: aname => 'QUANTITY',
354: avalue => l_sum_loct_onhand) ;
355: WF_ENGINE.SETITEMATTRNUMBER (itemtype => p_itemtype,

Line 355: WF_ENGINE.SETITEMATTRNUMBER (itemtype => p_itemtype,

351: WF_ENGINE.SETITEMATTRNUMBER (itemtype => p_itemtype,
352: itemkey => p_itemkey,
353: aname => 'QUANTITY',
354: avalue => l_sum_loct_onhand) ;
355: WF_ENGINE.SETITEMATTRNUMBER (itemtype => p_itemtype,
356: itemkey => p_itemkey,
357: aname => 'QUANTITY2',
358: avalue => l_sum_loct_onhand2) ;
359:

Line 369: WF_ENGINE.SETITEMATTRTEXT (itemtype => p_itemtype,

365: ELSIF (p_funcmode = 'TIMEOUT') THEN
366: p_resultout := 'COMPLETE' ;
367:
368: ELSE
369: WF_ENGINE.SETITEMATTRTEXT (itemtype => p_itemtype,
370: itemkey => p_itemkey,
371: aname => 'ERRMSG',
372: avalue => 'Bad p_funcmode passed to ' ||
373: 'the workflow lot expiry ' ||

Line 386: l_lot_no := WF_ENGINE.GETITEMATTRTEXT (p_itemtype,

382: WHEN OTHERS THEN
383:
384: l_sqlcode := SQLCODE;
385: l_sqlerrm := SQLERRM(-l_sqlcode);
386: l_lot_no := WF_ENGINE.GETITEMATTRTEXT (p_itemtype,
387: p_itemkey,
388: 'LOT_NO');
389:
390: l_sublot_no := WF_ENGINE.GETITEMATTRTEXT (p_itemtype,

Line 390: l_sublot_no := WF_ENGINE.GETITEMATTRTEXT (p_itemtype,

386: l_lot_no := WF_ENGINE.GETITEMATTRTEXT (p_itemtype,
387: p_itemkey,
388: 'LOT_NO');
389:
390: l_sublot_no := WF_ENGINE.GETITEMATTRTEXT (p_itemtype,
391: p_itemkey,
392: 'SUBLOT_NO');
393:
394: WF_ENGINE.SETITEMATTRTEXT (itemtype => p_itemtype,

Line 394: WF_ENGINE.SETITEMATTRTEXT (itemtype => p_itemtype,

390: l_sublot_no := WF_ENGINE.GETITEMATTRTEXT (p_itemtype,
391: p_itemkey,
392: 'SUBLOT_NO');
393:
394: WF_ENGINE.SETITEMATTRTEXT (itemtype => p_itemtype,
395: itemkey => p_itemkey,
396: aname => 'ERRMSG',
397: avalue => 'A database error occurred in ' ||
398: 'the workflow lot expiry ' ||