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 64: pqh_rst_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_rst_shd.constraint_error
65: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66: When Others Then
67: Raise;
68: End delete_dml;

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

98: -- Internal Row Handler Use Only.
99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure pre_delete(p_rec in pqh_rst_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: Begin

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

141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure post_delete(
145: p_effective_date in date,p_rec in pqh_rst_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'post_delete';
148: --
149: Begin

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

156: --
157: pqh_rst_rkd.after_delete
158: (
159: p_rule_set_id =>p_rec.rule_set_id
160: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id
161: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
162: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
163: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
164: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id

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

157: pqh_rst_rkd.after_delete
158: (
159: p_rule_set_id =>p_rec.rule_set_id
160: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id
161: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
162: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
163: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
164: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
165: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd

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

158: (
159: p_rule_set_id =>p_rec.rule_set_id
160: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id
161: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
162: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
163: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
164: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
165: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
166: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number

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

159: p_rule_set_id =>p_rec.rule_set_id
160: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id
161: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
162: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
163: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
164: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
165: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
166: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
167: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name

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

160: ,p_business_group_id_o =>pqh_rst_shd.g_old_rec.business_group_id
161: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
162: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
163: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
164: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
165: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
166: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
167: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
168: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability

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

161: ,p_rule_set_name_o =>pqh_rst_shd.g_old_rec.rule_set_name
162: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
163: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
164: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
165: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
166: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
167: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
168: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
169: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category

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

162: ,p_organization_structure_id_o =>pqh_rst_shd.g_old_rec.organization_structure_id
163: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
164: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
165: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
166: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
167: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
168: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
169: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
170: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id

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

163: ,p_organization_id_o =>pqh_rst_shd.g_old_rec.organization_id
164: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
165: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
166: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
167: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
168: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
169: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
170: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
171: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag

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

164: ,p_referenced_rule_set_id_o =>pqh_rst_shd.g_old_rec.referenced_rule_set_id
165: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
166: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
167: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
168: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
169: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
170: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
171: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag
172: ,p_status_o =>pqh_rst_shd.g_old_rec.status

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

165: ,p_rule_level_cd_o =>pqh_rst_shd.g_old_rec.rule_level_cd
166: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
167: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
168: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
169: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
170: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
171: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag
172: ,p_status_o =>pqh_rst_shd.g_old_rec.status
173: );

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

166: ,p_object_version_number_o =>pqh_rst_shd.g_old_rec.object_version_number
167: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
168: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
169: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
170: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
171: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag
172: ,p_status_o =>pqh_rst_shd.g_old_rec.status
173: );
174: --

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

167: ,p_short_name_o =>pqh_rst_shd.g_old_rec.short_name
168: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
169: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
170: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
171: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag
172: ,p_status_o =>pqh_rst_shd.g_old_rec.status
173: );
174: --
175: exception

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

168: ,p_rule_applicability_o =>pqh_rst_shd.g_old_rec.rule_applicability
169: ,p_rule_category_o =>pqh_rst_shd.g_old_rec.rule_category
170: ,p_starting_organization_id_o =>pqh_rst_shd.g_old_rec.starting_organization_id
171: ,p_seeded_rule_flag_o =>pqh_rst_shd.g_old_rec.seeded_rule_flag
172: ,p_status_o =>pqh_rst_shd.g_old_rec.status
173: );
174: --
175: exception
176: --

Line 197: p_rec in pqh_rst_shd.g_rec_type

193: -- ----------------------------------------------------------------------------
194: Procedure del
195: (
196: p_effective_date in date,
197: p_rec in pqh_rst_shd.g_rec_type
198: ) is
199: --
200: l_proc varchar2(72) := g_package||'del';
201: --

Line 207: pqh_rst_shd.lck

203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: -- We must lock the row which we need to delete.
206: --
207: pqh_rst_shd.lck
208: (
209: p_rec.rule_set_id,
210: p_rec.object_version_number
211: );

Line 242: l_rec pqh_rst_shd.g_rec_type;

238: p_rule_set_id in number,
239: p_object_version_number in number
240: ) is
241: --
242: l_rec pqh_rst_shd.g_rec_type;
243: l_proc varchar2(72) := g_package||'del';
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);