DBA Data[Home] [Help]

APPS.IGS_PS_USEC_CAL_NUMS_PKG dependencies on IGS_PS_USEC_CAL_NUMS_S

Line 348: IGS_PS_USEC_CAL_NUMS_S.nextval

344: IGS_GE_MSG_STACK.ADD;
345: app_exception.raise_exception;
346: end if;
347: SELECT
348: IGS_PS_USEC_CAL_NUMS_S.nextval
349: INTO
350: x_unit_section_call_number_id
351: FROM
352: dual;

Line 498: update IGS_PS_USEC_CAL_NUMS set

494: x_created_by=>X_LAST_UPDATED_BY,
495: x_last_update_date=>X_LAST_UPDATE_DATE,
496: x_last_updated_by=>X_LAST_UPDATED_BY,
497: x_last_update_login=>X_LAST_UPDATE_LOGIN);
498: update IGS_PS_USEC_CAL_NUMS set
499: CALENDER_TYPE = NEW_REFERENCES.CALENDER_TYPE,
500: CI_SEQUENCE_NUMBER = NEW_REFERENCES.CI_SEQUENCE_NUMBER,
501: CALL_NUMBER = NEW_REFERENCES.CALL_NUMBER,
502: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,