eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_ASSIGNMENT_SET_UTIL dependencies on FND_API

Line 11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 27: IF p_attr_id = FND_API.G_MISS_NUM THEN

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;

Line 396: IF l_Assignment_Set_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN

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

Line 400: IF l_Assignment_Set_rec.Assignment_Set_Name = FND_API.G_MISS_CHAR THEN

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

Line 404: IF l_Assignment_Set_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

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

Line 408: IF l_Assignment_Set_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

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

Line 412: IF l_Assignment_Set_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

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

Line 416: IF l_Assignment_Set_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

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

Line 420: IF l_Assignment_Set_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

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;
423:
424: IF l_Assignment_Set_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

Line 424: IF l_Assignment_Set_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

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;
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;
426: END IF;
427:
428: IF l_Assignment_Set_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

Line 428: IF l_Assignment_Set_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

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;
426: END IF;
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

Line 432: IF l_Assignment_Set_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

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

Line 436: IF l_Assignment_Set_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

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

Line 440: IF l_Assignment_Set_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

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

Line 444: IF l_Assignment_Set_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

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

Line 448: IF l_Assignment_Set_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

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

Line 452: IF l_Assignment_Set_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

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

Line 456: IF l_Assignment_Set_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

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

Line 460: IF l_Assignment_Set_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

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

Line 464: IF l_Assignment_Set_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

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

Line 468: IF l_Assignment_Set_rec.Created_By = FND_API.G_MISS_NUM THEN

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

Line 472: IF l_Assignment_Set_rec.Creation_Date = FND_API.G_MISS_DATE THEN

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

Line 476: IF l_Assignment_Set_rec.Description = FND_API.G_MISS_CHAR THEN

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

Line 480: IF l_Assignment_Set_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

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

Line 484: IF l_Assignment_Set_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

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

Line 488: IF l_Assignment_Set_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

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

Line 492: IF l_Assignment_Set_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

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

Line 496: IF l_Assignment_Set_rec.Program_Id = FND_API.G_MISS_NUM THEN

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

Line 500: IF l_Assignment_Set_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

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

Line 504: IF l_Assignment_Set_rec.Request_Id = FND_API.G_MISS_NUM THEN

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
505: l_Assignment_Set_rec.Request_Id := p_old_Assignment_Set_rec.Request_Id;
506: END IF;
507:
508: RETURN l_Assignment_Set_rec;

Line 521: IF l_Assignment_Set_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN

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

Line 525: IF l_Assignment_Set_rec.Assignment_Set_Name = FND_API.G_MISS_CHAR THEN

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

Line 529: IF l_Assignment_Set_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

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

Line 533: IF l_Assignment_Set_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

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

Line 537: IF l_Assignment_Set_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

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

Line 541: IF l_Assignment_Set_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

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

Line 545: IF l_Assignment_Set_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

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

Line 549: IF l_Assignment_Set_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

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

Line 553: IF l_Assignment_Set_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

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

Line 557: IF l_Assignment_Set_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

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

Line 561: IF l_Assignment_Set_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

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

Line 565: IF l_Assignment_Set_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

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

Line 569: IF l_Assignment_Set_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

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

Line 573: IF l_Assignment_Set_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

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

Line 577: IF l_Assignment_Set_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

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

Line 581: IF l_Assignment_Set_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

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

Line 585: IF l_Assignment_Set_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

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

Line 589: IF l_Assignment_Set_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

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

Line 593: IF l_Assignment_Set_rec.Created_By = FND_API.G_MISS_NUM THEN

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

Line 597: IF l_Assignment_Set_rec.Creation_Date = FND_API.G_MISS_DATE THEN

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
598: l_Assignment_Set_rec.Creation_Date := NULL;
599: END IF;
600:
601: IF l_Assignment_Set_rec.Description = FND_API.G_MISS_CHAR THEN

Line 601: IF l_Assignment_Set_rec.Description = FND_API.G_MISS_CHAR THEN

597: IF l_Assignment_Set_rec.Creation_Date = FND_API.G_MISS_DATE THEN
598: l_Assignment_Set_rec.Creation_Date := NULL;
599: END IF;
600:
601: IF l_Assignment_Set_rec.Description = FND_API.G_MISS_CHAR THEN
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

Line 605: IF l_Assignment_Set_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

601: IF l_Assignment_Set_rec.Description = FND_API.G_MISS_CHAR THEN
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

Line 609: IF l_Assignment_Set_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

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

Line 613: IF l_Assignment_Set_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

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

Line 617: IF l_Assignment_Set_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

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

Line 621: IF l_Assignment_Set_rec.Program_Id = FND_API.G_MISS_NUM THEN

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

Line 625: IF l_Assignment_Set_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

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

Line 629: IF l_Assignment_Set_rec.Request_Id = FND_API.G_MISS_NUM THEN

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;

Line 664: l_Assignment_Set_rec.return_status := FND_API.G_RET_STS_SUCCESS;

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;