Subversion Repositories DevTools

<%@LANGUAGE="VBSCRIPT"%>
<%
Option explicit
Response.Expires = 0    ' always load the page, dont store
%>
<%
'=====================================================
'               Approve a Single Package merge candidate
'=====================================================
%>
<!--#include file="common/conf.asp"-->
<!--#include file="common/globals.asp"-->
<!--#include file="common/formating.asp"-->
<!--#include file="common/qstr.asp"-->
<!--#include file="common/common_subs.asp"-->
<!--#include file="common/common_dbedit.asp"-->
<%
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_login.asp"-->
<!--#include file="_access_control_general.asp"-->
<!--#include file="_access_control_project.asp"-->
<%
'------------ Variable Definition -------------
Dim parPv_id
'------------ Constants Declaration -----------

'------------ Variable Init -------------------
parPv_id = QStrPar("pv_id")
'----------------------------------------------
%>
<%
Sub ApproveMerge ( NNpv_id, NNrtag_id )
        On Error Resume Next
        objEH.ErrorRedirect = TRUE

        OraDatabase.Parameters.Add "PV_ID",                     NNpv_id,        ORAPARM_INPUT, ORATYPE_NUMBER
        OraDatabase.Parameters.Add "RTAG_ID",                   NNrtag_id,      ORAPARM_INPUT, ORATYPE_NUMBER
        OraDatabase.Parameters.Add "USER_ID",                   objAccessControl.UserId,        ORAPARM_INPUT, ORATYPE_NUMBER

        objEH.TryORA ( OraSession )

        OraSession.BeginTrans

        OraDatabase.ExecuteSQL _
        "BEGIN "&_
        " PK_ENVIRONMENT.APPROVE_MERGE ( :PV_ID, :RTAG_ID, :USER_ID );"&_
        "END; "

        OraSession.CommitTrans

        objEH.CatchORA ( OraSession )

        OraDatabase.Parameters.Remove "PV_ID"
        OraDatabase.Parameters.Remove "RTAG_ID"
        OraDatabase.Parameters.Remove "USER_ID"
End Sub
'------------------------------------------------------------------------------------

'-------------------------------------------------------------------------------------
%>
<%
'---------------------------------- MAIN LINE ----------------------------------------


' All Requirements OK
Call ApproveMerge ( parPv_id, parRtag_id )

If objEH.Finally Then
        Call OpenInWindow ( "dependencies.asp?rtag_id="&parRtag_id&"&pv_id="&parPv_id )
End If

%>


<!-- DESTRUCTOR ------->
<!--#include file="common/destructor.asp"-->