APPS.IGS_PS_NOTE_TYPES_PKG dependencies on IGS_PS_NOTE_TYPES_S

Line 418: SELECT igs_ps_note_types_s.nextval

414: IGS_GE_MSG_STACK.ADD;
415: app_exception.raise_exception;
416: end if;
417: ----
418: SELECT igs_ps_note_types_s.nextval
419: INTO x_NOTE_TYPE_ID
420: FROM dual;
421: ---
422:

Line 576: update IGS_PS_NOTE_TYPES set

572: x_created_by=>X_LAST_UPDATED_BY,
573: x_last_update_date=>X_LAST_UPDATE_DATE,
574: x_last_updated_by=>X_LAST_UPDATED_BY,
575: x_last_update_login=>X_LAST_UPDATE_LOGIN);
576: update IGS_PS_NOTE_TYPES set
577: NOTE_TYPE = NEW_REFERENCES.NOTE_TYPE,
578: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
579: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
580: CATALOG_SCHEDULE = NEW_REFERENCES.CATALOG_SCHEDULE,