[Home] [Help]
146: --------------------------------------------------------------------------------
147: smaddali 26-mar-2002 UCCR002(bug#2278817) replaced direct DML with TBH calls,
148: replaced text being written into LOG file with Message names
149: smaddali 02-apr-2002 Modified the source field for social class from starh_social_class to
150: starh_socio_economic field of table igs_uc_app_stats for UCCR002 bug#2278817
151: Also changed the name of table igs_uc_attendance_history to igs_uc_attend_hist
152: and package name igs_uc_attendance_history to igs_uc_attend_hist.
153: Changed tbh calls of igs_uc_app_stats_pkg and igs_uc_applicants to add new columns
154: smaddali 15-jul-02 Modified cursors to get mapped values for domicile,social_class,institution,occupation for bug 2497509
149: smaddali 02-apr-2002 Modified the source field for social class from starh_social_class to
150: starh_socio_economic field of table igs_uc_app_stats for UCCR002 bug#2278817
151: Also changed the name of table igs_uc_attendance_history to igs_uc_attend_hist
152: and package name igs_uc_attendance_history to igs_uc_attend_hist.
153: Changed tbh calls of igs_uc_app_stats_pkg and igs_uc_applicants to add new columns
154: smaddali 15-jul-02 Modified cursors to get mapped values for domicile,social_class,institution,occupation for bug 2497509
155: smaddali 18-jul-02 Added cursor c_person and passing person_number instead of person_id to log messages,bug2497516
156: bayadav 06-Nov-2002 Added Columns as part of UCFD102 Build. Bug NO: 2643048
157: pmarada 26-dec-02 Bug 2726132, i)Removed the igs_he_st_spa_all_pkg.update_row.
158: ii)creating record in igs_uc_attend_hist if the record not exist else updating.
159: ayedubat 31-DEC-2002 Fixed all the issues as mentioned in the bug, 2727487
160: rbezawad 19-Sep-2003 Modified the process w.r.t. UCFD210 Build, Bug 2893542 to populate the Previous education details into
161: OSS Academic History and obsolete the functionality related to IGS_UC_ATTEND_HIST.
162: rgangara 30-Jan-2004 Modified cur_all_applicants cursor to check for Sent_to_hesa flag from IGS_UC_APP_STATS instead of
163: IGS_UC_APPLICANTS. The Sent_to_hesa is for all practical purposes obsolete. Also removed update of
164: Applicant's.Sent_to_hesa as it is no more required as part of bug 3405245
165: arvsrini 27-Jul-2004 Added code to shift the exporting ethnic code logic from IGSUC44B.pls to the current process.
166: Included logic to export ethnic details in case of the same person having multiple information coming from
185: app.country_birth,
186: stat.starh_pocc,
187: stat.starh_socio_economic,
188: stat.starh_pocc_edu_chg_dt
189: FROM igs_uc_applicants app, igs_uc_app_stats stat
190: WHERE app.app_no = stat.app_no
191: AND oss_person_id = NVL(cp_person_id, oss_person_id)
192: AND stat.sent_to_hesa = 'N'
193: ORDER BY app.system_code, app.app_no ;
197: SELECT system_code
198: FROM igs_uc_defaults
199: WHERE prev_inst_left_date IS NULL
200: AND system_code IN ( SELECT DISTINCT app.system_code
201: FROM igs_uc_applicants app, igs_uc_app_stats stat
202: WHERE app.app_no = stat.app_no
203: AND oss_person_id = NVL(cp_person_id, oss_person_id)
204: AND stat.sent_to_hesa = 'N' );
205:
245: SELECT app.ROWID , app.*
246: FROM igs_uc_applicants app
247: WHERE app.app_id = p_app_id ;
248:
249: CURSOR cur_upd_uc_app_stats ( p_app_id IGS_UC_APP_STATS.app_id%TYPE) IS
250: SELECT apst.ROWID , apst.*
251: FROM igs_uc_app_stats apst
252: WHERE apst.app_id = p_app_id ;
253:
247: WHERE app.app_id = p_app_id ;
248:
249: CURSOR cur_upd_uc_app_stats ( p_app_id IGS_UC_APP_STATS.app_id%TYPE) IS
250: SELECT apst.ROWID , apst.*
251: FROM igs_uc_app_stats apst
252: WHERE apst.app_id = p_app_id ;
253:
254: CURSOR cur_ad_appl_inst (p_per_id igs_pe_person.person_id%TYPE) IS
255: SELECT admission_appl_number,
284:
285: -- to fetch the system code in the order U,S,N,G in case there are multiple ethnic data
286: CURSOR cur_sys_ethnic(cp_person_id igs_pe_person.person_id%TYPE ) IS
287: SELECT app.system_code,app.app_no
288: FROM igs_uc_applicants app, igs_uc_app_stats stat
289: WHERE app.app_no = stat.app_no
290: AND oss_person_id = cp_person_id
291: ORDER BY app.system_code DESC;
292:
306: l_col_spa_null VARCHAR2(1) := 'Y';
307: l_dom_cd igs_he_ad_dtl_all.domicile_cd%TYPE;
308: l_occ_code igs_he_ad_dtl_all.occupation_cd%TYPE;
309: l_soc_code igs_he_ad_dtl_all.social_class_cd%TYPE;
310: l_starh_pocc_edu_chg_dt igs_uc_app_stats.starh_pocc_edu_chg_dt%TYPE;
311:
312: l_oss_religion_cd igs_ad_stat_int.religion_cd%TYPE;
313: l_oss_ethnic_origin igs_ad_stat_int.ethnic_origin%TYPE;
314: l_ethnic_cd igs_uc_app_stats.starh_ethnic%TYPE;
310: l_starh_pocc_edu_chg_dt igs_uc_app_stats.starh_pocc_edu_chg_dt%TYPE;
311:
312: l_oss_religion_cd igs_ad_stat_int.religion_cd%TYPE;
313: l_oss_ethnic_origin igs_ad_stat_int.ethnic_origin%TYPE;
314: l_ethnic_cd igs_uc_app_stats.starh_ethnic%TYPE;
315: l_max_sys_ethnic cur_sys_ethnic%ROWTYPE;
316:
317: had_rec get_had_details%ROWTYPE;
318: hestspa_rec get_st_spa_details%ROWTYPE;
331:
332: igs_uc_he_not_enabled_excep EXCEPTION;
333:
334: -- anwest 17-FEB-2006 Bug#5034713
335: l_ucas_code igs_uc_app_stats.starh_pocc%TYPE;
336:
337: BEGIN
338:
339: --anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
749:
750: IF l_error_occurred = 'N' THEN
751:
752: FOR j IN cur_upd_uc_app_stats(all_appl_rec.app_id) LOOP
753: igs_uc_app_stats_pkg.update_row(
754: X_ROWID => j.ROWID ,
755: X_APP_STAT_ID => j.app_stat_id ,
756: X_APP_ID => j.app_id ,
757: X_APP_NO => j.app_no ,