1 PACKAGE BODY MRP_Assignment_Set_Util AS
2 /* $Header: MRPUASTB.pls 115.2 99/07/16 12:39:03 porting ship $ */
3
4 -- Global constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_Assignment_Set_Util';
7
8 -- Procedure Clear_Dependent_Attr
9
10 PROCEDURE Clear_Dependent_Attr
11 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12 , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
13 , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
14 MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
15 , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
16 )
17 IS
18 BEGIN
19
20 -- Load out record
21
22 x_Assignment_Set_rec := p_Assignment_Set_rec;
23
24 -- If attr_id is missing compare old and new records and for
25 -- every changed attribute clear its dependent fields.
26
27 IF p_attr_id = FND_API.G_MISS_NUM THEN
28
29 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Assignment_Set_Id,p_old_Assignment_Set_rec.Assignment_Set_Id)
30 THEN
31 NULL;
32 END IF;
33
34 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Assignment_Set_Name,p_old_Assignment_Set_rec.Assignment_Set_Name)
35 THEN
36 NULL;
37 END IF;
38
39 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute1,p_old_Assignment_Set_rec.Attribute1)
40 THEN
41 NULL;
42 END IF;
43
44 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute10,p_old_Assignment_Set_rec.Attribute10)
45 THEN
46 NULL;
47 END IF;
48
49 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute11,p_old_Assignment_Set_rec.Attribute11)
50 THEN
51 NULL;
52 END IF;
53
54 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute12,p_old_Assignment_Set_rec.Attribute12)
55 THEN
56 NULL;
57 END IF;
58
59 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute13,p_old_Assignment_Set_rec.Attribute13)
60 THEN
61 NULL;
62 END IF;
63
64 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute14,p_old_Assignment_Set_rec.Attribute14)
65 THEN
66 NULL;
67 END IF;
68
69 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute15,p_old_Assignment_Set_rec.Attribute15)
70 THEN
71 NULL;
72 END IF;
73
74 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute2,p_old_Assignment_Set_rec.Attribute2)
75 THEN
76 NULL;
77 END IF;
78
79 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute3,p_old_Assignment_Set_rec.Attribute3)
80 THEN
81 NULL;
82 END IF;
83
84 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute4,p_old_Assignment_Set_rec.Attribute4)
85 THEN
86 NULL;
87 END IF;
88
89 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute5,p_old_Assignment_Set_rec.Attribute5)
90 THEN
91 NULL;
92 END IF;
93
94 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute6,p_old_Assignment_Set_rec.Attribute6)
95 THEN
96 NULL;
97 END IF;
98
99 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute7,p_old_Assignment_Set_rec.Attribute7)
100 THEN
101 NULL;
102 END IF;
103
104 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute8,p_old_Assignment_Set_rec.Attribute8)
105 THEN
106 NULL;
107 END IF;
108
109 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute9,p_old_Assignment_Set_rec.Attribute9)
110 THEN
111 NULL;
112 END IF;
113
114 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute_Category,p_old_Assignment_Set_rec.Attribute_Category)
115 THEN
116 NULL;
120 THEN
117 END IF;
118
119 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Created_By,p_old_Assignment_Set_rec.Created_By)
121 NULL;
122 END IF;
123
124 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Creation_Date,p_old_Assignment_Set_rec.Creation_Date)
125 THEN
126 NULL;
127 END IF;
128
129 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Description,p_old_Assignment_Set_rec.Description)
130 THEN
131 NULL;
132 END IF;
133
134 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Last_Updated_By,p_old_Assignment_Set_rec.Last_Updated_By)
135 THEN
136 NULL;
137 END IF;
138
139 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Last_Update_Date,p_old_Assignment_Set_rec.Last_Update_Date)
140 THEN
141 NULL;
142 END IF;
143
144 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Last_Update_Login,p_old_Assignment_Set_rec.Last_Update_Login)
145 THEN
146 NULL;
147 END IF;
148
149 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Program_Application_Id,p_old_Assignment_Set_rec.Program_Application_Id)
150 THEN
151 NULL;
152 END IF;
153
154 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Program_Id,p_old_Assignment_Set_rec.Program_Id)
155 THEN
156 NULL;
157 END IF;
158
159 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Program_Update_Date,p_old_Assignment_Set_rec.Program_Update_Date)
160 THEN
161 NULL;
162 END IF;
163
164 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Request_Id,p_old_Assignment_Set_rec.Request_Id)
165 THEN
166 NULL;
167 END IF;
168
169 ELSIF p_attr_id = G_ASSIGNMENT_SET_ID THEN
170 NULL;
174 NULL;
171 ELSIF p_attr_id = G_ASSIGNMENT_SET_NAME THEN
172 NULL;
173 ELSIF p_attr_id = G_ATTRIBUTE1 THEN
175 ELSIF p_attr_id = G_ATTRIBUTE10 THEN
176 NULL;
177 ELSIF p_attr_id = G_ATTRIBUTE11 THEN
178 NULL;
179 ELSIF p_attr_id = G_ATTRIBUTE12 THEN
180 NULL;
181 ELSIF p_attr_id = G_ATTRIBUTE13 THEN
182 NULL;
183 ELSIF p_attr_id = G_ATTRIBUTE14 THEN
184 NULL;
185 ELSIF p_attr_id = G_ATTRIBUTE15 THEN
186 NULL;
187 ELSIF p_attr_id = G_ATTRIBUTE2 THEN
188 NULL;
189 ELSIF p_attr_id = G_ATTRIBUTE3 THEN
190 NULL;
191 ELSIF p_attr_id = G_ATTRIBUTE4 THEN
192 NULL;
193 ELSIF p_attr_id = G_ATTRIBUTE5 THEN
194 NULL;
195 ELSIF p_attr_id = G_ATTRIBUTE6 THEN
196 NULL;
197 ELSIF p_attr_id = G_ATTRIBUTE7 THEN
198 NULL;
199 ELSIF p_attr_id = G_ATTRIBUTE8 THEN
200 NULL;
201 ELSIF p_attr_id = G_ATTRIBUTE9 THEN
202 NULL;
203 ELSIF p_attr_id = G_ATTRIBUTE_CATEGORY THEN
204 NULL;
205 ELSIF p_attr_id = G_CREATED_BY THEN
206 NULL;
207 ELSIF p_attr_id = G_CREATION_DATE THEN
208 NULL;
209 ELSIF p_attr_id = G_DESCRIPTION THEN
210 NULL;
211 ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
212 NULL;
213 ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
214 NULL;
215 ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
216 NULL;
220 NULL;
217 ELSIF p_attr_id = G_PROGRAM_APPLICATION_ID THEN
218 NULL;
219 ELSIF p_attr_id = G_PROGRAM_ID THEN
221 ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
222 NULL;
223 ELSIF p_attr_id = G_REQUEST_ID THEN
224 NULL;
225 END IF;
226
227 END Clear_Dependent_Attr;
228
229 -- Procedure Apply_Attribute_Changes
230
231 PROCEDURE Apply_Attribute_Changes
232 ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
233 , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
234 MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
235 , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
236 )
237 IS
238 BEGIN
239
240 -- Load out record
241
242 x_Assignment_Set_rec := p_Assignment_Set_rec;
243
244 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Assignment_Set_Id,p_old_Assignment_Set_rec.Assignment_Set_Id)
245 THEN
246 NULL;
247 END IF;
248
249 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Assignment_Set_Name,p_old_Assignment_Set_rec.Assignment_Set_Name)
250 THEN
251 NULL;
252 END IF;
253
254 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute1,p_old_Assignment_Set_rec.Attribute1)
255 THEN
256 NULL;
257 END IF;
258
259 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute10,p_old_Assignment_Set_rec.Attribute10)
260 THEN
261 NULL;
262 END IF;
263
264 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute11,p_old_Assignment_Set_rec.Attribute11)
265 THEN
266 NULL;
267 END IF;
268
269 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute12,p_old_Assignment_Set_rec.Attribute12)
270 THEN
271 NULL;
275 THEN
272 END IF;
273
274 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute13,p_old_Assignment_Set_rec.Attribute13)
276 NULL;
277 END IF;
278
279 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute14,p_old_Assignment_Set_rec.Attribute14)
280 THEN
281 NULL;
282 END IF;
283
284 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute15,p_old_Assignment_Set_rec.Attribute15)
285 THEN
286 NULL;
287 END IF;
288
289 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute2,p_old_Assignment_Set_rec.Attribute2)
290 THEN
291 NULL;
292 END IF;
293
294 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute3,p_old_Assignment_Set_rec.Attribute3)
295 THEN
296 NULL;
297 END IF;
298
299 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute4,p_old_Assignment_Set_rec.Attribute4)
300 THEN
301 NULL;
302 END IF;
303
304 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute5,p_old_Assignment_Set_rec.Attribute5)
305 THEN
306 NULL;
307 END IF;
308
309 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute6,p_old_Assignment_Set_rec.Attribute6)
310 THEN
311 NULL;
312 END IF;
313
314 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute7,p_old_Assignment_Set_rec.Attribute7)
315 THEN
316 NULL;
317 END IF;
318
319 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute8,p_old_Assignment_Set_rec.Attribute8)
320 THEN
321 NULL;
322 END IF;
323
324 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute9,p_old_Assignment_Set_rec.Attribute9)
325 THEN
326 NULL;
327 END IF;
328
329 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Attribute_Category,p_old_Assignment_Set_rec.Attribute_Category)
330 THEN
331 NULL;
332 END IF;
333
334 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Created_By,p_old_Assignment_Set_rec.Created_By)
335 THEN
336 NULL;
337 END IF;
338
339 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Creation_Date,p_old_Assignment_Set_rec.Creation_Date)
340 THEN
341 NULL;
345 THEN
342 END IF;
343
344 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Description,p_old_Assignment_Set_rec.Description)
346 NULL;
347 END IF;
348
349 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Last_Updated_By,p_old_Assignment_Set_rec.Last_Updated_By)
350 THEN
351 NULL;
352 END IF;
353
354 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Last_Update_Date,p_old_Assignment_Set_rec.Last_Update_Date)
355 THEN
356 NULL;
357 END IF;
358
359 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Last_Update_Login,p_old_Assignment_Set_rec.Last_Update_Login)
360 THEN
361 NULL;
362 END IF;
363
364 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Program_Application_Id,p_old_Assignment_Set_rec.Program_Application_Id)
365 THEN
366 NULL;
367 END IF;
368
369 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Program_Id,p_old_Assignment_Set_rec.Program_Id)
370 THEN
371 NULL;
372 END IF;
373
374 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Program_Update_Date,p_old_Assignment_Set_rec.Program_Update_Date)
375 THEN
376 NULL;
377 END IF;
378
379 IF NOT MRP_Globals.Equal(p_Assignment_Set_rec.Request_Id,p_old_Assignment_Set_rec.Request_Id)
380 THEN
381 NULL;
382 END IF;
383
384 END Apply_Attribute_Changes;
385
386 -- Function Complete_Record
387
388 FUNCTION Complete_Record
389 ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
390 , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
391 ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
392 IS
393 l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
394 BEGIN
395
396 IF l_Assignment_Set_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN
397 l_Assignment_Set_rec.Assignment_Set_Id := p_old_Assignment_Set_rec.Assignment_Set_Id;
398 END IF;
399
400 IF l_Assignment_Set_rec.Assignment_Set_Name = FND_API.G_MISS_CHAR THEN
401 l_Assignment_Set_rec.Assignment_Set_Name := p_old_Assignment_Set_rec.Assignment_Set_Name;
402 END IF;
403
404 IF l_Assignment_Set_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
405 l_Assignment_Set_rec.Attribute1 := p_old_Assignment_Set_rec.Attribute1;
406 END IF;
407
408 IF l_Assignment_Set_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
409 l_Assignment_Set_rec.Attribute10 := p_old_Assignment_Set_rec.Attribute10;
410 END IF;
411
412 IF l_Assignment_Set_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
413 l_Assignment_Set_rec.Attribute11 := p_old_Assignment_Set_rec.Attribute11;
414 END IF;
415
416 IF l_Assignment_Set_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
417 l_Assignment_Set_rec.Attribute12 := p_old_Assignment_Set_rec.Attribute12;
418 END IF;
419
420 IF l_Assignment_Set_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
421 l_Assignment_Set_rec.Attribute13 := p_old_Assignment_Set_rec.Attribute13;
422 END IF;
426 END IF;
423
424 IF l_Assignment_Set_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
425 l_Assignment_Set_rec.Attribute14 := p_old_Assignment_Set_rec.Attribute14;
427
428 IF l_Assignment_Set_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
429 l_Assignment_Set_rec.Attribute15 := p_old_Assignment_Set_rec.Attribute15;
430 END IF;
431
432 IF l_Assignment_Set_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
433 l_Assignment_Set_rec.Attribute2 := p_old_Assignment_Set_rec.Attribute2;
434 END IF;
435
436 IF l_Assignment_Set_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
437 l_Assignment_Set_rec.Attribute3 := p_old_Assignment_Set_rec.Attribute3;
438 END IF;
439
440 IF l_Assignment_Set_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
441 l_Assignment_Set_rec.Attribute4 := p_old_Assignment_Set_rec.Attribute4;
442 END IF;
443
444 IF l_Assignment_Set_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
445 l_Assignment_Set_rec.Attribute5 := p_old_Assignment_Set_rec.Attribute5;
446 END IF;
447
448 IF l_Assignment_Set_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
449 l_Assignment_Set_rec.Attribute6 := p_old_Assignment_Set_rec.Attribute6;
450 END IF;
451
452 IF l_Assignment_Set_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
453 l_Assignment_Set_rec.Attribute7 := p_old_Assignment_Set_rec.Attribute7;
454 END IF;
455
456 IF l_Assignment_Set_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
457 l_Assignment_Set_rec.Attribute8 := p_old_Assignment_Set_rec.Attribute8;
458 END IF;
459
460 IF l_Assignment_Set_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
461 l_Assignment_Set_rec.Attribute9 := p_old_Assignment_Set_rec.Attribute9;
462 END IF;
463
464 IF l_Assignment_Set_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
465 l_Assignment_Set_rec.Attribute_Category := p_old_Assignment_Set_rec.Attribute_Category;
466 END IF;
467
468 IF l_Assignment_Set_rec.Created_By = FND_API.G_MISS_NUM THEN
469 l_Assignment_Set_rec.Created_By := p_old_Assignment_Set_rec.Created_By;
470 END IF;
471
472 IF l_Assignment_Set_rec.Creation_Date = FND_API.G_MISS_DATE THEN
473 l_Assignment_Set_rec.Creation_Date := p_old_Assignment_Set_rec.Creation_Date;
474 END IF;
475
476 IF l_Assignment_Set_rec.Description = FND_API.G_MISS_CHAR THEN
477 l_Assignment_Set_rec.Description := p_old_Assignment_Set_rec.Description;
478 END IF;
479
480 IF l_Assignment_Set_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
481 l_Assignment_Set_rec.Last_Updated_By := p_old_Assignment_Set_rec.Last_Updated_By;
482 END IF;
483
484 IF l_Assignment_Set_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
485 l_Assignment_Set_rec.Last_Update_Date := p_old_Assignment_Set_rec.Last_Update_Date;
486 END IF;
487
488 IF l_Assignment_Set_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
489 l_Assignment_Set_rec.Last_Update_Login := p_old_Assignment_Set_rec.Last_Update_Login;
490 END IF;
491
492 IF l_Assignment_Set_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
493 l_Assignment_Set_rec.Program_Application_Id := p_old_Assignment_Set_rec.Program_Application_Id;
494 END IF;
495
496 IF l_Assignment_Set_rec.Program_Id = FND_API.G_MISS_NUM THEN
497 l_Assignment_Set_rec.Program_Id := p_old_Assignment_Set_rec.Program_Id;
498 END IF;
499
500 IF l_Assignment_Set_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
501 l_Assignment_Set_rec.Program_Update_Date := p_old_Assignment_Set_rec.Program_Update_Date;
502 END IF;
503
504 IF l_Assignment_Set_rec.Request_Id = FND_API.G_MISS_NUM THEN
508 RETURN l_Assignment_Set_rec;
505 l_Assignment_Set_rec.Request_Id := p_old_Assignment_Set_rec.Request_Id;
506 END IF;
507
509
510 END Complete_Record;
511
512 -- Function Convert_Miss_To_Null
513
514 FUNCTION Convert_Miss_To_Null
515 ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
516 ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
517 IS
518 l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type := p_Assignment_Set_rec;
519 BEGIN
520
521 IF l_Assignment_Set_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN
522 l_Assignment_Set_rec.Assignment_Set_Id := NULL;
523 END IF;
524
525 IF l_Assignment_Set_rec.Assignment_Set_Name = FND_API.G_MISS_CHAR THEN
526 l_Assignment_Set_rec.Assignment_Set_Name := NULL;
527 END IF;
528
529 IF l_Assignment_Set_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
530 l_Assignment_Set_rec.Attribute1 := NULL;
531 END IF;
532
533 IF l_Assignment_Set_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
534 l_Assignment_Set_rec.Attribute10 := NULL;
535 END IF;
536
537 IF l_Assignment_Set_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
538 l_Assignment_Set_rec.Attribute11 := NULL;
539 END IF;
540
541 IF l_Assignment_Set_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
542 l_Assignment_Set_rec.Attribute12 := NULL;
543 END IF;
544
545 IF l_Assignment_Set_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
546 l_Assignment_Set_rec.Attribute13 := NULL;
547 END IF;
548
549 IF l_Assignment_Set_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
550 l_Assignment_Set_rec.Attribute14 := NULL;
551 END IF;
552
553 IF l_Assignment_Set_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
554 l_Assignment_Set_rec.Attribute15 := NULL;
555 END IF;
556
557 IF l_Assignment_Set_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
558 l_Assignment_Set_rec.Attribute2 := NULL;
559 END IF;
560
561 IF l_Assignment_Set_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
562 l_Assignment_Set_rec.Attribute3 := NULL;
563 END IF;
564
565 IF l_Assignment_Set_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
566 l_Assignment_Set_rec.Attribute4 := NULL;
567 END IF;
568
569 IF l_Assignment_Set_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
570 l_Assignment_Set_rec.Attribute5 := NULL;
571 END IF;
572
573 IF l_Assignment_Set_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
574 l_Assignment_Set_rec.Attribute6 := NULL;
575 END IF;
576
577 IF l_Assignment_Set_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
578 l_Assignment_Set_rec.Attribute7 := NULL;
579 END IF;
580
581 IF l_Assignment_Set_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
582 l_Assignment_Set_rec.Attribute8 := NULL;
583 END IF;
584
585 IF l_Assignment_Set_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
586 l_Assignment_Set_rec.Attribute9 := NULL;
587 END IF;
588
589 IF l_Assignment_Set_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
590 l_Assignment_Set_rec.Attribute_Category := NULL;
591 END IF;
592
593 IF l_Assignment_Set_rec.Created_By = FND_API.G_MISS_NUM THEN
594 l_Assignment_Set_rec.Created_By := NULL;
595 END IF;
596
597 IF l_Assignment_Set_rec.Creation_Date = FND_API.G_MISS_DATE THEN
601 IF l_Assignment_Set_rec.Description = FND_API.G_MISS_CHAR THEN
598 l_Assignment_Set_rec.Creation_Date := NULL;
599 END IF;
600
602 l_Assignment_Set_rec.Description := NULL;
603 END IF;
604
605 IF l_Assignment_Set_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
606 l_Assignment_Set_rec.Last_Updated_By := NULL;
607 END IF;
608
609 IF l_Assignment_Set_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
610 l_Assignment_Set_rec.Last_Update_Date := NULL;
611 END IF;
612
613 IF l_Assignment_Set_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
614 l_Assignment_Set_rec.Last_Update_Login := NULL;
615 END IF;
616
617 IF l_Assignment_Set_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
618 l_Assignment_Set_rec.Program_Application_Id := NULL;
619 END IF;
620
621 IF l_Assignment_Set_rec.Program_Id = FND_API.G_MISS_NUM THEN
622 l_Assignment_Set_rec.Program_Id := NULL;
623 END IF;
624
625 IF l_Assignment_Set_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
626 l_Assignment_Set_rec.Program_Update_Date := NULL;
627 END IF;
628
629 IF l_Assignment_Set_rec.Request_Id = FND_API.G_MISS_NUM THEN
630 l_Assignment_Set_rec.Request_Id := NULL;
631 END IF;
632
633 RETURN l_Assignment_Set_rec;
634
635 END Convert_Miss_To_Null;
636
637 -- Function Get_Values
638
639 FUNCTION Get_Values
640 ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
641 , p_old_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type :=
642 MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_SET_REC
643 ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
644 IS
645 l_Assignment_Set_val_rec MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type;
646 BEGIN
647
648 RETURN l_Assignment_Set_val_rec;
649
650 END Get_Values;
651
652 -- Function Get_Ids
653
654 FUNCTION Get_Ids
655 ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
656 , p_Assignment_Set_val_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
657 ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
658 IS
659 l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
660 BEGIN
661
662 -- initialize return_status.
663
664 l_Assignment_Set_rec.return_status := FND_API.G_RET_STS_SUCCESS;
665
666 -- initialize l_Assignment_Set_rec.
667
668 l_Assignment_Set_rec := p_Assignment_Set_rec;
669
670
671 RETURN l_Assignment_Set_rec;
672
673 END Get_Ids;
674
675 END MRP_Assignment_Set_Util;
[Home] [Help]