-- Package for importing dependency data

create or replace package jr_dependency_imp is

-- import to sdd_dependencies and sdd_global_names
-- the src is the supplier if isKnownSupplier. Otherwise the src is the client.
procedure imp
(
   isKnownSupplier    number
  ,dependencyTypeIrid number
  ,srcIrid            number
  ,srcIvid            number
  ,srcParentIvid      number
  ,srcTypeId          number
  ,globalName_name    varchar2
  ,globalName_domain  number
  ,globalName_typeId  number
  ,stat               varchar2  
);

-- import to sdd_global_names
-- select from sdd_global_names if it exists
-- insert into sdd_global_names if it doesn't exist
procedure imp_global_name
(
   p_irid out number
  ,p_ivid out number
  ,p_name in varchar2
  ,p_domain_irid in number
  ,p_type_id in number  
);

-- import to sdd_dependencies
-- select and update status from sdd_global_names if it exists
-- insert into sdd_dependencies if it doesn't exist
procedure imp_dependency
(
   dependencyTypeIrid number
  ,supplierIrid number
  ,supplierIvid number
  ,supplierParentIvid number
  ,supplierTypeId number
  ,clientIrid number
  ,clientIvid number
  ,clientParentIvid number
  ,clientTypeId number  
  ,stat varchar2  
);

end jr_dependency_imp;
/