APPS.CS_KB_SOLUTION_PVT dependencies on FND_GLOBAL

Line 44: X_USER_ID := FND_GLOBAL.user_id;

40: IS
41: BEGIN
42:
43: X_SYSDATE := SYSDATE;
44: X_USER_ID := FND_GLOBAL.user_id;
45: X_LOGIN_ID := FND_GLOBAL.login_id;
46:
47: END Get_Who;
48:

Line 45: X_LOGIN_ID := FND_GLOBAL.login_id;

41: BEGIN
42:
43: X_SYSDATE := SYSDATE;
44: X_USER_ID := FND_GLOBAL.user_id;
45: X_LOGIN_ID := FND_GLOBAL.login_id;
46:
47: END Get_Who;
48:
49: PROCEDURE Get_Set_Details(

Line 875: l_created_by := FND_GLOBAL.user_id;

871: p_data => X_MSG_DATA);
872:
873: ELSE
874: l_date := SYSDATE;
875: l_created_by := FND_GLOBAL.user_id;
876: l_login := FND_GLOBAL.login_id;
877:
878: CS_KB_SETS_PKG.Insert_Row( x_rowid => l_rowid,
879: x_set_id => x_set_id,

Line 876: l_login := FND_GLOBAL.login_id;

872:
873: ELSE
874: l_date := SYSDATE;
875: l_created_by := FND_GLOBAL.user_id;
876: l_login := FND_GLOBAL.login_id;
877:
878: CS_KB_SETS_PKG.Insert_Row( x_rowid => l_rowid,
879: x_set_id => x_set_id,
880: x_set_number => x_set_number,

Line 1116: l_updated_by := FND_GLOBAL.user_id;

1112: ELSE
1113:
1114: --prepare data, THEN insert new set
1115: l_date := SYSDATE;
1116: l_updated_by := FND_GLOBAL.user_id;
1117: l_login := FND_GLOBAL.login_id;
1118:
1119: Get_Lock_Info(p_set_number, l_locked_by, l_lock_date);
1120:

Line 1117: l_login := FND_GLOBAL.login_id;

1113:
1114: --prepare data, THEN insert new set
1115: l_date := SYSDATE;
1116: l_updated_by := FND_GLOBAL.user_id;
1117: l_login := FND_GLOBAL.login_id;
1118:
1119: Get_Lock_Info(p_set_number, l_locked_by, l_lock_date);
1120:
1121: CS_KB_SETS_PKG.Update_Row(

Line 1250: LAST_UPDATED_BY = FND_GLOBAL.user_id,

1246: -- If Dup doesnt already exist
1247: UPDATE CS_KB_SET_ELES
1248: SET ELEMENT_ID = l_dup_element_id,
1249: LAST_UPDATE_DATE = sysdate,
1250: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1251: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1252: WHERE set_id = p_set_id
1253: AND element_id = rec.element_id;
1254:

Line 1251: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1247: UPDATE CS_KB_SET_ELES
1248: SET ELEMENT_ID = l_dup_element_id,
1249: LAST_UPDATE_DATE = sysdate,
1250: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1251: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1252: WHERE set_id = p_set_id
1253: AND element_id = rec.element_id;
1254:
1255: l_delete_status := CS_KB_ELEMENTS_AUDIT_PKG.Delete_Element(rec.element_number);

Line 1359: l_current_user NUMBER := FND_GLOBAL.user_id;

1355: FROM CS_KB_SETS_B
1356: WHERE Set_Id = v_set_id;
1357:
1358: l_default_user NUMBER := -1;
1359: l_current_user NUMBER := FND_GLOBAL.user_id;
1360: l_locked_by NUMBER;
1361: l_flow_details_id NUMBER;
1362: l_latest_set_id NUMBER;
1363: l_status VARCHAR2(30);

Line 1493: l_current_user NUMBER := FND_GLOBAL.user_id;

1489: SELECT Status, locked_by
1490: FROM CS_KB_SETS_B
1491: WHERE Set_Id = v_set_id;
1492:
1493: l_current_user NUMBER := FND_GLOBAL.user_id;
1494: l_locked_by NUMBER;
1495: l_set_number VARCHAR2(30);
1496: l_latest_set_id NUMBER;
1497: l_status VARCHAR2(30);

Line 1605: 'User='||fnd_global.user_id);

1601: SAVEPOINT MOVE_SOLUTIONS;
1602: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1603: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1605: 'User='||fnd_global.user_id);
1606: END IF;
1607:
1608: --Validate categories' id
1609: Open Is_Category_Existing(P_DEST_CAT_ID);

Line 1665: fnd_global.user_id,

1661: (
1662: l_set_id,
1663: P_DEST_CAT_ID,
1664: sysdate,
1665: fnd_global.user_id,
1666: sysdate,
1667: fnd_global.user_id,
1668: fnd_global.login_id
1669: );

Line 1667: fnd_global.user_id,

1663: P_DEST_CAT_ID,
1664: sysdate,
1665: fnd_global.user_id,
1666: sysdate,
1667: fnd_global.user_id,
1668: fnd_global.login_id
1669: );
1670: end if;
1671: end loop;

Line 1668: fnd_global.login_id

1664: sysdate,
1665: fnd_global.user_id,
1666: sysdate,
1667: fnd_global.user_id,
1668: fnd_global.login_id
1669: );
1670: end if;
1671: end loop;
1672: