[Home] [Help]
PACKAGE: APPS.JTF_TERRITORY_TYPE_PVT
Source
1 PACKAGE JTF_TERRITORY_TYPE_PVT AS
2 /* $Header: jtfvttys.pls 120.0 2005/06/02 18:23:09 appldev ship $ */
3 -- ---------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_TERRITORY_TYPE_PVT
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- Joint task force core territory manager public api's.
10 -- This package is a public API for inserting territory type
11 -- related information in to information into 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 for private use only
20 --
21 -- HISTORY
22 -- 06/09/99 VNEDUNGA Created
23 -- 11/20/99 VNEDUNGA Commenting out FND_G_MISS
24 -- 11/29/99 VNEDUNGA Added a new procedure to validate
25 -- Territory Type( Is_TerrType_Deletable )
26 -- 01/25/00 VNEDUNGA Adding Copy terr Type procedure
27 -- 02/17/00 VNEDUNGA Adding ORG_ID to Record Defnitions
28 --
29 -- End of Comments
30
31 --*******************************************************
32 -- Start of Comments
33 ---------------------------------------------------------
34 -- Territory Header Record: TerrType_rec_type
35 -- ---------------------------------------------------
36 -- Parameters:
37 -- Required:
38 -- NAME -- Territory Type Name
39 -- LAST_UPDATE_DATE -- Part of std who columns
40 -- LAST_UPDATED_BY -- Part of std who columns
41 -- CREATION_DATE -- Part of std who columns
42 -- CREATED_BY -- Part of std who columns
43 -- LAST_UPDATE_LOGIN -- Part of std who columns
44 -- ENABLED_FLAG -- Status fo territory type
45 -- NUM_QUALIFIERS -- Number of qualifiers used
46 --
47 -- Defaults:
48 -- Note:
49 --
50 -- End of Comments
51
52 TYPE TerrType_rec_type IS RECORD
53 (
54 TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
55 LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
56 LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
57 CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
58 CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
59 LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
60 APPLICATION_SHORT_NAME VARCHAR2(50) , -- := FND_API.G_MISS_CHAR,
61 NAME VARCHAR2(60) , -- := FND_API.G_MISS_CHAR,
62 ENABLED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
63 START_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
64 END_DATE_ACTIVE DATE , -- := FND_API.G_MISS_DATE,
65 DESCRIPTION VARCHAR2(240) , -- := FND_API.G_MISS_CHAR,
66 ORG_ID NUMBER , -- := FND_API.G_MISS_NUM,
67 ATTRIBUTE_CATEGORY VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
68 ATTRIBUTE1 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
69 ATTRIBUTE2 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
70 ATTRIBUTE3 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
71 ATTRIBUTE4 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
72 ATTRIBUTE5 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
73 ATTRIBUTE6 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
74 ATTRIBUTE7 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
75 ATTRIBUTE8 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
76 ATTRIBUTE9 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
77 ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
78 ATTRIBUTE11 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
79 ATTRIBUTE12 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
80 ATTRIBUTE13 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
81 ATTRIBUTE14 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
82 ATTRIBUTE15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
83 );
84
85 G_MISS_TerrType_REC TerrType_rec_type;
86
87 TYPE TerrType_tbl_type IS TABLE OF TerrType_rec_type
88 INDEX BY BINARY_INTEGER;
89
90 G_MISS_TerrType_TBL TerrType_tbl_type;
91
92
93 --*******************************************************
94 -- Start of Comments
95 ---------------------------------------------------------
96 -- Territory Header Out Record: TerrType_Out_rec_type
97 -- ---------------------------------------------------
98 -- Parameters:
99 -- Required:
100 --
101 -- Defaults:
102 -- Note:
103 --
104 -- End of Comments
105
106 TYPE TerrType_Out_rec_type IS RECORD
107 (
108 TERR_TYPE_ID NUMBER , --:= FND_API.G_MISS_NUM,
109 RETURN_STATUS VARCHAR2(01) --:= FND_API.G_MISS_CHAR
110 );
111
112 G_MISS_TerrType_OUT_REC TerrType_Out_rec_type;
113
114 TYPE TerrType_Out_tbl_type IS TABLE OF TerrType_Out_rec_type
115 INDEX BY BINARY_INTEGER;
116
117 G_MISS_TerrType_OUT_TBL TerrType_Out_tbl_type;
118
119
120 -- ***************************************************
121 -- Start of Comments
122 -- ---------------------------------------------------
123 -- Territory Type source Record: TerrTypeUsgs_rec_type
124 -- ---------------------------------------------------
125 -- Parameters:
126 --
127 -- Required:
128 -- TERR_TYPE_USG_ID -- primary key sequence
129 -- SOURCE_ID -- Source identifier
130 -- TERR_TYPE_ID -- Territory identifier
131 -- LAST_UPDATE_DATE -- Part of std who columns
132 -- LAST_UPDATED_BY -- Part of std who columns
133 -- CREATION_DATE -- Part of std who columns
134 -- CREATED_BY -- Part of std who columns
135 -- LAST_UPDATE_LOGIN -- Part of std who columns
136 -- ORG_ID -- Oraganization Name
137 --
138 -- Defaults:
139 -- Note:
140 --
141 -- End of Comments
142
143 TYPE TerrTypeUsgs_rec_type IS RECORD
144 (
145 TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
146 SOURCE_ID NUMBER , -- := FND_API.G_MISS_NUM,
147 TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
148 LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
149 LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
150 CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
151 CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
152 LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
153 ORG_ID NUMBER -- := FND_API.G_MISS_NUM
154 );
155
156 G_MISS_TerrTypeUSGS_REC TerrTypeusgs_rec_type;
157
158 TYPE TerrTypeusgs_tbl_type IS TABLE OF TerrTypeusgs_rec_type
159 INDEX BY BINARY_INTEGER;
160
161 G_MISS_TerrTypeUSGS_TBL TerrTypeusgs_tbl_type;
162
163
164 -- ***************************************************
165 -- Start of Comments
166 -- ---------------------------------------------------
167 -- Territory Type source out Record:
168 -- TerrTypeusgs_out_rec_type
169 -- ---------------------------------------------------
170 -- Parameters:
171 --
172 -- Required:
173 --
174 -- Defaults:
175 -- Note:
176 --
177 -- End of Comments
178
179 TYPE TerrTypeusgs_out_rec_type IS RECORD
180 (
181 TERR_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
182 RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR
183 );
184
185 G_MISS_TerrTypeUSGS_OUT_REC TerrTypeusgs_out_rec_type;
186
187 TYPE TerrTypeusgs_out_tbl_type IS TABLE OF TerrTypeusgs_out_rec_type
188 INDEX BY BINARY_INTEGER;
189
190 G_MISS_TerrTypeUSGS_OUT_TBL TerrTypeusgs_out_tbl_type;
191
192
193 -- *************************************************************
194 -- Start of Comments
195 -- -------------------------------------------------------------
196 -- Territory Type Qualifier Type Record: TypeQualTypeUsgs_rec_type
197 -- -------------------------------------------------------------
198 -- Parameters:
199 --
200 -- Required:
201 -- TYPE_QUAL_TYPE_USG_ID -- Primary Key sequence
202 -- TERR_TYPE_USG_ID -- Source source id
203 -- QUAL_TYPE_USG_ID -- Type identifier
204 -- LAST_UPDATE_DATE -- Part of std who columns
205 -- LAST_UPDATED_BY -- Part of std who columns
206 -- CREATION_DATE -- Part of std who columns
207 -- CREATED_BY -- Part of std who columns
208 -- LAST_UPDATE_LOGIN -- Part of std who columns
209 -- ORG_ID -- Oraganization Name
210 --
211 -- Defaults:
212 -- Note:
213 --
214 -- End of Comments
215
216 TYPE typequaltypeusgs_rec_type IS RECORD
217 (
218 TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
219 TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
220 QUAL_TYPE_USG_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 ORG_ID NUMBER -- := FND_API.G_MISS_NUM
227 );
228
229 G_MISS_TYPEQUALTYPEUSGS_REC typequaltypeusgs_rec_type;
230
231 TYPE typequaltypeusgs_tbl_type IS TABLE OF typequaltypeusgs_rec_type
232 INDEX BY BINARY_INTEGER;
233
234 G_MISS_TYPEQUALTYPEUSGS_TBL TypeQualTypeUsgs_tbl_type;
235
236
237 -- ***********************************************************
238 -- Start of Comments
239 -- -----------------------------------------------------------
240 -- Territory Type Source Type out Record:
241 -- TerrTypesrcType_out_rec_type
242 -- -----------------------------------------------------------
243 -- Parameters:
244 --
245 -- Required:
246 -- Defaults:
247 -- Note:
248 --
249 -- End of Comments
250
251 TYPE typequaltypeusgs_out_rec_type IS RECORD
252 (
253 TYPE_QUAL_TYPE_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
254 RETURN_STATUS VARCHAR2(01) -- := FND_API.G_MISS_CHAR
255 );
256
257 G_MISS_TYPEQUALTYPUSGS_OUT_REC typequaltypeusgs_out_rec_type;
258
259
260 TYPE Typequaltypeusgs_out_tbl_type IS TABLE OF typequaltypeusgs_out_rec_type
261 INDEX BY BINARY_INTEGER;
262
263 G_MISS_TYPEQUALTYPUSGS_OUT_TBL Typequaltypeusgs_out_tbl_type;
264
265
266 -- ***************************************************
267 -- Start of Comments
268 -- ---------------------------------------------------
269 -- Territory Qualifier Record: TerrTypequal_rec_type
270 -- ---------------------------------------------------
271 -- Parameters:
272 --
273 -- Required:
274 -- SEEDED_QUAL_ID -- Seeded qualifier id
275 -- TERR_TYPE_ID -- Territory type identifier
276 -- LAST_UPDATE_DATE -- Part of std who columns
277 -- LAST_UPDATED_BY -- Part of std who columns
278 -- CREATION_DATE -- Part of std who columns
279 -- CREATED_BY -- Part of std who columns
280 -- LAST_UPDATE_LOGIN -- Part of std who columns
281 -- ORG_ID -- Oraganization Name
282 --
283 -- Defaults:
284 -- Note:
285 -- End of Comments
286
287 TYPE TerrTypequal_rec_type IS RECORD
288 ( TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
289 LAST_UPDATE_DATE DATE , -- := FND_API.G_MISS_DATE,
290 LAST_UPDATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
291 CREATION_DATE DATE , -- := FND_API.G_MISS_DATE,
292 CREATED_BY NUMBER , -- := FND_API.G_MISS_NUM,
293 LAST_UPDATE_LOGIN NUMBER , -- := FND_API.G_MISS_NUM,
294 QUAL_USG_ID NUMBER , -- := FND_API.G_MISS_NUM,
295 TERR_TYPE_ID NUMBER , -- := FND_API.G_MISS_NUM,
296 EXCLUSIVE_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
297 OVERLAP_ALLOWED_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
298 IN_USE_FLAG VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
299 QUALIFIER_MODE VARCHAR2(30) , -- := FND_API.G_MISS_CHAR,
300 ORG_ID NUMBER -- := FND_API.G_MISS_NUM
301 );
302
303 G_MISS_TerrTypeQUAL_REC TerrTypequal_rec_type;
304
305 TYPE TerrTypequal_tbl_type IS TABLE OF TerrTypequal_rec_type
306 INDEX BY BINARY_INTEGER;
307
308 G_MISS_TerrTypeQUAL_TBL TerrTypequal_tbl_type;
309
310
311 -- ***************************************************
312 -- Start of Comments
313 -- ---------------------------------------------------
314 -- Territory Type Qualifier Record: TerrTypequal_out_rec_type
315 -- ---------------------------------------------------
316 -- Parameters:
317 --
318 -- Required:
319 --
320 -- Defaults:
321 -- Note:
322 -- End of Comments
323
324 TYPE TerrTypequal_out_rec_type IS RECORD
325 (
326 TERR_TYPE_QUAL_ID NUMBER , -- := FND_API.G_MISS_NUM,
327 return_status VARCHAR2(1) -- := FND_API.G_MISS_CHAR
328 );
329
330 G_MISS_TerrTypeQUAL_OUT_REC TerrTypequal_out_rec_type;
331
332 TYPE TerrTypequal_out_tbl_type IS TABLE OF TerrTypequal_out_rec_type
333 INDEX BY BINARY_INTEGER;
334
335 G_MISS_TerrTypeQUAL_OUT_TBL TerrTypequal_out_tbl_type;
336
337 -- ***************************************************
338 -- start of comments
339 -- ***************************************************
343 -- pre-reqs : Territory qualifiers has to be enabled.
340 -- api name : create_terrtype
341 -- type : public.
342 -- function : creates territory type defnitions
344 -- parameters :
345
346 -- in:
347 -- p_api_version_number in number required
348 -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
349 -- p_commit in varchar2 optional --default = fnd_api.g_false
350 -- p_TerrType_rec in TerrType_rec_type required --default = g_miss_TerrType_rec,
351 -- p_TerrTypequal_tbl in TerrTypequal_tbl_type required --default = g_miss_TerrTypequal_rec,
352 -- p_TerrTypeusgs_tbl in TerrTypeusgs_rec_type required --default = g_miss_tersrc_rec
353 -- p_TypequalTypeusgs_tbl in TypeQualTypeUsgs_tbl_type required --default = g_miss_tersrc_tbl,
354 --
355 -- out:
356 -- p_return_status out varchar2(1)
357 -- p_msg_count out number
358 -- p_msg_data out varchar2(2000)
359 -- p_TerrType_id out number
360 -- p_TerrTypequal_out_tbl out TerrTypequal_out_tbl_type
361 -- p_TerrTypeusgs_out_tbl out TerrTypeusgs_out_tbl_type
362 -- p_TypeQualTypeUsgs_out_tbl out TypeQualTypeUsgs_out_tbl_type
363 --
364 -- requirements :
365 -- business rules :
366
367 -- version : current version 1.0
368 -- initial version: initial version 1.0
369 --
370 -- notes: api for creating territory types
371 --
372 -- end of comments
373
374 procedure create_terrtype
375 ( p_api_version_number in number,
376 p_init_msg_list in varchar2 := fnd_api.g_false,
377 p_commit in varchar2 := fnd_api.g_false,
378 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
379 p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
380 p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,
381 p_TerrTypeusgs_tbl in TerrTypeusgs_tbl_type := g_miss_TerrTypeusgs_tbl,
382 p_TypeQualTypeUsgs_tbl in TypeQualTypeUsgs_tbl_type := g_miss_typeQualTypeUsgs_tbl,
383 x_return_status OUT NOCOPY varchar2,
384 x_msg_count OUT NOCOPY number,
385 x_msg_data OUT NOCOPY varchar2,
386 x_TerrType_id OUT NOCOPY number,
387 x_TerrTypequal_out_tbl OUT NOCOPY TerrTypequal_out_tbl_type,
388 x_TerrTypeusgs_out_tbl OUT NOCOPY TerrTypeusgs_out_tbl_type,
389 x_TypeQualTypeUsgs_out_tbl OUT NOCOPY TypeQualTypeUsgs_out_tbl_type
390 );
391
392
393 -- ***************************************************
394 -- start of comments
395 -- ***************************************************
396 -- api name : update_Terrtype
397 -- type : public.
398 -- function : Update territory type defnitions
399 -- pre-reqs : Territory qualifiers has to be enabled.
400 -- parameters :
401
402 -- in:
403 -- p_api_version_number in number required
404 -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
405 -- p_commit in varchar2 optional --default = fnd_api.g_false
406 -- p_TerrType_rec in TerrType_rec_type required --default = g_miss_TerrType_rec,
407 -- p_TerrTypequal_tbl in TerrTypequal_tbl_type required --default = g_miss_TerrTypequal_rec,
408 -- p_TerrTypesrc_tbl in TerrTypesrc_rec_type required --default = g_miss_tersrc_rec
409 -- p_TerrTypeSrcType_tbl in TerrTypeSrcType_tbl_type required --default = g_miss_tersrc_tbl,
410 -- out:
411 -- p_return_status OUT NOCOPY varchar2(1)
412 -- p_msg_count OUT NOCOPY number
413 -- p_msg_data OUT NOCOPY varchar2(2000)
414 -- p_TerrTypequal_out_tbl OUT NOCOPY TerrTypequal_out_tbl_type,
415 -- p_TerrTypesrc_out_tbl OUT NOCOPY TerrTypeSrc_out_tbl_type,
416 -- p_TerrTypeSrcType_out_tbl OUT NOCOPY TerrTypeSrcType_out_tbl_type
417 --
418 -- requirements :
419 -- business rules :
420
421 -- version : current version 1.0
422 -- initial version: initial version 1.0
423 --
424 -- notes: api for Updating territory types
425 --
426 -- end of comments
427
428 procedure Update_Terrtype
429 ( p_api_version_number in number,
430 p_init_msg_list in varchar2 := fnd_api.g_false,
431 p_commit in varchar2 := fnd_api.g_false,
432 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433 p_TerrType_rec in TerrType_rec_type := g_miss_TerrType_rec,
434 p_TerrTypequal_tbl in TerrTypequal_tbl_type := g_miss_TerrTypequal_tbl,
435 p_TerrTypeUsgs_tbl in TerrTypeusgs_tbl_type := g_miss_TerrTypeusgs_tbl,
436 p_TypeQualTypeUsgs_tbl in TypeQualTypeUsgs_tbl_type := g_miss_TypeQualTypeUsgs_tbl,
437 x_return_status OUT NOCOPY varchar2,
438 x_msg_count OUT NOCOPY number,
439 x_msg_data OUT NOCOPY varchar2,
443 x_TypeQualTypeUsgs_out_tbl OUT NOCOPY TypeQualTypeUsgs_out_tbl_type
440 x_TerrType_out_rec OUT NOCOPY TerrType_out_rec_type,
441 x_TerrTypequal_out_tbl OUT NOCOPY TerrTypequal_out_tbl_type,
442 x_TerrTypeUsgs_out_tbl OUT NOCOPY TerrTypeusgs_out_tbl_type,
444 );
445
446 -- ***************************************************
447 -- start of comments
448 -- ***************************************************
449 -- api name : Delete_TerrType
450 -- type : public.
451 -- function : Delete territory type defnitions
452 -- pre-reqs : Territory qualifiers has to be enabled.
453 -- parameters :
454 --
455 -- in:
456 -- p_api_version_number in number required
457 -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
458 -- p_commit in varchar2 optional --default = fnd_api.g_false
459 -- p_TerrType_id in number
460 --
461 -- out:
462 -- p_return_status OUT NOCOPY varchar2(1)
463 -- p_msg_count OUT NOCOPY number
464 -- p_msg_data OUT NOCOPY varchar2(2000)
465 --
466 -- requirements :
467 -- business rules :
468
469 -- version : current version 1.0
470 -- initial version: initial version 1.0
471 --
472 -- notes: API for Deleting territory types
473 --
474 -- end of comments
475
476 procedure Delete_TerrType
477 ( p_api_version_number in number,
478 p_init_msg_list in varchar2 := fnd_api.g_false,
479 p_commit in varchar2 := fnd_api.g_false,
480 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
481 p_TerrType_id in number,
482 x_return_status OUT NOCOPY varchar2,
483 x_msg_count OUT NOCOPY number,
484 X_msg_data OUT NOCOPY varchar2
485 );
486
487
488
489
490 -- ***************************************************
491 -- start of comments
492 -- ***************************************************
493 -- api name : Deactivate_TerrType
494 -- type : public.
495 -- function : Deactivate territory type defnitions
496 -- pre-reqs : Territory qualifiers has to be enabled.
497 -- parameters :
498 --
499 -- in:
500 -- p_api_version_number in number required
501 -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
502 -- p_commit in varchar2 optional --default = fnd_api.g_false
503 -- p_TerrType_id in number
504 --
505 -- out:
506 -- p_return_status OUT NOCOPY varchar2(1)
507 -- p_msg_count OUT NOCOPY number
508 -- p_msg_data OUT NOCOPY varchar2(2000)
509 --
510 -- requirements :
511 -- business rules :
512
513 -- version : current version 1.0
514 -- initial version: initial version 1.0
515 --
516 -- notes: API for Deleting territory types
517 --
518 -- end of comments
519
520 procedure Deactivate_TerrType
521 ( p_api_version_number in number,
522 p_init_msg_list in varchar2 := fnd_api.g_false,
523 p_commit in varchar2 := fnd_api.g_false,
524 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
525 p_TerrType_id in number,
526 x_return_status OUT NOCOPY varchar2,
527 x_msg_count OUT NOCOPY number,
528 x_msg_data OUT NOCOPY varchar2
529 );
530
531
532
533 -- ***************************************************
534 -- start of comments
535 -- ***************************************************
536 -- api name : Copy_TerrType
537 -- type : public.
538 -- function : Copy_territory type defnitions
539 -- pre-reqs : Territory qualifiers has to be enabled.
540 -- parameters :
541 --
542 -- in:
543 -- p_api_version_number in number required
544 -- p_init_msg_list in varchar2 optional --default = fnd_api.g_false
545 -- p_commit in varchar2 optional --default = fnd_api.g_false
546 -- p_TerrType_id in number
547 -- p_TerrType_Name in varchar2
548 -- p_TerrType_Description in varchar2
549 -- p_Enabled_Flag in varchar2
550 -- p_Start_Date in date
551 -- p_End_Date in date
552 --
553 -- out:
554 -- p_return_status OUT NOCOPY varchar2(1)
555 -- p_msg_count OUT NOCOPY number
556 -- p_msg_data OUT NOCOPY varchar2(2000)
557 --
558 -- requirements :
559 -- business rules :
560
561 -- version : current version 1.0
562 -- initial version: initial version 1.0
563 --
564 -- notes: API for Copying territory types
565 --
566 -- end of comments
567
568 procedure Copy_TerrType
569 ( p_api_version_number in number,
570 p_init_msg_list in varchar2 := fnd_api.g_false,
571 p_commit in varchar2 := fnd_api.g_false,
575 p_TerrType_Description in varchar2,
572 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573 p_TerrType_id in number,
574 p_TerrType_Name in varchar2,
576 p_Enabled_Flag in varchar2,
577 p_Start_Date in date,
578 p_End_Date in date,
579 x_return_status OUT NOCOPY varchar2,
580 x_msg_count OUT NOCOPY number,
581 X_msg_data OUT NOCOPY varchar2,
582 x_TerrType_id OUT NOCOPY number
583 );
584
585
586
587 --
588 -- ***************************************************
589 -- start of comments
590 -- ***************************************************
591 -- API name : Create_TerrType_Header
592 -- Type : PUBLIC
593 -- Function : To create Territories Types - which inludes the creation of following
594 -- Territory Type Header, Territory Type Usages, Territory Type qualifier
595 -- type usages table.
596 -- Pre-reqs :
597 -- Parameters:
598 -- IN :
599 -- Required
600 -- Parameter Name Data Type Default
601 -- P_Api_Version_Number NUMBER
602 -- P_TerrType_Rec TerrType_Rec_Type := G_Miss_TerrType_Rec
603 -- P_TerrTypeUsgs_Tbl TerrTypeusgs_Tbl_Type := G_MISS_TerrTypeusgs_Tbl
604 -- P_TypeQualTypeUsgs_Tbl TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl
605 --
606 -- Optional
607 -- Parameter Name Data Type Default
608 -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
609 -- P_Commit VARCHAR2 := FND_API.G_FALSE
610 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL,
611 --
612 -- OUT NOCOPY :
613 -- Parameter Name Data Type
614 -- X_Return_Status VARCHAR2(1)
615 -- X_Msg_Count NUMBER
616 -- X_Msg_Data VARCHAR2(2000)
617 -- X_TerrType_Out_Rec TerrType_Out_Rec_Type
618 -- X_TerrTypeusgs_Out_Tbl TerrTypeusgs_Out_Tbl_Type
619 -- X_TypeQualTypeUsgs_Out_Tbl TypeQualTypeUsgs_Out_Tbl_Type
620 --
621 --
622 -- Notes:
623 --
624 --
625 -- End of Comments
626 --
627 PROCEDURE Create_TerrType_Header
628 (P_Api_Version_Number IN NUMBER,
629 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
630 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
631 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
632 P_TerrType_Rec IN TerrType_Rec_Type := G_Miss_TerrType_Rec,
633 P_TerrTypeUsgs_Tbl IN TerrTypeusgs_Tbl_Type := G_MISS_TerrTypeusgs_Tbl,
634 P_TypeQualTypeUsgs_Tbl IN TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl,
635 X_Return_Status OUT NOCOPY VARCHAR2,
636 X_Msg_Count OUT NOCOPY NUMBER,
637 X_Msg_Data OUT NOCOPY VARCHAR2,
638 X_TerrType_Out_Rec OUT NOCOPY TerrType_Out_Rec_Type,
639 X_TerrTypeusgs_Out_Tbl OUT NOCOPY TerrTypeusgs_Out_Tbl_Type,
640 X_TypeQualTypeUsgs_Out_Tbl OUT NOCOPY TypeQualTypeUsgs_Out_Tbl_Type);
641
642 --
643 -- ***************************************************
644 -- start of comments
645 -- ***************************************************
646 -- API name : Create_TerrType_record
647 -- Type : PUBLIC
648 -- Function : To create a records in jtf_Terr_Type_all table
649 --
650 -- Pre-reqs :
651 -- Parameters:
652 -- IN :
653 -- Required
654 -- Parameter Name Data Type Default
655 -- X_TerrType_Rec TerrType_Rec_Type := G_Miss_TerrType_Rec,
656 --
657 -- OUT NOCOPY :
658 -- Parameter Name Data Type
659 -- X_terr_id NUMBER;
660 -- X_Return_Status VARCHAR2(1)
661 -- X_TerrType_Out_Rec TerrType_Out_Rec_Type
662 --
663 --
664 -- Notes:
665 --
666 --
667 -- End of Comments
668 --
669 PROCEDURE Create_TerrType_Record
670 ( P_Api_Version_Number IN NUMBER,
671 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
672 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
673 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
674 P_TerrType_Rec IN TerrType_Rec_Type := G_Miss_TerrType_Rec,
675 X_Return_Status OUT NOCOPY VARCHAR2,
676 X_Msg_Count OUT NOCOPY NUMBER,
677 X_Msg_Data OUT NOCOPY VARCHAR2,
678 X_TerrType_Id OUT NOCOPY NUMBER,
679 X_TerrType_Out_Rec OUT NOCOPY TerrType_Out_Rec_Type
680 );
681
682 --
683 -- ***************************************************
684 -- start of comments
685 -- ***************************************************
686 -- API name : Create_TerrType_Usages
687 -- Type : PUBLIC
688 -- Function : To create Territories Type usages
689 --
690 -- Pre-reqs :
694 -- Parameter Name Data Type Default
691 -- Parameters:
692 -- IN :
693 -- Required
695 -- p_terr_id NUMBER;
696 -- P_TerrTypeUsgs_Tbl TerrTypeUsgs_Tbl_Type := G_MISS_TerrTypeUsgs_Tbl
697 --
698 -- OUT NOCOPY :
699 -- Parameter Name Data Type
700 -- X_Return_Status VARCHAR2(1)
701 -- X_TerrTypeUsgs_Out_Tbl TerrTypeUsgs_Out_Tbl,
702 --
703 --
704 -- Notes:
705 --
706 --
707 -- End of Comments
708 --
709 PROCEDURE Create_TerrType_Usages
710 ( P_Api_Version_Number IN NUMBER,
711 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
712 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
713 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
714 P_TerrType_Id IN NUMBER,
715 P_TerrTypeUsgs_Tbl IN TerrTypeUsgs_Tbl_Type := G_MISS_TerrTypeUsgs_Tbl,
716 X_Return_Status OUT NOCOPY VARCHAR2,
717 X_Msg_Count OUT NOCOPY NUMBER,
718 X_Msg_Data OUT NOCOPY VARCHAR2,
719 X_TerrTypeUsgs_Out_Tbl OUT NOCOPY TerrTypeUsgs_Out_Tbl_Type
720 );
721
722 -- ***************************************************
723 -- start of comments
724 -- ***************************************************
725 -- API name : Create_TerrTypeQualType_Usage
726 -- Type : PUBLIC
727 -- Function : To create Territory type qualifier type
728 -- usages
729 --
730 -- Pre-reqs :
731 -- Parameters:
732 -- IN :
733 -- Required
734 -- Parameter Name Data Type Default
735 -- p_terr_id NUMBER
736 -- p_terr_usg_id NUMBER;
737 -- P_Terr_QualTypeUsgs_Rec Terr_QualTypeUsgs_Rec_Type := G_Miss_Terr_QualTypeUsgs_Rec
738 --
739 -- OUT NOCOPY :
740 -- Parameter Name Data Type
741 -- X_Return_Status VARCHAR2(1)
742 -- X_Terr_QualTypeUsgs_Out_Tbl Terr_QualTypeUsgs_Out_Tbl,
743 --
744 -- Notes:
745 --
746 --
747 -- End of Comments
748 --
749 PROCEDURE Create_TerrTypeQualType_Usage
750 (P_Api_Version_Number IN NUMBER,
751 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
752 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
753 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
754 P_TerrType_Id IN NUMBER,
755 P_TerrTypeUsg_Id IN NUMBER,
756 P_TypeQualTypeUsgs_Rec IN TypeQualTypeUsgs_Rec_Type := G_Miss_TypeQualTypeUsgs_Rec,
757 X_Return_Status OUT NOCOPY VARCHAR2,
758 X_Msg_Count OUT NOCOPY NUMBER,
759 X_Msg_Data OUT NOCOPY VARCHAR2,
760 X_TypeQualTypeUsgs_Id OUT NOCOPY NUMBER,
761 X_TypeQualTypeUsgs_Out_Rec OUT NOCOPY TypeQualTypeUsgs_Out_Rec_Type
762 );
763
764
765 --
766 -- ***************************************************
767 -- start of comments
768 -- ***************************************************
769 -- API name : Create_TerrTypeQualType_Usage
770 -- Type : PUBLIC
771 -- Function : To create Territories type qualifier usages
772 --
773 -- Pre-reqs :
774 -- Parameters:
775 -- IN :
776 -- Required
777 -- Parameter Name Data Type Default
778 -- P_TerrType_Id NUMBER
779 -- P_TerrTypeUsg_Id NUMBER;
780 -- P_TypeQualTypeUsgs_Tbl TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl
781 --
782 -- OUT NOCOPY :
783 -- Parameter Name Data Type
784 -- X_Return_Status VARCHAR2(1)
785 -- X_TypeQualTypeUsgs_Out_Tbl TypeQualTypeUsgs_Out_Tbl,
786 --
787 -- Notes:
788 --
789 --
790 -- End of Comments
791 --
792 PROCEDURE Create_TerrTypeQualType_Usage
793 (P_Api_Version_Number IN NUMBER,
794 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
795 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
796 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
797 P_TerrType_Id IN NUMBER,
798 P_TerrTypeUsg_Id IN NUMBER,
799 P_TypeQualTypeUsgs_Tbl IN TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl,
800 X_Return_Status OUT NOCOPY VARCHAR2,
801 X_Msg_Count OUT NOCOPY NUMBER,
802 X_Msg_Data OUT NOCOPY VARCHAR2,
803 X_TypeQualTypeUsgs_Out_Tbl OUT NOCOPY TypeQualTypeUsgs_Out_Tbl_Type);
804
805 --
806 -- ***************************************************
807 -- start of comments
808 -- ***************************************************
809 -- API name : Create_TerrType_QualIfier
810 -- Type : PUBLIC
811 -- Function : To create Territories qualifier
812 --
813 --
814 -- Pre-reqs :
815 -- Parameters:
816 -- IN :
817 -- Required
821 --
818 -- Parameter Name Data Type Default
819 -- p_terrType_id NUMBER
820 -- P_TerrTypeQual_Rec TerrTypeQual_Rec_Type := G_Miss_TerrTypeQual_Rec
822 -- OUT NOCOPY :
823 -- Parameter Name Data Type
824 -- X_TerrTypeQual_Id NUMBER
825 -- X_Return_Status VARCHAR2(1)
826 -- X_TerrTypeQual_Out_Rec TerrTypeQual_Out_Rec
827 --
828 -- Notes: This is a an overloaded procedure
829 --
830 --
831 -- End of Comments
832 --
833 PROCEDURE Create_TerrType_Qualifier
834 (P_Api_Version_Number IN NUMBER,
835 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
836 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
837 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
838 P_TerrType_Id IN NUMBER,
839 P_TerrTypeQual_Rec IN TerrTypeQual_Rec_Type := G_Miss_TerrTypeQual_Rec,
840 X_Return_Status OUT NOCOPY VARCHAR2,
841 X_Msg_Count OUT NOCOPY NUMBER,
842 X_Msg_Data OUT NOCOPY VARCHAR2,
843 X_TerrTypeQual_Id OUT NOCOPY NUMBER,
844 X_TerrTypeQual_Out_Rec OUT NOCOPY TerrTypeQual_Out_Rec_Type);
845
846
847 --
848 -- ***************************************************
849 -- start of comments
850 -- ***************************************************
851 -- API name : Create_TerrType_Qualifier
852 -- Type : PUBLIC
853 -- Function : To create Territories type qualifier
854 --
855 -- Pre-reqs :
856 -- Parameters:
857 -- IN :
858 -- Required
859 -- Parameter Name Data Type Default
860 -- p_terrType_id NUMBER
861 -- P_TerrTypeQual_Tbl TerrTypeQual_Tbl_Type := G_Miss_TerrTypeQual_Tbl
862 --
863 -- OUT NOCOPY :
864 -- Parameter Name Data Type
865 -- X_Return_Status VARCHAR2(1)
866 -- X_TerrTypeQual_Out_Tbl TerrTypeQual_Out_Tbl
867 --
868 -- Notes: This is a an overloaded procedure. This one
869 -- will call the overloade procedure for records
870 -- creation
871 --
872 --
873 -- End of Comments
874 --
875 PROCEDURE Create_TerrType_Qualifier
876 (P_Api_Version_Number IN NUMBER,
877 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
878 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
879 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
880 P_TerrType_Id IN NUMBER,
881 P_TerrTypeQual_Tbl IN TerrTypeQual_Tbl_Type := G_Miss_TerrTypeQual_Tbl,
882 X_Return_Status OUT NOCOPY VARCHAR2,
883 X_Msg_Count OUT NOCOPY NUMBER,
884 X_Msg_Data OUT NOCOPY VARCHAR2,
885 X_TerrTypeQual_Out_Tbl OUT NOCOPY TerrTypeQual_Out_Tbl_Type);
886
887 --
888 -- *******************************************************
889 -- Start of Comments
890 -- *******************************************************
891 -- API Name: Update_TerrType_Record
892 -- Type :
893 -- Pre-Req :
894 -- Parameters:
895 -- IN
896 -- Required:
897 -- Parameter Name Data Type Default
898 -- P_TerrType_Rec TerrType_Rec_Type := G_MISS_TERRTYPE_REC
899 --
900 -- Optional:
901 -- OUT:
902 -- Parameter Name Data Type Default
903 -- X_Return_Status VARCHAR2
904 -- X_TerrType_Out_rec TerrType_Out_Rec_Type
905 --
906 -- Note:
907 --
908 -- End of Comments
909 --
910 PROCEDURE Update_TerrType_Record
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_TerrType_Rec IN TerrType_Rec_Type := G_MISS_TERRTYPE_REC,
916 X_Return_Status OUT NOCOPY VARCHAR2,
917 X_Msg_Count OUT NOCOPY NUMBER,
918 X_Msg_Data OUT NOCOPY VARCHAR2,
919 X_TerrType_Out_rec OUT NOCOPY TerrType_Out_Rec_Type);
920
921 --
922 -- *******************************************************
923 -- Start of Comments
924 -- *******************************************************
925 -- API Name: Update_TerrType_Usages
926 -- Type :
927 -- Pre-Req :
928 -- Parameters:
929 -- IN
930 -- Required:
931 -- Parameter Name Data Type Default
932 -- P_TerrTypeUsgs_Rec TerrTypeUsgs_Rec_Type := G_MISS_TERRTYPEUSGS_REC
933 --
934 -- Optional:
935 -- OUT:
936 -- Parameter Name Data Type Default
937 -- X_Return_Status VARCHAR2
938 -- X_TerrTypeUsgs_Out_Rec TerrTypeUsgs_Out_Rec_Type
939 --
940 --
941 -- Note:
942 --
943 -- End of Comments
944 --
945 PROCEDURE Update_TerrType_Usages
946 (P_Api_Version_Number IN NUMBER,
950 P_TerrTypeUsgs_Rec IN TerrTypeUsgs_Rec_Type := G_MISS_TERRTYPEUSGS_REC,
947 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
948 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
949 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
951 X_Return_Status OUT NOCOPY VARCHAR2,
952 X_Msg_Count OUT NOCOPY NUMBER,
953 X_Msg_Data OUT NOCOPY VARCHAR2,
954 X_TerrTypeUsgs_Out_Rec OUT NOCOPY TerrTypeUsgs_Out_Rec_Type
955 );
956
957
958 --
959 -- *******************************************************
960 -- Start of Comments
961 -- *******************************************************
962 -- API Name: Update_TerrType_Usages
963 -- Type :
964 -- Pre-Req :
965 -- Parameters:
966 -- IN
967 -- Required:
968 -- Parameter Name Data Type Default
969 -- P_TerrTypeUsgs_Tbl TerrTypeUsgs_Tbl_Type := G_MISS_TERRTYPEUSGS_TBL
970 --
971 -- Optional:
972 -- OUT:
973 -- Parameter Name Data Type Default
974 -- X_Return_Status VARCHAR2
975 -- X_TerrTypeUsgs_Out_Tbl TerrTypeUsgs_Out_Tbl_Type
976 --
977 --
978 -- Note:
979 --
980 -- End of Comments
981 --
982 PROCEDURE Update_TerrType_Usages
983 (P_Api_Version_Number IN NUMBER,
984 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
985 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
986 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987 P_TerrTypeUsgs_Tbl IN TerrTypeUsgs_Tbl_Type := G_MISS_TERRTYPEUSGS_TBL,
988 X_Return_Status OUT NOCOPY VARCHAR2,
989 X_Msg_Count OUT NOCOPY NUMBER,
990 X_Msg_Data OUT NOCOPY VARCHAR2,
991 X_TerrTypeUsgs_Out_Tbl OUT NOCOPY TerrTypeUsgs_Out_Tbl_Type);
992
993
994 --
995 -- *******************************************************
996 -- Start of Comments
997 -- *******************************************************
998 -- API Name: Update_TerrTypeQualType_Usage
999 -- Type :
1000 -- Pre-Req :
1001 -- Parameters:
1002 -- IN
1003 -- Required:
1004 -- Parameter Name Data Type Default
1005 --
1006 -- Optional:
1007 -- OUT:
1008 -- Parameter Name Data Type Default
1009 --
1010 -- Note:
1011 --
1012 -- End of Comments
1013 --
1014 PROCEDURE Update_TerrTypeQualType_Usage
1015 (P_Api_Version_Number IN NUMBER,
1016 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1017 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1018 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1019 P_TypeQualTypeUsgs_Rec IN TypeQualTypeUsgs_Rec_Type := G_Miss_TypeQualTypeUsgs_Rec,
1020 X_Return_Status OUT NOCOPY VARCHAR2,
1021 X_Msg_Count OUT NOCOPY NUMBER,
1022 X_Msg_Data OUT NOCOPY VARCHAR2,
1023 X_TypeQualTypeUsgs_Out_Rec OUT NOCOPY TypeQualTypeUsgs_Out_Rec_Type);
1024
1025
1026 --
1027 -- *******************************************************
1028 -- Start of Comments
1029 -- *******************************************************
1030 -- API Name: Update_TerrTypeQualType_Usage
1031 -- Type :
1032 -- Pre-Req :
1033 -- Parameters:
1034 -- IN
1035 -- Required:
1036 -- Parameter Name Data Type Default
1037 --
1038 -- Optional:
1039 -- OUT:
1040 -- Parameter Name Data Type Default
1041 --
1042 -- Note:
1043 --
1044 -- End of Comments
1045 --
1046 PROCEDURE Update_TerrTypeQualType_Usage
1047 (P_Api_Version_Number IN NUMBER,
1048 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1049 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1050 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1051 P_TypeQualTypeUsgs_Tbl IN TypeQualTypeUsgs_Tbl_Type := G_Miss_TypeQualTypeUsgs_Tbl,
1052 X_Return_Status OUT NOCOPY VARCHAR2,
1053 X_Msg_Count OUT NOCOPY NUMBER,
1054 X_Msg_Data OUT NOCOPY VARCHAR2,
1055 X_TypeQualTypeUsgs_Out_Tbl OUT NOCOPY TypeQualTypeUsgs_Out_Tbl_Type);
1056
1057 --
1058 -- *******************************************************
1059 -- Start of Comments
1060 -- *******************************************************
1061 -- API Name: Update_TerrType_Qualifier
1062 -- Type :
1063 -- Pre-Req :
1064 -- Parameters:
1065 -- IN :
1066 -- Required
1067 -- Parameter Name Data Type Default
1068 -- P_TerrTypeQual_Rec TerrTypeQual_Rec_Type := G_Miss_TerrTypeQual_Rec
1069 --
1070 -- OUT NOCOPY :
1071 -- Parameter Name Data Type
1072 -- X_Return_Status VARCHAR2
1073 -- X_Terr_Qual_Out_Rec Terr_Qual_Out_Rec_Type
1074 --
1075 -- Note:
1076 --
1080 (P_Api_Version_Number IN NUMBER,
1077 -- End of Comments
1078 --
1079 PROCEDURE Update_TerrType_Qualifier
1081 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1082 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1083 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1084 P_TerrTypeQual_Rec IN TerrTypeQual_Rec_Type := G_Miss_TerrTypeQual_Rec,
1085 X_Return_Status OUT NOCOPY VARCHAR2,
1086 X_Msg_Count OUT NOCOPY NUMBER,
1087 X_Msg_Data OUT NOCOPY VARCHAR2,
1088 X_TerrTypeQual_Out_Rec OUT NOCOPY TerrTypeQual_Out_Rec_Type);
1089
1090 --
1091 -- *******************************************************
1092 -- Start of Comments
1093 -- *******************************************************
1094 -- API Name: Update_TerrType_Qualifier
1095 -- Type :
1096 -- Pre-Req :
1097 -- Parameters:
1098 -- IN :
1099 -- Required
1100 -- Parameter Name Data Type Default
1101 -- P_TerrTypeQual_Tbl TerrTypeQual_Tbl_Type := G_Miss_TerrTypeQual_Tbl
1102 --
1103 -- OUT NOCOPY :
1104 -- Parameter Name Data Type
1105 -- X_Return_Status VARCHAR2
1106 -- X_TerrTypeQual_Out_Tbl TerrTypeQual_Out_Tbl_Type
1107 --
1108 -- Note:
1109 --
1110 -- End of Comments
1111 --
1112 PROCEDURE Update_TerrType_Qualifier
1113 (P_Api_Version_Number IN NUMBER,
1114 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1115 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1117 P_TerrTypeQual_Tbl IN TerrTypeQual_Tbl_Type := G_Miss_TerrTypeQual_Tbl,
1118 X_Return_Status OUT NOCOPY VARCHAR2,
1119 X_Msg_Count OUT NOCOPY NUMBER,
1120 X_Msg_Data OUT NOCOPY VARCHAR2,
1121 X_TerrTypeQual_Out_Tbl OUT NOCOPY TerrTypeQual_Out_Tbl_Type);
1122
1123 --
1124 -- *******************************************************
1125 -- Start of Comments
1126 -- *******************************************************
1127 -- API Name: Delete_TerrType_Qualifier
1128 -- Type :
1129 -- Pre-Req :
1130 -- Parameters:
1131 -- IN
1132 -- Required:
1133 -- Parameter Name Data Type Default
1134 -- P_Api_Version_Number NUMBER,
1135 -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1136 -- P_Commit VARCHAR2
1137 -- P_TerrTypeQual_Id NUMBER
1138 --
1139 -- Optional:
1140 -- OUT:
1141 -- Parameter Name Data Type Default
1142 -- X_Return_Status VARCHAR2
1143 --
1144 -- Note:
1145 --
1146 -- End of Comments
1147 --
1148 PROCEDURE Delete_TerrType_Qualifier
1149 (P_Api_Version_Number IN NUMBER,
1150 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1151 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1152 P_TerrTypeQual_Id IN NUMBER,
1153 X_Return_Status OUT NOCOPY VARCHAR2,
1154 X_Msg_Count OUT NOCOPY VARCHAR2,
1155 X_Msg_Data OUT NOCOPY VARCHAR2);
1156
1157 --
1158 -- *******************************************************
1159 -- Start of Comments
1160 -- *******************************************************
1161 -- API Name: Delete_TerrTypeQualType_Usage
1162 -- Type :
1163 -- Pre-Req :
1164 -- Parameters
1165 -- IN
1166 -- Required:
1167 -- Parameter Name Data Type Default
1168 -- P_Api_Version_Number NUMBER,
1169 -- P_Init_Msg_List VARCHAR2 := FND_API.G_FALSE
1170 -- P_Commit VARCHAR2 := FND_API.G_FALSE
1171 -- P_Terr_Qual_Type_Usg_Id NUMBER
1172 --
1173 -- Optional:
1174 -- OUT:
1175 -- Parameter Name Data Type Default
1176 -- X_Return_Status VARCHAR2
1177 --
1178 -- Note:
1179 --
1180 -- End of Comments
1181 --
1182 PROCEDURE Delete_TerrTypeQualType_Usage
1183 (P_Api_Version_Number IN NUMBER,
1184 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1185 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1186 P_TerrTypeQualType_Usg_Id IN NUMBER,
1187 X_Return_Status OUT NOCOPY VARCHAR2,
1188 X_Msg_Count OUT NOCOPY VARCHAR2,
1189 X_Msg_Data OUT NOCOPY VARCHAR2);
1190
1191 --
1192 -- *******************************************************
1193 -- Start of Comments
1194 -- *******************************************************
1195 -- API Name: Delete_TerrType_Usages
1196 -- Type :
1197 -- Pre-Req :
1198 -- Parameters:
1199 -- IN
1200 -- Required:
1201 -- Parameter Name Data Type Default
1202 -- P_Api_Version_Number NUMBER,
1203 -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1204 -- P_Commit VARCHAR2
1205 -- P_TerrTypeUsg_Id NUMBER
1206 --
1207 -- Optional:
1208 -- OUT:
1209 -- Parameter Name Data Type Default
1210 -- X_Return_Status VARCHAR2
1211 --
1212 -- Note:
1213 --
1214 -- End of Comments
1215 --
1216 PROCEDURE Delete_TerrType_Usages
1217 (P_Api_Version_Number IN NUMBER,
1218 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1219 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1220 P_TerrTypeUsg_Id IN NUMBER,
1221 X_Return_Status OUT NOCOPY VARCHAR2,
1222 X_Msg_Count OUT NOCOPY VARCHAR2,
1223 X_Msg_Data OUT NOCOPY VARCHAR2);
1224
1225 --
1226 -- *******************************************************
1227 -- Start of Comments
1228 -- *******************************************************
1229 -- API Name: Delete_TerrType_Record
1230 -- Type :
1231 -- Pre-Req :
1232 -- Parameters:
1233 -- IN
1234 -- Required:
1235 -- Parameter Name Data Type Default
1236 -- P_Api_Version_Number NUMBER,
1237 -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
1238 -- P_Commit VARCHAR2
1239 -- P_TerrType_Id NUMBER
1240 --
1241 -- Optional:
1242 -- OUT:
1243 -- Parameter Name Data Type Default
1244 -- X_Return_Status VARCHAR2
1245 --
1246 -- Note:
1247 --
1248 -- End of Comments
1249 --
1250 PROCEDURE Delete_TerrType_Record
1251 (P_Api_Version_Number IN NUMBER,
1252 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1253 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1254 P_TerrType_Id IN NUMBER,
1255 X_Return_Status OUT NOCOPY VARCHAR2,
1256 X_Msg_Count OUT NOCOPY VARCHAR2,
1257 X_Msg_Data OUT NOCOPY VARCHAR2);
1258
1259 --
1260 -- Validate the Territory Type RECORD
1261 -- Validate Territory Type Name and other not null columns
1262 PROCEDURE Validate_TerrType_Record
1263 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1264 p_Terr_Type_Rec IN TerrType_Rec_Type := G_Miss_TerrType_Rec,
1265 x_Return_Status OUT NOCOPY VARCHAR2,
1266 x_msg_count OUT NOCOPY NUMBER,
1267 x_msg_data OUT NOCOPY VARCHAR2 );
1268
1269 --
1270 -- This procedure will check whether the qualifiers passed are
1271 -- valid.
1272 --
1273 PROCEDURE Validate_Qualifier
1274 (P_TerrTypequal_Rec IN TerrTypeQual_Rec_Type := G_Miss_TerrTypequal_Rec,
1275 p_Terr_Type_Id IN NUMBER,
1276 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1277 x_Return_Status OUT NOCOPY VARCHAR2,
1278 x_msg_count OUT NOCOPY NUMBER,
1279 x_msg_data OUT NOCOPY VARCHAR2 );
1280
1281 ---------------------------------------------------------------------
1282 -- Validate the Territory Type Usage
1283 ---------------------------------------------------------------------
1284 -- Columns Validated
1285 -- Make sure a Territory Type Usage is specified
1286 -- Make sure the Territory Type Id is valid
1287 -- Make sure the territory Type usage Id is Valid
1288 ---------------------------------------------------------------------
1289 PROCEDURE Validate_TerrType_Usage
1290 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1291 x_Return_Status OUT NOCOPY VARCHAR2,
1292 x_msg_count OUT NOCOPY NUMBER,
1293 x_msg_data OUT NOCOPY VARCHAR2,
1294 p_TerrTypeusgs_Rec IN TerrTypeusgs_Rec_Type := G_MISS_TerrTypeusgs_Rec,
1295 p_Terr_Type_Id IN NUMBER);
1296
1297 ---------------------------------------------------------------------
1298 -- Validate the Territory Qualifer Type Usage
1299 ---------------------------------------------------------------------
1300 -- Columns Validated
1301 -- Make sure a Territory Qual Type Usage is specified
1302 -- Make sure the Territory Id is valid
1303 -- Make sure the QUAL_TYPE_USG_ID is valid
1304 ---------------------------------------------------------------------
1305 PROCEDURE Validate_Type_Qtype_Usage
1306 (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1307 x_Return_Status OUT NOCOPY VARCHAR2,
1308 x_msg_count OUT NOCOPY NUMBER,
1309 x_msg_data OUT NOCOPY VARCHAR2,
1310 p_Type_QualTypeUsgs_Rec IN TypeQualTypeUsgs_Rec_Type := G_MISS_TYPEQUALTYPEUSGS_REC,
1311 p_Terr_Type_Id IN NUMBER);
1312
1313 --
1314 -- Checks whether a Terr Type is used by any territories
1315 --
1316 PROCEDURE Is_TerrType_Deletable
1317 (P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1318 P_TerrType_Id IN NUMBER,
1319 X_Return_Status OUT NOCOPY VARCHAR2,
1320 X_Msg_Count OUT NOCOPY VARCHAR2,
1324 END JTF_TERRITORY_TYPE_PVT;
1321 X_Msg_Data OUT NOCOPY VARCHAR2 );
1322
1323 -- Package spec