DBA Data[Home] [Help]

APPS.PA_PERF_RULES_PVT dependencies on PA_PERF_THRESHOLDS

Line 414: FROM pa_perf_thresholds

410:
411: CURSOR cur_threshold( rule_id_par NUMBER)
412: IS
413: SELECT threshold_id, record_version_number
414: FROM pa_perf_thresholds
415: WHERE thres_obj_id= rule_id_par;
416:
417: CURSOR cur_obj_rule( rule_id_par NUMBER)
418: IS

Line 476: PA_PERF_THRESHOLDS_PVT.delete_rule_det (

472: LOOP
473: l_return_status := FND_API.G_RET_STS_SUCCESS;
474: l_msg_count := 0;
475: l_msg_data := NULL;
476: PA_PERF_THRESHOLDS_PVT.delete_rule_det (
477: P_THRESHOLD_ID => cur_var.threshold_id,
478: P_RECORD_VERSION_NUMBER => cur_var.record_version_number,
479: X_RETURN_STATUS => l_return_status,
480: X_MSG_COUNT => l_msg_count,