APPS.BEN_EXT_UTIL dependencies on BEN_EXT_RSLT_ERR

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 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 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