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