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_RECEIVING_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_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
13: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
14: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
15: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_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_Receiving_Org_rec.Sr_Receipt_Id,p_old_Receiving_Org_rec.Sr_Receipt_Id)
30: THEN
31: NULL;

Line 420: IF l_Receiving_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN

416: IS
417: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type := p_Receiving_Org_rec;
418: BEGIN
419:
420: IF l_Receiving_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN
421: l_Receiving_Org_rec.Sr_Receipt_Id := p_old_Receiving_Org_rec.Sr_Receipt_Id;
422: END IF;
423:
424: IF l_Receiving_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

Line 424: IF l_Receiving_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

420: IF l_Receiving_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN
421: l_Receiving_Org_rec.Sr_Receipt_Id := p_old_Receiving_Org_rec.Sr_Receipt_Id;
422: END IF;
423:
424: IF l_Receiving_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
425: l_Receiving_Org_rec.Attribute1 := p_old_Receiving_Org_rec.Attribute1;
426: END IF;
427:
428: IF l_Receiving_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

Line 428: IF l_Receiving_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

424: IF l_Receiving_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
425: l_Receiving_Org_rec.Attribute1 := p_old_Receiving_Org_rec.Attribute1;
426: END IF;
427:
428: IF l_Receiving_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
429: l_Receiving_Org_rec.Attribute10 := p_old_Receiving_Org_rec.Attribute10;
430: END IF;
431:
432: IF l_Receiving_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

Line 432: IF l_Receiving_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

428: IF l_Receiving_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
429: l_Receiving_Org_rec.Attribute10 := p_old_Receiving_Org_rec.Attribute10;
430: END IF;
431:
432: IF l_Receiving_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
433: l_Receiving_Org_rec.Attribute11 := p_old_Receiving_Org_rec.Attribute11;
434: END IF;
435:
436: IF l_Receiving_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

Line 436: IF l_Receiving_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

432: IF l_Receiving_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
433: l_Receiving_Org_rec.Attribute11 := p_old_Receiving_Org_rec.Attribute11;
434: END IF;
435:
436: IF l_Receiving_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
437: l_Receiving_Org_rec.Attribute12 := p_old_Receiving_Org_rec.Attribute12;
438: END IF;
439:
440: IF l_Receiving_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

Line 440: IF l_Receiving_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

436: IF l_Receiving_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
437: l_Receiving_Org_rec.Attribute12 := p_old_Receiving_Org_rec.Attribute12;
438: END IF;
439:
440: IF l_Receiving_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
441: l_Receiving_Org_rec.Attribute13 := p_old_Receiving_Org_rec.Attribute13;
442: END IF;
443:
444: IF l_Receiving_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

Line 444: IF l_Receiving_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

440: IF l_Receiving_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
441: l_Receiving_Org_rec.Attribute13 := p_old_Receiving_Org_rec.Attribute13;
442: END IF;
443:
444: IF l_Receiving_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
445: l_Receiving_Org_rec.Attribute14 := p_old_Receiving_Org_rec.Attribute14;
446: END IF;
447:
448: IF l_Receiving_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

Line 448: IF l_Receiving_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

444: IF l_Receiving_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
445: l_Receiving_Org_rec.Attribute14 := p_old_Receiving_Org_rec.Attribute14;
446: END IF;
447:
448: IF l_Receiving_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
449: l_Receiving_Org_rec.Attribute15 := p_old_Receiving_Org_rec.Attribute15;
450: END IF;
451:
452: IF l_Receiving_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

Line 452: IF l_Receiving_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

448: IF l_Receiving_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
449: l_Receiving_Org_rec.Attribute15 := p_old_Receiving_Org_rec.Attribute15;
450: END IF;
451:
452: IF l_Receiving_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
453: l_Receiving_Org_rec.Attribute2 := p_old_Receiving_Org_rec.Attribute2;
454: END IF;
455:
456: IF l_Receiving_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

Line 456: IF l_Receiving_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

452: IF l_Receiving_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
453: l_Receiving_Org_rec.Attribute2 := p_old_Receiving_Org_rec.Attribute2;
454: END IF;
455:
456: IF l_Receiving_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
457: l_Receiving_Org_rec.Attribute3 := p_old_Receiving_Org_rec.Attribute3;
458: END IF;
459:
460: IF l_Receiving_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

Line 460: IF l_Receiving_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

456: IF l_Receiving_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
457: l_Receiving_Org_rec.Attribute3 := p_old_Receiving_Org_rec.Attribute3;
458: END IF;
459:
460: IF l_Receiving_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
461: l_Receiving_Org_rec.Attribute4 := p_old_Receiving_Org_rec.Attribute4;
462: END IF;
463:
464: IF l_Receiving_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

Line 464: IF l_Receiving_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

460: IF l_Receiving_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
461: l_Receiving_Org_rec.Attribute4 := p_old_Receiving_Org_rec.Attribute4;
462: END IF;
463:
464: IF l_Receiving_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
465: l_Receiving_Org_rec.Attribute5 := p_old_Receiving_Org_rec.Attribute5;
466: END IF;
467:
468: IF l_Receiving_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

Line 468: IF l_Receiving_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

464: IF l_Receiving_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
465: l_Receiving_Org_rec.Attribute5 := p_old_Receiving_Org_rec.Attribute5;
466: END IF;
467:
468: IF l_Receiving_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
469: l_Receiving_Org_rec.Attribute6 := p_old_Receiving_Org_rec.Attribute6;
470: END IF;
471:
472: IF l_Receiving_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

Line 472: IF l_Receiving_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

468: IF l_Receiving_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
469: l_Receiving_Org_rec.Attribute6 := p_old_Receiving_Org_rec.Attribute6;
470: END IF;
471:
472: IF l_Receiving_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
473: l_Receiving_Org_rec.Attribute7 := p_old_Receiving_Org_rec.Attribute7;
474: END IF;
475:
476: IF l_Receiving_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

Line 476: IF l_Receiving_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

472: IF l_Receiving_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
473: l_Receiving_Org_rec.Attribute7 := p_old_Receiving_Org_rec.Attribute7;
474: END IF;
475:
476: IF l_Receiving_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
477: l_Receiving_Org_rec.Attribute8 := p_old_Receiving_Org_rec.Attribute8;
478: END IF;
479:
480: IF l_Receiving_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

Line 480: IF l_Receiving_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

476: IF l_Receiving_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
477: l_Receiving_Org_rec.Attribute8 := p_old_Receiving_Org_rec.Attribute8;
478: END IF;
479:
480: IF l_Receiving_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
481: l_Receiving_Org_rec.Attribute9 := p_old_Receiving_Org_rec.Attribute9;
482: END IF;
483:
484: IF l_Receiving_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

Line 484: IF l_Receiving_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

480: IF l_Receiving_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
481: l_Receiving_Org_rec.Attribute9 := p_old_Receiving_Org_rec.Attribute9;
482: END IF;
483:
484: IF l_Receiving_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
485: l_Receiving_Org_rec.Attribute_Category := p_old_Receiving_Org_rec.Attribute_Category;
486: END IF;
487:
488: IF l_Receiving_Org_rec.Created_By = FND_API.G_MISS_NUM THEN

Line 488: IF l_Receiving_Org_rec.Created_By = FND_API.G_MISS_NUM THEN

484: IF l_Receiving_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
485: l_Receiving_Org_rec.Attribute_Category := p_old_Receiving_Org_rec.Attribute_Category;
486: END IF;
487:
488: IF l_Receiving_Org_rec.Created_By = FND_API.G_MISS_NUM THEN
489: l_Receiving_Org_rec.Created_By := p_old_Receiving_Org_rec.Created_By;
490: END IF;
491:
492: IF l_Receiving_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN

Line 492: IF l_Receiving_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN

488: IF l_Receiving_Org_rec.Created_By = FND_API.G_MISS_NUM THEN
489: l_Receiving_Org_rec.Created_By := p_old_Receiving_Org_rec.Created_By;
490: END IF;
491:
492: IF l_Receiving_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN
493: l_Receiving_Org_rec.Creation_Date := p_old_Receiving_Org_rec.Creation_Date;
494: END IF;
495:
496: IF l_Receiving_Org_rec.Disable_Date = FND_API.G_MISS_DATE THEN

Line 496: IF l_Receiving_Org_rec.Disable_Date = FND_API.G_MISS_DATE THEN

492: IF l_Receiving_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN
493: l_Receiving_Org_rec.Creation_Date := p_old_Receiving_Org_rec.Creation_Date;
494: END IF;
495:
496: IF l_Receiving_Org_rec.Disable_Date = FND_API.G_MISS_DATE THEN
497: l_Receiving_Org_rec.Disable_Date := p_old_Receiving_Org_rec.Disable_Date;
498: END IF;
499:
500: IF l_Receiving_Org_rec.Effective_Date = FND_API.G_MISS_DATE THEN

Line 500: IF l_Receiving_Org_rec.Effective_Date = FND_API.G_MISS_DATE THEN

496: IF l_Receiving_Org_rec.Disable_Date = FND_API.G_MISS_DATE THEN
497: l_Receiving_Org_rec.Disable_Date := p_old_Receiving_Org_rec.Disable_Date;
498: END IF;
499:
500: IF l_Receiving_Org_rec.Effective_Date = FND_API.G_MISS_DATE THEN
501: l_Receiving_Org_rec.Effective_Date := p_old_Receiving_Org_rec.Effective_Date;
502: END IF;
503:
504: IF l_Receiving_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

Line 504: IF l_Receiving_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

500: IF l_Receiving_Org_rec.Effective_Date = FND_API.G_MISS_DATE THEN
501: l_Receiving_Org_rec.Effective_Date := p_old_Receiving_Org_rec.Effective_Date;
502: END IF;
503:
504: IF l_Receiving_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
505: l_Receiving_Org_rec.Last_Updated_By := p_old_Receiving_Org_rec.Last_Updated_By;
506: END IF;
507:
508: IF l_Receiving_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

Line 508: IF l_Receiving_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

504: IF l_Receiving_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
505: l_Receiving_Org_rec.Last_Updated_By := p_old_Receiving_Org_rec.Last_Updated_By;
506: END IF;
507:
508: IF l_Receiving_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
509: l_Receiving_Org_rec.Last_Update_Date := p_old_Receiving_Org_rec.Last_Update_Date;
510: END IF;
511:
512: IF l_Receiving_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

Line 512: IF l_Receiving_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

508: IF l_Receiving_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
509: l_Receiving_Org_rec.Last_Update_Date := p_old_Receiving_Org_rec.Last_Update_Date;
510: END IF;
511:
512: IF l_Receiving_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
513: l_Receiving_Org_rec.Last_Update_Login := p_old_Receiving_Org_rec.Last_Update_Login;
514: END IF;
515:
516: IF l_Receiving_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

Line 516: IF l_Receiving_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

512: IF l_Receiving_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
513: l_Receiving_Org_rec.Last_Update_Login := p_old_Receiving_Org_rec.Last_Update_Login;
514: END IF;
515:
516: IF l_Receiving_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
517: l_Receiving_Org_rec.Program_Application_Id := p_old_Receiving_Org_rec.Program_Application_Id;
518: END IF;
519:
520: IF l_Receiving_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN

Line 520: IF l_Receiving_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN

516: IF l_Receiving_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
517: l_Receiving_Org_rec.Program_Application_Id := p_old_Receiving_Org_rec.Program_Application_Id;
518: END IF;
519:
520: IF l_Receiving_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN
521: l_Receiving_Org_rec.Program_Id := p_old_Receiving_Org_rec.Program_Id;
522: END IF;
523:
524: IF l_Receiving_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

Line 524: IF l_Receiving_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

520: IF l_Receiving_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN
521: l_Receiving_Org_rec.Program_Id := p_old_Receiving_Org_rec.Program_Id;
522: END IF;
523:
524: IF l_Receiving_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
525: l_Receiving_Org_rec.Program_Update_Date := p_old_Receiving_Org_rec.Program_Update_Date;
526: END IF;
527:
528: IF l_Receiving_Org_rec.Receipt_Organization_Id = FND_API.G_MISS_NUM THEN

Line 528: IF l_Receiving_Org_rec.Receipt_Organization_Id = FND_API.G_MISS_NUM THEN

524: IF l_Receiving_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
525: l_Receiving_Org_rec.Program_Update_Date := p_old_Receiving_Org_rec.Program_Update_Date;
526: END IF;
527:
528: IF l_Receiving_Org_rec.Receipt_Organization_Id = FND_API.G_MISS_NUM THEN
529: l_Receiving_Org_rec.Receipt_Organization_Id := p_old_Receiving_Org_rec.Receipt_Organization_Id;
530: END IF;
531:
532: IF l_Receiving_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN

Line 532: IF l_Receiving_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN

528: IF l_Receiving_Org_rec.Receipt_Organization_Id = FND_API.G_MISS_NUM THEN
529: l_Receiving_Org_rec.Receipt_Organization_Id := p_old_Receiving_Org_rec.Receipt_Organization_Id;
530: END IF;
531:
532: IF l_Receiving_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN
533: l_Receiving_Org_rec.Request_Id := p_old_Receiving_Org_rec.Request_Id;
534: END IF;
535:
536: IF l_Receiving_Org_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN

Line 536: IF l_Receiving_Org_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN

532: IF l_Receiving_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN
533: l_Receiving_Org_rec.Request_Id := p_old_Receiving_Org_rec.Request_Id;
534: END IF;
535:
536: IF l_Receiving_Org_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
537: l_Receiving_Org_rec.Sourcing_Rule_Id := p_old_Receiving_Org_rec.Sourcing_Rule_Id;
538: END IF;
539:
540: RETURN l_Receiving_Org_rec;

Line 553: IF l_Receiving_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN

549: IS
550: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type := p_Receiving_Org_rec;
551: BEGIN
552:
553: IF l_Receiving_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN
554: l_Receiving_Org_rec.Sr_Receipt_Id := NULL;
555: END IF;
556:
557: IF l_Receiving_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

Line 557: IF l_Receiving_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN

553: IF l_Receiving_Org_rec.Sr_Receipt_Id = FND_API.G_MISS_NUM THEN
554: l_Receiving_Org_rec.Sr_Receipt_Id := NULL;
555: END IF;
556:
557: IF l_Receiving_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
558: l_Receiving_Org_rec.Attribute1 := NULL;
559: END IF;
560:
561: IF l_Receiving_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

Line 561: IF l_Receiving_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN

557: IF l_Receiving_Org_rec.Attribute1 = FND_API.G_MISS_CHAR THEN
558: l_Receiving_Org_rec.Attribute1 := NULL;
559: END IF;
560:
561: IF l_Receiving_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
562: l_Receiving_Org_rec.Attribute10 := NULL;
563: END IF;
564:
565: IF l_Receiving_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

Line 565: IF l_Receiving_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN

561: IF l_Receiving_Org_rec.Attribute10 = FND_API.G_MISS_CHAR THEN
562: l_Receiving_Org_rec.Attribute10 := NULL;
563: END IF;
564:
565: IF l_Receiving_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
566: l_Receiving_Org_rec.Attribute11 := NULL;
567: END IF;
568:
569: IF l_Receiving_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

Line 569: IF l_Receiving_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN

565: IF l_Receiving_Org_rec.Attribute11 = FND_API.G_MISS_CHAR THEN
566: l_Receiving_Org_rec.Attribute11 := NULL;
567: END IF;
568:
569: IF l_Receiving_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
570: l_Receiving_Org_rec.Attribute12 := NULL;
571: END IF;
572:
573: IF l_Receiving_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

Line 573: IF l_Receiving_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN

569: IF l_Receiving_Org_rec.Attribute12 = FND_API.G_MISS_CHAR THEN
570: l_Receiving_Org_rec.Attribute12 := NULL;
571: END IF;
572:
573: IF l_Receiving_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
574: l_Receiving_Org_rec.Attribute13 := NULL;
575: END IF;
576:
577: IF l_Receiving_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

Line 577: IF l_Receiving_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN

573: IF l_Receiving_Org_rec.Attribute13 = FND_API.G_MISS_CHAR THEN
574: l_Receiving_Org_rec.Attribute13 := NULL;
575: END IF;
576:
577: IF l_Receiving_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
578: l_Receiving_Org_rec.Attribute14 := NULL;
579: END IF;
580:
581: IF l_Receiving_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

Line 581: IF l_Receiving_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN

577: IF l_Receiving_Org_rec.Attribute14 = FND_API.G_MISS_CHAR THEN
578: l_Receiving_Org_rec.Attribute14 := NULL;
579: END IF;
580:
581: IF l_Receiving_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
582: l_Receiving_Org_rec.Attribute15 := NULL;
583: END IF;
584:
585: IF l_Receiving_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

Line 585: IF l_Receiving_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN

581: IF l_Receiving_Org_rec.Attribute15 = FND_API.G_MISS_CHAR THEN
582: l_Receiving_Org_rec.Attribute15 := NULL;
583: END IF;
584:
585: IF l_Receiving_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
586: l_Receiving_Org_rec.Attribute2 := NULL;
587: END IF;
588:
589: IF l_Receiving_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

Line 589: IF l_Receiving_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN

585: IF l_Receiving_Org_rec.Attribute2 = FND_API.G_MISS_CHAR THEN
586: l_Receiving_Org_rec.Attribute2 := NULL;
587: END IF;
588:
589: IF l_Receiving_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
590: l_Receiving_Org_rec.Attribute3 := NULL;
591: END IF;
592:
593: IF l_Receiving_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

Line 593: IF l_Receiving_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN

589: IF l_Receiving_Org_rec.Attribute3 = FND_API.G_MISS_CHAR THEN
590: l_Receiving_Org_rec.Attribute3 := NULL;
591: END IF;
592:
593: IF l_Receiving_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
594: l_Receiving_Org_rec.Attribute4 := NULL;
595: END IF;
596:
597: IF l_Receiving_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

Line 597: IF l_Receiving_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN

593: IF l_Receiving_Org_rec.Attribute4 = FND_API.G_MISS_CHAR THEN
594: l_Receiving_Org_rec.Attribute4 := NULL;
595: END IF;
596:
597: IF l_Receiving_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
598: l_Receiving_Org_rec.Attribute5 := NULL;
599: END IF;
600:
601: IF l_Receiving_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

Line 601: IF l_Receiving_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN

597: IF l_Receiving_Org_rec.Attribute5 = FND_API.G_MISS_CHAR THEN
598: l_Receiving_Org_rec.Attribute5 := NULL;
599: END IF;
600:
601: IF l_Receiving_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
602: l_Receiving_Org_rec.Attribute6 := NULL;
603: END IF;
604:
605: IF l_Receiving_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

Line 605: IF l_Receiving_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN

601: IF l_Receiving_Org_rec.Attribute6 = FND_API.G_MISS_CHAR THEN
602: l_Receiving_Org_rec.Attribute6 := NULL;
603: END IF;
604:
605: IF l_Receiving_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
606: l_Receiving_Org_rec.Attribute7 := NULL;
607: END IF;
608:
609: IF l_Receiving_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

Line 609: IF l_Receiving_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN

605: IF l_Receiving_Org_rec.Attribute7 = FND_API.G_MISS_CHAR THEN
606: l_Receiving_Org_rec.Attribute7 := NULL;
607: END IF;
608:
609: IF l_Receiving_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
610: l_Receiving_Org_rec.Attribute8 := NULL;
611: END IF;
612:
613: IF l_Receiving_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

Line 613: IF l_Receiving_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN

609: IF l_Receiving_Org_rec.Attribute8 = FND_API.G_MISS_CHAR THEN
610: l_Receiving_Org_rec.Attribute8 := NULL;
611: END IF;
612:
613: IF l_Receiving_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
614: l_Receiving_Org_rec.Attribute9 := NULL;
615: END IF;
616:
617: IF l_Receiving_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

Line 617: IF l_Receiving_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN

613: IF l_Receiving_Org_rec.Attribute9 = FND_API.G_MISS_CHAR THEN
614: l_Receiving_Org_rec.Attribute9 := NULL;
615: END IF;
616:
617: IF l_Receiving_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
618: l_Receiving_Org_rec.Attribute_Category := NULL;
619: END IF;
620:
621: IF l_Receiving_Org_rec.Created_By = FND_API.G_MISS_NUM THEN

Line 621: IF l_Receiving_Org_rec.Created_By = FND_API.G_MISS_NUM THEN

617: IF l_Receiving_Org_rec.Attribute_Category = FND_API.G_MISS_CHAR THEN
618: l_Receiving_Org_rec.Attribute_Category := NULL;
619: END IF;
620:
621: IF l_Receiving_Org_rec.Created_By = FND_API.G_MISS_NUM THEN
622: l_Receiving_Org_rec.Created_By := NULL;
623: END IF;
624:
625: IF l_Receiving_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN

Line 625: IF l_Receiving_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN

621: IF l_Receiving_Org_rec.Created_By = FND_API.G_MISS_NUM THEN
622: l_Receiving_Org_rec.Created_By := NULL;
623: END IF;
624:
625: IF l_Receiving_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN
626: l_Receiving_Org_rec.Creation_Date := NULL;
627: END IF;
628:
629: IF l_Receiving_Org_rec.Disable_Date = FND_API.G_MISS_DATE THEN

Line 629: IF l_Receiving_Org_rec.Disable_Date = FND_API.G_MISS_DATE THEN

625: IF l_Receiving_Org_rec.Creation_Date = FND_API.G_MISS_DATE THEN
626: l_Receiving_Org_rec.Creation_Date := NULL;
627: END IF;
628:
629: IF l_Receiving_Org_rec.Disable_Date = FND_API.G_MISS_DATE THEN
630: l_Receiving_Org_rec.Disable_Date := NULL;
631: END IF;
632:
633: IF l_Receiving_Org_rec.Effective_Date = FND_API.G_MISS_DATE THEN

Line 633: IF l_Receiving_Org_rec.Effective_Date = FND_API.G_MISS_DATE THEN

629: IF l_Receiving_Org_rec.Disable_Date = FND_API.G_MISS_DATE THEN
630: l_Receiving_Org_rec.Disable_Date := NULL;
631: END IF;
632:
633: IF l_Receiving_Org_rec.Effective_Date = FND_API.G_MISS_DATE THEN
634: l_Receiving_Org_rec.Effective_Date := NULL;
635: END IF;
636:
637: IF l_Receiving_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

Line 637: IF l_Receiving_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN

633: IF l_Receiving_Org_rec.Effective_Date = FND_API.G_MISS_DATE THEN
634: l_Receiving_Org_rec.Effective_Date := NULL;
635: END IF;
636:
637: IF l_Receiving_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
638: l_Receiving_Org_rec.Last_Updated_By := NULL;
639: END IF;
640:
641: IF l_Receiving_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

Line 641: IF l_Receiving_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN

637: IF l_Receiving_Org_rec.Last_Updated_By = FND_API.G_MISS_NUM THEN
638: l_Receiving_Org_rec.Last_Updated_By := NULL;
639: END IF;
640:
641: IF l_Receiving_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
642: l_Receiving_Org_rec.Last_Update_Date := NULL;
643: END IF;
644:
645: IF l_Receiving_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

Line 645: IF l_Receiving_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN

641: IF l_Receiving_Org_rec.Last_Update_Date = FND_API.G_MISS_DATE THEN
642: l_Receiving_Org_rec.Last_Update_Date := NULL;
643: END IF;
644:
645: IF l_Receiving_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
646: l_Receiving_Org_rec.Last_Update_Login := NULL;
647: END IF;
648:
649: IF l_Receiving_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

Line 649: IF l_Receiving_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN

645: IF l_Receiving_Org_rec.Last_Update_Login = FND_API.G_MISS_NUM THEN
646: l_Receiving_Org_rec.Last_Update_Login := NULL;
647: END IF;
648:
649: IF l_Receiving_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
650: l_Receiving_Org_rec.Program_Application_Id := NULL;
651: END IF;
652:
653: IF l_Receiving_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN

Line 653: IF l_Receiving_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN

649: IF l_Receiving_Org_rec.Program_Application_Id = FND_API.G_MISS_NUM THEN
650: l_Receiving_Org_rec.Program_Application_Id := NULL;
651: END IF;
652:
653: IF l_Receiving_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN
654: l_Receiving_Org_rec.Program_Id := NULL;
655: END IF;
656:
657: IF l_Receiving_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

Line 657: IF l_Receiving_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN

653: IF l_Receiving_Org_rec.Program_Id = FND_API.G_MISS_NUM THEN
654: l_Receiving_Org_rec.Program_Id := NULL;
655: END IF;
656:
657: IF l_Receiving_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
658: l_Receiving_Org_rec.Program_Update_Date := NULL;
659: END IF;
660:
661: IF l_Receiving_Org_rec.Receipt_Organization_Id = FND_API.G_MISS_NUM THEN

Line 661: IF l_Receiving_Org_rec.Receipt_Organization_Id = FND_API.G_MISS_NUM THEN

657: IF l_Receiving_Org_rec.Program_Update_Date = FND_API.G_MISS_DATE THEN
658: l_Receiving_Org_rec.Program_Update_Date := NULL;
659: END IF;
660:
661: IF l_Receiving_Org_rec.Receipt_Organization_Id = FND_API.G_MISS_NUM THEN
662: l_Receiving_Org_rec.Receipt_Organization_Id := NULL;
663: END IF;
664:
665: IF l_Receiving_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN

Line 665: IF l_Receiving_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN

661: IF l_Receiving_Org_rec.Receipt_Organization_Id = FND_API.G_MISS_NUM THEN
662: l_Receiving_Org_rec.Receipt_Organization_Id := NULL;
663: END IF;
664:
665: IF l_Receiving_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN
666: l_Receiving_Org_rec.Request_Id := NULL;
667: END IF;
668:
669: IF l_Receiving_Org_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN

Line 669: IF l_Receiving_Org_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN

665: IF l_Receiving_Org_rec.Request_Id = FND_API.G_MISS_NUM THEN
666: l_Receiving_Org_rec.Request_Id := NULL;
667: END IF;
668:
669: IF l_Receiving_Org_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM THEN
670: l_Receiving_Org_rec.Sourcing_Rule_Id := NULL;
671: END IF;
672:
673: RETURN l_Receiving_Org_rec;

Line 704: l_Receiving_Org_rec.return_status := FND_API.G_RET_STS_SUCCESS;

700: BEGIN
701:
702: -- initialize return_status.
703:
704: l_Receiving_Org_rec.return_status := FND_API.G_RET_STS_SUCCESS;
705:
706: -- initialize l_Receiving_Org_rec.
707:
708: l_Receiving_Org_rec := p_Receiving_Org_rec;