eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CSI_CTR_GEN_UTILITY_PVT

Source


1 PACKAGE CSI_CTR_GEN_UTILITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: csivctus.pls 120.2.12020000.1 2012/06/28 13:01:12 appldev ship $ */
3 
4 g_sid       NUMBER;
5 g_osuser    VARCHAR2(30);
6 G_PKG_NAME  CONSTANT VARCHAR2(30) := 'CSI_CTR_GEN_UTILITY_PVT';
7 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivctus.pls';
8 g_debug_level            number;
9 g_debug_file             varchar2(30);
10 g_debug_file_path        varchar2(540);
11 g_stop_on_debug_error    VARCHAR2(10);
12 
13 FUNCTION G_MISS_NUM RETURN NUMBER;
14 
15 FUNCTION G_MISS_CHAR RETURN VARCHAR2;
16 
17 FUNCTION G_MISS_DATE RETURN DATE;
18 
19 PROCEDURE put_line(p_message IN VARCHAR2);
20 
21 PROCEDURE read_debug_profiles;
22 
23 Procedure ExitWithErrMsg
24 (   p_msg_name		in	varchar2,
25     p_token1_name	in	varchar2	:=	null,
26     p_token1_val	in	varchar2	:=	null,
27     p_token2_name	in	varchar2	:=	null,
28     p_token2_val	in	varchar2	:=	null,
29     p_token3_name	in	varchar2	:=	null,
30     p_token3_val	in	varchar2	:=	null,
31     p_token4_name	in	varchar2	:=	null,
32     p_token4_val	in	varchar2	:=	null
33 );
34 
35 PROCEDURE Initialize_Desc_Flex
36 (   p_desc_flex	IN OUT NOCOPY  csi_ctr_datastructures_pub.dff_rec_type
37 );
38 
39 
40 PROCEDURE Is_DescFlex_Valid
41 (
42    p_api_name			IN	VARCHAR2,
43    p_appl_short_name		IN	VARCHAR2	:=	'CSI',
44    p_desc_flex_name		IN	VARCHAR2,
45    p_seg_partial_name		IN	VARCHAR2,
46    p_num_of_attributes		IN	NUMBER,
47    p_seg_values			IN	csi_ctr_datastructures_pub.dff_rec_type,
48    p_stack_err_msg		IN	BOOLEAN	:=	TRUE
49 );
50 
51 PROCEDURE Validate_Desc_Flex
52   ( p_api_name		IN	VARCHAR2,
53     p_appl_short_name	IN	VARCHAR2,
54     p_desc_flex_name	IN	VARCHAR2,
55     p_column_name1	IN	VARCHAR2,
56     p_column_name2	IN	VARCHAR2,
57     p_column_name3	IN	VARCHAR2,
58     p_column_name4	IN	VARCHAR2,
59     p_column_name5	IN	VARCHAR2,
60     p_column_name6	IN	VARCHAR2,
61     p_column_name7	IN	VARCHAR2,
62     p_column_name8	IN	VARCHAR2,
63     p_column_name9	IN	VARCHAR2,
64     p_column_name10	IN	VARCHAR2,
65     p_column_name11	IN	VARCHAR2,
66     p_column_name12	IN	VARCHAR2,
67     p_column_name13	IN	VARCHAR2,
68     p_column_name14	IN	VARCHAR2,
69     p_column_name15	IN	VARCHAR2,
70     p_column_name16	IN	VARCHAR2,
71     p_column_name17	IN	VARCHAR2,
72     p_column_name18	IN	VARCHAR2,
73     p_column_name19	IN	VARCHAR2,
74     p_column_name20	IN	VARCHAR2,
75     p_column_name21	IN	VARCHAR2,
76     p_column_name22	IN	VARCHAR2,
77     p_column_name23	IN	VARCHAR2,
78     p_column_name24	IN	VARCHAR2,
79     p_column_name25	IN	VARCHAR2,
80     p_column_name26	IN	VARCHAR2,
81     p_column_name27	IN	VARCHAR2,
82     p_column_name28	IN	VARCHAR2,
83     p_column_name29	IN	VARCHAR2,
84     p_column_name30	IN	VARCHAR2,
85     p_column_value1	IN	VARCHAR2,
86     p_column_value2	IN	VARCHAR2,
87     p_column_value3	IN	VARCHAR2,
88     p_column_value4	IN	VARCHAR2,
89     p_column_value5	IN	VARCHAR2,
90     p_column_value6	IN	VARCHAR2,
91     p_column_value7	IN	VARCHAR2,
92     p_column_value8	IN	VARCHAR2,
93     p_column_value9	IN	VARCHAR2,
94     p_column_value10	IN	VARCHAR2,
95     p_column_value11	IN	VARCHAR2,
96     p_column_value12	IN	VARCHAR2,
97     p_column_value13	IN	VARCHAR2,
98     p_column_value14	IN	VARCHAR2,
99     p_column_value15	IN	VARCHAR2,
100     p_column_value16	IN	VARCHAR2,
101     p_column_value17	IN	VARCHAR2,
102     p_column_value18	IN	VARCHAR2,
103     p_column_value19	IN	VARCHAR2,
104     p_column_value20	IN	VARCHAR2,
105     p_column_value21	IN	VARCHAR2,
106     p_column_value22	IN	VARCHAR2,
107     p_column_value23	IN	VARCHAR2,
108     p_column_value24	IN	VARCHAR2,
109     p_column_value25	IN	VARCHAR2,
110     p_column_value26	IN	VARCHAR2,
111     p_column_value27	IN	VARCHAR2,
112     p_column_value28	IN	VARCHAR2,
113     p_column_value29	IN	VARCHAR2,
114     p_column_value30	IN	VARCHAR2,
115     p_context_value	IN	VARCHAR2,
116     p_resp_appl_id	IN	NUMBER,
117     p_resp_id		IN	NUMBER,
118     x_return_status	OUT	NOCOPY VARCHAR2 );
119 
120 PROCEDURE VALIDATE_FORMULA_CTR
121 (
122    p_api_version        IN	NUMBER,
123    p_init_msg_list	IN	VARCHAR2	:= FND_API.G_FALSE,
124    p_commit		IN	VARCHAR2	:= FND_API.G_FALSE,
125    p_validation_level	IN	VARCHAR2	:= FND_API.G_VALID_LEVEL_FULL,
126    x_return_status		OUT	NOCOPY VARCHAR2,
127    x_msg_count		OUT     NOCOPY  NUMBER,
128    x_msg_data		OUT     NOCOPY  VARCHAR2,
129    p_counter_id		IN	NUMBER,
130    x_valid_flag		OUT     NOCOPY  VARCHAR2
131 );
132 
133 PROCEDURE VALIDATE_GRPOP_CTR
134 (
135     p_api_version	IN	NUMBER,
136     p_init_msg_list	IN	VARCHAR2	:= FND_API.G_FALSE,
137     p_commit		IN	VARCHAR2	:= FND_API.G_FALSE,
138     p_validation_level	IN	VARCHAR2	:= FND_API.G_VALID_LEVEL_FULL,
139     x_return_status		OUT     NOCOPY VARCHAR2,
140     x_msg_count		OUT	NOCOPY NUMBER,
141     x_msg_data		OUT	NOCOPY VARCHAR2,
142     p_counter_id	IN	NUMBER,
143     x_valid_flag		OUT     NOCOPY VARCHAR2
144 );
145 
146 FUNCTION Is_StartEndDate_Valid
147 (
148     p_st_dt              IN      DATE,
149     p_end_dt             IN      DATE,
150     p_stack_err_msg      IN      BOOLEAN := TRUE
151 ) RETURN BOOLEAN;
152 
153 PROCEDURE Initialize_Desc_Flex_For_Upd
154 (
155 	l_ctr_derived_filters_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec,
156 	l_old_ctr_derived_filters_rec IN		CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_rec
157 );
158 
159 PROCEDURE check_ib_active;
160 
161 PROCEDURE dump_ctr_grp_rec
162    (p_counter_groups_rec IN  csi_ctr_datastructures_pub.counter_groups_rec);
163 
164 PROCEDURE dump_ctr_grp_tbl
165    (p_counter_groups_tbl IN  csi_ctr_datastructures_pub.counter_groups_tbl);
166 
167 PROCEDURE dump_ctr_template_rec
168    (p_counter_template_rec IN  csi_ctr_datastructures_pub.counter_template_rec);
169 
170 PROCEDURE dump_ctr_template_tbl
171    (p_counter_template_tbl IN  csi_ctr_datastructures_pub.counter_template_tbl);
172 
173 PROCEDURE dump_ctr_item_assoc_rec
174    (p_ctr_item_associations_rec IN  csi_ctr_datastructures_pub.ctr_item_associations_rec);
175 
176 PROCEDURE dump_ctr_item_assoc_tbl
177    (p_ctr_item_associations_tbl IN  csi_ctr_datastructures_pub.ctr_item_associations_tbl);
178 
179 PROCEDURE dump_ctr_relationship_rec
180    (p_counter_relationships_rec IN  csi_ctr_datastructures_pub.counter_relationships_rec);
181 
182 PROCEDURE dump_ctr_relationship_tbl
183    (p_counter_relationships_tbl IN  csi_ctr_datastructures_pub.counter_relationships_tbl);
184 
185 PROCEDURE dump_ctr_property_template_rec
186    (p_ctr_property_template_rec IN  csi_ctr_datastructures_pub.ctr_property_template_rec);
187 
188 PROCEDURE dump_ctr_property_template_tbl
189    (p_ctr_property_template_tbl IN  csi_ctr_datastructures_pub.ctr_property_template_tbl);
190 
191 PROCEDURE dm_ctr_estimation_methods_rec
192    (p_ctr_estimation_methods_rec IN  csi_ctr_datastructures_pub.ctr_estimation_methods_rec);
193 
194 PROCEDURE dm_ctr_estimation_methods_tbl
195    (p_ctr_estimation_methods_tbl IN  csi_ctr_datastructures_pub.ctr_estimation_methods_tbl);
196 
197 PROCEDURE dump_ctr_derived_filters_rec
198    (p_ctr_derived_filters_rec IN  csi_ctr_datastructures_pub.ctr_derived_filters_rec);
199 
200 PROCEDURE dump_ctr_derived_filters_tbl
201    (p_ctr_derived_filters_tbl IN  csi_ctr_datastructures_pub.ctr_derived_filters_tbl);
202 
203 PROCEDURE dump_counter_instance_rec
204    (p_counter_instance_rec IN  csi_ctr_datastructures_pub.counter_instance_rec);
205 
206 PROCEDURE dump_counter_instance_tbl
207    (p_counter_instance_tbl IN  csi_ctr_datastructures_pub.counter_instance_tbl);
208 
209 PROCEDURE dump_ctr_properties_rec
210    (p_ctr_properties_rec IN  csi_ctr_datastructures_pub.ctr_properties_rec);
211 
212 PROCEDURE dump_ctr_properties_tbl
213    (p_ctr_properties_tbl IN  csi_ctr_datastructures_pub.ctr_properties_tbl);
214 
215 PROCEDURE dump_counter_associations_rec
216    (p_counter_associations_rec IN  csi_ctr_datastructures_pub.counter_associations_rec);
217 
218 PROCEDURE dump_counter_associations_tbl
219    (p_counter_associations_tbl IN  csi_ctr_datastructures_pub.counter_associations_tbl);
220 
221 PROCEDURE dump_counter_readings_rec
222    (p_counter_readings_rec IN  csi_ctr_datastructures_pub.counter_readings_rec);
223 
224 PROCEDURE dump_counter_readings_tbl
225    (p_counter_readings_tbl IN  csi_ctr_datastructures_pub.counter_readings_tbl);
226 
227 PROCEDURE dump_ctr_property_readings_rec
228    (p_ctr_property_readings_rec IN  csi_ctr_datastructures_pub.ctr_property_readings_rec);
229 
230 PROCEDURE dump_ctr_property_readings_tbl
231    (p_ctr_property_readings_tbl IN  csi_ctr_datastructures_pub.ctr_property_readings_tbl);
232 
233 PROCEDURE dump_ctr_usage_forecast_rec
234    (p_ctr_usage_forecast_rec IN  csi_ctr_datastructures_pub.ctr_usage_forecast_rec);
235 
236 PROCEDURE dump_ctr_usage_forecast_tbl
237    (p_ctr_usage_forecast_tbl IN  csi_ctr_datastructures_pub.ctr_usage_forecast_tbl);
238 
239 PROCEDURE dump_ctr_reading_lock_rec
240    (p_ctr_reading_lock_rec IN  csi_ctr_datastructures_pub.ctr_reading_lock_rec);
241 
242 PROCEDURE dump_ctr_reading_lock_tbl
243    (p_ctr_reading_lock_tbl IN  csi_ctr_datastructures_pub.ctr_reading_lock_tbl);
244 
245 PROCEDURE dm_ctr_estimated_readings_rec
246    (p_ctr_estimated_readings_rec IN  csi_ctr_datastructures_pub.ctr_estimated_readings_rec);
247 
248 PROCEDURE dm_ctr_estimated_readings_tbl
249    (p_ctr_estimated_readings_tbl IN  csi_ctr_datastructures_pub.ctr_estimated_readings_tbl);
250 
251 PROCEDURE dm_ctr_readings_interface_rec
252    (p_ctr_readings_interface_rec IN  csi_ctr_datastructures_pub.ctr_readings_interface_rec);
253 
254 PROCEDURE dm_ctr_readings_interface_tbl
255    (p_ctr_readings_interface_tbl IN  csi_ctr_datastructures_pub.ctr_readings_interface_tbl);
256 
257 PROCEDURE dm_ctr_read_prop_interface_rec
258    (p_ctr_read_prop_interface_rec IN  csi_ctr_datastructures_pub.ctr_read_prop_interface_rec);
259 
260 PROCEDURE dm_ctr_read_prop_interface_tbl
261    (p_ctr_read_prop_interface_tbl IN  csi_ctr_datastructures_pub.ctr_read_prop_interface_tbl);
262 
263 PROCEDURE dump_txn_rec
264    (p_txn_rec   IN  csi_datastructures_pub.transaction_rec);
265 
266 PROCEDURE dump_txn_tbl
267    (p_txn_tbl   IN  csi_datastructures_pub.transaction_tbl);
268 
269 END CSI_CTR_GEN_UTILITY_PVT;