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 140: from ben_ext_rslt_err xre

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

Line 158: ben_ext_rslt_err_api.create_ext_rslt_err

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

Line 197: FROM ben_ext_rslt_dtl d,

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

Line 200: ben_ext_rslt rs,

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

Line 215: FROM ben_ext_rslt_dtl d,

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

Line 218: ben_ext_rslt rs,

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

Line 233: FROM ben_ext_rslt_dtl a

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

Line 245: ben_ext_rslt rs,

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

Line 342: FROM ben_ext_rslt_dtl a

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

Line 351: FROM ben_ext_rslt_dtl a

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

Line 360: FROM ben_ext_rslt_dtl a

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

Line 416: FROM ben_ext_rslt_dtl

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

Line 423: FROM ben_ext_rslt_dtl

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

Line 429: FROM ben_ext_rslt_err

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

Line 436: FROM ben_ext_rslt

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

Line 518: FROM ben_ext_rslt_err

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

Line 523: FROM ben_ext_rslt

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

Line 811: ' FROM ben_ext_rslt_dtl ' ||

807: l_char_seq_num := to_char(p_seq_num);
808: end if;
809: --
810: l_string := 'SELECT val_' || l_char_seq_num ||
811: ' FROM ben_ext_rslt_dtl ' ||
812: 'WHERE ext_rslt_dtl_id = :b1'; -- Bug 14482456:
813: -- For Memory issues, used bind parameter in dynamic sql
814: --to_char(p_ext_rslt_dtl_id);
815: --

Line 1238: FROM ben_ext_rslt

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

Line 1244: FROM ben_ext_rslt

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