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

Line 166: WF_Engine.CreateProcess

162: L_WF_PROCESS || ':' ||
163: P_Deliverable_ID || ':' ||
164: to_char(sysdate , 'DDMONRRHH24MISS');
165:
166: WF_Engine.CreateProcess
167: ( ItemType => L_WF_Item_Type
168: , ItemKey => L_WF_Item_Key
169: , Process => L_WF_Process);
170:

Line 171: WF_Engine.SetItemOwner

167: ( ItemType => L_WF_Item_Type
168: , ItemKey => L_WF_Item_Key
169: , Process => L_WF_Process);
170:
171: WF_Engine.SetItemOwner
172: ( ItemType => L_WF_Item_Type
173: , ItemKey => L_WF_Item_Key
174: , Owner => FND_GLOBAL.User_Name);
175:

Line 176: WF_Engine.SetItemUserKey

172: ( ItemType => L_WF_Item_Type
173: , ItemKey => L_WF_Item_Key
174: , Owner => FND_GLOBAL.User_Name);
175:
176: WF_Engine.SetItemUserKey
177: ( ItemType => L_WF_Item_Type
178: , ItemKey => L_WF_Item_Key
179: , UserKey => L_WF_User_Key);
180:

Line 184: WF_ENGINE.SetItemAttrNumber

180:
181: --
182: -- Setting various Workflow Item Attributes
183: --
184: WF_ENGINE.SetItemAttrNumber
185: ( ItemType => L_WF_Item_Type
186: , ItemKey => L_WF_Item_Key
187: , AName => 'API_VERSION'
188: , AValue => P_API_VERSION );

Line 190: WF_ENGINE.SetItemAttrNumber

186: , ItemKey => L_WF_Item_Key
187: , AName => 'API_VERSION'
188: , AValue => P_API_VERSION );
189:
190: WF_ENGINE.SetItemAttrNumber
191: ( ItemType => L_WF_Item_Type
192: , ItemKey => L_WF_Item_Key
193: , AName => 'ORG_ID'
194: , AValue => l_org_id );

Line 196: WF_ENGINE.SetItemAttrNumber

192: , ItemKey => L_WF_Item_Key
193: , AName => 'ORG_ID'
194: , AValue => l_org_id );
195:
196: WF_ENGINE.SetItemAttrNumber
197: ( ItemType => L_WF_Item_Type
198: , ItemKey => L_WF_Item_Key
199: , AName => 'K_HEADER_ID'
200: , AValue => P_K_HEADER_ID );

Line 202: WF_ENGINE.SetItemAttrNumber

198: , ItemKey => L_WF_Item_Key
199: , AName => 'K_HEADER_ID'
200: , AValue => P_K_HEADER_ID );
201:
202: WF_ENGINE.SetItemAttrNumber
203: ( ItemType => L_WF_Item_Type
204: , ItemKey => L_WF_Item_Key
205: , AName => 'DELIVERABLE_ID'
206: , AValue => P_DELIVERABLE_ID );

Line 208: WF_ENGINE.SetItemAttrText

204: , ItemKey => L_WF_Item_Key
205: , AName => 'DELIVERABLE_ID'
206: , AValue => P_DELIVERABLE_ID );
207:
208: WF_ENGINE.SetItemAttrText
209: ( ItemType => L_WF_Item_Type
210: , ItemKey => L_WF_Item_Key
211: , AName => 'DELIVERABLE_NUM'
212: , AValue => P_DELIVERABLE_NUM );

Line 214: WF_ENGINE.SetItemAttrText

210: , ItemKey => L_WF_Item_Key
211: , AName => 'DELIVERABLE_NUM'
212: , AValue => P_DELIVERABLE_NUM );
213:
214: WF_ENGINE.SetItemAttrText
215: ( ItemType => L_WF_Item_Type
216: , ItemKey => L_WF_Item_Key
217: , AName => 'ITEM_NUM'
218: , AValue => P_ITEM_NUMBER );

Line 220: WF_ENGINE.SetItemAttrText

216: , ItemKey => L_WF_Item_Key
217: , AName => 'ITEM_NUM'
218: , AValue => P_ITEM_NUMBER );
219:
220: WF_ENGINE.SetItemAttrText
221: ( ItemType => L_WF_Item_Type
222: , ItemKey => L_WF_Item_Key
223: , AName => 'K_NUMBER'
224: , AValue => P_K_NUMBER );

Line 226: WF_ENGINE.SetItemAttrText

222: , ItemKey => L_WF_Item_Key
223: , AName => 'K_NUMBER'
224: , AValue => P_K_NUMBER );
225:
226: WF_ENGINE.SetItemAttrText
227: ( ItemType => L_WF_Item_Type
228: , ItemKey => L_WF_Item_Key
229: , AName => 'LINE_NUMBER'
230: , AValue => P_LINE_NUMBER );

Line 232: WF_ENGINE.SetItemAttrText

228: , ItemKey => L_WF_Item_Key
229: , AName => 'LINE_NUMBER'
230: , AValue => P_LINE_NUMBER );
231:
232: WF_ENGINE.SetItemAttrText
233: ( ItemType => L_WF_Item_Type
234: , ItemKey => L_WF_Item_Key
235: , AName => 'SOURCE_CODE'
236: , AValue => P_SOURCE_CODE);

Line 238: WF_ENGINE.SetItemAttrText

234: , ItemKey => L_WF_Item_Key
235: , AName => 'SOURCE_CODE'
236: , AValue => P_SOURCE_CODE);
237:
238: WF_ENGINE.SetItemAttrText
239: ( ItemType => L_WF_Item_Type
240: , ItemKey => L_WF_Item_Key
241: , AName => 'USAGE_CODE'
242: , AValue => P_USAGE_CODE);

Line 244: WF_ENGINE.SetItemAttrText

240: , ItemKey => L_WF_Item_Key
241: , AName => 'USAGE_CODE'
242: , AValue => P_USAGE_CODE);
243:
244: WF_ENGINE.SetItemAttrText
245: ( ItemType => L_WF_Item_Type
246: , ItemKey => L_WF_Item_Key
247: , AName => 'DESCRIPTION'
248: , AValue => P_DESCRIPTION);

Line 250: WF_ENGINE.SetItemAttrText

246: , ItemKey => L_WF_Item_Key
247: , AName => 'DESCRIPTION'
248: , AValue => P_DESCRIPTION);
249:
250: WF_ENGINE.SetItemAttrText
251: ( ItemType => L_WF_Item_Type
252: , ItemKey => L_WF_Item_Key
253: , AName => 'DOC_TYPE'
254: , AValue => P_DOC_TYPE);

Line 256: WF_ENGINE.SetItemAttrText

252: , ItemKey => L_WF_Item_Key
253: , AName => 'DOC_TYPE'
254: , AValue => P_DOC_TYPE);
255:
256: WF_ENGINE.SetItemAttrText
257: ( ItemType => L_WF_Item_Type
258: , ItemKey => L_WF_Item_Key
259: , AName => 'DTS_WF_MODE'
260: , AValue => P_DTS_WF_MODE );

Line 262: WF_ENGINE.SetItemAttrText

258: , ItemKey => L_WF_Item_Key
259: , AName => 'DTS_WF_MODE'
260: , AValue => P_DTS_WF_MODE );
261:
262: WF_ENGINE.SetItemAttrText
263: ( ItemType => L_WF_Item_Type
264: , ItemKey => L_WF_Item_Key
265: , AName => 'REQUESTOR'
266: , AValue => FND_GLOBAL.User_Name );

Line 272: WF_ENGINE.StartProcess( ItemType => L_WF_Item_Type

268: ------------------------------------------------------------------------------
269: --
270: -- Start the Workflow Process
271: --
272: WF_ENGINE.StartProcess( ItemType => L_WF_Item_Type
273: , ItemKey => L_WF_Item_Key );
274:
275: update oke_k_deliverables_b
276: set wf_item_key = L_WF_Item_Key

Line 378: L_K_Header_ID := WF_Engine.GetItemAttrNumber

374: BEGIN
375:
376: IF ( FuncMode = 'RUN' ) THEN
377:
378: L_K_Header_ID := WF_Engine.GetItemAttrNumber
379: ( ItemType => ItemType
380: , ItemKey => ItemKey
381: , AName => 'K_HEADER_ID'
382: );

Line 384: L_Deliverable_Id := WF_Engine.GetItemAttrNumber

380: , ItemKey => ItemKey
381: , AName => 'K_HEADER_ID'
382: );
383:
384: L_Deliverable_Id := WF_Engine.GetItemAttrNumber
385: ( ItemType => ItemType
386: , ItemKey => ItemKey
387: , AName => 'DELIVERABLE_ID'
388: );

Line 390: L_Due_Ntf_Id := WF_Engine.GetItemAttrNumber

386: , ItemKey => ItemKey
387: , AName => 'DELIVERABLE_ID'
388: );
389:
390: L_Due_Ntf_Id := WF_Engine.GetItemAttrNumber
391: ( ItemType => ItemType
392: , ItemKey => ItemKey
393: , AName => 'DUE_NTF_ID'
394: );

Line 396: L_Source_Code := WF_Engine.GetItemAttrText

392: , ItemKey => ItemKey
393: , AName => 'DUE_NTF_ID'
394: );
395:
396: L_Source_Code := WF_Engine.GetItemAttrText
397: ( ItemType => ItemType
398: , ItemKey => ItemKey
399: , AName => 'SOURCE_CODE'
400: );

Line 402: L_Usage_Code := WF_Engine.GetItemAttrText

398: , ItemKey => ItemKey
399: , AName => 'SOURCE_CODE'
400: );
401:
402: L_Usage_Code := WF_Engine.GetItemAttrText
403: ( ItemType => ItemType
404: , ItemKey => ItemKey
405: , AName => 'USAGE_CODE'
406: );

Line 408: L_Target_Date := WF_Engine.GetItemAttrText

404: , ItemKey => ItemKey
405: , AName => 'USAGE_CODE'
406: );
407:
408: L_Target_Date := WF_Engine.GetItemAttrText
409: ( ItemType => ItemType
410: , ItemKey => ItemKey
411: , AName => 'TARGET_DATE'
412: );

Line 414: L_Before_After := WF_Engine.GetItemAttrText

410: , ItemKey => ItemKey
411: , AName => 'TARGET_DATE'
412: );
413:
414: L_Before_After := WF_Engine.GetItemAttrText
415: ( ItemType => ItemType
416: , ItemKey => ItemKey
417: , AName => 'BEFORE_AFTER'
418: );

Line 420: L_Duration_Days := WF_Engine.GetItemAttrNumber

416: , ItemKey => ItemKey
417: , AName => 'BEFORE_AFTER'
418: );
419:
420: L_Duration_Days := WF_Engine.GetItemAttrNumber
421: ( ItemType => ItemType
422: , ItemKey => ItemKey
423: , AName => 'DURATION_DAYS'
424: );

Line 432: WF_ENGINE.SetItemAttrNumber

428: FETCH CSR_DUE_NTF INTO REC_DUE_NTF;
429: CLOSE CSR_DUE_NTF;
430:
431: IF REC_DUE_NTF.ID IS NULL THEN
432: WF_ENGINE.SetItemAttrNumber
433: ( ItemType => ItemType
434: , ItemKey => ItemKey
435: , AName => 'DUE_NTF_ID'
436: , AValue => NULL );

Line 441: WF_ENGINE.SetItemAttrNumber

437:
438: ResultOut := 'COMPLETE:F';
439: RETURN;
440: ELSE
441: WF_ENGINE.SetItemAttrNumber
442: ( ItemType => ItemType
443: , ItemKey => ItemKey
444: , AName => 'DUE_NTF_ID'
445: , AValue => REC_DUE_NTF.ID );

Line 447: WF_ENGINE.SetItemAttrText

443: , ItemKey => ItemKey
444: , AName => 'DUE_NTF_ID'
445: , AValue => REC_DUE_NTF.ID );
446:
447: WF_ENGINE.SetItemAttrText
448: ( ItemType => ItemType
449: , ItemKey => ItemKey
450: , AName => 'SOURCE_CODE'
451: , AValue => REC_DUE_NTF.SOURCE_CODE );

Line 453: WF_ENGINE.SetItemAttrText

449: , ItemKey => ItemKey
450: , AName => 'SOURCE_CODE'
451: , AValue => REC_DUE_NTF.SOURCE_CODE );
452:
453: WF_ENGINE.SetItemAttrText
454: ( ItemType => ItemType
455: , ItemKey => ItemKey
456: , AName => 'USAGE_CODE'
457: , AValue => REC_DUE_NTF.USAGE_CODE );

Line 459: WF_ENGINE.SetItemAttrText

455: , ItemKey => ItemKey
456: , AName => 'USAGE_CODE'
457: , AValue => REC_DUE_NTF.USAGE_CODE );
458:
459: WF_ENGINE.SetItemAttrText
460: ( ItemType => ItemType
461: , ItemKey => ItemKey
462: , AName => 'TARGET_DATE'
463: , AValue => REC_DUE_NTF.TARGET_DATE );

Line 465: WF_ENGINE.SetItemAttrText

461: , ItemKey => ItemKey
462: , AName => 'TARGET_DATE'
463: , AValue => REC_DUE_NTF.TARGET_DATE );
464:
465: WF_ENGINE.SetItemAttrText
466: ( ItemType => ItemType
467: , ItemKey => ItemKey
468: , AName => 'BEFORE_AFTER'
469: , AValue => REC_DUE_NTF.BEFORE_AFTER );

Line 471: WF_ENGINE.SetItemAttrNumber

467: , ItemKey => ItemKey
468: , AName => 'BEFORE_AFTER'
469: , AValue => REC_DUE_NTF.BEFORE_AFTER );
470:
471: WF_ENGINE.SetItemAttrNumber
472: ( ItemType => ItemType
473: , ItemKey => ItemKey
474: , AName => 'DURATION_DAYS'
475: , AValue => REC_DUE_NTF.DURATION_DAYS );

Line 477: WF_ENGINE.SetItemAttrText

473: , ItemKey => ItemKey
474: , AName => 'DURATION_DAYS'
475: , AValue => REC_DUE_NTF.DURATION_DAYS );
476:
477: WF_ENGINE.SetItemAttrText
478: ( ItemType => ItemType
479: , ItemKey => ItemKey
480: , AName => 'RECIPIENT'
481: , AValue => REC_DUE_NTF.RECIPIENT );

Line 483: WF_ENGINE.SetItemAttrNumber

479: , ItemKey => ItemKey
480: , AName => 'RECIPIENT'
481: , AValue => REC_DUE_NTF.RECIPIENT );
482:
483: WF_ENGINE.SetItemAttrNumber
484: ( ItemType => ItemType
485: , ItemKey => ItemKey
486: , AName => 'ROLE_ID'
487: , AValue => REC_DUE_NTF.ROLE_ID );

Line 490: WF_ENGINE.SetItemAttrText

486: , AName => 'ROLE_ID'
487: , AValue => REC_DUE_NTF.ROLE_ID );
488:
489: IF REC_DUE_NTF.RECIPIENT='REQUESTOR' THEN
490: WF_ENGINE.SetItemAttrText
491: ( ItemType => ItemType
492: , ItemKey => ItemKey
493: , AName => 'PERFORMER'
494: , AValue => FND_GLOBAL.User_Name);

Line 502: WF_ENGINE.SetItemAttrText

498: -- CLOSE CSR_ESC;
499:
500: L_Performer := OKE_UTILS.Retrieve_WF_Role_Name(L_K_Header_ID,REC_DUE_NTF.ROLE_ID);
501:
502: WF_ENGINE.SetItemAttrText
503: ( ItemType => ItemType
504: , ItemKey => ItemKey
505: , AName => 'PERFORMER'
506: , AValue => L_Performer );

Line 509: WF_ENGINE.SetItemAttrText

505: , AName => 'PERFORMER'
506: , AValue => L_Performer );
507:
508: ELSE
509: WF_ENGINE.SetItemAttrText
510: ( ItemType => ItemType
511: , ItemKey => ItemKey
512: , AName => 'PERFORMER'
513: , AValue => FND_GLOBAL.User_Name);

Line 534: WF_ENGINE.SetItemAttrText

530:
531: EXCEPTION
532: WHEN OTHERS THEN
533: ResultOut := 'ERROR:';
534: WF_ENGINE.SetItemAttrText
535: ( ItemType => ItemType
536: , ItemKey => ItemKey
537: , AName => 'ERRORTEXT'
538: , AValue => sqlerrm );

Line 616: L_K_Header_ID := WF_Engine.GetItemAttrNumber

612: BEGIN
613:
614: IF ( FuncMode = 'RUN' ) THEN
615:
616: L_K_Header_ID := WF_Engine.GetItemAttrNumber
617: ( ItemType => ItemType
618: , ItemKey => ItemKey
619: , AName => 'K_HEADER_ID'
620: );

Line 622: L_Deliverable_Id := WF_Engine.GetItemAttrNumber

618: , ItemKey => ItemKey
619: , AName => 'K_HEADER_ID'
620: );
621:
622: L_Deliverable_Id := WF_Engine.GetItemAttrNumber
623: ( ItemType => ItemType
624: , ItemKey => ItemKey
625: , AName => 'DELIVERABLE_ID'
626: );

Line 628: L_Due_Ntf_Id := WF_Engine.GetItemAttrNumber

624: , ItemKey => ItemKey
625: , AName => 'DELIVERABLE_ID'
626: );
627:
628: L_Due_Ntf_Id := WF_Engine.GetItemAttrNumber
629: ( ItemType => ItemType
630: , ItemKey => ItemKey
631: , AName => 'DUE_NTF_ID'
632: );

Line 634: L_Source_Code := WF_Engine.GetItemAttrText

630: , ItemKey => ItemKey
631: , AName => 'DUE_NTF_ID'
632: );
633:
634: L_Source_Code := WF_Engine.GetItemAttrText
635: ( ItemType => ItemType
636: , ItemKey => ItemKey
637: , AName => 'SOURCE_CODE'
638: );

Line 640: L_Usage_Code := WF_Engine.GetItemAttrText

636: , ItemKey => ItemKey
637: , AName => 'SOURCE_CODE'
638: );
639:
640: L_Usage_Code := WF_Engine.GetItemAttrText
641: ( ItemType => ItemType
642: , ItemKey => ItemKey
643: , AName => 'USAGE_CODE'
644: );

Line 646: L_Target_Date := WF_Engine.GetItemAttrText

642: , ItemKey => ItemKey
643: , AName => 'USAGE_CODE'
644: );
645:
646: L_Target_Date := WF_Engine.GetItemAttrText
647: ( ItemType => ItemType
648: , ItemKey => ItemKey
649: , AName => 'TARGET_DATE'
650: );

Line 652: L_Before_After := WF_Engine.GetItemAttrText

648: , ItemKey => ItemKey
649: , AName => 'TARGET_DATE'
650: );
651:
652: L_Before_After := WF_Engine.GetItemAttrText
653: ( ItemType => ItemType
654: , ItemKey => ItemKey
655: , AName => 'BEFORE_AFTER'
656: );

Line 658: L_Duration_Days := WF_Engine.GetItemAttrNumber

654: , ItemKey => ItemKey
655: , AName => 'BEFORE_AFTER'
656: );
657:
658: L_Duration_Days := WF_Engine.GetItemAttrNumber
659: ( ItemType => ItemType
660: , ItemKey => ItemKey
661: , AName => 'DURATION_DAYS'
662: );

Line 670: WF_ENGINE.SetItemAttrNumber

666: FETCH CSR_DUE_NTF INTO REC_DUE_NTF;
667: CLOSE CSR_DUE_NTF;
668:
669: IF REC_DUE_NTF.ID IS NULL THEN
670: WF_ENGINE.SetItemAttrNumber
671: ( ItemType => ItemType
672: , ItemKey => ItemKey
673: , AName => 'DUE_NTF_ID'
674: , AValue => NULL );

Line 679: WF_ENGINE.SetItemAttrNumber

675:
676: ResultOut := 'COMPLETE:F';
677: RETURN;
678: ELSE
679: WF_ENGINE.SetItemAttrNumber
680: ( ItemType => ItemType
681: , ItemKey => ItemKey
682: , AName => 'DUE_NTF_ID'
683: , AValue => REC_DUE_NTF.ID );

Line 685: WF_ENGINE.SetItemAttrText

681: , ItemKey => ItemKey
682: , AName => 'DUE_NTF_ID'
683: , AValue => REC_DUE_NTF.ID );
684:
685: WF_ENGINE.SetItemAttrText
686: ( ItemType => ItemType
687: , ItemKey => ItemKey
688: , AName => 'SOURCE_CODE'
689: , AValue => REC_DUE_NTF.SOURCE_CODE );

Line 691: WF_ENGINE.SetItemAttrText

687: , ItemKey => ItemKey
688: , AName => 'SOURCE_CODE'
689: , AValue => REC_DUE_NTF.SOURCE_CODE );
690:
691: WF_ENGINE.SetItemAttrText
692: ( ItemType => ItemType
693: , ItemKey => ItemKey
694: , AName => 'USAGE_CODE'
695: , AValue => REC_DUE_NTF.USAGE_CODE );

Line 697: WF_ENGINE.SetItemAttrText

693: , ItemKey => ItemKey
694: , AName => 'USAGE_CODE'
695: , AValue => REC_DUE_NTF.USAGE_CODE );
696:
697: WF_ENGINE.SetItemAttrText
698: ( ItemType => ItemType
699: , ItemKey => ItemKey
700: , AName => 'TARGET_DATE'
701: , AValue => REC_DUE_NTF.TARGET_DATE );

Line 703: WF_ENGINE.SetItemAttrText

699: , ItemKey => ItemKey
700: , AName => 'TARGET_DATE'
701: , AValue => REC_DUE_NTF.TARGET_DATE );
702:
703: WF_ENGINE.SetItemAttrText
704: ( ItemType => ItemType
705: , ItemKey => ItemKey
706: , AName => 'BEFORE_AFTER'
707: , AValue => REC_DUE_NTF.BEFORE_AFTER );

Line 709: WF_ENGINE.SetItemAttrNumber

705: , ItemKey => ItemKey
706: , AName => 'BEFORE_AFTER'
707: , AValue => REC_DUE_NTF.BEFORE_AFTER );
708:
709: WF_ENGINE.SetItemAttrNumber
710: ( ItemType => ItemType
711: , ItemKey => ItemKey
712: , AName => 'DURATION_DAYS'
713: , AValue => REC_DUE_NTF.DURATION_DAYS );

Line 715: WF_ENGINE.SetItemAttrText

711: , ItemKey => ItemKey
712: , AName => 'DURATION_DAYS'
713: , AValue => REC_DUE_NTF.DURATION_DAYS );
714:
715: WF_ENGINE.SetItemAttrText
716: ( ItemType => ItemType
717: , ItemKey => ItemKey
718: , AName => 'RECIPIENT'
719: , AValue => REC_DUE_NTF.RECIPIENT );

Line 721: WF_ENGINE.SetItemAttrNumber

717: , ItemKey => ItemKey
718: , AName => 'RECIPIENT'
719: , AValue => REC_DUE_NTF.RECIPIENT );
720:
721: WF_ENGINE.SetItemAttrNumber
722: ( ItemType => ItemType
723: , ItemKey => ItemKey
724: , AName => 'ROLE_ID'
725: , AValue => REC_DUE_NTF.ROLE_ID );

Line 728: WF_ENGINE.SetItemAttrText

724: , AName => 'ROLE_ID'
725: , AValue => REC_DUE_NTF.ROLE_ID );
726:
727: IF REC_DUE_NTF.RECIPIENT='REQUESTOR' THEN
728: WF_ENGINE.SetItemAttrText
729: ( ItemType => ItemType
730: , ItemKey => ItemKey
731: , AName => 'PERFORMER'
732: , AValue => FND_GLOBAL.User_Name);

Line 740: WF_ENGINE.SetItemAttrText

736: -- CLOSE CSR_ESC;
737:
738: L_Performer := OKE_UTILS.Retrieve_WF_Role_Name(L_K_Header_ID,REC_DUE_NTF.ROLE_ID);
739:
740: WF_ENGINE.SetItemAttrText
741: ( ItemType => ItemType
742: , ItemKey => ItemKey
743: , AName => 'PERFORMER'
744: , AValue => L_Performer );

Line 747: WF_ENGINE.SetItemAttrText

743: , AName => 'PERFORMER'
744: , AValue => L_Performer );
745:
746: ELSE
747: WF_ENGINE.SetItemAttrText
748: ( ItemType => ItemType
749: , ItemKey => ItemKey
750: , AName => 'PERFORMER'
751: , AValue => FND_GLOBAL.User_Name);

Line 772: WF_ENGINE.SetItemAttrText

768:
769: EXCEPTION
770: WHEN OTHERS THEN
771: ResultOut := 'ERROR:';
772: WF_ENGINE.SetItemAttrText
773: ( ItemType => ItemType
774: , ItemKey => ItemKey
775: , AName => 'ERRORTEXT'
776: , AValue => sqlerrm );

Line 818: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

814:
815: BEGIN
816: IF ( FuncMode = 'RUN' ) THEN
817:
818: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
819: ( ItemType => ItemType
820: , ItemKey => ItemKey
821: , AName => 'DELIVERABLE_ID'
822: );

Line 824: L_Due_Ntf_ID := WF_Engine.GetItemAttrNumber

820: , ItemKey => ItemKey
821: , AName => 'DELIVERABLE_ID'
822: );
823:
824: L_Due_Ntf_ID := WF_Engine.GetItemAttrNumber
825: ( ItemType => ItemType
826: , ItemKey => ItemKey
827: , AName => 'DUE_NTF_ID'
828: );

Line 830: L_Source_Code := WF_Engine.GetItemAttrText

826: , ItemKey => ItemKey
827: , AName => 'DUE_NTF_ID'
828: );
829:
830: L_Source_Code := WF_Engine.GetItemAttrText
831: ( ItemType => ItemType
832: , ItemKey => ItemKey
833: , AName => 'SOURCE_CODE'
834: );

Line 836: L_Usage_Code := WF_Engine.GetItemAttrText

832: , ItemKey => ItemKey
833: , AName => 'SOURCE_CODE'
834: );
835:
836: L_Usage_Code := WF_Engine.GetItemAttrText
837: ( ItemType => ItemType
838: , ItemKey => ItemKey
839: , AName => 'USAGE_CODE'
840: );

Line 842: L_Target_date := WF_Engine.GetItemAttrText

838: , ItemKey => ItemKey
839: , AName => 'USAGE_CODE'
840: );
841:
842: L_Target_date := WF_Engine.GetItemAttrText
843: ( ItemType => ItemType
844: , ItemKey => ItemKey
845: , AName => 'TARGET_DATE'
846: );

Line 848: L_Before_After := WF_Engine.GetItemAttrText

844: , ItemKey => ItemKey
845: , AName => 'TARGET_DATE'
846: );
847:
848: L_Before_After := WF_Engine.GetItemAttrText
849: ( ItemType => ItemType
850: , ItemKey => ItemKey
851: , AName => 'BEFORE_AFTER'
852: );

Line 854: L_Duration_Days := WF_Engine.GetItemAttrNumber

850: , ItemKey => ItemKey
851: , AName => 'BEFORE_AFTER'
852: );
853:
854: L_Duration_Days := WF_Engine.GetItemAttrNumber
855: ( ItemType => ItemType
856: , ItemKey => ItemKey
857: , AName => 'DURATION_DAYS'
858: );

Line 878: WF_ENGINE.SetItemAttrDate

874:
875: IF L_Delivery_Date IS NULL THEN
876: ResultOut := 'COMPLETE:F';
877: ELSE
878: WF_ENGINE.SetItemAttrDate
879: ( ItemType => ItemType
880: , ItemKey => ItemKey
881: , AName => 'DELIVERY_DATE'
882: , AValue => L_Delivery_Date );

Line 884: WF_ENGINE.SetItemAttrDate

880: , ItemKey => ItemKey
881: , AName => 'DELIVERY_DATE'
882: , AValue => L_Delivery_Date );
883:
884: WF_ENGINE.SetItemAttrDate
885: ( ItemType => ItemType
886: , ItemKey => ItemKey
887: , AName => 'TARGET_DATE_VALUE'
888: , AValue => L_Delivery_Date );

Line 890: WF_ENGINE.SetItemAttrText

886: , ItemKey => ItemKey
887: , AName => 'TARGET_DATE_VALUE'
888: , AValue => L_Delivery_Date );
889:
890: WF_ENGINE.SetItemAttrText
891: ( ItemType => ItemType
892: , ItemKey => ItemKey
893: , AName => 'DELIVERABLE_NUM'
894: , AValue => L_DELIVERABLE_NUM );

Line 896: WF_ENGINE.SetItemAttrText

892: , ItemKey => ItemKey
893: , AName => 'DELIVERABLE_NUM'
894: , AValue => L_DELIVERABLE_NUM );
895:
896: WF_ENGINE.SetItemAttrText
897: ( ItemType => ItemType
898: , ItemKey => ItemKey
899: , AName => 'DESCRIPTION'
900: , AValue => L_DESCRIPTION );

Line 903: WF_ENGINE.SetItemAttrDate

899: , AName => 'DESCRIPTION'
900: , AValue => L_DESCRIPTION );
901:
902: IF L_Before_After = 'BEFORE' THEN
903: WF_ENGINE.SetItemAttrDate
904: ( ItemType => ItemType
905: , ItemKey => ItemKey
906: , AName => 'COMPARE_DATE'
907: , AValue => sysdate+L_Duration_Days );

Line 909: WF_ENGINE.SetItemAttrDate

905: , ItemKey => ItemKey
906: , AName => 'COMPARE_DATE'
907: , AValue => sysdate+L_Duration_Days );
908: ELSE
909: WF_ENGINE.SetItemAttrDate
910: ( ItemType => ItemType
911: , ItemKey => ItemKey
912: , AName => 'COMPARE_DATE'
913: , AValue => sysdate-L_Duration_Days );

Line 934: WF_ENGINE.SetItemAttrText

930:
931: EXCEPTION
932: WHEN OTHERS THEN
933: ResultOut := 'ERROR:';
934: WF_ENGINE.SetItemAttrText
935: ( ItemType => ItemType
936: , ItemKey => ItemKey
937: , AName => 'ERRORTEXT'
938: , AValue => sqlerrm );

Line 982: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

978: L_Hold :=FALSE;
979:
980: IF ( FuncMode = 'RUN' ) THEN
981:
982: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
983: ( ItemType => ItemType
984: , ItemKey => ItemKey
985: , AName => 'DELIVERABLE_ID'
986: );

Line 1024: WF_ENGINE.SetItemAttrText

1020:
1021: ResultOut := 'COMPLETE:F';
1022: RETURN;
1023: ELSE
1024: WF_ENGINE.SetItemAttrText
1025: ( ItemType => ItemType
1026: , ItemKey => ItemKey
1027: , AName => 'ACTION'
1028: , AValue => 'SHIP' );

Line 1043: WF_ENGINE.SetItemAttrText

1039: WHERE DELIVERABLE_ID = L_Deliverable_ID;
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: ResultOut := 'ERROR:';
1043: WF_ENGINE.SetItemAttrText
1044: ( ItemType => ItemType
1045: , ItemKey => ItemKey
1046: , AName => 'ERRORTEXT'
1047: , AValue => sqlerrm );

Line 1095: WF_ENGINE.SetItemAttrText

1091:
1092: EXCEPTION
1093: WHEN OTHERS THEN
1094: ResultOut := 'ERROR:';
1095: WF_ENGINE.SetItemAttrText
1096: ( ItemType => ItemType
1097: , ItemKey => ItemKey
1098: , AName => 'ERRORTEXT'
1099: , AValue => sqlerrm );

Line 1145: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

1141: L_Hold := FALSE;
1142:
1143: IF ( FuncMode = 'RUN' ) THEN
1144:
1145: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
1146: ( ItemType => ItemType
1147: , ItemKey => ItemKey
1148: , AName => 'DELIVERABLE_ID'
1149: );

Line 1185: WF_ENGINE.SetItemAttrText

1181:
1182: ResultOut := 'COMPLETE:F';
1183: RETURN;
1184: ELSE
1185: WF_ENGINE.SetItemAttrText
1186: ( ItemType => ItemType
1187: , ItemKey => ItemKey
1188: , AName => 'ACTION'
1189: , AValue => 'PLAN' );

Line 1203: WF_ENGINE.SetItemAttrText

1199: WHERE DELIVERABLE_ID = L_Deliverable_ID;
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: ResultOut := 'ERROR:';
1203: WF_ENGINE.SetItemAttrText
1204: ( ItemType => ItemType
1205: , ItemKey => ItemKey
1206: , AName => 'ERRORTEXT'
1207: , AValue => sqlerrm );

Line 1255: WF_ENGINE.SetItemAttrText

1251:
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: ResultOut := 'ERROR:';
1255: WF_ENGINE.SetItemAttrText
1256: ( ItemType => ItemType
1257: , ItemKey => ItemKey
1258: , AName => 'ERRORTEXT'
1259: , AValue => sqlerrm );

Line 1296: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

1292: L_Hold := FALSE;
1293:
1294: IF ( FuncMode = 'RUN' ) THEN
1295:
1296: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
1297: ( ItemType => ItemType
1298: , ItemKey => ItemKey
1299: , AName => 'DELIVERABLE_ID'
1300: );

Line 1317: WF_ENGINE.SetItemAttrText

1313:
1314: ResultOut := 'COMPLETE:F';
1315: RETURN;
1316: ELSE
1317: WF_ENGINE.SetItemAttrText
1318: ( ItemType => ItemType
1319: , ItemKey => ItemKey
1320: , AName => 'ACTION'
1321: , AValue => 'REQ' );

Line 1335: WF_ENGINE.SetItemAttrText

1331: WHERE DELIVERABLE_ID = L_Deliverable_ID;
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: ResultOut := 'ERROR:';
1335: WF_ENGINE.SetItemAttrText
1336: ( ItemType => ItemType
1337: , ItemKey => ItemKey
1338: , AName => 'ERRORTEXT'
1339: , AValue => sqlerrm );

Line 1387: WF_ENGINE.SetItemAttrText

1383:
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: ResultOut := 'ERROR:';
1387: WF_ENGINE.SetItemAttrText
1388: ( ItemType => ItemType
1389: , ItemKey => ItemKey
1390: , AName => 'ERRORTEXT'
1391: , AValue => sqlerrm );

Line 1495: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

1491: Counter := 0;
1492:
1493: IF ( FuncMode = 'RUN' ) THEN
1494:
1495: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
1496: ( ItemType => ItemType
1497: , ItemKey => ItemKey
1498: , AName => 'DELIVERABLE_ID'
1499: );

Line 1502: L_Header_ID := WF_Engine.GetItemAttrNumber

1498: , AName => 'DELIVERABLE_ID'
1499: );
1500:
1501: --------------------------------------------------------------
1502: L_Header_ID := WF_Engine.GetItemAttrNumber
1503: ( ItemType => ItemType
1504: , ItemKey => ItemKey
1505: , AName => 'K_HEADER_ID'
1506: );

Line 1508: L_Contract_Number:= WF_Engine.GetItemAttrText

1504: , ItemKey => ItemKey
1505: , AName => 'K_HEADER_ID'
1506: );
1507:
1508: L_Contract_Number:= WF_Engine.GetItemAttrText
1509: ( ItemType => ItemType
1510: , ItemKey => ItemKey
1511: , AName => 'K_NUMBER'
1512: );

Line 1514: L_Line_Number:= WF_Engine.GetItemAttrText

1510: , ItemKey => ItemKey
1511: , AName => 'K_NUMBER'
1512: );
1513:
1514: L_Line_Number:= WF_Engine.GetItemAttrText
1515: ( ItemType => ItemType
1516: , ItemKey => ItemKey
1517: , AName => 'LINE_NUMBER'
1518: );

Line 1519: L_Requestor := WF_Engine.GetItemAttrText

1515: ( ItemType => ItemType
1516: , ItemKey => ItemKey
1517: , AName => 'LINE_NUMBER'
1518: );
1519: L_Requestor := WF_Engine.GetItemAttrText
1520: ( ItemType => ItemType
1521: , ItemKey => ItemKey
1522: , AName => 'REQUESTOR'
1523: );

Line 1593: WF_ENGINE.SetItemAttrText

1589:
1590: EXCEPTION
1591: WHEN OTHERS THEN
1592: ResultOut := 'ERROR:';
1593: WF_ENGINE.SetItemAttrText
1594: ( ItemType => ItemType
1595: , ItemKey => ItemKey
1596: , AName => 'ERRORTEXT'
1597: , AValue => sqlerrm );

Line 1701: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

1697:
1698:
1699: IF ( FuncMode = 'RUN' ) THEN
1700:
1701: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
1702: ( ItemType => ItemType
1703: , ItemKey => ItemKey
1704: , AName => 'DELIVERABLE_ID'
1705: );

Line 1707: L_Header_ID := WF_Engine.GetItemAttrNumber

1703: , ItemKey => ItemKey
1704: , AName => 'DELIVERABLE_ID'
1705: );
1706: --------------------------------------------------------------
1707: L_Header_ID := WF_Engine.GetItemAttrNumber
1708: ( ItemType => ItemType
1709: , ItemKey => ItemKey
1710: , AName => 'K_HEADER_ID'
1711: );

Line 1713: L_Contract_Number:= WF_Engine.GetItemAttrText

1709: , ItemKey => ItemKey
1710: , AName => 'K_HEADER_ID'
1711: );
1712:
1713: L_Contract_Number:= WF_Engine.GetItemAttrText
1714: ( ItemType => ItemType
1715: , ItemKey => ItemKey
1716: , AName => 'K_NUMBER'
1717: );

Line 1719: L_Line_Number:= WF_Engine.GetItemAttrText

1715: , ItemKey => ItemKey
1716: , AName => 'K_NUMBER'
1717: );
1718:
1719: L_Line_Number:= WF_Engine.GetItemAttrText
1720: ( ItemType => ItemType
1721: , ItemKey => ItemKey
1722: , AName => 'LINE_NUMBER'
1723: );

Line 1724: L_Requestor := WF_Engine.GetItemAttrText

1720: ( ItemType => ItemType
1721: , ItemKey => ItemKey
1722: , AName => 'LINE_NUMBER'
1723: );
1724: L_Requestor := WF_Engine.GetItemAttrText
1725: ( ItemType => ItemType
1726: , ItemKey => ItemKey
1727: , AName => 'REQUESTOR'
1728: );

Line 1797: WF_ENGINE.SetItemAttrText

1793:
1794: EXCEPTION
1795: WHEN OTHERS THEN
1796: ResultOut := 'ERROR:';
1797: WF_ENGINE.SetItemAttrText
1798: ( ItemType => ItemType
1799: , ItemKey => ItemKey
1800: , AName => 'ERRORTEXT'
1801: , AValue => sqlerrm );

Line 1904: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

1900: Counter := 0;
1901:
1902: IF ( FuncMode = 'RUN' ) THEN
1903:
1904: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
1905: ( ItemType => ItemType
1906: , ItemKey => ItemKey
1907: , AName => 'DELIVERABLE_ID'
1908: );

Line 1910: L_Header_ID := WF_Engine.GetItemAttrNumber

1906: , ItemKey => ItemKey
1907: , AName => 'DELIVERABLE_ID'
1908: );
1909: --------------------------------------------------------------
1910: L_Header_ID := WF_Engine.GetItemAttrNumber
1911: ( ItemType => ItemType
1912: , ItemKey => ItemKey
1913: , AName => 'K_HEADER_ID'
1914: );

Line 1916: L_Contract_Number:= WF_Engine.GetItemAttrText

1912: , ItemKey => ItemKey
1913: , AName => 'K_HEADER_ID'
1914: );
1915:
1916: L_Contract_Number:= WF_Engine.GetItemAttrText
1917: ( ItemType => ItemType
1918: , ItemKey => ItemKey
1919: , AName => 'K_NUMBER'
1920: );

Line 1922: L_Line_Number:= WF_Engine.GetItemAttrText

1918: , ItemKey => ItemKey
1919: , AName => 'K_NUMBER'
1920: );
1921:
1922: L_Line_Number:= WF_Engine.GetItemAttrText
1923: ( ItemType => ItemType
1924: , ItemKey => ItemKey
1925: , AName => 'LINE_NUMBER'
1926: );

Line 1927: L_Requestor := WF_Engine.GetItemAttrText

1923: ( ItemType => ItemType
1924: , ItemKey => ItemKey
1925: , AName => 'LINE_NUMBER'
1926: );
1927: L_Requestor := WF_Engine.GetItemAttrText
1928: ( ItemType => ItemType
1929: , ItemKey => ItemKey
1930: , AName => 'REQUESTOR'
1931: );

Line 2003: WF_ENGINE.SetItemAttrText

1999:
2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: ResultOut := 'ERROR:';
2003: WF_ENGINE.SetItemAttrText
2004: ( ItemType => ItemType
2005: , ItemKey => ItemKey
2006: , AName => 'ERRORTEXT'
2007: , AValue => sqlerrm );

Line 2034: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

2030: L_Completed_Flag VARCHAR2(1);
2031: BEGIN
2032: IF ( FuncMode = 'RUN' ) THEN
2033:
2034: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
2035: ( ItemType => ItemType
2036: , ItemKey => ItemKey
2037: , AName => 'DELIVERABLE_ID'
2038: );

Line 2072: WF_ENGINE.SetItemAttrText

2068:
2069: EXCEPTION
2070: WHEN OTHERS THEN
2071: ResultOut := 'ERROR:';
2072: WF_ENGINE.SetItemAttrText
2073: ( ItemType => ItemType
2074: , ItemKey => ItemKey
2075: , AName => 'ERRORTEXT'
2076: , AValue => sqlerrm );

Line 2123: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

2119:
2120: BEGIN
2121: IF ( FuncMode = 'RUN' ) THEN
2122:
2123: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
2124: ( ItemType => ItemType
2125: , ItemKey => ItemKey
2126: , AName => 'DELIVERABLE_ID'
2127: );

Line 2159: WF_ENGINE.SetItemAttrText

2155:
2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: ResultOut := 'ERROR:';
2159: WF_ENGINE.SetItemAttrText
2160: ( ItemType => ItemType
2161: , ItemKey => ItemKey
2162: , AName => 'ERRORTEXT'
2163: , AValue => sqlerrm );

Line 2196: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

2192:
2193: BEGIN
2194: IF ( FuncMode = 'RUN' ) THEN
2195:
2196: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
2197: ( ItemType => ItemType
2198: , ItemKey => ItemKey
2199: , AName => 'DELIVERABLE_ID'
2200: );

Line 2227: WF_ENGINE.SetItemAttrText

2223:
2224: EXCEPTION
2225: WHEN OTHERS THEN
2226: ResultOut := 'ERROR:';
2227: WF_ENGINE.SetItemAttrText
2228: ( ItemType => ItemType
2229: , ItemKey => ItemKey
2230: , AName => 'ERRORTEXT'
2231: , AValue => sqlerrm );

Line 2264: L_Deliverable_ID := WF_Engine.GetItemAttrNumber

2260:
2261: BEGIN
2262: IF ( FuncMode = 'RUN' ) THEN
2263:
2264: L_Deliverable_ID := WF_Engine.GetItemAttrNumber
2265: ( ItemType => ItemType
2266: , ItemKey => ItemKey
2267: , AName => 'DELIVERABLE_ID'
2268: );

Line 2295: WF_ENGINE.SetItemAttrText

2291:
2292: EXCEPTION
2293: WHEN OTHERS THEN
2294: ResultOut := 'ERROR:';
2295: WF_ENGINE.SetItemAttrText
2296: ( ItemType => ItemType
2297: , ItemKey => ItemKey
2298: , AName => 'ERRORTEXT'
2299: , AValue => sqlerrm );

Line 2330: WF_ENGINE.AbortProcess('OKEDTS',L_WF_Item_Key);

2326: FETCH C INTO L_WF_Item_Key;
2327: CLOSE C;
2328:
2329: IF L_WF_Item_Key IS NOT NULL THEN
2330: WF_ENGINE.AbortProcess('OKEDTS',L_WF_Item_Key);
2331: END IF;
2332: EXCEPTION
2333: WHEN OTHERS THEN
2334: NULL;

Line 2350: L_Performer := WF_Engine.GetItemAttrText

2346:
2347: BEGIN
2348: IF ( FuncMode = 'RUN' ) THEN
2349:
2350: L_Performer := WF_Engine.GetItemAttrText
2351: ( ItemType => ItemType
2352: , ItemKey => ItemKey
2353: , AName => 'PERFORMER'
2354: );

Line 2378: WF_ENGINE.SetItemAttrText

2374:
2375: EXCEPTION
2376: WHEN OTHERS THEN
2377: ResultOut := 'ERROR:';
2378: WF_ENGINE.SetItemAttrText
2379: ( ItemType => ItemType
2380: , ItemKey => ItemKey
2381: , AName => 'ERRORTEXT'
2382: , AValue => sqlerrm );

Line 2437: L_K_Header_ID := WF_Engine.GetItemAttrNumber

2433:
2434: BEGIN
2435: IF ( FuncMode = 'RUN' ) THEN
2436:
2437: L_K_Header_ID := WF_Engine.GetItemAttrNumber
2438: ( ItemType => ItemType
2439: , ItemKey => ItemKey
2440: , AName => 'K_HEADER_ID'
2441: );

Line 2443: L_Due_Ntf_Id := WF_Engine.GetItemAttrNumber

2439: , ItemKey => ItemKey
2440: , AName => 'K_HEADER_ID'
2441: );
2442:
2443: L_Due_Ntf_Id := WF_Engine.GetItemAttrNumber
2444: ( ItemType => ItemType
2445: , ItemKey => ItemKey
2446: , AName => 'DUE_NTF_ID'
2447: );

Line 2454: WF_ENGINE.SetItemAttrNumber

2450: FETCH CSR_DUE_NTF INTO REC_DUE_NTF;
2451: CLOSE CSR_DUE_NTF;
2452:
2453: IF REC_DUE_NTF.ID IS NULL THEN
2454: WF_ENGINE.SetItemAttrNumber
2455: ( ItemType => ItemType
2456: , ItemKey => ItemKey
2457: , AName => 'DUE_NTF_ID'
2458: , AValue => NULL );

Line 2463: WF_ENGINE.SetItemAttrNumber

2459:
2460: ResultOut := 'COMPLETE:F';
2461: RETURN;
2462: ELSE
2463: WF_ENGINE.SetItemAttrNumber
2464: ( ItemType => ItemType
2465: , ItemKey => ItemKey
2466: , AName => 'DUE_NTF_ID'
2467: , AValue => REC_DUE_NTF.ID );

Line 2469: WF_ENGINE.SetItemAttrText

2465: , ItemKey => ItemKey
2466: , AName => 'DUE_NTF_ID'
2467: , AValue => REC_DUE_NTF.ID );
2468:
2469: WF_ENGINE.SetItemAttrText
2470: ( ItemType => ItemType
2471: , ItemKey => ItemKey
2472: , AName => 'SOURCE_CODE'
2473: , AValue => REC_DUE_NTF.SOURCE_CODE );

Line 2475: WF_ENGINE.SetItemAttrText

2471: , ItemKey => ItemKey
2472: , AName => 'SOURCE_CODE'
2473: , AValue => REC_DUE_NTF.SOURCE_CODE );
2474:
2475: WF_ENGINE.SetItemAttrText
2476: ( ItemType => ItemType
2477: , ItemKey => ItemKey
2478: , AName => 'USAGE_CODE'
2479: , AValue => REC_DUE_NTF.USAGE_CODE );

Line 2481: WF_ENGINE.SetItemAttrText

2477: , ItemKey => ItemKey
2478: , AName => 'USAGE_CODE'
2479: , AValue => REC_DUE_NTF.USAGE_CODE );
2480:
2481: WF_ENGINE.SetItemAttrText
2482: ( ItemType => ItemType
2483: , ItemKey => ItemKey
2484: , AName => 'TARGET_DATE'
2485: , AValue => REC_DUE_NTF.TARGET_DATE );

Line 2487: WF_ENGINE.SetItemAttrText

2483: , ItemKey => ItemKey
2484: , AName => 'TARGET_DATE'
2485: , AValue => REC_DUE_NTF.TARGET_DATE );
2486:
2487: WF_ENGINE.SetItemAttrText
2488: ( ItemType => ItemType
2489: , ItemKey => ItemKey
2490: , AName => 'BEFORE_AFTER'
2491: , AValue => REC_DUE_NTF.BEFORE_AFTER );

Line 2493: WF_ENGINE.SetItemAttrNumber

2489: , ItemKey => ItemKey
2490: , AName => 'BEFORE_AFTER'
2491: , AValue => REC_DUE_NTF.BEFORE_AFTER );
2492:
2493: WF_ENGINE.SetItemAttrNumber
2494: ( ItemType => ItemType
2495: , ItemKey => ItemKey
2496: , AName => 'DURATION_DAYS'
2497: , AValue => REC_DUE_NTF.DURATION_DAYS );

Line 2499: WF_ENGINE.SetItemAttrText

2495: , ItemKey => ItemKey
2496: , AName => 'DURATION_DAYS'
2497: , AValue => REC_DUE_NTF.DURATION_DAYS );
2498:
2499: WF_ENGINE.SetItemAttrText
2500: ( ItemType => ItemType
2501: , ItemKey => ItemKey
2502: , AName => 'RECIPIENT'
2503: , AValue => REC_DUE_NTF.RECIPIENT );

Line 2505: WF_ENGINE.SetItemAttrNumber

2501: , ItemKey => ItemKey
2502: , AName => 'RECIPIENT'
2503: , AValue => REC_DUE_NTF.RECIPIENT );
2504:
2505: WF_ENGINE.SetItemAttrNumber
2506: ( ItemType => ItemType
2507: , ItemKey => ItemKey
2508: , AName => 'ROLE_ID'
2509: , AValue => REC_DUE_NTF.ROLE_ID );

Line 2512: WF_ENGINE.SetItemAttrText

2508: , AName => 'ROLE_ID'
2509: , AValue => REC_DUE_NTF.ROLE_ID );
2510:
2511: IF REC_DUE_NTF.RECIPIENT='REQUESTOR' THEN
2512: WF_ENGINE.SetItemAttrText
2513: ( ItemType => ItemType
2514: , ItemKey => ItemKey
2515: , AName => 'PERFORMER'
2516: , AValue => FND_GLOBAL.User_Name);

Line 2528: WF_ENGINE.SetItemAttrText

2524: IF L_Performer IS NULL THEN
2525: ResultOut := 'COMPLETE:F';
2526: RETURN;
2527: ELSE
2528: WF_ENGINE.SetItemAttrText
2529: ( ItemType => ItemType
2530: , ItemKey => ItemKey
2531: , AName => 'PERFORMER'
2532: , AValue => L_Performer );

Line 2536: WF_ENGINE.SetItemAttrText

2532: , AValue => L_Performer );
2533: END IF;
2534:
2535: ELSE
2536: WF_ENGINE.SetItemAttrText
2537: ( ItemType => ItemType
2538: , ItemKey => ItemKey
2539: , AName => 'PERFORMER'
2540: , AValue => FND_GLOBAL.User_Name);

Line 2561: WF_ENGINE.SetItemAttrText

2557:
2558: EXCEPTION
2559: WHEN OTHERS THEN
2560: ResultOut := 'ERROR:';
2561: WF_ENGINE.SetItemAttrText
2562: ( ItemType => ItemType
2563: , ItemKey => ItemKey
2564: , AName => 'ERRORTEXT'
2565: , AValue => sqlerrm );

Line 2591: L_Target_Date_Value := WF_Engine.GetItemAttrDate

2587:
2588: BEGIN
2589: IF ( FuncMode = 'RUN' ) THEN
2590:
2591: L_Target_Date_Value := WF_Engine.GetItemAttrDate
2592: ( ItemType => ItemType
2593: , ItemKey => ItemKey
2594: , AName => 'TARGET_DATE_VALUE'
2595: );

Line 2619: WF_ENGINE.SetItemAttrText

2615:
2616: EXCEPTION
2617: WHEN OTHERS THEN
2618: ResultOut := 'ERROR:';
2619: WF_ENGINE.SetItemAttrText
2620: ( ItemType => ItemType
2621: , ItemKey => ItemKey
2622: , AName => 'ERRORTEXT'
2623: , AValue => sqlerrm );