eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PERF_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_rules table.
 ==================================================================*/


PROCEDURE create_rule(
  P_RULE_ID	          IN NUMBER,
  P_RULE_NAME	          IN VARCHAR2,
  P_RULE_DESCRIPTION      IN VARCHAR2,
  P_RULE_TYPE             IN VARCHAR2,
  P_KPA_CODE              IN VARCHAR2,
  P_MEASURE_ID            IN NUMBER,
  P_MEASURE_FORMAT        IN VARCHAR2,
  P_CURRENCY_TYPE         IN VARCHAR2,
  P_PERIOD_TYPE           IN VARCHAR2,
  P_PRECISION             IN NUMBER,
  P_START_DATE_ACTIVE     IN DATE,
  P_END_DATE_ACTIVE       IN DATE,
  P_SCORE_METHOD          IN VARCHAR2,
  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: 89


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


      update_rule
  PURPOSE
      This procedure updates a row into the pa_perf_rules table.
 ==================================================================*/

PROCEDURE update_rule(
  P_RULE_ID	          IN NUMBER,
  P_RULE_NAME	          IN VARCHAR2,
  P_RULE_DESCRIPTION      IN VARCHAR2,
  P_RULE_TYPE             IN VARCHAR2,
  P_KPA_CODE              IN VARCHAR2,
  P_MEASURE_ID            IN NUMBER,
  P_MEASURE_FORMAT        IN VARCHAR2,
  P_CURRENCY_TYPE         IN VARCHAR2,
  P_PERIOD_TYPE           IN VARCHAR2,
  P_PRECISION             IN NUMBER,
  P_START_DATE_ACTIVE     IN DATE,
  P_END_DATE_ACTIVE       IN DATE,
  P_SCORE_METHOD          IN VARCHAR2,
  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: 205


     PA_DEBUG.init_err_stack('PA_PERF_RULES_PUB.Update_Rule');

Line: 213


          pa_debug.set_curr_function( p_function   => 'PA_PERF_RULES_PUB.update_rule',
                                      p_debug_mode => l_debug_mode );

Line: 218


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

Line: 236


	pa_debug.g_err_stage:= 'about to call PA_PER_RULES_PVT.UPDATE_RULE';

Line: 241


     PA_PERF_RULES_PVT.UPDATE_RULE(
       P_RULE_ID => P_RULE_ID,
       P_RULE_NAME => P_RULE_NAME,
       P_RULE_DESCRIPTION => P_RULE_DESCRIPTION,
       P_RULE_TYPE => P_RULE_TYPE,
       P_KPA_CODE => P_KPA_CODE,
       P_MEASURE_ID => P_MEASURE_ID,
       P_MEASURE_FORMAT => P_MEASURE_FORMAT,
       P_CURRENCY_TYPE => P_CURRENCY_TYPE,
       P_PERIOD_TYPE => P_PERIOD_TYPE,
       P_PRECISION => P_PRECISION,
       P_START_DATE_ACTIVE => P_START_DATE_ACTIVE,
       P_END_DATE_ACTIVE => P_END_DATE_ACTIVE,
       P_SCORE_METHOD => P_SCORE_METHOD,
       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: 268


          pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PUB.update_rule';

Line: 316


END update_rule;

Line: 320


      delete_rule
  PURPOSE
      This procedure deletes a row from the pa_perf_rules table.
 ==================================================================*/

PROCEDURE delete_rule (
 P_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
)
IS
Invalid_Ret_Status EXCEPTION;

Line: 350


     PA_DEBUG.init_err_stack('PA_PERF_RULES_PUB.Delete_Rule');

Line: 358


          pa_debug.set_curr_function( p_function   => 'PA_PERF_RULES_PUB.delete_rule',
                                      p_debug_mode => l_debug_mode );

Line: 363


          pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PUB.delete_rule';

Line: 373


	pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PVT.delete_rule';

Line: 379


     PA_PERF_RULES_PVT.DELETE_RULE
     ( P_RULE_ID         =>  P_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 );

Line: 391


          pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PUB.delete_rule';

Line: 439


END delete_rule;

Line: 445


      This procedure validates the performance rule to be inserted .
 ==================================================================*/
PROCEDURE validate_rule(
  P_RULE_ID	              IN     NUMBER,
  P_RULE_NAME	        IN     VARCHAR2,
  P_RULE_TYPE             IN     VARCHAR2,
  P_PRECISION             IN     NUMBER,
  P_START_DATE_ACTIVE     IN     DATE,
  P_END_DATE_ACTIVE       IN     DATE,
  P_THRESHOLD_ID          IN     SYSTEM.PA_NUM_TBL_TYPE,
  P_THRES_OBJ_ID          IN     SYSTEM.PA_NUM_TBL_TYPE,
  P_FROM_VALUE            IN     SYSTEM.PA_NUM_TBL_TYPE,
  P_TO_VALUE              IN     SYSTEM.PA_NUM_TBL_TYPE,
  P_INDICATOR_CODE        IN     SYSTEM.pa_varchar2_30_tbl_type,
  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
  P_WEIGHTING             IN     SYSTEM.PA_NUM_TBL_TYPE   )
  IS
  l_debug_mode VARCHAR2(1);