DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on FND_GLOBAL

Line 792: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

788: USER_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
789: ROLE_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
790: USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
791: ROLE_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
792: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
793: LAST_UPDATE_DATE = SYSDATE,
794: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
795: where rowid = l_rowIDTAB(tabIndex);
796: else --donot touch the WHO columns. This is default behavior

Line 794: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

790: USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
791: ROLE_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
792: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
793: LAST_UPDATE_DATE = SYSDATE,
794: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
795: where rowid = l_rowIDTAB(tabIndex);
796: else --donot touch the WHO columns. This is default behavior
797: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST save exceptions
798: update WF_USER_ROLE_ASSIGNMENTS

Line 849: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

845: EFFECTIVE_START_DATE = nvl(l_StartSrcTAB(tabIndex),
846: to_date(1,'J')),
847: EFFECTIVE_END_DATE = nvl(l_EndSrcTAB(tabIndex),
848: to_date('9999/01/01', 'YYYY/MM/DD')),
849: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
850: LAST_UPDATE_DATE = SYSDATE,
851: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
852: where rowid = l_rowIDSrcTAB(tabIndex);
853: else --donot touch the WHO columns. This is default behavior

Line 851: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

847: EFFECTIVE_END_DATE = nvl(l_EndSrcTAB(tabIndex),
848: to_date('9999/01/01', 'YYYY/MM/DD')),
849: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
850: LAST_UPDATE_DATE = SYSDATE,
851: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
852: where rowid = l_rowIDSrcTAB(tabIndex);
853: else --donot touch the WHO columns. This is default behavior
854: forall tabIndex in l_rowIDSrcTAB.FIRST..l_rowIDSrcTAB.LAST save exceptions
855: update wf_local_user_roles partition (FND_USR)

Line 1090: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1086: USER_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
1087: ROLE_ORIG_SYSTEM=l_roleOrigSrcTAB(tabIndex),
1088: USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
1089: ROLE_ORIG_SYSTEM_ID=l_roleOrigIDSrcTAB(tabIndex),
1090: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1091: LAST_UPDATE_DATE = SYSDATE,
1092: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1093: where rowid = l_rowIDTAB(tabIndex);
1094: else --Donot touch WHO columns. This is default behavior

Line 1092: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1088: USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
1089: ROLE_ORIG_SYSTEM_ID=l_roleOrigIDSrcTAB(tabIndex),
1090: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1091: LAST_UPDATE_DATE = SYSDATE,
1092: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1093: where rowid = l_rowIDTAB(tabIndex);
1094: else --Donot touch WHO columns. This is default behavior
1095: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
1096: update WF_USER_ROLE_ASSIGNMENTS

Line 1146: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1142: EXPIRATION_DATE = l_endDestTAB(destTabIndex),
1143: EFFECTIVE_START_DATE = l_effStartDestTAB(destTabIndex),
1144: EFFECTIVE_END_DATE = l_effEndDestTAB(destTabIndex),
1145: ASSIGNMENT_TYPE = l_assignTAB(destTabIndex),
1146: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1147: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,
1148: LAST_UPDATE_DATE = SYSDATE
1149: WHERE rowid = l_rowIDDestTAB(destTabIndex);
1150: else --Do not touch WHO columns. This is default behavior

Line 1147: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,

1143: EFFECTIVE_START_DATE = l_effStartDestTAB(destTabIndex),
1144: EFFECTIVE_END_DATE = l_effEndDestTAB(destTabIndex),
1145: ASSIGNMENT_TYPE = l_assignTAB(destTabIndex),
1146: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1147: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,
1148: LAST_UPDATE_DATE = SYSDATE
1149: WHERE rowid = l_rowIDDestTAB(destTabIndex);
1150: else --Do not touch WHO columns. This is default behavior
1151: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST

Line 1317: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1313: EFFECTIVE_END_DATE = l_effEndDestTAB(destTabIndex),
1314: START_DATE = l_startDestTAB(destTabIndex),
1315: EXPIRATION_DATE = l_endDestTAB(destTabIndex),
1316: ASSIGNMENT_TYPE = l_assignTAB(destTabIndex),
1317: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1318: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,
1319: LAST_UPDATE_DATE = SYSDATE
1320: WHERE rowid = l_rowIDDestTAB(destTabIndex);
1321: else --Do not touch WHO columns. This is default behavior.

Line 1318: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,

1314: START_DATE = l_startDestTAB(destTabIndex),
1315: EXPIRATION_DATE = l_endDestTAB(destTabIndex),
1316: ASSIGNMENT_TYPE = l_assignTAB(destTabIndex),
1317: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1318: LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,
1319: LAST_UPDATE_DATE = SYSDATE
1320: WHERE rowid = l_rowIDDestTAB(destTabIndex);
1321: else --Do not touch WHO columns. This is default behavior.
1322: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST