DBA Data[Home] [Help]

APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_AD_GEN_002

Line 550: igs_ad_gen_002.admp_get_aa_dtl(

546:
547:
548: -- Get admission application details required for validation.
549: --
550: igs_ad_gen_002.admp_get_aa_dtl(
551: new_references.person_id,
552: new_references.admission_appl_number,
553: v_admission_cat,
554: v_s_admission_process_type,

Line 729: IF NOT (igs_ad_gen_002.check_any_offer_inst(new_references.person_id, --arvsrini igsm

725: IGS_GE_MSG_STACK.ADD;
726: APP_EXCEPTION.RAISE_EXCEPTION;
727: END IF;
728: ELSE
729: IF NOT (igs_ad_gen_002.check_any_offer_inst(new_references.person_id, --arvsrini igsm
730: new_references.admission_appl_number, --either instance is withdrawn
731: new_references.nominated_course_cd, --or instance is complete and is not offered/cond offered
732: new_references.sequence_number) --or instance is complete but deffered appl is already created
733: AND old_references.def_term_adm_appl_num IS NULL -- hence cant be udpated

Line 1712: IGS_AD_GEN_002.ADMP_GET_AA_DTL(

1708: END IF;
1709: --
1710: -- Get admission application details required for validation.
1711: --
1712: IGS_AD_GEN_002.ADMP_GET_AA_DTL(
1713: old_references.person_id,
1714: old_references.admission_appl_number,
1715: v_admission_cat,
1716: v_s_admission_process_type,

Line 2047: IGS_AD_GEN_002.ADMP_GET_AA_DTL(

2043: IF NVL(p_inserting,FALSE) OR NVL(p_updating,FALSE) THEN
2044: --
2045: -- Get admission application details required for validation.
2046: --
2047: IGS_AD_GEN_002.ADMP_GET_AA_DTL(
2048: new_references.person_id,
2049: new_references.admission_appl_number,
2050: v_admission_cat,
2051: v_s_admission_process_type,

Line 2424: v_derived_adm_appl_status := IGS_AD_GEN_002.ADMP_GET_AA_AAS (

2420: CLOSE c_aa;
2421: v_person_id := old_references.person_id;
2422: v_admission_appl_number := old_references.admission_appl_number;
2423: -- Derive the Admission Application status.
2424: v_derived_adm_appl_status := IGS_AD_GEN_002.ADMP_GET_AA_AAS (
2425: v_person_id,
2426: v_admission_appl_number,
2427: v_adm_appl_status);
2428: -- Update the admission application status.