1778: l_found VARCHAR2(1);
1779: l_app_id NUMBER := 0;
1780: l_view_app_id NUMBER := 0;
1781:
1782: CURSOR book_type_csr(bk_type_name fa_book_controls.BOOK_TYPE_NAME%TYPE) IS
1783: SELECT '1'
1784: FROM fa_book_controls
1785: WHERE BOOK_TYPE_NAME = bk_type_name;
1786:
1780: l_view_app_id NUMBER := 0;
1781:
1782: CURSOR book_type_csr(bk_type_name fa_book_controls.BOOK_TYPE_NAME%TYPE) IS
1783: SELECT '1'
1784: FROM fa_book_controls
1785: WHERE BOOK_TYPE_NAME = bk_type_name;
1786:
1787: BEGIN
1788: -- initialize return status