[Home] [Help]
7: -- removed .
8: -------------------------------------------------------------------------------------------
9: -- Validate for one open version of grading schema
10: FUNCTION assp_val_gs_one_open(
11: p_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
12: p_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN;
15:
8: -------------------------------------------------------------------------------------------
9: -- Validate for one open version of grading schema
10: FUNCTION assp_val_gs_one_open(
11: p_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
12: p_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN;
15:
16: --
15:
16: --
17: -- Validate for overlapping dates for grading schemas
18: FUNCTION assp_val_gs_ovrlp(
19: p_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
20: p_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
21: p_start_dt IN IGS_AS_GRD_SCHEMA.start_dt%TYPE ,
22: p_end_dt IN IGS_AS_GRD_SCHEMA.end_dt%TYPE ,
23: p_message_name OUT NOCOPY VARCHAR2 )
16: --
17: -- Validate for overlapping dates for grading schemas
18: FUNCTION assp_val_gs_ovrlp(
19: p_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
20: p_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
21: p_start_dt IN IGS_AS_GRD_SCHEMA.start_dt%TYPE ,
22: p_end_dt IN IGS_AS_GRD_SCHEMA.end_dt%TYPE ,
23: p_message_name OUT NOCOPY VARCHAR2 )
24: RETURN BOOLEAN;
17: -- Validate for overlapping dates for grading schemas
18: FUNCTION assp_val_gs_ovrlp(
19: p_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
20: p_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
21: p_start_dt IN IGS_AS_GRD_SCHEMA.start_dt%TYPE ,
22: p_end_dt IN IGS_AS_GRD_SCHEMA.end_dt%TYPE ,
23: p_message_name OUT NOCOPY VARCHAR2 )
24: RETURN BOOLEAN;
25:
18: FUNCTION assp_val_gs_ovrlp(
19: p_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
20: p_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
21: p_start_dt IN IGS_AS_GRD_SCHEMA.start_dt%TYPE ,
22: p_end_dt IN IGS_AS_GRD_SCHEMA.end_dt%TYPE ,
23: p_message_name OUT NOCOPY VARCHAR2 )
24: RETURN BOOLEAN;
25:
26: END IGS_AS_VAL_GS;