eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_SUSA_LGCY_PUB dependencies on IGS_HE_LGY_SUSA_INT

Line 5: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_HE_LGY_SUSA_INT interface table.

1: PACKAGE igs_he_susa_lgcy_pub AS
2: /* $Header: IGSHE23S.pls 120.1 2006/02/13 23:27:10 jchakrab noship $ */
3: /*#
4: * The Student Unit Set Attempt HESA Detail Import process is a public API designed for use in populating rows with data during a system conversion.
5: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_HE_LGY_SUSA_INT interface table.
6: * @rep:scope public
7: * @rep:product IGS
8: * @rep:displayname Import Legacy Student Unit Set Attempt HESA Detail
9: * @rep:lifecycle active

Line 14: -- Record Type for columns of Interface table IGS_HE_LGY_SUSA_INT

10: * @rep:compatibility S
11: * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
12: */
13:
14: -- Record Type for columns of Interface table IGS_HE_LGY_SUSA_INT
15: --
16: TYPE hesa_susa_rec_type IS RECORD ( person_number igs_he_lgy_susa_int.person_number%TYPE,
17: program_cd igs_he_lgy_susa_int.program_cd%TYPE,
18: unit_set_cd igs_he_lgy_susa_int.unit_set_cd%TYPE,

Line 16: TYPE hesa_susa_rec_type IS RECORD ( person_number igs_he_lgy_susa_int.person_number%TYPE,

12: */
13:
14: -- Record Type for columns of Interface table IGS_HE_LGY_SUSA_INT
15: --
16: TYPE hesa_susa_rec_type IS RECORD ( person_number igs_he_lgy_susa_int.person_number%TYPE,
17: program_cd igs_he_lgy_susa_int.program_cd%TYPE,
18: unit_set_cd igs_he_lgy_susa_int.unit_set_cd%TYPE,
19: new_he_entrant_cd igs_he_lgy_susa_int.new_he_entrant_cd%TYPE,
20: term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,

Line 17: program_cd igs_he_lgy_susa_int.program_cd%TYPE,

13:
14: -- Record Type for columns of Interface table IGS_HE_LGY_SUSA_INT
15: --
16: TYPE hesa_susa_rec_type IS RECORD ( person_number igs_he_lgy_susa_int.person_number%TYPE,
17: program_cd igs_he_lgy_susa_int.program_cd%TYPE,
18: unit_set_cd igs_he_lgy_susa_int.unit_set_cd%TYPE,
19: new_he_entrant_cd igs_he_lgy_susa_int.new_he_entrant_cd%TYPE,
20: term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,
21: disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,

Line 18: unit_set_cd igs_he_lgy_susa_int.unit_set_cd%TYPE,

14: -- Record Type for columns of Interface table IGS_HE_LGY_SUSA_INT
15: --
16: TYPE hesa_susa_rec_type IS RECORD ( person_number igs_he_lgy_susa_int.person_number%TYPE,
17: program_cd igs_he_lgy_susa_int.program_cd%TYPE,
18: unit_set_cd igs_he_lgy_susa_int.unit_set_cd%TYPE,
19: new_he_entrant_cd igs_he_lgy_susa_int.new_he_entrant_cd%TYPE,
20: term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,
21: disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,
22: additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,

Line 19: new_he_entrant_cd igs_he_lgy_susa_int.new_he_entrant_cd%TYPE,

15: --
16: TYPE hesa_susa_rec_type IS RECORD ( person_number igs_he_lgy_susa_int.person_number%TYPE,
17: program_cd igs_he_lgy_susa_int.program_cd%TYPE,
18: unit_set_cd igs_he_lgy_susa_int.unit_set_cd%TYPE,
19: new_he_entrant_cd igs_he_lgy_susa_int.new_he_entrant_cd%TYPE,
20: term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,
21: disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,
22: additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,
23: sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,

Line 20: term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,

16: TYPE hesa_susa_rec_type IS RECORD ( person_number igs_he_lgy_susa_int.person_number%TYPE,
17: program_cd igs_he_lgy_susa_int.program_cd%TYPE,
18: unit_set_cd igs_he_lgy_susa_int.unit_set_cd%TYPE,
19: new_he_entrant_cd igs_he_lgy_susa_int.new_he_entrant_cd%TYPE,
20: term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,
21: disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,
22: additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,
23: sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,
24: study_mode igs_he_lgy_susa_int.study_mode%TYPE,

Line 21: disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,

17: program_cd igs_he_lgy_susa_int.program_cd%TYPE,
18: unit_set_cd igs_he_lgy_susa_int.unit_set_cd%TYPE,
19: new_he_entrant_cd igs_he_lgy_susa_int.new_he_entrant_cd%TYPE,
20: term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,
21: disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,
22: additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,
23: sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,
24: study_mode igs_he_lgy_susa_int.study_mode%TYPE,
25: study_location igs_he_lgy_susa_int.study_location%TYPE,

Line 22: additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,

18: unit_set_cd igs_he_lgy_susa_int.unit_set_cd%TYPE,
19: new_he_entrant_cd igs_he_lgy_susa_int.new_he_entrant_cd%TYPE,
20: term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,
21: disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,
22: additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,
23: sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,
24: study_mode igs_he_lgy_susa_int.study_mode%TYPE,
25: study_location igs_he_lgy_susa_int.study_location%TYPE,
26: fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,

Line 23: sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,

19: new_he_entrant_cd igs_he_lgy_susa_int.new_he_entrant_cd%TYPE,
20: term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,
21: disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,
22: additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,
23: sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,
24: study_mode igs_he_lgy_susa_int.study_mode%TYPE,
25: study_location igs_he_lgy_susa_int.study_location%TYPE,
26: fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,
27: franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,

Line 24: study_mode igs_he_lgy_susa_int.study_mode%TYPE,

20: term_time_accom igs_he_lgy_susa_int.term_time_accom%TYPE,
21: disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,
22: additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,
23: sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,
24: study_mode igs_he_lgy_susa_int.study_mode%TYPE,
25: study_location igs_he_lgy_susa_int.study_location%TYPE,
26: fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,
27: franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,
28: completion_status igs_he_lgy_susa_int.completion_status%TYPE,

Line 25: study_location igs_he_lgy_susa_int.study_location%TYPE,

21: disability_allow igs_he_lgy_susa_int.disability_allow%TYPE,
22: additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,
23: sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,
24: study_mode igs_he_lgy_susa_int.study_mode%TYPE,
25: study_location igs_he_lgy_susa_int.study_location%TYPE,
26: fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,
27: franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,
28: completion_status igs_he_lgy_susa_int.completion_status%TYPE,
29: good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,

Line 26: fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,

22: additional_sup_band igs_he_lgy_susa_int.additional_sup_band%TYPE,
23: sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,
24: study_mode igs_he_lgy_susa_int.study_mode%TYPE,
25: study_location igs_he_lgy_susa_int.study_location%TYPE,
26: fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,
27: franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,
28: completion_status igs_he_lgy_susa_int.completion_status%TYPE,
29: good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,
30: complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,

Line 27: franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,

23: sldd_discrete_prov igs_he_lgy_susa_int.sldd_discrete_prov%TYPE,
24: study_mode igs_he_lgy_susa_int.study_mode%TYPE,
25: study_location igs_he_lgy_susa_int.study_location%TYPE,
26: fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,
27: franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,
28: completion_status igs_he_lgy_susa_int.completion_status%TYPE,
29: good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,
30: complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,
31: credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,

Line 28: completion_status igs_he_lgy_susa_int.completion_status%TYPE,

24: study_mode igs_he_lgy_susa_int.study_mode%TYPE,
25: study_location igs_he_lgy_susa_int.study_location%TYPE,
26: fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,
27: franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,
28: completion_status igs_he_lgy_susa_int.completion_status%TYPE,
29: good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,
30: complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,
31: credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,
32: credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,

Line 29: good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,

25: study_location igs_he_lgy_susa_int.study_location%TYPE,
26: fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,
27: franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,
28: completion_status igs_he_lgy_susa_int.completion_status%TYPE,
29: good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,
30: complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,
31: credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,
32: credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,
33: credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,

Line 30: complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,

26: fte_perc_override igs_he_lgy_susa_int.fte_perc_override%TYPE,
27: franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,
28: completion_status igs_he_lgy_susa_int.completion_status%TYPE,
29: good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,
30: complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,
31: credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,
32: credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,
33: credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,
34: credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,

Line 31: credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,

27: franchising_activity igs_he_lgy_susa_int.franchising_activity%TYPE,
28: completion_status igs_he_lgy_susa_int.completion_status%TYPE,
29: good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,
30: complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,
31: credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,
32: credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,
33: credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,
34: credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,
35: credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,

Line 32: credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,

28: completion_status igs_he_lgy_susa_int.completion_status%TYPE,
29: good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,
30: complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,
31: credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,
32: credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,
33: credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,
34: credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,
35: credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,
36: credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,

Line 33: credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,

29: good_stand_marker igs_he_lgy_susa_int.good_stand_marker%TYPE,
30: complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,
31: credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,
32: credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,
33: credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,
34: credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,
35: credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,
36: credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,
37: credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,

Line 34: credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,

30: complete_pyr_study_cd igs_he_lgy_susa_int.complete_pyr_study_cd%TYPE,
31: credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,
32: credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,
33: credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,
34: credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,
35: credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,
36: credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,
37: credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,
38: credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,

Line 35: credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,

31: credit_value_yop1 igs_he_lgy_susa_int.credit_value_yop1%TYPE,
32: credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,
33: credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,
34: credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,
35: credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,
36: credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,
37: credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,
38: credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,
39: credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,

Line 36: credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,

32: credit_value_yop2 igs_he_lgy_susa_int.credit_value_yop2%TYPE,
33: credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,
34: credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,
35: credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,
36: credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,
37: credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,
38: credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,
39: credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,
40: credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,

Line 37: credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,

33: credit_value_yop3 igs_he_lgy_susa_int.credit_value_yop3%TYPE,
34: credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,
35: credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,
36: credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,
37: credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,
38: credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,
39: credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,
40: credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,
41: credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,

Line 38: credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,

34: credit_value_yop4 igs_he_lgy_susa_int.credit_value_yop4%TYPE,
35: credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,
36: credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,
37: credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,
38: credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,
39: credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,
40: credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,
41: credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,
42: credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,

Line 39: credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,

35: credit_level_achieved1 igs_he_lgy_susa_int.credit_level_achieved1%TYPE,
36: credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,
37: credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,
38: credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,
39: credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,
40: credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,
41: credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,
42: credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,
43: credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,

Line 40: credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,

36: credit_level_achieved2 igs_he_lgy_susa_int.credit_level_achieved2%TYPE,
37: credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,
38: credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,
39: credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,
40: credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,
41: credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,
42: credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,
43: credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,
44: credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,

Line 41: credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,

37: credit_level_achieved3 igs_he_lgy_susa_int.credit_level_achieved3%TYPE,
38: credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,
39: credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,
40: credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,
41: credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,
42: credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,
43: credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,
44: credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,
45: credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,

Line 42: credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,

38: credit_level_achieved4 igs_he_lgy_susa_int.credit_level_achieved4%TYPE,
39: credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,
40: credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,
41: credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,
42: credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,
43: credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,
44: credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,
45: credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,
46: credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,

Line 43: credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,

39: credit_pt_achieved1 igs_he_lgy_susa_int.credit_pt_achieved1%TYPE,
40: credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,
41: credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,
42: credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,
43: credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,
44: credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,
45: credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,
46: credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,
47: grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,

Line 44: credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,

40: credit_pt_achieved2 igs_he_lgy_susa_int.credit_pt_achieved2%TYPE,
41: credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,
42: credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,
43: credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,
44: credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,
45: credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,
46: credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,
47: grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,
48: mark igs_he_lgy_susa_int.mark%TYPE,

Line 45: credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,

41: credit_pt_achieved3 igs_he_lgy_susa_int.credit_pt_achieved3%TYPE,
42: credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,
43: credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,
44: credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,
45: credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,
46: credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,
47: grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,
48: mark igs_he_lgy_susa_int.mark%TYPE,
49: teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,

Line 46: credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,

42: credit_pt_achieved4 igs_he_lgy_susa_int.credit_pt_achieved4%TYPE,
43: credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,
44: credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,
45: credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,
46: credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,
47: grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,
48: mark igs_he_lgy_susa_int.mark%TYPE,
49: teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,
50: teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,

Line 47: grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,

43: credit_level1 igs_he_lgy_susa_int.credit_level1%TYPE,
44: credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,
45: credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,
46: credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,
47: grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,
48: mark igs_he_lgy_susa_int.mark%TYPE,
49: teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,
50: teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,
51: pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,

Line 48: mark igs_he_lgy_susa_int.mark%TYPE,

44: credit_level2 igs_he_lgy_susa_int.credit_level2%TYPE,
45: credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,
46: credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,
47: grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,
48: mark igs_he_lgy_susa_int.mark%TYPE,
49: teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,
50: teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,
51: pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,
52: fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,

Line 49: teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,

45: credit_level3 igs_he_lgy_susa_int.credit_level3%TYPE,
46: credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,
47: grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,
48: mark igs_he_lgy_susa_int.mark%TYPE,
49: teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,
50: teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,
51: pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,
52: fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,
53: fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,

Line 50: teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,

46: credit_level4 igs_he_lgy_susa_int.credit_level4%TYPE,
47: grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,
48: mark igs_he_lgy_susa_int.mark%TYPE,
49: teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,
50: teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,
51: pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,
52: fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,
53: fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,
54: fee_band igs_he_lgy_susa_int.fee_band%TYPE,

Line 51: pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,

47: grad_sch_grade igs_he_lgy_susa_int.grad_sch_grade%TYPE,
48: mark igs_he_lgy_susa_int.mark%TYPE,
49: teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,
50: teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,
51: pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,
52: fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,
53: fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,
54: fee_band igs_he_lgy_susa_int.fee_band%TYPE,
55: non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,

Line 52: fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,

48: mark igs_he_lgy_susa_int.mark%TYPE,
49: teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,
50: teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,
51: pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,
52: fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,
53: fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,
54: fee_band igs_he_lgy_susa_int.fee_band%TYPE,
55: non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,
56: student_fee igs_he_lgy_susa_int.student_fee%TYPE,

Line 53: fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,

49: teaching_inst1 igs_he_lgy_susa_int.teaching_inst1%TYPE,
50: teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,
51: pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,
52: fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,
53: fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,
54: fee_band igs_he_lgy_susa_int.fee_band%TYPE,
55: non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,
56: student_fee igs_he_lgy_susa_int.student_fee%TYPE,
57: fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,

Line 54: fee_band igs_he_lgy_susa_int.fee_band%TYPE,

50: teaching_inst2 igs_he_lgy_susa_int.teaching_inst2%TYPE,
51: pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,
52: fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,
53: fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,
54: fee_band igs_he_lgy_susa_int.fee_band%TYPE,
55: non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,
56: student_fee igs_he_lgy_susa_int.student_fee%TYPE,
57: fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,
58: calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,

Line 55: non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,

51: pro_not_taught igs_he_lgy_susa_int.pro_not_taught%TYPE,
52: fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,
53: fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,
54: fee_band igs_he_lgy_susa_int.fee_band%TYPE,
55: non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,
56: student_fee igs_he_lgy_susa_int.student_fee%TYPE,
57: fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,
58: calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,
59: fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,

Line 56: student_fee igs_he_lgy_susa_int.student_fee%TYPE,

52: fundability_code igs_he_lgy_susa_int.fundability_code%TYPE,
53: fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,
54: fee_band igs_he_lgy_susa_int.fee_band%TYPE,
55: non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,
56: student_fee igs_he_lgy_susa_int.student_fee%TYPE,
57: fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,
58: calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,
59: fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,
60: type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,

Line 57: fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,

53: fee_eligibility igs_he_lgy_susa_int.fee_eligibility%TYPE,
54: fee_band igs_he_lgy_susa_int.fee_band%TYPE,
55: non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,
56: student_fee igs_he_lgy_susa_int.student_fee%TYPE,
57: fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,
58: calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,
59: fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,
60: type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,
61: year_stu igs_he_lgy_susa_int.year_stu%TYPE,

Line 58: calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,

54: fee_band igs_he_lgy_susa_int.fee_band%TYPE,
55: non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,
56: student_fee igs_he_lgy_susa_int.student_fee%TYPE,
57: fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,
58: calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,
59: fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,
60: type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,
61: year_stu igs_he_lgy_susa_int.year_stu%TYPE,
62: enh_fund_elig_cd igs_he_lgy_susa_int.enh_fund_elig_cd%TYPE,

Line 59: fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,

55: non_payment_reason igs_he_lgy_susa_int.non_payment_reason%TYPE,
56: student_fee igs_he_lgy_susa_int.student_fee%TYPE,
57: fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,
58: calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,
59: fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,
60: type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,
61: year_stu igs_he_lgy_susa_int.year_stu%TYPE,
62: enh_fund_elig_cd igs_he_lgy_susa_int.enh_fund_elig_cd%TYPE,
63: additional_sup_cost igs_he_lgy_susa_int.additional_sup_cost%TYPE,

Line 60: type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,

56: student_fee igs_he_lgy_susa_int.student_fee%TYPE,
57: fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,
58: calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,
59: fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,
60: type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,
61: year_stu igs_he_lgy_susa_int.year_stu%TYPE,
62: enh_fund_elig_cd igs_he_lgy_susa_int.enh_fund_elig_cd%TYPE,
63: additional_sup_cost igs_he_lgy_susa_int.additional_sup_cost%TYPE,
64: disadv_uplift_factor igs_he_lgy_susa_int.disadv_uplift_factor%TYPE);

Line 61: year_stu igs_he_lgy_susa_int.year_stu%TYPE,

57: fte_intensity igs_he_lgy_susa_int.fte_intensity%TYPE,
58: calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,
59: fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,
60: type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,
61: year_stu igs_he_lgy_susa_int.year_stu%TYPE,
62: enh_fund_elig_cd igs_he_lgy_susa_int.enh_fund_elig_cd%TYPE,
63: additional_sup_cost igs_he_lgy_susa_int.additional_sup_cost%TYPE,
64: disadv_uplift_factor igs_he_lgy_susa_int.disadv_uplift_factor%TYPE);
65:

Line 62: enh_fund_elig_cd igs_he_lgy_susa_int.enh_fund_elig_cd%TYPE,

58: calculated_fte igs_he_lgy_susa_int.calculated_fte%TYPE,
59: fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,
60: type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,
61: year_stu igs_he_lgy_susa_int.year_stu%TYPE,
62: enh_fund_elig_cd igs_he_lgy_susa_int.enh_fund_elig_cd%TYPE,
63: additional_sup_cost igs_he_lgy_susa_int.additional_sup_cost%TYPE,
64: disadv_uplift_factor igs_he_lgy_susa_int.disadv_uplift_factor%TYPE);
65:
66:

Line 63: additional_sup_cost igs_he_lgy_susa_int.additional_sup_cost%TYPE,

59: fte_calc_type igs_he_lgy_susa_int.fte_calc_type%TYPE,
60: type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,
61: year_stu igs_he_lgy_susa_int.year_stu%TYPE,
62: enh_fund_elig_cd igs_he_lgy_susa_int.enh_fund_elig_cd%TYPE,
63: additional_sup_cost igs_he_lgy_susa_int.additional_sup_cost%TYPE,
64: disadv_uplift_factor igs_he_lgy_susa_int.disadv_uplift_factor%TYPE);
65:
66:
67: /*----------------------------------------------------------------------------

Line 64: disadv_uplift_factor igs_he_lgy_susa_int.disadv_uplift_factor%TYPE);

60: type_of_year igs_he_lgy_susa_int.type_of_year%TYPE,
61: year_stu igs_he_lgy_susa_int.year_stu%TYPE,
62: enh_fund_elig_cd igs_he_lgy_susa_int.enh_fund_elig_cd%TYPE,
63: additional_sup_cost igs_he_lgy_susa_int.additional_sup_cost%TYPE,
64: disadv_uplift_factor igs_he_lgy_susa_int.disadv_uplift_factor%TYPE);
65:
66:
67: /*----------------------------------------------------------------------------
68: || Created By : prraj

Line 79: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_HE_LGY_SUSA_INT interface table.

75: ------------------------------------------------------------------------------*/
76:
77: /*#
78: * The Student Unit Set Attempt HESA Detail Import process is a public API designed for use in populating rows with data during a system conversion.
79: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_HE_LGY_SUSA_INT interface table.
80: * @param p_api_version API Version Number.
81: * @param p_init_msg_list Initialize Message List.
82: * @param p_commit Commit Transaction.
83: * @param p_validation_level Validation Level.

Line 84: * @param p_hesa_susa_rec Legacy Student Unit Set Attempt HESA Details record type. Refer to IGS_HE_LGY_SUSA_INT for detail column descriptions.

80: * @param p_api_version API Version Number.
81: * @param p_init_msg_list Initialize Message List.
82: * @param p_commit Commit Transaction.
83: * @param p_validation_level Validation Level.
84: * @param p_hesa_susa_rec Legacy Student Unit Set Attempt HESA Details record type. Refer to IGS_HE_LGY_SUSA_INT for detail column descriptions.
85: * @param x_return_status Return Status.
86: * @param x_msg_count Message count.
87: * @param x_msg_data Message data.
88: * @rep:scope public