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_CNDNL_OFRSTAT

Line 218: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;

214: DECLARE
215: v_message_name VARCHAR2(30);
216: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;
217: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
218: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
219: BEGIN
220: -- Set the default message number
221: p_message_name := NULL;
222: -- Perform item level validations.

Line 377: IGS_AD_CNDNL_OFRSTAT.s_adm_cndtnl_offer_status%TYPE := 'SATISFIED';

373: cst_withdrawn CONSTANT
374: IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'WITHDRAWN';
375: cst_voided CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'VOIDED';
376: cst_satisfied CONSTANT
377: IGS_AD_CNDNL_OFRSTAT.s_adm_cndtnl_offer_status%TYPE := 'SATISFIED';
378: BEGIN
379: p_message_name := NULL;
380: -- Only validate the admission documentation status if
381: -- it has a system value other then not-applicable.

Line 739: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE ;

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
742: -- Set the default message number
743: p_message_name := NULL;

Line 1603: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_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;
1606: BEGIN
1607: -- Perform the following validations when the module has been called

Line 2972: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;

2968: BEGIN --admp_val_acai_acos
2969: --Validate the IGS_AD_PS_APPL_INST.adm_cndtnl_offer_status
2970: DECLARE
2971: v_message_name VARCHAR2(30);
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;

Line 2973: v_old_s_adm_cndtnl_offer_stat igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;

2969: --Validate the IGS_AD_PS_APPL_INST.adm_cndtnl_offer_status
2970: DECLARE
2971: v_message_name VARCHAR2(30);
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

Line 3037: --The IGS_AD_CNDNL_OFRSTAT must be open. (ACOS01)

3033: p_message_name OUT NOCOPY VARCHAR2 )
3034: RETURN BOOLEAN AS
3035: BEGIN --admp_val_acos_item
3036: --Validate the IGS_AD_PS_APPL_INST.adm_cndtnl_offer_status.
3037: --The IGS_AD_CNDNL_OFRSTAT must be open. (ACOS01)
3038: --The conditional offer status must be not-applicable when conditional
3039: --offers are not allowed. (ACOS02)
3040: --If fees are required for the application, then fees must not be outstanding
3041: --for the conditional offer to be satisfied. (ACOS08)

Line 3045: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;

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;
3049: --validate the closed indicator

Line 3090: -- Validate if IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status is closed.

3086: IGS_GE_MSG_STACK.ADD;
3087: App_Exception.Raise_Exception;
3088: END admp_val_acos_item;
3089: --
3090: -- Validate if IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status is closed.
3091: FUNCTION admp_val_acos_closed(
3092: p_adm_cndtnl_offer_status IN VARCHAR2 ,
3093: p_message_name OUT NOCOPY VARCHAR2 )
3094: RETURN BOOLEAN AS

Line 3096: -- Validate the IGS_AD_CNDNL_OFRSTAT closed indicator

3092: p_adm_cndtnl_offer_status IN VARCHAR2 ,
3093: p_message_name OUT NOCOPY VARCHAR2 )
3094: RETURN BOOLEAN AS
3095: BEGIN -- admp_val_acos_closed
3096: -- Validate the IGS_AD_CNDNL_OFRSTAT closed indicator
3097: DECLARE
3098: CURSOR c_acos(
3099: cp_adm_cndtnl_offer_status
3100: IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE) IS

Line 3100: IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE) IS

3096: -- Validate the IGS_AD_CNDNL_OFRSTAT closed indicator
3097: DECLARE
3098: CURSOR c_acos(
3099: cp_adm_cndtnl_offer_status
3100: IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE) IS
3101: SELECT closed_ind
3102: FROM IGS_AD_CNDNL_OFRSTAT
3103: WHERE adm_cndtnl_offer_status =cp_adm_cndtnl_offer_status;
3104: v_acos_rec c_acos%ROWTYPE;

Line 3102: FROM IGS_AD_CNDNL_OFRSTAT

3098: CURSOR c_acos(
3099: cp_adm_cndtnl_offer_status
3100: IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE) IS
3101: SELECT closed_ind
3102: FROM IGS_AD_CNDNL_OFRSTAT
3103: WHERE adm_cndtnl_offer_status =cp_adm_cndtnl_offer_status;
3104: v_acos_rec c_acos%ROWTYPE;
3105: cst_yes CONSTANT CHAR := 'Y';
3106: BEGIN