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_BUCKET_CUSTOMIZATIONS_PKG dependencies on BIS_BUCKET_CUSTOMIZATIONS

Line 1: package body BIS_BUCKET_CUSTOMIZATIONS_PKG as

1: package body BIS_BUCKET_CUSTOMIZATIONS_PKG as
2: /* $Header: BISPBUCB.pls 115.1 2004/02/15 21:55:32 ankgoel noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_ID in NUMBER,

Line 51: cursor C is select ROWID from BIS_BUCKET_CUSTOMIZATIONS

47: X_LAST_UPDATE_DATE in DATE,
48: X_LAST_UPDATED_BY in NUMBER,
49: X_LAST_UPDATE_LOGIN in NUMBER
50: ) is
51: cursor C is select ROWID from BIS_BUCKET_CUSTOMIZATIONS
52: where ID = X_ID
53: ;
54: begin
55: insert into BIS_BUCKET_CUSTOMIZATIONS (

Line 55: insert into BIS_BUCKET_CUSTOMIZATIONS (

51: cursor C is select ROWID from BIS_BUCKET_CUSTOMIZATIONS
52: where ID = X_ID
53: ;
54: begin
55: insert into BIS_BUCKET_CUSTOMIZATIONS (
56: RANGE8_HIGH,
57: RANGE9_LOW,
58: RANGE9_HIGH,
59: RANGE10_LOW,

Line 129: insert into BIS_BUCKET_CUSTOMIZATIONS_TL (

125: X_LAST_UPDATED_BY,
126: X_LAST_UPDATE_LOGIN
127: );
128:
129: insert into BIS_BUCKET_CUSTOMIZATIONS_TL (
130: CREATED_BY,
131: CREATION_DATE,
132: LAST_UPDATED_BY,
133: LAST_UPDATE_DATE,

Line 171: from BIS_BUCKET_CUSTOMIZATIONS_TL T

167: from FND_LANGUAGES L
168: where L.INSTALLED_FLAG in ('I', 'B')
169: and not exists
170: (select NULL
171: from BIS_BUCKET_CUSTOMIZATIONS_TL T
172: where T.ID = X_ID
173: and T.LANGUAGE = L.LANGUAGE_CODE);
174:
175: open c;

Line 257: from BIS_BUCKET_CUSTOMIZATIONS

253: RANGE5_LOW,
254: RANGE5_HIGH,
255: RANGE6_LOW,
256: RANGE6_HIGH
257: from BIS_BUCKET_CUSTOMIZATIONS
258: where ID = X_ID
259: for update of ID nowait;
260: recinfo c%rowtype;
261:

Line 274: from BIS_BUCKET_CUSTOMIZATIONS_TL

270: RANGE8_NAME,
271: RANGE9_NAME,
272: RANGE10_NAME,
273: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
274: from BIS_BUCKET_CUSTOMIZATIONS_TL
275: where ID = X_ID
276: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
277: for update of ID nowait;
278: begin

Line 430: update BIS_BUCKET_CUSTOMIZATIONS set

426: X_LAST_UPDATED_BY in NUMBER,
427: X_LAST_UPDATE_LOGIN in NUMBER
428: ) is
429: begin
430: update BIS_BUCKET_CUSTOMIZATIONS set
431: RANGE8_HIGH = X_RANGE8_HIGH,
432: RANGE9_LOW = X_RANGE9_LOW,
433: RANGE9_HIGH = X_RANGE9_HIGH,
434: RANGE10_LOW = X_RANGE10_LOW,

Line 469: update BIS_BUCKET_CUSTOMIZATIONS_TL set

465: if (sql%notfound) then
466: raise no_data_found;
467: end if;
468:
469: update BIS_BUCKET_CUSTOMIZATIONS_TL set
470: RANGE1_NAME = X_RANGE1_NAME,
471: RANGE2_NAME = X_RANGE2_NAME,
472: RANGE3_NAME = X_RANGE3_NAME,
473: RANGE4_NAME = X_RANGE4_NAME,

Line 496: delete from BIS_BUCKET_CUSTOMIZATIONS_TL

492: procedure DELETE_ROW (
493: X_ID in NUMBER
494: ) is
495: begin
496: delete from BIS_BUCKET_CUSTOMIZATIONS_TL
497: where ID = X_ID;
498:
499: if (sql%notfound) then
500: raise no_data_found;

Line 503: delete from BIS_BUCKET_CUSTOMIZATIONS

499: if (sql%notfound) then
500: raise no_data_found;
501: end if;
502:
503: delete from BIS_BUCKET_CUSTOMIZATIONS
504: where ID = X_ID;
505:
506: if (sql%notfound) then
507: raise no_data_found;

Line 514: delete from BIS_BUCKET_CUSTOMIZATIONS_TL T

510:
511: procedure ADD_LANGUAGE
512: is
513: begin
514: delete from BIS_BUCKET_CUSTOMIZATIONS_TL T
515: where not exists
516: (select NULL
517: from BIS_BUCKET_CUSTOMIZATIONS B
518: where B.ID = T.ID

Line 517: from BIS_BUCKET_CUSTOMIZATIONS B

513: begin
514: delete from BIS_BUCKET_CUSTOMIZATIONS_TL T
515: where not exists
516: (select NULL
517: from BIS_BUCKET_CUSTOMIZATIONS B
518: where B.ID = T.ID
519: );
520:
521: update BIS_BUCKET_CUSTOMIZATIONS_TL T set (

Line 521: update BIS_BUCKET_CUSTOMIZATIONS_TL T set (

517: from BIS_BUCKET_CUSTOMIZATIONS B
518: where B.ID = T.ID
519: );
520:
521: update BIS_BUCKET_CUSTOMIZATIONS_TL T set (
522: RANGE1_NAME,
523: RANGE2_NAME,
524: RANGE3_NAME,
525: RANGE4_NAME,

Line 543: from BIS_BUCKET_CUSTOMIZATIONS_TL B

539: B.RANGE7_NAME,
540: B.RANGE8_NAME,
541: B.RANGE9_NAME,
542: B.RANGE10_NAME
543: from BIS_BUCKET_CUSTOMIZATIONS_TL B
544: where B.ID = T.ID
545: and B.LANGUAGE = T.SOURCE_LANG)
546: where (
547: T.ID,

Line 552: from BIS_BUCKET_CUSTOMIZATIONS_TL SUBB, BIS_BUCKET_CUSTOMIZATIONS_TL SUBT

548: T.LANGUAGE
549: ) in (select
550: SUBT.ID,
551: SUBT.LANGUAGE
552: from BIS_BUCKET_CUSTOMIZATIONS_TL SUBB, BIS_BUCKET_CUSTOMIZATIONS_TL SUBT
553: where SUBB.ID = SUBT.ID
554: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
555: and (SUBB.RANGE1_NAME <> SUBT.RANGE1_NAME
556: or (SUBB.RANGE1_NAME is null and SUBT.RANGE1_NAME is not null)

Line 587: insert into BIS_BUCKET_CUSTOMIZATIONS_TL (

583: or (SUBB.RANGE10_NAME is null and SUBT.RANGE10_NAME is not null)
584: or (SUBB.RANGE10_NAME is not null and SUBT.RANGE10_NAME is null)
585: ));
586:
587: insert into BIS_BUCKET_CUSTOMIZATIONS_TL (
588: CREATED_BY,
589: CREATION_DATE,
590: LAST_UPDATED_BY,
591: LAST_UPDATE_DATE,

Line 625: from BIS_BUCKET_CUSTOMIZATIONS_TL B, FND_LANGUAGES L

621: B.RANGE5_NAME,
622: B.RANGE6_NAME,
623: L.LANGUAGE_CODE,
624: B.SOURCE_LANG
625: from BIS_BUCKET_CUSTOMIZATIONS_TL B, FND_LANGUAGES L
626: where L.INSTALLED_FLAG in ('I', 'B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL

Line 630: from BIS_BUCKET_CUSTOMIZATIONS_TL T

626: where L.INSTALLED_FLAG in ('I', 'B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL
630: from BIS_BUCKET_CUSTOMIZATIONS_TL T
631: where T.ID = B.ID
632: and T.LANGUAGE = L.LANGUAGE_CODE);
633: end ADD_LANGUAGE;
634:

Line 635: end BIS_BUCKET_CUSTOMIZATIONS_PKG;

631: where T.ID = B.ID
632: and T.LANGUAGE = L.LANGUAGE_CODE);
633: end ADD_LANGUAGE;
634:
635: end BIS_BUCKET_CUSTOMIZATIONS_PKG;