APPS.CS_SR_COST_CP SQL Statements

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

Line: 99

  SELECT
    request_id
  FROM
    fnd_concurrent_requests
  WHERE
    parent_request_id = c_request_id;

Line: 270

	    DELETE cs_cost_staging
	    WHERE
	      concurrent_request_id IN
	      (
	      SELECT
		request_id
	      FROM
		fnd_concurrent_requests r
	      , fnd_concurrent_programs p
	      WHERE
		  r.phase_code              = 'C'
	      AND p.concurrent_program_id   = r.concurrent_program_id
	      AND p.concurrent_program_name = 'CSCSTPG'
	      AND p.application_id          = 170
	      );

Line: 365

    Form_And_Exec_Statement -- this will insert data into the staging table
    (
      p_sr_status             => p_sr_status
    , p_creation_from_date    => l_creation_from_date
    , p_creation_to_date      => l_creation_to_date
    , p_number_of_workers     => l_number_of_workers
    , p_cost_batch_size      => p_cost_batch_size
    , p_request_id            => l_request_id
    , p_row_count             => l_row_count
    );

Line: 609

		  AND l_worker_conc_req_dev_status IN ('ERROR', 'DELETED', 'TERMINATED')
		  THEN
		    l_main_conc_req_dev_status := 'ERROR';

Line: 701

	    /*DELETE cs_cost_staging
	    WHERE
	      concurrent_request_id = l_request_id;

Line: 737

   /* DELETE cs_cost_staging
    WHERE
      concurrent_request_id = l_request_id;

Line: 1233

	      SELECT
		form_left_prompt
	      INTO
		l_prompt
	      FROM
		fnd_descr_flex_col_usage_vl
	      WHERE
		  end_user_column_name       = 'P_CREATION_FROM_DATE'
	      AND application_id             = 170
	      AND descriptive_flexfield_name = '$SRS$.CSCSTPG';

Line: 1306

		      SELECT
			form_left_prompt
		      INTO
			l_prompt
		      FROM
			fnd_descr_flex_col_usage_vl
		      WHERE
			end_user_column_name         = 'P_CREATION_TO_DATE'
		      AND application_id             = 170
		      AND descriptive_flexfield_name = '$SRS$.CSCSTPG';

Line: 1418

	      SELECT
		form_left_prompt
	      INTO
		l_prompt
	      FROM
		fnd_descr_flex_col_usage_vl
	      WHERE
		  end_user_column_name       = 'P_CREATION_FROM_DATE'
	      AND application_id             = 170
	      AND descriptive_flexfield_name = '$SRS$.CSCSTPG';

Line: 1431

	      SELECT
		form_left_prompt
	      INTO
		l_prompt
	      FROM
		fnd_descr_flex_col_usage_vl
	      WHERE
		  end_user_column_name       = 'P_CREATION_TO_DATE'
	      AND application_id             = 170
	      AND descriptive_flexfield_name = '$SRS$.CSCSTPG';

Line: 1489

SELECT  ced.estimate_detail_id
FROM    cs_incidents_all_b    cia
       ,cs_incident_statuses  cis
       ,cs_estimate_details   ced
WHERE Nvl(cis.close_flag,'N') IN  (decode( p_sr_status,'OPEN','N','CLOSED','Y'   ,'ALL',Nvl(cis.close_flag,'N')))
and cis.incident_subtype='INC'
and     cia.incident_status_id = cis.incident_status_id
and     cia.incident_id  = ced.incident_id
--and      ced.estimate_Detail_id =115538
and     trunc(cia.creation_date) between trunc(p_creation_from_date) and trunc(p_creation_to_date);

Line: 1511

   INSERT INTO cs_cost_staging
	   (
		estimate_detail_id,
		worker_id,
		concurrent_request_id
	    )
    VALUES
	   (
	       l_estimate_Detail_id,
	       NULL,
	       p_request_id
	   );

Line: 1564

  UPDATE cs_cost_staging
  SET
    worker_id = MOD
    (
      ROWNUM - 1
    , l_number_of_workers
    ) + 1;

Line: 1661

  SELECT
    estimate_detail_id
  FROM
    cs_cost_staging
  WHERE
      worker_id             = p_worker_id
  AND concurrent_request_id = p_cost_set_id
  AND status IS NULL;

Line: 1671

SELECT cost_id
FROM   cs_cost_details
WHERE  estimate_detail_id = p_estimate_detail_id;

Line: 1713

    SELECT
      1
    INTO
      l_row_count
    FROM
      fnd_concurrent_requests r
    , fnd_concurrent_programs p
    WHERE
        r.request_id              = p_cost_set_id
    AND p.concurrent_program_id   = r.concurrent_program_id
    AND p.concurrent_program_name = 'CSCSTPG'
    AND p.application_id          = 170
    AND r.status_code             <> 'C';

Line: 1797

			 UPDATE cs_cost_staging
			 SET  status      = 'E'
			     ,error_message =  x_msg_data
			 WHERE estimate_detail_id  = l_temp_count ;

Line: 1802

			 UPDATE cs_cost_staging
			 SET    status      = 'S'
			 WHERE  estimate_detail_id  = l_temp_count ;

Line: 1812

		-- while executing the SR delete API

	      THEN

	            UPDATE cs_cost_staging
		    SET
		    status      = 'E'
		  , error_message =  x_msg_data
		  WHERE
		      estimate_detail_id  = l_temp_count
		  AND NVL(status, 'S') = 'S';

Line: 1869

      SELECT
         cia.incident_number       incident_number
	,ced.estimate_detail_id    estimate_detail_id
	,ced.line_number           line_number
--	, css.error_message		   cost_error_message
--,	substr(css.error_message,instr(css.error_message,':',1)+1)  cost_error_message
,case when length(css.error_message)>120 then
substr(css.error_message,1,75)
else
substr(css.error_message,instr(css.error_message,':',1)+1)
end
--  , p.party_number          customer_number
  --, i.segment1              item_number
--  , t.summary               summary

  FROM
    cs_cost_staging   css
  , cs_estimate_Details         ced
  , cs_incidents_all_b         cia
--  , mtl_system_items_b          i
 -- , hz_parties                  p
  WHERE
      css.status          = 'E'
	  and css.ESTIMATE_DETAIL_ID = ced.ESTIMATE_DETAIL_ID
	  and ced.incident_id = cia.incident_id
	  and css.CONCURRENT_REQUEST_ID =p_request_id
	  and css.worker_id=NVL(1, css.worker_id) ;

Line: 1960

  SELECT
    count(1)
  INTO
    l_row_count
  FROM
    cs_cost_staging s
  WHERE
    s.worker_id = NVL(p_worker_id, s.worker_id);

Line: 1988

  SELECT
    count(1)
  INTO
    l_row_count
  FROM
    cs_cost_staging s
  WHERE
      status = 'S'
  AND s.worker_id = NVL(p_worker_id, s.worker_id);

Line: 2016

  SELECT
    count(1)
  INTO
    l_row_count
  FROM
    cs_cost_staging s
  WHERE
      status IS NULL
  AND s.worker_id = NVL(p_worker_id, s.worker_id);

Line: 2065

  SELECT
    count(1)
  INTO
    l_row_count
  FROM
    cs_cost_staging s
  WHERE
      status = 'E'
  AND s.worker_id = NVL(p_worker_id, s.worker_id);