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

423: l_shift_date DATE;
424: l_shift SHIFT_TBL_TYPE;
425: l_tbl tbl_type; -- added by Sarvi.
426: l_idx number := 0;
427: l_resource_name jtf_task_resources_vl.resource_name%TYPE; -- bug #2418561
428: l_st_time date;
429:
430: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
431: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

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

929: l_res_Timezone_id Number;
930:
931: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
932:
933: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
934:
935: BEGIN
936: -- standard call to check for call compatibility.
937: if not fnd_api.compatible_api_call

Line 979: from jtf_task_resources_vl

975: select resource_name
976: into l_resource_name
977: --from jtf_rs_all_resources_vl
978: --Modified by jawang to fix the bug 2416932
979: from jtf_task_resources_vl
980: where resource_id = p_resource_id
981: and resource_type = p_resource_type;
982: EXCEPTION
983: WHEN Others THEN

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

1439: l_res_Timezone_id Number;
1440:
1441: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR ;
1442:
1443: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
1444:
1445: BEGIN
1446:
1447: -- standard call to check for call compatibility.

Line 1487: from jtf_task_resources_vl

1483: select resource_name
1484: into l_resource_name
1485: --from jtf_rs_all_resources_vl
1486: --Modified by jawang to fix the bug 2416932
1487: from jtf_task_resources_vl
1488: where resource_id = p_resource_id
1489: and resource_type = p_resource_type;
1490: EXCEPTION
1491: WHEN Others THEN

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

2110: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'); -- Added by SBARAT on 23/06/2005 for Bug# 4443443
2111: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
2112: l_res_Timezone_id Number;
2113:
2114: l_resource_name jtf_task_resources_vl.resource_name%TYPE;-- bug # 2418561
2115:
2116: BEGIN
2117: -- Standard call to check for call compatibility.
2118: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 2148: from jtf_task_resources_vl

2144: select resource_name
2145: into l_resource_name
2146: --from jtf_rs_all_resources_vl
2147: --Modified by jawang to fix the bug 2416932
2148: from jtf_task_resources_vl
2149: where resource_id = p_resource_id
2150: and resource_type = p_resource_type;
2151: EXCEPTION
2152: WHEN Others THEN