1 PACKAGE JA_CN_CFS_GENERATE_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNCGES.pls 120.0.12000000.1 2007/08/13 14:09:22 qzhao noship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation
5 --| Redwood Shores, CA, USA
6 --| All rights reserved.
7 --+=======================================================================
8 --| FILENAME
9 --| JACNCGES.pls
10 --|
11 --| DESCRIPTION
12 --|
13 --| This package is the main program for 'Cash Flow Statement - Generation'
14 --|
15 --|
16 --| PROCEDURE LIST
17 --| Submit Requests
18 --|
19 --|
20 --| HISTORY
21 --| 24-Mar-2006 Donghai Wang Created
22 --|
23 --+======================================================================*/
24
25 --==========================================================================
26 -- PROCEDURE NAME:
27 --
28 -- Submit_Requests Public
29 --
30 -- DESCRIPTION:
31 --
32 -- The 'Submit_Requests' procedure is responsible for submit the following
33 -- four concurrent programs in turn to generate the final output file in 'TXT'
34 -- format for CNAO.
35 -- 1. Cash Flow Statement - FSG
36 -- 2. Cash Flow Statement - Calculation
37 -- 3. Cash Flow Statement - Combination
38 -- 4. XML Report Publisher
39 --
40 -- PARAMETERS:
41 -- In: p_legal_entity_id Identifier of legal entity
42 -- p_ledger_id Identifier of GL set of book, a required
43 -- parameter for FSG report
44 -- p_coa_id Chart of Accounts Id, a required parameter
45 -- for FSG report
46 -- p_adhoc_prefix Ad hoc prefix for FSG report, a required
47 -- parameter for FSG report
48 -- p_industry Industry with constant value 'C' for
49 -- now, a required parameter for FSG report
50 -- p_id_flex_code ID flex code, a required parameter for
51 -- FSG report
52 -- p_report_id Identifier of FSG report
53 -- p_period_name GL period Name
54 -- p_axis_set_id Identifier of FSG Row Set
55 -- p_colset_id Identifier of FSG Column Set, a required
56 -- parameter for FSG
57 -- p_rounding_option Rounding option for amount in Cash Flow
58 -- statement
59 -- p_segment_override Segment override for FSG report
60 -- flow statement calculation
61 -- p_accounting_date Accounting date
62 -- p_parameter_set_id Parameter set id, a required parameter
63 -- for FSG report
64 -- p_max_page_length Maximum page length
65 -- p_balance_type Type of balance, available value is
66 -- 'YTD/QTD/PTD'. a required parameter for
67 -- FSG report
68 -- p_internal_trx_flag To indicate if intercompany transactions
69 -- should be involved in amount calculation
70 -- of cash flow statement.
71 -- p_xml_template_language Template language of Cash Flow Statement
72 -- p_xml_template_territory Template territory of Cash Flow Statement
73 -- p_xml_output_format Output format of Cash Flow Statement
74 -- p_source_charset Characterset of input file for characterset
75 -- conversion
76 -- p_destination_charset Characterset of output file for characterset
77 -- conversion
78 -- p_source_separator Separater between fields in input file
79 -- for conversion
80 -- p_destination_filename file name after change
81 --
82 -- DESIGN REFERENCES:
83 -- CNAO_Cashflow_Statement_Generation_TD.doc
84 --
85 -- CHANGE HISTORY:
86 --
87 -- 24-Mar-2006 Donghai Wang Created
88 --
89 --===========================================================================
90
91 PROCEDURE Submit_Requests
92 (p_legal_entity_id IN NUMBER
93 ,p_ledger_id IN NUMBER
94 ,P_DATA_ACCESS_SET_ID IN NUMBER--added by lyb
95 ,p_coa_id IN NUMBER
96 ,p_adhoc_prefix IN VARCHAR2
97 ,p_industry IN VARCHAR2
98 ,p_id_flex_code IN VARCHAR2
99 ,p_ledger_name IN VARCHAR2
100 ,p_report_id IN NUMBER
101 ,p_axis_set_id IN NUMBER
102 ,p_colset_id IN NUMBER
103 ,p_period_name IN VARCHAR2
104 ,p_currency_code IN VARCHAR2
105 ,p_rounding_option IN VARCHAR2
106 ,p_segment_override IN VARCHAR2
107 ,p_content_set_id IN NUMBER
108 ,P_ROW_ORDER_ID IN NUMBER
109 ,P_REPORT_DISPLAY_SET_ID IN NUMBER
110 ,p_OUTPUT_OPTION IN VARCHAR2
111 ,p_EXCEPTIONS_FLAG IN VARCHAR2
112 ,p_MINIMUM_DISPLAY_LEVEL IN NUMBER
113 ,p_accounting_date IN varchar2
114 ,p_parameter_set_id IN NUMBER
115 ,P_PAGE_LENGTH IN NUMBER
116 ,p_SUBREQUEST_ID IN NUMBER
117 ,P_APPL_NAME IN VARCHAR2
118
119 ,p_balance_type IN VARCHAR2
120 --,p_internal_trx_flag IN VARCHAR2
121 ,p_xml_template_language IN VARCHAR2
122 ,p_xml_template_territory IN VARCHAR2
123 ,p_xml_output_format IN VARCHAR2
124 ,p_source_charset IN VARCHAR2
125 ,p_destination_charset IN VARCHAR2
126 ,p_destination_filename IN VARCHAR2
127 ,p_source_separator IN VARCHAR2
128 );
129
130 END JA_CN_CFS_GENERATE_PKG;