PACKAGE: MDSYS.SDO_OLS_DIRECTORY

Source

1 PACKAGE       sdo_ols_directory AUTHID current_user AS
2 
3   FUNCTION isBusinessOfCategoryId(
4     businessId      VARCHAR2,
5     categoryId      VARCHAR2,
6     categoryTypeId  VARCHAR2)
7       RETURN NUMBER;
8 
9   FUNCTION isBusinessOfCategoryName(
10     businessId      VARCHAR2,
11     categoryName    VARCHAR2,
12     categoryTypeId  VARCHAR2)
13       RETURN NUMBER;
14 
15   FUNCTION makeOpenLS10Request(
16     request XMLTYPE)
17       RETURN XMLTYPE;
18 
19   FUNCTION getOpenLsForBusiness(
20     BUSINESS_ID                   VARCHAR2,
21     BUSINESS_NAME                 VARCHAR2,
22     DESCRIPTION                   VARCHAR2,
23     PHONE                         VARCHAR2,
24     COUNTRY                       VARCHAR2,
25     COUNTRY_SUBDIVISION           VARCHAR2,
26     COUNTRY_SECONDARY_SUBDIVISION VARCHAR2,
27     MUNICIPALITY                  VARCHAR2,
28     MUNICIPALITY_SUBDIVISION      VARCHAR2,
29     POSTAL_CODE                   VARCHAR2,
30     POSTAL_CODE_EXT               VARCHAR2,
31     STREET                        VARCHAR2,
32     INTERSECTING_STREET           VARCHAR2,
33     BUILDING                      VARCHAR2,
34     x                             NUMBER,
35     y                             NUMBER,
36     parameters                    XMLTYPE,
37     openLsVersion                 VARCHAR2)
38       RETURN XMLTYPE;
39 
40   FUNCTION getOpenLsForCategory(
41     CATEGORY_ID       VARCHAR2,
42     CATEGORY_TYPE_ID  NUMBER,
43     CATEGORY_NAME     VARCHAR2,
44     PARENT_ID         VARCHAR2,
45     openLsVersion     VARCHAR2)
46       RETURN XMLTYPE;
47 
48   FUNCTION getOpenLsForCategories(
49     BUSINESS_ID   VARCHAR2,
50     openLsVersion VARCHAR2)
51       RETURN XMLTYPE;
52 
53 END sdo_ols_directory;