DBA Data[Home] [Help]

APPS.IES_META_DATA_UPDATER dependencies on DUAL

Line 178: execute immediate 'select ies_meta_object_propvals_s.nextval from dual' into seqval;

174: BEGIN
175: for i in 0..propval_tab.last loop
176: propValId := propval_tab(i);
177:
178: execute immediate 'select ies_meta_object_propvals_s.nextval from dual' into seqval;
179: sqlStmt :=
180: 'INSERT INTO ies_meta_object_propvals
181: (objpropval_id,
182: object_id,

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,