[Home] [Help]
PACKAGE: APPS.JTF_TERRITORY_GET_PUB
Source
1 PACKAGE JTF_TERRITORY_GET_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfptrgs.pls 115.6 2000/05/12 20:34:04 pkm ship $ */
3 -- ---------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_TERRITORY_GET_PUB
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- Joint task force core territory manager private api's.
10 -- This package is a public API for retrieving
11 -- related information from JTF tables.
12 -- It contains specification for pl/sql records and tables
13 -- and the Public territory related API's.
14 --
15 -- Procedures:
16 --
17 --
18 -- NOTES
19 -- This package is available for private use only
20 --
21 -- HISTORY
22 -- 07/15/99 JDOCHERT Created
23 -- 12/22/99 VNEDUNGA Making changes to confirm
24 -- to JTF_TER_RSC_ALL
25 -- 03/20/00 JDOCHERT Added FULL_ACCESS_FLAG to
26 -- Territory Resource record definition
27 --
28 --
29 -- End of Comments
30
31 G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_TERRITORY_GET_PUB';
32 G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtfptrgs.pls';
33
34 G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
35 G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
36
37
38 --*******************************************************
39 -- Composite Types
40 --*******************************************************
41
42 TYPE order_by_rec_type IS RECORD
43 (
44 -- Please define your own sort by record here.
45 TERR_ID NUMBER := FND_API.G_MISS_NUM,
46 TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
47 );
48 TYPE order_by_Tbl_Type IS TABLE OF order_by_rec_type
49 INDEX BY BINARY_INTEGER;
50
51 G_MISS_ORDER_BY_REC order_by_rec_type;
52
53 G_MISS_ORDER_BY_TBL order_by_Tbl_Type;
54
55
56 ---------------------------------------------------------
57 -- Start of Comments
58 ---------------------------------------------------------
59 -- Territory Resource out Record: QualifyingRsc_Rec_Type
60 ---------------------------------------------------------
61 -- Parameters:
62 -- TERR_RSC_ID Territory resource id
63 -- TERR_ID Territory Id
64 -- TERR_NAME Territory Name
65 -- RESOURCE_ID Resource Identifier
66 -- ACCESS_TYPE Access Type
67 -- RESOURCE_TYPE Resource Type Id
68 -- ROLE Resource sub type Id
69 -- PRIMARY_CONTACT_FLAG Falg to identify a resource as primary
70 -- Required:
71 -- Defaults:
72 -- Note:
73 --
74 -- End of Comments
75 TYPE QualifyingRsc_Out_Rec_Type IS RECORD
76 (
77 TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
78 TERR_ID NUMBER := FND_API.G_MISS_NUM,
79 TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
80 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
81 ACCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82 RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
83 ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
84 PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
85 );
86
87 G_MISS_QUALIFYINGRSC_OUT_REC QualifyingRsc_Out_rec_type;
88
89 TYPE QualifyingRsc_out_tbl_type IS TABLE OF QualifyingRsc_out_rec_type
90 INDEX BY BINARY_INTEGER;
91
92 G_MISS_QUALIFYINGRSC_OUT_TBL QualifyingRsc_out_tbl_type;
93
94
95 ---------------------------------------------------------
96 -- Start of Comments
97 ---------------------------------------------------------
98 -- Territory Header out Record: Terr_Header_Rec_Type
99 ---------------------------------------------------------
100 -- Parameters:
101 -- TERR_ID Territory Id
102 -- TERR_NAME Territory Name
103 -- TERR_USAGE Territory Usage
104 -- START_DATE Start Date Effective
105 -- END_DATE End Date Effective
106 -- TEMPLATE_FLAG Template Flag
107 -- ESCALATION_TERRITORY_FLAG Escalation Territory Flag
108 -- PARENT_TERR_NAME Enabled Flag
109 -- TERR_TYPE_NAME Territory Type name
110 -- Required:
111 -- Defaults:
112 -- Note:
113 --
114 -- End of Comments
115 TYPE Terr_Header_Rec_Type IS RECORD (
116 TERR_ID NUMBER := FND_API.G_MISS_NUM,
117 TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
118 TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
120 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
121 TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
122 ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
123 PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
124 TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
125 );
126
127 TYPE Terr_Header_Tbl_Type IS TABLE OF Terr_Header_Rec_Type
128 INDEX BY BINARY_INTEGER;
129
130 G_MISS_TERR_HEADER_REC Terr_Header_Rec_Type;
131
132 G_MISS_TERR_HEADER_TBL Terr_Header_Tbl_Type;
133
134 ---------------------------------------------------------
135 -- Territory Record: Terr_Rec_Type
136 ---------------------------------------------------------
137 TYPE Terr_Rec_Type IS RECORD
138 (
139 TERR_ID NUMBER := FND_API.G_MISS_NUM,
140 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
141 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
142 CREATION_DATE DATE := FND_API.G_MISS_DATE,
143 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
144 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
145 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
146 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
147 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
148 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
149 APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
150 NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR,
151 ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
152 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
153 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
154 PLANNED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155 PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
156 TERRITORY_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
157 TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
158 TEMPLATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
159 ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
160 ESCALATION_TERRITORY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
161 OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
162 RANK NUMBER := FND_API.G_MISS_NUM,
163 DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
164 UPDATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
165 AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
166 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
167 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
168 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
169 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
170 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
171 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
172 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
173 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
174 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
175 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
176 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
177 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
178 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
179 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
180 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
181 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
182 ORG_ID NUMBER := FND_API.G_MISS_NUM
183 , TERR_TYPE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
184 , PARENT_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
185 , ESCALATION_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
186 , TEMPLATE_TERR_NAME VARCHAR2(2000) := FND_API.G_MISS_CHAR
187 , TERR_USG_ID NUMBER := FND_API.G_MISS_NUM
188 , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
189 , TERR_USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
190 );
191
192
193
194 TYPE Terr_Tbl_Type IS TABLE OF Terr_Rec_Type
195 INDEX BY BINARY_INTEGER;
196
197 G_MISS_TERR_REC Terr_Rec_Type;
198
199 G_MISS_TERR_TBL Terr_Tbl_Type;
200
201
202 ---------------------------------------------------------
203 -- Territory Type Record: Terr_Type_Rec_Type
204 ---------------------------------------------------------
205 TYPE TERR_TYPE_REC_TYPE IS RECORD
206 (
207 TERR_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
208 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
209 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
210 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
211 CREATION_DATE DATE := FND_API.G_MISS_DATE,
212 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
213 APPLICATION_SHORT_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
214 NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
215 ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
216 DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR,
217 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
218 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
219 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
220 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
229 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
230 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
231 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
232 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
233 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
234 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
235 ORG_ID NUMBER := FND_API.G_MISS_NUM
236 );
237
238 TYPE Terr_Type_Tbl_Type IS TABLE OF Terr_Type_Rec_Type
239 INDEX BY BINARY_INTEGER;
240
241 G_MISS_TERR_TYPE_REC Terr_Type_Rec_Type;
242
243 G_MISS_TERR_TYPE_TBL Terr_Type_Tbl_Type;
244
245 ---------------------------------------------------------
246 -- Territory Usages Record: Terr_Usgs_Rec_Type
247 ---------------------------------------------------------
248 TYPE Terr_Usgs_Rec_Type IS RECORD
249 (
250 TERR_USG_ID NUMBER := FND_API.G_MISS_NUM,
251 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
252 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
253 CREATION_DATE DATE := FND_API.G_MISS_DATE,
254 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
255 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
256 TERR_ID NUMBER := FND_API.G_MISS_NUM,
257 SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
258 ORG_ID NUMBER := FND_API.G_MISS_NUM
259 , USAGE VARCHAR2(30) := FND_API.G_MISS_CHAR
260 );
261
262 TYPE Terr_Usgs_Tbl_Type IS TABLE OF Terr_Usgs_Rec_Type
263 INDEX BY BINARY_INTEGER;
264
265 G_MISS_TERR_USGS_REC Terr_Usgs_Rec_Type;
266
267 G_MISS_TERR_USGS_TBL Terr_Usgs_Tbl_Type;
268
269
270 -----------------------------------------------------------------------
271 -- Territory Qualifier Type Usages Record: Terr_QType_Usgs_Rec_Type
272 -----------------------------------------------------------------------
273 TYPE Terr_QType_Usgs_Rec_Type IS RECORD
274 (
275 TERR_QTYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
276 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
277 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
278 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
279 CREATION_DATE DATE := FND_API.G_MISS_DATE,
280 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
281 TERR_ID NUMBER := FND_API.G_MISS_NUM,
282 QUAL_TYPE_USG_ID NUMBER := FND_API.G_MISS_NUM,
283 ORG_ID NUMBER := FND_API.G_MISS_NUM
284 , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
285 , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
286 , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
287 , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
288 );
289
290 TYPE Terr_QType_Usgs_Tbl_Type IS TABLE OF Terr_QType_Usgs_Rec_Type
291 INDEX BY BINARY_INTEGER;
292
293 G_MISS_TERR_QTYPE_USGS_REC Terr_QType_Usgs_Rec_Type;
294
295 G_MISS_TERR_QTYPE_USGS_TBL Terr_QType_Usgs_Tbl_Type;
296
297
298 -----------------------------------------------------------------------
299 -- Territory Qualifier Record: Terr_Qual_Rec_Type
300 -----------------------------------------------------------------------
301 TYPE Terr_Qual_Rec_Type IS RECORD
302 (
303 TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
304 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
305 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
306 CREATION_DATE DATE := FND_API.G_MISS_DATE,
307 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
308 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
309 TERR_ID NUMBER := FND_API.G_MISS_NUM,
310 QUAL_USG_ID NUMBER := FND_API.G_MISS_NUM,
311 USE_TO_NAME_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
312 GENERATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
313 OVERLAP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
314 QUALIFIER_MODE VARCHAR(30) := FND_API.G_MISS_CHAR,
315 ORG_ID NUMBER := FND_API.G_MISS_NUM
316 , DISPLAY_TYPE VARCHAR2(40) := FND_API.G_MISS_CHAR
317 , LOV_SQL VARCHAR2(1000) := FND_API.G_MISS_CHAR
318 , CONVERT_TO_ID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
319 , QUAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM
320 , QUALIFIER_TYPE_NAME VARCHAR2(40) := FND_API.G_MISS_CHAR
321 , QUALIFIER_TYPE_DESCRIPTION VARCHAR2(240) := FND_API.G_MISS_CHAR
322 , QUALIFIER_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR
323 );
324
325 TYPE Terr_Qual_Tbl_Type IS TABLE OF Terr_Qual_Rec_Type
329
326 INDEX BY BINARY_INTEGER;
327
328 G_MISS_TERR_QUAL_REC Terr_Qual_Rec_Type;
330 G_MISS_TERR_QUAL_TBL Terr_Qual_Tbl_Type;
331
332
333
334 -----------------------------------------------------------------------
335 -- Territory Values Record: Terr_Values_Rec_Type
336 -----------------------------------------------------------------------
337 TYPE Terr_Values_Rec_Type IS RECORD
338 (
339 TERR_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
340 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
341 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
342 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
343 CREATION_DATE DATE := FND_API.G_MISS_DATE,
344 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
345 TERR_QUAL_ID NUMBER := FND_API.G_MISS_NUM,
346 INCLUDE_FLAG VARCHAR2(15) := FND_API.G_MISS_CHAR,
347 COMPARISON_OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR,
348 ID_USED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
349 LOW_VALUE_CHAR_ID NUMBER := FND_API.G_MISS_NUM,
350 LOW_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
351 HIGH_VALUE_CHAR VARCHAR2(60) := FND_API.G_MISS_CHAR,
352 LOW_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
353 HIGH_VALUE_NUMBER NUMBER := FND_API.G_MISS_NUM,
354 VALUE_SET NUMBER := FND_API.G_MISS_NUM,
355 INTEREST_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
356 PRIMARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
357 SECONDARY_INTEREST_CODE_ID NUMBER := FND_API.G_MISS_NUM,
358 CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR,
359 ORG_ID NUMBER := FND_API.G_MISS_NUM
360 );
361
362 TYPE Terr_Values_Tbl_Type IS TABLE OF Terr_Values_Rec_Type
363 INDEX BY BINARY_INTEGER;
364
365 G_MISS_TERR_VALUES_REC Terr_Values_Rec_Type;
366
367 G_MISS_TERR_VALUES_TBL Terr_Values_Tbl_Type;
368
369
370 -----------------------------------------------------------------------
371 -- Territory Resources Record: Terr_Resources_Rec_Type
372 -----------------------------------------------------------------------
373 TYPE Terr_Rsc_Rec_Type IS RECORD
374 (
375 TERR_RSC_ID NUMBER := FND_API.G_MISS_NUM,
376 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
377 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
378 CREATION_DATE DATE := FND_API.G_MISS_DATE,
379 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
380 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
381 TERR_ID NUMBER := FND_API.G_MISS_NUM,
382 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
383 RESOURCE_TYPE VARCHAR2(60) := FND_API.G_MISS_CHAR,
384 ROLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
385 PRIMARY_CONTACT_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
386 START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
387 END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
388 FULL_ACCESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
389 ORG_ID NUMBER := FND_API.G_MISS_NUM
390 , RESOURCE_NAME VARCHAR2(573) := FND_API.G_MISS_CHAR
391 );
392
393 TYPE Terr_Rsc_Tbl_Type IS TABLE OF Terr_Rsc_Rec_Type
394 INDEX BY BINARY_INTEGER;
395
396 G_MISS_TERR_RSC_REC Terr_Rsc_Rec_Type;
397
398 G_MISS_TERR_RSC_TBL Terr_Rsc_Tbl_Type;
399
400
401
402 -- ***************************************************
403 -- start of comments
404 -- ***************************************************
405 --
406 -- API name : Get_Territory_Header
407 -- Type : PUBLIC
408 -- Function : To get a list of territory headers
409 --
410 --
411 -- Pre-reqs :
412 -- Parameters:
413 -- IN :
414 -- Required
415 -- Parameter Name Data Type Default
416 -- p_Api_Version_Number NUMBER
417 --
418 -- Optional
419 -- Parameter Name Data Type Default
420 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
421 -- p_terr_rec Terr_Rec_Type G_MISS_TERR_REC
422 -- p_terr_type_rec Terr_Type_Rec_Type G_MISS_TERR_TYPE_REC
423 -- p_terr_usg_rec Terr_Usgs_Rec_Type G_MISS_TERR_USGS_REC
424 -- p_terr_rsc_rec Terr_Rsc_Rec_Type G_MISS_TERR_RSC_REC
425 -- p_terr_qual_tbl Terr_Qual_Tbl_Type G_MISS_TERR_QUAL_TBL
426 -- p_terr_values_tbl Terr_Values_Tbl_Type G_MISS_TERR_VALUES_TBL
427 -- p_order_by_rec order_by_rec_type G_MISS_ORDER_BY_REC
428 -- p_return_all_rec VARCHAR2 FND_API.G_FALSE
429 -- p_num_rec_requested NUMBER 30
430 -- p_start_rec_num NUMBER 1
431 --
432 -- OUT :
433 -- Parameter Name Data Type
434 -- x_Return_Status VARCHAR2(1)
435 -- x_Msg_Count NUMBER
436 -- x_Msg_Data VARCHAR2(2000)
437 -- x_terr_header_tbl Terr_Header_Tbl_Type
438 -- x_num_rec_returned NUMBER
439 -- x_next_rec_num NUMBER
443 -- Notes:
440 -- x_total_num_rec NUMBER
441 --
442 --
444 --
445 --
446 -- End of Comments
447 --
448 PROCEDURE Get_Territory_Header (
449 p_Api_Version IN NUMBER,
450 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
451 x_return_status OUT VARCHAR2,
452 x_msg_count OUT NUMBER,
453 x_msg_data OUT VARCHAR2,
454 p_terr_rec IN Terr_Rec_Type := G_MISS_TERR_REC,
455 p_terr_type_rec IN Terr_Type_Rec_Type := G_MISS_TERR_TYPE_REC,
456 p_terr_usg_rec IN Terr_Usgs_Rec_Type := G_MISS_TERR_USGS_REC,
457 p_terr_rsc_rec IN Terr_Rsc_Rec_Type := G_MISS_TERR_RSC_REC,
458 p_terr_qual_tbl IN Terr_Qual_Tbl_Type := G_MISS_TERR_QUAL_TBL,
459 p_terr_values_tbl IN Terr_Values_Tbl_Type := G_MISS_TERR_VALUES_TBL,
460 p_order_by_rec IN order_by_rec_type := G_MISS_ORDER_BY_REC,
461 p_return_all_rec IN VARCHAR2 := FND_API.G_FALSE,
462 p_num_rec_requested IN NUMBER := 30,
463 p_start_rec_num IN NUMBER := 1,
464 x_terr_header_tbl OUT Terr_Header_Tbl_Type,
465 x_num_rec_returned OUT NUMBER,
466 x_next_rec_num OUT NUMBER,
467 x_total_num_rec OUT NUMBER
468 );
469
470
471 -- ***************************************************
472 -- start of comments
473 -- ***************************************************
474 --
475 -- API name : Get_Territory_Details
476 -- Type : PUBLIC
477 -- Function : To get a territory's details
478 --
479 --
480 -- Pre-reqs :
481 -- Parameters:
482 -- IN :
483 -- Required
484 -- Parameter Name Data Type Default
485 -- p_Api_Version_Number NUMBER
486 -- p_terr_id NUMBER FND_API.G_MISS_NUM
487 --
488 -- Optional
489 -- Parameter Name Data Type Default
490 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
491 --
492 -- OUT :
493 -- Parameter Name Data Type
494 -- x_Return_Status VARCHAR2(1)
495 -- x_Msg_Count NUMBER
496 -- x_Msg_Data VARCHAR2(2000)
497 -- x_terr_rec Terr_Rec_Type
498 -- x_terr_type_rec Terr_Type_Rec_Type
499 -- x_terr_sub_terr_tbl Terr_Tbl_Type
500 -- x_terr_usgs_tbl Terr_Usgs_Tbl_Type
501 -- x_terr_qtype_usgs_tbl Terr_QType_Usgs_Tbl_Type
502 -- x_terr_qual_tbl Terr_Qual_Tbl_Type
503 -- x_terr_values_tbl Terr_Values_Tbl_Type
504 -- x_terr_rsc_tbl Terr_Rsc_Tbl_Type
505 --
506 --
507 -- Notes:
508 --
509 --
510 -- End of Comments
511 --
512 PROCEDURE Get_Territory_Details (
513 p_Api_Version IN NUMBER,
514 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
515 x_return_status OUT VARCHAR2,
516 x_msg_count OUT NUMBER,
517 x_msg_data OUT VARCHAR2,
518 p_terr_id IN NUMBER := FND_API.G_MISS_NUM,
519 x_terr_rec OUT Terr_Rec_Type,
520 x_terr_type_rec OUT Terr_Type_Rec_Type,
521 x_terr_sub_terr_tbl OUT Terr_Tbl_Type,
522 x_terr_usgs_tbl OUT Terr_Usgs_Tbl_Type,
523 x_terr_qtype_usgs_tbl OUT Terr_QType_Usgs_Tbl_Type,
524 x_terr_qual_tbl OUT Terr_Qual_Tbl_Type,
525 x_terr_values_tbl OUT Terr_Values_Tbl_Type,
526 x_terr_rsc_tbl OUT Terr_Rsc_Tbl_Type
527 );
528
529 -- ***************************************************
530 -- start of comments
531 -- ***************************************************
532 --
533 -- API name : Get_Escalation_Territory
534 -- Type : PUBLIC
535 -- Function : To get a territory's escalation territory
536 --
537 --
538 -- Pre-reqs :
539 -- Parameters:
540 -- IN :
541 -- Required
542 -- Parameter Name Data Type Default
543 -- p_Api_Version_Number NUMBER
544 -- p_Escalation_Terr_Id NUMBER
545 --
546 -- Optional
547 -- Parameter Name Data Type Default
548 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
549 -- p_Commit VARCHAR2 FND_API.G_FALSE
550 --
551 -- OUT :
552 -- Parameter Name Data Type
553 -- x_Return_Status VARCHAR2(1)
554 -- x_Msg_Count NUMBER
555 -- x_Msg_Data VARCHAR2(2000)
556 --
557 --
558 -- Notes:
559 --
560 --
561 -- End of Comments
562 --
563 PROCEDURE Get_Escalation_Territory (
564 p_Api_Version IN NUMBER,
565 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
566 x_return_status OUT VARCHAR2,
570 x_escalation_terr_id OUT NUMBER
567 x_msg_count OUT NUMBER,
568 x_msg_data OUT VARCHAR2,
569 p_terr_id IN NUMBER := FND_API.G_MISS_NUM,
571 );
572
573
574 -- ***************************************************
575 -- start of comments
576 -- ***************************************************
577 --
578 -- API name : Get_Parent_Territory
579 -- Type : PUBLIC
580 -- Function : To get a territory's parent territory
581 --
582 --
583 -- Pre-reqs :
584 -- Parameters:
585 -- IN :
586 -- Required
587 -- Parameter Name Data Type Default
588 -- p_Api_Version_Number NUMBER
589 -- p_Parent_Terr_Id NUMBER
590 --
591 -- Optional
592 -- Parameter Name Data Type Default
593 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
594 -- p_Commit VARCHAR2 FND_API.G_FALSE
595 --
596 -- OUT :
597 -- Parameter Name Data Type
598 -- x_Return_Status VARCHAR2(1)
599 -- x_Msg_Count NUMBER
600 -- x_Msg_Data VARCHAR2(2000)
601 --
602 --
603 -- Notes:
604 --
605 --
606 -- End of Comments
607 --
608 PROCEDURE Get_Parent_Territory (
609 p_Api_Version IN NUMBER,
610 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
611 x_return_status OUT VARCHAR2,
612 x_msg_count OUT NUMBER,
613 x_msg_data OUT VARCHAR2,
614 p_terr_id IN NUMBER := FND_API.G_MISS_NUM,
615 x_parent_terr_id OUT NUMBER
616 );
617
618
619 --
620 -- ***************************************************
621 -- start of comments
622 -- ***************************************************
623 --
624 -- API name : Get_Escalation_TerrMembers
625 -- Type : PUBLIC
626 -- Function : To get reosurces attached with a escalation
627 -- territory
628 --
629 --
630 -- Pre-reqs :
631 -- Parameters:
632 -- IN :
633 -- Required
634 -- Parameter Name Data Type Default
635 -- p_Api_Version_Number NUMBER
636 -- p_Terr_Id NUMBER
637 --
638 -- Optional
639 -- Parameter Name Data Type Default
640 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
641 -- p_Commit VARCHAR2 FND_API.G_FALSE
642 --
643 -- OUT :
644 -- Parameter Name Data Type
645 -- x_Return_Status VARCHAR2(1)
646 -- x_Msg_Count NUMBER
647 -- x_Msg_Data VARCHAR2(2000)
648 --
649 --
650 -- Notes:
651 --
652 --
653 -- End of Comments
654 --
655 PROCEDURE Get_Escalation_TerrMembers
656 (p_api_version_number IN NUMBER,
657 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
658 p_commit IN VARCHAR2 := FND_API.G_FALSE,
659 x_return_status OUT VARCHAR2,
660 x_msg_count OUT NUMBER,
661 x_msg_data OUT VARCHAR2,
662 p_terr_id IN NUMBER,
663 x_QualifyingRsc_out_tbl OUT QualifyingRsc_out_tbl_type);
664
665 End JTF_TERRITORY_GET_PUB; -- end package specification