APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_THRESHOLDS_PKG

Line 2727: AHL_UNIT_THRESHOLDS_PKG.delete_row(l_threshold_id);

2723: OPEN l_get_thresholds(l_unit_def_rec.unit_deferral_id);
2724: LOOP
2725: FETCH l_get_thresholds into l_threshold_id;
2726: EXIT WHEN l_get_thresholds%NOTFOUND;
2727: AHL_UNIT_THRESHOLDS_PKG.delete_row(l_threshold_id);
2728: END LOOP;
2729: CLOSE l_get_thresholds;
2730:
2731: -- delete unit_deferrals.

Line 2960: AHL_UNIT_THRESHOLDS_PKG.delete_row(p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID);

2956: IF (p_x_unit_threshold_tbl.COUNT > 0) THEN
2957: FOR i IN p_x_unit_threshold_tbl.FIRST..p_x_unit_threshold_tbl.LAST LOOP
2958: IF (p_x_unit_threshold_tbl(i).OPERATION_FLAG = 'D') THEN
2959: -- delete row
2960: AHL_UNIT_THRESHOLDS_PKG.delete_row(p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID);
2961: ELSIF (p_x_unit_threshold_tbl(i).OPERATION_FLAG = 'M') THEN
2962: -- modify row
2963: OPEN l_get_unit_threshold_csr(p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID);
2964: FETCH l_get_unit_threshold_csr INTO l_threshold_details;

Line 3058: AHL_UNIT_THRESHOLDS_PKG.update_row (

3054: p_x_unit_threshold_tbl(i).ATTRIBUTE15 := l_threshold_details.ATTRIBUTE15;
3055: END IF;
3056:
3057: -- Call table handler to update
3058: AHL_UNIT_THRESHOLDS_PKG.update_row (
3059: P_UNIT_THRESHOLD_ID => p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID,
3060: --P_UNIT_EFFECTIVITY_ID => l_threshold_details.UNIT_EFFECTIVITY_ID,
3061: P_UNIT_DEFERRAL_ID => l_threshold_details.UNIT_DEFERRAL_ID,
3062: P_CTR_VALUE_TYPE_CODE => l_threshold_details.CTR_VALUE_TYPE_CODE,

Line 3202: AHL_UNIT_THRESHOLDS_PKG.insert_row (

3198: IF p_x_unit_threshold_tbl(i).ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
3199: p_x_unit_threshold_tbl(i).ATTRIBUTE15 := null;
3200: END IF;
3201: -- Call table handler to insert
3202: AHL_UNIT_THRESHOLDS_PKG.insert_row (
3203: P_X_UNIT_THRESHOLD_ID => p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID,
3204: --P_UNIT_EFFECTIVITY_ID => p_x_unit_threshold_tbl(i).UNIT_EFFECTIVITY_ID,
3205: P_UNIT_DEFERRAL_ID => l_UNIT_DEFERRAL_ID,
3206: P_COUNTER_ID => p_x_unit_threshold_tbl(i).COUNTER_ID,