580:
581: Begin
582: hr_utility.set_location('Entered '||l_proc,10);
583:
584: l_entity := wf_event.getvalueforparameter( p_name => 'CONTEXT',
585: p_parameterlist => my_parms);
586:
587: l_event := wf_event.getvalueforparameter( p_name => 'EVENT',
588: p_parameterlist => my_parms);
583:
584: l_entity := wf_event.getvalueforparameter( p_name => 'CONTEXT',
585: p_parameterlist => my_parms);
586:
587: l_event := wf_event.getvalueforparameter( p_name => 'EVENT',
588: p_parameterlist => my_parms);
589:
590: l_datetrack_mode := wf_event.getvalueforparameter( p_name => 'DATETRACK_MODE',
591: p_parameterlist => my_parms);
586:
587: l_event := wf_event.getvalueforparameter( p_name => 'EVENT',
588: p_parameterlist => my_parms);
589:
590: l_datetrack_mode := wf_event.getvalueforparameter( p_name => 'DATETRACK_MODE',
591: p_parameterlist => my_parms);
592:
593: l_assignment_id_can := wf_event.getvalueforparameter( p_name => 'ASSIGNMENT_ID',
594: p_parameterlist => my_parms);
589:
590: l_datetrack_mode := wf_event.getvalueforparameter( p_name => 'DATETRACK_MODE',
591: p_parameterlist => my_parms);
592:
593: l_assignment_id_can := wf_event.getvalueforparameter( p_name => 'ASSIGNMENT_ID',
594: p_parameterlist => my_parms);
595:
596: l_assignment_id := fnd_number.canonical_to_number(l_assignment_id_can);
597:
594: p_parameterlist => my_parms);
595:
596: l_assignment_id := fnd_number.canonical_to_number(l_assignment_id_can);
597:
598: l_user_orig_system := wf_event.getvalueforparameter( p_name => 'USER_ORIG_SYSTEM',
599: p_parameterlist => my_parms);
600:
601: l_user_orig_system_id_can := wf_event.getvalueforparameter( p_name => 'USER_ORIG_SYSTEM_ID',
602: p_parameterlist => my_parms);
597:
598: l_user_orig_system := wf_event.getvalueforparameter( p_name => 'USER_ORIG_SYSTEM',
599: p_parameterlist => my_parms);
600:
601: l_user_orig_system_id_can := wf_event.getvalueforparameter( p_name => 'USER_ORIG_SYSTEM_ID',
602: p_parameterlist => my_parms);
603:
604: l_user_orig_system_id := fnd_number.canonical_to_number(l_user_orig_system_id_can);
605:
602: p_parameterlist => my_parms);
603:
604: l_user_orig_system_id := fnd_number.canonical_to_number(l_user_orig_system_id_can);
605:
606: l_role_orig_system := wf_event.getvalueforparameter( p_name => 'ROLE_ORIG_SYSTEM',
607: p_parameterlist => my_parms);
608:
609: l_role_orig_system_id_can := wf_event.getvalueforparameter( p_name => 'ROLE_ORIG_SYSTEM_ID',
610: p_parameterlist => my_parms);
605:
606: l_role_orig_system := wf_event.getvalueforparameter( p_name => 'ROLE_ORIG_SYSTEM',
607: p_parameterlist => my_parms);
608:
609: l_role_orig_system_id_can := wf_event.getvalueforparameter( p_name => 'ROLE_ORIG_SYSTEM_ID',
610: p_parameterlist => my_parms);
611:
612: l_old_position_id_can := wf_event.getvalueforparameter( p_name => 'OLD_POSITION_ID',
613: p_parameterlist => my_parms);
608:
609: l_role_orig_system_id_can := wf_event.getvalueforparameter( p_name => 'ROLE_ORIG_SYSTEM_ID',
610: p_parameterlist => my_parms);
611:
612: l_old_position_id_can := wf_event.getvalueforparameter( p_name => 'OLD_POSITION_ID',
613: p_parameterlist => my_parms);
614:
615: l_old_position_id := fnd_number.canonical_to_number(l_old_position_id_can);
616:
613: p_parameterlist => my_parms);
614:
615: l_old_position_id := fnd_number.canonical_to_number(l_old_position_id_can);
616:
617: l_user_name := wf_event.getvalueforparameter( p_name => 'USER_NAME',
618: p_parameterlist => my_parms);
619:
620: l_role_orig_system_id := fnd_number.canonical_to_number(l_role_orig_system_id_can);
621:
618: p_parameterlist => my_parms);
619:
620: l_role_orig_system_id := fnd_number.canonical_to_number(l_role_orig_system_id_can);
621:
622: l_start_date_can := wf_event.getvalueforparameter( p_name => 'START_DATE',
623: p_parameterlist => my_parms);
624:
625: l_start_date := fnd_date.canonical_to_date(l_start_date_can);
626:
623: p_parameterlist => my_parms);
624:
625: l_start_date := fnd_date.canonical_to_date(l_start_date_can);
626:
627: l_expiration_date_can := wf_event.getvalueforparameter( p_name => 'EXPIRATION_DATE',
628: p_parameterlist => my_parms);
629:
630: l_expiration_date := fnd_date.canonical_to_date(l_expiration_date_can);
631:
846: l_assg_start_date_canonical := fnd_date.date_to_canonical(greatest(p_rec.effective_start_date,l_usr_strt_date));
847: l_assg_end_date_canonical := fnd_date.date_to_canonical(least(p_rec.effective_end_date,nvl(l_usr_end_date,hr_general.end_of_time)));
848:
849:
850: wf_event.addparametertolist(p_name => 'CONTEXT',
851: p_value => 'POSITION',
852: p_parameterlist => l_plist);
853:
854: wf_event.addparametertolist(p_name => 'EVENT',
850: wf_event.addparametertolist(p_name => 'CONTEXT',
851: p_value => 'POSITION',
852: p_parameterlist => l_plist);
853:
854: wf_event.addparametertolist(p_name => 'EVENT',
855: p_value => p_event,
856: p_parameterlist => l_plist);
857:
858: wf_event.addparametertolist(p_name => 'DATETRACK_MODE',
854: wf_event.addparametertolist(p_name => 'EVENT',
855: p_value => p_event,
856: p_parameterlist => l_plist);
857:
858: wf_event.addparametertolist(p_name => 'DATETRACK_MODE',
859: p_value => p_datetrack_mode,
860: p_parameterlist => l_plist);
861:
862: wf_event.addparametertolist(p_name => 'ASSIGNMENT_ID',
858: wf_event.addparametertolist(p_name => 'DATETRACK_MODE',
859: p_value => p_datetrack_mode,
860: p_parameterlist => l_plist);
861:
862: wf_event.addparametertolist(p_name => 'ASSIGNMENT_ID',
863: p_value => l_assignment_id_canonical,
864: p_parameterlist => l_plist);
865:
866: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM',
862: wf_event.addparametertolist(p_name => 'ASSIGNMENT_ID',
863: p_value => l_assignment_id_canonical,
864: p_parameterlist => l_plist);
865:
866: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM',
867: p_value => 'PER',
868: p_parameterlist => l_plist);
869:
870: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM_ID',
866: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM',
867: p_value => 'PER',
868: p_parameterlist => l_plist);
869:
870: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM_ID',
871: p_value => l_per_id_can,
872: p_parameterlist => l_plist);
873:
874: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM',
870: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM_ID',
871: p_value => l_per_id_can,
872: p_parameterlist => l_plist);
873:
874: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM',
875: p_value => 'POS',
876: p_parameterlist => l_plist);
877:
878: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM_ID',
874: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM',
875: p_value => 'POS',
876: p_parameterlist => l_plist);
877:
878: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM_ID',
879: p_value => l_position_id_canonical,
880: p_parameterlist => l_plist);
881:
882: wf_event.addparametertolist(p_name => 'OLD_POSITION_ID',
878: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM_ID',
879: p_value => l_position_id_canonical,
880: p_parameterlist => l_plist);
881:
882: wf_event.addparametertolist(p_name => 'OLD_POSITION_ID',
883: p_value => l_old_position_id_can,
884: p_parameterlist => l_plist);
885:
886: wf_event.addparametertolist(p_name => 'USER_NAME',
882: wf_event.addparametertolist(p_name => 'OLD_POSITION_ID',
883: p_value => l_old_position_id_can,
884: p_parameterlist => l_plist);
885:
886: wf_event.addparametertolist(p_name => 'USER_NAME',
887: p_value => l_user_name,
888: p_parameterlist => l_plist);
889:
890: wf_event.addparametertolist(p_name => 'START_DATE',
886: wf_event.addparametertolist(p_name => 'USER_NAME',
887: p_value => l_user_name,
888: p_parameterlist => l_plist);
889:
890: wf_event.addparametertolist(p_name => 'START_DATE',
891: p_value => l_assg_start_date_canonical,
892: p_parameterlist => l_plist);
893:
894: wf_event.addparametertolist(p_name => 'EXPIRATION_DATE',
890: wf_event.addparametertolist(p_name => 'START_DATE',
891: p_value => l_assg_start_date_canonical,
892: p_parameterlist => l_plist);
893:
894: wf_event.addparametertolist(p_name => 'EXPIRATION_DATE',
895: p_value => l_assg_end_date_canonical,
896: p_parameterlist => l_plist);
897: hr_utility.set_location(l_proc,96);
898: wf_util.call_me_later(p_callback => 'per_pqh_shr.mysynch_routine',
953: l_assg_start_date_canonical := fnd_date.date_to_canonical(greatest(l_effective_start_date,l_usr_strt_date));
954: l_assg_end_date_canonical := fnd_date.date_to_canonical(least(l_assg_end_date,l_usr_end_date));
955: l_old_position_id_can := fnd_number.number_to_canonical(l_old_pos_id);
956:
957: wf_event.addparametertolist(p_name => 'CONTEXT',
958: p_value => 'POSITION',
959: p_parameterlist => l_plist);
960:
961: wf_event.addparametertolist(p_name => 'EVENT',
957: wf_event.addparametertolist(p_name => 'CONTEXT',
958: p_value => 'POSITION',
959: p_parameterlist => l_plist);
960:
961: wf_event.addparametertolist(p_name => 'EVENT',
962: p_value => p_event,
963: p_parameterlist => l_plist);
964:
965: wf_event.addparametertolist(p_name => 'DATETRACK_MODE',
961: wf_event.addparametertolist(p_name => 'EVENT',
962: p_value => p_event,
963: p_parameterlist => l_plist);
964:
965: wf_event.addparametertolist(p_name => 'DATETRACK_MODE',
966: p_value => p_datetrack_mode,
967: p_parameterlist => l_plist);
968:
969: wf_event.addparametertolist(p_name => 'ASSIGNMENT_ID',
965: wf_event.addparametertolist(p_name => 'DATETRACK_MODE',
966: p_value => p_datetrack_mode,
967: p_parameterlist => l_plist);
968:
969: wf_event.addparametertolist(p_name => 'ASSIGNMENT_ID',
970: p_value => l_assignment_id_canonical,
971: p_parameterlist => l_plist);
972:
973: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM',
969: wf_event.addparametertolist(p_name => 'ASSIGNMENT_ID',
970: p_value => l_assignment_id_canonical,
971: p_parameterlist => l_plist);
972:
973: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM',
974: p_value => 'PER',
975: p_parameterlist => l_plist);
976:
977: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM_ID',
973: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM',
974: p_value => 'PER',
975: p_parameterlist => l_plist);
976:
977: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM_ID',
978: p_value => l_per_id_can,
979: p_parameterlist => l_plist);
980:
981: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM',
977: wf_event.addparametertolist(p_name => 'USER_ORIG_SYSTEM_ID',
978: p_value => l_per_id_can,
979: p_parameterlist => l_plist);
980:
981: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM',
982: p_value => 'POS',
983: p_parameterlist => l_plist);
984:
985: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM_ID',
981: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM',
982: p_value => 'POS',
983: p_parameterlist => l_plist);
984:
985: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM_ID',
986: p_value => l_position_id_canonical,
987: p_parameterlist => l_plist);
988:
989: wf_event.addparametertolist(p_name => 'OLD_POSITION_ID',
985: wf_event.addparametertolist(p_name => 'ROLE_ORIG_SYSTEM_ID',
986: p_value => l_position_id_canonical,
987: p_parameterlist => l_plist);
988:
989: wf_event.addparametertolist(p_name => 'OLD_POSITION_ID',
990: p_value => l_old_position_id_can,
991: p_parameterlist => l_plist);
992:
993: wf_event.addparametertolist(p_name => 'USER_NAME',
989: wf_event.addparametertolist(p_name => 'OLD_POSITION_ID',
990: p_value => l_old_position_id_can,
991: p_parameterlist => l_plist);
992:
993: wf_event.addparametertolist(p_name => 'USER_NAME',
994: p_value => l_user_name,
995: p_parameterlist => l_plist);
996:
997: wf_event.addparametertolist(p_name => 'START_DATE',
993: wf_event.addparametertolist(p_name => 'USER_NAME',
994: p_value => l_user_name,
995: p_parameterlist => l_plist);
996:
997: wf_event.addparametertolist(p_name => 'START_DATE',
998: p_value => l_assg_start_date_canonical,
999: p_parameterlist => l_plist);
1000:
1001: wf_event.addparametertolist(p_name => 'EXPIRATION_DATE',
997: wf_event.addparametertolist(p_name => 'START_DATE',
998: p_value => l_assg_start_date_canonical,
999: p_parameterlist => l_plist);
1000:
1001: wf_event.addparametertolist(p_name => 'EXPIRATION_DATE',
1002: p_value => l_assg_end_date_canonical,
1003: p_parameterlist => l_plist);
1004: hr_utility.set_location(l_proc,96);
1005: wf_util.call_me_later(p_callback => 'per_pqh_shr.mysynch_routine',
1114: open c_per_pos_del(r_person.USER_ORIG_SYSTEM_ID);
1115: fetch c_per_pos_del into l_dummy;
1116: if c_per_pos_del%found then
1117: hr_utility.set_location('WF_SYNC set DELETE parameter true: '||l_proc, 10);
1118: wf_event.AddParameterToList('USER_NAME', r_person.ROLE_NAME,l_plist);
1119: wf_event.AddParameterToList('DELETE', 'TRUE',l_plist);
1120: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
1121: -- synch the wf_local_user table --
1122: hr_utility.set_location('Before deleting WF_SYNC package role_user: '
1115: fetch c_per_pos_del into l_dummy;
1116: if c_per_pos_del%found then
1117: hr_utility.set_location('WF_SYNC set DELETE parameter true: '||l_proc, 10);
1118: wf_event.AddParameterToList('USER_NAME', r_person.ROLE_NAME,l_plist);
1119: wf_event.AddParameterToList('DELETE', 'TRUE',l_plist);
1120: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
1121: -- synch the wf_local_user table --
1122: hr_utility.set_location('Before deleting WF_SYNC package role_user: '
1123: || r_person.USER_NAME, 15);
1116: if c_per_pos_del%found then
1117: hr_utility.set_location('WF_SYNC set DELETE parameter true: '||l_proc, 10);
1118: wf_event.AddParameterToList('USER_NAME', r_person.ROLE_NAME,l_plist);
1119: wf_event.AddParameterToList('DELETE', 'TRUE',l_plist);
1120: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
1121: -- synch the wf_local_user table --
1122: hr_utility.set_location('Before deleting WF_SYNC package role_user: '
1123: || r_person.USER_NAME, 15);
1124: wf_local_synch.propagate_user_role(p_user_orig_system => r_person.USER_ORIG_SYSTEM,
1140: --
1141: -- construct the list of attributes using standard OID att names --
1142: --
1143: hr_utility.set_location('Before calling add parameters: '||l_proc, 20);
1144: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
1145: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
1146: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
1147: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
1148: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
1141: -- construct the list of attributes using standard OID att names --
1142: --
1143: hr_utility.set_location('Before calling add parameters: '||l_proc, 20);
1144: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
1145: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
1146: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
1147: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
1148: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
1149: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
1142: --
1143: hr_utility.set_location('Before calling add parameters: '||l_proc, 20);
1144: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
1145: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
1146: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
1147: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
1148: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
1149: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
1150: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
1143: hr_utility.set_location('Before calling add parameters: '||l_proc, 20);
1144: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
1145: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
1146: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
1147: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
1148: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
1149: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
1150: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
1151: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
1144: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
1145: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
1146: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
1147: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
1148: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
1149: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
1150: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
1151: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
1152:
1145: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
1146: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
1147: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
1148: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
1149: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
1150: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
1151: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
1152:
1153: open c_pos_exists(r_person.ROLE_ORIG_SYSTEM_ID);
1146: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
1147: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
1148: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
1149: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
1150: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
1151: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
1152:
1153: open c_pos_exists(r_person.ROLE_ORIG_SYSTEM_ID);
1154: fetch c_pos_exists into l_dummy_pos;
1147: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
1148: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
1149: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
1150: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
1151: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
1152:
1153: open c_pos_exists(r_person.ROLE_ORIG_SYSTEM_ID);
1154: fetch c_pos_exists into l_dummy_pos;
1155:
1153: open c_pos_exists(r_person.ROLE_ORIG_SYSTEM_ID);
1154: fetch c_pos_exists into l_dummy_pos;
1155:
1156: if c_pos_exists%notfound then
1157: wf_event.AddParameterToList(
1158: p_name => 'USER_NAME',
1159: p_value => r_person.ROLE_NAME,
1160: p_parameterlist => l_plist);
1161:
1173:
1174: if c_user_exists%notfound then
1175: hr_utility.set_location('In Insert WF_SYNC user: '
1176: || r_person.USER_NAME, 25);
1177: wf_event.AddParameterToList(
1178: p_name => 'USER_NAME',
1179: p_value => r_person.USER_NAME,
1180: p_parameterlist => l_plist);
1181: