eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_DUT_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: ghr_dut_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: ghr_dut_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 71: hr_utility.set_location('dt_delete_dml NAR IF ',10);

67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: hr_utility.set_location('dt_delete_dml NAR IF ',10);
72: delete from ghr_duty_stations_f
73: where duty_station_id = p_rec.duty_station_id
74: and effective_start_date = p_validation_start_date;
75: --

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

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

Line 84: hr_utility.set_location('dt_delete_dml NAR ELSE ',15);

80: --
81: -- Delete the row(s) where the effective start date is greater than
82: -- or equal to the validation start date.
83: --
84: hr_utility.set_location('dt_delete_dml NAR ELSE ',15);
85: delete from ghr_duty_stations_f
86: where duty_station_id = p_rec.duty_station_id
87: and effective_start_date >= p_validation_start_date;
88: --

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

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

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

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

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

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

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

163: --
164: l_proc varchar2(72) := g_package||'dt_pre_delete';
165: --
166: Begin
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: If (p_datetrack_mode <> 'ZAP') then
170: --
171: p_rec.effective_start_date := ghr_dut_shd.g_old_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 240: hr_utility.set_location('Entering:'||l_proc, 5);

236: --
237: --
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: --
243: --
244: dt_pre_delete

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

247: p_datetrack_mode => p_datetrack_mode,
248: p_validation_start_date => p_validation_start_date,
249: p_validation_end_date => p_validation_end_date);
250: --
251: hr_utility.set_location(' Leaving:'||l_proc, 10);
252: End pre_delete;
253: --
254: -- ----------------------------------------------------------------------------
255: -- |-----------------------------< post_delete >------------------------------|

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

292: --
293: l_proc varchar2(72) := g_package||'post_delete';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: ghr_dut_rkd.after_delete(
299: p_duty_station_id => p_rec.duty_station_id
300: ,p_object_version_number => p_rec. object_version_number

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

298: ghr_dut_rkd.after_delete(
299: p_duty_station_id => p_rec.duty_station_id
300: ,p_object_version_number => p_rec. object_version_number
301: );
302: hr_utility.set_location(' Leaving:'||l_proc, 10);
303: End post_delete;
304: --
305: -- ----------------------------------------------------------------------------
306: -- |---------------------------------< del >----------------------------------|

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

316: l_validation_start_date date;
317: l_validation_end_date date;
318: --
319: Begin
320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: -- Ensure that the DateTrack delete mode is valid
323: --
324: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

387: l_rec ghr_dut_shd.g_rec_type;
388: l_proc varchar2(72) := g_package||'del';
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: -- As the delete procedure accepts a plsql record structure we do need to
394: -- convert the arguments into the record structure.
395: -- We don't need to call the supplied conversion argument routine as we

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

408: --
409: p_effective_start_date := l_rec.effective_start_date;
410: p_effective_end_date := l_rec.effective_end_date;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: End del;
414: --
415: end ghr_dut_del;