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 162: p_person_id => nvl(p_person_id,ben_ext_person.g_person_id),

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

Line 1052: where person_id = ben_ext_person.g_person_id

1048: ---
1049: cursor c_asg_exist is
1050: select 'x' from
1051: per_all_assignments_f
1052: where person_id = ben_ext_person.g_person_id
1053: and primary_flag = 'Y'
1054: and p_effective_Date between effective_start_date
1055: and effective_end_date ;
1056:

Line 1061: where person_id = ben_ext_person.g_person_id

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

Line 1071: where person_id = ben_ext_person.g_person_id

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

Line 1080: where person_id = ben_ext_person.g_person_id

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

Line 1154: l_person_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;

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

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

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

Line 1158: l_person_dt := ben_ext_person.g_cm_eff_dt;

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

Line 1160: l_person_dt := ben_ext_person.g_cm_to_be_sent_dt;

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

Line 1162: l_person_dt := ben_ext_person.g_chg_actl_dt;

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

Line 1164: l_person_dt := ben_ext_person.g_chg_eff_dt;

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

Line 1175: l_benefits_dt := ben_ext_person.g_cm_lf_evt_ocrd_dt;

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

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

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

Line 1179: l_benefits_dt := ben_ext_person.g_cm_eff_dt;

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

Line 1181: l_benefits_dt := ben_ext_person.g_cm_to_be_sent_dt;

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

Line 1183: l_benefits_dt := ben_ext_person.g_chg_actl_dt;

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

Line 1185: l_benefits_dt := ben_ext_person.g_chg_eff_dt;

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

Line 1197: l_person_dt := ben_ext_person.g_CWB_LE_DT;

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

Line 1199: l_person_dt := ben_ext_person.g_CWB_EFFECTIVE_DATE ;

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

Line 1441: if ben_ext_person.g_cm_type_id is null then

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

Line 1452: if ben_ext_person.g_cm_to_be_sent_dt is null then

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

Line 1456: raise ben_ext_person.detail_error;

1452: if ben_ext_person.g_cm_to_be_sent_dt is null then
1453:
1454: ben_ext_thread.g_err_num := 92454;
1455: ben_ext_thread.g_err_name := 'BEN_92454_EXT_INV_TO_BE_SNT_DT';
1456: raise ben_ext_person.detail_error;
1457:
1458: else
1459:
1460: l_rslt_dt := trunc(ben_ext_person.g_cm_to_be_sent_dt);

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

1456: raise ben_ext_person.detail_error;
1457:
1458: else
1459:
1460: l_rslt_dt := trunc(ben_ext_person.g_cm_to_be_sent_dt);
1461:
1462: end if;
1463:
1464: elsif p_ext_date_cd = 'CESD' then -- communication effective start date

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

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

Line 1470: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then

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

Line 1474: raise ben_ext_person.detail_error;

1470: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1471:
1472: ben_ext_thread.g_err_num := 92450;
1473: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1474: raise ben_ext_person.detail_error;
1475:
1476: else
1477:
1478: l_rslt_dt := trunc(ben_ext_person.g_cm_lf_evt_ocrd_dt);

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

1474: raise ben_ext_person.detail_error;
1475:
1476: else
1477:
1478: l_rslt_dt := trunc(ben_ext_person.g_cm_lf_evt_ocrd_dt);
1479:
1480: end if;
1481:
1482: else -- CDBLEOD communication day before life event occured date

Line 1484: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then

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

Line 1488: raise ben_ext_person.detail_error;

1484: if ben_ext_person.g_cm_lf_evt_ocrd_dt is null then
1485:
1486: ben_ext_thread.g_err_num := 92450;
1487: ben_ext_thread.g_err_name := 'BEN_92450_EXT_INV_LER_DT';
1488: raise ben_ext_person.detail_error;
1489:
1490: else
1491:
1492: l_rslt_dt := trunc(ben_ext_person.g_cm_lf_evt_ocrd_dt) - 1;

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

1488: raise ben_ext_person.detail_error;
1489:
1490: else
1491:
1492: l_rslt_dt := trunc(ben_ext_person.g_cm_lf_evt_ocrd_dt) - 1;
1493:
1494: end if;
1495:
1496: end if;

Line 1500: if ben_ext_person.g_chg_actl_dt is null then

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

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

1504: raise ben_ext_thread.g_job_failure_error;
1505:
1506: else
1507:
1508: l_rslt_dt := trunc(ben_ext_person.g_chg_actl_dt);
1509:
1510: end if;
1511: --
1512: elsif p_ext_date_cd = 'CHED' then

Line 1514: if ben_ext_person.g_chg_eff_dt is null then

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

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

1519: raise ben_ext_thread.g_job_failure_error;
1520:
1521: else
1522:
1523: l_rslt_dt := trunc(ben_ext_person.g_chg_eff_dt);
1524:
1525: end if;
1526: --
1527: -- day after last run date, day of last run date