DBA Data[Home] [Help]

APPS.CSF_GPS_PUB dependencies on CSF_RESOURCE_PUB

Line 358: l_res_info csf_resource_pub.resource_rec_type;

354: , p_end_date DATE
355: , p_indent NUMBER
356: ) IS
357: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_RES_LOCATION_FEEDS';
358: l_res_info csf_resource_pub.resource_rec_type;
359: BEGIN
360: l_res_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);
361:
362: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_RES_LOCS');

Line 360: l_res_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);

356: ) IS
357: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_RES_LOCATION_FEEDS';
358: l_res_info csf_resource_pub.resource_rec_type;
359: BEGIN
360: l_res_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);
361:
362: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_RES_LOCS');
363: fnd_message.set_token('RESOURCE', l_res_info.resource_name || '(' || csf_resource_pub.get_resource_type_name(l_res_info.resource_type) || ', ' || l_res_info.resource_number || ')');
364: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);

Line 363: fnd_message.set_token('RESOURCE', l_res_info.resource_name || '(' || csf_resource_pub.get_resource_type_name(l_res_info.resource_type) || ', ' || l_res_info.resource_number || ')');

359: BEGIN
360: l_res_info := csf_resource_pub.get_resource_info(p_resource_id, p_resource_type);
361:
362: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_RES_LOCS');
363: fnd_message.set_token('RESOURCE', l_res_info.resource_name || '(' || csf_resource_pub.get_resource_type_name(l_res_info.resource_type) || ', ' || l_res_info.resource_number || ')');
364: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);
365:
366: DELETE csf_gps_location_feeds
367: WHERE device_id IN (