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: p_start_date_commitment IN ra_customer_trx.start_date_commitment%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: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type default NULL
376: )
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: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type default NULL
376: )
377: AS
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: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type default NULL
376: )
377: AS
378:
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: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type default NULL
376: )
377: AS
378:
379: l_cm_header ra_customer_trx%rowtype;
375: p_start_date_commitment IN ra_customer_trx.start_date_commitment%type default NULL
376: )
377: AS
378:
379: l_cm_header ra_customer_trx%rowtype;
380: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
381: l_compute_tax VARCHAR2(1);
382: l_line_orig number;
383: l_tax_orig number;
376: )
377: AS
378:
379: l_cm_header ra_customer_trx%rowtype;
380: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
381: l_compute_tax VARCHAR2(1);
382: l_line_orig number;
383: l_tax_orig number;
384: l_frt_orig number;
392: l_num_frt_lines number;
393: l_num_installments number;
394: l_pmt_exist_flag varchar2(1);
395: --
396: l_line_amount ra_customer_trx_lines.extended_amount%type ;
397: l_line_percent number ;
398: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
399: l_freight_percent number ;
400: l_computed_tax_percent number;
394: l_pmt_exist_flag varchar2(1);
395: --
396: l_line_amount ra_customer_trx_lines.extended_amount%type ;
397: l_line_percent number ;
398: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
399: l_freight_percent number ;
400: l_computed_tax_percent number;
401: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
402: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
397: l_line_percent number ;
398: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
399: l_freight_percent number ;
400: l_computed_tax_percent number;
401: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
402: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
403: l_credited_trx_cm_type_id ra_cust_trx_types.credit_memo_type_id%TYPE ;
404: l_credited_trx_open_rec_flag ra_cust_trx_types.accounting_affect_flag%TYPE ;
405: --
398: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
399: l_freight_percent number ;
400: l_computed_tax_percent number;
401: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
402: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
403: l_credited_trx_cm_type_id ra_cust_trx_types.credit_memo_type_id%TYPE ;
404: l_credited_trx_open_rec_flag ra_cust_trx_types.accounting_affect_flag%TYPE ;
405: --
406: l_default_bs_name varchar2(50);
709: --
710: BEGIN
711: SELECT *
712: INTO l_credited_trx_rec
713: FROM ra_customer_trx_cr_trx_v
714: WHERE customer_trx_id = p_prev_customer_trx_id ;
715: EXCEPTION
716: WHEN NO_DATA_FOUND THEN
717: --- TDEY 99/09/27 : Bug 913062
720: --- not exist in the system.
721: --- Proposed error message : AR_RAXTRX-1666 Your credit memo
722: --- transaction can only credit an invoice or a debit memo line
723: IF PG_DEBUG in ('Y', 'C') THEN
724: arp_util.debug('EXCEPTION: select from ra_customer_trx_cr_trx_v returns no data');
725: END IF;
726:
727: fnd_message.set_name( 'AR', 'AR_RAXTRX-1666');
728: l_message_name := 'AR_RAXTRX-1666' ;
1269: END ;
1270:
1271: /*
1272: Bug 2527439 : check if doc sequence is required/used
1273: Bug 3041195 : 1. ra_customer_trx_table was not getting updated with the
1274: doc seq no/value when copy_doc_number_flag = 'N'. Modified
1275: if ..else clause.
1276: 2. Document sequence Nos were getting lost if errors were
1277: encountered during completion checking. Re-arranged the
1314: ELSE
1315: l_cm_header.trx_number := p_trx_number;
1316: END IF;
1317:
1318: UPDATE ra_customer_trx
1319: SET doc_sequence_value = l_cm_header.doc_sequence_value,
1320: doc_sequence_id = l_cm_header.doc_sequence_id,
1321: trx_number = l_cm_header.trx_number,
1322: old_trx_number = l_cm_header.old_trx_number
1468: | passed value.
1469: +=======================================================================*/
1470:
1471: PROCEDURE create_line_cm (
1472: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1473: p_batch_id IN ra_batches.batch_id%type,
1474: p_trx_date IN ra_customer_trx.trx_date%type,
1475: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1476: p_complete_flag IN ra_customer_trx.complete_flag%type,
1470:
1471: PROCEDURE create_line_cm (
1472: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1473: p_batch_id IN ra_batches.batch_id%type,
1474: p_trx_date IN ra_customer_trx.trx_date%type,
1475: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1476: p_complete_flag IN ra_customer_trx.complete_flag%type,
1477: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
1478: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1472: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1473: p_batch_id IN ra_batches.batch_id%type,
1474: p_trx_date IN ra_customer_trx.trx_date%type,
1475: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1476: p_complete_flag IN ra_customer_trx.complete_flag%type,
1477: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
1478: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1479: p_currency_code IN fnd_currencies.currency_code%type,
1480: p_exchange_date IN ra_customer_trx.exchange_date%type,
1476: p_complete_flag IN ra_customer_trx.complete_flag%type,
1477: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
1478: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1479: p_currency_code IN fnd_currencies.currency_code%type,
1480: p_exchange_date IN ra_customer_trx.exchange_date%type,
1481: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1482: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1483: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1484: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1477: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
1478: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1479: p_currency_code IN fnd_currencies.currency_code%type,
1480: p_exchange_date IN ra_customer_trx.exchange_date%type,
1481: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1482: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1483: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1484: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1485: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1478: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1479: p_currency_code IN fnd_currencies.currency_code%type,
1480: p_exchange_date IN ra_customer_trx.exchange_date%type,
1481: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1482: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1483: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1484: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1485: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1486: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1479: p_currency_code IN fnd_currencies.currency_code%type,
1480: p_exchange_date IN ra_customer_trx.exchange_date%type,
1481: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1482: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1483: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1484: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1485: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1486: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1487: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1480: p_exchange_date IN ra_customer_trx.exchange_date%type,
1481: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1482: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1483: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1484: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1485: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1486: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1487: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1488: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1481: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
1482: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1483: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1484: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1485: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1486: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1487: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1488: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1489: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1482: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1483: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1484: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1485: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1486: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1487: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1488: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1489: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1490: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1483: p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
1484: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1485: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1486: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1487: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1488: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1489: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1490: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1491: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1484: p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
1485: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1486: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1487: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1488: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1489: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1490: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1491: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1492: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1485: p_split_term_method IN ra_customer_trx.credit_method_for_installments%type,
1486: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1487: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1488: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1489: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1490: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1491: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1492: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1493: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1486: p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
1487: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1488: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1489: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1490: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1491: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1492: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1493: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1494: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1487: p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
1488: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1489: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1490: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1491: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1492: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1493: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1494: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1495: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1488: p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
1489: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1490: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1491: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1492: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1493: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1494: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1495: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1496: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1489: p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
1490: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1491: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1492: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1493: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1494: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1495: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1496: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1497: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1490: p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
1491: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1492: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1493: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1494: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1495: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1496: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1497: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1498: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1491: p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
1492: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1493: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1494: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1495: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1496: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1497: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1498: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1499: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1492: p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
1493: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1494: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1495: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1496: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1497: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1498: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1499: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1500: p_printing_option IN ra_customer_trx.printing_option%type,
1493: p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
1494: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1495: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1496: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1497: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1498: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1499: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1500: p_printing_option IN ra_customer_trx.printing_option%type,
1501: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1494: p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
1495: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1496: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1497: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1498: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1499: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1500: p_printing_option IN ra_customer_trx.printing_option%type,
1501: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1502: p_printing_pending IN ra_customer_trx.printing_pending%type,
1495: p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
1496: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1497: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1498: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1499: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1500: p_printing_option IN ra_customer_trx.printing_option%type,
1501: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1502: p_printing_pending IN ra_customer_trx.printing_pending%type,
1503: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1496: p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
1497: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1498: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1499: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1500: p_printing_option IN ra_customer_trx.printing_option%type,
1501: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1502: p_printing_pending IN ra_customer_trx.printing_pending%type,
1503: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1504: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1497: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
1498: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1499: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1500: p_printing_option IN ra_customer_trx.printing_option%type,
1501: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1502: p_printing_pending IN ra_customer_trx.printing_pending%type,
1503: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1504: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1505: p_reason_code IN ra_customer_trx.reason_code%type,
1498: p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
1499: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1500: p_printing_option IN ra_customer_trx.printing_option%type,
1501: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1502: p_printing_pending IN ra_customer_trx.printing_pending%type,
1503: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1504: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1505: p_reason_code IN ra_customer_trx.reason_code%type,
1506: p_customer_reference IN ra_customer_trx.customer_reference%type,
1499: p_customer_bank_account_id IN ra_customer_trx.customer_bank_account_id%type,
1500: p_printing_option IN ra_customer_trx.printing_option%type,
1501: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1502: p_printing_pending IN ra_customer_trx.printing_pending%type,
1503: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1504: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1505: p_reason_code IN ra_customer_trx.reason_code%type,
1506: p_customer_reference IN ra_customer_trx.customer_reference%type,
1507: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1500: p_printing_option IN ra_customer_trx.printing_option%type,
1501: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1502: p_printing_pending IN ra_customer_trx.printing_pending%type,
1503: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1504: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1505: p_reason_code IN ra_customer_trx.reason_code%type,
1506: p_customer_reference IN ra_customer_trx.customer_reference%type,
1507: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1508: p_internal_notes IN ra_customer_trx.internal_notes%type,
1501: p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
1502: p_printing_pending IN ra_customer_trx.printing_pending%type,
1503: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1504: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1505: p_reason_code IN ra_customer_trx.reason_code%type,
1506: p_customer_reference IN ra_customer_trx.customer_reference%type,
1507: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1508: p_internal_notes IN ra_customer_trx.internal_notes%type,
1509: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1502: p_printing_pending IN ra_customer_trx.printing_pending%type,
1503: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1504: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1505: p_reason_code IN ra_customer_trx.reason_code%type,
1506: p_customer_reference IN ra_customer_trx.customer_reference%type,
1507: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1508: p_internal_notes IN ra_customer_trx.internal_notes%type,
1509: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1510: p_created_from IN ra_customer_trx.created_from%type,
1503: p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
1504: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1505: p_reason_code IN ra_customer_trx.reason_code%type,
1506: p_customer_reference IN ra_customer_trx.customer_reference%type,
1507: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1508: p_internal_notes IN ra_customer_trx.internal_notes%type,
1509: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1510: p_created_from IN ra_customer_trx.created_from%type,
1511: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1504: p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
1505: p_reason_code IN ra_customer_trx.reason_code%type,
1506: p_customer_reference IN ra_customer_trx.customer_reference%type,
1507: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1508: p_internal_notes IN ra_customer_trx.internal_notes%type,
1509: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1510: p_created_from IN ra_customer_trx.created_from%type,
1511: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1512: p_attribute_category IN ra_customer_trx.attribute_category%type,
1505: p_reason_code IN ra_customer_trx.reason_code%type,
1506: p_customer_reference IN ra_customer_trx.customer_reference%type,
1507: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1508: p_internal_notes IN ra_customer_trx.internal_notes%type,
1509: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1510: p_created_from IN ra_customer_trx.created_from%type,
1511: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1512: p_attribute_category IN ra_customer_trx.attribute_category%type,
1513: p_attribute1 IN ra_customer_trx.attribute1%type,
1506: p_customer_reference IN ra_customer_trx.customer_reference%type,
1507: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1508: p_internal_notes IN ra_customer_trx.internal_notes%type,
1509: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1510: p_created_from IN ra_customer_trx.created_from%type,
1511: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1512: p_attribute_category IN ra_customer_trx.attribute_category%type,
1513: p_attribute1 IN ra_customer_trx.attribute1%type,
1514: p_attribute2 IN ra_customer_trx.attribute2%type,
1507: p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
1508: p_internal_notes IN ra_customer_trx.internal_notes%type,
1509: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1510: p_created_from IN ra_customer_trx.created_from%type,
1511: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1512: p_attribute_category IN ra_customer_trx.attribute_category%type,
1513: p_attribute1 IN ra_customer_trx.attribute1%type,
1514: p_attribute2 IN ra_customer_trx.attribute2%type,
1515: p_attribute3 IN ra_customer_trx.attribute3%type,
1508: p_internal_notes IN ra_customer_trx.internal_notes%type,
1509: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1510: p_created_from IN ra_customer_trx.created_from%type,
1511: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1512: p_attribute_category IN ra_customer_trx.attribute_category%type,
1513: p_attribute1 IN ra_customer_trx.attribute1%type,
1514: p_attribute2 IN ra_customer_trx.attribute2%type,
1515: p_attribute3 IN ra_customer_trx.attribute3%type,
1516: p_attribute4 IN ra_customer_trx.attribute4%type,
1509: p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
1510: p_created_from IN ra_customer_trx.created_from%type,
1511: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1512: p_attribute_category IN ra_customer_trx.attribute_category%type,
1513: p_attribute1 IN ra_customer_trx.attribute1%type,
1514: p_attribute2 IN ra_customer_trx.attribute2%type,
1515: p_attribute3 IN ra_customer_trx.attribute3%type,
1516: p_attribute4 IN ra_customer_trx.attribute4%type,
1517: p_attribute5 IN ra_customer_trx.attribute5%type,
1510: p_created_from IN ra_customer_trx.created_from%type,
1511: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1512: p_attribute_category IN ra_customer_trx.attribute_category%type,
1513: p_attribute1 IN ra_customer_trx.attribute1%type,
1514: p_attribute2 IN ra_customer_trx.attribute2%type,
1515: p_attribute3 IN ra_customer_trx.attribute3%type,
1516: p_attribute4 IN ra_customer_trx.attribute4%type,
1517: p_attribute5 IN ra_customer_trx.attribute5%type,
1518: p_attribute6 IN ra_customer_trx.attribute6%type,
1511: p_old_trx_number IN ra_customer_trx.old_trx_number%type,
1512: p_attribute_category IN ra_customer_trx.attribute_category%type,
1513: p_attribute1 IN ra_customer_trx.attribute1%type,
1514: p_attribute2 IN ra_customer_trx.attribute2%type,
1515: p_attribute3 IN ra_customer_trx.attribute3%type,
1516: p_attribute4 IN ra_customer_trx.attribute4%type,
1517: p_attribute5 IN ra_customer_trx.attribute5%type,
1518: p_attribute6 IN ra_customer_trx.attribute6%type,
1519: p_attribute7 IN ra_customer_trx.attribute7%type,
1512: p_attribute_category IN ra_customer_trx.attribute_category%type,
1513: p_attribute1 IN ra_customer_trx.attribute1%type,
1514: p_attribute2 IN ra_customer_trx.attribute2%type,
1515: p_attribute3 IN ra_customer_trx.attribute3%type,
1516: p_attribute4 IN ra_customer_trx.attribute4%type,
1517: p_attribute5 IN ra_customer_trx.attribute5%type,
1518: p_attribute6 IN ra_customer_trx.attribute6%type,
1519: p_attribute7 IN ra_customer_trx.attribute7%type,
1520: p_attribute8 IN ra_customer_trx.attribute8%type,
1513: p_attribute1 IN ra_customer_trx.attribute1%type,
1514: p_attribute2 IN ra_customer_trx.attribute2%type,
1515: p_attribute3 IN ra_customer_trx.attribute3%type,
1516: p_attribute4 IN ra_customer_trx.attribute4%type,
1517: p_attribute5 IN ra_customer_trx.attribute5%type,
1518: p_attribute6 IN ra_customer_trx.attribute6%type,
1519: p_attribute7 IN ra_customer_trx.attribute7%type,
1520: p_attribute8 IN ra_customer_trx.attribute8%type,
1521: p_attribute9 IN ra_customer_trx.attribute9%type,
1514: p_attribute2 IN ra_customer_trx.attribute2%type,
1515: p_attribute3 IN ra_customer_trx.attribute3%type,
1516: p_attribute4 IN ra_customer_trx.attribute4%type,
1517: p_attribute5 IN ra_customer_trx.attribute5%type,
1518: p_attribute6 IN ra_customer_trx.attribute6%type,
1519: p_attribute7 IN ra_customer_trx.attribute7%type,
1520: p_attribute8 IN ra_customer_trx.attribute8%type,
1521: p_attribute9 IN ra_customer_trx.attribute9%type,
1522: p_attribute10 IN ra_customer_trx.attribute10%type,
1515: p_attribute3 IN ra_customer_trx.attribute3%type,
1516: p_attribute4 IN ra_customer_trx.attribute4%type,
1517: p_attribute5 IN ra_customer_trx.attribute5%type,
1518: p_attribute6 IN ra_customer_trx.attribute6%type,
1519: p_attribute7 IN ra_customer_trx.attribute7%type,
1520: p_attribute8 IN ra_customer_trx.attribute8%type,
1521: p_attribute9 IN ra_customer_trx.attribute9%type,
1522: p_attribute10 IN ra_customer_trx.attribute10%type,
1523: p_attribute11 IN ra_customer_trx.attribute11%type,
1516: p_attribute4 IN ra_customer_trx.attribute4%type,
1517: p_attribute5 IN ra_customer_trx.attribute5%type,
1518: p_attribute6 IN ra_customer_trx.attribute6%type,
1519: p_attribute7 IN ra_customer_trx.attribute7%type,
1520: p_attribute8 IN ra_customer_trx.attribute8%type,
1521: p_attribute9 IN ra_customer_trx.attribute9%type,
1522: p_attribute10 IN ra_customer_trx.attribute10%type,
1523: p_attribute11 IN ra_customer_trx.attribute11%type,
1524: p_attribute12 IN ra_customer_trx.attribute12%type,
1517: p_attribute5 IN ra_customer_trx.attribute5%type,
1518: p_attribute6 IN ra_customer_trx.attribute6%type,
1519: p_attribute7 IN ra_customer_trx.attribute7%type,
1520: p_attribute8 IN ra_customer_trx.attribute8%type,
1521: p_attribute9 IN ra_customer_trx.attribute9%type,
1522: p_attribute10 IN ra_customer_trx.attribute10%type,
1523: p_attribute11 IN ra_customer_trx.attribute11%type,
1524: p_attribute12 IN ra_customer_trx.attribute12%type,
1525: p_attribute13 IN ra_customer_trx.attribute13%type,
1518: p_attribute6 IN ra_customer_trx.attribute6%type,
1519: p_attribute7 IN ra_customer_trx.attribute7%type,
1520: p_attribute8 IN ra_customer_trx.attribute8%type,
1521: p_attribute9 IN ra_customer_trx.attribute9%type,
1522: p_attribute10 IN ra_customer_trx.attribute10%type,
1523: p_attribute11 IN ra_customer_trx.attribute11%type,
1524: p_attribute12 IN ra_customer_trx.attribute12%type,
1525: p_attribute13 IN ra_customer_trx.attribute13%type,
1526: p_attribute14 IN ra_customer_trx.attribute14%type,
1519: p_attribute7 IN ra_customer_trx.attribute7%type,
1520: p_attribute8 IN ra_customer_trx.attribute8%type,
1521: p_attribute9 IN ra_customer_trx.attribute9%type,
1522: p_attribute10 IN ra_customer_trx.attribute10%type,
1523: p_attribute11 IN ra_customer_trx.attribute11%type,
1524: p_attribute12 IN ra_customer_trx.attribute12%type,
1525: p_attribute13 IN ra_customer_trx.attribute13%type,
1526: p_attribute14 IN ra_customer_trx.attribute14%type,
1527: p_attribute15 IN ra_customer_trx.attribute15%type,
1520: p_attribute8 IN ra_customer_trx.attribute8%type,
1521: p_attribute9 IN ra_customer_trx.attribute9%type,
1522: p_attribute10 IN ra_customer_trx.attribute10%type,
1523: p_attribute11 IN ra_customer_trx.attribute11%type,
1524: p_attribute12 IN ra_customer_trx.attribute12%type,
1525: p_attribute13 IN ra_customer_trx.attribute13%type,
1526: p_attribute14 IN ra_customer_trx.attribute14%type,
1527: p_attribute15 IN ra_customer_trx.attribute15%type,
1528: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1521: p_attribute9 IN ra_customer_trx.attribute9%type,
1522: p_attribute10 IN ra_customer_trx.attribute10%type,
1523: p_attribute11 IN ra_customer_trx.attribute11%type,
1524: p_attribute12 IN ra_customer_trx.attribute12%type,
1525: p_attribute13 IN ra_customer_trx.attribute13%type,
1526: p_attribute14 IN ra_customer_trx.attribute14%type,
1527: p_attribute15 IN ra_customer_trx.attribute15%type,
1528: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1529: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1522: p_attribute10 IN ra_customer_trx.attribute10%type,
1523: p_attribute11 IN ra_customer_trx.attribute11%type,
1524: p_attribute12 IN ra_customer_trx.attribute12%type,
1525: p_attribute13 IN ra_customer_trx.attribute13%type,
1526: p_attribute14 IN ra_customer_trx.attribute14%type,
1527: p_attribute15 IN ra_customer_trx.attribute15%type,
1528: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1529: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1530: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1523: p_attribute11 IN ra_customer_trx.attribute11%type,
1524: p_attribute12 IN ra_customer_trx.attribute12%type,
1525: p_attribute13 IN ra_customer_trx.attribute13%type,
1526: p_attribute14 IN ra_customer_trx.attribute14%type,
1527: p_attribute15 IN ra_customer_trx.attribute15%type,
1528: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1529: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1530: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1531: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1524: p_attribute12 IN ra_customer_trx.attribute12%type,
1525: p_attribute13 IN ra_customer_trx.attribute13%type,
1526: p_attribute14 IN ra_customer_trx.attribute14%type,
1527: p_attribute15 IN ra_customer_trx.attribute15%type,
1528: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1529: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1530: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1531: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1532: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1525: p_attribute13 IN ra_customer_trx.attribute13%type,
1526: p_attribute14 IN ra_customer_trx.attribute14%type,
1527: p_attribute15 IN ra_customer_trx.attribute15%type,
1528: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1529: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1530: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1531: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1532: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1533: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1526: p_attribute14 IN ra_customer_trx.attribute14%type,
1527: p_attribute15 IN ra_customer_trx.attribute15%type,
1528: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1529: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1530: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1531: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1532: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1533: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1534: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1527: p_attribute15 IN ra_customer_trx.attribute15%type,
1528: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1529: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1530: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1531: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1532: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1533: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1534: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1535: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1528: p_interface_header_context IN ra_customer_trx.interface_header_context%type,
1529: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1530: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1531: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1532: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1533: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1534: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1535: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1536: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1529: p_interface_header_attribute1 IN ra_customer_trx.interface_header_attribute1%type,
1530: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1531: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1532: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1533: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1534: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1535: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1536: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1537: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1530: p_interface_header_attribute2 IN ra_customer_trx.interface_header_attribute2%type,
1531: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1532: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1533: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1534: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1535: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1536: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1537: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1538: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1531: p_interface_header_attribute3 IN ra_customer_trx.interface_header_attribute3%type,
1532: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1533: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1534: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1535: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1536: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1537: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1538: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1539: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1532: p_interface_header_attribute4 IN ra_customer_trx.interface_header_attribute4%type,
1533: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1534: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1535: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1536: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1537: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1538: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1539: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1540: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1533: p_interface_header_attribute5 IN ra_customer_trx.interface_header_attribute5%type,
1534: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1535: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1536: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1537: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1538: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1539: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1540: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1541: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1534: p_interface_header_attribute6 IN ra_customer_trx.interface_header_attribute6%type,
1535: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1536: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1537: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1538: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1539: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1540: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1541: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1542: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1535: p_interface_header_attribute7 IN ra_customer_trx.interface_header_attribute7%type,
1536: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1537: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1538: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1539: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1540: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1541: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1542: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1543: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1536: p_interface_header_attribute8 IN ra_customer_trx.interface_header_attribute8%type,
1537: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1538: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1539: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1540: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1541: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1542: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1543: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1544: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1537: p_interface_header_attribute9 IN ra_customer_trx.interface_header_attribute9%type,
1538: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1539: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1540: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1541: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1542: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1543: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1544: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1545: p_line_percent IN number,
1538: p_interface_header_attribute10 IN ra_customer_trx.interface_header_attribute10%type,
1539: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1540: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1541: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1542: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1543: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1544: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1545: p_line_percent IN number,
1546: p_freight_percent IN number,
1539: p_interface_header_attribute11 IN ra_customer_trx.interface_header_attribute11%type,
1540: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1541: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1542: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1543: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1544: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1545: p_line_percent IN number,
1546: p_freight_percent IN number,
1547: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1540: p_interface_header_attribute12 IN ra_customer_trx.interface_header_attribute12%type,
1541: p_interface_header_attribute13 IN ra_customer_trx.interface_header_attribute13%type,
1542: p_interface_header_attribute14 IN ra_customer_trx.interface_header_attribute14%type,
1543: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1544: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1545: p_line_percent IN number,
1546: p_freight_percent IN number,
1547: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1548: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1543: p_interface_header_attribute15 IN ra_customer_trx.interface_header_attribute15%type,
1544: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1545: p_line_percent IN number,
1546: p_freight_percent IN number,
1547: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1548: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1549: p_compute_tax IN varchar2,
1550: p_comments IN ra_customer_trx.comments%type,
1551: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1544: p_default_ussgl_trx_code IN ra_customer_trx.default_ussgl_transaction_code%type,
1545: p_line_percent IN number,
1546: p_freight_percent IN number,
1547: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1548: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1549: p_compute_tax IN varchar2,
1550: p_comments IN ra_customer_trx.comments%type,
1551: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1552: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1546: p_freight_percent IN number,
1547: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1548: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1549: p_compute_tax IN varchar2,
1550: p_comments IN ra_customer_trx.comments%type,
1551: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1552: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1553: p_computed_tax_percent IN OUT NOCOPY number,
1554: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1547: p_line_amount IN ra_customer_trx_lines.extended_amount%type,
1548: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1549: p_compute_tax IN varchar2,
1550: p_comments IN ra_customer_trx.comments%type,
1551: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1552: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1553: p_computed_tax_percent IN OUT NOCOPY number,
1554: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1555: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1548: p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
1549: p_compute_tax IN varchar2,
1550: p_comments IN ra_customer_trx.comments%type,
1551: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1552: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1553: p_computed_tax_percent IN OUT NOCOPY number,
1554: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1555: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1556: p_status OUT NOCOPY varchar2,
1550: p_comments IN ra_customer_trx.comments%type,
1551: p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
1552: p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
1553: p_computed_tax_percent IN OUT NOCOPY number,
1554: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1555: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1556: p_status OUT NOCOPY varchar2,
1557: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1558: p_purchase_order IN ra_customer_trx.purchase_order%type,
1554: p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
1555: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1556: p_status OUT NOCOPY varchar2,
1557: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1558: p_purchase_order IN ra_customer_trx.purchase_order%type,
1559: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
1560: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1561: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1562: /*4556000-4606558*/
1555: p_errors OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
1556: p_status OUT NOCOPY varchar2,
1557: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1558: p_purchase_order IN ra_customer_trx.purchase_order%type,
1559: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
1560: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1561: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1562: /*4556000-4606558*/
1563: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1556: p_status OUT NOCOPY varchar2,
1557: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1558: p_purchase_order IN ra_customer_trx.purchase_order%type,
1559: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
1560: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1561: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1562: /*4556000-4606558*/
1563: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1564: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1557: p_credit_line_table IN arw_cm_cover.credit_lines_table_type,
1558: p_purchase_order IN ra_customer_trx.purchase_order%type,
1559: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
1560: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1561: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1562: /*4556000-4606558*/
1563: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1564: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1565: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1559: p_purchase_order_revision IN ra_customer_trx.purchase_order_revision%type,
1560: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1561: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1562: /*4556000-4606558*/
1563: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1564: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1565: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1566: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1567: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1560: p_purchase_order_date IN ra_customer_trx.purchase_order_date%type,
1561: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1562: /*4556000-4606558*/
1563: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1564: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1565: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1566: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1567: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1568: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1561: p_legal_entity_id IN ra_customer_trx.legal_entity_id%type ,
1562: /*4556000-4606558*/
1563: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1564: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1565: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1566: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1567: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1568: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1569: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1562: /*4556000-4606558*/
1563: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1564: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1565: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1566: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1567: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1568: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1569: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1570: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1563: p_global_attribute_category IN ra_customer_trx.global_attribute_category%type default null,
1564: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1565: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1566: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1567: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1568: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1569: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1570: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1571: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1564: p_global_attribute1 IN ra_customer_trx.global_attribute1%type default NULL,
1565: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1566: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1567: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1568: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1569: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1570: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1571: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1572: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1565: p_global_attribute2 IN ra_customer_trx.global_attribute2%type default NULL,
1566: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1567: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1568: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1569: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1570: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1571: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1572: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1573: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1566: p_global_attribute3 IN ra_customer_trx.global_attribute3%type default NULL,
1567: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1568: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1569: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1570: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1571: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1572: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1573: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1574: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1567: p_global_attribute4 IN ra_customer_trx.global_attribute4%type default NULL,
1568: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1569: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1570: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1571: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1572: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1573: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1574: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1575: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1568: p_global_attribute5 IN ra_customer_trx.global_attribute5%type default NULL,
1569: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1570: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1571: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1572: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1573: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1574: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1575: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1576: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1569: p_global_attribute6 IN ra_customer_trx.global_attribute6%type default NULL,
1570: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1571: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1572: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1573: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1574: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1575: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1576: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1577: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1570: p_global_attribute7 IN ra_customer_trx.global_attribute7%type default NULL,
1571: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1572: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1573: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1574: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1575: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1576: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1577: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1578: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1571: p_global_attribute8 IN ra_customer_trx.global_attribute8%type default NULL,
1572: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1573: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1574: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1575: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1576: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1577: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1578: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1579: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1572: p_global_attribute9 IN ra_customer_trx.global_attribute9%type default NULL,
1573: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1574: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1575: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1576: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1577: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1578: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1579: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1580: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1573: p_global_attribute10 IN ra_customer_trx.global_attribute10%type default NULL,
1574: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1575: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1576: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1577: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1578: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1579: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1580: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1581: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1574: p_global_attribute11 IN ra_customer_trx.global_attribute11%type default NULL,
1575: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1576: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1577: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1578: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1579: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1580: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1581: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1582: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1575: p_global_attribute12 IN ra_customer_trx.global_attribute12%type default NULL,
1576: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1577: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1578: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1579: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1580: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1581: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1582: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1583: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1576: p_global_attribute13 IN ra_customer_trx.global_attribute13%type default NULL,
1577: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1578: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1579: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1580: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1581: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1582: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1583: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1584: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1577: p_global_attribute14 IN ra_customer_trx.global_attribute14%type default NULL,
1578: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1579: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1580: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1581: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1582: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1583: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1584: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1585: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1578: p_global_attribute15 IN ra_customer_trx.global_attribute15%type default NULL,
1579: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1580: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1581: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1582: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1583: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1584: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1585: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1586: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1579: p_global_attribute16 IN ra_customer_trx.global_attribute16%type default NULL,
1580: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1581: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1582: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1583: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1584: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1585: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1586: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1587: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1580: p_global_attribute17 IN ra_customer_trx.global_attribute17%type default NULL,
1581: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1582: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1583: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1584: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1585: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1586: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1587: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1588: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1581: p_global_attribute18 IN ra_customer_trx.global_attribute18%type default NULL,
1582: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1583: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1584: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1585: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1586: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1587: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1588: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1589: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1582: p_global_attribute19 IN ra_customer_trx.global_attribute19%type default NULL,
1583: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1584: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1585: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1586: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1587: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1588: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1589: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1590: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1583: p_global_attribute20 IN ra_customer_trx.global_attribute20%type default NULL,
1584: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1585: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1586: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1587: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1588: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1589: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1590: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1591: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1584: p_global_attribute21 IN ra_customer_trx.global_attribute21%type default NULL,
1585: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1586: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1587: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1588: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1589: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1590: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1591: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1592: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1585: p_global_attribute22 IN ra_customer_trx.global_attribute22%type default NULL,
1586: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1587: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1588: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1589: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1590: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1591: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1592: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1593: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
1586: p_global_attribute23 IN ra_customer_trx.global_attribute23%type default NULL,
1587: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1588: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1589: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1590: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1591: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1592: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1593: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
1594: )
1587: p_global_attribute24 IN ra_customer_trx.global_attribute24%type default NULL,
1588: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1589: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1590: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1591: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1592: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1593: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
1594: )
1595: AS
1588: p_global_attribute25 IN ra_customer_trx.global_attribute25%type default NULL,
1589: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1590: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1591: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1592: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1593: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
1594: )
1595: AS
1596:
1589: p_global_attribute26 IN ra_customer_trx.global_attribute26%type default NULL,
1590: p_global_attribute27 IN ra_customer_trx.global_attribute27%type default NULL,
1591: p_global_attribute28 IN ra_customer_trx.global_attribute28%type default NULL,
1592: p_global_attribute29 IN ra_customer_trx.global_attribute29%type default NULL,
1593: p_global_attribute30 IN ra_customer_trx.global_attribute30%type default NULL
1594: )
1595: AS
1596:
1597: --
1600: p_do_salescredits VARCHAR2(1) := 'N';
1601: p_do_autoaccounting VARCHAR2(1) := 'N';
1602: p_commit VARCHAR2(1) := FND_API.G_TRUE;
1603: l_compute_tax VARCHAR2(1);
1604: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1605: l_temp varchar2(30);
1606: l_start_time varchar2(100);
1607: l_header_time varchar2(100);
1608: l_line_time varchar2(100);
1618: l_return_status varchar2(1);
1619: l_msg_count NUMBER;
1620: l_msg_data varchar2(4000);
1621: l_errors arp_trx_validate.Message_Tbl_Type;
1622: l_new_customer_trx_id ra_customer_trx.customer_trx_id%type;
1623: l_cursor INTEGER;
1624: i BINARY_INTEGER := 0;
1625: n BINARY_INTEGER := 0;
1626: l_ignore INTEGER;
1630: l_prev_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type ;
1631:
1632:
1633: l_rec_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1634: l_trx_rec ra_customer_trx_cr_trx_v%rowtype;
1635: l_batch_rec ra_batches%rowtype;
1636:
1637: l_cr CONSTANT char(1) := '
1638: ';
1637: l_cr CONSTANT char(1) := '
1638: ';
1639: j number;
1640:
1641: ct_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1642: ct_quantity_invoiced ra_customer_trx_lines.quantity_invoiced%TYPE;
1643: ct_extended_amount ra_customer_trx_lines.extended_amount%TYPE;
1644: ----
1645: l_dist_index NUMBER ;
1638: ';
1639: j number;
1640:
1641: ct_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1642: ct_quantity_invoiced ra_customer_trx_lines.quantity_invoiced%TYPE;
1643: ct_extended_amount ra_customer_trx_lines.extended_amount%TYPE;
1644: ----
1645: l_dist_index NUMBER ;
1646: l_lines_index NUMBER ;
1639: j number;
1640:
1641: ct_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1642: ct_quantity_invoiced ra_customer_trx_lines.quantity_invoiced%TYPE;
1643: ct_extended_amount ra_customer_trx_lines.extended_amount%TYPE;
1644: ----
1645: l_dist_index NUMBER ;
1646: l_lines_index NUMBER ;
1647: l_credit_memo_type_id ra_cust_trx_types.credit_memo_type_id%type;
1648: l_line_matched NUMBER := 0;
1649: l_lines_to_delete_index NUMBER := 1;
1650: TYPE lines_to_delete_rec IS RECORD
1651: (line_index BINARY_INTEGER,
1652: line_type ra_customer_trx_lines.Line_type%type
1653: );
1654: TYPE lines_to_delete_tbl_type IS TABLE OF lines_to_delete_rec INDEX BY BINARY_INTEGER;
1655: l_lines_to_delete_tbl lines_to_delete_tbl_type;
1656:
1662: e_unexpected_error EXCEPTION;
1663: l_message_name VARCHAR2(255);
1664: l_debug_point NUMBER;
1665:
1666: l_cm_header ra_customer_trx%rowtype;
1667:
1668: l_line_amount ra_customer_trx_lines.extended_amount%type ;
1669: l_line_percent number ;
1670: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1664: l_debug_point NUMBER;
1665:
1666: l_cm_header ra_customer_trx%rowtype;
1667:
1668: l_line_amount ra_customer_trx_lines.extended_amount%type ;
1669: l_line_percent number ;
1670: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1671: l_freight_percent number ;
1672: l_computed_tax_percent number;
1666: l_cm_header ra_customer_trx%rowtype;
1667:
1668: l_line_amount ra_customer_trx_lines.extended_amount%type ;
1669: l_line_percent number ;
1670: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1671: l_freight_percent number ;
1672: l_computed_tax_percent number;
1673: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
1674:
1669: l_line_percent number ;
1670: l_freight_amount ra_customer_trx_lines.extended_amount%type ;
1671: l_freight_percent number ;
1672: l_computed_tax_percent number;
1673: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
1674:
1675: l_default_bs_name varchar2(50);
1676: l_bs_type varchar2(10);
1677: l_copy_doc_number_flag varchar2(1);
1697: l_form_version number := NULL;
1698:
1699: l_auto_trx_numbering_flag varchar2(1);
1700:
1701: l_credited_trx_rec ra_customer_trx_cr_trx_v%rowtype ;
1702: --
1703: l_line_orig number;
1704: l_tax_orig number;
1705: l_frt_orig number;
1715: l_pmt_exist_flag varchar2(1);
1716: --
1717: l_credited_trx_line_tbl arw_cm_cover.credit_lines_table_type;
1718:
1719: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1720:
1721: l_err_mesg VARCHAR2(2000);
1722: l_ue_message VARCHAR2(2000);
1723:
1880: --
1881: BEGIN
1882: SELECT *
1883: INTO l_credited_trx_rec
1884: FROM ra_customer_trx_cr_trx_v
1885: WHERE customer_trx_id = p_prev_customer_trx_id ;
1886: EXCEPTION
1887: WHEN NO_DATA_FOUND THEN
1888: --- TDEY 99/09/27 : Bug 913062
2606:
2607:
2608: /*
2609: Bug 2527439 : check if doc sequence is required/used
2610: Bug 3041195 : 1. ra_customer_trx_table was not getting updated with the
2611: doc seq no/value when copy_doc_number_flag = 'N'. Modified
2612: if ..else clause.
2613: 2. Document sequence Nos were getting lost if errors were
2614: encountered during completion checking. Re-arranged the
2651: ELSE
2652: l_cm_header.trx_number := p_trx_number;
2653: END IF;
2654:
2655: UPDATE ra_customer_trx
2656: SET doc_sequence_value = l_cm_header.doc_sequence_value,
2657: doc_sequence_id = l_cm_header.doc_sequence_id,
2658: trx_number = l_cm_header.trx_number,
2659: old_trx_number = l_cm_header.old_trx_number