[Home] [Help]
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: --
64: --
65: --
75: and language = p_rec.language;
76: --
77: --
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
146: -- ----------------------------------------------------------------------------
147: -- |-----------------------------< post_update >------------------------------|
181: --
182: l_proc varchar2(72) := g_package||'post_update';
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: begin
187: --
188: per_jbt_rku.after_update
189: (p_job_id
209: ,p_hook_type => 'AU');
210: --
211: end;
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: End post_update;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |-----------------------------< convert_defs >-----------------------------|
287: --
288: l_proc varchar2(72) := g_package||'upd';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- We must lock the row which we need to update.
294: --
295: per_jbt_shd.lck
342: l_rec per_jbt_shd.g_rec_type;
343: l_proc varchar2(72) := g_package||'upd';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Call conversion function to turn arguments into the
349: -- l_rec structure.
350: --
364: (l_rec
365: );
366: --
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 10);
369: End upd;
370: --
371: -- ----------------------------------------------------------------------------
372: -- |------------------------------< upd_tl >----------------------------------|
379: --
380: l_proc varchar2(72) := g_package||'upd_tl';
381: --
382: Begin
383: hr_utility.set_location('Entering:'||l_proc,10);
384: --
385: -- Update the translated values for every matching row
386: --
387: upd_key_flex_meanings( p_job_id );
385: -- Update the translated values for every matching row
386: --
387: upd_key_flex_meanings( p_job_id );
388: --
389: hr_utility.set_location(' Leaving:'||l_proc,20);
390: End upd_tl;
391: --
392: -- ----------------------------------------------------------------------------
393: -- |------------------------------< upd_key_flex_meanings >-------------------|
420: l_proc varchar2(72) := g_package||'upd_key_flex_meanings';
421: --
422: Begin
423: --
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: For l_language IN c_languages Loop
427: --
428: -- Lock the existing record (which may already be updated)
456: -- Set the session language
457: --
458: hr_kflex_utility.set_session_language_code( l_userenv_language_code );
459: --
460: hr_utility.set_location(' Leaving:'||l_proc,20);
461: --
462: Exception
463: --
464: When Others Then