eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_UTIL dependencies on BEN_EXT_PERSON

Line 164: p_person_id => nvl(p_person_id,ben_ext_person.g_person_id),

160: p_ext_rslt_err_id => l_ext_rslt_err_id,
161: p_err_num => p_err_num,
162: p_err_txt => p_err_name,
163: p_typ_cd => p_typ_cd,
164: p_person_id => nvl(p_person_id,ben_ext_person.g_person_id),
165: p_business_group_id => p_business_group_id,
166: p_ext_rslt_id => p_ext_rslt_id,
167: p_object_version_number => l_object_version_number,
168: p_request_id => nvl(p_request_id,fnd_global.conc_request_id),

Line 1056: where person_id = ben_ext_person.g_person_id

1052: ---
1053: cursor c_asg_exist is
1054: select 'x' from
1055: per_all_assignments_f
1056: where person_id = ben_ext_person.g_person_id
1057: and primary_flag = 'Y'
1058: and p_effective_Date between effective_start_date
1059: and effective_end_date ;
1060:

Line 1065: where person_id = ben_ext_person.g_person_id

1061:
1062: cursor c_e_asg_exist is
1063: select 'x' from
1064: per_all_assignments_f
1065: where person_id = ben_ext_person.g_person_id
1066: and primary_flag = 'Y'
1067: and assignment_type = 'E' -- added by hmani bug 3629576
1068: and p_effective_Date between effective_start_date
1069: and effective_end_date ;

Line 1075: where person_id = ben_ext_person.g_person_id

1071:
1072: cursor c_A_asg_exist is
1073: select 'x' from
1074: per_all_assignments_f
1075: where person_id = ben_ext_person.g_person_id
1076: and assignment_type = 'A' -- applicatn does not have any primary
1077: and p_effective_Date between effective_start_date
1078: and effective_end_date ;
1079:

Line 1084: where person_id = ben_ext_person.g_person_id

1080:
1081: cursor c_asg_term is
1082: select effective_end_date from
1083: per_all_assignments_f
1084: where person_id = ben_ext_person.g_person_id
1085: and primary_flag = 'Y'
1086: and assignment_type = 'E' -- added by hmani bug 3629576
1087: and effective_start_date < p_effective_Date
1088: order by effective_end_Date desc ;

Line 1158: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;

1154: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1155:
1156:
1157: if l_person_dt_cd = 'CLEOD' then -- life event occured
1158: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;
1159: elsif l_person_dt_cd = 'CDBLEOD' then -- day before life event occured
1160: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt - 1;
1161: elsif l_person_dt_cd = 'CESD' then -- per_cm_f effective start date
1162: l_person_dt := ben_ext_person.g_cm_eff_dt;

Line 1160: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt - 1;

1156:
1157: if l_person_dt_cd = 'CLEOD' then -- life event occured
1158: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;
1159: elsif l_person_dt_cd = 'CDBLEOD' then -- day before life event occured
1160: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt - 1;
1161: elsif l_person_dt_cd = 'CESD' then -- per_cm_f effective start date
1162: l_person_dt := ben_ext_person.g_cm_eff_dt;
1163: elsif l_person_dt_cd = 'CTBSD' then -- communication to be sent date
1164: l_person_dt := ben_ext_person.g_cm_to_be_sent_dt;

Line 1162: l_person_dt := ben_ext_person.g_cm_eff_dt;

1158: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;
1159: elsif l_person_dt_cd = 'CDBLEOD' then -- day before life event occured
1160: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt - 1;
1161: elsif l_person_dt_cd = 'CESD' then -- per_cm_f effective start date
1162: l_person_dt := ben_ext_person.g_cm_eff_dt;
1163: elsif l_person_dt_cd = 'CTBSD' then -- communication to be sent date
1164: l_person_dt := ben_ext_person.g_cm_to_be_sent_dt;
1165: elsif l_person_dt_cd = 'CHAD' then -- change actual date
1166: l_person_dt := ben_ext_person.g_chg_actl_dt;

Line 1164: l_person_dt := ben_ext_person.g_cm_to_be_sent_dt;

1160: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt - 1;
1161: elsif l_person_dt_cd = 'CESD' then -- per_cm_f effective start date
1162: l_person_dt := ben_ext_person.g_cm_eff_dt;
1163: elsif l_person_dt_cd = 'CTBSD' then -- communication to be sent date
1164: l_person_dt := ben_ext_person.g_cm_to_be_sent_dt;
1165: elsif l_person_dt_cd = 'CHAD' then -- change actual date
1166: l_person_dt := ben_ext_person.g_chg_actl_dt;
1167: elsif l_person_dt_cd = 'CHED' then -- change effective date
1168: l_person_dt := ben_ext_person.g_chg_eff_dt;

Line 1166: l_person_dt := ben_ext_person.g_chg_actl_dt;

1162: l_person_dt := ben_ext_person.g_cm_eff_dt;
1163: elsif l_person_dt_cd = 'CTBSD' then -- communication to be sent date
1164: l_person_dt := ben_ext_person.g_cm_to_be_sent_dt;
1165: elsif l_person_dt_cd = 'CHAD' then -- change actual date
1166: l_person_dt := ben_ext_person.g_chg_actl_dt;
1167: elsif l_person_dt_cd = 'CHED' then -- change effective date
1168: l_person_dt := ben_ext_person.g_chg_eff_dt;
1169: elsif l_person_dt_cd = 'TD' then -- today (conc mgr effective dt)
1170: l_person_dt := p_effective_date;

Line 1168: l_person_dt := ben_ext_person.g_chg_eff_dt;

1164: l_person_dt := ben_ext_person.g_cm_to_be_sent_dt;
1165: elsif l_person_dt_cd = 'CHAD' then -- change actual date
1166: l_person_dt := ben_ext_person.g_chg_actl_dt;
1167: elsif l_person_dt_cd = 'CHED' then -- change effective date
1168: l_person_dt := ben_ext_person.g_chg_eff_dt;
1169: elsif l_person_dt_cd = 'TD' then -- today (conc mgr effective dt)
1170: l_person_dt := p_effective_date;
1171: end if;
1172: end if; --found

Line 1179: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;

1175: if ben_extract.g_bdtor_dt_cd is not null then
1176: l_benefits_dt_cd := ben_extract.g_bdtor_dt_cd ;
1177:
1178: if l_benefits_dt_cd = 'CLEOD' then -- life event occured
1179: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;
1180: elsif l_benefits_dt_cd = 'CDBLEOD' then -- day before life event occured
1181: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt - 1;
1182: elsif l_benefits_dt_cd = 'CESD' then -- per_cm_f effective start date
1183: l_benefits_dt := ben_ext_person.g_cm_eff_dt;

Line 1181: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt - 1;

1177:
1178: if l_benefits_dt_cd = 'CLEOD' then -- life event occured
1179: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;
1180: elsif l_benefits_dt_cd = 'CDBLEOD' then -- day before life event occured
1181: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt - 1;
1182: elsif l_benefits_dt_cd = 'CESD' then -- per_cm_f effective start date
1183: l_benefits_dt := ben_ext_person.g_cm_eff_dt;
1184: elsif l_benefits_dt_cd = 'CTBSD' then -- communication to be sent date
1185: l_benefits_dt := ben_ext_person.g_cm_to_be_sent_dt;

Line 1183: l_benefits_dt := ben_ext_person.g_cm_eff_dt;

1179: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;
1180: elsif l_benefits_dt_cd = 'CDBLEOD' then -- day before life event occured
1181: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt - 1;
1182: elsif l_benefits_dt_cd = 'CESD' then -- per_cm_f effective start date
1183: l_benefits_dt := ben_ext_person.g_cm_eff_dt;
1184: elsif l_benefits_dt_cd = 'CTBSD' then -- communication to be sent date
1185: l_benefits_dt := ben_ext_person.g_cm_to_be_sent_dt;
1186: elsif l_benefits_dt_cd = 'CHAD' then -- change actual date
1187: l_benefits_dt := ben_ext_person.g_chg_actl_dt;

Line 1185: l_benefits_dt := ben_ext_person.g_cm_to_be_sent_dt;

1181: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt - 1;
1182: elsif l_benefits_dt_cd = 'CESD' then -- per_cm_f effective start date
1183: l_benefits_dt := ben_ext_person.g_cm_eff_dt;
1184: elsif l_benefits_dt_cd = 'CTBSD' then -- communication to be sent date
1185: l_benefits_dt := ben_ext_person.g_cm_to_be_sent_dt;
1186: elsif l_benefits_dt_cd = 'CHAD' then -- change actual date
1187: l_benefits_dt := ben_ext_person.g_chg_actl_dt;
1188: elsif l_benefits_dt_cd = 'CHED' then -- change effective date
1189: l_benefits_dt := ben_ext_person.g_chg_eff_dt;

Line 1187: l_benefits_dt := ben_ext_person.g_chg_actl_dt;

1183: l_benefits_dt := ben_ext_person.g_cm_eff_dt;
1184: elsif l_benefits_dt_cd = 'CTBSD' then -- communication to be sent date
1185: l_benefits_dt := ben_ext_person.g_cm_to_be_sent_dt;
1186: elsif l_benefits_dt_cd = 'CHAD' then -- change actual date
1187: l_benefits_dt := ben_ext_person.g_chg_actl_dt;
1188: elsif l_benefits_dt_cd = 'CHED' then -- change effective date
1189: l_benefits_dt := ben_ext_person.g_chg_eff_dt;
1190: elsif l_benefits_dt_cd = 'TD' then -- today (conc mgr effective dt)
1191: l_benefits_dt := p_effective_date;

Line 1189: l_benefits_dt := ben_ext_person.g_chg_eff_dt;

1185: l_benefits_dt := ben_ext_person.g_cm_to_be_sent_dt;
1186: elsif l_benefits_dt_cd = 'CHAD' then -- change actual date
1187: l_benefits_dt := ben_ext_person.g_chg_actl_dt;
1188: elsif l_benefits_dt_cd = 'CHED' then -- change effective date
1189: l_benefits_dt := ben_ext_person.g_chg_eff_dt;
1190: elsif l_benefits_dt_cd = 'TD' then -- today (conc mgr effective dt)
1191: l_benefits_dt := p_effective_date;
1192: end if;
1193: end if; --found

Line 1201: l_person_dt := ben_ext_person.g_CWB_LE_DT;

1197: if ben_extract.g_pasor_dt_cd is not null then
1198: l_person_dt_cd := ben_extract.g_pasor_dt_cd ;
1199:
1200: if l_person_dt_cd = 'CWBEDT' then -- effective date
1201: l_person_dt := ben_ext_person.g_CWB_LE_DT;
1202: elsif l_person_dt_cd = 'CWBFDT' then -- life evt ocrd dt
1203: l_person_dt := ben_ext_person.g_CWB_EFFECTIVE_DATE ;
1204: elsif l_person_dt_cd = 'TD' then -- today (conc mgr effective dt)
1205: l_person_dt := p_effective_date;

Line 1203: l_person_dt := ben_ext_person.g_CWB_EFFECTIVE_DATE ;

1199:
1200: if l_person_dt_cd = 'CWBEDT' then -- effective date
1201: l_person_dt := ben_ext_person.g_CWB_LE_DT;
1202: elsif l_person_dt_cd = 'CWBFDT' then -- life evt ocrd dt
1203: l_person_dt := ben_ext_person.g_CWB_EFFECTIVE_DATE ;
1204: elsif l_person_dt_cd = 'TD' then -- today (conc mgr effective dt)
1205: l_person_dt := p_effective_date;
1206: end if;
1207: end if; --found

Line 1445: if ben_ext_person.g_cm_type_id is null then

1441: l_rslt_dt := trunc(add_months(p_abs_date, -18));
1442: --
1443: elsif p_ext_date_cd IN ('CTBSD','CESD','CLEOD','CDBLEOD') then
1444: --
1445: if ben_ext_person.g_cm_type_id is null then
1446: hr_utility.set_location(' 514 error '|| p_ext_date_cd , 514);
1447:
1448: ben_ext_thread.g_err_num := 92451;
1449: ben_ext_thread.g_err_name := 'BEN_92451_EXT_INV_CM_DT';

Line 1456: if ben_ext_person.g_cm_to_be_sent_dt is null then

1452: end if;
1453:
1454: if p_ext_date_cd = 'CTBSD' then --communication to be sent date
1455:
1456: if ben_ext_person.g_cm_to_be_sent_dt is null then
1457:
1458: ben_ext_thread.g_err_num := 92454;
1459: ben_ext_thread.g_err_name := 'BEN_92454_EXT_INV_TO_BE_SNT_DT';
1460: raise ben_ext_person.detail_error;

Line 1460: raise ben_ext_person.detail_error;

1456: if ben_ext_person.g_cm_to_be_sent_dt is null then
1457:
1458: ben_ext_thread.g_err_num := 92454;
1459: ben_ext_thread.g_err_name := 'BEN_92454_EXT_INV_TO_BE_SNT_DT';
1460: raise ben_ext_person.detail_error;
1461:
1462: else
1463:
1464: l_rslt_dt := trunc(ben_ext_person.g_cm_to_be_sent_dt);

Line 1464: l_rslt_dt := trunc(ben_ext_person.g_cm_to_be_sent_dt);

1460: raise ben_ext_person.detail_error;
1461:
1462: else
1463:
1464: l_rslt_dt := trunc(ben_ext_person.g_cm_to_be_sent_dt);
1465:
1466: end if;
1467:
1468: elsif p_ext_date_cd = 'CESD' then -- communication effective start date

Line 1470: l_rslt_dt := trunc(ben_ext_person.g_cm_eff_dt);

1466: end if;
1467:
1468: elsif p_ext_date_cd = 'CESD' then -- communication effective start date
1469:
1470: l_rslt_dt := trunc(ben_ext_person.g_cm_eff_dt);
1471:
1472: elsif p_ext_date_cd = 'CLEOD' then -- communication life event occurred date
1473:
1474: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then

Line 1474: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then

1470: l_rslt_dt := trunc(ben_ext_person.g_cm_eff_dt);
1471:
1472: elsif p_ext_date_cd = 'CLEOD' then -- communication life event occurred date
1473:
1474: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1475:
1476: ben_ext_thread.g_err_num := 92450;
1477: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1478: raise ben_ext_person.detail_error;

Line 1478: raise ben_ext_person.detail_error;

1474: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1475:
1476: ben_ext_thread.g_err_num := 92450;
1477: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1478: raise ben_ext_person.detail_error;
1479:
1480: else
1481:
1482: l_rslt_dt := trunc(ben_ext_person.g_cm_lf_evt_ocrd_dt);

Line 1482: l_rslt_dt := trunc(ben_ext_person.g_cm_lf_evt_ocrd_dt);

1478: raise ben_ext_person.detail_error;
1479:
1480: else
1481:
1482: l_rslt_dt := trunc(ben_ext_person.g_cm_lf_evt_ocrd_dt);
1483:
1484: end if;
1485:
1486: else -- CDBLEOD communication day before life event occured date

Line 1488: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then

1484: end if;
1485:
1486: else -- CDBLEOD communication day before life event occured date
1487:
1488: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1489:
1490: ben_ext_thread.g_err_num := 92450;
1491: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1492: raise ben_ext_person.detail_error;

Line 1492: raise ben_ext_person.detail_error;

1488: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1489:
1490: ben_ext_thread.g_err_num := 92450;
1491: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1492: raise ben_ext_person.detail_error;
1493:
1494: else
1495:
1496: l_rslt_dt := trunc(ben_ext_person.g_cm_lf_evt_ocrd_dt) - 1;

Line 1496: l_rslt_dt := trunc(ben_ext_person.g_cm_lf_evt_ocrd_dt) - 1;

1492: raise ben_ext_person.detail_error;
1493:
1494: else
1495:
1496: l_rslt_dt := trunc(ben_ext_person.g_cm_lf_evt_ocrd_dt) - 1;
1497:
1498: end if;
1499:
1500: end if;

Line 1504: if ben_ext_person.g_chg_actl_dt is null then

1500: end if;
1501: --
1502: elsif p_ext_date_cd = 'CHAD' then
1503:
1504: if ben_ext_person.g_chg_actl_dt is null then
1505: hr_utility.set_location(' 514 error 1' , 514);
1506: ben_ext_thread.g_err_num := 92455;
1507: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';
1508: raise ben_ext_thread.g_job_failure_error;

Line 1512: l_rslt_dt := trunc(ben_ext_person.g_chg_actl_dt);

1508: raise ben_ext_thread.g_job_failure_error;
1509:
1510: else
1511:
1512: l_rslt_dt := trunc(ben_ext_person.g_chg_actl_dt);
1513:
1514: end if;
1515: --
1516: elsif p_ext_date_cd = 'CHED' then

Line 1518: if ben_ext_person.g_chg_eff_dt is null then

1514: end if;
1515: --
1516: elsif p_ext_date_cd = 'CHED' then
1517:
1518: if ben_ext_person.g_chg_eff_dt is null then
1519:
1520: hr_utility.set_location(' 514 error 2' , 514);
1521: ben_ext_thread.g_err_num := 92455;
1522: ben_ext_thread.g_err_name := 'BEN_92455_EXT_INV_CHG_DT';

Line 1527: l_rslt_dt := trunc(ben_ext_person.g_chg_eff_dt);

1523: raise ben_ext_thread.g_job_failure_error;
1524:
1525: else
1526:
1527: l_rslt_dt := trunc(ben_ext_person.g_chg_eff_dt);
1528:
1529: end if;
1530: --
1531: -- day after last run date, day of last run date