DBA Data[Home] [Help]

APPS.HZ_ELOCATION_PKG dependencies on SDO_GEOMETRY

Line 14: hz_geometry_default CONSTANT mdsys.sdo_geometry :=

10: g_index_name CONSTANT VARCHAR2(20) := 'hz_locations_n15';
11: g_index_owner CONSTANT VARCHAR2(2) := ''; -- Bug 12916969 . removed hard coding of 'ar'
12: g_commit_interval VARCHAR2(5) := '1000';
13:
14: hz_geometry_default CONSTANT mdsys.sdo_geometry :=
15: mdsys.sdo_geometry(fnd_api.g_miss_num,
16: fnd_api.g_miss_num, NULL, NULL, NULL);
17: geometry_status_code_default CONSTANT VARCHAR2(30) := 'DIRTY';
18:

Line 15: mdsys.sdo_geometry(fnd_api.g_miss_num,

11: g_index_owner CONSTANT VARCHAR2(2) := ''; -- Bug 12916969 . removed hard coding of 'ar'
12: g_commit_interval VARCHAR2(5) := '1000';
13:
14: hz_geometry_default CONSTANT mdsys.sdo_geometry :=
15: mdsys.sdo_geometry(fnd_api.g_miss_num,
16: fnd_api.g_miss_num, NULL, NULL, NULL);
17: geometry_status_code_default CONSTANT VARCHAR2(30) := 'DIRTY';
18:
19: TYPE geo_location_rec_type IS RECORD(

Line 31: geometry mdsys.sdo_geometry := hz_geometry_default,

27: postal_code VARCHAR2(60),
28: state VARCHAR2(60),
29: province VARCHAR2(60),
30: county VARCHAR2(60),
31: geometry mdsys.sdo_geometry := hz_geometry_default,
32: geometry_status_code VARCHAR2(30) := geometry_status_code_default,
33: geometry_accuracy NUMBER
34: );
35: