1 PACKAGE igs_da_trns_imp AS
2 /* $Header: IGSDA12S.pls 120.0 2005/10/14 10:33:37 appldev noship $ */
3 TYPE trans_cur_rec IS RECORD (
4
5 transcript_id igs_ad_transcript.transcript_id%TYPE,
6 education_id igs_ad_transcript.education_id%TYPE,
7 term_details_id igs_ad_term_details.term_details_id%TYPE,
8 unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE,
9
10 term_type igs_ad_transcript.term_type%TYPE,
11 term igs_ad_term_details.term%TYPE,
12 start_date igs_ad_term_details.start_date%TYPE,
13 end_date igs_ad_term_details.end_date%TYPE,
14 unit igs_ad_term_unitdtls.unit%TYPE,
15 person_id hz_education.party_id%TYPE,
16 unit_name igs_ad_term_unitdtls.unit_name%TYPE,
17 cp_attempted igs_ad_term_unitdtls.cp_attempted%TYPE,
18 cp_earned igs_ad_term_unitdtls.cp_earned%TYPE,
19 grade igs_ad_term_unitdtls.grade%TYPE,
20 unit_grade_points igs_ad_term_unitdtls.unit_grade_points%TYPE,
21 prev_institution_code igs_ad_acad_history_v.institution_code%TYPE
22 );
23
24 -- This function is called to create a new / update an existing academic history record and
25 -- term / unit details corresponding to a source unit.
26
27 PROCEDURE create_acad_hist_rec (
28 p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
29 p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
30 p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
31 p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
32 p_term_type IN VARCHAR2,
33 p_term IN igs_ad_term_details.term%TYPE,
34 p_start_date IN VARCHAR2,
35 p_end_date IN VARCHAR2,
36 p_source_course_subject IN VARCHAR2,
37 p_source_course_num IN VARCHAR2,
38 p_unit_name IN igs_ad_term_unitdtls.unit_name%TYPE,
39 p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
40 p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
41 p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
42 p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
43 p_grade IN igs_ad_term_unitdtls.grade%TYPE,
44 p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
45 p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE
46 );
47
48 -- This function is called to create a new / update an existing advanced standing record
49
50 PROCEDURE create_adv_stnd_unit (
51 p_batch_id IN igs_da_rqst.batch_id%TYPE,
52 p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
53 p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
54 p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
55 p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
56 p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
57 p_avstnd_grade IN igs_av_lgcy_unt_int.grade%TYPE,
58 p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
59 p_target_course_subject IN VARCHAR2,
60 p_target_course_num IN VARCHAR2,
61 p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
62 p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE
63 );
64
65 -- This procedure is called to validate a batch ID or to create a new batch id if
66 -- the incomming transfer evaluation reply is without a request.This procedure also deletes the
67 -- academic history and advanced standing details for the the student.
68
69 PROCEDURE create_or_get_batch_id (
70 p_batch_id IN igs_da_rqst.batch_id%TYPE,
71 p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
72 p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
73 p_program_code IN igs_av_lgcy_unt_int.program_cd%TYPE,
74 transaction_sub_type IN VARCHAR2,
75 p_out_batch_id OUT NOCOPY igs_da_rqst.batch_id%TYPE
76 );
77
78 PROCEDURE delete_adv_stnd_records (p_person_id IN hz_parties.party_id%TYPE);
79 PROCEDURE complete_import_process (p_batch_id IN igs_da_rqst.batch_id%TYPE);
80
81 END igs_da_trns_imp;