APPS.AR_BPA_DATASRC_VIEWS_PKG dependencies on AR_BPA_DATA_SOURCES_B

Line 27: cursor C is select ROWID from AR_BPA_DATA_SOURCES_B

23: X_LAST_UPDATE_DATE in DATE,
24: X_LAST_UPDATED_BY in NUMBER,
25: X_LAST_UPDATE_LOGIN in NUMBER
26: ) is
27: cursor C is select ROWID from AR_BPA_DATA_SOURCES_B
28: where DATA_SOURCE_ID = X_DATA_SOURCE_ID
29: ;
30: begin
31: insert into AR_BPA_DATA_SOURCES_B (

Line 31: insert into AR_BPA_DATA_SOURCES_B (

27: cursor C is select ROWID from AR_BPA_DATA_SOURCES_B
28: where DATA_SOURCE_ID = X_DATA_SOURCE_ID
29: ;
30: begin
31: insert into AR_BPA_DATA_SOURCES_B (
32: OBJECT_TYPE,
33: OBJECT_NAME,
34: VO_USAGE_NAME,
35: VO_USAGE_FULL_NAME,

Line 145: from AR_BPA_DATA_SOURCES_B

141: SOURCE_LINE_TYPE,
142: ENABLED_FLAG,
143: SEEDED_FLAG,
144: APPLICATION_ID
145: from AR_BPA_DATA_SOURCES_B
146: where DATA_SOURCE_ID = X_DATA_SOURCE_ID
147: for update of DATA_SOURCE_ID nowait;
148: recinfo c%rowtype;
149:

Line 235: update AR_BPA_DATA_SOURCES_B set

231: X_LAST_UPDATED_BY in NUMBER,
232: X_LAST_UPDATE_LOGIN in NUMBER
233: ) is
234: begin
235: update AR_BPA_DATA_SOURCES_B set
236: OBJECT_TYPE = X_OBJECT_TYPE,
237: OBJECT_NAME = X_OBJECT_NAME,
238: VO_USAGE_NAME = X_VO_USAGE_NAME,
239: VO_USAGE_FULL_NAME = X_VO_USAGE_FULL_NAME,

Line 292: delete from AR_BPA_DATA_SOURCES_B

288: if (sql%notfound) then
289: raise no_data_found;
290: end if;
291:
292: delete from AR_BPA_DATA_SOURCES_B
293: where DATA_SOURCE_ID = X_DATA_SOURCE_ID;
294:
295: if (sql%notfound) then
296: raise no_data_found;

Line 306: from AR_BPA_DATA_SOURCES_B B

302: begin
303: delete from AR_BPA_DATA_SOURCES_TL T
304: where not exists
305: (select NULL
306: from AR_BPA_DATA_SOURCES_B B
307: where B.DATA_SOURCE_ID = T.DATA_SOURCE_ID
308: );
309:
310: update AR_BPA_DATA_SOURCES_TL T set (