Subversion Repositories DevTools

Rev

Rev 6189 | Rev 6191 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6189 Rev 6190
Line 760... Line 760...
760
 
760
 
761
    var divA = MM_findObj( 'PVA' + rowId );
761
    var divA = MM_findObj( 'PVA' + rowId );
762
    var divB = MM_findObj( 'PVB' + rowId );
762
    var divB = MM_findObj( 'PVB' + rowId );
763
 
763
 
764
    // Set text equal
764
    // Set text equal
765
    divB.innerHTML = divB.getAttribute('data_pkg');
765
    //divB.innerHTML = divB.getAttribute('data_pkg');
766
    divB.style.textDecoration = 'none';
766
    divB.style.textDecoration = 'none';
767
 
767
 
768
    // Set highlight to blank
768
    // Set highlight to blank
769
    divA.style.backgroundColor = divA.getAttribute('data_color');
769
    divA.style.backgroundColor = divA.getAttribute('data_color');
770
    divB.style.backgroundColor = divB.getAttribute('data_color');
770
    divB.style.backgroundColor = divB.getAttribute('data_color');
Line 966... Line 966...
966
                                                                    <tr>
966
                                                                    <tr>
967
                                                                        <td width="1" background="images/bg_action_norm.gif"><input name="difilter" type="checkbox" value="<%=enumDB_NUM_DIFF_UPDATED%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_UPDATED)%>></td>
967
                                                                        <td width="1" background="images/bg_action_norm.gif"><input name="difilter" type="checkbox" value="<%=enumDB_NUM_DIFF_UPDATED%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_UPDATED)%>></td>
968
                                                                        <td width="50" nowrap background="images/bg_action_norm.gif" class="form_field"><%=LIMG_UPDATED%>Updated</td>
968
                                                                        <td width="50" nowrap background="images/bg_action_norm.gif" class="form_field"><%=LIMG_UPDATED%>Updated</td>
969
                                                                    </tr>
969
                                                                    </tr>
970
                                                                    <tr>
970
                                                                    <tr>
-
 
971
                                                                        <td background="images/bg_action_norm.gif"><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_WARN%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_WARN)%>></td>
-
 
972
                                                                        <td nowrap background="images/bg_action_norm.gif" class="form_field"><%=LIMG_UPDATED%>Updated with Warning</td>
-
 
973
                                                                    </tr>
-
 
974
                                                                    <tr>
971
                                                                        <td background="images/bg_action_norm.gif"><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_NEW%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_NEW)%>></td>
975
                                                                        <td background="images/bg_action_norm.gif"><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_NEW%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_NEW)%>></td>
972
                                                                        <td nowrap background="images/bg_action_norm.gif" class="form_field"><%=LIMG_ADDED%>Added</td>
976
                                                                        <td nowrap background="images/bg_action_norm.gif" class="form_field"><%=LIMG_ADDED%>Added</td>
973
                                                                    </tr>
977
                                                                    </tr>
974
                                                                    <tr>
978
                                                                    <tr>
975
                                                                        <td background="images/bg_action_norm.gif"><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_REMOVED%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_REMOVED)%>></td>
979
                                                                        <td background="images/bg_action_norm.gif"><input type="checkbox" name="difilter" value="<%=enumDB_NUM_DIFF_REMOVED%>" <%=GetIsDiffFilterChecked(enumDB_NUM_DIFF_REMOVED)%>></td>
Line 1025... Line 1029...
1025
                                                <%
1029
                                                <%
1026
                                                OraDatabase.Parameters.Add "RTAG_A",     parRtagA,    ORAPARM_INPUT, ORATYPE_NUMBER
1030
                                                OraDatabase.Parameters.Add "RTAG_A",     parRtagA,    ORAPARM_INPUT, ORATYPE_NUMBER
1027
                                                OraDatabase.Parameters.Add "RTAG_B",     parRtagB,    ORAPARM_INPUT, ORATYPE_NUMBER
1031
                                                OraDatabase.Parameters.Add "RTAG_B",     parRtagB,    ORAPARM_INPUT, ORATYPE_NUMBER
1028
                                                OraDatabase.Parameters.Add "NO_CHANGE",  GetIsDiffFilterChecked(enumDB_NUM_DIFF_NO_CHANGE), ORAPARM_INPUT, ORATYPE_VARCHAR2
1032
                                                OraDatabase.Parameters.Add "NO_CHANGE",  GetIsDiffFilterChecked(enumDB_NUM_DIFF_NO_CHANGE), ORAPARM_INPUT, ORATYPE_VARCHAR2
1029
                                                OraDatabase.Parameters.Add "ADDED",      GetIsDiffFilterChecked(enumDB_NUM_DIFF_NEW),       ORAPARM_INPUT, ORATYPE_VARCHAR2
1033
                                                OraDatabase.Parameters.Add "ADDED",      GetIsDiffFilterChecked(enumDB_NUM_DIFF_NEW),       ORAPARM_INPUT, ORATYPE_VARCHAR2
1030
                                                OraDatabase.Parameters.Add "UPDATED",    GetIsDiffFilterChecked(enumDB_NUM_DIFF_UPDATED),   ORAPARM_INPUT, ORATYPE_VARCHAR2
1034
                                                OraDatabase.Parameters.Add "UPDATED",    NULL,                                              ORAPARM_INPUT, ORATYPE_VARCHAR2
1031
                                                OraDatabase.Parameters.Add "REMOVED",    GetIsDiffFilterChecked(enumDB_NUM_DIFF_REMOVED),   ORAPARM_INPUT, ORATYPE_VARCHAR2
1035
                                                OraDatabase.Parameters.Add "REMOVED",    GetIsDiffFilterChecked(enumDB_NUM_DIFF_REMOVED),   ORAPARM_INPUT, ORATYPE_VARCHAR2
1032
 
1036
 
1033
                                                Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleaseDiff.sql"), cint(0))
1037
                                                Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleaseDiff.sql"), cint(0))
1034
 
1038
 
1035
                                                OraDatabase.Parameters.Remove "RTAG_A"
1039
                                                OraDatabase.Parameters.Remove "RTAG_A"
Line 1165... Line 1169...
1165
                                                                End If
1169
                                                                End If
1166
                                                            End If
1170
                                                            End If
1167
                                                        End If
1171
                                                        End If
1168
                                                    End If
1172
                                                    End If
1169
 
1173
 
1170
                                                    ' -------- FILTERS RIPPLE BUILDS WHEN CHECKED -----------------
1174
                                                    ' -------- END GROUP ------------------------
-
 
1175
                                                    %>
-
 
1176
                                                    <%
-
 
1177
                                                    'Determine if we are dealing with a PV_ID that we have already encountered and displayed as a pending addition
1171
                                                    If NOT (GetIsDiffFilterChecked(enumDB_NUM_DIFF_RIPPLE) = "checked" AND changeType = "UR") THEN
1178
                                                    'If we are, we do not need to display anything more about it, so skip the row.
-
 
1179
                                                    ' NOTE. the result set is sorted by change type (see releasediff.sql) such that if there are multiple entries
-
 
1180
                                                    '         for the same PV_ID, they are sorted in the following order: pending, unchanged, additions, removals, updates.
-
 
1181
                                                    '         This is important to the row skip filtering carried out below.
-
 
1182
                                                    Dim skipRow
-
 
1183
                                                    If rsQry("pv_id_a") Then
-
 
1184
                                                        skipRow = pkgSeen.Exists(CStr(rsQry("pv_id_a")))
-
 
1185
                                                        pkgSeen.Item(CStr(rsQry("pv_id_a"))) = 1
-
 
1186
                                                    Else
-
 
1187
                                                        skipRow = FALSE
-
 
1188
                                                    End If
1172
 
1189
 
1173
                                                        ' -------- GROUP BY BASE VIEW  -----------------
-
 
1174
                                                        If CDbl(currView_id) <> CDbl(rsQry("view_id")) Then%>
1190
                                                    If GetIsDiffFilterChecked(enumDB_NUM_DIFF_PENDING) <> "" Then
1175
                                                            <tr>
-
 
1176
                                                                <td valign="top" nowrap class="form_ttl"><b><%=rsQry("view_name")%></b></td>
-
 
1177
                                                                <td class="form_ttl">&nbsp;</td>
-
 
1178
                                                                <td class="form_ttl">&nbsp;</td>
-
 
1179
                                                                <td class="form_ttl">&nbsp;</td>
-
 
1180
                                                                <td class="form_ttl">&nbsp;</td>
-
 
1181
                                                                <td class="form_ttl">&nbsp;</td>
1191
                                                        If changeType = "APS" OR changeType = "APA" Then
1182
                                                            </tr>
1192
                                                            skipRow = TRUE
1183
                                                            <%
-
 
1184
                                                            currView_id = CDbl(rsQry("view_id"))
-
 
1185
                                                        End If
1193
                                                        End If
1186
                                                        ' -------- END GROUP ------------------------
-
 
1187
                                                        %>
-
 
1188
                                                        <%
1194
                                                    End If
1189
                                                        'Determine if we are dealing with a PV_ID that we have already encountered and displayed as a pending addition
-
 
1190
                                                        'If we are, we do not need to display anything more about it, so skip the row.
-
 
1191
                                                        ' NOTE. the result set is sorted by change type (see releasediff.sql) such that if there are multiple entries
-
 
1192
                                                        '         for the same PV_ID, they are sorted in the following order: unchanged, additions, removals, updates.
-
 
-
 
1195
 
1193
                                                        '         This is important to the row skip filtering carried out below.
1196
                                                    If GetIsDiffFilterChecked(enumDB_NUM_DIFF_UPDATED) <> "" Then
1194
                                                        Dim skipRow
-
 
1195
                                                        If rsQry("pv_id_a") Then
1197
                                                        If changeType = "U" Then
1196
                                                            skipRow = pkgSeen.Exists(CStr(rsQry("pv_id_a")))
-
 
1197
                                                            pkgSeen.Item(CStr(rsQry("pv_id_a"))) = 1
-
 
1198
                                                        Else
-
 
1199
                                                            skipRow = FALSE
1198
                                                            skipRow = TRUE
1200
                                                        End If
1199
                                                        End If
-
 
1200
                                                    End If
1201
 
1201
 
1202
                                                        If GetIsDiffFilterChecked(enumDB_NUM_DIFF_PENDING) <> "" Then
1202
                                                    If GetIsDiffFilterChecked(enumDB_NUM_DIFF_WARN) <> "" Then
1203
                                                            If rsQry("CHANGE_TYPE") = "APS" OR rsQry("CHANGE_TYPE") = "APA" Then
-
 
1204
                                                                skipRow = TRUE
1203
                                                        If changeType = "UW" Then
1205
                                                            End If
1204
                                                            skipRow = TRUE
1206
                                                        End If
1205
                                                        End If
-
 
1206
                                                    End If
1207
 
1207
 
1208
                                                        %>
-
 
1209
                                                        <%If NOT skipRow Then%>
-
 
1210
                                                            <tr>
-
 
1211
                                                                <td class="body_row" nowrap>
-
 
1212
                                                                    <DIV id="PVA<%=rowId%>" style="background:<%=colorA%>; padding:5px;" data_color="<%=colorA%>">
-
 
1213
                                                                        <%=rsQry("pkg_name_a") &" "& rsQry("pkg_version_a")%>
-
 
1214
                                                                    </DIV>
-
 
1215
                                                                </td>
-
 
1216
 
-
 
1217
                                                                <%
-
 
1218
                                                                Dim pkgADisplayControl
-
 
1219
                                                                pkgADisplayControl = isMergable
-
 
1220
                                                                If IsNull( changeType ) OR (changeType = "A")  OR (changeType = "B") OR (changeType = "APA")  OR (changeType = "APS")  Then pkgADisplayControl = FALSE
-
 
1221
                                                                If isaSdk Then pkgADisplayControl = FALSE
1208
                                                    If GetIsDiffFilterChecked(enumDB_NUM_DIFF_RIPPLE) <> "" Then
1222
                                                                %>
-
 
1223
                                                                <td bgcolor="#F5F5F5">
-
 
1224
                                                                    <%If pkgADisplayControl Then%>
-
 
1225
                                                                        <DIV id="IMGMERGE<%=rowId%>"><a href="javascript:;" onClick="MergePackage( '<%=rsQry("pv_id_a")%>', '<%=rsQry("pv_id_b")%>', '<%=rowId%>' );"><%=btnMerge%></a></DIV>
-
 
1226
                                                                    <%End If%>
-
 
1227
                                                                </td>
-
 
1228
 
-
 
1229
                                                                <td bgcolor="#E4E9EC">
-
 
1230
                                                                    <DIV id="IMGSTATE<%=rowId%>" DATA_CT="<%=changeType%>"><%=ChangeTypeIcon%></DIV>
-
 
1231
                                                                </td>
-
 
1232
 
-
 
1233
                                                                <%
-
 
1234
                                                                Dim pkgBDisplayControl
-
 
1235
                                                                pkgBDisplayControl = isMergable
-
 
1236
                                                                If changeType = "R" Then pkgBDisplayControl = FALSE
-
 
1237
                                                                If isaSdk Then pkgBDisplayControl = FALSE
-
 
1238
                                                                %>
-
 
1239
                                                                <td bgcolor="#F5F5F5">
-
 
1240
                                                                    <%If pkgBDisplayControl Then%>
-
 
1241
                                                                        <DIV id="IMGREMOVE<%=rowId%>" ><a href="javascript:;" onClick="RemovePackage( '<%=rsQry("pv_id_a")%>', '<%=rsQry("pv_id_b")%>', '<%=rowId%>' );"><%=btnRemove%></a></DIV>
-
 
1242
                                                                    <%ElseIf isaSdk Then %> 
-
 
1243
                                                                        <DIV ><%=LIMG_SDK%></DIV>
-
 
1244
                                                                    <%End If%>
-
 
1245
                                                                </td>
-
 
1246
 
-
 
1247
                                                                <td class="body_row" nowrap>
-
 
1248
                                                                    <DIV id="PVB<%=rowId%>" 
-
 
1249
                                                                         style="background:<%=colorB%>; padding:5px;" 
-
 
1250
                                                                         data_color="<%=colorB%>"
-
 
1251
                                                                         data_pkg="<%=rsQry("pkg_name_b") &" "& rsQry("pkg_version_b")%>"
-
 
1252
                                                                         >
-
 
1253
                                                                        <%=rsQry("pkg_name_b") &" "& rsQry("pkg_version_b")%>
-
 
1254
                                                                        <%If ChangeType = "APS" Then%>
1209
                                                        If changeType = "UR" Then
1255
                                                                                (removal pending<%=Quick_Help("RemovalPending")%>)
-
 
1256
                                                                        <%ElseIf ChangeType = "APA" Then%>
-
 
1257
                                                                                (addition pending<%=Quick_Help("AdditionPending")%>)
-
 
1258
                                                                        <%End If %>
-
 
1259
                                                                    </DIV>
1210
                                                            skipRow = TRUE
1260
                                                                    <input type="hidden" disabled="disabled" name="addpkg" id="ADDPKG_<%=rowId%>" value="">
-
 
1261
                                                                    <input type="hidden" disabled="disabled" name="removepkg" id="REMOVEPKG_<%=rowId%>" value="">
-
 
1262
                                                                </td>
-
 
1263
 
-
 
1264
                                                                <td bgcolor="#F5F5F5">
-
 
1265
                                                                    <DIV id="IMGUNDO<%=rowId%>" style="display:none;" >
-
 
1266
                                                                        <a href="javascript:;" onClick="UndoPackage( '<%=rowId%>' );"><%=LIMG_UNDO%></a>
-
 
1267
                                                                    </DIV>
-
 
1268
                                                                </td>
-
 
1269
                                                            </tr>
-
 
1270
                                                        <%End If %>
1211
                                                        End If
1271
 
-
 
1272
                                                        <%
1212
                                                    End If
1273
                                                        If genReport AND NOT skipRow  Then
-
 
1274
                                                            If rsQry("pv_id_a") Then
-
 
1275
                                                                Set rsQryCommentsA = OraDatabase.DbCreateDynaset( "SELECT COMMENTS FROM PACKAGE_VERSIONS WHERE PV_ID="& rsQry("pv_id_a"), cint(0))
-
 
1276
                                                            End If
-
 
1277
 
1213
 
-
 
1214
                                                    If NOT skipRow Then
-
 
1215
                                                    ' -------- GROUP BY BASE VIEW  -----------------
-
 
1216
                                                    If CDbl(currView_id) <> CDbl(rsQry("view_id")) Then
-
 
1217
                                                    %>
-
 
1218
                                                        <tr>
-
 
1219
                                                            <td valign="top" nowrap class="form_ttl"><b><%=rsQry("view_name")%></b></td>
-
 
1220
                                                            <td class="form_ttl">&nbsp;</td>
-
 
1221
                                                            <td class="form_ttl">&nbsp;</td>
-
 
1222
                                                            <td class="form_ttl">&nbsp;</td>
-
 
1223
                                                            <td class="form_ttl">&nbsp;</td>
-
 
1224
                                                            <td class="form_ttl">&nbsp;</td>
-
 
1225
                                                        </tr>
-
 
1226
                                                    <%
-
 
1227
                                                        currView_id = CDbl(rsQry("view_id"))
-
 
1228
                                                    End If
-
 
1229
                                                    %>
-
 
1230
                                                        <tr>
1278
                                                            If rsQry("pv_id_b") Then
1231
                                                            <td class="body_row" nowrap>
-
 
1232
                                                                <DIV id="PVA<%=rowId%>" style="background:<%=colorA%>; padding:5px;" data_color="<%=colorA%>">
1279
                                                                Set rsQryCommentsB = OraDatabase.DbCreateDynaset( "SELECT COMMENTS FROM PACKAGE_VERSIONS WHERE PV_ID="& rsQry("pv_id_b"), cint(0))
1233
                                                                    <%=rsQry("pkg_name_a") &" "& rsQry("pkg_version_a")%>
-
 
1234
                                                                </DIV>
1280
                                                            End If
1235
                                                            </td>
1281
 
1236
 
-
 
1237
                                                            <%
-
 
1238
                                                            Dim pkgADisplayControl
1282
                                                            pkgA = rsQry("pkg_name_a")
1239
                                                            pkgADisplayControl = isMergable
-
 
1240
                                                            If IsNull( changeType ) OR (changeType = "A")  OR (changeType = "B") OR (changeType = "APA")  OR (changeType = "APS")  Then pkgADisplayControl = FALSE
-
 
1241
                                                            If isaSdk Then pkgADisplayControl = FALSE
-
 
1242
                                                            %>
1283
                                                            pkgB = rsQry("pkg_name_b")
1243
                                                            <td bgcolor="#F5F5F5">
-
 
1244
                                                                <%If pkgADisplayControl Then%>
-
 
1245
                                                                    <DIV id="IMGMERGE<%=rowId%>"><a href="javascript:;" onClick="MergePackage( '<%=rsQry("pv_id_a")%>', '<%=rsQry("pv_id_b")%>', '<%=rowId%>' );"><%=btnMerge%></a></DIV>
-
 
1246
                                                                <%End If%>
-
 
1247
                                                            </td>
1284
 
1248
 
1285
                                                            If pkgA <> "" then
1249
                                                            <td bgcolor="#E4E9EC">
1286
                                                                pkgname = pkgA
1250
                                                                <DIV id="IMGSTATE<%=rowId%>" DATA_CT="<%=changeType%>"><%=ChangeTypeIcon%></DIV>
1287
                                                            Else
1251
                                                            </td>
1288
                                                                pkgname = pkgB
-
 
1289
                                                            End If
-
 
1290
 
1252
 
1291
                                                            If changeType = "U" OR  changeType = "UW" Then
-
 
1292
                                                                ChangeASource = false
1253
                                                            <%
1293
                                                                ChangeAUpdate = false
1254
                                                            Dim pkgBDisplayControl
1294
                                                                ChangeBSource = false
1255
                                                            pkgBDisplayControl = isMergable
1295
                                                                ChangeBUpdate = false
1256
                                                            If changeType = "R" Then pkgBDisplayControl = FALSE
1296
 
-
 
1297
                                                                'NewTextFile.WriteLine("<br><b><font face="&chr(34)&"arial"&chr(34)&">"&pkgname&"</font></b>")
-
 
1298
                                                                NewTextFile.Write("<a href=""javascript:;"" class=""body_scol"" onClick=""toggleSPAN('"& rowId &"');"">"& pkgname &"</a>")
-
 
1299
                                                                NewTextFile.WriteLine("<DIV class=divPkgInfo id=""spanPkgInfo"& rowId &""" name=""spanPkgInfo"" style=""display:none;"">")
-
 
1300
                                                                NewTextFile.Write(rsQryA("rtag_name")&" uses: "&rsQry("pkg_version_a")&" (")
-
 
1301
                                                                Call Release(rsQry("pv_id_a"))
-
 
1302
                                                                NewTextFile.WriteLine(")<br>")
-
 
1303
                                                                NewTextFile.Write(rsQryB("rtag_name")&" uses: "&rsQry("pkg_version_b")&" (")
-
 
1304
                                                                Call Release(rsQry("pv_id_b"))
1257
                                                            If isaSdk Then pkgBDisplayControl = FALSE
1305
                                                                NewTextFile.WriteLine(")<br>")
-
 
1306
 
-
 
1307
                                                                a = rsQry("pv_id_a")
1258
                                                            %>
1308
                                                                b = rsQry("pv_id_b")
1259
                                                            <td bgcolor="#F5F5F5">
1309
                                                                c = rsQry("pv_id_a")
-
 
1310
                                                                d = rsQry("pv_id_b")
-
 
1311
 
-
 
1312
                                                                Set pvCollectionA = CreateObject("Scripting.Dictionary")
-
 
1313
                                                                Set pvCollectionB = CreateObject("Scripting.Dictionary")
-
 
1314
                                                                On Error Resume Next
-
 
1315
                                                                While CLng(a) <> CLng(b) and NOT errormsg
-
 
1316
 
-
 
1317
                                                                    'NewTextFile.WriteLine("A: "&a)
-
 
1318
                                                                    'NewTextFile.WriteLine("B: "&b)
-
 
1319
                                                                    pvCollectionA.Add CStr(a), Empty
-
 
1320
                                                                    pvCollectionB.Add CStr(b), Empty
-
 
1321
                                                                    If CLng(a) > CLng(b) Then
1260
                                                                <%If pkgBDisplayControl Then%>
1322
                                                                        'NewTextFile.WriteLine("TestA")
1261
                                                                    <DIV id="IMGREMOVE<%=rowId%>" ><a href="javascript:;" onClick="RemovePackage( '<%=rsQry("pv_id_a")%>', '<%=rsQry("pv_id_b")%>', '<%=rowId%>' );"><%=btnRemove%></a></DIV>
1323
                                                                        Call LastPvIdA(a)
-
 
1324
                                                                    ElseIf CLng(b) > CLng(a) Then
1262
                                                                <%ElseIf isaSdk Then %> 
1325
                                                                        'NewTextFile.WriteLine("TestB")
-
 
1326
                                                                        Call LastPvIdB(b)
1263
                                                                    <DIV ><%=LIMG_SDK%></DIV>
1327
                                                                    End If
1264
                                                                <%End If%>
1328
                                                                Wend
1265
                                                            </td>
1329
 
1266
 
-
 
1267
                                                            <td class="body_row" nowrap>
-
 
1268
                                                                <DIV id="PVB<%=rowId%>" 
-
 
1269
                                                                     style="background:<%=colorB%>; padding:5px;" 
1330
                                                                Set pvCollectionA = Nothing
1270
                                                                     data_color="<%=colorB%>"
-
 
1271
                                                                     data_pkg="<%=rsQry("pkg_name_b") &" "& rsQry("pkg_version_b")%>"
-
 
1272
                                                                     >
-
 
1273
                                                                    <%=rsQry("pkg_name_b") &" "& rsQry("pkg_version_b")%>
-
 
1274
                                                                    <%If ChangeType = "APS" Then%>
-
 
1275
                                                                            (removal pending<%=Quick_Help("RemovalPending")%>)
-
 
1276
                                                                    <%ElseIf ChangeType = "APA" Then%>
-
 
1277
                                                                            (addition pending<%=Quick_Help("AdditionPending")%>)
1331
                                                                Set pvCollectionB = Nothing
1278
                                                                    <%End If %>
-
 
1279
                                                                </DIV>
-
 
1280
                                                                <input type="hidden" disabled="disabled" name="addpkg" id="ADDPKG_<%=rowId%>" value="">
-
 
1281
                                                                <input type="hidden" disabled="disabled" name="removepkg" id="REMOVEPKG_<%=rowId%>" value="">
-
 
1282
                                                            </td>
1332
 
1283
 
1333
                                                                Call pkg_Version(a)
1284
                                                            <td bgcolor="#F5F5F5">
1334
                                                                NewTextFile.Write("Common PARENT package version: "&pkgversion&" (")
1285
                                                                <DIV id="IMGUNDO<%=rowId%>" style="display:none;" >
-
 
1286
                                                                    <a href="javascript:;" onClick="UndoPackage( '<%=rowId%>' );"><%=LIMG_UNDO%></a>
1335
                                                                Call Release(a)
1287
                                                                </DIV>
1336
                                                                NewTextFile.WriteLine(")<br><br>")
1288
                                                            </td>
1337
                                                                NewTextFile.WriteLine()
1289
                                                        </tr>
1338
                                                                NewTextFile.WriteLine("<b>"&rsQryA("rtag_name")&"</b>")
1290
                                                    <%End If %>
1339
 
1291
 
-
 
1292
                                                    <%
-
 
1293
                                                    If genReport AND NOT skipRow  Then
1340
                                                                If pkgversion <> rsQry("pkg_version_a") Then
1294
                                                        If rsQry("pv_id_a") Then
1341
                                                                    NewTextFile.WriteLine("<blockquote><b><i>Versions between "& pkgversion &" and "& rsQry("pkg_version_a")&"</i></b></blockquote>")
1295
                                                            Set rsQryCommentsA = OraDatabase.DbCreateDynaset( "SELECT COMMENTS FROM PACKAGE_VERSIONS WHERE PV_ID="& rsQry("pv_id_a"), cint(0))
-
 
1296
                                                        End If
1342
 
1297
 
1343
                                                                    If errormsg Then
1298
                                                        If rsQry("pv_id_b") Then
1344
                                                                        NewTextFile.WriteLine("Error determining root!<br>")
1299
                                                            Set rsQryCommentsB = OraDatabase.DbCreateDynaset( "SELECT COMMENTS FROM PACKAGE_VERSIONS WHERE PV_ID="& rsQry("pv_id_b"), cint(0))
1345
                                                                        NewTextFile.WriteLine()
-
 
1346
                                                                    End If
1300
                                                        End If
1347
 
1301
 
1348
                                                                    source_change = false
1302
                                                        pkgA = rsQry("pkg_name_a")
-
 
1303
                                                        pkgB = rsQry("pkg_name_b")
1349
 
1304
 
1350
                                                                    While CLng(a) <> CLng(c) and NOT errormsg
-
 
1351
                                                                        Call Comments(c)
1305
                                                        If pkgA <> "" then
1352
                                                                        If scFlag = TRUE Then
-
 
1353
                                                                            Call GetFixedIssues(c)
-
 
1354
                                                                        End If
1306
                                                            pkgname = pkgA
1355
                                                                        Call LastPvIdAa(c)
-
 
1356
                                                                        NewTextFile.WriteLine()
-
 
1357
                                                                    Wend
1307
                                                        Else
1358
 
-
 
1359
                                                                    If source_change = false Then
-
 
1360
                                                                        NewTextFile.WriteLine("<blockquote><b><i>No source changes to "& rsQryA("rtag_name")&". Only Rippled Builds.</i></b></blockquote><br>")
-
 
1361
                                                                        ChangeASource = true
1308
                                                            pkgname = pkgB
1362
                                                                    End If
1309
                                                        End If
1363
 
1310
 
-
 
1311
                                                        If changeType = "U" OR  changeType = "UW" Then
-
 
1312
                                                            ChangeASource = false
-
 
1313
                                                            ChangeAUpdate = false
-
 
1314
                                                            ChangeBSource = false
-
 
1315
                                                            ChangeBUpdate = false
-
 
1316
 
-
 
1317
                                                            'NewTextFile.WriteLine("<br><b><font face="&chr(34)&"arial"&chr(34)&">"&pkgname&"</font></b>")
-
 
1318
                                                            NewTextFile.Write("<a href=""javascript:;"" class=""body_scol"" onClick=""toggleSPAN('"& rowId &"');"">"& pkgname &"</a>")
-
 
1319
                                                            NewTextFile.WriteLine("<DIV class=divPkgInfo id=""spanPkgInfo"& rowId &""" name=""spanPkgInfo"" style=""display:none;"">")
-
 
1320
                                                            NewTextFile.Write(rsQryA("rtag_name")&" uses: "&rsQry("pkg_version_a")&" (")
-
 
1321
                                                            Call Release(rsQry("pv_id_a"))
-
 
1322
                                                            NewTextFile.WriteLine(")<br>")
-
 
1323
                                                            NewTextFile.Write(rsQryB("rtag_name")&" uses: "&rsQry("pkg_version_b")&" (")
-
 
1324
                                                            Call Release(rsQry("pv_id_b"))
-
 
1325
                                                            NewTextFile.WriteLine(")<br>")
-
 
1326
 
-
 
1327
                                                            a = rsQry("pv_id_a")
-
 
1328
                                                            b = rsQry("pv_id_b")
-
 
1329
                                                            c = rsQry("pv_id_a")
-
 
1330
                                                            d = rsQry("pv_id_b")
-
 
1331
 
-
 
1332
                                                            Set pvCollectionA = CreateObject("Scripting.Dictionary")
-
 
1333
                                                            Set pvCollectionB = CreateObject("Scripting.Dictionary")
-
 
1334
                                                            On Error Resume Next
-
 
1335
                                                            While CLng(a) <> CLng(b) and NOT errormsg
-
 
1336
 
-
 
1337
                                                                'NewTextFile.WriteLine("A: "&a)
-
 
1338
                                                                'NewTextFile.WriteLine("B: "&b)
-
 
1339
                                                                pvCollectionA.Add CStr(a), Empty
-
 
1340
                                                                pvCollectionB.Add CStr(b), Empty
-
 
1341
                                                                If CLng(a) > CLng(b) Then
-
 
1342
                                                                    'NewTextFile.WriteLine("TestA")
1364
                                                                    Call pkg_Version(b)
1343
                                                                    Call LastPvIdA(a)
-
 
1344
                                                                ElseIf CLng(b) > CLng(a) Then
1365
                                                                    NewTextFile.WriteLine()
1345
                                                                    'NewTextFile.WriteLine("TestB")
-
 
1346
                                                                    Call LastPvIdB(b)
-
 
1347
                                                                End If
-
 
1348
                                                            Wend
-
 
1349
 
-
 
1350
                                                            Set pvCollectionA = Nothing
-
 
1351
                                                            Set pvCollectionB = Nothing
-
 
1352
 
-
 
1353
                                                            Call pkg_Version(a)
-
 
1354
                                                            NewTextFile.Write("Common PARENT package version: "&pkgversion&" (")
-
 
1355
                                                            Call Release(a)
-
 
1356
                                                            NewTextFile.WriteLine(")<br><br>")
1366
                                                                    NewTextFile.WriteLine()
1357
                                                            NewTextFile.WriteLine()
-
 
1358
                                                            NewTextFile.WriteLine("<b>"&rsQryA("rtag_name")&"</b>")
-
 
1359
 
-
 
1360
                                                            If pkgversion <> rsQry("pkg_version_a") Then
-
 
1361
                                                                NewTextFile.WriteLine("<blockquote><b><i>Versions between "& pkgversion &" and "& rsQry("pkg_version_a")&"</i></b></blockquote>")
1367
 
1362
 
1368
                                                                ElseIf pkgversion = rsQry("pkg_version_a") Then
1363
                                                                If errormsg Then
1369
                                                                    NewTextFile.WriteLine("<blockquote><b><i>No updates to "& rsQryA("rtag_name")&"</i></b></blockquote><br>")
-
 
1370
                                                                    ChangeAUpdate = true
1364
                                                                    NewTextFile.WriteLine("Error determining root!<br>")
1371
                                                                    NewTextFile.WriteLine()
1365
                                                                    NewTextFile.WriteLine()
1372
                                                                End If
1366
                                                                End If
1373
 
1367
 
1374
                                                                NewTextFile.WriteLine("<b>"&rsQryB("rtag_name")&"</b>")
1368
                                                                source_change = false
1375
 
1369
 
1376
                                                                If pkgversion <> rsQry("pkg_version_b") Then
1370
                                                                While CLng(a) <> CLng(c) and NOT errormsg
1377
                                                                    NewTextFile.WriteLine("<blockquote><b><i>Versions between "& pkgversion &" and "& rsQry("pkg_version_b")&"</i></b></blockquote>")
-
 
1378
 
-
 
1379
                                                                    If errormsg Then
1371
                                                                    Call Comments(c)
1380
                                                                        NewTextFile.WriteLine("Error determining root!<br>")
1372
                                                                    If scFlag = TRUE Then
1381
                                                                        NewTextFile.WriteLine()
1373
                                                                        Call GetFixedIssues(c)
1382
                                                                    End If
1374
                                                                    End If
-
 
1375
                                                                    Call LastPvIdAa(c)
-
 
1376
                                                                    NewTextFile.WriteLine()
-
 
1377
                                                                Wend
1383
 
1378
 
1384
                                                                    source_change = false
1379
                                                                If source_change = false Then
-
 
1380
                                                                    NewTextFile.WriteLine("<blockquote><b><i>No source changes to "& rsQryA("rtag_name")&". Only Rippled Builds.</i></b></blockquote><br>")
-
 
1381
                                                                    ChangeASource = true
-
 
1382
                                                                End If
1385
 
1383
 
1386
                                                                    While CLng(b) <> CLng(d) and NOT errormsg
1384
                                                                Call pkg_Version(b)
1387
                                                                        Call Comments(d)
1385
                                                                NewTextFile.WriteLine()
1388
                                                                        If scFlag = TRUE Then
1386
                                                                NewTextFile.WriteLine()
-
 
1387
 
1389
                                                                            Call GetFixedIssues(d)
1388
                                                            ElseIf pkgversion = rsQry("pkg_version_a") Then
1390
                                                                        End If
1389
                                                                NewTextFile.WriteLine("<blockquote><b><i>No updates to "& rsQryA("rtag_name")&"</i></b></blockquote><br>")
1391
                                                                        Call LastPvIdBb(d)
1390
                                                                ChangeAUpdate = true
1392
                                                                        NewTextFile.WriteLine()
1391
                                                                NewTextFile.WriteLine()
1393
                                                                    Wend
1392
                                                            End If
1394
 
1393
 
1395
                                                                    If source_change = false Then
1394
                                                            NewTextFile.WriteLine("<b>"&rsQryB("rtag_name")&"</b>")
1396
                                                                        NewTextFIle.WriteLine("<blockquote><b><i>No source changes to "& rsQryB("rtag_name")&". Only Rippled Builds.</i></b></blockquote><br>")
-
 
-
 
1395
 
1397
                                                                        ChangeBSource = true
1396
                                                            If pkgversion <> rsQry("pkg_version_b") Then
1398
                                                                    End If
1397
                                                                NewTextFile.WriteLine("<blockquote><b><i>Versions between "& pkgversion &" and "& rsQry("pkg_version_b")&"</i></b></blockquote>")
1399
 
1398
 
1400
                                                                ElseIf pkgversion = rsQry("pkg_version_b") Then
1399
                                                                If errormsg Then
1401
                                                                    NewTextFile.WriteLine("<blockquote><b><i>No updates to "& rsQryB("rtag_name")&"</i></b></blockquote><br>")
-
 
1402
                                                                    ChangeBUpdate = true
1400
                                                                    NewTextFile.WriteLine("Error determining root!<br>")
1403
                                                                    NewTextFile.WriteLine()
1401
                                                                    NewTextFile.WriteLine()
1404
                                                                End If
1402
                                                                End If
1405
 
1403
 
1406
                                                                NewTextFile.WriteLine("</DIV>")
1404
                                                                source_change = false
1407
 
1405
 
1408
                                                                If ChangeASource Then
-
 
1409
                                                                    If ChangeBSource Then
-
 
1410
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": .</b class=changesnone> Ripple Builds Only.</td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &": </b class=changesnone> Ripple Builds Only.</td>  </tr></table></blockquote>")
1406
                                                                While CLng(b) <> CLng(d) and NOT errormsg
1411
                                                                    ElseIf ChangeBUpdate Then
1407
                                                                    Call Comments(d)
1412
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": </b><span class=changesnone>Ripple Builds Only.</span></td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &": </b><span class=changesnone> No Updates.</span></td>  </tr></table></blockquote>")
1408
                                                                    If scFlag = TRUE Then
1413
                                                                    ElseIf NOT ChangeBSource AND NOT ChangeBUpdate Then
-
 
1414
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0""><tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>Ripple Builds Only.</span></td>    <td width=""50%"">    <b>"& Ucase(rsQryB("rtag_name")) &":</b> <b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
1409
                                                                        Call GetFixedIssues(d)
1415
                                                                    End If
1410
                                                                    End If
-
 
1411
                                                                    Call LastPvIdBb(d)
-
 
1412
                                                                    NewTextFile.WriteLine()
-
 
1413
                                                                Wend
-
 
1414
 
-
 
1415
                                                                If source_change = false Then
-
 
1416
                                                                    NewTextFIle.WriteLine("<blockquote><b><i>No source changes to "& rsQryB("rtag_name")&". Only Rippled Builds.</i></b></blockquote><br>")
-
 
1417
                                                                    ChangeBSource = true
1416
                                                                End If
1418
                                                                End If
1417
 
1419
 
-
 
1420
                                                            ElseIf pkgversion = rsQry("pkg_version_b") Then
-
 
1421
                                                                NewTextFile.WriteLine("<blockquote><b><i>No updates to "& rsQryB("rtag_name")&"</i></b></blockquote><br>")
-
 
1422
                                                                ChangeBUpdate = true
-
 
1423
                                                                NewTextFile.WriteLine()
-
 
1424
                                                            End If
-
 
1425
 
-
 
1426
                                                            NewTextFile.WriteLine("</DIV>")
-
 
1427
 
-
 
1428
                                                            If ChangeASource Then
1418
                                                                If ChangeBSource Then
1429
                                                                If ChangeBSource Then
1419
                                                                    If NOT ChangeAUpdate Then
1430
                                                                    NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": .</b class=changesnone> Ripple Builds Only.</td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &": </b class=changesnone> Ripple Builds Only.</td>  </tr></table></blockquote>")
1420
                                                                        If NOT ChangeASource AND NOT ChangeBUpdate Then
1431
                                                                ElseIf ChangeBUpdate Then
1421
                                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": </b><b class=changesa> SOURCE CODE CHANGES</b>.</td>    <td width=""50%""> <b>"& Ucase(rsQryB("rtag_name")) &":</b> <span class=changesnone> Ripple Builds Only.</span></td>  </tr></table></blockquote>")
1432
                                                                    NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": </b><span class=changesnone>Ripple Builds Only.</span></td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &": </b><span class=changesnone> No Updates.</span></td>  </tr></table></blockquote>")
1422
                                                                        End If
1433
                                                                ElseIf NOT ChangeBSource AND NOT ChangeBUpdate Then
1423
                                                                    End If
1434
                                                                    NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0""><tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>Ripple Builds Only.</span></td>    <td width=""50%"">    <b>"& Ucase(rsQryB("rtag_name")) &":</b> <b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
1424
                                                                End If
1435
                                                                End If
-
 
1436
                                                            End If
1425
 
1437
 
1426
                                                                If NOT ChangeASource Then
1438
                                                            If ChangeBSource Then
1427
                                                                    If NOT ChangeAUpdate Then
1439
                                                                If NOT ChangeAUpdate Then
1428
                                                                        If NOT ChangeBSource AND NOT ChangeBUpdate Then
-
 
1429
                                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <b class=changesa> SOURCE CODE CHANGES.</b></td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &":</b><b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
-
 
1430
                                                                        ElseIf ChangeBUpdate Then
-
 
1431
                                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <b class=changesa> SOURCE CODE CHANGES.</b></td> <td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &":</b><span class=changesnone> No Updates.</span></td>  </tr></table></blockquote>")
-
 
1432
                                                                        End If
-
 
1433
                                                                    ElseIf ChangeAUpdate Then
-
 
1434
                                                                        If NOT ChangeBSource AND NOT ChangeBUpdate Then
1440
                                                                    If NOT ChangeASource AND NOT ChangeBUpdate Then
1435
                                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>No Updates.</span></td> <td width=""50%"">  <b></font>"& Ucase(rsQryB("rtag_name")) &":</b><b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
-
 
1436
                                                                        ElseIf ChangeBSource Then
-
 
1437
                                                                            NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>No Updates.</span></td> <td width=""50%""> </font><b>"& Ucase(rsQryB("rtag_name")) &":</b> <span class=changesnone> Ripple Builds Only.</span></td>  </tr></table></blockquote>")
1441
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &": </b><b class=changesa> SOURCE CODE CHANGES</b>.</td>    <td width=""50%""> <b>"& Ucase(rsQryB("rtag_name")) &":</b> <span class=changesnone> Ripple Builds Only.</span></td>  </tr></table></blockquote>")
1438
                                                                        End If
-
 
1439
                                                                    End If
1442
                                                                    End If
1440
                                                                End If
1443
                                                                End If
-
 
1444
                                                            End If
1441
 
1445
 
-
 
1446
                                                            If NOT ChangeASource Then
-
 
1447
                                                                If NOT ChangeAUpdate Then
-
 
1448
                                                                    If NOT ChangeBSource AND NOT ChangeBUpdate Then
1442
                                                            End If  'changeType = "U" OR  changeType = "UW"
1449
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <b class=changesa> SOURCE CODE CHANGES.</b></td><td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &":</b><b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
-
 
1450
                                                                    ElseIf ChangeBUpdate Then
-
 
1451
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <b class=changesa> SOURCE CODE CHANGES.</b></td> <td width=""50%""><b>"& Ucase(rsQryB("rtag_name")) &":</b><span class=changesnone> No Updates.</span></td>  </tr></table></blockquote>")
-
 
1452
                                                                    End If
-
 
1453
                                                                ElseIf ChangeAUpdate Then
-
 
1454
                                                                    If NOT ChangeBSource AND NOT ChangeBUpdate Then
-
 
1455
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>No Updates.</span></td> <td width=""50%"">  <b></font>"& Ucase(rsQryB("rtag_name")) &":</b><b class=changesb> SOURCE CODE CHANGES.</b></td></tr></table></blockquote>")
-
 
1456
                                                                    ElseIf ChangeBSource Then
-
 
1457
                                                                        NewTextFile.WriteLine("<blockquote><table width=""100%"" border=""0"">  <tr><td width=""50%""><b>"& Ucase(rsQryA("rtag_name")) &":</b> <span class=changesnone>No Updates.</span></td> <td width=""50%""> </font><b>"& Ucase(rsQryB("rtag_name")) &":</b> <span class=changesnone> Ripple Builds Only.</span></td>  </tr></table></blockquote>")
-
 
1458
                                                                    End If
-
 
1459
                                                                End If
-
 
1460
                                                            End If
1443
 
1461
 
1444
                                                        End If  'email
1462
                                                        End If  'changeType = "U" OR  changeType = "UW"
1445
 
1463
 
1446
                                                    End If 'NOT (GetIsDiffFilterChecked(enumDB_NUM_DIFF_RIPPLE) = "checked" AND changeType = "UR")
1464
                                                    End If  'email
1447
 
1465
 
1448
                                                    rsQry.MoveNext
1466
                                                    rsQry.MoveNext
1449
                                                WEnd
1467
                                                WEnd
1450
 
1468
 
1451
                                                rsQry.Close
1469
                                                rsQry.Close