58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: --
62: -- Delete the per_cagr_entitlement_items_tl row.
63: --
64: delete from per_cagr_entitlement_items_tl
65: where cagr_entitlement_item_id = p_rec.cagr_entitlement_item_id
66: and language = p_rec.language;
60: --
61: --
62: -- Delete the per_cagr_entitlement_items_tl row.
63: --
64: delete from per_cagr_entitlement_items_tl
65: where cagr_entitlement_item_id = p_rec.cagr_entitlement_item_id
66: and language = p_rec.language;
67: --
68: --
177: --
178: when hr_api.cannot_find_prog_unit then
179: --
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'PER_CAGR_ENTITLEMENT_ITEMS_TL'
182: ,p_hook_type => 'AD');
183: --
184: end;
185: --
265: -- Cursor to obtain all the translation rows.
266: --
267: cursor csr_del_langs is
268: select cit.language
269: from per_cagr_entitlement_items_tl cit
270: where cit.cagr_entitlement_item_id = p_cagr_entitlement_item_id;
271: --
272: l_proc varchar2(72) := g_package||'del_tl';
273: --