61: --
62: --
63: --
64: --
65: -- Insert the row into: ota_lp_sections_tl
66: --
67: insert into ota_lp_sections_tl
68: (learning_path_section_id
69: ,language
63: --
64: --
65: -- Insert the row into: ota_lp_sections_tl
66: --
67: insert into ota_lp_sections_tl
68: (learning_path_section_id
69: ,language
70: ,name
71: ,description
216: --
217: when hr_api.cannot_find_prog_unit then
218: --
219: hr_api.cannot_find_prog_unit_error
220: (p_module_name => 'OTA_LP_SECTIONS_TL'
221: ,p_hook_type => 'AI');
222: --
223: end;
224: --
339: select l.language_code
340: from fnd_languages l
341: where l.installed_flag in ('I','B')
342: and not exists (select null
343: from ota_lp_sections_tl lst
344: where lst.learning_path_section_id = p_learning_path_section_id
345: and lst.language = l.language_code);
346: --
347: l_proc varchar2(72) := g_package || 'ins_tl';