APPS.PER_STT_INS dependencies on PER_SHARED_TYPES_TL

Line 61: p_entity_name=>'PER_SHARED_TYPES_TL',

57: -- Added the following code as a part of Zero Downtime Patching Project.
58: -- Code Starts Here.
59: --
60: per_ric_pkg.Chk_integrity(
61: p_entity_name=>'PER_SHARED_TYPES_TL',
62: p_ref_entity=>'PER_SHARED_TYPES',
63: p_ref_column_name=>'SHARED_TYPE_ID',
64: p_ref_col_value_number=>p_rec.shared_type_id,
65: p_ref_col_value_varchar=>NULL,

Line 72: -- Insert the row into: per_shared_types_tl

68: --
69: -- Code Ends Here
70: --
71: --
72: -- Insert the row into: per_shared_types_tl
73: --
74: insert into per_shared_types_tl
75: ( shared_type_id,
76: language,

Line 74: insert into per_shared_types_tl

70: --
71: --
72: -- Insert the row into: per_shared_types_tl
73: --
74: insert into per_shared_types_tl
75: ( shared_type_id,
76: language,
77: source_lang,
78: shared_type_name

Line 212: (p_module_name => 'per_shared_types_tl'

208: --
209: when hr_api.cannot_find_prog_unit then
210: --
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'per_shared_types_tl'
213: ,p_hook_type => 'AI');
214: --
215: end;
216: --

Line 303: from per_shared_types_tl stt

299: select l.language_code
300: from fnd_languages l
301: where l.installed_flag in ('I','B')
302: and not exists ( select null
303: from per_shared_types_tl stt
304: where stt.shared_type_id = p_shared_type_id
305: and stt.language = l.language_code );
306: l_proc varchar2(72) := g_package||'ins_tl';
307: begin