eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_AD_STAT_INT

Line 296: FROM igs_ad_stat_int_all a

292:
293: -- Get the Applicant Statistics interface records whose import has failed
294: CURSOR c_stat_int (cp_interface_id igs_ad_acadhis_int_all.interface_id%TYPE) IS
295: SELECT a.*
296: FROM igs_ad_stat_int_all a
297: WHERE a.interface_id = cp_interface_id
298: AND a.status = '3';
299: l_interface_stat_rec c_stat_int%ROWTYPE ;
300:

Line 303: l_interface_stat_id igs_ad_stat_int_all.interface_stat_id%TYPE;

299: l_interface_stat_rec c_stat_int%ROWTYPE ;
300:
301: l_imp_batch_id igs_ad_interface_all.batch_id%TYPE ;
302: l_interface_id igs_ad_interface_all.interface_id%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;

Line 312: l_oss_religion_cd igs_ad_stat_int.religion_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;
315: l_max_sys_ethnic cur_sys_ethnic%ROWTYPE;
316:

Line 313: l_oss_ethnic_origin igs_ad_stat_int.ethnic_origin%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;
315: l_max_sys_ethnic cur_sys_ethnic%ROWTYPE;
316:
317: had_rec get_had_details%ROWTYPE;

Line 504: -- and populate IGS_AD_STAT_INT interface table

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;
508: OPEN cur_upd_uc_app_stats (all_appl_rec.app_id);

Line 506: -- into populate IGS_AD_STAT_INT interface table as per bug 3094405

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;
508: OPEN cur_upd_uc_app_stats (all_appl_rec.app_id);
509: FETCH cur_upd_uc_app_stats INTO l_app_stat_rec;
510: CLOSE cur_upd_uc_app_stats;

Line 711: INSERT INTO igs_ad_stat_int_all (

707: END IF;
708:
709: l_interface_stat_id := NULL;
710:
711: INSERT INTO igs_ad_stat_int_all (
712: interface_stat_id
713: ,interface_id
714: ,ethnic_origin
715: ,religion_cd

Line 723: IGS_AD_STAT_INT_S.NEXTVAL,

719: ,last_updated_by
720: ,last_update_date
721: ,last_update_login )
722: VALUES(
723: IGS_AD_STAT_INT_S.NEXTVAL,
724: l_interface_id,
725: l_oss_ethnic_origin,
726: l_oss_religion_cd,
727: '2',