APPS.IGS_AD_VAL_ACA dependencies on IGS_AD_CD

Line 383: -- Validate if IGS_AD_CD.admission_cd is closed.

379: IGS_GE_MSG_STACK.ADD;
380: App_Exception.Raise_Exception;
381: END admp_val_aca_trnsfr;
382: --
383: -- Validate if IGS_AD_CD.admission_cd is closed.
384: FUNCTION admp_val_aco_closed(
385: p_admission_cd IN VARCHAR2 ,
386: p_message_name OUT NOCOPY VARCHAR2 )
387: RETURN BOOLEAN IS

Line 392: cp_admission_cd IGS_AD_CD.admission_cd%TYPE) IS

388: BEGIN -- admp_val_aco_closed
389: -- Validate the admission_cd closed indicator
390: DECLARE
391: CURSOR c_aco(
392: cp_admission_cd IGS_AD_CD.admission_cd%TYPE) IS
393: SELECT closed_ind
394: FROM IGS_AD_CD
395: WHERE admission_cd = cp_admission_cd;
396: v_aco_rec c_aco%ROWTYPE;

Line 394: FROM IGS_AD_CD

390: DECLARE
391: CURSOR c_aco(
392: cp_admission_cd IGS_AD_CD.admission_cd%TYPE) IS
393: SELECT closed_ind
394: FROM IGS_AD_CD
395: WHERE admission_cd = cp_admission_cd;
396: v_aco_rec c_aco%ROWTYPE;
397: cst_yes CONSTANT CHAR := 'Y';
398: BEGIN