1 PACKAGE igs_uc_crse_dets_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSXI14S.pls 115.9 2003/06/11 10:57:36 smaddali noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_ucas_program_code IN VARCHAR2,
7 x_oss_program_code IN VARCHAR2,
8 x_oss_program_version IN NUMBER,
9 x_institute IN VARCHAR2,
10 x_uvcourse_updater IN VARCHAR2,
11 x_uvcrsevac_updater IN VARCHAR2,
12 x_short_title IN VARCHAR2,
13 x_long_title IN VARCHAR2,
14 x_ucas_campus IN VARCHAR2,
15 x_oss_location IN VARCHAR2,
16 x_faculty IN VARCHAR2,
17 x_total_no_of_seats IN NUMBER,
18 x_min_entry_points IN NUMBER,
19 x_max_entry_points IN NUMBER,
20 x_current_validity IN VARCHAR2,
21 x_deferred_validity IN VARCHAR2,
22 x_term_1_start IN DATE,
23 x_term_1_end IN DATE,
24 x_term_2_start IN DATE,
25 x_term_2_end IN DATE,
26 x_term_3_start IN DATE,
27 x_term_3_end IN DATE,
28 x_term_4_start IN DATE,
29 x_term_4_end IN DATE,
30 x_cl_updated IN VARCHAR2,
31 x_cl_date IN DATE,
32 x_vacancy_status IN VARCHAR2,
33 x_no_of_vacancy IN VARCHAR2,
34 x_score IN NUMBER,
35 x_rb_full IN VARCHAR2,
36 x_scot_vac IN VARCHAR2,
37 x_sent_to_ucas IN VARCHAR2,
38 x_ucas_system_id IN NUMBER,
39 x_mode IN VARCHAR2 DEFAULT 'R',
40 x_oss_attendance_type IN VARCHAR2 DEFAULT NULL,
41 x_oss_attendance_mode IN VARCHAR2 DEFAULT NULL,
42 x_joint_admission_ind IN VARCHAR2 DEFAULT NULL,
43 x_open_extra_ind IN VARCHAR2 DEFAULT NULL,
44 x_system_code IN VARCHAR2 DEFAULT NULL,
45 x_clearing_options IN VARCHAR2 DEFAULT NULL,
46 x_imported IN VARCHAR2 DEFAULT NULL,
47 x_keywrds_changed IN VARCHAR2 DEFAULT NULL
48 );
49
50 PROCEDURE lock_row (
51 x_rowid IN VARCHAR2,
52 x_ucas_program_code IN VARCHAR2,
53 x_oss_program_code IN VARCHAR2,
54 x_oss_program_version IN NUMBER,
55 x_institute IN VARCHAR2,
56 x_uvcourse_updater IN VARCHAR2,
57 x_uvcrsevac_updater IN VARCHAR2,
58 x_short_title IN VARCHAR2,
59 x_long_title IN VARCHAR2,
60 x_ucas_campus IN VARCHAR2,
61 x_oss_location IN VARCHAR2,
62 x_faculty IN VARCHAR2,
63 x_total_no_of_seats IN NUMBER,
64 x_min_entry_points IN NUMBER,
65 x_max_entry_points IN NUMBER,
66 x_current_validity IN VARCHAR2,
67 x_deferred_validity IN VARCHAR2,
68 x_term_1_start IN DATE,
69 x_term_1_end IN DATE,
70 x_term_2_start IN DATE,
71 x_term_2_end IN DATE,
72 x_term_3_start IN DATE,
73 x_term_3_end IN DATE,
74 x_term_4_start IN DATE,
75 x_term_4_end IN DATE,
76 x_cl_updated IN VARCHAR2,
77 x_cl_date IN DATE,
78 x_vacancy_status IN VARCHAR2,
79 x_no_of_vacancy IN VARCHAR2,
80 x_score IN NUMBER,
81 x_rb_full IN VARCHAR2,
82 x_scot_vac IN VARCHAR2,
83 x_sent_to_ucas IN VARCHAR2,
84 x_ucas_system_id IN NUMBER,
85 x_oss_attendance_type IN VARCHAR2 DEFAULT NULL,
86 x_oss_attendance_mode IN VARCHAR2 DEFAULT NULL,
87 x_joint_admission_ind IN VARCHAR2 DEFAULT NULL,
88 x_open_extra_ind IN VARCHAR2 DEFAULT NULL,
89 x_system_code IN VARCHAR2 DEFAULT NULL,
90 x_clearing_options IN VARCHAR2 DEFAULT NULL,
91 x_imported IN VARCHAR2 DEFAULT NULL,
92 x_keywrds_changed IN VARCHAR2 DEFAULT NULL
93 );
94
95 PROCEDURE update_row (
96 x_rowid IN VARCHAR2,
97 x_ucas_program_code IN VARCHAR2,
98 x_oss_program_code IN VARCHAR2,
99 x_oss_program_version IN NUMBER,
100 x_institute IN VARCHAR2,
101 x_uvcourse_updater IN VARCHAR2,
102 x_uvcrsevac_updater IN VARCHAR2,
103 x_short_title IN VARCHAR2,
104 x_long_title IN VARCHAR2,
105 x_ucas_campus IN VARCHAR2,
106 x_oss_location IN VARCHAR2,
107 x_faculty IN VARCHAR2,
108 x_total_no_of_seats IN NUMBER,
109 x_min_entry_points IN NUMBER,
110 x_max_entry_points IN NUMBER,
111 x_current_validity IN VARCHAR2,
112 x_deferred_validity IN VARCHAR2,
113 x_term_1_start IN DATE,
114 x_term_1_end IN DATE,
115 x_term_2_start IN DATE,
116 x_term_2_end IN DATE,
117 x_term_3_start IN DATE,
118 x_term_3_end IN DATE,
119 x_term_4_start IN DATE,
120 x_term_4_end IN DATE,
121 x_cl_updated IN VARCHAR2,
122 x_cl_date IN DATE,
123 x_vacancy_status IN VARCHAR2,
124 x_no_of_vacancy IN VARCHAR2,
125 x_score IN NUMBER,
126 x_rb_full IN VARCHAR2,
127 x_scot_vac IN VARCHAR2,
128 x_sent_to_ucas IN VARCHAR2,
129 x_ucas_system_id IN NUMBER,
130 x_mode IN VARCHAR2 DEFAULT 'R',
131 x_oss_attendance_type IN VARCHAR2 DEFAULT NULL,
132 x_oss_attendance_mode IN VARCHAR2 DEFAULT NULL,
133 x_joint_admission_ind IN VARCHAR2 DEFAULT NULL,
134 x_open_extra_ind IN VARCHAR2 DEFAULT NULL,
135 x_system_code IN VARCHAR2 DEFAULT NULL,
136 x_clearing_options IN VARCHAR2 DEFAULT NULL,
137 x_imported IN VARCHAR2 DEFAULT NULL,
138 x_keywrds_changed IN VARCHAR2 DEFAULT NULL
139 );
140
141 PROCEDURE add_row (
142 x_rowid IN OUT NOCOPY VARCHAR2,
143 x_ucas_program_code IN VARCHAR2,
144 x_oss_program_code IN VARCHAR2,
145 x_oss_program_version IN NUMBER,
146 x_institute IN VARCHAR2,
147 x_uvcourse_updater IN VARCHAR2,
148 x_uvcrsevac_updater IN VARCHAR2,
149 x_short_title IN VARCHAR2,
150 x_long_title IN VARCHAR2,
151 x_ucas_campus IN VARCHAR2,
152 x_oss_location IN VARCHAR2,
153 x_faculty IN VARCHAR2,
154 x_total_no_of_seats IN NUMBER,
155 x_min_entry_points IN NUMBER,
156 x_max_entry_points IN NUMBER,
157 x_current_validity IN VARCHAR2,
158 x_deferred_validity IN VARCHAR2,
159 x_term_1_start IN DATE,
160 x_term_1_end IN DATE,
161 x_term_2_start IN DATE,
162 x_term_2_end IN DATE,
163 x_term_3_start IN DATE,
164 x_term_3_end IN DATE,
165 x_term_4_start IN DATE,
166 x_term_4_end IN DATE,
167 x_cl_updated IN VARCHAR2,
168 x_cl_date IN DATE,
169 x_vacancy_status IN VARCHAR2,
170 x_no_of_vacancy IN VARCHAR2,
171 x_score IN NUMBER,
172 x_rb_full IN VARCHAR2,
173 x_scot_vac IN VARCHAR2,
174 x_sent_to_ucas IN VARCHAR2,
175 x_ucas_system_id IN NUMBER,
176 x_mode IN VARCHAR2 DEFAULT 'R',
177 x_oss_attendance_type IN VARCHAR2 DEFAULT NULL,
178 x_oss_attendance_mode IN VARCHAR2 DEFAULT NULL,
179 x_joint_admission_ind IN VARCHAR2 DEFAULT NULL,
180 x_open_extra_ind IN VARCHAR2 DEFAULT NULL,
181 x_system_code IN VARCHAR2 DEFAULT NULL,
182 x_clearing_options IN VARCHAR2 DEFAULT NULL,
183 x_imported IN VARCHAR2 DEFAULT NULL,
184 x_keywrds_changed IN VARCHAR2 DEFAULT NULL
185 );
186
187 FUNCTION get_pk_for_validation (
188 x_ucas_program_code IN VARCHAR2,
189 x_institute IN VARCHAR2,
190 x_ucas_campus IN VARCHAR2,
191 x_system_code IN VARCHAR2
192 ) RETURN BOOLEAN;
193
194 -- smaddali added this procedure for ucfd203 - multiple cycles build bug#2669208
195 PROCEDURE get_fk_igs_uc_defaults (
196 x_system_code IN VARCHAR2
197 );
198
199 PROCEDURE before_dml (
200 p_action IN VARCHAR2,
201 x_rowid IN VARCHAR2 DEFAULT NULL,
202 x_ucas_program_code IN VARCHAR2 DEFAULT NULL,
203 x_oss_program_code IN VARCHAR2 DEFAULT NULL,
204 x_oss_program_version IN NUMBER DEFAULT NULL,
205 x_institute IN VARCHAR2 DEFAULT NULL,
206 x_uvcourse_updater IN VARCHAR2 DEFAULT NULL,
207 x_uvcrsevac_updater IN VARCHAR2 DEFAULT NULL,
208 x_short_title IN VARCHAR2 DEFAULT NULL,
209 x_long_title IN VARCHAR2 DEFAULT NULL,
210 x_ucas_campus IN VARCHAR2 DEFAULT NULL,
211 x_oss_location IN VARCHAR2 DEFAULT NULL,
212 x_faculty IN VARCHAR2 DEFAULT NULL,
213 x_total_no_of_seats IN NUMBER DEFAULT NULL,
214 x_min_entry_points IN NUMBER DEFAULT NULL,
215 x_max_entry_points IN NUMBER DEFAULT NULL,
216 x_current_validity IN VARCHAR2 DEFAULT NULL,
217 x_deferred_validity IN VARCHAR2 DEFAULT NULL,
218 x_term_1_start IN DATE DEFAULT NULL,
219 x_term_1_end IN DATE DEFAULT NULL,
220 x_term_2_start IN DATE DEFAULT NULL,
221 x_term_2_end IN DATE DEFAULT NULL,
222 x_term_3_start IN DATE DEFAULT NULL,
223 x_term_3_end IN DATE DEFAULT NULL,
224 x_term_4_start IN DATE DEFAULT NULL,
225 x_term_4_end IN DATE DEFAULT NULL,
226 x_cl_updated IN VARCHAR2 DEFAULT NULL,
227 x_cl_date IN DATE DEFAULT NULL,
228 x_vacancy_status IN VARCHAR2 DEFAULT NULL,
229 x_no_of_vacancy IN VARCHAR2 DEFAULT NULL,
230 x_score IN NUMBER DEFAULT NULL,
231 x_rb_full IN VARCHAR2 DEFAULT NULL,
232 x_scot_vac IN VARCHAR2 DEFAULT NULL,
233 x_sent_to_ucas IN VARCHAR2 DEFAULT NULL,
234 x_creation_date IN DATE DEFAULT NULL,
235 x_created_by IN NUMBER DEFAULT NULL,
236 x_last_update_date IN DATE DEFAULT NULL,
237 x_last_updated_by IN NUMBER DEFAULT NULL,
238 x_last_update_login IN NUMBER DEFAULT NULL,
239 x_ucas_system_id IN NUMBER DEFAULT NULL,
240 x_oss_attendance_type IN VARCHAR2 DEFAULT NULL,
241 x_oss_attendance_mode IN VARCHAR2 DEFAULT NULL,
242 x_joint_admission_ind IN VARCHAR2 DEFAULT NULL,
243 x_open_extra_ind IN VARCHAR2 DEFAULT NULL,
244 x_system_code IN VARCHAR2 DEFAULT NULL,
245 x_clearing_options IN VARCHAR2 DEFAULT NULL,
246 x_imported IN VARCHAR2 DEFAULT NULL,
247 x_keywrds_changed IN VARCHAR2 DEFAULT NULL
248 );
249
250 END igs_uc_crse_dets_pkg;