DBA Data[Home] [Help]

APPS.BEN_PL_R_OIPL_PREM_BY_MO_API dependencies on BEN_PL_R_OIPL_PREM_BY_MO_F

Line 67: l_pl_r_oipl_prem_by_mo_id ben_pl_r_oipl_prem_by_mo_f.pl_r_oipl_prem_by_mo_id%TYPE;

63: ) is
64: --
65: -- Declare cursors and local variables
66: --
67: l_pl_r_oipl_prem_by_mo_id ben_pl_r_oipl_prem_by_mo_f.pl_r_oipl_prem_by_mo_id%TYPE;
68: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;
69: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_PL_R_OIPL_PREM_BY_MO';
71: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;

Line 68: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;

64: --
65: -- Declare cursors and local variables
66: --
67: l_pl_r_oipl_prem_by_mo_id ben_pl_r_oipl_prem_by_mo_f.pl_r_oipl_prem_by_mo_id%TYPE;
68: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;
69: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_PL_R_OIPL_PREM_BY_MO';
71: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;
72: --

Line 69: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;

65: -- Declare cursors and local variables
66: --
67: l_pl_r_oipl_prem_by_mo_id ben_pl_r_oipl_prem_by_mo_f.pl_r_oipl_prem_by_mo_id%TYPE;
68: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;
69: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_PL_R_OIPL_PREM_BY_MO';
71: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;
72: --
73: begin

Line 71: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;

67: l_pl_r_oipl_prem_by_mo_id ben_pl_r_oipl_prem_by_mo_f.pl_r_oipl_prem_by_mo_id%TYPE;
68: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;
69: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_PL_R_OIPL_PREM_BY_MO';
71: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;
72: --
73: begin
74: --
75: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 378: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;

374: --
375: -- Declare cursors and local variables
376: --
377: l_proc varchar2(72) := g_package||'update_PL_R_OIPL_PREM_BY_MO';
378: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;
379: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;
380: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;
381: --
382: begin

Line 379: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;

375: -- Declare cursors and local variables
376: --
377: l_proc varchar2(72) := g_package||'update_PL_R_OIPL_PREM_BY_MO';
378: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;
379: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;
380: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;
381: --
382: begin
383: --

Line 380: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;

376: --
377: l_proc varchar2(72) := g_package||'update_PL_R_OIPL_PREM_BY_MO';
378: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;
379: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;
380: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;
381: --
382: begin
383: --
384: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 644: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;

640: --
641: -- Declare cursors and local variables
642: --
643: l_proc varchar2(72) := g_package||'update_PL_R_OIPL_PREM_BY_MO';
644: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;
645: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;
646: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;
647: --
648: begin

Line 645: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;

641: -- Declare cursors and local variables
642: --
643: l_proc varchar2(72) := g_package||'update_PL_R_OIPL_PREM_BY_MO';
644: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;
645: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;
646: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;
647: --
648: begin
649: --

Line 646: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;

642: --
643: l_proc varchar2(72) := g_package||'update_PL_R_OIPL_PREM_BY_MO';
644: l_object_version_number ben_pl_r_oipl_prem_by_mo_f.object_version_number%TYPE;
645: l_effective_start_date ben_pl_r_oipl_prem_by_mo_f.effective_start_date%TYPE;
646: l_effective_end_date ben_pl_r_oipl_prem_by_mo_f.effective_end_date%TYPE;
647: --
648: begin
649: --
650: hr_utility.set_location('Entering:'|| l_proc, 10);