1 PACKAGE IGS_EN_VAL_SCT AS
2 /* $Header: IGSEN66S.pls 120.0 2005/06/01 21:35:15 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 25-AUG-2001 Bug No. 1956374 .The function declaration of GENP_VAL_SDTT_SESS
7 -- removed
8 --kkillams 28-04-2003 Added new parameter p_uoo_id to the enrp_val_sua_trnsfr function
9 -- w.r.t. bug number 2829262
10 --ckasu 20-Nov-2004 modified signature of enrp_val_sua_trnsfr procedure by adding
11 -- p_unit_outcome as apart of program transfer build bug#4000939
12 -- smaddali 21-dec-04 modified parameter in procedure enrp_val_sua_acad for bug#4083358
13 -------------------------------------------------------------------------------------------
14 -- Bug #1956374
15 -- As part of the bug# 1956374 removed the function crsp_val_uv_active
16
17 --
18 -- Validate the enrolment period for a transferred course_attempt.
19 FUNCTION enrp_val_scae_acad(
20 p_person_id IN NUMBER ,
21 p_course_cd IN VARCHAR2 ,
22 p_cal_type IN VARCHAR2 ,
23 p_message_name OUT NOCOPY VARCHAR2)
24 RETURN BOOLEAN;
25 --PRAGMA RESTRICT_REFERENCES( enrp_val_scae_acad, WNDS);
26 --
27 -- Validate the IGS_PS_OFR_OPT for a transferred unit_attempt
28 -- smaddali modified parameter for bug#4083358
29 FUNCTION enrp_val_sua_acad(
30 p_person_id IN NUMBER ,
31 p_course_cd IN VARCHAR2 ,
32 p_uoo_id IN NUMBER ,
33 p_cal_type IN VARCHAR2 ,
34 p_message_name OUT NOCOPY VARCHAR2)
35 RETURN BOOLEAN;
36 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_acad , WNDS);
37 --
38 -- To validate student course transfer insert
39 FUNCTION enrp_val_sct_insert(
40 p_person_id IN NUMBER ,
41 p_course_cd IN VARCHAR2 ,
42 p_transfer_course_cd IN VARCHAR2 ,
43 p_transfer_dt IN DATE ,
44 p_message_name OUT NOCOPY VARCHAR2)
45 RETURN BOOLEAN;
46 --PRAGMA RESTRICT_REFERENCES( enrp_val_sct_insert , WNDS);
47 --
48 -- To validate student course transfer 'to' course code
49 FUNCTION enrp_val_sct_to(
50 p_person_id IN NUMBER ,
51 p_course_cd IN VARCHAR2 ,
52 p_transfer_dt IN DATE ,
53 p_crv_version_number IN NUMBER ,
54 p_course_attempt_status IN VARCHAR2 ,
55 p_admission_appl_number IN NUMBER ,
56 p_nominated_course_cd IN VARCHAR2 ,
57 p_acai_sequence_number IN NUMBER ,
58 p_message_name OUT NOCOPY VARCHAR2)
59 RETURN BOOLEAN;
60 --PRAGMA RESTRICT_REFERENCES( enrp_val_sct_to , WNDS);
61
62 --
63 -- To validate student course transfer 'from' course code
64 FUNCTION enrp_val_sct_from(
65 p_person_id IN NUMBER ,
66 p_course_cd IN VARCHAR2 ,
67 p_transfer_course_cd IN VARCHAR2 ,
68 p_transfer_dt IN DATE ,
69 p_course_attempt_status IN VARCHAR2 ,
70 p_message_name OUT NOCOPY VARCHAR2)
71 RETURN BOOLEAN;
72 --PRAGMA RESTRICT_REFERENCES( enrp_val_sct_from, WNDS);
73
74 --
75 -- To validate transfer of SUA.
76 FUNCTION enrp_val_sua_trnsfr(
77 p_person_id IN NUMBER ,
78 p_course_cd IN VARCHAR2 ,
79 p_unit_cd IN VARCHAR2 ,
80 p_cal_type IN VARCHAR2 ,
81 p_ci_sequence_number IN NUMBER ,
82 p_unit_attempt_status IN VARCHAR2 ,
83 p_message_name OUT NOCOPY VARCHAR2,
84 p_uoo_id IN NUMBER,
85 p_unit_outcome OUT NOCOPY VARCHAR2)
86 RETURN BOOLEAN;
87 --PRAGMA RESTRICT_REFERENCES( enrp_val_sua_trnsfr, WNDS);
88
89 --
90 -- To validate a student unit set attempt exists.
91 FUNCTION enrp_val_susa_exists(
92 p_person_id IN NUMBER ,
93 p_course_cd IN VARCHAR2 ,
94 p_unit_set_cd IN VARCHAR2 ,
95 p_us_version_number IN NUMBER ,
96 p_message_name OUT NOCOPY VARCHAR2)
97 RETURN BOOLEAN;
98 --PRAGMA RESTRICT_REFERENCES( enrp_val_susa_exists , WNDS);
99
100 END IGS_EN_VAL_SCT;