DBA Data[Home] [Help]

APPS.PQH_DOC_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: pqh_doc_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal

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

85: --
86: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status

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

108: --
109: l_proc varchar2(72) := g_package||'delete_dml';
110: --
111: Begin
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: pqh_doc_del.dt_delete_dml
115: (p_rec => p_rec
116: ,p_effective_date => p_effective_date

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

118: ,p_validation_start_date => p_validation_start_date
119: ,p_validation_end_date => p_validation_end_date
120: );
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: End delete_dml;
124: --
125: -- ----------------------------------------------------------------------------
126: -- |----------------------------< dt_pre_delete >-----------------------------|

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

165: --
166: l_proc varchar2(72) := g_package||'dt_pre_delete';
167: --
168: Begin
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date

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

192: Else
193: p_rec.effective_start_date := null;
194: p_rec.effective_end_date := null;
195: End If;
196: hr_utility.set_location(' Leaving:'||l_proc, 10);
197: End dt_pre_delete;
198: --
199: -- ----------------------------------------------------------------------------
200: -- |------------------------------< pre_delete >------------------------------|

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

241: --
242: --
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: --
248: --
249: pqh_doc_del.dt_pre_delete

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

253: ,p_validation_start_date => p_validation_start_date
254: ,p_validation_end_date => p_validation_end_date
255: );
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 10);
258: End pre_delete;
259: --
260: -- ----------------------------------------------------------------------------
261: -- |----------------------------< post_delete >-------------------------------|

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

299: --
300: l_proc varchar2(72) := g_package||'post_delete';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: begin
305: --
306: pqh_doc_rkd.after_delete
307: (p_effective_date

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

356: ,p_hook_type => 'AD');
357: --
358: end;
359: --
360: hr_utility.set_location(' Leaving:'||l_proc, 10);
361: End post_delete;
362: --
363: -- ----------------------------------------------------------------------------
364: -- |---------------------------------< del >----------------------------------|

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

373: l_validation_start_date date;
374: l_validation_end_date date;
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Ensure that the DateTrack delete mode is valid
380: --
381: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

435: --
436: -- Call to raise any errors on multi-message list
437: hr_multi_message.end_validation_set;
438: --
439: hr_utility.set_location(' Leaving:'||l_proc, 5);
440: End del;
441: --
442: -- ----------------------------------------------------------------------------
443: -- |--------------------------------< del >-----------------------------------|

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

454: l_rec pqh_doc_shd.g_rec_type;
455: l_proc varchar2(72) := g_package||'del';
456: --
457: Begin
458: hr_utility.set_location('Entering:'||l_proc, 5);
459: --
460: -- As the delete procedure accepts a plsql record structure we do need to
461: -- convert the arguments into the record structure.
462: -- We don't need to call the supplied conversion argument routine as we

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

481: p_object_version_number := l_rec.object_version_number;
482: p_effective_start_date := l_rec.effective_start_date;
483: p_effective_end_date := l_rec.effective_end_date;
484: --
485: hr_utility.set_location(' Leaving:'||l_proc, 10);
486: End del;
487: --
488: end pqh_doc_del;