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

Line 48: Procedure update_dml(p_rec in out nocopy pqh_rng_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pqh_rng_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 89: pqh_rng_shd.constraint_error

85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pqh_rng_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pqh_rng_shd.constraint_error

Line 93: pqh_rng_shd.constraint_error

89: pqh_rng_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: pqh_rng_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: pqh_rng_shd.constraint_error

Line 97: pqh_rng_shd.constraint_error

93: pqh_rng_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: pqh_rng_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: Raise;
101: End update_dml;

Line 135: Procedure pre_update(p_rec in pqh_rng_shd.g_rec_type) is

131: -- Internal Row Handler Use Only.
132: --
133: -- {End Of Comments}
134: -- ----------------------------------------------------------------------------
135: Procedure pre_update(p_rec in pqh_rng_shd.g_rec_type) is
136: --
137: l_proc varchar2(72) := g_package||'pre_update';
138: --
139: Begin

Line 178: p_effective_date in date,p_rec in pqh_rng_shd.g_rec_type) is

174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure post_update(
178: p_effective_date in date,p_rec in pqh_rng_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) := g_package||'post_update';
181: --
182: Begin

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

206: ,p_to_date =>p_rec.to_date
207: ,p_to_number =>p_rec.to_number
208: ,p_object_version_number =>p_rec.object_version_number
209: ,p_effective_date =>p_effective_date
210: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag
211: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
212: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
213: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
214: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id

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

207: ,p_to_number =>p_rec.to_number
208: ,p_object_version_number =>p_rec.object_version_number
209: ,p_effective_date =>p_effective_date
210: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag
211: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
212: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
213: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
214: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
215: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char

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

208: ,p_object_version_number =>p_rec.object_version_number
209: ,p_effective_date =>p_effective_date
210: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag
211: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
212: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
213: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
214: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
215: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
216: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date

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

209: ,p_effective_date =>p_effective_date
210: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag
211: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
212: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
213: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
214: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
215: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
216: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
217: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number

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

210: ,p_approver_flag_o =>pqh_rng_shd.g_old_rec.approver_flag
211: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
212: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
213: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
214: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
215: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
216: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
217: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
218: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id

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

211: ,p_enable_flag_o =>pqh_rng_shd.g_old_rec.enable_flag
212: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
213: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
214: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
215: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
216: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
217: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
218: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
219: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name

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

212: ,p_delete_flag_o =>pqh_rng_shd.g_old_rec.delete_flag
213: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
214: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
215: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
216: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
217: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
218: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
219: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
220: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id

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

213: ,p_assignment_id_o =>pqh_rng_shd.g_old_rec.assignment_id
214: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
215: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
216: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
217: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
218: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
219: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
220: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
221: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id

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

214: ,p_attribute_id_o =>pqh_rng_shd.g_old_rec.attribute_id
215: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
216: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
217: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
218: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
219: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
220: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
221: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
222: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char

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

215: ,p_from_char_o =>pqh_rng_shd.g_old_rec.from_char
216: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
217: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
218: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
219: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
220: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
221: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
222: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
223: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date

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

216: ,p_from_date_o =>pqh_rng_shd.g_old_rec.from_date
217: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
218: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
219: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
220: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
221: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
222: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
223: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
224: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number

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

217: ,p_from_number_o =>pqh_rng_shd.g_old_rec.from_number
218: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
219: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
220: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
221: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
222: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
223: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
224: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number
225: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number

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

218: ,p_position_id_o =>pqh_rng_shd.g_old_rec.position_id
219: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
220: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
221: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
222: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
223: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
224: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number
225: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number
226: );

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

219: ,p_range_name_o =>pqh_rng_shd.g_old_rec.range_name
220: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
221: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
222: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
223: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
224: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number
225: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number
226: );
227: --

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

220: ,p_routing_category_id_o =>pqh_rng_shd.g_old_rec.routing_category_id
221: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
222: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
223: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
224: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number
225: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number
226: );
227: --
228: exception

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

221: ,p_routing_list_member_id_o =>pqh_rng_shd.g_old_rec.routing_list_member_id
222: ,p_to_char_o =>pqh_rng_shd.g_old_rec.to_char
223: ,p_to_date_o =>pqh_rng_shd.g_old_rec.to_date
224: ,p_to_number_o =>pqh_rng_shd.g_old_rec.to_number
225: ,p_object_version_number_o =>pqh_rng_shd.g_old_rec.object_version_number
226: );
227: --
228: exception
229: --

Line 287: Procedure convert_defs(p_rec in out nocopy pqh_rng_shd.g_rec_type) is

283: -- Internal Row Handler Use Only.
284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure convert_defs(p_rec in out nocopy pqh_rng_shd.g_rec_type) is
288: --
289: l_proc varchar2(72) := g_package||'convert_defs';
290: --
291: Begin

Line 302: pqh_rng_shd.g_old_rec.approver_flag;

298: -- is being used then we must set to the 'current' argument value.
299: --
300: If (p_rec.approver_flag = hr_api.g_varchar2) then
301: p_rec.approver_flag :=
302: pqh_rng_shd.g_old_rec.approver_flag;
303: End If;
304: If (p_rec.enable_flag = hr_api.g_varchar2) then
305: p_rec.enable_flag :=
306: pqh_rng_shd.g_old_rec.enable_flag;

Line 306: pqh_rng_shd.g_old_rec.enable_flag;

302: pqh_rng_shd.g_old_rec.approver_flag;
303: End If;
304: If (p_rec.enable_flag = hr_api.g_varchar2) then
305: p_rec.enable_flag :=
306: pqh_rng_shd.g_old_rec.enable_flag;
307: End If;
308: If (p_rec.delete_flag = hr_api.g_varchar2) then
309: p_rec.delete_flag :=
310: pqh_rng_shd.g_old_rec.delete_flag;

Line 310: pqh_rng_shd.g_old_rec.delete_flag;

306: pqh_rng_shd.g_old_rec.enable_flag;
307: End If;
308: If (p_rec.delete_flag = hr_api.g_varchar2) then
309: p_rec.delete_flag :=
310: pqh_rng_shd.g_old_rec.delete_flag;
311: End If;
312: If (p_rec.assignment_id = hr_api.g_number) then
313: p_rec.assignment_id :=
314: pqh_rng_shd.g_old_rec.assignment_id;

Line 314: pqh_rng_shd.g_old_rec.assignment_id;

310: pqh_rng_shd.g_old_rec.delete_flag;
311: End If;
312: If (p_rec.assignment_id = hr_api.g_number) then
313: p_rec.assignment_id :=
314: pqh_rng_shd.g_old_rec.assignment_id;
315: End If;
316: If (p_rec.attribute_id = hr_api.g_number) then
317: p_rec.attribute_id :=
318: pqh_rng_shd.g_old_rec.attribute_id;

Line 318: pqh_rng_shd.g_old_rec.attribute_id;

314: pqh_rng_shd.g_old_rec.assignment_id;
315: End If;
316: If (p_rec.attribute_id = hr_api.g_number) then
317: p_rec.attribute_id :=
318: pqh_rng_shd.g_old_rec.attribute_id;
319: End If;
320: If (p_rec.from_char = hr_api.g_varchar2) then
321: p_rec.from_char :=
322: pqh_rng_shd.g_old_rec.from_char;

Line 322: pqh_rng_shd.g_old_rec.from_char;

318: pqh_rng_shd.g_old_rec.attribute_id;
319: End If;
320: If (p_rec.from_char = hr_api.g_varchar2) then
321: p_rec.from_char :=
322: pqh_rng_shd.g_old_rec.from_char;
323: End If;
324: If (p_rec.from_date = hr_api.g_date) then
325: p_rec.from_date :=
326: pqh_rng_shd.g_old_rec.from_date;

Line 326: pqh_rng_shd.g_old_rec.from_date;

322: pqh_rng_shd.g_old_rec.from_char;
323: End If;
324: If (p_rec.from_date = hr_api.g_date) then
325: p_rec.from_date :=
326: pqh_rng_shd.g_old_rec.from_date;
327: End If;
328: If (p_rec.from_number = hr_api.g_number) then
329: p_rec.from_number :=
330: pqh_rng_shd.g_old_rec.from_number;

Line 330: pqh_rng_shd.g_old_rec.from_number;

326: pqh_rng_shd.g_old_rec.from_date;
327: End If;
328: If (p_rec.from_number = hr_api.g_number) then
329: p_rec.from_number :=
330: pqh_rng_shd.g_old_rec.from_number;
331: End If;
332: If (p_rec.position_id = hr_api.g_number) then
333: p_rec.position_id :=
334: pqh_rng_shd.g_old_rec.position_id;

Line 334: pqh_rng_shd.g_old_rec.position_id;

330: pqh_rng_shd.g_old_rec.from_number;
331: End If;
332: If (p_rec.position_id = hr_api.g_number) then
333: p_rec.position_id :=
334: pqh_rng_shd.g_old_rec.position_id;
335: End If;
336: If (p_rec.range_name = hr_api.g_varchar2) then
337: p_rec.range_name :=
338: pqh_rng_shd.g_old_rec.range_name;

Line 338: pqh_rng_shd.g_old_rec.range_name;

334: pqh_rng_shd.g_old_rec.position_id;
335: End If;
336: If (p_rec.range_name = hr_api.g_varchar2) then
337: p_rec.range_name :=
338: pqh_rng_shd.g_old_rec.range_name;
339: End If;
340: If (p_rec.routing_category_id = hr_api.g_number) then
341: p_rec.routing_category_id :=
342: pqh_rng_shd.g_old_rec.routing_category_id;

Line 342: pqh_rng_shd.g_old_rec.routing_category_id;

338: pqh_rng_shd.g_old_rec.range_name;
339: End If;
340: If (p_rec.routing_category_id = hr_api.g_number) then
341: p_rec.routing_category_id :=
342: pqh_rng_shd.g_old_rec.routing_category_id;
343: End If;
344: If (p_rec.routing_list_member_id = hr_api.g_number) then
345: p_rec.routing_list_member_id :=
346: pqh_rng_shd.g_old_rec.routing_list_member_id;

Line 346: pqh_rng_shd.g_old_rec.routing_list_member_id;

342: pqh_rng_shd.g_old_rec.routing_category_id;
343: End If;
344: If (p_rec.routing_list_member_id = hr_api.g_number) then
345: p_rec.routing_list_member_id :=
346: pqh_rng_shd.g_old_rec.routing_list_member_id;
347: End If;
348: If (p_rec.to_char = hr_api.g_varchar2) then
349: p_rec.to_char :=
350: pqh_rng_shd.g_old_rec.to_char;

Line 350: pqh_rng_shd.g_old_rec.to_char;

346: pqh_rng_shd.g_old_rec.routing_list_member_id;
347: End If;
348: If (p_rec.to_char = hr_api.g_varchar2) then
349: p_rec.to_char :=
350: pqh_rng_shd.g_old_rec.to_char;
351: End If;
352: If (p_rec.to_date = hr_api.g_date) then
353: p_rec.to_date :=
354: pqh_rng_shd.g_old_rec.to_date;

Line 354: pqh_rng_shd.g_old_rec.to_date;

350: pqh_rng_shd.g_old_rec.to_char;
351: End If;
352: If (p_rec.to_date = hr_api.g_date) then
353: p_rec.to_date :=
354: pqh_rng_shd.g_old_rec.to_date;
355: End If;
356: If (p_rec.to_number = hr_api.g_number) then
357: p_rec.to_number :=
358: pqh_rng_shd.g_old_rec.to_number;

Line 358: pqh_rng_shd.g_old_rec.to_number;

354: pqh_rng_shd.g_old_rec.to_date;
355: End If;
356: If (p_rec.to_number = hr_api.g_number) then
357: p_rec.to_number :=
358: pqh_rng_shd.g_old_rec.to_number;
359: End If;
360:
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 372: p_rec in out nocopy pqh_rng_shd.g_rec_type

368: -- ----------------------------------------------------------------------------
369: Procedure upd
370: (
371: p_effective_date in date,
372: p_rec in out nocopy pqh_rng_shd.g_rec_type
373: ) is
374: --
375: l_proc varchar2(72) := g_package||'upd';
376: --

Line 382: pqh_rng_shd.lck

378: hr_utility.set_location('Entering:'||l_proc, 5);
379: --
380: -- We must lock the row which we need to update.
381: --
382: pqh_rng_shd.lck
383: (
384: p_rec.attribute_range_id,
385: p_rec.object_version_number
386: );

Line 437: l_rec pqh_rng_shd.g_rec_type;

433: p_to_number in number default hr_api.g_number,
434: p_object_version_number in out nocopy number
435: ) is
436: --
437: l_rec pqh_rng_shd.g_rec_type;
438: l_proc varchar2(72) := g_package||'upd';
439: --
440: Begin
441: hr_utility.set_location('Entering:'||l_proc, 5);

Line 447: pqh_rng_shd.convert_args

443: -- Call conversion function to turn arguments into the
444: -- l_rec structure.
445: --
446: l_rec :=
447: pqh_rng_shd.convert_args
448: (
449: p_attribute_range_id,
450: p_approver_flag,
451: p_enable_flag,