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_PS_CREATE_GENERIC_PKG dependencies on IGS_AD_ADM_UNIT_STAT

Line 9635: CURSOR cur_amd_unit_stat(cp_administrative_unit_status IN igs_ad_adm_unit_stat.administrative_unit_status%TYPE) IS

9631:
9632: END validate_derivation;
9633:
9634: PROCEDURE validate_db_cons(p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type,p_insert_update IN VARCHAR2) AS
9635: CURSOR cur_amd_unit_stat(cp_administrative_unit_status IN igs_ad_adm_unit_stat.administrative_unit_status%TYPE) IS
9636: SELECT 'X'
9637: FROM igs_ad_adm_unit_stat aus
9638: WHERE aus.administrative_unit_status = cp_administrative_unit_status
9639: AND aus.unit_attempt_status='DISCONTIN'

Line 9637: FROM igs_ad_adm_unit_stat aus

9633:
9634: PROCEDURE validate_db_cons(p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type,p_insert_update IN VARCHAR2) AS
9635: CURSOR cur_amd_unit_stat(cp_administrative_unit_status IN igs_ad_adm_unit_stat.administrative_unit_status%TYPE) IS
9636: SELECT 'X'
9637: FROM igs_ad_adm_unit_stat aus
9638: WHERE aus.administrative_unit_status = cp_administrative_unit_status
9639: AND aus.unit_attempt_status='DISCONTIN'
9640: AND aus.closed_ind ='N';
9641: l_c_var VARCHAR2(1);