DBA Data[Home] [Help]

APPS.BEN_ELIG_CMBN_AGE_LOS_API dependencies on BEN_ELIG_CMBN_AGE_LOS_PRTE_F

Line 62: l_elig_cmbn_age_los_prte_id ben_elig_cmbn_age_los_prte_f.elig_cmbn_age_los_prte_id%TYPE;

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

Line 63: l_effective_start_date ben_elig_cmbn_age_los_prte_f.effective_start_date%TYPE;

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

Line 64: l_effective_end_date ben_elig_cmbn_age_los_prte_f.effective_end_date%TYPE;

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

Line 66: l_object_version_number ben_elig_cmbn_age_los_prte_f.object_version_number%TYPE;

62: l_elig_cmbn_age_los_prte_id ben_elig_cmbn_age_los_prte_f.elig_cmbn_age_los_prte_id%TYPE;
63: l_effective_start_date ben_elig_cmbn_age_los_prte_f.effective_start_date%TYPE;
64: l_effective_end_date ben_elig_cmbn_age_los_prte_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ELIG_CMBN_AGE_LOS';
66: l_object_version_number ben_elig_cmbn_age_los_prte_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_CMBN_AGE_LOS_PRTE_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_CMBN_AGE_LOS_FLAG',
255: p_reference_table => 'BEN_ELIG_CMBN_AGE_LOS_PRTE_F',
256: p_reference_table_column => 'ELIGY_PRFL_ID');
257: --
258: ben_derivable_factor.derivable_factor_handler
259: (p_event => 'CREATE',

Line 369: l_object_version_number ben_elig_cmbn_age_los_prte_f.object_version_number%TYPE;

365: --
366: -- Declare cursors and local variables
367: --
368: l_proc varchar2(72) := g_package||'update_ELIG_CMBN_AGE_LOS';
369: l_object_version_number ben_elig_cmbn_age_los_prte_f.object_version_number%TYPE;
370: l_effective_start_date ben_elig_cmbn_age_los_prte_f.effective_start_date%TYPE;
371: l_effective_end_date ben_elig_cmbn_age_los_prte_f.effective_end_date%TYPE;
372: --
373: begin

Line 370: l_effective_start_date ben_elig_cmbn_age_los_prte_f.effective_start_date%TYPE;

366: -- Declare cursors and local variables
367: --
368: l_proc varchar2(72) := g_package||'update_ELIG_CMBN_AGE_LOS';
369: l_object_version_number ben_elig_cmbn_age_los_prte_f.object_version_number%TYPE;
370: l_effective_start_date ben_elig_cmbn_age_los_prte_f.effective_start_date%TYPE;
371: l_effective_end_date ben_elig_cmbn_age_los_prte_f.effective_end_date%TYPE;
372: --
373: begin
374: --

Line 371: l_effective_end_date ben_elig_cmbn_age_los_prte_f.effective_end_date%TYPE;

367: --
368: l_proc varchar2(72) := g_package||'update_ELIG_CMBN_AGE_LOS';
369: l_object_version_number ben_elig_cmbn_age_los_prte_f.object_version_number%TYPE;
370: l_effective_start_date ben_elig_cmbn_age_los_prte_f.effective_start_date%TYPE;
371: l_effective_end_date ben_elig_cmbn_age_los_prte_f.effective_end_date%TYPE;
372: --
373: begin
374: --
375: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 621: l_object_version_number ben_elig_cmbn_age_los_prte_f.object_version_number%TYPE;

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

Line 622: l_effective_start_date ben_elig_cmbn_age_los_prte_f.effective_start_date%TYPE;

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

Line 623: l_effective_end_date ben_elig_cmbn_age_los_prte_f.effective_end_date%TYPE;

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

Line 702: p_reference_table => 'BEN_ELIG_CMBN_AGE_LOS_PRTE_F',

698: p_base_table => 'BEN_ELIGY_PRFL_F',
699: p_base_table_column => 'ELIGY_PRFL_ID',
700: p_base_table_column_value => ben_ecp_shd.g_old_rec.eligy_prfl_id,
701: p_base_table_reference_column => 'ELIG_CMBN_AGE_LOS_FLAG',
702: p_reference_table => 'BEN_ELIG_CMBN_AGE_LOS_PRTE_F',
703: p_reference_table_column => 'ELIGY_PRFL_ID');
704: --
705: ben_derivable_factor.derivable_factor_handler
706: (p_event => 'DELETE',