The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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 );
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;
PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.Update_Rule_Det');
pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.update_rule_det',
p_debug_mode => l_debug_mode );
pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PUB.update_rule';
pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PVT.UPDATE_RULE_DET';
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 );
pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PUB.update_rule_det';
END update_rule_det;
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;
PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.Delete_Rule_Det');
pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.delete_rule_det',
p_debug_mode => l_debug_mode );
pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PUB.delete_rule_det';
pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PVT.delete_rule_det';
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 );
pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PUB.delete_rule_det';
END delete_rule_det;