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

Line 98: wf_engine.createProcess ( ItemType => l_ItemType,

94: into l_seq from sys.dual;
95:
96: l_itemkey:=to_char(p_asl_id)||'-'||l_seq;
97:
98: wf_engine.createProcess ( ItemType => l_ItemType,
99: ItemKey => l_ItemKey,
100: Process => 'ORDER_MODIFIERS');
101:
102:

Line 103: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

99: ItemKey => l_ItemKey,
100: Process => 'ORDER_MODIFIERS');
101:
102:
103: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
104: itemkey => l_itemkey,
105: aname => 'ASL_ID',
106: avalue => p_asl_id);
107: wf_engine.StartProcess ( ItemType => l_ItemType,

Line 107: wf_engine.StartProcess ( ItemType => l_ItemType,

103: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
104: itemkey => l_itemkey,
105: aname => 'ASL_ID',
106: avalue => p_asl_id);
107: wf_engine.StartProcess ( ItemType => l_ItemType,
108: ItemKey => l_ItemKey );
109:
110: end StartWorkflow;
111:

Line 180: if (funcmode <> wf_engine.eng_run) then

176: l_planner_displayname varchar2(180):=null;
177: l_supplier_displayname varchar2(180):=null;
178: l_approval_required_by varchar2(20);
179: begin
180: if (funcmode <> wf_engine.eng_run) then
181: resultout := wf_engine.eng_null;
182: return;
183: end if;
184:

Line 181: resultout := wf_engine.eng_null;

177: l_supplier_displayname varchar2(180):=null;
178: l_approval_required_by varchar2(20);
179: begin
180: if (funcmode <> wf_engine.eng_run) then
181: resultout := wf_engine.eng_null;
182: return;
183: end if;
184:
185: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 185: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

181: resultout := wf_engine.eng_null;
182: return;
183: end if;
184:
185: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,
186: itemkey => itemkey,
187: aname => 'ASL_ID');
188: select DESCRIPTION,
189: BUYER_ID,

Line 211: wf_engine.SetItemAttrText ( itemtype => itemtype,

207: l_fixed_lot_multiple
208: from POS_ORD_MODIFIERS_V
209: where asl_id=l_asl_id;
210:
211: wf_engine.SetItemAttrText ( itemtype => itemtype,
212: itemkey => itemkey,
213: aname => 'ITEM_DESCRIPTION',
214: avalue => l_item_description);
215: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 215: wf_engine.SetItemAttrText ( itemtype => itemtype,

211: wf_engine.SetItemAttrText ( itemtype => itemtype,
212: itemkey => itemkey,
213: aname => 'ITEM_DESCRIPTION',
214: avalue => l_item_description);
215: wf_engine.SetItemAttrText ( itemtype => itemtype,
216: itemkey => itemkey,
217: aname => 'ITEM_NUM',
218: avalue => l_item_number);
219: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 219: wf_engine.SetItemAttrText ( itemtype => itemtype,

215: wf_engine.SetItemAttrText ( itemtype => itemtype,
216: itemkey => itemkey,
217: aname => 'ITEM_NUM',
218: avalue => l_item_number);
219: wf_engine.SetItemAttrText ( itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'SUPPLIER_ITEM',
222: avalue => l_supplier_item_number);
223: wf_engine.SetItemAttrText ( itemtype => itemtype,

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

219: wf_engine.SetItemAttrText ( itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'SUPPLIER_ITEM',
222: avalue => l_supplier_item_number);
223: wf_engine.SetItemAttrText ( itemtype => itemtype,
224: itemkey => itemkey,
225: aname => 'SUPPLIER_ITEM_NVL',
226: avalue => nvl(l_supplier_item_number,
227: l_item_number));

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

224: itemkey => itemkey,
225: aname => 'SUPPLIER_ITEM_NVL',
226: avalue => nvl(l_supplier_item_number,
227: l_item_number));
228: wf_engine.SetItemAttrText ( itemtype => itemtype,
229: itemkey => itemkey,
230: aname => 'PURCHASING_UOM',
231: avalue => l_uom);
232: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 232: wf_engine.SetItemAttrText ( itemtype => itemtype,

228: wf_engine.SetItemAttrText ( itemtype => itemtype,
229: itemkey => itemkey,
230: aname => 'PURCHASING_UOM',
231: avalue => l_uom);
232: wf_engine.SetItemAttrText ( itemtype => itemtype,
233: itemkey => itemkey,
234: aname => 'OLD_PLT',
235: avalue => nvl(l_processing_lead_time, '-'));
236: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 236: wf_engine.SetItemAttrText ( itemtype => itemtype,

232: wf_engine.SetItemAttrText ( itemtype => itemtype,
233: itemkey => itemkey,
234: aname => 'OLD_PLT',
235: avalue => nvl(l_processing_lead_time, '-'));
236: wf_engine.SetItemAttrText ( itemtype => itemtype,
237: itemkey => itemkey,
238: aname => 'OLD_MOQ',
239: avalue => nvl(l_min_order_qty, '-'));
240: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 240: wf_engine.SetItemAttrText ( itemtype => itemtype,

236: wf_engine.SetItemAttrText ( itemtype => itemtype,
237: itemkey => itemkey,
238: aname => 'OLD_MOQ',
239: avalue => nvl(l_min_order_qty, '-'));
240: wf_engine.SetItemAttrText ( itemtype => itemtype,
241: itemkey => itemkey,
242: aname => 'OLD_FLM',
243: avalue => nvl(l_fixed_lot_multiple, '-'));
244:

Line 259: wf_engine.SetItemAttrText ( itemtype => itemtype,

255: from po_vendors
256: where vendor_id=l_vendor_id;
257: end if;
258:
259: wf_engine.SetItemAttrText ( itemtype => itemtype,
260: itemkey => itemkey,
261: aname => 'SUPPLIER_ORG_NAME',
262: avalue => l_supplier_username);
263:

Line 276: wf_engine.SetItemAttrText ( itemtype => itemtype,

272:
273: if(l_vendor_id is not null) then
274: wf_directory.GetUserName('FND_USR', l_vendor_id, l_supplier_username, l_supplier_displayname);
275: end if;
276: wf_engine.SetItemAttrText ( itemtype => itemtype,
277: itemkey => itemkey,
278: aname => 'BUYER_NAME',
279: avalue => l_buyer_username);
280: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 280: wf_engine.SetItemAttrText ( itemtype => itemtype,

276: wf_engine.SetItemAttrText ( itemtype => itemtype,
277: itemkey => itemkey,
278: aname => 'BUYER_NAME',
279: avalue => l_buyer_username);
280: wf_engine.SetItemAttrText ( itemtype => itemtype,
281: itemkey => itemkey,
282: aname => 'BUYER_DISPLAY_NAME',
283: avalue => l_buyer_displayname);
284: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 284: wf_engine.SetItemAttrText ( itemtype => itemtype,

280: wf_engine.SetItemAttrText ( itemtype => itemtype,
281: itemkey => itemkey,
282: aname => 'BUYER_DISPLAY_NAME',
283: avalue => l_buyer_displayname);
284: wf_engine.SetItemAttrText ( itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'PLANNER_NAME',
287: avalue => l_planner_username);
288: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 288: wf_engine.SetItemAttrText ( itemtype => itemtype,

284: wf_engine.SetItemAttrText ( itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'PLANNER_NAME',
287: avalue => l_planner_username);
288: wf_engine.SetItemAttrText ( itemtype => itemtype,
289: itemkey => itemkey,
290: aname => 'PLANNER_DISPLAY_NAME',
291: avalue => l_planner_displayname);
292: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 292: wf_engine.SetItemAttrText ( itemtype => itemtype,

288: wf_engine.SetItemAttrText ( itemtype => itemtype,
289: itemkey => itemkey,
290: aname => 'PLANNER_DISPLAY_NAME',
291: avalue => l_planner_displayname);
292: wf_engine.SetItemAttrText ( itemtype => itemtype,
293: itemkey => itemkey,
294: aname => 'SUPPLIER_NAME',
295: avalue => l_supplier_username);
296: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 296: wf_engine.SetItemAttrText ( itemtype => itemtype,

292: wf_engine.SetItemAttrText ( itemtype => itemtype,
293: itemkey => itemkey,
294: aname => 'SUPPLIER_NAME',
295: avalue => l_supplier_username);
296: wf_engine.SetItemAttrText ( itemtype => itemtype,
297: itemkey => itemkey,
298: aname => 'SUPPLIER_DISPLAY_NAME',
299: avalue => l_supplier_displayname);
300:

Line 310: wf_engine.SetItemAttrText ( itemtype => itemtype,

306: l_fixed_lot_multiple
307: from POS_ORDER_MODIFIERS_TEMP
308: where asl_id=l_asl_id and status='NEW';
309:
310: wf_engine.SetItemAttrText ( itemtype => itemtype,
311: itemkey => itemkey,
312: aname => 'NEW_PLT',
313: avalue => nvl(l_processing_lead_time, '-'));
314: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 314: wf_engine.SetItemAttrText ( itemtype => itemtype,

310: wf_engine.SetItemAttrText ( itemtype => itemtype,
311: itemkey => itemkey,
312: aname => 'NEW_PLT',
313: avalue => nvl(l_processing_lead_time, '-'));
314: wf_engine.SetItemAttrText ( itemtype => itemtype,
315: itemkey => itemkey,
316: aname => 'NEW_MOQ',
317: avalue => nvl(l_min_order_qty, '-'));
318: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 318: wf_engine.SetItemAttrText ( itemtype => itemtype,

314: wf_engine.SetItemAttrText ( itemtype => itemtype,
315: itemkey => itemkey,
316: aname => 'NEW_MOQ',
317: avalue => nvl(l_min_order_qty, '-'));
318: wf_engine.SetItemAttrText ( itemtype => itemtype,
319: itemkey => itemkey,
320: aname => 'NEW_FLM',
321: avalue => nvl(l_fixed_lot_multiple, '-'));
322:

Line 325: wf_engine.SetItemAttrText ( itemtype => itemtype,

321: avalue => nvl(l_fixed_lot_multiple, '-'));
322:
323: FND_PROFILE.get('POS_ASL_MOD_APPR_REQD_BY', l_approval_required_by);
324: if(upper(l_approval_required_by)='BUYER') then
325: wf_engine.SetItemAttrText ( itemtype => itemtype,
326: itemkey => itemkey,
327: aname => 'APPROVAL_REQUIRED_BY',
328: avalue => 'BUYER');
329: elsif(upper(l_approval_required_by)='PLANNER') then

Line 330: wf_engine.SetItemAttrText ( itemtype => itemtype,

326: itemkey => itemkey,
327: aname => 'APPROVAL_REQUIRED_BY',
328: avalue => 'BUYER');
329: elsif(upper(l_approval_required_by)='PLANNER') then
330: wf_engine.SetItemAttrText ( itemtype => itemtype,
331: itemkey => itemkey,
332: aname => 'APPROVAL_REQUIRED_BY',
333: avalue => 'PLANNER');
334: else

Line 335: wf_engine.SetItemAttrText ( itemtype => itemtype,

331: itemkey => itemkey,
332: aname => 'APPROVAL_REQUIRED_BY',
333: avalue => 'PLANNER');
334: else
335: wf_engine.SetItemAttrText ( itemtype => itemtype,
336: itemkey => itemkey,
337: aname => 'APPROVAL_REQUIRED_BY',
338: avalue => 'NONE');
339: end if;

Line 341: wf_engine.SetItemAttrText (itemtype => itemtype,

337: aname => 'APPROVAL_REQUIRED_BY',
338: avalue => 'NONE');
339: end if;
340:
341: wf_engine.SetItemAttrText (itemtype => itemtype,
342: itemkey => itemkey,
343: aname => 'POS_NOTIFY_APPROVER',
344: avalue => 'PLSQL:POS_ORDER_MODIFIERS_PKG.GENERATE_APPR_NOTIF/'|| itemtype || ':' || itemkey);
345:

Line 346: wf_engine.SetItemAttrText (itemtype => itemtype,

342: itemkey => itemkey,
343: aname => 'POS_NOTIFY_APPROVER',
344: avalue => 'PLSQL:POS_ORDER_MODIFIERS_PKG.GENERATE_APPR_NOTIF/'|| itemtype || ':' || itemkey);
345:
346: wf_engine.SetItemAttrText (itemtype => itemtype,
347: itemkey => itemkey,
348: aname => 'POS_SUPP_NOTIF_APPR',
349: avalue => 'PLSQL:POS_ORDER_MODIFIERS_PKG.GENERATE_SUPPL_NOTIF_APPR/'|| itemtype || ':' || itemkey);
350:

Line 351: wf_engine.SetItemAttrText (itemtype => itemtype,

347: itemkey => itemkey,
348: aname => 'POS_SUPP_NOTIF_APPR',
349: avalue => 'PLSQL:POS_ORDER_MODIFIERS_PKG.GENERATE_SUPPL_NOTIF_APPR/'|| itemtype || ':' || itemkey);
350:
351: wf_engine.SetItemAttrText (itemtype => itemtype,
352: itemkey => itemkey,
353: aname => 'POS_SUPP_NOTIF_REJ',
354: avalue => 'PLSQL:POS_ORDER_MODIFIERS_PKG.GENERATE_SUPPL_NOTIF_REJ/'|| itemtype || ':' || itemkey);
355:

Line 394: x_new_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,

390:
391: generate_ord_mod_header(l_document,l_item_type,l_item_key);
392:
393:
394: x_new_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,
395: itemkey => l_item_key,
396: aname => 'NEW_PLT');
397:
398: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 398: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,

394: x_new_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,
395: itemkey => l_item_key,
396: aname => 'NEW_PLT');
397:
398: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,
399: itemkey => l_item_key,
400: aname => 'NEW_MOQ');
401:
402: x_new_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 402: x_new_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,

398: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,
399: itemkey => l_item_key,
400: aname => 'NEW_MOQ');
401:
402: x_new_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,
403: itemkey => l_item_key,
404: aname => 'NEW_FLM');
405:
406:

Line 407: x_old_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,

403: itemkey => l_item_key,
404: aname => 'NEW_FLM');
405:
406:
407: x_old_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,
408: itemkey => l_item_key,
409: aname => 'OLD_PLT');
410:
411: x_old_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 411: x_old_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,

407: x_old_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,
408: itemkey => l_item_key,
409: aname => 'OLD_PLT');
410:
411: x_old_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,
412: itemkey => l_item_key,
413: aname => 'OLD_MOQ');
414:
415: x_old_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 415: x_old_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,

411: x_old_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,
412: itemkey => l_item_key,
413: aname => 'OLD_MOQ');
414:
415: x_old_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,
416: itemkey => l_item_key,
417: aname => 'OLD_FLM');
418:
419:

Line 460: x_item_desc := wf_engine.GetItemAttrText ( itemtype => itemtype,

456: x_uom varchar2(25);
457:
458: begin
459:
460: x_item_desc := wf_engine.GetItemAttrText ( itemtype => itemtype,
461: itemkey => itemkey,
462: aname => 'ITEM_DESCRIPTION');
463:
464: x_item_num := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 464: x_item_num := wf_engine.GetItemAttrText ( itemtype => itemtype,

460: x_item_desc := wf_engine.GetItemAttrText ( itemtype => itemtype,
461: itemkey => itemkey,
462: aname => 'ITEM_DESCRIPTION');
463:
464: x_item_num := wf_engine.GetItemAttrText ( itemtype => itemtype,
465: itemkey => itemkey,
466: aname => 'ITEM_NUM');
467:
468: x_supp_item := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 468: x_supp_item := wf_engine.GetItemAttrText ( itemtype => itemtype,

464: x_item_num := wf_engine.GetItemAttrText ( itemtype => itemtype,
465: itemkey => itemkey,
466: aname => 'ITEM_NUM');
467:
468: x_supp_item := wf_engine.GetItemAttrText ( itemtype => itemtype,
469: itemkey => itemkey,
470: aname => 'SUPPLIER_ITEM');
471:
472: x_uom := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 472: x_uom := wf_engine.GetItemAttrText ( itemtype => itemtype,

468: x_supp_item := wf_engine.GetItemAttrText ( itemtype => itemtype,
469: itemkey => itemkey,
470: aname => 'SUPPLIER_ITEM');
471:
472: x_uom := wf_engine.GetItemAttrText ( itemtype => itemtype,
473: itemkey => itemkey,
474: aname => 'PURCHASING_UOM');
475:
476:

Line 531: x_new_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,

527:
528: generate_ord_mod_header(l_document,l_item_type,l_item_key);
529:
530:
531: x_new_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,
532: itemkey => l_item_key,
533: aname => 'NEW_PLT');
534:
535: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 535: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,

531: x_new_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,
532: itemkey => l_item_key,
533: aname => 'NEW_PLT');
534:
535: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,
536: itemkey => l_item_key,
537: aname => 'NEW_MOQ');
538:
539: x_new_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 539: x_new_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,

535: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,
536: itemkey => l_item_key,
537: aname => 'NEW_MOQ');
538:
539: x_new_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,
540: itemkey => l_item_key,
541: aname => 'NEW_FLM');
542:
543: l_document := l_document || '' || fnd_message.get_string('POS','POS_ORDER_MODIFIERS') || '

' || fnd_message.get_string('POS','POS_ORD_MOD_APPROVED') || NL;

Line 595: x_new_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,

591:
592:
593: generate_ord_mod_header(l_document,l_item_type,l_item_key);
594:
595: x_new_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,
596: itemkey => l_item_key,
597: aname => 'NEW_PLT');
598:
599: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 599: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,

595: x_new_plt := wf_engine.GetItemAttrText ( itemtype => l_item_type,
596: itemkey => l_item_key,
597: aname => 'NEW_PLT');
598:
599: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,
600: itemkey => l_item_key,
601: aname => 'NEW_MOQ');
602:
603: x_new_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,

Line 603: x_new_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,

599: x_new_moq := wf_engine.GetItemAttrText ( itemtype => l_item_type,
600: itemkey => l_item_key,
601: aname => 'NEW_MOQ');
602:
603: x_new_flm := wf_engine.GetItemAttrText ( itemtype => l_item_type,
604: itemkey => l_item_key,
605: aname => 'NEW_FLM');
606:
607: l_document := l_document || '' || fnd_message.get_string('POS','POS_ORDER_MODIFIERS') || '

' || fnd_message.get_string('POS','POS_ORD_MOD_REJECTED') || NL;

Line 636: if (funcmode <> wf_engine.eng_run) then

632: actid in number,
633: funcmode in varchar2,
634: resultout out NOCOPY varchar2 ) is
635: begin
636: if (funcmode <> wf_engine.eng_run) then
637: resultout := wf_engine.eng_null;
638: return;
639: end if;
640: end;

Line 637: resultout := wf_engine.eng_null;

633: funcmode in varchar2,
634: resultout out NOCOPY varchar2 ) is
635: begin
636: if (funcmode <> wf_engine.eng_run) then
637: resultout := wf_engine.eng_null;
638: return;
639: end if;
640: end;
641:

Line 648: if (funcmode <> wf_engine.eng_run) then

644: actid in number,
645: funcmode in varchar2,
646: resultout out NOCOPY varchar2 ) is
647: begin
648: if (funcmode <> wf_engine.eng_run) then
649: resultout := wf_engine.eng_null;
650: return;
651: end if;
652: end;

Line 649: resultout := wf_engine.eng_null;

645: funcmode in varchar2,
646: resultout out NOCOPY varchar2 ) is
647: begin
648: if (funcmode <> wf_engine.eng_run) then
649: resultout := wf_engine.eng_null;
650: return;
651: end if;
652: end;
653:

Line 663: if (funcmode <> wf_engine.eng_run) then

659:
660: l_approval_required_by varchar2(20);
661: l_buyer_name varchar2(180);
662: begin
663: if (funcmode <> wf_engine.eng_run) then
664: resultout := wf_engine.eng_null;
665: return;
666: end if;
667: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 664: resultout := wf_engine.eng_null;

660: l_approval_required_by varchar2(20);
661: l_buyer_name varchar2(180);
662: begin
663: if (funcmode <> wf_engine.eng_run) then
664: resultout := wf_engine.eng_null;
665: return;
666: end if;
667: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
668: itemkey => itemkey,

Line 667: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,

663: if (funcmode <> wf_engine.eng_run) then
664: resultout := wf_engine.eng_null;
665: return;
666: end if;
667: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
668: itemkey => itemkey,
669: aname => 'APPROVAL_REQUIRED_BY');
670: if(l_approval_required_by='BUYER') then
671: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 671: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

667: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
668: itemkey => itemkey,
669: aname => 'APPROVAL_REQUIRED_BY');
670: if(l_approval_required_by='BUYER') then
671: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
672: itemkey => itemkey,
673: aname => 'BUYER_NAME');
674: wf_engine.SetItemAttrText ( itemtype => itemtype,
675: itemkey => itemkey,

Line 674: wf_engine.SetItemAttrText ( itemtype => itemtype,

670: if(l_approval_required_by='BUYER') then
671: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
672: itemkey => itemkey,
673: aname => 'BUYER_NAME');
674: wf_engine.SetItemAttrText ( itemtype => itemtype,
675: itemkey => itemkey,
676: aname => 'RESPONSE_FROM_ROLE',
677: avalue => l_buyer_name);
678:

Line 680: resultout := wf_engine.eng_completed || ':' || 'Y';

676: aname => 'RESPONSE_FROM_ROLE',
677: avalue => l_buyer_name);
678:
679:
680: resultout := wf_engine.eng_completed || ':' || 'Y';
681: else
682: resultout := wf_engine.eng_completed || ':' || 'N';
683: end if;
684:

Line 682: resultout := wf_engine.eng_completed || ':' || 'N';

678:
679:
680: resultout := wf_engine.eng_completed || ':' || 'Y';
681: else
682: resultout := wf_engine.eng_completed || ':' || 'N';
683: end if;
684:
685: end;
686:

Line 695: if (funcmode <> wf_engine.eng_run) then

691: resultout out NOCOPY varchar2 ) is
692:
693: l_buyer_name varchar2(100);
694: begin
695: if (funcmode <> wf_engine.eng_run) then
696: resultout := wf_engine.eng_null;
697: return;
698: end if;
699: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 696: resultout := wf_engine.eng_null;

692:
693: l_buyer_name varchar2(100);
694: begin
695: if (funcmode <> wf_engine.eng_run) then
696: resultout := wf_engine.eng_null;
697: return;
698: end if;
699: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
700: itemkey => itemkey,

Line 699: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

695: if (funcmode <> wf_engine.eng_run) then
696: resultout := wf_engine.eng_null;
697: return;
698: end if;
699: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
700: itemkey => itemkey,
701: aname => 'BUYER_NAME');
702: if(l_buyer_name is not null) then
703: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 703: resultout := wf_engine.eng_completed || ':' || 'Y';

699: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
700: itemkey => itemkey,
701: aname => 'BUYER_NAME');
702: if(l_buyer_name is not null) then
703: resultout := wf_engine.eng_completed || ':' || 'Y';
704: else
705: resultout := wf_engine.eng_completed || ':' || 'N';
706: end if;
707: end;

Line 705: resultout := wf_engine.eng_completed || ':' || 'N';

701: aname => 'BUYER_NAME');
702: if(l_buyer_name is not null) then
703: resultout := wf_engine.eng_completed || ':' || 'Y';
704: else
705: resultout := wf_engine.eng_completed || ':' || 'N';
706: end if;
707: end;
708:
709: procedure PLANNER_APPROVAL_REQUIRED( itemtype in varchar2,

Line 719: if (funcmode <> wf_engine.eng_run) then

715: l_approval_required_by varchar2(20);
716: l_planner_name varchar2(180);
717: l_supplier_name varchar2(180);
718: begin
719: if (funcmode <> wf_engine.eng_run) then
720: resultout := wf_engine.eng_null;
721: return;
722: end if;
723: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 720: resultout := wf_engine.eng_null;

716: l_planner_name varchar2(180);
717: l_supplier_name varchar2(180);
718: begin
719: if (funcmode <> wf_engine.eng_run) then
720: resultout := wf_engine.eng_null;
721: return;
722: end if;
723: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
724: itemkey => itemkey,

Line 723: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,

719: if (funcmode <> wf_engine.eng_run) then
720: resultout := wf_engine.eng_null;
721: return;
722: end if;
723: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
724: itemkey => itemkey,
725: aname => 'APPROVAL_REQUIRED_BY');
726: if(l_approval_required_by='PLANNER') then
727: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 727: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

723: l_approval_required_by:=wf_engine.GetItemAttrText ( itemtype => itemtype,
724: itemkey => itemkey,
725: aname => 'APPROVAL_REQUIRED_BY');
726: if(l_approval_required_by='PLANNER') then
727: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
728: itemkey => itemkey,
729: aname => 'PLANNER_NAME');
730: wf_engine.SetItemAttrText ( itemtype => itemtype,
731: itemkey => itemkey,

Line 730: wf_engine.SetItemAttrText ( itemtype => itemtype,

726: if(l_approval_required_by='PLANNER') then
727: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
728: itemkey => itemkey,
729: aname => 'PLANNER_NAME');
730: wf_engine.SetItemAttrText ( itemtype => itemtype,
731: itemkey => itemkey,
732: aname => 'RESPONSE_FROM_ROLE',
733: avalue => l_planner_name);
734: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 734: resultout := wf_engine.eng_completed || ':' || 'Y';

730: wf_engine.SetItemAttrText ( itemtype => itemtype,
731: itemkey => itemkey,
732: aname => 'RESPONSE_FROM_ROLE',
733: avalue => l_planner_name);
734: resultout := wf_engine.eng_completed || ':' || 'Y';
735: else
736: l_supplier_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
737: itemkey => itemkey,
738: aname => 'SUPPLIER_NAME');

Line 736: l_supplier_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

732: aname => 'RESPONSE_FROM_ROLE',
733: avalue => l_planner_name);
734: resultout := wf_engine.eng_completed || ':' || 'Y';
735: else
736: l_supplier_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
737: itemkey => itemkey,
738: aname => 'SUPPLIER_NAME');
739: wf_engine.SetItemAttrText ( itemtype => itemtype,
740: itemkey => itemkey,

Line 739: wf_engine.SetItemAttrText ( itemtype => itemtype,

735: else
736: l_supplier_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
737: itemkey => itemkey,
738: aname => 'SUPPLIER_NAME');
739: wf_engine.SetItemAttrText ( itemtype => itemtype,
740: itemkey => itemkey,
741: aname => 'RESPONSE_FROM_ROLE',
742: avalue => l_supplier_name);
743: resultout := wf_engine.eng_completed || ':' || 'N';

Line 743: resultout := wf_engine.eng_completed || ':' || 'N';

739: wf_engine.SetItemAttrText ( itemtype => itemtype,
740: itemkey => itemkey,
741: aname => 'RESPONSE_FROM_ROLE',
742: avalue => l_supplier_name);
743: resultout := wf_engine.eng_completed || ':' || 'N';
744: end if;
745:
746: end;
747:

Line 756: if (funcmode <> wf_engine.eng_run) then

752: resultout out NOCOPY varchar2 ) is
753:
754: l_planner_name varchar2(100);
755: begin
756: if (funcmode <> wf_engine.eng_run) then
757: resultout := wf_engine.eng_null;
758: return;
759: end if;
760: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 757: resultout := wf_engine.eng_null;

753:
754: l_planner_name varchar2(100);
755: begin
756: if (funcmode <> wf_engine.eng_run) then
757: resultout := wf_engine.eng_null;
758: return;
759: end if;
760: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
761: itemkey => itemkey,

Line 760: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

756: if (funcmode <> wf_engine.eng_run) then
757: resultout := wf_engine.eng_null;
758: return;
759: end if;
760: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
761: itemkey => itemkey,
762: aname => 'PLANNER_NAME');
763: if(l_planner_name is not null) then
764: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 764: resultout := wf_engine.eng_completed || ':' || 'Y';

760: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
761: itemkey => itemkey,
762: aname => 'PLANNER_NAME');
763: if(l_planner_name is not null) then
764: resultout := wf_engine.eng_completed || ':' || 'Y';
765: else
766: resultout := wf_engine.eng_completed || ':' || 'N';
767: end if;
768: end;

Line 766: resultout := wf_engine.eng_completed || ':' || 'N';

762: aname => 'PLANNER_NAME');
763: if(l_planner_name is not null) then
764: resultout := wf_engine.eng_completed || ':' || 'Y';
765: else
766: resultout := wf_engine.eng_completed || ':' || 'N';
767: end if;
768: end;
769:
770: procedure UPDATE_ASL( itemtype in varchar2,

Line 781: if (funcmode <> wf_engine.eng_run) then

777: l_proc_lead_time number;
778: l_min_order_qty number;
779: l_fixed_lot_multiple number;
780: begin
781: if (funcmode <> wf_engine.eng_run) then
782: resultout := wf_engine.eng_null;
783: return;
784: end if;
785:

Line 782: resultout := wf_engine.eng_null;

778: l_min_order_qty number;
779: l_fixed_lot_multiple number;
780: begin
781: if (funcmode <> wf_engine.eng_run) then
782: resultout := wf_engine.eng_null;
783: return;
784: end if;
785:
786: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 786: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

782: resultout := wf_engine.eng_null;
783: return;
784: end if;
785:
786: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,
787: itemkey => itemkey,
788: aname => 'ASL_ID');
789:
790: select processing_lead_time, min_order_quantity, fixed_lot_multiple

Line 818: if (funcmode <> wf_engine.eng_run) then

814: resultout out NOCOPY varchar2 ) is
815:
816: l_default_mode varchar2(20);
817: begin
818: if (funcmode <> wf_engine.eng_run) then
819: resultout := wf_engine.eng_null;
820: return;
821: end if;
822: l_default_mode:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 819: resultout := wf_engine.eng_null;

815:
816: l_default_mode varchar2(20);
817: begin
818: if (funcmode <> wf_engine.eng_run) then
819: resultout := wf_engine.eng_null;
820: return;
821: end if;
822: l_default_mode:=wf_engine.GetItemAttrText ( itemtype => itemtype,
823: itemkey => itemkey,

Line 822: l_default_mode:=wf_engine.GetItemAttrText ( itemtype => itemtype,

818: if (funcmode <> wf_engine.eng_run) then
819: resultout := wf_engine.eng_null;
820: return;
821: end if;
822: l_default_mode:=wf_engine.GetItemAttrText ( itemtype => itemtype,
823: itemkey => itemkey,
824: aname => 'DEFAULT_MODE');
825: if(upper(l_default_mode)='APPROVE') then
826: resultout := wf_engine.eng_completed || ':' || 'APPROVED';

Line 826: resultout := wf_engine.eng_completed || ':' || 'APPROVED';

822: l_default_mode:=wf_engine.GetItemAttrText ( itemtype => itemtype,
823: itemkey => itemkey,
824: aname => 'DEFAULT_MODE');
825: if(upper(l_default_mode)='APPROVE') then
826: resultout := wf_engine.eng_completed || ':' || 'APPROVED';
827: else
828: resultout := wf_engine.eng_completed || ':' || 'REJECTED';
829: end if;
830:

Line 828: resultout := wf_engine.eng_completed || ':' || 'REJECTED';

824: aname => 'DEFAULT_MODE');
825: if(upper(l_default_mode)='APPROVE') then
826: resultout := wf_engine.eng_completed || ':' || 'APPROVED';
827: else
828: resultout := wf_engine.eng_completed || ':' || 'REJECTED';
829: end if;
830:
831: end;
832:

Line 841: if (funcmode <> wf_engine.eng_run) then

837: resultout out NOCOPY varchar2 ) is
838:
839: l_asl_id number;
840: begin
841: if (funcmode <> wf_engine.eng_run) then
842: resultout := wf_engine.eng_null;
843: return;
844: end if;
845:

Line 842: resultout := wf_engine.eng_null;

838:
839: l_asl_id number;
840: begin
841: if (funcmode <> wf_engine.eng_run) then
842: resultout := wf_engine.eng_null;
843: return;
844: end if;
845:
846: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 846: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,

842: resultout := wf_engine.eng_null;
843: return;
844: end if;
845:
846: l_asl_id:=wf_engine.GetItemAttrNumber ( itemtype => itemtype,
847: itemkey => itemkey,
848: aname => 'ASL_ID');
849:
850: update POS_ORDER_MODIFIERS_TEMP

Line 866: if (funcmode <> wf_engine.eng_run) then

862:
863: l_buyer_name varchar2(100);
864: l_planner_name varchar2(100);
865: begin
866: if (funcmode <> wf_engine.eng_run) then
867: resultout := wf_engine.eng_null;
868: return;
869: end if;
870: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 867: resultout := wf_engine.eng_null;

863: l_buyer_name varchar2(100);
864: l_planner_name varchar2(100);
865: begin
866: if (funcmode <> wf_engine.eng_run) then
867: resultout := wf_engine.eng_null;
868: return;
869: end if;
870: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
871: itemkey => itemkey,

Line 870: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

866: if (funcmode <> wf_engine.eng_run) then
867: resultout := wf_engine.eng_null;
868: return;
869: end if;
870: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
871: itemkey => itemkey,
872: aname => 'BUYER_NAME');
873: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
874: itemkey => itemkey,

Line 873: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,

869: end if;
870: l_buyer_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
871: itemkey => itemkey,
872: aname => 'BUYER_NAME');
873: l_planner_name:=wf_engine.GetItemAttrText ( itemtype => itemtype,
874: itemkey => itemkey,
875: aname => 'PLANNER_NAME');
876:
877: if(l_planner_name is not null) then

Line 879: resultout := wf_engine.eng_completed || ':' || 'Y';

875: aname => 'PLANNER_NAME');
876:
877: if(l_planner_name is not null) then
878: if(l_planner_name=l_buyer_name) then
879: resultout := wf_engine.eng_completed || ':' || 'Y';
880: else
881: resultout := wf_engine.eng_completed || ':' || 'N';
882: end if;
883: else

Line 881: resultout := wf_engine.eng_completed || ':' || 'N';

877: if(l_planner_name is not null) then
878: if(l_planner_name=l_buyer_name) then
879: resultout := wf_engine.eng_completed || ':' || 'Y';
880: else
881: resultout := wf_engine.eng_completed || ':' || 'N';
882: end if;
883: else
884: resultout := wf_engine.eng_completed || ':' || 'Y';
885: end if;

Line 884: resultout := wf_engine.eng_completed || ':' || 'Y';

880: else
881: resultout := wf_engine.eng_completed || ':' || 'N';
882: end if;
883: else
884: resultout := wf_engine.eng_completed || ':' || 'Y';
885: end if;
886: end;
887:
888: