DBA Data[Home] [Help]

APPS.AHL_PRD_DF_PVT dependencies on AHL_UNIT_DEFERRALS_PKG

Line 643: AHL_UNIT_DEFERRALS_PKG.delete_row(x_unit_deferral_id => p_x_df_header_rec.unit_deferral_id);

639: IF(p_x_df_header_rec.operation_flag = G_OP_DELETE) THEN
640: -- delete schedules records
641: DELETE AHL_UNIT_THRESHOLDS WHERE UNIT_DEFERRAL_ID = p_x_df_header_rec.unit_deferral_id;
642: -- delete header records.
643: AHL_UNIT_DEFERRALS_PKG.delete_row(x_unit_deferral_id => p_x_df_header_rec.unit_deferral_id);
644: ELSIF(p_x_df_header_rec.operation_flag = G_OP_CREATE) THEN
645: --setting object version number for create
646: p_x_df_header_rec.object_version_number := 1;
647: --setting up user/create/update information

Line 659: AHL_UNIT_DEFERRALS_PKG.insert_row(

655: p_x_df_header_rec.set_due_date := null;
656: p_x_df_header_rec.affect_due_calc_flag := G_NO_FLAG;
657: END IF;
658:
659: AHL_UNIT_DEFERRALS_PKG.insert_row(
660: x_rowid => l_rowid,
661: x_unit_deferral_id => p_x_df_header_rec.unit_deferral_id,
662: x_object_version_number => p_x_df_header_rec.object_version_number,
663: x_created_by => p_x_df_header_rec.created_by,

Line 714: AHL_UNIT_DEFERRALS_PKG.update_row(

710: -- Delete all records in unit thresholds
711: DELETE AHL_UNIT_THRESHOLDS WHERE UNIT_DEFERRAL_ID = p_x_df_header_rec.unit_deferral_id;
712: END IF;
713: p_x_df_header_rec.approval_status_code := 'DRAFT';
714: AHL_UNIT_DEFERRALS_PKG.update_row(
715: x_unit_deferral_id => p_x_df_header_rec.unit_deferral_id,
716: x_object_version_number => p_x_df_header_rec.object_version_number,
717: x_last_updated_by => p_x_df_header_rec.last_updated_by,
718: x_last_update_date => p_x_df_header_rec.last_update_date,

Line 5347: AHL_UNIT_DEFERRALS_PKG.delete_row(redundant_deferral_rec.unit_deferral_id);

5343: FOR redundant_deferral_rec IN redundant_deferral_ue_csr(p_unit_effectivity_id) LOOP
5344: FOR redundant_threshold_rec IN redundant_threshold_csr(redundant_deferral_rec.unit_deferral_id) LOOP
5345: AHL_UNIT_THRESHOLDS_PKG.delete_row(redundant_threshold_rec.unit_threshold_id);
5346: END LOOP;
5347: AHL_UNIT_DEFERRALS_PKG.delete_row(redundant_deferral_rec.unit_deferral_id);
5348: END LOOP;
5349:
5350:
5351: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 5905: AHL_UNIT_DEFERRALS_PKG.delete_row(l_unit_deferral_id);

5901: ELSE
5902: FOR redundant_threshold_rec IN redundant_threshold_csr(l_unit_deferral_id) LOOP
5903: AHL_UNIT_THRESHOLDS_PKG.delete_row(redundant_threshold_rec.unit_threshold_id);
5904: END LOOP;
5905: AHL_UNIT_DEFERRALS_PKG.delete_row(l_unit_deferral_id);
5906: END IF;
5907: RETURN TRUE;
5908: END process_deferred_exceptions;
5909: