APPS.IES_SAVE_METADATA dependencies on IES_META_PROP_DATATYPES

Line 67: INSERT INTO IES_META_PROP_DATATYPES (type_id, type_name, created_by)

63: end insert_meta_props;
64:
65: Procedure insert_meta_prop_datatypes(p_datatype IN VARCHAR2) IS
66: begin
67: INSERT INTO IES_META_PROP_DATATYPES (type_id, type_name, created_by)
68: SELECT ies_meta_prop_datatypes_s.nextval, p_datatype, 1
69: FROM dual
70: WHERE NOT EXISTS (SELECT 1
71: FROM IES_META_PROP_DATATYPES

Line 68: SELECT ies_meta_prop_datatypes_s.nextval, p_datatype, 1

64:
65: Procedure insert_meta_prop_datatypes(p_datatype IN VARCHAR2) IS
66: begin
67: INSERT INTO IES_META_PROP_DATATYPES (type_id, type_name, created_by)
68: SELECT ies_meta_prop_datatypes_s.nextval, p_datatype, 1
69: FROM dual
70: WHERE NOT EXISTS (SELECT 1
71: FROM IES_META_PROP_DATATYPES
72: WHERE type_name = p_datatype);

Line 71: FROM IES_META_PROP_DATATYPES

67: INSERT INTO IES_META_PROP_DATATYPES (type_id, type_name, created_by)
68: SELECT ies_meta_prop_datatypes_s.nextval, p_datatype, 1
69: FROM dual
70: WHERE NOT EXISTS (SELECT 1
71: FROM IES_META_PROP_DATATYPES
72: WHERE type_name = p_datatype);
73: end insert_meta_prop_datatypes;
74:
75: Procedure insert_meta_relationship_types(p_type_name IN VARCHAR2) IS

Line 117: FROM ies_meta_prop_datatypes

113: datatypeId NUMBER;
114: begin
115: SELECT type_id
116: INTO datatypeId
117: FROM ies_meta_prop_datatypes
118: WHERE type_name = p_datatype;
119:
120: RETURN datatypeId;
121: end get_prop_datatype_id;