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