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_001 dependencies on IGS_GR_AWD_CRMN

Line 5: p_person_id IN IGS_GR_AWD_CRMN.person_id%TYPE ,

1: PACKAGE IGS_GR_GEN_001 AUTHID CURRENT_USER AS
2: /* $Header: IGSGR13S.pls 115.4 2002/11/29 00:41:49 nsidana ship $ */
3:
4: FUNCTION grdp_del_gac_hist(
5: p_person_id IN IGS_GR_AWD_CRMN.person_id%TYPE ,
6: p_create_dt IN IGS_GR_AWD_CRMN.create_dt%TYPE ,
7: p_grd_cal_type IN IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
8: p_grd_ci_sequence_number IN IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
9: p_ceremony_number IN IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

Line 6: p_create_dt IN IGS_GR_AWD_CRMN.create_dt%TYPE ,

2: /* $Header: IGSGR13S.pls 115.4 2002/11/29 00:41:49 nsidana ship $ */
3:
4: FUNCTION grdp_del_gac_hist(
5: p_person_id IN IGS_GR_AWD_CRMN.person_id%TYPE ,
6: p_create_dt IN IGS_GR_AWD_CRMN.create_dt%TYPE ,
7: p_grd_cal_type IN IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
8: p_grd_ci_sequence_number IN IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
9: p_ceremony_number IN IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
10: p_award_course_cd IN IGS_GR_AWD_CRMN.award_course_cd%TYPE ,

Line 7: p_grd_cal_type IN IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

3:
4: FUNCTION grdp_del_gac_hist(
5: p_person_id IN IGS_GR_AWD_CRMN.person_id%TYPE ,
6: p_create_dt IN IGS_GR_AWD_CRMN.create_dt%TYPE ,
7: p_grd_cal_type IN IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
8: p_grd_ci_sequence_number IN IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
9: p_ceremony_number IN IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
10: p_award_course_cd IN IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
11: p_award_crs_version_number IN IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,

Line 8: p_grd_ci_sequence_number IN IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

4: FUNCTION grdp_del_gac_hist(
5: p_person_id IN IGS_GR_AWD_CRMN.person_id%TYPE ,
6: p_create_dt IN IGS_GR_AWD_CRMN.create_dt%TYPE ,
7: p_grd_cal_type IN IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
8: p_grd_ci_sequence_number IN IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
9: p_ceremony_number IN IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
10: p_award_course_cd IN IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
11: p_award_crs_version_number IN IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
12: p_award_cd IN IGS_GR_AWD_CRMN.award_cd%TYPE ,

Line 9: p_ceremony_number IN IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

5: p_person_id IN IGS_GR_AWD_CRMN.person_id%TYPE ,
6: p_create_dt IN IGS_GR_AWD_CRMN.create_dt%TYPE ,
7: p_grd_cal_type IN IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
8: p_grd_ci_sequence_number IN IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
9: p_ceremony_number IN IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
10: p_award_course_cd IN IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
11: p_award_crs_version_number IN IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
12: p_award_cd IN IGS_GR_AWD_CRMN.award_cd%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )

Line 10: p_award_course_cd IN IGS_GR_AWD_CRMN.award_course_cd%TYPE ,

6: p_create_dt IN IGS_GR_AWD_CRMN.create_dt%TYPE ,
7: p_grd_cal_type IN IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
8: p_grd_ci_sequence_number IN IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
9: p_ceremony_number IN IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
10: p_award_course_cd IN IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
11: p_award_crs_version_number IN IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
12: p_award_cd IN IGS_GR_AWD_CRMN.award_cd%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN;

Line 11: p_award_crs_version_number IN IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,

7: p_grd_cal_type IN IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
8: p_grd_ci_sequence_number IN IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
9: p_ceremony_number IN IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
10: p_award_course_cd IN IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
11: p_award_crs_version_number IN IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
12: p_award_cd IN IGS_GR_AWD_CRMN.award_cd%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN;
15:

Line 12: p_award_cd IN IGS_GR_AWD_CRMN.award_cd%TYPE ,

8: p_grd_ci_sequence_number IN IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
9: p_ceremony_number IN IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
10: p_award_course_cd IN IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
11: p_award_crs_version_number IN IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
12: p_award_cd IN IGS_GR_AWD_CRMN.award_cd%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN;
15:
16:

Line 45: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,

41: p_course_cd IN VARCHAR2 )
42: RETURN VARCHAR2 ;
43:
44: PROCEDURE grdp_ins_gac_hist(
45: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
46: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
47: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
48: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
49: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

Line 46: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,

42: RETURN VARCHAR2 ;
43:
44: PROCEDURE grdp_ins_gac_hist(
45: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
46: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
47: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
48: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
49: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
50: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,

Line 47: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

43:
44: PROCEDURE grdp_ins_gac_hist(
45: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
46: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
47: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
48: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
49: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
50: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
51: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,

Line 48: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

44: PROCEDURE grdp_ins_gac_hist(
45: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
46: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
47: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
48: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
49: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
50: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
51: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
52: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,

Line 49: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

45: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
46: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
47: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
48: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
49: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
50: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
51: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
52: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
53: p_old_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,

Line 50: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,

46: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
47: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
48: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
49: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
50: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
51: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
52: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
53: p_old_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
54: p_new_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,

Line 51: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,

47: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
48: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
49: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
50: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
51: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
52: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
53: p_old_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
54: p_new_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
55: p_old_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,

Line 52: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,

48: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
49: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
50: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
51: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
52: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
53: p_old_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
54: p_new_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
55: p_old_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
56: p_new_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,

Line 53: p_old_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,

49: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
50: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
51: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
52: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
53: p_old_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
54: p_new_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
55: p_old_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
56: p_new_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
57: p_old_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,

Line 54: p_new_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,

50: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
51: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
52: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
53: p_old_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
54: p_new_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
55: p_old_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
56: p_new_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
57: p_old_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
58: p_new_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,

Line 55: p_old_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,

51: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
52: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
53: p_old_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
54: p_new_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
55: p_old_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
56: p_new_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
57: p_old_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
58: p_new_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
59: p_old_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,

Line 56: p_new_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,

52: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
53: p_old_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
54: p_new_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
55: p_old_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
56: p_new_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
57: p_old_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
58: p_new_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
59: p_old_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
60: p_new_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,

Line 57: p_old_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,

53: p_old_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
54: p_new_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
55: p_old_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
56: p_new_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
57: p_old_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
58: p_new_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
59: p_old_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
60: p_new_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
61: p_old_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,

Line 58: p_new_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,

54: p_new_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
55: p_old_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
56: p_new_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
57: p_old_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
58: p_new_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
59: p_old_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
60: p_new_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
61: p_old_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
62: p_new_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,

Line 59: p_old_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,

55: p_old_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
56: p_new_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
57: p_old_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
58: p_new_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
59: p_old_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
60: p_new_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
61: p_old_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
62: p_new_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
63: p_old_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,

Line 60: p_new_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,

56: p_new_order_in_presentation IGS_GR_AWD_CRMN.order_in_presentation%TYPE ,
57: p_old_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
58: p_new_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
59: p_old_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
60: p_new_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
61: p_old_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
62: p_new_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
63: p_old_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
64: p_new_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,

Line 61: p_old_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,

57: p_old_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
58: p_new_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
59: p_old_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
60: p_new_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
61: p_old_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
62: p_new_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
63: p_old_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
64: p_new_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
65: p_old_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,

Line 62: p_new_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,

58: p_new_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
59: p_old_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
60: p_new_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
61: p_old_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
62: p_new_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
63: p_old_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
64: p_new_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
65: p_old_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
66: p_new_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,

Line 63: p_old_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,

59: p_old_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
60: p_new_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
61: p_old_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
62: p_new_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
63: p_old_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
64: p_new_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
65: p_old_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
66: p_new_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
67: p_old_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,

Line 64: p_new_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,

60: p_new_name_pronunciation IGS_GR_AWD_CRMN.name_pronunciation%TYPE ,
61: p_old_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
62: p_new_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
63: p_old_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
64: p_new_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
65: p_old_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
66: p_new_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
67: p_old_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
68: p_new_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,

Line 65: p_old_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,

61: p_old_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
62: p_new_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
63: p_old_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
64: p_new_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
65: p_old_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
66: p_new_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
67: p_old_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
68: p_new_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
69: p_old_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,

Line 66: p_new_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,

62: p_new_name_announced IGS_GR_AWD_CRMN.name_announced%TYPE ,
63: p_old_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
64: p_new_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
65: p_old_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
66: p_new_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
67: p_old_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
68: p_new_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
69: p_old_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
70: p_new_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,

Line 67: p_old_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,

63: p_old_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
64: p_new_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
65: p_old_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
66: p_new_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
67: p_old_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
68: p_new_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
69: p_old_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
70: p_new_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
71: p_old_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,

Line 68: p_new_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,

64: p_new_academic_dress_rqrd_ind IGS_GR_AWD_CRMN.academic_dress_rqrd_ind%TYPE ,
65: p_old_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
66: p_new_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
67: p_old_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
68: p_new_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
69: p_old_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
70: p_new_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
71: p_old_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
72: p_new_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,

Line 69: p_old_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,

65: p_old_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
66: p_new_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
67: p_old_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
68: p_new_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
69: p_old_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
70: p_new_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
71: p_old_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
72: p_new_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
73: p_old_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,

Line 70: p_new_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,

66: p_new_academic_gown_size IGS_GR_AWD_CRMN.academic_gown_size%TYPE ,
67: p_old_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
68: p_new_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
69: p_old_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
70: p_new_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
71: p_old_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
72: p_new_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
73: p_old_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
74: p_new_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,

Line 71: p_old_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,

67: p_old_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
68: p_new_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
69: p_old_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
70: p_new_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
71: p_old_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
72: p_new_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
73: p_old_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
74: p_new_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
75: p_old_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,

Line 72: p_new_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,

68: p_new_academic_hat_size IGS_GR_AWD_CRMN.academic_hat_size%TYPE ,
69: p_old_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
70: p_new_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
71: p_old_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
72: p_new_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
73: p_old_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
74: p_new_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
75: p_old_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
76: p_new_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,

Line 73: p_old_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,

69: p_old_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
70: p_new_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
71: p_old_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
72: p_new_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
73: p_old_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
74: p_new_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
75: p_old_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
76: p_new_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
77: p_old_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,

Line 74: p_new_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,

70: p_new_guest_tickets_requested IGS_GR_AWD_CRMN.guest_tickets_requested%TYPE ,
71: p_old_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
72: p_new_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
73: p_old_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
74: p_new_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
75: p_old_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
76: p_new_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
77: p_old_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
78: p_new_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,

Line 75: p_old_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,

71: p_old_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
72: p_new_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
73: p_old_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
74: p_new_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
75: p_old_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
76: p_new_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
77: p_old_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
78: p_new_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
79: p_old_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,

Line 76: p_new_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,

72: p_new_guest_tickets_allocated IGS_GR_AWD_CRMN.guest_tickets_allocated%TYPE ,
73: p_old_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
74: p_new_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
75: p_old_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
76: p_new_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
77: p_old_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
78: p_new_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
79: p_old_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
80: p_new_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,

Line 77: p_old_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,

73: p_old_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
74: p_new_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
75: p_old_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
76: p_new_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
77: p_old_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
78: p_new_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
79: p_old_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
80: p_new_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
81: p_old_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,

Line 78: p_new_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,

74: p_new_guest_seats IGS_GR_AWD_CRMN.guest_seats%TYPE ,
75: p_old_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
76: p_new_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
77: p_old_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
78: p_new_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
79: p_old_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
80: p_new_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
81: p_old_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
82: p_new_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,

Line 79: p_old_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,

75: p_old_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
76: p_new_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
77: p_old_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
78: p_new_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
79: p_old_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
80: p_new_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
81: p_old_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
82: p_new_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
83: p_old_comments IGS_GR_AWD_CRMN.comments%TYPE ,

Line 80: p_new_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,

76: p_new_fees_paid_ind IGS_GR_AWD_CRMN.fees_paid_ind%TYPE ,
77: p_old_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
78: p_new_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
79: p_old_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
80: p_new_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
81: p_old_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
82: p_new_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
83: p_old_comments IGS_GR_AWD_CRMN.comments%TYPE ,
84: p_new_comments IGS_GR_AWD_CRMN.comments%TYPE ) ;

Line 81: p_old_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,

77: p_old_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
78: p_new_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
79: p_old_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
80: p_new_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
81: p_old_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
82: p_new_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
83: p_old_comments IGS_GR_AWD_CRMN.comments%TYPE ,
84: p_new_comments IGS_GR_AWD_CRMN.comments%TYPE ) ;
85:

Line 82: p_new_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,

78: p_new_update_who IGS_GR_AWD_CRMN.last_updated_by%TYPE ,
79: p_old_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
80: p_new_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
81: p_old_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
82: p_new_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
83: p_old_comments IGS_GR_AWD_CRMN.comments%TYPE ,
84: p_new_comments IGS_GR_AWD_CRMN.comments%TYPE ) ;
85:
86: END IGS_GR_GEN_001 ;

Line 83: p_old_comments IGS_GR_AWD_CRMN.comments%TYPE ,

79: p_old_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
80: p_new_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
81: p_old_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
82: p_new_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
83: p_old_comments IGS_GR_AWD_CRMN.comments%TYPE ,
84: p_new_comments IGS_GR_AWD_CRMN.comments%TYPE ) ;
85:
86: END IGS_GR_GEN_001 ;

Line 84: p_new_comments IGS_GR_AWD_CRMN.comments%TYPE ) ;

80: p_new_update_on IGS_GR_AWD_CRMN.last_update_date%TYPE ,
81: p_old_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
82: p_new_special_requirements IGS_GR_AWD_CRMN.special_requirements%TYPE ,
83: p_old_comments IGS_GR_AWD_CRMN.comments%TYPE ,
84: p_new_comments IGS_GR_AWD_CRMN.comments%TYPE ) ;
85:
86: END IGS_GR_GEN_001 ;