DBA Data[Home] [Help]

APPS.BEN_ELIG_HRS_WKD_PRTE_API dependencies on BEN_ELIG_HRS_WKD_PRTE_F

Line 61: l_elig_hrs_wkd_prte_id ben_elig_hrs_wkd_prte_f.elig_hrs_wkd_prte_id%TYPE;

57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_hrs_wkd_prte_id ben_elig_hrs_wkd_prte_f.elig_hrs_wkd_prte_id%TYPE;
62: l_effective_start_date ben_elig_hrs_wkd_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_hrs_wkd_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_HRS_WKD_PRTE';
65: l_object_version_number ben_elig_hrs_wkd_prte_f.object_version_number%TYPE;

Line 62: l_effective_start_date ben_elig_hrs_wkd_prte_f.effective_start_date%TYPE;

58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_hrs_wkd_prte_id ben_elig_hrs_wkd_prte_f.elig_hrs_wkd_prte_id%TYPE;
62: l_effective_start_date ben_elig_hrs_wkd_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_hrs_wkd_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_HRS_WKD_PRTE';
65: l_object_version_number ben_elig_hrs_wkd_prte_f.object_version_number%TYPE;
66: --

Line 63: l_effective_end_date ben_elig_hrs_wkd_prte_f.effective_end_date%TYPE;

59: -- Declare cursors and local variables
60: --
61: l_elig_hrs_wkd_prte_id ben_elig_hrs_wkd_prte_f.elig_hrs_wkd_prte_id%TYPE;
62: l_effective_start_date ben_elig_hrs_wkd_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_hrs_wkd_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_HRS_WKD_PRTE';
65: l_object_version_number ben_elig_hrs_wkd_prte_f.object_version_number%TYPE;
66: --
67: begin

Line 65: l_object_version_number ben_elig_hrs_wkd_prte_f.object_version_number%TYPE;

61: l_elig_hrs_wkd_prte_id ben_elig_hrs_wkd_prte_f.elig_hrs_wkd_prte_id%TYPE;
62: l_effective_start_date ben_elig_hrs_wkd_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_hrs_wkd_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_HRS_WKD_PRTE';
65: l_object_version_number ben_elig_hrs_wkd_prte_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 251: p_reference_table => 'BEN_ELIG_HRS_WKD_PRTE_F',

247: p_base_table => 'BEN_ELIGY_PRFL_F',
248: p_base_table_column => 'ELIGY_PRFL_ID',
249: p_base_table_column_value => p_eligy_prfl_id,
250: p_base_table_reference_column => 'ELIG_HRS_WKD_FLAG',
251: p_reference_table => 'BEN_ELIG_HRS_WKD_PRTE_F',
252: p_reference_table_column => 'ELIGY_PRFL_ID');
253: --
254: ben_derivable_factor.derivable_factor_handler
255: (p_event => 'CREATE',

Line 366: l_object_version_number ben_elig_hrs_wkd_prte_f.object_version_number%TYPE;

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

Line 367: l_effective_start_date ben_elig_hrs_wkd_prte_f.effective_start_date%TYPE;

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

Line 368: l_effective_end_date ben_elig_hrs_wkd_prte_f.effective_end_date%TYPE;

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

Line 617: l_object_version_number ben_elig_hrs_wkd_prte_f.object_version_number%TYPE;

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

Line 618: l_effective_start_date ben_elig_hrs_wkd_prte_f.effective_start_date%TYPE;

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

Line 619: l_effective_end_date ben_elig_hrs_wkd_prte_f.effective_end_date%TYPE;

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

Line 698: p_reference_table => 'BEN_ELIG_HRS_WKD_PRTE_F',

694: p_base_table => 'BEN_ELIGY_PRFL_F',
695: p_base_table_column => 'ELIGY_PRFL_ID',
696: p_base_table_column_value => ben_ehw_shd.g_old_rec.eligy_prfl_id,
697: p_base_table_reference_column => 'ELIG_HRS_WKD_FLAG',
698: p_reference_table => 'BEN_ELIG_HRS_WKD_PRTE_F',
699: p_reference_table_column => 'ELIGY_PRFL_ID');
700: --
701: ben_derivable_factor.derivable_factor_handler
702: (p_event => 'DELETE',