APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_HE_AD_DTL_ALL

Line 235: FROM igs_he_ad_dtl_all had

231: AND map1 = cp_map1 ;
232:
233: CURSOR get_had_details (l_per_id igs_pe_person.person_id%TYPE) IS
234: SELECT had.ROWID ,had.*
235: FROM igs_he_ad_dtl_all had
236: WHERE person_id = l_per_id;
237:
238: CURSOR get_st_spa_details( l_per_id igs_pe_person.person_id%TYPE) IS
239: SELECT course_cd, version_number

Line 263: FROM igs_he_ad_dtl_all

259: WHERE person_id = p_per_id;
260:
261: CURSOR cur_he_ad_dtl_all(p_per_id igs_pe_person.person_id%TYPE) IS
262: SELECT COUNT(*)
263: FROM igs_he_ad_dtl_all
264: WHERE person_id = p_per_id;
265:
266: -- Get the Batch ID for admission application import process
267: CURSOR c_bat_id IS

Line 307: l_dom_cd igs_he_ad_dtl_all.domicile_cd%TYPE;

303: l_interface_stat_id igs_ad_stat_int_all.interface_stat_id%TYPE;
304: l_chk_per_present VARCHAR2(1) := 'Y';
305: l_col_ad_null VARCHAR2(1) := 'Y';
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:

Line 308: l_occ_code igs_he_ad_dtl_all.occupation_cd%TYPE;

304: l_chk_per_present VARCHAR2(1) := 'Y';
305: l_col_ad_null VARCHAR2(1) := 'Y';
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;

Line 309: l_soc_code igs_he_ad_dtl_all.social_class_cd%TYPE;

305: l_col_ad_null VARCHAR2(1) := 'Y';
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;

Line 556: -- check if there is a record for the passed person in igs_he_ad_dtl_all ,

552:
553: IF l_mapping_failed = 'N' THEN
554:
555: /* Fetch the fields in the tables for this particular person_id and call the TBH to insert/update the table */
556: -- check if there is a record for the passed person in igs_he_ad_dtl_all ,
557: -- if not then create a new record from the corresponding OSS admission record for the person
558: -- smaddali start replacing the select statement with a cursor
559: l_count :=0 ;
560: OPEN cur_he_ad_dtl_all(all_appl_rec.oss_person_id) ;

Line 568: igs_he_ad_dtl_all_pkg.insert_row(

564: IF l_count = 0 THEN
565:
566: FOR lv_ad_appl_inst IN cur_ad_appl_inst(all_appl_rec.oss_person_id) LOOP
567: l_rowid := NULL ;
568: igs_he_ad_dtl_all_pkg.insert_row(
569: x_rowid => l_rowid,
570: x_org_id => NULL,
571: x_hesa_ad_dtl_id => l_count,
572: x_person_id => all_appl_rec.oss_person_id,

Line 587: igs_he_ad_dtl_all_pkg.update_row (

583:
584: ELSE
585:
586: FOR had_rec IN get_had_details(all_appl_rec.oss_person_id) LOOP
587: igs_he_ad_dtl_all_pkg.update_row (
588: x_mode => 'R',
589: x_rowid => had_rec.ROWID,
590: x_org_id => had_rec.org_id,
591: x_hesa_ad_dtl_id => had_rec.hesa_ad_dtl_id,