1 PACKAGE AMS_Prod_Template_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvptms.pls 115.2 2002/11/15 21:02:51 abhola ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Prod_Template_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 -- prod_template_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- template_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- object_version_number
31 -- last_update_login
32 -- security_group_id
33 -- product_service_flag
34 -- template_name
35 -- description
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 prod_template_rec_type IS RECORD
48 (
49 template_id NUMBER := FND_API.G_MISS_NUM,
50 last_update_date DATE := FND_API.G_MISS_DATE,
51 last_updated_by NUMBER := FND_API.G_MISS_NUM,
52 creation_date DATE := FND_API.G_MISS_DATE,
53 created_by NUMBER := FND_API.G_MISS_NUM,
54 object_version_number NUMBER := FND_API.G_MISS_NUM,
55 last_update_login NUMBER := FND_API.G_MISS_NUM,
56 security_group_id NUMBER := FND_API.G_MISS_NUM,
57 product_service_flag VARCHAR2(40) := FND_API.G_MISS_CHAR,
58 template_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
59 description VARCHAR2(4000) := FND_API.G_MISS_CHAR
60 );
61
62
63 g_miss_prod_template_rec prod_template_rec_type;
64 TYPE prod_template_tbl_type IS TABLE OF prod_template_rec_type INDEX BY BINARY_INTEGER;
65 g_miss_prod_template_tbl prod_template_tbl_type;
66
67 -- ==============================================================================
68 -- Start of Comments
69 -- ==============================================================================
70 -- API Name
71 -- Create_Prod_Template
72 -- Type
73 -- Private
74 -- Pre-Req
75 --
76 -- Parameters
77 --
78 -- IN
79 -- p_api_version_number IN NUMBER Required
80 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
81 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
82 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
83 -- p_prod_template_rec IN prod_template_rec_type Required
84 --
85 -- OUT
86 -- x_return_status OUT VARCHAR2
87 -- x_msg_count OUT NUMBER
88 -- x_msg_data OUT VARCHAR2
89 -- Version : Current version 1.0
90 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
91 -- and basic operation, developer must manually add parameters and business logic as necessary.
92 --
93 -- End of Comments
94 -- ==============================================================================
95 --
96
97 PROCEDURE Create_Prod_Template(
98 p_api_version_number IN NUMBER,
99 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100 p_commit IN VARCHAR2 := FND_API.G_FALSE,
101 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106
107 p_prod_template_rec IN prod_template_rec_type := g_miss_prod_template_rec,
108 x_template_id OUT NOCOPY NUMBER
109 );
110
111 -- ==============================================================================
112 -- Start of Comments
113 -- ==============================================================================
114 -- API Name
115 -- Update_Prod_Template
116 -- Type
117 -- Private
118 -- Pre-Req
119 --
120 -- Parameters
121 --
122 -- IN
123 -- p_api_version_number IN NUMBER Required
124 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127 -- p_prod_template_rec IN prod_template_rec_type Required
128 --
129 -- OUT
130 -- x_return_status OUT VARCHAR2
131 -- x_msg_count OUT NUMBER
132 -- x_msg_data OUT VARCHAR2
133 -- Version : Current version 1.0
134 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
135 -- and basic operation, developer must manually add parameters and business logic as necessary.
136 --
137 -- End of Comments
138 -- ==============================================================================
139 --
140
141 PROCEDURE Update_Prod_Template(
142 p_api_version_number IN NUMBER,
143 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144 p_commit IN VARCHAR2 := FND_API.G_FALSE,
145 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150
151 p_prod_template_rec IN prod_template_rec_type
152 );
153
154 -- ==============================================================================
155 -- Start of Comments
156 -- ==============================================================================
157 -- API Name
158 -- Delete_Prod_Template
159 -- Type
160 -- Private
161 -- Pre-Req
162 --
163 -- Parameters
164 --
165 -- IN
166 -- p_api_version_number IN NUMBER Required
167 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
168 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
169 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
170 -- p_TEMPLATE_ID IN NUMBER
171 -- p_object_version_number IN NUMBER Optional Default = NULL
172 --
173 -- OUT
174 -- x_return_status OUT VARCHAR2
175 -- x_msg_count OUT NUMBER
176 -- x_msg_data OUT VARCHAR2
177 -- Version : Current version 1.0
178 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
179 -- and basic operation, developer must manually add parameters and business logic as necessary.
180 --
181 -- End of Comments
182 -- ==============================================================================
183 --
184
185 PROCEDURE Delete_Prod_Template(
186 p_api_version_number IN NUMBER,
187 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188 p_commit IN VARCHAR2 := FND_API.G_FALSE,
189 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_template_id IN NUMBER,
194 p_object_version_number IN NUMBER
195 );
196
197 -- ==============================================================================
198 -- Start of Comments
199 -- ==============================================================================
200 -- API Name
201 -- Lock_Prod_Template
202 -- Type
203 -- Private
204 -- Pre-Req
205 --
206 -- Parameters
207 --
208 -- IN
209 -- p_api_version_number IN NUMBER Required
210 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
211 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
212 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
213 -- p_prod_template_rec IN prod_template_rec_type Required
214 --
215 -- OUT
216 -- x_return_status OUT VARCHAR2
217 -- x_msg_count OUT NUMBER
218 -- x_msg_data OUT VARCHAR2
219 -- Version : Current version 1.0
220 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
221 -- and basic operation, developer must manually add parameters and business logic as necessary.
222 --
223 -- End of Comments
224 -- ==============================================================================
225 --
226
227 PROCEDURE Lock_Prod_Template(
228 p_api_version_number IN NUMBER,
229 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
230
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234
235 p_template_id IN NUMBER,
236 p_object_version IN NUMBER
237 );
238
239
240 -- Start of Comments
241 --
242 -- validation procedures
243 --
244 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
245 -- For create: G_CREATE, for update: G_UPDATE
246 -- Note: 1. This is automated generated item level validation procedure.
247 -- The actual validation detail is needed to be added.
248 -- 2. We can also validate table instead of record. There will be an option for user to choose.
249 -- End of Comments
250
251 PROCEDURE Validate_prod_template(
252 p_api_version_number IN NUMBER,
253 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255 p_prod_template_rec IN prod_template_rec_type,
256 p_validation_mode IN VARCHAR2,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2
260 );
261
262 -- Start of Comments
263 --
264 -- validation procedures
265 --
266 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
267 -- For create: G_CREATE, for update: G_UPDATE
268 -- Note: 1. This is automated generated item level validation procedure.
269 -- The actual validation detail is needed to be added.
270 -- 2. Validate the unique keys, lookups here
271 -- End of Comments
272
273 PROCEDURE Check_prod_template_Items (
274 P_prod_template_rec IN prod_template_rec_type,
275 p_validation_mode IN VARCHAR2,
276 x_return_status OUT NOCOPY VARCHAR2
277 );
278
279 -- Start of Comments
280 --
281 -- Record level validation procedures
282 --
283 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
284 -- For create: G_CREATE, for update: G_UPDATE
285 -- Note: 1. This is automated generated item level validation procedure.
286 -- The actual validation detail is needed to be added.
287 -- 2. Developer can manually added inter-field level validation.
288 -- End of Comments
289
290 PROCEDURE Validate_prod_template_rec(
291 p_api_version_number IN NUMBER,
292 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293 x_return_status OUT NOCOPY VARCHAR2,
294 x_msg_count OUT NOCOPY NUMBER,
295 x_msg_data OUT NOCOPY VARCHAR2,
296 p_prod_template_rec IN prod_template_rec_type
297 );
298 END AMS_Prod_Template_PVT;