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