49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: --
53: -- Delete the pqh_attributes_tl row.
54: --
55: delete from pqh_attributes_tl
56: where attribute_id = p_rec.attribute_id
57: and language = p_rec.language;
51: --
52: --
53: -- Delete the pqh_attributes_tl row.
54: --
55: delete from pqh_attributes_tl
56: where attribute_id = p_rec.attribute_id
57: and language = p_rec.language;
58: --
59: --
166: --
167: when hr_api.cannot_find_prog_unit then
168: --
169: hr_api.cannot_find_prog_unit_error
170: (p_module_name => 'pqh_attributes_tl'
171: ,p_hook_type => 'AD');
172: --
173: end;
174: --
257: ) is
258: --
259: cursor csr_del_langs is
260: Select atl.language
261: from pqh_attributes_tl atl
262: where atl.attribute_id = p_attribute_id;
263: --
264: l_proc varchar2(72) := g_package||'del_tl';
265: --