DBA Data[Home] [Help]

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.30.12010000.2 2008/08/26 20:35:26 alepe 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 574: WF_CORE.Context('WF_LOCAL_SYNCH', 'Create_Stage_Indexes',

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

Line 932: wf_local_synch.update_entmgr('USER',

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

Line 939: wf_local_synch.update_entmgr('USER',

935: p_orig_system);
936: end loop;
937: elsif (p_orig_system = 'PER') then
938: for myuser in linked_per_users loop
939: wf_local_synch.update_entmgr('USER',
940: myuser.user_name,
941: p_attributes,
942: p_orig_system);
943: end loop;

Line 946: wf_local_synch.update_entmgr('USER',

942: p_orig_system);
943: end loop;
944: elsif (p_orig_system = 'HZ_PARTY') then
945: for myuser in linked_tca_users loop
946: wf_local_synch.update_entmgr('USER',
947: myuser.user_name,
948: p_attributes,
949: p_orig_system);
950: end loop;

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

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

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

1539: 'Exception: '||sqlerrm);
1540:
1541: end if;
1542:
1543: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User',
1544: p_orig_system, p_orig_system_id);
1545: raise;
1546:
1547: else

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

1861: 'Exception: '||sqlerrm);
1862:
1863: end if;
1864:
1865: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_Role',
1866: p_orig_system, p_orig_system_id);
1867: raise;
1868:
1869: else

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

1927: end if;
1928: end;
1929:
1930: begin
1931: WF_LOCAL_SYNCH.propagateUserRole(p_user_name=>l_userName,
1932: p_role_name=>l_roleName,
1933: p_user_orig_system=>l_origSystem,
1934: p_user_orig_system_id=>l_origSystemID,
1935: p_role_orig_system=>Propagate_user_role.p_role_orig_system,

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

1942:
1943: exception
1944: when OTHERS then
1945: if (p_raiseErrors) then
1946: WF_CORE.Context('WF_LOCAL_SYNCH', 'Propagate_User_Role',
1947: p_user_orig_system, p_user_orig_system_id,
1948: p_role_orig_system, p_role_orig_system_id);
1949: raise;
1950:

Line 2764: wf_local_synch.BulkSynchronization(p_orig_system,

2760: l_raiseerrors := TRUE;
2761: end if;
2762:
2763:
2764: wf_local_synch.BulkSynchronization(p_orig_system,
2765: to_number(p_parallel_processes),
2766: p_logging,
2767: l_raiseerrors,
2768: l_temptablespace);

Line 2907: end WF_LOCAL_SYNCH;

2903: when OTHERS then
2904: retcode := '2'; -- (error)
2905: errbuf := sqlerrm;
2906: end;
2907: end WF_LOCAL_SYNCH;