DBA Data[Home] [Help]

APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_PS_APPL_INST_APLINST_V

Line 3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;

3448: v_valid_location BOOLEAN := FALSE;
3449: v_valid_att_mode BOOLEAN := FALSE;
3450: v_valid_att_type BOOLEAN := FALSE;
3451: v_valid_unit_set BOOLEAN := FALSE;
3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;
3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;

Line 3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;

3449: v_valid_att_mode BOOLEAN := FALSE;
3450: v_valid_att_type BOOLEAN := FALSE;
3451: v_valid_unit_set BOOLEAN := FALSE;
3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;
3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;

Line 3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;

3450: v_valid_att_type BOOLEAN := FALSE;
3451: v_valid_unit_set BOOLEAN := FALSE;
3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;
3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num

Line 3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;

3451: v_valid_unit_set BOOLEAN := FALSE;
3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;
3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;

Line 3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;

3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;
3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;

Line 3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;

3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;

Line 3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;

3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd

Line 3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;

3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;

Line 3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;

3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;

Line 3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;

3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;

Line 3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;

3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type

Line 3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;

3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;

Line 3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;

3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;

Line 3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;

3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;

Line 3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;

3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;

Line 3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;

3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;
3474: v_sca_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;

Line 3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;

3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;
3474: v_sca_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;
3475: v_sca_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;

Line 3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;

3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;
3474: v_sca_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;
3475: v_sca_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;
3476: v_scae_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;