DBA Data[Home] [Help]

APPS.AME_ACF_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_acf_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_acf_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_acf_shd.constraint_error

Line 115: When hr_api.unique_integrity_violated Then

111: -- A check constraint has been violated
112: --
113: ame_acf_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_acf_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_acf_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_acf_shd.upd_end_date

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

246: ,p_validation_end_date => p_validation_end_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 422: when hr_api.cannot_find_prog_unit then

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

Line 424: hr_api.cannot_find_prog_unit_error

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

Line 487: If (p_rec.voting_regime = hr_api.g_varchar2) then

483: -- p_rec plsql record structure
484: -- to see if a system default is being used. If a system default
485: -- is being used then we must set to the 'current' argument value.
486: --
487: If (p_rec.voting_regime = hr_api.g_varchar2) then
488: p_rec.voting_regime :=
489: ame_acf_shd.g_old_rec.voting_regime;
490: End If;
491: If (p_rec.order_number = hr_api.g_number) then

Line 491: If (p_rec.order_number = hr_api.g_number) then

487: If (p_rec.voting_regime = hr_api.g_varchar2) then
488: p_rec.voting_regime :=
489: ame_acf_shd.g_old_rec.voting_regime;
490: End If;
491: If (p_rec.order_number = hr_api.g_number) then
492: p_rec.order_number :=
493: ame_acf_shd.g_old_rec.order_number;
494: End If;
495: If (p_rec.chain_ordering_mode = hr_api.g_varchar2) then

Line 495: If (p_rec.chain_ordering_mode = hr_api.g_varchar2) then

491: If (p_rec.order_number = hr_api.g_number) then
492: p_rec.order_number :=
493: ame_acf_shd.g_old_rec.order_number;
494: End If;
495: If (p_rec.chain_ordering_mode = hr_api.g_varchar2) then
496: p_rec.chain_ordering_mode :=
497: ame_acf_shd.g_old_rec.chain_ordering_mode;
498: End If;
499: --

Line 596: ,p_order_number in number default hr_api.g_number

592: ,p_datetrack_mode in varchar2
593: ,p_application_id in number
594: ,p_action_type_id in number
595: ,p_object_version_number in out nocopy number
596: ,p_order_number in number default hr_api.g_number
597: ,p_voting_regime in varchar2 default hr_api.g_varchar2
598: ,p_chain_ordering_mode in varchar2 default hr_api.g_varchar2
599: ,p_start_date out nocopy date
600: ,p_end_date out nocopy date

Line 597: ,p_voting_regime in varchar2 default hr_api.g_varchar2

593: ,p_application_id in number
594: ,p_action_type_id in number
595: ,p_object_version_number in out nocopy number
596: ,p_order_number in number default hr_api.g_number
597: ,p_voting_regime in varchar2 default hr_api.g_varchar2
598: ,p_chain_ordering_mode in varchar2 default hr_api.g_varchar2
599: ,p_start_date out nocopy date
600: ,p_end_date out nocopy date
601: ) is

Line 598: ,p_chain_ordering_mode in varchar2 default hr_api.g_varchar2

594: ,p_action_type_id in number
595: ,p_object_version_number in out nocopy number
596: ,p_order_number in number default hr_api.g_number
597: ,p_voting_regime in varchar2 default hr_api.g_varchar2
598: ,p_chain_ordering_mode in varchar2 default hr_api.g_varchar2
599: ,p_start_date out nocopy date
600: ,p_end_date out nocopy date
601: ) is
602: --