CREATE OR REPLACE PACKAGE DEP_UTIL AS

  PROCEDURE queryNameInfo(objID IN NUMBER, objUOID IN OUT VARCHAR2,
   objName IN OUT VARCHAR2, objLogicalName IN OUT VARCHAR2, 
   objClassName IN OUT VARCHAR2, objStrongTypeName IN OUT VARCHAR2, 
   objIconType IN OUT VARCHAR2, noDataFound OUT BOOLEAN);

  FUNCTION getGroupID(objID IN NUMBER, class_name IN VARCHAR2) RETURN NUMBER;

  FUNCTION getParentID(objID IN NUMBER, class_name IN VARCHAR2) RETURN NUMBER;

  FUNCTION getFolderID(objID IN NUMBER, class_name IN VARCHAR2) RETURN NUMBER;

  FUNCTION getParentIDForDF(objID IN NUMBER, class_name IN VARCHAR2) RETURN NUMBER;
  
  FUNCTION getFolderIDForDF(objID IN NUMBER, class_name IN VARCHAR2) RETURN NUMBER;
  
  FUNCTION getOutofSync(objID1 IN NUMBER, objID2 IN NUMBER) RETURN VARCHAR2;

  PROCEDURE queryNameInfoFromCategory(objID IN NUMBER, objUOID IN OUT VARCHAR2,
   objName IN OUT VARCHAR2, objLogicalName IN OUT VARCHAR2, 
   objClassName IN OUT VARCHAR2, objIconType IN OUT VARCHAR2);
   
  PROCEDURE analyzeMCMTables;
END DEP_UTIL;
/