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_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_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
13: , p_old_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type :=
14: MRP_Src_Assignment_PUB.G_MISS_ASSIGNMENT_REC
15: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_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_rec.Assignment_Id,p_old_Assignment_rec.Assignment_Id)
30: THEN
31: NULL;

Line 313: p_Assignment_rec.Organization_Id <> FND_API.G_MISS_NUM THEN

309: x_Assignment_rec.Category_Id := NULL;
310: x_Assignment_rec.Category_Set_Id := NULL;
311: ELSIF p_Assignment_rec.Assignment_Type = 4 THEN
312: IF p_Assignment_rec.Organization_Id IS NOT NULL AND
313: p_Assignment_rec.Organization_Id <> FND_API.G_MISS_NUM THEN
314: x_Assignment_rec.Customer_Id := NULL;
315: x_Assignment_rec.Ship_To_Site_Id := NULL;
316: ELSIF p_Assignment_rec.Customer_Id IS NOT NULL AND
317: p_Assignment_rec.Customer_Id <> FND_API.G_MISS_NUM THEN

Line 317: p_Assignment_rec.Customer_Id <> FND_API.G_MISS_NUM THEN

313: p_Assignment_rec.Organization_Id <> FND_API.G_MISS_NUM THEN
314: x_Assignment_rec.Customer_Id := NULL;
315: x_Assignment_rec.Ship_To_Site_Id := NULL;
316: ELSIF p_Assignment_rec.Customer_Id IS NOT NULL AND
317: p_Assignment_rec.Customer_Id <> FND_API.G_MISS_NUM THEN
318: x_Assignment_rec.Organization_Id := NULL;
319: END IF;
320: ELSIF p_Assignment_rec.Assignment_Type = 5 THEN
321: IF p_Assignment_rec.Organization_Id IS NOT NULL AND

Line 322: p_Assignment_rec.Organization_Id <> FND_API.G_MISS_NUM THEN

318: x_Assignment_rec.Organization_Id := NULL;
319: END IF;
320: ELSIF p_Assignment_rec.Assignment_Type = 5 THEN
321: IF p_Assignment_rec.Organization_Id IS NOT NULL AND
322: p_Assignment_rec.Organization_Id <> FND_API.G_MISS_NUM THEN
323: x_Assignment_rec.Customer_Id := NULL;
324: x_Assignment_rec.Ship_To_Site_Id := NULL;
325: ELSIF p_Assignment_rec.Customer_Id IS NOT NULL AND
326: p_Assignment_rec.Customer_Id <> FND_API.G_MISS_NUM THEN

Line 326: p_Assignment_rec.Customer_Id <> FND_API.G_MISS_NUM THEN

322: p_Assignment_rec.Organization_Id <> FND_API.G_MISS_NUM THEN
323: x_Assignment_rec.Customer_Id := NULL;
324: x_Assignment_rec.Ship_To_Site_Id := NULL;
325: ELSIF p_Assignment_rec.Customer_Id IS NOT NULL AND
326: p_Assignment_rec.Customer_Id <> FND_API.G_MISS_NUM THEN
327: x_Assignment_rec.Organization_Id := NULL;
328: END IF;
329: x_Assignment_rec.Inventory_Item_Id := NULL;
330: ELSIF p_Assignment_rec.Assignment_Type = 6 THEN

Line 332: p_Assignment_rec.Organization_Id <> FND_API.G_MISS_NUM THEN

328: END IF;
329: x_Assignment_rec.Inventory_Item_Id := NULL;
330: ELSIF p_Assignment_rec.Assignment_Type = 6 THEN
331: IF p_Assignment_rec.Organization_Id IS NOT NULL AND
332: p_Assignment_rec.Organization_Id <> FND_API.G_MISS_NUM THEN
333: x_Assignment_rec.Customer_Id := NULL;
334: x_Assignment_rec.Ship_To_Site_Id := NULL;
335: ELSIF p_Assignment_rec.Customer_Id IS NOT NULL AND
336: p_Assignment_rec.Customer_Id <> FND_API.G_MISS_NUM THEN

Line 336: p_Assignment_rec.Customer_Id <> FND_API.G_MISS_NUM THEN

332: p_Assignment_rec.Organization_Id <> FND_API.G_MISS_NUM THEN
333: x_Assignment_rec.Customer_Id := NULL;
334: x_Assignment_rec.Ship_To_Site_Id := NULL;
335: ELSIF p_Assignment_rec.Customer_Id IS NOT NULL AND
336: p_Assignment_rec.Customer_Id <> FND_API.G_MISS_NUM THEN
337: x_Assignment_rec.Organization_Id := NULL;
338: END IF;
339: x_Assignment_rec.Category_Id := NULL;
340: x_Assignment_rec.Category_Set_Id := NULL;

Line 557: IF l_Assignment_rec.Assignment_Id = FND_API.G_MISS_NUM THEN

553: IS
554: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type := p_Assignment_rec;
555: BEGIN
556:
557: IF l_Assignment_rec.Assignment_Id = FND_API.G_MISS_NUM THEN
558: l_Assignment_rec.Assignment_Id := p_old_Assignment_rec.Assignment_Id;
559: END IF;
560:
561: IF l_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN

Line 561: IF l_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN

557: IF l_Assignment_rec.Assignment_Id = FND_API.G_MISS_NUM THEN
558: l_Assignment_rec.Assignment_Id := p_old_Assignment_rec.Assignment_Id;
559: END IF;
560:
561: IF l_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN
562: l_Assignment_rec.Assignment_Set_Id := p_old_Assignment_rec.Assignment_Set_Id;
563: END IF;
564:
565: IF l_Assignment_rec.Assignment_Type = FND_API.G_MISS_NUM THEN

Line 565: IF l_Assignment_rec.Assignment_Type = FND_API.G_MISS_NUM THEN

561: IF l_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN
562: l_Assignment_rec.Assignment_Set_Id := p_old_Assignment_rec.Assignment_Set_Id;
563: END IF;
564:
565: IF l_Assignment_rec.Assignment_Type = FND_API.G_MISS_NUM THEN
566: l_Assignment_rec.Assignment_Type := p_old_Assignment_rec.Assignment_Type;
567: END IF;
568:
569: IF l_Assignment_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

Line 569: IF l_Assignment_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

565: IF l_Assignment_rec.Assignment_Type = FND_API.G_MISS_NUM THEN
566: l_Assignment_rec.Assignment_Type := p_old_Assignment_rec.Assignment_Type;
567: END IF;
568:
569: IF l_Assignment_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
570: l_Assignment_rec.Attribute1 := p_old_Assignment_rec.Attribute1;
571: END IF;
572:
573: IF l_Assignment_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

Line 573: IF l_Assignment_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

569: IF l_Assignment_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
570: l_Assignment_rec.Attribute1 := p_old_Assignment_rec.Attribute1;
571: END IF;
572:
573: IF l_Assignment_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
574: l_Assignment_rec.Attribute10 := p_old_Assignment_rec.Attribute10;
575: END IF;
576:
577: IF l_Assignment_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

Line 577: IF l_Assignment_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

573: IF l_Assignment_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
574: l_Assignment_rec.Attribute10 := p_old_Assignment_rec.Attribute10;
575: END IF;
576:
577: IF l_Assignment_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
578: l_Assignment_rec.Attribute11 := p_old_Assignment_rec.Attribute11;
579: END IF;
580:
581: IF l_Assignment_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

Line 581: IF l_Assignment_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

577: IF l_Assignment_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
578: l_Assignment_rec.Attribute11 := p_old_Assignment_rec.Attribute11;
579: END IF;
580:
581: IF l_Assignment_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
582: l_Assignment_rec.Attribute12 := p_old_Assignment_rec.Attribute12;
583: END IF;
584:
585: IF l_Assignment_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

Line 585: IF l_Assignment_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

581: IF l_Assignment_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
582: l_Assignment_rec.Attribute12 := p_old_Assignment_rec.Attribute12;
583: END IF;
584:
585: IF l_Assignment_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
586: l_Assignment_rec.Attribute13 := p_old_Assignment_rec.Attribute13;
587: END IF;
588:
589: IF l_Assignment_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

Line 589: IF l_Assignment_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

585: IF l_Assignment_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
586: l_Assignment_rec.Attribute13 := p_old_Assignment_rec.Attribute13;
587: END IF;
588:
589: IF l_Assignment_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
590: l_Assignment_rec.Attribute14 := p_old_Assignment_rec.Attribute14;
591: END IF;
592:
593: IF l_Assignment_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

Line 593: IF l_Assignment_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

589: IF l_Assignment_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
590: l_Assignment_rec.Attribute14 := p_old_Assignment_rec.Attribute14;
591: END IF;
592:
593: IF l_Assignment_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
594: l_Assignment_rec.Attribute15 := p_old_Assignment_rec.Attribute15;
595: END IF;
596:
597: IF l_Assignment_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

Line 597: IF l_Assignment_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

593: IF l_Assignment_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
594: l_Assignment_rec.Attribute15 := p_old_Assignment_rec.Attribute15;
595: END IF;
596:
597: IF l_Assignment_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
598: l_Assignment_rec.Attribute2 := p_old_Assignment_rec.Attribute2;
599: END IF;
600:
601: IF l_Assignment_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

Line 601: IF l_Assignment_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

597: IF l_Assignment_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
598: l_Assignment_rec.Attribute2 := p_old_Assignment_rec.Attribute2;
599: END IF;
600:
601: IF l_Assignment_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
602: l_Assignment_rec.Attribute3 := p_old_Assignment_rec.Attribute3;
603: END IF;
604:
605: IF l_Assignment_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

Line 605: IF l_Assignment_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

601: IF l_Assignment_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
602: l_Assignment_rec.Attribute3 := p_old_Assignment_rec.Attribute3;
603: END IF;
604:
605: IF l_Assignment_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
606: l_Assignment_rec.Attribute4 := p_old_Assignment_rec.Attribute4;
607: END IF;
608:
609: IF l_Assignment_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

Line 609: IF l_Assignment_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

605: IF l_Assignment_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
606: l_Assignment_rec.Attribute4 := p_old_Assignment_rec.Attribute4;
607: END IF;
608:
609: IF l_Assignment_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
610: l_Assignment_rec.Attribute5 := p_old_Assignment_rec.Attribute5;
611: END IF;
612:
613: IF l_Assignment_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

Line 613: IF l_Assignment_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

609: IF l_Assignment_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
610: l_Assignment_rec.Attribute5 := p_old_Assignment_rec.Attribute5;
611: END IF;
612:
613: IF l_Assignment_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
614: l_Assignment_rec.Attribute6 := p_old_Assignment_rec.Attribute6;
615: END IF;
616:
617: IF l_Assignment_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

Line 617: IF l_Assignment_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

613: IF l_Assignment_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
614: l_Assignment_rec.Attribute6 := p_old_Assignment_rec.Attribute6;
615: END IF;
616:
617: IF l_Assignment_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
618: l_Assignment_rec.Attribute7 := p_old_Assignment_rec.Attribute7;
619: END IF;
620:
621: IF l_Assignment_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

Line 621: IF l_Assignment_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

617: IF l_Assignment_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
618: l_Assignment_rec.Attribute7 := p_old_Assignment_rec.Attribute7;
619: END IF;
620:
621: IF l_Assignment_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
622: l_Assignment_rec.Attribute8 := p_old_Assignment_rec.Attribute8;
623: END IF;
624:
625: IF l_Assignment_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

Line 625: IF l_Assignment_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

621: IF l_Assignment_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
622: l_Assignment_rec.Attribute8 := p_old_Assignment_rec.Attribute8;
623: END IF;
624:
625: IF l_Assignment_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
626: l_Assignment_rec.Attribute9 := p_old_Assignment_rec.Attribute9;
627: END IF;
628:
629: IF l_Assignment_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

Line 629: IF l_Assignment_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

625: IF l_Assignment_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
626: l_Assignment_rec.Attribute9 := p_old_Assignment_rec.Attribute9;
627: END IF;
628:
629: IF l_Assignment_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
630: l_Assignment_rec.Attribute_Category := p_old_Assignment_rec.Attribute_Category;
631: END IF;
632:
633: IF l_Assignment_rec.Category_Id = FND_API.G_MISS_NUM THEN

Line 633: IF l_Assignment_rec.Category_Id = FND_API.G_MISS_NUM THEN

629: IF l_Assignment_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
630: l_Assignment_rec.Attribute_Category := p_old_Assignment_rec.Attribute_Category;
631: END IF;
632:
633: IF l_Assignment_rec.Category_Id = FND_API.G_MISS_NUM THEN
634: l_Assignment_rec.Category_Id := p_old_Assignment_rec.Category_Id;
635: END IF;
636:
637: IF l_Assignment_rec.Category_Set_Id = FND_API.G_MISS_NUM THEN

Line 637: IF l_Assignment_rec.Category_Set_Id = FND_API.G_MISS_NUM THEN

633: IF l_Assignment_rec.Category_Id = FND_API.G_MISS_NUM THEN
634: l_Assignment_rec.Category_Id := p_old_Assignment_rec.Category_Id;
635: END IF;
636:
637: IF l_Assignment_rec.Category_Set_Id = FND_API.G_MISS_NUM THEN
638: l_Assignment_rec.Category_Set_Id := p_old_Assignment_rec.Category_Set_Id;
639: END IF;
640:
641: IF l_Assignment_rec.Created_By = FND_API.G_MISS_NUM THEN

Line 641: IF l_Assignment_rec.Created_By = FND_API.G_MISS_NUM THEN

637: IF l_Assignment_rec.Category_Set_Id = FND_API.G_MISS_NUM THEN
638: l_Assignment_rec.Category_Set_Id := p_old_Assignment_rec.Category_Set_Id;
639: END IF;
640:
641: IF l_Assignment_rec.Created_By = FND_API.G_MISS_NUM THEN
642: l_Assignment_rec.Created_By := p_old_Assignment_rec.Created_By;
643: END IF;
644:
645: IF l_Assignment_rec.Creation_Date = FND_API.G_MISS_DATE THEN

Line 645: IF l_Assignment_rec.Creation_Date = FND_API.G_MISS_DATE THEN

641: IF l_Assignment_rec.Created_By = FND_API.G_MISS_NUM THEN
642: l_Assignment_rec.Created_By := p_old_Assignment_rec.Created_By;
643: END IF;
644:
645: IF l_Assignment_rec.Creation_Date = FND_API.G_MISS_DATE THEN
646: l_Assignment_rec.Creation_Date := p_old_Assignment_rec.Creation_Date;
647: END IF;
648:
649: IF l_Assignment_rec.Customer_Id = FND_API.G_MISS_NUM THEN

Line 649: IF l_Assignment_rec.Customer_Id = FND_API.G_MISS_NUM THEN

645: IF l_Assignment_rec.Creation_Date = FND_API.G_MISS_DATE THEN
646: l_Assignment_rec.Creation_Date := p_old_Assignment_rec.Creation_Date;
647: END IF;
648:
649: IF l_Assignment_rec.Customer_Id = FND_API.G_MISS_NUM THEN
650: l_Assignment_rec.Customer_Id := p_old_Assignment_rec.Customer_Id;
651: END IF;
652:
653: IF l_Assignment_rec.Inventory_Item_Id = FND_API.G_MISS_NUM THEN

Line 653: IF l_Assignment_rec.Inventory_Item_Id = FND_API.G_MISS_NUM THEN

649: IF l_Assignment_rec.Customer_Id = FND_API.G_MISS_NUM THEN
650: l_Assignment_rec.Customer_Id := p_old_Assignment_rec.Customer_Id;
651: END IF;
652:
653: IF l_Assignment_rec.Inventory_Item_Id = FND_API.G_MISS_NUM THEN
654: l_Assignment_rec.Inventory_Item_Id := p_old_Assignment_rec.Inventory_Item_Id;
655: END IF;
656:
657: IF l_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

Line 657: IF l_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

653: IF l_Assignment_rec.Inventory_Item_Id = FND_API.G_MISS_NUM THEN
654: l_Assignment_rec.Inventory_Item_Id := p_old_Assignment_rec.Inventory_Item_Id;
655: END IF;
656:
657: IF l_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
658: l_Assignment_rec.Last_Updated_By := p_old_Assignment_rec.Last_Updated_By;
659: END IF;
660:
661: IF l_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

Line 661: IF l_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

657: IF l_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
658: l_Assignment_rec.Last_Updated_By := p_old_Assignment_rec.Last_Updated_By;
659: END IF;
660:
661: IF l_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
662: l_Assignment_rec.Last_Update_Date := p_old_Assignment_rec.Last_Update_Date;
663: END IF;
664:
665: IF l_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

Line 665: IF l_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

661: IF l_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
662: l_Assignment_rec.Last_Update_Date := p_old_Assignment_rec.Last_Update_Date;
663: END IF;
664:
665: IF l_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
666: l_Assignment_rec.Last_Update_Login := p_old_Assignment_rec.Last_Update_Login;
667: END IF;
668:
669: IF l_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM THEN

Line 669: IF l_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM THEN

665: IF l_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
666: l_Assignment_rec.Last_Update_Login := p_old_Assignment_rec.Last_Update_Login;
667: END IF;
668:
669: IF l_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM THEN
670: l_Assignment_rec.Organization_Id := p_old_Assignment_rec.Organization_Id;
671: END IF;
672:
673: IF l_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

Line 673: IF l_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

669: IF l_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM THEN
670: l_Assignment_rec.Organization_Id := p_old_Assignment_rec.Organization_Id;
671: END IF;
672:
673: IF l_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
674: l_Assignment_rec.Program_Application_Id := p_old_Assignment_rec.Program_Application_Id;
675: END IF;
676:
677: IF l_Assignment_rec.Program_Id = FND_API.G_MISS_NUM THEN

Line 677: IF l_Assignment_rec.Program_Id = FND_API.G_MISS_NUM THEN

673: IF l_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
674: l_Assignment_rec.Program_Application_Id := p_old_Assignment_rec.Program_Application_Id;
675: END IF;
676:
677: IF l_Assignment_rec.Program_Id = FND_API.G_MISS_NUM THEN
678: l_Assignment_rec.Program_Id := p_old_Assignment_rec.Program_Id;
679: END IF;
680:
681: IF l_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

Line 681: IF l_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

677: IF l_Assignment_rec.Program_Id = FND_API.G_MISS_NUM THEN
678: l_Assignment_rec.Program_Id := p_old_Assignment_rec.Program_Id;
679: END IF;
680:
681: IF l_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
682: l_Assignment_rec.Program_Update_Date := p_old_Assignment_rec.Program_Update_Date;
683: END IF;
684:
685: IF l_Assignment_rec.Request_Id = FND_API.G_MISS_NUM THEN

Line 685: IF l_Assignment_rec.Request_Id = FND_API.G_MISS_NUM THEN

681: IF l_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
682: l_Assignment_rec.Program_Update_Date := p_old_Assignment_rec.Program_Update_Date;
683: END IF;
684:
685: IF l_Assignment_rec.Request_Id = FND_API.G_MISS_NUM THEN
686: l_Assignment_rec.Request_Id := p_old_Assignment_rec.Request_Id;
687: END IF;
688:
689: IF l_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN

Line 689: IF l_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN

685: IF l_Assignment_rec.Request_Id = FND_API.G_MISS_NUM THEN
686: l_Assignment_rec.Request_Id := p_old_Assignment_rec.Request_Id;
687: END IF;
688:
689: IF l_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN
690: l_Assignment_rec.Secondary_Inventory := p_old_Assignment_rec.Secondary_Inventory;
691: END IF;
692:
693: IF l_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM THEN

Line 693: IF l_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM THEN

689: IF l_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN
690: l_Assignment_rec.Secondary_Inventory := p_old_Assignment_rec.Secondary_Inventory;
691: END IF;
692:
693: IF l_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM THEN
694: l_Assignment_rec.Ship_To_Site_Id := p_old_Assignment_rec.Ship_To_Site_Id;
695: END IF;
696:
697: IF l_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN

Line 697: IF l_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN

693: IF l_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM THEN
694: l_Assignment_rec.Ship_To_Site_Id := p_old_Assignment_rec.Ship_To_Site_Id;
695: END IF;
696:
697: IF l_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
698: l_Assignment_rec.Sourcing_Rule_Id := p_old_Assignment_rec.Sourcing_Rule_Id;
699: END IF;
700:
701: IF l_Assignment_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN

Line 701: IF l_Assignment_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN

697: IF l_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
698: l_Assignment_rec.Sourcing_Rule_Id := p_old_Assignment_rec.Sourcing_Rule_Id;
699: END IF;
700:
701: IF l_Assignment_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN
702: l_Assignment_rec.Sourcing_Rule_Type := p_old_Assignment_rec.Sourcing_Rule_Type;
703: END IF;
704:
705: RETURN l_Assignment_rec;

Line 718: IF l_Assignment_rec.Assignment_Id = FND_API.G_MISS_NUM THEN

714: IS
715: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type := p_Assignment_rec;
716: BEGIN
717:
718: IF l_Assignment_rec.Assignment_Id = FND_API.G_MISS_NUM THEN
719: l_Assignment_rec.Assignment_Id := NULL;
720: END IF;
721:
722: IF l_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN

Line 722: IF l_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN

718: IF l_Assignment_rec.Assignment_Id = FND_API.G_MISS_NUM THEN
719: l_Assignment_rec.Assignment_Id := NULL;
720: END IF;
721:
722: IF l_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN
723: l_Assignment_rec.Assignment_Set_Id := NULL;
724: END IF;
725:
726: IF l_Assignment_rec.Assignment_Type = FND_API.G_MISS_NUM THEN

Line 726: IF l_Assignment_rec.Assignment_Type = FND_API.G_MISS_NUM THEN

722: IF l_Assignment_rec.Assignment_Set_Id = FND_API.G_MISS_NUM THEN
723: l_Assignment_rec.Assignment_Set_Id := NULL;
724: END IF;
725:
726: IF l_Assignment_rec.Assignment_Type = FND_API.G_MISS_NUM THEN
727: l_Assignment_rec.Assignment_Type := NULL;
728: END IF;
729:
730: IF l_Assignment_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

Line 730: IF l_Assignment_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

726: IF l_Assignment_rec.Assignment_Type = FND_API.G_MISS_NUM THEN
727: l_Assignment_rec.Assignment_Type := NULL;
728: END IF;
729:
730: IF l_Assignment_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
731: l_Assignment_rec.Attribute1 := NULL;
732: END IF;
733:
734: IF l_Assignment_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

Line 734: IF l_Assignment_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

730: IF l_Assignment_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
731: l_Assignment_rec.Attribute1 := NULL;
732: END IF;
733:
734: IF l_Assignment_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
735: l_Assignment_rec.Attribute10 := NULL;
736: END IF;
737:
738: IF l_Assignment_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

Line 738: IF l_Assignment_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

734: IF l_Assignment_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
735: l_Assignment_rec.Attribute10 := NULL;
736: END IF;
737:
738: IF l_Assignment_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
739: l_Assignment_rec.Attribute11 := NULL;
740: END IF;
741:
742: IF l_Assignment_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

Line 742: IF l_Assignment_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

738: IF l_Assignment_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
739: l_Assignment_rec.Attribute11 := NULL;
740: END IF;
741:
742: IF l_Assignment_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
743: l_Assignment_rec.Attribute12 := NULL;
744: END IF;
745:
746: IF l_Assignment_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

Line 746: IF l_Assignment_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

742: IF l_Assignment_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
743: l_Assignment_rec.Attribute12 := NULL;
744: END IF;
745:
746: IF l_Assignment_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
747: l_Assignment_rec.Attribute13 := NULL;
748: END IF;
749:
750: IF l_Assignment_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

Line 750: IF l_Assignment_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

746: IF l_Assignment_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
747: l_Assignment_rec.Attribute13 := NULL;
748: END IF;
749:
750: IF l_Assignment_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
751: l_Assignment_rec.Attribute14 := NULL;
752: END IF;
753:
754: IF l_Assignment_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

Line 754: IF l_Assignment_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

750: IF l_Assignment_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
751: l_Assignment_rec.Attribute14 := NULL;
752: END IF;
753:
754: IF l_Assignment_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
755: l_Assignment_rec.Attribute15 := NULL;
756: END IF;
757:
758: IF l_Assignment_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

Line 758: IF l_Assignment_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

754: IF l_Assignment_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
755: l_Assignment_rec.Attribute15 := NULL;
756: END IF;
757:
758: IF l_Assignment_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
759: l_Assignment_rec.Attribute2 := NULL;
760: END IF;
761:
762: IF l_Assignment_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

Line 762: IF l_Assignment_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

758: IF l_Assignment_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
759: l_Assignment_rec.Attribute2 := NULL;
760: END IF;
761:
762: IF l_Assignment_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
763: l_Assignment_rec.Attribute3 := NULL;
764: END IF;
765:
766: IF l_Assignment_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

Line 766: IF l_Assignment_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

762: IF l_Assignment_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
763: l_Assignment_rec.Attribute3 := NULL;
764: END IF;
765:
766: IF l_Assignment_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
767: l_Assignment_rec.Attribute4 := NULL;
768: END IF;
769:
770: IF l_Assignment_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

Line 770: IF l_Assignment_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

766: IF l_Assignment_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
767: l_Assignment_rec.Attribute4 := NULL;
768: END IF;
769:
770: IF l_Assignment_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
771: l_Assignment_rec.Attribute5 := NULL;
772: END IF;
773:
774: IF l_Assignment_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

Line 774: IF l_Assignment_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

770: IF l_Assignment_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
771: l_Assignment_rec.Attribute5 := NULL;
772: END IF;
773:
774: IF l_Assignment_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
775: l_Assignment_rec.Attribute6 := NULL;
776: END IF;
777:
778: IF l_Assignment_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

Line 778: IF l_Assignment_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

774: IF l_Assignment_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
775: l_Assignment_rec.Attribute6 := NULL;
776: END IF;
777:
778: IF l_Assignment_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
779: l_Assignment_rec.Attribute7 := NULL;
780: END IF;
781:
782: IF l_Assignment_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

Line 782: IF l_Assignment_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

778: IF l_Assignment_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
779: l_Assignment_rec.Attribute7 := NULL;
780: END IF;
781:
782: IF l_Assignment_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
783: l_Assignment_rec.Attribute8 := NULL;
784: END IF;
785:
786: IF l_Assignment_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

Line 786: IF l_Assignment_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

782: IF l_Assignment_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
783: l_Assignment_rec.Attribute8 := NULL;
784: END IF;
785:
786: IF l_Assignment_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
787: l_Assignment_rec.Attribute9 := NULL;
788: END IF;
789:
790: IF l_Assignment_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

Line 790: IF l_Assignment_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

786: IF l_Assignment_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
787: l_Assignment_rec.Attribute9 := NULL;
788: END IF;
789:
790: IF l_Assignment_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
791: l_Assignment_rec.Attribute_Category := NULL;
792: END IF;
793:
794: IF l_Assignment_rec.Category_Id = FND_API.G_MISS_NUM THEN

Line 794: IF l_Assignment_rec.Category_Id = FND_API.G_MISS_NUM THEN

790: IF l_Assignment_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
791: l_Assignment_rec.Attribute_Category := NULL;
792: END IF;
793:
794: IF l_Assignment_rec.Category_Id = FND_API.G_MISS_NUM THEN
795: l_Assignment_rec.Category_Id := NULL;
796: END IF;
797:
798: IF l_Assignment_rec.Category_Set_Id = FND_API.G_MISS_NUM THEN

Line 798: IF l_Assignment_rec.Category_Set_Id = FND_API.G_MISS_NUM THEN

794: IF l_Assignment_rec.Category_Id = FND_API.G_MISS_NUM THEN
795: l_Assignment_rec.Category_Id := NULL;
796: END IF;
797:
798: IF l_Assignment_rec.Category_Set_Id = FND_API.G_MISS_NUM THEN
799: l_Assignment_rec.Category_Set_Id := NULL;
800: END IF;
801:
802: IF l_Assignment_rec.Created_By = FND_API.G_MISS_NUM THEN

Line 802: IF l_Assignment_rec.Created_By = FND_API.G_MISS_NUM THEN

798: IF l_Assignment_rec.Category_Set_Id = FND_API.G_MISS_NUM THEN
799: l_Assignment_rec.Category_Set_Id := NULL;
800: END IF;
801:
802: IF l_Assignment_rec.Created_By = FND_API.G_MISS_NUM THEN
803: l_Assignment_rec.Created_By := NULL;
804: END IF;
805:
806: IF l_Assignment_rec.Creation_Date = FND_API.G_MISS_DATE THEN

Line 806: IF l_Assignment_rec.Creation_Date = FND_API.G_MISS_DATE THEN

802: IF l_Assignment_rec.Created_By = FND_API.G_MISS_NUM THEN
803: l_Assignment_rec.Created_By := NULL;
804: END IF;
805:
806: IF l_Assignment_rec.Creation_Date = FND_API.G_MISS_DATE THEN
807: l_Assignment_rec.Creation_Date := NULL;
808: END IF;
809:
810: IF l_Assignment_rec.Customer_Id = FND_API.G_MISS_NUM THEN

Line 810: IF l_Assignment_rec.Customer_Id = FND_API.G_MISS_NUM THEN

806: IF l_Assignment_rec.Creation_Date = FND_API.G_MISS_DATE THEN
807: l_Assignment_rec.Creation_Date := NULL;
808: END IF;
809:
810: IF l_Assignment_rec.Customer_Id = FND_API.G_MISS_NUM THEN
811: l_Assignment_rec.Customer_Id := NULL;
812: END IF;
813:
814: IF l_Assignment_rec.Inventory_Item_Id = FND_API.G_MISS_NUM THEN

Line 814: IF l_Assignment_rec.Inventory_Item_Id = FND_API.G_MISS_NUM THEN

810: IF l_Assignment_rec.Customer_Id = FND_API.G_MISS_NUM THEN
811: l_Assignment_rec.Customer_Id := NULL;
812: END IF;
813:
814: IF l_Assignment_rec.Inventory_Item_Id = FND_API.G_MISS_NUM THEN
815: l_Assignment_rec.Inventory_Item_Id := NULL;
816: END IF;
817:
818: IF l_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

Line 818: IF l_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

814: IF l_Assignment_rec.Inventory_Item_Id = FND_API.G_MISS_NUM THEN
815: l_Assignment_rec.Inventory_Item_Id := NULL;
816: END IF;
817:
818: IF l_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
819: l_Assignment_rec.Last_Updated_By := NULL;
820: END IF;
821:
822: IF l_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

Line 822: IF l_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

818: IF l_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
819: l_Assignment_rec.Last_Updated_By := NULL;
820: END IF;
821:
822: IF l_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
823: l_Assignment_rec.Last_Update_Date := NULL;
824: END IF;
825:
826: IF l_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

Line 826: IF l_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

822: IF l_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
823: l_Assignment_rec.Last_Update_Date := NULL;
824: END IF;
825:
826: IF l_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
827: l_Assignment_rec.Last_Update_Login := NULL;
828: END IF;
829:
830: IF l_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM THEN

Line 830: IF l_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM THEN

826: IF l_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
827: l_Assignment_rec.Last_Update_Login := NULL;
828: END IF;
829:
830: IF l_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM THEN
831: l_Assignment_rec.Organization_Id := NULL;
832: END IF;
833:
834: IF l_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

Line 834: IF l_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

830: IF l_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM THEN
831: l_Assignment_rec.Organization_Id := NULL;
832: END IF;
833:
834: IF l_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
835: l_Assignment_rec.Program_Application_Id := NULL;
836: END IF;
837:
838: IF l_Assignment_rec.Program_Id = FND_API.G_MISS_NUM THEN

Line 838: IF l_Assignment_rec.Program_Id = FND_API.G_MISS_NUM THEN

834: IF l_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
835: l_Assignment_rec.Program_Application_Id := NULL;
836: END IF;
837:
838: IF l_Assignment_rec.Program_Id = FND_API.G_MISS_NUM THEN
839: l_Assignment_rec.Program_Id := NULL;
840: END IF;
841:
842: IF l_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

Line 842: IF l_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

838: IF l_Assignment_rec.Program_Id = FND_API.G_MISS_NUM THEN
839: l_Assignment_rec.Program_Id := NULL;
840: END IF;
841:
842: IF l_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
843: l_Assignment_rec.Program_Update_Date := NULL;
844: END IF;
845:
846: IF l_Assignment_rec.Request_Id = FND_API.G_MISS_NUM THEN

Line 846: IF l_Assignment_rec.Request_Id = FND_API.G_MISS_NUM THEN

842: IF l_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
843: l_Assignment_rec.Program_Update_Date := NULL;
844: END IF;
845:
846: IF l_Assignment_rec.Request_Id = FND_API.G_MISS_NUM THEN
847: l_Assignment_rec.Request_Id := NULL;
848: END IF;
849:
850: IF l_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN

Line 850: IF l_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN

846: IF l_Assignment_rec.Request_Id = FND_API.G_MISS_NUM THEN
847: l_Assignment_rec.Request_Id := NULL;
848: END IF;
849:
850: IF l_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN
851: l_Assignment_rec.Secondary_Inventory := NULL;
852: END IF;
853:
854: IF l_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM THEN

Line 854: IF l_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM THEN

850: IF l_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN
851: l_Assignment_rec.Secondary_Inventory := NULL;
852: END IF;
853:
854: IF l_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM THEN
855: l_Assignment_rec.Ship_To_Site_Id := NULL;
856: END IF;
857:
858: IF l_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN

Line 858: IF l_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN

854: IF l_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM THEN
855: l_Assignment_rec.Ship_To_Site_Id := NULL;
856: END IF;
857:
858: IF l_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
859: l_Assignment_rec.Sourcing_Rule_Id := NULL;
860: END IF;
861:
862: IF l_Assignment_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN

Line 862: IF l_Assignment_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN

858: IF l_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
859: l_Assignment_rec.Sourcing_Rule_Id := NULL;
860: END IF;
861:
862: IF l_Assignment_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN
863: l_Assignment_rec.Sourcing_Rule_Type := NULL;
864: END IF;
865:
866: RETURN l_Assignment_rec;

Line 897: l_Assignment_rec.return_status := FND_API.G_RET_STS_SUCCESS;

893: BEGIN
894:
895: -- initialize return_status.
896:
897: l_Assignment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
898:
899: -- initialize l_Assignment_rec.
900:
901: l_Assignment_rec := p_Assignment_rec;