APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_EN_SPA_AWD_AIM

Line 1601: FROM igs_en_spa_awd_aim spaa

1597: p_award_cd igs_ps_awd.AWARD_CD%TYPE) IS
1598: -- Cursor to get all the award aims which are to be updated with the award marks and award grades...
1599: CURSOR cur_spaa(cp_awd_cd VARCHAR2) IS
1600: SELECT spaa.rowid row_id, spaa.*
1601: FROM igs_en_spa_awd_aim spaa
1602: WHERE spaa.AWARD_CD = cp_awd_cd AND
1603: spaa.AWARD_MARK IS NULL AND
1604: spaa.AWARD_GRADE IS NULL;
1605:

Line 1622: lAwdMark igs_en_spa_awd_aim.AWARD_MARK%TYPE;

1618: AND gs.grading_schema_cd = cp_grd_sch
1619: AND gs.version_number = cp_grd_ver
1620: AND gsg.GRADE = cp_grade;
1621:
1622: lAwdMark igs_en_spa_awd_aim.AWARD_MARK%TYPE;
1623: lAwadrdGrade IGS_as_grd_sch_grade.Grade%TYPE;
1624: lReturnStatus VARCHAR2(10);
1625: lMsgData VARCHAR2(2000);
1626: l_enc_msg VARCHAR2(2000);

Line 1701: igs_en_spa_awd_aim_pkg.update_row(

1697:
1698: ELSE -- The mark and honors level were calculated successfully. Now update the SPAA record.
1699: fnd_file.put_line (fnd_file.LOG,'-------------------------***----------------------');
1700: BEGIN
1701: igs_en_spa_awd_aim_pkg.update_row(
1702: x_rowid => spaa_rec.row_id,
1703: x_person_id => spaa_rec.person_id,
1704: x_course_cd => spaa_rec.course_cd,
1705: x_award_cd => spaa_rec.award_cd,