70: End;
71:
72: PROCEDURE insert_recur( p_form_name IN varchar2,
73: p_form_version IN number,
74: p_rec_rec IN ra_recur_interim%rowtype,
75: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
76: p_cust_trx_type_id IN number,
77: p_trx_no OUT NOCOPY ra_recur_interim.trx_number%type) IS
78:
73: p_form_version IN number,
74: p_rec_rec IN ra_recur_interim%rowtype,
75: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
76: p_cust_trx_type_id IN number,
77: p_trx_no OUT NOCOPY ra_recur_interim.trx_number%type) IS
78:
79: l_trx_no ra_recur_interim.trx_number%type;
80:
81: Begin
75: p_batch_source_id IN ra_batch_sources.batch_source_id%type,
76: p_cust_trx_type_id IN number,
77: p_trx_no OUT NOCOPY ra_recur_interim.trx_number%type) IS
78:
79: l_trx_no ra_recur_interim.trx_number%type;
80:
81: Begin
82:
83: -- validate that the transaction and document numbers are unique