[Home] [Help]
PACKAGE: MDSYS.SDO_CSW_PROCESS
Source
1 PACKAGE SDO_CSW_PROCESS AUTHID current_user AS
2 SPATIALCOLSEP varchar2(20) := '<>';
3 SPATIALPATHELEMSEP varchar2(20) := '>';
4 NS_SEP varchar2(20) := '<';
5 NULL_NS varchar2(20) := 'null';
6 function sortSpContentByColIndex (spatialPaths mdsys.StringList, spatialPathInfo sdo_geom_path_info,
7 userName varchar2, tableName in varchar2) return sdo_geom_path_info;
8 function genSpatialPathElemColIndex(spatialPaths mdsys.StringList, spatialPathElem sdo_geom_path_elem) return number ;
9 function genIdValue(data xmltype, tNS varchar2, tName varchar2, rtUserName varchar2) return varchar2 ;
10 function getPath(path mdsys.StringList) return varchar2;
11 function getParsedPath(path varchar2) return mdsys.StringList; -- (ns1, name1, ns2, name2....)
12 procedure genRecordTypeProcessingLogic(tNS varchar2, tName varchar2) ;
13 function isRowIdIn (r ROWID, rlist RowPointerList) return number ;
14 procedure insertRtMDUpdated(ns varchar2, name varchar2, updateTs timestamp) ;
15 procedure insertRtDataUpdated(ns varchar2, name varchar2, updatedRowList ROWPOINTERLIST, updateTs timestamp);
16 procedure insertCapabilitiesInfo(capabilitiesInfo xmltype);
17 procedure deleteCapabilitiesInfo;
18
19 function getRecordTypeId(rtnsUrl IN VARCHAR2,
20 rtName IN VARCHAR2) return number;
21 procedure insertPluginMap(rtnsUrl IN VARCHAR2, rtName IN VARCHAR2,
22 pluginpackageName varchar2);
23
24 procedure deletePluginMap(rtnsUrl IN VARCHAR2, rtName IN VARCHAR2);
25 procedure insertDomainInfo(recordTypeId NUMBER,
26 propertyName VARCHAR2,
27 parameterName VARCHAR2,
28 pValue STRINGLIST);
29 procedure deleteDomainInfo(recordTypeId NUMBER, propertyName VARCHAR2,
30 parameterName VARCHAR2);
31
32 procedure insertRecordViewMap(recordTypeNs VARCHAR2,
33 viewSrcName VARCHAR2,
34 targetTypeName VARCHAR2,
35 mapInfo XMLTYPE,
36 mapType VARCHAR2);
37 procedure deleteRecordViewMap (recordTypeNs VARCHAR2,
38 viewSrcName VARCHAR2,
39 targetTypeName VARCHAR2);
40
41 function extractID(xmldata XMLType, idPaths mdsys.StringList) return varchar2;
42 function processIdPath(srcPaths mdsys.StringList) return mdsys.StringList;
43 function parsePath(path varchar2) return mdsys.StringList;
44 function parsePathElimTypePrefix(path varchar2) return mdsys.StringList;
45 function generateAliasString(aliasList mdsys.StringList) return varchar2;
46 function getAlias(nsurl varchar2, aliasList mdsys.StringList) return varchar2;
47 function putAlias (nsurl varchar2, alias varchar2, aliasList mdsys.StringList) return mdsys.StringList;
48 function mergeSysAndUserDefinedGeomInfo(l_spatialPaths mdsys.StringList, sysInfo mdsys.sdo_geom_path_info, userInfo mdsys.sdo_geom_path_info) return mdsys.sdo_geom_path_info;
49 function generateParsedSpatialPath(spatialPaths mdsys.StringList, typeNS varchar2, typeName varchar2) return mdsys.StringList;
50 function extractSDO(xmldata XMLType, spatialPaths mdsys.StringList, userInfo mdsys.sdo_geom_path_info, srsNs varchar2, ISGML3 varchar2, typeNS varchar2, typeName varchar2, spPathsSRSNSList mdsys.StringListList) return sdo_geom_path_info;
51 function generateParsedSpatialPath(spatialPaths mdsys.StringList) return mdsys.StringListList;
52 function processPath(srcPaths mdsys.StringListList, genArrIdx number) return mdsys.StringListList;
53 function getProcessedIndex(userInfo mdsys.sdo_geom_path_info, spatialPath varchar2, typeNS varchar2, typeName varchar2) return number;
54 function isInList(l mdsys.StringList, item varchar2) return number ;
55 function genSpatialArrInfo(tableNamePrefix varchar2, pkVal varchar2,
56 l_spatialArrList mdsys.StringListList,
57 data XMLType, srsNs varchar2, spatialArrUpdMap varchar2, ISGML3 varchar2,
58 typeNS varchar2, typeName varchar2, spArrPathsSRSNSList mdsys.StringListList)
59 return mdsys.SDO_GEOM_PATH_INFO_LIST;
60 function getUpdateMap(spatialArrList mdsys.StringListList) return varchar2;
61 function expandPath(aliasedPath varchar2, nsParam varchar2) return varchar2;
62 function findNSUrl(nsAlias varchar2, nsAliasList mdsys.StringList, nsUrlList mdsys.StringList) return varchar2;
63 function getCount(pathPattern varchar2, nsParam varchar2, data xmltype) return number;
64 function enumerateArrPaths(pathPattern varchar2, nsParam varchar2, data xmltype) return mdsys.StringList;
65 function isPKColIn (r varchar2, rlist RowPointerList) return number;
66
67
68 PROCEDURE initialize_after_import;
69
70 FUNCTION prepare_for_export_user return varchar2;
71 FUNCTION prepare_for_export_user(exportSDOMetadata varchar2) return varchar2;
72
73 FUNCTION prepare_for_export_rts (rtList mdsys.StringListList) return varchar2;
74 FUNCTION prepare_for_export_rts (rtList mdsys.StringListList, exportSDOMetadata varchar2) return varchar2;
75 PROCEDURE prepare_for_export_rt_m_int(rtName in varchar2, rtNsUrl in varchar2, exportSDOMetadata varchar2) ;
76 PROCEDURE prepare_for_export_rt_int(rtName in varchar2, rtNsUrl in varchar2, exportSDOMetadata varchar2);
77
78 FUNCTION prepare_for_export_all return varchar2;
79 FUNCTION prepare_for_export_all(exportSDOMetadata varchar2) return varchar2;
80 procedure drop_export_tables;
81 procedure genUpdateStr(spatialColCount number, update_prefix varchar2, update_suffix varchar2);
82
83 procedure preProcessInsert (xmldata xmltype,
84 idPaths mdsys.StringList,
85 origidPaths mdsys.StringList,
86 extractorType varchar2,
87 spatialPaths mdsys.StringList,
88 parsedAliasSpPath mdsys.StringListList,
89 spPathsSRSNSList mdsys.StringListList,
90 spatialArrPathsList mdsys.StringListList,
91 spArrPathsSRSNSList mdsys.StringListList,
92 rtNS varchar2,
93 rtName varchar2,
94 rtId number,
95 rtUserName varchar2,
96 tableName varchar2,
97 srsNs varchar2,
98 ISGML3 varchar2,
99 spatialPathsStgSrIds mdsys.sdoNumList,
100 spatialArrPathsStgSrIds mdsys.sdoNumList,
101 p_type varchar2,
102 pkColVal OUT varchar2) ;
103
104 procedure preProcessUpdate(xmldata xmltype,
105 oldId varchar2,
106 spColUpdMap mdsys.StringList,
107 spArrColUpdMap mdsys.StringList,
108 idPaths mdsys.StringList,
109 extractorType varchar2,
110 spatialPaths mdsys.StringList,
111 parsedAliasSpPath mdsys.StringListList,
112 spPathsSRSNSList mdsys.StringListList,
113 spatialArrPathsList mdsys.StringListList,
114 spArrPathsSRSNSList mdsys.StringListList,
115 rtNS varchar2,
116 rtName varchar2,
117 rtId number,
118 rtUserName varchar2,
119 tableName varchar2,
120 srsNs varchar2,
121 ISGML3 varchar2,
122 spatialPathsStgSrIds mdsys.sdoNumList,
123 spatialArrPathsStgSrIds mdsys.sdoNumList,
124 computeSp number,
125 p_type varchar2,
126 newId OUT varchar2);
127 procedure grantMDAccessToAdminUser(userName IN varchar2) ;
128 procedure revokeMDAccessFromAdminUser(userName IN varchar2) ;
129 procedure grantMDAccessToUser(userName IN varchar2) ;
130 procedure revokeMDAccessFromUser(userName IN varchar2) ;
131 procedure grantRecordTypeToUser(rtnsUrl IN VARCHAR2, rtName IN VARCHAR2, userName IN varchar2);
132 procedure revokeRecordTypeFromUser(rtnsUrl IN VARCHAR2, rtName IN VARCHAR2, userName IN varchar2);
133 end;