eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_AD_FEE_STAT

Line 737: v_s_late_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;

733: RETURN BOOLEAN AS
734: BEGIN -- admp_val_acai_lafs
735: -- Validate the IGS_AD_PS_APPL_INST.late_adm_fee_status.
736: DECLARE
737: v_s_late_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
738: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
739: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE ;
740: v_message_name VARCHAR2(30);
741: BEGIN

Line 814: v_s_late_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;

810: -- * If late applications are not allowed the late_adm_fee_status
811: -- must have a system value of not-applicable. (LAFS02)
812: DECLARE
813: v_message_name VARCHAR2(30);
814: v_s_late_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
815: BEGIN
816: -- Set the default message number
817: p_message_name := NULL;
818: -- Validate the closed indicator

Line 847: -- Validate if IGS_AD_FEE_STAT.adm_fee_status is closed.

843: IGS_GE_MSG_STACK.ADD;
844: App_Exception.Raise_Exception;
845: END admp_val_lafs_item;
846: --
847: -- Validate if IGS_AD_FEE_STAT.adm_fee_status is closed.
848: FUNCTION admp_val_afs_closed(
849: p_adm_fee_status IN VARCHAR2 ,
850: p_message_name OUT NOCOPY VARCHAR2 )
851: RETURN BOOLEAN AS

Line 853: -- Validate if IGS_AD_FEE_STAT.adm_fee_status is closed

849: p_adm_fee_status IN VARCHAR2 ,
850: p_message_name OUT NOCOPY VARCHAR2 )
851: RETURN BOOLEAN AS
852: BEGIN -- admp_val_afs_closed
853: -- Validate if IGS_AD_FEE_STAT.adm_fee_status is closed
854: DECLARE
855: CURSOR c_afs IS
856: SELECT closed_ind
857: FROM IGS_AD_FEE_STAT

Line 857: FROM IGS_AD_FEE_STAT

853: -- Validate if IGS_AD_FEE_STAT.adm_fee_status is closed
854: DECLARE
855: CURSOR c_afs IS
856: SELECT closed_ind
857: FROM IGS_AD_FEE_STAT
858: WHERE adm_fee_status = p_adm_fee_status;
859: v_closed_ind IGS_AD_FEE_STAT.closed_ind%TYPE;
860: BEGIN
861: -- Set the default message number

Line 859: v_closed_ind IGS_AD_FEE_STAT.closed_ind%TYPE;

855: CURSOR c_afs IS
856: SELECT closed_ind
857: FROM IGS_AD_FEE_STAT
858: WHERE adm_fee_status = p_adm_fee_status;
859: v_closed_ind IGS_AD_FEE_STAT.closed_ind%TYPE;
860: BEGIN
861: -- Set the default message number
862: p_message_name := NULL;
863: -- Cursor handling

Line 1600: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;

1596: v_message_name VARCHAR2(30);
1597: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1598: v_old_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1599: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;
1600: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1601: v_late_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1602: v_s_adm_entry_qual_status igs_ad_ent_qf_stat.s_adm_entry_qual_status%TYPE;
1603: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
1604: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;

Line 1601: v_late_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;

1597: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1598: v_old_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1599: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;
1600: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1601: v_late_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1602: v_s_adm_entry_qual_status igs_ad_ent_qf_stat.s_adm_entry_qual_status%TYPE;
1603: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
1604: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
1605: v_old_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;

Line 1820: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;

1816: cst_unconfirmed CONSTANT VARCHAR2(11) := 'UNCONFIRM';
1817: cst_offer_future_term CONSTANT VARCHAR2(20) := 'OFFER-FUTURE-TERM';
1818: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1819: v_old_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1820: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1821: v_message_name VARCHAR2(30);
1822: v_dummy VARCHAR2(1);
1823: CURSOR c_sca IS
1824: SELECT 'x'

Line 2976: v_late_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;

2972: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
2973: v_old_s_adm_cndtnl_offer_stat igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
2974: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
2975: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;
2976: v_late_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
2977: BEGIN
2978: --set the default message number
2979: p_message_name := NULL;
2980: --Perform item level validations.

Line 3044: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;

3040: --If fees are required for the application, then fees must not be outstanding
3041: --for the conditional offer to be satisfied. (ACOS08)
3042: DECLARE
3043: v_message_name VARCHAR2(30);
3044: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
3045: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
3046: BEGIN
3047: --set the default message number
3048: p_message_name := NULL;