51: -- Check if another adm_appl_status record exists with the system
52: -- default indicator set to 'Y'
53: DECLARE
54: v_count_rec NUMBER;
55: v_sys_def_ind IGS_AD_APPL_STAT.system_default_ind%TYPE;
56: cst_yes CONSTANT CHAR := 'Y';
57: CURSOR c_count(cp_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE,
58: cp_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE)IS
59: SELECT count(*),
53: DECLARE
54: v_count_rec NUMBER;
55: v_sys_def_ind IGS_AD_APPL_STAT.system_default_ind%TYPE;
56: cst_yes CONSTANT CHAR := 'Y';
57: CURSOR c_count(cp_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE,
58: cp_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE)IS
59: SELECT count(*),
60: system_default_ind
61: FROM IGS_AD_APPL_STAT aas
54: v_count_rec NUMBER;
55: v_sys_def_ind IGS_AD_APPL_STAT.system_default_ind%TYPE;
56: cst_yes CONSTANT CHAR := 'Y';
57: CURSOR c_count(cp_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE,
58: cp_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE)IS
59: SELECT count(*),
60: system_default_ind
61: FROM IGS_AD_APPL_STAT aas
62: WHERE aas.adm_appl_status <> cp_adm_appl_status AND
57: CURSOR c_count(cp_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE,
58: cp_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE)IS
59: SELECT count(*),
60: system_default_ind
61: FROM IGS_AD_APPL_STAT aas
62: WHERE aas.adm_appl_status <> cp_adm_appl_status AND
63: aas.s_adm_appl_status = cp_s_adm_appl_status AND
64: aas.system_default_ind = cst_yes
65: GROUP BY system_default_ind;