1272:
1273: END Record_Outcome_AdmApplication;
1274:
1275: PROCEDURE validate_off_resp_dtls(
1276: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
1277: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
1278: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
1279: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
1280: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
1273: END Record_Outcome_AdmApplication;
1274:
1275: PROCEDURE validate_off_resp_dtls(
1276: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
1277: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
1278: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
1279: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
1280: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
1281: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1274:
1275: PROCEDURE validate_off_resp_dtls(
1276: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
1277: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
1278: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
1279: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
1280: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
1281: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1282: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
1275: PROCEDURE validate_off_resp_dtls(
1276: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
1277: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
1278: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
1279: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
1280: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
1281: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1282: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
1283: -- p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1276: p_person_id IN igs_ad_offresp_int.person_id%TYPE,
1277: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
1278: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
1279: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
1280: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
1281: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1282: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
1283: -- p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1284: p_adm_offer_defr_status IN OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
1277: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%TYPE,
1278: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
1279: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
1280: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
1281: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1282: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
1283: -- p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1284: p_adm_offer_defr_status IN OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
1285: -- p_authorized_dt IN DATE, -- if null then default it to sys date. and validation exists in Form(pld)
1278: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%TYPE ,
1279: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
1280: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
1281: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1282: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
1283: -- p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1284: p_adm_offer_defr_status IN OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
1285: -- p_authorized_dt IN DATE, -- if null then default it to sys date. and validation exists in Form(pld)
1286: -- p_authorizing_pers_id IN NUMBER, --NUMBER(15) LOV (No validation) need to write validations
1279: p_sequence_number IN igs_ad_offresp_int.sequence_number%TYPE,
1280: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
1281: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1282: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
1283: -- p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1284: p_adm_offer_defr_status IN OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
1285: -- p_authorized_dt IN DATE, -- if null then default it to sys date. and validation exists in Form(pld)
1286: -- p_authorizing_pers_id IN NUMBER, --NUMBER(15) LOV (No validation) need to write validations
1287: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
1283: -- p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1284: p_adm_offer_defr_status IN OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
1285: -- p_authorized_dt IN DATE, -- if null then default it to sys date. and validation exists in Form(pld)
1286: -- p_authorizing_pers_id IN NUMBER, --NUMBER(15) LOV (No validation) need to write validations
1287: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
1288: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
1289: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
1290: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
1291: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE,
1284: p_adm_offer_defr_status IN OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
1285: -- p_authorized_dt IN DATE, -- if null then default it to sys date. and validation exists in Form(pld)
1286: -- p_authorizing_pers_id IN NUMBER, --NUMBER(15) LOV (No validation) need to write validations
1287: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
1288: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
1289: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
1290: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
1291: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE,
1292: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1285: -- p_authorized_dt IN DATE, -- if null then default it to sys date. and validation exists in Form(pld)
1286: -- p_authorizing_pers_id IN NUMBER, --NUMBER(15) LOV (No validation) need to write validations
1287: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
1288: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
1289: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
1290: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
1291: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE,
1292: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1293: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1286: -- p_authorizing_pers_id IN NUMBER, --NUMBER(15) LOV (No validation) need to write validations
1287: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
1288: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
1289: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
1290: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
1291: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE,
1292: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1293: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1294: -- p_yes_no IN VARCHAR2,
1287: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
1288: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
1289: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
1290: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
1291: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE,
1292: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1293: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1294: -- p_yes_no IN VARCHAR2,
1295: p_validation_success OUT NOCOPY VARCHAR2) IS
1288: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,
1289: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
1290: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
1291: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE,
1292: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1293: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1294: -- p_yes_no IN VARCHAR2,
1295: p_validation_success OUT NOCOPY VARCHAR2) IS
1296: ---------------------------------------------------------------------------------------------------------------------------------------
1289: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%TYPE ,
1290: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%TYPE ,
1291: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE,
1292: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1293: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1294: -- p_yes_no IN VARCHAR2,
1295: p_validation_success OUT NOCOPY VARCHAR2) IS
1296: ---------------------------------------------------------------------------------------------------------------------------------------
1297: -- Created By : rsharma