Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
119 ghuddy 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
4653 dpurdie 5
'|                 Action Log                    |
119 ghuddy 6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
' Good idea to set when using redirect
4653 dpurdie 12
Response.Expires = 0    ' always load the page, dont store
119 ghuddy 13
%>
14
<!--#include file="common/conf.asp"-->
15
<!--#include file="common/globals.asp"-->
16
<!--#include file="common/formating.asp"-->
17
<!--#include file="common/qstr.asp"-->
18
<!--#include file="common/common_subs.asp"-->
19
<!--#include file="common/common_dbedit.asp"-->
20
<!--#include file="_tabs.asp"-->
21
<!--#include file="_action_buttons.asp"-->
22
<!--#include file="common/_package_common.asp"-->
23
<%
24
'------------ ACCESS CONTROL ------------------
25
%>
6181 dpurdie 26
<!--#include file="_access_control_login_optional.asp"-->
119 ghuddy 27
<!--#include file="_access_control_general.asp"-->
28
<%
29
'------------ Variable Definition -------------
30
Dim rsTemp
4653 dpurdie 31
Dim rsQry
119 ghuddy 32
Dim retVal
33
Dim sActionDate, sUsername, sAction_type, sDescription
34
'------------ Constants Declaration -----------
35
'------------ Variable Init -------------------
36
'----------------------------------------------
37
%>
38
<html>
39
<title><%=Title(Request("rtag_id"))%></title>
5357 dpurdie 40
<link rel="shortcut icon" href="<%=FavIcon%>"/>
119 ghuddy 41
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
42
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
6579 dpurdie 43
<link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
44
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
45
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
46
<script language="JavaScript" src="scripts/remote_scripting.js?ver=<%=VixVerNum%>"></script>
5085 dpurdie 47
<!--#include file="_jquery_includes.asp"-->
119 ghuddy 48
<!-- DROPDOWN MENUS -->
49
<!--#include file="_menu_def.asp"-->
6579 dpurdie 50
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
119 ghuddy 51
</head>
52
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
53
<!-- HEADER -->
54
<!--#include file="_header.asp"-->
55
<!-- BODY ---->
56
<table width="100%" border="0" cellspacing="0" cellpadding="0">
4653 dpurdie 57
    <tr> 
58
        <td valign="top" width="1" background="images/bg_bage.gif">
59
        <!-- LEFT -->
60
        <!--#include file="_environment.asp"-->
61
        </td>
62
        <td width="1" bgcolor="#999999"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
63
        <td valign="top" width="100%">
64
        <!-- MIDDLE -->
65
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
183 brianf 66
          <tr>
4653 dpurdie 67
            <td width="1%" background="images/bg_action_norm.gif"><IMG height=35 src="images/spacer.gif" width=15></td>
68
            <td width="100%" background="images/bg_action_norm.gif"><%Call RenderActionBar(parRtag_id,parPv_id)%></td>
69
            <td width="1%" background="images/bg_action_norm.gif"><IMG height=1 src="images/spacer.gif" width=15></td>
70
          </tr>
71
          <tr>
183 brianf 72
            <td background="images/bg_lght_gray.gif"><IMG height="45" src="images/spacer.gif" width=1></td>
187 brianf 73
            <td background="images/bg_lght_gray.gif"><%Call RenderStatus(parRtag_id,parPv_id)%></td>
183 brianf 74
            <td background="images/bg_lght_gray.gif">&nbsp;</td>
75
          </tr>
4653 dpurdie 76
          <tr>
77
            <td background="images/bg_lght_gray.gif">&nbsp;</td>
78
            <td valign="bottom" background="images/bg_lght_gray.gif">
6873 dpurdie 79
              <table width="100%" border="0" cellspacing="0" cellpadding="0">
4653 dpurdie 80
                <tr>
4687 dpurdie 81
                  <td><IMG height="1" src="images/spacer.gif" width="0" alt="tab-left-margin" ></td>
4653 dpurdie 82
                  <td>
83
                  <!-- TABS ------------------------------------->
84
                  <%Call Generate_Tab_Menu ( TABarray1, "Action Log", "orange" )%>
85
                  </td>
86
                </tr>
87
              </table>
88
            </td>
89
            <td background="images/bg_lght_gray.gif">&nbsp;</td>
90
          </tr>
6873 dpurdie 91
          <tr class='panel_bg' style="height:35px;">
92
            <td></td>
93
            <td>
4653 dpurdie 94
            <!-- TAB ACTION BUTTONS ------------------------------------->
95
            </td>
6873 dpurdie 96
            <td></td>
4653 dpurdie 97
          </tr>
98
          <tr>
99
            <td></td>
100
            <td valign="top">
101
            <!-- DETAILS ------------------------------------------------->
102
            <br>                      
119 ghuddy 103
                        <span class="body_colb">Action Log</span><br>
6790 dpurdie 104
                        <table width="100%" border="0" cellspacing="1" cellpadding="3" class='stdGrey'>
105
                            <thead>
106
                              <tr>
107
                                <th nowrap width="1%"  >Date&nbsp;</th>
108
                                <th nowrap width="1%"  >Who&nbsp;</th>
109
                                <th nowrap width="1%"  >Action&nbsp;&nbsp;</th>
110
                                <th nowrap width="100%">Description&nbsp;&nbsp;</th>
111
                              </tr>
112
                            </thead>
119 ghuddy 113
                          <%
4653 dpurdie 114
 
115
                          OraDatabase.Parameters.Add "PV_ID", parPv_id,     ORAPARM_INPUT, ORATYPE_NUMBER 
116
 
117
                          Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("PackageActionLog.sql"), cint(0))
118
                          %>
119 ghuddy 119
                          <%If rsTemp.RecordCount < 1 Then%>
6790 dpurdie 120
                          <tr>
4653 dpurdie 121
                            <td nowrap>&nbsp;</td>
122
                            <td nowrap>&nbsp;</td>
123
                            <td nowrap>&nbsp;</td>
124
                            <td nowrap>&nbsp;</td>
119 ghuddy 125
                          </tr>
126
                          <%End If%>
127
                          <%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
6790 dpurdie 128
                          <tr> 
4670 dpurdie 129
                            <td nowrap valign="top" align="right"><%=rsTemp("action_timestamp")%></td>
6612 dpurdie 130
                            <td nowrap valign="top">by <%=emailField(enum_imgUser & rsTemp("FULL_NAME"),rsTemp("user_email"))%></td>
4653 dpurdie 131
                            <td nowrap valign="top"><%=rsTemp("acttype")%></td>
132
                            <td wrap   valign="top"><%=NewLine_To_BR( To_HTML ( rsTemp("description") ) )%></td>
119 ghuddy 133
                          </tr>
134
                          <%rsTemp.MoveNext
4653 dpurdie 135
                          WEnd
136
                          rsTemp.Close
137
                          Set rsTemp = nothing
138
 
139
                          OraDatabase.Parameters.Remove "PV_ID"
140
                          %>
119 ghuddy 141
                        </table>
142
                        <!------------------------------------------------------------>
143
           <br>
144
 
4653 dpurdie 145
            <!-- END DETAILS ------------------------------------------------->
146
            </td>
147
            <td>&nbsp;</td>
148
          </tr>
149
        </table>
150
        <!-- END MIDDLE -------->
151
        </td>
152
    </tr>
119 ghuddy 153
</table>
154
<!-- FOOTER -->
155
<!--#include file="_footer.asp"-->
156
</body>
4653 dpurdie 157
</html>