APPS.IGS_AD_APPL_NOTES_PKG dependencies on IGS_GE_NOTE

Line 482: rboddu 21-jan-2002 added igs_ge_note_pkg.delete_row Bug:2177686

478: Purpose :
479: Know limitations, enhancements or remarks
480: Change History
481: Who When What
482: rboddu 21-jan-2002 added igs_ge_note_pkg.delete_row Bug:2177686
483:
484: (reverse chronological order - newest change first)
485: ***************************************************************/
486:

Line 489: FROM IGS_GE_NOTE

485: ***************************************************************/
486:
487: CURSOR C_NOTE IS
488: SELECT ROWID
489: FROM IGS_GE_NOTE
490: WHERE REFERENCE_NUMBER = (SELECT ref_notes_id FROM igs_ad_appl_notes WHERE rowid = x_rowid);
491:
492: BEGIN
493:

Line 506: IGS_GE_NOTE_pkg.delete_row(C_NOTE_REC.ROWID);

502: ELSIF (p_action = 'DELETE') THEN
503: -- Call all the procedures related to After Delete.
504: FOR C_NOTE_REC IN C_NOTE
505: LOOP
506: IGS_GE_NOTE_pkg.delete_row(C_NOTE_REC.ROWID);
507: END LOOP;
508:
509: END IF;
510:

Line 624: ,IGS_GE_NOTE_RF_NUM_S.NEXTVAL

620: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
621: ,NEW_REFERENCES.NOMINATED_COURSE_CD
622: ,NEW_REFERENCES.SEQUENCE_NUMBER
623: ,NEW_REFERENCES.NOTE_TYPE_ID
624: ,IGS_GE_NOTE_RF_NUM_S.NEXTVAL
625: ,X_LAST_UPDATE_DATE
626: ,X_LAST_UPDATED_BY
627: ,X_LAST_UPDATE_DATE
628: ,X_LAST_UPDATED_BY