1 package JTF_TTY_GEO_WEBADI_INT_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfgtwps.pls 120.2 2005/09/22 23:14:23 shli ship $ */
3 -- ===========================================================================+
4 -- | Copyright (c) 1999 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +===========================================================================
8 -- Start of Comments
9 -- ---------------------------------------------------
10 -- PACKAGE NAME: JTF_TTY_GEO_WEBADI_INTERFACE_PKG
11 -- ---------------------------------------------------
12 -- PURPOSE
13 --
14 -- This package is used to return a list of column in order of selectivity.
15 -- And create indices on columns in order of input
16 --
17 --
18 -- Procedures:
19 -- (see below for specification)
20 --
21 -- NOTES
22 -- This package is publicly available for use
23 --
24 -- HISTORY
25 -- 06/20/2002 SHLI Created
26 --
27 -- End of Comments
28 --
29 -- *******************************************************
30 -- Start of Comments
31 -- *******************************************************
32
33 TYPE VARRAY_TYPE IS VARRAY(20) OF VARCHAR(360);
34 TYPE NARRAY_TYPE IS VARRAY(20) OF NUMBER;
35
36
37
38 procedure POPULATE_INTERFACE( p_userid in varchar2,
39 p_geoterrlist in varchar2,
40 x_seq out NOCOPY varchar2);
41
42 procedure isDefaultTerr(terr_id IN number, flag out NOCOPY varchar2);
43
44
45 procedure UPDATE_GEO_TERR ( --p_user_sequence in varchar2,
46 p_terrgroup in varchar2,
47 p_manager_terr_name in varchar2,
48 p_country in varchar2,
49 p_state_province in varchar2,
50 p_city in varchar2,
51 p_postal_code in varchar2,
52 p_geo_terr_name in varchar2,
53 p_geo_terr_value_id in varchar2,
54 p_userid in varchar2
55 );
56
57 END JTF_TTY_GEO_WEBADI_INT_PKG;