APPS.WF_LOCAL_SYNCH dependencies on WF_LOCAL_SYNCH

Line 1: package body WF_LOCAL_SYNCH as

1: package body WF_LOCAL_SYNCH as
2: /* $Header: WFLOCALB.pls 120.39.12020000.6 2013/03/24 12:32:41 skandepu ship $ */
3: ------------------------------------------------------------------------------
4: -- Global Private Variables
5:

Line 12: g_modulePkg varchar2(100) := 'wf.plsql.WF_LOCAL_SYNCH';

8: g_logging VARCHAR2(10);
9: g_BaseLanguage VARCHAR2(30) := 'AMERICAN';
10: g_BaseTerritory VARCHAR2(30) := 'AMERICA';
11: g_temptablespace VARCHAR2(30);
12: g_modulePkg varchar2(100) := 'wf.plsql.WF_LOCAL_SYNCH';
13: g_trustedRoles WF_DIRECTORY.roleTable;
14: g_trustTimeStamp DATE;
15:
16: ------------------------------------------------------------------------------

Line 294: WF_CORE.Context('WF_LOCAL_SYNCH', 'seedAttributes', p_origSystem,

290: exception
291: when OTHERS then
292: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
293: 'Exception: '||sqlerrm);
294: WF_CORE.Context('WF_LOCAL_SYNCH', 'seedAttributes', p_origSystem,
295: to_char(p_origSystemID), to_char(p_expDate,
296: WF_CORE.canonical_date_mask));
297: raise;
298:

Line 576: WF_CORE.Context('WF_LOCAL_SYNCH', 'Create_Stage_Indexes',

572:
573: end if;
574:
575:
576: WF_CORE.Context('WF_LOCAL_SYNCH', 'Create_Stage_Indexes',
577: p_sourceTable, p_targetTable);
578: raise;
579:
580: end;

Line 936: wf_local_synch.update_entmgr('USER',

932: -- tell entmgr if linked to an FND user
933: --
934: if (p_orig_system = 'FND_USR') then
935: for myuser in fnd_users loop
936: wf_local_synch.update_entmgr('USER',
937: myuser.user_name,
938: p_attributes,
939: p_orig_system);
940: end loop;

Line 943: wf_local_synch.update_entmgr('USER',

939: p_orig_system);
940: end loop;
941: elsif (p_orig_system = 'PER') then
942: for myuser in linked_per_users loop
943: wf_local_synch.update_entmgr('USER',
944: myuser.user_name,
945: p_attributes,
946: p_orig_system);
947: end loop;

Line 950: wf_local_synch.update_entmgr('USER',

946: p_orig_system);
947: end loop;
948: elsif (p_orig_system = 'HZ_PARTY') then
949: for myuser in linked_tca_users loop
950: wf_local_synch.update_entmgr('USER',
951: myuser.user_name,
952: p_attributes,
953: p_orig_system);
954: end loop;

Line 1075: -- employeeID attribute for every call to WF_LOCAL_SYNCH.

1071: --
1072: -- Second, an FND_USER might be updated to be associated with the employee.
1073: --
1074: -- If there is an employee id, fnd_usr is required to populate the
1075: -- employeeID attribute for every call to WF_LOCAL_SYNCH.
1076: --
1077: -- If there is no employee associated, then employeeID is null.
1078: -- The same will hold true for a dis-association, so we will
1079: -- always need to check for that.

Line 1551: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User',

1547: end if;
1548:
1549: if (g_raiseErrors) then
1550:
1551: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User',
1552: p_orig_system, p_orig_system_id);
1553: raise;
1554:
1555: else

Line 1915: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_Role',

1911: end if;
1912:
1913: if (g_raiseErrors) then
1914:
1915: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_Role',
1916: p_orig_system, p_orig_system_id);
1917: raise;
1918:
1919: else

Line 1981: WF_LOCAL_SYNCH.propagateUserRole(p_user_name=>l_userName,

1977: end if;
1978: end;
1979:
1980: begin
1981: WF_LOCAL_SYNCH.propagateUserRole(p_user_name=>l_userName,
1982: p_role_name=>l_roleName,
1983: p_user_orig_system=>l_origSystem,
1984: p_user_orig_system_id=>l_origSystemID,
1985: p_role_orig_system=>Propagate_user_role.p_role_orig_system,

Line 1996: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User_Role',

1992:
1993: exception
1994: when OTHERS then
1995: if (p_raiseErrors) then
1996: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User_Role',
1997: p_user_orig_system, p_user_orig_system_id,
1998: p_role_orig_system, p_role_orig_system_id);
1999: raise;
2000:

Line 2830: wf_local_synch.BulkSynchronization(p_orig_system,

2826: l_raiseerrors := TRUE;
2827: end if;
2828:
2829:
2830: wf_local_synch.BulkSynchronization(p_orig_system,
2831: to_number(p_parallel_processes),
2832: p_logging,
2833: l_raiseerrors,
2834: l_temptablespace);

Line 3037: -- the previous preference value, if exists call wf_local_synch.Propagate_User

3033:
3034: end loop;
3035:
3036: -- For each DISABLED user/role other than FND or PER, call fnd_preference.get() to get
3037: -- the previous preference value, if exists call wf_local_synch.Propagate_User
3038: -- to reset the notification preference in wf_local_roles table
3039: for user_rec in c_other_users loop
3040:
3041: -- Concatenate username with orig system and orig system id to make it unique

Line 3051: wf_local_synch.Propagate_User(user_rec.orig_system , user_rec.orig_system_id , l_parameterlist);

3047:
3048: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_prev_preference, l_parameterlist);
3049: wf_event.AddParameterToList('USER_NAME', user_rec.name, l_parameterlist);
3050: wf_event.AddParameterToList('RAISEERRORS', 'TRUE', l_parameterlist);
3051: wf_local_synch.Propagate_User(user_rec.orig_system , user_rec.orig_system_id , l_parameterlist);
3052:
3053: -- remove the row from FND_USER_PREFERENCES table after reset
3054: fnd_preference.remove(l_userName, 'WF' , 'PREV_MAILTYPE');
3055:

Line 3078: end WF_LOCAL_SYNCH;

3074: retcode := '2';
3075:
3076: end bulk_reset_ntfPref;
3077:
3078: end WF_LOCAL_SYNCH;