[Home] [Help]
326: , resp_id => l_responsibility_id
327: , resp_appl_id => l_resp_appl_id );
328:
329: -- Setting thresold value to run the process in background
330: l_save_threshold := wf_engine.threshold;
331: wf_engine.threshold := -1;
332:
333:
334: -- Now start fetching the details
327: , resp_appl_id => l_resp_appl_id );
328:
329: -- Setting thresold value to run the process in background
330: l_save_threshold := wf_engine.threshold;
331: wf_engine.threshold := -1;
332:
333:
334: -- Now start fetching the details
335: OPEN l_assignments_csr;
614: END IF;
615: -- End 07/11/00 changes
616: -- We now have all the values in local variables
617: -- Create the WF process
618: wf_engine.CreateProcess ( ItemType => p_wf_item_type
619: , ItemKey => l_itemkey
620: , process => p_wf_process
621: );
622:
620: , process => p_wf_process
621: );
622:
623: --Set approval type
624: wf_engine.SetItemAttrText
625: ( itemtype => p_wf_item_type
626: , itemkey => l_itemkey
627: , aname => 'APPROVAL_TYPE'
628: , avalue => PA_ASGMT_WFSTD.G_SINGLE_APPROVAL );
628: , avalue => PA_ASGMT_WFSTD.G_SINGLE_APPROVAL );
629:
630: -- Now set the values as appropriate in the WF attributes
631: -- Set Project details attributes
632: wf_engine.SetItemAttrNumber
633: ( itemtype => p_wf_item_type
634: , itemkey => l_itemkey
635: , aname => 'PROJECT_ID'
636: , avalue => l_projects_rec.project_id
635: , aname => 'PROJECT_ID'
636: , avalue => l_projects_rec.project_id
637: );
638:
639: wf_engine.SetItemAttrText
640: ( itemtype => p_wf_item_type
641: , itemkey => l_itemkey
642: , aname => 'PROJECT_NUMBER'
643: , avalue => l_projects_rec.segment1
642: , aname => 'PROJECT_NUMBER'
643: , avalue => l_projects_rec.segment1
644: );
645:
646: wf_engine.SetItemAttrText
647: ( itemtype => p_wf_item_type
648: , itemkey => l_itemkey
649: , aname => 'PROJECT_NAME'
650: , avalue => l_projects_rec.name
649: , aname => 'PROJECT_NAME'
650: , avalue => l_projects_rec.name
651: );
652:
653: wf_engine.SetItemAttrText
654: ( itemtype => p_wf_item_type
655: , itemkey => l_itemkey
656: , aname => 'PROJECT_ORGANIZATION'
657: , avalue => l_projects_rec.organization_name
657: , avalue => l_projects_rec.organization_name
658: );
659: /*Commented the code for the bug 3595857
660: Bug 3595857 - Adding the FROM_ROLE_VALUE Attribute
661: wf_engine.SetItemAttrText
662: ( itemtype => p_wf_item_type
663: , itemkey => l_itemkey
664: , aname => 'FROM_ROLE_VALUE'
665: , avalue => fnd_global.user_name
664: , aname => 'FROM_ROLE_VALUE'
665: , avalue => fnd_global.user_name
666: );*/
667:
668: wf_engine.SetItemAttrText
669: ( itemtype => p_wf_item_type
670: , itemkey => l_itemkey
671: , aname => 'PROJECT_LOCATION'
672: , avalue => l_city||' , ' ||l_region||
673: ' , ' ||l_country_name
674: );
675: -- Set the customer name if it is not null
676: IF l_customer_name IS NOT NULL THEN
677: wf_engine.SetItemAttrText
678: ( itemtype => p_wf_item_type
679: , itemkey => l_itemkey
680: , aname => 'PROJECT_CUSTOMER'
681: , avalue => l_customer_name
684:
685:
686: -- Set Assignment related attributes
687:
688: wf_engine.SetItemAttrNumber
689: ( itemtype => p_wf_item_type
690: , itemkey => l_itemkey
691: , aname => 'ASSIGNMENT_ID'
692: , avalue => l_assignments_rec.assignment_id
691: , aname => 'ASSIGNMENT_ID'
692: , avalue => l_assignments_rec.assignment_id
693: );
694:
695: wf_engine.SetItemAttrText
696: ( itemtype => p_wf_item_type
697: , itemkey => l_itemkey
698: , aname => 'ASSIGNMENT_NAME'
699: , avalue => l_assignments_rec.assignment_name
698: , aname => 'ASSIGNMENT_NAME'
699: , avalue => l_assignments_rec.assignment_name
700: );
701:
702: wf_engine.SetItemAttrText
703: ( itemtype => p_wf_item_type
704: , itemkey => l_itemkey
705: , aname => 'ASSIGNMENT_TYPE'
706: , avalue => l_assignments_rec.assignment_type
705: , aname => 'ASSIGNMENT_TYPE'
706: , avalue => l_assignments_rec.assignment_type
707: );
708:
709: wf_engine.SetItemAttrText
710: ( itemtype => p_wf_item_type
711: , itemkey => l_itemkey
712: , aname => 'DESCRIPTION'
713: , avalue => l_assignments_rec.description
714: );
715:
716: /* Added for bug 3051110 */
717:
718: wf_engine.SetItemAttrNumber(itemtype => p_wf_item_type
719: , Itemkey => l_itemkey
720: , aname => 'TRANSFER_PRICE_RATE'
721: , avalue => l_assignments_rec.transfer_price_rate);
722:
719: , Itemkey => l_itemkey
720: , aname => 'TRANSFER_PRICE_RATE'
721: , avalue => l_assignments_rec.transfer_price_rate);
722:
723: wf_engine.SetItemAttrtext(itemtype => p_wf_item_type
724: , Itemkey => l_itemkey
725: , aname => 'TRANSFER_PR_RATE_CURR'
726: , avalue => l_assignments_rec.transfer_pr_rate_curr);
727:
724: , Itemkey => l_itemkey
725: , aname => 'TRANSFER_PR_RATE_CURR'
726: , avalue => l_assignments_rec.transfer_pr_rate_curr);
727:
728: wf_engine.SetItemAttrText
729: ( itemtype => p_wf_item_type
730: , itemkey => l_itemkey
731: , aname => 'ADDITIONAL_INFORMATION'
732: , avalue =>
732: , avalue =>
733: l_assignments_rec.additional_information
734: );
735:
736: wf_engine.SetItemAttrDate
737: (itemtype => p_wf_item_type
738: , itemkey => l_itemkey
739: , aname => 'START_DATE'
740: , avalue => l_assignments_rec.start_date
739: , aname => 'START_DATE'
740: , avalue => l_assignments_rec.start_date
741: );
742:
743: wf_engine.SetItemAttrDate
744: (itemtype => p_wf_item_type
745: , itemkey => l_itemkey
746: , aname => 'END_DATE'
747: , avalue => l_assignments_rec.end_date
746: , aname => 'END_DATE'
747: , avalue => l_assignments_rec.end_date
748: );
749:
750: wf_engine.SetItemAttrNumber
751: ( itemtype => p_wf_item_type
752: , itemkey => l_itemkey
753: , aname => 'ASSIGNMENT_DURATION'
754: , avalue =>
755: (trunc(l_assignments_rec.end_date) -
756: trunc(l_assignments_rec.start_date)+1)
757: );
758:
759: wf_engine.SetItemAttrNumber
760: ( itemtype => p_wf_item_type
761: , itemkey => l_itemkey
762: , aname => 'ASSIGNMENT_EFFORT'
763: , avalue => l_assignments_rec.assignment_effort
763: , avalue => l_assignments_rec.assignment_effort
764: );
765:
766: -- Start Additions by RM for bug 2274426
767: wf_engine.SetItemAttrNumber
768: ( itemtype => p_wf_item_type
769: , itemkey => l_itemkey
770: , aname => 'REVENUE_BILL_RATE'
771: , avalue => l_assignments_rec.revenue_bill_rate
769: , itemkey => l_itemkey
770: , aname => 'REVENUE_BILL_RATE'
771: , avalue => l_assignments_rec.revenue_bill_rate
772: );
773: wf_engine.SetItemAttrText
774: ( itemtype => p_wf_item_type
775: , itemkey => l_itemkey
776: , aname => 'REVENUE_BILL_RATE_CURR'
777: , avalue => l_assignments_rec.revenue_currency_code
775: , itemkey => l_itemkey
776: , aname => 'REVENUE_BILL_RATE_CURR'
777: , avalue => l_assignments_rec.revenue_currency_code
778: );
779: wf_engine.SetItemAttrNumber
780: ( itemtype => p_wf_item_type
781: , itemkey => l_itemkey
782: , aname => 'BILL_RATE_OVERRIDE'
783: , avalue => l_assignments_rec.bill_rate_override
781: , itemkey => l_itemkey
782: , aname => 'BILL_RATE_OVERRIDE'
783: , avalue => l_assignments_rec.bill_rate_override
784: );
785: wf_engine.SetItemAttrText
786: ( itemtype => p_wf_item_type
787: , itemkey => l_itemkey
788: , aname => 'BILL_RATE_OVERRIDE_CURR'
789: , avalue => l_assignments_rec.bill_rate_curr_override
788: , aname => 'BILL_RATE_OVERRIDE_CURR'
789: , avalue => l_assignments_rec.bill_rate_curr_override
790: );
791: IF l_assignments_rec.markup_percent_override IS NOT NULL THEN
792: wf_engine.SetItemAttrText
793: ( itemtype => p_wf_item_type
794: , itemkey => l_itemkey
795: , aname => 'MARKUP_PCT_OVERRIDE'
796: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
795: , aname => 'MARKUP_PCT_OVERRIDE'
796: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
797: );
798: ELSE
799: wf_engine.SetItemAttrText
800: ( itemtype => p_wf_item_type
801: , itemkey => l_itemkey
802: , aname => 'MARKUP_PCT_OVERRIDE'
803: , avalue => to_char(l_assignments_rec.markup_percent_override)
802: , aname => 'MARKUP_PCT_OVERRIDE'
803: , avalue => to_char(l_assignments_rec.markup_percent_override)
804: );
805: END IF;
806: wf_engine.SetItemAttrText
807: ( itemtype => p_wf_item_type
808: , itemkey => l_itemkey
809: , aname => 'TP_AMT_TYPE_NAME'
810: , avalue => l_assignments_rec.fcst_tp_amount_type_name
808: , itemkey => l_itemkey
809: , aname => 'TP_AMT_TYPE_NAME'
810: , avalue => l_assignments_rec.fcst_tp_amount_type_name
811: );
812: wf_engine.SetItemAttrNumber
813: ( itemtype => p_wf_item_type
814: , itemkey => l_itemkey
815: , aname => 'TP_RATE_OVERRIDE'
816: , avalue => l_assignments_rec.tp_rate_override
814: , itemkey => l_itemkey
815: , aname => 'TP_RATE_OVERRIDE'
816: , avalue => l_assignments_rec.tp_rate_override
817: );
818: wf_engine.SetItemAttrText
819: ( itemtype => p_wf_item_type
820: , itemkey => l_itemkey
821: , aname => 'TP_RATE_OVERRIDE_CURR'
822: , avalue => l_assignments_rec.tp_currency_override
825: open csr_get_override_basis_name(l_assignments_rec.tp_calc_base_code_override);
826: fetch csr_get_override_basis_name into l_override_basis_name;
827: close csr_get_override_basis_name;
828: END IF;
829: wf_engine.SetItemAttrText
830: ( itemtype => p_wf_item_type
831: , itemkey => l_itemkey
832: , aname => 'OVERRIDE_BASIS_NAME'
833: , avalue => l_override_basis_name
833: , avalue => l_override_basis_name
834: );
835: IF l_assignments_rec.tp_percent_applied_override IS NOT NULL THEN
836: IF l_override_basis_name IS NOT NULL THEN
837: wf_engine.SetItemAttrText
838: ( itemtype => p_wf_item_type
839: , itemkey => l_itemkey
840: , aname => 'TP_PCT_APPLIED_OVERRIDE'
841: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
840: , aname => 'TP_PCT_APPLIED_OVERRIDE'
841: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
842: );
843: ELSE
844: wf_engine.SetItemAttrText
845: ( itemtype => p_wf_item_type
846: , itemkey => l_itemkey
847: , aname => 'TP_PCT_APPLIED_OVERRIDE'
848: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
848: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
849: );
850: END IF;
851: ELSE
852: wf_engine.SetItemAttrText
853: ( itemtype => p_wf_item_type
854: , itemkey => l_itemkey
855: , aname => 'TP_PCT_APPLIED_OVERRIDE'
856: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
855: , aname => 'TP_PCT_APPLIED_OVERRIDE'
856: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
857: );
858: END IF;
859: wf_engine.SetItemAttrText
860: ( itemtype => p_wf_item_type
861: , itemkey => l_itemkey
862: , aname => 'WORK_TYPE_NAME'
863: , avalue => l_assignments_rec.work_type_name
863: , avalue => l_assignments_rec.work_type_name
864: );
865: -- End of Additions by RM
866:
867: wf_engine.SetItemAttrText
868: ( itemtype => p_wf_item_type
869: , itemkey => l_itemkey
870: , aname => 'CURRENT_ASGMT_STATUS_CODE'
871: , avalue => l_assignments_rec.apprvl_status_code
870: , aname => 'CURRENT_ASGMT_STATUS_CODE'
871: , avalue => l_assignments_rec.apprvl_status_code
872: );
873:
874: wf_engine.SetItemAttrText
875: ( itemtype => p_wf_item_type
876: , itemkey => l_itemkey
877: , aname => 'NOTE_TO_APPROVER'
878: , avalue => l_assignments_rec.note_to_approver
876: , itemkey => l_itemkey
877: , aname => 'NOTE_TO_APPROVER'
878: , avalue => l_assignments_rec.note_to_approver
879: );
880: wf_engine.SetItemAttrText
881: ( itemtype => p_wf_item_type
882: , itemkey => l_itemkey
883: , aname => 'ASGMT_FAILURE_STATUS_CODE'
884: , avalue => l_wf_failure_status_code
883: , aname => 'ASGMT_FAILURE_STATUS_CODE'
884: , avalue => l_wf_failure_status_code
885: );
886:
887: wf_engine.SetItemAttrText
888: ( itemtype => p_wf_item_type
889: , itemkey => l_itemkey
890: , aname => 'ASGMT_SUCCESS_STATUS_CODE'
891: , avalue => l_wf_success_status_code
889: , itemkey => l_itemkey
890: , aname => 'ASGMT_SUCCESS_STATUS_CODE'
891: , avalue => l_wf_success_status_code
892: );
893: wf_engine.SetItemAttrText
894: ( itemtype => p_wf_item_type
895: , itemkey => l_itemkey
896: , aname => 'PROJECT_STATUS_NAME'
897: , avalue => l_project_status_name
896: , aname => 'PROJECT_STATUS_NAME'
897: , avalue => l_project_status_name
898: );
899:
900: wf_engine.SetItemAttrText
901: ( itemtype => p_wf_item_type
902: , itemkey => l_itemkey
903: , aname => 'REAPPROVAL_FLAG'
904: , avalue => l_reapproval_flag
904: , avalue => l_reapproval_flag
905: );
906: -- Set the previously approved values , if it is a re-approval
907: IF l_reapproval_flag = 'Y' THEN
908: wf_engine.SetItemAttrNumber
909: ( itemtype => p_wf_item_type
910: , itemkey => l_itemkey
911: , aname => 'PREV_DURATION'
912: , avalue => l_prev_asgmt_info_rec.prev_duration );
909: ( itemtype => p_wf_item_type
910: , itemkey => l_itemkey
911: , aname => 'PREV_DURATION'
912: , avalue => l_prev_asgmt_info_rec.prev_duration );
913: wf_engine.SetItemAttrNumber
914: ( itemtype => p_wf_item_type
915: , itemkey => l_itemkey
916: , aname => 'PREV_EFFORT'
917: , avalue => l_prev_asgmt_info_rec.prev_effort );
918: END IF;
919:
920: -- Set resource related attributes
921:
922: wf_engine.SetItemAttrNumber
923: ( itemtype => p_wf_item_type
924: , itemkey => l_itemkey
925: , aname => 'RESOURCE_ID'
926: , avalue => l_resource_rec.resource_id
925: , aname => 'RESOURCE_ID'
926: , avalue => l_resource_rec.resource_id
927: );
928:
929: wf_engine.SetItemAttrNumber
930: ( itemtype => p_wf_item_type
931: , itemkey => l_itemkey
932: , aname => 'RESOURCE_PERSON_ID'
933: , avalue => l_resource_person_id
932: , aname => 'RESOURCE_PERSON_ID'
933: , avalue => l_resource_person_id
934: );
935:
936: wf_engine.SetItemAttrText
937: ( itemtype => p_wf_item_type
938: , itemkey => l_itemkey
939: , aname => 'RESOURCE_NAME'
940: , avalue => l_resource_rec.resource_name
939: , aname => 'RESOURCE_NAME'
940: , avalue => l_resource_rec.resource_name
941: );
942:
943: wf_engine.SetItemAttrText
944: ( itemtype => p_wf_item_type
945: , itemkey => l_itemkey
946: , aname => 'RESOURCE_ORGANIZATION'
947: , avalue =>
949: );
950:
951: -- Set project manager attributes
952:
953: wf_engine.SetItemAttrNumber
954: ( itemtype => p_wf_item_type
955: , itemkey => l_itemkey
956: , aname => 'PROJECT_MANAGER_PERSON_ID'
957: , avalue => l_project_manager_person_id
956: , aname => 'PROJECT_MANAGER_PERSON_ID'
957: , avalue => l_project_manager_person_id
958: );
959:
960: wf_engine.SetItemAttrText
961: ( itemtype => p_wf_item_type
962: , itemkey => l_itemkey
963: , aname => 'PROJECT_MANAGER_NAME'
964: , avalue => l_project_manager_name
963: , aname => 'PROJECT_MANAGER_NAME'
964: , avalue => l_project_manager_name
965: );
966:
967: wf_engine.SetItemAttrText
968: ( itemtype => p_wf_item_type
969: , itemkey => l_itemkey
970: , aname => 'PROJECT_MANAGER_UNAME'
971: , avalue =>
972: l_project_manager_uname
973: );
974: -- Set the other attributes
975:
976: wf_engine.SetItemAttrNumber
977: ( itemtype => p_wf_item_type
978: , itemkey => l_itemkey
979: , aname => 'NUMBER_OF_APPROVERS'
980: , avalue => l_number_of_approvers
979: , aname => 'NUMBER_OF_APPROVERS'
980: , avalue => l_number_of_approvers
981: );
982:
983: wf_engine.SetItemAttrNumber
984: ( itemtype => p_wf_item_type
985: , itemkey => l_itemkey
986: , aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
987: , avalue => l_number_of_apprvl_nf_rects
986: , aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
987: , avalue => l_number_of_apprvl_nf_rects
988: );
989:
990: wf_engine.SetItemAttrNumber
991: ( itemtype => p_wf_item_type
992: , itemkey => l_itemkey
993: , aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
994: , avalue => l_number_of_reject_nf_rects
993: , aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
994: , avalue => l_number_of_reject_nf_rects
995: );
996:
997: wf_engine.SetItemAttrNumber
998: ( itemtype => p_wf_item_type
999: , itemkey => l_itemkey
1000: , aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
1001: , avalue => l_number_of_reject_nf_rects
1001: , avalue => l_number_of_reject_nf_rects
1002: );
1003:
1004:
1005: wf_engine.SetItemAttrNumber
1006: ( itemtype => p_wf_item_type
1007: , itemkey => l_itemkey
1008: , aname => 'APPROVER_LOOP_COUNTER'
1009: , avalue => 0
1007: , itemkey => l_itemkey
1008: , aname => 'APPROVER_LOOP_COUNTER'
1009: , avalue => 0
1010: );
1011: wf_engine.SetItemAttrNumber
1012: ( itemtype => p_wf_item_type
1013: , itemkey => l_itemkey
1014: , aname => 'APPROVAL_NF_LOOP_COUNTER'
1015: , avalue => 0
1013: , itemkey => l_itemkey
1014: , aname => 'APPROVAL_NF_LOOP_COUNTER'
1015: , avalue => 0
1016: );
1017: wf_engine.SetItemAttrNumber
1018: ( itemtype => p_wf_item_type
1019: , itemkey => l_itemkey
1020: , aname => 'REJECTION_NF_LOOP_COUNTER'
1021: , avalue => 0
1020: , aname => 'REJECTION_NF_LOOP_COUNTER'
1021: , avalue => 0
1022: );
1023:
1024: wf_engine.SetItemAttrNumber
1025: ( itemtype => p_wf_item_type
1026: , itemkey => l_itemkey
1027: , aname => 'CANCELLATION_NF_LOOP_COUNTER'
1028: , avalue => 0
1027: , aname => 'CANCELLATION_NF_LOOP_COUNTER'
1028: , avalue => 0
1029: );
1030:
1031: wf_engine.SetItemAttrNumber
1032: ( itemtype => p_wf_item_type
1033: , itemkey => l_itemkey
1034: , aname => 'APPROVER_1_PERSON_ID'
1035: , avalue => p_approver1_person_id
1034: , aname => 'APPROVER_1_PERSON_ID'
1035: , avalue => p_approver1_person_id
1036: );
1037:
1038: wf_engine.SetItemAttrNumber
1039: ( itemtype => p_wf_item_type
1040: , itemkey => l_itemkey
1041: , aname => 'APPROVER_2_PERSON_ID'
1042: , avalue => p_approver2_person_id
1041: , aname => 'APPROVER_2_PERSON_ID'
1042: , avalue => p_approver2_person_id
1043: );
1044:
1045: wf_engine.SetItemAttrText
1046: ( itemtype => p_wf_item_type
1047: , itemkey => l_itemkey
1048: , aname => 'APPROVER1_USER_NAME'
1049: , avalue => l_approver1_user_name
1048: , aname => 'APPROVER1_USER_NAME'
1049: , avalue => l_approver1_user_name
1050: );
1051:
1052: wf_engine.SetItemAttrText
1053: ( itemtype => p_wf_item_type
1054: , itemkey => l_itemkey
1055: , aname => 'APPROVER2_USER_NAME'
1056: , avalue => l_approver2_user_name
1054: , itemkey => l_itemkey
1055: , aname => 'APPROVER2_USER_NAME'
1056: , avalue => l_approver2_user_name
1057: );
1058: wf_engine.SetItemAttrText
1059: ( itemtype => p_wf_item_type
1060: , itemkey => l_itemkey
1061: , aname => 'APPROVER_1_TYPE'
1062: , avalue => l_approver1_type
1060: , itemkey => l_itemkey
1061: , aname => 'APPROVER_1_TYPE'
1062: , avalue => l_approver1_type
1063: );
1064: wf_engine.SetItemAttrText
1065: ( itemtype => p_wf_item_type
1066: , itemkey => l_itemkey
1067: , aname => 'APPROVER_2_TYPE'
1068: , avalue => l_approver2_type
1066: , itemkey => l_itemkey
1067: , aname => 'APPROVER_2_TYPE'
1068: , avalue => l_approver2_type
1069: );
1070: wf_engine.SetItemAttrText
1071: ( itemtype => p_wf_item_type
1072: , itemkey => l_itemkey
1073: , aname => 'APPROVAL_NF_REC1_USER_NAME'
1074: , avalue => l_apprvl_nf_rec1_uname
1073: , aname => 'APPROVAL_NF_REC1_USER_NAME'
1074: , avalue => l_apprvl_nf_rec1_uname
1075: );
1076:
1077: wf_engine.SetItemAttrText
1078: ( itemtype => p_wf_item_type
1079: , itemkey => l_itemkey
1080: , aname => 'APPROVAL_NF_REC1_USER_TYPE'
1081: , avalue => l_apprvl_nf_rec1_utype
1079: , itemkey => l_itemkey
1080: , aname => 'APPROVAL_NF_REC1_USER_TYPE'
1081: , avalue => l_apprvl_nf_rec1_utype
1082: );
1083: wf_engine.SetItemAttrNumber
1084: ( itemtype => p_wf_item_type
1085: , itemkey => l_itemkey
1086: , aname => 'APPROVAL_NF_REC1_PERSON_ID'
1087: , avalue => l_apprvl_nf_rec1_person_id
1085: , itemkey => l_itemkey
1086: , aname => 'APPROVAL_NF_REC1_PERSON_ID'
1087: , avalue => l_apprvl_nf_rec1_person_id
1088: );
1089: wf_engine.SetItemAttrText
1090: ( itemtype => p_wf_item_type
1091: , itemkey => l_itemkey
1092: , aname => 'APPROVAL_NF_REC2_USER_NAME'
1093: , avalue => l_apprvl_nf_rec2_uname
1091: , itemkey => l_itemkey
1092: , aname => 'APPROVAL_NF_REC2_USER_NAME'
1093: , avalue => l_apprvl_nf_rec2_uname
1094: );
1095: wf_engine.SetItemAttrText
1096: ( itemtype => p_wf_item_type
1097: , itemkey => l_itemkey
1098: , aname => 'APPROVAL_NF_REC2_USER_TYPE'
1099: , avalue => l_apprvl_nf_rec2_utype
1097: , itemkey => l_itemkey
1098: , aname => 'APPROVAL_NF_REC2_USER_TYPE'
1099: , avalue => l_apprvl_nf_rec2_utype
1100: );
1101: wf_engine.SetItemAttrNumber
1102: ( itemtype => p_wf_item_type
1103: , itemkey => l_itemkey
1104: , aname => 'APPROVAL_NF_REC2_PERSON_ID'
1105: , avalue => l_apprvl_nf_rec2_person_id
1103: , itemkey => l_itemkey
1104: , aname => 'APPROVAL_NF_REC2_PERSON_ID'
1105: , avalue => l_apprvl_nf_rec2_person_id
1106: );
1107: wf_engine.SetItemAttrText
1108: ( itemtype => p_wf_item_type
1109: , itemkey => l_itemkey
1110: , aname => 'APPROVAL_NF_REC3_USER_NAME'
1111: , avalue => l_apprvl_nf_rec3_uname
1109: , itemkey => l_itemkey
1110: , aname => 'APPROVAL_NF_REC3_USER_NAME'
1111: , avalue => l_apprvl_nf_rec3_uname
1112: );
1113: wf_engine.SetItemAttrText
1114: ( itemtype => p_wf_item_type
1115: , itemkey => l_itemkey
1116: , aname => 'APPROVAL_NF_REC3_USER_TYPE'
1117: , avalue => l_apprvl_nf_rec3_utype
1115: , itemkey => l_itemkey
1116: , aname => 'APPROVAL_NF_REC3_USER_TYPE'
1117: , avalue => l_apprvl_nf_rec3_utype
1118: );
1119: wf_engine.SetItemAttrNumber
1120: ( itemtype => p_wf_item_type
1121: , itemkey => l_itemkey
1122: , aname => 'APPROVAL_NF_REC3_PERSON_ID'
1123: , avalue => l_apprvl_nf_rec3_person_id
1123: , avalue => l_apprvl_nf_rec3_person_id
1124: );
1125: -- Ramesh 07/11/00
1126: IF l_apprvl_nf_rec4_uname IS NOT NULL THEN
1127: wf_engine.SetItemAttrText
1128: ( itemtype => p_wf_item_type
1129: , itemkey => l_itemkey
1130: , aname => 'APPROVAL_NF_REC4_USER_NAME'
1131: , avalue => l_apprvl_nf_rec4_uname
1129: , itemkey => l_itemkey
1130: , aname => 'APPROVAL_NF_REC4_USER_NAME'
1131: , avalue => l_apprvl_nf_rec4_uname
1132: );
1133: wf_engine.SetItemAttrText
1134: ( itemtype => p_wf_item_type
1135: , itemkey => l_itemkey
1136: , aname => 'APPROVAL_NF_REC4_USER_TYPE'
1137: , avalue => l_apprvl_nf_rec4_utype
1135: , itemkey => l_itemkey
1136: , aname => 'APPROVAL_NF_REC4_USER_TYPE'
1137: , avalue => l_apprvl_nf_rec4_utype
1138: );
1139: wf_engine.SetItemAttrNumber
1140: ( itemtype => p_wf_item_type
1141: , itemkey => l_itemkey
1142: , aname => 'APPROVAL_NF_REC4_PERSON_ID'
1143: , avalue => l_apprvl_nf_rec4_person_id
1144: );
1145: END IF;
1146: -- End 07/11/00 changes
1147:
1148: wf_engine.SetItemAttrText
1149: ( itemtype => p_wf_item_type
1150: , itemkey => l_itemkey
1151: , aname => 'REJECT_NF_REC1_USER_NAME'
1152: , avalue => l_reject_nf_rec1_uname
1150: , itemkey => l_itemkey
1151: , aname => 'REJECT_NF_REC1_USER_NAME'
1152: , avalue => l_reject_nf_rec1_uname
1153: );
1154: wf_engine.SetItemAttrText
1155: ( itemtype => p_wf_item_type
1156: , itemkey => l_itemkey
1157: , aname => 'REJECT_NF_REC1_USER_TYPE'
1158: , avalue => l_reject_nf_rec1_utype
1156: , itemkey => l_itemkey
1157: , aname => 'REJECT_NF_REC1_USER_TYPE'
1158: , avalue => l_reject_nf_rec1_utype
1159: );
1160: wf_engine.SetItemAttrNumber
1161: ( itemtype => p_wf_item_type
1162: , itemkey => l_itemkey
1163: , aname => 'REJECT_NF_REC1_PERSON_ID'
1164: , avalue => l_reject_nf_rec1_person_id
1162: , itemkey => l_itemkey
1163: , aname => 'REJECT_NF_REC1_PERSON_ID'
1164: , avalue => l_reject_nf_rec1_person_id
1165: );
1166: wf_engine.SetItemAttrText
1167: ( itemtype => p_wf_item_type
1168: , itemkey => l_itemkey
1169: , aname => 'REJECT_NF_REC2_USER_NAME'
1170: , avalue => l_reject_nf_rec2_uname
1168: , itemkey => l_itemkey
1169: , aname => 'REJECT_NF_REC2_USER_NAME'
1170: , avalue => l_reject_nf_rec2_uname
1171: );
1172: wf_engine.SetItemAttrText
1173: ( itemtype => p_wf_item_type
1174: , itemkey => l_itemkey
1175: , aname => 'REJECT_NF_REC2_USER_TYPE'
1176: , avalue => l_reject_nf_rec2_utype
1174: , itemkey => l_itemkey
1175: , aname => 'REJECT_NF_REC2_USER_TYPE'
1176: , avalue => l_reject_nf_rec2_utype
1177: );
1178: wf_engine.SetItemAttrNumber
1179: ( itemtype => p_wf_item_type
1180: , itemkey => l_itemkey
1181: , aname => 'REJECT_NF_REC2_PERSON_ID'
1182: , avalue => l_reject_nf_rec2_person_id
1180: , itemkey => l_itemkey
1181: , aname => 'REJECT_NF_REC2_PERSON_ID'
1182: , avalue => l_reject_nf_rec2_person_id
1183: );
1184: wf_engine.SetItemAttrText
1185: ( itemtype => p_wf_item_type
1186: , itemkey => l_itemkey
1187: , aname => 'REJECT_NF_REC3_USER_NAME'
1188: , avalue => l_reject_nf_rec3_uname
1186: , itemkey => l_itemkey
1187: , aname => 'REJECT_NF_REC3_USER_NAME'
1188: , avalue => l_reject_nf_rec3_uname
1189: );
1190: wf_engine.SetItemAttrText
1191: ( itemtype => p_wf_item_type
1192: , itemkey => l_itemkey
1193: , aname => 'REJECT_NF_REC3_USER_TYPE'
1194: , avalue => l_reject_nf_rec3_utype
1192: , itemkey => l_itemkey
1193: , aname => 'REJECT_NF_REC3_USER_TYPE'
1194: , avalue => l_reject_nf_rec3_utype
1195: );
1196: wf_engine.SetItemAttrNumber
1197: ( itemtype => p_wf_item_type
1198: , itemkey => l_itemkey
1199: , aname => 'REJECT_NF_REC3_PERSON_ID'
1200: , avalue => l_reject_nf_rec3_person_id
1200: , avalue => l_reject_nf_rec3_person_id
1201: );
1202: -- Ramesh 07/11/00 changes
1203: IF l_reject_nf_rec4_uname IS NOT NULL THEN
1204: wf_engine.SetItemAttrText
1205: ( itemtype => p_wf_item_type
1206: , itemkey => l_itemkey
1207: , aname => 'REJECT_NF_REC4_USER_NAME'
1208: , avalue => l_reject_nf_rec4_uname
1206: , itemkey => l_itemkey
1207: , aname => 'REJECT_NF_REC4_USER_NAME'
1208: , avalue => l_reject_nf_rec4_uname
1209: );
1210: wf_engine.SetItemAttrText
1211: ( itemtype => p_wf_item_type
1212: , itemkey => l_itemkey
1213: , aname => 'REJECT_NF_REC4_USER_TYPE'
1214: , avalue => l_reject_nf_rec4_utype
1212: , itemkey => l_itemkey
1213: , aname => 'REJECT_NF_REC4_USER_TYPE'
1214: , avalue => l_reject_nf_rec4_utype
1215: );
1216: wf_engine.SetItemAttrNumber
1217: ( itemtype => p_wf_item_type
1218: , itemkey => l_itemkey
1219: , aname => 'REJECT_NF_REC4_PERSON_ID'
1220: , avalue => l_reject_nf_rec4_person_id
1221: );
1222: END IF;
1223: -- End 07/11/00 changes
1224:
1225: wf_engine.SetItemAttrText
1226: ( itemtype => p_wf_item_type
1227: , itemkey => l_itemkey
1228: , aname => 'CANCEL_NF_REC1_USER_NAME'
1229: , avalue => l_cancel_nf_rec1_uname
1227: , itemkey => l_itemkey
1228: , aname => 'CANCEL_NF_REC1_USER_NAME'
1229: , avalue => l_cancel_nf_rec1_uname
1230: );
1231: wf_engine.SetItemAttrText
1232: ( itemtype => p_wf_item_type
1233: , itemkey => l_itemkey
1234: , aname => 'CANCEL_NF_REC1_USER_TYPE'
1235: , avalue => l_cancel_nf_rec1_utype
1233: , itemkey => l_itemkey
1234: , aname => 'CANCEL_NF_REC1_USER_TYPE'
1235: , avalue => l_cancel_nf_rec1_utype
1236: );
1237: wf_engine.SetItemAttrNumber
1238: ( itemtype => p_wf_item_type
1239: , itemkey => l_itemkey
1240: , aname => 'CANCEL_NF_REC1_PERSON_ID'
1241: , avalue => l_cancel_nf_rec1_person_id
1239: , itemkey => l_itemkey
1240: , aname => 'CANCEL_NF_REC1_PERSON_ID'
1241: , avalue => l_cancel_nf_rec1_person_id
1242: );
1243: wf_engine.SetItemAttrText
1244: ( itemtype => p_wf_item_type
1245: , itemkey => l_itemkey
1246: , aname => 'CANCEL_NF_REC2_USER_NAME'
1247: , avalue => l_cancel_nf_rec2_uname
1245: , itemkey => l_itemkey
1246: , aname => 'CANCEL_NF_REC2_USER_NAME'
1247: , avalue => l_cancel_nf_rec2_uname
1248: );
1249: wf_engine.SetItemAttrText
1250: ( itemtype => p_wf_item_type
1251: , itemkey => l_itemkey
1252: , aname => 'CANCEL_NF_REC2_USER_TYPE'
1253: , avalue => l_cancel_nf_rec2_utype
1251: , itemkey => l_itemkey
1252: , aname => 'CANCEL_NF_REC2_USER_TYPE'
1253: , avalue => l_cancel_nf_rec2_utype
1254: );
1255: wf_engine.SetItemAttrNumber
1256: ( itemtype => p_wf_item_type
1257: , itemkey => l_itemkey
1258: , aname => 'CANCEL_NF_REC2_PERSON_ID'
1259: , avalue => l_cancel_nf_rec2_person_id
1257: , itemkey => l_itemkey
1258: , aname => 'CANCEL_NF_REC2_PERSON_ID'
1259: , avalue => l_cancel_nf_rec2_person_id
1260: );
1261: wf_engine.SetItemAttrText
1262: ( itemtype => p_wf_item_type
1263: , itemkey => l_itemkey
1264: , aname => 'CANCEL_NF_REC3_USER_NAME'
1265: , avalue => l_cancel_nf_rec3_uname
1263: , itemkey => l_itemkey
1264: , aname => 'CANCEL_NF_REC3_USER_NAME'
1265: , avalue => l_cancel_nf_rec3_uname
1266: );
1267: wf_engine.SetItemAttrText
1268: ( itemtype => p_wf_item_type
1269: , itemkey => l_itemkey
1270: , aname => 'CANCEL_NF_REC3_USER_TYPE'
1271: , avalue => l_cancel_nf_rec3_utype
1269: , itemkey => l_itemkey
1270: , aname => 'CANCEL_NF_REC3_USER_TYPE'
1271: , avalue => l_cancel_nf_rec3_utype
1272: );
1273: wf_engine.SetItemAttrNumber
1274: ( itemtype => p_wf_item_type
1275: , itemkey => l_itemkey
1276: , aname => 'CANCEL_NF_REC3_PERSON_ID'
1277: , avalue => l_cancel_nf_rec3_person_id
1277: , avalue => l_cancel_nf_rec3_person_id
1278: );
1279: -- Ramesh 07/11/00 changes
1280: IF l_cancel_nf_rec4_uname IS NOT NULL THEN
1281: wf_engine.SetItemAttrText
1282: ( itemtype => p_wf_item_type
1283: , itemkey => l_itemkey
1284: , aname => 'CANCEL_NF_REC4_USER_NAME'
1285: , avalue => l_cancel_nf_rec4_uname
1283: , itemkey => l_itemkey
1284: , aname => 'CANCEL_NF_REC4_USER_NAME'
1285: , avalue => l_cancel_nf_rec4_uname
1286: );
1287: wf_engine.SetItemAttrText
1288: ( itemtype => p_wf_item_type
1289: , itemkey => l_itemkey
1290: , aname => 'CANCEL_NF_REC4_USER_TYPE'
1291: , avalue => l_cancel_nf_rec4_utype
1289: , itemkey => l_itemkey
1290: , aname => 'CANCEL_NF_REC4_USER_TYPE'
1291: , avalue => l_cancel_nf_rec4_utype
1292: );
1293: wf_engine.SetItemAttrNumber
1294: ( itemtype => p_wf_item_type
1295: , itemkey => l_itemkey
1296: , aname => 'CANCEL_NF_REC4_PERSON_ID'
1297: , avalue => l_cancel_nf_rec4_person_id
1303: -- and apprvl item key . This would be the item type
1304: -- and item key of the approval process
1305: IF (p_apprvl_item_type IS NOT NULL AND p_apprvl_item_key
1306: IS NOT NULL ) THEN
1307: wf_engine.SetItemAttrText
1308: ( itemtype => p_wf_item_type
1309: , itemkey => l_itemkey
1310: , aname => 'APPRVL_ITEM_TYPE'
1311: , avalue => p_apprvl_item_type
1309: , itemkey => l_itemkey
1310: , aname => 'APPRVL_ITEM_TYPE'
1311: , avalue => p_apprvl_item_type
1312: );
1313: wf_engine.SetItemAttrText
1314: ( itemtype => p_wf_item_type
1315: , itemkey => l_itemkey
1316: , aname => 'APPRVL_ITEM_KEY'
1317: , avalue => p_apprvl_item_key
1318: );
1319: /*Bug 3817940 : Code addition Starts*/
1320: if p_wf_process = 'PA_APRVL_NF_SP' or p_wf_process = 'PA_CANCEL_NF_SP' or p_wf_process = 'PA_REJ_NF_SP'
1321: Then
1322: l_last_approver_uname := wf_engine.GetItemAttrText
1323: ( itemtype => p_apprvl_item_type
1324: , itemkey => p_apprvl_item_key
1325: , aname => 'APPROVER_UNAME');
1326:
1323: ( itemtype => p_apprvl_item_type
1324: , itemkey => p_apprvl_item_key
1325: , aname => 'APPROVER_UNAME');
1326:
1327: wf_engine.SetItemAttrText
1328: ( itemtype => p_wf_item_type
1329: , itemkey => l_itemkey
1330: , aname => 'FROM_ROLE_VALUE1'
1331: , avalue => l_last_approver_uname
1352: END IF ;
1353: /*Code modification ends for bug 6408552*/
1354: l_resource_schedules_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275&akRegionCode=PA_VIEW_RESOURCE_LAYOUT&paResourceId='||l_resource_rec.resource_id||'&addBreadCrumb=RP';
1355:
1356: wf_engine.SetItemAttrText
1357: ( itemtype => p_wf_item_type
1358: , itemkey => l_itemkey
1359: , aname => 'ASSIGNMENT_DETAILS_URL_INFO'
1360: , avalue => l_asgmt_details_url
1358: , itemkey => l_itemkey
1359: , aname => 'ASSIGNMENT_DETAILS_URL_INFO'
1360: , avalue => l_asgmt_details_url
1361: );
1362: wf_engine.SetItemAttrText
1363: ( itemtype => p_wf_item_type
1364: , itemkey => l_itemkey
1365: , aname => 'RESOURCE_DETAILS_URL_INFO'
1366: , avalue => l_resource_details_url
1364: , itemkey => l_itemkey
1365: , aname => 'RESOURCE_DETAILS_URL_INFO'
1366: , avalue => l_resource_details_url
1367: );
1368: wf_engine.SetItemAttrText
1369: ( itemtype => p_wf_item_type
1370: , itemkey => l_itemkey
1371: , aname => 'RESOURCE_SCHEDULES_URL_INFO'
1372: , avalue => l_resource_schedules_url
1371: , aname => 'RESOURCE_SCHEDULES_URL_INFO'
1372: , avalue => l_resource_schedules_url
1373: );
1374:
1375: wf_engine.SetItemAttrNumber
1376: ( itemtype => p_wf_item_type
1377: , itemkey => l_itemkey
1378: , aname => 'CONFLICT_GROUP_ID'
1379: , avalue => p_conflict_group_id
1383: -- Get the current user_id using FND_GLOBAL.USER_ID
1384: -- Get the user name from the user id
1385: -- Set the workflow started by user name
1386: l_workflow_started_by_uname := FND_GLOBAL.USER_NAME;
1387: wf_engine.SetItemAttrText
1388: ( itemtype => p_wf_item_type
1389: , itemkey => l_itemkey
1390: , aname => 'WORKFLOW_STARTED_BY_UNAME'
1391: , avalue => l_workflow_started_by_uname
1412: -- by the product , which is 3
1413: l_number_of_reminders := 3;
1414: END IF;
1415: -- Now set the appropriate attributes in the workflow process
1416: wf_engine.SetItemAttrNumber
1417: ( itemtype => p_wf_item_type
1418: , itemkey => l_itemkey
1419: , aname => 'TIMEOUT_WAITING_PERIOD'
1420: , avalue => l_waiting_time
1419: , aname => 'TIMEOUT_WAITING_PERIOD'
1420: , avalue => l_waiting_time
1421: );
1422:
1423: wf_engine.SetItemAttrNumber
1424: ( itemtype => p_wf_item_type
1425: , itemkey => l_itemkey
1426: , aname => 'NUMBER_OF_REMINDERS'
1427: , avalue => l_number_of_reminders
1426: , aname => 'NUMBER_OF_REMINDERS'
1427: , avalue => l_number_of_reminders
1428: );
1429: -- Now start the WF process
1430: wf_engine.StartProcess ( itemtype => p_wf_item_type
1431: , itemkey => l_itemkey );
1432: PA_WORKFLOW_UTILS.Insert_WF_Processes
1433: (p_wf_type_code => 'ASSIGNMENT_APPROVAL'
1434: ,p_item_type => p_wf_item_type
1440: ,p_err_stage => l_err_stage
1441: ,p_err_stack => l_err_stack
1442: );
1443: --Setting the original value
1444: wf_engine.threshold := l_save_threshold;
1445:
1446: -- dbms_output.put_line ('after pa_workflow_utils ');
1447: EXCEPTION
1448: WHEN OTHERS THEN
1446: -- dbms_output.put_line ('after pa_workflow_utils ');
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: --Setting the original value
1450: wf_engine.threshold := l_save_threshold;
1451:
1452: -- dbms_output.put_line ('others exception raised ');
1453: -- dbms_output.put_line ('error is '||SQLERRM);
1454:
1614: BEGIN
1615:
1616: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_URL');
1617: -- Return if WF Not Running
1618: IF (funcmode <> wf_engine.eng_run) THEN
1619: resultout := wf_engine.eng_null;
1620: RETURN;
1621: END IF;
1622: l_assignment_id := wf_engine.GetItemAttrNumber
1615:
1616: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_URL');
1617: -- Return if WF Not Running
1618: IF (funcmode <> wf_engine.eng_run) THEN
1619: resultout := wf_engine.eng_null;
1620: RETURN;
1621: END IF;
1622: l_assignment_id := wf_engine.GetItemAttrNumber
1623: (itemtype => itemtype,
1618: IF (funcmode <> wf_engine.eng_run) THEN
1619: resultout := wf_engine.eng_null;
1620: RETURN;
1621: END IF;
1622: l_assignment_id := wf_engine.GetItemAttrNumber
1623: (itemtype => itemtype,
1624: itemkey => itemkey,
1625: aname => 'ASSIGNMENT_ID');
1626:
1623: (itemtype => itemtype,
1624: itemkey => itemkey,
1625: aname => 'ASSIGNMENT_ID');
1626:
1627: l_resource_person_id := wf_engine.GetItemAttrNumber
1628: (itemtype => itemtype,
1629: itemkey => itemkey,
1630: aname => 'RESOURCE_PERSON_ID');
1631:
1628: (itemtype => itemtype,
1629: itemkey => itemkey,
1630: aname => 'RESOURCE_PERSON_ID');
1631:
1632: l_resource_id := wf_engine.GetItemAttrNumber
1633: (itemtype => itemtype,
1634: itemkey => itemkey,
1635: aname => 'RESOURCE_ID');
1636:
1633: (itemtype => itemtype,
1634: itemkey => itemkey,
1635: aname => 'RESOURCE_ID');
1636:
1637: l_asgmt_start_date := wf_engine.GetItemAttrDate
1638: (itemtype => itemtype,
1639: itemkey => itemkey,
1640: aname => 'START_DATE');
1641:
1638: (itemtype => itemtype,
1639: itemkey => itemkey,
1640: aname => 'START_DATE');
1641:
1642: l_asgmt_end_date := wf_engine.GetItemAttrDate
1643: (itemtype => itemtype,
1644: itemkey => itemkey,
1645: aname => 'END_DATE');
1646:
1643: (itemtype => itemtype,
1644: itemkey => itemkey,
1645: aname => 'END_DATE');
1646:
1647: l_conflict_group_id := wf_engine.GetItemAttrNumber
1648: (itemtype => itemtype,
1649: itemkey => itemkey,
1650: aname => 'CONFLICT_GROUP_ID');
1651:
1649: itemkey => itemkey,
1650: aname => 'CONFLICT_GROUP_ID');
1651:
1652: /*Added for bug 6408552*/
1653: l_asgmt_type := wf_engine.GetItemAttrText
1654: (itemtype => itemtype,
1655: itemkey => itemkey,
1656: aname => 'ASSIGNMENT_TYPE');
1657: resultout := wf_engine.eng_completed||':'||'S';
1653: l_asgmt_type := wf_engine.GetItemAttrText
1654: (itemtype => itemtype,
1655: itemkey => itemkey,
1656: aname => 'ASSIGNMENT_TYPE');
1657: resultout := wf_engine.eng_completed||':'||'S';
1658: -- call to the generate url api goes here
1659: -- If unable to generate url return
1660: -- resultout := wf_engine.eng_completed||':'||'F';
1661: -- If such URL generation succeded then set the appropriate attributes
1656: aname => 'ASSIGNMENT_TYPE');
1657: resultout := wf_engine.eng_completed||':'||'S';
1658: -- call to the generate url api goes here
1659: -- If unable to generate url return
1660: -- resultout := wf_engine.eng_completed||':'||'F';
1661: -- If such URL generation succeded then set the appropriate attributes
1662: -- so that it gets displayed in the NF
1663: /*Code modified for bug 6408552*/
1664: /*make url with paCalledPage as 'AdminAsmt' for an Admin Assignment*/
1679: l_resource_schedules_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275&akRegionCode='
1680: || 'PA_VIEW_RESOURCE_LAYOUT&paResourceId=' || l_resource_id
1681: || '&addBreadCrumb=RP';
1682:
1683: wf_engine.SetItemAttrText
1684: ( itemtype => itemtype
1685: , itemkey => itemkey
1686: , aname => 'ASSIGNMENT_DETAILS_URL_INFO'
1687: , avalue => l_asgmt_details_url
1685: , itemkey => itemkey
1686: , aname => 'ASSIGNMENT_DETAILS_URL_INFO'
1687: , avalue => l_asgmt_details_url
1688: );
1689: wf_engine.SetItemAttrText
1690: ( itemtype => itemtype
1691: , itemkey => itemkey
1692: , aname => 'RESOURCE_DETAILS_URL_INFO'
1693: , avalue => l_resource_details_url
1691: , itemkey => itemkey
1692: , aname => 'RESOURCE_DETAILS_URL_INFO'
1693: , avalue => l_resource_details_url
1694: );
1695: wf_engine.SetItemAttrText
1696: ( itemtype => itemtype
1697: , itemkey => itemkey
1698: , aname => 'RESOURCE_SCHEDULES_URL_INFO'
1699: , avalue => l_resource_schedules_url
1715: ELSE
1716: l_overcom_description := 'If approved, this assignment will result in an overcommitment of the resource.';
1717: END IF;
1718:
1719: wf_engine.SetItemAttrText
1720: ( itemtype => itemtype
1721: , itemkey => itemkey
1722: , aname => 'OVERCOM_DESCRIPTION'
1723: , avalue => l_overcom_description );
1723: , avalue => l_overcom_description );
1724:
1725: -- set 'Number of Assignments Resulting in Resource Overcommitment -1/0' for single approval
1726: -- required notification.
1727: wf_engine.SetItemAttrNumber
1728: ( itemtype => itemtype
1729: , itemkey => itemkey
1730: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
1731: , avalue => 1 );
1729: , itemkey => itemkey
1730: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
1731: , avalue => 1 );
1732: ELSE
1733: wf_engine.SetItemAttrNumber
1734: ( itemtype => itemtype
1735: , itemkey => itemkey
1736: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
1737: , avalue => 0 );
1741: l_view_conflict_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275&akRegionCode=PA_RES_OVERCOMMITMENT_LAYOUT'
1742: || '&paAssignmentId=' || l_assignment_id || '&paConflictGroupId=' || l_conflict_group_id
1743: || '&paCallingPage=Default&addBreadCrumb=RP';
1744:
1745: wf_engine.SetItemAttrText
1746: ( itemtype => itemtype
1747: , itemkey => itemkey
1748: , aname => 'VIEW_CONFLICT_URL_INFO'
1749: , avalue => l_view_conflict_url );
1758: itemtype,
1759: itemkey,
1760: to_char(actid),
1761: funcmode);
1762: resultout := wf_engine.eng_completed||':'||'F';
1763: RAISE;
1764:
1765: END Generate_URL ;
1766:
1773: ) IS
1774: l_mesg VARCHAR2(240);
1775: BEGIN
1776: -- Return if WF Not Running
1777: IF (funcmode <> wf_engine.eng_run) THEN
1778: resultout := wf_engine.eng_null;
1779: RETURN;
1780: END IF;
1781: FND_MESSAGE.SET_NAME ('PA','PA_ASGMT_URL_GEN_FAILURE');
1774: l_mesg VARCHAR2(240);
1775: BEGIN
1776: -- Return if WF Not Running
1777: IF (funcmode <> wf_engine.eng_run) THEN
1778: resultout := wf_engine.eng_null;
1779: RETURN;
1780: END IF;
1781: FND_MESSAGE.SET_NAME ('PA','PA_ASGMT_URL_GEN_FAILURE');
1782: l_mesg := FND_MESSAGE.GET;
1779: RETURN;
1780: END IF;
1781: FND_MESSAGE.SET_NAME ('PA','PA_ASGMT_URL_GEN_FAILURE');
1782: l_mesg := FND_MESSAGE.GET;
1783: wf_engine.SetItemAttrText
1784: (itemtype => itemtype
1785: ,itemkey => itemkey
1786: ,aname => 'URL_FAILURE_INFO'
1787: ,avalue => l_mesg
1818: l_return_status VARCHAR2(30);
1819: BEGIN
1820: pa_debug.init_err_stack ('pa_asgmt_wfstd.start_new_wf');
1821: -- Return if WF Not Running
1822: IF (funcmode <> wf_engine.eng_run) THEN
1823: resultout := wf_engine.eng_null;
1824: RETURN;
1825: END IF;
1826: l_new_item_type := wf_engine.GetItemAttrText
1819: BEGIN
1820: pa_debug.init_err_stack ('pa_asgmt_wfstd.start_new_wf');
1821: -- Return if WF Not Running
1822: IF (funcmode <> wf_engine.eng_run) THEN
1823: resultout := wf_engine.eng_null;
1824: RETURN;
1825: END IF;
1826: l_new_item_type := wf_engine.GetItemAttrText
1827: (itemtype => itemtype,
1822: IF (funcmode <> wf_engine.eng_run) THEN
1823: resultout := wf_engine.eng_null;
1824: RETURN;
1825: END IF;
1826: l_new_item_type := wf_engine.GetItemAttrText
1827: (itemtype => itemtype,
1828: itemkey => itemkey,
1829: aname => 'NEW_WF_ITEM_TYPE');
1830:
1827: (itemtype => itemtype,
1828: itemkey => itemkey,
1829: aname => 'NEW_WF_ITEM_TYPE');
1830:
1831: l_new_process := wf_engine.GetItemAttrText
1832: (itemtype => itemtype,
1833: itemkey => itemkey,
1834: aname => 'NEW_WF_PROCESS_NAME');
1835: IF (l_new_item_type IS NOT NULL AND
1835: IF (l_new_item_type IS NOT NULL AND
1836: l_new_process IS NOT NULL ) THEN
1837: -- Get the necessary details from the item attributes
1838: l_new_asgmt_status_code :=
1839: wf_engine.GetItemAttrText
1840: (itemtype => itemtype,
1841: itemkey => itemkey,
1842: aname => 'NEW_ASGMT_STATUS_CODE' );
1843: l_project_id := wf_engine.GetItemAttrNumber
1839: wf_engine.GetItemAttrText
1840: (itemtype => itemtype,
1841: itemkey => itemkey,
1842: aname => 'NEW_ASGMT_STATUS_CODE' );
1843: l_project_id := wf_engine.GetItemAttrNumber
1844: (itemtype => itemtype,
1845: itemkey => itemkey,
1846: aname => 'PROJECT_ID' );
1847: l_assignment_id := wf_engine.GetItemAttrNumber
1843: l_project_id := wf_engine.GetItemAttrNumber
1844: (itemtype => itemtype,
1845: itemkey => itemkey,
1846: aname => 'PROJECT_ID' );
1847: l_assignment_id := wf_engine.GetItemAttrNumber
1848: (itemtype => itemtype,
1849: itemkey => itemkey,
1850: aname => 'ASSIGNMENT_ID');
1851: l_resource_person_id := wf_engine.GetItemAttrNumber
1847: l_assignment_id := wf_engine.GetItemAttrNumber
1848: (itemtype => itemtype,
1849: itemkey => itemkey,
1850: aname => 'ASSIGNMENT_ID');
1851: l_resource_person_id := wf_engine.GetItemAttrNumber
1852: (itemtype => itemtype,
1853: itemkey => itemkey,
1854: aname => 'RESOURCE_PERSON_ID');
1855: l_conflict_group_id := wf_engine.GetItemAttrNumber
1851: l_resource_person_id := wf_engine.GetItemAttrNumber
1852: (itemtype => itemtype,
1853: itemkey => itemkey,
1854: aname => 'RESOURCE_PERSON_ID');
1855: l_conflict_group_id := wf_engine.GetItemAttrNumber
1856: (itemtype => itemtype,
1857: itemkey => itemkey,
1858: aname => 'CONFLICT_GROUP_ID');
1859:
1878: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1879: raise_application_error(-20001, l_error_message_code);
1880: END IF;
1881: END IF;
1882: resultout := wf_engine.eng_completed||':'||'S';
1883: pa_debug.reset_err_stack;
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: WF_CORE.CONTEXT
1889: itemtype,
1890: itemkey,
1891: to_char(actid),
1892: funcmode);
1893: resultout := wf_engine.eng_completed||':'||'F';
1894: RAISE ;
1895: END Start_New_WF ;
1896:
1897: PROCEDURE Set_Success_Status (itemtype IN VARCHAR2
1912: l_is_new_assignment_flag VARCHAR2(1);
1913: BEGIN
1914: pa_debug.init_err_stack ('pa_asgmt_wfstd.Set_Success_Status');
1915: -- Return if WF Not Running
1916: IF (funcmode <> wf_engine.eng_run) THEN
1917: resultout := wf_engine.eng_null;
1918: RETURN;
1919: END IF;
1920: l_asgmt_success_status_code :=
1913: BEGIN
1914: pa_debug.init_err_stack ('pa_asgmt_wfstd.Set_Success_Status');
1915: -- Return if WF Not Running
1916: IF (funcmode <> wf_engine.eng_run) THEN
1917: resultout := wf_engine.eng_null;
1918: RETURN;
1919: END IF;
1920: l_asgmt_success_status_code :=
1921: wf_engine.GetItemAttrText
1917: resultout := wf_engine.eng_null;
1918: RETURN;
1919: END IF;
1920: l_asgmt_success_status_code :=
1921: wf_engine.GetItemAttrText
1922: (itemtype => itemtype,
1923: itemkey => itemkey,
1924: aname => 'ASGMT_SUCCESS_STATUS_CODE');
1925: l_assignment_id :=
1922: (itemtype => itemtype,
1923: itemkey => itemkey,
1924: aname => 'ASGMT_SUCCESS_STATUS_CODE');
1925: l_assignment_id :=
1926: wf_engine.GetItemAttrText
1927: (itemtype => itemtype,
1928: itemkey => itemkey,
1929: aname => 'ASSIGNMENT_ID');
1930: -- Now store the approvers' response in the global variable
1951: ,X_MSG_COUNT => l_msg_count
1952: ,X_MSG_DATA => l_msg_data );
1953: */
1954: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1955: resultout := wf_engine.eng_completed||':'||'F';
1956: RETURN;
1957: END IF;
1958: resultout := wf_engine.eng_completed||':'||'S';
1959: pa_debug.reset_err_stack;
1954: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1955: resultout := wf_engine.eng_completed||':'||'F';
1956: RETURN;
1957: END IF;
1958: resultout := wf_engine.eng_completed||':'||'S';
1959: pa_debug.reset_err_stack;
1960:
1961: EXCEPTION
1962: WHEN OTHERS THEN
1966: itemtype,
1967: itemkey,
1968: to_char(actid),
1969: funcmode);
1970: resultout := wf_engine.eng_completed||':'||'F';
1971: RAISE;
1972:
1973: END Set_Success_Status ;
1974:
1989: l_is_new_assignment_flag VARCHAR2(1);
1990: BEGIN
1991: pa_debug.init_err_stack ('pa_asgmt_wfstd.Set_Failure_Status');
1992: -- Return if WF Not Running
1993: IF (funcmode <> wf_engine.eng_run) THEN
1994: resultout := wf_engine.eng_null;
1995: RETURN;
1996: END IF;
1997: l_asgmt_failure_status_code :=
1990: BEGIN
1991: pa_debug.init_err_stack ('pa_asgmt_wfstd.Set_Failure_Status');
1992: -- Return if WF Not Running
1993: IF (funcmode <> wf_engine.eng_run) THEN
1994: resultout := wf_engine.eng_null;
1995: RETURN;
1996: END IF;
1997: l_asgmt_failure_status_code :=
1998: wf_engine.GetItemAttrText
1994: resultout := wf_engine.eng_null;
1995: RETURN;
1996: END IF;
1997: l_asgmt_failure_status_code :=
1998: wf_engine.GetItemAttrText
1999: (itemtype => itemtype,
2000: itemkey => itemkey,
2001: aname => 'ASGMT_FAILURE_STATUS_CODE');
2002: l_assignment_id :=
1999: (itemtype => itemtype,
2000: itemkey => itemkey,
2001: aname => 'ASGMT_FAILURE_STATUS_CODE');
2002: l_assignment_id :=
2003: wf_engine.GetItemAttrText
2004: (itemtype => itemtype,
2005: itemkey => itemkey,
2006: aname => 'ASSIGNMENT_ID');
2007: -- Now store the approvers' response in the global variable
2028: ,x_msg_count => l_msg_count
2029: ,x_msg_data => l_msg_data );
2030: */
2031: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2032: resultout := wf_engine.eng_completed||':'||'F';
2033: RETURN;
2034: END IF;
2035: resultout := wf_engine.eng_completed||':'||'S';
2036: pa_debug.reset_err_stack;
2031: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2032: resultout := wf_engine.eng_completed||':'||'F';
2033: RETURN;
2034: END IF;
2035: resultout := wf_engine.eng_completed||':'||'S';
2036: pa_debug.reset_err_stack;
2037:
2038: EXCEPTION
2039: WHEN OTHERS THEN
2043: itemtype,
2044: itemkey,
2045: to_char(actid),
2046: funcmode);
2047: resultout := wf_engine.eng_completed||':'||'F';
2048: RAISE;
2049: END Set_Failure_Status ;
2050:
2051: PROCEDURE Check_Wf_Enabled (itemtype IN VARCHAR2
2076: resultout = 'T'
2077: */
2078: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_Wf_Enabled');
2079: -- Return if WF Not Running
2080: IF (funcmode <> wf_engine.eng_run) THEN
2081: resultout := wf_engine.eng_null;
2082: RETURN;
2083: END IF;
2084: l_new_asgmt_status_code :=
2077: */
2078: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_Wf_Enabled');
2079: -- Return if WF Not Running
2080: IF (funcmode <> wf_engine.eng_run) THEN
2081: resultout := wf_engine.eng_null;
2082: RETURN;
2083: END IF;
2084: l_new_asgmt_status_code :=
2085: wf_engine.GetItemAttrText
2081: resultout := wf_engine.eng_null;
2082: RETURN;
2083: END IF;
2084: l_new_asgmt_status_code :=
2085: wf_engine.GetItemAttrText
2086: (itemtype => itemtype,
2087: itemkey => itemkey,
2088: aname => 'NEW_ASGMT_STATUS_CODE' );
2089: get_workflow_process_info
2096: ,x_return_status => l_return_status
2097: ,x_error_message_code => l_error_message_code );
2098:
2099: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2100: resultout := wf_engine.eng_completed||':'||'N';
2101: RETURN;
2102: END IF;
2103: IF l_wf_type = 'NOT_ENABLED' THEN
2104: resultout := wf_engine.eng_completed||':'||'N';
2100: resultout := wf_engine.eng_completed||':'||'N';
2101: RETURN;
2102: END IF;
2103: IF l_wf_type = 'NOT_ENABLED' THEN
2104: resultout := wf_engine.eng_completed||':'||'N';
2105: ELSE
2106: IF (l_new_item_type IS NOT NULL AND
2107: l_new_process IS NOT NULL ) THEN
2108: wf_engine.SetItemAttrText
2104: resultout := wf_engine.eng_completed||':'||'N';
2105: ELSE
2106: IF (l_new_item_type IS NOT NULL AND
2107: l_new_process IS NOT NULL ) THEN
2108: wf_engine.SetItemAttrText
2109: (itemtype => itemtype
2110: ,itemkey => itemkey
2111: ,aname => 'NEW_WF_ITEM_TYPE'
2112: ,avalue => l_new_item_type
2110: ,itemkey => itemkey
2111: ,aname => 'NEW_WF_ITEM_TYPE'
2112: ,avalue => l_new_item_type
2113: );
2114: wf_engine.SetItemAttrText
2115: (itemtype => itemtype
2116: ,itemkey => itemkey
2117: ,aname => 'NEW_WF_PROCESS_NAME'
2118: ,avalue => l_new_process
2116: ,itemkey => itemkey
2117: ,aname => 'NEW_WF_PROCESS_NAME'
2118: ,avalue => l_new_process
2119: );
2120: resultout := wf_engine.eng_completed||':'||'Y';
2121: ELSE
2122: resultout := wf_engine.eng_completed||':'||'N';
2123: END IF;
2124: END IF;
2118: ,avalue => l_new_process
2119: );
2120: resultout := wf_engine.eng_completed||':'||'Y';
2121: ELSE
2122: resultout := wf_engine.eng_completed||':'||'N';
2123: END IF;
2124: END IF;
2125: pa_debug.reset_err_stack;
2126: EXCEPTION
2156: l_approvers_list_tbl_idx NUMBER := 1;
2157: BEGIN
2158: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_Approvers');
2159: -- Return if WF Not Running
2160: IF (funcmode <> wf_engine.eng_run) THEN
2161: resultout := wf_engine.eng_null;
2162: RETURN;
2163: END IF;
2164: NULL;
2157: BEGIN
2158: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_Approvers');
2159: -- Return if WF Not Running
2160: IF (funcmode <> wf_engine.eng_run) THEN
2161: resultout := wf_engine.eng_null;
2162: RETURN;
2163: END IF;
2164: NULL;
2165: l_assignment_id := wf_engine.GetItemAttrNumber
2161: resultout := wf_engine.eng_null;
2162: RETURN;
2163: END IF;
2164: NULL;
2165: l_assignment_id := wf_engine.GetItemAttrNumber
2166: (itemtype => itemtype,
2167: itemkey => itemkey,
2168: aname => 'ASSIGNMENT_ID');
2169: l_project_id := wf_engine.GetItemAttrNumber
2165: l_assignment_id := wf_engine.GetItemAttrNumber
2166: (itemtype => itemtype,
2167: itemkey => itemkey,
2168: aname => 'ASSIGNMENT_ID');
2169: l_project_id := wf_engine.GetItemAttrNumber
2170: (itemtype => itemtype,
2171: itemkey => itemkey,
2172: aname => 'PROJECT_ID' );
2173: -- Now populate the PL/SQL table with the 2 approvers
2175: FOR i IN 1..2
2176: LOOP
2177: l_item_attr_name := 'APPROVER_'||i||'_PERSON_ID';
2178: l_approver_person_id :=
2179: wf_engine.GetItemAttrNumber
2180: ( itemtype => itemtype
2181: , itemkey => itemkey
2182: , aname => l_item_attr_name
2183: );
2182: , aname => l_item_attr_name
2183: );
2184:
2185: l_item_attr_name := 'APPROVER'||i||'_USER_NAME';
2186: l_approver_user_name := wf_engine.GetItemAttrText
2187: ( itemtype => itemtype
2188: , itemkey => itemkey
2189: , aname => l_item_attr_name
2190: );
2188: , itemkey => itemkey
2189: , aname => l_item_attr_name
2190: );
2191: l_item_attr_name := 'APPROVER_'||i||'_TYPE';
2192: l_approver_type := wf_engine.GetItemAttrText
2193: ( itemtype => itemtype
2194: , itemkey => itemkey
2195: , aname => l_item_attr_name
2196: );
2223: ,p_current_approver_flag => 'N'
2224: ,x_number_of_performers => l_number_of_approvers );
2225:
2226: -- Now set the number of approvers
2227: wf_engine.SetItemAttrNumber
2228: ( itemtype => itemtype
2229: , itemkey => itemkey
2230: , aname => 'NUMBER_OF_APPROVERS'
2231: , avalue => l_number_of_approvers
2271: Resultout = 'S'
2272: */
2273: -- Return if WF Not Running
2274: pa_debug.init_err_stack ('pa_asgmt_wfstd.get_approver');
2275: IF (funcmode <> wf_engine.eng_run) THEN
2276: resultout := wf_engine.eng_null;
2277: RETURN;
2278: END IF;
2279: l_number_of_approvers := wf_engine.GetItemAttrNumber
2272: */
2273: -- Return if WF Not Running
2274: pa_debug.init_err_stack ('pa_asgmt_wfstd.get_approver');
2275: IF (funcmode <> wf_engine.eng_run) THEN
2276: resultout := wf_engine.eng_null;
2277: RETURN;
2278: END IF;
2279: l_number_of_approvers := wf_engine.GetItemAttrNumber
2280: ( itemtype => itemtype
2275: IF (funcmode <> wf_engine.eng_run) THEN
2276: resultout := wf_engine.eng_null;
2277: RETURN;
2278: END IF;
2279: l_number_of_approvers := wf_engine.GetItemAttrNumber
2280: ( itemtype => itemtype
2281: , itemkey => itemkey
2282: , aname => 'NUMBER_OF_APPROVERS'
2283: );
2280: ( itemtype => itemtype
2281: , itemkey => itemkey
2282: , aname => 'NUMBER_OF_APPROVERS'
2283: );
2284: l_approver_loop_counter := wf_engine.getItemAttrNumber
2285: ( itemtype => itemtype
2286: , itemkey => itemkey
2287: , aname => 'APPROVER_LOOP_COUNTER'
2288: );
2285: ( itemtype => itemtype
2286: , itemkey => itemkey
2287: , aname => 'APPROVER_LOOP_COUNTER'
2288: );
2289: l_assignment_id := wf_engine.GetItemAttrNumber
2290: (itemtype => itemtype,
2291: itemkey => itemkey,
2292: aname => 'ASSIGNMENT_ID');
2293:
2292: aname => 'ASSIGNMENT_ID');
2293:
2294: l_approver_loop_counter := l_approver_loop_counter + 1;
2295: IF l_approver_loop_counter > l_number_of_approvers THEN
2296: resultout := wf_engine.eng_completed||':'||'F';
2297: RETURN ;
2298: END IF;
2299: get_wf_performer (p_wf_type_code => 'ASSIGNMENT_APPROVAL'
2300: ,p_item_type => itemtype
2304: ,x_performer_name => l_approver_user_name
2305: ,x_performer_type => l_approver_type );
2306:
2307: IF l_approver_user_name IS NULL THEN
2308: resultout := wf_engine.eng_completed||':'||'F';
2309: RETURN ;
2310: END IF;
2311: -- In order to set the forwarded from, capture the current
2312: -- approver before modifying the same
2313: -- Set the current approver as the previous approver
2314: -- Handling a NULL previous approver (which is likely when
2315: -- the current approver is the first approver) is done
2316: -- in the Set forwarded from procedure
2317: l_prev_approver_user_name := wf_engine.GetItemAttrText
2318: ( itemtype => itemtype
2319: , itemkey => itemkey
2320: , aname => 'APPROVER_UNAME'
2321: );
2318: ( itemtype => itemtype
2319: , itemkey => itemkey
2320: , aname => 'APPROVER_UNAME'
2321: );
2322: wf_engine.SetItemAttrText
2323: ( itemtype => itemtype
2324: , itemkey => itemkey
2325: , aname => 'PREV_APPROVER_UNAME'
2326: , avalue => l_prev_approver_user_name
2324: , itemkey => itemkey
2325: , aname => 'PREV_APPROVER_UNAME'
2326: , avalue => l_prev_approver_user_name
2327: );
2328: wf_engine.SetItemAttrText
2329: ( itemtype => itemtype
2330: , itemkey => itemkey
2331: , aname => 'APPROVER_UNAME'
2332: , avalue => l_approver_user_name
2330: , itemkey => itemkey
2331: , aname => 'APPROVER_UNAME'
2332: , avalue => l_approver_user_name
2333: );
2334: wf_engine.SetItemAttrNumber
2335: ( itemtype => itemtype
2336: , itemkey => itemkey
2337: , aname => 'APPROVER_LOOP_COUNTER'
2338: , avalue => l_approver_loop_counter
2339: );
2340:
2341: /*Added the code for the bug 3595857*/
2342: IF l_approver_loop_counter = 1 THEN
2343: l_wf_startedby_uname := wf_engine.GetItemAttrText
2344: ( itemtype => itemtype
2345: , itemkey => itemkey
2346: , aname => 'WORKFLOW_STARTED_BY_UNAME'
2347: );
2345: , itemkey => itemkey
2346: , aname => 'WORKFLOW_STARTED_BY_UNAME'
2347: );
2348:
2349: wf_engine.SetItemAttrText
2350: ( itemtype => itemtype
2351: , itemkey => itemkey
2352: , aname => 'FROM_ROLE_VALUE'
2353: , avalue => l_wf_startedby_uname
2352: , aname => 'FROM_ROLE_VALUE'
2353: , avalue => l_wf_startedby_uname
2354: );
2355: ELSE
2356: wf_engine.SetItemAttrText
2357: ( itemtype => itemtype
2358: , itemkey => itemkey
2359: , aname => 'FROM_ROLE_VALUE'
2360: , avalue => l_prev_approver_user_name
2370: (DECODE(user_name,l_approver_user_name,'Y','N'))
2371: WHERE item_type = itemtype
2372: AND item_key = itemkey
2373: AND object_id1 = l_assignment_id;
2374: resultout := wf_engine.eng_completed||':'||'S';
2375: pa_debug.reset_err_stack;
2376: EXCEPTION
2377: WHEN OTHERS THEN
2378: WF_CORE.CONTEXT
2417: -- appropriate client extensions will be called
2418:
2419: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_apprvl_nf_recipients');
2420: -- Return if WF Not Running
2421: IF (funcmode <> wf_engine.eng_run) THEN
2422: resultout := wf_engine.eng_null;
2423: RETURN;
2424: END IF;
2425: l_assignment_id := wf_engine.GetItemAttrNumber
2418:
2419: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_apprvl_nf_recipients');
2420: -- Return if WF Not Running
2421: IF (funcmode <> wf_engine.eng_run) THEN
2422: resultout := wf_engine.eng_null;
2423: RETURN;
2424: END IF;
2425: l_assignment_id := wf_engine.GetItemAttrNumber
2426: (itemtype => itemtype,
2421: IF (funcmode <> wf_engine.eng_run) THEN
2422: resultout := wf_engine.eng_null;
2423: RETURN;
2424: END IF;
2425: l_assignment_id := wf_engine.GetItemAttrNumber
2426: (itemtype => itemtype,
2427: itemkey => itemkey,
2428: aname => 'ASSIGNMENT_ID');
2429: l_project_id := wf_engine.GetItemAttrNumber
2425: l_assignment_id := wf_engine.GetItemAttrNumber
2426: (itemtype => itemtype,
2427: itemkey => itemkey,
2428: aname => 'ASSIGNMENT_ID');
2429: l_project_id := wf_engine.GetItemAttrNumber
2430: (itemtype => itemtype,
2431: itemkey => itemkey,
2432: aname => 'PROJECT_ID' );
2433: -- Now populate the PL/SQL table with the 4 recipients
2431: itemkey => itemkey,
2432: aname => 'PROJECT_ID' );
2433: -- Now populate the PL/SQL table with the 4 recipients
2434: -- which are done by the product by default
2435: l_number_of_apprvl_nf_rects := wf_engine.GetItemAttrNumber
2436: ( itemtype => itemtype
2437: , itemkey => itemkey
2438: , aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
2439: );
2437: , itemkey => itemkey
2438: , aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
2439: );
2440:
2441: l_apprvl_item_type := wf_engine.getItemAttrText
2442: ( itemtype => itemtype
2443: , itemkey => itemkey
2444: , aname => 'APPRVL_ITEM_TYPE' );
2445:
2442: ( itemtype => itemtype
2443: , itemkey => itemkey
2444: , aname => 'APPRVL_ITEM_TYPE' );
2445:
2446: l_apprvl_item_key := wf_engine.getItemAttrText
2447: ( itemtype => itemtype
2448: , itemkey => itemkey
2449: , aname => 'APPRVL_ITEM_KEY');
2450:
2450:
2451: FOR i IN 1..l_number_of_apprvl_nf_rects LOOP
2452: l_ntfy_rect_item_attr_name :=
2453: 'APPROVAL_NF_REC'||i||'_USER_NAME';
2454: l_ntfy_apprvl_recipient_name := wf_engine.getItemAttrText
2455: ( itemtype => itemtype
2456: , itemkey => itemkey
2457: , aname => l_ntfy_rect_item_attr_name
2458: );
2457: , aname => l_ntfy_rect_item_attr_name
2458: );
2459: l_ntfy_rect_item_attr_name :=
2460: 'APPROVAL_NF_REC'||i||'_USER_TYPE';
2461: l_ntfy_apprvl_rect_type := wf_engine.getItemAttrText
2462: ( itemtype => itemtype
2463: , itemkey => itemkey
2464: , aname => l_ntfy_rect_item_attr_name
2465: );
2464: , aname => l_ntfy_rect_item_attr_name
2465: );
2466: l_ntfy_rect_item_attr_name :=
2467: 'APPROVAL_NF_REC'||i||'_PERSON_ID';
2468: l_ntfy_apprvl_rect_person_id := wf_engine.getItemAttrNumber
2469: ( itemtype => itemtype
2470: , itemkey => itemkey
2471: , aname => l_ntfy_rect_item_attr_name
2472: );
2502:
2503: -- Now set the number of approvl nf recipients based
2504: -- on how many records were inserted
2505:
2506: wf_engine.SetItemAttrNumber
2507: (itemtype => itemtype
2508: ,itemkey => itemkey
2509: ,aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
2510: ,avalue => l_number_of_recipients
2560: Set loop counter
2561: Resultout = 'T'
2562: */
2563: -- Return if WF Not Running
2564: IF (funcmode <> wf_engine.eng_run) THEN
2565: resultout := wf_engine.eng_null;
2566: RETURN;
2567: END IF;
2568: l_number_of_apprvl_nf_rects := wf_engine.GetItemAttrNumber
2561: Resultout = 'T'
2562: */
2563: -- Return if WF Not Running
2564: IF (funcmode <> wf_engine.eng_run) THEN
2565: resultout := wf_engine.eng_null;
2566: RETURN;
2567: END IF;
2568: l_number_of_apprvl_nf_rects := wf_engine.GetItemAttrNumber
2569: ( itemtype => itemtype
2564: IF (funcmode <> wf_engine.eng_run) THEN
2565: resultout := wf_engine.eng_null;
2566: RETURN;
2567: END IF;
2568: l_number_of_apprvl_nf_rects := wf_engine.GetItemAttrNumber
2569: ( itemtype => itemtype
2570: , itemkey => itemkey
2571: , aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
2572: );
2569: ( itemtype => itemtype
2570: , itemkey => itemkey
2571: , aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
2572: );
2573: l_approval_nf_loop_counter := wf_engine.getItemAttrNumber
2574: ( itemtype => itemtype
2575: , itemkey => itemkey
2576: , aname => 'APPROVAL_NF_LOOP_COUNTER'
2577: );
2574: ( itemtype => itemtype
2575: , itemkey => itemkey
2576: , aname => 'APPROVAL_NF_LOOP_COUNTER'
2577: );
2578: l_assignment_id := wf_engine.getItemAttrNumber
2579: ( itemtype => itemtype
2580: , itemkey => itemkey
2581: , aname => 'ASSIGNMENT_ID'
2582: );
2581: , aname => 'ASSIGNMENT_ID'
2582: );
2583: l_approval_nf_loop_counter := l_approval_nf_loop_counter + 1;
2584: IF l_approval_nf_loop_counter > l_number_of_apprvl_nf_rects THEN
2585: resultout := wf_engine.eng_completed||':'||'F';
2586: RETURN;
2587: END IF;
2588: get_wf_performer (p_wf_type_code => 'APPROVAL_FYI'
2589: ,p_item_type => itemtype
2591: ,p_routing_order => l_approval_nf_loop_counter
2592: ,p_object_id1 => l_assignment_id
2593: ,x_performer_name =>l_ntfy_apprvl_recipient_name
2594: ,x_performer_type =>l_ntfy_apprvl_rect_type );
2595: wf_engine.SetItemAttrText
2596: ( itemtype => itemtype
2597: , itemkey => itemkey
2598: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
2599: , avalue => l_ntfy_apprvl_recipient_name
2597: , itemkey => itemkey
2598: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
2599: , avalue => l_ntfy_apprvl_recipient_name
2600: );
2601: wf_engine.SetItemAttrNumber
2602: ( itemtype => itemtype
2603: , itemkey => itemkey
2604: , aname => 'APPROVAL_NF_LOOP_COUNTER'
2605: , avalue => l_approval_nf_loop_counter
2612: p_item_key => itemkey ,
2613: p_rect_type =>
2614: l_ntfy_apprvl_rect_type );
2615:
2616: resultout := wf_engine.eng_completed||':'||'S';
2617: EXCEPTION
2618: WHEN OTHERS THEN
2619: WF_CORE.CONTEXT
2620: ('PA_ASGMT_WFSTD',
2652: l_apprvl_item_key VARCHAR2(30);
2653:
2654: BEGIN
2655: -- Return if WF Not Running
2656: IF (funcmode <> wf_engine.eng_run) THEN
2657: resultout := wf_engine.eng_null;
2658: RETURN;
2659: END IF;
2660: l_assignment_id := wf_engine.GetItemAttrNumber
2653:
2654: BEGIN
2655: -- Return if WF Not Running
2656: IF (funcmode <> wf_engine.eng_run) THEN
2657: resultout := wf_engine.eng_null;
2658: RETURN;
2659: END IF;
2660: l_assignment_id := wf_engine.GetItemAttrNumber
2661: (itemtype => itemtype,
2656: IF (funcmode <> wf_engine.eng_run) THEN
2657: resultout := wf_engine.eng_null;
2658: RETURN;
2659: END IF;
2660: l_assignment_id := wf_engine.GetItemAttrNumber
2661: (itemtype => itemtype,
2662: itemkey => itemkey,
2663: aname => 'ASSIGNMENT_ID');
2664: l_project_id := wf_engine.GetItemAttrNumber
2660: l_assignment_id := wf_engine.GetItemAttrNumber
2661: (itemtype => itemtype,
2662: itemkey => itemkey,
2663: aname => 'ASSIGNMENT_ID');
2664: l_project_id := wf_engine.GetItemAttrNumber
2665: (itemtype => itemtype,
2666: itemkey => itemkey,
2667: aname => 'PROJECT_ID' );
2668: -- Now populate the PL/SQL table with the 4 recipients
2666: itemkey => itemkey,
2667: aname => 'PROJECT_ID' );
2668: -- Now populate the PL/SQL table with the 4 recipients
2669: -- which are done by the product by default
2670: l_number_of_reject_nf_rects := wf_engine.GetItemAttrNumber
2671: ( itemtype => itemtype
2672: , itemkey => itemkey
2673: , aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
2674: );
2672: , itemkey => itemkey
2673: , aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
2674: );
2675:
2676: l_apprvl_item_type := wf_engine.getItemAttrText
2677: ( itemtype => itemtype
2678: , itemkey => itemkey
2679: , aname => 'APPRVL_ITEM_TYPE' );
2680:
2677: ( itemtype => itemtype
2678: , itemkey => itemkey
2679: , aname => 'APPRVL_ITEM_TYPE' );
2680:
2681: l_apprvl_item_key := wf_engine.getItemAttrText
2682: ( itemtype => itemtype
2683: , itemkey => itemkey
2684: , aname => 'APPRVL_ITEM_KEY');
2685:
2686: FOR i IN 1..l_number_of_reject_nf_rects
2687: LOOP
2688: l_ntfy_rect_item_attr_name :=
2689: 'REJECT_NF_REC'||i||'_USER_NAME';
2690: l_ntfy_reject_recipient_name := wf_engine.getItemAttrText
2691: ( itemtype => itemtype
2692: , itemkey => itemkey
2693: , aname => l_ntfy_rect_item_attr_name
2694: );
2693: , aname => l_ntfy_rect_item_attr_name
2694: );
2695: l_ntfy_rect_item_attr_name :=
2696: 'REJECT_NF_REC'||i||'_USER_TYPE';
2697: l_ntfy_reject_rect_type := wf_engine.getItemAttrText
2698: ( itemtype => itemtype
2699: , itemkey => itemkey
2700: , aname => l_ntfy_rect_item_attr_name
2701: );
2700: , aname => l_ntfy_rect_item_attr_name
2701: );
2702: l_ntfy_rect_item_attr_name :=
2703: 'REJECT_NF_REC'||i||'_PERSON_ID';
2704: l_ntfy_reject_rect_person_id := wf_engine.getItemAttrNumber
2705: ( itemtype => itemtype
2706: , itemkey => itemkey
2707: , aname => l_ntfy_rect_item_attr_name
2708: );
2739:
2740: -- Now set the number of reject nf recipients based
2741: -- on how many records were inserted
2742:
2743: wf_engine.SetItemAttrNumber
2744: (itemtype => itemtype
2745: ,itemkey => itemkey
2746: ,aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
2747: ,avalue => l_number_of_recipients
2796: Set loop counter
2797: Resultout = 'T'
2798: */
2799: -- Return if WF Not Running
2800: IF (funcmode <> wf_engine.eng_run) THEN
2801: resultout := wf_engine.eng_null;
2802: RETURN;
2803: END IF;
2804: l_number_of_reject_nf_rects := wf_engine.GetItemAttrNumber
2797: Resultout = 'T'
2798: */
2799: -- Return if WF Not Running
2800: IF (funcmode <> wf_engine.eng_run) THEN
2801: resultout := wf_engine.eng_null;
2802: RETURN;
2803: END IF;
2804: l_number_of_reject_nf_rects := wf_engine.GetItemAttrNumber
2805: ( itemtype => itemtype
2800: IF (funcmode <> wf_engine.eng_run) THEN
2801: resultout := wf_engine.eng_null;
2802: RETURN;
2803: END IF;
2804: l_number_of_reject_nf_rects := wf_engine.GetItemAttrNumber
2805: ( itemtype => itemtype
2806: , itemkey => itemkey
2807: , aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
2808: );
2805: ( itemtype => itemtype
2806: , itemkey => itemkey
2807: , aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
2808: );
2809: l_rejection_nf_loop_counter := wf_engine.getItemAttrNumber
2810: ( itemtype => itemtype
2811: , itemkey => itemkey
2812: , aname => 'REJECTION_NF_LOOP_COUNTER'
2813: );
2811: , itemkey => itemkey
2812: , aname => 'REJECTION_NF_LOOP_COUNTER'
2813: );
2814:
2815: l_assignment_id := wf_engine.getItemAttrNumber
2816: ( itemtype => itemtype
2817: , itemkey => itemkey
2818: , aname => 'ASSIGNMENT_ID'
2819: );
2818: , aname => 'ASSIGNMENT_ID'
2819: );
2820: l_rejection_nf_loop_counter := l_rejection_nf_loop_counter + 1;
2821: IF l_rejection_nf_loop_counter > l_number_of_reject_nf_rects THEN
2822: resultout := wf_engine.eng_completed||':'||'F';
2823: RETURN;
2824: END IF;
2825: get_wf_performer (p_wf_type_code => 'REJECTION_FYI'
2826: ,p_item_type => itemtype
2828: ,p_routing_order => l_rejection_nf_loop_counter
2829: ,p_object_id1 => l_assignment_id
2830: ,x_performer_name =>l_ntfy_reject_recipient_name
2831: ,x_performer_type =>l_ntfy_reject_rect_type );
2832: wf_engine.SetItemAttrText
2833: ( itemtype => itemtype
2834: , itemkey => itemkey
2835: , aname => 'NTFY_REJECT_RECIPIENT_NAME'
2836: , avalue => l_ntfy_reject_recipient_name
2834: , itemkey => itemkey
2835: , aname => 'NTFY_REJECT_RECIPIENT_NAME'
2836: , avalue => l_ntfy_reject_recipient_name
2837: );
2838: wf_engine.SetItemAttrNumber
2839: ( itemtype => itemtype
2840: , itemkey => itemkey
2841: , aname => 'REJECTION_NF_LOOP_COUNTER'
2842: , avalue => l_rejection_nf_loop_counter
2848: Set_Comment_Attributes (p_item_type => itemtype,
2849: p_item_key => itemkey ,
2850: p_rect_type =>
2851: l_ntfy_reject_rect_type );
2852: resultout := wf_engine.eng_completed||':'||'S';
2853: EXCEPTION
2854: WHEN OTHERS THEN
2855: WF_CORE.CONTEXT
2856: ('PA_ASGMT_WFSTD',
2893: l_counter NUMBER := 0; -- local variable for bug 7511389
2894:
2895: BEGIN
2896: -- Return if WF Not Running
2897: IF (funcmode <> wf_engine.eng_run) THEN
2898: resultout := wf_engine.eng_null;
2899: RETURN;
2900: END IF;
2901: l_assignment_id := wf_engine.GetItemAttrNumber
2894:
2895: BEGIN
2896: -- Return if WF Not Running
2897: IF (funcmode <> wf_engine.eng_run) THEN
2898: resultout := wf_engine.eng_null;
2899: RETURN;
2900: END IF;
2901: l_assignment_id := wf_engine.GetItemAttrNumber
2902: (itemtype => itemtype,
2897: IF (funcmode <> wf_engine.eng_run) THEN
2898: resultout := wf_engine.eng_null;
2899: RETURN;
2900: END IF;
2901: l_assignment_id := wf_engine.GetItemAttrNumber
2902: (itemtype => itemtype,
2903: itemkey => itemkey,
2904: aname => 'ASSIGNMENT_ID');
2905: l_project_id := wf_engine.GetItemAttrNumber
2901: l_assignment_id := wf_engine.GetItemAttrNumber
2902: (itemtype => itemtype,
2903: itemkey => itemkey,
2904: aname => 'ASSIGNMENT_ID');
2905: l_project_id := wf_engine.GetItemAttrNumber
2906: (itemtype => itemtype,
2907: itemkey => itemkey,
2908: aname => 'PROJECT_ID' );
2909: -- Now populate the PL/SQL table with the 4 recipients
2907: itemkey => itemkey,
2908: aname => 'PROJECT_ID' );
2909: -- Now populate the PL/SQL table with the 4 recipients
2910: -- which are done by the product by default
2911: l_number_of_cancel_nf_rects := wf_engine.GetItemAttrNumber
2912: ( itemtype => itemtype
2913: , itemkey => itemkey
2914: , aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
2915: );
2913: , itemkey => itemkey
2914: , aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
2915: );
2916:
2917: l_apprvl_item_type := wf_engine.getItemAttrText
2918: ( itemtype => itemtype
2919: , itemkey => itemkey
2920: , aname => 'APPRVL_ITEM_TYPE' );
2921:
2918: ( itemtype => itemtype
2919: , itemkey => itemkey
2920: , aname => 'APPRVL_ITEM_TYPE' );
2921:
2922: l_apprvl_item_key := wf_engine.getItemAttrText
2923: ( itemtype => itemtype
2924: , itemkey => itemkey
2925: , aname => 'APPRVL_ITEM_KEY');
2926:
2927: FOR i IN 1..l_number_of_cancel_nf_rects
2928: LOOP
2929: l_ntfy_rect_item_attr_name :=
2930: 'CANCEL_NF_REC'||i||'_USER_NAME';
2931: l_ntfy_cancel_recipient_name := wf_engine.getItemAttrText
2932: ( itemtype => itemtype
2933: , itemkey => itemkey
2934: , aname => l_ntfy_rect_item_attr_name
2935: );
2934: , aname => l_ntfy_rect_item_attr_name
2935: );
2936: l_ntfy_rect_item_attr_name :=
2937: 'CANCEL_NF_REC'||i||'_USER_TYPE';
2938: l_ntfy_cancel_rect_type := wf_engine.getItemAttrText
2939: ( itemtype => itemtype
2940: , itemkey => itemkey
2941: , aname => l_ntfy_rect_item_attr_name
2942: );
2941: , aname => l_ntfy_rect_item_attr_name
2942: );
2943: l_ntfy_rect_item_attr_name :=
2944: 'CANCEL_NF_REC'||i||'_PERSON_ID';
2945: l_ntfy_cancel_rect_person_id := wf_engine.getItemAttrNumber
2946: ( itemtype => itemtype
2947: , itemkey => itemkey
2948: , aname => l_ntfy_rect_item_attr_name
2949: );
2988:
2989: -- Now set the number of cancel nf recipients based
2990: -- on how many records were inserted
2991:
2992: wf_engine.SetItemAttrNumber
2993: (itemtype => itemtype
2994: ,itemkey => itemkey
2995: ,aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
2996: ,avalue => l_number_of_recipients
3046: Set loop counter
3047: Resultout = 'T'
3048: */
3049: -- Return if WF Not Running
3050: IF (funcmode <> wf_engine.eng_run) THEN
3051: resultout := wf_engine.eng_null;
3052: RETURN;
3053: END IF;
3054: l_number_of_cancel_nf_rects := wf_engine.GetItemAttrNumber
3047: Resultout = 'T'
3048: */
3049: -- Return if WF Not Running
3050: IF (funcmode <> wf_engine.eng_run) THEN
3051: resultout := wf_engine.eng_null;
3052: RETURN;
3053: END IF;
3054: l_number_of_cancel_nf_rects := wf_engine.GetItemAttrNumber
3055: ( itemtype => itemtype
3050: IF (funcmode <> wf_engine.eng_run) THEN
3051: resultout := wf_engine.eng_null;
3052: RETURN;
3053: END IF;
3054: l_number_of_cancel_nf_rects := wf_engine.GetItemAttrNumber
3055: ( itemtype => itemtype
3056: , itemkey => itemkey
3057: , aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
3058: );
3055: ( itemtype => itemtype
3056: , itemkey => itemkey
3057: , aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
3058: );
3059: l_cancellation_nf_loop_counter := wf_engine.getItemAttrNumber
3060: ( itemtype => itemtype
3061: , itemkey => itemkey
3062: , aname => 'CANCELLATION_NF_LOOP_COUNTER'
3063: );
3061: , itemkey => itemkey
3062: , aname => 'CANCELLATION_NF_LOOP_COUNTER'
3063: );
3064:
3065: l_assignment_id := wf_engine.getItemAttrNumber
3066: ( itemtype => itemtype
3067: , itemkey => itemkey
3068: , aname => 'ASSIGNMENT_ID'
3069: );
3068: , aname => 'ASSIGNMENT_ID'
3069: );
3070: l_cancellation_nf_loop_counter := l_cancellation_nf_loop_counter + 1;
3071: IF l_cancellation_nf_loop_counter > l_number_of_cancel_nf_rects THEN
3072: resultout := wf_engine.eng_completed||':'||'F';
3073: RETURN;
3074: END IF;
3075: get_wf_performer (p_wf_type_code => 'CANCELLATION_FYI'
3076: ,p_item_type => itemtype
3078: ,p_routing_order => l_cancellation_nf_loop_counter
3079: ,p_object_id1 => l_assignment_id
3080: ,x_performer_name =>l_ntfy_cancel_recipient_name
3081: ,x_performer_type =>l_ntfy_cancel_rect_type );
3082: wf_engine.SetItemAttrText
3083: ( itemtype => itemtype
3084: , itemkey => itemkey
3085: , aname => 'NTFY_CANCEL_RECIPIENT_NAME'
3086: , avalue => l_ntfy_cancel_recipient_name
3084: , itemkey => itemkey
3085: , aname => 'NTFY_CANCEL_RECIPIENT_NAME'
3086: , avalue => l_ntfy_cancel_recipient_name
3087: );
3088: wf_engine.SetItemAttrNumber
3089: ( itemtype => itemtype
3090: , itemkey => itemkey
3091: , aname => 'CANCELLATION_NF_LOOP_COUNTER'
3092: , avalue => l_cancellation_nf_loop_counter
3098: Set_Comment_Attributes (p_item_type => itemtype,
3099: p_item_key => itemkey ,
3100: p_rect_type =>
3101: l_ntfy_cancel_rect_type );
3102: resultout := wf_engine.eng_completed||':'||'S';
3103: EXCEPTION
3104: WHEN OTHERS THEN
3105: WF_CORE.CONTEXT
3106: ('PA_ASGMT_WFSTD',
3122: l_forwarded_from wf_users.name%type; ----- VARCHAR2(240); Changed for bug 3267790
3123: BEGIN
3124:
3125: -- Return if WF Not Running
3126: IF (funcmode <> wf_engine.eng_run) THEN
3127: resultout := wf_engine.eng_null;
3128: RETURN;
3129: END IF;
3130: -- The approval notification would have been forwarded
3123: BEGIN
3124:
3125: -- Return if WF Not Running
3126: IF (funcmode <> wf_engine.eng_run) THEN
3127: resultout := wf_engine.eng_null;
3128: RETURN;
3129: END IF;
3130: -- The approval notification would have been forwarded
3131: -- from either the initial submittor or the last approver
3132: -- Prev Approver uname is set only in get approver node
3133: -- Hence, if that value is not set, get the value
3134: -- from workflow started by uname attribute, which
3135: -- is always set at the time of starting the workflow
3136: l_forwarded_from := wf_engine.GetItemAttrText
3137: ( itemtype => itemtype
3138: , itemkey => itemkey
3139: , aname => 'PREV_APPROVER_UNAME'
3140: );
3138: , itemkey => itemkey
3139: , aname => 'PREV_APPROVER_UNAME'
3140: );
3141: IF l_forwarded_from IS NULL THEN
3142: l_forwarded_from := wf_engine.GetItemAttrText
3143: ( itemtype => itemtype
3144: , itemkey => itemkey
3145: , aname => 'WORKFLOW_STARTED_BY_UNAME'
3146: );
3145: , aname => 'WORKFLOW_STARTED_BY_UNAME'
3146: );
3147: END IF;
3148: -- Now set the forwarded from field
3149: wf_engine.SetItemAttrText
3150: ( itemtype => itemtype
3151: , itemkey => itemkey
3152: , aname => 'FORWARDED_FROM'
3153: , avalue => l_forwarded_from
3172: IS
3173: l_assignment_type pa_project_assignments.assignment_type%TYPE;
3174: l_reapproval_flag VARCHAR2(1);
3175: BEGIN
3176: IF (funcmode <> wf_engine.eng_run) THEN
3177: resultout := wf_engine.eng_null;
3178: RETURN;
3179: END IF;
3180: -- Check whether the assignment is work or admin assignment
3173: l_assignment_type pa_project_assignments.assignment_type%TYPE;
3174: l_reapproval_flag VARCHAR2(1);
3175: BEGIN
3176: IF (funcmode <> wf_engine.eng_run) THEN
3177: resultout := wf_engine.eng_null;
3178: RETURN;
3179: END IF;
3180: -- Check whether the assignment is work or admin assignment
3181: -- If work assignment check whether this is a reapproval
3181: -- If work assignment check whether this is a reapproval
3182: -- Accordingly set the attributes for MSG_SUBJECT and MSG_DESCRIPTION
3183: -- All this is done in the Set_NF_Subject_and_Desc procedure
3184:
3185: l_assignment_type := wf_engine.GetItemAttrText
3186: (itemtype => itemtype,
3187: itemkey => itemkey,
3188: aname => 'ASSIGNMENT_TYPE');
3189:
3186: (itemtype => itemtype,
3187: itemkey => itemkey,
3188: aname => 'ASSIGNMENT_TYPE');
3189:
3190: l_reapproval_flag := wf_engine.GetItemAttrText
3191: (itemtype => itemtype,
3192: itemkey => itemkey,
3193: aname => 'REAPPROVAL_FLAG');
3194:
3219: , funcmode IN VARCHAR2
3220: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3221: IS
3222: BEGIN
3223: IF (funcmode <> wf_engine.eng_run) THEN
3224: resultout := wf_engine.eng_null;
3225: RETURN;
3226: END IF;
3227:
3220: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3221: IS
3222: BEGIN
3223: IF (funcmode <> wf_engine.eng_run) THEN
3224: resultout := wf_engine.eng_null;
3225: RETURN;
3226: END IF;
3227:
3228: -- Set the appropriate notification subject and description
3255: ,resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3256:
3257: IS
3258: BEGIN
3259: IF (funcmode <> wf_engine.eng_run) THEN
3260: resultout := wf_engine.eng_null;
3261: RETURN;
3262: END IF;
3263:
3256:
3257: IS
3258: BEGIN
3259: IF (funcmode <> wf_engine.eng_run) THEN
3260: resultout := wf_engine.eng_null;
3261: RETURN;
3262: END IF;
3263:
3264: -- Set the appropriate notification subject and description
3291: ,resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3292:
3293: IS
3294: BEGIN
3295: IF (funcmode <> wf_engine.eng_run) THEN
3296: resultout := wf_engine.eng_null;
3297: RETURN;
3298: END IF;
3299:
3292:
3293: IS
3294: BEGIN
3295: IF (funcmode <> wf_engine.eng_run) THEN
3296: resultout := wf_engine.eng_null;
3297: RETURN;
3298: END IF;
3299:
3300: -- Set the appropriate notification subject and description
3331: BEGIN
3332: /*
3333: IF funcmode = 'FORWARD' THEN
3334: Notification assignee validations go here
3335: get the assigned user which is available in wf_engine.context_text
3336: validate this user
3337: If not valid user fnd_message.set_name ('PA','PA_NO_RESOURCE_AUTHORITY');
3338: l_msg_text := fnd_message.get;
3339: RAISE invalid_user_exception;
3370: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
3371:
3372: l_assignment_id pa_project_assignments.assignment_id%TYPE;
3373: BEGIN
3374: l_assignment_id := wf_engine.GetItemAttrNumber
3375: (itemtype => itemtype,
3376: itemkey => itemkey,
3377: aname => 'ASSIGNMENT_ID');
3378: Maintain_wf_pending_flag
3486: ELSE
3487: -------------------------------------------------------------------
3488: -- Resolve Overcommitment conflict for Approve
3489: -------------------------------------------------------------------
3490: l_conflict_group_id := wf_engine.GetItemAttrNumber
3491: (itemtype => p_item_type,
3492: itemkey => p_item_key,
3493: aname => 'CONFLICT_GROUP_ID');
3494:
3491: (itemtype => p_item_type,
3492: itemkey => p_item_key,
3493: aname => 'CONFLICT_GROUP_ID');
3494:
3495: l_submitter_uname := wf_engine.GetItemAttrText
3496: ( itemtype => p_item_type
3497: , itemkey => p_item_key
3498: , aname => 'WORKFLOW_STARTED_BY_UNAME');
3499:
3525: (p_assignment_id => p_assignment_id,
3526: p_mode => 'APPROVAL_PROCESS_COMPLETED');
3527:
3528: -- Set the attribute NEW_ASGMT_STATUS_CODE
3529: wf_engine.SetItemAttrText
3530: ( itemtype => p_item_type
3531: , itemkey => p_item_key
3532: , aname => 'NEW_ASGMT_STATUS_CODE'
3533: , avalue => l_apprvl_status_code);
3551: , actid IN NUMBER
3552: , funcmode IN VARCHAR2
3553: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3554: IS
3555: l_comment VARCHAR2(4000); --VARCHAR2(2000); Bug 7459451 : Changed the length to accomodate max length returned by wf_engine.getItemAttrText
3556: l_approver_user_name wf_users.name%type; ----- VARCHAR2(240);Changed for bug 3267790
3557: /* Modified length from 30 to 100 for bug 3148857 */
3558: l_assignment_id NUMBER;
3559: l_wf_context_user pa_wf_ntf_performers.user_name%TYPE;
3578: AND item_key = itemkey
3579: AND current_approver_flag = 'Y';
3580:
3581: BEGIN
3582: l_comment := wf_engine.GetItemAttrText
3583: ( itemtype => itemtype
3584: , itemkey => itemkey
3585: , aname => 'APPROVER_RESPONSE'
3586: );
3584: , itemkey => itemkey
3585: , aname => 'APPROVER_RESPONSE'
3586: );
3587: IF l_comment IS NOT NULL THEN
3588: l_approver_user_name := wf_engine.GetItemAttrText
3589: ( itemtype => itemtype
3590: , itemkey => itemkey
3591: , aname => 'APPROVER_UNAME'
3592: );
3589: ( itemtype => itemtype
3590: , itemkey => itemkey
3591: , aname => 'APPROVER_UNAME'
3592: );
3593: l_assignment_id := wf_engine.GetItemAttrNumber
3594: ( itemtype => itemtype
3595: , itemkey => itemkey
3596: , aname => 'ASSIGNMENT_ID'
3597: );
3602: AND object_id1 = l_assignment_id
3603: AND user_name = l_approver_user_Name;
3604: -- Now reset the approver response attribute
3605: -- so that the next approver can add his/her comments
3606: wf_engine.SetItemAttrText
3607: ( itemtype => itemtype
3608: , itemkey => itemkey
3609: , aname => 'APPROVER_RESPONSE'
3610: , avalue => NULL
3616: -- set current_approver_flag to 'Y'. If reassignee is already in the table, then just set flag to 'Y'
3617: --2) Set the Forwarded_From attribute for display
3618: IF funcmode IN ('TRANSFER', 'FORWARD') THEN
3619:
3620: l_wf_context_user := WF_ENGINE.context_text;
3621:
3622: --Check to see if the reassignee already in the table
3623: OPEN get_reassignee;
3624: FETCH get_reassignee INTO l_reassignee_user_name;
3657: --
3658:
3659: --set the previous_approver attribute correctly
3660: l_prev_approver_user_name :=
3661: wf_engine.GetItemAttrText
3662: ( itemtype => itemtype
3663: , itemkey => itemkey
3664: , aname => 'APPROVER_UNAME');
3665: wf_engine.SetItemAttrText
3661: wf_engine.GetItemAttrText
3662: ( itemtype => itemtype
3663: , itemkey => itemkey
3664: , aname => 'APPROVER_UNAME');
3665: wf_engine.SetItemAttrText
3666: ( itemtype => itemtype
3667: , itemkey => itemkey
3668: , aname => 'PREV_APPROVER_UNAME'
3669: , avalue => l_prev_approver_user_name
3669: , avalue => l_prev_approver_user_name
3670: );
3671:
3672: --set current_approver to be the reassignee
3673: wf_engine.SetItemAttrText
3674: ( itemtype => itemtype
3675: , itemkey => itemkey
3676: , aname => 'APPROVER_UNAME'
3677: , avalue => l_wf_context_user
3685: , funcmode => funcmode
3686: , resultout => resultout);
3687:
3688: --set notification attribute forwarded_from to let the change show up
3689: WF_NOTIFICATION.SetAttrText (nid => WF_ENGINE.context_nid
3690: ,aname => 'FORWARDED_FROM'
3691: ,avalue => l_prev_approver_user_name);
3692:
3693: /*
3714: p_item_key IN VARCHAR2)
3715: IS
3716: BEGIN
3717: g_approver_response :=
3718: wf_engine.GetItemAttrText
3719: ( itemtype => p_item_type
3720: , itemkey => p_item_key
3721: , aname => 'APPROVER_RESPONSE'
3722: );
3737: -- Since populate_approval_NF_comments is being called from the
3738: -- approval process, pass the same item type and item key values
3739: -- for both p_apprvl and p_item parameters
3740:
3741: l_assignment_id := wf_engine.GetItemAttrNumber
3742: (itemtype => itemtype,
3743: itemkey => itemkey,
3744: aname => 'ASSIGNMENT_ID');
3745:
3805: CLOSE l_nf_csr;
3806: END IF;
3807: -- document := '';
3808: document_type := 'text/html';
3809: l_msg_data := wf_engine.GetItemAttrText
3810: ( itemtype => l_item_type
3811: , itemkey => l_item_key
3812: , aname => 'L_MSG_DATA'
3813: );
3856: IF p_msg_count = 1 THEN
3857: IF p_msg_data IS NOT NULL THEN
3858: FND_MESSAGE.SET_ENCODED (p_msg_data);
3859: l_data := FND_MESSAGE.GET;
3860: wf_engine.SetItemAttrText
3861: ( itemtype => p_item_type
3862: , itemkey => p_item_key
3863: , aname => 'ERROR_MSG1'
3864: , avalue => l_data
3880: p_msg_data => p_msg_data ,
3881: p_data => l_data,
3882: p_msg_index_out => l_msg_index_out );
3883: l_item_attr_name := 'ERROR_MSG'||i;
3884: wf_engine.SetItemAttrText
3885: ( itemtype => p_item_type
3886: , itemkey => p_item_key
3887: , aname => l_item_attr_name
3888: , avalue => l_data
4018:
4019: IF p_wf_type_code like '%FYI' THEN
4020:
4021: --Get the Name of the User logged In.
4022: l_user_name := wf_engine.GetItemAttrText
4023: ( itemtype => p_item_type
4024: , itemkey => p_item_key
4025: , aname => 'WORKFLOW_STARTED_BY_UNAME');
4026: /* IF x_performer_name = l_user_name THEN
4075: -- Now set the appropriate comments attributes for this WF
4076: -- Populate the internal comments only . displayed comments
4077: -- will be done by the get_recipients nodes
4078: l_item_attr_name := 'INTERNAL_APPROVER_COMMENTS_'||l_counter ;
4079: wf_engine.SetItemAttrText
4080: ( itemtype => p_item_type
4081: , itemkey => p_item_key
4082: , aname => l_item_attr_name
4083: , avalue =>
4096: PROCEDURE Set_Comment_Attributes (p_item_type IN VARCHAR2,
4097: p_item_key IN VARCHAR2,
4098: p_rect_type IN VARCHAR2 ) IS
4099: l_comments_item_attr_name VARCHAR2(30);
4100: l_comments VARCHAR2(4000); -- VARCHAR2(255); Bug 7459451 : Changed the length to accomodate max length returned by wf_engine.getItemAttrText
4101: BEGIN
4102: -- Set displayed comments to NULL if the recipient is resource
4103: -- otherwise set the displayed comments to the internal comments
4104: FOR i IN 1..5 LOOP
4102: -- Set displayed comments to NULL if the recipient is resource
4103: -- otherwise set the displayed comments to the internal comments
4104: FOR i IN 1..5 LOOP
4105: l_comments_item_attr_name := 'INTERNAL_APPROVER_COMMENTS_'||i;
4106: l_comments := wf_engine.getItemAttrText
4107: ( itemtype => p_item_type
4108: , itemkey => p_item_key
4109: , aname => l_comments_item_attr_name
4110: );
4110: );
4111: IF p_rect_type = 'RESOURCE' THEN
4112: l_comments := NULL;
4113: END IF;
4114: wf_engine.SetItemAttrText
4115: ( itemtype => p_item_type
4116: , itemkey => p_item_key
4117: , aname => 'APPROVER_COMMENTS_'||i
4118: , avalue => l_comments
4239: END IF;
4240: END IF;
4241:
4242: ELSIF p_msg_type = 'APPROVAL_FYI' THEN
4243: l_assignment_id := wf_engine.GetItemAttrNumber
4244: (itemtype => p_item_type,
4245: itemkey => p_item_key,
4246: aname => 'ASSIGNMENT_ID');
4247: l_conflict_group_id := wf_engine.GetItemAttrNumber
4243: l_assignment_id := wf_engine.GetItemAttrNumber
4244: (itemtype => p_item_type,
4245: itemkey => p_item_key,
4246: aname => 'ASSIGNMENT_ID');
4247: l_conflict_group_id := wf_engine.GetItemAttrNumber
4248: (itemtype => p_item_type,
4249: itemkey => p_item_key,
4250: aname => 'CONFLICT_GROUP_ID');
4251:
4255: l_msg_desc_code := 'PA_NFDESC_ASGMT_APPROVED';
4256:
4257: -- set 'Number of Assignments Resulting in Resource Overcommitment -1/0' for single
4258: -- approval FYI notification.
4259: wf_engine.SetItemAttrNumber
4260: ( itemtype => p_item_type
4261: , itemkey => p_item_key
4262: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
4263: , avalue => 0 );
4279: END IF;
4280:
4281: -- set 'Number of Assignments Resulting in Resource Overcommitment -1/0' for single
4282: -- approval FYI notification.
4283: wf_engine.SetItemAttrNumber
4284: ( itemtype => p_item_type
4285: , itemkey => p_item_key
4286: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
4287: , avalue => 1 );
4292: || 'PA_RES_OVERCOMMITMENT_LAYOUT&paAssignmentId=' || l_assignment_id
4293: || '&paConflictGroupId=' || l_conflict_group_id
4294: || '&paCallingPage=Default&addBreadCrumb=RP';
4295:
4296: wf_engine.SetItemAttrText
4297: ( itemtype => p_item_type
4298: , itemkey => p_item_key
4299: , aname => 'VIEW_CONFLICT_URL_INFO'
4300: , avalue => l_view_conflict_url );
4300: , avalue => l_view_conflict_url );
4301: ELSIF p_msg_type = 'REJECTION_FYI' OR p_msg_type = 'CANCELLATION_FYI' THEN
4302: -- set 'Number of Assignments Resulting in Resource Overcommitment -0' for single
4303: -- reject/cancel FYI notification.
4304: wf_engine.SetItemAttrNumber
4305: ( itemtype => p_item_type
4306: , itemkey => p_item_key
4307: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
4308: , avalue => 0 );
4306: , itemkey => p_item_key
4307: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
4308: , avalue => 0 );
4309:
4310: l_assignment_id := wf_engine.GetItemAttrNumber
4311: (itemtype => p_item_type,
4312: itemkey => p_item_key,
4313: aname => 'ASSIGNMENT_ID');
4314: -- set resource overcommitment url
4315: l_view_conflict_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275&akRegionCode='
4316: || 'PA_RES_OVERCOMMITMENT_LAYOUT&paAssignmentId=' || l_assignment_id
4317: || '&paConflictGroupId=&paCallingPage=Default&addBreadCrumb=RP';
4318:
4319: wf_engine.SetItemAttrText
4320: ( itemtype => p_item_type
4321: , itemkey => p_item_key
4322: , aname => 'VIEW_CONFLICT_URL_INFO'
4323: , avalue => l_view_conflict_url );
4342: l_msg_subj_text := FND_MESSAGE.GET;
4343: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
4344: l_msg_desc_text := FND_MESSAGE.GET;
4345:
4346: wf_engine.SetItemAttrText
4347: ( itemtype => p_item_type
4348: , itemkey => p_item_key
4349: , aname => l_msg_subj_itemattr_name
4350: , avalue => l_msg_subj_text
4348: , itemkey => p_item_key
4349: , aname => l_msg_subj_itemattr_name
4350: , avalue => l_msg_subj_text
4351: );
4352: wf_engine.SetItemAttrText
4353: ( itemtype => p_item_type
4354: , itemkey => p_item_key
4355: , aname => l_msg_desc_itemattr_name
4356: , avalue => l_msg_desc_text
4501: , resp_id => l_responsibility_id
4502: , resp_appl_id => l_resp_appl_id );
4503:
4504: -- Setting thresold value to run the process in background
4505: l_save_threshold := wf_engine.threshold;
4506: wf_engine.threshold := -1;
4507:
4508: -----------------------------------
4509: --Getting the current approver name
4502: , resp_appl_id => l_resp_appl_id );
4503:
4504: -- Setting thresold value to run the process in background
4505: l_save_threshold := wf_engine.threshold;
4506: wf_engine.threshold := -1;
4507:
4508: -----------------------------------
4509: --Getting the current approver name
4510: -----------------------------------
4574:
4575: log_message('l_mass_approve_url:' || l_mass_approve_url);
4576:
4577: -- Create the WF process
4578: wf_engine.CreateProcess
4579: ( ItemType => l_wf_item_type
4580: , ItemKey => l_itemkey
4581: , process => l_wf_process );
4582:
4585: ----------------------------------------------------------------
4586: --Set all the required workflow attributes and start the workflow
4587: -----------------------------------------------------------------
4588: --set group_id
4589: wf_engine.SetItemAttrNumber
4590: ( itemtype => l_wf_item_type
4591: , itemkey => l_itemkey
4592: , aname => 'GROUP_ID'
4593: , avalue => p_group_id);
4591: , itemkey => l_itemkey
4592: , aname => 'GROUP_ID'
4593: , avalue => p_group_id);
4594:
4595: wf_engine.SetItemAttrNumber
4596: ( itemtype => l_wf_item_type
4597: , itemkey => l_itemkey
4598: , aname => 'APPROVER_GROUP_ID'
4599: , avalue => p_approver_group_id);
4597: , itemkey => l_itemkey
4598: , aname => 'APPROVER_GROUP_ID'
4599: , avalue => p_approver_group_id);
4600:
4601: wf_engine.SetItemAttrNumber
4602: ( itemtype => l_wf_item_type
4603: , itemkey => l_itemkey
4604: , aname => 'ROUTING_ORDER'
4605: , avalue => p_routing_order);
4604: , aname => 'ROUTING_ORDER'
4605: , avalue => p_routing_order);
4606:
4607: --This is required for check_notiifcation_completed API logic
4608: wf_engine.SetItemAttrText
4609: ( itemtype => l_wf_item_type
4610: , itemkey => l_itemkey
4611: , aname => 'MODE'
4612: , avalue => p_mode);
4610: , itemkey => l_itemkey
4611: , aname => 'MODE'
4612: , avalue => p_mode);
4613:
4614: wf_engine.SetItemAttrText
4615: ( itemtype => l_wf_item_type
4616: , itemkey => l_itemkey
4617: , aname => 'SUBMITTER_UNAME'
4618: , avalue => p_submitter_user_name);
4616: , itemkey => l_itemkey
4617: , aname => 'SUBMITTER_UNAME'
4618: , avalue => p_submitter_user_name);
4619:
4620: wf_engine.SetItemAttrDocument
4621: ( itemtype => l_wf_item_type
4622: , itemkey => l_itemkey
4623: , aname => 'UPDATED_INFO_DOC'
4624: , documentid => p_update_info_doc );
4623: , aname => 'UPDATED_INFO_DOC'
4624: , documentid => p_update_info_doc );
4625:
4626: --Set approval type
4627: wf_engine.SetItemAttrText
4628: ( itemtype => l_wf_item_type
4629: , itemkey => l_itemkey
4630: , aname => 'APPROVAL_TYPE'
4631: , avalue => PA_ASGMT_WFSTD.G_MASS_APPROVAL );
4630: , aname => 'APPROVAL_TYPE'
4631: , avalue => PA_ASGMT_WFSTD.G_MASS_APPROVAL );
4632:
4633: --Setting Mass Assignments details
4634: wf_engine.SetItemAttrText
4635: ( itemtype => l_wf_item_type
4636: , itemkey => l_itemkey
4637: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
4638: , avalue => l_ntfy_apprvl_recipient_name );
4636: , itemkey => l_itemkey
4637: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
4638: , avalue => l_ntfy_apprvl_recipient_name );
4639:
4640: wf_engine.SetItemAttrText
4641: ( itemtype => l_wf_item_type
4642: , itemkey => l_itemkey
4643: , aname => 'FORWARDED_FROM'
4644: , avalue => l_prev_user );
4642: , itemkey => l_itemkey
4643: , aname => 'FORWARDED_FROM'
4644: , avalue => l_prev_user );
4645:
4646: wf_engine.SetItemAttrText
4647: ( itemtype => l_wf_item_type
4648: , itemkey => l_itemkey
4649: , aname => 'NOTE_TO_APPROVER'
4650: , avalue => p_note_to_approvers );
4648: , itemkey => l_itemkey
4649: , aname => 'NOTE_TO_APPROVER'
4650: , avalue => p_note_to_approvers );
4651:
4652: wf_engine.SetItemAttrText
4653: ( itemtype => l_wf_item_type
4654: , itemkey => l_itemkey
4655: , aname => 'NUMBER_OF_ASSIGNMENTS'
4656: , avalue => l_number_of_assignments );
4654: , itemkey => l_itemkey
4655: , aname => 'NUMBER_OF_ASSIGNMENTS'
4656: , avalue => l_number_of_assignments );
4657:
4658: wf_engine.SetItemAttrText
4659: ( itemtype => l_wf_item_type
4660: , itemkey => l_itemkey
4661: , aname => 'MASS_APPROVE_URL_INFO'
4662: , avalue => l_mass_approve_url );
4661: , aname => 'MASS_APPROVE_URL_INFO'
4662: , avalue => l_mass_approve_url );
4663:
4664: --Setting the Upadate info document
4665: wf_engine.SetItemAttrDocument
4666: ( itemtype => l_wf_item_type
4667: , itemkey => l_itemkey
4668: , aname => 'UPDATED_INFO_DOC'
4669: , documentid => p_update_info_doc );
4669: , documentid => p_update_info_doc );
4670:
4671: --Setting Project Details
4672: IF p_project_manager IS NOT NULL THEN
4673: wf_engine.SetItemAttrText
4674: ( itemtype => l_wf_item_type
4675: , itemkey => l_itemkey
4676: , aname => 'PROJECT_MANAGER_NAME'
4677: , avalue => p_project_manager );
4676: , aname => 'PROJECT_MANAGER_NAME'
4677: , avalue => p_project_manager );
4678: END IF;
4679:
4680: wf_engine.SetItemAttrNumber
4681: ( itemtype => l_wf_item_type
4682: , itemkey => l_itemkey
4683: , aname => 'PROJECT_ID'
4684: , avalue => p_project_id);
4682: , itemkey => l_itemkey
4683: , aname => 'PROJECT_ID'
4684: , avalue => p_project_id);
4685:
4686: wf_engine.SetItemAttrText
4687: ( itemtype => l_wf_item_type
4688: , itemkey => l_itemkey
4689: , aname => 'PROJECT_NUMBER'
4690: , avalue => p_project_number);
4688: , itemkey => l_itemkey
4689: , aname => 'PROJECT_NUMBER'
4690: , avalue => p_project_number);
4691:
4692: wf_engine.SetItemAttrText
4693: ( itemtype => l_wf_item_type
4694: , itemkey => l_itemkey
4695: , aname => 'PROJECT_NAME'
4696: , avalue => p_project_name);
4694: , itemkey => l_itemkey
4695: , aname => 'PROJECT_NAME'
4696: , avalue => p_project_name);
4697:
4698: wf_engine.SetItemAttrText
4699: ( itemtype => l_wf_item_type
4700: , itemkey => l_itemkey
4701: , aname => 'PROJECT_ORGANIZATION'
4702: , avalue => p_project_org);
4700: , itemkey => l_itemkey
4701: , aname => 'PROJECT_ORGANIZATION'
4702: , avalue => p_project_org);
4703:
4704: wf_engine.SetItemAttrText
4705: ( itemtype => l_wf_item_type
4706: , itemkey => l_itemkey
4707: , aname => 'FROM_ROLE_VALUE'
4708: , avalue => p_submitter_user_name); --Added for bug 4535838
4708: , avalue => p_submitter_user_name); --Added for bug 4535838
4709:
4710: -- Set the customer name if it is not null
4711: IF p_project_cus IS NOT NULL THEN
4712: wf_engine.SetItemAttrText
4713: ( itemtype => l_wf_item_type
4714: , itemkey => l_itemkey
4715: , aname => 'PROJECT_CUSTOMER'
4716: , avalue => p_project_cus);
4719: log_message('Starting process');
4720: -----------------------------
4721: --Start the workflow process
4722: -----------------------------
4723: wf_engine.StartProcess ( itemtype => l_wf_item_type
4724: ,itemkey => l_itemkey );
4725:
4726: PA_WORKFLOW_UTILS.Insert_WF_Processes
4727: (p_wf_type_code => 'MASS_ASSIGNMENT_APPROVAL'
4736:
4737: END IF; --l_num_of_assignments > 0
4738:
4739: --Setting the original value
4740: wf_engine.threshold := l_save_threshold;
4741:
4742: EXCEPTION
4743: WHEN OTHERS THEN
4744:
4742: EXCEPTION
4743: WHEN OTHERS THEN
4744:
4745: --Setting the original value
4746: wf_engine.threshold := l_save_threshold;
4747:
4748: -- Set the excetption Message and the stack
4749: FND_MSG_PUB.add_exc_msg
4750: ( p_pkg_name => 'PA_ASGMT_WFSTD.start_mass_Approval_flow'
5022: , resp_id => l_responsibility_id
5023: , resp_appl_id => l_resp_appl_id );
5024:
5025: -- Setting thresold value to run the process in background
5026: l_save_threshold := wf_engine.threshold;
5027: wf_engine.threshold := -1;
5028:
5029: log_message('RESOURCE PERSON ID:' || l_ntfy_apprvl_rect_person_id);
5030: log_message('RESOURCE UNAME:' || l_ntfy_apprvl_recipient_name);
5023: , resp_appl_id => l_resp_appl_id );
5024:
5025: -- Setting thresold value to run the process in background
5026: l_save_threshold := wf_engine.threshold;
5027: wf_engine.threshold := -1;
5028:
5029: log_message('RESOURCE PERSON ID:' || l_ntfy_apprvl_rect_person_id);
5030: log_message('RESOURCE UNAME:' || l_ntfy_apprvl_recipient_name);
5031:
5085: INTO l_itemkey
5086: FROM dual;
5087:
5088: -- Create the WF process
5089: wf_engine.CreateProcess
5090: ( ItemType => l_wf_item_type
5091: , ItemKey => l_itemkey
5092: , process => l_wf_process );
5093:
5140: ------------------------------------------------------------
5141: --Set the item attributes required for resource notification
5142: ------------------------------------------------------------
5143: -- setting subject, description, conflict URL for overcommitment
5144: wf_engine.SetItemAttrText
5145: ( itemtype => l_wf_item_type
5146: , itemkey => l_itemkey
5147: , aname => 'MSG_SUBJECT'
5148: , avalue => l_msg_subj_text);
5146: , itemkey => l_itemkey
5147: , aname => 'MSG_SUBJECT'
5148: , avalue => l_msg_subj_text);
5149:
5150: wf_engine.SetItemAttrText
5151: ( itemtype => l_wf_item_type
5152: , itemkey => l_itemkey
5153: , aname => 'MSG_DESCRIPTION'
5154: , avalue => l_msg_desc_text );
5154: , avalue => l_msg_desc_text );
5155:
5156: -- IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved AND
5157: -- p_conflict_group_id IS NOT NULL) THEN
5158: wf_engine.SetItemAttrText
5159: ( itemtype => l_wf_item_type
5160: , itemkey => l_itemkey
5161: , aname => 'CONFLICT_URL'
5162: , avalue => l_view_conflict_url );
5162: , avalue => l_view_conflict_url );
5163: -- END IF;
5164:
5165: --Setting Resource attributes
5166: wf_engine.SetItemAttrText
5167: ( itemtype => l_wf_item_type
5168: , itemkey => l_itemkey
5169: , aname => 'NTFY_FYI_USER_NAME'
5170: , avalue => l_ntfy_apprvl_recipient_name);
5168: , itemkey => l_itemkey
5169: , aname => 'NTFY_FYI_USER_NAME'
5170: , avalue => l_ntfy_apprvl_recipient_name);
5171:
5172: wf_engine.SetItemAttrText
5173: ( itemtype => l_wf_item_type
5174: , itemkey => l_itemkey
5175: , aname => 'RESOURCE_NAME'
5176: , avalue => l_resource_rec.resource_name );
5174: , itemkey => l_itemkey
5175: , aname => 'RESOURCE_NAME'
5176: , avalue => l_resource_rec.resource_name );
5177:
5178: wf_engine.SetItemAttrText
5179: ( itemtype => l_wf_item_type
5180: , itemkey => l_itemkey
5181: , aname => 'RESOURCE_ORGANIZATION'
5182: , avalue => l_resource_rec.name );
5182: , avalue => l_resource_rec.name );
5183:
5184:
5185: --Setting URL information
5186: wf_engine.SetItemAttrText
5187: ( itemtype => l_wf_item_type
5188: , itemkey => l_itemkey
5189: , aname => 'ASSIGNMENT_DETAILS_URL'
5190: , avalue => l_asgmt_details_url );
5188: , itemkey => l_itemkey
5189: , aname => 'ASSIGNMENT_DETAILS_URL'
5190: , avalue => l_asgmt_details_url );
5191:
5192: wf_engine.SetItemAttrText
5193: ( itemtype => l_wf_item_type
5194: , itemkey => l_itemkey
5195: , aname => 'RESOURCE_SCHEDULES_URL'
5196: , avalue => l_resource_schedules_url );
5196: , avalue => l_resource_schedules_url );
5197:
5198: --Setting assignment attributes
5199: IF l_reapproval_flag = 'Y' THEN
5200: wf_engine.SetItemAttrNumber
5201: ( itemtype => l_wf_item_type
5202: , itemkey => l_itemkey
5203: , aname => 'PREV_DURATION'
5204: , avalue => l_prev_asgmt_info_rec.prev_duration );
5202: , itemkey => l_itemkey
5203: , aname => 'PREV_DURATION'
5204: , avalue => l_prev_asgmt_info_rec.prev_duration );
5205:
5206: wf_engine.SetItemAttrNumber
5207: ( itemtype => l_wf_item_type
5208: ,itemkey => l_itemkey
5209: , aname => 'PREV_EFFORT'
5210: , avalue => l_prev_asgmt_info_rec.prev_effort );
5210: , avalue => l_prev_asgmt_info_rec.prev_effort );
5211: END IF;
5212:
5213: -- Start Additions by RM for bug 2274426
5214: wf_engine.SetItemAttrNumber
5215: ( itemtype => l_wf_item_type
5216: , itemkey => l_itemkey
5217: , aname => 'REVENUE_BILL_RATE'
5218: , avalue => l_assignments_rec.revenue_bill_rate
5216: , itemkey => l_itemkey
5217: , aname => 'REVENUE_BILL_RATE'
5218: , avalue => l_assignments_rec.revenue_bill_rate
5219: );
5220: wf_engine.SetItemAttrText
5221: ( itemtype => l_wf_item_type
5222: , itemkey => l_itemkey
5223: , aname => 'REVENUE_BILL_RATE_CURR'
5224: , avalue => l_assignments_rec.revenue_currency_code
5222: , itemkey => l_itemkey
5223: , aname => 'REVENUE_BILL_RATE_CURR'
5224: , avalue => l_assignments_rec.revenue_currency_code
5225: );
5226: wf_engine.SetItemAttrNumber
5227: ( itemtype => l_wf_item_type
5228: , itemkey => l_itemkey
5229: , aname => 'BILL_RATE_OVERRIDE'
5230: , avalue => l_assignments_rec.bill_rate_override
5228: , itemkey => l_itemkey
5229: , aname => 'BILL_RATE_OVERRIDE'
5230: , avalue => l_assignments_rec.bill_rate_override
5231: );
5232: wf_engine.SetItemAttrText
5233: ( itemtype => l_wf_item_type
5234: , itemkey => l_itemkey
5235: , aname => 'BILL_RATE_OVERRIDE_CURR'
5236: , avalue => l_assignments_rec.bill_rate_curr_override
5235: , aname => 'BILL_RATE_OVERRIDE_CURR'
5236: , avalue => l_assignments_rec.bill_rate_curr_override
5237: );
5238: IF l_assignments_rec.markup_percent_override IS NOT NULL THEN
5239: wf_engine.SetItemAttrText
5240: ( itemtype => l_wf_item_type
5241: , itemkey => l_itemkey
5242: , aname => 'MARKUP_PCT_OVERRIDE'
5243: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
5242: , aname => 'MARKUP_PCT_OVERRIDE'
5243: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
5244: );
5245: ELSE
5246: wf_engine.SetItemAttrText
5247: ( itemtype => l_wf_item_type
5248: , itemkey => l_itemkey
5249: , aname => 'MARKUP_PCT_OVERRIDE'
5250: , avalue => to_char(l_assignments_rec.markup_percent_override)
5249: , aname => 'MARKUP_PCT_OVERRIDE'
5250: , avalue => to_char(l_assignments_rec.markup_percent_override)
5251: );
5252: END IF;
5253: wf_engine.SetItemAttrText
5254: ( itemtype => l_wf_item_type
5255: , itemkey => l_itemkey
5256: , aname => 'TP_AMT_TYPE_NAME'
5257: , avalue => l_assignments_rec.fcst_tp_amount_type_name
5255: , itemkey => l_itemkey
5256: , aname => 'TP_AMT_TYPE_NAME'
5257: , avalue => l_assignments_rec.fcst_tp_amount_type_name
5258: );
5259: wf_engine.SetItemAttrNumber
5260: ( itemtype => l_wf_item_type
5261: , itemkey => l_itemkey
5262: , aname => 'TP_RATE_OVERRIDE'
5263: , avalue => l_assignments_rec.tp_rate_override
5261: , itemkey => l_itemkey
5262: , aname => 'TP_RATE_OVERRIDE'
5263: , avalue => l_assignments_rec.tp_rate_override
5264: );
5265: wf_engine.SetItemAttrText
5266: ( itemtype => l_wf_item_type
5267: , itemkey => l_itemkey
5268: , aname => 'TP_RATE_OVERRIDE_CURR'
5269: , avalue => l_assignments_rec.tp_currency_override
5272: open csr_get_override_basis_name(l_assignments_rec.tp_calc_base_code_override);
5273: fetch csr_get_override_basis_name into l_override_basis_name;
5274: close csr_get_override_basis_name;
5275: END IF;
5276: wf_engine.SetItemAttrText
5277: ( itemtype => l_wf_item_type
5278: , itemkey => l_itemkey
5279: , aname => 'OVERRIDE_BASIS_NAME'
5280: , avalue => l_override_basis_name
5280: , avalue => l_override_basis_name
5281: );
5282: IF l_assignments_rec.tp_percent_applied_override IS NOT NULL THEN
5283: IF l_override_basis_name IS NOT NULL THEN
5284: wf_engine.SetItemAttrText
5285: ( itemtype => l_wf_item_type
5286: , itemkey => l_itemkey
5287: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5288: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5287: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5288: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5289: );
5290: ELSE
5291: wf_engine.SetItemAttrText
5292: ( itemtype => l_wf_item_type
5293: , itemkey => l_itemkey
5294: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5295: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5295: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5296: );
5297: END IF;
5298: ELSE
5299: wf_engine.SetItemAttrText
5300: ( itemtype => l_wf_item_type
5301: , itemkey => l_itemkey
5302: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5303: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
5302: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5303: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
5304: );
5305: END IF;
5306: wf_engine.SetItemAttrText
5307: ( itemtype => l_wf_item_type
5308: , itemkey => l_itemkey
5309: , aname => 'WORK_TYPE_NAME'
5310: , avalue => l_assignments_rec.work_type_name
5310: , avalue => l_assignments_rec.work_type_name
5311: );
5312: -- End of Additions by RM
5313:
5314: wf_engine.SetItemAttrText
5315: ( itemtype => l_wf_item_type
5316: , itemkey => l_itemkey
5317: , aname => 'ASSIGNMENT_NAME'
5318: , avalue => l_assignments_rec.assignment_name );
5316: , itemkey => l_itemkey
5317: , aname => 'ASSIGNMENT_NAME'
5318: , avalue => l_assignments_rec.assignment_name );
5319:
5320: wf_engine.SetItemAttrNumber
5321: ( itemtype => l_wf_item_type
5322: , itemkey => l_itemkey
5323: , aname => 'ASSIGNMENT_DURATION'
5324: , avalue => (trunc(l_assignments_rec.end_date) -
5323: , aname => 'ASSIGNMENT_DURATION'
5324: , avalue => (trunc(l_assignments_rec.end_date) -
5325: trunc(l_assignments_rec.start_date)+1) );
5326:
5327: wf_engine.SetItemAttrNumber
5328: ( itemtype => l_wf_item_type
5329: , itemkey => l_itemkey
5330: , aname => 'ASSIGNMENT_EFFORT'
5331: , avalue => l_assignments_rec.assignment_effort );
5329: , itemkey => l_itemkey
5330: , aname => 'ASSIGNMENT_EFFORT'
5331: , avalue => l_assignments_rec.assignment_effort );
5332:
5333: wf_engine.SetItemAttrText
5334: ( itemtype => l_wf_item_type
5335: , itemkey => l_itemkey
5336: , aname => 'DESCRIPTION'
5337: , avalue => l_assignments_rec.description );
5335: , itemkey => l_itemkey
5336: , aname => 'DESCRIPTION'
5337: , avalue => l_assignments_rec.description );
5338:
5339: wf_engine.SetItemAttrText
5340: ( itemtype => l_wf_item_type
5341: , itemkey => l_itemkey
5342: , aname => 'ADDITIONAL_INFORMATION'
5343: , avalue => l_assignments_rec.additional_information );
5342: , aname => 'ADDITIONAL_INFORMATION'
5343: , avalue => l_assignments_rec.additional_information );
5344:
5345: --Setting Project attributes
5346: wf_engine.SetItemAttrText
5347: ( itemtype => l_wf_item_type
5348: , itemkey => l_itemkey
5349: , aname => 'PROJECT_NAME'
5350: , avalue => p_project_name );
5348: , itemkey => l_itemkey
5349: , aname => 'PROJECT_NAME'
5350: , avalue => p_project_name );
5351:
5352: wf_engine.SetItemAttrText
5353: ( itemtype => l_wf_item_type
5354: , itemkey => l_itemkey
5355: , aname => 'PROJECT_NUMBER'
5356: , avalue => p_project_number );
5354: , itemkey => l_itemkey
5355: , aname => 'PROJECT_NUMBER'
5356: , avalue => p_project_number );
5357:
5358: wf_engine.SetItemAttrText
5359: ( itemtype => l_wf_item_type
5360: , itemkey => l_itemkey
5361: , aname => 'PROJECT_MANAGER_NAME'
5362: , avalue => p_project_manager );
5360: , itemkey => l_itemkey
5361: , aname => 'PROJECT_MANAGER_NAME'
5362: , avalue => p_project_manager );
5363:
5364: wf_engine.SetItemAttrText
5365: ( itemtype => l_wf_item_type
5366: , itemkey => l_itemkey
5367: , aname => 'PROJECT_ORGANIZATION'
5368: , avalue => p_project_org );
5366: , itemkey => l_itemkey
5367: , aname => 'PROJECT_ORGANIZATION'
5368: , avalue => p_project_org );
5369:
5370: wf_engine.SetItemAttrText
5371: ( itemtype => l_wf_item_type
5372: , itemkey => l_itemkey
5373: , aname => 'PROJECT_CUSTOMER'
5374: , avalue => p_project_cus );
5372: , itemkey => l_itemkey
5373: , aname => 'PROJECT_CUSTOMER'
5374: , avalue => p_project_cus );
5375:
5376: wf_engine.SetItemAttrDate
5377: ( itemtype => l_wf_item_type
5378: , itemkey => l_itemkey
5379: , aname => 'START_DATE'
5380: , avalue => l_assignments_rec.start_date);
5378: , itemkey => l_itemkey
5379: , aname => 'START_DATE'
5380: , avalue => l_assignments_rec.start_date);
5381:
5382: wf_engine.SetItemAttrDate
5383: ( itemtype => l_wf_item_type
5384: , itemkey => l_itemkey
5385: , aname => 'END_DATE'
5386: , avalue => l_assignments_rec.end_date);
5386: , avalue => l_assignments_rec.end_date);
5387:
5388: /* Added for bug 3051110 */
5389:
5390: wf_engine.SetItemAttrNumber
5391: ( itemtype => l_wf_item_type
5392: , Itemkey => l_itemkey
5393: , aname => 'TRANSFER_PRICE_RATE'
5394: , avalue => l_assignments_rec.transfer_price_rate);
5392: , Itemkey => l_itemkey
5393: , aname => 'TRANSFER_PRICE_RATE'
5394: , avalue => l_assignments_rec.transfer_price_rate);
5395:
5396: wf_Engine.SetItemAttrText
5397: (itemtype => l_wf_item_type
5398: , itemkey => l_itemkey
5399: , aname => 'TRANSFER_PR_RATE_CURR'
5400: , avalue => l_assignments_rec.transfer_pr_rate_curr);
5399: , aname => 'TRANSFER_PR_RATE_CURR'
5400: , avalue => l_assignments_rec.transfer_pr_rate_curr);
5401:
5402: --Start the workflow process
5403: wf_engine.StartProcess ( itemtype => l_wf_item_type
5404: ,itemkey => l_itemkey );
5405:
5406: PA_WORKFLOW_UTILS.Insert_WF_Processes
5407: (p_wf_type_code => 'MASS_ASSIGNMENT_APPROVAL'
5418: END IF;--end recipient name is null (no fnd_user for this resource)
5419:
5420:
5421: --Setting the original value
5422: wf_engine.threshold := l_save_threshold;
5423:
5424: -- IF the number of messages is 1 then fetch the message code from
5425: -- the stack and return its text
5426: x_msg_count := FND_MSG_PUB.Count_Msg;
5444: EXCEPTION
5445: WHEN OTHERS THEN
5446:
5447: --Setting the original value
5448: wf_engine.threshold := l_save_threshold;
5449:
5450: -- Set the excetption Message and the stack
5451: FND_MSG_PUB.add_exc_msg
5452: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_res_fyi_notification'
5588: '&akRegionCode=PA_SELECTED_RESOURCES_LAYOUT&paCallingPage=WF_Notifications' ||
5589: '&paProjectId=' || l_assignments_rec.project_id || '&paNotifiedId=' ||
5590: p_notified_id || '&paGroupId=' || p_group_id || '&paApprovalStatus=Rejected&addBreadCrumb=RP';
5591:
5592: wf_engine.SetItemAttrText
5593: ( itemtype => l_wf_item_type
5594: , itemkey => l_itemkey
5595: , aname => 'SELECTED_RESOURCES_URL'
5596: , avalue => l_selected_resources_url);
5594: , itemkey => l_itemkey
5595: , aname => 'SELECTED_RESOURCES_URL'
5596: , avalue => l_selected_resources_url);
5597:
5598: wf_engine.SetItemAttrText
5599: ( itemtype => l_wf_item_type
5600: , itemkey => l_itemkey
5601: , aname => 'SELECTED_RESOURCES2_URL'
5602: , avalue => l_selected_resources2_url);
5600: , itemkey => l_itemkey
5601: , aname => 'SELECTED_RESOURCES2_URL'
5602: , avalue => l_selected_resources2_url);
5603:
5604: wf_engine.SetItemAttrText
5605: ( itemtype => l_wf_item_type
5606: , itemkey => l_itemkey
5607: , aname => 'ASSIGNMENT_NAME'
5608: , avalue => l_assignments_rec.assignment_name );
5606: , itemkey => l_itemkey
5607: , aname => 'ASSIGNMENT_NAME'
5608: , avalue => l_assignments_rec.assignment_name );
5609:
5610: wf_engine.SetItemAttrText
5611: ( itemtype => l_wf_item_type
5612: , itemkey => l_itemkey
5613: , aname => 'RESOURCE_ORGANIZATION'
5614: , avalue => l_assignments_rec.name );
5612: , itemkey => l_itemkey
5613: , aname => 'RESOURCE_ORGANIZATION'
5614: , avalue => l_assignments_rec.name );
5615:
5616: wf_engine.SetItemAttrNumber
5617: ( itemtype => l_wf_item_type
5618: , itemkey => l_itemkey
5619: , aname => 'ASSIGNMENT_DURATION'
5620: , avalue => (trunc(l_assignments_rec.end_date) -
5619: , aname => 'ASSIGNMENT_DURATION'
5620: , avalue => (trunc(l_assignments_rec.end_date) -
5621: trunc(l_assignments_rec.start_date)+1) );
5622:
5623: wf_engine.SetItemAttrNumber
5624: ( itemtype => l_wf_item_type
5625: , itemkey => l_itemkey
5626: , aname => 'ASSIGNMENT_EFFORT'
5627: , avalue => l_assignments_rec.assignment_effort );
5625: , itemkey => l_itemkey
5626: , aname => 'ASSIGNMENT_EFFORT'
5627: , avalue => l_assignments_rec.assignment_effort );
5628:
5629: wf_engine.SetItemAttrText
5630: ( itemtype => l_wf_item_type
5631: , itemkey => l_itemkey
5632: , aname => 'DESCRIPTION'
5633: , avalue => l_assignments_rec.description );
5631: , itemkey => l_itemkey
5632: , aname => 'DESCRIPTION'
5633: , avalue => l_assignments_rec.description );
5634:
5635: wf_engine.SetItemAttrText
5636: ( itemtype => l_wf_item_type
5637: , itemkey => l_itemkey
5638: , aname => 'ADDITIONAL_INFORMATION'
5639: , avalue => l_assignments_rec.additional_information );
5637: , itemkey => l_itemkey
5638: , aname => 'ADDITIONAL_INFORMATION'
5639: , avalue => l_assignments_rec.additional_information );
5640:
5641: wf_engine.SetItemAttrDate
5642: (itemtype => l_wf_item_type
5643: , itemkey => l_itemkey
5644: , aname => 'START_DATE'
5645: , avalue => l_assignments_rec.start_date
5644: , aname => 'START_DATE'
5645: , avalue => l_assignments_rec.start_date
5646: );
5647:
5648: wf_engine.SetItemAttrDate
5649: (itemtype => l_wf_item_type
5650: , itemkey => l_itemkey
5651: , aname => 'END_DATE'
5652: , avalue => l_assignments_rec.end_date
5651: , aname => 'END_DATE'
5652: , avalue => l_assignments_rec.end_date
5653: );
5654: -- Start Additions by RM for bug 2274426
5655: wf_engine.SetItemAttrNumber
5656: ( itemtype => l_wf_item_type
5657: , itemkey => l_itemkey
5658: , aname => 'REVENUE_BILL_RATE'
5659: , avalue => l_assignments_rec.revenue_bill_rate
5657: , itemkey => l_itemkey
5658: , aname => 'REVENUE_BILL_RATE'
5659: , avalue => l_assignments_rec.revenue_bill_rate
5660: );
5661: wf_engine.SetItemAttrText
5662: ( itemtype => l_wf_item_type
5663: , itemkey => l_itemkey
5664: , aname => 'REVENUE_BILL_RATE_CURR'
5665: , avalue => l_assignments_rec.revenue_currency_code
5663: , itemkey => l_itemkey
5664: , aname => 'REVENUE_BILL_RATE_CURR'
5665: , avalue => l_assignments_rec.revenue_currency_code
5666: );
5667: wf_engine.SetItemAttrNumber
5668: ( itemtype => l_wf_item_type
5669: , itemkey => l_itemkey
5670: , aname => 'BILL_RATE_OVERRIDE'
5671: , avalue => l_assignments_rec.bill_rate_override
5669: , itemkey => l_itemkey
5670: , aname => 'BILL_RATE_OVERRIDE'
5671: , avalue => l_assignments_rec.bill_rate_override
5672: );
5673: wf_engine.SetItemAttrText
5674: ( itemtype => l_wf_item_type
5675: , itemkey => l_itemkey
5676: , aname => 'BILL_RATE_OVERRIDE_CURR'
5677: , avalue => l_assignments_rec.bill_rate_curr_override
5676: , aname => 'BILL_RATE_OVERRIDE_CURR'
5677: , avalue => l_assignments_rec.bill_rate_curr_override
5678: );
5679: IF l_assignments_rec.markup_percent_override IS NOT NULL THEN
5680: wf_engine.SetItemAttrText
5681: ( itemtype => l_wf_item_type
5682: , itemkey => l_itemkey
5683: , aname => 'MARKUP_PCT_OVERRIDE'
5684: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
5683: , aname => 'MARKUP_PCT_OVERRIDE'
5684: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
5685: );
5686: ELSE
5687: wf_engine.SetItemAttrText
5688: ( itemtype => l_wf_item_type
5689: , itemkey => l_itemkey
5690: , aname => 'MARKUP_PCT_OVERRIDE'
5691: , avalue => to_char(l_assignments_rec.markup_percent_override)
5690: , aname => 'MARKUP_PCT_OVERRIDE'
5691: , avalue => to_char(l_assignments_rec.markup_percent_override)
5692: );
5693: END IF;
5694: wf_engine.SetItemAttrText
5695: ( itemtype => l_wf_item_type
5696: , itemkey => l_itemkey
5697: , aname => 'TP_AMT_TYPE_NAME'
5698: , avalue => l_assignments_rec.fcst_tp_amount_type_name
5696: , itemkey => l_itemkey
5697: , aname => 'TP_AMT_TYPE_NAME'
5698: , avalue => l_assignments_rec.fcst_tp_amount_type_name
5699: );
5700: wf_engine.SetItemAttrNumber
5701: ( itemtype => l_wf_item_type
5702: , itemkey => l_itemkey
5703: , aname => 'TP_RATE_OVERRIDE'
5704: , avalue => l_assignments_rec.tp_rate_override
5702: , itemkey => l_itemkey
5703: , aname => 'TP_RATE_OVERRIDE'
5704: , avalue => l_assignments_rec.tp_rate_override
5705: );
5706: wf_engine.SetItemAttrText
5707: ( itemtype => l_wf_item_type
5708: , itemkey => l_itemkey
5709: , aname => 'TP_RATE_OVERRIDE_CURR'
5710: , avalue => l_assignments_rec.tp_currency_override
5713: open csr_get_override_basis_name(l_assignments_rec.tp_calc_base_code_override);
5714: fetch csr_get_override_basis_name into l_override_basis_name;
5715: close csr_get_override_basis_name;
5716: END IF;
5717: wf_engine.SetItemAttrText
5718: ( itemtype => l_wf_item_type
5719: , itemkey => l_itemkey
5720: , aname => 'OVERRIDE_BASIS_NAME'
5721: , avalue => l_override_basis_name
5721: , avalue => l_override_basis_name
5722: );
5723: IF l_assignments_rec.tp_percent_applied_override IS NOT NULL THEN
5724: IF l_override_basis_name IS NOT NULL THEN
5725: wf_engine.SetItemAttrText
5726: ( itemtype => l_wf_item_type
5727: , itemkey => l_itemkey
5728: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5729: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5728: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5729: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5730: );
5731: ELSE
5732: wf_engine.SetItemAttrText
5733: ( itemtype => l_wf_item_type
5734: , itemkey => l_itemkey
5735: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5736: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5736: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5737: );
5738: END IF;
5739: ELSE
5740: wf_engine.SetItemAttrText
5741: ( itemtype => l_wf_item_type
5742: , itemkey => l_itemkey
5743: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5744: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
5743: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5744: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
5745: );
5746: END IF;
5747: wf_engine.SetItemAttrText
5748: ( itemtype => l_wf_item_type
5749: , itemkey => l_itemkey
5750: , aname => 'WORK_TYPE_NAME'
5751: , avalue => l_assignments_rec.work_type_name
5758: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
5759:
5760: THEN
5761:
5762: wf_engine.SetItemAttrDocument
5763: ( itemtype => l_wf_item_type
5764: , itemkey => l_itemkey
5765: , aname => 'UPDATED_INFO_DOC'
5766: , documentid => p_update_info_doc );
5771: --Setting Common attributes for CRN / UPD / APS
5772: --------------------------------------------------------------------
5773:
5774: --Setting Assignment Attributes
5775: wf_engine.SetItemAttrNumber
5776: ( itemtype => l_wf_item_type
5777: , itemkey => l_itemkey
5778: , aname => 'APPROVED_ASSIGNMENTS'
5779: , avalue => p_num_apr_asgns );
5777: , itemkey => l_itemkey
5778: , aname => 'APPROVED_ASSIGNMENTS'
5779: , avalue => p_num_apr_asgns );
5780:
5781: wf_engine.SetItemAttrText
5782: ( itemtype => l_wf_item_type
5783: , itemkey => l_itemkey
5784: , aname => 'SELECTED_ROLES_URL'
5785: , avalue => l_selected_roles_url);
5783: , itemkey => l_itemkey
5784: , aname => 'SELECTED_ROLES_URL'
5785: , avalue => l_selected_roles_url);
5786:
5787: wf_engine.SetItemAttrText
5788: ( itemtype => l_wf_item_type
5789: , itemkey => l_itemkey
5790: , aname => 'SELECTED_ROLES2_URL'
5791: , avalue => l_selected_roles2_url);
5789: , itemkey => l_itemkey
5790: , aname => 'SELECTED_ROLES2_URL'
5791: , avalue => l_selected_roles2_url);
5792:
5793: wf_engine.SetItemAttrNumber
5794: ( itemtype => l_wf_item_type
5795: , itemkey => l_itemkey
5796: , aname => 'REJECTED_ASSIGNMENTS'
5797: , avalue => p_num_rej_asgns );
5796: , aname => 'REJECTED_ASSIGNMENTS'
5797: , avalue => p_num_rej_asgns );
5798:
5799: --Setting Project attributes
5800: wf_engine.SetItemAttrText
5801: ( itemtype => l_wf_item_type
5802: , itemkey => l_itemkey
5803: , aname => 'PROJECT_NAME'
5804: , avalue => p_project_name );
5802: , itemkey => l_itemkey
5803: , aname => 'PROJECT_NAME'
5804: , avalue => p_project_name );
5805:
5806: wf_engine.SetItemAttrText
5807: ( itemtype => l_wf_item_type
5808: , itemkey => l_itemkey
5809: , aname => 'PROJECT_NUMBER'
5810: , avalue => p_project_number );
5808: , itemkey => l_itemkey
5809: , aname => 'PROJECT_NUMBER'
5810: , avalue => p_project_number );
5811:
5812: wf_engine.SetItemAttrText
5813: ( itemtype => l_wf_item_type
5814: , itemkey => l_itemkey
5815: , aname => 'PROJECT_MANAGER_NAME'
5816: , avalue => p_project_manager );
5814: , itemkey => l_itemkey
5815: , aname => 'PROJECT_MANAGER_NAME'
5816: , avalue => p_project_manager );
5817:
5818: wf_engine.SetItemAttrText
5819: ( itemtype => l_wf_item_type
5820: , itemkey => l_itemkey
5821: , aname => 'PROJECT_ORGANIZATION'
5822: , avalue => p_project_org );
5820: , itemkey => l_itemkey
5821: , aname => 'PROJECT_ORGANIZATION'
5822: , avalue => p_project_org );
5823:
5824: wf_engine.SetItemAttrText
5825: ( itemtype => l_wf_item_type
5826: , itemkey => l_itemkey
5827: , aname => 'PROJECT_CUSTOMER'
5828: , avalue => p_project_cus );
5837: l_conflict_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275&akRegionCode=PA_VIEW_CONFLICTS_LAYOUT&paProjectId=' ||
5838: l_assignments_rec.project_id || '&paCallingPage=MassAsmtFYINotif&paConflictGroupId=' ||
5839: l_conflict_group_id || '&addBreadCrumb=RP';
5840:
5841: wf_engine.SetItemAttrText
5842: ( itemtype => l_wf_item_type
5843: , itemkey => l_itemkey
5844: , aname => 'CONFLICT_URL'
5845: , avalue => l_conflict_url );
6259: , resp_id => l_responsibility_id
6260: , resp_appl_id => l_resp_appl_id );
6261:
6262: -- Setting thresold value to run the process in background
6263: l_save_threshold := wf_engine.threshold;
6264: wf_engine.threshold := -1;
6265:
6266: -----------------------------------------------------------------------------
6267: --Setting Process Creation / Update / Aproval submission mode for assignments
6260: , resp_appl_id => l_resp_appl_id );
6261:
6262: -- Setting thresold value to run the process in background
6263: l_save_threshold := wf_engine.threshold;
6264: wf_engine.threshold := -1;
6265:
6266: -----------------------------------------------------------------------------
6267: --Setting Process Creation / Update / Aproval submission mode for assignments
6268: -----------------------------------------------------------------------------
6292: INTO l_itemkey
6293: FROM dual;
6294:
6295: -- Create the WF process
6296: wf_engine.CreateProcess
6297: ( ItemType => l_wf_item_type
6298: , ItemKey => l_itemkey
6299: , process => l_wf_process );
6300:
6300:
6301: ------------------------------------------------------------
6302: --Set the item attributes required for manager notifications
6303: ------------------------------------------------------------
6304: wf_engine.SetItemAttrText
6305: ( itemtype => l_wf_item_type
6306: , itemkey => l_itemkey
6307: , aname => 'NTFY_FYI_USER_NAME'
6308: , avalue => l_recipients_tbl(k));
6372:
6373: log_message('After Calling set manager attributes');
6374:
6375: --Start the workflow process
6376: wf_engine.StartProcess ( itemtype => l_wf_item_type
6377: ,itemkey => l_itemkey );
6378:
6379: PA_WORKFLOW_UTILS.Insert_WF_Processes
6380: (p_wf_type_code => 'MASS_ASSIGNMENT_APPROVAL'
6390: END LOOP;--end k loop
6391:
6392:
6393: --Setting the original value
6394: wf_engine.threshold := l_save_threshold;
6395:
6396: -- IF the number of messages is 1 then fetch the message code from
6397: -- the stack and return its text
6398: x_msg_count := FND_MSG_PUB.Count_Msg;
6488:
6489: ---------------------------------------------------
6490: --Get the values required from the item attributes
6491: ---------------------------------------------------
6492: l_project_id := wf_engine.getItemAttrNumber
6493: ( itemtype => itemtype
6494: , itemkey => itemkey
6495: , aname => 'PROJECT_ID' );
6496:
6493: ( itemtype => itemtype
6494: , itemkey => itemkey
6495: , aname => 'PROJECT_ID' );
6496:
6497: l_mode := wf_engine.getItemAttrText
6498: ( itemtype => itemtype
6499: , itemkey => itemkey
6500: , aname => 'MODE' );
6501:
6498: ( itemtype => itemtype
6499: , itemkey => itemkey
6500: , aname => 'MODE' );
6501:
6502: l_group_id := wf_engine.getItemAttrNumber
6503: ( itemtype => itemtype
6504: , itemkey => itemkey
6505: , aname => 'GROUP_ID' );
6506:
6503: ( itemtype => itemtype
6504: , itemkey => itemkey
6505: , aname => 'GROUP_ID' );
6506:
6507: l_approver_group_id := wf_engine.getItemAttrNumber
6508: ( itemtype => itemtype
6509: , itemkey => itemkey
6510: , aname => 'APPROVER_GROUP_ID' );
6511:
6508: ( itemtype => itemtype
6509: , itemkey => itemkey
6510: , aname => 'APPROVER_GROUP_ID' );
6511:
6512: l_routing_order := wf_engine.getItemAttrNumber
6513: ( itemtype => itemtype
6514: , itemkey => itemkey
6515: , aname => 'ROUTING_ORDER' );
6516:
6513: ( itemtype => itemtype
6514: , itemkey => itemkey
6515: , aname => 'ROUTING_ORDER' );
6516:
6517: l_num_assignments := wf_engine.getItemAttrNumber
6518: ( itemtype => itemtype
6519: , itemkey => itemkey
6520: , aname => 'NUMBER_OF_ASSIGNMENTS' );
6521:
6519: , itemkey => itemkey
6520: , aname => 'NUMBER_OF_ASSIGNMENTS' );
6521:
6522: --Get the Update Info document
6523: l_update_info_doc := wf_engine.getItemAttrDocument
6524: ( itemtype => itemtype
6525: , itemkey => itemkey
6526: , aname => 'UPDATED_INFO_DOC' );
6527:
6524: ( itemtype => itemtype
6525: , itemkey => itemkey
6526: , aname => 'UPDATED_INFO_DOC' );
6527:
6528: l_submitter_user_name := wf_engine.getItemAttrText
6529: ( itemtype => itemtype
6530: , itemkey => itemkey
6531: , aname => 'SUBMITTER_UNAME');
6532:
6529: ( itemtype => itemtype
6530: , itemkey => itemkey
6531: , aname => 'SUBMITTER_UNAME');
6532:
6533: l_conflict_group_id := wf_engine.getItemAttrNumber
6534: ( itemtype => itemtype
6535: , itemkey => itemkey
6536: , aname => 'CONFLICT_GROUP_ID' );
6537:
6534: ( itemtype => itemtype
6535: , itemkey => itemkey
6536: , aname => 'CONFLICT_GROUP_ID' );
6537:
6538: l_forwarded_from := wf_engine.getItemAttrText
6539: ( itemtype => itemtype
6540: , itemkey => itemkey
6541: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
6542:
6539: ( itemtype => itemtype
6540: , itemkey => itemkey
6541: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
6542:
6543: l_note_to_approvers := wf_engine.getItemAttrText
6544: ( itemtype => itemtype
6545: , itemkey => itemkey
6546: , aname => 'NOTE_TO_APPROVER');
6547:
6551: --Also get number of approved and rejected assignments
6552: -----------------------------------------------------------
6553: FOR i IN 1..l_num_assignments LOOP
6554: l_assignment_id_tbl.extend;
6555: l_assignment_id_tbl(i) := wf_engine.getItemAttrNumber
6556: ( itemtype => itemtype
6557: ,itemkey => itemkey
6558: ,aname => 'ASSIGNMENT_'|| i );
6559:
6557: ,itemkey => itemkey
6558: ,aname => 'ASSIGNMENT_'|| i );
6559:
6560: l_approval_status_tbl.extend;
6561: l_approval_status_tbl(i) := wf_engine.getItemAttrText
6562: ( itemtype => itemtype
6563: ,itemkey => itemkey
6564: ,aname => 'STATUS_'|| i );
6565: END LOOP;
7395: , resp_id => l_responsibility_id
7396: , resp_appl_id => l_resp_appl_id );
7397:
7398: -- Setting thresold value to run the process in background
7399: l_save_threshold := wf_engine.threshold;
7400: wf_engine.threshold := -1;
7401:
7402: ----------------------------------------------------------------
7403: --Getting all local variables required for workflow attributes
7396: , resp_appl_id => l_resp_appl_id );
7397:
7398: -- Setting thresold value to run the process in background
7399: l_save_threshold := wf_engine.threshold;
7400: wf_engine.threshold := -1;
7401:
7402: ----------------------------------------------------------------
7403: --Getting all local variables required for workflow attributes
7404: ---------------------------------------------------------------
7431:
7432: END IF;
7433:
7434: -- Create the WF process
7435: wf_engine.CreateProcess
7436: ( ItemType => l_wf_item_type
7437: , ItemKey => l_itemkey
7438: , process => l_wf_process );
7439:
7468: END IF;
7469:
7470: CLOSE l_assignments_csr;
7471:
7472: wf_engine.SetItemAttrText
7473: ( itemtype => l_wf_item_type
7474: , itemkey => l_itemkey
7475: , aname => 'ASSIGNMENT_NAME'
7476: , avalue => l_assignments_rec.assignment_name );
7474: , itemkey => l_itemkey
7475: , aname => 'ASSIGNMENT_NAME'
7476: , avalue => l_assignments_rec.assignment_name );
7477:
7478: wf_engine.SetItemAttrText
7479: ( itemtype => l_wf_item_type
7480: , itemkey => l_itemkey
7481: , aname => 'RESOURCE_ORGANIZATION'
7482: , avalue => l_assignments_rec.name );
7480: , itemkey => l_itemkey
7481: , aname => 'RESOURCE_ORGANIZATION'
7482: , avalue => l_assignments_rec.name );
7483:
7484: wf_engine.SetItemAttrNumber
7485: ( itemtype => l_wf_item_type
7486: , itemkey => l_itemkey
7487: , aname => 'ASSIGNMENT_DURATION'
7488: , avalue => (trunc(l_assignments_rec.end_date) -
7487: , aname => 'ASSIGNMENT_DURATION'
7488: , avalue => (trunc(l_assignments_rec.end_date) -
7489: trunc(l_assignments_rec.start_date)+1) );
7490:
7491: wf_engine.SetItemAttrNumber
7492: ( itemtype => l_wf_item_type
7493: , itemkey => l_itemkey
7494: , aname => 'ASSIGNMENT_EFFORT'
7495: , avalue => l_assignments_rec.assignment_effort );
7493: , itemkey => l_itemkey
7494: , aname => 'ASSIGNMENT_EFFORT'
7495: , avalue => l_assignments_rec.assignment_effort );
7496:
7497: wf_engine.SetItemAttrText
7498: ( itemtype => l_wf_item_type
7499: , itemkey => l_itemkey
7500: , aname => 'DESCRIPTION'
7501: , avalue => l_assignments_rec.description );
7499: , itemkey => l_itemkey
7500: , aname => 'DESCRIPTION'
7501: , avalue => l_assignments_rec.description );
7502:
7503: wf_engine.SetItemAttrText
7504: ( itemtype => l_wf_item_type
7505: , itemkey => l_itemkey
7506: , aname => 'ADDITIONAL_INFORMATION'
7507: , avalue => l_assignments_rec.additional_information );
7506: , aname => 'ADDITIONAL_INFORMATION'
7507: , avalue => l_assignments_rec.additional_information );
7508:
7509: -- Start Additions by RM for bug 2274426
7510: wf_engine.SetItemAttrNumber
7511: ( itemtype => l_wf_item_type
7512: , itemkey => l_itemkey
7513: , aname => 'REVENUE_BILL_RATE'
7514: , avalue => l_assignments_rec.revenue_bill_rate
7512: , itemkey => l_itemkey
7513: , aname => 'REVENUE_BILL_RATE'
7514: , avalue => l_assignments_rec.revenue_bill_rate
7515: );
7516: wf_engine.SetItemAttrText
7517: ( itemtype => l_wf_item_type
7518: , itemkey => l_itemkey
7519: , aname => 'REVENUE_BILL_RATE_CURR'
7520: , avalue => l_assignments_rec.revenue_currency_code
7518: , itemkey => l_itemkey
7519: , aname => 'REVENUE_BILL_RATE_CURR'
7520: , avalue => l_assignments_rec.revenue_currency_code
7521: );
7522: wf_engine.SetItemAttrNumber
7523: ( itemtype => l_wf_item_type
7524: , itemkey => l_itemkey
7525: , aname => 'BILL_RATE_OVERRIDE'
7526: , avalue => l_assignments_rec.bill_rate_override
7524: , itemkey => l_itemkey
7525: , aname => 'BILL_RATE_OVERRIDE'
7526: , avalue => l_assignments_rec.bill_rate_override
7527: );
7528: wf_engine.SetItemAttrText
7529: ( itemtype => l_wf_item_type
7530: , itemkey => l_itemkey
7531: , aname => 'BILL_RATE_OVERRIDE_CURR'
7532: , avalue => l_assignments_rec.bill_rate_curr_override
7531: , aname => 'BILL_RATE_OVERRIDE_CURR'
7532: , avalue => l_assignments_rec.bill_rate_curr_override
7533: );
7534: IF l_assignments_rec.markup_percent_override IS NOT NULL THEN
7535: wf_engine.SetItemAttrText
7536: ( itemtype => l_wf_item_type
7537: , itemkey => l_itemkey
7538: , aname => 'MARKUP_PCT_OVERRIDE'
7539: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
7538: , aname => 'MARKUP_PCT_OVERRIDE'
7539: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
7540: );
7541: ELSE
7542: wf_engine.SetItemAttrText
7543: ( itemtype => l_wf_item_type
7544: , itemkey => l_itemkey
7545: , aname => 'MARKUP_PCT_OVERRIDE'
7546: , avalue => to_char(l_assignments_rec.markup_percent_override)
7545: , aname => 'MARKUP_PCT_OVERRIDE'
7546: , avalue => to_char(l_assignments_rec.markup_percent_override)
7547: );
7548: END IF;
7549: wf_engine.SetItemAttrText
7550: ( itemtype => l_wf_item_type
7551: , itemkey => l_itemkey
7552: , aname => 'TP_AMT_TYPE_NAME'
7553: , avalue => l_assignments_rec.fcst_tp_amount_type_name
7551: , itemkey => l_itemkey
7552: , aname => 'TP_AMT_TYPE_NAME'
7553: , avalue => l_assignments_rec.fcst_tp_amount_type_name
7554: );
7555: wf_engine.SetItemAttrNumber
7556: ( itemtype => l_wf_item_type
7557: , itemkey => l_itemkey
7558: , aname => 'TP_RATE_OVERRIDE'
7559: , avalue => l_assignments_rec.tp_rate_override
7557: , itemkey => l_itemkey
7558: , aname => 'TP_RATE_OVERRIDE'
7559: , avalue => l_assignments_rec.tp_rate_override
7560: );
7561: wf_engine.SetItemAttrText
7562: ( itemtype => l_wf_item_type
7563: , itemkey => l_itemkey
7564: , aname => 'TP_RATE_OVERRIDE_CURR'
7565: , avalue => l_assignments_rec.tp_currency_override
7568: open csr_get_override_basis_name(l_assignments_rec.tp_calc_base_code_override);
7569: fetch csr_get_override_basis_name into l_override_basis_name;
7570: close csr_get_override_basis_name;
7571: END IF;
7572: wf_engine.SetItemAttrText
7573: ( itemtype => l_wf_item_type
7574: , itemkey => l_itemkey
7575: , aname => 'OVERRIDE_BASIS_NAME'
7576: , avalue => l_override_basis_name
7576: , avalue => l_override_basis_name
7577: );
7578: IF l_assignments_rec.tp_percent_applied_override IS NOT NULL THEN
7579: IF l_override_basis_name IS NOT NULL THEN
7580: wf_engine.SetItemAttrText
7581: ( itemtype => l_wf_item_type
7582: , itemkey => l_itemkey
7583: , aname => 'TP_PCT_APPLIED_OVERRIDE'
7584: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
7583: , aname => 'TP_PCT_APPLIED_OVERRIDE'
7584: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
7585: );
7586: ELSE
7587: wf_engine.SetItemAttrText
7588: ( itemtype => l_wf_item_type
7589: , itemkey => l_itemkey
7590: , aname => 'TP_PCT_APPLIED_OVERRIDE'
7591: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
7591: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
7592: );
7593: END IF;
7594: ELSE
7595: wf_engine.SetItemAttrText
7596: ( itemtype => l_wf_item_type
7597: , itemkey => l_itemkey
7598: , aname => 'TP_PCT_APPLIED_OVERRIDE'
7599: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
7598: , aname => 'TP_PCT_APPLIED_OVERRIDE'
7599: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
7600: );
7601: END IF;
7602: wf_engine.SetItemAttrText
7603: ( itemtype => l_wf_item_type
7604: , itemkey => l_itemkey
7605: , aname => 'WORK_TYPE_NAME'
7606: , avalue => l_assignments_rec.work_type_name
7607: );
7608: -- End of Additions by RM
7609:
7610: --Setting Successful assignments count
7611: wf_engine.SetItemAttrNumber
7612: ( itemtype => l_wf_item_type
7613: , itemkey => l_itemkey
7614: , aname => 'APPROVED_ASSIGNMENTS'
7615: , avalue => p_num_apr_asgns + p_num_rej_asgns);
7619: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7620: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7621:
7622: THEN
7623: wf_engine.SetItemAttrDocument
7624: ( itemtype => l_wf_item_type
7625: , itemkey => l_itemkey
7626: , aname => 'UPDATED_INFO_DOC'
7627: , documentid => p_update_info_doc );
7626: , aname => 'UPDATED_INFO_DOC'
7627: , documentid => p_update_info_doc );
7628:
7629: --Setting Successful assignments count
7630: wf_engine.SetItemAttrNumber
7631: ( itemtype => l_wf_item_type
7632: , itemkey => l_itemkey
7633: , aname => 'APPROVED_ASSIGNMENTS'
7634: , avalue => p_num_apr_asgns + p_num_rej_asgns);
7641:
7642: log_message('Setting common attributes');
7643:
7644: --Setting total assignments count
7645: wf_engine.SetItemAttrNumber
7646: ( itemtype => l_wf_item_type
7647: , itemkey => l_itemkey
7648: , aname => 'NUMBER_OF_ASSIGNMENTS'
7649: , avalue => p_num_apr_asgns + p_num_rej_asgns + l_error_asgns_count);
7648: , aname => 'NUMBER_OF_ASSIGNMENTS'
7649: , avalue => p_num_apr_asgns + p_num_rej_asgns + l_error_asgns_count);
7650:
7651: --Setting failed assignments count
7652: wf_engine.SetItemAttrNumber
7653: ( itemtype => l_wf_item_type
7654: , itemkey => l_itemkey
7655: , aname => 'REJECTED_ASSIGNMENTS'
7656: , avalue => l_error_asgns_count);
7655: , aname => 'REJECTED_ASSIGNMENTS'
7656: , avalue => l_error_asgns_count);
7657:
7658: --Setting Project attributes
7659: wf_engine.SetItemAttrText
7660: ( itemtype => l_wf_item_type
7661: , itemkey => l_itemkey
7662: , aname => 'PROJECT_NAME'
7663: , avalue => p_project_name );
7661: , itemkey => l_itemkey
7662: , aname => 'PROJECT_NAME'
7663: , avalue => p_project_name );
7664:
7665: wf_engine.SetItemAttrText
7666: ( itemtype => l_wf_item_type
7667: , itemkey => l_itemkey
7668: , aname => 'PROJECT_NUMBER'
7669: , avalue => p_project_number );
7667: , itemkey => l_itemkey
7668: , aname => 'PROJECT_NUMBER'
7669: , avalue => p_project_number );
7670:
7671: wf_engine.SetItemAttrText
7672: ( itemtype => l_wf_item_type
7673: , itemkey => l_itemkey
7674: , aname => 'PROJECT_MANAGER_NAME'
7675: , avalue => p_project_manager );
7673: , itemkey => l_itemkey
7674: , aname => 'PROJECT_MANAGER_NAME'
7675: , avalue => p_project_manager );
7676:
7677: wf_engine.SetItemAttrText
7678: ( itemtype => l_wf_item_type
7679: , itemkey => l_itemkey
7680: , aname => 'PROJECT_ORGANIZATION'
7681: , avalue => p_project_org );
7679: , itemkey => l_itemkey
7680: , aname => 'PROJECT_ORGANIZATION'
7681: , avalue => p_project_org );
7682:
7683: wf_engine.SetItemAttrText
7684: ( itemtype => l_wf_item_type
7685: , itemkey => l_itemkey
7686: , aname => 'PROJECT_CUSTOMER'
7687: , avalue => p_project_cus );
7685: , itemkey => l_itemkey
7686: , aname => 'PROJECT_CUSTOMER'
7687: , avalue => p_project_cus );
7688:
7689: wf_engine.SetItemAttrText
7690: ( itemtype => l_wf_item_type
7691: , itemkey => l_itemkey
7692: , aname => 'SUBMITTER_UNAME'
7693: , avalue => p_submitter_user_name);
7695: l_view_errors_url := 'JSP:/OA_HTML/OA.jsp?akRegionCode=PA_ERROR_LAYOUT&akRegionApplicationId=275&paProjectId='
7696: || p_project_id ||'&paSrcType1=MASS_ASSIGNMENT_TRANSACTION&paSrcType2=MASS_APPROVAL&paSrcId1=PAWFAAP&paSrcId2='
7697: || p_group_id || '&addBreadCrumb=RP' ;
7698:
7699: wf_engine.SetItemAttrText
7700: ( itemtype => l_wf_item_type
7701: , itemkey => l_itemkey
7702: , aname => 'VIEW_ERRORS_URL'
7703: , avalue => l_view_errors_url );
7704:
7705: log_message('Staring process for :' || l_wf_item_type || ':' || l_itemkey);
7706:
7707: --Start the workflow process
7708: wf_engine.StartProcess ( itemtype => l_wf_item_type
7709: ,itemkey => l_itemkey );
7710:
7711: PA_WORKFLOW_UTILS.Insert_WF_Processes
7712: (p_wf_type_code => 'MASS_ASSIGNMENT_APPROVAL'
7722: log_message('Out of submitter notification');
7723:
7724:
7725: --Setting the original value
7726: wf_engine.threshold := l_save_threshold;
7727:
7728: -- IF the number of messages is 1 then fetch the message code from
7729: -- the stack and return its text
7730: x_msg_count := FND_MSG_PUB.Count_Msg;
7750: x_return_status := FND_API.G_RET_STS_SUCCESS;
7751: WHEN OTHERS THEN
7752:
7753: --Setting the original value
7754: wf_engine.threshold := l_save_threshold;
7755:
7756: -- Set the excetption Message and the stack
7757: FND_MSG_PUB.add_exc_msg
7758: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_submitter_notification'
7781:
7782: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_approval_type');
7783:
7784: -- Return if WF Not Running
7785: IF (funcmode <> wf_engine.eng_run) THEN
7786: resultout := wf_engine.eng_null;
7787: RETURN;
7788: END IF;
7789:
7782: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_approval_type');
7783:
7784: -- Return if WF Not Running
7785: IF (funcmode <> wf_engine.eng_run) THEN
7786: resultout := wf_engine.eng_null;
7787: RETURN;
7788: END IF;
7789:
7790: l_approval_type := wf_engine.GetItemAttrText
7786: resultout := wf_engine.eng_null;
7787: RETURN;
7788: END IF;
7789:
7790: l_approval_type := wf_engine.GetItemAttrText
7791: (itemtype => itemtype,
7792: itemkey => itemkey,
7793: aname => 'APPROVAL_TYPE');
7794:
7793: aname => 'APPROVAL_TYPE');
7794:
7795: IF l_approval_type = PA_ASGMT_WFSTD.G_MASS_APPROVAL THEN
7796:
7797: resultout := wf_engine.eng_completed||':'||'M';
7798:
7799: ELSIF l_approval_type = PA_ASGMT_WFSTD.G_SINGLE_APPROVAL THEN
7800:
7801: resultout := wf_engine.eng_completed||':'||'S';
7797: resultout := wf_engine.eng_completed||':'||'M';
7798:
7799: ELSIF l_approval_type = PA_ASGMT_WFSTD.G_SINGLE_APPROVAL THEN
7800:
7801: resultout := wf_engine.eng_completed||':'||'S';
7802:
7803: END IF;
7804:
7805: pa_debug.reset_err_stack;
7812: itemtype,
7813: itemkey,
7814: to_char(actid),
7815: funcmode);
7816: resultout := wf_engine.eng_completed||':'||'S';
7817: RAISE;
7818:
7819: END Check_Approval_Type ;
7820:
7863: l_pending_txn_approvals pending_txn_approvals%ROWTYPE;
7864:
7865: BEGIN
7866:
7867: l_group_id := wf_engine.GetItemAttrNumber
7868: (itemtype => itemtype,
7869: itemkey => itemkey,
7870: aname => 'GROUP_ID');
7871:
7868: (itemtype => itemtype,
7869: itemkey => itemkey,
7870: aname => 'GROUP_ID');
7871:
7872: l_approver_group_id := wf_engine.GetItemAttrNumber
7873: (itemtype => itemtype,
7874: itemkey => itemkey,
7875: aname => 'APPROVER_GROUP_ID');
7876:
7873: (itemtype => itemtype,
7874: itemkey => itemkey,
7875: aname => 'APPROVER_GROUP_ID');
7876:
7877: l_routing_order := wf_engine.GetItemAttrNumber
7878: (itemtype => itemtype,
7879: itemkey => itemkey,
7880: aname => 'ROUTING_ORDER');
7881:
7879: itemkey => itemkey,
7880: aname => 'ROUTING_ORDER');
7881:
7882: -- added for bug 5488496
7883: l_ntfy_apprvl_recip_name := wf_engine.getItemAttrText
7884: (itemtype => itemtype,
7885: itemkey => itemkey,
7886: aname => 'NTFY_APPRVL_RECIPIENT_NAME');
7887:
7926: AND ntf.routing_order = l_routing_order
7927: AND ntf.object_id1 = asgn.assignment_id
7928: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
7929:
7930: l_project_id := wf_engine.getItemAttrNumber
7931: ( itemtype => itemtype
7932: , itemkey => itemkey
7933: , aname => 'PROJECT_ID' );
7934:
7931: ( itemtype => itemtype
7932: , itemkey => itemkey
7933: , aname => 'PROJECT_ID' );
7934:
7935: l_mode := wf_engine.getItemAttrText
7936: ( itemtype => itemtype
7937: , itemkey => itemkey
7938: , aname => 'MODE' );
7939:
7939:
7940: l_num_assignments := l_assignment_id_tbl.COUNT;
7941:
7942: --Get the Update Info document
7943: l_update_info_doc := wf_engine.getItemAttrDocument
7944: ( itemtype => itemtype
7945: , itemkey => itemkey
7946: , aname => 'UPDATED_INFO_DOC' );
7947:
7944: ( itemtype => itemtype
7945: , itemkey => itemkey
7946: , aname => 'UPDATED_INFO_DOC' );
7947:
7948: l_submitter_user_name := wf_engine.getItemAttrText
7949: ( itemtype => itemtype
7950: , itemkey => itemkey
7951: , aname => 'SUBMITTER_UNAME');
7952:
7949: ( itemtype => itemtype
7950: , itemkey => itemkey
7951: , aname => 'SUBMITTER_UNAME');
7952:
7953: l_conflict_group_id := wf_engine.getItemAttrNumber
7954: ( itemtype => itemtype
7955: , itemkey => itemkey
7956: , aname => 'CONFLICT_GROUP_ID' );
7957:
7954: ( itemtype => itemtype
7955: , itemkey => itemkey
7956: , aname => 'CONFLICT_GROUP_ID' );
7957:
7958: l_forwarded_from := wf_engine.getItemAttrText
7959: ( itemtype => itemtype
7960: , itemkey => itemkey
7961: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
7962:
7959: ( itemtype => itemtype
7960: , itemkey => itemkey
7961: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
7962:
7963: l_note_to_approvers := wf_engine.getItemAttrText
7964: ( itemtype => itemtype
7965: , itemkey => itemkey
7966: , aname => 'NOTE_TO_APPROVER');
7967:
8010: log_message('Inside Set_Submitter_User_Name');
8011:
8012:
8013: --get the following wf attributes for the process that errored out.
8014: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8015: itemkey => p_item_key,
8016: aname => 'ERROR_ITEM_TYPE');
8017:
8018: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8014: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8015: itemkey => p_item_key,
8016: aname => 'ERROR_ITEM_TYPE');
8017:
8018: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8019: itemkey => p_item_key,
8020: aname => 'ERROR_ITEM_KEY');
8021:
8022: l_submitter_user_name := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8018: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8019: itemkey => p_item_key,
8020: aname => 'ERROR_ITEM_KEY');
8021:
8022: l_submitter_user_name := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8023: itemkey => l_error_item_key,
8024: aname => 'SUBMITTER_UNAME');
8025:
8026: --SET the Text item attributes (these attributes were created at design time)
8023: itemkey => l_error_item_key,
8024: aname => 'SUBMITTER_UNAME');
8025:
8026: --SET the Text item attributes (these attributes were created at design time)
8027: WF_ENGINE.SetItemAttrText(itemtype => p_item_type,
8028: itemkey => p_item_key,
8029: aname => 'SUBMITTER_UNAME',
8030: avalue => l_submitter_user_name);
8031:
8069: --but we commit 1 at a time, so some of the transactions
8070: --may be complete - so we are only aborting the ones that are not yet processed.
8071:
8072: --get the following wf attributes for the process that errored out.
8073: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8074: itemkey => p_item_key,
8075: aname => 'ERROR_ITEM_TYPE');
8076:
8077: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8073: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8074: itemkey => p_item_key,
8075: aname => 'ERROR_ITEM_TYPE');
8076:
8077: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8078: itemkey => p_item_key,
8079: aname => 'ERROR_ITEM_KEY');
8080:
8081: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8077: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8078: itemkey => p_item_key,
8079: aname => 'ERROR_ITEM_KEY');
8080:
8081: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8082: itemkey => l_error_item_key,
8083: aname => 'PROJECT_ID');
8084:
8085: l_submitter_uname := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8081: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8082: itemkey => l_error_item_key,
8083: aname => 'PROJECT_ID');
8084:
8085: l_submitter_uname := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8086: itemkey => l_error_item_key,
8087: aname => 'SUBMITTER_UNAME');
8088:
8089: l_group_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8085: l_submitter_uname := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8086: itemkey => l_error_item_key,
8087: aname => 'SUBMITTER_UNAME');
8088:
8089: l_group_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8090: itemkey => l_error_item_key,
8091: aname => 'GROUP_ID');
8092:
8093: SELECT ntf.object_id1