DBA Data[Home] [Help]

APPS.BEN_PEN_BUS dependencies on BEN_COBJ_CACHE

Line 885: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;

881: l_api_updating BOOLEAN;
882: l_level VARCHAR2 (30) := 'PL';
883: l_code VARCHAR2 (30);
884: --
885: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
886: l_pl_rec ben_cobj_cache.g_pl_inst_row;
887: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
888: l_benefit_name ben_pl_typ_f.NAME%TYPE;
889: --

Line 886: l_pl_rec ben_cobj_cache.g_pl_inst_row;

882: l_level VARCHAR2 (30) := 'PL';
883: l_code VARCHAR2 (30);
884: --
885: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
886: l_pl_rec ben_cobj_cache.g_pl_inst_row;
887: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
888: l_benefit_name ben_pl_typ_f.NAME%TYPE;
889: --
890: l_lf_evt_ocrd_dt DATE;

Line 887: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;

883: l_code VARCHAR2 (30);
884: --
885: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
886: l_pl_rec ben_cobj_cache.g_pl_inst_row;
887: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
888: l_benefit_name ben_pl_typ_f.NAME%TYPE;
889: --
890: l_lf_evt_ocrd_dt DATE;
891: --

Line 1027: ben_cobj_cache.get_pl_dets (p_business_group_id => p_business_group_id,

1023: hr_utility.set_location ('Entering:' || l_proc, 5);
1024: --
1025: hr_utility.set_location ('Checking court order at PEN level', 12);
1026: --
1027: ben_cobj_cache.get_pl_dets (p_business_group_id => p_business_group_id,
1028: p_effective_date => p_effective_date,
1029: p_pl_id => p_pl_id,
1030: p_inst_row => l_pl_rec
1031: );

Line 1044: ben_cobj_cache.get_pgm_dets

1040: THEN
1041: --
1042: -- find the level from the program
1043: --
1044: ben_cobj_cache.get_pgm_dets
1045: (p_business_group_id => p_business_group_id,
1046: p_effective_date => p_effective_date,
1047: p_pgm_id => p_pgm_id,
1048: p_inst_row => l_pgm_rec

Line 1080: ben_cobj_cache.get_ptip_dets

1076: --
1077: ELSIF l_level = 'PTIP'
1078: THEN
1079: --
1080: ben_cobj_cache.get_ptip_dets
1081: (p_business_group_id => p_business_group_id,
1082: p_effective_date => p_effective_date,
1083: p_ptip_id => p_ptip_id,
1084: p_inst_row => l_ptip_rec

Line 1526: l_plnrow ben_cobj_cache.g_pl_inst_row;

1522: l_dup_ptip_id_list ben_cache.IdType;
1523: l_dup_pl_typ_id_list ben_cache.IdType;
1524: l_dup_pl_id_list ben_cache.IdType;
1525: --
1526: l_plnrow ben_cobj_cache.g_pl_inst_row;
1527: l_oiplrow ben_cobj_cache.g_oipl_inst_row;
1528: --
1529: -- Cursor Declaration.
1530: --

Line 1527: l_oiplrow ben_cobj_cache.g_oipl_inst_row;

1523: l_dup_pl_typ_id_list ben_cache.IdType;
1524: l_dup_pl_id_list ben_cache.IdType;
1525: --
1526: l_plnrow ben_cobj_cache.g_pl_inst_row;
1527: l_oiplrow ben_cobj_cache.g_oipl_inst_row;
1528: --
1529: -- Cursor Declaration.
1530: --
1531: -- Previous enrollment means previous enrollment, so we check that the

Line 1734: ben_cobj_cache.get_pl_dets

1730: g_comp_obj_cnt := g_comp_obj_cnt+1;
1731: --
1732: if g_enrt_tbl(g_comp_obj_cnt).pl_id is not null then
1733: --
1734: ben_cobj_cache.get_pl_dets
1735: (p_business_group_id => p_business_group_id
1736: ,p_effective_date => p_effective_date
1737: ,p_pl_id => g_enrt_tbl(g_comp_obj_cnt).pl_id
1738: ,p_inst_row => l_plnrow

Line 1748: ben_cobj_cache.get_oipl_dets

1744: end if;
1745: --
1746: if g_enrt_tbl(g_comp_obj_cnt).oipl_id is not null then
1747: --
1748: ben_cobj_cache.get_oipl_dets
1749: (p_business_group_id => p_business_group_id
1750: ,p_effective_date => p_effective_date
1751: ,p_oipl_id => g_enrt_tbl(g_comp_obj_cnt).oipl_id
1752: ,p_inst_row => l_oiplrow

Line 1794: ben_cobj_cache.get_oipl_dets

1790: g_comp_obj_cnt := g_comp_obj_cnt+1;
1791: --
1792: if g_enrt_tbl(g_comp_obj_cnt).oipl_id is not null then
1793: --
1794: ben_cobj_cache.get_oipl_dets
1795: (p_business_group_id => p_business_group_id
1796: ,p_effective_date => p_effective_date
1797: ,p_oipl_id => g_enrt_tbl(g_comp_obj_cnt).oipl_id
1798: ,p_inst_row => l_oiplrow

Line 2249: l_pl_rec ben_cobj_cache.g_pl_inst_row;

2245: )
2246: return varchar2
2247: is
2248: --
2249: l_pl_rec ben_cobj_cache.g_pl_inst_row;
2250: /*
2251: l_pl_rec ben_pl_f%rowtype;
2252: */
2253: --

Line 2256: ben_cobj_cache.get_pl_dets

2252: */
2253: --
2254: begin
2255: --
2256: ben_cobj_cache.get_pl_dets
2257: (p_business_group_id => p_business_group_id
2258: ,p_effective_date => p_effective_date
2259: ,p_pl_id => p_pl_id
2260: ,p_inst_row => l_pl_rec

Line 2947: l_pl_rec ben_cobj_cache.g_pl_inst_row;

2943: l_ptip_tbl_ct number := g_ptip_tbl.count;
2944: l_plan_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683
2945: l_option_name ben_opt_f.name%type; -- UTF8 Change Bug 2254683
2946: --
2947: l_pl_rec ben_cobj_cache.g_pl_inst_row;
2948: /*
2949: l_pl_rec ben_pl_f%rowtype;
2950: */
2951: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

Line 2951: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

2947: l_pl_rec ben_cobj_cache.g_pl_inst_row;
2948: /*
2949: l_pl_rec ben_pl_f%rowtype;
2950: */
2951: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2952: /*
2953: l_oipl_rec ben_oipl_f%rowtype;
2954: */
2955: l_plip_rec ben_cobj_cache.g_plip_inst_row;

Line 2955: l_plip_rec ben_cobj_cache.g_plip_inst_row;

2951: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2952: /*
2953: l_oipl_rec ben_oipl_f%rowtype;
2954: */
2955: l_plip_rec ben_cobj_cache.g_plip_inst_row;
2956: /*
2957: l_plip_rec ben_plip_f%rowtype;
2958: */
2959: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;

Line 2959: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;

2955: l_plip_rec ben_cobj_cache.g_plip_inst_row;
2956: /*
2957: l_plip_rec ben_plip_f%rowtype;
2958: */
2959: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
2960: /*
2961: l_ptip_rec ben_ptip_f%rowtype;
2962: */
2963: l_erl varchar2(30);

Line 3395: ben_cobj_cache.clear_down_cache;

3391: -- same plan id and option id.
3392: --
3393: l_step := 80;
3394: -- Bug 6741391
3395: ben_cobj_cache.clear_down_cache;
3396: -- Bug 6741391
3397: for i in 1..g_comp_obj_cnt loop
3398: --
3399: if g_enrt_tbl(i).prtt_enrt_rslt_id is not null and

Line 3405: ben_cobj_cache.get_pl_dets

3401: --
3402: -- RCHASE - Bug#1412801 - Moved post election edit rule from insert/update
3403: -- RCHASE validation calls to multi-row edit
3404: --
3405: ben_cobj_cache.get_pl_dets
3406: (p_business_group_id => p_business_group_id
3407: ,p_effective_date => p_effective_date
3408: ,p_pl_id => g_enrt_tbl(i).pl_id
3409: ,p_inst_row => l_pl_rec

Line 3419: ben_cobj_cache.get_plip_dets

3415: */
3416: --
3417: if g_enrt_tbl(i).plip_id is not null then
3418: --
3419: ben_cobj_cache.get_plip_dets
3420: (p_business_group_id => p_business_group_id
3421: ,p_effective_date => p_effective_date
3422: ,p_plip_id => g_enrt_tbl(i).plip_id
3423: ,p_inst_row => l_plip_rec

Line 3436: ben_cobj_cache.get_ptip_dets

3432: end if;
3433: --
3434: if g_enrt_tbl(i).ptip_id is not null then
3435: --
3436: ben_cobj_cache.get_ptip_dets
3437: (p_business_group_id => p_business_group_id
3438: ,p_effective_date => p_effective_date
3439: ,p_ptip_id => g_enrt_tbl(i).ptip_id
3440: ,p_inst_row => l_ptip_rec

Line 3453: ben_cobj_cache.get_oipl_dets

3449: end if;
3450: --
3451: if g_enrt_tbl(i).oipl_id is not null then
3452: --
3453: ben_cobj_cache.get_oipl_dets
3454: (p_business_group_id => p_business_group_id
3455: ,p_effective_date => p_effective_date
3456: ,p_oipl_id => g_enrt_tbl(i).oipl_id
3457: ,p_inst_row => l_oipl_rec