DBA Data[Home] [Help]

APPS.PER_ROL_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: -- Insert the row into: per_roles

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

177: );
178: --
179: --
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
182: Exception
183: When hr_api.check_integrity_violated Then
184: -- A check constraint has been violated
185: --

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

245: --
246: Cursor C_Sel1 is select per_roles_s.nextval from sys.dual;
247: --
248: Begin
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: --
252: -- Select the next sequence number
253: --

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

254: Open C_Sel1;
255: Fetch C_Sel1 Into p_rec.role_id;
256: Close C_Sel1;
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259: End pre_insert;
260: --
261: -- ----------------------------------------------------------------------------
262: -- |-----------------------------< post_insert >------------------------------|

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

297: --
298: l_proc varchar2(72) := g_package||'post_insert';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: begin
303: --
304: per_rol_rki.after_insert
305: (p_effective_date => p_effective_date

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

422: ,p_hook_type => 'AI');
423: --
424: end;
425: --
426: hr_utility.set_location(' Leaving:'||l_proc, 10);
427: End post_insert;
428: --
429: -- ----------------------------------------------------------------------------
430: -- |---------------------------------< ins >----------------------------------|

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

436: --
437: l_proc varchar2(72) := g_package||'ins';
438: --
439: Begin
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: -- Call the supporting insert validate operations
443: --
444: per_rol_bus.insert_validate

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

460: (p_effective_date
461: ,p_rec
462: );
463: --
464: hr_utility.set_location('Leaving:'||l_proc, 20);
465: end ins;
466: --
467: -- ----------------------------------------------------------------------------
468: -- |---------------------------------< ins >----------------------------------|

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

528: l_rec per_rol_shd.g_rec_type;
529: l_proc varchar2(72) := g_package||'ins';
530: --
531: Begin
532: hr_utility.set_location('Entering:'||l_proc, 5);
533: --
534: -- Call conversion function to turn arguments into the
535: -- p_rec structure.
536: --

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

606: --
607: p_role_id := l_rec.role_id;
608: p_object_version_number := l_rec.object_version_number;
609: --
610: hr_utility.set_location(' Leaving:'||l_proc, 10);
611: End ins;
612: --
613: end per_rol_ins;