50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pqh_rmr_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date
133: -- ----------------------------------------------------------------------------
134: -- |------------------------------< delete_dml >------------------------------|
135: -- ----------------------------------------------------------------------------
136: Procedure delete_dml
137: (p_rec in out nocopy pqh_rmr_shd.g_rec_type
138: ,p_effective_date in date
139: ,p_datetrack_mode in varchar2
140: ,p_validation_start_date in date
141: ,p_validation_end_date in date
190: --
191: -- {End Of Comments}
192: -- ----------------------------------------------------------------------------
193: Procedure dt_pre_delete
194: (p_rec in out nocopy pqh_rmr_shd.g_rec_type
195: ,p_effective_date in date
196: ,p_datetrack_mode in varchar2
197: ,p_validation_start_date in date
198: ,p_validation_end_date in date
205: --
206: If (p_datetrack_mode <> hr_api.g_zap) then
207: --
208: p_rec.effective_start_date
209: := pqh_rmr_shd.g_old_rec.effective_start_date;
210: --
211: If (p_datetrack_mode = hr_api.g_delete) then
212: p_rec.effective_end_date := p_validation_start_date - 1;
213: Else
215: End If;
216: --
217: -- Update the current effective end date record
218: --
219: pqh_rmr_shd.upd_effective_end_date
220: (p_effective_date => p_effective_date
221: ,p_base_key_value => p_rec.rate_matrix_rate_id
222: ,p_new_effective_end_date => p_rec.effective_end_date
223: ,p_validation_start_date => p_validation_start_date
264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure pre_delete
268: (p_rec in out nocopy pqh_rmr_shd.g_rec_type
269: ,p_effective_date in date
270: ,p_datetrack_mode in varchar2
271: ,p_validation_start_date in date
272: ,p_validation_end_date in date
324: --
325: -- {End Of Comments}
326: -- ----------------------------------------------------------------------------
327: Procedure post_delete
328: (p_rec in pqh_rmr_shd.g_rec_type
329: ,p_effective_date in date
330: ,p_datetrack_mode in varchar2
331: ,p_validation_start_date in date
332: ,p_validation_end_date in date
359: => p_rec.effective_start_date
360: ,p_effective_end_date
361: => p_rec.effective_end_date
362: ,p_effective_start_date_o
363: => pqh_rmr_shd.g_old_rec.effective_start_date
364: ,p_effective_end_date_o
365: => pqh_rmr_shd.g_old_rec.effective_end_date
366: ,p_rate_matrix_node_id_o
367: => pqh_rmr_shd.g_old_rec.rate_matrix_node_id
361: => p_rec.effective_end_date
362: ,p_effective_start_date_o
363: => pqh_rmr_shd.g_old_rec.effective_start_date
364: ,p_effective_end_date_o
365: => pqh_rmr_shd.g_old_rec.effective_end_date
366: ,p_rate_matrix_node_id_o
367: => pqh_rmr_shd.g_old_rec.rate_matrix_node_id
368: ,p_criteria_rate_defn_id_o
369: => pqh_rmr_shd.g_old_rec.criteria_rate_defn_id
363: => pqh_rmr_shd.g_old_rec.effective_start_date
364: ,p_effective_end_date_o
365: => pqh_rmr_shd.g_old_rec.effective_end_date
366: ,p_rate_matrix_node_id_o
367: => pqh_rmr_shd.g_old_rec.rate_matrix_node_id
368: ,p_criteria_rate_defn_id_o
369: => pqh_rmr_shd.g_old_rec.criteria_rate_defn_id
370: ,p_min_rate_value_o
371: => pqh_rmr_shd.g_old_rec.min_rate_value
365: => pqh_rmr_shd.g_old_rec.effective_end_date
366: ,p_rate_matrix_node_id_o
367: => pqh_rmr_shd.g_old_rec.rate_matrix_node_id
368: ,p_criteria_rate_defn_id_o
369: => pqh_rmr_shd.g_old_rec.criteria_rate_defn_id
370: ,p_min_rate_value_o
371: => pqh_rmr_shd.g_old_rec.min_rate_value
372: ,p_max_rate_value_o
373: => pqh_rmr_shd.g_old_rec.max_rate_value
367: => pqh_rmr_shd.g_old_rec.rate_matrix_node_id
368: ,p_criteria_rate_defn_id_o
369: => pqh_rmr_shd.g_old_rec.criteria_rate_defn_id
370: ,p_min_rate_value_o
371: => pqh_rmr_shd.g_old_rec.min_rate_value
372: ,p_max_rate_value_o
373: => pqh_rmr_shd.g_old_rec.max_rate_value
374: ,p_mid_rate_value_o
375: => pqh_rmr_shd.g_old_rec.mid_rate_value
369: => pqh_rmr_shd.g_old_rec.criteria_rate_defn_id
370: ,p_min_rate_value_o
371: => pqh_rmr_shd.g_old_rec.min_rate_value
372: ,p_max_rate_value_o
373: => pqh_rmr_shd.g_old_rec.max_rate_value
374: ,p_mid_rate_value_o
375: => pqh_rmr_shd.g_old_rec.mid_rate_value
376: ,p_rate_value_o
377: => pqh_rmr_shd.g_old_rec.rate_value
371: => pqh_rmr_shd.g_old_rec.min_rate_value
372: ,p_max_rate_value_o
373: => pqh_rmr_shd.g_old_rec.max_rate_value
374: ,p_mid_rate_value_o
375: => pqh_rmr_shd.g_old_rec.mid_rate_value
376: ,p_rate_value_o
377: => pqh_rmr_shd.g_old_rec.rate_value
378: ,p_business_group_id_o
379: => pqh_rmr_shd.g_old_rec.business_group_id
373: => pqh_rmr_shd.g_old_rec.max_rate_value
374: ,p_mid_rate_value_o
375: => pqh_rmr_shd.g_old_rec.mid_rate_value
376: ,p_rate_value_o
377: => pqh_rmr_shd.g_old_rec.rate_value
378: ,p_business_group_id_o
379: => pqh_rmr_shd.g_old_rec.business_group_id
380: ,p_legislation_code_o
381: => pqh_rmr_shd.g_old_rec.legislation_code
375: => pqh_rmr_shd.g_old_rec.mid_rate_value
376: ,p_rate_value_o
377: => pqh_rmr_shd.g_old_rec.rate_value
378: ,p_business_group_id_o
379: => pqh_rmr_shd.g_old_rec.business_group_id
380: ,p_legislation_code_o
381: => pqh_rmr_shd.g_old_rec.legislation_code
382: ,p_object_version_number_o
383: => pqh_rmr_shd.g_old_rec.object_version_number
377: => pqh_rmr_shd.g_old_rec.rate_value
378: ,p_business_group_id_o
379: => pqh_rmr_shd.g_old_rec.business_group_id
380: ,p_legislation_code_o
381: => pqh_rmr_shd.g_old_rec.legislation_code
382: ,p_object_version_number_o
383: => pqh_rmr_shd.g_old_rec.object_version_number
384: );
385: --
379: => pqh_rmr_shd.g_old_rec.business_group_id
380: ,p_legislation_code_o
381: => pqh_rmr_shd.g_old_rec.legislation_code
382: ,p_object_version_number_o
383: => pqh_rmr_shd.g_old_rec.object_version_number
384: );
385: --
386: exception
387: --
401: -- ----------------------------------------------------------------------------
402: Procedure del
403: (p_effective_date in date
404: ,p_datetrack_mode in varchar2
405: ,p_rec in out nocopy pqh_rmr_shd.g_rec_type
406: ) is
407: --
408: l_proc varchar2(72) := g_package||'del';
409: l_validation_start_date date;
417: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
418: --
419: -- We must lock the row which we need to delete.
420: --
421: pqh_rmr_shd.lck
422: (p_effective_date => p_effective_date
423: ,p_datetrack_mode => p_datetrack_mode
424: ,p_rate_matrix_rate_id => p_rec.rate_matrix_rate_id
425: ,p_object_version_number => p_rec.object_version_number
486: ,p_effective_start_date out nocopy date
487: ,p_effective_end_date out nocopy date
488: ) is
489: --
490: l_rec pqh_rmr_shd.g_rec_type;
491: l_proc varchar2(72) := g_package||'del';
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);