APPS.MRP_SHIPPING_ORG_HANDLERS dependencies on MRP_SOURCING_RULE_PUB

Line 11: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

7:
8: -- Procedure Update_Row
9:
10: PROCEDURE Update_Row
11: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
12: )
13: IS
14: BEGIN
15:

Line 74: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

70:
71: -- Procedure Insert_Row
72:
73: PROCEDURE Insert_Row
74: ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
75: )
76: IS
77: BEGIN
78:

Line 203: , p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

199: --
200:
201: PROCEDURE Lock_Row
202: ( x_return_status OUT VARCHAR2
203: , p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
204: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
205: )
206: IS
207: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;

Line 204: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

200:
201: PROCEDURE Lock_Row
202: ( x_return_status OUT VARCHAR2
203: , p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
204: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
205: )
206: IS
207: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
208: BEGIN

Line 207: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;

203: , p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
204: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
205: )
206: IS
207: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
208: BEGIN
209:
210: SELECT SR_SOURCE_ID
211: , ALLOCATION_PERCENT

Line 534: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

530: -- Function Query_Row
531:
532: FUNCTION Query_Row
533: ( p_Sr_Source_Id IN NUMBER
534: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
535: IS
536: BEGIN
537:
538: RETURN Query_Rows

Line 563: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type

559: -- Procedure Query_Entity
560:
561: PROCEDURE Query_Entity
562: ( p_Sr_Source_Id IN NUMBER
563: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
564: , x_Shipping_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
565: )
566: IS
567: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;

Line 564: , x_Shipping_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type

560:
561: PROCEDURE Query_Entity
562: ( p_Sr_Source_Id IN NUMBER
563: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
564: , x_Shipping_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
565: )
566: IS
567: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
568: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;

Line 567: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;

563: , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
564: , x_Shipping_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
565: )
566: IS
567: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
568: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
569: BEGIN
570:
571: Query_Entities

Line 568: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;

564: , x_Shipping_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
565: )
566: IS
567: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
568: l_Shipping_Org_val_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type;
569: BEGIN
570:
571: Query_Entities
572: ( p_Sr_Source_Id => p_Sr_Source_Id

Line 608: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type

604: ( p_Sr_Source_Id IN NUMBER :=
605: FND_API.G_MISS_NUM
606: , p_Sr_Receipt_Id IN NUMBER :=
607: FND_API.G_MISS_NUM
608: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
609: IS
610: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
611: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
612:

Line 610: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;

606: , p_Sr_Receipt_Id IN NUMBER :=
607: FND_API.G_MISS_NUM
608: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
609: IS
610: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
611: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
612:
613: CURSOR l_Shipping_Org_csr IS
614: SELECT SR_SOURCE_ID

Line 611: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;

607: FND_API.G_MISS_NUM
608: ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
609: IS
610: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
611: l_Shipping_Org_tbl MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
612:
613: CURSOR l_Shipping_Org_csr IS
614: SELECT SR_SOURCE_ID
615: , ALLOCATION_PERCENT

Line 771: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type

767: ( p_Sr_Source_Id IN NUMBER :=
768: FND_API.G_MISS_NUM
769: , p_Sr_Receipt_Id IN NUMBER :=
770: FND_API.G_MISS_NUM
771: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
772: , x_Shipping_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type
773: )
774: IS
775: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;

Line 772: , x_Shipping_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type

768: FND_API.G_MISS_NUM
769: , p_Sr_Receipt_Id IN NUMBER :=
770: FND_API.G_MISS_NUM
771: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
772: , x_Shipping_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type
773: )
774: IS
775: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
776: l_Shipping_Org_val_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type;

Line 775: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;

771: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
772: , x_Shipping_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type
773: )
774: IS
775: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
776: l_Shipping_Org_val_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type;
777: l_rows_fetched BOOLEAN := FALSE;
778:
779: CURSOR l_Shipping_Org_csr IS

Line 776: l_Shipping_Org_val_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type;

772: , x_Shipping_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type
773: )
774: IS
775: l_Shipping_Org_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
776: l_Shipping_Org_val_rec MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type;
777: l_rows_fetched BOOLEAN := FALSE;
778:
779: CURSOR l_Shipping_Org_csr IS
780: SELECT SR_SOURCE_ID