[Home] [Help]
PACKAGE: APPS.JTF_TERRITORY_PUB
Source
1 PACKAGE JTF_TERRITORY_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfpters.pls 120.11 2010/06/30 18:47:52 sseshaiy ship $ */
3 /*#
4 * This package provides the public APIs for creating a territory or
5 * assigning resources and their access information to a territory.
6 * @rep:scope public
7 * @rep:product JTY
8 * @rep:lifecycle active
9 * @rep:displayname Create Territory and Assign Resources
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY JTY_TERRITORY
12 */
13 -- ---------------------------------------------------
14 -- Start of Comments
15 -- ---------------------------------------------------
16 -- PACKAGE NAME: JTF_TERRITORY_PUB
17 -- ---------------------------------------------------
18 -- PURPOSE
19 -- Joint task force core territory manager public api's.
20 -- This package is a public API for inserting territory
21 -- related information IN to information into JTF tables.
22 -- It contains specification for pl/sql records and tables
23 -- and the Public territory related API's.
24 --
25 -- Procedures:
26 -- (see below for specification)
27 --
28 -- NOTES
29 -- This package is publicly available for use
30 --
31 -- HISTORY
32 -- 06/09/99 VNEDUNGA Created
33 -- 07/15/99 JDOCHERT Updated existing APIs and
34 -- added new APIs
35 -- 12/09/99 VNEDUNGA Modifying TASK record defnition
36 -- 01/05/99 VNEDUNGA Changing the records def for lead/oppor
37 -- 01/10/00 VNEDUNGA Changes to serv_req/srv_task as per
38 -- new qualifer list
39 -- 01/10/00 VNEDUNGA Correcting the DEF_MGMT rec type defnition
40 -- 01/10/00 VNEDUNGA Adding language_code_id to DEF_MGMT rec type
41 -- 01/11/00 VNEDUNGA Changing the servic req and
42 -- Serv Req + Task rec def
43 -- 01/12/00 VNEDUNGA Adding currency code to lead/oppr rec type
44 -- 01/12/00 VNEDUNGA Changing Defect Rec type
45 -- 01/17/00 VNEDUNGA deleteing service request id for task
46 -- 03/22/00 VNEDUNGA Adding FULL_ACCESS_FLAG to resource record
47 -- and winning terr rec defnitions
48 -- 05/04/00 VNEDUNGA Added pricing_date
49 -- 05/04/00 VNEDUNGA Changing Area_code from varchar2(05) - 10
50 -- 06/08/00 VNEDUNGA Adding group_id to resource record defnition
51 -- 07/17/00 JDOCHERT Adding Contract Renewal record type for OKS
52 -- 09/18/00 JDOCHERT BUG#1408610 FIX
53 -- 10/30/00 JDOCHERT BUG#1478215 FIX
54 -- 07/20/2001 EIHSU CHANGED all char_XXlist to char360list for
55 -- easier maintainability and purposes of JTF_TERR_ASSIGN_PUB
56 -- 09/27/01 ARPATEL changed all char1list to char360list
57 -- 12/03/04 achanda changed the record JTF_Serv_Req_rec_type and JTF_Srv_Task_rec_type to include
58 -- fields for component and subcomponent : bug # 3726007
59 -- 12/31/08 Gmarwah changed the record JTF_Serv_Req_rec_type and JTF_Srv_Task_rec_type to include
60 -- fields for Time OF Day and Day OF week Qualifiers. Refer Bug 7676184
61 --
62 -- End of Comments
63 --
64
65
66
67 --*******************************************************
68 -- Composite Types
69 --*******************************************************
70 --
71 -- Start of Comments
72 ---------------------------------------------------------
73 -- For ORACLE SALES
74 ---------------------------------------------------------
75 /* START OF 10/30/00 JDOCHERT BUG#1478215 FIX */
76 /* These types have been created outside the package
77 ** on the database as a workaround for:
78 ** If type created internally with procedure PL/SQL error raised
79 ** PLS-00457: in USING clause expressions have to be of SQL types
80 ** They are listed here for informational purposes
81 CREATE TYPE jtf_terr_date_list IS VARRAY(1000000) OF DATE;
82 CREATE TYPE jtf_terr_number_list IS VARRAY(1000000) OF NUMBER;
83 CREATE TYPE jtf_terr_char_1list IS VARRAY(1000000) OF VARCHAR2(1);
84 CREATE TYPE jtf_terr_char_360list IS VARRAY(1000000) OF VARCHAR2(15);
85 CREATE TYPE jtf_terr_char_360list IS VARRAY(1000000) OF VARCHAR2(25);
86 CREATE TYPE jtf_terr_char_360list IS VARRAY(1000000) OF VARCHAR2(30);
87 CREATE TYPE jtf_terr_char_360list IS VARRAY(1000000) OF VARCHAR2(60);
88 CREATE TYPE jtf_terr_char_360list IS VARRAY(1000000) OF VARCHAR2(150);
89 CREATE TYPE jtf_terr_char_255list IS VARRAY(1000000) OF VARCHAR2(255);
90 ************************************************************************/
91
92
93
94 ---------------------------------------------------------
95 -- GENERIC BULK record format
96 ---------------------------------------------------------
97 TYPE jtf_bulk_trans_rec_type IS RECORD
98 (
99 TRANS_OBJECT_ID jtf_terr_number_list := jtf_terr_number_list(),
100 TRANS_DETAIL_OBJECT_ID jtf_terr_number_list := jtf_terr_number_list(),
101 SQUAL_CHAR01 jtf_terr_char_360list := jtf_terr_char_360list(),
102 SQUAL_CHAR02 jtf_terr_char_360list := jtf_terr_char_360list(),
103 SQUAL_CHAR03 jtf_terr_char_360list := jtf_terr_char_360list(),
104 SQUAL_CHAR04 jtf_terr_char_360list := jtf_terr_char_360list(),
105 SQUAL_CHAR05 jtf_terr_char_360list := jtf_terr_char_360list(),
106 SQUAL_CHAR06 jtf_terr_char_360list := jtf_terr_char_360list(),
107 SQUAL_CHAR07 jtf_terr_char_360list := jtf_terr_char_360list(),
108 SQUAL_CHAR08 jtf_terr_char_360list := jtf_terr_char_360list(),
109 SQUAL_CHAR09 jtf_terr_char_360list := jtf_terr_char_360list(),
110 SQUAL_CHAR10 jtf_terr_char_360list := jtf_terr_char_360list(),
111 SQUAL_CHAR11 jtf_terr_char_360list := jtf_terr_char_360list(),
112 SQUAL_CHAR12 jtf_terr_char_360list := jtf_terr_char_360list(),
113 SQUAL_CHAR13 jtf_terr_char_360list := jtf_terr_char_360list(),
114 SQUAL_CHAR14 jtf_terr_char_360list := jtf_terr_char_360list(),
115 SQUAL_CHAR15 jtf_terr_char_360list := jtf_terr_char_360list(),
116 SQUAL_CHAR16 jtf_terr_char_360list := jtf_terr_char_360list(),
117 SQUAL_CHAR17 jtf_terr_char_360list := jtf_terr_char_360list(),
118 SQUAL_CHAR18 jtf_terr_char_360list := jtf_terr_char_360list(),
119 SQUAL_CHAR19 jtf_terr_char_360list := jtf_terr_char_360list(),
120 SQUAL_CHAR20 jtf_terr_char_360list := jtf_terr_char_360list(),
121 SQUAL_CHAR21 jtf_terr_char_360list := jtf_terr_char_360list(),
122 SQUAL_CHAR22 jtf_terr_char_360list := jtf_terr_char_360list(),
123 SQUAL_CHAR23 jtf_terr_char_360list := jtf_terr_char_360list(),
124 SQUAL_CHAR24 jtf_terr_char_360list := jtf_terr_char_360list(),
125 SQUAL_CHAR25 jtf_terr_char_360list := jtf_terr_char_360list(),
126 SQUAL_NUM01 jtf_terr_number_list := jtf_terr_number_list(),
127 SQUAL_NUM02 jtf_terr_number_list := jtf_terr_number_list(),
128 SQUAL_NUM03 jtf_terr_number_list := jtf_terr_number_list(),
129 SQUAL_NUM04 jtf_terr_number_list := jtf_terr_number_list(),
130 SQUAL_NUM05 jtf_terr_number_list := jtf_terr_number_list(),
131 SQUAL_NUM06 jtf_terr_number_list := jtf_terr_number_list(),
132 SQUAL_NUM07 jtf_terr_number_list := jtf_terr_number_list(),
133 SQUAL_NUM08 jtf_terr_number_list := jtf_terr_number_list(),
134 SQUAL_NUM09 jtf_terr_number_list := jtf_terr_number_list(),
135 SQUAL_NUM10 jtf_terr_number_list := jtf_terr_number_list(),
136 SQUAL_NUM11 jtf_terr_number_list := jtf_terr_number_list(),
137 SQUAL_NUM12 jtf_terr_number_list := jtf_terr_number_list(),
138 SQUAL_NUM13 jtf_terr_number_list := jtf_terr_number_list(),
139 SQUAL_NUM14 jtf_terr_number_list := jtf_terr_number_list(),
140 SQUAL_NUM15 jtf_terr_number_list := jtf_terr_number_list(),
141 SQUAL_NUM16 jtf_terr_number_list := jtf_terr_number_list(),
142 SQUAL_NUM17 jtf_terr_number_list := jtf_terr_number_list(),
143 SQUAL_NUM18 jtf_terr_number_list := jtf_terr_number_list(),
144 SQUAL_NUM19 jtf_terr_number_list := jtf_terr_number_list(),
145 SQUAL_NUM20 jtf_terr_number_list := jtf_terr_number_list(),
146 SQUAL_NUM21 jtf_terr_number_list := jtf_terr_number_list(),
147 SQUAL_NUM22 jtf_terr_number_list := jtf_terr_number_list(),
148 SQUAL_NUM23 jtf_terr_number_list := jtf_terr_number_list(),
149 SQUAL_NUM24 jtf_terr_number_list := jtf_terr_number_list(),
150 SQUAL_NUM25 jtf_terr_number_list := jtf_terr_number_list(),
151 SQUAL_NUM26 jtf_terr_number_list := jtf_terr_number_list(),
152 SQUAL_NUM27 jtf_terr_number_list := jtf_terr_number_list(),
153 SQUAL_NUM28 jtf_terr_number_list := jtf_terr_number_list(),
154 SQUAL_NUM29 jtf_terr_number_list := jtf_terr_number_list(),
155 SQUAL_NUM30 jtf_terr_number_list := jtf_terr_number_list(),
156 SQUAL_NUM31 jtf_terr_number_list := jtf_terr_number_list(),
157 SQUAL_NUM32 jtf_terr_number_list := jtf_terr_number_list(),
158 SQUAL_NUM33 jtf_terr_number_list := jtf_terr_number_list(),
159 SQUAL_NUM34 jtf_terr_number_list := jtf_terr_number_list(),
160 SQUAL_NUM35 jtf_terr_number_list := jtf_terr_number_list(),
161 SQUAL_NUM36 jtf_terr_number_list := jtf_terr_number_list(),
162 SQUAL_NUM37 jtf_terr_number_list := jtf_terr_number_list(),
163 SQUAL_NUM38 jtf_terr_number_list := jtf_terr_number_list(),
164 SQUAL_NUM39 jtf_terr_number_list := jtf_terr_number_list(),
165 SQUAL_NUM40 jtf_terr_number_list := jtf_terr_number_list(),
166
167 SQUAL_CURC01 jtf_terr_char_360list := jtf_terr_char_360list(),
168 SQUAL_CURC02 jtf_terr_char_360list := jtf_terr_char_360list(),
169 SQUAL_CURC03 jtf_terr_char_360list := jtf_terr_char_360list(),
170 SQUAL_CURC04 jtf_terr_char_360list := jtf_terr_char_360list(),
171 SQUAL_CURC05 jtf_terr_char_360list := jtf_terr_char_360list()
172
173 );
174
175
176 ---------------------------------------------------------
177 -- Winning Territory record format
178 ---------------------------------------------------------
179 TYPE WINNING_BULK_REC_TYPE IS RECORD (
180 party_id jtf_terr_number_list := jtf_terr_number_list(),
181 party_site_id jtf_terr_number_list := jtf_terr_number_list(),
182 trans_object_id jtf_terr_number_list := jtf_terr_number_list(),
183 trans_detail_object_id jtf_terr_number_list := jtf_terr_number_list(),
184 terr_id jtf_terr_number_list := jtf_terr_number_list(),
185 absolute_rank jtf_terr_number_list := jtf_terr_number_list(),
186 terr_rsc_id jtf_terr_number_list := jtf_terr_number_list(),
187 resource_id jtf_terr_number_list := jtf_terr_number_list(),
188 resource_type jtf_terr_char_360list := jtf_terr_char_360list(),
189 group_id jtf_terr_number_list := jtf_terr_number_list(),
190 role jtf_terr_char_360list := jtf_terr_char_360list(),
191 full_access_flag jtf_terr_char_360list := jtf_terr_char_360list(),
192 primary_contact_flag jtf_terr_char_360list := jtf_terr_char_360list()
193 );
194
195
196
197 TYPE JTF_WIN_RSC_BULK_REC_TYPE IS RECORD
198 ( resource_id DBMS_SQL.NUMBER_TABLE,
199 resource_name DBMS_SQL.VARCHAR2_TABLE,
200 resource_job_title DBMS_SQL.VARCHAR2_TABLE,
201 resource_phone DBMS_SQL.VARCHAR2_TABLE,
205 resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,
202 resource_email DBMS_SQL.VARCHAR2_TABLE,
203 resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,
204 resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,
206 terr_id DBMS_SQL.NUMBER_TABLE,
207 absolute_rank DBMS_SQL.NUMBER_TABLE,
208 top_level_terr_id DBMS_SQL.NUMBER_TABLE,
209 resource_property1 DBMS_SQL.VARCHAR2_TABLE,
210 resource_property2 DBMS_SQL.VARCHAR2_TABLE,
211 resource_property3 DBMS_SQL.VARCHAR2_TABLE,
212 resource_property4 DBMS_SQL.VARCHAR2_TABLE
213 );
214
215 ---------------------------------------------------------
216 -- Winning Territory Record: WinningTerr_rec_type
217 --
218 -- Used for backward compatibility with pre 11.5.5 APIs
219 --
220 ---------------------------------------------------------
221 TYPE WinningTerrMember_rec_type IS RECORD
222 (
223 TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
224 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
225 RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
226 GROUP_ID NUMBER := FND_API.G_MISS_NUM,
227 ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
228 START_DATE DATE := FND_API.G_MISS_DATE,
229 END_DATE DATE := FND_API.G_MISS_DATE,
230 PRIMARY_CONTACT_FLAG VARCHAR2(01) := FND_API.G_MISS_CHAR,
231 FULL_ACCESS_FLAG VARCHAR2(01) := FND_API.G_MISS_CHAR,
232 TERR_ID NUMBER := FND_API.G_MISS_NUM,
233 TERR_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
234 ABSOLUTE_RANK NUMBER := FND_API.G_MISS_NUM
235 );
236
237 G_MISS_WINNINGTERRMEMBER_REC WinningTerrMember_rec_type;
238
239 TYPE WinningTerrMember_tbl_type IS TABLE OF WinningTerrMember_rec_type
240 INDEX BY BINARY_INTEGER;
241
242 G_MISS_WINNINGTERRMEMBER_TBL WinningTerrMember_tbl_type;
243
244
245
246 ---------------------------------------------------------
247 -- Winning Territory Record: WinningTerr_rec_type
248 --
249 -- Used for backward compatibility with
250 -- GetWinningTerritories API for Oracle Sales/Accounts
251 -- used by AMS.
252 -----------------------------------------------------------
253 TYPE WinningTerr_rec_type IS RECORD
254 (
255 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
256 PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
257 TERR_ID NUMBER := FND_API.G_MISS_NUM,
258 TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
259 RANK NUMBER := FND_API.G_MISS_NUM,
260 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
261 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
262 ORG_ID NUMBER := FND_API.G_MISS_NUM,
263 PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
264 TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
265 ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM
266 );
267
268 G_MISS_WINNINGTERR_REC WinningTerr_rec_type;
269
270 TYPE WinningTerr_tbl_type IS TABLE OF WinningTerr_rec_type
271 INDEX BY BINARY_INTEGER;
272
273 G_MISS_WINNINGTERR_TBL WinningTerr_tbl_type;
274
275
276
277
278 ---------------------------------------------------------
279 -- Account BULK record format
280 ---------------------------------------------------------
281 TYPE JTF_ACCOUNT_BULK_REC_TYPE IS RECORD (
282
283 /* 2167091 BUG FIX: JDOCHERT: 01/17/02 */
284 TRANS_OBJECT_ID jtf_terr_number_list := jtf_terr_number_list(),
285
286 city jtf_terr_char_360list := jtf_terr_char_360list(),
287 postal_code jtf_terr_char_360list := jtf_terr_char_360list(),
288 state jtf_terr_char_360list := jtf_terr_char_360list(),
289 province jtf_terr_char_360list := jtf_terr_char_360list(),
290 county jtf_terr_char_360list := jtf_terr_char_360list(),
291 country jtf_terr_char_360list := jtf_terr_char_360list(),
292 interest_type_id jtf_terr_number_list := jtf_terr_number_list (),
293 primary_interest_id jtf_terr_number_list := jtf_terr_number_list (),
294 secondary_interest_id jtf_terr_number_list := jtf_terr_number_list (),
295 party_id jtf_terr_number_list := jtf_terr_number_list (),
296 party_site_id jtf_terr_number_list := jtf_terr_number_list (),
297 area_code jtf_terr_char_360list := jtf_terr_char_360list (),
298 comp_name_range jtf_terr_char_360list := jtf_terr_char_360list(),
299 partner_id jtf_terr_number_list := jtf_terr_number_list (),
300 num_of_employees jtf_terr_number_list := jtf_terr_number_list (),
301 category_code jtf_terr_char_360list := jtf_terr_char_360list(),
302 party_relationship_id jtf_terr_number_list := jtf_terr_number_list (),
303 sic_code jtf_terr_char_360list := jtf_terr_char_360list(),
304 attribute1 jtf_terr_char_360list := jtf_terr_char_360list(),
305 attribute2 jtf_terr_char_360list := jtf_terr_char_360list(),
306 attribute3 jtf_terr_char_360list := jtf_terr_char_360list(),
307 attribute4 jtf_terr_char_360list := jtf_terr_char_360list(),
308 attribute5 jtf_terr_char_360list := jtf_terr_char_360list(),
312 attribute9 jtf_terr_char_360list := jtf_terr_char_360list(),
309 attribute6 jtf_terr_char_360list := jtf_terr_char_360list(),
310 attribute7 jtf_terr_char_360list := jtf_terr_char_360list(),
311 attribute8 jtf_terr_char_360list := jtf_terr_char_360list(),
313 attribute10 jtf_terr_char_360list := jtf_terr_char_360list(),
314 attribute11 jtf_terr_char_360list := jtf_terr_char_360list(),
315 attribute12 jtf_terr_char_360list := jtf_terr_char_360list(),
316 attribute13 jtf_terr_char_360list := jtf_terr_char_360list(),
317 attribute14 jtf_terr_char_360list := jtf_terr_char_360list(),
318 attribute15 jtf_terr_char_360list := jtf_terr_char_360list(),
319 org_id jtf_terr_number_list := jtf_terr_number_list(),
320
321 /* JDOCHERT 040901 - Bug#1697951 FIX: */
322 /* Company Annual Revenue */
323 squal_num06 jtf_terr_number_list := jtf_terr_number_list(),
324 car_currency_code jtf_terr_char_360list := jtf_terr_char_360list(),
325
326 squal_num01 jtf_terr_number_list := jtf_terr_number_list(),
327
328 /* DUNS#: BUG#2933116: JDOCHERT: 05/20/03 */
329 SQUAL_CHAR11 jtf_terr_char_360list := jtf_terr_char_360list(),
330
331 /* ARPATEL, 10/17/03: bug#3200912 Quote/Product Category */
332 squal_num50 jtf_terr_number_list := jtf_terr_number_list()
333
334 );
335
336 ---------------------------------------------------------
337 -- Lead record format
338 ---------------------------------------------------------
339 TYPE JTF_Lead_BULK_rec_type IS RECORD
340 (
341
342 /* 2167091 BUG FIX: JDOCHERT: 01/17/02 */
343 TRANS_OBJECT_ID jtf_terr_number_list := jtf_terr_number_list(),
344
345 sales_lead_id jtf_terr_number_list := jtf_terr_number_list(),
346 sales_lead_line_id jtf_terr_number_list := jtf_terr_number_list(),
347 city jtf_terr_char_360list := jtf_terr_char_360list(),
348 postal_code jtf_terr_char_360list := jtf_terr_char_360list(),
349 state jtf_terr_char_360list := jtf_terr_char_360list(),
350 province jtf_terr_char_360list := jtf_terr_char_360list(),
351 county jtf_terr_char_360list := jtf_terr_char_360list(),
352 country jtf_terr_char_360list := jtf_terr_char_360list(),
353 interest_type_id jtf_terr_number_list := jtf_terr_number_list(),
354 primary_interest_id jtf_terr_number_list := jtf_terr_number_list(),
355 secondary_interest_id jtf_terr_number_list := jtf_terr_number_list(),
356 party_id jtf_terr_number_list := jtf_terr_number_list(),
357 party_site_id jtf_terr_number_list := jtf_terr_number_list(),
358 area_code jtf_terr_char_360list := jtf_terr_char_360list (),
359 comp_name_range jtf_terr_char_360list := jtf_terr_char_360list(),
360 partner_id jtf_terr_number_list := jtf_terr_number_list(),
361 num_of_employees jtf_terr_number_list := jtf_terr_number_list(),
362 category_code jtf_terr_char_360list := jtf_terr_char_360list(),
363 party_relationship_id jtf_terr_number_list := jtf_terr_number_list(),
364 sic_code jtf_terr_char_360list := jtf_terr_char_360list(),
365 budget_amount jtf_terr_number_list := jtf_terr_number_list(),
366 currency_code jtf_terr_char_360list := jtf_terr_char_360list(),
367 pricing_date jtf_terr_date_list := jtf_terr_date_list(),
368 source_promotion_id jtf_terr_number_list := jtf_terr_number_list(),
369 inventory_item_id jtf_terr_number_list := jtf_terr_number_list(),
370 lead_interest_type_id jtf_terr_number_list := jtf_terr_number_list(),
371 lead_primary_interest_id jtf_terr_number_list := jtf_terr_number_list(),
372 lead_secondary_interest_id jtf_terr_number_list := jtf_terr_number_list(),
373 purchase_amount jtf_terr_number_list := jtf_terr_number_list(),
374 attribute1 jtf_terr_char_360list := jtf_terr_char_360list(),
375 attribute2 jtf_terr_char_360list := jtf_terr_char_360list(),
376 attribute3 jtf_terr_char_360list := jtf_terr_char_360list(),
377 attribute4 jtf_terr_char_360list := jtf_terr_char_360list(),
378 attribute5 jtf_terr_char_360list := jtf_terr_char_360list(),
379 attribute6 jtf_terr_char_360list := jtf_terr_char_360list(),
380 attribute7 jtf_terr_char_360list := jtf_terr_char_360list(),
381 attribute8 jtf_terr_char_360list := jtf_terr_char_360list(),
382 attribute9 jtf_terr_char_360list := jtf_terr_char_360list(),
383 attribute10 jtf_terr_char_360list := jtf_terr_char_360list(),
384 attribute11 jtf_terr_char_360list := jtf_terr_char_360list(),
385 attribute12 jtf_terr_char_360list := jtf_terr_char_360list(),
386 attribute13 jtf_terr_char_360list := jtf_terr_char_360list(),
387 attribute14 jtf_terr_char_360list := jtf_terr_char_360list(),
388 attribute15 jtf_terr_char_360list := jtf_terr_char_360list(),
392 /* Company Annual Revenue */
389 org_id jtf_terr_number_list := jtf_terr_number_list(),
390
391 /* JDOCHERT 040901 - Bug#1697951 FIX: */
393 squal_num06 jtf_terr_number_list := jtf_terr_number_list(),
394 car_currency_code jtf_terr_char_360list := jtf_terr_char_360list(),
395
396 squal_num01 jtf_terr_number_list := jtf_terr_number_list(),
397
398 /* DUNS#: BUG#2933116: JDOCHERT: 05/20/03 */
399 SQUAL_CHAR11 jtf_terr_char_360list := jtf_terr_char_360list(),
400
401 /* SALES CHANNEL: BUG#2725578: JDOCHERT: 08/11/03 */
402 SQUAL_CHAR30 jtf_terr_char_360list := jtf_terr_char_360list()
403
404 );
405
406 ---------------------------------------------------------
407 -- Opportunity record format
408 ---------------------------------------------------------
409 TYPE JTF_OPPOR_BULK_REC_TYPE IS RECORD (
410
411
412 /* 2167091 BUG FIX: JDOCHERT: 01/17/02 */
413 TRANS_OBJECT_ID jtf_terr_number_list := jtf_terr_number_list(),
414
415 lead_id jtf_terr_number_list := jtf_terr_number_list (),
416 lead_line_id jtf_terr_number_list := jtf_terr_number_list (),
417 city jtf_terr_char_360list := jtf_terr_char_360list(),
418 postal_code jtf_terr_char_360list := jtf_terr_char_360list(),
419 state jtf_terr_char_360list := jtf_terr_char_360list(),
420 province jtf_terr_char_360list := jtf_terr_char_360list(),
421 county jtf_terr_char_360list := jtf_terr_char_360list(),
422 country jtf_terr_char_360list := jtf_terr_char_360list(),
423 interest_type_id jtf_terr_number_list := jtf_terr_number_list (),
424 primary_interest_id jtf_terr_number_list := jtf_terr_number_list (),
425 secondary_interest_id jtf_terr_number_list := jtf_terr_number_list (),
426 party_id jtf_terr_number_list := jtf_terr_number_list (),
427 party_site_id jtf_terr_number_list := jtf_terr_number_list (),
428 area_code jtf_terr_char_360list := jtf_terr_char_360list (),
429 comp_name_range jtf_terr_char_360list := jtf_terr_char_360list(),
430 partner_id jtf_terr_number_list := jtf_terr_number_list (),
431 num_of_employees jtf_terr_number_list := jtf_terr_number_list (),
432 category_code jtf_terr_char_360list := jtf_terr_char_360list(),
433 party_relationship_id jtf_terr_number_list := jtf_terr_number_list (),
434 sic_code jtf_terr_char_360list := jtf_terr_char_360list(),
435 target_segment_current jtf_terr_char_360list := jtf_terr_char_360list(),
436 total_amount jtf_terr_number_list := jtf_terr_number_list (),
437 currency_code jtf_terr_char_360list := jtf_terr_char_360list(),
438 pricing_date jtf_terr_date_list := jtf_terr_date_list(),
439 channel_code jtf_terr_char_360list := jtf_terr_char_360list(),
440 inventory_item_id jtf_terr_number_list := jtf_terr_number_list (),
441 opp_interest_type_id jtf_terr_number_list := jtf_terr_number_list (),
442 opp_primary_interest_id jtf_terr_number_list := jtf_terr_number_list (),
443 opp_secondary_interest_id jtf_terr_number_list := jtf_terr_number_list (),
444 opclss_interest_type_id jtf_terr_number_list := jtf_terr_number_list (),
445 opclss_primary_interest_id jtf_terr_number_list := jtf_terr_number_list (),
446 opclss_secondary_interest_id jtf_terr_number_list := jtf_terr_number_list (),
447 attribute1 jtf_terr_char_360list := jtf_terr_char_360list(),
448 attribute2 jtf_terr_char_360list := jtf_terr_char_360list(),
449 attribute3 jtf_terr_char_360list := jtf_terr_char_360list(),
450 attribute4 jtf_terr_char_360list := jtf_terr_char_360list(),
451 attribute5 jtf_terr_char_360list := jtf_terr_char_360list(),
452 attribute6 jtf_terr_char_360list := jtf_terr_char_360list(),
453 attribute7 jtf_terr_char_360list := jtf_terr_char_360list(),
454 attribute8 jtf_terr_char_360list := jtf_terr_char_360list(),
455 attribute9 jtf_terr_char_360list := jtf_terr_char_360list(),
456 attribute10 jtf_terr_char_360list := jtf_terr_char_360list(),
457 attribute11 jtf_terr_char_360list := jtf_terr_char_360list(),
458 attribute12 jtf_terr_char_360list := jtf_terr_char_360list(),
459 attribute13 jtf_terr_char_360list := jtf_terr_char_360list(),
460 attribute14 jtf_terr_char_360list := jtf_terr_char_360list(),
461 attribute15 jtf_terr_char_360list := jtf_terr_char_360list(),
462 org_id jtf_terr_number_list := jtf_terr_number_list(),
463
464 /* JDOCHERT 040901 - Bug#1697951 FIX: */
465 /* Company Annual Revenue */
466 squal_num06 jtf_terr_number_list := jtf_terr_number_list(),
467 car_currency_code jtf_terr_char_360list := jtf_terr_char_360list(),
468
469 /* Campaign Code */
473
470 squal_char40 jtf_terr_char_360list := jtf_terr_char_360list(),
471 /* Opportunity Status */
472 squal_char41 jtf_terr_char_360list := jtf_terr_char_360list(),
474 /* JDOCHERT 060401 - Bug#1378393 FIX */
475 /* Opportunity Promotion Identifier */
476 squal_num40 jtf_terr_number_list := jtf_terr_number_list(),
477
478 squal_num01 jtf_terr_number_list := jtf_terr_number_list(),
479 squal_char01 jtf_terr_char_360list := jtf_terr_char_360list(),
480 squal_char02 jtf_terr_char_360list := jtf_terr_char_360list(),
481
482 /* DUNS#: BUG#2933116: JDOCHERT: 05/20/03 */
483 SQUAL_CHAR11 jtf_terr_char_360list := jtf_terr_char_360list()
484
485 );
486
487 /* END OF 10/30/00 JDOCHERT BUG#1478215 FIX */
488
489
490 --*******************************************************
491 -- Start of Comments
492 ---------------------------------------------------------
493 -- Service request view record format
494 ---------------------------------------------------------
495 -- Parameters:
496 -- Required:
497 -- Defaults:
498 -- Note:
499 --
500 -- End of Comments
501
502 TYPE JTF_Serv_Req_rec_type IS RECORD
503 (
504 SERVICE_REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
505 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
506 COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
507 PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
508 CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
509 POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
510 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
511 AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
512 COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
513 COMP_NAME_RANGE VARCHAR2(360) := FND_API.G_MISS_CHAR,
514 PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
515 NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
516 INCIDENT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
517 INCIDENT_SEVERITY_ID NUMBER := FND_API.G_MISS_NUM,
518 INCIDENT_URGENCY_ID NUMBER := FND_API.G_MISS_NUM,
519 PROBLEM_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
520 INCIDENT_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
521 PLATFORM_ID NUMBER := FND_API.G_MISS_NUM,
522 SUPPORT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
523 CUSTOMER_SITE_ID NUMBER := FND_API.G_MISS_NUM,
524 SR_CREATION_CHANNEL VARCHAR2(150) := FND_API.G_MISS_CHAR,
525 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
526 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
527 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
528 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
529 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
530 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
531 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
532 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
533 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
534 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
535 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
536 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
537 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
538 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
539 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
540 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
541 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
542
543
544 /* Qualifier: SR Platform: */
545 -- Inventory Item Id
546 SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
547 -- Organization Id
548 SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
549
550 /* Qualifier: SR Product Category: */
551 -- Category Id
552 SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
553
554 /* Qualifier: SR Product, SR Product/Component/Subcomponent: */
555 -- Inventory Item Id
556 SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
557 -- Organization Id
558 SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
559 -- Component
560 SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
561 -- Subcomponent
562 SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
563
564 /* Qualifier: SR Group Owner */
565 SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
566
567 /* Contract Support Service Item# */
568 -- Inventory Item Id
569 SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
570 -- Organization Id
571 SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
572
573 /* VIP Customers */
574 SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
575
576 /* Qualifier: SR Problem Code */
577 SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
578
579 /* Qualifier: SR Customer Contact Preference */
583 SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
580 SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
581
582 /* Qualifier: SR Service Contract Coverage */
584
585 /* SR Language */
586 SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
587
588 SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,
589
590 /* Day Of Week */
591
592 DAY_OF_WEEK VARCHAR2(360) := FND_API.G_MISS_CHAR,
593
594 /*Time of Day */
595 TIME_OF_DAY VARCHAR2(360) := FND_API.G_MISS_CHAR,
596 /* System */
597 SQUAL_NUM60 NUMBER := FND_API.G_MISS_NUM
598 );
599
600
601 ---------------------------------------------------------
602 -- Service Task view record format
603 ---------------------------------------------------------
604 -- Parameters:
605 -- Required:
606 -- Defaults:
607 -- Note:
608 --
609 -- End of Comments
610
611 TYPE JTF_Task_rec_type IS RECORD
612 (
613 TASK_ID NUMBER := FND_API.G_MISS_NUM,
614 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
615 COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
616 PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
617 CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
618 POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
619 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
620 AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
621 COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
622 COMP_NAME_RANGE VARCHAR2(360) := FND_API.G_MISS_CHAR,
623 PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
624 NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
625 TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
626 TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
627 TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
628 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
629 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
630 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
631 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
632 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
633 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
634 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
635 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
636 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
637 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
638 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
639 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
640 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
641 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
642 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
643 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM
644 );
645
646
647 ---------------------------------------------------------
648 -- Service Service/Task view record format
649 ---------------------------------------------------------
650 -- Parameters:
651 -- Required:
652 -- Defaults:
653 -- Note:
654 --
655 -- End of Comments
656
657 TYPE JTF_Srv_Task_rec_type IS RECORD
658 (
659 TASK_ID NUMBER := FND_API.G_MISS_NUM,
660 SERVICE_REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
661 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
662 COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
663 PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
664 CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
665 POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
666 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
667 AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
668 COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
669 COMP_NAME_RANGE VARCHAR2(360) := FND_API.G_MISS_CHAR,
670 PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
671 NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
672 TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
673 TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
674 TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
675 INCIDENT_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
676 INCIDENT_SEVERITY_ID NUMBER := FND_API.G_MISS_NUM,
677 INCIDENT_URGENCY_ID NUMBER := FND_API.G_MISS_NUM,
678 PROBLEM_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
679 INCIDENT_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
680 PLATFORM_ID NUMBER := FND_API.G_MISS_NUM,
681 SUPPORT_SITE_ID NUMBER := FND_API.G_MISS_NUM,
682 CUSTOMER_SITE_ID NUMBER := FND_API.G_MISS_NUM,
683 SR_CREATION_CHANNEL VARCHAR2(150) := FND_API.G_MISS_CHAR,
684 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
685 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
689 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
686 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
687 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
688 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
690 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
691 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
692 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
693 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
694 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
695 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
696 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
697 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
698 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
699 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
700 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
701
702 /* Qualifier: SR Platform: */
703 -- Inventory Item Id
704 SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
705 -- Organization Id
706 SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
707
708 /* Qualifier: SR Product Category: */
709 -- Category Id
710 SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
711
712 /* Qualifier: SR Product, SR Product/Component/Subcomponent: */
713 -- Inventory Item Id
714 SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
715 -- Organization Id
716 SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
717 -- Component
718 SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
719 -- Subcomponent
720 SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
721
722 /* Qualifier: SR Group Owner */
723 SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
724
725 /* Contract Support Service Item# */
726 -- Inventory Item Id
727 SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
728 -- Organization Id
729 SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
730
731 /* VIP Customers */
732 SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
733
734 /* Qualifier: SR Problem Code */
735 SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
736
737 /* Qualifier: SR Customer Contact Preference */
738 SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
739
740 /* Qualifier: SR Service Contract Coverage */
741 SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
742
743 /* SR Language */
744 SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
745
746 SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,
747
748
749 /* Day Of Week */
750
751 DAY_OF_WEEK VARCHAR2(360) := FND_API.G_MISS_CHAR,
752
753 /*Time of Day */
754 TIME_OF_DAY VARCHAR2(360) := FND_API.G_MISS_CHAR,
755 /* System */
756 SQUAL_NUM60 NUMBER := FND_API.G_MISS_NUM
757 );
758
759
760
761 --*******************************************************
762 -- Start of Comments
763 ---------------------------------------------------------
764 -- Contract Renewal record type
765 ---------------------------------------------------------
766 -- Parameters:
767 -- Required:
768 -- Defaults:
769 -- Note:
770 --
771 -- End of Comments
772
773 TYPE JTF_KREN_rec_type IS RECORD
774 (
775 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
776 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
777 COMP_NAME_RANGE VARCHAR2(360) := FND_API.G_MISS_CHAR,
778 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
779 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
780 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
781 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
782 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
783 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
784 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
785 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
786 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
787 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
788 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
789 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
790 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
791 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
792 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
793 );
794
795
796 --*******************************************************
797 -- Start of Comments
798 ---------------------------------------------------------
799 -- Defect Management record format
800 ---------------------------------------------------------
801 -- Parameters:
802 -- Required:
803 -- Defaults:
804 -- Note:
805 --
806 -- End of Comments
807 TYPE JTF_DEF_MGMT_rec_type IS RECORD
808 (
812 SQUAL_CHAR04 VARCHAR2(360) := FND_API.G_MISS_CHAR,
809 SQUAL_CHAR01 VARCHAR2(360) := FND_API.G_MISS_CHAR,
810 SQUAL_CHAR02 VARCHAR2(360) := FND_API.G_MISS_CHAR,
811 SQUAL_CHAR03 VARCHAR2(360) := FND_API.G_MISS_CHAR,
813 SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,
814 SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,
815 SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,
816 SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,
817 SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,
818 SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
819 SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
820 SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
821 SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
822 SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
823 SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,
824 SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,
825 SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,
826 SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,
827 SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,
828 SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
829 SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
830 SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,
831 SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,
832 SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,
833 SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,
834 SQUAL_NUM01 NUMBER := FND_API.G_MISS_NUM,
835 SQUAL_NUM02 NUMBER := FND_API.G_MISS_NUM,
836 SQUAL_NUM03 NUMBER := FND_API.G_MISS_NUM,
837 SQUAL_NUM04 NUMBER := FND_API.G_MISS_NUM,
838 SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,
839 SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,
840 SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,
841 SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,
842 SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,
843 SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,
844 SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,
845 SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
846 SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
847 SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
848 SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
849 SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
850 SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
851 SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
852 SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
853 SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,
854 SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,
855 SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,
856 SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
857 SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
858 SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,
859 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
860 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
861 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
862 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
863 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
864 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
865 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
866 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
867 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
868 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
869 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
870 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
871 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
872 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
873 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
874 );
875
876
877
878
879 --*******************************************************
880 -- Start of Comments
881 ---------------------------------------------------------
882 -- Territory Resource Record: TerrResource_rec_type
883 ---------------------------------------------------------
884 TYPE TerrResource_rec_type IS RECORD
885 (
886 TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
887 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
888 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
889 CREATION_DATE DATE := FND_API.G_MISS_DATE,
890 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
891 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
892 TERR_ID NUMBER := FND_API.G_MISS_NUM,
893 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
894 GROUP_ID NUMBER := FND_API.G_MISS_NUM,
895 RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
896 ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
900 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
897 PRIMARY_CONTACT_FLAG VARCHAR2(1) := 'N',
898
899 /* BUG# 1355914 - FIX START*/
901 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
902 /* BUG# 1355914 - FIX END*/
903
904 FULL_ACCESS_FLAG VARCHAR2(1) := 'Y',
905 ORG_ID NUMBER := FND_API.G_MISS_NUM,
906 -- Adding the attribute columns as fix for bug 7168485.
907 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
908 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
909 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
910 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
911 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
912 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
913 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
914 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
915 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
916 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
917 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
918 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
919 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
920 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
921 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
922 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR);
923
924 G_MISS_TERRRESOURCE_REC TerrResource_rec_type;
925
926 TYPE TerrResource_tbl_type IS TABLE OF TerrResource_rec_type
927 INDEX BY BINARY_INTEGER;
928
929 G_MISS_TERRRESOURCE_TBL TerrResource_tbl_type;
930
931
932 --***********************************************************
933 -- Start of Comments
934 -------------------------------------------------------------
935 -- Territory Resource out Record: TerrResource_out_rec_type
936 -------------------------------------------------------------
937 TYPE TerrResource_out_rec_type IS RECORD
938 (
939 TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
940 RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
941 );
942
943 G_MISS_TERRRESOURCE_OUT_REC TerrResource_out_rec_type;
944
945
946 TYPE TerrResource_out_tbl_type IS TABLE OF TerrResource_out_rec_type
947 INDEX BY BINARY_INTEGER;
948
949 G_MISS_TERRRESOURCE_OUT_TBL TerrResource_out_tbl_type;
950
951
952 ---------------------------------------------------------
953 -- Territory Resource Record: TerrRsc_Access_type
954 ---------------------------------------------------------
955 TYPE TerrRsc_Access_Rec_type IS RECORD
956 (
957 TERR_RSC_ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
958 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
959 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
960 CREATION_DATE DATE := FND_API.G_MISS_DATE,
961 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
962 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
963 TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
964 ACCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
965 ORG_ID NUMBER := FND_API.G_MISS_NUM,
966 QUALIFIER_TBL_INDEX NUMBER := FND_API.G_MISS_NUM,
967 TRANS_ACCESS_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
968 );
969
970 G_MISS_TERRRSC_ACCESS_REC TerrRsc_Access_Rec_type;
971
972 TYPE TerrRsc_Access_tbl_type IS TABLE OF TerrRsc_Access_rec_type
973 INDEX BY BINARY_INTEGER;
974
975 G_MISS_TERRRSC_ACCESS_TBL TerrRsc_Access_tbl_type;
976
977
978
979 -- ***********************************************************
980 -- Start of Comments
981 -------------------------------------------------------------------
982 -- Territory Resource access out Record: TerrResource_out_rec_type
983 -------------------------------------------------------------------
984 TYPE TerrRsc_Access_Out_rec_type IS RECORD
985 (
986 TERR_RSC_ACCESS_ID NUMBER := FND_API.G_MISS_NUM,
987 RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
988 );
989
990 G_MISS_TERRRSC_ACCESS_OUT_REC TerrRsc_Access_Out_rec_type;
991
992
993 TYPE TerrRsc_Access_out_tbl_type IS TABLE OF TerrRsc_Access_Out_rec_type
994 INDEX BY BINARY_INTEGER;
995
996 G_MISS_TERRRSC_ACCESS_OUT_TBL TerrRsc_Access_out_tbl_type;
997
998
999 -- ***************************************************
1000 -- Start of Comments
1001 -- ---------------------------------------------------
1002 -- Territory record type: Terr_All_Rec_Type
1003 -- ---------------------------------------------------
1004 TYPE Terr_All_Rec_Type IS RECORD
1005 (
1006 TERR_ID NUMBER := FND_API.G_MISS_NUM,
1007 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1008 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1009 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1010 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1011 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1012 APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
1016 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
1013 NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
1014 ENABLED_FLAG VARCHAR2(1) := 'N',
1015 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
1017 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
1018 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1019 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
1020 RANK NUMBER := FND_API.G_MISS_NUM,
1021 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
1022 DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
1023 UPDATE_FLAG VARCHAR2(1) := 'Y',
1024 AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1025 PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1026 TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
1027 PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
1028 TEMPLATE_FLAG VARCHAR2(1) := 'N',
1029 TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
1030 ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N',
1031 ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
1032 OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1033 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
1034 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1035 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1036 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1037 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1038 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1039 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1040 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1041 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1042 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1043 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1044 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1045 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1046 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1047 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1048 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1049 ORG_ID NUMBER := FND_API.G_MISS_NUM,
1050 NUM_WINNERS NUMBER := FND_API.G_MISS_NUM
1051 );
1052
1053 TYPE Terr_All_Tbl_Type IS TABLE OF Terr_All_Rec_Type
1054 INDEX BY BINARY_INTEGER;
1055
1056 G_MISS_Terr_All_Rec Terr_All_Rec_Type;
1057
1058 G_MISS_Terr_All_Tbl Terr_All_Tbl_Type;
1059
1060
1061 -- ***************************************************
1062 -- Start of Comments
1063 -- ---------------------------------------------------
1064 TYPE Terr_Qual_Rec_Type IS RECORD
1065 (
1066 Rowid VARCHAR2(50) := FND_API.G_MISS_CHAR,
1067 TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
1068 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1069 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1070 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1071 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1072 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1073 TERR_ID NUMBER := FND_API.G_MISS_NUM,
1074 QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
1075 USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1076 GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1077 OVERLAP_ALLOWED_FLAG VARCHAR2(1) := 'Y',
1078 QUALIFIER_MODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1079 ORG_ID NUMBER := FND_API.G_MISS_NUM
1080 );
1081
1082 TYPE Terr_Qual_Tbl_Type IS TABLE OF Terr_Qual_Rec_Type
1083 INDEX BY BINARY_INTEGER;
1084
1085 G_MISS_Terr_Qual_Rec Terr_Qual_Rec_Type;
1086
1087 G_MISS_Terr_Qual_Tbl Terr_Qual_Tbl_Type;
1088
1089
1090
1091 -- ***************************************************
1092 -- Start of Comments
1093 -- ---------------------------------------------------
1094 -- Territory values record type: Terr_Values_Rec_Type
1095 -- ---------------------------------------------------
1096 TYPE Terr_Values_Rec_Type IS RECORD
1097 (
1098 TERR_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
1099 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1100 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1101 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1102 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1103 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1104 TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
1105 INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
1106 COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
1107 LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
1108 HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
1109 LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
1110 HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
1111 VALUE_SET NUMBER := FND_API.G_MISS_NUM,
1115 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
1112 INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
1113 PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
1114 SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
1116 ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1117 LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
1118 QUALIFIER_TBL_INDEX NUMBER := FND_API.G_MISS_NUM,
1119 ORG_ID NUMBER := FND_API.G_MISS_NUM,
1120 CNR_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
1121 VALUE1_ID NUMBER := FND_API.G_MISS_NUM,
1122 VALUE2_ID NUMBER := FND_API.G_MISS_NUM,
1123 VALUE3_ID NUMBER := FND_API.G_MISS_NUM,
1124 VALUE4_ID NUMBER := FND_API.G_MISS_NUM
1125 );
1126
1127 TYPE Terr_Values_Tbl_Type IS TABLE OF Terr_Values_Rec_Type
1128 INDEX BY BINARY_INTEGER;
1129
1130 G_MISS_Terr_Values_Rec Terr_Values_Rec_Type;
1131
1132 G_MISS_Terr_Values_Tbl Terr_Values_Tbl_Type;
1133
1134
1135 -- ***************************************************
1136 -- Start of Comments
1137 -- ---------------------------------------------------
1138 -- Territory source Record: terr_Usgs_rec_type
1139 -- ---------------------------------------------------
1140 TYPE terr_usgs_rec_type IS RECORD
1141 (
1142 TERR_USG_ID NUMBER := FND_API.G_MISS_NUM,
1143 SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
1144 TERR_ID NUMBER := FND_API.G_MISS_NUM,
1145 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1146 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1147 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1148 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1149 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1150 ORG_ID NUMBER := FND_API.G_MISS_NUM
1151 );
1152
1153 G_MISS_TERR_USGS_REC terr_usgs_rec_type;
1154
1155 TYPE terr_usgs_tbl_type IS TABLE OF terr_usgs_rec_type
1156 INDEX BY BINARY_INTEGER;
1157
1158 G_MISS_TERR_USGS_TBL terr_usgs_tbl_type;
1159
1160
1161 -- *************************************************************
1162 -- Start of Comments
1163 -- -------------------------------------------------------------
1164 -- Territory qualifier Type Record: TerrQualTypeUsgs_rec_type
1165 -- -------------------------------------------------------------
1166 TYPE terr_qualtypeusgs_rec_type IS RECORD
1167 (
1168 TERR_QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
1169 TERR_ID NUMBER := FND_API.G_MISS_NUM,
1170 QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
1171 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1172 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1173 CREATION_DATE DATE := FND_API.G_MISS_DATE,
1174 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1175 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
1176 ORG_ID NUMBER := FND_API.G_MISS_NUM
1177 );
1178
1179 G_MISS_TERR_QUALTYPEUSGS_REC terr_qualtypeusgs_rec_type;
1180
1181 TYPE terr_qualtypeusgs_tbl_type IS TABLE OF terr_qualtypeusgs_rec_type
1182 INDEX BY BINARY_INTEGER;
1183
1184 G_MISS_TERR_QUALTYPEUSGS_TBL Terr_QualTypeUsgs_tbl_type;
1185
1186
1187 -- ***********************************************************
1188 -- Start of Comments
1189 -- -----------------------------------------------------------
1190 -- Territory out Record: terr_all_out_rec
1191 -- -----------------------------------------------------------
1192 TYPE terr_all_out_rec_type IS RECORD
1193 (
1194 TERR_ID NUMBER := FND_API.G_MISS_NUM,
1195 RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
1196 );
1197
1198 G_MISS_TERR_ALL_OUT_REC terr_all_out_rec_type;
1199
1200
1201 TYPE Terr_All_out_tbl_type IS TABLE OF terr_all_out_rec_type
1202 INDEX BY BINARY_INTEGER;
1203
1204 G_MISS_TERR_ALL_OUT_TBL Terr_All_out_tbl_type;
1205
1206
1207 -- ***********************************************************
1208 -- Start of Comments
1209 -- -----------------------------------------------------------
1210 -- Territory usages out Record: terr_usgs_out_rec_type
1211 -- -----------------------------------------------------------
1212 TYPE Terr_Usgs_out_rec_type IS RECORD
1213 (
1214 TERR_USG_ID NUMBER := FND_API.G_MISS_NUM,
1215 RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
1216 );
1217
1218 G_MISS_TERR_USGS_OUT_REC terr_usgs_out_rec_type;
1219
1220 TYPE Terr_Usgs_out_tbl_type IS TABLE OF terr_usgs_out_rec_type
1221 INDEX BY BINARY_INTEGER;
1222 G_MISS_TERR_USGS_OUT_TBL Terr_Usgs_out_tbl_type;
1223
1224
1225 -- ****************************************************************
1226 -- Start of Comments
1227 -- ----------------------------------------------------------------
1228 -- Territory qualifier type out Record: terr_QualTypeUsgs_out_rec
1229 -- ----------------------------------------------------------------
1230 TYPE terr_QualTypeUsgs_out_rec_type IS RECORD
1231 (
1235
1232 TERR_QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
1233 RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
1234 );
1236 G_MISS_TERRQUALTYPUSGS_OUT_REC terr_QualTypeUsgs_out_rec_type;
1237
1238 TYPE Terr_QualTypeUsgs_Out_Tbl_Type IS TABLE OF terr_QualTypeUsgs_out_rec_type
1239 INDEX BY BINARY_INTEGER;
1240 G_MISS_TERRQUALTYPUSGS_OUT_TBL Terr_QualTypeUsgs_Out_Tbl_Type;
1241
1242 -- ***********************************************************
1243 -- Start of Comments
1244 -- -----------------------------------------------------------
1245 -- Territory qualifiers out Record: terr_Oual_out_rec_Type
1246 -- -----------------------------------------------------------
1247 TYPE Terr_Qual_out_rec_type IS RECORD
1248 (
1249 TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
1250 RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
1251 );
1252
1253 G_MISS_TERR_QUAL_OUT_REC Terr_Qual_out_rec_type;
1254
1255 TYPE Terr_Qual_out_tbl_type IS TABLE OF Terr_Qual_out_rec_type
1256 INDEX BY BINARY_INTEGER;
1257 G_MISS_TERR_QUAL_OUT_TBL Terr_Qual_Out_tbl_type;
1258
1259
1260 -- ***********************************************************
1261 -- Start of Comments
1262 -- -----------------------------------------------------------
1263 -- Territory values out Record: terr_values_out_rec_type
1264 -- -----------------------------------------------------------
1265 TYPE Terr_Values_out_rec_type IS RECORD
1266 (
1267 TERR_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
1268 RETURN_STATUS VARCHAR2(01) := FND_API.G_MISS_CHAR
1269 );
1270
1271 G_MISS_TERR_VALUES_OUT_REC terr_values_out_rec_type;
1272
1273
1274 TYPE Terr_Values_out_tbl_type IS TABLE OF terr_values_out_rec_type
1275 INDEX BY BINARY_INTEGER;
1276
1277 G_MISS_TERR_VALUES_OUT_TBL Terr_Values_out_tbl_type;
1278
1279
1280 -- ***************************************************
1281 -- start of comments
1282 -- ***************************************************
1283 -- API name : Create_Territory
1284 -- Type : PUBLIC
1285 -- Function : To create Territories - which inludes the creation of following
1286 -- Territory Header, Territory Qualifier, terr Usages,
1287 -- Territory Qualifiers and Territory Qualifier Values.
1288 -- P_terr_values_tbl.QUALIFIER_TBL_INDEX is, associates the values with the Qualifier,
1289 -- the index of qualifier record of the qualifier table.
1290 -- Atleast one qualifier value must be passed, other wise, Qualifier can't be created.
1291 -- This procedure creates the records in the following tables.
1292 -- JTF_TERR_ALL,
1293 -- JTF_TERR_USGS_ALL,
1294 -- JTF_TERR_QTYPE_USGS_ALL,
1295 -- JTF_TERR_QUAL_ALL,
1296 -- JTF_TERR_VALUES_ALL.
1297 --
1298 -- Pre-reqs :
1299 -- Parameters:
1300 -- IN :
1301 -- Required
1302 -- Parameter Name Data Type Default
1303 -- p_Api_Version_Number NUMBER
1304 -- p_Terr_All_Rec Terr_All_Rec_Type := G_Miss_Terr_All_Rec
1305 -- p_Terr_Usgs_Tbl Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl
1306 -- p_Terr_Qual_Tbl Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl
1307 -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
1308 --
1309 -- Optional
1310 -- Parameter Name Data Type Default
1311 -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1312 -- p_Commit VARCHAR2 := FND_API.G_FALSE
1313 --
1314 -- OUT NOCOPY :
1315 -- Parameter Name Data Type
1316 -- x_Return_Status VARCHAR2(1)
1317 -- x_Msg_Count NUMBER
1318 -- x_Msg_Data VARCHAR2(2000)
1319 -- x_Terr_Id NUMBER
1320 -- x_Terr_Usgs_Out_Tbl Terr_Usgs_Out_Tbl,
1321 -- x_Terr_QualTypeUsgs_Out_Tbl Terr_QualTypeUsgs_Out_Tbl,
1322 -- x_Terr_Qual_Out_Tbl Terr_Qual_Out_Tbl,
1323 -- x_Terr_Values_Out_Tbl Terr_Values_Out_Tbl
1324 --
1325 --
1326 -- Notes:
1327 --
1328 --
1329 -- End of Comments
1330 --
1331 /*#
1332 * Use this API to create a territory based on territory header information (name, parent territory, rank, etc.),
1333 * usage, transaction types, qualifiers and qualifier values.
1334 * @param p_api_version_number API version number
1335 * @param p_init_msg_list Initialize message array
1336 * @param p_commit Commit after processing transaction
1337 * @param p_terr_all_rec Territory detail information like name, rank, number of winners, parent territory
1338 * @param p_terr_usgs_tbl Territory usage information:
1339 * -1001 for Oracle Sales and Telesales,
1340 * -1002 for Oracle Service,
1341 * -1003 for Oracle Trade Management,
1342 * -1004 for Oracle Defect Management,
1343 * -1500 for Oracle Service Contracts,
1344 * -1600 for Oracle Collections,
1345 * and -1700 for Oracle Partner Management
1346 * @param p_terr_qual_tbl Territory qualifier information like qualifier name
1347 * @param p_terr_values_tbl Territory qualifier value information like condition, qualifier value
1348 * @param x_return_status API return status stating success, failure or unexpected error
1349 * @param x_msg_count Number of error messages recorded during processing
1350 * @param x_msg_data Contains message text if msg_count=1
1354 * @param x_terr_qual_out_tbl Territory qualifier information including the territory qualifier identifiers
1351 * @param x_terr_id Identifier of the created territory
1352 * @param x_terr_usgs_out_tbl Territory usage information including the territory usage identifier
1353 * @param x_terr_qualtypeusgs_out_tbl Territory transaction type information including the territory transaction type identifier
1355 * @param x_terr_values_out_tbl Territory qualifier value information including the territory qualifier value identifiers
1356 * @rep:scope public
1357 * @rep:lifecycle active
1358 * @rep:displayname Create Territory
1359 */
1360
1361 PROCEDURE Create_Territory
1362 (p_Api_Version_Number IN NUMBER,
1363 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1364 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1365 x_Return_Status OUT NOCOPY VARCHAR2,
1366 x_Msg_Count OUT NOCOPY NUMBER,
1367 x_Msg_Data OUT NOCOPY VARCHAR2,
1368 p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1369 p_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
1370 --p_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
1371 p_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
1372 p_Terr_Values_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
1373 x_Terr_Id OUT NOCOPY NUMBER,
1374 x_Terr_Usgs_Out_Tbl OUT NOCOPY Terr_Usgs_Out_Tbl_Type,
1375 x_Terr_QualTypeUsgs_Out_Tbl OUT NOCOPY Terr_QualTypeUsgs_Out_Tbl_Type,
1376 x_Terr_Qual_Out_Tbl OUT NOCOPY Terr_Qual_Out_Tbl_Type,
1377 x_Terr_Values_Out_Tbl OUT NOCOPY Terr_Values_Out_Tbl_Type);
1378
1379
1380 -- ***************************************************
1381 -- start of comments
1382 -- ***************************************************
1383 --
1384 -- API name : Delete_Territory
1385 -- Type : PUBLIC
1386 -- Function : To delete Territories - which would also delete
1387 -- Territory Header, Territory Qualifier,
1388 -- Territory Qualifier Values and Resources.
1389 --
1390 -- Pre-reqs :
1391 -- Parameters:
1392 -- IN :
1393 -- Required
1394 -- Parameter Name Data Type Default
1395 -- p_Api_Version_Number NUMBER
1396 -- p_Terr_Id NUMBER
1397 --
1398 -- Optional
1399 -- Parameter Name Data Type Default
1400 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1401 -- p_Commit VARCHAR2 FND_API.G_FALSE
1402 --
1403 -- OUT NOCOPY :
1404 -- Parameter Name Data Type
1405 -- p_Return_Status VARCHAR2(1)
1406 -- p_Msg_Count NUMBER
1407 -- p_Msg_Data VARCHAR2(2000)
1408 --
1409 --
1410 -- Notes:
1411 -- Rules for deletion have to be very strict.
1412 --
1413 -- End of Comments
1414 --
1415 PROCEDURE Delete_Territory
1416 (p_Api_Version_Number IN NUMBER,
1417 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1418 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1419 x_Return_Status OUT NOCOPY VARCHAR2,
1420 x_Msg_Count OUT NOCOPY NUMBER,
1421 x_Msg_Data OUT NOCOPY VARCHAR2,
1422 p_Terr_Id IN NUMBER);
1423
1424
1425 -- ***************************************************
1426 -- start of comments
1427 -- ***************************************************
1428 -- API name : Update_Territory
1429 -- Type : PUBLIC
1430 -- Function : To update existing Territory Header whcich will update
1431 -- the records in JTF_TERR_ALL table.
1432 -- We can't update the territory usage and Territory Qual Types.
1433 -- Updating Qualifier Values can be done with Update_Qualifier_Value procedure.
1434 -- Pre-reqs :
1435 -- Parameters:
1436 -- IN :
1437 -- Required
1438 -- Parameter Name Data Type Default
1439 -- p_Api_Version_Number NUMBER
1440 -- p_Terr_All_Rec Terr_All_Rec_Type := G_Miss_Terr_All_Rec
1441 --
1442 -- Optional
1443 -- Parameter Name Data Type Default
1444 -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1445 -- p_Commit VARCHAR2 := FND_API.G_FALSE
1446 --
1447 -- OUT NOCOPY :
1448 -- Parameter Name Data Type
1449 -- p_Return_Status VARCHAR2(1)
1450 -- p_Msg_Count NUMBER
1451 -- p_Msg_Data VARCHAR2(2000)
1452 -- p_Terr_All_Out_Rec Terr_All_Out_Rec
1453 --
1454 --
1455 -- Notes:
1456 --
1457 --
1458 -- End of Comments
1459 --
1460
1461 PROCEDURE Update_Territory
1462 (p_Api_Version_Number IN NUMBER,
1463 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1464 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1465 x_Return_Status OUT NOCOPY VARCHAR2,
1466 x_Msg_Count OUT NOCOPY NUMBER,
1467 x_Msg_Data OUT NOCOPY VARCHAR2,
1468 p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1469 /* Territory Usage and Transaction types cant be updated in R12.
1470 p_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
1471 p_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
1475 -- x_Terr_Usgs_Out_Tbl OUT NOCOPY Terr_Usgs_Out_Tbl_Type,
1472 p_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
1473 p_Terr_Values_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl, */
1474 x_Terr_All_Out_Rec OUT NOCOPY Terr_All_Out_Rec_Type
1476 -- x_Terr_QualTypeUsgs_Out_Tbl OUT NOCOPY Terr_QualTypeUsgs_Out_Tbl_Type,
1477 -- x_Terr_Qual_Out_Tbl OUT NOCOPY Terr_Qual_Out_Tbl_Type,
1478 -- x_Terr_Values_Out_Tbl OUT NOCOPY Terr_Values_Out_Tbl_Type
1479 );
1480
1481
1482 -- ***************************************************
1483 -- start of comments
1484 -- ***************************************************
1485 --
1486 -- API name : Deactivate_Territory
1487 -- Type : PUBLIC
1488 -- Function : To deactivate Territories - this API also deactivates
1489 -- any sub-territories of this territory.
1490 --
1491 -- Pre-reqs :
1492 -- Parameters:
1493 -- IN :
1494 -- Required
1495 -- Parameter Name Data Type Default
1496 -- p_Api_Version_Number NUMBER
1497 -- p_Terr_Id NUMBER
1498 --
1499 -- Optional
1500 -- Parameter Name Data Type Default
1501 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1502 -- p_Commit VARCHAR2 FND_API.G_FALSE
1503 --
1504 -- OUT :
1505 -- Parameter Name Data Type
1506 -- x_Return_Status VARCHAR2(1)
1507 -- x_Msg_Count NUMBER
1508 -- x_Msg_Data VARCHAR2(2000)
1509 --
1510 --
1511 -- Notes:
1512 --
1513 --
1514 -- End of Comments
1515 --
1516 PROCEDURE Deactivate_Territory
1517 (p_api_version_number IN NUMBER,
1518 p_INit_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1519 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1520 x_return_status OUT NOCOPY VARCHAR2,
1521 x_msg_count OUT NOCOPY NUMBER,
1522 x_msg_data OUT NOCOPY VARCHAR2,
1523 p_terr_id IN NUMBER);
1524
1525
1526 -- ***************************************************
1527 -- start of comments
1528 -- ***************************************************
1529 -- API name : Create_Terr_Qualifier
1530 -- Type : PUBLIC
1531 -- Function : To create Territories Qualifier and it's Values.
1532 -- Atleast one qualifier value must be passed, other wise, Qualifier can't be created.
1533 -- Pre-reqs :
1534 -- Parameters:
1535 -- IN :
1536 -- Required
1537 -- Parameter Name Data Type Default
1538 -- p_Api_Version_Number NUMBER
1539 -- p_Terr_Qual_Rec Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Tbl
1540 -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
1541 --
1542 -- Optional
1543 -- Parameter Name Data Type Default
1544 -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1545 -- p_Commit VARCHAR2 := FND_API.G_FALSE
1546 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
1547 --
1548 -- OUT :
1549 -- Parameter Name Data Type
1550 -- x_Return_Status VARCHAR2(1)
1551 -- x_Msg_Count NUMBER
1552 -- x_Msg_Data VARCHAR2(2000)
1553 -- x_Terr_Qual_Out_Rec Terr_Qual_Out_Rec_Type,
1554 -- x_Terr_Values_Out_Tbl Terr_Values_Out_Tbl
1555 --
1556 -- End of Comments
1557 --
1558 --
1559 PROCEDURE Create_Terr_qualifier
1560 (
1561 p_Api_Version_Number IN NUMBER,
1562 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1563 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1564 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1565 x_Return_Status OUT NOCOPY VARCHAR2,
1566 x_Msg_Count OUT NOCOPY NUMBER,
1567 x_Msg_Data OUT NOCOPY VARCHAR2,
1568 P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
1569 p_Terr_Values_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
1570 X_Terr_Qual_Out_Rec OUT NOCOPY Terr_Qual_Out_Rec_Type,
1571 x_Terr_Values_Out_Tbl OUT NOCOPY Terr_Values_Out_Tbl_Type
1572 );
1573
1574
1575 -- ***************************************************
1576 -- start of comments
1577 -- ***************************************************
1578 --
1579 -- API name : Delete_Terr_Qualifier
1580 -- Type : PUBLIC
1581 -- Function : To delete Territories Qualifier and its values.
1582 -- Pre-reqs :
1583 -- Parameters:
1584 -- IN :
1585 -- Required
1586 -- Parameter Name Data Type Default
1587 -- p_Api_Version_Number NUMBER
1588 -- P_Terr_Qual_Id NUMBER
1589 --
1590 -- Optional
1591 -- Parameter Name Data Type Default
1592 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1593 -- p_Commit VARCHAR2 FND_API.G_FALSE
1594 --
1595 -- OUT :
1596 -- Parameter Name Data Type
1597 -- p_Return_Status VARCHAR2(1)
1598 -- p_Msg_Count NUMBER
1599 -- p_Msg_Data VARCHAR2(2000)
1600 --
1601 --
1602 -- Notes:
1603 -- Rules for deletion have to be very strict.
1604 --
1605 -- End of Comments
1606 --
1610 p_commit IN VARCHAR2 := fnd_api.g_false,
1607 PROCEDURE Delete_Terr_Qualifier (
1608 p_api_version_number IN NUMBER,
1609 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1611 x_return_status OUT NOCOPY VARCHAR2,
1612 x_msg_count OUT NOCOPY NUMBER,
1613 x_msg_data OUT NOCOPY VARCHAR2,
1614 P_Terr_Qual_Id IN NUMBER
1615 );
1616
1617 -- ***************************************************
1618 -- start of comments
1619 -- ***************************************************
1620 -- API name : Create_Qualifier_Value
1621 -- Type : PUBLIC
1622 -- Function : To create Territory Qualifier Values.
1623 -- Pre-reqs :
1624 -- Parameters:
1625 -- IN :
1626 -- Required
1627 -- Parameter Name Data Type Default
1628 -- p_Api_Version_Number NUMBER
1629 -- p_terr_qual_id NUMBER (Territory Qualifier ID)
1630 -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
1631 --
1632 -- Optional
1633 -- Parameter Name Data Type Default
1634 -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1635 -- p_Commit VARCHAR2 := FND_API.G_FALSE
1636 --
1637 -- OUT NOCOPY :
1638 -- Parameter Name Data Type
1639 -- p_Return_Status VARCHAR2(1)
1640 -- p_Msg_Count NUMBER
1641 -- p_Msg_Data VARCHAR2(2000)
1642 -- p_Terr_Values_Out_Tbl Terr_Values_Out_Tbl
1643 --
1644 -- Notes: Custmer need to verify the validity of the Territory Qualifier Value being passed to the procedure.
1645 -- Example : The city name as 'ADDION', instead of ADDISON, is not validated.
1646 --
1647 -- End of Comments
1648 --
1649 PROCEDURE Create_Qualifier_Value (
1650 p_api_version_number IN NUMBER,
1651 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1652 p_commit IN VARCHAR2 := fnd_api.g_false,
1653 x_return_status OUT NOCOPY VARCHAR2,
1654 x_msg_count OUT NOCOPY NUMBER,
1655 x_msg_data OUT NOCOPY VARCHAR2,
1656 p_terr_qual_id IN NUMBER,
1657 p_terr_values_tbl IN terr_values_tbl_type
1658 := g_miss_terr_values_tbl,
1659 x_terr_values_out_tbl OUT NOCOPY terr_values_out_tbl_type
1660 );
1661 -- ***************************************************
1662 -- start of comments
1663 -- ***************************************************
1664 -- API name : Update_Terr_Value
1665 -- Type : PUBLIC
1666 -- Function : To update existing Territory Qualifier Values
1667 -- Pre-reqs :
1668 -- Parameters:
1669 -- IN :
1670 -- Required
1671 -- Parameter Name Data Type Default
1672 -- p_Api_Version_Number NUMBER
1673 -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
1674 --
1675 -- Optional
1676 -- Parameter Name Data Type Default
1677 -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1678 -- p_Commit VARCHAR2 := FND_API.G_FALSE
1679 --
1680 -- OUT NOCOPY :
1681 -- Parameter Name Data Type
1682 -- p_Return_Status VARCHAR2(1)
1683 -- p_Msg_Count NUMBER
1684 -- p_Msg_Data VARCHAR2(2000)
1685 -- p_Terr_Values_Out_Tbl Terr_Values_Out_Tbl
1686 --
1687 -- Notes: Custmoer need to verify the validity of the Territory Qualifier Value being passed to the procedure.
1688 -- Example : The city name as 'ADDISON', instead of ADDISION, is not validated.
1689 --
1690 -- End of Comments
1691 --
1692 PROCEDURE Update_Qualifier_Value (
1693 p_api_version_number IN NUMBER,
1694 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1695 p_commit IN VARCHAR2 := fnd_api.g_false,
1696 x_return_status OUT NOCOPY VARCHAR2,
1697 x_msg_count OUT NOCOPY NUMBER,
1698 x_msg_data OUT NOCOPY VARCHAR2,
1699 p_terr_values_tbl IN terr_values_tbl_type
1700 := g_miss_terr_values_tbl,
1701 x_terr_values_out_tbl OUT NOCOPY terr_values_out_tbl_type
1702 );
1703
1704 -- ***************************************************
1705 -- start of comments
1706 -- ***************************************************
1707 --
1708 -- API name : Delete_Qualifier_Value
1709 -- Type : PUBLIC
1710 -- Function : To delete a Territoriy Qualifier Value
1711 -- Pre-reqs :
1712 -- Parameters:
1713 -- IN :
1714 -- Required
1715 -- Parameter Name Data Type Default
1716 -- p_Api_Version_Number NUMBER
1717 -- P_Terr_Value_Id NUMBER
1718 --
1719 -- Optional
1720 -- Parameter Name Data Type Default
1721 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1722 -- p_Commit VARCHAR2 FND_API.G_FALSE
1723 --
1724 -- OUT :
1725 -- Parameter Name Data Type
1729 --
1726 -- p_Return_Status VARCHAR2(1)
1727 -- p_Msg_Count NUMBER
1728 -- p_Msg_Data VARCHAR2(2000)
1730 --
1731 -- Notes:
1732 -- Rules for deletion have to be very strict.
1733 --
1734 -- End of Comments
1735 --
1736 PROCEDURE Delete_Qualifier_Value (
1737 p_api_version_number IN NUMBER,
1738 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1739 p_commit IN VARCHAR2 := fnd_api.g_false,
1740 x_return_status OUT NOCOPY VARCHAR2,
1741 x_msg_count OUT NOCOPY NUMBER,
1742 x_msg_data OUT NOCOPY VARCHAR2,
1743 P_Terr_Value_Id IN NUMBER
1744 );
1745
1746
1747 -- ***************************************************
1748 -- start of comments
1749 -- ***************************************************
1750 -- API name : Create_TerrResource
1751 -- Type : PUBLIC
1752 -- Function : To create Territory Resources - which will insert
1753 -- records into jtf_terr_rsc_access_all, jtf_terr_rsc_all
1754 -- tables.
1755 -- If the user doesnot provide resource access records, this procedure
1756 -- inserts the rows into jtf_terr_rsc_access_all for all Transaction Types
1757 -- associated with the territory with access as 'FULL_ACCESS'.
1758 --
1759 -- Pre-reqs :
1760 -- Parameters:
1761 -- IN :
1762 -- Required
1763 -- Parameter Name Data Type Default
1764 -- p_Api_Version_Number NUMBER
1765 -- p_TerrRsc_Tbl TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL
1766 -- p_TerrRsc_Access_Tbl TerrRsc_Access_tbl_type := G_MISS_TERRRSC_ACCESS_TBL
1767 --
1768 -- Optional
1769 -- Parameter Name Data Type Default
1770 -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1771 -- p_Commit VARCHAR2 := FND_API.G_FALSE
1772 --
1773 -- OUT :
1774 -- Parameter Name Data Type
1775 -- x_Return_Status VARCHAR2(1)
1776 -- x_Msg_Count NUMBER
1777 -- x_Msg_Data VARCHAR2(2000)
1778 -- x_TerrRsc_Id NUMBER
1779 -- x_TerrRsc_Out_Tbl TerrResource_out_tbl_type,
1780 -- x_TerrRsc_Access_Out_Tbl TerrRsc_Access_out_tbl_type);
1781 --
1782 -- Notes:
1783 --
1784 --
1785 -- End of Comments
1786 --
1787
1788 /*#
1789 * Use this API to assign resources and their access information to a territory.
1790 * @param p_api_version_number API version number
1791 * @param p_init_msg_list Initialize message array
1792 * @param p_commit Commit after processing transaction
1793 * @param p_terrrsc_tbl Territory resource information like resource, resource group and/or resource role
1794 * @param p_terrrsc_access_tbl Territory resource access information (for example, lead, opportunity, service request)
1795 * @param x_return_status API return status stating success, failure or unexpected error
1796 * @param x_msg_count Number of error messages recorded during processing
1797 * @param x_msg_data Contains message text if msg_count=1
1798 * @param x_terrrsc_out_tbl Territory resource information including the territory resource identifiers
1799 * @param x_terrrsc_access_out_tbl Territory resource access information including the territory resource access identifiers
1800 * @rep:scope public
1801 * @rep:lifecycle active
1802 * @rep:displayname Assign Resources to a Territory
1803 */
1804
1805 PROCEDURE Create_TerrResource
1806 (p_Api_Version_Number IN NUMBER,
1807 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1808 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1809 x_Return_Status OUT NOCOPY VARCHAR2,
1810 x_Msg_Count OUT NOCOPY NUMBER,
1811 x_Msg_Data OUT NOCOPY VARCHAR2,
1812 p_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
1813 p_TerrRsc_Access_Tbl IN TerrRsc_Access_tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
1814 x_TerrRsc_Out_Tbl OUT NOCOPY TerrResource_out_tbl_type,
1815 x_TerrRsc_Access_Out_Tbl OUT NOCOPY TerrRsc_Access_out_tbl_type);
1816
1817 -- ***************************************************
1818 -- start of comments
1819 -- ***************************************************
1820 --
1821 -- API name : Delete_TerrResource
1822 -- Type : PUBLIC
1823 -- Function : To delete Territories - which would also delete
1824 -- records from jtf_terr_rsc_access_all, jtf_terr_rsc_all
1825 -- tables.
1826 --
1827 -- Pre-reqs :
1828 -- Parameters:
1829 -- IN :
1830 -- Required
1831 -- Parameter Name Data Type Default
1832 -- p_Api_Version_Number NUMBER
1833 -- p_TerrRsc_Id NUMBER
1834 --
1835 -- Optional
1836 -- Parameter Name Data Type Default
1837 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1838 -- p_Commit VARCHAR2 FND_API.G_FALSE
1839 --
1840 -- OUT :
1841 -- Parameter Name Data Type
1842 -- p_Return_Status VARCHAR2(1)
1843 -- p_Msg_Count NUMBER
1844 -- p_Msg_Data VARCHAR2(2000)
1845 --
1846 --
1847 -- Notes:
1851 --
1848 -- Rules for deletion have to be very strict.
1849 --
1850 -- End of Comments
1852 PROCEDURE Delete_TerrResource
1853 (p_Api_Version_Number IN NUMBER,
1854 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1855 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1856 x_Return_Status OUT NOCOPY VARCHAR2,
1857 x_Msg_Count OUT NOCOPY NUMBER,
1858 x_Msg_Data OUT NOCOPY VARCHAR2,
1859 p_TerrRsc_Id IN NUMBER);
1860
1861 -- ***************************************************
1862 -- start of comments
1863 -- ***************************************************
1864 -- API name : Update_TerrResource
1865 -- Type : PUBLIC
1866 -- Function : To Update Territory Resources - which will update
1867 -- records into jtf_terr_rsc_access_all, jtf_terr_rsc_all
1868 -- tables.
1869 -- Pre-reqs :
1870 -- Parameters:
1871 -- IN :
1872 -- Required
1873 -- Parameter Name Data Type Default
1874 -- p_Api_Version_Number NUMBER
1875 -- p_TerrRsc_Tbl TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL
1876 -- p_TerrRsc_Access_Tbl TerrRsc_Access_tbl_type := G_MISS_TERRRSC_ACCESS_TBL
1877 --
1878 -- Optional
1879 -- Parameter Name Data Type Default
1880 -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1881 -- p_Commit VARCHAR2 := FND_API.G_FALSE
1882 --
1883 -- OUT NOCOPY :
1884 -- Parameter Name Data Type
1885 -- x_Return_Status VARCHAR2(1)
1886 -- x_Msg_Count NUMBER
1887 -- x_Msg_Data VARCHAR2(2000)
1888 -- x_TerrRsc_Id NUMBER
1889 -- x_TerrRsc_Out_Tbl TerrResource_out_tbl_type,
1890 -- x_TerrRsc_Access_Out_Tbl TerrRsc_Access_out_tbl_type
1891 --
1892 -- Notes:
1893 --
1894 --
1895 -- End of Comments
1896 --
1897 PROCEDURE Update_TerrResource
1898 (p_Api_Version_Number IN NUMBER,
1899 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1900 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1901 x_Return_Status OUT NOCOPY VARCHAR2,
1902 x_Msg_Count OUT NOCOPY NUMBER,
1903 x_Msg_Data OUT NOCOPY VARCHAR2,
1904 p_TerrRsc_Tbl IN TerrResource_tbl_type := G_MISS_TERRRESOURCE_TBL,
1905 p_TerrRsc_Access_Tbl IN TerrRsc_Access_tbl_type := G_MISS_TERRRSC_ACCESS_TBL,
1906 x_TerrRsc_Out_Tbl OUT NOCOPY TerrResource_out_tbl_type,
1907 x_TerrRsc_Access_Out_Tbl OUT NOCOPY TerrRsc_Access_out_tbl_type);
1908
1909
1910 /* THE FOLLOWING 3 RECORD SPECS SHOULD NO LONGER BE USED: THEY
1911 ARE LISTED HERE FOR BACKWARD COMPATIBILITY
1912 */
1913 ---------------------------------------------------------
1914 -- Account record format
1915 -- ---------------------------------------------------
1916 -- Parameters:
1917 -- Required:
1918 -- Defaults:
1919 -- Note:
1920 --
1921 -- End of Comments
1922
1923 TYPE JTF_Account_rec_type IS RECORD
1924 (
1925 CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
1926 POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1927 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1928 PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1929 COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
1930 COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
1931 INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
1932 PRIMARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
1933 SECONDARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
1934 CONTACT_INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
1935 CONTACT_PRIMARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
1936 CONTACT_SECONDARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
1937 PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
1938 AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
1939 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1940 COMP_NAME_RANGE VARCHAR2(360) := FND_API.G_MISS_CHAR,
1941 PARTNER_ID NUMBER := FND_API.G_MISS_NUM,
1942 NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
1943 CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1944 PARTY_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
1945 SIC_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1946 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1947 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1948 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1949 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1950 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1951 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1952 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1953 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1954 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1955 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1956 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1957 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1958 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1962 );
1959 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1960 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
1961 ORG_ID NUMBER := FND_PROFILE.VALUE('ORG_ID')
1963
1964 ---------------------------------------------------------
1965 -- Opportunity record format
1966 -- ---------------------------------------------------
1967 -- Parameters:
1968 -- Required:
1969 -- Defaults:
1970 -- Note:
1971 --
1972 -- End of Comments
1973
1974
1975 TYPE JTF_Oppor_rec_type IS RECORD
1976 ( LEAD_ID NUMBER := FND_API.G_MISS_NUM,
1977 LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
1978 CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
1979 POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1980 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1981 PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1982 COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
1983 COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
1984 INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
1985 PRIMARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
1986 SECONDARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
1987 CONTACT_INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
1988 CONTACT_PRIMARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
1989 CONTACT_SECONDARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
1990 PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
1991 AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
1992 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1993 COMP_NAME_RANGE VARCHAR2(360) := FND_API.G_MISS_CHAR,
1994 PARTNER_ID NUMBER := FND_API.G_MISS_NUM,
1995 NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
1996 CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1997 PARTY_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
1998 SIC_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
1999 TARGET_SEGMENT_CURRENT VARCHAR2(25) := FND_API.G_MISS_CHAR,
2000 TOTAL_AMOUNT NUMBER := FND_API.G_MISS_NUM,
2001 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
2002 PRICING_DATE DATE := FND_API.G_MISS_DATE,
2003 CHANNEL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
2004 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
2005 OPP_INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
2006 OPP_PRIMARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
2007 OPP_SECONDARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
2008 OPCLSS_INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
2009 OPCLSS_PRIMARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
2010 OPCLSS_SECONDARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
2011 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2012 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2013 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2014 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2015 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2016 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2017 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2018 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2019 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2020 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2021 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2022 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2023 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2024 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2025 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2026 ORG_ID NUMBER := FND_PROFILE.VALUE('ORG_ID')
2027 );
2028
2029
2030 ---------------------------------------------------------
2031 -- Lead record format
2032 -- ---------------------------------------------------
2033 -- Parameters:
2034 -- Required:
2035 -- Defaults:
2036 -- Note:
2037 --
2038 -- End of Comments
2039
2040
2041 TYPE JTF_Lead_rec_type IS RECORD
2042 (
2043 SALES_LEAD_ID NUMBER := FND_API.G_MISS_NUM,
2044 SALES_LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
2045 CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
2046 POSTAL_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
2047 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
2048 PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
2049 COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
2050 COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
2051 INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
2052 PRIMARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
2053 SECONDARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
2054 CONTACT_INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
2055 CONTACT_PRIMARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
2056 CONTACT_SECONDARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
2057 PARTY_SITE_ID NUMBER := FND_API.G_MISS_NUM,
2061 PARTNER_ID NUMBER := FND_API.G_MISS_NUM,
2058 AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
2059 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
2060 COMP_NAME_RANGE VARCHAR2(360) := FND_API.G_MISS_CHAR,
2062 NUM_OF_EMPLOYEES NUMBER := FND_API.G_MISS_NUM,
2063 CATEGORY_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
2064 PARTY_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,
2065 SIC_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
2066 BUDGET_AMOUNT NUMBER := FND_API.G_MISS_NUM,
2067 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
2068 PRICING_DATE DATE := FND_API.G_MISS_DATE,
2069 SOURCE_PROMOTION_ID NUMBER := FND_API.G_MISS_NUM,
2070 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
2071 LEAD_INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
2072 LEAD_PRIMARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
2073 LEAD_SECONDARY_INTEREST_ID NUMBER := FND_API.G_MISS_NUM,
2074 PURCHASE_AMOUNT NUMBER := FND_API.G_MISS_NUM,
2075 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2076 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2077 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2078 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2079 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2080 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2081 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2082 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2083 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2084 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2085 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2086 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2087 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2088 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2089 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
2090 ORG_ID NUMBER := FND_PROFILE.VALUE('ORG_ID')
2091 );
2092
2093
2094 --
2095 END JTF_TERRITORY_PUB;