DBA Data[Home] [Help]

APPS.IGS_PS_VAL_UV dependencies on IGS_PS_VAL_UOO

Line 732: IF (IGS_PS_VAL_UOo.crsp_val_loc_cd(

728: END IF;
729: -- Validate that if IGS_PS_UNIT_OFR_OPT records exist, then
730: -- check that location_cd and IGS_AS_UNIT_CLASS is not closed.
731: FOR uoo_rec IN c_unit_offering_option LOOP
732: IF (IGS_PS_VAL_UOo.crsp_val_loc_cd(
733: uoo_rec.location_cd,
734: p_message_name) = FALSE) THEN
735: v_terminate := TRUE;
736: EXIT;

Line 738: IF (IGS_PS_VAL_UOo.crsp_val_uoo_uc(

734: p_message_name) = FALSE) THEN
735: v_terminate := TRUE;
736: EXIT;
737: END IF;
738: IF (IGS_PS_VAL_UOo.crsp_val_uoo_uc(
739: uoo_rec.unit_class,
740: p_message_name) = FALSE) THEN
741: v_terminate := TRUE;
742: EXIT;

Line 746: IF (IGS_PS_VAL_UOo.crsp_val_uoo_contact(

742: EXIT;
743: END IF;
744: IF NVL(uoo_rec.unit_contact, 9999999999) <> 9999999999 THEN
745: -- Validate that the IGS_PS_UNIT contact is a staff member
746: IF (IGS_PS_VAL_UOo.crsp_val_uoo_contact(
747: uoo_rec.unit_contact,
748: p_message_name) = FALSE) THEN
749: v_terminate := TRUE;
750: EXIT;