[Home] [Help]
250: | |
251: +=======================================================================*/
252:
253: PROCEDURE create_header_cm (
254: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
255: p_batch_id IN ra_batches.batch_id%type,
256: p_trx_date IN ra_customer_trx.trx_date%type,
257: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
258: p_complete_flag IN ra_customer_trx.complete_flag%type,
252:
253: PROCEDURE create_header_cm (
254: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
255: p_batch_id IN ra_batches.batch_id%type,
256: p_trx_date IN ra_customer_trx.trx_date%type,
257: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
258: p_complete_flag IN ra_customer_trx.complete_flag%type,
259: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
260: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
254: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
255: p_batch_id IN ra_batches.batch_id%type,
256: p_trx_date IN ra_customer_trx.trx_date%type,
257: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
258: p_complete_flag IN ra_customer_trx.complete_flag%type,
259: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
260: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
261: p_currency_code IN fnd_currencies.currency_code%type,
262: p_exchange_date IN ra_customer_trx.exchange_date%type,
258: p_complete_flag IN ra_customer_trx.complete_flag%type,
259: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
260: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
261: p_currency_code IN fnd_currencies.currency_code%type,
262: p_exchange_date IN ra_customer_trx.exchange_date%type,
263: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
264: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
265: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
266: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
259: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
260: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
261: p_currency_code IN fnd_currencies.currency_code%type,
262: p_exchange_date IN ra_customer_trx.exchange_date%type,
263: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
264: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
265: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
266: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
267: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
260: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
261: p_currency_code IN fnd_currencies.currency_code%type,
262: p_exchange_date IN ra_customer_trx.exchange_date%type,
263: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
264: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
265: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
266: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
267: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
268: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
261: p_currency_code IN fnd_currencies.currency_code%type,
262: p_exchange_date IN ra_customer_trx.exchange_date%type,
263: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
264: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
265: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
266: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
267: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
268: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
269: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
262: p_exchange_date IN ra_customer_trx.exchange_date%type,
263: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
264: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
265: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
266: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
267: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
268: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
269: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
270: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
263: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
264: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
265: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
266: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
267: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
268: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
269: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
270: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
271: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
264: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
265: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
266: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
267: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
268: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
269: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
270: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
271: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
272: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
265: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
266: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
267: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
268: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
269: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
270: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
271: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
272: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
273: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
266: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
267: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
268: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
269: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
270: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
271: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
272: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
273: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
274: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
267: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
268: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
269: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
270: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
271: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
272: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
273: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
274: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
275: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
268: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
269: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
270: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
271: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
272: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
273: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
274: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
275: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
276: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
269: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
270: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
271: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
272: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
273: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
274: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
275: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
276: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
277: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
270: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
271: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
272: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
273: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
274: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
275: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
276: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
277: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
278: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
271: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
272: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
273: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
274: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
275: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
276: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
277: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
278: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
279: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
272: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
273: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
274: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
275: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
276: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
277: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
278: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
279: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
280: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
273: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
274: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
275: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
276: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
277: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
278: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
279: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
280: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
281: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
274: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
275: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
276: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
277: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
278: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
279: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
280: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
281: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
282: p_printing_option IN ra_customer_trx.printing_option%type,
275: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
276: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
277: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
278: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
279: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
280: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
281: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
282: p_printing_option IN ra_customer_trx.printing_option%type,
283: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
276: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
277: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
278: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
279: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
280: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
281: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
282: p_printing_option IN ra_customer_trx.printing_option%type,
283: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
284: p_printing_pending IN ra_customer_trx.printing_pending%type,
277: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
278: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
279: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
280: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
281: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
282: p_printing_option IN ra_customer_trx.printing_option%type,
283: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
284: p_printing_pending IN ra_customer_trx.printing_pending%type,
285: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
278: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
279: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
280: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
281: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
282: p_printing_option IN ra_customer_trx.printing_option%type,
283: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
284: p_printing_pending IN ra_customer_trx.printing_pending%type,
285: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
286: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
279: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
280: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
281: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
282: p_printing_option IN ra_customer_trx.printing_option%type,
283: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
284: p_printing_pending IN ra_customer_trx.printing_pending%type,
285: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
286: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
287: p_reason_code IN ra_customer_trx.reason_code%type,
280: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
281: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
282: p_printing_option IN ra_customer_trx.printing_option%type,
283: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
284: p_printing_pending IN ra_customer_trx.printing_pending%type,
285: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
286: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
287: p_reason_code IN ra_customer_trx.reason_code%type,
288: p_customer_reference IN ra_customer_trx.customer_reference%type,
281: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
282: p_printing_option IN ra_customer_trx.printing_option%type,
283: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
284: p_printing_pending IN ra_customer_trx.printing_pending%type,
285: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
286: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
287: p_reason_code IN ra_customer_trx.reason_code%type,
288: p_customer_reference IN ra_customer_trx.customer_reference%type,
289: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
282: p_printing_option IN ra_customer_trx.printing_option%type,
283: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
284: p_printing_pending IN ra_customer_trx.printing_pending%type,
285: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
286: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
287: p_reason_code IN ra_customer_trx.reason_code%type,
288: p_customer_reference IN ra_customer_trx.customer_reference%type,
289: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
290: p_internal_notes IN ra_customer_trx.internal_notes%type,
283: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
284: p_printing_pending IN ra_customer_trx.printing_pending%type,
285: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
286: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
287: p_reason_code IN ra_customer_trx.reason_code%type,
288: p_customer_reference IN ra_customer_trx.customer_reference%type,
289: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
290: p_internal_notes IN ra_customer_trx.internal_notes%type,
291: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
284: p_printing_pending IN ra_customer_trx.printing_pending%type,
285: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
286: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
287: p_reason_code IN ra_customer_trx.reason_code%type,
288: p_customer_reference IN ra_customer_trx.customer_reference%type,
289: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
290: p_internal_notes IN ra_customer_trx.internal_notes%type,
291: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
292: p_created_from IN ra_customer_trx.created_from%type,
285: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
286: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
287: p_reason_code IN ra_customer_trx.reason_code%type,
288: p_customer_reference IN ra_customer_trx.customer_reference%type,
289: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
290: p_internal_notes IN ra_customer_trx.internal_notes%type,
291: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
292: p_created_from IN ra_customer_trx.created_from%type,
293: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
286: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
287: p_reason_code IN ra_customer_trx.reason_code%type,
288: p_customer_reference IN ra_customer_trx.customer_reference%type,
289: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
290: p_internal_notes IN ra_customer_trx.internal_notes%type,
291: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
292: p_created_from IN ra_customer_trx.created_from%type,
293: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
287: p_reason_code IN ra_customer_trx.reason_code%type,
288: p_customer_reference IN ra_customer_trx.customer_reference%type,
289: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
290: p_internal_notes IN ra_customer_trx.internal_notes%type,
291: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
292: p_created_from IN ra_customer_trx.created_from%type,
293: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
288: p_customer_reference IN ra_customer_trx.customer_reference%type,
289: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
290: p_internal_notes IN ra_customer_trx.internal_notes%type,
291: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
292: p_created_from IN ra_customer_trx.created_from%type,
293: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
289: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
290: p_internal_notes IN ra_customer_trx.internal_notes%type,
291: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
292: p_created_from IN ra_customer_trx.created_from%type,
293: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
290: p_internal_notes IN ra_customer_trx.internal_notes%type,
291: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
292: p_created_from IN ra_customer_trx.created_from%type,
293: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
291: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
292: p_created_from IN ra_customer_trx.created_from%type,
293: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
292: p_created_from IN ra_customer_trx.created_from%type,
293: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
293: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
294: p_attribute_category IN ra_customer_trx.attribute_category%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
295: p_attribute1 IN ra_customer_trx.attribute1%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
296: p_attribute2 IN ra_customer_trx.attribute2%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
297: p_attribute3 IN ra_customer_trx.attribute3%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
298: p_attribute4 IN ra_customer_trx.attribute4%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
299: p_attribute5 IN ra_customer_trx.attribute5%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
300: p_attribute6 IN ra_customer_trx.attribute6%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
301: p_attribute7 IN ra_customer_trx.attribute7%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
302: p_attribute8 IN ra_customer_trx.attribute8%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
303: p_attribute9 IN ra_customer_trx.attribute9%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
311: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
304: p_attribute10 IN ra_customer_trx.attribute10%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
311: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
312: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
305: p_attribute11 IN ra_customer_trx.attribute11%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
311: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
312: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
313: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
306: p_attribute12 IN ra_customer_trx.attribute12%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
311: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
312: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
313: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
314: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
307: p_attribute13 IN ra_customer_trx.attribute13%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
311: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
312: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
313: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
314: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
315: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
308: p_attribute14 IN ra_customer_trx.attribute14%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
311: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
312: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
313: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
314: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
315: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
316: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
309: p_attribute15 IN ra_customer_trx.attribute15%type,
310: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
311: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
312: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
313: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
314: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
315: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
316: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
317: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
310: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
311: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
312: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
313: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
314: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
315: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
316: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
317: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
318: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
311: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
312: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
313: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
314: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
315: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
316: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
317: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
318: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
319: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
312: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
313: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
314: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
315: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
316: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
317: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
318: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
319: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
320: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
313: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
314: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
315: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
316: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
317: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
318: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
319: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
320: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
321: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
314: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
315: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
316: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
317: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
318: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
319: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
320: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
321: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
322: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
315: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
316: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
317: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
318: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
319: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
320: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
321: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
322: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
323: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
316: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
317: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
318: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
319: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
320: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
321: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
322: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
323: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
324: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
317: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
318: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
319: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
320: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
321: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
322: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
323: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
324: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
325: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
318: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
319: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
320: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
321: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
322: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
323: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
324: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
325: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
326: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
319: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
320: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
321: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
322: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
323: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
324: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
325: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
326: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
327: p_line_percent IN number,
320: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
321: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
322: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
323: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
324: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
325: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
326: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
327: p_line_percent IN number,
328: p_freight_percent IN number,
321: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
322: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
323: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
324: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
325: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
326: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
327: p_line_percent IN number,
328: p_freight_percent IN number,
329: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
322: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
323: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
324: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
325: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
326: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
327: p_line_percent IN number,
328: p_freight_percent IN number,
329: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
330: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
325: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
326: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
327: p_line_percent IN number,
328: p_freight_percent IN number,
329: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
330: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
331: p_compute_tax IN varchar2,
332: p_comments IN ra_customer_trx.comments%type,
333: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
326: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
327: p_line_percent IN number,
328: p_freight_percent IN number,
329: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
330: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
331: p_compute_tax IN varchar2,
332: p_comments IN ra_customer_trx.comments%type,
333: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
334: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
328: p_freight_percent IN number,
329: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
330: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
331: p_compute_tax IN varchar2,
332: p_comments IN ra_customer_trx.comments%type,
333: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
334: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
335: p_computed_tax_percent IN OUT NOCOPY number,
336: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
329: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
330: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
331: p_compute_tax IN varchar2,
332: p_comments IN ra_customer_trx.comments%type,
333: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
334: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
335: p_computed_tax_percent IN OUT NOCOPY number,
336: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
337: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
330: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
331: p_compute_tax IN varchar2,
332: p_comments IN ra_customer_trx.comments%type,
333: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
334: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
335: p_computed_tax_percent IN OUT NOCOPY number,
336: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
337: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
338: p_status OUT NOCOPY varchar2,
332: p_comments IN ra_customer_trx.comments%type,
333: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
334: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
335: p_computed_tax_percent IN OUT NOCOPY number,
336: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
337: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
338: p_status OUT NOCOPY varchar2,
339: p_purchase_order IN ra_customer_trx.purchase_order%type,
340: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
335: p_computed_tax_percent IN OUT NOCOPY number,
336: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
337: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
338: p_status OUT NOCOPY varchar2,
339: p_purchase_order IN ra_customer_trx.purchase_order%type,
340: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
341: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
342: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
343: /*4556000-4606558*/
336: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
337: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
338: p_status OUT NOCOPY varchar2,
339: p_purchase_order IN ra_customer_trx.purchase_order%type,
340: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
341: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
342: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
343: /*4556000-4606558*/
344: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
337: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
338: p_status OUT NOCOPY varchar2,
339: p_purchase_order IN ra_customer_trx.purchase_order%type,
340: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
341: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
342: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
343: /*4556000-4606558*/
344: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
345: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
338: p_status OUT NOCOPY varchar2,
339: p_purchase_order IN ra_customer_trx.purchase_order%type,
340: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
341: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
342: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
343: /*4556000-4606558*/
344: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
345: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
346: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
340: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
341: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
342: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
343: /*4556000-4606558*/
344: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
345: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
346: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
347: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
348: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
341: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
342: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
343: /*4556000-4606558*/
344: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
345: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
346: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
347: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
348: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
349: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
342: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
343: /*4556000-4606558*/
344: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
345: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
346: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
347: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
348: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
349: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
350: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
343: /*4556000-4606558*/
344: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
345: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
346: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
347: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
348: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
349: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
350: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
351: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
344: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
345: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
346: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
347: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
348: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
349: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
350: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
351: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
352: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
345: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
346: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
347: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
348: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
349: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
350: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
351: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
352: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
353: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
346: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
347: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
348: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
349: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
350: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
351: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
352: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
353: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
354: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
347: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
348: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
349: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
350: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
351: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
352: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
353: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
354: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
355: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
348: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
349: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
350: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
351: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
352: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
353: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
354: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
355: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
356: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
349: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
350: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
351: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
352: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
353: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
354: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
355: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
356: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
357: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
350: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
351: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
352: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
353: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
354: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
355: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
356: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
357: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
358: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
351: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
352: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
353: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
354: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
355: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
356: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
357: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
358: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
359: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
352: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
353: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
354: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
355: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
356: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
357: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
358: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
359: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
360: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
353: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
354: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
355: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
356: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
357: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
358: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
359: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
360: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
361: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
354: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
355: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
356: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
357: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
358: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
359: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
360: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
361: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
362: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
355: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
356: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
357: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
358: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
359: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
360: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
361: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
362: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
363: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
356: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
357: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
358: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
359: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
360: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
361: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
362: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
363: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
364: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
357: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
358: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
359: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
360: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
361: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
362: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
363: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
364: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
365: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
358: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
359: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
360: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
361: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
362: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
363: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
364: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
365: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
366: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
359: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
360: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
361: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
362: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
363: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
364: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
365: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
366: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
367: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
360: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
361: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
362: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
363: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
364: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
365: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
366: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
367: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
368: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
361: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
362: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
363: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
364: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
365: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
366: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
367: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
368: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
369: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
362: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
363: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
364: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
365: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
366: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
367: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
368: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
369: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
370: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
363: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
364: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
365: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
366: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
367: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
368: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
369: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
370: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
371: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
364: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
365: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
366: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
367: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
368: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
369: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
370: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
371: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
372: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
365: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
366: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
367: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
368: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
369: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
370: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
371: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
372: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
373: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
366: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
367: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
368: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
369: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
370: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
371: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
372: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
373: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
374: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
367: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
368: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
369: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
370: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
371: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
372: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
373: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
374: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
375: )
368: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
369: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
370: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
371: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
372: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
373: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
374: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
375: )
376: AS
369: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
370: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
371: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
372: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
373: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
374: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
375: )
376: AS
377:
370: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
371: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
372: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
373: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
374: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
375: )
376: AS
377:
378: l_cm_header ra_customer_trx%rowtype;
374: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
375: )
376: AS
377:
378: l_cm_header ra_customer_trx%rowtype;
379: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
380: l_compute_tax VARCHAR2(1);
381: l_line_orig number;
382: l_tax_orig number;
375: )
376: AS
377:
378: l_cm_header ra_customer_trx%rowtype;
379: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
380: l_compute_tax VARCHAR2(1);
381: l_line_orig number;
382: l_tax_orig number;
383: l_frt_orig number;
391: l_num_frt_lines number;
392: l_num_installments number;
393: l_pmt_exist_flag varchar2(1);
394: --
395: l_line_amount ra_customer_trx_lines.extended_amount%type ;
396: l_line_percent number ;
397: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
398: l_freight_percent number ;
399: l_computed_tax_percent number;
393: l_pmt_exist_flag varchar2(1);
394: --
395: l_line_amount ra_customer_trx_lines.extended_amount%type ;
396: l_line_percent number ;
397: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
398: l_freight_percent number ;
399: l_computed_tax_percent number;
400: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
401: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
396: l_line_percent number ;
397: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
398: l_freight_percent number ;
399: l_computed_tax_percent number;
400: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
401: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
402: l_credited_trx_cm_type_id ra_cust_trx_types.credit_memo_type_id%TYPE ;
403: l_credited_trx_open_rec_flag ra_cust_trx_types.accounting_affect_flag%TYPE ;
404: --
397: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
398: l_freight_percent number ;
399: l_computed_tax_percent number;
400: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
401: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
402: l_credited_trx_cm_type_id ra_cust_trx_types.credit_memo_type_id%TYPE ;
403: l_credited_trx_open_rec_flag ra_cust_trx_types.accounting_affect_flag%TYPE ;
404: --
405: l_default_bs_name varchar2(50);
699: --
700: BEGIN
701: SELECT *
702: INTO l_credited_trx_rec
703: FROM ra_customer_trx_cr_trx_v
704: WHERE customer_trx_id = p_prev_customer_trx_id ;
705: EXCEPTION
706: WHEN NO_DATA_FOUND THEN
707: --- TDEY 99/09/27 : Bug 913062
710: --- not exist in the system.
711: --- Proposed error message : AR_RAXTRX-1666 Your credit memo
712: --- transaction can only credit an invoice or a debit memo line
713: IF PG_DEBUG in ('Y', 'C') THEN
714: arp_util.debug('EXCEPTION: select from ra_customer_trx_cr_trx_v returns no data');
715: END IF;
716:
717: fnd_message.set_name( 'AR', 'AR_RAXTRX-1666');
718: l_message_name := 'AR_RAXTRX-1666' ;
1268: END ;
1269:
1270: /*
1271: Bug 2527439 : check if doc sequence is required/used
1272: Bug 3041195 : 1. ra_customer_trx_table was not getting updated with the
1273: doc seq no/value when copy_doc_number_flag = 'N'. Modified
1274: if ..else clause.
1275: 2. Document sequence Nos were getting lost if errors were
1276: encountered during completion checking. Re-arranged the
1313: ELSE
1314: l_cm_header.trx_number := p_trx_number;
1315: END IF;
1316:
1317: UPDATE ra_customer_trx
1318: SET doc_sequence_value = l_cm_header.doc_sequence_value,
1319: doc_sequence_id = l_cm_header.doc_sequence_id,
1320: trx_number = l_cm_header.trx_number,
1321: old_trx_number = l_cm_header.old_trx_number
1465: | |
1466: +=======================================================================*/
1467:
1468: PROCEDURE create_line_cm (
1469: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1470: p_batch_id IN ra_batches.batch_id%type,
1471: p_trx_date IN ra_customer_trx.trx_date%type,
1472: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1473: p_complete_flag IN ra_customer_trx.complete_flag%type,
1467:
1468: PROCEDURE create_line_cm (
1469: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1470: p_batch_id IN ra_batches.batch_id%type,
1471: p_trx_date IN ra_customer_trx.trx_date%type,
1472: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1473: p_complete_flag IN ra_customer_trx.complete_flag%type,
1474: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
1475: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1469: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1470: p_batch_id IN ra_batches.batch_id%type,
1471: p_trx_date IN ra_customer_trx.trx_date%type,
1472: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1473: p_complete_flag IN ra_customer_trx.complete_flag%type,
1474: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
1475: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1476: p_currency_code IN fnd_currencies.currency_code%type,
1477: p_exchange_date IN ra_customer_trx.exchange_date%type,
1473: p_complete_flag IN ra_customer_trx.complete_flag%type,
1474: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
1475: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1476: p_currency_code IN fnd_currencies.currency_code%type,
1477: p_exchange_date IN ra_customer_trx.exchange_date%type,
1478: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1479: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1480: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1481: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1474: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
1475: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1476: p_currency_code IN fnd_currencies.currency_code%type,
1477: p_exchange_date IN ra_customer_trx.exchange_date%type,
1478: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1479: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1480: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1481: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1482: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1475: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1476: p_currency_code IN fnd_currencies.currency_code%type,
1477: p_exchange_date IN ra_customer_trx.exchange_date%type,
1478: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1479: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1480: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1481: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1482: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1483: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1476: p_currency_code IN fnd_currencies.currency_code%type,
1477: p_exchange_date IN ra_customer_trx.exchange_date%type,
1478: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1479: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1480: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1481: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1482: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1483: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1484: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1477: p_exchange_date IN ra_customer_trx.exchange_date%type,
1478: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1479: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1480: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1481: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1482: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1483: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1484: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1485: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1478: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1479: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1480: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1481: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1482: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1483: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1484: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1485: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1486: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1479: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1480: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1481: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1482: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1483: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1484: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1485: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1486: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1487: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1480: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1481: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1482: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1483: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1484: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1485: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1486: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1487: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1488: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1481: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1482: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1483: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1484: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1485: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1486: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1487: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1488: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1489: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1482: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1483: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1484: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1485: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1486: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1487: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1488: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1489: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1490: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1483: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1484: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1485: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1486: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1487: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1488: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1489: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1490: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1491: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1484: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1485: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1486: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1487: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1488: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1489: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1490: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1491: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1492: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1485: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1486: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1487: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1488: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1489: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1490: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1491: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1492: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1493: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1486: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1487: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1488: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1489: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1490: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1491: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1492: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1493: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1494: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1487: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1488: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1489: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1490: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1491: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1492: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1493: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1494: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1495: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1488: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1489: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1490: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1491: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1492: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1493: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1494: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1495: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1496: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1489: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1490: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1491: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1492: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1493: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1494: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1495: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1496: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1497: p_printing_option IN ra_customer_trx.printing_option%type,
1490: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1491: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1492: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1493: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1494: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1495: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1496: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1497: p_printing_option IN ra_customer_trx.printing_option%type,
1498: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1491: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1492: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1493: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1494: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1495: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1496: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1497: p_printing_option IN ra_customer_trx.printing_option%type,
1498: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1499: p_printing_pending IN ra_customer_trx.printing_pending%type,
1492: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1493: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1494: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1495: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1496: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1497: p_printing_option IN ra_customer_trx.printing_option%type,
1498: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1499: p_printing_pending IN ra_customer_trx.printing_pending%type,
1500: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1493: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1494: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1495: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1496: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1497: p_printing_option IN ra_customer_trx.printing_option%type,
1498: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1499: p_printing_pending IN ra_customer_trx.printing_pending%type,
1500: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1501: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1494: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1495: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1496: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1497: p_printing_option IN ra_customer_trx.printing_option%type,
1498: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1499: p_printing_pending IN ra_customer_trx.printing_pending%type,
1500: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1501: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1502: p_reason_code IN ra_customer_trx.reason_code%type,
1495: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1496: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1497: p_printing_option IN ra_customer_trx.printing_option%type,
1498: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1499: p_printing_pending IN ra_customer_trx.printing_pending%type,
1500: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1501: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1502: p_reason_code IN ra_customer_trx.reason_code%type,
1503: p_customer_reference IN ra_customer_trx.customer_reference%type,
1496: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1497: p_printing_option IN ra_customer_trx.printing_option%type,
1498: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1499: p_printing_pending IN ra_customer_trx.printing_pending%type,
1500: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1501: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1502: p_reason_code IN ra_customer_trx.reason_code%type,
1503: p_customer_reference IN ra_customer_trx.customer_reference%type,
1504: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1497: p_printing_option IN ra_customer_trx.printing_option%type,
1498: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1499: p_printing_pending IN ra_customer_trx.printing_pending%type,
1500: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1501: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1502: p_reason_code IN ra_customer_trx.reason_code%type,
1503: p_customer_reference IN ra_customer_trx.customer_reference%type,
1504: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1505: p_internal_notes IN ra_customer_trx.internal_notes%type,
1498: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1499: p_printing_pending IN ra_customer_trx.printing_pending%type,
1500: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1501: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1502: p_reason_code IN ra_customer_trx.reason_code%type,
1503: p_customer_reference IN ra_customer_trx.customer_reference%type,
1504: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1505: p_internal_notes IN ra_customer_trx.internal_notes%type,
1506: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1499: p_printing_pending IN ra_customer_trx.printing_pending%type,
1500: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1501: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1502: p_reason_code IN ra_customer_trx.reason_code%type,
1503: p_customer_reference IN ra_customer_trx.customer_reference%type,
1504: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1505: p_internal_notes IN ra_customer_trx.internal_notes%type,
1506: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1507: p_created_from IN ra_customer_trx.created_from%type,
1500: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1501: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1502: p_reason_code IN ra_customer_trx.reason_code%type,
1503: p_customer_reference IN ra_customer_trx.customer_reference%type,
1504: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1505: p_internal_notes IN ra_customer_trx.internal_notes%type,
1506: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1507: p_created_from IN ra_customer_trx.created_from%type,
1508: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1501: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1502: p_reason_code IN ra_customer_trx.reason_code%type,
1503: p_customer_reference IN ra_customer_trx.customer_reference%type,
1504: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1505: p_internal_notes IN ra_customer_trx.internal_notes%type,
1506: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1507: p_created_from IN ra_customer_trx.created_from%type,
1508: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1509: p_attribute_category IN ra_customer_trx.attribute_category%type,
1502: p_reason_code IN ra_customer_trx.reason_code%type,
1503: p_customer_reference IN ra_customer_trx.customer_reference%type,
1504: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1505: p_internal_notes IN ra_customer_trx.internal_notes%type,
1506: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1507: p_created_from IN ra_customer_trx.created_from%type,
1508: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1509: p_attribute_category IN ra_customer_trx.attribute_category%type,
1510: p_attribute1 IN ra_customer_trx.attribute1%type,
1503: p_customer_reference IN ra_customer_trx.customer_reference%type,
1504: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1505: p_internal_notes IN ra_customer_trx.internal_notes%type,
1506: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1507: p_created_from IN ra_customer_trx.created_from%type,
1508: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1509: p_attribute_category IN ra_customer_trx.attribute_category%type,
1510: p_attribute1 IN ra_customer_trx.attribute1%type,
1511: p_attribute2 IN ra_customer_trx.attribute2%type,
1504: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1505: p_internal_notes IN ra_customer_trx.internal_notes%type,
1506: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1507: p_created_from IN ra_customer_trx.created_from%type,
1508: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1509: p_attribute_category IN ra_customer_trx.attribute_category%type,
1510: p_attribute1 IN ra_customer_trx.attribute1%type,
1511: p_attribute2 IN ra_customer_trx.attribute2%type,
1512: p_attribute3 IN ra_customer_trx.attribute3%type,
1505: p_internal_notes IN ra_customer_trx.internal_notes%type,
1506: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1507: p_created_from IN ra_customer_trx.created_from%type,
1508: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1509: p_attribute_category IN ra_customer_trx.attribute_category%type,
1510: p_attribute1 IN ra_customer_trx.attribute1%type,
1511: p_attribute2 IN ra_customer_trx.attribute2%type,
1512: p_attribute3 IN ra_customer_trx.attribute3%type,
1513: p_attribute4 IN ra_customer_trx.attribute4%type,
1506: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1507: p_created_from IN ra_customer_trx.created_from%type,
1508: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1509: p_attribute_category IN ra_customer_trx.attribute_category%type,
1510: p_attribute1 IN ra_customer_trx.attribute1%type,
1511: p_attribute2 IN ra_customer_trx.attribute2%type,
1512: p_attribute3 IN ra_customer_trx.attribute3%type,
1513: p_attribute4 IN ra_customer_trx.attribute4%type,
1514: p_attribute5 IN ra_customer_trx.attribute5%type,
1507: p_created_from IN ra_customer_trx.created_from%type,
1508: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1509: p_attribute_category IN ra_customer_trx.attribute_category%type,
1510: p_attribute1 IN ra_customer_trx.attribute1%type,
1511: p_attribute2 IN ra_customer_trx.attribute2%type,
1512: p_attribute3 IN ra_customer_trx.attribute3%type,
1513: p_attribute4 IN ra_customer_trx.attribute4%type,
1514: p_attribute5 IN ra_customer_trx.attribute5%type,
1515: p_attribute6 IN ra_customer_trx.attribute6%type,
1508: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1509: p_attribute_category IN ra_customer_trx.attribute_category%type,
1510: p_attribute1 IN ra_customer_trx.attribute1%type,
1511: p_attribute2 IN ra_customer_trx.attribute2%type,
1512: p_attribute3 IN ra_customer_trx.attribute3%type,
1513: p_attribute4 IN ra_customer_trx.attribute4%type,
1514: p_attribute5 IN ra_customer_trx.attribute5%type,
1515: p_attribute6 IN ra_customer_trx.attribute6%type,
1516: p_attribute7 IN ra_customer_trx.attribute7%type,
1509: p_attribute_category IN ra_customer_trx.attribute_category%type,
1510: p_attribute1 IN ra_customer_trx.attribute1%type,
1511: p_attribute2 IN ra_customer_trx.attribute2%type,
1512: p_attribute3 IN ra_customer_trx.attribute3%type,
1513: p_attribute4 IN ra_customer_trx.attribute4%type,
1514: p_attribute5 IN ra_customer_trx.attribute5%type,
1515: p_attribute6 IN ra_customer_trx.attribute6%type,
1516: p_attribute7 IN ra_customer_trx.attribute7%type,
1517: p_attribute8 IN ra_customer_trx.attribute8%type,
1510: p_attribute1 IN ra_customer_trx.attribute1%type,
1511: p_attribute2 IN ra_customer_trx.attribute2%type,
1512: p_attribute3 IN ra_customer_trx.attribute3%type,
1513: p_attribute4 IN ra_customer_trx.attribute4%type,
1514: p_attribute5 IN ra_customer_trx.attribute5%type,
1515: p_attribute6 IN ra_customer_trx.attribute6%type,
1516: p_attribute7 IN ra_customer_trx.attribute7%type,
1517: p_attribute8 IN ra_customer_trx.attribute8%type,
1518: p_attribute9 IN ra_customer_trx.attribute9%type,
1511: p_attribute2 IN ra_customer_trx.attribute2%type,
1512: p_attribute3 IN ra_customer_trx.attribute3%type,
1513: p_attribute4 IN ra_customer_trx.attribute4%type,
1514: p_attribute5 IN ra_customer_trx.attribute5%type,
1515: p_attribute6 IN ra_customer_trx.attribute6%type,
1516: p_attribute7 IN ra_customer_trx.attribute7%type,
1517: p_attribute8 IN ra_customer_trx.attribute8%type,
1518: p_attribute9 IN ra_customer_trx.attribute9%type,
1519: p_attribute10 IN ra_customer_trx.attribute10%type,
1512: p_attribute3 IN ra_customer_trx.attribute3%type,
1513: p_attribute4 IN ra_customer_trx.attribute4%type,
1514: p_attribute5 IN ra_customer_trx.attribute5%type,
1515: p_attribute6 IN ra_customer_trx.attribute6%type,
1516: p_attribute7 IN ra_customer_trx.attribute7%type,
1517: p_attribute8 IN ra_customer_trx.attribute8%type,
1518: p_attribute9 IN ra_customer_trx.attribute9%type,
1519: p_attribute10 IN ra_customer_trx.attribute10%type,
1520: p_attribute11 IN ra_customer_trx.attribute11%type,
1513: p_attribute4 IN ra_customer_trx.attribute4%type,
1514: p_attribute5 IN ra_customer_trx.attribute5%type,
1515: p_attribute6 IN ra_customer_trx.attribute6%type,
1516: p_attribute7 IN ra_customer_trx.attribute7%type,
1517: p_attribute8 IN ra_customer_trx.attribute8%type,
1518: p_attribute9 IN ra_customer_trx.attribute9%type,
1519: p_attribute10 IN ra_customer_trx.attribute10%type,
1520: p_attribute11 IN ra_customer_trx.attribute11%type,
1521: p_attribute12 IN ra_customer_trx.attribute12%type,
1514: p_attribute5 IN ra_customer_trx.attribute5%type,
1515: p_attribute6 IN ra_customer_trx.attribute6%type,
1516: p_attribute7 IN ra_customer_trx.attribute7%type,
1517: p_attribute8 IN ra_customer_trx.attribute8%type,
1518: p_attribute9 IN ra_customer_trx.attribute9%type,
1519: p_attribute10 IN ra_customer_trx.attribute10%type,
1520: p_attribute11 IN ra_customer_trx.attribute11%type,
1521: p_attribute12 IN ra_customer_trx.attribute12%type,
1522: p_attribute13 IN ra_customer_trx.attribute13%type,
1515: p_attribute6 IN ra_customer_trx.attribute6%type,
1516: p_attribute7 IN ra_customer_trx.attribute7%type,
1517: p_attribute8 IN ra_customer_trx.attribute8%type,
1518: p_attribute9 IN ra_customer_trx.attribute9%type,
1519: p_attribute10 IN ra_customer_trx.attribute10%type,
1520: p_attribute11 IN ra_customer_trx.attribute11%type,
1521: p_attribute12 IN ra_customer_trx.attribute12%type,
1522: p_attribute13 IN ra_customer_trx.attribute13%type,
1523: p_attribute14 IN ra_customer_trx.attribute14%type,
1516: p_attribute7 IN ra_customer_trx.attribute7%type,
1517: p_attribute8 IN ra_customer_trx.attribute8%type,
1518: p_attribute9 IN ra_customer_trx.attribute9%type,
1519: p_attribute10 IN ra_customer_trx.attribute10%type,
1520: p_attribute11 IN ra_customer_trx.attribute11%type,
1521: p_attribute12 IN ra_customer_trx.attribute12%type,
1522: p_attribute13 IN ra_customer_trx.attribute13%type,
1523: p_attribute14 IN ra_customer_trx.attribute14%type,
1524: p_attribute15 IN ra_customer_trx.attribute15%type,
1517: p_attribute8 IN ra_customer_trx.attribute8%type,
1518: p_attribute9 IN ra_customer_trx.attribute9%type,
1519: p_attribute10 IN ra_customer_trx.attribute10%type,
1520: p_attribute11 IN ra_customer_trx.attribute11%type,
1521: p_attribute12 IN ra_customer_trx.attribute12%type,
1522: p_attribute13 IN ra_customer_trx.attribute13%type,
1523: p_attribute14 IN ra_customer_trx.attribute14%type,
1524: p_attribute15 IN ra_customer_trx.attribute15%type,
1525: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1518: p_attribute9 IN ra_customer_trx.attribute9%type,
1519: p_attribute10 IN ra_customer_trx.attribute10%type,
1520: p_attribute11 IN ra_customer_trx.attribute11%type,
1521: p_attribute12 IN ra_customer_trx.attribute12%type,
1522: p_attribute13 IN ra_customer_trx.attribute13%type,
1523: p_attribute14 IN ra_customer_trx.attribute14%type,
1524: p_attribute15 IN ra_customer_trx.attribute15%type,
1525: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1526: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1519: p_attribute10 IN ra_customer_trx.attribute10%type,
1520: p_attribute11 IN ra_customer_trx.attribute11%type,
1521: p_attribute12 IN ra_customer_trx.attribute12%type,
1522: p_attribute13 IN ra_customer_trx.attribute13%type,
1523: p_attribute14 IN ra_customer_trx.attribute14%type,
1524: p_attribute15 IN ra_customer_trx.attribute15%type,
1525: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1526: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1527: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1520: p_attribute11 IN ra_customer_trx.attribute11%type,
1521: p_attribute12 IN ra_customer_trx.attribute12%type,
1522: p_attribute13 IN ra_customer_trx.attribute13%type,
1523: p_attribute14 IN ra_customer_trx.attribute14%type,
1524: p_attribute15 IN ra_customer_trx.attribute15%type,
1525: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1526: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1527: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1528: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1521: p_attribute12 IN ra_customer_trx.attribute12%type,
1522: p_attribute13 IN ra_customer_trx.attribute13%type,
1523: p_attribute14 IN ra_customer_trx.attribute14%type,
1524: p_attribute15 IN ra_customer_trx.attribute15%type,
1525: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1526: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1527: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1528: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1529: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1522: p_attribute13 IN ra_customer_trx.attribute13%type,
1523: p_attribute14 IN ra_customer_trx.attribute14%type,
1524: p_attribute15 IN ra_customer_trx.attribute15%type,
1525: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1526: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1527: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1528: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1529: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1530: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1523: p_attribute14 IN ra_customer_trx.attribute14%type,
1524: p_attribute15 IN ra_customer_trx.attribute15%type,
1525: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1526: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1527: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1528: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1529: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1530: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1531: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1524: p_attribute15 IN ra_customer_trx.attribute15%type,
1525: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1526: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1527: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1528: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1529: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1530: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1531: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1532: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1525: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1526: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1527: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1528: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1529: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1530: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1531: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1532: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1533: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1526: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1527: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1528: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1529: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1530: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1531: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1532: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1533: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1534: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1527: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1528: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1529: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1530: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1531: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1532: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1533: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1534: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1535: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1528: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1529: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1530: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1531: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1532: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1533: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1534: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1535: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1536: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1529: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1530: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1531: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1532: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1533: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1534: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1535: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1536: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1537: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1530: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1531: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1532: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1533: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1534: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1535: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1536: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1537: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1538: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1531: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1532: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1533: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1534: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1535: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1536: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1537: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1538: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1539: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1532: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1533: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1534: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1535: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1536: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1537: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1538: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1539: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1540: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1533: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1534: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1535: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1536: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1537: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1538: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1539: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1540: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1541: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1534: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1535: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1536: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1537: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1538: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1539: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1540: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1541: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1542: p_line_percent IN number,
1535: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1536: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1537: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1538: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1539: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1540: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1541: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1542: p_line_percent IN number,
1543: p_freight_percent IN number,
1536: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1537: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1538: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1539: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1540: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1541: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1542: p_line_percent IN number,
1543: p_freight_percent IN number,
1544: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1537: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1538: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1539: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1540: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1541: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1542: p_line_percent IN number,
1543: p_freight_percent IN number,
1544: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1545: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1540: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1541: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1542: p_line_percent IN number,
1543: p_freight_percent IN number,
1544: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1545: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1546: p_compute_tax IN varchar2,
1547: p_comments IN ra_customer_trx.comments%type,
1548: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1541: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1542: p_line_percent IN number,
1543: p_freight_percent IN number,
1544: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1545: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1546: p_compute_tax IN varchar2,
1547: p_comments IN ra_customer_trx.comments%type,
1548: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1549: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1543: p_freight_percent IN number,
1544: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1545: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1546: p_compute_tax IN varchar2,
1547: p_comments IN ra_customer_trx.comments%type,
1548: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1549: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1550: p_computed_tax_percent IN OUT NOCOPY number,
1551: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1544: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1545: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1546: p_compute_tax IN varchar2,
1547: p_comments IN ra_customer_trx.comments%type,
1548: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1549: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1550: p_computed_tax_percent IN OUT NOCOPY number,
1551: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1552: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1545: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1546: p_compute_tax IN varchar2,
1547: p_comments IN ra_customer_trx.comments%type,
1548: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1549: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1550: p_computed_tax_percent IN OUT NOCOPY number,
1551: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1552: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1553: p_status OUT NOCOPY varchar2,
1547: p_comments IN ra_customer_trx.comments%type,
1548: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1549: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1550: p_computed_tax_percent IN OUT NOCOPY number,
1551: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1552: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1553: p_status OUT NOCOPY varchar2,
1554: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1555: p_purchase_order IN ra_customer_trx.purchase_order%type,
1551: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1552: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1553: p_status OUT NOCOPY varchar2,
1554: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1555: p_purchase_order IN ra_customer_trx.purchase_order%type,
1556: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
1557: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1558: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1559: /*4556000-4606558*/
1552: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1553: p_status OUT NOCOPY varchar2,
1554: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1555: p_purchase_order IN ra_customer_trx.purchase_order%type,
1556: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
1557: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1558: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1559: /*4556000-4606558*/
1560: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1553: p_status OUT NOCOPY varchar2,
1554: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1555: p_purchase_order IN ra_customer_trx.purchase_order%type,
1556: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
1557: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1558: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1559: /*4556000-4606558*/
1560: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1561: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1554: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1555: p_purchase_order IN ra_customer_trx.purchase_order%type,
1556: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
1557: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1558: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1559: /*4556000-4606558*/
1560: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1561: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1562: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1556: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
1557: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1558: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1559: /*4556000-4606558*/
1560: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1561: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1562: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1563: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1564: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1557: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1558: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1559: /*4556000-4606558*/
1560: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1561: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1562: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1563: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1564: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1565: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1558: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1559: /*4556000-4606558*/
1560: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1561: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1562: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1563: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1564: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1565: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1566: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1559: /*4556000-4606558*/
1560: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1561: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1562: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1563: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1564: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1565: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1566: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1567: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1560: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1561: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1562: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1563: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1564: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1565: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1566: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1567: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1568: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1561: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1562: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1563: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1564: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1565: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1566: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1567: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1568: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1569: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1562: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1563: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1564: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1565: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1566: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1567: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1568: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1569: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1570: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1563: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1564: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1565: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1566: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1567: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1568: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1569: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1570: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1571: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1564: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1565: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1566: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1567: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1568: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1569: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1570: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1571: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1572: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1565: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1566: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1567: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1568: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1569: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1570: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1571: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1572: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1573: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1566: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1567: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1568: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1569: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1570: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1571: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1572: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1573: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1574: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1567: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1568: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1569: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1570: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1571: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1572: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1573: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1574: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1575: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1568: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1569: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1570: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1571: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1572: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1573: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1574: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1575: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1576: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1569: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1570: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1571: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1572: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1573: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1574: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1575: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1576: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1577: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1570: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1571: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1572: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1573: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1574: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1575: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1576: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1577: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1578: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1571: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1572: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1573: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1574: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1575: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1576: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1577: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1578: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1579: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1572: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1573: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1574: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1575: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1576: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1577: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1578: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1579: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1580: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1573: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1574: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1575: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1576: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1577: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1578: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1579: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1580: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1581: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1574: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1575: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1576: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1577: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1578: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1579: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1580: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1581: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1582: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1575: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1576: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1577: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1578: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1579: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1580: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1581: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1582: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1583: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1576: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1577: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1578: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1579: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1580: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1581: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1582: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1583: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1584: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1577: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1578: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1579: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1580: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1581: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1582: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1583: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1584: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1585: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1578: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1579: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1580: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1581: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1582: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1583: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1584: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1585: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1586: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1579: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1580: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1581: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1582: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1583: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1584: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1585: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1586: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1587: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1580: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1581: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1582: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1583: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1584: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1585: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1586: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1587: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1588: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1581: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1582: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1583: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1584: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1585: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1586: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1587: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1588: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1589: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1582: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1583: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1584: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1585: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1586: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1587: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1588: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1589: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1590: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
1583: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1584: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1585: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1586: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1587: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1588: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1589: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1590: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
1591: )
1584: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1585: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1586: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1587: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1588: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1589: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1590: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
1591: )
1592: AS
1585: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1586: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1587: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1588: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1589: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1590: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
1591: )
1592: AS
1593:
1586: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1587: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1588: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1589: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1590: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
1591: )
1592: AS
1593:
1594: --
1597: p_do_salescredits VARCHAR2(1) := 'N';
1598: p_do_autoaccounting VARCHAR2(1) := 'N';
1599: p_commit VARCHAR2(1) := FND_API.G_TRUE;
1600: l_compute_tax VARCHAR2(1);
1601: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1602: l_temp varchar2(30);
1603: l_start_time varchar2(100);
1604: l_header_time varchar2(100);
1605: l_line_time varchar2(100);
1615: l_return_status varchar2(1);
1616: l_msg_count NUMBER;
1617: l_msg_data varchar2(4000);
1618: l_errors arp_trx_validate.Message_Tbl_Type;
1619: l_new_customer_trx_id ra_customer_trx.customer_trx_id%type;
1620: l_cursor INTEGER;
1621: i BINARY_INTEGER := 0;
1622: n BINARY_INTEGER := 0;
1623: l_ignore INTEGER;
1627: l_prev_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type ;
1628:
1629:
1630: l_rec_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1631: l_trx_rec ra_customer_trx_cr_trx_v%rowtype;
1632: l_batch_rec ra_batches%rowtype;
1633:
1634: l_cr CONSTANT char(1) := '
1635: ';
1634: l_cr CONSTANT char(1) := '
1635: ';
1636: j number;
1637:
1638: ct_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1639: ct_quantity_invoiced ra_customer_trx_lines.quantity_invoiced%TYPE;
1640: ct_extended_amount ra_customer_trx_lines.extended_amount%TYPE;
1641: ----
1642: l_dist_index NUMBER ;
1635: ';
1636: j number;
1637:
1638: ct_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1639: ct_quantity_invoiced ra_customer_trx_lines.quantity_invoiced%TYPE;
1640: ct_extended_amount ra_customer_trx_lines.extended_amount%TYPE;
1641: ----
1642: l_dist_index NUMBER ;
1643: l_lines_index NUMBER ;
1636: j number;
1637:
1638: ct_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1639: ct_quantity_invoiced ra_customer_trx_lines.quantity_invoiced%TYPE;
1640: ct_extended_amount ra_customer_trx_lines.extended_amount%TYPE;
1641: ----
1642: l_dist_index NUMBER ;
1643: l_lines_index NUMBER ;
1644: l_credit_memo_type_id ra_cust_trx_types.credit_memo_type_id%type;
1645: l_line_matched NUMBER := 0;
1646: l_lines_to_delete_index NUMBER := 1;
1647: TYPE lines_to_delete_rec IS RECORD
1648: (line_index BINARY_INTEGER,
1649: line_type ra_customer_trx_lines.Line_type%type
1650: );
1651: TYPE lines_to_delete_tbl_type IS TABLE OF lines_to_delete_rec INDEX BY BINARY_INTEGER;
1652: l_lines_to_delete_tbl lines_to_delete_tbl_type;
1653:
1659: e_unexpected_error EXCEPTION;
1660: l_message_name VARCHAR2(255);
1661: l_debug_point NUMBER;
1662:
1663: l_cm_header ra_customer_trx%rowtype;
1664:
1665: l_line_amount ra_customer_trx_lines.extended_amount%type ;
1666: l_line_percent number ;
1667: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1661: l_debug_point NUMBER;
1662:
1663: l_cm_header ra_customer_trx%rowtype;
1664:
1665: l_line_amount ra_customer_trx_lines.extended_amount%type ;
1666: l_line_percent number ;
1667: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1668: l_freight_percent number ;
1669: l_computed_tax_percent number;
1663: l_cm_header ra_customer_trx%rowtype;
1664:
1665: l_line_amount ra_customer_trx_lines.extended_amount%type ;
1666: l_line_percent number ;
1667: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1668: l_freight_percent number ;
1669: l_computed_tax_percent number;
1670: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
1671:
1666: l_line_percent number ;
1667: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1668: l_freight_percent number ;
1669: l_computed_tax_percent number;
1670: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
1671:
1672: l_default_bs_name varchar2(50);
1673: l_bs_type varchar2(10);
1674: l_copy_doc_number_flag varchar2(1);
1694: p_form_version number := NULL;
1695:
1696: l_auto_trx_numbering_flag varchar2(1);
1697:
1698: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
1699: --
1700: l_line_orig number;
1701: l_tax_orig number;
1702: l_frt_orig number;
1712: l_pmt_exist_flag varchar2(1);
1713: --
1714: l_credited_trx_line_tbl arw_cm_cover.credit_lines_table_type;
1715:
1716: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1717:
1718: l_err_mesg VARCHAR2(2000);
1719: l_ue_message VARCHAR2(2000);
1720:
1877: --
1878: BEGIN
1879: SELECT *
1880: INTO l_credited_trx_rec
1881: FROM ra_customer_trx_cr_trx_v
1882: WHERE customer_trx_id = p_prev_customer_trx_id ;
1883: EXCEPTION
1884: WHEN NO_DATA_FOUND THEN
1885: --- TDEY 99/09/27 : Bug 913062
2624:
2625:
2626: /*
2627: Bug 2527439 : check if doc sequence is required/used
2628: Bug 3041195 : 1. ra_customer_trx_table was not getting updated with the
2629: doc seq no/value when copy_doc_number_flag = 'N'. Modified
2630: if ..else clause.
2631: 2. Document sequence Nos were getting lost if errors were
2632: encountered during completion checking. Re-arranged the
2669: ELSE
2670: l_cm_header.trx_number := p_trx_number;
2671: END IF;
2672:
2673: UPDATE ra_customer_trx
2674: SET doc_sequence_value = l_cm_header.doc_sequence_value,
2675: doc_sequence_id = l_cm_header.doc_sequence_id,
2676: trx_number = l_cm_header.trx_number,
2677: old_trx_number = l_cm_header.old_trx_number