55:
56: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
57: c_dyn_pig_check c_dyn_pig_checkCurTyp;
58:
59: TYPE c_dyn_pig_checkrecTyp IS RECORD ( row_id igs_ad_ps_appl.row_id%TYPE,
60: person_id igs_ad_ps_appl.person_id%TYPE,
61: admission_appl_number igs_ad_ps_appl.admission_appl_number%TYPE,
62: nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
63: transfer_course_cd igs_ad_ps_appl.transfer_course_cd%TYPE,
56: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
57: c_dyn_pig_check c_dyn_pig_checkCurTyp;
58:
59: TYPE c_dyn_pig_checkrecTyp IS RECORD ( row_id igs_ad_ps_appl.row_id%TYPE,
60: person_id igs_ad_ps_appl.person_id%TYPE,
61: admission_appl_number igs_ad_ps_appl.admission_appl_number%TYPE,
62: nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
63: transfer_course_cd igs_ad_ps_appl.transfer_course_cd%TYPE,
64: basis_for_admission_type igs_ad_ps_appl.basis_for_admission_type%TYPE,
57: c_dyn_pig_check c_dyn_pig_checkCurTyp;
58:
59: TYPE c_dyn_pig_checkrecTyp IS RECORD ( row_id igs_ad_ps_appl.row_id%TYPE,
60: person_id igs_ad_ps_appl.person_id%TYPE,
61: admission_appl_number igs_ad_ps_appl.admission_appl_number%TYPE,
62: nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
63: transfer_course_cd igs_ad_ps_appl.transfer_course_cd%TYPE,
64: basis_for_admission_type igs_ad_ps_appl.basis_for_admission_type%TYPE,
65: admission_cd igs_ad_ps_appl.admission_cd%TYPE,
58:
59: TYPE c_dyn_pig_checkrecTyp IS RECORD ( row_id igs_ad_ps_appl.row_id%TYPE,
60: person_id igs_ad_ps_appl.person_id%TYPE,
61: admission_appl_number igs_ad_ps_appl.admission_appl_number%TYPE,
62: nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
63: transfer_course_cd igs_ad_ps_appl.transfer_course_cd%TYPE,
64: basis_for_admission_type igs_ad_ps_appl.basis_for_admission_type%TYPE,
65: admission_cd igs_ad_ps_appl.admission_cd%TYPE,
66: course_rank_set igs_ad_ps_appl.course_rank_set%TYPE,
59: TYPE c_dyn_pig_checkrecTyp IS RECORD ( row_id igs_ad_ps_appl.row_id%TYPE,
60: person_id igs_ad_ps_appl.person_id%TYPE,
61: admission_appl_number igs_ad_ps_appl.admission_appl_number%TYPE,
62: nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
63: transfer_course_cd igs_ad_ps_appl.transfer_course_cd%TYPE,
64: basis_for_admission_type igs_ad_ps_appl.basis_for_admission_type%TYPE,
65: admission_cd igs_ad_ps_appl.admission_cd%TYPE,
66: course_rank_set igs_ad_ps_appl.course_rank_set%TYPE,
67: course_rank_schedule igs_ad_ps_appl.course_rank_schedule%TYPE,
60: person_id igs_ad_ps_appl.person_id%TYPE,
61: admission_appl_number igs_ad_ps_appl.admission_appl_number%TYPE,
62: nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
63: transfer_course_cd igs_ad_ps_appl.transfer_course_cd%TYPE,
64: basis_for_admission_type igs_ad_ps_appl.basis_for_admission_type%TYPE,
65: admission_cd igs_ad_ps_appl.admission_cd%TYPE,
66: course_rank_set igs_ad_ps_appl.course_rank_set%TYPE,
67: course_rank_schedule igs_ad_ps_appl.course_rank_schedule%TYPE,
68: req_for_adv_standing_ind igs_ad_ps_appl.req_for_adv_standing_ind%TYPE );
61: admission_appl_number igs_ad_ps_appl.admission_appl_number%TYPE,
62: nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
63: transfer_course_cd igs_ad_ps_appl.transfer_course_cd%TYPE,
64: basis_for_admission_type igs_ad_ps_appl.basis_for_admission_type%TYPE,
65: admission_cd igs_ad_ps_appl.admission_cd%TYPE,
66: course_rank_set igs_ad_ps_appl.course_rank_set%TYPE,
67: course_rank_schedule igs_ad_ps_appl.course_rank_schedule%TYPE,
68: req_for_adv_standing_ind igs_ad_ps_appl.req_for_adv_standing_ind%TYPE );
69: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
62: nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
63: transfer_course_cd igs_ad_ps_appl.transfer_course_cd%TYPE,
64: basis_for_admission_type igs_ad_ps_appl.basis_for_admission_type%TYPE,
65: admission_cd igs_ad_ps_appl.admission_cd%TYPE,
66: course_rank_set igs_ad_ps_appl.course_rank_set%TYPE,
67: course_rank_schedule igs_ad_ps_appl.course_rank_schedule%TYPE,
68: req_for_adv_standing_ind igs_ad_ps_appl.req_for_adv_standing_ind%TYPE );
69: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
70:
63: transfer_course_cd igs_ad_ps_appl.transfer_course_cd%TYPE,
64: basis_for_admission_type igs_ad_ps_appl.basis_for_admission_type%TYPE,
65: admission_cd igs_ad_ps_appl.admission_cd%TYPE,
66: course_rank_set igs_ad_ps_appl.course_rank_set%TYPE,
67: course_rank_schedule igs_ad_ps_appl.course_rank_schedule%TYPE,
68: req_for_adv_standing_ind igs_ad_ps_appl.req_for_adv_standing_ind%TYPE );
69: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
70:
71: TYPE c_dyn_pig_check_table IS TABLE OF c_dyn_pig_check_rec%TYPE INDEX BY BINARY_INTEGER;
64: basis_for_admission_type igs_ad_ps_appl.basis_for_admission_type%TYPE,
65: admission_cd igs_ad_ps_appl.admission_cd%TYPE,
66: course_rank_set igs_ad_ps_appl.course_rank_set%TYPE,
67: course_rank_schedule igs_ad_ps_appl.course_rank_schedule%TYPE,
68: req_for_adv_standing_ind igs_ad_ps_appl.req_for_adv_standing_ind%TYPE );
69: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
70:
71: TYPE c_dyn_pig_check_table IS TABLE OF c_dyn_pig_check_rec%TYPE INDEX BY BINARY_INTEGER;
72:
75:
76: TYPE c_pend_futCurTyp IS REF CURSOR;
77: c_pend_fut c_pend_futCurTyp;
78:
79: TYPE c_pend_futrecTyp IS RECORD (rowid igs_ad_ps_appl_inst.ROW_ID%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
76: TYPE c_pend_futCurTyp IS REF CURSOR;
77: c_pend_fut c_pend_futCurTyp;
78:
79: TYPE c_pend_futrecTyp IS RECORD (rowid igs_ad_ps_appl_inst.ROW_ID%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
77: c_pend_fut c_pend_futCurTyp;
78:
79: TYPE c_pend_futrecTyp IS RECORD (rowid igs_ad_ps_appl_inst.ROW_ID%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
78:
79: TYPE c_pend_futrecTyp IS RECORD (rowid igs_ad_ps_appl_inst.ROW_ID%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
79: TYPE c_pend_futrecTyp IS RECORD (rowid igs_ad_ps_appl_inst.ROW_ID%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
208: decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE);
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
208: decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE);
209:
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
208: decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE);
209:
210: c_pend_fut_rec c_pend_futrecTyp;
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
208: decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE);
209:
210: c_pend_fut_rec c_pend_futrecTyp;
211:
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
208: decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE);
209:
210: c_pend_fut_rec c_pend_futrecTyp;
211:
212: TYPE c_pend_fut_table IS TABLE OF c_pend_fut_rec%TYPE INDEX BY BINARY_INTEGER;
225: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
226: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
227: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE) IS
228: SELECT distinct psapl.*
229: FROM igs_ad_ps_appl_inst apai,
230: igs_ad_ps_appl psapl,
231: igs_ad_ou_stat aos,
232: igs_ad_appl aa,
233: igs_ad_appl_stat aps
226: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
227: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE) IS
228: SELECT distinct psapl.*
229: FROM igs_ad_ps_appl_inst apai,
230: igs_ad_ps_appl psapl,
231: igs_ad_ou_stat aos,
232: igs_ad_appl aa,
233: igs_ad_appl_stat aps
234: WHERE (( Aa.acad_cal_type = cp_acad_cal_type AND cp_acad_cal_type IS NOT NULL) OR ( cp_acad_cal_type IS NULL))AND
260: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
261: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
262: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE)IS
263: SELECT apai.rowid, apai.*
264: FROM Igs_ad_ps_appl_inst apai,
265: Igs_ad_ps_appl psapl,
266: Igs_ad_ou_stat aos,
267: Igs_ad_appl_all Aa
268: WHERE (( Aa.acad_cal_type = cp_acad_cal_type AND cp_acad_cal_type IS NOT NULL) OR ( cp_acad_cal_type IS NULL))AND
261: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
262: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE)IS
263: SELECT apai.rowid, apai.*
264: FROM Igs_ad_ps_appl_inst apai,
265: Igs_ad_ps_appl psapl,
266: Igs_ad_ou_stat aos,
267: Igs_ad_appl_all Aa
268: WHERE (( Aa.acad_cal_type = cp_acad_cal_type AND cp_acad_cal_type IS NOT NULL) OR ( cp_acad_cal_type IS NULL))AND
269: (( Aa.acad_ci_sequence_number = cp_acad_sequence_number AND cp_acad_sequence_number IS NOT NULL)OR (cp_acad_sequence_number IS NULL) ) AND
311: FROM igs_ad_appl_all
312: WHERE person_id = cp_person_id
313: AND admission_appl_number = cp_admission_appl_number;
314:
315: CURSOR c_get_inst_dtls(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
316: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
317: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
318: SELECT apai.rowid,apai.*
319: FROM igs_ad_ps_appl_inst_all apai
312: WHERE person_id = cp_person_id
313: AND admission_appl_number = cp_admission_appl_number;
314:
315: CURSOR c_get_inst_dtls(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
316: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
317: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
318: SELECT apai.rowid,apai.*
319: FROM igs_ad_ps_appl_inst_all apai
320: WHERE apai.person_id = cp_person_id
313: AND admission_appl_number = cp_admission_appl_number;
314:
315: CURSOR c_get_inst_dtls(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
316: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
317: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
318: SELECT apai.rowid,apai.*
319: FROM igs_ad_ps_appl_inst_all apai
320: WHERE apai.person_id = cp_person_id
321: AND apai.admission_appl_number = cp_admission_appl_number
315: CURSOR c_get_inst_dtls(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
316: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
317: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
318: SELECT apai.rowid,apai.*
319: FROM igs_ad_ps_appl_inst_all apai
320: WHERE apai.person_id = cp_person_id
321: AND apai.admission_appl_number = cp_admission_appl_number
322: AND apai.nominated_course_cd = cp_nominated_course_cd
323: AND NVL(apai.appl_inst_status,'RECEIVED') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = 'WITHDRAWN');
415: l_sql_stmt1 VARCHAR2(32676) := 'SELECT distinct psapl.row_id,psapl.person_id, psapl.admission_appl_number,psapl.nominated_course_cd,
416: psapl.transfer_course_cd,psapl.basis_for_admission_type,psapl.admission_cd,
417: psapl.course_rank_set,psapl.course_rank_schedule, psapl.req_for_adv_standing_ind
418: FROM
419: Igs_ad_ps_appl_inst apai,
420: igs_ad_ps_appl psapl,
421: Igs_ad_ou_stat aos,
422: Igs_ad_appl aa,
423: Igs_ad_appl_stat aps
416: psapl.transfer_course_cd,psapl.basis_for_admission_type,psapl.admission_cd,
417: psapl.course_rank_set,psapl.course_rank_schedule, psapl.req_for_adv_standing_ind
418: FROM
419: Igs_ad_ps_appl_inst apai,
420: igs_ad_ps_appl psapl,
421: Igs_ad_ou_stat aos,
422: Igs_ad_appl aa,
423: Igs_ad_appl_stat aps
424: WHERE
579: apai.def_appl_sequence_num,
580: apai.appl_inst_status,
581: apai.ais_reason,
582: apai.decline_ofr_reason
583: FROM Igs_ad_ps_appl_inst apai,
584: Igs_ad_ps_appl psapl,
585: Igs_ad_ou_stat aos,
586: Igs_ad_appl_all Aa
587: WHERE Apai.person_id IN ';
580: apai.appl_inst_status,
581: apai.ais_reason,
582: apai.decline_ofr_reason
583: FROM Igs_ad_ps_appl_inst apai,
584: Igs_ad_ps_appl psapl,
585: Igs_ad_ou_stat aos,
586: Igs_ad_appl_all Aa
587: WHERE Apai.person_id IN ';
588:
682: v_message_name VARCHAR2(2000);
683:
684: BEGIN
685:
686: igs_ad_ps_appl_pkg.update_row (
687: x_rowid => l_get_ad_ps_appl_rec.row_id,
688: x_person_id => l_get_ad_ps_appl_rec.person_id,
689: x_admission_appl_number => l_get_ad_ps_appl_rec.admission_appl_number,
690: x_nominated_course_cd => l_get_ad_ps_appl_rec.nominated_course_cd,
724: IF c_get_pending_hist%FOUND THEN
725:
726: igs_ad_cancel_reconsider.g_cancel_recons_on := 'Y';
727:
728: igs_ad_ps_appl_inst_pkg.update_row (
729: X_ROWID => l_get_inst_dtls_rec.ROWID,
730: x_PERSON_ID => l_get_inst_dtls_rec.PERSON_ID,
731: x_ADMISSION_APPL_NUMBER => l_get_inst_dtls_rec.ADMISSION_APPL_NUMBER,
732: x_NOMINATED_COURSE_CD => l_get_inst_dtls_rec.NOMINATED_COURSE_CD,
975: || 'Sequence Number: ' || RPAD(l_get_fut_appl_inst.SEQUENCE_NUMBER,6,' '));
976: l_get_application_id := NULL;
977: /* End Apadegal - 4747281 */
978:
979: igs_ad_ps_appl_inst_pkg.update_row (
980: X_ROWID => l_get_fut_appl_inst.ROWID,
981: x_PERSON_ID => l_get_fut_appl_inst.PERSON_ID,
982: x_ADMISSION_APPL_NUMBER => l_get_fut_appl_inst.ADMISSION_APPL_NUMBER,
983: x_NOMINATED_COURSE_CD => l_get_fut_appl_inst.NOMINATED_COURSE_CD,
1203: l_app_name VARCHAR2(2000);
1204: v_message_name VARCHAR2(2000);
1205:
1206: BEGIN
1207: igs_ad_ps_appl_pkg.update_row (
1208: x_rowid => c_dyn_pig_check_rec.row_id,
1209: x_person_id => c_dyn_pig_check_rec.person_id,
1210: x_admission_appl_number => c_dyn_pig_check_rec.admission_appl_number,
1211: x_nominated_course_cd => c_dyn_pig_check_rec.nominated_course_cd,
1245: IF c_get_pending_hist%FOUND THEN
1246:
1247: igs_ad_cancel_reconsider.g_cancel_recons_on := 'Y';
1248:
1249: igs_ad_ps_appl_inst_pkg.update_row (
1250: X_ROWID => l_get_inst_dtls_rec.ROWID,
1251: x_PERSON_ID => l_get_inst_dtls_rec.PERSON_ID,
1252: x_ADMISSION_APPL_NUMBER => l_get_inst_dtls_rec.ADMISSION_APPL_NUMBER,
1253: x_NOMINATED_COURSE_CD => l_get_inst_dtls_rec.NOMINATED_COURSE_CD,
1534: RPAD(l_get_application_id,15,' ') || ' Program: ' || RPAD(c_pend_fut_rec.NOMINATED_COURSE_CD,6,' ')
1535: || 'Sequence Number: ' || RPAD(c_pend_fut_rec.SEQUENCE_NUMBER,6,' '));
1536: l_get_application_id := NULL;
1537: /* End Apadegal - 4747281 */
1538: igs_ad_ps_appl_inst_pkg.update_row (
1539: X_ROWID => c_pend_fut_rec.ROWID,
1540: x_PERSON_ID => c_pend_fut_rec.PERSON_ID,
1541: x_ADMISSION_APPL_NUMBER => c_pend_fut_rec.ADMISSION_APPL_NUMBER,
1542: x_NOMINATED_COURSE_CD => c_pend_fut_rec.NOMINATED_COURSE_CD,