APPS.AR_BPA_ITEMS_PKG dependencies on AR_BPA_ITEMS_B

Line 36: cursor C is select ROWID from AR_BPA_ITEMS_B

32: X_URLCFG_ENABLED_FLAG in VARCHAR2,
33: X_FLEXFIELD_ITEM_FLAG in VARCHAR2,
34: X_COLUMN_NAME in VARCHAR2
35: ) is
36: cursor C is select ROWID from AR_BPA_ITEMS_B
37: where ITEM_ID = X_ITEM_ID
38: ;
39: begin
40: insert into AR_BPA_ITEMS_B (

Line 40: insert into AR_BPA_ITEMS_B (

36: cursor C is select ROWID from AR_BPA_ITEMS_B
37: where ITEM_ID = X_ITEM_ID
38: ;
39: begin
40: insert into AR_BPA_ITEMS_B (
41: ITEM_ID,
42: ITEM_CODE,
43: ITEM_SOURCE,
44: ITEM_TYPE,

Line 188: from AR_BPA_ITEMS_B

184: DATA_TYPE,
185: URLCFG_ENABLED_FLAG,
186: FLEXFIELD_ITEM_FLAG,
187: COLUMN_NAME
188: from AR_BPA_ITEMS_B
189: where ITEM_ID = X_ITEM_ID
190: for update of ITEM_ID nowait;
191: recinfo c%rowtype;
192:

Line 307: update AR_BPA_ITEMS_B set

303: X_FLEXFIELD_ITEM_FLAG in VARCHAR2,
304: X_COLUMN_NAME in VARCHAR2
305: ) is
306: begin
307: update AR_BPA_ITEMS_B set
308: ITEM_CODE = X_ITEM_CODE,
309: ITEM_SOURCE = X_ITEM_SOURCE,
310: ITEM_TYPE = X_ITEM_TYPE,
311: DISPLAY_LEVEL = X_DISPLAY_LEVEL,

Line 365: delete from AR_BPA_ITEMS_B

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

Line 379: from AR_BPA_ITEMS_B B

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