1 PACKAGE Igs_As_Doc_Details_Pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSDI71S.pls 115.3 2002/11/28 23:29:29 nsidana noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_order_number IN NUMBER,
7 x_document_type IN VARCHAR2,
8 x_document_sub_type IN VARCHAR2,
9 x_item_number IN OUT NOCOPY NUMBER,
10 x_item_status IN VARCHAR2,
11 x_date_produced IN DATE,
12 x_incl_curr_course IN VARCHAR2,
13 x_num_of_copies IN NUMBER,
14 x_comments IN VARCHAR2,
15 x_recip_pers_name IN VARCHAR2,
16 x_recip_inst_name IN VARCHAR2,
17 x_recip_addr_line_1 IN VARCHAR2,
18 x_recip_addr_line_2 IN VARCHAR2,
19 x_recip_addr_line_3 IN VARCHAR2,
20 x_recip_addr_line_4 IN VARCHAR2,
21 x_recip_city IN VARCHAR2,
22 x_recip_postal_code IN VARCHAR2,
23 x_recip_state IN VARCHAR2,
24 x_recip_province IN VARCHAR2,
25 x_recip_county IN VARCHAR2,
26 x_recip_country IN VARCHAR2,
27 x_recip_fax_area_code IN VARCHAR2,
28 x_recip_fax_country_code IN VARCHAR2,
29 x_recip_fax_number IN VARCHAR2,
30 x_delivery_method_type IN VARCHAR2,
31 x_programs_on_file IN VARCHAR2,
32 x_missing_acad_record_data_ind IN VARCHAR2,
33 x_missing_academic_record_data IN VARCHAR2,
34 x_send_transcript_immediately IN VARCHAR2,
35 x_hold_release_of_final_grades IN VARCHAR2,
36 x_fgrade_cal_type IN VARCHAR2,
37 x_fgrade_seq_num IN NUMBER,
38 x_hold_degree_expected IN VARCHAR2,
39 x_deghold_cal_type IN VARCHAR2,
40 x_deghold_seq_num IN NUMBER,
41 x_hold_for_grade_chg IN VARCHAR2,
42 x_special_instr IN VARCHAR2,
43 x_express_mail_type IN VARCHAR2,
44 x_express_mail_track_num IN VARCHAR2,
45 x_ge_certification IN VARCHAR2,
46 x_external_comments IN VARCHAR2,
47 x_internal_comments IN VARCHAR2,
48 x_dup_requested IN VARCHAR2,
49 x_dup_req_date IN DATE,
50 x_dup_sent_date IN DATE,
51 x_enr_term_cal_type IN VARCHAR2,
52 x_enr_ci_sequence_number IN NUMBER,
53 x_incl_attempted_hours IN VARCHAR2,
54 x_incl_class_rank IN VARCHAR2,
55 x_incl_progresssion_status IN VARCHAR2,
56 x_incl_class_standing IN VARCHAR2,
57 x_incl_cum_hours_earned IN VARCHAR2,
58 x_incl_gpa IN VARCHAR2,
59 x_incl_date_of_graduation IN VARCHAR2,
60 x_incl_degree_dates IN VARCHAR2,
61 x_incl_degree_earned IN VARCHAR2,
62 x_incl_date_of_entry IN VARCHAR2,
63 x_incl_drop_withdrawal_dates IN VARCHAR2,
64 x_incl_hrs_for_curr_term IN VARCHAR2,
65 x_incl_majors IN VARCHAR2,
66 x_incl_last_date_of_enrollment IN VARCHAR2,
67 x_incl_professional_licensure IN VARCHAR2,
68 x_incl_college_affiliation IN VARCHAR2,
69 x_incl_instruction_dates IN VARCHAR2,
70 x_incl_usec_dates IN VARCHAR2,
71 x_incl_program_attempt IN VARCHAR2,
72 x_incl_attendence_type IN VARCHAR2,
73 x_incl_last_term_enrolled IN VARCHAR2,
74 x_incl_ssn IN VARCHAR2,
75 x_incl_date_of_birth IN VARCHAR2,
76 x_incl_disciplin_standing IN VARCHAR2,
77 x_incl_no_future_term IN VARCHAR2,
78 x_incl_acurat_till_copmp_dt IN VARCHAR2,
79 x_incl_cant_rel_without_sign IN VARCHAR2,
80 x_mode IN VARCHAR2 DEFAULT 'R' ,
81 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
82 X_MSG_DATA OUT NOCOPY VARCHAR2,
83 X_MSG_COUNT OUT NOCOPY NUMBER,
84 X_DOC_FEE_PER_COPY IN NUMBER,
85 X_DELIVERY_FEE IN NUMBER,
86 X_RECIP_EMAIL IN VARCHAR2,
87 x_overridden_doc_delivery_fee IN NUMBER DEFAULT NULL,
88 x_overridden_document_fee IN NUMBER DEFAULT NULL,
89 x_fee_overridden_by IN NUMBER DEFAULT NULL,
90 x_fee_overridden_date IN DATE DEFAULT NULL,
91 x_incl_department IN VARCHAR2 DEFAULT NULL,
92 x_incl_field_of_stdy IN VARCHAR2 DEFAULT NULL,
93 x_incl_attend_mode IN VARCHAR2 DEFAULT NULL,
94 x_incl_yop_acad_prd IN VARCHAR2 DEFAULT NULL,
95 x_incl_intrmsn_st_end IN VARCHAR2 DEFAULT NULL,
96 x_incl_hnrs_lvl IN VARCHAR2 DEFAULT NULL,
97 x_incl_awards IN VARCHAR2 DEFAULT NULL,
98 x_incl_award_aim IN VARCHAR2 DEFAULT NULL,
99 x_incl_acad_sessions IN VARCHAR2 DEFAULT NULL,
100 x_incl_st_end_acad_ses IN VARCHAR2 DEFAULT NULL,
101 x_incl_hesa_num IN VARCHAR2 DEFAULT NULL,
102 x_incl_location IN VARCHAR2 DEFAULT NULL,
103 x_incl_program_type IN VARCHAR2 DEFAULT NULL,
104 x_incl_program_name IN VARCHAR2 DEFAULT NULL,
105 x_incl_prog_atmpt_stat IN VARCHAR2 DEFAULT NULL,
106 x_incl_prog_atmpt_end IN VARCHAR2 DEFAULT NULL,
107 x_incl_prog_atmpt_strt IN VARCHAR2 DEFAULT NULL,
108 x_incl_req_cmplete IN VARCHAR2 DEFAULT NULL,
109 x_incl_expected_compl_dt IN VARCHAR2 DEFAULT NULL,
110 x_incl_conferral_dt IN VARCHAR2 DEFAULT NULL,
111 x_incl_thesis_title IN VARCHAR2 DEFAULT NULL,
112 x_incl_program_code IN VARCHAR2 DEFAULT NULL,
113 x_incl_program_ver IN VARCHAR2 DEFAULT NULL,
114 x_incl_stud_no IN VARCHAR2 DEFAULT NULL,
115 x_incl_surname IN VARCHAR2 DEFAULT NULL,
116 x_incl_fore_name IN VARCHAR2 DEFAULT NULL,
117 x_incl_prev_names IN VARCHAR2 DEFAULT NULL,
118 x_incl_initials IN VARCHAR2 DEFAULT NULL,
119 x_doc_purpose_code IN VARCHAR2 DEFAULT NULL,
120 x_plan_id IN NUMBER DEFAULT NULL,
121 x_produced_by IN NUMBER DEFAULT NULL,
122 x_person_id IN NUMBER DEFAULT NULL
123 );
124
125 PROCEDURE lock_row (
126 x_rowid IN VARCHAR2,
127 x_order_number IN NUMBER,
128 x_document_type IN VARCHAR2,
129 x_document_sub_type IN VARCHAR2,
130 x_item_number IN NUMBER,
131 x_item_status IN VARCHAR2,
132 x_date_produced IN DATE,
133 x_incl_curr_course IN VARCHAR2,
134 x_num_of_copies IN NUMBER,
135 x_comments IN VARCHAR2,
136 x_recip_pers_name IN VARCHAR2,
137 x_recip_inst_name IN VARCHAR2,
138 x_recip_addr_line_1 IN VARCHAR2,
139 x_recip_addr_line_2 IN VARCHAR2,
140 x_recip_addr_line_3 IN VARCHAR2,
141 x_recip_addr_line_4 IN VARCHAR2,
142 x_recip_city IN VARCHAR2,
143 x_recip_postal_code IN VARCHAR2,
144 x_recip_state IN VARCHAR2,
145 x_recip_province IN VARCHAR2,
146 x_recip_county IN VARCHAR2,
147 x_recip_country IN VARCHAR2,
148 x_recip_fax_area_code IN VARCHAR2,
149 x_recip_fax_country_code IN VARCHAR2,
150 x_recip_fax_number IN VARCHAR2,
151 x_delivery_method_type IN VARCHAR2,
152 x_programs_on_file IN VARCHAR2,
153 x_missing_acad_record_data_ind IN VARCHAR2,
154 x_missing_academic_record_data IN VARCHAR2,
155 x_send_transcript_immediately IN VARCHAR2,
156 x_hold_release_of_final_grades IN VARCHAR2,
157 x_fgrade_cal_type IN VARCHAR2,
158 x_fgrade_seq_num IN NUMBER,
159 x_hold_degree_expected IN VARCHAR2,
160 x_deghold_cal_type IN VARCHAR2,
161 x_deghold_seq_num IN NUMBER,
162 x_hold_for_grade_chg IN VARCHAR2,
163 x_special_instr IN VARCHAR2,
164 x_express_mail_type IN VARCHAR2,
165 x_express_mail_track_num IN VARCHAR2,
166 x_ge_certification IN VARCHAR2,
167 x_external_comments IN VARCHAR2,
168 x_internal_comments IN VARCHAR2,
169 x_dup_requested IN VARCHAR2,
170 x_dup_req_date IN DATE,
171 x_dup_sent_date IN DATE,
172 x_enr_term_cal_type IN VARCHAR2,
173 x_enr_ci_sequence_number IN NUMBER,
174 x_incl_attempted_hours IN VARCHAR2,
175 x_incl_class_rank IN VARCHAR2,
176 x_incl_progresssion_status IN VARCHAR2,
177 x_incl_class_standing IN VARCHAR2,
178 x_incl_cum_hours_earned IN VARCHAR2,
179 x_incl_gpa IN VARCHAR2,
180 x_incl_date_of_graduation IN VARCHAR2,
181 x_incl_degree_dates IN VARCHAR2,
182 x_incl_degree_earned IN VARCHAR2,
183 x_incl_date_of_entry IN VARCHAR2,
184 x_incl_drop_withdrawal_dates IN VARCHAR2,
185 x_incl_hrs_for_curr_term IN VARCHAR2,
186 x_incl_majors IN VARCHAR2,
187 x_incl_last_date_of_enrollment IN VARCHAR2,
188 x_incl_professional_licensure IN VARCHAR2,
189 x_incl_college_affiliation IN VARCHAR2,
190 x_incl_instruction_dates IN VARCHAR2,
191 x_incl_usec_dates IN VARCHAR2,
192 x_incl_program_attempt IN VARCHAR2,
193 x_incl_attendence_type IN VARCHAR2,
194 x_incl_last_term_enrolled IN VARCHAR2,
195 x_incl_ssn IN VARCHAR2,
196 x_incl_date_of_birth IN VARCHAR2,
197 x_incl_disciplin_standing IN VARCHAR2,
198 x_incl_no_future_term IN VARCHAR2,
199 x_incl_acurat_till_copmp_dt IN VARCHAR2,
200 x_incl_cant_rel_without_sign IN VARCHAR2,
201 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
202 X_MSG_DATA OUT NOCOPY VARCHAR2,
203 X_MSG_COUNT OUT NOCOPY NUMBER,
204 X_DOC_FEE_PER_COPY IN NUMBER,
205 X_DELIVERY_FEE IN NUMBER,
206 X_RECIP_EMAIL IN VARCHAR2,
207 x_overridden_doc_delivery_fee IN NUMBER DEFAULT NULL,
208 x_overridden_document_fee IN NUMBER DEFAULT NULL,
209 x_fee_overridden_by IN NUMBER DEFAULT NULL,
210 x_fee_overridden_date IN DATE DEFAULT NULL,
211 x_incl_department IN VARCHAR2 DEFAULT NULL,
212 x_incl_field_of_stdy IN VARCHAR2 DEFAULT NULL,
213 x_incl_attend_mode IN VARCHAR2 DEFAULT NULL,
214 x_incl_yop_acad_prd IN VARCHAR2 DEFAULT NULL,
215 x_incl_intrmsn_st_end IN VARCHAR2 DEFAULT NULL,
216 x_incl_hnrs_lvl IN VARCHAR2 DEFAULT NULL,
217 x_incl_awards IN VARCHAR2 DEFAULT NULL,
218 x_incl_award_aim IN VARCHAR2 DEFAULT NULL,
219 x_incl_acad_sessions IN VARCHAR2 DEFAULT NULL,
220 x_incl_st_end_acad_ses IN VARCHAR2 DEFAULT NULL,
221 x_incl_hesa_num IN VARCHAR2 DEFAULT NULL,
222 x_incl_location IN VARCHAR2 DEFAULT NULL,
223 x_incl_program_type IN VARCHAR2 DEFAULT NULL,
224 x_incl_program_name IN VARCHAR2 DEFAULT NULL,
225 x_incl_prog_atmpt_stat IN VARCHAR2 DEFAULT NULL,
226 x_incl_prog_atmpt_end IN VARCHAR2 DEFAULT NULL,
227 x_incl_prog_atmpt_strt IN VARCHAR2 DEFAULT NULL,
228 x_incl_req_cmplete IN VARCHAR2 DEFAULT NULL,
229 x_incl_expected_compl_dt IN VARCHAR2 DEFAULT NULL,
230 x_incl_conferral_dt IN VARCHAR2 DEFAULT NULL,
231 x_incl_thesis_title IN VARCHAR2 DEFAULT NULL,
232 x_incl_program_code IN VARCHAR2 DEFAULT NULL,
233 x_incl_program_ver IN VARCHAR2 DEFAULT NULL,
234 x_incl_stud_no IN VARCHAR2 DEFAULT NULL,
235 x_incl_surname IN VARCHAR2 DEFAULT NULL,
236 x_incl_fore_name IN VARCHAR2 DEFAULT NULL,
237 x_incl_prev_names IN VARCHAR2 DEFAULT NULL,
238 x_incl_initials IN VARCHAR2 DEFAULT NULL,
239 x_doc_purpose_code IN VARCHAR2 DEFAULT NULL,
240 x_plan_id IN NUMBER DEFAULT NULL,
241 x_produced_by IN NUMBER DEFAULT NULL,
242 x_person_id IN NUMBER DEFAULT NULL
243 );
244
245 PROCEDURE update_row (
246 x_rowid IN VARCHAR2,
247 x_order_number IN NUMBER,
248 x_document_type IN VARCHAR2,
249 x_document_sub_type IN VARCHAR2,
250 x_item_number IN NUMBER,
251 x_item_status IN VARCHAR2,
252 x_date_produced IN DATE,
253 x_incl_curr_course IN VARCHAR2,
254 x_num_of_copies IN NUMBER,
255 x_comments IN VARCHAR2,
256 x_recip_pers_name IN VARCHAR2,
257 x_recip_inst_name IN VARCHAR2,
258 x_recip_addr_line_1 IN VARCHAR2,
259 x_recip_addr_line_2 IN VARCHAR2,
260 x_recip_addr_line_3 IN VARCHAR2,
261 x_recip_addr_line_4 IN VARCHAR2,
262 x_recip_city IN VARCHAR2,
263 x_recip_postal_code IN VARCHAR2,
264 x_recip_state IN VARCHAR2,
265 x_recip_province IN VARCHAR2,
266 x_recip_county IN VARCHAR2,
267 x_recip_country IN VARCHAR2,
268 x_recip_fax_area_code IN VARCHAR2,
269 x_recip_fax_country_code IN VARCHAR2,
270 x_recip_fax_number IN VARCHAR2,
271 x_delivery_method_type IN VARCHAR2,
272 x_programs_on_file IN VARCHAR2,
273 x_missing_acad_record_data_ind IN VARCHAR2,
274 x_missing_academic_record_data IN VARCHAR2,
275 x_send_transcript_immediately IN VARCHAR2,
276 x_hold_release_of_final_grades IN VARCHAR2,
277 x_fgrade_cal_type IN VARCHAR2,
278 x_fgrade_seq_num IN NUMBER,
279 x_hold_degree_expected IN VARCHAR2,
280 x_deghold_cal_type IN VARCHAR2,
284 x_express_mail_type IN VARCHAR2,
281 x_deghold_seq_num IN NUMBER,
282 x_hold_for_grade_chg IN VARCHAR2,
283 x_special_instr IN VARCHAR2,
285 x_express_mail_track_num IN VARCHAR2,
286 x_ge_certification IN VARCHAR2,
287 x_external_comments IN VARCHAR2,
288 x_internal_comments IN VARCHAR2,
289 x_dup_requested IN VARCHAR2,
290 x_dup_req_date IN DATE,
291 x_dup_sent_date IN DATE,
292 x_enr_term_cal_type IN VARCHAR2,
293 x_enr_ci_sequence_number IN NUMBER,
294 x_incl_attempted_hours IN VARCHAR2,
295 x_incl_class_rank IN VARCHAR2,
296 x_incl_progresssion_status IN VARCHAR2,
297 x_incl_class_standing IN VARCHAR2,
298 x_incl_cum_hours_earned IN VARCHAR2,
299 x_incl_gpa IN VARCHAR2,
300 x_incl_date_of_graduation IN VARCHAR2,
301 x_incl_degree_dates IN VARCHAR2,
302 x_incl_degree_earned IN VARCHAR2,
303 x_incl_date_of_entry IN VARCHAR2,
304 x_incl_drop_withdrawal_dates IN VARCHAR2,
305 x_incl_hrs_for_curr_term IN VARCHAR2,
306 x_incl_majors IN VARCHAR2,
307 x_incl_last_date_of_enrollment IN VARCHAR2,
308 x_incl_professional_licensure IN VARCHAR2,
309 x_incl_college_affiliation IN VARCHAR2,
310 x_incl_instruction_dates IN VARCHAR2,
311 x_incl_usec_dates IN VARCHAR2,
312 x_incl_program_attempt IN VARCHAR2,
313 x_incl_attendence_type IN VARCHAR2,
314 x_incl_last_term_enrolled IN VARCHAR2,
315 x_incl_ssn IN VARCHAR2,
316 x_incl_date_of_birth IN VARCHAR2,
317 x_incl_disciplin_standing IN VARCHAR2,
318 x_incl_no_future_term IN VARCHAR2,
319 x_incl_acurat_till_copmp_dt IN VARCHAR2,
320 x_incl_cant_rel_without_sign IN VARCHAR2,
321 x_mode IN VARCHAR2 DEFAULT 'R' ,
322 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
323 X_MSG_DATA OUT NOCOPY VARCHAR2,
324 X_MSG_COUNT OUT NOCOPY NUMBER,
325 X_DOC_FEE_PER_COPY IN NUMBER,
326 X_DELIVERY_FEE IN NUMBER,
327 X_RECIP_EMAIL IN VARCHAR2,
328 x_overridden_doc_delivery_fee IN NUMBER DEFAULT NULL,
329 x_overridden_document_fee IN NUMBER DEFAULT NULL,
330 x_fee_overridden_by IN NUMBER DEFAULT NULL,
331 x_fee_overridden_date IN DATE DEFAULT NULL,
332 x_incl_department IN VARCHAR2 DEFAULT NULL,
333 x_incl_field_of_stdy IN VARCHAR2 DEFAULT NULL,
334 x_incl_attend_mode IN VARCHAR2 DEFAULT NULL,
335 x_incl_yop_acad_prd IN VARCHAR2 DEFAULT NULL,
336 x_incl_intrmsn_st_end IN VARCHAR2 DEFAULT NULL,
337 x_incl_hnrs_lvl IN VARCHAR2 DEFAULT NULL,
338 x_incl_awards IN VARCHAR2 DEFAULT NULL,
339 x_incl_award_aim IN VARCHAR2 DEFAULT NULL,
340 x_incl_acad_sessions IN VARCHAR2 DEFAULT NULL,
341 x_incl_st_end_acad_ses IN VARCHAR2 DEFAULT NULL,
342 x_incl_hesa_num IN VARCHAR2 DEFAULT NULL,
343 x_incl_location IN VARCHAR2 DEFAULT NULL,
344 x_incl_program_type IN VARCHAR2 DEFAULT NULL,
345 x_incl_program_name IN VARCHAR2 DEFAULT NULL,
346 x_incl_prog_atmpt_stat IN VARCHAR2 DEFAULT NULL,
347 x_incl_prog_atmpt_end IN VARCHAR2 DEFAULT NULL,
348 x_incl_prog_atmpt_strt IN VARCHAR2 DEFAULT NULL,
349 x_incl_req_cmplete IN VARCHAR2 DEFAULT NULL,
350 x_incl_expected_compl_dt IN VARCHAR2 DEFAULT NULL,
351 x_incl_conferral_dt IN VARCHAR2 DEFAULT NULL,
352 x_incl_thesis_title IN VARCHAR2 DEFAULT NULL,
353 x_incl_program_code IN VARCHAR2 DEFAULT NULL,
354 x_incl_program_ver IN VARCHAR2 DEFAULT NULL,
355 x_incl_stud_no IN VARCHAR2 DEFAULT NULL,
356 x_incl_surname IN VARCHAR2 DEFAULT NULL,
357 x_incl_fore_name IN VARCHAR2 DEFAULT NULL,
358 x_incl_prev_names IN VARCHAR2 DEFAULT NULL,
359 x_incl_initials IN VARCHAR2 DEFAULT NULL,
360 x_doc_purpose_code IN VARCHAR2 DEFAULT NULL,
361 x_plan_id IN NUMBER DEFAULT NULL,
362 x_produced_by IN NUMBER DEFAULT NULL,
363 x_person_id IN NUMBER DEFAULT NULL
364 );
365
366 PROCEDURE add_row (
367 x_rowid IN OUT NOCOPY VARCHAR2,
368 x_order_number IN NUMBER,
369 x_document_type IN VARCHAR2,
370 x_document_sub_type IN VARCHAR2,
371 x_item_number IN OUT NOCOPY NUMBER,
375 x_num_of_copies IN NUMBER,
372 x_item_status IN VARCHAR2,
373 x_date_produced IN DATE,
374 x_incl_curr_course IN VARCHAR2,
376 x_comments IN VARCHAR2,
377 x_recip_pers_name IN VARCHAR2,
378 x_recip_inst_name IN VARCHAR2,
379 x_recip_addr_line_1 IN VARCHAR2,
380 x_recip_addr_line_2 IN VARCHAR2,
381 x_recip_addr_line_3 IN VARCHAR2,
382 x_recip_addr_line_4 IN VARCHAR2,
383 x_recip_city IN VARCHAR2,
384 x_recip_postal_code IN VARCHAR2,
385 x_recip_state IN VARCHAR2,
386 x_recip_province IN VARCHAR2,
387 x_recip_county IN VARCHAR2,
388 x_recip_country IN VARCHAR2,
389 x_recip_fax_area_code IN VARCHAR2,
390 x_recip_fax_country_code IN VARCHAR2,
391 x_recip_fax_number IN VARCHAR2,
392 x_delivery_method_type IN VARCHAR2,
393 x_programs_on_file IN VARCHAR2,
394 x_missing_acad_record_data_ind IN VARCHAR2,
395 x_missing_academic_record_data IN VARCHAR2,
396 x_send_transcript_immediately IN VARCHAR2,
397 x_hold_release_of_final_grades IN VARCHAR2,
398 x_fgrade_cal_type IN VARCHAR2,
399 x_fgrade_seq_num IN NUMBER,
400 x_hold_degree_expected IN VARCHAR2,
401 x_deghold_cal_type IN VARCHAR2,
402 x_deghold_seq_num IN NUMBER,
403 x_hold_for_grade_chg IN VARCHAR2,
404 x_special_instr IN VARCHAR2,
405 x_express_mail_type IN VARCHAR2,
406 x_express_mail_track_num IN VARCHAR2,
407 x_ge_certification IN VARCHAR2,
408 x_external_comments IN VARCHAR2,
409 x_internal_comments IN VARCHAR2,
410 x_dup_requested IN VARCHAR2,
411 x_dup_req_date IN DATE,
412 x_dup_sent_date IN DATE,
413 x_enr_term_cal_type IN VARCHAR2,
414 x_enr_ci_sequence_number IN NUMBER,
415 x_incl_attempted_hours IN VARCHAR2,
416 x_incl_class_rank IN VARCHAR2,
417 x_incl_progresssion_status IN VARCHAR2,
418 x_incl_class_standing IN VARCHAR2,
419 x_incl_cum_hours_earned IN VARCHAR2,
420 x_incl_gpa IN VARCHAR2,
421 x_incl_date_of_graduation IN VARCHAR2,
422 x_incl_degree_dates IN VARCHAR2,
423 x_incl_degree_earned IN VARCHAR2,
424 x_incl_date_of_entry IN VARCHAR2,
425 x_incl_drop_withdrawal_dates IN VARCHAR2,
426 x_incl_hrs_for_curr_term IN VARCHAR2,
427 x_incl_majors IN VARCHAR2,
428 x_incl_last_date_of_enrollment IN VARCHAR2,
429 x_incl_professional_licensure IN VARCHAR2,
430 x_incl_college_affiliation IN VARCHAR2,
431 x_incl_instruction_dates IN VARCHAR2,
432 x_incl_usec_dates IN VARCHAR2,
433 x_incl_program_attempt IN VARCHAR2,
434 x_incl_attendence_type IN VARCHAR2,
435 x_incl_last_term_enrolled IN VARCHAR2,
436 x_incl_ssn IN VARCHAR2,
437 x_incl_date_of_birth IN VARCHAR2,
438 x_incl_disciplin_standing IN VARCHAR2,
439 x_incl_no_future_term IN VARCHAR2,
440 x_incl_acurat_till_copmp_dt IN VARCHAR2,
441 x_incl_cant_rel_without_sign IN VARCHAR2,
442 x_mode IN VARCHAR2 DEFAULT 'R',
443 X_DOC_FEE_PER_COPY IN NUMBER,
444 X_DELIVERY_FEE IN NUMBER,
445 X_RECIP_EMAIL IN VARCHAR2,
446 x_overridden_doc_delivery_fee IN NUMBER DEFAULT NULL,
447 x_overridden_document_fee IN NUMBER DEFAULT NULL,
448 x_fee_overridden_by IN NUMBER DEFAULT NULL,
449 x_fee_overridden_date IN DATE DEFAULT NULL,
450 x_incl_department IN VARCHAR2 DEFAULT NULL,
451 x_incl_field_of_stdy IN VARCHAR2 DEFAULT NULL,
452 x_incl_attend_mode IN VARCHAR2 DEFAULT NULL,
453 x_incl_yop_acad_prd IN VARCHAR2 DEFAULT NULL,
454 x_incl_intrmsn_st_end IN VARCHAR2 DEFAULT NULL,
455 x_incl_hnrs_lvl IN VARCHAR2 DEFAULT NULL,
456 x_incl_awards IN VARCHAR2 DEFAULT NULL,
457 x_incl_award_aim IN VARCHAR2 DEFAULT NULL,
458 x_incl_acad_sessions IN VARCHAR2 DEFAULT NULL,
459 x_incl_st_end_acad_ses IN VARCHAR2 DEFAULT NULL,
460 x_incl_hesa_num IN VARCHAR2 DEFAULT NULL,
461 x_incl_location IN VARCHAR2 DEFAULT NULL,
462 x_incl_program_type IN VARCHAR2 DEFAULT NULL,
463 x_incl_program_name IN VARCHAR2 DEFAULT NULL,
467 x_incl_req_cmplete IN VARCHAR2 DEFAULT NULL,
464 x_incl_prog_atmpt_stat IN VARCHAR2 DEFAULT NULL,
465 x_incl_prog_atmpt_end IN VARCHAR2 DEFAULT NULL,
466 x_incl_prog_atmpt_strt IN VARCHAR2 DEFAULT NULL,
468 x_incl_expected_compl_dt IN VARCHAR2 DEFAULT NULL,
469 x_incl_conferral_dt IN VARCHAR2 DEFAULT NULL,
470 x_incl_thesis_title IN VARCHAR2 DEFAULT NULL,
471 x_incl_program_code IN VARCHAR2 DEFAULT NULL,
472 x_incl_program_ver IN VARCHAR2 DEFAULT NULL,
473 x_incl_stud_no IN VARCHAR2 DEFAULT NULL,
477 x_incl_initials IN VARCHAR2 DEFAULT NULL,
474 x_incl_surname IN VARCHAR2 DEFAULT NULL,
475 x_incl_fore_name IN VARCHAR2 DEFAULT NULL,
476 x_incl_prev_names IN VARCHAR2 DEFAULT NULL,
478 x_doc_purpose_code IN VARCHAR2 DEFAULT NULL,
479 x_plan_id IN NUMBER DEFAULT NULL,
480 x_produced_by IN NUMBER DEFAULT NULL,
481 x_person_id IN NUMBER DEFAULT NULL
482 );
483
484 PROCEDURE delete_row (
485 x_rowid IN VARCHAR2 ,
486 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
487 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
488 X_MSG_COUNT OUT NOCOPY NUMBER
489 );
490
491 FUNCTION get_pk_for_validation (
492 x_item_number IN NUMBER
493 ) RETURN BOOLEAN;
494
495 PROCEDURE get_fk_igs_as_doc_dlvy_typ (
496 x_delivery_method_type IN VARCHAR2
497 );
498
499 PROCEDURE get_fk_igs_ca_inst (
500 x_cal_type IN VARCHAR2,
501 x_sequence_number IN NUMBER
502 );
503
504 PROCEDURE get_fk_igs_as_order_hdr (
505 x_order_number IN NUMBER
506 );
507
508 PROCEDURE before_dml (
509 p_action IN VARCHAR2,
510 x_rowid IN VARCHAR2 DEFAULT NULL,
511 x_order_number IN NUMBER DEFAULT NULL,
512 x_document_type IN VARCHAR2 DEFAULT NULL,
513 x_document_sub_type IN VARCHAR2 DEFAULT NULL,
514 x_item_number IN NUMBER DEFAULT NULL,
515 x_item_status IN VARCHAR2 DEFAULT NULL,
516 x_date_produced IN DATE DEFAULT NULL,
517 x_incl_curr_course IN VARCHAR2 DEFAULT NULL,
518 x_num_of_copies IN NUMBER DEFAULT NULL,
519 x_comments IN VARCHAR2 DEFAULT NULL,
520 x_recip_pers_name IN VARCHAR2 DEFAULT NULL,
521 x_recip_inst_name IN VARCHAR2 DEFAULT NULL,
522 x_recip_addr_line_1 IN VARCHAR2 DEFAULT NULL,
523 x_recip_addr_line_2 IN VARCHAR2 DEFAULT NULL,
524 x_recip_addr_line_3 IN VARCHAR2 DEFAULT NULL,
525 x_recip_addr_line_4 IN VARCHAR2 DEFAULT NULL,
526 x_recip_city IN VARCHAR2 DEFAULT NULL,
527 x_recip_postal_code IN VARCHAR2 DEFAULT NULL,
528 x_recip_state IN VARCHAR2 DEFAULT NULL,
529 x_recip_province IN VARCHAR2 DEFAULT NULL,
530 x_recip_county IN VARCHAR2 DEFAULT NULL,
531 x_recip_country IN VARCHAR2 DEFAULT NULL,
532 x_recip_fax_area_code IN VARCHAR2 DEFAULT NULL,
533 x_recip_fax_country_code IN VARCHAR2 DEFAULT NULL,
534 x_recip_fax_number IN VARCHAR2 DEFAULT NULL,
535 x_delivery_method_type IN VARCHAR2 DEFAULT NULL,
536 x_programs_on_file IN VARCHAR2 DEFAULT NULL,
537 x_missing_acad_record_data_ind IN VARCHAR2 DEFAULT NULL,
538 x_missing_academic_record_data IN VARCHAR2 DEFAULT NULL,
539 x_send_transcript_immediately IN VARCHAR2 DEFAULT NULL,
540 x_hold_release_of_final_grades IN VARCHAR2 DEFAULT NULL,
541 x_fgrade_cal_type IN VARCHAR2 DEFAULT NULL,
542 x_fgrade_seq_num IN NUMBER DEFAULT NULL,
543 x_hold_degree_expected IN VARCHAR2 DEFAULT NULL,
544 x_deghold_cal_type IN VARCHAR2 DEFAULT NULL,
545 x_deghold_seq_num IN NUMBER DEFAULT NULL,
546 x_hold_for_grade_chg IN VARCHAR2 DEFAULT NULL,
547 x_special_instr IN VARCHAR2 DEFAULT NULL,
548 x_express_mail_type IN VARCHAR2 DEFAULT NULL,
549 x_express_mail_track_num IN VARCHAR2 DEFAULT NULL,
550 x_ge_certification IN VARCHAR2 DEFAULT NULL,
551 x_external_comments IN VARCHAR2 DEFAULT NULL,
552 x_internal_comments IN VARCHAR2 DEFAULT NULL,
553 x_dup_requested IN VARCHAR2 DEFAULT NULL,
554 x_dup_req_date IN DATE DEFAULT NULL,
555 x_dup_sent_date IN DATE DEFAULT NULL,
556 x_enr_term_cal_type IN VARCHAR2 DEFAULT NULL,
557 x_enr_ci_sequence_number IN NUMBER DEFAULT NULL,
558 x_incl_attempted_hours IN VARCHAR2 DEFAULT NULL,
559 x_incl_class_rank IN VARCHAR2 DEFAULT NULL,
560 x_incl_progresssion_status IN VARCHAR2 DEFAULT NULL,
561 x_incl_class_standing IN VARCHAR2 DEFAULT NULL,
562 x_incl_cum_hours_earned IN VARCHAR2 DEFAULT NULL,
563 x_incl_gpa IN VARCHAR2 DEFAULT NULL,
564 x_incl_date_of_graduation IN VARCHAR2 DEFAULT NULL,
565 x_incl_degree_dates IN VARCHAR2 DEFAULT NULL,
566 x_incl_degree_earned IN VARCHAR2 DEFAULT NULL,
567 x_incl_date_of_entry IN VARCHAR2 DEFAULT NULL,
568 x_incl_drop_withdrawal_dates IN VARCHAR2 DEFAULT NULL,
569 x_incl_hrs_for_curr_term IN VARCHAR2 DEFAULT NULL,
570 x_incl_majors IN VARCHAR2 DEFAULT NULL,
574 x_incl_instruction_dates IN VARCHAR2 DEFAULT NULL,
571 x_incl_last_date_of_enrollment IN VARCHAR2 DEFAULT NULL,
572 x_incl_professional_licensure IN VARCHAR2 DEFAULT NULL,
573 x_incl_college_affiliation IN VARCHAR2 DEFAULT NULL,
575 x_incl_usec_dates IN VARCHAR2 DEFAULT NULL,
576 x_incl_program_attempt IN VARCHAR2 DEFAULT NULL,
577 x_incl_attendence_type IN VARCHAR2 DEFAULT NULL,
578 x_incl_last_term_enrolled IN VARCHAR2 DEFAULT NULL,
579 x_incl_ssn IN VARCHAR2 DEFAULT NULL,
580 x_incl_date_of_birth IN VARCHAR2 DEFAULT NULL,
581 x_incl_disciplin_standing IN VARCHAR2 DEFAULT NULL,
582 x_incl_no_future_term IN VARCHAR2 DEFAULT NULL,
583 x_incl_acurat_till_copmp_dt IN VARCHAR2 DEFAULT NULL,
584 x_incl_cant_rel_without_sign IN VARCHAR2 DEFAULT NULL,
585 x_creation_date IN DATE DEFAULT NULL,
586 x_created_by IN NUMBER DEFAULT NULL,
587 x_last_update_date IN DATE DEFAULT NULL,
588 x_last_updated_by IN NUMBER DEFAULT NULL,
589 x_last_update_login IN NUMBER DEFAULT NULL,
590 X_DOC_FEE_PER_COPY IN NUMBER DEFAULT NULL,
591 X_DELIVERY_FEE IN NUMBER DEFAULT NULL,
592 X_RECIP_EMAIL IN VARCHAR2 DEFAULT NULL,
593 x_overridden_doc_delivery_fee IN NUMBER DEFAULT NULL,
594 x_overridden_document_fee IN NUMBER DEFAULT NULL,
595 x_fee_overridden_by IN NUMBER DEFAULT NULL,
596 x_fee_overridden_date IN DATE DEFAULT NULL,
597 x_incl_department IN VARCHAR2 DEFAULT NULL,
598 x_incl_field_of_stdy IN VARCHAR2 DEFAULT NULL,
599 x_incl_attend_mode IN VARCHAR2 DEFAULT NULL,
600 x_incl_yop_acad_prd IN VARCHAR2 DEFAULT NULL,
601 x_incl_intrmsn_st_end IN VARCHAR2 DEFAULT NULL,
602 x_incl_hnrs_lvl IN VARCHAR2 DEFAULT NULL,
603 x_incl_awards IN VARCHAR2 DEFAULT NULL,
604 x_incl_award_aim IN VARCHAR2 DEFAULT NULL,
605 x_incl_acad_sessions IN VARCHAR2 DEFAULT NULL,
606 x_incl_st_end_acad_ses IN VARCHAR2 DEFAULT NULL,
607 x_incl_hesa_num IN VARCHAR2 DEFAULT NULL,
608 x_incl_location IN VARCHAR2 DEFAULT NULL,
609 x_incl_program_type IN VARCHAR2 DEFAULT NULL,
610 x_incl_program_name IN VARCHAR2 DEFAULT NULL,
611 x_incl_prog_atmpt_stat IN VARCHAR2 DEFAULT NULL,
612 x_incl_prog_atmpt_end IN VARCHAR2 DEFAULT NULL,
613 x_incl_prog_atmpt_strt IN VARCHAR2 DEFAULT NULL,
614 x_incl_req_cmplete IN VARCHAR2 DEFAULT NULL,
615 x_incl_expected_compl_dt IN VARCHAR2 DEFAULT NULL,
616 x_incl_conferral_dt IN VARCHAR2 DEFAULT NULL,
617 x_incl_thesis_title IN VARCHAR2 DEFAULT NULL,
618 x_incl_program_code IN VARCHAR2 DEFAULT NULL,
619 x_incl_program_ver IN VARCHAR2 DEFAULT NULL,
620 x_incl_stud_no IN VARCHAR2 DEFAULT NULL,
621 x_incl_surname IN VARCHAR2 DEFAULT NULL,
622 x_incl_fore_name IN VARCHAR2 DEFAULT NULL,
623 x_incl_prev_names IN VARCHAR2 DEFAULT NULL,
624 x_incl_initials IN VARCHAR2 DEFAULT NULL,
625 x_doc_purpose_code IN VARCHAR2 DEFAULT NULL,
626 x_plan_id IN NUMBER DEFAULT NULL,
627 x_produced_by IN NUMBER DEFAULT NULL,
628 x_person_id IN NUMBER DEFAULT NULL
629 );
630
631 END Igs_As_Doc_Details_Pkg;