752: Raise NO_DATA_FOUND;
753: end if;
754: CLOSE C_bc;
755:
756: insert into fa_book_controls_history (
757: book_type_code,
758: date_active,
759: date_inactive,
760: book_type_name,
1526: end if;
1527:
1528: select sysdate into l_sysdate from dual;
1529:
1530: UPDATE fa_book_controls_history
1531: SET date_inactive = l_sysdate
1532: WHERE book_type_code = X_Book_Type_Code
1533: AND date_inactive is null;
1534:
1531: SET date_inactive = l_sysdate
1532: WHERE book_type_code = X_Book_Type_Code
1533: AND date_inactive is null;
1534:
1535: insert into fa_book_controls_history (
1536: book_type_code,
1537: date_active,
1538: date_inactive,
1539: book_type_name,
1915:
1916: DELETE FROM fa_book_controls
1917: WHERE book_type_code = l_book_type_code;
1918:
1919: DELETE FROM fa_book_controls_history
1920: WHERE book_type_code = l_book_type_code;
1921:
1922: end if;
1923: