[Home] [Help]
PACKAGE: APPS.OE_PRICING_CONT_PVT
Source
1 PACKAGE OE_Pricing_Cont_PVT AS
2 /* $Header: OEXVPRCS.pls 120.1 2005/06/09 04:45:29 appldev $ */
3
4 -- Start of Comments
5 -- API name Process_Pricing_Cont
6 -- Type Private
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 PROCEDURE Process_Pricing_Cont
21 ( p_api_version_number IN NUMBER
22 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 , p_commit IN VARCHAR2 := FND_API.G_FALSE
24 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25 , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
26 OE_GLOBALS.G_MISS_CONTROL_REC
27 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
31 OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
32 , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
33 OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
34 , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
35 OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
36 , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
37 OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
38 , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
39 OE_Price_List_PUB.G_MISS_PRICE_List_REC
40 , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
41 OE_Price_List_PUB.G_MISS_PRICE_List_REC
42 , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
43 OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
44 , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
45 OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
46 , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
47 OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
48 , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
49 OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
50 , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
51 OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
52 , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
53 OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
54 , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
55 OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
56 , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
57 OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
58 , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
59 OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
60 , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
61 OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
62 , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
63 , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
64 , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
65 , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
66 , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
67 , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
68 , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
69 , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
70 );
71
72 -- Start of Comments
73 -- API name Lock_Pricing_Cont
74 -- Type Private
75 -- Function
76 --
77 -- Pre-reqs
78 --
79 -- Parameters
80 --
81 -- Version Current version = 1.0
82 -- Initial version = 1.0
83 --
84 -- Notes
85 --
86 -- End of Comments
87
88 PROCEDURE Lock_Pricing_Cont
89 ( p_api_version_number IN NUMBER
90 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
91 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
93 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
95 OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
96 , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
97 OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
98 , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
99 OE_Price_List_PUB.G_MISS_PRICE_List_REC
100 , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
101 OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
102 , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
103 OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
104 , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
105 OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
106 , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
107 OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
108 , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
109 OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
110 , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
111 , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
112 , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
113 , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
114 , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
115 , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
116 , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
117 , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
118 );
119
120 -- Start of Comments
121 -- API name Get_Pricing_Cont
122 -- Type Private
123 -- Function
124 --
125 -- Pre-reqs
126 --
127 -- Parameters
128 --
129 -- Version Current version = 1.0
130 -- Initial version = 1.0
131 --
132 -- Notes
133 --
134 -- End of Comments
135
136 PROCEDURE Get_Pricing_Cont
137 ( p_api_version_number IN NUMBER
138 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
139 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
141 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
142 , p_pricing_contract_id IN NUMBER
143 , p_name IN VARCHAR2
144 , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
145 , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
146 , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
147 , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
148 , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
149 , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
150 , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
151 , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
152 );
153
154
155 /*Included this procedure in public to be used by vgulati for his upgrade script to upgrade agreements -- spgopal*/
156
157 PROCEDURE Create_Agreement_Qualifier
158 (p_list_header_id IN NUMBER,
159 p_old_list_header_id IN NUMBER,
160 p_Agreement_id IN NUMBER,
161 p_operation IN VARCHAR2,
162 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
163
164 END OE_Pricing_Cont_PVT;