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_AD_VAL_AOS dependencies on IGS_AD_OU_STAT

Line 14: -- Check if another IGS_AD_OU_STAT record exists with the system

10: p_s_adm_outcome_status IN VARCHAR2 ,
11: p_message_name OUT NOCOPY VARCHAR2 )
12: RETURN BOOLEAN AS
13: BEGIN -- ADMP_VAL_AOS_DFLT
14: -- Check if another IGS_AD_OU_STAT record exists with the system
15: -- default indicator set to 'Y'
16: DECLARE
17: v_count_rec NUMBER;
18: v_sys_def_ind IGS_AD_OU_STAT.system_default_ind%TYPE;

Line 18: v_sys_def_ind IGS_AD_OU_STAT.system_default_ind%TYPE;

14: -- Check if another IGS_AD_OU_STAT record exists with the system
15: -- default indicator set to 'Y'
16: DECLARE
17: v_count_rec NUMBER;
18: v_sys_def_ind IGS_AD_OU_STAT.system_default_ind%TYPE;
19: CURSOR c_count IS
20: SELECT count(*),
21: system_default_ind
22: FROM IGS_AD_OU_STAT aos

Line 22: FROM IGS_AD_OU_STAT aos

18: v_sys_def_ind IGS_AD_OU_STAT.system_default_ind%TYPE;
19: CURSOR c_count IS
20: SELECT count(*),
21: system_default_ind
22: FROM IGS_AD_OU_STAT aos
23: WHERE aos.adm_outcome_status <> p_adm_outcome_status AND
24: aos.s_adm_outcome_status = p_s_adm_outcome_status AND
25: aos.system_default_ind = 'Y'
26: GROUP BY system_default_ind;