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_PVT dependencies on BIS_BUCKET_CUSTOMIZATIONS_TL

Line 299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE

295: , p_range9_low IN BIS_BUCKET_CUSTOMIZATIONS.range9_low%TYPE
296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE

Line 300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE

296: , p_range9_high IN BIS_BUCKET_CUSTOMIZATIONS.range9_high%TYPE
297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE

Line 301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE

297: , p_range10_low IN BIS_BUCKET_CUSTOMIZATIONS.range10_low%TYPE
298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE

Line 302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE

298: , p_range10_high IN BIS_BUCKET_CUSTOMIZATIONS.range10_high%TYPE
299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE

Line 303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE

299: , p_range1_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range1_name%TYPE
300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE

Line 304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE

300: , p_range2_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range2_name%TYPE
301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE

Line 305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE

301: , p_range3_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range3_name%TYPE
302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
309: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE

Line 306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE

302: , p_range4_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range4_name%TYPE
303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
309: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
310: , p_deleted_ranges IN VARCHAR2

Line 307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE

303: , p_range5_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range5_name%TYPE
304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
309: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
310: , p_deleted_ranges IN VARCHAR2
311: , p_new_ranges IN VARCHAR2

Line 308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE

304: , p_range6_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range6_name%TYPE
305: , p_range7_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range7_name%TYPE
306: , p_range8_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range8_name%TYPE
307: , p_range9_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range9_name%TYPE
308: , p_range10_name IN BIS_BUCKET_CUSTOMIZATIONS_TL.range10_name%TYPE
309: , p_customized IN BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
310: , p_deleted_ranges IN VARCHAR2
311: , p_new_ranges IN VARCHAR2
312: , x_return_status OUT NOCOPY VARCHAR2

Line 359: UPDATE bis_bucket_customizations_tl SET

355: last_updated_by = FND_GLOBAL.USER_ID,
356: last_update_login = FND_GLOBAL.LOGIN_ID
357: WHERE id = p_id;
358:
359: UPDATE bis_bucket_customizations_tl SET
360: range1_name = p_range1_name,
361: range2_name = p_range2_name,
362: range3_name = p_range3_name,
363: range4_name = p_range4_name,

Line 448: FROM bis_bucket_customizations_tl

444:
445: CURSOR c_bucket(p_lang_code VARCHAR2) IS
446: SELECT range1_name, range2_name, range3_name, range4_name,
447: range5_name, range6_name, range7_name, range8_name, range9_name, range10_name
448: FROM bis_bucket_customizations_tl
449: WHERE id = p_id
450: AND language = source_lang
451: AND source_lang = p_lang_code;
452: l_bucket_rec c_bucket%ROWTYPE;

Line 565: UPDATE bis_bucket_customizations_tl

561: OPEN c_bucket(userenv('LANG'));
562: FETCH c_bucket INTO l_bucket_rec;
563:
564: IF (c_bucket%FOUND) THEN
565: UPDATE bis_bucket_customizations_tl
566: SET range1_name = NVL(l_range_labels(1), l_bucket_rec.range1_name),
567: range2_name = NVL(l_range_labels(2), l_bucket_rec.range2_name),
568: range3_name = NVL(l_range_labels(3), l_bucket_rec.range3_name),
569: range4_name = NVL(l_range_labels(4), l_bucket_rec.range4_name),

Line 689: UPDATE bis_bucket_customizations_tl SET

685: OPEN c_base_bucket_tl(l_lang_rec.language_code);
686: FETCH c_base_bucket_tl INTO l_base_bucket_tl_rec;
687: IF(c_base_bucket_tl%FOUND) THEN
688:
689: UPDATE bis_bucket_customizations_tl SET
690: range1_name = l_base_bucket_tl_rec.range1_name,
691: range2_name = l_base_bucket_tl_rec.range2_name,
692: range3_name = l_base_bucket_tl_rec.range3_name,
693: range4_name = l_base_bucket_tl_rec.range4_name,

Line 1133: INSERT INTO bis_bucket_customizations_tl

1129: SYSDATE,
1130: l_login_id,
1131: 'F');
1132:
1133: INSERT INTO bis_bucket_customizations_tl
1134: (ID,
1135: RANGE1_NAME,
1136: RANGE2_NAME,
1137: RANGE3_NAME,

Line 1177: from BIS_BUCKET_CUSTOMIZATIONS_TL T

1173: from FND_LANGUAGES L
1174: where L.INSTALLED_FLAG in ('I', 'B')
1175: and not exists
1176: (select NULL
1177: from BIS_BUCKET_CUSTOMIZATIONS_TL T
1178: where T.ID = l_id
1179: and T.LANGUAGE = L.LANGUAGE_CODE);
1180:
1181: COMMIT;

Line 1396: update BIS_BUCKET_CUSTOMIZATIONS_TL set

1392: ,LAST_UPDATED_BY = l_user_id
1393: ,LAST_UPDATE_LOGIN = l_login_id
1394: where BUCKET_ID = l_bucket_Id;
1395:
1396: update BIS_BUCKET_CUSTOMIZATIONS_TL set
1397: RANGE1_NAME = l_bis_bucket_rec.range1_name
1398: ,RANGE2_NAME = l_bis_bucket_rec.range2_name
1399: ,RANGE3_NAME = l_bis_bucket_rec.range3_name
1400: ,RANGE4_NAME = l_bis_bucket_rec.range4_name

Line 1456: --BIS_BUCKET_CUSTOMIZATIONS_TL tables.

1452:
1453: --This API should delete a row from the tables BIS_BUCKET and BIS_BUCKET_TL
1454: --using the short name or the bucket id as the where clause value
1455: --It should also delete the rows from BIS_BUCKET_CUSTOMIZATIONS and
1456: --BIS_BUCKET_CUSTOMIZATIONS_TL tables.
1457: PROCEDURE DELETE_BIS_BUCKET (
1458: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
1459: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
1460: ,x_return_status OUT NOCOPY VARCHAR2

Line 1481: DELETE from BIS_BUCKET_CUSTOMIZATIONS_TL

1477: IF (l_ret_name = FND_API.G_FALSE) THEN
1478: SELECT bucket_id INTO l_bucket_id FROM BIS_BUCKET
1479: WHERE SHORT_NAME = p_short_name;
1480:
1481: DELETE from BIS_BUCKET_CUSTOMIZATIONS_TL
1482: WHERE id in (
1483: SELECT id
1484: FROM BIS_BUCKET_CUSTOMIZATIONS
1485: WHERE bucket_id = l_bucket_id);

Line 1512: DELETE from BIS_BUCKET_CUSTOMIZATIONS_TL

1508: ,x_error_table => x_error_tbl
1509: );
1510: RAISE FND_API.G_EXC_ERROR;
1511: ELSE
1512: DELETE from BIS_BUCKET_CUSTOMIZATIONS_TL
1513: WHERE id in (
1514: SELECT id
1515: FROM BIS_BUCKET_CUSTOMIZATIONS
1516: WHERE bucket_id = p_bucket_id);

Line 1800: UPDATE BIS_BUCKET_CUSTOMIZATIONS_TL

1796: ,SOURCE_LANG = userenv('LANG')
1797: WHERE BUCKET_ID = l_bis_bucket_rec.bucket_id
1798: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1799:
1800: UPDATE BIS_BUCKET_CUSTOMIZATIONS_TL
1801: SET
1802: RANGE1_NAME = l_bis_bucket_rec.range1_name
1803: ,RANGE2_NAME = l_bis_bucket_rec.range2_name
1804: ,RANGE3_NAME = l_bis_bucket_rec.range3_name