APPS.CSF_GANTT_DATA_PKG dependencies on CSF_RESOURCE_PUB

Line 1948: RETURN csf_resource_pub.get_resource_name(p_res_id,p_res_type);

1944:
1945: FUNCTION get_resource_name(p_res_id NUMBER, p_res_type VARCHAR2)
1946: RETURN VARCHAR2 IS
1947: BEGIN
1948: RETURN csf_resource_pub.get_resource_name(p_res_id,p_res_type);
1949: EXCEPTION
1950: WHEN OTHERS THEN
1951: RETURN NULL;
1952: END get_resource_name;

Line 1958: RETURN CSF_RESOURCE_PUB.get_resource_type_name(p_res_type);

1954: FUNCTION get_resource_type_name(p_res_type VARCHAR2)
1955: RETURN VARCHAR2 IS
1956:
1957: BEGIN
1958: RETURN CSF_RESOURCE_PUB.get_resource_type_name(p_res_type);
1959: EXCEPTION
1960: WHEN OTHERS THEN
1961: RETURN NULL;
1962: END get_resource_type_name;

Line 2489: l_resource_dtls csf_resource_pub.resource_rec_type;

2485: AND NVL(tsa.cancelled_flag, 'N') <> 'Y'
2486: AND NVL(tsb.cancelled_flag, 'N') <> 'Y';
2487:
2488:
2489: l_resource_dtls csf_resource_pub.resource_rec_type;
2490: l_cnt number (10);
2491:
2492: --------------------------------------------------------------------
2493: --all the variable and cursor used for getting real task information

Line 4472: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'

4468:
4469:
4470: L_RESOURCE_QUERY := ' SELECT RR.RESOURCE_ID'
4471: ||',RR.RESOURCE_TYPE'
4472: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
4473: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
4474: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
4475: ||',POP.COST'
4476: ||' FROM '

Line 4491: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'

4487: ||' AND PT.TASK_ID = T.TASK_ID(+)';
4488:
4489: L_RESOURCE_QUERY_COST := ' SELECT RR.RESOURCE_ID'
4490: ||',RR.RESOURCE_TYPE'
4491: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
4492: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
4493: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
4494: ||',POP.COST'
4495: ||' FROM '

Line 4526: ||' ,CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME '

4522: ||' GROUP BY RR.RESOURCE_ID)';
4523:
4524: L_RESOURCE_QUERY_COST_DAY := ' SELECT RR.RESOURCE_ID '
4525: ||' ,RR.RESOURCE_TYPE '
4526: ||' ,CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME '
4527: ||' ,CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME '
4528: ||' ,RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY '
4529: ||' ,POP.COST '
4530: ||' FROM '

Line 4578: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'

4574: ||' GROUP BY TRUNC(START_TIME))) ';
4575:
4576: L_RESOURCE_SINGLE_QUERY :=' SELECT RR.RESOURCE_ID'
4577: ||',RR.RESOURCE_TYPE'
4578: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
4579: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
4580: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
4581: ||',POP.COST'
4582: ||' FROM '

Line 5408: g_resource_id :=csf_resource_pub.resource_id;

5404: g_uom_minutes := fnd_profile.value_specific('CSF_UOM_MINUTES', g_user_id);
5405: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
5406: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
5407: l_language := USERENV('LANG');
5408: g_resource_id :=csf_resource_pub.resource_id;
5409: g_resource_type :=csf_resource_pub.resource_type;
5410: g_server_tz := fnd_timezones.get_server_timezone_code;
5411: g_client_tz := fnd_timezones.get_client_timezone_code;
5412: g_tz_enabled := 'N';

Line 5409: g_resource_type :=csf_resource_pub.resource_type;

5405: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
5406: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
5407: l_language := USERENV('LANG');
5408: g_resource_id :=csf_resource_pub.resource_id;
5409: g_resource_type :=csf_resource_pub.resource_type;
5410: g_server_tz := fnd_timezones.get_server_timezone_code;
5411: g_client_tz := fnd_timezones.get_client_timezone_code;
5412: g_tz_enabled := 'N';
5413: