DBA Data[Home] [Help]

APPS.IGS_GR_VAL_GAC dependencies on IGS_GE_MEASUREMENT

Line 593: p_measurement_cd IGS_GE_MEASUREMENT.measurement_cd%TYPE ,

589: END grdp_val_acusg_close;
590: --
591: -- Validate a measurement code is not closed.
592: FUNCTION GRDP_VAL_MSR_CLOSED(
593: p_measurement_cd IGS_GE_MEASUREMENT.measurement_cd%TYPE ,
594: p_message_name OUT NOCOPY VARCHAR2 )
595: RETURN BOOLEAN AS
596: BEGIN -- GRDP_VAL_MSR_CLOSED
597: -- Validate if the measurement is closed.

Line 601: FROM IGS_GE_MEASUREMENT msr

597: -- Validate if the measurement is closed.
598: DECLARE
599: CURSOR c_MSR IS
600: SELECT 'X'
601: FROM IGS_GE_MEASUREMENT msr
602: WHERE msr.measurement_cd = p_measurement_cd AND
603: msr.closed_ind = 'Y';
604: v_msr_exists VARCHAR2(1);
605: BEGIN