DBA Data[Home] [Help]

APPS.BIS_BUCKET_PVT dependencies on BIS_BUCKET_PUB

Line 231: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

227:
228: --This API should generate the bucket_id in sequence and insert the data passed to it,
229: --into the tables BIS_BUCKET, BIS_BUCKET_TL and BIS_BUCKET_TYPE
230: PROCEDURE CREATE_BIS_BUCKET (
231: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
232: ,x_return_status OUT NOCOPY VARCHAR2
233: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
234: );
235:

Line 240: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

236:
237: --This API should update the tables BIS_BUCKET, BIS_BUCKET_TL and BIS_BUCKET_TYPE
238: --using the short name or the bucket id as the where clause value
239: PROCEDURE UPDATE_BIS_BUCKET (
240: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
241: ,x_return_status OUT NOCOPY VARCHAR2
242: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
243: );
244:

Line 259: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type

255:
256: --This API should populate a record of type bis_bucket_rec_type based on the bucket short name
257: PROCEDURE RETRIEVE_BIS_BUCKET (
258: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
259: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
260: ,x_return_status OUT NOCOPY VARCHAR2
261: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
262: );
263:

Line 265: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

261: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
262: );
263:
264: PROCEDURE TRANSLATE_BUCKET (
265: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
266: ,p_owner IN VARCHAR2
267: ,x_return_status OUT NOCOPY VARCHAR2
268: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
269: );

Line 276: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

272: p_bucket_type IN VARCHAR2
273: ) RETURN BOOLEAN;
274: --=============================================================================
275: PROCEDURE Validate_Bucket (
276: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
277: ,x_return_status OUT NOCOPY VARCHAR2
278: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
279: );
280: --=============================================================================

Line 296: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

292: --Needed for range validations -- overlappig and discontinous.
293: --=============================================================================
294: PROCEDURE Populate_Loc_Bucket_Range_Tbl
295: (
296: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
297: ,x_bucket_ranges_tbl OUT NOCOPY BIS_BUCKET_PVT.bis_bucket_ranges_tbl
298: ,x_return_status OUT NOCOPY VARCHAR2
299: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
300: );

Line 387: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

383: p_application_id IN NUMBER
384: ) RETURN BOOLEAN;
385:
386: PROCEDURE Validate_Bucket_Common (
387: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
388: ,x_return_status OUT NOCOPY VARCHAR2
389: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
390: );
391: