DBA Data[Home] [Help]

APPS.IGS_AD_APPL_NOTES_PKG dependencies on IGS_AD_APPL_NOTES_S

Line 618: IGS_AD_APPL_NOTES_S.NEXTVAL

614: ,PROGRAM_ID
615: ,PROGRAM_APPLICATION_ID
616: ,PROGRAM_UPDATE_DATE
617: ) values (
618: IGS_AD_APPL_NOTES_S.NEXTVAL
619: ,NEW_REFERENCES.PERSON_ID
620: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
621: ,NEW_REFERENCES.NOMINATED_COURSE_CD
622: ,NEW_REFERENCES.SEQUENCE_NUMBER

Line 809: update IGS_AD_APPL_NOTES set

805:
806: IF (x_mode = 'S') THEN
807: igs_sc_gen_001.set_ctx('R');
808: END IF;
809: update IGS_AD_APPL_NOTES set
810: PERSON_ID = NEW_REFERENCES.PERSON_ID,
811: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
812: NOMINATED_COURSE_CD = NEW_REFERENCES.NOMINATED_COURSE_CD,
813: SEQUENCE_NUMBER = NEW_REFERENCES.SEQUENCE_NUMBER,