APPS.HZ_GEOGRAPHY_PUB dependencies on SDO_GEOMETRY

Line 45: geometry MDSYS.SDO_GEOMETRY,

41: end_date DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY'),
42: geo_data_provider VARCHAR2(30) DEFAULT 'USER_ENTERED',
43: language_code VARCHAR2(4) DEFAULT userenv('LANG'),
44: parent_geography_id PARENT_GEOGRAPHY_TBL_TYPE,
45: geometry MDSYS.SDO_GEOMETRY,
46: timezone_code VARCHAR2(50),
47: created_by_module VARCHAR2(150),
48: application_id NUMBER
49: );

Line 367: p_geometry IN MDSYS.SDO_GEOMETRY,

363: PROCEDURE update_geography (
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
365: p_geography_id IN NUMBER,
366: p_end_date IN DATE,
367: p_geometry IN MDSYS.SDO_GEOMETRY,
368: p_timezone_code IN VARCHAR2,
369: p_object_version_number IN OUT NOCOPY NUMBER,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER,

Line 556: p_geometry IN MDSYS.SDO_GEOMETRY,

552: p_end_date IN DATE ,
553: p_geo_data_provider IN VARCHAR2 ,
554: p_language_code IN VARCHAR2,
555: p_zone_relation_tbl IN ZONE_RELATION_TBL_TYPE,
556: p_geometry IN MDSYS.SDO_GEOMETRY,
557: p_timezone_code IN VARCHAR2,
558: x_geography_id OUT NOCOPY NUMBER,
559: p_created_by_module IN VARCHAR2,
560: p_application_id IN NUMBER,