[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
2157: l_user_exists BOOLEAN := FALSE; -- Bug#11769582
2158: BEGIN
2159: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_Approvers');
2160: -- Return if WF Not Running
2161: IF (funcmode <> wf_engine.eng_run) THEN
2162: resultout := wf_engine.eng_null;
2163: RETURN;
2164: END IF;
2165: NULL;
2158: BEGIN
2159: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_Approvers');
2160: -- Return if WF Not Running
2161: IF (funcmode <> wf_engine.eng_run) THEN
2162: resultout := wf_engine.eng_null;
2163: RETURN;
2164: END IF;
2165: NULL;
2166: l_assignment_id := wf_engine.GetItemAttrNumber
2162: resultout := wf_engine.eng_null;
2163: RETURN;
2164: END IF;
2165: NULL;
2166: l_assignment_id := wf_engine.GetItemAttrNumber
2167: (itemtype => itemtype,
2168: itemkey => itemkey,
2169: aname => 'ASSIGNMENT_ID');
2170: l_project_id := wf_engine.GetItemAttrNumber
2166: l_assignment_id := wf_engine.GetItemAttrNumber
2167: (itemtype => itemtype,
2168: itemkey => itemkey,
2169: aname => 'ASSIGNMENT_ID');
2170: l_project_id := wf_engine.GetItemAttrNumber
2171: (itemtype => itemtype,
2172: itemkey => itemkey,
2173: aname => 'PROJECT_ID' );
2174: -- Now populate the PL/SQL table with the 2 approvers
2176: FOR i IN 1..2
2177: LOOP
2178: l_item_attr_name := 'APPROVER_'||i||'_PERSON_ID';
2179: l_approver_person_id :=
2180: wf_engine.GetItemAttrNumber
2181: ( itemtype => itemtype
2182: , itemkey => itemkey
2183: , aname => l_item_attr_name
2184: );
2183: , aname => l_item_attr_name
2184: );
2185:
2186: l_item_attr_name := 'APPROVER'||i||'_USER_NAME';
2187: l_approver_user_name := wf_engine.GetItemAttrText
2188: ( itemtype => itemtype
2189: , itemkey => itemkey
2190: , aname => l_item_attr_name
2191: );
2189: , itemkey => itemkey
2190: , aname => l_item_attr_name
2191: );
2192: l_item_attr_name := 'APPROVER_'||i||'_TYPE';
2193: l_approver_type := wf_engine.GetItemAttrText
2194: ( itemtype => itemtype
2195: , itemkey => itemkey
2196: , aname => l_item_attr_name
2197: );
2233: ,p_current_approver_flag => 'N'
2234: ,x_number_of_performers => l_number_of_approvers );
2235:
2236: -- Now set the number of approvers
2237: wf_engine.SetItemAttrNumber
2238: ( itemtype => itemtype
2239: , itemkey => itemkey
2240: , aname => 'NUMBER_OF_APPROVERS'
2241: , avalue => l_number_of_approvers
2281: Resultout = 'S'
2282: */
2283: -- Return if WF Not Running
2284: pa_debug.init_err_stack ('pa_asgmt_wfstd.get_approver');
2285: IF (funcmode <> wf_engine.eng_run) THEN
2286: resultout := wf_engine.eng_null;
2287: RETURN;
2288: END IF;
2289: l_number_of_approvers := wf_engine.GetItemAttrNumber
2282: */
2283: -- Return if WF Not Running
2284: pa_debug.init_err_stack ('pa_asgmt_wfstd.get_approver');
2285: IF (funcmode <> wf_engine.eng_run) THEN
2286: resultout := wf_engine.eng_null;
2287: RETURN;
2288: END IF;
2289: l_number_of_approvers := wf_engine.GetItemAttrNumber
2290: ( itemtype => itemtype
2285: IF (funcmode <> wf_engine.eng_run) THEN
2286: resultout := wf_engine.eng_null;
2287: RETURN;
2288: END IF;
2289: l_number_of_approvers := wf_engine.GetItemAttrNumber
2290: ( itemtype => itemtype
2291: , itemkey => itemkey
2292: , aname => 'NUMBER_OF_APPROVERS'
2293: );
2290: ( itemtype => itemtype
2291: , itemkey => itemkey
2292: , aname => 'NUMBER_OF_APPROVERS'
2293: );
2294: l_approver_loop_counter := wf_engine.getItemAttrNumber
2295: ( itemtype => itemtype
2296: , itemkey => itemkey
2297: , aname => 'APPROVER_LOOP_COUNTER'
2298: );
2295: ( itemtype => itemtype
2296: , itemkey => itemkey
2297: , aname => 'APPROVER_LOOP_COUNTER'
2298: );
2299: l_assignment_id := wf_engine.GetItemAttrNumber
2300: (itemtype => itemtype,
2301: itemkey => itemkey,
2302: aname => 'ASSIGNMENT_ID');
2303:
2302: aname => 'ASSIGNMENT_ID');
2303:
2304: l_approver_loop_counter := l_approver_loop_counter + 1;
2305: IF l_approver_loop_counter > l_number_of_approvers THEN
2306: resultout := wf_engine.eng_completed||':'||'F';
2307: RETURN ;
2308: END IF;
2309: get_wf_performer (p_wf_type_code => 'ASSIGNMENT_APPROVAL'
2310: ,p_item_type => itemtype
2314: ,x_performer_name => l_approver_user_name
2315: ,x_performer_type => l_approver_type );
2316:
2317: IF l_approver_user_name IS NULL THEN
2318: resultout := wf_engine.eng_completed||':'||'F';
2319: RETURN ;
2320: END IF;
2321: -- In order to set the forwarded from, capture the current
2322: -- approver before modifying the same
2323: -- Set the current approver as the previous approver
2324: -- Handling a NULL previous approver (which is likely when
2325: -- the current approver is the first approver) is done
2326: -- in the Set forwarded from procedure
2327: l_prev_approver_user_name := wf_engine.GetItemAttrText
2328: ( itemtype => itemtype
2329: , itemkey => itemkey
2330: , aname => 'APPROVER_UNAME'
2331: );
2328: ( itemtype => itemtype
2329: , itemkey => itemkey
2330: , aname => 'APPROVER_UNAME'
2331: );
2332: wf_engine.SetItemAttrText
2333: ( itemtype => itemtype
2334: , itemkey => itemkey
2335: , aname => 'PREV_APPROVER_UNAME'
2336: , avalue => l_prev_approver_user_name
2334: , itemkey => itemkey
2335: , aname => 'PREV_APPROVER_UNAME'
2336: , avalue => l_prev_approver_user_name
2337: );
2338: wf_engine.SetItemAttrText
2339: ( itemtype => itemtype
2340: , itemkey => itemkey
2341: , aname => 'APPROVER_UNAME'
2342: , avalue => l_approver_user_name
2340: , itemkey => itemkey
2341: , aname => 'APPROVER_UNAME'
2342: , avalue => l_approver_user_name
2343: );
2344: wf_engine.SetItemAttrNumber
2345: ( itemtype => itemtype
2346: , itemkey => itemkey
2347: , aname => 'APPROVER_LOOP_COUNTER'
2348: , avalue => l_approver_loop_counter
2349: );
2350:
2351: /*Added the code for the bug 3595857*/
2352: IF l_approver_loop_counter = 1 THEN
2353: l_wf_startedby_uname := wf_engine.GetItemAttrText
2354: ( itemtype => itemtype
2355: , itemkey => itemkey
2356: , aname => 'WORKFLOW_STARTED_BY_UNAME'
2357: );
2355: , itemkey => itemkey
2356: , aname => 'WORKFLOW_STARTED_BY_UNAME'
2357: );
2358:
2359: wf_engine.SetItemAttrText
2360: ( itemtype => itemtype
2361: , itemkey => itemkey
2362: , aname => 'FROM_ROLE_VALUE'
2363: , avalue => l_wf_startedby_uname
2362: , aname => 'FROM_ROLE_VALUE'
2363: , avalue => l_wf_startedby_uname
2364: );
2365: ELSE
2366: wf_engine.SetItemAttrText
2367: ( itemtype => itemtype
2368: , itemkey => itemkey
2369: , aname => 'FROM_ROLE_VALUE'
2370: , avalue => l_prev_approver_user_name
2380: (DECODE(user_name,l_approver_user_name,'Y','N'))
2381: WHERE item_type = itemtype
2382: AND item_key = itemkey
2383: AND object_id1 = l_assignment_id;
2384: resultout := wf_engine.eng_completed||':'||'S';
2385: pa_debug.reset_err_stack;
2386: EXCEPTION
2387: WHEN OTHERS THEN
2388: WF_CORE.CONTEXT
2427: -- appropriate client extensions will be called
2428:
2429: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_apprvl_nf_recipients');
2430: -- Return if WF Not Running
2431: IF (funcmode <> wf_engine.eng_run) THEN
2432: resultout := wf_engine.eng_null;
2433: RETURN;
2434: END IF;
2435: l_assignment_id := wf_engine.GetItemAttrNumber
2428:
2429: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_apprvl_nf_recipients');
2430: -- Return if WF Not Running
2431: IF (funcmode <> wf_engine.eng_run) THEN
2432: resultout := wf_engine.eng_null;
2433: RETURN;
2434: END IF;
2435: l_assignment_id := wf_engine.GetItemAttrNumber
2436: (itemtype => itemtype,
2431: IF (funcmode <> wf_engine.eng_run) THEN
2432: resultout := wf_engine.eng_null;
2433: RETURN;
2434: END IF;
2435: l_assignment_id := wf_engine.GetItemAttrNumber
2436: (itemtype => itemtype,
2437: itemkey => itemkey,
2438: aname => 'ASSIGNMENT_ID');
2439: l_project_id := wf_engine.GetItemAttrNumber
2435: l_assignment_id := wf_engine.GetItemAttrNumber
2436: (itemtype => itemtype,
2437: itemkey => itemkey,
2438: aname => 'ASSIGNMENT_ID');
2439: l_project_id := wf_engine.GetItemAttrNumber
2440: (itemtype => itemtype,
2441: itemkey => itemkey,
2442: aname => 'PROJECT_ID' );
2443: -- Now populate the PL/SQL table with the 4 recipients
2441: itemkey => itemkey,
2442: aname => 'PROJECT_ID' );
2443: -- Now populate the PL/SQL table with the 4 recipients
2444: -- which are done by the product by default
2445: l_number_of_apprvl_nf_rects := wf_engine.GetItemAttrNumber
2446: ( itemtype => itemtype
2447: , itemkey => itemkey
2448: , aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
2449: );
2447: , itemkey => itemkey
2448: , aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
2449: );
2450:
2451: l_apprvl_item_type := wf_engine.getItemAttrText
2452: ( itemtype => itemtype
2453: , itemkey => itemkey
2454: , aname => 'APPRVL_ITEM_TYPE' );
2455:
2452: ( itemtype => itemtype
2453: , itemkey => itemkey
2454: , aname => 'APPRVL_ITEM_TYPE' );
2455:
2456: l_apprvl_item_key := wf_engine.getItemAttrText
2457: ( itemtype => itemtype
2458: , itemkey => itemkey
2459: , aname => 'APPRVL_ITEM_KEY');
2460:
2460:
2461: FOR i IN 1..l_number_of_apprvl_nf_rects LOOP
2462: l_ntfy_rect_item_attr_name :=
2463: 'APPROVAL_NF_REC'||i||'_USER_NAME';
2464: l_ntfy_apprvl_recipient_name := wf_engine.getItemAttrText
2465: ( itemtype => itemtype
2466: , itemkey => itemkey
2467: , aname => l_ntfy_rect_item_attr_name
2468: );
2467: , aname => l_ntfy_rect_item_attr_name
2468: );
2469: l_ntfy_rect_item_attr_name :=
2470: 'APPROVAL_NF_REC'||i||'_USER_TYPE';
2471: l_ntfy_apprvl_rect_type := wf_engine.getItemAttrText
2472: ( itemtype => itemtype
2473: , itemkey => itemkey
2474: , aname => l_ntfy_rect_item_attr_name
2475: );
2474: , aname => l_ntfy_rect_item_attr_name
2475: );
2476: l_ntfy_rect_item_attr_name :=
2477: 'APPROVAL_NF_REC'||i||'_PERSON_ID';
2478: l_ntfy_apprvl_rect_person_id := wf_engine.getItemAttrNumber
2479: ( itemtype => itemtype
2480: , itemkey => itemkey
2481: , aname => l_ntfy_rect_item_attr_name
2482: );
2513:
2514: -- Now set the number of approvl nf recipients based
2515: -- on how many records were inserted
2516:
2517: wf_engine.SetItemAttrNumber
2518: (itemtype => itemtype
2519: ,itemkey => itemkey
2520: ,aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
2521: ,avalue => l_number_of_recipients
2571: Set loop counter
2572: Resultout = 'T'
2573: */
2574: -- Return if WF Not Running
2575: IF (funcmode <> wf_engine.eng_run) THEN
2576: resultout := wf_engine.eng_null;
2577: RETURN;
2578: END IF;
2579: l_number_of_apprvl_nf_rects := wf_engine.GetItemAttrNumber
2572: Resultout = 'T'
2573: */
2574: -- Return if WF Not Running
2575: IF (funcmode <> wf_engine.eng_run) THEN
2576: resultout := wf_engine.eng_null;
2577: RETURN;
2578: END IF;
2579: l_number_of_apprvl_nf_rects := wf_engine.GetItemAttrNumber
2580: ( itemtype => itemtype
2575: IF (funcmode <> wf_engine.eng_run) THEN
2576: resultout := wf_engine.eng_null;
2577: RETURN;
2578: END IF;
2579: l_number_of_apprvl_nf_rects := wf_engine.GetItemAttrNumber
2580: ( itemtype => itemtype
2581: , itemkey => itemkey
2582: , aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
2583: );
2580: ( itemtype => itemtype
2581: , itemkey => itemkey
2582: , aname => 'NUMBER_OF_APPRVL_NF_RECIPIENTS'
2583: );
2584: l_approval_nf_loop_counter := wf_engine.getItemAttrNumber
2585: ( itemtype => itemtype
2586: , itemkey => itemkey
2587: , aname => 'APPROVAL_NF_LOOP_COUNTER'
2588: );
2585: ( itemtype => itemtype
2586: , itemkey => itemkey
2587: , aname => 'APPROVAL_NF_LOOP_COUNTER'
2588: );
2589: l_assignment_id := wf_engine.getItemAttrNumber
2590: ( itemtype => itemtype
2591: , itemkey => itemkey
2592: , aname => 'ASSIGNMENT_ID'
2593: );
2592: , aname => 'ASSIGNMENT_ID'
2593: );
2594: l_approval_nf_loop_counter := l_approval_nf_loop_counter + 1;
2595: IF l_approval_nf_loop_counter > l_number_of_apprvl_nf_rects THEN
2596: resultout := wf_engine.eng_completed||':'||'F';
2597: RETURN;
2598: END IF;
2599: get_wf_performer (p_wf_type_code => 'APPROVAL_FYI'
2600: ,p_item_type => itemtype
2602: ,p_routing_order => l_approval_nf_loop_counter
2603: ,p_object_id1 => l_assignment_id
2604: ,x_performer_name =>l_ntfy_apprvl_recipient_name
2605: ,x_performer_type =>l_ntfy_apprvl_rect_type );
2606: wf_engine.SetItemAttrText
2607: ( itemtype => itemtype
2608: , itemkey => itemkey
2609: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
2610: , avalue => l_ntfy_apprvl_recipient_name
2608: , itemkey => itemkey
2609: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
2610: , avalue => l_ntfy_apprvl_recipient_name
2611: );
2612: wf_engine.SetItemAttrNumber
2613: ( itemtype => itemtype
2614: , itemkey => itemkey
2615: , aname => 'APPROVAL_NF_LOOP_COUNTER'
2616: , avalue => l_approval_nf_loop_counter
2623: p_item_key => itemkey ,
2624: p_rect_type =>
2625: l_ntfy_apprvl_rect_type );
2626:
2627: resultout := wf_engine.eng_completed||':'||'S';
2628: EXCEPTION
2629: WHEN OTHERS THEN
2630: WF_CORE.CONTEXT
2631: ('PA_ASGMT_WFSTD',
2665: l_counter NUMBER := 0; -- local variable Bug #11841318
2666:
2667: BEGIN
2668: -- Return if WF Not Running
2669: IF (funcmode <> wf_engine.eng_run) THEN
2670: resultout := wf_engine.eng_null;
2671: RETURN;
2672: END IF;
2673: l_assignment_id := wf_engine.GetItemAttrNumber
2666:
2667: BEGIN
2668: -- Return if WF Not Running
2669: IF (funcmode <> wf_engine.eng_run) THEN
2670: resultout := wf_engine.eng_null;
2671: RETURN;
2672: END IF;
2673: l_assignment_id := wf_engine.GetItemAttrNumber
2674: (itemtype => itemtype,
2669: IF (funcmode <> wf_engine.eng_run) THEN
2670: resultout := wf_engine.eng_null;
2671: RETURN;
2672: END IF;
2673: l_assignment_id := wf_engine.GetItemAttrNumber
2674: (itemtype => itemtype,
2675: itemkey => itemkey,
2676: aname => 'ASSIGNMENT_ID');
2677: l_project_id := wf_engine.GetItemAttrNumber
2673: l_assignment_id := wf_engine.GetItemAttrNumber
2674: (itemtype => itemtype,
2675: itemkey => itemkey,
2676: aname => 'ASSIGNMENT_ID');
2677: l_project_id := wf_engine.GetItemAttrNumber
2678: (itemtype => itemtype,
2679: itemkey => itemkey,
2680: aname => 'PROJECT_ID' );
2681: -- Now populate the PL/SQL table with the 4 recipients
2679: itemkey => itemkey,
2680: aname => 'PROJECT_ID' );
2681: -- Now populate the PL/SQL table with the 4 recipients
2682: -- which are done by the product by default
2683: l_number_of_reject_nf_rects := wf_engine.GetItemAttrNumber
2684: ( itemtype => itemtype
2685: , itemkey => itemkey
2686: , aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
2687: );
2685: , itemkey => itemkey
2686: , aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
2687: );
2688:
2689: l_apprvl_item_type := wf_engine.getItemAttrText
2690: ( itemtype => itemtype
2691: , itemkey => itemkey
2692: , aname => 'APPRVL_ITEM_TYPE' );
2693:
2690: ( itemtype => itemtype
2691: , itemkey => itemkey
2692: , aname => 'APPRVL_ITEM_TYPE' );
2693:
2694: l_apprvl_item_key := wf_engine.getItemAttrText
2695: ( itemtype => itemtype
2696: , itemkey => itemkey
2697: , aname => 'APPRVL_ITEM_KEY');
2698:
2699: FOR i IN 1..l_number_of_reject_nf_rects
2700: LOOP
2701: l_ntfy_rect_item_attr_name :=
2702: 'REJECT_NF_REC'||i||'_USER_NAME';
2703: l_ntfy_reject_recipient_name := wf_engine.getItemAttrText
2704: ( itemtype => itemtype
2705: , itemkey => itemkey
2706: , aname => l_ntfy_rect_item_attr_name
2707: );
2706: , aname => l_ntfy_rect_item_attr_name
2707: );
2708: l_ntfy_rect_item_attr_name :=
2709: 'REJECT_NF_REC'||i||'_USER_TYPE';
2710: l_ntfy_reject_rect_type := wf_engine.getItemAttrText
2711: ( itemtype => itemtype
2712: , itemkey => itemkey
2713: , aname => l_ntfy_rect_item_attr_name
2714: );
2713: , aname => l_ntfy_rect_item_attr_name
2714: );
2715: l_ntfy_rect_item_attr_name :=
2716: 'REJECT_NF_REC'||i||'_PERSON_ID';
2717: l_ntfy_reject_rect_person_id := wf_engine.getItemAttrNumber
2718: ( itemtype => itemtype
2719: , itemkey => itemkey
2720: , aname => l_ntfy_rect_item_attr_name
2721: );
2754:
2755: -- Now set the number of reject nf recipients based
2756: -- on how many records were inserted
2757:
2758: wf_engine.SetItemAttrNumber
2759: (itemtype => itemtype
2760: ,itemkey => itemkey
2761: ,aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
2762: ,avalue => l_number_of_recipients
2811: Set loop counter
2812: Resultout = 'T'
2813: */
2814: -- Return if WF Not Running
2815: IF (funcmode <> wf_engine.eng_run) THEN
2816: resultout := wf_engine.eng_null;
2817: RETURN;
2818: END IF;
2819: l_number_of_reject_nf_rects := wf_engine.GetItemAttrNumber
2812: Resultout = 'T'
2813: */
2814: -- Return if WF Not Running
2815: IF (funcmode <> wf_engine.eng_run) THEN
2816: resultout := wf_engine.eng_null;
2817: RETURN;
2818: END IF;
2819: l_number_of_reject_nf_rects := wf_engine.GetItemAttrNumber
2820: ( itemtype => itemtype
2815: IF (funcmode <> wf_engine.eng_run) THEN
2816: resultout := wf_engine.eng_null;
2817: RETURN;
2818: END IF;
2819: l_number_of_reject_nf_rects := wf_engine.GetItemAttrNumber
2820: ( itemtype => itemtype
2821: , itemkey => itemkey
2822: , aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
2823: );
2820: ( itemtype => itemtype
2821: , itemkey => itemkey
2822: , aname => 'NUMBER_OF_REJECT_NF_RECIPIENTS'
2823: );
2824: l_rejection_nf_loop_counter := wf_engine.getItemAttrNumber
2825: ( itemtype => itemtype
2826: , itemkey => itemkey
2827: , aname => 'REJECTION_NF_LOOP_COUNTER'
2828: );
2826: , itemkey => itemkey
2827: , aname => 'REJECTION_NF_LOOP_COUNTER'
2828: );
2829:
2830: l_assignment_id := wf_engine.getItemAttrNumber
2831: ( itemtype => itemtype
2832: , itemkey => itemkey
2833: , aname => 'ASSIGNMENT_ID'
2834: );
2833: , aname => 'ASSIGNMENT_ID'
2834: );
2835: l_rejection_nf_loop_counter := l_rejection_nf_loop_counter + 1;
2836: IF l_rejection_nf_loop_counter > l_number_of_reject_nf_rects THEN
2837: resultout := wf_engine.eng_completed||':'||'F';
2838: RETURN;
2839: END IF;
2840: get_wf_performer (p_wf_type_code => 'REJECTION_FYI'
2841: ,p_item_type => itemtype
2843: ,p_routing_order => l_rejection_nf_loop_counter
2844: ,p_object_id1 => l_assignment_id
2845: ,x_performer_name =>l_ntfy_reject_recipient_name
2846: ,x_performer_type =>l_ntfy_reject_rect_type );
2847: wf_engine.SetItemAttrText
2848: ( itemtype => itemtype
2849: , itemkey => itemkey
2850: , aname => 'NTFY_REJECT_RECIPIENT_NAME'
2851: , avalue => l_ntfy_reject_recipient_name
2849: , itemkey => itemkey
2850: , aname => 'NTFY_REJECT_RECIPIENT_NAME'
2851: , avalue => l_ntfy_reject_recipient_name
2852: );
2853: wf_engine.SetItemAttrNumber
2854: ( itemtype => itemtype
2855: , itemkey => itemkey
2856: , aname => 'REJECTION_NF_LOOP_COUNTER'
2857: , avalue => l_rejection_nf_loop_counter
2863: Set_Comment_Attributes (p_item_type => itemtype,
2864: p_item_key => itemkey ,
2865: p_rect_type =>
2866: l_ntfy_reject_rect_type );
2867: resultout := wf_engine.eng_completed||':'||'S';
2868: EXCEPTION
2869: WHEN OTHERS THEN
2870: WF_CORE.CONTEXT
2871: ('PA_ASGMT_WFSTD',
2908: l_counter NUMBER := 0; -- local variable for bug 7511389
2909:
2910: BEGIN
2911: -- Return if WF Not Running
2912: IF (funcmode <> wf_engine.eng_run) THEN
2913: resultout := wf_engine.eng_null;
2914: RETURN;
2915: END IF;
2916: l_assignment_id := wf_engine.GetItemAttrNumber
2909:
2910: BEGIN
2911: -- Return if WF Not Running
2912: IF (funcmode <> wf_engine.eng_run) THEN
2913: resultout := wf_engine.eng_null;
2914: RETURN;
2915: END IF;
2916: l_assignment_id := wf_engine.GetItemAttrNumber
2917: (itemtype => itemtype,
2912: IF (funcmode <> wf_engine.eng_run) THEN
2913: resultout := wf_engine.eng_null;
2914: RETURN;
2915: END IF;
2916: l_assignment_id := wf_engine.GetItemAttrNumber
2917: (itemtype => itemtype,
2918: itemkey => itemkey,
2919: aname => 'ASSIGNMENT_ID');
2920: l_project_id := wf_engine.GetItemAttrNumber
2916: l_assignment_id := wf_engine.GetItemAttrNumber
2917: (itemtype => itemtype,
2918: itemkey => itemkey,
2919: aname => 'ASSIGNMENT_ID');
2920: l_project_id := wf_engine.GetItemAttrNumber
2921: (itemtype => itemtype,
2922: itemkey => itemkey,
2923: aname => 'PROJECT_ID' );
2924: -- Now populate the PL/SQL table with the 4 recipients
2922: itemkey => itemkey,
2923: aname => 'PROJECT_ID' );
2924: -- Now populate the PL/SQL table with the 4 recipients
2925: -- which are done by the product by default
2926: l_number_of_cancel_nf_rects := wf_engine.GetItemAttrNumber
2927: ( itemtype => itemtype
2928: , itemkey => itemkey
2929: , aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
2930: );
2928: , itemkey => itemkey
2929: , aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
2930: );
2931:
2932: l_apprvl_item_type := wf_engine.getItemAttrText
2933: ( itemtype => itemtype
2934: , itemkey => itemkey
2935: , aname => 'APPRVL_ITEM_TYPE' );
2936:
2933: ( itemtype => itemtype
2934: , itemkey => itemkey
2935: , aname => 'APPRVL_ITEM_TYPE' );
2936:
2937: l_apprvl_item_key := wf_engine.getItemAttrText
2938: ( itemtype => itemtype
2939: , itemkey => itemkey
2940: , aname => 'APPRVL_ITEM_KEY');
2941:
2942: FOR i IN 1..l_number_of_cancel_nf_rects
2943: LOOP
2944: l_ntfy_rect_item_attr_name :=
2945: 'CANCEL_NF_REC'||i||'_USER_NAME';
2946: l_ntfy_cancel_recipient_name := wf_engine.getItemAttrText
2947: ( itemtype => itemtype
2948: , itemkey => itemkey
2949: , aname => l_ntfy_rect_item_attr_name
2950: );
2949: , aname => l_ntfy_rect_item_attr_name
2950: );
2951: l_ntfy_rect_item_attr_name :=
2952: 'CANCEL_NF_REC'||i||'_USER_TYPE';
2953: l_ntfy_cancel_rect_type := wf_engine.getItemAttrText
2954: ( itemtype => itemtype
2955: , itemkey => itemkey
2956: , aname => l_ntfy_rect_item_attr_name
2957: );
2956: , aname => l_ntfy_rect_item_attr_name
2957: );
2958: l_ntfy_rect_item_attr_name :=
2959: 'CANCEL_NF_REC'||i||'_PERSON_ID';
2960: l_ntfy_cancel_rect_person_id := wf_engine.getItemAttrNumber
2961: ( itemtype => itemtype
2962: , itemkey => itemkey
2963: , aname => l_ntfy_rect_item_attr_name
2964: );
3003:
3004: -- Now set the number of cancel nf recipients based
3005: -- on how many records were inserted
3006:
3007: wf_engine.SetItemAttrNumber
3008: (itemtype => itemtype
3009: ,itemkey => itemkey
3010: ,aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
3011: ,avalue => l_number_of_recipients
3061: Set loop counter
3062: Resultout = 'T'
3063: */
3064: -- Return if WF Not Running
3065: IF (funcmode <> wf_engine.eng_run) THEN
3066: resultout := wf_engine.eng_null;
3067: RETURN;
3068: END IF;
3069: l_number_of_cancel_nf_rects := wf_engine.GetItemAttrNumber
3062: Resultout = 'T'
3063: */
3064: -- Return if WF Not Running
3065: IF (funcmode <> wf_engine.eng_run) THEN
3066: resultout := wf_engine.eng_null;
3067: RETURN;
3068: END IF;
3069: l_number_of_cancel_nf_rects := wf_engine.GetItemAttrNumber
3070: ( itemtype => itemtype
3065: IF (funcmode <> wf_engine.eng_run) THEN
3066: resultout := wf_engine.eng_null;
3067: RETURN;
3068: END IF;
3069: l_number_of_cancel_nf_rects := wf_engine.GetItemAttrNumber
3070: ( itemtype => itemtype
3071: , itemkey => itemkey
3072: , aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
3073: );
3070: ( itemtype => itemtype
3071: , itemkey => itemkey
3072: , aname => 'NUMBER_OF_CANCEL_NF_RECIPIENTS'
3073: );
3074: l_cancellation_nf_loop_counter := wf_engine.getItemAttrNumber
3075: ( itemtype => itemtype
3076: , itemkey => itemkey
3077: , aname => 'CANCELLATION_NF_LOOP_COUNTER'
3078: );
3076: , itemkey => itemkey
3077: , aname => 'CANCELLATION_NF_LOOP_COUNTER'
3078: );
3079:
3080: l_assignment_id := wf_engine.getItemAttrNumber
3081: ( itemtype => itemtype
3082: , itemkey => itemkey
3083: , aname => 'ASSIGNMENT_ID'
3084: );
3083: , aname => 'ASSIGNMENT_ID'
3084: );
3085: l_cancellation_nf_loop_counter := l_cancellation_nf_loop_counter + 1;
3086: IF l_cancellation_nf_loop_counter > l_number_of_cancel_nf_rects THEN
3087: resultout := wf_engine.eng_completed||':'||'F';
3088: RETURN;
3089: END IF;
3090: get_wf_performer (p_wf_type_code => 'CANCELLATION_FYI'
3091: ,p_item_type => itemtype
3093: ,p_routing_order => l_cancellation_nf_loop_counter
3094: ,p_object_id1 => l_assignment_id
3095: ,x_performer_name =>l_ntfy_cancel_recipient_name
3096: ,x_performer_type =>l_ntfy_cancel_rect_type );
3097: wf_engine.SetItemAttrText
3098: ( itemtype => itemtype
3099: , itemkey => itemkey
3100: , aname => 'NTFY_CANCEL_RECIPIENT_NAME'
3101: , avalue => l_ntfy_cancel_recipient_name
3099: , itemkey => itemkey
3100: , aname => 'NTFY_CANCEL_RECIPIENT_NAME'
3101: , avalue => l_ntfy_cancel_recipient_name
3102: );
3103: wf_engine.SetItemAttrNumber
3104: ( itemtype => itemtype
3105: , itemkey => itemkey
3106: , aname => 'CANCELLATION_NF_LOOP_COUNTER'
3107: , avalue => l_cancellation_nf_loop_counter
3113: Set_Comment_Attributes (p_item_type => itemtype,
3114: p_item_key => itemkey ,
3115: p_rect_type =>
3116: l_ntfy_cancel_rect_type );
3117: resultout := wf_engine.eng_completed||':'||'S';
3118: EXCEPTION
3119: WHEN OTHERS THEN
3120: WF_CORE.CONTEXT
3121: ('PA_ASGMT_WFSTD',
3137: l_forwarded_from wf_users.name%type; ----- VARCHAR2(240); Changed for bug 3267790
3138: BEGIN
3139:
3140: -- Return if WF Not Running
3141: IF (funcmode <> wf_engine.eng_run) THEN
3142: resultout := wf_engine.eng_null;
3143: RETURN;
3144: END IF;
3145: -- The approval notification would have been forwarded
3138: BEGIN
3139:
3140: -- Return if WF Not Running
3141: IF (funcmode <> wf_engine.eng_run) THEN
3142: resultout := wf_engine.eng_null;
3143: RETURN;
3144: END IF;
3145: -- The approval notification would have been forwarded
3146: -- from either the initial submittor or the last approver
3147: -- Prev Approver uname is set only in get approver node
3148: -- Hence, if that value is not set, get the value
3149: -- from workflow started by uname attribute, which
3150: -- is always set at the time of starting the workflow
3151: l_forwarded_from := wf_engine.GetItemAttrText
3152: ( itemtype => itemtype
3153: , itemkey => itemkey
3154: , aname => 'PREV_APPROVER_UNAME'
3155: );
3153: , itemkey => itemkey
3154: , aname => 'PREV_APPROVER_UNAME'
3155: );
3156: IF l_forwarded_from IS NULL THEN
3157: l_forwarded_from := wf_engine.GetItemAttrText
3158: ( itemtype => itemtype
3159: , itemkey => itemkey
3160: , aname => 'WORKFLOW_STARTED_BY_UNAME'
3161: );
3160: , aname => 'WORKFLOW_STARTED_BY_UNAME'
3161: );
3162: END IF;
3163: -- Now set the forwarded from field
3164: wf_engine.SetItemAttrText
3165: ( itemtype => itemtype
3166: , itemkey => itemkey
3167: , aname => 'FORWARDED_FROM'
3168: , avalue => l_forwarded_from
3187: IS
3188: l_assignment_type pa_project_assignments.assignment_type%TYPE;
3189: l_reapproval_flag VARCHAR2(1);
3190: BEGIN
3191: IF (funcmode <> wf_engine.eng_run) THEN
3192: resultout := wf_engine.eng_null;
3193: RETURN;
3194: END IF;
3195: -- Check whether the assignment is work or admin assignment
3188: l_assignment_type pa_project_assignments.assignment_type%TYPE;
3189: l_reapproval_flag VARCHAR2(1);
3190: BEGIN
3191: IF (funcmode <> wf_engine.eng_run) THEN
3192: resultout := wf_engine.eng_null;
3193: RETURN;
3194: END IF;
3195: -- Check whether the assignment is work or admin assignment
3196: -- If work assignment check whether this is a reapproval
3196: -- If work assignment check whether this is a reapproval
3197: -- Accordingly set the attributes for MSG_SUBJECT and MSG_DESCRIPTION
3198: -- All this is done in the Set_NF_Subject_and_Desc procedure
3199:
3200: l_assignment_type := wf_engine.GetItemAttrText
3201: (itemtype => itemtype,
3202: itemkey => itemkey,
3203: aname => 'ASSIGNMENT_TYPE');
3204:
3201: (itemtype => itemtype,
3202: itemkey => itemkey,
3203: aname => 'ASSIGNMENT_TYPE');
3204:
3205: l_reapproval_flag := wf_engine.GetItemAttrText
3206: (itemtype => itemtype,
3207: itemkey => itemkey,
3208: aname => 'REAPPROVAL_FLAG');
3209:
3234: , funcmode IN VARCHAR2
3235: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3236: IS
3237: BEGIN
3238: IF (funcmode <> wf_engine.eng_run) THEN
3239: resultout := wf_engine.eng_null;
3240: RETURN;
3241: END IF;
3242:
3235: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3236: IS
3237: BEGIN
3238: IF (funcmode <> wf_engine.eng_run) THEN
3239: resultout := wf_engine.eng_null;
3240: RETURN;
3241: END IF;
3242:
3243: -- Set the appropriate notification subject and description
3270: ,resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3271:
3272: IS
3273: BEGIN
3274: IF (funcmode <> wf_engine.eng_run) THEN
3275: resultout := wf_engine.eng_null;
3276: RETURN;
3277: END IF;
3278:
3271:
3272: IS
3273: BEGIN
3274: IF (funcmode <> wf_engine.eng_run) THEN
3275: resultout := wf_engine.eng_null;
3276: RETURN;
3277: END IF;
3278:
3279: -- Set the appropriate notification subject and description
3306: ,resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3307:
3308: IS
3309: BEGIN
3310: IF (funcmode <> wf_engine.eng_run) THEN
3311: resultout := wf_engine.eng_null;
3312: RETURN;
3313: END IF;
3314:
3307:
3308: IS
3309: BEGIN
3310: IF (funcmode <> wf_engine.eng_run) THEN
3311: resultout := wf_engine.eng_null;
3312: RETURN;
3313: END IF;
3314:
3315: -- Set the appropriate notification subject and description
3346: BEGIN
3347: /*
3348: IF funcmode = 'FORWARD' THEN
3349: Notification assignee validations go here
3350: get the assigned user which is available in wf_engine.context_text
3351: validate this user
3352: If not valid user fnd_message.set_name ('PA','PA_NO_RESOURCE_AUTHORITY');
3353: l_msg_text := fnd_message.get;
3354: RAISE invalid_user_exception;
3385: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
3386:
3387: l_assignment_id pa_project_assignments.assignment_id%TYPE;
3388: BEGIN
3389: l_assignment_id := wf_engine.GetItemAttrNumber
3390: (itemtype => itemtype,
3391: itemkey => itemkey,
3392: aname => 'ASSIGNMENT_ID');
3393: Maintain_wf_pending_flag
3501: ELSE
3502: -------------------------------------------------------------------
3503: -- Resolve Overcommitment conflict for Approve
3504: -------------------------------------------------------------------
3505: l_conflict_group_id := wf_engine.GetItemAttrNumber
3506: (itemtype => p_item_type,
3507: itemkey => p_item_key,
3508: aname => 'CONFLICT_GROUP_ID');
3509:
3506: (itemtype => p_item_type,
3507: itemkey => p_item_key,
3508: aname => 'CONFLICT_GROUP_ID');
3509:
3510: l_submitter_uname := wf_engine.GetItemAttrText
3511: ( itemtype => p_item_type
3512: , itemkey => p_item_key
3513: , aname => 'WORKFLOW_STARTED_BY_UNAME');
3514:
3540: (p_assignment_id => p_assignment_id,
3541: p_mode => 'APPROVAL_PROCESS_COMPLETED');
3542:
3543: -- Set the attribute NEW_ASGMT_STATUS_CODE
3544: wf_engine.SetItemAttrText
3545: ( itemtype => p_item_type
3546: , itemkey => p_item_key
3547: , aname => 'NEW_ASGMT_STATUS_CODE'
3548: , avalue => l_apprvl_status_code);
3566: , actid IN NUMBER
3567: , funcmode IN VARCHAR2
3568: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3569: IS
3570: l_comment VARCHAR2(4000); --VARCHAR2(2000); Bug 7459451 : Changed the length to accomodate max length returned by wf_engine.getItemAttrText
3571: l_approver_user_name wf_users.name%type; ----- VARCHAR2(240);Changed for bug 3267790
3572: /* Modified length from 30 to 100 for bug 3148857 */
3573: l_assignment_id NUMBER;
3574: l_wf_context_user pa_wf_ntf_performers.user_name%TYPE;
3593: AND item_key = itemkey
3594: AND current_approver_flag = 'Y';
3595:
3596: BEGIN
3597: l_comment := wf_engine.GetItemAttrText
3598: ( itemtype => itemtype
3599: , itemkey => itemkey
3600: , aname => 'APPROVER_RESPONSE'
3601: );
3599: , itemkey => itemkey
3600: , aname => 'APPROVER_RESPONSE'
3601: );
3602: IF l_comment IS NOT NULL THEN
3603: l_approver_user_name := wf_engine.GetItemAttrText
3604: ( itemtype => itemtype
3605: , itemkey => itemkey
3606: , aname => 'APPROVER_UNAME'
3607: );
3604: ( itemtype => itemtype
3605: , itemkey => itemkey
3606: , aname => 'APPROVER_UNAME'
3607: );
3608: l_assignment_id := wf_engine.GetItemAttrNumber
3609: ( itemtype => itemtype
3610: , itemkey => itemkey
3611: , aname => 'ASSIGNMENT_ID'
3612: );
3617: AND object_id1 = l_assignment_id
3618: AND user_name = l_approver_user_Name;
3619: -- Now reset the approver response attribute
3620: -- so that the next approver can add his/her comments
3621: wf_engine.SetItemAttrText
3622: ( itemtype => itemtype
3623: , itemkey => itemkey
3624: , aname => 'APPROVER_RESPONSE'
3625: , avalue => NULL
3631: -- set current_approver_flag to 'Y'. If reassignee is already in the table, then just set flag to 'Y'
3632: --2) Set the Forwarded_From attribute for display
3633: IF funcmode IN ('TRANSFER', 'FORWARD') THEN
3634:
3635: l_wf_context_user := WF_ENGINE.context_text;
3636:
3637: --Check to see if the reassignee already in the table
3638: OPEN get_reassignee;
3639: FETCH get_reassignee INTO l_reassignee_user_name;
3672: --
3673:
3674: --set the previous_approver attribute correctly
3675: l_prev_approver_user_name :=
3676: wf_engine.GetItemAttrText
3677: ( itemtype => itemtype
3678: , itemkey => itemkey
3679: , aname => 'APPROVER_UNAME');
3680: wf_engine.SetItemAttrText
3676: wf_engine.GetItemAttrText
3677: ( itemtype => itemtype
3678: , itemkey => itemkey
3679: , aname => 'APPROVER_UNAME');
3680: wf_engine.SetItemAttrText
3681: ( itemtype => itemtype
3682: , itemkey => itemkey
3683: , aname => 'PREV_APPROVER_UNAME'
3684: , avalue => l_prev_approver_user_name
3684: , avalue => l_prev_approver_user_name
3685: );
3686:
3687: --set current_approver to be the reassignee
3688: wf_engine.SetItemAttrText
3689: ( itemtype => itemtype
3690: , itemkey => itemkey
3691: , aname => 'APPROVER_UNAME'
3692: , avalue => l_wf_context_user
3700: , funcmode => funcmode
3701: , resultout => resultout);
3702:
3703: --set notification attribute forwarded_from to let the change show up
3704: WF_NOTIFICATION.SetAttrText (nid => WF_ENGINE.context_nid
3705: ,aname => 'FORWARDED_FROM'
3706: ,avalue => l_prev_approver_user_name);
3707:
3708: /*
3729: p_item_key IN VARCHAR2)
3730: IS
3731: BEGIN
3732: g_approver_response :=
3733: wf_engine.GetItemAttrText
3734: ( itemtype => p_item_type
3735: , itemkey => p_item_key
3736: , aname => 'APPROVER_RESPONSE'
3737: );
3752: -- Since populate_approval_NF_comments is being called from the
3753: -- approval process, pass the same item type and item key values
3754: -- for both p_apprvl and p_item parameters
3755:
3756: l_assignment_id := wf_engine.GetItemAttrNumber
3757: (itemtype => itemtype,
3758: itemkey => itemkey,
3759: aname => 'ASSIGNMENT_ID');
3760:
3820: CLOSE l_nf_csr;
3821: END IF;
3822: -- document := '';
3823: document_type := 'text/html';
3824: l_msg_data := wf_engine.GetItemAttrText
3825: ( itemtype => l_item_type
3826: , itemkey => l_item_key
3827: , aname => 'L_MSG_DATA'
3828: );
3871: IF p_msg_count = 1 THEN
3872: IF p_msg_data IS NOT NULL THEN
3873: FND_MESSAGE.SET_ENCODED (p_msg_data);
3874: l_data := FND_MESSAGE.GET;
3875: wf_engine.SetItemAttrText
3876: ( itemtype => p_item_type
3877: , itemkey => p_item_key
3878: , aname => 'ERROR_MSG1'
3879: , avalue => l_data
3895: p_msg_data => p_msg_data ,
3896: p_data => l_data,
3897: p_msg_index_out => l_msg_index_out );
3898: l_item_attr_name := 'ERROR_MSG'||i;
3899: wf_engine.SetItemAttrText
3900: ( itemtype => p_item_type
3901: , itemkey => p_item_key
3902: , aname => l_item_attr_name
3903: , avalue => l_data
4033:
4034: IF p_wf_type_code like '%FYI' THEN
4035:
4036: --Get the Name of the User logged In.
4037: l_user_name := wf_engine.GetItemAttrText
4038: ( itemtype => p_item_type
4039: , itemkey => p_item_key
4040: , aname => 'WORKFLOW_STARTED_BY_UNAME');
4041: /* IF x_performer_name = l_user_name THEN
4090: -- Now set the appropriate comments attributes for this WF
4091: -- Populate the internal comments only . displayed comments
4092: -- will be done by the get_recipients nodes
4093: l_item_attr_name := 'INTERNAL_APPROVER_COMMENTS_'||l_counter ;
4094: wf_engine.SetItemAttrText
4095: ( itemtype => p_item_type
4096: , itemkey => p_item_key
4097: , aname => l_item_attr_name
4098: , avalue =>
4111: PROCEDURE Set_Comment_Attributes (p_item_type IN VARCHAR2,
4112: p_item_key IN VARCHAR2,
4113: p_rect_type IN VARCHAR2 ) IS
4114: l_comments_item_attr_name VARCHAR2(30);
4115: l_comments VARCHAR2(4000); -- VARCHAR2(255); Bug 7459451 : Changed the length to accomodate max length returned by wf_engine.getItemAttrText
4116: BEGIN
4117: -- Set displayed comments to NULL if the recipient is resource
4118: -- otherwise set the displayed comments to the internal comments
4119: FOR i IN 1..5 LOOP
4117: -- Set displayed comments to NULL if the recipient is resource
4118: -- otherwise set the displayed comments to the internal comments
4119: FOR i IN 1..5 LOOP
4120: l_comments_item_attr_name := 'INTERNAL_APPROVER_COMMENTS_'||i;
4121: l_comments := wf_engine.getItemAttrText
4122: ( itemtype => p_item_type
4123: , itemkey => p_item_key
4124: , aname => l_comments_item_attr_name
4125: );
4125: );
4126: IF p_rect_type = 'RESOURCE' THEN
4127: l_comments := NULL;
4128: END IF;
4129: wf_engine.SetItemAttrText
4130: ( itemtype => p_item_type
4131: , itemkey => p_item_key
4132: , aname => 'APPROVER_COMMENTS_'||i
4133: , avalue => l_comments
4254: END IF;
4255: END IF;
4256:
4257: ELSIF p_msg_type = 'APPROVAL_FYI' THEN
4258: l_assignment_id := wf_engine.GetItemAttrNumber
4259: (itemtype => p_item_type,
4260: itemkey => p_item_key,
4261: aname => 'ASSIGNMENT_ID');
4262: l_conflict_group_id := wf_engine.GetItemAttrNumber
4258: l_assignment_id := wf_engine.GetItemAttrNumber
4259: (itemtype => p_item_type,
4260: itemkey => p_item_key,
4261: aname => 'ASSIGNMENT_ID');
4262: l_conflict_group_id := wf_engine.GetItemAttrNumber
4263: (itemtype => p_item_type,
4264: itemkey => p_item_key,
4265: aname => 'CONFLICT_GROUP_ID');
4266:
4270: l_msg_desc_code := 'PA_NFDESC_ASGMT_APPROVED';
4271:
4272: -- set 'Number of Assignments Resulting in Resource Overcommitment -1/0' for single
4273: -- approval FYI notification.
4274: wf_engine.SetItemAttrNumber
4275: ( itemtype => p_item_type
4276: , itemkey => p_item_key
4277: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
4278: , avalue => 0 );
4294: END IF;
4295:
4296: -- set 'Number of Assignments Resulting in Resource Overcommitment -1/0' for single
4297: -- approval FYI notification.
4298: wf_engine.SetItemAttrNumber
4299: ( itemtype => p_item_type
4300: , itemkey => p_item_key
4301: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
4302: , avalue => 1 );
4307: || 'PA_RES_OVERCOMMITMENT_LAYOUT&paAssignmentId=' || l_assignment_id
4308: || '&paConflictGroupId=' || l_conflict_group_id
4309: || '&paCallingPage=Default&addBreadCrumb=RP';
4310:
4311: wf_engine.SetItemAttrText
4312: ( itemtype => p_item_type
4313: , itemkey => p_item_key
4314: , aname => 'VIEW_CONFLICT_URL_INFO'
4315: , avalue => l_view_conflict_url );
4315: , avalue => l_view_conflict_url );
4316: ELSIF p_msg_type = 'REJECTION_FYI' OR p_msg_type = 'CANCELLATION_FYI' THEN
4317: -- set 'Number of Assignments Resulting in Resource Overcommitment -0' for single
4318: -- reject/cancel FYI notification.
4319: wf_engine.SetItemAttrNumber
4320: ( itemtype => p_item_type
4321: , itemkey => p_item_key
4322: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
4323: , avalue => 0 );
4321: , itemkey => p_item_key
4322: , aname => 'NUMBER_OF_OVERCOM_ASGMT'
4323: , avalue => 0 );
4324:
4325: l_assignment_id := wf_engine.GetItemAttrNumber
4326: (itemtype => p_item_type,
4327: itemkey => p_item_key,
4328: aname => 'ASSIGNMENT_ID');
4329: -- set resource overcommitment url
4330: l_view_conflict_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275&akRegionCode='
4331: || 'PA_RES_OVERCOMMITMENT_LAYOUT&paAssignmentId=' || l_assignment_id
4332: || '&paConflictGroupId=&paCallingPage=Default&addBreadCrumb=RP';
4333:
4334: wf_engine.SetItemAttrText
4335: ( itemtype => p_item_type
4336: , itemkey => p_item_key
4337: , aname => 'VIEW_CONFLICT_URL_INFO'
4338: , avalue => l_view_conflict_url );
4357: l_msg_subj_text := FND_MESSAGE.GET;
4358: FND_MESSAGE.SET_NAME ('PA',l_msg_desc_code);
4359: l_msg_desc_text := FND_MESSAGE.GET;
4360:
4361: wf_engine.SetItemAttrText
4362: ( itemtype => p_item_type
4363: , itemkey => p_item_key
4364: , aname => l_msg_subj_itemattr_name
4365: , avalue => l_msg_subj_text
4363: , itemkey => p_item_key
4364: , aname => l_msg_subj_itemattr_name
4365: , avalue => l_msg_subj_text
4366: );
4367: wf_engine.SetItemAttrText
4368: ( itemtype => p_item_type
4369: , itemkey => p_item_key
4370: , aname => l_msg_desc_itemattr_name
4371: , avalue => l_msg_desc_text
4516: , resp_id => l_responsibility_id
4517: , resp_appl_id => l_resp_appl_id );
4518:
4519: -- Setting thresold value to run the process in background
4520: l_save_threshold := wf_engine.threshold;
4521: wf_engine.threshold := -1;
4522:
4523: -----------------------------------
4524: --Getting the current approver name
4517: , resp_appl_id => l_resp_appl_id );
4518:
4519: -- Setting thresold value to run the process in background
4520: l_save_threshold := wf_engine.threshold;
4521: wf_engine.threshold := -1;
4522:
4523: -----------------------------------
4524: --Getting the current approver name
4525: -----------------------------------
4589:
4590: log_message('l_mass_approve_url:' || l_mass_approve_url);
4591:
4592: -- Create the WF process
4593: wf_engine.CreateProcess
4594: ( ItemType => l_wf_item_type
4595: , ItemKey => l_itemkey
4596: , process => l_wf_process );
4597:
4600: ----------------------------------------------------------------
4601: --Set all the required workflow attributes and start the workflow
4602: -----------------------------------------------------------------
4603: --set group_id
4604: wf_engine.SetItemAttrNumber
4605: ( itemtype => l_wf_item_type
4606: , itemkey => l_itemkey
4607: , aname => 'GROUP_ID'
4608: , avalue => p_group_id);
4606: , itemkey => l_itemkey
4607: , aname => 'GROUP_ID'
4608: , avalue => p_group_id);
4609:
4610: wf_engine.SetItemAttrNumber
4611: ( itemtype => l_wf_item_type
4612: , itemkey => l_itemkey
4613: , aname => 'APPROVER_GROUP_ID'
4614: , avalue => p_approver_group_id);
4612: , itemkey => l_itemkey
4613: , aname => 'APPROVER_GROUP_ID'
4614: , avalue => p_approver_group_id);
4615:
4616: wf_engine.SetItemAttrNumber
4617: ( itemtype => l_wf_item_type
4618: , itemkey => l_itemkey
4619: , aname => 'ROUTING_ORDER'
4620: , avalue => p_routing_order);
4619: , aname => 'ROUTING_ORDER'
4620: , avalue => p_routing_order);
4621:
4622: --This is required for check_notiifcation_completed API logic
4623: wf_engine.SetItemAttrText
4624: ( itemtype => l_wf_item_type
4625: , itemkey => l_itemkey
4626: , aname => 'MODE'
4627: , avalue => p_mode);
4625: , itemkey => l_itemkey
4626: , aname => 'MODE'
4627: , avalue => p_mode);
4628:
4629: wf_engine.SetItemAttrText
4630: ( itemtype => l_wf_item_type
4631: , itemkey => l_itemkey
4632: , aname => 'SUBMITTER_UNAME'
4633: , avalue => p_submitter_user_name);
4631: , itemkey => l_itemkey
4632: , aname => 'SUBMITTER_UNAME'
4633: , avalue => p_submitter_user_name);
4634:
4635: wf_engine.SetItemAttrDocument
4636: ( itemtype => l_wf_item_type
4637: , itemkey => l_itemkey
4638: , aname => 'UPDATED_INFO_DOC'
4639: , documentid => p_update_info_doc );
4638: , aname => 'UPDATED_INFO_DOC'
4639: , documentid => p_update_info_doc );
4640:
4641: --Set approval type
4642: wf_engine.SetItemAttrText
4643: ( itemtype => l_wf_item_type
4644: , itemkey => l_itemkey
4645: , aname => 'APPROVAL_TYPE'
4646: , avalue => PA_ASGMT_WFSTD.G_MASS_APPROVAL );
4645: , aname => 'APPROVAL_TYPE'
4646: , avalue => PA_ASGMT_WFSTD.G_MASS_APPROVAL );
4647:
4648: --Setting Mass Assignments details
4649: wf_engine.SetItemAttrText
4650: ( itemtype => l_wf_item_type
4651: , itemkey => l_itemkey
4652: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
4653: , avalue => l_ntfy_apprvl_recipient_name );
4651: , itemkey => l_itemkey
4652: , aname => 'NTFY_APPRVL_RECIPIENT_NAME'
4653: , avalue => l_ntfy_apprvl_recipient_name );
4654:
4655: wf_engine.SetItemAttrText
4656: ( itemtype => l_wf_item_type
4657: , itemkey => l_itemkey
4658: , aname => 'FORWARDED_FROM'
4659: , avalue => l_prev_user );
4657: , itemkey => l_itemkey
4658: , aname => 'FORWARDED_FROM'
4659: , avalue => l_prev_user );
4660:
4661: wf_engine.SetItemAttrText
4662: ( itemtype => l_wf_item_type
4663: , itemkey => l_itemkey
4664: , aname => 'NOTE_TO_APPROVER'
4665: , avalue => p_note_to_approvers );
4663: , itemkey => l_itemkey
4664: , aname => 'NOTE_TO_APPROVER'
4665: , avalue => p_note_to_approvers );
4666:
4667: wf_engine.SetItemAttrText
4668: ( itemtype => l_wf_item_type
4669: , itemkey => l_itemkey
4670: , aname => 'NUMBER_OF_ASSIGNMENTS'
4671: , avalue => l_number_of_assignments );
4669: , itemkey => l_itemkey
4670: , aname => 'NUMBER_OF_ASSIGNMENTS'
4671: , avalue => l_number_of_assignments );
4672:
4673: wf_engine.SetItemAttrText
4674: ( itemtype => l_wf_item_type
4675: , itemkey => l_itemkey
4676: , aname => 'MASS_APPROVE_URL_INFO'
4677: , avalue => l_mass_approve_url );
4676: , aname => 'MASS_APPROVE_URL_INFO'
4677: , avalue => l_mass_approve_url );
4678:
4679: --Setting the Upadate info document
4680: wf_engine.SetItemAttrDocument
4681: ( itemtype => l_wf_item_type
4682: , itemkey => l_itemkey
4683: , aname => 'UPDATED_INFO_DOC'
4684: , documentid => p_update_info_doc );
4684: , documentid => p_update_info_doc );
4685:
4686: --Setting Project Details
4687: IF p_project_manager IS NOT NULL THEN
4688: wf_engine.SetItemAttrText
4689: ( itemtype => l_wf_item_type
4690: , itemkey => l_itemkey
4691: , aname => 'PROJECT_MANAGER_NAME'
4692: , avalue => p_project_manager );
4691: , aname => 'PROJECT_MANAGER_NAME'
4692: , avalue => p_project_manager );
4693: END IF;
4694:
4695: wf_engine.SetItemAttrNumber
4696: ( itemtype => l_wf_item_type
4697: , itemkey => l_itemkey
4698: , aname => 'PROJECT_ID'
4699: , avalue => p_project_id);
4697: , itemkey => l_itemkey
4698: , aname => 'PROJECT_ID'
4699: , avalue => p_project_id);
4700:
4701: wf_engine.SetItemAttrText
4702: ( itemtype => l_wf_item_type
4703: , itemkey => l_itemkey
4704: , aname => 'PROJECT_NUMBER'
4705: , avalue => p_project_number);
4703: , itemkey => l_itemkey
4704: , aname => 'PROJECT_NUMBER'
4705: , avalue => p_project_number);
4706:
4707: wf_engine.SetItemAttrText
4708: ( itemtype => l_wf_item_type
4709: , itemkey => l_itemkey
4710: , aname => 'PROJECT_NAME'
4711: , avalue => p_project_name);
4709: , itemkey => l_itemkey
4710: , aname => 'PROJECT_NAME'
4711: , avalue => p_project_name);
4712:
4713: wf_engine.SetItemAttrText
4714: ( itemtype => l_wf_item_type
4715: , itemkey => l_itemkey
4716: , aname => 'PROJECT_ORGANIZATION'
4717: , avalue => p_project_org);
4716: , aname => 'PROJECT_ORGANIZATION'
4717: , avalue => p_project_org);
4718:
4719: if wf_directory.UserActive(p_submitter_user_name) then -- Bug # 9837538
4720: wf_engine.SetItemAttrText
4721: ( itemtype => l_wf_item_type
4722: , itemkey => l_itemkey
4723: , aname => 'FROM_ROLE_VALUE'
4724: , avalue => p_submitter_user_name); --Added for bug 4535838
4724: , avalue => p_submitter_user_name); --Added for bug 4535838
4725: end if; -- Bug # 9837538
4726: -- Set the customer name if it is not null
4727: IF p_project_cus IS NOT NULL THEN
4728: wf_engine.SetItemAttrText
4729: ( itemtype => l_wf_item_type
4730: , itemkey => l_itemkey
4731: , aname => 'PROJECT_CUSTOMER'
4732: , avalue => p_project_cus);
4735: log_message('Starting process');
4736: -----------------------------
4737: --Start the workflow process
4738: -----------------------------
4739: wf_engine.StartProcess ( itemtype => l_wf_item_type
4740: ,itemkey => l_itemkey );
4741:
4742: PA_WORKFLOW_UTILS.Insert_WF_Processes
4743: (p_wf_type_code => 'MASS_ASSIGNMENT_APPROVAL'
4752:
4753: END IF; --l_num_of_assignments > 0
4754:
4755: --Setting the original value
4756: wf_engine.threshold := l_save_threshold;
4757:
4758: EXCEPTION
4759: WHEN OTHERS THEN
4760:
4758: EXCEPTION
4759: WHEN OTHERS THEN
4760:
4761: --Setting the original value
4762: wf_engine.threshold := l_save_threshold;
4763:
4764: -- Set the excetption Message and the stack
4765: FND_MSG_PUB.add_exc_msg
4766: ( p_pkg_name => 'PA_ASGMT_WFSTD.start_mass_Approval_flow'
5038: , resp_id => l_responsibility_id
5039: , resp_appl_id => l_resp_appl_id );
5040:
5041: -- Setting thresold value to run the process in background
5042: l_save_threshold := wf_engine.threshold;
5043: wf_engine.threshold := -1;
5044:
5045: log_message('RESOURCE PERSON ID:' || l_ntfy_apprvl_rect_person_id);
5046: log_message('RESOURCE UNAME:' || l_ntfy_apprvl_recipient_name);
5039: , resp_appl_id => l_resp_appl_id );
5040:
5041: -- Setting thresold value to run the process in background
5042: l_save_threshold := wf_engine.threshold;
5043: wf_engine.threshold := -1;
5044:
5045: log_message('RESOURCE PERSON ID:' || l_ntfy_apprvl_rect_person_id);
5046: log_message('RESOURCE UNAME:' || l_ntfy_apprvl_recipient_name);
5047:
5101: INTO l_itemkey
5102: FROM dual;
5103:
5104: -- Create the WF process
5105: wf_engine.CreateProcess
5106: ( ItemType => l_wf_item_type
5107: , ItemKey => l_itemkey
5108: , process => l_wf_process );
5109:
5156: ------------------------------------------------------------
5157: --Set the item attributes required for resource notification
5158: ------------------------------------------------------------
5159: -- setting subject, description, conflict URL for overcommitment
5160: wf_engine.SetItemAttrText
5161: ( itemtype => l_wf_item_type
5162: , itemkey => l_itemkey
5163: , aname => 'MSG_SUBJECT'
5164: , avalue => l_msg_subj_text);
5162: , itemkey => l_itemkey
5163: , aname => 'MSG_SUBJECT'
5164: , avalue => l_msg_subj_text);
5165:
5166: wf_engine.SetItemAttrText
5167: ( itemtype => l_wf_item_type
5168: , itemkey => l_itemkey
5169: , aname => 'MSG_DESCRIPTION'
5170: , avalue => l_msg_desc_text );
5170: , avalue => l_msg_desc_text );
5171:
5172: -- IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved AND
5173: -- p_conflict_group_id IS NOT NULL) THEN
5174: wf_engine.SetItemAttrText
5175: ( itemtype => l_wf_item_type
5176: , itemkey => l_itemkey
5177: , aname => 'CONFLICT_URL'
5178: , avalue => l_view_conflict_url );
5178: , avalue => l_view_conflict_url );
5179: -- END IF;
5180:
5181: --Setting Resource attributes
5182: wf_engine.SetItemAttrText
5183: ( itemtype => l_wf_item_type
5184: , itemkey => l_itemkey
5185: , aname => 'NTFY_FYI_USER_NAME'
5186: , avalue => l_ntfy_apprvl_recipient_name);
5184: , itemkey => l_itemkey
5185: , aname => 'NTFY_FYI_USER_NAME'
5186: , avalue => l_ntfy_apprvl_recipient_name);
5187:
5188: wf_engine.SetItemAttrText
5189: ( itemtype => l_wf_item_type
5190: , itemkey => l_itemkey
5191: , aname => 'RESOURCE_NAME'
5192: , avalue => l_resource_rec.resource_name );
5190: , itemkey => l_itemkey
5191: , aname => 'RESOURCE_NAME'
5192: , avalue => l_resource_rec.resource_name );
5193:
5194: wf_engine.SetItemAttrText
5195: ( itemtype => l_wf_item_type
5196: , itemkey => l_itemkey
5197: , aname => 'RESOURCE_ORGANIZATION'
5198: , avalue => l_resource_rec.name );
5198: , avalue => l_resource_rec.name );
5199:
5200:
5201: --Setting URL information
5202: wf_engine.SetItemAttrText
5203: ( itemtype => l_wf_item_type
5204: , itemkey => l_itemkey
5205: , aname => 'ASSIGNMENT_DETAILS_URL'
5206: , avalue => l_asgmt_details_url );
5204: , itemkey => l_itemkey
5205: , aname => 'ASSIGNMENT_DETAILS_URL'
5206: , avalue => l_asgmt_details_url );
5207:
5208: wf_engine.SetItemAttrText
5209: ( itemtype => l_wf_item_type
5210: , itemkey => l_itemkey
5211: , aname => 'RESOURCE_SCHEDULES_URL'
5212: , avalue => l_resource_schedules_url );
5212: , avalue => l_resource_schedules_url );
5213:
5214: --Setting assignment attributes
5215: IF l_reapproval_flag = 'Y' THEN
5216: wf_engine.SetItemAttrNumber
5217: ( itemtype => l_wf_item_type
5218: , itemkey => l_itemkey
5219: , aname => 'PREV_DURATION'
5220: , avalue => l_prev_asgmt_info_rec.prev_duration );
5218: , itemkey => l_itemkey
5219: , aname => 'PREV_DURATION'
5220: , avalue => l_prev_asgmt_info_rec.prev_duration );
5221:
5222: wf_engine.SetItemAttrNumber
5223: ( itemtype => l_wf_item_type
5224: ,itemkey => l_itemkey
5225: , aname => 'PREV_EFFORT'
5226: , avalue => l_prev_asgmt_info_rec.prev_effort );
5226: , avalue => l_prev_asgmt_info_rec.prev_effort );
5227: END IF;
5228:
5229: -- Start Additions by RM for bug 2274426
5230: wf_engine.SetItemAttrNumber
5231: ( itemtype => l_wf_item_type
5232: , itemkey => l_itemkey
5233: , aname => 'REVENUE_BILL_RATE'
5234: , avalue => l_assignments_rec.revenue_bill_rate
5232: , itemkey => l_itemkey
5233: , aname => 'REVENUE_BILL_RATE'
5234: , avalue => l_assignments_rec.revenue_bill_rate
5235: );
5236: wf_engine.SetItemAttrText
5237: ( itemtype => l_wf_item_type
5238: , itemkey => l_itemkey
5239: , aname => 'REVENUE_BILL_RATE_CURR'
5240: , avalue => l_assignments_rec.revenue_currency_code
5238: , itemkey => l_itemkey
5239: , aname => 'REVENUE_BILL_RATE_CURR'
5240: , avalue => l_assignments_rec.revenue_currency_code
5241: );
5242: wf_engine.SetItemAttrNumber
5243: ( itemtype => l_wf_item_type
5244: , itemkey => l_itemkey
5245: , aname => 'BILL_RATE_OVERRIDE'
5246: , avalue => l_assignments_rec.bill_rate_override
5244: , itemkey => l_itemkey
5245: , aname => 'BILL_RATE_OVERRIDE'
5246: , avalue => l_assignments_rec.bill_rate_override
5247: );
5248: wf_engine.SetItemAttrText
5249: ( itemtype => l_wf_item_type
5250: , itemkey => l_itemkey
5251: , aname => 'BILL_RATE_OVERRIDE_CURR'
5252: , avalue => l_assignments_rec.bill_rate_curr_override
5251: , aname => 'BILL_RATE_OVERRIDE_CURR'
5252: , avalue => l_assignments_rec.bill_rate_curr_override
5253: );
5254: IF l_assignments_rec.markup_percent_override IS NOT NULL THEN
5255: wf_engine.SetItemAttrText
5256: ( itemtype => l_wf_item_type
5257: , itemkey => l_itemkey
5258: , aname => 'MARKUP_PCT_OVERRIDE'
5259: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
5258: , aname => 'MARKUP_PCT_OVERRIDE'
5259: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
5260: );
5261: ELSE
5262: wf_engine.SetItemAttrText
5263: ( itemtype => l_wf_item_type
5264: , itemkey => l_itemkey
5265: , aname => 'MARKUP_PCT_OVERRIDE'
5266: , avalue => to_char(l_assignments_rec.markup_percent_override)
5265: , aname => 'MARKUP_PCT_OVERRIDE'
5266: , avalue => to_char(l_assignments_rec.markup_percent_override)
5267: );
5268: END IF;
5269: wf_engine.SetItemAttrText
5270: ( itemtype => l_wf_item_type
5271: , itemkey => l_itemkey
5272: , aname => 'TP_AMT_TYPE_NAME'
5273: , avalue => l_assignments_rec.fcst_tp_amount_type_name
5271: , itemkey => l_itemkey
5272: , aname => 'TP_AMT_TYPE_NAME'
5273: , avalue => l_assignments_rec.fcst_tp_amount_type_name
5274: );
5275: wf_engine.SetItemAttrNumber
5276: ( itemtype => l_wf_item_type
5277: , itemkey => l_itemkey
5278: , aname => 'TP_RATE_OVERRIDE'
5279: , avalue => l_assignments_rec.tp_rate_override
5277: , itemkey => l_itemkey
5278: , aname => 'TP_RATE_OVERRIDE'
5279: , avalue => l_assignments_rec.tp_rate_override
5280: );
5281: wf_engine.SetItemAttrText
5282: ( itemtype => l_wf_item_type
5283: , itemkey => l_itemkey
5284: , aname => 'TP_RATE_OVERRIDE_CURR'
5285: , avalue => l_assignments_rec.tp_currency_override
5288: open csr_get_override_basis_name(l_assignments_rec.tp_calc_base_code_override);
5289: fetch csr_get_override_basis_name into l_override_basis_name;
5290: close csr_get_override_basis_name;
5291: END IF;
5292: wf_engine.SetItemAttrText
5293: ( itemtype => l_wf_item_type
5294: , itemkey => l_itemkey
5295: , aname => 'OVERRIDE_BASIS_NAME'
5296: , avalue => l_override_basis_name
5296: , avalue => l_override_basis_name
5297: );
5298: IF l_assignments_rec.tp_percent_applied_override IS NOT NULL THEN
5299: IF l_override_basis_name IS NOT NULL THEN
5300: wf_engine.SetItemAttrText
5301: ( itemtype => l_wf_item_type
5302: , itemkey => l_itemkey
5303: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5304: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5303: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5304: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5305: );
5306: ELSE
5307: wf_engine.SetItemAttrText
5308: ( itemtype => l_wf_item_type
5309: , itemkey => l_itemkey
5310: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5311: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5311: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5312: );
5313: END IF;
5314: ELSE
5315: wf_engine.SetItemAttrText
5316: ( itemtype => l_wf_item_type
5317: , itemkey => l_itemkey
5318: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5319: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
5318: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5319: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
5320: );
5321: END IF;
5322: wf_engine.SetItemAttrText
5323: ( itemtype => l_wf_item_type
5324: , itemkey => l_itemkey
5325: , aname => 'WORK_TYPE_NAME'
5326: , avalue => l_assignments_rec.work_type_name
5326: , avalue => l_assignments_rec.work_type_name
5327: );
5328: -- End of Additions by RM
5329:
5330: wf_engine.SetItemAttrText
5331: ( itemtype => l_wf_item_type
5332: , itemkey => l_itemkey
5333: , aname => 'ASSIGNMENT_NAME'
5334: , avalue => l_assignments_rec.assignment_name );
5332: , itemkey => l_itemkey
5333: , aname => 'ASSIGNMENT_NAME'
5334: , avalue => l_assignments_rec.assignment_name );
5335:
5336: wf_engine.SetItemAttrNumber
5337: ( itemtype => l_wf_item_type
5338: , itemkey => l_itemkey
5339: , aname => 'ASSIGNMENT_DURATION'
5340: , avalue => (trunc(l_assignments_rec.end_date) -
5339: , aname => 'ASSIGNMENT_DURATION'
5340: , avalue => (trunc(l_assignments_rec.end_date) -
5341: trunc(l_assignments_rec.start_date)+1) );
5342:
5343: wf_engine.SetItemAttrNumber
5344: ( itemtype => l_wf_item_type
5345: , itemkey => l_itemkey
5346: , aname => 'ASSIGNMENT_EFFORT'
5347: , avalue => l_assignments_rec.assignment_effort );
5345: , itemkey => l_itemkey
5346: , aname => 'ASSIGNMENT_EFFORT'
5347: , avalue => l_assignments_rec.assignment_effort );
5348:
5349: wf_engine.SetItemAttrText
5350: ( itemtype => l_wf_item_type
5351: , itemkey => l_itemkey
5352: , aname => 'DESCRIPTION'
5353: , avalue => l_assignments_rec.description );
5351: , itemkey => l_itemkey
5352: , aname => 'DESCRIPTION'
5353: , avalue => l_assignments_rec.description );
5354:
5355: wf_engine.SetItemAttrText
5356: ( itemtype => l_wf_item_type
5357: , itemkey => l_itemkey
5358: , aname => 'ADDITIONAL_INFORMATION'
5359: , avalue => l_assignments_rec.additional_information );
5358: , aname => 'ADDITIONAL_INFORMATION'
5359: , avalue => l_assignments_rec.additional_information );
5360:
5361: --Setting Project attributes
5362: wf_engine.SetItemAttrText
5363: ( itemtype => l_wf_item_type
5364: , itemkey => l_itemkey
5365: , aname => 'PROJECT_NAME'
5366: , avalue => p_project_name );
5364: , itemkey => l_itemkey
5365: , aname => 'PROJECT_NAME'
5366: , avalue => p_project_name );
5367:
5368: wf_engine.SetItemAttrText
5369: ( itemtype => l_wf_item_type
5370: , itemkey => l_itemkey
5371: , aname => 'PROJECT_NUMBER'
5372: , avalue => p_project_number );
5370: , itemkey => l_itemkey
5371: , aname => 'PROJECT_NUMBER'
5372: , avalue => p_project_number );
5373:
5374: wf_engine.SetItemAttrText
5375: ( itemtype => l_wf_item_type
5376: , itemkey => l_itemkey
5377: , aname => 'PROJECT_MANAGER_NAME'
5378: , avalue => p_project_manager );
5376: , itemkey => l_itemkey
5377: , aname => 'PROJECT_MANAGER_NAME'
5378: , avalue => p_project_manager );
5379:
5380: wf_engine.SetItemAttrText
5381: ( itemtype => l_wf_item_type
5382: , itemkey => l_itemkey
5383: , aname => 'PROJECT_ORGANIZATION'
5384: , avalue => p_project_org );
5382: , itemkey => l_itemkey
5383: , aname => 'PROJECT_ORGANIZATION'
5384: , avalue => p_project_org );
5385:
5386: wf_engine.SetItemAttrText
5387: ( itemtype => l_wf_item_type
5388: , itemkey => l_itemkey
5389: , aname => 'PROJECT_CUSTOMER'
5390: , avalue => p_project_cus );
5388: , itemkey => l_itemkey
5389: , aname => 'PROJECT_CUSTOMER'
5390: , avalue => p_project_cus );
5391:
5392: wf_engine.SetItemAttrDate
5393: ( itemtype => l_wf_item_type
5394: , itemkey => l_itemkey
5395: , aname => 'START_DATE'
5396: , avalue => l_assignments_rec.start_date);
5394: , itemkey => l_itemkey
5395: , aname => 'START_DATE'
5396: , avalue => l_assignments_rec.start_date);
5397:
5398: wf_engine.SetItemAttrDate
5399: ( itemtype => l_wf_item_type
5400: , itemkey => l_itemkey
5401: , aname => 'END_DATE'
5402: , avalue => l_assignments_rec.end_date);
5402: , avalue => l_assignments_rec.end_date);
5403:
5404: /* Added for bug 3051110 */
5405:
5406: wf_engine.SetItemAttrNumber
5407: ( itemtype => l_wf_item_type
5408: , Itemkey => l_itemkey
5409: , aname => 'TRANSFER_PRICE_RATE'
5410: , avalue => l_assignments_rec.transfer_price_rate);
5408: , Itemkey => l_itemkey
5409: , aname => 'TRANSFER_PRICE_RATE'
5410: , avalue => l_assignments_rec.transfer_price_rate);
5411:
5412: wf_Engine.SetItemAttrText
5413: (itemtype => l_wf_item_type
5414: , itemkey => l_itemkey
5415: , aname => 'TRANSFER_PR_RATE_CURR'
5416: , avalue => l_assignments_rec.transfer_pr_rate_curr);
5415: , aname => 'TRANSFER_PR_RATE_CURR'
5416: , avalue => l_assignments_rec.transfer_pr_rate_curr);
5417:
5418: --Start the workflow process
5419: wf_engine.StartProcess ( itemtype => l_wf_item_type
5420: ,itemkey => l_itemkey );
5421:
5422: PA_WORKFLOW_UTILS.Insert_WF_Processes
5423: (p_wf_type_code => 'MASS_ASSIGNMENT_APPROVAL'
5434: END IF;--end recipient name is null (no fnd_user for this resource)
5435:
5436:
5437: --Setting the original value
5438: wf_engine.threshold := l_save_threshold;
5439:
5440: -- IF the number of messages is 1 then fetch the message code from
5441: -- the stack and return its text
5442: x_msg_count := FND_MSG_PUB.Count_Msg;
5460: EXCEPTION
5461: WHEN OTHERS THEN
5462:
5463: --Setting the original value
5464: wf_engine.threshold := l_save_threshold;
5465:
5466: -- Set the excetption Message and the stack
5467: FND_MSG_PUB.add_exc_msg
5468: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_res_fyi_notification'
5604: '&akRegionCode=PA_SELECTED_RESOURCES_LAYOUT&paCallingPage=WF_Notifications' ||
5605: '&paProjectId=' || l_assignments_rec.project_id || '&paNotifiedId=' ||
5606: p_notified_id || '&paGroupId=' || p_group_id || '&paApprovalStatus=Rejected&addBreadCrumb=RP';
5607:
5608: wf_engine.SetItemAttrText
5609: ( itemtype => l_wf_item_type
5610: , itemkey => l_itemkey
5611: , aname => 'SELECTED_RESOURCES_URL'
5612: , avalue => l_selected_resources_url);
5610: , itemkey => l_itemkey
5611: , aname => 'SELECTED_RESOURCES_URL'
5612: , avalue => l_selected_resources_url);
5613:
5614: wf_engine.SetItemAttrText
5615: ( itemtype => l_wf_item_type
5616: , itemkey => l_itemkey
5617: , aname => 'SELECTED_RESOURCES2_URL'
5618: , avalue => l_selected_resources2_url);
5616: , itemkey => l_itemkey
5617: , aname => 'SELECTED_RESOURCES2_URL'
5618: , avalue => l_selected_resources2_url);
5619:
5620: wf_engine.SetItemAttrText
5621: ( itemtype => l_wf_item_type
5622: , itemkey => l_itemkey
5623: , aname => 'ASSIGNMENT_NAME'
5624: , avalue => l_assignments_rec.assignment_name );
5622: , itemkey => l_itemkey
5623: , aname => 'ASSIGNMENT_NAME'
5624: , avalue => l_assignments_rec.assignment_name );
5625:
5626: wf_engine.SetItemAttrText
5627: ( itemtype => l_wf_item_type
5628: , itemkey => l_itemkey
5629: , aname => 'RESOURCE_ORGANIZATION'
5630: , avalue => l_assignments_rec.name );
5628: , itemkey => l_itemkey
5629: , aname => 'RESOURCE_ORGANIZATION'
5630: , avalue => l_assignments_rec.name );
5631:
5632: wf_engine.SetItemAttrNumber
5633: ( itemtype => l_wf_item_type
5634: , itemkey => l_itemkey
5635: , aname => 'ASSIGNMENT_DURATION'
5636: , avalue => (trunc(l_assignments_rec.end_date) -
5635: , aname => 'ASSIGNMENT_DURATION'
5636: , avalue => (trunc(l_assignments_rec.end_date) -
5637: trunc(l_assignments_rec.start_date)+1) );
5638:
5639: wf_engine.SetItemAttrNumber
5640: ( itemtype => l_wf_item_type
5641: , itemkey => l_itemkey
5642: , aname => 'ASSIGNMENT_EFFORT'
5643: , avalue => l_assignments_rec.assignment_effort );
5641: , itemkey => l_itemkey
5642: , aname => 'ASSIGNMENT_EFFORT'
5643: , avalue => l_assignments_rec.assignment_effort );
5644:
5645: wf_engine.SetItemAttrText
5646: ( itemtype => l_wf_item_type
5647: , itemkey => l_itemkey
5648: , aname => 'DESCRIPTION'
5649: , avalue => l_assignments_rec.description );
5647: , itemkey => l_itemkey
5648: , aname => 'DESCRIPTION'
5649: , avalue => l_assignments_rec.description );
5650:
5651: wf_engine.SetItemAttrText
5652: ( itemtype => l_wf_item_type
5653: , itemkey => l_itemkey
5654: , aname => 'ADDITIONAL_INFORMATION'
5655: , avalue => l_assignments_rec.additional_information );
5653: , itemkey => l_itemkey
5654: , aname => 'ADDITIONAL_INFORMATION'
5655: , avalue => l_assignments_rec.additional_information );
5656:
5657: wf_engine.SetItemAttrDate
5658: (itemtype => l_wf_item_type
5659: , itemkey => l_itemkey
5660: , aname => 'START_DATE'
5661: , avalue => l_assignments_rec.start_date
5660: , aname => 'START_DATE'
5661: , avalue => l_assignments_rec.start_date
5662: );
5663:
5664: wf_engine.SetItemAttrDate
5665: (itemtype => l_wf_item_type
5666: , itemkey => l_itemkey
5667: , aname => 'END_DATE'
5668: , avalue => l_assignments_rec.end_date
5667: , aname => 'END_DATE'
5668: , avalue => l_assignments_rec.end_date
5669: );
5670: -- Start Additions by RM for bug 2274426
5671: wf_engine.SetItemAttrNumber
5672: ( itemtype => l_wf_item_type
5673: , itemkey => l_itemkey
5674: , aname => 'REVENUE_BILL_RATE'
5675: , avalue => l_assignments_rec.revenue_bill_rate
5673: , itemkey => l_itemkey
5674: , aname => 'REVENUE_BILL_RATE'
5675: , avalue => l_assignments_rec.revenue_bill_rate
5676: );
5677: wf_engine.SetItemAttrText
5678: ( itemtype => l_wf_item_type
5679: , itemkey => l_itemkey
5680: , aname => 'REVENUE_BILL_RATE_CURR'
5681: , avalue => l_assignments_rec.revenue_currency_code
5679: , itemkey => l_itemkey
5680: , aname => 'REVENUE_BILL_RATE_CURR'
5681: , avalue => l_assignments_rec.revenue_currency_code
5682: );
5683: wf_engine.SetItemAttrNumber
5684: ( itemtype => l_wf_item_type
5685: , itemkey => l_itemkey
5686: , aname => 'BILL_RATE_OVERRIDE'
5687: , avalue => l_assignments_rec.bill_rate_override
5685: , itemkey => l_itemkey
5686: , aname => 'BILL_RATE_OVERRIDE'
5687: , avalue => l_assignments_rec.bill_rate_override
5688: );
5689: wf_engine.SetItemAttrText
5690: ( itemtype => l_wf_item_type
5691: , itemkey => l_itemkey
5692: , aname => 'BILL_RATE_OVERRIDE_CURR'
5693: , avalue => l_assignments_rec.bill_rate_curr_override
5692: , aname => 'BILL_RATE_OVERRIDE_CURR'
5693: , avalue => l_assignments_rec.bill_rate_curr_override
5694: );
5695: IF l_assignments_rec.markup_percent_override IS NOT NULL THEN
5696: wf_engine.SetItemAttrText
5697: ( itemtype => l_wf_item_type
5698: , itemkey => l_itemkey
5699: , aname => 'MARKUP_PCT_OVERRIDE'
5700: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
5699: , aname => 'MARKUP_PCT_OVERRIDE'
5700: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
5701: );
5702: ELSE
5703: wf_engine.SetItemAttrText
5704: ( itemtype => l_wf_item_type
5705: , itemkey => l_itemkey
5706: , aname => 'MARKUP_PCT_OVERRIDE'
5707: , avalue => to_char(l_assignments_rec.markup_percent_override)
5706: , aname => 'MARKUP_PCT_OVERRIDE'
5707: , avalue => to_char(l_assignments_rec.markup_percent_override)
5708: );
5709: END IF;
5710: wf_engine.SetItemAttrText
5711: ( itemtype => l_wf_item_type
5712: , itemkey => l_itemkey
5713: , aname => 'TP_AMT_TYPE_NAME'
5714: , avalue => l_assignments_rec.fcst_tp_amount_type_name
5712: , itemkey => l_itemkey
5713: , aname => 'TP_AMT_TYPE_NAME'
5714: , avalue => l_assignments_rec.fcst_tp_amount_type_name
5715: );
5716: wf_engine.SetItemAttrNumber
5717: ( itemtype => l_wf_item_type
5718: , itemkey => l_itemkey
5719: , aname => 'TP_RATE_OVERRIDE'
5720: , avalue => l_assignments_rec.tp_rate_override
5718: , itemkey => l_itemkey
5719: , aname => 'TP_RATE_OVERRIDE'
5720: , avalue => l_assignments_rec.tp_rate_override
5721: );
5722: wf_engine.SetItemAttrText
5723: ( itemtype => l_wf_item_type
5724: , itemkey => l_itemkey
5725: , aname => 'TP_RATE_OVERRIDE_CURR'
5726: , avalue => l_assignments_rec.tp_currency_override
5729: open csr_get_override_basis_name(l_assignments_rec.tp_calc_base_code_override);
5730: fetch csr_get_override_basis_name into l_override_basis_name;
5731: close csr_get_override_basis_name;
5732: END IF;
5733: wf_engine.SetItemAttrText
5734: ( itemtype => l_wf_item_type
5735: , itemkey => l_itemkey
5736: , aname => 'OVERRIDE_BASIS_NAME'
5737: , avalue => l_override_basis_name
5737: , avalue => l_override_basis_name
5738: );
5739: IF l_assignments_rec.tp_percent_applied_override IS NOT NULL THEN
5740: IF l_override_basis_name IS NOT NULL THEN
5741: wf_engine.SetItemAttrText
5742: ( itemtype => l_wf_item_type
5743: , itemkey => l_itemkey
5744: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5745: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5744: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5745: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5746: );
5747: ELSE
5748: wf_engine.SetItemAttrText
5749: ( itemtype => l_wf_item_type
5750: , itemkey => l_itemkey
5751: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5752: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5752: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
5753: );
5754: END IF;
5755: ELSE
5756: wf_engine.SetItemAttrText
5757: ( itemtype => l_wf_item_type
5758: , itemkey => l_itemkey
5759: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5760: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
5759: , aname => 'TP_PCT_APPLIED_OVERRIDE'
5760: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
5761: );
5762: END IF;
5763: wf_engine.SetItemAttrText
5764: ( itemtype => l_wf_item_type
5765: , itemkey => l_itemkey
5766: , aname => 'WORK_TYPE_NAME'
5767: , avalue => l_assignments_rec.work_type_name
5774: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
5775:
5776: THEN
5777:
5778: wf_engine.SetItemAttrDocument
5779: ( itemtype => l_wf_item_type
5780: , itemkey => l_itemkey
5781: , aname => 'UPDATED_INFO_DOC'
5782: , documentid => p_update_info_doc );
5787: --Setting Common attributes for CRN / UPD / APS
5788: --------------------------------------------------------------------
5789:
5790: --Setting Assignment Attributes
5791: wf_engine.SetItemAttrNumber
5792: ( itemtype => l_wf_item_type
5793: , itemkey => l_itemkey
5794: , aname => 'APPROVED_ASSIGNMENTS'
5795: , avalue => p_num_apr_asgns );
5793: , itemkey => l_itemkey
5794: , aname => 'APPROVED_ASSIGNMENTS'
5795: , avalue => p_num_apr_asgns );
5796:
5797: wf_engine.SetItemAttrText
5798: ( itemtype => l_wf_item_type
5799: , itemkey => l_itemkey
5800: , aname => 'SELECTED_ROLES_URL'
5801: , avalue => l_selected_roles_url);
5799: , itemkey => l_itemkey
5800: , aname => 'SELECTED_ROLES_URL'
5801: , avalue => l_selected_roles_url);
5802:
5803: wf_engine.SetItemAttrText
5804: ( itemtype => l_wf_item_type
5805: , itemkey => l_itemkey
5806: , aname => 'SELECTED_ROLES2_URL'
5807: , avalue => l_selected_roles2_url);
5805: , itemkey => l_itemkey
5806: , aname => 'SELECTED_ROLES2_URL'
5807: , avalue => l_selected_roles2_url);
5808:
5809: wf_engine.SetItemAttrNumber
5810: ( itemtype => l_wf_item_type
5811: , itemkey => l_itemkey
5812: , aname => 'REJECTED_ASSIGNMENTS'
5813: , avalue => p_num_rej_asgns );
5812: , aname => 'REJECTED_ASSIGNMENTS'
5813: , avalue => p_num_rej_asgns );
5814:
5815: --Setting Project attributes
5816: wf_engine.SetItemAttrText
5817: ( itemtype => l_wf_item_type
5818: , itemkey => l_itemkey
5819: , aname => 'PROJECT_NAME'
5820: , avalue => p_project_name );
5818: , itemkey => l_itemkey
5819: , aname => 'PROJECT_NAME'
5820: , avalue => p_project_name );
5821:
5822: wf_engine.SetItemAttrText
5823: ( itemtype => l_wf_item_type
5824: , itemkey => l_itemkey
5825: , aname => 'PROJECT_NUMBER'
5826: , avalue => p_project_number );
5824: , itemkey => l_itemkey
5825: , aname => 'PROJECT_NUMBER'
5826: , avalue => p_project_number );
5827:
5828: wf_engine.SetItemAttrText
5829: ( itemtype => l_wf_item_type
5830: , itemkey => l_itemkey
5831: , aname => 'PROJECT_MANAGER_NAME'
5832: , avalue => p_project_manager );
5830: , itemkey => l_itemkey
5831: , aname => 'PROJECT_MANAGER_NAME'
5832: , avalue => p_project_manager );
5833:
5834: wf_engine.SetItemAttrText
5835: ( itemtype => l_wf_item_type
5836: , itemkey => l_itemkey
5837: , aname => 'PROJECT_ORGANIZATION'
5838: , avalue => p_project_org );
5836: , itemkey => l_itemkey
5837: , aname => 'PROJECT_ORGANIZATION'
5838: , avalue => p_project_org );
5839:
5840: wf_engine.SetItemAttrText
5841: ( itemtype => l_wf_item_type
5842: , itemkey => l_itemkey
5843: , aname => 'PROJECT_CUSTOMER'
5844: , avalue => p_project_cus );
5853: l_conflict_url := 'JSP:/OA_HTML/OA.jsp?akRegionApplicationId=275&akRegionCode=PA_VIEW_CONFLICTS_LAYOUT&paProjectId=' ||
5854: l_assignments_rec.project_id || '&paCallingPage=MassAsmtFYINotif&paConflictGroupId=' ||
5855: l_conflict_group_id || '&addBreadCrumb=RP';
5856:
5857: wf_engine.SetItemAttrText
5858: ( itemtype => l_wf_item_type
5859: , itemkey => l_itemkey
5860: , aname => 'CONFLICT_URL'
5861: , avalue => l_conflict_url );
6275: , resp_id => l_responsibility_id
6276: , resp_appl_id => l_resp_appl_id );
6277:
6278: -- Setting thresold value to run the process in background
6279: l_save_threshold := wf_engine.threshold;
6280: wf_engine.threshold := -1;
6281:
6282: -----------------------------------------------------------------------------
6283: --Setting Process Creation / Update / Aproval submission mode for assignments
6276: , resp_appl_id => l_resp_appl_id );
6277:
6278: -- Setting thresold value to run the process in background
6279: l_save_threshold := wf_engine.threshold;
6280: wf_engine.threshold := -1;
6281:
6282: -----------------------------------------------------------------------------
6283: --Setting Process Creation / Update / Aproval submission mode for assignments
6284: -----------------------------------------------------------------------------
6308: INTO l_itemkey
6309: FROM dual;
6310:
6311: -- Create the WF process
6312: wf_engine.CreateProcess
6313: ( ItemType => l_wf_item_type
6314: , ItemKey => l_itemkey
6315: , process => l_wf_process );
6316:
6316:
6317: ------------------------------------------------------------
6318: --Set the item attributes required for manager notifications
6319: ------------------------------------------------------------
6320: wf_engine.SetItemAttrText
6321: ( itemtype => l_wf_item_type
6322: , itemkey => l_itemkey
6323: , aname => 'NTFY_FYI_USER_NAME'
6324: , avalue => l_recipients_tbl(k));
6388:
6389: log_message('After Calling set manager attributes');
6390:
6391: --Start the workflow process
6392: wf_engine.StartProcess ( itemtype => l_wf_item_type
6393: ,itemkey => l_itemkey );
6394:
6395: PA_WORKFLOW_UTILS.Insert_WF_Processes
6396: (p_wf_type_code => 'MASS_ASSIGNMENT_APPROVAL'
6406: END LOOP;--end k loop
6407:
6408:
6409: --Setting the original value
6410: wf_engine.threshold := l_save_threshold;
6411:
6412: -- IF the number of messages is 1 then fetch the message code from
6413: -- the stack and return its text
6414: x_msg_count := FND_MSG_PUB.Count_Msg;
6504:
6505: ---------------------------------------------------
6506: --Get the values required from the item attributes
6507: ---------------------------------------------------
6508: l_project_id := wf_engine.getItemAttrNumber
6509: ( itemtype => itemtype
6510: , itemkey => itemkey
6511: , aname => 'PROJECT_ID' );
6512:
6509: ( itemtype => itemtype
6510: , itemkey => itemkey
6511: , aname => 'PROJECT_ID' );
6512:
6513: l_mode := wf_engine.getItemAttrText
6514: ( itemtype => itemtype
6515: , itemkey => itemkey
6516: , aname => 'MODE' );
6517:
6514: ( itemtype => itemtype
6515: , itemkey => itemkey
6516: , aname => 'MODE' );
6517:
6518: l_group_id := wf_engine.getItemAttrNumber
6519: ( itemtype => itemtype
6520: , itemkey => itemkey
6521: , aname => 'GROUP_ID' );
6522:
6519: ( itemtype => itemtype
6520: , itemkey => itemkey
6521: , aname => 'GROUP_ID' );
6522:
6523: l_approver_group_id := wf_engine.getItemAttrNumber
6524: ( itemtype => itemtype
6525: , itemkey => itemkey
6526: , aname => 'APPROVER_GROUP_ID' );
6527:
6524: ( itemtype => itemtype
6525: , itemkey => itemkey
6526: , aname => 'APPROVER_GROUP_ID' );
6527:
6528: l_routing_order := wf_engine.getItemAttrNumber
6529: ( itemtype => itemtype
6530: , itemkey => itemkey
6531: , aname => 'ROUTING_ORDER' );
6532:
6529: ( itemtype => itemtype
6530: , itemkey => itemkey
6531: , aname => 'ROUTING_ORDER' );
6532:
6533: l_num_assignments := wf_engine.getItemAttrNumber
6534: ( itemtype => itemtype
6535: , itemkey => itemkey
6536: , aname => 'NUMBER_OF_ASSIGNMENTS' );
6537:
6535: , itemkey => itemkey
6536: , aname => 'NUMBER_OF_ASSIGNMENTS' );
6537:
6538: --Get the Update Info document
6539: l_update_info_doc := wf_engine.getItemAttrDocument
6540: ( itemtype => itemtype
6541: , itemkey => itemkey
6542: , aname => 'UPDATED_INFO_DOC' );
6543:
6540: ( itemtype => itemtype
6541: , itemkey => itemkey
6542: , aname => 'UPDATED_INFO_DOC' );
6543:
6544: l_submitter_user_name := wf_engine.getItemAttrText
6545: ( itemtype => itemtype
6546: , itemkey => itemkey
6547: , aname => 'SUBMITTER_UNAME');
6548:
6545: ( itemtype => itemtype
6546: , itemkey => itemkey
6547: , aname => 'SUBMITTER_UNAME');
6548:
6549: l_conflict_group_id := wf_engine.getItemAttrNumber
6550: ( itemtype => itemtype
6551: , itemkey => itemkey
6552: , aname => 'CONFLICT_GROUP_ID' );
6553:
6550: ( itemtype => itemtype
6551: , itemkey => itemkey
6552: , aname => 'CONFLICT_GROUP_ID' );
6553:
6554: l_forwarded_from := wf_engine.getItemAttrText
6555: ( itemtype => itemtype
6556: , itemkey => itemkey
6557: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
6558:
6555: ( itemtype => itemtype
6556: , itemkey => itemkey
6557: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
6558:
6559: l_note_to_approvers := wf_engine.getItemAttrText
6560: ( itemtype => itemtype
6561: , itemkey => itemkey
6562: , aname => 'NOTE_TO_APPROVER');
6563:
6567: --Also get number of approved and rejected assignments
6568: -----------------------------------------------------------
6569: FOR i IN 1..l_num_assignments LOOP
6570: l_assignment_id_tbl.extend;
6571: l_assignment_id_tbl(i) := wf_engine.getItemAttrNumber
6572: ( itemtype => itemtype
6573: ,itemkey => itemkey
6574: ,aname => 'ASSIGNMENT_'|| i );
6575:
6573: ,itemkey => itemkey
6574: ,aname => 'ASSIGNMENT_'|| i );
6575:
6576: l_approval_status_tbl.extend;
6577: l_approval_status_tbl(i) := wf_engine.getItemAttrText
6578: ( itemtype => itemtype
6579: ,itemkey => itemkey
6580: ,aname => 'STATUS_'|| i );
6581: END LOOP;
7411: , resp_id => l_responsibility_id
7412: , resp_appl_id => l_resp_appl_id );
7413:
7414: -- Setting thresold value to run the process in background
7415: l_save_threshold := wf_engine.threshold;
7416: wf_engine.threshold := -1;
7417:
7418: ----------------------------------------------------------------
7419: --Getting all local variables required for workflow attributes
7412: , resp_appl_id => l_resp_appl_id );
7413:
7414: -- Setting thresold value to run the process in background
7415: l_save_threshold := wf_engine.threshold;
7416: wf_engine.threshold := -1;
7417:
7418: ----------------------------------------------------------------
7419: --Getting all local variables required for workflow attributes
7420: ---------------------------------------------------------------
7447:
7448: END IF;
7449:
7450: -- Create the WF process
7451: wf_engine.CreateProcess
7452: ( ItemType => l_wf_item_type
7453: , ItemKey => l_itemkey
7454: , process => l_wf_process );
7455:
7484: END IF;
7485:
7486: CLOSE l_assignments_csr;
7487:
7488: wf_engine.SetItemAttrText
7489: ( itemtype => l_wf_item_type
7490: , itemkey => l_itemkey
7491: , aname => 'ASSIGNMENT_NAME'
7492: , avalue => l_assignments_rec.assignment_name );
7490: , itemkey => l_itemkey
7491: , aname => 'ASSIGNMENT_NAME'
7492: , avalue => l_assignments_rec.assignment_name );
7493:
7494: wf_engine.SetItemAttrText
7495: ( itemtype => l_wf_item_type
7496: , itemkey => l_itemkey
7497: , aname => 'RESOURCE_ORGANIZATION'
7498: , avalue => l_assignments_rec.name );
7496: , itemkey => l_itemkey
7497: , aname => 'RESOURCE_ORGANIZATION'
7498: , avalue => l_assignments_rec.name );
7499:
7500: wf_engine.SetItemAttrNumber
7501: ( itemtype => l_wf_item_type
7502: , itemkey => l_itemkey
7503: , aname => 'ASSIGNMENT_DURATION'
7504: , avalue => (trunc(l_assignments_rec.end_date) -
7503: , aname => 'ASSIGNMENT_DURATION'
7504: , avalue => (trunc(l_assignments_rec.end_date) -
7505: trunc(l_assignments_rec.start_date)+1) );
7506:
7507: wf_engine.SetItemAttrNumber
7508: ( itemtype => l_wf_item_type
7509: , itemkey => l_itemkey
7510: , aname => 'ASSIGNMENT_EFFORT'
7511: , avalue => l_assignments_rec.assignment_effort );
7509: , itemkey => l_itemkey
7510: , aname => 'ASSIGNMENT_EFFORT'
7511: , avalue => l_assignments_rec.assignment_effort );
7512:
7513: wf_engine.SetItemAttrText
7514: ( itemtype => l_wf_item_type
7515: , itemkey => l_itemkey
7516: , aname => 'DESCRIPTION'
7517: , avalue => l_assignments_rec.description );
7515: , itemkey => l_itemkey
7516: , aname => 'DESCRIPTION'
7517: , avalue => l_assignments_rec.description );
7518:
7519: wf_engine.SetItemAttrText
7520: ( itemtype => l_wf_item_type
7521: , itemkey => l_itemkey
7522: , aname => 'ADDITIONAL_INFORMATION'
7523: , avalue => l_assignments_rec.additional_information );
7522: , aname => 'ADDITIONAL_INFORMATION'
7523: , avalue => l_assignments_rec.additional_information );
7524:
7525: -- Start Additions by RM for bug 2274426
7526: wf_engine.SetItemAttrNumber
7527: ( itemtype => l_wf_item_type
7528: , itemkey => l_itemkey
7529: , aname => 'REVENUE_BILL_RATE'
7530: , avalue => l_assignments_rec.revenue_bill_rate
7528: , itemkey => l_itemkey
7529: , aname => 'REVENUE_BILL_RATE'
7530: , avalue => l_assignments_rec.revenue_bill_rate
7531: );
7532: wf_engine.SetItemAttrText
7533: ( itemtype => l_wf_item_type
7534: , itemkey => l_itemkey
7535: , aname => 'REVENUE_BILL_RATE_CURR'
7536: , avalue => l_assignments_rec.revenue_currency_code
7534: , itemkey => l_itemkey
7535: , aname => 'REVENUE_BILL_RATE_CURR'
7536: , avalue => l_assignments_rec.revenue_currency_code
7537: );
7538: wf_engine.SetItemAttrNumber
7539: ( itemtype => l_wf_item_type
7540: , itemkey => l_itemkey
7541: , aname => 'BILL_RATE_OVERRIDE'
7542: , avalue => l_assignments_rec.bill_rate_override
7540: , itemkey => l_itemkey
7541: , aname => 'BILL_RATE_OVERRIDE'
7542: , avalue => l_assignments_rec.bill_rate_override
7543: );
7544: wf_engine.SetItemAttrText
7545: ( itemtype => l_wf_item_type
7546: , itemkey => l_itemkey
7547: , aname => 'BILL_RATE_OVERRIDE_CURR'
7548: , avalue => l_assignments_rec.bill_rate_curr_override
7547: , aname => 'BILL_RATE_OVERRIDE_CURR'
7548: , avalue => l_assignments_rec.bill_rate_curr_override
7549: );
7550: IF l_assignments_rec.markup_percent_override IS NOT NULL THEN
7551: wf_engine.SetItemAttrText
7552: ( itemtype => l_wf_item_type
7553: , itemkey => l_itemkey
7554: , aname => 'MARKUP_PCT_OVERRIDE'
7555: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
7554: , aname => 'MARKUP_PCT_OVERRIDE'
7555: , avalue => to_char(l_assignments_rec.markup_percent_override)||'%'
7556: );
7557: ELSE
7558: wf_engine.SetItemAttrText
7559: ( itemtype => l_wf_item_type
7560: , itemkey => l_itemkey
7561: , aname => 'MARKUP_PCT_OVERRIDE'
7562: , avalue => to_char(l_assignments_rec.markup_percent_override)
7561: , aname => 'MARKUP_PCT_OVERRIDE'
7562: , avalue => to_char(l_assignments_rec.markup_percent_override)
7563: );
7564: END IF;
7565: wf_engine.SetItemAttrText
7566: ( itemtype => l_wf_item_type
7567: , itemkey => l_itemkey
7568: , aname => 'TP_AMT_TYPE_NAME'
7569: , avalue => l_assignments_rec.fcst_tp_amount_type_name
7567: , itemkey => l_itemkey
7568: , aname => 'TP_AMT_TYPE_NAME'
7569: , avalue => l_assignments_rec.fcst_tp_amount_type_name
7570: );
7571: wf_engine.SetItemAttrNumber
7572: ( itemtype => l_wf_item_type
7573: , itemkey => l_itemkey
7574: , aname => 'TP_RATE_OVERRIDE'
7575: , avalue => l_assignments_rec.tp_rate_override
7573: , itemkey => l_itemkey
7574: , aname => 'TP_RATE_OVERRIDE'
7575: , avalue => l_assignments_rec.tp_rate_override
7576: );
7577: wf_engine.SetItemAttrText
7578: ( itemtype => l_wf_item_type
7579: , itemkey => l_itemkey
7580: , aname => 'TP_RATE_OVERRIDE_CURR'
7581: , avalue => l_assignments_rec.tp_currency_override
7584: open csr_get_override_basis_name(l_assignments_rec.tp_calc_base_code_override);
7585: fetch csr_get_override_basis_name into l_override_basis_name;
7586: close csr_get_override_basis_name;
7587: END IF;
7588: wf_engine.SetItemAttrText
7589: ( itemtype => l_wf_item_type
7590: , itemkey => l_itemkey
7591: , aname => 'OVERRIDE_BASIS_NAME'
7592: , avalue => l_override_basis_name
7592: , avalue => l_override_basis_name
7593: );
7594: IF l_assignments_rec.tp_percent_applied_override IS NOT NULL THEN
7595: IF l_override_basis_name IS NOT NULL THEN
7596: wf_engine.SetItemAttrText
7597: ( itemtype => l_wf_item_type
7598: , itemkey => l_itemkey
7599: , aname => 'TP_PCT_APPLIED_OVERRIDE'
7600: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
7599: , aname => 'TP_PCT_APPLIED_OVERRIDE'
7600: , avalue => ', '||to_char(l_assignments_rec.tp_percent_applied_override)||'%'
7601: );
7602: ELSE
7603: wf_engine.SetItemAttrText
7604: ( itemtype => l_wf_item_type
7605: , itemkey => l_itemkey
7606: , aname => 'TP_PCT_APPLIED_OVERRIDE'
7607: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
7607: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)||'%'
7608: );
7609: END IF;
7610: ELSE
7611: wf_engine.SetItemAttrText
7612: ( itemtype => l_wf_item_type
7613: , itemkey => l_itemkey
7614: , aname => 'TP_PCT_APPLIED_OVERRIDE'
7615: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
7614: , aname => 'TP_PCT_APPLIED_OVERRIDE'
7615: , avalue => to_char(l_assignments_rec.tp_percent_applied_override)
7616: );
7617: END IF;
7618: wf_engine.SetItemAttrText
7619: ( itemtype => l_wf_item_type
7620: , itemkey => l_itemkey
7621: , aname => 'WORK_TYPE_NAME'
7622: , avalue => l_assignments_rec.work_type_name
7623: );
7624: -- End of Additions by RM
7625:
7626: --Setting Successful assignments count
7627: wf_engine.SetItemAttrNumber
7628: ( itemtype => l_wf_item_type
7629: , itemkey => l_itemkey
7630: , aname => 'APPROVED_ASSIGNMENTS'
7631: , avalue => p_num_apr_asgns + p_num_rej_asgns);
7635: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_FORECAST_ITEMS OR
7636: p_mode = PA_MASS_ASGMT_TRX.G_MASS_UPDATE_SCHEDULE )
7637:
7638: THEN
7639: wf_engine.SetItemAttrDocument
7640: ( itemtype => l_wf_item_type
7641: , itemkey => l_itemkey
7642: , aname => 'UPDATED_INFO_DOC'
7643: , documentid => p_update_info_doc );
7642: , aname => 'UPDATED_INFO_DOC'
7643: , documentid => p_update_info_doc );
7644:
7645: --Setting Successful assignments count
7646: wf_engine.SetItemAttrNumber
7647: ( itemtype => l_wf_item_type
7648: , itemkey => l_itemkey
7649: , aname => 'APPROVED_ASSIGNMENTS'
7650: , avalue => p_num_apr_asgns + p_num_rej_asgns);
7657:
7658: log_message('Setting common attributes');
7659:
7660: --Setting total assignments count
7661: wf_engine.SetItemAttrNumber
7662: ( itemtype => l_wf_item_type
7663: , itemkey => l_itemkey
7664: , aname => 'NUMBER_OF_ASSIGNMENTS'
7665: , avalue => p_num_apr_asgns + p_num_rej_asgns + l_error_asgns_count);
7664: , aname => 'NUMBER_OF_ASSIGNMENTS'
7665: , avalue => p_num_apr_asgns + p_num_rej_asgns + l_error_asgns_count);
7666:
7667: --Setting failed assignments count
7668: wf_engine.SetItemAttrNumber
7669: ( itemtype => l_wf_item_type
7670: , itemkey => l_itemkey
7671: , aname => 'REJECTED_ASSIGNMENTS'
7672: , avalue => l_error_asgns_count);
7671: , aname => 'REJECTED_ASSIGNMENTS'
7672: , avalue => l_error_asgns_count);
7673:
7674: --Setting Project attributes
7675: wf_engine.SetItemAttrText
7676: ( itemtype => l_wf_item_type
7677: , itemkey => l_itemkey
7678: , aname => 'PROJECT_NAME'
7679: , avalue => p_project_name );
7677: , itemkey => l_itemkey
7678: , aname => 'PROJECT_NAME'
7679: , avalue => p_project_name );
7680:
7681: wf_engine.SetItemAttrText
7682: ( itemtype => l_wf_item_type
7683: , itemkey => l_itemkey
7684: , aname => 'PROJECT_NUMBER'
7685: , avalue => p_project_number );
7683: , itemkey => l_itemkey
7684: , aname => 'PROJECT_NUMBER'
7685: , avalue => p_project_number );
7686:
7687: wf_engine.SetItemAttrText
7688: ( itemtype => l_wf_item_type
7689: , itemkey => l_itemkey
7690: , aname => 'PROJECT_MANAGER_NAME'
7691: , avalue => p_project_manager );
7689: , itemkey => l_itemkey
7690: , aname => 'PROJECT_MANAGER_NAME'
7691: , avalue => p_project_manager );
7692:
7693: wf_engine.SetItemAttrText
7694: ( itemtype => l_wf_item_type
7695: , itemkey => l_itemkey
7696: , aname => 'PROJECT_ORGANIZATION'
7697: , avalue => p_project_org );
7695: , itemkey => l_itemkey
7696: , aname => 'PROJECT_ORGANIZATION'
7697: , avalue => p_project_org );
7698:
7699: wf_engine.SetItemAttrText
7700: ( itemtype => l_wf_item_type
7701: , itemkey => l_itemkey
7702: , aname => 'PROJECT_CUSTOMER'
7703: , avalue => p_project_cus );
7701: , itemkey => l_itemkey
7702: , aname => 'PROJECT_CUSTOMER'
7703: , avalue => p_project_cus );
7704:
7705: wf_engine.SetItemAttrText
7706: ( itemtype => l_wf_item_type
7707: , itemkey => l_itemkey
7708: , aname => 'SUBMITTER_UNAME'
7709: , avalue => p_submitter_user_name);
7711: l_view_errors_url := 'JSP:/OA_HTML/OA.jsp?akRegionCode=PA_ERROR_LAYOUT&akRegionApplicationId=275&paProjectId='
7712: || p_project_id ||'&paSrcType1=MASS_ASSIGNMENT_TRANSACTION&paSrcType2=MASS_APPROVAL&paSrcId1=PAWFAAP&paSrcId2='
7713: || p_group_id || '&addBreadCrumb=RP' ;
7714:
7715: wf_engine.SetItemAttrText
7716: ( itemtype => l_wf_item_type
7717: , itemkey => l_itemkey
7718: , aname => 'VIEW_ERRORS_URL'
7719: , avalue => l_view_errors_url );
7720:
7721: log_message('Staring process for :' || l_wf_item_type || ':' || l_itemkey);
7722:
7723: --Start the workflow process
7724: wf_engine.StartProcess ( itemtype => l_wf_item_type
7725: ,itemkey => l_itemkey );
7726:
7727: PA_WORKFLOW_UTILS.Insert_WF_Processes
7728: (p_wf_type_code => 'MASS_ASSIGNMENT_APPROVAL'
7738: log_message('Out of submitter notification');
7739:
7740:
7741: --Setting the original value
7742: wf_engine.threshold := l_save_threshold;
7743:
7744: -- IF the number of messages is 1 then fetch the message code from
7745: -- the stack and return its text
7746: x_msg_count := FND_MSG_PUB.Count_Msg;
7766: x_return_status := FND_API.G_RET_STS_SUCCESS;
7767: WHEN OTHERS THEN
7768:
7769: --Setting the original value
7770: wf_engine.threshold := l_save_threshold;
7771:
7772: -- Set the excetption Message and the stack
7773: FND_MSG_PUB.add_exc_msg
7774: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_submitter_notification'
7797:
7798: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_approval_type');
7799:
7800: -- Return if WF Not Running
7801: IF (funcmode <> wf_engine.eng_run) THEN
7802: resultout := wf_engine.eng_null;
7803: RETURN;
7804: END IF;
7805:
7798: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_approval_type');
7799:
7800: -- Return if WF Not Running
7801: IF (funcmode <> wf_engine.eng_run) THEN
7802: resultout := wf_engine.eng_null;
7803: RETURN;
7804: END IF;
7805:
7806: l_approval_type := wf_engine.GetItemAttrText
7802: resultout := wf_engine.eng_null;
7803: RETURN;
7804: END IF;
7805:
7806: l_approval_type := wf_engine.GetItemAttrText
7807: (itemtype => itemtype,
7808: itemkey => itemkey,
7809: aname => 'APPROVAL_TYPE');
7810:
7809: aname => 'APPROVAL_TYPE');
7810:
7811: IF l_approval_type = PA_ASGMT_WFSTD.G_MASS_APPROVAL THEN
7812:
7813: resultout := wf_engine.eng_completed||':'||'M';
7814:
7815: ELSIF l_approval_type = PA_ASGMT_WFSTD.G_SINGLE_APPROVAL THEN
7816:
7817: resultout := wf_engine.eng_completed||':'||'S';
7813: resultout := wf_engine.eng_completed||':'||'M';
7814:
7815: ELSIF l_approval_type = PA_ASGMT_WFSTD.G_SINGLE_APPROVAL THEN
7816:
7817: resultout := wf_engine.eng_completed||':'||'S';
7818:
7819: END IF;
7820:
7821: pa_debug.reset_err_stack;
7828: itemtype,
7829: itemkey,
7830: to_char(actid),
7831: funcmode);
7832: resultout := wf_engine.eng_completed||':'||'S';
7833: RAISE;
7834:
7835: END Check_Approval_Type ;
7836:
7879: l_pending_txn_approvals pending_txn_approvals%ROWTYPE;
7880:
7881: BEGIN
7882:
7883: l_group_id := wf_engine.GetItemAttrNumber
7884: (itemtype => itemtype,
7885: itemkey => itemkey,
7886: aname => 'GROUP_ID');
7887:
7884: (itemtype => itemtype,
7885: itemkey => itemkey,
7886: aname => 'GROUP_ID');
7887:
7888: l_approver_group_id := wf_engine.GetItemAttrNumber
7889: (itemtype => itemtype,
7890: itemkey => itemkey,
7891: aname => 'APPROVER_GROUP_ID');
7892:
7889: (itemtype => itemtype,
7890: itemkey => itemkey,
7891: aname => 'APPROVER_GROUP_ID');
7892:
7893: l_routing_order := wf_engine.GetItemAttrNumber
7894: (itemtype => itemtype,
7895: itemkey => itemkey,
7896: aname => 'ROUTING_ORDER');
7897:
7895: itemkey => itemkey,
7896: aname => 'ROUTING_ORDER');
7897:
7898: -- added for bug 5488496
7899: l_ntfy_apprvl_recip_name := wf_engine.getItemAttrText
7900: (itemtype => itemtype,
7901: itemkey => itemkey,
7902: aname => 'NTFY_APPRVL_RECIPIENT_NAME');
7903:
7942: AND ntf.routing_order = l_routing_order
7943: AND ntf.object_id1 = asgn.assignment_id
7944: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
7945:
7946: l_project_id := wf_engine.getItemAttrNumber
7947: ( itemtype => itemtype
7948: , itemkey => itemkey
7949: , aname => 'PROJECT_ID' );
7950:
7947: ( itemtype => itemtype
7948: , itemkey => itemkey
7949: , aname => 'PROJECT_ID' );
7950:
7951: l_mode := wf_engine.getItemAttrText
7952: ( itemtype => itemtype
7953: , itemkey => itemkey
7954: , aname => 'MODE' );
7955:
7955:
7956: l_num_assignments := l_assignment_id_tbl.COUNT;
7957:
7958: --Get the Update Info document
7959: l_update_info_doc := wf_engine.getItemAttrDocument
7960: ( itemtype => itemtype
7961: , itemkey => itemkey
7962: , aname => 'UPDATED_INFO_DOC' );
7963:
7960: ( itemtype => itemtype
7961: , itemkey => itemkey
7962: , aname => 'UPDATED_INFO_DOC' );
7963:
7964: l_submitter_user_name := wf_engine.getItemAttrText
7965: ( itemtype => itemtype
7966: , itemkey => itemkey
7967: , aname => 'SUBMITTER_UNAME');
7968:
7965: ( itemtype => itemtype
7966: , itemkey => itemkey
7967: , aname => 'SUBMITTER_UNAME');
7968:
7969: l_conflict_group_id := wf_engine.getItemAttrNumber
7970: ( itemtype => itemtype
7971: , itemkey => itemkey
7972: , aname => 'CONFLICT_GROUP_ID' );
7973:
7970: ( itemtype => itemtype
7971: , itemkey => itemkey
7972: , aname => 'CONFLICT_GROUP_ID' );
7973:
7974: l_forwarded_from := wf_engine.getItemAttrText
7975: ( itemtype => itemtype
7976: , itemkey => itemkey
7977: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
7978:
7975: ( itemtype => itemtype
7976: , itemkey => itemkey
7977: , aname => 'NTFY_APPRVL_RECIPIENT_NAME');
7978:
7979: l_note_to_approvers := wf_engine.getItemAttrText
7980: ( itemtype => itemtype
7981: , itemkey => itemkey
7982: , aname => 'NOTE_TO_APPROVER');
7983:
8026: log_message('Inside Set_Submitter_User_Name');
8027:
8028:
8029: --get the following wf attributes for the process that errored out.
8030: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8031: itemkey => p_item_key,
8032: aname => 'ERROR_ITEM_TYPE');
8033:
8034: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8030: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8031: itemkey => p_item_key,
8032: aname => 'ERROR_ITEM_TYPE');
8033:
8034: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8035: itemkey => p_item_key,
8036: aname => 'ERROR_ITEM_KEY');
8037:
8038: l_submitter_user_name := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8034: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8035: itemkey => p_item_key,
8036: aname => 'ERROR_ITEM_KEY');
8037:
8038: l_submitter_user_name := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8039: itemkey => l_error_item_key,
8040: aname => 'SUBMITTER_UNAME');
8041:
8042: --SET the Text item attributes (these attributes were created at design time)
8039: itemkey => l_error_item_key,
8040: aname => 'SUBMITTER_UNAME');
8041:
8042: --SET the Text item attributes (these attributes were created at design time)
8043: WF_ENGINE.SetItemAttrText(itemtype => p_item_type,
8044: itemkey => p_item_key,
8045: aname => 'SUBMITTER_UNAME',
8046: avalue => l_submitter_user_name);
8047:
8085: --but we commit 1 at a time, so some of the transactions
8086: --may be complete - so we are only aborting the ones that are not yet processed.
8087:
8088: --get the following wf attributes for the process that errored out.
8089: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8090: itemkey => p_item_key,
8091: aname => 'ERROR_ITEM_TYPE');
8092:
8093: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8089: l_error_item_type := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8090: itemkey => p_item_key,
8091: aname => 'ERROR_ITEM_TYPE');
8092:
8093: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8094: itemkey => p_item_key,
8095: aname => 'ERROR_ITEM_KEY');
8096:
8097: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8093: l_error_item_key := WF_ENGINE.GetItemAttrText(itemtype => p_item_type,
8094: itemkey => p_item_key,
8095: aname => 'ERROR_ITEM_KEY');
8096:
8097: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8098: itemkey => l_error_item_key,
8099: aname => 'PROJECT_ID');
8100:
8101: l_submitter_uname := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8097: l_project_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8098: itemkey => l_error_item_key,
8099: aname => 'PROJECT_ID');
8100:
8101: l_submitter_uname := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8102: itemkey => l_error_item_key,
8103: aname => 'SUBMITTER_UNAME');
8104:
8105: l_group_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8101: l_submitter_uname := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8102: itemkey => l_error_item_key,
8103: aname => 'SUBMITTER_UNAME');
8104:
8105: l_group_id := WF_ENGINE.GetItemAttrText(itemtype => l_error_item_type,
8106: itemkey => l_error_item_key,
8107: aname => 'GROUP_ID');
8108:
8109: SELECT ntf.object_id1