APPS.JL_AR_RECUR_PKG SQL Statements

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

Line: 10

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);

Line: 31

    arp_util.debug('arp_process_recur.insert_p()+');

Line: 46

          SELECT MIN(org_id)
          INTO   l_org_id
          FROM   ar_system_parameters;

Line: 59

                          '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);

Line: 81

       jl_ar_ar_prefix_trx_num.update_trx_number_date(
                      p_batch_source_id,
                      l_trx_number,
                      l_trx_date);

Line: 90

     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);

Line: 126

   arp_util.debug('arp_process_recur.insert_p()-');

Line: 130

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