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

Line 13: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,

9: -- removed .
10: -------------------------------------------------------------------------------------------
11: -- Validate graduand award ceremony insert.
12: FUNCTION grdp_val_gac_insert(
13: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
14: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
15: p_message_name OUT NOCOPY VARCHAR2 )
16: RETURN BOOLEAN;
17: --

Line 14: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,

10: -------------------------------------------------------------------------------------------
11: -- Validate graduand award ceremony insert.
12: FUNCTION grdp_val_gac_insert(
13: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
14: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
15: p_message_name OUT NOCOPY VARCHAR2 )
16: RETURN BOOLEAN;
17: --
18: -- Validate inserting or updating a IGS_GR_GRADUAND IGS_PS_AWD ceremony.

Line 20: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

16: RETURN BOOLEAN;
17: --
18: -- Validate inserting or updating a IGS_GR_GRADUAND IGS_PS_AWD ceremony.
19: FUNCTION grdp_val_gac_iu(
20: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
21: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
22: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
23: p_message_name OUT NOCOPY VARCHAR2 )
24: RETURN BOOLEAN;

Line 21: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

17: --
18: -- Validate inserting or updating a IGS_GR_GRADUAND IGS_PS_AWD ceremony.
19: FUNCTION grdp_val_gac_iu(
20: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
21: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
22: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
23: p_message_name OUT NOCOPY VARCHAR2 )
24: RETURN BOOLEAN;
25: --

Line 22: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

18: -- Validate inserting or updating a IGS_GR_GRADUAND IGS_PS_AWD ceremony.
19: FUNCTION grdp_val_gac_iu(
20: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
21: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
22: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
23: p_message_name OUT NOCOPY VARCHAR2 )
24: RETURN BOOLEAN;
25: --
26: -- Validate inserting or updating a graduand award ceremony.

Line 28: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,

24: RETURN BOOLEAN;
25: --
26: -- Validate inserting or updating a graduand award ceremony.
27: FUNCTION grdp_val_gac_rqrd(
28: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
29: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
30: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
31: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
32: p_academic_dress_rqrd_ind VARCHAR2 DEFAULT 'N',

Line 29: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,

25: --
26: -- Validate inserting or updating a graduand award ceremony.
27: FUNCTION grdp_val_gac_rqrd(
28: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
29: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
30: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
31: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
32: p_academic_dress_rqrd_ind VARCHAR2 DEFAULT 'N',
33: p_academic_gown_size VARCHAR2 ,

Line 30: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,

26: -- Validate inserting or updating a graduand award ceremony.
27: FUNCTION grdp_val_gac_rqrd(
28: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
29: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
30: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
31: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
32: p_academic_dress_rqrd_ind VARCHAR2 DEFAULT 'N',
33: p_academic_gown_size VARCHAR2 ,
34: p_academic_hat_size VARCHAR2 ,

Line 31: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,

27: FUNCTION grdp_val_gac_rqrd(
28: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
29: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
30: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
31: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
32: p_academic_dress_rqrd_ind VARCHAR2 DEFAULT 'N',
33: p_academic_gown_size VARCHAR2 ,
34: p_academic_hat_size VARCHAR2 ,
35: p_message_name OUT NOCOPY VARCHAR2 )

Line 40: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,

36: RETURN BOOLEAN;
37: --
38: -- Validate graduand seat number is unique for the person.
39: FUNCTION grdp_val_gac_seat(
40: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
41: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
42: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
43: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
44: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,

Line 41: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

37: --
38: -- Validate graduand seat number is unique for the person.
39: FUNCTION grdp_val_gac_seat(
40: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
41: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
42: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
43: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
44: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
45: p_message_name OUT NOCOPY VARCHAR2 )

Line 42: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

38: -- Validate graduand seat number is unique for the person.
39: FUNCTION grdp_val_gac_seat(
40: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
41: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
42: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
43: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
44: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
45: p_message_name OUT NOCOPY VARCHAR2 )
46: RETURN BOOLEAN;

Line 43: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

39: FUNCTION grdp_val_gac_seat(
40: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
41: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
42: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
43: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
44: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
45: p_message_name OUT NOCOPY VARCHAR2 )
46: RETURN BOOLEAN;
47: --

Line 44: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,

40: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
41: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
42: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
43: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
44: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
45: p_message_name OUT NOCOPY VARCHAR2 )
46: RETURN BOOLEAN;
47: --
48: -- Validate Graduand Student Unit Set Attempts.

Line 50: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,

46: RETURN BOOLEAN;
47: --
48: -- Validate Graduand Student Unit Set Attempts.
49: FUNCTION grdp_val_gac_susa(
50: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
51: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
52: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
53: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
54: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,

Line 51: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,

47: --
48: -- Validate Graduand Student Unit Set Attempts.
49: FUNCTION grdp_val_gac_susa(
50: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
51: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
52: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
53: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
54: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
55: p_graduand_status VARCHAR2 ,

Line 52: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

48: -- Validate Graduand Student Unit Set Attempts.
49: FUNCTION grdp_val_gac_susa(
50: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
51: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
52: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
53: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
54: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
55: p_graduand_status VARCHAR2 ,
56: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

Line 53: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

49: FUNCTION grdp_val_gac_susa(
50: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
51: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
52: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
53: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
54: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
55: p_graduand_status VARCHAR2 ,
56: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
57: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,

Line 56: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

52: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
53: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
54: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
55: p_graduand_status VARCHAR2 ,
56: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
57: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
60: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,

Line 57: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,

53: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
54: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
55: p_graduand_status VARCHAR2 ,
56: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
57: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
60: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
61: p_message_name OUT NOCOPY VARCHAR2 )

Line 58: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,

54: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
55: p_graduand_status VARCHAR2 ,
56: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
57: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
60: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
61: p_message_name OUT NOCOPY VARCHAR2 )
62: RETURN BOOLEAN;

Line 59: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,

55: p_graduand_status VARCHAR2 ,
56: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
57: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
60: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
61: p_message_name OUT NOCOPY VARCHAR2 )
62: RETURN BOOLEAN;
63: --

Line 60: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,

56: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
57: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
60: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
61: p_message_name OUT NOCOPY VARCHAR2 )
62: RETURN BOOLEAN;
63: --
64: -- Validate Graduand Award Ceremony graduation calendar instance.

Line 66: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

62: RETURN BOOLEAN;
63: --
64: -- Validate Graduand Award Ceremony graduation calendar instance.
65: FUNCTION grdp_val_gac_grd_ci(
66: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
67: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
68: p_message_name OUT NOCOPY VARCHAR2 )
69: RETURN BOOLEAN;
70: --

Line 67: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

63: --
64: -- Validate Graduand Award Ceremony graduation calendar instance.
65: FUNCTION grdp_val_gac_grd_ci(
66: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
67: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
68: p_message_name OUT NOCOPY VARCHAR2 )
69: RETURN BOOLEAN;
70: --
71: -- Validate graduand award ceremony order in presentation is unique.