APPS.AMS_PRICE_PVT dependencies on JTF_NUMBER_TABLE

Line 151: ,p_item_tbl IN JTF_NUMBER_TABLE

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

Line 156: ,x_listprice_tbl OUT NOCOPY 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

Line 157: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE

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

Line 170: ,p_item_tbl IN JTF_NUMBER_TABLE

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

Line 175: ,x_listprice_tbl OUT NOCOPY 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

Line 176: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE

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

Line 191: ,p_item_tbl IN JTF_NUMBER_TABLE

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

Line 196: ,x_listprice_tbl OUT NOCOPY 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

Line 197: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE

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

Line 210: ,p_item_tbl IN JTF_NUMBER_TABLE

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'

Line 212: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE

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

Line 213: ,p_childIndex_tbl IN JTF_NUMBER_TABLE

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

Line 217: ,x_listprice_tbl OUT NOCOPY 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

Line 218: ,x_bestprice_tbl OUT NOCOPY 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

Line 221: ,x_parentIndex_tbl out NOCOPY JTF_NUMBER_TABLE

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:

Line 222: ,x_childIndex_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: );

Line 235: ,p_item_tbl IN JTF_NUMBER_TABLE

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'

Line 237: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE

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

Line 238: ,p_childIndex_tbl IN JTF_NUMBER_TABLE

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

Line 242: ,x_listprice_tbl OUT nocopy 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

Line 243: ,x_bestprice_tbl OUT nocopy 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

Line 246: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

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:

Line 247: ,x_childIndex_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: );

Line 260: ,p_item_tbl IN JTF_NUMBER_TABLE

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'

Line 262: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE

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

Line 263: ,p_childIndex_tbl IN JTF_NUMBER_TABLE

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

Line 267: ,x_listprice_tbl OUT nocopy 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

Line 268: ,x_bestprice_tbl OUT nocopy 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

Line 271: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

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:

Line 272: ,x_childIndex_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: );