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_GEN_002 dependencies on IGS_AD_PS_APPL

Line 2544: FROM --IGS_AD_PS_APPL aca,

2540: acai.adm_offer_dfrmnt_status,
2541: acai.appl_inst_status,
2542: acai.def_term_adm_appl_num,
2543: acai.def_appl_sequence_num
2544: FROM --IGS_AD_PS_APPL aca,
2545: IGS_AD_PS_APPL_INST acai
2546: WHERE acai.person_id = p_person_id AND
2547: acai.admission_appl_number = p_admission_appl_number;
2548: --AND aca.person_id = acai.person_id AND

Line 2545: IGS_AD_PS_APPL_INST acai

2541: acai.appl_inst_status,
2542: acai.def_term_adm_appl_num,
2543: acai.def_appl_sequence_num
2544: FROM --IGS_AD_PS_APPL aca,
2545: IGS_AD_PS_APPL_INST acai
2546: WHERE acai.person_id = p_person_id AND
2547: acai.admission_appl_number = p_admission_appl_number;
2548: --AND aca.person_id = acai.person_id AND
2549: --aca.admission_appl_number = acai.admission_appl_number AND

Line 2571: v_s_appl_inst_stat igs_ad_ps_appl_inst.appl_inst_status%TYPE;

2567: v_withdrawn_appl BOOLEAN DEFAULT FALSE;
2568: v_completed_appl BOOLEAN DEFAULT FALSE;
2569: v_acai_records_found BOOLEAN DEFAULT FALSE;
2570: v_rej_lap BOOLEAN DEFAULT FALSE;
2571: v_s_appl_inst_stat igs_ad_ps_appl_inst.appl_inst_status%TYPE;
2572: v_s_adm_appl_status igs_ad_appl_stat.s_adm_appl_status%TYPE;
2573: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
2574: v_s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE;
2575: -- v_exit_loop NUMBER DEFAULT 0;

Line 2837: cp_adm_cal_type IN IGS_AD_PS_APPL_INST.adm_cal_type%TYPE,

2833: WHERE person_id = p_person_id AND
2834: admission_appl_number = p_admission_appl_number;
2835: CURSOR c_cir (
2836: cp_acad_cal_type IN IGS_AD_APPL.acad_cal_type%TYPE,
2837: cp_adm_cal_type IN IGS_AD_PS_APPL_INST.adm_cal_type%TYPE,
2838: cp_adm_ci_sequence_number IN
2839: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE) IS
2840: SELECT ci.alternate_code, ci.start_dt
2841: FROM IGS_CA_INST_REL cir,

Line 2839: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE) IS

2835: CURSOR c_cir (
2836: cp_acad_cal_type IN IGS_AD_APPL.acad_cal_type%TYPE,
2837: cp_adm_cal_type IN IGS_AD_PS_APPL_INST.adm_cal_type%TYPE,
2838: cp_adm_ci_sequence_number IN
2839: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE) IS
2840: SELECT ci.alternate_code, ci.start_dt
2841: FROM IGS_CA_INST_REL cir,
2842: IGS_CA_INST ci
2843: WHERE cir.sup_cal_type = cp_acad_cal_type AND

Line 2889: -- IGS_AD_PS_APPL_INST.adm_outcome_status was set.

2885: p_acai_sequence_number IN NUMBER )
2886: RETURN DATE IS
2887: BEGIN -- admp_get_acai_aos_dt
2888: -- This module gets the date that the current
2889: -- IGS_AD_PS_APPL_INST.adm_outcome_status was set.
2890: DECLARE
2891: v_decision_date IGS_AD_PS_APPL_INST.decision_date%TYPE;
2892: CURSOR c_acai IS
2893: SELECT acai.decision_date

Line 2891: v_decision_date IGS_AD_PS_APPL_INST.decision_date%TYPE;

2887: BEGIN -- admp_get_acai_aos_dt
2888: -- This module gets the date that the current
2889: -- IGS_AD_PS_APPL_INST.adm_outcome_status was set.
2890: DECLARE
2891: v_decision_date IGS_AD_PS_APPL_INST.decision_date%TYPE;
2892: CURSOR c_acai IS
2893: SELECT acai.decision_date
2894: FROM IGS_AD_PS_APPL_INST acai
2895: WHERE acai.person_id = p_person_id AND

Line 2894: FROM IGS_AD_PS_APPL_INST acai

2890: DECLARE
2891: v_decision_date IGS_AD_PS_APPL_INST.decision_date%TYPE;
2892: CURSOR c_acai IS
2893: SELECT acai.decision_date
2894: FROM IGS_AD_PS_APPL_INST acai
2895: WHERE acai.person_id = p_person_id AND
2896: acai.admission_appl_number = p_admission_appl_number AND
2897: acai.nominated_course_cd = p_nominated_course_cd AND
2898: acai.sequence_number = p_acai_sequence_number AND

Line 3071: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

3067: END IF;
3068: RETURN lOverallStatus;
3069: END Admp_Get_Fee_Status;
3070: PROCEDURE check_adm_appl_inst_stat(
3071: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3072: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3073: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
3074: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
3075: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.

Line 3072: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

3068: RETURN lOverallStatus;
3069: END Admp_Get_Fee_Status;
3070: PROCEDURE check_adm_appl_inst_stat(
3071: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3072: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3073: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
3074: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
3075: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
3076: ) IS

Line 3073: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,

3069: END Admp_Get_Fee_Status;
3070: PROCEDURE check_adm_appl_inst_stat(
3071: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3072: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3073: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
3074: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
3075: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
3076: ) IS
3077: /*******************************************************************************

Line 3074: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,

3070: PROCEDURE check_adm_appl_inst_stat(
3071: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3072: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3073: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
3074: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
3075: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
3076: ) IS
3077: /*******************************************************************************
3078: Created by : Kedarnath Nag

Line 3087: l_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE;

3083: Known limitations/enhancements and/or remarks:
3084: Change History: (who, when, what: )
3085: Who When What
3086: *******************************************************************************/
3087: l_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE;
3088: l_adm_appl_status_old igs_ad_appl.adm_appl_status%TYPE;
3089: l_adm_appl_status_new igs_ad_appl.adm_appl_status%TYPE;
3090: l_appl_inst_status igs_ad_ps_appl_inst.appl_inst_status%TYPE;
3091: cst_withdrawn CONSTANT VARCHAR2(10) := 'WITHDRAWN';

Line 3090: l_appl_inst_status igs_ad_ps_appl_inst.appl_inst_status%TYPE;

3086: *******************************************************************************/
3087: l_adm_outcome_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE;
3088: l_adm_appl_status_old igs_ad_appl.adm_appl_status%TYPE;
3089: l_adm_appl_status_new igs_ad_appl.adm_appl_status%TYPE;
3090: l_appl_inst_status igs_ad_ps_appl_inst.appl_inst_status%TYPE;
3091: cst_withdrawn CONSTANT VARCHAR2(10) := 'WITHDRAWN';
3092: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
3093: cst_cancelled CONSTANT VARCHAR2(10) := 'CANCELLED';
3094: CURSOR c_adm_appl_status (cp_person_id igs_ad_appl.person_id%TYPE,

Line 3100: CURSOR c_adm_outcome_status (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,

3096: SELECT adm_appl_status
3097: FROM igs_ad_appl
3098: WHERE person_id = cp_person_id
3099: AND admission_appl_number = cp_admission_appl_number;
3100: CURSOR c_adm_outcome_status (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
3101: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
3102: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
3103: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
3104: SELECT adm_outcome_status,

Line 3101: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,

3097: FROM igs_ad_appl
3098: WHERE person_id = cp_person_id
3099: AND admission_appl_number = cp_admission_appl_number;
3100: CURSOR c_adm_outcome_status (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
3101: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
3102: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
3103: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
3104: SELECT adm_outcome_status,
3105: appl_inst_status, --arvsrini

Line 3102: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

3098: WHERE person_id = cp_person_id
3099: AND admission_appl_number = cp_admission_appl_number;
3100: CURSOR c_adm_outcome_status (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
3101: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
3102: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
3103: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
3104: SELECT adm_outcome_status,
3105: appl_inst_status, --arvsrini
3106: def_term_adm_appl_num,

Line 3103: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS

3099: AND admission_appl_number = cp_admission_appl_number;
3100: CURSOR c_adm_outcome_status (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
3101: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
3102: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
3103: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
3104: SELECT adm_outcome_status,
3105: appl_inst_status, --arvsrini
3106: def_term_adm_appl_num,
3107: def_appl_sequence_num

Line 3108: FROM igs_ad_ps_appl_inst

3104: SELECT adm_outcome_status,
3105: appl_inst_status, --arvsrini
3106: def_term_adm_appl_num,
3107: def_appl_sequence_num
3108: FROM igs_ad_ps_appl_inst
3109: WHERE person_id = cp_person_id
3110: AND admission_appl_number= cp_admission_appl_number
3111: AND nominated_course_cd = cp_nominated_course_cd
3112: AND sequence_number = cp_sequence_number;

Line 3116: l_def_term_adm_appl_num igs_ad_ps_appl_inst.def_term_adm_appl_num%TYPE DEFAULT NULL;

3112: AND sequence_number = cp_sequence_number;
3113:
3114: l_offer_inst VARCHAR2(1) DEFAULT 'N';
3115: l_is_inst_complete BOOLEAN DEFAULT FALSE ;
3116: l_def_term_adm_appl_num igs_ad_ps_appl_inst.def_term_adm_appl_num%TYPE DEFAULT NULL;
3117: l_def_appl_sequence_num igs_ad_ps_appl_inst.def_term_adm_appl_num%TYPE DEFAULT NULL;
3118: BEGIN
3119:
3120: OPEN c_adm_appl_status (p_person_id,

Line 3117: l_def_appl_sequence_num igs_ad_ps_appl_inst.def_term_adm_appl_num%TYPE DEFAULT NULL;

3113:
3114: l_offer_inst VARCHAR2(1) DEFAULT 'N';
3115: l_is_inst_complete BOOLEAN DEFAULT FALSE ;
3116: l_def_term_adm_appl_num igs_ad_ps_appl_inst.def_term_adm_appl_num%TYPE DEFAULT NULL;
3117: l_def_appl_sequence_num igs_ad_ps_appl_inst.def_term_adm_appl_num%TYPE DEFAULT NULL;
3118: BEGIN
3119:
3120: OPEN c_adm_appl_status (p_person_id,
3121: p_admission_appl_number

Line 3222: p_person_id igs_ad_ps_appl_inst.person_id%TYPE ,

3218: END check_adm_appl_inst_stat;
3219:
3220:
3221: FUNCTION valid_ofr_resp_status(
3222: p_person_id igs_ad_ps_appl_inst.person_id%TYPE ,
3223: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)
3224: RETURN BOOLEAN IS
3225: CURSOR c_ofr_resp_status (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
3226: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE) IS

Line 3223: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)

3219:
3220:
3221: FUNCTION valid_ofr_resp_status(
3222: p_person_id igs_ad_ps_appl_inst.person_id%TYPE ,
3223: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)
3224: RETURN BOOLEAN IS
3225: CURSOR c_ofr_resp_status (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
3226: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE) IS
3227: /*******************************************************************************

Line 3225: CURSOR c_ofr_resp_status (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,

3221: FUNCTION valid_ofr_resp_status(
3222: p_person_id igs_ad_ps_appl_inst.person_id%TYPE ,
3223: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)
3224: RETURN BOOLEAN IS
3225: CURSOR c_ofr_resp_status (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
3226: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE) IS
3227: /*******************************************************************************
3228: Created by : Rishi Ghosh
3229: Date created: 17-Apr-2003

Line 3226: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE) IS

3222: p_person_id igs_ad_ps_appl_inst.person_id%TYPE ,
3223: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)
3224: RETURN BOOLEAN IS
3225: CURSOR c_ofr_resp_status (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
3226: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE) IS
3227: /*******************************************************************************
3228: Created by : Rishi Ghosh
3229: Date created: 17-Apr-2003
3230: Purpose:

Line 3239: FROM igs_ad_ps_appl_inst

3235: Change History: (who, when, what: )
3236: Who When What
3237: *******************************************************************************/
3238: SELECT count(*)
3239: FROM igs_ad_ps_appl_inst
3240: WHERE person_id = cp_person_id AND
3241: admission_appl_number =cp_admission_appl_number AND
3242: (( adm_offer_resp_status IN ( SELECT adm_offer_resp_status
3243: FROM igs_ad_ofr_resp_stat

Line 3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

3325: App_Exception.Raise_Exception;
3326: END res_pending_fee_status;
3327:
3328: PROCEDURE Admp_resub_inst(
3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3330: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3331: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3332: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3333: p_do_commit VARCHAR2 DEFAULT NULL,

Line 3330: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

3326: END res_pending_fee_status;
3327:
3328: PROCEDURE Admp_resub_inst(
3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3330: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3331: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3332: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3333: p_do_commit VARCHAR2 DEFAULT NULL,
3334: x_return_status OUT NOCOPY VARCHAR2,

Line 3331: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

3327:
3328: PROCEDURE Admp_resub_inst(
3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3330: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3331: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3332: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3333: p_do_commit VARCHAR2 DEFAULT NULL,
3334: x_return_status OUT NOCOPY VARCHAR2,
3335: x_msg_count OUT NOCOPY NUMBER,

Line 3332: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

3328: PROCEDURE Admp_resub_inst(
3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3330: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3331: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3332: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3333: p_do_commit VARCHAR2 DEFAULT NULL,
3334: x_return_status OUT NOCOPY VARCHAR2,
3335: x_msg_count OUT NOCOPY NUMBER,
3336: x_msg_data OUT NOCOPY VARCHAR2

Line 3349: FROM IGS_AD_PS_APPL_INST acai

3345: Who When What
3346: *******************************************************************************/
3347: CURSOR c_acai IS
3348: SELECT ROWID, acai.*
3349: FROM IGS_AD_PS_APPL_INST acai
3350: WHERE acai.person_id = p_person_id AND
3351: acai.admission_appl_number = p_admission_appl_number AND
3352: acai.nominated_course_cd= p_nominated_course_cd AND
3353: acai.sequence_number = p_acai_sequence_number;

Line 3363: IGS_AD_PS_APPL_Inst_Pkg.update_row(

3359: OPEN c_acai;
3360: FETCH c_acai INTO acai_rec;
3361: IF (c_acai%FOUND) THEN
3362: -- Call to tbh to insert null values for Application instance status. This will resubmit the application instance.
3363: IGS_AD_PS_APPL_Inst_Pkg.update_row(
3364: X_ROWID => acai_rec.ROWID,
3365: x_PERSON_ID => acai_rec.PERSON_ID,
3366: x_ADMISSION_APPL_NUMBER => acai_rec.ADMISSION_APPL_NUMBER,
3367: x_NOMINATED_COURSE_CD => acai_rec.NOMINATED_COURSE_CD,

Line 3524: (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

3520:
3521:
3522: -- begin arvsrini - ADTD001 RE-OPEN BUILD- IGS.M
3523: FUNCTION check_any_offer_inst
3524: (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
3525: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
3526: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,
3527: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL
3528: )

Line 3525: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

3521:
3522: -- begin arvsrini - ADTD001 RE-OPEN BUILD- IGS.M
3523: FUNCTION check_any_offer_inst
3524: (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
3525: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
3526: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,
3527: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL
3528: )
3529: RETURN BOOLEAN IS

Line 3526: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,

3522: -- begin arvsrini - ADTD001 RE-OPEN BUILD- IGS.M
3523: FUNCTION check_any_offer_inst
3524: (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
3525: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
3526: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,
3527: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL
3528: )
3529: RETURN BOOLEAN IS
3530: -- created for IGS.M arvsrini

Line 3527: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL

3523: FUNCTION check_any_offer_inst
3524: (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
3525: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
3526: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,
3527: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL
3528: )
3529: RETURN BOOLEAN IS
3530: -- created for IGS.M arvsrini
3531: --Cursor to fetch the desired records.

Line 3532: Cursor c_aca ( cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

3528: )
3529: RETURN BOOLEAN IS
3530: -- created for IGS.M arvsrini
3531: --Cursor to fetch the desired records.
3532: Cursor c_aca ( cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
3533: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
3534: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
3535: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE
3536: ) IS

Line 3533: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

3529: RETURN BOOLEAN IS
3530: -- created for IGS.M arvsrini
3531: --Cursor to fetch the desired records.
3532: Cursor c_aca ( cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
3533: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
3534: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
3535: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE
3536: ) IS
3537: SELECT acai.adm_outcome_status outcome_status

Line 3534: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,

3530: -- created for IGS.M arvsrini
3531: --Cursor to fetch the desired records.
3532: Cursor c_aca ( cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
3533: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
3534: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
3535: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE
3536: ) IS
3537: SELECT acai.adm_outcome_status outcome_status
3538: FROM IGS_AD_PS_APPL_INST acai

Line 3535: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE

3531: --Cursor to fetch the desired records.
3532: Cursor c_aca ( cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
3533: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
3534: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
3535: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE
3536: ) IS
3537: SELECT acai.adm_outcome_status outcome_status
3538: FROM IGS_AD_PS_APPL_INST acai
3539: WHERE acai.person_id = cp_person_id AND

Line 3538: FROM IGS_AD_PS_APPL_INST acai

3534: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
3535: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE
3536: ) IS
3537: SELECT acai.adm_outcome_status outcome_status
3538: FROM IGS_AD_PS_APPL_INST acai
3539: WHERE acai.person_id = cp_person_id AND
3540: acai.admission_appl_number = cp_admission_appl_number AND
3541: acai.nominated_course_cd = NVL(cp_nominated_course_cd,acai.nominated_course_cd) AND
3542: acai.sequence_number= NVL(cp_sequence_number,acai.sequence_number) ;

Line 3574: FROM IGS_AD_PS_APPL_INST acai

3570: acai.adm_offer_resp_status,
3571: acai.adm_offer_dfrmnt_status,
3572: acai.def_term_adm_appl_num,
3573: acai.def_appl_sequence_num
3574: FROM IGS_AD_PS_APPL_INST acai
3575: WHERE acai.person_id = p_person_id AND
3576: acai.admission_appl_number = p_admission_appl_number AND
3577: acai.nominated_course_cd = p_nominated_course_cd AND
3578: acai.sequence_number = p_sequence_number;

Line 3640: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

3636: -- END arvsrini - ADTD001 RE-OPEN BUILD- IGS.M
3637:
3638: -- begin APADEGAL - ADTD001 RE-OPEN BUILD- IGS.M
3639: ---------------------------***************Is_inst_recon_allowed (PROCEDURE)**************-------------------------
3640: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3641: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3642: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3643: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3644: p_success out nocopy varchar2,

Line 3641: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

3637:
3638: -- begin APADEGAL - ADTD001 RE-OPEN BUILD- IGS.M
3639: ---------------------------***************Is_inst_recon_allowed (PROCEDURE)**************-------------------------
3640: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3641: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3642: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3643: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3644: p_success out nocopy varchar2,
3645: p_message_name out nocopy varchar2

Line 3642: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

3638: -- begin APADEGAL - ADTD001 RE-OPEN BUILD- IGS.M
3639: ---------------------------***************Is_inst_recon_allowed (PROCEDURE)**************-------------------------
3640: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3641: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3642: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3643: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3644: p_success out nocopy varchar2,
3645: p_message_name out nocopy varchar2
3646: ) IS

Line 3643: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

3639: ---------------------------***************Is_inst_recon_allowed (PROCEDURE)**************-------------------------
3640: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3641: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3642: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3643: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3644: p_success out nocopy varchar2,
3645: p_message_name out nocopy varchar2
3646: ) IS
3647: cst_accepted CONSTANT VARCHAR2(10) := 'ACCEPTED';

Line 3666: FROM igs_ad_ps_appl_inst acaiv

3662: acaiv.future_term_adm_appl_number,
3663: acaiv.future_term_sequence_number,
3664: acaiv.def_term_adm_appl_num,
3665: acaiv.def_appl_sequence_num
3666: FROM igs_ad_ps_appl_inst acaiv
3667: WHERE acaiv.person_id = p_person_id AND
3668: acaiv.admission_appl_number = p_admission_appl_number AND
3669: acaiv.nominated_course_cd = p_nominated_course_cd AND
3670: acaiv.sequence_number = p_sequence_number;

Line 3674: FROM igs_ad_ps_appl_inst acaiv

3670: acaiv.sequence_number = p_sequence_number;
3671: v_aa_acaiv_rec c_aa_acaiv%ROWTYPE;
3672: CURSOR c_other_offer_inst IS
3673: SELECT 1 CNT
3674: FROM igs_ad_ps_appl_inst acaiv
3675: WHERE acaiv.person_id = p_person_id AND
3676: acaiv.admission_appl_number = p_admission_appl_number AND
3677: acaiv.nominated_course_cd = p_nominated_course_cd AND
3678: acaiv.sequence_number <> p_sequence_number AND

Line 3771: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

3767: p_success := 'N';
3768: RETURN;
3769: END Is_inst_recon_allowed;
3770: ---------------------------***************Is_inst_recon_allowed (overloaded function)**************-------------------------
3771: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3772: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3773: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3774: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
3775: )

Line 3772: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

3768: RETURN;
3769: END Is_inst_recon_allowed;
3770: ---------------------------***************Is_inst_recon_allowed (overloaded function)**************-------------------------
3771: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3772: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3773: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3774: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
3775: )
3776: RETURN VARCHAR2 IS

Line 3773: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

3769: END Is_inst_recon_allowed;
3770: ---------------------------***************Is_inst_recon_allowed (overloaded function)**************-------------------------
3771: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3772: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3773: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3774: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
3775: )
3776: RETURN VARCHAR2 IS
3777: p_message_name VARCHAR2(40) DEFAULT NULL;

Line 3774: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE

3770: ---------------------------***************Is_inst_recon_allowed (overloaded function)**************-------------------------
3771: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3772: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3773: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3774: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
3775: )
3776: RETURN VARCHAR2 IS
3777: p_message_name VARCHAR2(40) DEFAULT NULL;
3778: p_success VARCHAR2(1) DEFAULT NULL;

Line 3787: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

3783:
3784: ---------------------------**************Reconsider_Appl_Inst***************-------------------------
3785:
3786: PROCEDURE Reconsider_Appl_Inst (
3787: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3788: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3789: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3790: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3791: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)

Line 3788: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

3784: ---------------------------**************Reconsider_Appl_Inst***************-------------------------
3785:
3786: PROCEDURE Reconsider_Appl_Inst (
3787: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3788: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3789: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3790: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3791: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
3792: )

Line 3789: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

3785:
3786: PROCEDURE Reconsider_Appl_Inst (
3787: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3788: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3789: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3790: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3791: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
3792: )
3793: IS

Line 3790: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

3786: PROCEDURE Reconsider_Appl_Inst (
3787: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3788: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3789: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3790: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3791: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
3792: )
3793: IS
3794:

Line 3818: FROM IGS_AD_PS_APPL_INST_ALL acai

3814: *******************************************************************************/
3815:
3816: CURSOR c_aca IS
3817: SELECT rowid,acai.*
3818: FROM IGS_AD_PS_APPL_INST_ALL acai
3819: WHERE acai.person_id = p_person_id AND
3820: acai.admission_appl_number = p_admission_appl_number AND
3821: acai.nominated_course_cd = p_nominated_course_cd AND
3822: acai.future_term_adm_appl_number IS NULL AND

Line 3830: CURSOR cur_ad_ps_appl ( cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,

3826: IGS_AD_GEN_008.ADMP_GET_SAOS(acai.ADM_OUTCOME_STATUS) <> 'PENDING'
3827: FOR UPDATE NOWAIT;
3828:
3829:
3830: CURSOR cur_ad_ps_appl ( cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,
3831: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,
3832: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS
3833: SELECT rowid , IGS_AD_PS_APPL.*
3834: FROM IGS_AD_PS_APPL

Line 3831: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,

3827: FOR UPDATE NOWAIT;
3828:
3829:
3830: CURSOR cur_ad_ps_appl ( cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,
3831: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,
3832: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS
3833: SELECT rowid , IGS_AD_PS_APPL.*
3834: FROM IGS_AD_PS_APPL
3835: WHERE person_id = CUR_person_id AND

Line 3832: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS

3828:
3829:
3830: CURSOR cur_ad_ps_appl ( cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,
3831: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,
3832: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS
3833: SELECT rowid , IGS_AD_PS_APPL.*
3834: FROM IGS_AD_PS_APPL
3835: WHERE person_id = CUR_person_id AND
3836: admission_appl_number = CUR_admission_appl_number AND

Line 3833: SELECT rowid , IGS_AD_PS_APPL.*

3829:
3830: CURSOR cur_ad_ps_appl ( cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,
3831: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,
3832: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS
3833: SELECT rowid , IGS_AD_PS_APPL.*
3834: FROM IGS_AD_PS_APPL
3835: WHERE person_id = CUR_person_id AND
3836: admission_appl_number = CUR_admission_appl_number AND
3837: nominated_course_cd = CUR_nominated_course_cd;

Line 3834: FROM IGS_AD_PS_APPL

3830: CURSOR cur_ad_ps_appl ( cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,
3831: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,
3832: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS
3833: SELECT rowid , IGS_AD_PS_APPL.*
3834: FROM IGS_AD_PS_APPL
3835: WHERE person_id = CUR_person_id AND
3836: admission_appl_number = CUR_admission_appl_number AND
3837: nominated_course_cd = CUR_nominated_course_cd;
3838: cur_ad_ps_appl_rec cur_ad_ps_appl%ROWTYPE ;

Line 3933: IGS_AD_PS_APPL_INST_PKG.UPDATE_ROW (X_ROWID => c_aca_rec.ROWID ,

3929: END IF;
3930:
3931: END IF;
3932:
3933: IGS_AD_PS_APPL_INST_PKG.UPDATE_ROW (X_ROWID => c_aca_rec.ROWID ,
3934: x_PERSON_ID => c_aca_rec.PERSON_ID ,
3935: x_ADMISSION_APPL_NUMBER => c_aca_rec.ADMISSION_APPL_NUMBER ,
3936: x_NOMINATED_COURSE_CD => c_aca_rec.NOMINATED_COURSE_CD ,
3937: x_SEQUENCE_NUMBER => c_aca_rec.SEQUENCE_NUMBER ,

Line 4099: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

4095:
4096:
4097: -- following function would be invoked only from Admin Dashboard for reconsideration
4098: PROCEDURE Recon_Appl_inst (
4099: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4100: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4101: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4102: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4103: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)

Line 4100: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

4096:
4097: -- following function would be invoked only from Admin Dashboard for reconsideration
4098: PROCEDURE Recon_Appl_inst (
4099: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4100: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4101: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4102: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4103: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
4104: )

Line 4101: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

4097: -- following function would be invoked only from Admin Dashboard for reconsideration
4098: PROCEDURE Recon_Appl_inst (
4099: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4100: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4101: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4102: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4103: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
4104: )
4105: IS

Line 4102: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

4098: PROCEDURE Recon_Appl_inst (
4099: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4100: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4101: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4102: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4103: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
4104: )
4105: IS
4106:

Line 4107: CURSOR cur_ad_ps_appl (cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,

4103: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
4104: )
4105: IS
4106:
4107: CURSOR cur_ad_ps_appl (cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,
4108: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,
4109: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS
4110: SELECT rowid , IGS_AD_PS_APPL.*
4111: FROM IGS_AD_PS_APPL

Line 4108: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,

4104: )
4105: IS
4106:
4107: CURSOR cur_ad_ps_appl (cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,
4108: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,
4109: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS
4110: SELECT rowid , IGS_AD_PS_APPL.*
4111: FROM IGS_AD_PS_APPL
4112: WHERE person_id = CUR_person_id AND

Line 4109: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS

4105: IS
4106:
4107: CURSOR cur_ad_ps_appl (cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,
4108: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,
4109: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS
4110: SELECT rowid , IGS_AD_PS_APPL.*
4111: FROM IGS_AD_PS_APPL
4112: WHERE person_id = CUR_person_id AND
4113: admission_appl_number = CUR_admission_appl_number AND

Line 4110: SELECT rowid , IGS_AD_PS_APPL.*

4106:
4107: CURSOR cur_ad_ps_appl (cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,
4108: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,
4109: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS
4110: SELECT rowid , IGS_AD_PS_APPL.*
4111: FROM IGS_AD_PS_APPL
4112: WHERE person_id = CUR_person_id AND
4113: admission_appl_number = CUR_admission_appl_number AND
4114: nominated_course_cd = CUR_nominated_course_cd;

Line 4111: FROM IGS_AD_PS_APPL

4107: CURSOR cur_ad_ps_appl (cur_person_id IGS_AD_PS_APPL.person_id%TYPE ,
4108: cur_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE ,
4109: cur_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE ) IS
4110: SELECT rowid , IGS_AD_PS_APPL.*
4111: FROM IGS_AD_PS_APPL
4112: WHERE person_id = CUR_person_id AND
4113: admission_appl_number = CUR_admission_appl_number AND
4114: nominated_course_cd = CUR_nominated_course_cd;
4115:

Line 4125: IGS_AD_PS_APPL_PKG.UPDATE_ROW (

4121:
4122:
4123: OPEN cur_ad_ps_appl(p_person_id ,p_ADMISSION_APPL_NUMBER,p_NOMINATED_COURSE_CD);
4124: FETCH cur_ad_ps_appl INTO cur_ad_ps_appl_rec;
4125: IGS_AD_PS_APPL_PKG.UPDATE_ROW (
4126: X_ROWID => cur_ad_ps_appl_rec.ROWID ,
4127: X_PERSON_ID => cur_ad_ps_appl_rec.PERSON_ID ,
4128: X_ADMISSION_APPL_NUMBER => cur_ad_ps_appl_rec.ADMISSION_APPL_NUMBER ,
4129: X_NOMINATED_COURSE_CD => cur_ad_ps_appl_rec.NOMINATED_COURSE_CD ,

Line 4152: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

4148: END Recon_Appl_inst;
4149:
4150: -----------------***************** check_adm_appl_inst_stat overloaded function to invoke in Selfservice ***------------------------------------
4151: FUNCTION check_adm_appl_inst_stat(
4152: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4153: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4154: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
4155: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
4156: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.

Line 4153: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

4149:
4150: -----------------***************** check_adm_appl_inst_stat overloaded function to invoke in Selfservice ***------------------------------------
4151: FUNCTION check_adm_appl_inst_stat(
4152: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4153: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4154: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
4155: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
4156: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
4157: )

Line 4154: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,

4150: -----------------***************** check_adm_appl_inst_stat overloaded function to invoke in Selfservice ***------------------------------------
4151: FUNCTION check_adm_appl_inst_stat(
4152: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4153: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4154: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
4155: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
4156: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
4157: )
4158: RETURN VARCHAR2

Line 4155: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,

4151: FUNCTION check_adm_appl_inst_stat(
4152: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4153: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4154: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
4155: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
4156: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
4157: )
4158: RETURN VARCHAR2
4159: IS

Line 4177: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

4173: WHEN OTHERS THEN
4174: RETURN 'N';
4175: END check_adm_appl_inst_stat;
4176:
4177: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4178: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4179: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
4180: )
4181: IS

Line 4178: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

4174: RETURN 'N';
4175: END check_adm_appl_inst_stat;
4176:
4177: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4178: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4179: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
4180: )
4181: IS
4182:

Line 4179: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE

4175: END check_adm_appl_inst_stat;
4176:
4177: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4178: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4179: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
4180: )
4181: IS
4182:
4183: CURSOR c_inst IS

Line 4185: FROM igs_ad_ps_appl_inst_all acai

4181: IS
4182:
4183: CURSOR c_inst IS
4184: SELECT rowid,acai.*
4185: FROM igs_ad_ps_appl_inst_all acai
4186: WHERE acai.person_id = p_person_id AND
4187: acai.admission_appl_number = p_admission_appl_number AND
4188: acai.nominated_course_cd = p_nominated_course_cd AND
4189: acai.future_term_adm_appl_number IS NULL AND

Line 4199: CURSOR c_inst_last_who ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

4195: FOR UPDATE NOWAIT;
4196:
4197: c_inst_rec c_inst%ROWTYPE;
4198:
4199: CURSOR c_inst_last_who ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4200: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4201: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
4203: )

Line 4200: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

4196:
4197: c_inst_rec c_inst%ROWTYPE;
4198:
4199: CURSOR c_inst_last_who ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4200: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4201: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
4203: )
4204: IS

Line 4201: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

4197: c_inst_rec c_inst%ROWTYPE;
4198:
4199: CURSOR c_inst_last_who ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4200: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4201: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
4203: )
4204: IS
4205: SELECT last_update_date

Line 4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE

4198:
4199: CURSOR c_inst_last_who ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4200: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4201: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
4203: )
4204: IS
4205: SELECT last_update_date
4206: FROM igs_ad_ps_appl_inst_all acinst

Line 4206: FROM igs_ad_ps_appl_inst_all acinst

4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
4203: )
4204: IS
4205: SELECT last_update_date
4206: FROM igs_ad_ps_appl_inst_all acinst
4207: WHERE acinst.person_id = cp_person_id AND
4208: acinst.admission_appl_number = cp_admission_appl_number AND
4209: acinst.nominated_course_cd = cp_nominated_course_cd AND
4210: acinst.sequence_number = cp_sequence_number;

Line 4215: CURSOR c_old_hist_dt ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

4211:
4212: c_inst_last_who_rec c_inst_last_who%ROWTYPE;
4213:
4214:
4215: CURSOR c_old_hist_dt ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4216: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4217: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4219: cp_old_update_on DATE)

Line 4216: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

4212: c_inst_last_who_rec c_inst_last_who%ROWTYPE;
4213:
4214:
4215: CURSOR c_old_hist_dt ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4216: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4217: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4219: cp_old_update_on DATE)
4220: IS

Line 4217: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

4213:
4214:
4215: CURSOR c_old_hist_dt ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4216: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4217: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4219: cp_old_update_on DATE)
4220: IS
4221: SELECT 'x'

Line 4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

4214:
4215: CURSOR c_old_hist_dt ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4216: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4217: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4219: cp_old_update_on DATE)
4220: IS
4221: SELECT 'x'
4222: FROM IGS_AD_PS_APLINSTHST ahist

Line 4229: CURSOR cur_ad_ps_appl ( cp_person_id igs_ad_ps_appl.person_id%type ,

4225: AND nominated_course_cd = cp_nominated_course_cd
4226: AND sequence_number = cp_sequence_number
4227: AND hist_start_dt = cp_old_update_on;
4228:
4229: CURSOR cur_ad_ps_appl ( cp_person_id igs_ad_ps_appl.person_id%type ,
4230: cp_admission_appl_number igs_ad_ps_appl.admission_appl_number%type ,
4231: cp_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%type )
4232: IS
4233: SELECT req_for_reconsideration_ind

Line 4230: cp_admission_appl_number igs_ad_ps_appl.admission_appl_number%type ,

4226: AND sequence_number = cp_sequence_number
4227: AND hist_start_dt = cp_old_update_on;
4228:
4229: CURSOR cur_ad_ps_appl ( cp_person_id igs_ad_ps_appl.person_id%type ,
4230: cp_admission_appl_number igs_ad_ps_appl.admission_appl_number%type ,
4231: cp_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%type )
4232: IS
4233: SELECT req_for_reconsideration_ind
4234: FROM igs_ad_ps_appl

Line 4231: cp_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%type )

4227: AND hist_start_dt = cp_old_update_on;
4228:
4229: CURSOR cur_ad_ps_appl ( cp_person_id igs_ad_ps_appl.person_id%type ,
4230: cp_admission_appl_number igs_ad_ps_appl.admission_appl_number%type ,
4231: cp_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%type )
4232: IS
4233: SELECT req_for_reconsideration_ind
4234: FROM igs_ad_ps_appl
4235: WHERE person_id = cp_person_id and

Line 4234: FROM igs_ad_ps_appl

4230: cp_admission_appl_number igs_ad_ps_appl.admission_appl_number%type ,
4231: cp_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%type )
4232: IS
4233: SELECT req_for_reconsideration_ind
4234: FROM igs_ad_ps_appl
4235: WHERE person_id = cp_person_id and
4236: admission_appl_number = cp_admission_appl_number and
4237: nominated_course_cd = cp_nominated_course_cd;
4238:

Line 4258: IGS_AD_PS_APPL_INST_PKG.UPDATE_ROW

4254: LOOP
4255:
4256: --calling INSTANCE TBH, but not updating anything.. this is just to create a dummy history record.
4257:
4258: IGS_AD_PS_APPL_INST_PKG.UPDATE_ROW
4259: (
4260: X_Mode => 'S',
4261: X_RowId => c_inst_rec.rowid,
4262: X_Person_Id => c_inst_rec.Person_Id,

Line 4530: FROM igs_ad_ps_appl_inst acaiv

4526: SELECT acaiv.future_term_adm_appl_number,
4527: acaiv.future_term_sequence_number,
4528: acaiv.def_term_adm_appl_num,
4529: acaiv.def_appl_sequence_num
4530: FROM igs_ad_ps_appl_inst acaiv
4531: WHERE acaiv.person_id = p_person_id AND
4532: acaiv.admission_appl_number = p_admission_appl_number AND
4533: acaiv.nominated_course_cd = p_nominated_course_cd AND
4534: acaiv.sequence_number = p_sequence_number;