DBA Data[Home] [Help]

APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_AV_LGCY_UNT_INT

Line 15: person_number igs_av_lgcy_unt_int.person_number%TYPE,

11: * @rep:category BUSINESS_ENTITY IGS_ADV_STAND
12: */
13: -- RECORD type variable for the table igs_av_lgcy_lvl_int
14: TYPE lgcy_adstunt_rec_type IS RECORD (
15: person_number igs_av_lgcy_unt_int.person_number%TYPE,
16: program_cd igs_av_lgcy_unt_int.program_cd%TYPE,
17: total_exmptn_approved igs_av_lgcy_unt_int.total_exmptn_approved%TYPE,
18: total_exmptn_granted igs_av_lgcy_unt_int.total_exmptn_granted%TYPE,
19: total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,

Line 16: program_cd igs_av_lgcy_unt_int.program_cd%TYPE,

12: */
13: -- RECORD type variable for the table igs_av_lgcy_lvl_int
14: TYPE lgcy_adstunt_rec_type IS RECORD (
15: person_number igs_av_lgcy_unt_int.person_number%TYPE,
16: program_cd igs_av_lgcy_unt_int.program_cd%TYPE,
17: total_exmptn_approved igs_av_lgcy_unt_int.total_exmptn_approved%TYPE,
18: total_exmptn_granted igs_av_lgcy_unt_int.total_exmptn_granted%TYPE,
19: total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,
20: exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,

Line 17: total_exmptn_approved igs_av_lgcy_unt_int.total_exmptn_approved%TYPE,

13: -- RECORD type variable for the table igs_av_lgcy_lvl_int
14: TYPE lgcy_adstunt_rec_type IS RECORD (
15: person_number igs_av_lgcy_unt_int.person_number%TYPE,
16: program_cd igs_av_lgcy_unt_int.program_cd%TYPE,
17: total_exmptn_approved igs_av_lgcy_unt_int.total_exmptn_approved%TYPE,
18: total_exmptn_granted igs_av_lgcy_unt_int.total_exmptn_granted%TYPE,
19: total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,
20: exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,
21: unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,

Line 18: total_exmptn_granted igs_av_lgcy_unt_int.total_exmptn_granted%TYPE,

14: TYPE lgcy_adstunt_rec_type IS RECORD (
15: person_number igs_av_lgcy_unt_int.person_number%TYPE,
16: program_cd igs_av_lgcy_unt_int.program_cd%TYPE,
17: total_exmptn_approved igs_av_lgcy_unt_int.total_exmptn_approved%TYPE,
18: total_exmptn_granted igs_av_lgcy_unt_int.total_exmptn_granted%TYPE,
19: total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,
20: exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,
21: unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
22: version_number igs_av_lgcy_unt_int.version_number%TYPE,

Line 19: total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,

15: person_number igs_av_lgcy_unt_int.person_number%TYPE,
16: program_cd igs_av_lgcy_unt_int.program_cd%TYPE,
17: total_exmptn_approved igs_av_lgcy_unt_int.total_exmptn_approved%TYPE,
18: total_exmptn_granted igs_av_lgcy_unt_int.total_exmptn_granted%TYPE,
19: total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,
20: exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,
21: unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
22: version_number igs_av_lgcy_unt_int.version_number%TYPE,
23: institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,

Line 20: exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,

16: program_cd igs_av_lgcy_unt_int.program_cd%TYPE,
17: total_exmptn_approved igs_av_lgcy_unt_int.total_exmptn_approved%TYPE,
18: total_exmptn_granted igs_av_lgcy_unt_int.total_exmptn_granted%TYPE,
19: total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,
20: exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,
21: unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
22: version_number igs_av_lgcy_unt_int.version_number%TYPE,
23: institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,
24: approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,

Line 21: unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,

17: total_exmptn_approved igs_av_lgcy_unt_int.total_exmptn_approved%TYPE,
18: total_exmptn_granted igs_av_lgcy_unt_int.total_exmptn_granted%TYPE,
19: total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,
20: exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,
21: unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
22: version_number igs_av_lgcy_unt_int.version_number%TYPE,
23: institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,
24: approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,
25: authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,

Line 22: version_number igs_av_lgcy_unt_int.version_number%TYPE,

18: total_exmptn_granted igs_av_lgcy_unt_int.total_exmptn_granted%TYPE,
19: total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,
20: exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,
21: unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
22: version_number igs_av_lgcy_unt_int.version_number%TYPE,
23: institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,
24: approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,
25: authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,
26: prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,

Line 23: institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,

19: total_exmptn_perc_grntd igs_av_lgcy_unt_int.total_exmptn_perc_grntd%TYPE,
20: exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,
21: unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
22: version_number igs_av_lgcy_unt_int.version_number%TYPE,
23: institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,
24: approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,
25: authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,
26: prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,
27: granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,

Line 24: approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,

20: exemption_institution_cd igs_av_lgcy_unt_int.exemption_institution_cd%TYPE,
21: unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
22: version_number igs_av_lgcy_unt_int.version_number%TYPE,
23: institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,
24: approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,
25: authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,
26: prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,
27: granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,
28: expiry_dt igs_av_lgcy_unt_int.expiry_dt%TYPE,

Line 25: authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,

21: unit_cd igs_av_lgcy_unt_int.unit_cd%TYPE,
22: version_number igs_av_lgcy_unt_int.version_number%TYPE,
23: institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,
24: approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,
25: authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,
26: prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,
27: granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,
28: expiry_dt igs_av_lgcy_unt_int.expiry_dt%TYPE,
29: cancelled_dt igs_av_lgcy_unt_int.cancelled_dt%TYPE,

Line 26: prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,

22: version_number igs_av_lgcy_unt_int.version_number%TYPE,
23: institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,
24: approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,
25: authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,
26: prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,
27: granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,
28: expiry_dt igs_av_lgcy_unt_int.expiry_dt%TYPE,
29: cancelled_dt igs_av_lgcy_unt_int.cancelled_dt%TYPE,
30: revoked_dt igs_av_lgcy_unt_int.revoked_dt%TYPE,

Line 27: granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,

23: institution_cd igs_av_lgcy_unt_int.institution_cd%TYPE,
24: approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,
25: authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,
26: prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,
27: granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,
28: expiry_dt igs_av_lgcy_unt_int.expiry_dt%TYPE,
29: cancelled_dt igs_av_lgcy_unt_int.cancelled_dt%TYPE,
30: revoked_dt igs_av_lgcy_unt_int.revoked_dt%TYPE,
31: comments igs_av_lgcy_unt_int.comments%TYPE,

Line 28: expiry_dt igs_av_lgcy_unt_int.expiry_dt%TYPE,

24: approved_dt igs_av_lgcy_unt_int.approved_dt%TYPE,
25: authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,
26: prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,
27: granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,
28: expiry_dt igs_av_lgcy_unt_int.expiry_dt%TYPE,
29: cancelled_dt igs_av_lgcy_unt_int.cancelled_dt%TYPE,
30: revoked_dt igs_av_lgcy_unt_int.revoked_dt%TYPE,
31: comments igs_av_lgcy_unt_int.comments%TYPE,
32: credit_percentage NUMBER(5,2),

Line 29: cancelled_dt igs_av_lgcy_unt_int.cancelled_dt%TYPE,

25: authorising_person_number igs_av_lgcy_unt_int.authorising_person_number%TYPE,
26: prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,
27: granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,
28: expiry_dt igs_av_lgcy_unt_int.expiry_dt%TYPE,
29: cancelled_dt igs_av_lgcy_unt_int.cancelled_dt%TYPE,
30: revoked_dt igs_av_lgcy_unt_int.revoked_dt%TYPE,
31: comments igs_av_lgcy_unt_int.comments%TYPE,
32: credit_percentage NUMBER(5,2),
33: s_adv_stnd_granting_status igs_av_lgcy_unt_int.s_adv_stnd_granting_status%TYPE,

Line 30: revoked_dt igs_av_lgcy_unt_int.revoked_dt%TYPE,

26: prog_group_ind igs_av_lgcy_unt_int.prog_group_ind%TYPE,
27: granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,
28: expiry_dt igs_av_lgcy_unt_int.expiry_dt%TYPE,
29: cancelled_dt igs_av_lgcy_unt_int.cancelled_dt%TYPE,
30: revoked_dt igs_av_lgcy_unt_int.revoked_dt%TYPE,
31: comments igs_av_lgcy_unt_int.comments%TYPE,
32: credit_percentage NUMBER(5,2),
33: s_adv_stnd_granting_status igs_av_lgcy_unt_int.s_adv_stnd_granting_status%TYPE,
34: s_adv_stnd_recognition_type igs_av_lgcy_unt_int.s_adv_stnd_recognition_type%TYPE,

Line 31: comments igs_av_lgcy_unt_int.comments%TYPE,

27: granted_dt igs_av_lgcy_unt_int.granted_dt%TYPE,
28: expiry_dt igs_av_lgcy_unt_int.expiry_dt%TYPE,
29: cancelled_dt igs_av_lgcy_unt_int.cancelled_dt%TYPE,
30: revoked_dt igs_av_lgcy_unt_int.revoked_dt%TYPE,
31: comments igs_av_lgcy_unt_int.comments%TYPE,
32: credit_percentage NUMBER(5,2),
33: s_adv_stnd_granting_status igs_av_lgcy_unt_int.s_adv_stnd_granting_status%TYPE,
34: s_adv_stnd_recognition_type igs_av_lgcy_unt_int.s_adv_stnd_recognition_type%TYPE,
35: load_cal_alt_code igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,

Line 33: s_adv_stnd_granting_status igs_av_lgcy_unt_int.s_adv_stnd_granting_status%TYPE,

29: cancelled_dt igs_av_lgcy_unt_int.cancelled_dt%TYPE,
30: revoked_dt igs_av_lgcy_unt_int.revoked_dt%TYPE,
31: comments igs_av_lgcy_unt_int.comments%TYPE,
32: credit_percentage NUMBER(5,2),
33: s_adv_stnd_granting_status igs_av_lgcy_unt_int.s_adv_stnd_granting_status%TYPE,
34: s_adv_stnd_recognition_type igs_av_lgcy_unt_int.s_adv_stnd_recognition_type%TYPE,
35: load_cal_alt_code igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
36: grading_schema_cd igs_av_lgcy_unt_int.grading_schema_cd%TYPE,
37: grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,

Line 34: s_adv_stnd_recognition_type igs_av_lgcy_unt_int.s_adv_stnd_recognition_type%TYPE,

30: revoked_dt igs_av_lgcy_unt_int.revoked_dt%TYPE,
31: comments igs_av_lgcy_unt_int.comments%TYPE,
32: credit_percentage NUMBER(5,2),
33: s_adv_stnd_granting_status igs_av_lgcy_unt_int.s_adv_stnd_granting_status%TYPE,
34: s_adv_stnd_recognition_type igs_av_lgcy_unt_int.s_adv_stnd_recognition_type%TYPE,
35: load_cal_alt_code igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
36: grading_schema_cd igs_av_lgcy_unt_int.grading_schema_cd%TYPE,
37: grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,
38: grade igs_av_lgcy_unt_int.grade%TYPE,

Line 35: load_cal_alt_code igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,

31: comments igs_av_lgcy_unt_int.comments%TYPE,
32: credit_percentage NUMBER(5,2),
33: s_adv_stnd_granting_status igs_av_lgcy_unt_int.s_adv_stnd_granting_status%TYPE,
34: s_adv_stnd_recognition_type igs_av_lgcy_unt_int.s_adv_stnd_recognition_type%TYPE,
35: load_cal_alt_code igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
36: grading_schema_cd igs_av_lgcy_unt_int.grading_schema_cd%TYPE,
37: grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,
38: grade igs_av_lgcy_unt_int.grade%TYPE,
39: achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,

Line 36: grading_schema_cd igs_av_lgcy_unt_int.grading_schema_cd%TYPE,

32: credit_percentage NUMBER(5,2),
33: s_adv_stnd_granting_status igs_av_lgcy_unt_int.s_adv_stnd_granting_status%TYPE,
34: s_adv_stnd_recognition_type igs_av_lgcy_unt_int.s_adv_stnd_recognition_type%TYPE,
35: load_cal_alt_code igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
36: grading_schema_cd igs_av_lgcy_unt_int.grading_schema_cd%TYPE,
37: grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,
38: grade igs_av_lgcy_unt_int.grade%TYPE,
39: achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
40: prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,

Line 37: grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,

33: s_adv_stnd_granting_status igs_av_lgcy_unt_int.s_adv_stnd_granting_status%TYPE,
34: s_adv_stnd_recognition_type igs_av_lgcy_unt_int.s_adv_stnd_recognition_type%TYPE,
35: load_cal_alt_code igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
36: grading_schema_cd igs_av_lgcy_unt_int.grading_schema_cd%TYPE,
37: grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,
38: grade igs_av_lgcy_unt_int.grade%TYPE,
39: achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
40: prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,
41: prev_term igs_av_lgcy_unt_int.prev_term%TYPE,

Line 38: grade igs_av_lgcy_unt_int.grade%TYPE,

34: s_adv_stnd_recognition_type igs_av_lgcy_unt_int.s_adv_stnd_recognition_type%TYPE,
35: load_cal_alt_code igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
36: grading_schema_cd igs_av_lgcy_unt_int.grading_schema_cd%TYPE,
37: grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,
38: grade igs_av_lgcy_unt_int.grade%TYPE,
39: achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
40: prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,
41: prev_term igs_av_lgcy_unt_int.prev_term%TYPE,
42: tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,

Line 39: achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,

35: load_cal_alt_code igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,
36: grading_schema_cd igs_av_lgcy_unt_int.grading_schema_cd%TYPE,
37: grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,
38: grade igs_av_lgcy_unt_int.grade%TYPE,
39: achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
40: prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,
41: prev_term igs_av_lgcy_unt_int.prev_term%TYPE,
42: tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,
43: tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,

Line 40: prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,

36: grading_schema_cd igs_av_lgcy_unt_int.grading_schema_cd%TYPE,
37: grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,
38: grade igs_av_lgcy_unt_int.grade%TYPE,
39: achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
40: prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,
41: prev_term igs_av_lgcy_unt_int.prev_term%TYPE,
42: tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,
43: tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,
44: test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,

Line 41: prev_term igs_av_lgcy_unt_int.prev_term%TYPE,

37: grd_sch_version_number igs_av_lgcy_unt_int.grd_sch_version_number%TYPE,
38: grade igs_av_lgcy_unt_int.grade%TYPE,
39: achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
40: prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,
41: prev_term igs_av_lgcy_unt_int.prev_term%TYPE,
42: tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,
43: tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,
44: test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,
45: alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,

Line 42: tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,

38: grade igs_av_lgcy_unt_int.grade%TYPE,
39: achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
40: prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,
41: prev_term igs_av_lgcy_unt_int.prev_term%TYPE,
42: tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,
43: tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,
44: test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,
45: alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,
46: alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,

Line 43: tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,

39: achievable_credit_points igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
40: prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,
41: prev_term igs_av_lgcy_unt_int.prev_term%TYPE,
42: tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,
43: tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,
44: test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,
45: alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,
46: alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,
47: optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,

Line 44: test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,

40: prev_unit_cd igs_av_lgcy_unt_int.prev_unit_cd%TYPE,
41: prev_term igs_av_lgcy_unt_int.prev_term%TYPE,
42: tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,
43: tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,
44: test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,
45: alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,
46: alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,
47: optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,
48: basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,

Line 45: alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,

41: prev_term igs_av_lgcy_unt_int.prev_term%TYPE,
42: tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,
43: tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,
44: test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,
45: alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,
46: alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,
47: optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,
48: basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,
49: basis_year igs_av_lgcy_unt_int.basis_year%TYPE,

Line 46: alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,

42: tst_admission_test_type igs_av_lgcy_unt_int.tst_admission_test_type%TYPE,
43: tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,
44: test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,
45: alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,
46: alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,
47: optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,
48: basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,
49: basis_year igs_av_lgcy_unt_int.basis_year%TYPE,
50: basis_completion_ind igs_av_lgcy_unt_int.basis_completion_ind%TYPE,

Line 47: optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,

43: tst_test_date igs_av_lgcy_unt_int.tst_test_date%TYPE,
44: test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,
45: alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,
46: alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,
47: optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,
48: basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,
49: basis_year igs_av_lgcy_unt_int.basis_year%TYPE,
50: basis_completion_ind igs_av_lgcy_unt_int.basis_completion_ind%TYPE,
51: start_date igs_av_lgcy_unt_int.start_date%TYPE,

Line 48: basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,

44: test_segment_name igs_av_lgcy_unt_int.test_segment_name%TYPE,
45: alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,
46: alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,
47: optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,
48: basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,
49: basis_year igs_av_lgcy_unt_int.basis_year%TYPE,
50: basis_completion_ind igs_av_lgcy_unt_int.basis_completion_ind%TYPE,
51: start_date igs_av_lgcy_unt_int.start_date%TYPE,
52: end_date igs_av_lgcy_unt_int.end_date%TYPE,

Line 49: basis_year igs_av_lgcy_unt_int.basis_year%TYPE,

45: alt_unit_cd igs_av_lgcy_unt_int.alt_unit_cd%TYPE,
46: alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,
47: optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,
48: basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,
49: basis_year igs_av_lgcy_unt_int.basis_year%TYPE,
50: basis_completion_ind igs_av_lgcy_unt_int.basis_completion_ind%TYPE,
51: start_date igs_av_lgcy_unt_int.start_date%TYPE,
52: end_date igs_av_lgcy_unt_int.end_date%TYPE,
53: -- added jhanda bug 4327991

Line 50: basis_completion_ind igs_av_lgcy_unt_int.basis_completion_ind%TYPE,

46: alt_version_number igs_av_lgcy_unt_int.alt_version_number%TYPE,
47: optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,
48: basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,
49: basis_year igs_av_lgcy_unt_int.basis_year%TYPE,
50: basis_completion_ind igs_av_lgcy_unt_int.basis_completion_ind%TYPE,
51: start_date igs_av_lgcy_unt_int.start_date%TYPE,
52: end_date igs_av_lgcy_unt_int.end_date%TYPE,
53: -- added jhanda bug 4327991
54: reference_cd_type igs_av_lgcy_unt_int.reference_cd_type%TYPE,

Line 51: start_date igs_av_lgcy_unt_int.start_date%TYPE,

47: optional_ind igs_av_lgcy_unt_int.optional_ind%TYPE,
48: basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,
49: basis_year igs_av_lgcy_unt_int.basis_year%TYPE,
50: basis_completion_ind igs_av_lgcy_unt_int.basis_completion_ind%TYPE,
51: start_date igs_av_lgcy_unt_int.start_date%TYPE,
52: end_date igs_av_lgcy_unt_int.end_date%TYPE,
53: -- added jhanda bug 4327991
54: reference_cd_type igs_av_lgcy_unt_int.reference_cd_type%TYPE,
55: reference_cd igs_av_lgcy_unt_int.reference_cd%TYPE,

Line 52: end_date igs_av_lgcy_unt_int.end_date%TYPE,

48: basis_program_type igs_av_lgcy_unt_int.basis_program_type%TYPE,
49: basis_year igs_av_lgcy_unt_int.basis_year%TYPE,
50: basis_completion_ind igs_av_lgcy_unt_int.basis_completion_ind%TYPE,
51: start_date igs_av_lgcy_unt_int.start_date%TYPE,
52: end_date igs_av_lgcy_unt_int.end_date%TYPE,
53: -- added jhanda bug 4327991
54: reference_cd_type igs_av_lgcy_unt_int.reference_cd_type%TYPE,
55: reference_cd igs_av_lgcy_unt_int.reference_cd%TYPE,
56: applied_program_cd igs_av_lgcy_unt_int.applied_program_cd%TYPE

Line 54: reference_cd_type igs_av_lgcy_unt_int.reference_cd_type%TYPE,

50: basis_completion_ind igs_av_lgcy_unt_int.basis_completion_ind%TYPE,
51: start_date igs_av_lgcy_unt_int.start_date%TYPE,
52: end_date igs_av_lgcy_unt_int.end_date%TYPE,
53: -- added jhanda bug 4327991
54: reference_cd_type igs_av_lgcy_unt_int.reference_cd_type%TYPE,
55: reference_cd igs_av_lgcy_unt_int.reference_cd%TYPE,
56: applied_program_cd igs_av_lgcy_unt_int.applied_program_cd%TYPE
57:
58: );

Line 55: reference_cd igs_av_lgcy_unt_int.reference_cd%TYPE,

51: start_date igs_av_lgcy_unt_int.start_date%TYPE,
52: end_date igs_av_lgcy_unt_int.end_date%TYPE,
53: -- added jhanda bug 4327991
54: reference_cd_type igs_av_lgcy_unt_int.reference_cd_type%TYPE,
55: reference_cd igs_av_lgcy_unt_int.reference_cd%TYPE,
56: applied_program_cd igs_av_lgcy_unt_int.applied_program_cd%TYPE
57:
58: );
59:

Line 56: applied_program_cd igs_av_lgcy_unt_int.applied_program_cd%TYPE

52: end_date igs_av_lgcy_unt_int.end_date%TYPE,
53: -- added jhanda bug 4327991
54: reference_cd_type igs_av_lgcy_unt_int.reference_cd_type%TYPE,
55: reference_cd igs_av_lgcy_unt_int.reference_cd%TYPE,
56: applied_program_cd igs_av_lgcy_unt_int.applied_program_cd%TYPE
57:
58: );
59:
60: /*===========================================================================+