223:
224: --validate je_category.
225: select count(*)
226: into l_count
227: from gl_je_categories_tl
228: where user_je_category_name = l_JE_CATEGORY;
229: -- and LANGUAGE = userenv('LANG')
230: if l_count=0 then
231: update ja_cn_item_interface
487:
488: end loop;
489: close c_journals;
490:
491: -- select * from gl_je_categories_tl where user_je_category_name =
492:
493:
494: EXCEPTION
495: