APPS.IGS_HE_IMPORT_DATA dependencies on IGS_HE_ST_SPA_ALL

Line 1188: FROM igs_he_st_spa_all

1184: -- get the student program attempt hesa record
1185: CURSOR c_spa( cp_person_id igs_he_st_spa.person_id%TYPE ,
1186: cp_course_cd igs_he_st_spa.course_cd%TYPE ) IS
1187: SELECT person_id ,course_cd , version_number
1188: FROM igs_he_st_spa_all
1189: WHERE person_id = cp_person_id AND
1190: course_cd = NVL(cp_course_cd,course_cd) ;
1191: l_spa c_spa%ROWTYPE;
1192:

Line 1272: FROM igs_he_st_spa_all spa

1268: -- get the student program attempt hesa record for update
1269: CURSOR c_upd_spa( cp_person_id igs_he_st_spa.person_id%TYPE ,
1270: cp_course_cd igs_he_st_spa.course_cd%TYPE ) IS
1271: SELECT spa.rowid , spa.*
1272: FROM igs_he_st_spa_all spa
1273: WHERE spa.person_id = cp_person_id AND
1274: spa.course_cd = NVL(cp_course_cd,course_cd) ;
1275:
1276: -- get the student unit set attempt hesa record

Line 2400: igs_he_st_spa_all_pkg.update_row (

2396: -- If there is data to be imported into spa record then update student program attempt hesa records
2397: IF l_upd_spa THEN
2398: BEGIN
2399: FOR c_upd_spa_rec IN c_upd_spa( c_pe_det_rec.person_id , c_interface_rec.course_cd) LOOP
2400: igs_he_st_spa_all_pkg.update_row (
2401: X_ROWID => c_upd_spa_rec.rowid ,
2402: X_HESA_ST_SPA_ID => c_upd_spa_rec.hesa_st_spa_id,
2403: X_ORG_ID => c_upd_spa_rec.org_id,
2404: X_PERSON_ID => c_upd_spa_rec.person_id,