DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UNIT_DEFERRALS_PKG

Line 398: AHL_UNIT_DEFERRALS_PKG.INSERT_ROW

394: '][position_path_id='||p_x_nonroutine_rec.position_path_id||'][ata_code='||p_x_nonroutine_rec.ata_code||']'
395: );
396: END IF;
397:
398: AHL_UNIT_DEFERRALS_PKG.INSERT_ROW
399: (
400: X_ROWID => l_row_id,
401: X_UNIT_DEFERRAL_ID => l_deferral_id,
402: X_ATTRIBUTE14 => null,

Line 932: AHL_UNIT_DEFERRALS_PKG.UPDATE_ROW

928: OPEN get_deferral_rec(l_unit_effectivity_id);
929: FETCH get_deferral_rec INTO l_deferral_rec;
930: IF (get_deferral_rec%FOUND)
931: THEN
932: AHL_UNIT_DEFERRALS_PKG.UPDATE_ROW
933: (
934: X_UNIT_DEFERRAL_ID => l_deferral_rec.unit_deferral_id,
935: X_ATTRIBUTE14 => l_deferral_rec.attribute14,
936: X_ATTRIBUTE15 => l_deferral_rec.attribute15,

Line 979: AHL_UNIT_DEFERRALS_PKG.INSERT_ROW

975: 'Updated unit_deferral ['||l_deferral_rec.unit_deferral_id||'] with relevant MEL/CDL qualification information'
976: );
977: END IF;
978: ELSE
979: AHL_UNIT_DEFERRALS_PKG.INSERT_ROW
980: (
981: X_ROWID => l_row_id,
982: X_UNIT_DEFERRAL_ID => l_deferral_id,
983: X_ATTRIBUTE14 => null,

Line 3703: AHL_UNIT_DEFERRALS_PKG.insert_row(

3699: END IF;
3700: CLOSE get_new_ue_csr;
3701:
3702: -- Insert row.
3703: AHL_UNIT_DEFERRALS_PKG.insert_row(
3704: x_rowid => l_rowid,
3705: x_unit_deferral_id => l_unit_deferral_id,
3706: x_ata_sequence_id => l_deferral_rec.ata_sequence_id,
3707: x_object_version_number => 1,