DBA Data[Home] [Help]

APPS.IGS_PS_UOFR_WLST_PRF_PKG dependencies on IGS_PS_UOFR_WLST_PRF_S

Line 422: SELECT IGS_PS_UOFR_WLST_PRF_S.NEXTVAL

418: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
419: IGS_GE_MSG_STACK.ADD;
420: app_exception.raise_exception;
421: end if;
422: SELECT IGS_PS_UOFR_WLST_PRF_S.NEXTVAL
423: INTO X_UNIT_OFR_WL_PREF_ID
424: FROM dual;
425: Before_DML(
426: p_action=>'INSERT',

Line 580: update IGS_PS_UOFR_WLST_PRF set

576: x_created_by=>X_LAST_UPDATED_BY,
577: x_last_update_date=>X_LAST_UPDATE_DATE,
578: x_last_updated_by=>X_LAST_UPDATED_BY,
579: x_last_update_login=>X_LAST_UPDATE_LOGIN);
580: update IGS_PS_UOFR_WLST_PRF set
581: UNIT_OFR_WAITLIST_PRIORITY_ID = NEW_REFERENCES.UNIT_OFR_WAITLIST_PRIORITY_ID,
582: PREFERENCE_ORDER = NEW_REFERENCES.PREFERENCE_ORDER,
583: PREFERENCE_CODE = NEW_REFERENCES.PREFERENCE_CODE,
584: PREFERENCE_VERSION = NEW_REFERENCES.PREFERENCE_VERSION,