PROCEDURE TO IMPLEMENT FOLLOWING>>>

Hi

The requirement is as follows...

Have a table for employees. As they join, they are under 'temporary' category for which employee id is 'temp01'. This employee has various details in some 25 other tables in the db.

Now, after 6 months, he is made permanent, so employee id is 'per01'.

Now, when i pass the old id 'temp01' and new id 'per01' to a procedure, it must gather the values from 'temp01' records of 25 tables and populate the 25 tables again, but for 'per01' record. It must also change the temp01 record to inactive (i.e., set/update a column 'status' to inactive).

Any ideas ?

Thanks.

do it with a stored procedure or package.