DBA Data[Home] [Help]

APPS.OTA_TMT_INS dependencies on HR_UTILITY

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

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: --
64: --

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

152: );
153: --
154: --
155: --
156: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: Exception
158: When hr_api.check_integrity_violated Then
159: -- A check constraint has been violated
160: --

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

220: --
221: Cursor C_Sel1 is select ota_tp_measurement_types_s.nextval from sys.dual;
222: --
223: Begin
224: hr_utility.set_location('Entering:'||l_proc, 5);
225: --
226: --
227: -- Select the next sequence number
228: --

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

229: Open C_Sel1;
230: Fetch C_Sel1 Into p_rec.tp_measurement_type_id;
231: Close C_Sel1;
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: End pre_insert;
235: --
236: -- ----------------------------------------------------------------------------
237: -- |-----------------------------< post_insert >------------------------------|

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

272: --
273: l_proc varchar2(72) := g_package||'post_insert';
274: --
275: Begin
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: begin
278: --
279: ota_tmt_rki.after_insert
280: (p_effective_date => p_effective_date

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

371: ,p_hook_type => 'AI');
372: --
373: end;
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 10);
376: End post_insert;
377: --
378: -- ----------------------------------------------------------------------------
379: -- |---------------------------------< ins >----------------------------------|

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

385: --
386: l_proc varchar2(72) := g_package||'ins';
387: --
388: Begin
389: hr_utility.set_location('Entering:'||l_proc, 5);
390: --
391: -- Call the supporting insert validate operations
392: --
393: ota_tmt_bus.insert_validate

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

409: (p_effective_date
410: ,p_rec
411: );
412: --
413: hr_utility.set_location('Leaving:'||l_proc, 20);
414: end ins;
415: --
416: -- ----------------------------------------------------------------------------
417: -- |---------------------------------< ins >----------------------------------|

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

464: l_rec ota_tmt_shd.g_rec_type;
465: l_proc varchar2(72) := g_package||'ins';
466: --
467: Begin
468: hr_utility.set_location('Entering:'||l_proc, 5);
469: --
470: -- Call conversion function to turn arguments into the
471: -- p_rec structure.
472: --

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

528: --
529: p_tp_measurement_type_id := l_rec.tp_measurement_type_id;
530: p_object_version_number := l_rec.object_version_number;
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 10);
533: End ins;
534: --
535: end ota_tmt_ins;