29: X_LAST_UPDATE_DATE in DATE,
30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: ) is
33: cursor C is select ROWID from PA_UTIL_CATEGORIES_B
34: where UTIL_CATEGORY_ID = X_UTIL_CATEGORY_ID
35: ;
36: begin
37: insert into PA_UTIL_CATEGORIES_B (
33: cursor C is select ROWID from PA_UTIL_CATEGORIES_B
34: where UTIL_CATEGORY_ID = X_UTIL_CATEGORY_ID
35: ;
36: begin
37: insert into PA_UTIL_CATEGORIES_B (
38: UTIL_CATEGORY_ID,
39: REPORTING_ORDER,
40: START_DATE_ACTIVE,
41: END_DATE_ACTIVE,
171: ATTRIBUTE12,
172: ATTRIBUTE13,
173: ATTRIBUTE14,
174: ATTRIBUTE15
175: from PA_UTIL_CATEGORIES_B
176: where UTIL_CATEGORY_ID = X_UTIL_CATEGORY_ID
177: for update of UTIL_CATEGORY_ID nowait;
178: recinfo c%rowtype;
179:
280: X_LAST_UPDATED_BY in NUMBER,
281: X_LAST_UPDATE_LOGIN in NUMBER
282: ) is
283: begin
284: update PA_UTIL_CATEGORIES_B set
285: REPORTING_ORDER = X_REPORTING_ORDER,
286: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
287: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
288: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
335: if (sql%notfound) then
336: raise no_data_found;
337: end if;
338:
339: delete from PA_UTIL_CATEGORIES_B
340: where UTIL_CATEGORY_ID = X_UTIL_CATEGORY_ID;
341:
342: if (sql%notfound) then
343: raise no_data_found;
349: begin
350: delete from PA_UTIL_CATEGORIES_TL T
351: where not exists
352: (select NULL
353: from PA_UTIL_CATEGORIES_B B
354: where B.UTIL_CATEGORY_ID = T.UTIL_CATEGORY_ID
355: );
356:
357: update PA_UTIL_CATEGORIES_TL T set (