DBA Data[Home] [Help]

APPS.PER_PQH_SHR dependencies on WF_EVENT

Line 584: l_entity := wf_event.getvalueforparameter( p_name => 'CONTEXT',

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);

Line 587: l_event := wf_event.getvalueforparameter( p_name => 'EVENT',

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);

Line 590: l_datetrack_mode := wf_event.getvalueforparameter( p_name => 'DATETRACK_MODE',

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);

Line 593: l_assignment_id_can := wf_event.getvalueforparameter( p_name => 'ASSIGNMENT_ID',

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:

Line 598: l_user_orig_system := wf_event.getvalueforparameter( p_name => 'USER_ORIG_SYSTEM',

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);

Line 601: l_user_orig_system_id_can := wf_event.getvalueforparameter( p_name => 'USER_ORIG_SYSTEM_ID',

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:

Line 606: l_role_orig_system := wf_event.getvalueforparameter( p_name => 'ROLE_ORIG_SYSTEM',

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);

Line 609: l_role_orig_system_id_can := wf_event.getvalueforparameter( p_name => 'ROLE_ORIG_SYSTEM_ID',

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);

Line 612: l_old_position_id_can := wf_event.getvalueforparameter( p_name => 'OLD_POSITION_ID',

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:

Line 617: l_user_name := wf_event.getvalueforparameter( p_name => 'USER_NAME',

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:

Line 622: l_start_date_can := wf_event.getvalueforparameter( p_name => 'START_DATE',

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:

Line 627: l_expiration_date_can := wf_event.getvalueforparameter( p_name => 'EXPIRATION_DATE',

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:

Line 850: wf_event.addparametertolist(p_name => 'CONTEXT',

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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 957: wf_event.addparametertolist(p_name => 'CONTEXT',

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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 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',

Line 1118: wf_event.AddParameterToList('USER_NAME', r_person.ROLE_NAME,l_plist);

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: '

Line 1119: wf_event.AddParameterToList('DELETE', 'TRUE',l_plist);

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);

Line 1120: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);

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,

Line 1144: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);

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);

Line 1145: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,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);

Line 1146: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, 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);

Line 1147: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,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);

Line 1148: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, 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:

Line 1149: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, 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:
1153: open c_pos_exists(r_person.ROLE_ORIG_SYSTEM_ID);

Line 1150: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',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);
1154: fetch c_pos_exists into l_dummy_pos;

Line 1151: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', 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;
1155:

Line 1157: wf_event.AddParameterToList(

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:

Line 1177: wf_event.AddParameterToList(

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: