1 PACKAGE JA_CN_CFSSE_GENERATE_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNCSES.pls 120.0.12010000.2 2008/10/28 06:34:45 shyan ship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNCSES.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package is the main program for 'Cash Flow Statement |
13 --| for small enterprise - Generation' |
14 --| |
15 --| Public PROCEDURE LIST |
16 --| PROCEDURE Submit_Requests |
17 --| |
18 --| HISTORY |
19 --| 03/22/2006 Jackey Li Created |
20 --| 2006-06-26 Jackey Li Updated |
21 --| add seven parameters for the procedure |
22 --| 'Submit_Requests' |
23 --| 09/22/2008 Chaoqun Wu Updated for CNAO Enhancement |
24 --+======================================================================*/
25
26 --==========================================================================
27 -- PROCEDURE NAME:
28 -- Submit_Requests Public
29 --
30 -- DESCRIPTION:
31 -- It is responsible for submit four concurrent programs
32 -- in turn to generate the final output file in 'TXT' format for CNAO.
33 --
34 -- PARAMETERS:
35 -- In: p_legal_entity_id legal entity ID
36 -- p_set_of_bks_id set of books ID
37 -- p_coa_id Chart of Accounts ID
38 -- p_adhoc_prefix Ad hoc prefix for FSG report
39 -- p_industry Industry with constant value 'C'
40 -- p_id_flex_code ID flex code
41 -- p_report_id FSG report id
42 -- p_perid_name GL period Name
43 -- p_rowset_id FSG report row Set ID
44 -- p_colset_id FSG report column Set ID
45 -- p_rounding_option Rounding option
46 -- p_segment_override Segment override
47 -- p_accounting_date Accounting date
48 -- p_parameter_set_id Parameter set id
49 -- p_max_page_length Maximum page length
50 -- p_balance_type Type of balance
51 -- p_internal_trx_flag intercompany transactions flag
52 --
53 -- DESIGN REFERENCES:
54 -- CNAO_Cashflow_Statement_Generation(SE)_TD.doc
55 --
56 -- CHANGE HISTORY:
57 -- 03/22/2006 Jackey Li Created
58 -- 2006-06-26 Jackey Li add seven parameters
59 --==========================================================================
60
61 PROCEDURE Submit_Requests
62 (p_legal_entity_id IN NUMBER
63 ,p_ledger_id IN NUMBER
64 ,P_DATA_ACCESS_SET_ID IN NUMBER--added by lyb
65 ,p_coa_id IN NUMBER
66 ,p_adhoc_prefix IN VARCHAR2
67 ,p_industry IN VARCHAR2
68 ,p_id_flex_code IN VARCHAR2
69 ,p_ledger_name IN VARCHAR2
70 ,p_report_id IN NUMBER
71 ,p_axis_set_id IN NUMBER
72 ,p_colset_id IN NUMBER
73 ,p_period_name IN VARCHAR2
74 ,p_currency_code IN VARCHAR2
75 ,p_rounding_option IN VARCHAR2
76 ,p_segment_override IN VARCHAR2
77 ,p_content_set_id IN NUMBER
78 ,P_ROW_ORDER_ID IN NUMBER
79 ,P_REPORT_DISPLAY_SET_ID IN NUMBER
80 ,p_OUTPUT_OPTION IN VARCHAR2
81 ,p_EXCEPTIONS_FLAG IN VARCHAR2
82 ,p_MINIMUM_DISPLAY_LEVEL IN NUMBER
83 ,p_accounting_date IN varchar2
84 ,p_parameter_set_id IN NUMBER
85 ,P_PAGE_LENGTH IN NUMBER
86 ,p_SUBREQUEST_ID IN NUMBER
87 ,P_APPL_NAME IN VARCHAR2
88
89 ,p_balance_type IN VARCHAR2
90 --,p_internal_trx_flag IN VARCHAR2
91 ,p_xml_template_language IN VARCHAR2
92 ,p_xml_template_territory IN VARCHAR2
93 ,p_xml_output_format IN VARCHAR2
94 ,p_source_charset IN VARCHAR2
95 ,p_destination_charset IN VARCHAR2
96 ,p_destination_filename IN VARCHAR2
97 ,p_source_separator IN VARCHAR2
98 );
99
100
101
102 END JA_CN_CFSSE_GENERATE_PKG;