[Home] [Help]
54: l_benefit_type pay_ie_social_benefits_f.benefit_type%type := p_benefit_type;
55: l_incident_id pay_ie_social_benefits_f.incident_id%type := p_incident_id;
56: --
57: begin
58: hr_utility.set_location('Entering:'|| l_proc, 10);
59: --
60: -- Issue a savepoint
61: --
62: savepoint create_ie_sb_details;
167: p_object_version_number := l_object_version_number;
168: p_effective_start_date := l_effective_start_date;
169: p_effective_end_date := l_effective_end_Date;
170: --
171: hr_utility.set_location(' Leaving:'||l_proc, 70);
172: exception
173: when hr_api.validate_enabled then
174: --
175: -- As the Validate_Enabled exception has been raised
182: -- when validation only mode is being used.)
183: --
184: p_social_benefit_id := null;
185: p_object_version_number := null;
186: hr_utility.set_location(' Leaving:'||l_proc, 80);
187: when others then
188: --
189: -- A validation or unexpected error has occured
190: --
192: p_social_benefit_id := null;
193: p_object_version_number := null;
194: p_effective_start_date := null;
195: p_effective_end_date := null;
196: hr_utility.set_location(' Leaving:'||l_proc, 90);
197: raise;
198: end create_ie_sb_details;
199: --
200: --
257: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
258: --
259: t_calculation_option pay_ie_social_benefits_f.calculation_option%type;
260: begin
261: hr_utility.set_location('Entering:'|| l_proc, 10);
262: --
263: -- Issue a savepoint
264: --
265: savepoint update_ie_sb_details;
412: p_object_version_number := l_object_version_number;
413: p_effective_start_date := l_effective_start_date;
414: p_effective_end_date := l_effective_end_Date;
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 70);
417: exception
418: when hr_api.validate_enabled then
419: --
420: -- As the Validate_Enabled exception has been raised
428: --
429: p_object_version_number := l_object_version_number;
430: p_effective_start_date := null;
431: p_effective_end_Date := null;
432: hr_utility.set_location(' Leaving:'||l_proc, 80);
433: when others then
434: --
435: -- A validation or unexpected error has occured
436: --
437: rollback to update_ie_sb_details;
438: p_object_version_number := l_object_version_number;
439: p_effective_start_date := null;
440: p_effective_end_date := null;
441: hr_utility.set_location(' Leaving:'||l_proc, 90);
442: raise;
443: end update_ie_sb_details;
444: --
445: -- ----------------------------------------------------------------------------
476: FROM per_all_assignments_f
477: WHERE assignment_id = l_assignment_id
478: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
479: begin
480: hr_utility.set_location('Entering:'|| l_proc, 10);
481: --
482: -- Issue a savepoint
483: --
484: savepoint delete_ie_sb_details;
554: p_object_version_number := l_object_version_number;
555: p_effective_start_date := l_effective_start_date;
556: p_effective_end_date := l_effective_end_Date;
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 70);
559: --
560: exception
561: when hr_api.validate_enabled then
562: --
572: p_object_version_number := l_object_version_number;
573: p_effective_start_date := null;
574: p_effective_end_Date := null;
575: --
576: hr_utility.set_location(' Leaving:'||l_proc, 80);
577: when others then
578: --
579: -- A validation or unexpected error has occured
580: --
581: rollback to delete_ie_sb_details;
582: p_object_version_number := l_object_version_number;
583: p_effective_start_date := null;
584: p_effective_end_date := null;
585: hr_utility.set_location(' Leaving:'||l_proc, 90);
586: raise;
587: end delete_ie_sb_details;
588: end pay_ie_sb_api;