--
-- $Header: whdev/2.0/owb/oracle/wh/runtime/sql/pls/metadata/wb_location_helper.pls /main/3 2011/04/22 00:51:35 yuhhuang Exp $
--
-- wb_location_helper.pls
--
-- Copyright (c) 2010, 2011, Oracle and/or its affiliates. 
-- All rights reserved. 
--
--   NAME
--     wb_location_helper.pls - <one-line expansion of the name>
--
--   DESCRIPTION
--     <short description of component this file declares/defines>
--
--   RETURNS
--
--   NOTES
--     <other useful comments, qualifications, etc.>
--
--   MODIFIED   (MM/DD/YY)
--   swzhou      08/08/10 - Creation
--


create or replace package wb_location_helper is  -- check whether you have license to do location_helper
  -- return 1 if have license
  function checkLicense return NUMBER;
  
  -- fix runtime location: <loc_name> <host> <port> <service> <version> <schema> <user> <password>
  -- return 1 if succeed.
  function fixRTLocation
  (
    location_in in varchar2,
    host_in in varchar2,
    port_in in varchar2,
    service_in in varchar2,
    version_in in varchar2,
    schema_in in varchar2,
    user_in in varchar2,
    password_in in varchar2
  )
  return NUMBER;
  
  -- fix logical location: <loc_name> <host> <port> <service> <version> <schema> <user>
  -- return 1 if succeed.
  function fixDTLocation
  (
    location_in in varchar2,
    host_in in varchar2,
    port_in in varchar2,
    service_in in varchar2,
    version_in in varchar2,
    schema_in in varchar2,
    user_in in varchar2
  )
  return NUMBER;
  
  -- get current control center home
  function getOWBCCHome return VARCHAR2;
  
  -- set control center home to specific value.
  -- return 1 if succeed.
  function setOWBCCHome (newLoc in varchar2) return NUMBER;
  
  -- fix runtime service node: <node_id> <host> <port> <service> <server_side_home>
  -- return 1 if succeed.
  function fixRTServiceNode 
  (
    node_id_in in number,
    host_in in varchar2,
    port_in in varchar2,
    service_in in varchar2,
    server_side_home_in in varchar2
  ) 
  return NUMBER;
  
end;
/