[Home] [Help]
PACKAGE: APPS.FUN_XLA_TAB_PKG
Source
1 PACKAGE FUN_XLA_TAB_PKG AS
2 /* $Header: funxlatabs.pls 120.1 2006/07/14 09:38:02 bsilveir noship $ */
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 | 12-JUL-06 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_initiator_bsv VARCHAR2(80) --INPUT
72 ,ftb_initiator_id NUMBER --INPUT
73 ,fth_attribute1 VARCHAR2(80) --INPUT
74 ,fth_attribute10 VARCHAR2(80) --INPUT
75 ,fth_attribute11 VARCHAR2(80) --INPUT
76 ,fth_attribute12 VARCHAR2(80) --INPUT
77 ,fth_attribute13 VARCHAR2(80) --INPUT
78 ,fth_attribute14 VARCHAR2(80) --INPUT
79 ,fth_attribute15 VARCHAR2(80) --INPUT
80 ,fth_attribute2 VARCHAR2(80) --INPUT
81 ,fth_attribute3 VARCHAR2(80) --INPUT
82 ,fth_attribute4 VARCHAR2(80) --INPUT
83 ,fth_attribute5 VARCHAR2(80) --INPUT
84 ,fth_attribute6 VARCHAR2(80) --INPUT
85 ,fth_attribute7 VARCHAR2(80) --INPUT
86 ,fth_attribute8 VARCHAR2(80) --INPUT
87 ,fth_attribute9 VARCHAR2(80) --INPUT
88 ,fth_attribute_category VARCHAR2(80) --INPUT
89 ,fth_recipient_bsv VARCHAR2(80) --INPUT
90 ,fth_recipient_id NUMBER --INPUT
91 ,fth_to_ledger_id NUMBER --INPUT
92 ,fth_to_le_id NUMBER --INPUT
93 ,ftt_allow_interest_accr_flag VARCHAR2(80) --INPUT
94 ,ftt_allow_invoicing_flag VARCHAR2(80) --INPUT
95 ,ftt_attribute1 VARCHAR2(80) --INPUT
96 ,ftt_attribute10 VARCHAR2(80) --INPUT
97 ,ftt_attribute11 VARCHAR2(80) --INPUT
98 ,ftt_attribute12 VARCHAR2(80) --INPUT
99 ,ftt_attribute13 VARCHAR2(80) --INPUT
100 ,ftt_attribute14 VARCHAR2(80) --INPUT
101 ,ftt_attribute15 VARCHAR2(80) --INPUT
102 ,ftt_attribute2 VARCHAR2(80) --INPUT
103 ,ftt_attribute3 VARCHAR2(80) --INPUT
104 ,ftt_attribute4 VARCHAR2(80) --INPUT
105 ,ftt_attribute5 VARCHAR2(80) --INPUT
106 ,ftt_attribute6 VARCHAR2(80) --INPUT
107 ,ftt_attribute7 VARCHAR2(80) --INPUT
108 ,ftt_attribute8 VARCHAR2(80) --INPUT
109 ,ftt_attribute9 VARCHAR2(80) --INPUT
110 ,ftt_attribute_category VARCHAR2(80) --INPUT
111 ,ftt_manual_approve_flag VARCHAR2(80) --INPUT
112 ,ftt_trx_type_id NUMBER --INPUT
113 ,ftt_vat_taxable_flag VARCHAR2(80) --INPUT
114 --END of source list
115 ,target_ccid NUMBER(15) --OUTPUT
116 ,concatenated_segments VARCHAR2(2000) --OUTPUT
117 ,msg_count NUMBER --OUTPUT
118 ,msg_data VARCHAR2(2000) --OUTPUT
119 );
120
121
122
123 --Public table types
124 TYPE t_array_xla_tab
125 IS TABLE OF t_rec_xla_tab INDEX BY BINARY_INTEGER;
126
127
128 --Public variables
129 g_array_xla_tab t_array_xla_tab ;
130
131
132 --Public procedures
133 PROCEDURE run
134 (
135 p_api_version IN NUMBER
136 ,p_account_definition_type_code IN VARCHAR2
137 ,p_account_definition_code IN VARCHAR2
138 ,p_transaction_coa_id IN NUMBER
139 ,p_mode IN VARCHAR2
140 ,x_return_status OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 ,x_msg_data OUT NOCOPY VARCHAR2
143 );
144
145 PROCEDURE reset_online_interface
146 (
147 p_api_version IN NUMBER
148 ,x_return_status OUT NOCOPY VARCHAR2
149 ,x_msg_count OUT NOCOPY NUMBER
150 ,x_msg_data OUT NOCOPY VARCHAR2
151 );
152
153 PROCEDURE write_online_tab
154 (
155 p_api_version IN NUMBER --INPUT NOT NULL
156 ,p_source_distrib_id_num_1 IN NUMBER --INPUT
157 ,p_source_distrib_id_num_2 IN NUMBER --INPUT
158 ,p_source_distrib_id_num_3 IN NUMBER --INPUT
159 ,p_source_distrib_id_num_4 IN NUMBER --INPUT
160 ,p_source_distrib_id_num_5 IN NUMBER --INPUT
161 ,p_account_type_code IN VARCHAR2 --INPUT NOT NULL
162 --START of source list
163 ,ftb_attribute1 IN VARCHAR2 --INPUT
164 ,ftb_attribute10 IN VARCHAR2 --INPUT
165 ,ftb_attribute11 IN VARCHAR2 --INPUT
166 ,ftb_attribute12 IN VARCHAR2 --INPUT
167 ,ftb_attribute13 IN VARCHAR2 --INPUT
168 ,ftb_attribute14 IN VARCHAR2 --INPUT
169 ,ftb_attribute15 IN VARCHAR2 --INPUT
170 ,ftb_attribute2 IN VARCHAR2 --INPUT
171 ,ftb_attribute3 IN VARCHAR2 --INPUT
172 ,ftb_attribute4 IN VARCHAR2 --INPUT
173 ,ftb_attribute5 IN VARCHAR2 --INPUT
174 ,ftb_attribute6 IN VARCHAR2 --INPUT
175 ,ftb_attribute7 IN VARCHAR2 --INPUT
176 ,ftb_attribute8 IN VARCHAR2 --INPUT
177 ,ftb_attribute9 IN VARCHAR2 --INPUT
178 ,ftb_category_code IN VARCHAR2 --INPUT
179 ,ftb_currency_code IN VARCHAR2 --INPUT
180 ,ftb_from_ledger_id IN NUMBER --INPUT
181 ,ftb_from_le_id IN NUMBER --INPUT
182 ,ftb_initiator_bsv IN VARCHAR2 --INPUT
183 ,ftb_initiator_id IN NUMBER --INPUT
184 ,fth_attribute1 IN VARCHAR2 --INPUT
185 ,fth_attribute10 IN VARCHAR2 --INPUT
186 ,fth_attribute11 IN VARCHAR2 --INPUT
187 ,fth_attribute12 IN VARCHAR2 --INPUT
188 ,fth_attribute13 IN VARCHAR2 --INPUT
189 ,fth_attribute14 IN VARCHAR2 --INPUT
190 ,fth_attribute15 IN VARCHAR2 --INPUT
191 ,fth_attribute2 IN VARCHAR2 --INPUT
192 ,fth_attribute3 IN VARCHAR2 --INPUT
193 ,fth_attribute4 IN VARCHAR2 --INPUT
194 ,fth_attribute5 IN VARCHAR2 --INPUT
195 ,fth_attribute6 IN VARCHAR2 --INPUT
196 ,fth_attribute7 IN VARCHAR2 --INPUT
197 ,fth_attribute8 IN VARCHAR2 --INPUT
198 ,fth_attribute9 IN VARCHAR2 --INPUT
199 ,fth_attribute_category IN VARCHAR2 --INPUT
200 ,fth_recipient_bsv IN VARCHAR2 --INPUT
201 ,fth_recipient_id IN NUMBER --INPUT
202 ,fth_to_ledger_id IN NUMBER --INPUT
203 ,fth_to_le_id IN NUMBER --INPUT
204 ,ftt_allow_interest_accr_flag IN VARCHAR2 --INPUT
205 ,ftt_allow_invoicing_flag IN VARCHAR2 --INPUT
206 ,ftt_attribute1 IN VARCHAR2 --INPUT
207 ,ftt_attribute10 IN VARCHAR2 --INPUT
208 ,ftt_attribute11 IN VARCHAR2 --INPUT
209 ,ftt_attribute12 IN VARCHAR2 --INPUT
210 ,ftt_attribute13 IN VARCHAR2 --INPUT
211 ,ftt_attribute14 IN VARCHAR2 --INPUT
212 ,ftt_attribute15 IN VARCHAR2 --INPUT
213 ,ftt_attribute2 IN VARCHAR2 --INPUT
214 ,ftt_attribute3 IN VARCHAR2 --INPUT
215 ,ftt_attribute4 IN VARCHAR2 --INPUT
216 ,ftt_attribute5 IN VARCHAR2 --INPUT
217 ,ftt_attribute6 IN VARCHAR2 --INPUT
218 ,ftt_attribute7 IN VARCHAR2 --INPUT
219 ,ftt_attribute8 IN VARCHAR2 --INPUT
220 ,ftt_attribute9 IN VARCHAR2 --INPUT
221 ,ftt_attribute_category IN VARCHAR2 --INPUT
222 ,ftt_manual_approve_flag IN VARCHAR2 --INPUT
223 ,ftt_trx_type_id IN NUMBER --INPUT
224 ,ftt_vat_taxable_flag IN VARCHAR2 --INPUT
225 --END of source list
226 ,x_return_status OUT NOCOPY VARCHAR2 --OUTPUT
227 ,x_msg_count OUT NOCOPY NUMBER --OUTPUT
228 ,x_msg_data OUT NOCOPY VARCHAR2 --OUTPUT
229 );
230
231 PROCEDURE read_online_tab
232 (
233 p_api_version IN NUMBER
234 ,p_source_distrib_id_num_1 IN NUMBER
235 ,p_source_distrib_id_num_2 IN NUMBER
236 ,p_source_distrib_id_num_3 IN NUMBER
237 ,p_source_distrib_id_num_4 IN NUMBER
238 ,p_source_distrib_id_num_5 IN NUMBER
239 ,p_account_type_code IN VARCHAR2
240 ,x_target_ccid OUT NOCOPY NUMBER
241 ,x_concatenated_segments OUT NOCOPY VARCHAR2
242 ,x_return_status OUT NOCOPY VARCHAR2
243 ,x_msg_count OUT NOCOPY NUMBER
244 ,x_msg_data OUT NOCOPY VARCHAR2
245 );
246
247 END FUN_XLA_TAB_PKG;