PACKAGE: APPS.RRS_SITE_UTILS

Source

1 PACKAGE RRS_SITE_UTILS AS
2 /* $Header: RRSUTILS.pls 120.8 2008/01/25 21:33:22 sunarang noship $ */
3 
4 FUNCTION GET_LOCATION_ADDRESS
5 	(
6 		p_site_id IN NUMBER
7 	) RETURN VARCHAR2;
8 
9 FUNCTION GET_SITE_DISPLAY_NAME
10 	(
11 		p_site_id IN NUMBER
12 	) RETURN VARCHAR2;
13 
14 FUNCTION GET_USER_ATTR_VAL
15 	(
16 		p_attr_grp_type IN VARCHAR2,
17 		p_attr_grp_name IN VARCHAR2,
18 		p_attr_name IN VARCHAR2,
19 		p_object_name IN VARCHAR2,
20 		p_pk_col_val IN VARCHAR2
21 	)RETURN VARCHAR2;
22 
23 PROCEDURE INSERT_TEMP_FOR_MAP
24 	(
25 		x_theme_id OUT NOCOPY NUMBER,
26 		p_session_id IN VARCHAR2,
27 		p_context_flag IN VARCHAR2,
28 		p_site_ids IN RRS_NUMBER_TBL_TYPE DEFAULT NULL,
29 		p_tag_code IN NUMBER DEFAULT NULL,
30 		p_x_coord IN NUMBER DEFAULT NULL,
31 		p_y_coord IN NUMBER DEFAULT NULL
32 	);
33 
34 PROCEDURE CLEAR_TEMP_FOR_MAP
35 	(
36 		p_session_id IN VARCHAR2,
37         	p_delete_theme IN VARCHAR2
38 	);
39 
40 FUNCTION GET_LOCATION_NAME
41 	(
42 		p_site_id IN NUMBER
43 	) RETURN VARCHAR2;
44 
45 FUNCTION GET_PROPERTY_NAME
46         (
47                 p_location_id IN NUMBER
48         ) RETURN VARCHAR2 ;
49 
50 FUNCTION GET_UOM_COLUMN_PROMPT
51 	(
52 		p_uom_class IN VARCHAR2
53 	)RETURN VARCHAR2;
54 
55 FUNCTION Update_geometry_for_locations
56  (p_loc_id IN NUMBER,
57   p_lat IN NUMBER,
58   p_long IN NUMBER,
59   p_status IN VARCHAR2
60  ) RETURN NUMBER;
61 
62 FUNCTION get_ordinate
63 	(geom IN MDSYS.SDO_GEOMETRY,
64 	 indx IN NUMBER
65 	) RETURN NUMBER;
66 
67 FUNCTION get_address
68 	(p_loc_id IN NUMBER
69 	) RETURN VARCHAR2;
70 
71 END RRS_SITE_UTILS;
72