APPS.AR_BPA_URLS_PKG dependencies on AR_BPA_URLS_TL

Line 52: insert into AR_BPA_URLS_TL (

48: X_APPLICATION_ID,
49: X_DATA_SOURCE_ID
50: );
51:
52: insert into AR_BPA_URLS_TL (
53: URL_ID,
54: URL_NAME,
55: URL_DESCRIPTION,
56: CREATED_BY,

Line 78: from AR_BPA_URLS_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from AR_BPA_URLS_TL T
79: where T.URL_ID = X_URL_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from AR_BPA_URLS_TL

115: cursor c1 is select
116: URL_NAME,
117: URL_DESCRIPTION,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from AR_BPA_URLS_TL
120: where URL_ID = X_URL_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of URL_ID nowait;
123: begin

Line 196: update AR_BPA_URLS_TL set

192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195:
196: update AR_BPA_URLS_TL set
197: URL_NAME = X_URL_NAME,
198: URL_DESCRIPTION = X_URL_DESCRIPTION,
199: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
200: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 215: delete from AR_BPA_URLS_TL

211: procedure DELETE_ROW (
212: X_URL_ID in NUMBER
213: ) is
214: begin
215: delete from AR_BPA_URLS_TL
216: where URL_ID = X_URL_ID;
217:
218: if (sql%notfound) then
219: raise no_data_found;

Line 233: delete from AR_BPA_URLS_TL T

229:
230: procedure ADD_LANGUAGE
231: is
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

Line 240: update AR_BPA_URLS_TL T set (

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 (
241: URL_NAME,
242: URL_DESCRIPTION
243: ) = (select
244: B.URL_NAME,

Line 246: from AR_BPA_URLS_TL B

242: URL_DESCRIPTION
243: ) = (select
244: B.URL_NAME,
245: B.URL_DESCRIPTION
246: from AR_BPA_URLS_TL B
247: where B.URL_ID = T.URL_ID
248: and B.LANGUAGE = T.SOURCE_LANG)
249: where (
250: T.URL_ID,

Line 255: from AR_BPA_URLS_TL SUBB, AR_BPA_URLS_TL SUBT

251: T.LANGUAGE
252: ) in (select
253: SUBT.URL_ID,
254: SUBT.LANGUAGE
255: from AR_BPA_URLS_TL SUBB, AR_BPA_URLS_TL SUBT
256: where SUBB.URL_ID = SUBT.URL_ID
257: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
258: and (SUBB.URL_NAME <> SUBT.URL_NAME
259: or SUBB.URL_DESCRIPTION <> SUBT.URL_DESCRIPTION

Line 264: insert into AR_BPA_URLS_TL (

260: or (SUBB.URL_DESCRIPTION is null and SUBT.URL_DESCRIPTION is not null)
261: or (SUBB.URL_DESCRIPTION is not null and SUBT.URL_DESCRIPTION is null)
262: ));
263:
264: insert into AR_BPA_URLS_TL (
265: URL_ID,
266: URL_NAME,
267: URL_DESCRIPTION,
268: CREATED_BY,

Line 286: from AR_BPA_URLS_TL B, FND_LANGUAGES L

282: B.LAST_UPDATE_DATE,
283: B.LAST_UPDATE_LOGIN,
284: L.LANGUAGE_CODE,
285: B.SOURCE_LANG
286: from AR_BPA_URLS_TL B, FND_LANGUAGES L
287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL

Line 291: from AR_BPA_URLS_TL T

287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL
291: from AR_BPA_URLS_TL T
292: where T.URL_ID = B.URL_ID
293: and T.LANGUAGE = L.LANGUAGE_CODE);
294: end ADD_LANGUAGE;
295:

Line 303: update AR_BPA_URLS_TL

299: X_URL_DESCRIPTION in VARCHAR2,
300: X_OWNER in VARCHAR2) IS
301: begin
302:
303: update AR_BPA_URLS_TL
304: set URL_NAME = X_URL_NAME,
305: URL_DESCRIPTION = X_URL_DESCRIPTION,
306: source_lang = userenv('LANG'),
307: last_update_date = sysdate,