[Home] [Help]
1: PACKAGE BODY BIS_BUCKET_PUB AS
2: /* $Header: BISPBKTB.pls 115.4 2004/01/24 08:37:51 jxyu noship $ */
3:
4:
5: --This API should call BIS_BUCKET_PVT.CREATE_BIS_BUCKET
3:
4:
5: --This API should call BIS_BUCKET_PVT.CREATE_BIS_BUCKET
6: PROCEDURE CREATE_BIS_BUCKET (
7: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
8: ,x_return_status OUT NOCOPY VARCHAR2
9: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
10: )
11: IS
38:
39:
40: --This API should call BIS_BUCKET_PVT.UPDATE_BIS_BUCKET
41: PROCEDURE UPDATE_BIS_BUCKET (
42: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
43: ,x_return_status OUT NOCOPY VARCHAR2
44: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
45: )
46: IS
111:
112: --This API should call BIS_BUCKET_PVT.RETRIEVE_BIS_BUCKET
113: PROCEDURE RETRIEVE_BIS_BUCKET (
114: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
115: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
116: ,x_return_status OUT NOCOPY VARCHAR2
117: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
118: )
119: IS
145: END RETRIEVE_BIS_BUCKET;
146: -- This API is called from LCT file
147: --=============================================================================
148: PROCEDURE LOAD_BIS_BUCKET (
149: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
150: ,x_return_status OUT NOCOPY VARCHAR2
151: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
152: ) IS
153:
155: SELECT 1
156: FROM bis_bucket
157: WHERE short_name = p_bis_bucket_rec.short_name;
158: l_bucket_exists NUMBER := 0;
159: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
160: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
161: BEGIN
162:
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
218: BIS_BUCKET_PVT.ADD_LANGUAGE;
219:
220: END ADD_LANGUAGE;
221:
222: END BIS_BUCKET_PUB;