DBA Data[Home] [Help]

APPS.PQP_PTY_DEL dependencies on HR_UTILITY

Line 64: hr_utility.set_location('Entering:'||l_proc, 5);

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

Line 89: hr_utility.set_location(' Leaving:'||l_proc, 20);

85: --
86: --
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: End dt_delete_dml;
92: --
93: -- ----------------------------------------------------------------------------

Line 147: hr_utility.set_location('Entering:'||l_proc, 5);

143: --
144: l_proc varchar2(72) := g_package||'delete_dml';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: pqp_pty_del.dt_delete_dml
150: (p_rec => p_rec
151: ,p_effective_date => p_effective_date

Line 157: hr_utility.set_location(' Leaving:'||l_proc, 10);

153: ,p_validation_start_date => p_validation_start_date
154: ,p_validation_end_date => p_validation_end_date
155: );
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: End delete_dml;
159: --
160: -- ----------------------------------------------------------------------------
161: -- |----------------------------< dt_pre_delete >-----------------------------|

Line 204: hr_utility.set_location('Entering:'||l_proc, 5);

200: --
201: l_proc varchar2(72) := g_package||'dt_pre_delete';
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: If (p_datetrack_mode <> hr_api.g_zap) then
207: --
208: p_rec.effective_start_date

Line 231: hr_utility.set_location(' Leaving:'||l_proc, 10);

227: Else
228: p_rec.effective_start_date := null;
229: p_rec.effective_end_date := null;
230: End If;
231: hr_utility.set_location(' Leaving:'||l_proc, 10);
232: End dt_pre_delete;
233: --
234: -- ----------------------------------------------------------------------------
235: -- |------------------------------< pre_delete >------------------------------|

Line 280: hr_utility.set_location('Entering:'||l_proc, 5);

276: --
277: --
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: --
283: --
284: pqp_pty_del.dt_pre_delete

Line 292: hr_utility.set_location(' Leaving:'||l_proc, 10);

288: ,p_validation_start_date => p_validation_start_date
289: ,p_validation_end_date => p_validation_end_date
290: );
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: End pre_delete;
294: --
295: -- ----------------------------------------------------------------------------
296: -- |----------------------------< post_delete >-------------------------------|

Line 338: hr_utility.set_location('Entering:'||l_proc, 5);

334: --
335: l_proc varchar2(72) := g_package||'post_delete';
336: --
337: Begin
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: begin
340: --
341: -- Delete ownerships if applicable
342: delete_app_ownerships

Line 558: hr_utility.set_location(' Leaving:'||l_proc, 10);

554: ,p_hook_type => 'AD');
555: --
556: end;
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: End post_delete;
560: --
561: -- ----------------------------------------------------------------------------
562: -- |---------------------------------< del >----------------------------------|

Line 575: hr_utility.set_location('Entering:'||l_proc, 5);

571: l_validation_start_date date;
572: l_validation_end_date date;
573: --
574: Begin
575: hr_utility.set_location('Entering:'||l_proc, 5);
576: --
577: -- Ensure that the DateTrack delete mode is valid
578: --
579: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

Line 637: hr_utility.set_location(' Leaving:'||l_proc, 5);

633: --
634: -- Call to raise any errors on multi-message list
635: hr_multi_message.end_validation_set;
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 5);
638: End del;
639: --
640: -- ----------------------------------------------------------------------------
641: -- |--------------------------------< del >-----------------------------------|

Line 669: hr_utility.set_location('Entering:'||l_proc, 5);

665: l_business_group_id pqp_pension_types_f.business_group_id%TYPE;
666: l_pension_type_id pqp_pension_types_f.pension_type_id%TYPE;
667: --
668: Begin
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: -- As the delete procedure accepts a plsql record structure we do need to
672: -- convert the arguments into the record structure.
673: -- We don't need to call the supplied conversion argument routine as we

Line 710: hr_utility.set_location(' Leaving:'||l_proc, 10);

706: p_object_version_number := l_rec.object_version_number;
707: p_effective_start_date := l_rec.effective_start_date;
708: p_effective_end_date := l_rec.effective_end_date;
709: --
710: hr_utility.set_location(' Leaving:'||l_proc, 10);
711: End del;
712: --
713: end pqp_pty_del;
714: