APPS.CSF_RESOURCE_PUB dependencies on FND_GLOBAL

Line 2114: * (FND_GLOBAL.USER_ID).

2110: /**
2111: * Returns the ID of the Resource tied to the given User (FND User).
2112: *
2113: * If no User is passed in, then it will take the User who has logged in
2114: * (FND_GLOBAL.USER_ID).
2115: *
2116: * @param p_user_id Identifier to the User desired (Optional)
2117: * @returns Resource ID (NUMBER)
2118: */

Line 2124: WHERE user_id = NVL(p_user_id, fnd_global.user_id);

2120: RETURN NUMBER IS
2121: CURSOR c_resource IS
2122: SELECT resource_id
2123: FROM jtf_rs_resource_extns
2124: WHERE user_id = NVL(p_user_id, fnd_global.user_id);
2125: l_id NUMBER := NULL;
2126: BEGIN
2127: OPEN c_resource;
2128: FETCH c_resource INTO l_id;

Line 2138: * (FND_GLOBAL.USER_ID).

2134: /**
2135: * Returns the Resource Type of the Resource tied to the given user. (FND User)
2136: *
2137: * If no User is passed in, then it will take the User who has logged in
2138: * (FND_GLOBAL.USER_ID).
2139: *
2140: * @param p_user_id Identifier to the User desired (Optional)
2141: * @returns Resource Type (VARCHAR2)
2142: */

Line 2148: WHERE user_id = NVL(p_user_id, fnd_global.user_id);

2144: RETURN VARCHAR2 IS
2145: CURSOR c_resource_type IS
2146: SELECT category
2147: FROM jtf_rs_resource_extns
2148: WHERE user_id = NVL(p_user_id, fnd_global.user_id);
2149: l_type jtf_rs_resource_extns.category%TYPE;
2150: BEGIN
2151: OPEN c_resource_type;
2152: FETCH c_resource_type INTO l_type;