1 PACKAGE IGS_AS_VAL_SUAO AUTHID CURRENT_USER AS
2 /* $Header: IGSAS32S.pls 115.6 2004/01/29 09:32:29 ddey ship $ */
3
4 -- To validate update of IGS_AS_SU_STMPTOUT record
5 FUNCTION ASSP_VAL_SUAO_UPD(
6 p_person_id IN NUMBER ,
7 p_course_cd IN VARCHAR2 ,
8 p_unit_cd IN VARCHAR2 ,
9 p_cal_type IN VARCHAR2 ,
10 p_ci_sequence_number IN NUMBER ,
11 p_outcome_dt IN DATE ,
12 p_new_finalised_outcome_ind IN VARCHAR2 ,
13 p_new_s_grade_creation_mthd_tp IN VARCHAR2 ,
14 p_new_mark IN NUMBER ,
15 p_new_grading_schema_cd IN VARCHAR2 ,
16 p_new_version_number IN NUMBER ,
17 p_new_grade IN VARCHAR2 ,
18 p_old_finalised_outcome_ind IN VARCHAR2 ,
19 p_old_s_grade_creation_mthd_tp IN VARCHAR2 ,
20 p_old_mark IN NUMBER ,
21 p_old_grading_schema_cd IN VARCHAR2 ,
22 p_old_version_number IN NUMBER ,
23 p_old_grade IN VARCHAR2 ,
24 p_message_name OUT NOCOPY VARCHAR2 ,
25 -- anilk, 22-Apr-2003, Bug# 2829262
26 p_uoo_id IN NUMBER )
27 RETURN boolean;
28
29
30 --
31 -- Validate the insert of a IGS_AS_SU_STMPTOUT record
32 FUNCTION ASSP_VAL_SUAO_INS(
33 p_person_id IN NUMBER ,
34 p_course_cd IN VARCHAR2 ,
35 p_unit_cd IN VARCHAR2 ,
36 p_cal_type IN VARCHAR2 ,
37 p_ci_sequence_number IN NUMBER ,
38 p_outcome_dt IN DATE ,
39 p_s_grade_creation_method_type IN VARCHAR2 ,
40 p_unit_attempt_status IN VARCHAR2 ,
41 p_message_name OUT NOCOPY VARCHAR2 ,
42 -- anilk, 22-Apr-2003, Bug# 2829262
43 p_uoo_id IN NUMBER )
44 RETURN boolean;
45
46
47 --
48 -- Validate IGS_AS_SU_STMPTOUT outcome_dt field
49 FUNCTION ASSP_VAL_SUAO_DT(
50 p_person_id IN NUMBER ,
51 p_course_cd IN VARCHAR2 ,
52 p_unit_cd VARCHAR2 ,
53 p_cal_type IN VARCHAR2 ,
54 p_ci_sequence_number IN NUMBER ,
55 p_outcome_dt IN DATE ,
56 p_message_name OUT NOCOPY VARCHAR2 ,
57 -- anilk, 22-Apr-2003, Bug# 2829262
58 p_uoo_id IN NUMBER )
59 RETURN boolean;
60
61
62 --
63 -- Validate s_grade_creation_method_type closed indicator
64 FUNCTION ASSP_VAL_SGCMT_CLSD(
65 p_s_grade_creation_method_type IN VARCHAR2 ,
66 p_message_name OUT NOCOPY VARCHAR2 )
67 RETURN boolean;
68
69 --
70 -- To validate an assessment mark against a grade
71 FUNCTION ASSP_VAL_MARK_GRADE(
72 p_mark IN NUMBER ,
73 p_grade IN VARCHAR2 ,
74 p_grading_schema_cd IN VARCHAR2 ,
75 p_version_number IN NUMBER ,
76 p_message_name OUT NOCOPY VARCHAR2 )
77 RETURN boolean;
78
79 PROCEDURE assp_val_mark_grade_ss (
80 p_mark IN NUMBER ,
81 p_grade IN VARCHAR2 ,
82 p_grading_schema_cd IN VARCHAR2 ,
83 p_version_number IN NUMBER ,
84 p_message_name OUT NOCOPY VARCHAR2,
85 p_boolean OUT NOCOPY VARCHAR2 );
86
87 END IGS_AS_VAL_SUAO;