[Home] [Help]
815:
816: PROCEDURE copy_abstracts
817: ( p_old_proposal_id number, p_new_proposal_id number ) IS
818: BEGIN
819: INSERT INTO igw_prop_abstracts
820: (
821: proposal_id,
822: abstract_type,
823: abstract_type_code,
872: attribute13,
873: attribute14,
874: attribute15
875: FROM
876: igw_prop_abstracts
877: WHERE
878: proposal_id = p_old_proposal_id;
879: EXCEPTION
880: WHEN OTHERS THEN