Subversion Repositories DevTools

Rev

Rev 5175 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5175 Rev 5177
Line 1251... Line 1251...
1251
   Dim rsQry,query
1251
   Dim rsQry,query
1252
 
1252
 
1253
   ' Set defaults
1253
   ' Set defaults
1254
   nProjId    = -1
1254
   nProjId    = -1
1255
   nRtagId    = -1
1255
   nRtagId    = -1
1256
   nPvId       = -1
1256
   nPvId      = -1
1257
 
1257
 
1258
   ' Get parameters from database
1258
   ' Get parameters from database
1259
   OraDatabase.Parameters.Add "ProjId",        Request("proj_id"),   ORAPARM_INPUT, ORATYPE_VARCHAR2
1259
   OraDatabase.Parameters.Add "ProjId",        Request("proj_id"),   ORAPARM_INPUT, ORATYPE_VARCHAR2
1260
   OraDatabase.Parameters.Add "Rtag_id",       Request("rtag_id"),   ORAPARM_INPUT, ORATYPE_VARCHAR2
1260
   OraDatabase.Parameters.Add "Rtag_id",       Request("rtag_id"),   ORAPARM_INPUT, ORATYPE_VARCHAR2
1261
   OraDatabase.Parameters.Add "results",       NULL, ORAPARM_OUTPUT, ORATYPE_CURSOR
1261
   OraDatabase.Parameters.Add "results",       NULL, ORAPARM_OUTPUT, ORATYPE_CURSOR
Line 1270... Line 1270...
1270
 
1270
 
1271
 
1271
 
1272
   If rsQry.RecordCount > 0 Then
1272
   If rsQry.RecordCount > 0 Then
1273
      nProjId    = CDbl(rsQry("PROJ_ID"))
1273
      nProjId    = CDbl(rsQry("PROJ_ID"))
1274
      nRtagId    = CDbl(rsQry("RTAG_ID"))
1274
      nRtagId    = CDbl(rsQry("RTAG_ID"))
1275
 
-
 
1276
   End If
1275
   End If
1277
 
1276
 
1278
   rsQry.Close()
1277
   rsQry.Close()
1279
   Set rsQry = nothing
1278
   Set rsQry = nothing
1280
 
1279
 
1281
 
-
 
1282
   ' Set pv_id parameter
1280
   ' Set pv_id parameter
1283
   If Request("pv_id") <> "" Then nPvId = CDbl(Request("pv_id"))
1281
   If Request("pv_id") <> "" Then nPvId = CDbl(Request("pv_id"))
1284
 
1282
 
1285
 
-
 
1286
End Function
1283
End Function
1287
'-----------------------------------------------------------------------------------------------------------------------------
1284
'-----------------------------------------------------------------------------------------------------------------------------
1288
Function GetEnvName ( nEnvTab )
1285
Function GetEnvName ( nEnvTab )
1289
   Select Case CInt( nEnvTab )
1286
   Select Case CInt( nEnvTab )
1290
      Case enumENVTAB_WORK_IN_PROGRESS
1287
      Case enumENVTAB_WORK_IN_PROGRESS
Line 2005... Line 2002...
2005
	objEH.CatchORA ( OraSession )
2002
	objEH.CatchORA ( OraSession )
2006
 
2003
 
2007
	OraDatabase.Parameters.Remove "RETURN_CODE"
2004
	OraDatabase.Parameters.Remove "RETURN_CODE"
2008
	OraDatabase.Parameters.Remove "RTAG_ID"
2005
	OraDatabase.Parameters.Remove "RTAG_ID"
2009
	OraDatabase.Parameters.Remove "PV_ID"	
2006
	OraDatabase.Parameters.Remove "PV_ID"	
-
 
2007
End Function
-
 
2008
'--------------------------------------------------------------------------------------------------------------------------
-
 
2009
'   Returns either the value of the Request('tag') or the default value       
-
 
2010
Function RequestDefault(stag, sdefault)
-
 
2011
   If Request(stag) <> "" Then
-
 
2012
       RequestDefault = Request(stag)
2010
 
2013
   Else 
-
 
2014
       RequestDefault = sdefault
-
 
2015
   End If
2011
End Function
2016
End Function
2012
%>
2017
%>