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 11: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,

7: --smadathi 27-AUG-2001 Bug No. 1956374 .The function grdp_val_awc_closed removed
8: -------------------------------------------------------------------------------------------
9: -- Validate graduand award ceremony insert.
10: FUNCTION grdp_val_gac_insert(
11: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
12: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN AS
15: BEGIN -- grdp_val_gac_insert

Line 12: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,

8: -------------------------------------------------------------------------------------------
9: -- Validate graduand award ceremony insert.
10: FUNCTION grdp_val_gac_insert(
11: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
12: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN AS
15: BEGIN -- grdp_val_gac_insert
16: -- Description: This routine validates inserting a graduand_award_ceremony

Line 56: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

52: END grdp_val_gac_insert;
53: --
54: -- Validate inserting or updating a graduand award ceremony.
55: FUNCTION grdp_val_gac_iu(
56: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
57: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
58: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
59: p_message_name OUT NOCOPY VARCHAR2 )
60: RETURN BOOLEAN AS

Line 57: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

53: --
54: -- Validate inserting or updating a graduand award ceremony.
55: FUNCTION grdp_val_gac_iu(
56: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
57: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
58: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
59: p_message_name OUT NOCOPY VARCHAR2 )
60: RETURN BOOLEAN AS
61: BEGIN -- grdp_val_gac_iu

Line 58: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

54: -- Validate inserting or updating a graduand award ceremony.
55: FUNCTION grdp_val_gac_iu(
56: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
57: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
58: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
59: p_message_name OUT NOCOPY VARCHAR2 )
60: RETURN BOOLEAN AS
61: BEGIN -- grdp_val_gac_iu
62: -- Validate that the insert or update of a graduand_award_ceremony record

Line 174: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,

170: END grdp_val_gac_iu;
171: --
172: -- Validate Graduand Award Ceremony required details have been specified.
173: FUNCTION grdp_val_gac_rqrd(
174: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
175: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
176: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
177: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
178: p_academic_dress_rqrd_ind VARCHAR2 DEFAULT 'N',

Line 175: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,

171: --
172: -- Validate Graduand Award Ceremony required details have been specified.
173: FUNCTION grdp_val_gac_rqrd(
174: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
175: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
176: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
177: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
178: p_academic_dress_rqrd_ind VARCHAR2 DEFAULT 'N',
179: p_academic_gown_size VARCHAR2 ,

Line 176: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,

172: -- Validate Graduand Award Ceremony required details have been specified.
173: FUNCTION grdp_val_gac_rqrd(
174: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
175: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
176: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
177: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
178: p_academic_dress_rqrd_ind VARCHAR2 DEFAULT 'N',
179: p_academic_gown_size VARCHAR2 ,
180: p_academic_hat_size VARCHAR2 ,

Line 177: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,

173: FUNCTION grdp_val_gac_rqrd(
174: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
175: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
176: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
177: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
178: p_academic_dress_rqrd_ind VARCHAR2 DEFAULT 'N',
179: p_academic_gown_size VARCHAR2 ,
180: p_academic_hat_size VARCHAR2 ,
181: p_message_name OUT NOCOPY VARCHAR2 )

Line 224: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,

220: END grdp_val_gac_rqrd;
221: --
222: -- Validate graduand seat number is unique for the person.
223: FUNCTION grdp_val_gac_seat(
224: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
225: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
226: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
227: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
228: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,

Line 225: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

221: --
222: -- Validate graduand seat number is unique for the person.
223: FUNCTION grdp_val_gac_seat(
224: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
225: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
226: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
227: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
228: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
229: p_message_name OUT NOCOPY VARCHAR2 )

Line 226: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

222: -- Validate graduand seat number is unique for the person.
223: FUNCTION grdp_val_gac_seat(
224: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
225: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
226: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
227: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
228: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
229: p_message_name OUT NOCOPY VARCHAR2 )
230: RETURN BOOLEAN AS

Line 227: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

223: FUNCTION grdp_val_gac_seat(
224: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
225: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
226: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
227: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
228: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
229: p_message_name OUT NOCOPY VARCHAR2 )
230: RETURN BOOLEAN AS
231: BEGIN -- grdp_val_gac_seat

Line 228: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,

224: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
225: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
226: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
227: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
228: p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
229: p_message_name OUT NOCOPY VARCHAR2 )
230: RETURN BOOLEAN AS
231: BEGIN -- grdp_val_gac_seat
232: -- This routine validates the allocation of seats to graduands. It checks

Line 239: FROM IGS_GR_AWD_CRMN gac

235: DECLARE
236: v_gac_found VARCHAR2(1);
237: CURSOR c_gac IS
238: SELECT 'x'
239: FROM IGS_GR_AWD_CRMN gac
240: WHERE gac.grd_cal_type = p_grd_cal_type AND
241: gac.grd_ci_sequence_number = p_grd_ci_sequence_number AND
242: gac.ceremony_number = p_ceremony_number AND
243: gac.person_id <> p_person_id AND

Line 283: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,

279: END grdp_val_gac_seat;
280: --
281: -- Validate Graduand Student Unit Set Attempts.
282: FUNCTION grdp_val_gac_susa(
283: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
284: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
285: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
286: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
287: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,

Line 284: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,

280: --
281: -- Validate Graduand Student Unit Set Attempts.
282: FUNCTION grdp_val_gac_susa(
283: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
284: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
285: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
286: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
287: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
288: p_graduand_status VARCHAR2 ,

Line 285: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

281: -- Validate Graduand Student Unit Set Attempts.
282: FUNCTION grdp_val_gac_susa(
283: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
284: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
285: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
286: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
287: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
288: p_graduand_status VARCHAR2 ,
289: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

Line 286: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

282: FUNCTION grdp_val_gac_susa(
283: p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
284: p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
285: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
286: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
287: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
288: p_graduand_status VARCHAR2 ,
289: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
290: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,

Line 289: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,

285: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
286: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
287: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
288: p_graduand_status VARCHAR2 ,
289: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
290: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
291: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
292: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
293: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,

Line 290: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,

286: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
287: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
288: p_graduand_status VARCHAR2 ,
289: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
290: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
291: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
292: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
293: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
294: p_message_name OUT NOCOPY VARCHAR2 )

Line 291: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,

287: p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
288: p_graduand_status VARCHAR2 ,
289: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
290: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
291: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
292: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
293: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
294: p_message_name OUT NOCOPY VARCHAR2 )
295: RETURN BOOLEAN AS

Line 292: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,

288: p_graduand_status VARCHAR2 ,
289: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
290: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
291: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
292: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
293: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
294: p_message_name OUT NOCOPY VARCHAR2 )
295: RETURN BOOLEAN AS
296: BEGIN -- grdp_val_gac_susa

Line 293: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,

289: p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
290: p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
291: p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
292: p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
293: p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
294: p_message_name OUT NOCOPY VARCHAR2 )
295: RETURN BOOLEAN AS
296: BEGIN -- grdp_val_gac_susa
297: -- This routine validates the award ceremony unit sets belonging to a unit

Line 429: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

425: END grdp_val_gac_susa;
426: --
427: -- Validate Graduand Award Ceremony graduation calendar instance.
428: FUNCTION grdp_val_gac_grd_ci(
429: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
430: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
431: p_message_name OUT NOCOPY VARCHAR2 )
432: RETURN BOOLEAN AS
433: BEGIN -- grdp_val_gac_grd_ci

Line 430: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

426: --
427: -- Validate Graduand Award Ceremony graduation calendar instance.
428: FUNCTION grdp_val_gac_grd_ci(
429: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
430: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
431: p_message_name OUT NOCOPY VARCHAR2 )
432: RETURN BOOLEAN AS
433: BEGIN -- grdp_val_gac_grd_ci
434: -- Validate that the graduand_award_ceremony is linked

Line 493: FROM IGS_GR_AWD_CRMN

489: DECLARE
490: v_dummy VARCHAR2(1);
491: CURSOR c_gac IS
492: SELECT 'X'
493: FROM IGS_GR_AWD_CRMN
494: WHERE grd_cal_type = p_grd_cal_type AND
495: grd_ci_sequence_number = p_grd_ci_sequence_number AND
496: ceremony_number = p_ceremony_number AND
497: person_id <> p_person_id AND