DBA Data[Home] [Help]

PACKAGE: APPS.IGS_CO_VAL_CCI

Source


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;