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_OBJ_PKG dependencies on IES_META_OBJECTS

Line 23: -- Add a new record into IES_META_OBJECTS. This is only called after checking

19: end getObjectTypeId;
20:
21: --
22: -- InsertMetaObject )
23: -- Add a new record into IES_META_OBJECTS. This is only called after checking
24: -- there is no such object exists in UploadMetaObject().
25: --
26: procedure InsertMetaObject (
27: x_object_uid in varchar2,

Line 39: execute immediate 'select IES_META_OBJECTS_S.NEXTVAL from dual' into seqval;

35: seqval number;
36: begin
37: typeId := getObjectTypeId(x_object_type);
38:
39: execute immediate 'select IES_META_OBJECTS_S.NEXTVAL from dual' into seqval;
40:
41: insertStmt := 'insert into IES_META_OBJECTS (
42: OBJECT_ID,
43: OBJECT_UID,

Line 41: insertStmt := 'insert into IES_META_OBJECTS (

37: typeId := getObjectTypeId(x_object_type);
38:
39: execute immediate 'select IES_META_OBJECTS_S.NEXTVAL from dual' into seqval;
40:
41: insertStmt := 'insert into IES_META_OBJECTS (
42: OBJECT_ID,
43: OBJECT_UID,
44: NAME,
45: CREATED_BY,

Line 83: from IES_META_OBJECTS

79: objectId NUMBER;
80: begin
81: select OBJECT_ID
82: into objectId
83: from IES_META_OBJECTS
84: where OBJECT_UID = x_object_uid
85: and rownum < 2; -- see comments #2 above for details
86:
87: return objectId;

Line 99: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,

95: propValCount number := 0;
96: begin
97: select count(B.PROPVAL_ID)
98: into propValCount
99: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,
100: IES_META_PROPERTY_VALUES C,
101: IES_META_PROPERTIES D
102: where A.OBJECT_UID = X_OBJECT_UID
103: and A.OBJECT_ID = B.OBJECT_ID

Line 132: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,

128: propValId NUMBER;
129: BEGIN
130: OPEN propval FOR
131: 'select B.PROPVAL_ID
132: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,
133: IES_META_PROPERTY_VALUES C,
134: IES_META_PROPERTIES D
135: where A.OBJECT_UID = :1
136: and A.OBJECT_ID = B.OBJECT_ID

Line 152: -- Update record in IES_META_OBJECTS. This is only called after checking

148: CLOSE propval;
149: END deleteObjectPropVals;
150: --
151: -- UpdateMetaObject )
152: -- Update record in IES_META_OBJECTS. This is only called after checking
153: -- that the object exists in UploadMetaObject().
154: --
155: procedure UpdateMetaObject (
156: x_object_uid in varchar2,

Line 167: updateStmt := 'update IES_META_OBJECTS set

163: updateStmt varchar2(2000);
164: begin
165: typeId := getObjectTypeId(x_object_type);
166:
167: updateStmt := 'update IES_META_OBJECTS set
168: NAME = :name,
169: TYPE_ID = :id,
170: LAST_UPDATE_DATE = :updateDate,
171: LAST_UPDATED_BY = :last_updated_by

Line 214: from ies_meta_objects

210: db_ludate date;
211:
212: CURSOR metaObj_curs IS
213: select last_updated_by, last_update_date
214: from ies_meta_objects
215: where object_uid = x_object_uid
216: and rownum < 2;
217: begin
218:

Line 309: from IES_META_OBJECTS

305: CURSOR metalib_curs IS
306: SELECT libobj_id
307: FROM ies_meta_library
308: WHERE object_id = (select OBJECT_ID
309: from IES_META_OBJECTS
310: where OBJECT_UID = x_object_uid
311: and rownum < 2);
312: begin
313:

Line 352: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,

348: end if;
349:
350: select B.PROPVAL_ID
351: into propValId
352: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,
353: IES_META_PROPERTY_VALUES C,
354: IES_META_PROPERTIES D
355: where A.OBJECT_UID = X_OBJECT_UID
356: and A.OBJECT_ID = B.OBJECT_ID

Line 399: from IES_META_OBJECTS c

395: and A.OBJTYPE_ID IN (select TYPE_ID
396: from IES_META_OBJECT_TYPES
397: connect by prior PARENT_ID = TYPE_ID
398: start with TYPE_ID = (select TYPE_ID
399: from IES_META_OBJECTS c
400: where C.OBJECT_UID = X_OBJECT_UID));
401: return propId;
402: end getPropertyId;
403:

Line 532: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,

528:
529:
530: CURSOR propvals_curs IS
531: select b.last_updated_by, b.last_update_date
532: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,
533: IES_META_PROPERTY_VALUES C,
534: IES_META_PROPERTIES D
535: where A.OBJECT_UID = X_OBJECT_UID
536: and A.OBJECT_ID = B.OBJECT_ID

Line 587: from IES_META_OBJECTS

583: into objRelId
584: from IES_META_OBJ_RELATIONSHIPS C,
585: IES_META_RELATIONSHIP_TYPES D
586: where PRIMARY_OBJ_ID = (select OBJECT_ID
587: from IES_META_OBJECTS
588: where OBJECT_UID = x_prim_obj_uid
589: and rownum < 2)
590: and SECONDARY_OBJ_ID = (select OBJECT_ID
591: from IES_META_OBJECTS

Line 591: from IES_META_OBJECTS

587: from IES_META_OBJECTS
588: where OBJECT_UID = x_prim_obj_uid
589: and rownum < 2)
590: and SECONDARY_OBJ_ID = (select OBJECT_ID
591: from IES_META_OBJECTS
592: where OBJECT_UID = x_sec_obj_uid
593: and rownum < 2)
594: and C.TYPE_ID = D.TYPE_ID
595: and D.TYPE_NAME = x_type_name;

Line 727: from IES_META_OBJECTS

723: select c.last_updated_by, c.last_update_date
724: from IES_META_OBJ_RELATIONSHIPS C,
725: IES_META_RELATIONSHIP_TYPES D
726: where PRIMARY_OBJ_ID = (select OBJECT_ID
727: from IES_META_OBJECTS
728: where OBJECT_UID = x_prim_obj_uid
729: and rownum < 2)
730: and SECONDARY_OBJ_ID = (select OBJECT_ID
731: from IES_META_OBJECTS

Line 731: from IES_META_OBJECTS

727: from IES_META_OBJECTS
728: where OBJECT_UID = x_prim_obj_uid
729: and rownum < 2)
730: and SECONDARY_OBJ_ID = (select OBJECT_ID
731: from IES_META_OBJECTS
732: where OBJECT_UID = x_sec_obj_uid
733: and rownum < 2)
734: and C.TYPE_ID = D.TYPE_ID
735: and D.TYPE_NAME = x_type_name;