DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UNIT_DEFERRALS_PKG

Line 430: AHL_UNIT_DEFERRALS_PKG.INSERT_ROW

426: '][position_path_id='||p_x_nonroutine_rec.position_path_id||'][ata_code='||p_x_nonroutine_rec.ata_code||']'
427: );
428: END IF;
429:
430: AHL_UNIT_DEFERRALS_PKG.INSERT_ROW
431: (
432: X_ROWID => l_row_id,
433: X_UNIT_DEFERRAL_ID => l_deferral_id,
434: X_ATTRIBUTE14 => null,

Line 1013: AHL_UNIT_DEFERRALS_PKG.UPDATE_ROW

1009: OPEN get_deferral_rec(l_unit_effectivity_id);
1010: FETCH get_deferral_rec INTO l_deferral_rec;
1011: IF (get_deferral_rec%FOUND)
1012: THEN
1013: AHL_UNIT_DEFERRALS_PKG.UPDATE_ROW
1014: (
1015: X_UNIT_DEFERRAL_ID => l_deferral_rec.unit_deferral_id,
1016: X_ATTRIBUTE14 => l_deferral_rec.attribute14,
1017: X_ATTRIBUTE15 => l_deferral_rec.attribute15,

Line 1061: AHL_UNIT_DEFERRALS_PKG.INSERT_ROW

1057: 'Updated unit_deferral ['||l_deferral_rec.unit_deferral_id||'] with relevant MEL/CDL qualification information'
1058: );
1059: END IF;
1060: ELSE
1061: AHL_UNIT_DEFERRALS_PKG.INSERT_ROW
1062: (
1063: X_ROWID => l_row_id,
1064: X_UNIT_DEFERRAL_ID => l_deferral_id,
1065: X_ATTRIBUTE14 => null,

Line 3957: AHL_UNIT_DEFERRALS_PKG.insert_row(

3953: END IF;
3954: CLOSE get_new_ue_csr;
3955:
3956: -- Insert row.
3957: AHL_UNIT_DEFERRALS_PKG.insert_row(
3958: x_rowid => l_rowid,
3959: x_unit_deferral_id => l_unit_deferral_id,
3960: x_ata_sequence_id => l_deferral_rec.ata_sequence_id,
3961: x_object_version_number => 1,