APPS.PQH_RST_INS dependencies on PQH_RULE_SETS

Line 60: p_entity_name=>'PQH_RULE_SETS',

56: -- Added the following code as a part of Zero Downtime Patching Project.
57: -- Code Starts Here.
58: --
59: PER_RIC_PKG.chk_integrity (
60: p_entity_name=>'PQH_RULE_SETS',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),

Line 74: -- Insert the row into: pqh_rule_sets

70: --
71: -- Code Ends Here
72: --
73: --
74: -- Insert the row into: pqh_rule_sets
75: --
76: insert into pqh_rule_sets
77: ( business_group_id,
78: rule_set_id,

Line 76: insert into pqh_rule_sets

72: --
73: --
74: -- Insert the row into: pqh_rule_sets
75: --
76: insert into pqh_rule_sets
77: ( business_group_id,
78: rule_set_id,
79: rule_set_name,
80: organization_structure_id,

Line 170: Cursor C_Sel1 is select pqh_rule_sets_s.nextval from sys.dual;

166: --
167: l_proc varchar2(72) := g_package||'pre_insert';
168: --
169: --
170: Cursor C_Sel1 is select pqh_rule_sets_s.nextval from sys.dual;
171: --
172: --
173: Begin
174: hr_utility.set_location('Entering:'||l_proc, 5);

Line 252: (p_module_name => 'pqh_rule_sets'

248: --
249: when hr_api.cannot_find_prog_unit then
250: --
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'pqh_rule_sets'
253: ,p_hook_type => 'AI');
254: --
255: end;
256: --