APPS.CS_KB_SOLUTION_PVT dependencies on FND_GLOBAL

Line 42: X_USER_ID := FND_GLOBAL.user_id;

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

Line 43: X_LOGIN_ID := FND_GLOBAL.login_id;

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

Line 861: l_created_by := FND_GLOBAL.user_id;

857: p_data => X_MSG_DATA);
858:
859: ELSE
860: l_date := SYSDATE;
861: l_created_by := FND_GLOBAL.user_id;
862: l_login := FND_GLOBAL.login_id;
863:
864: CS_KB_SETS_PKG.Insert_Row( x_rowid => l_rowid,
865: x_set_id => x_set_id,

Line 862: l_login := FND_GLOBAL.login_id;

858:
859: ELSE
860: l_date := SYSDATE;
861: l_created_by := FND_GLOBAL.user_id;
862: l_login := FND_GLOBAL.login_id;
863:
864: CS_KB_SETS_PKG.Insert_Row( x_rowid => l_rowid,
865: x_set_id => x_set_id,
866: x_set_number => x_set_number,

Line 1102: l_updated_by := FND_GLOBAL.user_id;

1098: ELSE
1099:
1100: --prepare data, THEN insert new set
1101: l_date := SYSDATE;
1102: l_updated_by := FND_GLOBAL.user_id;
1103: l_login := FND_GLOBAL.login_id;
1104:
1105: Get_Lock_Info(p_set_number, l_locked_by, l_lock_date);
1106:

Line 1103: l_login := FND_GLOBAL.login_id;

1099:
1100: --prepare data, THEN insert new set
1101: l_date := SYSDATE;
1102: l_updated_by := FND_GLOBAL.user_id;
1103: l_login := FND_GLOBAL.login_id;
1104:
1105: Get_Lock_Info(p_set_number, l_locked_by, l_lock_date);
1106:
1107: CS_KB_SETS_PKG.Update_Row(

Line 1236: LAST_UPDATED_BY = FND_GLOBAL.user_id,

1232: -- If Dup doesnt already exist
1233: UPDATE CS_KB_SET_ELES
1234: SET ELEMENT_ID = l_dup_element_id,
1235: LAST_UPDATE_DATE = sysdate,
1236: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1237: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1238: WHERE set_id = p_set_id
1239: AND element_id = rec.element_id;
1240:

Line 1237: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1233: UPDATE CS_KB_SET_ELES
1234: SET ELEMENT_ID = l_dup_element_id,
1235: LAST_UPDATE_DATE = sysdate,
1236: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1237: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1238: WHERE set_id = p_set_id
1239: AND element_id = rec.element_id;
1240:
1241: l_delete_status := CS_KB_ELEMENTS_AUDIT_PKG.Delete_Element(rec.element_number);

Line 1345: l_current_user NUMBER := FND_GLOBAL.user_id;

1341: FROM CS_KB_SETS_B
1342: WHERE Set_Id = v_set_id;
1343:
1344: l_default_user NUMBER := -1;
1345: l_current_user NUMBER := FND_GLOBAL.user_id;
1346: l_locked_by NUMBER;
1347: l_flow_details_id NUMBER;
1348: l_latest_set_id NUMBER;
1349: l_status VARCHAR2(30);

Line 1479: l_current_user NUMBER := FND_GLOBAL.user_id;

1475: SELECT Status, locked_by
1476: FROM CS_KB_SETS_B
1477: WHERE Set_Id = v_set_id;
1478:
1479: l_current_user NUMBER := FND_GLOBAL.user_id;
1480: l_locked_by NUMBER;
1481: l_set_number VARCHAR2(30);
1482: l_latest_set_id NUMBER;
1483: l_status VARCHAR2(30);

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

1587: SAVEPOINT MOVE_SOLUTIONS;
1588: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1589: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1591: 'User='||fnd_global.user_id);
1592: END IF;
1593:
1594: --Validate categories' id
1595: Open Is_Category_Existing(P_DEST_CAT_ID);

Line 1651: fnd_global.user_id,

1647: (
1648: l_set_id,
1649: P_DEST_CAT_ID,
1650: sysdate,
1651: fnd_global.user_id,
1652: sysdate,
1653: fnd_global.user_id,
1654: fnd_global.login_id
1655: );

Line 1653: fnd_global.user_id,

1649: P_DEST_CAT_ID,
1650: sysdate,
1651: fnd_global.user_id,
1652: sysdate,
1653: fnd_global.user_id,
1654: fnd_global.login_id
1655: );
1656: end if;
1657: end loop;

Line 1654: fnd_global.login_id

1650: sysdate,
1651: fnd_global.user_id,
1652: sysdate,
1653: fnd_global.user_id,
1654: fnd_global.login_id
1655: );
1656: end if;
1657: end loop;
1658: