[Home] [Help]
PACKAGE: APPS.ARRX_C_TRX
Source
1 PACKAGE ARRX_C_TRX as
2 /* $Header: ARRXCTXS.pls 120.3 2005/10/30 03:56:56 appldev ship $ */
3
4 PROCEDURE TRANSACTION_REGISTER (
5 errbuf out NOCOPY varchar2,
6 retcode out NOCOPY varchar2,
7 argument1 in varchar2, -- reporting_level
8 argument2 in varchar2, -- reporting_entity_id
9 argument3 in varchar2, -- set_of_books_id
10 argument4 in varchar2, -- chart_of_accounts_id
11 argument5 in varchar2, -- company_seg_low
12 argument6 in varchar2, -- company_seg_high
13 argument7 in varchar2, -- gl_date_low
14 argument8 in varchar2, -- gl_date_high
15 argument9 in varchar2, -- account_seg_low
16 argument10 in varchar2, -- account_seg_high
17 argument11 in varchar2, -- currency_code_low
18 argument12 in varchar2, -- currency_code_high
19 argument13 in varchar2, -- batch_source_id
20 argument14 in varchar2, -- trx_type_low
21 argument15 in varchar2, -- trx_type_high
22 argument16 in varchar2, -- invoice_class
23 argument17 in varchar2, -- trx_date_low
24 argument18 in varchar2, -- trx_date_high
25 argument19 in varchar2, -- doc seq name
26 argument20 in varchar2, -- doc seq num low
27 argument21 in varchar2, -- doc seq num high
28 argument22 in varchar2 default 'N', -- debug flag
29 argument23 in varchar2 default 'N', -- sql trace
30 argument24 in varchar2 default null,
31 argument25 in varchar2 default null,
32 argument26 in varchar2 default null,
33 argument27 in varchar2 default null,
34 argument28 in varchar2 default null,
35 argument29 in varchar2 default null,
36 argument30 in varchar2 default null,
37 argument31 in varchar2 default null,
38 argument32 in varchar2 default null,
39 argument33 in varchar2 default null,
40 argument34 in varchar2 default null,
41 argument35 in varchar2 default null,
42 argument36 in varchar2 default null,
43 argument37 in varchar2 default null,
44 argument38 in varchar2 default null,
45 argument39 in varchar2 default null,
46 argument40 in varchar2 default null,
47 argument41 in varchar2 default null,
48 argument42 in varchar2 default null,
49 argument43 in varchar2 default null,
50 argument44 in varchar2 default null,
51 argument45 in varchar2 default null,
52 argument46 in varchar2 default null,
53 argument47 in varchar2 default null,
54 argument48 in varchar2 default null,
55 argument49 in varchar2 default null,
56 argument50 in varchar2 default null,
57 argument51 in varchar2 default null,
58 argument52 in varchar2 default null,
59 argument53 in varchar2 default null,
60 argument54 in varchar2 default null,
61 argument55 in varchar2 default null,
62 argument56 in varchar2 default null,
63 argument57 in varchar2 default null,
64 argument58 in varchar2 default null,
65 argument59 in varchar2 default null,
66 argument60 in varchar2 default null,
67 argument61 in varchar2 default null,
68 argument62 in varchar2 default null,
69 argument63 in varchar2 default null,
70 argument64 in varchar2 default null,
71 argument65 in varchar2 default null,
72 argument66 in varchar2 default null,
73 argument67 in varchar2 default null,
74 argument68 in varchar2 default null,
75 argument69 in varchar2 default null,
76 argument70 in varchar2 default null,
77 argument71 in varchar2 default null,
78 argument72 in varchar2 default null,
79 argument73 in varchar2 default null,
80 argument74 in varchar2 default null,
81 argument75 in varchar2 default null,
82 argument76 in varchar2 default null,
83 argument77 in varchar2 default null,
84 argument78 in varchar2 default null,
85 argument79 in varchar2 default null,
86 argument80 in varchar2 default null,
87 argument81 in varchar2 default null,
88 argument82 in varchar2 default null,
89 argument83 in varchar2 default null,
90 argument84 in varchar2 default null,
91 argument85 in varchar2 default null,
92 argument86 in varchar2 default null,
93 argument87 in varchar2 default null,
94 argument88 in varchar2 default null,
95 argument89 in varchar2 default null,
96 argument90 in varchar2 default null,
97 argument91 in varchar2 default null,
98 argument92 in varchar2 default null,
99 argument93 in varchar2 default null,
100 argument94 in varchar2 default null,
101 argument95 in varchar2 default null,
102 argument96 in varchar2 default null,
103 argument97 in varchar2 default null,
104 argument98 in varchar2 default null,
105 argument99 in varchar2 default null,
106 argument100 in varchar2 default null);
107
108 PROCEDURE TRANSACTION_CHECK (
109 errbuf out NOCOPY varchar2,
110 retcode out NOCOPY varchar2,
111 argument1 in varchar2, -- set_of_books_id
112 argument2 in varchar2, -- chart_of_accounts_id
113 argument3 in varchar2, -- completed_flag
114 argument4 in varchar2, -- posted_flag
115 argument5 in varchar2, -- gl_date_low
116 argument6 in varchar2, -- gl_date_high
117 argument7 in varchar2, -- transaction_date_low
118 argument8 in varchar2, -- transaction_date_high
119 argument9 in varchar2, -- transaction_type_low
120 argument10 in varchar2, -- transaction_type_high
121 argument11 in varchar2, -- currency_code_low
122 argument12 in varchar2, -- currency_code_high
123 argument13 in varchar2, -- company_segment_low
124 argument14 in varchar2, -- company_segment_high
125 argument15 in varchar2, -- invoice_class_low
126 argument16 in varchar2, -- invoice_class_high
127 argument17 in varchar2, -- customer_name_low
128 argument18 in varchar2, -- customer_name_high
129 argument19 in varchar2, -- payment_method
130 argument20 in varchar2, -- start_update_date
131 argument21 in varchar2, -- end_update_date
132 argument22 in varchar2, -- last_updated_by
133 argument23 in varchar2 default 'N', -- debug flag
134 argument24 in varchar2 default 'N', -- sql trace
135 argument25 in varchar2 default null,
136 argument26 in varchar2 default null,
137 argument27 in varchar2 default null,
138 argument28 in varchar2 default null,
139 argument29 in varchar2 default null,
140 argument30 in varchar2 default null,
141 argument31 in varchar2 default null,
142 argument32 in varchar2 default null,
143 argument33 in varchar2 default null,
144 argument34 in varchar2 default null,
145 argument35 in varchar2 default null,
146 argument36 in varchar2 default null,
147 argument37 in varchar2 default null,
148 argument38 in varchar2 default null,
149 argument39 in varchar2 default null,
150 argument40 in varchar2 default null,
151 argument41 in varchar2 default null,
152 argument42 in varchar2 default null,
153 argument43 in varchar2 default null,
154 argument44 in varchar2 default null,
155 argument45 in varchar2 default null,
156 argument46 in varchar2 default null,
157 argument47 in varchar2 default null,
158 argument48 in varchar2 default null,
159 argument49 in varchar2 default null,
160 argument50 in varchar2 default null,
161 argument51 in varchar2 default null,
162 argument52 in varchar2 default null,
163 argument53 in varchar2 default null,
164 argument54 in varchar2 default null,
165 argument55 in varchar2 default null,
166 argument56 in varchar2 default null,
167 argument57 in varchar2 default null,
168 argument58 in varchar2 default null,
169 argument59 in varchar2 default null,
170 argument60 in varchar2 default null,
171 argument61 in varchar2 default null,
172 argument62 in varchar2 default null,
173 argument63 in varchar2 default null,
174 argument64 in varchar2 default null,
175 argument65 in varchar2 default null,
176 argument66 in varchar2 default null,
177 argument67 in varchar2 default null,
178 argument68 in varchar2 default null,
179 argument69 in varchar2 default null,
180 argument70 in varchar2 default null,
181 argument71 in varchar2 default null,
182 argument72 in varchar2 default null,
183 argument73 in varchar2 default null,
184 argument74 in varchar2 default null,
185 argument75 in varchar2 default null,
186 argument76 in varchar2 default null,
187 argument77 in varchar2 default null,
188 argument78 in varchar2 default null,
189 argument79 in varchar2 default null,
190 argument80 in varchar2 default null,
191 argument81 in varchar2 default null,
192 argument82 in varchar2 default null,
193 argument83 in varchar2 default null,
194 argument84 in varchar2 default null,
195 argument85 in varchar2 default null,
196 argument86 in varchar2 default null,
197 argument87 in varchar2 default null,
198 argument88 in varchar2 default null,
199 argument89 in varchar2 default null,
200 argument90 in varchar2 default null,
201 argument91 in varchar2 default null,
202 argument92 in varchar2 default null,
203 argument93 in varchar2 default null,
204 argument94 in varchar2 default null,
205 argument95 in varchar2 default null,
206 argument96 in varchar2 default null,
207 argument97 in varchar2 default null,
208 argument98 in varchar2 default null,
209 argument99 in varchar2 default null,
210 argument100 in varchar2 default null);
211
212 PROCEDURE RECEIPT_FORECAST (
213 errbuf out NOCOPY varchar2,
214 retcode out NOCOPY varchar2,
215 argument1 in varchar2, -- set_of_books_id
216 argument2 in varchar2, -- chart_of_accounts_id
217 argument3 in varchar2, -- completed_flag
218 argument4 in varchar2, -- posted_flag
219 argument5 in varchar2, -- gl_date_low
220 argument6 in varchar2, -- gl_date_high
221 argument7 in varchar2, -- transaction_date_low
222 argument8 in varchar2, -- transaction_date_high
223 argument9 in varchar2, -- transaction_type_low
224 argument10 in varchar2, -- transaction_type_high
225 argument11 in varchar2, -- currency_code_low
226 argument12 in varchar2, -- currency_code_high
227 argument13 in varchar2, -- company_segment_low
228 argument14 in varchar2, -- company_segment_high
229 argument15 in varchar2, -- invoice_class_low
230 argument16 in varchar2, -- invoice_class_high
231 argument17 in varchar2, -- customer_name_low
232 argument18 in varchar2, -- customer_name_high
233 argument19 in varchar2, -- payment_method
234 argument20 in varchar2 default null,
235 argument21 in varchar2 default null,
236 argument22 in varchar2 default null,
237 argument23 in varchar2, -- start_due_date
238 argument24 in varchar2, -- end_due_date
242 argument28 in varchar2 default null,
239 argument25 in varchar2 default 'N', -- debug flag
240 argument26 in varchar2 default 'N', -- sql trace
241 argument27 in varchar2 default null,
243 argument29 in varchar2 default null,
244 argument30 in varchar2 default null,
245 argument31 in varchar2 default null,
246 argument32 in varchar2 default null,
247 argument33 in varchar2 default null,
248 argument34 in varchar2 default null,
249 argument35 in varchar2 default null,
250 argument36 in varchar2 default null,
251 argument37 in varchar2 default null,
252 argument38 in varchar2 default null,
253 argument39 in varchar2 default null,
254 argument40 in varchar2 default null,
255 argument41 in varchar2 default null,
256 argument42 in varchar2 default null,
257 argument43 in varchar2 default null,
258 argument44 in varchar2 default null,
259 argument45 in varchar2 default null,
260 argument46 in varchar2 default null,
261 argument47 in varchar2 default null,
262 argument48 in varchar2 default null,
263 argument49 in varchar2 default null,
264 argument50 in varchar2 default null,
265 argument51 in varchar2 default null,
266 argument52 in varchar2 default null,
267 argument53 in varchar2 default null,
268 argument54 in varchar2 default null,
269 argument55 in varchar2 default null,
270 argument56 in varchar2 default null,
271 argument57 in varchar2 default null,
272 argument58 in varchar2 default null,
273 argument59 in varchar2 default null,
274 argument60 in varchar2 default null,
275 argument61 in varchar2 default null,
276 argument62 in varchar2 default null,
277 argument63 in varchar2 default null,
278 argument64 in varchar2 default null,
279 argument65 in varchar2 default null,
280 argument66 in varchar2 default null,
281 argument67 in varchar2 default null,
282 argument68 in varchar2 default null,
283 argument69 in varchar2 default null,
284 argument70 in varchar2 default null,
285 argument71 in varchar2 default null,
286 argument72 in varchar2 default null,
287 argument73 in varchar2 default null,
288 argument74 in varchar2 default null,
289 argument75 in varchar2 default null,
290 argument76 in varchar2 default null,
291 argument77 in varchar2 default null,
292 argument78 in varchar2 default null,
293 argument79 in varchar2 default null,
294 argument80 in varchar2 default null,
295 argument81 in varchar2 default null,
296 argument82 in varchar2 default null,
297 argument83 in varchar2 default null,
298 argument84 in varchar2 default null,
299 argument85 in varchar2 default null,
300 argument86 in varchar2 default null,
301 argument87 in varchar2 default null,
302 argument88 in varchar2 default null,
303 argument89 in varchar2 default null,
304 argument90 in varchar2 default null,
305 argument91 in varchar2 default null,
306 argument92 in varchar2 default null,
307 argument93 in varchar2 default null,
308 argument94 in varchar2 default null,
309 argument95 in varchar2 default null,
310 argument96 in varchar2 default null,
311 argument97 in varchar2 default null,
312 argument98 in varchar2 default null,
313 argument99 in varchar2 default null,
314 argument100 in varchar2 default null);
315
316 PROCEDURE SALES_REGISTER (
317 errbuf out NOCOPY varchar2,
318 retcode out NOCOPY varchar2,
319 argument1 in varchar2, -- set_of_books_id
320 argument2 in varchar2, -- chart_of_accounts_id
321 argument3 in varchar2 default 'Y', -- completed_flag
322 argument4 in varchar2 default null, -- GL_start_date
323 argument5 in varchar2 default null, -- GL_end_date
324 argument6 in varchar2 default 'BOTH', -- posted_flag
325 argument7 in varchar2 default null, -- transaction_type
326 argument8 in varchar2 default null, -- line_invoice
327 argument9 in varchar2 default null, -- start_invoice_num
328 argument10 in varchar2 default null, -- end_invoice_num
329 argument11 in varchar2 default null, -- doc_dsequence_name
330 argument12 in varchar2 default null, -- start_doc_sequence_value
334 argument16 in varchar2 default null, -- start_rec_nat_acct
331 argument13 in varchar2 default null, -- end_doc_sequence_value
332 argument14 in varchar2 default null, -- start_company_segment
333 argument15 in varchar2 default null, -- end_company_segment
335 argument17 in varchar2 default null, -- end_rec_nat_acct
336 argument18 in varchar2 default null, -- start_account
337 argument19 in varchar2 default null, -- end_account
338 argument20 in varchar2 default null, -- start_currency
339 argument21 in varchar2 default null, -- end_currency
340 argument22 in varchar2 default null, -- start_amount
341 argument23 in varchar2 default null, -- end_amount
342 argument24 in varchar2 default null, -- start_customer_name
343 argument25 in varchar2 default null, -- end_customer_name
344 argument26 in varchar2 default null, -- start_customer_number
345 argument27 in varchar2 default null, -- end_customer_number
346 argument28 in varchar2 default null, -- debug_switch
347 argument29 in varchar2 default null, -- trace_switch
348 argument30 in varchar2 default null,
349 argument31 in varchar2 default null,
350 argument32 in varchar2 default null,
351 argument33 in varchar2 default null,
352 argument34 in varchar2 default null,
353 argument35 in varchar2 default null,
354 argument36 in varchar2 default null,
355 argument37 in varchar2 default null,
356 argument38 in varchar2 default null,
357 argument39 in varchar2 default null,
358 argument40 in varchar2 default null,
359 argument41 in varchar2 default null,
360 argument42 in varchar2 default null,
361 argument43 in varchar2 default null,
362 argument44 in varchar2 default null,
363 argument45 in varchar2 default null,
364 argument46 in varchar2 default null,
365 argument47 in varchar2 default null,
366 argument48 in varchar2 default null,
367 argument49 in varchar2 default null,
368 argument50 in varchar2 default null,
369 argument51 in varchar2 default null,
370 argument52 in varchar2 default null,
371 argument53 in varchar2 default null,
372 argument54 in varchar2 default null,
373 argument55 in varchar2 default null,
374 argument56 in varchar2 default null,
375 argument57 in varchar2 default null,
376 argument58 in varchar2 default null,
377 argument59 in varchar2 default null,
378 argument60 in varchar2 default null,
379 argument61 in varchar2 default null,
380 argument62 in varchar2 default null,
381 argument63 in varchar2 default null,
382 argument64 in varchar2 default null,
383 argument65 in varchar2 default null,
384 argument66 in varchar2 default null,
385 argument67 in varchar2 default null,
386 argument68 in varchar2 default null,
387 argument69 in varchar2 default null,
388 argument70 in varchar2 default null,
389 argument71 in varchar2 default null,
390 argument72 in varchar2 default null,
391 argument73 in varchar2 default null,
392 argument74 in varchar2 default null,
393 argument75 in varchar2 default null,
394 argument76 in varchar2 default null,
395 argument77 in varchar2 default null,
396 argument78 in varchar2 default null,
397 argument79 in varchar2 default null,
398 argument80 in varchar2 default null,
399 argument81 in varchar2 default null,
400 argument82 in varchar2 default null,
401 argument83 in varchar2 default null,
402 argument84 in varchar2 default null,
403 argument85 in varchar2 default null,
404 argument86 in varchar2 default null,
405 argument87 in varchar2 default null,
406 argument88 in varchar2 default null,
407 argument89 in varchar2 default null,
408 argument90 in varchar2 default null,
409 argument91 in varchar2 default null,
410 argument92 in varchar2 default null,
411 argument93 in varchar2 default null,
412 argument94 in varchar2 default null,
413 argument95 in varchar2 default null,
414 argument96 in varchar2 default null,
415 argument97 in varchar2 default null,
416 argument98 in varchar2 default null,
417 argument99 in varchar2 default null,
418 argument100 in varchar2 default null);
419
420 -- Bug 2008925. Adding new procedure for Purge API
421 PROCEDURE PURGE_TRANSACTION_DATA(
425 END ARRX_C_TRX;
422 p_request_id in number,
423 p_rows_affected out NOCOPY number);
424