APPS.BIS_LEVELS_CUSTOMIZATIONS_PKG dependencies on BIS_LEVELS_CUSTOMIZATIONS_TL

Line 65: insert into BIS_LEVELS_CUSTOMIZATIONS_TL (

61: X_LAST_UPDATED_BY,
62: X_LAST_UPDATE_LOGIN
63: );
64:
65: insert into BIS_LEVELS_CUSTOMIZATIONS_TL (
66: CREATED_BY,
67: CREATION_DATE,
68: LAST_UPDATED_BY,
69: LAST_UPDATE_DATE,

Line 91: from BIS_LEVELS_CUSTOMIZATIONS_TL T

87: from FND_LANGUAGES L
88: where L.INSTALLED_FLAG in ('I', 'B')
89: and not exists
90: (select NULL
91: from BIS_LEVELS_CUSTOMIZATIONS_TL T
92: where T.ID = X_ID
93: and T.LANGUAGE = L.LANGUAGE_CODE);
94:
95: open c;

Line 138: from BIS_LEVELS_CUSTOMIZATIONS_TL

134: cursor c1 is select
135: NAME,
136: DESCRIPTION,
137: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
138: from BIS_LEVELS_CUSTOMIZATIONS_TL
139: where ID = X_ID
140: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
141: for update of ID nowait;
142: begin

Line 233: update BIS_LEVELS_CUSTOMIZATIONS_TL set

229: if (sql%notfound) then
230: raise no_data_found;
231: end if;
232:
233: update BIS_LEVELS_CUSTOMIZATIONS_TL set
234: NAME = X_NAME,
235: DESCRIPTION = X_DESCRIPTION,
236: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
237: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 252: delete from BIS_LEVELS_CUSTOMIZATIONS_TL

248: procedure DELETE_ROW (
249: X_ID in NUMBER
250: ) is
251: begin
252: delete from BIS_LEVELS_CUSTOMIZATIONS_TL
253: where ID = X_ID;
254:
255: if (sql%notfound) then
256: raise no_data_found;

Line 270: delete from BIS_LEVELS_CUSTOMIZATIONS_TL T

266:
267: procedure ADD_LANGUAGE
268: is
269: begin
270: delete from BIS_LEVELS_CUSTOMIZATIONS_TL T
271: where not exists
272: (select NULL
273: from BIS_LEVELS_CUSTOMIZATIONS B
274: where B.ID = T.ID

Line 277: update BIS_LEVELS_CUSTOMIZATIONS_TL T set (

273: from BIS_LEVELS_CUSTOMIZATIONS B
274: where B.ID = T.ID
275: );
276:
277: update BIS_LEVELS_CUSTOMIZATIONS_TL T set (
278: NAME,
279: DESCRIPTION
280: ) = (select
281: B.NAME,

Line 283: from BIS_LEVELS_CUSTOMIZATIONS_TL B

279: DESCRIPTION
280: ) = (select
281: B.NAME,
282: B.DESCRIPTION
283: from BIS_LEVELS_CUSTOMIZATIONS_TL B
284: where B.ID = T.ID
285: and B.LANGUAGE = T.SOURCE_LANG)
286: where (
287: T.ID,

Line 292: from BIS_LEVELS_CUSTOMIZATIONS_TL SUBB, BIS_LEVELS_CUSTOMIZATIONS_TL SUBT

288: T.LANGUAGE
289: ) in (select
290: SUBT.ID,
291: SUBT.LANGUAGE
292: from BIS_LEVELS_CUSTOMIZATIONS_TL SUBB, BIS_LEVELS_CUSTOMIZATIONS_TL SUBT
293: where SUBB.ID = SUBT.ID
294: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
295: and (SUBB.NAME <> SUBT.NAME
296: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 303: insert into BIS_LEVELS_CUSTOMIZATIONS_TL (

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

Line 325: from BIS_LEVELS_CUSTOMIZATIONS_TL B, FND_LANGUAGES L

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

Line 330: from BIS_LEVELS_CUSTOMIZATIONS_TL T

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