1 PACKAGE AMS_Iba_Pl_Stylesheets_PVT AS
2 /* $Header: amsvstys.pls 120.0 2005/06/01 01:01:27 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Iba_Pl_Stylesheets_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- iba_pl_stylesheets_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- stylesheet_id
26 -- content_type
27 -- stylesheet_filename
28 -- status_code
29 -- created_by
30 -- creation_date
31 -- last_updated_by
32 -- last_update_date
33 -- last_update_login
34 -- object_version_number
35 -- name
36 -- description
37 --
38 -- Required
39 --
40 -- Defaults
41 --
42 -- Note: This is automatic generated record definition, it includes all columns
43 -- defined in the table, developer must manually add or delete some of the attributes.
44 --
45 -- End of Comments
46
47 --===================================================================
48 TYPE iba_pl_stylesheets_rec_type IS RECORD
49 (
50 stylesheet_id NUMBER := FND_API.G_MISS_NUM,
51 content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
52 stylesheet_filename VARCHAR2(500) := FND_API.G_MISS_CHAR,
53 status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54 created_by NUMBER := FND_API.G_MISS_NUM,
55 creation_date DATE := FND_API.G_MISS_DATE,
56 last_updated_by NUMBER := FND_API.G_MISS_NUM,
57 last_update_date DATE := FND_API.G_MISS_DATE,
58 last_update_login NUMBER := FND_API.G_MISS_NUM,
59 object_version_number NUMBER := FND_API.G_MISS_NUM,
60 name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61 description VARCHAR2(4000) := FND_API.G_MISS_CHAR
62 );
63
64 g_miss_iba_pl_stylesheets_rec iba_pl_stylesheets_rec_type;
65 TYPE iba_pl_stylesheets_tbl_type IS TABLE OF iba_pl_stylesheets_rec_type INDEX BY BINARY_INTEGER;
66 g_miss_iba_pl_stylesheets_tbl iba_pl_stylesheets_tbl_type;
67
68 -- ==============================================================================
69 -- Start of Comments
70 -- ==============================================================================
71 -- API Name
72 -- Create_Iba_Pl_Stylesheets
73 -- Type
74 -- Private
75 -- Pre-Req
76 --
77 -- Parameters
78 --
79 -- IN
80 -- p_api_version_number IN NUMBER Required
81 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
82 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
83 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
84 -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
85 --
86 -- OUT
87 -- x_return_status OUT VARCHAR2
88 -- x_msg_count OUT NUMBER
89 -- x_msg_data OUT VARCHAR2
90 -- Version : Current version 1.0
91 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
92 -- and basic operation, developer must manually add parameters and business logic as necessary.
93 --
94 -- End of Comments
95 -- ==============================================================================
96 --
97
98 PROCEDURE Create_Iba_Pl_Stylesheets(
99 p_api_version_number IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107
108 p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type := g_miss_iba_pl_stylesheets_rec,
109 x_stylesheet_id OUT NOCOPY NUMBER
110 );
111
112 -- ==============================================================================
113 -- Start of Comments
114 -- ==============================================================================
115 -- API Name
116 -- Update_Iba_Pl_Stylesheets
117 -- Type
118 -- Private
119 -- Pre-Req
120 --
121 -- Parameters
122 --
123 -- IN
124 -- p_api_version_number IN NUMBER Required
125 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128 -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
129 --
130 -- OUT
131 -- x_return_status OUT VARCHAR2
132 -- x_msg_count OUT NUMBER
133 -- x_msg_data OUT VARCHAR2
134 -- Version : Current version 1.0
135 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
136 -- and basic operation, developer must manually add parameters and business logic as necessary.
137 --
138 -- End of Comments
139 -- ==============================================================================
140 --
141
142 PROCEDURE Update_Iba_Pl_Stylesheets(
143 p_api_version_number IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151
152 p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type,
153 x_object_version_number OUT NOCOPY NUMBER
154 );
155
156 -- ==============================================================================
157 -- Start of Comments
158 -- ==============================================================================
159 -- API Name
160 -- Delete_Iba_Pl_Stylesheets
161 -- Type
162 -- Private
163 -- Pre-Req
164 --
165 -- Parameters
166 --
167 -- IN
168 -- p_api_version_number IN NUMBER Required
169 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
172 -- p_STYLESHEET_ID IN NUMBER
173 -- p_object_version_number IN NUMBER Optional Default = NULL
174 --
175 -- OUT
176 -- x_return_status OUT VARCHAR2
177 -- x_msg_count OUT NUMBER
178 -- x_msg_data OUT VARCHAR2
179 -- Version : Current version 1.0
180 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
181 -- and basic operation, developer must manually add parameters and business logic as necessary.
182 --
183 -- End of Comments
184 -- ==============================================================================
185 --
186
187 PROCEDURE Delete_Iba_Pl_Stylesheets(
188 p_api_version_number IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190 p_commit IN VARCHAR2 := FND_API.G_FALSE,
191 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_stylesheet_id IN NUMBER,
196 p_object_version_number IN NUMBER
197 );
198
199 -- ==============================================================================
200 -- Start of Comments
201 -- ==============================================================================
202 -- API Name
203 -- Lock_Iba_Pl_Stylesheets
204 -- Type
205 -- Private
206 -- Pre-Req
207 --
208 -- Parameters
209 --
210 -- IN
211 -- p_api_version_number IN NUMBER Required
212 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
215 -- p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type Required
216 --
217 -- OUT
218 -- x_return_status OUT VARCHAR2
219 -- x_msg_count OUT NUMBER
220 -- x_msg_data OUT VARCHAR2
221 -- Version : Current version 1.0
222 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
223 -- and basic operation, developer must manually add parameters and business logic as necessary.
224 --
225 -- End of Comments
226 -- ==============================================================================
227 --
228
229 PROCEDURE Lock_Iba_Pl_Stylesheets(
230 p_api_version_number IN NUMBER,
231 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236
237 p_stylesheet_id IN NUMBER,
238 p_object_version IN NUMBER
239 );
240
241
242 -- Start of Comments
243 --
244 -- validation procedures
245 --
246 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
247 -- For create: G_CREATE, for update: G_UPDATE
248 -- Note: 1. This is automated generated item level validation procedure.
249 -- The actual validation detail is needed to be added.
250 -- 2. We can also validate table instead of record. There will be an option for user to choose.
251 -- End of Comments
252
253 PROCEDURE Validate_iba_pl_stylesheets(
254 p_api_version_number IN NUMBER
255 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
256 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
257 , p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type
258 , x_return_status OUT NOCOPY VARCHAR2
259 , x_msg_count OUT NOCOPY NUMBER
260 , x_msg_data OUT NOCOPY VARCHAR2
261 , p_validation_mode IN VARCHAR2
262 );
263
264 -- Start of Comments
265 --
266 -- validation procedures
267 --
268 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
269 -- For create: G_CREATE, for update: G_UPDATE
270 -- Note: 1. This is automated generated item level validation procedure.
271 -- The actual validation detail is needed to be added.
272 -- 2. Validate the unique keys, lookups here
273 -- End of Comments
274
275 PROCEDURE Check_iba_pl_style_Items (
276 P_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type,
277 p_validation_mode IN VARCHAR2,
278 x_return_status OUT NOCOPY VARCHAR2
279 );
280
281 -- Start of Comments
282 --
283 -- Record level validation procedures
284 --
285 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
286 -- For create: G_CREATE, for update: G_UPDATE
287 -- Note: 1. This is automated generated item level validation procedure.
288 -- The actual validation detail is needed to be added.
289 -- 2. Developer can manually added inter-field level validation.
290 -- End of Comments
291
292 PROCEDURE Validate_iba_pl_style_rec(
293 p_api_version_number IN NUMBER,
294 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295 x_return_status OUT NOCOPY VARCHAR2,
296 x_msg_count OUT NOCOPY NUMBER,
297 x_msg_data OUT NOCOPY VARCHAR2,
298 p_iba_pl_stylesheets_rec IN iba_pl_stylesheets_rec_type
299 );
300 END AMS_Iba_Pl_Stylesheets_PVT;