APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_AD_PS_APPL_INST_ALL

Line 63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;

59: -- [
60: lv_ad_appl_row_id ROWID; -- Retains RowId for IGS_AD_APPL
61: lv_ad_prog_row_id ROWID; -- Retains RowId for IGS_AD_PS_APPL_INST
62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
67: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;

Line 64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;

60: lv_ad_appl_row_id ROWID; -- Retains RowId for IGS_AD_APPL
61: lv_ad_prog_row_id ROWID; -- Retains RowId for IGS_AD_PS_APPL_INST
62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
67: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
68: lv_multiple VARCHAR2(10); -- Hold 'Y' / 'N'

Line 65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;

61: lv_ad_prog_row_id ROWID; -- Retains RowId for IGS_AD_PS_APPL_INST
62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
67: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
68: lv_multiple VARCHAR2(10); -- Hold 'Y' / 'N'
69: -- ]

Line 66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;

62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
67: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
68: lv_multiple VARCHAR2(10); -- Hold 'Y' / 'N'
69: -- ]
70:

Line 87: lv_expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE;

83:
84: -- variables to get anticipated completion date
85: -- [
86: lv_course_start_dt DATE;
87: lv_expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE;
88: lv_expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE;
89: lv_completion_dt DATE;
90: -- ]
91:

Line 88: lv_expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE;

84: -- variables to get anticipated completion date
85: -- [
86: lv_course_start_dt DATE;
87: lv_expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE;
88: lv_expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE;
89: lv_completion_dt DATE;
90: -- ]
91:
92: -- variables to get Cummulative and Current GPA