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 STRINGLIST

Line 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',

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,

Line 20: ftVaryingNSAlias_ColName IN StringList default NULL*/,

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,

Line 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',

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

Line 31: ftVaryingNSAlias_ColName IN StringList default NULL*/,

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,

Line 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',

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,

Line 43: ftVaryingNSAlias_ColName IN StringList default NULL*/,

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,

Line 66: spatialCols IN OUT NOCOPY mdsys.StringList,

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);

Line 73: spatialCols IN OUT NOCOPY mdsys.StringList,

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);

Line 79: function isInList(l mdsys.StringList, item varchar2) return 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;

Line 80: function orderInList(l mdsys.StringList, item varchar2) return 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);

Line 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);

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) ;

Line 94: objPathInfo mdsys.StringList) ;

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 ;

Line 103: function sortSpContentByColIndex (spatialPaths mdsys.StringList, spatialPathInfo sdo_geom_path_info,

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;

Line 105: function genSpatialPathElemColIndex(spatialPaths mdsys.StringList, spatialPathElem sdo_geom_path_elem) return number ;

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) ;

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 107: function getPath(path mdsys.StringList) return varchar2;

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 ;

Line 108: function getParsedPath(path varchar2) return mdsys.StringList; -- (ns1, name1, ns2, name2....)

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 ;

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 111: function parsePath(path varchar2) return mdsys.StringList ;

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 ;

Line 112: function generateParsedSpatialPath(spatialPaths mdsys.StringList) return mdsys.StringListList ;

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;

Line 113: function processPath(srcPaths mdsys.StringListList, genArrIdx number) return mdsys.StringListList ;

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 ;

Line 114: function generateAliasString(aliasList mdsys.StringList) return 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;

Line 115: function getAlias(nsurl varchar2, aliasList mdsys.StringList) return varchar2 ;

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 ;

Line 116: function putAlias (nsurl varchar2, alias varchar2, aliasList mdsys.StringList) 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 ;

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 120: function processIdPath(srcPaths mdsys.StringList) return mdsys.StringList ;

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) ;

Line 136: viewTableList mdsys.StringList,

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,

Line 137: viewTablePkeyColList mdsys.StringList,

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,

Line 138: tablePKeyColList mdsys.StringList);

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,

Line 141: 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,

Line 142: 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);

Line 143: formattedViewTableColList mdsys.StringListList,

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;

Line 144: tablePKeyColList mdsys.StringList);

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:

Line 150: l_spatialArrList mdsys.StringListList,

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;

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 153: function getUpdateMap(spatialArrList mdsys.StringListList) return varchar2;

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;

Line 155: function findNSUrl(nsAlias varchar2, nsAliasList mdsys.StringList, nsUrlList mdsys.StringList) return varchar2;

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;

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 159: function isListMember(featureTypeName varchar2, namespaceUrl varchar2, ftIdList mdsys.StringListList) return number;

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;

Line 165: FUNCTION prepare_for_export_fts (ftList mdsys.StringListList) return varchar2;

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:

Line 166: FUNCTION prepare_for_export_fts (ftList mdsys.StringListList, exportSDOMetadata varchar2) return varchar2;

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;

Line 175: idPaths mdsys.StringList,

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,

Line 176: spatialPaths mdsys.StringList,

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,

Line 177: parsedAliasSpPath mdsys.StringListList,

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,

Line 178: spPathsSRSNSList mdsys.StringListList,

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,

Line 179: spatialArrPathsList mdsys.StringListList,

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,

Line 180: spArrPathsSRSNSList mdsys.StringListList,

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,

Line 192: spColUpdMap mdsys.StringList,

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,

Line 193: spArrColUpdMap mdsys.StringList,

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,

Line 194: idPaths mdsys.StringList,

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,

Line 195: spatialPaths mdsys.StringList,

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,

Line 196: parsedAliasSpPath mdsys.StringListList,

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,

Line 197: spPathsSRSNSList mdsys.StringListList,

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,

Line 198: spatialArrPathsList mdsys.StringListList,

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,

Line 199: spArrPathsSRSNSList mdsys.StringListList,

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,