DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CSF_GPS_PUB

Line 2645: IF p_date > SYSDATE OR NVL(csf_gps_pub.is_gps_enabled, 'N') <> 'Y' OR l_mapping_count = 0 THEN

2641: OPEN c_device_res_map_exists;
2642: FETCH c_device_res_map_exists INTO l_mapping_count;
2643: CLOSE c_device_res_map_exists;
2644:
2645: IF p_date > SYSDATE OR NVL(csf_gps_pub.is_gps_enabled, 'N') <> 'Y' OR l_mapping_count = 0 THEN
2646: l_address :=
2647: get_resource_party_address(
2648: p_res_id => p_resource_id
2649: , p_res_type => p_resource_type

Line 2657: csf_gps_pub.get_gps_label(

2653: -- This is wrong. It should follow the Country specific Formatting rules
2654: x_address := l_address.street || ', ' || l_address.city || ', ' || l_address.state || ', ' || l_address.postal_code || ', ' || l_address.country;
2655: x_status_code := 'AT_HOME';
2656: x_device_tag :=
2657: csf_gps_pub.get_gps_label(
2658: p_resource_id => p_resource_id
2659: , p_resource_type => p_resource_type
2660: , p_date => p_date
2661: );

Line 2701: csf_gps_pub.get_location(

2697: x_latitude := -9999;
2698: END IF;
2699: x_status_code_meaning := NULL;
2700: ELSE
2701: csf_gps_pub.get_location(
2702: p_resource_id => p_resource_id
2703: , p_resource_type => p_resource_type
2704: , p_date => p_date
2705: , x_feed_time => x_feed_time