DBA Data[Home] [Help]

APPS.OTA_TPC_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 216: hr_utility.set_location(' Leaving:'||l_proc, 10);

212: );
213: --
214: --
215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 10);
217: Exception
218: When hr_api.check_integrity_violated Then
219: -- A check constraint has been violated
220: --

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

280: --
281: Cursor C_Sel1 is select ota_training_plan_costs_s.nextval from sys.dual;
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: --
287: -- Select the next sequence number
288: --

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

289: Open C_Sel1;
290: Fetch C_Sel1 Into p_rec.training_plan_cost_id;
291: Close C_Sel1;
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294: End pre_insert;
295: --
296: -- ----------------------------------------------------------------------------
297: -- |-----------------------------< post_insert >------------------------------|

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

332: --
333: l_proc varchar2(72) := g_package||'post_insert';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: begin
338: --
339: ota_tpc_rki.after_insert
340: (p_effective_date => p_effective_date

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

491: ,p_hook_type => 'AI');
492: --
493: end;
494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 10);
496: End post_insert;
497: --
498: -- ----------------------------------------------------------------------------
499: -- |---------------------------------< ins >----------------------------------|

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

505: --
506: l_proc varchar2(72) := g_package||'ins';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Call the supporting insert validate operations
512: --
513: ota_tpc_bus.insert_validate

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

529: (p_effective_date
530: ,p_rec
531: );
532: --
533: hr_utility.set_location('Leaving:'||l_proc, 20);
534: end ins;
535: --
536: -- ----------------------------------------------------------------------------
537: -- |---------------------------------< ins >----------------------------------|

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

614: l_rec ota_tpc_shd.g_rec_type;
615: l_proc varchar2(72) := g_package||'ins';
616: --
617: Begin
618: hr_utility.set_location('Entering:'||l_proc, 5);
619: --
620: -- Call conversion function to turn arguments into the
621: -- p_rec structure.
622: --

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

708: --
709: p_training_plan_cost_id := l_rec.training_plan_cost_id;
710: p_object_version_number := l_rec.object_version_number;
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 10);
713: End ins;
714: --
715: end ota_tpc_ins;