var g_conCount=1;var g_fkCount=1;var g_ukCount=1;function ob_TableToggleType(F){var E=html_CascadeUpTill(F,"TR");var D=E.getElementsByTagName("input");var B=D[1];var C=D[2];var A=D[3];html_VisibleElement(A);switch(F.value){case"NUMBER":html_VisibleElement(C);if(C.value>38){C.value=""}html_VisibleElement(B);if((B.value.length>0)&&(C.value.length==0)){B.value=""}break;case"CLOB":case"BLOB":case"DATE":case"TIMESTAMP":html_HiddenElement(C);html_HiddenElement(B);break;case"VARCHAR2":html_VisibleElement(C);if((C.value>4000)||(C.value.length==0)){C.value="4000"}html_HiddenElement(B);break;case"NVARCHAR2":html_VisibleElement(C);if((C.value>2000)||(C.value.length==0)){C.value="2000"}html_HiddenElement(B);break;case"CHAR":html_VisibleElement(C);html_HiddenElement(B);if((C.value>100)||(C.value.length==0)){C.value="100"}break;case"BINARY_FLOAT":html_HiddenElement(C);html_HiddenElement(B);break;case"BINARY_DOUBLE":html_HiddenElement(C);html_HiddenElement(B);break;default:html_HiddenElement(C);html_HiddenElement(B);html_HiddenElement(A);break}return }function addTableRow2(D,A,B){var I=html_GetElement(A);var E=new Array();for(i=0;i<B;i++){var K=I.rows[I.rows.length-1];var C=K.cloneNode(true);if(document.all){myNewRow=I.insertRow(I.rows.length);oReplace=myNewRow.replaceNode(C)}else{I.appendChild(C)}E[E.length]=C;var H=C.getElementsByTagName("select");for(var G=0;G<H.length;G++){H[G].selectedIndex=0;H[G].disabled=""}var F=C.getElementsByTagName("input");for(var J=0;J<F.length;J++){if(F[J].type=="text"){F[J].value="";F[J].disabled=""}}}return E}function ob_TableAddColumn(F,C,B){var D=addTableRow2(F,C,B);for(var A=0;A<D.length;A++){var E=D[A].getElementsByTagName("input");html_HiddenElement(E[1]);html_HiddenElement(E[2])}}function ob_TablePrevInit(){var C=html_GetElement("htmldbNewTable");var A=html_GetElement("htmldbNewTable").rows;for(var B=1;B<A.length;B++){var D=A[B].getElementsByTagName("SELECT")[0];ob_TableToggleType(D)}}function ob_createTableSeq(E){var C="";if(E=="NEW_SEQUENCE"){html_HideItemRow("P604_EXISTING_SEQUENCE");html_HideItemRow("P604_PK2");html_ShowItemRow("P604_PK1");html_ShowItemRow("P604_NEW_SEQUENCE");html_ShowItemRow("P604_PK1_NAME");C=html_GetElement("P604_PK1").value}else{if(E=="EXISTING_SEQUENCE"){html_ShowItemRow("P604_EXISTING_SEQUENCE");html_HideItemRow("P604_NEW_SEQUENCE");html_HideItemRow("P604_PK2");html_ShowItemRow("P604_PK1");html_ShowItemRow("P604_PK1_NAME");C=html_GetElement("P604_PK1").value}else{if(E=="NOT_GENERATED"){html_HideItemRow("P604_EXISTING_SEQUENCE");html_HideItemRow("P604_NEW_SEQUENCE");html_ShowItemRow("P604_PK1");html_ShowItemRow("P604_PK2");html_ShowItemRow("P604_PK1_NAME");C=html_GetElement("P604_PK1").value}else{if(E=="NONE"){html_HideItemRow("P604_EXISTING_SEQUENCE");html_HideItemRow("P604_NEW_SEQUENCE");html_HideItemRow("P604_PK1_NAME");html_HideItemRow("P604_PK1");html_HideItemRow("P604_PK2")}}}}var B=new htmldb_Get(null,4500,"INTERNAL_APPLICATION_PROCESS=1504518033640244",0);B.add("P604_EXISTING_SEQUENCE",html_GetElement("P604_EXISTING_SEQUENCE").value);B.add("P604_NEW_SEQUENCE",html_GetElement("P604_NEW_SEQUENCE").value);B.add("P604_PK2",html_GetElement("P604_PK2").value);var D=html_GetElement("P604_PK1").value;B.add("P604_PK1",C);B.add("P604_PK1_NAME",html_GetElement("P604_PK1_NAME").value);var F=html_RadioValue("P604_PK_TYPE");B.add("P604_PK_TYPE",html_RadioValue("P604_PK_TYPE"));var A=B.get();B=null}function ob_createTableGetFK(){var B=new htmldb_Get(null,4500,"INTERNAL_APPLICATION_PROCESS=1504518033640244",0);B.add("P145_FK_TABLE",html_GetElement("P145_FK_TABLE").value);var A=B.get();B=null}function ob_createTableFKCols(){var A=html_GetElement("P145_FK_REF_TABLE").value;var G=html_GetElement("P145_SCHEMA").value;var F=html_GetElement("P145_FK_REF_COLUMN");if(A!=""){var C=new htmldb_Get(null,4500,"INTERNAL_APPLICATION_PROCESS=29884608907915599",0);C.add("P145_FK_REF_TABLE",A);C.add("OB_SCHEMA",G);var B=C.get();if(B=="NONE"){html_HideItemRow(F);return }F.options.length=0;var D=B.split(";");html_GetElement("P145_FK_REF_TABLE").value=D[0];var E="";for(i=1;i<D.length;i++){if(D[i]!=""){E=new Option(D[i],D[i],false,false);F.options[F.options.length]=E}}html_ShowItemRow(F);C=null;Shuttle2=new dhtml_ShuttleObject("P145_FK_REF_COLUMN","P145_FK_REF_COLUMN_SEL")}else{html_HideItemRow(F)}}function ob_getOpts(A){A=html_GetElement(A).options;var C="";for(var B=0;B<A.length;B++){if(B>0){C=C+","}C=C+A[B].value}return C}function ob_addFk(){var H=html_GetElement("P145_FK_REF_TABLE").value;var I=ob_getOpts("P145_FK_REF_COLUMN_SEL");var B=ob_getOpts("P145_FK_THIS_COLUMN_SEL");var D=html_GetElement("P145_FK_NAME").value;var A=html_RadioValue("P145_FK_ACTION");var G=html_GetElement("htmldbNewTable");var C=new htmldb_Get(null,4500,"INTERNAL_APPLICATION_PROCESS=172369000165936003",0);C.add("P145_FK_REF_TABLE",H);C.add("P145_TO_COLS",I);C.add("P145_FROM_COLS",B);C.add("P145_FK_NAME",D);C.add("P145_FK_ACTION",A);var E=C.get();if(E.indexOf("HTMLDB:ERROR")>0){html_GetElement("htmldbMessageHolder").innerHTML=E}else{html_GetElement("htmldbNewTable").parentNode.innerHTML=E;html_GetElement("P145_FK_REF_TABLE").value="";html_GetElement("P145_FK_REF_COLUMN_SEL").options.length=0;g_fkCount+=1;html_GetElement("P145_FK_NAME").value=html_GetElement("P145_TABLE_NAME").value+"_fk"+g_fkCount;html_HideItemRow("P145_FK_REF_COLUMN");html_HideItemRow("P145_FK_REF_COLUMN_SEL");html_RemoveAllChildren("htmldbMessageHolder");Shuttle.reset()}var F=""}function ob_rmFkRow(C){var B=new htmldb_Get(null,4500,"INTERNAL_APPLICATION_PROCESS=172867829404455433",0);B.add("P145_FK_SEQ",C);var A=B.get();x=html_GetElement("fkTab_"+C);x.parentNode.removeChild(x)}function ob_addCons(){var F=html_GetElement("P149_NAME").value;var D=ob_getOpts("P149_SEL_COLS");var E=html_GetElement("P149_CHECK").value;var A=html_RadioValue("P149_CONST_TYPE");var C=new htmldb_Get(null,4500,"INTERNAL_APPLICATION_PROCESS=176127519858657209",0);C.add("P149_NAME",F);C.add("P149_SEL_COLS",D);C.add("P149_CHECK",E);C.add("P149_CONST_TYPE",A);var B=C.get();if(B.indexOf("HTMLDB:ERROR")>0){html_GetElement("htmldbMessageHolder").innerHTML=B}else{html_GetElement("htmldbNewTable").parentNode.innerHTML=B;html_GetElement("P149_CHECK").value="";html_GetElement("P149_SEL_COLS").options.length=0;if(A=="C"){g_conCount+=1;html_GetElement("P149_NAME").value=html_GetElement("P149_TABLE_NAME").value+"_ck"+g_conCount}else{g_ukCount+=1;html_GetElement("P149_NAME").value=html_GetElement("P149_TABLE_NAME").value+"_uk"+g_ukCount}html_GetElement("htmldbMessageHolder").innerHTML="";Shuttle.reset()}}function ob_rmConsRow(C){var B=new htmldb_Get(null,4500,"INTERNAL_APPLICATION_PROCESS=176138206577719675",0);B.add("P149_CONS_SEQ",C);var A=B.get();x=html_GetElement("consTab_"+C);x.parentNode.removeChild(x)}var gLastFilteredKey;function ob_DelayTableSearch(A){gLastFilteredKey=new Date();setTimeout(delayedFilter,250)}function delayedFilter(){if(((new Date()-gLastFilteredKey))>250){ob_createTableFKCols()}else{setTimeout(delayedFilter,250)}}function p149_RadioTog(){var A=html_RadioValue("P149_CONST_TYPE");if(A=="C"){html_ShowItemRow("P149_CHECK");html_HideItemRow("P149_AVAIL_COLS");html_HideItemRow("P149_SEL_COLS");html_GetElement("P149_NAME").value=html_GetElement("P149_TABLE_NAME").value+"_ck"+g_conCount}else{html_HideItemRow("P149_CHECK");html_ShowItemRow("P149_AVAIL_COLS");html_ShowItemRow("P149_SEL_COLS");html_GetElement("P149_NAME").value=html_GetElement("P149_TABLE_NAME").value+"_uk"+g_ukCount}}function ob_ToggleNN(B){var A=B.nextSibling;if(A!=null&&A.nodeType==3){A=A.nextSibling}if(B.checked==true){B.value="Y";A.value="Y"}else{B.value="N";A.value="N"}}function ob_table_getColOrder(){var E=html_GetElement("P602_COL_ORDER");var C=html_CascadeUpTill(html_GetElement("htmldbNewTable"),"TABLE");var D=C.getElementsByTagName("input");var B=0;var A="";for(B=0;B<D.length;B++){if(D[B].id=="colname"){A=A+D[B].value+";"}}E.value=A;return true}function ob_delayOrder(){setTimeout(ob_table_getColOrder,500)}function ob_IeRowFixStart(E){if(document.all){var C=html_CascadeUpTill(E,"TR");var D=html_Return_Form_Items(C);var A=false;for(var B=0;B<D.length;B++){if(D[B].type=="checkbox"&&D[B].checked){A=true}}return A}}function ob_IeRowFixFinish(D,B){if(document.all){var C=html_Return_Form_Items(D);for(var A=0;A<C.length;A++){if(C[A].type=="checkbox"){C[A].checked=B}}}}function ob_RowUp(C){var B=ob_IeRowFixStart(C);var A=html_RowUp(C);ob_delayOrder();ob_IeRowFixFinish(A,B)}function ob_RowDown(C){var B=ob_IeRowFixStart(C);var A=html_RowDown(C);ob_delayOrder();ob_IeRowFixFinish(A,B)};