APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_THRESHOLDS

Line 2068: FROM AHL_UNIT_THRESHOLDS

2064: ) WHERE ROWNUM < 2;
2065:
2066: CURSOR l_get_prev_ctr_csr(p_threshold_id IN NUMBER) IS
2067: SELECT OBJECT_VERSION_NUMBER, COUNTER_ID
2068: FROM AHL_UNIT_THRESHOLDS
2069: WHERE UNIT_THRESHOLD_ID = p_threshold_id;
2070:
2071: CURSOR l_ue_id_check_csr(p_threshold_id IN NUMBER, p_ue_id IN NUMBER) IS
2072: SELECT 'x'

Line 2073: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF

2069: WHERE UNIT_THRESHOLD_ID = p_threshold_id;
2070:
2071: CURSOR l_ue_id_check_csr(p_threshold_id IN NUMBER, p_ue_id IN NUMBER) IS
2072: SELECT 'x'
2073: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF
2074: WHERE UTH.unit_deferral_id = UDF.unit_deferral_ID AND
2075: UTH.UNIT_THRESHOLD_ID = p_threshold_id AND
2076: UDF.UNIT_EFFECTIVITY_ID = p_ue_id AND
2077: UDF.Unit_deferral_type = 'INIT-DUE';

Line 2508: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF

2504: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type) IS
2505:
2506: CURSOR l_threshold_exists_csr(p_ue_id IN NUMBER) IS
2507: SELECT 'x'
2508: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF
2509: WHERE UTH.unit_deferral_id = UDF.unit_deferral_id
2510: AND UDF.unit_deferral_type = 'INIT-DUE'
2511: AND UDF.unit_effectivity_id = p_ue_id;
2512:

Line 2592: FROM ahl_unit_thresholds

2588: WHERE UNIT_EFFECTIVITY_ID = p_ue_id;
2589:
2590: CURSOR l_get_thresholds(p_ue_id IN NUMBER) IS
2591: SELECT UNIT_THRESHOLD_ID
2592: FROM ahl_unit_thresholds
2593: WHERE UNIT_DEFERRAL_ID = p_ue_id;
2594:
2595: CURSOR ahl_unit_def_csr(p_ue_id IN NUMBER) IS
2596: SELECT unit_deferral_id,

Line 3039: AHL_UNIT_THRESHOLDS_PKG.delete_row(l_threshold_id);

3035: OPEN l_get_thresholds(l_unit_def_rec.unit_deferral_id);
3036: LOOP
3037: FETCH l_get_thresholds into l_threshold_id;
3038: EXIT WHEN l_get_thresholds%NOTFOUND;
3039: AHL_UNIT_THRESHOLDS_PKG.delete_row(l_threshold_id);
3040: END LOOP;
3041: CLOSE l_get_thresholds;
3042:
3043: -- delete unit_deferrals.

Line 3245: FROM AHL_UNIT_THRESHOLDS

3241: ATTRIBUTE12,
3242: ATTRIBUTE13,
3243: ATTRIBUTE14,
3244: ATTRIBUTE15
3245: FROM AHL_UNIT_THRESHOLDS
3246: WHERE UNIT_THRESHOLD_ID = p_threshold_id
3247: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3248:
3249: CURSOR l_get_dup_counter_csr(p_unit_def_id IN NUMBER,

Line 3252: FROM AHL_UNIT_THRESHOLDS UTH

3248:
3249: CURSOR l_get_dup_counter_csr(p_unit_def_id IN NUMBER,
3250: p_counter_id IN NUMBER) IS
3251: SELECT 'x'
3252: FROM AHL_UNIT_THRESHOLDS UTH
3253: WHERE UTH.unit_deferral_id = p_unit_def_id AND
3254: UTH.COUNTER_ID = p_counter_id;
3255:
3256: CURSOR l_get_def_csr(p_ue_id IN NUMBER) IS

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

3268: IF (p_x_unit_threshold_tbl.COUNT > 0) THEN
3269: FOR i IN p_x_unit_threshold_tbl.FIRST..p_x_unit_threshold_tbl.LAST LOOP
3270: IF (p_x_unit_threshold_tbl(i).OPERATION_FLAG = 'D') THEN
3271: -- delete row
3272: AHL_UNIT_THRESHOLDS_PKG.delete_row(p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID);
3273: ELSIF (p_x_unit_threshold_tbl(i).OPERATION_FLAG = 'M') THEN
3274: -- modify row
3275: OPEN l_get_unit_threshold_csr(p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID);
3276: FETCH l_get_unit_threshold_csr INTO l_threshold_details;

Line 3370: AHL_UNIT_THRESHOLDS_PKG.update_row (

3366: p_x_unit_threshold_tbl(i).ATTRIBUTE15 := l_threshold_details.ATTRIBUTE15;
3367: END IF;
3368:
3369: -- Call table handler to update
3370: AHL_UNIT_THRESHOLDS_PKG.update_row (
3371: P_UNIT_THRESHOLD_ID => p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID,
3372: --P_UNIT_EFFECTIVITY_ID => l_threshold_details.UNIT_EFFECTIVITY_ID,
3373: P_UNIT_DEFERRAL_ID => l_threshold_details.UNIT_DEFERRAL_ID,
3374: P_CTR_VALUE_TYPE_CODE => l_threshold_details.CTR_VALUE_TYPE_CODE,

Line 3515: AHL_UNIT_THRESHOLDS_PKG.insert_row (

3511: IF p_x_unit_threshold_tbl(i).ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
3512: p_x_unit_threshold_tbl(i).ATTRIBUTE15 := null;
3513: END IF;
3514: -- Call table handler to insert
3515: AHL_UNIT_THRESHOLDS_PKG.insert_row (
3516: P_X_UNIT_THRESHOLD_ID => p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID,
3517: --P_UNIT_EFFECTIVITY_ID => p_x_unit_threshold_tbl(i).UNIT_EFFECTIVITY_ID,
3518: P_UNIT_DEFERRAL_ID => l_UNIT_DEFERRAL_ID,
3519: P_COUNTER_ID => p_x_unit_threshold_tbl(i).COUNTER_ID,