3: /*#
4: * The Student Program Attempt Legacy Import process is a public API designed for
5: * use in populating rows with data during a system conversion. This API is also used
6: * by the Legacy Import Process for Enrollment and Records when importing rows from the
7: * IGS_EN_LGCY_SPA_INT interface table.
8: * @rep:scope public
9: * @rep:product IGS
10: * @rep:lifecycle active
11: * @rep:displayname Import Legacy Student Program Attempt
13: * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
14: */
15: -- irep annotations above.
16: TYPE SCA_RE_REC_TYPE IS RECORD(
17: person_number igs_en_lgcy_spa_int.person_number%TYPE,
18: program_cd igs_en_lgcy_spa_int.program_cd%TYPE,
19: version_number igs_en_lgcy_spa_int.version_number%TYPE,
20: cal_type igs_en_lgcy_spa_int.cal_type%TYPE,
21: location_cd igs_en_lgcy_spa_int.location_cd%TYPE,
14: */
15: -- irep annotations above.
16: TYPE SCA_RE_REC_TYPE IS RECORD(
17: person_number igs_en_lgcy_spa_int.person_number%TYPE,
18: program_cd igs_en_lgcy_spa_int.program_cd%TYPE,
19: version_number igs_en_lgcy_spa_int.version_number%TYPE,
20: cal_type igs_en_lgcy_spa_int.cal_type%TYPE,
21: location_cd igs_en_lgcy_spa_int.location_cd%TYPE,
22: attendance_mode igs_en_lgcy_spa_int.attendance_mode%TYPE,
15: -- irep annotations above.
16: TYPE SCA_RE_REC_TYPE IS RECORD(
17: person_number igs_en_lgcy_spa_int.person_number%TYPE,
18: program_cd igs_en_lgcy_spa_int.program_cd%TYPE,
19: version_number igs_en_lgcy_spa_int.version_number%TYPE,
20: cal_type igs_en_lgcy_spa_int.cal_type%TYPE,
21: location_cd igs_en_lgcy_spa_int.location_cd%TYPE,
22: attendance_mode igs_en_lgcy_spa_int.attendance_mode%TYPE,
23: attendance_type igs_en_lgcy_spa_int.attendance_type%TYPE,
16: TYPE SCA_RE_REC_TYPE IS RECORD(
17: person_number igs_en_lgcy_spa_int.person_number%TYPE,
18: program_cd igs_en_lgcy_spa_int.program_cd%TYPE,
19: version_number igs_en_lgcy_spa_int.version_number%TYPE,
20: cal_type igs_en_lgcy_spa_int.cal_type%TYPE,
21: location_cd igs_en_lgcy_spa_int.location_cd%TYPE,
22: attendance_mode igs_en_lgcy_spa_int.attendance_mode%TYPE,
23: attendance_type igs_en_lgcy_spa_int.attendance_type%TYPE,
24: student_confirmed_ind igs_en_lgcy_spa_int.student_confirmed_ind%TYPE,
17: person_number igs_en_lgcy_spa_int.person_number%TYPE,
18: program_cd igs_en_lgcy_spa_int.program_cd%TYPE,
19: version_number igs_en_lgcy_spa_int.version_number%TYPE,
20: cal_type igs_en_lgcy_spa_int.cal_type%TYPE,
21: location_cd igs_en_lgcy_spa_int.location_cd%TYPE,
22: attendance_mode igs_en_lgcy_spa_int.attendance_mode%TYPE,
23: attendance_type igs_en_lgcy_spa_int.attendance_type%TYPE,
24: student_confirmed_ind igs_en_lgcy_spa_int.student_confirmed_ind%TYPE,
25: commencement_dt igs_en_lgcy_spa_int.commencement_dt%TYPE,
18: program_cd igs_en_lgcy_spa_int.program_cd%TYPE,
19: version_number igs_en_lgcy_spa_int.version_number%TYPE,
20: cal_type igs_en_lgcy_spa_int.cal_type%TYPE,
21: location_cd igs_en_lgcy_spa_int.location_cd%TYPE,
22: attendance_mode igs_en_lgcy_spa_int.attendance_mode%TYPE,
23: attendance_type igs_en_lgcy_spa_int.attendance_type%TYPE,
24: student_confirmed_ind igs_en_lgcy_spa_int.student_confirmed_ind%TYPE,
25: commencement_dt igs_en_lgcy_spa_int.commencement_dt%TYPE,
26: primary_program_type igs_en_lgcy_spa_int.primary_program_type%TYPE,
19: version_number igs_en_lgcy_spa_int.version_number%TYPE,
20: cal_type igs_en_lgcy_spa_int.cal_type%TYPE,
21: location_cd igs_en_lgcy_spa_int.location_cd%TYPE,
22: attendance_mode igs_en_lgcy_spa_int.attendance_mode%TYPE,
23: attendance_type igs_en_lgcy_spa_int.attendance_type%TYPE,
24: student_confirmed_ind igs_en_lgcy_spa_int.student_confirmed_ind%TYPE,
25: commencement_dt igs_en_lgcy_spa_int.commencement_dt%TYPE,
26: primary_program_type igs_en_lgcy_spa_int.primary_program_type%TYPE,
27: primary_prog_type_source igs_en_lgcy_spa_int.primary_prog_type_source%TYPE,
20: cal_type igs_en_lgcy_spa_int.cal_type%TYPE,
21: location_cd igs_en_lgcy_spa_int.location_cd%TYPE,
22: attendance_mode igs_en_lgcy_spa_int.attendance_mode%TYPE,
23: attendance_type igs_en_lgcy_spa_int.attendance_type%TYPE,
24: student_confirmed_ind igs_en_lgcy_spa_int.student_confirmed_ind%TYPE,
25: commencement_dt igs_en_lgcy_spa_int.commencement_dt%TYPE,
26: primary_program_type igs_en_lgcy_spa_int.primary_program_type%TYPE,
27: primary_prog_type_source igs_en_lgcy_spa_int.primary_prog_type_source%TYPE,
28: key_program igs_en_lgcy_spa_int.key_program%TYPE,
21: location_cd igs_en_lgcy_spa_int.location_cd%TYPE,
22: attendance_mode igs_en_lgcy_spa_int.attendance_mode%TYPE,
23: attendance_type igs_en_lgcy_spa_int.attendance_type%TYPE,
24: student_confirmed_ind igs_en_lgcy_spa_int.student_confirmed_ind%TYPE,
25: commencement_dt igs_en_lgcy_spa_int.commencement_dt%TYPE,
26: primary_program_type igs_en_lgcy_spa_int.primary_program_type%TYPE,
27: primary_prog_type_source igs_en_lgcy_spa_int.primary_prog_type_source%TYPE,
28: key_program igs_en_lgcy_spa_int.key_program%TYPE,
29: provisional_ind igs_en_lgcy_spa_int.provisional_ind%TYPE,
22: attendance_mode igs_en_lgcy_spa_int.attendance_mode%TYPE,
23: attendance_type igs_en_lgcy_spa_int.attendance_type%TYPE,
24: student_confirmed_ind igs_en_lgcy_spa_int.student_confirmed_ind%TYPE,
25: commencement_dt igs_en_lgcy_spa_int.commencement_dt%TYPE,
26: primary_program_type igs_en_lgcy_spa_int.primary_program_type%TYPE,
27: primary_prog_type_source igs_en_lgcy_spa_int.primary_prog_type_source%TYPE,
28: key_program igs_en_lgcy_spa_int.key_program%TYPE,
29: provisional_ind igs_en_lgcy_spa_int.provisional_ind%TYPE,
30: discontinued_dt igs_en_lgcy_spa_int.discontinued_dt%TYPE,
23: attendance_type igs_en_lgcy_spa_int.attendance_type%TYPE,
24: student_confirmed_ind igs_en_lgcy_spa_int.student_confirmed_ind%TYPE,
25: commencement_dt igs_en_lgcy_spa_int.commencement_dt%TYPE,
26: primary_program_type igs_en_lgcy_spa_int.primary_program_type%TYPE,
27: primary_prog_type_source igs_en_lgcy_spa_int.primary_prog_type_source%TYPE,
28: key_program igs_en_lgcy_spa_int.key_program%TYPE,
29: provisional_ind igs_en_lgcy_spa_int.provisional_ind%TYPE,
30: discontinued_dt igs_en_lgcy_spa_int.discontinued_dt%TYPE,
31: discontinuation_reason_cd igs_en_lgcy_spa_int.discontinuation_reason_cd%TYPE,
24: student_confirmed_ind igs_en_lgcy_spa_int.student_confirmed_ind%TYPE,
25: commencement_dt igs_en_lgcy_spa_int.commencement_dt%TYPE,
26: primary_program_type igs_en_lgcy_spa_int.primary_program_type%TYPE,
27: primary_prog_type_source igs_en_lgcy_spa_int.primary_prog_type_source%TYPE,
28: key_program igs_en_lgcy_spa_int.key_program%TYPE,
29: provisional_ind igs_en_lgcy_spa_int.provisional_ind%TYPE,
30: discontinued_dt igs_en_lgcy_spa_int.discontinued_dt%TYPE,
31: discontinuation_reason_cd igs_en_lgcy_spa_int.discontinuation_reason_cd%TYPE,
32: lapsed_dt igs_en_lgcy_spa_int.lapsed_dt%TYPE,
25: commencement_dt igs_en_lgcy_spa_int.commencement_dt%TYPE,
26: primary_program_type igs_en_lgcy_spa_int.primary_program_type%TYPE,
27: primary_prog_type_source igs_en_lgcy_spa_int.primary_prog_type_source%TYPE,
28: key_program igs_en_lgcy_spa_int.key_program%TYPE,
29: provisional_ind igs_en_lgcy_spa_int.provisional_ind%TYPE,
30: discontinued_dt igs_en_lgcy_spa_int.discontinued_dt%TYPE,
31: discontinuation_reason_cd igs_en_lgcy_spa_int.discontinuation_reason_cd%TYPE,
32: lapsed_dt igs_en_lgcy_spa_int.lapsed_dt%TYPE,
33: funding_source igs_en_lgcy_spa_int.funding_source%TYPE,
26: primary_program_type igs_en_lgcy_spa_int.primary_program_type%TYPE,
27: primary_prog_type_source igs_en_lgcy_spa_int.primary_prog_type_source%TYPE,
28: key_program igs_en_lgcy_spa_int.key_program%TYPE,
29: provisional_ind igs_en_lgcy_spa_int.provisional_ind%TYPE,
30: discontinued_dt igs_en_lgcy_spa_int.discontinued_dt%TYPE,
31: discontinuation_reason_cd igs_en_lgcy_spa_int.discontinuation_reason_cd%TYPE,
32: lapsed_dt igs_en_lgcy_spa_int.lapsed_dt%TYPE,
33: funding_source igs_en_lgcy_spa_int.funding_source%TYPE,
34: exam_location_cd igs_en_lgcy_spa_int.exam_location_cd%TYPE,
27: primary_prog_type_source igs_en_lgcy_spa_int.primary_prog_type_source%TYPE,
28: key_program igs_en_lgcy_spa_int.key_program%TYPE,
29: provisional_ind igs_en_lgcy_spa_int.provisional_ind%TYPE,
30: discontinued_dt igs_en_lgcy_spa_int.discontinued_dt%TYPE,
31: discontinuation_reason_cd igs_en_lgcy_spa_int.discontinuation_reason_cd%TYPE,
32: lapsed_dt igs_en_lgcy_spa_int.lapsed_dt%TYPE,
33: funding_source igs_en_lgcy_spa_int.funding_source%TYPE,
34: exam_location_cd igs_en_lgcy_spa_int.exam_location_cd%TYPE,
35: nominated_completion_yr igs_en_lgcy_spa_int.nominated_completion_yr%TYPE,
28: key_program igs_en_lgcy_spa_int.key_program%TYPE,
29: provisional_ind igs_en_lgcy_spa_int.provisional_ind%TYPE,
30: discontinued_dt igs_en_lgcy_spa_int.discontinued_dt%TYPE,
31: discontinuation_reason_cd igs_en_lgcy_spa_int.discontinuation_reason_cd%TYPE,
32: lapsed_dt igs_en_lgcy_spa_int.lapsed_dt%TYPE,
33: funding_source igs_en_lgcy_spa_int.funding_source%TYPE,
34: exam_location_cd igs_en_lgcy_spa_int.exam_location_cd%TYPE,
35: nominated_completion_yr igs_en_lgcy_spa_int.nominated_completion_yr%TYPE,
36: nominated_completion_perd igs_en_lgcy_spa_int.nominated_completion_perd%TYPE,
29: provisional_ind igs_en_lgcy_spa_int.provisional_ind%TYPE,
30: discontinued_dt igs_en_lgcy_spa_int.discontinued_dt%TYPE,
31: discontinuation_reason_cd igs_en_lgcy_spa_int.discontinuation_reason_cd%TYPE,
32: lapsed_dt igs_en_lgcy_spa_int.lapsed_dt%TYPE,
33: funding_source igs_en_lgcy_spa_int.funding_source%TYPE,
34: exam_location_cd igs_en_lgcy_spa_int.exam_location_cd%TYPE,
35: nominated_completion_yr igs_en_lgcy_spa_int.nominated_completion_yr%TYPE,
36: nominated_completion_perd igs_en_lgcy_spa_int.nominated_completion_perd%TYPE,
37: rule_check_ind igs_en_lgcy_spa_int.rule_check_ind%TYPE,
30: discontinued_dt igs_en_lgcy_spa_int.discontinued_dt%TYPE,
31: discontinuation_reason_cd igs_en_lgcy_spa_int.discontinuation_reason_cd%TYPE,
32: lapsed_dt igs_en_lgcy_spa_int.lapsed_dt%TYPE,
33: funding_source igs_en_lgcy_spa_int.funding_source%TYPE,
34: exam_location_cd igs_en_lgcy_spa_int.exam_location_cd%TYPE,
35: nominated_completion_yr igs_en_lgcy_spa_int.nominated_completion_yr%TYPE,
36: nominated_completion_perd igs_en_lgcy_spa_int.nominated_completion_perd%TYPE,
37: rule_check_ind igs_en_lgcy_spa_int.rule_check_ind%TYPE,
38: waive_option_check_ind igs_en_lgcy_spa_int.waive_option_check_ind%TYPE,
31: discontinuation_reason_cd igs_en_lgcy_spa_int.discontinuation_reason_cd%TYPE,
32: lapsed_dt igs_en_lgcy_spa_int.lapsed_dt%TYPE,
33: funding_source igs_en_lgcy_spa_int.funding_source%TYPE,
34: exam_location_cd igs_en_lgcy_spa_int.exam_location_cd%TYPE,
35: nominated_completion_yr igs_en_lgcy_spa_int.nominated_completion_yr%TYPE,
36: nominated_completion_perd igs_en_lgcy_spa_int.nominated_completion_perd%TYPE,
37: rule_check_ind igs_en_lgcy_spa_int.rule_check_ind%TYPE,
38: waive_option_check_ind igs_en_lgcy_spa_int.waive_option_check_ind%TYPE,
39: last_rule_check_dt igs_en_lgcy_spa_int.last_rule_check_dt%TYPE,
32: lapsed_dt igs_en_lgcy_spa_int.lapsed_dt%TYPE,
33: funding_source igs_en_lgcy_spa_int.funding_source%TYPE,
34: exam_location_cd igs_en_lgcy_spa_int.exam_location_cd%TYPE,
35: nominated_completion_yr igs_en_lgcy_spa_int.nominated_completion_yr%TYPE,
36: nominated_completion_perd igs_en_lgcy_spa_int.nominated_completion_perd%TYPE,
37: rule_check_ind igs_en_lgcy_spa_int.rule_check_ind%TYPE,
38: waive_option_check_ind igs_en_lgcy_spa_int.waive_option_check_ind%TYPE,
39: last_rule_check_dt igs_en_lgcy_spa_int.last_rule_check_dt%TYPE,
40: publish_outcomes_ind igs_en_lgcy_spa_int.publish_outcomes_ind%TYPE,
33: funding_source igs_en_lgcy_spa_int.funding_source%TYPE,
34: exam_location_cd igs_en_lgcy_spa_int.exam_location_cd%TYPE,
35: nominated_completion_yr igs_en_lgcy_spa_int.nominated_completion_yr%TYPE,
36: nominated_completion_perd igs_en_lgcy_spa_int.nominated_completion_perd%TYPE,
37: rule_check_ind igs_en_lgcy_spa_int.rule_check_ind%TYPE,
38: waive_option_check_ind igs_en_lgcy_spa_int.waive_option_check_ind%TYPE,
39: last_rule_check_dt igs_en_lgcy_spa_int.last_rule_check_dt%TYPE,
40: publish_outcomes_ind igs_en_lgcy_spa_int.publish_outcomes_ind%TYPE,
41: course_rqrmnt_complete_ind igs_en_lgcy_spa_int.course_rqrmnt_complete_ind%TYPE,
34: exam_location_cd igs_en_lgcy_spa_int.exam_location_cd%TYPE,
35: nominated_completion_yr igs_en_lgcy_spa_int.nominated_completion_yr%TYPE,
36: nominated_completion_perd igs_en_lgcy_spa_int.nominated_completion_perd%TYPE,
37: rule_check_ind igs_en_lgcy_spa_int.rule_check_ind%TYPE,
38: waive_option_check_ind igs_en_lgcy_spa_int.waive_option_check_ind%TYPE,
39: last_rule_check_dt igs_en_lgcy_spa_int.last_rule_check_dt%TYPE,
40: publish_outcomes_ind igs_en_lgcy_spa_int.publish_outcomes_ind%TYPE,
41: course_rqrmnt_complete_ind igs_en_lgcy_spa_int.course_rqrmnt_complete_ind%TYPE,
42: course_rqrmnts_complete_dt igs_en_lgcy_spa_int.course_rqrmnts_complete_dt%TYPE,
35: nominated_completion_yr igs_en_lgcy_spa_int.nominated_completion_yr%TYPE,
36: nominated_completion_perd igs_en_lgcy_spa_int.nominated_completion_perd%TYPE,
37: rule_check_ind igs_en_lgcy_spa_int.rule_check_ind%TYPE,
38: waive_option_check_ind igs_en_lgcy_spa_int.waive_option_check_ind%TYPE,
39: last_rule_check_dt igs_en_lgcy_spa_int.last_rule_check_dt%TYPE,
40: publish_outcomes_ind igs_en_lgcy_spa_int.publish_outcomes_ind%TYPE,
41: course_rqrmnt_complete_ind igs_en_lgcy_spa_int.course_rqrmnt_complete_ind%TYPE,
42: course_rqrmnts_complete_dt igs_en_lgcy_spa_int.course_rqrmnts_complete_dt%TYPE,
43: s_completed_source_type igs_en_lgcy_spa_int.s_completed_source_type%TYPE,
36: nominated_completion_perd igs_en_lgcy_spa_int.nominated_completion_perd%TYPE,
37: rule_check_ind igs_en_lgcy_spa_int.rule_check_ind%TYPE,
38: waive_option_check_ind igs_en_lgcy_spa_int.waive_option_check_ind%TYPE,
39: last_rule_check_dt igs_en_lgcy_spa_int.last_rule_check_dt%TYPE,
40: publish_outcomes_ind igs_en_lgcy_spa_int.publish_outcomes_ind%TYPE,
41: course_rqrmnt_complete_ind igs_en_lgcy_spa_int.course_rqrmnt_complete_ind%TYPE,
42: course_rqrmnts_complete_dt igs_en_lgcy_spa_int.course_rqrmnts_complete_dt%TYPE,
43: s_completed_source_type igs_en_lgcy_spa_int.s_completed_source_type%TYPE,
44: advanced_standing_ind igs_en_lgcy_spa_int.advanced_standing_ind%TYPE,
37: rule_check_ind igs_en_lgcy_spa_int.rule_check_ind%TYPE,
38: waive_option_check_ind igs_en_lgcy_spa_int.waive_option_check_ind%TYPE,
39: last_rule_check_dt igs_en_lgcy_spa_int.last_rule_check_dt%TYPE,
40: publish_outcomes_ind igs_en_lgcy_spa_int.publish_outcomes_ind%TYPE,
41: course_rqrmnt_complete_ind igs_en_lgcy_spa_int.course_rqrmnt_complete_ind%TYPE,
42: course_rqrmnts_complete_dt igs_en_lgcy_spa_int.course_rqrmnts_complete_dt%TYPE,
43: s_completed_source_type igs_en_lgcy_spa_int.s_completed_source_type%TYPE,
44: advanced_standing_ind igs_en_lgcy_spa_int.advanced_standing_ind%TYPE,
45: fee_cat igs_en_lgcy_spa_int.fee_cat%TYPE,
38: waive_option_check_ind igs_en_lgcy_spa_int.waive_option_check_ind%TYPE,
39: last_rule_check_dt igs_en_lgcy_spa_int.last_rule_check_dt%TYPE,
40: publish_outcomes_ind igs_en_lgcy_spa_int.publish_outcomes_ind%TYPE,
41: course_rqrmnt_complete_ind igs_en_lgcy_spa_int.course_rqrmnt_complete_ind%TYPE,
42: course_rqrmnts_complete_dt igs_en_lgcy_spa_int.course_rqrmnts_complete_dt%TYPE,
43: s_completed_source_type igs_en_lgcy_spa_int.s_completed_source_type%TYPE,
44: advanced_standing_ind igs_en_lgcy_spa_int.advanced_standing_ind%TYPE,
45: fee_cat igs_en_lgcy_spa_int.fee_cat%TYPE,
46: correspondence_cat igs_en_lgcy_spa_int.correspondence_cat%TYPE,
39: last_rule_check_dt igs_en_lgcy_spa_int.last_rule_check_dt%TYPE,
40: publish_outcomes_ind igs_en_lgcy_spa_int.publish_outcomes_ind%TYPE,
41: course_rqrmnt_complete_ind igs_en_lgcy_spa_int.course_rqrmnt_complete_ind%TYPE,
42: course_rqrmnts_complete_dt igs_en_lgcy_spa_int.course_rqrmnts_complete_dt%TYPE,
43: s_completed_source_type igs_en_lgcy_spa_int.s_completed_source_type%TYPE,
44: advanced_standing_ind igs_en_lgcy_spa_int.advanced_standing_ind%TYPE,
45: fee_cat igs_en_lgcy_spa_int.fee_cat%TYPE,
46: correspondence_cat igs_en_lgcy_spa_int.correspondence_cat%TYPE,
47: self_help_group_ind igs_en_lgcy_spa_int.self_help_group_ind%TYPE,
40: publish_outcomes_ind igs_en_lgcy_spa_int.publish_outcomes_ind%TYPE,
41: course_rqrmnt_complete_ind igs_en_lgcy_spa_int.course_rqrmnt_complete_ind%TYPE,
42: course_rqrmnts_complete_dt igs_en_lgcy_spa_int.course_rqrmnts_complete_dt%TYPE,
43: s_completed_source_type igs_en_lgcy_spa_int.s_completed_source_type%TYPE,
44: advanced_standing_ind igs_en_lgcy_spa_int.advanced_standing_ind%TYPE,
45: fee_cat igs_en_lgcy_spa_int.fee_cat%TYPE,
46: correspondence_cat igs_en_lgcy_spa_int.correspondence_cat%TYPE,
47: self_help_group_ind igs_en_lgcy_spa_int.self_help_group_ind%TYPE,
48: adm_admission_appl_number igs_en_lgcy_spa_int.adm_admission_appl_number%TYPE,
41: course_rqrmnt_complete_ind igs_en_lgcy_spa_int.course_rqrmnt_complete_ind%TYPE,
42: course_rqrmnts_complete_dt igs_en_lgcy_spa_int.course_rqrmnts_complete_dt%TYPE,
43: s_completed_source_type igs_en_lgcy_spa_int.s_completed_source_type%TYPE,
44: advanced_standing_ind igs_en_lgcy_spa_int.advanced_standing_ind%TYPE,
45: fee_cat igs_en_lgcy_spa_int.fee_cat%TYPE,
46: correspondence_cat igs_en_lgcy_spa_int.correspondence_cat%TYPE,
47: self_help_group_ind igs_en_lgcy_spa_int.self_help_group_ind%TYPE,
48: adm_admission_appl_number igs_en_lgcy_spa_int.adm_admission_appl_number%TYPE,
49: adm_nominated_course_cd igs_en_lgcy_spa_int.adm_nominated_course_cd%TYPE,
42: course_rqrmnts_complete_dt igs_en_lgcy_spa_int.course_rqrmnts_complete_dt%TYPE,
43: s_completed_source_type igs_en_lgcy_spa_int.s_completed_source_type%TYPE,
44: advanced_standing_ind igs_en_lgcy_spa_int.advanced_standing_ind%TYPE,
45: fee_cat igs_en_lgcy_spa_int.fee_cat%TYPE,
46: correspondence_cat igs_en_lgcy_spa_int.correspondence_cat%TYPE,
47: self_help_group_ind igs_en_lgcy_spa_int.self_help_group_ind%TYPE,
48: adm_admission_appl_number igs_en_lgcy_spa_int.adm_admission_appl_number%TYPE,
49: adm_nominated_course_cd igs_en_lgcy_spa_int.adm_nominated_course_cd%TYPE,
50: adm_sequence_number igs_en_lgcy_spa_int.adm_sequence_number%TYPE,
43: s_completed_source_type igs_en_lgcy_spa_int.s_completed_source_type%TYPE,
44: advanced_standing_ind igs_en_lgcy_spa_int.advanced_standing_ind%TYPE,
45: fee_cat igs_en_lgcy_spa_int.fee_cat%TYPE,
46: correspondence_cat igs_en_lgcy_spa_int.correspondence_cat%TYPE,
47: self_help_group_ind igs_en_lgcy_spa_int.self_help_group_ind%TYPE,
48: adm_admission_appl_number igs_en_lgcy_spa_int.adm_admission_appl_number%TYPE,
49: adm_nominated_course_cd igs_en_lgcy_spa_int.adm_nominated_course_cd%TYPE,
50: adm_sequence_number igs_en_lgcy_spa_int.adm_sequence_number%TYPE,
51: class_standing_override igs_en_lgcy_spa_int.class_standing_override%TYPE,
44: advanced_standing_ind igs_en_lgcy_spa_int.advanced_standing_ind%TYPE,
45: fee_cat igs_en_lgcy_spa_int.fee_cat%TYPE,
46: correspondence_cat igs_en_lgcy_spa_int.correspondence_cat%TYPE,
47: self_help_group_ind igs_en_lgcy_spa_int.self_help_group_ind%TYPE,
48: adm_admission_appl_number igs_en_lgcy_spa_int.adm_admission_appl_number%TYPE,
49: adm_nominated_course_cd igs_en_lgcy_spa_int.adm_nominated_course_cd%TYPE,
50: adm_sequence_number igs_en_lgcy_spa_int.adm_sequence_number%TYPE,
51: class_standing_override igs_en_lgcy_spa_int.class_standing_override%TYPE,
52: catalog_cal_alternate_code igs_en_lgcy_spa_int.catalog_cal_alternate_code%TYPE,
45: fee_cat igs_en_lgcy_spa_int.fee_cat%TYPE,
46: correspondence_cat igs_en_lgcy_spa_int.correspondence_cat%TYPE,
47: self_help_group_ind igs_en_lgcy_spa_int.self_help_group_ind%TYPE,
48: adm_admission_appl_number igs_en_lgcy_spa_int.adm_admission_appl_number%TYPE,
49: adm_nominated_course_cd igs_en_lgcy_spa_int.adm_nominated_course_cd%TYPE,
50: adm_sequence_number igs_en_lgcy_spa_int.adm_sequence_number%TYPE,
51: class_standing_override igs_en_lgcy_spa_int.class_standing_override%TYPE,
52: catalog_cal_alternate_code igs_en_lgcy_spa_int.catalog_cal_alternate_code%TYPE,
53: override_cmpl_dt igs_en_lgcy_spa_int.override_cmpl_dt%TYPE,
46: correspondence_cat igs_en_lgcy_spa_int.correspondence_cat%TYPE,
47: self_help_group_ind igs_en_lgcy_spa_int.self_help_group_ind%TYPE,
48: adm_admission_appl_number igs_en_lgcy_spa_int.adm_admission_appl_number%TYPE,
49: adm_nominated_course_cd igs_en_lgcy_spa_int.adm_nominated_course_cd%TYPE,
50: adm_sequence_number igs_en_lgcy_spa_int.adm_sequence_number%TYPE,
51: class_standing_override igs_en_lgcy_spa_int.class_standing_override%TYPE,
52: catalog_cal_alternate_code igs_en_lgcy_spa_int.catalog_cal_alternate_code%TYPE,
53: override_cmpl_dt igs_en_lgcy_spa_int.override_cmpl_dt%TYPE,
54: manual_ovr_cmpl_dt_ind igs_en_lgcy_spa_int.manual_ovr_cmpl_dt_ind%TYPE,
47: self_help_group_ind igs_en_lgcy_spa_int.self_help_group_ind%TYPE,
48: adm_admission_appl_number igs_en_lgcy_spa_int.adm_admission_appl_number%TYPE,
49: adm_nominated_course_cd igs_en_lgcy_spa_int.adm_nominated_course_cd%TYPE,
50: adm_sequence_number igs_en_lgcy_spa_int.adm_sequence_number%TYPE,
51: class_standing_override igs_en_lgcy_spa_int.class_standing_override%TYPE,
52: catalog_cal_alternate_code igs_en_lgcy_spa_int.catalog_cal_alternate_code%TYPE,
53: override_cmpl_dt igs_en_lgcy_spa_int.override_cmpl_dt%TYPE,
54: manual_ovr_cmpl_dt_ind igs_en_lgcy_spa_int.manual_ovr_cmpl_dt_ind%TYPE,
55: attribute_category igs_en_lgcy_spa_int.attribute_category%TYPE,
48: adm_admission_appl_number igs_en_lgcy_spa_int.adm_admission_appl_number%TYPE,
49: adm_nominated_course_cd igs_en_lgcy_spa_int.adm_nominated_course_cd%TYPE,
50: adm_sequence_number igs_en_lgcy_spa_int.adm_sequence_number%TYPE,
51: class_standing_override igs_en_lgcy_spa_int.class_standing_override%TYPE,
52: catalog_cal_alternate_code igs_en_lgcy_spa_int.catalog_cal_alternate_code%TYPE,
53: override_cmpl_dt igs_en_lgcy_spa_int.override_cmpl_dt%TYPE,
54: manual_ovr_cmpl_dt_ind igs_en_lgcy_spa_int.manual_ovr_cmpl_dt_ind%TYPE,
55: attribute_category igs_en_lgcy_spa_int.attribute_category%TYPE,
56: attribute1 igs_en_lgcy_spa_int.attribute1%TYPE,
49: adm_nominated_course_cd igs_en_lgcy_spa_int.adm_nominated_course_cd%TYPE,
50: adm_sequence_number igs_en_lgcy_spa_int.adm_sequence_number%TYPE,
51: class_standing_override igs_en_lgcy_spa_int.class_standing_override%TYPE,
52: catalog_cal_alternate_code igs_en_lgcy_spa_int.catalog_cal_alternate_code%TYPE,
53: override_cmpl_dt igs_en_lgcy_spa_int.override_cmpl_dt%TYPE,
54: manual_ovr_cmpl_dt_ind igs_en_lgcy_spa_int.manual_ovr_cmpl_dt_ind%TYPE,
55: attribute_category igs_en_lgcy_spa_int.attribute_category%TYPE,
56: attribute1 igs_en_lgcy_spa_int.attribute1%TYPE,
57: attribute2 igs_en_lgcy_spa_int.attribute2%TYPE,
50: adm_sequence_number igs_en_lgcy_spa_int.adm_sequence_number%TYPE,
51: class_standing_override igs_en_lgcy_spa_int.class_standing_override%TYPE,
52: catalog_cal_alternate_code igs_en_lgcy_spa_int.catalog_cal_alternate_code%TYPE,
53: override_cmpl_dt igs_en_lgcy_spa_int.override_cmpl_dt%TYPE,
54: manual_ovr_cmpl_dt_ind igs_en_lgcy_spa_int.manual_ovr_cmpl_dt_ind%TYPE,
55: attribute_category igs_en_lgcy_spa_int.attribute_category%TYPE,
56: attribute1 igs_en_lgcy_spa_int.attribute1%TYPE,
57: attribute2 igs_en_lgcy_spa_int.attribute2%TYPE,
58: attribute3 igs_en_lgcy_spa_int.attribute3%TYPE,
51: class_standing_override igs_en_lgcy_spa_int.class_standing_override%TYPE,
52: catalog_cal_alternate_code igs_en_lgcy_spa_int.catalog_cal_alternate_code%TYPE,
53: override_cmpl_dt igs_en_lgcy_spa_int.override_cmpl_dt%TYPE,
54: manual_ovr_cmpl_dt_ind igs_en_lgcy_spa_int.manual_ovr_cmpl_dt_ind%TYPE,
55: attribute_category igs_en_lgcy_spa_int.attribute_category%TYPE,
56: attribute1 igs_en_lgcy_spa_int.attribute1%TYPE,
57: attribute2 igs_en_lgcy_spa_int.attribute2%TYPE,
58: attribute3 igs_en_lgcy_spa_int.attribute3%TYPE,
59: attribute4 igs_en_lgcy_spa_int.attribute4%TYPE,
52: catalog_cal_alternate_code igs_en_lgcy_spa_int.catalog_cal_alternate_code%TYPE,
53: override_cmpl_dt igs_en_lgcy_spa_int.override_cmpl_dt%TYPE,
54: manual_ovr_cmpl_dt_ind igs_en_lgcy_spa_int.manual_ovr_cmpl_dt_ind%TYPE,
55: attribute_category igs_en_lgcy_spa_int.attribute_category%TYPE,
56: attribute1 igs_en_lgcy_spa_int.attribute1%TYPE,
57: attribute2 igs_en_lgcy_spa_int.attribute2%TYPE,
58: attribute3 igs_en_lgcy_spa_int.attribute3%TYPE,
59: attribute4 igs_en_lgcy_spa_int.attribute4%TYPE,
60: attribute5 igs_en_lgcy_spa_int.attribute5%TYPE,
53: override_cmpl_dt igs_en_lgcy_spa_int.override_cmpl_dt%TYPE,
54: manual_ovr_cmpl_dt_ind igs_en_lgcy_spa_int.manual_ovr_cmpl_dt_ind%TYPE,
55: attribute_category igs_en_lgcy_spa_int.attribute_category%TYPE,
56: attribute1 igs_en_lgcy_spa_int.attribute1%TYPE,
57: attribute2 igs_en_lgcy_spa_int.attribute2%TYPE,
58: attribute3 igs_en_lgcy_spa_int.attribute3%TYPE,
59: attribute4 igs_en_lgcy_spa_int.attribute4%TYPE,
60: attribute5 igs_en_lgcy_spa_int.attribute5%TYPE,
61: attribute6 igs_en_lgcy_spa_int.attribute6%TYPE,
54: manual_ovr_cmpl_dt_ind igs_en_lgcy_spa_int.manual_ovr_cmpl_dt_ind%TYPE,
55: attribute_category igs_en_lgcy_spa_int.attribute_category%TYPE,
56: attribute1 igs_en_lgcy_spa_int.attribute1%TYPE,
57: attribute2 igs_en_lgcy_spa_int.attribute2%TYPE,
58: attribute3 igs_en_lgcy_spa_int.attribute3%TYPE,
59: attribute4 igs_en_lgcy_spa_int.attribute4%TYPE,
60: attribute5 igs_en_lgcy_spa_int.attribute5%TYPE,
61: attribute6 igs_en_lgcy_spa_int.attribute6%TYPE,
62: attribute7 igs_en_lgcy_spa_int.attribute7%TYPE,
55: attribute_category igs_en_lgcy_spa_int.attribute_category%TYPE,
56: attribute1 igs_en_lgcy_spa_int.attribute1%TYPE,
57: attribute2 igs_en_lgcy_spa_int.attribute2%TYPE,
58: attribute3 igs_en_lgcy_spa_int.attribute3%TYPE,
59: attribute4 igs_en_lgcy_spa_int.attribute4%TYPE,
60: attribute5 igs_en_lgcy_spa_int.attribute5%TYPE,
61: attribute6 igs_en_lgcy_spa_int.attribute6%TYPE,
62: attribute7 igs_en_lgcy_spa_int.attribute7%TYPE,
63: attribute8 igs_en_lgcy_spa_int.attribute8%TYPE,
56: attribute1 igs_en_lgcy_spa_int.attribute1%TYPE,
57: attribute2 igs_en_lgcy_spa_int.attribute2%TYPE,
58: attribute3 igs_en_lgcy_spa_int.attribute3%TYPE,
59: attribute4 igs_en_lgcy_spa_int.attribute4%TYPE,
60: attribute5 igs_en_lgcy_spa_int.attribute5%TYPE,
61: attribute6 igs_en_lgcy_spa_int.attribute6%TYPE,
62: attribute7 igs_en_lgcy_spa_int.attribute7%TYPE,
63: attribute8 igs_en_lgcy_spa_int.attribute8%TYPE,
64: attribute9 igs_en_lgcy_spa_int.attribute9%TYPE,
57: attribute2 igs_en_lgcy_spa_int.attribute2%TYPE,
58: attribute3 igs_en_lgcy_spa_int.attribute3%TYPE,
59: attribute4 igs_en_lgcy_spa_int.attribute4%TYPE,
60: attribute5 igs_en_lgcy_spa_int.attribute5%TYPE,
61: attribute6 igs_en_lgcy_spa_int.attribute6%TYPE,
62: attribute7 igs_en_lgcy_spa_int.attribute7%TYPE,
63: attribute8 igs_en_lgcy_spa_int.attribute8%TYPE,
64: attribute9 igs_en_lgcy_spa_int.attribute9%TYPE,
65: attribute10 igs_en_lgcy_spa_int.attribute10%TYPE,
58: attribute3 igs_en_lgcy_spa_int.attribute3%TYPE,
59: attribute4 igs_en_lgcy_spa_int.attribute4%TYPE,
60: attribute5 igs_en_lgcy_spa_int.attribute5%TYPE,
61: attribute6 igs_en_lgcy_spa_int.attribute6%TYPE,
62: attribute7 igs_en_lgcy_spa_int.attribute7%TYPE,
63: attribute8 igs_en_lgcy_spa_int.attribute8%TYPE,
64: attribute9 igs_en_lgcy_spa_int.attribute9%TYPE,
65: attribute10 igs_en_lgcy_spa_int.attribute10%TYPE,
66: attribute11 igs_en_lgcy_spa_int.attribute11%TYPE,
59: attribute4 igs_en_lgcy_spa_int.attribute4%TYPE,
60: attribute5 igs_en_lgcy_spa_int.attribute5%TYPE,
61: attribute6 igs_en_lgcy_spa_int.attribute6%TYPE,
62: attribute7 igs_en_lgcy_spa_int.attribute7%TYPE,
63: attribute8 igs_en_lgcy_spa_int.attribute8%TYPE,
64: attribute9 igs_en_lgcy_spa_int.attribute9%TYPE,
65: attribute10 igs_en_lgcy_spa_int.attribute10%TYPE,
66: attribute11 igs_en_lgcy_spa_int.attribute11%TYPE,
67: attribute12 igs_en_lgcy_spa_int.attribute12%TYPE,
60: attribute5 igs_en_lgcy_spa_int.attribute5%TYPE,
61: attribute6 igs_en_lgcy_spa_int.attribute6%TYPE,
62: attribute7 igs_en_lgcy_spa_int.attribute7%TYPE,
63: attribute8 igs_en_lgcy_spa_int.attribute8%TYPE,
64: attribute9 igs_en_lgcy_spa_int.attribute9%TYPE,
65: attribute10 igs_en_lgcy_spa_int.attribute10%TYPE,
66: attribute11 igs_en_lgcy_spa_int.attribute11%TYPE,
67: attribute12 igs_en_lgcy_spa_int.attribute12%TYPE,
68: attribute13 igs_en_lgcy_spa_int.attribute13%TYPE,
61: attribute6 igs_en_lgcy_spa_int.attribute6%TYPE,
62: attribute7 igs_en_lgcy_spa_int.attribute7%TYPE,
63: attribute8 igs_en_lgcy_spa_int.attribute8%TYPE,
64: attribute9 igs_en_lgcy_spa_int.attribute9%TYPE,
65: attribute10 igs_en_lgcy_spa_int.attribute10%TYPE,
66: attribute11 igs_en_lgcy_spa_int.attribute11%TYPE,
67: attribute12 igs_en_lgcy_spa_int.attribute12%TYPE,
68: attribute13 igs_en_lgcy_spa_int.attribute13%TYPE,
69: attribute14 igs_en_lgcy_spa_int.attribute14%TYPE,
62: attribute7 igs_en_lgcy_spa_int.attribute7%TYPE,
63: attribute8 igs_en_lgcy_spa_int.attribute8%TYPE,
64: attribute9 igs_en_lgcy_spa_int.attribute9%TYPE,
65: attribute10 igs_en_lgcy_spa_int.attribute10%TYPE,
66: attribute11 igs_en_lgcy_spa_int.attribute11%TYPE,
67: attribute12 igs_en_lgcy_spa_int.attribute12%TYPE,
68: attribute13 igs_en_lgcy_spa_int.attribute13%TYPE,
69: attribute14 igs_en_lgcy_spa_int.attribute14%TYPE,
70: attribute15 igs_en_lgcy_spa_int.attribute15%TYPE,
63: attribute8 igs_en_lgcy_spa_int.attribute8%TYPE,
64: attribute9 igs_en_lgcy_spa_int.attribute9%TYPE,
65: attribute10 igs_en_lgcy_spa_int.attribute10%TYPE,
66: attribute11 igs_en_lgcy_spa_int.attribute11%TYPE,
67: attribute12 igs_en_lgcy_spa_int.attribute12%TYPE,
68: attribute13 igs_en_lgcy_spa_int.attribute13%TYPE,
69: attribute14 igs_en_lgcy_spa_int.attribute14%TYPE,
70: attribute15 igs_en_lgcy_spa_int.attribute15%TYPE,
71: attribute16 igs_en_lgcy_spa_int.attribute16%TYPE,
64: attribute9 igs_en_lgcy_spa_int.attribute9%TYPE,
65: attribute10 igs_en_lgcy_spa_int.attribute10%TYPE,
66: attribute11 igs_en_lgcy_spa_int.attribute11%TYPE,
67: attribute12 igs_en_lgcy_spa_int.attribute12%TYPE,
68: attribute13 igs_en_lgcy_spa_int.attribute13%TYPE,
69: attribute14 igs_en_lgcy_spa_int.attribute14%TYPE,
70: attribute15 igs_en_lgcy_spa_int.attribute15%TYPE,
71: attribute16 igs_en_lgcy_spa_int.attribute16%TYPE,
72: attribute17 igs_en_lgcy_spa_int.attribute17%TYPE,
65: attribute10 igs_en_lgcy_spa_int.attribute10%TYPE,
66: attribute11 igs_en_lgcy_spa_int.attribute11%TYPE,
67: attribute12 igs_en_lgcy_spa_int.attribute12%TYPE,
68: attribute13 igs_en_lgcy_spa_int.attribute13%TYPE,
69: attribute14 igs_en_lgcy_spa_int.attribute14%TYPE,
70: attribute15 igs_en_lgcy_spa_int.attribute15%TYPE,
71: attribute16 igs_en_lgcy_spa_int.attribute16%TYPE,
72: attribute17 igs_en_lgcy_spa_int.attribute17%TYPE,
73: attribute18 igs_en_lgcy_spa_int.attribute18%TYPE,
66: attribute11 igs_en_lgcy_spa_int.attribute11%TYPE,
67: attribute12 igs_en_lgcy_spa_int.attribute12%TYPE,
68: attribute13 igs_en_lgcy_spa_int.attribute13%TYPE,
69: attribute14 igs_en_lgcy_spa_int.attribute14%TYPE,
70: attribute15 igs_en_lgcy_spa_int.attribute15%TYPE,
71: attribute16 igs_en_lgcy_spa_int.attribute16%TYPE,
72: attribute17 igs_en_lgcy_spa_int.attribute17%TYPE,
73: attribute18 igs_en_lgcy_spa_int.attribute18%TYPE,
74: attribute19 igs_en_lgcy_spa_int.attribute19%TYPE,
67: attribute12 igs_en_lgcy_spa_int.attribute12%TYPE,
68: attribute13 igs_en_lgcy_spa_int.attribute13%TYPE,
69: attribute14 igs_en_lgcy_spa_int.attribute14%TYPE,
70: attribute15 igs_en_lgcy_spa_int.attribute15%TYPE,
71: attribute16 igs_en_lgcy_spa_int.attribute16%TYPE,
72: attribute17 igs_en_lgcy_spa_int.attribute17%TYPE,
73: attribute18 igs_en_lgcy_spa_int.attribute18%TYPE,
74: attribute19 igs_en_lgcy_spa_int.attribute19%TYPE,
75: attribute20 igs_en_lgcy_spa_int.attribute20%TYPE,
68: attribute13 igs_en_lgcy_spa_int.attribute13%TYPE,
69: attribute14 igs_en_lgcy_spa_int.attribute14%TYPE,
70: attribute15 igs_en_lgcy_spa_int.attribute15%TYPE,
71: attribute16 igs_en_lgcy_spa_int.attribute16%TYPE,
72: attribute17 igs_en_lgcy_spa_int.attribute17%TYPE,
73: attribute18 igs_en_lgcy_spa_int.attribute18%TYPE,
74: attribute19 igs_en_lgcy_spa_int.attribute19%TYPE,
75: attribute20 igs_en_lgcy_spa_int.attribute20%TYPE,
76: re_attendance_percentage igs_en_lgcy_spa_int.re_attendance_percentage%TYPE,
69: attribute14 igs_en_lgcy_spa_int.attribute14%TYPE,
70: attribute15 igs_en_lgcy_spa_int.attribute15%TYPE,
71: attribute16 igs_en_lgcy_spa_int.attribute16%TYPE,
72: attribute17 igs_en_lgcy_spa_int.attribute17%TYPE,
73: attribute18 igs_en_lgcy_spa_int.attribute18%TYPE,
74: attribute19 igs_en_lgcy_spa_int.attribute19%TYPE,
75: attribute20 igs_en_lgcy_spa_int.attribute20%TYPE,
76: re_attendance_percentage igs_en_lgcy_spa_int.re_attendance_percentage%TYPE,
77: re_govt_type_of_activity_cd igs_en_lgcy_spa_int.re_govt_type_of_activity_cd%TYPE,
70: attribute15 igs_en_lgcy_spa_int.attribute15%TYPE,
71: attribute16 igs_en_lgcy_spa_int.attribute16%TYPE,
72: attribute17 igs_en_lgcy_spa_int.attribute17%TYPE,
73: attribute18 igs_en_lgcy_spa_int.attribute18%TYPE,
74: attribute19 igs_en_lgcy_spa_int.attribute19%TYPE,
75: attribute20 igs_en_lgcy_spa_int.attribute20%TYPE,
76: re_attendance_percentage igs_en_lgcy_spa_int.re_attendance_percentage%TYPE,
77: re_govt_type_of_activity_cd igs_en_lgcy_spa_int.re_govt_type_of_activity_cd%TYPE,
78: re_max_submission_dt igs_en_lgcy_spa_int.re_max_submission_dt%TYPE,
71: attribute16 igs_en_lgcy_spa_int.attribute16%TYPE,
72: attribute17 igs_en_lgcy_spa_int.attribute17%TYPE,
73: attribute18 igs_en_lgcy_spa_int.attribute18%TYPE,
74: attribute19 igs_en_lgcy_spa_int.attribute19%TYPE,
75: attribute20 igs_en_lgcy_spa_int.attribute20%TYPE,
76: re_attendance_percentage igs_en_lgcy_spa_int.re_attendance_percentage%TYPE,
77: re_govt_type_of_activity_cd igs_en_lgcy_spa_int.re_govt_type_of_activity_cd%TYPE,
78: re_max_submission_dt igs_en_lgcy_spa_int.re_max_submission_dt%TYPE,
79: re_min_submission_dt igs_en_lgcy_spa_int.re_min_submission_dt%TYPE,
72: attribute17 igs_en_lgcy_spa_int.attribute17%TYPE,
73: attribute18 igs_en_lgcy_spa_int.attribute18%TYPE,
74: attribute19 igs_en_lgcy_spa_int.attribute19%TYPE,
75: attribute20 igs_en_lgcy_spa_int.attribute20%TYPE,
76: re_attendance_percentage igs_en_lgcy_spa_int.re_attendance_percentage%TYPE,
77: re_govt_type_of_activity_cd igs_en_lgcy_spa_int.re_govt_type_of_activity_cd%TYPE,
78: re_max_submission_dt igs_en_lgcy_spa_int.re_max_submission_dt%TYPE,
79: re_min_submission_dt igs_en_lgcy_spa_int.re_min_submission_dt%TYPE,
80: re_research_topic igs_en_lgcy_spa_int.re_research_topic%TYPE,
73: attribute18 igs_en_lgcy_spa_int.attribute18%TYPE,
74: attribute19 igs_en_lgcy_spa_int.attribute19%TYPE,
75: attribute20 igs_en_lgcy_spa_int.attribute20%TYPE,
76: re_attendance_percentage igs_en_lgcy_spa_int.re_attendance_percentage%TYPE,
77: re_govt_type_of_activity_cd igs_en_lgcy_spa_int.re_govt_type_of_activity_cd%TYPE,
78: re_max_submission_dt igs_en_lgcy_spa_int.re_max_submission_dt%TYPE,
79: re_min_submission_dt igs_en_lgcy_spa_int.re_min_submission_dt%TYPE,
80: re_research_topic igs_en_lgcy_spa_int.re_research_topic%TYPE,
81: re_industry_links igs_en_lgcy_spa_int.re_industry_links%TYPE);
74: attribute19 igs_en_lgcy_spa_int.attribute19%TYPE,
75: attribute20 igs_en_lgcy_spa_int.attribute20%TYPE,
76: re_attendance_percentage igs_en_lgcy_spa_int.re_attendance_percentage%TYPE,
77: re_govt_type_of_activity_cd igs_en_lgcy_spa_int.re_govt_type_of_activity_cd%TYPE,
78: re_max_submission_dt igs_en_lgcy_spa_int.re_max_submission_dt%TYPE,
79: re_min_submission_dt igs_en_lgcy_spa_int.re_min_submission_dt%TYPE,
80: re_research_topic igs_en_lgcy_spa_int.re_research_topic%TYPE,
81: re_industry_links igs_en_lgcy_spa_int.re_industry_links%TYPE);
82:
75: attribute20 igs_en_lgcy_spa_int.attribute20%TYPE,
76: re_attendance_percentage igs_en_lgcy_spa_int.re_attendance_percentage%TYPE,
77: re_govt_type_of_activity_cd igs_en_lgcy_spa_int.re_govt_type_of_activity_cd%TYPE,
78: re_max_submission_dt igs_en_lgcy_spa_int.re_max_submission_dt%TYPE,
79: re_min_submission_dt igs_en_lgcy_spa_int.re_min_submission_dt%TYPE,
80: re_research_topic igs_en_lgcy_spa_int.re_research_topic%TYPE,
81: re_industry_links igs_en_lgcy_spa_int.re_industry_links%TYPE);
82:
83: -- irep annotations below.
76: re_attendance_percentage igs_en_lgcy_spa_int.re_attendance_percentage%TYPE,
77: re_govt_type_of_activity_cd igs_en_lgcy_spa_int.re_govt_type_of_activity_cd%TYPE,
78: re_max_submission_dt igs_en_lgcy_spa_int.re_max_submission_dt%TYPE,
79: re_min_submission_dt igs_en_lgcy_spa_int.re_min_submission_dt%TYPE,
80: re_research_topic igs_en_lgcy_spa_int.re_research_topic%TYPE,
81: re_industry_links igs_en_lgcy_spa_int.re_industry_links%TYPE);
82:
83: -- irep annotations below.
84: /*#
77: re_govt_type_of_activity_cd igs_en_lgcy_spa_int.re_govt_type_of_activity_cd%TYPE,
78: re_max_submission_dt igs_en_lgcy_spa_int.re_max_submission_dt%TYPE,
79: re_min_submission_dt igs_en_lgcy_spa_int.re_min_submission_dt%TYPE,
80: re_research_topic igs_en_lgcy_spa_int.re_research_topic%TYPE,
81: re_industry_links igs_en_lgcy_spa_int.re_industry_links%TYPE);
82:
83: -- irep annotations below.
84: /*#
85: * The Student Program Attempt Legacy Import process is a public API designed for use in
83: -- irep annotations below.
84: /*#
85: * The Student Program Attempt Legacy Import process is a public API designed for use in
86: * populating rows with data during a system conversion. This API is also used by the Legacy
87: * Import Process for Enrollment and Records when importing rows from the IGS_EN_LGCY_SPA_INT interface table.
88: * @param p_api_version The version number will be used to compare with
89: * claim public api's current version number.Unexpected error is raised if version in-compatibility exists.
90: * @param P_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
91: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
89: * claim public api's current version number.Unexpected error is raised if version in-compatibility exists.
90: * @param P_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
91: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
92: * @param p_validation_level Public API will always perform full level of validation.
93: * @param p_sca_re_rec Legacy Student Program Attempt record type. Refer to IGS_EN_LGCY_SPA_INT for detail column descriptions.
94: * @param x_return_status The return status values are as follows; Success - FND_API.G_RET_STS_SUCCESS ; Error - FND_API.G_RET_STS_ERROR ; Unexpected error - FND_API.G_RET_STS_UNEXP_ERROR.
95: * @param x_msg_count Message count.
96: * @param x_msg_data Message data.
97: * @rep:scope public