APPS.PER_STT_UPD dependencies on HR_UTILITY

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

52: --
53: l_proc varchar2(72) := g_package||'update_dml';
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: --
59: -- Update the per_shared_types_tl Row
60: --

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

67: where shared_type_id = p_rec.shared_type_id
68: and language = p_rec.language;
69: --
70: --
71: hr_utility.set_location(' Leaving:'||l_proc, 10);
72: --
73: Exception
74: When hr_api.check_integrity_violated Then
75: -- A check constraint has been violated

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

123: --
124: l_proc varchar2(72) := g_package||'pre_update';
125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: End pre_update;
131: --

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

125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: End pre_update;
131: --
132: -- ----------------------------------------------------------------------------
133: -- |-----------------------------< post_update >------------------------------|

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

165: --
166: l_proc varchar2(72) := g_package||'post_update';
167: --
168: Begin
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: --
172: -- Start of API User Hook for post_update.
173: --

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

196: --
197: -- End of API User Hook for post_update.
198: --
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: End post_update;
202: --
203: -- ----------------------------------------------------------------------------
204: -- |-----------------------------< convert_defs >-----------------------------|

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

248: l_proc varchar2(72) := g_package||'convert_defs';
249: --
250: Begin
251: --
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- We must now examine each argument value in the
255: -- p_rec plsql record structure
256: -- to see if a system default is being used. If a system default

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

264: p_rec.shared_type_name :=
265: per_stt_shd.g_old_rec.shared_type_name;
266: End If;
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 10);
269: --
270: End convert_defs;
271: --
272: -- ----------------------------------------------------------------------------

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

279: --
280: l_proc varchar2(72) := g_package||'upd';
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --
285: -- We must lock the row which we need to update.
286: --
287: per_stt_shd.lck

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

326: l_rec per_stt_shd.g_rec_type;
327: l_proc varchar2(72) := g_package||'upd';
328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: -- Call conversion function to turn arguments into the
333: -- l_rec structure.
334: --

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

347: --
348: upd(l_rec);
349: --
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 10);
352: End upd;
353: --
354: procedure upd_tl (
355: p_language_code in varchar2,

Line 367: hr_utility.set_location(' Entering:'||l_proc, 10);

363: and p_language_code in (stt.language,stt.source_lang) ;
364:
365: l_proc varchar2(72) := g_package||'upd_tl';
366: begin
367: hr_utility.set_location(' Entering:'||l_proc, 10);
368: for l_lang in csr_upd_langs loop
369: upd(
370: p_shared_type_id => p_shared_type_id ,
371: p_language => l_lang.language,

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

371: p_language => l_lang.language,
372: p_source_lang => p_language_code,
373: p_shared_type_name => p_shared_type_name );
374: end loop;
375: hr_utility.set_location(' Leaving:'||l_proc, 20);
376: end upd_tl ;
377: --
378: procedure translate_row (
379: p_shared_type_id in number,