DBA Data[Home] [Help]

APPS.GHR_DUT_INS dependencies on HR_UTILITY

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

79: l_last_updated_by ghr_duty_stations_f.last_updated_by%TYPE;
80: l_last_update_login ghr_duty_stations_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --
85: -- Get the object version number for the insert
86: --
87: p_rec.object_version_number :=

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

100: -- If the datetrack_mode is not INSERT then we must populate the WHO
101: -- columns with the 'old' creation values and 'new' updated values.
102: --
103: If (p_datetrack_mode <> 'INSERT') then
104: hr_utility.set_location(l_proc, 10);
105: --
106: -- Select the 'old' created values
107: --
108: Open C_Sel1;

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

172: l_last_update_login
173: );
174: --
175: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
176: hr_utility.set_location(' Leaving:'||l_proc, 15);
177: --
178: Exception
179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated

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

203: --
204: l_proc varchar2(72) := g_package||'insert_dml';
205: --
206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: dt_insert_dml(p_rec => p_rec,
210: p_effective_date => p_effective_date,
211: p_datetrack_mode => p_datetrack_mode,

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

211: p_datetrack_mode => p_datetrack_mode,
212: p_validation_start_date => p_validation_start_date,
213: p_validation_end_date => p_validation_end_date);
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: End insert_dml;
217: --
218: -- ----------------------------------------------------------------------------
219: -- |------------------------------< pre_insert >------------------------------|

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

269: from dual;
270: --
271: --
272: Begin
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: open c1;
276: fetch c1 into p_rec.duty_station_id;
277: close c1;

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

275: open c1;
276: fetch c1 into p_rec.duty_station_id;
277: close c1;
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: End pre_insert;
281: --
282: -- ----------------------------------------------------------------------------
283: -- |-----------------------------< post_insert >------------------------------|

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

320: --
321: l_proc varchar2(72) := g_package||'post_insert';
322: --
323: Begin
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: ghr_dut_rki.after_insert(
327: p_duty_station_id => p_rec.duty_station_id
328: ,p_effective_start_date => p_rec.effective_start_date

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

338: ,p_is_duty_station => p_rec.is_duty_station
339: ,p_effective_date => trunc(p_effective_date)
340: ,p_object_version_number => p_rec.object_version_number
341: );
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: End post_insert;
344: --
345: -- ----------------------------------------------------------------------------
346: -- |-------------------------------< ins_lck >--------------------------------|

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

389: l_validation_start_date date;
390: l_validation_end_date date;
391: --
392: Begin
393: hr_utility.set_location('Entering:'||l_proc, 5);
394: --
395: -- Validate the datetrack mode mode getting the validation start
396: -- and end dates for the specified datetrack operation.
397: --

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

409: --
410: p_validation_start_date := l_validation_start_date;
411: p_validation_end_date := l_validation_end_date;
412: --
413: hr_utility.set_location(' Leaving:'||l_proc, 10);
414: --
415: End ins_lck;
416: --
417: -- ----------------------------------------------------------------------------

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

428: l_validation_start_date date;
429: l_validation_end_date date;
430: --
431: Begin
432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: -- Call the lock operation
435: --
436: ins_lck

Line 479: hr_utility.set_location('Leaving INS2',30);

475: p_datetrack_mode => l_datetrack_mode,
476: p_validation_start_date => l_validation_start_date,
477: p_validation_end_date => l_validation_end_date);
478:
479: hr_utility.set_location('Leaving INS2',30);
480: end ins;
481: --
482: -- ----------------------------------------------------------------------------
483: -- |---------------------------------< ins >----------------------------------|

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

503: l_rec ghr_dut_shd.g_rec_type;
504: l_proc varchar2(72) := g_package||'ins';
505: --
506: Begin
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --
509: -- Call conversion function to turn arguments into the
510: -- p_rec structure.
511: --

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

539: p_effective_start_date := l_rec.effective_start_date;
540: p_effective_end_date := l_rec.effective_end_date;
541: --
542: --
543: hr_utility.set_location(' Leaving:'||l_proc, 10);
544: End ins;
545: --
546: end ghr_dut_ins;