[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_header_cover (
p_form_name IN varchar2,
p_form_version IN number,
p_batch_id IN ra_batches.batch_id%type,
p_trx_date IN ra_customer_trx.trx_date%type,
p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
p_complete_flag IN ra_customer_trx.complete_flag%type,
p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
p_batch_source_id IN ra_batch_sources.batch_source_id%type,
p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
p_currency_code IN fnd_currencies.currency_code%type,
p_exchange_date IN ra_customer_trx.exchange_date%type,
p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type,
p_exchange_rate IN ra_customer_trx.exchange_rate%type,
p_invoicing_rule_id IN ra_customer_trx.invoicing_rule_id%type,
p_method_for_rules IN ra_customer_trx.credit_method_for_rules%type,
p_split_term_method IN
ra_customer_trx.credit_method_for_installments%type,
p_initial_customer_trx_id IN ra_customer_trx.initial_customer_trx_id%type,
p_primary_salesrep_id IN ra_customer_trx.primary_salesrep_id%type,
p_bill_to_customer_id IN ra_customer_trx.bill_to_customer_id%type,
p_bill_to_address_id IN ra_customer_trx.bill_to_address_id%type,
p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
p_bill_to_contact_id IN ra_customer_trx.bill_to_contact_id%type,
p_ship_to_customer_id IN ra_customer_trx.ship_to_customer_id%type,
p_ship_to_address_id IN ra_customer_trx.ship_to_address_id%type,
p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
p_ship_to_contact_id IN ra_customer_trx.ship_to_contact_id%type,
p_receipt_method_id IN ra_customer_trx.receipt_method_id%type,
p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
p_paying_site_use_id IN ra_customer_trx.paying_site_use_id%type,
p_customer_bank_account_id IN
ra_customer_trx.customer_bank_account_id%type,
p_printing_option IN ra_customer_trx.printing_option%type,
p_printing_last_printed IN ra_customer_trx.printing_last_printed%type,
p_printing_pending IN ra_customer_trx.printing_pending%type,
p_doc_sequence_value IN ra_customer_trx.doc_sequence_value%type,
p_doc_sequence_id IN ra_customer_trx.doc_sequence_id%type,
p_reason_code IN ra_customer_trx.reason_code%type,
p_customer_reference IN ra_customer_trx.customer_reference%type,
p_customer_reference_date IN ra_customer_trx.customer_reference_date%type,
p_internal_notes IN ra_customer_trx.internal_notes%type,
p_set_of_books_id IN ra_customer_trx.set_of_books_id%type,
p_created_from IN ra_customer_trx.created_from%type,
p_old_trx_number IN ra_customer_trx.old_trx_number%type,
p_attribute_category IN ra_customer_trx.attribute_category%type,
p_attribute1 IN ra_customer_trx.attribute1%type,
p_attribute2 IN ra_customer_trx.attribute2%type,
p_attribute3 IN ra_customer_trx.attribute3%type,
p_attribute4 IN ra_customer_trx.attribute4%type,
p_attribute5 IN ra_customer_trx.attribute5%type,
p_attribute6 IN ra_customer_trx.attribute6%type,
p_attribute7 IN ra_customer_trx.attribute7%type,
p_attribute8 IN ra_customer_trx.attribute8%type,
p_attribute9 IN ra_customer_trx.attribute9%type,
p_attribute10 IN ra_customer_trx.attribute10%type,
p_attribute11 IN ra_customer_trx.attribute11%type,
p_attribute12 IN ra_customer_trx.attribute12%type,
p_attribute13 IN ra_customer_trx.attribute13%type,
p_attribute14 IN ra_customer_trx.attribute14%type,
p_attribute15 IN ra_customer_trx.attribute15%type,
p_interface_header_context IN
ra_customer_trx.interface_header_context%type,
p_interface_header_attribute1 IN
ra_customer_trx.interface_header_attribute1%type,
p_interface_header_attribute2 IN
ra_customer_trx.interface_header_attribute2%type,
p_interface_header_attribute3 IN
ra_customer_trx.interface_header_attribute3%type,
p_interface_header_attribute4 IN
ra_customer_trx.interface_header_attribute4%type,
p_interface_header_attribute5 IN
ra_customer_trx.interface_header_attribute5%type,
p_interface_header_attribute6 IN
ra_customer_trx.interface_header_attribute6%type,
p_interface_header_attribute7 IN
ra_customer_trx.interface_header_attribute7%type,
p_interface_header_attribute8 IN
ra_customer_trx.interface_header_attribute8%type,
p_interface_header_attribute9 IN
ra_customer_trx.interface_header_attribute9%type,
p_interface_header_attribute10 IN
ra_customer_trx.interface_header_attribute10%type,
p_interface_header_attribute11 IN
ra_customer_trx.interface_header_attribute11%type,
p_interface_header_attribute12 IN
ra_customer_trx.interface_header_attribute12%type,
p_interface_header_attribute13 IN
ra_customer_trx.interface_header_attribute13%type,
p_interface_header_attribute14 IN
ra_customer_trx.interface_header_attribute14%type,
p_interface_header_attribute15 IN
ra_customer_trx.interface_header_attribute15%type,
p_default_ussgl_trx_code IN
ra_customer_trx.default_ussgl_transaction_code%type,
p_line_percent IN number,
p_freight_percent IN number,
p_line_amount IN ra_customer_trx_lines.extended_amount%type,
p_freight_amount IN ra_customer_trx_lines.extended_amount%type,
p_compute_tax IN varchar2,
p_comments IN ra_customer_trx.comments%type,
p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type,
p_trx_number IN OUT NOCOPY ra_customer_trx.trx_number%type,
p_computed_tax_percent IN OUT NOCOPY number,
p_computed_tax_amount IN OUT NOCOPY ra_customer_trx_lines.extended_amount%type,
p_status OUT NOCOPY varchar2,
p_submit_cm_dist IN varchar2 DEFAULT 'N')
IS
l_cm_header ra_customer_trx%rowtype;
arp_util.debug('arp_process_credit_cover.insert_header_cover()+');
SELECT purchase_order,
purchase_order_revision,
purchase_order_date ,
territory_id, /* Bug-3852057 */
legal_entity_id /* R12 LE uptake */
INTO l_cm_header.purchase_order,
l_cm_header.purchase_order_revision,
l_cm_header.purchase_order_date,
l_cm_header.territory_id, /* Bug-3852057 */
l_cm_header.legal_entity_id /* R12 LE uptake */
FROM ra_customer_trx_all
WHERE customer_trx_id = p_prev_customer_trx_id;
arp_process_credit.insert_header(
p_form_name,
p_form_version,
l_cm_header,
'CM',
p_gl_date,
p_primary_salesrep_id,
p_currency_code,
p_prev_customer_trx_id,
p_line_percent,
p_freight_percent,
p_line_amount,
p_freight_amount,
p_compute_tax,
p_trx_number,
l_customer_trx_id,
p_computed_tax_percent,
p_computed_tax_amount,
p_status,
p_submit_cm_dist);
arp_util.debug('arp_process_credit_cover.insert_header_cover()-');
arp_util.debug('EXCEPTION : arp_process_credit_cover.insert_header_cover');
END insert_header_cover;