APPS.AR_BPA_PAGE_SETUPS_PKG dependencies on AR_BPA_PAGE_SETUPS_TL

Line 68: insert into AR_BPA_PAGE_SETUPS_TL (

64: X_LAST_UPDATED_BY,
65: X_LAST_UPDATE_LOGIN
66: );
67:
68: insert into AR_BPA_PAGE_SETUPS_TL (
69: LAST_UPDATED_BY,
70: LAST_UPDATE_DATE,
71: CREATION_DATE,
72: CREATED_BY,

Line 94: from AR_BPA_PAGE_SETUPS_TL T

90: from FND_LANGUAGES L
91: where L.INSTALLED_FLAG in ('I', 'B')
92: and not exists
93: (select NULL
94: from AR_BPA_PAGE_SETUPS_TL T
95: where T.PAGE_SETUP_ID = X_PAGE_SETUP_ID
96: and T.LANGUAGE = L.LANGUAGE_CODE);
97:
98: open c;

Line 145: from AR_BPA_PAGE_SETUPS_TL

141: cursor c1 is select
142: PAGE_SETUP_NAME,
143: PAGE_SETUP_DESC,
144: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
145: from AR_BPA_PAGE_SETUPS_TL
146: where PAGE_SETUP_ID = X_PAGE_SETUP_ID
147: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
148: for update of PAGE_SETUP_ID nowait;
149: begin

Line 234: update AR_BPA_PAGE_SETUPS_TL set

230: if (sql%notfound) then
231: raise no_data_found;
232: end if;
233:
234: update AR_BPA_PAGE_SETUPS_TL set
235: PAGE_SETUP_NAME = X_PAGE_SETUP_NAME,
236: PAGE_SETUP_DESC = X_PAGE_SETUP_DESC,
237: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
238: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 253: delete from AR_BPA_PAGE_SETUPS_TL

249: procedure DELETE_ROW (
250: X_PAGE_SETUP_ID in NUMBER
251: ) is
252: begin
253: delete from AR_BPA_PAGE_SETUPS_TL
254: where PAGE_SETUP_ID = X_PAGE_SETUP_ID;
255:
256: if (sql%notfound) then
257: raise no_data_found;

Line 271: delete from AR_BPA_PAGE_SETUPS_TL T

267:
268: procedure ADD_LANGUAGE
269: is
270: begin
271: delete from AR_BPA_PAGE_SETUPS_TL T
272: where not exists
273: (select NULL
274: from AR_BPA_PAGE_SETUPS_B B
275: where B.PAGE_SETUP_ID = T.PAGE_SETUP_ID

Line 278: update AR_BPA_PAGE_SETUPS_TL T set (

274: from AR_BPA_PAGE_SETUPS_B B
275: where B.PAGE_SETUP_ID = T.PAGE_SETUP_ID
276: );
277:
278: update AR_BPA_PAGE_SETUPS_TL T set (
279: PAGE_SETUP_NAME,
280: PAGE_SETUP_DESC
281: ) = (select
282: B.PAGE_SETUP_NAME,

Line 284: from AR_BPA_PAGE_SETUPS_TL B

280: PAGE_SETUP_DESC
281: ) = (select
282: B.PAGE_SETUP_NAME,
283: B.PAGE_SETUP_DESC
284: from AR_BPA_PAGE_SETUPS_TL B
285: where B.PAGE_SETUP_ID = T.PAGE_SETUP_ID
286: and B.LANGUAGE = T.SOURCE_LANG)
287: where (
288: T.PAGE_SETUP_ID,

Line 293: from AR_BPA_PAGE_SETUPS_TL SUBB, AR_BPA_PAGE_SETUPS_TL SUBT

289: T.LANGUAGE
290: ) in (select
291: SUBT.PAGE_SETUP_ID,
292: SUBT.LANGUAGE
293: from AR_BPA_PAGE_SETUPS_TL SUBB, AR_BPA_PAGE_SETUPS_TL SUBT
294: where SUBB.PAGE_SETUP_ID = SUBT.PAGE_SETUP_ID
295: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
296: and (SUBB.PAGE_SETUP_NAME <> SUBT.PAGE_SETUP_NAME
297: or SUBB.PAGE_SETUP_DESC <> SUBT.PAGE_SETUP_DESC

Line 302: insert into AR_BPA_PAGE_SETUPS_TL (

298: or (SUBB.PAGE_SETUP_DESC is null and SUBT.PAGE_SETUP_DESC is not null)
299: or (SUBB.PAGE_SETUP_DESC is not null and SUBT.PAGE_SETUP_DESC is null)
300: ));
301:
302: insert into AR_BPA_PAGE_SETUPS_TL (
303: LAST_UPDATED_BY,
304: LAST_UPDATE_DATE,
305: CREATION_DATE,
306: CREATED_BY,

Line 324: from AR_BPA_PAGE_SETUPS_TL B, FND_LANGUAGES L

320: B.PAGE_SETUP_NAME,
321: B.PAGE_SETUP_DESC,
322: L.LANGUAGE_CODE,
323: B.SOURCE_LANG
324: from AR_BPA_PAGE_SETUPS_TL B, FND_LANGUAGES L
325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL

Line 329: from AR_BPA_PAGE_SETUPS_TL T

325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL
329: from AR_BPA_PAGE_SETUPS_TL T
330: where T.PAGE_SETUP_ID = B.PAGE_SETUP_ID
331: and T.LANGUAGE = L.LANGUAGE_CODE);
332: end ADD_LANGUAGE;
333:

Line 410: update AR_BPA_PAGE_SETUPS_TL

406: X_PAGE_SETUP_DESC in VARCHAR2,
407: X_OWNER in VARCHAR2) IS
408: begin
409:
410: update AR_BPA_PAGE_SETUPS_TL
411: set PAGE_SETUP_NAME = X_PAGE_SETUP_NAME ,
412: PAGE_SETUP_DESC = X_PAGE_SETUP_DESC ,
413: source_lang = userenv('LANG'),
414: last_update_date = sysdate,