[Home] [Help]
PACKAGE: APPS.BIS_CUSTOMIZATION_PUB
Source
1 PACKAGE BIS_CUSTOMIZATION_PUB AS
2 /* $Header: BISPCSTS.pls 120.1 2006/02/14 13:25:57 hengliu noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.1=120.1):~PROD:~PATH:~FILE
5
6 /*
7 REM +=======================================================================+
8 REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |
9 REM | All rights reserved. |
10 REM +=======================================================================+
11 REM | FILENAME |
12 REM | BISPCSTS.pls |
13 REM | |
14 REM | DESCRIPTION |
15 REM | Public API for shipping ak customizations at function level |
16 REM | |
17 REM | NOTES |
18 REM | |
19 REM | HISTORY |
20 REM | 27-Apr-2005 kyadamak Creation |
21 REM | 14-Feb-2006 hengliu Added Delete_Custom_Region_Items |
22 REM +=======================================================================+
23 */
24 --
25
26 TYPE custom_region_items_type IS RECORD
27 ( customization_application_id ak_custom_region_items.customization_application_id%TYPE
28 , customization_code ak_custom_region_items.customization_code%TYPE
29 , region_application_id ak_custom_region_items.region_application_id%TYPE
30 , region_code ak_custom_region_items.region_code%TYPE
31 , attribute_application_id ak_custom_region_items.attribute_application_id%TYPE
32 , attribute_code ak_custom_region_items.attribute_code%TYPE
33 , property_name ak_custom_region_items.property_name%TYPE
34 , property_varchar2_value ak_custom_region_items.property_varchar2_value%TYPE
35 , property_number_value ak_custom_region_items.property_number_value%TYPE
36 , property_date_value ak_custom_region_items.property_date_value%TYPE
37 , language ak_custom_region_items_tl.language%TYPE
38 , source_lang ak_custom_region_items_tl.source_lang%TYPE
39 , created_by ak_custom_region_items_tl.created_by%TYPE
40 , creation_date ak_custom_region_items_tl.creation_date%TYPE
41 , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
42 , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
43 , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
44 );
45
46 TYPE customizations_type IS RECORD
47 ( customization_application_id ak_customizations.customization_application_id%TYPE
48 , customization_code ak_customizations.customization_code%TYPE
49 , region_application_id ak_customizations.region_application_id%TYPE
50 , region_code ak_customizations.region_code%TYPE
51 , verticalization_id ak_customizations.verticalization_id%TYPE
52 , localization_code ak_customizations.localization_code%TYPE
53 , org_id ak_customizations.org_id%TYPE
54 , site_id ak_customizations.site_id%TYPE
55 , responsibility_id ak_customizations.responsibility_id%TYPE
56 , web_user_id ak_customizations.web_user_id%TYPE
57 , default_customization_flag ak_customizations.default_customization_flag%TYPE
58 , customization_level_id ak_customizations.customization_level_id%TYPE
59 , start_date_active ak_customizations.start_date_active%TYPE
60 , end_date_active ak_customizations.end_date_active%TYPE
61 , reference_path ak_customizations.reference_path%TYPE
62 , function_name ak_customizations.function_name%TYPE
63 , developer_mode ak_customizations.developer_mode%TYPE
64 , name ak_customizations_tl.name%TYPE
65 , description ak_customizations_tl.description%TYPE
66 , language ak_custom_region_items_tl.language%TYPE
67 , source_lang ak_custom_region_items_tl.source_lang%TYPE
68 , created_by ak_custom_region_items_tl.created_by%TYPE
69 , creation_date ak_custom_region_items_tl.creation_date%TYPE
70 , last_updated_by ak_custom_region_items_tl.last_updated_by%TYPE
71 , last_update_date ak_custom_region_items_tl.last_update_date%TYPE
72 , last_update_login ak_custom_region_items_tl.last_update_login%TYPE
73 );
74
75
76 -- PROCEDUREs
77 --
78 -- creates rows into ak_custom_region_items and tl tables
79 --
80 PROCEDURE Create_Custom_Region_Items
81 ( p_api_version IN NUMBER
82 , p_commit IN VARCHAR2 := FND_API.G_FALSE
83 , p_Custom_region_items_Rec IN BIS_CUSTOMIZATION_PUB.custom_region_items_type
84 , x_return_status OUT NOCOPY VARCHAR2
85 , x_msg_count OUT NOCOPY NUMBER
86 , x_msg_data OUT NOCOPY VARCHAR2
87 );
88 --
89 --
90 -- updates rows into ak_custom_region_items and tl tables
91 --
92 PROCEDURE Update_Custom_Region_Items
93 ( p_api_version IN NUMBER
94 , p_commit IN VARCHAR2 := FND_API.G_FALSE
95 , p_Custom_region_items_Rec IN BIS_CUSTOMIZATION_PUB.custom_region_items_type
96 , x_return_status OUT NOCOPY VARCHAR2
97 , x_msg_count OUT NOCOPY NUMBER
98 , x_msg_data OUT NOCOPY VARCHAR2
99 );
100 --
101 --
102 -- delete row in ak_custom_region_items and tl tables
103 --
104 PROCEDURE Delete_Custom_Region_Items
105 ( p_api_version IN NUMBER
106 , p_commit IN VARCHAR2 := FND_API.G_FALSE
107 , p_Custom_region_items_Rec IN BIS_CUSTOMIZATION_PUB.custom_region_items_type
108 , x_return_status OUT NOCOPY VARCHAR2
109 , x_msg_count OUT NOCOPY NUMBER
110 , x_msg_data OUT NOCOPY VARCHAR2
111 );
112 --
113 --
114 PROCEDURE Update_Customizations
115 ( p_api_version IN NUMBER
116 , p_commit IN VARCHAR2 := FND_API.G_FALSE
117 , p_Customizations_Rec IN BIS_CUSTOMIZATION_PUB.customizations_type
118 , x_return_status OUT NOCOPY VARCHAR2
119 , x_msg_count OUT NOCOPY NUMBER
120 , x_msg_data OUT NOCOPY VARCHAR2
121 );
122 --
123 --
124 -- creates rows into ak_custom_regions and tl tables
125 --
126 PROCEDURE Create_Customizations
127 ( p_api_version IN NUMBER
128 , p_commit IN VARCHAR2 := FND_API.G_FALSE
129 , p_Customizations_Rec IN BIS_CUSTOMIZATION_PUB.customizations_type
130 , x_return_status OUT NOCOPY VARCHAR2
131 , x_msg_count OUT NOCOPY NUMBER
132 , x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE Create_Customizations_UI
136 ( p_api_version IN NUMBER
137 , p_commit IN VARCHAR2 := FND_API.G_FALSE
138 , p_customization_application_id IN NUMBER
139 , p_customization_code IN VARCHAR2
140 , p_region_application_id IN NUMBER
141 , p_region_code IN VARCHAR2
142 , p_verticalization_id IN VARCHAR2
143 , p_localization_code IN VARCHAR2
144 , p_org_id IN NUMBER
145 , p_site_id IN NUMBER
146 , p_responsibility_id IN NUMBER
147 , p_web_user_id IN NUMBER
148 , p_default_customization_flag IN VARCHAR2
149 , p_customization_level_id IN NUMBER
150 , p_start_date_active IN DATE
151 , p_end_date_active IN DATE
152 , p_reference_path IN VARCHAR2
153 , p_function_name IN VARCHAR2
154 , p_developer_mode IN VARCHAR2
155 , p_name IN VARCHAR2
156 , p_description IN VARCHAR2
157 , x_return_status OUT NOCOPY VARCHAR2
158 , x_msg_count OUT NOCOPY NUMBER
159 , x_msg_data OUT NOCOPY VARCHAR2
160 );
161
162 PROCEDURE Update_Customizations_UI
163 ( p_api_version IN NUMBER
164 , p_commit IN VARCHAR2 := FND_API.G_FALSE
165 , p_customization_application_id IN NUMBER
166 , p_customization_code IN VARCHAR2
167 , p_region_application_id IN NUMBER
168 , p_region_code IN VARCHAR2
169 , p_verticalization_id IN VARCHAR2
170 , p_localization_code IN VARCHAR2
171 , p_org_id IN NUMBER
172 , p_site_id IN NUMBER
173 , p_responsibility_id IN NUMBER
174 , p_web_user_id IN NUMBER
175 , p_default_customization_flag IN VARCHAR2
176 , p_customization_level_id IN NUMBER
177 , p_start_date_active IN DATE
178 , p_end_date_active IN DATE
179 , p_reference_path IN VARCHAR2
180 , p_function_name IN VARCHAR2
181 , p_developer_mode IN VARCHAR2
182 , p_name IN VARCHAR2
183 , p_description IN VARCHAR2
184 , x_return_status OUT NOCOPY VARCHAR2
185 , x_msg_count OUT NOCOPY NUMBER
186 , x_msg_data OUT NOCOPY VARCHAR2
187 );
188
189
190 PROCEDURE Create_Custom_Region_Items_UI
191 ( p_api_version IN NUMBER
192 , p_commit IN VARCHAR2 := FND_API.G_FALSE
193 , p_customization_application_id IN NUMBER
194 , p_customization_code IN VARCHAR2
195 , p_region_application_id IN NUMBER
196 , p_region_code IN VARCHAR2
197 , p_attribute_application_id IN NUMBER
198 , p_attribute_code IN VARCHAR2
199 , p_property_name IN VARCHAR2
200 , p_property_varchar2_value IN VARCHAR2
201 , p_property_number_value IN NUMBER
202 , p_property_date_value IN DATE
203 , x_return_status OUT NOCOPY VARCHAR2
204 , x_msg_count OUT NOCOPY NUMBER
205 , x_msg_data OUT NOCOPY VARCHAR2
206 );
207 --
208 --
209 -- updates rows into ak_custom_region_items and tl tables
210 --
211 PROCEDURE Update_Custom_Region_Items_UI
212 ( p_api_version IN NUMBER
213 , p_commit IN VARCHAR2 := FND_API.G_FALSE
214 , p_customization_application_id IN NUMBER
215 , p_customization_code IN VARCHAR2
216 , p_region_application_id IN NUMBER
217 , p_region_code IN VARCHAR2
218 , p_attribute_application_id IN NUMBER
219 , p_attribute_code IN VARCHAR2
220 , p_property_name IN VARCHAR2
221 , p_property_varchar2_value IN VARCHAR2
222 , p_property_number_value IN NUMBER
223 , p_property_date_value IN DATE
224 , x_return_status OUT NOCOPY VARCHAR2
225 , x_msg_count OUT NOCOPY NUMBER
226 , x_msg_data OUT NOCOPY VARCHAR2
227 );
228 --
229 -- delete rows from ak_custom_region_items and tl tables
230 --
231 PROCEDURE Delete_Custom_Region_Items_UI
232 ( p_api_version IN NUMBER
233 , p_commit IN VARCHAR2 := FND_API.G_FALSE
234 , p_customization_application_id IN NUMBER
235 , p_customization_code IN VARCHAR2
236 , p_region_application_id IN NUMBER
237 , p_region_code IN VARCHAR2
238 , p_attribute_application_id IN NUMBER
239 , p_attribute_code IN VARCHAR2
240 , p_property_name IN VARCHAR2
241 , x_return_status OUT NOCOPY VARCHAR2
242 , x_msg_count OUT NOCOPY NUMBER
243 , x_msg_data OUT NOCOPY VARCHAR2
244 );
245
246 END BIS_CUSTOMIZATION_PUB;