APPS.PQH_TCA_DEL dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 57: p_entity_name=> 'PQH_TXN_CATEGORY_ATTRIBUTES',

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_TXN_CATEGORY_ATTRIBUTES',
58: p_ref_entity=>'PQH_SPECIAL_ATTRIBUTES',
59: p_ref_column_name=>'TXN_CATEGORY_ATTRIBUTE_ID',
60: p_ref_col_value_number=>p_rec.txn_category_attribute_id,
61: p_ref_col_value_varchar=>NULL,

Line 67: -- Delete the pqh_txn_category_attributes row.

63: p_ref_type=>'DEL');
64: --
65: -- Code Ends Here
66: --
67: -- Delete the pqh_txn_category_attributes row.
68: --
69: delete from pqh_txn_category_attributes
70: where txn_category_attribute_id = p_rec.txn_category_attribute_id;
71: --

Line 69: delete from pqh_txn_category_attributes

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

Line 193: (p_module_name => 'pqh_txn_category_attributes'

189: --
190: when hr_api.cannot_find_prog_unit then
191: --
192: hr_api.cannot_find_prog_unit_error
193: (p_module_name => 'pqh_txn_category_attributes'
194: ,p_hook_type => 'AD');
195: --
196: end;
197: --