APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_APPL_STAT

Line 64: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

60: cst_completed CONSTANT VARCHAR2(9) := 'COMPLETED';
61: cst_withdrawn CONSTANT VARCHAR2(9) := 'WITHDRAWN';
62: cst_warn CONSTANT VARCHAR2(1) := 'W';
63: cst_error CONSTANT VARCHAR2(1) := 'E';
64: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
65: v_message_name VARCHAR2(30);
66: v_return BOOLEAN := TRUE;
67: CURSOR c_acaiv (
68: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

Line 204: IGS_AD_APPL_STAT aas

200: cp_person_id IGS_AD_APPL.person_id%TYPE,
201: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE) IS
202: SELECT aas.s_adm_appl_status
203: FROM IGS_AD_APPL aa,
204: IGS_AD_APPL_STAT aas
205: WHERE aa.person_id = cp_person_id AND
206: aa.admission_appl_number = cp_admission_appl_number AND
207: aas.adm_appl_status = aa.adm_appl_status;
208: BEGIN

Line 363: v_s_appl_inst_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

359: RETURN BOOLEAN AS
360: BEGIN --admp_val_acai_update
361: --This module validates update of an IGS_AD_PS_APPL_INST record.
362: DECLARE
363: v_s_appl_inst_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
364: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
365: cst_withdrawn CONSTANT VARCHAR2(10) := 'WITHDRAWN';
366: CURSOR c_sca (
367: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

Line 469: IGS_AD_APPL_STAT aas

465: admission_appl_number = p_admission_appl_number;
466: CURSOR c_aas IS
467: SELECT 'x'
468: FROM IGS_AD_APPL aa,
469: IGS_AD_APPL_STAT aas
470: WHERE aa.person_id = p_person_id AND
471: aa.admission_appl_number = p_admission_appl_number AND
472: aas.adm_appl_status = aa.adm_appl_status AND
473: aas.s_adm_appl_status = 'WITHDRAWN';