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_RUL_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 110: When hr_api.check_integrity_violated Then

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

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

110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: ame_rul_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --
118: ame_rul_shd.constraint_error

Line 115: When hr_api.unique_integrity_violated Then

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

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

115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --
118: ame_rul_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: --
122: Raise;
123: End dt_update_dml;

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

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

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

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

Line 429: when hr_api.cannot_find_prog_unit then

425: );
426: --
427: exception
428: --
429: when hr_api.cannot_find_prog_unit then
430: --
431: hr_api.cannot_find_prog_unit_error
432: (p_module_name => 'AME_RULES'
433: ,p_hook_type => 'AU');

Line 431: hr_api.cannot_find_prog_unit_error

427: exception
428: --
429: when hr_api.cannot_find_prog_unit then
430: --
431: hr_api.cannot_find_prog_unit_error
432: (p_module_name => 'AME_RULES'
433: ,p_hook_type => 'AU');
434: --
435: end;

Line 494: If (p_rec.rule_type = hr_api.g_number) then

490: -- p_rec plsql record structure
491: -- to see if a system default is being used. If a system default
492: -- is being used then we must set to the 'current' argument value.
493: --
494: If (p_rec.rule_type = hr_api.g_number) then
495: p_rec.rule_type :=
496: ame_rul_shd.g_old_rec.rule_type;
497: End If;
498: If (p_rec.action_id = hr_api.g_number) then

Line 498: If (p_rec.action_id = hr_api.g_number) then

494: If (p_rec.rule_type = hr_api.g_number) then
495: p_rec.rule_type :=
496: ame_rul_shd.g_old_rec.rule_type;
497: End If;
498: If (p_rec.action_id = hr_api.g_number) then
499: p_rec.action_id :=
500: ame_rul_shd.g_old_rec.action_id;
501: End If;
502: If (p_rec.description = hr_api.g_varchar2) then

Line 502: If (p_rec.description = hr_api.g_varchar2) then

498: If (p_rec.action_id = hr_api.g_number) then
499: p_rec.action_id :=
500: ame_rul_shd.g_old_rec.action_id;
501: End If;
502: If (p_rec.description = hr_api.g_varchar2) then
503: p_rec.description :=
504: ame_rul_shd.g_old_rec.description;
505: End If;
506: If (p_rec.security_group_id = hr_api.g_number) then

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

502: If (p_rec.description = hr_api.g_varchar2) then
503: p_rec.description :=
504: ame_rul_shd.g_old_rec.description;
505: End If;
506: If (p_rec.security_group_id = hr_api.g_number) then
507: p_rec.security_group_id :=
508: ame_rul_shd.g_old_rec.security_group_id;
509: End If;
510: If (p_rec.rule_key = hr_api.g_varchar2) then

Line 510: If (p_rec.rule_key = hr_api.g_varchar2) then

506: If (p_rec.security_group_id = hr_api.g_number) then
507: p_rec.security_group_id :=
508: ame_rul_shd.g_old_rec.security_group_id;
509: End If;
510: If (p_rec.rule_key = hr_api.g_varchar2) then
511: p_rec.rule_key :=
512: ame_rul_shd.g_old_rec.rule_key;
513: End If;
514: If (p_rec.item_class_id = hr_api.g_number) then

Line 514: If (p_rec.item_class_id = hr_api.g_number) then

510: If (p_rec.rule_key = hr_api.g_varchar2) then
511: p_rec.rule_key :=
512: ame_rul_shd.g_old_rec.rule_key;
513: End If;
514: If (p_rec.item_class_id = hr_api.g_number) then
515: p_rec.item_class_id :=
516: ame_rul_shd.g_old_rec.item_class_id;
517: End If;
518: If (p_rec.start_date = hr_api.g_date) then

Line 518: If (p_rec.start_date = hr_api.g_date) then

514: If (p_rec.item_class_id = hr_api.g_number) then
515: p_rec.item_class_id :=
516: ame_rul_shd.g_old_rec.item_class_id;
517: End If;
518: If (p_rec.start_date = hr_api.g_date) then
519: p_rec.start_date :=
520: ame_rul_shd.g_old_rec.start_date;
521: End If;
522: If (p_rec.end_date = hr_api.g_date) then

Line 522: If (p_rec.end_date = hr_api.g_date) then

518: If (p_rec.start_date = hr_api.g_date) then
519: p_rec.start_date :=
520: ame_rul_shd.g_old_rec.start_date;
521: End If;
522: If (p_rec.end_date = hr_api.g_date) then
523: p_rec.end_date :=
524: ame_rul_shd.g_old_rec.end_date;
525: End If;
526:

Line 551: p_rec.start_date := hr_api.g_date;

547: --
548: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
549: -- set the start and end dates if not set
550: if p_rec.start_date is null then
551: p_rec.start_date := hr_api.g_date;
552: end if;
553: if p_rec.end_date is null then
554: p_rec.end_date := hr_api.g_date;
555: end if;

Line 554: p_rec.end_date := hr_api.g_date;

550: if p_rec.start_date is null then
551: p_rec.start_date := hr_api.g_date;
552: end if;
553: if p_rec.end_date is null then
554: p_rec.end_date := hr_api.g_date;
555: end if;
556: --
557: -- We must lock the row which we need to update.
558: --

Line 650: ,p_rule_type in number default hr_api.g_number

646: (p_effective_date in date
647: ,p_datetrack_mode in varchar2
648: ,p_rule_id in number
649: ,p_object_version_number in out nocopy number
650: ,p_rule_type in number default hr_api.g_number
651: ,p_description in varchar2 default hr_api.g_varchar2
652: ,p_rule_key in varchar2 default hr_api.g_varchar2
653: ,p_action_id in number default hr_api.g_number
654: ,p_security_group_id in number default hr_api.g_number

Line 651: ,p_description in varchar2 default hr_api.g_varchar2

647: ,p_datetrack_mode in varchar2
648: ,p_rule_id in number
649: ,p_object_version_number in out nocopy number
650: ,p_rule_type in number default hr_api.g_number
651: ,p_description in varchar2 default hr_api.g_varchar2
652: ,p_rule_key in varchar2 default hr_api.g_varchar2
653: ,p_action_id in number default hr_api.g_number
654: ,p_security_group_id in number default hr_api.g_number
655: ,p_item_class_id in number default hr_api.g_number

Line 652: ,p_rule_key in varchar2 default hr_api.g_varchar2

648: ,p_rule_id in number
649: ,p_object_version_number in out nocopy number
650: ,p_rule_type in number default hr_api.g_number
651: ,p_description in varchar2 default hr_api.g_varchar2
652: ,p_rule_key in varchar2 default hr_api.g_varchar2
653: ,p_action_id in number default hr_api.g_number
654: ,p_security_group_id in number default hr_api.g_number
655: ,p_item_class_id in number default hr_api.g_number
656: ,p_start_date in out nocopy date

Line 653: ,p_action_id in number default hr_api.g_number

649: ,p_object_version_number in out nocopy number
650: ,p_rule_type in number default hr_api.g_number
651: ,p_description in varchar2 default hr_api.g_varchar2
652: ,p_rule_key in varchar2 default hr_api.g_varchar2
653: ,p_action_id in number default hr_api.g_number
654: ,p_security_group_id in number default hr_api.g_number
655: ,p_item_class_id in number default hr_api.g_number
656: ,p_start_date in out nocopy date
657: ,p_end_date in out nocopy date

Line 654: ,p_security_group_id in number default hr_api.g_number

650: ,p_rule_type in number default hr_api.g_number
651: ,p_description in varchar2 default hr_api.g_varchar2
652: ,p_rule_key in varchar2 default hr_api.g_varchar2
653: ,p_action_id in number default hr_api.g_number
654: ,p_security_group_id in number default hr_api.g_number
655: ,p_item_class_id in number default hr_api.g_number
656: ,p_start_date in out nocopy date
657: ,p_end_date in out nocopy date
658: ) is

Line 655: ,p_item_class_id in number default hr_api.g_number

651: ,p_description in varchar2 default hr_api.g_varchar2
652: ,p_rule_key in varchar2 default hr_api.g_varchar2
653: ,p_action_id in number default hr_api.g_number
654: ,p_security_group_id in number default hr_api.g_number
655: ,p_item_class_id in number default hr_api.g_number
656: ,p_start_date in out nocopy date
657: ,p_end_date in out nocopy date
658: ) is
659: --