PACKAGE: APPS.OE_LINE_ADJ_ASSOCS_UTIL

Source

1 PACKAGE OE_Line_Adj_Assocs_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXULASS.pls 120.0.12020000.2 2013/02/13 10:23:01 nilegupt ship $ */
3 
4 PROCEDURE Query_Row
5 (   p_price_adj_assoc_id           IN  NUMBER
6 ,   x_Line_Adj_Assoc_Rec			IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
7 );
8 
9 PROCEDURE Query_Rows
10 (   p_price_adj_Assoc_id           IN  NUMBER :=
11 							    FND_API.G_MISS_NUM
12 ,   p_price_adjustment_id          IN  NUMBER :=
13 							    FND_API.G_MISS_NUM
14 ,   x_Line_Adj_Assoc_Tbl			IN OUT NOCOPY  OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
15 );
16 
17 PROCEDURE Insert_Row
18 ( p_Line_Adj_Assoc_Rec			IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
19 );
20 
21 PROCEDURE Update_Row
22 ( p_Line_Adj_Assoc_Rec			IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
23 );
24 
25 
26 PROCEDURE Delete_Row
27 ( p_price_adj_Assoc_id     NUMBER := FND_API.G_MISS_NUM
28 ,   p_price_adjustment_id     NUMBER := FND_API.G_MISS_NUM
29 )
30 ;
31 --  Procedure Complete_Record
32 
33 PROCEDURE Complete_Record
34 (   p_x_Line_Adj_Assoc_rec      IN OUT NOCOPY  OE_Order_PUB.Line_Adj_Assoc_Rec_Type
35 ,   p_old_Line_Adj_Assoc_rec    IN  OE_Order_PUB.Line_Adj_Assoc_Rec_Type
36 );
37 
38 
39 --  Procedure Convert_Miss_To_Null
40 
41 PROCEDURE Convert_Miss_To_Null
42 (   p_x_Line_Adj_Assoc_rec        IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
43 );
44 
45 
46 --  Procedure Apply_Attribute_Changes
47 
48 PROCEDURE Apply_Attribute_Changes
49 (   p_x_Line_Adj_Assoc_rec      IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
50 ,   p_old_Line_Adj_Assoc_rec    IN  OE_Order_PUB.Line_Adj_Assoc_Rec_Type := OE_Order_PUB.G_MISS_Line_Adj_Assoc_REC
51 -- ,   x_Line_Adj_Assoc_rec     OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type
52 );
53 
54 PROCEDURE Lock_Row
55 ( x_return_status OUT NOCOPY VARCHAR2
56 
57 ,   p_x_Line_Adj_Assoc_rec       	IN OUT NOCOPY  OE_Order_PUB.Line_Adj_Assoc_Rec_Type
58 ,   p_price_adj_assoc_id			IN NUMBER := FND_API.G_MISS_NUM
59 -- ,   x_Line_Adj_Assoc_rec      	OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type
60 );
61 
62 PROCEDURE Lock_Rows
63 (   p_price_adj_assoc_id		  IN NUMBER
64 							:= FND_API.G_MISS_NUM
65 ,   p_price_adjustment_id	  IN NUMBER
66 							:= FND_API.G_MISS_NUM
67 ,   x_Line_Adj_Assoc_tbl        OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
68 , x_return_status OUT NOCOPY VARCHAR2
69 
70 );
71 --bug 16317238
72 PROCEDURE copy_assoc_lines(
73 	p_from_line_id		IN	number
74 	,p_to_line_id		IN	NUMBER
75   ,p_from_pr_adjustment_id IN NUMBER
76   ,p_from_rltd_padj_id   IN NUMBER
77   ,p_prg_list_line_id    IN  NUMBER
78   ,p_assoc_list_line_id  IN  NUMBER
79 ,x_return_status out nocopy varchar2);
80 
81 END OE_Line_Adj_Assocs_Util;