APPS.BEN_EXT_UTIL dependencies on BEN_EXT_RSLT_ERR

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