DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_DEFERRALS_PKG

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

2898: FND_MSG_PUB.ADD;
2899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2900: END IF;
2901:
2902: AHL_UNIT_DEFERRALS_PKG.delete_row(x_unit_deferral_id => l_unit_def_rec.unit_deferral_id);
2903:
2904: ELSIF (l_unit_deferral_operation = 'U') THEN
2905:
2906: -- Check Object version.

Line 2921: AHL_UNIT_DEFERRALS_PKG.update_row(

2917: l_set_due_date := l_unit_def_rec.set_due_date;
2918: END IF;
2919:
2920: IF (nvl(l_unit_def_rec.set_due_date, sysdate+1) <> nvl(l_set_due_date, sysdate+1)) THEN
2921: AHL_UNIT_DEFERRALS_PKG.update_row(
2922: x_unit_deferral_id => l_unit_def_rec.unit_deferral_id,
2923: x_ata_sequence_id => l_unit_def_rec.ata_sequence_id,
2924: x_object_version_number => l_unit_def_rec.object_version_number + 1,
2925: x_last_updated_by => fnd_global.user_id,

Line 2962: AHL_UNIT_DEFERRALS_PKG.insert_row(

2958: END IF;
2959: ELSE -- unit deferral not found.
2960: -- If set due date is not null, create a new unit deferral record.
2961: -- Create unit_deferral record.
2962: AHL_UNIT_DEFERRALS_PKG.insert_row(
2963: x_rowid => l_rowid,
2964: x_unit_deferral_id => l_unit_deferral_id,
2965: x_ata_sequence_id => null,
2966: x_object_version_number => 1,

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

3040: END LOOP;
3041: CLOSE l_get_thresholds;
3042:
3043: -- delete unit_deferrals.
3044: AHL_UNIT_DEFERRALS_PKG.delete_row(x_unit_deferral_id => l_unit_def_rec.unit_deferral_id);
3045:
3046: END IF;
3047: CLOSE ahl_unit_def_csr;
3048: END IF;

Line 3421: AHL_UNIT_DEFERRALS_PKG.insert_row(

3417: END IF;
3418: CLOSE l_get_dup_counter_csr;
3419: ELSE
3420: -- Create unit_deferral record.
3421: AHL_UNIT_DEFERRALS_PKG.insert_row(
3422: x_rowid => l_rowid,
3423: x_unit_deferral_id => l_unit_deferral_id,
3424: x_ata_sequence_id => null,
3425: x_object_version_number => 1,