APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_ACCOMPLISH_PKG

Line 3023: AHL_UNIT_ACCOMPLISH_PKG.delete_row(l_accomplishment_id);

3019: OPEN l_get_accomplishments(p_unit_Effectivity_rec.UNIT_EFFECTIVITY_ID);
3020: LOOP
3021: FETCH l_get_accomplishments into l_accomplishment_id;
3022: EXIT WHEN l_get_accomplishments%NOTFOUND;
3023: AHL_UNIT_ACCOMPLISH_PKG.delete_row(l_accomplishment_id);
3024: END LOOP;
3025: CLOSE l_get_accomplishments;
3026: END IF;
3027:

Line 3608: AHL_UNIT_ACCOMPLISH_PKG.delete_row(p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID);

3604: IF (p_x_unit_accomplish_tbl.COUNT > 0) THEN
3605: FOR i IN p_x_unit_accomplish_tbl.FIRST..p_x_unit_accomplish_tbl.LAST LOOP
3606: IF (p_x_unit_accomplish_tbl(i).OPERATION_FLAG = 'D') THEN
3607: -- delete row
3608: AHL_UNIT_ACCOMPLISH_PKG.delete_row(p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID);
3609: ELSIF (p_x_unit_accomplish_tbl(i).OPERATION_FLAG = 'M') THEN
3610: -- modify row
3611: OPEN l_get_unit_accomplish_csr(p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID);
3612: FETCH l_get_unit_accomplish_csr INTO l_accomplish_details;

Line 3706: AHL_UNIT_ACCOMPLISH_PKG.update_row (

3702: p_x_unit_accomplish_tbl(i).ATTRIBUTE15 := l_accomplish_details.ATTRIBUTE15;
3703: END IF;
3704:
3705: -- Call table handler to update
3706: AHL_UNIT_ACCOMPLISH_PKG.update_row (
3707: P_UNIT_ACCOMPLISHMNT_ID => p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID,
3708: P_UNIT_EFFECTIVITY_ID => p_x_unit_accomplish_tbl(i).UNIT_EFFECTIVITY_ID,
3709: P_COUNTER_ID => p_x_unit_accomplish_tbl(i).COUNTER_ID,
3710: P_COUNTER_VALUE => p_x_unit_accomplish_tbl(i).COUNTER_VALUE,

Line 3800: AHL_UNIT_ACCOMPLISH_PKG.insert_row (

3796: IF p_x_unit_accomplish_tbl(i).ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
3797: p_x_unit_accomplish_tbl(i).ATTRIBUTE15 := null;
3798: END IF;
3799: -- Call table handler to insert
3800: AHL_UNIT_ACCOMPLISH_PKG.insert_row (
3801: P_X_UNIT_ACCOMPLISHMNT_ID => p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID,
3802: P_UNIT_EFFECTIVITY_ID => p_x_unit_accomplish_tbl(i).UNIT_EFFECTIVITY_ID,
3803: P_COUNTER_ID => p_x_unit_accomplish_tbl(i).COUNTER_ID,
3804: P_COUNTER_VALUE => p_x_unit_accomplish_tbl(i).COUNTER_VALUE,