The Cascade Update Procedures

PROCEDURE update_column(
                old_value              IN VARCHAR2,
                new_value            IN VARCHAR2,
                table_name           IN VARCHAR2,
                update_column   IN VARCHAR2
);
--
-- Next procedure is update_tables
-- It is the loop control procedure for
-- the trigger and calls update_column
--
PROCEDURE update_tables(
                source_table         IN VARCHAR2,
                old_value              IN VARCHAR2,
                new_value            IN VARCHAR2
);

--
-- End of PACKAGE HEADER
--
END cascade_update;
/
--
-- Now build package body
-- That actually holds the
-- procedures and code
--

SEE CODE DEPOT FOR FULL SCRIPTS

http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm