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_ALL

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 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