The following lines contain the word 'select', 'insert', 'update' or 'delete':
select invoice_currency_code, org_id
from ra_customer_trx
where customer_trx_id = l_disp_header_rec.cust_trx_id;
select TRX_TYPE.creation_sign, TRX_TYPE.CREDIT_MEMO_TYPE_ID into l_creationSign, l_credit_memo_type_id
from ra_cust_trx_types TRX_TYPE,
ra_customer_trx TRX
where TRX.CUST_TRX_TYPE_ID = TRX_TYPE.CUST_TRX_TYPE_ID and
TRX.Customer_Trx_ID = l_disp_header_rec.cust_trx_id;
select decode(l_disp_header_rec.line_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.line_amt) into l_line
from dual;
select decode(l_disp_header_rec.tax_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.tax_amt) into l_tax
from dual;
select decode(l_disp_header_rec.freight_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.freight_amt) into l_freight
from dual;
SELECT UNIT_SELLING_PRICE
INTO l_disp_line_tbl(i).price
FROM ra_customer_trx_lines
WHERE customer_trx_line_id = l_disp_line_tbl(i).customer_trx_line_id;
SELECT iex_disputes_s.nextval INTO l_dis_id FROM dual;
IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Inserting a dispute row in IEX_DISPUTES');
IEX_DISPUTES_PKG.Insert_Row(x_rowid => x,
p_dispute_id => l_dis_id,
p_last_update_date => sysdate,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => sysdate,
p_created_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.USER_ID,
p_cm_request_id => l_request_id,
p_dispute_section => p_disp_header_rec.dispute_section,
p_delinquency_id => p_disp_header_rec.delinquency_id);
IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Insert Failed');
select count(1) into l_count
from iex_disputes
where DELINQUENCY_ID = l_delinquency_id ;
select cm_request_id into l_request_id
from iex_disputes
where delinquency_id = l_delinquency_id ;
select status into l_status
from ra_cm_requests
where request_id = l_request_id ;
l_last_updated_by NUMBER;
l_last_update_login NUMBER;
l_last_update_date DATE;
SELECT payment_schedule_id,
due_date,
amount_in_dispute,
dispute_date
FROM ar_payment_schedules ps
WHERE ps.customer_trx_id = p_customer_trx_id;
SELECT item_type
FROM wf_items
WHERE item_key = l_item_key
AND item_type IN('ARCMREQ', 'ARAMECM');
select party_id
from hz_cust_accounts
where cust_account_id = p_cust_acct_id;
select bill_to_site_use_id
from ra_customer_trx
where customer_trx_id = p_cust_trx_id;
select customer_id,payment_schedule_id
from ar_payment_schedules
where customer_trx_id = p_cust_trx_id;
SELECT org_id
INTO l_org_id
FROM ra_cm_requests_all
WHERE request_id = p_dispute_id;
SELECT total_amount * -1
INTO remove_from_dispute_amt
FROM ra_cm_requests
WHERE request_id = p_dispute_id;
arp_process_cutil.update_ps(p_ps_id => ps_rec.payment_schedule_id,
p_due_date => ps_rec.due_date,
p_amount_in_dispute => new_dispute_amt,
p_dispute_date => new_dispute_date,
p_update_dff => 'N',
p_attribute_category => NULL,
p_attribute1 => NULL,
p_attribute2 => NULL,
p_attribute3 => NULL,
p_attribute4 => NULL,
p_attribute5 => NULL,
p_attribute6 => NULL,
p_attribute7 => NULL,
p_attribute8 => NULL,
p_attribute9 => NULL,
p_attribute10 => NULL,
p_attribute11 => NULL,
p_attribute12 => NULL,
p_attribute13 => NULL,
p_attribute14 => NULL,
p_attribute15 => NULL);
IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: After arp_process_cutil.update_ps for p_ps_id => ' || ps_rec.payment_schedule_id);
l_debug_mesg := 'Insert Rejected Response notes';
IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: Insert Rejected Response notes');
l_last_updated_by := arp_global.user_id;
l_last_update_login := arp_global.last_update_login;
IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: l_last_updated_by: ' || l_last_updated_by || ' l_last_update_login: '|| l_last_update_login);
SELECT customer_trx_id
INTO l_customer_trx_id
FROM ra_cm_requests
WHERE request_id = l_document_id;
l_debug_mesg := 'Insert call topic notes';
l_last_update_login := arp_global.last_update_login;
l_last_update_date := sysdate;
l_last_updated_by := fnd_global.user_id;
IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: Before calling arp_notes_pkg.insert_cover');
arp_notes_pkg.insert_cover(
p_note_type => 'MAINTAIN',
p_text => l_note_text,
p_customer_call_id => null,
p_customer_call_topic_id => null,
p_call_action_id => NULL,
p_customer_trx_id => l_customer_trx_id,
p_note_id => l_note_id,
p_last_updated_by => l_last_updated_by,
p_last_update_date => l_last_update_date,
p_last_update_login => l_last_update_login,
p_created_by => l_created_by,
p_creation_date => l_creation_date);
IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: After calling arp_notes_pkg.insert_cover');