DBA Data[Home] [Help]

APPS.PQH_CTL_DEL dependencies on PQH_TRANSACTION_CATEGORIES_TL

Line 53: -- Delete the pqh_transaction_categories_tl row.

49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: --
53: -- Delete the pqh_transaction_categories_tl row.
54: --
55: delete from pqh_transaction_categories_tl
56: where transaction_category_id = p_rec.transaction_category_id
57: and language = p_rec.language;

Line 55: delete from pqh_transaction_categories_tl

51: --
52: --
53: -- Delete the pqh_transaction_categories_tl row.
54: --
55: delete from pqh_transaction_categories_tl
56: where transaction_category_id = p_rec.transaction_category_id
57: and language = p_rec.language;
58: --
59: --

Line 170: (p_module_name => 'pqh_transaction_categories_tl'

166: --
167: when hr_api.cannot_find_prog_unit then
168: --
169: hr_api.cannot_find_prog_unit_error
170: (p_module_name => 'pqh_transaction_categories_tl'
171: ,p_hook_type => 'AD');
172: --
173: end;
174: --

Line 262: from pqh_transaction_categories_tl ctl

258: ) is
259: --
260: cursor csr_del_langs is
261: Select ctl.language
262: from pqh_transaction_categories_tl ctl
263: where ctl.transaction_category_id = p_transaction_category_id;
264: --
265: l_proc varchar2(72) := g_package||'del_tl';
266: --