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.

[Home] [Help]

APPS.MRP_SOURCING_RULE_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_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
13: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
14: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
15: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_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_Sourcing_Rule_rec.Sourcing_Rule_Id,p_old_Sourcing_Rule_rec.Sourcing_Rule_Id)
30: THEN
31: NULL;

Line 444: IF l_Sourcing_Rule_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN

440: IS
441: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;
442: BEGIN
443:
444: IF l_Sourcing_Rule_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
445: l_Sourcing_Rule_rec.Sourcing_Rule_Id := p_old_Sourcing_Rule_rec.Sourcing_Rule_Id;
446: END IF;
447:
448: IF l_Sourcing_Rule_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

Line 448: IF l_Sourcing_Rule_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

444: IF l_Sourcing_Rule_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
445: l_Sourcing_Rule_rec.Sourcing_Rule_Id := p_old_Sourcing_Rule_rec.Sourcing_Rule_Id;
446: END IF;
447:
448: IF l_Sourcing_Rule_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
449: l_Sourcing_Rule_rec.Attribute1 := p_old_Sourcing_Rule_rec.Attribute1;
450: END IF;
451:
452: IF l_Sourcing_Rule_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

Line 452: IF l_Sourcing_Rule_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

448: IF l_Sourcing_Rule_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
449: l_Sourcing_Rule_rec.Attribute1 := p_old_Sourcing_Rule_rec.Attribute1;
450: END IF;
451:
452: IF l_Sourcing_Rule_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
453: l_Sourcing_Rule_rec.Attribute10 := p_old_Sourcing_Rule_rec.Attribute10;
454: END IF;
455:
456: IF l_Sourcing_Rule_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

Line 456: IF l_Sourcing_Rule_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

452: IF l_Sourcing_Rule_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
453: l_Sourcing_Rule_rec.Attribute10 := p_old_Sourcing_Rule_rec.Attribute10;
454: END IF;
455:
456: IF l_Sourcing_Rule_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
457: l_Sourcing_Rule_rec.Attribute11 := p_old_Sourcing_Rule_rec.Attribute11;
458: END IF;
459:
460: IF l_Sourcing_Rule_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

Line 460: IF l_Sourcing_Rule_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

456: IF l_Sourcing_Rule_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
457: l_Sourcing_Rule_rec.Attribute11 := p_old_Sourcing_Rule_rec.Attribute11;
458: END IF;
459:
460: IF l_Sourcing_Rule_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
461: l_Sourcing_Rule_rec.Attribute12 := p_old_Sourcing_Rule_rec.Attribute12;
462: END IF;
463:
464: IF l_Sourcing_Rule_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

Line 464: IF l_Sourcing_Rule_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

460: IF l_Sourcing_Rule_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
461: l_Sourcing_Rule_rec.Attribute12 := p_old_Sourcing_Rule_rec.Attribute12;
462: END IF;
463:
464: IF l_Sourcing_Rule_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
465: l_Sourcing_Rule_rec.Attribute13 := p_old_Sourcing_Rule_rec.Attribute13;
466: END IF;
467:
468: IF l_Sourcing_Rule_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

Line 468: IF l_Sourcing_Rule_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

464: IF l_Sourcing_Rule_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
465: l_Sourcing_Rule_rec.Attribute13 := p_old_Sourcing_Rule_rec.Attribute13;
466: END IF;
467:
468: IF l_Sourcing_Rule_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
469: l_Sourcing_Rule_rec.Attribute14 := p_old_Sourcing_Rule_rec.Attribute14;
470: END IF;
471:
472: IF l_Sourcing_Rule_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

Line 472: IF l_Sourcing_Rule_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

468: IF l_Sourcing_Rule_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
469: l_Sourcing_Rule_rec.Attribute14 := p_old_Sourcing_Rule_rec.Attribute14;
470: END IF;
471:
472: IF l_Sourcing_Rule_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
473: l_Sourcing_Rule_rec.Attribute15 := p_old_Sourcing_Rule_rec.Attribute15;
474: END IF;
475:
476: IF l_Sourcing_Rule_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

Line 476: IF l_Sourcing_Rule_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

472: IF l_Sourcing_Rule_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
473: l_Sourcing_Rule_rec.Attribute15 := p_old_Sourcing_Rule_rec.Attribute15;
474: END IF;
475:
476: IF l_Sourcing_Rule_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
477: l_Sourcing_Rule_rec.Attribute2 := p_old_Sourcing_Rule_rec.Attribute2;
478: END IF;
479:
480: IF l_Sourcing_Rule_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

Line 480: IF l_Sourcing_Rule_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

476: IF l_Sourcing_Rule_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
477: l_Sourcing_Rule_rec.Attribute2 := p_old_Sourcing_Rule_rec.Attribute2;
478: END IF;
479:
480: IF l_Sourcing_Rule_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
481: l_Sourcing_Rule_rec.Attribute3 := p_old_Sourcing_Rule_rec.Attribute3;
482: END IF;
483:
484: IF l_Sourcing_Rule_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

Line 484: IF l_Sourcing_Rule_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

480: IF l_Sourcing_Rule_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
481: l_Sourcing_Rule_rec.Attribute3 := p_old_Sourcing_Rule_rec.Attribute3;
482: END IF;
483:
484: IF l_Sourcing_Rule_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
485: l_Sourcing_Rule_rec.Attribute4 := p_old_Sourcing_Rule_rec.Attribute4;
486: END IF;
487:
488: IF l_Sourcing_Rule_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

Line 488: IF l_Sourcing_Rule_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

484: IF l_Sourcing_Rule_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
485: l_Sourcing_Rule_rec.Attribute4 := p_old_Sourcing_Rule_rec.Attribute4;
486: END IF;
487:
488: IF l_Sourcing_Rule_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
489: l_Sourcing_Rule_rec.Attribute5 := p_old_Sourcing_Rule_rec.Attribute5;
490: END IF;
491:
492: IF l_Sourcing_Rule_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

Line 492: IF l_Sourcing_Rule_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

488: IF l_Sourcing_Rule_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
489: l_Sourcing_Rule_rec.Attribute5 := p_old_Sourcing_Rule_rec.Attribute5;
490: END IF;
491:
492: IF l_Sourcing_Rule_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
493: l_Sourcing_Rule_rec.Attribute6 := p_old_Sourcing_Rule_rec.Attribute6;
494: END IF;
495:
496: IF l_Sourcing_Rule_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

Line 496: IF l_Sourcing_Rule_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

492: IF l_Sourcing_Rule_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
493: l_Sourcing_Rule_rec.Attribute6 := p_old_Sourcing_Rule_rec.Attribute6;
494: END IF;
495:
496: IF l_Sourcing_Rule_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
497: l_Sourcing_Rule_rec.Attribute7 := p_old_Sourcing_Rule_rec.Attribute7;
498: END IF;
499:
500: IF l_Sourcing_Rule_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

Line 500: IF l_Sourcing_Rule_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

496: IF l_Sourcing_Rule_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
497: l_Sourcing_Rule_rec.Attribute7 := p_old_Sourcing_Rule_rec.Attribute7;
498: END IF;
499:
500: IF l_Sourcing_Rule_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
501: l_Sourcing_Rule_rec.Attribute8 := p_old_Sourcing_Rule_rec.Attribute8;
502: END IF;
503:
504: IF l_Sourcing_Rule_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

Line 504: IF l_Sourcing_Rule_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

500: IF l_Sourcing_Rule_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
501: l_Sourcing_Rule_rec.Attribute8 := p_old_Sourcing_Rule_rec.Attribute8;
502: END IF;
503:
504: IF l_Sourcing_Rule_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
505: l_Sourcing_Rule_rec.Attribute9 := p_old_Sourcing_Rule_rec.Attribute9;
506: END IF;
507:
508: IF l_Sourcing_Rule_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

Line 508: IF l_Sourcing_Rule_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

504: IF l_Sourcing_Rule_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
505: l_Sourcing_Rule_rec.Attribute9 := p_old_Sourcing_Rule_rec.Attribute9;
506: END IF;
507:
508: IF l_Sourcing_Rule_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
509: l_Sourcing_Rule_rec.Attribute_Category := p_old_Sourcing_Rule_rec.Attribute_Category;
510: END IF;
511:
512: IF l_Sourcing_Rule_rec.Created_By = FND_API.G_MISS_NUM THEN

Line 512: IF l_Sourcing_Rule_rec.Created_By = FND_API.G_MISS_NUM THEN

508: IF l_Sourcing_Rule_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
509: l_Sourcing_Rule_rec.Attribute_Category := p_old_Sourcing_Rule_rec.Attribute_Category;
510: END IF;
511:
512: IF l_Sourcing_Rule_rec.Created_By = FND_API.G_MISS_NUM THEN
513: l_Sourcing_Rule_rec.Created_By := p_old_Sourcing_Rule_rec.Created_By;
514: END IF;
515:
516: IF l_Sourcing_Rule_rec.Creation_Date = FND_API.G_MISS_DATE THEN

Line 516: IF l_Sourcing_Rule_rec.Creation_Date = FND_API.G_MISS_DATE THEN

512: IF l_Sourcing_Rule_rec.Created_By = FND_API.G_MISS_NUM THEN
513: l_Sourcing_Rule_rec.Created_By := p_old_Sourcing_Rule_rec.Created_By;
514: END IF;
515:
516: IF l_Sourcing_Rule_rec.Creation_Date = FND_API.G_MISS_DATE THEN
517: l_Sourcing_Rule_rec.Creation_Date := p_old_Sourcing_Rule_rec.Creation_Date;
518: END IF;
519:
520: IF l_Sourcing_Rule_rec.Description = FND_API.G_MISS_CHAR THEN

Line 520: IF l_Sourcing_Rule_rec.Description = FND_API.G_MISS_CHAR THEN

516: IF l_Sourcing_Rule_rec.Creation_Date = FND_API.G_MISS_DATE THEN
517: l_Sourcing_Rule_rec.Creation_Date := p_old_Sourcing_Rule_rec.Creation_Date;
518: END IF;
519:
520: IF l_Sourcing_Rule_rec.Description = FND_API.G_MISS_CHAR THEN
521: l_Sourcing_Rule_rec.Description := p_old_Sourcing_Rule_rec.Description;
522: END IF;
523:
524: IF l_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

Line 524: IF l_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

520: IF l_Sourcing_Rule_rec.Description = FND_API.G_MISS_CHAR THEN
521: l_Sourcing_Rule_rec.Description := p_old_Sourcing_Rule_rec.Description;
522: END IF;
523:
524: IF l_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
525: l_Sourcing_Rule_rec.Last_Updated_By := p_old_Sourcing_Rule_rec.Last_Updated_By;
526: END IF;
527:
528: IF l_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

Line 528: IF l_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

524: IF l_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
525: l_Sourcing_Rule_rec.Last_Updated_By := p_old_Sourcing_Rule_rec.Last_Updated_By;
526: END IF;
527:
528: IF l_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
529: l_Sourcing_Rule_rec.Last_Update_Date := p_old_Sourcing_Rule_rec.Last_Update_Date;
530: END IF;
531:
532: IF l_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

Line 532: IF l_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

528: IF l_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
529: l_Sourcing_Rule_rec.Last_Update_Date := p_old_Sourcing_Rule_rec.Last_Update_Date;
530: END IF;
531:
532: IF l_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
533: l_Sourcing_Rule_rec.Last_Update_Login := p_old_Sourcing_Rule_rec.Last_Update_Login;
534: END IF;
535:
536: IF l_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM THEN

Line 536: IF l_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM THEN

532: IF l_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
533: l_Sourcing_Rule_rec.Last_Update_Login := p_old_Sourcing_Rule_rec.Last_Update_Login;
534: END IF;
535:
536: IF l_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM THEN
537: l_Sourcing_Rule_rec.Organization_Id := p_old_Sourcing_Rule_rec.Organization_Id;
538: END IF;
539:
540: IF l_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM THEN

Line 540: IF l_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM THEN

536: IF l_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM THEN
537: l_Sourcing_Rule_rec.Organization_Id := p_old_Sourcing_Rule_rec.Organization_Id;
538: END IF;
539:
540: IF l_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM THEN
541: l_Sourcing_Rule_rec.Planning_Active := p_old_Sourcing_Rule_rec.Planning_Active;
542: END IF;
543:
544: IF l_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

Line 544: IF l_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

540: IF l_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM THEN
541: l_Sourcing_Rule_rec.Planning_Active := p_old_Sourcing_Rule_rec.Planning_Active;
542: END IF;
543:
544: IF l_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
545: l_Sourcing_Rule_rec.Program_Application_Id := p_old_Sourcing_Rule_rec.Program_Application_Id;
546: END IF;
547:
548: IF l_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM THEN

Line 548: IF l_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM THEN

544: IF l_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
545: l_Sourcing_Rule_rec.Program_Application_Id := p_old_Sourcing_Rule_rec.Program_Application_Id;
546: END IF;
547:
548: IF l_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM THEN
549: l_Sourcing_Rule_rec.Program_Id := p_old_Sourcing_Rule_rec.Program_Id;
550: END IF;
551:
552: IF l_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

Line 552: IF l_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

548: IF l_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM THEN
549: l_Sourcing_Rule_rec.Program_Id := p_old_Sourcing_Rule_rec.Program_Id;
550: END IF;
551:
552: IF l_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
553: l_Sourcing_Rule_rec.Program_Update_Date := p_old_Sourcing_Rule_rec.Program_Update_Date;
554: END IF;
555:
556: IF l_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM THEN

Line 556: IF l_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM THEN

552: IF l_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
553: l_Sourcing_Rule_rec.Program_Update_Date := p_old_Sourcing_Rule_rec.Program_Update_Date;
554: END IF;
555:
556: IF l_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM THEN
557: l_Sourcing_Rule_rec.Request_Id := p_old_Sourcing_Rule_rec.Request_Id;
558: END IF;
559:
560: IF l_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR THEN

Line 560: IF l_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR THEN

556: IF l_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM THEN
557: l_Sourcing_Rule_rec.Request_Id := p_old_Sourcing_Rule_rec.Request_Id;
558: END IF;
559:
560: IF l_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR THEN
561: l_Sourcing_Rule_rec.Sourcing_Rule_Name := p_old_Sourcing_Rule_rec.Sourcing_Rule_Name;
562: END IF;
563:
564: IF l_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN

Line 564: IF l_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN

560: IF l_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR THEN
561: l_Sourcing_Rule_rec.Sourcing_Rule_Name := p_old_Sourcing_Rule_rec.Sourcing_Rule_Name;
562: END IF;
563:
564: IF l_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN
565: l_Sourcing_Rule_rec.Sourcing_Rule_Type := p_old_Sourcing_Rule_rec.Sourcing_Rule_Type;
566: END IF;
567:
568: IF l_Sourcing_Rule_rec.Status = FND_API.G_MISS_NUM THEN

Line 568: IF l_Sourcing_Rule_rec.Status = FND_API.G_MISS_NUM THEN

564: IF l_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN
565: l_Sourcing_Rule_rec.Sourcing_Rule_Type := p_old_Sourcing_Rule_rec.Sourcing_Rule_Type;
566: END IF;
567:
568: IF l_Sourcing_Rule_rec.Status = FND_API.G_MISS_NUM THEN
569: l_Sourcing_Rule_rec.Status := p_old_Sourcing_Rule_rec.Status;
570: END IF;
571:
572: RETURN l_Sourcing_Rule_rec;

Line 585: IF l_Sourcing_Rule_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN

581: IS
582: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type := p_Sourcing_Rule_rec;
583: BEGIN
584:
585: IF l_Sourcing_Rule_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
586: l_Sourcing_Rule_rec.Sourcing_Rule_Id := NULL;
587: END IF;
588:
589: IF l_Sourcing_Rule_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

Line 589: IF l_Sourcing_Rule_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

585: IF l_Sourcing_Rule_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
586: l_Sourcing_Rule_rec.Sourcing_Rule_Id := NULL;
587: END IF;
588:
589: IF l_Sourcing_Rule_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
590: l_Sourcing_Rule_rec.Attribute1 := NULL;
591: END IF;
592:
593: IF l_Sourcing_Rule_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

Line 593: IF l_Sourcing_Rule_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

589: IF l_Sourcing_Rule_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
590: l_Sourcing_Rule_rec.Attribute1 := NULL;
591: END IF;
592:
593: IF l_Sourcing_Rule_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
594: l_Sourcing_Rule_rec.Attribute10 := NULL;
595: END IF;
596:
597: IF l_Sourcing_Rule_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

Line 597: IF l_Sourcing_Rule_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

593: IF l_Sourcing_Rule_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
594: l_Sourcing_Rule_rec.Attribute10 := NULL;
595: END IF;
596:
597: IF l_Sourcing_Rule_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
598: l_Sourcing_Rule_rec.Attribute11 := NULL;
599: END IF;
600:
601: IF l_Sourcing_Rule_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

Line 601: IF l_Sourcing_Rule_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

597: IF l_Sourcing_Rule_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
598: l_Sourcing_Rule_rec.Attribute11 := NULL;
599: END IF;
600:
601: IF l_Sourcing_Rule_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
602: l_Sourcing_Rule_rec.Attribute12 := NULL;
603: END IF;
604:
605: IF l_Sourcing_Rule_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

Line 605: IF l_Sourcing_Rule_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

601: IF l_Sourcing_Rule_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
602: l_Sourcing_Rule_rec.Attribute12 := NULL;
603: END IF;
604:
605: IF l_Sourcing_Rule_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
606: l_Sourcing_Rule_rec.Attribute13 := NULL;
607: END IF;
608:
609: IF l_Sourcing_Rule_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

Line 609: IF l_Sourcing_Rule_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

605: IF l_Sourcing_Rule_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
606: l_Sourcing_Rule_rec.Attribute13 := NULL;
607: END IF;
608:
609: IF l_Sourcing_Rule_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
610: l_Sourcing_Rule_rec.Attribute14 := NULL;
611: END IF;
612:
613: IF l_Sourcing_Rule_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

Line 613: IF l_Sourcing_Rule_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

609: IF l_Sourcing_Rule_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
610: l_Sourcing_Rule_rec.Attribute14 := NULL;
611: END IF;
612:
613: IF l_Sourcing_Rule_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
614: l_Sourcing_Rule_rec.Attribute15 := NULL;
615: END IF;
616:
617: IF l_Sourcing_Rule_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

Line 617: IF l_Sourcing_Rule_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

613: IF l_Sourcing_Rule_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
614: l_Sourcing_Rule_rec.Attribute15 := NULL;
615: END IF;
616:
617: IF l_Sourcing_Rule_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
618: l_Sourcing_Rule_rec.Attribute2 := NULL;
619: END IF;
620:
621: IF l_Sourcing_Rule_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

Line 621: IF l_Sourcing_Rule_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

617: IF l_Sourcing_Rule_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
618: l_Sourcing_Rule_rec.Attribute2 := NULL;
619: END IF;
620:
621: IF l_Sourcing_Rule_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
622: l_Sourcing_Rule_rec.Attribute3 := NULL;
623: END IF;
624:
625: IF l_Sourcing_Rule_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

Line 625: IF l_Sourcing_Rule_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

621: IF l_Sourcing_Rule_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
622: l_Sourcing_Rule_rec.Attribute3 := NULL;
623: END IF;
624:
625: IF l_Sourcing_Rule_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
626: l_Sourcing_Rule_rec.Attribute4 := NULL;
627: END IF;
628:
629: IF l_Sourcing_Rule_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

Line 629: IF l_Sourcing_Rule_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

625: IF l_Sourcing_Rule_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
626: l_Sourcing_Rule_rec.Attribute4 := NULL;
627: END IF;
628:
629: IF l_Sourcing_Rule_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
630: l_Sourcing_Rule_rec.Attribute5 := NULL;
631: END IF;
632:
633: IF l_Sourcing_Rule_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

Line 633: IF l_Sourcing_Rule_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

629: IF l_Sourcing_Rule_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
630: l_Sourcing_Rule_rec.Attribute5 := NULL;
631: END IF;
632:
633: IF l_Sourcing_Rule_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
634: l_Sourcing_Rule_rec.Attribute6 := NULL;
635: END IF;
636:
637: IF l_Sourcing_Rule_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

Line 637: IF l_Sourcing_Rule_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

633: IF l_Sourcing_Rule_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
634: l_Sourcing_Rule_rec.Attribute6 := NULL;
635: END IF;
636:
637: IF l_Sourcing_Rule_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
638: l_Sourcing_Rule_rec.Attribute7 := NULL;
639: END IF;
640:
641: IF l_Sourcing_Rule_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

Line 641: IF l_Sourcing_Rule_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

637: IF l_Sourcing_Rule_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
638: l_Sourcing_Rule_rec.Attribute7 := NULL;
639: END IF;
640:
641: IF l_Sourcing_Rule_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
642: l_Sourcing_Rule_rec.Attribute8 := NULL;
643: END IF;
644:
645: IF l_Sourcing_Rule_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

Line 645: IF l_Sourcing_Rule_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

641: IF l_Sourcing_Rule_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
642: l_Sourcing_Rule_rec.Attribute8 := NULL;
643: END IF;
644:
645: IF l_Sourcing_Rule_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
646: l_Sourcing_Rule_rec.Attribute9 := NULL;
647: END IF;
648:
649: IF l_Sourcing_Rule_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

Line 649: IF l_Sourcing_Rule_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

645: IF l_Sourcing_Rule_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
646: l_Sourcing_Rule_rec.Attribute9 := NULL;
647: END IF;
648:
649: IF l_Sourcing_Rule_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
650: l_Sourcing_Rule_rec.Attribute_Category := NULL;
651: END IF;
652:
653: IF l_Sourcing_Rule_rec.Created_By = FND_API.G_MISS_NUM THEN

Line 653: IF l_Sourcing_Rule_rec.Created_By = FND_API.G_MISS_NUM THEN

649: IF l_Sourcing_Rule_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
650: l_Sourcing_Rule_rec.Attribute_Category := NULL;
651: END IF;
652:
653: IF l_Sourcing_Rule_rec.Created_By = FND_API.G_MISS_NUM THEN
654: l_Sourcing_Rule_rec.Created_By := NULL;
655: END IF;
656:
657: IF l_Sourcing_Rule_rec.Creation_Date = FND_API.G_MISS_DATE THEN

Line 657: IF l_Sourcing_Rule_rec.Creation_Date = FND_API.G_MISS_DATE THEN

653: IF l_Sourcing_Rule_rec.Created_By = FND_API.G_MISS_NUM THEN
654: l_Sourcing_Rule_rec.Created_By := NULL;
655: END IF;
656:
657: IF l_Sourcing_Rule_rec.Creation_Date = FND_API.G_MISS_DATE THEN
658: l_Sourcing_Rule_rec.Creation_Date := NULL;
659: END IF;
660:
661: IF l_Sourcing_Rule_rec.Description = FND_API.G_MISS_CHAR THEN

Line 661: IF l_Sourcing_Rule_rec.Description = FND_API.G_MISS_CHAR THEN

657: IF l_Sourcing_Rule_rec.Creation_Date = FND_API.G_MISS_DATE THEN
658: l_Sourcing_Rule_rec.Creation_Date := NULL;
659: END IF;
660:
661: IF l_Sourcing_Rule_rec.Description = FND_API.G_MISS_CHAR THEN
662: l_Sourcing_Rule_rec.Description := NULL;
663: END IF;
664:
665: IF l_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

Line 665: IF l_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

661: IF l_Sourcing_Rule_rec.Description = FND_API.G_MISS_CHAR THEN
662: l_Sourcing_Rule_rec.Description := NULL;
663: END IF;
664:
665: IF l_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
666: l_Sourcing_Rule_rec.Last_Updated_By := NULL;
667: END IF;
668:
669: IF l_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

Line 669: IF l_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

665: IF l_Sourcing_Rule_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
666: l_Sourcing_Rule_rec.Last_Updated_By := NULL;
667: END IF;
668:
669: IF l_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
670: l_Sourcing_Rule_rec.Last_Update_Date := NULL;
671: END IF;
672:
673: IF l_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

Line 673: IF l_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

669: IF l_Sourcing_Rule_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
670: l_Sourcing_Rule_rec.Last_Update_Date := NULL;
671: END IF;
672:
673: IF l_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
674: l_Sourcing_Rule_rec.Last_Update_Login := NULL;
675: END IF;
676:
677: IF l_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM THEN

Line 677: IF l_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM THEN

673: IF l_Sourcing_Rule_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
674: l_Sourcing_Rule_rec.Last_Update_Login := NULL;
675: END IF;
676:
677: IF l_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM THEN
678: l_Sourcing_Rule_rec.Organization_Id := NULL;
679: END IF;
680:
681: IF l_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM THEN

Line 681: IF l_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM THEN

677: IF l_Sourcing_Rule_rec.Organization_Id = FND_API.G_MISS_NUM THEN
678: l_Sourcing_Rule_rec.Organization_Id := NULL;
679: END IF;
680:
681: IF l_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM THEN
682: l_Sourcing_Rule_rec.Planning_Active := NULL;
683: END IF;
684:
685: IF l_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

Line 685: IF l_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

681: IF l_Sourcing_Rule_rec.Planning_Active = FND_API.G_MISS_NUM THEN
682: l_Sourcing_Rule_rec.Planning_Active := NULL;
683: END IF;
684:
685: IF l_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
686: l_Sourcing_Rule_rec.Program_Application_Id := NULL;
687: END IF;
688:
689: IF l_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM THEN

Line 689: IF l_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM THEN

685: IF l_Sourcing_Rule_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
686: l_Sourcing_Rule_rec.Program_Application_Id := NULL;
687: END IF;
688:
689: IF l_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM THEN
690: l_Sourcing_Rule_rec.Program_Id := NULL;
691: END IF;
692:
693: IF l_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

Line 693: IF l_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

689: IF l_Sourcing_Rule_rec.Program_Id = FND_API.G_MISS_NUM THEN
690: l_Sourcing_Rule_rec.Program_Id := NULL;
691: END IF;
692:
693: IF l_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
694: l_Sourcing_Rule_rec.Program_Update_Date := NULL;
695: END IF;
696:
697: IF l_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM THEN

Line 697: IF l_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM THEN

693: IF l_Sourcing_Rule_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
694: l_Sourcing_Rule_rec.Program_Update_Date := NULL;
695: END IF;
696:
697: IF l_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM THEN
698: l_Sourcing_Rule_rec.Request_Id := NULL;
699: END IF;
700:
701: IF l_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR THEN

Line 701: IF l_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR THEN

697: IF l_Sourcing_Rule_rec.Request_Id = FND_API.G_MISS_NUM THEN
698: l_Sourcing_Rule_rec.Request_Id := NULL;
699: END IF;
700:
701: IF l_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR THEN
702: l_Sourcing_Rule_rec.Sourcing_Rule_Name := NULL;
703: END IF;
704:
705: IF l_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN

Line 705: IF l_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN

701: IF l_Sourcing_Rule_rec.Sourcing_Rule_Name = FND_API.G_MISS_CHAR THEN
702: l_Sourcing_Rule_rec.Sourcing_Rule_Name := NULL;
703: END IF;
704:
705: IF l_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN
706: l_Sourcing_Rule_rec.Sourcing_Rule_Type := NULL;
707: END IF;
708:
709: IF l_Sourcing_Rule_rec.Status = FND_API.G_MISS_NUM THEN

Line 709: IF l_Sourcing_Rule_rec.Status = FND_API.G_MISS_NUM THEN

705: IF l_Sourcing_Rule_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM THEN
706: l_Sourcing_Rule_rec.Sourcing_Rule_Type := NULL;
707: END IF;
708:
709: IF l_Sourcing_Rule_rec.Status = FND_API.G_MISS_NUM THEN
710: l_Sourcing_Rule_rec.Status := NULL;
711: END IF;
712:
713: RETURN l_Sourcing_Rule_rec;

Line 744: l_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_SUCCESS;

740: BEGIN
741:
742: -- initialize return_status.
743:
744: l_Sourcing_Rule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
745:
746: -- initialize l_Sourcing_Rule_rec.
747:
748: l_Sourcing_Rule_rec := p_Sourcing_Rule_rec;