110: X_LAST_UPDATE_DATE in DATE,
111: X_LAST_UPDATED_BY in NUMBER,
112: X_LAST_UPDATE_LOGIN in NUMBER
113: ) is
114: cursor C is select ROWID from AMV_D_ENT_ATTRIBUTES_B
115: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
116: ;
117: begin
118: insert into AMV_D_ENT_ATTRIBUTES_B (
114: cursor C is select ROWID from AMV_D_ENT_ATTRIBUTES_B
115: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
116: ;
117: begin
118: insert into AMV_D_ENT_ATTRIBUTES_B (
119: ATTRIBUTE_ID,
120: OBJECT_VERSION_NUMBER,
121: ENTITY_ID,
122: DATA_TYPE,
216: VALIDATION_TYPE,
217: RANGE_LOW_VALUE,
218: RANGE_HIGH_VALUE,
219: FUNCTION_CALL
220: from AMV_D_ENT_ATTRIBUTES_B
221: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
222: for update of ATTRIBUTE_ID nowait;
223: recinfo c%rowtype;
224:
294: X_LAST_UPDATED_BY in NUMBER,
295: X_LAST_UPDATE_LOGIN in NUMBER
296: ) is
297: begin
298: update AMV_D_ENT_ATTRIBUTES_B set
299: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
300: ENTITY_ID = X_ENTITY_ID,
301: DATA_TYPE = X_DATA_TYPE,
302: STATUS = X_STATUS,
340: if (sql%notfound) then
341: raise no_data_found;
342: end if;
343:
344: delete from AMV_D_ENT_ATTRIBUTES_B
345: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
346:
347: if (sql%notfound) then
348: raise no_data_found;
354: begin
355: delete from AMV_D_ENT_ATTRIBUTES_TL T
356: where not exists
357: (select NULL
358: from AMV_D_ENT_ATTRIBUTES_B B
359: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
360: );
361:
362: update AMV_D_ENT_ATTRIBUTES_TL T set (