Subversion Repositories DevTools

<%@LANGUAGE="VBSCRIPT"%>
<%
Option explicit
Response.Expires = 0    ' always load the page, dont store
%>
<%
'=====================================================
'                                       System Lock Package
'=====================================================
%>
<!--#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_general.asp"-->
<%
'------------ Variable Definition -------------
Dim parPv_id
Dim pending_unlock
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
parPv_id = QStrPar("pv_id")
parRtag_id = QStrPar("rtag_id")
'----------------------------------------------
%>
<%
Sub LockPackage ()
        
        OraDatabase.Parameters.Add "PV_ID",             Request("pv_id"),       ORAPARM_INPUT, ORATYPE_NUMBER 
        OraDatabase.Parameters.Add "USER_ID",           objAccessControl.UserId,        ORAPARM_INPUT, ORATYPE_NUMBER 
        
        
        OraSession.BeginTrans
        
        OraDatabase.ExecuteSQL _
        "BEGIN  Lock_Package( :PV_ID, :USER_ID );  END;"
        
    OraSession.CommitTrans
        
        
        OraDatabase.Parameters.Remove "PV_ID"
        OraDatabase.Parameters.Remove "USER_ID"
        
End Sub
Sub DLocked_A ()
        
        OraDatabase.Parameters.Add "PV_ID",             Request("pv_id"),       ORAPARM_INPUT, ORATYPE_NUMBER 
        OraDatabase.Parameters.Add "USER_ID",           objAccessControl.UserId,        ORAPARM_INPUT, ORATYPE_NUMBER 
        
        
        OraSession.BeginTrans
        
        OraDatabase.ExecuteSQL _
        "BEGIN  Pending_Package( :PV_ID, :USER_ID );  END;"
        
    OraSession.CommitTrans
        
        
        OraDatabase.Parameters.Remove "PV_ID"
        OraDatabase.Parameters.Remove "USER_ID"
        
End Sub
%>
<%
Dim sqlstr, rsTemp, rsQry
sqlstr = "select pkg_label from package_versions where PV_ID ="& parPv_id 

Set rsTemp = OraDatabase.DbCreateDynaset( sqlstr, cint(0))

If instr(rsTemp("pkg_label"),"WIP") <> 0 Then
        pending_unlock = true
End If

rsTemp.Close
Set rsTemp = nothing
'Process submition
'---------------------------------------
' THIS IS FOR SYSTEM ADMIN ONLY
'---------------------------------------
If objAccessControl.IsVisible("UnlockPackage") AND NOT pending_unlock Then
        Call LockPackage ()
        Response.Redirect ( "_generate_release_notes.asp?rfile=dependencies.asp&pv_id="& parPv_id &"&rtag_id="& parRtag_id )
End If
If objAccessControl.IsVisible("UnlockPackage") AND pending_unlock Then
        'Check If There Already Exists A WIP Instance Of The Package In The Release
         If Check_Package_WIP_Already_Exists(Request("rtag_id"), Request("pv_id")) > 0 Then
                Call RaiseMsg ( enum_MSG_PACKAGE_WIP_EXISTS&"?rtag_id="& parRtag_id &"&pv_id="& parPv_id &"", parPv_id )
         End If
        Call DLocked_A()
        Response.Redirect ( "dependencies.asp?pv_id="& parPv_id &"&rtag_id="& parRtag_id )
End If
%>

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