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 HR_API

Line 97: When hr_api.check_integrity_violated Then

93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: --
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));

Line 101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: --
105: pqh_rmv_shd.constraint_error

Line 102: When hr_api.parent_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: --
105: pqh_rmv_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 106: (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: --
110: pqh_rmv_shd.constraint_error

Line 107: When hr_api.unique_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: --
110: pqh_rmv_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 111: (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;
115: End update_dml;

Line 278: when hr_api.cannot_find_prog_unit then

274: );
275: --
276: exception
277: --
278: when hr_api.cannot_find_prog_unit then
279: --
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'PQH_RT_MATRIX_NODE_VALUES'
282: ,p_hook_type => 'AU');

Line 280: hr_api.cannot_find_prog_unit_error

276: exception
277: --
278: when hr_api.cannot_find_prog_unit then
279: --
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'PQH_RT_MATRIX_NODE_VALUES'
282: ,p_hook_type => 'AU');
283: --
284: end;

Line 343: If (p_rec.rate_matrix_node_id = hr_api.g_number) then

339: -- p_rec plsql record structure
340: -- to see if a system default is being used. If a system default
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

Line 347: If (p_rec.short_code = hr_api.g_varchar2) then

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;
350: End If;
351: If (p_rec.char_value1 = hr_api.g_varchar2) then

Line 351: If (p_rec.char_value1 = hr_api.g_varchar2) then

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;
354: End If;
355: If (p_rec.char_value2 = hr_api.g_varchar2) then

Line 355: If (p_rec.char_value2 = hr_api.g_varchar2) then

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;
358: End If;
359: If (p_rec.char_value3 = hr_api.g_varchar2) then

Line 359: If (p_rec.char_value3 = hr_api.g_varchar2) then

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;
362: End If;
363: If (p_rec.char_value4 = hr_api.g_varchar2) then

Line 363: If (p_rec.char_value4 = hr_api.g_varchar2) then

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;
366: End If;
367: If (p_rec.number_value1 = hr_api.g_number) then

Line 367: If (p_rec.number_value1 = hr_api.g_number) then

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;
370: End If;
371: If (p_rec.number_value2 = hr_api.g_number) then

Line 371: If (p_rec.number_value2 = hr_api.g_number) then

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;
374: End If;
375: If (p_rec.number_value3 = hr_api.g_number) then

Line 375: If (p_rec.number_value3 = hr_api.g_number) then

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;
378: End If;
379: If (p_rec.number_value4 = hr_api.g_number) then

Line 379: If (p_rec.number_value4 = hr_api.g_number) then

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;
382: End If;
383: If (p_rec.date_value1 = hr_api.g_date) then

Line 383: If (p_rec.date_value1 = hr_api.g_date) then

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;
386: End If;
387: If (p_rec.date_value2 = hr_api.g_date) then

Line 387: If (p_rec.date_value2 = hr_api.g_date) then

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;
390: End If;
391: If (p_rec.date_value3 = hr_api.g_date) then

Line 391: If (p_rec.date_value3 = hr_api.g_date) then

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;
394: End If;
395: If (p_rec.date_value4 = hr_api.g_date) then

Line 395: If (p_rec.date_value4 = hr_api.g_date) then

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;
398: End If;
399: If (p_rec.business_group_id = hr_api.g_number) then

Line 399: If (p_rec.business_group_id = hr_api.g_number) then

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;
402: End If;
403: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 403: If (p_rec.legislation_code = hr_api.g_varchar2) then

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;
406: End If;
407: --

Line 467: ,p_rate_matrix_node_id in number default hr_api.g_number

463: -- ----------------------------------------------------------------------------
464: Procedure upd
465: (p_node_value_id in number
466: ,p_object_version_number in out nocopy number
467: ,p_rate_matrix_node_id in number default hr_api.g_number
468: ,p_short_code in varchar2 default hr_api.g_varchar2
469: ,p_char_value1 in varchar2 default hr_api.g_varchar2
470: ,p_char_value2 in varchar2 default hr_api.g_varchar2
471: ,p_char_value3 in varchar2 default hr_api.g_varchar2

Line 468: ,p_short_code in varchar2 default hr_api.g_varchar2

464: Procedure upd
465: (p_node_value_id in number
466: ,p_object_version_number in out nocopy number
467: ,p_rate_matrix_node_id in number default hr_api.g_number
468: ,p_short_code in varchar2 default hr_api.g_varchar2
469: ,p_char_value1 in varchar2 default hr_api.g_varchar2
470: ,p_char_value2 in varchar2 default hr_api.g_varchar2
471: ,p_char_value3 in varchar2 default hr_api.g_varchar2
472: ,p_char_value4 in varchar2 default hr_api.g_varchar2

Line 469: ,p_char_value1 in varchar2 default hr_api.g_varchar2

465: (p_node_value_id in number
466: ,p_object_version_number in out nocopy number
467: ,p_rate_matrix_node_id in number default hr_api.g_number
468: ,p_short_code in varchar2 default hr_api.g_varchar2
469: ,p_char_value1 in varchar2 default hr_api.g_varchar2
470: ,p_char_value2 in varchar2 default hr_api.g_varchar2
471: ,p_char_value3 in varchar2 default hr_api.g_varchar2
472: ,p_char_value4 in varchar2 default hr_api.g_varchar2
473: ,p_number_value1 in number default hr_api.g_number

Line 470: ,p_char_value2 in varchar2 default hr_api.g_varchar2

466: ,p_object_version_number in out nocopy number
467: ,p_rate_matrix_node_id in number default hr_api.g_number
468: ,p_short_code in varchar2 default hr_api.g_varchar2
469: ,p_char_value1 in varchar2 default hr_api.g_varchar2
470: ,p_char_value2 in varchar2 default hr_api.g_varchar2
471: ,p_char_value3 in varchar2 default hr_api.g_varchar2
472: ,p_char_value4 in varchar2 default hr_api.g_varchar2
473: ,p_number_value1 in number default hr_api.g_number
474: ,p_number_value2 in number default hr_api.g_number

Line 471: ,p_char_value3 in varchar2 default hr_api.g_varchar2

467: ,p_rate_matrix_node_id in number default hr_api.g_number
468: ,p_short_code in varchar2 default hr_api.g_varchar2
469: ,p_char_value1 in varchar2 default hr_api.g_varchar2
470: ,p_char_value2 in varchar2 default hr_api.g_varchar2
471: ,p_char_value3 in varchar2 default hr_api.g_varchar2
472: ,p_char_value4 in varchar2 default hr_api.g_varchar2
473: ,p_number_value1 in number default hr_api.g_number
474: ,p_number_value2 in number default hr_api.g_number
475: ,p_number_value3 in number default hr_api.g_number

Line 472: ,p_char_value4 in varchar2 default hr_api.g_varchar2

468: ,p_short_code in varchar2 default hr_api.g_varchar2
469: ,p_char_value1 in varchar2 default hr_api.g_varchar2
470: ,p_char_value2 in varchar2 default hr_api.g_varchar2
471: ,p_char_value3 in varchar2 default hr_api.g_varchar2
472: ,p_char_value4 in varchar2 default hr_api.g_varchar2
473: ,p_number_value1 in number default hr_api.g_number
474: ,p_number_value2 in number default hr_api.g_number
475: ,p_number_value3 in number default hr_api.g_number
476: ,p_number_value4 in number default hr_api.g_number

Line 473: ,p_number_value1 in number default hr_api.g_number

469: ,p_char_value1 in varchar2 default hr_api.g_varchar2
470: ,p_char_value2 in varchar2 default hr_api.g_varchar2
471: ,p_char_value3 in varchar2 default hr_api.g_varchar2
472: ,p_char_value4 in varchar2 default hr_api.g_varchar2
473: ,p_number_value1 in number default hr_api.g_number
474: ,p_number_value2 in number default hr_api.g_number
475: ,p_number_value3 in number default hr_api.g_number
476: ,p_number_value4 in number default hr_api.g_number
477: ,p_date_value1 in date default hr_api.g_date

Line 474: ,p_number_value2 in number default hr_api.g_number

470: ,p_char_value2 in varchar2 default hr_api.g_varchar2
471: ,p_char_value3 in varchar2 default hr_api.g_varchar2
472: ,p_char_value4 in varchar2 default hr_api.g_varchar2
473: ,p_number_value1 in number default hr_api.g_number
474: ,p_number_value2 in number default hr_api.g_number
475: ,p_number_value3 in number default hr_api.g_number
476: ,p_number_value4 in number default hr_api.g_number
477: ,p_date_value1 in date default hr_api.g_date
478: ,p_date_value2 in date default hr_api.g_date

Line 475: ,p_number_value3 in number default hr_api.g_number

471: ,p_char_value3 in varchar2 default hr_api.g_varchar2
472: ,p_char_value4 in varchar2 default hr_api.g_varchar2
473: ,p_number_value1 in number default hr_api.g_number
474: ,p_number_value2 in number default hr_api.g_number
475: ,p_number_value3 in number default hr_api.g_number
476: ,p_number_value4 in number default hr_api.g_number
477: ,p_date_value1 in date default hr_api.g_date
478: ,p_date_value2 in date default hr_api.g_date
479: ,p_date_value3 in date default hr_api.g_date

Line 476: ,p_number_value4 in number default hr_api.g_number

472: ,p_char_value4 in varchar2 default hr_api.g_varchar2
473: ,p_number_value1 in number default hr_api.g_number
474: ,p_number_value2 in number default hr_api.g_number
475: ,p_number_value3 in number default hr_api.g_number
476: ,p_number_value4 in number default hr_api.g_number
477: ,p_date_value1 in date default hr_api.g_date
478: ,p_date_value2 in date default hr_api.g_date
479: ,p_date_value3 in date default hr_api.g_date
480: ,p_date_value4 in date default hr_api.g_date

Line 477: ,p_date_value1 in date default hr_api.g_date

473: ,p_number_value1 in number default hr_api.g_number
474: ,p_number_value2 in number default hr_api.g_number
475: ,p_number_value3 in number default hr_api.g_number
476: ,p_number_value4 in number default hr_api.g_number
477: ,p_date_value1 in date default hr_api.g_date
478: ,p_date_value2 in date default hr_api.g_date
479: ,p_date_value3 in date default hr_api.g_date
480: ,p_date_value4 in date default hr_api.g_date
481: ,p_business_group_id in number default hr_api.g_number

Line 478: ,p_date_value2 in date default hr_api.g_date

474: ,p_number_value2 in number default hr_api.g_number
475: ,p_number_value3 in number default hr_api.g_number
476: ,p_number_value4 in number default hr_api.g_number
477: ,p_date_value1 in date default hr_api.g_date
478: ,p_date_value2 in date default hr_api.g_date
479: ,p_date_value3 in date default hr_api.g_date
480: ,p_date_value4 in date default hr_api.g_date
481: ,p_business_group_id in number default hr_api.g_number
482: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 479: ,p_date_value3 in date default hr_api.g_date

475: ,p_number_value3 in number default hr_api.g_number
476: ,p_number_value4 in number default hr_api.g_number
477: ,p_date_value1 in date default hr_api.g_date
478: ,p_date_value2 in date default hr_api.g_date
479: ,p_date_value3 in date default hr_api.g_date
480: ,p_date_value4 in date default hr_api.g_date
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

Line 480: ,p_date_value4 in date default hr_api.g_date

476: ,p_number_value4 in number default hr_api.g_number
477: ,p_date_value1 in date default hr_api.g_date
478: ,p_date_value2 in date default hr_api.g_date
479: ,p_date_value3 in date default hr_api.g_date
480: ,p_date_value4 in date default hr_api.g_date
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: --

Line 481: ,p_business_group_id in number default hr_api.g_number

477: ,p_date_value1 in date default hr_api.g_date
478: ,p_date_value2 in date default hr_api.g_date
479: ,p_date_value3 in date default hr_api.g_date
480: ,p_date_value4 in date default hr_api.g_date
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;

Line 482: ,p_legislation_code in varchar2 default hr_api.g_varchar2

478: ,p_date_value2 in date default hr_api.g_date
479: ,p_date_value3 in date default hr_api.g_date
480: ,p_date_value4 in date default hr_api.g_date
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';