544: , LAST_UPDATE_LOGIN
545: , CREATED_BY
546: , CREATION_DATE
547: , rowid
548: from hr_s_wc_state_surcharges;
549:
550: stu_rec stu%ROWTYPE;
551:
552: PROCEDURE remove
556:
557: BEGIN
558:
559:
560: delete from hr_s_wc_state_surcharges
561: where rowid = stu_rec.rowid;
562:
563: END remove;
564:
613: END;
614:
615: -- Update all child entities
616:
617: update hr_s_wc_state_surcharges
618: set surcharge_id = l_new_surrogate_key
619: where surcharge_id = stu_rec.surcharge_id;
620:
621: IF p_phase = 2 THEN