DBA Data[Home] [Help]

APPS.GHR_DUT_UPD dependencies on HR_UTILITY

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

63: --
64: l_proc varchar2(72) := g_package||'dt_update_dml';
65: --
66: Begin
67: hr_utility.set_location('Entering:'||l_proc, 5);
68: --
69: If (p_datetrack_mode = 'CORRECTION') then
70: hr_utility.set_location(l_proc, 10);
71: --

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

66: Begin
67: hr_utility.set_location('Entering:'||l_proc, 5);
68: --
69: If (p_datetrack_mode = 'CORRECTION') then
70: hr_utility.set_location(l_proc, 10);
71: --
72:
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 110: hr_utility.set_location(' Leaving:'||l_proc, 15);

106: p_rec.effective_start_date := p_validation_start_date;
107: p_rec.effective_end_date := p_validation_end_date;
108: End If;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 15);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status

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

164: --
165: l_proc varchar2(72) := g_package||'update_dml';
166: --
167: Begin
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: dt_update_dml(p_rec => p_rec,
171: p_effective_date => p_effective_date,
172: p_datetrack_mode => p_datetrack_mode,

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

172: p_datetrack_mode => p_datetrack_mode,
173: p_validation_start_date => p_validation_start_date,
174: p_validation_end_date => p_validation_end_date);
175: --
176: hr_utility.set_location(' Leaving:'||l_proc, 10);
177: End update_dml;
178: --
179: -- ----------------------------------------------------------------------------
180: -- |----------------------------< dt_pre_update >-----------------------------|

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

229: l_proc varchar2(72) := g_package||'dt_pre_update';
230: l_dummy_version_number number;
231: --
232: Begin
233: hr_utility.set_location('Entering:'||l_proc, 5);
234: If (p_datetrack_mode <> 'CORRECTION') then
235: hr_utility.set_location(l_proc, 10);
236: --
237: -- Update the current effective end date

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

231: --
232: Begin
233: hr_utility.set_location('Entering:'||l_proc, 5);
234: If (p_datetrack_mode <> 'CORRECTION') then
235: hr_utility.set_location(l_proc, 10);
236: --
237: -- Update the current effective end date
238: --
239: ghr_dut_shd.upd_effective_end_date

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

244: p_validation_end_date => p_validation_end_date,
245: p_object_version_number => p_rec.object_version_number);
246: --
247: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
248: hr_utility.set_location(l_proc, 15);
249: --
250: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
251: -- delete any future rows
252: --

Line 260: hr_utility.set_location(l_proc, 20);

256: p_datetrack_mode => p_datetrack_mode,
257: p_validation_start_date => p_validation_start_date,
258: p_validation_end_date => p_validation_end_date);
259: End If;
260: hr_utility.set_location(l_proc, 20);
261: --
262: -- We must now insert the updated row
263: --
264: ghr_dut_ins.insert_dml

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

267: p_datetrack_mode => p_datetrack_mode,
268: p_validation_start_date => p_validation_start_date,
269: p_validation_end_date => p_validation_end_date);
270: End If;
271: hr_utility.set_location(' Leaving:'||l_proc, 20);
272: End dt_pre_update;
273: --
274: -- ----------------------------------------------------------------------------
275: -- |------------------------------< pre_update >------------------------------|

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

313: --
314: l_proc varchar2(72) := g_package||'pre_update';
315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: --
320: dt_pre_update
321: (p_rec => p_rec,

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

323: p_datetrack_mode => p_datetrack_mode,
324: p_validation_start_date => p_validation_start_date,
325: p_validation_end_date => p_validation_end_date);
326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 10);
328: End pre_update;
329: --
330: -- ----------------------------------------------------------------------------
331: -- |-----------------------------< post_update >------------------------------|

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

368: --
369: l_proc varchar2(72) := g_package||'post_update';
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: ghr_dut_rku.after_update(
375: p_duty_station_id => p_rec.duty_station_id
376: ,p_effective_start_date => p_rec.effective_start_date

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

383: ,p_effective_date => p_effective_date
384: ,p_datetrack_update_mode => p_datetrack_mode
385: ,p_object_version_number => p_rec.object_version_number
386: );
387: hr_utility.set_location(' Leaving:'||l_proc, 10);
388: End post_update;
389: -- ----------------------------------------------------------------------------
390: -- |-----------------------------< convert_defs >-----------------------------|
391: -- ----------------------------------------------------------------------------

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

434: l_proc varchar2(72) := g_package||'convert_defs';
435: --
436: Begin
437: --
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: -- We must now examine each argument value in the
441: -- p_rec plsql record structure
442: -- to see if a system default is being used. If a system default

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

452: p_rec.name :=
453: ghr_dut_shd.g_old_rec.name;
454: End If;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: --
458: End convert_defs;
459: --
460: -- ----------------------------------------------------------------------------

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

471: l_validation_start_date date;
472: l_validation_end_date date;
473: --
474: Begin
475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: -- Ensure that the DateTrack update mode is valid
478: --
479: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_update_mode);

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

555: l_rec ghr_dut_shd.g_rec_type;
556: l_proc varchar2(72) := g_package||'upd';
557: --
558: Begin
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: --
561: -- Call conversion function to turn arguments into the
562: -- l_rec structure.
563: --

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

589: p_effective_start_date := l_rec.effective_start_date;
590: p_effective_end_date := l_rec.effective_end_date;
591: --
592: --
593: hr_utility.set_location(' Leaving:'||l_proc, 10);
594: End upd;
595: --
596: end ghr_dut_upd;