APPS.AR_BPA_BFPRI_CONC SQL Statements

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

Line: 343

select_stmt      varchar2(1000);

Line: 354

   select  substr(userenv('LANG'),1,4)
   into    userenv_lang
   from    dual;

Line: 359

   select  language_code
   into    base_lang
   from    fnd_languages
   where   installed_flag = 'B';

Line: 459

  select_stmt :=
      '  select distinct(nvl(rtrim(substr(loc.language,1,4)), ''' || userenv_lang || ''')) language ' || cr ||
         build_from_clause;

Line: 476

  sql_stmt := select_stmt || cr || p_where;

Line: 567

insert_stmt         varchar2(240);

Line: 568

select_stmt         varchar2(2048);

Line: 570

inserted_row_counts  INTEGER;

Line: 604

      select  substr(userenv('LANG'),1,4)
      into    userenv_lang
      from    dual;

Line: 609

      select  language_code
      into    base_lang
      from    fnd_languages
      where   installed_flag = 'B';*/

Line: 637

      insert_stmt := '  insert into ar_bpa_print_requests (request_id, payment_schedule_id,
			worker_id, created_by, creation_date,last_updated_by, last_update_date)';

Line: 641

      select_stmt := '  select  ' || m_request_id || ', to_number(cons_billing_number), rownum, 1, sysdate, 1, sysdate from '
                     || cr ||' ( select cons.cons_billing_number '|| cr || build_from_clause ||
              '  AND nvl(loc.language,' || '''' || userenv_lang || ''') = ' || '''' || userenv_lang || '''' ;

Line: 659

	    sql_stmt := insert_stmt || cr || select_stmt || cr || p_where || ')';

Line: 683

      inserted_row_counts := dbms_sql.execute(sql_stmt_c);

Line: 684

      fnd_file.put_line( fnd_file.log, 'inserted row count: ' || inserted_row_counts);

Line: 686

      IF inserted_row_counts > 0 THEN

        -- update the last printed date for all the transactions that are being printed.
        -- bug 6955957
        update ra_customer_trx_all trx set trx.printing_last_printed = sysdate where trx.trx_number in
        (select cons.trx_number from ar_cons_inv_trx_all cons, ar_bpa_print_requests pri
          where pri.request_id = m_request_id
          and pri.payment_schedule_id = cons.cons_inv_id
        );

Line: 696

        divided_worker_counts := ceil(inserted_row_counts/l_job_size);

Line: 697

        row_counts_perworker  := ceil(inserted_row_counts/divided_worker_counts);

Line: 707

            UPDATE ar_bpa_print_requests
                SET worker_id = l_worker_id
                WHERE request_id = m_request_id
                AND worker_id BETWEEN  l_low_range AND l_high_range;

Line: 746

                                        request_data => to_char(inserted_row_counts));

Line: 769

                   SELECT request_id, status_code
                   FROM fnd_concurrent_requests
                   WHERE parent_request_id = p_request_id;

Line: 796

	DELETE FROM ar_bpa_print_requests
	WHERE request_id = m_request_id;

Line: 820

lang_selector VARCHAR2(1024);

Line: 826

select_stmt   VARCHAR2(1024);

Line: 827

select_cur    INTEGER;

Line: 831

inserted_row_counts   INTEGER;

Line: 847

   SELECT    language_code
     INTO    base_lang
     FROM    fnd_languages
     WHERE   installed_flag = 'B';

Line: 853

	  lang_selector := '  select distinct(nvl(rtrim(substr(a_bill.language,1,4)), '''
			|| base_lang || ''')) language ' || cr || build_from_clause
			|| ' AND cons.cons_inv_id in ('|| p_id_list || ' )' ;

Line: 858

   OPEN lang_cv FOR lang_selector;

Line: 865

      SELECT  nls_language, nls_territory
        INTO  nls_lang, nls_terr
        FROM  FND_LANGUAGES
        WHERE language_code = lang_code;

Line: 870

      select_stmt := ' SELECT to_number(cons.cons_billing_number) ' || cr || build_from_clause || cr ||
                    ' AND cons.cons_inv_id in ('|| p_id_list || ' ) ' || cr ||
                    ' AND nvl(a_bill.language, ''' || base_lang ||''' ) = :lang_code ';

Line: 874

      select_cur := dbms_sql.open_cursor;

Line: 875

      dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );

Line: 877

      dbms_sql.bind_variable(select_cur,':lang_code', lang_code );

Line: 878

      dbms_sql.define_array(select_cur,1,ps_id,500,1 );

Line: 879

      ignore := dbms_sql.execute(select_cur);

Line: 882

         fetched_row_count := dbms_sql.fetch_rows(select_cur);

Line: 883

         dbms_sql.column_value(select_cur,1,ps_id);

Line: 887

      dbms_sql.close_cursor(select_cur);

Line: 889

      inserted_row_counts := ps_id.COUNT    ;

Line: 891

      divided_worker_counts := ceil(inserted_row_counts/500);

Line: 892

      row_counts_perworker  := ceil(inserted_row_counts/divided_worker_counts);

Line: 926

            INSERT INTO ar_bpa_print_requests (
            						request_id,
                				payment_schedule_id,
     	                	worker_id,
           	        		created_by,
                   			creation_date,
               					last_updated_by,
     	               		last_update_date)
     	    VALUES (l_request_id,
               	  ps_id(i),
                  no_of_workers  ,
     	            1,
           	      sysdate,
                  1,
                  sysdate);

Line: 957

      IF dbms_sql.is_open(select_cur) THEN
         dbms_sql.close_cursor(select_cur);