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_S

Line 26: p_short_name IN BIS_BUCKET.short_name%TYPE

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
29: ,p_application_id IN BIS_BUCKET.application_id%TYPE
30: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE

Line 151: ,p_short_name IN BIS_BUCKET.short_name%TYPE

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
153: ,p_type IN BIS_BUCKET.type%TYPE
154: ,p_application_id IN BIS_BUCKET.application_id%TYPE
155: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE

Line 730: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

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
731: ,x_bucket_id OUT NOCOPY BIS_BUCKET.bucket_id%TYPE
732: ,x_name OUT NOCOPY BIS_BUCKET_TL.name%TYPE
733: ,x_type OUT NOCOPY BIS_BUCKET.type%TYPE
734: ,x_application_id OUT NOCOPY BIS_BUCKET.application_id%TYPE

Line 853: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

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
855: ,x_error_msg OUT NOCOPY VARCHAR2
856: )
857: IS

Line 941: SELECT bis_bucket_s.nextval INTO l_bucket_id FROM dual;

937: );
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940:
941: SELECT bis_bucket_s.nextval INTO l_bucket_id FROM dual;
942:
943: INSERT into BIS_BUCKET (
944: BUCKET_ID,
945: SHORT_NAME,

Line 1311: UPDATE BIS_BUCKET SET

1307: l_bis_bucket_rec.overlapping := p_bis_bucket_rec.overlapping;
1308: l_bis_bucket_rec.uom := p_bis_bucket_rec.uom;
1309:
1310:
1311: UPDATE BIS_BUCKET SET
1312: TYPE = l_bis_bucket_rec.type
1313: ,APPLICATION_ID = l_bis_bucket_rec.application_id
1314: ,RANGE1_LOW = l_bis_bucket_rec.range1_low
1315: ,RANGE1_HIGH = l_bis_bucket_rec.range1_high

Line 1459: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

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
1461: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1462: )
1463: IS

Line 1582: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

1578: --This API should populate a record of type bis_bucket_rec_type based on the bucket short name
1579: -- Modified for bug #3394457 , ankgoel
1580: -- Retrieve the record always from the customization table
1581: PROCEDURE RETRIEVE_BIS_BUCKET (
1582: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
1583: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
1584: ,x_return_status OUT NOCOPY VARCHAR2
1585: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1586: )

Line 2671: p_error_msg_name => 'BIS_BUCKET_SET_OVERLAPPING'

2667: EXCEPTION
2668: WHEN FND_API.G_EXC_ERROR THEN -- overlapping occurs
2669: x_return_status := FND_API.G_RET_STS_ERROR;
2670: BIS_UTILITIES_PVT.Add_Error_Message (
2671: p_error_msg_name => 'BIS_BUCKET_SET_OVERLAPPING'
2672: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2673: ,p_error_proc_name => G_PKG_NAME||'.Validate_Bucket_Overlapping'
2674: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
2675: ,p_error_table => l_error_tbl

Line 2733: p_error_msg_name => 'BIS_BUCKET_SET_DISCONTINUOUS'

2729: EXCEPTION
2730: WHEN FND_API.G_EXC_ERROR THEN -- discontinuous occurs
2731: x_return_status := FND_API.G_RET_STS_ERROR;
2732: BIS_UTILITIES_PVT.Add_Error_Message (
2733: p_error_msg_name => 'BIS_BUCKET_SET_DISCONTINUOUS'
2734: ,p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2735: ,p_error_proc_name => G_PKG_NAME||'.Validate_Bucket_Discontinuous'
2736: ,p_error_type => BIS_UTILITIES_PUB.G_ERROR
2737: ,p_error_table => l_error_tbl

Line 2810: p_short_name IN BIS_BUCKET.short_name%TYPE

2806:
2807: --=============================================================================
2808: --This is the java wrapper for bucket customization UI.
2809: PROCEDURE VALIDATE_BUCKET_WRAPPER (
2810: p_short_name IN BIS_BUCKET.short_name%TYPE
2811: ,p_name IN BIS_BUCKET_TL.name%TYPE
2812: ,p_type IN BIS_BUCKET.type%TYPE
2813: ,p_application_id IN BIS_BUCKET.application_id%TYPE
2814: ,p_range1_name IN BIS_BUCKET_TL.range1_name%TYPE