APPS.IGS_AD_VAL_AA dependencies on IGS_AD_APPL_STAT

Line 13: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

9: RETURN BOOLEAN AS
10: BEGIN -- admp_val_aa_delete
11: -- Validate delete of an IGS_AD_APPL record.
12: DECLARE
13: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
14: BEGIN
15: -- Set the default message number
16: p_message_name := null;
17: -- Get the system admission application status.

Line 181: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

177: RETURN BOOLEAN AS
178: BEGIN -- admp_val_aa_update
179: -- Validate update of an IGS_AD_APPL record.
180: DECLARE
181: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
182: BEGIN
183: -- Set the default message number
184: p_message_name := null;
185: -- Get the system admission application status.

Line 587: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

583: cst_rejected CONSTANT VARCHAR2(10) := 'REJECTED';
584: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
585: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
586: v_message_name VARCHAR2(30);
587: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
588: v_derived_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
589: v_exit_loop BOOLEAN DEFAULT FALSE;
590: BEGIN
591: -- Set the default message number

Line 588: v_derived_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

584: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
585: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
586: v_message_name VARCHAR2(30);
587: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
588: v_derived_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
589: v_exit_loop BOOLEAN DEFAULT FALSE;
590: BEGIN
591: -- Set the default message number
592: p_message_name := null;

Line 666: -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed.

662: IGS_GE_MSG_STACK.ADD;
663: App_Exception.Raise_Exception;
664: END admp_val_aa_aas;
665: --
666: -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed.
667: FUNCTION admp_val_aas_closed(
668: p_adm_appl_status IN VARCHAR2 ,
669: p_message_name OUT NOCOPY VARCHAR2 )
670: RETURN BOOLEAN AS

Line 672: -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed

668: p_adm_appl_status IN VARCHAR2 ,
669: p_message_name OUT NOCOPY VARCHAR2 )
670: RETURN BOOLEAN AS
671: BEGIN -- admp_val_aas_closed
672: -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed
673: DECLARE
674: CURSOR c_aas IS
675: SELECT closed_ind
676: FROM IGS_AD_APPL_STAT

Line 676: FROM IGS_AD_APPL_STAT

672: -- Validate if IGS_AD_APPL_STAT.adm_appl_status is closed
673: DECLARE
674: CURSOR c_aas IS
675: SELECT closed_ind
676: FROM IGS_AD_APPL_STAT
677: WHERE adm_appl_status = p_adm_appl_status;
678: v_closed_ind IGS_AD_APPL_STAT.closed_ind%TYPE;
679: BEGIN
680: -- Set the default message number

Line 678: v_closed_ind IGS_AD_APPL_STAT.closed_ind%TYPE;

674: CURSOR c_aas IS
675: SELECT closed_ind
676: FROM IGS_AD_APPL_STAT
677: WHERE adm_appl_status = p_adm_appl_status;
678: v_closed_ind IGS_AD_APPL_STAT.closed_ind%TYPE;
679: BEGIN
680: -- Set the default message number
681: p_message_name := null;
682: -- Cursor handling