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
16: )
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
16: )
17: IS
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
16: )
17: IS
18: BEGIN
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
16: )
17: IS
18: BEGIN
19:
242:
243: -- Procedure Apply_Attribute_Changes
244:
245: PROCEDURE Apply_Attribute_Changes
246: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
247: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
248: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
249: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
250: )
243: -- Procedure Apply_Attribute_Changes
244:
245: PROCEDURE Apply_Attribute_Changes
246: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
247: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
248: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
249: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
250: )
251: IS
244:
245: PROCEDURE Apply_Attribute_Changes
246: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
247: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
248: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
249: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
250: )
251: IS
252: BEGIN
245: PROCEDURE Apply_Attribute_Changes
246: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
247: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
248: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
249: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
250: )
251: IS
252: BEGIN
253:
409:
410: -- Function Complete_Record
411:
412: FUNCTION Complete_Record
413: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
414: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
415: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
416: IS
417: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type := p_Receiving_Org_rec;
410: -- Function Complete_Record
411:
412: FUNCTION Complete_Record
413: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
414: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
415: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
416: IS
417: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type := p_Receiving_Org_rec;
418: BEGIN
411:
412: FUNCTION Complete_Record
413: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
414: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
415: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
416: IS
417: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type := p_Receiving_Org_rec;
418: BEGIN
419:
413: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
414: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
415: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
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;
543:
544: -- Function Convert_Miss_To_Null
545:
546: FUNCTION Convert_Miss_To_Null
547: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
548: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
549: IS
550: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type := p_Receiving_Org_rec;
551: BEGIN
544: -- Function Convert_Miss_To_Null
545:
546: FUNCTION Convert_Miss_To_Null
547: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
548: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
549: IS
550: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type := p_Receiving_Org_rec;
551: BEGIN
552:
546: FUNCTION Convert_Miss_To_Null
547: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
548: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
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;
676:
677: -- Function Get_Values
678:
679: FUNCTION Get_Values
680: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
681: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
682: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
683: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
684: IS
677: -- Function Get_Values
678:
679: FUNCTION Get_Values
680: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
681: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
682: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
683: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
684: IS
685: l_Receiving_Org_val_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type;
678:
679: FUNCTION Get_Values
680: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
681: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
682: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
683: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
684: IS
685: l_Receiving_Org_val_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type;
686: BEGIN
679: FUNCTION Get_Values
680: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
681: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
682: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
683: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
684: IS
685: l_Receiving_Org_val_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type;
686: BEGIN
687:
681: , p_old_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type :=
682: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_REC
683: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
684: IS
685: l_Receiving_Org_val_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type;
686: BEGIN
687:
688: RETURN l_Receiving_Org_val_rec;
689:
691:
692: -- Function Get_Ids
693:
694: FUNCTION Get_Ids
695: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
696: , p_Receiving_Org_val_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
697: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
698: IS
699: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
692: -- Function Get_Ids
693:
694: FUNCTION Get_Ids
695: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
696: , p_Receiving_Org_val_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
697: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
698: IS
699: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
700: BEGIN
693:
694: FUNCTION Get_Ids
695: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
696: , p_Receiving_Org_val_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
697: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
698: IS
699: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
700: BEGIN
701:
695: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
696: , p_Receiving_Org_val_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
697: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
698: IS
699: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
700: BEGIN
701:
702: -- initialize return_status.
703: