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.AME_APT_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 114: When hr_api.check_integrity_violated Then

110: End If;
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 15);
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: ame_apt_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: ame_apt_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ame_apt_shd.constraint_error

Line 119: When hr_api.unique_integrity_violated Then

115: -- A check constraint has been violated
116: --
117: ame_apt_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ame_apt_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ame_apt_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: --
126: Raise;
127: End dt_update_dml;

Line 240: If (p_datetrack_mode <> hr_api.g_correction) then

236: l_dummy_version_number number;
237: --
238: Begin
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: If (p_datetrack_mode <> hr_api.g_correction) then
241: --
242: -- Update the current effective end date
243: --
244: ame_apt_shd.upd_effective_end_date

Line 253: If (p_datetrack_mode = hr_api.g_update_override) then

249: ,p_validation_end_date => p_validation_end_date
250: ,p_object_version_number => l_dummy_version_number
251: );
252: --
253: If (p_datetrack_mode = hr_api.g_update_override) then
254: --
255: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
256: -- delete any future rows
257: --

Line 424: when hr_api.cannot_find_prog_unit then

420: );
421: --
422: exception
423: --
424: when hr_api.cannot_find_prog_unit then
425: --
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'ame_approver_types'
428: ,p_hook_type => 'AU');

Line 426: hr_api.cannot_find_prog_unit_error

422: exception
423: --
424: when hr_api.cannot_find_prog_unit then
425: --
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'ame_approver_types'
428: ,p_hook_type => 'AU');
429: --
430: end;

Line 489: If (p_rec.orig_system = hr_api.g_varchar2) then

485: -- p_rec plsql record structure
486: -- to see if a system default is being used. If a system default
487: -- is being used then we must set to the 'current' argument value.
488: --
489: If (p_rec.orig_system = hr_api.g_varchar2) then
490: p_rec.orig_system :=
491: ame_apt_shd.g_old_rec.orig_system;
492: End If;
493: If (p_rec.query_variable_1_label = hr_api.g_varchar2) then

Line 493: If (p_rec.query_variable_1_label = hr_api.g_varchar2) then

489: If (p_rec.orig_system = hr_api.g_varchar2) then
490: p_rec.orig_system :=
491: ame_apt_shd.g_old_rec.orig_system;
492: End If;
493: If (p_rec.query_variable_1_label = hr_api.g_varchar2) then
494: p_rec.query_variable_1_label :=
495: ame_apt_shd.g_old_rec.query_variable_1_label;
496: End If;
497: If (p_rec.query_variable_2_label = hr_api.g_varchar2) then

Line 497: If (p_rec.query_variable_2_label = hr_api.g_varchar2) then

493: If (p_rec.query_variable_1_label = hr_api.g_varchar2) then
494: p_rec.query_variable_1_label :=
495: ame_apt_shd.g_old_rec.query_variable_1_label;
496: End If;
497: If (p_rec.query_variable_2_label = hr_api.g_varchar2) then
498: p_rec.query_variable_2_label :=
499: ame_apt_shd.g_old_rec.query_variable_2_label;
500: End If;
501: If (p_rec.query_variable_3_label = hr_api.g_varchar2) then

Line 501: If (p_rec.query_variable_3_label = hr_api.g_varchar2) then

497: If (p_rec.query_variable_2_label = hr_api.g_varchar2) then
498: p_rec.query_variable_2_label :=
499: ame_apt_shd.g_old_rec.query_variable_2_label;
500: End If;
501: If (p_rec.query_variable_3_label = hr_api.g_varchar2) then
502: p_rec.query_variable_3_label :=
503: ame_apt_shd.g_old_rec.query_variable_3_label;
504: End If;
505: If (p_rec.query_variable_4_label = hr_api.g_varchar2) then

Line 505: If (p_rec.query_variable_4_label = hr_api.g_varchar2) then

501: If (p_rec.query_variable_3_label = hr_api.g_varchar2) then
502: p_rec.query_variable_3_label :=
503: ame_apt_shd.g_old_rec.query_variable_3_label;
504: End If;
505: If (p_rec.query_variable_4_label = hr_api.g_varchar2) then
506: p_rec.query_variable_4_label :=
507: ame_apt_shd.g_old_rec.query_variable_4_label;
508: End If;
509: If (p_rec.query_variable_5_label = hr_api.g_varchar2) then

Line 509: If (p_rec.query_variable_5_label = hr_api.g_varchar2) then

505: If (p_rec.query_variable_4_label = hr_api.g_varchar2) then
506: p_rec.query_variable_4_label :=
507: ame_apt_shd.g_old_rec.query_variable_4_label;
508: End If;
509: If (p_rec.query_variable_5_label = hr_api.g_varchar2) then
510: p_rec.query_variable_5_label :=
511: ame_apt_shd.g_old_rec.query_variable_5_label;
512: End If;
513: If (p_rec.variable_1_lov_query = hr_api.g_varchar2) then

Line 513: If (p_rec.variable_1_lov_query = hr_api.g_varchar2) then

509: If (p_rec.query_variable_5_label = hr_api.g_varchar2) then
510: p_rec.query_variable_5_label :=
511: ame_apt_shd.g_old_rec.query_variable_5_label;
512: End If;
513: If (p_rec.variable_1_lov_query = hr_api.g_varchar2) then
514: p_rec.variable_1_lov_query :=
515: ame_apt_shd.g_old_rec.variable_1_lov_query;
516: End If;
517: If (p_rec.variable_2_lov_query = hr_api.g_varchar2) then

Line 517: If (p_rec.variable_2_lov_query = hr_api.g_varchar2) then

513: If (p_rec.variable_1_lov_query = hr_api.g_varchar2) then
514: p_rec.variable_1_lov_query :=
515: ame_apt_shd.g_old_rec.variable_1_lov_query;
516: End If;
517: If (p_rec.variable_2_lov_query = hr_api.g_varchar2) then
518: p_rec.variable_2_lov_query :=
519: ame_apt_shd.g_old_rec.variable_2_lov_query;
520: End If;
521: If (p_rec.variable_3_lov_query = hr_api.g_varchar2) then

Line 521: If (p_rec.variable_3_lov_query = hr_api.g_varchar2) then

517: If (p_rec.variable_2_lov_query = hr_api.g_varchar2) then
518: p_rec.variable_2_lov_query :=
519: ame_apt_shd.g_old_rec.variable_2_lov_query;
520: End If;
521: If (p_rec.variable_3_lov_query = hr_api.g_varchar2) then
522: p_rec.variable_3_lov_query :=
523: ame_apt_shd.g_old_rec.variable_3_lov_query;
524: End If;
525: If (p_rec.variable_4_lov_query = hr_api.g_varchar2) then

Line 525: If (p_rec.variable_4_lov_query = hr_api.g_varchar2) then

521: If (p_rec.variable_3_lov_query = hr_api.g_varchar2) then
522: p_rec.variable_3_lov_query :=
523: ame_apt_shd.g_old_rec.variable_3_lov_query;
524: End If;
525: If (p_rec.variable_4_lov_query = hr_api.g_varchar2) then
526: p_rec.variable_4_lov_query :=
527: ame_apt_shd.g_old_rec.variable_4_lov_query;
528: End If;
529: If (p_rec.variable_5_lov_query = hr_api.g_varchar2) then

Line 529: If (p_rec.variable_5_lov_query = hr_api.g_varchar2) then

525: If (p_rec.variable_4_lov_query = hr_api.g_varchar2) then
526: p_rec.variable_4_lov_query :=
527: ame_apt_shd.g_old_rec.variable_4_lov_query;
528: End If;
529: If (p_rec.variable_5_lov_query = hr_api.g_varchar2) then
530: p_rec.variable_5_lov_query :=
531: ame_apt_shd.g_old_rec.variable_5_lov_query;
532: End If;
533: If (p_rec.query_procedure = hr_api.g_varchar2) then

Line 533: If (p_rec.query_procedure = hr_api.g_varchar2) then

529: If (p_rec.variable_5_lov_query = hr_api.g_varchar2) then
530: p_rec.variable_5_lov_query :=
531: ame_apt_shd.g_old_rec.variable_5_lov_query;
532: End If;
533: If (p_rec.query_procedure = hr_api.g_varchar2) then
534: p_rec.query_procedure :=
535: ame_apt_shd.g_old_rec.query_procedure;
536: End If;
537: --

Line 635: ,p_orig_system in varchar2 default hr_api.g_varchar2

631: ,p_approver_type_id in number
632: ,p_start_date in date
633: ,p_end_date in date
634: ,p_object_version_number in out nocopy number
635: ,p_orig_system in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2

Line 636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2

632: ,p_start_date in date
633: ,p_end_date in date
634: ,p_object_version_number in out nocopy number
635: ,p_orig_system in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2

Line 637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2

633: ,p_end_date in date
634: ,p_object_version_number in out nocopy number
635: ,p_orig_system in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2

Line 638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2

634: ,p_object_version_number in out nocopy number
635: ,p_orig_system in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2

Line 639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2

635: ,p_orig_system in varchar2 default hr_api.g_varchar2
636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2

Line 640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2

636: ,p_query_variable_1_label in varchar2 default hr_api.g_varchar2
637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2

Line 641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2

637: ,p_query_variable_2_label in varchar2 default hr_api.g_varchar2
638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2

Line 642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2

638: ,p_query_variable_3_label in varchar2 default hr_api.g_varchar2
639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2

Line 643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2

639: ,p_query_variable_4_label in varchar2 default hr_api.g_varchar2
640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2
647: ) is

Line 644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2

640: ,p_query_variable_5_label in varchar2 default hr_api.g_varchar2
641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2
647: ) is
648: --

Line 645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2

641: ,p_variable_1_lov_query in varchar2 default hr_api.g_varchar2
642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2
647: ) is
648: --
649: l_rec ame_apt_shd.g_rec_type;

Line 646: ,p_query_procedure in varchar2 default hr_api.g_varchar2

642: ,p_variable_2_lov_query in varchar2 default hr_api.g_varchar2
643: ,p_variable_3_lov_query in varchar2 default hr_api.g_varchar2
644: ,p_variable_4_lov_query in varchar2 default hr_api.g_varchar2
645: ,p_variable_5_lov_query in varchar2 default hr_api.g_varchar2
646: ,p_query_procedure in varchar2 default hr_api.g_varchar2
647: ) is
648: --
649: l_rec ame_apt_shd.g_rec_type;
650: l_proc varchar2(72) := g_package||'upd';