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_SPA_LGCY_PUB dependencies on IGS_HE_LGCY_SPA_INT

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

1: PACKAGE IGS_HE_SPA_LGCY_PUB AS
2: /* $Header: IGSHE22S.pls 120.1 2006/02/13 23:26:52 jchakrab noship $ */
3: /*#
4: * The Student Program 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_LGCY_SPA_INT interface table.
6: * @rep:scope public
7: * @rep:product IGS
8: * @rep:displayname Import Legacy Student Program Attempt HESA Detail
9: * @rep:lifecycle active

Line 15: person_number igs_he_lgcy_spa_int.person_number%TYPE,

11: * @rep:category BUSINESS_ENTITY IGS_STUDENT_PROGRAM
12: */
13:
14: TYPE hesa_spa_rec_type IS RECORD (
15: person_number igs_he_lgcy_spa_int.person_number%TYPE,
16: program_cd igs_he_lgcy_spa_int.program_cd%TYPE,
17: fe_student_marker igs_he_lgcy_spa_int.fe_student_marker%TYPE,
18: domicile_cd igs_he_lgcy_spa_int.domicile_cd%TYPE,
19: highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,

Line 16: program_cd igs_he_lgcy_spa_int.program_cd%TYPE,

12: */
13:
14: TYPE hesa_spa_rec_type IS RECORD (
15: person_number igs_he_lgcy_spa_int.person_number%TYPE,
16: program_cd igs_he_lgcy_spa_int.program_cd%TYPE,
17: fe_student_marker igs_he_lgcy_spa_int.fe_student_marker%TYPE,
18: domicile_cd igs_he_lgcy_spa_int.domicile_cd%TYPE,
19: highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,
20: occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,

Line 17: fe_student_marker igs_he_lgcy_spa_int.fe_student_marker%TYPE,

13:
14: TYPE hesa_spa_rec_type IS RECORD (
15: person_number igs_he_lgcy_spa_int.person_number%TYPE,
16: program_cd igs_he_lgcy_spa_int.program_cd%TYPE,
17: fe_student_marker igs_he_lgcy_spa_int.fe_student_marker%TYPE,
18: domicile_cd igs_he_lgcy_spa_int.domicile_cd%TYPE,
19: highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,
20: occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,
21: commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,

Line 18: domicile_cd igs_he_lgcy_spa_int.domicile_cd%TYPE,

14: TYPE hesa_spa_rec_type IS RECORD (
15: person_number igs_he_lgcy_spa_int.person_number%TYPE,
16: program_cd igs_he_lgcy_spa_int.program_cd%TYPE,
17: fe_student_marker igs_he_lgcy_spa_int.fe_student_marker%TYPE,
18: domicile_cd igs_he_lgcy_spa_int.domicile_cd%TYPE,
19: highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,
20: occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,
21: commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,
22: special_student igs_he_lgcy_spa_int.special_student%TYPE,

Line 19: highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,

15: person_number igs_he_lgcy_spa_int.person_number%TYPE,
16: program_cd igs_he_lgcy_spa_int.program_cd%TYPE,
17: fe_student_marker igs_he_lgcy_spa_int.fe_student_marker%TYPE,
18: domicile_cd igs_he_lgcy_spa_int.domicile_cd%TYPE,
19: highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,
20: occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,
21: commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,
22: special_student igs_he_lgcy_spa_int.special_student%TYPE,
23: student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,

Line 20: occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,

16: program_cd igs_he_lgcy_spa_int.program_cd%TYPE,
17: fe_student_marker igs_he_lgcy_spa_int.fe_student_marker%TYPE,
18: domicile_cd igs_he_lgcy_spa_int.domicile_cd%TYPE,
19: highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,
20: occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,
21: commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,
22: special_student igs_he_lgcy_spa_int.special_student%TYPE,
23: student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,
24: student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,

Line 21: commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,

17: fe_student_marker igs_he_lgcy_spa_int.fe_student_marker%TYPE,
18: domicile_cd igs_he_lgcy_spa_int.domicile_cd%TYPE,
19: highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,
20: occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,
21: commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,
22: special_student igs_he_lgcy_spa_int.special_student%TYPE,
23: student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,
24: student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,
25: teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,

Line 22: special_student igs_he_lgcy_spa_int.special_student%TYPE,

18: domicile_cd igs_he_lgcy_spa_int.domicile_cd%TYPE,
19: highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,
20: occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,
21: commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,
22: special_student igs_he_lgcy_spa_int.special_student%TYPE,
23: student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,
24: student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,
25: teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,
26: itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,

Line 23: student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,

19: highest_qual_on_entry igs_he_lgcy_spa_int.highest_qual_on_entry%TYPE,
20: occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,
21: commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,
22: special_student igs_he_lgcy_spa_int.special_student%TYPE,
23: student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,
24: student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,
25: teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,
26: itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,
27: bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,

Line 24: student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,

20: occupation_code igs_he_lgcy_spa_int.occupation_code%TYPE,
21: commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,
22: special_student igs_he_lgcy_spa_int.special_student%TYPE,
23: student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,
24: student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,
25: teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,
26: itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,
27: bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,
28: teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,

Line 25: teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,

21: commencement_dt igs_he_lgcy_spa_int.commencement_dt%TYPE,
22: special_student igs_he_lgcy_spa_int.special_student%TYPE,
23: student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,
24: student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,
25: teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,
26: itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,
27: bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,
28: teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,
29: teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,

Line 26: itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,

22: special_student igs_he_lgcy_spa_int.special_student%TYPE,
23: student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,
24: student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,
25: teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,
26: itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,
27: bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,
28: teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,
29: teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,
30: teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,

Line 27: bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,

23: student_qual_aim igs_he_lgcy_spa_int.student_qual_aim%TYPE,
24: student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,
25: teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,
26: itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,
27: bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,
28: teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,
29: teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,
30: teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,
31: teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,

Line 28: teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,

24: student_fe_qual_aim igs_he_lgcy_spa_int.student_fe_qual_aim%TYPE,
25: teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,
26: itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,
27: bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,
28: teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,
29: teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,
30: teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,
31: teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,
32: student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,

Line 29: teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,

25: teacher_train_prog_id igs_he_lgcy_spa_int.teacher_train_prog_id%TYPE,
26: itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,
27: bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,
28: teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,
29: teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,
30: teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,
31: teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,
32: student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,
33: destination igs_he_lgcy_spa_int.destination%TYPE,

Line 30: teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,

26: itt_phase igs_he_lgcy_spa_int.itt_phase%TYPE,
27: bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,
28: teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,
29: teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,
30: teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,
31: teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,
32: student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,
33: destination igs_he_lgcy_spa_int.destination%TYPE,
34: itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,

Line 31: teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,

27: bilingual_itt_marker igs_he_lgcy_spa_int.bilingual_itt_marker%TYPE,
28: teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,
29: teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,
30: teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,
31: teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,
32: student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,
33: destination igs_he_lgcy_spa_int.destination%TYPE,
34: itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,
35: associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,

Line 32: student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,

28: teaching_qual_gain_sector igs_he_lgcy_spa_int.teaching_qual_gain_sector%TYPE,
29: teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,
30: teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,
31: teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,
32: student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,
33: destination igs_he_lgcy_spa_int.destination%TYPE,
34: itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,
35: associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,
36: associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,

Line 33: destination igs_he_lgcy_spa_int.destination%TYPE,

29: teaching_qual_gain_subj1 igs_he_lgcy_spa_int.teaching_qual_gain_subj1%TYPE,
30: teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,
31: teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,
32: student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,
33: destination igs_he_lgcy_spa_int.destination%TYPE,
34: itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,
35: associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,
36: associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,
37: associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,

Line 34: itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,

30: teaching_qual_gain_subj2 igs_he_lgcy_spa_int.teaching_qual_gain_subj2%TYPE,
31: teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,
32: student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,
33: destination igs_he_lgcy_spa_int.destination%TYPE,
34: itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,
35: associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,
36: associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,
37: associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,
38: associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,

Line 35: associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,

31: teaching_qual_gain_subj3 igs_he_lgcy_spa_int.teaching_qual_gain_subj3%TYPE,
32: student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,
33: destination igs_he_lgcy_spa_int.destination%TYPE,
34: itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,
35: associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,
36: associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,
37: associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,
38: associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,
39: nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,

Line 36: associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,

32: student_inst_number igs_he_lgcy_spa_int.student_inst_number%TYPE,
33: destination igs_he_lgcy_spa_int.destination%TYPE,
34: itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,
35: associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,
36: associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,
37: associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,
38: associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,
39: nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,
40: ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,

Line 37: associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,

33: destination igs_he_lgcy_spa_int.destination%TYPE,
34: itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,
35: associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,
36: associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,
37: associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,
38: associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,
39: nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,
40: ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,
41: postcode igs_he_lgcy_spa_int.postcode%TYPE,

Line 38: associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,

34: itt_prog_outcome igs_he_lgcy_spa_int.itt_prog_outcome%TYPE,
35: associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,
36: associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,
37: associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,
38: associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,
39: nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,
40: ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,
41: postcode igs_he_lgcy_spa_int.postcode%TYPE,
42: social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,

Line 39: nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,

35: associate_ucas_number igs_he_lgcy_spa_int.associate_ucas_number%TYPE,
36: associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,
37: associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,
38: associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,
39: nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,
40: ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,
41: postcode igs_he_lgcy_spa_int.postcode%TYPE,
42: social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,
43: occcode igs_he_lgcy_spa_int.occcode%TYPE,

Line 40: ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,

36: associate_scott_cand igs_he_lgcy_spa_int.associate_scott_cand%TYPE,
37: associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,
38: associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,
39: nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,
40: ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,
41: postcode igs_he_lgcy_spa_int.postcode%TYPE,
42: social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,
43: occcode igs_he_lgcy_spa_int.occcode%TYPE,
44: nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,

Line 41: postcode igs_he_lgcy_spa_int.postcode%TYPE,

37: associate_teach_ref_num igs_he_lgcy_spa_int.associate_teach_ref_num%TYPE,
38: associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,
39: nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,
40: ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,
41: postcode igs_he_lgcy_spa_int.postcode%TYPE,
42: social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,
43: occcode igs_he_lgcy_spa_int.occcode%TYPE,
44: nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,
45: return_type igs_he_lgcy_spa_int.return_type%TYPE,

Line 42: social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,

38: associate_nhs_reg_num igs_he_lgcy_spa_int.associate_nhs_reg_num%TYPE,
39: nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,
40: ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,
41: postcode igs_he_lgcy_spa_int.postcode%TYPE,
42: social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,
43: occcode igs_he_lgcy_spa_int.occcode%TYPE,
44: nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,
45: return_type igs_he_lgcy_spa_int.return_type%TYPE,
46: subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,

Line 43: occcode igs_he_lgcy_spa_int.occcode%TYPE,

39: nhs_funding_source igs_he_lgcy_spa_int.nhs_funding_source%TYPE,
40: ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,
41: postcode igs_he_lgcy_spa_int.postcode%TYPE,
42: social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,
43: occcode igs_he_lgcy_spa_int.occcode%TYPE,
44: nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,
45: return_type igs_he_lgcy_spa_int.return_type%TYPE,
46: subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,
47: subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,

Line 44: nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,

40: ufi_place igs_he_lgcy_spa_int.ufi_place%TYPE,
41: postcode igs_he_lgcy_spa_int.postcode%TYPE,
42: social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,
43: occcode igs_he_lgcy_spa_int.occcode%TYPE,
44: nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,
45: return_type igs_he_lgcy_spa_int.return_type%TYPE,
46: subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,
47: subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,
48: subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,

Line 45: return_type igs_he_lgcy_spa_int.return_type%TYPE,

41: postcode igs_he_lgcy_spa_int.postcode%TYPE,
42: social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,
43: occcode igs_he_lgcy_spa_int.occcode%TYPE,
44: nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,
45: return_type igs_he_lgcy_spa_int.return_type%TYPE,
46: subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,
47: subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,
48: subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,
49: qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,

Line 46: subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,

42: social_class_ind igs_he_lgcy_spa_int.social_class_ind%TYPE,
43: occcode igs_he_lgcy_spa_int.occcode%TYPE,
44: nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,
45: return_type igs_he_lgcy_spa_int.return_type%TYPE,
46: subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,
47: subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,
48: subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,
49: qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,
50: dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,

Line 47: subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,

43: occcode igs_he_lgcy_spa_int.occcode%TYPE,
44: nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,
45: return_type igs_he_lgcy_spa_int.return_type%TYPE,
46: subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,
47: subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,
48: subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,
49: qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,
50: dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,
51: implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,

Line 48: subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,

44: nhs_employer igs_he_lgcy_spa_int.nhs_employer%TYPE,
45: return_type igs_he_lgcy_spa_int.return_type%TYPE,
46: subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,
47: subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,
48: subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,
49: qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,
50: dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,
51: implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,
52: gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,

Line 49: qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,

45: return_type igs_he_lgcy_spa_int.return_type%TYPE,
46: subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,
47: subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,
48: subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,
49: qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,
50: dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,
51: implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,
52: gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,
53: units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,

Line 50: dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,

46: subj_qualaim1 igs_he_lgcy_spa_int.subj_qualaim1%TYPE,
47: subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,
48: subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,
49: qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,
50: dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,
51: implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,
52: gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,
53: units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,
54: disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,

Line 51: implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,

47: subj_qualaim2 igs_he_lgcy_spa_int.subj_qualaim2%TYPE,
48: subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,
49: qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,
50: dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,
51: implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,
52: gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,
53: units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,
54: disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,
55: franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,

Line 52: gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,

48: subj_qualaim3 igs_he_lgcy_spa_int.subj_qualaim3%TYPE,
49: qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,
50: dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,
51: implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,
52: gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,
53: units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,
54: disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,
55: franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,
56: units_completed igs_he_lgcy_spa_int.units_completed%TYPE,

Line 53: units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,

49: qualaim_proportion igs_he_lgcy_spa_int.qualaim_proportion%TYPE,
50: dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,
51: implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,
52: gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,
53: units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,
54: disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,
55: franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,
56: units_completed igs_he_lgcy_spa_int.units_completed%TYPE,
57: franch_out_arr_cd igs_he_lgcy_spa_int.franch_out_arr_cd%TYPE,

Line 54: disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,

50: dependants_cd igs_he_lgcy_spa_int.dependants_cd%TYPE,
51: implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,
52: gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,
53: units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,
54: disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,
55: franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,
56: units_completed igs_he_lgcy_spa_int.units_completed%TYPE,
57: franch_out_arr_cd igs_he_lgcy_spa_int.franch_out_arr_cd%TYPE,
58: employer_role_cd igs_he_lgcy_spa_int.employer_role_cd%TYPE,

Line 55: franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,

51: implied_fund_rate igs_he_lgcy_spa_int.implied_fund_rate%TYPE,
52: gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,
53: units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,
54: disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,
55: franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,
56: units_completed igs_he_lgcy_spa_int.units_completed%TYPE,
57: franch_out_arr_cd igs_he_lgcy_spa_int.franch_out_arr_cd%TYPE,
58: employer_role_cd igs_he_lgcy_spa_int.employer_role_cd%TYPE,
59: disadv_uplift_factor igs_he_lgcy_spa_int.disadv_uplift_factor%TYPE,

Line 56: units_completed igs_he_lgcy_spa_int.units_completed%TYPE,

52: gov_initiatives_cd igs_he_lgcy_spa_int.gov_initiatives_cd%TYPE,
53: units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,
54: disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,
55: franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,
56: units_completed igs_he_lgcy_spa_int.units_completed%TYPE,
57: franch_out_arr_cd igs_he_lgcy_spa_int.franch_out_arr_cd%TYPE,
58: employer_role_cd igs_he_lgcy_spa_int.employer_role_cd%TYPE,
59: disadv_uplift_factor igs_he_lgcy_spa_int.disadv_uplift_factor%TYPE,
60: enh_fund_elig_cd igs_he_lgcy_spa_int.enh_fund_elig_cd%TYPE);

Line 57: franch_out_arr_cd igs_he_lgcy_spa_int.franch_out_arr_cd%TYPE,

53: units_for_qual igs_he_lgcy_spa_int.units_for_qual%TYPE,
54: disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,
55: franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,
56: units_completed igs_he_lgcy_spa_int.units_completed%TYPE,
57: franch_out_arr_cd igs_he_lgcy_spa_int.franch_out_arr_cd%TYPE,
58: employer_role_cd igs_he_lgcy_spa_int.employer_role_cd%TYPE,
59: disadv_uplift_factor igs_he_lgcy_spa_int.disadv_uplift_factor%TYPE,
60: enh_fund_elig_cd igs_he_lgcy_spa_int.enh_fund_elig_cd%TYPE);
61:

Line 58: employer_role_cd igs_he_lgcy_spa_int.employer_role_cd%TYPE,

54: disadv_uplift_elig_cd igs_he_lgcy_spa_int.disadv_uplift_elig_cd%TYPE,
55: franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,
56: units_completed igs_he_lgcy_spa_int.units_completed%TYPE,
57: franch_out_arr_cd igs_he_lgcy_spa_int.franch_out_arr_cd%TYPE,
58: employer_role_cd igs_he_lgcy_spa_int.employer_role_cd%TYPE,
59: disadv_uplift_factor igs_he_lgcy_spa_int.disadv_uplift_factor%TYPE,
60: enh_fund_elig_cd igs_he_lgcy_spa_int.enh_fund_elig_cd%TYPE);
61:
62: /*------------------------------------------------------------------

Line 59: disadv_uplift_factor igs_he_lgcy_spa_int.disadv_uplift_factor%TYPE,

55: franch_partner_cd igs_he_lgcy_spa_int.franch_partner_cd%TYPE,
56: units_completed igs_he_lgcy_spa_int.units_completed%TYPE,
57: franch_out_arr_cd igs_he_lgcy_spa_int.franch_out_arr_cd%TYPE,
58: employer_role_cd igs_he_lgcy_spa_int.employer_role_cd%TYPE,
59: disadv_uplift_factor igs_he_lgcy_spa_int.disadv_uplift_factor%TYPE,
60: enh_fund_elig_cd igs_he_lgcy_spa_int.enh_fund_elig_cd%TYPE);
61:
62: /*------------------------------------------------------------------
63: --Created by : knaraset, Oracle IDC

Line 60: enh_fund_elig_cd igs_he_lgcy_spa_int.enh_fund_elig_cd%TYPE);

56: units_completed igs_he_lgcy_spa_int.units_completed%TYPE,
57: franch_out_arr_cd igs_he_lgcy_spa_int.franch_out_arr_cd%TYPE,
58: employer_role_cd igs_he_lgcy_spa_int.employer_role_cd%TYPE,
59: disadv_uplift_factor igs_he_lgcy_spa_int.disadv_uplift_factor%TYPE,
60: enh_fund_elig_cd igs_he_lgcy_spa_int.enh_fund_elig_cd%TYPE);
61:
62: /*------------------------------------------------------------------
63: --Created by : knaraset, Oracle IDC
64: --Date created: 14-Nov-2002

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

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

Line 86: * @param p_hesa_spa_stats_rec Legacy Student Program Attempt HESA Details record type. Refer to IGS_HE_LGCY_SPA_INT for detail column descriptions.

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