DBA Data[Home] [Help]

APPS.BEN_LER_CHG_DEPENDENT_CVG_API dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 68: l_ler_chg_dpnt_cvg_id ben_ler_chg_dpnt_cvg_f.ler_chg_dpnt_cvg_id%TYPE;

64: ) is
65: --
66: -- Declare cursors and local variables
67: --
68: l_ler_chg_dpnt_cvg_id ben_ler_chg_dpnt_cvg_f.ler_chg_dpnt_cvg_id%TYPE;
69: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
70: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_Ler_Chg_Dependent_Cvg';
72: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;

Line 69: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;

65: --
66: -- Declare cursors and local variables
67: --
68: l_ler_chg_dpnt_cvg_id ben_ler_chg_dpnt_cvg_f.ler_chg_dpnt_cvg_id%TYPE;
69: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
70: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_Ler_Chg_Dependent_Cvg';
72: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
73: --

Line 70: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;

66: -- Declare cursors and local variables
67: --
68: l_ler_chg_dpnt_cvg_id ben_ler_chg_dpnt_cvg_f.ler_chg_dpnt_cvg_id%TYPE;
69: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
70: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_Ler_Chg_Dependent_Cvg';
72: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
73: --
74: begin

Line 72: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;

68: l_ler_chg_dpnt_cvg_id ben_ler_chg_dpnt_cvg_f.ler_chg_dpnt_cvg_id%TYPE;
69: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
70: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_Ler_Chg_Dependent_Cvg';
72: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
73: --
74: begin
75: --
76: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 379: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;

375: --
376: -- Declare cursors and local variables
377: --
378: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
379: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
380: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
381: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
382: --
383: begin

Line 380: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;

376: -- Declare cursors and local variables
377: --
378: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
379: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
380: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
381: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
382: --
383: begin
384: --

Line 381: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;

377: --
378: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
379: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
380: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
381: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
382: --
383: begin
384: --
385: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 648: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;

644: --
645: -- Declare cursors and local variables
646: --
647: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
648: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
649: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
650: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
651: --
652: begin

Line 649: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;

645: -- Declare cursors and local variables
646: --
647: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
648: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
649: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
650: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
651: --
652: begin
653: --

Line 650: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;

646: --
647: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
648: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
649: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
650: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
651: --
652: begin
653: --
654: hr_utility.set_location('Entering:'|| l_proc, 10);