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.
TYPE BODY: MDSYS.SDO_GEO_ADDR

Source


1 type body sdo_geo_addr as
2   CONSTRUCTOR FUNCTION SDO_GEO_ADDR
3     RETURN SELF AS RESULT
4   AS
5   BEGIN
6     return ;
7   END ;
8   CONSTRUCTOR FUNCTION SDO_GEO_ADDR(
9     country VARCHAR2, lines SDO_KEYWORDARRAY, matchmode VARCHAR2)
10     RETURN SELF AS RESULT
11   AS
12   BEGIN
13     SELF.id := 1 ;
14     SELF.country := country ;
15     SELF.addresslines := lines ;
16     SELF.matchmode := matchmode ;
17     return ;
18   END ;
19   CONSTRUCTOR FUNCTION SDO_GEO_ADDR(
20     country VARCHAR2, matchmode VARCHAR2, street VARCHAR2, settlement VARCHAR2,
21     municipality VARCHAR2, region VARCHAR2, postalcode VARCHAR2)
22     RETURN SELF AS RESULT
23   AS
24   BEGIN
25     SELF.id := 1;
26     SELF.country := country ;
27     SELF.matchmode := matchmode ;
28     SELF.streetname := street ;
29     SELF.settlement := settlement ;
30     SELF.municipality := municipality ;
31     SELF.region := region ;
32     SELF.postalcode := postalcode ;
33     RETURN ;
34   END;
35 
36   CONSTRUCTOR FUNCTION SDO_GEO_ADDR( id                  NUMBER,
37      addresslines        SDO_KEYWORDARRAY, placeName           VARCHAR2,
38      streetName          VARCHAR2, intersectStreet     VARCHAR2,
39      secUnit             VARCHAR2, settlement          VARCHAR2,
40      municipality        VARCHAR2, region              VARCHAR2,
41      country             VARCHAR2, postalCode          VARCHAR2,
42      postalAddonCode     VARCHAR2, fullPostalCode      VARCHAR2,
43      poBox               VARCHAR2, houseNumber         VARCHAR2,
44      baseName            VARCHAR2, streetType          VARCHAR2,
45      streetTypeBefore    VARCHAR2,
46      streetTypeAttached  VARCHAR2, streetPrefix        VARCHAR2,
47      streetSuffix        VARCHAR2, side                VARCHAR2,
48      percent             NUMBER, edgeId              NUMBER,
49      errorMessage        VARCHAR2, matchcode           NUMBER,
50      matchmode VARCHAR2, longitude  NUMBER, latitude   NUMBER)
51   RETURN SELF AS RESULT AS
52   BEGIN
53    self.id := id;
54    self.addresslines := addresslines;
55    self.placeName := placeName;
56    self.streetName := streetName;
57    self.intersectStreet := intersectStreet;
58    self.secUnit := secUnit;
59    self.settlement := settlement;
60    self.municipality := municipality;
61    self.region := region;
62    self.country := country;
63    self.postalCode := postalCode;
64    self.postalAddonCode := postalAddonCode;
65    self.fullPostalCode := fullPostalCode;
66    self.poBox := poBox;
67    self.houseNumber := houseNumber;
68    self.baseName := baseName;
69    self.streetType := streetType;
70    self.streetTypeBefore := streetTypeBefore;
71    self.streetTypeAttached := streetTypeAttached;
72    self.streetPrefix := streetPrefix;
73    self.streetSuffix := streetSuffix;
74    self.side := side;
75    self.percent := percent;
76    self.edgeId := edgeId;
77    self.errorMessage := errorMessage;
78    self.matchcode := matchcode;
79    self.matchmode := matchmode;
80    self.longitude := longitude;
81    self.latitude := latitude;
82 
83    RETURN;
84   END;
85 
86   CONSTRUCTOR FUNCTION SDO_GEO_ADDR( id                  NUMBER,
87      addresslines        SDO_KEYWORDARRAY, placeName           VARCHAR2,
88      streetName          VARCHAR2, intersectStreet     VARCHAR2,
89      secUnit             VARCHAR2, settlement          VARCHAR2,
90      municipality        VARCHAR2, region              VARCHAR2,
91      country             VARCHAR2, postalCode          VARCHAR2,
92      postalAddonCode     VARCHAR2, fullPostalCode      VARCHAR2,
93      poBox               VARCHAR2, houseNumber         VARCHAR2,
94      baseName            VARCHAR2, streetType          VARCHAR2,
95      streetTypeBefore    VARCHAR2,
96      streetTypeAttached  VARCHAR2, streetPrefix        VARCHAR2,
97      streetSuffix        VARCHAR2, side                VARCHAR2,
98      percent             NUMBER, edgeId              NUMBER,
99      errorMessage        VARCHAR2, matchcode           NUMBER,
100      matchmode VARCHAR2, longitude  NUMBER, latitude   NUMBER,
101      matchVector VARCHAR2)
102   RETURN SELF AS RESULT AS
103   BEGIN
104    self.id := id;
105    self.addresslines := addresslines;
106    self.placeName := placeName;
107    self.streetName := streetName;
108    self.intersectStreet := intersectStreet;
109    self.secUnit := secUnit;
110    self.settlement := settlement;
111    self.municipality := municipality;
112    self.region := region;
113    self.country := country;
114    self.postalCode := postalCode;
115    self.postalAddonCode := postalAddonCode;
116    self.fullPostalCode := fullPostalCode;
117    self.poBox := poBox;
118    self.houseNumber := houseNumber;
119    self.baseName := baseName;
120    self.streetType := streetType;
121    self.streetTypeBefore := streetTypeBefore;
122    self.streetTypeAttached := streetTypeAttached;
123    self.streetPrefix := streetPrefix;
124    self.streetSuffix := streetSuffix;
125    self.side := side;
126    self.percent := percent;
127    self.edgeId := edgeId;
128    self.errorMessage := errorMessage;
129    self.matchcode := matchcode;
130    self.matchmode := matchmode;
131    self.longitude := longitude;
132    self.latitude := latitude;
133    self.matchVector := matchVector;
134 
135    RETURN;
136   END;
137 
138 end;