APPS.IGS_GR_VAL_GAC dependencies on IGS_GR_GRADUAND

Line 19: v_gr_rec IGS_GR_GRADUAND.s_graduand_type%TYPE;

15: BEGIN -- grdp_val_gac_insert
16: -- Description: This routine validates inserting a graduand_award_ceremony
17: -- record based on the graduand details.
18: DECLARE
19: v_gr_rec IGS_GR_GRADUAND.s_graduand_type%TYPE;
20: cst_unknown CONSTANT VARCHAR2(10) := 'UNKNOWN';
21: cst_attending CONSTANT VARCHAR2(10) := 'ATTENDING';
22: cst_inabsentia CONSTANT VARCHAR2(10) := 'INABSENTIA';
23: CURSOR c_gr IS

Line 25: FROM IGS_GR_GRADUAND gr

21: cst_attending CONSTANT VARCHAR2(10) := 'ATTENDING';
22: cst_inabsentia CONSTANT VARCHAR2(10) := 'INABSENTIA';
23: CURSOR c_gr IS
24: SELECT 'X'
25: FROM IGS_GR_GRADUAND gr
26: WHERE gr.person_id = p_person_id AND
27: gr.create_dt = p_create_dt AND
28: gr.s_graduand_type NOT IN (cst_unknown,
29: cst_attending,

Line 306: v_course_cd IGS_GR_GRADUAND.course_cd%TYPE;

302: cst_graduated CONSTANT VARCHAR2(10) := 'GRADUATED';
303: cst_surrender CONSTANT VARCHAR2(10) := 'SURRENDER';
304: v_incomplete_unit_sets BOOLEAN DEFAULT FALSE;
305: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
306: v_course_cd IGS_GR_GRADUAND.course_cd%TYPE;
307: v_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;
308: v_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;
309: CURSOR c_gr IS
310: SELECT gr.course_cd,

Line 307: v_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;

303: cst_surrender CONSTANT VARCHAR2(10) := 'SURRENDER';
304: v_incomplete_unit_sets BOOLEAN DEFAULT FALSE;
305: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
306: v_course_cd IGS_GR_GRADUAND.course_cd%TYPE;
307: v_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE;
308: v_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;
309: CURSOR c_gr IS
310: SELECT gr.course_cd,
311: gr.graduand_status

Line 312: FROM IGS_GR_GRADUAND gr

308: v_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;
309: CURSOR c_gr IS
310: SELECT gr.course_cd,
311: gr.graduand_status
312: FROM IGS_GR_GRADUAND gr
313: WHERE gr.person_id = p_person_id AND
314: gr.create_dt = p_create_dt;
315: CURSOR c_acus IS
316: SELECT acus.unit_set_cd,

Line 327: cp_course_cd IGS_GR_GRADUAND.course_cd%TYPE,

323: acus.award_crs_version_number = p_award_crs_version_number AND
324: acus.award_cd = p_award_cd AND
325: acus.us_group_number = p_us_group_number;
326: CURSOR c_susa (
327: cp_course_cd IGS_GR_GRADUAND.course_cd%TYPE,
328: cp_unit_set_cd IGS_GR_AWD_CRM_UT_ST.unit_set_cd%TYPE,
329: cp_us_version_number IGS_GR_AWD_CRM_UT_ST.us_version_number%TYPE)
330: IS
331: SELECT susa.rqrmnts_complete_ind

Line 341: cp_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE)

337: susa.student_confirmed_ind = 'Y' AND
338: susa.primary_set_ind = 'Y' AND
339: susa.end_dt IS NULL;
340: CURSOR c_gst(
341: cp_graduand_status IGS_GR_GRADUAND.graduand_status%TYPE)
342: IS
343: SELECT gst.s_graduand_status
344: FROM IGS_GR_STAT gst
345: WHERE gst.graduand_status = cp_graduand_status;