DBA Data[Home] [Help]

APPS.AME_CNU_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 108: When hr_api.check_integrity_violated Then

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

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

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

Line 113: When hr_api.unique_integrity_violated Then

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

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

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

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

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

Line 410: when hr_api.cannot_find_prog_unit then

406: );
407: --
408: exception
409: --
410: when hr_api.cannot_find_prog_unit then
411: --
412: hr_api.cannot_find_prog_unit_error
413: (p_module_name => 'AME_CONDITION_USAGES'
414: ,p_hook_type => 'AU');

Line 412: hr_api.cannot_find_prog_unit_error

408: exception
409: --
410: when hr_api.cannot_find_prog_unit then
411: --
412: hr_api.cannot_find_prog_unit_error
413: (p_module_name => 'AME_CONDITION_USAGES'
414: ,p_hook_type => 'AU');
415: --
416: end;

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

471: -- p_rec plsql record structure
472: -- to see if a system default is being used. If a system default
473: -- is being used then we must set to the 'current' argument value.
474: --
475: If (p_rec.security_group_id = hr_api.g_number) then
476: p_rec.security_group_id :=
477: ame_cnu_shd.g_old_rec.security_group_id;
478: End If;
479: If (p_rec.start_date = hr_api.g_date) then

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

475: If (p_rec.security_group_id = hr_api.g_number) then
476: p_rec.security_group_id :=
477: ame_cnu_shd.g_old_rec.security_group_id;
478: End If;
479: If (p_rec.start_date = hr_api.g_date) then
480: p_rec.start_date := ame_cnu_shd.g_old_rec.start_date;
481: End If;
482: If (p_rec.end_date = hr_api.g_date) then
483: p_rec.end_date := ame_cnu_shd.g_old_rec.end_date;

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

478: End If;
479: If (p_rec.start_date = hr_api.g_date) then
480: p_rec.start_date := ame_cnu_shd.g_old_rec.start_date;
481: End If;
482: If (p_rec.end_date = hr_api.g_date) then
483: p_rec.end_date := ame_cnu_shd.g_old_rec.end_date;
484: End If;
485: --
486: End convert_defs;

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

505: --
506: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
507: -- set the start and end dates if not set
508: if p_rec.start_date is null then
509: p_rec.start_date := hr_api.g_date;
510: end if;
511: if p_rec.end_date is null then
512: p_rec.end_date := hr_api.g_date;
513: end if;

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

508: if p_rec.start_date is null then
509: p_rec.start_date := hr_api.g_date;
510: end if;
511: if p_rec.end_date is null then
512: p_rec.end_date := hr_api.g_date;
513: end if;
514: --
515: -- We must lock the row which we need to update.
516: --

Line 606: ,p_security_group_id in number default hr_api.g_number

602: ,p_datetrack_mode in varchar2
603: ,p_rule_id in number
604: ,p_condition_id in number
605: ,p_object_version_number in out nocopy number
606: ,p_security_group_id in number default hr_api.g_number
607: ,p_start_date in out nocopy date
608: ,p_end_date in out nocopy date
609: ) is
610: --