The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_line_cover(
p_form_name IN varchar2,
p_form_version IN number,
p_memo_line_type IN
ar_memo_lines.line_type%type,
p_trx_class IN
ra_cust_trx_types.type%type,
p_ccid1 IN
gl_code_combinations.code_combination_id%type,
p_ccid2 IN
gl_code_combinations.code_combination_id%type,
p_amount1 IN
ra_cust_trx_line_gl_dist.amount%type,
p_amount2 IN
ra_cust_trx_line_gl_dist.amount%type,
p_customer_trx_id IN
ra_customer_trx_lines.customer_trx_id%type,
p_line_number IN
ra_customer_trx_lines.line_number%type,
p_line_type IN
ra_customer_trx_lines.line_type%type,
p_quantity_credited IN
ra_customer_trx_lines.quantity_credited%type,
p_quantity_invoiced IN
ra_customer_trx_lines.quantity_invoiced%type,
p_quantity_ordered IN
ra_customer_trx_lines.quantity_ordered%type,
p_unit_selling_price IN
ra_customer_trx_lines.unit_selling_price%type,
p_unit_standard_price IN
ra_customer_trx_lines.unit_standard_price%type,
p_revenue_amount IN
ra_customer_trx_lines.revenue_amount%type,
p_extended_amount IN
ra_customer_trx_lines.extended_amount%type,
p_memo_line_id IN
ra_customer_trx_lines.memo_line_id%type,
p_inventory_item_id IN
ra_customer_trx_lines.inventory_item_id%type,
p_item_exception_rate_id IN
ra_customer_trx_lines.item_exception_rate_id%type,
p_description IN
ra_customer_trx_lines.description%type,
p_item_context IN
ra_customer_trx_lines.item_context%type,
p_initial_customer_trx_line_id IN
ra_customer_trx_lines.initial_customer_trx_line_id%type,
p_link_to_cust_trx_line_id IN
ra_customer_trx_lines.link_to_cust_trx_line_id%type,
p_previous_customer_trx_id IN
ra_customer_trx_lines.previous_customer_trx_id%type,
p_prev_customer_trx_line_id IN
ra_customer_trx_lines.previous_customer_trx_line_id%type,
p_accounting_rule_duration IN OUT NOCOPY
ra_customer_trx_lines.accounting_rule_duration%type,
p_accounting_rule_id IN
ra_customer_trx_lines.accounting_rule_id%type,
p_rule_start_date IN OUT NOCOPY
ra_customer_trx_lines.rule_start_date%type,
p_autorule_complete_flag IN
ra_customer_trx_lines.autorule_complete_flag%type,
p_autorule_duration_processed IN
ra_customer_trx_lines.autorule_duration_processed%type,
p_reason_code IN
ra_customer_trx_lines.reason_code%type,
p_last_period_to_credit IN
ra_customer_trx_lines.last_period_to_credit%type,
p_sales_order IN
ra_customer_trx_lines.sales_order%type,
p_sales_order_date IN
ra_customer_trx_lines.sales_order_date%type,
p_sales_order_line IN
ra_customer_trx_lines.sales_order_line%type,
p_sales_order_revision IN
ra_customer_trx_lines.sales_order_revision%type,
p_sales_order_source IN
ra_customer_trx_lines.sales_order_source%type,
p_vat_tax_id IN
ra_customer_trx_lines.vat_tax_id%type,
p_tax_exempt_flag IN
ra_customer_trx_lines.tax_exempt_flag%type,
p_sales_tax_id IN
ra_customer_trx_lines.sales_tax_id%type,
p_location_segment_id IN
ra_customer_trx_lines.location_segment_id%type,
p_tax_exempt_number IN
ra_customer_trx_lines.tax_exempt_number%type,
p_tax_exempt_reason_code IN
ra_customer_trx_lines.tax_exempt_reason_code%type,
p_tax_vendor_return_code IN
ra_customer_trx_lines.tax_vendor_return_code%type,
p_taxable_flag IN
ra_customer_trx_lines.taxable_flag%type,
p_tax_exemption_id IN
ra_customer_trx_lines.tax_exemption_id%type,
p_tax_precedence IN
ra_customer_trx_lines.tax_precedence%type,
p_tax_rate IN
ra_customer_trx_lines.tax_rate%type,
p_uom_code IN
ra_customer_trx_lines.uom_code%type,
p_autotax IN
ra_customer_trx_lines.autotax%type,
p_movement_id IN
ra_customer_trx_lines.movement_id%type,
p_default_ussgl_trx_code IN
ra_customer_trx_lines.default_ussgl_transaction_code%type,
p_default_ussgl_trx_code_cntxt IN
ra_customer_trx_lines.default_ussgl_trx_code_context%type,
p_interface_line_context IN
ra_customer_trx_lines.interface_line_context%type,
p_interface_line_attribute1 IN
ra_customer_trx_lines.interface_line_attribute1%type,
p_interface_line_attribute2 IN
ra_customer_trx_lines.interface_line_attribute2%type,
p_interface_line_attribute3 IN
ra_customer_trx_lines.interface_line_attribute3%type,
p_interface_line_attribute4 IN
ra_customer_trx_lines.interface_line_attribute4%type,
p_interface_line_attribute5 IN
ra_customer_trx_lines.interface_line_attribute5%type,
p_interface_line_attribute6 IN
ra_customer_trx_lines.interface_line_attribute6%type,
p_interface_line_attribute7 IN
ra_customer_trx_lines.interface_line_attribute7%type,
p_interface_line_attribute8 IN
ra_customer_trx_lines.interface_line_attribute8%type,
p_interface_line_attribute9 IN
ra_customer_trx_lines.interface_line_attribute9%type,
p_interface_line_attribute10 IN
ra_customer_trx_lines.interface_line_attribute10%type,
p_interface_line_attribute11 IN
ra_customer_trx_lines.interface_line_attribute11%type,
p_interface_line_attribute12 IN
ra_customer_trx_lines.interface_line_attribute12%type,
p_interface_line_attribute13 IN
ra_customer_trx_lines.interface_line_attribute13%type,
p_interface_line_attribute14 IN
ra_customer_trx_lines.interface_line_attribute14%type,
p_interface_line_attribute15 IN
ra_customer_trx_lines.interface_line_attribute15%type,
p_attribute_category IN
ra_customer_trx_lines.attribute_category%type,
p_attribute1 IN
ra_customer_trx_lines.attribute1%type,
p_attribute2 IN
ra_customer_trx_lines.attribute2%type,
p_attribute3 IN
ra_customer_trx_lines.attribute3%type,
p_attribute4 IN
ra_customer_trx_lines.attribute4%type,
p_attribute5 IN
ra_customer_trx_lines.attribute5%type,
p_attribute6 IN
ra_customer_trx_lines.attribute6%type,
p_attribute7 IN
ra_customer_trx_lines.attribute7%type,
p_attribute8 IN
ra_customer_trx_lines.attribute8%type,
p_attribute9 IN
ra_customer_trx_lines.attribute9%type,
p_attribute10 IN
ra_customer_trx_lines.attribute10%type,
p_attribute11 IN
ra_customer_trx_lines.attribute11%type,
p_attribute12 IN
ra_customer_trx_lines.attribute12%type,
p_attribute13 IN
ra_customer_trx_lines.attribute13%type,
p_attribute14 IN
ra_customer_trx_lines.attribute14%type,
p_attribute15 IN
ra_customer_trx_lines.attribute15%type,
p_customer_trx_line_id OUT NOCOPY
ra_customer_trx_lines.customer_trx_line_id%type,
p_gl_date IN OUT NOCOPY
ra_cust_trx_line_gl_dist.gl_date%type,
p_trx_date IN OUT NOCOPY
ra_customer_trx.trx_date%type,
p_header_currency_code IN
ra_customer_trx.invoice_currency_code%type,
p_header_exchange_rate IN
ra_customer_trx.exchange_rate%type,
p_amount_includes_tax_flag IN
ra_customer_trx_lines.amount_includes_tax_flag%type,
p_net_extended_amount OUT NOCOPY
ra_customer_trx_lines.extended_amount%type,
p_net_unit_selling_price OUT NOCOPY
ra_customer_trx_lines.unit_selling_price%type,
p_status OUT NOCOPY
varchar2 ,
p_global_attribute_category IN
ra_customer_trx_lines.global_attribute_category%type,
p_global_attribute1 IN
ra_customer_trx_lines.global_attribute1%type,
p_global_attribute2 IN
ra_customer_trx_lines.global_attribute2%type,
p_global_attribute3 IN
ra_customer_trx_lines.global_attribute3%type,
p_global_attribute4 IN
ra_customer_trx_lines.global_attribute4%type,
p_global_attribute5 IN
ra_customer_trx_lines.global_attribute5%type,
p_global_attribute6 IN
ra_customer_trx_lines.global_attribute6%type,
p_global_attribute7 IN
ra_customer_trx_lines.global_attribute7%type,
p_global_attribute8 IN
ra_customer_trx_lines.global_attribute8%type,
p_global_attribute9 IN
ra_customer_trx_lines.global_attribute9%type,
p_global_attribute10 IN
ra_customer_trx_lines.global_attribute10%type,
p_global_attribute11 IN
ra_customer_trx_lines.global_attribute11%type,
p_global_attribute12 IN
ra_customer_trx_lines.global_attribute12%type,
p_global_attribute13 IN
ra_customer_trx_lines.global_attribute13%type,
p_global_attribute14 IN
ra_customer_trx_lines.global_attribute14%type,
p_global_attribute15 IN
ra_customer_trx_lines.global_attribute15%type,
p_global_attribute16 IN
ra_customer_trx_lines.global_attribute16%type,
p_global_attribute17 IN
ra_customer_trx_lines.global_attribute17%type,
p_global_attribute18 IN
ra_customer_trx_lines.global_attribute18%type,
p_global_attribute19 IN
ra_customer_trx_lines.global_attribute19%type,
p_global_attribute20 IN
ra_customer_trx_lines.global_attribute20%type,
p_warehouse_id IN
ra_customer_trx_lines.warehouse_id%type,
p_translated_description IN
ra_customer_trx_lines.translated_description%type,
p_payment_set_id IN ra_customer_trx_lines.payment_set_id%type,
p_ship_to_customer_id IN
ra_customer_trx_lines.ship_to_customer_id%type DEFAULT NULL,
p_ship_to_site_use_id IN
ra_customer_trx_lines.ship_to_site_use_id%type DEFAULT NULL,
p_ship_to_contact_id IN
ra_customer_trx_lines.ship_to_contact_id%type DEFAULT NULL,
p_tax_classification_code IN
ra_customer_trx_lines.tax_classification_code%type DEFAULT NULL,
p_rule_end_date IN
ra_customer_trx_lines.rule_end_date%type DEFAULT NULL
)
IS
l_line_rec ra_customer_trx_lines%rowtype;
arp_util.debug('arp_insert_line_cover.insert_line_cover()+');
arp_util.debug('insert_line_cover: ' || 'ARTCTLIB: amount_includes_tax_flag = ' || l_line_rec.amount_includes_tax_flag);
arp_util.debug('insert_line_cover: ' || 'ARTCTLIB: header_currency_code = '|| p_header_currency_code);
arp_util.debug('insert_line_cover: ' || 'ARTCTLIB: header_exchange_rate = '|| p_header_exchange_rate);
arp_process_line.insert_line(
p_form_name,
p_form_version,
l_line_rec,
p_memo_line_type,
p_customer_trx_line_id,
p_trx_class,
p_ccid1,
p_ccid2,
p_amount1,
p_amount2,
p_rule_start_date,
p_accounting_rule_duration,
p_gl_date,
p_trx_date,
p_header_currency_code,
p_header_exchange_rate,
p_status );
arp_util.debug('EXCEPTION: arp_insert_line_cover.insert_line_cover()');
arp_util.debug('arp_insert_line_cover.insert_line_cover()-');
arp_util.debug('EXCEPTION: arp_insert_line_cover.insert_line_cover()');
arp_util.debug('------- parameters for insert_line_cover() ' ||
'---------');
arp_util.debug('insert_line_cover: ' || 'p_form_name = ' || p_form_name);
arp_util.debug('insert_line_cover: ' || 'p_form_version = ' || p_form_version);
arp_util.debug('insert_line_cover: ' || 'p_memo_line_type = ' || p_memo_line_type);
arp_util.debug('insert_line_cover: ' || 'p_trx_class = ' || p_trx_class);
arp_util.debug('insert_line_cover: ' || 'p_ccid1 = ' || p_ccid1);
arp_util.debug('insert_line_cover: ' || 'p_ccid2 = ' || p_ccid2);
arp_util.debug('insert_line_cover: ' || 'p_amount1 = ' || p_amount1);
arp_util.debug('insert_line_cover: ' || 'p_amount2 = ' || p_amount2);
arp_util.debug('insert_line_cover: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
arp_util.debug('insert_line_cover: ' || 'p_line_number = ' || p_line_number);
arp_util.debug('insert_line_cover: ' || 'p_line_type = ' || p_line_type);
arp_util.debug('insert_line_cover: ' || 'p_quantity_credited = ' || p_quantity_credited);
arp_util.debug('insert_line_cover: ' || 'p_quantity_invoiced = ' || p_quantity_invoiced);
arp_util.debug('insert_line_cover: ' || 'p_quantity_ordered = ' || p_quantity_ordered);
arp_util.debug('insert_line_cover: ' || 'p_unit_selling_price = ' || p_unit_selling_price);
arp_util.debug('insert_line_cover: ' || 'p_unit_standard_price = ' || p_unit_standard_price);
arp_util.debug('insert_line_cover: ' || 'p_revenue_amount = ' || p_revenue_amount);
arp_util.debug('insert_line_cover: ' || 'p_extended_amount = ' || p_extended_amount);
arp_util.debug('insert_line_cover: ' || 'p_memo_line_id = ' || p_memo_line_id);
arp_util.debug('insert_line_cover: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
arp_util.debug('insert_line_cover: ' || 'p_item_exception_rate_id = ' || p_item_exception_rate_id);
arp_util.debug('insert_line_cover: ' || 'p_description = ' || p_description);
arp_util.debug('insert_line_cover: ' || 'p_item_context = ' || p_item_context);
arp_util.debug('insert_line_cover: ' || 'p_initial_customer_trx_line_id = ' ||
p_initial_customer_trx_line_id);
arp_util.debug('insert_line_cover: ' || 'p_link_to_cust_trx_line_id = ' ||
p_link_to_cust_trx_line_id);
arp_util.debug('insert_line_cover: ' || 'p_previous_customer_trx_id = ' ||
p_previous_customer_trx_id);
arp_util.debug('insert_line_cover: ' || 'p_prev_customer_trx_line_id = ' ||
p_prev_customer_trx_line_id);
arp_util.debug('insert_line_cover: ' || 'p_accounting_rule_duration = ' ||
p_accounting_rule_duration);
arp_util.debug('insert_line_cover: ' || 'p_accounting_rule_id = ' || p_accounting_rule_id);
arp_util.debug('insert_line_cover: ' || 'p_rule_start_date = ' || p_rule_start_date);
arp_util.debug('insert_line_cover: ' || 'p_autorule_complete_flag = ' || p_autorule_complete_flag);
arp_util.debug('insert_line_cover: ' || 'p_autorule_duration_processed = ' ||
p_autorule_duration_processed);
arp_util.debug('insert_line_cover: ' || 'p_reason_code = ' || p_reason_code);
arp_util.debug('insert_line_cover: ' || 'p_last_period_to_credit = ' || p_last_period_to_credit);
arp_util.debug('insert_line_cover: ' || 'p_sales_order = ' || p_sales_order);
arp_util.debug('insert_line_cover: ' || 'p_sales_order_date = ' || p_sales_order_date);
arp_util.debug('insert_line_cover: ' || 'p_sales_order_line = ' || p_sales_order_line);
arp_util.debug('insert_line_cover: ' || 'p_sales_order_revision = ' || p_sales_order_revision);
arp_util.debug('insert_line_cover: ' || 'p_sales_order_source = ' || p_sales_order_source);
arp_util.debug('insert_line_cover: ' || 'p_vat_tax_id = ' || p_vat_tax_id);
arp_util.debug('insert_line_cover: ' || 'p_tax_exempt_flag = ' || p_tax_exempt_flag);
arp_util.debug('insert_line_cover: ' || 'p_sales_tax_id = ' || p_sales_tax_id);
arp_util.debug('insert_line_cover: ' || 'p_location_segment_id = ' || p_location_segment_id);
arp_util.debug('insert_line_cover: ' || 'p_tax_exempt_number = ' || p_tax_exempt_number);
arp_util.debug('insert_line_cover: ' || 'p_tax_exempt_reason_code = ' || p_tax_exempt_reason_code);
arp_util.debug('insert_line_cover: ' || 'p_tax_vendor_return_code = ' || p_tax_vendor_return_code);
arp_util.debug('insert_line_cover: ' || 'p_taxable_flag = ' || p_taxable_flag);
arp_util.debug('insert_line_cover: ' || 'p_tax_exemption_id = ' || p_tax_exemption_id);
arp_util.debug('insert_line_cover: ' || 'p_tax_precedence = ' || p_tax_precedence);
arp_util.debug('insert_line_cover: ' || 'p_tax_rate = ' || p_tax_rate);
arp_util.debug('insert_line_cover: ' || 'p_uom_code = ' || p_uom_code);
arp_util.debug('insert_line_cover: ' || 'p_autotax = ' || p_autotax);
arp_util.debug('insert_line_cover: ' || 'p_movement_id = ' || p_movement_id);
arp_util.debug('insert_line_cover: ' || 'p_default_ussgl_trx_code = ' ||
p_default_ussgl_trx_code);
arp_util.debug('insert_line_cover: ' || 'p_default_ussgl_trx_code_cntxt = ' ||
p_default_ussgl_trx_code_cntxt);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_context = ' || p_interface_line_context);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute1 = ' ||
p_interface_line_attribute1);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute2 = ' ||
p_interface_line_attribute2);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute3 = ' ||
p_interface_line_attribute3);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute4 = ' ||
p_interface_line_attribute4);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute5 = ' ||
p_interface_line_attribute5);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute6 = ' ||
p_interface_line_attribute6);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute7 = ' ||
p_interface_line_attribute7);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute8 = ' ||
p_interface_line_attribute8);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute9 = ' ||
p_interface_line_attribute9);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute10 = ' ||
p_interface_line_attribute10);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute11 = ' ||
p_interface_line_attribute11);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute12 = ' ||
p_interface_line_attribute12);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute13 = ' ||
p_interface_line_attribute13);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute14 = ' ||
p_interface_line_attribute14);
arp_util.debug('insert_line_cover: ' || 'p_interface_line_attribute15 = ' ||
p_interface_line_attribute15);
arp_util.debug('insert_line_cover: ' || 'p_attribute_category = ' || p_attribute_category);
arp_util.debug('insert_line_cover: ' || 'p_attribute1 = ' || p_attribute1);
arp_util.debug('insert_line_cover: ' || 'p_attribute2 = ' || p_attribute2);
arp_util.debug('insert_line_cover: ' || 'p_attribute3 = ' || p_attribute3);
arp_util.debug('insert_line_cover: ' || 'p_attribute4 = ' || p_attribute4);
arp_util.debug('insert_line_cover: ' || 'p_attribute5 = ' || p_attribute5);
arp_util.debug('insert_line_cover: ' || 'p_attribute6 = ' || p_attribute6);
arp_util.debug('insert_line_cover: ' || 'p_attribute7 = ' || p_attribute7);
arp_util.debug('insert_line_cover: ' || 'p_attribute8 = ' || p_attribute8);
arp_util.debug('insert_line_cover: ' || 'p_attribute9 = ' || p_attribute9);
arp_util.debug('insert_line_cover: ' || 'p_attribute10 = ' || p_attribute10);
arp_util.debug('insert_line_cover: ' || 'p_attribute11 = ' || p_attribute11);
arp_util.debug('insert_line_cover: ' || 'p_attribute12 = ' || p_attribute12);
arp_util.debug('insert_line_cover: ' || 'p_attribute13 = ' || p_attribute13);
arp_util.debug('insert_line_cover: ' || 'p_attribute14 = ' || p_attribute14);
arp_util.debug('insert_line_cover: ' || 'p_attribute15 = ' || p_attribute15);
arp_util.debug('insert_line_cover: ' || 'amount_includes_tax_flag = ' || p_amount_includes_tax_flag);
arp_util.debug('insert_line_cover: ' || 'header_currency_code = '|| p_header_currency_code);
arp_util.debug('insert_line_cover: ' || 'header_exchange_rate = '|| p_header_exchange_rate);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute_category = ' || p_global_attribute_category);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute1 = ' || p_global_attribute1);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute2 = ' || p_global_attribute2);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute3 = ' || p_global_attribute3);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute4 = ' || p_global_attribute4);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute5 = ' || p_global_attribute5);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute6 = ' || p_global_attribute6);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute7 = ' || p_global_attribute7);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute8 = ' || p_global_attribute8);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute9 = ' || p_global_attribute9);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute10 = ' || p_global_attribute10);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute11 = ' || p_global_attribute11);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute12 = ' || p_global_attribute12);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute13 = ' || p_global_attribute13);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute14 = ' || p_global_attribute14);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute15 = ' || p_global_attribute15);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute16 = ' || p_global_attribute16);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute17 = ' || p_global_attribute17);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute18 = ' || p_global_attribute18);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute19 = ' || p_global_attribute19);
arp_util.debug('insert_line_cover: ' || 'p_global_attribute20 = ' || p_global_attribute20);
arp_util.debug('insert_line_cover: ' || 'p_warehouse_id = ' || p_warehouse_id);
arp_util.debug('insert_line_cover: ' || 'p_translated_description = ' || p_translated_description);
arp_util.debug('insert_line_cover: ' || 'p_payment_set_id = ' || p_payment_set_id);
arp_util.debug('insert_line_cover: ' || 'p_rule_end_date = ' || p_rule_end_date);
END insert_line_cover;