DBA Data[Home] [Help]

APPS.BEN_ELIG_CBR_QUALD_BNF_API dependencies on BEN_ELIG_CBR_QUALD_BNF_F

Line 62: l_elig_cbr_quald_bnf_id ben_elig_cbr_quald_bnf_f.elig_cbr_quald_bnf_id%TYPE;

58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_elig_cbr_quald_bnf_id ben_elig_cbr_quald_bnf_f.elig_cbr_quald_bnf_id%TYPE;
63: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ELIG_CBR_QUALD_BNF';
66: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;

Line 63: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;

59: --
60: -- Declare cursors and local variables
61: --
62: l_elig_cbr_quald_bnf_id ben_elig_cbr_quald_bnf_f.elig_cbr_quald_bnf_id%TYPE;
63: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ELIG_CBR_QUALD_BNF';
66: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;
67: --

Line 64: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;

60: -- Declare cursors and local variables
61: --
62: l_elig_cbr_quald_bnf_id ben_elig_cbr_quald_bnf_f.elig_cbr_quald_bnf_id%TYPE;
63: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ELIG_CBR_QUALD_BNF';
66: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;
67: --
68: begin

Line 66: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;

62: l_elig_cbr_quald_bnf_id ben_elig_cbr_quald_bnf_f.elig_cbr_quald_bnf_id%TYPE;
63: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ELIG_CBR_QUALD_BNF';
66: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 255: p_reference_table => 'BEN_ELIG_CBR_QUALD_BNF_F',

251: p_base_table => 'BEN_ELIGY_PRFL_F',
252: p_base_table_column => 'ELIGY_PRFL_ID',
253: p_base_table_column_value => p_eligy_prfl_id,
254: p_base_table_reference_column => 'ELIG_CBR_QUALD_BNF_FLAG',
255: p_reference_table => 'BEN_ELIG_CBR_QUALD_BNF_F',
256: p_reference_table_column => 'ELIGY_PRFL_ID');
257: --
258: hr_utility.set_location(l_proc, 60);
259: --

Line 364: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;

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

Line 365: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;

361: -- Declare cursors and local variables
362: --
363: l_proc varchar2(72) := g_package||'update_ELIG_CBR_QUALD_BNF';
364: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;
365: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;
366: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;
367: --
368: begin
369: --

Line 366: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;

362: --
363: l_proc varchar2(72) := g_package||'update_ELIG_CBR_QUALD_BNF';
364: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;
365: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;
366: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;
367: --
368: begin
369: --
370: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 616: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;

612: --
613: -- Declare cursors and local variables
614: --
615: l_proc varchar2(72) := g_package||'update_ELIG_CBR_QUALD_BNF';
616: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;
617: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;
618: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;
619: --
620: begin

Line 617: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;

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

Line 618: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;

614: --
615: l_proc varchar2(72) := g_package||'update_ELIG_CBR_QUALD_BNF';
616: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;
617: l_effective_start_date ben_elig_cbr_quald_bnf_f.effective_start_date%TYPE;
618: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;
619: --
620: begin
621: --
622: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 697: p_reference_table => 'BEN_ELIG_CBR_QUALD_BNF_F',

693: p_base_table => 'BEN_ELIGY_PRFL_F',
694: p_base_table_column => 'ELIGY_PRFL_ID',
695: p_base_table_column_value => ben_ecq_shd.g_old_rec.eligy_prfl_id,
696: p_base_table_reference_column => 'ELIG_CBR_QUALD_BNF_FLAG',
697: p_reference_table => 'BEN_ELIG_CBR_QUALD_BNF_F',
698: p_reference_table_column => 'ELIGY_PRFL_ID');
699: --
700: hr_utility.set_location(l_proc, 60);
701: --