APPS.BIS_BUCKET_PUB dependencies on BIS_UTILITIES_PUB

Line 9: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
12:
13: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 13: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

9: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
10: )
11: IS
12:
13: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
14:
15: BEGIN
16:
17: BIS_BUCKET_PVT.CREATE_BIS_BUCKET(

Line 44: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
47:
48: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 48: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

44: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
45: )
46: IS
47:
48: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
49:
50: BEGIN
51:
52: BIS_BUCKET_PVT.UPDATE_BIS_BUCKET(

Line 77: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

73:
74:
75: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET
76: PROCEDURE DELETE_BIS_BUCKET (
77: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
78: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81: )

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

74:
75: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET
76: PROCEDURE DELETE_BIS_BUCKET (
77: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
78: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81: )
82: IS

Line 80: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

76: PROCEDURE DELETE_BIS_BUCKET (
77: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
78: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81: )
82: IS
83:
84: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 84: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

80: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81: )
82: IS
83:
84: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
85:
86: BEGIN
87:
88: BIS_BUCKET_PVT.DELETE_BIS_BUCKET(

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

110:
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: )

Line 117: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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
120:
121: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 121: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

117: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
118: )
119: IS
120:
121: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
122:
123: BEGIN
124:
125: BIS_BUCKET_PVT.RETRIEVE_BIS_BUCKET(

Line 151: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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:
154: CURSOR c_bkt_set IS
155: SELECT 1

Line 160: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

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;
164: l_bis_bucket_rec := p_bis_bucket_rec;