Subversion Repositories DevTools

CREATE PROCEDURE "RELEASE_MANAGER"."UPDATE_UNIT_TEST_ACCEPTANCE" ( pnTest_id IN NUMBER,
                                                                                                                  pnPv_id IN NUMBER,
                                                                              sAccepted IN UNIT_TESTS.TEST_ACCEPTED%TYPE,
                                                                                                                  sAcceptanceDate IN VARCHAR2,
                                                                                                                  sAcceptedBy IN NUMBER,
                                                                              sReviewComments IN UNIT_TESTS.REVIEW_COMMENTS%TYPE,
                                                                                                                  cUpdateAcceptedStateOnly IN CHAR
                                                                             ) IS
/* ---------------------------------------------------------------------------
    Version: 3.0.0
   --------------------------------------------------------------------------- */



BEGIN
        IF cUpdateAcceptedStateOnly = 'Y'
        THEN
                --- Update Accepted State Only ---
                IF ( sAccepted IS NULL )
                THEN
                        -- Clear alleptance
                        UPDATE UNIT_TESTS SET
                           TEST_ACCEPTED = NULL,
                           ACCEPTANCE_DATE = NULL,
                                   ACCEPTED_BY = NULL,
                                   REVIEW_COMMENTS = NULL
                     WHERE TEST_ID = pnTest_id
                       AND PV_ID = pnPv_id;

            ELSE
                        UPDATE UNIT_TESTS SET
                           TEST_ACCEPTED = sAccepted,
                           ACCEPTANCE_DATE = TO_DATE( sAcceptanceDate,'DD/MM/YYYY' ),
                                   ACCEPTED_BY = sAcceptedBy
                     WHERE TEST_ID = pnTest_id
                       AND PV_ID = pnPv_id;

                END IF;


        ELSE
                --- Update Unit Test Acceptance ---
            UPDATE UNIT_TESTS SET
                   TEST_ACCEPTED = sAccepted,
                           REVIEW_COMMENTS = sReviewComments,
                   ACCEPTANCE_DATE = TO_DATE( sAcceptanceDate,'DD/MM/YYYY' ),
                           ACCEPTED_BY = sAcceptedBy
             WHERE TEST_ID = pnTest_id
               AND PV_ID = pnPv_id;

        END IF;

END Update_Unit_Test_Acceptance;
/