APPS.IGS_GR_GEN_002 dependencies on IGS_EN_SPA_AWD_AIM

Line 125: igs_en_spa_awd_aim spaa,

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,
129: igs_ca_da_inst_v dai1,

Line 184: cp_award_cd igs_en_spa_awd_aim.award_cd%TYPE) IS

180:
181: CURSOR c_gr (
182: cp_person_id igs_gr_graduand.person_id%TYPE,
183: cp_course_cd igs_gr_graduand.course_cd%TYPE,
184: cp_award_cd igs_en_spa_awd_aim.award_cd%TYPE) IS
185: SELECT 'x'
186: FROM igs_gr_graduand gr,
187: IGS_GR_STAT gst
188: WHERE gr.person_id = cp_person_id AND

Line 204: cp_person_id igs_en_spa_awd_aim.person_id%TYPE,

200: v_message_name VARCHAR2(30);
201:
202: --Cursor to check the existence of the SPAA records.
203: CURSOR cur_spaaa (
204: cp_person_id igs_en_spa_awd_aim.person_id%TYPE,
205: cp_course_cd igs_en_spa_awd_aim.course_cd%TYPE) IS
206: SELECT 'x'
207: FROM igs_en_spa_awd_aim
208: WHERE person_id = cp_person_id AND

Line 205: cp_course_cd igs_en_spa_awd_aim.course_cd%TYPE) IS

201:
202: --Cursor to check the existence of the SPAA records.
203: CURSOR cur_spaaa (
204: cp_person_id igs_en_spa_awd_aim.person_id%TYPE,
205: cp_course_cd igs_en_spa_awd_aim.course_cd%TYPE) IS
206: SELECT 'x'
207: FROM igs_en_spa_awd_aim
208: WHERE person_id = cp_person_id AND
209: course_cd = cp_course_cd;

Line 207: FROM igs_en_spa_awd_aim

203: CURSOR cur_spaaa (
204: cp_person_id igs_en_spa_awd_aim.person_id%TYPE,
205: cp_course_cd igs_en_spa_awd_aim.course_cd%TYPE) IS
206: SELECT 'x'
207: FROM igs_en_spa_awd_aim
208: WHERE person_id = cp_person_id AND
209: course_cd = cp_course_cd;
210: rec_spaaa cur_spaaa%ROWTYPE;
211:

Line 320: p_award_cd igs_en_spa_awd_aim.award_cd%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
322: --
323: -- Change History :
324: -- Who When What

Line 340: FROM igs_en_spa_awd_aim spaaa

336: SELECT spaaa.award_cd,
337: spaaa.start_dt,
338: spaaa.complete_ind,
339: spaaa.conferral_date
340: FROM igs_en_spa_awd_aim spaaa
341: WHERE spaaa.person_id = p_person_id
342: AND spaaa.course_cd = p_course_cd
343: AND spaaa.award_cd = p_award_cd
344: AND ((spaaa.end_dt is NULL OR spaaa.complete_ind = 'Y')

Line 364: FROM igs_en_spa_awd_aim spaaa

360: -- Added to fix Bug# 2683072
361: --
362: CURSOR c_spaaa_chk IS
363: SELECT 'X'
364: FROM igs_en_spa_awd_aim spaaa
365: WHERE spaaa.person_id = p_person_id
366: AND spaaa.course_cd = p_course_cd
367: AND spaaa.award_cd = p_award_cd
368: AND NOT EXISTS (

Line 593: FROM igs_en_spa_awd_aim spaaa

589:
590: DECLARE
591: CURSOR cur_spaa_gr_dif IS
592: SELECT 'X'
593: FROM igs_en_spa_awd_aim spaaa
594: WHERE spaaa.person_id = p_person_id
595: AND spaaa.course_cd = p_course_cd
596: AND spaaa.award_cd = p_award_cd
597: AND EXISTS (

Line 701: igs_en_spa_awd_aim_pkg.insert_row(

697: l_row_id VARCHAR2(30);
698: BEGIN
699: --Loop through all Defaulted Awards and create the SPAA records.
700: FOR rec_def_awds IN cur_def_awds LOOP
701: igs_en_spa_awd_aim_pkg.insert_row(
702: X_ROWID => l_row_id,
703: X_PERSON_ID => v_crd_sca_rec.person_id,
704: X_COURSE_CD => v_crd_sca_rec.course_cd,
705: X_AWARD_CD => rec_def_awds.award_cd,

Line 1360: FROM IGS_EN_SPA_AWD_AIM spaaa

1356: cp_person_id IGS_GR_GRADUAND.person_id%TYPE,
1357: cp_course_cd IGS_GR_GRADUAND.course_cd%TYPE,
1358: cp_award_cd IGS_GR_GRADUAND.award_cd%TYPE) IS
1359: SELECT '1'
1360: FROM IGS_EN_SPA_AWD_AIM spaaa
1361: WHERE spaaa.person_id = cp_person_id
1362: AND spaaa.course_cd = cp_course_cd
1363: AND spaaa.award_cd = cp_award_cd
1364: AND spaaa.complete_ind='Y';