DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on FND_GLOBAL

Line 1403: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1399: USER_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
1400: ROLE_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
1401: USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
1402: ROLE_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
1403: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1404: LAST_UPDATE_DATE = SYSDATE,
1405: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1406: where rowid = l_rowIDTAB(tabIndex);
1407: else --donot touch the WHO columns. This is default behavior

Line 1405: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1401: USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
1402: ROLE_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
1403: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1404: LAST_UPDATE_DATE = SYSDATE,
1405: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1406: where rowid = l_rowIDTAB(tabIndex);
1407: else --donot touch the WHO columns. This is default behavior
1408: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST save exceptions
1409: update WF_USER_ROLE_ASSIGNMENTS

Line 1460: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1456: EFFECTIVE_START_DATE = nvl(l_StartSrcTAB(tabIndex),
1457: to_date(1,'J')),
1458: EFFECTIVE_END_DATE = nvl(l_EndSrcTAB(tabIndex),
1459: to_date('9999/01/01', 'YYYY/MM/DD')),
1460: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1461: LAST_UPDATE_DATE = SYSDATE,
1462: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1463: where rowid = l_rowIDSrcTAB(tabIndex);
1464: else --donot touch the WHO columns. This is default behavior

Line 1462: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1458: EFFECTIVE_END_DATE = nvl(l_EndSrcTAB(tabIndex),
1459: to_date('9999/01/01', 'YYYY/MM/DD')),
1460: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1461: LAST_UPDATE_DATE = SYSDATE,
1462: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1463: where rowid = l_rowIDSrcTAB(tabIndex);
1464: else --donot touch the WHO columns. This is default behavior
1465: forall tabIndex in l_rowIDSrcTAB.FIRST..l_rowIDSrcTAB.LAST save exceptions
1466: update wf_local_user_roles partition (FND_USR)

Line 1704: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1700: USER_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
1701: ROLE_ORIG_SYSTEM=l_roleOrigSrcTAB(tabIndex),
1702: USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
1703: ROLE_ORIG_SYSTEM_ID=l_roleOrigIDSrcTAB(tabIndex),
1704: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1705: LAST_UPDATE_DATE = SYSDATE,
1706: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1707: where rowid = l_rowIDTAB(tabIndex);
1708: else --Donot touch WHO columns. This is default behavior

Line 1706: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1702: USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
1703: ROLE_ORIG_SYSTEM_ID=l_roleOrigIDSrcTAB(tabIndex),
1704: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1705: LAST_UPDATE_DATE = SYSDATE,
1706: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1707: where rowid = l_rowIDTAB(tabIndex);
1708: else --Donot touch WHO columns. This is default behavior
1709: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
1710: update WF_USER_ROLE_ASSIGNMENTS

Line 1760: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1756: EXPIRATION_DATE = l_endDestTAB(destTabIndex),
1757: EFFECTIVE_START_DATE = l_effStartDestTAB(destTabIndex),
1758: EFFECTIVE_END_DATE = l_effEndDestTAB(destTabIndex),
1759: ASSIGNMENT_TYPE = l_assignTAB(destTabIndex),
1760: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1761: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,
1762: LAST_UPDATE_DATE = SYSDATE
1763: WHERE rowid = l_rowIDDestTAB(destTabIndex);
1764: else --Do not touch WHO columns. This is default behavior

Line 1761: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,

1757: EFFECTIVE_START_DATE = l_effStartDestTAB(destTabIndex),
1758: EFFECTIVE_END_DATE = l_effEndDestTAB(destTabIndex),
1759: ASSIGNMENT_TYPE = l_assignTAB(destTabIndex),
1760: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1761: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,
1762: LAST_UPDATE_DATE = SYSDATE
1763: WHERE rowid = l_rowIDDestTAB(destTabIndex);
1764: else --Do not touch WHO columns. This is default behavior
1765: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST

Line 1931: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1927: EFFECTIVE_END_DATE = l_effEndDestTAB(destTabIndex),
1928: START_DATE = l_startDestTAB(destTabIndex),
1929: EXPIRATION_DATE = l_endDestTAB(destTabIndex),
1930: ASSIGNMENT_TYPE = l_assignTAB(destTabIndex),
1931: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1932: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,
1933: LAST_UPDATE_DATE = SYSDATE
1934: WHERE rowid = l_rowIDDestTAB(destTabIndex);
1935: else --Do not touch WHO columns. This is default behavior.

Line 1932: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,

1928: START_DATE = l_startDestTAB(destTabIndex),
1929: EXPIRATION_DATE = l_endDestTAB(destTabIndex),
1930: ASSIGNMENT_TYPE = l_assignTAB(destTabIndex),
1931: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1932: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,
1933: LAST_UPDATE_DATE = SYSDATE
1934: WHERE rowid = l_rowIDDestTAB(destTabIndex);
1935: else --Do not touch WHO columns. This is default behavior.
1936: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST