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_RNG_DEL dependencies on PQH_RNG_SHD

Line 45: Procedure delete_dml(p_rec in pqh_rng_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_rng_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 64: pqh_rng_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_rng_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_rng_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_rng_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_rng_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_rng_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'post_delete';
148: --
149: Begin

Line 160: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag

156: --
157: pqh_rng_rkd.after_delete
158: (
159: p_attribute_range_id =>p_rec.attribute_range_id
160: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag
161: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
162: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
163: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
164: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id

Line 161: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag

157: pqh_rng_rkd.after_delete
158: (
159: p_attribute_range_id =>p_rec.attribute_range_id
160: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag
161: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
162: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
163: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
164: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
165: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char

Line 162: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag

158: (
159: p_attribute_range_id =>p_rec.attribute_range_id
160: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag
161: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
162: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
163: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
164: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
165: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
166: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date

Line 163: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id

159: p_attribute_range_id =>p_rec.attribute_range_id
160: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag
161: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
162: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
163: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
164: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
165: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
166: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
167: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number

Line 164: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id

160: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag
161: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
162: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
163: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
164: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
165: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
166: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
167: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
168: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id

Line 165: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char

161: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
162: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
163: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
164: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
165: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
166: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
167: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
168: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
169: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name

Line 166: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date

162: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
163: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
164: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
165: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
166: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
167: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
168: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
169: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
170: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id

Line 167: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number

163: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
164: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
165: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
166: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
167: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
168: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
169: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
170: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
171: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id

Line 168: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id

164: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
165: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
166: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
167: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
168: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
169: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
170: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
171: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
172: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char

Line 169: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name

165: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
166: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
167: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
168: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
169: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
170: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
171: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
172: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
173: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date

Line 170: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id

166: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
167: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
168: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
169: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
170: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
171: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
172: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
173: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
174: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number

Line 171: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id

167: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
168: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
169: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
170: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
171: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
172: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
173: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
174: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number
175: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number

Line 172: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char

168: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
169: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
170: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
171: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
172: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
173: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
174: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number
175: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number
176: );

Line 173: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date

169: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
170: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
171: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
172: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
173: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
174: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number
175: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number
176: );
177: --

Line 174: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number

170: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
171: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
172: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
173: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
174: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number
175: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number
176: );
177: --
178: exception

Line 175: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number

171: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
172: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
173: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
174: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number
175: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number
176: );
177: --
178: exception
179: --

Line 200: p_rec in pqh_rng_shd.g_rec_type

196: -- ----------------------------------------------------------------------------
197: Procedure del
198: (
199: p_effective_date in date,
200: p_rec in pqh_rng_shd.g_rec_type
201: ) is
202: --
203: l_proc varchar2(72) := g_package||'del';
204: --

Line 210: pqh_rng_shd.lck

206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: -- We must lock the row which we need to delete.
209: --
210: pqh_rng_shd.lck
211: (
212: p_rec.attribute_range_id,
213: p_rec.object_version_number
214: );

Line 245: l_rec pqh_rng_shd.g_rec_type;

241: p_attribute_range_id in number,
242: p_object_version_number in number
243: ) is
244: --
245: l_rec pqh_rng_shd.g_rec_type;
246: l_proc varchar2(72) := g_package||'del';
247: --
248: Begin
249: hr_utility.set_location('Entering:'||l_proc, 5);