var g_object = null;
var cX =  0;
var cY = 0;
var link1=false;
var link2=false;
var qb_state=false;
//var sliding = false;
var qb_init=false;
var qb_startTime;
var qb_resultsOnClick=true;
var qb_colDrag = false;
var qb_begDrag = '';
var qb_zIndex = 100;
//var gQbFind = '';
var gSetFocus = '';

function qb_cascadeUpUntil(n,tag){
 var l_find = true;
 var htmlEl = n;
      if(htmlEl){
       while(l_find){
         htmlEl = htmlEl.parentNode;        	
       if ( ! htmlEl ) 
           return;         
         if ( htmlEl && htmlEl.nodeName == tag  ) {
           l_find = false;
         }
      } 
    }
  return htmlEl;
}  

function qb_cascadeUpMove(n,tag){
 var l_find = true;
 var htmlEl = n;
      if(htmlEl){
       while(l_find){
       if ( ! htmlEl ) { return; }
               if ( htmlEl.getAttributeNode && htmlEl.getAttributeNode("htmldb:close") && htmlEl.getAttributeNode("htmldb:close").nodeValue == '0' ) {
                 return null;
              } else if (( tag=='ANY' || htmlEl.nodeName == tag )  && htmlEl.movable == '1' ) {
                  l_find = false;
              } else {
                 htmlEl = htmlEl.parentNode;        	
              }
      } 
    }
  return htmlEl;
}  

function qb_cascadeUpClose(n,tag){
 var l_find = true;
 var htmlEl = n;
      if(htmlEl){
       while(l_find){        	
        htmlEl = htmlEl.parentNode;
       if ( ! htmlEl ) 
           return;
         if ( ( tag=='ANY' || htmlEl.nodeName == tag ) 
              && htmlEl.closable == '1' ) {
           l_find = false;
         } 
      } 
    }
  return htmlEl;
}  

function qb_delArrElement(arr,ele){
 var i;
 var delId= typeof(ele) =='object' ? ele.id : ele;
 var ret;
   for(i=0;i<arr.length;i++){
    if ( ( typeof(arr[i]) == 'object' && arr[i].id == delId)
          || ( typeof(arr[i]) == 'string' &&  arr[i] == delId ) ) {
       ret = arr.splice(i,1);
     }
   }
   return arr;
}

var gFirstResize = true;
function qb_initPage () {
    document.onmousedown = qb_pickIt;
    document.onmousemove = qb_dragIt;
    document.onmouseup   = qb_dropIt;
    document.onkeypress  = qb_keyHandler;
    document.onkeydown   = qb_keyHandler;
    window.onresize  = qb_Resize;
    if(gFirstResize){
		qb_Resize();
	    gFirstResize = !gFirstResize;
	}
    //init_qbRender();
}

function qb_keyHandler(evt) {
  var e = evt ? evt : window.event;
  if (document.all) {  
    if (event.keyCode == 27) {
      qb_clearLink();
      return true;
    }
    if (event.keyCode == 10 && event.ctrlKey == true){
      qb_genSql();  
      html_TabClick(html_GetElement('result_tab'),'queryResults_table');
      qb_getQueryResults();
      return true;
    }
    if (event.srcElement.id == 'QUERYTEXT') {
        if (event.ctrlKey == true && (event.keyCode == 65 || event.keyCode == 67)) {
          null;
        } else {
          return false;
        }
    }

    return event.keyCode;
  }else{
    if (e.keyCode == 27) {
      qb_clearLink();
      return true;
    }
    if (e.keyCode == 13 && e.ctrlKey == true){
      qb_genSql();
      html_TabClick(html_GetElement('result_tab'),'queryResults_table');
      qb_getQueryResults();
      return true;
    }
    if (e.explicitOriginalTarget.id == 'QUERYTEXT'){
        if (e.ctrlKey == true && (e.charCode == 97 || e.charCode == 99)) {
          return e.keyCode;
        } else {
          return false;
        }
    }
      
    return  e.keyCode;
  }    
}

function qb_pickIt(evt) { 
   var evt = (evt) ? evt :((window.event) ? event : null);
   var target = evt.target ? evt.target : evt.srcElement;

    if (gSetFocus != '') {
       qbSetFocus();
       return false;
    }

  if (target.id == 'QUERYTEXT' || target.id == 'P1002_QUERY_DESC' || target.id == 'P1002_QUERY_NAME' ) {
    return true;
  }

   if ( target.nodeName == 'scrollbar' ||
        target.nodeName == 'input' ) {
       return false;
    }

    if ( target.id == 'h_slide') {
       qb_hPosition(evt);
       return false;
    }

    var mousex = 0;
    var mousey = 0;
    if (evt.pageX || evt.pageY) { 
      mousex = evt.pageX - 3; 
      mousey = evt.pageY - 12;  
    } else if (evt.clientX || evt.clientY) { 
      mousex = evt.clientX + document.body.scrollLeft - 3;
      mousey = evt.clientY + document.body.scrollTop - 12;
    }

    if (qb_colDrag) {
        var myobject = html_GetElement("dragimg");
        myobject.style.display="block";
        myobject.style.left = mousex;
        myobject.style.top = mousey;
		cX = mousex - myobject.offsetLeft;
		cY = mousey - myobject.offsetTop;
		qb_zIndex = qb_zIndex +1;
        myobject.style.zIndex = qb_zIndex;
        g_object = myobject;
        return false;
    }

    var sUp = html_GetElement('qbTableHolder').scrollTop;
    var sLeft = html_GetElement('qbTableHolder').scrollLeft;
    mousex = mousex + sLeft; 
    mousey = mousey + sUp; 
 
	var myobject=qb_cascadeUpMove(target,"ANY");
	if (myobject) { 
    	g_object = myobject;
    	qb_zIndex = qb_zIndex + 1;
		myobject.style.zIndex = qb_zIndex;
		cX = mousex - myobject.offsetLeft;
		cY = mousey - myobject.offsetTop;
		return false;
	}
	else {
		myobject = null;
		if (target.tagName == 'INPUT') {
		  return true;
		}
		return false;
	}
}

function qb_dragIt(evt) {
    evt = (evt) ? evt : ((window.event) ? event : null);
    var target = evt.target ? evt.target : evt.srcElement;

    if ( hFubar ) {
       qb_hNewPos(evt);
       return false;
    }

    var mousex = 0;
    var mousey = 0;
    if (evt.pageX || evt.pageY) { 
      mousex = evt.pageX - 3; 
      mousey = evt.pageY - 12;  
    } else if (evt.clientX || evt.clientY) { 
      mousex = evt.clientX + document.body.scrollLeft - 3;
      mousey = evt.clientY + document.body.scrollTop - 12;
    }

	if (g_object) {
	  if (qb_colDrag) {
	    if ( mousex - cX > 0 )  {
		   g_object.style.left = mousex - cX + 'px';
	    } else {
	        g_object.style.left = '0px';
	    }
	    
	    if ( mousey - cY > 0 )  {
		    g_object.style.top = mousey - cY + 'px';
	    } else {
	        g_object.style.top = '0px';
	    }
		qb_redraw();
		return false;
      } else {
        var sUp = html_GetElement('qbTableHolder').scrollTop;
        var sLeft = html_GetElement('qbTableHolder').scrollLeft;
        mousex = mousex + sLeft; 
        mousey = mousey + sUp; 
	    if ( mousex - cX > 0 )  {
		   g_object.style.left = mousex - cX + 'px';
	    } else {
	        g_object.style.left = '0px';
	    }
	    
	    if ( mousey - cY > 0 )  {
		    g_object.style.top = mousey - cY + 'px';
	    } else {
	        g_object.style.top = '0px';
	    }
		qb_redraw();
		return false;
      }
	 }
	if (target.nodeName == 'INPUT' || target.id == 'QUERYTEXT') {
	  qb_redraw();
      return;
    } else {
      qb_redraw();
      return false;
    }
}


function qb_dropIt(evt) {
	
	evt = (evt) ? evt : ((window.event) ? event : null);
    var target = evt.target ? evt.target : evt.srcElement;

    if ( hFubar ) {
       qb_hAction(evt); 
       return false;
    }
    
    if (qb_colDrag) {
      var mousex = 0;
      var mousey = 0;
      var sUp = html_GetElement('qbTableHolder').scrollTop;
      var sLeft = html_GetElement('qbTableHolder').scrollLeft;
      if (evt.pageX || evt.pageY) { 
        mousex = evt.pageX + sLeft; 
        mousey = evt.pageY + sUp;  
      } else if (evt.clientX || evt.clientY) { 
        mousex = evt.clientX + document.body.scrollLeft + sLeft;
        mousey = evt.clientY + document.body.scrollTop + sUp;
      }
        var obj = qb_getItem(mousex,mousey);
        if (obj) {
          qb_dragStop(obj.getAttributeNode("htmldb:col").nodeValue);
        } else {
          var img = html_GetElement("dragimg");
          img.style.display="none";
          qb_colDrag = false;
          qb_begDrag = '';
        }          
    }
    
	if (g_object) {	
		g_object = null;
	}
    return false;
}

var gTableCount = new Array();
 gTableCount[0] = new Array();

function qb_addTable(id) {
    if ( gTableCount[id] && gTableCount[id].length > 0 ) {
       var x = parseInt(gTableCount[id][0]) + 1;
       gTableCount[id][0] = x;
       getTable(id,x);
    } else {
       gTableCount[id] = new Array();
       gTableCount[id][0] = 0;
       getTable(id,0);
    }
}


function q(pId){
  qb_addTable(pId)
}

function qb_tblCount(id) {
    if ( gTableCount[id] && gTableCount[id].length > 0) {
        return parseInt(gTableCount[id][0])+1;
    } else {
        return 0;
    }
}    

function qb_chkCount(id,pCount) {
    if ( gTableCount[id] && gTableCount[id].length > 0) {
       var x = parseInt(gTableCount[id][0]);
         if ( x < pCount ) 
           gTableCount[id][0] = pCount;
    } else {
       gTableCount[id] = new Array();
       gTableCount[id][0] = pCount;
    }
}

function getTable(id,pCount,top,left) {
    qb_initPage();
    id   = typeof (id) == 'object' ? id.id : id;    
    var x = id;
    qb_chkCount(id,pCount);
    var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=1916013849479713',0);
    get.add('P1002_ID',id);
    get.add('P1002_COUNT', pCount);
    var x = get.get('FULL');
    get = null;
    var l_newDiv = document.createElement('DIV');
    l_newDiv.style.display='none';
    l_newDiv.style.position='absolute';
    l_newDiv.id = id+'_'+pCount;
    var main = html_GetElement('qbTableHolder');
    main.insertBefore(l_newDiv, main.firstChild);
    l_newDiv.innerHTML= x;
    l_newDiv.movable  = '1';
    l_newDiv.closable = '1';
    if ( top && left ) {
          l_newDiv.style.left=left;
          l_newDiv.style.top=top;  
    } else {
        var children = main.getElementsByTagName('TABLE');
        var y = '';
        var lastEl = false;
        for(i=0;i<=children.length-1;i++){
          var x = 0;
          if (children[i].id != l_newDiv.id+'_data' && children[i].id != '' ) 
            x = findPosX(children[i]);
          if (x > y) {
            lastEl = children[i];             
            y = x;
          }
        }
        if (lastEl) {         
          var lastX = findPosX(lastEl);
          var lastY = findPosY(lastEl);
					l_newDiv.style.display='block';
          l_newDiv.style.left = lastX + (lastEl.offsetWidth + 25);
          l_newDiv.style.top = lastY;
        } else {
				  l_newDiv.style.display='block';
          l_newDiv.style.left = 28;  
          l_newDiv.style.top = 14;
        }
    }
		$x_Show(l_newDiv)
    qb_genSql();
}

function qb_toggleTable(pId) {
  //var t = html_CascadeUpTill(pId,"TABLE").rows[1];
  var foo = html_CascadeUpTill(pId,"DIV");
  var tname = foo.getAttribute("htmldb:id")
  var tcnt = foo.getAttribute("htmldb:cnt")
  var foo2 = tname+'_'+tcnt+'_tog';
  var t = html_GetElement(foo2);
  var l_Set = 'none';
  if(html_CheckImageSrc(pId,'min')){
    html_SwitchImageSrc(pId,'min',htmldb_Img_Dir + 'qb/vertical_max.png');
    html_HideElement(t)
  }else{
    html_SwitchImageSrc(pId,'max',htmldb_Img_Dir + 'qb/vertical_min.png');
    html_ShowElement(t)
    l_Set = '';
  }
  qb_redraw();
  toolTip_disable();
}

function qb_redraw(){
    if ( qb_links && qb_links.length > 0 ) {
    	for (j=0;j<qb_links.length;j++) {
    	   qb_links[j].redim();
    	}
    }
}

function qb_clearLink(){
        if ( link1 != false && link1.id  )
           if(html_GetElement(link1.id)) {
            html_GetElement(link1.id+'_jbox').style.backgroundColor="";
            html_GetElement(link1.id).style.backgroundColor="";
           }
        if (link2 != false && link2.id )
         if(html_GetElement(link2.id)) {
           html_GetElement(link2.id+'_jbox').style.backgroundColor="";
           html_GetElement(link2.id).style.backgroundColor="";
         }
        link1=false;
        link2=false;
        qb_validateLinks();
}


function qb_postQUERY(sql) {
    qb_initPage();
    sql = escape(sql);
    var get = htmldb_getData(null,4500,'INTERNAL_APPLICATION_PROCESS=1504518033640244',0);
      get.add('P1002_QUERY',cwsqlid);
    var x = get.get('FULL');
      get = null;
}

function qb_escapeSQL(sql){
  var ret="";
  var c;
  for(var i=0;i<sql.length;i++){
    c = sql.charAt(i);
    if (c == "," )
       ret = ret + "^c"; 
    else if ( c == "+" )
       ret = ret + "^p"; 
    else if ( c == ":" )
       ret = ret + "^x"; 
  else
       ret = ret + c; 
  }
  return ret;
}

function qb_removeTable(id) {
  if (id.nodeName && id.nodeName == "IMG" ) {
     var d= qb_cascadeUpClose(id,"DIV");
  } else {
     var d= html_GetElement(id);
  }
 var i;
   qb_clearLink();
   qb_rmTableConditions(d.id);       
   d.parentNode.removeChild(d); 
   qb_validateLinks();
   qb_validateLinks();
   // hide tool tip
   toolTip_disable();
   // call in qb_rmTableConditions doesn't get it done
   qb_genSql();	
   // this is to clean up the array holding table counts
   var c = 0;	
   // get the table object id
   var tabId = d.id.substring(0,d.id.indexOf('_'));
   // get the array of rendered tables
   var tableDiv = html_GetElement("qbTableHolder"); 
   // wlk the tables and see if any still exist
    for(i=0;i<tableDiv.childNodes.length;i++) {
      var lid = tableDiv.childNodes[i].id.substring(0,tableDiv.childNodes[i].id.indexOf('_'));  
      if (lid == tabId) {
        c++;
      }
     }
     // if none exist count is 0 so reset the array for that object id
     if (c==0) {
       gTableCount[tabId] = new Array;
     }  
  }


function qb_linkTable(o){
     o = o.nodeName == "TD" ? o : qb_cascadeUpUntil(o,"TD");
     var orig = o;
    
     if (link1 == false ) {
         link1 = o;
         orig.style.backgroundColor='#DDDDDD';
         html_GetElement(link1.id+'_jbox').style.backgroundColor="#DDDDDD";
         return;
      } else if ( link2 == false ) {
         link2 = o;
         if (link1 == link2) {
             qb_clearLink();
             qb_validateLinks();
             return;
         }
         var sFrom = link1.id.split('.');
         var sTo = link2.id.split('.');
         if (sFrom[0] == sTo[0]) {
             link2=false;
             return;
         }
         orig.style.backgroundColor='#DDDDDD';
         html_GetElement(link2.id+'_jbox').style.backgroundColor="#DDDDDD";
         var l = new qb_link(link1,link2);
         qb_genSql();
         link1=false;
         link2=false;
         return;
      }    
}


var qb_Open_Menu = '';

function qb_tablePopup(obj,evt,id){
    var x = html_GetElement(id+"_thold");
    var alias = qb_getAlias(x);
    var holder = html_GetElement(alias+"_tmenu");
      var tname = x.getAttribute("htmldb:name");
      var schema = html_GetElement("P1002_SCHEMA").value; 
      var get = new htmldb_Get(holder,4500,'TABLE',59);
      get.add('P59_TNAME',tname);
      get.add('P59_SCHEMA', schema);
      get.get('PPR','<htmldb:BOX_BODY>','</htmldb:BOX_BODY>');
      get = null;
      holder.closable=1;
      qb_zIndex = qb_zIndex + 1;
      holder.style.zIndex = qb_zIndex;
      holder.tableId=id;
      var evt = (evt) ? evt : ((window.event) ? event : null);
      var target_x = evt.pageX ? evt.pageX : evt.clientX ;
      var target_y = evt.pageY ? evt.pageY : evt.clientY ;
       dhtml_SingeMenuOpen(obj,holder,'Set',target_x,target_y);
    qb_redraw();
    return;
}


function qb_getQueryResults(){
    var holder = html_GetElement("queryResults"); 
    var query = html_GetElement("P1002_QUERY").value;
    if (query) {
      var get = new htmldb_Get(null,4500,'RP',23);
        get.add('P1002_QUERY', query);
         get.clear('RP');
         var results = get.get(null,'<htmldb:BOX_BODY>','</htmldb:BOX_BODY>');
        get = null;
      holder.innerHTML = results;
      init_htmlPPRReport();
    } else {
        // this item is set to a system message showing the correct message
        holder.innerHTML = html_GetElement('P1002_RESULTS_ERROR_MSG').value;
    }
    qb_resultsOnClick=false;
}

function qb_popup(id){
  var t = qb_cascadeUpUntil(html_GetElement(id),'TABLE');
      qb_zIndex = qb_zIndex + 1000;
      html_disableBase(qb_zIndex,"htmldbInvisDiv");
      t.closable='1';
      qb_zIndex = qb_zIndex+1;
      t.style.zIndex = qb_zIndex;
      t.style.display = "block";
      qb_Centerme(t);
	   html_GetElement('qbTableHolder').style.overflow = 'hidden';
	   html_GetElement('qbBottomHolder').style.overflow = 'hidden';
	   if(id == 'saveDialog'){html_GetElement('P1002_QUERY_NAME').focus()}
}

function qb_hidePopup(){
  var t = html_GetElement("R2310326687229087");
      t.style.display = "none";
      html_GetElement('qbTableHolder').className = 'd1';/* ff BUG https://bugzilla.mozilla.org/show_bug.cgi?id=223239 */
      html_GetElement('qbBottomHolder').className = 'd2';
	   html_GetElement('qbTableHolder').style.overflow = 'auto';
	   html_GetElement('qbBottomHolder').style.overflow = 'auto';
	   }

function qb_close(id){
  html_enableBase();
  var t = qb_cascadeUpClose(html_GetElement(id),'ANY');
  html_HideElement(t)
  toolTip_disable();
  html_GetElement("htmldbMessageHolder").innerHTML = '';
  html_GetElement('qbTableHolder').className = 'd1'; /* ff BUG https://bugzilla.mozilla.org/show_bug.cgi?id=223239 */
  html_GetElement('qbBottomHolder').className = 'd2';
  html_GetElement('qbTableHolder').style.overflow = 'auto';
  html_GetElement('qbBottomHolder').style.overflow = 'auto';
  }




function qb_Centerme(id){
     html_Centerme(id);
}

function qb_makeJoin(obj) {
    var x = obj.value;
    if ( x == 0 ) return;
    var zz = x.split('|');
    var newCount = qb_tblCount(zz[0]);
    getTable(zz[0],newCount);    
    
    var fdiv = html_CascadeUpTill(obj,'SPAN');  
    //var fdiv = html_CascadeUpTill(fdiv1,'DIV');  
    var fdiv = html_GetElement(fdiv.tableId+"_"+"thold");
    var ftab = qb_getAlias(fdiv);
    var fcol = zz[2];

    var tdiv = html_GetElement(zz[0]+'_'+newCount+'_thold');
    var ttab = qb_getAlias(tdiv);
    var tcol = zz[1];

    var l1 = html_GetElement(ftab+'.'+fcol); 
    var l2 = html_GetElement(ttab+'.'+tcol); 

    qb_linkTable(l1); 
    qb_linkTable(l2); 
    qb_genSql();
    var menu = html_GetElement(ftab +"_tmenu");
        html_HideElement(menu);
    var breaker = '';
}

function qb_CheckAllColumns(pThis){
    var start= new Date();
    qb_suspendGen= true;
    var fdiv1 = html_CascadeUpTill(pThis,'SPAN');  
    var fdiv = html_GetElement(fdiv1.tableId +"_thold");
    var l_Inputs = html_Return_Form_Items(fdiv,'checkbox');
    var table = html_GetElement("conditions");
    for (var i=0;i<l_Inputs.length&&i!=-1;i++){
      if ( l_Inputs[i].id != "P59_CHECK_ALL_0" ) {
         // check for the 60 limit
         if ( qb_checkCols + 1 > 60 ) {
           l_Inputs[i].checked = false;
           alert(l_maxCols);
           i=-2; // set i to -2 to stop the loop
         } else if ( pThis.checked ) {
            if ( qb_checkCols + 1 < 21 ) {
               l_Inputs[i].checked = true;
               qb_checkColumn(l_Inputs[i])
            } else {
               i=-2; // set i to -2 to stop the loop
            }
          } else {
               l_Inputs[i].checked = false;
              qb_rmCondition( html_GetElement(l_Inputs[i].value+"_condition"));
          }
     } // end check for P59_
    }
    qb_suspendGen= false;
	qb_genSql();
    return;
}

function qb_newQuery() {
    var holder = html_GetElement("queryResults"); 
        holder.innerHTML="";
    var tableDiv = html_GetElement("qbTableHolder");   
    var foo = tableDiv.childNodes.length;
    for(i=0;i<=foo;i++){
      var id = tableDiv.childNodes[0].id;
      if (id) {
        qb_removeTable(id); 
      }
     }
     gTableCount = new Array;
     gTableCount[0] = new Array();
  
     html_GetElement("P1002_QUERY_NAME").value = '';
     html_GetElement("P1002_QUERY_DESC").value = '';
     html_GetElement("P1002_QUERY_ID").value = '';
     html_GetElement("P1002_OWNER").value = '';

     var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=1504518033640244',0);
      get.add('P1002_QUERY_TYPE','P');
      get.add('P1002_QUERY_NAME', '');
      get.add('P1002_QUERY_DESC','');
      get.add('P1002_QUERY_ID','');
      get.add('P1002_OWNER','');
     var x = get.get('FULL');
      get = null;
   
 }

function qb_returnSQL(){
   var ret = html_GetElement("P1002_RETURN_INTO").value;
   opener.html_GetElement(ret).value =  html_GetElement("P1002_QUERY").value;
   window.close();
}

function qb_checkQuery(){
   if ( qb_resultsOnClick ) {
     qb_getQueryResults();
   }

}

function qb_dragStart(pCol) {
    qb_colDrag = true;
    qb_begDrag = pCol;
}

function qb_dragStop(pCol) {
  if (qb_begDrag != '' && pCol != '') {
    var sFrom = qb_begDrag.split('.');
    var sTo = pCol.split('.');
    if (sFrom[0] != sTo[0]) {
      var foo = new qb_link(qb_begDrag,pCol,"E");
      qb_validateLinks();
      qb_redraw();
      qb_genSql();
    }
  }

  var img = html_GetElement("dragimg");
  img.style.display="none";

  qb_colDrag = false;
  qb_begDrag = '';
}    


function qb_getItem(x,y){
 var element = document.getElementsByTagName("TD");
 var iselement = false;
 var ele = '';
 for (i=0; i<element.length; i++) {
    var nId = element[i].innerHTML;
    var nEle = element[i];
    if (nEle.getAttributeNode && nEle.getAttributeNode("htmldb:dragable")) {
      var left = fPosX(element[i]); 
      var top = fPosY(element[i]);
      var right = left + nEle.clientWidth;
      var bottom = top + nEle.clientHeight;
      if (left < x && right > x && top < y && bottom  > y) {
        return element[i];
      }
    }
  }
    return null;
}

function offsetX()
{
    var obj = html_GetElement("qbTableHolder");
	var curleft = 0;
	if (obj.offsetParent)
	{
		while (obj.offsetParent)
		{
			curleft += obj.offsetLeft
			obj = obj.offsetParent;
		}
	}
	else if (obj.x)
		curleft += obj.x;
	return curleft;
}

function offsetY()
{
    var obj = html_GetElement("qbTableHolder");
	var curtop = 0;
	if (obj.offsetParent)
	{
		while (obj.offsetParent)
		{
			curtop += obj.offsetTop
			obj = obj.offsetParent;
		}
	}
	else if (obj.y)
		curtop += obj.y;
	return curtop;
}

function fPosX(obj)
{
	var curleft = 0;
	if (obj.offsetParent)
	{
		while (obj.offsetParent)
		{
			curleft += obj.offsetLeft
			obj = obj.offsetParent;
		}
	}
	else if (obj.x)
		curleft += obj.x;
	return curleft;
}

function fPosY(obj)
{
	var curtop = 0;
	if (obj.offsetParent)
	{
		while (obj.offsetParent)
		{
			curtop += obj.offsetTop
			obj = obj.offsetParent;
            if (obj.className == 'qbData') {
                curtop -= obj.offsetParent.firstChild.scrollTop;
            }

		}
	}
	else if (obj.y)
		curtop += obj.y;
	return curtop;
}


function qb_getSavedSQL(pReset){
  var own = "0";
  var find = "";
  var rows = 15;
  var holder = html_GetElement("SavedSQLHolder");
  if (html_GetElement("P38_OWNER")){own = html_SelectValue("P38_OWNER")}
  if(pReset != true){
	  if (html_GetElement("P38_FIND") && html_GetElement("P38_FIND").value != "undefined" ) {
		  find = html_GetElement("P38_FIND").value;
	  }
  }
  if(pReset){find = '';}
  if (html_GetElement("P38_ROWS")){rows = html_SelectValue("P38_ROWS")}
  
   if(pReset){
     lURL = 'f?p=4500:38:'+html_GetElement('pInstance').value+'::NO:RP:P38_OWNER,P38_FIND,P38_ROWS:'+own+','+find+','+rows;
     var get = new htmldb_Get(null,4500,null,38,null,'f',lURL.substring(2));
   }else{
     var get = new htmldb_Get(null,4500,null,38);
   }
	get.add('P38_OWNER',own);
	get.add('P38_FIND',find);
	get.add('P38_ROWS',rows);
  var results = get.get(null,'<htmldb:BOX_BODY>','</htmldb:BOX_BODY>');
  holder.innerHTML = results;
  init_htmlPPRReport('R159940232617099966');
  results = null;
  get = null; 
}

function IsNumeric(sText) {
   var ValidChars = "0123456789";
   var IsNumber=true;
   var Char;
   for (i = 0; i < sText.length && IsNumber == true; i++) 
      { 
      Char = sText.charAt(i); 
      if (ValidChars.indexOf(Char) == -1) 
         {
         IsNumber = false;
         }
      }
   return IsNumber;
}
    
function qbValSo(obj) {
    var val = IsNumeric(obj.value);
    if (! val) {
     var pMessage = '<div class="htmldbNotification"><ul><li>';
     pMessage = pMessage+l_invSo;
     pMessage = pMessage+'</li></ul></div>';
     html_GetElement("htmldbMessageHolder").innerHTML = pMessage;
     gSetFocus = obj.id;
     return false;
    } else {
     gSetFocus = '';
     html_GetElement("htmldbMessageHolder").innerHTML = '';
     qb_genSql();
    }
}

function qbSetFocus() {
    if (gSetFocus != '') {
     html_GetElement(gSetFocus).focus();
    }
}


            var rowStyle      = new Array(10);
            var rowActive     = new Array(10);
            var rowStyleHover = new Array(10);
            



            function checkAll(masterCheckbox) {
                if (masterCheckbox.checked) {
                    if (document.wwv_flow.f01.checked==false) {
                      document.wwv_flow.f01.checked=true;
                      highlight_row(document.wwv_flow.f01,1);
                    }
                } else {
                    rowsNotChecked=0;
                    if (document.wwv_flow.f01.checked!=true) {
                       rowsNotChecked=rowsNotChecked+1;
                    }
                    if (rowsNotChecked==0) {
                        if (document.wwv_flow.f01.checked==true) {
                          document.wwv_flow.f01.checked=false;
                          highlight_row(document.wwv_flow.f01,1);
                        }
                    }
                }
            }

            function highlight_row(checkBoxElemement,currentRowNum) {
                if(checkBoxElemement.checked==true) {
                    for( var i = 0; i < checkBoxElemement.parentNode.parentNode.childNodes.length; i++ ) {
                        if (checkBoxElemement.parentNode.parentNode.childNodes[i].tagName=='TD') {
                            if(rowActive=='Y') {
                                rowStyle[currentRowNum] = rowStyleHover[currentRowNum];
                            } else {
                                rowStyle[currentRowNum] = checkBoxElemement.parentNode.parentNode.childNodes[i].style.backgroundColor;
                            }
                            checkBoxElemement.parentNode.parentNode.childNodes[i].style.backgroundColor = '#CCCCCC';
                        }
                    }
                    rowStyleHover[currentRowNum] =  '#CCCCCC';
                } else {
                      for( var i = 0; i < checkBoxElemement.parentNode.parentNode.childNodes.length; i++ ) {
                          if (checkBoxElemement.parentNode.parentNode.childNodes[i].tagName=='TD') {
                              checkBoxElemement.parentNode.parentNode.childNodes[i].style.backgroundColor =  rowStyle[currentRowNum];
                              rowStyleHover[currentRowNum] =  rowStyle[currentRowNum];
                              document.wwv_flow.x02.checked=false;
                          }
                      }
                }
            }