722: open c_per_pos_del(r_person.USER_ORIG_SYSTEM_ID);
723: fetch c_per_pos_del into l_dummy;
724: if c_per_pos_del%found then
725: hr_utility.set_location('WF_SYNC set DELETE parameter true: '||l_proc, 10);
726: wf_event.AddParameterToList('USER_NAME', r_person.ROLE_NAME,l_plist);
727: wf_event.AddParameterToList('DELETE', 'TRUE',l_plist);
728: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
729: -- synch the wf_local_user table --
730: hr_utility.set_location('Before deleting WF_SYNC package role_user: '
723: fetch c_per_pos_del into l_dummy;
724: if c_per_pos_del%found then
725: hr_utility.set_location('WF_SYNC set DELETE parameter true: '||l_proc, 10);
726: wf_event.AddParameterToList('USER_NAME', r_person.ROLE_NAME,l_plist);
727: wf_event.AddParameterToList('DELETE', 'TRUE',l_plist);
728: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
729: -- synch the wf_local_user table --
730: hr_utility.set_location('Before deleting WF_SYNC package role_user: '
731: || r_person.USER_NAME, 15);
724: if c_per_pos_del%found then
725: hr_utility.set_location('WF_SYNC set DELETE parameter true: '||l_proc, 10);
726: wf_event.AddParameterToList('USER_NAME', r_person.ROLE_NAME,l_plist);
727: wf_event.AddParameterToList('DELETE', 'TRUE',l_plist);
728: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
729: -- synch the wf_local_user table --
730: hr_utility.set_location('Before deleting WF_SYNC package role_user: '
731: || r_person.USER_NAME, 15);
732: wf_local_synch.propagate_user_role(p_user_orig_system => r_person.USER_ORIG_SYSTEM,
748: --
749: -- construct the list of attributes using standard OID att names --
750: --
751: hr_utility.set_location('Before calling add parameters: '||l_proc, 20);
752: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
753: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
754: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
755: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
756: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
749: -- construct the list of attributes using standard OID att names --
750: --
751: hr_utility.set_location('Before calling add parameters: '||l_proc, 20);
752: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
753: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
754: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
755: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
756: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
757: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
750: --
751: hr_utility.set_location('Before calling add parameters: '||l_proc, 20);
752: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
753: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
754: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
755: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
756: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
757: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
758: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
751: hr_utility.set_location('Before calling add parameters: '||l_proc, 20);
752: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
753: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
754: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
755: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
756: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
757: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
758: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
759: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
752: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
753: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
754: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
755: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
756: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
757: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
758: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
759: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
760:
753: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
754: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
755: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
756: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
757: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
758: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
759: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
760:
761: open c_pos_exists(r_person.ROLE_ORIG_SYSTEM_ID);
754: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
755: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
756: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
757: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
758: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
759: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
760:
761: open c_pos_exists(r_person.ROLE_ORIG_SYSTEM_ID);
762: fetch c_pos_exists into l_dummy_pos;
755: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);
756: wf_event.AddParameterToList( 'orclNLSTerritory', r_person.TERRITORY, l_plist);
757: wf_event.AddParameterToList( 'orclIsEnabled', r_person.STATUS, l_plist);
758: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
759: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
760:
761: open c_pos_exists(r_person.ROLE_ORIG_SYSTEM_ID);
762: fetch c_pos_exists into l_dummy_pos;
763:
761: open c_pos_exists(r_person.ROLE_ORIG_SYSTEM_ID);
762: fetch c_pos_exists into l_dummy_pos;
763:
764: if c_pos_exists%notfound then
765: wf_event.AddParameterToList(
766: p_name => 'USER_NAME',
767: p_value => r_person.ROLE_NAME,
768: p_parameterlist => l_plist);
769:
781:
782: if c_user_exists%notfound then
783: hr_utility.set_location('In Insert WF_SYNC user: '
784: || r_person.USER_NAME, 25);
785: wf_event.AddParameterToList(
786: p_name => 'USER_NAME',
787: p_value => r_person.USER_NAME,
788: p_parameterlist => l_plist);
789: