DBA Data[Home] [Help]

APPS.OTA_ONT_INS dependencies on OTA_OFFERINGS_TL

Line 65: -- Insert the row into: ota_offerings_tl

61: --
62: --
63: --
64: --
65: -- Insert the row into: ota_offerings_tl
66: --
67: insert into ota_offerings_tl
68: (offering_id
69: ,language

Line 67: insert into ota_offerings_tl

63: --
64: --
65: -- Insert the row into: ota_offerings_tl
66: --
67: insert into ota_offerings_tl
68: (offering_id
69: ,language
70: ,name
71: ,description

Line 221: (p_module_name => 'OTA_OFFERINGS_TL'

217: --
218: when hr_api.cannot_find_prog_unit then
219: --
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'OTA_OFFERINGS_TL'
222: ,p_hook_type => 'AI');
223: --
224: end;
225: --

Line 343: from ota_offerings_tl ont

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_offerings_tl ont
344: where ont.offering_id = p_offering_id
345: and ont.language = l.language_code);
346: --
347: l_proc varchar2(72) := g_package || 'ins_tl';