85: --
86: procedure cobcep_getdets
87: (p_business_group_id in number
88: ,p_effective_date in date
89: ,p_pgm_id in number default hr_api.g_number
90: ,p_pl_id in number default hr_api.g_number
91: ,p_oipl_id in number default hr_api.g_number
92: ,p_plip_id in number default hr_api.g_number
93: ,p_ptip_id in number default hr_api.g_number
86: procedure cobcep_getdets
87: (p_business_group_id in number
88: ,p_effective_date in date
89: ,p_pgm_id in number default hr_api.g_number
90: ,p_pl_id in number default hr_api.g_number
91: ,p_oipl_id in number default hr_api.g_number
92: ,p_plip_id in number default hr_api.g_number
93: ,p_ptip_id in number default hr_api.g_number
94: --
87: (p_business_group_id in number
88: ,p_effective_date in date
89: ,p_pgm_id in number default hr_api.g_number
90: ,p_pl_id in number default hr_api.g_number
91: ,p_oipl_id in number default hr_api.g_number
92: ,p_plip_id in number default hr_api.g_number
93: ,p_ptip_id in number default hr_api.g_number
94: --
95: ,p_inst_set out nocopy ben_elp_cache.g_cobcep_cache
88: ,p_effective_date in date
89: ,p_pgm_id in number default hr_api.g_number
90: ,p_pl_id in number default hr_api.g_number
91: ,p_oipl_id in number default hr_api.g_number
92: ,p_plip_id in number default hr_api.g_number
93: ,p_ptip_id in number default hr_api.g_number
94: --
95: ,p_inst_set out nocopy ben_elp_cache.g_cobcep_cache
96: ,p_inst_count out nocopy number
89: ,p_pgm_id in number default hr_api.g_number
90: ,p_pl_id in number default hr_api.g_number
91: ,p_oipl_id in number default hr_api.g_number
92: ,p_plip_id in number default hr_api.g_number
93: ,p_ptip_id in number default hr_api.g_number
94: --
95: ,p_inst_set out nocopy ben_elp_cache.g_cobcep_cache
96: ,p_inst_count out nocopy number
97: );
99: type g_cobcep_odcache is varray(1000000) of g_cobcep_cache_rec;
100: --
101: procedure cobcep_odgetdets
102: (p_effective_date in date
103: ,p_pgm_id in number default hr_api.g_number
104: ,p_pl_id in number default hr_api.g_number
105: ,p_oipl_id in number default hr_api.g_number
106: ,p_plip_id in number default hr_api.g_number
107: ,p_ptip_id in number default hr_api.g_number
100: --
101: procedure cobcep_odgetdets
102: (p_effective_date in date
103: ,p_pgm_id in number default hr_api.g_number
104: ,p_pl_id in number default hr_api.g_number
105: ,p_oipl_id in number default hr_api.g_number
106: ,p_plip_id in number default hr_api.g_number
107: ,p_ptip_id in number default hr_api.g_number
108: --
101: procedure cobcep_odgetdets
102: (p_effective_date in date
103: ,p_pgm_id in number default hr_api.g_number
104: ,p_pl_id in number default hr_api.g_number
105: ,p_oipl_id in number default hr_api.g_number
106: ,p_plip_id in number default hr_api.g_number
107: ,p_ptip_id in number default hr_api.g_number
108: --
109: ,p_inst_set in out nocopy ben_elp_cache.g_cobcep_odcache
102: (p_effective_date in date
103: ,p_pgm_id in number default hr_api.g_number
104: ,p_pl_id in number default hr_api.g_number
105: ,p_oipl_id in number default hr_api.g_number
106: ,p_plip_id in number default hr_api.g_number
107: ,p_ptip_id in number default hr_api.g_number
108: --
109: ,p_inst_set in out nocopy ben_elp_cache.g_cobcep_odcache
110: );
103: ,p_pgm_id in number default hr_api.g_number
104: ,p_pl_id in number default hr_api.g_number
105: ,p_oipl_id in number default hr_api.g_number
106: ,p_plip_id in number default hr_api.g_number
107: ,p_ptip_id in number default hr_api.g_number
108: --
109: ,p_inst_set in out nocopy ben_elp_cache.g_cobcep_odcache
110: );
111: --
147: --
148: procedure elpelc_getdets
149: (p_business_group_id in number
150: ,p_effective_date in date
151: ,p_eligy_prfl_id in number default hr_api.g_number
152: ,p_cache_code in varchar2 default hr_api.g_varchar2
153: --
154: ,p_inst_set out nocopy ben_elp_cache.g_elpelc_cache
155: ,p_inst_count out nocopy number
148: procedure elpelc_getdets
149: (p_business_group_id in number
150: ,p_effective_date in date
151: ,p_eligy_prfl_id in number default hr_api.g_number
152: ,p_cache_code in varchar2 default hr_api.g_varchar2
153: --
154: ,p_inst_set out nocopy ben_elp_cache.g_elpelc_cache
155: ,p_inst_count out nocopy number
156: )