[Home] [Help]
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy irc_iad_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
93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy irc_iad_shd.g_rec_type
98: ,p_effective_date in date
99: ,p_datetrack_mode in varchar2
100: ,p_validation_start_date in date
101: ,p_validation_end_date in date
150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy irc_iad_shd.g_rec_type
155: ,p_effective_date in date
156: ,p_datetrack_mode in varchar2
157: ,p_validation_start_date in date
158: ,p_validation_end_date in date
165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date
169: := irc_iad_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else
175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: irc_iad_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_base_key_value => p_rec.assignment_id
182: ,p_new_effective_end_date => p_rec.effective_end_date
183: ,p_validation_start_date => p_validation_start_date
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy irc_iad_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date
284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in irc_iad_shd.g_rec_type
289: ,p_effective_date in date
290: ,p_datetrack_mode in varchar2
291: ,p_validation_start_date in date
292: ,p_validation_end_date in date
309: => p_validation_end_date
310: ,p_assignment_details_id
311: => p_rec.assignment_details_id
312: ,p_assignment_id_o
313: => irc_iad_shd.g_old_rec.assignment_id
314: ,p_effective_start_date_o
315: => irc_iad_shd.g_old_rec.effective_start_date
316: ,p_effective_end_date_o
317: => irc_iad_shd.g_old_rec.effective_end_date
311: => p_rec.assignment_details_id
312: ,p_assignment_id_o
313: => irc_iad_shd.g_old_rec.assignment_id
314: ,p_effective_start_date_o
315: => irc_iad_shd.g_old_rec.effective_start_date
316: ,p_effective_end_date_o
317: => irc_iad_shd.g_old_rec.effective_end_date
318: ,p_details_version_o
319: => irc_iad_shd.g_old_rec.details_version
313: => irc_iad_shd.g_old_rec.assignment_id
314: ,p_effective_start_date_o
315: => irc_iad_shd.g_old_rec.effective_start_date
316: ,p_effective_end_date_o
317: => irc_iad_shd.g_old_rec.effective_end_date
318: ,p_details_version_o
319: => irc_iad_shd.g_old_rec.details_version
320: ,p_latest_details_o
321: => irc_iad_shd.g_old_rec.latest_details
315: => irc_iad_shd.g_old_rec.effective_start_date
316: ,p_effective_end_date_o
317: => irc_iad_shd.g_old_rec.effective_end_date
318: ,p_details_version_o
319: => irc_iad_shd.g_old_rec.details_version
320: ,p_latest_details_o
321: => irc_iad_shd.g_old_rec.latest_details
322: ,p_attempt_id_o
323: => irc_iad_shd.g_old_rec.attempt_id
317: => irc_iad_shd.g_old_rec.effective_end_date
318: ,p_details_version_o
319: => irc_iad_shd.g_old_rec.details_version
320: ,p_latest_details_o
321: => irc_iad_shd.g_old_rec.latest_details
322: ,p_attempt_id_o
323: => irc_iad_shd.g_old_rec.attempt_id
324: ,p_qualified_o
325: => irc_iad_shd.g_old_rec.qualified
319: => irc_iad_shd.g_old_rec.details_version
320: ,p_latest_details_o
321: => irc_iad_shd.g_old_rec.latest_details
322: ,p_attempt_id_o
323: => irc_iad_shd.g_old_rec.attempt_id
324: ,p_qualified_o
325: => irc_iad_shd.g_old_rec.qualified
326: ,p_considered_o
327: => irc_iad_shd.g_old_rec.considered
321: => irc_iad_shd.g_old_rec.latest_details
322: ,p_attempt_id_o
323: => irc_iad_shd.g_old_rec.attempt_id
324: ,p_qualified_o
325: => irc_iad_shd.g_old_rec.qualified
326: ,p_considered_o
327: => irc_iad_shd.g_old_rec.considered
328: ,p_object_version_number_o
329: => irc_iad_shd.g_old_rec.object_version_number
323: => irc_iad_shd.g_old_rec.attempt_id
324: ,p_qualified_o
325: => irc_iad_shd.g_old_rec.qualified
326: ,p_considered_o
327: => irc_iad_shd.g_old_rec.considered
328: ,p_object_version_number_o
329: => irc_iad_shd.g_old_rec.object_version_number
330: );
331: --
325: => irc_iad_shd.g_old_rec.qualified
326: ,p_considered_o
327: => irc_iad_shd.g_old_rec.considered
328: ,p_object_version_number_o
329: => irc_iad_shd.g_old_rec.object_version_number
330: );
331: --
332: exception
333: --
347: -- ----------------------------------------------------------------------------
348: Procedure del
349: (p_effective_date in date
350: ,p_datetrack_mode in varchar2
351: ,p_rec in out nocopy irc_iad_shd.g_rec_type
352: ) is
353: --
354: l_proc varchar2(72) := g_package||'del';
355: l_validation_start_date date;
363: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
364: --
365: -- We must lock the row which we need to delete.
366: --
367: irc_iad_shd.lck
368: (p_effective_date => p_effective_date
369: ,p_datetrack_mode => p_datetrack_mode
370: ,p_assignment_details_id => p_rec.assignment_details_id
371: ,p_object_version_number => p_rec.object_version_number
432: ,p_effective_start_date out nocopy date
433: ,p_effective_end_date out nocopy date
434: ) is
435: --
436: l_rec irc_iad_shd.g_rec_type;
437: l_proc varchar2(72) := g_package||'del';
438: --
439: Begin
440: hr_utility.set_location('Entering:'||l_proc, 5);