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_GR_GEN_002 dependencies on IGS_GR_GRADUAND_ALL

Line 23: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

19: p_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE DEFAULT NULL
20: ) ;
21:
22: PROCEDURE grdp_ins_gr_hist(
23: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
24: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
25: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
26: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
27: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,

Line 24: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,

20: ) ;
21:
22: PROCEDURE grdp_ins_gr_hist(
23: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
24: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
25: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
26: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
27: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
28: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,

Line 25: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,

21:
22: PROCEDURE grdp_ins_gr_hist(
23: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
24: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
25: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
26: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
27: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
28: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
29: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

Line 26: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,

22: PROCEDURE grdp_ins_gr_hist(
23: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
24: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
25: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
26: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
27: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
28: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
29: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
30: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

Line 27: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,

23: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
24: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
25: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
26: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
27: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
28: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
29: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
30: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
31: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

Line 28: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,

24: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
25: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
26: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
27: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
28: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
29: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
30: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
31: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
32: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

Line 29: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

25: p_old_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
26: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
27: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
28: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
29: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
30: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
31: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
32: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
33: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

Line 30: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

26: p_new_grd_cal_type IGS_GR_GRADUAND_ALL.grd_cal_type%TYPE ,
27: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
28: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
29: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
30: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
31: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
32: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
33: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
34: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

Line 31: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

27: p_old_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
28: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
29: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
30: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
31: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
32: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
33: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
34: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
35: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 32: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

28: p_new_grd_ci_sequence_number IGS_GR_GRADUAND_ALL.grd_ci_sequence_number%TYPE ,
29: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
30: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
31: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
32: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
33: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
34: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
35: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
36: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 33: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

29: p_old_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
30: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
31: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
32: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
33: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
34: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
35: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
36: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
37: p_old_honours_level VARCHAR2 DEFAULT NULL,

Line 34: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

30: p_new_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
31: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
32: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
33: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
34: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
35: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
36: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
37: p_old_honours_level VARCHAR2 DEFAULT NULL,
38: p_new_honours_level VARCHAR2 DEFAULT NULL,

Line 35: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

31: p_old_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
32: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
33: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
34: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
35: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
36: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
37: p_old_honours_level VARCHAR2 DEFAULT NULL,
38: p_new_honours_level VARCHAR2 DEFAULT NULL,
39: p_old_conferral_dt DATE DEFAULT NULL,

Line 36: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

32: p_new_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
33: p_old_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
34: p_new_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
35: p_old_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
36: p_new_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
37: p_old_honours_level VARCHAR2 DEFAULT NULL,
38: p_new_honours_level VARCHAR2 DEFAULT NULL,
39: p_old_conferral_dt DATE DEFAULT NULL,
40: p_new_conferral_dt DATE DEFAULT NULL,

Line 41: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

37: p_old_honours_level VARCHAR2 DEFAULT NULL,
38: p_new_honours_level VARCHAR2 DEFAULT NULL,
39: p_old_conferral_dt DATE DEFAULT NULL,
40: p_new_conferral_dt DATE DEFAULT NULL,
41: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
42: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
43: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
44: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
45: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

Line 42: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

38: p_new_honours_level VARCHAR2 DEFAULT NULL,
39: p_old_conferral_dt DATE DEFAULT NULL,
40: p_new_conferral_dt DATE DEFAULT NULL,
41: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
42: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
43: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
44: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
45: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
46: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

Line 43: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,

39: p_old_conferral_dt DATE DEFAULT NULL,
40: p_new_conferral_dt DATE DEFAULT NULL,
41: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
42: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
43: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
44: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
45: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
46: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
47: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,

Line 44: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,

40: p_new_conferral_dt DATE DEFAULT NULL,
41: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
42: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
43: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
44: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
45: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
46: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
47: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
48: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,

Line 45: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

41: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
42: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
43: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
44: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
45: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
46: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
47: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
48: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
49: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,

Line 46: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

42: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
43: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
44: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
45: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
46: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
47: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
48: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
49: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
50: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,

Line 47: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,

43: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
44: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
45: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
46: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
47: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
48: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
49: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
50: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
51: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,

Line 48: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,

44: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
45: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
46: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
47: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
48: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
49: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
50: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
51: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
52: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,

Line 49: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,

45: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
46: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
47: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
48: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
49: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
50: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
51: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
52: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
53: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,

Line 50: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,

46: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
47: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
48: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
49: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
50: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
51: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
52: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
53: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
54: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,

Line 51: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,

47: p_old_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
48: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
49: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
50: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
51: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
52: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
53: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
54: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
55: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,

Line 52: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,

48: p_new_graduation_name IN IGS_GR_GRADUAND_ALL.graduation_name%TYPE ,
49: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
50: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
51: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
52: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
53: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
54: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
55: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
56: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,

Line 53: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,

49: p_old_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
50: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
51: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
52: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
53: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
54: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
55: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
56: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
57: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

Line 54: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,

50: p_new_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
51: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
52: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
53: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
54: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
55: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
56: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
57: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
58: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

Line 55: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,

51: p_old_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
52: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
53: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
54: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
55: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
56: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
57: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
58: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
59: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

Line 56: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,

52: p_new_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
53: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
54: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
55: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
56: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
57: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
58: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
59: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
60: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

Line 57: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

53: p_old_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
54: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
55: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
56: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
57: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
58: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
59: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
60: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
61: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

Line 58: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

54: p_new_previous_qualifications IGS_GR_GRADUAND_ALL.previous_qualifications%TYPE ,
55: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
56: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
57: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
58: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
59: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
60: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
61: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
62: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

Line 59: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

55: p_old_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
56: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
57: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
58: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
59: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
60: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
61: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
62: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
63: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,

Line 60: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

56: p_new_convocation_memb_ind IGS_GR_GRADUAND_ALL.convocation_membership_ind%TYPE ,
57: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
58: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
59: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
60: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
61: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
62: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
63: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
64: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,

Line 61: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

57: p_old_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
58: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
59: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
60: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
61: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
62: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
63: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
64: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
65: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,

Line 62: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

58: p_new_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
59: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
60: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
61: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
62: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
63: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
64: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
65: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
66: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,

Line 63: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,

59: p_old_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
60: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
61: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
62: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
63: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
64: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
65: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
66: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
67: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,

Line 64: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,

60: p_new_sur_for_crs_version_numb IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
61: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
62: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
63: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
64: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
65: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
66: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
67: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,
68: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE );

Line 65: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,

61: p_old_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
62: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
63: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
64: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
65: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
66: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
67: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,
68: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE );
69:

Line 66: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,

62: p_new_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
63: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
64: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
65: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
66: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
67: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,
68: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE );
69:
70: PROCEDURE grdp_prc_gac(

Line 67: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,

63: p_old_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
64: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
65: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
66: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
67: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,
68: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE );
69:
70: PROCEDURE grdp_prc_gac(
71: errbuf out NOCOPY varchar2,

Line 68: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE );

64: p_new_update_who IGS_GR_GRADUAND_ALL.last_updated_by%TYPE ,
65: p_old_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
66: p_new_update_on IGS_GR_GRADUAND_ALL.last_update_date%TYPE ,
67: p_old_comments IGS_GR_GRADUAND_ALL.comments%TYPE ,
68: p_new_comments IGS_GR_GRADUAND_ALL.comments%TYPE );
69:
70: PROCEDURE grdp_prc_gac(
71: errbuf out NOCOPY varchar2,
72: retcode out NOCOPY number,