APPS.IES_META_DATA_UPDATER dependencies on IES_META_PROPERTY_VALUES

Line 129: ies_meta_property_values c

125: SELECT b.name, c.propval_id , b.property_id
126: FROM ies_meta_objects o,
127: ies_meta_object_propvals a,
128: ies_meta_properties b,
129: ies_meta_property_values c
130: WHERE o.object_uid = uid
131: AND a.propval_id = c.propval_id
132: AND b.property_id = c.property_id
133: AND o.object_id = a.object_id;

Line 145: sqlStmt := 'UPDATE ies_meta_property_values

141: val := IES_META_DATA_UTIL.getProperty(element, i.name);
142:
143: lookupId := IES_META_DATA_UTIL.getLookupId(i.property_id, val);
144: if (lookupId = -1) then
145: sqlStmt := 'UPDATE ies_meta_property_values
146: SET string_val = :value,
147: last_update_date = sysdate
148: WHERE propval_id = :propvalue_id';
149: EXECUTE IMMEDIATE sqlStmt USING val, i.propval_id;

Line 151: sqlStmt := 'UPDATE ies_meta_property_values

147: last_update_date = sysdate
148: WHERE propval_id = :propvalue_id';
149: EXECUTE IMMEDIATE sqlStmt USING val, i.propval_id;
150: else
151: sqlStmt := 'UPDATE ies_meta_property_values
152: SET lookup_id = :lookupId,
153: last_update_date = sysdate
154: WHERE propval_id = :propvalue_id';
155: EXECUTE IMMEDIATE sqlStmt USING lookupId, i.propval_id;

Line 197: -- ies_meta_property_values table. The inserted propval_ids

193: -- **********************************************************************
194: -- API name : insertNewProperties
195: -- Type : Private
196: -- Function : This procedure inserts the properties into
197: -- ies_meta_property_values table. The inserted propval_ids
198: -- are stored in a pl/sql table and all the propval_ids are
199: -- later inserted into ies_meta_object_propvals table. Filter
200: -- records which already have been inserted.
201: -- **********************************************************************

Line 234: ies_meta_property_values c

230: AND b.property_id NOT IN (SELECT b.property_id
231: FROM ies_meta_objects o,
232: ies_meta_object_propvals a,
233: ies_meta_properties b,
234: ies_meta_property_values c
235: WHERE o.object_uid = :bUID
236: AND a.propval_id = c.propval_id
237: AND b.property_id = c.property_id
238: AND o.object_id = a.object_id)' USING objUID, objUID;

Line 247: select ies_meta_property_values_s.nextval into propValue_id from dual;

243:
244: val := IES_META_DATA_UTIL.getProperty(element, propName);
245:
246: lookupId := IES_META_DATA_UTIL.getLookupId(propId, val);
247: select ies_meta_property_values_s.nextval into propValue_id from dual;
248:
249: if (lookupId = -1) then
250: sqlStmt := 'INSERT INTO ies_meta_property_values (propval_id,
251: property_id,

Line 250: sqlStmt := 'INSERT INTO ies_meta_property_values (propval_id,

246: lookupId := IES_META_DATA_UTIL.getLookupId(propId, val);
247: select ies_meta_property_values_s.nextval into propValue_id from dual;
248:
249: if (lookupId = -1) then
250: sqlStmt := 'INSERT INTO ies_meta_property_values (propval_id,
251: property_id,
252: string_val,
253: created_by)
254: VALUES (:id,

Line 262: sqlStmt := 'INSERT INTO ies_meta_property_values (propval_id,

258:
259: execute immediate sqlStmt using propvalue_id, propId, val;
260: propval_tab(counter) := propvalue_id;
261: else
262: sqlStmt := 'INSERT INTO ies_meta_property_values (propval_id,
263: property_id,
264: lookup_id,
265: created_by)
266: VALUES (:id,