DBA Data[Home] [Help]

APPS.BEN_LER_RLTD_PER_CS_LER_API dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 59: l_ler_rltd_per_cs_ler_id ben_ler_rltd_per_cs_ler_f.ler_rltd_per_cs_ler_id%TYPE;

55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_ler_rltd_per_cs_ler_id ben_ler_rltd_per_cs_ler_f.ler_rltd_per_cs_ler_id%TYPE;
60: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;
61: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_Ler_Rltd_Per_Cs_Ler';
63: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;

Line 60: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;

56: --
57: -- Declare cursors and local variables
58: --
59: l_ler_rltd_per_cs_ler_id ben_ler_rltd_per_cs_ler_f.ler_rltd_per_cs_ler_id%TYPE;
60: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;
61: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_Ler_Rltd_Per_Cs_Ler';
63: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;
64: --

Line 61: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;

57: -- Declare cursors and local variables
58: --
59: l_ler_rltd_per_cs_ler_id ben_ler_rltd_per_cs_ler_f.ler_rltd_per_cs_ler_id%TYPE;
60: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;
61: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_Ler_Rltd_Per_Cs_Ler';
63: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;
64: --
65: begin

Line 63: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;

59: l_ler_rltd_per_cs_ler_id ben_ler_rltd_per_cs_ler_f.ler_rltd_per_cs_ler_id%TYPE;
60: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;
61: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_Ler_Rltd_Per_Cs_Ler';
63: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 338: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;

334: --
335: -- Declare cursors and local variables
336: --
337: l_proc varchar2(72) := g_package||'update_Ler_Rltd_Per_Cs_Ler';
338: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;
339: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;
340: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;
341: --
342: begin

Line 339: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;

335: -- Declare cursors and local variables
336: --
337: l_proc varchar2(72) := g_package||'update_Ler_Rltd_Per_Cs_Ler';
338: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;
339: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;
340: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;
341: --
342: begin
343: --

Line 340: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;

336: --
337: l_proc varchar2(72) := g_package||'update_Ler_Rltd_Per_Cs_Ler';
338: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;
339: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;
340: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;
341: --
342: begin
343: --
344: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 579: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;

575: --
576: -- Declare cursors and local variables
577: --
578: l_proc varchar2(72) := g_package||'update_Ler_Rltd_Per_Cs_Ler';
579: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;
580: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;
581: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;
582: --
583: begin

Line 580: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;

576: -- Declare cursors and local variables
577: --
578: l_proc varchar2(72) := g_package||'update_Ler_Rltd_Per_Cs_Ler';
579: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;
580: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;
581: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;
582: --
583: begin
584: --

Line 581: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;

577: --
578: l_proc varchar2(72) := g_package||'update_Ler_Rltd_Per_Cs_Ler';
579: l_object_version_number ben_ler_rltd_per_cs_ler_f.object_version_number%TYPE;
580: l_effective_start_date ben_ler_rltd_per_cs_ler_f.effective_start_date%TYPE;
581: l_effective_end_date ben_ler_rltd_per_cs_ler_f.effective_end_date%TYPE;
582: --
583: begin
584: --
585: hr_utility.set_location('Entering:'|| l_proc, 10);