[Home] [Help]
777: ,PROGRAM_ID
778: ,PROGRAM_APPLICATION_ID
779: ,PROGRAM_UPDATE_DATE
780: ) values (
781: IGS_AD_UNIT_SETS_S.NEXTVAL
782: ,NEW_REFERENCES.PERSON_ID
783: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
784: ,NEW_REFERENCES.NOMINATED_COURSE_CD
785: ,NEW_REFERENCES.SEQUENCE_NUMBER
972:
973: IF (x_mode = 'S') THEN
974: igs_sc_gen_001.set_ctx('R');
975: END IF;
976: update IGS_AD_UNIT_SETS set
977: PERSON_ID = NEW_REFERENCES.PERSON_ID,
978: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
979: NOMINATED_COURSE_CD = NEW_REFERENCES.NOMINATED_COURSE_CD,
980: SEQUENCE_NUMBER = NEW_REFERENCES.SEQUENCE_NUMBER,