[Home] [Help]
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ame_atu_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
95: -- ----------------------------------------------------------------------------
96: -- |------------------------------< delete_dml >------------------------------|
97: -- ----------------------------------------------------------------------------
98: Procedure delete_dml
99: (p_rec in out nocopy ame_atu_shd.g_rec_type
100: ,p_effective_date in date
101: ,p_datetrack_mode in varchar2
102: ,p_validation_start_date in date
103: ,p_validation_end_date in date
152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ame_atu_shd.g_rec_type
157: ,p_effective_date in date
158: ,p_datetrack_mode in varchar2
159: ,p_validation_start_date in date
160: ,p_validation_end_date in date
167: --
168: If (p_datetrack_mode <> hr_api.g_zap) then
169: --
170: p_rec.start_date
171: := ame_atu_shd.g_old_rec.start_date;
172: --
173: If (p_datetrack_mode = hr_api.g_delete) then
174: p_rec.end_date := p_validation_start_date;
175: Else
177: End If;
178: --
179: -- Update the current effective end date record
180: --
181: ame_atu_shd.upd_end_date
182: (p_effective_date => p_effective_date
183: ,p_attribute_id => p_rec.attribute_id
184: ,p_application_id => p_rec.application_id
185: ,p_new_end_date => p_rec.end_date
225: --
226: -- {End Of Comments}
227: -- ----------------------------------------------------------------------------
228: Procedure pre_delete
229: (p_rec in out nocopy ame_atu_shd.g_rec_type
230: ,p_effective_date in date
231: ,p_datetrack_mode in varchar2
232: ,p_validation_start_date in date
233: ,p_validation_end_date in date
285: --
286: -- {End Of Comments}
287: -- ----------------------------------------------------------------------------
288: Procedure post_delete
289: (p_rec in ame_atu_shd.g_rec_type
290: ,p_effective_date in date
291: ,p_datetrack_mode in varchar2
292: ,p_validation_start_date in date
293: ,p_validation_end_date in date
316: => p_rec.start_date
317: ,p_end_date
318: => p_rec.end_date
319: ,p_query_string_o
320: => ame_atu_shd.g_old_rec.query_string
321: ,p_use_count_o
322: => ame_atu_shd.g_old_rec.use_count
323: ,p_user_editable_o
324: => ame_atu_shd.g_old_rec.user_editable
318: => p_rec.end_date
319: ,p_query_string_o
320: => ame_atu_shd.g_old_rec.query_string
321: ,p_use_count_o
322: => ame_atu_shd.g_old_rec.use_count
323: ,p_user_editable_o
324: => ame_atu_shd.g_old_rec.user_editable
325: ,p_is_static_o
326: => ame_atu_shd.g_old_rec.is_static
320: => ame_atu_shd.g_old_rec.query_string
321: ,p_use_count_o
322: => ame_atu_shd.g_old_rec.use_count
323: ,p_user_editable_o
324: => ame_atu_shd.g_old_rec.user_editable
325: ,p_is_static_o
326: => ame_atu_shd.g_old_rec.is_static
327: ,p_start_date_o
328: => ame_atu_shd.g_old_rec.start_date
322: => ame_atu_shd.g_old_rec.use_count
323: ,p_user_editable_o
324: => ame_atu_shd.g_old_rec.user_editable
325: ,p_is_static_o
326: => ame_atu_shd.g_old_rec.is_static
327: ,p_start_date_o
328: => ame_atu_shd.g_old_rec.start_date
329: ,p_end_date_o
330: => ame_atu_shd.g_old_rec.end_date
324: => ame_atu_shd.g_old_rec.user_editable
325: ,p_is_static_o
326: => ame_atu_shd.g_old_rec.is_static
327: ,p_start_date_o
328: => ame_atu_shd.g_old_rec.start_date
329: ,p_end_date_o
330: => ame_atu_shd.g_old_rec.end_date
331: ,p_security_group_id_o
332: => ame_atu_shd.g_old_rec.security_group_id
326: => ame_atu_shd.g_old_rec.is_static
327: ,p_start_date_o
328: => ame_atu_shd.g_old_rec.start_date
329: ,p_end_date_o
330: => ame_atu_shd.g_old_rec.end_date
331: ,p_security_group_id_o
332: => ame_atu_shd.g_old_rec.security_group_id
333: ,p_value_set_id_o
334: => ame_atu_shd.g_old_rec.value_set_id
328: => ame_atu_shd.g_old_rec.start_date
329: ,p_end_date_o
330: => ame_atu_shd.g_old_rec.end_date
331: ,p_security_group_id_o
332: => ame_atu_shd.g_old_rec.security_group_id
333: ,p_value_set_id_o
334: => ame_atu_shd.g_old_rec.value_set_id
335: ,p_object_version_number_o
336: => ame_atu_shd.g_old_rec.object_version_number
330: => ame_atu_shd.g_old_rec.end_date
331: ,p_security_group_id_o
332: => ame_atu_shd.g_old_rec.security_group_id
333: ,p_value_set_id_o
334: => ame_atu_shd.g_old_rec.value_set_id
335: ,p_object_version_number_o
336: => ame_atu_shd.g_old_rec.object_version_number
337: );
338: --
332: => ame_atu_shd.g_old_rec.security_group_id
333: ,p_value_set_id_o
334: => ame_atu_shd.g_old_rec.value_set_id
335: ,p_object_version_number_o
336: => ame_atu_shd.g_old_rec.object_version_number
337: );
338: --
339: exception
340: --
354: -- ----------------------------------------------------------------------------
355: Procedure del
356: (p_effective_date in date
357: ,p_datetrack_mode in varchar2
358: ,p_rec in out nocopy ame_atu_shd.g_rec_type
359: ) is
360: --
361: l_proc varchar2(72) := g_package||'del';
362: l_validation_start_date date;
370: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
371: --
372: -- We must lock the row which we need to delete.
373: --
374: ame_atu_shd.lck
375: (p_effective_date => p_effective_date
376: ,p_datetrack_mode => p_datetrack_mode
377: ,p_attribute_id => p_rec.attribute_id
378: ,p_application_id => p_rec.application_id
441: ,p_start_date out nocopy date
442: ,p_end_date out nocopy date
443: ) is
444: --
445: l_rec ame_atu_shd.g_rec_type;
446: l_proc varchar2(72) := g_package||'del';
447: --
448: Begin
449: hr_utility.set_location('Entering:'||l_proc, 5);