DBA Data[Home] [Help]

APPS.BEN_ELIG_PSTN_PRTE_API dependencies on BEN_ELIG_PSTN_PRTE_F

Line 61: l_ELIG_PSTN_PRTE_id ben_ELIG_PSTN_PRTE_f.ELIG_PSTN_PRTE_id%TYPE;

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

Line 62: l_effective_start_date ben_ELIG_PSTN_PRTE_f.effective_start_date%TYPE;

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

Line 63: l_effective_end_date ben_ELIG_PSTN_PRTE_f.effective_end_date%TYPE;

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

Line 65: l_object_version_number ben_ELIG_PSTN_PRTE_f.object_version_number%TYPE;

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

Line 254: p_reference_table => 'BEN_ELIG_PSTN_PRTE_F',

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

Line 363: l_object_version_number ben_ELIG_PSTN_PRTE_f.object_version_number%TYPE;

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

Line 364: l_effective_start_date ben_ELIG_PSTN_PRTE_f.effective_start_date%TYPE;

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

Line 365: l_effective_end_date ben_ELIG_PSTN_PRTE_f.effective_end_date%TYPE;

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

Line 613: l_object_version_number ben_ELIG_PSTN_PRTE_f.object_version_number%TYPE;

609: --
610: -- Declare cursors and local variables
611: --
612: l_proc varchar2(72) := g_package||'update_ELIG_PSTN_PRTE';
613: l_object_version_number ben_ELIG_PSTN_PRTE_f.object_version_number%TYPE;
614: l_effective_start_date ben_ELIG_PSTN_PRTE_f.effective_start_date%TYPE;
615: l_effective_end_date ben_ELIG_PSTN_PRTE_f.effective_end_date%TYPE;
616: --
617: begin

Line 614: l_effective_start_date ben_ELIG_PSTN_PRTE_f.effective_start_date%TYPE;

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

Line 615: l_effective_end_date ben_ELIG_PSTN_PRTE_f.effective_end_date%TYPE;

611: --
612: l_proc varchar2(72) := g_package||'update_ELIG_PSTN_PRTE';
613: l_object_version_number ben_ELIG_PSTN_PRTE_f.object_version_number%TYPE;
614: l_effective_start_date ben_ELIG_PSTN_PRTE_f.effective_start_date%TYPE;
615: l_effective_end_date ben_ELIG_PSTN_PRTE_f.effective_end_date%TYPE;
616: --
617: begin
618: --
619: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 694: p_reference_table => 'BEN_ELIG_PSTN_PRTE_F',

690: p_base_table => 'BEN_ELIGY_PRFL_F',
691: p_base_table_column => 'ELIGY_PRFL_ID',
692: p_base_table_column_value => ben_eps_shd.g_old_rec.eligy_prfl_id,
693: p_base_table_reference_column => 'ELIG_PSTN_FLAG',
694: p_reference_table => 'BEN_ELIG_PSTN_PRTE_F',
695: p_reference_table_column => 'ELIGY_PRFL_ID');
696: --
697: hr_utility.set_location(l_proc, 60);
698: --