DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CSF_GPS_LOCATION_FEEDS

Line 2740: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;

2736: , x_address OUT NOCOPY VARCHAR2
2737: , x_status_meaning OUT NOCOPY VARCHAR2
2738: , x_device_tag OUT NOCOPY VARCHAR2
2739: ) IS
2740: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2741: l_status_code csf_gps_location_feeds.status%TYPE;
2742: l_speed csf_gps_location_feeds.speed%TYPE;
2743: l_direction csf_gps_location_feeds.direction%TYPE;
2744: l_parked_time csf_gps_location_feeds.parked_time%TYPE;

Line 2741: l_status_code csf_gps_location_feeds.status%TYPE;

2737: , x_status_meaning OUT NOCOPY VARCHAR2
2738: , x_device_tag OUT NOCOPY VARCHAR2
2739: ) IS
2740: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2741: l_status_code csf_gps_location_feeds.status%TYPE;
2742: l_speed csf_gps_location_feeds.speed%TYPE;
2743: l_direction csf_gps_location_feeds.direction%TYPE;
2744: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2745: l_creation_date csf_gps_location_feeds.creation_date%TYPE;

Line 2742: l_speed csf_gps_location_feeds.speed%TYPE;

2738: , x_device_tag OUT NOCOPY VARCHAR2
2739: ) IS
2740: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2741: l_status_code csf_gps_location_feeds.status%TYPE;
2742: l_speed csf_gps_location_feeds.speed%TYPE;
2743: l_direction csf_gps_location_feeds.direction%TYPE;
2744: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2745: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2746: BEGIN

Line 2743: l_direction csf_gps_location_feeds.direction%TYPE;

2739: ) IS
2740: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2741: l_status_code csf_gps_location_feeds.status%TYPE;
2742: l_speed csf_gps_location_feeds.speed%TYPE;
2743: l_direction csf_gps_location_feeds.direction%TYPE;
2744: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2745: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2746: BEGIN
2747: get_location(

Line 2744: l_parked_time csf_gps_location_feeds.parked_time%TYPE;

2740: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2741: l_status_code csf_gps_location_feeds.status%TYPE;
2742: l_speed csf_gps_location_feeds.speed%TYPE;
2743: l_direction csf_gps_location_feeds.direction%TYPE;
2744: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2745: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2746: BEGIN
2747: get_location(
2748: x_msg_count => x_msg_count

Line 2745: l_creation_date csf_gps_location_feeds.creation_date%TYPE;

2741: l_status_code csf_gps_location_feeds.status%TYPE;
2742: l_speed csf_gps_location_feeds.speed%TYPE;
2743: l_direction csf_gps_location_feeds.direction%TYPE;
2744: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2745: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2746: BEGIN
2747: get_location(
2748: x_msg_count => x_msg_count
2749: , x_msg_data => x_msg_data

Line 2776: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;

2772: ) RETURN MDSYS.SDO_POINT_TYPE IS
2773: l_return_status VARCHAR2(1);
2774: l_msg_data VARCHAR2(2000);
2775: l_msg_count NUMBER;
2776: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2777: l_status_code csf_gps_location_feeds.status%TYPE;
2778: l_latitude csf_gps_location_feeds.latitude%TYPE;
2779: l_longitude csf_gps_location_feeds.longitude%TYPE;
2780: l_speed csf_gps_location_feeds.speed%TYPE;

Line 2777: l_status_code csf_gps_location_feeds.status%TYPE;

2773: l_return_status VARCHAR2(1);
2774: l_msg_data VARCHAR2(2000);
2775: l_msg_count NUMBER;
2776: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2777: l_status_code csf_gps_location_feeds.status%TYPE;
2778: l_latitude csf_gps_location_feeds.latitude%TYPE;
2779: l_longitude csf_gps_location_feeds.longitude%TYPE;
2780: l_speed csf_gps_location_feeds.speed%TYPE;
2781: l_direction csf_gps_location_feeds.direction%TYPE;

Line 2778: l_latitude csf_gps_location_feeds.latitude%TYPE;

2774: l_msg_data VARCHAR2(2000);
2775: l_msg_count NUMBER;
2776: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2777: l_status_code csf_gps_location_feeds.status%TYPE;
2778: l_latitude csf_gps_location_feeds.latitude%TYPE;
2779: l_longitude csf_gps_location_feeds.longitude%TYPE;
2780: l_speed csf_gps_location_feeds.speed%TYPE;
2781: l_direction csf_gps_location_feeds.direction%TYPE;
2782: l_parked_time csf_gps_location_feeds.parked_time%TYPE;

Line 2779: l_longitude csf_gps_location_feeds.longitude%TYPE;

2775: l_msg_count NUMBER;
2776: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2777: l_status_code csf_gps_location_feeds.status%TYPE;
2778: l_latitude csf_gps_location_feeds.latitude%TYPE;
2779: l_longitude csf_gps_location_feeds.longitude%TYPE;
2780: l_speed csf_gps_location_feeds.speed%TYPE;
2781: l_direction csf_gps_location_feeds.direction%TYPE;
2782: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2783: l_address csf_gps_location_feeds.address%TYPE;

Line 2780: l_speed csf_gps_location_feeds.speed%TYPE;

2776: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2777: l_status_code csf_gps_location_feeds.status%TYPE;
2778: l_latitude csf_gps_location_feeds.latitude%TYPE;
2779: l_longitude csf_gps_location_feeds.longitude%TYPE;
2780: l_speed csf_gps_location_feeds.speed%TYPE;
2781: l_direction csf_gps_location_feeds.direction%TYPE;
2782: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2783: l_address csf_gps_location_feeds.address%TYPE;
2784: l_creation_date csf_gps_location_feeds.creation_date%TYPE;

Line 2781: l_direction csf_gps_location_feeds.direction%TYPE;

2777: l_status_code csf_gps_location_feeds.status%TYPE;
2778: l_latitude csf_gps_location_feeds.latitude%TYPE;
2779: l_longitude csf_gps_location_feeds.longitude%TYPE;
2780: l_speed csf_gps_location_feeds.speed%TYPE;
2781: l_direction csf_gps_location_feeds.direction%TYPE;
2782: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2783: l_address csf_gps_location_feeds.address%TYPE;
2784: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2785: l_device_tag csf_gps_devices.device_tag%TYPE;

Line 2782: l_parked_time csf_gps_location_feeds.parked_time%TYPE;

2778: l_latitude csf_gps_location_feeds.latitude%TYPE;
2779: l_longitude csf_gps_location_feeds.longitude%TYPE;
2780: l_speed csf_gps_location_feeds.speed%TYPE;
2781: l_direction csf_gps_location_feeds.direction%TYPE;
2782: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2783: l_address csf_gps_location_feeds.address%TYPE;
2784: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2785: l_device_tag csf_gps_devices.device_tag%TYPE;
2786: l_status_code_meaning fnd_lookups.meaning%TYPE;

Line 2783: l_address csf_gps_location_feeds.address%TYPE;

2779: l_longitude csf_gps_location_feeds.longitude%TYPE;
2780: l_speed csf_gps_location_feeds.speed%TYPE;
2781: l_direction csf_gps_location_feeds.direction%TYPE;
2782: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2783: l_address csf_gps_location_feeds.address%TYPE;
2784: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2785: l_device_tag csf_gps_devices.device_tag%TYPE;
2786: l_status_code_meaning fnd_lookups.meaning%TYPE;
2787: BEGIN

Line 2784: l_creation_date csf_gps_location_feeds.creation_date%TYPE;

2780: l_speed csf_gps_location_feeds.speed%TYPE;
2781: l_direction csf_gps_location_feeds.direction%TYPE;
2782: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2783: l_address csf_gps_location_feeds.address%TYPE;
2784: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2785: l_device_tag csf_gps_devices.device_tag%TYPE;
2786: l_status_code_meaning fnd_lookups.meaning%TYPE;
2787: BEGIN
2788: get_location(

Line 2819: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;

2815: RETURN VARCHAR2 IS
2816: l_return_status VARCHAR2(1);
2817: l_msg_data VARCHAR2(2000);
2818: l_msg_count NUMBER;
2819: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2820: l_status_code csf_gps_location_feeds.status%TYPE;
2821: l_latitude csf_gps_location_feeds.latitude%TYPE;
2822: l_longitude csf_gps_location_feeds.longitude%TYPE;
2823: l_speed csf_gps_location_feeds.speed%TYPE;

Line 2820: l_status_code csf_gps_location_feeds.status%TYPE;

2816: l_return_status VARCHAR2(1);
2817: l_msg_data VARCHAR2(2000);
2818: l_msg_count NUMBER;
2819: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2820: l_status_code csf_gps_location_feeds.status%TYPE;
2821: l_latitude csf_gps_location_feeds.latitude%TYPE;
2822: l_longitude csf_gps_location_feeds.longitude%TYPE;
2823: l_speed csf_gps_location_feeds.speed%TYPE;
2824: l_direction csf_gps_location_feeds.direction%TYPE;

Line 2821: l_latitude csf_gps_location_feeds.latitude%TYPE;

2817: l_msg_data VARCHAR2(2000);
2818: l_msg_count NUMBER;
2819: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2820: l_status_code csf_gps_location_feeds.status%TYPE;
2821: l_latitude csf_gps_location_feeds.latitude%TYPE;
2822: l_longitude csf_gps_location_feeds.longitude%TYPE;
2823: l_speed csf_gps_location_feeds.speed%TYPE;
2824: l_direction csf_gps_location_feeds.direction%TYPE;
2825: l_parked_time csf_gps_location_feeds.parked_time%TYPE;

Line 2822: l_longitude csf_gps_location_feeds.longitude%TYPE;

2818: l_msg_count NUMBER;
2819: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2820: l_status_code csf_gps_location_feeds.status%TYPE;
2821: l_latitude csf_gps_location_feeds.latitude%TYPE;
2822: l_longitude csf_gps_location_feeds.longitude%TYPE;
2823: l_speed csf_gps_location_feeds.speed%TYPE;
2824: l_direction csf_gps_location_feeds.direction%TYPE;
2825: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2826: l_address csf_gps_location_feeds.address%TYPE;

Line 2823: l_speed csf_gps_location_feeds.speed%TYPE;

2819: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
2820: l_status_code csf_gps_location_feeds.status%TYPE;
2821: l_latitude csf_gps_location_feeds.latitude%TYPE;
2822: l_longitude csf_gps_location_feeds.longitude%TYPE;
2823: l_speed csf_gps_location_feeds.speed%TYPE;
2824: l_direction csf_gps_location_feeds.direction%TYPE;
2825: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2826: l_address csf_gps_location_feeds.address%TYPE;
2827: l_creation_date csf_gps_location_feeds.creation_date%TYPE;

Line 2824: l_direction csf_gps_location_feeds.direction%TYPE;

2820: l_status_code csf_gps_location_feeds.status%TYPE;
2821: l_latitude csf_gps_location_feeds.latitude%TYPE;
2822: l_longitude csf_gps_location_feeds.longitude%TYPE;
2823: l_speed csf_gps_location_feeds.speed%TYPE;
2824: l_direction csf_gps_location_feeds.direction%TYPE;
2825: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2826: l_address csf_gps_location_feeds.address%TYPE;
2827: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2828: l_device_tag csf_gps_devices.device_tag%TYPE;

Line 2825: l_parked_time csf_gps_location_feeds.parked_time%TYPE;

2821: l_latitude csf_gps_location_feeds.latitude%TYPE;
2822: l_longitude csf_gps_location_feeds.longitude%TYPE;
2823: l_speed csf_gps_location_feeds.speed%TYPE;
2824: l_direction csf_gps_location_feeds.direction%TYPE;
2825: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2826: l_address csf_gps_location_feeds.address%TYPE;
2827: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2828: l_device_tag csf_gps_devices.device_tag%TYPE;
2829: l_status_code_meaning fnd_lookups.meaning%TYPE;

Line 2826: l_address csf_gps_location_feeds.address%TYPE;

2822: l_longitude csf_gps_location_feeds.longitude%TYPE;
2823: l_speed csf_gps_location_feeds.speed%TYPE;
2824: l_direction csf_gps_location_feeds.direction%TYPE;
2825: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2826: l_address csf_gps_location_feeds.address%TYPE;
2827: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2828: l_device_tag csf_gps_devices.device_tag%TYPE;
2829: l_status_code_meaning fnd_lookups.meaning%TYPE;
2830: BEGIN

Line 2827: l_creation_date csf_gps_location_feeds.creation_date%TYPE;

2823: l_speed csf_gps_location_feeds.speed%TYPE;
2824: l_direction csf_gps_location_feeds.direction%TYPE;
2825: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
2826: l_address csf_gps_location_feeds.address%TYPE;
2827: l_creation_date csf_gps_location_feeds.creation_date%TYPE;
2828: l_device_tag csf_gps_devices.device_tag%TYPE;
2829: l_status_code_meaning fnd_lookups.meaning%TYPE;
2830: BEGIN
2831: get_location(