1 PACKAGE IGS_CO_VAL_CCI AUTHID CURRENT_USER AS
2 /* $Header: IGSCO06S.pls 115.5 2002/11/28 23:04:16 nsidana ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --avenkatr 29-AUG-2001 Bug Id : 1956374. Removed procedure "corp_val_cort_closed"
7 -------------------------------------------------------------------------------------------
8
9 -- Validate that the correspondence type is eligible for the category
10 FUNCTION corp_val_cci_elgbl(
11 p_person_id IN NUMBER ,
12 p_course_cd IN VARCHAR2 ,
13 p_correspondence_cat IN VARCHAR2 ,
14 p_correspondence_type IN VARCHAR2 ,
15 p_job_name IN VARCHAR2 ,
16 p_output_num IN NUMBER ,
17 p_effective_dt IN DATE ,
18 p_message_name OUT NOCOPY varchar2 )
19 RETURN BOOLEAN;
20 --
21 -- Validate for correspondence category item duplicates.
22 FUNCTION corp_val_cci_duplict(
23 p_correspondence_cat IN VARCHAR2 ,
24 p_correspondence_type IN VARCHAR2 ,
25 p_create_dt IN DATE ,
26 p_message_name OUT NOCOPY varchar2)
27 RETURN BOOLEAN;
28 PRAGMA RESTRICT_REFERENCES(corp_val_cci_duplict,WNDS);
29 END IGS_CO_VAL_CCI;