Subversion Repositories DevTools

Rev

Rev 62 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'|                                                   |
'|                                ReleaseTo                                      |
'|                                                   |
'=====================================================
%>
<%
Option explicit
Response.Expires = 0
%>
<!--#include file="common/globals.asp"-->
<!--#include file="common/config.asp"-->
<!--#include file="common/common_subs.asp"-->
<!--#include file="common/_form_window_common.asp"-->
<%
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_general.asp"-->
<%
'------------ VARIABLE DEFINITION -------------
Dim rsQry
Dim parState_id
Dim parBom_id_list
'------------ CONSTANTS DECLARATION -----------
'------------ VARIABLE INIT -------------------
parState_id = Request("state_id")
parBom_id_list = Request("bom_id_list")
'------------ CONDITIONS ----------------------
'----------------------------------------------
%>
<%
'--------------------------------------------------------------------------------------------------------------------------
Sub GetFormDetails ( nState_id, ByRef outobjDetails )
        Dim rsQry, query
        OraDatabase.Parameters.Add "STATE_ID",          nState_id,              ORAPARM_INPUT, ORATYPE_NUMBER 
        
        query = _
        " SELECT st.STATE_SEQ FROM STATES st WHERE st.STATE_ID = :STATE_ID"
        
        Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
        
        If rsQry.RecordCount > 0 Then
                outobjDetails.Item ("state_seq") = rsQry("state_seq")
                
        End If
        
        OraDatabase.Parameters.Remove "STATE_ID"
        
        rsQry.Close
        Set rsQry = Nothing
End Sub
'--------------------------------------------------------------------------------------------------------------------------
Sub ReleaseTo ()
        On Error Resume Next
        
        OraDatabase.Parameters.Add "BOM_ID",            Request("bom_id_list"),                 ORAPARM_INPUT, ORATYPE_NUMBER
        OraDatabase.Parameters.Add "USER_ID",           objAccessControl.UserId,                ORAPARM_INPUT, ORATYPE_NUMBER 
        OraDatabase.Parameters.Add "TOSTATE_ID",        Request("tostate_id"),                  ORAPARM_INPUT, ORATYPE_NUMBER 
        OraDatabase.Parameters.Add "COMMENTS",          Request("release_to_comments"), ORAPARM_INPUT, ORATYPE_VARCHAR2
        
        
        objEH.TryORA ( OraSession )
        
        OraDatabase.ExecuteSQL _
        "BEGIN   pk_Bom.Release_To ( :BOM_ID, :USER_ID, :TOSTATE_ID, :COMMENTS );   END;"
        
        objEH.CatchORA ( OraSession )
        
        
        OraDatabase.Parameters.Remove "BOM_ID"
        OraDatabase.Parameters.Remove "USER_ID"
        OraDatabase.Parameters.Remove "TOSTATE_ID"
        OraDatabase.Parameters.Remove "COMMENTS"
        
End Sub
'--------------------------------------------------------------------------------------------------------------------------
%>
<%
'------------ RUN BEFORE PAGE RENDER ----------
' --- Get Form details from DB ---
Call GetFormDetails ( Request("state_id"), objFormCollector )

' --- Load Validation Rules ---
Call objForm.LoadValidationRules ( Array("release_to_comments"), OraDatabase )          ' Load Validation Rules

' --- Enter Form Validation Rule Changes here... ----
'----------------------------------------------------

' --- RUN onPostBack ---
If Request("action") <> "" Then
        If objForm.IsValidOnPostBack Then
                ' --- Form is Valid ---
                Call ReleaseTo()
                
                If objEH.Finally Then
                        Call OpenInWindow ( Request("rfile") &"?DONE=OK"& objPMod.ComposeURLWithout("rfile") )
                End If
                
        End If
End If

'----------------------------------------------
%>
<html>
<head>
<title>Deployment Manager</title>
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
<script language="JavaScript" src="scripts/common.js"></script>

</head>
<body background="images/bg_lite_blue.gif" leftmargin="0" topmargin="0" onLoad="FormName.release_to_comments.focus();">
<!-- HEADER ++++++++++++++++ -->
<!--#include file="_header.asp"-->
<!-- +++++++++++++++++++++++ -->
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
<form name="FormName" method="post" action="<%=SCRIPT_NAME%>" onSubmit="ShowProgress();">
  <tr>
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="42"></td>
  </tr>
  <tr>
    <td align="center" valign="middle" bgcolor="#FFFFFF">
        <!-- LOGIN FROM ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
    <table width="570" border="0" cellspacing="0" cellpadding="1">
        <tr>
          <td background="images/bg_bage_2.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td bgcolor="#FFFFFF"><table width="100%"  border="0" cellspacing="0" cellpadding="10">
                <tr>
                  <td bgcolor="#FFFFFF" class="body_txt"><span class="body_h1"><img src="icons/mi_release_to.gif" width="19" height="19" align="absmiddle" border="0">&nbsp;Release BOM</span> <br>
                        Select where do you want to release BOM.</td>
                </tr>
                <tr>
                  <td background="images/bg_bage_0.gif"><table width="100%"  border="0" cellspacing="2" cellpadding="0">
                      <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
                      <%If NOT objEH.Finally Then%>
                      <tr>
                        <td class="form_iname">&nbsp;</td>
                        <td>
                          <%objEH.DisplayMessage()%>
                        </td>
                        <td class="val_err"></td>
                      </tr>
                      <%End If%>
                      <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
                      <tr>
                        <td valign="top" nowrap class="form_iname">Release To </td>
                        <td valign="top" class="body_txt">
                          <select name="tostate_id" class="form_ivalue" >
                          <%
                                                  OraDatabase.Parameters.Add "TOSTATE_ID",  Request("tostate_id"),                                      ORAPARM_INPUT, ORATYPE_NUMBER 
                                                  OraDatabase.Parameters.Add "PROJ_ID",   Request("proj_id"),                                   ORAPARM_INPUT, ORATYPE_NUMBER 
                                                  OraDatabase.Parameters.Add "STATE_SEQ", objFormCollector.Item("state_seq"),   ORAPARM_INPUT, ORATYPE_NUMBER 
                                                  
                                                  
                                                  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ReleaseToStateList.sql"), ORADYN_DEFAULT )
                                                  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
                                                  %>
                            <option value="<%=rsQry("state_id")%>" <%=rsQry("selected")%>><%=rsQry("state_name").Value%></option>
                          <%
                                                        rsQry.MoveNext
                                                  WEnd
                                                  rsQry.Close
                                                  
                                                  OraDatabase.Parameters.Remove "TOSTATE_ID"
                                                  OraDatabase.Parameters.Remove "PROJ_ID"
                                                  OraDatabase.Parameters.Remove "STATE_SEQ"
                                                  %>
                          </select>
                        </td>
                        <td valign="top"></td>
                      </tr>
                      <tr>
                        <td valign="top" nowrap class="form_iname">Comments</td>
                        <td valign="top"><textarea name="release_to_comments" cols="60" rows="14" class="form_ivalue"><%=Request("release_to_comments")%></textarea></td>
                        <td valign="top"><%=objForm.Validate ("release_to_comments")%> </td>
                      </tr>
                      <tr>
                        <td width="10%" class="form_iname">&nbsp;</td>
                        <td width="1%">&nbsp;</td>
                        <td width="90%" class="val_err"></td>
                      </tr>
                  </table></td>
                </tr>
                                <tr>
                  <td background="images/bg_login.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td></td>
                        <td align="right"><input name="btn" type="submit" class="form_btn" value="Submit">
                            <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="window.location='<%=Request("rfile") &"?CANCEL=OK"& objPMod.ComposeURLWithout("rfile")%>';"></td>
                      </tr>
                  </table></td>
                </tr>
                <%=objPMod.ComposeHiddenTags()%>
                <input type="hidden" name="bom_id_list" value="<%=parBom_id_list%>">
                <input type="hidden" name="action" value="true">
              </table>                </td>
            </tr>
          </table></td>
        </tr>
      </table>
          <!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->   </td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="42"></td>
  </tr>
</form>  
</table>
<!-- FOOTER ++++++++++++++++++++++ -->
<!--#include file="_footer.asp"-->
<!-- +++++++++++++++++++++++++++++ -->
</body>
</html>
<%
'------------ RUN AFTER PAGE RENDER -----------
Set objPMod = Nothing
'----------------------------------------------
%>
<!--#include file="common/globals_destructor.asp"-->