DBA Data[Home] [Help]

APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on SDO_GEOMETRY

Line 46: , geometry mdsys.sdo_geometry

42: , country hz_locations.country%TYPE
43: -- , county hz_locations.county%TYPE
44: -- , province hz_locations.province%TYPE
45: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
46: , geometry mdsys.sdo_geometry
47: , start_date_active DATE
48: , end_date_active DATE
49: );
50:

Line 69: , geometry mdsys.sdo_geometry

65: , country hz_locations.country%TYPE
66: , county hz_locations.county%TYPE
67: , province hz_locations.province%TYPE
68: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
69: , geometry mdsys.sdo_geometry
70: , start_date_active DATE
71: , end_date_active DATE
72: );
73:

Line 244: , x_geometry OUT NOCOPY mdsys.sdo_geometry

240: , p_country IN VARCHAR2
241: , p_country_code IN VARCHAR2
242: , p_alternate IN VARCHAR2 DEFAULT NULL
243: , p_update_address IN VARCHAR2 DEFAULT 'F'
244: , x_geometry OUT NOCOPY mdsys.sdo_geometry
245: );
246:
247: /**
248: * Returns which address line to be considered among the four