DBA Data[Home] [Help]

APPS.PER_STT_UPD dependencies on PER_SHARED_TYPES_TL

Line 59: -- Update the per_shared_types_tl Row

55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: --
59: -- Update the per_shared_types_tl Row
60: --
61: update per_shared_types_tl
62: set
63: shared_type_id = p_rec.shared_type_id,

Line 61: update per_shared_types_tl

57: --
58: --
59: -- Update the per_shared_types_tl Row
60: --
61: update per_shared_types_tl
62: set
63: shared_type_id = p_rec.shared_type_id,
64: language = p_rec.language,
65: source_lang = p_rec.source_lang,

Line 192: (p_module_name => 'per_shared_types_tl'

188: --
189: when hr_api.cannot_find_prog_unit then
190: --
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'per_shared_types_tl'
193: ,p_hook_type => 'AU');
194: --
195: end;
196: --

Line 361: from per_shared_types_tl stt

357: p_shared_type_name in varchar2 default hr_api.g_varchar2 )
358: is
359: cursor csr_upd_langs is
360: select stt.language
361: from per_shared_types_tl stt
362: where stt.shared_type_id = p_shared_type_id
363: and p_language_code in (stt.language,stt.source_lang) ;
364:
365: l_proc varchar2(72) := g_package||'upd_tl';

Line 382: update per_shared_types_tl

378: procedure translate_row (
379: p_shared_type_id in number,
380: p_shared_type_name in varchar2) is
381: begin
382: update per_shared_types_tl
383: set shared_type_name = p_shared_type_name
384: ,source_lang = USERENV('LANG')
385: where USERENV('LANG') in (language,source_lang)
386: and shared_type_id = p_shared_type_id ;