[Home] [Help]
68: END Call_WF_API_to_set_date_Att;
69:
70: PROCEDURE set_ag_wf_attributes(
71: itemtype IN VARCHAR2,
72: wf_itemkey IN VARCHAR2,
73: x_coa_id IN NUMBER,
74: x_bom_cost_element_id IN NUMBER,
75: x_bom_resource_id IN NUMBER,
76: x_category_id IN NUMBER,
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:
178: --< Shared Proc FPJ Start >
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
195: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
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;
200: --< Shared Proc FPJ End >
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,
207: itemkey => wf_itemkey,
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,
211: itemkey => wf_itemkey,
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,
215: itemkey => wf_itemkey,
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,
219: itemkey => wf_itemkey,
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,
223: itemkey => wf_itemkey,
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,
227: itemkey => wf_itemkey,
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
240: null;
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
251: null;
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
262: null;
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
273: null;
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
284: null;
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
295: null;
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
306: null;
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
317: null;
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
328: null;
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
339: null;
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
350: null;
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
361: null;
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
372: null;
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
383: null;
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
394: null;
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
407: null;
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
418: null;
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
429: null;
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
440: null;
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
451: null;
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
462: null;
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
473: null;
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
484: null;
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
495: null;
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
506: null;
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
517: null;
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
528: null;
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
539: null;
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
550: null;
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
561: null;
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
574: null;
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
585: null;
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
596: null;
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
607: null;
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
618: null;
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
629: null;
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
640: null;
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
651: null;
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
662: null;
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
673: null;
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
684: null;
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
695: null;
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
706: null;
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
717: null;
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
728: null;
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
741: null;
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
752: null;
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
763: null;
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
774: null;
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
785: null;
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
796: null;
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
807: null;
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
818: null;
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
829: null;
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
840: null;
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
851: null;
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
862: null;
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
873: null;
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
884: null;
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,
904: itemkey => wf_itemkey,
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,
908: itemkey => wf_itemkey,
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,
912: itemkey => wf_itemkey,
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,
916: itemkey => wf_itemkey,
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,
920: itemkey => wf_itemkey,
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,
924: itemkey => wf_itemkey,
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,
928: itemkey => wf_itemkey,
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,
932: itemkey => wf_itemkey,
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,
936: itemkey => wf_itemkey,
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,
940: itemkey => wf_itemkey,
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,
944: itemkey => wf_itemkey,
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,
948: itemkey => wf_itemkey,
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,
952: itemkey => wf_itemkey,
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,
956: itemkey => wf_itemkey,
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
960: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
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
965: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
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:
970: --< Shared Proc FPJ Start >
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
986: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
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;
991: --< Shared Proc FPJ End >
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,
998: itemkey => wf_itemkey,
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,
1002: itemkey => wf_itemkey,
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,
1006: itemkey => wf_itemkey,
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:
1010: --< Shared Proc FPJ Start >
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,
1016: itemkey => wf_itemkey,
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,
1020: itemkey => wf_itemkey,
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,
1024: itemkey => wf_itemkey,
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,
1028: itemkey => wf_itemkey,
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
1032: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
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
1037: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
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;
1042: po_wf_util_pkg.SetItemAttrNumber ( itemtype => itemtype,
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,
1047: itemkey => wf_itemkey,
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 >
1051:
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: --
1058:
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 );
1069:
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' );
1089:
1090: po_wf_util_pkg.SetItemAttrText (
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' );
1095:
1096: ELSE
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' );
1106:
1107: po_wf_util_pkg.SetItemAttrText (
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' );
1112:
1113: END IF; --is payment type advance or not
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' );
1126:
1127: po_wf_util_pkg.SetItemAttrText (
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' );
1132:
1133: END IF; --is distribution type check
1139:
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')
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: );
1149: END IF;
1150:
1151: --
1152:
1153: l_progress := '060';
1154:
1155: -- Done setting WF item attributes
1156: IF g_debug_stmt THEN
1157: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
1158: END IF;
1159:
1159:
1160: END set_ag_wf_attributes;
1161:
1162: PROCEDURE derive_pa_params(itemtype IN VARCHAR2,
1163: wf_itemkey IN VARCHAR2,
1164: x_project_id IN NUMBER,
1165: x_task_id IN NUMBER,
1166: x_expenditure_type IN VARCHAR2,
1167: x_vendor_id IN NUMBER,
1244: WHEN OTHERS THEN
1245: NULL;
1246: END;
1247:
1248: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'CLASS_CODE',
1249: l_class_code);
1250: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'DIRECT_FLAG',
1251: l_direct_flag);
1252: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'EXPENDITURE_CATEGORY',
1246: END;
1247:
1248: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'CLASS_CODE',
1249: l_class_code);
1250: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'DIRECT_FLAG',
1251: l_direct_flag);
1252: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'EXPENDITURE_CATEGORY',
1253: l_expenditure_category);
1254: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'EXPENDITURE_ORG_NAME',
1248: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'CLASS_CODE',
1249: l_class_code);
1250: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'DIRECT_FLAG',
1251: l_direct_flag);
1252: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'EXPENDITURE_CATEGORY',
1253: l_expenditure_category);
1254: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'EXPENDITURE_ORG_NAME',
1255: l_expenditure_org_name);
1256: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_NUMBER',
1250: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'DIRECT_FLAG',
1251: l_direct_flag);
1252: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'EXPENDITURE_CATEGORY',
1253: l_expenditure_category);
1254: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'EXPENDITURE_ORG_NAME',
1255: l_expenditure_org_name);
1256: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_NUMBER',
1257: l_project_number);
1258: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_ORGANIZATION_NAME',
1252: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'EXPENDITURE_CATEGORY',
1253: l_expenditure_category);
1254: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'EXPENDITURE_ORG_NAME',
1255: l_expenditure_org_name);
1256: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_NUMBER',
1257: l_project_number);
1258: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_ORGANIZATION_NAME',
1259: l_project_organization_name);
1260: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey,'PROJECT_ORGANIZATION_ID',
1254: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'EXPENDITURE_ORG_NAME',
1255: l_expenditure_org_name);
1256: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_NUMBER',
1257: l_project_number);
1258: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_ORGANIZATION_NAME',
1259: l_project_organization_name);
1260: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey,'PROJECT_ORGANIZATION_ID',
1261: l_project_organization_id);
1262: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_TYPE',
1256: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_NUMBER',
1257: l_project_number);
1258: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_ORGANIZATION_NAME',
1259: l_project_organization_name);
1260: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey,'PROJECT_ORGANIZATION_ID',
1261: l_project_organization_id);
1262: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_TYPE',
1263: l_project_type);
1264: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PUBLIC_SECTOR_FLAG',
1258: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_ORGANIZATION_NAME',
1259: l_project_organization_name);
1260: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey,'PROJECT_ORGANIZATION_ID',
1261: l_project_organization_id);
1262: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_TYPE',
1263: l_project_type);
1264: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PUBLIC_SECTOR_FLAG',
1265: l_public_sector_flag);
1266: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'REVENUE_CATEGORY',
1260: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey,'PROJECT_ORGANIZATION_ID',
1261: l_project_organization_id);
1262: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_TYPE',
1263: l_project_type);
1264: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PUBLIC_SECTOR_FLAG',
1265: l_public_sector_flag);
1266: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'REVENUE_CATEGORY',
1267: l_revenue_category);
1268: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_NUMBER',
1262: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PROJECT_TYPE',
1263: l_project_type);
1264: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PUBLIC_SECTOR_FLAG',
1265: l_public_sector_flag);
1266: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'REVENUE_CATEGORY',
1267: l_revenue_category);
1268: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_NUMBER',
1269: l_task_number);
1270: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_ORGANIZATION_NAME',
1264: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'PUBLIC_SECTOR_FLAG',
1265: l_public_sector_flag);
1266: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'REVENUE_CATEGORY',
1267: l_revenue_category);
1268: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_NUMBER',
1269: l_task_number);
1270: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_ORGANIZATION_NAME',
1271: l_task_organization_name);
1272: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'TASK_ORGANIZATION_ID',
1266: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'REVENUE_CATEGORY',
1267: l_revenue_category);
1268: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_NUMBER',
1269: l_task_number);
1270: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_ORGANIZATION_NAME',
1271: l_task_organization_name);
1272: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'TASK_ORGANIZATION_ID',
1273: l_task_organization_id);
1274: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_SERVICE_TYPE',
1268: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_NUMBER',
1269: l_task_number);
1270: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_ORGANIZATION_NAME',
1271: l_task_organization_name);
1272: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'TASK_ORGANIZATION_ID',
1273: l_task_organization_id);
1274: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_SERVICE_TYPE',
1275: l_task_service_type);
1276: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'TOP_TASK_ID',
1270: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_ORGANIZATION_NAME',
1271: l_task_organization_name);
1272: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'TASK_ORGANIZATION_ID',
1273: l_task_organization_id);
1274: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_SERVICE_TYPE',
1275: l_task_service_type);
1276: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'TOP_TASK_ID',
1277: l_top_task_id);
1278: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TOP_TASK_NUMBER',
1272: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'TASK_ORGANIZATION_ID',
1273: l_task_organization_id);
1274: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_SERVICE_TYPE',
1275: l_task_service_type);
1276: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'TOP_TASK_ID',
1277: l_top_task_id);
1278: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TOP_TASK_NUMBER',
1279: l_top_task_number);
1280: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'VENDOR_EMPLOYEE_ID',
1274: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TASK_SERVICE_TYPE',
1275: l_task_service_type);
1276: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'TOP_TASK_ID',
1277: l_top_task_id);
1278: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TOP_TASK_NUMBER',
1279: l_top_task_number);
1280: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'VENDOR_EMPLOYEE_ID',
1281: l_vendor_employee_id);
1282: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'VENDOR_EMPLOYEE_NUMBER',
1276: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'TOP_TASK_ID',
1277: l_top_task_id);
1278: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TOP_TASK_NUMBER',
1279: l_top_task_number);
1280: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'VENDOR_EMPLOYEE_ID',
1281: l_vendor_employee_id);
1282: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'VENDOR_EMPLOYEE_NUMBER',
1283: l_vendor_employee_number);
1284: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'VENDOR_TYPE',
1278: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'TOP_TASK_NUMBER',
1279: l_top_task_number);
1280: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'VENDOR_EMPLOYEE_ID',
1281: l_vendor_employee_id);
1282: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'VENDOR_EMPLOYEE_NUMBER',
1283: l_vendor_employee_number);
1284: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'VENDOR_TYPE',
1285: l_vendor_type);
1286: -- OGM stores award_set id into award_id column and derives award_id
1280: Call_WF_API_to_set_no_Att (ItemType, Wf_Itemkey, 'VENDOR_EMPLOYEE_ID',
1281: l_vendor_employee_id);
1282: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'VENDOR_EMPLOYEE_NUMBER',
1283: l_vendor_employee_number);
1284: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'VENDOR_TYPE',
1285: l_vendor_type);
1286: -- OGM stores award_set id into award_id column and derives award_id
1287: -- from ADLs table.
1288: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'AWARD_SET_ID',
1284: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'VENDOR_TYPE',
1285: l_vendor_type);
1286: -- OGM stores award_set id into award_id column and derives award_id
1287: -- from ADLs table.
1288: Call_WF_API_to_set_Att (ItemType, Wf_Itemkey, 'AWARD_SET_ID',
1289: X_Award_id); --OGM_0.0 change
1290: END IF; -- IF (x_project_id IS NOT NULL)
1291: -- done setting AP project accounting attributes.
1292:
1338: END all_returned_segments_null_sv;
1339:
1340: PROCEDURE generate_destination_accounts(
1341: itemtype IN VARCHAR2,
1342: wf_itemkey IN VARCHAR2,
1343: p_is_SPS_distribution IN BOOLEAN,
1344: x_insert_if_new IN BOOLEAN,
1345: x_account_generation_flow_type IN VARCHAR2,
1346: x_coa_id IN NUMBER,
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:
1415: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL (
1413: avalue => x_gl_encumbered_date);
1414:
1415: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL (
1416: ItemType,
1417: Wf_Itemkey,
1418: 'GENERATE_DEST_CHARGE_ACCOUNT',
1419: l_block_activity_label,
1420: x_insert_if_new,
1421: ccid,
1456: p_message => 'Terminating the workflow because'||
1457: ' invalid dest charge account was generated.');
1458: END IF;
1459:
1460: wf_engine.CompleteActivity(itemtype, wf_itemkey,
1461: 'BLOCK_DEST_VAR_ACC_GENERATE', 'FAILURE');
1462: EXCEPTION
1463: WHEN OTHERS THEN
1464: IF g_debug_stmt THEN
1465: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1466: p_token => l_progress,
1467: p_message =>
1468: 'Exception when completing WF for dest accounts '||
1469: 'Item key='|| Wf_Itemkey);
1470: END IF;
1471:
1472: IF g_debug_unexp THEN
1473: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
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:
1497: IF g_debug_stmt THEN
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:
1511: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL (
1509: avalue => x_gl_encumbered_date);
1510:
1511: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL (
1512: ItemType,
1513: Wf_Itemkey,
1514: 'GENERATE_DEST_VARIANCE_ACCOUNT',
1515: 'BLOCK_DEST_VAR_ACC_GENERATE',
1516: x_insert_if_new,
1517: ccid,
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)
1556: END IF; -- IF x_success (DEST_CHARGE_ACCOUNT)
1683: x_po_encumberance_flag VARCHAR2,
1684: x_gl_encumbered_date DATE,
1685:
1686: -- because of changes due to WF synch mode this input parameter is not used.
1687: wf_itemkey IN OUT NOCOPY VARCHAR2,
1688: x_new_combination IN OUT NOCOPY BOOLEAN,
1689:
1690: header_att1 VARCHAR2, header_att2 VARCHAR2, header_att3 VARCHAR2,
1691: header_att4 VARCHAR2, header_att5 VARCHAR2, header_att6 VARCHAR2,
1762:
1763: -- Note from bug5075361: We probably don't need to keep the clearcache
1764: -- at the beginning of the procedure since they're called at the end
1765: -- but it doesn't hurt to keep them anyway
1766: wf_item.clearcache;
1767:
1768: ItemType := 'POWFPOAG'; -- PO Account Generator Workflow
1769: x_appl_short_name := 'SQLGL';
1770: x_flex_field_code := 'GL#';
1788: l_distribution_type := nvl(p_distribution_type, 'NOT PREPAYMENT');
1789:
1790: l_progress := '020';
1791:
1792: Wf_Itemkey := FND_FLEX_WORKFLOW.initialize(x_appl_short_name,
1793: x_flex_field_code,
1794: x_flex_field_struc_num,
1795: ItemType);
1796:
1798: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1799: p_token => l_progress,
1800: p_message => 'x_account_generation_flow_type='
1801: || x_account_generation_flow_type
1802: || 'item_key=' || wf_itemkey);
1803: END IF;
1804:
1805: l_progress := '030';
1806:
1803: END IF;
1804:
1805: l_progress := '030';
1806:
1807: IF ( ItemType IS NOT NULL ) AND ( Wf_Itemkey IS NOT NULL) THEN -- (
1808:
1809: l_progress := '040';
1810:
1811: -- Moved the calling of AP routine to get raw and derived parameters for
1809: l_progress := '040';
1810:
1811: -- Moved the calling of AP routine to get raw and derived parameters for
1812: -- project accounting accounts into this new private procedure called
1813: -- derive_pa_params(). This procedure also sets the PA related WF item
1814: -- attributes that are derived from the PA API. It also sets the
1815: -- AWARD_SET_ID attribute if project_id is not null.
1816:
1817: derive_pa_params(itemtype,
1814: -- attributes that are derived from the PA API. It also sets the
1815: -- AWARD_SET_ID attribute if project_id is not null.
1816:
1817: derive_pa_params(itemtype,
1818: wf_itemkey,
1819: x_project_id,
1820: x_task_id,
1821: x_expenditure_type,
1822: x_vendor_id,
1830: -- this new private procedure called set_ag_wf_attributes(). This makes
1831: -- the procedure Start_Workflow() more modular and more readable.
1832:
1833: set_ag_wf_attributes(itemtype,
1834: wf_itemkey,
1835: x_coa_id,
1836: x_bom_cost_element_id,
1837: x_bom_resource_id,
1838: x_category_id,
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:
1924: IF g_debug_stmt THEN
1927: p_message => 'Before calling FND_FLEX_WORKFLOW.generate_partial');
1928: END IF;
1929:
1930: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL ( ItemType,
1931: Wf_Itemkey,
1932: 'DEFAULT_CHARGE_ACC_GENERATION',
1933: x_block_activity_label,
1934: x_insert_if_new,
1935: ccid,
1965: ' Account was generated.');
1966: END IF;
1967:
1968:
1969: wf_engine.CompleteActivity(itemtype, wf_itemkey,
1970: 'BLOCK_BUDGET_ACC_GENERATION', 'FAILURE');
1971: EXCEPTION
1972: WHEN OTHERS THEN
1973: IF g_debug_stmt THEN
1973: IF g_debug_stmt THEN
1974: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1975: p_token => l_progress,
1976: p_message => 'Exception when completing WF.' ||
1977: ' item_key='||Wf_Itemkey);
1978: END IF;
1979:
1980: IF g_debug_unexp THEN
1981: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
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:
2045: -- Generate Budget Account if encumbrance is on
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:
2074: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL(
2072: avalue => x_gl_encumbered_date);
2073:
2074: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL(
2075: ItemType,
2076: Wf_Itemkey,
2077: 'DEFAULT_BUDGET_ACC_GENERATION',
2078: x_block_activity_label,
2079: x_insert_if_new,
2080: ccid,
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:
2136: -- Generate Accrual Account
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:
2175: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL (
2173: avalue => x_gl_encumbered_date);
2174:
2175: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL (
2176: ItemType,
2177: Wf_Itemkey,
2178: 'DEFAULT_ACCRUAL_ACC_GENERATION',
2179: x_block_activity_label,
2180: x_insert_if_new,
2181: ccid,
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:
2218: IF g_debug_stmt THEN
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:
2232: -- Generate Variance Account
2231:
2232: -- Generate Variance Account
2233: x_success := FND_FLEX_WORKFLOW.GENERATE_PARTIAL(
2234: ItemType,
2235: Wf_Itemkey,
2236: 'DEFAULT_VARIANCE_ACC_GENERATION',
2237: 'BLOCK_VARIANCE_ACC_GENERATION',
2238: x_insert_if_new,
2239: ccid,
2322:
2323: --< Shared Proc FPJ Start >
2324: generate_destination_accounts(
2325: itemtype, -- IN VARCHAR2
2326: wf_itemkey, -- IN VARCHAR2,
2327: x_is_SPS_distribution, -- IN BOOLEAN
2328: x_insert_if_new, -- IN BOOLEAN,
2329: x_account_generation_flow_type, -- IN VARCHAR2,
2330: x_coa_id, -- IN NUMBER,
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
2393: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2394: END IF;
2468: x_po_encumberance_flag VARCHAR2,
2469: x_gl_encumbered_date DATE,
2470:
2471: -- because of changes due to WF synch mode this input parameter is not used.
2472: wf_itemkey IN OUT NOCOPY VARCHAR2,
2473: x_new_combination IN OUT NOCOPY BOOLEAN,
2474:
2475: header_att1 VARCHAR2, header_att2 VARCHAR2, header_att3 VARCHAR2,
2476: header_att4 VARCHAR2, header_att5 VARCHAR2, header_att6 VARCHAR2,
2648: x_gl_encumbered_date,
2649:
2650: -- because of changes due to WF synch mode this input parameter is not
2651: -- used.
2652: wf_itemkey,
2653: x_new_combination,
2654:
2655: header_att1, header_att2, header_att3, header_att4, header_att5,
2656: header_att6, header_att7, header_att8, header_att9, header_att10,
2810: x_gl_encumbered_date,
2811:
2812: -- because of changes due to WF synch mode this input parameter is not
2813: -- used.
2814: wf_itemkey,
2815: x_new_combination,
2816:
2817: header_att1, header_att2, header_att3, header_att4, header_att5,
2818: header_att6, header_att7, header_att8, header_att9, header_att10,
2968: x_po_encumberance_flag VARCHAR2,
2969: x_gl_encumbered_date DATE,
2970:
2971: -- because of changes due to WF synch mode this input parameter is not used.
2972: wf_itemkey IN OUT NOCOPY VARCHAR2,
2973: x_new_combination IN OUT NOCOPY BOOLEAN,
2974:
2975: header_att1 VARCHAR2, header_att2 VARCHAR2, header_att3 VARCHAR2,
2976: header_att4 VARCHAR2, header_att5 VARCHAR2, header_att6 VARCHAR2,
3083: x_gl_encumbered_date,
3084:
3085: -- because of changes due to WF synch mode this input
3086: -- parameter is not used.
3087: wf_itemkey,
3088: x_new_combination,
3089:
3090: header_att1, header_att2, header_att3,
3091: header_att4, header_att5, header_att6,