APPS.OTA_BSL_DEL dependencies on OTA_BOOKING_STATUS_TYPES_TL

Line 62: -- Delete the ota_booking_status_types_tl row.

58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: --
62: -- Delete the ota_booking_status_types_tl row.
63: --
64: delete from ota_booking_status_types_tl
65: where booking_status_type_id = p_rec.booking_status_type_id
66: and language = p_rec.language;

Line 64: delete from ota_booking_status_types_tl

60: --
61: --
62: -- Delete the ota_booking_status_types_tl row.
63: --
64: delete from ota_booking_status_types_tl
65: where booking_status_type_id = p_rec.booking_status_type_id
66: and language = p_rec.language;
67: --
68: --

Line 183: (p_module_name => 'OTA_BOOKING_STATUS_TYPES_TL'

179: --
180: when hr_api.cannot_find_prog_unit then
181: --
182: hr_api.cannot_find_prog_unit_error
183: (p_module_name => 'OTA_BOOKING_STATUS_TYPES_TL'
184: ,p_hook_type => 'AD');
185: --
186: end;
187: --

Line 278: from ota_booking_status_types_tl bst

274: -- Cursor to obtain all the translation rows.
275: --
276: cursor csr_del_langs is
277: select bst.language
278: from ota_booking_status_types_tl bst
279: where bst.booking_status_type_id = p_booking_status_type_id;
280: --
281: l_proc varchar2(72) := g_package||'del_tl';
282: --