[Home] [Help]
PACKAGE: APPS.JTF_TTY_WEBADI_NADOC_PKG
Source
1 PACKAGE JTF_TTY_WEBADI_NADOC_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfintfs.pls 120.2 2005/09/06 22:42:47 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_TAE_INDEX_CREATION_PVT
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 -- 05/02/2002 SHLI Created
26 --
27 -- End of Comments
28 --
29 -- *******************************************************
30 -- Start of Comments
31 -- *******************************************************
32
33 TYPE VARRAY_TYPE IS VARRAY(30) OF VARCHAR(360);
34 TYPE NARRAY_TYPE IS VARRAY(30) OF NUMBER;
35 /*
36 TYPE bulk_NAST_rec IS RECORD (
37 user_sequence jtf_terr_number_list ,
38 user_id jtf_terr_number_list ,
39 terr_grp_acct_id jtf_terr_number_list ,
40 jtf_tty_webadi_int_id jtf_terr_number_list ,
41 named_account jtf_terr_char_360list,
42 site_type jtf_terr_char_360list,
43 duns jtf_terr_char_360list,
44 trade_name jtf_terr_char_360list,
45 gu_duns jtf_terr_char_360list,
46 gu_name jtf_terr_char_360list,
47 du_duns jtf_terr_char_360list,
48 du_name jtf_terr_char_360list,
49 city jtf_terr_char_360list,
50 state jtf_terr_char_360list,
51 province jtf_terr_char_360list,
52 postal_code jtf_terr_char_360list,
53 territory_group jtf_terr_char_360list,
54 resource1_name jtf_terr_char_360list,
55 resource1_id jtf_terr_number_list,
56 group1_name jtf_terr_char_360list,
57 group1_id jtf_terr_number_list,
58 role1_name jtf_terr_char_360list,
59 role1_id jtf_terr_number_list,
60 resource2_name jtf_terr_char_360list,
61 resource2_id jtf_terr_number_list,
62 group2_name jtf_terr_char_360list,
63 group2_id jtf_terr_number_list,
64 role2_name jtf_terr_char_360list,
65 role2_id jtf_terr_number_list,
66 resource3_name jtf_terr_char_360list,
67 resource3_id jtf_terr_number_list,
68 group3_name jtf_terr_char_360list,
69 group3_id jtf_terr_number_list,
70 role3_name jtf_terr_char_360list,
71 role3_id jtf_terr_number_list,
72 resource4_name jtf_terr_char_360list,
73 resource4_id jtf_terr_number_list,
74 group4_name jtf_terr_char_360list,
75 group4_id jtf_terr_number_list,
76 role4_name jtf_terr_char_360list,
77 role4_id jtf_terr_number_list,
78 resource5_name jtf_terr_char_360list,
79 resource5_id jtf_terr_number_list,
80 group5_name jtf_terr_char_360list,
81 group5_id jtf_terr_number_list,
82 role5_name jtf_terr_char_360list,
83 role5_id jtf_terr_number_list,
84 resource6_name jtf_terr_char_360list,
85 resource6_id jtf_terr_number_list,
86 group6_name jtf_terr_char_360list,
87 group6_id jtf_terr_number_list,
88 role6_name jtf_terr_char_360list,
89 role6_id jtf_terr_number_list,
90 resource7_name jtf_terr_char_360list,
91 resource7_id jtf_terr_number_list,
92 group7_name jtf_terr_char_360list,
93 group7_id jtf_terr_number_list,
94 role7_name jtf_terr_char_360list,
95 role7_id jtf_terr_number_list,
96 resource8_name jtf_terr_char_360list,
97 resource8_id jtf_terr_number_list,
98 group8_name jtf_terr_char_360list,
99 group8_id jtf_terr_number_list,
100 role8_name jtf_terr_char_360list,
101 role8_id jtf_terr_number_list,
102 resource9_name jtf_terr_char_360list,
103 resource9_id jtf_terr_number_list,
104 group9_name jtf_terr_char_360list,
105 group9_id jtf_terr_number_list,
106 role9_name jtf_terr_char_360list,
107 role9_id jtf_terr_number_list,
108 resource10_name jtf_terr_char_360list,
109 resource10_id jtf_terr_number_list,
110 group10_name jtf_terr_char_360list,
111 group10_id jtf_terr_number_list,
112 role10_name jtf_terr_char_360list,
113 role10_id jtf_terr_number_list,
114 resource11_name jtf_terr_char_360list,
115 resource11_id jtf_terr_number_list,
116 group11_name jtf_terr_char_360list,
117 group11_id jtf_terr_number_list,
118 role11_name jtf_terr_char_360list,
119 role11_id jtf_terr_number_list,
120 resource12_name jtf_terr_char_360list,
121 resource12_id jtf_terr_number_list,
122 group12_name jtf_terr_char_360list,
123 group12_id jtf_terr_number_list,
124 role12_name jtf_terr_char_360list,
125 role12_id jtf_terr_number_list,
126 resource13_name jtf_terr_char_360list,
127 resource13_id jtf_terr_number_list,
128 group13_name jtf_terr_char_360list,
129 group13_id jtf_terr_number_list,
130 role13_name jtf_terr_char_360list,
131 role13_id jtf_terr_number_list,
132 resource14_name jtf_terr_char_360list,
133 resource14_id jtf_terr_number_list,
134 group14_name jtf_terr_char_360list,
135 group14_id jtf_terr_number_list,
136 role14_name jtf_terr_char_360list,
137 role14_id jtf_terr_number_list,
138 resource15_name jtf_terr_char_360list,
139 resource15_id jtf_terr_number_list,
140 group15_name jtf_terr_char_360list,
141 group15_id jtf_terr_number_list,
142 role15_name jtf_terr_char_360list,
143 role15_id jtf_terr_number_list,
144 resource16_name jtf_terr_char_360list,
145 resource16_id jtf_terr_number_list,
146 group16_name jtf_terr_char_360list,
147 group16_id jtf_terr_number_list,
148 role16_name jtf_terr_char_360list,
149 role16_id jtf_terr_number_list,
150 resource17_name jtf_terr_char_360list,
151 resource17_id jtf_terr_number_list,
152 group17_name jtf_terr_char_360list,
153 group17_id jtf_terr_number_list,
154 role17_name jtf_terr_char_360list,
155 role17_id jtf_terr_number_list,
156 resource18_name jtf_terr_char_360list,
157 resource18_id jtf_terr_number_list,
158 group18_name jtf_terr_char_360list,
159 group18_id jtf_terr_number_list,
160 role18_name jtf_terr_char_360list,
161 role18_id jtf_terr_number_list,
162 resource19_name jtf_terr_char_360list,
163 resource19_id jtf_terr_number_list,
164 group19_name jtf_terr_char_360list,
165 group19_id jtf_terr_number_list,
166 role19_name jtf_terr_char_360list,
167 role19_id jtf_terr_number_list,
168 resource20_name jtf_terr_char_360list,
169 resource20_id jtf_terr_number_list,
170 group20_name jtf_terr_char_360list,
171 group20_id jtf_terr_number_list,
172 role20_name jtf_terr_char_360list,
173 role20_id jtf_terr_number_list,
174 resource21_name jtf_terr_char_360list,
175 resource21_id jtf_terr_number_list,
176 group21_name jtf_terr_char_360list,
177 group21_id jtf_terr_number_list,
178 role21_name jtf_terr_char_360list,
179 role21_id jtf_terr_number_list,
180 resource22_name jtf_terr_char_360list,
181 resource22_id jtf_terr_number_list,
182 group22_name jtf_terr_char_360list,
183 group22_id jtf_terr_number_list,
184 role22_name jtf_terr_char_360list,
185 role22_id jtf_terr_number_list,
186 resource23_name jtf_terr_char_360list,
187 resource23_id jtf_terr_number_list,
188 group23_name jtf_terr_char_360list,
189 group23_id jtf_terr_number_list,
190 role23_name jtf_terr_char_360list,
191 role23_id jtf_terr_number_list,
192 resource24_name jtf_terr_char_360list,
193 resource24_id jtf_terr_number_list,
194 group24_name jtf_terr_char_360list,
195 group24_id jtf_terr_number_list,
196 role24_name jtf_terr_char_360list,
197 role24_id jtf_terr_number_list,
198 resource25_name jtf_terr_char_360list,
199 resource25_id jtf_terr_number_list,
200 group25_name jtf_terr_char_360list,
201 group25_id jtf_terr_number_list,
202 role25_name jtf_terr_char_360list,
203 role25_id jtf_terr_number_list,
204 resource26_name jtf_terr_char_360list,
205 resource26_id jtf_terr_number_list,
206 group26_name jtf_terr_char_360list,
207 group26_id jtf_terr_number_list,
208 role26_name jtf_terr_char_360list,
209 role26_id jtf_terr_number_list,
210 resource27_name jtf_terr_char_360list,
211 resource27_id jtf_terr_number_list,
212 group27_name jtf_terr_char_360list,
213 group27_id jtf_terr_number_list,
214 role27_name jtf_terr_char_360list,
215 role27_id jtf_terr_number_list,
216 resource28_name jtf_terr_char_360list,
217 resource28_id jtf_terr_number_list,
218 group28_name jtf_terr_char_360list,
219 group28_id jtf_terr_number_list,
220 role28_name jtf_terr_char_360list,
221 role28_id jtf_terr_number_list,
222 resource29_name jtf_terr_char_360list,
223 resource29_id jtf_terr_number_list,
224 group29_name jtf_terr_char_360list,
225 group29_id jtf_terr_number_list,
226 role29_name jtf_terr_char_360list,
227 role29_id jtf_terr_number_list,
228 resource30_name jtf_terr_char_360list,
229 resource30_id jtf_terr_number_list,
230 group30_name jtf_terr_char_360list,
231 group30_id jtf_terr_number_list,
232 role30_name jtf_terr_char_360list,
233 role30_id jtf_terr_number_list,
234 created_by jtf_terr_number_list,
235 last_updated_by jtf_terr_number_list,
236 last_update_login jtf_terr_number_list,
237 dnb_annual_rev jtf_terr_number_list,
238 dnb_num_of_em jtf_terr_number_list,
239 prior_won jtf_terr_number_list
240 );
241
242 --TYPE bulk_NAST_tbl IS TABLE OF bulk_NAST_rec;
243 */
244
245 procedure POPULATE_INTERFACE( P_CALLFROM IN VARCHAR2,
246 P_SEARCHTYPE IN VARCHAR2,
247 P_SEARCHVALUE IN VARCHAR2,
248 P_USERID IN INTEGER,
249 P_GRPID IN NUMBER,
250 P_GRPNAME IN VARCHAR2,
251 P_SITE_TYPE IN VARCHAR2,
252 P_SICCODE IN VARCHAR2,
253 P_SITE_DUNS IN VARCHAR2,
254 P_NAMED_ACCOUNT IN VARCHAR2,
255 P_CITY IN VARCHAR2,
256 P_STATE IN VARCHAR2,
257 P_PROVINCE IN VARCHAR2,
258 P_POSTAL_CODE_FROM IN VARCHAR2,
259 P_POSTAL_CODE_TO IN VARCHAR2,
260 P_COUNTRY IN VARCHAR2,
261 P_DU_DUNS IN VARCHAR2,
262 P_DU_NAME IN VARCHAR2,
263 P_GU_DUNS IN VARCHAR2,
264 P_GU_NAME IN VARCHAR2,
265 P_SALESPERSON IN NUMBER,
266 P_SALES_GROUP IN NUMBER,
267 P_SALES_ROLE IN VARCHAR2,
268 P_ASSIGNED_STATUS IN VARCHAR2,
269 P_IDENTADDRFLAG IN VARCHAR2,
270 P_ISADMINFLAG IN VARCHAR2,
271 X_SEQ OUT NOCOPY VARCHAR2
272 );
273
274
275
276 END JTF_TTY_WEBADI_NADOC_PKG;