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.

MDSYS.SDO_WFS_PROCESS dependencies on XMLTYPE

Line 15: featureDesc IN XMLType,

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/*,

Line 19: ftXSD IN XMLType default NULL/*,

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,

Line 26: featureDesc IN XMLType,

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/*,

Line 30: ftXSD IN XMLType default NULL/*,

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,

Line 38: featureDesc IN XMLType,

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/*,

Line 42: ftXSD IN XMLType default NULL/*,

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,

Line 45: function populateVaryingAliases(ftXSD IN XMLType,

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;

Line 62: procedure publishFeatureType(ftxsd IN XMLType, featureDesc IN XMLType, wfs_version IN varchar2 default '1.0.0');

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,

Line 63: procedure processInLineComplexElement(ftxsd IN XMLType,

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,

Line 64: elementXml IN XMLType,

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,

Line 71: procedure processComplexElement(ftxsd IN XMLType,

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,

Line 88: procedure insertCapabilitiesInfo(capabilitiesInfo xmltype, wfs_version IN varchar2 default '1.0.0');

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,

Line 92: procedure populateFeatureTypeXMLInfo(xmlcoltypexsd XMLType,

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;

Line 106: function genIdValue(data xmltype, idPaths mdsys.StringList, tNS varchar2, tName varchar2, ftUserName varchar2) return 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 ;

Line 110: function extractSDO(xmldata XMLType, spatialPaths mdsys.StringList, srsNs varchar2, ISGML3 varchar2, spPathsSRSNSList mdsys.StringListList) return sdo_geom_path_info ;

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 ;

Line 119: function extractID(xmldata XMLType, idPaths 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;

Line 151: data XMLType, srsNs varchar2, spatialArrUpdMap varchar2, ISGML3 varchar2, spArrPathsSRSNSList mdsys.StringListList)

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;

Line 156: function getCount(pathPattern varchar2, nsParam varchar2, data xmltype) return number;

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;

Line 157: function enumerateArrPaths(pathPattern varchar2, nsParam varchar2, data xmltype) return mdsys.StringList;

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:

Line 174: procedure preProcessInsert (xmldata xmltype,

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,

Line 190: procedure preProcessUpdate(xmldata xmltype,

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,