eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_GR_VAL_GR dependencies on IGS_GR_GRADUAND_ALL

Line 22: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

18: RETURN BOOLEAN;
19: --
20: -- Validate graduand student course attempt is a graduating course.
21: FUNCTION grdp_val_gr_sca(
22: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
23: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
24: p_message_name OUT NOCOPY VARCHAR2 )
25: RETURN BOOLEAN;
26: --

Line 23: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

19: --
20: -- Validate graduand student course attempt is a graduating course.
21: FUNCTION grdp_val_gr_sca(
22: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
23: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
24: p_message_name OUT NOCOPY VARCHAR2 )
25: RETURN BOOLEAN;
26: --
27: -- Validate Graduand Ceremony Round calendar instance.

Line 36: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

32: RETURN BOOLEAN;
33: --
34: -- Validate GRADUAND required details.
35: FUNCTION grdp_val_gr_rqrd(
36: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
37: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
38: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
39: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
40: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

Line 37: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

33: --
34: -- Validate GRADUAND required details.
35: FUNCTION grdp_val_gr_rqrd(
36: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
37: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
38: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
39: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
40: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
41: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 38: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

34: -- Validate GRADUAND required details.
35: FUNCTION grdp_val_gr_rqrd(
36: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
37: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
38: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
39: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
40: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
41: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
42: p_honours_level VARCHAR2 DEFAULT NULL,

Line 39: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

35: FUNCTION grdp_val_gr_rqrd(
36: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
37: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
38: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
39: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
40: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
41: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
42: p_honours_level VARCHAR2 DEFAULT NULL,
43: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

Line 40: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

36: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
37: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
38: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
39: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
40: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
41: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
42: p_honours_level VARCHAR2 DEFAULT NULL,
43: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
44: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

Line 41: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

37: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
38: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
39: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
40: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
41: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
42: p_honours_level VARCHAR2 DEFAULT NULL,
43: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
44: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
45: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

Line 43: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

39: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
40: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
41: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
42: p_honours_level VARCHAR2 DEFAULT NULL,
43: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
44: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
45: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
46: p_conferral_dt IGS_GR_GRADUAND_V.conferral_dt%TYPE DEFAULT NULL,
47: p_message_name OUT NOCOPY VARCHAR2 )

Line 44: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

40: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
41: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
42: p_honours_level VARCHAR2 DEFAULT NULL,
43: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
44: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
45: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
46: p_conferral_dt IGS_GR_GRADUAND_V.conferral_dt%TYPE DEFAULT NULL,
47: p_message_name OUT NOCOPY VARCHAR2 )
48: RETURN BOOLEAN;

Line 45: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

41: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
42: p_honours_level VARCHAR2 DEFAULT NULL,
43: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
44: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
45: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
46: p_conferral_dt IGS_GR_GRADUAND_V.conferral_dt%TYPE DEFAULT NULL,
47: p_message_name OUT NOCOPY VARCHAR2 )
48: RETURN BOOLEAN;
49: --

Line 52: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

48: RETURN BOOLEAN;
49: --
50: -- Validate graduand status.
51: FUNCTION grdp_val_gr_gst(
52: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
53: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
54: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
55: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
56: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

Line 53: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,

49: --
50: -- Validate graduand status.
51: FUNCTION grdp_val_gr_gst(
52: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
53: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
54: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
55: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
56: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
57: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

Line 54: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

50: -- Validate graduand status.
51: FUNCTION grdp_val_gr_gst(
52: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
53: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
54: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
55: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
56: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
57: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

Line 55: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,

51: FUNCTION grdp_val_gr_gst(
52: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
53: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
54: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
55: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
56: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
57: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 56: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

52: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
53: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
54: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
55: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
56: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
57: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
60: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

Line 57: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

53: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
54: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
55: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
56: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
57: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
60: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
61: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

Line 58: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

54: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
55: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
56: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
57: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
60: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
61: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
62: p_message_name OUT NOCOPY VARCHAR2 )

Line 59: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

55: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
56: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
57: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
60: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
61: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
62: p_message_name OUT NOCOPY VARCHAR2 )
63: RETURN BOOLEAN;

Line 60: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

56: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
57: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
60: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
61: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
62: p_message_name OUT NOCOPY VARCHAR2 )
63: RETURN BOOLEAN;
64: --

Line 61: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

57: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
58: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
59: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
60: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
61: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
62: p_message_name OUT NOCOPY VARCHAR2 )
63: RETURN BOOLEAN;
64: --
65: -- Validate graduand approval status.

Line 69: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

65: -- Validate graduand approval status.
66: FUNCTION grdp_val_gr_gas(
67: p_person_id IN HZ_PARTIES.party_id%TYPE,
68: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
69: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
70: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
71: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
72: p_message_name OUT NOCOPY VARCHAR2 )
73: RETURN BOOLEAN;

Line 70: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,

66: FUNCTION grdp_val_gr_gas(
67: p_person_id IN HZ_PARTIES.party_id%TYPE,
68: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
69: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
70: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
71: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
72: p_message_name OUT NOCOPY VARCHAR2 )
73: RETURN BOOLEAN;
74: --

Line 71: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,

67: p_person_id IN HZ_PARTIES.party_id%TYPE,
68: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
69: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
70: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
71: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
72: p_message_name OUT NOCOPY VARCHAR2 )
73: RETURN BOOLEAN;
74: --
75: -- Validate system graduand type.

Line 77: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

73: RETURN BOOLEAN;
74: --
75: -- Validate system graduand type.
76: FUNCTION GRDP_VAL_GR_TYPE(
77: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
78: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
79: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
80: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
81: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

Line 78: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,

74: --
75: -- Validate system graduand type.
76: FUNCTION GRDP_VAL_GR_TYPE(
77: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
78: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
79: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
80: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
81: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
82: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

Line 79: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

75: -- Validate system graduand type.
76: FUNCTION GRDP_VAL_GR_TYPE(
77: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
78: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
79: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
80: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
81: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
82: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
83: p_message_name OUT NOCOPY VARCHAR2 )

Line 80: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

76: FUNCTION GRDP_VAL_GR_TYPE(
77: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
78: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
79: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
80: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
81: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
82: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
83: p_message_name OUT NOCOPY VARCHAR2 )
84: RETURN BOOLEAN;

Line 81: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

77: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
78: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
79: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
80: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
81: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
82: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
83: p_message_name OUT NOCOPY VARCHAR2 )
84: RETURN BOOLEAN;
85: --

Line 82: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

78: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
79: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
80: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
81: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
82: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
83: p_message_name OUT NOCOPY VARCHAR2 )
84: RETURN BOOLEAN;
85: --
86: -- Validate proxy details.

Line 88: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

84: RETURN BOOLEAN;
85: --
86: -- Validate proxy details.
87: FUNCTION grdp_val_gr_proxy(
88: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
89: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
90: p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
91: p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
92: p_message_name OUT NOCOPY VARCHAR2 )

Line 89: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

85: --
86: -- Validate proxy details.
87: FUNCTION grdp_val_gr_proxy(
88: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
89: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
90: p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
91: p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
92: p_message_name OUT NOCOPY VARCHAR2 )
93: RETURN BOOLEAN;

Line 90: p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,

86: -- Validate proxy details.
87: FUNCTION grdp_val_gr_proxy(
88: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
89: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
90: p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
91: p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
92: p_message_name OUT NOCOPY VARCHAR2 )
93: RETURN BOOLEAN;
94: --

Line 91: p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,

87: FUNCTION grdp_val_gr_proxy(
88: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
89: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
90: p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
91: p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
92: p_message_name OUT NOCOPY VARCHAR2 )
93: RETURN BOOLEAN;
94: --
95: -- Check for multiple instances of the same award for the person.

Line 97: p_person_id IN IGS_GR_GRADUAND_ALL.person_id%TYPE ,

93: RETURN BOOLEAN;
94: --
95: -- Check for multiple instances of the same award for the person.
96: FUNCTION grdp_val_gr_unique(
97: p_person_id IN IGS_GR_GRADUAND_ALL.person_id%TYPE ,
98: p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
99: p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
100: p_grd_ci_sequence_num IN NUMBER ,
101: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

Line 98: p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,

94: --
95: -- Check for multiple instances of the same award for the person.
96: FUNCTION grdp_val_gr_unique(
97: p_person_id IN IGS_GR_GRADUAND_ALL.person_id%TYPE ,
98: p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
99: p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
100: p_grd_ci_sequence_num IN NUMBER ,
101: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
102: p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

Line 101: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

97: p_person_id IN IGS_GR_GRADUAND_ALL.person_id%TYPE ,
98: p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
99: p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
100: p_grd_ci_sequence_num IN NUMBER ,
101: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
102: p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
103: p_award_cd IN IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
104: p_message_name OUT NOCOPY VARCHAR2 )
105: RETURN BOOLEAN;

Line 102: p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

98: p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
99: p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
100: p_grd_ci_sequence_num IN NUMBER ,
101: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
102: p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
103: p_award_cd IN IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
104: p_message_name OUT NOCOPY VARCHAR2 )
105: RETURN BOOLEAN;
106: --

Line 103: p_award_cd IN IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

99: p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
100: p_grd_ci_sequence_num IN NUMBER ,
101: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
102: p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
103: p_award_cd IN IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
104: p_message_name OUT NOCOPY VARCHAR2 )
105: RETURN BOOLEAN;
106: --
107: -- Validate the update of a graduand with graduand awards ceremonies.

Line 109: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

105: RETURN BOOLEAN;
106: --
107: -- Validate the update of a graduand with graduand awards ceremonies.
108: FUNCTION grdp_val_gr_upd(
109: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
110: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
111: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
112: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
113: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 110: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,

106: --
107: -- Validate the update of a graduand with graduand awards ceremonies.
108: FUNCTION grdp_val_gr_upd(
109: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
110: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
111: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
112: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
113: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
114: p_message_name OUT NOCOPY VARCHAR2 )

Line 111: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

107: -- Validate the update of a graduand with graduand awards ceremonies.
108: FUNCTION grdp_val_gr_upd(
109: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
110: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
111: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
112: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
113: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
114: p_message_name OUT NOCOPY VARCHAR2 )
115: RETURN BOOLEAN;

Line 112: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

108: FUNCTION grdp_val_gr_upd(
109: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
110: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
111: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
112: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
113: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
114: p_message_name OUT NOCOPY VARCHAR2 )
115: RETURN BOOLEAN;
116: --

Line 113: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

109: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
110: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
111: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
112: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
113: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
114: p_message_name OUT NOCOPY VARCHAR2 )
115: RETURN BOOLEAN;
116: --
117: -- Validate inserting or updating a graduand.

Line 126: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

122: RETURN BOOLEAN;
123: --
124: -- Validate the graduand has satisfied academic requirements for an award
125: FUNCTION grdp_val_aw_eligible(
126: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
127: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
128: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
129: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
130: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 127: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

123: --
124: -- Validate the graduand has satisfied academic requirements for an award
125: FUNCTION grdp_val_aw_eligible(
126: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
127: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
128: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
129: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
130: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
131: p_message_name OUT NOCOPY VARCHAR2 )

Line 128: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

124: -- Validate the graduand has satisfied academic requirements for an award
125: FUNCTION grdp_val_aw_eligible(
126: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
127: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
128: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
129: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
130: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
131: p_message_name OUT NOCOPY VARCHAR2 )
132: RETURN BOOLEAN;

Line 129: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

125: FUNCTION grdp_val_aw_eligible(
126: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
127: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
128: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
129: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
130: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
131: p_message_name OUT NOCOPY VARCHAR2 )
132: RETURN BOOLEAN;
133: --

Line 130: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

126: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
127: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
128: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
129: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
130: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
131: p_message_name OUT NOCOPY VARCHAR2 )
132: RETURN BOOLEAN;
133: --
134: -- Validate graduand course award.

Line 136: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

132: RETURN BOOLEAN;
133: --
134: -- Validate graduand course award.
135: FUNCTION grdp_val_gr_caw(
136: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
137: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
138: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
139: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
140: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 137: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

133: --
134: -- Validate graduand course award.
135: FUNCTION grdp_val_gr_caw(
136: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
137: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
138: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
139: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
140: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
141: p_message_name OUT NOCOPY VARCHAR2 )

Line 138: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

134: -- Validate graduand course award.
135: FUNCTION grdp_val_gr_caw(
136: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
137: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
138: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
139: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
140: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
141: p_message_name OUT NOCOPY VARCHAR2 )
142: RETURN BOOLEAN;

Line 139: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

135: FUNCTION grdp_val_gr_caw(
136: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
137: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
138: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
139: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
140: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
141: p_message_name OUT NOCOPY VARCHAR2 )
142: RETURN BOOLEAN;
143: --

Line 140: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

136: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
137: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
138: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
139: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
140: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
141: p_message_name OUT NOCOPY VARCHAR2 )
142: RETURN BOOLEAN;
143: --
144: -- Validate if graduand approval status is closed.

Line 164: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

160: RETURN BOOLEAN;
161: --
162: -- Validate graduand surrender for award.
163: FUNCTION GRDP_VAL_GR_SUR_CAW(
164: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
165: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
166: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
167: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
168: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

Line 165: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

161: --
162: -- Validate graduand surrender for award.
163: FUNCTION GRDP_VAL_GR_SUR_CAW(
164: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
165: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
166: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
167: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
168: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
169: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

Line 166: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

162: -- Validate graduand surrender for award.
163: FUNCTION GRDP_VAL_GR_SUR_CAW(
164: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
165: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
166: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
167: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
168: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
169: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
170: p_message_name OUT NOCOPY VARCHAR2 )

Line 167: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

163: FUNCTION GRDP_VAL_GR_SUR_CAW(
164: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
165: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
166: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
167: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
168: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
169: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
170: p_message_name OUT NOCOPY VARCHAR2 )
171: RETURN BOOLEAN;

Line 168: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

164: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
165: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
166: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
167: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
168: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
169: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
170: p_message_name OUT NOCOPY VARCHAR2 )
171: RETURN BOOLEAN;
172: END IGS_GR_VAL_GR;

Line 169: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

165: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
166: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
167: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
168: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
169: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
170: p_message_name OUT NOCOPY VARCHAR2 )
171: RETURN BOOLEAN;
172: END IGS_GR_VAL_GR;