APPS.IES_SAVE_METADATA dependencies on IES_META_PROPERTY_LOOKUPS

Line 40: INSERT INTO IES_META_PROPERTY_LOOKUPS

36: propId NUMBER;
37: begin
38: propId := get_prop_id(p_prop_name);
39:
40: INSERT INTO IES_META_PROPERTY_LOOKUPS
41: (prop_lookup_id, property_id, lookup_key, lookup_value, created_by)
42: SELECT ies_meta_property_lookups_s.nextval, propId, p_prop_key, p_prop_val, 1
43: FROM dual
44: WHERE NOT EXISTS (SELECT 1

Line 42: SELECT ies_meta_property_lookups_s.nextval, propId, p_prop_key, p_prop_val, 1

38: propId := get_prop_id(p_prop_name);
39:
40: INSERT INTO IES_META_PROPERTY_LOOKUPS
41: (prop_lookup_id, property_id, lookup_key, lookup_value, created_by)
42: SELECT ies_meta_property_lookups_s.nextval, propId, p_prop_key, p_prop_val, 1
43: FROM dual
44: WHERE NOT EXISTS (SELECT 1
45: FROM IES_META_PROPERTY_LOOKUPS
46: WHERE lookup_key = p_prop_key

Line 45: FROM IES_META_PROPERTY_LOOKUPS

41: (prop_lookup_id, property_id, lookup_key, lookup_value, created_by)
42: SELECT ies_meta_property_lookups_s.nextval, propId, p_prop_key, p_prop_val, 1
43: FROM dual
44: WHERE NOT EXISTS (SELECT 1
45: FROM IES_META_PROPERTY_LOOKUPS
46: WHERE lookup_key = p_prop_key
47: AND lookup_value = p_prop_val
48: AND property_id = propId);
49: