APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on FND_USER

Line 1901: gmaheswa Jul 28, 2005 Modified c_fnd_user_name cursor to validate user from fnd_user instead of wf_user.

1897: Change History
1898: Who When What
1899: ------------------------------------------------------------------------
1900: Don Shellito April 23, 2003 New Procedure Created.
1901: gmaheswa Jul 28, 2005 Modified c_fnd_user_name cursor to validate user from fnd_user instead of wf_user.
1902: pkpatel 10-Mar-2006 Bug 5081932 (Used wf_local_synch instead of private API wf_directory)
1903: ******************************************************************/
1904: PROCEDURE Insert_Local_User_Role (p_api_version IN NUMBER,
1905: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1935: CURSOR c_fnd_user_name IS

1931: -- Define the cursors to be used in procedure.
1932: -- -----------------------------------------------------------------
1933: -- This cursor check what user_id and system are used in wf_users view
1934:
1935: CURSOR c_fnd_user_name IS
1936: SELECT 'X'
1937: FROM fnd_user
1938: WHERE user_name = p_user_name
1939: AND user_id = p_user_orig_system_id;

Line 1937: FROM fnd_user

1933: -- This cursor check what user_id and system are used in wf_users view
1934:
1935: CURSOR c_fnd_user_name IS
1936: SELECT 'X'
1937: FROM fnd_user
1938: WHERE user_name = p_user_name
1939: AND user_id = p_user_orig_system_id;
1940:
1941: BEGIN

Line 1976: -- Check if fnd userid is used.

1972: -- Set the return status to success
1973: -- -----------------------------------------------------------------
1974: x_return_status := FND_API.G_RET_STS_SUCCESS;
1975:
1976: -- Check if fnd userid is used.
1977:
1978: OPEN c_fnd_user_name;
1979: FETCH c_fnd_user_name INTO l_user_found;
1980:

Line 1978: OPEN c_fnd_user_name;

1974: x_return_status := FND_API.G_RET_STS_SUCCESS;
1975:
1976: -- Check if fnd userid is used.
1977:
1978: OPEN c_fnd_user_name;
1979: FETCH c_fnd_user_name INTO l_user_found;
1980:
1981: IF c_fnd_user_name%NOTFOUND THEN
1982:

Line 1979: FETCH c_fnd_user_name INTO l_user_found;

1975:
1976: -- Check if fnd userid is used.
1977:
1978: OPEN c_fnd_user_name;
1979: FETCH c_fnd_user_name INTO l_user_found;
1980:
1981: IF c_fnd_user_name%NOTFOUND THEN
1982:
1983: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_USR_NOT_FOUND');

Line 1981: IF c_fnd_user_name%NOTFOUND THEN

1977:
1978: OPEN c_fnd_user_name;
1979: FETCH c_fnd_user_name INTO l_user_found;
1980:
1981: IF c_fnd_user_name%NOTFOUND THEN
1982:
1983: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_USR_NOT_FOUND');
1984: FND_MSG_PUB.Add;
1985: RAISE FND_API.G_EXC_ERROR;

Line 1989: CLOSE c_fnd_user_name;

1985: RAISE FND_API.G_EXC_ERROR;
1986:
1987: END IF;
1988:
1989: CLOSE c_fnd_user_name;
1990:
1991: wf_local_synch.propagateUserRole(p_user_name => p_user_name,
1992: p_role_name => p_role_name,
1993: p_user_orig_system => p_user_orig_system,