APPS.AR_BPA_DATASRC_APPS_PKG dependencies on AR_BPA_DATASRC_APPS_B

Line 18: cursor C is select ROWID from AR_BPA_DATASRC_APPS_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from AR_BPA_DATASRC_APPS_B
19: where APPLICATION_ID = X_APPLICATION_ID
20: ;
21: begin
22: insert into AR_BPA_DATASRC_APPS_B (

Line 22: insert into AR_BPA_DATASRC_APPS_B (

18: cursor C is select ROWID from AR_BPA_DATASRC_APPS_B
19: where APPLICATION_ID = X_APPLICATION_ID
20: ;
21: begin
22: insert into AR_BPA_DATASRC_APPS_B (
23: APPLICATION_ID,
24: INTERFACE_CONTEXT,
25: ENABLED_FLAG,
26: SEEDED_FLAG,

Line 100: from AR_BPA_DATASRC_APPS_B

96: INTERFACE_CONTEXT,
97: ENABLED_FLAG,
98: SEEDED_FLAG,
99: PRIMARY_FLAG
100: from AR_BPA_DATASRC_APPS_B
101: where APPLICATION_ID = X_APPLICATION_ID
102: for update of APPLICATION_ID nowait;
103: recinfo c%rowtype;
104:

Line 166: update AR_BPA_DATASRC_APPS_B set

162: X_LAST_UPDATED_BY in NUMBER,
163: X_LAST_UPDATE_LOGIN in NUMBER
164: ) is
165: begin
166: update AR_BPA_DATASRC_APPS_B set
167: INTERFACE_CONTEXT = X_INTERFACE_CONTEXT,
168: ENABLED_FLAG = X_ENABLED_FLAG,
169: SEEDED_FLAG = X_SEEDED_FLAG,
170: PRIMARY_FLAG = X_PRIMARY_FLAG,

Line 214: delete from AR_BPA_DATASRC_APPS_B

210: if (sql%notfound) then
211: raise no_data_found;
212: end if;
213:
214: delete from AR_BPA_DATASRC_APPS_B
215: where APPLICATION_ID = X_APPLICATION_ID;
216:
217: if (sql%notfound) then
218: raise no_data_found;

Line 228: from AR_BPA_DATASRC_APPS_B B

224: begin
225: delete from AR_BPA_DATASRC_APPS_TL T
226: where not exists
227: (select NULL
228: from AR_BPA_DATASRC_APPS_B B
229: where B.APPLICATION_ID = T.APPLICATION_ID
230: );
231:
232: update AR_BPA_DATASRC_APPS_TL T set (