DBA Data[Home] [Help]

APPS.IGS_ADMAPPLICATION_PUB dependencies on IGS_AD_OFFRESP_INT

Line 1276: p_person_id IN igs_ad_offresp_int.person_id%TYPE,

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 ,

Line 1277: p_admission_appl_number IN igs_ad_offresp_int.admission_appl_number%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,

Line 1278: p_nominated_course_cd IN igs_ad_offresp_int.nominated_course_cd%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,

Line 1279: p_sequence_number IN igs_ad_offresp_int.sequence_number%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,

Line 1280: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%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,

Line 1281: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%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)

Line 1282: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%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)
1286: -- p_authorizing_pers_id IN NUMBER, --NUMBER(15) LOV (No validation) need to write validations

Line 1283: -- p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_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
1287: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,

Line 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,

Line 1288: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%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,

Line 1289: p_def_adm_cal_type IN igs_ad_offresp_int.def_adm_cal_type%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,

Line 1290: p_def_adm_ci_sequence_number IN igs_ad_offresp_int.def_adm_ci_sequence_number%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,

Line 1291: p_decline_ofr_reason IN igs_ad_offresp_int.decline_ofr_reason%TYPE,

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

Line 1292: p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%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
1296: ---------------------------------------------------------------------------------------------------------------------------------------

Line 1293: p_calc_actual_ofr_resp_dt OUT NOCOPY igs_ad_offresp_int.actual_offer_response_dt%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: ---------------------------------------------------------------------------------------------------------------------------------------
1297: -- Created By : rsharma