APPS.AHL_PRD_DF_PVT dependencies on AHL_UNIT_THRESHOLDS_PKG

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

2031:
2032:
2033: FOR i IN p_x_df_schedules_tbl.FIRST..p_x_df_schedules_tbl.LAST LOOP
2034: IF(p_x_df_schedules_tbl(i).operation_flag = G_OP_DELETE) THEN
2035: AHL_UNIT_THRESHOLDS_PKG.delete_row(p_x_df_schedules_tbl(i).unit_threshold_id);
2036: END IF;
2037: END LOOP;
2038:
2039: FOR i IN p_x_df_schedules_tbl.FIRST..p_x_df_schedules_tbl.LAST LOOP

Line 2048: AHL_UNIT_THRESHOLDS_PKG.update_row(

2044: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2045: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2046: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
2047:
2048: AHL_UNIT_THRESHOLDS_PKG.update_row(
2049: p_unit_threshold_id => p_x_df_schedules_tbl(i).unit_threshold_id,
2050: p_object_version_number => p_x_df_schedules_tbl(i).object_version_number,
2051: p_last_updated_by => p_x_df_schedules_tbl(i).last_updated_by,
2052: p_last_update_date => p_x_df_schedules_tbl(i).last_update_date,

Line 2088: AHL_UNIT_THRESHOLDS_PKG.insert_row(

2084: p_x_df_schedules_tbl(i).last_updated_by := fnd_global.user_id;
2085: p_x_df_schedules_tbl(i).last_update_date := SYSDATE;
2086: p_x_df_schedules_tbl(i).last_update_login := fnd_global.user_id;
2087:
2088: AHL_UNIT_THRESHOLDS_PKG.insert_row(
2089: p_x_unit_threshold_id => p_x_df_schedules_tbl(i).unit_threshold_id,
2090: p_object_version_number => p_x_df_schedules_tbl(i).object_version_number,
2091: p_created_by => p_x_df_schedules_tbl(i).created_by,
2092: p_creation_date => p_x_df_schedules_tbl(i).creation_date,

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

5341: END IF;
5342:
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:

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

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