DBA Data[Home] [Help]

APPS.PER_PER_DEL dependencies on HR_UTILITY

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

59: --
60: l_proc varchar2(72) := g_package||'dt_delete_dml';
61: --
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: per_per_shd.g_api_dml := true; -- Set the api dml status
67: --

Line 65: hr_utility.set_location(l_proc, 10);

61: --
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: per_per_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.

Line 77: hr_utility.set_location(l_proc, 15);

73: and effective_start_date = p_validation_start_date;
74: --
75: per_per_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: per_per_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.

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

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

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

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

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

115: p_datetrack_mode => p_datetrack_mode,
116: p_validation_start_date => p_validation_start_date,
117: p_validation_end_date => p_validation_end_date);
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: End delete_dml;
121: --
122: -- ----------------------------------------------------------------------------
123: -- |----------------------------< 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 <> 'ZAP') then
168: --
169: p_rec.effective_start_date :=

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

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

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

268: or t2.effective_end_date < p_validation_start_date));
269: --
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: --
275: -- Delete any possible comments
276: --

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

309: p_rec => l_per_rec,
310: p_action => 'DELETE');
311: -- End of HR/WF Synchronization
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 10);
314: End pre_delete;
315: --
316: -- ----------------------------------------------------------------------------
317: -- |-----------------------------< post_delete >------------------------------|

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

354: --
355: l_proc varchar2(72) := g_package||'post_delete';
356: --
357: Begin
358: hr_utility.set_location('Entering:'||l_proc, 5);
359: --
360: -- Start of API User Hook for post_delete.
361: begin
362: per_per_rkd.after_delete

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

669: );
670: end;
671: -- End of API User Hook for post_delete.
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
674: End post_delete;
675: --
676: -- ----------------------------------------------------------------------------
677: -- |---------------------------------< del >----------------------------------|

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

688: l_validation_start_date date;
689: l_validation_end_date date;
690: --
691: Begin
692: hr_utility.set_location('Entering:'||l_proc, 5);
693: --
694: -- Ensure that the DateTrack delete mode is valid
695: --
696: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

757: If p_validate then
758: Raise HR_Api.Validate_Enabled;
759: End If;
760: --
761: hr_utility.set_location(' Leaving:'||l_proc, 10);
762: Exception
763: When HR_Api.Validate_Enabled Then
764: --
765: -- As the Validate_Enabled exception has been raised

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

784: l_rec per_per_shd.g_rec_type;
785: l_proc varchar2(72) := g_package||'del';
786: --
787: Begin
788: hr_utility.set_location('Entering:'||l_proc, 5);
789: --
790: -- As the delete procedure accepts a plsql record structure we do need to
791: -- convert the arguments into the record structure.
792: -- We don't need to call the supplied conversion argument routine as we

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

806: p_object_version_number := l_rec.object_version_number;
807: p_effective_start_date := l_rec.effective_start_date;
808: p_effective_end_date := l_rec.effective_end_date;
809: --
810: hr_utility.set_location(' Leaving:'||l_proc, 10);
811: End del;
812: --
813: end per_per_del;