APPS.MRP_SHIPPING_ORG_UTIL dependencies on MRP_SOURCING_RULE_PUB

Line 12: , p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

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
16: )

Line 13: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=

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
16: )
17: IS

Line 14: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC

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
16: )
17: IS
18: BEGIN

Line 15: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

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
16: )
17: IS
18: BEGIN
19:

Line 295: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

291:
292: -- Procedure Apply_Attribute_Changes
293:
294: PROCEDURE Apply_Attribute_Changes
295: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
296: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
297: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
298: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
299: )

Line 296: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=

292: -- Procedure Apply_Attribute_Changes
293:
294: PROCEDURE Apply_Attribute_Changes
295: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
296: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
297: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
298: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
299: )
300: IS

Line 297: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC

293:
294: PROCEDURE Apply_Attribute_Changes
295: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
296: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
297: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
298: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
299: )
300: IS
301: BEGIN

Line 298: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

294: PROCEDURE Apply_Attribute_Changes
295: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
296: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
297: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
298: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
299: )
300: IS
301: BEGIN
302:

Line 487: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

483:
484: -- Function Complete_Record
485:
486: FUNCTION Complete_Record
487: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
488: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
489: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
490: IS
491: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type := p_Shipping_Org_rec;

Line 488: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

484: -- Function Complete_Record
485:
486: FUNCTION Complete_Record
487: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
488: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
489: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
490: IS
491: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type := p_Shipping_Org_rec;
492: BEGIN

Line 489: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

485:
486: FUNCTION Complete_Record
487: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
488: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
489: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
490: IS
491: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type := p_Shipping_Org_rec;
492: BEGIN
493:

Line 491: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type := p_Shipping_Org_rec;

487: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
488: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
489: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
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;

Line 641: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

637:
638: -- Function Convert_Miss_To_Null
639:
640: FUNCTION Convert_Miss_To_Null
641: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
642: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
643: IS
644: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type := p_Shipping_Org_rec;
645: BEGIN

Line 642: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

638: -- Function Convert_Miss_To_Null
639:
640: FUNCTION Convert_Miss_To_Null
641: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
642: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
643: IS
644: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type := p_Shipping_Org_rec;
645: BEGIN
646:

Line 644: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type := p_Shipping_Org_rec;

640: FUNCTION Convert_Miss_To_Null
641: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
642: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
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;

Line 794: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

790:
791: -- Function Get_Values
792:
793: FUNCTION Get_Values
794: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
795: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
796: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
797: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
798: IS

Line 795: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=

791: -- Function Get_Values
792:
793: FUNCTION Get_Values
794: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
795: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
796: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
797: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
798: IS
799: l_Shipping_Org_val_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type;

Line 796: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC

792:
793: FUNCTION Get_Values
794: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
795: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
796: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
797: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
798: IS
799: l_Shipping_Org_val_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type;
800: BEGIN

Line 797: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type

793: FUNCTION Get_Values
794: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
795: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
796: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
797: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
798: IS
799: l_Shipping_Org_val_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type;
800: BEGIN
801:

Line 799: l_Shipping_Org_val_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type;

795: , p_old_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type :=
796: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_REC
797: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
798: IS
799: l_Shipping_Org_val_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type;
800: BEGIN
801:
802: RETURN l_Shipping_Org_val_rec;
803:

Line 809: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

805:
806: -- Function Get_Ids
807:
808: FUNCTION Get_Ids
809: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
810: , p_Shipping_Org_val_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
811: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
812: IS
813: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;

Line 810: , p_Shipping_Org_val_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type

806: -- Function Get_Ids
807:
808: FUNCTION Get_Ids
809: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
810: , p_Shipping_Org_val_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
811: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
812: IS
813: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
814: BEGIN

Line 811: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

807:
808: FUNCTION Get_Ids
809: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
810: , p_Shipping_Org_val_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
811: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
812: IS
813: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
814: BEGIN
815:

Line 813: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;

809: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
810: , p_Shipping_Org_val_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
811: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
812: IS
813: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
814: BEGIN
815:
816: -- initialize return_status.
817: