APPS.PA_UTIL_CATEGORIES_PKG dependencies on PA_UTIL_CATEGORIES_B

Line 33: cursor C is select ROWID from PA_UTIL_CATEGORIES_B

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 (

Line 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,

Line 175: from PA_UTIL_CATEGORIES_B

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:

Line 284: update PA_UTIL_CATEGORIES_B set

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,

Line 339: delete from PA_UTIL_CATEGORIES_B

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;

Line 353: from PA_UTIL_CATEGORIES_B B

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 (