eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: MDSYS.SDO_WFS_PROCESS

Source


1 PACKAGE       SDO_WFS_PROCESS AUTHID current_user AS
2         SPATIALCOLSEP varchar2(40) := '<>';
3         SPATIALPATHELEMSEP varchar2(20) := '>';
4         NS_SEP varchar2(20) := '<';
5         NULL_NS varchar2(20) := 'null';
6         KEY_SEP varchar2(20) := ';';
7         COMMIT_THRESHOLD number  := 1000;
8         LARGE_THRESHOLD number  := 0;
9 
10         -- publish from relation table content
11         procedure publishFeatureType(dataSrc IN VARCHAR2,
12                                      ftnsUrl IN VARCHAR2,
13                                      ftName IN VARCHAR2,
14                                      ftnsAlias IN VARCHAR2,
15                                      featureDesc IN XMLType,
16                                      SCHEMALOCATION IN VARCHAR2,
17                                      pkeyCol IN VARCHAR2,
18                                      columnInfo IN mdsys.StringList, pSpatialCol varchar2, featureMemberNS varchar2, featureMemberName varchar2, srsNS varchar2, srsNSAlias varchar2, mandatoryColumnInfo IN mdsys.StringList default mdsys.StringList('$ALL$'), wfs_version IN varchar2 default '1.0.0',
19                                      ftXSD IN XMLType default NULL/*,
20                                      ftVaryingNSAlias_ColName IN StringList default NULL*/,
21                                      customSrsNamePrefixes IN VARCHAR2 default NULL) ;
22         procedure publishFeatureType(dataSrc IN VARCHAR2,
23                                      ftnsUrl IN VARCHAR2,
24                                      ftName IN VARCHAR2,
25                                      ftnsAlias IN VARCHAR2,
26                                      featureDesc IN XMLType,
27                                      SCHEMALOCATION IN VARCHAR2,
28                                      pkeyCol IN VARCHAR2,
29                                      columnInfo IN mdsys.StringList, pSpatialCol varchar2, featureMemberNS varchar2, featureMemberName varchar2, srsNS varchar2, srsNSAlias varchar2, viewTableName varchar2, viewTablepkeyCol varchar2, mandatoryColumnInfo IN mdsys.StringList default mdsys.StringList('$ALL$'), wfs_version IN varchar2 default '1.0.0',
30                                      ftXSD IN XMLType default NULL/*,
31                                      ftVaryingNSAlias_ColName IN StringList default NULL*/,
32                                      customSrsNamePrefixes IN VARCHAR2 default NULL) ;
33         -- publish from a external feature xsd
34         procedure publishFeatureType(dataSrc IN VARCHAR2,
35                                      ftnsUrl IN VARCHAR2,
36                                      ftName IN VARCHAR2,
37                                      ftnsAlias IN VARCHAR2,
38                                      featureDesc IN XMLType,
39                                      SCHEMALOCATION IN VARCHAR2,
40                                      pkeyCol IN VARCHAR2,
41                                      columnInfo IN mdsys.StringList, pSpatialCol varchar2, featureMemberNS varchar2, featureMemberName varchar2, srsNS varchar2, srsNSAlias varchar2, featureCollectionNS varchar2, featureCollectionName varchar2, isGML3 varchar2, formattedkeyCols mdsys.StringList, viewTableName varchar2, viewTablepkeyCol varchar2, viewTableFmtKeyCols mdsys.StringList, mandatoryColumnInfo IN mdsys.StringList default mdsys.StringList('$ALL$'), wfs_version IN varchar2 default '1.0.0',
42                                      ftXSD IN XMLType default NULL/*,
43                                      ftVaryingNSAlias_ColName IN StringList default NULL*/,
44                                      customSrsNamePrefixes IN VARCHAR2 default NULL) ;
45         function populateVaryingAliases(ftXSD IN XMLType,
46                                         ftName IN VARCHAR2,
47                                         featureTypeId IN NUMBER,
48                                         col_name IN VARCHAR2,
49                                         tagTypeName OUT VARCHAR2) return varchar2;
50   function strip_special_chars(input_str           varchar2,
51                                chars_to_be_deleted varchar2,
52                                placeholders        varchar2 default CHR(1)) return varchar2;
53         procedure publish_featureTypes_in_schema(
54                                                 p_owner               varchar2,
55                                                 p_namespace_url       varchar2,
56                                                 p_namespace_alias     varchar2,
57                                                 p_wls_postxml_url     varchar2,
58                                                 p_tablename_pattern   varchar2 default '%',
59                                                 p_wfs_version         varchar2 default '1.1.0',
60                                                 p_write_xsd           varchar2 default 'N');
61         -- publish from a external feature xsd
62         procedure publishFeatureType(ftxsd IN XMLType, featureDesc IN XMLType, wfs_version IN varchar2 default '1.0.0');
63         procedure processInLineComplexElement(ftxsd IN XMLType,
64                                elementXml IN XMLType,
65                                elemIndex IN number,
66                                spatialCols IN OUT NOCOPY mdsys.StringList,
67                                currGmlElementsCnt IN OUT number,
68                                gmlElementsCnt IN number,
69                                parentElemPath IN varchar2,
70                                gmlAlias IN VARCHAR2);
71         procedure processComplexElement(ftxsd IN XMLType,
72                                elementType IN varchar2,
73                                spatialCols IN OUT NOCOPY mdsys.StringList,
74                                currGmlElementsCnt IN OUT number,
75                                gmlElementsCnt IN number,
76                                parentElemPath IN varchar2,
77                                gmlAlias IN VARCHAR2);
78         function isComplexObjectType(elemType IN VARCHAR2, gmlAlias IN VARCHAR2) return number ;
79         function isInList(l mdsys.StringList, item varchar2) return number ;
80         function orderInList(l mdsys.StringList, item varchar2) return number ;
81 
82         procedure  registerObject(objNs IN VARCHAR2, objName IN VARCHAR2, ftnsUrl IN VARCHAR2, currObjColPath varchar2, objNameIndex IN  NUMBER, ftId IN NUMBER, spatialColInfo mdsys.StringList, spatialColInfoIndex IN OUT NUMBER);
83         function getXMLTagType(typeOwner IN VARCHAR2, type IN VARCHAR2) RETURN VARCHAR2;
84         procedure dropFeatureType(ftnsUrl IN VARCHAR2, ftName IN VARCHAR2);
85         procedure dropFeatureTypes(ftnsUrl IN VARCHAR2);
86         procedure insertFtMDUpdated(ns varchar2, name varchar2, updateTs timestamp) ;
87         procedure insertFtDataUpdated(ns varchar2, name varchar2, updatedRowList ROWPOINTERLIST, updateTs timestamp);
88         procedure insertCapabilitiesInfo(capabilitiesInfo xmltype, wfs_version IN varchar2 default '1.0.0');
89         procedure deleteCapabilitiesInfo;
90         procedure  genCollectionProcs ;
91         procedure genCollectionProcsHelper(objNs IN VARCHAR2, objName IN VARCHAR2) ;
92         procedure populateFeatureTypeXMLInfo(xmlcoltypexsd XMLType,
93                         fTypeId number, columnName varchar2,
94                         objPathInfo mdsys.StringList) ;
95         procedure deleteFeatureTypeXMLInfo(fTypeId number);
96         function containsSDO(ns varchar2, name varchar2, ftId number) return number;
97         function containsSDOInternal(rootns varchar2, rootname varchar2,
98                                 ns varchar2, name varchar2, ftId number) return number ;
99         procedure updateObjectRef(refObjNs varchar2, refObjName varchar2, featureTypeId number , refObjSeqNo number) ;
100         procedure updateObjectRef(refObjNs varchar2, refObjName varchar2,
101                 refObjSeqNo number, nsUrl varchar2,
102                 containerObjNs varchar2, containerObjName varchar2, containerObjNameIndex number, featureTypeId number) ;
103         function sortSpContentByColIndex (spatialPaths mdsys.StringList, spatialPathInfo sdo_geom_path_info,
104                 userName varchar2, tableName in varchar2) return sdo_geom_path_info;
105         function genSpatialPathElemColIndex(spatialPaths mdsys.StringList, spatialPathElem sdo_geom_path_elem) return number ;
106         function genIdValue(data xmltype, idPaths mdsys.StringList, tNS varchar2, tName varchar2, ftUserName varchar2) return varchar2 ;
107         function getPath(path mdsys.StringList) return varchar2;
108         function getParsedPath(path varchar2) return mdsys.StringList; -- (ns1, name1, ns2, name2....)
109         procedure genRecordTypeProcessingLogic(tNS varchar2, tName varchar2) ;
110         function extractSDO(xmldata XMLType, spatialPaths mdsys.StringList, srsNs varchar2, ISGML3 varchar2, spPathsSRSNSList mdsys.StringListList) return sdo_geom_path_info ;
111         function parsePath(path varchar2) return mdsys.StringList ;
112         function generateParsedSpatialPath(spatialPaths mdsys.StringList) return mdsys.StringListList ;
113         function processPath(srcPaths mdsys.StringListList,  genArrIdx number) return mdsys.StringListList ;
114         function generateAliasString(aliasList mdsys.StringList) return varchar2 ;
115         function getAlias(nsurl varchar2, aliasList mdsys.StringList) return varchar2 ;
116         function putAlias (nsurl varchar2, alias varchar2, aliasList mdsys.StringList) return mdsys.StringList;
117         function isRowIdIn (r ROWID, rlist RowPointerList) return number ;
118         function isPKColIn (r varchar2, rlist RowPointerList) return number;
119         function extractID(xmldata XMLType, idPaths mdsys.StringList) return varchar2 ;
120         function processIdPath(srcPaths mdsys.StringList) return mdsys.StringList ;
121 
122         function getFeatureTypeId(ftnsUrl IN VARCHAR2,
123                                   ftName IN VARCHAR2) return number;
124         procedure grantMDAccessToAdminUser(userName IN varchar2) ;
125         procedure grantMDAccessToUser(userName IN varchar2);
126         procedure revokeMDAccessFromAdminUser(userName IN varchar2) ;
127         procedure revokeMDAccessFromUser(userName IN varchar2);
128         procedure grantFeatureTypeToUser(ftnsUrl IN VARCHAR2,
129                                   ftName IN VARCHAR2,
130                                   userName IN varchar2);
131         procedure revokeFeatureTypeFromUser(ftnsUrl IN VARCHAR2,
132                                   ftName IN VARCHAR2,
133                                   userName IN varchar2);
134         procedure registerMTableView(ftNSUrl varchar2,
135                      ftName varchar2,
136                      viewTableList mdsys.StringList,
137                      viewTablePkeyColList mdsys.StringList,
138                      tablePKeyColList mdsys.StringList);
139         procedure registerMTableView(ftNSUrl varchar2,
140                      ftName varchar2,
141                      viewTableList mdsys.StringList,
142                      viewTablePkeyColList mdsys.StringList,
143                      formattedViewTableColList mdsys.StringListList,
144                      tablePKeyColList mdsys.StringList);
145         procedure unRegisterMTableView(ftNSUrl varchar2,
146                        ftName varchar2);
147         function notInArray(p varchar2, pList mdsys.RowPointerList) return number;
148 
149         function genSpatialArrInfo(tableNamePrefix varchar2, pkVal varchar2,
150                                    l_spatialArrList mdsys.StringListList,
151                                    data XMLType,  srsNs varchar2, spatialArrUpdMap varchar2, ISGML3 varchar2, spArrPathsSRSNSList mdsys.StringListList)
152         return mdsys.SDO_GEOM_PATH_INFO_LIST;
153         function  getUpdateMap(spatialArrList mdsys.StringListList) return varchar2;
154         function expandPath(aliasedPath varchar2, nsParam varchar2) return varchar2;
155         function findNSUrl(nsAlias varchar2, nsAliasList mdsys.StringList, nsUrlList mdsys.StringList) return varchar2;
156         function getCount(pathPattern varchar2, nsParam varchar2, data xmltype) return number;
157         function enumerateArrPaths(pathPattern varchar2, nsParam varchar2, data xmltype) return mdsys.StringList;
158         procedure genTriggers(tNS varchar2, tName varchar2);
159         function isListMember(featureTypeName varchar2, namespaceUrl varchar2, ftIdList mdsys.StringListList) return number;
160         PROCEDURE initialize_after_import;
161 
162         FUNCTION prepare_for_export_user return varchar2;
163         FUNCTION prepare_for_export_user(exportSDOMetadata varchar2) return varchar2;
164 
165         FUNCTION prepare_for_export_fts (ftList mdsys.StringListList) return varchar2;
166         FUNCTION prepare_for_export_fts (ftList mdsys.StringListList,  exportSDOMetadata varchar2) return varchar2;
167         PROCEDURE prepare_for_export_ft_m_int(ftName in varchar2, ftNsUrl in varchar2, exportSDOMetadata varchar2) ;
168         PROCEDURE prepare_for_export_ft_int(ftName in varchar2, ftNsUrl in varchar2, exportSDOMetadata varchar2);
169 
170         FUNCTION prepare_for_export_all return varchar2;
171         FUNCTION prepare_for_export_all(exportSDOMetadata varchar2) return varchar2;
172         procedure drop_export_tables;
173         procedure genUpdateStr(spatialColCount number, update_prefix varchar2, update_suffix varchar2);
174         procedure preProcessInsert (xmldata xmltype,
175                                     idPaths mdsys.StringList,
176                                     spatialPaths mdsys.StringList,
177                                     parsedAliasSpPath mdsys.StringListList,
178                                     spPathsSRSNSList mdsys.StringListList,
179                                     spatialArrPathsList mdsys.StringListList,
180                                     spArrPathsSRSNSList mdsys.StringListList,
181                                     ftNS varchar2,
182                                     ftName varchar2,
183                                     ftId number,
184                                     ftUserName varchar2,
185                                     tableName varchar2,
186                                     srsNs varchar2,
187                                     ISGML3 varchar2,
188                                     spatialPathsStgSrIds mdsys.sdoNumList, -- spatialPaths storage srid
189                                     spatialArrPathsStgSrIds mdsys.sdoNumList, pkColVal OUT VARCHAR2); -- spatial Arr paths storage srids
190         procedure preProcessUpdate(xmldata xmltype,
191                                    oldId varchar2,
192                                    spColUpdMap mdsys.StringList,
193                                    spArrColUpdMap mdsys.StringList,
194                                    idPaths mdsys.StringList,
195                                    spatialPaths mdsys.StringList,
196                                    parsedAliasSpPath mdsys.StringListList,
197                                    spPathsSRSNSList mdsys.StringListList,
198                                    spatialArrPathsList mdsys.StringListList,
199                                    spArrPathsSRSNSList mdsys.StringListList,
200                                    ftNS varchar2,
201                                    ftName varchar2,
202                                    ftId number,
203                                    ftUserName varchar2,
204                                    tableName varchar2,
205                                    srsNs varchar2,
206                                    ISGML3 varchar2,
207                                    spatialPathsStgSrIds mdsys.sdoNumList,  -- spatialPaths storage srid
208                                    spatialArrPathsStgSrIds mdsys.sdoNumList,   -- spatial Arr paths storage srids
209                                    computeSp number, newId OUT varchar2);
210 
211 END SDO_WFS_PROCESS;