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_PVT

Line 1: PACKAGE BODY BIS_BUCKET_PVT AS

1: PACKAGE BODY BIS_BUCKET_PVT AS
2: /* $Header: BISVBKTB.pls 120.1 2006/07/26 07:58:21 ankgoel noship $ */
3:
4: --=============================================================================
5: FUNCTION CHECK_RANGE_NAME (

Line 24: --and call BIS_BUCKET_PVT. CREATE_BIS_BUCKET with it.

20: , p_new_ranges IN VARCHAR2);
21: --=============================================================================
22: --Called by Java API
23: --It should take all the data passed to it and builds a record of type BIS_BUCKET_REC_TYPE
24: --and call BIS_BUCKET_PVT. CREATE_BIS_BUCKET with it.
25: PROCEDURE CREATE_BIS_BUCKET_WRAPPER (
26: p_short_name IN BIS_BUCKET.short_name%TYPE
27: ,p_name IN BIS_BUCKET_TL.name%TYPE
28: ,p_type IN BIS_BUCKET.type%TYPE

Line 118: BIS_BUCKET_PVT.CREATE_BIS_BUCKET (

114: l_bis_bucket_rec.discontinuous := p_discontinuous;
115: l_bis_bucket_rec.overlapping := p_overlapping;
116: l_bis_bucket_rec.uom := p_uom;
117:
118: BIS_BUCKET_PVT.CREATE_BIS_BUCKET (
119: p_bis_bucket_rec => l_bis_bucket_rec
120: ,x_return_status => l_return_status
121: ,x_error_tbl => l_error_tbl
122: );

Line 148: --and call BIS_BUCKET_PVT.UPDATE_BIS_BUCKET with it.

144:
145:
146: --Called by Java API
147: --It should take all the data passed to it and builds a record of type BIS_BUCKET_REC_TYPE
148: --and call BIS_BUCKET_PVT.UPDATE_BIS_BUCKET with it.
149: PROCEDURE UPDATE_BIS_BUCKET_WRAPPER (
150: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE
151: ,p_short_name IN BIS_BUCKET.short_name%TYPE
152: ,p_name IN BIS_BUCKET_TL.name%TYPE

Line 244: BIS_BUCKET_PVT.UPDATE_BIS_BUCKET (

240: l_bis_bucket_rec.discontinuous := p_discontinuous;
241: l_bis_bucket_rec.overlapping := p_overlapping;
242: l_bis_bucket_rec.uom := p_uom;
243:
244: BIS_BUCKET_PVT.UPDATE_BIS_BUCKET (
245: p_bis_bucket_rec => l_bis_bucket_rec
246: ,x_return_status => l_return_status
247: ,x_error_tbl => l_error_tbl
248: );

Line 411: x_msg_data := x_msg_data||' -> BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';

407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: WHEN NO_DATA_FOUND THEN
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: IF (x_msg_data IS NOT NULL) THEN
411: x_msg_data := x_msg_data||' -> BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';
412: ELSE
413: x_msg_data := SQLERRM||' at BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';
414: END IF;
415: ROLLBACK TO SP_UPDATE_BUCKET_CUST;

Line 413: x_msg_data := SQLERRM||' at BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';

409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: IF (x_msg_data IS NOT NULL) THEN
411: x_msg_data := x_msg_data||' -> BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';
412: ELSE
413: x_msg_data := SQLERRM||' at BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';
414: END IF;
415: ROLLBACK TO SP_UPDATE_BUCKET_CUST;
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 419: x_msg_data := x_msg_data||' -> BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';

415: ROLLBACK TO SP_UPDATE_BUCKET_CUST;
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF (x_msg_data IS NOT NULL) THEN
419: x_msg_data := x_msg_data||' -> BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';
420: ELSE
421: x_msg_data := SQLERRM||' at BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';
422: END IF;
423: ROLLBACK TO SP_UPDATE_BUCKET_CUST;

Line 421: x_msg_data := SQLERRM||' at BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';

417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF (x_msg_data IS NOT NULL) THEN
419: x_msg_data := x_msg_data||' -> BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';
420: ELSE
421: x_msg_data := SQLERRM||' at BIS_BUCKET_PVT.UPDATE_CUST_BUCKET ';
422: END IF;
423: ROLLBACK TO SP_UPDATE_BUCKET_CUST;
424: END UPDATE_CUST_BUCKET;
425:

Line 454: l_range_labels BIS_BUCKET_PVT.RangeLabels;

450: AND language = source_lang
451: AND source_lang = p_lang_code;
452: l_bucket_rec c_bucket%ROWTYPE;
453:
454: l_range_labels BIS_BUCKET_PVT.RangeLabels;
455: c_delete_marker VARCHAR2(10) := '@#!$';
456:
457: BEGIN
458:

Line 726: --It should call BIS_BUCKET_PVT. RETRIEVE _BIS_BUCKET with the short name

722: END reset_bucket;
723:
724:
725: --Called by Java API
726: --It should call BIS_BUCKET_PVT. RETRIEVE _BIS_BUCKET with the short name
727: --and using the record of type BIS_BUCKET_REC_TYPE data obtained from that procedure,
728: --it should populates the out parameters
729: PROCEDURE RETRIEVE_BIS_BUCKET_WRAPPER (
730: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 782: BIS_BUCKET_PVT.RETRIEVE_BIS_BUCKET (

778: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
779:
780: BEGIN
781:
782: BIS_BUCKET_PVT.RETRIEVE_BIS_BUCKET (
783: p_short_name => p_short_name
784: ,x_bis_bucket_rec => l_bis_bucket_rec
785: ,x_return_status => l_return_status
786: ,x_error_tbl => l_error_tbl

Line 850: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET

846:
847: END RETRIEVE_BIS_BUCKET_WRAPPER;
848:
849:
850: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET
851: PROCEDURE DELETE_BIS_BUCKET_WRAPPER (
852: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
853: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
854: ,x_return_status OUT NOCOPY VARCHAR2

Line 863: BIS_BUCKET_PVT.DELETE_BIS_BUCKET(

859: l_return_status VARCHAR2(10);
860: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
861:
862: BEGIN
863: BIS_BUCKET_PVT.DELETE_BIS_BUCKET(
864: p_bucket_id => p_bucket_id
865: ,p_short_name => p_short_name
866: ,x_return_status => l_return_status
867: ,x_error_tbl => l_error_tbl

Line 916: BIS_BUCKET_PVT.Validate_Bucket (

912: l_user_id := fnd_global.user_id;
913: l_login_id := fnd_global.LOGIN_ID;
914: l_bis_bucket_rec := p_bis_bucket_rec;
915:
916: BIS_BUCKET_PVT.Validate_Bucket (
917: p_bis_bucket_rec => l_bis_bucket_rec
918: ,x_return_status => x_return_status
919: ,x_error_Tbl => x_error_tbl
920: );

Line 1264: BIS_BUCKET_PVT.Validate_Bucket (

1260: );
1261: RAISE FND_API.G_EXC_ERROR;
1262: END IF;
1263:
1264: BIS_BUCKET_PVT.Validate_Bucket (
1265: p_bis_bucket_rec => p_bis_bucket_rec
1266: ,x_return_status => x_return_status
1267: ,x_error_Tbl => x_error_tbl
1268: );

Line 1757: BIS_BUCKET_PVT.RETRIEVE_BIS_BUCKET (

1753: BEGIN
1754:
1755: l_bis_bucket_rec := p_bis_bucket_rec;
1756:
1757: BIS_BUCKET_PVT.RETRIEVE_BIS_BUCKET (
1758: p_short_name => l_bis_bucket_rec.short_name
1759: ,x_bis_bucket_rec => l_bis_bucket_rec_orig
1760: ,x_return_status => l_return_status
1761: ,x_error_tbl => l_error_tbl

Line 2390: l_bucket_ranges_tbl BIS_BUCKET_PVT.BIS_BUCKET_RANGES_TBL;

2386:
2387: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2388: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
2389:
2390: l_bucket_ranges_tbl BIS_BUCKET_PVT.BIS_BUCKET_RANGES_TBL;
2391:
2392: BEGIN
2393:
2394: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2412: BIS_BUCKET_PVT.Validate_Bucket_Common (

2408: );
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411:
2412: BIS_BUCKET_PVT.Validate_Bucket_Common (
2413: p_bis_bucket_rec => l_bis_bucket_rec
2414: ,x_return_status => x_return_status
2415: ,x_error_Tbl => x_error_tbl
2416: );

Line 2523: ,x_bucket_ranges_tbl OUT NOCOPY BIS_BUCKET_PVT.bis_bucket_ranges_tbl

2519: --=============================================================================
2520: PROCEDURE Populate_Loc_Bucket_Range_Tbl
2521: (
2522: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
2523: ,x_bucket_ranges_tbl OUT NOCOPY BIS_BUCKET_PVT.bis_bucket_ranges_tbl
2524: ,x_return_status OUT NOCOPY VARCHAR2
2525: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2526: )
2527: IS

Line 2635: ,p_bucket_ranges_tbl IN BIS_BUCKET_PVT.bis_bucket_ranges_tbl

2631: -- Validation is only needed if it doesn't allow overlapping.
2632: --=============================================================================
2633: PROCEDURE Validate_Bucket_Overlapping (
2634: p_overlapping IN VARCHAR2
2635: ,p_bucket_ranges_tbl IN BIS_BUCKET_PVT.bis_bucket_ranges_tbl
2636: ,x_return_status OUT NOCOPY VARCHAR2
2637: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2638: )
2639: IS

Line 2699: ,p_bucket_ranges_tbl IN BIS_BUCKET_PVT.bis_bucket_ranges_tbl

2695: -- Validation is only needed if it doesn't allow discontinuous.
2696: --=============================================================================
2697: PROCEDURE Validate_Bucket_Discontinuous (
2698: p_discontinuous IN VARCHAR2
2699: ,p_bucket_ranges_tbl IN BIS_BUCKET_PVT.bis_bucket_ranges_tbl
2700: ,x_return_status OUT NOCOPY VARCHAR2
2701: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2702: )
2703: IS

Line 2757: p_bucket_ranges_tbl IN BIS_BUCKET_PVT.bis_bucket_ranges_tbl

2753: --=============================================================================
2754: --API for validating that the FROM is always less than or equal to TO
2755: --=============================================================================
2756: PROCEDURE Validate_From_To (
2757: p_bucket_ranges_tbl IN BIS_BUCKET_PVT.bis_bucket_ranges_tbl
2758: ,x_return_status OUT NOCOPY VARCHAR2
2759: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2760: )
2761: IS

Line 2902: BIS_BUCKET_PVT.Validate_Bucket_Common (

2898: l_bis_bucket_rec.discontinuous := p_discontinuous;
2899: l_bis_bucket_rec.overlapping := p_overlapping;
2900: l_bis_bucket_rec.uom := p_uom;
2901:
2902: BIS_BUCKET_PVT.Validate_Bucket_Common (
2903: p_bis_bucket_rec => l_bis_bucket_rec
2904: ,x_return_status => l_return_status
2905: ,x_error_Tbl => l_error_tbl
2906: );

Line 2962: l_bucket_ranges_tbl BIS_BUCKET_PVT.BIS_BUCKET_RANGES_TBL;

2958:
2959: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2960: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
2961:
2962: l_bucket_ranges_tbl BIS_BUCKET_PVT.BIS_BUCKET_RANGES_TBL;
2963:
2964: BEGIN
2965:
2966: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3207: END BIS_BUCKET_PVT;

3203: AND T.LANGUAGE = L.LANGUAGE_CODE);
3204: END ADD_LANGUAGE;
3205:
3206:
3207: END BIS_BUCKET_PVT;