1 PACKAGE IGS_PS_VAL_UV AS
2 /* $Header: IGSPS72S.pls 120.0 2005/06/01 16:06:28 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --sarakshi 02-sep-2003 Enh#3052452,removed functions crsp_val_uv_sub_ind and crsp_val_uv_sup_ind
7 --sarakshi 14-Nov-2002 Bug#2649028,modified function crsp_val_uv_pnt_ovr,crsp_val_uv_unit_sts
8 -- added parameter p_lgcy_validator
9 --smadathi 24-AUG-2001 Bug No. 1956374 .The function declaration of genp_val_staff_prsn removed
10 --bdeviset 21-JUL-004 Added procedure get_cp_values for Bug # 3782329
11
12 -------------------------------------------------------------------------------------------
13 -- Bug #1956374
14 -- As part of the bug# 1956374 removed the function crsp_val_ou_sys_sts
15 -- As part of the bug# 1956374 removed the function crsp_val_ver_dt
16
17
18 -- Validate the IGS_PS_UNIT level
19 FUNCTION crsp_val_unit_lvl(
20 p_unit_level IN CHAR ,
21 p_message_name OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN;
23
24 -- Validate the credit point descritor for IGS_PS_UNIT version.
25 FUNCTION crsp_val_uv_cp_desc(
26 P_CREDIT_POINT_DESCRIPTOR IN VARCHAR2 ,
27 p_message_name OUT NOCOPY VARCHAR2 )
28 RETURN BOOLEAN;
29 --
30 -- Validate the IGS_PS_UNIT internal IGS_PS_COURSE level for IGS_PS_UNIT version.
31 FUNCTION crsp_val_uv_uicl(
32 p_unit_int_course_level_cd IN VARCHAR2 ,
33 p_message_name OUT NOCOPY VARCHAR2 )
34 RETURN BOOLEAN;
35
36 --
37 -- Validate IGS_PS_UNIT version end date and IGS_PS_UNIT version status
38 FUNCTION crsp_val_uv_end_sts(
39 p_end_dt IN DATE ,
40 p_unit_status IN VARCHAR2 ,
41 p_message_name OUT NOCOPY VARCHAR2)
42 RETURN BOOLEAN;
43
44 --
45 -- Validate IGS_PS_UNIT version expiry date and IGS_PS_UNIT version status.
46 FUNCTION crsp_val_uv_exp_sts(
47 p_unit_cd IN VARCHAR2 ,
48 p_version_number IN NUMBER ,
49 p_expiry_dt IN DATE ,
50 p_unit_status IN VARCHAR2 ,
51 p_message_name OUT NOCOPY VARCHAR2 )
52 RETURN BOOLEAN;
53
54 --
55 -- Validate points increment, min and max fields against points override.
56 FUNCTION crsp_val_uv_pnt_ovrd(
57 p_points_override_ind IN VARCHAR2 ,
58 p_points_increment IN NUMBER ,
59 p_points_min IN NUMBER ,
60 p_points_max IN NUMBER ,
61 p_enrolled_credit_points IN NUMBER ,
62 p_achievable_credit_points IN NUMBER ,
63 p_message_name OUT NOCOPY VARCHAR2,
64 p_lgcy_validator IN BOOLEAN DEFAULT FALSE)
65 RETURN BOOLEAN;
66
67 --
68 -- Validate the IGS_PS_UNIT status for IGS_PS_UNIT version
69 FUNCTION crsp_val_uv_unit_sts(
70 p_unit_cd IN VARCHAR2 ,
71 p_version_number IN NUMBER ,
72 p_new_unit_status IN VARCHAR2 ,
73 p_old_unit_status IN VARCHAR2 ,
74 p_message_name OUT NOCOPY VARCHAR2 ,
75 p_lgcy_validator IN BOOLEAN DEFAULT FALSE)
76 RETURN BOOLEAN;
77 --
78 -- Perform quality validation checks on a IGS_PS_UNIT version and its details.
79 FUNCTION crsp_val_uv_quality(
80 p_unit_cd IN VARCHAR2 ,
81 p_version_number IN NUMBER ,
82 p_old_unit_status IN VARCHAR2 ,
83 p_message_name OUT NOCOPY VARCHAR2 )
84 RETURN BOOLEAN;
85 --
86 -- Validate supplementary exam indicator against the assessable indicator
87 FUNCTION CRSP_VAL_UV_SUP_EXAM(
88 p_supp_exam_permitted_ind IN VARCHAR2 ,
89 p_assessable_ind IN VARCHAR2 ,
90 p_message_name OUT NOCOPY VARCHAR2 )
91 RETURN BOOLEAN;
92 --
93 -- Validate students fall within new override limits set
94 FUNCTION crsp_val_uv_cp_ovrd(
95 p_unit_cd IN VARCHAR2 ,
96 p_version_number IN NUMBER ,
97 p_points_override_ind IN VARCHAR2 DEFAULT 'N',
98 p_points_min IN NUMBER ,
99 p_points_max IN NUMBER ,
100 p_points_increment IN NUMBER ,
101 p_message_name OUT NOCOPY VARCHAR2 )
102 RETURN BOOLEAN;
103
104 --
105 -- Validate discont sua with pass grade within new uv overrides.
106 FUNCTION crsp_val_uv_dsc_ovrd(
107 p_unit_cd IN VARCHAR2 ,
108 p_version_number IN NUMBER ,
109 p_points_min IN NUMBER ,
110 p_points_max IN NUMBER ,
111 p_points_increment IN NUMBER ,
112 p_message_name OUT NOCOPY VARCHAR2 )
113 RETURN BOOLEAN;
114
115 --
116 -- Validate IGS_PS_UNIT attempts when ending IGS_PS_UNIT version.
117 FUNCTION crsp_val_uv_end(
118 p_unit_cd IN VARCHAR2 ,
119 p_version_number IN NUMBER ,
120 p_return_type OUT NOCOPY VARCHAR2 ,
121 p_message_name OUT NOCOPY VARCHAR2 )
122 RETURN BOOLEAN;
123
124 --
125 -- Validate if students have IGS_EN_SU_ATTEMPT IGS_PE_TITLE override set
126 FUNCTION crsp_val_uv_ttl_ovrd(
127 p_unit_cd IN VARCHAR2 ,
128 p_version_number IN NUMBER ,
129 p_title_override_ind IN VARCHAR2 DEFAULT 'N',
130 p_message_name OUT NOCOPY VARCHAR2 )
131 RETURN BOOLEAN;
132
133 -- gets the Enrolled, Audit and Billable credit point values for the passes unit section
134 PROCEDURE get_cp_values(
135 p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE,
136 p_enrolled_cp OUT NOCOPY IGS_PS_USEC_CPS.enrolled_credit_points%TYPE,
137 p_billable_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_hrs%TYPE,
138 p_audit_cp OUT NOCOPY IGS_PS_USEC_CPS.billing_credit_points%TYPE );
139 PRAGMA RESTRICT_REFERENCES (get_cp_values,WNDS,WNPS);
140
141 END IGS_PS_VAL_UV;