1: Package Body ben_eligy_criteria_api as
2: /* $Header: beeglapi.pkb 120.1 2005/07/29 09:06 rbingi noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: beeglapi.pkb 120.1 2005/07/29 09:06 rbingi noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_eligy_criteria_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_eligy_criteria >----------------------|
10: -- ----------------------------------------------------------------------------
78: ) is
79: --
80: -- Declare cursors and local variables
81: --
82: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%TYPE;
83: l_proc varchar2(72) := g_package||'create_eligy_criteria';
84: l_object_version_number ben_eligy_criteria.object_version_number%TYPE;
85: --
86: begin
80: -- Declare cursors and local variables
81: --
82: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%TYPE;
83: l_proc varchar2(72) := g_package||'create_eligy_criteria';
84: l_object_version_number ben_eligy_criteria.object_version_number%TYPE;
85: --
86: begin
87: --
88: hr_utility.set_location('Entering:'|| l_proc, 10);
98: begin
99: --
100: -- Start of API User Hook for the before hook of create_eligy_criteria
101: --
102: ben_eligy_criteria_bk1.create_eligy_criteria_b
103: (
104: p_name => p_name
105: ,p_short_code => p_short_code
106: ,p_description => p_description
245: begin
246: --
247: -- Start of API User Hook for the after hook of create_eligy_criteria
248: --
249: ben_eligy_criteria_bk1.create_eligy_criteria_a
250: (
251: p_eligy_criteria_id => l_eligy_criteria_id
252: ,p_name => p_name
253: ,p_short_code => p_short_code
438: ) is
439: --
440: -- Declare cursors and local variables
441: --
442: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%TYPE;
443: l_proc varchar2(72) := g_package||'update_eligy_criteria';
444: l_object_version_number ben_eligy_criteria.object_version_number%TYPE;
445: --
446: begin
440: -- Declare cursors and local variables
441: --
442: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%TYPE;
443: l_proc varchar2(72) := g_package||'update_eligy_criteria';
444: l_object_version_number ben_eligy_criteria.object_version_number%TYPE;
445: --
446: begin
447:
448: ----hr_utility.trace_on(null,'TRACE-file');
464: begin
465: --
466: -- Start of API User Hook for the before hook of update_eligy_criteria
467: --
468: ben_eligy_criteria_bk2.update_eligy_criteria_b
469: (
470: p_eligy_criteria_id => l_eligy_criteria_id
471: ,p_name => p_name
472: ,p_short_code => p_short_code
612: begin
613: --
614: -- Start of API User Hook for the after hook of update_eligy_criteria
615: --
616: ben_eligy_criteria_bk2.update_eligy_criteria_a
617: (
618: p_eligy_criteria_id => l_eligy_criteria_id
619: ,p_name => p_name
620: ,p_short_code => p_short_code
740: --
741: -- Declare cursors and local variables
742: --
743: l_proc varchar2(72) := g_package||'update_eligy_criteria';
744: l_object_version_number ben_eligy_criteria.object_version_number%TYPE;
745: --
746: begin
747: --
748: hr_utility.set_location('Entering:'|| l_proc, 10);
761: begin
762: --
763: -- Start of API User Hook for the before hook of delete_eligy_criteria
764: --
765: ben_eligy_criteria_bk3.delete_eligy_criteria_b
766: (
767: p_eligy_criteria_id => p_eligy_criteria_id
768: ,p_object_version_number => p_object_version_number
769: ,p_effective_date => trunc(p_effective_date)
789: begin
790: --
791: -- Start of API User Hook for the after hook of delete_eligy_criteria
792: --
793: ben_eligy_criteria_bk3.delete_eligy_criteria_a
794: (
795: p_eligy_criteria_id => p_eligy_criteria_id
796: ,p_object_version_number => l_object_version_number
797: ,p_effective_date => trunc(p_effective_date)
868: hr_utility.set_location(' Leaving:'||l_proc, 20);
869: --
870: end lck;
871: --
872: end ben_eligy_criteria_api;