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.

[Home] [Help]

APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_AV_LGCY_LVL_INT

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

1: PACKAGE igs_av_lvl_lgcy_pub AS
2: /* $Header: IGSPAV1S.pls 120.2 2006/01/17 03:53:06 ijeddy ship $ */
3: /*#
4: * The Advanced Standing Unit Level Legacy 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_AV_LGCY_LVL_INT interface table.
6: * @rep:scope public
7: * @rep:product IGS
8: * @rep:displayname Import Legacy Level Advanced Standing
9: * @rep:lifecycle active

Line 14: -- RECORD type variable for the table igs_av_lgcy_lvl_int

10: * @rep:compatibility S
11: * @rep:category BUSINESS_ENTITY IGS_ADV_STAND
12: */
13:
14: -- RECORD type variable for the table igs_av_lgcy_lvl_int
15: TYPE lgcy_adstlvl_rec_type IS RECORD
16: (
17: person_number igs_av_lgcy_lvl_int.person_number%TYPE ,
18: program_cd igs_av_lgcy_lvl_int.program_cd%TYPE ,

Line 17: person_number igs_av_lgcy_lvl_int.person_number%TYPE ,

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

Line 18: program_cd igs_av_lgcy_lvl_int.program_cd%TYPE ,

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

Line 19: total_exmptn_approved igs_av_lgcy_lvl_int.total_exmptn_approved%TYPE ,

15: TYPE lgcy_adstlvl_rec_type IS RECORD
16: (
17: person_number igs_av_lgcy_lvl_int.person_number%TYPE ,
18: program_cd igs_av_lgcy_lvl_int.program_cd%TYPE ,
19: total_exmptn_approved igs_av_lgcy_lvl_int.total_exmptn_approved%TYPE ,
20: total_exmptn_granted igs_av_lgcy_lvl_int.total_exmptn_granted%TYPE ,
21: total_exmptn_perc_grntd igs_av_lgcy_lvl_int.total_exmptn_perc_grntd%TYPE ,
22: exemption_institution_cd igs_av_lgcy_lvl_int.exemption_institution_cd%TYPE ,
23: unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,

Line 20: total_exmptn_granted igs_av_lgcy_lvl_int.total_exmptn_granted%TYPE ,

16: (
17: person_number igs_av_lgcy_lvl_int.person_number%TYPE ,
18: program_cd igs_av_lgcy_lvl_int.program_cd%TYPE ,
19: total_exmptn_approved igs_av_lgcy_lvl_int.total_exmptn_approved%TYPE ,
20: total_exmptn_granted igs_av_lgcy_lvl_int.total_exmptn_granted%TYPE ,
21: total_exmptn_perc_grntd igs_av_lgcy_lvl_int.total_exmptn_perc_grntd%TYPE ,
22: exemption_institution_cd igs_av_lgcy_lvl_int.exemption_institution_cd%TYPE ,
23: unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,
24: prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,

Line 21: total_exmptn_perc_grntd igs_av_lgcy_lvl_int.total_exmptn_perc_grntd%TYPE ,

17: person_number igs_av_lgcy_lvl_int.person_number%TYPE ,
18: program_cd igs_av_lgcy_lvl_int.program_cd%TYPE ,
19: total_exmptn_approved igs_av_lgcy_lvl_int.total_exmptn_approved%TYPE ,
20: total_exmptn_granted igs_av_lgcy_lvl_int.total_exmptn_granted%TYPE ,
21: total_exmptn_perc_grntd igs_av_lgcy_lvl_int.total_exmptn_perc_grntd%TYPE ,
22: exemption_institution_cd igs_av_lgcy_lvl_int.exemption_institution_cd%TYPE ,
23: unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,
24: prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,
25: load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,

Line 22: exemption_institution_cd igs_av_lgcy_lvl_int.exemption_institution_cd%TYPE ,

18: program_cd igs_av_lgcy_lvl_int.program_cd%TYPE ,
19: total_exmptn_approved igs_av_lgcy_lvl_int.total_exmptn_approved%TYPE ,
20: total_exmptn_granted igs_av_lgcy_lvl_int.total_exmptn_granted%TYPE ,
21: total_exmptn_perc_grntd igs_av_lgcy_lvl_int.total_exmptn_perc_grntd%TYPE ,
22: exemption_institution_cd igs_av_lgcy_lvl_int.exemption_institution_cd%TYPE ,
23: unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,
24: prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,
25: load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,
26: institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,

Line 23: unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,

19: total_exmptn_approved igs_av_lgcy_lvl_int.total_exmptn_approved%TYPE ,
20: total_exmptn_granted igs_av_lgcy_lvl_int.total_exmptn_granted%TYPE ,
21: total_exmptn_perc_grntd igs_av_lgcy_lvl_int.total_exmptn_perc_grntd%TYPE ,
22: exemption_institution_cd igs_av_lgcy_lvl_int.exemption_institution_cd%TYPE ,
23: unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,
24: prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,
25: load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,
26: institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,
27: s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,

Line 24: prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,

20: total_exmptn_granted igs_av_lgcy_lvl_int.total_exmptn_granted%TYPE ,
21: total_exmptn_perc_grntd igs_av_lgcy_lvl_int.total_exmptn_perc_grntd%TYPE ,
22: exemption_institution_cd igs_av_lgcy_lvl_int.exemption_institution_cd%TYPE ,
23: unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,
24: prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,
25: load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,
26: institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,
27: s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,
28: credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,

Line 25: load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,

21: total_exmptn_perc_grntd igs_av_lgcy_lvl_int.total_exmptn_perc_grntd%TYPE ,
22: exemption_institution_cd igs_av_lgcy_lvl_int.exemption_institution_cd%TYPE ,
23: unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,
24: prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,
25: load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,
26: institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,
27: s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,
28: credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,
29: approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,

Line 26: institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,

22: exemption_institution_cd igs_av_lgcy_lvl_int.exemption_institution_cd%TYPE ,
23: unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,
24: prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,
25: load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,
26: institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,
27: s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,
28: credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,
29: approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,
30: authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,

Line 27: s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,

23: unit_level igs_av_lgcy_lvl_int.unit_level%TYPE ,
24: prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,
25: load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,
26: institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,
27: s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,
28: credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,
29: approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,
30: authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,
31: granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,

Line 28: credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,

24: prog_group_ind igs_av_lgcy_lvl_int.prog_group_ind%TYPE ,
25: load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,
26: institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,
27: s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,
28: credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,
29: approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,
30: authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,
31: granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,
32: expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,

Line 29: approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,

25: load_cal_alt_code igs_av_lgcy_lvl_int.load_cal_alt_code%TYPE ,
26: institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,
27: s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,
28: credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,
29: approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,
30: authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,
31: granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,
32: expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,
33: cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,

Line 30: authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,

26: institution_cd igs_av_lgcy_lvl_int.institution_cd%TYPE ,
27: s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,
28: credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,
29: approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,
30: authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,
31: granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,
32: expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,
33: cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,
34: revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,

Line 31: granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,

27: s_adv_stnd_granting_status igs_av_lgcy_lvl_int.s_adv_stnd_granting_status%TYPE ,
28: credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,
29: approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,
30: authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,
31: granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,
32: expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,
33: cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,
34: revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,
35: comments igs_av_lgcy_lvl_int.comments%TYPE ,

Line 32: expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,

28: credit_points igs_av_lgcy_lvl_int.credit_points%TYPE ,
29: approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,
30: authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,
31: granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,
32: expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,
33: cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,
34: revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,
35: comments igs_av_lgcy_lvl_int.comments%TYPE ,
36: qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,

Line 33: cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,

29: approved_dt igs_av_lgcy_lvl_int.approved_dt%TYPE ,
30: authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,
31: granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,
32: expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,
33: cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,
34: revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,
35: comments igs_av_lgcy_lvl_int.comments%TYPE ,
36: qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,
37: qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,

Line 34: revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,

30: authorising_person_number igs_av_lgcy_lvl_int.authorising_person_number%TYPE ,
31: granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,
32: expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,
33: cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,
34: revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,
35: comments igs_av_lgcy_lvl_int.comments%TYPE ,
36: qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,
37: qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,
38: qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,

Line 35: comments igs_av_lgcy_lvl_int.comments%TYPE ,

31: granted_dt igs_av_lgcy_lvl_int.granted_dt%TYPE ,
32: expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,
33: cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,
34: revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,
35: comments igs_av_lgcy_lvl_int.comments%TYPE ,
36: qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,
37: qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,
38: qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,
39: qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,

Line 36: qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,

32: expiry_dt igs_av_lgcy_lvl_int.expiry_dt%TYPE ,
33: cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,
34: revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,
35: comments igs_av_lgcy_lvl_int.comments%TYPE ,
36: qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,
37: qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,
38: qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,
39: qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,
40: qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,

Line 37: qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,

33: cancelled_dt igs_av_lgcy_lvl_int.cancelled_dt%TYPE ,
34: revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,
35: comments igs_av_lgcy_lvl_int.comments%TYPE ,
36: qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,
37: qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,
38: qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,
39: qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,
40: qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,
41: approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,

Line 38: qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,

34: revoked_dt igs_av_lgcy_lvl_int.revoked_dt%TYPE ,
35: comments igs_av_lgcy_lvl_int.comments%TYPE ,
36: qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,
37: qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,
38: qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,
39: qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,
40: qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,
41: approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,
42: prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,

Line 39: qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,

35: comments igs_av_lgcy_lvl_int.comments%TYPE ,
36: qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,
37: qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,
38: qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,
39: qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,
40: qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,
41: approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,
42: prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,
43: prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,

Line 40: qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,

36: qual_exam_level igs_av_lgcy_lvl_int.qual_exam_level%TYPE ,
37: qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,
38: qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,
39: qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,
40: qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,
41: approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,
42: prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,
43: prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,
44: start_date igs_av_lgcy_lvl_int.start_date%TYPE ,

Line 41: approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,

37: qual_subject_code igs_av_lgcy_lvl_int.qual_subject_code%TYPE ,
38: qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,
39: qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,
40: qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,
41: approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,
42: prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,
43: prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,
44: start_date igs_av_lgcy_lvl_int.start_date%TYPE ,
45: end_date igs_av_lgcy_lvl_int.end_date%TYPE ,

Line 42: prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,

38: qual_year igs_av_lgcy_lvl_int.qual_year%TYPE ,
39: qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,
40: qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,
41: approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,
42: prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,
43: prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,
44: start_date igs_av_lgcy_lvl_int.start_date%TYPE ,
45: end_date igs_av_lgcy_lvl_int.end_date%TYPE ,
46: tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,

Line 43: prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,

39: qual_sitting igs_av_lgcy_lvl_int.qual_sitting%TYPE ,
40: qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,
41: approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,
42: prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,
43: prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,
44: start_date igs_av_lgcy_lvl_int.start_date%TYPE ,
45: end_date igs_av_lgcy_lvl_int.end_date%TYPE ,
46: tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,
47: tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,

Line 44: start_date igs_av_lgcy_lvl_int.start_date%TYPE ,

40: qual_awarding_body igs_av_lgcy_lvl_int.qual_awarding_body%TYPE ,
41: approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,
42: prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,
43: prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,
44: start_date igs_av_lgcy_lvl_int.start_date%TYPE ,
45: end_date igs_av_lgcy_lvl_int.end_date%TYPE ,
46: tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,
47: tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,
48: test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,

Line 45: end_date igs_av_lgcy_lvl_int.end_date%TYPE ,

41: approved_result igs_av_lgcy_lvl_int.approved_result%TYPE ,
42: prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,
43: prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,
44: start_date igs_av_lgcy_lvl_int.start_date%TYPE ,
45: end_date igs_av_lgcy_lvl_int.end_date%TYPE ,
46: tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,
47: tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,
48: test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,
49: basis_program_type igs_av_lgcy_lvl_int.basis_program_type%TYPE ,

Line 46: tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,

42: prev_unit_cd igs_av_lgcy_lvl_int.prev_unit_cd%TYPE ,
43: prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,
44: start_date igs_av_lgcy_lvl_int.start_date%TYPE ,
45: end_date igs_av_lgcy_lvl_int.end_date%TYPE ,
46: tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,
47: tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,
48: test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,
49: basis_program_type igs_av_lgcy_lvl_int.basis_program_type%TYPE ,
50: basis_year igs_av_lgcy_lvl_int.basis_year%TYPE ,

Line 47: tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,

43: prev_term igs_av_lgcy_lvl_int.prev_term%TYPE ,
44: start_date igs_av_lgcy_lvl_int.start_date%TYPE ,
45: end_date igs_av_lgcy_lvl_int.end_date%TYPE ,
46: tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,
47: tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,
48: test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,
49: basis_program_type igs_av_lgcy_lvl_int.basis_program_type%TYPE ,
50: basis_year igs_av_lgcy_lvl_int.basis_year%TYPE ,
51: basis_completion_ind igs_av_lgcy_lvl_int.basis_completion_ind%TYPE ,

Line 48: test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,

44: start_date igs_av_lgcy_lvl_int.start_date%TYPE ,
45: end_date igs_av_lgcy_lvl_int.end_date%TYPE ,
46: tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,
47: tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,
48: test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,
49: basis_program_type igs_av_lgcy_lvl_int.basis_program_type%TYPE ,
50: basis_year igs_av_lgcy_lvl_int.basis_year%TYPE ,
51: basis_completion_ind igs_av_lgcy_lvl_int.basis_completion_ind%TYPE ,
52: unit_level_mark igs_av_lgcy_lvl_int.unit_level_mark%TYPE -- jhanda added unit_level_mark record member

Line 49: basis_program_type igs_av_lgcy_lvl_int.basis_program_type%TYPE ,

45: end_date igs_av_lgcy_lvl_int.end_date%TYPE ,
46: tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,
47: tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,
48: test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,
49: basis_program_type igs_av_lgcy_lvl_int.basis_program_type%TYPE ,
50: basis_year igs_av_lgcy_lvl_int.basis_year%TYPE ,
51: basis_completion_ind igs_av_lgcy_lvl_int.basis_completion_ind%TYPE ,
52: unit_level_mark igs_av_lgcy_lvl_int.unit_level_mark%TYPE -- jhanda added unit_level_mark record member
53:

Line 50: basis_year igs_av_lgcy_lvl_int.basis_year%TYPE ,

46: tst_admission_test_type igs_av_lgcy_lvl_int.tst_admission_test_type%TYPE ,
47: tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,
48: test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,
49: basis_program_type igs_av_lgcy_lvl_int.basis_program_type%TYPE ,
50: basis_year igs_av_lgcy_lvl_int.basis_year%TYPE ,
51: basis_completion_ind igs_av_lgcy_lvl_int.basis_completion_ind%TYPE ,
52: unit_level_mark igs_av_lgcy_lvl_int.unit_level_mark%TYPE -- jhanda added unit_level_mark record member
53:
54:

Line 51: basis_completion_ind igs_av_lgcy_lvl_int.basis_completion_ind%TYPE ,

47: tst_test_date igs_av_lgcy_lvl_int.tst_test_date%TYPE ,
48: test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,
49: basis_program_type igs_av_lgcy_lvl_int.basis_program_type%TYPE ,
50: basis_year igs_av_lgcy_lvl_int.basis_year%TYPE ,
51: basis_completion_ind igs_av_lgcy_lvl_int.basis_completion_ind%TYPE ,
52: unit_level_mark igs_av_lgcy_lvl_int.unit_level_mark%TYPE -- jhanda added unit_level_mark record member
53:
54:
55: );

Line 52: unit_level_mark igs_av_lgcy_lvl_int.unit_level_mark%TYPE -- jhanda added unit_level_mark record member

48: test_segment_name igs_av_lgcy_lvl_int.test_segment_name%TYPE ,
49: basis_program_type igs_av_lgcy_lvl_int.basis_program_type%TYPE ,
50: basis_year igs_av_lgcy_lvl_int.basis_year%TYPE ,
51: basis_completion_ind igs_av_lgcy_lvl_int.basis_completion_ind%TYPE ,
52: unit_level_mark igs_av_lgcy_lvl_int.unit_level_mark%TYPE -- jhanda added unit_level_mark record member
53:
54:
55: );
56:

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

55: );
56:
57: /*#
58: * The Advanced Standing Unit Level Legacy Import process is a public API designed for use in populating rows with data during a system conversion.
59: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AV_LGCY_LVL_INT interface table.
60: * @param p_api_version The version number will be used to compare with claim public api's current version number.Unexpected error is raised if version in-compatibility exists.
61: * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
62: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
63: * @param p_validation_level Public API will always perform full level of validation.

Line 64: * @param p_lgcy_adstlvl_rec Legacy Advanced Standing Unit Level record type. Refer to IGS_AV_LGCY_LVL_INT for detail column descriptions.

60: * @param p_api_version The version number will be used to compare with claim public api's current version number.Unexpected error is raised if version in-compatibility exists.
61: * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
62: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
63: * @param p_validation_level Public API will always perform full level of validation.
64: * @param p_lgcy_adstlvl_rec Legacy Advanced Standing Unit Level record type. Refer to IGS_AV_LGCY_LVL_INT for detail column descriptions.
65: * @param x_return_status The return status values are as follows; Success - FND_API.G_RET_STS_SUCCESS ; Error - FND_API.G_RET_STS_ERROR ; Unexpected error - FND_API.G_RET_STS_UNEXP_ERROR.
66: * @param x_msg_count Message count.
67: * @param x_msg_data Message data.
68: * @rep:scope public