[Home] [Help]
733:
734: PROCEDURE copy_special_reviews
735: ( p_old_proposal_id number, p_new_proposal_id number ) IS
736: BEGIN
737: INSERT INTO igw_prop_special_reviews
738: (
739: proposal_id,
740: special_review_code,
741: special_review_type,
766: SYSDATE,
767: FND_GLOBAL.USER_ID,
768: FND_GLOBAL.LOGIN_ID
769: FROM
770: igw_prop_special_reviews
771: WHERE
772: proposal_id = p_old_proposal_id;
773: EXCEPTION
774: WHEN OTHERS THEN