APPS.CSF_RESOURCE_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 42: , resource_name jtf_rs_resource_extns_tl.resource_name%TYPE

38: */
39: TYPE resource_cache_rec_type IS RECORD(
40: resource_id NUMBER
41: , resource_type jtf_objects_b.object_code%TYPE
42: , resource_name jtf_rs_resource_extns_tl.resource_name%TYPE
43: , resource_number jtf_rs_resource_extns.resource_number%TYPE
44: , address csf_resource_address_pvt.address_rec_type
45: );
46:

Line 43: , resource_number jtf_rs_resource_extns.resource_number%TYPE

39: TYPE resource_cache_rec_type IS RECORD(
40: resource_id NUMBER
41: , resource_type jtf_objects_b.object_code%TYPE
42: , resource_name jtf_rs_resource_extns_tl.resource_name%TYPE
43: , resource_number jtf_rs_resource_extns.resource_number%TYPE
44: , address csf_resource_address_pvt.address_rec_type
45: );
46:
47: /**

Line 1583: FROM jtf_rs_resource_extns

1579: FUNCTION resource_id(p_user_id NUMBER DEFAULT NULL)
1580: RETURN NUMBER IS
1581: CURSOR c_resource IS
1582: SELECT resource_id
1583: FROM jtf_rs_resource_extns
1584: WHERE user_id = NVL(p_user_id, fnd_global.user_id);
1585: l_id NUMBER := NULL;
1586: BEGIN
1587: OPEN c_resource;

Line 1607: FROM jtf_rs_resource_extns

1603: FUNCTION resource_type(p_user_id NUMBER DEFAULT NULL)
1604: RETURN VARCHAR2 IS
1605: CURSOR c_resource_type IS
1606: SELECT category
1607: FROM jtf_rs_resource_extns
1608: WHERE user_id = NVL(p_user_id, fnd_global.user_id);
1609: l_type jtf_rs_resource_extns.category%TYPE;
1610: BEGIN
1611: OPEN c_resource_type;

Line 1609: l_type jtf_rs_resource_extns.category%TYPE;

1605: CURSOR c_resource_type IS
1606: SELECT category
1607: FROM jtf_rs_resource_extns
1608: WHERE user_id = NVL(p_user_id, fnd_global.user_id);
1609: l_type jtf_rs_resource_extns.category%TYPE;
1610: BEGIN
1611: OPEN c_resource_type;
1612: FETCH c_resource_type INTO l_type;
1613: CLOSE c_resource_type;

Line 1637: FROM jtf_rs_resource_extns_vl

1633: SELECT resource_id
1634: , p_res_type resource_type
1635: , resource_name
1636: , resource_number
1637: FROM jtf_rs_resource_extns_vl
1638: WHERE resource_id = p_res_id;
1639:
1640: CURSOR c_group_resource IS
1641: SELECT group_id resource_id

Line 1854: FROM jtf_rs_resource_extns

1850: l_dest_tz_id NUMBER;
1851: l_temp_tz_id NUMBER;
1852: CURSOR c_resource IS
1853: SELECT time_zone
1854: FROM jtf_rs_resource_extns
1855: WHERE resource_id = p_resource_id
1856: AND p_resource_type NOT IN('RS_GROUP', 'RS_TEAM');
1857: BEGIN
1858: -- Standard call to check for call compatibility