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_EN_GEN_011 dependencies on IGS_HE_ST_SPA_ALL

Line 426: FROM igs_he_st_spa_all spa

422: -- Cursor added as per the HESA DLD Bug 3985220
423: -- Get the hesa program attempt details for update
424: CURSOR c_he_spa_upd IS
425: SELECT spa.rowid , spa.*
426: FROM igs_he_st_spa_all spa
427: WHERE spa.person_id = p_person_id AND
428: spa.course_cd = p_course_cd
429: FOR UPDATE NOWAIT;
430:

Line 751: IGS_HE_ST_SPA_ALL_PKG.UPDATE_ROW (

747: BEGIN
748: FOR v_he_spa_upd_rec IN c_he_spa_upd LOOP
749:
750: -- update the version_number of the hesa program attempt record
751: IGS_HE_ST_SPA_ALL_PKG.UPDATE_ROW (
752: X_ROWID => v_he_spa_upd_rec.rowid ,
753: X_HESA_ST_SPA_ID => v_he_spa_upd_rec.hesa_st_spa_id ,
754: X_ORG_ID => v_he_spa_upd_rec.org_id ,
755: X_PERSON_ID => v_he_spa_upd_rec.person_id ,