1 package fa_rx_publish AUTHID CURRENT_USER as
2 /* $Header: FARXPBSS.pls 120.5 2009/06/03 06:42:21 deemitta ship $ */
3
4 -------------------------------------------
5 -- Globals
6 -------------------------------------------
7 page_break_level CONSTANT NUMBER := -1;
8 page_carry_forward_level CONSTANT NUMBER := -2;
9 report_break_level CONSTANT NUMBER := -3;
10
11 --* Bug 8402286
12 --* This value is used in the package to get the message text, that needs to be shouwn in
13 --* the report heading. Refer to bug#4394814, for furhter details.
14 --*
15 G_Moac_Message_Code Constant Varchar2(100) := 'FND_MO_RPT_PARTIAL_LEDGER';
16
17 --*
18 --* if this value is stored in the fnd_concurrent_programs.multi_org_category,
19 --* then we need to handle the MOAC changes, of displaying the message.
20 --*
21 G_Moac_Mo_Category_Conc_Flag Constant Varchar2(10) := 'M';
22
23
24
25 ----------------------------------------------------------
26 -- This routine are used by the RXi publishing engine.
27 -- These routines are meant only to provide information
28 -- to the publishing engine.
29 --------
30 -- The following outlines the how these functions should be called:
31 --
32 --
33 -- Init_Report or Init_Request
34 -- Get_Report_Info
35 -- Loop
36 -- Start_Format
37 -- Get_Format_Info
38 -- For i in 1..Get_Param_Count Loop
39 -- Get_Parameter
40 -- End Loop
41 -- For i in 1..Get_Break_Level_Count Loop
42 -- For j in 1..Get_Column_Count(i) Loop
43 -- Get_Column_Info
44 -- End Loop
45 -- For j in 1..Get_Summary_Column_Count(i) Loop
46 -- Get_Summary_Column_Info
47 -- End Loop
48 -- End Loop
49 --
50 -- Output Data
51 --
52 -- End_Format
53 -- While Format_Available
54 ----------------------------------------------------------
55
56
57
58
59 ------------------------------------------------------------------
60 -- Get_Report_Name
61 --
62 -- Given a report_id, this routine returns
63 -- the application short name and concurrent program name of the
64 -- associated concurrent program.
65 -- If this is a Direct Select RX, it will return a NULL value
66 -- for p_appname and p_concname
67 ------------------------------------------------------------------
68 PROCEDURE get_report_name(
69 p_report_id IN NUMBER,
70 p_appname OUT NOCOPY VARCHAR2,
71 p_concname OUT NOCOPY VARCHAR2);
72
73 ------------------------------------------------------------------
74 -- Init_Request
75 --
76 -- Initializes this package with the given request ID, report ID,
77 -- attribute set and output format.
78 -- Should not call this for Direct Select RX.
79 -- Should only be called once per session.
80 ------------------------------------------------------------------
81 PROCEDURE init_request(p_request_id IN NUMBER,
82 p_report_id IN NUMBER,
83 p_attribute_set IN VARCHAR2,
84 p_output_format IN VARCHAR2,
85 p_request_type IN VARCHAR2 DEFAULT 'PUBLISH');
86
87 ------------------------------------------------------------------
88 -- Init_Report
89 --
90 -- Initializes this package with the given report ID, attribute
91 -- set, output format, and concurrent program arguments.
92 -- This routine should only be called for Direct Select RX.
93 -- This routine should only be called once per session.
94 ------------------------------------------------------------------
95 PROCEDURE init_report(
96 p_report_id IN NUMBER,
97 p_attribute_set IN VARCHAR2,
98 p_output_format IN VARCHAR2,
99 p_argument1 IN VARCHAR2 ,
100 p_argument2 IN VARCHAR2 ,
101 p_argument3 IN VARCHAR2 ,
102 p_argument4 IN VARCHAR2 ,
103 p_argument5 IN VARCHAR2 ,
104 p_argument6 IN VARCHAR2 ,
105 p_argument7 IN VARCHAR2 ,
106 p_argument8 IN VARCHAR2 ,
107 p_argument9 IN VARCHAR2 ,
108 p_argument10 IN VARCHAR2 ,
109 p_argument11 IN VARCHAR2 ,
110 p_argument12 IN VARCHAR2 ,
111 p_argument13 IN VARCHAR2 ,
112 p_argument14 IN VARCHAR2 ,
113 p_argument15 IN VARCHAR2 ,
114 p_argument16 IN VARCHAR2 ,
115 p_argument17 IN VARCHAR2 ,
116 p_argument18 IN VARCHAR2 ,
117 p_argument19 IN VARCHAR2 ,
118 p_argument20 IN VARCHAR2 ,
119 p_argument21 IN VARCHAR2 ,
120 p_argument22 IN VARCHAR2 ,
121 p_argument23 IN VARCHAR2 ,
122 p_argument24 IN VARCHAR2 ,
123 p_argument25 IN VARCHAR2 ,
124 p_argument26 IN VARCHAR2 ,
125 p_argument27 IN VARCHAR2 ,
126 p_argument28 IN VARCHAR2 ,
127 p_argument29 IN VARCHAR2 ,
128 p_argument30 IN VARCHAR2 ,
129 p_argument31 IN VARCHAR2 ,
130 p_argument32 IN VARCHAR2 ,
131 p_argument33 IN VARCHAR2 ,
132 p_argument34 IN VARCHAR2 ,
133 p_argument35 IN VARCHAR2 ,
134 p_argument36 IN VARCHAR2 ,
135 p_argument37 IN VARCHAR2 ,
136 p_argument38 IN VARCHAR2 ,
137 p_argument39 IN VARCHAR2 ,
138 p_argument40 IN VARCHAR2 ,
139 p_argument41 IN VARCHAR2 ,
140 p_argument42 IN VARCHAR2 ,
141 p_argument43 IN VARCHAR2 ,
142 p_argument44 IN VARCHAR2 ,
143 p_argument45 IN VARCHAR2 ,
144 p_argument46 IN VARCHAR2 ,
145 p_argument47 IN VARCHAR2 ,
146 p_argument48 IN VARCHAR2 ,
147 p_argument49 IN VARCHAR2 ,
148 p_argument50 IN VARCHAR2 ,
149 p_argument51 IN VARCHAR2 ,
150 p_argument52 IN VARCHAR2 ,
151 p_argument53 IN VARCHAR2 ,
152 p_argument54 IN VARCHAR2 ,
153 p_argument55 IN VARCHAR2 ,
154 p_argument56 IN VARCHAR2 ,
155 p_argument57 IN VARCHAR2 ,
156 p_argument58 IN VARCHAR2 ,
157 p_argument59 IN VARCHAR2 ,
158 p_argument60 IN VARCHAR2 ,
159 p_argument61 IN VARCHAR2 ,
160 p_argument62 IN VARCHAR2 ,
161 p_argument63 IN VARCHAR2 ,
162 p_argument64 IN VARCHAR2 ,
163 p_argument65 IN VARCHAR2 ,
164 p_argument66 IN VARCHAR2 ,
165 p_argument67 IN VARCHAR2 ,
166 p_argument68 IN VARCHAR2 ,
167 p_argument69 IN VARCHAR2 ,
168 p_argument70 IN VARCHAR2 ,
169 p_argument71 IN VARCHAR2 ,
170 p_argument72 IN VARCHAR2 ,
171 p_argument73 IN VARCHAR2 ,
172 p_argument74 IN VARCHAR2 ,
173 p_argument75 IN VARCHAR2 ,
174 p_argument76 IN VARCHAR2 ,
175 p_argument77 IN VARCHAR2 ,
176 p_argument78 IN VARCHAR2 ,
177 p_argument79 IN VARCHAR2 ,
178 p_argument80 IN VARCHAR2 ,
179 p_argument81 IN VARCHAR2 ,
180 p_argument82 IN VARCHAR2 ,
181 p_argument83 IN VARCHAR2 ,
182 p_argument84 IN VARCHAR2 ,
183 p_argument85 IN VARCHAR2 ,
184 p_argument86 IN VARCHAR2 ,
185 p_argument87 IN VARCHAR2 ,
186 p_argument88 IN VARCHAR2 ,
187 p_argument89 IN VARCHAR2 ,
188 p_argument90 IN VARCHAR2 ,
189 p_argument91 IN VARCHAR2 ,
190 p_argument92 IN VARCHAR2 ,
191 p_argument93 IN VARCHAR2 ,
192 p_argument94 IN VARCHAR2 ,
193 p_argument95 IN VARCHAR2 ,
194 p_argument96 IN VARCHAR2 ,
195 p_argument97 IN VARCHAR2 ,
196 p_argument98 IN VARCHAR2 ,
197 p_argument99 IN VARCHAR2 ,
198 p_argument100 IN VARCHAR2 );
199
200 ------------------------------------------------------------------
201 -- Get_Report_Info
202 --
203 -- This routine returns report level information.
204 -- These are information that should not change between formats.
205 ------------------------------------------------------------------
206 PROCEDURE get_report_info(
207 p_display_report_title OUT NOCOPY VARCHAR2,
208 p_display_set_of_books OUT NOCOPY VARCHAR2,
209 p_display_functional_currency OUT NOCOPY VARCHAR2,
210 p_display_submission_date OUT NOCOPY VARCHAR2,
211 p_display_current_page OUT NOCOPY VARCHAR2,
212 p_display_total_page OUT NOCOPY VARCHAR2,
213 p_report_title OUT NOCOPY VARCHAR2,
214 p_set_of_books_name OUT NOCOPY VARCHAR2,
215 p_function_currency_prompt OUT NOCOPY VARCHAR2,
216 p_function_currency OUT NOCOPY VARCHAR2,
217 p_submission_date OUT NOCOPY VARCHAR2,
218 p_report_date_prompt OUT NOCOPY VARCHAR2, --* bug#2902895, rravunny
219 p_current_page_prompt OUT NOCOPY VARCHAR2,
220 p_total_page_prompt OUT NOCOPY VARCHAR2,
221 p_page_width OUT NOCOPY NUMBER,
222 p_page_height OUT NOCOPY NUMBER,
223 p_output_format OUT NOCOPY VARCHAR2,
224 p_nls_end_of_report OUT NOCOPY VARCHAR2,
225 p_nls_no_data_found OUT NOCOPY VARCHAR2);
226
227 ------------------------------------------------------------------
228 -- Bug 8460187: RER Project overloaded this function
229 -- Get_Report_Info
230 -- This routine returns report level information.
231 -- These are information that should not change between formats.
232 ------------------------------------------------------------------
233 PROCEDURE get_report_info(
234 p_display_report_title OUT NOCOPY VARCHAR2,
235 p_display_set_of_books OUT NOCOPY VARCHAR2,
236 p_display_functional_currency OUT NOCOPY VARCHAR2,
237 p_display_submission_date OUT NOCOPY VARCHAR2,
238 p_display_current_page OUT NOCOPY VARCHAR2,
239 p_display_total_page OUT NOCOPY VARCHAR2,
240 p_report_title OUT NOCOPY VARCHAR2,
241 p_set_of_books_name OUT NOCOPY VARCHAR2,
242 p_function_currency_prompt OUT NOCOPY VARCHAR2,
243 p_function_currency OUT NOCOPY VARCHAR2,
244 p_submission_date OUT NOCOPY VARCHAR2,
245 p_current_page_prompt OUT NOCOPY VARCHAR2,
246 p_total_page_prompt OUT NOCOPY VARCHAR2,
247 p_page_width OUT NOCOPY NUMBER,
248 p_page_height OUT NOCOPY NUMBER,
249 p_output_format OUT NOCOPY VARCHAR2,
250 p_nls_end_of_report OUT NOCOPY VARCHAR2,
251 p_nls_no_data_found OUT NOCOPY VARCHAR2);
252
253 ------------------------------------------------------------------
254 -- Get_Format_Info
255 --
256 -- This routine returns format level information.
257 -- These are information that may change from format to format.
258 ------------------------------------------------------------------
259 PROCEDURE get_format_info(
260 p_display_parameters OUT NOCOPY VARCHAR2,
261 p_display_page_break OUT NOCOPY VARCHAR2,
262 p_group_display_type OUT NOCOPY VARCHAR2);
263
264 ------------------------------------------------------------------
265 -- Get_Param_Count
266 --
267 -- Returns the number of parameters for the current format.
268 ------------------------------------------------------------------
269 FUNCTION get_param_count RETURN NUMBER;
270
271 ------------------------------------------------------------------
272 -- Get_Parameter
273 --
274 -- Returns parameter information.
275 -- Must be called exact number of times as is returned by
276 -- Get_Param_Count.
277 ------------------------------------------------------------------
278 PROCEDURE get_parameter(
279 p_param_id IN NUMBER,
280 p_param_name OUT NOCOPY VARCHAR2,
281 p_param_value OUT NOCOPY VARCHAR2);
282
283 ------------------------------------------------------------------
284 -- Get_Break_Level
285 --
286 -- Returns the number of break levels in the current format.
287 ------------------------------------------------------------------
288 FUNCTION get_break_level_count RETURN NUMBER;
289
290
291 ------------------------------------------------------------------
292 -- Get_Column_Count
293 --
294 -- Returns the number of columns in the given break level.
295 -- Break level should be between 1 and the returned value of
296 -- Get_Break_Level.
297 ------------------------------------------------------------------
298 FUNCTION get_column_count(
299 p_break_level IN NUMBER) RETURN NUMBER;
300
301
302 ------------------------------------------------------------------
303 -- Get_Column_Info
304 --
305 -- Returns the column information for the given break level.
306 -- This routine must be called as many times as is returned
307 -- by Get_Column_Count.
308 ------------------------------------------------------------------
309 PROCEDURE get_column_info(
310 p_break_level IN NUMBER,
311 p_column_id OUT NOCOPY NUMBER,
312 p_column_name OUT NOCOPY VARCHAR2,
313 p_column_type OUT NOCOPY VARCHAR2,
314 p_attribute_name OUT NOCOPY VARCHAR2,
315 p_length OUT NOCOPY NUMBER,
316 p_currency_column_id OUT NOCOPY NUMBER,
317 p_precision OUT NOCOPY NUMBER,
318 p_minimum_accountable_unit OUT NOCOPY NUMBER,
319 p_break OUT NOCOPY VARCHAR2);
320
321 ------------------------------------------------------------------
322 -- Get_Summary_Column_Count
323 --
324 -- Returns the number of summary columns in the given break level.
325 -- Break level should be between 1 and the returned value of
326 -- Get_Break_Level.
327 ------------------------------------------------------------------
328 FUNCTION get_summary_column_count(
329 p_break_level IN NUMBER) RETURN NUMBER;
330
331
332 ------------------------------------------------------------------
333 -- Get_Summary_Column_Info
334 --
335 -- Returns the summary column information for the given break level.
336 -- This routine must be called as many times as is returned
337 -- by Get_Summary_Column_Count.
338 ------------------------------------------------------------------
339 PROCEDURE get_summary_column_info(
340 p_break_level IN NUMBER,
341 p_summary_column_id OUT NOCOPY NUMBER,
342 p_prompt OUT NOCOPY VARCHAR2,
343 p_source_column_id OUT NOCOPY NUMBER);
344
345
346 ------------------------------------------------------------------
347 -- Start_Format
348 --
349 -- This routine should be called at the beginning of every format.
350 ------------------------------------------------------------------
351 PROCEDURE start_format;
352
353 ------------------------------------------------------------------
354 -- End_Format
355 --
356 -- This routine should be called at the end of every format.
357 ------------------------------------------------------------------
358 PROCEDURE end_format;
359
360 ------------------------------------------------------------------
361 -- Format Available
362 --
363 -- This routine should be called after a format ends to determine
364 -- if there are any more formats.
365 ------------------------------------------------------------------
366 FUNCTION format_available RETURN VARCHAR2;
367
368
369 ------------------------------------------------------------------
370 -- Get_Select_Stmt
371 --
372 -- This routine returns the main select statment.
373 -- There will be no bind variables here.
374 ------------------------------------------------------------------
375 FUNCTION get_select_stmt RETURN VARCHAR2;
376
377
378 ------------------------------------------------------------------
379 -- Get_All_Column_Count
380 --
381 -- This routine returns the number of columns in the select
382 -- statement returned by Get_Select_Stmt
383 -- May return more than get_break_level_count * get_column_count
384 -- since the select statement may include currency columns
385 -- as well.
386 ------------------------------------------------------------------
387 function get_all_column_count return number;
388 function get_disp_column_count return number;
389
390
394 -- This routine returns information required for formatting.
391 ------------------------------------------------------------------
392 -- Get_Format_Col_Info
393 --
395 -- It will return the columns in order of the column_id returned
396 -- by Get_Column_Info. The p_currency_column_id returned here
397 -- will also point to a valid column_id returned by this routine.
398 ------------------------------------------------------------------
399 PROCEDURE get_format_col_info(
400 p_column_name OUT NOCOPY VARCHAR2,
401 p_display_format OUT NOCOPY VARCHAR2,
402 p_display_length OUT NOCOPY NUMBER,
403 p_break_group_level OUT NOCOPY NUMBER,
404 p_format_mask OUT NOCOPY VARCHAR2,
405 p_currency_column_id OUT NOCOPY NUMBER,
406 p_precision OUT NOCOPY NUMBER,
407 p_minunit OUT NOCOPY NUMBER);
408
409
410 ------------------------------------------------------------------
411 -- Get_All_Summary_Count
412 --
413 -- This routine returns the number of summary columns
414 ------------------------------------------------------------------
415 FUNCTION get_all_summary_count RETURN NUMBER;
416
417 ------------------------------------------------------------------
418 -- Get_Format_Sum_Info
419 --
420 -- This routine returns information about summary columns as required
421 -- to format.
422 -- p_source_column_id will point to a valid column_id returned
423 -- by Get_Format_Column_Info.
424 -- This routine will return the columns in order of p_summary_column_id
425 -- returned by Get_Summary_Column_Info
426 ------------------------------------------------------------------
427 PROCEDURE get_format_sum_info(
428 p_source_column_id OUT NOCOPY NUMBER,
429 p_reset_level OUT NOCOPY NUMBER,
430 p_compute_level OUT NOCOPY NUMBER,
431 p_summary_function OUT NOCOPY VARCHAR2);
432
433 -----------------------------------------
434 -- Handle Bind variables
435 -----------------------------------------
436 FUNCTION get_bind_count RETURN NUMBER;
437 FUNCTION get_bind_variable RETURN VARCHAR2;
438
439 ------------------------------------------------------------------
440 -- Get_Rows_Purged
441 --
442 -- This routine returns the number of rows purged.
443 ------------------------------------------------------------------
444 PROCEDURE get_rows_purged(request_id IN VARCHAR2, l_report_id IN NUMBER,
445 l_purge_api OUT NOCOPY VARCHAR2, row_num out NUMBER);
446
447 Procedure Get_Moac_Message(xMoac_Message out NOCOPY Varchar2);
448
449 end fa_rx_publish;