[Home] [Help]
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.
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
167: different systems Bug#3796641
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:
240: FROM igs_he_st_spa_all hestspa
241: WHERE person_id = l_per_id;
242:
243: --smaddali start ,new cursors created to remove direct DML from code
244: CURSOR cur_upd_uc_appl ( p_app_id IGS_UC_APPLICANTS.app_id%TYPE) IS
245: SELECT app.ROWID , app.*
246: FROM igs_uc_applicants app
247: WHERE app.app_id = p_app_id ;
248:
242:
243: --smaddali start ,new cursors created to remove direct DML from code
244: CURSOR cur_upd_uc_appl ( p_app_id IGS_UC_APPLICANTS.app_id%TYPE) IS
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.*
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:
499:
500: -- to process only one record in case multiple records are present for the same person
501: IF all_appl_rec.system_code = l_max_sys_ethnic.system_code THEN
502:
503: -- Get the country description for the IGS_UC_APPLICANTS.COUNTRY_BIRTH column,
504: -- and populate IGS_AD_STAT_INT interface table
505: -- Also get the ethnic and religion code mappings from mapping table and populate it
506: -- into populate IGS_AD_STAT_INT interface table as per bug 3094405
507: l_app_stat_rec := NULL;