788: ORDER BY COLUMN_ID;
789:
790:
791: VN_INTERFACE_EXISTS NUMBER;
792: VN_STANDARD_WHO_COUNT NUMBER;
793: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
794:
795: BEGIN
796: --
983: END IF;
984:
985: BEGIN
986: SELECT COUNT(*)
987: INTO VN_STANDARD_WHO_COUNT
988: FROM BNE_INTERFACE_COLS_B BIC
989: WHERE APPLICATION_ID = P_APPLICATION_ID
990: AND INTERFACE_CODE = P_INTERFACE_CODE
991: AND INTERFACE_COL_NAME IN
993: EXCEPTION
994: WHEN NO_DATA_FOUND THEN NULL;
995: END;
996:
997: IF VN_STANDARD_WHO_COUNT = 5 THEN
998: UPDATE BNE_INTERFACE_COLS_B
999: SET DISPLAY_FLAG = 'N'
1000: ,REQUIRED_FLAG = 'Y'
1001: ,DEFAULT_TYPE = 'ENVIRONMENT'
2915: IF UPPER(P_POPLIST_FLAG) = 'Y'
2916: THEN
2917: VV_LOV_TYPE := 'POPLIST';
2918: ELSE
2919: VV_LOV_TYPE := 'STANDARD';
2920: END IF;
2921:
2922: IF VV_MEAN_COL IS NULL THEN
2923: RAISE_APPLICATION_ERROR(-20000,'Required: The meaning column is NULL.');