APPS.IGS_GR_GEN_002 dependencies on IGS_EN_STDNT_PS_ATT

Line 124: FROM igs_en_stdnt_ps_att sca ,

120: sca.course_cd,
121: sca.version_number,
122: sca.commencement_dt,
123: spaa.award_cd
124: FROM igs_en_stdnt_ps_att sca ,
125: igs_en_spa_awd_aim spaa,
126: igs_ps_ver crv ,
127: igs_gr_crmn_round crd ,
128: igs_gr_crm_round_prd crdp,

Line 199: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE DEFAULT 0;

195: gr.s_graduand_type IN (
196: cst_articulate,
197: cst_declined));
198: v_gr_exists VARCHAR2(1);
199: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE DEFAULT 0;
200: v_message_name VARCHAR2(30);
201:
202: --Cursor to check the existence of the SPAA records.
203: CURSOR cur_spaaa (

Line 315: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,

311: App_Exception.Raise_Exception;
312: END grdpl_val_graduand_status;
313: -------------------------------------------------------------------
314: PROCEDURE grdpl_ins_new_graduand(
315: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
316: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
317: p_version_number igs_en_stdnt_ps_att.version_number%TYPE,
318: p_grd_cal_type igs_gr_crmn_round.grd_cal_type%TYPE,
319: p_grd_ci_sequence_number igs_gr_crmn_round.grd_ci_sequence_number%TYPE,

Line 316: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

312: END grdpl_val_graduand_status;
313: -------------------------------------------------------------------
314: PROCEDURE grdpl_ins_new_graduand(
315: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
316: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
317: p_version_number igs_en_stdnt_ps_att.version_number%TYPE,
318: p_grd_cal_type igs_gr_crmn_round.grd_cal_type%TYPE,
319: p_grd_ci_sequence_number igs_gr_crmn_round.grd_ci_sequence_number%TYPE,
320: p_award_cd igs_en_spa_awd_aim.award_cd%TYPE,

Line 317: p_version_number igs_en_stdnt_ps_att.version_number%TYPE,

313: -------------------------------------------------------------------
314: PROCEDURE grdpl_ins_new_graduand(
315: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
316: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
317: p_version_number igs_en_stdnt_ps_att.version_number%TYPE,
318: p_grd_cal_type igs_gr_crmn_round.grd_cal_type%TYPE,
319: p_grd_ci_sequence_number igs_gr_crmn_round.grd_ci_sequence_number%TYPE,
320: p_award_cd igs_en_spa_awd_aim.award_cd%TYPE,
321: p_message_name IN OUT NOCOPY VARCHAR2) AS

Line 447: FROM igs_en_stdnt_ps_att sca

443: p_graduand_status IS NOT NULL AND p_approval_status IS NOT NULL THEN
444: DECLARE
445: CURSOR cur_sca IS
446: SELECT sca.course_rqrmnt_complete_ind
447: FROM igs_en_stdnt_ps_att sca
448: WHERE sca.person_id = p_person_id AND
449: sca.course_cd = p_course_cd;
450: rec_sca cur_sca%ROWTYPE;
451: BEGIN

Line 1090: IGS_EN_STDNT_PS_ATT sca

1086: gr.grd_cal_type,
1087: gr.grd_ci_sequence_number
1088: FROM IGS_GR_GRADUAND gr,
1089: IGS_GR_STAT gst,
1090: IGS_EN_STDNT_PS_ATT sca
1091: WHERE gr.grd_cal_type = p_grd_cal_type AND
1092: gr.grd_ci_sequence_number = p_grd_ci_sequence_number AND
1093: gr.graduand_status = gst.graduand_status AND
1094: gst.s_graduand_status <> cst_surrender AND