APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_PS_APLINSTUNT

Line 4764: -- Validate the deferment of IGS_AD_PS_APLINSTUNT records.

4760: IGS_GE_MSG_STACK.ADD;
4761: APP_EXCEPTION.RAISE_EXCEPTION;
4762: END admp_val_pe_comp;
4763: --
4764: -- Validate the deferment of IGS_AD_PS_APLINSTUNT records.
4765: FUNCTION admp_val_acaiu_defer(
4766: p_person_id IN NUMBER ,
4767: p_admission_appl_number IN NUMBER ,
4768: p_nominated_course_cd IN VARCHAR2 ,

Line 4778: -- Validate the deferment of IGS_AD_PS_APLINSTUNT records

4774: p_s_admission_process_type IN VARCHAR2 ,
4775: p_message_name OUT NOCOPY VARCHAR2 )
4776: RETURN BOOLEAN AS
4777: BEGIN -- admp_val_acaiu_defer
4778: -- Validate the deferment of IGS_AD_PS_APLINSTUNT records
4779: DECLARE
4780: cst_offer CONSTANT
4781: IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
4782: v_message_name VARCHAR2(30);

Line 4791: FROM IGS_AD_PS_APLINSTUNT acaiu,

4787: acaiu.ci_sequence_number,
4788: acaiu.location_cd,
4789: acaiu.unit_class,
4790: acaiu.unit_mode
4791: FROM IGS_AD_PS_APLINSTUNT acaiu,
4792: IGS_AD_UNIT_OU_STAT auos
4793: WHERE acaiu.person_id = p_person_id AND
4794: acaiu.admission_appl_number = p_admission_appl_number AND
4795: acaiu.nominated_course_cd = p_nominated_course_cd AND