1 PACKAGE IGS_AS_VAL_GSG AUTHID CURRENT_USER AS
2 /* $Header: IGSAS24S.pls 115.3 2002/11/28 22:45:38 nsidana ship $ */
3 --
4 -- Validate grade's gs date range is current or future
5 FUNCTION assp_val_gs_cur_fut(
6 p_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
7 p_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
8 p_message_name OUT NOCOPY VARCHAR2 )
9 RETURN BOOLEAN;
10
11 --
12 -- Retrofitted
13 FUNCTION genp_val_dt_range(
14 p_start_dt IN DATE ,
15 p_end_dt IN DATE ,
16 p_message_name OUT NOCOPY VARCHAR2 )
17 RETURN BOOLEAN;
18
19 --
20 -- Validate upper mark range >= lower mark range and both set if one set
21 FUNCTION assp_val_gsg_mrk_rng(
22 p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
23 p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
24 p_message_name OUT NOCOPY VARCHAR2 )
25 RETURN BOOLEAN;
26
27 --
28 -- Validate max percentage >= min percentage
29 FUNCTION assp_val_gsg_min_max(
30 p_min_percentage IN IGS_AS_GRD_SCH_GRADE.min_percentage%TYPE ,
31 p_max_percentage IN IGS_AS_GRD_SCH_GRADE.max_percentage%TYPE ,
32 p_message_name OUT NOCOPY VARCHAR2 )
33 RETURN BOOLEAN;
34
35 --
36 -- Validate mark range does not overlap with other grades in GS version
37 FUNCTION assp_val_gsg_m_ovrlp(
38 p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
39 p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
40 p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
41 p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
42 p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
43 p_message_name OUT NOCOPY VARCHAR2 )
44 RETURN BOOLEAN;
45
46 --
47 -- Validate only 1 grade exists in a GS with the dflt outstanding ind set
48 FUNCTION assp_val_gsg_dflt(
49 p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
50 p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
51 p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
52 p_message_name OUT NOCOPY VARCHAR2 )
53 RETURN BOOLEAN;
54
55 --
56 -- Routine to clear rowids saved in a PL/SQL TABLE from a prior commit.
57 --
58 -- Validate the result for a grade cannot be chngd when translat'ns exist
59 FUNCTION assp_val_gsg_gsgt(
60 p_grading_schema_cd IN VARCHAR2 ,
61 p_version_number IN NUMBER ,
62 p_grade IN VARCHAR2 ,
63 p_message_name OUT NOCOPY VARCHAR2 )
64 RETURN BOOLEAN;
65
66 --
67 -- Validate special grade type.
68 FUNCTION assp_val_gsg_ssgt(
69 p_s_special_grade_type IN VARCHAR2 ,
70 p_s_result_type IN VARCHAR2 ,
71 p_message_name OUT NOCOPY VARCHAR2 )
72 RETURN BOOLEAN;
73
74 END IGS_AS_VAL_GSG;