eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IES_META_DATA_UPDATER dependencies on IES_META_OBJECT_PROPVALS

Line 127: ies_meta_object_propvals a,

123: PROCEDURE updatePropertyValues(element IN xmldom.DOMElement, uid IN varchar2) IS
124: CURSOR getPropertiesForObject IS
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

Line 165: -- into ies_meta_object_propvals table.

161: -- **********************************************************************
162: -- API name : insertObjPropertyValues
163: -- Type : Private
164: -- Function : This procedure inserts the property values of the object
165: -- into ies_meta_object_propvals table.
166: -- **********************************************************************
167:
168: PROCEDURE insertObjPropertyValues(propval_tab IN propval_table, objUID IN VARCHAR2) IS
169: propValId number;

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 180: 'INSERT INTO ies_meta_object_propvals

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,
183: propval_id,
184: created_by) SELECT :seq,

Line 199: -- later inserted into ies_meta_object_propvals table. Filter

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: -- **********************************************************************
202:
203:

Line 232: ies_meta_object_propvals a,

228: FROM ies_meta_objects
229: WHERE object_uid = :aUID))
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