56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_cntnu_prtn_ctfn_typ_id ben_cntnu_prtn_ctfn_typ_f.cntnu_prtn_ctfn_typ_id%TYPE;
61: l_effective_start_date ben_cntnu_prtn_ctfn_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_cntnu_prtn_ctfn_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_CNTNU_PRTN_CTFN_TYP';
64: l_object_version_number ben_cntnu_prtn_ctfn_typ_f.object_version_number%TYPE;
57: --
58: -- Declare cursors and local variables
59: --
60: l_cntnu_prtn_ctfn_typ_id ben_cntnu_prtn_ctfn_typ_f.cntnu_prtn_ctfn_typ_id%TYPE;
61: l_effective_start_date ben_cntnu_prtn_ctfn_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_cntnu_prtn_ctfn_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_CNTNU_PRTN_CTFN_TYP';
64: l_object_version_number ben_cntnu_prtn_ctfn_typ_f.object_version_number%TYPE;
65: --
58: -- Declare cursors and local variables
59: --
60: l_cntnu_prtn_ctfn_typ_id ben_cntnu_prtn_ctfn_typ_f.cntnu_prtn_ctfn_typ_id%TYPE;
61: l_effective_start_date ben_cntnu_prtn_ctfn_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_cntnu_prtn_ctfn_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_CNTNU_PRTN_CTFN_TYP';
64: l_object_version_number ben_cntnu_prtn_ctfn_typ_f.object_version_number%TYPE;
65: --
66: begin
60: l_cntnu_prtn_ctfn_typ_id ben_cntnu_prtn_ctfn_typ_f.cntnu_prtn_ctfn_typ_id%TYPE;
61: l_effective_start_date ben_cntnu_prtn_ctfn_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_cntnu_prtn_ctfn_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_CNTNU_PRTN_CTFN_TYP';
64: l_object_version_number ben_cntnu_prtn_ctfn_typ_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
340: --
341: -- Declare cursors and local variables
342: --
343: l_proc varchar2(72) := g_package||'update_CNTNU_PRTN_CTFN_TYP';
344: l_object_version_number ben_cntnu_prtn_ctfn_typ_f.object_version_number%TYPE;
345: l_effective_start_date ben_cntnu_prtn_ctfn_typ_f.effective_start_date%TYPE;
346: l_effective_end_date ben_cntnu_prtn_ctfn_typ_f.effective_end_date%TYPE;
347: --
348: begin
341: -- Declare cursors and local variables
342: --
343: l_proc varchar2(72) := g_package||'update_CNTNU_PRTN_CTFN_TYP';
344: l_object_version_number ben_cntnu_prtn_ctfn_typ_f.object_version_number%TYPE;
345: l_effective_start_date ben_cntnu_prtn_ctfn_typ_f.effective_start_date%TYPE;
346: l_effective_end_date ben_cntnu_prtn_ctfn_typ_f.effective_end_date%TYPE;
347: --
348: begin
349: --
342: --
343: l_proc varchar2(72) := g_package||'update_CNTNU_PRTN_CTFN_TYP';
344: l_object_version_number ben_cntnu_prtn_ctfn_typ_f.object_version_number%TYPE;
345: l_effective_start_date ben_cntnu_prtn_ctfn_typ_f.effective_start_date%TYPE;
346: l_effective_end_date ben_cntnu_prtn_ctfn_typ_f.effective_end_date%TYPE;
347: --
348: begin
349: --
350: hr_utility.set_location('Entering:'|| l_proc, 10);
585: --
586: -- Declare cursors and local variables
587: --
588: l_proc varchar2(72) := g_package||'update_CNTNU_PRTN_CTFN_TYP';
589: l_object_version_number ben_cntnu_prtn_ctfn_typ_f.object_version_number%TYPE;
590: l_effective_start_date ben_cntnu_prtn_ctfn_typ_f.effective_start_date%TYPE;
591: l_effective_end_date ben_cntnu_prtn_ctfn_typ_f.effective_end_date%TYPE;
592: --
593: begin
586: -- Declare cursors and local variables
587: --
588: l_proc varchar2(72) := g_package||'update_CNTNU_PRTN_CTFN_TYP';
589: l_object_version_number ben_cntnu_prtn_ctfn_typ_f.object_version_number%TYPE;
590: l_effective_start_date ben_cntnu_prtn_ctfn_typ_f.effective_start_date%TYPE;
591: l_effective_end_date ben_cntnu_prtn_ctfn_typ_f.effective_end_date%TYPE;
592: --
593: begin
594: --
587: --
588: l_proc varchar2(72) := g_package||'update_CNTNU_PRTN_CTFN_TYP';
589: l_object_version_number ben_cntnu_prtn_ctfn_typ_f.object_version_number%TYPE;
590: l_effective_start_date ben_cntnu_prtn_ctfn_typ_f.effective_start_date%TYPE;
591: l_effective_end_date ben_cntnu_prtn_ctfn_typ_f.effective_end_date%TYPE;
592: --
593: begin
594: --
595: hr_utility.set_location('Entering:'|| l_proc, 10);