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