Subversion Repositories DevTools

Rev

Rev 6612 | Rev 6873 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'|                                                   |
'|                 Action Log                    |
'|                                                   |
'=====================================================
%>
<%
Option explicit
' Good idea to set when using redirect
Response.Expires = 0    ' always load the page, dont store
%>
<!--#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"-->
<!--#include file="_tabs.asp"-->
<!--#include file="_action_buttons.asp"-->
<!--#include file="common/_package_common.asp"-->
<%
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_login_optional.asp"-->
<!--#include file="_access_control_general.asp"-->
<%
'------------ Variable Definition -------------
Dim rsTemp
Dim rsQry
Dim retVal
Dim sActionDate, sUsername, sAction_type, sDescription
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
'----------------------------------------------
%>
<html>
<title><%=Title(Request("rtag_id"))%></title>
<link rel="shortcut icon" href="<%=FavIcon%>"/>
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
<script language="JavaScript" src="scripts/remote_scripting.js?ver=<%=VixVerNum%>"></script>
<!--#include file="_jquery_includes.asp"-->
<!-- DROPDOWN MENUS -->
<!--#include file="_menu_def.asp"-->
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
<!-- HEADER -->
<!--#include file="_header.asp"-->
<!-- BODY ---->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr> 
        <td valign="top" width="1" background="images/bg_bage.gif">
        <!-- LEFT -->
        <!--#include file="_environment.asp"-->
        </td>
        <td width="1" bgcolor="#999999"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
        <td valign="top" width="100%">
        <!-- MIDDLE -->
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="1%" background="images/bg_action_norm.gif"><IMG height=35 src="images/spacer.gif" width=15></td>
            <td width="100%" background="images/bg_action_norm.gif"><%Call RenderActionBar(parRtag_id,parPv_id)%></td>
            <td width="1%" background="images/bg_action_norm.gif"><IMG height=1 src="images/spacer.gif" width=15></td>
          </tr>
          <tr>
            <td background="images/bg_lght_gray.gif"><IMG height="45" src="images/spacer.gif" width=1></td>
            <td background="images/bg_lght_gray.gif"><%Call RenderStatus(parRtag_id,parPv_id)%></td>
            <td background="images/bg_lght_gray.gif">&nbsp;</td>
          </tr>
          <tr>
            <td background="images/bg_lght_gray.gif">&nbsp;</td>
            <td valign="bottom" background="images/bg_lght_gray.gif">
              <table width="100" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td><IMG height="1" src="images/spacer.gif" width="0" alt="tab-left-margin" ></td>
                  <td>
                  <!-- TABS ------------------------------------->
                  <%Call Generate_Tab_Menu ( TABarray1, "Action Log", "orange" )%>
                  </td>
                </tr>
              </table>
            </td>
            <td background="images/bg_lght_gray.gif">&nbsp;</td>
          </tr>
          <tr>
            <td background="images/lbox_bg_orange.gif"><IMG height=35 src="images/spacer.gif" width=1></td>
            <td background="images/lbox_bg_orange.gif">
            <!-- TAB ACTION BUTTONS ------------------------------------->
            </td>
            <td background="images/lbox_bg_orange.gif">&nbsp;</td>
          </tr>
          <tr>
            <td></td>
            <td valign="top">
            <!-- DETAILS ------------------------------------------------->
            <br>                      
                        <span class="body_colb">Action Log</span><br>
                        <table width="100%" border="0" cellspacing="1" cellpadding="3" class='stdGrey'>
                            <thead>
                              <tr>
                                <th nowrap width="1%"  >Date&nbsp;</th>
                                <th nowrap width="1%"  >Who&nbsp;</th>
                                <th nowrap width="1%"  >Action&nbsp;&nbsp;</th>
                                <th nowrap width="100%">Description&nbsp;&nbsp;</th>
                              </tr>
                            </thead>
                          <%
                          
                          OraDatabase.Parameters.Add "PV_ID", parPv_id,     ORAPARM_INPUT, ORATYPE_NUMBER 
                          
                          Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("PackageActionLog.sql"), cint(0))
                          %>
                          <%If rsTemp.RecordCount < 1 Then%>
                          <tr>
                            <td nowrap>&nbsp;</td>
                            <td nowrap>&nbsp;</td>
                            <td nowrap>&nbsp;</td>
                            <td nowrap>&nbsp;</td>
                          </tr>
                          <%End If%>
                          <%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
                          <tr> 
                            <td nowrap valign="top" align="right"><%=rsTemp("action_timestamp")%></td>
                            <td nowrap valign="top">by <%=emailField(enum_imgUser & rsTemp("FULL_NAME"),rsTemp("user_email"))%></td>
                            <td nowrap valign="top"><%=rsTemp("acttype")%></td>
                            <td wrap   valign="top"><%=NewLine_To_BR( To_HTML ( rsTemp("description") ) )%></td>
                          </tr>
                          <%rsTemp.MoveNext
                          WEnd
                          rsTemp.Close
                          Set rsTemp = nothing
                          
                          OraDatabase.Parameters.Remove "PV_ID"
                          %>
                        </table>
                        <!------------------------------------------------------------>
           <br>
           
            <!-- END DETAILS ------------------------------------------------->
            </td>
            <td>&nbsp;</td>
          </tr>
        </table>
        <!-- END MIDDLE -------->
        </td>
    </tr>
</table>
<!-- FOOTER -->
<!--#include file="_footer.asp"-->
</body>
</html>