1: Package Body ben_enrt_rt_ctfn_api as
2: /* $Header: beercapi.pkb 115.2 2002/12/16 09:36:44 hnarayan noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: beercapi.pkb 115.2 2002/12/16 09:36:44 hnarayan noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_enrt_rt_ctfn_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_enrt_rt_ctfn >----------------------|
10: -- ----------------------------------------------------------------------------
56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_enrt_rt_ctfn_id ben_enrt_rt_ctfn.enrt_rt_ctfn_id%TYPE;
61: l_proc varchar2(72) := g_package||'create_enrt_rt_ctfn';
62: l_object_version_number ben_enrt_rt_ctfn.object_version_number%TYPE;
63: --
64: begin
58: -- Declare cursors and local variables
59: --
60: l_enrt_rt_ctfn_id ben_enrt_rt_ctfn.enrt_rt_ctfn_id%TYPE;
61: l_proc varchar2(72) := g_package||'create_enrt_rt_ctfn';
62: l_object_version_number ben_enrt_rt_ctfn.object_version_number%TYPE;
63: --
64: begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);
76: begin
77: --
78: -- Start of API User Hook for the before hook of create_enrt_rt_ctfn
79: --
80: ben_enrt_rt_ctfn_bk1.create_enrt_rt_ctfn_b
81: (
82: p_enrt_ctfn_typ_cd => p_enrt_ctfn_typ_cd
83: ,p_rqd_flag => p_rqd_flag
84: ,p_enrt_rt_id => p_enrt_rt_id
181: begin
182: --
183: -- Start of API User Hook for the after hook of create_enrt_rt_ctfn
184: --
185: ben_enrt_rt_ctfn_bk1.create_enrt_rt_ctfn_a
186: (
187: p_enrt_rt_ctfn_id => l_enrt_rt_ctfn_id
188: ,p_enrt_ctfn_typ_cd => p_enrt_ctfn_typ_cd
189: ,p_rqd_flag => p_rqd_flag
332: --
333: -- Declare cursors and local variables
334: --
335: l_proc varchar2(72) := g_package||'update_enrt_rt_ctfn';
336: l_object_version_number ben_enrt_rt_ctfn.object_version_number%TYPE;
337: --
338: begin
339: --
340: hr_utility.set_location('Entering:'|| l_proc, 10);
352: begin
353: --
354: -- Start of API User Hook for the before hook of update_enrt_rt_ctfn
355: --
356: ben_enrt_rt_ctfn_bk2.update_enrt_rt_ctfn_b
357: (
358: p_enrt_rt_ctfn_id => p_enrt_rt_ctfn_id
359: ,p_enrt_ctfn_typ_cd => p_enrt_ctfn_typ_cd
360: ,p_rqd_flag => p_rqd_flag
458: begin
459: --
460: -- Start of API User Hook for the after hook of update_enrt_rt_ctfn
461: --
462: ben_enrt_rt_ctfn_bk2.update_enrt_rt_ctfn_a
463: (
464: p_enrt_rt_ctfn_id => p_enrt_rt_ctfn_id
465: ,p_enrt_ctfn_typ_cd => p_enrt_ctfn_typ_cd
466: ,p_rqd_flag => p_rqd_flag
565: --
566: -- Declare cursors and local variables
567: --
568: l_proc varchar2(72) := g_package||'update_enrt_rt_ctfn';
569: l_object_version_number ben_enrt_rt_ctfn.object_version_number%TYPE;
570: --
571: begin
572: --
573: hr_utility.set_location('Entering:'|| l_proc, 10);
586: begin
587: --
588: -- Start of API User Hook for the before hook of delete_enrt_rt_ctfn
589: --
590: ben_enrt_rt_ctfn_bk3.delete_enrt_rt_ctfn_b
591: (
592: p_enrt_rt_ctfn_id => p_enrt_rt_ctfn_id
593: ,p_object_version_number => p_object_version_number
594: ,p_effective_date => trunc(p_effective_date)
614: begin
615: --
616: -- Start of API User Hook for the after hook of delete_enrt_rt_ctfn
617: --
618: ben_enrt_rt_ctfn_bk3.delete_enrt_rt_ctfn_a
619: (
620: p_enrt_rt_ctfn_id => p_enrt_rt_ctfn_id
621: ,p_object_version_number => l_object_version_number
622: ,p_effective_date => trunc(p_effective_date)
693: hr_utility.set_location(' Leaving:'||l_proc, 70);
694: --
695: end lck;
696: --
697: end ben_enrt_rt_ctfn_api;