[Home] [Help]
PACKAGE: APPS.MRP_SHIPPING_ORG_HANDLERS
Source
1 PACKAGE MRP_Shipping_Org_Handlers AUTHID CURRENT_USER AS
2 /* $Header: MRPHSHOS.pls 115.1 99/07/16 12:23:16 porting ship $ */
3
4 -- Procedure Update_Row
5
6 PROCEDURE Update_Row
7 ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
8 );
9
10 -- Procedure Insert_Row
11
12 PROCEDURE Insert_Row
13 ( p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
14 );
15
16 -- Procedure Delete_Row
17
18 PROCEDURE Delete_Row
19 ( p_Sr_Source_Id IN NUMBER
20 );
21
22 -- Procedure lock_Row
23 --
24
25 PROCEDURE Lock_Row
26 ( x_return_status OUT VARCHAR2
27 , p_Shipping_Org_rec IN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
28 , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
29 );
30
31 -- Function Query_Row
32
33 FUNCTION Query_Row
34 ( p_Sr_Source_Id IN NUMBER
35 ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type;
36
37 -- Procedure Query_Entity
38
39 PROCEDURE Query_Entity
40 ( p_Sr_Source_Id IN NUMBER
41 , x_Shipping_Org_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Rec_Type
42 , x_Shipping_Org_val_rec OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Rec_Type
43 );
44
45 -- Function Query_Rows
46
47 --
48
49 FUNCTION Query_Rows
50 ( p_Sr_Source_Id IN NUMBER :=
51 FND_API.G_MISS_NUM
52 , p_Sr_Receipt_Id IN NUMBER :=
53 FND_API.G_MISS_NUM
54 ) RETURN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type;
55
56 -- Procedure Query_Entities
57
58 --
59
60 PROCEDURE Query_Entities
61 ( p_Sr_Source_Id IN NUMBER :=
62 FND_API.G_MISS_NUM
63 , p_Sr_Receipt_Id IN NUMBER :=
64 FND_API.G_MISS_NUM
65 , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
66 , x_Shipping_Org_val_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Val_Tbl_Type
67 );
68
69 END MRP_Shipping_Org_Handlers;