DBA Data[Home] [Help]

APPS.IBE_PRICE_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 219: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

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

Line 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

Line 229: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

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:

Line 247: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

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

Line 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

Line 257: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

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:

Line 277: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

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

Line 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

Line 287: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

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:

Line 305: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

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:

Line 311: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

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

Line 317: ,x_status_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

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

Line 339: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

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:

Line 345: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

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

Line 351: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

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

Line 373: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

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:

Line 379: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

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

Line 385: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

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

Line 409: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

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:

Line 421: ,p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100

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

Line 429: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

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: