1 PACKAGE IGS_EN_SUA_API AS
2 /* $Header: IGSENA0S.pls 120.0 2005/06/01 22:36:02 appldev noship $ */
3
4 EN_SUA_REC_TYPE IGS_EN_SU_ATTEMPT_ALL%ROWTYPE;
5
6 PROCEDURE create_unit_attempt (
7 X_ROWID IN OUT NOCOPY VARCHAR2,
8 X_PERSON_ID IN NUMBER,
9 X_COURSE_CD IN VARCHAR2,
10 X_UNIT_CD IN VARCHAR2,
11 X_CAL_TYPE IN VARCHAR2,
12 X_CI_SEQUENCE_NUMBER IN NUMBER,
13 X_VERSION_NUMBER IN NUMBER,
14 X_LOCATION_CD IN VARCHAR2,
15 X_UNIT_CLASS IN VARCHAR2,
16 X_CI_START_DT IN DATE,
17 X_CI_END_DT IN DATE,
18 X_UOO_ID IN NUMBER,
19 X_ENROLLED_DT IN DATE,
20 X_UNIT_ATTEMPT_STATUS IN VARCHAR2,
21 X_ADMINISTRATIVE_UNIT_STATUS IN VARCHAR2,
22 X_DISCONTINUED_DT IN DATE,
23 X_RULE_WAIVED_DT IN DATE,
24 X_RULE_WAIVED_PERSON_ID IN NUMBER,
25 X_NO_ASSESSMENT_IND IN VARCHAR2,
26 X_SUP_UNIT_CD IN VARCHAR2,
27 X_SUP_VERSION_NUMBER IN NUMBER,
28 X_EXAM_LOCATION_CD IN VARCHAR2,
29 X_ALTERNATIVE_TITLE IN VARCHAR2,
30 X_OVERRIDE_ENROLLED_CP IN NUMBER,
31 X_OVERRIDE_EFTSU IN NUMBER,
32 X_OVERRIDE_ACHIEVABLE_CP IN NUMBER,
33 X_OVERRIDE_OUTCOME_DUE_DT IN DATE,
34 X_OVERRIDE_CREDIT_REASON IN VARCHAR2,
35 X_ADMINISTRATIVE_PRIORITY IN NUMBER,
36 X_WAITLIST_DT IN DATE,
37 X_DCNT_REASON_CD IN VARCHAR2,
38 X_MODE IN VARCHAR2 DEFAULT 'R' ,
39 x_org_id IN NUMBER,
40 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
41 X_ENR_METHOD_TYPE IN VARCHAR2 DEFAULT NULL,
42 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
43 X_CART IN VARCHAR2 DEFAULT 'N',
44 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
45 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
46 X_GRADING_SCHEMA_CODE IN VARCHAR2 DEFAULT NULL,
47 X_SUBTITLE IN VARCHAR2 DEFAULT NULL,
48 -- session_id added by Nishikant 28JAN2002. Enh Bug#2172380.
49 X_SESSION_ID IN NUMBER DEFAULT NULL,
50 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
51 X_STUDENT_CAREER_TRANSCRIPT IN VARCHAR2 DEFAULT NULL,
52 X_STUDENT_CAREER_STATISTICS IN VARCHAR2 DEFAULT NULL,
53 X_WAITLIST_MANUAL_IND IN VARCHAR2 DEFAULT NULL,
54 X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
55 X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
56 X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
57 X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
58 X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
59 X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
60 X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
61 X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
62 X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
63 X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
64 X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
65 X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
66 X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
67 X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
68 X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
69 X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
70 X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
71 X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
72 X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
73 X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
74 X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL ,
75 X_WLST_PRIORITY_WEIGHT_NUM IN NUMBER DEFAULT NULL,
76 X_WLST_PREFERENCE_WEIGHT_NUM IN NUMBER DEFAULT NULL,
77 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
78 );
79
80 PROCEDURE UPDATE_UNIT_ATTEMPT (
81 X_ROWID IN VARCHAR2,
82 X_PERSON_ID IN NUMBER,
83 X_COURSE_CD IN VARCHAR2,
84 X_UNIT_CD IN VARCHAR2,
85 X_CAL_TYPE IN VARCHAR2,
86 X_CI_SEQUENCE_NUMBER IN NUMBER,
87 X_VERSION_NUMBER IN NUMBER,
88 X_LOCATION_CD IN VARCHAR2,
89 X_UNIT_CLASS IN VARCHAR2,
90 X_CI_START_DT IN DATE,
91 X_CI_END_DT IN DATE,
92 X_UOO_ID IN NUMBER,
93 X_ENROLLED_DT IN DATE,
94 X_UNIT_ATTEMPT_STATUS IN VARCHAR2,
95 X_ADMINISTRATIVE_UNIT_STATUS IN VARCHAR2,
96 X_DISCONTINUED_DT IN DATE,
97 X_RULE_WAIVED_DT IN DATE,
98 X_RULE_WAIVED_PERSON_ID IN NUMBER,
99 X_NO_ASSESSMENT_IND IN VARCHAR2,
100 X_SUP_UNIT_CD IN VARCHAR2,
101 X_SUP_VERSION_NUMBER IN NUMBER,
102 X_EXAM_LOCATION_CD IN VARCHAR2,
103 X_ALTERNATIVE_TITLE IN VARCHAR2,
104 X_OVERRIDE_ENROLLED_CP IN NUMBER,
105 X_OVERRIDE_EFTSU IN NUMBER,
106 X_OVERRIDE_ACHIEVABLE_CP IN NUMBER,
107 X_OVERRIDE_OUTCOME_DUE_DT IN DATE,
108 X_OVERRIDE_CREDIT_REASON IN VARCHAR2,
109 X_ADMINISTRATIVE_PRIORITY IN NUMBER,
110 X_WAITLIST_DT IN DATE,
111 X_DCNT_REASON_CD IN VARCHAR2,
112 X_MODE IN VARCHAR2 DEFAULT 'R',
113 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
114 X_ENR_METHOD_TYPE IN VARCHAR2 DEFAULT NULL,
115 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
116 X_CART IN VARCHAR2 DEFAULT 'N',
117 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
118 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
119 X_GRADING_SCHEMA_CODE IN VARCHAR2 DEFAULT NULL,
120 X_SUBTITLE IN VARCHAR2 DEFAULT NULL,
121 -- session_id added by Nishikant 28JAN2002. Enh Bug#2172380.
122 X_SESSION_ID IN NUMBER DEFAULT NULL,
123 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
124 X_STUDENT_CAREER_TRANSCRIPT IN VARCHAR2 DEFAULT NULL,
125 X_STUDENT_CAREER_STATISTICS IN VARCHAR2 DEFAULT NULL,
126 X_WAITLIST_MANUAL_IND IN VARCHAR2 DEFAULT NULL,
127 X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
128 X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
129 X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
130 X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
131 X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
132 X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
133 X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
134 X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
135 X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
136 X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
137 X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
138 X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
139 X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
140 X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
141 X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
142 X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
143 X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
144 X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
145 X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
146 X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
147 X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
148 X_WLST_PRIORITY_WEIGHT_NUM IN NUMBER DEFAULT NULL,
149 X_WLST_PREFERENCE_WEIGHT_NUM IN NUMBER DEFAULT NULL,
150 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
151 );
152
153
154 PROCEDURE upd_enrollment_counts( p_action IN VARCHAR2,
155 old_references EN_SUA_REC_TYPE%TYPE,
156 new_references EN_SUA_REC_TYPE%TYPE);
157
158 FUNCTION Enr_sua_sup_sub_val(
159 P_PERSON_ID IN NUMBER,
160 P_COURSE_CD IN VARCHAR2,
161 P_UOO_ID IN NUMBER,
162 P_UNIT_ATTEMPT_STATUS IN VARCHAR2,
163 P_SUP_SUB_STATUS OUT NOCOPY VARCHAR2
164 ) RETURN BOOLEAN;
165
166 FUNCTION chk_sup_del_alwd(p_person_id IN NUMBER,
167 p_course_cd IN VARCHAR2,
168 p_uoo_id IN NUMBER) RETURN BOOLEAN ;
169
170 END igs_en_sua_api;