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_GR dependencies on IGS_GR_GRADUAND

Line 106: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

102: END enrp_val_encmb_efct;
103: --
104: -- Validate graduand student course attempt is a graduating course.
105: FUNCTION grdp_val_gr_sca(
106: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
107: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
108: p_message_name OUT NOCOPY VARCHAR2 )
109: RETURN BOOLEAN AS
110: BEGIN -- grdp_val_gr_sca

Line 107: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

103: --
104: -- Validate graduand student course attempt is a graduating course.
105: FUNCTION grdp_val_gr_sca(
106: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
107: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
108: p_message_name OUT NOCOPY VARCHAR2 )
109: RETURN BOOLEAN AS
110: BEGIN -- grdp_val_gr_sca
111: -- Validate the graduand record student course attempt is for a

Line 221: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

217: END grdp_val_gr_crd_ci;
218: --
219: -- Validate GRADUAND required details.
220: FUNCTION grdp_val_gr_rqrd(
221: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
222: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
223: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
224: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
225: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

Line 222: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

218: --
219: -- Validate GRADUAND required details.
220: FUNCTION grdp_val_gr_rqrd(
221: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
222: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
223: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
224: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
225: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
226: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 223: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

219: -- Validate GRADUAND required details.
220: FUNCTION grdp_val_gr_rqrd(
221: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
222: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
223: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
224: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
225: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
226: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
227: p_honours_level VARCHAR2 DEFAULT NULL,

Line 224: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

220: FUNCTION grdp_val_gr_rqrd(
221: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
222: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
223: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
224: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
225: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
226: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
227: p_honours_level VARCHAR2 DEFAULT NULL,
228: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

Line 225: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

221: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
222: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
223: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
224: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
225: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
226: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
227: p_honours_level VARCHAR2 DEFAULT NULL,
228: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
229: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

Line 226: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

222: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
223: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
224: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
225: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
226: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
227: p_honours_level VARCHAR2 DEFAULT NULL,
228: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
229: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
230: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

Line 228: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

224: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
225: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
226: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
227: p_honours_level VARCHAR2 DEFAULT NULL,
228: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
229: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
230: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
231: p_conferral_dt IGS_GR_GRADUAND_V.conferral_dt%TYPE DEFAULT NULL,
232: p_message_name OUT NOCOPY VARCHAR2 )

Line 229: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

225: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
226: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
227: p_honours_level VARCHAR2 DEFAULT NULL,
228: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
229: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
230: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
231: p_conferral_dt IGS_GR_GRADUAND_V.conferral_dt%TYPE DEFAULT NULL,
232: p_message_name OUT NOCOPY VARCHAR2 )
233: RETURN BOOLEAN AS

Line 230: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

226: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
227: p_honours_level VARCHAR2 DEFAULT NULL,
228: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
229: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
230: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
231: p_conferral_dt IGS_GR_GRADUAND_V.conferral_dt%TYPE DEFAULT NULL,
232: p_message_name OUT NOCOPY VARCHAR2 )
233: RETURN BOOLEAN AS
234: BEGIN -- grdp_val_gr_rqrd

Line 231: p_conferral_dt IGS_GR_GRADUAND_V.conferral_dt%TYPE DEFAULT NULL,

227: p_honours_level VARCHAR2 DEFAULT NULL,
228: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
229: p_sur_for_crs_version_number IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
230: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
231: p_conferral_dt IGS_GR_GRADUAND_V.conferral_dt%TYPE DEFAULT NULL,
232: p_message_name OUT NOCOPY VARCHAR2 )
233: RETURN BOOLEAN AS
234: BEGIN -- grdp_val_gr_rqrd
235: -- Validate the graduand record details:

Line 340: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

336: END grdp_val_gr_rqrd;
337: --
338: -- Validate graduand status.
339: FUNCTION grdp_val_gr_gst(
340: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
341: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
342: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
343: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
344: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

Line 341: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,

337: --
338: -- Validate graduand status.
339: FUNCTION grdp_val_gr_gst(
340: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
341: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
342: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
343: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
344: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
345: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

Line 342: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

338: -- Validate graduand status.
339: FUNCTION grdp_val_gr_gst(
340: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
341: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
342: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
343: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
344: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
345: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
346: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

Line 343: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,

339: FUNCTION grdp_val_gr_gst(
340: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
341: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
342: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
343: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
344: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
345: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
346: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
347: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 344: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

340: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
341: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
342: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
343: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
344: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
345: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
346: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
347: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
348: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

Line 345: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

341: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
342: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
343: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
344: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
345: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
346: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
347: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
348: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
349: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

Line 346: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

342: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
343: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
344: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
345: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
346: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
347: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
348: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
349: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
350: p_message_name OUT NOCOPY VARCHAR2 )

Line 347: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

343: p_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
344: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
345: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
346: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
347: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
348: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
349: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
350: p_message_name OUT NOCOPY VARCHAR2 )
351: RETURN BOOLEAN AS

Line 348: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

344: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
345: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
346: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
347: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
348: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
349: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
350: p_message_name OUT NOCOPY VARCHAR2 )
351: RETURN BOOLEAN AS
352: BEGIN -- grdp_val_gr_gst

Line 349: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

345: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
346: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
347: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
348: p_new_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
349: p_old_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
350: p_message_name OUT NOCOPY VARCHAR2 )
351: RETURN BOOLEAN AS
352: BEGIN -- grdp_val_gr_gst
353: -- This routine validates the setting of graduand.graduand_status

Line 356: v_new_s_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;

352: BEGIN -- grdp_val_gr_gst
353: -- This routine validates the setting of graduand.graduand_status
354: DECLARE
355: v_s_graduand_appr_status IGS_GR_APRV_STAT.s_graduand_appr_status%TYPE;
356: v_new_s_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;
357: v_old_s_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;
358: cst_potential CONSTANT VARCHAR2(12) := 'POTENTIAL';
359: cst_graduated CONSTANT VARCHAR2(12) := 'GRADUATED';
360: cst_eligible CONSTANT VARCHAR2(12) := 'ELIGIBLE';

Line 357: v_old_s_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;

353: -- This routine validates the setting of graduand.graduand_status
354: DECLARE
355: v_s_graduand_appr_status IGS_GR_APRV_STAT.s_graduand_appr_status%TYPE;
356: v_new_s_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;
357: v_old_s_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;
358: cst_potential CONSTANT VARCHAR2(12) := 'POTENTIAL';
359: cst_graduated CONSTANT VARCHAR2(12) := 'GRADUATED';
360: cst_eligible CONSTANT VARCHAR2(12) := 'ELIGIBLE';
361: cst_approved CONSTANT VARCHAR2(12) := 'APPROVED';

Line 370: cp_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE)

366: SELECT gas.s_graduand_appr_status
367: FROM IGS_GR_APRV_STAT gas
368: WHERE gas.graduand_appr_status = p_graduand_appr_status;
369: CURSOR c_gst (
370: cp_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE)
371: IS
372: SELECT gst.s_graduand_status
373: FROM IGS_GR_STAT gst
374: WHERE gst.graduand_status = cp_graduand_status;

Line 549: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

545: -- Validate graduand approval status.
546: FUNCTION grdp_val_gr_gas(
547: p_person_id IN HZ_PARTIES.party_id%TYPE ,
548: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
549: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
550: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
551: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
552: p_message_name OUT NOCOPY VARCHAR2 )
553: RETURN BOOLEAN AS

Line 550: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,

546: FUNCTION grdp_val_gr_gas(
547: p_person_id IN HZ_PARTIES.party_id%TYPE ,
548: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
549: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
550: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
551: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
552: p_message_name OUT NOCOPY VARCHAR2 )
553: RETURN BOOLEAN AS
554: BEGIN -- grdp_val_gr_gas

Line 551: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,

547: p_person_id IN HZ_PARTIES.party_id%TYPE ,
548: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
549: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
550: p_new_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
551: p_old_graduand_appr_status IGS_GR_GRADUAND_ALL.graduand_appr_status%TYPE ,
552: p_message_name OUT NOCOPY VARCHAR2 )
553: RETURN BOOLEAN AS
554: BEGIN -- grdp_val_gr_gas
555: DECLARE

Line 636: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

632: END grdp_val_gr_gas;
633: --
634: -- Validate system graduand type.
635: FUNCTION GRDP_VAL_GR_TYPE(
636: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
637: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
638: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
639: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
640: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

Line 637: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,

633: --
634: -- Validate system graduand type.
635: FUNCTION GRDP_VAL_GR_TYPE(
636: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
637: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
638: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
639: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
640: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
641: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

Line 638: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

634: -- Validate system graduand type.
635: FUNCTION GRDP_VAL_GR_TYPE(
636: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
637: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
638: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
639: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
640: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
641: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
642: p_message_name OUT NOCOPY VARCHAR2 )

Line 639: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

635: FUNCTION GRDP_VAL_GR_TYPE(
636: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
637: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
638: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
639: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
640: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
641: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
642: p_message_name OUT NOCOPY VARCHAR2 )
643: RETURN BOOLEAN AS

Line 640: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

636: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
637: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
638: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
639: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
640: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
641: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
642: p_message_name OUT NOCOPY VARCHAR2 )
643: RETURN BOOLEAN AS
644: BEGIN -- grdp_val_gr_type

Line 641: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

637: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
638: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
639: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
640: p_new_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
641: p_old_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
642: p_message_name OUT NOCOPY VARCHAR2 )
643: RETURN BOOLEAN AS
644: BEGIN -- grdp_val_gr_type
645: DECLARE

Line 784: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

780: END grdp_val_gr_type;
781: --
782: -- Validate proxy details.
783: FUNCTION grdp_val_gr_proxy(
784: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
785: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
786: p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
787: p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
788: p_message_name OUT NOCOPY VARCHAR2 )

Line 785: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,

781: --
782: -- Validate proxy details.
783: FUNCTION grdp_val_gr_proxy(
784: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
785: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
786: p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
787: p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
788: p_message_name OUT NOCOPY VARCHAR2 )
789: RETURN BOOLEAN AS

Line 786: p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,

782: -- Validate proxy details.
783: FUNCTION grdp_val_gr_proxy(
784: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
785: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
786: p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
787: p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
788: p_message_name OUT NOCOPY VARCHAR2 )
789: RETURN BOOLEAN AS
790: BEGIN -- grdp_val_gr_proxy

Line 787: p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,

783: FUNCTION grdp_val_gr_proxy(
784: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
785: p_s_graduand_type IGS_GR_GRADUAND_ALL.s_graduand_type%TYPE ,
786: p_proxy_award_ind IGS_GR_GRADUAND_ALL.proxy_award_ind%TYPE ,
787: p_proxy_award_person_id IGS_GR_GRADUAND_ALL.proxy_award_person_id%TYPE ,
788: p_message_name OUT NOCOPY VARCHAR2 )
789: RETURN BOOLEAN AS
790: BEGIN -- grdp_val_gr_proxy
791: -- Validate the graduand record proxy details.

Line 793: cst_attending CONSTANT IGS_GR_GRADUAND.s_graduand_type%TYPE := 'ATTENDING';

789: RETURN BOOLEAN AS
790: BEGIN -- grdp_val_gr_proxy
791: -- Validate the graduand record proxy details.
792: DECLARE
793: cst_attending CONSTANT IGS_GR_GRADUAND.s_graduand_type%TYPE := 'ATTENDING';
794: v_pe_exists VARCHAR2(1);
795: CURSOR c_pe(
796: cp_id IGS_PE_PERSON_BASE_V.person_id%TYPE) IS
797: SELECT 'x'

Line 870: p_person_id IN IGS_GR_GRADUAND_ALL.person_id%TYPE ,

866: END grdp_val_gr_proxy;
867: --
868: -- Check for multiple instances of the same award for the person.
869: FUNCTION grdp_val_gr_unique(
870: p_person_id IN IGS_GR_GRADUAND_ALL.person_id%TYPE ,
871: p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
872: p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
873: p_grd_ci_sequence_num IN NUMBER ,
874: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

Line 871: p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,

867: --
868: -- Check for multiple instances of the same award for the person.
869: FUNCTION grdp_val_gr_unique(
870: p_person_id IN IGS_GR_GRADUAND_ALL.person_id%TYPE ,
871: p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
872: p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
873: p_grd_ci_sequence_num IN NUMBER ,
874: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
875: p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

Line 874: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

870: p_person_id IN IGS_GR_GRADUAND_ALL.person_id%TYPE ,
871: p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
872: p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
873: p_grd_ci_sequence_num IN NUMBER ,
874: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
875: p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
876: p_award_cd IN IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
877: p_message_name OUT NOCOPY VARCHAR2 )
878: RETURN BOOLEAN AS

Line 875: p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

871: p_create_dt IN IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
872: p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
873: p_grd_ci_sequence_num IN NUMBER ,
874: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
875: p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
876: p_award_cd IN IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
877: p_message_name OUT NOCOPY VARCHAR2 )
878: RETURN BOOLEAN AS
879: BEGIN -- grdp_val_gr_unique

Line 876: p_award_cd IN IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

872: p_grd_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
873: p_grd_ci_sequence_num IN NUMBER ,
874: p_award_course_cd IN IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
875: p_award_crs_version_number IN IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
876: p_award_cd IN IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
877: p_message_name OUT NOCOPY VARCHAR2 )
878: RETURN BOOLEAN AS
879: BEGIN -- grdp_val_gr_unique
880: -- Validate that the graduand record is unique.

Line 891: FROM IGS_GR_GRADUAND gr

887: CURSOR c_gr IS
888: SELECT gr.grd_cal_type,
889: gr.grd_ci_sequence_number,
890: gr.graduand_status
891: FROM IGS_GR_GRADUAND gr
892: WHERE gr.person_id = p_person_id AND
893: gr.create_dt <> p_create_dt AND
894: gr.award_cd = p_award_cd AND
895: NVL(gr.award_course_cd, 'NULL') = NVL(p_award_course_cd,'NULL') AND

Line 898: cp_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE)

894: gr.award_cd = p_award_cd AND
895: NVL(gr.award_course_cd, 'NULL') = NVL(p_award_course_cd,'NULL') AND
896: NVL(gr.award_crs_version_number,0) = NVL(p_award_crs_version_number,0);
897: CURSOR c_gst (
898: cp_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE)
899: IS
900: SELECT 'x'
901: FROM IGS_GR_STAT gst
902: WHERE gst.graduand_status = cp_graduand_status AND

Line 957: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

953: END grdp_val_gr_unique;
954: --
955: -- Validate the update of a graduand with graduand awards ceremonies.
956: FUNCTION grdp_val_gr_upd(
957: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
958: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
959: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
960: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
961: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 958: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,

954: --
955: -- Validate the update of a graduand with graduand awards ceremonies.
956: FUNCTION grdp_val_gr_upd(
957: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
958: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
959: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
960: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
961: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
962: p_message_name OUT NOCOPY VARCHAR2 )

Line 959: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

955: -- Validate the update of a graduand with graduand awards ceremonies.
956: FUNCTION grdp_val_gr_upd(
957: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
958: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
959: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
960: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
961: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
962: p_message_name OUT NOCOPY VARCHAR2 )
963: RETURN BOOLEAN AS

Line 960: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

956: FUNCTION grdp_val_gr_upd(
957: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
958: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
959: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
960: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
961: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
962: p_message_name OUT NOCOPY VARCHAR2 )
963: RETURN BOOLEAN AS
964: BEGIN -- grdp_val_gr_upd

Line 961: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

957: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
958: p_create_dt IGS_GR_GRADUAND_ALL.create_dt%TYPE ,
959: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
960: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
961: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
962: p_message_name OUT NOCOPY VARCHAR2 )
963: RETURN BOOLEAN AS
964: BEGIN -- grdp_val_gr_upd
965: -- Validate that the update of a graduand record does not occur

Line 1122: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

1118: END grdp_val_gr_iu;
1119: --
1120: -- Validate the graduand has satisfied academic requirements for an award
1121: FUNCTION grdp_val_aw_eligible(
1122: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1123: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1124: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
1125: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
1126: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 1123: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

1119: --
1120: -- Validate the graduand has satisfied academic requirements for an award
1121: FUNCTION grdp_val_aw_eligible(
1122: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1123: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1124: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
1125: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
1126: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
1127: p_message_name OUT NOCOPY VARCHAR2 )

Line 1124: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

1120: -- Validate the graduand has satisfied academic requirements for an award
1121: FUNCTION grdp_val_aw_eligible(
1122: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1123: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1124: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
1125: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
1126: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
1127: p_message_name OUT NOCOPY VARCHAR2 )
1128: RETURN BOOLEAN AS

Line 1125: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

1121: FUNCTION grdp_val_aw_eligible(
1122: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1123: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1124: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
1125: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
1126: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
1127: p_message_name OUT NOCOPY VARCHAR2 )
1128: RETURN BOOLEAN AS
1129: BEGIN -- grdp_val_aw_eligible

Line 1126: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

1122: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1123: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1124: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
1125: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
1126: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
1127: p_message_name OUT NOCOPY VARCHAR2 )
1128: RETURN BOOLEAN AS
1129: BEGIN -- grdp_val_aw_eligible
1130: -- Validate the graduand is academically eligible for the award.

Line 1218: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

1214: END grdp_val_aw_eligible;
1215: --
1216: -- Validate graduand course award.
1217: FUNCTION grdp_val_gr_caw(
1218: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1219: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1220: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
1221: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
1222: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

Line 1219: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

1215: --
1216: -- Validate graduand course award.
1217: FUNCTION grdp_val_gr_caw(
1218: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1219: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1220: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
1221: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
1222: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
1223: p_message_name OUT NOCOPY VARCHAR2 )

Line 1220: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,

1216: -- Validate graduand course award.
1217: FUNCTION grdp_val_gr_caw(
1218: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1219: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1220: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
1221: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
1222: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
1223: p_message_name OUT NOCOPY VARCHAR2 )
1224: RETURN BOOLEAN AS

Line 1221: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,

1217: FUNCTION grdp_val_gr_caw(
1218: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1219: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1220: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
1221: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
1222: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
1223: p_message_name OUT NOCOPY VARCHAR2 )
1224: RETURN BOOLEAN AS
1225: BEGIN -- grdp_val_gr_caw

Line 1222: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,

1218: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1219: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1220: p_award_course_cd IGS_GR_GRADUAND_ALL.award_course_cd%TYPE ,
1221: p_award_crs_version_number IGS_GR_GRADUAND_ALL.award_crs_version_number%TYPE ,
1222: p_award_cd IGS_GR_GRADUAND_ALL.award_cd%TYPE ,
1223: p_message_name OUT NOCOPY VARCHAR2 )
1224: RETURN BOOLEAN AS
1225: BEGIN -- grdp_val_gr_caw
1226: -- Validate the graduand record course award is an award for the

Line 1379: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,

1375: END grdp_val_hl_closed;
1376: --
1377: -- Validate graduand surrender for award.
1378: FUNCTION GRDP_VAL_GR_SUR_CAW(
1379: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1380: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1381: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
1382: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
1383: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

Line 1380: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,

1376: --
1377: -- Validate graduand surrender for award.
1378: FUNCTION GRDP_VAL_GR_SUR_CAW(
1379: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1380: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1381: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
1382: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
1383: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
1384: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

Line 1381: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,

1377: -- Validate graduand surrender for award.
1378: FUNCTION GRDP_VAL_GR_SUR_CAW(
1379: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1380: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1381: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
1382: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
1383: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
1384: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
1385: p_message_name OUT NOCOPY VARCHAR2 )

Line 1382: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,

1378: FUNCTION GRDP_VAL_GR_SUR_CAW(
1379: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1380: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1381: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
1382: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
1383: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
1384: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
1385: p_message_name OUT NOCOPY VARCHAR2 )
1386: RETURN BOOLEAN AS

Line 1383: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,

1379: p_person_id IGS_GR_GRADUAND_ALL.person_id%TYPE ,
1380: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1381: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
1382: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
1383: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
1384: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
1385: p_message_name OUT NOCOPY VARCHAR2 )
1386: RETURN BOOLEAN AS
1387: BEGIN -- grdp_val_gr_sur_caw

Line 1384: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,

1380: p_course_cd IGS_GR_GRADUAND_ALL.course_cd%TYPE ,
1381: p_graduand_status IGS_GR_GRADUAND_ALL.graduand_status%TYPE ,
1382: p_sur_for_course_cd IGS_GR_GRADUAND_ALL.sur_for_course_cd%TYPE ,
1383: p_sur_for_crs_version_num IGS_GR_GRADUAND_ALL.sur_for_crs_version_number%TYPE ,
1384: p_sur_for_award_cd IGS_GR_GRADUAND_ALL.sur_for_award_cd%TYPE ,
1385: p_message_name OUT NOCOPY VARCHAR2 )
1386: RETURN BOOLEAN AS
1387: BEGIN -- grdp_val_gr_sur_caw
1388: DECLARE