59: l_proc varchar2(72) := g_package||'update_dml';
60: l_recruiting_site_response clob;
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: --
126: if (g_recruiting_site_response
127: and dbms_lob.getlength(l_recruiting_site_response)<=32767
128: and dbms_lob.instr(l_recruiting_site_response,p_rec.recruiting_site_response)<>1)
129: then
130: hr_utility.set_location(l_proc, 10);
131: dbms_lob.trim(l_recruiting_site_response,0);
132: dbms_lob.write(l_recruiting_site_response
133: ,length(p_rec.recruiting_site_response)
134: ,1
135: ,p_rec.recruiting_site_response);
136: end if;
137: --
138: --
139: hr_utility.set_location(' Leaving:'||l_proc, 10);
140: --
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
197: --
198: l_proc varchar2(72) := g_package||'pre_update';
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: hr_utility.set_location(' Leaving:'||l_proc, 10);
204: End pre_update;
205: --
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: hr_utility.set_location(' Leaving:'||l_proc, 10);
204: End pre_update;
205: --
206: -- ----------------------------------------------------------------------------
207: -- |-----------------------------< post_update >------------------------------|
241: --
242: l_proc varchar2(72) := g_package||'post_update';
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: begin
247: --
248: per_raa_rku.after_update
249: (p_recruitment_activity_id
447: ,p_hook_type => 'AU');
448: --
449: end;
450: --
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: End post_update;
453: --
454: -- ----------------------------------------------------------------------------
455: -- |-----------------------------< convert_defs >-----------------------------|
703: --
704: l_proc varchar2(72) := g_package||'upd';
705: --
706: Begin
707: hr_utility.set_location('Entering:'||l_proc, 5);
708: --
709: -- We must lock the row which we need to update.
710: --
711: per_raa_shd.lck
802: l_rec per_raa_shd.g_rec_type;
803: l_proc varchar2(72) := g_package||'upd';
804: --
805: Begin
806: hr_utility.set_location('Entering:'||l_proc, 5);
807: --
808: -- Call conversion function to turn arguments into the
809: -- l_rec structure.
810: --
868: (l_rec
869: );
870: p_object_version_number := l_rec.object_version_number;
871: --
872: hr_utility.set_location(' Leaving:'||l_proc, 10);
873: End upd;
874: --
875: end per_raa_upd;