APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_ACCOMPLISH_PKG

Line 2711: AHL_UNIT_ACCOMPLISH_PKG.delete_row(l_accomplishment_id);

2707: OPEN l_get_accomplishments(p_unit_Effectivity_rec.UNIT_EFFECTIVITY_ID);
2708: LOOP
2709: FETCH l_get_accomplishments into l_accomplishment_id;
2710: EXIT WHEN l_get_accomplishments%NOTFOUND;
2711: AHL_UNIT_ACCOMPLISH_PKG.delete_row(l_accomplishment_id);
2712: END LOOP;
2713: CLOSE l_get_accomplishments;
2714: END IF;
2715:

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

3291: IF (p_x_unit_accomplish_tbl.COUNT > 0) THEN
3292: FOR i IN p_x_unit_accomplish_tbl.FIRST..p_x_unit_accomplish_tbl.LAST LOOP
3293: IF (p_x_unit_accomplish_tbl(i).OPERATION_FLAG = 'D') THEN
3294: -- delete row
3295: AHL_UNIT_ACCOMPLISH_PKG.delete_row(p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID);
3296: ELSIF (p_x_unit_accomplish_tbl(i).OPERATION_FLAG = 'M') THEN
3297: -- modify row
3298: OPEN l_get_unit_accomplish_csr(p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID);
3299: FETCH l_get_unit_accomplish_csr INTO l_accomplish_details;

Line 3393: AHL_UNIT_ACCOMPLISH_PKG.update_row (

3389: p_x_unit_accomplish_tbl(i).ATTRIBUTE15 := l_accomplish_details.ATTRIBUTE15;
3390: END IF;
3391:
3392: -- Call table handler to update
3393: AHL_UNIT_ACCOMPLISH_PKG.update_row (
3394: P_UNIT_ACCOMPLISHMNT_ID => p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID,
3395: P_UNIT_EFFECTIVITY_ID => p_x_unit_accomplish_tbl(i).UNIT_EFFECTIVITY_ID,
3396: P_COUNTER_ID => p_x_unit_accomplish_tbl(i).COUNTER_ID,
3397: P_COUNTER_VALUE => p_x_unit_accomplish_tbl(i).COUNTER_VALUE,

Line 3487: AHL_UNIT_ACCOMPLISH_PKG.insert_row (

3483: IF p_x_unit_accomplish_tbl(i).ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
3484: p_x_unit_accomplish_tbl(i).ATTRIBUTE15 := null;
3485: END IF;
3486: -- Call table handler to insert
3487: AHL_UNIT_ACCOMPLISH_PKG.insert_row (
3488: P_X_UNIT_ACCOMPLISHMNT_ID => p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID,
3489: P_UNIT_EFFECTIVITY_ID => p_x_unit_accomplish_tbl(i).UNIT_EFFECTIVITY_ID,
3490: P_COUNTER_ID => p_x_unit_accomplish_tbl(i).COUNTER_ID,
3491: P_COUNTER_VALUE => p_x_unit_accomplish_tbl(i).COUNTER_VALUE,