DBA Data[Home] [Help]

APPS.PQP_VRE_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 90: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

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

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

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

114: ,p_validation_start_date => p_validation_start_date
115: ,p_validation_end_date => p_validation_end_date
116: );
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: END delete_dml;
120: --
121: -- ----------------------------------------------------------------------------
122: -- |----------------------------< dt_pre_delete >-----------------------------|

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

161: --
162: l_proc varchar2(72) := g_package||'dt_pre_delete';
163: --
164: BEGIN
165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: IF (p_datetrack_mode <> hr_api.g_zap) THEN
168: --
169: p_rec.effective_start_date

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

188: ELSE
189: p_rec.effective_start_date := null;
190: p_rec.effective_end_date := null;
191: END IF;
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: where pve.vehicle_repository_id = cp_vehicle_repository_id;
244:
245: --
246: BEGIN
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: pqp_vre_del.dt_pre_delete
250: (p_rec => p_rec
251: ,p_effective_date => p_effective_date

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

266: );
267: End Loop;
268: End If;
269: --
270: hr_utility.set_location(' Leaving:'||l_proc, 10);
271: END pre_delete;
272: --
273: -- ----------------------------------------------------------------------------
274: -- |----------------------------< post_delete >-------------------------------|

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

312: --
313: l_proc varchar2(72) := g_package||'post_delete';
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: begin
318: --
319: pqp_vre_rkd.after_delete
320: (p_effective_date

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

503: (p_module_name => 'PQP_VEHICLE_REPOSITORY_F'
504: ,p_hook_type => 'AD');
505: --
506: end;
507: hr_utility.set_location(' Leaving:'||l_proc, 10);
508: End post_delete;
509: --
510: -- ----------------------------------------------------------------------------
511: -- |---------------------------------< del >----------------------------------|

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

520: l_validation_start_date date;
521: l_validation_end_date date;
522: --
523: Begin
524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: -- Ensure that the DateTrack delete mode is valid
527: --
528: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

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

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

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

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

628: p_object_version_number := l_rec.object_version_number;
629: p_effective_start_date := l_rec.effective_start_date;
630: p_effective_end_date := l_rec.effective_end_date;
631: --
632: hr_utility.set_location(' Leaving:'||l_proc, 10);
633: End del;
634: --
635: end pqp_vre_del;