DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on STANDARD

Line 792: VN_STANDARD_WHO_COUNT NUMBER;

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: --

Line 987: INTO VN_STANDARD_WHO_COUNT

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

Line 997: IF VN_STANDARD_WHO_COUNT = 5 THEN

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'

Line 2919: VV_LOV_TYPE := 'STANDARD';

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.');