DBA Data[Home] [Help]

APPS.PER_DIS_INS dependencies on HR_UTILITY

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

79: l_last_updated_by per_disabilities_f.last_updated_by%TYPE;
80: l_last_update_login per_disabilities_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 <> hr_api.g_insert) then
104: hr_utility.set_location(l_proc, 10);
105: --
106: -- Select the 'old' created values
107: --
108: Open C_Sel1;

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

306: ,l_last_update_login
307: );
308: --
309: --
310: hr_utility.set_location(' Leaving:'||l_proc, 15);
311: --
312: Exception
313: When hr_api.check_integrity_violated Then
314: -- A check constraint has been violated

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

338: --
339: l_proc varchar2(72) := g_package||'insert_dml';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: per_dis_ins.dt_insert_dml
345: (p_rec => p_rec
346: ,p_effective_date => p_effective_date

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

348: ,p_validation_start_date => p_validation_start_date
349: ,p_validation_end_date => p_validation_end_date
350: );
351: --
352: hr_utility.set_location(' Leaving:'||l_proc, 10);
353: End insert_dml;
354: --
355: -- ----------------------------------------------------------------------------
356: -- |------------------------------< pre_insert >------------------------------|

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

403: --
404: Cursor C_Sel1 is select per_disabilities_s.nextval from sys.dual;
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: --
410: -- Select the next sequence number
411: --

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

413: Fetch C_Sel1 Into p_rec.disability_id;
414: Close C_Sel1;
415: --
416: --
417: hr_utility.set_location(' Leaving:'||l_proc, 10);
418: End pre_insert;
419: --
420: -- ----------------------------------------------------------------------------
421: -- |----------------------------< post_insert >-------------------------------|

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

459: --
460: l_proc varchar2(72) := g_package||'post_insert';
461: --
462: Begin
463: hr_utility.set_location('Entering:'||l_proc, 5);
464: begin
465: --
466: per_dis_rki.after_insert
467: (p_effective_date

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

641: ,p_hook_type => 'AI');
642: --
643: end;
644: --
645: hr_utility.set_location(' Leaving:'||l_proc, 10);
646: End post_insert;
647: --
648: -- ----------------------------------------------------------------------------
649: -- |-------------------------------< ins_lck >--------------------------------|

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

693: l_validation_start_date date;
694: l_validation_end_date date;
695: --
696: Begin
697: hr_utility.set_location('Entering:'||l_proc, 5);
698: --
699: -- Validate the datetrack mode mode getting the validation start
700: -- and end dates for the specified datetrack operation.
701: --

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

717: --
718: p_validation_start_date := l_validation_start_date;
719: p_validation_end_date := l_validation_end_date;
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 10);
722: --
723: End ins_lck;
724: --
725: -- ----------------------------------------------------------------------------

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

735: l_validation_start_date date;
736: l_validation_end_date date;
737: --
738: Begin
739: hr_utility.set_location('Entering:'||l_proc, 5);
740: --
741: -- Call the lock operation
742: --
743: per_dis_ins.ins_lck

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

787: ,p_validation_start_date => l_validation_start_date
788: ,p_validation_end_date => l_validation_end_date
789: );
790: --
791: hr_utility.set_location('Leaving:'||l_proc,10);
792: end ins;
793: --
794: -- ----------------------------------------------------------------------------
795: -- |---------------------------------< ins >----------------------------------|

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

881: l_rec per_dis_shd.g_rec_type;
882: l_proc varchar2(72) := g_package||'ins';
883: --
884: Begin
885: hr_utility.set_location('Entering:'||l_proc, 5);
886: --
887: -- Call conversion function to turn arguments into the
888: -- p_rec structure.
889: --

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

987: p_effective_end_date := l_rec.effective_end_date;
988: p_object_version_number := l_rec.object_version_number;
989: --
990: --
991: hr_utility.set_location(' Leaving:'||l_proc, 10);
992: End ins;
993: --
994: end per_dis_ins;