DBA Data[Home] [Help]

APPS.HZ_LOCATION_V2PUB dependencies on SDO_GEOMETRY

Line 17: hz_geometry_default CONSTANT mdsys.sdo_geometry :=

13: --------------------------------------
14: -- declaration of record type
15: --------------------------------------
16:
17: hz_geometry_default CONSTANT mdsys.sdo_geometry :=
18: mdsys.sdo_geometry(fnd_api.g_miss_num,
19: fnd_api.g_miss_num, NULL, NULL, NULL);
20: geometry_status_code_default CONSTANT VARCHAR2(30) := 'DIRTY';
21:

Line 18: mdsys.sdo_geometry(fnd_api.g_miss_num,

14: -- declaration of record type
15: --------------------------------------
16:
17: hz_geometry_default CONSTANT mdsys.sdo_geometry :=
18: mdsys.sdo_geometry(fnd_api.g_miss_num,
19: fnd_api.g_miss_num, NULL, NULL, NULL);
20: geometry_status_code_default CONSTANT VARCHAR2(30) := 'DIRTY';
21:
22: -- Bug 2197181:: Added the constant for Mix-N-Match project to reduce the dependencies.

Line 60: geometry mdsys.sdo_geometry := hz_geometry_default,

56: clli_code VARCHAR2(60),
57: language VARCHAR2(4) ,
58: short_description VARCHAR2(240),
59: description VARCHAR2(2000),
60: geometry mdsys.sdo_geometry := hz_geometry_default,
61: geometry_status_code VARCHAR2(30) := geometry_status_code_default,
62: loc_hierarchy_id NUMBER,
63: sales_tax_geocode VARCHAR2(30),
64: sales_tax_inside_city_limits VARCHAR2(30),