[Home] [Help]
PACKAGE BODY: APPS.BIS_CUSTOMIZATIONS_PUB
Source
1 PACKAGE BODY BIS_CUSTOMIZATIONS_PUB AS
2 /* $Header: BISPCUSB.pls 115.0 2002/12/16 11:13:10 nkishore noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=plb \
4 -- dbdrv: checkfile:~PROD:~PATH:~FILE
5
6 /*
7 REM +=======================================================================+
8 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
9 REM | All rights reserved. |
10 REM +=======================================================================+
11 REM | FILENAME |
12 REM | BISPCUSB.pls |
13 REM | |
14 REM | DESCRIPTION |
15 REM | Public API for creating ak Customization Data at function level |
16 REM | |
17 REM | NOTES |
18 REM | |
19 REM | HISTORY |
20 REM | 16-Dec-02 nkishore Creation |
21 REM | |
22 REM +=======================================================================+
23 */
24 --
25
26 -- creates rows in ak_customizations/tl
27 --
28 PROCEDURE Create_Customizations
29 ( p_api_version IN NUMBER
30 , p_commit IN VARCHAR2 := 'N'
31 , p_Customizations_Rec IN BIS_CUSTOMIZATIONS_PVT.customizations_type
32 , x_return_status OUT NOCOPY VARCHAR2
33 )
34 IS
35
36 BEGIN
37 BIS_CUSTOMIZATIONS_PVT.Create_Customizations
38 ( p_api_version=>p_api_version
39 , p_commit =>p_commit
40 , p_Customizations_Rec =>p_Customizations_Rec
41 , x_return_status => x_return_status
42 );
43
44 EXCEPTION
45 when FND_API.G_EXC_ERROR then
46 x_return_status := FND_API.G_RET_STS_ERROR ;
47 when FND_API.G_EXC_UNEXPECTED_ERROR then
48 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
49 when others then
50 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
51
52 END Create_Customizations;
53 --
54 --
55
56 PROCEDURE Update_Customizations
57 ( p_api_version IN NUMBER
58 , p_commit IN VARCHAR2 := 'N'
59 , p_Customizations_Rec IN BIS_CUSTOMIZATIONS_PVT.customizations_type
60 , x_return_status OUT NOCOPY VARCHAR2
61 )
62
63 IS
64 BEGIN
65
66 BIS_CUSTOMIZATIONS_PVT.Update_Customizations
67 ( p_api_version=>p_api_version
68 , p_commit =>p_commit
69 , p_Customizations_Rec =>p_Customizations_Rec
70 , x_return_status => x_return_status
71 );
72 EXCEPTION
73 when FND_API.G_EXC_ERROR then
74 x_return_status := FND_API.G_RET_STS_ERROR ;
75 when FND_API.G_EXC_UNEXPECTED_ERROR then
76 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
77 when others then
78 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
79
80 END Update_Customizations;
81
82 PROCEDURE Create_Custom_Regions
83 ( p_api_version IN NUMBER
84 , p_commit IN VARCHAR2 := 'N'
85 , p_Custom_Regions_Rec IN BIS_CUSTOMIZATIONS_PVT.custom_regions_type
86 , x_return_status OUT NOCOPY VARCHAR2
87 )
88
89 IS
90 BEGIN
91 BIS_CUSTOMIZATIONS_PVT.Create_Custom_Regions
92 ( p_api_version=>p_api_version
93 , p_commit =>p_commit
94 , p_Custom_Regions_Rec =>p_Custom_Regions_Rec
95 , x_return_status => x_return_status
96 );
97
98 EXCEPTION
99 when FND_API.G_EXC_ERROR then
100 x_return_status := FND_API.G_RET_STS_ERROR ;
101 when FND_API.G_EXC_UNEXPECTED_ERROR then
102 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
103 when others then
104 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
105
106 END Create_Custom_Regions;
107 --
108 --
109 PROCEDURE Update_Custom_Regions
110 ( p_api_version IN NUMBER
111 , p_commit IN VARCHAR2 := 'N'
112 , p_Custom_Regions_Rec IN BIS_CUSTOMIZATIONS_PVT.custom_regions_type
113 , x_return_status OUT NOCOPY VARCHAR2
114 )
115
116 IS
117 BEGIN
118
119 BIS_CUSTOMIZATIONS_PVT.Update_Custom_Regions
120 ( p_api_version=>p_api_version
121 , p_commit =>p_commit
122 , p_Custom_Regions_Rec =>p_Custom_Regions_Rec
123 , x_return_status => x_return_status
124 );
125 EXCEPTION
126 when FND_API.G_EXC_ERROR then
127 x_return_status := FND_API.G_RET_STS_ERROR ;
128 when FND_API.G_EXC_UNEXPECTED_ERROR then
129 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130 when others then
131 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132
133 END Update_Custom_Regions;
134
135 PROCEDURE Create_Custom_Region_Items
136 ( p_api_version IN NUMBER
137 , p_commit IN VARCHAR2 := 'N'
138 , p_Custom_Region_Items_Rec IN BIS_CUSTOMIZATIONS_PVT.custom_region_items_type
139 , x_return_status OUT NOCOPY VARCHAR2
140 )
141
142 IS
143 BEGIN
144 BIS_CUSTOMIZATIONS_PVT.Create_Custom_Region_Items
145 ( p_api_version=>p_api_version
146 , p_commit =>p_commit
147 , p_Custom_Region_Items_Rec =>p_Custom_Region_Items_Rec
148 , x_return_status => x_return_status
149 );
150
151
152 EXCEPTION
153 when FND_API.G_EXC_ERROR then
154 x_return_status := FND_API.G_RET_STS_ERROR ;
155 when FND_API.G_EXC_UNEXPECTED_ERROR then
156 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
157 when others then
158 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159
160 END Create_Custom_Region_Items;
161 --
162 --
163 PROCEDURE Update_Custom_Region_Items
164 ( p_api_version IN NUMBER
165 , p_commit IN VARCHAR2 := 'N'
166 , p_Custom_Region_Items_Rec IN BIS_CUSTOMIZATIONS_PVT.custom_Region_Items_type
167 , x_return_status OUT NOCOPY VARCHAR2
168 )
169
170 IS
171 BEGIN
172
173 BIS_CUSTOMIZATIONS_PVT.Update_Custom_Region_Items
174 ( p_api_version=>p_api_version
175 , p_commit =>p_commit
176 , p_Custom_Region_Items_Rec =>p_Custom_Region_Items_Rec
177 , x_return_status => x_return_status
178 );
179 EXCEPTION
180 when FND_API.G_EXC_ERROR then
181 x_return_status := FND_API.G_RET_STS_ERROR ;
182 when FND_API.G_EXC_UNEXPECTED_ERROR then
183 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
184 when others then
185 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186
187 END Update_Custom_Region_items;
188
189
190 END BIS_CUSTOMIZATIONS_PUB;