--$Header: /cvsroot/ebxmlrr/ebxmlrr-spec/misc/2.5/sql/storedProcedures.sql,v 1.2 2003/06/04 18:18:52 farrukh_najmi Exp $
--Define Stored procedures that map to RIM class methods

CREATE PROCEDURE RegistryObject_auditTrail(registryObjectId) {
--Must return an collection of UUIDs for AuditableEvents related to the RegistryObject.
--Collection must be in ascending order by timestamp
}

CREATE PROCEDURE RegistryObject_externalLinks(registryObjectId) {
--Must return a collection of UUIDs for ExternalLinks annotating this RegistryObject.
}

CREATE PROCEDURE RegistryObject_registryPackages(registryObjectId) {
--Must return a collection of UUIDs for RegistryPackages that this RegistryObject belongs to.
}



--Procedures on RegistryPackage
CREATE PROCEDURE RegistryPackage_memberObjects(registryPackageId) {
--Must return a collection of UUIDs for RegistryObjects that are memebers of this RegistryPackage.
}

--Procedures on ExternalLink
CREATE PROCEDURE ExternalLink_linkedObjects(externalLinkId) {
--Must return a collection of UUIDs for RegistryObject linked by this ExternalLink to external content
}

--Procedures on ClassificationNode
CREATE PROCEDURE ClassificationNode_classifiedObjects(classificationNodeId) {
--Must return a collection of UUIDs for RegistryObjects classified by this ClassificationNode
}