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_CON_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 113: When hr_api.check_integrity_violated Then

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

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

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

Line 118: When hr_api.unique_integrity_violated Then

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

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

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

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

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

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

246: ,p_new_end_date => p_validation_start_date
247: ,p_object_version_number => l_dummy_version_number
248: );
249: --
250: If (p_datetrack_mode = hr_api.g_update_override) then
251: --
252: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
253: -- delete any future rows
254: --

Line 444: when hr_api.cannot_find_prog_unit then

440: );
441: --
442: exception
443: --
444: when hr_api.cannot_find_prog_unit then
445: --
446: hr_api.cannot_find_prog_unit_error
447: (p_module_name => 'AME_CONDITIONS'
448: ,p_hook_type => 'AU');

Line 446: hr_api.cannot_find_prog_unit_error

442: exception
443: --
444: when hr_api.cannot_find_prog_unit then
445: --
446: hr_api.cannot_find_prog_unit_error
447: (p_module_name => 'AME_CONDITIONS'
448: ,p_hook_type => 'AU');
449: --
450: end;

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

505: -- p_rec plsql record structure
506: -- to see if a system default is being used. If a system default
507: -- is being used then we must set to the 'current' argument value.
508: --
509: If (p_rec.condition_type = hr_api.g_varchar2) then
510: p_rec.condition_type :=
511: ame_con_shd.g_old_rec.condition_type;
512: End If;
513: If (p_rec.attribute_id = hr_api.g_number) then

Line 513: If (p_rec.attribute_id = hr_api.g_number) then

509: If (p_rec.condition_type = hr_api.g_varchar2) then
510: p_rec.condition_type :=
511: ame_con_shd.g_old_rec.condition_type;
512: End If;
513: If (p_rec.attribute_id = hr_api.g_number) then
514: p_rec.attribute_id :=
515: ame_con_shd.g_old_rec.attribute_id;
516: End If;
517: If (p_rec.parameter_one = hr_api.g_varchar2) then

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

513: If (p_rec.attribute_id = hr_api.g_number) then
514: p_rec.attribute_id :=
515: ame_con_shd.g_old_rec.attribute_id;
516: End If;
517: If (p_rec.parameter_one = hr_api.g_varchar2) then
518: p_rec.parameter_one :=
519: ame_con_shd.g_old_rec.parameter_one;
520: End If;
521: If (p_rec.parameter_two = hr_api.g_varchar2) then

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

517: If (p_rec.parameter_one = hr_api.g_varchar2) then
518: p_rec.parameter_one :=
519: ame_con_shd.g_old_rec.parameter_one;
520: End If;
521: If (p_rec.parameter_two = hr_api.g_varchar2) then
522: p_rec.parameter_two :=
523: ame_con_shd.g_old_rec.parameter_two;
524: End If;
525: If (p_rec.parameter_three = hr_api.g_varchar2) then

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

521: If (p_rec.parameter_two = hr_api.g_varchar2) then
522: p_rec.parameter_two :=
523: ame_con_shd.g_old_rec.parameter_two;
524: End If;
525: If (p_rec.parameter_three = hr_api.g_varchar2) then
526: p_rec.parameter_three :=
527: ame_con_shd.g_old_rec.parameter_three;
528: End If;
529: If (p_rec.include_lower_limit = hr_api.g_varchar2) then

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

525: If (p_rec.parameter_three = hr_api.g_varchar2) then
526: p_rec.parameter_three :=
527: ame_con_shd.g_old_rec.parameter_three;
528: End If;
529: If (p_rec.include_lower_limit = hr_api.g_varchar2) then
530: p_rec.include_lower_limit :=
531: ame_con_shd.g_old_rec.include_lower_limit;
532: End If;
533: If (p_rec.include_upper_limit = hr_api.g_varchar2) then

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

529: If (p_rec.include_lower_limit = hr_api.g_varchar2) then
530: p_rec.include_lower_limit :=
531: ame_con_shd.g_old_rec.include_lower_limit;
532: End If;
533: If (p_rec.include_upper_limit = hr_api.g_varchar2) then
534: p_rec.include_upper_limit :=
535: ame_con_shd.g_old_rec.include_upper_limit;
536: End If;
537: If (p_rec.security_group_id = hr_api.g_number) then

Line 537: If (p_rec.security_group_id = hr_api.g_number) then

533: If (p_rec.include_upper_limit = hr_api.g_varchar2) then
534: p_rec.include_upper_limit :=
535: ame_con_shd.g_old_rec.include_upper_limit;
536: End If;
537: If (p_rec.security_group_id = hr_api.g_number) then
538: p_rec.security_group_id :=
539: ame_con_shd.g_old_rec.security_group_id;
540: End If;
541: If (p_rec.condition_key = hr_api.g_varchar2) then

Line 541: If (p_rec.condition_key = hr_api.g_varchar2) then

537: If (p_rec.security_group_id = hr_api.g_number) then
538: p_rec.security_group_id :=
539: ame_con_shd.g_old_rec.security_group_id;
540: End If;
541: If (p_rec.condition_key = hr_api.g_varchar2) then
542: p_rec.condition_key :=
543: ame_con_shd.g_old_rec.condition_key;
544: End If;
545: --

Line 640: ,p_condition_type in varchar2 default hr_api.g_varchar2

636: (p_effective_date in date
637: ,p_datetrack_mode in varchar2
638: ,p_condition_id in number
639: ,p_object_version_number in out nocopy number
640: ,p_condition_type in varchar2 default hr_api.g_varchar2
641: ,p_attribute_id in number default hr_api.g_number
642: ,p_condition_key in varchar2 default hr_api.g_varchar2
643: ,p_parameter_one in varchar2 default hr_api.g_varchar2
644: ,p_parameter_two in varchar2 default hr_api.g_varchar2

Line 641: ,p_attribute_id in number default hr_api.g_number

637: ,p_datetrack_mode in varchar2
638: ,p_condition_id in number
639: ,p_object_version_number in out nocopy number
640: ,p_condition_type in varchar2 default hr_api.g_varchar2
641: ,p_attribute_id in number default hr_api.g_number
642: ,p_condition_key in varchar2 default hr_api.g_varchar2
643: ,p_parameter_one in varchar2 default hr_api.g_varchar2
644: ,p_parameter_two in varchar2 default hr_api.g_varchar2
645: ,p_parameter_three in varchar2 default hr_api.g_varchar2

Line 642: ,p_condition_key in varchar2 default hr_api.g_varchar2

638: ,p_condition_id in number
639: ,p_object_version_number in out nocopy number
640: ,p_condition_type in varchar2 default hr_api.g_varchar2
641: ,p_attribute_id in number default hr_api.g_number
642: ,p_condition_key in varchar2 default hr_api.g_varchar2
643: ,p_parameter_one in varchar2 default hr_api.g_varchar2
644: ,p_parameter_two in varchar2 default hr_api.g_varchar2
645: ,p_parameter_three in varchar2 default hr_api.g_varchar2
646: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2

Line 643: ,p_parameter_one in varchar2 default hr_api.g_varchar2

639: ,p_object_version_number in out nocopy number
640: ,p_condition_type in varchar2 default hr_api.g_varchar2
641: ,p_attribute_id in number default hr_api.g_number
642: ,p_condition_key in varchar2 default hr_api.g_varchar2
643: ,p_parameter_one in varchar2 default hr_api.g_varchar2
644: ,p_parameter_two in varchar2 default hr_api.g_varchar2
645: ,p_parameter_three in varchar2 default hr_api.g_varchar2
646: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
647: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2

Line 644: ,p_parameter_two in varchar2 default hr_api.g_varchar2

640: ,p_condition_type in varchar2 default hr_api.g_varchar2
641: ,p_attribute_id in number default hr_api.g_number
642: ,p_condition_key in varchar2 default hr_api.g_varchar2
643: ,p_parameter_one in varchar2 default hr_api.g_varchar2
644: ,p_parameter_two in varchar2 default hr_api.g_varchar2
645: ,p_parameter_three in varchar2 default hr_api.g_varchar2
646: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
647: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
648: ,p_security_group_id in number default hr_api.g_number

Line 645: ,p_parameter_three in varchar2 default hr_api.g_varchar2

641: ,p_attribute_id in number default hr_api.g_number
642: ,p_condition_key in varchar2 default hr_api.g_varchar2
643: ,p_parameter_one in varchar2 default hr_api.g_varchar2
644: ,p_parameter_two in varchar2 default hr_api.g_varchar2
645: ,p_parameter_three in varchar2 default hr_api.g_varchar2
646: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
647: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
648: ,p_security_group_id in number default hr_api.g_number
649: ,p_start_date out nocopy date

Line 646: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2

642: ,p_condition_key in varchar2 default hr_api.g_varchar2
643: ,p_parameter_one in varchar2 default hr_api.g_varchar2
644: ,p_parameter_two in varchar2 default hr_api.g_varchar2
645: ,p_parameter_three in varchar2 default hr_api.g_varchar2
646: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
647: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
648: ,p_security_group_id in number default hr_api.g_number
649: ,p_start_date out nocopy date
650: ,p_end_date out nocopy date

Line 647: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2

643: ,p_parameter_one in varchar2 default hr_api.g_varchar2
644: ,p_parameter_two in varchar2 default hr_api.g_varchar2
645: ,p_parameter_three in varchar2 default hr_api.g_varchar2
646: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
647: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
648: ,p_security_group_id in number default hr_api.g_number
649: ,p_start_date out nocopy date
650: ,p_end_date out nocopy date
651: ) is

Line 648: ,p_security_group_id in number default hr_api.g_number

644: ,p_parameter_two in varchar2 default hr_api.g_varchar2
645: ,p_parameter_three in varchar2 default hr_api.g_varchar2
646: ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
647: ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
648: ,p_security_group_id in number default hr_api.g_number
649: ,p_start_date out nocopy date
650: ,p_end_date out nocopy date
651: ) is
652: --