APPS.AR_BPA_CONTENT_AREAS_PKG dependencies on AR_BPA_CONTENT_AREAS_B

Line 36: cursor C is select ROWID from AR_BPA_CONTENT_AREAS_B

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from AR_BPA_CONTENT_AREAS_B
37: where CONTENT_AREA_ID = X_CONTENT_AREA_ID
38: ;
39: begin
40: insert into AR_BPA_CONTENT_AREAS_B (

Line 40: insert into AR_BPA_CONTENT_AREAS_B (

36: cursor C is select ROWID from AR_BPA_CONTENT_AREAS_B
37: where CONTENT_AREA_ID = X_CONTENT_AREA_ID
38: ;
39: begin
40: insert into AR_BPA_CONTENT_AREAS_B (
41: CONTENT_AREA_ID,
42: DISPLAY_LEVEL,
43: CONTENT_TYPE,
44: CONTENT_ORIENTATION,

Line 190: from AR_BPA_CONTENT_AREAS_B

186: INVOICE_LINE_TYPE,
187: AREA_CODE,
188: PARENT_AREA_CODE,
189: ITEM_COLUMN_WIDTH
190: from AR_BPA_CONTENT_AREAS_B
191: where CONTENT_AREA_ID = X_CONTENT_AREA_ID
192: for update of CONTENT_AREA_ID nowait;
193: recinfo c%rowtype;
194:

Line 307: update AR_BPA_CONTENT_AREAS_B set

303: X_LAST_UPDATED_BY in NUMBER,
304: X_LAST_UPDATE_LOGIN in NUMBER
305: ) is
306: begin
307: update AR_BPA_CONTENT_AREAS_B set
308: DISPLAY_LEVEL = X_DISPLAY_LEVEL,
309: CONTENT_TYPE = X_CONTENT_TYPE,
310: CONTENT_ORIENTATION = X_CONTENT_ORIENTATION,
311: TEMPLATE_ID = X_TEMPLATE_ID,

Line 365: delete from AR_BPA_CONTENT_AREAS_B

361: if (sql%notfound) then
362: raise no_data_found;
363: end if;
364:
365: delete from AR_BPA_CONTENT_AREAS_B
366: where CONTENT_AREA_ID = X_CONTENT_AREA_ID;
367:
368: if (sql%notfound) then
369: raise no_data_found;

Line 379: from AR_BPA_CONTENT_AREAS_B B

375: begin
376: delete from AR_BPA_CONTENT_AREAS_TL T
377: where not exists
378: (select NULL
379: from AR_BPA_CONTENT_AREAS_B B
380: where B.CONTENT_AREA_ID = T.CONTENT_AREA_ID
381: );
382:
383: update AR_BPA_CONTENT_AREAS_TL T set (