APPS.CSF_RESOURCE_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 47: , resource_name jtf_rs_resource_extns_tl.resource_name%TYPE

43: */
44: TYPE resource_cache_rec_type IS RECORD(
45: resource_id NUMBER
46: , resource_type jtf_objects_b.object_code%TYPE
47: , resource_name jtf_rs_resource_extns_tl.resource_name%TYPE
48: , resource_number jtf_rs_resource_extns.resource_number%TYPE
49: , address csf_resource_address_pvt.address_rec_type
50: );
51:

Line 48: , resource_number jtf_rs_resource_extns.resource_number%TYPE

44: TYPE resource_cache_rec_type IS RECORD(
45: resource_id NUMBER
46: , resource_type jtf_objects_b.object_code%TYPE
47: , resource_name jtf_rs_resource_extns_tl.resource_name%TYPE
48: , resource_number jtf_rs_resource_extns.resource_number%TYPE
49: , address csf_resource_address_pvt.address_rec_type
50: );
51:
52: /**

Line 2123: FROM jtf_rs_resource_extns

2119: FUNCTION resource_id(p_user_id NUMBER DEFAULT NULL)
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;

Line 2147: FROM jtf_rs_resource_extns

2143: FUNCTION resource_type(p_user_id NUMBER DEFAULT NULL)
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;

Line 2149: l_type jtf_rs_resource_extns.category%TYPE;

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;
2153: CLOSE c_resource_type;

Line 2177: FROM jtf_rs_resource_extns_vl

2173: SELECT resource_id
2174: , p_res_type resource_type
2175: , resource_name
2176: , resource_number
2177: FROM jtf_rs_resource_extns_vl
2178: WHERE resource_id = p_res_id;
2179:
2180: CURSOR c_group_resource IS
2181: SELECT group_id resource_id

Line 2398: FROM jtf_rs_resource_extns

2394: l_dest_tz_id NUMBER;
2395: l_temp_tz_id NUMBER;
2396: CURSOR c_resource IS
2397: SELECT time_zone
2398: FROM jtf_rs_resource_extns
2399: WHERE resource_id = p_resource_id
2400: AND p_resource_type NOT IN('RS_GROUP', 'RS_TEAM');
2401: BEGIN
2402: -- Standard call to check for call compatibility