APPS.IES_META_OBJ_PKG dependencies on IES_META_OBJECT_PROPVALS

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 146: execute immediate 'delete from IES_META_OBJECT_PROPVALS where propval_id = :id' using propValId;

142: FETCH propval INTO propValId;
143: EXIT WHEN propval%NOTFOUND;
144:
145: deletePropVals(propValId, x_prop_name);
146: execute immediate 'delete from IES_META_OBJECT_PROPVALS where propval_id = :id' using propValId;
147: END LOOP;
148: CLOSE propval;
149: END deleteObjectPropVals;
150: --

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 444: execute immediate 'select IES_META_OBJECT_PROPVALS_S.NEXTVAL from dual' into seqVal;

440: insertStmt varchar2(2000);
441: begin
442: objId := getObjectId(x_object_uid);
443:
444: execute immediate 'select IES_META_OBJECT_PROPVALS_S.NEXTVAL from dual' into seqVal;
445:
446: insertStmt := 'insert into IES_META_OBJECT_PROPVALS(
447: OBJPROPVAL_ID,
448: CREATION_DATE,

Line 446: insertStmt := 'insert into IES_META_OBJECT_PROPVALS(

442: objId := getObjectId(x_object_uid);
443:
444: execute immediate 'select IES_META_OBJECT_PROPVALS_S.NEXTVAL from dual' into seqVal;
445:
446: insertStmt := 'insert into IES_META_OBJECT_PROPVALS(
447: OBJPROPVAL_ID,
448: CREATION_DATE,
449: CREATED_BY,
450: LAST_UPDATE_DATE,

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