DBA Data[Home] [Help]

APPS.BEN_ELIG_SCHEDD_HRS_PRTE_API dependencies on BEN_ELIG_SCHEDD_HRS_PRTE_F

Line 68: l_elig_schedd_hrs_prte_id ben_elig_schedd_hrs_prte_f.elig_schedd_hrs_prte_id%TYPE;

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

Line 69: l_effective_start_date ben_elig_schedd_hrs_prte_f.effective_start_date%TYPE;

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

Line 70: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;

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

Line 72: l_object_version_number ben_elig_schedd_hrs_prte_f.object_version_number%TYPE;

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

Line 279: p_reference_table => 'BEN_ELIG_SCHEDD_HRS_PRTE_F',

275: p_base_table => 'BEN_ELIGY_PRFL_F',
276: p_base_table_column => 'ELIGY_PRFL_ID',
277: p_base_table_column_value => p_eligy_prfl_id,
278: p_base_table_reference_column => 'ELIG_SCHEDD_HRS_FLAG',
279: p_reference_table => 'BEN_ELIG_SCHEDD_HRS_PRTE_F',
280: p_reference_table_column => 'ELIGY_PRFL_ID');
281: --
282: hr_utility.set_location(l_proc, 60);
283: --

Line 393: l_object_version_number ben_elig_schedd_hrs_prte_f.object_version_number%TYPE;

389: --
390: -- Declare cursors and local variables
391: --
392: l_proc varchar2(72) := g_package||'update_ELIG_SCHEDD_HRS_PRTE';
393: l_object_version_number ben_elig_schedd_hrs_prte_f.object_version_number%TYPE;
394: l_effective_start_date ben_elig_schedd_hrs_prte_f.effective_start_date%TYPE;
395: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;
396: --
397: begin

Line 394: l_effective_start_date ben_elig_schedd_hrs_prte_f.effective_start_date%TYPE;

390: -- Declare cursors and local variables
391: --
392: l_proc varchar2(72) := g_package||'update_ELIG_SCHEDD_HRS_PRTE';
393: l_object_version_number ben_elig_schedd_hrs_prte_f.object_version_number%TYPE;
394: l_effective_start_date ben_elig_schedd_hrs_prte_f.effective_start_date%TYPE;
395: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;
396: --
397: begin
398: --

Line 395: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;

391: --
392: l_proc varchar2(72) := g_package||'update_ELIG_SCHEDD_HRS_PRTE';
393: l_object_version_number ben_elig_schedd_hrs_prte_f.object_version_number%TYPE;
394: l_effective_start_date ben_elig_schedd_hrs_prte_f.effective_start_date%TYPE;
395: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;
396: --
397: begin
398: --
399: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 661: l_object_version_number ben_elig_schedd_hrs_prte_f.object_version_number%TYPE;

657: --
658: -- Declare cursors and local variables
659: --
660: l_proc varchar2(72) := g_package||'update_ELIG_SCHEDD_HRS_PRTE';
661: l_object_version_number ben_elig_schedd_hrs_prte_f.object_version_number%TYPE;
662: l_effective_start_date ben_elig_schedd_hrs_prte_f.effective_start_date%TYPE;
663: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;
664: --
665: begin

Line 662: l_effective_start_date ben_elig_schedd_hrs_prte_f.effective_start_date%TYPE;

658: -- Declare cursors and local variables
659: --
660: l_proc varchar2(72) := g_package||'update_ELIG_SCHEDD_HRS_PRTE';
661: l_object_version_number ben_elig_schedd_hrs_prte_f.object_version_number%TYPE;
662: l_effective_start_date ben_elig_schedd_hrs_prte_f.effective_start_date%TYPE;
663: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;
664: --
665: begin
666: --

Line 663: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;

659: --
660: l_proc varchar2(72) := g_package||'update_ELIG_SCHEDD_HRS_PRTE';
661: l_object_version_number ben_elig_schedd_hrs_prte_f.object_version_number%TYPE;
662: l_effective_start_date ben_elig_schedd_hrs_prte_f.effective_start_date%TYPE;
663: l_effective_end_date ben_elig_schedd_hrs_prte_f.effective_end_date%TYPE;
664: --
665: begin
666: --
667: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 742: p_reference_table => 'BEN_ELIG_SCHEDD_HRS_PRTE_F',

738: p_base_table => 'BEN_ELIGY_PRFL_F',
739: p_base_table_column => 'ELIGY_PRFL_ID',
740: p_base_table_column_value => ben_esh_shd.g_old_rec.eligy_prfl_id,
741: p_base_table_reference_column => 'ELIG_SCHEDD_HRS_FLAG',
742: p_reference_table => 'BEN_ELIG_SCHEDD_HRS_PRTE_F',
743: p_reference_table_column => 'ELIGY_PRFL_ID');
744: --
745: hr_utility.set_location(l_proc, 60);
746: --