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_RMV_UPD dependencies on PQH_RMV_SHD

Line 55: (p_rec in out nocopy pqh_rmv_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_rmv_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 100: pqh_rmv_shd.constraint_error

96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: --
100: pqh_rmv_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: --

Line 105: pqh_rmv_shd.constraint_error

101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: --
105: pqh_rmv_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: --

Line 110: pqh_rmv_shd.constraint_error

106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: --
110: pqh_rmv_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When Others Then
113: --
114: Raise;

Line 150: (p_rec in pqh_rmv_shd.g_rec_type

146: --
147: -- {End Of Comments}
148: -- ----------------------------------------------------------------------------
149: Procedure pre_update
150: (p_rec in pqh_rmv_shd.g_rec_type
151: ) is
152: --
153: l_proc varchar2(72) := g_package||'pre_update';
154: --

Line 194: (p_rec in pqh_rmv_shd.g_rec_type

190: --
191: -- {End Of Comments}
192: -- ----------------------------------------------------------------------------
193: Procedure post_update
194: (p_rec in pqh_rmv_shd.g_rec_type
195: ) is
196: --
197: l_proc varchar2(72) := g_package||'post_update';
198: --

Line 241: => pqh_rmv_shd.g_old_rec.rate_matrix_node_id

237: => p_rec.legislation_code
238: ,p_object_version_number
239: => p_rec.object_version_number
240: ,p_rate_matrix_node_id_o
241: => pqh_rmv_shd.g_old_rec.rate_matrix_node_id
242: ,p_short_code_o
243: => pqh_rmv_shd.g_old_rec.short_code
244: ,p_char_value1_o
245: => pqh_rmv_shd.g_old_rec.char_value1

Line 243: => pqh_rmv_shd.g_old_rec.short_code

239: => p_rec.object_version_number
240: ,p_rate_matrix_node_id_o
241: => pqh_rmv_shd.g_old_rec.rate_matrix_node_id
242: ,p_short_code_o
243: => pqh_rmv_shd.g_old_rec.short_code
244: ,p_char_value1_o
245: => pqh_rmv_shd.g_old_rec.char_value1
246: ,p_char_value2_o
247: => pqh_rmv_shd.g_old_rec.char_value2

Line 245: => pqh_rmv_shd.g_old_rec.char_value1

241: => pqh_rmv_shd.g_old_rec.rate_matrix_node_id
242: ,p_short_code_o
243: => pqh_rmv_shd.g_old_rec.short_code
244: ,p_char_value1_o
245: => pqh_rmv_shd.g_old_rec.char_value1
246: ,p_char_value2_o
247: => pqh_rmv_shd.g_old_rec.char_value2
248: ,p_char_value3_o
249: => pqh_rmv_shd.g_old_rec.char_value3

Line 247: => pqh_rmv_shd.g_old_rec.char_value2

243: => pqh_rmv_shd.g_old_rec.short_code
244: ,p_char_value1_o
245: => pqh_rmv_shd.g_old_rec.char_value1
246: ,p_char_value2_o
247: => pqh_rmv_shd.g_old_rec.char_value2
248: ,p_char_value3_o
249: => pqh_rmv_shd.g_old_rec.char_value3
250: ,p_char_value4_o
251: => pqh_rmv_shd.g_old_rec.char_value4

Line 249: => pqh_rmv_shd.g_old_rec.char_value3

245: => pqh_rmv_shd.g_old_rec.char_value1
246: ,p_char_value2_o
247: => pqh_rmv_shd.g_old_rec.char_value2
248: ,p_char_value3_o
249: => pqh_rmv_shd.g_old_rec.char_value3
250: ,p_char_value4_o
251: => pqh_rmv_shd.g_old_rec.char_value4
252: ,p_number_value1_o
253: => pqh_rmv_shd.g_old_rec.number_value1

Line 251: => pqh_rmv_shd.g_old_rec.char_value4

247: => pqh_rmv_shd.g_old_rec.char_value2
248: ,p_char_value3_o
249: => pqh_rmv_shd.g_old_rec.char_value3
250: ,p_char_value4_o
251: => pqh_rmv_shd.g_old_rec.char_value4
252: ,p_number_value1_o
253: => pqh_rmv_shd.g_old_rec.number_value1
254: ,p_number_value2_o
255: => pqh_rmv_shd.g_old_rec.number_value2

Line 253: => pqh_rmv_shd.g_old_rec.number_value1

249: => pqh_rmv_shd.g_old_rec.char_value3
250: ,p_char_value4_o
251: => pqh_rmv_shd.g_old_rec.char_value4
252: ,p_number_value1_o
253: => pqh_rmv_shd.g_old_rec.number_value1
254: ,p_number_value2_o
255: => pqh_rmv_shd.g_old_rec.number_value2
256: ,p_number_value3_o
257: => pqh_rmv_shd.g_old_rec.number_value3

Line 255: => pqh_rmv_shd.g_old_rec.number_value2

251: => pqh_rmv_shd.g_old_rec.char_value4
252: ,p_number_value1_o
253: => pqh_rmv_shd.g_old_rec.number_value1
254: ,p_number_value2_o
255: => pqh_rmv_shd.g_old_rec.number_value2
256: ,p_number_value3_o
257: => pqh_rmv_shd.g_old_rec.number_value3
258: ,p_number_value4_o
259: => pqh_rmv_shd.g_old_rec.number_value4

Line 257: => pqh_rmv_shd.g_old_rec.number_value3

253: => pqh_rmv_shd.g_old_rec.number_value1
254: ,p_number_value2_o
255: => pqh_rmv_shd.g_old_rec.number_value2
256: ,p_number_value3_o
257: => pqh_rmv_shd.g_old_rec.number_value3
258: ,p_number_value4_o
259: => pqh_rmv_shd.g_old_rec.number_value4
260: ,p_date_value1_o
261: => pqh_rmv_shd.g_old_rec.date_value1

Line 259: => pqh_rmv_shd.g_old_rec.number_value4

255: => pqh_rmv_shd.g_old_rec.number_value2
256: ,p_number_value3_o
257: => pqh_rmv_shd.g_old_rec.number_value3
258: ,p_number_value4_o
259: => pqh_rmv_shd.g_old_rec.number_value4
260: ,p_date_value1_o
261: => pqh_rmv_shd.g_old_rec.date_value1
262: ,p_date_value2_o
263: => pqh_rmv_shd.g_old_rec.date_value2

Line 261: => pqh_rmv_shd.g_old_rec.date_value1

257: => pqh_rmv_shd.g_old_rec.number_value3
258: ,p_number_value4_o
259: => pqh_rmv_shd.g_old_rec.number_value4
260: ,p_date_value1_o
261: => pqh_rmv_shd.g_old_rec.date_value1
262: ,p_date_value2_o
263: => pqh_rmv_shd.g_old_rec.date_value2
264: ,p_date_value3_o
265: => pqh_rmv_shd.g_old_rec.date_value3

Line 263: => pqh_rmv_shd.g_old_rec.date_value2

259: => pqh_rmv_shd.g_old_rec.number_value4
260: ,p_date_value1_o
261: => pqh_rmv_shd.g_old_rec.date_value1
262: ,p_date_value2_o
263: => pqh_rmv_shd.g_old_rec.date_value2
264: ,p_date_value3_o
265: => pqh_rmv_shd.g_old_rec.date_value3
266: ,p_date_value4_o
267: => pqh_rmv_shd.g_old_rec.date_value4

Line 265: => pqh_rmv_shd.g_old_rec.date_value3

261: => pqh_rmv_shd.g_old_rec.date_value1
262: ,p_date_value2_o
263: => pqh_rmv_shd.g_old_rec.date_value2
264: ,p_date_value3_o
265: => pqh_rmv_shd.g_old_rec.date_value3
266: ,p_date_value4_o
267: => pqh_rmv_shd.g_old_rec.date_value4
268: ,p_business_group_id_o
269: => pqh_rmv_shd.g_old_rec.business_group_id

Line 267: => pqh_rmv_shd.g_old_rec.date_value4

263: => pqh_rmv_shd.g_old_rec.date_value2
264: ,p_date_value3_o
265: => pqh_rmv_shd.g_old_rec.date_value3
266: ,p_date_value4_o
267: => pqh_rmv_shd.g_old_rec.date_value4
268: ,p_business_group_id_o
269: => pqh_rmv_shd.g_old_rec.business_group_id
270: ,p_legislation_code_o
271: => pqh_rmv_shd.g_old_rec.legislation_code

Line 269: => pqh_rmv_shd.g_old_rec.business_group_id

265: => pqh_rmv_shd.g_old_rec.date_value3
266: ,p_date_value4_o
267: => pqh_rmv_shd.g_old_rec.date_value4
268: ,p_business_group_id_o
269: => pqh_rmv_shd.g_old_rec.business_group_id
270: ,p_legislation_code_o
271: => pqh_rmv_shd.g_old_rec.legislation_code
272: ,p_object_version_number_o
273: => pqh_rmv_shd.g_old_rec.object_version_number

Line 271: => pqh_rmv_shd.g_old_rec.legislation_code

267: => pqh_rmv_shd.g_old_rec.date_value4
268: ,p_business_group_id_o
269: => pqh_rmv_shd.g_old_rec.business_group_id
270: ,p_legislation_code_o
271: => pqh_rmv_shd.g_old_rec.legislation_code
272: ,p_object_version_number_o
273: => pqh_rmv_shd.g_old_rec.object_version_number
274: );
275: --

Line 273: => pqh_rmv_shd.g_old_rec.object_version_number

269: => pqh_rmv_shd.g_old_rec.business_group_id
270: ,p_legislation_code_o
271: => pqh_rmv_shd.g_old_rec.legislation_code
272: ,p_object_version_number_o
273: => pqh_rmv_shd.g_old_rec.object_version_number
274: );
275: --
276: exception
277: --

Line 333: (p_rec in out nocopy pqh_rmv_shd.g_rec_type

329: --
330: -- {End Of Comments}
331: -- ----------------------------------------------------------------------------
332: Procedure convert_defs
333: (p_rec in out nocopy pqh_rmv_shd.g_rec_type
334: ) is
335: --
336: Begin
337: --

Line 345: pqh_rmv_shd.g_old_rec.rate_matrix_node_id;

341: -- is being used then we must set to the 'current' argument value.
342: --
343: If (p_rec.rate_matrix_node_id = hr_api.g_number) then
344: p_rec.rate_matrix_node_id :=
345: pqh_rmv_shd.g_old_rec.rate_matrix_node_id;
346: End If;
347: If (p_rec.short_code = hr_api.g_varchar2) then
348: p_rec.short_code :=
349: pqh_rmv_shd.g_old_rec.short_code;

Line 349: pqh_rmv_shd.g_old_rec.short_code;

345: pqh_rmv_shd.g_old_rec.rate_matrix_node_id;
346: End If;
347: If (p_rec.short_code = hr_api.g_varchar2) then
348: p_rec.short_code :=
349: pqh_rmv_shd.g_old_rec.short_code;
350: End If;
351: If (p_rec.char_value1 = hr_api.g_varchar2) then
352: p_rec.char_value1 :=
353: pqh_rmv_shd.g_old_rec.char_value1;

Line 353: pqh_rmv_shd.g_old_rec.char_value1;

349: pqh_rmv_shd.g_old_rec.short_code;
350: End If;
351: If (p_rec.char_value1 = hr_api.g_varchar2) then
352: p_rec.char_value1 :=
353: pqh_rmv_shd.g_old_rec.char_value1;
354: End If;
355: If (p_rec.char_value2 = hr_api.g_varchar2) then
356: p_rec.char_value2 :=
357: pqh_rmv_shd.g_old_rec.char_value2;

Line 357: pqh_rmv_shd.g_old_rec.char_value2;

353: pqh_rmv_shd.g_old_rec.char_value1;
354: End If;
355: If (p_rec.char_value2 = hr_api.g_varchar2) then
356: p_rec.char_value2 :=
357: pqh_rmv_shd.g_old_rec.char_value2;
358: End If;
359: If (p_rec.char_value3 = hr_api.g_varchar2) then
360: p_rec.char_value3 :=
361: pqh_rmv_shd.g_old_rec.char_value3;

Line 361: pqh_rmv_shd.g_old_rec.char_value3;

357: pqh_rmv_shd.g_old_rec.char_value2;
358: End If;
359: If (p_rec.char_value3 = hr_api.g_varchar2) then
360: p_rec.char_value3 :=
361: pqh_rmv_shd.g_old_rec.char_value3;
362: End If;
363: If (p_rec.char_value4 = hr_api.g_varchar2) then
364: p_rec.char_value4 :=
365: pqh_rmv_shd.g_old_rec.char_value4;

Line 365: pqh_rmv_shd.g_old_rec.char_value4;

361: pqh_rmv_shd.g_old_rec.char_value3;
362: End If;
363: If (p_rec.char_value4 = hr_api.g_varchar2) then
364: p_rec.char_value4 :=
365: pqh_rmv_shd.g_old_rec.char_value4;
366: End If;
367: If (p_rec.number_value1 = hr_api.g_number) then
368: p_rec.number_value1 :=
369: pqh_rmv_shd.g_old_rec.number_value1;

Line 369: pqh_rmv_shd.g_old_rec.number_value1;

365: pqh_rmv_shd.g_old_rec.char_value4;
366: End If;
367: If (p_rec.number_value1 = hr_api.g_number) then
368: p_rec.number_value1 :=
369: pqh_rmv_shd.g_old_rec.number_value1;
370: End If;
371: If (p_rec.number_value2 = hr_api.g_number) then
372: p_rec.number_value2 :=
373: pqh_rmv_shd.g_old_rec.number_value2;

Line 373: pqh_rmv_shd.g_old_rec.number_value2;

369: pqh_rmv_shd.g_old_rec.number_value1;
370: End If;
371: If (p_rec.number_value2 = hr_api.g_number) then
372: p_rec.number_value2 :=
373: pqh_rmv_shd.g_old_rec.number_value2;
374: End If;
375: If (p_rec.number_value3 = hr_api.g_number) then
376: p_rec.number_value3 :=
377: pqh_rmv_shd.g_old_rec.number_value3;

Line 377: pqh_rmv_shd.g_old_rec.number_value3;

373: pqh_rmv_shd.g_old_rec.number_value2;
374: End If;
375: If (p_rec.number_value3 = hr_api.g_number) then
376: p_rec.number_value3 :=
377: pqh_rmv_shd.g_old_rec.number_value3;
378: End If;
379: If (p_rec.number_value4 = hr_api.g_number) then
380: p_rec.number_value4 :=
381: pqh_rmv_shd.g_old_rec.number_value4;

Line 381: pqh_rmv_shd.g_old_rec.number_value4;

377: pqh_rmv_shd.g_old_rec.number_value3;
378: End If;
379: If (p_rec.number_value4 = hr_api.g_number) then
380: p_rec.number_value4 :=
381: pqh_rmv_shd.g_old_rec.number_value4;
382: End If;
383: If (p_rec.date_value1 = hr_api.g_date) then
384: p_rec.date_value1 :=
385: pqh_rmv_shd.g_old_rec.date_value1;

Line 385: pqh_rmv_shd.g_old_rec.date_value1;

381: pqh_rmv_shd.g_old_rec.number_value4;
382: End If;
383: If (p_rec.date_value1 = hr_api.g_date) then
384: p_rec.date_value1 :=
385: pqh_rmv_shd.g_old_rec.date_value1;
386: End If;
387: If (p_rec.date_value2 = hr_api.g_date) then
388: p_rec.date_value2 :=
389: pqh_rmv_shd.g_old_rec.date_value2;

Line 389: pqh_rmv_shd.g_old_rec.date_value2;

385: pqh_rmv_shd.g_old_rec.date_value1;
386: End If;
387: If (p_rec.date_value2 = hr_api.g_date) then
388: p_rec.date_value2 :=
389: pqh_rmv_shd.g_old_rec.date_value2;
390: End If;
391: If (p_rec.date_value3 = hr_api.g_date) then
392: p_rec.date_value3 :=
393: pqh_rmv_shd.g_old_rec.date_value3;

Line 393: pqh_rmv_shd.g_old_rec.date_value3;

389: pqh_rmv_shd.g_old_rec.date_value2;
390: End If;
391: If (p_rec.date_value3 = hr_api.g_date) then
392: p_rec.date_value3 :=
393: pqh_rmv_shd.g_old_rec.date_value3;
394: End If;
395: If (p_rec.date_value4 = hr_api.g_date) then
396: p_rec.date_value4 :=
397: pqh_rmv_shd.g_old_rec.date_value4;

Line 397: pqh_rmv_shd.g_old_rec.date_value4;

393: pqh_rmv_shd.g_old_rec.date_value3;
394: End If;
395: If (p_rec.date_value4 = hr_api.g_date) then
396: p_rec.date_value4 :=
397: pqh_rmv_shd.g_old_rec.date_value4;
398: End If;
399: If (p_rec.business_group_id = hr_api.g_number) then
400: p_rec.business_group_id :=
401: pqh_rmv_shd.g_old_rec.business_group_id;

Line 401: pqh_rmv_shd.g_old_rec.business_group_id;

397: pqh_rmv_shd.g_old_rec.date_value4;
398: End If;
399: If (p_rec.business_group_id = hr_api.g_number) then
400: p_rec.business_group_id :=
401: pqh_rmv_shd.g_old_rec.business_group_id;
402: End If;
403: If (p_rec.legislation_code = hr_api.g_varchar2) then
404: p_rec.legislation_code :=
405: pqh_rmv_shd.g_old_rec.legislation_code;

Line 405: pqh_rmv_shd.g_old_rec.legislation_code;

401: pqh_rmv_shd.g_old_rec.business_group_id;
402: End If;
403: If (p_rec.legislation_code = hr_api.g_varchar2) then
404: p_rec.legislation_code :=
405: pqh_rmv_shd.g_old_rec.legislation_code;
406: End If;
407: --
408: End convert_defs;
409: --

Line 414: (p_rec in out nocopy pqh_rmv_shd.g_rec_type

410: -- ----------------------------------------------------------------------------
411: -- |---------------------------------< upd >----------------------------------|
412: -- ----------------------------------------------------------------------------
413: Procedure upd
414: (p_rec in out nocopy pqh_rmv_shd.g_rec_type
415: ) is
416: --
417: l_proc varchar2(72) := g_package||'upd';
418: --

Line 424: pqh_rmv_shd.lck

420: hr_utility.set_location('Entering:'||l_proc, 5);
421: --
422: -- We must lock the row which we need to update.
423: --
424: pqh_rmv_shd.lck
425: (p_rec.node_value_id
426: ,p_rec.object_version_number
427: );
428: --

Line 485: l_rec pqh_rmv_shd.g_rec_type;

481: ,p_business_group_id in number default hr_api.g_number
482: ,p_legislation_code in varchar2 default hr_api.g_varchar2
483: ) is
484: --
485: l_rec pqh_rmv_shd.g_rec_type;
486: l_proc varchar2(72) := g_package||'upd';
487: --
488: Begin
489: hr_utility.set_location('Entering:'||l_proc, 5);

Line 495: pqh_rmv_shd.convert_args

491: -- Call conversion function to turn arguments into the
492: -- l_rec structure.
493: --
494: l_rec :=
495: pqh_rmv_shd.convert_args
496: (p_node_value_id
497: ,p_rate_matrix_node_id
498: ,p_short_code
499: ,p_char_value1