370: FUNCTION Structure_Type( p_structure_type_name IN VARCHAR2,
371: x_err_text IN OUT NOCOPY VARCHAR2 )
372: RETURN NUMBER
373: IS
374: l_structure_type_id BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_ID%TYPE;
375: BEGIN
376: SELECT STRUCTURE_TYPE_ID
377: INTO l_structure_type_id
378: FROM BOM_STRUCTURE_TYPES_B
374: l_structure_type_id BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_ID%TYPE;
375: BEGIN
376: SELECT STRUCTURE_TYPE_ID
377: INTO l_structure_type_id
378: FROM BOM_STRUCTURE_TYPES_B
379: WHERE STRUCTURE_TYPE_NAME = p_structure_type_name
380: AND ( DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE );
381:
382: RETURN l_structure_type_id;