1 PACKAGE AMS_Ps_Cndclses_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvccls.pls 120.0 2005/06/01 02:19:20 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Ps_Cndclses_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 -- ps_cndclses_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- created_by
26 -- creation_date
27 -- last_updated_by
28 -- last_update_date
29 -- last_update_login
30 -- object_version_number
31 -- cnd_clause_id
32 -- cnd_clause_datatype
33 -- cnd_clause_ref_code
34 -- cnd_comp_operator
35 -- cnd_default_value
36 --
37 -- Required
38 --
39 -- Defaults
40 --
41 -- Note: This is automatic generated record definition, it includes all columns
42 -- defined in the table, developer must manually add or delete some of the attributes.
43 --
44 -- End of Comments
45
46 --===================================================================
47 TYPE ps_cndclses_rec_type IS RECORD
48 (
49 created_by NUMBER := FND_API.G_MISS_NUM,
50 creation_date DATE := FND_API.G_MISS_DATE,
51 last_updated_by NUMBER := FND_API.G_MISS_NUM,
52 last_update_date DATE := FND_API.G_MISS_DATE,
53 last_update_login NUMBER := FND_API.G_MISS_NUM,
54 object_version_number NUMBER := FND_API.G_MISS_NUM,
55 cnd_clause_id NUMBER := FND_API.G_MISS_NUM,
56 cnd_clause_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR,
57 cnd_clause_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
58 cnd_comp_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
59 cnd_default_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
60 cnd_clause_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
61 cnd_clause_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
62 );
63
64 g_miss_ps_cndclses_rec ps_cndclses_rec_type;
65 TYPE ps_cndclses_tbl_type IS TABLE OF ps_cndclses_rec_type INDEX BY BINARY_INTEGER;
66 g_miss_ps_cndclses_tbl ps_cndclses_tbl_type;
67
68 -- ==========================================================
69 -- Start of Comments
70 -- ==========================================================
71 -- API Name
72 -- Create_Ps_Cndclses
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_ps_cndclses_rec IN ps_cndclses_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_Ps_Cndclses(
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_ps_cndclses_rec IN ps_cndclses_rec_type := g_miss_ps_cndclses_rec,
109 x_cnd_clause_id OUT NOCOPY NUMBER
110 );
111
112 -- ==========================================================
113 -- Start of Comments
114 -- ==========================================================
115 -- API Name
116 -- Update_Ps_Cndclses
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_ps_cndclses_rec IN ps_cndclses_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_Ps_Cndclses(
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_ps_cndclses_rec IN ps_cndclses_rec_type,
153 x_object_version_number OUT NOCOPY NUMBER
154 );
155
156 -- ==========================================================
157 -- Start of Comments
158 -- ==========================================================
159 -- API Name
160 -- Delete_Ps_Cndclses
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_CND_CLAUSE_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_Ps_Cndclses(
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_cnd_clause_id IN NUMBER,
196 p_object_version_number IN NUMBER
197 );
198
199 -- ==========================================================
200 -- Start of Comments
201 -- ==========================================================
202 -- API Name
203 -- Lock_Ps_Cndclses
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_ps_cndclses_rec IN ps_cndclses_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_Ps_Cndclses(
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_cnd_clause_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_ps_cndclses(
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_ps_cndclses_rec IN ps_cndclses_rec_type,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2
261 );
262
263 -- Start of Comments
264 --
265 -- validation procedures
266 --
267 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
268 -- For create: G_CREATE, for update: G_UPDATE
269 -- Note: 1. This is automated generated item level validation procedure.
270 -- The actual validation detail is needed to be added.
271 -- 2. Validate the unique keys, lookups here
272 -- End of Comments
273
274 PROCEDURE Check_ps_cndclses_Items (
275 P_ps_cndclses_rec IN ps_cndclses_rec_type,
276 p_validation_mode IN VARCHAR2,
277 x_return_status OUT NOCOPY VARCHAR2
278 );
279
280 -- Start of Comments
281 --
282 -- Record level validation procedures
283 --
284 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
285 -- For create: G_CREATE, for update: G_UPDATE
286 -- Note: 1. This is automated generated item level validation procedure.
287 -- The actual validation detail is needed to be added.
288 -- 2. Developer can manually added inter-field level validation.
289 -- End of Comments
290
291 PROCEDURE Validate_ps_cndclses_rec(
292 p_api_version_number IN NUMBER,
293 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297 p_ps_cndclses_rec IN ps_cndclses_rec_type
298 );
299 END AMS_Ps_Cndclses_PVT;