Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
15 rsolanki 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5
'|			          wAddProd					 	 |
6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
Response.Expires = 0
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
'------------ ACCESS CONTROL ------------------
19
%>
20
<!--#include file="_access_control_general.asp"-->
21
<%
22
'------------ VARIABLE DEFINITION -------------
23
Dim rsQry, healthTag, cmdInterface, pkgOwner, isInterface, package
24
Dim objFormCollector
25
Dim sMessage
26
Dim SEQ_proc_id
27
'------------ CONSTANTS DECLARATION -----------
28
Const LIMG_PRODUCT = "<img src='icons/i_product.gif' width='19' height='19' hspace='2' align='absmiddle'>"
29
Const LIMG_PRODUCT_UNPACKAGED = "<img src='icons/i_product_unpackaged.gif' width='19' height='19' hspace='2' align='absmiddle' title='Product is unofficial'>"
30
Const LIMG_PRODUCT_PATCH = "<img src='icons/i_patch_small.gif' hspace='2' align='absmiddle'>"
31
'------------ VARIABLE INIT -------------------
32
sMessage = NULL
33
isInterface = NULL
34
parOs_id = Request("os_id")
35
parBom_id = Request("bom_id")
36
Set objFormCollector = CreateObject("Scripting.Dictionary")
37
'------------ CONDITIONS ----------------------
38
'----------------------------------------------
39
%>
40
<%
41
 
42
%>
43
<%
44
'------------ RUN BEFORE PAGE RENDER ----------
45
 
46
 
47
If CBool(Request("action")) Then
48
 
49
  If Request("isInterface") = "" Then
50
  	isInterface = "F"
51
  Else
52
  	isInterface = "T"
53
  End If		
54
 
55
	objEH.Try
56
 
57
	SEQ_proc_id = Get_From_DUAL("SEQ_PROC_ID.nextval")
58
 
59
	OraDatabase.Parameters.Add "PROC_ID", 			SEQ_proc_id, ORAPARM_INPUT, ORATYPE_NUMBER
60
	OraDatabase.Parameters.Add "PKG_HEALTH_TAG", 	Request("healthTag"), ORAPARM_INPUT, ORATYPE_VARCHAR2
61
	OraDatabase.Parameters.Add "OS_ID", 			Request("os_id"), ORAPARM_INPUT, ORATYPE_NUMBER
62
	OraDatabase.Parameters.Add "CMD_INTERFACE", 	Request("cmdInterface"), ORAPARM_INPUT, ORATYPE_VARCHAR2
63
	OraDatabase.Parameters.Add "PKG_OWNER", 		Request("pkgOwner"), ORAPARM_INPUT, ORATYPE_VARCHAR2	
64
	OraDatabase.Parameters.Add "IS_INTERFACE", 		isInterface, ORAPARM_INPUT, ORATYPE_VARCHAR	
65
	OraDatabase.Parameters.Add "PROD_ID", 			Request("prod_id"), ORAPARM_INPUT, ORATYPE_NUMBER	
66
	OraDatabase.Parameters.Add "USER_ID", 			objAccessControl.UserId, 	ORAPARM_INPUT, ORATYPE_NUMBER 
67
 
68
	OraSession.BeginTrans
69
 
70
	OraDatabase.ExecuteSQL _
71
	"BEGIN  Add_Process( :PROC_ID, :PKG_HEALTH_TAG, :OS_ID, :CMD_INTERFACE, :PKG_OWNER, :IS_INTERFACE, :PROD_ID, :USER_ID);  END;"
72
 
73
    OraSession.CommitTrans	
74
 
75
	OraDatabase.Parameters.Remove "PROC_ID"
76
	OraDatabase.Parameters.Remove "PKG_HEALTH_TAG"
77
	OraDatabase.Parameters.Remove "OS_ID"
78
	OraDatabase.Parameters.Remove "CMD_INTERFACE"
79
	OraDatabase.Parameters.Remove "PKG_OWNER"		
80
	OraDatabase.Parameters.Remove "IS_INTERFACE"	
81
	OraDatabase.Parameters.Remove "PROD_ID"		
82
	OraDatabase.Parameters.Remove "USER_ID"			
83
 
84
	If objEH.Finally Then
85
		Call OpenInParentWindow ("Os_Processes.asp?bom_id="& parBom_id &"&os_id="& parOs_id)
86
		Call CloseWindow()
87
	End If
88
End If
89
 
90
 
91
'----------------------------------------------
92
%>
93
<html>
94
<head>
95
<title>Deployment Manager</title>
96
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
97
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
98
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
99
<script language="JavaScript" src="scripts/common.js"></script>
100
</head>
101
 
102
<body background="images/bg_bage_0.gif" leftmargin="0" topmargin="0" onLoad="self.focus();FormSearch.prod_name.focus();">
103
<table width="100%"  border="0" cellspacing="0" cellpadding="10">
104
  <tr>
105
    <td bgcolor="#FFFFFF" class="body_txt"><span class="body_h1"><img src="icons/i_linkarrow_black.gif" width="11" height="11" align="absmiddle">&nbsp;Add Process</span> <br>
106
    Add a process for the node.
107
      </td>
108
  </tr>
109
 
110
<%
111
 
112
%>
113
 
114
<%
115
'-- FROM START --------------------------------------------------------------------------------------------------------------
116
objFormComponent.FormName = "FormName"
117
objFormComponent.Action = SCRIPT_NAME
118
objFormComponent.OnSubmit = "ShowProgress();"
119
Call objFormComponent.FormStart()
120
 
121
%>  
122
  <tr>
123
    <td background="images/bg_login.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
124
      <tr>
125
        <td><%=ProgressBar()%></td>
126
        <td align="right"><input name="btn" type="submit" class="form_btn" value="Add">
127
          <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="self.close();"></td>
128
      </tr>
129
    </table></td>
130
  </tr>
131
  <tr>
132
    <td>
133
<!-- NEW PRODUCT ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->		
134
	<%Call Messenger ( sMessage , 3, "100%" )%>
135
	<!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->	
136
	<!--#include file="messages/_msg_inline.asp"-->
137
<table width="664" border="0">
138
  <tr>
139
    <td><span class="body_txt">Package Health Tag</span>&nbsp;</td>
140
    <td><input name="healthTag" type="text" class="body_txt" value="<%=healthTag%>">&nbsp;</td>
141
  </tr>
142
  <tr>
143
    <td><span class="body_txt">Package/Product</span></td>
144
    <td><%
145
	Dim rsTemp
146
 
147
	OraDatabase.Parameters.Add "OS_ID", 	Request("os_id"), 	ORAPARM_INPUT, ORATYPE_VARCHAR2
148
 
149
	Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("ProductsLessPatches.sql"), cint(0))
150
 
151
 
152
	Response.write "<select name='prod_id' class='body_txt'>"
153
	Response.write "<option value =''>"
154
 
155
		While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
156
 
157
				Response.write "<option value='"& rsTemp.Fields("prod_id") &"'>"& (rsTemp.Fields("pkg_name")) &" - "& (rsTemp.Fields("pkg_version")) &"</option>"
158
 
159
			rsTemp.MoveNext
160
		WEnd
161
	Response.write "</select>"
162
 
163
	rsTemp.Close
164
	Set rsTemp = nothing	
165
 
166
	OraDatabase.Parameters.Remove "OS_ID"
167
 
168
	%></td>
169
  </tr>
170
  <tr>
171
    <td><span class="body_txt">Command Interface</span></td>
172
    <td><input name="cmdInterface" type="text" class="body_txt" value="<%=cmdInterface%>" size=80></td>
173
  </tr>
174
  <tr>
175
    <td><span class="body_txt">Is Interface</span></td>
176
    <td><input type="checkbox" name="isInterface">
177
      <span class="body_txt">(Checked If True)</span> </td>
178
  </tr>
179
  <tr>
180
    <td><span class="body_txt">Package Owner</span></td>
181
    <td><input name="pkgOwner" type="text" class="body_txt" value="<%=pkgOwner%>">
182
	</td>
183
  </tr>
184
  <tr>
185
    <td>&nbsp;</td>
186
    <td>&nbsp;</td>
187
  </tr>  
188
</table>    
189
 
190
 
191
 
192
 
193
 
194
 
195
</td>
196
  </tr>
197
  <%=objPMod.ComposeHiddenTags()%>
198
  <input type="hidden" name="action" value="true">
199
 
200
 
201
<%
202
Call objFormComponent.FormEnd()
203
'-- FROM END ----------------------------------------------------------------------------------------------------------------
204
%>
205
</table>
206
</body>
207
</html>
208
<%
209
'------------ RUN AFTER PAGE RENDER -----------
210
Set objFormCollector = Nothing
211
'----------------------------------------------
212
%><!--#include file="common/globals_destructor.asp"-->