APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_TASK_RESOURCES_VL

Line 21: -- 12/12/05 SBARAT Changed jtf_rs_resources_vl to jtf_task_resources_vl

17: -- 03/27/03 ABRAINA Modified cursors in Get_available_time
18: -- and Get_Res_Schedule.
19: -- 06/16/03 ABRAINA Fixed GSCC warning.
20: -- 08/11/03 ABRAINA Added ResourceDt_To_ServerDT
21: -- 12/12/05 SBARAT Changed jtf_rs_resources_vl to jtf_task_resources_vl
22: -- due to MOAC change, bug# 4455792
23: -- 12/22/05 MPADHIAR Change for Bug # 4400664
24: -- In case of UOM is minute(MIN) . It was truncating Second portion
25: -- of the Calculated end_time. So giving 1 Minute less

Line 1185: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561

1181: l_res_Timezone_id Number;
1182:
1183: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1184:
1185: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
1186:
1187: BEGIN
1188:
1189: -- standard call to check for call compatibility.

Line 1223: from jtf_task_resources_vl

1219: select resource_name
1220: into l_resource_name
1221: --from jtf_rs_all_resources_vl
1222: --Modified by jawang to fix the bug 2416932
1223: from jtf_task_resources_vl
1224: where resource_id = p_resource_id
1225: and resource_type = p_resource_type;
1226: EXCEPTION
1227: WHEN Others THEN

Line 1768: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561

1764: l_res_Timezone_id Number;
1765:
1766: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1767:
1768: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
1769:
1770: BEGIN
1771: -- standard call to check for call compatibility.
1772: if not fnd_api.compatible_api_call

Line 1809: from jtf_task_resources_vl

1805: select resource_name
1806: into l_resource_name
1807: --from jtf_rs_all_resources_vl
1808: --Modified by jawang to fix the bug 2416932
1809: from jtf_task_resources_vl
1810: where resource_id = p_resource_id
1811: and resource_type = p_resource_type;
1812: EXCEPTION
1813: WHEN Others THEN

Line 2611: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561

2607: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2608: l_res_Timezone_id Number;
2609: m INTEGER := 0;
2610:
2611: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
2612:
2613: BEGIN
2614:
2615: -- Standard call to check for call compatibility.

Line 2644: from jtf_task_resources_vl

2640: select resource_name
2641: into l_resource_name
2642: --from jtf_rs_all_resources_vl
2643: --Modified by jawang to fix the bug 2416932
2644: from jtf_task_resources_vl
2645: where resource_id = p_resource_id
2646: and resource_type = p_resource_type;
2647: EXCEPTION
2648: WHEN Others THEN

Line 2995: SELECT 1 INTO nDummy FROM jtf_task_resources_vl

2991: if p_resource_id is null or p_resource_type is null then
2992: return false;
2993: end if;
2994:
2995: SELECT 1 INTO nDummy FROM jtf_task_resources_vl
2996: WHERE resource_id = p_resource_id AND resource_type = p_resource_type
2997: AND ((start_date_active IS NULL AND end_date_active IS NULL)
2998: OR (start_date_active <= SYSDATE AND end_date_active IS NULL)
2999: OR (SYSDATE BETWEEN start_date_active AND end_date_active));