[Home] [Help]
26: X_LAST_UPDATE_DATE in DATE,
27: X_LAST_UPDATED_BY in NUMBER,
28: X_LAST_UPDATE_LOGIN in NUMBER
29: ) is
30: cursor C is select ROWID from FEM_DIM_ATTRIBUTES_B
31: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
32: ;
33: begin
34: insert into FEM_DIM_ATTRIBUTES_B (
30: cursor C is select ROWID from FEM_DIM_ATTRIBUTES_B
31: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
32: ;
33: begin
34: insert into FEM_DIM_ATTRIBUTES_B (
35: ATTRIBUTE_ID,
36: ATTRIBUTE_VARCHAR_LABEL,
37: DIMENSION_ID,
38: ATTRIBUTE_DIMENSION_ID,
156: PERSONAL_FLAG,
157: READ_ONLY_FLAG,
158: OBJECT_VERSION_NUMBER,
159: USER_ASSIGN_ALLOWED_FLAG
160: from FEM_DIM_ATTRIBUTES_B
161: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
162: for update of ATTRIBUTE_ID nowait;
163: recinfo c%rowtype;
164:
245: X_LAST_UPDATED_BY in NUMBER,
246: X_LAST_UPDATE_LOGIN in NUMBER
247: ) is
248: begin
249: update FEM_DIM_ATTRIBUTES_B set
250: ATTRIBUTE_VARCHAR_LABEL = X_ATTRIBUTE_VARCHAR_LABEL,
251: DIMENSION_ID = X_DIMENSION_ID,
252: ATTRIBUTE_DIMENSION_ID = X_ATTRIBUTE_DIMENSION_ID,
253: ATTRIBUTE_VALUE_COLUMN_NAME = X_ATTRIBUTE_VALUE_COLUMN_NAME,
297: if (sql%notfound) then
298: raise no_data_found;
299: end if;
300:
301: delete from FEM_DIM_ATTRIBUTES_B
302: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
303:
304: if (sql%notfound) then
305: raise no_data_found;
311: begin
312: delete from FEM_DIM_ATTRIBUTES_TL T
313: where not exists
314: (select NULL
315: from FEM_DIM_ATTRIBUTES_B B
316: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
317: );
318:
319: update FEM_DIM_ATTRIBUTES_TL T set (