DBA Data[Home] [Help]

APPS.BEN_RLTD_PER_CHG_CS_LER_API dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 63: l_rltd_per_chg_cs_ler_id ben_rltd_per_chg_cs_ler_f.rltd_per_chg_cs_ler_id%TYPE;

59: ) is
60: --
61: -- Declare cursors and local variables
62: --
63: l_rltd_per_chg_cs_ler_id ben_rltd_per_chg_cs_ler_f.rltd_per_chg_cs_ler_id%TYPE;
64: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;
65: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_Rltd_Per_Chg_Cs_Ler';
67: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;

Line 64: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;

60: --
61: -- Declare cursors and local variables
62: --
63: l_rltd_per_chg_cs_ler_id ben_rltd_per_chg_cs_ler_f.rltd_per_chg_cs_ler_id%TYPE;
64: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;
65: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_Rltd_Per_Chg_Cs_Ler';
67: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;
68: --

Line 65: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;

61: -- Declare cursors and local variables
62: --
63: l_rltd_per_chg_cs_ler_id ben_rltd_per_chg_cs_ler_f.rltd_per_chg_cs_ler_id%TYPE;
64: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;
65: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_Rltd_Per_Chg_Cs_Ler';
67: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;
68: --
69: begin

Line 67: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;

63: l_rltd_per_chg_cs_ler_id ben_rltd_per_chg_cs_ler_f.rltd_per_chg_cs_ler_id%TYPE;
64: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;
65: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_Rltd_Per_Chg_Cs_Ler';
67: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;
68: --
69: begin
70: --
71: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 361: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;

357: --
358: -- Declare cursors and local variables
359: --
360: l_proc varchar2(72) := g_package||'update_Rltd_Per_Chg_Cs_Ler';
361: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;
362: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;
363: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;
364: --
365: begin

Line 362: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;

358: -- Declare cursors and local variables
359: --
360: l_proc varchar2(72) := g_package||'update_Rltd_Per_Chg_Cs_Ler';
361: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;
362: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;
363: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;
364: --
365: begin
366: --

Line 363: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;

359: --
360: l_proc varchar2(72) := g_package||'update_Rltd_Per_Chg_Cs_Ler';
361: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;
362: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;
363: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;
364: --
365: begin
366: --
367: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 619: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;

615: --
616: -- Declare cursors and local variables
617: --
618: l_proc varchar2(72) := g_package||'update_Rltd_Per_Chg_Cs_Ler';
619: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;
620: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;
621: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;
622: --
623: begin

Line 620: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;

616: -- Declare cursors and local variables
617: --
618: l_proc varchar2(72) := g_package||'update_Rltd_Per_Chg_Cs_Ler';
619: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;
620: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;
621: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;
622: --
623: begin
624: --

Line 621: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;

617: --
618: l_proc varchar2(72) := g_package||'update_Rltd_Per_Chg_Cs_Ler';
619: l_object_version_number ben_rltd_per_chg_cs_ler_f.object_version_number%TYPE;
620: l_effective_start_date ben_rltd_per_chg_cs_ler_f.effective_start_date%TYPE;
621: l_effective_end_date ben_rltd_per_chg_cs_ler_f.effective_end_date%TYPE;
622: --
623: begin
624: --
625: hr_utility.set_location('Entering:'|| l_proc, 10);