DBA Data[Home] [Help]

APPS.PQP_VAL_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 107: hr_utility.set_location('Entering:'||l_proc, 5);

103: --
104: l_proc varchar2(72) := g_package||'delete_dml';
105: --
106: Begin
107: hr_utility.set_location('Entering:'||l_proc, 5);
108: --
109: pqp_val_del.dt_delete_dml
110: (p_rec => p_rec
111: ,p_effective_date => p_effective_date

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

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 >-----------------------------|

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

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

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

188: p_rec.effective_start_date := null;
189: p_rec.effective_end_date := null;
190: End If;
191:
192: hr_utility.set_location(' Leaving:'||l_proc, 10);
193: End dt_pre_delete;
194: --
195: -- ----------------------------------------------------------------------------
196: -- |------------------------------< pre_delete >------------------------------|

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

243: from pqp_veh_alloc_extra_info pva
244: where pva.vehicle_allocation_id = cp_vehicle_allocation_id;
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: pqp_val_del.dt_pre_delete
250: (p_rec => p_rec
251: ,p_effective_date => p_effective_date

Line 288: hr_utility.set_location(' exception:'||l_proc, 9);

284: );
285: End Loop;
286: Exception
287: When Others Then
288: hr_utility.set_location(' exception:'||l_proc, 9);
289: Null;
290: End;
291: End If;
292: --

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

289: Null;
290: End;
291: End If;
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294: End pre_delete;
295: --
296: -- ----------------------------------------------------------------------------
297: -- |----------------------------< post_delete >-------------------------------|

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

336: l_proc varchar2(72) := g_package||'post_delete';
337:
338: --
339: Begin
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: begin
342: --
343: pqp_val_rkd.after_delete
344: (p_effective_date

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

492: (p_module_name => 'PQP_VEHICLE_ALLOCATIONS_F'
493: ,p_hook_type => 'AD');
494: --
495: end;
496: hr_utility.set_location(' Leaving:'||l_proc, 10);
497: End post_delete;
498: --
499: -- ----------------------------------------------------------------------------
500: -- |---------------------------------< del >----------------------------------|

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

509: l_validation_start_date date;
510: l_validation_end_date date;
511: --
512: Begin
513: hr_utility.set_location('Entering:'||l_proc, 5);
514: --
515: -- Ensure that the DateTrack delete mode is valid
516: --
517: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

585: --
586: -- Call to raise any errors on multi-message list
587: hr_multi_message.end_validation_set;
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 5);
590:
591: End del;
592: --
593: -- ----------------------------------------------------------------------------

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

605: l_rec pqp_val_shd.g_rec_type;
606: l_proc varchar2(72) := g_package||'del';
607: --
608: Begin
609: hr_utility.set_location('Entering:'||l_proc, 5);
610: --
611: -- As the delete procedure accepts a plsql record structure we do need to
612: -- convert the arguments into the record structure.
613: -- We don't need to call the supplied conversion argument routine as we

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

632: p_object_version_number := l_rec.object_version_number;
633: p_effective_start_date := l_rec.effective_start_date;
634: p_effective_end_date := l_rec.effective_end_date;
635: --
636: hr_utility.set_location(' Leaving:'||l_proc, 10);
637: End del;
638: --
639: end pqp_val_del;