APPS.PA_PERF_EXCP_UTILS SQL Statements

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

Line: 28

		  SELECT meaning, attribute1
		    FROM pa_perf_kpa_summary ppks, pa_perf_kpa_summary_det ppksd,
		    pa_lookups pl
		    WHERE
		    ppks.object_type = p_object_type
		    AND ppks.object_id = p_object_id
		    AND ppks.current_flag = 'Y'
		    AND ppks.kpa_summary_id = ppksd.kpa_summary_id
		    AND ppksd.kpa_code = l_kpa_code
		    AND pl.lookup_type = 'PA_PERF_INDICATORS'
		    AND pl.lookup_code = ppksd.indicator_code
		    ;

Line: 44

		  SELECT meaning, attribute1
		    FROM pa_perf_kpa_summary ppks,
		    pa_lookups pl
		    WHERE
		    ppks.object_type = p_object_type
		    AND ppks.object_id = p_object_id
		    AND ppks.current_flag = 'Y'
		    AND pl.lookup_type = 'PA_PERF_INDICATORS'
		    AND pl.lookup_code = ppks.perf_status_code
		    ;

Line: 79

	      --x_indicators.DELETE;

Line: 159

		 SELECT meaning
		   FROM pa_lookups pl
		   WHERE  pl.lookup_code = l_kpa_code
		   AND pl.lookup_type = 'PA_PERF_KEY_AREAS'
		   AND pl.enabled_flag = 'Y' ;

Line: 166

	      SELECT COUNT(*) FROM pa_lookups
	      WHERE lookup_type = 'PA_PERF_KEY_AREAS'
		AND lookup_code <> 'ALL';

Line: 220

		  SELECT meaning, attribute1
		    FROM pa_perf_kpa_summary ppks, pa_perf_kpa_summary_det ppksd,
		    pa_lookups pl
		    WHERE
		    ppks.object_type = p_object_type
		    AND ppks.object_id = p_object_id
		    AND ppks.current_flag = 'Y'
		    AND ppks.kpa_summary_id = ppksd.kpa_summary_id
		    AND ppksd.kpa_code = p_kpa_code
		    AND pl.lookup_type = 'PA_PERF_INDICATORS'
		    AND pl.lookup_code = ppksd.indicator_code
		    ;

Line: 292

		  SELECT
		    meaning, attribute1, ppt.perf_txn_id, ppt.exception_flag
		    FROM pa_perf_transactions ppt, pa_lookups pl
		    WHERE
		    ppt.perf_txn_obj_type = p_object_type
		    AND ppt.perf_txn_obj_id = p_object_id
		    AND ppt.period_type = Nvl(p_period_type, ppt.period_type)
		    AND nvl(ppt.period_name, '-9999')
		    = Nvl(p_period_name, '-9999')
		    AND ppt.measure_id = p_measure_id
		    AND ppt.current_flag = 'Y'
		    AND ppt.indicator_code = pl.lookup_code
		    AND pl.lookup_type = 'PA_PERF_INDICATORS'
		    AND ROWNUM = 1
		    ;

Line: 394

		  SELECT
		    meaning, attribute1, ppt.perf_txn_id, ppt.exception_flag
		    FROM pa_perf_transactions ppt, pa_lookups pl
		    WHERE
		    ppt.perf_txn_obj_type = p_object_type
		    AND ppt.perf_txn_obj_id = p_object_id
		    AND ppt.period_TYPE = Nvl(p_period_type, ppt.period_type)
		    AND nvl(ppt.period_name, '-9999')
		    = Nvl(p_period_name, '-9999')
		    AND ppt.measure_id = (l_measure_id)
		    AND ppt.current_flag = 'Y'
		    AND ppt.indicator_code = pl.lookup_code
		    AND pl.lookup_type = 'PA_PERF_INDICATORS'
		    AND ROWNUM = 1
		    ;

Line: 412

	        SELECT measure_index
		FROM   PA_PERF_EXCP_MSR_TEMP
		WHERE measure_id= l_measure_id;

Line: 456

	   delete from PA_PERF_EXCP_MSR_TEMP;

Line: 458

	   --Inserting the measure id and thier corresponding index in p_measure_id parameter in the temporary table
           FOR i IN p_measure_id.FIRST..p_measure_id.LAST LOOP
           INSERT INTO PA_PERF_EXCP_MSR_TEMP(measure_index,measure_id)
 	   VALUES(to_number(i),p_measure_id(i));

Line: 465

	   SELECT meaning, attribute1, ppt.perf_txn_id, ppt.exception_flag,ppt.measure_id
	   BULK COLLECT INTO  l_meaning_tbl, l_icon_tbl, l_perf_txn_id_tbl, l_flag_tbl,l_meaure_id_tbl
           FROM pa_perf_transactions ppt, pa_lookups pl
	   WHERE ppt.perf_txn_obj_type = p_object_type
           AND ppt.perf_txn_obj_id = p_object_id
	   AND ppt.period_TYPE = Nvl(p_period_type, ppt.period_type)
	   AND nvl(ppt.period_name, '-9999')
	       = Nvl(p_period_name, '-9999')
	   AND ppt.measure_id in (select measure_id from PA_PERF_EXCP_MSR_TEMP)
	   AND ppt.current_flag = 'Y'
	   AND ppt.indicator_code = pl.lookup_code
	   AND pl.lookup_type = 'PA_PERF_INDICATORS'
	   ;

Line: 586

   SELECT Object_rule_id,
	  Object_type,
	  Object_id,
	  rule_id
     FROM pa_perf_object_rules
    WHERE object_type = p_from_object_type
      AND object_id = p_from_object_id;

Line: 608

        select PA_PERF_OBJECT_RULES_S1.nextval into l_object_rule_id from dual;

Line: 610

        PA_PERF_OBJECT_RULES_PKG.insert_row(
          X_ROWID => l_rowid,
          X_OBJECT_RULE_ID => l_object_rule_id,
          X_OBJECT_TYPE => P_TO_OBJECT_TYPE,
          X_OBJECT_ID => P_TO_OBJECT_ID,
          X_RULE_ID => c_rec.RULE_ID,
          X_RECORD_VERSION_NUMBER => 1,
          X_CREATION_DATE => sysdate,
          X_CREATED_BY => fnd_global.user_id,
          X_LAST_UPDATE_DATE => sysdate,
          X_LAST_UPDATED_BY => fnd_global.user_id,
          X_LAST_UPDATE_LOGIN => fnd_global.login_id);

Line: 640

Procedure delete_object_exceptions
          ( p_object_type     in  varchar2
           ,p_object_id       in  number
           , x_msg_count      OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
           , x_msg_data       OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
           , x_return_status  OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

BEGIN

   PA_DEBUG.init_err_stack('PA_PERF_EXCP_UTILS.delete_object_exceptions');

Line: 652

   savepoint delete_object_exceptions;

Line: 654

   delete pa_perf_object_rules
    where object_type = p_object_type
      and object_id = p_object_id;

Line: 659

   delete pa_perf_kpa_trans
    where perf_txn_id in (select perf_txn_id from pa_perf_transactions
                           where project_id = p_object_id)
      and kpa_summary_det_id in (select kpa_summary_det_id from pa_perf_kpa_summary_det
                                  where object_type = p_object_type
                                    and object_id = p_object_id);

Line: 666

   delete pa_perf_kpa_summary_det
    where object_type = p_object_type
      and object_id = p_object_id;

Line: 670

   delete pa_perf_kpa_summary
    where object_type = p_object_type
      and object_id = p_object_id;

Line: 674

   delete pa_perf_comments
    where perf_txn_id in (select perf_txn_id from pa_perf_transactions
                           where project_id = p_object_id);

Line: 678

   delete pa_perf_transactions
    where project_id = p_object_id;

Line: 685

          ROLLBACK TO delete_object_exceptions;

Line: 691

END delete_object_exceptions;