52: Procedure insert_meta_props(p_prop_name IN VARCHAR2, p_datatype IN VARCHAR2) IS
53: dataTypeId NUMBER;
54: begin
55: dataTypeId := get_prop_datatype_id(p_datatype);
56: INSERT INTO IES_META_PROPERTIES (property_id, name, datatype_id, created_by)
57: SELECT ies_meta_properties_s.nextval, p_prop_name, datatypeId, 1
58: FROM dual
59: WHERE NOT EXISTS (SELECT 1
60: FROM IES_META_PROPERTIES
53: dataTypeId NUMBER;
54: begin
55: dataTypeId := get_prop_datatype_id(p_datatype);
56: INSERT INTO IES_META_PROPERTIES (property_id, name, datatype_id, created_by)
57: SELECT ies_meta_properties_s.nextval, p_prop_name, datatypeId, 1
58: FROM dual
59: WHERE NOT EXISTS (SELECT 1
60: FROM IES_META_PROPERTIES
61: WHERE name = p_prop_name
56: INSERT INTO IES_META_PROPERTIES (property_id, name, datatype_id, created_by)
57: SELECT ies_meta_properties_s.nextval, p_prop_name, datatypeId, 1
58: FROM dual
59: WHERE NOT EXISTS (SELECT 1
60: FROM IES_META_PROPERTIES
61: WHERE name = p_prop_name
62: AND datatype_id = datatypeId);
63: end insert_meta_props;
64:
91: propId NUMBER;
92: begin
93: SELECT property_id
94: INTO propId
95: FROM ies_meta_properties
96: WHERE name = p_prop_name;
97:
98: RETURN propId;
99: end get_prop_id;