APPS.IES_META_DATA_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

        'SELECT a.primary_obj_id
          FROM ies_meta_obj_relationships a
         WHERE a.primary_obj_id = :primObjId
           AND a.secondary_obj_id = :secObjId
           AND a.type_id = :typeId' using primObjId, secObjId, typeId;

Line: 51

         'SELECT object_id
            FROM ies_meta_objects
           WHERE object_uid = :x_uid' using uid;

Line: 75

         'SELECT 1
            FROM ies_meta_library
           WHERE object_id = :x_id' using objectId;

Line: 93

        insertStmt varchar2(2000);

Line: 97

          execute immediate 'SELECT ies_meta_library_s.nextval from dual' into seqval;

Line: 98

          insertStmt := 'INSERT INTO ies_meta_library(libobj_id,
 	                                             object_id,
 	                                             created_by)
 	                                     VALUES (:seq,
 	                                             :x_objId,
                                                      1)';

Line: 104

           EXECUTE IMMEDIATE insertStmt using seqval, objectId;

Line: 189

             execute immediate 'select ies_meta_obj_relationships_s.nextval from dual' into seqval;

Line: 190

             sqlStmt := 'INSERT INTO ies_meta_obj_relationships (
                                                   objrel_id,
                                                   obj_Order,
                                                   primary_obj_id,
                                                   secondary_obj_id,
                                                   type_id,
                                                   created_by)
                                           VALUES (:seq,
                                                   :objectOrder,
                                                   :primObjId,
                                                   :secObjId,
                                                   :typeId,
                                                   1)';

Line: 205

            sqlStmt  := 'UPDATE ies_meta_obj_relationships SET obj_order = :objectOrder
                          WHERE primary_obj_id = :primObjId
                            AND secondary_obj_id = :secObjId
                            AND type_id          = :typeId';

Line: 272

              objId := IES_META_DATA_INSERTER.insertMetaObject(e); /* If object does not exist, insert record */

Line: 274

              objId := IES_META_DATA_UPDATER.updateMetaObject(e);  /* Otherwise update existing record */