APPS.AR_BPA_URLS_PKG dependencies on AR_BPA_URLS_B

Line 20: cursor C is select ROWID from AR_BPA_URLS_B

16: X_DISPLAY_AREA in VARCHAR2,
17: X_APPLICATION_ID in NUMBER,
18: X_DATA_SOURCE_ID in NUMBER
19: ) is
20: cursor C is select ROWID from AR_BPA_URLS_B
21: where URL_ID = X_URL_ID
22: ;
23: begin
24: insert into AR_BPA_URLS_B (

Line 24: insert into AR_BPA_URLS_B (

20: cursor C is select ROWID from AR_BPA_URLS_B
21: where URL_ID = X_URL_ID
22: ;
23: begin
24: insert into AR_BPA_URLS_B (
25: URL_ID,
26: URL_ADDRESS,
27: FULL_URL_ADDRESS,
28: SEEDED_FLAG,

Line 110: from AR_BPA_URLS_B

106: SEEDED_FLAG,
107: DISPLAY_AREA,
108: APPLICATION_ID,
109: DATA_SOURCE_ID
110: from AR_BPA_URLS_B
111: where URL_ID = X_URL_ID
112: for update of URL_ID nowait;
113: recinfo c%rowtype;
114:

Line 180: update AR_BPA_URLS_B set

176: X_APPLICATION_ID in NUMBER,
177: X_DATA_SOURCE_ID in NUMBER
178: ) is
179: begin
180: update AR_BPA_URLS_B set
181: URL_ADDRESS = X_URL_ADDRESS,
182: FULL_URL_ADDRESS = X_FULL_URL_ADDRESS,
183: SEEDED_FLAG = X_SEEDED_FLAG,
184: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 222: delete from AR_BPA_URLS_B

218: if (sql%notfound) then
219: raise no_data_found;
220: end if;
221:
222: delete from AR_BPA_URLS_B
223: where URL_ID = X_URL_ID;
224:
225: if (sql%notfound) then
226: raise no_data_found;

Line 236: from AR_BPA_URLS_B B

232: begin
233: delete from AR_BPA_URLS_TL T
234: where not exists
235: (select NULL
236: from AR_BPA_URLS_B B
237: where B.URL_ID = T.URL_ID
238: );
239:
240: update AR_BPA_URLS_TL T set (