DBA Data[Home] [Help]

APPS.BEN_PERIOD_LIMIT_API dependencies on BEN_PTD_LMT_F

Line 63: l_ptd_lmt_id ben_ptd_lmt_f.ptd_lmt_id%TYPE;

59: ) is
60: --
61: -- Declare cursors and local variables
62: --
63: l_ptd_lmt_id ben_ptd_lmt_f.ptd_lmt_id%TYPE;
64: l_effective_start_date ben_ptd_lmt_f.effective_start_date%TYPE;
65: l_effective_end_date ben_ptd_lmt_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_period_limit';
67: l_object_version_number ben_ptd_lmt_f.object_version_number%TYPE;

Line 64: l_effective_start_date ben_ptd_lmt_f.effective_start_date%TYPE;

60: --
61: -- Declare cursors and local variables
62: --
63: l_ptd_lmt_id ben_ptd_lmt_f.ptd_lmt_id%TYPE;
64: l_effective_start_date ben_ptd_lmt_f.effective_start_date%TYPE;
65: l_effective_end_date ben_ptd_lmt_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_period_limit';
67: l_object_version_number ben_ptd_lmt_f.object_version_number%TYPE;
68: --

Line 65: l_effective_end_date ben_ptd_lmt_f.effective_end_date%TYPE;

61: -- Declare cursors and local variables
62: --
63: l_ptd_lmt_id ben_ptd_lmt_f.ptd_lmt_id%TYPE;
64: l_effective_start_date ben_ptd_lmt_f.effective_start_date%TYPE;
65: l_effective_end_date ben_ptd_lmt_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_period_limit';
67: l_object_version_number ben_ptd_lmt_f.object_version_number%TYPE;
68: --
69: begin

Line 67: l_object_version_number ben_ptd_lmt_f.object_version_number%TYPE;

63: l_ptd_lmt_id ben_ptd_lmt_f.ptd_lmt_id%TYPE;
64: l_effective_start_date ben_ptd_lmt_f.effective_start_date%TYPE;
65: l_effective_end_date ben_ptd_lmt_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_period_limit';
67: l_object_version_number ben_ptd_lmt_f.object_version_number%TYPE;
68: --
69: begin
70: --
71: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 360: l_object_version_number ben_ptd_lmt_f.object_version_number%TYPE;

356: --
357: -- Declare cursors and local variables
358: --
359: l_proc varchar2(72) := g_package||'update_period_limit';
360: l_object_version_number ben_ptd_lmt_f.object_version_number%TYPE;
361: l_effective_start_date ben_ptd_lmt_f.effective_start_date%TYPE;
362: l_effective_end_date ben_ptd_lmt_f.effective_end_date%TYPE;
363: --
364: begin

Line 361: l_effective_start_date ben_ptd_lmt_f.effective_start_date%TYPE;

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

Line 362: l_effective_end_date ben_ptd_lmt_f.effective_end_date%TYPE;

358: --
359: l_proc varchar2(72) := g_package||'update_period_limit';
360: l_object_version_number ben_ptd_lmt_f.object_version_number%TYPE;
361: l_effective_start_date ben_ptd_lmt_f.effective_start_date%TYPE;
362: l_effective_end_date ben_ptd_lmt_f.effective_end_date%TYPE;
363: --
364: begin
365: --
366: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 615: l_object_version_number ben_ptd_lmt_f.object_version_number%TYPE;

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

Line 616: l_effective_start_date ben_ptd_lmt_f.effective_start_date%TYPE;

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

Line 617: l_effective_end_date ben_ptd_lmt_f.effective_end_date%TYPE;

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