DBA Data[Home] [Help]

APPS.HZ_LOCATIONS_PKG dependencies on SDO_GEOMETRY

Line 68: x_geometry IN mdsys.sdo_geometry,

64: x_loc_hierarchy_id IN NUMBER,
65: x_sales_tax_geocode IN VARCHAR2,
66: x_sales_tax_inside_city_limits IN VARCHAR2,
67: x_fa_location_id IN NUMBER,
68: x_geometry IN mdsys.sdo_geometry,
69: x_object_version_number IN NUMBER,
70: x_timezone_id IN NUMBER,
71: x_created_by_module IN VARCHAR2,
72: x_application_id IN NUMBER,

Line 80: l_geometry mdsys.sdo_geometry := NULL;

76: x_delivery_point_code IN VARCHAR2
77: ) IS
78:
79: l_success VARCHAR2(1) := 'N';
80: l_geometry mdsys.sdo_geometry := NULL;
81: l_primary_key_passed BOOLEAN := FALSE;
82:
83: BEGIN
84:

Line 405: x_geometry IN mdsys.sdo_geometry,

401: x_loc_hierarchy_id IN NUMBER,
402: x_sales_tax_geocode IN VARCHAR2,
403: x_sales_tax_inside_city_limits IN VARCHAR2,
404: x_fa_location_id IN NUMBER,
405: x_geometry IN mdsys.sdo_geometry,
406: x_object_version_number IN NUMBER,
407: x_timezone_id IN NUMBER,
408: x_created_by_module IN VARCHAR2,
409: x_application_id IN NUMBER,

Line 739: x_geometry IN mdsys.sdo_geometry,

735: x_loc_hierarchy_id IN NUMBER,
736: x_sales_tax_geocode IN VARCHAR2,
737: x_sales_tax_inside_city_limits IN VARCHAR2,
738: x_fa_location_id IN NUMBER,
739: x_geometry IN mdsys.sdo_geometry,
740: x_object_version_number IN NUMBER,
741: x_timezone_id IN NUMBER,
742: x_created_by_module IN VARCHAR2,
743: x_application_id IN NUMBER,

Line 1038: x_geometry OUT NOCOPY mdsys.sdo_geometry,

1034: x_loc_hierarchy_id OUT NOCOPY NUMBER,
1035: x_sales_tax_geocode OUT NOCOPY VARCHAR2,
1036: x_sales_tax_inside_city_limits OUT NOCOPY VARCHAR2,
1037: x_fa_location_id OUT NOCOPY NUMBER,
1038: x_geometry OUT NOCOPY mdsys.sdo_geometry,
1039: x_timezone_id OUT NOCOPY NUMBER,
1040: x_created_by_module OUT NOCOPY VARCHAR2,
1041: x_application_id OUT NOCOPY NUMBER,
1042: x_actual_content_source OUT NOCOPY VARCHAR2,