APPS.IGS_PS_VAL_CST dependencies on IGS_PS_STAGE

Line 12: p_course_cd IN IGS_PS_STAGE.course_cd%TYPE ,

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 )

Line 13: p_version_number IN IGS_PS_STAGE.version_number%TYPE ,

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;

Line 14: p_sequence_number IN IGS_PS_STAGE.sequence_number%TYPE ,

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:

Line 15: p_course_stage_type IN IGS_PS_STAGE.course_stage_type%TYPE ,

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: --

Line 22: p_course_stage_type IN IGS_PS_STAGE_TYPE.course_stage_type%TYPE ,

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: