| Line 723... |
Line 723... |
| 723 |
|
723 |
|
| 724 |
OraDatabase.Parameters.Add "PV_ID", pvidInRelease, ORAPARM_INPUT, ORATYPE_NUMBER
|
724 |
OraDatabase.Parameters.Add "PV_ID", pvidInRelease, ORAPARM_INPUT, ORATYPE_NUMBER
|
| 725 |
OraDatabase.Parameters.Add "RTAG_ID", pkgInfoHash.Item ("rtag_id"), ORAPARM_INPUT, ORATYPE_NUMBER
|
725 |
OraDatabase.Parameters.Add "RTAG_ID", pkgInfoHash.Item ("rtag_id"), ORAPARM_INPUT, ORATYPE_NUMBER
|
| 726 |
|
726 |
|
| 727 |
Query_String = _
|
727 |
Query_String = _
|
| 728 |
" SELECT NVL(rc.s3sync, 'N') as s3sync, NVL(rt.s3sync, 'N') AS s3syncenabled, nvl2(s3.file_path, 'Y', 'N') AS s3synccontent" &_
|
728 |
"SELECT NVL(RC.S3SYNC, 'N') AS S3SYNC, NVL(RT.S3SYNC, 'N') AS S3SYNCENABLED, NVL2(S3.PV_ID, 'Y', 'N') AS S3SYNCCONTENT " &_
|
| 729 |
" FROM release_content rc, release_tags rt, (" &_
|
729 |
" FROM RELEASE_CONTENT RC, RELEASE_TAGS RT, ( " &_
|
| - |
|
730 |
" SELECT RCP.* " &_
|
| - |
|
731 |
" FROM RELEASE_COMPONENTS RCP, RELEASE_CONTENT RC " &_
|
| 730 |
" SELECT rcp.* FROM release_components rcp, release_content rc WHERE rc.rtag_id = :RTAG_ID" &_
|
732 |
" WHERE RC.RTAG_ID = :RTAG_ID " &_
|
| 731 |
" AND rc.pv_id = rcp.pv_id" &_
|
733 |
" AND RC.PV_ID = RCP.PV_ID " &_
|
| 732 |
" AND rcp.file_name IS NULL" &_
|
734 |
" AND RC.PV_ID = :PV_ID " &_
|
| 733 |
" AND rcp.file_path LIKE 'pkg/S3TRANSFER'" &_
|
735 |
" AND RCP.FILE_NAME = 's3Transfer.json' " &_
|
| - |
|
736 |
" AND RCP.FILE_PATH IS NULL " &_
|
| 734 |
" ) s3" &_
|
737 |
") S3 " &_
|
| 735 |
" WHERE rc.rtag_id = rt.rtag_id" &_
|
738 |
" WHERE RC.RTAG_ID = rt.RTAG_ID " &_
|
| 736 |
" AND rc.pv_id = :PV_ID" &_
|
739 |
" AND RC.PV_ID = :PV_ID " &_
|
| 737 |
" AND rt.rtag_id = :RTAG_ID" &_
|
740 |
" AND rt.RTAG_ID = :RTAG_ID " &_
|
| 738 |
" AND s3.pv_id (+) = rc.pv_id"
|
741 |
" AND S3.PV_ID (+) = RC.PV_ID "
|
| 739 |
|
742 |
|
| 740 |
Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
|
743 |
Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
|
| 741 |
If rsTemp.RecordCount > 0 Then
|
744 |
If rsTemp.RecordCount > 0 Then
|
| 742 |
pkgInfoHash.Item ("s3Sync") = (rsTemp.Fields("s3Sync"))
|
745 |
pkgInfoHash.Item ("s3Sync") = (rsTemp.Fields("s3Sync"))
|
| 743 |
pkgInfoHash.Item ("s3SyncEnabled") = (rsTemp.Fields("s3SyncEnabled"))
|
746 |
pkgInfoHash.Item ("s3SyncEnabled") = (rsTemp.Fields("s3SyncEnabled"))
|