[Home] [Help]
PACKAGE: APPS.RG_REPORT_AXES_PKG
Source
1 PACKAGE RG_REPORT_AXES_PKG AS
2 /* $Header: rgiraxes.pls 120.7 2004/07/16 18:32:58 ticheng ship $ */
3 --
4 -- Name
5 -- rg_report_axes_pkg
6 -- Purpose
7 -- to include all sever side procedures and packages for table
8 -- rg_report_axes
9 -- Notes
10 --
11 -- History
12 -- 11/01/93 A Chen Created
13 --
14 --
15 -- Procedures
16
17 -- Name
18 -- select_row
19 -- Purpose
20 -- select a axis from rg_report_axes
21 -- Arguments
22 -- recinfo
23 --
24 PROCEDURE select_row(recinfo IN OUT NOCOPY rg_report_axes%ROWTYPE);
25
26 -- Name
27 -- select_column
28 -- Purpose
29 -- select a axis name from rg_report_axes
30 -- Arguments
31 -- axis_set_id axis set id
32 -- axis_seq axis sequence
33 -- name axis name
34 --
35 PROCEDURE select_columns(X_axis_set_id NUMBER, X_axis_seq NUMBER,
36 X_name IN OUT NOCOPY VARCHAR2);
37
38 -- Name
39 -- check_unique
40 -- Purpose
41 -- unique check for name
42 -- Arguments
43 -- rowid rowid
44 -- ax_seq axis sequence
45 -- ax_set_id axis set id
46 --
47 FUNCTION check_unique(X_rowid VARCHAR2,
48 X_axis_seq NUMBER,
49 X_axis_set_id NUMBER,
50 X_axis_set_type VARCHAR2) RETURN BOOLEAN;
51
52 -- Name
53 -- construct_format
54 -- Purpose
55 -- reconstruct the display format
56 -- Arguments
57 -- display_format display format ($ 99999999.99 USD)
58 -- format_before_text format before text ('$ ')
59 -- format_after_text format after text (' USD')
60 -- display_precision display precision
61 -- format_mask_width the width of the format mask (9999999.99)
62 -- radix language specific radix character
63 -- thsnd_sprtr language specific thousands separator
64 -- po_thsnd_sprtr "Currency: Thousands Separator" profile option
65 --
66 FUNCTION construct_format(X_display_format VARCHAR2,
67 X_format_before_text VARCHAR2,
68 X_format_after_text VARCHAR2,
69 X_display_precision NUMBER,
70 X_format_mask_width NUMBER,
71 X_radix VARCHAR2,
72 X_thsnd_sprtr VARCHAR2,
73 X_po_thsnd_sprtr VARCHAR2) RETURN VARCHAR2;
74
75 -- Name
76 -- create_ruler
77 -- Purpose
78 -- create the ruler for column set header
79 -- Arguments
80 -- column_set_id column set id
81 -- radix language specific radix character
82 -- thsnd_sprtr language specific thousands separator
83 -- po_thsnd_sprtr "Currency: Thousands Separator" profile option
84 -- ruler ruler
85 --
86 PROCEDURE create_ruler( X_column_set_id NUMBER,
87 X_radix VARCHAR2,
88 X_thsnd_sprtr VARCHAR2,
89 X_po_thsnd_sprtr VARCHAR2,
90 X_ruler IN OUT NOCOPY VARCHAR2);
91
92 -- Name
93 -- default_heading
94 -- Purpose
95 -- default the column descriptions into the column set header
96 -- Arguments
97 -- column_set_id column set id
98 --
99 PROCEDURE default_heading(X_column_set_id NUMBER,
100 X_amount_type_line IN OUT NOCOPY VARCHAR2,
101 X_period_line IN OUT NOCOPY VARCHAR2,
102 X_dash_line IN OUT NOCOPY VARCHAR2);
103
104 -- *********************************************************************
105 -- The following procedures are necessary to handle the base view form.
106
107 PROCEDURE insert_row(X_rowid IN OUT NOCOPY VARCHAR2 ,
108 X_application_id NUMBER ,
109 X_axis_set_id NUMBER ,
110 X_axis_set_type VARCHAR2 ,
111 X_axis_seq NUMBER ,
112 X_last_update_date DATE ,
113 X_last_updated_by NUMBER ,
114 X_last_update_login NUMBER ,
115 X_creation_date DATE ,
116 X_created_by NUMBER ,
117 X_axis_type VARCHAR2 ,
118 X_axis_name VARCHAR2 ,
119 X_amount_id NUMBER ,
120 X_standard_axis_id NUMBER ,
121 X_width NUMBER ,
122 X_position NUMBER ,
123 X_structure_id NUMBER ,
124 X_unit_of_measure_id VARCHAR2 ,
125 X_parameter_num NUMBER ,
126 X_period_offset NUMBER ,
127 X_description VARCHAR2 ,
128 X_display_flag VARCHAR2 ,
129 X_before_axis_string VARCHAR2 ,
130 X_after_axis_string VARCHAR2 ,
131 X_number_characters_indented NUMBER ,
132 X_page_break_after_flag VARCHAR2 ,
133 X_page_break_before_flag VARCHAR2 ,
134 X_number_lines_skipped_before NUMBER ,
135 X_number_lines_skipped_after NUMBER ,
136 X_display_level NUMBER ,
137 X_display_zero_amount_flag VARCHAR2 ,
138 X_change_sign_flag VARCHAR2 ,
139 X_change_variance_sign_flag VARCHAR2 ,
140 X_display_units NUMBER ,
141 X_display_format VARCHAR2 ,
142 X_calculation_precedence_flag VARCHAR2 ,
143 X_percentage_divisor_seq NUMBER ,
144 X_transaction_flag VARCHAR2 ,
145 X_format_before_text VARCHAR2 ,
146 X_format_after_text VARCHAR2 ,
147 X_format_mask_width NUMBER ,
148 X_display_precision NUMBER ,
149 X_segment_override_value VARCHAR2 ,
150 X_override_alc_ledger_currency VARCHAR2 ,
151 X_context VARCHAR2 ,
152 X_attribute1 VARCHAR2 ,
153 X_attribute2 VARCHAR2 ,
154 X_attribute3 VARCHAR2 ,
155 X_attribute4 VARCHAR2 ,
156 X_attribute5 VARCHAR2 ,
157 X_attribute6 VARCHAR2 ,
158 X_attribute7 VARCHAR2 ,
159 X_attribute8 VARCHAR2 ,
160 X_attribute9 VARCHAR2 ,
161 X_attribute10 VARCHAR2 ,
162 X_attribute11 VARCHAR2 ,
163 X_attribute12 VARCHAR2 ,
164 X_attribute13 VARCHAR2 ,
165 X_attribute14 VARCHAR2 ,
166 X_attribute15 VARCHAR2 ,
167 X_element_id NUMBER
168 );
169
170 PROCEDURE lock_row(X_rowid IN OUT NOCOPY VARCHAR2 ,
171 X_application_id NUMBER ,
172 X_axis_set_id NUMBER ,
173 X_axis_seq NUMBER ,
174 X_axis_type VARCHAR2 ,
175 X_axis_name VARCHAR2 ,
176 X_amount_id NUMBER ,
177 X_standard_axis_id NUMBER ,
178 X_width NUMBER ,
179 X_position NUMBER ,
180 X_structure_id NUMBER ,
181 X_unit_of_measure_id VARCHAR2 ,
182 X_parameter_num NUMBER ,
183 X_period_offset NUMBER ,
184 X_description VARCHAR2 ,
185 X_display_flag VARCHAR2 ,
186 X_before_axis_string VARCHAR2 ,
187 X_after_axis_string VARCHAR2 ,
188 X_number_characters_indented NUMBER ,
189 X_page_break_after_flag VARCHAR2 ,
190 X_page_break_before_flag VARCHAR2 ,
191 X_number_lines_skipped_before NUMBER ,
192 X_number_lines_skipped_after NUMBER ,
193 X_display_level NUMBER ,
194 X_display_zero_amount_flag VARCHAR2 ,
195 X_change_sign_flag VARCHAR2 ,
196 X_change_variance_sign_flag VARCHAR2 ,
197 X_display_units NUMBER ,
198 X_display_format VARCHAR2 ,
199 X_calculation_precedence_flag VARCHAR2 ,
200 X_percentage_divisor_seq NUMBER ,
201 X_transaction_flag VARCHAR2 ,
202 X_format_before_text VARCHAR2 ,
203 X_format_after_text VARCHAR2 ,
204 X_format_mask_width NUMBER ,
205 X_display_precision NUMBER ,
206 X_segment_override_value VARCHAR2 ,
207 X_override_alc_ledger_currency VARCHAR2 ,
208 X_context VARCHAR2 ,
209 X_attribute1 VARCHAR2 ,
210 X_attribute2 VARCHAR2 ,
211 X_attribute3 VARCHAR2 ,
212 X_attribute4 VARCHAR2 ,
213 X_attribute5 VARCHAR2 ,
214 X_attribute6 VARCHAR2 ,
215 X_attribute7 VARCHAR2 ,
216 X_attribute8 VARCHAR2 ,
217 X_attribute9 VARCHAR2 ,
218 X_attribute10 VARCHAR2 ,
219 X_attribute11 VARCHAR2 ,
220 X_attribute12 VARCHAR2 ,
221 X_attribute13 VARCHAR2 ,
222 X_attribute14 VARCHAR2 ,
223 X_attribute15 VARCHAR2 ,
224 X_element_id NUMBER
225 );
226
227 PROCEDURE update_row(X_rowid IN OUT NOCOPY VARCHAR2 ,
228 X_application_id NUMBER ,
229 X_axis_set_id NUMBER ,
230 X_axis_seq NUMBER ,
231 X_last_update_date DATE ,
232 X_last_updated_by NUMBER ,
233 X_last_update_login NUMBER ,
234 X_axis_type VARCHAR2 ,
235 X_axis_name VARCHAR2 ,
236 X_amount_id NUMBER ,
237 X_standard_axis_id NUMBER ,
238 X_width NUMBER ,
239 X_position NUMBER ,
240 X_structure_id NUMBER ,
241 X_unit_of_measure_id VARCHAR2 ,
242 X_parameter_num NUMBER ,
243 X_period_offset NUMBER ,
244 X_description VARCHAR2 ,
245 X_display_flag VARCHAR2 ,
246 X_before_axis_string VARCHAR2 ,
247 X_after_axis_string VARCHAR2 ,
248 X_number_characters_indented NUMBER ,
249 X_page_break_after_flag VARCHAR2 ,
250 X_page_break_before_flag VARCHAR2 ,
251 X_number_lines_skipped_before NUMBER ,
252 X_number_lines_skipped_after NUMBER ,
253 X_display_level NUMBER ,
254 X_display_zero_amount_flag VARCHAR2 ,
255 X_change_sign_flag VARCHAR2 ,
256 X_change_variance_sign_flag VARCHAR2 ,
257 X_display_units NUMBER ,
258 X_display_format VARCHAR2 ,
259 X_calculation_precedence_flag VARCHAR2 ,
260 X_percentage_divisor_seq NUMBER ,
261 X_transaction_flag VARCHAR2 ,
262 X_format_before_text VARCHAR2 ,
263 X_format_after_text VARCHAR2 ,
264 X_format_mask_width NUMBER ,
265 X_display_precision NUMBER ,
266 X_segment_override_value VARCHAR2 ,
267 X_override_alc_ledger_currency VARCHAR2 ,
268 X_context VARCHAR2 ,
269 X_attribute1 VARCHAR2 ,
270 X_attribute2 VARCHAR2 ,
274 X_attribute6 VARCHAR2 ,
271 X_attribute3 VARCHAR2 ,
272 X_attribute4 VARCHAR2 ,
273 X_attribute5 VARCHAR2 ,
275 X_attribute7 VARCHAR2 ,
276 X_attribute8 VARCHAR2 ,
277 X_attribute9 VARCHAR2 ,
278 X_attribute10 VARCHAR2 ,
279 X_attribute11 VARCHAR2 ,
280 X_attribute12 VARCHAR2 ,
281 X_attribute13 VARCHAR2 ,
282 X_attribute14 VARCHAR2 ,
283 X_attribute15 VARCHAR2 ,
284 X_element_id NUMBER
285 );
286
287 PROCEDURE delete_row(X_rowid VARCHAR2);
288
289 PROCEDURE delete_rows(X_axis_set_id NUMBER);
290
291
292 --
293 -- Procedure
294 -- Load_Row
295 -- Purpose
296 -- Called from loader config file to upload a multi-lingual entity
297 -- History
298 -- 07-19-99 W Wong Created
299 -- Arguments
300 --
301 -- Notes
302 --
303 PROCEDURE Load_Row(
304 X_Application_Id NUMBER,
305 X_Axis_Set_Id NUMBER,
306 X_Axis_Seq NUMBER,
307 X_Axis_Type VARCHAR2,
308 X_axis_Name VARCHAR2,
309 X_Amount_Id NUMBER,
310 X_Standard_Axis_Id NUMBER,
311 X_Width NUMBER,
312 X_Position NUMBER,
313 X_Unit_Of_Measure_Id VARCHAR2,
314 X_Parameter_Num NUMBER,
315 X_Period_Offset NUMBER,
316 X_Description VARCHAR2,
317 X_Display_Flag VARCHAR2,
318 X_Before_Axis_String VARCHAR2,
319 X_After_Axis_String VARCHAR2,
320 X_Number_Characters_Indented NUMBER,
321 X_Page_Break_After_Flag VARCHAR2,
322 X_Page_Break_Before_Flag VARCHAR2,
323 X_Number_Lines_Skipped_Before NUMBER,
324 X_Number_Lines_Skipped_After NUMBER,
325 X_Display_Level NUMBER,
326 X_Display_Zero_Amount_Flag VARCHAR2,
327 X_Change_Sign_Flag VARCHAR2,
328 X_Change_Variance_Sign_Flag VARCHAR2,
329 X_Display_Units NUMBER,
330 X_Display_Format VARCHAR2,
331 X_Calculation_Precedence_Flag VARCHAR2,
332 X_Percentage_Divisor_Seq NUMBER,
333 X_Format_Before_Text VARCHAR2,
334 X_Format_After_Text VARCHAR2,
335 X_Format_Mask_Width NUMBER,
336 X_Display_Precision NUMBER,
337 X_Segment_Override_Value VARCHAR2,
338 X_Override_Alc_Ledger_Currency VARCHAR2,
339 X_Context VARCHAR2,
340 X_Attribute1 VARCHAR2,
341 X_Attribute2 VARCHAR2,
342 X_Attribute3 VARCHAR2,
343 X_Attribute4 VARCHAR2,
344 X_Attribute5 VARCHAR2,
345 X_Attribute6 VARCHAR2,
346 X_Attribute7 VARCHAR2,
347 X_Attribute8 VARCHAR2,
348 X_Attribute9 VARCHAR2,
349 X_Attribute10 VARCHAR2,
350 X_Attribute11 VARCHAR2,
351 X_Attribute12 VARCHAR2,
352 X_Attribute13 VARCHAR2,
353 X_Attribute14 VARCHAR2,
354 X_Attribute15 VARCHAR2,
355 X_Owner VARCHAR2,
356 X_Force_Edits VARCHAR2
357 );
358
359 --
360 -- Procedure
361 -- Translate_Row
362 -- Purpose
363 -- Called from loader config file to upload translations.
364 -- History
365 -- 07-19-99 W Wong Created
366 -- Arguments
367 --
368 -- Notes
369 --
370 PROCEDURE Translate_Row(
371 X_Axis_Name VARCHAR2,
372 X_Description VARCHAR2,
376 X_Force_Edits VARCHAR2
373 X_Axis_Set_Id NUMBER,
374 X_Axis_Seq NUMBER,
375 X_Owner VARCHAR2,
377 );
378
379
380 END RG_REPORT_AXES_PKG;