APPS.PA_PERF_THRESHOLDS_PVT SQL Statements

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

Line: 10

      This procedure inserts a row into the pa_perf_thersholds 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

l_msg_count               NUMBER := 0;

Line: 67

     PA_PERF_THRESHOLDS_PKG.insert_row(
        X_ROWID => l_rowid,
        X_THRESHOLD_ID => P_THRESHOLD_ID,
        X_RULE_TYPE => P_RULE_TYPE,
        X_THRES_OBJ_ID => P_THRES_OBJ_ID,
        X_FROM_VALUE => P_FROM_VALUE,
        X_TO_VALUE => P_TO_VALUE,
        X_INDICATOR_CODE => P_INDICATOR_CODE,
        X_EXCEPTION_FLAG => P_EXCEPTION_FLAG,
        X_WEIGHTING => P_WEIGHTING,
        X_ACCESS_LIST_ID => P_ACCESS_LIST_ID,
        X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
        X_CREATION_DATE => P_CREATION_DATE,
        X_CREATED_BY => P_CREATED_BY,
        X_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
        X_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN
     );

Line: 121

      update_rule
  PURPOSE
      This procedure updates a row into the pa_perf_thersholds 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: 160

     PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PVT.Update_Rule_Det');

Line: 168

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

Line: 173

          pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PVT.update_rule_det';

Line: 209

	pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PKG.UPDATE_ROW';

Line: 214

     PA_PERF_THRESHOLDS_PKG.UPDATE_ROW(
       X_THRESHOLD_ID => P_THRESHOLD_ID,
       X_RULE_TYPE => P_RULE_TYPE,
       X_THRES_OBJ_ID => P_THRES_OBJ_ID,
       X_FROM_VALUE => P_FROM_VALUE,
       X_TO_VALUE => P_TO_VALUE,
       X_INDICATOR_CODE => P_INDICATOR_CODE,
       X_EXCEPTION_FLAG => P_EXCEPTION_FLAG,
       X_WEIGHTING => P_WEIGHTING,
       X_ACCESS_LIST_ID => P_ACCESS_LIST_ID,
       X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
       X_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN );

Line: 230

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

Line: 278

END update_rule_det;

Line: 282

      delete_rule_det
  PURPOSE
      This procedure deletes a row from the pa_perf_thersholds 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: 311

     PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PVT.Delete_Rule_Det');

Line: 319

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

Line: 324

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

Line: 348

	pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PKG.delete_row';

Line: 354

     PA_PERF_THRESHOLDS_PKG.DELETE_ROW
     (X_THRESHOLD_ID => P_THRESHOLD_ID);

Line: 358

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

Line: 406

END delete_rule_det;