The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_interim(
p_customer_trx_id IN ra_recur_interim.customer_trx_id%type,
p_trx_date IN DATE,
p_term_due_date IN DATE,
p_gl_date IN DATE,
p_term_discount_date IN DATE,
p_request_id IN ra_recur_interim.request_id%type,
p_doc_sequence_value IN ra_recur_interim.doc_sequence_value%type,
p_new_customer_trx_id IN ra_recur_interim.new_customer_trx_id%type,
p_batch_source_id IN ra_batch_sources.batch_source_id%type,
p_trx_number_out OUT ra_recur_interim.trx_number%type) IS
l_country_code VARCHAR2(2);
arp_util.debug('arp_process_recur.insert_p()+');
SELECT MIN(org_id)
INTO l_org_id
FROM ar_system_parameters;
'select ra_trx_number_' ||
REPLACE(p_batch_source_id, '-', 'N') ||
l_org_str||
'_s.nextval trx_number ' ||
'from ra_batch_sources ' ||
'where batch_source_id = ' ||
p_batch_source_id ||
' and auto_trx_numbering_flag = ''Y''',
dbms_sql.v7);
jl_ar_ar_prefix_trx_num.update_trx_number_date(
p_batch_source_id,
l_trx_number,
l_trx_date);
INSERT INTO ra_recur_interim
(
customer_trx_id,
trx_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
trx_date,
term_due_date,
gl_date,
term_discount_date,
request_id,
doc_sequence_value,
new_customer_trx_id)
VALUES
(
p_customer_trx_id,
l_trx_number,
pg_user_id,
sysdate,
pg_user_id,
sysdate,
nvl(pg_conc_login_id,
pg_login_id),
l_trx_date,
p_term_due_date,
p_gl_date,
p_term_discount_date ,
p_request_id,
p_doc_sequence_value,
p_new_customer_trx_id);
arp_util.debug('arp_process_recur.insert_p()-');
arp_util.debug('EXCEPTION: arp_process_recur.insert_p()');