APPS.IGS_AD_GEN_002 dependencies on IGS_AD_APPL_ALL

Line 2974: FROM igs_ad_appl_all

2970: Who When What
2971: *******************************************************************************/
2972: CURSOR c_application_id IS
2973: SELECT application_id
2974: FROM igs_ad_appl_all
2975: WHERE person_id = p_person_id
2976: AND admission_appl_number = p_admission_appl_number;
2977: l_application_id igs_ad_appl_all.application_id%TYPE;
2978: BEGIN

Line 2977: l_application_id igs_ad_appl_all.application_id%TYPE;

2973: SELECT application_id
2974: FROM igs_ad_appl_all
2975: WHERE person_id = p_person_id
2976: AND admission_appl_number = p_admission_appl_number;
2977: l_application_id igs_ad_appl_all.application_id%TYPE;
2978: BEGIN
2979: IF p_person_id IS NOT NULL AND
2980: p_admission_appl_number IS NOT NULL THEN
2981: FOR c_application_id_rec IN c_application_id

Line 3002: l_FeeAmt igs_ad_appl_all.appl_fee_amt%TYPE :=0;

2998: Known limitations/enhancements and/or remarks:
2999: Change History: (who, when, what: )
3000: Who When What
3001: *******************************************************************************/
3002: l_FeeAmt igs_ad_appl_all.appl_fee_amt%TYPE :=0;
3003: l_TotalRemitt igs_ad_app_req.fee_amount%TYPE :=0;
3004: l_WaivedTemp igs_ad_app_req.fee_amount%TYPE :=0;
3005: lOverallStatus igs_lookup_values.meaning%TYPE;
3006: CURSOR c_adm_fee_amt IS

Line 3008: FROM igs_ad_appl_all

3004: l_WaivedTemp igs_ad_app_req.fee_amount%TYPE :=0;
3005: lOverallStatus igs_lookup_values.meaning%TYPE;
3006: CURSOR c_adm_fee_amt IS
3007: SELECT appl_fee_amt
3008: FROM igs_ad_appl_all
3009: WHERE person_id = p_person_id
3010: AND admission_appl_number = p_admission_appl_number;
3011: CURSOR c_appl_fee_status_meaning (p_sys_fee_status igs_ad_code_classes.class%TYPE) IS
3012: SELECT meaning

Line 3287: CURSOR c_igs_ad_appl_all (cp_application_id igs_ad_appl_all.application_id%TYPE) IS

3283: *******************************************************************************/
3284: BEGIN
3285: DECLARE
3286: l_fee_exists VARCHAR2(1);
3287: CURSOR c_igs_ad_appl_all (cp_application_id igs_ad_appl_all.application_id%TYPE) IS
3288: SELECT person_id, admission_appl_number, appl_fee_amt
3289: FROM igs_ad_appl_all
3290: WHERE application_id = cp_application_id;
3291: rec_igs_ad_appl_all c_igs_ad_appl_all%ROWTYPE;

Line 3289: FROM igs_ad_appl_all

3285: DECLARE
3286: l_fee_exists VARCHAR2(1);
3287: CURSOR c_igs_ad_appl_all (cp_application_id igs_ad_appl_all.application_id%TYPE) IS
3288: SELECT person_id, admission_appl_number, appl_fee_amt
3289: FROM igs_ad_appl_all
3290: WHERE application_id = cp_application_id;
3291: rec_igs_ad_appl_all c_igs_ad_appl_all%ROWTYPE;
3292: CURSOR c_igs_ad_app_req (cp_person_id igs_ad_app_req.person_id%TYPE,
3293: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS

Line 3291: rec_igs_ad_appl_all c_igs_ad_appl_all%ROWTYPE;

3287: CURSOR c_igs_ad_appl_all (cp_application_id igs_ad_appl_all.application_id%TYPE) IS
3288: SELECT person_id, admission_appl_number, appl_fee_amt
3289: FROM igs_ad_appl_all
3290: WHERE application_id = cp_application_id;
3291: rec_igs_ad_appl_all c_igs_ad_appl_all%ROWTYPE;
3292: CURSOR c_igs_ad_app_req (cp_person_id igs_ad_app_req.person_id%TYPE,
3293: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
3294: SELECT 'X'
3295: FROM igs_ad_app_req

Line 3302: OPEN c_igs_ad_appl_all(p_application_id);

3298: BEGIN
3299: IF p_application_id IS NULL THEN
3300: RETURN NULL;
3301: ELSE
3302: OPEN c_igs_ad_appl_all(p_application_id);
3303: FETCH c_igs_ad_appl_all INTO rec_igs_ad_appl_all;
3304: CLOSE c_igs_ad_appl_all;
3305: IF (rec_igs_ad_appl_all.appl_fee_amt is NULL OR
3306: rec_igs_ad_appl_all.appl_fee_amt = 0) THEN

Line 3303: FETCH c_igs_ad_appl_all INTO rec_igs_ad_appl_all;

3299: IF p_application_id IS NULL THEN
3300: RETURN NULL;
3301: ELSE
3302: OPEN c_igs_ad_appl_all(p_application_id);
3303: FETCH c_igs_ad_appl_all INTO rec_igs_ad_appl_all;
3304: CLOSE c_igs_ad_appl_all;
3305: IF (rec_igs_ad_appl_all.appl_fee_amt is NULL OR
3306: rec_igs_ad_appl_all.appl_fee_amt = 0) THEN
3307: RETURN 'NOFEEDUE';

Line 3304: CLOSE c_igs_ad_appl_all;

3300: RETURN NULL;
3301: ELSE
3302: OPEN c_igs_ad_appl_all(p_application_id);
3303: FETCH c_igs_ad_appl_all INTO rec_igs_ad_appl_all;
3304: CLOSE c_igs_ad_appl_all;
3305: IF (rec_igs_ad_appl_all.appl_fee_amt is NULL OR
3306: rec_igs_ad_appl_all.appl_fee_amt = 0) THEN
3307: RETURN 'NOFEEDUE';
3308: ELSE

Line 3305: IF (rec_igs_ad_appl_all.appl_fee_amt is NULL OR

3301: ELSE
3302: OPEN c_igs_ad_appl_all(p_application_id);
3303: FETCH c_igs_ad_appl_all INTO rec_igs_ad_appl_all;
3304: CLOSE c_igs_ad_appl_all;
3305: IF (rec_igs_ad_appl_all.appl_fee_amt is NULL OR
3306: rec_igs_ad_appl_all.appl_fee_amt = 0) THEN
3307: RETURN 'NOFEEDUE';
3308: ELSE
3309: OPEN c_igs_ad_app_req(rec_igs_ad_appl_all.person_id, rec_igs_ad_appl_all.admission_appl_number);

Line 3306: rec_igs_ad_appl_all.appl_fee_amt = 0) THEN

3302: OPEN c_igs_ad_appl_all(p_application_id);
3303: FETCH c_igs_ad_appl_all INTO rec_igs_ad_appl_all;
3304: CLOSE c_igs_ad_appl_all;
3305: IF (rec_igs_ad_appl_all.appl_fee_amt is NULL OR
3306: rec_igs_ad_appl_all.appl_fee_amt = 0) THEN
3307: RETURN 'NOFEEDUE';
3308: ELSE
3309: OPEN c_igs_ad_app_req(rec_igs_ad_appl_all.person_id, rec_igs_ad_appl_all.admission_appl_number);
3310: FETCH c_igs_ad_app_req INTO l_fee_exists;

Line 3309: OPEN c_igs_ad_app_req(rec_igs_ad_appl_all.person_id, rec_igs_ad_appl_all.admission_appl_number);

3305: IF (rec_igs_ad_appl_all.appl_fee_amt is NULL OR
3306: rec_igs_ad_appl_all.appl_fee_amt = 0) THEN
3307: RETURN 'NOFEEDUE';
3308: ELSE
3309: OPEN c_igs_ad_app_req(rec_igs_ad_appl_all.person_id, rec_igs_ad_appl_all.admission_appl_number);
3310: FETCH c_igs_ad_app_req INTO l_fee_exists;
3311: CLOSE c_igs_ad_app_req;
3312: IF l_fee_exists is NULL THEN
3313: RETURN 'PENDING';