[Home] [Help]
60: --
61: l_proc varchar2(72) := g_package||'dt_delete_dml';
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: --
67: --
68: -- Delete the where the effective start date is equal
85: --
86: --
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: End dt_delete_dml;
92: --
93: -- ----------------------------------------------------------------------------
103: --
104: l_proc varchar2(72) := g_package||'delete_dml';
105: --
106: Begin
107: hr_utility.set_location('Entering:'||l_proc, 5);
108: --
109: pay_pga_del.dt_delete_dml
110: (p_rec => p_rec
111: ,p_effective_date => p_effective_date
113: ,p_validation_start_date => p_validation_start_date
114: ,p_validation_end_date => p_validation_end_date
115: );
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: End delete_dml;
119: --
120: -- ----------------------------------------------------------------------------
121: -- |----------------------------< dt_pre_delete >-----------------------------|
160: --
161: l_proc varchar2(72) := g_package||'dt_pre_delete';
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date
187: Else
188: p_rec.effective_start_date := null;
189: p_rec.effective_end_date := null;
190: End If;
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: End dt_pre_delete;
193: --
194: -- ----------------------------------------------------------------------------
195: -- |------------------------------< pre_delete >------------------------------|
236: --
237: --
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: --
243: --
244: pay_pga_del.dt_pre_delete
248: ,p_validation_start_date => p_validation_start_date
249: ,p_validation_end_date => p_validation_end_date
250: );
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: End pre_delete;
254: --
255: -- ----------------------------------------------------------------------------
256: -- |----------------------------< post_delete >-------------------------------|
294: --
295: l_proc varchar2(72) := g_package||'post_delete';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: begin
300: --
301: null;
302: --
301: null;
302: --
303: end;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
306: End post_delete;
307: --
308: -- ----------------------------------------------------------------------------
309: -- |---------------------------------< del >----------------------------------|
318: l_validation_start_date date;
319: l_validation_end_date date;
320: --
321: Begin
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: -- Ensure that the DateTrack delete mode is valid
325: --
326: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
380: --
381: -- Call to raise any errors on multi-message list
382: hr_multi_message.end_validation_set;
383: --
384: hr_utility.set_location(' Leaving:'||l_proc, 5);
385: End del;
386: --
387: -- ----------------------------------------------------------------------------
388: -- |--------------------------------< del >-----------------------------------|
399: l_rec pay_pga_shd.g_rec_type;
400: l_proc varchar2(72) := g_package||'del';
401: --
402: Begin
403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: -- As the delete procedure accepts a plsql record structure we do need to
406: -- convert the arguments into the record structure.
407: -- We don't need to call the supplied conversion argument routine as we
426: p_object_version_number := l_rec.object_version_number;
427: p_effective_start_date := l_rec.effective_start_date;
428: p_effective_end_date := l_rec.effective_end_date;
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 10);
431: End del;
432: --
433: end pay_pga_del;