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:
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:
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;
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
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
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
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;
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;
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
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
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:
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
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
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;
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;
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
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