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_RSLT

Line 138: from ben_ext_rslt_err xre

134: l_proc varchar2(72) := g_package||'.write_err';
135: --
136: cursor c_xre is
137: select 'x'
138: from ben_ext_rslt_err xre
139: where xre.ext_rslt_id = p_ext_rslt_id --xre.request_id = fnd_global.conc_request_id
140: and xre.person_id = p_person_id
141: and xre.err_num = p_err_num
142: and ( /*p_typ_cd <> 'W'

Line 156: ben_ext_rslt_err_api.create_ext_rslt_err

152: open c_xre;
153: fetch c_xre into l_dummy;
154: hr_utility.set_location('error msg '||substr(p_err_name,1,100), 99.96 );
155: if c_xre%notfound then -- only write once.
156: ben_ext_rslt_err_api.create_ext_rslt_err
157: (p_validate => FALSE,
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,

Line 195: FROM ben_ext_rslt_dtl d,

191: --Modified cursor version 115.26
192: CURSOR csr_get_rec_tot_rslt IS
193: SELECT r.name name,
194: count(d.ext_rslt_dtl_id) count
195: FROM ben_ext_rslt_dtl d,
196: ben_ext_rcd r,
197: ben_ext_rcd_in_file f,
198: ben_ext_rslt rs,
199: ben_ext_dfn df

Line 198: ben_ext_rslt rs,

194: count(d.ext_rslt_dtl_id) count
195: FROM ben_ext_rslt_dtl d,
196: ben_ext_rcd r,
197: ben_ext_rcd_in_file f,
198: ben_ext_rslt rs,
199: ben_ext_dfn df
200: WHERE d.ext_rslt_id(+) = p_ext_rslt_id
201: AND f.ext_rcd_id = r.ext_rcd_id
202: AND r.ext_rcd_id = d.ext_rcd_id (+)

Line 213: FROM ben_ext_rslt_dtl d,

209: --Modified cursor version 115.26
210: CURSOR csr_get_rec_tot_both IS
211: SELECT r.name name,
212: count(d.ext_rslt_dtl_id) count
213: FROM ben_ext_rslt_dtl d,
214: ben_ext_rcd r,
215: ben_ext_rcd_in_file f,
216: ben_ext_rslt rs,
217: ben_ext_dfn df

Line 216: ben_ext_rslt rs,

212: count(d.ext_rslt_dtl_id) count
213: FROM ben_ext_rslt_dtl d,
214: ben_ext_rcd r,
215: ben_ext_rcd_in_file f,
216: ben_ext_rslt rs,
217: ben_ext_dfn df
218: WHERE d.ext_rslt_id(+) = p_ext_rslt_id
219: AND d.request_id(+) = p_request_id
220: AND f.ext_rcd_id = r.ext_rcd_id

Line 231: FROM ben_ext_rslt_dtl a

227: --
228: cursor csr_get_rec_tot_req is
229: SELECT b.name rec_name
230: ,count(ext_rslt_dtl_id)
231: FROM ben_ext_rslt_dtl a
232: ,ben_ext_rcd b
233: WHERE a.ext_rcd_id = b.ext_rcd_id
234: AND a.ext_rslt_id = p_ext_rslt_id --a.request_id = p_request_id
235: GROUP BY b.name

Line 243: ben_ext_rslt rs,

239: CURSOR csr_get_count(p_name in varchar2)IS
240: SELECT count(r.name) count
241: FROM ben_ext_rcd r,
242: ben_ext_rcd_in_file f,
243: ben_ext_rslt rs,
244: ben_ext_dfn df
245: WHERE f.ext_rcd_id = r.ext_rcd_id
246: AND f.ext_file_id = df.ext_file_id
247: AND df.ext_dfn_id = rs.ext_dfn_id

Line 340: FROM ben_ext_rslt_dtl a

336: cursor csr_get_rec_statistics_rslt is
337: SELECT count(decode(b.rcd_type_cd, 'H', b.rcd_type_cd))
338: ,count(decode(b.rcd_type_cd, 'D', b.rcd_type_cd))
339: ,count(decode(b.rcd_type_cd, 'T', b.rcd_type_cd))
340: FROM ben_ext_rslt_dtl a
341: ,ben_ext_rcd b
342: WHERE a.ext_rcd_id = b.ext_rcd_id
343: AND a.ext_rslt_id = p_ext_rslt_id;
344: --

Line 349: FROM ben_ext_rslt_dtl a

345: cursor csr_get_rec_statistics_req is
346: SELECT count(decode(b.rcd_type_cd, 'H', b.rcd_type_cd))
347: ,count(decode(b.rcd_type_cd, 'D', b.rcd_type_cd))
348: ,count(decode(b.rcd_type_cd, 'T', b.rcd_type_cd))
349: FROM ben_ext_rslt_dtl a
350: ,ben_ext_rcd b
351: WHERE a.ext_rcd_id = b.ext_rcd_id
352: AND a.ext_rslt_id = p_ext_rslt_id; --a.request_id = p_request_id;
353: --

Line 358: FROM ben_ext_rslt_dtl a

354: cursor csr_get_rec_statistics_both is
355: SELECT count(decode(b.rcd_type_cd, 'H', b.rcd_type_cd))
356: ,count(decode(b.rcd_type_cd, 'D', b.rcd_type_cd))
357: ,count(decode(b.rcd_type_cd, 'T', b.rcd_type_cd))
358: FROM ben_ext_rslt_dtl a
359: ,ben_ext_rcd b
360: WHERE a.ext_rcd_id = b.ext_rcd_id
361: AND a.request_id = p_request_id
362: AND a.ext_rslt_id = p_ext_rslt_id;

Line 414: FROM ben_ext_rslt_dtl

410: l_proc varchar2(72) := g_package||'.get_per_statistics';
411: --
412: cursor csr_get_per_xtrctd_rslt is
413: SELECT count(distinct person_id)
414: FROM ben_ext_rslt_dtl
415: WHERE ext_rslt_id = p_ext_rslt_id
416: AND person_id not in (0, 999999999999);
417:
418: --

Line 421: FROM ben_ext_rslt_dtl

417:
418: --
419: cursor csr_get_per_xtrctd_req is
420: SELECT count(distinct person_id)
421: FROM ben_ext_rslt_dtl
422: WHERE ext_rslt_id = p_ext_rslt_id --request_id = p_request_id
423: AND person_id not in (0, 999999999999);
424: --
425: cursor csr_get_per_not_xtrctd_req is

Line 427: FROM ben_ext_rslt_err

423: AND person_id not in (0, 999999999999);
424: --
425: cursor csr_get_per_not_xtrctd_req is
426: SELECT count(distinct person_id)
427: FROM ben_ext_rslt_err
428: WHERE ext_rslt_id = p_ext_rslt_id --request_id = l_request_id
429: AND person_id not in (0, 999999999999)
430: AND typ_cd <> 'W';
431: --

Line 434: FROM ben_ext_rslt

430: AND typ_cd <> 'W';
431: --
432: cursor csr_get_req_id is
433: SELECT request_id
434: FROM ben_ext_rslt
435: WHERE ext_rslt_id = p_ext_rslt_id;
436: --
437: begin
438: --

Line 516: FROM ben_ext_rslt_err

512: cursor csr_get_err_warn_stat_req is
513: SELECT count(decode(typ_cd, 'F', typ_cd))
514: ,count(decode(typ_cd, 'E', typ_cd))
515: ,count(decode(typ_cd, 'W', typ_cd))
516: FROM ben_ext_rslt_err
517: WHERE ext_rslt_id = p_ext_rslt_id; --request_id = l_request_id;
518: --
519: cursor csr_get_req_id is
520: SELECT request_id

Line 521: FROM ben_ext_rslt

517: WHERE ext_rslt_id = p_ext_rslt_id; --request_id = l_request_id;
518: --
519: cursor csr_get_req_id is
520: SELECT request_id
521: FROM ben_ext_rslt
522: WHERE ext_rslt_id = p_ext_rslt_id;
523: --
524: l_proc varchar2(72) := g_package||'.get_err_warn_statistics';
525: --

Line 809: ' FROM ben_ext_rslt_dtl ' ||

805: l_char_seq_num := to_char(p_seq_num);
806: end if;
807: --
808: l_string := 'SELECT val_' || l_char_seq_num ||
809: ' FROM ben_ext_rslt_dtl ' ||
810: 'WHERE ext_rslt_dtl_id = ' ||
811: to_char(p_ext_rslt_dtl_id);
812: --
813: l_cid := DBMS_SQL.OPEN_CURSOR;

Line 1234: FROM ben_ext_rslt

1230: l_eff_dt date;
1231: --
1232: cursor prior_ext_run_c is
1233: SELECT max(run_end_dt)
1234: FROM ben_ext_rslt
1235: WHERE ext_dfn_id = p_ext_dfn_id
1236: AND ext_stat_cd IN ('S', 'E', 'A','W');
1237: --
1238: cursor prior_ext_eff_c is

Line 1240: FROM ben_ext_rslt

1236: AND ext_stat_cd IN ('S', 'E', 'A','W');
1237: --
1238: cursor prior_ext_eff_c is
1239: SELECT max(eff_dt)
1240: FROM ben_ext_rslt
1241: WHERE ext_dfn_id = p_ext_dfn_id
1242: AND ext_stat_cd IN ('S', 'E', 'A','W');
1243: --
1244: cursor c_pln_yr is