1 PACKAGE AMS_PRICE_PVT as
2 /* $Header: amsvprcs.pls 120.0 2005/05/31 15:35:17 appldev noship $ */
3
4
5 g_pkg_name CONSTANT VARCHAR2(30) :='AMS_PRICE_PVT';
6
7
8 -- test part--
9 Procedure getReqLineAttrAndQual(
10 p_inventory_item_id IN NUMBER
11 ,p_uom_code IN VARCHAR2
12 ,p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
13 ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
14 ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
15 ,p_line_index IN NUMBER
16 ,p_request_type_code IN VARCHAR2
17 ,px_req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
18 ,px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.qual_TBL_TYPE
19 );
20
21 Procedure getReqHeaderAttrAndQual(
22 p_party_id IN NUMBER := FND_API.G_MISS_NUM
23 ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
24 ,p_price_list_id IN NUMBER := FND_API.G_MISS_NUM
25 ,p_line_index IN NUMBER
26 ,p_request_type_code IN VARCHAR2
27 ,px_req_line_attr_tbl IN OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
28 ,px_req_qual_tbl IN OUT NOCOPY QP_PREQ_GRP.qual_TBL_TYPE
29 );
30
31 -- 2.a [using qp] get price of one item base on price_list_id
32 PROCEDURE GetPrice(
33 p_price_list_id IN NUMBER
34 ,p_currency_code IN VARCHAR2
35 ,p_inventory_item_id IN NUMBER
36 ,p_uom_code IN VARCHAR2
37 ,p_request_type_code IN VARCHAR2
38 ,p_pricing_event IN VARCHAR2
39 ,x_listprice OUT NOCOPY NUMBER
40 ,x_bestprice OUT NOCOPY NUMBER
41 ,x_status_code OUT NOCOPY VARCHAR2
42 ,x_status_text OUT NOCOPY VARCHAR2
43 );
44
45 --2.b [using qp] get price of one item base on party_id and cust_account_id
46 PROCEDURE GetPrice(
47 p_party_id IN NUMBER
48 ,p_cust_account_id IN NUMBER
49 ,p_currency_code IN VARCHAR2
50 ,p_inventory_item_id IN NUMBER
51 ,p_uom_code IN VARCHAR2
52 -- ,p_calculate_flag IN CHAR(1) :='Y'
53 ,p_request_type_code IN VARCHAR2
54 ,p_pricing_event IN VARCHAR2
55 ,x_listprice OUT NOCOPY NUMBER
56 ,x_bestprice OUT NOCOPY NUMBER
57 ,x_status_code OUT NOCOPY VARCHAR2
58 ,x_status_text OUT NOCOPY VARCHAR2
59 );
60
61 --2.b1 [using qp] get price of one item base on price_list_id, party_id and cust_account_id
62 PROCEDURE GetPrice(
63 p_price_list_id IN NUMBER
64 ,p_party_id IN NUMBER
65 ,p_cust_account_id IN NUMBER
66 ,p_currency_code IN VARCHAR2
67 ,p_inventory_item_id IN NUMBER
68 ,p_uom_code IN VARCHAR2
69 -- ,p_calculate_flag IN CHAR(1) :='Y'
70 ,p_request_type_code IN VARCHAR2
71 ,p_pricing_event IN VARCHAR2
72 ,x_listprice OUT NOCOPY NUMBER
73 ,x_bestprice OUT NOCOPY NUMBER
74 ,x_status_code OUT NOCOPY VARCHAR2
75 ,x_status_text OUT NOCOPY VARCHAR2
76 );
77
78 -- 2.c [using qp] get price of one item base on price_list_id for service support
79 PROCEDURE GetPrice(
80 p_price_list_id IN NUMBER
81 ,p_currency_code IN VARCHAR2
82 ,p_inventory_item_id IN NUMBER
83 ,p_uom_code IN VARCHAR2
84 ,p_related_inventory_item_id IN NUMBER
85 ,p_related_uom_code IN VARCHAR2
86 -- ,p_calculate_flag IN CHAR(1) :='Y'
87 ,p_request_type_code IN VARCHAR2
88 ,p_pricing_event IN VARCHAR2
89 ,x_listprice OUT NOCOPY NUMBER
90 ,x_bestprice OUT NOCOPY NUMBER
91 ,x_status_code OUT NOCOPY VARCHAR2
92 ,x_status_text OUT NOCOPY VARCHAR2
93 ,x_related_listprice OUT NOCOPY NUMBER
94 ,x_related_bestprice OUT NOCOPY NUMBER
95 ,x_related_status_code OUT NOCOPY VARCHAR2
96 ,x_related_status_text OUT NOCOPY VARCHAR2
97 );
98
99 -- 2.d [using qp] get price of one item base customer info for service support
100 PROCEDURE GetPrice(
101 p_party_id IN NUMBER
102 ,p_cust_account_id IN NUMBER
103 ,p_currency_code IN VARCHAR2
104 ,p_inventory_item_id IN NUMBER
105 ,p_uom_code IN VARCHAR2
106 ,p_related_inventory_item_id IN NUMBER
107 ,p_related_uom_code IN VARCHAR2
108 -- ,p_calculate_flag IN CHAR(1) :='Y'
109 ,p_request_type_code IN VARCHAR2
110 ,p_pricing_event IN VARCHAR2
111 ,x_listprice OUT NOCOPY NUMBER
112 ,x_bestprice OUT NOCOPY NUMBER
113 ,x_status_code OUT NOCOPY VARCHAR2
114 ,x_status_text OUT NOCOPY VARCHAR2
115 ,x_related_listprice OUT NOCOPY NUMBER
116 ,x_related_bestprice OUT NOCOPY NUMBER
117 ,x_related_status_code OUT NOCOPY VARCHAR2
118 ,x_related_status_text OUT NOCOPY VARCHAR2
119 );
120
121 -- 2.d1 [using qp] get price of one item based on price list and customer info
122 -- for service support
123 PROCEDURE GetPrice(
124 p_price_list_id IN NUMBER
125 ,p_party_id IN NUMBER
126 ,p_cust_account_id IN NUMBER
127 ,p_currency_code IN VARCHAR2
128 ,p_inventory_item_id IN NUMBER
129 ,p_uom_code IN VARCHAR2
130 ,p_related_inventory_item_id IN NUMBER
131 ,p_related_uom_code IN VARCHAR2
132 -- ,p_calculate_flag IN CHAR(1) :='Y'
133 ,p_request_type_code IN VARCHAR2
134 ,p_pricing_event IN VARCHAR2
135 ,x_listprice OUT NOCOPY NUMBER
136 ,x_bestprice OUT NOCOPY NUMBER
137 ,x_status_code OUT NOCOPY VARCHAR2
138 ,x_status_text OUT NOCOPY VARCHAR2
139 ,x_related_listprice OUT NOCOPY NUMBER
140 ,x_related_bestprice OUT NOCOPY NUMBER
141 ,x_related_status_code OUT NOCOPY VARCHAR2
142 ,x_related_status_text OUT NOCOPY VARCHAR2
143 );
144
145
146
147 -- 2.e [using qp] get prices for a list of items based on price_list_id
148 PROCEDURE GetPrices(
149 p_price_list_id IN NUMBER
150 ,p_currency_code IN VARCHAR2
151 ,p_item_tbl IN JTF_NUMBER_TABLE
152 ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
153 -- ,p_calculate_flag IN CHAR(1) :='Y'
154 ,p_request_type_code IN VARCHAR2
155 ,p_pricing_event IN VARCHAR2
156 ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
157 ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
158 ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
159 ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
160 ,x_return_status out NOCOPY VARCHAR2
161 ,x_return_status_text out NOCOPY VARCHAR2
162
163 );
164
165 -- 2.f [using qp] get prices of a list of items based on party_id and cust_account_id
166 PROCEDURE GetPrices(
167 p_party_id IN NUMBER
168 ,p_cust_account_id IN NUMBER
169 ,p_currency_code IN VARCHAR2
170 ,p_item_tbl IN JTF_NUMBER_TABLE
171 ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
172 -- ,p_calculate_flag IN CHAR(1) :='Y'
173 ,p_request_type_code IN VARCHAR2
174 ,p_pricing_event IN VARCHAR2
175 ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
176 ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
177 ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
178 ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
179 ,x_return_status OUT NOCOPY VARCHAR2
180 ,x_return_status_text OUT NOCOPY VARCHAR2
181
182 );
183
184 -- 2.f1 [using qp] get prices of a list of items based on price_list_id, party_id,
185 -- and cust_account_id
186 PROCEDURE GetPrices(
187 p_price_list_id IN NUMBER
188 ,p_party_id IN NUMBER
189 ,p_cust_account_id IN NUMBER
190 ,p_currency_code IN VARCHAR2
191 ,p_item_tbl IN JTF_NUMBER_TABLE
192 ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
193 -- ,p_calculate_flag IN CHAR(1) :='Y'
194 ,p_request_type_code IN VARCHAR2
195 ,p_pricing_event IN VARCHAR2
196 ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
197 ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
198 ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
199 ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
200 ,x_return_status out NOCOPY VARCHAR2
201 ,x_return_status_text out NOCOPY VARCHAR2
202
203 );
204
205
206 -- 2.g [using qp] get prices of a list of items based on price_list_id for service support
207 PROCEDURE GetPrices(
208 p_price_list_id IN NUMBER
209 ,p_currency_code IN VARCHAR2
210 ,p_item_tbl IN JTF_NUMBER_TABLE
211 ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
212 ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
213 ,p_childIndex_tbl IN JTF_NUMBER_TABLE
214 -- ,p_calculate_flag IN CHAR(1) :='Y'
215 ,p_request_type_code IN VARCHAR2
216 ,p_pricing_event IN VARCHAR2
217 ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
218 ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
219 ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
220 ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
221 ,x_parentIndex_tbl out NOCOPY JTF_NUMBER_TABLE
222 ,x_childIndex_tbl out NOCOPY JTF_NUMBER_TABLE
223 ,x_return_status out NOCOPY VARCHAR2
224 ,x_return_status_text out NOCOPY VARCHAR2
225
226 );
227
228
229
230 -- 2.h [using qp] get prices of a list of items based on party_id and cust_account_id
231 PROCEDURE GetPrices(
232 p_party_id IN NUMBER
233 ,p_cust_account_id IN number
234 ,p_currency_code IN VARCHAR2
235 ,p_item_tbl IN JTF_NUMBER_TABLE
236 ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
237 ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
238 ,p_childIndex_tbl IN JTF_NUMBER_TABLE
239 -- ,p_calculate_flag IN CHAR(1) :='Y'
240 ,p_request_type_code IN VARCHAR2
241 ,p_pricing_event IN VARCHAR2
242 ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
243 ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
244 ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
245 ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
246 ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
247 ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
248 ,x_return_status out nocopy varchar2
249 ,x_return_status_text out nocopy varchar2
250
251 );
252
253 -- 2.h1 [using qp] get prices of a list of items based on price_list_id,
254 -- party_id and cust_account_id
255 PROCEDURE GetPrices(
256 p_price_list_id IN NUMBER
257 ,p_party_id IN NUMBER
258 ,p_cust_account_id IN number
259 ,p_currency_code IN VARCHAR2
260 ,p_item_tbl IN JTF_NUMBER_TABLE
261 ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
262 ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
263 ,p_childIndex_tbl IN JTF_NUMBER_TABLE
264 -- ,p_calculate_flag IN CHAR(1) :='Y'
265 ,p_request_type_code IN VARCHAR2
266 ,p_pricing_event IN VARCHAR2
267 ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
268 ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
269 ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
270 ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
271 ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
272 ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
273 ,x_return_status out nocopy varchar2
274 ,x_return_status_text out nocopy varchar2
275
276 );
277
278
279
280 END AMS_PRICE_PVT;