DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on CSF_RESOURCE_PUB

Line 984: csf_resource_pub.get_location(

980:
981: If CSF_GPS_PUB.IS_GPS_ENABLED='Y'
982: THEN
983:
984: csf_resource_pub.get_location(
985: x_return_status => l_return_status
986: ,x_msg_count => l_msg_count
987: ,x_msg_data => l_msg_data
988: ,p_resource_id => p_resource_id

Line 1948: csf_resource_pub.get_location(

1944:
1945: If CSF_GPS_PUB.IS_GPS_ENABLED='Y'
1946: THEN
1947:
1948: csf_resource_pub.get_location(
1949: x_return_status => l_return_status
1950: ,x_msg_count => l_msg_count
1951: ,x_msg_data => l_msg_data
1952: ,p_resource_id => p_resource_id

Line 2746: csf_resource_pub.get_location(

2742: /*
2743: If CSF_GPS_PUB.IS_GPS_ENABLED='Y'
2744: THEN
2745:
2746: csf_resource_pub.get_location(
2747: x_return_status => l_return_status
2748: ,x_msg_count => l_msg_count
2749: ,x_msg_data => l_msg_data
2750: ,p_resource_id => p_resource_id

Line 3480: csf_resource_pub.get_location(

3476:
3477: If CSF_GPS_PUB.IS_GPS_ENABLED='Y'
3478: THEN
3479:
3480: csf_resource_pub.get_location(
3481: x_return_status => l_return_status
3482: ,x_msg_count => l_msg_count
3483: ,x_msg_data => l_msg_data
3484: ,p_resource_id => p_resource_id

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

4529:
4530: FUNCTION get_resource_name(p_res_id NUMBER, p_res_type VARCHAR2)
4531: RETURN VARCHAR2 IS
4532: BEGIN
4533: RETURN csf_resource_pub.get_resource_name(p_res_id,p_res_type);
4534: EXCEPTION
4535: WHEN OTHERS THEN
4536: RETURN NULL;
4537: END get_resource_name;

Line 4543: RETURN CSF_RESOURCE_PUB.get_resource_type_name(p_res_type);

4539: FUNCTION get_resource_type_name(p_res_type VARCHAR2)
4540: RETURN VARCHAR2 IS
4541:
4542: BEGIN
4543: RETURN CSF_RESOURCE_PUB.get_resource_type_name(p_res_type);
4544: EXCEPTION
4545: WHEN OTHERS THEN
4546: RETURN NULL;
4547: END get_resource_type_name;

Line 5235: l_resource_dtls csf_resource_pub.resource_rec_type;

5231: AND NVL(tsa.cancelled_flag, 'N') <> 'Y'
5232: AND NVL(tsb.cancelled_flag, 'N') <> 'Y';
5233:
5234:
5235: l_resource_dtls csf_resource_pub.resource_rec_type;
5236: l_cnt number (10);
5237:
5238: --------------------------------------------------------------------
5239: --all the variable and cursor used for getting real task information

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

7567:
7568:
7569: L_RESOURCE_QUERY := ' SELECT RR.RESOURCE_ID'
7570: ||',RR.RESOURCE_TYPE'
7571: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
7572: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
7573: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
7574: ||',POP.COST'
7575: ||' FROM '

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

7586: ||' AND PT.TASK_ID = T.TASK_ID(+)';
7587:
7588: L_RESOURCE_QUERY_COST := ' SELECT RR.RESOURCE_ID'
7589: ||',RR.RESOURCE_TYPE'
7590: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
7591: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
7592: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
7593: ||',POP.COST'
7594: ||' FROM '

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

7621: ||' GROUP BY RR.RESOURCE_ID)';
7622:
7623: L_RESOURCE_QUERY_COST_DAY := ' SELECT RR.RESOURCE_ID '
7624: ||' ,RR.RESOURCE_TYPE '
7625: ||' ,CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME '
7626: ||' ,CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME '
7627: ||' ,RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY '
7628: ||' ,POP.COST '
7629: ||' FROM '

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

7673: ||' GROUP BY TRUNC(START_TIME))) ';
7674:
7675: L_RESOURCE_SINGLE_QUERY :=' SELECT RR.RESOURCE_ID'
7676: ||',RR.RESOURCE_TYPE'
7677: ||',CSF_RESOURCE_PUB.GET_RESOURCE_NAME (RR.RESOURCE_ID,RR.RESOURCE_TYPE) RESOURCE_NAME'
7678: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
7679: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
7680: ||',POP.COST'
7681: ||' FROM '

Line 8705: g_resource_id :=csf_resource_pub.resource_id;

8701: g_uom_minutes := fnd_profile.value_specific('CSF_UOM_MINUTES', g_user_id);
8702: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
8703: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
8704: l_language := USERENV('LANG');
8705: g_resource_id :=csf_resource_pub.resource_id;
8706: g_resource_type :=csf_resource_pub.resource_type;
8707: g_server_tz := fnd_timezones.get_server_timezone_code;
8708: g_client_tz := fnd_timezones.get_client_timezone_code;
8709: g_tz_enabled := 'N';

Line 8706: g_resource_type :=csf_resource_pub.resource_type;

8702: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
8703: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
8704: l_language := USERENV('LANG');
8705: g_resource_id :=csf_resource_pub.resource_id;
8706: g_resource_type :=csf_resource_pub.resource_type;
8707: g_server_tz := fnd_timezones.get_server_timezone_code;
8708: g_client_tz := fnd_timezones.get_client_timezone_code;
8709: g_tz_enabled := 'N';
8710: