DBA Data[Home] [Help]

APPS.MRP_RECEIVING_ORG_HANDLERS dependencies on MRP_SOURCING_RULE_PUB

Line 11: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type

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

Line 69: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type

65:
66: -- Procedure Insert_Row
67:
68: PROCEDURE Insert_Row
69: ( p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
70: )
71: IS
72: BEGIN
73:

Line 216: , p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type

212: --
213:
214: PROCEDURE Lock_Row
215: ( x_return_status OUT VARCHAR2
216: , p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
217: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
218: )
219: IS
220: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;

Line 217: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type

213:
214: PROCEDURE Lock_Row
215: ( x_return_status OUT VARCHAR2
216: , p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
217: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
218: )
219: IS
220: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
221: BEGIN

Line 220: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;

216: , p_Receiving_Org_rec IN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
217: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
218: )
219: IS
220: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
221: BEGIN
222:
223: SELECT SR_RECEIPT_ID
224: , ATTRIBUTE1

Line 512: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type

508: -- Function Query_Row
509:
510: FUNCTION Query_Row
511: ( p_Sr_Receipt_Id IN NUMBER
512: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
513: IS
514: BEGIN
515:
516: RETURN Query_Rows

Line 541: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type

537: -- Procedure Query_Entity
538:
539: PROCEDURE Query_Entity
540: ( p_Sr_Receipt_Id IN NUMBER
541: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
542: , x_Receiving_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
543: )
544: IS
545: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;

Line 542: , x_Receiving_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type

538:
539: PROCEDURE Query_Entity
540: ( p_Sr_Receipt_Id IN NUMBER
541: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
542: , x_Receiving_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
543: )
544: IS
545: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
546: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;

Line 545: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;

541: , x_Receiving_Org_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type
542: , x_Receiving_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
543: )
544: IS
545: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
546: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;
547: BEGIN
548:
549: Query_Entities

Line 546: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;

542: , x_Receiving_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type
543: )
544: IS
545: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
546: l_Receiving_Org_val_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type;
547: BEGIN
548:
549: Query_Entities
550: ( p_Sr_Receipt_Id => p_Sr_Receipt_Id

Line 586: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type

582: ( p_Sr_Receipt_Id IN NUMBER :=
583: FND_API.G_MISS_NUM
584: , p_Sourcing_Rule_Id IN NUMBER :=
585: FND_API.G_MISS_NUM
586: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
587: IS
588: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
589: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
590:

Line 588: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;

584: , p_Sourcing_Rule_Id IN NUMBER :=
585: FND_API.G_MISS_NUM
586: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
587: IS
588: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
589: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
590:
591: CURSOR l_Receiving_Org_csr IS
592: SELECT SR_RECEIPT_ID

Line 589: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;

585: FND_API.G_MISS_NUM
586: ) RETURN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
587: IS
588: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
589: l_Receiving_Org_tbl MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type;
590:
591: CURSOR l_Receiving_Org_csr IS
592: SELECT SR_RECEIPT_ID
593: , ATTRIBUTE1

Line 739: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type

735: ( p_Sr_Receipt_Id IN NUMBER :=
736: FND_API.G_MISS_NUM
737: , p_Sourcing_Rule_Id IN NUMBER :=
738: FND_API.G_MISS_NUM
739: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
740: , x_Receiving_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type
741: )
742: IS
743: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;

Line 740: , x_Receiving_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type

736: FND_API.G_MISS_NUM
737: , p_Sourcing_Rule_Id IN NUMBER :=
738: FND_API.G_MISS_NUM
739: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
740: , x_Receiving_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type
741: )
742: IS
743: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
744: l_Receiving_Org_val_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type;

Line 743: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;

739: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
740: , x_Receiving_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type
741: )
742: IS
743: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
744: l_Receiving_Org_val_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type;
745: l_rows_fetched BOOLEAN := FALSE;
746:
747: CURSOR l_Receiving_Org_csr IS

Line 744: l_Receiving_Org_val_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type;

740: , x_Receiving_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Tbl_Type
741: )
742: IS
743: l_Receiving_Org_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Rec_Type;
744: l_Receiving_Org_val_rec MRP_Sourcing_Rule_PUB.Receiving_Org_Val_Rec_Type;
745: l_rows_fetched BOOLEAN := FALSE;
746:
747: CURSOR l_Receiving_Org_csr IS
748: SELECT SR_RECEIPT_ID