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

Line 25: -- wf_engine.threshold := -1;

21: Begin
22:
23: /* To Defer the process from the start */
24:
25: -- wf_engine.threshold := -1;
26:
27:
28: /* To check weather the current item already exist for approval */
29:

Line 102: wf_engine.createprocess( itemtype => l_ItemType,

98: FND_MESSAGE.SET_TOKEN('ENTITY','Approval Process');
99: FND_MSG_PUB.Add;
100: else
101: --Inv_debug.message(' creating the process');
102: wf_engine.createprocess( itemtype => l_ItemType,
103: itemkey => l_ItemKey,
104: process => l_process_int_name );
105: --Inv_debug.message(' created the process');
106:

Line 121: wf_engine.SetItemOwner( itemtype => l_ItemType,

117: p_orig_system_id => l_requestor_id,
118: p_name => x_requestor_username,
119: p_display_name => x_requestor_disp_name);
120:
121: wf_engine.SetItemOwner( itemtype => l_ItemType,
122: itemkey => l_ItemKey,
123: owner => l_requestor_name );
124:
125: --inv_debug.message('Starting to set attributes' );

Line 127: wf_engine.setitemattrNumber( itemtype => l_ItemType,

123: owner => l_requestor_name );
124:
125: --inv_debug.message('Starting to set attributes' );
126:
127: wf_engine.setitemattrNumber( itemtype => l_ItemType,
128: itemkey => l_ItemKey,
129: aname => 'TO_HEADER_ID',
130: avalue => To_Header_Id );
131: wf_engine.setitemattrNumber( itemtype => l_ItemType,

Line 131: wf_engine.setitemattrNumber( itemtype => l_ItemType,

127: wf_engine.setitemattrNumber( itemtype => l_ItemType,
128: itemkey => l_ItemKey,
129: aname => 'TO_HEADER_ID',
130: avalue => To_Header_Id );
131: wf_engine.setitemattrNumber( itemtype => l_ItemType,
132: itemkey => l_ItemKey,
133: aname => 'ORG_ID',
134: avalue => l_trohdr_rec.organization_id );
135:

Line 137: wf_engine.setitemattrtext( itemtype => l_ItemType,

133: aname => 'ORG_ID',
134: avalue => l_trohdr_rec.organization_id );
135:
136:
137: wf_engine.setitemattrtext( itemtype => l_ItemType,
138: itemkey => l_ItemKey,
139: aname => 'REQUESTOR_USERNAME',
140: avalue => x_requestor_username );
141:

Line 142: wf_engine.setitemattrtext( itemtype => l_ItemType,

138: itemkey => l_ItemKey,
139: aname => 'REQUESTOR_USERNAME',
140: avalue => x_requestor_username );
141:
142: wf_engine.setitemattrtext( itemtype => l_ItemType,
143: itemkey => l_ItemKey,
144: aname => 'REQUESTOR_DISPLAY_NAME',
145: avalue => x_requestor_disp_name );
146:

Line 147: wf_engine.setitemattrNumber( itemtype => l_ItemType,

143: itemkey => l_ItemKey,
144: aname => 'REQUESTOR_DISPLAY_NAME',
145: avalue => x_requestor_disp_name );
146:
147: wf_engine.setitemattrNumber( itemtype => l_ItemType,
148: itemkey => l_ItemKey,
149: aname => 'REQUESTOR_ID',
150: avalue => l_requestor_id );
151:

Line 152: wf_engine.setitemattrtext( itemtype => l_ItemType,

148: itemkey => l_ItemKey,
149: aname => 'REQUESTOR_ID',
150: avalue => l_requestor_id );
151:
152: wf_engine.setitemattrtext( itemtype => l_ItemType,
153: itemkey => l_ItemKey,
154: aname => 'FORWARD_FROM_USERNAME',
155: avalue => x_requestor_username );
156:

Line 157: wf_engine.setitemattrtext( itemtype => l_ItemType,

153: itemkey => l_ItemKey,
154: aname => 'FORWARD_FROM_USERNAME',
155: avalue => x_requestor_username );
156:
157: wf_engine.setitemattrtext( itemtype => l_ItemType,
158: itemkey => l_ItemKey,
159: aname => 'FORWARD_FROM_DISPLAY_NAME',
160: avalue => x_requestor_disp_name );
161:

Line 162: wf_engine.setitemattrNumber( itemtype => l_ItemType,

158: itemkey => l_ItemKey,
159: aname => 'FORWARD_FROM_DISPLAY_NAME',
160: avalue => x_requestor_disp_name );
161:
162: wf_engine.setitemattrNumber( itemtype => l_ItemType,
163: itemkey => l_ItemKey,
164: aname => 'FORWARD_FROM_ID',
165: avalue => l_requestor_id );
166:

Line 174: wf_engine.startprocess( itemtype => l_ItemType,

170: --inv_debug.message('Itemkey='||l_Itemkey );
171:
172: --Inv_Debug.Message('Starting the process' );
173:
174: wf_engine.startprocess( itemtype => l_ItemType,
175: itemkey => l_ItemKey );
176:
177: --inv_debug.message('Started the process' );
178: FND_MESSAGE.SET_NAME('INV','INV_APPROVAL_LAUNCHED');

Line 209: p_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

205: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
206: Begin
207: if (funcmode = 'RUN') then
208:
209: p_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
210: itemkey => itemkey,
211: aname => 'TO_HEADER_ID');
212: l_trohdr_rec := INV_Trohdr_Util.Query_row( p_header_id );
213:

Line 218: wf_engine.setitemattrtext( itemtype => itemtype,

214: if ( l_trohdr_rec.header_status IN
215: ( INV_Globals.G_TO_STATUS_PENDING_APPROVAL,
216: INV_Globals.G_TO_STATUS_APPROVED ) ) then
217:
218: wf_engine.setitemattrtext( itemtype => itemtype,
219: itemkey => itemkey,
220: aname => 'TO_NUMBER',
221: avalue => l_trohdr_rec.request_number );
222:

Line 223: wf_engine.setitemattrtext( itemtype => itemtype,

219: itemkey => itemkey,
220: aname => 'TO_NUMBER',
221: avalue => l_trohdr_rec.request_number );
222:
223: wf_engine.setitemattrtext( itemtype => itemtype,
224: itemkey => itemkey,
225: aname => 'TO_DESCRIPTION',
226: avalue => l_trohdr_rec.description );
227:

Line 228: wf_engine.setitemattrdate( itemtype => itemtype,

224: itemkey => itemkey,
225: aname => 'TO_DESCRIPTION',
226: avalue => l_trohdr_rec.description );
227:
228: wf_engine.setitemattrdate( itemtype => itemtype,
229: itemkey => itemkey,
230: aname => 'DATE_REQUIRED',
231: avalue => l_trohdr_rec.date_required );
232:

Line 280: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

276: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
277: Begin
278: if (funcmode = 'RUN') then
279:
280: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
281: itemkey => itemkey,
282: aname => 'TO_HEADER_ID');
283:
284: l_to_number := wf_engine.GetItemAttrtext( itemtype => itemtype,

Line 284: l_to_number := wf_engine.GetItemAttrtext( itemtype => itemtype,

280: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
281: itemkey => itemkey,
282: aname => 'TO_HEADER_ID');
283:
284: l_to_number := wf_engine.GetItemAttrtext( itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'TO_NUMBER');
287:
288: l_to_desc := wf_engine.GetItemAttrtext( itemtype => itemtype,

Line 288: l_to_desc := wf_engine.GetItemAttrtext( itemtype => itemtype,

284: l_to_number := wf_engine.GetItemAttrtext( itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'TO_NUMBER');
287:
288: l_to_desc := wf_engine.GetItemAttrtext( itemtype => itemtype,
289: itemkey => itemkey,
290: aname => 'TO_DESCRIPTION');
291:
292: l_requestor_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 292: l_requestor_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

288: l_to_desc := wf_engine.GetItemAttrtext( itemtype => itemtype,
289: itemkey => itemkey,
290: aname => 'TO_DESCRIPTION');
291:
292: l_requestor_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
293: itemkey => itemkey,
294: aname => 'REQUESTOR_ID');
295:
296: l_requestor_username := wf_engine.GetItemAttrtext( itemtype => itemtype,

Line 296: l_requestor_username := wf_engine.GetItemAttrtext( itemtype => itemtype,

292: l_requestor_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
293: itemkey => itemkey,
294: aname => 'REQUESTOR_ID');
295:
296: l_requestor_username := wf_engine.GetItemAttrtext( itemtype => itemtype,
297: itemkey => itemkey,
298: aname => 'REQUESTOR_USERNAME');
299:
300: l_requestor_disp_name := wf_engine.GetItemAttrtext( itemtype => itemtype,

Line 300: l_requestor_disp_name := wf_engine.GetItemAttrtext( itemtype => itemtype,

296: l_requestor_username := wf_engine.GetItemAttrtext( itemtype => itemtype,
297: itemkey => itemkey,
298: aname => 'REQUESTOR_USERNAME');
299:
300: l_requestor_disp_name := wf_engine.GetItemAttrtext( itemtype => itemtype,
301: itemkey => itemkey,
302: aname => 'REQUESTOR_DISPLAY_NAME');
303:
304:

Line 317: wf_engine.createprocess( itemtype => l_child_itemtype,

313:
314: l_child_itemkey := to_char(l_header_id)||'-'||
315: to_char(l_trolin_tbl(l_line_count).line_id);
316:
317: wf_engine.createprocess( itemtype => l_child_itemtype,
318: itemkey => l_child_itemkey,
319: process => 'TO_LINE_APPROVE');
320:
321: wf_engine.SetItemOwner( itemtype => l_child_itemtype,

Line 321: wf_engine.SetItemOwner( itemtype => l_child_itemtype,

317: wf_engine.createprocess( itemtype => l_child_itemtype,
318: itemkey => l_child_itemkey,
319: process => 'TO_LINE_APPROVE');
320:
321: wf_engine.SetItemOwner( itemtype => l_child_itemtype,
322: itemkey => l_child_itemkey,
323: owner => l_requestor_username );
324:
325: /* Set the item attributes here */

Line 327: wf_engine.setitemattrtext( itemtype => l_child_itemtype,

323: owner => l_requestor_username );
324:
325: /* Set the item attributes here */
326:
327: wf_engine.setitemattrtext( itemtype => l_child_itemtype,
328: itemkey => l_child_itemkey,
329: aname => 'TO_NUMBER',
330: avalue => l_to_number );
331:

Line 332: wf_engine.setitemattrtext( itemtype => l_child_itemtype,

328: itemkey => l_child_itemkey,
329: aname => 'TO_NUMBER',
330: avalue => l_to_number );
331:
332: wf_engine.setitemattrtext( itemtype => l_child_itemtype,
333: itemkey => l_child_itemkey,
334: aname => 'TO_HEADER_ID',
335: avalue => l_header_id );
336:

Line 337: wf_engine.setitemattrtext( itemtype => l_child_itemtype,

333: itemkey => l_child_itemkey,
334: aname => 'TO_HEADER_ID',
335: avalue => l_header_id );
336:
337: wf_engine.setitemattrtext( itemtype => l_child_itemtype,
338: itemkey => l_child_itemkey,
339: aname => 'TO_DESCRIPTION',
340: avalue => l_to_desc );
341:

Line 342: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,

338: itemkey => l_child_itemkey,
339: aname => 'TO_DESCRIPTION',
340: avalue => l_to_desc );
341:
342: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,
343: itemkey => l_child_itemkey,
344: aname => 'LINE_NUMBER',
345: avalue => l_trolin_tbl(l_line_count).line_number );
346:

Line 347: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,

343: itemkey => l_child_itemkey,
344: aname => 'LINE_NUMBER',
345: avalue => l_trolin_tbl(l_line_count).line_number );
346:
347: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,
348: itemkey => l_child_itemkey,
349: aname => 'LINE_QUANTITY',
350: avalue => l_trolin_tbl(l_line_count).quantity );
351:

Line 353: wf_engine.setitemattrNumber( itemtype => itemtype,

349: aname => 'LINE_QUANTITY',
350: avalue => l_trolin_tbl(l_line_count).quantity );
351:
352: --INVCONV
353: wf_engine.setitemattrNumber( itemtype => itemtype,
354: itemkey => l_child_itemkey,
355: aname => 'SEC_LINE_QTY',
356: avalue => l_trolin_tbl(l_line_count).secondary_quantity );
357:

Line 358: wf_engine.setitemattrtext( itemtype => itemtype,

354: itemkey => l_child_itemkey,
355: aname => 'SEC_LINE_QTY',
356: avalue => l_trolin_tbl(l_line_count).secondary_quantity );
357:
358: wf_engine.setitemattrtext( itemtype => itemtype,
359: itemkey => l_child_itemkey,
360: aname => 'SEC_UOM',
361: avalue => l_trolin_tbl(l_line_count).secondary_uom );
362: --INVCONV

Line 364: wf_engine.setitemattrtext( itemtype => l_child_itemtype,

360: aname => 'SEC_UOM',
361: avalue => l_trolin_tbl(l_line_count).secondary_uom );
362: --INVCONV
363:
364: wf_engine.setitemattrtext( itemtype => l_child_itemtype,
365: itemkey => l_child_itemkey,
366: aname => 'FROM_SUBINVENTORY',
367: avalue => l_trolin_tbl(l_line_count).from_subinventory_code );
368:

Line 372: wf_engine.setitemattrtext( itemtype => l_child_itemtype,

368:
369: from_locator_value := INV_UTILITIES.get_conc_segments(l_trolin_tbl(l_line_count).organization_id,
370: l_trolin_tbl(l_line_count).from_locator_id);
371:
372: wf_engine.setitemattrtext( itemtype => l_child_itemtype,
373: itemkey => l_child_itemkey,
374: aname => 'FROM_LOCATOR',
375: avalue => from_locator_value);
376:

Line 377: wf_engine.setitemattrtext( itemtype => l_child_itemtype,

373: itemkey => l_child_itemkey,
374: aname => 'FROM_LOCATOR',
375: avalue => from_locator_value);
376:
377: wf_engine.setitemattrtext( itemtype => l_child_itemtype,
378: itemkey => l_child_itemkey,
379: aname => 'TO_SUBINVENTORY',
380: avalue =>
381: l_trolin_tbl(l_line_count).to_subinventory_code );

Line 386: wf_engine.setitemattrtext( itemtype => l_child_itemtype,

382:
383: to_locator_value := INV_UTILITIES.get_conc_segments(l_trolin_tbl(l_line_count).organization_id,
384: l_trolin_tbl(l_line_count).to_locator_id);
385:
386: wf_engine.setitemattrtext( itemtype => l_child_itemtype,
387: itemkey => l_child_itemkey,
388: aname => 'TO_LOCATOR',
389: avalue => to_locator_value);
390:

Line 391: wf_engine.setitemattrtext( itemtype => l_child_itemtype,

387: itemkey => l_child_itemkey,
388: aname => 'TO_LOCATOR',
389: avalue => to_locator_value);
390:
391: wf_engine.setitemattrtext( itemtype => l_child_itemtype,
392: itemkey => l_child_itemkey,
393: aname => 'UOM',
394: avalue => l_trolin_tbl(l_line_count).uom_code );
395:

Line 396: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,

392: itemkey => l_child_itemkey,
393: aname => 'UOM',
394: avalue => l_trolin_tbl(l_line_count).uom_code );
395:
396: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,
397: itemkey => l_child_itemkey,
398: aname => 'LINE_ID',
399: avalue => l_trolin_tbl(l_line_count).line_id );
400:

Line 401: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,

397: itemkey => l_child_itemkey,
398: aname => 'LINE_ID',
399: avalue => l_trolin_tbl(l_line_count).line_id );
400:
401: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,
402: itemkey => l_child_itemkey,
403: aname => 'ITEM_ID',
404: avalue => l_trolin_tbl(l_line_count).inventory_item_id );
405:

Line 406: wf_engine.setitemattrdate( itemtype => l_child_itemtype,

402: itemkey => l_child_itemkey,
403: aname => 'ITEM_ID',
404: avalue => l_trolin_tbl(l_line_count).inventory_item_id );
405:
406: wf_engine.setitemattrdate( itemtype => l_child_itemtype,
407: itemkey => l_child_itemkey,
408: aname => 'DATE_REQUIRED',
409: avalue => l_trolin_tbl(l_line_count).date_required );
410:

Line 411: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,

407: itemkey => l_child_itemkey,
408: aname => 'DATE_REQUIRED',
409: avalue => l_trolin_tbl(l_line_count).date_required );
410:
411: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,
412: itemkey => l_child_itemkey,
413: aname => 'ORG_ID',
414: avalue => l_trolin_tbl(l_line_count).organization_id );
415:

Line 416: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,

412: itemkey => l_child_itemkey,
413: aname => 'ORG_ID',
414: avalue => l_trolin_tbl(l_line_count).organization_id );
415:
416: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,
417: itemkey => l_child_itemkey,
418: aname => 'REQUESTOR_ID',
419: avalue => l_requestor_id );
420:

Line 421: wf_engine.setitemattrtext( itemtype => l_child_ItemType,

417: itemkey => l_child_itemkey,
418: aname => 'REQUESTOR_ID',
419: avalue => l_requestor_id );
420:
421: wf_engine.setitemattrtext( itemtype => l_child_ItemType,
422: itemkey => l_child_ItemKey,
423: aname => 'REQUESTOR_USERNAME',
424: avalue => l_requestor_username );
425:

Line 426: wf_engine.setitemattrtext( itemtype => l_child_ItemType,

422: itemkey => l_child_ItemKey,
423: aname => 'REQUESTOR_USERNAME',
424: avalue => l_requestor_username );
425:
426: wf_engine.setitemattrtext( itemtype => l_child_ItemType,
427: itemkey => l_child_ItemKey,
428: aname => 'REQUESTOR_DISPLAY_NAME',
429: avalue => l_requestor_disp_name );
430:

Line 431: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,

427: itemkey => l_child_ItemKey,
428: aname => 'REQUESTOR_DISPLAY_NAME',
429: avalue => l_requestor_disp_name );
430:
431: wf_engine.setitemattrNumber( itemtype => l_child_itemtype,
432: itemkey => l_child_itemkey,
433: aname => 'FORWARD_FROM_ID',
434: avalue => l_requestor_id );
435:

Line 436: wf_engine.setitemattrtext( itemtype => l_child_ItemType,

432: itemkey => l_child_itemkey,
433: aname => 'FORWARD_FROM_ID',
434: avalue => l_requestor_id );
435:
436: wf_engine.setitemattrtext( itemtype => l_child_ItemType,
437: itemkey => l_child_ItemKey,
438: aname => 'FORWARD_FROM_USERNAME',
439: avalue => l_requestor_username );
440:

Line 441: wf_engine.setitemattrtext( itemtype => l_child_ItemType,

437: itemkey => l_child_ItemKey,
438: aname => 'FORWARD_FROM_USERNAME',
439: avalue => l_requestor_username );
440:
441: wf_engine.setitemattrtext( itemtype => l_child_ItemType,
442: itemkey => l_child_ItemKey,
443: aname => 'FORWARD_FROM_DISPLAY_NAME',
444: avalue => l_requestor_disp_name );
445:

Line 446: wf_engine.setitemparent( itemtype => l_child_itemtype,

442: itemkey => l_child_ItemKey,
443: aname => 'FORWARD_FROM_DISPLAY_NAME',
444: avalue => l_requestor_disp_name );
445:
446: wf_engine.setitemparent( itemtype => l_child_itemtype,
447: itemkey => l_child_itemkey,
448: parent_itemtype => itemtype,
449: parent_itemkey => itemkey,
450: parent_context => NULL );

Line 466: wf_engine.startprocess( itemtype => l_child_itemtype,

462:
463: Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id ,
464: INV_Globals.G_TO_STATUS_PENDING_APPROVAL);
465:
466: wf_engine.startprocess( itemtype => l_child_itemtype,
467: itemkey => l_child_itemkey );
468: END IF;
469: End loop;
470:

Line 509: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

505: Begin
506:
507: if ( funcmode = 'RUN') then
508:
509: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
510: itemkey => itemkey,
511: aname => 'TO_HEADER_ID');
512:
513: l_trolin_tbl := INV_trolin_util.Get_Lines( l_header_id );

Line 565: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

561: l_header_id Number;
562: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
563: Begin
564: if (funcmode = 'RUN') then
565: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
566: itemkey => itemkey,
567: aname => 'TO_HEADER_ID');
568: Inv_trohdr_Util.Update_Row_Status(l_header_id,
569: Inv_Globals.G_TO_STATUS_APPROVED);

Line 600: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

596: l_header_id Number;
597: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
598: Begin
599: if (funcmode = 'RUN') then
600: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
601: itemkey => itemkey,
602: aname => 'TO_HEADER_ID');
603: Inv_trohdr_Util.Update_Row_Status(l_header_id,
604: Inv_Globals.G_TO_STATUS_PART_APPROVED);

Line 638: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

634: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
635: Begin
636: if (funcmode = 'RUN') then
637:
638: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
639: itemkey => itemkey,
640: aname => 'TO_HEADER_ID');
641: Inv_trohdr_Util.Update_Row_Status(l_header_id,
642: Inv_Globals.G_TO_STATUS_REJECTED);

Line 684: l_item_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

680: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
681: Begin
682: if (funcmode = 'RUN') then
683:
684: l_item_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
685: itemkey => itemkey,
686: aname => 'ITEM_ID');
687: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
688: itemkey => itemkey,

Line 687: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

683:
684: l_item_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
685: itemkey => itemkey,
686: aname => 'ITEM_ID');
687: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
688: itemkey => itemkey,
689: aname => 'ORG_ID');
690:
691: /* Commented the select statement from MTL_SYSTEM_ITEMS_KFV AND

Line 710: wf_engine.setitemattrtext( itemtype => itemtype,

706: where organization_id = l_org_id and
707: inventory_item_id = l_item_id;
708:
709:
710: wf_engine.setitemattrtext( itemtype => itemtype,
711: itemkey => itemkey,
712: aname => 'ITEM_NAME',
713: avalue => l_item_name );
714:

Line 715: wf_engine.setitemattrtext( itemtype => itemtype,

711: itemkey => itemkey,
712: aname => 'ITEM_NAME',
713: avalue => l_item_name );
714:
715: wf_engine.setitemattrtext( itemtype => itemtype,
716: itemkey => itemkey,
717: aname => 'PLANNER_CODE',
718: avalue => l_planner_code );
719: --

Line 725: wf_engine.setitemattrtext( itemtype => itemtype,

721: -- Passing the value of item description to workflow engine to
722: -- print the item description in the notification sent to the
723: -- planner of the item.
724: --
725: wf_engine.setitemattrtext( itemtype => itemtype,
726: itemkey => itemkey,
727: aname => 'ITEM_DESC',
728: avalue => l_item_description );
729:

Line 777: l_requestor_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

773: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
774: Begin
775: if (funcmode = 'RUN') then
776:
777: l_requestor_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
778: itemkey => itemkey,
779: aname => 'REQUESTOR_ID');
780:
781: l_planner_code := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 781: l_planner_code := wf_engine.GetItemAttrText( itemtype => itemtype,

777: l_requestor_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
778: itemkey => itemkey,
779: aname => 'REQUESTOR_ID');
780:
781: l_planner_code := wf_engine.GetItemAttrText( itemtype => itemtype,
782: itemkey => itemkey,
783: aname => 'PLANNER_CODE');
784:
785: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 785: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

781: l_planner_code := wf_engine.GetItemAttrText( itemtype => itemtype,
782: itemkey => itemkey,
783: aname => 'PLANNER_CODE');
784:
785: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
786: itemkey => itemkey,
787: aname => 'ORG_ID');
788:
789: select employee_id

Line 795: wf_engine.setitemattrNumber( itemtype => itemtype,

791: from MTL_PLANNERS
792: where planner_code = l_planner_code and
793: organization_id = l_org_id;
794:
795: wf_engine.setitemattrNumber( itemtype => itemtype,
796: itemkey => itemkey,
797: aname => 'PLANNER_ID',
798: avalue => l_planner_id );
799:

Line 812: wf_engine.setitemattrNumber( itemtype => itemtype,

808: p_orig_system_id => l_planner_id,
809: p_name => x_planner_username,
810: p_display_name => x_planner_disp_name);
811:
812: wf_engine.setitemattrNumber( itemtype => itemtype,
813: itemkey => itemkey,
814: aname => 'FORWARD_TO_ID',
815: avalue => l_planner_id );
816:

Line 817: wf_engine.setitemattrtext( itemtype => ItemType,

813: itemkey => itemkey,
814: aname => 'FORWARD_TO_ID',
815: avalue => l_planner_id );
816:
817: wf_engine.setitemattrtext( itemtype => ItemType,
818: itemkey => ItemKey,
819: aname => 'FORWARD_TO_USERNAME',
820: avalue => x_planner_username);
821:

Line 822: wf_engine.setitemattrtext( itemtype => ItemType,

818: itemkey => ItemKey,
819: aname => 'FORWARD_TO_USERNAME',
820: avalue => x_planner_username);
821:
822: wf_engine.setitemattrtext( itemtype => ItemType,
823: itemkey => ItemKey,
824: aname => 'FORWARD_TO_DISPLAY_NAME',
825: avalue => x_planner_disp_name );
826:

Line 866: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

862:
863: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
864: Begin
865: if (funcmode = 'RUN') then
866: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
867: itemkey => itemkey,
868: aname => 'ORG_ID');
869: Select nvl(MO_APPROVAL_tIMEOUT_ACTION,1)
870: Into l_timeout_action

Line 913: l_line_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

909:
910: Begin
911: if (funcmode = 'RUN') then
912:
913: l_line_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
914: itemkey => itemkey,
915: aname => 'LINE_ID');
916:
917: -- Bug #5462193, added the code below so that cancelled line is not approved

Line 961: l_line_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

957: l_line_status NUMBER;
958: Begin
959: if (funcmode = 'RUN') then
960:
961: l_line_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
962: itemkey => itemkey,
963: aname => 'LINE_ID');
964:
965: -- Bug #5462193, added the code below so that cancelled line is not approved

Line 1010: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1006: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1007: Begin
1008: if (funcmode = 'RUN') then
1009:
1010: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1011: itemkey => itemkey,
1012: aname => 'ORG_ID');
1013: Select nvl(TXN_APPROVAL_TIMEOUT_PERIOD,0)
1014: Into l_timeout_period

Line 1035: wf_engine.setitemattrNumber( itemtype => itemtype,

1031:
1032:
1033: l_timeout_period := trunc(l_mfg_cal_date) - trunc(sysdate);
1034:
1035: wf_engine.setitemattrNumber( itemtype => itemtype,
1036: itemkey => itemkey,
1037: aname => 'APPROVAL_TIMEOUT',
1038: avalue => l_timeout_period );
1039: result := 'COMPLETE';

Line 1081: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1077: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1078: Begin
1079: if (funcmode = 'RUN') then
1080:
1081: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1082: itemkey => itemkey,
1083: aname => 'TO_HEADER_ID');
1084:
1085: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1085: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1081: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1082: itemkey => itemkey,
1083: aname => 'TO_HEADER_ID');
1084:
1085: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1086: itemkey => itemkey,
1087: aname => 'ORG_ID');
1088:
1089: l_trolin_tbl := INV_trolin_util.Get_Lines( l_header_id );

Line 1093: wf_engine.setItemAttrNumber( itemtype => itemtype,

1089: l_trolin_tbl := INV_trolin_util.Get_Lines( l_header_id );
1090: l_total_lines := l_trolin_tbl.count;
1091:
1092:
1093: wf_engine.setItemAttrNumber( itemtype => itemtype,
1094: itemkey => itemkey,
1095: aname => 'TOTAL_LINES',
1096: avalue => l_total_lines );
1097:

Line 1098: l_current_line := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1094: itemkey => itemkey,
1095: aname => 'TOTAL_LINES',
1096: avalue => l_total_lines );
1097:
1098: l_current_line := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1099: itemkey => itemkey,
1100: aname => 'CURRENT_LINE');
1101:
1102: l_current_line := nvl(l_current_line,0) + 1;

Line 1107: wf_engine.setitemattrNumber( itemtype => itemtype,

1103:
1104: if ( ( l_current_line <= l_total_lines ) AND
1105: ( l_trolin_tbl(l_current_line).line_status =
1106: INV_Globals.G_TO_STATUS_APPROVED ) ) then
1107: wf_engine.setitemattrNumber( itemtype => itemtype,
1108: itemkey => itemkey,
1109: aname => 'LINE_NUMBER',
1110: avalue => l_trolin_tbl(l_current_line).line_number );
1111:

Line 1112: wf_engine.setitemattrNumber( itemtype => itemtype,

1108: itemkey => itemkey,
1109: aname => 'LINE_NUMBER',
1110: avalue => l_trolin_tbl(l_current_line).line_number );
1111:
1112: wf_engine.setitemattrNumber( itemtype => itemtype,
1113: itemkey => itemkey,
1114: aname => 'LINE_QUANTITY',
1115: avalue => l_trolin_tbl(l_current_line).quantity );
1116: --INVCONV

Line 1117: wf_engine.setitemattrNumber( itemtype => itemtype,

1113: itemkey => itemkey,
1114: aname => 'LINE_QUANTITY',
1115: avalue => l_trolin_tbl(l_current_line).quantity );
1116: --INVCONV
1117: wf_engine.setitemattrNumber( itemtype => itemtype,
1118: itemkey => itemkey,
1119: aname => 'SEC_LINE_QTY',
1120: avalue => l_trolin_tbl(l_current_line).secondary_quantity );
1121:

Line 1122: wf_engine.setitemattrtext( itemtype => itemtype,

1118: itemkey => itemkey,
1119: aname => 'SEC_LINE_QTY',
1120: avalue => l_trolin_tbl(l_current_line).secondary_quantity );
1121:
1122: wf_engine.setitemattrtext( itemtype => itemtype,
1123: itemkey => itemkey,
1124: aname => 'SEC_UOM',
1125: avalue => l_trolin_tbl(l_current_line).secondary_uom );
1126: --INVCONV

Line 1128: wf_engine.setitemattrtext( itemtype => itemtype,

1124: aname => 'SEC_UOM',
1125: avalue => l_trolin_tbl(l_current_line).secondary_uom );
1126: --INVCONV
1127:
1128: wf_engine.setitemattrtext( itemtype => itemtype,
1129: itemkey => itemkey,
1130: aname => 'FROM_SUBINVENTORY',
1131: avalue =>
1132: l_trolin_tbl(l_current_line).from_subinventory_code );

Line 1136: wf_engine.setitemattrtext( itemtype => itemtype,

1132: l_trolin_tbl(l_current_line).from_subinventory_code );
1133:
1134: from_locator_value := INV_UTILITIES.get_conc_segments(l_org_id,l_trolin_tbl(l_current_line).from_locator_id);
1135:
1136: wf_engine.setitemattrtext( itemtype => itemtype,
1137: itemkey => itemkey,
1138: aname => 'FROM_LOCATOR',
1139: avalue => from_locator_value);
1140:

Line 1141: wf_engine.setitemattrtext( itemtype => itemtype,

1137: itemkey => itemkey,
1138: aname => 'FROM_LOCATOR',
1139: avalue => from_locator_value);
1140:
1141: wf_engine.setitemattrtext( itemtype => itemtype,
1142: itemkey => itemkey,
1143: aname => 'TO_SUBINVENTORY',
1144: avalue =>
1145: l_trolin_tbl(l_current_line).to_subinventory_code );

Line 1149: wf_engine.setitemattrtext( itemtype => itemtype,

1145: l_trolin_tbl(l_current_line).to_subinventory_code );
1146:
1147: to_locator_value := INV_UTILITIES.get_conc_segments(l_org_id,l_trolin_tbl(l_current_line).to_locator_id);
1148:
1149: wf_engine.setitemattrtext( itemtype => itemtype,
1150: itemkey => itemkey,
1151: aname => 'TO_LOCATOR',
1152: avalue => to_locator_value);
1153:

Line 1154: wf_engine.setitemattrtext( itemtype => itemtype,

1150: itemkey => itemkey,
1151: aname => 'TO_LOCATOR',
1152: avalue => to_locator_value);
1153:
1154: wf_engine.setitemattrtext( itemtype => itemtype,
1155: itemkey => itemkey,
1156: aname => 'UOM',
1157: avalue => l_trolin_tbl(l_current_line).uom_code );
1158:

Line 1159: wf_engine.setitemattrNumber( itemtype => itemtype,

1155: itemkey => itemkey,
1156: aname => 'UOM',
1157: avalue => l_trolin_tbl(l_current_line).uom_code );
1158:
1159: wf_engine.setitemattrNumber( itemtype => itemtype,
1160: itemkey => itemkey,
1161: aname => 'ITEM_ID',
1162: avalue => l_trolin_tbl(l_current_line).inventory_item_id );
1163:

Line 1164: wf_engine.setitemattrdate( itemtype => itemtype,

1160: itemkey => itemkey,
1161: aname => 'ITEM_ID',
1162: avalue => l_trolin_tbl(l_current_line).inventory_item_id );
1163:
1164: wf_engine.setitemattrdate( itemtype => itemtype,
1165: itemkey => itemkey,
1166: aname => 'DATE_REQUIRED',
1167: avalue => l_trolin_tbl(l_current_line).date_required );
1168:

Line 1169: wf_engine.setItemAttrNumber( itemtype => itemtype,

1165: itemkey => itemkey,
1166: aname => 'DATE_REQUIRED',
1167: avalue => l_trolin_tbl(l_current_line).date_required );
1168:
1169: wf_engine.setItemAttrNumber( itemtype => itemtype,
1170: itemkey => itemkey,
1171: aname => 'CURRENT_LINE',
1172: avalue => l_current_line );
1173: Begin

Line 1185: wf_engine.setItemAttrText( itemtype => itemtype,

1181: when others then
1182: l_to_notify_role := NULL;
1183: End;
1184:
1185: wf_engine.setItemAttrText( itemtype => itemtype,
1186: itemkey => itemkey,
1187: aname => 'TO_NOTIFY_ROLE',
1188: avalue => l_to_notify_role );
1189:

Line 1202: wf_engine.setItemAttrText( itemtype => itemtype,

1198: when Others then
1199: l_from_notify_role := Null;
1200: End;
1201:
1202: wf_engine.setItemAttrText( itemtype => itemtype,
1203: itemkey => itemkey,
1204: aname => 'FROM_NOTIFY_ROLE',
1205: avalue => l_from_notify_role );
1206:

Line 1244: l_sub_role := wf_engine.GetItemAttrText( itemtype => itemtype,

1240: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1241: Begin
1242: if (funcmode = 'RUN') then
1243:
1244: l_sub_role := wf_engine.GetItemAttrText( itemtype => itemtype,
1245: itemkey => itemkey,
1246: aname => 'TO_NOTIFY_ROLE');
1247:
1248: if ( l_sub_role IS NULL ) then

Line 1287: l_sub_role := wf_engine.GetItemAttrText( itemtype => itemtype,

1283: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1284: Begin
1285: if (funcmode = 'RUN') then
1286:
1287: l_sub_role := wf_engine.GetItemAttrText( itemtype => itemtype,
1288: itemkey => itemkey,
1289: aname => 'FROM_NOTIFY_ROLE');
1290:
1291: if ( l_sub_role IS NULL ) then