DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_DEFERRALS_PKG

Line 2592: AHL_UNIT_DEFERRALS_PKG.delete_row(x_unit_deferral_id => l_unit_def_rec.unit_deferral_id);

2588: FND_MSG_PUB.ADD;
2589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2590: END IF;
2591:
2592: AHL_UNIT_DEFERRALS_PKG.delete_row(x_unit_deferral_id => l_unit_def_rec.unit_deferral_id);
2593:
2594: ELSIF (l_unit_deferral_operation = 'U') THEN
2595:
2596: -- Check Object version.

Line 2611: AHL_UNIT_DEFERRALS_PKG.update_row(

2607: l_set_due_date := l_unit_def_rec.set_due_date;
2608: END IF;
2609:
2610: IF (nvl(l_unit_def_rec.set_due_date, sysdate+1) <> nvl(l_set_due_date, sysdate+1)) THEN
2611: AHL_UNIT_DEFERRALS_PKG.update_row(
2612: x_unit_deferral_id => l_unit_def_rec.unit_deferral_id,
2613: x_ata_sequence_id => l_unit_def_rec.ata_sequence_id,
2614: x_object_version_number => l_unit_def_rec.object_version_number + 1,
2615: x_last_updated_by => fnd_global.user_id,

Line 2651: AHL_UNIT_DEFERRALS_PKG.insert_row(

2647: END IF;
2648: ELSE -- unit deferral not found.
2649: -- If set due date is not null, create a new unit deferral record.
2650: -- Create unit_deferral record.
2651: AHL_UNIT_DEFERRALS_PKG.insert_row(
2652: x_rowid => l_rowid,
2653: x_unit_deferral_id => l_unit_deferral_id,
2654: x_ata_sequence_id => null,
2655: x_object_version_number => 1,

Line 2732: AHL_UNIT_DEFERRALS_PKG.delete_row(x_unit_deferral_id => l_unit_def_rec.unit_deferral_id);

2728: END LOOP;
2729: CLOSE l_get_thresholds;
2730:
2731: -- delete unit_deferrals.
2732: AHL_UNIT_DEFERRALS_PKG.delete_row(x_unit_deferral_id => l_unit_def_rec.unit_deferral_id);
2733:
2734: END IF;
2735: CLOSE ahl_unit_def_csr;
2736: END IF;

Line 3109: AHL_UNIT_DEFERRALS_PKG.insert_row(

3105: END IF;
3106: CLOSE l_get_dup_counter_csr;
3107: ELSE
3108: -- Create unit_deferral record.
3109: AHL_UNIT_DEFERRALS_PKG.insert_row(
3110: x_rowid => l_rowid,
3111: x_unit_deferral_id => l_unit_deferral_id,
3112: x_ata_sequence_id => null,
3113: x_object_version_number => 1,