1 PACKAGE JA_CN_CFS_CONC_PROG AUTHID CURRENT_USER AS
2 --$Header: JACNCFSS.pls 120.4 2010/09/25 01:28:25 riqi ship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation
5 --| Redwood Shores, CA, USA
6 --| All rights reserved.
7 --+=======================================================================
8 --| FILENAME
9 --| JACNCFSS.pls
10 --|
11 --| DESCRIPTION
12 --|
13 --| This is a wrapper package for submission of cash flow
14 --| statement related concurrent programs
15 --|
16 --|
17 --| PROCEDURE LIST
18 --| Cfs_Generate
19 --| Cfs_Calculate
20 --| Cfsse_Generate
21 --| Cfsse_Calculate
22 --| Collect_Cfs_Data
23 --|
24 --| HISTORY
25 --| 27-Mar-2006 Donghai Wang Created
26 --| 28-Mar-2006 Jackey Li Add Cfsse_Generate and Cfsse_Calculate
27 --| 28-Mar-2006 Andrew Liu Add Collect_Cfs_Data
28 --| 30-Mar-2006 Andrew Liu Add GL_Validation/Intercompany_Validation
29 --| 26-Jun-2006 Jackey Li Update Cfsse_Generate
30 --| 02/09/2008 Chaoqun Wu Updated
31 --| CNAO Enhancement: add company segment
32 --| 22-Sep-2008 Chaoqun Wu CNAO Enhancement for small enterprise
33 --| 20-Sep-2010 Richard Qi Commented Cfs_Detail_Report for using XML Publisher for this report
34 --+======================================================================*/
35
36 --==========================================================================
37 -- PROCEDURE NAME:
38 --
39 -- Cfs_Generate Public
40 --
41 -- DESCRIPTION:
42 --
43 -- The 'Cfs_Generate' procedure accepts parameters from concurrent program
44 -- 'Cash Flow Statement - Generation' and calls another procedure
45 -- 'JA_CN_CFS_GENERATE_PKG.Submit_Requests' with parameters after processing.
46 --
47 -- PARAMETERS:
48 -- In: p_legal_entity_id Identifier of legal entity
49 -- for FSG report
50 -- p_set_of_bks_id Identifier of gl set of book
51 -- p_coa_id Identifier of gl chart of account
52 -- p_adhoc_prefix Ad hoc prefix for FSG report, a required
53 -- parameter for FSG report
54 -- p_industry Industry with constant value 'C' for
55 -- now, a required parameter for FSG report
56 -- p_id_flex_code ID flex code, a required parameter for
57 -- FSG report
58 -- p_report_id Identifier of FSG report
59 -- p_period_name GL period Name
60 -- p_axis_set_id Identifier of FSG Row Set
61 -- p_colset_id Identifier of FSG Column Set, a required
62 -- parameter for FSG
63 -- p_rounding_option Rounding option for amount in Cash Flow
64 -- statement
65 -- p_segment_override Segment override for FSG report
66 -- flow statement calculation
67 -- p_accounting_date Accounting date
68 -- p_parameter_set_id Parameter set id, a required parameter
69 -- for FSG report
70 -- p_max_page_length Maximum page length
71 -- p_balance_type Type of balance, available value is
72 -- 'YTD/QTD/PTD'. a required parameter for
73 -- FSG report
74 -- p_internal_trx_flag To indicate if intercompany transactions
75 -- should be involved in amount calculation
76 -- of cash flow statement.
77 -- p_xml_template_language Template language of Cash Flow Statement
78 -- p_xml_template_territory Template territory of Cash Flow Statement
79 -- p_xml_output_format Output format of Cash Flow Statement
80 -- p_source_charset Characterset of input file for characterset
81 -- conversion
82 -- p_destination_charset Characterset of output file for characterset
83 -- conversion
84 -- p_source_separator Separater between fields in input file
85 -- for conversion
86 -- p_destination_filename file name after change
87 --
88 -- Out: errbuf
89 -- retcode
90 --
91 -- DESIGN REFERENCES:
92 -- CNAO_Cashflow_Statement_Generation_TD.doc
93 --
94 -- CHANGE HISTORY:
95 --
96 -- 27-Mar-2006 Donghai Wang Created
97 --
98 --=========================================================================
99 PROCEDURE Cfs_Generate(errbuf OUT NOCOPY VARCHAR2,
100 retcode OUT NOCOPY VARCHAR2,
101 p_legal_entity_id IN NUMBER,
102 p_ledger_id IN NUMBER,
103 P_DATA_ACCESS_SET_ID IN NUMBER,
104 p_coa_id IN NUMBER,
105 p_adhoc_prefix IN VARCHAR2,
106 p_industry IN VARCHAR2,
107 p_id_flex_code IN VARCHAR2,
108 p_ledger_name IN VARCHAR2,
109 p_report_id IN NUMBER,
110 p_axis_set_id IN NUMBER,
111 p_colset_id IN NUMBER,
112 p_period_name IN VARCHAR2,
113 p_currency_code IN VARCHAR2,
114 p_rounding_option IN VARCHAR2,
115 p_segment_override IN VARCHAR2,
116 p_content_set_id IN NUMBER,
117 P_ROW_ORDER_ID IN NUMBER,
118 P_REPORT_DISPLAY_SET_ID IN NUMBER,
119 p_OUTPUT_OPTION IN VARCHAR2,
120 p_EXCEPTIONS_FLAG IN VARCHAR2,
121 p_MINIMUM_DISPLAY_LEVEL IN NUMBER,
122 p_accounting_date IN VARCHAR2,
123 p_parameter_set_id IN NUMBER,
124 P_PAGE_LENGTH IN NUMBER,
125 p_SUBREQUEST_ID IN NUMBER,
126 P_APPL_NAME IN VARCHAR2
127
128 ,
129 p_balance_type IN VARCHAR2
130 --,p_internal_trx_flag IN VARCHAR2
131 ,
132 p_xml_template_language IN VARCHAR2,
133 p_xml_template_territory IN VARCHAR2,
134 p_xml_output_format IN VARCHAR2,
135 p_source_charset IN VARCHAR2,
136 p_destination_charset IN VARCHAR2,
137 p_source_separator IN VARCHAR2,
138 p_destination_filename IN VARCHAR2);
139
140 --==========================================================================
141 -- PROCEDURE NAME:
142 --
143 -- Cfs_Calculate Public
144 --
145 -- DESCRIPTION:
146 --
147 -- The 'Cfs_Calculate' procedure accepts parameters from concurrent program
148 -- 'Cash Flow Statement -Calcluation' and calls another procedure
149 -- 'JA_CN_CFS_CALCULATE_PKG.Generate_Cfs_Xml' with parameters after processing.
150 --
151 -- PARAMETERS:
152 -- In: p_legal_entity_id Identifier of legal entity
153 -- p_set_of_bks_id Identifier of GL set of book, a required
154 -- parameter for FSG report
155 -- p_period_name GL period Name
156 -- p_axis_set_id Identifier of FSG Row Set
157 -- p_rounding_option Rounding option for amount in Cash Flow statement
158 -- p_balance_type Type of balance, available value is
159 -- 'YTD/QTD/PTD'. a required parameter for FSG
160 -- report
161 -- p_internal_trx_flag To indicate if intercompany transactions
162 -- should be involved in amount calculation
163 -- of cash flow statement.
164 --
165 -- Out: errbuf
166 -- retcode
167 --
168 --
169 -- DESIGN REFERENCES:
170 -- CNAO_Cashflow_Statement_Generation_TD.doc
171 --
172 -- CHANGE HISTORY:
173 --
174 -- 27-Mar-2006 Donghai Wang Created
175 --
176 --===========================================================================
177 PROCEDURE Cfs_Calculate(errbuf OUT NOCOPY VARCHAR2,
178 retcode OUT NOCOPY VARCHAR2,
179 p_legal_entity_id IN NUMBER,
180 p_ledger_id IN NUMBER,
181 p_period_name IN VARCHAR2,
182 p_axis_set_id IN NUMBER,
183 p_rounding_option IN VARCHAR2,
184 p_balance_type IN VARCHAR2
185 --,p_internal_trx_flag IN VARCHAR2
186 ,p_coa IN NUMBER
187 ,p_segment_override IN VARCHAR2 -- Added for CNAO Enhancement
188 );
189
190 --==========================================================================
191 -- PROCEDURE NAME:
192 -- Cfsse_Generate Public
193 --
194 -- DESCRIPTION:
195 -- This procedure accepts parameters from concurrent program
196 -- 'Cash Flow Statement for small enterprise- Generation' and
197 -- calls another procedure 'JA_CN_CFSSE_GENERATE_PKG.Submit_Requests'
198 -- with parameters after processing.
199 --
200 -- PARAMETERS:
201 -- In: p_legal_entity_id legal entity ID
202 -- p_set_of_bks_id set of books ID
203 -- p_coa_id Chart of Accounts ID
204 -- p_adhoc_prefix Ad hoc prefix for FSG report
205 -- p_industry Industry with constant value 'C'
206 -- p_id_flex_code ID flex code
207 -- p_report_id FSG report id
208 -- p_perid_name GL period Name
209 -- p_rowset_id FSG report row Set ID
210 -- p_colset_id FSG report column Set ID
211 -- p_rounding_option Rounding option
212 -- p_segment_override Segment override
213 -- p_accounting_date Accounting date
214 -- p_template_application_id Application id for xml publisher template
215 -- p_template XML publisher template
216 -- p_template_locale Template locale
217 -- p_output_format Output format for xml publisher report
218 -- p_parameter_set_id Parameter set id
219 -- p_max_page_length Maximum page length
220 -- p_balance_type Type of balance
221 -- p_internal_trx_flag intercompany transactions flag
222
223 -- Out: errbuf
224 -- retcode
225 --
226 -- DESIGN REFERENCES:
227 -- CNAO_Cashflow_Statement_Generation(SE)_TD.doc
228 --
229 -- CHANGE HISTORY:
230 -- 03/29/2006 Jackey Li Created
231 -- 06/26/2006 Jackey Li Add seven parameters
232 --===========================================================================
233 PROCEDURE Cfsse_Generate(errbuf OUT NOCOPY VARCHAR2,
234 retcode OUT NOCOPY VARCHAR2,
235 p_legal_entity_id IN NUMBER,
236 p_ledger_id IN NUMBER,
237 P_DATA_ACCESS_SET_ID IN NUMBER,
238 p_coa_id IN NUMBER,
239 p_adhoc_prefix IN VARCHAR2,
240 p_industry IN VARCHAR2,
241 p_id_flex_code IN VARCHAR2,
242 p_ledger_name IN VARCHAR2,
243 p_report_id IN NUMBER,
244 p_axis_set_id IN NUMBER,
245 p_colset_id IN NUMBER,
246 p_period_name IN VARCHAR2,
247 p_currency_code IN VARCHAR2,
248 p_rounding_option IN VARCHAR2,
249 p_segment_override IN VARCHAR2,
250 p_content_set_id IN NUMBER,
251 P_ROW_ORDER_ID IN NUMBER,
252 P_REPORT_DISPLAY_SET_ID IN NUMBER,
253 p_OUTPUT_OPTION IN VARCHAR2,
254 p_EXCEPTIONS_FLAG IN VARCHAR2,
255 p_MINIMUM_DISPLAY_LEVEL IN NUMBER,
256 p_accounting_date IN VARCHAR2,
257 p_parameter_set_id IN NUMBER,
258 P_PAGE_LENGTH IN NUMBER,
259 p_SUBREQUEST_ID IN NUMBER,
260 P_APPL_NAME IN VARCHAR2
261
262 ,
263 p_balance_type IN VARCHAR2
264 --,p_internal_trx_flag IN VARCHAR2
265 ,
266 p_xml_template_language IN VARCHAR2,
267 p_xml_template_territory IN VARCHAR2,
268 p_xml_output_format IN VARCHAR2,
269 p_source_charset IN VARCHAR2,
270 p_destination_charset IN VARCHAR2,
271 p_source_separator IN VARCHAR2,
272 p_destination_filename IN VARCHAR2);
273
274 --==========================================================================
275 -- PROCEDURE NAME:
276 -- Cfsse_Calculate Public
277 --
278 -- DESCRIPTION:
279 -- This procedure accepts parameters from concurrent program
280 -- 'Cash Flow Statement for small enterprise -Calcluation'
281 -- and calls another procedure 'JA_CN_CFS_CALCULATE_PKG.Generate_Cfs_Xml'
282 -- with parameters after processing.
283 --
284 -- PARAMETERS:
285 -- In: p_legal_entity_id legal entity ID
286 -- p_period_name period name
287 -- p_axis_set_id axis set id
288 -- p_rounding_option rounding option
289 -- p_balance_type balance type
290 -- p_internal_trx_flag is intercompany transactions
291 --
292 -- Out: errbuf
293 -- retcode
294 --
295 -- DESIGN REFERENCES:
296 -- CNAO_Cashflow_Statement_Generation(SE)_TD.doc
297 --
298 -- CHANGE HISTORY:
299 -- 03/29/2006 Jackey Li Created
300 --===========================================================================
301 PROCEDURE Cfsse_Calculate(ERRBUF OUT NOCOPY VARCHAR2
302 ,RETCODE OUT NOCOPY VARCHAR2
303 ,p_legal_entity_id IN NUMBER
304 ,p_ledger_id IN NUMBER
305 ,p_period_name IN VARCHAR2
306 ,p_axis_set_id IN NUMBER
307 ,p_rounding_option IN VARCHAR2
308 ,p_balance_type IN VARCHAR2
309 --,p_internal_trx_flag IN VARCHAR2 --updated by lyb
313 --==========================================================================
310 ,p_coa IN number
311 ,p_segment_override IN VARCHAR2); -- Added for CNAO Enhancement
312
314 -- PROCEDURE NAME:
315 -- Collect_Cfs_Data public
316 --
317 -- DESCRIPTION:
318 -- This procedure checks year of FROM/TO periods and then collects
319 -- CFS Data from GL/Intercompany/AR/AP.
320 --
321 -- PARAMETERS:
322 -- Out: errbuf NOCOPY VARCHAR2
323 -- Out: retcode NOCOPY VARCHAR2
324 -- In: P_LE_ID NUMBER ID of Legal Entity
325 -- In: P_SOB_ID NUMBER ID of Set Of Book
326 -- In: P_GL_PERIOD_FROM VARCHAR2 Start period
327 -- In: P_GL_PERIOD_TO VARCHAR2 End period
328 -- In: P_SOURCE VARCHAR2 Source of the collection
329 -- In: P_DFT_ITEM VARCHAR2 default CFS item
330 --
331 -- DESIGN REFERENCES:
332 -- None
333 --
334 -- CHANGE HISTORY:
335 -- 03/01/2006 Andrew Liu Created
336 -- 03/30/2007 Yucheng Sun Altered
337 --===========================================================================
338 PROCEDURE Collect_Cfs_Data(errbuf OUT NOCOPY VARCHAR2,
339 retcode OUT NOCOPY VARCHAR2,
340 P_COA_ID IN NUMBER,
341 P_LE_ID IN NUMBER,
342 p_LEDGER_ID IN NUMBER,
343 P_GL_PERIOD_FROM IN VARCHAR2,
344 P_GL_PERIOD_TO IN VARCHAR2,
345 P_SOURCE IN VARCHAR2);
346
347 --==========================================================================
348 -- PROCEDURE NAME:
349 -- GL_Validation Public
350 --
351 -- DESCRIPTION:
352 -- This procedure calls Intercompany transactions validation program to
353 -- check the Intercompany transactions.
354 --
355 -- PARAMETERS:
356 -- Out: errbuf NOCOPY VARCHAR2
357 -- Out: retcode NOCOPY VARCHAR2
358 -- In: P_COA_ID NMBER Chart of accounts ID
359 -- In: P_LE_ID NUMBER ID of Legal Entity
360 -- In: P_LEDGER_ID NUMBER ID of ledger
361 -- In: P_START_PERIOD VARCHAR2 Start period
362 -- In: P_END_PERIOD VARCHAR2 End period
363 -- In: P_SOURCE VARCHAR2 Specified journal source
364 -- In: P_JOURNAL_CTG VARCHAR2 Specified journal category
365 -- In: P_STATUS VARCHAR2 Specified journal status
366 --
367 -- DESIGN REFERENCES:
368 -- None
369 --
370 -- CHANGE HISTORY:
371 -- 02/24/2006 Andrew Liu Created
372 -- 04/21/2007 Yucheng Sun Updated
373 -- delete parameter: P_COM_SEGMENT
374 -- 03/09/2008 Chaoqun Wu Updated
375 -- CNAO Enhancement: add company segment
376 --===========================================================================
377 PROCEDURE GL_Validation(errbuf OUT NOCOPY VARCHAR2,
378 retcode OUT NOCOPY VARCHAR2,
379 P_COA_ID IN NUMBER,
380 P_LE_ID IN NUMBER,
381 P_LEDGER_ID IN NUMBER,
382 P_START_PERIOD IN VARCHAR2,
383 P_END_PERIOD IN VARCHAR2,
384 P_SOURCE IN VARCHAR2,
385 P_JOURNAL_CTG IN VARCHAR2,
386 P_STATUS IN VARCHAR2,
387 P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
388 );
389
390 --==========================================================================
391 -- PROCEDURE NAME:
392 -- Intercompany_Validation Public
393 --
394 -- DESCRIPTION:
395 -- This procedure calls Intercompany transactions validation program to
396 -- check the Intercompany transactions.
397 --
398 -- PARAMETERS:
399 -- Out: errbuf NOCOPY VARCHAR2
400 -- Out: retcode NOCOPY VARCHAR2
401 -- In: P_COA_ID NMBER Chart of accounts ID
402 -- In: P_LE_ID NUMBER ID of Legal Entity
403 -- In: P_LEDGER_ID NUMBER ID of ledger
404 -- In: P_START_PERIOD VARCHAR2 Start period
405 -- In: P_END_PERIOD VARCHAR2 End period
406 -- In: P_STATUS VARCHAR2 Specified journal status
407 --
408 -- DESIGN REFERENCES:
409 -- None
410 --
411 -- CHANGE HISTORY:
412 -- 02/24/2006 Andrew Liu Created
413 -- 04/21/2007 Yucheng Sun Updated
414 -- delete parameter: P_COM_SEGMENT
415 -- 02/09/2008 Chaoqun Wu Updated
419 retcode OUT NOCOPY VARCHAR2,
416 -- CNAO Enhancement: add company segment
417 --===========================================================================
418 PROCEDURE Intercompany_Validation(errbuf OUT NOCOPY VARCHAR2,
420 P_COA_ID IN NUMBER,
421 P_LE_ID IN NUMBER,
422 P_LEDGER_ID IN NUMBER,
423 P_START_PERIOD IN VARCHAR2,
424 P_END_PERIOD IN VARCHAR2,
425 P_STATUS IN VARCHAR2,
426 P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
427 );
428
429 --===========================================================================
430 --added by lyb
431 --===========================================================================
432
433 PROCEDURE Item_Mapping_Analysis_Report(errbuf OUT NOCOPY VARCHAR2,
434 retcode OUT NOCOPY VARCHAR2,
435 P_APLICATION_ID IN Number,
436 P_EVENT_CLASS_CODE IN Varchar2,
437 P_SUPPORTING_REFERENCE_CODE IN Varchar2,
438 P_CHART_OF_ACCOUNTS_ID IN NUMBER);
439
440 --==========================================================================
441 -- PROCEDURE NAME:
442 -- cfs_detail_report Public
443 --
444 -- DESCRIPTION:
445 -- This procedure is to generate the cfs detail report.
446 --
447 -- PARAMETERS:
448 -- Out: errbuf
449 -- Out: retcode
450 -- In: P_LE_ID ID of Legal Entity
451 -- In: P_ledger_ID ID of ledger
452 -- In: P_chart_of_accounts_ID Identifier of gl chart of account
453 -- In: P_ADHOC_PREFIX Ad hoc prefix for FSG report, a required
454 -- parameter for FSG report
455 -- In: P_INDUSTRY Industry with constant value 'C' for
456 -- now, a required parameter for FSG report
457 -- In: P_ID_FLEX_CODE ID flex code, a required parameter for
458 -- FSG report
459 -- In: P_REPORT_ID Identifier of FSG report
460 -- In: P_GL_PERIOD_FROM Start period
461 -- In: P_GL_PERIOD_TO End period
462 -- In: P_SOURCE Source of the collection
463 -- In: P_INTERNAL_TRX To indicate if intercompany transactions
464 -- should be involved in amount calculation
465 -- of cash flow statement.
466 --
467 -- DESIGN REFERENCES:
468 -- None
469 --
470 -- CHANGE HISTORY:
471 -- 04/28/2007 Qingjun Zhao Change
472 -- 09/09/2008 Yao Zhang Change
473 -- 20/09/2010 Richard Qi Commented the whole procedure
474 --===========================================================================
475
476 /* PROCEDURE Cfs_Detail_Report(errbuf OUT NOCOPY VARCHAR2,
477 retcode OUT NOCOPY VARCHAR2,
478 P_LEGAL_ENTITY_ID IN NUMBER,
479 P_ledger_ID IN NUMBER,
480 P_Chart_of_accounts_ID IN NUMBER,
481 P_ADHOC_PREFIX IN VARCHAR2,
482 P_INDUSTRY IN VARCHAR2,
483 P_ID_FLEX_CODE IN VARCHAR2,
484 P_REPORT_ID IN NUMBER,
485 P_ROW_SET_ID IN NUMBER,
486 P_ROW_NAME IN VARCHAR2,
487 P_GL_PERIOD_FROM IN VARCHAR2,
488 P_GL_PERIOD_TO IN VARCHAR2,
489 P_SOURCE IN VARCHAR2,
490 P_BSV IN VARCHAR2);--Fix bug#7334017 add*/
491
492 END JA_CN_CFS_CONC_PROG;