APPS.BEN_CWB_EMP_ELIG dependencies on BEN_CWB_PERSON_RATES_API

Line 158: ben_cwb_person_rates_api.update_person_rate

154: IF p_pl_elig_flag = 'Y' THEN
155: OPEN c_person_rate(p_o1_person_rate_id);
156: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
157: CLOSE c_person_rate;
158: ben_cwb_person_rates_api.update_person_rate
159: (
160: p_group_per_in_ler_id => p_group_per_in_ler_id
161: ,p_pl_id => p_o1_pl_id
162: ,p_oipl_id => p_o1_oipl_id

Line 184: ben_cwb_person_rates_api.update_person_rate

180: ELSE
181: l_inelig_rsn_cd := NULL;
182: l_ws_start_date := hr_api.g_date;
183: END IF;
184: ben_cwb_person_rates_api.update_person_rate
185: (
186: p_group_per_in_ler_id => p_group_per_in_ler_id
187: ,p_pl_id => p_o1_pl_id
188: ,p_oipl_id => p_o1_oipl_id

Line 202: ben_cwb_person_rates_api.update_person_rate

198: OPEN c_person_rate(p_pl_person_rate_id);
199: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
200: CLOSE c_person_rate;
201: IF l_elig_flag = 'N' AND p_o1_elig_flag = 'Y' THEN
202: ben_cwb_person_rates_api.update_person_rate
203: (
204: p_group_per_in_ler_id => p_group_per_in_ler_id
205: ,p_pl_id => p_pl_pl_id
206: ,p_oipl_id => p_pl_oipl_id

Line 232: ben_cwb_person_rates_api.update_person_rate

228: IF p_pl_elig_flag = 'Y' THEN
229: OPEN c_person_rate(p_o2_person_rate_id);
230: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
231: CLOSE c_person_rate;
232: ben_cwb_person_rates_api.update_person_rate
233: (
234: p_group_per_in_ler_id => p_group_per_in_ler_id
235: ,p_pl_id => p_o2_pl_id
236: ,p_oipl_id => p_o2_oipl_id

Line 258: ben_cwb_person_rates_api.update_person_rate

254: ELSE
255: l_inelig_rsn_cd := NULL;
256: l_ws_start_date := hr_api.g_date;
257: END IF;
258: ben_cwb_person_rates_api.update_person_rate
259: (
260: p_group_per_in_ler_id => p_group_per_in_ler_id
261: ,p_pl_id => p_o2_pl_id
262: ,p_oipl_id => p_o2_oipl_id

Line 276: ben_cwb_person_rates_api.update_person_rate

272: OPEN c_person_rate(p_pl_person_rate_id);
273: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
274: CLOSE c_person_rate;
275: IF l_elig_flag = 'N' AND p_o2_elig_flag = 'Y' THEN
276: ben_cwb_person_rates_api.update_person_rate
277: (
278: p_group_per_in_ler_id => p_group_per_in_ler_id
279: ,p_pl_id => p_pl_pl_id
280: ,p_oipl_id => p_pl_oipl_id

Line 306: ben_cwb_person_rates_api.update_person_rate

302: IF p_pl_elig_flag = 'Y' THEN
303: OPEN c_person_rate(p_o3_person_rate_id);
304: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
305: CLOSE c_person_rate;
306: ben_cwb_person_rates_api.update_person_rate
307: (
308: p_group_per_in_ler_id => p_group_per_in_ler_id
309: ,p_pl_id => p_o3_pl_id
310: ,p_oipl_id => p_o3_oipl_id

Line 332: ben_cwb_person_rates_api.update_person_rate

328: ELSE
329: l_inelig_rsn_cd := NULL;
330: l_ws_start_date := hr_api.g_date;
331: END IF;
332: ben_cwb_person_rates_api.update_person_rate
333: (
334: p_group_per_in_ler_id => p_group_per_in_ler_id
335: ,p_pl_id => p_o3_pl_id
336: ,p_oipl_id => p_o3_oipl_id

Line 350: ben_cwb_person_rates_api.update_person_rate

346: OPEN c_person_rate(p_pl_person_rate_id);
347: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
348: CLOSE c_person_rate;
349: IF l_elig_flag = 'N' AND p_o3_elig_flag = 'Y' THEN
350: ben_cwb_person_rates_api.update_person_rate
351: (
352: p_group_per_in_ler_id => p_group_per_in_ler_id
353: ,p_pl_id => p_pl_pl_id
354: ,p_oipl_id => p_pl_oipl_id

Line 380: ben_cwb_person_rates_api.update_person_rate

376: IF p_pl_elig_flag = 'Y' THEN
377: OPEN c_person_rate(p_o4_person_rate_id);
378: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
379: CLOSE c_person_rate;
380: ben_cwb_person_rates_api.update_person_rate
381: (
382: p_group_per_in_ler_id => p_group_per_in_ler_id
383: ,p_pl_id => p_o4_pl_id
384: ,p_oipl_id => p_o4_oipl_id

Line 406: ben_cwb_person_rates_api.update_person_rate

402: ELSE
403: l_inelig_rsn_cd := NULL;
404: l_ws_start_date := hr_api.g_date;
405: END IF;
406: ben_cwb_person_rates_api.update_person_rate
407: (
408: p_group_per_in_ler_id => p_group_per_in_ler_id
409: ,p_pl_id => p_o4_pl_id
410: ,p_oipl_id => p_o4_oipl_id

Line 424: ben_cwb_person_rates_api.update_person_rate

420: OPEN c_person_rate(p_pl_person_rate_id);
421: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
422: CLOSE c_person_rate;
423: IF l_elig_flag = 'N' AND p_o4_elig_flag = 'Y' THEN
424: ben_cwb_person_rates_api.update_person_rate
425: (
426: p_group_per_in_ler_id => p_group_per_in_ler_id
427: ,p_pl_id => p_pl_pl_id
428: ,p_oipl_id => p_pl_oipl_id

Line 456: ben_cwb_person_rates_api.update_person_rate

452: -- Need to call the routine which deletes all assignment changes
453: -- as the person becomes ineligible.
454: END IF;
455:
456: ben_cwb_person_rates_api.update_person_rate
457: (
458: p_group_per_in_ler_id => p_group_per_in_ler_id
459: ,p_pl_id => p_pl_pl_id
460: ,p_oipl_id => p_pl_oipl_id

Line 481: ben_cwb_person_rates_api.update_person_rate

477: IF p_o1_oipl_id IS NOT NULL THEN
478: OPEN c_person_rate(p_o1_person_rate_id);
479: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
480: CLOSE c_person_rate;
481: ben_cwb_person_rates_api.update_person_rate
482: (
483: p_group_per_in_ler_id => p_group_per_in_ler_id
484: ,p_pl_id => p_o1_pl_id
485: ,p_oipl_id => p_o1_oipl_id

Line 504: ben_cwb_person_rates_api.update_person_rate

500: IF p_o2_oipl_id IS NOT NULL THEN
501: OPEN c_person_rate(p_o2_person_rate_id);
502: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
503: CLOSE c_person_rate;
504: ben_cwb_person_rates_api.update_person_rate
505: (
506: p_group_per_in_ler_id => p_group_per_in_ler_id
507: ,p_pl_id => p_o2_pl_id
508: ,p_oipl_id => p_o2_oipl_id

Line 527: ben_cwb_person_rates_api.update_person_rate

523: IF p_o3_oipl_id IS NOT NULL THEN
524: OPEN c_person_rate(p_o3_person_rate_id);
525: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
526: CLOSE c_person_rate;
527: ben_cwb_person_rates_api.update_person_rate
528: (
529: p_group_per_in_ler_id => p_group_per_in_ler_id
530: ,p_pl_id => p_o3_pl_id
531: ,p_oipl_id => p_o3_oipl_id

Line 550: ben_cwb_person_rates_api.update_person_rate

546: IF p_o4_oipl_id IS NOT NULL THEN
547: OPEN c_person_rate(p_o4_person_rate_id);
548: FETCH c_person_rate INTO l_object_version_number, l_ws_val,l_elig_flag,l_ws_start_date;
549: CLOSE c_person_rate;
550: ben_cwb_person_rates_api.update_person_rate
551: (
552: p_group_per_in_ler_id => p_group_per_in_ler_id
553: ,p_pl_id => p_o4_pl_id
554: ,p_oipl_id => p_o4_oipl_id