DBA Data[Home] [Help]

APPS.IGS_PR_VAL_SPO dependencies on IGS_PR_STDNT_PR_OU_ALL

Line 21: person_id IGS_PR_STDNT_PR_OU_ALL.PERSON_ID%TYPE,

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,

Line 23: course_cd IGS_PR_STDNT_PR_OU_ALL.COURSE_CD%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,

Line 25: sequence_number IGS_PR_STDNT_PR_OU_ALL.SEQUENCE_NUMBER%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,

Line 27: prg_cal_type IGS_PR_STDNT_PR_OU_ALL.PRG_CAL_TYPE%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,

Line 29: prg_ci_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRG_CI_SEQUENCE_NUMBER%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,

Line 31: rule_check_dt IGS_PR_STDNT_PR_OU_ALL.RULE_CHECK_DT%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:

Line 33: progression_rule_cat IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_RULE_CAT%TYPE,

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:

Line 36: pra_sequence_number IGS_PR_STDNT_PR_OU_ALL.PRA_SEQUENCE_NUMBER%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:
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,

Line 38: progression_outcome_type IGS_PR_STDNT_PR_OU_ALL.PROGRESSION_OUTCOME_TYPE%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,

Line 40: old_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,

Line 42: new_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%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,

Line 44: decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%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,

Line 46: decision_org_unit_cd IGS_PR_STDNT_PR_OU_ALL.DECISION_ORG_UNIT_CD%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,

Line 48: decision_ou_start_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_OU_START_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,

Line 50: applied_dt IGS_PR_STDNT_PR_OU_ALL.APPLIED_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,

Line 52: expiry_dt IGS_PR_STDNT_PR_OU_ALL.EXPIRY_DT%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,

Line 54: encmb_course_group_cd IGS_PR_STDNT_PR_OU_ALL.ENCMB_COURSE_GROUP_CD%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:

Line 56: restricted_enrolment_cp IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ENROLMENT_CP%TYPE,

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:

Line 59: restricted_attendance_type IGS_PR_STDNT_PR_OU_ALL.RESTRICTED_ATTENDANCE_TYPE%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:
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,

Line 61: new_duration IGS_PR_STDNT_PR_OU_ALL.DURATION%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,

Line 63: old_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);

Line 65: new_duration_type IGS_PR_STDNT_PR_OU_ALL.DURATION_TYPE%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: --

Line 67: old_duration IGS_PR_STDNT_PR_OU_ALL.DURATION%TYPE);

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: --