DBA Data[Home] [Help]

APPS.BEN_ELIG_COMPTNCY_PRTE_API dependencies on BEN_ELIG_COMPTNCY_PRTE_F

Line 62: l_ELIG_COMPTNCY_PRTE_id ben_ELIG_COMPTNCY_PRTE_f.ELIG_COMPTNCY_PRTE_id%TYPE;

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

Line 63: l_effective_start_date ben_ELIG_COMPTNCY_PRTE_f.effective_start_date%TYPE;

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

Line 64: l_effective_end_date ben_ELIG_COMPTNCY_PRTE_f.effective_end_date%TYPE;

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

Line 66: l_object_version_number ben_ELIG_COMPTNCY_PRTE_f.object_version_number%TYPE;

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

Line 258: p_reference_table => 'BEN_ELIG_COMPTNCY_PRTE_F',

254: p_base_table => 'BEN_ELIGY_PRFL_F',
255: p_base_table_column => 'ELIGY_PRFL_ID',
256: p_base_table_column_value => p_eligy_prfl_id,
257: p_base_table_reference_column => 'ELIG_COMPTNCY_FLAG',
258: p_reference_table => 'BEN_ELIG_COMPTNCY_PRTE_F',
259: p_reference_table_column => 'ELIGY_PRFL_ID');
260: --
261: hr_utility.set_location(l_proc, 60);
262: --

Line 367: l_object_version_number ben_ELIG_COMPTNCY_PRTE_f.object_version_number%TYPE;

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

Line 368: l_effective_start_date ben_ELIG_COMPTNCY_PRTE_f.effective_start_date%TYPE;

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

Line 369: l_effective_end_date ben_ELIG_COMPTNCY_PRTE_f.effective_end_date%TYPE;

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

Line 619: l_object_version_number ben_ELIG_COMPTNCY_PRTE_f.object_version_number%TYPE;

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

Line 620: l_effective_start_date ben_ELIG_COMPTNCY_PRTE_f.effective_start_date%TYPE;

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

Line 621: l_effective_end_date ben_ELIG_COMPTNCY_PRTE_f.effective_end_date%TYPE;

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

Line 700: p_reference_table => 'BEN_ELIG_COMPTNCY_PRTE_F',

696: p_base_table => 'BEN_ELIGY_PRFL_F',
697: p_base_table_column => 'ELIGY_PRFL_ID',
698: p_base_table_column_value => ben_ecy_shd.g_old_rec.eligy_prfl_id,
699: p_base_table_reference_column => 'ELIG_COMPTNCY_FLAG',
700: p_reference_table => 'BEN_ELIG_COMPTNCY_PRTE_F',
701: p_reference_table_column => 'ELIGY_PRFL_ID');
702: --
703: hr_utility.set_location(l_proc, 60);
704: --