APPS.OTA_OFF_UPD dependencies on HR_UTILITY

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

59: --
60: l_proc varchar2(72) := g_package||'update_dml';
61: --
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: --
65: -- Increment the object version
66: p_rec.object_version_number := p_rec.object_version_number + 1;
67: --

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

123: where offering_id = p_rec.offering_id;
124: --
125: --
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated

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

185: --
186: l_proc varchar2(72) := g_package||'pre_update';
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: End pre_update;
193: --

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

187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: End pre_update;
193: --
194: -- ----------------------------------------------------------------------------
195: -- |-----------------------------< post_update >------------------------------|

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

232: l_activity_version_id_changed boolean := ota_general.value_changed(ota_off_shd.g_old_rec.activity_version_id,
233: p_rec.activity_version_id);
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: begin
238: --
239: if l_activity_version_id_changed then
240: update_evt_when_course_change( p_rec.offering_id , p_rec.activity_version_id);

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

442: ,p_hook_type => 'AU');
443: --
444: end;
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 10);
447: End post_update;
448: --
449: -- ----------------------------------------------------------------------------
450: -- |-----------------------------< convert_defs >-----------------------------|

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

702: --
703: l_proc varchar2(72) := g_package||'upd';
704: --
705: Begin
706: hr_utility.set_location('Entering:'||l_proc, 5);
707: --
708: -- We must lock the row which we need to update.
709: --
710: ota_off_shd.lck

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

807: l_rec ota_off_shd.g_rec_type;
808: l_proc varchar2(72) := g_package||'upd';
809: --
810: Begin
811: hr_utility.set_location('Entering:'||l_proc, 5);
812: --
813: -- Call conversion function to turn arguments into the
814: -- l_rec structure.
815: --

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

877: ,p_name
878: );
879: p_object_version_number := l_rec.object_version_number;
880: --
881: hr_utility.set_location(' Leaving:'||l_proc, 10);
882: End upd;
883: --
884: Procedure update_evt_when_course_change
885: (

Line 904: hr_utility.set_location('Entering:'|| v_proc, 5);

900: where evt.parent_offering_id = p_offering_id ;
901: --
902: Begin
903: --
904: hr_utility.set_location('Entering:'|| v_proc, 5);
905: --
906: /*open sel_evt;
907: fetch sel_evt BULK COLLECT into v_event_tab;*/
908:

Line 924: hr_utility.set_location(' Leaving:'|| v_proc, 10);

920: end loop;
921: --
922: --close sel_evt;
923: --
924: hr_utility.set_location(' Leaving:'|| v_proc, 10);
925: --
926: End update_evt_when_course_change;
927: end ota_off_upd;