DBA Data[Home] [Help]

APPS.OTA_CTT_UPD dependencies on OTA_CATEGORY_USAGES_TL

Line 66: -- Update the ota_category_usages_tl Row

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

Line 68: update ota_category_usages_tl

64: --
65: --
66: -- Update the ota_category_usages_tl Row
67: --
68: update ota_category_usages_tl
69: set
70: category_usage_id = p_rec.category_usage_id
71: ,language = p_rec.language
72: ,source_lang = p_rec.source_lang

Line 215: (p_module_name => 'OTA_CATEGORY_USAGES_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_CATEGORY_USAGES_TL'
216: ,p_hook_type => 'AU');
217: --
218: end;
219: --

Line 405: from ota_category_usages_tl ctt

401: -- source_lang match the specified language.
402: --
403: cursor csr_upd_langs is
404: select ctt.language
405: from ota_category_usages_tl ctt
406: where ctt.category_usage_id = p_category_usage_id
407: and p_language_code in (ctt.language
408: ,ctt.source_lang);
409: --