APPS.AHL_PRD_DF_PVT dependencies on AHL_UNIT_THRESHOLDS_PKG

Line 1972: AHL_UNIT_THRESHOLDS_PKG.delete_row(p_x_df_schedules_tbl(i).unit_threshold_id);

1968:
1969:
1970: FOR i IN p_x_df_schedules_tbl.FIRST..p_x_df_schedules_tbl.LAST LOOP
1971: IF(p_x_df_schedules_tbl(i).operation_flag = G_OP_DELETE) THEN
1972: AHL_UNIT_THRESHOLDS_PKG.delete_row(p_x_df_schedules_tbl(i).unit_threshold_id);
1973: END IF;
1974: END LOOP;
1975:
1976: FOR i IN p_x_df_schedules_tbl.FIRST..p_x_df_schedules_tbl.LAST LOOP

Line 1985: AHL_UNIT_THRESHOLDS_PKG.update_row(

1981: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
1982: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
1983: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
1984:
1985: AHL_UNIT_THRESHOLDS_PKG.update_row(
1986: p_unit_threshold_id => p_x_df_schedules_tbl(i).unit_threshold_id,
1987: p_object_version_number => p_x_df_schedules_tbl(i).object_version_number,
1988: p_last_updated_by => p_x_df_schedules_tbl(i).last_updated_by,
1989: p_last_update_date => p_x_df_schedules_tbl(i).last_update_date,

Line 2025: AHL_UNIT_THRESHOLDS_PKG.insert_row(

2021: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2022: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2023: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
2024:
2025: AHL_UNIT_THRESHOLDS_PKG.insert_row(
2026: p_x_unit_threshold_id => p_x_df_schedules_tbl(i).unit_threshold_id,
2027: p_object_version_number => p_x_df_schedules_tbl(i).object_version_number,
2028: p_created_by => p_x_df_schedules_tbl(i).created_by,
2029: p_creation_date => p_x_df_schedules_tbl(i).creation_date,

Line 4967: AHL_UNIT_THRESHOLDS_PKG.delete_row(redundant_threshold_rec.unit_threshold_id);

4963: END IF;
4964:
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:

Line 5430: AHL_UNIT_THRESHOLDS_PKG.delete_row(redundant_threshold_rec.unit_threshold_id);

5426: IF(unit_deferral_csr%NOTFOUND)THEN
5427: RETURN FALSE;
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;