424: l_enrt_rt_id_tab l_number_15_table_type; -- 2897152
425:
426: --
427: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
428: l_enrt_rt_ctfn_id ben_enrt_rt_ctfn.enrt_rt_ctfn_id%type;
429: l_old_val NUMBER;
430: l_dummy varchar2(1);
431: --
432: cursor c_enrt_rt_id is
479: --
480: cursor c_enrt_ctfn_exists (p_enrt_rt_id number,
481: p_enrt_ctfn_typ_cd varchar2) is
482: select null
483: from ben_enrt_rt_ctfn erc
484: where erc.enrt_rt_id = p_enrt_rt_id
485: and erc.enrt_ctfn_typ_cd = p_enrt_ctfn_typ_cd;
486: --
487: -- 2897152
1659: -- bug#4126093
1660: open c_enrt_ctfn_exists (l_enrt_ctfn.enrt_rt_id,l_enrt_ctfn.enrt_ctfn_typ_cd);
1661: fetch c_enrt_ctfn_exists into l_dummy;
1662: if c_enrt_ctfn_exists%notfound then
1663: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn
1664: (p_validate => false
1665: ,p_enrt_rt_ctfn_id => l_enrt_rt_ctfn_id
1666: ,p_enrt_ctfn_typ_cd => l_enrt_ctfn.enrt_ctfn_typ_cd
1667: ,p_rqd_flag => l_enrt_ctfn.rqd_flag
1686: --
1687: open c_enrt_ctfn_exists (l_enrt_ctfn.enrt_rt_id,l_enrt_ctfn.enrt_ctfn_typ_cd);
1688: fetch c_enrt_ctfn_exists into l_dummy;
1689: if c_enrt_ctfn_exists%notfound then
1690: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn
1691: (p_validate => false
1692: ,p_enrt_rt_ctfn_id => l_enrt_rt_ctfn_id
1693: ,p_enrt_ctfn_typ_cd => l_enrt_ctfn.enrt_ctfn_typ_cd
1694: ,p_rqd_flag => l_enrt_ctfn.rqd_flag