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 1118: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561

1114: l_res_Timezone_id Number;
1115:
1116: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1117:
1118: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
1119:
1120: BEGIN
1121:
1122: -- standard call to check for call compatibility.

Line 1156: from jtf_task_resources_vl

1152: select resource_name
1153: into l_resource_name
1154: --from jtf_rs_all_resources_vl
1155: --Modified by jawang to fix the bug 2416932
1156: from jtf_task_resources_vl
1157: where resource_id = p_resource_id
1158: and resource_type = p_resource_type;
1159: EXCEPTION
1160: WHEN Others THEN

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

1697: l_res_Timezone_id Number;
1698:
1699: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1700:
1701: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
1702:
1703: BEGIN
1704: -- standard call to check for call compatibility.
1705: if not fnd_api.compatible_api_call

Line 1742: from jtf_task_resources_vl

1738: select resource_name
1739: into l_resource_name
1740: --from jtf_rs_all_resources_vl
1741: --Modified by jawang to fix the bug 2416932
1742: from jtf_task_resources_vl
1743: where resource_id = p_resource_id
1744: and resource_type = p_resource_type;
1745: EXCEPTION
1746: WHEN Others THEN

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

2537: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2538: l_res_Timezone_id Number;
2539: m INTEGER := 0;
2540:
2541: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
2542:
2543: BEGIN
2544:
2545: -- Standard call to check for call compatibility.

Line 2574: from jtf_task_resources_vl

2570: select resource_name
2571: into l_resource_name
2572: --from jtf_rs_all_resources_vl
2573: --Modified by jawang to fix the bug 2416932
2574: from jtf_task_resources_vl
2575: where resource_id = p_resource_id
2576: and resource_type = p_resource_type;
2577: EXCEPTION
2578: WHEN Others THEN

Line 2925: SELECT 1 INTO nDummy FROM jtf_task_resources_vl

2921: if p_resource_id is null or p_resource_type is null then
2922: return false;
2923: end if;
2924:
2925: SELECT 1 INTO nDummy FROM jtf_task_resources_vl
2926: WHERE resource_id = p_resource_id AND resource_type = p_resource_type
2927: AND ((start_date_active IS NULL AND end_date_active IS NULL)
2928: OR (start_date_active <= SYSDATE AND end_date_active IS NULL)
2929: OR (SYSDATE BETWEEN start_date_active AND end_date_active));