DBA Data[Home] [Help]

APPS.IGS_HE_MRK_PROG_ATT_PKG dependencies on IGS_HE_ST_SPA_ALL

Line 12: Purpose : To update the marked program attempts in the IGS_HE_ST_SPA_ALL table Know limitations, enhancements or remarks

8:
9: /*************************************************************
10: Created By : sowsubra
11: Date Created By : 21-JAN-2002
12: Purpose : To update the marked program attempts in the IGS_HE_ST_SPA_ALL table Know limitations, enhancements or remarks
13: Change History
14: Who When What
15: anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
16:

Line 36: UPDATE igs_he_st_spa_all

32: LOOP
33: IF (( get_details_rec.person_id IS NOT NULL ) AND
34: ( get_details_rec.course_cd IS NOT NULL ) AND
35: ( get_details_rec.student_inst_number IS NOT NULL )) THEN
36: UPDATE igs_he_st_spa_all
37: SET HESA_SUBMISSION_NAME = l_submission_name,
38: HESA_RETURN_NAME =l_return_name,
39: HESA_RETURN_ID = l_extract_run_id
40: WHERE PERSON_ID = get_details_rec.person_id AND