PACKAGE: APPS.RRS_SITE_UTILS

Source

1 PACKAGE RRS_SITE_UTILS AUTHID CURRENT_USER AS
2 /* $Header: RRSUTILS.pls 120.15 2010/07/02 09:56:40 vmalline ship $ */
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 
56 
57 FUNCTION get_ordinate
58 	(geom IN MDSYS.SDO_GEOMETRY,
59 	 indx IN NUMBER
60 	) RETURN NUMBER;
61 
62 FUNCTION get_address
63 	(p_loc_id IN NUMBER
64 	) RETURN VARCHAR2;
65 
66 PROCEDURE Update_geometry_for_locations
67  (p_loc_id IN NUMBER,
68   p_lat IN NUMBER,
69   p_long IN NUMBER,
70   p_status IN VARCHAR2,
71   p_geo_source IN VARCHAR2 DEFAULT 'RRS_GOOGLE',
72   x_return_status OUT NOCOPY VARCHAR2,
73   x_msg_count OUT NOCOPY NUMBER,
74   x_msg_data  OUT NOCOPY VARCHAR2
75  ) ;
76 
77 /* Added for bugfix 8800595 */
78 PROCEDURE get_geometry_for_location
79  (p_loc_id IN NUMBER,
80   x_geo_source OUT NOCOPY VARCHAR2,
81 	x_null_flag OUT NOCOPY VARCHAR2,
82   x_latitude OUT NOCOPY NUMBER,
83   x_longitude OUT NOCOPY NUMBER,
84   x_return_status OUT NOCOPY VARCHAR2,
85   x_msg_count OUT NOCOPY NUMBER,
86   x_msg_data  OUT NOCOPY VARCHAR2
87  ) ;
88 
89 /* Added for bugfix 8903725 */
90 PROCEDURE set_geometry_src_for_location
91  (p_loc_id IN NUMBER,
92   x_geo_source_was_null OUT NOCOPY VARCHAR2,
93   x_geo_source_set_value OUT NOCOPY VARCHAR2,
94   x_return_status OUT NOCOPY VARCHAR2,
95   x_msg_count OUT NOCOPY NUMBER,
96   x_msg_data  OUT NOCOPY VARCHAR2
97  ) ;
98 
99 PROCEDURE default_site_numbers
100  (p_result_format_usage_id IN NUMBER,
101   p_site_number_col_name VARCHAR2,
102   p_site_name_col_name VARCHAR2,
103   x_return_status OUT NOCOPY VARCHAR2,
104   x_msg_data  OUT NOCOPY VARCHAR2
105  ) ;
106 
107 Procedure Add_Favorite_objects(P_OBJECT_TYPE IN VARCHAR2,
108                                P_OBJECT_ID   IN VARCHAR2,
109                                P_OBJECT_NAME IN VARCHAR2,
110                                P_USER_ID     IN NUMBER,
111                                X_RET_STATUS  OUT NOCOPY VARCHAR2);
112 
113 Procedure isAGAndClsAssocDeletable
114 (
115 	p_application_id	IN 		NUMBER,
116 	p_classification_code	IN 		VARCHAR2,
117 	p_attr_group_type	IN 		VARCHAR2,
118 	p_attr_group_name	IN 		VARCHAR2,
119 	x_is_ag_deletable	OUT NOCOPY 	VARCHAR2
120 );
121 FUNCTION get_multiAG_count(
122 						   p_result_format_usage_id IN NUMBER
123                           )RETURN NUMBER;
124 END RRS_SITE_UTILS;