[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.0.12000000.1 2007/08/13 14:09:35 qzhao noship $
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 --| |
19 --| HISTORY |
20 --| 06/02/2006 ShuJuan Yan Created
21 --| 17/04/2006 Joy liu Updated |
22 --+========================================================================
23 --Declare global variable for package name
24 g_module_name VARCHAR2(30) := 'JA_CN_FSG_XML_SUBMIT_PROG';
25 --==========================================================================
26 -- FUNCTION NAME:
27 -- Submit_FSG_Request Private
28 --
29 -- DESCRIPTION:
30 -- This function is used to submit FSG report,
31 -- PARAMETERS:
32 -- In:
33 -- X_APPL_SHORT_NAME Application short name
34 -- X_DATA_ACCESS_SET_ID Data Acess ID
35 -- X_CONCURRENT_REQUEST_ID CONCURRENT REQUEST ID
36 -- X_PROGRAM PROGRAM
37 -- X_COA_ID char of accounts id
38 -- X_ADHOC_PREFIX ADHOC PREFIX
39 -- X_INDUSTRY Industry
40 -- X_FLEX_CODE Flex Code
41 -- X_DEFAULT_LEDGER_SHORT_NAME Default Ledger short Name
42 -- X_REPORT_ID Report ID
43 -- X_ROW_SET_ID Row Set ID
44 -- X_COLUMN_SET_ID Column Set ID
45 -- X_PERIOD_NAME Period Name
46 -- X_UNIT_OF_MEASURE_ID Unit of Measure ID/currency
47 -- X_ROUNDING_OPTION Rounding Option
48 -- X_SEGMENT_OVERRIDE Segment Override
49 -- X_CONTENT_SET_ID Content Set ID
50 -- X_ROW_ORDER_ID Row Order ID
51 -- X_REPORT_DISPLAY_SET_ID Report Display Set ID
52 -- X_OUTPUT_OPTION Out Option
53 -- X_EXCEPTIONS_FLAG Exception
54 -- X_MINIMUM_DISPLAY_LEVEL Minimum Display Level
55 -- X_ACCOUNTING_DATE Accounting Date
56 -- X_PARAMETER_SET_ID Parameter set ID
57 -- X_PAGE_LENGTH Page Lenth
58 -- X_SUBREQUEST_ID SubRequest ID
59 -- X_APPL_DEFLT_NAME Application Default Name
60 -- Out:
61 -- X_CONCURRENT_REQUEST_ID Concrrent Request ID
62 -- X_PROGRAM Program
63 --
64 -- DESIGN REFERENCES:
65 -- None
66 --
67 -- CHANGE HISTORY:
68 -- 06/14/2006 Shujuan Yan Created
69 -- 27/04/2007 Joy liu Updated
70 -- the order and number of parameter is changed
71 --==========================================================================
72
73 FUNCTION Submit_FSG_Request
74 (X_APPL_SHORT_NAME IN VARCHAR2,
75 X_DATA_ACCESS_SET_ID IN NUMBER,
76 X_CONCURRENT_REQUEST_ID OUT NOCOPY NUMBER,
77 X_PROGRAM OUT NOCOPY VARCHAR2,
78 X_COA_ID IN NUMBER,
79 X_ADHOC_PREFIX IN VARCHAR2,
80 X_INDUSTRY IN VARCHAR2,
81 X_FLEX_CODE IN VARCHAR2,
82 X_DEFAULT_LEDGER_SHORT_NAME IN VARCHAR2,
83 X_REPORT_ID IN NUMBER,
84 X_ROW_SET_ID IN NUMBER,
85 X_COLUMN_SET_ID IN NUMBER,
86 X_PERIOD_NAME IN VARCHAR2,
87 X_UNIT_OF_MEASURE_ID IN VARCHAR2,
88 X_ROUNDING_OPTION IN VARCHAR2,
89 X_SEGMENT_OVERRIDE IN VARCHAR2,
90 X_CONTENT_SET_ID IN NUMBER,
91 X_ROW_ORDER_ID IN NUMBER,
92 X_REPORT_DISPLAY_SET_ID IN NUMBER,
93 X_OUTPUT_OPTION IN VARCHAR2,
94 X_EXCEPTIONS_FLAG IN VARCHAR2,
95 X_MINIMUM_DISPLAY_LEVEL IN NUMBER,
96 X_ACCOUNTING_DATE IN DATE,
97 X_PARAMETER_SET_ID IN NUMBER,
98 X_PAGE_LENGTH IN NUMBER,
99 X_SUBREQUEST_ID IN NUMBER,
100 X_APPL_DEFLT_NAME IN VARCHAR2)
101 RETURN BOOLEAN;
102
103
104 --==========================================================================
105 -- PROCEDURE NAME:
106 -- Submit_xml_publiser Private
107 --
108 -- DESCRIPTION:
109 -- This procedure is used to submit xml publisher concurrent,
110 -- PARAMETERS:
111 -- In: p_template_appl template application
112 -- p_ltemplate template name
113 -- p_template_locale template locale
114 -- p_output_format output format
115 -- Out: x_xml_request_id xml request id
116 -- x_result_flag result flag
117 --
118 -- DESIGN REFERENCES:
119 -- None
120 --
121 -- CHANGE HISTORY:
122 -- 06/03/2006 Shujuan Yan Created
123 --==========================================================================
124 PROCEDURE Submit_xml_Publisher(p_fsg_request_id IN NUMBER,
125 p_template_appl IN VARCHAR2,
126 p_template IN VARCHAR2,
127 p_template_locale IN VARCHAR2,
128 p_output_format IN VARCHAR2,
129 x_xml_request_id OUT NOCOPY NUMBER,
130 x_result_flag OUT NOCOPY VARCHAR2);
131 --=========================================================================
132 -- PROCEDURE NAME:
133 -- Submit_FSG_XML_Report Private
134 --
135 -- DESCRIPTION:
136 -- This procedure is used to submit FSG report and XML Report publisher .
137 -- PARAMETERS:
138 -- In:
139 -- P_APPL_SHORT_NAME Application short name
140 -- P_DATA_ACCESS_SET_ID Data Acess ID
141 -- P_CONCURRENT_REQUEST_ID CONCURRENT REQUEST ID
142 -- P_PROGRAM PROGRAM
143 -- P_COA_ID char of accounts id
144 -- P_ADHOC_PREFIX ADHOC PREFIX
145 -- P_INDUSTRY Industry
146 -- P_FLEX_CODE Flex Code
147 -- P_DEFAULT_LEDGER_SHORT_NAME Default Ledger short Name
148 -- P_REPORT_ID Report ID
149 -- P_ROW_SET_ID Row Set ID
150 -- P_COLUMN_SET_ID Column Set ID
151 -- P_PERIOD_NAME Period Name
152 -- P_UNIT_OF_MEASURE_ID Unit of Measure ID/currency
153 -- P_ROUNDING_OPTION Rounding Option
154 -- P_SEGMENT_OVERRIDE Segment Override
155 -- P_CONTENT_SET_ID Content Set ID
156 -- P_ROW_ORDER_ID Row Order ID
157 -- P_REPORT_DISPLAY_SET_ID Report Display Set ID
158 -- P_OUTPUT_OPTION Out Option
159 -- P_EXCEPTIONS_FLAG Exception
160 -- P_MINIMUM_DISPLAY_LEVEL Minimum Display Level
161 -- P_ACCOUNTING_DATE Accounting Date
162 -- P_PARAMETER_SET_ID Parameter set ID
163 -- P_PAGE_LENGTH Page Lenth
164 -- P_SUBREQUEST_ID SubRequest ID
165 -- P_APPL_DEFLT_NAME Application Default Name
166
167 -- p_template Template name
168 -- p_template_locale Template locale
169 -- p_output_format Output format
170 -- p_source_charset source charset
171 -- p_destination_charset destination charset
172 -- p_destination_filename destination filename
173 -- p_source_separator source separator
174 -- Out:
175 -- X_CONCURRENT_REQUEST_ID Concrrent Request ID
176 -- X_PROGRAM Program
177
178 -- DESIGN REFERENCES:
179 -- None
180 --
181 -- CHANGE HISTORY:
182 -- 06/02/2006 Shujuan Yan Created
183 -- 27/04/2007 Joy liu Updated
184 -- the order and number of parameter is changed
185 --===========================================================================
186 PROCEDURE Submit_FSG_XML_Report(errbuf OUT NOCOPY VARCHAR2,
187 retcode OUT NOCOPY VARCHAR2,
188
189 P_DATA_ACCESS_SET_ID IN NUMBER,
190 P_COA_ID IN NUMBER,
191 P_ADHOC_PREFIX IN VARCHAR2,
192 P_INDUSTRY IN VARCHAR2,
193 P_FLEX_CODE IN VARCHAR2,
194 P_DEFAULT_LEDGER_SHORT_NAME IN VARCHAR2,
195 P_REPORT_ID IN NUMBER,
196 P_ROW_SET_ID IN NUMBER,
197 P_COLUMN_SET_ID IN NUMBER,
198 p_PERIOD_NAME IN VARCHAR2,
199 p_UNIT_OF_MEASURE_ID IN VARCHAR2,
200 P_ROUNDING_OPTION IN VARCHAR2,
201 P_SEGMENT_OVERRIDE IN VARCHAR2,
202 P_CONTENT_SET_ID IN NUMBER,
203 P_ROW_ORDER_ID IN NUMBER,
204 P_REPORT_DISPLAY_SET_ID IN NUMBER,
205 P_OUTPUT_OPTION IN VARCHAR2,
206 P_EXCEPTIONS_FLAG IN VARCHAR2,
207 p_MINIMUM_DISPLAY_LEVEL IN NUMBER,
208 p_ACCOUNTING_DATE IN VARCHAR2,
209 P_PARAMETER_SET_ID IN NUMBER,
210 p_PAGE_LENGTH IN NUMBER,
211
212 p_subrequest_id IN NUMBER,
213 P_APPL_DEFLT_NAME IN VARCHAR2,
214
215 p_template IN VARCHAR2,
216 p_template_locale IN VARCHAR2,
217 p_output_format IN VARCHAR2,
218 p_source_charset IN VARCHAR2,
219 p_destination_charset IN VARCHAR2,
220 p_destination_filename IN VARCHAR2,
221 p_source_separator IN VARCHAR2
222 );
223 end ja_cn_fsg_xml_submit_prog;