PACKAGE: APPS.OE_HEADER_ADJ_ASSOCS_UTIL

Source

1 PACKAGE OE_Header_Adj_Assocs_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUHASS.pls 120.0 2005/06/01 01:55:19 appldev noship $ */
3 
4 PROCEDURE Query_Row
5 (   p_price_adj_assoc_id           IN  NUMBER
6 ,   x_Header_Adj_Assoc_Rec 		IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type);
7 
8 PROCEDURE Query_Rows
9 (   p_price_adj_Assoc_id           IN  NUMBER :=
10 							    FND_API.G_MISS_NUM
11 ,   p_price_adjustment_id          IN  NUMBER :=
12 							    FND_API.G_MISS_NUM
13 ,   x_Header_Adj_Assoc_Tbl 		IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
14 );
15 
16 PROCEDURE Insert_Row
17 ( p_Header_Adj_Assoc_Rec			IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
18 );
19 
20 PROCEDURE Update_Row
21 ( p_Header_Adj_Assoc_Rec			IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
22 );
23 
24 
25 PROCEDURE Delete_Row
26 ( p_price_adj_Assoc_id     NUMBER := FND_API.G_MISS_NUM
27 ,   p_price_adjustment_id     NUMBER := FND_API.G_MISS_NUM
28 )
29 ;
30 
31 --  Procedure Complete_Record
32 
33 PROCEDURE Complete_Record
34 (   p_x_Header_Adj_Assoc_rec      IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
35 ,   p_old_Header_Adj_Assoc_rec    IN  OE_Order_PUB.Header_Adj_Assoc_Rec_Type
36 );
37 
38 
39 --  Procedure Convert_Miss_To_Null
40 
41 PROCEDURE Convert_Miss_To_Null
42 (   p_x_Header_Adj_Assoc_rec        IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
43 );
44 
45 
46 --  Procedure Apply_Attribute_Changes
47 
48 PROCEDURE Apply_Attribute_Changes
49 (   p_x_Header_Adj_Assoc_rec      IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
50 ,   p_old_Header_Adj_Assoc_rec    IN  OE_Order_PUB.Header_Adj_Assoc_Rec_Type := OE_Order_PUB.G_MISS_Header_Adj_Assoc_REC
51 -- ,   x_Header_Adj_Assoc_rec     OUT OE_Order_PUB.Header_Adj_Assoc_Rec_Type
52 );
53 
54 PROCEDURE Lock_Row
55 ( x_return_status OUT NOCOPY VARCHAR2
56 
57 ,   p_x_Header_Adj_Assoc_rec       IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
58 ,   p_price_adj_assoc_id			IN NUMBER := FND_API.G_MISS_NUM
59 );
60 
61 PROCEDURE Lock_Rows
62 (   p_price_adj_assoc_id		IN NUMBER
63 							:= FND_API.G_MISS_NUM
64 ,   p_price_adjustment_id	IN NUMBER
65 							:= FND_API.G_MISS_NUM
66 ,   x_Header_Adj_Assoc_tbl     OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
67 , x_return_status OUT NOCOPY VARCHAR2
68 
69 );
70 
71 END OE_Header_Adj_Assocs_Util;