APPS.BEN_OPTION_IN_PLAN_IN_PGM_API dependencies on BEN_OIPLIP_F

Line 59: l_oiplip_id ben_oiplip_f.oiplip_id%TYPE;

55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_oiplip_id ben_oiplip_f.oiplip_id%TYPE;
60: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;
61: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_option_in_plan_in_pgm';
63: l_object_version_number ben_oiplip_f.object_version_number%TYPE;

Line 60: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;

56: --
57: -- Declare cursors and local variables
58: --
59: l_oiplip_id ben_oiplip_f.oiplip_id%TYPE;
60: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;
61: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_option_in_plan_in_pgm';
63: l_object_version_number ben_oiplip_f.object_version_number%TYPE;
64: --

Line 61: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;

57: -- Declare cursors and local variables
58: --
59: l_oiplip_id ben_oiplip_f.oiplip_id%TYPE;
60: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;
61: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_option_in_plan_in_pgm';
63: l_object_version_number ben_oiplip_f.object_version_number%TYPE;
64: --
65: begin

Line 63: l_object_version_number ben_oiplip_f.object_version_number%TYPE;

59: l_oiplip_id ben_oiplip_f.oiplip_id%TYPE;
60: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;
61: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_option_in_plan_in_pgm';
63: l_object_version_number ben_oiplip_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 340: l_object_version_number ben_oiplip_f.object_version_number%TYPE;

336: --
337: -- Declare cursors and local variables
338: --
339: l_proc varchar2(72) := g_package||'update_option_in_plan_in_pgm';
340: l_object_version_number ben_oiplip_f.object_version_number%TYPE;
341: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;
342: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;
343: --
344: begin

Line 341: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;

337: -- Declare cursors and local variables
338: --
339: l_proc varchar2(72) := g_package||'update_option_in_plan_in_pgm';
340: l_object_version_number ben_oiplip_f.object_version_number%TYPE;
341: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;
342: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;
343: --
344: begin
345: --

Line 342: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;

338: --
339: l_proc varchar2(72) := g_package||'update_option_in_plan_in_pgm';
340: l_object_version_number ben_oiplip_f.object_version_number%TYPE;
341: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;
342: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;
343: --
344: begin
345: --
346: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 588: l_object_version_number ben_oiplip_f.object_version_number%TYPE;

584: --
585: -- Declare cursors and local variables
586: --
587: l_proc varchar2(72) := g_package||'update_option_in_plan_in_pgm';
588: l_object_version_number ben_oiplip_f.object_version_number%TYPE;
589: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;
590: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;
591: --
592: begin

Line 589: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;

585: -- Declare cursors and local variables
586: --
587: l_proc varchar2(72) := g_package||'update_option_in_plan_in_pgm';
588: l_object_version_number ben_oiplip_f.object_version_number%TYPE;
589: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;
590: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;
591: --
592: begin
593: --

Line 590: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;

586: --
587: l_proc varchar2(72) := g_package||'update_option_in_plan_in_pgm';
588: l_object_version_number ben_oiplip_f.object_version_number%TYPE;
589: l_effective_start_date ben_oiplip_f.effective_start_date%TYPE;
590: l_effective_end_date ben_oiplip_f.effective_end_date%TYPE;
591: --
592: begin
593: --
594: hr_utility.set_location('Entering:'|| l_proc, 10);