1 PACKAGE IGS_PS_VAL_CFOS AUTHID CURRENT_USER AS
2 /* $Header: IGSPS19S.pls 115.3 2002/11/29 02:58:08 nsidana ship $ */
3
4 --
5 -- Validate the IGS_PS_COURSE field of study.
6 FUNCTION crsp_val_cfos_fos(
7 p_field_of_study IN VARCHAR2 ,
8 p_message_name OUT NOCOPY VARCHAR2)
9 RETURN BOOLEAN;
10 --
11 -- Validate IGS_PS_COURSE field of study percentage for the IGS_PS_COURSE version.
12 FUNCTION crsp_val_cfos_perc(
13 p_course_cd IN VARCHAR2 ,
14 p_version_number IN NUMBER ,
15 p_message_name OUT NOCOPY VARCHAR2)
16 RETURN BOOLEAN;
17
18 --
19 -- Validate IGS_PS_COURSE field of study major indicator.
20 FUNCTION crsp_val_cfos_major(
21 p_course_cd IN VARCHAR2 ,
22 p_version_number IN NUMBER ,
23 p_message_name OUT NOCOPY VARCHAR2)
24 RETURN BOOLEAN;
25
26 --
27 -- Cross-table validation on IGS_PS_COURSE field of study and IGS_PS_COURSE IGS_PS_AWD.
28 FUNCTION crsp_val_cfos_caw(
29 p_course_cd IN VARCHAR2 ,
30 p_version_number IN NUMBER ,
31 p_message_name OUT NOCOPY VARCHAR2)
32 RETURN BOOLEAN;
33
34 END IGS_PS_VAL_CFOS;