1 PACKAGE IGS_PS_VAL_POS AUTHID CURRENT_USER AS
2 /* $Header: IGSPS50S.pls 115.5 2002/11/29 03:06:15 nsidana ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --avenkatr 29-AUG-2001 Bug Id : 1956374. Removed Function "crsp_val_am_closed"
7 -- avenkatr 29-AUG-2001 Bug Id : 1956374. Removed Function "crsp_val_att_closed"
8 -- avenkatr 29-AUG-2001 Bug Id : 1956374. Removed Function "crsp_val_crs_ci"
9 -------------------------------------------------------------------------------------------
10 -- Bug #1956374
11 -- As part of the bug# 1956374 removed the function crsp_val_loc_cd
12
13 --
14 -- Validate the admission category is not closed.
15 FUNCTION crsp_val_ac_closed(
16 p_admission_cat IN IGS_AD_CAT.admission_cat%TYPE ,
17 p_message_name OUT NOCOPY VARCHAR2)
18 RETURN BOOLEAN;
19
20 --
21 -- Validate the calendar type is categorised admission and is not closed.
22 FUNCTION crsp_val_pos_cat(
23 p_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
24 p_message_name OUT NOCOPY VARCHAR2)
25 RETURN BOOLEAN;
26 --
27 -- Warn if no IGS_PS_COURSE offering exists for the specified options.
28 FUNCTION crsp_val_pos_coo(
29 p_course_cd IN VARCHAR2 ,
30 p_version_number IN NUMBER ,
31 p_cal_type IN VARCHAR2 ,
32 p_location_cd IN VARCHAR2 ,
33 p_attendance_mode IN VARCHAR2 ,
34 p_attendance_type IN VARCHAR2 ,
35 p_message_name OUT NOCOPY VARCHAR2)
36 RETURN BOOLEAN;
37 --
38 -- Warn if no IGS_PS_COURSE offering IGS_PS_UNIT set record exists.
39 FUNCTION crsp_val_pos_cous(
40 p_course_cd IN VARCHAR2 ,
41 p_crv_version_number IN NUMBER ,
42 p_cal_type IN VARCHAR2 ,
43 p_unit_set_cd IN VARCHAR2 ,
44 p_message_name OUT NOCOPY VARCHAR2)
45 RETURN BOOLEAN;
46
47 --
48 -- Validate pattern of study record is not ambiguous.
49 FUNCTION crsp_val_pos_iu(
50 p_course_cd IN IGS_PS_PAT_OF_STUDY.course_cd%TYPE ,
51 p_version_number IN IGS_PS_PAT_OF_STUDY.version_number%TYPE ,
52 p_cal_type IN IGS_PS_PAT_OF_STUDY.cal_type%TYPE ,
53 p_sequence_number IN IGS_PS_PAT_OF_STUDY.sequence_number%TYPE ,
54 p_location_cd IN IGS_PS_PAT_OF_STUDY.location_cd%TYPE ,
55 p_attendance_mode IN IGS_PS_PAT_OF_STUDY.attendance_mode%TYPE ,
56 p_attendance_type IN IGS_PS_PAT_OF_STUDY.attendance_type%TYPE ,
57 p_unit_set_cd IN IGS_PS_PAT_OF_STUDY.unit_set_cd%TYPE ,
58 p_admission_cal_type IN IGS_PS_PAT_OF_STUDY.admission_cal_type%TYPE ,
59 p_admission_cat IN IGS_PS_PAT_OF_STUDY.admission_cat%TYPE ,
60 p_message_name OUT NOCOPY VARCHAR2 )
61 RETURN BOOLEAN;
62
63 --
64 -- Validate a least one version of the IGS_PS_UNIT set is active.
65 FUNCTION crsp_val_us_active(
66 p_unit_set_cd IN IGS_EN_UNIT_SET_ALL.unit_set_cd%TYPE ,
67 p_message_name OUT NOCOPY VARCHAR2 )
68 RETURN BOOLEAN;
69 END IGS_PS_VAL_POS;