DBA Data[Home] [Help]

APPS.OKL_QUICK_QUOTES_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 29: procedure rosetta_table_copy_in_p12(t out nocopy okl_quick_quotes_pvt.item_order_estimate_tbl, a0 JTF_VARCHAR2_TABLE_300

25: , a2 out nocopy JTF_NUMBER_TABLE
26: , a3 out nocopy JTF_DATE_TABLE
27: );
28:
29: procedure rosetta_table_copy_in_p12(t out nocopy okl_quick_quotes_pvt.item_order_estimate_tbl, a0 JTF_VARCHAR2_TABLE_300
30: , a1 JTF_VARCHAR2_TABLE_300
31: , a2 JTF_NUMBER_TABLE
32: , a3 JTF_NUMBER_TABLE
33: , a4 JTF_NUMBER_TABLE

Line 30: , a1 JTF_VARCHAR2_TABLE_300

26: , a3 out nocopy JTF_DATE_TABLE
27: );
28:
29: procedure rosetta_table_copy_in_p12(t out nocopy okl_quick_quotes_pvt.item_order_estimate_tbl, a0 JTF_VARCHAR2_TABLE_300
30: , a1 JTF_VARCHAR2_TABLE_300
31: , a2 JTF_NUMBER_TABLE
32: , a3 JTF_NUMBER_TABLE
33: , a4 JTF_NUMBER_TABLE
34: , a5 JTF_NUMBER_TABLE

Line 38: procedure rosetta_table_copy_out_p12(t okl_quick_quotes_pvt.item_order_estimate_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300

34: , a5 JTF_NUMBER_TABLE
35: , a6 JTF_NUMBER_TABLE
36: , a7 JTF_DATE_TABLE
37: );
38: procedure rosetta_table_copy_out_p12(t okl_quick_quotes_pvt.item_order_estimate_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
39: , a1 out nocopy JTF_VARCHAR2_TABLE_300
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_NUMBER_TABLE

Line 39: , a1 out nocopy JTF_VARCHAR2_TABLE_300

35: , a6 JTF_NUMBER_TABLE
36: , a7 JTF_DATE_TABLE
37: );
38: procedure rosetta_table_copy_out_p12(t okl_quick_quotes_pvt.item_order_estimate_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
39: , a1 out nocopy JTF_VARCHAR2_TABLE_300
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_NUMBER_TABLE

Line 189: , p7_a28 JTF_VARCHAR2_TABLE_300

185: , p7_a24 JTF_NUMBER_TABLE
186: , p7_a25 JTF_NUMBER_TABLE
187: , p7_a26 JTF_NUMBER_TABLE
188: , p7_a27 JTF_NUMBER_TABLE
189: , p7_a28 JTF_VARCHAR2_TABLE_300
190: , p7_a29 JTF_VARCHAR2_TABLE_2000
191: , p7_a30 JTF_VARCHAR2_TABLE_2000
192: , p8_a0 out nocopy JTF_NUMBER_TABLE
193: , p8_a1 out nocopy JTF_NUMBER_TABLE

Line 220: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300

216: , p8_a24 out nocopy JTF_NUMBER_TABLE
217: , p8_a25 out nocopy JTF_NUMBER_TABLE
218: , p8_a26 out nocopy JTF_NUMBER_TABLE
219: , p8_a27 out nocopy JTF_NUMBER_TABLE
220: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300
221: , p8_a29 out nocopy JTF_VARCHAR2_TABLE_2000
222: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_2000
223: );
224: procedure update_quick_qte(p_api_version NUMBER

Line 365: , p7_a28 JTF_VARCHAR2_TABLE_300

361: , p7_a24 JTF_NUMBER_TABLE
362: , p7_a25 JTF_NUMBER_TABLE
363: , p7_a26 JTF_NUMBER_TABLE
364: , p7_a27 JTF_NUMBER_TABLE
365: , p7_a28 JTF_VARCHAR2_TABLE_300
366: , p7_a29 JTF_VARCHAR2_TABLE_2000
367: , p7_a30 JTF_VARCHAR2_TABLE_2000
368: , p8_a0 out nocopy JTF_NUMBER_TABLE
369: , p8_a1 out nocopy JTF_NUMBER_TABLE

Line 396: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300

392: , p8_a24 out nocopy JTF_NUMBER_TABLE
393: , p8_a25 out nocopy JTF_NUMBER_TABLE
394: , p8_a26 out nocopy JTF_NUMBER_TABLE
395: , p8_a27 out nocopy JTF_NUMBER_TABLE
396: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300
397: , p8_a29 out nocopy JTF_VARCHAR2_TABLE_2000
398: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_2000
399: );
400: procedure delete_qql(p_api_version NUMBER

Line 470: , p5_a28 JTF_VARCHAR2_TABLE_300

466: , p5_a24 JTF_NUMBER_TABLE
467: , p5_a25 JTF_NUMBER_TABLE
468: , p5_a26 JTF_NUMBER_TABLE
469: , p5_a27 JTF_NUMBER_TABLE
470: , p5_a28 JTF_VARCHAR2_TABLE_300
471: , p5_a29 JTF_VARCHAR2_TABLE_2000
472: , p5_a30 JTF_VARCHAR2_TABLE_2000
473: );
474: procedure handle_quick_quote(p_api_version NUMBER

Line 561: , p6_a28 JTF_VARCHAR2_TABLE_300

557: , p6_a24 JTF_NUMBER_TABLE
558: , p6_a25 JTF_NUMBER_TABLE
559: , p6_a26 JTF_NUMBER_TABLE
560: , p6_a27 JTF_NUMBER_TABLE
561: , p6_a28 JTF_VARCHAR2_TABLE_300
562: , p6_a29 JTF_VARCHAR2_TABLE_2000
563: , p6_a30 JTF_VARCHAR2_TABLE_2000
564: , p7_a0 VARCHAR2
565: , p7_a1 NUMBER

Line 612: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300

608: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
609: , p13_a1 out nocopy JTF_NUMBER_TABLE
610: , p13_a2 out nocopy JTF_NUMBER_TABLE
611: , p13_a3 out nocopy JTF_DATE_TABLE
612: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
613: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_300
614: , p14_a2 out nocopy JTF_NUMBER_TABLE
615: , p14_a3 out nocopy JTF_NUMBER_TABLE
616: , p14_a4 out nocopy JTF_NUMBER_TABLE

Line 613: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_300

609: , p13_a1 out nocopy JTF_NUMBER_TABLE
610: , p13_a2 out nocopy JTF_NUMBER_TABLE
611: , p13_a3 out nocopy JTF_DATE_TABLE
612: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
613: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_300
614: , p14_a2 out nocopy JTF_NUMBER_TABLE
615: , p14_a3 out nocopy JTF_NUMBER_TABLE
616: , p14_a4 out nocopy JTF_NUMBER_TABLE
617: , p14_a5 out nocopy JTF_NUMBER_TABLE

Line 702: , p16_a28 out nocopy JTF_VARCHAR2_TABLE_300

698: , p16_a24 out nocopy JTF_NUMBER_TABLE
699: , p16_a25 out nocopy JTF_NUMBER_TABLE
700: , p16_a26 out nocopy JTF_NUMBER_TABLE
701: , p16_a27 out nocopy JTF_NUMBER_TABLE
702: , p16_a28 out nocopy JTF_VARCHAR2_TABLE_300
703: , p16_a29 out nocopy JTF_VARCHAR2_TABLE_2000
704: , p16_a30 out nocopy JTF_VARCHAR2_TABLE_2000
705: );
706: procedure cancel_quick_quote(p_api_version NUMBER