[Home] [Help]
PACKAGE: APPS.AMS_ACT_MARKET_SEGMENTS_PVT
Source
1 PACKAGE AMS_Act_Market_Segments_PVT AS
2 /* $Header: amsvmkss.pls 120.1 2005/06/16 06:12:48 appldev $ */
3
4 TYPE mks_rec_type IS RECORD
5 (
6 ACTIVITY_MARKET_SEGMENT_ID NUMBER,
7 LAST_UPDATE_DATE DATE,
8 LAST_UPDATED_BY NUMBER,
9 CREATION_DATE DATE,
10 CREATED_BY NUMBER,
11 MARKET_SEGMENT_ID NUMBER,
12 ACT_MARKET_SEGMENT_USED_BY_ID NUMBER,
13 ARC_ACT_MARKET_SEGMENT_USED_BY VARCHAR2(30),
14 SEGMENT_TYPE VARCHAR2(30),
15 LAST_UPDATE_LOGIN NUMBER,
16 OBJECT_VERSION_NUMBER NUMBER,
17 ATTRIBUTE_CATEGORY VARCHAR2(30),
18 ATTRIBUTE1 VARCHAR2(150),
19 ATTRIBUTE2 VARCHAR2(150),
20 ATTRIBUTE3 VARCHAR2(150),
21 ATTRIBUTE4 VARCHAR2(150),
22 ATTRIBUTE5 VARCHAR2(150),
23 ATTRIBUTE6 VARCHAR2(150),
24 ATTRIBUTE7 VARCHAR2(150),
25 ATTRIBUTE8 VARCHAR2(150),
26 ATTRIBUTE9 VARCHAR2(150),
27 ATTRIBUTE10 VARCHAR2(150),
28 ATTRIBUTE11 VARCHAR2(150),
29 ATTRIBUTE12 VARCHAR2(150),
30 ATTRIBUTE13 VARCHAR2(150),
31 ATTRIBUTE14 VARCHAR2(150),
32 ATTRIBUTE15 VARCHAR2(150),
33 GROUP_CODE VARCHAR2(30),
34 EXCLUDE_FLAG VARCHAR2(30)
35 );
36
37 /****************************************************************************/
38 -- Procedure
39 -- create_market_segments
40 -- Purpose
41 -- create a row in AMS_ACT_MARKET_SEGMENTS
42 -- Parameters
43 -- IN:
44 -- p_api_version IN NUMBER
45 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
46 -- p_commit IN VARCHAR2 := FND_API.g_false
47 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
48 --
49 -- p_mks_rec IN mks_rec_type
50 --
51 -- OUT:
52 -- x_return_status OUT NOCOPY VARCHAR2
53 -- x_msg_count OUT NOCOPY NUMBER
54 -- x_msg_data OUT NOCOPY VARCHAR2
55 --
56 -- x_act_mks_id OUT NOCOPY NUMBER
57 ------------------------------------------------------------------------------
58 PROCEDURE create_market_segments
59 (
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
62 p_commit IN VARCHAR2 := FND_API.g_false,
63 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
64
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68
69 p_mks_rec IN mks_rec_type,
70 x_act_mks_id OUT NOCOPY NUMBER
71 );
72
73 /****************************************************************************/
74 -- Procedure
75 -- update_market_segments
76 -- Purpose
77 -- update a row in AMS_ACT_MARKET_SEGMENTS
78 -- Parameters
79 -- IN:
80 -- p_api_version IN NUMBER
81 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
82 -- p_commit IN VARCHAR2 := FND_API.g_false
83 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
84 --
85 -- p_mks_rec IN mks_rec_type
86 --
87 -- OUT:
88 -- x_return_status OUT NOCOPY VARCHAR2
89 -- x_msg_count OUT NOCOPY NUMBER
90 -- x_msg_data OUT NOCOPY VARCHAR2
91 ------------------------------------------------------------------------------
92 PROCEDURE update_market_segments
93 (
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96 p_commit IN VARCHAR2 := FND_API.g_false,
97 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102
103 p_mks_rec IN mks_rec_type
104 );
105
106 /****************************************************************************/
107 -- Procedure
108 -- delete_market_segments
109 -- Purpose
110 -- delete a row from AMS_ACT_MARKET_SEGMENTS
111 -- Parameters
112 -- IN:
113 -- p_api_version IN NUMBER
114 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
115 -- p_commit IN VARCHAR2 := FND_API.g_false
116 --
117 -- p_act_mks_id IN NUMBER
118 -- p_object_version IN NUMBER
119 --
120 -- OUT:
121 -- x_return_status OUT NOCOPY VARCHAR2
122 -- x_msg_count OUT NOCOPY NUMBER
123 -- x_msg_data OUT NOCOPY VARCHAR2
124 ------------------------------------------------------------------------------
125 PROCEDURE delete_market_segments
126 (
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
129 p_commit IN VARCHAR2 := FND_API.g_false,
130
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134
135 p_act_mks_id IN NUMBER,
136 p_object_version IN NUMBER
137 );
138
139 /****************************************************************************/
140 -- Procedure
141 -- lock_market_segments
142 -- Purpose
143 -- lock a row form AMS_ACT_MARKET_SEGMENTS
144 -- Parameters
145 -- IN:
146 -- p_api_version IN NUMBER
147 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
148 --
149 -- p_act_mks_id IN NUMBER
150 -- p_object_version IN NUMBER
151 --
152 -- OUT:
153 -- x_return_status OUT NOCOPY VARCHAR2
154 -- x_msg_count OUT NOCOPY NUMBER
155 -- x_msg_data OUT NOCOPY VARCHAR2
156 ------------------------------------------------------------------------------
157 PROCEDURE lock_market_segments
158 (
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
161
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165
166 p_act_mks_id IN NUMBER,
167 p_object_version IN NUMBER
168 );
169
170 /***************************************************************************/
171 -- Procedure
172 -- validate_market_segments
173 -- Purpose
174 -- validate a record before inserting or updating AMS_ACT_MARKET_SEGMENTS
175 -- Parameters
176 -- IN:
177 -- p_api_version IN NUMBER
178 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
179 -- p_validation_mode IN VARCHAR2
180 --
181 -- p_mks_rec IN mks_rec_type
182 --
183 -- OUT:
184 -- x_return_status OUT NOCOPY VARCHAR2
185 -- x_msg_count OUT NOCOPY NUMBER
186 -- x_msg_data OUT NOCOPY VARCHAR2
187 ------------------------------------------------------------------------------
188 PROCEDURE validate_market_segments
189 (
190 p_api_version IN NUMBER,
191 P_init_msg_list IN VARCHAR2 := FND_API.g_false,
192 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197
198 p_mks_rec IN mks_rec_type
199 );
200
201
202 -- Start of Comments
203 --
204 -- NAME
205 -- Check_Mks_Items
206 --
207 -- PURPOSE
208 -- This procedure is to validate ams_act_market_segtments
209 -- NOTES
210 --
211 -- HISTORY
212 -- 12/16/1999 ptendulk created
213 -- End of Comments
214
215 PROCEDURE check_Mks_items(
216 p_mks_rec IN mks_rec_type,
217 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
218 x_return_status OUT NOCOPY VARCHAR2
219 ) ;
220
221
222 -- Start of Comments
223 --
224 -- NAME
225 -- Validate_cross_ent_Rec
226 --
227 -- PURPOSE
228 -- This procedure is to validate Unique Marketsegment across
229 -- Activities
230 -- NOTES
231 --
232 --
233 -- HISTORY
234 -- 12/16/1999 ptendulk created
235 -- End of Comments
236 PROCEDURE Validate_cross_ent_Rec(
237 p_mks_rec IN mks_rec_type,
238 p_complete_rec IN mks_rec_type,
239 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
240 x_return_status OUT NOCOPY VARCHAR2
241 ) ;
242
243
244 -- Start of Comments
245 --
246 -- NAME
247 -- Validate_Mks_Record
248 --
249 -- PURPOSE
250 -- This procedure is to validate ams_act_market_segments table
251 -- NOTES
252 --
253 --
254 -- HISTORY
255 -- 12/16/1999 ptendulk created
256 -- End of Comments
257 PROCEDURE Check_Mks_Record(
258 p_mks_rec IN mks_rec_type,
259 p_complete_rec IN mks_rec_type,
260 x_return_status OUT NOCOPY VARCHAR2
261 ) ;
262
263 -- Start of Comments
264 --
265 -- NAME
266 -- Init_Mks_Rec
267 --
268 -- PURPOSE
269 -- This procedure is to Initialize the Record type before Updation.
270 --
271 -- NOTES
272 --
273 --
274 -- HISTORY
275 -- 12/16/1999 ptendulk created
276 -- End of Comments
277 PROCEDURE Init_Mks_Rec(
278 x_mks_rec OUT NOCOPY mks_rec_type
279 ) ;
280
281 /* Start of Comments Made by ptendulk */
282 /****************************************************************************/
283 -- Procedure
284 -- check_mks_req_items
285 -- Purpose
286 -- check if required items are missing
287 -- Parameters
288 -- IN:
289 -- p_validation_mode IN VARCHAR2
290 -- p_mks_rec IN mks_rec_type
291 -- OUT:
292 -- x_return_status OUT NOCOPY VARCHAR2
293 ------------------------------------------------------------------------------
294 --PROCEDURE check_mks_req_items
295 --(
296 -- p_validation_mode IN VARCHAR2,
297 -- p_mks_rec IN mks_rec_type,
298 -- x_return_status OUT NOCOPY VARCHAR2
299 --);
300
301 /****************************************************************************/
302 -- Procedure
303 -- check_mks_fk_items
304 -- Purpose
305 -- check foreign key items
306 -- Parameters
307 -- IN:
308 -- p_mks_rec IN mks_rec_type
309 -- OUT:
310 -- x_return_status OUT NOCOPY VARCHAR2
311 ------------------------------------------------------------------------------
312 --PROCEDURE check_mks_fk_items
313 --(
314 -- p_mks_rec IN mks_rec_type,
315 -- x_return_status OUT NOCOPY VARCHAR2
316 --);
317
318 /****************************************************************************/
319 -- Procedure
320 -- check_mks_lookup_items
321 -- Purpose
322 -- check for lookup items
323 -- Parameters
324 -- IN:
325 --- p_mks_rec IN mks_rec_type
326 -- OUT:
327 -- x_return_status OUT NOCOPY VARCHAR2
328 ------------------------------------------------------------------------------
329 --PROCEDURE check_mks_lookup_items
330 --(
331 -- p_mks_rec IN mks_rec_type,
332 -- x_return_status OUT NOCOPY VARCHAR2
333 --);
334 /* End Of code Commented by ptendulk */
335
336 /****************************************************************************/
337 -- Procedure
338 -- complete_mks_rec
339 -- Purpose
340 -- replace "g_miss" values with current database values
341 -- Parameters
342 -- IN:
343 -- p_mks_rec IN mks_rec_type
344 -- OUT:
345 -- x_complete_rec OUT NOCOPY mks_rec_type
346 ------------------------------------------------------------------------------
347 PROCEDURE complete_mks_rec
348 (
349 p_mks_rec IN mks_rec_type,
350 x_complete_rec OUT NOCOPY mks_rec_type
351 );
352
353 END AMS_Act_Market_Segments_PVT;