1 PACKAGE IGS_PS_VAL_CST AUTHID CURRENT_USER AS
2 /* $Header: IGSPS36S.pls 115.4 2002/11/29 03:02:34 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 ----------------------------------------------------------------------------
9
10 -- Validate if the IGS_PS_COURSE stage type is unique for this IGS_PS_COURSE version
11 FUNCTION crsp_val_cst_cstt(
12 p_course_cd IN IGS_PS_STAGE.course_cd%TYPE ,
13 p_version_number IN IGS_PS_STAGE.version_number%TYPE ,
14 p_sequence_number IN IGS_PS_STAGE.sequence_number%TYPE ,
15 p_course_stage_type IN IGS_PS_STAGE.course_stage_type%TYPE ,
16 p_message_name OUT NOCOPY VARCHAR2 )
17 RETURN BOOLEAN;
18
19 --
20 -- Validate the IGS_PS_COURSE stage type closed indicator.
21 FUNCTION crsp_val_cstt_closed(
22 p_course_stage_type IN IGS_PS_STAGE_TYPE.course_stage_type%TYPE ,
23 p_message_name OUT NOCOPY VARCHAR2)
24 RETURN BOOLEAN;
25
26
27 END IGS_PS_VAL_CST;