Line 1132: select sysdate into l_sysdate from dual;
1128: if (SQL%NOTFOUND) then
1129: Raise NO_DATA_FOUND;
1130: end if;
1131: 1132: select sysdate into l_sysdate from dual; 1133:
1134: UPDATE fa_book_controls_history
1135: SET date_inactive = l_sysdate
1136: WHERE book_type_code = X_Book_Type_Code