APPS.IGS_PS_UNIT_CROS_REF_PKG dependencies on IGS_PS_UNIT_CROS_REF_S

Line 446: SELECT IGS_PS_UNIT_CROS_REF_S.NEXTVAL INTO X_UNIT_CROSS_REFERENCE_ID FROM DUAL;

442: IGS_GE_MSG_STACK.ADD;
443: app_exception.raise_exception;
444: end if;
445:
446: SELECT IGS_PS_UNIT_CROS_REF_S.NEXTVAL INTO X_UNIT_CROSS_REFERENCE_ID FROM DUAL;
447:
448:
449: Before_DML(
450: p_action=>'INSERT',

Line 602: update IGS_PS_UNIT_CROS_REF set

598: x_created_by=>X_LAST_UPDATED_BY,
599: x_last_update_date=>X_LAST_UPDATE_DATE,
600: x_last_updated_by=>X_LAST_UPDATED_BY,
601: x_last_update_login=>X_LAST_UPDATE_LOGIN);
602: update IGS_PS_UNIT_CROS_REF set
603: PARENT_UNIT_CODE = NEW_REFERENCES.PARENT_UNIT_CODE,
604: PARENT_UNIT_VERSION_NUMBER = NEW_REFERENCES.PARENT_UNIT_VERSION_NUMBER,
605: CHILD_UNIT_CODE = NEW_REFERENCES.CHILD_UNIT_CODE,
606: CHILD_UNIT_VERSION_NUMBER = NEW_REFERENCES.CHILD_UNIT_VERSION_NUMBER,