DBA Data[Home] [Help]

APPS.PQH_TCT_DEL dependencies on PQH_TRANSACTION_CATEGORIES

Line 57: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',

53: -- Added the following code as a part of Zero Downtime Patching Project.
54: -- Code Starts Here.
55: --
56: PER_RIC_PKG.chk_integrity (
57: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL, p_rec.transaction_category_id,NULL))),

Line 69: -- Delete the pqh_transaction_categories row.

65: --
66: --
67: -- Code Ends Here
68: --
69: -- Delete the pqh_transaction_categories row.
70: --
71: delete from pqh_transaction_categories
72: where transaction_category_id = p_rec.transaction_category_id;
73: --

Line 71: delete from pqh_transaction_categories

67: -- Code Ends Here
68: --
69: -- Delete the pqh_transaction_categories row.
70: --
71: delete from pqh_transaction_categories
72: where transaction_category_id = p_rec.transaction_category_id;
73: --
74: --
75: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 203: (p_module_name => 'pqh_transaction_categories'

199: --
200: when hr_api.cannot_find_prog_unit then
201: --
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'pqh_transaction_categories'
204: ,p_hook_type => 'AD');
205: --
206: end;
207: --