1 PACKAGE IGS_AD_GEN_011 AS
2 /* $Header: IGSAD11S.pls 120.2 2005/09/21 00:38:55 appldev ship $ */
3
4 Procedure Admp_Ins_Acai_Hist(
5 p_person_id IN NUMBER ,
6 p_admission_appl_number IN NUMBER ,
7 p_nominated_course_cd IN VARCHAR2 ,
8 p_sequence_number IN NUMBER ,
9 p_new_adm_cal_type IN VARCHAR2 ,
10 p_old_adm_cal_type IN VARCHAR2 ,
11 p_new_adm_ci_sequence_number IN NUMBER ,
12 p_old_adm_ci_sequence_number IN NUMBER ,
13 p_new_course_cd IN VARCHAR2 ,
14 p_old_course_cd IN VARCHAR2 ,
15 p_new_crv_version_number IN NUMBER ,
16 p_old_crv_version_number IN NUMBER ,
17 p_new_location_cd IN VARCHAR2 ,
18 p_old_location_cd IN VARCHAR2 ,
19 p_new_attendance_mode IN VARCHAR2 ,
20 p_old_attendance_mode IN VARCHAR2 ,
21 p_new_attendance_type IN VARCHAR2 ,
22 p_old_attendance_type IN VARCHAR2 ,
23 p_new_unit_set_cd IN VARCHAR2 ,
24 p_old_unit_set_cd IN VARCHAR2 ,
25 p_new_us_version_number IN NUMBER ,
26 p_old_us_version_number IN NUMBER ,
27 p_new_preference_number IN NUMBER ,
28 p_old_preference_number IN NUMBER ,
29 p_new_adm_doc_status IN VARCHAR2 ,
30 p_old_adm_doc_status IN VARCHAR2 ,
31 p_new_adm_entry_qual_status IN VARCHAR2 ,
32 p_old_adm_entry_qual_status IN VARCHAR2 ,
33 p_new_late_adm_fee_status IN VARCHAR2 ,
34 p_old_late_adm_fee_status IN VARCHAR2 ,
35 p_new_adm_outcome_status IN VARCHAR2 ,
36 p_old_adm_outcome_status IN VARCHAR2 ,
37 p_new_otcm_sts_auth_prsn_id IN NUMBER ,
38 p_old_otcm_sts_auth_prsn_id IN NUMBER ,
39 p_new_adm_otcm_status_auth_dt IN DATE ,
40 p_old_adm_otcm_status_auth_dt IN DATE ,
41 p_new_adm_otcm_status_reason IN VARCHAR2 ,
42 p_old_adm_otcm_status_reason IN VARCHAR2 ,
43 p_new_offer_dt IN DATE ,
44 p_old_offer_dt IN DATE ,
45 p_new_offer_response_dt IN DATE ,
46 p_old_offer_response_dt IN DATE ,
47 p_new_prpsd_commencement_dt IN DATE ,
48 p_old_prpsd_commencement_dt IN DATE ,
49 p_new_adm_cndtnl_offer_status IN VARCHAR2 ,
50 p_old_adm_cndtnl_offer_status IN VARCHAR2 ,
51 p_new_cndtnl_offer_stsfd_dt IN DATE ,
52 p_old_cndtnl_offer_stsfd_dt IN DATE ,
53 p_new_cndtnl_off_must_be_stsfd IN VARCHAR2 DEFAULT 'N',
54 p_old_cndtnl_off_must_be_stsfd IN VARCHAR2 DEFAULT 'N',
55 p_new_adm_offer_resp_status IN VARCHAR2 ,
56 p_old_adm_offer_resp_status IN VARCHAR2 ,
57 p_new_actual_response_dt IN DATE ,
58 p_old_actual_response_dt IN DATE ,
59 p_new_adm_offer_dfrmnt_status IN VARCHAR2 ,
60 p_old_adm_offer_dfrmnt_status IN VARCHAR2 ,
61 p_new_deferred_adm_cal_type IN VARCHAR2 ,
62 p_old_deferred_adm_cal_type IN VARCHAR2 ,
63 p_new_deferred_adm_ci_seq_num IN NUMBER ,
64 p_old_deferred_adm_ci_seq_num IN NUMBER ,
65 p_new_deferred_tracking_id IN NUMBER ,
66 p_old_deferred_tracking_id IN NUMBER ,
67 p_new_ass_rank IN NUMBER ,
68 p_old_ass_rank IN NUMBER ,
69 p_new_secondary_ass_rank IN NUMBER ,
70 p_old_secondary_ass_rank IN NUMBER ,
71 p_new_intrntnl_acpt_advice_num IN NUMBER ,
72 p_old_intrntnl_acpt_advice_num IN NUMBER ,
73 p_new_ass_tracking_id IN NUMBER ,
74 p_old_ass_tracking_id IN NUMBER ,
75 p_new_fee_cat IN VARCHAR2 ,
76 p_old_fee_cat IN VARCHAR2 ,
77 p_new_hecs_payment_option IN VARCHAR2 ,
78 p_old_hecs_payment_option IN VARCHAR2 ,
79 p_new_expected_completion_yr IN NUMBER ,
80 p_old_expected_completion_yr IN NUMBER ,
81 p_new_expected_completion_perd IN VARCHAR2 ,
82 p_old_expected_completion_perd IN VARCHAR2 ,
83 p_new_correspondence_cat IN VARCHAR2 ,
84 p_old_correspondence_cat IN VARCHAR2 ,
85 p_new_enrolment_cat IN VARCHAR2 ,
86 p_old_enrolment_cat IN VARCHAR2 ,
87 p_new_funding_source IN VARCHAR2 ,
88 p_old_funding_source IN VARCHAR2 ,
89 p_new_update_who IN VARCHAR2 ,
90 p_old_update_who IN VARCHAR2 ,
91 p_new_update_on IN DATE ,
92 p_old_update_on IN DATE ,
93 p_new_applicant_acptnce_cndtn IN VARCHAR2 ,
94 p_old_applicant_acptnce_cndtn IN VARCHAR2 ,
95 p_new_cndtnl_offer_cndtn IN VARCHAR2 ,
96 p_old_cndtnl_offer_cndtn IN VARCHAR2 ,
97 p_new_appl_inst_status IN VARCHAR2 DEFAULT NULL, --arvsrini igsm
98 p_old_appl_inst_status IN VARCHAR2 DEFAULT NULL,
99 P_NEW_DECISION_DATE DATE DEFAULT NULL, -- begin APADEGAL adtd001 igs.m
100 P_OLD_DECISION_DATE DATE DEFAULT NULL,
101 P_NEW_DECISION_MAKE_ID NUMBER DEFAULT NULL,
102 P_OLD_DECISION_MAKE_ID NUMBER DEFAULT NULL,
103 P_NEW_DECISION_REASON_ID NUMBER DEFAULT NULL,
104 P_OLD_DECISION_REASON_ID NUMBER DEFAULT NULL,
105 P_NEW_PENDING_REASON_ID NUMBER DEFAULT NULL,
106 P_OLD_PENDING_REASON_ID NUMBER DEFAULT NULL,
107 P_NEW_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
108 P_OLD_WAITLIST_STATUS VARCHAR2 DEFAULT NULL,
109 P_NEW_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
110 P_OLD_WAITLIST_RANK VARCHAR2 DEFAULT NULL,
111 P_NEW_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
112 P_OLD_FUTURE_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
113 P_NEW_FUTURE_ACAD_CI_SEQ_NUM NUMBER DEFAULT NULL,
114 P_OLD_FUTURE_ACAD_CI_SEQ_NUM NUMBER DEFAULT NULL,
115 P_NEW_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
116 P_OLD_FUTURE_ADM_CAL_TYPE VARCHAR2 DEFAULT NULL,
117 P_NEW_FUTURE_ADM_CI_SEQ_NUM NUMBER DEFAULT NULL,
118 P_OLD_FUTURE_ADM_CI_SEQ_NUM NUMBER DEFAULT NULL,
119 P_NEW_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
120 P_OLD_DEF_ACAD_CAL_TYPE VARCHAR2 DEFAULT NULL,
121 P_NEW_DEF_ACAD_CI_SEQ_NUM NUMBER DEFAULT NULL,
122 P_OLD_DEF_ACAD_CI_SEQ_NUM NUMBER DEFAULT NULL,
123 P_NEW_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL,
124 P_OLD_DECLINE_OFR_REASON VARCHAR2 DEFAULT NULL -- end APADEGAL adtd001 igs.m
125
126 );
127
128 Procedure Admp_Ins_Aca_Hist(
129 p_person_id IN NUMBER ,
130 p_admission_appl_number IN NUMBER ,
131 p_nominated_course_cd IN VARCHAR2 ,
132 p_new_transfer_course_cd IN VARCHAR2 ,
133 p_old_transfer_course_cd IN VARCHAR2 ,
134 p_new_basis_for_admission_type IN VARCHAR2 ,
135 p_old_basis_for_admission_type IN VARCHAR2 ,
136 p_new_admission_cd IN VARCHAR2 ,
137 p_old_admission_cd IN VARCHAR2 ,
138 p_new_course_rank_set IN VARCHAR2 ,
139 p_old_course_rank_set IN VARCHAR2 ,
140 p_new_course_rank_schedule IN VARCHAR2 ,
141 p_old_course_rank_schedule IN VARCHAR2 ,
142 p_new_req_for_reconsider_ind IN VARCHAR2 DEFAULT 'N',
143 p_old_req_for_reconsider_ind IN VARCHAR2 DEFAULT 'N',
144 p_new_req_for_adv_standing_ind IN VARCHAR2 DEFAULT 'N',
145 p_old_req_for_adv_standing_ind IN VARCHAR2 DEFAULT 'N',
146 p_new_update_who IN VARCHAR2 ,
147 p_old_update_who IN VARCHAR2 ,
148 p_new_update_on IN DATE ,
149 p_old_update_on IN DATE );
150 --
151 Function Admp_Ins_Adm_Letter (
152 p_acad_cal_type IN VARCHAR2,
153 p_acad_ci_sequence_number IN NUMBER,
154 p_adm_cal_type IN VARCHAR2,
155 p_adm_ci_sequence_number IN NUMBER,
156 p_admission_cat IN VARCHAR2,
157 p_s_admission_process_type IN VARCHAR2,
158 p_correspondence_type IN VARCHAR2,
159 p_person_id IN NUMBER,
160 p_admission_appl_number IN NUMBER,
161 p_adm_outcome_status IN VARCHAR2,
162 p_message_name OUT NOCOPY VARCHAR2,
163 p_reference_number OUT NOCOPY NUMBER,
164 p_pgmofstudy IN VARCHAR2,
165 p_response_stat IN VARCHAR2,
166 p_resd_class IN VARCHAR2,
167 p_resd_stat IN VARCHAR2,
168 p_persid_grp IN NUMBER,
169 p_org_unit IN VARCHAR2,
170 p_sortby IN VARCHAR2
171 ) RETURN BOOLEAN;
172 --
173 PROCEDURE Adms_Ins_Adm_Letter (
174 errbuf OUT NOCOPY VARCHAR2,
175 retcode OUT NOCOPY NUMBER,
176 p_acad_perd IN VARCHAR2,
177 p_adm_perd IN VARCHAR2,
178 p_adm_cat IN VARCHAR2,
179 p_s_adm_prcss_type IN VARCHAR2,
180 p_correspondence_type IN VARCHAR2,
181 p_adm_outcome_stat IN VARCHAR2,
182 p_org_id IN NUMBER,
183 p_pgmofstudy IN VARCHAR2,
184 p_response_stat IN VARCHAR2,
185 p_resd_class IN VARCHAR2,
186 p_resd_stat IN VARCHAR2,
187 p_persid_grp IN NUMBER,
188 p_org_unit IN VARCHAR2,
189 p_sortby IN VARCHAR2
190 );
191
192 -- Removed Function for IGR migration (bug 4114493) sjlaport
193
194 Function Admp_Ins_Phrase_Splp(
195 p_person_id IN NUMBER ,
196 p_admission_appl_number IN NUMBER ,
197 p_correspondence_type IN VARCHAR2 ,
198 p_aal_sequence_number IN NUMBER ,
199 p_letter_parameter_type IN VARCHAR2 ,
200 p_letter_reference_number IN NUMBER ,
201 p_spl_sequence_number IN NUMBER ,
202 p_letter_repeating_group_cd IN VARCHAR2 ,
203 p_splrg_sequence_number IN NUMBER,
204 p_letter_order_number IN NUMBER)
205 RETURN BOOLEAN;
206
207 END IGS_AD_GEN_011;