APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_THRESHOLDS

Line 1809: FROM AHL_UNIT_THRESHOLDS

1805: CCR.VALUE_TIMESTAMP DESC;
1806:
1807: CURSOR l_get_prev_ctr_csr(p_threshold_id IN NUMBER) IS
1808: SELECT OBJECT_VERSION_NUMBER, COUNTER_ID
1809: FROM AHL_UNIT_THRESHOLDS
1810: WHERE UNIT_THRESHOLD_ID = p_threshold_id;
1811:
1812: CURSOR l_ue_id_check_csr(p_threshold_id IN NUMBER, p_ue_id IN NUMBER) IS
1813: SELECT 'x'

Line 1814: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF

1810: WHERE UNIT_THRESHOLD_ID = p_threshold_id;
1811:
1812: CURSOR l_ue_id_check_csr(p_threshold_id IN NUMBER, p_ue_id IN NUMBER) IS
1813: SELECT 'x'
1814: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF
1815: WHERE UTH.unit_deferral_id = UDF.unit_deferral_ID AND
1816: UTH.UNIT_THRESHOLD_ID = p_threshold_id AND
1817: UDF.UNIT_EFFECTIVITY_ID = p_ue_id AND
1818: UDF.Unit_deferral_type = 'INIT-DUE';

Line 2199: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF

2195: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type) IS
2196:
2197: CURSOR l_threshold_exists_csr(p_ue_id IN NUMBER) IS
2198: SELECT 'x'
2199: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF
2200: WHERE UTH.unit_deferral_id = UDF.unit_deferral_id
2201: AND UDF.unit_deferral_type = 'INIT-DUE'
2202: AND UDF.unit_effectivity_id = p_ue_id;
2203:

Line 2283: FROM ahl_unit_thresholds

2279: WHERE UNIT_EFFECTIVITY_ID = p_ue_id;
2280:
2281: CURSOR l_get_thresholds(p_ue_id IN NUMBER) IS
2282: SELECT UNIT_THRESHOLD_ID
2283: FROM ahl_unit_thresholds
2284: WHERE UNIT_DEFERRAL_ID = p_ue_id;
2285:
2286: CURSOR ahl_unit_def_csr(p_ue_id IN NUMBER) IS
2287: SELECT unit_deferral_id,

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 2933: FROM AHL_UNIT_THRESHOLDS

2929: ATTRIBUTE12,
2930: ATTRIBUTE13,
2931: ATTRIBUTE14,
2932: ATTRIBUTE15
2933: FROM AHL_UNIT_THRESHOLDS
2934: WHERE UNIT_THRESHOLD_ID = p_threshold_id
2935: FOR UPDATE OF OBJECT_VERSION_NUMBER;
2936:
2937: CURSOR l_get_dup_counter_csr(p_unit_def_id IN NUMBER,

Line 2940: FROM AHL_UNIT_THRESHOLDS UTH

2936:
2937: CURSOR l_get_dup_counter_csr(p_unit_def_id IN NUMBER,
2938: p_counter_id IN NUMBER) IS
2939: SELECT 'x'
2940: FROM AHL_UNIT_THRESHOLDS UTH
2941: WHERE UTH.unit_deferral_id = p_unit_def_id AND
2942: UTH.COUNTER_ID = p_counter_id;
2943:
2944: CURSOR l_get_def_csr(p_ue_id IN NUMBER) IS

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,