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_SHIPPING_ORG_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_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
13: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
14: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
15: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_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_Shipping_Org_rec.Sr_Source_Id,p_old_Shipping_Org_rec.Sr_Source_Id)
30: THEN
31: NULL;

Line 494: IF l_Shipping_Org_rec.Sr_Source_Id = FND_API.G_MISS_NUM THEN

490: IS
491: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type := p_Shipping_Org_rec;
492: BEGIN
493:
494: IF l_Shipping_Org_rec.Sr_Source_Id = FND_API.G_MISS_NUM THEN
495: l_Shipping_Org_rec.Sr_Source_Id := p_old_Shipping_Org_rec.Sr_Source_Id;
496: END IF;
497:
498: IF l_Shipping_Org_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN

Line 498: IF l_Shipping_Org_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN

494: IF l_Shipping_Org_rec.Sr_Source_Id = FND_API.G_MISS_NUM THEN
495: l_Shipping_Org_rec.Sr_Source_Id := p_old_Shipping_Org_rec.Sr_Source_Id;
496: END IF;
497:
498: IF l_Shipping_Org_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN
499: l_Shipping_Org_rec.Allocation_Percent := p_old_Shipping_Org_rec.Allocation_Percent;
500: END IF;
501:
502: IF l_Shipping_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

Line 502: IF l_Shipping_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

498: IF l_Shipping_Org_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN
499: l_Shipping_Org_rec.Allocation_Percent := p_old_Shipping_Org_rec.Allocation_Percent;
500: END IF;
501:
502: IF l_Shipping_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
503: l_Shipping_Org_rec.Attribute1 := p_old_Shipping_Org_rec.Attribute1;
504: END IF;
505:
506: IF l_Shipping_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

Line 506: IF l_Shipping_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

502: IF l_Shipping_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
503: l_Shipping_Org_rec.Attribute1 := p_old_Shipping_Org_rec.Attribute1;
504: END IF;
505:
506: IF l_Shipping_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
507: l_Shipping_Org_rec.Attribute10 := p_old_Shipping_Org_rec.Attribute10;
508: END IF;
509:
510: IF l_Shipping_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

Line 510: IF l_Shipping_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

506: IF l_Shipping_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
507: l_Shipping_Org_rec.Attribute10 := p_old_Shipping_Org_rec.Attribute10;
508: END IF;
509:
510: IF l_Shipping_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
511: l_Shipping_Org_rec.Attribute11 := p_old_Shipping_Org_rec.Attribute11;
512: END IF;
513:
514: IF l_Shipping_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

Line 514: IF l_Shipping_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

510: IF l_Shipping_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
511: l_Shipping_Org_rec.Attribute11 := p_old_Shipping_Org_rec.Attribute11;
512: END IF;
513:
514: IF l_Shipping_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
515: l_Shipping_Org_rec.Attribute12 := p_old_Shipping_Org_rec.Attribute12;
516: END IF;
517:
518: IF l_Shipping_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

Line 518: IF l_Shipping_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

514: IF l_Shipping_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
515: l_Shipping_Org_rec.Attribute12 := p_old_Shipping_Org_rec.Attribute12;
516: END IF;
517:
518: IF l_Shipping_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
519: l_Shipping_Org_rec.Attribute13 := p_old_Shipping_Org_rec.Attribute13;
520: END IF;
521:
522: IF l_Shipping_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

Line 522: IF l_Shipping_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

518: IF l_Shipping_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
519: l_Shipping_Org_rec.Attribute13 := p_old_Shipping_Org_rec.Attribute13;
520: END IF;
521:
522: IF l_Shipping_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
523: l_Shipping_Org_rec.Attribute14 := p_old_Shipping_Org_rec.Attribute14;
524: END IF;
525:
526: IF l_Shipping_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

Line 526: IF l_Shipping_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

522: IF l_Shipping_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
523: l_Shipping_Org_rec.Attribute14 := p_old_Shipping_Org_rec.Attribute14;
524: END IF;
525:
526: IF l_Shipping_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
527: l_Shipping_Org_rec.Attribute15 := p_old_Shipping_Org_rec.Attribute15;
528: END IF;
529:
530: IF l_Shipping_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

Line 530: IF l_Shipping_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

526: IF l_Shipping_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
527: l_Shipping_Org_rec.Attribute15 := p_old_Shipping_Org_rec.Attribute15;
528: END IF;
529:
530: IF l_Shipping_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
531: l_Shipping_Org_rec.Attribute2 := p_old_Shipping_Org_rec.Attribute2;
532: END IF;
533:
534: IF l_Shipping_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

Line 534: IF l_Shipping_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

530: IF l_Shipping_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
531: l_Shipping_Org_rec.Attribute2 := p_old_Shipping_Org_rec.Attribute2;
532: END IF;
533:
534: IF l_Shipping_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
535: l_Shipping_Org_rec.Attribute3 := p_old_Shipping_Org_rec.Attribute3;
536: END IF;
537:
538: IF l_Shipping_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

Line 538: IF l_Shipping_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

534: IF l_Shipping_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
535: l_Shipping_Org_rec.Attribute3 := p_old_Shipping_Org_rec.Attribute3;
536: END IF;
537:
538: IF l_Shipping_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
539: l_Shipping_Org_rec.Attribute4 := p_old_Shipping_Org_rec.Attribute4;
540: END IF;
541:
542: IF l_Shipping_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

Line 542: IF l_Shipping_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

538: IF l_Shipping_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
539: l_Shipping_Org_rec.Attribute4 := p_old_Shipping_Org_rec.Attribute4;
540: END IF;
541:
542: IF l_Shipping_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
543: l_Shipping_Org_rec.Attribute5 := p_old_Shipping_Org_rec.Attribute5;
544: END IF;
545:
546: IF l_Shipping_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

Line 546: IF l_Shipping_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

542: IF l_Shipping_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
543: l_Shipping_Org_rec.Attribute5 := p_old_Shipping_Org_rec.Attribute5;
544: END IF;
545:
546: IF l_Shipping_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
547: l_Shipping_Org_rec.Attribute6 := p_old_Shipping_Org_rec.Attribute6;
548: END IF;
549:
550: IF l_Shipping_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

Line 550: IF l_Shipping_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

546: IF l_Shipping_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
547: l_Shipping_Org_rec.Attribute6 := p_old_Shipping_Org_rec.Attribute6;
548: END IF;
549:
550: IF l_Shipping_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
551: l_Shipping_Org_rec.Attribute7 := p_old_Shipping_Org_rec.Attribute7;
552: END IF;
553:
554: IF l_Shipping_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

Line 554: IF l_Shipping_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

550: IF l_Shipping_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
551: l_Shipping_Org_rec.Attribute7 := p_old_Shipping_Org_rec.Attribute7;
552: END IF;
553:
554: IF l_Shipping_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
555: l_Shipping_Org_rec.Attribute8 := p_old_Shipping_Org_rec.Attribute8;
556: END IF;
557:
558: IF l_Shipping_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

Line 558: IF l_Shipping_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

554: IF l_Shipping_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
555: l_Shipping_Org_rec.Attribute8 := p_old_Shipping_Org_rec.Attribute8;
556: END IF;
557:
558: IF l_Shipping_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
559: l_Shipping_Org_rec.Attribute9 := p_old_Shipping_Org_rec.Attribute9;
560: END IF;
561:
562: IF l_Shipping_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

Line 562: IF l_Shipping_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

558: IF l_Shipping_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
559: l_Shipping_Org_rec.Attribute9 := p_old_Shipping_Org_rec.Attribute9;
560: END IF;
561:
562: IF l_Shipping_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
563: l_Shipping_Org_rec.Attribute_Category := p_old_Shipping_Org_rec.Attribute_Category;
564: END IF;
565:
566: IF l_Shipping_Org_rec.Created_By = FND_API.G_MISS_NUM THEN

Line 566: IF l_Shipping_Org_rec.Created_By = FND_API.G_MISS_NUM THEN

562: IF l_Shipping_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
563: l_Shipping_Org_rec.Attribute_Category := p_old_Shipping_Org_rec.Attribute_Category;
564: END IF;
565:
566: IF l_Shipping_Org_rec.Created_By = FND_API.G_MISS_NUM THEN
567: l_Shipping_Org_rec.Created_By := p_old_Shipping_Org_rec.Created_By;
568: END IF;
569:
570: IF l_Shipping_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN

Line 570: IF l_Shipping_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN

566: IF l_Shipping_Org_rec.Created_By = FND_API.G_MISS_NUM THEN
567: l_Shipping_Org_rec.Created_By := p_old_Shipping_Org_rec.Created_By;
568: END IF;
569:
570: IF l_Shipping_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN
571: l_Shipping_Org_rec.Creation_Date := p_old_Shipping_Org_rec.Creation_Date;
572: END IF;
573:
574: IF l_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

Line 574: IF l_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

570: IF l_Shipping_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN
571: l_Shipping_Org_rec.Creation_Date := p_old_Shipping_Org_rec.Creation_Date;
572: END IF;
573:
574: IF l_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
575: l_Shipping_Org_rec.Last_Updated_By := p_old_Shipping_Org_rec.Last_Updated_By;
576: END IF;
577:
578: IF l_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

Line 578: IF l_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

574: IF l_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
575: l_Shipping_Org_rec.Last_Updated_By := p_old_Shipping_Org_rec.Last_Updated_By;
576: END IF;
577:
578: IF l_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
579: l_Shipping_Org_rec.Last_Update_Date := p_old_Shipping_Org_rec.Last_Update_Date;
580: END IF;
581:
582: IF l_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

Line 582: IF l_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

578: IF l_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
579: l_Shipping_Org_rec.Last_Update_Date := p_old_Shipping_Org_rec.Last_Update_Date;
580: END IF;
581:
582: IF l_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
583: l_Shipping_Org_rec.Last_Update_Login := p_old_Shipping_Org_rec.Last_Update_Login;
584: END IF;
585:
586: IF l_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

Line 586: IF l_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

582: IF l_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
583: l_Shipping_Org_rec.Last_Update_Login := p_old_Shipping_Org_rec.Last_Update_Login;
584: END IF;
585:
586: IF l_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
587: l_Shipping_Org_rec.Program_Application_Id := p_old_Shipping_Org_rec.Program_Application_Id;
588: END IF;
589:
590: IF l_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN

Line 590: IF l_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN

586: IF l_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
587: l_Shipping_Org_rec.Program_Application_Id := p_old_Shipping_Org_rec.Program_Application_Id;
588: END IF;
589:
590: IF l_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN
591: l_Shipping_Org_rec.Program_Id := p_old_Shipping_Org_rec.Program_Id;
592: END IF;
593:
594: IF l_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

Line 594: IF l_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

590: IF l_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN
591: l_Shipping_Org_rec.Program_Id := p_old_Shipping_Org_rec.Program_Id;
592: END IF;
593:
594: IF l_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
595: l_Shipping_Org_rec.Program_Update_Date := p_old_Shipping_Org_rec.Program_Update_Date;
596: END IF;
597:
598: IF l_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM THEN

Line 598: IF l_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM THEN

594: IF l_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
595: l_Shipping_Org_rec.Program_Update_Date := p_old_Shipping_Org_rec.Program_Update_Date;
596: END IF;
597:
598: IF l_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM THEN
599: l_Shipping_Org_rec.Rank := p_old_Shipping_Org_rec.Rank;
600: END IF;
601:
602: IF l_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN

Line 602: IF l_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN

598: IF l_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM THEN
599: l_Shipping_Org_rec.Rank := p_old_Shipping_Org_rec.Rank;
600: END IF;
601:
602: IF l_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN
603: l_Shipping_Org_rec.Request_Id := p_old_Shipping_Org_rec.Request_Id;
604: END IF;
605:
606: IF l_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN

Line 606: IF l_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN

602: IF l_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN
603: l_Shipping_Org_rec.Request_Id := p_old_Shipping_Org_rec.Request_Id;
604: END IF;
605:
606: IF l_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN
607: l_Shipping_Org_rec.Secondary_Inventory := p_old_Shipping_Org_rec.Secondary_Inventory;
608: END IF;
609:
610: IF l_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR THEN

Line 610: IF l_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR THEN

606: IF l_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN
607: l_Shipping_Org_rec.Secondary_Inventory := p_old_Shipping_Org_rec.Secondary_Inventory;
608: END IF;
609:
610: IF l_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR THEN
611: l_Shipping_Org_rec.Ship_Method := p_old_Shipping_Org_rec.Ship_Method;
612: END IF;
613:
614: IF l_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM THEN

Line 614: IF l_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM THEN

610: IF l_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR THEN
611: l_Shipping_Org_rec.Ship_Method := p_old_Shipping_Org_rec.Ship_Method;
612: END IF;
613:
614: IF l_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM THEN
615: l_Shipping_Org_rec.Source_Organization_Id := p_old_Shipping_Org_rec.Source_Organization_Id;
616: END IF;
617:
618: IF l_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM THEN

Line 618: IF l_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM THEN

614: IF l_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM THEN
615: l_Shipping_Org_rec.Source_Organization_Id := p_old_Shipping_Org_rec.Source_Organization_Id;
616: END IF;
617:
618: IF l_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM THEN
619: l_Shipping_Org_rec.Source_Type := p_old_Shipping_Org_rec.Source_Type;
620: END IF;
621:
622: IF l_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN

Line 622: IF l_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN

618: IF l_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM THEN
619: l_Shipping_Org_rec.Source_Type := p_old_Shipping_Org_rec.Source_Type;
620: END IF;
621:
622: IF l_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN
623: l_Shipping_Org_rec.Sr_Receipt_Id := p_old_Shipping_Org_rec.Sr_Receipt_Id;
624: END IF;
625:
626: IF l_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM THEN

Line 626: IF l_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM THEN

622: IF l_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN
623: l_Shipping_Org_rec.Sr_Receipt_Id := p_old_Shipping_Org_rec.Sr_Receipt_Id;
624: END IF;
625:
626: IF l_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM THEN
627: l_Shipping_Org_rec.Vendor_Id := p_old_Shipping_Org_rec.Vendor_Id;
628: END IF;
629:
630: IF l_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM THEN

Line 630: IF l_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM THEN

626: IF l_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM THEN
627: l_Shipping_Org_rec.Vendor_Id := p_old_Shipping_Org_rec.Vendor_Id;
628: END IF;
629:
630: IF l_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM THEN
631: l_Shipping_Org_rec.Vendor_Site_Id := p_old_Shipping_Org_rec.Vendor_Site_Id;
632: END IF;
633:
634: RETURN l_Shipping_Org_rec;

Line 647: IF l_Shipping_Org_rec.Sr_Source_Id = FND_API.G_MISS_NUM THEN

643: IS
644: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type := p_Shipping_Org_rec;
645: BEGIN
646:
647: IF l_Shipping_Org_rec.Sr_Source_Id = FND_API.G_MISS_NUM THEN
648: l_Shipping_Org_rec.Sr_Source_Id := NULL;
649: END IF;
650:
651: IF l_Shipping_Org_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN

Line 651: IF l_Shipping_Org_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN

647: IF l_Shipping_Org_rec.Sr_Source_Id = FND_API.G_MISS_NUM THEN
648: l_Shipping_Org_rec.Sr_Source_Id := NULL;
649: END IF;
650:
651: IF l_Shipping_Org_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN
652: l_Shipping_Org_rec.Allocation_Percent := NULL;
653: END IF;
654:
655: IF l_Shipping_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

Line 655: IF l_Shipping_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

651: IF l_Shipping_Org_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN
652: l_Shipping_Org_rec.Allocation_Percent := NULL;
653: END IF;
654:
655: IF l_Shipping_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
656: l_Shipping_Org_rec.Attribute1 := NULL;
657: END IF;
658:
659: IF l_Shipping_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

Line 659: IF l_Shipping_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

655: IF l_Shipping_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
656: l_Shipping_Org_rec.Attribute1 := NULL;
657: END IF;
658:
659: IF l_Shipping_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
660: l_Shipping_Org_rec.Attribute10 := NULL;
661: END IF;
662:
663: IF l_Shipping_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

Line 663: IF l_Shipping_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

659: IF l_Shipping_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
660: l_Shipping_Org_rec.Attribute10 := NULL;
661: END IF;
662:
663: IF l_Shipping_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
664: l_Shipping_Org_rec.Attribute11 := NULL;
665: END IF;
666:
667: IF l_Shipping_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

Line 667: IF l_Shipping_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

663: IF l_Shipping_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
664: l_Shipping_Org_rec.Attribute11 := NULL;
665: END IF;
666:
667: IF l_Shipping_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
668: l_Shipping_Org_rec.Attribute12 := NULL;
669: END IF;
670:
671: IF l_Shipping_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

Line 671: IF l_Shipping_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

667: IF l_Shipping_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
668: l_Shipping_Org_rec.Attribute12 := NULL;
669: END IF;
670:
671: IF l_Shipping_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
672: l_Shipping_Org_rec.Attribute13 := NULL;
673: END IF;
674:
675: IF l_Shipping_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

Line 675: IF l_Shipping_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

671: IF l_Shipping_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
672: l_Shipping_Org_rec.Attribute13 := NULL;
673: END IF;
674:
675: IF l_Shipping_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
676: l_Shipping_Org_rec.Attribute14 := NULL;
677: END IF;
678:
679: IF l_Shipping_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

Line 679: IF l_Shipping_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

675: IF l_Shipping_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
676: l_Shipping_Org_rec.Attribute14 := NULL;
677: END IF;
678:
679: IF l_Shipping_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
680: l_Shipping_Org_rec.Attribute15 := NULL;
681: END IF;
682:
683: IF l_Shipping_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

Line 683: IF l_Shipping_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

679: IF l_Shipping_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
680: l_Shipping_Org_rec.Attribute15 := NULL;
681: END IF;
682:
683: IF l_Shipping_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
684: l_Shipping_Org_rec.Attribute2 := NULL;
685: END IF;
686:
687: IF l_Shipping_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

Line 687: IF l_Shipping_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

683: IF l_Shipping_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
684: l_Shipping_Org_rec.Attribute2 := NULL;
685: END IF;
686:
687: IF l_Shipping_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
688: l_Shipping_Org_rec.Attribute3 := NULL;
689: END IF;
690:
691: IF l_Shipping_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

Line 691: IF l_Shipping_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

687: IF l_Shipping_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
688: l_Shipping_Org_rec.Attribute3 := NULL;
689: END IF;
690:
691: IF l_Shipping_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
692: l_Shipping_Org_rec.Attribute4 := NULL;
693: END IF;
694:
695: IF l_Shipping_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

Line 695: IF l_Shipping_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

691: IF l_Shipping_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
692: l_Shipping_Org_rec.Attribute4 := NULL;
693: END IF;
694:
695: IF l_Shipping_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
696: l_Shipping_Org_rec.Attribute5 := NULL;
697: END IF;
698:
699: IF l_Shipping_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

Line 699: IF l_Shipping_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

695: IF l_Shipping_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
696: l_Shipping_Org_rec.Attribute5 := NULL;
697: END IF;
698:
699: IF l_Shipping_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
700: l_Shipping_Org_rec.Attribute6 := NULL;
701: END IF;
702:
703: IF l_Shipping_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

Line 703: IF l_Shipping_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

699: IF l_Shipping_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
700: l_Shipping_Org_rec.Attribute6 := NULL;
701: END IF;
702:
703: IF l_Shipping_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
704: l_Shipping_Org_rec.Attribute7 := NULL;
705: END IF;
706:
707: IF l_Shipping_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

Line 707: IF l_Shipping_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

703: IF l_Shipping_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
704: l_Shipping_Org_rec.Attribute7 := NULL;
705: END IF;
706:
707: IF l_Shipping_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
708: l_Shipping_Org_rec.Attribute8 := NULL;
709: END IF;
710:
711: IF l_Shipping_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

Line 711: IF l_Shipping_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

707: IF l_Shipping_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
708: l_Shipping_Org_rec.Attribute8 := NULL;
709: END IF;
710:
711: IF l_Shipping_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
712: l_Shipping_Org_rec.Attribute9 := NULL;
713: END IF;
714:
715: IF l_Shipping_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

Line 715: IF l_Shipping_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

711: IF l_Shipping_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
712: l_Shipping_Org_rec.Attribute9 := NULL;
713: END IF;
714:
715: IF l_Shipping_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
716: l_Shipping_Org_rec.Attribute_Category := NULL;
717: END IF;
718:
719: IF l_Shipping_Org_rec.Created_By = FND_API.G_MISS_NUM THEN

Line 719: IF l_Shipping_Org_rec.Created_By = FND_API.G_MISS_NUM THEN

715: IF l_Shipping_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
716: l_Shipping_Org_rec.Attribute_Category := NULL;
717: END IF;
718:
719: IF l_Shipping_Org_rec.Created_By = FND_API.G_MISS_NUM THEN
720: l_Shipping_Org_rec.Created_By := NULL;
721: END IF;
722:
723: IF l_Shipping_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN

Line 723: IF l_Shipping_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN

719: IF l_Shipping_Org_rec.Created_By = FND_API.G_MISS_NUM THEN
720: l_Shipping_Org_rec.Created_By := NULL;
721: END IF;
722:
723: IF l_Shipping_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN
724: l_Shipping_Org_rec.Creation_Date := NULL;
725: END IF;
726:
727: IF l_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

Line 727: IF l_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

723: IF l_Shipping_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN
724: l_Shipping_Org_rec.Creation_Date := NULL;
725: END IF;
726:
727: IF l_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
728: l_Shipping_Org_rec.Last_Updated_By := NULL;
729: END IF;
730:
731: IF l_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

Line 731: IF l_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

727: IF l_Shipping_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
728: l_Shipping_Org_rec.Last_Updated_By := NULL;
729: END IF;
730:
731: IF l_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
732: l_Shipping_Org_rec.Last_Update_Date := NULL;
733: END IF;
734:
735: IF l_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

Line 735: IF l_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

731: IF l_Shipping_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
732: l_Shipping_Org_rec.Last_Update_Date := NULL;
733: END IF;
734:
735: IF l_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
736: l_Shipping_Org_rec.Last_Update_Login := NULL;
737: END IF;
738:
739: IF l_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

Line 739: IF l_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

735: IF l_Shipping_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
736: l_Shipping_Org_rec.Last_Update_Login := NULL;
737: END IF;
738:
739: IF l_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
740: l_Shipping_Org_rec.Program_Application_Id := NULL;
741: END IF;
742:
743: IF l_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN

Line 743: IF l_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN

739: IF l_Shipping_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
740: l_Shipping_Org_rec.Program_Application_Id := NULL;
741: END IF;
742:
743: IF l_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN
744: l_Shipping_Org_rec.Program_Id := NULL;
745: END IF;
746:
747: IF l_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

Line 747: IF l_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

743: IF l_Shipping_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN
744: l_Shipping_Org_rec.Program_Id := NULL;
745: END IF;
746:
747: IF l_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
748: l_Shipping_Org_rec.Program_Update_Date := NULL;
749: END IF;
750:
751: IF l_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM THEN

Line 751: IF l_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM THEN

747: IF l_Shipping_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
748: l_Shipping_Org_rec.Program_Update_Date := NULL;
749: END IF;
750:
751: IF l_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM THEN
752: l_Shipping_Org_rec.Rank := NULL;
753: END IF;
754:
755: IF l_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN

Line 755: IF l_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN

751: IF l_Shipping_Org_rec.Rank = FND_API.G_MISS_NUM THEN
752: l_Shipping_Org_rec.Rank := NULL;
753: END IF;
754:
755: IF l_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN
756: l_Shipping_Org_rec.Request_Id := NULL;
757: END IF;
758:
759: IF l_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN

Line 759: IF l_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN

755: IF l_Shipping_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN
756: l_Shipping_Org_rec.Request_Id := NULL;
757: END IF;
758:
759: IF l_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN
760: l_Shipping_Org_rec.Secondary_Inventory := NULL;
761: END IF;
762:
763: IF l_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR THEN

Line 763: IF l_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR THEN

759: IF l_Shipping_Org_rec.Secondary_Inventory = FND_API.G_MISS_CHAR THEN
760: l_Shipping_Org_rec.Secondary_Inventory := NULL;
761: END IF;
762:
763: IF l_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR THEN
764: l_Shipping_Org_rec.Ship_Method := NULL;
765: END IF;
766:
767: IF l_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM THEN

Line 767: IF l_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM THEN

763: IF l_Shipping_Org_rec.Ship_Method = FND_API.G_MISS_CHAR THEN
764: l_Shipping_Org_rec.Ship_Method := NULL;
765: END IF;
766:
767: IF l_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM THEN
768: l_Shipping_Org_rec.Source_Organization_Id := NULL;
769: END IF;
770:
771: IF l_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM THEN

Line 771: IF l_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM THEN

767: IF l_Shipping_Org_rec.Source_Organization_Id = FND_API.G_MISS_NUM THEN
768: l_Shipping_Org_rec.Source_Organization_Id := NULL;
769: END IF;
770:
771: IF l_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM THEN
772: l_Shipping_Org_rec.Source_Type := NULL;
773: END IF;
774:
775: IF l_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN

Line 775: IF l_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN

771: IF l_Shipping_Org_rec.Source_Type = FND_API.G_MISS_NUM THEN
772: l_Shipping_Org_rec.Source_Type := NULL;
773: END IF;
774:
775: IF l_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN
776: l_Shipping_Org_rec.Sr_Receipt_Id := NULL;
777: END IF;
778:
779: IF l_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM THEN

Line 779: IF l_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM THEN

775: IF l_Shipping_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN
776: l_Shipping_Org_rec.Sr_Receipt_Id := NULL;
777: END IF;
778:
779: IF l_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM THEN
780: l_Shipping_Org_rec.Vendor_Id := NULL;
781: END IF;
782:
783: IF l_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM THEN

Line 783: IF l_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM THEN

779: IF l_Shipping_Org_rec.Vendor_Id = FND_API.G_MISS_NUM THEN
780: l_Shipping_Org_rec.Vendor_Id := NULL;
781: END IF;
782:
783: IF l_Shipping_Org_rec.Vendor_Site_Id = FND_API.G_MISS_NUM THEN
784: l_Shipping_Org_rec.Vendor_Site_Id := NULL;
785: END IF;
786:
787: RETURN l_Shipping_Org_rec;

Line 818: l_Shipping_Org_rec.return_status := FND_API.G_RET_STS_SUCCESS;

814: BEGIN
815:
816: -- initialize return_status.
817:
818: l_Shipping_Org_rec.return_status := FND_API.G_RET_STS_SUCCESS;
819:
820: -- initialize l_Shipping_Org_rec.
821:
822: l_Shipping_Org_rec := p_Shipping_Org_rec;