eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RST_DEL dependencies on PQH_RST_SHD

Line 45: Procedure delete_dml(p_rec in pqh_rst_shd.g_rec_type) is

41: -- Internal Row Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in pqh_rst_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 79: pqh_rst_shd.constraint_error

75: --
76: Exception
77: When hr_api.child_integrity_violated then
78: -- Child integrity has been violated
79: pqh_rst_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When Others Then
82: Raise;
83: End delete_dml;

Line 117: Procedure pre_delete(p_rec in pqh_rst_shd.g_rec_type) is

113: -- Internal Row Handler Use Only.
114: --
115: -- {End Of Comments}
116: -- ----------------------------------------------------------------------------
117: Procedure pre_delete(p_rec in pqh_rst_shd.g_rec_type) is
118: --
119: l_proc varchar2(72) := g_package||'pre_delete';
120: --
121: Begin

Line 160: p_effective_date in date,p_rec in pqh_rst_shd.g_rec_type) is

156: --
157: -- {End Of Comments}
158: -- ----------------------------------------------------------------------------
159: Procedure post_delete(
160: p_effective_date in date,p_rec in pqh_rst_shd.g_rec_type) is
161: --
162: l_proc varchar2(72) := g_package||'post_delete';
163: --
164: Begin

Line 175: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id

171: --
172: pqh_rst_rkd.after_delete
173: (
174: p_rule_set_id =>p_rec.rule_set_id
175: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id
176: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
177: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
178: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
179: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id

Line 176: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name

172: pqh_rst_rkd.after_delete
173: (
174: p_rule_set_id =>p_rec.rule_set_id
175: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id
176: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
177: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
178: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
179: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
180: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd

Line 177: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id

173: (
174: p_rule_set_id =>p_rec.rule_set_id
175: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id
176: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
177: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
178: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
179: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
180: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
181: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number

Line 178: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id

174: p_rule_set_id =>p_rec.rule_set_id
175: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id
176: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
177: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
178: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
179: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
180: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
181: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
182: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name

Line 179: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id

175: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id
176: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
177: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
178: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
179: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
180: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
181: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
182: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
183: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability

Line 180: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd

176: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
177: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
178: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
179: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
180: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
181: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
182: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
183: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
184: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category

Line 181: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number

177: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
178: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
179: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
180: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
181: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
182: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
183: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
184: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
185: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id

Line 182: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name

178: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
179: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
180: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
181: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
182: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
183: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
184: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
185: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
186: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag

Line 183: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability

179: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
180: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
181: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
182: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
183: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
184: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
185: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
186: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag
187: ,p_status_o =>pqh_rst_shd.g_old_rec.status

Line 184: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category

180: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
181: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
182: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
183: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
184: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
185: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
186: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag
187: ,p_status_o =>pqh_rst_shd.g_old_rec.status
188: );

Line 185: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id

181: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
182: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
183: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
184: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
185: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
186: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag
187: ,p_status_o =>pqh_rst_shd.g_old_rec.status
188: );
189: --

Line 186: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag

182: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
183: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
184: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
185: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
186: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag
187: ,p_status_o =>pqh_rst_shd.g_old_rec.status
188: );
189: --
190: exception

Line 187: ,p_status_o =>pqh_rst_shd.g_old_rec.status

183: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
184: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
185: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
186: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag
187: ,p_status_o =>pqh_rst_shd.g_old_rec.status
188: );
189: --
190: exception
191: --

Line 212: p_rec in pqh_rst_shd.g_rec_type

208: -- ----------------------------------------------------------------------------
209: Procedure del
210: (
211: p_effective_date in date,
212: p_rec in pqh_rst_shd.g_rec_type
213: ) is
214: --
215: l_proc varchar2(72) := g_package||'del';
216: --

Line 222: pqh_rst_shd.lck

218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: -- We must lock the row which we need to delete.
221: --
222: pqh_rst_shd.lck
223: (
224: p_rec.rule_set_id,
225: p_rec.object_version_number
226: );

Line 257: l_rec pqh_rst_shd.g_rec_type;

253: p_rule_set_id in number,
254: p_object_version_number in number
255: ) is
256: --
257: l_rec pqh_rst_shd.g_rec_type;
258: l_proc varchar2(72) := g_package||'del';
259: --
260: Begin
261: hr_utility.set_location('Entering:'||l_proc, 5);