DBA Data[Home] [Help]

APPS.AHL_PRD_DF_PVT dependencies on AHL_UNIT_DEFERRALS_PKG

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

621: IF(p_x_df_header_rec.operation_flag = G_OP_DELETE) THEN
622: -- delete schedules records
623: DELETE AHL_UNIT_THRESHOLDS WHERE UNIT_DEFERRAL_ID = p_x_df_header_rec.unit_deferral_id;
624: -- delete header records.
625: AHL_UNIT_DEFERRALS_PKG.delete_row(x_unit_deferral_id => p_x_df_header_rec.unit_deferral_id);
626: ELSIF(p_x_df_header_rec.operation_flag = G_OP_CREATE) THEN
627: --setting object version number for create
628: p_x_df_header_rec.object_version_number := 1;
629: --setting up user/create/update information

Line 641: AHL_UNIT_DEFERRALS_PKG.insert_row(

637: p_x_df_header_rec.set_due_date := null;
638: p_x_df_header_rec.affect_due_calc_flag := G_NO_FLAG;
639: END IF;
640:
641: AHL_UNIT_DEFERRALS_PKG.insert_row(
642: x_rowid => l_rowid,
643: x_unit_deferral_id => p_x_df_header_rec.unit_deferral_id,
644: x_object_version_number => p_x_df_header_rec.object_version_number,
645: x_created_by => p_x_df_header_rec.created_by,

Line 695: AHL_UNIT_DEFERRALS_PKG.update_row(

691: -- Delete all records in unit thresholds
692: DELETE AHL_UNIT_THRESHOLDS WHERE UNIT_DEFERRAL_ID = p_x_df_header_rec.unit_deferral_id;
693: END IF;
694: p_x_df_header_rec.approval_status_code := 'DRAFT';
695: AHL_UNIT_DEFERRALS_PKG.update_row(
696: x_unit_deferral_id => p_x_df_header_rec.unit_deferral_id,
697: x_object_version_number => p_x_df_header_rec.object_version_number,
698: x_last_updated_by => p_x_df_header_rec.last_updated_by,
699: x_last_update_date => p_x_df_header_rec.last_update_date,

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

4965: FOR redundant_deferral_rec IN redundant_deferral_ue_csr(p_unit_effectivity_id) LOOP
4966: FOR redundant_threshold_rec IN redundant_threshold_csr(redundant_deferral_rec.unit_deferral_id) LOOP
4967: AHL_UNIT_THRESHOLDS_PKG.delete_row(redundant_threshold_rec.unit_threshold_id);
4968: END LOOP;
4969: AHL_UNIT_DEFERRALS_PKG.delete_row(redundant_deferral_rec.unit_deferral_id);
4970: END LOOP;
4971:
4972:
4973: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 5432: AHL_UNIT_DEFERRALS_PKG.delete_row(l_unit_deferral_id);

5428: ELSE
5429: FOR redundant_threshold_rec IN redundant_threshold_csr(l_unit_deferral_id) LOOP
5430: AHL_UNIT_THRESHOLDS_PKG.delete_row(redundant_threshold_rec.unit_threshold_id);
5431: END LOOP;
5432: AHL_UNIT_DEFERRALS_PKG.delete_row(l_unit_deferral_id);
5433: END IF;
5434: RETURN TRUE;
5435: END process_deferred_exceptions;
5436: