DBA Data[Home] [Help]

APPS.BEN_LER_CHG_PL_NIP_RL_API dependencies on BEN_LER_CHG_PL_NIP_RL_F

Line 58: l_ler_chg_pl_nip_rl_id ben_ler_chg_pl_nip_rl_f.ler_chg_pl_nip_rl_id%TYPE;

54: ) is
55: --
56: -- Declare cursors and local variables
57: --
58: l_ler_chg_pl_nip_rl_id ben_ler_chg_pl_nip_rl_f.ler_chg_pl_nip_rl_id%TYPE;
59: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pl_Nip_Rl';
62: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;

Line 59: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;

55: --
56: -- Declare cursors and local variables
57: --
58: l_ler_chg_pl_nip_rl_id ben_ler_chg_pl_nip_rl_f.ler_chg_pl_nip_rl_id%TYPE;
59: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pl_Nip_Rl';
62: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;
63: --

Line 60: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;

56: -- Declare cursors and local variables
57: --
58: l_ler_chg_pl_nip_rl_id ben_ler_chg_pl_nip_rl_f.ler_chg_pl_nip_rl_id%TYPE;
59: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pl_Nip_Rl';
62: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;
63: --
64: begin

Line 62: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;

58: l_ler_chg_pl_nip_rl_id ben_ler_chg_pl_nip_rl_f.ler_chg_pl_nip_rl_id%TYPE;
59: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;
60: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pl_Nip_Rl';
62: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;
63: --
64: begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 329: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;

325: --
326: -- Declare cursors and local variables
327: --
328: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Rl';
329: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;
330: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;
331: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;
332: --
333: begin

Line 330: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;

326: -- Declare cursors and local variables
327: --
328: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Rl';
329: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;
330: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;
331: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;
332: --
333: begin
334: --

Line 331: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;

327: --
328: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Rl';
329: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;
330: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;
331: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;
332: --
333: begin
334: --
335: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 564: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;

560: --
561: -- Declare cursors and local variables
562: --
563: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Rl';
564: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;
565: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;
566: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;
567: --
568: begin

Line 565: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;

561: -- Declare cursors and local variables
562: --
563: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Rl';
564: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;
565: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;
566: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;
567: --
568: begin
569: --

Line 566: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;

562: --
563: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Rl';
564: l_object_version_number ben_ler_chg_pl_nip_rl_f.object_version_number%TYPE;
565: l_effective_start_date ben_ler_chg_pl_nip_rl_f.effective_start_date%TYPE;
566: l_effective_end_date ben_ler_chg_pl_nip_rl_f.effective_end_date%TYPE;
567: --
568: begin
569: --
570: hr_utility.set_location('Entering:'|| l_proc, 10);