APPS.AR_BPA_AREA_ITEMS_PKG dependencies on AR_BPA_AREA_ITEMS

Line 1: package body AR_BPA_AREA_ITEMS_PKG as

1: package body AR_BPA_AREA_ITEMS_PKG as
2: /* $Header: ARBPAIB.pls 120.1 2004/12/03 01:44:55 orashid noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_AREA_ITEM_ID in NUMBER,

Line 20: cursor C is select ROWID from AR_BPA_AREA_ITEMS

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from AR_BPA_AREA_ITEMS
21: where AREA_ITEM_ID = X_AREA_ITEM_ID
22: ;
23: begin
24: insert into AR_BPA_AREA_ITEMS (

Line 24: insert into AR_BPA_AREA_ITEMS (

20: cursor C is select ROWID from AR_BPA_AREA_ITEMS
21: where AREA_ITEM_ID = X_AREA_ITEM_ID
22: ;
23: begin
24: insert into AR_BPA_AREA_ITEMS (
25: LAST_UPDATE_LOGIN,
26: CREATION_DATE,
27: SECONDARY_APP_ID,
28: ITEM_ID,

Line 86: from AR_BPA_AREA_ITEMS

82: DISPLAY_LEVEL,
83: PARENT_AREA_CODE,
84: DATA_SOURCE_ID,
85: FLEXFIELD_ITEM_FLAG
86: from AR_BPA_AREA_ITEMS
87: where AREA_ITEM_ID = X_AREA_ITEM_ID
88: for update of AREA_ITEM_ID nowait;
89: begin
90: for tlinfo in c1 loop

Line 124: update AR_BPA_AREA_ITEMS set

120: X_LAST_UPDATED_BY in NUMBER,
121: X_LAST_UPDATE_LOGIN in NUMBER
122: ) is
123: begin
124: update AR_BPA_AREA_ITEMS set
125: SECONDARY_APP_ID = X_SECONDARY_APP_ID,
126: ITEM_ID = X_ITEM_ID,
127: DISPLAY_SEQUENCE = X_DISPLAY_SEQUENCE,
128: TEMPLATE_ID = X_TEMPLATE_ID,

Line 147: delete from AR_BPA_AREA_ITEMS

143: procedure DELETE_ROW (
144: X_AREA_ITEM_ID in NUMBER
145: ) is
146: begin
147: delete from AR_BPA_AREA_ITEMS
148: where AREA_ITEM_ID = X_AREA_ITEM_ID;
149:
150: if (sql%notfound) then
151: raise no_data_found;

Line 177: AR_BPA_AREA_ITEMS_PKG.UPDATE_ROW (

173: if (X_OWNER = 'SEED') then
174: user_id := 1;
175: end if;
176:
177: AR_BPA_AREA_ITEMS_PKG.UPDATE_ROW (
178: X_AREA_ITEM_ID => X_AREA_ITEM_ID,
179: X_SECONDARY_APP_ID => X_SECONDARY_APP_ID,
180: X_ITEM_ID => X_ITEM_ID,
181: X_DISPLAY_SEQUENCE => X_DISPLAY_SEQUENCE,

Line 192: AR_BPA_AREA_ITEMS_PKG.INSERT_ROW (

188: X_LAST_UPDATED_BY => user_id,
189: X_LAST_UPDATE_LOGIN => 0);
190: exception
191: when NO_DATA_FOUND then
192: AR_BPA_AREA_ITEMS_PKG.INSERT_ROW (
193: X_ROWID => row_id,
194: X_AREA_ITEM_ID => X_AREA_ITEM_ID,
195: X_SECONDARY_APP_ID => X_SECONDARY_APP_ID,
196: X_ITEM_ID => X_ITEM_ID,

Line 211: end AR_BPA_AREA_ITEMS_PKG;

207: X_LAST_UPDATE_LOGIN => 0);
208: end;
209: end LOAD_ROW;
210:
211: end AR_BPA_AREA_ITEMS_PKG;