DBA Data[Home] [Help]

APPS.PER_PQH_SHR dependencies on WF_EVENT

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

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

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

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

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

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,

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

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

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

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

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

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

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

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

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

Line 765: wf_event.AddParameterToList(

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:

Line 785: wf_event.AddParameterToList(

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: