DBA Data[Home] [Help]

APPS.OTA_SRT_UPD dependencies on OTA_SUPPLIABLE_RESOURCES

Line 66: -- Update the ota_suppliable_resources_tl Row

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

Line 68: update ota_suppliable_resources_tl

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

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

Line 405: from ota_suppliable_resources_tl srt

401: -- source_lang match the specified language.
402: --
403: cursor csr_upd_langs is
404: select srt.language
405: from ota_suppliable_resources_tl srt
406: where srt.supplied_resource_id = p_supplied_resource_id
407: and p_language_code in (srt.language
408: ,srt.source_lang);
409: --

Line 451: , ota_suppliable_resources rs

447: , l.nls_language
448: , rd.id_flex_num
449: , rd.resource_definition_id
450: from fnd_languages l
451: , ota_suppliable_resources rs
452: , ota_resource_definitions rd
453: where rs.supplied_resource_id = p_supplied_resource_id
454: and rd.resource_definition_id = rs.resource_definition_id
455: and l.installed_flag IN ('B', 'I');