67: ) is
68: --
69: -- Declare cursors and local variables
70: --
71: l_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;
72: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
73: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PRTT_PREM_BY_MO';
75: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
68: --
69: -- Declare cursors and local variables
70: --
71: l_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;
72: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
73: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PRTT_PREM_BY_MO';
75: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
76: --
69: -- Declare cursors and local variables
70: --
71: l_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;
72: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
73: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PRTT_PREM_BY_MO';
75: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
76: --
77: begin
71: l_prtt_prem_by_mo_id ben_prtt_prem_by_mo_f.prtt_prem_by_mo_id%TYPE;
72: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
73: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
74: l_proc varchar2(72) := g_package||'create_PRTT_PREM_BY_MO';
75: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
76: --
77: begin
78: --
79: hr_utility.set_location('Entering:'|| l_proc, 10);
394: --
395: -- Declare cursors and local variables
396: --
397: l_proc varchar2(72) := g_package||'update_PRTT_PREM_BY_MO';
398: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
399: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
400: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
401: --
402: begin
395: -- Declare cursors and local variables
396: --
397: l_proc varchar2(72) := g_package||'update_PRTT_PREM_BY_MO';
398: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
399: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
400: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
401: --
402: begin
403: --
396: --
397: l_proc varchar2(72) := g_package||'update_PRTT_PREM_BY_MO';
398: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
399: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
400: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
401: --
402: begin
403: --
404: hr_utility.set_location('Entering:'|| l_proc, 10);
672: --
673: -- Declare cursors and local variables
674: --
675: l_proc varchar2(72) := g_package||'delete_PRTT_PREM_BY_MO';
676: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
677: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
678: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
679: --
680: begin
673: -- Declare cursors and local variables
674: --
675: l_proc varchar2(72) := g_package||'delete_PRTT_PREM_BY_MO';
676: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
677: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
678: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
679: --
680: begin
681: --
674: --
675: l_proc varchar2(72) := g_package||'delete_PRTT_PREM_BY_MO';
676: l_object_version_number ben_prtt_prem_by_mo_f.object_version_number%TYPE;
677: l_effective_start_date ben_prtt_prem_by_mo_f.effective_start_date%TYPE;
678: l_effective_end_date ben_prtt_prem_by_mo_f.effective_end_date%TYPE;
679: --
680: begin
681: --
682: hr_utility.set_location('Entering:'|| l_proc, 10);