1224: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).plip_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1225: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).pl_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1226: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).oipl_id'||p_comp_obj_tree(l_treeele_num).oipl_id,10);
1227:
1228: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1229: ben_determine_eligibility2.g_cache_first_inelig_object
1230: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1231: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1232:
1225: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).pl_id'||p_comp_obj_tree(l_treeele_num).plip_id,10);
1226: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).oipl_id'||p_comp_obj_tree(l_treeele_num).oipl_id,10);
1227:
1228: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1229: ben_determine_eligibility2.g_cache_first_inelig_object
1230: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1231: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1232:
1233: if p_comp_obj_tree(l_treeele_num).ptip_id is not null then
1226: hr_utility.set_location('p_comp_obj_tree(l_treeele_num).oipl_id'||p_comp_obj_tree(l_treeele_num).oipl_id,10);
1227:
1228: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1229: ben_determine_eligibility2.g_cache_first_inelig_object
1230: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1231: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1232:
1233: if p_comp_obj_tree(l_treeele_num).ptip_id is not null then
1234: ben_determine_eligibility2.g_cache_first_inelig_object
1227:
1228: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1229: ben_determine_eligibility2.g_cache_first_inelig_object
1230: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1231: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1232:
1233: if p_comp_obj_tree(l_treeele_num).ptip_id is not null then
1234: ben_determine_eligibility2.g_cache_first_inelig_object
1235: (ben_determine_eligibility2.g_cache_first_inelig_object.last).ptip_id :=
1230: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1231: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1232:
1233: if p_comp_obj_tree(l_treeele_num).ptip_id is not null then
1234: ben_determine_eligibility2.g_cache_first_inelig_object
1235: (ben_determine_eligibility2.g_cache_first_inelig_object.last).ptip_id :=
1236: p_comp_obj_tree(l_treeele_num).ptip_id;
1237: ben_determine_eligibility2.g_cache_first_inelig_object
1238: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1231: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1232:
1233: if p_comp_obj_tree(l_treeele_num).ptip_id is not null then
1234: ben_determine_eligibility2.g_cache_first_inelig_object
1235: (ben_determine_eligibility2.g_cache_first_inelig_object.last).ptip_id :=
1236: p_comp_obj_tree(l_treeele_num).ptip_id;
1237: ben_determine_eligibility2.g_cache_first_inelig_object
1238: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1239: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1233: if p_comp_obj_tree(l_treeele_num).ptip_id is not null then
1234: ben_determine_eligibility2.g_cache_first_inelig_object
1235: (ben_determine_eligibility2.g_cache_first_inelig_object.last).ptip_id :=
1236: p_comp_obj_tree(l_treeele_num).ptip_id;
1237: ben_determine_eligibility2.g_cache_first_inelig_object
1238: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1239: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1240:
1241: elsif p_comp_obj_tree(l_treeele_num).plip_id is not null then
1234: ben_determine_eligibility2.g_cache_first_inelig_object
1235: (ben_determine_eligibility2.g_cache_first_inelig_object.last).ptip_id :=
1236: p_comp_obj_tree(l_treeele_num).ptip_id;
1237: ben_determine_eligibility2.g_cache_first_inelig_object
1238: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1239: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1240:
1241: elsif p_comp_obj_tree(l_treeele_num).plip_id is not null then
1242: ben_determine_eligibility2.g_cache_first_inelig_object
1238: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1239: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1240:
1241: elsif p_comp_obj_tree(l_treeele_num).plip_id is not null then
1242: ben_determine_eligibility2.g_cache_first_inelig_object
1243: (ben_determine_eligibility2.g_cache_first_inelig_object.last).plip_id :=
1244: p_comp_obj_tree(l_treeele_num).plip_id;
1245: ben_determine_eligibility2.g_cache_first_inelig_object
1246: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1239: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1240:
1241: elsif p_comp_obj_tree(l_treeele_num).plip_id is not null then
1242: ben_determine_eligibility2.g_cache_first_inelig_object
1243: (ben_determine_eligibility2.g_cache_first_inelig_object.last).plip_id :=
1244: p_comp_obj_tree(l_treeele_num).plip_id;
1245: ben_determine_eligibility2.g_cache_first_inelig_object
1246: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1247: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1241: elsif p_comp_obj_tree(l_treeele_num).plip_id is not null then
1242: ben_determine_eligibility2.g_cache_first_inelig_object
1243: (ben_determine_eligibility2.g_cache_first_inelig_object.last).plip_id :=
1244: p_comp_obj_tree(l_treeele_num).plip_id;
1245: ben_determine_eligibility2.g_cache_first_inelig_object
1246: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1247: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1248:
1249: elsif p_comp_obj_tree(l_treeele_num).pl_id is not null then
1242: ben_determine_eligibility2.g_cache_first_inelig_object
1243: (ben_determine_eligibility2.g_cache_first_inelig_object.last).plip_id :=
1244: p_comp_obj_tree(l_treeele_num).plip_id;
1245: ben_determine_eligibility2.g_cache_first_inelig_object
1246: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1247: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1248:
1249: elsif p_comp_obj_tree(l_treeele_num).pl_id is not null then
1250: ben_determine_eligibility2.g_cache_first_inelig_object
1246: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1247: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1248:
1249: elsif p_comp_obj_tree(l_treeele_num).pl_id is not null then
1250: ben_determine_eligibility2.g_cache_first_inelig_object
1251: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1252: p_comp_obj_tree(l_treeele_num).pl_id;
1253: ben_determine_eligibility2.g_cache_first_inelig_object
1254: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1247: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1248:
1249: elsif p_comp_obj_tree(l_treeele_num).pl_id is not null then
1250: ben_determine_eligibility2.g_cache_first_inelig_object
1251: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1252: p_comp_obj_tree(l_treeele_num).pl_id;
1253: ben_determine_eligibility2.g_cache_first_inelig_object
1254: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1255: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1249: elsif p_comp_obj_tree(l_treeele_num).pl_id is not null then
1250: ben_determine_eligibility2.g_cache_first_inelig_object
1251: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1252: p_comp_obj_tree(l_treeele_num).pl_id;
1253: ben_determine_eligibility2.g_cache_first_inelig_object
1254: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1255: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1256:
1257: end if;
1250: ben_determine_eligibility2.g_cache_first_inelig_object
1251: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1252: p_comp_obj_tree(l_treeele_num).pl_id;
1253: ben_determine_eligibility2.g_cache_first_inelig_object
1254: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1255: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1256:
1257: end if;
1258: end if;
1389: --If the Compensation object is first ineligible or still ineligible then inserting the
1390: --comp object into globle variables to check whether any future records are there in
1391: -- ben_elig_per_f and ben_elig_opt_f tables of the same compensation object.
1392: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1393: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1394: ben_determine_eligibility2.g_cache_first_inelig_object
1395: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1396: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1397:
1390: --comp object into globle variables to check whether any future records are there in
1391: -- ben_elig_per_f and ben_elig_opt_f tables of the same compensation object.
1392: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1393: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1394: ben_determine_eligibility2.g_cache_first_inelig_object
1395: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1396: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1397:
1398: if p_comp_obj_tree(l_treeele_num).plip_id is not null then
1391: -- ben_elig_per_f and ben_elig_opt_f tables of the same compensation object.
1392: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1393: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1394: ben_determine_eligibility2.g_cache_first_inelig_object
1395: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1396: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1397:
1398: if p_comp_obj_tree(l_treeele_num).plip_id is not null then
1399: ben_determine_eligibility2.g_cache_first_inelig_object
1392: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1393: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1394: ben_determine_eligibility2.g_cache_first_inelig_object
1395: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1396: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1397:
1398: if p_comp_obj_tree(l_treeele_num).plip_id is not null then
1399: ben_determine_eligibility2.g_cache_first_inelig_object
1400: (ben_determine_eligibility2.g_cache_first_inelig_object.last).plip_id :=
1395: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1396: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1397:
1398: if p_comp_obj_tree(l_treeele_num).plip_id is not null then
1399: ben_determine_eligibility2.g_cache_first_inelig_object
1400: (ben_determine_eligibility2.g_cache_first_inelig_object.last).plip_id :=
1401: p_comp_obj_tree(l_treeele_num).plip_id;
1402: ben_determine_eligibility2.g_cache_first_inelig_object
1403: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1396: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1397:
1398: if p_comp_obj_tree(l_treeele_num).plip_id is not null then
1399: ben_determine_eligibility2.g_cache_first_inelig_object
1400: (ben_determine_eligibility2.g_cache_first_inelig_object.last).plip_id :=
1401: p_comp_obj_tree(l_treeele_num).plip_id;
1402: ben_determine_eligibility2.g_cache_first_inelig_object
1403: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1404: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1398: if p_comp_obj_tree(l_treeele_num).plip_id is not null then
1399: ben_determine_eligibility2.g_cache_first_inelig_object
1400: (ben_determine_eligibility2.g_cache_first_inelig_object.last).plip_id :=
1401: p_comp_obj_tree(l_treeele_num).plip_id;
1402: ben_determine_eligibility2.g_cache_first_inelig_object
1403: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1404: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1405:
1406: elsif p_comp_obj_tree(l_treeele_num).pl_id is not null then
1399: ben_determine_eligibility2.g_cache_first_inelig_object
1400: (ben_determine_eligibility2.g_cache_first_inelig_object.last).plip_id :=
1401: p_comp_obj_tree(l_treeele_num).plip_id;
1402: ben_determine_eligibility2.g_cache_first_inelig_object
1403: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1404: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1405:
1406: elsif p_comp_obj_tree(l_treeele_num).pl_id is not null then
1407: ben_determine_eligibility2.g_cache_first_inelig_object
1403: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1404: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1405:
1406: elsif p_comp_obj_tree(l_treeele_num).pl_id is not null then
1407: ben_determine_eligibility2.g_cache_first_inelig_object
1408: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1409: p_comp_obj_tree(l_treeele_num).pl_id;
1410: ben_determine_eligibility2.g_cache_first_inelig_object
1411: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1404: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1405:
1406: elsif p_comp_obj_tree(l_treeele_num).pl_id is not null then
1407: ben_determine_eligibility2.g_cache_first_inelig_object
1408: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1409: p_comp_obj_tree(l_treeele_num).pl_id;
1410: ben_determine_eligibility2.g_cache_first_inelig_object
1411: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1412: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1406: elsif p_comp_obj_tree(l_treeele_num).pl_id is not null then
1407: ben_determine_eligibility2.g_cache_first_inelig_object
1408: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1409: p_comp_obj_tree(l_treeele_num).pl_id;
1410: ben_determine_eligibility2.g_cache_first_inelig_object
1411: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1412: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1413:
1414: end if;
1407: ben_determine_eligibility2.g_cache_first_inelig_object
1408: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1409: p_comp_obj_tree(l_treeele_num).pl_id;
1410: ben_determine_eligibility2.g_cache_first_inelig_object
1411: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1412: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1413:
1414: end if;
1415: end if;
1578: --If the Compensation object is first ineligible or still ineligible then inserting the
1579: --comp object into globle variables to check whether any future records are there in
1580: -- ben_elig_per_f and ben_elig_opt_f tables of the same compensation object.
1581: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1582: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1583: ben_determine_eligibility2.g_cache_first_inelig_object
1584: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1585: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1586:
1579: --comp object into globle variables to check whether any future records are there in
1580: -- ben_elig_per_f and ben_elig_opt_f tables of the same compensation object.
1581: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1582: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1583: ben_determine_eligibility2.g_cache_first_inelig_object
1584: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1585: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1586:
1587: if p_comp_obj_tree(l_treeele_num).pl_id is not null then
1580: -- ben_elig_per_f and ben_elig_opt_f tables of the same compensation object.
1581: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1582: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1583: ben_determine_eligibility2.g_cache_first_inelig_object
1584: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1585: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1586:
1587: if p_comp_obj_tree(l_treeele_num).pl_id is not null then
1588: ben_determine_eligibility2.g_cache_first_inelig_object
1581: if p_comp_obj_tree(l_treeele_num).oipl_id is null then
1582: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
1583: ben_determine_eligibility2.g_cache_first_inelig_object
1584: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1585: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1586:
1587: if p_comp_obj_tree(l_treeele_num).pl_id is not null then
1588: ben_determine_eligibility2.g_cache_first_inelig_object
1589: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1584: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
1585: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1586:
1587: if p_comp_obj_tree(l_treeele_num).pl_id is not null then
1588: ben_determine_eligibility2.g_cache_first_inelig_object
1589: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1590: p_comp_obj_tree(l_treeele_num).pl_id;
1591: ben_determine_eligibility2.g_cache_first_inelig_object
1592: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1585: ben_determine_eligibility2.g_cache_first_inelig_object.last;
1586:
1587: if p_comp_obj_tree(l_treeele_num).pl_id is not null then
1588: ben_determine_eligibility2.g_cache_first_inelig_object
1589: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1590: p_comp_obj_tree(l_treeele_num).pl_id;
1591: ben_determine_eligibility2.g_cache_first_inelig_object
1592: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1593: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1587: if p_comp_obj_tree(l_treeele_num).pl_id is not null then
1588: ben_determine_eligibility2.g_cache_first_inelig_object
1589: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1590: p_comp_obj_tree(l_treeele_num).pl_id;
1591: ben_determine_eligibility2.g_cache_first_inelig_object
1592: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1593: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1594:
1595: end if;
1588: ben_determine_eligibility2.g_cache_first_inelig_object
1589: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pl_id :=
1590: p_comp_obj_tree(l_treeele_num).pl_id;
1591: ben_determine_eligibility2.g_cache_first_inelig_object
1592: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
1593: p_comp_obj_tree(l_treeele_num).par_pgm_id;
1594:
1595: end if;
1596: end if;