APPS.PA_PERF_THRESHOLDS_PUB SQL Statements

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

Line: 10

      This procedure inserts a row into the pa_perf_thresholds table.
 ==================================================================*/


PROCEDURE create_rule_det(
  P_THRESHOLD_ID          IN NUMBER,
  P_RULE_TYPE             IN VARCHAR2,
  P_THRES_OBJ_ID          IN NUMBER,
  P_FROM_VALUE            IN NUMBER,
  P_TO_VALUE              IN NUMBER,
  P_INDICATOR_CODE        IN VARCHAR2,
  P_EXCEPTION_FLAG        IN VARCHAR2,
  P_WEIGHTING             IN NUMBER,
  P_ACCESS_LIST_ID        IN NUMBER,
  P_RECORD_VERSION_NUMBER IN NUMBER,
  P_CREATION_DATE         IN DATE,
  P_CREATED_BY            IN NUMBER,
  P_LAST_UPDATE_DATE      IN DATE,
  P_LAST_UPDATED_BY       IN NUMBER,
  P_LAST_UPDATE_LOGIN     IN NUMBER,
  X_RETURN_STATUS         OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  X_MSG_COUNT             OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
  X_MSG_DATA              OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS
Invalid_Ret_Status        EXCEPTION;

Line: 80

      P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
      P_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
      P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN ,
      X_RETURN_STATUS => l_return_status,
      X_MSG_COUNT  => l_msg_count,
      X_MSG_DATA  => l_msg_data );

Line: 152

      update_rule_det
  PURPOSE
      This procedure updates a row into the pa_perf_thresholds table.
 ==================================================================*/

PROCEDURE update_rule_det(
  P_THRESHOLD_ID          IN NUMBER,
  P_RULE_TYPE             IN VARCHAR2,
  P_THRES_OBJ_ID          IN NUMBER,
  P_FROM_VALUE            IN NUMBER,
  P_TO_VALUE              IN NUMBER,
  P_INDICATOR_CODE        IN VARCHAR2,
  P_EXCEPTION_FLAG        IN VARCHAR2,
  P_WEIGHTING             IN NUMBER,
  P_ACCESS_LIST_ID        IN NUMBER,
  P_RECORD_VERSION_NUMBER IN NUMBER,
  P_LAST_UPDATE_DATE      IN DATE,
  P_LAST_UPDATED_BY       IN NUMBER,
  P_LAST_UPDATE_LOGIN     IN NUMBER,
  X_RETURN_STATUS         OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  X_MSG_COUNT             OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
  X_MSG_DATA              OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS
Invalid_Ret_Status EXCEPTION;

Line: 192

     PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.Update_Rule_Det');

Line: 200

          pa_debug.set_curr_function( p_function   => 'PA_PERF_THRESHOLDS_PUB.update_rule_det',
                                      p_debug_mode => l_debug_mode );

Line: 205

          pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PUB.update_rule';

Line: 220

	pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PVT.UPDATE_RULE_DET';

Line: 225

     PA_PERF_THRESHOLDS_PVT.update_rule_det(
       P_THRESHOLD_ID => P_THRESHOLD_ID,
       P_RULE_TYPE => P_RULE_TYPE,
       P_THRES_OBJ_ID => P_THRES_OBJ_ID,
       P_FROM_VALUE => P_FROM_VALUE,
       P_TO_VALUE => P_TO_VALUE,
       P_INDICATOR_CODE => P_INDICATOR_CODE,
       P_EXCEPTION_FLAG => P_EXCEPTION_FLAG,
       P_WEIGHTING => P_WEIGHTING,
       P_ACCESS_LIST_ID => P_ACCESS_LIST_ID,
       P_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
       P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
       P_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
       P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
       X_RETURN_STATUS => l_return_status,
       X_MSG_COUNT  => l_msg_count,
       X_MSG_DATA  => l_msg_data );

Line: 248

          pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PUB.update_rule_det';

Line: 296

END update_rule_det;

Line: 300

      delete_rule_det
  PURPOSE
      This procedure deletes a row from the pa_perf_thresholds table.
 ==================================================================*/

PROCEDURE delete_rule_det (
 P_THRESHOLD_ID           IN         NUMBER,
 P_RECORD_VERSION_NUMBER  IN         NUMBER,
 X_RETURN_STATUS          OUT        NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 X_MSG_COUNT              OUT        NOCOPY NUMBER, --File.Sql.39 bug 4440895
 X_MSG_DATA               OUT        NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
Invalid_Ret_Status EXCEPTION;

Line: 330

     PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.Delete_Rule_Det');

Line: 338

          pa_debug.set_curr_function( p_function   => 'PA_PERF_THRESHOLDS_PUB.delete_rule_det',
                                      p_debug_mode => l_debug_mode );

Line: 343

          pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PUB.delete_rule_det';

Line: 353

	pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PVT.delete_rule_det';

Line: 359

     PA_PERF_THRESHOLDS_PVT.delete_rule_det
     ( P_THRESHOLD_ID    =>  P_THRESHOLD_ID,
       P_RECORD_VERSION_NUMBER  => P_RECORD_VERSION_NUMBER,
       X_RETURN_STATUS => l_return_status,
       X_MSG_COUNT  => l_msg_count,
       X_MSG_DATA  => l_msg_data );

Line: 371

          pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PUB.delete_rule_det';

Line: 419

END delete_rule_det;