APPS.IGF_AP_OSS_INTEGR dependencies on IGS_AD_OFR_RESP_STAT

Line 403: IGS_AD_OFR_RESP_STAT rpstat

399: IGS_AD_PS_APPL_INST acai,
400: IGS_PS_VER crv,
401: IGS_AD_APPL_STAT apstat,
402: IGS_AD_OU_STAT oustat,
403: IGS_AD_OFR_RESP_STAT rpstat
404: WHERE aav.person_id = acai.person_id (+)
405: AND aav.admission_appl_number = acai.admission_appl_number(+)
406: AND aav.person_id = p_person_id
407: /*AND aav.acad_cal_type = c_cal_type

Line 508: lv_adm_offer_resp_stat igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;

504: lv_ad_prog_appl_row_id ROWID;
505: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
506: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
507: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
508: lv_adm_offer_resp_stat igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
509: lv_adm_outcome_stat igs_ad_ou_stat.adm_outcome_status%TYPE;
510: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
511: lv_multiple VARCHAR2(10) ;
512: BEGIN

Line 557: lv_adm_offer_resp_stat igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;

553: lv_ad_prog_appl_row_id ROWID;
554: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
555: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
556: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
557: lv_adm_offer_resp_stat igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
558: lv_adm_outcome_stat igs_ad_ou_stat.adm_outcome_status%TYPE;
559: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
560: lv_multiple VARCHAR2(10) ;
561: BEGIN