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 1525: l_plnrow ben_cobj_cache.g_pl_inst_row;

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

Line 1526: l_oiplrow ben_cobj_cache.g_oipl_inst_row;

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

Line 1733: ben_cobj_cache.get_pl_dets

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

Line 1747: ben_cobj_cache.get_oipl_dets

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

Line 1793: ben_cobj_cache.get_oipl_dets

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

Line 2248: l_pl_rec ben_cobj_cache.g_pl_inst_row;

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

Line 2255: ben_cobj_cache.get_pl_dets

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

Line 2946: l_pl_rec ben_cobj_cache.g_pl_inst_row;

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

Line 2950: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

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

Line 2954: l_plip_rec ben_cobj_cache.g_plip_inst_row;

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

Line 2958: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;

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

Line 3394: ben_cobj_cache.clear_down_cache;

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

Line 3404: ben_cobj_cache.get_pl_dets

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

Line 3418: ben_cobj_cache.get_plip_dets

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

Line 3435: ben_cobj_cache.get_ptip_dets

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

Line 3452: ben_cobj_cache.get_oipl_dets

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