1 PACKAGE IGS_PS_VAL_COus AUTHID CURRENT_USER AS
2 /* $Header: IGSPS28S.pls 115.4 2002/11/29 03:00:44 nsidana ship $ */
3
4 ----------------------------------------------------------------------------
5 -- Change History :
6 -- Who When What
7 -- avenkatr 30-AUG-2001 Bug No 1956374. Removed procedure "crsp_val_iud_crv_dtl"
8 -- avenkatr 30-AUG-2001 Bug No 1956374. Removed procedure "crsp_val_iud_us_dtl"
9 ----------------------------------------------------------------------------
10
11 --
12 -- Validate crs off IGS_PS_UNIT sets against IGS_PS_UNIT set IGS_PS_COURSE type restrictions
13 FUNCTION crsp_val_cous_usctv(
14 p_course_cd IN VARCHAR2 ,
15 p_crv_version_number IN NUMBER ,
16 p_unit_set_cd IN VARCHAR2 ,
17 p_us_version_number IN NUMBER ,
18 p_message_name OUT NOCOPY VARCHAR2 )
19 RETURN BOOLEAN;
20
21 --
22 -- Validate crs off IGS_PS_UNIT set 'only as subordinate' indicator
23 FUNCTION crsp_val_cous_subind(
24 p_course_cd IN VARCHAR2 ,
25 p_crv_version_number IN NUMBER ,
26 p_cal_type IN VARCHAR2 ,
27 p_unit_set_cd IN VARCHAR2 ,
28 p_us_version_number IN NUMBER ,
29 p_old_only_as_sub_ind IN VARCHAR2 DEFAULT 'N',
30 p_new_only_as_sub_ind IN VARCHAR2 DEFAULT 'N',
31 p_message_name OUT NOCOPY VARCHAR2 )
32 RETURN BOOLEAN;
33
34 END IGS_PS_VAL_COus;