DBA Data[Home] [Help]

APPS.HR_ORT_INS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 86: -- Insert the row into: hr_all_organization_units_tl

82: --
83: --
84: --
85: --
86: -- Insert the row into: hr_all_organization_units_tl
87: --
88: insert into hr_all_organization_units_tl
89: (organization_id
90: ,language

Line 88: insert into hr_all_organization_units_tl

84: --
85: --
86: -- Insert the row into: hr_all_organization_units_tl
87: --
88: insert into hr_all_organization_units_tl
89: (organization_id
90: ,language
91: ,source_lang
92: ,name

Line 235: (p_module_name => 'HR_ALL_ORGANIZATION_UNITS_TL'

231: --
232: when hr_api.cannot_find_prog_unit then
233: --
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'HR_ALL_ORGANIZATION_UNITS_TL'
236: ,p_hook_type => 'AI');
237: --
238: end;
239: --

Line 341: from hr_all_organization_units_tl ort

337: select l.language_code
338: from fnd_languages l
339: where l.installed_flag in ('I','B')
340: and not exists (select null
341: from hr_all_organization_units_tl ort
342: where ort.organization_id = p_organization_id
343: and ort.language = l.language_code);
344: --
345: l_proc varchar2(72) := g_package || 'ins_tl';