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.
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: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
116: pay_cal_shd.constraint_error
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: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
116: pay_cal_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: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
121: pay_cal_shd.constraint_error
114: -- A check constraint has been violated
115: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
116: pay_cal_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: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
121: pay_cal_shd.constraint_error
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: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
121: pay_cal_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
125: Raise;
126: End dt_update_dml;
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: pay_cal_shd.upd_effective_end_date
248: ,p_validation_end_date => p_validation_end_date
249: ,p_object_version_number => l_dummy_version_number
250: );
251: --
252: If (p_datetrack_mode = hr_api.g_update_override) then
253: --
254: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
255: -- delete any future rows
256: --
438: );
439: --
440: exception
441: --
442: when hr_api.cannot_find_prog_unit then
443: --
444: hr_api.cannot_find_prog_unit_error
445: (p_module_name => 'PAY_COST_ALLOCATIONS_F'
446: ,p_hook_type => 'AU');
440: exception
441: --
442: when hr_api.cannot_find_prog_unit then
443: --
444: hr_api.cannot_find_prog_unit_error
445: (p_module_name => 'PAY_COST_ALLOCATIONS_F'
446: ,p_hook_type => 'AU');
447: --
448: end;
503: -- p_rec plsql record structure
504: -- to see if a system default is being used. If a system default
505: -- is being used then we must set to the 'current' argument value.
506: --
507: If (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: pay_cal_shd.g_old_rec.business_group_id;
510: End If;
511: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
507: If (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: pay_cal_shd.g_old_rec.business_group_id;
510: End If;
511: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
512: p_rec.cost_allocation_keyflex_id :=
513: pay_cal_shd.g_old_rec.cost_allocation_keyflex_id;
514: End If;
515: If (p_rec.assignment_id = hr_api.g_number) then
511: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
512: p_rec.cost_allocation_keyflex_id :=
513: pay_cal_shd.g_old_rec.cost_allocation_keyflex_id;
514: End If;
515: If (p_rec.assignment_id = hr_api.g_number) then
516: p_rec.assignment_id :=
517: pay_cal_shd.g_old_rec.assignment_id;
518: End If;
519: If (p_rec.proportion = hr_api.g_number) then
515: If (p_rec.assignment_id = hr_api.g_number) then
516: p_rec.assignment_id :=
517: pay_cal_shd.g_old_rec.assignment_id;
518: End If;
519: If (p_rec.proportion = hr_api.g_number) then
520: p_rec.proportion :=
521: pay_cal_shd.g_old_rec.proportion;
522: End If;
523: If (p_rec.request_id = hr_api.g_number) then
519: If (p_rec.proportion = hr_api.g_number) then
520: p_rec.proportion :=
521: pay_cal_shd.g_old_rec.proportion;
522: End If;
523: If (p_rec.request_id = hr_api.g_number) then
524: p_rec.request_id :=
525: pay_cal_shd.g_old_rec.request_id;
526: End If;
527: If (p_rec.program_application_id = hr_api.g_number) then
523: If (p_rec.request_id = hr_api.g_number) then
524: p_rec.request_id :=
525: pay_cal_shd.g_old_rec.request_id;
526: End If;
527: If (p_rec.program_application_id = hr_api.g_number) then
528: p_rec.program_application_id :=
529: pay_cal_shd.g_old_rec.program_application_id;
530: End If;
531: If (p_rec.program_id = hr_api.g_number) then
527: If (p_rec.program_application_id = hr_api.g_number) then
528: p_rec.program_application_id :=
529: pay_cal_shd.g_old_rec.program_application_id;
530: End If;
531: If (p_rec.program_id = hr_api.g_number) then
532: p_rec.program_id :=
533: pay_cal_shd.g_old_rec.program_id;
534: End If;
535: If (p_rec.program_update_date = hr_api.g_date) then
531: If (p_rec.program_id = hr_api.g_number) then
532: p_rec.program_id :=
533: pay_cal_shd.g_old_rec.program_id;
534: End If;
535: If (p_rec.program_update_date = hr_api.g_date) then
536: p_rec.program_update_date :=
537: pay_cal_shd.g_old_rec.program_update_date;
538: End If;
539: --
630: (p_effective_date in date
631: ,p_datetrack_mode in varchar2
632: ,p_cost_allocation_id in number
633: ,p_object_version_number in out nocopy number
634: ,p_business_group_id in number default hr_api.g_number
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
631: ,p_datetrack_mode in varchar2
632: ,p_cost_allocation_id in number
633: ,p_object_version_number in out nocopy number
634: ,p_business_group_id in number default hr_api.g_number
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
632: ,p_cost_allocation_id in number
633: ,p_object_version_number in out nocopy number
634: ,p_business_group_id in number default hr_api.g_number
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
633: ,p_object_version_number in out nocopy number
634: ,p_business_group_id in number default hr_api.g_number
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
641: ,p_program_update_date in date default hr_api.g_date
634: ,p_business_group_id in number default hr_api.g_number
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
641: ,p_program_update_date in date default hr_api.g_date
642: ,p_effective_start_date out nocopy date
635: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
641: ,p_program_update_date in date default hr_api.g_date
642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date
636: ,p_assignment_id in number default hr_api.g_number
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
641: ,p_program_update_date in date default hr_api.g_date
642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date
644: ) is
637: ,p_proportion in number default hr_api.g_number
638: ,p_request_id in number default hr_api.g_number
639: ,p_program_application_id in number default hr_api.g_number
640: ,p_program_id in number default hr_api.g_number
641: ,p_program_update_date in date default hr_api.g_date
642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date
644: ) is
645: --