APPS.IGS_EN_GEN_009 dependencies on IGS_EN_SPA_AWD_AIM

Line 449: || (reverse chronological order - newest change first) igs_en_spa_awd_aim

445: || Prajeesh Chandran .K 11-Jun-2002
446: || Added a check saying if in insert row of student program attempt is called
447: || it insert the awards else if called in udpaterow it updates the date or inserts the new awards which is not
448: || already inserted.
449: || (reverse chronological order - newest change first) igs_en_spa_awd_aim
450: */
451: CURSOR cur_caw IS
452: SELECT caw.award_cd, awd.grading_schema_cd, awd.gs_version_number
453: FROM igs_ps_award caw, igs_ps_awd awd

Line 462: FROM igs_en_spa_awd_aim awd

458: caw.award_cd = awd.award_cd;
459:
460: CURSOR cur_spaa_awd_cnt IS
461: SELECT count(*)
462: FROM igs_en_spa_awd_aim awd
463: WHERE person_id = p_person_id AND
464: course_cd = p_course_cd;
465:
466: CURSOR cur_spaa_awd IS

Line 468: FROM igs_en_spa_awd_aim awd

464: course_cd = p_course_cd;
465:
466: CURSOR cur_spaa_awd IS
467: SELECT awd.*, awd.rowid
468: FROM igs_en_spa_awd_aim awd
469: WHERE person_id = p_person_id AND
470: course_cd = p_course_cd;
471:
472: CURSOR cur_course IS

Line 500: igs_en_spa_awd_aim_pkg.insert_row (

496: ELSE
497: l_end_date := NULL;
498: END IF;
499: FOR v_cur_caw IN cur_caw LOOP
500: igs_en_spa_awd_aim_pkg.insert_row (
501: x_rowid => lv_rowid,
502: x_person_id => p_person_id,
503: x_course_cd => p_course_cd,
504: x_award_cd => v_cur_caw.award_cd,

Line 520: igs_en_spa_awd_aim_pkg.update_row (

516: ELSE -- l_spaa_awd_cnt > 0
517: FOR l_spaa_awd_rec IN cur_spaa_awd LOOP
518: IF p_start_dt IS NOT NULL AND
519: p_start_dt <> l_spaa_awd_rec.start_dt THEN
520: igs_en_spa_awd_aim_pkg.update_row (
521: x_rowid => l_spaa_awd_rec.rowid,
522: x_person_id => l_spaa_awd_rec.person_id,
523: x_course_cd => l_spaa_awd_rec.course_cd,
524: x_award_cd => l_spaa_awd_rec.award_cd,