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

Line 109: l_chg_req_grp_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

105: END IF;
106:
107: x_progress := 'INIT_TOL_VALUES:000';
108:
109: l_chg_req_grp_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
110: itemkey => itemkey,
111: aname => 'CHANGE_REQUEST_GROUP_ID');
112:
113: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 113: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

109: l_chg_req_grp_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
110: itemkey => itemkey,
111: aname => 'CHANGE_REQUEST_GROUP_ID');
112:
113: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
114: itemkey => itemkey,
115: aname => 'PO_HEADER_ID');
116:
117: l_po_release_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 117: l_po_release_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

113: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
114: itemkey => itemkey,
115: aname => 'PO_HEADER_ID');
116:
117: l_po_release_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
118: itemkey => itemkey,
119: aname => 'PO_RELEASE_ID');
120:
121: x_progress := 'INIT_TOL_VALUES:001';

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

176: x_progress := 'INIT_TOL_VALUES:002';
177:
178:
179:
180: wf_engine.SetItemAttrText (itemtype => itemtype,
181: itemkey => itemkey,
182: aname => 'DOCUMENT_TYPE',
183: avalue => l_doc_type);
184:

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

181: itemkey => itemkey,
182: aname => 'DOCUMENT_TYPE',
183: avalue => l_doc_type);
184:
185: wf_engine.SetItemAttrText (itemtype => itemtype,
186: itemkey => itemkey,
187: aname => 'DOC_SUB_TYPE',
188: avalue => l_doc_subtype);
189:

Line 294: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

290:
291: x_progress := 'INIT_TOL_VALUES:005';
292:
293:
294: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
295: itemkey => itemkey,
296: aname => 'PROMISE_DATE_INCR',
297: avalue => l_promise_date_incr);
298:

Line 299: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

295: itemkey => itemkey,
296: aname => 'PROMISE_DATE_INCR',
297: avalue => l_promise_date_incr);
298:
299: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
300: itemkey => itemkey,
301: aname => 'PROMISE_DATE_DEC',
302: avalue => l_promise_date_decr);
303:

Line 304: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

300: itemkey => itemkey,
301: aname => 'PROMISE_DATE_DEC',
302: avalue => l_promise_date_decr);
303:
304: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
305: itemkey => itemkey,
306: aname => 'UNIT_PRICE_INCR',
307: avalue => l_unit_price_incr);
308:

Line 309: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

305: itemkey => itemkey,
306: aname => 'UNIT_PRICE_INCR',
307: avalue => l_unit_price_incr);
308:
309: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
310: itemkey => itemkey,
311: aname => 'UNIT_PRICE_DEC',
312: avalue => l_unit_price_decr);
313:

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

310: itemkey => itemkey,
311: aname => 'UNIT_PRICE_DEC',
312: avalue => l_unit_price_decr);
313:
314: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
315: itemkey => itemkey,
316: aname => 'DOC_AMOUNT_INCR_PER',
317: avalue => l_doc_amount_incr_per);
318:

Line 319: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

315: itemkey => itemkey,
316: aname => 'DOC_AMOUNT_INCR_PER',
317: avalue => l_doc_amount_incr_per);
318:
319: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
320: itemkey => itemkey,
321: aname => 'DOC_AMOUNT_DEC_PER',
322: avalue => l_doc_amount_decr_per);
323:

Line 324: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

320: itemkey => itemkey,
321: aname => 'DOC_AMOUNT_DEC_PER',
322: avalue => l_doc_amount_decr_per);
323:
324: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
325: itemkey => itemkey,
326: aname => 'DOC_AMOUNT_INCR_VAL',
327: avalue => l_doc_amount_incr_val);
328:

Line 329: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

325: itemkey => itemkey,
326: aname => 'DOC_AMOUNT_INCR_VAL',
327: avalue => l_doc_amount_incr_val);
328:
329: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
330: itemkey => itemkey,
331: aname => 'DOC_AMOUNT_DEC_VAL',
332: avalue => l_doc_amount_decr_val);
333:

Line 334: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

330: itemkey => itemkey,
331: aname => 'DOC_AMOUNT_DEC_VAL',
332: avalue => l_doc_amount_decr_val);
333:
334: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
335: itemkey => itemkey,
336: aname => 'LINE_AMOUNT_INCR_PER',
337: avalue => l_line_amount_incr_per);
338:

Line 339: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

335: itemkey => itemkey,
336: aname => 'LINE_AMOUNT_INCR_PER',
337: avalue => l_line_amount_incr_per);
338:
339: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
340: itemkey => itemkey,
341: aname => 'LINE_AMOUNT_DEC_PER',
342: avalue => l_line_amount_decr_per);
343:

Line 344: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

340: itemkey => itemkey,
341: aname => 'LINE_AMOUNT_DEC_PER',
342: avalue => l_line_amount_decr_per);
343:
344: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
345: itemkey => itemkey,
346: aname => 'LINE_AMOUNT_INCR_VAL',
347: avalue => l_line_amount_incr_val);
348:

Line 349: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

345: itemkey => itemkey,
346: aname => 'LINE_AMOUNT_INCR_VAL',
347: avalue => l_line_amount_incr_val);
348:
349: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
350: itemkey => itemkey,
351: aname => 'LINE_AMOUNT_DEC_VAL',
352: avalue => l_line_amount_decr_val);
353:

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

350: itemkey => itemkey,
351: aname => 'LINE_AMOUNT_DEC_VAL',
352: avalue => l_line_amount_decr_val);
353:
354: wf_engine.SetItemAttrText (itemtype => itemtype,
355: itemkey => itemkey,
356: aname => 'PROMISE_DATE_APP_FLAG',
357: avalue => l_prm_date_approval_flag);
358:

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

355: itemkey => itemkey,
356: aname => 'PROMISE_DATE_APP_FLAG',
357: avalue => l_prm_date_approval_flag);
358:
359: wf_engine.SetItemAttrText (itemtype => itemtype,
360: itemkey => itemkey,
361: aname => 'SHIP_QTY_APPROVAL_FLAG',
362: avalue => l_ship_qty_approval_flag);
363:

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

360: itemkey => itemkey,
361: aname => 'SHIP_QTY_APPROVAL_FLAG',
362: avalue => l_ship_qty_approval_flag);
363:
364: wf_engine.SetItemAttrText (itemtype => itemtype,
365: itemkey => itemkey,
366: aname => 'PRICE_APPROVAL_FLAG',
367: avalue => l_price_approval_flag);
368:

Line 371: l_po_style := wf_engine.GetItemAttrText ( itemtype => itemtype,

367: avalue => l_price_approval_flag);
368:
369:
370: -- Get the PO Style ( COMPLEX or NORMAL and accordingly populating the Tolerance Attributes
371: l_po_style := wf_engine.GetItemAttrText ( itemtype => itemtype,
372: itemkey => itemkey,
373: aname => 'PO_STYLE_TYPE');
374:
375: log_message('INITIALIZE_TOL_VALUES','PO Style Type',l_po_style);

Line 380: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

376:
377:
378: IF (l_po_style ='COMPLEX') THEN
379:
380: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
381: itemkey => itemkey,
382: aname => 'PAY_QUANTITY_INCR',
383: avalue => l_pay_item_qty_incr);
384:

Line 385: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

381: itemkey => itemkey,
382: aname => 'PAY_QUANTITY_INCR',
383: avalue => l_pay_item_qty_incr);
384:
385: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
386: itemkey => itemkey,
387: aname => 'PAY_QUANTITY_DEC',
388: avalue => l_pay_item_qty_decr);
389:

Line 390: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

386: itemkey => itemkey,
387: aname => 'PAY_QUANTITY_DEC',
388: avalue => l_pay_item_qty_decr);
389:
390: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
391: itemkey => itemkey,
392: aname => 'PAY_AMOUNT_INCR_PER',
393: avalue => l_pay_item_amount_incr_per);
394:

Line 395: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

391: itemkey => itemkey,
392: aname => 'PAY_AMOUNT_INCR_PER',
393: avalue => l_pay_item_amount_incr_per);
394:
395: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
396: itemkey => itemkey,
397: aname => 'PAY_AMOUNT_DEC_PER',
398: avalue => l_pay_item_amount_decr_per);
399:

Line 400: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

396: itemkey => itemkey,
397: aname => 'PAY_AMOUNT_DEC_PER',
398: avalue => l_pay_item_amount_decr_per);
399:
400: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
401: itemkey => itemkey,
402: aname => 'PAY_AMOUNT_INCR_VAL',
403: avalue => l_pay_item_amount_incr_val);
404:

Line 405: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

401: itemkey => itemkey,
402: aname => 'PAY_AMOUNT_INCR_VAL',
403: avalue => l_pay_item_amount_incr_val);
404:
405: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
406: itemkey => itemkey,
407: aname => 'PAY_AMOUNT_DEC_VAL',
408: avalue => l_pay_item_amount_decr_val);
409:

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

409:
410: IF (PO_COMPLEX_WORK_PVT.is_financing_po(l_po_header_id)) THEN
411: l_complex_po_style := 'FINANCING';
412:
413: wf_engine.SetItemAttrText (itemtype => itemtype,
414: itemkey => itemkey,
415: aname => 'COMPLEX_PO_STYLE',
416: avalue => l_complex_po_style);
417: ELSE

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

416: avalue => l_complex_po_style);
417: ELSE
418: l_complex_po_style := 'ACTUALS';
419:
420: wf_engine.SetItemAttrText (itemtype => itemtype,
421: itemkey => itemkey,
422: aname => 'COMPLEX_PO_STYLE',
423: avalue => l_complex_po_style);
424: END IF;

Line 430: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

426:
427:
428: ELSIF (l_po_style ='NORMAL') THEN
429:
430: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
431: itemkey => itemkey,
432: aname => 'SHIP_QUANTITY_INCR',
433: avalue => l_shipment_qty_incr);
434:

Line 435: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

431: itemkey => itemkey,
432: aname => 'SHIP_QUANTITY_INCR',
433: avalue => l_shipment_qty_incr);
434:
435: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
436: itemkey => itemkey,
437: aname => 'SHIP_QUANTITY_DEC',
438: avalue => l_shipment_qty_decr);
439:

Line 440: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

436: itemkey => itemkey,
437: aname => 'SHIP_QUANTITY_DEC',
438: avalue => l_shipment_qty_decr);
439:
440: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
441: itemkey => itemkey,
442: aname => 'SHIP_AMOUNT_INCR_PER',
443: avalue => l_ship_amount_incr_per);
444:

Line 445: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

441: itemkey => itemkey,
442: aname => 'SHIP_AMOUNT_INCR_PER',
443: avalue => l_ship_amount_incr_per);
444:
445: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'SHIP_AMOUNT_DEC_PER',
448: avalue => l_ship_amount_decr_per);
449:

Line 450: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

446: itemkey => itemkey,
447: aname => 'SHIP_AMOUNT_DEC_PER',
448: avalue => l_ship_amount_decr_per);
449:
450: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
451: itemkey => itemkey,
452: aname => 'SHIP_AMOUNT_INCR_VAL',
453: avalue => l_ship_amount_incr_val);
454:

Line 455: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

451: itemkey => itemkey,
452: aname => 'SHIP_AMOUNT_INCR_VAL',
453: avalue => l_ship_amount_incr_val);
454:
455: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
456: itemkey => itemkey,
457: aname => 'SHIP_AMOUNT_DEC_VAL',
458: avalue => l_ship_amount_decr_val);
459:

Line 527: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

523: IF ( funcmode = 'RUN' ) THEN
524:
525: x_progress := 'PROMISE_DATE_WITHIN_TOL:000';
526:
527: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
528: itemkey => itemkey,
529: aname => 'CHANGE_REQUEST_GROUP_ID');
530:
531: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 531: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

527: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
528: itemkey => itemkey,
529: aname => 'CHANGE_REQUEST_GROUP_ID');
530:
531: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
532: itemkey => itemkey,
533: aname => 'PO_HEADER_ID');
534:
535: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 535: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

531: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
532: itemkey => itemkey,
533: aname => 'PO_HEADER_ID');
534:
535: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
536: itemkey => itemkey,
537: aname => 'PO_STYLE_TYPE');
538:
539: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 539: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

535: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
536: itemkey => itemkey,
537: aname => 'PO_STYLE_TYPE');
538:
539: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
540: itemkey => itemkey,
541: aname => 'DOCUMENT_TYPE');
542:
543: x_progress := 'PROMISE_DATE_WITHIN_TOL:001';

Line 552: l_prom_date_dec := wf_engine.GetItemAttrNumber (itemtype => itemtype,

548: -- DOC_SUB_TYPE is already checked in business rules check
549:
550: IF( (l_doc_type = 'PO') OR (l_doc_type = 'RELEASE')) THEN
551: -- get the promise date tolerances in days
552: l_prom_date_dec := wf_engine.GetItemAttrNumber (itemtype => itemtype,
553: itemkey => itemkey,
554: aname => 'PROMISE_DATE_DEC');
555: l_prom_date_incr := wf_engine.GetItemAttrNumber (itemtype => itemtype,
556: itemkey => itemkey,

Line 555: l_prom_date_incr := wf_engine.GetItemAttrNumber (itemtype => itemtype,

551: -- get the promise date tolerances in days
552: l_prom_date_dec := wf_engine.GetItemAttrNumber (itemtype => itemtype,
553: itemkey => itemkey,
554: aname => 'PROMISE_DATE_DEC');
555: l_prom_date_incr := wf_engine.GetItemAttrNumber (itemtype => itemtype,
556: itemkey => itemkey,
557: aname => 'PROMISE_DATE_INCR');
558:
559: log_message('PROMISE_DATE_WITHIN_TOL','Promise Date Incr and decr Values',l_prom_date_incr || ', '|| l_prom_date_dec);

Line 598: resultout := wf_engine.eng_completed || ':' || l_return_val ;

594: END IF; -- DOC_TYPE check
595: END IF; --l_change_group_id IS NOT NULL
596:
597: -- set result value
598: resultout := wf_engine.eng_completed || ':' || l_return_val ;
599:
600: x_progress := 'PROMISE_DATE_WITHIN_TOL:005';
601:
602: log_message('PROMISE_DATE_WITHIN_TOL','Result',resultout);

Line 694: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

690: IF ( funcmode = 'RUN' ) THEN
691:
692: x_progress := 'UNIT_PRICE_WITHIN_TOL:000';
693:
694: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
695: itemkey => itemkey,
696: aname => 'CHANGE_REQUEST_GROUP_ID');
697:
698: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 698: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

694: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
695: itemkey => itemkey,
696: aname => 'CHANGE_REQUEST_GROUP_ID');
697:
698: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
699: itemkey => itemkey,
700: aname => 'PO_HEADER_ID');
701:
702: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 702: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

698: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
699: itemkey => itemkey,
700: aname => 'PO_HEADER_ID');
701:
702: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
703: itemkey => itemkey,
704: aname => 'PO_RELEASE_ID');
705:
706: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 706: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

702: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
703: itemkey => itemkey,
704: aname => 'PO_RELEASE_ID');
705:
706: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
707: itemkey => itemkey,
708: aname => 'PO_STYLE_TYPE');
709:
710: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 710: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

706: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
707: itemkey => itemkey,
708: aname => 'PO_STYLE_TYPE');
709:
710: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
711: itemkey => itemkey,
712: aname => 'DOCUMENT_TYPE');
713:
714: l_complex_po_style := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 714: l_complex_po_style := wf_engine.GetItemAttrText (itemtype => itemtype,

710: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
711: itemkey => itemkey,
712: aname => 'DOCUMENT_TYPE');
713:
714: l_complex_po_style := wf_engine.GetItemAttrText (itemtype => itemtype,
715: itemkey => itemkey,
716: aname => 'COMPLEX_PO_STYLE');
717:
718: x_progress := 'UNIT_PRICE_WITHIN_TOL:001';

Line 724: l_unitprice_lower_tol := wf_engine.GetItemAttrNumber (itemtype => itemtype,

720: -- check for the DOC types (applicable for PO unit price( Line level) and BPA release unit price(Shipment Level)
721: -- if other doc types return true and exit
722: IF(l_doc_type = 'PO' OR l_doc_type = 'RELEASE') THEN
723: -- get the unit price percentage tolerances
724: l_unitprice_lower_tol := wf_engine.GetItemAttrNumber (itemtype => itemtype,
725: itemkey => itemkey,
726: aname => 'UNIT_PRICE_DEC');
727:
728: l_unitprice_upper_tol := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 728: l_unitprice_upper_tol := wf_engine.GetItemAttrNumber (itemtype => itemtype,

724: l_unitprice_lower_tol := wf_engine.GetItemAttrNumber (itemtype => itemtype,
725: itemkey => itemkey,
726: aname => 'UNIT_PRICE_DEC');
727:
728: l_unitprice_upper_tol := wf_engine.GetItemAttrNumber (itemtype => itemtype,
729: itemkey => itemkey,
730: aname => 'UNIT_PRICE_INCR');
731: x_progress := 'UNIT_PRICE_WITHIN_TOL:002';
732: log_message('UNIT_PRICE_WITHIN_TOL','Unit Price Incr & Decr Values',l_unitprice_upper_tol || ', '|| l_unitprice_lower_tol);

Line 796: resultout := wf_engine.eng_completed|| ':' || l_return_val ;

792: END IF; -- change_group_id is not null
793:
794: -- set result value
795:
796: resultout := wf_engine.eng_completed|| ':' || l_return_val ;
797: x_progress := 'UNIT_PRICE_WITHIN_TOL:009';
798: log_message('UNIT_PRICE_WITHIN_TOL','Result',resultout);
799:
800: END IF; -- IF ( funcmode = 'RUN' )

Line 860: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

856:
857: IF ( funcmode = 'RUN' ) THEN
858:
859: x_progress := 'SHIP_QUANTITY_WITHIN_TOL:000';
860: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
861: itemkey => itemkey,
862: aname => 'PO_HEADER_ID');
863:
864: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 864: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

860: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
861: itemkey => itemkey,
862: aname => 'PO_HEADER_ID');
863:
864: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
865: itemkey => itemkey,
866: aname => 'CHANGE_REQUEST_GROUP_ID');
867:
868: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 868: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

864: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
865: itemkey => itemkey,
866: aname => 'CHANGE_REQUEST_GROUP_ID');
867:
868: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
869: itemkey => itemkey,
870: aname => 'PO_STYLE_TYPE');
871:
872: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 872: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

868: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
869: itemkey => itemkey,
870: aname => 'PO_STYLE_TYPE');
871:
872: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
873: itemkey => itemkey,
874: aname => 'DOCUMENT_TYPE');
875: x_progress := 'SHIP_QUANTITY_WITHIN_TOL:001';
876: IF (l_change_group_id IS NOT NULL) THEN

Line 882: l_ship_qty_max_incr_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,

878: -- check for the DOC types (applicable for PO and BPA release)
879: -- if other doc types return true and exit
880: IF (l_po_style_type='NORMAL') THEN
881:
882: l_ship_qty_max_incr_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,
883: itemkey => itemkey,
884: aname => 'SHIP_QUANTITY_INCR');
885:
886: l_shipq_ty_max_dec_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 886: l_shipq_ty_max_dec_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,

882: l_ship_qty_max_incr_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,
883: itemkey => itemkey,
884: aname => 'SHIP_QUANTITY_INCR');
885:
886: l_shipq_ty_max_dec_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,
887: itemkey => itemkey,
888: aname => 'SHIP_QUANTITY_DEC');
889: ELSIF (l_po_style_type='COMPLEX') THEN
890:

Line 891: l_ship_qty_max_incr_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,

887: itemkey => itemkey,
888: aname => 'SHIP_QUANTITY_DEC');
889: ELSIF (l_po_style_type='COMPLEX') THEN
890:
891: l_ship_qty_max_incr_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,
892: itemkey => itemkey,
893: aname => 'PAY_QUANTITY_INCR');
894:
895: l_shipq_ty_max_dec_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 895: l_shipq_ty_max_dec_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,

891: l_ship_qty_max_incr_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,
892: itemkey => itemkey,
893: aname => 'PAY_QUANTITY_INCR');
894:
895: l_shipq_ty_max_dec_per :=wf_engine.GetItemAttrNumber (itemtype => itemtype,
896: itemkey => itemkey,
897: aname => 'PAY_QUANTITY_DEC');
898: END IF;
899: x_progress := 'SHIP_QUANTITY_WITHIN_TOL:002';

Line 920: resultout := wf_engine.eng_completed|| ':' || l_return_val ;

916: END LOOP;
917: CLOSE c_ship_qty_changes;
918: END IF; -- change group Id is not null
919: -- set result value
920: resultout := wf_engine.eng_completed|| ':' || l_return_val ;
921: x_progress := 'SHIP_QUANTITY_WITHIN_TOL:005';
922: log_message('SHIP_QUANTITY_WITHIN_TOL','Result',resultout);
923:
924: END IF; -- IF ( funcmode = 'RUN' )

Line 1016: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1012:
1013: IF ( funcmode = 'RUN' ) THEN
1014:
1015: x_progress := 'DOC_AMOUNT_WITHIN_TOL:000';
1016: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1017: itemkey => itemkey,
1018: aname => 'PO_HEADER_ID');
1019:
1020: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1020: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1016: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1017: itemkey => itemkey,
1018: aname => 'PO_HEADER_ID');
1019:
1020: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => 'CHANGE_REQUEST_GROUP_ID');
1023:
1024: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1024: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1020: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => 'CHANGE_REQUEST_GROUP_ID');
1023:
1024: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1025: itemkey => itemkey,
1026: aname => 'PO_RELEASE_ID');
1027:
1028: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1028: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1024: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1025: itemkey => itemkey,
1026: aname => 'PO_RELEASE_ID');
1027:
1028: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1029: itemkey => itemkey,
1030: aname => 'PO_STYLE_TYPE');
1031:
1032: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1032: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1028: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1029: itemkey => itemkey,
1030: aname => 'PO_STYLE_TYPE');
1031:
1032: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1033: itemkey => itemkey,
1034: aname => 'DOCUMENT_TYPE');
1035:
1036: l_complex_po_style := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1036: l_complex_po_style := wf_engine.GetItemAttrText (itemtype => itemtype,

1032: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1033: itemkey => itemkey,
1034: aname => 'DOCUMENT_TYPE');
1035:
1036: l_complex_po_style := wf_engine.GetItemAttrText (itemtype => itemtype,
1037: itemkey => itemkey,
1038: aname => 'COMPLEX_PO_STYLE');
1039:
1040: x_progress := 'DOC_AMOUNT_WITHIN_TOL:001';

Line 1049: l_doc_amt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1045: -- check for the DOC types (applicable for PO Amount and BPA Release Amount)
1046: -- if other doc types return true and exit
1047: IF(l_doc_type = 'PO' OR l_doc_type = 'RELEASE') THEN
1048:
1049: l_doc_amt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1050: itemkey => itemkey,
1051: aname => 'DOC_AMOUNT_INCR_PER');
1052: l_doc_amt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1053: itemkey => itemkey,

Line 1052: l_doc_amt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1048:
1049: l_doc_amt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1050: itemkey => itemkey,
1051: aname => 'DOC_AMOUNT_INCR_PER');
1052: l_doc_amt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1053: itemkey => itemkey,
1054: aname => 'DOC_AMOUNT_DEC_PER');
1055:
1056: x_progress := 'DOC_AMOUNT_WITHIN_TOL:002';

Line 1060: l_doc_amt_max_incr_val :=wf_engine.GetItemAttrNumber (itemtype => itemtype,

1056: x_progress := 'DOC_AMOUNT_WITHIN_TOL:002';
1057: log_message('DOC_AMOUNT_WITHIN_TOL','Doc Amount Inc & Dec percentage',l_doc_amt_max_incr_per || ', '|| l_doc_amt_max_dec_per);
1058:
1059:
1060: l_doc_amt_max_incr_val :=wf_engine.GetItemAttrNumber (itemtype => itemtype,
1061: itemkey => itemkey,
1062: aname => 'DOC_AMOUNT_INCR_VAL');
1063: l_doc_amt_max_dec_val :=wf_engine.GetItemAttrNumber (itemtype => itemtype,
1064: itemkey => itemkey,

Line 1063: l_doc_amt_max_dec_val :=wf_engine.GetItemAttrNumber (itemtype => itemtype,

1059:
1060: l_doc_amt_max_incr_val :=wf_engine.GetItemAttrNumber (itemtype => itemtype,
1061: itemkey => itemkey,
1062: aname => 'DOC_AMOUNT_INCR_VAL');
1063: l_doc_amt_max_dec_val :=wf_engine.GetItemAttrNumber (itemtype => itemtype,
1064: itemkey => itemkey,
1065: aname => 'DOC_AMOUNT_DEC_VAL');
1066:
1067: x_progress := 'DOC_AMOUNT_WITHIN_TOL:003';

Line 1138: resultout := wf_engine.eng_completed|| ':' || l_return_val ;

1134:
1135: END IF; -- change group id is not null
1136:
1137: -- set result value
1138: resultout := wf_engine.eng_completed|| ':' || l_return_val ;
1139:
1140: x_progress := 'DOC_AMOUNT_WITHIN_TOL:013';
1141: log_message('DOC_AMOUNT_WITHIN_TOL','Result',resultout);
1142:

Line 1455: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1451: IF ( funcmode = 'RUN' ) THEN
1452:
1453: x_progress := 'LINE_AMOUNT_WITHIN_TOL:000';
1454:
1455: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1456: itemkey => itemkey,
1457: aname => 'PO_HEADER_ID');
1458:
1459: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1459: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1455: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1456: itemkey => itemkey,
1457: aname => 'PO_HEADER_ID');
1458:
1459: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1460: itemkey => itemkey,
1461: aname => 'PO_RELEASE_ID');
1462:
1463: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1463: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1459: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1460: itemkey => itemkey,
1461: aname => 'PO_RELEASE_ID');
1462:
1463: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1464: itemkey => itemkey,
1465: aname => 'PO_STYLE_TYPE');
1466:
1467: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1467: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1463: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1464: itemkey => itemkey,
1465: aname => 'PO_STYLE_TYPE');
1466:
1467: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1468: itemkey => itemkey,
1469: aname => 'DOCUMENT_TYPE');
1470:
1471: l_complex_po_style := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1471: l_complex_po_style := wf_engine.GetItemAttrText (itemtype => itemtype,

1467: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1468: itemkey => itemkey,
1469: aname => 'DOCUMENT_TYPE');
1470:
1471: l_complex_po_style := wf_engine.GetItemAttrText (itemtype => itemtype,
1472: itemkey => itemkey,
1473: aname => 'COMPLEX_PO_STYLE');
1474:
1475:

Line 1483: l_line_amt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1479: -- check for the DOC types (applicable for PO LINE AMOUNT( Line level)
1480: -- if other doc types return true and exit
1481: IF(l_doc_type = 'PO' OR l_doc_type = 'RELEASE') THEN
1482: -- get shipment quantity tolerances
1483: l_line_amt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1484: itemkey => itemkey,
1485: aname => 'LINE_AMOUNT_INCR_PER');
1486:
1487: l_line_amt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1487: l_line_amt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1483: l_line_amt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1484: itemkey => itemkey,
1485: aname => 'LINE_AMOUNT_INCR_PER');
1486:
1487: l_line_amt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1488: itemkey => itemkey,
1489: aname => 'LINE_AMOUNT_DEC_PER');
1490:
1491: x_progress := 'LINE_AMOUNT_WITHIN_TOL:002';

Line 1495: l_line_amt_max_incr_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1491: x_progress := 'LINE_AMOUNT_WITHIN_TOL:002';
1492: log_message('LINE_AMOUNT_WITHIN_TOL','Line Amount Incr & Decr Tol percentage',l_line_amt_max_incr_per || ', '|| l_line_amt_max_dec_per);
1493:
1494:
1495: l_line_amt_max_incr_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1496: itemkey => itemkey,
1497: aname => 'LINE_AMOUNT_INCR_VAL');
1498:
1499: l_line_amt_max_dec_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1499: l_line_amt_max_dec_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1495: l_line_amt_max_incr_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1496: itemkey => itemkey,
1497: aname => 'LINE_AMOUNT_INCR_VAL');
1498:
1499: l_line_amt_max_dec_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1500: itemkey => itemkey,
1501: aname => 'LINE_AMOUNT_DEC_VAL');
1502:
1503: x_progress := 'LINE_AMOUNT_WITHIN_TOL:003';

Line 1621: resultout := wf_engine.eng_completed|| ':' || l_return_val ;

1617: END IF; -- l_doc_type PO Or RELEASE
1618:
1619: END IF; -- l_po_header_id is not null
1620: -- set result value
1621: resultout := wf_engine.eng_completed|| ':' || l_return_val ;
1622: x_progress := 'LINE_AMOUNT_WITHIN_TOL:007';
1623: log_message('LINE_AMOUNT_WITHIN_TOL','Final result',resultout);
1624: END IF; -- IF ( funcmode = 'RUN' )
1625:

Line 1966: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1962:
1963: IF ( funcmode = 'RUN' ) THEN
1964: x_progress := 'SHIP_AMOUNT_WITHIN_TOL:000';
1965:
1966: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1967: itemkey => itemkey,
1968: aname => 'PO_HEADER_ID');
1969:
1970: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1970: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1966: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1967: itemkey => itemkey,
1968: aname => 'PO_HEADER_ID');
1969:
1970: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1971: itemkey => itemkey,
1972: aname => 'PO_RELEASE_ID');
1973:
1974: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1974: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1970: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1971: itemkey => itemkey,
1972: aname => 'PO_RELEASE_ID');
1973:
1974: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1975: itemkey => itemkey,
1976: aname => 'CHANGE_REQUEST_GROUP_ID');
1977:
1978: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1978: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1974: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1975: itemkey => itemkey,
1976: aname => 'CHANGE_REQUEST_GROUP_ID');
1977:
1978: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1979: itemkey => itemkey,
1980: aname => 'PO_STYLE_TYPE');
1981:
1982: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1982: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

1978: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1979: itemkey => itemkey,
1980: aname => 'PO_STYLE_TYPE');
1981:
1982: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
1983: itemkey => itemkey,
1984: aname => 'DOCUMENT_TYPE');
1985: x_progress := 'SHIP_AMOUNT_WITHIN_TOL:001';
1986:

Line 1995: l_shipamt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1991:
1992: IF (l_po_style_type='NORMAL') THEN
1993:
1994: -- get shipment quantity tolerances
1995: l_shipamt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1996: itemkey => itemkey,
1997: aname => 'SHIP_AMOUNT_INCR_PER');
1998:
1999: l_shipamt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1999: l_shipamt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1995: l_shipamt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1996: itemkey => itemkey,
1997: aname => 'SHIP_AMOUNT_INCR_PER');
1998:
1999: l_shipamt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2000: itemkey => itemkey,
2001: aname => 'SHIP_AMOUNT_DEC_PER');
2002:
2003: x_progress := 'SHIP_AMOUNT_WITHIN_TOL:002';

Line 2006: l_shipamt_max_incr_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2002:
2003: x_progress := 'SHIP_AMOUNT_WITHIN_TOL:002';
2004: log_message('SHIP_AMOUNT_WITHIN_TOL','Ship amount Incr & decr Percentage',l_shipamt_max_incr_per ||', '|| l_shipamt_max_dec_per);
2005: -- get shipment quantity tolerances
2006: l_shipamt_max_incr_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2007: itemkey => itemkey,
2008: aname => 'SHIP_AMOUNT_INCR_VAL');
2009:
2010: l_shipamt_max_dec_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2010: l_shipamt_max_dec_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2006: l_shipamt_max_incr_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2007: itemkey => itemkey,
2008: aname => 'SHIP_AMOUNT_INCR_VAL');
2009:
2010: l_shipamt_max_dec_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2011: itemkey => itemkey,
2012: aname => 'SHIP_AMOUNT_DEC_VAL');
2013:
2014: x_progress := 'SHIP_AMOUNT_WITHIN_TOL:003';

Line 2020: l_shipamt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2016:
2017: ELSIF (l_po_style_type='COMPLEX') THEN
2018: -- Complex Work PO Chack -- COMPLEX WORK
2019: -- get shipment quantity tolerances
2020: l_shipamt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2021: itemkey => itemkey,
2022: aname => 'PAY_AMOUNT_INCR_PER');
2023:
2024: l_shipamt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2024: l_shipamt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2020: l_shipamt_max_incr_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2021: itemkey => itemkey,
2022: aname => 'PAY_AMOUNT_INCR_PER');
2023:
2024: l_shipamt_max_dec_per := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2025: itemkey => itemkey,
2026: aname => 'PAY_AMOUNT_DEC_PER');
2027:
2028: x_progress := 'SHIP_AMOUNT_WITHIN_TOL:004';

Line 2031: l_shipamt_max_incr_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2027:
2028: x_progress := 'SHIP_AMOUNT_WITHIN_TOL:004';
2029: log_message('SHIP_AMOUNT_WITHIN_TOL','Ship amount Incr & decr Percentage',l_shipamt_max_incr_per ||', '|| l_shipamt_max_dec_per);
2030: -- get shipment quantity tolerances
2031: l_shipamt_max_incr_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2032: itemkey => itemkey,
2033: aname => 'PAY_AMOUNT_INCR_VAL');
2034:
2035: l_shipamt_max_dec_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2035: l_shipamt_max_dec_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2031: l_shipamt_max_incr_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2032: itemkey => itemkey,
2033: aname => 'PAY_AMOUNT_INCR_VAL');
2034:
2035: l_shipamt_max_dec_val := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2036: itemkey => itemkey,
2037: aname => 'PAY_AMOUNT_DEC_VAL');
2038: x_progress := 'SHIP_AMOUNT_WITHIN_TOL:005';
2039: log_message('SHIP_AMOUNT_WITHIN_TOL','Ship amount Incr & decr value', l_shipamt_max_incr_val ||', '|| l_shipamt_max_dec_val);

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

2062: END LOOP;
2063: CLOSE c_old_ship_amt;
2064:
2065: IF (l_return_val = 'Y') THEN
2066: wf_engine.SetItemAttrText( itemtype => itemtype,
2067: itemkey => itemkey,
2068: aname => 'NOTIF_USAGE',
2069: avalue => 'BUYER_AUTO_FYI');
2070: END IF;

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

2089: END LOOP;
2090: CLOSE c_old_ship_amt_rel;
2091:
2092: IF (l_return_val = 'Y') THEN
2093: wf_engine.SetItemAttrText( itemtype => itemtype,
2094: itemkey => itemkey,
2095: aname => 'NOTIF_USAGE',
2096: avalue => 'BUYER_AUTO_FYI');
2097: END IF;

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

2117: END LOOP;
2118: CLOSE c_old_ship_amt_cw;
2119:
2120: IF (l_return_val = 'Y') THEN
2121: wf_engine.SetItemAttrText( itemtype => itemtype,
2122: itemkey => itemkey,
2123: aname => 'NOTIF_USAGE',
2124: avalue => 'BUYER_AUTO_FYI');
2125: END IF;

Line 2130: resultout := wf_engine.eng_completed|| ':' || l_return_val ;

2126:
2127: END IF; -- PO Or RELEASE or complex work POs
2128: END IF; -- l_doc_type PO or RELEASE
2129: -- set result value
2130: resultout := wf_engine.eng_completed|| ':' || l_return_val ;
2131: END IF; -- change_group_id is not null
2132: x_progress := 'SHIP_AMOUNT_WITHIN_TOL:016';
2133: log_message('SHIP_AMOUNT_WITHIN_TOL','Result',resultout);
2134: END IF; -- IF ( funcmode = 'RUN' )

Line 2544: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2540: l_unit_price_app_flag VARCHAR2(10);
2541:
2542: BEGIN
2543: x_progress := 'ROUTE_TO_REQUESTER:000';
2544: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2545: itemkey => itemkey,
2546: aname => 'PO_HEADER_ID');
2547:
2548: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2548: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2544: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2545: itemkey => itemkey,
2546: aname => 'PO_HEADER_ID');
2547:
2548: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2549: itemkey => itemkey,
2550: aname => 'CHANGE_REQUEST_GROUP_ID');
2551:
2552: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2552: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

2548: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2549: itemkey => itemkey,
2550: aname => 'CHANGE_REQUEST_GROUP_ID');
2551:
2552: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2553: itemkey => itemkey,
2554: aname => 'PO_STYLE_TYPE');
2555:
2556: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2556: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

2552: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2553: itemkey => itemkey,
2554: aname => 'PO_STYLE_TYPE');
2555:
2556: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2557: itemkey => itemkey,
2558: aname => 'DOCUMENT_TYPE');
2559:
2560: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2560: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

2556: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2557: itemkey => itemkey,
2558: aname => 'DOCUMENT_TYPE');
2559:
2560: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2561: itemkey => itemkey,
2562: aname => 'DOC_SUB_TYPE');
2563:
2564: l_prmdate_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2564: l_prmdate_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,

2560: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2561: itemkey => itemkey,
2562: aname => 'DOC_SUB_TYPE');
2563:
2564: l_prmdate_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
2565: itemkey => itemkey,
2566: aname => 'PROMISE_DATE_APP_FLAG');
2567:
2568: l_shi_qty_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2568: l_shi_qty_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,

2564: l_prmdate_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
2565: itemkey => itemkey,
2566: aname => 'PROMISE_DATE_APP_FLAG');
2567:
2568: l_shi_qty_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
2569: itemkey => itemkey,
2570: aname => 'SHIP_QTY_APPROVAL_FLAG');
2571:
2572: l_unit_price_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2572: l_unit_price_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,

2568: l_shi_qty_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
2569: itemkey => itemkey,
2570: aname => 'SHIP_QTY_APPROVAL_FLAG');
2571:
2572: l_unit_price_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
2573: itemkey => itemkey,
2574: aname => 'PRICE_APPROVAL_FLAG');
2575:
2576: x_progress := 'ROUTE_TO_REQUESTER:001';

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

2582: l_return_val:= 'Y' ;
2583: x_progress := 'ROUTE_TO_REQUESTER:002';
2584: ELSE
2585: -- send the notification to buyer
2586: wf_engine.SetItemAttrText(itemtype => itemtype,
2587: itemkey => itemkey,
2588: aname => 'NOTIF_USAGE',
2589: avalue => 'BUYER');
2590: l_return_val:= 'N' ;

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

2591: x_progress := 'ROUTE_TO_REQUESTER:003';
2592: END IF;
2593:
2594: ELSE
2595: wf_engine.SetItemAttrText(itemtype => itemtype,
2596: itemkey => itemkey,
2597: aname => 'NOTIF_USAGE',
2598: avalue => 'BUYER');
2599: l_return_val:= 'N' ;

Line 2602: resultout := wf_engine.eng_completed|| ':' || l_return_val ;

2598: avalue => 'BUYER');
2599: l_return_val:= 'N' ;
2600: x_progress := 'ROUTE_TO_REQUESTER:004';
2601: END IF;
2602: resultout := wf_engine.eng_completed|| ':' || l_return_val ;
2603: x_progress := 'ROUTE_TO_REQUESTER:005';
2604: log_message('ROUTE_TO_REQUESTER','Result',resultout);
2605: EXCEPTION
2606: WHEN OTHERS THEN

Line 2855: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2851: BEGIN
2852:
2853: x_progress := 'ROUTE_SCO_BIZ_RULES:000';
2854:
2855: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2856: itemkey => itemkey,
2857: aname => 'PO_HEADER_ID');
2858:
2859: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2859: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2855: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2856: itemkey => itemkey,
2857: aname => 'PO_HEADER_ID');
2858:
2859: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2860: itemkey => itemkey,
2861: aname => 'PO_RELEASE_ID');
2862:
2863: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2863: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

2859: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2860: itemkey => itemkey,
2861: aname => 'PO_RELEASE_ID');
2862:
2863: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2864: itemkey => itemkey,
2865: aname => 'DOCUMENT_TYPE');
2866:
2867: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2867: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2863: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2864: itemkey => itemkey,
2865: aname => 'DOCUMENT_TYPE');
2866:
2867: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2868: itemkey => itemkey,
2869: aname => 'CHANGE_REQUEST_GROUP_ID');
2870:
2871: l_auto_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2871: l_auto_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,

2867: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2868: itemkey => itemkey,
2869: aname => 'CHANGE_REQUEST_GROUP_ID');
2870:
2871: l_auto_app_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
2872: itemkey => itemkey,
2873: aname => 'AUTO_APP_BIZ_RULES_FLAG');
2874:
2875: x_progress := 'ROUTE_SCO_BIZ_RULES:001';

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

2879: IF (ROUTE_SCO_BIZ_RULES_CHECK(l_po_header_id,l_po_release_id,l_doc_type,l_change_group_id)=FALSE) THEN
2880: l_return_val:= 'N';
2881: x_progress := 'ROUTE_SCO_BIZ_RULES:002';
2882: -- Set the Notif Usage for the notification to be sent to Buyer
2883: wf_engine.SetItemAttrText (itemtype => itemtype,
2884: itemkey => itemkey,
2885: aname => 'NOTIF_USAGE',
2886: avalue =>'BUYER');
2887: ELSE

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

2927:
2928: ELSIF( l_auto_app_flag = 'N') THEN
2929: l_return_val:= 'N';
2930: -- Set the Notif Usage for the notification to be sent to Buyer
2931: wf_engine.SetItemAttrText( itemtype => itemtype,
2932: itemkey => itemkey,
2933: aname => 'NOTIF_USAGE',
2934: avalue =>'BUYER');
2935: END IF;

Line 2938: resultout := wf_engine.eng_completed|| ':' || l_return_val ;

2934: avalue =>'BUYER');
2935: END IF;
2936:
2937:
2938: resultout := wf_engine.eng_completed|| ':' || l_return_val ;
2939:
2940: x_progress := 'ROUTE_SCO_BIZ_RULES:005';
2941: log_message('ROUTE_SCO_BIZ_RULES','Result',resultout);
2942:

Line 2975: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2971:
2972: BEGIN
2973: x_progress := 'AUTO_APP_BIZ_RULES:000';
2974:
2975: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2976: itemkey => itemkey,
2977: aname => 'PO_HEADER_ID');
2978:
2979: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 2979: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

2975: l_po_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2976: itemkey => itemkey,
2977: aname => 'PO_HEADER_ID');
2978:
2979: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2980: itemkey => itemkey,
2981: aname => 'PO_RELEASE_ID');
2982:
2983: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2983: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,

2979: l_po_release_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2980: itemkey => itemkey,
2981: aname => 'PO_RELEASE_ID');
2982:
2983: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2984: itemkey => itemkey,
2985: aname => 'PO_STYLE_TYPE');
2986:
2987: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2987: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

2983: l_po_style_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2984: itemkey => itemkey,
2985: aname => 'PO_STYLE_TYPE');
2986:
2987: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2988: itemkey => itemkey,
2989: aname => 'DOCUMENT_TYPE');
2990:
2991: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 2991: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,

2987: l_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2988: itemkey => itemkey,
2989: aname => 'DOCUMENT_TYPE');
2990:
2991: l_doc_subtype := wf_engine.GetItemAttrText (itemtype => itemtype,
2992: itemkey => itemkey,
2993: aname => 'DOC_SUB_TYPE');
2994:
2995: x_progress := 'AUTO_APP_BIZ_RULES:001';

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

2996:
2997: IF((l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD') OR (l_doc_type = 'RELEASE' AND l_doc_subtype = 'BLANKET')) THEN
2998: IF ( AUTO_APP_BIZ_RULES_CHECK(l_po_header_id,l_po_release_id,l_doc_type)=FALSE) THEN
2999:
3000: wf_engine.SetItemAttrText( itemtype => itemtype,
3001: itemkey => itemkey,
3002: aname => 'NOTIF_USAGE',
3003: avalue => 'BUYER');
3004:

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

3001: itemkey => itemkey,
3002: aname => 'NOTIF_USAGE',
3003: avalue => 'BUYER');
3004:
3005: wf_engine.SetItemAttrText( itemtype => itemtype,
3006: itemkey => itemkey,
3007: aname => 'AUTO_APP_BIZ_RULES_FLAG',
3008: avalue => 'N');
3009:

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

3010: x_progress := 'AUTO_APP_BIZ_RULES:002';
3011:
3012: l_return_val:= 'N';
3013: ELSE
3014: wf_engine.SetItemAttrText( itemtype => itemtype,
3015: itemkey => itemkey,
3016: aname => 'AUTO_APP_BIZ_RULES_FLAG',
3017: avalue => 'Y');
3018:

Line 3026: resultout := wf_engine.eng_completed|| ':' || l_return_val ;

3022: ELSE
3023: l_return_val := 'N';
3024: END IF;
3025:
3026: resultout := wf_engine.eng_completed|| ':' || l_return_val ;
3027: x_progress := 'AUTO_APP_BIZ_RULES:003';
3028:
3029: log_message('AUTO_APP_BIZ_RULES','Result',resultout);
3030:

Line 3786: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

3782: IF (funcmode = 'RUN') THEN
3783:
3784: x_progress := 'PROMISE_DATE_CHANGE:000';
3785:
3786: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
3787: itemkey => itemkey,
3788: aname => 'PO_HEADER_ID');
3789:
3790: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 3790: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

3786: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
3787: itemkey => itemkey,
3788: aname => 'PO_HEADER_ID');
3789:
3790: l_change_group_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3791: itemkey => itemkey,
3792: aname => 'CHANGE_REQUEST_GROUP_ID');
3793: -- IF only a promise date change return yes otherwise no
3794:

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

3792: aname => 'CHANGE_REQUEST_GROUP_ID');
3793: -- IF only a promise date change return yes otherwise no
3794:
3795: IF PROMISEDATECHANGE(l_po_header_id,l_change_group_id)=TRUE THEN
3796: resultout := wf_engine.eng_completed || ':' || 'Y';
3797: ELSE
3798: resultout := wf_engine.eng_completed || ':' || 'N';
3799: END IF;
3800: x_progress:= 'PROMISE_DATE_CHANGE:001';

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

3794:
3795: IF PROMISEDATECHANGE(l_po_header_id,l_change_group_id)=TRUE THEN
3796: resultout := wf_engine.eng_completed || ':' || 'Y';
3797: ELSE
3798: resultout := wf_engine.eng_completed || ':' || 'N';
3799: END IF;
3800: x_progress:= 'PROMISE_DATE_CHANGE:001';
3801: log_message('PROMISE_DATE_CHANGE','Only promised date changed',resultout);
3802: return;

Line 3958: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

3954: x_progress VARCHAR2(1000);
3955:
3956: BEGIN
3957: x_progress := 'INITIATE_RCO_FLOW:000';
3958: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
3959: itemkey => itemkey,
3960: aname => 'PO_HEADER_ID');
3961: l_po_release_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
3962: itemkey => itemkey,

Line 3961: l_po_release_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

3957: x_progress := 'INITIATE_RCO_FLOW:000';
3958: l_po_header_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
3959: itemkey => itemkey,
3960: aname => 'PO_HEADER_ID');
3961: l_po_release_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
3962: itemkey => itemkey,
3963: aname => 'PO_RELEASE_ID');
3964:
3965:

Line 3973: wf_engine.SetItemAttrNumber( itemtype => itemtype,

3969: -- set the x_change_request_group_id number
3970: x_progress:= 'INITIATE_RCO_FLOW:002';
3971: log_message('INITIATE_RCO_FLOW','Change Req Group Id',l_change_group_id);
3972:
3973: wf_engine.SetItemAttrNumber( itemtype => itemtype,
3974: itemkey => itemkey,
3975: aname => 'REQ_CHANGE_REQUEST_GROUP_ID',
3976: avalue => l_change_group_id);
3977:

Line 3978: resultout:=wf_engine.eng_completed;

3974: itemkey => itemkey,
3975: aname => 'REQ_CHANGE_REQUEST_GROUP_ID',
3976: avalue => l_change_group_id);
3977:
3978: resultout:=wf_engine.eng_completed;
3979: x_progress := 'INITIATE_RCO_FLOW:003';
3980:
3981: EXCEPTION
3982:

Line 4378: l_change_group_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

4374: BEGIN
4375:
4376: x_progress := 'START_RCO_WORKFLOW:000';
4377:
4378: l_change_group_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
4379: itemkey => itemkey,
4380: aname => 'REQ_CHANGE_REQUEST_GROUP_ID');
4381:
4382: x_progress := 'START_RCO_WORKFLOW:001';

Line 4391: resultout:=wf_engine.eng_completed;

4387:
4388:
4389: STARTRCOWORKFLOW (l_change_group_id);
4390:
4391: resultout:=wf_engine.eng_completed;
4392:
4393: x_progress := 'START_RCO_WORKFLOW:002';
4394:
4395:

Line 4539: l_change_group_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

4535: x_progress :='MARK_SCO_FOR_REQ:000';
4536:
4537: --Bug 11732340
4538: --Change group id to get the requester
4539: l_change_group_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
4540: itemkey => itemkey,
4541: aname => 'CHANGE_REQUEST_GROUP_ID');
4542:
4543: /*

Line 4546: l_po_header_id :=wf_engine.GetItemAttrNumber(itemtype => itemtype,

4542:
4543: /*
4544: OPEN l_planners_csr(l_change_group_id );
4545: */
4546: l_po_header_id :=wf_engine.GetItemAttrNumber(itemtype => itemtype,
4547: itemkey => itemkey,
4548: aname => 'PO_HEADER_ID');
4549:
4550: count_rec := 0;

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

4576:
4577: x_progress:= 'MARK_SCO_FOR_REQ:002';
4578: log_message('MARK_SCO_FOR_REQ','Planner User Name ',l_planner_username);
4579:
4580: wf_engine.SetItemAttrText(itemtype => itemtype,
4581: itemkey => itemkey,
4582: aname => 'PREPARER_USERNAME',
4583: avalue => l_planner_username);
4584: ELSE

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

4595:
4596: x_progress:= 'MARK_SCO_FOR_REQ:004';
4597: log_message('MARK_SCO_FOR_REQ','Requester User Name ',l_requester_username);
4598:
4599: wf_engine.SetItemAttrText(itemtype => itemtype,
4600: itemkey => itemkey,
4601: aname => 'PREPARER_USERNAME',
4602: avalue => l_requester_username);
4603: END IF;

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

4600: itemkey => itemkey,
4601: aname => 'PREPARER_USERNAME',
4602: avalue => l_requester_username);
4603: END IF;
4604: wf_engine.SetItemAttrText(itemtype => itemtype,
4605: itemkey => itemkey,
4606: aname => 'NOTIF_USAGE',
4607: avalue =>'REQ');
4608: update po_change_requests

Line 4616: resultout:=wf_engine.eng_completed;

4612: where change_request_group_id = l_change_group_id
4613: AND request_status = 'PENDING';
4614:
4615:
4616: resultout:=wf_engine.eng_completed;
4617:
4618: x_progress := 'MARK_SCO_FOR_REQ:005';
4619:
4620: