1 PACKAGE IGS_PS_VAL_POSp AUTHID CURRENT_USER AS
2 /* $Header: IGSPS51S.pls 115.4 2002/11/29 03:06:30 nsidana ship $ */
3 -- Bug #1956374
4 -- As part of the bug# 1956374 added the pragma
5
6 -- Validate the calendar type is categorised teaching and is not closed.
7 FUNCTION crsp_val_posp_cat(
8 p_cal_type IN IGS_CA_TYPE.CAL_TYPE%TYPE ,
9 p_message_name OUT NOCOPY VARCHAR2)
10 RETURN BOOLEAN;
11 PRAGMA RESTRICT_REFERENCES(crsp_val_posp_cat,WNDS);
12
13 -- Validate future relationship between IGS_CA_TYPE and teach_cal_type.
14 FUNCTION crsp_val_posp_cir(
15 p_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
16 p_teach_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
17 p_message_name OUT NOCOPY VARCHAR2)
18 RETURN BOOLEAN;
19 --
20 -- Validate pattern of study period record is unique.
21 FUNCTION crsp_val_posp_iu(
22 p_course_cd IN VARCHAR2 ,
23 p_version_number IN NUMBER ,
24 p_cal_type IN VARCHAR2 ,
25 p_pos_sequence_number IN NUMBER ,
26 p_sequence_number IN NUMBER ,
27 p_acad_period_num IN NUMBER ,
28 p_teach_cal_type IN VARCHAR2 ,
29 p_message_name OUT NOCOPY VARCHAR2)
30 RETURN BOOLEAN;
31 END IGS_PS_VAL_POSp;