[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM ar_payments_interface
WHERE rowid = p_row_id
FOR UPDATE of transmission_record_id NOWAIT;
FND_MESSAGE.Set_Name( 'FND', 'FORM_RECORD_DELETED');
PROCEDURE update_trans_data(
p_transmission_record_id IN NUMBER,
p_lockbox_number IN VARCHAR2,
p_batch_name IN VARCHAR2,
p_item_number IN VARCHAR2,
p_check_number IN VARCHAR2,
p_overflow_sequence IN NUMBER,
p_record_type IN VARCHAR2,
p_comments IN VARCHAR2,
p_origination IN VARCHAR2,
p_destination_account IN VARCHAR2,
p_deposit_date IN DATE,
p_gl_date IN DATE,
p_deposit_time IN VARCHAR2,
p_currency_code IN VARCHAR2,
p_exchange_rate_type IN VARCHAR2,
p_exchange_rate IN NUMBER,
p_transmission_record_count IN NUMBER,
p_transmission_amount IN NUMBER,
p_lockbox_batch_count IN NUMBER,
p_lockbox_amount IN NUMBER,
p_lockbox_record_count IN NUMBER,
p_batch_record_count IN NUMBER,
p_batch_amount IN NUMBER,
p_transferred_receipt_count IN NUMBER,
p_transferred_receipt_amount IN NUMBER,
p_overflow_indicator IN VARCHAR2,
p_receipt_date IN DATE,
p_receipt_method IN VARCHAR2,
p_receipt_method_id IN NUMBER,
p_remittance_amount IN NUMBER,
p_customer_number IN VARCHAR2,
p_customer_id IN NUMBER,
p_bill_to_location IN VARCHAR2,
p_customer_site_use_id IN NUMBER,
p_transit_routing_number IN VARCHAR2,
p_account IN VARCHAR2,
p_customer_bank_account_id IN NUMBER,
p_amount_applied1 IN NUMBER,
p_invoice1 IN VARCHAR2,
p_invoice1_installment IN NUMBER,
p_invoice1_status IN VARCHAR2,
p_amount_applied2 IN NUMBER,
p_invoice2 IN VARCHAR2,
p_invoice2_installment IN NUMBER,
p_invoice2_status IN VARCHAR2,
p_amount_applied3 IN NUMBER,
p_invoice3 IN VARCHAR2,
p_invoice3_installment IN NUMBER,
p_invoice3_status IN VARCHAR2,
p_amount_applied4 IN NUMBER,
p_invoice4 IN VARCHAR2,
p_invoice4_installment IN NUMBER,
p_invoice4_status IN VARCHAR2,
p_amount_applied5 IN NUMBER,
p_invoice5 IN VARCHAR2,
p_invoice5_installment IN NUMBER,
p_invoice5_status IN VARCHAR2,
p_amount_applied6 IN NUMBER,
p_invoice6 IN VARCHAR2,
p_invoice6_installment IN NUMBER,
p_invoice6_status IN VARCHAR2,
p_amount_applied7 IN NUMBER,
p_invoice7 IN VARCHAR2,
p_invoice7_installment IN NUMBER,
p_invoice7_status IN VARCHAR2,
p_amount_applied8 IN NUMBER,
p_invoice8 IN VARCHAR2,
p_invoice8_installment IN NUMBER,
p_invoice8_status IN VARCHAR2,
p_attribute1 IN VARCHAR2,
p_attribute2 IN VARCHAR2,
p_attribute3 IN VARCHAR2,
p_attribute4 IN VARCHAR2,
p_attribute5 IN VARCHAR2,
p_attribute6 IN VARCHAR2,
p_attribute7 IN VARCHAR2,
p_attribute8 IN VARCHAR2,
p_attribute9 IN VARCHAR2,
p_attribute10 IN VARCHAR2,
p_attribute11 IN VARCHAR2,
p_attribute12 IN VARCHAR2,
p_attribute13 IN VARCHAR2,
p_attribute14 IN VARCHAR2,
p_attribute15 IN VARCHAR2,
p_status IN VARCHAR2,
p_matching1_date IN DATE,
p_matching2_date IN DATE,
p_matching3_date IN DATE,
p_matching4_date IN DATE,
p_matching5_date IN DATE,
p_matching6_date IN DATE,
p_matching7_date IN DATE,
p_matching8_date IN DATE,
p_amount_applied_from1 IN NUMBER,
p_trans_to_receipt_rate1 IN NUMBER,
p_invoice_currency_code1 IN VARCHAR2,
p_amount_applied_from2 IN NUMBER,
p_trans_to_receipt_rate2 IN NUMBER,
p_invoice_currency_code2 IN VARCHAR2,
p_amount_applied_from3 IN NUMBER,
p_trans_to_receipt_rate3 IN NUMBER,
p_invoice_currency_code3 IN VARCHAR2,
p_amount_applied_from4 IN NUMBER,
p_trans_to_receipt_rate4 IN NUMBER,
p_invoice_currency_code4 IN VARCHAR2,
p_amount_applied_from5 IN NUMBER,
p_trans_to_receipt_rate5 IN NUMBER,
p_invoice_currency_code5 IN VARCHAR2,
p_amount_applied_from6 IN NUMBER,
p_trans_to_receipt_rate6 IN NUMBER,
p_invoice_currency_code6 IN VARCHAR2,
p_amount_applied_from7 IN NUMBER,
p_trans_to_receipt_rate7 IN NUMBER,
p_invoice_currency_code7 IN VARCHAR2,
p_amount_applied_from8 IN NUMBER,
p_trans_to_receipt_rate8 IN NUMBER,
p_invoice_currency_code8 IN VARCHAR2,
p_ussgl_transaction_code IN VARCHAR2,
p_ussgl_transaction_code1 IN VARCHAR2,
p_ussgl_transaction_code2 IN VARCHAR2,
p_ussgl_transaction_code3 IN VARCHAR2,
p_ussgl_transaction_code4 IN VARCHAR2,
p_ussgl_transaction_code5 IN VARCHAR2,
p_ussgl_transaction_code6 IN VARCHAR2,
p_ussgl_transaction_code7 IN VARCHAR2,
p_ussgl_transaction_code8 IN VARCHAR2
) IS
l_dummy NUMBER;
arp_util.debug('arp_lockbox_pkg.update_trans_data()+');
SELECT transmission_record_id
INTO l_dummy
FROM ar_payments_interface
WHERE transmission_record_id = p_transmission_record_id
FOR UPDATE NOWAIT; */
l_break_point := 'update record';
UPDATE ar_payments_interface
SET lockbox_number = p_lockbox_number,
batch_name = p_batch_name,
item_number = p_item_number,
check_number = p_check_number,
overflow_sequence = p_overflow_sequence,
record_type = p_record_type,
comments = p_comments,
origination = p_origination,
destination_account = p_destination_account,
deposit_date = p_deposit_date,
gl_date = p_gl_date,
deposit_time = p_deposit_time,
currency_code = p_currency_code,
exchange_rate_type = p_exchange_rate_type,
exchange_rate = p_exchange_rate,
transmission_record_count = p_transmission_record_count,
transmission_amount = p_transmission_amount,
lockbox_batch_count = p_lockbox_batch_count,
lockbox_amount = p_lockbox_amount,
lockbox_record_count = p_lockbox_record_count,
batch_record_count = p_batch_record_count,
batch_amount = p_batch_amount,
transferred_receipt_count = p_transferred_receipt_count,
transferred_receipt_amount = p_transferred_receipt_amount,
overflow_indicator = p_overflow_indicator,
receipt_date = p_receipt_date,
receipt_method = p_receipt_method,
receipt_method_id = p_receipt_method_id,
remittance_amount = p_remittance_amount,
customer_number = p_customer_number,
customer_id = p_customer_id,
bill_to_location = p_bill_to_location,
customer_site_use_id = p_customer_site_use_id,
transit_routing_number = p_transit_routing_number,
account = p_account,
customer_bank_account_id = p_customer_bank_account_id,
amount_applied1 = p_amount_applied1,
invoice1 = p_invoice1,
invoice1_installment = p_invoice1_installment,
invoice1_status = p_invoice1_status,
amount_applied2 = p_amount_applied2,
invoice2 = p_invoice2,
invoice2_installment = p_invoice2_installment,
invoice2_status = p_invoice2_status,
amount_applied3 = p_amount_applied3,
invoice3 = p_invoice3,
invoice3_installment = p_invoice3_installment,
invoice3_status = p_invoice3_status,
amount_applied4 = p_amount_applied4,
invoice4 = p_invoice4,
invoice4_installment = p_invoice4_installment,
invoice4_status = p_invoice4_status,
amount_applied5 = p_amount_applied5,
invoice5 = p_invoice5,
invoice5_installment = p_invoice5_installment,
invoice5_status = p_invoice5_status,
amount_applied6 = p_amount_applied6,
invoice6 = p_invoice6,
invoice6_installment = p_invoice6_installment,
invoice6_status = p_invoice6_status,
amount_applied7 = p_amount_applied7,
invoice7 = p_invoice7,
invoice7_installment = p_invoice7_installment,
invoice7_status = p_invoice7_status,
amount_applied8 = p_amount_applied8,
invoice8 = p_invoice8,
invoice8_installment = p_invoice8_installment,
invoice8_status = p_invoice8_status,
attribute1 = p_attribute1,
attribute2 = p_attribute2,
attribute3 = p_attribute3,
attribute4 = p_attribute4,
attribute5 = p_attribute5,
attribute6 = p_attribute6,
attribute7 = p_attribute7,
attribute8 = p_attribute8,
attribute9 = p_attribute9,
attribute10 = p_attribute10,
attribute11 = p_attribute11,
attribute12 = p_attribute12,
attribute13 = p_attribute13,
attribute14 = p_attribute14,
attribute15 = p_attribute15,
status = p_status,
matching1_date = p_matching1_date,
matching2_date = p_matching2_date,
matching3_date = p_matching3_date,
matching4_date = p_matching4_date,
matching5_date = p_matching5_date,
matching6_date = p_matching6_date,
matching7_date = p_matching7_date,
matching8_date = p_matching8_date,
amount_applied_from1 = p_amount_applied_from1,
trans_to_receipt_rate1 = p_trans_to_receipt_rate1,
invoice_currency_code1 = p_invoice_currency_code1,
amount_applied_from2 = p_amount_applied_from2,
trans_to_receipt_rate2 = p_trans_to_receipt_rate2,
invoice_currency_code2= p_invoice_currency_code2,
amount_applied_from3 = p_amount_applied_from3,
trans_to_receipt_rate3 = p_trans_to_receipt_rate3,
invoice_currency_code3= p_invoice_currency_code3,
amount_applied_from4 = p_amount_applied_from4,
trans_to_receipt_rate4 = p_trans_to_receipt_rate4,
invoice_currency_code4= p_invoice_currency_code4,
amount_applied_from5 = p_amount_applied_from5,
trans_to_receipt_rate5 = p_trans_to_receipt_rate5,
invoice_currency_code5= p_invoice_currency_code5,
amount_applied_from6 = p_amount_applied_from6,
trans_to_receipt_rate6 = p_trans_to_receipt_rate6,
invoice_currency_code6= p_invoice_currency_code6,
amount_applied_from7 = p_amount_applied_from7,
trans_to_receipt_rate7 = p_trans_to_receipt_rate7,
invoice_currency_code7= p_invoice_currency_code7,
amount_applied_from8 = p_amount_applied_from8,
trans_to_receipt_rate8 = p_trans_to_receipt_rate8,
invoice_currency_code8= p_invoice_currency_code8,
ussgl_transaction_code = p_ussgl_transaction_code,
ussgl_transaction_code1 = p_ussgl_transaction_code1,
ussgl_transaction_code2 = p_ussgl_transaction_code2,
ussgl_transaction_code3 = p_ussgl_transaction_code3,
ussgl_transaction_code4 = p_ussgl_transaction_code4,
ussgl_transaction_code5 = p_ussgl_transaction_code5,
ussgl_transaction_code6 = p_ussgl_transaction_code6,
ussgl_transaction_code7 = p_ussgl_transaction_code7,
ussgl_transaction_code8 = p_ussgl_transaction_code8
WHERE transmission_record_id = p_transmission_record_id;
arp_util.debug('arp_lockbox_pkg.update_trans_data()-');
arp_standard.debug('update_trans_data: ' ||
'EXCEPTION: arp_lockbox_pkg.update_trans_data when '||
l_break_point);
END update_trans_data;
PROCEDURE delete_trans_data(
p_transmission_record_id IN NUMBER ) IS
l_dummy NUMBER;
arp_util.debug('arp_lockbox_pkg.delete_trans_data()+');
SELECT transmission_record_id
INTO l_dummy
FROM ar_payments_interface
WHERE transmission_record_id = p_transmission_record_id
FOR UPDATE NOWAIT; */
l_break_point := 'delete record';
DELETE ar_payments_interface
WHERE transmission_record_id = p_transmission_record_id;
arp_util.debug('arp_lockbox_pkg.delete_trans_data()-');
arp_standard.debug('delete_trans_data: ' ||
'EXCEPTION: arp_lockbox_pkg.delete_trans_data when '||
l_break_point);
END delete_trans_data;
SELECT distinct(batch_name)
INTO l_batch_name
FROM ar_payments_interface
WHERE lockbox_number = p_lockbox_number
AND transmission_id = p_transmission_id
AND batch_name is NOT NULL;
SELECT distinct(batch_name)
INTO l_batch_name
FROM ar_payments_interface
WHERE item_number = p_item_num
AND transmission_id = p_transmission_id
AND batch_name is NOT NULL;
SELECT distinct(lockbox_number)
INTO l_lockbox_number
FROM ar_payments_interface
WHERE batch_name = p_batch_name
AND transmission_id = p_transmission_id
AND lockbox_number is NOT NULL;
SELECT distinct(lockbox_number)
INTO l_lockbox_number
FROM ar_payments_interface
WHERE item_number = p_item_num
AND transmission_id = p_transmission_id
AND lockbox_number is NOT NULL;