[Home] [Help]
34: IS
35: BEGIN
36:
37: If avalue IS NOT NULL then
38: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
39: itemkey => itemkey,
40: aname => aname,
41: avalue => avalue );
42: end if;
47: IS
48: BEGIN
49:
50: If avalue IS NOT NULL then
51: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
52: itemkey => itemkey,
53: aname => aname,
54: avalue => avalue );
55: end if;
59: avalue date)
60: IS
61: BEGIN
62: If avalue IS NOT NULL then
63: po_wf_util_pkg.SetItemAttrDate ( itemtype => itemtype,
64: itemkey => itemkey,
65: aname => aname,
66: avalue => avalue );
67: end if;
169: END IF;
170:
171: -- Initialize workflow item attributes
172:
173: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
174: itemkey => wf_itemkey,
175: aname => 'CHART_OF_ACCOUNTS_ID',
176: avalue => x_coa_id );
177:
186: x_bom_resource_code => l_bom_resource_code,
187: x_bom_resource_unit => l_bom_resource_unit,
188: x_bom_cost_element_id => l_bom_cost_element_id);
189:
190: po_wf_util_pkg.SetItemAttrNumber( itemtype => itemtype,
191: itemkey => wf_itemkey,
192: aname => 'BOM_COST_ELEMENT_ID',
193: avalue => l_bom_cost_element_id );
194: ELSE
191: itemkey => wf_itemkey,
192: aname => 'BOM_COST_ELEMENT_ID',
193: avalue => l_bom_cost_element_id );
194: ELSE
195: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
196: itemkey => wf_itemkey,
197: aname => 'BOM_COST_ELEMENT_ID',
198: avalue => x_bom_cost_element_id );
199: END IF;
198: avalue => x_bom_cost_element_id );
199: END IF;
200: --< Shared Proc FPJ End >
201:
202: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
203: itemkey => wf_itemkey,
204: aname => 'BOM_RESOURCE_ID',
205: avalue => x_bom_resource_id );
206: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
202: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
203: itemkey => wf_itemkey,
204: aname => 'BOM_RESOURCE_ID',
205: avalue => x_bom_resource_id );
206: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
207: itemkey => wf_itemkey,
208: aname => 'CATEGORY_ID',
209: avalue => x_category_id );
210: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
206: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
207: itemkey => wf_itemkey,
208: aname => 'CATEGORY_ID',
209: avalue => x_category_id );
210: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
211: itemkey => wf_itemkey,
212: aname => 'DELIVER_TO_LOCATION_ID',
213: avalue => x_deliver_to_location_id );
214: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
210: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
211: itemkey => wf_itemkey,
212: aname => 'DELIVER_TO_LOCATION_ID',
213: avalue => x_deliver_to_location_id );
214: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
215: itemkey => wf_itemkey,
216: aname => 'DESTINATION_ORGANIZATION_ID',
217: avalue => x_destination_organization_id );
218: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
214: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
215: itemkey => wf_itemkey,
216: aname => 'DESTINATION_ORGANIZATION_ID',
217: avalue => x_destination_organization_id );
218: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
219: itemkey => wf_itemkey,
220: aname => 'DESTINATION_SUBINVENTORY',
221: avalue => x_destination_subinventory );
222: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
218: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
219: itemkey => wf_itemkey,
220: aname => 'DESTINATION_SUBINVENTORY',
221: avalue => x_destination_subinventory );
222: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
223: itemkey => wf_itemkey,
224: aname => 'DESTINATION_TYPE_CODE',
225: avalue => x_destination_type_code );
226: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
222: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
223: itemkey => wf_itemkey,
224: aname => 'DESTINATION_TYPE_CODE',
225: avalue => x_destination_type_code );
226: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
227: itemkey => wf_itemkey,
228: aname => 'PO_ENCUMBRANCE_FLAG',
229: avalue => x_po_encumberance_flag );
230:
231: -- Header
232:
233: If header_att1 is not null then
234: begin
235: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
236: itemkey => wf_itemkey,
237: aname => 'HEADER_ATT1',
238: avalue => header_att1 );
239: exception when others then
242: end if;
243:
244: If header_att2 is not null then
245: begin
246: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
247: itemkey => wf_itemkey,
248: aname => 'HEADER_ATT2',
249: avalue => header_att2 );
250: exception when others then
253: end if;
254:
255: If header_att3 is not null then
256: begin
257: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
258: itemkey => wf_itemkey,
259: aname => 'HEADER_ATT3',
260: avalue => header_att3 );
261: exception when others then
264: end if;
265:
266: If header_att4 is not null then
267: begin
268: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
269: itemkey => wf_itemkey,
270: aname => 'HEADER_ATT4',
271: avalue => header_att4 );
272: exception when others then
275: end if;
276:
277: If header_att5 is not null then
278: begin
279: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
280: itemkey => wf_itemkey,
281: aname => 'HEADER_ATT5',
282: avalue => header_att5 );
283: exception when others then
286: end if;
287:
288: If header_att6 is not null then
289: begin
290: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
291: itemkey => wf_itemkey,
292: aname => 'HEADER_ATT6',
293: avalue => header_att6 );
294: exception when others then
297: end if;
298:
299: If header_att7 is not null then
300: begin
301: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
302: itemkey => wf_itemkey,
303: aname => 'HEADER_ATT7',
304: avalue => header_att7 );
305: exception when others then
308: end if;
309:
310: If header_att8 is not null then
311: begin
312: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
313: itemkey => wf_itemkey,
314: aname => 'HEADER_ATT8',
315: avalue => header_att8 );
316: exception when others then
319: end if;
320:
321: If header_att9 is not null then
322: begin
323: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
324: itemkey => wf_itemkey,
325: aname => 'HEADER_ATT9',
326: avalue => header_att9 );
327: exception when others then
330: end if;
331:
332: If header_att10 is not null then
333: begin
334: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
335: itemkey => wf_itemkey,
336: aname => 'HEADER_ATT10',
337: avalue => header_att10 );
338: exception when others then
341: end if;
342:
343: If header_att11 is not null then
344: begin
345: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
346: itemkey => wf_itemkey,
347: aname => 'HEADER_ATT11',
348: avalue => header_att11 );
349: exception when others then
352: end if;
353:
354: If header_att12 is not null then
355: begin
356: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
357: itemkey => wf_itemkey,
358: aname => 'HEADER_ATT12',
359: avalue => header_att12 );
360: exception when others then
363: end if;
364:
365: If header_att13 is not null then
366: begin
367: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
368: itemkey => wf_itemkey,
369: aname => 'HEADER_ATT13',
370: avalue => header_att13 );
371: exception when others then
374: end if;
375:
376: If header_att14 is not null then
377: begin
378: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
379: itemkey => wf_itemkey,
380: aname => 'HEADER_ATT14',
381: avalue => header_att14 );
382: exception when others then
385: end if;
386:
387: If header_att15 is not null then
388: begin
389: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
390: itemkey => wf_itemkey,
391: aname => 'HEADER_ATT15',
392: avalue => header_att15 );
393: exception when others then
398: -- Line
399:
400: If line_att1 is not null then
401: begin
402: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
403: itemkey => wf_itemkey,
404: aname => 'LINE_ATT1',
405: avalue => line_att1 );
406: exception when others then
409: end if;
410:
411: If line_att2 is not null then
412: begin
413: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
414: itemkey => wf_itemkey,
415: aname => 'LINE_ATT2',
416: avalue => line_att2 );
417: exception when others then
420: end if;
421:
422: If line_att3 is not null then
423: begin
424: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
425: itemkey => wf_itemkey,
426: aname => 'LINE_ATT3',
427: avalue => line_att3 );
428: exception when others then
431: end if;
432:
433: If line_att4 is not null then
434: begin
435: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
436: itemkey => wf_itemkey,
437: aname => 'LINE_ATT4',
438: avalue => line_att4 );
439: exception when others then
442: end if;
443:
444: If line_att5 is not null then
445: begin
446: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
447: itemkey => wf_itemkey,
448: aname => 'LINE_ATT5',
449: avalue => line_att5 );
450: exception when others then
453: end if;
454:
455: If line_att6 is not null then
456: begin
457: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
458: itemkey => wf_itemkey,
459: aname => 'LINE_ATT6',
460: avalue => line_att6 );
461: exception when others then
464: end if;
465:
466: If line_att7 is not null then
467: begin
468: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
469: itemkey => wf_itemkey,
470: aname => 'LINE_ATT7',
471: avalue => line_att7 );
472: exception when others then
475: end if;
476:
477: If line_att8 is not null then
478: begin
479: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
480: itemkey => wf_itemkey,
481: aname => 'LINE_ATT8',
482: avalue => line_att8 );
483: exception when others then
486: end if;
487:
488: If line_att9 is not null then
489: begin
490: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
491: itemkey => wf_itemkey,
492: aname => 'LINE_ATT9',
493: avalue => line_att9 );
494: exception when others then
497: end if;
498:
499: If line_att10 is not null then
500: begin
501: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
502: itemkey => wf_itemkey,
503: aname => 'LINE_ATT10',
504: avalue => line_att10 );
505: exception when others then
508: end if;
509:
510: If line_att11 is not null then
511: begin
512: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
513: itemkey => wf_itemkey,
514: aname => 'LINE_ATT11',
515: avalue => line_att11 );
516: exception when others then
519: end if;
520:
521: If line_att12 is not null then
522: begin
523: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
524: itemkey => wf_itemkey,
525: aname => 'LINE_ATT12',
526: avalue => line_att12 );
527: exception when others then
530: end if;
531:
532: If line_att13 is not null then
533: begin
534: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
535: itemkey => wf_itemkey,
536: aname => 'LINE_ATT13',
537: avalue => line_att13 );
538: exception when others then
541: end if;
542:
543: If line_att14 is not null then
544: begin
545: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
546: itemkey => wf_itemkey,
547: aname => 'LINE_ATT14',
548: avalue => line_att14 );
549: exception when others then
552: end if;
553:
554: If line_att15 is not null then
555: begin
556: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
557: itemkey => wf_itemkey,
558: aname => 'LINE_ATT15',
559: avalue => line_att15 );
560: exception when others then
565: -- shipment
566:
567: If shipment_att1 is not null then
568: begin
569: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
570: itemkey => wf_itemkey,
571: aname => 'SHIPMENT_ATT1',
572: avalue => shipment_att1 );
573: exception when others then
576: end if;
577:
578: If shipment_att2 is not null then
579: begin
580: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
581: itemkey => wf_itemkey,
582: aname => 'SHIPMENT_ATT2',
583: avalue => shipment_att2 );
584: exception when others then
587: end if;
588:
589: If shipment_att3 is not null then
590: begin
591: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
592: itemkey => wf_itemkey,
593: aname => 'SHIPMENT_ATT3',
594: avalue => shipment_att3 );
595: exception when others then
598: end if;
599:
600: If shipment_att4 is not null then
601: begin
602: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
603: itemkey => wf_itemkey,
604: aname => 'SHIPMENT_ATT4',
605: avalue => shipment_att4 );
606: exception when others then
609: end if;
610:
611: If shipment_att5 is not null then
612: begin
613: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
614: itemkey => wf_itemkey,
615: aname => 'SHIPMENT_ATT5',
616: avalue => shipment_att5 );
617: exception when others then
620: end if;
621:
622: If shipment_att6 is not null then
623: begin
624: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
625: itemkey => wf_itemkey,
626: aname => 'SHIPMENT_ATT6',
627: avalue => shipment_att6 );
628: exception when others then
631: end if;
632:
633: If shipment_att7 is not null then
634: begin
635: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
636: itemkey => wf_itemkey,
637: aname => 'SHIPMENT_ATT7',
638: avalue => shipment_att7 );
639: exception when others then
642: end if;
643:
644: If shipment_att8 is not null then
645: begin
646: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
647: itemkey => wf_itemkey,
648: aname => 'SHIPMENT_ATT8',
649: avalue => shipment_att8 );
650: exception when others then
653: end if;
654:
655: If shipment_att9 is not null then
656: begin
657: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
658: itemkey => wf_itemkey,
659: aname => 'SHIPMENT_ATT9',
660: avalue => shipment_att9 );
661: exception when others then
664: end if;
665:
666: If shipment_att10 is not null then
667: begin
668: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
669: itemkey => wf_itemkey,
670: aname => 'SHIPMENT_ATT10',
671: avalue => shipment_att10 );
672: exception when others then
675: end if;
676:
677: If shipment_att11 is not null then
678: begin
679: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
680: itemkey => wf_itemkey,
681: aname => 'SHIPMENT_ATT11',
682: avalue => shipment_att11 );
683: exception when others then
686: end if;
687:
688: If shipment_att12 is not null then
689: begin
690: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
691: itemkey => wf_itemkey,
692: aname => 'SHIPMENT_ATT12',
693: avalue => shipment_att12 );
694: exception when others then
697: end if;
698:
699: If shipment_att13 is not null then
700: begin
701: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
702: itemkey => wf_itemkey,
703: aname => 'SHIPMENT_ATT13',
704: avalue => shipment_att13 );
705: exception when others then
708: end if;
709:
710: If shipment_att14 is not null then
711: begin
712: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
713: itemkey => wf_itemkey,
714: aname => 'SHIPMENT_ATT14',
715: avalue => shipment_att14 );
716: exception when others then
719: end if;
720:
721: If shipment_att15 is not null then
722: begin
723: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
724: itemkey => wf_itemkey,
725: aname => 'SHIPMENT_ATT15',
726: avalue => shipment_att15 );
727: exception when others then
732: -- Distribution
733:
734: If distribution_att1 is not null then
735: begin
736: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
737: itemkey => wf_itemkey,
738: aname => 'DISTRIBUTION_ATT1',
739: avalue => distribution_att1 );
740: exception when others then
743: end if;
744:
745: If distribution_att2 is not null then
746: begin
747: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
748: itemkey => wf_itemkey,
749: aname => 'DISTRIBUTION_ATT2',
750: avalue => distribution_att2 );
751: exception when others then
754: end if;
755:
756: If distribution_att3 is not null then
757: begin
758: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
759: itemkey => wf_itemkey,
760: aname => 'DISTRIBUTION_ATT3',
761: avalue => distribution_att3 );
762: exception when others then
765: end if;
766:
767: If distribution_att4 is not null then
768: begin
769: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
770: itemkey => wf_itemkey,
771: aname => 'DISTRIBUTION_ATT4',
772: avalue => distribution_att4 );
773: exception when others then
776: end if;
777:
778: If distribution_att5 is not null then
779: begin
780: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
781: itemkey => wf_itemkey,
782: aname => 'DISTRIBUTION_ATT5',
783: avalue => distribution_att5 );
784: exception when others then
787: end if;
788:
789: If distribution_att6 is not null then
790: begin
791: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
792: itemkey => wf_itemkey,
793: aname => 'DISTRIBUTION_ATT6',
794: avalue => distribution_att6 );
795: exception when others then
798: end if;
799:
800: If distribution_att7 is not null then
801: begin
802: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
803: itemkey => wf_itemkey,
804: aname => 'DISTRIBUTION_ATT7',
805: avalue => distribution_att7 );
806: exception when others then
809: end if;
810:
811: If distribution_att8 is not null then
812: begin
813: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
814: itemkey => wf_itemkey,
815: aname => 'DISTRIBUTION_ATT8',
816: avalue => distribution_att8 );
817: exception when others then
820: end if;
821:
822: If distribution_att9 is not null then
823: begin
824: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
825: itemkey => wf_itemkey,
826: aname => 'DISTRIBUTION_ATT9',
827: avalue => distribution_att9 );
828: exception when others then
831: end if;
832:
833: If distribution_att10 is not null then
834: begin
835: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
836: itemkey => wf_itemkey,
837: aname => 'DISTRIBUTION_ATT10',
838: avalue => distribution_att10 );
839: exception when others then
842: end if;
843:
844: If distribution_att11 is not null then
845: begin
846: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
847: itemkey => wf_itemkey,
848: aname => 'DISTRIBUTION_ATT11',
849: avalue => distribution_att11 );
850: exception when others then
853: end if;
854:
855: If distribution_att12 is not null then
856: begin
857: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
858: itemkey => wf_itemkey,
859: aname => 'DISTRIBUTION_ATT12',
860: avalue => distribution_att12 );
861: exception when others then
864: end if;
865:
866: If distribution_att13 is not null then
867: begin
868: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
869: itemkey => wf_itemkey,
870: aname => 'DISTRIBUTION_ATT13',
871: avalue => distribution_att13 );
872: exception when others then
875: end if;
876:
877: If distribution_att14 is not null then
878: begin
879: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
880: itemkey => wf_itemkey,
881: aname => 'DISTRIBUTION_ATT14',
882: avalue => distribution_att14 );
883: exception when others then
886: end if;
887:
888: If distribution_att15 is not null then
889: begin
890: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
891: itemkey => wf_itemkey,
892: aname => 'DISTRIBUTION_ATT15',
893: avalue => distribution_att15 );
894: exception when others then
895: null;
896: end;
897: end if;
898:
899: po_wf_util_pkg.SetItemAttrDate ( itemtype => itemtype,
900: itemkey => wf_itemkey,
901: aname => 'EXPENDITURE_ITEM_DATE',
902: avalue => x_expenditure_item_date );
903: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
899: po_wf_util_pkg.SetItemAttrDate ( itemtype => itemtype,
900: itemkey => wf_itemkey,
901: aname => 'EXPENDITURE_ITEM_DATE',
902: avalue => x_expenditure_item_date );
903: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
904: itemkey => wf_itemkey,
905: aname => 'EXPENDITURE_ORGANIZATION_ID',
906: avalue => x_expenditure_organization_id );
907: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
903: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
904: itemkey => wf_itemkey,
905: aname => 'EXPENDITURE_ORGANIZATION_ID',
906: avalue => x_expenditure_organization_id );
907: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
908: itemkey => wf_itemkey,
909: aname => 'EXPENDITURE_TYPE',
910: avalue => x_expenditure_type );
911: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
907: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
908: itemkey => wf_itemkey,
909: aname => 'EXPENDITURE_TYPE',
910: avalue => x_expenditure_type );
911: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
912: itemkey => wf_itemkey,
913: aname => 'ITEM_ID',
914: avalue => x_item_id );
915: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
911: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
912: itemkey => wf_itemkey,
913: aname => 'ITEM_ID',
914: avalue => x_item_id );
915: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
916: itemkey => wf_itemkey,
917: aname => 'LINE_TYPE_ID',
918: avalue => x_line_type_id );
919: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
915: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
916: itemkey => wf_itemkey,
917: aname => 'LINE_TYPE_ID',
918: avalue => x_line_type_id );
919: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
920: itemkey => wf_itemkey,
921: aname => 'PA_BILLABLE_FLAG',
922: avalue => x_result_billable_flag );
923: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
919: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
920: itemkey => wf_itemkey,
921: aname => 'PA_BILLABLE_FLAG',
922: avalue => x_result_billable_flag );
923: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
924: itemkey => wf_itemkey,
925: aname => 'PREPARER_ID',
926: avalue => x_agent_id );
927: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
923: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
924: itemkey => wf_itemkey,
925: aname => 'PREPARER_ID',
926: avalue => x_agent_id );
927: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
928: itemkey => wf_itemkey,
929: aname => 'PROJECT_ID',
930: avalue => x_project_id );
931: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
927: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
928: itemkey => wf_itemkey,
929: aname => 'PROJECT_ID',
930: avalue => x_project_id );
931: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
932: itemkey => wf_itemkey,
933: aname => 'SOURCE_DOCUMENT_HEADER_ID',
934: avalue => x_from_header_id);
935: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
931: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
932: itemkey => wf_itemkey,
933: aname => 'SOURCE_DOCUMENT_HEADER_ID',
934: avalue => x_from_header_id);
935: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
936: itemkey => wf_itemkey,
937: aname => 'SOURCE_DOCUMENT_LINE_ID',
938: avalue => x_from_line_id );
939: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
935: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
936: itemkey => wf_itemkey,
937: aname => 'SOURCE_DOCUMENT_LINE_ID',
938: avalue => x_from_line_id );
939: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
940: itemkey => wf_itemkey,
941: aname => 'SOURCE_DOCUMENT_TYPE_CODE',
942: avalue => x_from_type_lookup_code );
943: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
939: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
940: itemkey => wf_itemkey,
941: aname => 'SOURCE_DOCUMENT_TYPE_CODE',
942: avalue => x_from_type_lookup_code );
943: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
944: itemkey => wf_itemkey,
945: aname => 'TASK_ID',
946: avalue => x_task_id );
947: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
943: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
944: itemkey => wf_itemkey,
945: aname => 'TASK_ID',
946: avalue => x_task_id );
947: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
948: itemkey => wf_itemkey,
949: aname => 'TO_PERSON_ID',
950: avalue => x_deliver_to_person_id );
951: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
947: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
948: itemkey => wf_itemkey,
949: aname => 'TO_PERSON_ID',
950: avalue => x_deliver_to_person_id );
951: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
952: itemkey => wf_itemkey,
953: aname => 'TYPE_LOOKUP_CODE',
954: avalue => x_type_lookup_code );
955: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
951: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
952: itemkey => wf_itemkey,
953: aname => 'TYPE_LOOKUP_CODE',
954: avalue => x_type_lookup_code );
955: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
956: itemkey => wf_itemkey,
957: aname => 'VENDOR_ID',
958: avalue => x_vendor_id );
959: -- B1548597 Common Receiving RVK
956: itemkey => wf_itemkey,
957: aname => 'VENDOR_ID',
958: avalue => x_vendor_id );
959: -- B1548597 Common Receiving RVK
960: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
961: itemkey => wf_itemkey,
962: aname => 'VENDOR_SITE_ID',
963: avalue => x_vendor_site_id );
964: -- B1548597 Common Receiving End RVK
961: itemkey => wf_itemkey,
962: aname => 'VENDOR_SITE_ID',
963: avalue => x_vendor_site_id );
964: -- B1548597 Common Receiving End RVK
965: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
966: itemkey => wf_itemkey,
967: aname => 'WIP_ENTITY_ID',
968: avalue => x_wip_entity_id );
969:
977: x_dest_org_id => x_destination_organization_id,
978: x_entity_name => l_entity_name,
979: x_entity_type => l_wip_entity_type);
980:
981: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
982: itemkey => wf_itemkey,
983: aname => 'WIP_ENTITY_TYPE',
984: avalue => l_wip_entity_type );
985: ELSE
982: itemkey => wf_itemkey,
983: aname => 'WIP_ENTITY_TYPE',
984: avalue => l_wip_entity_type );
985: ELSE
986: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
987: itemkey => wf_itemkey,
988: aname => 'WIP_ENTITY_TYPE',
989: avalue => x_wip_entity_type );
990: END IF;
989: avalue => x_wip_entity_type );
990: END IF;
991: --< Shared Proc FPJ End >
992:
993: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
994: itemkey => wf_itemkey,
995: aname => 'WIP_LINE_ID',
996: avalue => x_wip_line_id );
997: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
993: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
994: itemkey => wf_itemkey,
995: aname => 'WIP_LINE_ID',
996: avalue => x_wip_line_id );
997: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
998: itemkey => wf_itemkey,
999: aname => 'WIP_OPERATION_SEQ_NUM',
1000: avalue => x_wip_operation_seq_num );
1001: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
997: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
998: itemkey => wf_itemkey,
999: aname => 'WIP_OPERATION_SEQ_NUM',
1000: avalue => x_wip_operation_seq_num );
1001: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1002: itemkey => wf_itemkey,
1003: aname => 'WIP_REPETITIVE_SCHEDULE_ID',
1004: avalue => x_wip_repetitive_schedule_id );
1005: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1001: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1002: itemkey => wf_itemkey,
1003: aname => 'WIP_REPETITIVE_SCHEDULE_ID',
1004: avalue => x_wip_repetitive_schedule_id );
1005: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1006: itemkey => wf_itemkey,
1007: aname => 'WIP_RESOURCE_SEQ_NUM',
1008: avalue => x_wip_resource_seq_num );
1009:
1007: aname => 'WIP_RESOURCE_SEQ_NUM',
1008: avalue => x_wip_resource_seq_num );
1009:
1010: --< Shared Proc FPJ Start >
1011: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
1012: itemkey => wf_itemkey,
1013: aname => 'ACCOUNT_GENERATION_FLOW_TYPE',
1014: avalue => x_account_generation_flow_type );
1015: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1011: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
1012: itemkey => wf_itemkey,
1013: aname => 'ACCOUNT_GENERATION_FLOW_TYPE',
1014: avalue => x_account_generation_flow_type );
1015: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1016: itemkey => wf_itemkey,
1017: aname => 'SHIP_TO_OU_COA_ID',
1018: avalue => x_ship_to_ou_coa_id );
1019: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1015: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1016: itemkey => wf_itemkey,
1017: aname => 'SHIP_TO_OU_COA_ID',
1018: avalue => x_ship_to_ou_coa_id );
1019: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1020: itemkey => wf_itemkey,
1021: aname => 'SHIP_TO_OU_ID',
1022: avalue => x_ship_to_ou_id );
1023: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1019: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1020: itemkey => wf_itemkey,
1021: aname => 'SHIP_TO_OU_ID',
1022: avalue => x_ship_to_ou_id );
1023: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1024: itemkey => wf_itemkey,
1025: aname => 'PURCHASING_OU_ID',
1026: avalue => x_purchasing_ou_id );
1027: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1023: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1024: itemkey => wf_itemkey,
1025: aname => 'PURCHASING_OU_ID',
1026: avalue => x_purchasing_ou_id );
1027: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1028: itemkey => wf_itemkey,
1029: aname => 'TRANSACTION_FLOW_HEADER_ID',
1030: avalue => x_transaction_flow_header_id );
1031: IF (x_is_SPS_distribution = TRUE) THEN
1028: itemkey => wf_itemkey,
1029: aname => 'TRANSACTION_FLOW_HEADER_ID',
1030: avalue => x_transaction_flow_header_id );
1031: IF (x_is_SPS_distribution = TRUE) THEN
1032: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
1033: itemkey => wf_itemkey,
1034: aname => 'IS_SPS_DISTRIBUTION',
1035: avalue => 'Y' );
1036: ELSE
1033: itemkey => wf_itemkey,
1034: aname => 'IS_SPS_DISTRIBUTION',
1035: avalue => 'Y' );
1036: ELSE
1037: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
1038: itemkey => wf_itemkey,
1039: aname => 'IS_SPS_DISTRIBUTION',
1040: avalue => 'N' );
1041: END IF;
1038: itemkey => wf_itemkey,
1039: aname => 'IS_SPS_DISTRIBUTION',
1040: avalue => 'N' );
1041: END IF;
1042: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1043: itemkey => wf_itemkey,
1044: aname => 'DEST_CHARGE_ACCOUNT_ID',
1045: avalue => x_dest_charge_account_id );
1046: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1042: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1043: itemkey => wf_itemkey,
1044: aname => 'DEST_CHARGE_ACCOUNT_ID',
1045: avalue => x_dest_charge_account_id );
1046: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
1047: itemkey => wf_itemkey,
1048: aname => 'DEST_VARIANCE_ACCOUNT_ID',
1049: avalue => x_dest_variance_account_id );
1050: --< Shared Proc FPJ End >
1049: avalue => x_dest_variance_account_id );
1050: --< Shared Proc FPJ End >
1051:
1052: --
1053: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
1054: itemkey => wf_itemkey,
1055: aname => 'CLM_MISC_LOA',
1056: avalue => p_clm_misc_loa );
1057: --
1060: --Call WF API to set the unit_price attribute to the PO line / release
1061: --shipment price, converted to the functional currency (Bug 3463242).
1062: --unit_price will be taken into consideration when generating accounts.
1063:
1064: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
1065: itemkey => wf_itemkey,
1066: aname => 'UNIT_PRICE',
1067: -- Bug 3463242:
1068: avalue => p_func_unit_price );
1080: IF p_payment_type = 'ADVANCE' THEN
1081: --the distribution belongs to an advance, not a financing pay item
1082: l_progress := '020';
1083:
1084: po_wf_util_pkg.SetItemAttrText (
1085: itemtype => itemtype,
1086: itemkey => wf_itemkey,
1087: aname => 'IS_ADVANCE_DISTRIBUTION',
1088: avalue => 'Y' );
1086: itemkey => wf_itemkey,
1087: aname => 'IS_ADVANCE_DISTRIBUTION',
1088: avalue => 'Y' );
1089:
1090: po_wf_util_pkg.SetItemAttrText (
1091: itemtype => itemtype,
1092: itemkey => wf_itemkey,
1093: aname => 'IS_FINANCING_DISTRIBUTION',
1094: avalue => 'N' );
1097: --distr type is prepayment, but payment type is not advance
1098: --this means the distribution belongs to a financing pay item
1099: l_progress := '030';
1100:
1101: po_wf_util_pkg.SetItemAttrText (
1102: itemtype => itemtype,
1103: itemkey => wf_itemkey,
1104: aname => 'IS_ADVANCE_DISTRIBUTION',
1105: avalue => 'N' );
1103: itemkey => wf_itemkey,
1104: aname => 'IS_ADVANCE_DISTRIBUTION',
1105: avalue => 'N' );
1106:
1107: po_wf_util_pkg.SetItemAttrText (
1108: itemtype => itemtype,
1109: itemkey => wf_itemkey,
1110: aname => 'IS_FINANCING_DISTRIBUTION',
1111: avalue => 'Y' );
1117: -- the distribution belongs to neither an advance nor a
1118: -- financing pay item
1119: l_progress := '040';
1120:
1121: po_wf_util_pkg.SetItemAttrText (
1122: itemtype => itemtype,
1123: itemkey => wf_itemkey,
1124: aname => 'IS_ADVANCE_DISTRIBUTION',
1125: avalue => 'N' );
1123: itemkey => wf_itemkey,
1124: aname => 'IS_ADVANCE_DISTRIBUTION',
1125: avalue => 'N' );
1126:
1127: po_wf_util_pkg.SetItemAttrText (
1128: itemtype => itemtype,
1129: itemkey => wf_itemkey,
1130: aname => 'IS_FINANCING_DISTRIBUTION',
1131: avalue => 'N' );
1140: IF g_debug_stmt THEN
1141: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1142: p_token => l_progress,
1143: p_message => 'Set WF item UNIT_PRICE to ' ||
1144: PO_WF_UTIL_PKG.GetItemAttrNumber (
1145: itemtype => itemtype,
1146: itemkey => wf_itemkey,
1147: aname => 'UNIT_PRICE')
1148: );
1406:
1407: l_progress := '010';
1408:
1409: -- Bug 1497909 : Set the encumbrance date for validation
1410: po_wf_util_pkg.SetItemAttrDate(itemtype => itemtype,
1411: itemkey => wf_itemkey,
1412: aname => 'ENCUMBRANCE_DATE',
1413: avalue => x_gl_encumbered_date);
1414:
1488:
1489: l_progress := '030';
1490: IF x_success THEN
1491: l_progress := '040';
1492: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
1493: itemkey => wf_itemkey,
1494: aname => 'DEST_CHARGE_ACCOUNT_ID',
1495: avalue => x_dest_charge_account_id );
1496:
1502:
1503: l_progress := '050';
1504:
1505: -- Bug 1497909 : Set the encumbrance date for validation
1506: po_wf_util_pkg.SetItemAttrDate(itemtype => itemtype,
1507: itemkey => wf_itemkey,
1508: aname => 'ENCUMBRANCE_DATE',
1509: avalue => x_gl_encumbered_date);
1510:
1547:
1548: l_progress := '080';
1549: IF x_success THEN
1550: l_progress := '090';
1551: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
1552: itemkey => wf_itemkey,
1553: aname => 'DEST_VARIANCE_ACCOUNT_ID',
1554: avalue => x_dest_variance_account_id );
1555: END IF; -- IF x_success (DEST_VARIANCE_ACCOUNT)
1915: -- results.
1916: x_block_activity_label := NULL;
1917:
1918: -- Bug 1497909 : Set the encumbrance date for validation
1919: po_wf_util_pkg.SetItemAttrDate(itemtype => itemtype,
1920: itemkey => wf_itemkey,
1921: aname => 'ENCUMBRANCE_DATE',
1922: avalue => x_gl_encumbered_date);
1923:
2036: (x_code_combination_id <> -1) ) THEN -- (
2037:
2038: l_progress := '130';
2039:
2040: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
2041: itemkey => wf_itemkey,
2042: aname => 'CODE_COMBINATION_ID',
2043: avalue => x_code_combination_id );
2044:
2065:
2066: l_progress := '140';
2067:
2068: -- Bug 1497909 : Set the encumbrance date for validation
2069: po_wf_util_pkg.SetItemAttrDate(itemtype => itemtype,
2070: itemkey => wf_itemkey,
2071: aname => 'ENCUMBRANCE_DATE',
2072: avalue => x_gl_encumbered_date);
2073:
2127: IF x_success THEN
2128:
2129: l_progress := '170';
2130:
2131: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
2132: itemkey => wf_itemkey,
2133: aname => 'BUDGET_ACCOUNT_ID',
2134: avalue => x_budget_account_id );
2135:
2166: x_block_activity_label);
2167: END IF;
2168:
2169: -- Bug 1497909 : Set the encumbrance date for validation
2170: po_wf_util_pkg.SetItemAttrDate(itemtype => itemtype,
2171: itemkey => wf_itemkey,
2172: aname => 'ENCUMBRANCE_DATE',
2173: avalue => x_gl_encumbered_date);
2174:
2209: IF x_success THEN
2210:
2211: l_progress := '190';
2212:
2213: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
2214: itemkey => wf_itemkey,
2215: aname => 'ACCRUAL_ACCOUNT_ID',
2216: avalue => x_accrual_account_id );
2217:
2223:
2224: l_progress := '200';
2225:
2226: -- Bug 1497909 : Set the encumbrance date for validation
2227: po_wf_util_pkg.SetItemAttrDate(itemtype => itemtype,
2228: itemkey => wf_itemkey,
2229: aname => 'ENCUMBRANCE_DATE',
2230: avalue => x_gl_encumbered_date);
2231:
2267: END IF;
2268:
2269: --RETURN (x_success);
2270: IF NOT x_success THEN
2271: PO_WF_UTIL_PKG.clear_wf_cache; -- bug5075361
2272: RETURN (x_success);
2273: END IF;
2274: ELSE -- accrual acc failed.
2275: x_accrual_success := x_success;
2275: x_accrual_success := x_success;
2276:
2277: --RETURN (x_success);
2278: IF NOT x_success THEN
2279: PO_WF_UTIL_PKG.clear_wf_cache; -- bug5075361
2280: RETURN (x_success);
2281: END IF;
2282:
2283: END IF; -- IF x_success
2285: x_budget_success := x_success;
2286:
2287: --RETURN (x_success);
2288: IF NOT x_success THEN
2289: PO_WF_UTIL_PKG.clear_wf_cache; -- bug5075361
2290: RETURN (x_success);
2291: END IF;
2292:
2293: END IF; -- IF x_success
2295: x_charge_success := x_success;
2296:
2297: --RETURN (x_success);
2298: IF NOT x_success THEN
2299: PO_WF_UTIL_PKG.clear_wf_cache; -- bug5075361
2300: RETURN (x_success);
2301: END IF;
2302:
2303: END IF; -- IF ( x_success AND
2370: IF g_debug_stmt THEN
2371: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2372: END IF;
2373:
2374: PO_WF_UTIL_PKG.clear_wf_cache; -- bug5075361
2375: RETURN x_success;
2376: ELSE
2377: FB_ERROR_MSG := 'Invalid Item Type OR Item Key';
2378: IF g_debug_stmt THEN
2384: IF g_debug_stmt THEN
2385: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2386: END IF;
2387:
2388: PO_WF_UTIL_PKG.clear_wf_cache; -- bug5075361
2389: RETURN FALSE;
2390: END IF; -- IF ( ItemType IS NOT NULL ) AND ( Wf_Itemkey IS NOT NULL) -- )
2391:
2392: IF g_debug_stmt THEN
2394: END IF;
2395:
2396: EXCEPTION
2397: WHEN OTHERS THEN
2398: PO_WF_UTIL_PKG.clear_wf_cache; -- bug5075361
2399: po_message_s.sql_error('Start_Workflow_internal',
2400: l_progress, sqlcode);
2401: IF g_debug_unexp THEN
2402: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,