APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_GEN_007

Line 314: IF(NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(

310: p_unit_set_cd,
311: p_us_version_number,
312: p_adm_cal_type,
313: p_adm_ci_sequence_number) LOOP
314: IF(NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(
315: v_acaiv_aa_rec.adm_appl_status),'NULL')
316: NOT IN (cst_completed, cst_withdrawn)) THEN
317: p_message_name := 'IGS_AD_ADMPRG_MATCH_PRG';
318: p_return_type := cst_warn;

Line 403: v_s_appl_inst_status := NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(

399: FETCH c_ais INTO v_s_appl_inst_status;
400: CLOSE c_ais;
401:
402: IF v_s_appl_inst_status IS NOT NULL THEN
403: v_s_appl_inst_status := NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(
404: v_s_appl_inst_status), 'NULL');
405: END IF;
406:
407: IF v_s_appl_inst_status = cst_withdrawn THEN

Line 2225: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS (

2221: BEGIN
2222: p_message_name := NULL;
2223: -- Validate conditional offer satisfied date against the admission conditional
2224: -- offer status.
2225: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS (
2226: p_adm_cndtnl_offer_status);
2227: -- Conditional offer satisfied date must be set when the conditional offer has
2228: -- been
2229: -- satisfied or waived.

Line 2280: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS (

2276: p_message_name := NULL;
2277: -- Validate the conditional offer condition against the admission
2278: -- conditional offer status.
2279: IF p_cndtnl_offer_cndtn IS NOT NULL THEN
2280: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS (
2281: p_adm_cndtnl_offer_status);
2282: -- The conditional offer condition may only be specified when an
2283: -- conditional offer has been made.
2284: IF v_s_adm_cndtnl_offer_status = cst_not_applic THEN

Line 2364: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS(

2360: -- Set up the default return value.
2361: p_message_name := NULL;
2362:
2363: IF p_cndtnl_off_must_be_stsfd_ind = 'Y' THEN
2364: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS(
2365: p_adm_cndtnl_offer_status);
2366: IF v_s_adm_cndtnl_offer_status = cst_not_applic THEN
2367: -- The conditional offer must be satisfied indicator cannot be set when
2368: -- the conditional offer status is not applicable.

Line 4556: IGS_AD_GEN_007.ADMP_GET_PE_EXISTS(

4552: p_check_os_sec_ed = TRUE OR
4553: p_check_employment = TRUE OR
4554: p_check_membership = TRUE OR
4555: p_check_excurr = TRUE) THEN
4556: IGS_AD_GEN_007.ADMP_GET_PE_EXISTS(
4557: p_person_id,
4558: p_effective_dt,
4559: p_check_athletics,
4560: p_check_alternate,