APPS.PQH_SAT_INS dependencies on PQH_SPECIAL_ATTRIBUTES

Line 63: p_entity_name=>'PQH_SPECIAL_ATTRIBUTES',

59: -- Added the following code as a part of Zero Downtime Patching Project.
60: -- Code Starts Here.
61: --
62: PER_RIC_PKG.chk_integrity (
63: p_entity_name=>'PQH_SPECIAL_ATTRIBUTES',
64: p_ref_entity_info=>
65: PER_RIC_PKG.ref_entity_tbl(
66: PER_RIC_PKG.ref_info_rec('PQH_TXN_CATEGORY_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
67: PER_RIC_PKG.col_info_rec('TXN_CATEGORY_ATTRIBUTE_ID',NULL,p_rec.txn_category_attribute_id, NULL))),

Line 74: -- Insert the row into: pqh_special_attributes

70: p_ref_type=>'INS');
71: --
72: -- Code Ends Here
73: --
74: -- Insert the row into: pqh_special_attributes
75: --
76: insert into pqh_special_attributes
77: ( special_attribute_id,
78: txn_category_attribute_id,

Line 76: insert into pqh_special_attributes

72: -- Code Ends Here
73: --
74: -- Insert the row into: pqh_special_attributes
75: --
76: insert into pqh_special_attributes
77: ( special_attribute_id,
78: txn_category_attribute_id,
79: attribute_type_cd,
80: key_attribute_type,

Line 161: Cursor C_Sel1 is select pqh_special_attributes_s.nextval from sys.dual;

157: Procedure pre_insert(p_rec in out nocopy pqh_sat_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'pre_insert';
160: --
161: Cursor C_Sel1 is select pqh_special_attributes_s.nextval from sys.dual;
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --

Line 241: (p_module_name => 'pqh_special_attributes'

237: --
238: when hr_api.cannot_find_prog_unit then
239: --
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'pqh_special_attributes'
242: ,p_hook_type => 'AI');
243: --
244: end;
245: --