1 PACKAGE CSC_CORE_UTILS_PVT AUTHID CURRENT_USER as
2 /* $Header: cscvcors.pls 115.19 2002/12/04 19:13:10 jamose ship $ */
3 -- Start of Comments
4 -- Package name : CSC_CORE_UTILS_PVT
5 -- Purpose : This package contains all the common procedure, functions and global
6 -- variables that will be used by the CUSTOMER CARE-MODULE.
7 -- History
8 -- MM-DD-YYYY NAME MODIFICATION
9 -- 13-08-1999 dejoseph Created.
10 -- 12-08-1999 dejoseph 'Arcs'ed in for first code freeze.
11 -- 12-21-1999 dejoseph 'Arcs'ed in for second code freeze.
12 -- 01-03-2000 dejoseph 'Arcs'ed in for third code freeze. (10-JAN-2000)
13 -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)
14 -- 02-13-2000 dejoseph 'Arcs'ed on for fifth code freeze. (21-FEB-2000)
15 -- 02-28-2000 dejoseph 'Arcs'ed on for sixth code freeze. (06-MAR-2000)
16 -- 05-04-2000 dejoseph Included procedure to gather CBO statistics on a given
17 -- table.
18 -- 02-22-2001 dejoseph Added two more plan status functions, MERGE_PLAN and
19 -- TRANSFER_PLAN for the purpose of Party Merge.
20 -- 12-03-2002 jamose Added function for Fnd_Api_G_Miss* Changes
21 -- End of Comments
22
23
24 G_PVT CONSTANT VARCHAR2(30):= '_PVT';
25 G_PUB CONSTANT VARCHAR2(30):= '_PUB';
26
27 G_APP_SHORTNAME CONSTANT VARCHAR2(5) := 'CSC';
28 --G_UPDATE CONSTANT VARCHAR2(6) := 'UPDATE';
29 --G_CREATE CONSTANT VARCHAR2(6) := 'CREATE';
30
31 L_UPDATE CONSTANT VARCHAR2(6) := 'UPDATE';
32 L_CREATE CONSTANT VARCHAR2(6) := 'CREATE';
33
34 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_CORE_UTILS_PVT';
35 G_FILE_NAME CONSTANT VARCHAR2(12):= 'cscvcors.pls';
36
37 G_MSG_LVL_OTHERS CONSTANT NUMBER := 70;
38 -- This level of error is used when the 'WHEN OTHERS' exception is executed.
39 -- This value is passed when an Oracle error has occured on the server side which cannot
40 -- be trapped under normal validations, like value to large to be inserte/updated into
41 -- a column etc. The other error levels being used are taken from the FND_MSG_PUB package.
42
43 CURSOR g_lookups ( c_lookup_type VARCHAR2,
44 c_lookup_code VARCHAR2 ) IS
45 SELECT meaning
46 FROM fnd_lookups
47 WHERE lookup_type = c_lookup_type
48 AND lookup_code = c_lookup_code;
49
50
51 RECORD_LOCK_EXCEPTION EXCEPTION;
52 PRAGMA EXCEPTION_INIT(RECORD_LOCK_EXCEPTION,-0054);
53
54 -- *******************************************************
55 -- Start of Comments
56 -- *******************************************************
57 -- API Name : G_CREATE
58 -- Type : Private Function
59 -- Pre-Req : None
60 -- Function : Returns the value of the constant
61 -- CSC_CORE_UTILS_PVT.L_CREATE
62 -- Return Type : Number
63 --
64 -- End of Comments
65 --
66 FUNCTION G_CREATE RETURN VARCHAR2;
67
68 -- *******************************************************
69 -- Start of Comments
70 -- *******************************************************
71 -- API Name : G_UPDATE
72 -- Type : Private Function
73 -- Pre-Req : None
74 -- Function : Returns the value of the constant
75 -- CSC_CORE_UTILS_PVT.L_UPDATE
76 -- Return Type : Number
77 --
78 -- End of Comments
79 --
80 FUNCTION G_UPDATE RETURN VARCHAR2;
81
82 -- *******************************************************
83 -- Start of Comments
84 -- *******************************************************
85 -- API Name : G_MISS_NUM
86 -- Type : Private Function
87 -- Pre-Req : None
88 -- Function : Returns the Value of the Constant FND_API.G_MISS_NUM
89 -- Return Type : Number
90 --
91 -- End of Comments
92 --
93 FUNCTION G_MISS_NUM RETURN NUMBER;
94
95 -- *******************************************************
96 -- Start of Comments
97 -- *******************************************************
98 -- API Name : G_MISS_CHAR
99 -- Type : Private Function
100 -- Pre-Req : None
101 -- Function : Returns the Value of the Constant FND_API.G_MISS_CHAR
102 -- Return Type : Varchar2
103 --
104 -- End of Comments
105 --
106 FUNCTION G_MISS_CHAR RETURN VARCHAR2;
107
108 -- *******************************************************
109 -- Start of Comments
110 -- *******************************************************
111 -- API Name : G_MISS_DATE
112 -- Type : Private Function
113 -- Pre-Req : None
114 -- Function : Returns the Value of the Constant FND_API.G_MISS_DATE
115 -- Return Type : Date
116 --
117 -- End of Comments
118 --
119 FUNCTION G_MISS_DATE RETURN DATE ;
120
121 -- *******************************************************
122 -- Start of Comments
123 -- *******************************************************
124 -- API Name : G_RET_STS_SUCCESS
125 -- Type : Private Function
126 -- Pre-Req : None
127 -- Function : Returns the Value of the Constant FND_API.G_RET_STS_SUCCESS
128 -- Return Type : Date
129 --
130 -- End of Comments
131 --
132 FUNCTION G_RET_STS_SUCCESS RETURN VARCHAR2 ;
133
134 -- *******************************************************
135 -- Start of Comments
136 -- *******************************************************
137 -- API Name : G_RET_STS_ERROR
138 -- Type : Private Function
139 -- Pre-Req : None
140 -- Function : Returns the Value of the Constant FND_API.G_RET_STS_ERROR
141 -- Return Type : Date
142 --
143 -- End of Comments
144 --
145 FUNCTION G_RET_STS_ERROR RETURN VARCHAR2 ;
146
147 -- *******************************************************
148 -- Start of Comments
149 -- *******************************************************
150 -- API Name : G_RET_STS_UNEXP_ERROR
151 -- Type : Private Function
152 -- Pre-Req : None
153 -- Function : Returns the Value of the Constant FND_API.G_RET_STS_UNEXP_ERROR
154 -- Return Type : Date
155 --
156 -- End of Comments
157 --
158 FUNCTION G_RET_STS_UNEXP_ERROR RETURN VARCHAR2 ;
159
160 -- *******************************************************
161 -- Start of Comments
162 -- *******************************************************
163 -- API Name : G_VALID_LEVEL_NONE
164 -- Type : Private Function
165 -- Pre-Req : None
166 -- Function : Returns the Value of the Constant
167 -- FND_API.G_VALID_LEVEL_NONE
168 -- Return Type : Number
169 --
170 -- End of Comments
171 --
172 FUNCTION G_VALID_LEVEL_NONE RETURN NUMBER;
173
174 -- *******************************************************
175 -- Start of Comments
176 -- *******************************************************
177 -- API Name : G_VALID_LEVEL_FULL
178 -- Type : Private Function
179 -- Pre-Req : None
180 -- Function : Returns the Value of the Constant
181 -- FND_API.G_VALID_LEVEL_FULL
182 -- Return Type : Number
183 --
184 -- End of Comments
185 --
186 FUNCTION G_VALID_LEVEL_FULL RETURN NUMBER;
187
188 -- *******************************************************
189 -- Start of Comments
190 -- *******************************************************
191 -- API Name : G_VALID_LEVEL_INT
192 -- Type : Private Function
193 -- Pre-Req : None
194 -- Function : Returns the Value of the Constant
195 -- CS_INTERACTION_PVT.G_VALID_LEVEL_INT
196 -- Return Type : Number
197 --
198 -- End of Comments
199 --
200 FUNCTION G_VALID_LEVEL_INT RETURN NUMBER;
201
202 -- *******************************************************
203 -- Start of Comments
204 -- *******************************************************
205 -- API Name : G_TRUE
206 -- Type : Private Function
207 -- Pre-Req : None
208 -- Function : Returns the Value of the Constant
209 -- FND_API.G_TRUE
210 -- Return Type : Varchar2
211 --
212 -- End of Comments
213 --
214 FUNCTION G_TRUE RETURN Varchar2;
215
216 -- *******************************************************
217 -- Start of Comments
218 -- *******************************************************
219 -- API Name : G_FALSE
220 -- Type : Private Function
221 -- Pre-Req : None
222 -- Function : Returns the Value of the Constant
223 -- FND_API.G_FALSE
224 -- Return Type : Varchar2
225 --
226 -- End of Comments
227 --
228 FUNCTION G_FALSE RETURN Varchar2;
229
230 -- *******************************************************
231 -- Start of Comments
232 -- *******************************************************
233 -- API Name : ENABLE_PLAN
234 -- Type : Private Function
235 -- Pre-Req : None
236 -- Function : Returns the Value 'APPLIED'.
237 -- Return Type : Varchar2
238 --
239 -- End of Comments
240 --
241 FUNCTION ENABLE_PLAN RETURN Varchar2;
242
243 -- *******************************************************
244 -- Start of Comments
245 -- *******************************************************
246 -- API Name : DISABLE_PLAN
247 -- Type : Private Function
248 -- Pre-Req : None
249 -- Function : Returns the Value 'DISABLED'.
250 -- Return Type : Varchar2
251 --
252 -- End of Comments
253 --
254 FUNCTION DISABLE_PLAN RETURN Varchar2;
255
256 -- *******************************************************
257 -- Start of Comments
258 -- *******************************************************
259 -- API Name : APPLY_PLAN
260 -- Type : Private Function
261 -- Pre-Req : None
262 -- Function : Returns the Value 'APPLIED'.
263 -- Return Type : Varchar2
264 --
265 -- End of Comments
266 --
267 FUNCTION APPLY_PLAN RETURN VARCHAR2;
268
269 -- *******************************************************
270 -- Start of Comments
271 -- *******************************************************
272 -- API Name : REMOVE_PLAN
273 -- Type : Private Function
274 -- Pre-Req : None
275 -- Function : Returns the Value 'REMOVED'.
276 -- Return Type : Varchar2
277 --
278 -- End of Comments
279 --
280 FUNCTION REMOVE_PLAN RETURN VARCHAR2;
281
282 -- *******************************************************
283 -- Start of Comments
284 -- *******************************************************
285 -- API Name : MERGE_PLAN
286 -- Type : Private Function
287 -- Pre-Req : None
288 -- Function : Returns the Value 'MERGED'.
289 -- Return Type : Varchar2
290 --
291 -- End of Comments
292 --
293 FUNCTION MERGE_PLAN RETURN Varchar2;
294
295 -- *******************************************************
296 -- Start of Comments
297 -- *******************************************************
298 -- API Name : TRANSFER_PLAN
299 -- Type : Private Function
300 -- Pre-Req : None
301 -- Function : Returns the Value 'TRANSFERED'.
302 -- Return Type : Varchar2
303 --
304 -- End of Comments
305 --
306 FUNCTION TRANSFER_PLAN RETURN Varchar2;
307
308 -- *******************************************************
309 -- Start of Comments
310 -- *******************************************************
311 -- API Name : GATHER_TABLE_STATS
312 -- Type : Private Procedure
313 -- Pre-Req : Table should exist under specified schema.
314 -- Function : Invokes FND procedure FND_STATS.GATHER_TABLE_STATS which
315 -- estimates statistics for a given table. To be invoked
316 -- whenever generating stats. for the CBO during execution.
317 -- Parameters :
318 -- IN
319 -- p_ownname IN VARCHAR2 Optional Default :=
320 -- CSC_CORE_UTILS_PVT.G_APP_SHORTNAME
321 -- p_tabname IN VARCHAR2
322 -- p_percent IN NUMBER Optional Default := NULL
323 -- p_degree IN NUMBER Optional Default := NULL
324 -- p_partname IN VARCHAR2 Optional Default := NULL
325 -- p_backup_flag IN VARCHAR2 Optional Default := 'NOBACKUP'
326 -- p_cascade IN BOOLEAN Optional Default := TRUE
327 -- p_tmode IN VARCHAR2 Optional Default := 'NORMAL'
328 -- p_granularity IN VARCHAR2 Optional Default := 'DEFAULT'
329 --
330 -- End of Comments
331 --
332 --Fix for Bug # 2443649
333 --Commented out this procedure as it is not used in any appl
334 /*
335 PROCEDURE GATHER_TABLE_STATS (
336 P_OWNNAME IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_APP_SHORTNAME,
337 P_TABNAME IN VARCHAR2,
338 P_PERCENT IN NUMBER := NULL,
339 P_DEGREE IN NUMBER := NULL,
340 P_PARTNAME IN VARCHAR2 := NULL,
341 P_BACKUP_FLAG IN VARCHAR2 := 'NOBACKUP',
342 P_CASCADE IN BOOLEAN := TRUE,
343 P_TMODE IN VARCHAR2 := 'NORMAL' ,
344 P_GRANULARITY IN VARCHAR2 := 'DEFAULT');
345
346 */
347
348 PROCEDURE Handle_Exceptions(
352 P_PACKAGE_TYPE IN VARCHAR2,
349 P_API_NAME IN VARCHAR2,
350 P_PKG_NAME IN VARCHAR2,
351 P_EXCEPTION_LEVEL IN NUMBER DEFAULT NULL,
353 X_MSG_COUNT OUT NOCOPY NUMBER,
354 X_MSG_DATA OUT NOCOPY VARCHAR2,
355 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
356
357 PROCEDURE Validate_Dates (
358 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359 p_validation_mode IN VARCHAR2,
360 P_START_DATE IN DATE,
361 P_END_DATE IN DATE,
362 x_return_status OUT NOCOPY VARCHAR2,
363 x_msg_count OUT NOCOPY NUMBER,
364 x_msg_data OUT NOCOPY VARCHAR2);
365
366
367 PROCEDURE Validate_Not_Nulls (
368 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
369 p_validation_mode IN VARCHAR2,
370 P_COLUMN_NAME IN VARCHAR2,
371 P_COLUMN_VALUE IN VARCHAR2,
372 x_return_status OUT NOCOPY VARCHAR2,
373 x_msg_count OUT NOCOPY NUMBER,
374 x_msg_data OUT NOCOPY VARCHAR2);
375
376 PROCEDURE Validate_Not_Nulls (
377 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378 p_validation_mode IN VARCHAR2,
379 P_COLUMN_NAME IN VARCHAR2,
380 P_COLUMN_VALUE IN NUMBER,
381 x_return_status OUT NOCOPY VARCHAR2,
382 x_msg_count OUT NOCOPY NUMBER,
383 x_msg_data OUT NOCOPY VARCHAR2);
384
385 PROCEDURE Validate_Not_Nulls (
386 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
387 p_validation_mode IN VARCHAR2,
388 P_COLUMN_NAME IN VARCHAR2,
389 P_COLUMN_VALUE IN DATE,
390 x_return_status OUT NOCOPY VARCHAR2,
391 x_msg_count OUT NOCOPY NUMBER,
392 x_msg_data OUT NOCOPY VARCHAR2);
393
394 -- Start of Comments
395 --
396 -- Item level validation procedures for Seeded_flag added dated 15th June 2001 for
397 -- implementing Sequences.
398 --
399 -- End of Comments
400
401 PROCEDURE Validate_SEEDED_FLAG (
402 P_API_NAME IN VARCHAR2,
403 P_SEEDED_FLAG IN VARCHAR2,
404 X_Return_Status OUT NOCOPY VARCHAR2
405 );
406
407
408 /* This Procedure added for checking the Validity of Application Id for Enhancement 1784578 */
409
410 PROCEDURE Validate_Application_Id (
411 P_Init_Msg_List IN VARCHAR2 :=CSC_CORE_UTILS_PVT.G_FALSE,
412 P_Application_ID IN NUMBER DEFAULT NULL,
413 X_Return_Status OUT NOCOPY VARCHAR2,
414 X_Msg_Count OUT NOCOPY NUMBER,
415 X_Msg_Data OUT NOCOPY VARCHAR2,
416 p_effective_date IN Date);
417
418 -- *******************************************************
419 -- Start of Comments
420 -- *******************************************************
421 -- API Name : COMMIT_ROLLBACK
422 -- Type : Private Procedure
423 -- Pre-Req : None
424 -- Function : Does a commit or a rollback on the server side.
425 --
426 -- PARAMETERS
427 -- IN
428 -- COM_ROLL IN VARCHAR2 Optional Default := 'ROLL'
429 --
430 -- End of Comments
431 --
432 PROCEDURE COMMIT_ROLLBACK(
433 COM_ROLL IN VARCHAR2 := 'ROLL') ;
434
435
436
437 FUNCTION GET_COUNTER_NAME (p_COUNTER_ID NUMBER ) RETURN VARCHAR2;
438
439
440
441
442 -- ----------------------------------------------------------------------------
443 -- |----------------------< lookup_code_not_exists >---------------------------
444 -- ----------------------------------------------------------------------------
445 -- {Start Of Comments}
446 --
447
448 -- Description:
449 -- A function for lookupcode validation. Used to validate a date tracked
450 -- lookupcode exists in fnd_lookups. Returns FND_API.G_RET_STS_SUCCESS
451 -- if the lookup code exists else returns FND_API.G_RET_STS_ERROR if the
452 -- lookup code doesnt exist or if not enabled or if it doesnt exist for
453 -- the specified period (p_effective_date).
454 --
455 --
456 -- In Arguments:
457 -- p_effective_date IN DATE
458 -- p_lookup_type IN VARCHAR2
459 -- p_lookup_code IN VARCHAR2
460 --
461 -- Returns the status depending on the outcome
462 -- If p_currency_code is valid for the specified
463 -- (p_effective_date) period then returns
464 -- FND_API.G_RET_STS_SUCCESS else G_RET_STS_ERROR.
465
466 --
467 -- Access Status:
468 -- Internal Development Use Only.
469
470 --
471 -- {End Of Comments}
472
473 FUNCTION lookup_code_not_exists
474 (p_effective_date in date
475 ,p_lookup_type in varchar2
476 ,p_lookup_code in varchar2
477 ) return varchar2;
478
479
480
481 FUNCTION CSC_lookup_code_not_exists
482 (p_effective_date DATE
483 ,p_lookup_type VARCHAR2
487 -- ----------------------------------------------------------------------------
484 ,p_lookup_code VARCHAR2
485 ) return varchar2;
486
488 -- |----------------------< currency_code_not_exists >---------------------------
489 -- ----------------------------------------------------------------------------
490 -- {Start Of Comments}
491 --
492
493 -- Description:
494 -- A function for currency code validation. Used to validate a date tracked
495 -- currency code exists in fnd_currencies. Returns FND_API.G_RET_STS_SUCCESS
496 -- if the currency code exists else returns FND_API.G_RET_STS_ERROR if the
497 -- currency code doesnt exist or if not enabled or if it doesnt exist for
498 -- the specified period (p_effective_date).
499 --
500 --
501 -- In Arguments:
502 -- p_effective_date IN DATE
503 -- p_lookup_type IN VARCHAR2
504 -- p_lookup_code IN VARCHAR2
505 --
506 -- Returns the status depending on the outcome.
507 -- If p_currency_code is enabled for the specified
508 -- (p_effective_date) period then returns
509 -- FND_API.G_RET_STS_SUCCESS else G_RET_STS_ERROR.
510 --
511 -- Access Status:
512 -- Internal Development Use Only.
513
514 --
515 -- {End Of Comments}
516
517 FUNCTION currency_code_not_exists
518 (p_effective_date in date
519 ,p_currency_code in varchar2
520 ) return varchar2;
521
522 -- ---------------------------------------------------------------------------
523 -- -------------------------< validate_start_end_dt>---------------------------
524 -- ----------------------------------------------------------------------------
525 -- {Start Of Comments}
526 --
527
528 -- Description:
529 -- Used for validating the start and end date. Assuming the start date will
530 -- never be NULL.If end_date is null then uses the fnd_api.g_miss_date to
531 -- validate the dates.
532
533 -- Writes the messages CS_ALL_START_DATE and CS_ALL_END_DATE. Returns
534 -- FND_API.G_RET_STS_SUCCESS if start_date < session_date and end_date < start_date
535 -- else returns FND_API.G_RET_STS_ERROR.
536
537 --
538 -- In Arguments:
539 -- p_api_name IN VARCHAR2
540 -- p_start_date IN DATE
541 -- p_end_date IN DATE
542 -- x_return_status OUT VARCHAR2
543 --
544 --
545 -- Access Status:
546 -- Internal Development Use Only.
547
548 --
549 -- {End Of Comments}
550
551 PROCEDURE Validate_Start_End_Dt
552 ( p_api_name IN VARCHAR2,
553 p_start_date IN DATE,
554 p_end_date IN DATE DEFAULT NULL,
555 x_return_status OUT NOCOPY VARCHAR2
556 );
557
558 -- ---------------------------------------------------------------------------
559 -- -------------------------< Add_Invalid_Argument_Msg>------------------------
560 -- ----------------------------------------------------------------------------
561 -- {Start Of Comments}
562 --
563
564 -- Description:
565 -- Writes an Invalid Argument message using the api_name, parameter name and
566 -- the parameter value.
567
568 --
569 -- In Arguments:
570 -- p_token_an IN VARCHAR2 -- api_name
571 -- p_token_v IN VARCHAR2 -- parameter value
572 -- p_token_p IN VARCHAR2 -- parameter name
573 --
574 --
575 -- Access Status:
576 -- Internal Development Use Only.
577
578 --
579 -- {End Of Comments}
580
581 PROCEDURE Add_Invalid_Argument_Msg
582 ( p_api_name VARCHAR2,
583 p_argument VARCHAR2,
584 p_argument_value VARCHAR2
585 );
586
587 -- ---------------------------------------------------------------------------
588 -- -------------------------< Record_Is_Locked_Msg>------------------------
589 -- ----------------------------------------------------------------------------
590 -- {Start Of Comments}
591 --
592
593 -- Description:
594 -- Writes an Record Locked message using the api_name.
595
596 --
597 -- In Arguments:
598 -- p_token_an IN VARCHAR2 -- api_name
599 --
600 --
601 -- Access Status:
602 -- Internal Development Use Only.
603
604 --
605 -- {End Of Comments}
606
607 PROCEDURE Record_Is_Locked_Msg
608 ( p_api_name VARCHAR2
609 );
610
611 -- ---------------------------------------------------------------------------
612 -- -------------------------< Cannot_Update_Param_Msg>------------------------
613 -- ----------------------------------------------------------------------------
614 -- {Start Of Comments}
615 --
616
617 -- Description:
618 -- Writes a cannot update message.
619
620 --
621 -- In Arguments:
622 -- p_token_an IN VARCHAR2 -- api_name
623 -- p_token_cn IN VARCHAR2 -- column name
624 -- p_token_v IN VARCHAR2 -- column value
625 --
626 --
627 -- Access Status:
628 -- Internal Development Use Only.
629
630 --
631 -- {End Of Comments}
632
633 PROCEDURE Cannot_Update_Param_Msg
634 ( p_api_name VARCHAR2,
635 p_argument VARCHAR2,
636 p_argument_value VARCHAR2
637 );
638
639 -- ---------------------------------------------------------------------------
640 -- -------------------------< Add_Null_Parameter_Msg>--------------------------
641 -- ----------------------------------------------------------------------------
642 -- {Start Of Comments}
643 --
647 -- Varchar2 format.
644 -- Description: This procedure is called by business processes which have
645 -- identified a NULL argument error which needs to be NOT null.
646 -- If the argument is null then need to error.
648
649 -- Description:
650 -- Writes an cannot update the column message.
651
652 --
653 -- In Arguments:
654 -- p_token_an IN VARCHAR2 -- api_name
655 -- p_token_cn IN VARCHAR2 -- column name
656 -- p_token_v IN VARCHAR2 -- column value
657 --
658 --
659 -- Access Status:
660 -- Internal Development Use Only.
661
662 --
663 -- {End Of Comments}
664
665
666 PROCEDURE Add_Null_Parameter_Msg
667 ( p_api_name VARCHAR2,
668 p_argument VARCHAR2
669 );
670
671 -- ---------------------------------------------------------------------------
672 -- -------------------------< Add_Duplicate_Value_Msg>------------------------
673 -- ----------------------------------------------------------------------------
674 -- Description:
675 -- This procedure adds Invalid arguments message to the
676 -- messages que
677 --
678 --
679 -- In Arguments:
680 -- p_api_name
681 -- p_argument
682 -- p_argument_value
683 --
684 --
685 --
686 -- For CSC Development.
687
688 PROCEDURE Add_Duplicate_Value_Msg
689 ( p_api_name VARCHAR2,
690 p_argument VARCHAR2,
691 p_argument_value VARCHAR2
692 );
693
694 -- ---------------------------------------------------------------------------
695 -- -------------------------< Mandatory_arg_Error>--------------------------
696 -- ----------------------------------------------------------------------------
697 -- {Start Of Comments}
698 --
699
700 -- Description: This procedure is called by business processes which have
701 -- identified a mandatory argument which needs to be NOT null.
702 -- If the argument is null then need to error.
703 -- Varchar2 format.
704
705 --
706 -- In Arguments:
707 -- p_api_name IN VARCHAR2 -- api_name
708 -- p_argument IN VARCHAR2 -- column name
709 -- p_argument_value IN VARCHAR2 -- column value
710 --
711 --
712 -- Access Status:
713 -- Internal Development Use Only.
714
715 --
716 -- {End Of Comments}
717
718 Procedure mandatory_arg_error
719 (p_api_name in varchar2,
720 p_argument in varchar2,
721 p_argument_value in varchar2 );
722 --
723
724 -- ---------------------------------------------------------------------------
725 -- -------------------------< Mandatory_arg_Error>--------------------------
726 -- ----------------------------------------------------------------------------
727 -- {Start Of Comments}
728 --
729
730 -- Description: This procedure is called by business processes which have
731 -- identified a mandatory argument which needs to be NOT null.
732 -- If the argument is null then need to error.
733 -- Date format.
734 -- Overloaded procedure which converts argument into a varchar2.
735
736 --
737 -- In Arguments:
738 -- p_api_name IN VARCHAR2 -- api_name
739 -- p_argument IN VARCHAR2 -- column name
740 -- p_argument_value IN date -- column value
741 --
742 --
743 -- Access Status:
744 -- Internal Development Use Only.
745
746 --
747 -- {End Of Comments}
748 --
749 Procedure mandatory_arg_error
750 (p_api_name in varchar2,
751 p_argument in varchar2,
752 p_argument_value in date);
753 --
754 -- ---------------------------------------------------------------------------
755 -- -------------------------< Mandatory_arg_Error>--------------------------
756 -- ----------------------------------------------------------------------------
757 -- {Start Of Comments}
758 --
759
760 -- Description: This procedure is called by business processes which have
761 -- identified a mandatory argument which needs to be NOT null.
762 -- If the argument is null then need to error.
763 -- Number format.
764 -- Overloaded procedure which converts argument into a varchar2.
765 --
766 -- In Arguments:
767 -- p_api_name IN VARCHAR2 -- api_name
768 -- p_argument IN VARCHAR2 -- column name
769 -- p_argument_value IN number -- column value
770 --
771 --
772 -- Access Status:
773 -- Internal Development Use Only.
774
775 --
776 -- {End Of Comments}
777 --
778 --
779
780 --
781 Procedure mandatory_arg_error
782 (p_api_name in varchar2,
783 p_argument in varchar2,
784 p_argument_value in number );
785
786
787 -- ---------------------------------------------------------------------------
788 -- -------------------------< Validate_Sql_Stmnt>--------------------------
789 -- ----------------------------------------------------------------------------
790 -- Description:
791
792 PROCEDURE Validate_Sql_Stmnt
793 ( p_sql_stmnt IN VARCHAR2,
794 x_return_status OUT NOCOPY VARCHAR2 );
795
796
797 -- ---------------------------------------------------------------------------
798 -- -------------------------< Build_Sql_Stmnt>--------------------------
799 -- ----------------------------------------------------------------------------
800 -- Description:
801
802 PROCEDURE Build_Sql_Stmnt
803 ( p_select_clause IN VARCHAR2,
804 p_from_clause IN VARCHAR2,
805 p_where_clause IN VARCHAR2,
806 p_other_clause IN VARCHAR2,
807 x_sql_Stmnt OUT NOCOPY VARCHAR2,
808 x_return_status OUT NOCOPY VARCHAR2 );
809
810 FUNCTION Get_G_Miss_Char(p_value IN Varchar2, p_old_value IN Varchar2)
811 RETURN VARCHAR2;
812
813 FUNCTION Get_G_Miss_Num(p_value IN Number, p_old_value IN Number)
814 RETURN NUMBER;
815
816 FUNCTION Get_G_Miss_Date(p_value IN Date, p_old_value IN Date)
817 RETURN Date;
818
819
820 END CSC_CORE_UTILS_PVT;
[Home] [Help]