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:
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: --
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:
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;
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:
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;
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:
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