1902: raise validation_error;
1903: end if;
1904:
1905: if (X_mrc_sob_type_code = 'R') then
1906: DELETE FROM fa_deprn_periods_mrc_v
1907: WHERE book_type_code = l_book_type_code;
1908:
1909: DELETE FROM fa_book_controls_mrc_v
1910: WHERE book_type_code = l_book_type_code;
1909: DELETE FROM fa_book_controls_mrc_v
1910: WHERE book_type_code = l_book_type_code;
1911:
1912: else
1913: DELETE FROM fa_deprn_periods
1914: WHERE book_type_code = l_book_type_code;
1915:
1916: DELETE FROM fa_book_controls
1917: WHERE book_type_code = l_book_type_code;