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 9: p_person_id IN igs_gr_awd_crmn.person_id%TYPE,

5: --
6: -- Deletes the Graduand Award Ceremony History records.
7: --
8: FUNCTION grdp_del_gac_hist (
9: p_person_id IN igs_gr_awd_crmn.person_id%TYPE,
10: p_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
11: p_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
12: p_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
13: p_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,

Line 10: p_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,

6: -- Deletes the Graduand Award Ceremony History records.
7: --
8: FUNCTION grdp_del_gac_hist (
9: p_person_id IN igs_gr_awd_crmn.person_id%TYPE,
10: p_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
11: p_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
12: p_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
13: p_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
14: p_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,

Line 11: p_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,

7: --
8: FUNCTION grdp_del_gac_hist (
9: p_person_id IN igs_gr_awd_crmn.person_id%TYPE,
10: p_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
11: p_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
12: p_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
13: p_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
14: p_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
15: p_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,

Line 12: p_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,

8: FUNCTION grdp_del_gac_hist (
9: p_person_id IN igs_gr_awd_crmn.person_id%TYPE,
10: p_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
11: p_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
12: p_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
13: p_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
14: p_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
15: p_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,
16: p_award_cd IN igs_gr_awd_crmn.award_cd%TYPE,

Line 13: p_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,

9: p_person_id IN igs_gr_awd_crmn.person_id%TYPE,
10: p_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
11: p_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
12: p_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
13: p_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
14: p_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
15: p_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,
16: p_award_cd IN igs_gr_awd_crmn.award_cd%TYPE,
17: p_message_name OUT NOCOPY VARCHAR2

Line 14: p_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,

10: p_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
11: p_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
12: p_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
13: p_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
14: p_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
15: p_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,
16: p_award_cd IN igs_gr_awd_crmn.award_cd%TYPE,
17: p_message_name OUT NOCOPY VARCHAR2
18: ) RETURN BOOLEAN AS

Line 15: p_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,

11: p_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
12: p_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
13: p_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
14: p_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
15: p_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,
16: p_award_cd IN igs_gr_awd_crmn.award_cd%TYPE,
17: p_message_name OUT NOCOPY VARCHAR2
18: ) RETURN BOOLEAN AS
19: BEGIN -- grdp_del_gac_hist

Line 16: p_award_cd IN igs_gr_awd_crmn.award_cd%TYPE,

12: p_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
13: p_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
14: p_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
15: p_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,
16: p_award_cd IN igs_gr_awd_crmn.award_cd%TYPE,
17: p_message_name OUT NOCOPY VARCHAR2
18: ) RETURN BOOLEAN AS
19: BEGIN -- grdp_del_gac_hist
20: --

Line 37: cp_person_id igs_gr_awd_crmn.person_id%TYPE,

33: END IF;
34: --
35: DECLARE
36: CURSOR c_gach (
37: cp_person_id igs_gr_awd_crmn.person_id%TYPE,
38: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
39: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
40: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
41: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,

Line 38: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,

34: --
35: DECLARE
36: CURSOR c_gach (
37: cp_person_id igs_gr_awd_crmn.person_id%TYPE,
38: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
39: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
40: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
41: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
42: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,

Line 39: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,

35: DECLARE
36: CURSOR c_gach (
37: cp_person_id igs_gr_awd_crmn.person_id%TYPE,
38: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
39: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
40: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
41: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
42: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
43: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,

Line 40: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,

36: CURSOR c_gach (
37: cp_person_id igs_gr_awd_crmn.person_id%TYPE,
38: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
39: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
40: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
41: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
42: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
43: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
44: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE

Line 41: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,

37: cp_person_id igs_gr_awd_crmn.person_id%TYPE,
38: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
39: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
40: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
41: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
42: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
43: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
44: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
45: ) IS

Line 42: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,

38: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
39: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
40: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
41: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
42: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
43: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
44: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
45: ) IS
46: SELECT person_id

Line 43: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,

39: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
40: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
41: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
42: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
43: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
44: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
45: ) IS
46: SELECT person_id
47: FROM igs_gr_awd_crmn_hist

Line 44: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE

40: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
41: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
42: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
43: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
44: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
45: ) IS
46: SELECT person_id
47: FROM igs_gr_awd_crmn_hist
48: WHERE person_id = cp_person_id

Line 47: FROM igs_gr_awd_crmn_hist

43: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
44: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
45: ) IS
46: SELECT person_id
47: FROM igs_gr_awd_crmn_hist
48: WHERE person_id = cp_person_id
49: AND create_dt = cp_create_dt
50: AND grd_cal_type = cp_grd_cal_type
51: AND grd_ci_sequence_number = cp_grd_ci_sequence_number

Line 64: pl_person_id IN igs_gr_awd_crmn.person_id%TYPE,

60: -- table or rows are locked. Otherwise, it will delete the appropriate records
61: -- from the table and return true.
62: --
63: FUNCTION grdpl_del_if_not_locked (
64: pl_person_id IN igs_gr_awd_crmn.person_id%TYPE,
65: pl_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
66: pl_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
67: pl_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
68: pl_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,

Line 65: pl_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,

61: -- from the table and return true.
62: --
63: FUNCTION grdpl_del_if_not_locked (
64: pl_person_id IN igs_gr_awd_crmn.person_id%TYPE,
65: pl_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
66: pl_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
67: pl_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
68: pl_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
69: pl_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,

Line 66: pl_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,

62: --
63: FUNCTION grdpl_del_if_not_locked (
64: pl_person_id IN igs_gr_awd_crmn.person_id%TYPE,
65: pl_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
66: pl_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
67: pl_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
68: pl_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
69: pl_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
70: pl_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,

Line 67: pl_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,

63: FUNCTION grdpl_del_if_not_locked (
64: pl_person_id IN igs_gr_awd_crmn.person_id%TYPE,
65: pl_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
66: pl_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
67: pl_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
68: pl_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
69: pl_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
70: pl_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,
71: pl_award_cd IN igs_gr_awd_crmn.award_cd%TYPE

Line 68: pl_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,

64: pl_person_id IN igs_gr_awd_crmn.person_id%TYPE,
65: pl_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
66: pl_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
67: pl_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
68: pl_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
69: pl_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
70: pl_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,
71: pl_award_cd IN igs_gr_awd_crmn.award_cd%TYPE
72: ) RETURN BOOLEAN AS

Line 69: pl_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,

65: pl_create_dt IN igs_gr_awd_crmn.create_dt%TYPE,
66: pl_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
67: pl_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
68: pl_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
69: pl_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
70: pl_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,
71: pl_award_cd IN igs_gr_awd_crmn.award_cd%TYPE
72: ) RETURN BOOLEAN AS
73: --

Line 70: pl_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,

66: pl_grd_cal_type IN igs_gr_awd_crmn.grd_cal_type%TYPE,
67: pl_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
68: pl_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
69: pl_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
70: pl_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,
71: pl_award_cd IN igs_gr_awd_crmn.award_cd%TYPE
72: ) RETURN BOOLEAN AS
73: --
74: e_resource_busy_exception EXCEPTION;

Line 71: pl_award_cd IN igs_gr_awd_crmn.award_cd%TYPE

67: pl_grd_ci_sequence_number IN igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
68: pl_ceremony_number IN igs_gr_awd_crmn.ceremony_number%TYPE,
69: pl_award_course_cd IN igs_gr_awd_crmn.award_course_cd%TYPE,
70: pl_award_crs_version_number IN igs_gr_awd_crmn.award_crs_version_number%TYPE,
71: pl_award_cd IN igs_gr_awd_crmn.award_cd%TYPE
72: ) RETURN BOOLEAN AS
73: --
74: e_resource_busy_exception EXCEPTION;
75: PRAGMA EXCEPTION_INIT (e_resource_busy_exception, -54);

Line 95: cp_person_id igs_gr_awd_crmn.person_id%TYPE,

91: END IF;
92: --
93: DECLARE
94: CURSOR c_gach (
95: cp_person_id igs_gr_awd_crmn.person_id%TYPE,
96: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
97: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
98: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
99: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,

Line 96: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,

92: --
93: DECLARE
94: CURSOR c_gach (
95: cp_person_id igs_gr_awd_crmn.person_id%TYPE,
96: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
97: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
98: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
99: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
100: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,

Line 97: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,

93: DECLARE
94: CURSOR c_gach (
95: cp_person_id igs_gr_awd_crmn.person_id%TYPE,
96: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
97: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
98: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
99: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
100: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
101: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,

Line 98: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,

94: CURSOR c_gach (
95: cp_person_id igs_gr_awd_crmn.person_id%TYPE,
96: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
97: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
98: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
99: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
100: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
101: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
102: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE

Line 99: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,

95: cp_person_id igs_gr_awd_crmn.person_id%TYPE,
96: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
97: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
98: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
99: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
100: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
101: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
102: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
103: ) IS

Line 100: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,

96: cp_create_dt igs_gr_awd_crmn.create_dt%TYPE,
97: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
98: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
99: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
100: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
101: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
102: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
103: ) IS
104: SELECT ROWID,

Line 101: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,

97: cp_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
98: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
99: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
100: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
101: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
102: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
103: ) IS
104: SELECT ROWID,
105: person_id

Line 102: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE

98: cp_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
99: cp_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
100: cp_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
101: cp_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
102: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
103: ) IS
104: SELECT ROWID,
105: person_id
106: FROM igs_gr_awd_crmn_hist

Line 106: FROM igs_gr_awd_crmn_hist

102: cp_award_cd igs_gr_awd_crmn.award_cd%TYPE
103: ) IS
104: SELECT ROWID,
105: person_id
106: FROM igs_gr_awd_crmn_hist
107: WHERE person_id = cp_person_id
108: AND create_dt = cp_create_dt
109: AND grd_cal_type = cp_grd_cal_type
110: AND grd_ci_sequence_number = cp_grd_ci_sequence_number

Line 128: igs_gr_awd_crmn_hist_pkg.delete_row (x_rowid => v_gach_rec.ROWID);

124: p_award_course_cd,
125: p_award_crs_version_number,
126: p_award_cd
127: ) LOOP
128: igs_gr_awd_crmn_hist_pkg.delete_row (x_rowid => v_gach_rec.ROWID);
129: END LOOP;
130: --
131: RETURN TRUE;
132: END;

Line 252: FROM igs_gr_awd_crmn gac

248: FROM igs_gr_graduand_all gr
249: WHERE gr.person_id = cp_gr_person_id
250: AND gr.create_dt = cp_gr_create_dt
251: AND NOT EXISTS (SELECT 'X'
252: FROM igs_gr_awd_crmn gac
253: WHERE gac.person_id = cp_gr_person_id
254: AND gac.create_dt = cp_gr_create_dt)
255: FOR UPDATE OF gr.person_id NOWAIT;
256: --

Line 272: FROM igs_gr_awd_crmn gac

268: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
269: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
270: ) IS
271: SELECT ROWID
272: FROM igs_gr_awd_crmn gac
273: WHERE gac.person_id = cp_gr_person_id
274: AND gac.create_dt = cp_gr_create_dt
275: FOR UPDATE OF gac.person_id NOWAIT;
276: --

Line 282: FROM igs_gr_awd_crmn_hist gach

278: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
279: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
280: ) IS
281: SELECT ROWID
282: FROM igs_gr_awd_crmn_hist gach
283: WHERE gach.person_id = cp_gr_person_id
284: AND gach.create_dt = cp_gr_create_dt
285: AND gach.grd_cal_type = p_grd_cal_type
286: AND gach.grd_ci_sequence_number = p_grd_ci_sequence_number

Line 323: igs_gr_awd_crmn_pkg.delete_row (x_rowid => v_gac_rec.ROWID);

319: --
320: -- 4.1 Delete any Graduand Award Ceremony records found.
321: --
322: FOR v_gac_rec IN c_gac (v_gr_rec.person_id, v_gr_rec.create_dt) LOOP
323: igs_gr_awd_crmn_pkg.delete_row (x_rowid => v_gac_rec.ROWID);
324: END LOOP;
325: --
326: -- 4.2 Delete any Graduand Award Ceremony History records found.
327: --

Line 329: igs_gr_awd_crmn_hist_pkg.delete_row (x_rowid => v_gach_rec.ROWID);

325: --
326: -- 4.2 Delete any Graduand Award Ceremony History records found.
327: --
328: FOR v_gach_rec IN c_gach (v_gr_rec.person_id, v_gr_rec.create_dt) LOOP
329: igs_gr_awd_crmn_hist_pkg.delete_row (x_rowid => v_gach_rec.ROWID);
330: END LOOP;
331: --
332: EXCEPTION
333: WHEN e_resource_busy THEN

Line 679: p_person_id igs_gr_awd_crmn.person_id%TYPE,

675: --
676: -- Insert Graduand Award Ceremony History
677: --
678: PROCEDURE grdp_ins_gac_hist (
679: p_person_id igs_gr_awd_crmn.person_id%TYPE,
680: p_create_dt igs_gr_awd_crmn.create_dt%TYPE,
681: p_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
682: p_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
683: p_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,

Line 680: p_create_dt igs_gr_awd_crmn.create_dt%TYPE,

676: -- Insert Graduand Award Ceremony History
677: --
678: PROCEDURE grdp_ins_gac_hist (
679: p_person_id igs_gr_awd_crmn.person_id%TYPE,
680: p_create_dt igs_gr_awd_crmn.create_dt%TYPE,
681: p_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
682: p_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
683: p_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
684: p_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,

Line 681: p_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,

677: --
678: PROCEDURE grdp_ins_gac_hist (
679: p_person_id igs_gr_awd_crmn.person_id%TYPE,
680: p_create_dt igs_gr_awd_crmn.create_dt%TYPE,
681: p_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
682: p_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
683: p_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
684: p_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
685: p_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,

Line 682: p_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,

678: PROCEDURE grdp_ins_gac_hist (
679: p_person_id igs_gr_awd_crmn.person_id%TYPE,
680: p_create_dt igs_gr_awd_crmn.create_dt%TYPE,
681: p_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
682: p_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
683: p_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
684: p_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
685: p_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
686: p_award_cd igs_gr_awd_crmn.award_cd%TYPE,

Line 683: p_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,

679: p_person_id igs_gr_awd_crmn.person_id%TYPE,
680: p_create_dt igs_gr_awd_crmn.create_dt%TYPE,
681: p_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
682: p_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
683: p_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
684: p_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
685: p_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
686: p_award_cd igs_gr_awd_crmn.award_cd%TYPE,
687: p_old_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,

Line 684: p_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,

680: p_create_dt igs_gr_awd_crmn.create_dt%TYPE,
681: p_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
682: p_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
683: p_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
684: p_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
685: p_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
686: p_award_cd igs_gr_awd_crmn.award_cd%TYPE,
687: p_old_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
688: p_new_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,

Line 685: p_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,

681: p_grd_cal_type igs_gr_awd_crmn.grd_cal_type%TYPE,
682: p_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
683: p_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
684: p_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
685: p_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
686: p_award_cd igs_gr_awd_crmn.award_cd%TYPE,
687: p_old_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
688: p_new_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
689: p_old_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,

Line 686: p_award_cd igs_gr_awd_crmn.award_cd%TYPE,

682: p_grd_ci_sequence_number igs_gr_awd_crmn.grd_ci_sequence_number%TYPE,
683: p_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
684: p_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
685: p_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
686: p_award_cd igs_gr_awd_crmn.award_cd%TYPE,
687: p_old_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
688: p_new_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
689: p_old_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
690: p_new_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,

Line 687: p_old_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,

683: p_ceremony_number igs_gr_awd_crmn.ceremony_number%TYPE,
684: p_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
685: p_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
686: p_award_cd igs_gr_awd_crmn.award_cd%TYPE,
687: p_old_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
688: p_new_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
689: p_old_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
690: p_new_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
691: p_old_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,

Line 688: p_new_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,

684: p_award_course_cd igs_gr_awd_crmn.award_course_cd%TYPE,
685: p_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
686: p_award_cd igs_gr_awd_crmn.award_cd%TYPE,
687: p_old_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
688: p_new_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
689: p_old_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
690: p_new_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
691: p_old_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
692: p_new_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,

Line 689: p_old_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,

685: p_award_crs_version_number igs_gr_awd_crmn.award_crs_version_number%TYPE,
686: p_award_cd igs_gr_awd_crmn.award_cd%TYPE,
687: p_old_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
688: p_new_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
689: p_old_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
690: p_new_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
691: p_old_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
692: p_new_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
693: p_old_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,

Line 690: p_new_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,

686: p_award_cd igs_gr_awd_crmn.award_cd%TYPE,
687: p_old_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
688: p_new_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
689: p_old_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
690: p_new_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
691: p_old_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
692: p_new_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
693: p_old_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
694: p_new_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,

Line 691: p_old_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,

687: p_old_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
688: p_new_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
689: p_old_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
690: p_new_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
691: p_old_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
692: p_new_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
693: p_old_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
694: p_new_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
695: p_old_name_announced igs_gr_awd_crmn.name_announced%TYPE,

Line 692: p_new_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,

688: p_new_us_group_number igs_gr_awd_crmn.us_group_number%TYPE,
689: p_old_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
690: p_new_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
691: p_old_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
692: p_new_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
693: p_old_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
694: p_new_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
695: p_old_name_announced igs_gr_awd_crmn.name_announced%TYPE,
696: p_new_name_announced igs_gr_awd_crmn.name_announced%TYPE,

Line 693: p_old_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,

689: p_old_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
690: p_new_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
691: p_old_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
692: p_new_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
693: p_old_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
694: p_new_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
695: p_old_name_announced igs_gr_awd_crmn.name_announced%TYPE,
696: p_new_name_announced igs_gr_awd_crmn.name_announced%TYPE,
697: p_old_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,

Line 694: p_new_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,

690: p_new_order_in_presentation igs_gr_awd_crmn.order_in_presentation%TYPE,
691: p_old_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
692: p_new_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
693: p_old_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
694: p_new_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
695: p_old_name_announced igs_gr_awd_crmn.name_announced%TYPE,
696: p_new_name_announced igs_gr_awd_crmn.name_announced%TYPE,
697: p_old_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
698: p_new_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,

Line 695: p_old_name_announced igs_gr_awd_crmn.name_announced%TYPE,

691: p_old_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
692: p_new_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
693: p_old_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
694: p_new_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
695: p_old_name_announced igs_gr_awd_crmn.name_announced%TYPE,
696: p_new_name_announced igs_gr_awd_crmn.name_announced%TYPE,
697: p_old_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
698: p_new_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
699: p_old_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,

Line 696: p_new_name_announced igs_gr_awd_crmn.name_announced%TYPE,

692: p_new_graduand_seat_number igs_gr_awd_crmn.graduand_seat_number%TYPE,
693: p_old_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
694: p_new_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
695: p_old_name_announced igs_gr_awd_crmn.name_announced%TYPE,
696: p_new_name_announced igs_gr_awd_crmn.name_announced%TYPE,
697: p_old_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
698: p_new_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
699: p_old_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
700: p_new_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,

Line 697: p_old_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,

693: p_old_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
694: p_new_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
695: p_old_name_announced igs_gr_awd_crmn.name_announced%TYPE,
696: p_new_name_announced igs_gr_awd_crmn.name_announced%TYPE,
697: p_old_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
698: p_new_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
699: p_old_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
700: p_new_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
701: p_old_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,

Line 698: p_new_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,

694: p_new_name_pronunciation igs_gr_awd_crmn.name_pronunciation%TYPE,
695: p_old_name_announced igs_gr_awd_crmn.name_announced%TYPE,
696: p_new_name_announced igs_gr_awd_crmn.name_announced%TYPE,
697: p_old_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
698: p_new_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
699: p_old_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
700: p_new_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
701: p_old_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
702: p_new_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,

Line 699: p_old_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,

695: p_old_name_announced igs_gr_awd_crmn.name_announced%TYPE,
696: p_new_name_announced igs_gr_awd_crmn.name_announced%TYPE,
697: p_old_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
698: p_new_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
699: p_old_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
700: p_new_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
701: p_old_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
702: p_new_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
703: p_old_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,

Line 700: p_new_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,

696: p_new_name_announced igs_gr_awd_crmn.name_announced%TYPE,
697: p_old_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
698: p_new_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
699: p_old_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
700: p_new_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
701: p_old_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
702: p_new_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
703: p_old_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
704: p_new_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,

Line 701: p_old_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,

697: p_old_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
698: p_new_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
699: p_old_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
700: p_new_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
701: p_old_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
702: p_new_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
703: p_old_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
704: p_new_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
705: p_old_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,

Line 702: p_new_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,

698: p_new_academic_dress_rqrd_ind igs_gr_awd_crmn.academic_dress_rqrd_ind%TYPE,
699: p_old_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
700: p_new_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
701: p_old_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
702: p_new_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
703: p_old_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
704: p_new_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
705: p_old_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
706: p_new_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,

Line 703: p_old_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,

699: p_old_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
700: p_new_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
701: p_old_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
702: p_new_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
703: p_old_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
704: p_new_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
705: p_old_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
706: p_new_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
707: p_old_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,

Line 704: p_new_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,

700: p_new_academic_gown_size igs_gr_awd_crmn.academic_gown_size%TYPE,
701: p_old_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
702: p_new_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
703: p_old_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
704: p_new_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
705: p_old_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
706: p_new_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
707: p_old_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
708: p_new_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,

Line 705: p_old_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,

701: p_old_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
702: p_new_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
703: p_old_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
704: p_new_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
705: p_old_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
706: p_new_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
707: p_old_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
708: p_new_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
709: p_old_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,

Line 706: p_new_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,

702: p_new_academic_hat_size igs_gr_awd_crmn.academic_hat_size%TYPE,
703: p_old_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
704: p_new_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
705: p_old_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
706: p_new_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
707: p_old_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
708: p_new_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
709: p_old_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
710: p_new_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,

Line 707: p_old_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,

703: p_old_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
704: p_new_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
705: p_old_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
706: p_new_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
707: p_old_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
708: p_new_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
709: p_old_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
710: p_new_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
711: p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,

Line 708: p_new_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,

704: p_new_guest_tickets_requested igs_gr_awd_crmn.guest_tickets_requested%TYPE,
705: p_old_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
706: p_new_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
707: p_old_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
708: p_new_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
709: p_old_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
710: p_new_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
711: p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
712: p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,

Line 709: p_old_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,

705: p_old_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
706: p_new_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
707: p_old_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
708: p_new_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
709: p_old_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
710: p_new_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
711: p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
712: p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
713: p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,

Line 710: p_new_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,

706: p_new_guest_tickets_allocated igs_gr_awd_crmn.guest_tickets_allocated%TYPE,
707: p_old_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
708: p_new_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
709: p_old_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
710: p_new_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
711: p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
712: p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
713: p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,
714: p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,

Line 711: p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,

707: p_old_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
708: p_new_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
709: p_old_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
710: p_new_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
711: p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
712: p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
713: p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,
714: p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,
715: p_old_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,

Line 712: p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,

708: p_new_guest_seats igs_gr_awd_crmn.guest_seats%TYPE,
709: p_old_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
710: p_new_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
711: p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
712: p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
713: p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,
714: p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,
715: p_old_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
716: p_new_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,

Line 713: p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,

709: p_old_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
710: p_new_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
711: p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
712: p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
713: p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,
714: p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,
715: p_old_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
716: p_new_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
717: p_old_comments igs_gr_awd_crmn.comments%TYPE,

Line 714: p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,

710: p_new_fees_paid_ind igs_gr_awd_crmn.fees_paid_ind%TYPE,
711: p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
712: p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
713: p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,
714: p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,
715: p_old_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
716: p_new_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
717: p_old_comments igs_gr_awd_crmn.comments%TYPE,
718: p_new_comments igs_gr_awd_crmn.comments%TYPE

Line 715: p_old_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,

711: p_old_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
712: p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
713: p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,
714: p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,
715: p_old_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
716: p_new_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
717: p_old_comments igs_gr_awd_crmn.comments%TYPE,
718: p_new_comments igs_gr_awd_crmn.comments%TYPE
719: ) AS

Line 716: p_new_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,

712: p_new_update_who igs_gr_awd_crmn.last_updated_by%TYPE,
713: p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,
714: p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,
715: p_old_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
716: p_new_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
717: p_old_comments igs_gr_awd_crmn.comments%TYPE,
718: p_new_comments igs_gr_awd_crmn.comments%TYPE
719: ) AS
720: BEGIN -- grdp_ins_gr_hist

Line 717: p_old_comments igs_gr_awd_crmn.comments%TYPE,

713: p_old_update_on igs_gr_awd_crmn.last_update_date%TYPE,
714: p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,
715: p_old_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
716: p_new_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
717: p_old_comments igs_gr_awd_crmn.comments%TYPE,
718: p_new_comments igs_gr_awd_crmn.comments%TYPE
719: ) AS
720: BEGIN -- grdp_ins_gr_hist
721: --

Line 718: p_new_comments igs_gr_awd_crmn.comments%TYPE

714: p_new_update_on igs_gr_awd_crmn.last_update_date%TYPE,
715: p_old_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
716: p_new_special_requirements igs_gr_awd_crmn.special_requirements%TYPE,
717: p_old_comments igs_gr_awd_crmn.comments%TYPE,
718: p_new_comments igs_gr_awd_crmn.comments%TYPE
719: ) AS
720: BEGIN -- grdp_ins_gr_hist
721: --
722: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 769: v_gac_rec igs_gr_awd_crmn_hist%ROWTYPE;

765: );
766: END IF;
767: --
768: DECLARE
769: v_gac_rec igs_gr_awd_crmn_hist%ROWTYPE;
770: v_create_history BOOLEAN DEFAULT FALSE;
771: BEGIN
772: --
773: -- If any of the old values (p_old_) are different from the

Line 877: igs_gr_awd_crmn_hist_pkg.insert_row (

873: DECLARE
874: lv_rowid VARCHAR2 (25);
875: lv_seqnc NUMBER;
876: BEGIN
877: igs_gr_awd_crmn_hist_pkg.insert_row (
878: x_rowid => lv_rowid,
879: x_gach_id => lv_seqnc,
880: x_name_pronunciation => v_gac_rec.name_pronunciation,
881: x_name_announced => v_gac_rec.name_announced,