eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AV_GEN_001 dependencies on IGS_AV_ADV_STANDING_ALL

Line 84: FROM IGS_AV_ADV_STANDING_ALL asal

80: asua.as_course_cd = p_course_cd ;
81:
82: CURSOR c_adv_all IS
83: SELECT rowid
84: FROM IGS_AV_ADV_STANDING_ALL asal
85: WHERE asal.person_id = p_person_id AND
86: asal.course_cd = p_course_cd;
87:
88: CURSOR c_unit_lvl_all IS

Line 193: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted from IGS_AV_ADV_STANDING_ALL');

189: igs_av_adv_standing_pkg.DELETE_ROW (
190: X_ROWID => v_adv_all.rowid );
191:
192: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
193: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted from IGS_AV_ADV_STANDING_ALL');
194: END IF;
195:
196: END LOOP;
197:

Line 2158: FROM igs_av_adv_standing_all

2154:
2155: CURSOR c_adv_stnd
2156: IS
2157: SELECT *
2158: FROM igs_av_adv_standing_all
2159: WHERE person_id = p_person_id
2160: AND course_cd = p_course_cd
2161: AND version_number = p_version_number;
2162:

Line 2227: UPDATE igs_av_adv_standing_all

2223: INTO l_grnt_val;
2224:
2225: CLOSE c_granted;
2226:
2227: UPDATE igs_av_adv_standing_all
2228: SET total_exmptn_approved = l_app_val,
2229: total_exmptn_granted = l_grnt_val
2230: WHERE person_id = p_person_id
2231: AND course_cd = p_course_cd