1 PACKAGE IGS_AD_PRC_TAC_OFFER AUTHID CURRENT_USER AS
2 /* $Header: IGSAD15S.pls 115.8 2002/11/28 21:25:48 nsidana ship $ */
3
4 /******************************************************************
5 Created By:
6 Date Created By:
7 Purpose:
8 Known limitations,enhancements,remarks:
9 Change History
10 Who When What
11 vchappid 29-Aug-2001 Added new parameters into function calls, Enh Bug#1964478
12 knag 21-Nov-2002 Added new parameters to admp_ins_adm_appl for bug 2664410
13 ******************************************************************/
14
15
16 --
17 -- Get the admission category for this course offering option
18 FUNCTION admp_get_ac_cooac(
19 p_coo_id IN NUMBER ,
20 p_admission_cat IN OUT NOCOPY VARCHAR2 ,
21 p_message_name OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN;
23 --
24 -- Insert an Australian secondary education record
25 FUNCTION admp_ins_aus_scn_edu(
26 p_person_id IN NUMBER ,
27 p_result_obtained_yr IN NUMBER ,
28 p_score IN NUMBER ,
29 p_state_cd IN VARCHAR2 ,
30 p_candidate_number IN NUMBER ,
31 p_aus_scndry_edu_ass_type IN VARCHAR2 ,
32 p_secondary_school_cd IN VARCHAR2 ,
33 p_ase_sequence_number OUT NOCOPY NUMBER ,
34 p_message_name OUT NOCOPY VARCHAR2 )
35 RETURN BOOLEAN;
36 --
37 -- Insert an Australian secondary education subject record
38 FUNCTION admp_ins_aus_scn_sub(
39 p_person_id IN NUMBER ,
40 p_ase_sequence_number IN NUMBER ,
41 p_subject_result_yr IN NUMBER ,
42 p_subject_cd IN VARCHAR2 ,
43 p_subject_desc IN VARCHAR2 ,
44 p_subject_mark IN VARCHAR2 ,
45 p_subject_mark_level IN VARCHAR2 ,
46 p_subject_weighting IN VARCHAR2 ,
47 p_subject_ass_type IN VARCHAR2 ,
48 p_notes IN VARCHAR2 ,
49 p_message_name OUT NOCOPY VARCHAR2 )
50 RETURN BOOLEAN;
51
52 --
53 -- Retrieves the admission code and basis for admission type
54
55 --
56 -- Finds the user defined tertiary edu level of completion.
57 FUNCTION ADMP_GET_LVL_COMP(
58 p_tac_level_of_comp IN VARCHAR2 )
59 RETURN VARCHAR2;
60
61 --
62 -- Inserts an admission application record
63 FUNCTION admp_ins_adm_appl(
64 p_person_id IN NUMBER ,
65 p_appl_dt IN DATE ,
66 p_acad_cal_type IN VARCHAR2 ,
67 p_acad_ci_sequence_number IN NUMBER ,
68 p_adm_cal_type IN VARCHAR2 ,
69 p_adm_ci_sequence_number IN NUMBER ,
70 p_admission_cat IN VARCHAR2 ,
71 p_s_admission_process_type IN VARCHAR2 ,
72 p_adm_appl_status IN VARCHAR2 ,
73 p_adm_fee_status IN OUT NOCOPY VARCHAR2 ,
74 p_tac_appl_ind IN VARCHAR2 DEFAULT 'N',
75 p_adm_appl_number OUT NOCOPY NUMBER ,
76 p_message_name OUT NOCOPY VARCHAR2,
77 p_spcl_grp_1 IN NUMBER DEFAULT NULL, --Bug#1964478, Parameter added
78 p_spcl_grp_2 IN NUMBER DEFAULT NULL, --Bug#1964478, Parameter added
79 p_common_app IN VARCHAR2 DEFAULT NULL, --Bug#1964478, Parameter added
80 p_application_type IN VARCHAR2 DEFAULT NULL,
81 p_choice_number IN VARCHAR2 DEFAULT NULL,
82 p_routeb_pref IN VARCHAR2 DEFAULT NULL,
83 p_alt_appl_id IN VARCHAR2 DEFAULT NULL -- Added for Bug 2664410
84 )
85 RETURN BOOLEAN;
86
87 --
88 -- Inserts TAC details to form an admission course application instance
89 FUNCTION admp_ins_tac_acai(
90 p_person_id IN NUMBER ,
91 p_admission_appl_number IN NUMBER ,
92 p_acad_cal_type IN VARCHAR2 ,
93 p_acad_ci_sequence_number IN NUMBER ,
94 p_adm_cal_type IN VARCHAR2 ,
95 p_adm_ci_sequence_number IN NUMBER ,
96 p_admission_cat IN VARCHAR2 ,
97 p_appl_dt IN DATE ,
98 p_adm_fee_status IN VARCHAR2 ,
99 p_preference_number IN NUMBER ,
100 p_offer_dt IN DATE ,
101 p_offer_response_dt IN DATE ,
102 p_course_cd IN VARCHAR2 ,
103 p_crv_version_number IN NUMBER ,
104 p_location_cd IN VARCHAR2 ,
105 p_attendance_mode IN VARCHAR2 ,
106 p_attendance_type IN VARCHAR2 ,
107 p_unit_set_cd IN VARCHAR2 ,
108 p_us_version_number IN NUMBER ,
109 p_fee_cat IN VARCHAR2 ,
110 p_hecs_payment_option IN VARCHAR2 ,
111 p_correspondence_cat IN VARCHAR2 ,
112 p_enrolment_cat IN VARCHAR2 ,
113 p_insert_outcome_ind IN VARCHAR2 DEFAULT 'N',
114 p_pre_enrol_ind IN VARCHAR2 DEFAULT 'N',
115 p_return_type OUT NOCOPY VARCHAR2 ,
116 p_message_name OUT NOCOPY VARCHAR2 )
117 RETURN BOOLEAN;
118
119 --
120 -- Inserts TAC details to form an admission course
121 FUNCTION admp_ins_tac_course(
122 p_acad_cal_type IN VARCHAR2 ,
123 p_acad_ci_sequence_number IN NUMBER ,
124 p_adm_cal_type IN VARCHAR2 ,
125 p_adm_ci_sequence_number IN NUMBER ,
126 p_admission_cat IN VARCHAR2 ,
127 p_fee_cat IN VARCHAR2 ,
128 p_enrolment_cat IN VARCHAR2 ,
129 p_correspondence_cat IN VARCHAR2 ,
130 p_person_id IN NUMBER ,
131 p_tac_course_cd IN VARCHAR2 ,
132 p_preference_number IN NUMBER ,
133 p_appl_dt IN DATE ,
134 p_offer_dt IN DATE ,
135 p_basis_for_admission_type IN VARCHAR2 ,
136 p_admission_cd IN VARCHAR2 ,
137 p_fee_paying_appl_ind IN VARCHAR2 ,
138 p_hecs_payment_option IN VARCHAR2 ,
139 p_insert_outcome_letter_ind IN VARCHAR2 DEFAULT 'N',
140 p_pre_enrol_ind IN VARCHAR2 DEFAULT 'N',
141 p_course_cd OUT NOCOPY VARCHAR2 ,
142 p_tac_course_match_ind OUT NOCOPY VARCHAR2 ,
143 p_return_type OUT NOCOPY VARCHAR2 ,
144 p_message_name OUT NOCOPY VARCHAR2 )
145 RETURN BOOLEAN;
146
147 --
148 -- Insert a tertiary education record
149 FUNCTION admp_ins_tert_edu(
150 p_person_id IN NUMBER ,
151 p_exclusion_ind IN VARCHAR2 DEFAULT 'N',
152 p_tertiary_edu_lvl_comp IN VARCHAR2 ,
153 p_enrolment_first_yr IN NUMBER ,
154 p_institution_cd IN VARCHAR2 ,
155 p_enrolment_latest_yr IN NUMBER ,
156 p_grade_point_average IN NUMBER ,
157 p_language_of_tuition IN VARCHAR2 ,
158 p_qualification IN VARCHAR2 ,
159 p_institution_name IN VARCHAR2 ,
160 p_equiv_full_time_yrs_enr IN NUMBER ,
161 p_student_id IN VARCHAR2 ,
162 p_course_cd IN VARCHAR2 ,
163 p_course_title IN VARCHAR2 ,
164 p_state_cd IN VARCHAR2 ,
165 p_level_of_achievement_type IN VARCHAR2 ,
166 p_field_of_study IN VARCHAR2 ,
167 p_language_component IN VARCHAR2 ,
168 p_country_cd IN VARCHAR2 ,
169 p_tertiary_edu_lvl_qual IN VARCHAR2 ,
170 p_honours_level IN VARCHAR2 ,
171 p_notes IN VARCHAR2 ,
172 p_message_name OUT NOCOPY VARCHAR2 ,
173 p_inserted_ind OUT NOCOPY VARCHAR2 )
174 RETURN BOOLEAN;
175
176 --
177 -- inserts a new record into the IGS_PE_ALT_PERS_ID table
178 PROCEDURE admp_ins_alt_prsn_id(
179 p_alt_person_id IN VARCHAR2 ,
180 p_alt_person_id_type IN VARCHAR2 ,
181 p_person_id IN NUMBER ,
182 p_start_dt IN DATE ,
183 p_end_dt IN DATE )
184 ;
185 --
186 -- Inserts a IGS_PE_PERSON and alternate IGS_PE_PERSON ID record with data from TAC
187 FUNCTION admp_ins_tac_prsn(
188 p_person_id IN NUMBER ,
189 p_tac_person_id IN VARCHAR2 ,
190 p_surname IN VARCHAR2 ,
191 p_given_names IN VARCHAR2 ,
192 p_sex IN VARCHAR2 ,
193 p_birth_dt IN DATE ,
194 p_alt_person_id_type IN VARCHAR2 ,
195 p_new_person_id OUT NOCOPY NUMBER ,
196 p_message_out OUT NOCOPY VARCHAR2 )
197 RETURN BOOLEAN;
198 --
199 -- Insert a new IGS_PE_PERSON address record and end date the previous record
200 FUNCTION admp_ins_person_addr(
201 p_person_id IN NUMBER ,
202 p_addr_type IN VARCHAR2 ,
203 p_start_dt IN DATE ,
204 p_addr_line_1 IN VARCHAR2 ,
205 p_addr_line_2 VARCHAR2 ,
206 p_addr_line_3 IN VARCHAR2 ,
207 p_addr_line_4 IN VARCHAR2 ,
208 p_aust_postcode IN NUMBER ,
209 p_os_code IN VARCHAR2 ,
210 p_phone_1 IN VARCHAR2 ,
211 p_phone_2 IN VARCHAR2 ,
212 p_message_name OUT NOCOPY VARCHAR2 )
213 RETURN BOOLEAN;
214
215 --
216 -- Insert a admission course application record
217 FUNCTION admp_ins_adm_crs_app(
218 p_person_id IN NUMBER ,
219 p_adm_appl_number IN NUMBER ,
220 p_nominated_course_cd IN VARCHAR2 ,
221 p_basis_for_admission_type IN VARCHAR2 ,
222 p_admission_cd IN VARCHAR2 ,
223 p_req_for_reconsideration_ind IN VARCHAR2 DEFAULT 'N',
224 p_req_for_adv_standing_ind IN VARCHAR2 DEFAULT 'N',
225 p_message_name OUT NOCOPY VARCHAR2 )
226 RETURN BOOLEAN;
227
228 END IGS_AD_PRC_TAC_OFFER;