APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_THRESHOLDS_PKG

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 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,