DBA Data[Home] [Help]

APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on FND_GLOBAL

Line 180: x_user_id := FND_GLOBAL.user_id;

176: X_LOGIN_ID OUT NOCOPY NUMBER)
177: IS
178: BEGIN
179: x_sysdate := SYSDATE;
180: x_user_id := FND_GLOBAL.user_id;
181: x_login_id := FND_GLOBAL.login_id;
182: END Get_Who;
183:
184:

Line 181: x_login_id := FND_GLOBAL.login_id;

177: IS
178: BEGIN
179: x_sysdate := SYSDATE;
180: x_user_id := FND_GLOBAL.user_id;
181: x_login_id := FND_GLOBAL.login_id;
182: END Get_Who;
183:
184:
185: --

Line 1149: se.LAST_UPDATED_BY = FND_GLOBAL.user_id,

1145:
1146: UPDATE CS_KB_SET_ELES se
1147: SET se.ELEMENT_ID = l_dup_id,
1148: se.LAST_UPDATE_DATE = sysdate,
1149: se.LAST_UPDATED_BY = FND_GLOBAL.user_id,
1150: se.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1151: WHERE se.Element_Id = P_ELEMENT_ID
1152: AND se.Set_Id = solns.Set_Id;
1153:

Line 1150: se.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1146: UPDATE CS_KB_SET_ELES se
1147: SET se.ELEMENT_ID = l_dup_id,
1148: se.LAST_UPDATE_DATE = sysdate,
1149: se.LAST_UPDATED_BY = FND_GLOBAL.user_id,
1150: se.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1151: WHERE se.Element_Id = P_ELEMENT_ID
1152: AND se.Set_Id = solns.Set_Id;
1153:
1154: END LOOP;

Line 1331: se.LAST_UPDATED_BY = FND_GLOBAL.user_id,

1327:
1328: UPDATE CS_KB_SET_ELES se
1329: SET se.ELEMENT_ID = l_new_element_id,
1330: se.LAST_UPDATE_DATE = sysdate,
1331: se.LAST_UPDATED_BY = FND_GLOBAL.user_id,
1332: se.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1333: WHERE se.Element_Id = P_ELEMENT_ID
1334: AND se.Set_Id = solns.Set_Id;
1335:

Line 1332: se.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1328: UPDATE CS_KB_SET_ELES se
1329: SET se.ELEMENT_ID = l_new_element_id,
1330: se.LAST_UPDATE_DATE = sysdate,
1331: se.LAST_UPDATED_BY = FND_GLOBAL.user_id,
1332: se.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1333: WHERE se.Element_Id = P_ELEMENT_ID
1334: AND se.Set_Id = solns.Set_Id;
1335:
1336: END LOOP;

Line 1410: l_user NUMBER := FND_GLOBAL.User_Id;

1406: AND S.Status <> 'OBS'
1407: AND (S.Latest_Version_Flag = 'Y' OR S.Viewable_Version_Flag = 'Y')
1408: );
1409:
1410: l_user NUMBER := FND_GLOBAL.User_Id;
1411: l_login NUMBER := FND_GLOBAL.Login_Id;
1412:
1413: BEGIN
1414:

Line 1411: l_login NUMBER := FND_GLOBAL.Login_Id;

1407: AND (S.Latest_Version_Flag = 'Y' OR S.Viewable_Version_Flag = 'Y')
1408: );
1409:
1410: l_user NUMBER := FND_GLOBAL.User_Id;
1411: l_login NUMBER := FND_GLOBAL.Login_Id;
1412:
1413: BEGIN
1414:
1415: FOR Statements IN GET_ORPHANS LOOP