APPS.AR_BPA_PRINT_TRX SQL Statements

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

Line: 519

  lc_insert_stmt        VARCHAR2(240);

Line: 520

  lc_select_stmt        VARCHAR2(8096);

Line: 522

  ln_inserted_row_counts   INTEGER;

Line: 553

    SELECT SUBSTR(userenv('LANG'),1,4)
    INTO   lc_userenv_lang
    FROM   SYS.DUAL;

Line: 559

	  SELECT fl.language_code
      INTO   lc_base_lang
      FROM   fnd_languages fl
      WHERE  fl.installed_flag = 'B';

Line: 580

    lc_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: 582

    lc_select_stmt := '  SELECT  ' || ln_m_request_id || ', payment_schedule_id, ROWNUM, 1, SYSDATE, 1, SYSDATE FROM '
                   ||' ( SELECT apsa.payment_schedule_id '|| build_from_clause ||
                   '  AND NVL(hcasa.language,' || '''' || lc_base_lang || ''') = ' || '''' || lc_userenv_lang || '''' ;

Line: 603

    lc_sql_stmt := lc_insert_stmt || lc_select_stmt || lc_where1 || ')';

Line: 622

      lc_sql_stmt := lc_sql_stmt || ' UNION ALL ' || lc_select_stmt || lc_where2 || ')';

Line: 669

      ln_inserted_row_counts := DBMS_SQL.execute(ln_sql_stmt_c);

Line: 671

      IF ln_inserted_row_counts > 0 THEN
        ln_divided_worker_counts := ceil(ln_inserted_row_counts/ln_job_size);

Line: 673

        ln_row_counts_perworker  := ceil(ln_inserted_row_counts/ln_divided_worker_counts);

Line: 680

          UPDATE ar_bpa_print_requests
          SET    worker_id  = ln_worker_id
          WHERE  request_id = ln_m_request_id
          AND    worker_id BETWEEN  ln_low_range AND ln_high_range;

Line: 719

                                       ,request_data => to_char(ln_inserted_row_counts));

Line: 726

          SELECT fcr.request_id
		        ,fcr.status_code
          FROM   fnd_concurrent_requests fcr
          WHERE  fcr.parent_request_id = p_request_id;

Line: 756

    DELETE FROM ar_bpa_print_requests
    WHERE request_id = ln_m_request_id;