DBA Data[Home] [Help]

APPS.OTA_LST_UPD dependencies on OTA_LP_SECTIONS_TL

Line 66: -- Update the ota_lp_sections_tl Row

62: --
63: --
64: --
65: --
66: -- Update the ota_lp_sections_tl Row
67: --
68: update ota_lp_sections_tl
69: set
70: learning_path_section_id = p_rec.learning_path_section_id

Line 68: update ota_lp_sections_tl

64: --
65: --
66: -- Update the ota_lp_sections_tl Row
67: --
68: update ota_lp_sections_tl
69: set
70: learning_path_section_id = p_rec.learning_path_section_id
71: ,language = p_rec.language
72: ,name = p_rec.name

Line 215: (p_module_name => 'OTA_LP_SECTIONS_TL'

211: --
212: when hr_api.cannot_find_prog_unit then
213: --
214: hr_api.cannot_find_prog_unit_error
215: (p_module_name => 'OTA_LP_SECTIONS_TL'
216: ,p_hook_type => 'AU');
217: --
218: end;
219: --

Line 405: from ota_lp_sections_tl lst

401: -- source_lang match the specified language.
402: --
403: cursor csr_upd_langs is
404: select lst.language
405: from ota_lp_sections_tl lst
406: where lst.learning_path_section_id = p_learning_path_section_id
407: and p_language_code in (lst.language
408: ,lst.source_lang);
409: --