DBA Data[Home] [Help]

APPS.OTA_BSL_INS dependencies on OTA_BOOKING_STATUS_TYPES_TL

Line 65: -- Insert the row into: ota_booking_status_types_tl

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

Line 67: insert into ota_booking_status_types_tl

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

Line 220: (p_module_name => 'OTA_BOOKING_STATUS_TYPES_TL'

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

Line 342: from ota_booking_status_types_tl bst

338: select l.language_code
339: from fnd_languages l
340: where l.installed_flag in ('I','B')
341: and not exists (select null
342: from ota_booking_status_types_tl bst
343: where bst.booking_status_type_id = p_booking_status_type_id
344: and bst.language = l.language_code);
345: --
346: l_proc varchar2(72) := g_package || 'ins_tl';