DBA Data[Home] [Help]

APPS.BEN_BEO_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 109: When hr_api.check_integrity_violated Then

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

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

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

Line 114: When hr_api.unique_integrity_violated Then

110: -- A check constraint has been violated
111: --
112: ben_beo_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --
117: ben_beo_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.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --
117: ben_beo_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: --
121: Raise;
122: End dt_update_dml;

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

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

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

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

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 => 'BEN_ELIG_OBJ_F'
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 => 'BEN_ELIG_OBJ_F'
426: ,p_hook_type => 'AU');
427: --
428: end;

Line 487: If (p_rec.table_name = 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.table_name = hr_api.g_varchar2) then
488: p_rec.table_name :=
489: ben_beo_shd.g_old_rec.table_name;
490: End If;
491: If (p_rec.column_name = hr_api.g_varchar2) then

Line 491: If (p_rec.column_name = hr_api.g_varchar2) then

487: If (p_rec.table_name = hr_api.g_varchar2) then
488: p_rec.table_name :=
489: ben_beo_shd.g_old_rec.table_name;
490: End If;
491: If (p_rec.column_name = hr_api.g_varchar2) then
492: p_rec.column_name :=
493: ben_beo_shd.g_old_rec.column_name;
494: End If;
495: If (p_rec.column_value = hr_api.g_varchar2) then

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

491: If (p_rec.column_name = hr_api.g_varchar2) then
492: p_rec.column_name :=
493: ben_beo_shd.g_old_rec.column_name;
494: End If;
495: If (p_rec.column_value = hr_api.g_varchar2) then
496: p_rec.column_value :=
497: ben_beo_shd.g_old_rec.column_value;
498: End If;
499: If (p_rec.business_group_id = hr_api.g_number) then

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

495: If (p_rec.column_value = hr_api.g_varchar2) then
496: p_rec.column_value :=
497: ben_beo_shd.g_old_rec.column_value;
498: End If;
499: If (p_rec.business_group_id = hr_api.g_number) then
500: p_rec.business_group_id :=
501: ben_beo_shd.g_old_rec.business_group_id;
502: End If;
503: --

Line 598: ,p_table_name in varchar2 default hr_api.g_varchar2

594: (p_effective_date in date
595: ,p_datetrack_mode in varchar2
596: ,p_elig_obj_id in number
597: ,p_object_version_number in out nocopy number
598: ,p_table_name in varchar2 default hr_api.g_varchar2
599: ,p_column_name in varchar2 default hr_api.g_varchar2
600: ,p_column_value in varchar2 default hr_api.g_varchar2
601: ,p_business_group_id in number default hr_api.g_number
602: ,p_effective_start_date out nocopy date

Line 599: ,p_column_name in varchar2 default hr_api.g_varchar2

595: ,p_datetrack_mode in varchar2
596: ,p_elig_obj_id in number
597: ,p_object_version_number in out nocopy number
598: ,p_table_name in varchar2 default hr_api.g_varchar2
599: ,p_column_name in varchar2 default hr_api.g_varchar2
600: ,p_column_value in varchar2 default hr_api.g_varchar2
601: ,p_business_group_id in number default hr_api.g_number
602: ,p_effective_start_date out nocopy date
603: ,p_effective_end_date out nocopy date

Line 600: ,p_column_value in varchar2 default hr_api.g_varchar2

596: ,p_elig_obj_id in number
597: ,p_object_version_number in out nocopy number
598: ,p_table_name in varchar2 default hr_api.g_varchar2
599: ,p_column_name in varchar2 default hr_api.g_varchar2
600: ,p_column_value in varchar2 default hr_api.g_varchar2
601: ,p_business_group_id in number default hr_api.g_number
602: ,p_effective_start_date out nocopy date
603: ,p_effective_end_date out nocopy date
604: ) is

Line 601: ,p_business_group_id in number default hr_api.g_number

597: ,p_object_version_number in out nocopy number
598: ,p_table_name in varchar2 default hr_api.g_varchar2
599: ,p_column_name in varchar2 default hr_api.g_varchar2
600: ,p_column_value in varchar2 default hr_api.g_varchar2
601: ,p_business_group_id in number default hr_api.g_number
602: ,p_effective_start_date out nocopy date
603: ,p_effective_end_date out nocopy date
604: ) is
605: --