DBA Data[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;