1 PACKAGE csf_gps_pub AUTHID CURRENT_USER AS
2 /* $Header: CSFPGPSS.pls 120.1 2010/09/13 08:32:01 rkamasam noship $ */
3
4 FUNCTION is_gps_enabled
5 RETURN VARCHAR2;
6
7 FUNCTION get_gps_label(
8 p_device_id NUMBER DEFAULT NULL
9 , p_resource_id NUMBER DEFAULT NULL
10 , p_resource_type VARCHAR2 DEFAULT NULL
11 , p_date DATE DEFAULT NULL
12 )
13 RETURN VARCHAR2;
14
15 PROCEDURE get_location(
16 p_device_id IN NUMBER DEFAULT NULL
17 , p_resource_id IN NUMBER DEFAULT NULL
18 , p_resource_type IN VARCHAR2 DEFAULT NULL
19 , p_date IN DATE DEFAULT NULL
20 , x_feed_time OUT NOCOPY DATE
21 , x_status_code OUT NOCOPY VARCHAR2
22 , x_latitude OUT NOCOPY NUMBER
23 , x_longitude OUT NOCOPY NUMBER
24 , x_speed OUT NOCOPY NUMBER
25 , x_direction OUT NOCOPY VARCHAR2
26 , x_parked_time OUT NOCOPY NUMBER
27 , x_address OUT NOCOPY VARCHAR2
28 , x_creation_date OUT NOCOPY DATE
29 , x_device_tag OUT NOCOPY VARCHAR2
30 , x_status_code_meaning OUT NOCOPY VARCHAR2
31 );
32
33 FUNCTION get_location (
34 p_device_id IN NUMBER DEFAULT NULL
35 , p_resource_id IN NUMBER DEFAULT NULL
36 , p_resource_type IN VARCHAR2 DEFAULT NULL
37 , p_date IN DATE DEFAULT NULL
38 )
39 RETURN MDSYS.SDO_POINT_TYPE;
40
41 PROCEDURE save_location_feeds(
42 p_api_version IN NUMBER
43 , p_init_msg_list IN VARCHAR2
44 , p_commit IN VARCHAR2
45 , x_return_status OUT NOCOPY VARCHAR2
46 , x_msg_data OUT NOCOPY VARCHAR2
47 , x_msg_count OUT NOCOPY NUMBER
48 , p_count IN NUMBER
49 , p_device_id_tbl IN jtf_number_table
50 , p_feed_time_tbl IN jtf_date_table
51 , p_status_tbl IN jtf_varchar2_table_100
52 , p_lat_tbl IN jtf_number_table
53 , p_lng_tbl IN jtf_number_table
54 , p_speed_tbl IN jtf_number_table
55 , p_dir_tbl IN jtf_varchar2_table_100
56 , p_parked_time_tbl IN jtf_number_table
57 , p_address_tbl IN jtf_varchar2_table_300
58 );
59
60 PROCEDURE purge_location_feeds(
61 errbuf OUT NOCOPY VARCHAR2
62 , retcode OUT NOCOPY VARCHAR2
63 , p_vendor_id IN NUMBER DEFAULT NULL
64 , p_device_id IN NUMBER DEFAULT NULL
65 , p_device_assignment_id IN NUMBER DEFAULT NULL
66 , p_territory_id IN NUMBER DEFAULT NULL
67 , p_resource_type IN VARCHAR2 DEFAULT NULL
68 , p_resource_id IN NUMBER DEFAULT NULL
69 , p_start_date IN VARCHAR2 DEFAULT NULL
70 , p_end_date IN VARCHAR2 DEFAULT NULL
71 , p_num_days IN NUMBER DEFAULT NULL
72 );
73
74 PROCEDURE add_language;
75
76 END csf_gps_pub;
[Home] [Help]