[Home] [Help]
PACKAGE: APPS.BIS_BUCKET_PUB
Source
1 PACKAGE BIS_BUCKET_PUB AUTHID CURRENT_USER AS
2 /* $Header: BISPBKTS.pls 115.5 2004/02/15 21:54:59 ankgoel noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_BUCKET_PUB';
5
6 TYPE BIS_BUCKET_REC_TYPE IS RECORD (
7 bucket_id BIS_BUCKET.bucket_id%TYPE
8 ,short_name BIS_BUCKET.short_name%TYPE
9 ,name BIS_BUCKET_TL.name%TYPE
10 ,type BIS_BUCKET.type%TYPE
11 ,application_id BIS_BUCKET.application_id%TYPE
12 ,range1_name BIS_BUCKET_TL.range1_name%TYPE
13 ,range1_low BIS_BUCKET.range1_low%TYPE
14 ,range1_high BIS_BUCKET.range1_high%TYPE
15 ,range2_name BIS_BUCKET_TL.range2_name%TYPE
16 ,range2_low BIS_BUCKET.range2_low%TYPE
17 ,range2_high BIS_BUCKET.range2_high%TYPE
18 ,range3_name BIS_BUCKET_TL.range3_name%TYPE
19 ,range3_low BIS_BUCKET.range3_low%TYPE
20 ,range3_high BIS_BUCKET.range3_high%TYPE
21 ,range4_name BIS_BUCKET_TL.range4_name%TYPE
22 ,range4_low BIS_BUCKET.range4_low%TYPE
23 ,range4_high BIS_BUCKET.range4_high%TYPE
24 ,range5_name BIS_BUCKET_TL.range5_name%TYPE
25 ,range5_low BIS_BUCKET.range5_low%TYPE
26 ,range5_high BIS_BUCKET.range5_high%TYPE
27 ,range6_name BIS_BUCKET_TL.range6_name%TYPE
28 ,range6_low BIS_BUCKET.range6_low%TYPE
29 ,range6_high BIS_BUCKET.range6_high%TYPE
30 ,range7_name BIS_BUCKET_TL.range7_name%TYPE
31 ,range7_low BIS_BUCKET.range7_low%TYPE
32 ,range7_high BIS_BUCKET.range7_high%TYPE
33 ,range8_name BIS_BUCKET_TL.range8_name%TYPE
34 ,range8_low BIS_BUCKET.range8_low%TYPE
35 ,range8_high BIS_BUCKET.range8_high%TYPE
36 ,range9_name BIS_BUCKET_TL.range9_name%TYPE
37 ,range9_low BIS_BUCKET.range9_low%TYPE
38 ,range9_high BIS_BUCKET.range9_high%TYPE
39 ,range10_name BIS_BUCKET_TL.range10_name%TYPE
40 ,range10_low BIS_BUCKET.range10_low%TYPE
41 ,range10_high BIS_BUCKET.range10_high%TYPE
42 ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
43 ,description BIS_BUCKET_TL.description%TYPE
44 ,updatable BIS_BUCKET.updatable%TYPE:='F'
45 ,expandable BIS_BUCKET.expandable%TYPE:='F'
46 ,discontinuous BIS_BUCKET.discontinuous%TYPE:='F'
47 ,overlapping BIS_BUCKET.overlapping%TYPE:='F'
48 ,uom BIS_BUCKET.uom%TYPE
49 );
50
51
52 --This API should call BIS_BUCKET_PVT.CREATE_BIS_BUCKET
53 PROCEDURE CREATE_BIS_BUCKET (
54 p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
55 ,x_return_status OUT NOCOPY VARCHAR2
56 ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
57 );
58
59 --This API should call BIS_BUCKET_PVT.UPDATE_BIS_BUCKET
60 PROCEDURE UPDATE_BIS_BUCKET (
61 p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
64 );
65
66 --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET
67 PROCEDURE DELETE_BIS_BUCKET (
68 p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
69 ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
72 );
73
74
75 --This API should call BIS_BUCKET_PVT.RETRIEVE _BIS_BUCKET
76 PROCEDURE RETRIEVE_BIS_BUCKET (
77 p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
78 ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
79 ,x_return_status OUT NOCOPY VARCHAR2
80 ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81 );
82 -- This API is called from LCT file
83 --=============================================================================
84 PROCEDURE LOAD_BIS_BUCKET (
85 p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
86 ,x_return_status OUT NOCOPY VARCHAR2
87 ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
88 );
89 --=============================================================================
90
91 PROCEDURE ADD_LANGUAGE;
92
93 END BIS_BUCKET_PUB;