APPS.ARP_PROCESS_RECUR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 35

            SELECT  auto_trx_numbering_flag
            INTO   l_auto_trx_numbering_flag
            FROM   RA_BATCH_SOURCES
            WHERE  batch_source_id = p_batch_source_id;

Line: 59

   arp_ctl_sum_pkg.select_summary(p_customer_trx_id ,
                                  p_line_type,
                                  l_amount_trx,
                                  l_amount_trx_total_rtot_db);

Line: 72

PROCEDURE insert_recur(    p_form_name         IN varchar2,
                           p_form_version      IN number,
                           p_rec_rec           IN ra_recur_interim%rowtype,
                           p_batch_source_id   IN ra_batch_sources.batch_source_id%type,
                           p_cust_trx_type_id  IN number,
                           p_trx_no  OUT NOCOPY ra_recur_interim.trx_number%type) IS

    l_trx_no ra_recur_interim.trx_number%type;

Line: 95

     ARP_RECUR_PKG.insert_p(p_rec_rec, p_batch_source_id,l_trx_no);

Line: 98

     arp_util.debug('  insert_recur            : '||l_trx_no );

Line: 103

     arp_util.debug('EXCEPTION: arp_process_recur.insert_recur()');