DBA Data[Home] [Help]

APPS.BEN_LER_CHG_PGM_ENRT_API dependencies on BEN_LER_CHG_PGM_ENRT_F

Line 65: l_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;

61: ) is
62: --
63: -- Declare cursors and local variables
64: --
65: l_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
66: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pgm_Enrt';
69: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;

Line 66: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;

62: --
63: -- Declare cursors and local variables
64: --
65: l_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
66: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pgm_Enrt';
69: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;
70: --

Line 67: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;

63: -- Declare cursors and local variables
64: --
65: l_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
66: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pgm_Enrt';
69: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;
70: --
71: begin

Line 69: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;

65: l_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
66: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;
67: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;
68: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pgm_Enrt';
69: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;
70: --
71: begin
72: --
73: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 369: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;

365: --
366: -- Declare cursors and local variables
367: --
368: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pgm_Enrt';
369: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;
370: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;
371: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;
372: --
373: begin

Line 370: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;

366: -- Declare cursors and local variables
367: --
368: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pgm_Enrt';
369: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;
370: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;
371: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;
372: --
373: begin
374: --

Line 371: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;

367: --
368: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pgm_Enrt';
369: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;
370: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;
371: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;
372: --
373: begin
374: --
375: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 629: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;

625: --
626: -- Declare cursors and local variables
627: --
628: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pgm_Enrt';
629: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;
630: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;
631: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;
632: --
633: begin

Line 630: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;

626: -- Declare cursors and local variables
627: --
628: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pgm_Enrt';
629: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;
630: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;
631: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;
632: --
633: begin
634: --

Line 631: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;

627: --
628: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pgm_Enrt';
629: l_object_version_number ben_ler_chg_pgm_enrt_f.object_version_number%TYPE;
630: l_effective_start_date ben_ler_chg_pgm_enrt_f.effective_start_date%TYPE;
631: l_effective_end_date ben_ler_chg_pgm_enrt_f.effective_end_date%TYPE;
632: --
633: begin
634: --
635: hr_utility.set_location('Entering:'|| l_proc, 10);