1 PACKAGE IGS_AS_VAL_UAI AS
2 /* $Header: IGSAS34S.pls 120.0 2005/07/05 11:31:20 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 -- DDEY 02-Jan-2001 Bug # 2162831 . FUNCTION assp_val_unit_sec_uniqref is added.
7 --smadathi 24-AUG-2001 Bug No. 1956374 .Removed references to duplicate
8 -- function GENP_VAL_SDTT_SESS
9 -------------------------------------------------------------------------------------------
10 -- As part of the bug# 1956374 removed the function crsp_val_loc_closed
11 -- Bug No. 1956374 Procedure assp_val_optnl_links is removed
12 -- Validate assessment item exists
13 FUNCTION assp_val_ai_exists(
14 p_ass_id IN IGS_AS_ASSESSMNT_ITM_ALL.ass_id%TYPE,
15 p_message_name OUT NOCOPY VARCHAR2 )
16 RETURN BOOLEAN;
17 -- Commented out NOCOPY By DDEY
18 PRAGMA RESTRICT_REFERENCES (assp_val_ai_exists,WNDS);
19 --
20 -- Validate IGS_PS_UNIT mode closed indicator.
21 FUNCTION crsp_val_um_closed(
22 p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE ,
23 p_message_name OUT NOCOPY VARCHAR2 )
24 RETURN BOOLEAN;
25 PRAGMA RESTRICT_REFERENCES (crsp_val_um_closed,WNDS);
26
27 --
28 -- Validate IGS_PS_UNIT class closed indicator.
29 FUNCTION crsp_val_ucl_closed(
30 p_unit_class IN IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE ,
31 p_message_name OUT NOCOPY VARCHAR2 )
32 RETURN BOOLEAN;
33 PRAGMA RESTRICT_REFERENCES (crsp_val_ucl_closed,WNDS);
34 --
35 -- Validate IGS_PS_UNIT assessment item links for invalid combinations.
36 FUNCTION assp_val_uai_links(
37 p_unit_cd IN IGS_AS_UNITASS_ITEM_ALL.unit_cd%TYPE ,
38 p_version_number IN IGS_AS_UNITASS_ITEM_ALL.version_number%TYPE ,
39 p_cal_type IN IGS_AS_UNITASS_ITEM_ALL.cal_type%TYPE ,
40 p_ci_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.ci_sequence_number%TYPE ,
41 p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE ,
42 p_sequence_number IN IGS_AS_UNITASS_ITEM_ALL.sequence_number%TYPE ,
43 --ijeddy, Bug 3201661, Grade Book.
44 p_location_cd IN VARCHAR2,
45 p_unit_mode IN IGS_AS_UNIT_MODE.unit_mode%TYPE,
46 p_unit_class IN IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,
47 p_message_name OUT NOCOPY VARCHAR2 )
48 RETURN BOOLEAN;
49
50 --
51
52 --
53 -- Validate that date is not after the assessment variation cutoff date.
54 FUNCTION ASSP_VAL_CUTOFF_DT(
55 p_cal_type IN VARCHAR2 ,
56 p_ci_sequence_number IN NUMBER ,
57 p_effective_dt IN DATE ,
58 p_message_name OUT NOCOPY VARCHAR2 )
59 RETURN BOOLEAN;
60 PRAGMA RESTRICT_REFERENCES (ASSP_VAL_CUTOFF_DT,WNDS);
61
62
63
64
65 --
66 -- Validate Calendar Instance for IGS_PS_COURSE Information.
67 FUNCTION CRSP_VAL_CRS_CI(
68 p_cal_type IN VARCHAR2 ,
69 p_ci_sequence_number IN NUMBER ,
70 p_message_name OUT NOCOPY VARCHAR2 )
71 RETURN BOOLEAN;
72 PRAGMA RESTRICT_REFERENCES (CRSP_VAL_CRS_CI,WNDS);
73
74 --
75 -- Validate IGS_PS_UNIT Offering Calendar Type.
76 FUNCTION crsp_val_uo_cal_type(
77 p_cal_type IN VARCHAR2 ,
78 p_message_name OUT NOCOPY VARCHAR2 )
79 RETURN BOOLEAN;
80 PRAGMA RESTRICT_REFERENCES (crsp_val_uo_cal_type,WNDS);
81 --
82 -- Retrofitted
83 FUNCTION assp_val_uai_uniqref(
84 p_unit_cd IN VARCHAR2 ,
85 p_version_number IN NUMBER ,
86 p_cal_type IN VARCHAR2 ,
87 p_ci_sequence_number IN NUMBER ,
88 p_sequence_number IN NUMBER ,
89 p_reference IN VARCHAR2 ,
90 p_ass_id IN NUMBER ,
91 p_message_name OUT NOCOPY VARCHAR2 )
92 RETURN BOOLEAN;
93 PRAGMA RESTRICT_REFERENCES (assp_val_uai_uniqref,WNDS);
94 --
95 -- Retrofitted
96 FUNCTION assp_val_uai_opt_ref(
97 p_unit_cd IN VARCHAR2 ,
98 p_version_number IN NUMBER ,
99 p_cal_type IN VARCHAR2 ,
100 p_ci_sequence_number IN NUMBER ,
101 p_sequence_number IN NUMBER ,
102 p_reference IN VARCHAR2 ,
103 p_ass_id IN NUMBER ,
104 p_assessment_type IN VARCHAR2 ,
105 p_message_name OUT NOCOPY VARCHAR2 )
106 RETURN BOOLEAN;
107 PRAGMA RESTRICT_REFERENCES (assp_val_uai_opt_ref,WNDS);
108 --
109 -- w.r.t Bug # 1956374 procedure assp_val_ai_exmnbl is removed
110 --
111 -- To validate the examination calendar type/sequence number of the uai
112 FUNCTION ASSP_VAL_UAI_CAL(
113 p_exam_cal_type IN VARCHAR2 ,
114 p_exam_sequence_number IN NUMBER ,
115 p_teach_cal_type IN VARCHAR2 ,
116 p_teach_sequence_number IN NUMBER ,
117 p_message_name OUT NOCOPY VARCHAR2 )
118 RETURN boolean;
119 PRAGMA RESTRICT_REFERENCES (ASSP_VAL_UAI_CAL,WNDS);
120 --
121 -- Retrofitted
122 FUNCTION assp_val_uai_sameref(
123 p_unit_cd IN VARCHAR2 ,
124 p_version_number IN NUMBER ,
125 p_cal_type IN VARCHAR2 ,
126 p_ci_sequence_number IN NUMBER ,
127 p_sequence_number IN NUMBER ,
128 p_reference IN VARCHAR2 ,
129 p_ass_id IN NUMBER ,
130 p_message_name OUT NOCOPY VARCHAR2 )
131 RETURN BOOLEAN;
132 PRAGMA RESTRICT_REFERENCES (assp_val_uai_sameref,WNDS);
133 --
134 --
135 -- Val IGS_PS_UNIT assess item applies to stud IGS_PS_UNIT IGS_AD_LOCATION, class and mode.
136 FUNCTION ASSP_VAL_SUA_UAI(
137 p_student_location_cd IN VARCHAR2 ,
138 p_student_unit_class IN VARCHAR2 ,
139 p_student_unit_mode IN VARCHAR2 ,
140 p_location_cd IN VARCHAR2 ,
141 p_unit_class IN VARCHAR2 ,
142 p_unit_mode IN VARCHAR2 )
143 RETURN CHAR;
144 PRAGMA RESTRICT_REFERENCES (ASSP_VAL_SUA_UAI,WNDS,WNPS);
145 --
146 -- Validate the IGS_PS_COURSE type for an assessment item against student IGS_PS_COURSE
147 FUNCTION ASSP_VAL_SUA_AI_ACOT(
148 p_ass_id IN NUMBER ,
149 p_person_id IN NUMBER ,
150 p_course_cd IN VARCHAR2 )
151 RETURN VARCHAR2;
152 PRAGMA RESTRICT_REFERENCES (ASSP_VAL_SUA_AI_ACOT,WNDS,WNPS);
153 --
154 -- Validate modification of IGS_PS_UNIT ass item does not conflict with uapi.
155 FUNCTION ASSP_VAL_UAI_UAPI(
156 p_unit_cd IN VARCHAR2 ,
157 p_version_number IN NUMBER ,
158 p_cal_type IN VARCHAR2 ,
159 p_ci_sequence_number IN NUMBER ,
160 p_ass_id IN NUMBER ,
161 p_sequence_number IN NUMBER ,
162 p_old_location_cd IN VARCHAR2 ,
163 p_old_unit_class IN VARCHAR2 ,
164 p_old_unit_mode IN VARCHAR2 ,
165 p_old_logical_delete_dt IN DATE ,
166 p_new_location_cd IN VARCHAR2 ,
167 p_new_unit_class IN VARCHAR2 ,
168 p_new_unit_mode IN VARCHAR2 ,
169 p_new_logical_delete_dt IN DATE ,
170 p_message_name OUT NOCOPY VARCHAR2 )
171 RETURN BOOLEAN;
172 PRAGMA RESTRICT_REFERENCES (ASSP_VAL_UAI_UAPI,WNDS);
173
174 FUNCTION assp_val_unit_sec_uniqref(
175 p_unit_cd IN VARCHAR2 ,
176 p_version_number IN NUMBER ,
177 p_cal_type IN VARCHAR2 ,
178 p_ci_sequence_number IN NUMBER ,
179 p_sequence_number IN NUMBER ,
180 p_reference IN VARCHAR2 ,
181 p_ass_id IN NUMBER ,
182 p_message_name OUT NOCOPY VARCHAR2 )
183 RETURN BOOLEAN ;
184 PRAGMA RESTRICT_REFERENCES (assp_val_unit_sec_uniqref,WNDS);
185 END IGS_AS_VAL_UAI;