17: TYPE r_spo_record_type IS RECORD
18:
19: (
20:
21: person_id IGS_PR_STDNT_PR_OU_ALL.PERSON_ID%TYPE,
22:
23: course_cd IGS_PR_STDNT_PR_OU_ALL.COURSE_CD%TYPE,
24:
25: sequence_number IGS_PR_STDNT_PR_OU_ALL.SEQUENCE_NUMBER%TYPE,
19: (
20:
21: person_id IGS_PR_STDNT_PR_OU_ALL.PERSON_ID%TYPE,
22:
23: course_cd IGS_PR_STDNT_PR_OU_ALL.COURSE_CD%TYPE,
24:
25: sequence_number IGS_PR_STDNT_PR_OU_ALL.SEQUENCE_NUMBER%TYPE,
26:
27: prg_cal_type IGS_PR_STDNT_PR_OU_ALL.PRG_CAL_TYPE%TYPE,
21: person_id IGS_PR_STDNT_PR_OU_ALL.PERSON_ID%TYPE,
22:
23: course_cd IGS_PR_STDNT_PR_OU_ALL.COURSE_CD%TYPE,
24:
25: sequence_number IGS_PR_STDNT_PR_OU_ALL.SEQUENCE_NUMBER%TYPE,
26:
27: prg_cal_type IGS_PR_STDNT_PR_OU_ALL.PRG_CAL_TYPE%TYPE,
28:
29: prg_ci_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRG_CI_SEQUENCE_NUMBER%TYPE,
23: course_cd IGS_PR_STDNT_PR_OU_ALL.COURSE_CD%TYPE,
24:
25: sequence_number IGS_PR_STDNT_PR_OU_ALL.SEQUENCE_NUMBER%TYPE,
26:
27: prg_cal_type IGS_PR_STDNT_PR_OU_ALL.PRG_CAL_TYPE%TYPE,
28:
29: prg_ci_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRG_CI_SEQUENCE_NUMBER%TYPE,
30:
31: rule_check_dt IGS_PR_STDNT_PR_OU_ALL.RULE_CHECK_DT%TYPE,
25: sequence_number IGS_PR_STDNT_PR_OU_ALL.SEQUENCE_NUMBER%TYPE,
26:
27: prg_cal_type IGS_PR_STDNT_PR_OU_ALL.PRG_CAL_TYPE%TYPE,
28:
29: prg_ci_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRG_CI_SEQUENCE_NUMBER%TYPE,
30:
31: rule_check_dt IGS_PR_STDNT_PR_OU_ALL.RULE_CHECK_DT%TYPE,
32:
33: progression_rule_cat IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_RULE_CAT%TYPE,
27: prg_cal_type IGS_PR_STDNT_PR_OU_ALL.PRG_CAL_TYPE%TYPE,
28:
29: prg_ci_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRG_CI_SEQUENCE_NUMBER%TYPE,
30:
31: rule_check_dt IGS_PR_STDNT_PR_OU_ALL.RULE_CHECK_DT%TYPE,
32:
33: progression_rule_cat IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_RULE_CAT%TYPE,
34:
35:
29: prg_ci_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRG_CI_SEQUENCE_NUMBER%TYPE,
30:
31: rule_check_dt IGS_PR_STDNT_PR_OU_ALL.RULE_CHECK_DT%TYPE,
32:
33: progression_rule_cat IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_RULE_CAT%TYPE,
34:
35:
36: pra_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRA_SEQUENCE_NUMBER%TYPE,
37:
32:
33: progression_rule_cat IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_RULE_CAT%TYPE,
34:
35:
36: pra_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRA_SEQUENCE_NUMBER%TYPE,
37:
38: progression_outcome_type IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_OUTCOME_TYPE%TYPE,
39:
40: old_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE,
34:
35:
36: pra_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRA_SEQUENCE_NUMBER%TYPE,
37:
38: progression_outcome_type IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_OUTCOME_TYPE%TYPE,
39:
40: old_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE,
41:
42: new_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE,
36: pra_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRA_SEQUENCE_NUMBER%TYPE,
37:
38: progression_outcome_type IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_OUTCOME_TYPE%TYPE,
39:
40: old_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE,
41:
42: new_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE,
43:
44: decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%TYPE,
38: progression_outcome_type IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_OUTCOME_TYPE%TYPE,
39:
40: old_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE,
41:
42: new_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE,
43:
44: decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%TYPE,
45:
46: decision_org_unit_cd IGS_PR_STDNT_PR_OU_ALL.DECISION_ORG_UNIT_CD%TYPE,
40: old_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE,
41:
42: new_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE,
43:
44: decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%TYPE,
45:
46: decision_org_unit_cd IGS_PR_STDNT_PR_OU_ALL.DECISION_ORG_UNIT_CD%TYPE,
47:
48: decision_ou_start_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_OU_START_DT%TYPE,
42: new_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE,
43:
44: decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%TYPE,
45:
46: decision_org_unit_cd IGS_PR_STDNT_PR_OU_ALL.DECISION_ORG_UNIT_CD%TYPE,
47:
48: decision_ou_start_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_OU_START_DT%TYPE,
49:
50: applied_dt IGS_PR_STDNT_PR_OU_ALL.APPLIED_DT%TYPE,
44: decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%TYPE,
45:
46: decision_org_unit_cd IGS_PR_STDNT_PR_OU_ALL.DECISION_ORG_UNIT_CD%TYPE,
47:
48: decision_ou_start_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_OU_START_DT%TYPE,
49:
50: applied_dt IGS_PR_STDNT_PR_OU_ALL.APPLIED_DT%TYPE,
51:
52: expiry_dt IGS_PR_STDNT_PR_OU_ALL.EXPIRY_DT%TYPE,
46: decision_org_unit_cd IGS_PR_STDNT_PR_OU_ALL.DECISION_ORG_UNIT_CD%TYPE,
47:
48: decision_ou_start_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_OU_START_DT%TYPE,
49:
50: applied_dt IGS_PR_STDNT_PR_OU_ALL.APPLIED_DT%TYPE,
51:
52: expiry_dt IGS_PR_STDNT_PR_OU_ALL.EXPIRY_DT%TYPE,
53:
54: encmb_course_group_cd IGS_PR_STDNT_PR_OU_ALL.ENCMB_COURSE_GROUP_CD%TYPE,
48: decision_ou_start_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_OU_START_DT%TYPE,
49:
50: applied_dt IGS_PR_STDNT_PR_OU_ALL.APPLIED_DT%TYPE,
51:
52: expiry_dt IGS_PR_STDNT_PR_OU_ALL.EXPIRY_DT%TYPE,
53:
54: encmb_course_group_cd IGS_PR_STDNT_PR_OU_ALL.ENCMB_COURSE_GROUP_CD%TYPE,
55:
56: restricted_enrolment_cp IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ENROLMENT_CP%TYPE,
50: applied_dt IGS_PR_STDNT_PR_OU_ALL.APPLIED_DT%TYPE,
51:
52: expiry_dt IGS_PR_STDNT_PR_OU_ALL.EXPIRY_DT%TYPE,
53:
54: encmb_course_group_cd IGS_PR_STDNT_PR_OU_ALL.ENCMB_COURSE_GROUP_CD%TYPE,
55:
56: restricted_enrolment_cp IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ENROLMENT_CP%TYPE,
57:
58:
52: expiry_dt IGS_PR_STDNT_PR_OU_ALL.EXPIRY_DT%TYPE,
53:
54: encmb_course_group_cd IGS_PR_STDNT_PR_OU_ALL.ENCMB_COURSE_GROUP_CD%TYPE,
55:
56: restricted_enrolment_cp IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ENROLMENT_CP%TYPE,
57:
58:
59: restricted_attendance_type IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ATTENDANCE_TYPE%TYPE,
60:
55:
56: restricted_enrolment_cp IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ENROLMENT_CP%TYPE,
57:
58:
59: restricted_attendance_type IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ATTENDANCE_TYPE%TYPE,
60:
61: new_duration IGS_PR_STDNT_PR_OU_ALL.DURATION%TYPE,
62:
63: old_duration_type IGS_PR_STDNT_PR_OU_ALL.DURATION_TYPE%TYPE,
57:
58:
59: restricted_attendance_type IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ATTENDANCE_TYPE%TYPE,
60:
61: new_duration IGS_PR_STDNT_PR_OU_ALL.DURATION%TYPE,
62:
63: old_duration_type IGS_PR_STDNT_PR_OU_ALL.DURATION_TYPE%TYPE,
64:
65: new_duration_type IGS_PR_STDNT_PR_OU_ALL.DURATION_TYPE%TYPE,
59: restricted_attendance_type IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ATTENDANCE_TYPE%TYPE,
60:
61: new_duration IGS_PR_STDNT_PR_OU_ALL.DURATION%TYPE,
62:
63: old_duration_type IGS_PR_STDNT_PR_OU_ALL.DURATION_TYPE%TYPE,
64:
65: new_duration_type IGS_PR_STDNT_PR_OU_ALL.DURATION_TYPE%TYPE,
66:
67: old_duration IGS_PR_STDNT_PR_OU_ALL.DURATION%TYPE);
61: new_duration IGS_PR_STDNT_PR_OU_ALL.DURATION%TYPE,
62:
63: old_duration_type IGS_PR_STDNT_PR_OU_ALL.DURATION_TYPE%TYPE,
64:
65: new_duration_type IGS_PR_STDNT_PR_OU_ALL.DURATION_TYPE%TYPE,
66:
67: old_duration IGS_PR_STDNT_PR_OU_ALL.DURATION%TYPE);
68:
69: --
63: old_duration_type IGS_PR_STDNT_PR_OU_ALL.DURATION_TYPE%TYPE,
64:
65: new_duration_type IGS_PR_STDNT_PR_OU_ALL.DURATION_TYPE%TYPE,
66:
67: old_duration IGS_PR_STDNT_PR_OU_ALL.DURATION%TYPE);
68:
69: --
70:
71: --