[Home] [Help]
PACKAGE: APPS.AR_INVOICE_API_PUB
Source
1 PACKAGE AR_INVOICE_API_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARXPINVS.pls 120.32.12020000.2 2012/07/25 06:19:20 ashlkuma ship $ */
3 /*#
4 * Invoice Creation API allows users to create an invoice using simple
5 * calls to PL/SQL functions. Invoices can be created either in batch
6 * mode with multiple invoices or a single invoice.
7 * The Invoice Creation API is not intended to replace the existing
8 * Transaction workbench, AutoInvoice, or the Transaction API program.
9 * @rep:scope public
10 * @rep:metalink 236938.1 See OracleMetaLink note 236938.1
11 * @rep:product AR
12 * @rep:lifecycle active
13 * @rep:displayname Invoice Creation
14 * @rep:category BUSINESS_ENTITY AR_INVOICE
15 */
16
17 TYPE trx_header_rec_type IS RECORD (
18 trx_header_id NUMBER,
19 trx_number VARCHAR2(20) DEFAULT NULL,
20 trx_date DATE DEFAULT NULL,
21 trx_currency VARCHAR2(30) DEFAULT NULL,
22 reference_number VARCHAR2(30) DEFAULT NULL,
23 trx_class VARCHAR2(20) DEFAULT 'INV',
24 cust_trx_type_id NUMBER DEFAULT NULL,
25 gl_date DATE DEFAULT NULL,
26 bill_to_customer_id NUMBER DEFAULT NULL,
27 bill_to_account_number VARCHAR2(30) DEFAULT NULL,
28 bill_to_customer_name VARCHAR2(260) DEFAULT NULL,
29 -- bill_to_location_id NUMBER DEFAULT NULL,
30 bill_to_contact_id NUMBER DEFAULT NULL,
31 bill_to_address_id NUMBER DEFAULT NULL,
32 bill_to_site_use_id NUMBER DEFAULT NULL,
33 ship_to_customer_id NUMBER DEFAULT NULL,
34 ship_to_account_number VARCHAR2(30) DEFAULT NULL,
35 ship_to_customer_name VARCHAR2(260) DEFAULT NULL,
36 -- ship_to_location_id NUMBER DEFAULT NULL,
37 ship_to_contact_id NUMBER DEFAULT NULL,
38 ship_to_address_id NUMBER DEFAULT NULL,
39 ship_to_site_use_id NUMBER DEFAULT NULL,
40 sold_to_customer_id NUMBER DEFAULT NULL,
41 -- sold_to_site_use_id NUMBER DEFAULT NULL,
42 -- sold_to_contact_id NUMBER DEFAULT NULL,
43 term_id NUMBER DEFAULT NULL,
44 primary_salesrep_id NUMBER DEFAULT NULL,
45 primary_salesrep_name VARCHAR2(240) DEFAULT NULL,
46 exchange_rate_type VARCHAR2(60) DEFAULT NULL,
47 exchange_date DATE DEFAULT NULL,
48 exchange_rate NUMBER DEFAULT NULL,
49 territory_id NUMBER DEFAULT NULL,
50 remit_to_address_id NUMBER DEFAULT NULL,
51 invoicing_rule_id NUMBER DEFAULT NULL,
52 -- shipment_id NUMBER DEFAULT NULL,
53 printing_option VARCHAR2(20) DEFAULT NULL,
54 -- printing_count NUMBER DEFAULT NULL,
55 purchase_order VARCHAR2(50) DEFAULT NULL,
56 purchase_order_revision VARCHAR2(50) DEFAULT NULL,
57 purchase_order_date DATE DEFAULT NULL,
58 -- customer_reference VARCHAR2(30) DEFAULT NULL,
59 -- customer_reference_date DATE DEFAULT NULL,
60 comments VARCHAR2(1760) DEFAULT NULL, -- Bug 7484119
61 internal_notes VARCHAR2(240) DEFAULT NULL,
62 finance_charges VARCHAR2(1) DEFAULT NULL,
63 -- credit_method_for_rules VARCHAR2(30) DEFAULT NULL,
64 -- credit_method_for_installments VARCHAR2(30) DEFAULT NULL,
65 receipt_method_id NUMBER DEFAULT NULL,
66 related_customer_trx_id NUMBER DEFAULT NULL,
70 waybill_number VARCHAR2(50) DEFAULT NULL,
67 agreement_id NUMBER DEFAULT NULL,
68 ship_via VARCHAR2(30) DEFAULT NULL,
69 ship_date_actual DATE DEFAULT NULL,
71 fob_point VARCHAR2(30) DEFAULT NULL,
72 customer_bank_account_id NUMBER DEFAULT NULL,
73 -- default_ussgl_trx_code_context VARCHAR2(30) DEFAULT NULL,
74 default_ussgl_transaction_code VARCHAR2(30) DEFAULT NULL,
75 -- recurred_from_trx_number VARCHAR2(20) DEFAULT NULL,
76 status_trx VARCHAR2(30) DEFAULT NULL,
77 paying_customer_id NUMBER DEFAULT NULL,
78 paying_site_use_id NUMBER DEFAULT NULL,
79 default_tax_exempt_flag VARCHAR2(1) DEFAULT NULL,
80 -- mrc_exchange_rate_type VARCHAR2(2000) DEFAULT NULL,
81 -- mrc_exchange_date VARCHAR2(2000) DEFAULT NULL,
82 -- mrc_exchange_rate VARCHAR2(2000) DEFAULT NULL,
83 -- doc_sequence_id NUMBER(15) DEFAULT NULL,
84 doc_sequence_value NUMBER(15) DEFAULT NULL,
85 attribute_category VARCHAR2(30) DEFAULT NULL,
86 attribute1 VARCHAR2(150) DEFAULT NULL,
87 attribute2 VARCHAR2(150) DEFAULT NULL,
88 attribute3 VARCHAR2(150) DEFAULT NULL,
89 attribute4 VARCHAR2(150) DEFAULT NULL,
90 attribute5 VARCHAR2(150) DEFAULT NULL,
91 attribute6 VARCHAR2(150) DEFAULT NULL,
92 attribute7 VARCHAR2(150) DEFAULT NULL,
93 attribute8 VARCHAR2(150) DEFAULT NULL,
94 attribute9 VARCHAR2(150) DEFAULT NULL,
95 attribute10 VARCHAR2(150) DEFAULT NULL,
96 attribute11 VARCHAR2(150) DEFAULT NULL,
97 attribute12 VARCHAR2(150) DEFAULT NULL,
98 attribute13 VARCHAR2(150) DEFAULT NULL,
99 attribute14 VARCHAR2(150) DEFAULT NULL,
100 attribute15 VARCHAR2(150) DEFAULT NULL,
101 global_attribute_category VARCHAR2(30) DEFAULT NULL,
102 global_attribute1 VARCHAR2(150) DEFAULT NULL,
103 global_attribute2 VARCHAR2(150) DEFAULT NULL,
104 global_attribute3 VARCHAR2(150) DEFAULT NULL,
105 global_attribute4 VARCHAR2(150) DEFAULT NULL,
106 global_attribute5 VARCHAR2(150) DEFAULT NULL,
107 global_attribute6 VARCHAR2(150) DEFAULT NULL,
108 global_attribute7 VARCHAR2(150) DEFAULT NULL,
109 global_attribute8 VARCHAR2(150) DEFAULT NULL,
110 global_attribute9 VARCHAR2(150) DEFAULT NULL,
111 global_attribute10 VARCHAR2(150) DEFAULT NULL,
112 global_attribute11 VARCHAR2(150) DEFAULT NULL,
113 global_attribute12 VARCHAR2(150) DEFAULT NULL,
114 global_attribute13 VARCHAR2(150) DEFAULT NULL,
115 global_attribute14 VARCHAR2(150) DEFAULT NULL,
116 global_attribute15 VARCHAR2(150) DEFAULT NULL,
117 global_attribute16 VARCHAR2(150) DEFAULT NULL,
118 global_attribute17 VARCHAR2(150) DEFAULT NULL,
119 global_attribute18 VARCHAR2(150) DEFAULT NULL,
120 global_attribute19 VARCHAR2(150) DEFAULT NULL,
121 global_attribute20 VARCHAR2(150) DEFAULT NULL,
122 global_attribute21 VARCHAR2(150) DEFAULT NULL,
123 global_attribute22 VARCHAR2(150) DEFAULT NULL,
124 global_attribute23 VARCHAR2(150) DEFAULT NULL,
125 global_attribute24 VARCHAR2(150) DEFAULT NULL,
126 global_attribute25 VARCHAR2(150) DEFAULT NULL,
127 global_attribute26 VARCHAR2(150) DEFAULT NULL,
128 global_attribute27 VARCHAR2(150) DEFAULT NULL,
129 global_attribute28 VARCHAR2(150) DEFAULT NULL,
130 global_attribute29 VARCHAR2(150) DEFAULT NULL,
131 global_attribute30 VARCHAR2(150) DEFAULT NULL,
132 interface_header_context VARCHAR2(30) DEFAULT NULL,
133 interface_header_attribute1 VARCHAR2(150) DEFAULT NULL,
134 interface_header_attribute2 VARCHAR2(150) DEFAULT NULL,
135 interface_header_attribute3 VARCHAR2(150) DEFAULT NULL,
136 interface_header_attribute4 VARCHAR2(150) DEFAULT NULL,
137 interface_header_attribute5 VARCHAR2(150) DEFAULT NULL,
138 interface_header_attribute6 VARCHAR2(150) DEFAULT NULL,
139 interface_header_attribute7 VARCHAR2(150) DEFAULT NULL,
140 interface_header_attribute8 VARCHAR2(150) DEFAULT NULL,
141 interface_header_attribute9 VARCHAR2(150) DEFAULT NULL,
142 interface_header_attribute10 VARCHAR2(150) DEFAULT NULL,
143 interface_header_attribute11 VARCHAR2(150) DEFAULT NULL,
144 interface_header_attribute12 VARCHAR2(150) DEFAULT NULL,
145 interface_header_attribute13 VARCHAR2(150) DEFAULT NULL,
146 interface_header_attribute14 VARCHAR2(150) DEFAULT NULL,
150 payment_trxn_extension_id NUMBER DEFAULT NULL,
147 interface_header_attribute15 VARCHAR2(150) DEFAULT NULL,
148 org_id NUMBER DEFAULT NULL,
149 legal_entity_id NUMBER DEFAULT NULL,
151 billing_date DATE DEFAULT NULL,
152 --Late Charges
153 interest_header_id NUMBER DEFAULT NULL,
154 late_charges_assessed VARCHAR2(1) DEFAULT NULL,
155 document_sub_type VARCHAR2(240) DEFAULT NULL,
156 default_taxation_country VARCHAR2(2) DEFAULT NULL,
157 mandate_last_trx_flag VARCHAR2(1)
158 );
159
160 TYPE trx_header_tbl_type IS TABLE OF trx_header_rec_type
161 INDEX BY BINARY_INTEGER;
162
163 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_INVOICE_API_PUB';
164
165 TYPE trx_salescredits_rec_type IS RECORD (
166 TRX_salescredit_ID NUMBER ,
167 TRX_LINE_ID NUMBER ,
168 SALESREP_ID NUMBER DEFAULT NULL,
169 SALESREP_NUMBER VARCHAR2(30) DEFAULT NULL,
170 SALES_CREDIT_TYPE_NAME VARCHAR2(30) DEFAULT NULL,
171 SALES_CREDIT_TYPE_ID NUMBER(15) DEFAULT NULL,
172 --REVENUE_AMOUNT_SPLIT NUMBER DEFAULT NULL,
173 --REVENUE_PERCENT_SPLIT NUMBER DEFAULT NULL,
174 --NON_REVENUE_AMOUNT_SPLIT NUMBER DEFAULT NULL,
175 --NON_REVENUE_PERCENT_SPLIT NUMBER DEFAULT NULL,
176 -- REVENUE_ADJUSTMENT_ID NUMBER DEFAULT NULL,
177 SALESCREDIT_AMOUNT_SPLIT NUMBER DEFAULT NULL,
178 SALESCREDIT_PERCENT_SPLIT NUMBER DEFAULT NULL,
179 ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT NULL,
180 ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL,
181 ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL,
182 ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL,
183 ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL,
184 ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL,
185 ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL,
186 ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL,
187 ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL,
188 ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL,
189 ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL,
190 ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL,
191 ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL,
192 ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL,
193 ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL,
194 ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL);
195
196 TYPE trx_salescredits_tbl_type IS TABLE OF trx_salescredits_rec_type
197 INDEX BY BINARY_INTEGER;
198
199
200 -- BEGIN
201 -- new data types introduced for "Payment Based Revenue Managment" project
202 -- ORASHID 20-September-2004
203
204 TYPE trx_contingencies_rec_type IS RECORD
205 (
206 trx_contingency_id NUMBER,
207 trx_line_id NUMBER,
208 contingency_code VARCHAR2(30),
209 contingency_id NUMBER,
210 expiration_date DATE DEFAULT NULL,
211 expiration_days NUMBER DEFAULT NULL,
212 attribute_category VARCHAR2(30) DEFAULT NULL,
213 attribute1 VARCHAR2(150) DEFAULT NULL,
214 attribute2 VARCHAR2(150) DEFAULT NULL,
215 attribute3 VARCHAR2(150) DEFAULT NULL,
216 attribute4 VARCHAR2(150) DEFAULT NULL,
217 attribute5 VARCHAR2(150) DEFAULT NULL,
218 attribute6 VARCHAR2(150) DEFAULT NULL,
219 attribute7 VARCHAR2(150) DEFAULT NULL,
220 attribute8 VARCHAR2(150) DEFAULT NULL,
221 attribute9 VARCHAR2(150) DEFAULT NULL,
222 attribute10 VARCHAR2(150) DEFAULT NULL,
223 attribute11 VARCHAR2(150) DEFAULT NULL,
224 attribute12 VARCHAR2(150) DEFAULT NULL,
225 attribute13 VARCHAR2(150) DEFAULT NULL,
226 attribute14 VARCHAR2(150) DEFAULT NULL,
227 attribute15 VARCHAR2(150) DEFAULT NULL,
228 expiration_event_date DATE DEFAULT NULL,
229 completed_flag VARCHAR2(1) DEFAULT 'N',
230 completed_by NUMBER DEFAULT NULL
231 );
232
233 TYPE trx_contingencies_tbl_type IS TABLE OF trx_contingencies_rec_type
234 INDEX BY BINARY_INTEGER;
235
236 -- END
237 -- ORASHID 20-September-2004
238
239
240 TYPE trx_line_rec_type IS RECORD (
241 trx_header_id NUMBER,--required
242 trx_line_id NUMBER,--required
243 link_to_trx_line_id NUMBER, --required if line type is TAX or freight
244 LINE_NUMBER NUMBER, -- required
245 REASON_CODE VARCHAR2(30) DEFAULT NULL,
246 INVENTORY_ITEM_ID NUMBER DEFAULT NULL,
247 DESCRIPTION VARCHAR2(240) DEFAULT NULL,
248 QUANTITY_ORDERED NUMBER DEFAULT NULL,
249 -- QUANTITY_CREDITED NUMBER DEFAULT NULL,
250 QUANTITY_INVOICED NUMBER DEFAULT NULL,
251 UNIT_STANDARD_PRICE NUMBER DEFAULT NULL,
252 UNIT_SELLING_PRICE NUMBER DEFAULT NULL,
256 ACCOUNTING_RULE_ID NUMBER DEFAULT NULL,
253 SALES_ORDER VARCHAR2(50) DEFAULT NULL,
254 SALES_ORDER_LINE VARCHAR2(30) DEFAULT NULL,
255 SALES_ORDER_DATE DATE DEFAULT NULL,
257 ACCOUNTING_RULE_DURATION NUMBER DEFAULT NULL,
258 LINE_TYPE VARCHAR2(20), -- required
259 ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT NULL,
260 ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL,
261 ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL,
262 ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL,
263 ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL,
264 ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL,
265 ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL,
266 ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL,
267 ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL,
268 ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL,
269 ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL,
270 ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL,
271 ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL,
272 ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL,
273 ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL,
274 ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL,
275 RULE_START_DATE DATE DEFAULT NULL,
276 INTERFACE_LINE_CONTEXT VARCHAR2(30) DEFAULT NULL,
277 INTERFACE_LINE_ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL,
278 INTERFACE_LINE_ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL,
279 INTERFACE_LINE_ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL,
280 INTERFACE_LINE_ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL,
281 INTERFACE_LINE_ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL,
282 INTERFACE_LINE_ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL,
283 INTERFACE_LINE_ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL,
284 INTERFACE_LINE_ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL,
285 INTERFACE_LINE_ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL,
286 INTERFACE_LINE_ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL,
287 INTERFACE_LINE_ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL,
288 INTERFACE_LINE_ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL,
289 INTERFACE_LINE_ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL,
290 INTERFACE_LINE_ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL,
291 INTERFACE_LINE_ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL,
292 --channel in the form
293 SALES_ORDER_SOURCE VARCHAR2(50) DEFAULT NULL,
294 AMOUNT NUMBER, -- required
295 -- REVENUE_AMOUNT NUMBER DEFAULT NULL,
296 -- AUTORULE_COMPLETE_FLAG VARCHAR2(1) DEFAULT NULL,
297 TAX_PRECEDENCE NUMBER DEFAULT NULL,
298 TAX_RATE NUMBER DEFAULT NULL,
299 -- ITEM_EXCEPTION_RATE_ID NUMBER DEFAULT NULL,
300 TAX_EXEMPTION_ID NUMBER DEFAULT NULL,
301 MEMO_LINE_ID NUMBER DEFAULT NULL,
302 -- AUTORULE_DURATION_PROCESSED NUMBER DEFAULT NULL,
303 UOM_CODE VARCHAR2(3) DEFAULT NULL,
304 DEFAULT_USSGL_TRANSACTION_CODE VARCHAR2(30) DEFAULT NULL,
305 DEFAULT_USSGL_TRX_CODE_CONTEXT VARCHAR2(30) DEFAULT NULL,
306 VAT_TAX_ID NUMBER(15,0) DEFAULT NULL,
307 -- AUTOTAX VARCHAR2(1) DEFAULT NULL,
308 -- LAST_PERIOD_TO_CREDIT NUMBER DEFAULT NULL,
309 -- ITEM_CONTEXT VARCHAR2(30) DEFAULT NULL,
310 TAX_EXEMPT_FLAG VARCHAR2(1) DEFAULT NULL,
311 TAX_EXEMPT_NUMBER VARCHAR2(80) DEFAULT NULL,
312 TAX_EXEMPT_REASON_CODE VARCHAR2(30) DEFAULT NULL,
313 TAX_VENDOR_RETURN_CODE VARCHAR2(30) DEFAULT NULL,
314 -- LOCATION_SEGMENT_ID NUMBER DEFAULT NULL,
315 MOVEMENT_ID NUMBER DEFAULT NULL,
316 GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL,
317 GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL,
318 GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL,
319 GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL,
320 GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL,
321 GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL,
322 GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL,
323 GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL,
324 GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL,
325 GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL,
326 GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL,
327 GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL,
328 GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL,
329 GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL,
330 GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL,
331 GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT NULL,
332 GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT NULL,
333 GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT NULL,
334 GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT NULL,
335 GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT NULL,
336 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT NULL,
337 -- GROSS_UNIT_SELLING_PRICE NUMBER DEFAULT NULL,
338 -- GROSS_EXTENDED_AMOUNT NUMBER DEFAULT NULL,
339 AMOUNT_INCLUDES_TAX_FLAG VARCHAR2(1) DEFAULT NULL,
340 -- TAXABLE_AMOUNT NUMBER DEFAULT NULL,
341 WAREHOUSE_ID NUMBER DEFAULT NULL,
342 -- EXTENDED_ACCTD_AMOUNT NUMBER DEFAULT NULL,
343 CONTRACT_LINE_ID NUMBER DEFAULT NULL,
347 SOURCE_DATA_KEY4 VARCHAR2(150) DEFAULT NULL,
344 SOURCE_DATA_KEY1 VARCHAR2(150) DEFAULT NULL,
345 SOURCE_DATA_KEY2 VARCHAR2(150) DEFAULT NULL,
346 SOURCE_DATA_KEY3 VARCHAR2(150) DEFAULT NULL,
348 SOURCE_DATA_KEY5 VARCHAR2(150) DEFAULT NULL,
349 INVOICED_LINE_ACCTG_LEVEL VARCHAR2(15) DEFAULT NULL,
350 -- ship_via varchar2(30) DEFAULT NULL,
351 -- fob_point varchar2(30) DEFAULT NULL,
352 -- waybill_number varchar2(50) DEFAULT NULL,
353 SHIP_DATE_ACTUAL DATE DEFAULT NULL,
354 OVERRIDE_AUTO_ACCOUNTING_FLAG VARCHAR2(1) DEFAULT NULL,
355 DEFERRAL_EXCLUSION_FLAG VARCHAR2(1) DEFAULT NULL,
356 RULE_END_DATE DATE DEFAULT NULL,
357 SOURCE_APPLICATION_ID NUMBER DEFAULT NULL,
358 SOURCE_EVENT_CLASS_CODE VARCHAR2(30) DEFAULT NULL,
359 SOURCE_ENTITY_CODE VARCHAR2(30) DEFAULT NULL,
360 SOURCE_TRX_ID NUMBER DEFAULT NULL,
361 SOURCE_TRX_LINE_ID NUMBER DEFAULT NULL,
362 SOURCE_TRX_LINE_TYPE VARCHAR2(30) DEFAULT NULL,
363 SOURCE_TRX_DETAIL_TAX_LINE_ID NUMBER DEFAULT NULL,
364 HISTORICAL_FLAG VARCHAR2(1) DEFAULT NULL,
365 TAXABLE_FLAG VARCHAR2(1) DEFAULT NULL,
366 TAX_REGIME_CODE VARCHAR2(30) DEFAULT NULL,
367 TAX VARCHAR2(30) DEFAULT NULL,
368 TAX_STATUS_CODE VARCHAR2(30) DEFAULT NULL,
369 TAX_RATE_CODE VARCHAR2(35) DEFAULT NULL,
370 TAX_JURISDICTION_CODE VARCHAR2(30) DEFAULT NULL,
371 TAX_CLASSIFICATION_CODE VARCHAR2(50) DEFAULT NULL,
372 --Late Charges
373 interest_line_id NUMBER DEFAULT NULL,
374 TRX_BUSINESS_CATEGORY VARCHAR2(240) DEFAULT NULL,
375 PRODUCT_FISC_CLASSIFICATION VARCHAR2(240) DEFAULT NULL,
376 PRODUCT_CATEGORY VARCHAR2(240) DEFAULT NULL,
377 PRODUCT_TYPE VARCHAR2(240) DEFAULT NULL,
378 LINE_INTENDED_USE VARCHAR2(30) DEFAULT NULL,
379 ASSESSABLE_VALUE NUMBER
380 );
381
382
383 TYPE trx_line_tbl_type IS TABLE OF trx_line_rec_type
384 INDEX BY BINARY_INTEGER;
385
386 TYPE batch_source_rec_type IS RECORD (
387 batch_source_id NUMBER DEFAULT NULL,
388 default_date DATE DEFAULT NULL);
389
390
391 TYPE trx_dist_rec_type IS RECORD (
392 trx_dist_id NUMBER(15),
393 trx_header_id NUMBER(15),
394 trx_LINE_ID NUMBER(15),
395 ACCOUNT_CLASS VARCHAR2(20),
396 AMOUNT NUMBER DEFAULT NULL,
397 acctd_amount number DEFAULT NULL,
398 PERCENT NUMBER DEFAULT NULL,
399 CODE_COMBINATION_ID NUMBER(15) DEFAULT NULL,
400 -- CUST_TRX_LINE_SALESREP_ID NUMBER(15) DEFAULT NULL,
401 ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT NULL,
402 ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL,
403 ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL,
404 ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL,
405 ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL,
406 ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL,
407 ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL,
408 ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL,
409 ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL,
410 ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL,
411 ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL,
412 ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL,
413 ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL,
414 ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL,
415 ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL,
416 ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL,
417 COMMENTS VARCHAR2(240) DEFAULT NULL);
418
419 TYPE trx_dist_tbl_type IS TABLE OF trx_dist_rec_type
420 INDEX BY BINARY_INTEGER;
421
422
423 TYPE api_outputs_type IS RECORD
424 (
425 batch_id NUMBER DEFAULT NULL
426 );
427
428 g_api_outputs api_outputs_type;
429 g_customer_trx_id ra_customer_trx_all.customer_trx_id%type;
430 g_dist_exist boolean;
431 g_sc_exist boolean;
432 g_cont_exist boolean;
433
434 /*#
435 * Use this procedure to create multiple invoices in a batch.
436 * @rep:scope public
437 * @rep:lifecycle active
438 * @rep:displayname Create Invoice in a Batch
439 */
440
441 PROCEDURE CREATE_INVOICE(
442 p_api_version IN NUMBER,
443 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
444 p_commit IN VARCHAR2 := FND_API.G_FALSE,
445 p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
446 p_trx_header_tbl IN trx_header_tbl_type,
447 p_trx_lines_tbl IN trx_line_tbl_type,
448 p_trx_dist_tbl IN trx_dist_tbl_type,
449 p_trx_salescredits_tbl IN trx_salescredits_tbl_type,
450 x_return_status OUT NOCOPY VARCHAR2,
454 /*#
451 x_msg_count OUT NOCOPY NUMBER,
452 x_msg_data OUT NOCOPY VARCHAR2);
453
455 * Use this procedure to create a single invoice and return a customer transaction ID.
456 * @rep:scope public
457 * @rep:lifecycle active
458 * @rep:displayname Create Single Invoice
459 */
460
461 PROCEDURE CREATE_SINGLE_INVOICE(
462 p_api_version IN NUMBER,
463 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
464 p_commit IN VARCHAR2 := FND_API.G_FALSE,
465 p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
466 p_trx_header_tbl IN trx_header_tbl_type,
467 p_trx_lines_tbl IN trx_line_tbl_type,
468 p_trx_dist_tbl IN trx_dist_tbl_type,
469 p_trx_salescredits_tbl IN trx_salescredits_tbl_type,
470 x_customer_trx_id OUT NOCOPY NUMBER,
471 x_return_status OUT NOCOPY VARCHAR2,
472 x_msg_count OUT NOCOPY NUMBER,
473 x_msg_data OUT NOCOPY VARCHAR2);
474
475 -- added the overloaded procedures to make the api backward compatible
476 -- ORASHID
477 -- 10/11/2004
478
479
480 PROCEDURE CREATE_INVOICE(
481 p_api_version IN NUMBER,
482 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
483 p_commit IN VARCHAR2 := FND_API.G_FALSE,
484 p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
485 p_trx_header_tbl IN trx_header_tbl_type,
486 p_trx_lines_tbl IN trx_line_tbl_type,
487 p_trx_dist_tbl IN trx_dist_tbl_type,
488 p_trx_salescredits_tbl IN trx_salescredits_tbl_type,
489 p_trx_contingencies_tbl IN trx_contingencies_tbl_type,
490 x_return_status OUT NOCOPY VARCHAR2,
491 x_msg_count OUT NOCOPY NUMBER,
492 x_msg_data OUT NOCOPY VARCHAR2);
493
494
495 PROCEDURE CREATE_SINGLE_INVOICE(
496 p_api_version IN NUMBER,
497 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
498 p_commit IN VARCHAR2 := FND_API.G_FALSE,
499 p_batch_source_rec IN batch_source_rec_type DEFAULT NULL,
500 p_trx_header_tbl IN trx_header_tbl_type,
501 p_trx_lines_tbl IN trx_line_tbl_type,
502 p_trx_dist_tbl IN trx_dist_tbl_type,
503 p_trx_salescredits_tbl IN trx_salescredits_tbl_type,
504 p_trx_contingencies_tbl IN trx_contingencies_tbl_type,
505 x_customer_trx_id OUT NOCOPY NUMBER,
506 x_return_status OUT NOCOPY VARCHAR2,
507 x_msg_count OUT NOCOPY NUMBER,
508 x_msg_data OUT NOCOPY VARCHAR2);
509
510 -- bug 7194381
511 TYPE Context_Rec_Type IS RECORD
512 (
513 curr_precision fnd_currencies.precision%type,
514 curr_mau fnd_currencies.minimum_accountable_unit%type,
515 set_of_books_id gl_sets_of_books.set_of_books_id%type
516 := arp_global.set_of_books_id,
517 chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type
518 := arp_global.chart_of_accounts_id,
519 salesrep_required_flag ar_system_parameters.salesrep_required_flag%type
520 := arp_trx_global.system_info.system_parameters.salesrep_required_flag,
521 so_organization_id fnd_profile_option_values.profile_option_value%type
522 := oe_profile.value('SO_ORGANIZATION_ID'),
523 base_currency fnd_currencies.currency_code%type
524 := arp_trx_global.system_info.base_currency,
525 receivable_gl_date ra_cust_trx_line_gl_dist.gl_date%type,
526 code_combination_id_gain
527 ar_system_parameters.code_combination_id_gain%type
528 := arp_global.sysparam.code_combination_id_gain,
529 accounting_method ar_system_parameters.accounting_method%type
530 := arp_global.sysparam.accounting_method,
531 use_inv_accounting_for_cm
532 fnd_profile_option_values.profile_option_value%type
533 := arp_trx_global.profile_info.use_inv_acct_for_cm_flag,
534 allow_clearing_flag ra_batch_sources.create_clearing_flag%type,
535 validation_level VARCHAR2(10),
536 operation_mode VARCHAR2(1),
537 change_cust_on_trx VARCHAR2(1),
538 unique_seq_numbers VARCHAR2(1)
539 );
540
541 TYPE Line_Rec_Type IS RECORD
542 (
543 link_to_line_index BINARY_INTEGER,
544 rev_exist VARCHAR2(1) := 'N',
545 unearn_exist VARCHAR2(1) := 'N',
546 unbill_exist VARCHAR2(1) := 'N',
547 charge_exist VARCHAR2(1) := 'N',
548 delete_flag VARCHAR2(1) := 'N',
549 dist_amount NUMBER := 0,
550 gl_date DATE,
551 Accounting_rule_duration
552 ra_customer_trx_lines.Accounting_rule_duration%type,
553 Accounting_rule_id
554 ra_customer_trx_lines.Accounting_rule_id%type,
555 Attribute1
556 ra_customer_trx_lines.Attribute1%type,
557 Attribute10
558 ra_customer_trx_lines.Attribute10%type,
559 Attribute11
560 ra_customer_trx_lines.Attribute11%type,
561 Attribute12
562 ra_customer_trx_lines.Attribute12%type,
563 Attribute13
564 ra_customer_trx_lines.Attribute13%type,
565 Attribute14
566 ra_customer_trx_lines.Attribute14%type,
567 Attribute15
568 ra_customer_trx_lines.Attribute15%type,
572 ra_customer_trx_lines.Attribute3%type,
569 Attribute2
570 ra_customer_trx_lines.Attribute2%type,
571 Attribute3
573 Attribute4
574 ra_customer_trx_lines.Attribute4%type,
575 Attribute5
576 ra_customer_trx_lines.Attribute5%type,
577 Attribute6
578 ra_customer_trx_lines.Attribute6%type,
579 Attribute7
580 ra_customer_trx_lines.Attribute7%type,
581 Attribute8
582 ra_customer_trx_lines.Attribute8%type,
583 Attribute9
584 ra_customer_trx_lines.Attribute9%type,
585 Attribute_category
586 ra_customer_trx_lines.Attribute_category%type,
587 Autorule_complete_flag
588 ra_customer_trx_lines.Autorule_complete_flag%type,
589 Autorule_duration_processed
590 ra_customer_trx_lines.Autorule_duration_processed%type,
591 Autotax
592 ra_customer_trx_lines.Autotax%type,
593 Created_by
594 ra_customer_trx_lines.Created_by%type,
595 Creation_date
596 ra_customer_trx_lines.Creation_date%type,
597 Customer_trx_id
598 ra_customer_trx_lines.Customer_trx_id%type,
599 Customer_trx_line_id
600 ra_customer_trx_lines.Customer_trx_line_id%type,
601 Default_ussgl_transaction_code
602 ra_customer_trx_lines.Default_ussgl_transaction_code%type,
603 Default_ussgl_trx_code_context
604 ra_customer_trx_lines.Default_ussgl_trx_code_context%type,
605 Description
606 ra_customer_trx_lines.Description%type,
607 Extended_amount
608 ra_customer_trx_lines.Extended_amount%type,
609 Global_attribute1
610 ra_customer_trx_lines.Global_attribute1%type,
611 Global_attribute10
612 ra_customer_trx_lines.Global_attribute10%type,
613 Global_attribute11
614 ra_customer_trx_lines.Global_attribute11%type,
615 Global_attribute12
616 ra_customer_trx_lines.Global_attribute12%type,
617 Global_attribute13
618 ra_customer_trx_lines.Global_attribute13%type,
619 Global_attribute14
620 ra_customer_trx_lines.Global_attribute14%type,
621 Global_attribute15
622 ra_customer_trx_lines.Global_attribute15%type,
623 Global_attribute16
624 ra_customer_trx_lines.Global_attribute16%type,
625 Global_attribute17
626 ra_customer_trx_lines.Global_attribute17%type,
627 Global_attribute18
628 ra_customer_trx_lines.Global_attribute18%type,
629 Global_attribute19
630 ra_customer_trx_lines.Global_attribute19%type,
631 Global_attribute2
632 ra_customer_trx_lines.Global_attribute2%type,
633 Global_attribute20
634 ra_customer_trx_lines.Global_attribute20%type,
635 Global_attribute3
636 ra_customer_trx_lines.Global_attribute3%type,
637 Global_attribute4
638 ra_customer_trx_lines.Global_attribute4%type,
639 Global_attribute5
640 ra_customer_trx_lines.Global_attribute5%type,
641 Global_attribute6
642 ra_customer_trx_lines.Global_attribute6%type,
643 Global_attribute7
644 ra_customer_trx_lines.Global_attribute7%type,
645 Global_attribute8
646 ra_customer_trx_lines.Global_attribute8%type,
647 Global_attribute9
648 ra_customer_trx_lines.Global_attribute9%type,
649 Global_attribute_category
650 ra_customer_trx_lines.Global_attribute_category%type,
651 Initial_customer_trx_line_id
652 ra_customer_trx_lines.Initial_customer_trx_line_id%type,
653 Interface_line_attribute1
654 ra_customer_trx_lines.Interface_line_attribute1%type,
655 Interface_line_attribute10
656 ra_customer_trx_lines.Interface_line_attribute10%type,
657 Interface_line_attribute11
658 ra_customer_trx_lines.Interface_line_attribute11%type,
659 Interface_line_attribute12
660 ra_customer_trx_lines.Interface_line_attribute12%type,
661 Interface_line_attribute13
662 ra_customer_trx_lines.Interface_line_attribute13%type,
663 Interface_line_attribute14
664 ra_customer_trx_lines.Interface_line_attribute14%type,
665 Interface_line_attribute15
666 ra_customer_trx_lines.Interface_line_attribute15%type,
667 Interface_line_attribute2
668 ra_customer_trx_lines.Interface_line_attribute2%type,
669 Interface_line_attribute3
670 ra_customer_trx_lines.Interface_line_attribute3%type,
671 Interface_line_attribute4
672 ra_customer_trx_lines.Interface_line_attribute4%type,
673 Interface_line_attribute5
674 ra_customer_trx_lines.Interface_line_attribute5%type,
675 Interface_line_attribute6
676 ra_customer_trx_lines.Interface_line_attribute6%type,
677 Interface_line_attribute7
678 ra_customer_trx_lines.Interface_line_attribute7%type,
679 Interface_line_attribute8
680 ra_customer_trx_lines.Interface_line_attribute8%type,
681 Interface_line_attribute9
682 ra_customer_trx_lines.Interface_line_attribute9%type,
683 Interface_line_context
684 ra_customer_trx_lines.Interface_line_context%type,
685 Inventory_item_id
686 ra_customer_trx_lines.Inventory_item_id%type,
687 Item_context
688 ra_customer_trx_lines.Item_context%type,
689 Item_exception_rate_id
690 ra_customer_trx_lines.Item_exception_rate_id%type,
691 Last_period_to_credit
692 ra_customer_trx_lines.Last_period_to_credit%type,
693 Last_update_date
697 Last_updated_by
694 ra_customer_trx_lines.Last_update_date%type,
695 Last_update_login
696 ra_customer_trx_lines.Last_update_login%type,
698 ra_customer_trx_lines.Last_updated_by%type,
699 Line_number
700 ra_customer_trx_lines.Line_number%type,
701 Line_type
702 ra_customer_trx_lines.Line_type%type,
703 Link_to_cust_trx_line_id
704 ra_customer_trx_lines.Link_to_cust_trx_line_id%type,
705 Location_segment_id
706 ra_customer_trx_lines.Location_segment_id%type,
707 Memo_line_id
708 ra_customer_trx_lines.Memo_line_id%type,
709 Memo_line_type VARCHAR2(30),
710 Movement_id
711 ra_customer_trx_lines.Movement_id%type,
712 Org_id
713 ra_customer_trx_lines.Org_id%type,
714 Previous_customer_trx_id
715 ra_customer_trx_lines.Previous_customer_trx_id%type,
716 Previous_customer_trx_line_id
717 ra_customer_trx_lines.Previous_customer_trx_line_id%type,
718 Program_application_id
719 ra_customer_trx_lines.Program_application_id%type,
720 Program_id
721 ra_customer_trx_lines.Program_id%type,
722 Program_update_date
723 ra_customer_trx_lines.Program_update_date%type,
724 Quantity_credited
725 ra_customer_trx_lines.Quantity_credited%type,
726 Quantity_invoiced
727 ra_customer_trx_lines.Quantity_invoiced%type,
728 Quantity_ordered
729 ra_customer_trx_lines.Quantity_ordered%type,
730 Reason_code
731 ra_customer_trx_lines.Reason_code%type,
732 Request_id
733 ra_customer_trx_lines.Request_id%type,
734 Revenue_amount
735 ra_customer_trx_lines.Revenue_amount%type,
736 Rule_start_date
737 ra_customer_trx_lines.Rule_start_date%type,
738 Sales_order
739 ra_customer_trx_lines.Sales_order%type,
740 Sales_order_date
741 ra_customer_trx_lines.Sales_order_date%type,
742 Sales_order_line
743 ra_customer_trx_lines.Sales_order_line%type,
744 Sales_order_revision
745 ra_customer_trx_lines.Sales_order_revision%type,
746 Sales_order_source
747 ra_customer_trx_lines.Sales_order_source%type,
748 Sales_tax_id
749 ra_customer_trx_lines.Sales_tax_id%type,
750 Set_of_books_id
751 ra_customer_trx_lines.Set_of_books_id%type,
752 Tax_exempt_flag
753 ra_customer_trx_lines.Tax_exempt_flag%type,
754 Tax_exempt_number
755 ra_customer_trx_lines.Tax_exempt_number%type,
756 Tax_exempt_reason_code
757 ra_customer_trx_lines.Tax_exempt_reason_code%type,
758 Tax_exemption_id
759 ra_customer_trx_lines.Tax_exemption_id%type,
760 Tax_precedence
761 ra_customer_trx_lines.Tax_precedence%type,
762 Tax_rate
763 ra_customer_trx_lines.Tax_rate%type,
764 Tax_vendor_return_code
765 ra_customer_trx_lines.Tax_vendor_return_code%type,
766 Taxable_flag
767 ra_customer_trx_lines.Taxable_flag%type,
768 Unit_selling_price
769 ra_customer_trx_lines.Unit_selling_price%type,
770 Unit_standard_price
771 ra_customer_trx_lines.Unit_standard_price%type,
772 Uom_code
773 ra_customer_trx_lines.Uom_code%type,
774 Vat_tax_id
775 ra_customer_trx_lines.Vat_tax_id%type,
776 Wh_update_date
777 ra_customer_trx_lines.Wh_update_date%type,
778 Gross_unit_selling_price
779 ra_customer_trx_lines.gross_unit_selling_price%type,
780 Gross_extended_amount
781 ra_customer_trx_lines.gross_extended_amount%type,
782 amount_includes_tax_flag
783 ra_customer_trx_lines.amount_includes_tax_flag%type
784 );
785
786 TYPE Line_Tbl_Type IS TABLE OF Line_Rec_Type
787 INDEX BY BINARY_INTEGER;
788
789 TYPE Trx_Type_Tbl_Type IS TABLE OF ra_cust_trx_types%rowtype
790 INDEX BY BINARY_INTEGER;
791
792 G_lines_tbl Line_Tbl_Type;
793 Type_Cache_Tbl Trx_Type_Tbl_Type;
794
795
796 PROCEDURE Delete_Transaction(
797 p_api_name IN varchar2,
798 p_api_version IN number,
799 p_init_msg_list IN varchar2 := FND_API.G_FALSE,
800 p_commit IN varchar2 := FND_API.G_FALSE,
801 p_validation_level IN varchar2 := FND_API.G_VALID_LEVEL_FULL,
802 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
803 p_return_status OUT NOCOPY varchar2,
804 p_msg_count IN OUT NOCOPY NUMBER,
805 p_msg_data IN OUT NOCOPY varchar2,
806 p_errors IN OUT NOCOPY arp_trx_validate.Message_Tbl_Type);
807
808 -- bug 7194381 END
809
810
811 -- Bug12668756
812 PROCEDURE GET_TRXN_LINE_BALANCE(
813 p_api_version IN NUMBER,
814 p_customer_trx_id IN NUMBER,
815 p_interface_line_attribute6 IN ra_customer_trx_lines.interface_line_attribute6%type DEFAULT NULL,
816 x_amount_due_remaining OUT NOCOPY NUMBER,
817 x_acctd_amount_due_remaining OUT NOCOPY NUMBER,
818 x_return_status OUT NOCOPY VARCHAR2,
819 x_msg_count OUT NOCOPY NUMBER,
820 x_msg_data OUT NOCOPY VARCHAR2);
821
822 END AR_INVOICE_API_PUB;