create or replace package odwadeps is


function get_global_name
( p_ivid in number
) return varchar2
;

function get_global_type_label
( p_ivid in number
) return varchar2
;


-- this function informs on the dependency parse status of the object version
-- indicated by p_ivid. The result returned is one of the following:
-- * C  - complete, parsed and up to date
-- * I  - parsed but changed since then; potentially incomplete set of dependency data
-- * N  - not parsed at all
function parse_status
( p_ivid in number
) return varchar2
;

procedure parse4dependencies
( p_session_id in number
, p_ivid in number
);


procedure palette
( p_session_id  in number
, p_ivid        in number
, p_type_id     in number   default null
, p_classification in varchar2 default null
, p_type_of     in varchar2   default null
);

-- this procedure writes in the Nodes Tree all nodes for the supplier details that have been identified
-- within object p_ivid
procedure supplier_detail_nodes
( p_ivid       in number
, p_node_level in number
);

-- this procedure writes in the Nodes Tree all nodes for the usages that have been identified
-- for object p_ivid
procedure usages_nodes
( p_ivid       in number
, p_pac_ivid   in number
, p_node_level in number
);

-- this procedure writes in the Nodes Tree all nodes for the usages that have been identified
-- for PAC object p_ivid and all its details
procedure pac_usages_nodes
( p_ivid       in number
, p_node_level in number
);

-- this procedure writes in the Nodes Tree all nodes for the used by that have been identified
-- for object p_ivid
procedure used_by_nodes
( p_ivid       in number
, p_node_level in number
);

-- this procedure writes in the Nodes Tree all nodes for the used by that have been identified
-- for object p_ivid
procedure used_by_vrsn_nodes
( p_ivid       in number
, p_node_level in number
, p_irid       in number
);

procedure used_by_detail_nodes
( p_ivid         in number
, p_node_level   in number
, p_client_ivid  in number
);

-- this procedure writes in the Nodes Tree all nodes for the used by that have been identified
-- for object with Global Name IVID p_nm_ivid
procedure det_used_by_nodes
( p_nm_ivid    in number
, p_node_level in number
);

-- this procedure writes in the Nodes Tree nodes for all versions of p_irid for the used by that have been identified
-- for object with Global Name IVID p_nm_ivid
procedure det_used_by_vrsn_nodes
( p_nm_ivid    in number
, p_node_level in number
, p_cli_pac_ivid   in number  -- PAC who (or whose details) is using the detail p_nm_ivid
);

procedure unparsed
( p_wa_irid  in number default null
, p_cfg_ivid in number default null
, p_fol_ivid in number default null
, p_node_level in number
); 

procedure ext_deps
( p_wa_irid  in number default null
, p_cfg_ivid in number default null
, p_fol_ivid in number default null
, p_node_level in number
);


end;
/