APPS.JTF_CALENDAR_PUB dependencies on JTF_TASK_RESOURCES_VL

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

23: -- 04/28/03 ABRAINA Modified all cursor c_cal_shift_constr
24: -- and work_hrs for first day of week change
25: -- 06/16/03 ABRAINA Fixed GSCC warning.
26: -- 08/11/03 ABRAINA Added ResourceDt_To_ServerDT
27: -- 12/12/05 SBARAT Changed jtf_rs_resources_vl to jtf_task_resources_vl
28: -- due to MOAC change, bug# 4455792
29: -- End of Comments
30: -- ************************************************************************
31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_CALENDAR_PUB';

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

465: l_shift_date DATE;
466: l_shift SHIFT_TBL_TYPE;
467: l_tbl tbl_type; -- added by Sarvi.
468: l_idx number := 0;
469: l_resource_name jtf_task_resources_vl.resource_name%TYPE; -- bug #2418561
470: l_st_time date;
471:
472: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
473: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

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

971: l_res_Timezone_id Number;
972:
973: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
974:
975: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
976:
977: BEGIN
978: -- standard call to check for call compatibility.
979: if not fnd_api.compatible_api_call

Line 1021: from jtf_task_resources_vl

1017: select resource_name
1018: into l_resource_name
1019: --from jtf_rs_all_resources_vl
1020: --Modified by jawang to fix the bug 2416932
1021: from jtf_task_resources_vl
1022: where resource_id = p_resource_id
1023: and resource_type = p_resource_type;
1024: EXCEPTION
1025: WHEN Others THEN

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

1484: l_res_Timezone_id Number;
1485:
1486: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1487:
1488: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
1489:
1490: BEGIN
1491:
1492: -- standard call to check for call compatibility.

Line 1532: from jtf_task_resources_vl

1528: select resource_name
1529: into l_resource_name
1530: --from jtf_rs_all_resources_vl
1531: --Modified by jawang to fix the bug 2416932
1532: from jtf_task_resources_vl
1533: where resource_id = p_resource_id
1534: and resource_type = p_resource_type;
1535: EXCEPTION
1536: WHEN Others THEN

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

2160: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
2161: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2162: l_res_Timezone_id Number;
2163:
2164: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
2165:
2166: BEGIN
2167: -- Standard call to check for call compatibility.
2168: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 2198: from jtf_task_resources_vl

2194: select resource_name
2195: into l_resource_name
2196: --from jtf_rs_all_resources_vl
2197: --Modified by jawang to fix the bug 2416932
2198: from jtf_task_resources_vl
2199: where resource_id = p_resource_id
2200: and resource_type = p_resource_type;
2201: EXCEPTION
2202: WHEN Others THEN