[Home] [Help]
PACKAGE: APPS.JTF_TERRITORY_PVT
Source
1 Package JTF_TERRITORY_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvters.pls 120.5 2011/05/11 17:58:10 srguntur ship $ */
3 -- ---------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_TERRITORY_PVT
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- Joint task force core territory manager private api's.
10 -- This package is a public API for inserting territory
11 -- related information IN to information into JTF tables.
12 -- It contains specification for pl/sql records and tables
13 -- and the private territory related API's.
14 --
15 -- Procedures:
16 -- (see below for specification)
17 --
18 -- NOTES
19 -- This package is for private use
20 --
21 -- HISTORY
22 -- 06/09/99 VNEDUNGA Created
23 -- 07/15/99 JDOCHERT Updated existing APIs and
24 -- added new APIs
25 -- 06/09/99 VNEDUNGA Commenting OUT NOCOPY FND_G_MISS for records def
26 -- because of the bug in forms PL/SQL
27 -- 01/31/00 VNEDUNGA Adding code for overlap check
28 -- 03/15/00 VNEDUNGA Changing the some validation routine specs
29 -- 04/04/00 EIHSU Added Gen_Duplicate_Territory and relevant procs
30 -- 06/14/00 VNEDUNGA Changing the overlap exists function and
31 -- added rownum < 2 to function to return desc
32 -- 07/08/00 JDOCHERT Adding default values for flag, for data migration
33 -- 09/09/00 jdochert Added Unique validation for JTF_TERR_USGS_ALL + JTF_TERR_QTYPE_USGS_AL
34 -- 09/17/00 JDOCHERT BUG# 1408610 FIX: Added NUM_WINNERS to TERR_ALL_REC_TYPE
35 -- 10/04/00 jdochert Added validation for NUM_WINNERS
36 -- 10/04/00 jdochert Added NUM_QUAL to JTF_TERR_ALL_REC_TYPE record definition
37 -- 10/04/01 arpatel Added first_terr_node flag to Copy Territory
38 -- 04/12/01 jdochert Added PROCEDURE chk_num_copy_terr
39 -- 04/20/01 arpatel Added PROCEDURE Concurrent_Copy_Territory and Write_Log
40 -- 04/28/01 arpatel Added function conc_req_copy_terr returning number (concurrent request ID)
41 -- 12/03/04 achanda Added value4_id : bug # 3726007
42 --
43 -- End of Comments
44 --
45 --*******************************************************
46 -- Composite Types
47 --*******************************************************
48 --
49 -- Start of Comments
50 ---------------------------------------------------------
51
52 -- Winning Territory Record: WinningTerr_rec_type
53 -- ---------------------------------------------------
54 -- Parameters:
55 -- Required:
56 -- Defaults:
57 -- Note:
58 --
59 -- End of Comments
60
61 TYPE WinningTerr_rec_type IS RECORD
62 (
63 TERR_ID NUMBER := FND_API.G_MISS_NUM,
64 RANK VARCHAR2(30) := FND_API.G_MISS_CHAR,
65 ORG_ID NUMBER := FND_API.G_MISS_NUM,
66 PARENT_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
67 TEMPLATE_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
68 ESCALATION_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM
69 );
70
71 G_MISS_WINNINGTERR_REC WinningTerr_rec_type;
72
73 TYPE WinningTerr_tbl_type IS TABLE OF WinningTerr_rec_type
74 INDEX BY BINARY_INTEGER;
75
76 G_MISS_WINNINGTERR_TBL WinningTerr_tbl_type;
77
78
79 -- ***************************************************
80 -- Start of Comments
81 -- ---------------------------------------------------
82 -- Territory record type: Terr_All_Rec_Type
83 -- ---------------------------------------------------
84 -- Attributes:
85 -- TERR_ID
86 -- LAST_UPDATE_DATE
87 -- LAST_UPDATED_BY
88 -- CREATION_DATE
89 -- CREATED_BY
90 -- LAST_UPDATE_LOGIN
91 -- APPLICATION_SHORT_NAME
92 -- NAME
93 -- ENABLED_FLAG
94 -- REQUEST_ID
95 -- PROGRAM_APPLICATION_ID
96 -- PROGRAM_ID
97 -- PROGRAM_UPDATE_DATE
98 -- START_DATE_ACTIVE
99 -- RANK
100 -- END_DATE_ACTIVE
101 -- DESCRIPTION
102 -- ORG_ID
103 -- UPDATE_FLAG
104 -- AUTO_ASSIGN_MEMBERS_FLAG
105 -- PLANNED_FLAG
106 -- TERRITORY_TYPE_ID
107 -- PARENT_TERRITORY_ID
108 -- TEMPLATE_FLAG
109 -- TEMPLATE_TERRITORY_ID
110 -- ESCALATION_TERRITORY_FLAG
111 -- ESCALATION_TERRITORY_ID
112 -- OVERLAp_ALLOWED_FLAG
113 -- ATTRIBUTE_CATEGORY
114 -- ATTRIBUTE1
115 -- ATTRIBUTE2
116 -- ATTRIBUTE3
117 -- ATTRIBUTE4
118 -- ATTRIBUTE5
119 -- ATTRIBUTE6
120 -- ATTRIBUTE7
121 -- ATTRIBUTE8
122 -- ATTRIBUTE9
123 -- ATTRIBUTE10
124 -- ATTRIBUTE11
125 -- ATTRIBUTE12
126 -- ATTRIBUTE13
127 -- ATTRIBUTE14
128 -- ATTRIBUTE15
129 -- NUM_WINNERS
130 -- NUM_QUAL
131 --
132 -- Notes
133 --
134 --
135 -- End of Comments
136 --
137 TYPE Terr_All_Rec_Type IS RECORD
138 (TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
139 LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
140 LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
141 CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
142 CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
143 LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
144 APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
145 NAME VARCHAR2(2000) , -- := FND_API.G_MISS_CHAR,
146 ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
147 REQUEST_ID NUMBER , -- := FND_API.G_MISS_NUM,
148 PROGRAM_APPLICATION_ID NUMBER , -- := FND_API.G_MISS_NUM,
149 PROGRAM_ID NUMBER , -- := FND_API.G_MISS_NUM,
150 PROGRAM_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
151 START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
152 RANK NUMBER , -- := FND_API.G_MISS_NUM,
153 END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
154 DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
155 UPDATE_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
156 AUTO_ASSIGN_RESOURCES_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
157 PLANNED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
158 TERRITORY_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
159 PARENT_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
160 TEMPLATE_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
161 TEMPLATE_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
162 ESCALATION_TERRITORY_FLAG VARCHAR2(1) := 'N', -- := FND_API.G_MISS_CHAR,
163 ESCALATION_TERRITORY_ID NUMBER , -- := FND_API.G_MISS_NUM,
164 OVERLAp_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
165 ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
166 ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
167 ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
168 ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
169 ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
170 ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
171 ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
172 ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
173 ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
174 ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
175 ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
176 ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
177 ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
178 ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
179 ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
180 ATTRIBUTE15 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR
181 ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
182 NUM_WINNERS NUMBER,
183 NUM_QUAL NUMBER := 0,
184 TERR_CREATION_FLAG VARCHAR2(1) := NULL,
185 TERRITORY_GROUP_ID NUMBER :=NULL
186 );
187
188 TYPE Terr_All_Tbl_Type IS TABLE OF Terr_All_Rec_Type
189 INDEX BY BINARY_INTEGER;
190
191 G_MISS_Terr_All_Rec Terr_All_Rec_Type;
192
193 G_MISS_Terr_All_Tbl Terr_All_Tbl_Type;
194
195 -- ***************************************************
196 -- Start of Comments
197 -- ---------------------------------------------------
198 --
199 -- Terr_Qual_Rec_Type
200 -- Attributes:
201 -- TERR_QUAL_ID
202 -- TERR_ID
203 -- SEEDED_QUAL_ID
204 -- LAST_UPDATE_DATE
205 -- LAST_UPDATED_BY
206 -- CREATION_DATE
207 -- CREATED_BY
208 -- LAST_UPDATE_LOGIN
209 -- GENERATE_FLAG
210 -- NAME_FLAG
211 -- OVERLAp_ALLOWED_FLAG
212 --
213 -- Notes
214 --
215 --
216 -- End of Comments
217 --
218 TYPE Terr_Qual_Rec_Type IS RECORD
219 ( Rowid VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
220 TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
221 LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
222 LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
223 CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
224 CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
225 LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
226 TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
227 QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
228 USE_TO_NAME_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
229 GENERATE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
230 OVERLAP_ALLOWED_FLAG VARCHAR2(1) := 'Y', -- := FND_API.G_MISS_CHAR,
231 QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
232 ORG_ID NUMBER -- := FND_API.G_MISS_NUM
233 );
234
235 TYPE Terr_Qual_Tbl_Type IS TABLE OF Terr_Qual_Rec_Type
236 INDEX BY BINARY_INTEGER;
237
238 G_MISS_Terr_Qual_Rec Terr_Qual_Rec_Type;
239
240 G_MISS_Terr_Qual_Tbl Terr_Qual_Tbl_Type;
241
242 -- ***************************************************
243 -- Start of Comments
244 -- ---------------------------------------------------
245 -- Territory values record type: Terr_Values_Rec_Type
246 -- ---------------------------------------------------
247 -- Attributes:
248 -- TERR_VALUE_ID
249 -- LAST_UPDATE_DATE
250 -- LAST_UPDATED_BY
251 -- CREATION_DATE
252 -- CREATED_BY
253 -- LAST_UPDATE_LOGIN
254 -- TERR_QUAL_ID
255 -- INCLUDE_FLAG
256 -- COMPARISON_OPERATOR
257 -- LOW_VALUE_CHAR
258 -- HIGH_VALUE_CHAR
259 -- LOW_VALUE_NUMBER
260 -- HIGH_VALUE_NUMBER
261 -- INTEREST_TYPE_ID
262 -- PRIMARY_INTEREST_CODE_ID
263 -- SECONDARY_INTEREST_CODE_ID
264 -- ORG_ID
265 -- CURRENCY_CODE
266 -- VALUE_SET
267 --
268 --
269 -- Notes
270 --
271 --
272 -- End of Comments
273 --
274 TYPE Terr_Values_Rec_Type IS RECORD
275 (TERR_VALUE_ID NUMBER , -- := FND_API.G_MISS_NUM,
276 LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
277 LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
278 CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
279 CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
280 LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
281 TERR_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
282 INCLUDE_FLAG VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
283 COMPARISON_OPERATOR VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
284 LOW_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
285 HIGH_VALUE_CHAR VARCHAR2(360) , -- := FND_API.G_MISS_CHAR,
286 LOW_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
287 HIGH_VALUE_NUMBER NUMBER , -- := FND_API.G_MISS_NUM,
288 VALUE_SET NUMBER , -- := FND_API.G_MISS_NUM,
289 INTEREST_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
290 PRIMARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
291 SECONDARY_INTEREST_CODE_ID NUMBER , -- := FND_API.G_MISS_NUM,
292 CURRENCY_CODE VARCHAR2(15) , -- := FND_API.G_MISS_CHAR,
293 ID_USED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
294 LOW_VALUE_CHAR_ID NUMBER , -- := FND_API.G_MISS_NUM,
295 QUALIFIER_TBL_INDEX NUMBER , -- := FND_API.G_MISS_NUM,
296 ORG_ID NUMBER , -- := FND_API.G_MISS_NUM
297 CNR_GROUP_ID NUMBER ,
298 VALUE1_ID NUMBER ,
299 VALUE2_ID NUMBER ,
300 VALUE3_ID NUMBER ,
301 VALUE4_ID NUMBER
302 );
303
304 TYPE Terr_Values_Tbl_Type IS TABLE OF Terr_Values_Rec_Type
305 INDEX BY BINARY_INTEGER;
306
307 G_MISS_Terr_Values_Rec Terr_Values_Rec_Type;
308
309 G_MISS_Terr_Values_Tbl Terr_Values_Tbl_Type;
310
311
312 -- ***************************************************
313 -- Start of Comments
314 -- ---------------------------------------------------
315 -- Territory source Record: terr_Usgs_rec_type
316 -- ---------------------------------------------------
317 -- Parameters:
318 --
319 -- Required:
320 -- TERR_USG_ID -- primary key sequence
321 -- SOURCE_ID -- Source identifier
322 -- TERR_ID -- Territory identifier
323 -- LAST_UPDATE_DATE -- Part of std who columns
324 -- LAST_UPDATED_BY -- Part of std who columns
325 -- CREATION_DATE -- Part of std who columns
326 -- CREATED_BY -- Part of std who columns
327 -- LAST_UPDATE_LOGIN -- Part of std who columns
328 --
329 -- Defaults:
330 -- Note:
331 --
332 -- End of Comments
333
334 TYPE terr_usgs_rec_type IS RECORD
335 (
336 TERR_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
337 SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
338 TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
339 LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
340 LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
341 CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
342 CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
343 LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
344 ORG_ID NUMBER -- := FND_API.G_MISS_NUM
345
346 );
347
351 INDEX BY BINARY_INTEGER;
348 G_MISS_TERR_USGS_REC terr_usgs_rec_type;
349
350 TYPE terr_usgs_tbl_type IS TABLE OF terr_usgs_rec_type
352
353 G_MISS_TERR_USGS_TBL terr_usgs_tbl_type;
354
355
356 -- *************************************************************
357 -- Start of Comments
358 -- -------------------------------------------------------------
359 -- Territory qualifier Type Record: TerrQualTypeUsgs_rec_type
360 -- -------------------------------------------------------------
361 -- Parameters:
362 --
363 -- Required:
364 -- TYPE_QUAL_TYPE_USG_ID -- Primary Key sequence
365 -- TERR_TYPE_USG_ID -- Source source id
366 -- QUAL_TYPE_USG_ID -- Type identifier
367 -- LAST_UPDATE_DATE -- Part of std who columns
368 -- LAST_UPDATED_BY -- Part of std who columns
369 -- CREATION_DATE -- Part of std who columns
370 -- CREATED_BY -- Part of std who columns
371 -- LAST_UPDATE_LOGIN -- Part of std who columns
372 --
373 -- Defaults:
374 -- Note:
375 --
376 -- End of Comments
377
378 TYPE terr_qualtypeusgs_rec_type IS RECORD
379 (
380 TERR_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
381 TERR_ID NUMBER , -- := FND_API.G_MISS_NUM,
382 QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
383 LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
384 LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
385 CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
386 CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
387 LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
388 ORG_ID NUMBER -- := FND_API.G_MISS_NUM
389 );
390
391 G_MISS_TERR_QUALTYPEUSGS_REC terr_qualtypeusgs_rec_type;
392
393 TYPE terr_qualtypeusgs_tbl_type IS TABLE OF terr_qualtypeusgs_rec_type
394 INDEX BY BINARY_INTEGER;
395
396 G_MISS_TERR_QUALTYPEUSGS_TBL Terr_QualTypeUsgs_tbl_type;
397
398
399 -- ***********************************************************
400 -- Start of Comments
401 -- -----------------------------------------------------------
402 -- Territory OUT NOCOPY Record: terr_all_out_rec
403 -- -----------------------------------------------------------
404 -- Parameters:
405 --
406 -- Required:
407 -- Defaults:
408 -- Note:
409 --
410 -- End of Comments
411
412 TYPE terr_all_out_rec_type IS RECORD
413 (
414 TERR_ID NUMBER ,--:= FND_API.G_MISS_NUM,
415 RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
416 );
417
418 G_MISS_TERR_ALL_OUT_REC terr_all_out_rec_type;
419
420
421 TYPE Terr_All_out_tbl_type IS TABLE OF terr_all_out_rec_type
422 INDEX BY BINARY_INTEGER;
423
424 G_MISS_TERR_ALL_OUT_TBL Terr_All_out_tbl_type;
425
426
427 -- ***********************************************************
428 -- Start of Comments
429 -- -----------------------------------------------------------
430 -- Territory usages OUT NOCOPY Record: terr_usgs_out_rec_type
431 -- -----------------------------------------------------------
432 -- Parameters:
433 --
434 -- Required:
435 -- Defaults:
436 -- Note:
437 --
438 -- End of Comments
439
440 TYPE Terr_Usgs_out_rec_type IS RECORD
441 (
442 TERR_USG_ID NUMBER ,--:= FND_API.G_MISS_NUM,
443 RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
444 );
445
446 G_MISS_TERR_USGS_OUT_REC terr_usgs_out_rec_type;
447
448 TYPE Terr_Usgs_out_tbl_type IS TABLE OF terr_usgs_out_rec_type
449 INDEX BY BINARY_INTEGER;
450 G_MISS_TERR_USGS_OUT_TBL Terr_Usgs_out_tbl_type;
451
452
453 -- ****************************************************************
454 -- Start of Comments
455 -- ----------------------------------------------------------------
456 -- Territory qualifier type OUT NOCOPY Record: terr_QualTypeUsgs_out_rec
457 -- ----------------------------------------------------------------
458 -- Parameters:
459 --
460 -- Required:
461 -- Defaults:
462 -- Note:
463 --
464 -- End of Comments
465
466 TYPE terr_QualTypeUsgs_out_rec_type IS RECORD
467 (
468 TERR_QUAL_TYPE_USG_ID NUMBER ,--:= FND_API.G_MISS_NUM,
469 RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
470 );
471
472 G_MISS_TERRQUALTYPUSGS_OUT_REC terr_QualTypeUsgs_out_rec_type;
473
474 TYPE Terr_QualTypeUsgs_Out_Tbl_Type IS TABLE OF terr_QualTypeUsgs_out_rec_type
475 INDEX BY BINARY_INTEGER;
476 G_MISS_TERRQUALTYPUSGS_OUT_TBL Terr_QualTypeUsgs_Out_Tbl_Type;
477
478 -- ***********************************************************
479 -- Start of Comments
480 -- -----------------------------------------------------------
484 --
481 -- Territory qualifiers OUT NOCOPY Record: terr_Oual_out_rec_Type
482 -- -----------------------------------------------------------
483 -- Parameters:
485 -- Required:
486 -- Defaults:
487 -- Note:
488 --
489 -- End of Comments
490
491 TYPE Terr_Qual_out_rec_type IS RECORD
492 (
493 TERR_QUAL_ID NUMBER ,--:= FND_API.G_MISS_NUM,
494 RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
495 );
496
497 G_MISS_TERR_QUAL_OUT_REC Terr_Qual_out_rec_type;
498
499 TYPE Terr_Qual_out_tbl_type IS TABLE OF Terr_Qual_out_rec_type
500 INDEX BY BINARY_INTEGER;
501 G_MISS_TERR_QUAL_OUT_TBL Terr_Qual_Out_tbl_type;
502
503
504 -- ***********************************************************
505 -- Start of Comments
506 -- -----------------------------------------------------------
507 -- Territory values OUT NOCOPY Record: terr_values_out_rec_type
508 -- -----------------------------------------------------------
509 -- Parameters:
510 --
511 -- Required:
512 -- Defaults:
513 -- Note:
514 --
515 -- End of Comments
516
517 TYPE Terr_Values_out_rec_type IS RECORD
518 (
519 TERR_VALUE_ID NUMBER ,-- := FND_API.G_MISS_NUM,
520 RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR
521 );
522
523 G_MISS_TERR_VALUES_OUT_REC terr_values_out_rec_type;
524
525
526 TYPE Terr_Values_out_tbl_type IS TABLE OF terr_values_out_rec_type
527 INDEX BY BINARY_INTEGER;
528
529 G_MISS_TERR_VALUES_OUT_TBL Terr_Values_out_tbl_type;
530
531
532 -- ***************************************************
533 -- start of comments
534 -- ***************************************************
535 -- API name : Create_Territory
536 -- Type : PUBLIC
537 -- Function : To create Territories - which inludes the creation of following
538 -- Territory Header, Territory Qualifier, terr Usages, qualifier type usages
539 -- Territory Qualifier Values and Assign Resources
540 -- Pre-reqs :
541 -- Parameters:
542 -- IN :
543 -- Required
544 -- Parameter Name Data Type Default
545 -- p_Api_Version_Number NUMBER
546 -- p_Terr_All_Rec Terr_All_Rec_Type := G_Miss_Terr_All_Rec
547 -- p_Terr_Usgs_Tbl Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl
548 -- p_Terr_QualTypeUsgs_Tbl Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl
549 -- p_Terr_Qual_Tbl Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl
550 -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
551 --
552 -- Optional
553 -- Parameter Name Data Type Default
554 -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
555 -- p_Commit VARCHAR2 := FND_API.G_FALSE
556 --
557 -- OUT NOCOPY :
558 -- Parameter Name Data Type
559 -- x_Return_Status VARCHAR2(1)
560 -- x_Msg_Count NUMBER
561 -- x_Msg_Data VARCHAR2(2000)
562 -- x_Terr_Id NUMBER
563 -- x_Terr_Usgs_Out_Tbl Terr_Usgs_Out_Tbl,
564 -- x_Terr_QualTypeUsgs_Out_Tbl Terr_QualTypeUsgs_Out_Tbl,
565 -- x_Terr_Qual_Out_Tbl Terr_Qual_Out_Tbl,
566 -- x_Terr_Values_Out_Tbl Terr_Values_Out_Tbl
567 --
568 --
569 -- Notes:
570 --
571 --
572 -- End of Comments
573 --
574 PROCEDURE Create_Territory
575 (p_Api_Version_Number IN NUMBER,
576 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
577 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
578 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579 x_Return_Status OUT NOCOPY VARCHAR2,
580 x_Msg_Count OUT NOCOPY NUMBER,
581 x_Msg_Data OUT NOCOPY VARCHAR2,
582 p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
583 p_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
584 p_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
585 p_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
586 p_Terr_Values_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
587 x_Terr_Id OUT NOCOPY NUMBER,
588 x_Terr_Usgs_Out_Tbl OUT NOCOPY Terr_Usgs_Out_Tbl_Type,
589 x_Terr_QualTypeUsgs_Out_Tbl OUT NOCOPY Terr_QualTypeUsgs_Out_Tbl_Type,
590 x_Terr_Qual_Out_Tbl OUT NOCOPY Terr_Qual_Out_Tbl_Type,
591 x_Terr_Values_Out_Tbl OUT NOCOPY Terr_Values_Out_Tbl_Type);
592
593
594 -- ***************************************************
595 -- start of comments
596 -- ***************************************************
597 --
598 -- API name : Delete_Territory
599 -- Type : PUBLIC
600 -- Function : To delete Territories - which would also delete
601 -- Territory Header, Territory Qualifier,
605 -- Parameters:
602 -- Territory Qualifier Values and Resources.
603 --
604 -- Pre-reqs :
606 -- IN :
607 -- Required
608 -- Parameter Name Data Type Default
609 -- p_Api_Version_Number NUMBER
610 -- p_Terr_Id NUMBER
611 --
612 -- Optional
613 -- Parameter Name Data Type Default
614 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
615 -- p_Commit VARCHAR2 FND_API.G_FALSE
616 --
617 -- OUT NOCOPY :
618 -- Parameter Name Data Type
619 -- X_Return_Status VARCHAR2(1)
620 -- X_Msg_Count NUMBER
621 -- X_Msg_Data VARCHAR2(2000)
622 --
623 --
624 -- Notes:
625 -- Rules for deletion have to be very strict.
626 --
627 -- End of Comments
628 --
629 PROCEDURE Delete_Territory
630 (p_Api_Version_Number IN NUMBER,
631 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
632 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
633 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
634 X_Return_Status OUT NOCOPY VARCHAR2,
635 X_Msg_Count OUT NOCOPY NUMBER,
636 X_Msg_Data OUT NOCOPY VARCHAR2,
637 p_Terr_Id IN NUMBER);
638
639
640 -- ***************************************************
641 -- start of comments
642 -- ***************************************************
643 -- API name : Update_Territory
644 -- Type : PUBLIC
645 -- Function : To update existINg Territories - which includes updates to the following tables
646 -- Territory Header, Territory Qualifier, terr Usages, qualifier type usages
647 -- Territory Qualifier Values and Assign Resources
648 -- Pre-reqs :
649 -- Parameters:
650 -- IN :
651 -- Required
652 -- Parameter Name Data Type Default
653 -- p_Api_Version_Number NUMBER
654 -- p_Terr_All_Rec Terr_All_Rec_Type := G_Miss_Terr_All_Rec
655 -- p_Terr_Usgs_Tbl Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl
656 -- p_Terr_QualTypeUsgs_Tbl Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl
657 -- p_Terr_Qual_Tbl Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl
658 -- p_Terr_Values_Tbl Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl
659 --
660 -- Optional
661 -- Parameter Name Data Type Default
662 -- p_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
663 -- p_Commit VARCHAR2 := FND_API.G_FALSE
664 --
665 -- OUT NOCOPY :
666 -- Parameter Name Data Type
667 -- X_Return_Status VARCHAR2(1)
668 -- X_Msg_Count NUMBER
669 -- X_Msg_Data VARCHAR2(2000)
670 -- X_Terr_All_Out_Rec Terr_All_Out_Rec
671 -- X_Terr_Usgs_Out_Tbl Terr_Usgs_Out_Tbl,
672 -- X_Terr_QualTypeUsgs_Out_Tbl Terr_QualTypeUsgs_Out_Tbl,
673 -- X_Terr_Qual_Out_Tbl Terr_Qual_Out_Tbl,
674 -- X_Terr_Values_Out_Tbl Terr_Values_Out_Tbl
675 --
676 --
677 -- Notes:
678 --
679 --
680 -- End of Comments
681 --
682 PROCEDURE Update_Territory
683 (p_Api_Version_Number IN NUMBER,
684 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
685 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
686 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
687 X_Return_Status OUT NOCOPY VARCHAR2,
688 X_Msg_Count OUT NOCOPY NUMBER,
689 X_Msg_Data OUT NOCOPY VARCHAR2,
690 p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
691 -- p_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
692 -- p_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
693 -- p_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
694 -- p_Terr_Values_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
695 X_Terr_All_Out_Rec OUT NOCOPY Terr_All_Out_Rec_Type
696 -- X_Terr_Usgs_Out_Tbl OUT NOCOPY Terr_Usgs_Out_Tbl_Type,
697 -- X_Terr_QualTypeUsgs_Out_Tbl OUT NOCOPY Terr_QualTypeUsgs_Out_Tbl_Type,
698 -- X_Terr_Qual_Out_Tbl OUT NOCOPY Terr_Qual_Out_Tbl_Type,
699 -- X_Terr_Values_Out_Tbl OUT NOCOPY Terr_Values_Out_Tbl_Type
700 );
701
702
703 -- ***************************************************
704 -- start of comments
705 -- ***************************************************
706 --
707 -- API name : Deactivate_Territory
708 -- Type : PUBLIC
709 -- Function : To deactivate Territories - this API also deactivates
710 -- any sub-territories of this territory.
711 --
712 -- Pre-reqs :
713 -- Parameters:
714 -- IN :
715 -- Required
716 -- Parameter Name Data Type Default
717 -- p_Api_Version_Number NUMBER
721 -- Parameter Name Data Type Default
718 -- p_Terr_Id NUMBER
719 --
720 -- Optional
722 -- p_Init_Msg_List VARCHAR2 FND_API.G_FALSE
723 -- p_Commit VARCHAR2 FND_API.G_FALSE
724 --
725 -- OUT NOCOPY :
726 -- Parameter Name Data Type
727 -- x_Return_Status VARCHAR2(1)
728 -- x_Msg_Count NUMBER
729 -- x_Msg_Data VARCHAR2(2000)
730 --
731 --
732 -- Notes:
733 --
734 --
735 -- End of Comments
736 --
737 PROCEDURE Deactivate_Territory
738 (p_api_version_number IN NUMBER,
739 p_INit_msg_list IN VARCHAR2 := FND_API.G_FALSE,
740 p_commit IN VARCHAR2 := FND_API.G_FALSE,
741 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
742 x_return_status OUT NOCOPY VARCHAR2,
743 x_msg_count OUT NOCOPY NUMBER,
744 x_msg_data OUT NOCOPY VARCHAR2,
745 P_terr_id IN NUMBER);
746
747 --
748 -- ***************************************************
749 -- start of comments
750 -- ***************************************************
751 -- API name : Create_Terr_Header
752 -- Type : PUBLIC
753 -- Function : To create Territories - which inludes the creation of following
754 -- Territory Header, Territory Usages, Territory qualifier type usages
755 -- table.
756 -- Pre-reqs :
757 -- Parameters:
758 -- IN :
759 -- Required
760 -- Parameter Name Data Type Default
761 -- P_Api_Version_Number NUMBER
762 -- P_Terr_All_Rec Terr_All_Rec_Type := G_Miss_Terr_All_Rec
763 -- P_Terr_Usgs_Tbl Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl
764 -- P_Terr_QualTypeUsgs_Tbl Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl
765 --
766 -- Optional
767 -- Parameter Name Data Type Default
768 -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
769 -- P_Commit VARCHAR2 := FND_API.G_FALSE
770 --
771 -- OUT NOCOPY :
772 -- Parameter Name Data Type
773 -- X_Return_Status VARCHAR2(1)
774 -- X_Msg_Count NUMBER
775 -- X_Msg_Data VARCHAR2(2000)
776 -- X_Terr_All_Out_Rec Terr_All_Out_Rec
777 -- X_Terr_Usgs_Out_Tbl Terr_Usgs_Out_Tbl,
778 -- X_Terr_QualTypeUsgs_Out_Tbl Terr_QualTypeUsgs_Out_Tbl,
779 --
780 --
781 -- Notes:
782 --
783 --
784 -- End of Comments
785 --
786 PROCEDURE Create_Territory_Header
787 (P_Api_Version_Number IN NUMBER,
788 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
789 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
790 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
791 P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
792 P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
793 -- P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
794 X_Return_Status OUT NOCOPY VARCHAR2,
795 X_Msg_Count OUT NOCOPY NUMBER,
796 X_Msg_Data OUT NOCOPY VARCHAR2,
797 X_Terr_All_Out_Rec OUT NOCOPY Terr_All_Out_Rec_Type,
798 X_Terr_Usgs_Out_Tbl OUT NOCOPY Terr_Usgs_Out_Tbl_Type,
799 X_Terr_QualTypeUsgs_Out_Tbl OUT NOCOPY Terr_QualTypeUsgs_Out_Tbl_Type);
800
801 PROCEDURE Create_Territory_Record
802 ( P_Api_Version_Number IN NUMBER,
803 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
804 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
805 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
806 P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
807 X_Return_Status OUT NOCOPY VARCHAR2,
808 X_Msg_Count OUT NOCOPY NUMBER,
809 X_Msg_Data OUT NOCOPY VARCHAR2,
810 X_Terr_Id OUT NOCOPY NUMBER,
811 X_Terr_All_Out_Rec OUT NOCOPY Terr_All_Out_Rec_Type
812 );
813
814
815 PROCEDURE Create_Territory_Usages
816 ( P_Api_Version_Number IN NUMBER,
817 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
818 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
819 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
820 P_Terr_Id IN NUMBER,
821 P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
822 X_Return_Status OUT NOCOPY VARCHAR2,
823 X_Msg_Count OUT NOCOPY NUMBER,
824 X_Msg_Data OUT NOCOPY VARCHAR2,
825 X_Terr_Usgs_Out_Tbl OUT NOCOPY Terr_Usgs_Out_Tbl_Type
826 );
827
828
829 PROCEDURE Create_Terr_QualType_Usage
833 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
830 (P_Api_Version_Number IN NUMBER,
831 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
832 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
834 P_Terr_Id IN NUMBER,
835 P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
836 X_Return_Status OUT NOCOPY VARCHAR2,
837 X_Msg_Count OUT NOCOPY NUMBER,
838 X_Msg_Data OUT NOCOPY VARCHAR2,
839 X_Terr_QualTypeUsgs_Id OUT NOCOPY NUMBER,
840 X_Terr_QualTypeUsgs_Out_Rec OUT NOCOPY Terr_QualTypeUsgs_Out_Rec_Type);
841
842
843 PROCEDURE Create_Terr_QualType_Usage
844 (P_Api_Version_Number IN NUMBER,
845 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
846 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
847 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
848 P_Terr_Id IN NUMBER,
849 P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
850 X_Return_Status OUT NOCOPY VARCHAR2,
851 X_Msg_Count OUT NOCOPY NUMBER,
852 X_Msg_Data OUT NOCOPY VARCHAR2,
853 X_Terr_QualTypeUsgs_Out_Tbl OUT NOCOPY Terr_QualTypeUsgs_Out_Tbl_Type);
854
855
856 PROCEDURE Create_Terr_Qualifier
857 (P_Api_Version_Number IN NUMBER,
858 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
859 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
860 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
861 P_Terr_Id IN NUMBER,
862 P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
863 X_Return_Status OUT NOCOPY VARCHAR2,
864 X_Msg_Count OUT NOCOPY NUMBER,
865 X_Msg_Data OUT NOCOPY VARCHAR2,
866 X_Terr_Qual_Id OUT NOCOPY NUMBER,
867 X_Terr_Qual_Out_Rec OUT NOCOPY Terr_Qual_Out_Rec_Type);
868
869 PROCEDURE Create_Terr_Qualifier
870 (P_Api_Version_Number IN NUMBER,
871 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
872 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
873 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
874 P_Terr_Id IN NUMBER,
875 P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
876 X_Return_Status OUT NOCOPY VARCHAR2,
877 X_Msg_Count OUT NOCOPY NUMBER,
878 X_Msg_Data OUT NOCOPY VARCHAR2,
879 X_Terr_Qual_Out_Tbl OUT NOCOPY Terr_Qual_Out_Tbl_Type);
880
881 PROCEDURE Create_Terr_qualifier
882 (
883 p_Api_Version_Number IN NUMBER,
884 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
885 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
886 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
887 x_Return_Status OUT NOCOPY VARCHAR2,
888 x_Msg_Count OUT NOCOPY NUMBER,
889 x_Msg_Data OUT NOCOPY VARCHAR2,
890 P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
891 p_Terr_Values_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
892 X_Terr_Qual_Out_Rec OUT NOCOPY Terr_Qual_Out_Rec_Type,
893 x_Terr_Values_Out_Tbl OUT NOCOPY Terr_Values_Out_Tbl_Type );
894
895 PROCEDURE Create_Terr_Value
896 (P_Api_Version_Number IN NUMBER,
897 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
898 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
899 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
900 P_Terr_Id IN NUMBER,
901 p_terr_qual_id IN NUMBER,
902 P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
903 X_Return_Status OUT NOCOPY VARCHAR2,
904 X_Msg_Count OUT NOCOPY NUMBER,
905 X_Msg_Data OUT NOCOPY VARCHAR2,
906 X_Terr_Value_Id OUT NOCOPY NUMBER,
907 X_Terr_Value_Out_Rec OUT NOCOPY Terr_Values_Out_Rec_Type);
908
909
910 PROCEDURE Create_Terr_Value
911 (P_Api_Version_Number IN NUMBER,
912 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
913 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
914 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
915 P_Terr_Id IN NUMBER,
916 p_terr_qual_id IN NUMBER,
917 P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
918 X_Return_Status OUT NOCOPY VARCHAR2,
919 X_Msg_Count OUT NOCOPY NUMBER,
920 X_Msg_Data OUT NOCOPY VARCHAR2,
921 X_Terr_Value_Out_Tbl OUT NOCOPY Terr_Values_Out_Tbl_Type);
922
923
924 PROCEDURE Update_Territory_Record
925 ( P_Api_Version_Number IN NUMBER,
929 P_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
926 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
927 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
928 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
930 X_Return_Status OUT NOCOPY VARCHAR2,
931 X_Msg_Count OUT NOCOPY NUMBER,
932 X_Msg_Data OUT NOCOPY VARCHAR2,
933 X_Terr_All_Out_Rec OUT NOCOPY Terr_All_Out_Rec_Type
934 );
935
936 PROCEDURE Update_Territory_Usages
937 ( P_Api_Version_Number IN NUMBER,
938 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
939 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
940 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
941 P_Terr_Usgs_Rec IN Terr_Usgs_Rec_Type := G_MISS_TERR_USGS_REC,
942 X_Return_Status OUT NOCOPY VARCHAR2,
943 X_Msg_Count OUT NOCOPY NUMBER,
944 X_Msg_Data OUT NOCOPY VARCHAR2,
945 X_Terr_Usgs_Out_Rec OUT NOCOPY Terr_Usgs_Out_Rec_Type);
946
947 PROCEDURE Update_Territory_Usages
948 ( P_Api_Version_Number IN NUMBER,
949 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
950 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
951 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
952 P_Terr_Usgs_Tbl IN Terr_Usgs_Tbl_Type := G_MISS_Terr_Usgs_Tbl,
953 X_Return_Status OUT NOCOPY VARCHAR2,
954 X_Msg_Count OUT NOCOPY NUMBER,
955 X_Msg_Data OUT NOCOPY VARCHAR2,
956 X_Terr_Usgs_Out_Tbl OUT NOCOPY Terr_Usgs_Out_Tbl_Type
957 );
958
959 PROCEDURE Update_Terr_QualType_Usage
960 ( P_Api_Version_Number IN NUMBER,
961 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
962 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
963 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
964 P_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
965 X_Return_Status OUT NOCOPY VARCHAR2,
966 X_Msg_Count OUT NOCOPY NUMBER,
967 X_Msg_Data OUT NOCOPY VARCHAR2,
968 X_Terr_QualTypeUsgs_Out_Rec OUT NOCOPY Terr_QualTypeUsgs_Out_Rec_Type
969 );
970
971 PROCEDURE Update_Terr_QualType_Usage
972 ( P_Api_Version_Number IN NUMBER,
973 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
974 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
975 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
976 P_Terr_QualTypeUsgs_Tbl IN Terr_QualTypeUsgs_Tbl_Type := G_Miss_Terr_QualTypeUsgs_Tbl,
977 X_Return_Status OUT NOCOPY VARCHAR2,
978 X_Msg_Count OUT NOCOPY NUMBER,
979 X_Msg_Data OUT NOCOPY VARCHAR2,
980 X_Terr_QualTypeUsgs_Out_Tbl OUT NOCOPY Terr_QualTypeUsgs_Out_Tbl_Type
981 );
982
983 PROCEDURE Update_Terr_Qualifier
984 ( P_Api_Version_Number IN NUMBER,
985 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
986 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
987 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
988 P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
989 X_Return_Status OUT NOCOPY VARCHAR2,
990 X_Msg_Count OUT NOCOPY NUMBER,
991 X_Msg_Data OUT NOCOPY VARCHAR2,
992 X_Terr_Qual_Out_Rec OUT NOCOPY Terr_Qual_Out_Rec_Type
993 );
994
995 PROCEDURE Update_Terr_Qualifier
996 ( P_Api_Version_Number IN NUMBER,
997 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
998 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
999 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1000 P_Terr_Qual_Tbl IN Terr_Qual_Tbl_Type := G_Miss_Terr_Qual_Tbl,
1001 X_Return_Status OUT NOCOPY VARCHAR2,
1002 X_Msg_Count OUT NOCOPY NUMBER,
1003 X_Msg_Data OUT NOCOPY VARCHAR2,
1004 X_Terr_Qual_Out_Tbl OUT NOCOPY Terr_Qual_Out_Tbl_Type
1005 );
1006
1007 PROCEDURE Update_Terr_Value
1008 ( P_Api_Version_Number IN NUMBER,
1009 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1010 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1011 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1012 P_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec,
1013 X_Return_Status OUT NOCOPY VARCHAR2,
1014 X_Msg_Count OUT NOCOPY NUMBER,
1015 X_Msg_Data OUT NOCOPY VARCHAR2,
1016 X_Terr_Value_Out_Rec OUT NOCOPY Terr_Values_Out_Rec_Type
1017 );
1018
1022 ( P_Api_Version_Number IN NUMBER,
1019
1020 --Overloaded to take table type input parameter
1021 PROCEDURE Update_Terr_Value
1023 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1024 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1025 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1026 P_Terr_Value_Tbl IN Terr_Values_Tbl_Type := G_Miss_Terr_Values_Tbl,
1027 X_Return_Status OUT NOCOPY VARCHAR2,
1028 X_Msg_Count OUT NOCOPY NUMBER,
1029 X_Msg_Data OUT NOCOPY VARCHAR2,
1030 X_Terr_Value_Out_Tbl OUT NOCOPY Terr_Values_Out_Tbl_Type
1031 );
1032
1033
1034 PROCEDURE Delete_territory_Record
1035 (P_Api_Version_Number IN NUMBER,
1036 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1037 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1038 P_Terr_Id IN NUMBER,
1039 X_Return_Status OUT NOCOPY VARCHAR2,
1040 X_Msg_Count OUT NOCOPY VARCHAR2,
1041 X_Msg_Data OUT NOCOPY VARCHAR2);
1042
1043 PROCEDURE Delete_Territory_Usages
1044 (P_Api_Version_Number IN NUMBER,
1045 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1046 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1047 P_Terr_usg_Id IN NUMBER,
1048 X_Return_Status OUT NOCOPY VARCHAR2,
1049 X_Msg_Count OUT NOCOPY VARCHAR2,
1050 X_Msg_Data OUT NOCOPY VARCHAR2);
1051
1052 PROCEDURE Delete_Terr_QualType_Usage
1053 (P_Api_Version_Number IN NUMBER,
1054 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1055 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1056 P_Terr_Qual_Type_Usg_Id IN NUMBER,
1057 X_Return_Status OUT NOCOPY VARCHAR2,
1058 X_Msg_Count OUT NOCOPY VARCHAR2,
1059 X_Msg_Data OUT NOCOPY VARCHAR2);
1060
1061 PROCEDURE Delete_Terr_Qualifier
1062 (P_Api_Version_Number IN NUMBER,
1063 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1064 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1065 P_Terr_Qual_Id IN NUMBER,
1066 X_Return_Status OUT NOCOPY VARCHAR2,
1067 X_Msg_Count OUT NOCOPY VARCHAR2,
1068 X_Msg_Data OUT NOCOPY VARCHAR2);
1069
1070
1071 PROCEDURE Delete_Terr_Value
1072 (P_Api_Version_Number IN NUMBER,
1073 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1074 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1075 P_Terr_Value_Id IN NUMBER,
1076 X_Return_Status OUT NOCOPY VARCHAR2,
1077 X_Msg_Count OUT NOCOPY VARCHAR2,
1078 X_Msg_Data OUT NOCOPY VARCHAR2);
1079 ----------------------------------------------------------------------
1080 -- A generic routine to validate foreign keys
1081 ----------------------------------------------------------------------
1082 PROCEDURE Validate_Foreign_Key
1083 (p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1084 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1085 x_Return_Status OUT NOCOPY VARCHAR2,
1086 x_msg_count OUT NOCOPY NUMBER,
1087 x_msg_data OUT NOCOPY VARCHAR2 );
1088
1089 ----------------------------------------------------------------------
1090 -- This procedure will check whether the qualifiers passed are
1091 -- valid.
1092 ----------------------------------------------------------------------
1093 PROCEDURE Validate_Qualifier
1094 (p_Terr_Id IN NUMBER,
1095 P_Terr_Qual_Rec IN Terr_Qual_Rec_Type := G_Miss_Terr_Qual_Rec,
1096 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1097 x_Return_Status OUT NOCOPY VARCHAR2,
1098 x_msg_count OUT NOCOPY NUMBER,
1099 x_msg_data OUT NOCOPY VARCHAR2 );
1100
1101 ---------------------------------------------------------------------
1102 -- Validae the Territory record
1103 ---------------------------------------------------------------------
1104 -- Columns Validated
1105 -- Validate the foreign key if specified
1106 -- Validate to make sure the territory name is specified and is not duplicate
1107 -- Validate start date , end date , org_id , parent terr_id and Rank.
1108 ---------------------------------------------------------------------
1109 PROCEDURE Validate_Territory_Record
1110 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1111 x_Return_Status OUT NOCOPY VARCHAR2,
1112 x_msg_count OUT NOCOPY NUMBER,
1113 x_msg_data OUT NOCOPY VARCHAR2,
1114 p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec);
1115
1116 ---------------------------------------------------------------------
1117 -- Validae the Territory record while updation
1118 ---------------------------------------------------------------------
1119 -- Columns Validated
1120 -- Validate the foreign key if specified
1121 -- Validate to make sure the territory name is specified and is not duplicate
1125 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1122 -- Validate start date and end date
1123 ---------------------------------------------------------------------
1124 PROCEDURE Validate_TerrRec_Update
1126 x_Return_Status OUT NOCOPY VARCHAR2,
1127 x_msg_count OUT NOCOPY NUMBER,
1128 x_msg_data OUT NOCOPY VARCHAR2,
1129 p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec);
1130
1131
1132 ---------------------------------------------------------------------
1133 -- Validae the Territory Usage
1134 ---------------------------------------------------------------------
1135 -- Columns Validated
1136 -- Make sure a Territory Usage is specified
1137 -- Make sure the Territory Id is valid
1138 -- Make sure the territory usage Id is Valid
1139 ---------------------------------------------------------------------
1140 PROCEDURE Validate_Territory_Usage
1141 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1142 x_Return_Status OUT NOCOPY VARCHAR2,
1143 x_msg_count OUT NOCOPY NUMBER,
1144 x_msg_data OUT NOCOPY VARCHAR2,
1145 p_Terr_Usgs_Rec IN Terr_Usgs_Rec_Type := G_MISS_Terr_Usgs_Rec,
1146 p_Terr_Id IN NUMBER);
1147
1148
1149 ---------------------------------------------------------------------
1150 -- Validate the Territory Qualifer Type Usage
1151 ---------------------------------------------------------------------
1152 -- Columns Validated
1153 -- Make sure a Territory Qual Type Usage is specified
1154 -- Make sure the Territory Id is valid
1155 -- Make sure the QUAL_TYPE_USG_ID is valid
1156 ---------------------------------------------------------------------
1157 PROCEDURE Validate_Terr_Qtype_Usage
1158 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1159 x_Return_Status OUT NOCOPY VARCHAR2,
1160 x_msg_count OUT NOCOPY NUMBER,
1161 x_msg_data OUT NOCOPY VARCHAR2,
1162 p_Terr_QualTypeUsgs_Rec IN Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec,
1163 p_Terr_Id IN NUMBER);
1164
1165 ---------------------------------------------------------------------
1166 -- Validate the Territory Qualifer Values passed in
1167 ---------------------------------------------------------------------
1168 -- Columns Validated
1169 -- Make sure the values are in the right columns as per the
1170 -- qualifer setup
1171 -- Eg:
1172 -- If the qualifer, diplay_type = 'CHAR' and
1173 -- col1_data_type = 'NUMBER'
1174 -- then make sure the ID is passed in LOW_VALUE_CHAR_ID
1175 --
1176 --
1177 ---------------------------------------------------------------------
1178 PROCEDURE Validate_terr_Value_Rec
1179 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1180 x_Return_Status OUT NOCOPY VARCHAR2,
1181 x_msg_count OUT NOCOPY NUMBER,
1182 x_msg_data OUT NOCOPY VARCHAR2,
1183 p_terr_qual_id IN NUMBER,
1184 p_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec);
1185
1186
1187
1188 -- CHECK FOR DUPLICATES VALUES
1189 --
1190 PROCEDURE Check_duplicate_Value
1191 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1192 x_Return_Status OUT NOCOPY VARCHAR2,
1193 x_msg_count OUT NOCOPY NUMBER,
1194 x_msg_data OUT NOCOPY VARCHAR2,
1195 p_Terr_Qual_Id IN NUMBER,
1196 p_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec) ;
1197
1198 -- CHECK FOR DUPLICATES VALUES
1199 --
1200 PROCEDURE Check_duplicate_Value_update
1201 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1202 x_Return_Status OUT NOCOPY VARCHAR2,
1203 x_msg_count OUT NOCOPY NUMBER,
1204 x_msg_data OUT NOCOPY VARCHAR2,
1205 p_Terr_Qual_Id IN NUMBER,
1206 p_Terr_Value_Rec IN Terr_Values_Rec_Type := G_Miss_Terr_Values_Rec) ;
1207
1208 ---------------------------------------------------------------------
1209 -- Get_Max_Rank
1210 ---------------------------------------------------------------------
1211 --
1212 -- Gets the maximum rank of a particular Level
1213 ---------------------------------------------------------------------
1214 PROCEDURE Get_Max_Rank
1215 (p_Parent_Terr_Id IN NUMBER,
1216 p_Source_Id IN NUMBER,
1217 X_Rank OUT NOCOPY NUMBER);
1218
1219
1220 ---------------------------------------------------------------------
1221 -- Procedure
1222 -- Gen_Template_Territories
1223 --
1224 -- Purpose
1225 -- Generates territories for a template.
1226 --
1227 -- Argument: p_terr_template_id
1228 -- If the template id is passed, all territories which have been previously
1229 -- generated from this template and not updated manually will be deleted
1230 -- first.
1231 PROCEDURE Gen_Template_Territories (
1232 p_Api_Version_Number IN NUMBER,
1233 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1234 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1238 x_Msg_Count OUT NOCOPY NUMBER,
1235 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1236 p_Template_Terr_Id IN NUMBER,
1237 x_Return_Status OUT NOCOPY VARCHAR2,
1239 x_Msg_Data OUT NOCOPY VARCHAR2,
1240 x_num_gen_terr OUT NOCOPY NUMBER
1241 );
1242 ---------------------------------------------------------------------
1243 -- Procedure
1244 -- Copy_Territory
1245 --
1246 -- Purpose
1247 -- Makes a copy of a territory.
1248 --
1249 -- Argument: p_copy_source_terr_id - terr_id of territory to be copied
1250 -- p_new_terr_name - name of the new copied territory
1251 -- p_copy_rsc_flag - indicates whether resources assigned
1252 -- to territory are to be copied
1253 -- p_copy_hierarchy_flag - indicates whether the territory hierarchy
1254 -- below this territory are to be copied
1255 -- p_first_terr_node_flag - indicates whether this is the first node to be copied
1256
1257 PROCEDURE Copy_Territory (
1258 p_Api_Version_Number IN NUMBER,
1259 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1260 p_Commit IN VARCHAR2 := FND_API.G_FALSE,
1261 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1262 p_copy_source_terr_Id IN NUMBER,
1263 p_new_terr_rec IN Terr_All_Rec_Type,
1264 p_copy_rsc_flag IN VARCHAR2 := 'N',
1265 p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1266 p_first_terr_node_flag IN VARCHAR2 := 'N',
1267 x_Return_Status OUT NOCOPY VARCHAR2,
1268 x_Msg_Count OUT NOCOPY NUMBER,
1269 x_Msg_Data OUT NOCOPY VARCHAR2,
1270 x_Terr_Id OUT NOCOPY NUMBER
1271 );
1272
1273
1274 ---------------------------------------------------------------------
1275 -- Overlap Exists
1276 ---------------------------------------------------------------------
1277 --
1278 -- Check whether any OVERLAP exists for a particular
1279 -- qualifier usage value passed of a particular parent
1280 -- territory. This si because we only check for overlap
1281 -- under a single parent
1282 ---------------------------------------------------------------------
1283 FUNCTION Overlap_Exists(p_Parent_Terr_Id IN NUMBER,
1284 p_Qual_Usg_Id IN NUMBER,
1285 p_terr_value_record IN jtf_terr_values%ROWTYPE )
1286 RETURN VARCHAR2;
1287
1288
1289 -- jdochert 09/09
1290 -- check for Unique Key constraint violation on JTF_TERR_USGS table
1291 PROCEDURE validate_terr_usgs_UK(
1292 p_Terr_Id IN NUMBER,
1293 p_Source_Id IN NUMBER,
1294 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1295 x_Return_Status OUT NOCOPY VARCHAR2,
1296 x_msg_count OUT NOCOPY NUMBER,
1297 x_msg_data OUT NOCOPY VARCHAR2 );
1298
1299 -- jdochert 09/09
1300 -- check for Unique Key constraint violation on JTF_TERR_QTYPE_USGS table
1301 PROCEDURE validate_terr_qtype_usgs_UK(
1302 p_Terr_Id IN NUMBER,
1303 p_Qual_Type_Usg_Id IN NUMBER,
1304 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1305 x_Return_Status OUT NOCOPY VARCHAR2,
1306 x_msg_count OUT NOCOPY NUMBER,
1307 x_msg_data OUT NOCOPY VARCHAR2 );
1308
1309 -- jdochert 10/04
1310 -- check that Number of Winners is valid for this territory
1311 PROCEDURE validate_num_winners(
1312 p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1313 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1314 x_Return_Status OUT NOCOPY VARCHAR2,
1315 x_msg_count OUT NOCOPY NUMBER,
1316 x_msg_data OUT NOCOPY VARCHAR2,
1317 x_reason OUT NOCOPY VARCHAR2 );
1318
1319 -- jdochert 06/08/01
1320 -- check that parent is not already a
1321 -- child of this territory: circular reference check
1322 PROCEDURE validate_parent(
1323 p_Terr_All_Rec IN Terr_All_Rec_Type := G_Miss_Terr_All_Rec,
1324 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1325 x_Return_Status OUT NOCOPY VARCHAR2,
1326 x_msg_count OUT NOCOPY NUMBER,
1327 x_msg_data OUT NOCOPY VARCHAR2 );
1328
1329 /* JDOCHERT - 041201 */
1330 PROCEDURE chk_num_copy_terr( p_node_terr_id IN NUMBER,
1331 p_limit_num IN NUMBER := 10,
1332 x_Return_Status OUT NOCOPY VARCHAR2,
1333 x_msg_count OUT NOCOPY NUMBER,
1334 x_msg_data OUT NOCOPY VARCHAR2,
1335 x_terr_num OUT NOCOPY NUMBER,
1336 x_copy_status OUT NOCOPY VARCHAR2 );
1337 -- Package spec
1338
1339 /* ARPATEL - 041701 */
1340 PROCEDURE Concurrent_Copy_Territory (
1341 errbuf OUT NOCOPY VARCHAR2,
1342 retcode OUT NOCOPY VARCHAR2,
1343 p_copy_source_terr_Id IN NUMBER,
1344 p_name IN VARCHAR2,
1345 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1346 p_rank IN NUMBER := FND_API.G_MISS_NUM,
1347 p_start_date IN DATE,
1348 p_end_date IN DATE := FND_API.G_MISS_DATE,
1349 p_copy_rsc_flag IN VARCHAR2 := 'N',
1350 p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1351 p_first_terr_node_flag IN VARCHAR2 := 'N',
1352 p_debug_flag IN VARCHAR2 := 'N',
1353 p_sql_trace IN VARCHAR2 := 'N' );
1354
1355 PROCEDURE Write_Log(which number, mssg varchar2 );
1356
1357 FUNCTION conc_req_copy_terr (
1358 p_copy_source_terr_Id IN NUMBER,
1359 p_name IN VARCHAR2,
1360 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1361 p_rank IN NUMBER := FND_API.G_MISS_NUM,
1362 p_start_date IN DATE,
1363 p_end_date IN DATE := FND_API.G_MISS_DATE,
1364 p_copy_rsc_flag IN VARCHAR2 := 'N',
1365 p_copy_hierarchy_flag IN VARCHAR2 := 'N',
1366 p_first_terr_node_flag IN VARCHAR2 := 'N'
1367 )
1368 RETURN NUMBER;
1369
1370 /* Function used in JTF_TERR_VALUES_DESC_V to return
1371 ** descriptive values for ids and lookup_codes
1372 */
1373 FUNCTION get_terr_value_desc (
1374 p_convert_to_id_flag VARCHAR2
1375 , p_display_type VARCHAR2
1376 , p_column_count NUMBER := FND_API.G_MISS_NUM
1377 , p_display_sql VARCHAR2 := FND_API.G_MISS_CHAR
1378 , p_terr_value1 VARCHAR2
1379 , p_terr_value2 VARCHAR2 := FND_API.G_MISS_CHAR
1380 )
1381 RETURN VARCHAR2;
1382
1383 --Function for Getting the Qualifier Values.
1384
1385 FUNCTION get_qual_value(
1386 v_qual_usg_id IN NUMBER,
1387 v_display_type IN VARCHAR2,
1388 v_convert_to_id_flag IN VARCHAR2,
1389 v_COMPARISON_OPERATOR IN VARCHAR2,
1390 v_display_sql1 IN VARCHAR2,
1391 v_display_sql2 IN VARCHAR2,
1392 v_display_sql3 IN VARCHAR2,
1393 v_low_value_char_id IN NUMBER,
1394 v_low_value_char IN VARCHAR2,
1395 v_interest_type_id IN NUMBER,
1396 v_primary_interest_code_id IN NUMBER,
1397 v_secondary_interest_code_id IN NUMBER,
1398 v_value1_id_1 IN NUMBER,
1399 v_value2_id_2 IN NUMBER,
1400 v_currency_code IN VARCHAR2,
1401 select_flag IN VARCHAR2)
1402 RETURN VARCHAR2;
1403
1404 END JTF_TERRITORY_PVT;