[Home] [Help]
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_ecu_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 pay_ecu_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 pay_ecu_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: := pay_ecu_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: pay_ecu_shd.upd_effective_end_date
220: (p_effective_date => p_effective_date
221: ,p_base_key_value => p_rec.element_class_usage_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 pay_ecu_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 pay_ecu_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: => pay_ecu_shd.g_old_rec.effective_start_date
364: ,p_effective_end_date_o
365: => pay_ecu_shd.g_old_rec.effective_end_date
366: ,p_run_type_id_o
367: => pay_ecu_shd.g_old_rec.run_type_id
361: => p_rec.effective_end_date
362: ,p_effective_start_date_o
363: => pay_ecu_shd.g_old_rec.effective_start_date
364: ,p_effective_end_date_o
365: => pay_ecu_shd.g_old_rec.effective_end_date
366: ,p_run_type_id_o
367: => pay_ecu_shd.g_old_rec.run_type_id
368: ,p_classification_id_o
369: => pay_ecu_shd.g_old_rec.classification_id
363: => pay_ecu_shd.g_old_rec.effective_start_date
364: ,p_effective_end_date_o
365: => pay_ecu_shd.g_old_rec.effective_end_date
366: ,p_run_type_id_o
367: => pay_ecu_shd.g_old_rec.run_type_id
368: ,p_classification_id_o
369: => pay_ecu_shd.g_old_rec.classification_id
370: ,p_business_group_id_o
371: => pay_ecu_shd.g_old_rec.business_group_id
365: => pay_ecu_shd.g_old_rec.effective_end_date
366: ,p_run_type_id_o
367: => pay_ecu_shd.g_old_rec.run_type_id
368: ,p_classification_id_o
369: => pay_ecu_shd.g_old_rec.classification_id
370: ,p_business_group_id_o
371: => pay_ecu_shd.g_old_rec.business_group_id
372: ,p_legislation_code_o
373: => pay_ecu_shd.g_old_rec.legislation_code
367: => pay_ecu_shd.g_old_rec.run_type_id
368: ,p_classification_id_o
369: => pay_ecu_shd.g_old_rec.classification_id
370: ,p_business_group_id_o
371: => pay_ecu_shd.g_old_rec.business_group_id
372: ,p_legislation_code_o
373: => pay_ecu_shd.g_old_rec.legislation_code
374: ,p_object_version_number_o
375: => pay_ecu_shd.g_old_rec.object_version_number
369: => pay_ecu_shd.g_old_rec.classification_id
370: ,p_business_group_id_o
371: => pay_ecu_shd.g_old_rec.business_group_id
372: ,p_legislation_code_o
373: => pay_ecu_shd.g_old_rec.legislation_code
374: ,p_object_version_number_o
375: => pay_ecu_shd.g_old_rec.object_version_number
376: );
377: --
371: => pay_ecu_shd.g_old_rec.business_group_id
372: ,p_legislation_code_o
373: => pay_ecu_shd.g_old_rec.legislation_code
374: ,p_object_version_number_o
375: => pay_ecu_shd.g_old_rec.object_version_number
376: );
377: --
378: exception
379: --
393: -- ----------------------------------------------------------------------------
394: Procedure del
395: (p_effective_date in date
396: ,p_datetrack_mode in varchar2
397: ,p_rec in out nocopy pay_ecu_shd.g_rec_type
398: ) is
399: --
400: l_proc varchar2(72) := g_package||'del';
401: l_validation_start_date date;
409: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
410: --
411: -- We must lock the row which we need to delete.
412: --
413: pay_ecu_shd.lck
414: (p_effective_date => p_effective_date
415: ,p_datetrack_mode => p_datetrack_mode
416: ,p_element_class_usage_id => p_rec.element_class_usage_id
417: ,p_object_version_number => p_rec.object_version_number
478: ,p_effective_start_date out nocopy date
479: ,p_effective_end_date out nocopy date
480: ) is
481: --
482: l_rec pay_ecu_shd.g_rec_type;
483: l_proc varchar2(72) := g_package||'del';
484: --
485: Begin
486: hr_utility.set_location('Entering:'||l_proc, 5);