1 package ja_cn_fsg_xml_bank_pkg AUTHID CURRENT_USER AS
2 --$Header: JACNFXBS.pls 120.0.12020000.2 2013/02/06 08:57:53 chongwan noship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNFXBS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| |
13 --| PROCEDURE LIST |
14 --| PROCEDURE Submit_FSG_XML_Report |
15 --| PROCEDURE Get_Lookup_Code |
16 --| FUNCTION Submit_FSG_Request |
17 --| PROCEDURE Submit_xml_Publisher |
18 --| PROCEDURE Submit_FSG_Report |
19 --| |
20 --| HISTORY |
21 --| 06/02/2006 ShuJuan Yan Created |
22 --| 17/04/2006 Joy liu Updated |
23 --| 08/02/2010 Wei Huang Add PROCEDURE Submit_FSG_Report |
24 --| 19/11/2012 Jar Wang Updated for CANO BANKING |
25 --+========================================================================
26 --Declare global variable for package name
27 g_module_name VARCHAR2(30) := 'JA_CN_FSG_XML_BANK_PKG';
28 --==========================================================================
29 -- FUNCTION NAME:
30 -- Submit_FSG_Request Private
31 --
32 -- DESCRIPTION:
33 -- This function is used to submit FSG report,
34 -- PARAMETERS:
35 -- In:
36 -- X_APPL_SHORT_NAME Application short name
37 -- X_DATA_ACCESS_SET_ID Data Acess ID
38 -- X_CONCURRENT_REQUEST_ID CONCURRENT REQUEST ID
39 -- X_PROGRAM PROGRAM
40 -- X_COA_ID char of accounts id
41 -- X_ADHOC_PREFIX ADHOC PREFIX
42 -- X_INDUSTRY Industry
43 -- X_FLEX_CODE Flex Code
44 -- X_DEFAULT_LEDGER_SHORT_NAME Default Ledger short Name
45 -- X_REPORT_ID Report ID
46 -- X_ROW_SET_ID Row Set ID
47 -- X_COLUMN_SET_ID Column Set ID
48 -- X_PERIOD_NAME Period Name
49 -- X_UNIT_OF_MEASURE_ID Unit of Measure ID/currency
50 -- X_ROUNDING_OPTION Rounding Option
51 -- X_SEGMENT_OVERRIDE Segment Override
52 -- X_CONTENT_SET_ID Content Set ID
53 -- X_ROW_ORDER_ID Row Order ID
54 -- X_REPORT_DISPLAY_SET_ID Report Display Set ID
55 -- X_OUTPUT_OPTION Out Option
56 -- X_EXCEPTIONS_FLAG Exception
57 -- X_MINIMUM_DISPLAY_LEVEL Minimum Display Level
58 -- X_ACCOUNTING_DATE Accounting Date
59 -- X_PARAMETER_SET_ID Parameter set ID
60 -- X_PAGE_LENGTH Page Lenth
61 -- X_SUBREQUEST_ID SubRequest ID
62 -- X_APPL_DEFLT_NAME Application Default Name
63 -- Out:
64 -- X_CONCURRENT_REQUEST_ID Concrrent Request ID
65 -- X_PROGRAM Program
66 --
67 -- DESIGN REFERENCES:
68 -- None
69 --
70 -- CHANGE HISTORY:
71 -- 06/14/2006 Shujuan Yan Created
72 -- 27/04/2007 Joy liu Updated
73 -- the order and number of parameter is changed
74 -- 19/11/2012 Jar Wang Updated for CANO BANKING
75 --==========================================================================
76
77 FUNCTION Submit_FSG_Request(X_APPL_SHORT_NAME IN VARCHAR2,
78 X_DATA_ACCESS_SET_ID IN NUMBER,
79 X_CONCURRENT_REQUEST_ID OUT NOCOPY NUMBER,
80 X_PROGRAM OUT NOCOPY VARCHAR2,
81 X_BSV IN VARCHAR2,
82 X_LEGAL_ID IN NUMBER,
83 X_COA_ID IN NUMBER,
84 X_ADHOC_PREFIX IN VARCHAR2,
85 X_INDUSTRY IN VARCHAR2,
86 X_FLEX_CODE IN VARCHAR2,
87 X_DEFAULT_LEDGER_SHORT_NAME IN VARCHAR2,
88 X_REPORT_ID IN NUMBER,
89 X_ROW_SET_ID IN NUMBER,
90 X_COLUMN_SET_ID IN NUMBER,
91 X_PERIOD_NAME IN VARCHAR2,
92 X_UNIT_OF_MEASURE_ID IN VARCHAR2,
93 X_ROUNDING_OPTION IN VARCHAR2,
94 X_SEGMENT_OVERRIDE IN VARCHAR2,
95 X_CONTENT_SET_ID IN NUMBER,
96 X_ROW_ORDER_ID IN NUMBER,
97 X_REPORT_DISPLAY_SET_ID IN NUMBER,
98 X_OUTPUT_OPTION IN VARCHAR2,
99 X_EXCEPTIONS_FLAG IN VARCHAR2,
100 X_MINIMUM_DISPLAY_LEVEL IN NUMBER,
101 X_ACCOUNTING_DATE IN DATE,
102 X_PARAMETER_SET_ID IN NUMBER,
103 X_PAGE_LENGTH IN NUMBER,
104 X_SUBREQUEST_ID IN NUMBER,
105 X_APPL_DEFLT_NAME IN VARCHAR2)
106 RETURN BOOLEAN;
107
108 --==========================================================================
109 -- PROCEDURE NAME:
110 -- Submit_xml_publiser Private
111 --
112 -- DESCRIPTION:
113 -- This procedure is used to submit xml publisher concurrent,
114 -- PARAMETERS:
115 -- In: p_template_appl template application
116 -- p_ltemplate template name
117 -- p_template_locale template locale
118 -- p_output_format output format
119 -- Out: x_xml_request_id xml request id
120 -- x_result_flag result flag
121 --
122 -- DESIGN REFERENCES:
123 -- None
124 --
125 -- CHANGE HISTORY:
126 -- 06/03/2006 Shujuan Yan Created
127 -- 19/11/2012 Jar Wang Updated for CANO BANKING
128 --==========================================================================
129 PROCEDURE Submit_xml_Publisher(p_fsg_request_id IN NUMBER,
130 p_template_appl IN VARCHAR2,
131 p_template IN VARCHAR2,
132 p_template_locale IN VARCHAR2,
133 p_output_format IN VARCHAR2,
134 x_xml_request_id OUT NOCOPY NUMBER,
135 x_result_flag OUT NOCOPY VARCHAR2);
136 --=========================================================================
137 -- PROCEDURE NAME:
138 -- Submit_FSG_XML_Report Private
139 --
140 -- DESCRIPTION:
141 -- This procedure is used to submit FSG report and XML Report publisher .
142 -- PARAMETERS:
143 -- In:
144 -- P_APPL_SHORT_NAME Application short name
145 -- P_DATA_ACCESS_SET_ID Data Acess ID
146 -- P_CONCURRENT_REQUEST_ID CONCURRENT REQUEST ID
147 -- P_PROGRAM PROGRAM
148 -- P_COA_ID char of accounts id
149 -- P_ADHOC_PREFIX ADHOC PREFIX
150 -- P_INDUSTRY Industry
151 -- P_FLEX_CODE Flex Code
152 -- P_DEFAULT_LEDGER_SHORT_NAME Default Ledger short Name
153 -- P_REPORT_ID Report ID
154 -- P_ROW_SET_ID Row Set ID
155 -- P_COLUMN_SET_ID Column Set ID
156 -- P_PERIOD_NAME Period Name
157 -- P_UNIT_OF_MEASURE_ID Unit of Measure ID/currency
158 -- P_ROUNDING_OPTION Rounding Option
159 -- P_SEGMENT_OVERRIDE Segment Override
160 -- P_CONTENT_SET_ID Content Set ID
161 -- P_ROW_ORDER_ID Row Order ID
162 -- P_REPORT_DISPLAY_SET_ID Report Display Set ID
163 -- P_OUTPUT_OPTION Out Option
164 -- P_EXCEPTIONS_FLAG Exception
165 -- P_MINIMUM_DISPLAY_LEVEL Minimum Display Level
166 -- P_ACCOUNTING_DATE Accounting Date
167 -- P_PARAMETER_SET_ID Parameter set ID
168 -- P_PAGE_LENGTH Page Lenth
169 -- P_SUBREQUEST_ID SubRequest ID
170 -- P_APPL_DEFLT_NAME Application Default Name
171
172 -- p_template Template name
173 -- p_template_locale Template locale
174 -- p_output_format Output format
175 -- p_source_charset source charset
176 -- p_destination_charset destination charset
177 -- p_destination_filename destination filename
178 -- p_source_separator source separator
179 -- Out:
180 -- X_CONCURRENT_REQUEST_ID Concrrent Request ID
181 -- X_PROGRAM Program
182
183 -- DESIGN REFERENCES:
184 -- None
185 --
186 -- CHANGE HISTORY:
187 -- 06/02/2006 Shujuan Yan Created
188 -- 27/04/2007 Joy liu Updated
189 -- the order and number of parameter is changed
190 -- 19/11/2012 Jar Wang Updated for CANO BANKING
191 --===========================================================================
192 PROCEDURE Submit_FSG_XML_Report(errbuf OUT NOCOPY VARCHAR2,
193 retcode OUT NOCOPY VARCHAR2,
194
195 P_DATA_ACCESS_SET_ID IN NUMBER,
196 P_BSV IN VARCHAR2,
197 P_LEGAL_ID IN NUMBER,
198 P_COA_ID IN NUMBER,
199 P_ADHOC_PREFIX IN VARCHAR2,
200 P_INDUSTRY IN VARCHAR2,
201 P_FLEX_CODE IN VARCHAR2,
202 P_DEFAULT_LEDGER_SHORT_NAME IN VARCHAR2,
203 P_REPORT_ID IN NUMBER,
204 P_ROW_SET_ID IN NUMBER,
205 P_COLUMN_SET_ID IN NUMBER,
206 p_PERIOD_NAME IN VARCHAR2,
207 p_UNIT_OF_MEASURE_ID IN VARCHAR2,
208 P_ROUNDING_OPTION IN VARCHAR2,
209 P_SEGMENT_OVERRIDE IN VARCHAR2,
210 P_CONTENT_SET_ID IN NUMBER,
211 P_ROW_ORDER_ID IN NUMBER,
212 P_REPORT_DISPLAY_SET_ID IN NUMBER,
213 P_OUTPUT_OPTION IN VARCHAR2,
214 P_EXCEPTIONS_FLAG IN VARCHAR2,
215 p_MINIMUM_DISPLAY_LEVEL IN NUMBER,
216 p_ACCOUNTING_DATE IN VARCHAR2,
217 P_PARAMETER_SET_ID IN NUMBER,
218 p_PAGE_LENGTH IN NUMBER,
219
220 p_subrequest_id IN NUMBER,
221 P_APPL_DEFLT_NAME IN VARCHAR2,
222
223 p_template IN VARCHAR2,
224 p_template_locale IN VARCHAR2,
225 p_output_format IN VARCHAR2,
226 p_source_charset IN VARCHAR2,
227 p_destination_charset IN VARCHAR2,
228 p_destination_filename IN VARCHAR2,
229 p_source_separator IN VARCHAR2);
230
231 --=========================================================================
232 -- PROCEDURE NAME:
233 -- Submit_FSG_Report Private
234 --
235 -- DESCRIPTION:
236 -- This procedure is used to submit FSG reports, and then invoke the
240 -- pn_data_access_set_id Data Acess ID
237 -- 'Report Item Data Convert program' to covert the FSG output.
238 -- PARAMETERS:
239 -- In:
241 -- pn_coa_id Chart of Accounts ID
242 -- pv_adhoc_prefix ADHOC PREFIX
243 -- pv_industry Industry
244 -- pv_flex_code Flex Code
245 -- pv_default_ledger_short_name Default Ledger short Name
246 -- pv_period_name Period Name
250 -- pn_page_length Page Lenth
247 -- pv_output_option Out Option
248 -- pv_exceptions_flag Exception
249 -- pv_accounting_date Accounting Date
251 -- pn_subrequest_id SubRequest ID
252 -- pv_appl_deflt_name Application Default Name
253 -- pn_csf_report_id Cash Flow Statement Report ID
254 -- pn_csf_report_num Cash Flow Statement Report Number
255 -- pn_balance_sheet_id Balance Sheet Report ID
256 -- pn_balance_sheet_num Balance Sheet Report Number
257 -- pn_profit_statement_id Profit Statement Report ID
258 -- pn_profit_statement_num Profit Statement Report Number
259 -- pn_owners_equity_id Owners Equity Report ID
260 -- pn_owners_equity_num Owners Equity Report Number
261 -- pv_balance_type Balance Type
262 -- pn_legal_entity_id Legal Entity ID
263 -- pn_ledger_id Ledger ID
264 -- pv_currency_unit Currency Unit
265 -- pv_xml_template_language XML template language
266 -- pv_xml_template_territory XML template territory
267 -- pv_xml_output_format XML output format
268 --
269 -- Out:
270 -- pn_convert_reqid Report Item Data Convert program
271 --
272 -- DESIGN REFERENCES:
273 -- None
274 --
275 -- CHANGE HISTORY:
276 -- 08/02/2010 Wei Huang Created
277 -- 19/11/2012 Jar Wang Updated for CANO BANKING |
278 --===========================================================================
279 PROCEDURE Submit_FSG_Report(pn_data_access_set_id IN NUMBER,
280 pn_coa_id IN NUMBER,
281 pv_adhoc_prefix IN VARCHAR2,
282 pv_industry IN VARCHAR2,
283 pv_flex_code IN VARCHAR2,
284 pv_default_ledger_short_name IN VARCHAR2,
285 pv_period_name IN VARCHAR2,
286 pv_output_option IN VARCHAR2,
287 pv_exceptions_flag IN VARCHAR2,
288 pv_accounting_date IN VARCHAR2,
289 pn_page_length IN NUMBER,
290 pn_subrequest_id IN NUMBER,
291 pv_appl_deflt_name IN VARCHAR2,
292 pn_csf_report_id IN NUMBER,
293 pn_csf_report_num IN NUMBER,
294 pn_balance_sheet_id IN NUMBER,
295 pn_balance_sheet_num IN NUMBER,
296 pn_profit_statement_id IN NUMBER,
297 pn_profit_statement_num IN NUMBER,
298 pn_owners_equity_id IN NUMBER,
299 pn_owners_equity_num IN NUMBER,
300 pv_balance_type IN VARCHAR2,
301 pv_currency_unit IN VARCHAR2,
302 pv_bsv IN VARCHAR2,
303 pn_legal_entity_id IN NUMBER,
304 pn_ledger_id IN NUMBER,
305 pv_xml_template_language IN VARCHAR2,
306 pv_xml_template_territory IN VARCHAR2,
307 pv_xml_output_format IN VARCHAR2,
308 pn_convert_reqid OUT NOCOPY NUMBER);
309
310
311 end ja_cn_fsg_xml_bank_pkg;
312