63: l_debug_level3);
64: END IF;
65:
66:
67: PA_PERF_THRESHOLDS_PVT.create_rule_det(
68: P_THRESHOLD_ID => P_THRESHOLD_ID,
69: P_RULE_TYPE => P_RULE_TYPE,
70: P_THRES_OBJ_ID => P_THRES_OBJ_ID,
71: P_FROM_VALUE => P_FROM_VALUE,
216: END IF;
217:
218:
219: IF l_debug_mode = 'Y' THEN
220: pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PVT.UPDATE_RULE_DET';
221: pa_debug.write(g_module_name,pa_debug.g_err_stage,
222: l_debug_level3);
223: END IF;
224:
221: pa_debug.write(g_module_name,pa_debug.g_err_stage,
222: l_debug_level3);
223: END IF;
224:
225: PA_PERF_THRESHOLDS_PVT.update_rule_det(
226: P_THRESHOLD_ID => P_THRESHOLD_ID,
227: P_RULE_TYPE => P_RULE_TYPE,
228: P_THRES_OBJ_ID => P_THRES_OBJ_ID,
229: P_FROM_VALUE => P_FROM_VALUE,
349: END IF;
350:
351:
352: IF l_debug_mode = 'Y' THEN
353: pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PVT.delete_rule_det';
354: pa_debug.write(g_module_name,pa_debug.g_err_stage,
355: l_debug_level3);
356: END IF;
357:
355: l_debug_level3);
356: END IF;
357:
358: -- Delete Role
359: PA_PERF_THRESHOLDS_PVT.delete_rule_det
360: ( P_THRESHOLD_ID => P_THRESHOLD_ID,
361: P_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
362: X_RETURN_STATUS => l_return_status,
363: X_MSG_COUNT => l_msg_count,