APPS.JL_AR_AR_PREFIX_TRX_NUM SQL Statements

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

Line: 4

PROCEDURE update_trx_number_date (
  p_batch_source_id           IN     ra_customer_trx_all.batch_source_id%TYPE,
  p_trx_number                IN OUT NOCOPY ra_customer_trx_all.trx_number%TYPE,
  p_trx_date                  IN OUT NOCOPY ra_customer_trx_all.trx_date%TYPE )
IS

  l_trx_num_cursor          INTEGER;

Line: 32

     SELECT auto_trx_numbering_flag,
            batch_source_type,
            to_number(global_attribute1),
            substr(global_attribute2,1,4),
            substr(global_attribute3,1,1),
            to_date(global_attribute4,'YYYY/MM/DD HH24:MI:SS')
     INTO   l_auto_trx_numbering_flag,
            l_batch_source_type,
            l_imported_source_id,
            l_branch_number,
            l_document_letter,
            l_last_trx_date
     FROM   ra_batch_sources
     WHERE  batch_source_id = p_batch_source_id;

Line: 52

                       'select ra_trx_number_' ||
                       to_char(l_imported_source_id) ||
                       '_' ||
                       to_char(l_org_id)||
                       '_s.nextval trx_number ' ||
                       'from dual ',
                       dbms_sql.NATIVE);

Line: 68

        SELECT substr(global_attribute2,1,4),
               substr(global_attribute3,1,1),
               to_date(global_attribute4,'YYYY/MM/DD HH24:MI:SS')
        INTO   l_branch_number,
               l_document_letter,
               l_last_trx_date
        FROM   ra_batch_sources
        WHERE  batch_source_id = l_imported_source_id;

Line: 97

END update_trx_number_date;