159:
160: -- Note from bug5075361: We probably don't need to keep the clearcache
161: -- at the beginning of the procedure since they're called at the end
162: -- but it doesn't hurt to keep them anyway
163: WF_ENGINE_UTIL.CLEARCACHE;
164: WF_ACTIVITY.CLEARCACHE;
165: WF_ITEM_ACTIVITY_STATUS.CLEARCACHE;
166: WF_ITEM.CLEARCACHE;
167: WF_PROCESS_ACTIVITY.CLEARCACHE;
286: x_destination_subinventory);
287:
288: Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DESTINATION_TYPE_CODE', x_destination_type_code);
289:
290: wf_engine.SetItemAttrText ( itemtype => itemtype,
291: itemkey => WF_ItemKey,
292: aname => 'PO_ENCUMBRANCE_FLAG',
293: avalue => x_po_encumberance_flag );
294:
296:
297: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT1', header_att1);
298: If header_att1 is not null then
299: begin
300: wf_engine.SetItemAttrText ( itemtype => itemtype,
301: itemkey => WF_ItemKey,
302: aname => 'HEADER_ATT1',
303: avalue => header_att1 );
304: exception when others then
308:
309: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT2', header_att2);
310: If header_att2 is not null then
311: begin
312: wf_engine.SetItemAttrText ( itemtype => itemtype,
313: itemkey => WF_ItemKey,
314: aname => 'HEADER_ATT2',
315: avalue => header_att2 );
316: exception when others then
320:
321: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT3', header_att3);
322: If header_att3 is not null then
323: begin
324: wf_engine.SetItemAttrText ( itemtype => itemtype,
325: itemkey => WF_ItemKey,
326: aname => 'HEADER_ATT3',
327: avalue => header_att3 );
328: exception when others then
332:
333: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT4', header_att4);
334: If header_att4 is not null then
335: begin
336: wf_engine.SetItemAttrText ( itemtype => itemtype,
337: itemkey => WF_ItemKey,
338: aname => 'HEADER_ATT4',
339: avalue => header_att4 );
340: exception when others then
344:
345: -- Call_WF_API_to_set_Att (ItemType, ItemKey, 'HEADER_ATT5', header_att5);
346: If header_att5 is not null then
347: begin
348: wf_engine.SetItemAttrText ( itemtype => itemtype,
349: itemkey => WF_ItemKey,
350: aname => 'HEADER_ATT5',
351: avalue => header_att5 );
352: exception when others then
356:
357: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT6', header_att6);
358: If header_att6 is not null then
359: begin
360: wf_engine.SetItemAttrText ( itemtype => itemtype,
361: itemkey => WF_ItemKey,
362: aname => 'HEADER_ATT6',
363: avalue => header_att6 );
364: exception when others then
368:
369: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT7', header_att7);
370: If header_att7 is not null then
371: begin
372: wf_engine.SetItemAttrText ( itemtype => itemtype,
373: itemkey => WF_ItemKey,
374: aname => 'HEADER_ATT7',
375: avalue => header_att7 );
376: exception when others then
380:
381: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT8', header_att8);
382: If header_att8 is not null then
383: begin
384: wf_engine.SetItemAttrText ( itemtype => itemtype,
385: itemkey => WF_ItemKey,
386: aname => 'HEADER_ATT8',
387: avalue => header_att8 );
388: exception when others then
392:
393: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT9', header_att9);
394: If header_att9 is not null then
395: begin
396: wf_engine.SetItemAttrText ( itemtype => itemtype,
397: itemkey => WF_ItemKey,
398: aname => 'HEADER_ATT9',
399: avalue => header_att9 );
400: exception when others then
404:
405: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT10', header_att10);
406: If header_att10 is not null then
407: begin
408: wf_engine.SetItemAttrText ( itemtype => itemtype,
409: itemkey => WF_ItemKey,
410: aname => 'HEADER_ATT10',
411: avalue => header_att10 );
412: exception when others then
416:
417: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT11', header_att11);
418: If header_att11 is not null then
419: begin
420: wf_engine.SetItemAttrText ( itemtype => itemtype,
421: itemkey => WF_ItemKey,
422: aname => 'HEADER_ATT11',
423: avalue => header_att11 );
424: exception when others then
428:
429: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT12', header_att12);
430: If header_att12 is not null then
431: begin
432: wf_engine.SetItemAttrText ( itemtype => itemtype,
433: itemkey => WF_ItemKey,
434: aname => 'HEADER_ATT12',
435: avalue => header_att12 );
436: exception when others then
440:
441: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT13', header_att13);
442: If header_att13 is not null then
443: begin
444: wf_engine.SetItemAttrText ( itemtype => itemtype,
445: itemkey => WF_ItemKey,
446: aname => 'HEADER_ATT13',
447: avalue => header_att13 );
448: exception when others then
452:
453: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT14', header_att14);
454: If header_att14 is not null then
455: begin
456: wf_engine.SetItemAttrText ( itemtype => itemtype,
457: itemkey => WF_ItemKey,
458: aname => 'HEADER_ATT14',
459: avalue => header_att14 );
460: exception when others then
464:
465: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'HEADER_ATT15', header_att15);
466: If header_att15 is not null then
467: begin
468: wf_engine.SetItemAttrText ( itemtype => itemtype,
469: itemkey => WF_ItemKey,
470: aname => 'HEADER_ATT15',
471: avalue => header_att15 );
472: exception when others then
478:
479: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT1', line_att1);
480: If line_att1 is not null then
481: begin
482: wf_engine.SetItemAttrText ( itemtype => itemtype,
483: itemkey => WF_ItemKey,
484: aname => 'LINE_ATT1',
485: avalue => line_att1 );
486: exception when others then
490:
491: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT2', line_att2);
492: If line_att2 is not null then
493: begin
494: wf_engine.SetItemAttrText ( itemtype => itemtype,
495: itemkey => WF_ItemKey,
496: aname => 'LINE_ATT2',
497: avalue => line_att2 );
498: exception when others then
502:
503: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT3', line_att3);
504: If line_att3 is not null then
505: begin
506: wf_engine.SetItemAttrText ( itemtype => itemtype,
507: itemkey => WF_ItemKey,
508: aname => 'LINE_ATT3',
509: avalue => line_att3 );
510: exception when others then
514:
515: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT4', line_att4);
516: If line_att4 is not null then
517: begin
518: wf_engine.SetItemAttrText ( itemtype => itemtype,
519: itemkey => WF_ItemKey,
520: aname => 'LINE_ATT4',
521: avalue => line_att4 );
522: exception when others then
526:
527: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT5', line_att5);
528: If line_att5 is not null then
529: begin
530: wf_engine.SetItemAttrText ( itemtype => itemtype,
531: itemkey => WF_ItemKey,
532: aname => 'LINE_ATT5',
533: avalue => line_att5 );
534: exception when others then
538:
539: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT6', line_att6);
540: If line_att6 is not null then
541: begin
542: wf_engine.SetItemAttrText ( itemtype => itemtype,
543: itemkey => WF_ItemKey,
544: aname => 'LINE_ATT6',
545: avalue => line_att6 );
546: exception when others then
550:
551: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT7', line_att7);
552: If line_att7 is not null then
553: begin
554: wf_engine.SetItemAttrText ( itemtype => itemtype,
555: itemkey => WF_ItemKey,
556: aname => 'LINE_ATT7',
557: avalue => line_att7 );
558: exception when others then
562:
563: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT8', line_att8);
564: If line_att8 is not null then
565: begin
566: wf_engine.SetItemAttrText ( itemtype => itemtype,
567: itemkey => WF_ItemKey,
568: aname => 'LINE_ATT8',
569: avalue => line_att8 );
570: exception when others then
574:
575: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT9', line_att9);
576: If line_att9 is not null then
577: begin
578: wf_engine.SetItemAttrText ( itemtype => itemtype,
579: itemkey => WF_ItemKey,
580: aname => 'LINE_ATT9',
581: avalue => line_att9 );
582: exception when others then
586:
587: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT10', line_att10);
588: If line_att10 is not null then
589: begin
590: wf_engine.SetItemAttrText ( itemtype => itemtype,
591: itemkey => WF_ItemKey,
592: aname => 'LINE_ATT10',
593: avalue => line_att10 );
594: exception when others then
598:
599: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT11', line_att11);
600: If line_att11 is not null then
601: begin
602: wf_engine.SetItemAttrText ( itemtype => itemtype,
603: itemkey => WF_ItemKey,
604: aname => 'LINE_ATT11',
605: avalue => line_att11 );
606: exception when others then
610:
611: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT12', line_att12);
612: If line_att12 is not null then
613: begin
614: wf_engine.SetItemAttrText ( itemtype => itemtype,
615: itemkey => WF_ItemKey,
616: aname => 'LINE_ATT12',
617: avalue => line_att12 );
618: exception when others then
622:
623: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT13', line_att13);
624: If line_att13 is not null then
625: begin
626: wf_engine.SetItemAttrText ( itemtype => itemtype,
627: itemkey => WF_ItemKey,
628: aname => 'LINE_ATT13',
629: avalue => line_att13 );
630: exception when others then
634:
635: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT14', line_att14);
636: If line_att14 is not null then
637: begin
638: wf_engine.SetItemAttrText ( itemtype => itemtype,
639: itemkey => WF_ItemKey,
640: aname => 'LINE_ATT14',
641: avalue => line_att14 );
642: exception when others then
646:
647: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'LINE_ATT15', line_att15);
648: If line_att15 is not null then
649: begin
650: wf_engine.SetItemAttrText ( itemtype => itemtype,
651: itemkey => WF_ItemKey,
652: aname => 'LINE_ATT15',
653: avalue => line_att15 );
654: exception when others then
660:
661: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT1', distribution_att1);
662: If distribution_att1 is not null then
663: begin
664: wf_engine.SetItemAttrText ( itemtype => itemtype,
665: itemkey => WF_ItemKey,
666: aname => 'DISTRIBUTION_ATT1',
667: avalue => distribution_att1 );
668: exception when others then
672:
673: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT2', distribution_att2);
674: If distribution_att2 is not null then
675: begin
676: wf_engine.SetItemAttrText ( itemtype => itemtype,
677: itemkey => WF_ItemKey,
678: aname => 'DISTRIBUTION_ATT2',
679: avalue => distribution_att2 );
680: exception when others then
684:
685: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT3', distribution_att3);
686: If distribution_att3 is not null then
687: begin
688: wf_engine.SetItemAttrText ( itemtype => itemtype,
689: itemkey => WF_ItemKey,
690: aname => 'DISTRIBUTION_ATT3',
691: avalue => distribution_att3 );
692: exception when others then
696:
697: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT4', distribution_att4);
698: If distribution_att4 is not null then
699: begin
700: wf_engine.SetItemAttrText ( itemtype => itemtype,
701: itemkey => WF_ItemKey,
702: aname => 'DISTRIBUTION_ATT4',
703: avalue => distribution_att4 );
704: exception when others then
708:
709: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT5', distribution_att5);
710: If distribution_att5 is not null then
711: begin
712: wf_engine.SetItemAttrText ( itemtype => itemtype,
713: itemkey => WF_ItemKey,
714: aname => 'DISTRIBUTION_ATT5',
715: avalue => distribution_att5 );
716: exception when others then
720:
721: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT6', distribution_att6);
722: If distribution_att6 is not null then
723: begin
724: wf_engine.SetItemAttrText ( itemtype => itemtype,
725: itemkey => WF_ItemKey,
726: aname => 'DISTRIBUTION_ATT6',
727: avalue => distribution_att6 );
728: exception when others then
732:
733: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT7', distribution_att7);
734: If distribution_att7 is not null then
735: begin
736: wf_engine.SetItemAttrText ( itemtype => itemtype,
737: itemkey => WF_ItemKey,
738: aname => 'DISTRIBUTION_ATT7',
739: avalue => distribution_att7 );
740: exception when others then
744:
745: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT8', distribution_att8);
746: If distribution_att8 is not null then
747: begin
748: wf_engine.SetItemAttrText ( itemtype => itemtype,
749: itemkey => WF_ItemKey,
750: aname => 'DISTRIBUTION_ATT8',
751: avalue => distribution_att8 );
752: exception when others then
756:
757: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT9', distribution_att9);
758: If distribution_att9 is not null then
759: begin
760: wf_engine.SetItemAttrText ( itemtype => itemtype,
761: itemkey => WF_ItemKey,
762: aname => 'DISTRIBUTION_ATT9',
763: avalue => distribution_att9 );
764: exception when others then
768:
769: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT10', distribution_att10);
770: If distribution_att10 is not null then
771: begin
772: wf_engine.SetItemAttrText ( itemtype => itemtype,
773: itemkey => WF_ItemKey,
774: aname => 'DISTRIBUTION_ATT10',
775: avalue => distribution_att10 );
776: exception when others then
780:
781: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT11', distribution_att11);
782: If distribution_att11 is not null then
783: begin
784: wf_engine.SetItemAttrText ( itemtype => itemtype,
785: itemkey => WF_ItemKey,
786: aname => 'DISTRIBUTION_ATT11',
787: avalue => distribution_att11 );
788: exception when others then
792:
793: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT12', distribution_att12);
794: If distribution_att12 is not null then
795: begin
796: wf_engine.SetItemAttrText ( itemtype => itemtype,
797: itemkey => WF_ItemKey,
798: aname => 'DISTRIBUTION_ATT12',
799: avalue => distribution_att12 );
800: exception when others then
804:
805: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT13', distribution_att13);
806: If distribution_att13 is not null then
807: begin
808: wf_engine.SetItemAttrText ( itemtype => itemtype,
809: itemkey => WF_ItemKey,
810: aname => 'DISTRIBUTION_ATT13',
811: avalue => distribution_att13 );
812: exception when others then
816:
817: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT14', distribution_att14);
818: If distribution_att14 is not null then
819: begin
820: wf_engine.SetItemAttrText ( itemtype => itemtype,
821: itemkey => WF_ItemKey,
822: aname => 'DISTRIBUTION_ATT14',
823: avalue => distribution_att14 );
824: exception when others then
828:
829: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'DISTRIBUTION_ATT15', distribution_att15);
830: If distribution_att15 is not null then
831: begin
832: wf_engine.SetItemAttrText ( itemtype => itemtype,
833: itemkey => WF_ItemKey,
834: aname => 'DISTRIBUTION_ATT15',
835: avalue => distribution_att15 );
836: exception when others then
841: /* Added by sjanakir for Fed Fields */
842: -- Call_WF_API_to_set_Att (ItemType, WF_ItemKey, 'CLM_MISC_LOA', p_misc_loa);
843: If p_misc_loa is not null then
844: begin
845: wf_engine.SetItemAttrText ( itemtype => itemtype,
846: itemkey => WF_ItemKey,
847: aname => 'CLM_MISC_LOA',
848: avalue => p_misc_loa );
849: exception when others then
960:
961: -- Complete the blocked workflow as it may be running in synch mode and cause problems for consequent
962: -- account generation runs for this session.
963: begin
964: wf_engine.CompleteActivity(itemtype, wf_itemkey, 'BLOCK_BUDGET_ACC_GENERATION', 'FAILURE');
965: exception
966: when others then
967: IF (g_po_wf_debug = 'Y') THEN
968: PO_WF_DEBUG_PKG.insert_debug(itemtype,wf_itemkey,'Exception when completing WF' || Wf_Itemkey);
1004:
1005: If (x_success and (x_code_combination_id IS NOT NULL) and (x_code_combination_id <> 0) and
1006: (x_code_combination_id <> -1)) then
1007:
1008: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
1009: itemkey => WF_ItemKey,
1010: aname => 'CODE_COMBINATION_ID',
1011: avalue => x_code_combination_id );
1012:
1063: end if;
1064:
1065: if x_success then
1066:
1067: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
1068: itemkey => WF_ItemKey,
1069: aname => 'BUDGET_ACCOUNT_ID',
1070: avalue => x_budget_account_id );
1071:
1124: FB_ERROR_MSG;
1125:
1126: If x_success then
1127:
1128: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
1129: itemkey => WF_ItemKey,
1130: aname => 'ACCRUAL_ACCOUNT_ID',
1131: avalue => x_accrual_account_id );
1132:
1277: avalue varchar2)
1278: IS
1279: BEGIN
1280:
1281: wf_engine.SetItemAttrText ( itemtype => itemtype,
1282: itemkey => itemkey,
1283: aname => aname,
1284: avalue => avalue );
1285: END Call_WF_API_to_set_Att;
1288: avalue number)
1289: IS
1290: BEGIN
1291:
1292: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => aname,
1295: avalue => avalue );
1296: END Call_WF_API_to_set_no_Att;
1299: avalue date)
1300: IS
1301: BEGIN
1302:
1303: wf_engine.SetItemAttrDate ( itemtype => itemtype,
1304: itemkey => itemkey,
1305: aname => aname,
1306: avalue => avalue );
1307: END Call_WF_API_to_set_date_Att;