eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_LEVELS_CUSTOMIZATIONS_PKG dependencies on BIS_LEVELS_CUSTOMIZATIONS

Line 1: package body BIS_LEVELS_CUSTOMIZATIONS_PKG as

1: package body BIS_LEVELS_CUSTOMIZATIONS_PKG as
2: /* $Header: BISPCDLB.pls 115.1 2003/12/09 14:52:00 ankgoel noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_ID in NUMBER,

Line 23: cursor C is select ROWID from BIS_LEVELS_CUSTOMIZATIONS

19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from BIS_LEVELS_CUSTOMIZATIONS
24: where ID = X_ID
25: ;
26: begin
27: IF ( X_ENABLED = FND_API.G_FALSE ) THEN

Line 31: insert into BIS_LEVELS_CUSTOMIZATIONS (

27: IF ( X_ENABLED = FND_API.G_FALSE ) THEN
28: BIS_DIMENSION_LEVEL_PUB.validate_disabling(p_dim_level_id => X_LEVEL_ID );
29: END IF;
30:
31: insert into BIS_LEVELS_CUSTOMIZATIONS (
32: ID,
33: LEVEL_ID,
34: ENABLED,
35: USER_ID,

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 129: from BIS_LEVELS_CUSTOMIZATIONS

125: ORG_ID,
126: SITE_ID,
127: PAGE_ID,
128: FUNCTION_ID
129: from BIS_LEVELS_CUSTOMIZATIONS
130: where ID = X_ID
131: for update of ID nowait;
132: recinfo c%rowtype;
133:

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 214: update BIS_LEVELS_CUSTOMIZATIONS set

210: IF ( X_ENABLED = FND_API.G_FALSE ) THEN
211: BIS_DIMENSION_LEVEL_PUB.validate_disabling(p_dim_level_id => X_LEVEL_ID );
212: END IF;
213:
214: update BIS_LEVELS_CUSTOMIZATIONS set
215: LEVEL_ID = X_LEVEL_ID,
216: ENABLED = X_ENABLED,
217: USER_ID = X_USER_ID,
218: RESPONSIBILITY_ID = X_RESPONSIBILITY_ID,

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 259: delete from BIS_LEVELS_CUSTOMIZATIONS

255: if (sql%notfound) then
256: raise no_data_found;
257: end if;
258:
259: delete from BIS_LEVELS_CUSTOMIZATIONS
260: where ID = X_ID;
261:
262: if (sql%notfound) then
263: 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 273: from BIS_LEVELS_CUSTOMIZATIONS B

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
275: );
276:
277: update BIS_LEVELS_CUSTOMIZATIONS_TL T set (

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:

Line 335: end BIS_LEVELS_CUSTOMIZATIONS_PKG;

331: where T.ID = B.ID
332: and T.LANGUAGE = L.LANGUAGE_CODE);
333: end ADD_LANGUAGE;
334:
335: end BIS_LEVELS_CUSTOMIZATIONS_PKG;