[Home] [Help]
PACKAGE: APPS.AMS_ACTDELVMETHOD_PVT
Source
1 PACKAGE AMS_ActDelvMethod_PVT AS
2 /* $Header: amsvdlvs.pls 120.1 2005/06/27 05:41:21 appldev ship $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AMS_ActDelvMethod_PVT
8 --
9 -- PURPOSE
10 -- This package is a Private API for managing Delivery Method information in
11 -- AMS.
12 --
13 -- Procedures:
14 -- Create_Act_DelvMethod (see below for specification)
15 -- Update_Act_DelvMethod (see below for specification)
16 -- Delete_Act_DelvMethod (see below for specification)
17 -- Lock_Act_DelvMethod (see below for specification)
18 -- Validate_Act_DelvMethod (see below for specification)
19 -- Validate_Act_DelvMethod_Items (see below for specification)
20 -- Validate_Act_DelvMethod_Record (see below for specification
21 --
22 -- NOTES
23 --
24 -- History created rvaka 11/11/1999
25 --
26 -- End of Comments
27
28 -- global constants
29
30 TYPE act_DelvMethod_rec_type
31 IS RECORD
32 (
33 ACTIVITY_DELIVERY_METHOD_ID NUMBER, -- PK
34 LAST_UPDATE_DATE DATE,
35 LAST_UPDATED_BY NUMBER ,
36 CREATION_DATE DATE ,
37 CREATED_BY NUMBER ,
38 LAST_UPDATE_LOGIN NUMBER ,
39 OBJECT_VERSION_NUMBER NUMBER,
40
41 ACT_DELIVERY_METHOD_USED_BY_ID NUMBER,
42 ARC_ACT_DELIVERY_USED_BY VARCHAR2(30),
43 DELIVERY_MEDIA_TYPE_CODE VARCHAR2(30),
44
45 ATTRIBUTE_CATEGORY VARCHAR2(30),
46 ATTRIBUTE1 VARCHAR2(150),
47 ATTRIBUTE2 VARCHAR2(150),
48 ATTRIBUTE3 VARCHAR2(150),
49 ATTRIBUTE4 VARCHAR2(150),
50 ATTRIBUTE5 VARCHAR2(150),
51 ATTRIBUTE6 VARCHAR2(150),
52 ATTRIBUTE7 VARCHAR2(150),
53 ATTRIBUTE8 VARCHAR2(150),
54 ATTRIBUTE9 VARCHAR2(150),
55 ATTRIBUTE10 VARCHAR2(150),
56 ATTRIBUTE11 VARCHAR2(150),
57 ATTRIBUTE12 VARCHAR2(150),
58 ATTRIBUTE13 VARCHAR2(150),
59 ATTRIBUTE14 VARCHAR2(150),
60 ATTRIBUTE15 VARCHAR2(150)
61 );
62
63 PROCEDURE Create_Act_DelvMethod
64 ( p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66 p_commit IN VARCHAR2 := FND_API.G_FALSE,
67 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71
72 p_act_DelvMethod_rec IN Act_DelvMethod_rec_type,
73 x_act_DelvMethod_id OUT NOCOPY NUMBER
74 );
75
76 /****************************************************************************/
77 -- Start of Comments
78 --
79 -- API name : Update_Act_DelvMethod
80 -- Type : Private
81 -- Function : Update a row in AMS_ACT_DELIVERY_METHODS table
82 --
83 -- Pre-reqs : None
84 -- Paramaeters :
85 -- IN :
86 -- standard IN parameters
87 -- p_api_version IN NUMBER := NULL Required
88 -- p_init_msg_list IN VARCHAR2 Optional
89 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
90 -- p_validation_level IN NUMBER
91 -- := FND_API.G_VALID_LEVEL_FULL,
92 -- API's IN parameters
93 --
94 -- p_act_DelvMethod_rec IN Act_DelvMethod_rec_type
95 --
96 -- OUT :
97 -- standard OUT parameters
98 -- x_return_status OUT VARCHAR2(1)
99 -- x_msg_count OUT NUMBER
100 -- x_msg_data OUT VARCHAR2(2000)
101 --
102 -- Version : Current version 1.0
103 -- Initial version 1.0
104 --
105 -- Note : 1. p_act_DelvMethod_rec.activity_delivery_method_id is a required parameter
106 -- 2. p_act_DelvMethod_rec.activity_delivery_method_id is not updatable
107 --
108 -- End Of Comments
109
110 PROCEDURE Update_Act_DelvMethod
111 ( p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113 p_commit IN VARCHAR2 := FND_API.G_FALSE,
114 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118
119 p_act_DelvMethod_rec IN Act_DelvMethod_rec_type
120 );
121
122 /*****************************************************************************************/
123 -- Start of Comments
124 --
125 -- API name : Delete_Act_DelvMethod
126 -- Type : Private
127 -- Function : Delete a row in AMS_ACT_DELIVERY_METHODS table
128 --
129 -- Pre-reqs : None
130 -- Paramaeters :
131 -- IN :
132 -- standard IN parameters
133 -- p_api_version IN NUMBER := NULL Required
134 -- p_init_msg_list IN VARCHAR2 Optional
135 -- Default := FND_API.G_FALSE
136 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
137 -- p_validation_level IN NUMBER
138 -- := FND_API.G_VALID_LEVEL_FULL,
139 -- API's IN parameters
140 -- p_act_DelvMethod_rec IN Act_DelvMethod_rec_type Required
141 --
142 -- standard OUT parameters
143 -- x_return_status OUT VARCHAR2(1)
144 -- x_msg_count OUT NUMBER
145 -- x_msg_data OUT VARCHAR2(2000)
146 --
147 -- Version : Current version 1.0
148 -- Initial version 1.0
149 --
150 -- Note : 1. p_DelvMethod_rec.activity_Delivery_method_id is a required parameter
151 --
152 -- End Of Comments
153
154 PROCEDURE Delete_Act_DelvMethod
155 ( p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157 p_commit IN VARCHAR2 := FND_API.G_FALSE,
158 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162
163 p_act_DelvMethod_id IN NUMBER,
164 p_object_version IN NUMBER
165 );
166
167
168 /*****************************************************************************************/
169 -- Start of Comments
170 --
171 -- API name : Lock_Act_DelvMethod
172 -- Type : Private
173 -- Function : Lock a row in AMS_ACT_DELIVERY_METHODS table
174 --
175 -- Pre-reqs : None
176 -- Paramaeters :
177 -- IN :
178 -- standard IN parameters
179 -- p_api_version IN NUMBER := NULL Required
180 -- p_init_msg_list IN VARCHAR2 Optional
181 -- Default := FND_API.G_FALSE
182 -- p_validation_level IN NUMBER
183 -- := FND_API.G_VALID_LEVEL_FULL,
184 -- API's IN parameters
185 -- p_DelvMethod_rec IN Act_DelvMethod_rec_type Required
186 -- OUT :
187 -- standard OUT parameters
188 -- x_return_status OUT VARCHAR2(1)
189 -- x_msg_count OUT NUMBER
190 -- x_msg_data OUT VARCHAR2(2000)
191 --
192 --
193 -- Version : Current version 1.0
194 -- Initial version 1.0
195 --
196 -- Note : p_DelvMethod_rec.activity_category_id is a required parameter
197 --
198 -- End Of Comments
199
200 PROCEDURE Lock_Act_DelvMethod
201 ( p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207
208 p_act_DelvMethod_id IN NUMBER,
209 p_object_version IN NUMBER
210 );
211
212 /*****************************************************************************************/
213 -- Start of Comments
214 --
215 -- API name : Validate_Act_DelvMethod
216 -- Type : Private
217 -- Function : Validate a row in AMS_ACT_DELIVERY_METHODS table
218 --
219 -- Pre-reqs : None
220 -- Paramaeters :
221 -- IN :
222 -- standard IN parameters
223 -- p_api_version IN NUMBER := NULL Required
224 -- p_init_msg_list IN VARCHAR2 Optional
225 -- Default := FND_API.G_FALSE
226 -- p_validation_level IN NUMBER
227 -- := FND_API.G_VALID_LEVEL_FULL,
228 -- API's IN parameters
229 --
230 -- p_DelvMethod_rec IN Act_DelvMethod_rec_type Required
231 --
232 -- standard OUT parameters
233 -- x_return_status OUT VARCHAR2(1)
234 -- x_msg_count OUT NUMBER
235 -- x_msg_data OUT VARCHAR2(2000)
236 --
237 -- Version : Current version 1.0
238 -- Initial version 1.0
239 --
240 -- Note : 1. p_DelvMethod_rec.activity_delivery_method_id is a required parameter
241 -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
242 -- FND_API.G_RET_STS_ERROR, or
243 -- FND_API.G_RET_STS_UNEXP_ERROR
244 --
245 -- End Of Comments
246
247 PROCEDURE Validate_Act_DelvMethod
248 ( p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254
255 p_act_DelvMethod_rec IN Act_DelvMethod_rec_type
256 );
257
258 PROCEDURE Validate_Act_DelvMethod_Items
259 ( p_act_DelvMethod_rec IN Act_DelvMethod_rec_type,
260 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
261 x_return_status OUT NOCOPY VARCHAR2
262 );
263
264 PROCEDURE Validate_Act_DelvMethod_Record
265 (
266 p_act_DelvMethod_rec IN Act_DelvMethod_rec_type,
267 x_return_status OUT NOCOPY VARCHAR2
268 );
269 --added sugupta 07/25/2000 init_act_DelvMethod_rec
270 PROCEDURE init_act_DelvMethod_rec(
271 x_act_DelvMethod_rec OUT NOCOPY act_DelvMethod_rec_type
272 );
273 PROCEDURE complete_act_DelvMethod_rec(
274 p_act_DelvMethod_rec IN Act_DelvMethod_rec_type,
275 x_act_DelvMethod_rec OUT NOCOPY Act_DelvMethod_rec_type
276 );
277
278 END AMS_ActDelvMethod_PVT;