APPS.PA_PERF_OBJECT_RULES_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_object_rules table.
 ==================================================================*/


PROCEDURE create_rule_object(
  P_OBJECT_RULE_ID        IN NUMBER,
  P_OBJECT_TYPE           IN VARCHAR2,
  P_OBJECT_ID             IN NUMBER,
  P_RULE_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: 72

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

      update_rule_object
  PURPOSE
      This procedure updates a row in the pa_perf_object_rules table.
 ==================================================================*/


PROCEDURE update_rule_object(
  P_OBJECT_RULE_ID        IN NUMBER,
  P_OBJECT_TYPE           IN VARCHAR2,
  P_OBJECT_ID             IN NUMBER,
  P_RULE_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: 189

     PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PUB.update_rule_object');

Line: 196

          pa_debug.set_curr_function( p_function   => 'PA_PERF_OBJECT_RULES_PUB.update_rule_object',
                                      p_debug_mode => l_debug_mode );

Line: 201

          pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PUB.update_rule_object';

Line: 207

     PA_PERF_OBJECT_RULES_PVT.update_rule_object(
      P_OBJECT_RULE_ID => P_OBJECT_RULE_ID,
      P_OBJECT_TYPE => P_OBJECT_TYPE,
      P_OBJECT_ID => P_OBJECT_ID,
      P_RULE_ID => P_RULE_ID,
      P_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
      P_CREATION_DATE => P_CREATION_DATE,
      P_CREATED_BY   => P_CREATED_BY,
      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: 236

          pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PUB.update_rule_object';

Line: 280

      ,p_procedure_name  => 'UPDATE_RULE_OBJECT'
      ,p_error_text      => x_msg_data);

Line: 290

END update_rule_object;

Line: 294

      delete_rule_object
  PURPOSE
      This procedure deletes a row from the pa_perf_object_rules table.
 ==================================================================*/

PROCEDURE delete_rule_object (
 P_OBJECT_RULE_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
 X_RULE_NAME              OUT        NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
Invalid_Ret_Status EXCEPTION;

Line: 326

     PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PUB.delete_rule_object');

Line: 334

          pa_debug.set_curr_function( p_function   => 'PA_PERF_OBJECT_RULES_PUB.delete_rule_object',
                                      p_debug_mode => l_debug_mode );

Line: 339

          pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PUB.delete_rule_object';

Line: 349

	pa_debug.g_err_stage:= 'about to call PA_PERF_OBJECT_RULES_PVT.delete_rule_object';

Line: 355

     PA_PERF_OBJECT_RULES_PVT.delete_rule_object
     ( P_OBJECT_RULE_ID    =>  P_OBJECT_RULE_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,
       X_RULE_NAME => X_RULE_NAME);

Line: 368

          pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PUB.delete_rule_object';

Line: 416

END delete_rule_object;