Subversion Repositories DevTools

Rev

Rev 5513 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
27 rsolanki 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5
'|			          Log Download				 	 |
6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
Response.Expires = 0	' always load the page, dont store
12
%>
13
<!--#include file="common/globals.asp"-->
14
<!--#include file="common/config.asp"-->
15
<!--#include file="common/common_subs.asp"-->
16
<!--#include file="common/_popup_window_common.asp"-->
17
 
18
<%
19
'------------ VARIABLE DEFINITION -------------
20
'------------ CONSTANTS DECLARATION -----------
21
'------------ VARIABLE INIT -------------------
22
'------------ CONDITIONS ----------------------
23
'----------------------------------------------
24
%>
25
<%
26
'--------------------------------------------------------------------------------------------------------------------------
27
 
28
'--------------------------------------------------------------------------------------------------------------------------
29
%>
30
<%
31
'**************************** M  A  I  N ******************************
32
 
33
If Request("pkg_id") <> "" Then
34
 
35
	OraDatabase.Parameters.Add "PKG_ID", 	  Request("pkg_id"), 		ORAPARM_INPUT, ORATYPE_NUMBER
36
	OraDatabase.Parameters.Add "USER_ID", 	  objAccessControl.UserId, 		ORAPARM_INPUT, ORATYPE_NUMBER
37
	OraDatabase.Parameters.Add "COMMENT", 	  "Downloaded package version "&Request("pkg_version"), 		ORAPARM_INPUT, ORATYPE_NUMBER
38
 
39
	objEH.TryORA ( OraSession )
40
 
41
	OraDatabase.ExecuteSQL _
42
	"BEGIN   pk_production.Log_Pkg_Trail ( :PKG_ID, :COMMENT, :USER_ID  );   END;"
43
 
44
	objEH.CatchORA ( OraSession )
45
 
46
	OraDatabase.Parameters.Remove "PKG_ID"	
47
	OraDatabase.Parameters.Remove "USER_ID"	
48
	OraDatabase.Parameters.Remove "COMMENT"	
49
 
50
Else
51
	Response.write "There is an error in download logging."
52
End If
53
 
54
	If objEH.Finally Then
55
		Call OpenInParentWindow (Request("url"))
56
		Call CloseWindow
57
	End If				
58
'**********************************************************************
5958 dpurdie 59
Call Destroy_All_Objects
27 rsolanki 60
%>