DBA Data[Home] [Help]

APPS.BEN_PERSON_CHANGE_CS_LER_API dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 63: l_per_info_chg_cs_ler_id ben_per_info_chg_cs_ler_f.per_info_chg_cs_ler_id%TYPE;

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

Line 64: l_effective_start_date ben_per_info_chg_cs_ler_f.effective_start_date%TYPE;

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

Line 65: l_effective_end_date ben_per_info_chg_cs_ler_f.effective_end_date%TYPE;

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

Line 67: l_object_version_number ben_per_info_chg_cs_ler_f.object_version_number%TYPE;

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

Line 358: l_object_version_number ben_per_info_chg_cs_ler_f.object_version_number%TYPE;

354: --
355: -- Declare cursors and local variables
356: --
357: l_proc varchar2(72) := g_package||'update_Person_Change_Cs_Ler';
358: l_object_version_number ben_per_info_chg_cs_ler_f.object_version_number%TYPE;
359: l_effective_start_date ben_per_info_chg_cs_ler_f.effective_start_date%TYPE;
360: l_effective_end_date ben_per_info_chg_cs_ler_f.effective_end_date%TYPE;
361: --
362: begin

Line 359: l_effective_start_date ben_per_info_chg_cs_ler_f.effective_start_date%TYPE;

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

Line 360: l_effective_end_date ben_per_info_chg_cs_ler_f.effective_end_date%TYPE;

356: --
357: l_proc varchar2(72) := g_package||'update_Person_Change_Cs_Ler';
358: l_object_version_number ben_per_info_chg_cs_ler_f.object_version_number%TYPE;
359: l_effective_start_date ben_per_info_chg_cs_ler_f.effective_start_date%TYPE;
360: l_effective_end_date ben_per_info_chg_cs_ler_f.effective_end_date%TYPE;
361: --
362: begin
363: --
364: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 612: l_object_version_number ben_per_info_chg_cs_ler_f.object_version_number%TYPE;

608: --
609: -- Declare cursors and local variables
610: --
611: l_proc varchar2(72) := g_package||'update_Person_Change_Cs_Ler';
612: l_object_version_number ben_per_info_chg_cs_ler_f.object_version_number%TYPE;
613: l_effective_start_date ben_per_info_chg_cs_ler_f.effective_start_date%TYPE;
614: l_effective_end_date ben_per_info_chg_cs_ler_f.effective_end_date%TYPE;
615: --
616: begin

Line 613: l_effective_start_date ben_per_info_chg_cs_ler_f.effective_start_date%TYPE;

609: -- Declare cursors and local variables
610: --
611: l_proc varchar2(72) := g_package||'update_Person_Change_Cs_Ler';
612: l_object_version_number ben_per_info_chg_cs_ler_f.object_version_number%TYPE;
613: l_effective_start_date ben_per_info_chg_cs_ler_f.effective_start_date%TYPE;
614: l_effective_end_date ben_per_info_chg_cs_ler_f.effective_end_date%TYPE;
615: --
616: begin
617: --

Line 614: l_effective_end_date ben_per_info_chg_cs_ler_f.effective_end_date%TYPE;

610: --
611: l_proc varchar2(72) := g_package||'update_Person_Change_Cs_Ler';
612: l_object_version_number ben_per_info_chg_cs_ler_f.object_version_number%TYPE;
613: l_effective_start_date ben_per_info_chg_cs_ler_f.effective_start_date%TYPE;
614: l_effective_end_date ben_per_info_chg_cs_ler_f.effective_end_date%TYPE;
615: --
616: begin
617: --
618: hr_utility.set_location('Entering:'|| l_proc, 10);