<%@LANGUAGE="VBSCRIPT"%> <% '===================================================== ' Rename Version ' --- PROCESS FORM --- '===================================================== %> <% Option explicit ' Good idea to set when using redirect Response.Expires = 0 ' always load the page, dont store %> <% '------------ ACCESS CONTROL ------------------ %> <% '------------ Variable Definition ------------- Dim parPv_id Dim parRfile Dim rsPkgInfo Dim errMessage Dim objPkgInfo '------------ Constants Declaration ----------- '------------ Variable Init ------------------- parPv_id = QStrPar("pv_id") parRfile = QStrPar("rfile") Set objPkgInfo = CreateObject("Scripting.Dictionary") '----------------------------------------------------------------------------------------------------------------------------- Sub GetPackageInfo( nPvId, outPkgInfo ) Dim rsTemp, Query_String If IsEmpty(nPvId) Then Exit Sub Query_String = _ " SELECT pv.pv_id, pkg.pkg_id, pkg.pkg_name, pv.pkg_version, pv.v_ext, pv.build_type, pv.is_patch"&_ " FROM packages pkg, package_versions pv"&_ " WHERE pkg.pkg_id = pv.pkg_id AND pv.pv_id ="& nPvId Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0)) If ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF)) Then outPkgInfo.Item("pv_id") = rsTemp.Fields("pv_id") outPkgInfo.Item("pkg_id") = rsTemp.Fields("pkg_id") outPkgInfo.Item("pkg_name") = rsTemp.Fields("pkg_name") outPkgInfo.Item("pkg_version") = rsTemp.Fields("pkg_version") outPkgInfo.Item("v_ext") = rsTemp.Fields("v_ext") outPkgInfo.Item("build_type") = rsTemp.Fields("build_type") outPkgInfo.Item("is_patch") = rsTemp.Fields("is_patch") If rsTemp.Fields("build_type") = "M" Then objPkgInfo.Item("M_checked") = "checked" objPkgInfo.Item("A_checked") = "" objPkgInfo.Item("M_display") = "style='display:inline;'" objPkgInfo.Item("A_display") = "style='display:none;'" ElseIf rsTemp.Fields("build_type") = "A" Then objPkgInfo.Item("M_checked") = "" objPkgInfo.Item("A_checked") = "checked" objPkgInfo.Item("M_display") = "style='display:none;'" objPkgInfo.Item("A_display") = "style='display:inline;'" End If End If rsTemp.Close Set rsTemp = nothing End Sub '----------------------------------------------------------------------------------------------------------------------------- Function GetVersionNumber(SSpkg_version, SSv_ext) Dim versionNumber If SSv_ext <> "" Then versionNumber = Replace(SSpkg_version, SSv_ext, "") Else versionNumber = SSpkg_version End If GetVersionNumber = versionNumber End Function '----------------------------------------------------------------------------------------------------------------------------- Sub Rename_Pkg_Version ( NNpv_id, SSnewVersion, errMessage ) OraDatabase.Parameters.Add "RTAG_ID", parRtag_id, ORAPARM_INPUT, ORATYPE_NUMBER OraDatabase.Parameters.Add "NNpv_id", NNpv_id, ORAPARM_INPUT, ORATYPE_NUMBER If Request("build_type") = "M" Then ' Manual build OraDatabase.Parameters.Add "SSpkg_version", SSnewVersion & Request("v_ext"), ORAPARM_INPUT, ORATYPE_VARCHAR2 Else ' Automated Build OraDatabase.Parameters.Add "SSpkg_version", Request("v_ext"), ORAPARM_INPUT, ORATYPE_VARCHAR2 End If OraDatabase.Parameters.Add "BUILD_TYPE", Request("build_type"), ORAPARM_INPUT, ORATYPE_CHAR OraDatabase.Parameters.Add "NNuser_id", objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER OraDatabase.Parameters.Add "errMessage", 0, ORAPARM_OUTPUT, ORATYPE_VARCHAR2 objEH.TryORA ( OraSession ) On Error Resume Next OraDatabase.ExecuteSQL _ "BEGIN Rename_Package_Version ( :NNpv_id,"&_ " :SSpkg_version,"&_ " :BUILD_TYPE,"&_ " :NNuser_id,"&_ " :errMessage ); END;" objEH.CatchORA ( OraSession ) errMessage = OraDatabase.Parameters("errMessage").Value OraDatabase.Parameters.Remove "RTAG_ID" OraDatabase.Parameters.Remove "NNpv_id" OraDatabase.Parameters.Remove "SSpkg_version" OraDatabase.Parameters.Remove "NNuser_id" OraDatabase.Parameters.Remove "errMessage" OraDatabase.Parameters.Remove "BUILD_TYPE" End Sub '----------------------------------------------------------------------------------------------------------------------------- %> <% '----------------------- MAIN LINE --------------------------- '--- Process submition --- If CBool(QStrPar("action")) AND objAccessControl.UserLogedIn Then Call Rename_Pkg_Version ( parPv_id, Request("FRnewver"), errMessage ) If NOT IsNull(errMessage) Then Call RaiseMsgInParent ( Eval(errMessage), parRtag_id &"|"& parPv_id) Else Call OpenInParentWindow ( parRfile &"?pv_id="& parPv_id &"&rtag_id="& parRtag_id ) End If Call CloseWindow End If %> <%Call GetPackageInfo( parPv_id, objPkgInfo )%> Release Manager ');selectExtension('<%=objPkgInfo("v_ext")%>');">
');">
 Reversion Package
 
  Package <%=objPkgInfo.Item("pkg_name")%>
  Version Number Assignment <% ' Patches are never auto-built so tell user this if they try to make them so and make sure Manual ' build_type value of the radio button is checked afterwards. If objPkgInfo("is_patch") = "Y" Then%> Auto <%Else%> Auto <%End If%> Manual
  Version
">
(auto-number)