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_ENRT dependencies on BEN_EXTRACT

Line 1046: if ben_extract.g_pgn_csr = 'Y' then

1042: --
1043: -- retrieve additional enrollment information
1044: --
1045: -- retrieve policy or group number if required
1046: if ben_extract.g_pgn_csr = 'Y' then
1047: open plcy_c(enrt.pl_id);
1048: fetch plcy_c into ben_ext_person.g_enrt_plcy_r_grp;
1049: close plcy_c;
1050: end if;

Line 1053: if ben_extract.g_ppcp_csr = 'Y' then

1049: close plcy_c;
1050: end if;
1051: --
1052: -- retrieve primary care provider info if required
1053: if ben_extract.g_ppcp_csr = 'Y' then
1054: open c_prmry_care_prvdr(enrt.prtt_enrt_rslt_id);
1055: fetch c_prmry_care_prvdr into ben_ext_person.g_ppr_name
1056: ,ben_ext_person.g_ppr_ident
1057: ,ben_ext_person.g_ppr_typ

Line 1063: if ben_extract.g_rt_csr = 'Y' then

1059: ,ben_ext_person.g_ppr_end_dt;
1060: close c_prmry_care_prvdr;
1061: end if;
1062: --
1063: if ben_extract.g_rt_csr = 'Y' then
1064: --
1065: hr_utility.set_location(' person Id ' || p_person_id , 991) ;
1066: hr_utility.set_location(' result id ' || enrt.prtt_enrt_rslt_id , 991 ) ;
1067: get_rt_info(p_prtt_enrt_rslt_id => enrt.prtt_enrt_rslt_id,

Line 1073: if ben_extract.g_pprem_csr = 'Y' then

1069: --
1070: end if;
1071: --
1072: -- retrieve total premium info if required
1073: if ben_extract.g_pprem_csr = 'Y' then
1074: open prem_tot_c(enrt.prtt_enrt_rslt_id);
1075: fetch prem_tot_c into ben_ext_person.g_enrt_total_premium_amt
1076: ,ben_ext_person.g_enrt_total_premium_uom;
1077: close prem_tot_c;

Line 1083: if ben_extract.g_flxcr_csr = 'Y' then

1079: --
1080: -- this is for person level so moving benxpers
1081: -- retrieve total flex credit info
1082: /*
1083: if ben_extract.g_flxcr_csr = 'Y' then
1084: hr_utility.set_location('entering to open flex credit ' ,160);
1085: hr_utility.set_location('entering to open flex credit '|| enrt.prtt_enrt_rslt_id ,160);
1086: open flex_cred_info_c(enrt.prtt_enrt_rslt_id);
1087: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided

Line 1102: if ben_extract.g_prgrp_csr = 'Y' then

1098: --
1099: --
1100: -- Reporting group informations
1101: --
1102: if ben_extract.g_prgrp_csr = 'Y' then
1103: open c_rpt_grp(enrt.prtt_enrt_rslt_id);
1104: fetch c_rpt_grp into ben_ext_person.g_enrt_rpt_group_id,
1105: ben_ext_person.g_enrt_rpt_group_name;
1106: close c_rpt_grp;

Line 1112: if ben_extract.g_pplyr_csr = 'Y' then

1108: --
1109: --
1110: -- Plan Year Informations
1111: -- --B.Burns #: 1641610
1112: if ben_extract.g_pplyr_csr = 'Y' then
1113: open c_pl_yr(enrt.prtt_enrt_rslt_id);
1114: fetch c_pl_yr into ben_ext_person.g_enrt_pl_yr_strdt,
1115: ben_ext_person.g_enrt_pl_yr_enddt;
1116: if c_pl_yr%notfound then

Line 1128: if ben_extract.g_pmtpr_csr = 'Y' then

1124: --end B.Burns
1125: --
1126: -- Monthly Total Premium Informations
1127: --
1128: if ben_extract.g_pmtpr_csr = 'Y' then
1129: ben_ext_prem.premium_total(
1130: p_person_id => p_person_id,
1131: p_prtt_enrt_rslt_id => enrt.prtt_enrt_rslt_id,
1132: p_ext_rslt_id => p_ext_rslt_id,

Line 1144: if ben_extract.g_int_csr = 'Y' then

1140:
1141:
1142: end if;
1143: --
1144: if ben_extract.g_int_csr = 'Y' then
1145: if enrt.rplcs_sspndd_rslt_id is not null and enrt.sspndd_flag = 'Y' then
1146: open c_interim(enrt.rplcs_sspndd_rslt_id);
1147: fetch c_interim into l_interim;
1148: if c_interim%FOUND then

Line 1163: if ben_extract.g_intrm_csr = 'Y' then

1159: end if;
1160:
1161: -- Interim Flag
1162: --
1163: if ben_extract.g_intrm_csr = 'Y' then
1164: open c_intrm(enrt.prtt_enrt_rslt_id);
1165: fetch c_intrm into l_dummy;
1166: if c_intrm%FOUND then
1167: ben_ext_person.g_enrt_intrcovg_flag := 'Y';

Line 1176: IF ben_extract.g_enrt_lvl = 'Y' THEN

1172: end if;
1173: --
1174: --
1175: --
1176: IF ben_extract.g_enrt_lvl = 'Y' THEN
1177: --
1178: -- format and write enrollment
1179: -- ===========================
1180: --

Line 1198: IF ben_extract.g_prem_lvl = 'Y' then

1194:
1195:
1196: -- call premium level process
1197: --
1198: IF ben_extract.g_prem_lvl = 'Y' then
1199: --
1200: ben_ext_prem.main(
1201: p_person_id => p_person_id,
1202: p_prtt_enrt_rslt_id => enrt.prtt_enrt_rslt_id,

Line 1219: IF ben_extract.g_dpnt_lvl = 'Y' then

1215: --
1216: -- call dependent level process
1217: -- ====================================
1218: --
1219: IF ben_extract.g_dpnt_lvl = 'Y' then
1220: --
1221: ben_ext_dpnt.main(
1222: p_person_id => p_person_id,
1223: p_prtt_enrt_rslt_id => enrt.prtt_enrt_rslt_id,

Line 1238: IF ben_extract.g_bnf_lvl = 'Y' then

1234: --
1235: -- call beneficiary level process
1236: -- =================================================
1237: --
1238: IF ben_extract.g_bnf_lvl = 'Y' then
1239: --
1240: ben_ext_bnf.main(
1241: p_person_id => p_person_id,
1242: p_prtt_enrt_rslt_id => enrt.prtt_enrt_rslt_id,

Line 1258: IF ben_extract.g_actn_lvl = 'Y' then

1254: --
1255: -- call actions level process
1256: -- =================================================
1257: --
1258: IF ben_extract.g_actn_lvl = 'Y' then
1259: --
1260: ben_ext_actn.main(
1261: p_person_id => p_person_id,
1262: p_prtt_enrt_rslt_id => enrt.prtt_enrt_rslt_id,