[Home] [Help]
PACKAGE: APPS.FUN_XLA_TAB_PKG
Source
1 PACKAGE FUN_XLA_TAB_PKG AUTHID CURRENT_USER AS
2 /* $Header: funxlatabs.pls 120.3 2010/09/21 11:24:50 srampure ship $ */
3 /*======================================================================+
4 | Copyright (c) 2004 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | FUN_XLA_TAB_PKG |
10 | |
11 | DESCRIPTION |
12 | |
13 | Transaction Account Builder API. |
14 | |
15 | Package generated by Oracle Subledger Accounting for |
16 | |
17 | Financials Common Modules |
18 | (application_id: 435) |
19 | |
20 | ATTENTION: |
21 | This package has been automatically generated by the |
22 | Oracle Subledger Accounting Compiler. You should not modify its |
23 | content manually. |
24 | This package has been generated according to the Transaction |
25 | Account Types setup for this application. |
26 | In case of issues independent of the setup (e.g. GSCC errors) |
27 | please log a bug against Oracle Subledger Accounting. |
28 | |
29 | |
30 | HISTORY |
31 | 20-SEP-10 XLA Generated by Oracle Subledger Accounting Compiler |
32 | |
33 +=======================================================================*/
34
35 --Public constants
36 C_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
37 C_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
38 C_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
39 C_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
40 C_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
41
42 --Public record types
43 TYPE t_rec_xla_tab IS RECORD
44 ( base_rowid UROWID --INTERNAL
45 ,source_distribution_id_num_1 NUMBER --INPUT
46 ,source_distribution_id_num_2 NUMBER --INPUT
47 ,source_distribution_id_num_3 NUMBER --INPUT
48 ,source_distribution_id_num_4 NUMBER --INPUT
49 ,source_distribution_id_num_5 NUMBER --INPUT
50 ,account_type_code VARCHAR2(30) --NOT NULL --INPUT
51 --START of source list
52 ,ftb_attribute1 VARCHAR2(80) --INPUT
53 ,ftb_attribute10 VARCHAR2(80) --INPUT
54 ,ftb_attribute11 VARCHAR2(80) --INPUT
55 ,ftb_attribute12 VARCHAR2(80) --INPUT
56 ,ftb_attribute13 VARCHAR2(80) --INPUT
57 ,ftb_attribute14 VARCHAR2(80) --INPUT
58 ,ftb_attribute15 VARCHAR2(80) --INPUT
59 ,ftb_attribute2 VARCHAR2(80) --INPUT
60 ,ftb_attribute3 VARCHAR2(80) --INPUT
61 ,ftb_attribute4 VARCHAR2(80) --INPUT
62 ,ftb_attribute5 VARCHAR2(80) --INPUT
63 ,ftb_attribute6 VARCHAR2(80) --INPUT
64 ,ftb_attribute7 VARCHAR2(80) --INPUT
65 ,ftb_attribute8 VARCHAR2(80) --INPUT
66 ,ftb_attribute9 VARCHAR2(80) --INPUT
67 ,ftb_category_code VARCHAR2(80) --INPUT
68 ,ftb_currency_code VARCHAR2(80) --INPUT
69 ,ftb_from_ledger_id NUMBER --INPUT
70 ,ftb_from_le_id NUMBER --INPUT
71 ,ftb_gl_date DATE --INPUT
72 ,ftb_initiator_bsv VARCHAR2(80) --INPUT
73 ,ftb_initiator_id NUMBER --INPUT
74 ,ftd_initiator_ccid NUMBER --INPUT
75 ,ftd_initiator_clearing_ccid NUMBER --INPUT
76 ,fth_attribute1 VARCHAR2(80) --INPUT
77 ,fth_attribute10 VARCHAR2(80) --INPUT
78 ,fth_attribute11 VARCHAR2(80) --INPUT
79 ,fth_attribute12 VARCHAR2(80) --INPUT
80 ,fth_attribute13 VARCHAR2(80) --INPUT
81 ,fth_attribute14 VARCHAR2(80) --INPUT
82 ,fth_attribute15 VARCHAR2(80) --INPUT
83 ,fth_attribute2 VARCHAR2(80) --INPUT
84 ,fth_attribute3 VARCHAR2(80) --INPUT
85 ,fth_attribute4 VARCHAR2(80) --INPUT
86 ,fth_attribute5 VARCHAR2(80) --INPUT
87 ,fth_attribute6 VARCHAR2(80) --INPUT
88 ,fth_attribute7 VARCHAR2(80) --INPUT
89 ,fth_attribute8 VARCHAR2(80) --INPUT
90 ,fth_attribute9 VARCHAR2(80) --INPUT
91 ,fth_attribute_category VARCHAR2(80) --INPUT
92 ,fth_recipient_bsv VARCHAR2(80) --INPUT
93 ,fth_recipient_id NUMBER --INPUT
94 ,fth_to_ledger_id NUMBER --INPUT
95 ,fth_to_le_id NUMBER --INPUT
96 ,ftt_allow_interest_accr_flag VARCHAR2(80) --INPUT
97 ,ftt_allow_invoicing_flag VARCHAR2(80) --INPUT
98 ,ftt_attribute1 VARCHAR2(80) --INPUT
99 ,ftt_attribute10 VARCHAR2(80) --INPUT
100 ,ftt_attribute11 VARCHAR2(80) --INPUT
101 ,ftt_attribute12 VARCHAR2(80) --INPUT
102 ,ftt_attribute13 VARCHAR2(80) --INPUT
103 ,ftt_attribute14 VARCHAR2(80) --INPUT
104 ,ftt_attribute15 VARCHAR2(80) --INPUT
105 ,ftt_attribute2 VARCHAR2(80) --INPUT
106 ,ftt_attribute3 VARCHAR2(80) --INPUT
107 ,ftt_attribute4 VARCHAR2(80) --INPUT
108 ,ftt_attribute5 VARCHAR2(80) --INPUT
109 ,ftt_attribute6 VARCHAR2(80) --INPUT
110 ,ftt_attribute7 VARCHAR2(80) --INPUT
111 ,ftt_attribute8 VARCHAR2(80) --INPUT
112 ,ftt_attribute9 VARCHAR2(80) --INPUT
113 ,ftt_attribute_category VARCHAR2(80) --INPUT
114 ,ftt_manual_approve_flag VARCHAR2(80) --INPUT
115 ,ftt_trx_type_id NUMBER --INPUT
116 ,ftt_vat_taxable_flag VARCHAR2(80) --INPUT
117 --END of source list
118 ,target_ccid NUMBER(15) --OUTPUT
119 ,concatenated_segments VARCHAR2(2000) --OUTPUT
120 ,msg_count NUMBER --OUTPUT
121 ,msg_data VARCHAR2(2000) --OUTPUT
122 );
123
124
125
126 --Public table types
127 TYPE t_array_xla_tab
128 IS TABLE OF t_rec_xla_tab INDEX BY BINARY_INTEGER;
129
130
131 --Public variables
132 g_array_xla_tab t_array_xla_tab ;
133
134
135 --Public procedures
136 PROCEDURE run
137 (
138 p_api_version IN NUMBER
139 ,p_account_definition_type_code IN VARCHAR2
140 ,p_account_definition_code IN VARCHAR2
141 ,p_transaction_coa_id IN NUMBER
142 ,p_mode IN VARCHAR2
143 ,x_return_status OUT NOCOPY VARCHAR2
144 ,x_msg_count OUT NOCOPY NUMBER
145 ,x_msg_data OUT NOCOPY VARCHAR2
146 );
147
148 PROCEDURE reset_online_interface
149 (
150 p_api_version IN NUMBER
151 ,x_return_status OUT NOCOPY VARCHAR2
152 ,x_msg_count OUT NOCOPY NUMBER
153 ,x_msg_data OUT NOCOPY VARCHAR2
154 );
155
156 PROCEDURE write_online_tab
157 (
158 p_api_version IN NUMBER --INPUT NOT NULL
159 ,p_source_distrib_id_num_1 IN NUMBER --INPUT
160 ,p_source_distrib_id_num_2 IN NUMBER --INPUT
161 ,p_source_distrib_id_num_3 IN NUMBER --INPUT
162 ,p_source_distrib_id_num_4 IN NUMBER --INPUT
163 ,p_source_distrib_id_num_5 IN NUMBER --INPUT
164 ,p_account_type_code IN VARCHAR2 --INPUT NOT NULL
165 --START of source list
166 ,ftb_attribute1 IN VARCHAR2 --INPUT
167 ,ftb_attribute10 IN VARCHAR2 --INPUT
168 ,ftb_attribute11 IN VARCHAR2 --INPUT
169 ,ftb_attribute12 IN VARCHAR2 --INPUT
170 ,ftb_attribute13 IN VARCHAR2 --INPUT
171 ,ftb_attribute14 IN VARCHAR2 --INPUT
172 ,ftb_attribute15 IN VARCHAR2 --INPUT
173 ,ftb_attribute2 IN VARCHAR2 --INPUT
174 ,ftb_attribute3 IN VARCHAR2 --INPUT
175 ,ftb_attribute4 IN VARCHAR2 --INPUT
176 ,ftb_attribute5 IN VARCHAR2 --INPUT
177 ,ftb_attribute6 IN VARCHAR2 --INPUT
178 ,ftb_attribute7 IN VARCHAR2 --INPUT
179 ,ftb_attribute8 IN VARCHAR2 --INPUT
180 ,ftb_attribute9 IN VARCHAR2 --INPUT
181 ,ftb_category_code IN VARCHAR2 --INPUT
182 ,ftb_currency_code IN VARCHAR2 --INPUT
183 ,ftb_from_ledger_id IN NUMBER --INPUT
184 ,ftb_from_le_id IN NUMBER --INPUT
185 ,ftb_gl_date IN DATE --INPUT
186 ,ftb_initiator_bsv IN VARCHAR2 --INPUT
187 ,ftb_initiator_id IN NUMBER --INPUT
188 ,ftd_initiator_ccid IN NUMBER --INPUT
189 ,ftd_initiator_clearing_ccid IN NUMBER --INPUT
190 ,fth_attribute1 IN VARCHAR2 --INPUT
191 ,fth_attribute10 IN VARCHAR2 --INPUT
192 ,fth_attribute11 IN VARCHAR2 --INPUT
193 ,fth_attribute12 IN VARCHAR2 --INPUT
194 ,fth_attribute13 IN VARCHAR2 --INPUT
195 ,fth_attribute14 IN VARCHAR2 --INPUT
196 ,fth_attribute15 IN VARCHAR2 --INPUT
197 ,fth_attribute2 IN VARCHAR2 --INPUT
198 ,fth_attribute3 IN VARCHAR2 --INPUT
199 ,fth_attribute4 IN VARCHAR2 --INPUT
200 ,fth_attribute5 IN VARCHAR2 --INPUT
201 ,fth_attribute6 IN VARCHAR2 --INPUT
202 ,fth_attribute7 IN VARCHAR2 --INPUT
203 ,fth_attribute8 IN VARCHAR2 --INPUT
204 ,fth_attribute9 IN VARCHAR2 --INPUT
205 ,fth_attribute_category IN VARCHAR2 --INPUT
206 ,fth_recipient_bsv IN VARCHAR2 --INPUT
207 ,fth_recipient_id IN NUMBER --INPUT
208 ,fth_to_ledger_id IN NUMBER --INPUT
209 ,fth_to_le_id IN NUMBER --INPUT
210 ,ftt_allow_interest_accr_flag IN VARCHAR2 --INPUT
211 ,ftt_allow_invoicing_flag IN VARCHAR2 --INPUT
212 ,ftt_attribute1 IN VARCHAR2 --INPUT
213 ,ftt_attribute10 IN VARCHAR2 --INPUT
214 ,ftt_attribute11 IN VARCHAR2 --INPUT
215 ,ftt_attribute12 IN VARCHAR2 --INPUT
216 ,ftt_attribute13 IN VARCHAR2 --INPUT
217 ,ftt_attribute14 IN VARCHAR2 --INPUT
218 ,ftt_attribute15 IN VARCHAR2 --INPUT
219 ,ftt_attribute2 IN VARCHAR2 --INPUT
220 ,ftt_attribute3 IN VARCHAR2 --INPUT
221 ,ftt_attribute4 IN VARCHAR2 --INPUT
222 ,ftt_attribute5 IN VARCHAR2 --INPUT
223 ,ftt_attribute6 IN VARCHAR2 --INPUT
224 ,ftt_attribute7 IN VARCHAR2 --INPUT
225 ,ftt_attribute8 IN VARCHAR2 --INPUT
226 ,ftt_attribute9 IN VARCHAR2 --INPUT
227 ,ftt_attribute_category IN VARCHAR2 --INPUT
228 ,ftt_manual_approve_flag IN VARCHAR2 --INPUT
229 ,ftt_trx_type_id IN NUMBER --INPUT
230 ,ftt_vat_taxable_flag IN VARCHAR2 --INPUT
231 --END of source list
232 ,x_return_status OUT NOCOPY VARCHAR2 --OUTPUT
233 ,x_msg_count OUT NOCOPY NUMBER --OUTPUT
234 ,x_msg_data OUT NOCOPY VARCHAR2 --OUTPUT
235 );
236
237 PROCEDURE read_online_tab
238 (
239 p_api_version IN NUMBER
240 ,p_source_distrib_id_num_1 IN NUMBER
241 ,p_source_distrib_id_num_2 IN NUMBER
242 ,p_source_distrib_id_num_3 IN NUMBER
243 ,p_source_distrib_id_num_4 IN NUMBER
244 ,p_source_distrib_id_num_5 IN NUMBER
245 ,p_account_type_code IN VARCHAR2
246 ,x_target_ccid OUT NOCOPY NUMBER
247 ,x_concatenated_segments OUT NOCOPY VARCHAR2
248 ,x_return_status OUT NOCOPY VARCHAR2
249 ,x_msg_count OUT NOCOPY NUMBER
250 ,x_msg_data OUT NOCOPY VARCHAR2
251 );
252
253 END FUN_XLA_TAB_PKG;
254