215: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
216:
217: ,p_currency_code IN VARCHAR2
218: ,p_item_tbl IN JTF_NUMBER_TABLE
219: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
220: -- ,p_calculate_flag IN CHAR(1) :='Y'
221:
222: --gzhang 01/21/01, model bundle cache
223: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
219: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
220: -- ,p_calculate_flag IN CHAR(1) :='Y'
221:
222: --gzhang 01/21/01, model bundle cache
223: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
224:
225: ,p_request_type_code IN VARCHAR2
226: ,p_pricing_event IN VARCHAR2
227: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
225: ,p_request_type_code IN VARCHAR2
226: ,p_pricing_event IN VARCHAR2
227: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
228: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
229: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
230: ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
231: ,x_return_status out NOCOPY VARCHAR2
232: ,x_return_status_text out NOCOPY VARCHAR2
233:
243: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
244:
245: ,p_currency_code IN VARCHAR2
246: ,p_item_tbl IN JTF_NUMBER_TABLE
247: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
248: -- ,p_calculate_flag IN CHAR(1) :='Y'
249:
250: --gzhang 01/21/01, model bundle cache
251: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
247: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
248: -- ,p_calculate_flag IN CHAR(1) :='Y'
249:
250: --gzhang 01/21/01, model bundle cache
251: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
252:
253: ,p_request_type_code IN VARCHAR2
254: ,p_pricing_event IN VARCHAR2
255: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
253: ,p_request_type_code IN VARCHAR2
254: ,p_pricing_event IN VARCHAR2
255: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
256: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
257: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
258: ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
259: ,x_return_status OUT NOCOPY VARCHAR2
260: ,x_return_status_text OUT NOCOPY VARCHAR2
261:
273: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
274:
275: ,p_currency_code IN VARCHAR2
276: ,p_item_tbl IN JTF_NUMBER_TABLE
277: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
278: -- ,p_calculate_flag IN CHAR(1) :='Y'
279:
280: --gzhang 01/21/01, model bundle cache
281: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
277: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
278: -- ,p_calculate_flag IN CHAR(1) :='Y'
279:
280: --gzhang 01/21/01, model bundle cache
281: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
282:
283: ,p_request_type_code IN VARCHAR2
284: ,p_pricing_event IN VARCHAR2
285: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
283: ,p_request_type_code IN VARCHAR2
284: ,p_pricing_event IN VARCHAR2
285: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
286: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
287: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
288: ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
289: ,x_return_status out NOCOPY VARCHAR2
290: ,x_return_status_text out NOCOPY VARCHAR2
291:
301: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
302:
303: ,p_currency_code IN VARCHAR2
304: ,p_item_tbl IN JTF_NUMBER_TABLE
305: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
306: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
307: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
308: -- ,p_calculate_flag IN CHAR(1) :='Y'
309:
307: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
308: -- ,p_calculate_flag IN CHAR(1) :='Y'
309:
310: --gzhang 01/21/01, model bundle cache
311: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
312:
313: ,p_request_type_code IN VARCHAR2
314: ,p_pricing_event IN VARCHAR2
315: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
313: ,p_request_type_code IN VARCHAR2
314: ,p_pricing_event IN VARCHAR2
315: ,x_listprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
316: ,x_bestprice_tbl OUT NOCOPY JTF_NUMBER_TABLE
317: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
318: ,x_status_text_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
319: ,x_parentIndex_tbl out NOCOPY JTF_NUMBER_TABLE
320: ,x_childIndex_tbl out NOCOPY JTF_NUMBER_TABLE
321: ,x_return_status out NOCOPY VARCHAR2
335: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
336:
337: ,p_currency_code IN VARCHAR2
338: ,p_item_tbl IN JTF_NUMBER_TABLE
339: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
340: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
341: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
342: -- ,p_calculate_flag IN CHAR(1) :='Y'
343:
341: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
342: -- ,p_calculate_flag IN CHAR(1) :='Y'
343:
344: --gzhang 01/21/01, model bundle cache
345: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
346:
347: ,p_request_type_code IN VARCHAR2
348: ,p_pricing_event IN VARCHAR2
349: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
347: ,p_request_type_code IN VARCHAR2
348: ,p_pricing_event IN VARCHAR2
349: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
350: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
351: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
352: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
353: ,x_parentIndex_tbl out NOCOPY JTF_NUMBER_TABLE
354: ,x_childIndex_tbl out NOCOPY JTF_NUMBER_TABLE
355: ,x_return_status out nocopy varchar2
369: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
370:
371: ,p_currency_code IN VARCHAR2
372: ,p_item_tbl IN JTF_NUMBER_TABLE
373: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
374: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
375: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
376: -- ,p_calculate_flag IN CHAR(1) :='Y'
377:
375: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
376: -- ,p_calculate_flag IN CHAR(1) :='Y'
377:
378: --gzhang 01/21/01, model bundle cache
379: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
380:
381: ,p_request_type_code IN VARCHAR2
382: ,p_pricing_event IN VARCHAR2
383: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
381: ,p_request_type_code IN VARCHAR2
382: ,p_pricing_event IN VARCHAR2
383: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
384: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
385: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
386: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
387: ,x_parentIndex_tbl out NOCOPY JTF_NUMBER_TABLE
388: ,x_childIndex_tbl out NOCOPY JTF_NUMBER_TABLE
389: ,x_return_status out nocopy varchar2
405: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
406: ,p_request_type_code IN VARCHAR2 := 'ASO'
407: ,p_pricing_event IN VARCHAR2
408: ,x_price_csr OUT NOCOPY PRICE_REFCURSOR_TYPE
409: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
410: ,x_return_status OUT NOCOPY VARCHAR2
411: ,x_return_status_text OUT NOCOPY VARCHAR2
412: );
413:
417: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
418: ,p_currency_code IN VARCHAR2
419: ,p_minisite_id IN NUMBER := NULL
420: ,p_item_tbl IN JTF_NUMBER_TABLE
421: ,p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100
422: ,p_model_id_tbl IN JTF_NUMBER_TABLE
423: ,p_line_quantity_tbl IN JTF_NUMBER_TABLE
424: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := NULL
425: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := NULL
425: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := NULL
426: ,p_request_type_code IN VARCHAR2 := 'ASO'
427: ,p_pricing_event IN VARCHAR2
428: ,x_price_csr OUT NOCOPY PRICE_REFCURSOR_TYPE
429: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
430: ,x_return_status OUT NOCOPY VARCHAR2
431: ,x_return_status_text OUT NOCOPY VARCHAR2
432: );
433: