APPS.BEN_OPT_PLTYP_IN_PGM_API dependencies on BEN_OPTIP_F

Line 64: ben_optip_f optip

60: -- Cursor to find the uniqueness of the optip
61: --
62: cursor c_uniq_optip is
63: select null from
64: ben_optip_f optip
65: where optip.pgm_id = p_pgm_id
66: and optip.pl_typ_id = p_pl_typ_id
67: and optip.opt_id = p_opt_id
68: and p_effective_date between optip.effective_start_date and

Line 73: ben_optip_f optip

69: optip.effective_end_date ;
70: --
71: cursor c_future_optip is
72: select optip_id from
73: ben_optip_f optip
74: where optip.pgm_id = p_pgm_id
75: and optip.pl_typ_id = p_pl_typ_id
76: and optip.opt_id = p_opt_id
77: and optip.effective_start_date > p_effective_date ;

Line 81: l_optip_id ben_optip_f.optip_id%TYPE;

77: and optip.effective_start_date > p_effective_date ;
78:
79: -- Declare cursors and local variables
80: --
81: l_optip_id ben_optip_f.optip_id%TYPE;
82: l_effective_start_date ben_optip_f.effective_start_date%TYPE;
83: l_effective_end_date ben_optip_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_opt_pltyp_in_pgm';
85: l_object_version_number ben_optip_f.object_version_number%TYPE;

Line 82: l_effective_start_date ben_optip_f.effective_start_date%TYPE;

78:
79: -- Declare cursors and local variables
80: --
81: l_optip_id ben_optip_f.optip_id%TYPE;
82: l_effective_start_date ben_optip_f.effective_start_date%TYPE;
83: l_effective_end_date ben_optip_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_opt_pltyp_in_pgm';
85: l_object_version_number ben_optip_f.object_version_number%TYPE;
86: l_dummy varchar2(1) := null ;

Line 83: l_effective_end_date ben_optip_f.effective_end_date%TYPE;

79: -- Declare cursors and local variables
80: --
81: l_optip_id ben_optip_f.optip_id%TYPE;
82: l_effective_start_date ben_optip_f.effective_start_date%TYPE;
83: l_effective_end_date ben_optip_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_opt_pltyp_in_pgm';
85: l_object_version_number ben_optip_f.object_version_number%TYPE;
86: l_dummy varchar2(1) := null ;
87: l_future_optip_id ben_optip_f.optip_id%TYPE;

Line 85: l_object_version_number ben_optip_f.object_version_number%TYPE;

81: l_optip_id ben_optip_f.optip_id%TYPE;
82: l_effective_start_date ben_optip_f.effective_start_date%TYPE;
83: l_effective_end_date ben_optip_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_opt_pltyp_in_pgm';
85: l_object_version_number ben_optip_f.object_version_number%TYPE;
86: l_dummy varchar2(1) := null ;
87: l_future_optip_id ben_optip_f.optip_id%TYPE;
88: --
89: begin

Line 87: l_future_optip_id ben_optip_f.optip_id%TYPE;

83: l_effective_end_date ben_optip_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_opt_pltyp_in_pgm';
85: l_object_version_number ben_optip_f.object_version_number%TYPE;
86: l_dummy varchar2(1) := null ;
87: l_future_optip_id ben_optip_f.optip_id%TYPE;
88: --
89: begin
90: --
91: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 122: update ben_optip_f

118: --
119: if c_future_optip%found then
120: --
121: hr_utility.set_location('Future record exists. we need to extend the record ', 20 ) ;
122: update ben_optip_f
123: set effective_start_date = p_effective_date
124: where optip_id = l_future_optip_id ;
125: hr_utility.set_location('exiting from '||l_proc,25);
126: close c_future_optip ;

Line 407: l_object_version_number ben_optip_f.object_version_number%TYPE;

403: --
404: -- Declare cursors and local variables
405: --
406: l_proc varchar2(72) := g_package||'update_opt_pltyp_in_pgm';
407: l_object_version_number ben_optip_f.object_version_number%TYPE;
408: l_effective_start_date ben_optip_f.effective_start_date%TYPE;
409: l_effective_end_date ben_optip_f.effective_end_date%TYPE;
410: --
411: begin

Line 408: l_effective_start_date ben_optip_f.effective_start_date%TYPE;

404: -- Declare cursors and local variables
405: --
406: l_proc varchar2(72) := g_package||'update_opt_pltyp_in_pgm';
407: l_object_version_number ben_optip_f.object_version_number%TYPE;
408: l_effective_start_date ben_optip_f.effective_start_date%TYPE;
409: l_effective_end_date ben_optip_f.effective_end_date%TYPE;
410: --
411: begin
412: --

Line 409: l_effective_end_date ben_optip_f.effective_end_date%TYPE;

405: --
406: l_proc varchar2(72) := g_package||'update_opt_pltyp_in_pgm';
407: l_object_version_number ben_optip_f.object_version_number%TYPE;
408: l_effective_start_date ben_optip_f.effective_start_date%TYPE;
409: l_effective_end_date ben_optip_f.effective_end_date%TYPE;
410: --
411: begin
412: --
413: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 662: l_object_version_number ben_optip_f.object_version_number%TYPE;

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

Line 663: l_effective_start_date ben_optip_f.effective_start_date%TYPE;

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

Line 664: l_effective_end_date ben_optip_f.effective_end_date%TYPE;

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