1 PACKAGE IGS_RU_VAL_UNIT_RULE AS
2 /* $Header: IGSRU09S.pls 120.1 2005/09/30 06:50:50 appldev ship $ */
3 /* smaddali added new parameters to all the functions for
4 enrollment processes bug# 1832130 */
5 --
6 -- Validate co-requisite rules for a student IGS_PS_UNIT attempt
7 FUNCTION RULP_VAL_COREQ(
8 p_person_id IN NUMBER ,
9 p_course_cd IN VARCHAR2 ,
10 p_unit_cd IN VARCHAR2 ,
11 p_cal_type IN VARCHAR2 ,
12 p_ci_sequence_number IN NUMBER ,
13 p_message_text OUT NOCOPY VARCHAR2 ,
14 -- added new parameters for bug#1832130
15 p_course_version IN NUMBER DEFAULT NULL,
16 p_unit_ver IN NUMBER DEFAULT NULL,
17 p_uoo_id IN NUMBER DEFAULT NULL,
18 p_rule_failed OUT NOCOPY VARCHAR2 )
19 RETURN boolean;
20
21 -- To validate for incompatible student IGS_PS_UNIT attempts
22 FUNCTION RULP_VAL_INCOMP(
23 p_person_id IN NUMBER ,
24 p_course_cd IN VARCHAR2 ,
25 p_unit_cd IN VARCHAR2 ,
26 p_cal_type IN VARCHAR2 ,
27 p_ci_sequence_number IN NUMBER ,
28 p_message_text OUT NOCOPY VARCHAR2 ,
29 -- added new parameters for bug#1832130
30 p_course_version IN NUMBER DEFAULT NULL,
31 p_unit_ver IN NUMBER DEFAULT NULL,
32 p_uoo_id IN NUMBER DEFAULT NULL,
33 p_rule_failed OUT NOCOPY VARCHAR2 )
34 RETURN boolean;
35
36 -- Validate the pre-requisite rules for a student IGS_PS_UNIT attempt
37 FUNCTION RULP_VAL_PREREQ(
38 p_person_id IN NUMBER ,
39 p_course_cd IN VARCHAR2 ,
40 p_unit_cd IN VARCHAR2 ,
41 p_cal_type IN VARCHAR2 ,
42 p_ci_sequence_number IN NUMBER ,
43 p_message_text OUT NOCOPY VARCHAR2 ,
44 -- added new parameters for bug#1832130
45 p_course_version IN NUMBER DEFAULT NULL,
46 p_unit_ver IN NUMBER DEFAULT NULL,
47 p_uoo_id IN NUMBER DEFAULT NULL,
48 p_rule_failed OUT NOCOPY VARCHAR2 )
49 RETURN boolean;
50
51 -- Validate the enrolment rules for a student IGS_PS_UNIT attempt
52 FUNCTION RULP_VAL_ENROL_UNIT(
53 p_person_id IN NUMBER ,
54 p_course_cd IN VARCHAR2 ,
55 p_course_version NUMBER DEFAULT NULL,
56 p_unit_cd IN VARCHAR2 ,
57 p_unit_version NUMBER ,
58 p_cal_type IN VARCHAR2 ,
59 p_ci_sequence_number IN NUMBER ,
60 p_message_text OUT NOCOPY VARCHAR2 ,
61 -- added new parameters for bug#1832130
62 p_uoo_id IN NUMBER DEFAULT NULL,
63 p_rule_failed OUT NOCOPY VARCHAR2 )
64 RETURN boolean;
65
66 END IGS_RU_VAL_UNIT_RULE;