DBA Data[Home] [Help]

APPS.AR_BPA_PRINT_TRX SQL Statements

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

Line: 150

     SELECT fcp.concurrent_program_name
	        ,fcp.concurrent_program_id
	   INTO ln_conc_prog_code
	        ,ln_conc_prog_id
       FROM fnd_concurrent_programs	fcp
	        ,fnd_concurrent_requests fcr
	  WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
	    AND fcr.request_id = p_parent_request_id;
Line: 169

	        UPDATE fnd_concurrent_requests
               SET save_output_flag='N'
			       ,number_of_copies=1
             WHERE request_id = p_parent_request_id
               AND concurrent_program_id = ln_conc_prog_id;
Line: 175

	        UPDATE fnd_concurrent_requests
               SET save_output_flag='Y'
             WHERE request_id = p_parent_request_id
               AND concurrent_program_id = ln_conc_prog_id;
Line: 550

  lc_insert_stmt        VARCHAR2(240);
Line: 551

  lc_select_stmt        VARCHAR2(8096);
Line: 553

  ln_inserted_row_counts   INTEGER;
Line: 584

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

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

    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, customer_trx_id)';
Line: 613

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

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

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

      ln_inserted_row_counts := DBMS_SQL.execute(ln_sql_stmt_c);
Line: 702

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

        ln_row_counts_perworker  := ceil(ln_inserted_row_counts/ln_divided_worker_counts);
Line: 711

          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: 751

                                       ,request_data => to_char(ln_inserted_row_counts));
Line: 758

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

    DELETE FROM ar_bpa_print_requests
    WHERE request_id = ln_m_request_id;