DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 94: , a1 JTF_VARCHAR2_TABLE_100

90: end if;
91: end rosetta_table_copy_out_p17;
92:
93: procedure rosetta_table_copy_in_p19(t out nocopy okl_am_create_quote_pvt.achr_tbl_type, a0 JTF_VARCHAR2_TABLE_200
94: , a1 JTF_VARCHAR2_TABLE_100
95: , a2 JTF_NUMBER_TABLE
96: , a3 JTF_VARCHAR2_TABLE_200
97: , a4 JTF_DATE_TABLE
98: , a5 JTF_DATE_TABLE

Line 101: , a8 JTF_VARCHAR2_TABLE_100

97: , a4 JTF_DATE_TABLE
98: , a5 JTF_DATE_TABLE
99: , a6 JTF_DATE_TABLE
100: , a7 JTF_DATE_TABLE
101: , a8 JTF_VARCHAR2_TABLE_100
102: , a9 JTF_VARCHAR2_TABLE_100
103: , a10 JTF_NUMBER_TABLE
104: , a11 JTF_VARCHAR2_TABLE_400
105: ) as

Line 102: , a9 JTF_VARCHAR2_TABLE_100

98: , a5 JTF_DATE_TABLE
99: , a6 JTF_DATE_TABLE
100: , a7 JTF_DATE_TABLE
101: , a8 JTF_VARCHAR2_TABLE_100
102: , a9 JTF_VARCHAR2_TABLE_100
103: , a10 JTF_NUMBER_TABLE
104: , a11 JTF_VARCHAR2_TABLE_400
105: ) as
106: ddindx binary_integer; indx binary_integer;

Line 135: , a1 out nocopy JTF_VARCHAR2_TABLE_100

131: end if;
132: end if;
133: end rosetta_table_copy_in_p19;
134: procedure rosetta_table_copy_out_p19(t okl_am_create_quote_pvt.achr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
135: , a1 out nocopy JTF_VARCHAR2_TABLE_100
136: , a2 out nocopy JTF_NUMBER_TABLE
137: , a3 out nocopy JTF_VARCHAR2_TABLE_200
138: , a4 out nocopy JTF_DATE_TABLE
139: , a5 out nocopy JTF_DATE_TABLE

Line 142: , a8 out nocopy JTF_VARCHAR2_TABLE_100

138: , a4 out nocopy JTF_DATE_TABLE
139: , a5 out nocopy JTF_DATE_TABLE
140: , a6 out nocopy JTF_DATE_TABLE
141: , a7 out nocopy JTF_DATE_TABLE
142: , a8 out nocopy JTF_VARCHAR2_TABLE_100
143: , a9 out nocopy JTF_VARCHAR2_TABLE_100
144: , a10 out nocopy JTF_NUMBER_TABLE
145: , a11 out nocopy JTF_VARCHAR2_TABLE_400
146: ) as

Line 143: , a9 out nocopy JTF_VARCHAR2_TABLE_100

139: , a5 out nocopy JTF_DATE_TABLE
140: , a6 out nocopy JTF_DATE_TABLE
141: , a7 out nocopy JTF_DATE_TABLE
142: , a8 out nocopy JTF_VARCHAR2_TABLE_100
143: , a9 out nocopy JTF_VARCHAR2_TABLE_100
144: , a10 out nocopy JTF_NUMBER_TABLE
145: , a11 out nocopy JTF_VARCHAR2_TABLE_400
146: ) as
147: ddindx binary_integer; indx binary_integer;

Line 151: a1 := JTF_VARCHAR2_TABLE_100();

147: ddindx binary_integer; indx binary_integer;
148: begin
149: if t is null or t.count = 0 then
150: a0 := JTF_VARCHAR2_TABLE_200();
151: a1 := JTF_VARCHAR2_TABLE_100();
152: a2 := JTF_NUMBER_TABLE();
153: a3 := JTF_VARCHAR2_TABLE_200();
154: a4 := JTF_DATE_TABLE();
155: a5 := JTF_DATE_TABLE();

Line 158: a8 := JTF_VARCHAR2_TABLE_100();

154: a4 := JTF_DATE_TABLE();
155: a5 := JTF_DATE_TABLE();
156: a6 := JTF_DATE_TABLE();
157: a7 := JTF_DATE_TABLE();
158: a8 := JTF_VARCHAR2_TABLE_100();
159: a9 := JTF_VARCHAR2_TABLE_100();
160: a10 := JTF_NUMBER_TABLE();
161: a11 := JTF_VARCHAR2_TABLE_400();
162: else

Line 159: a9 := JTF_VARCHAR2_TABLE_100();

155: a5 := JTF_DATE_TABLE();
156: a6 := JTF_DATE_TABLE();
157: a7 := JTF_DATE_TABLE();
158: a8 := JTF_VARCHAR2_TABLE_100();
159: a9 := JTF_VARCHAR2_TABLE_100();
160: a10 := JTF_NUMBER_TABLE();
161: a11 := JTF_VARCHAR2_TABLE_400();
162: else
163: a0 := JTF_VARCHAR2_TABLE_200();

Line 164: a1 := JTF_VARCHAR2_TABLE_100();

160: a10 := JTF_NUMBER_TABLE();
161: a11 := JTF_VARCHAR2_TABLE_400();
162: else
163: a0 := JTF_VARCHAR2_TABLE_200();
164: a1 := JTF_VARCHAR2_TABLE_100();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_VARCHAR2_TABLE_200();
167: a4 := JTF_DATE_TABLE();
168: a5 := JTF_DATE_TABLE();

Line 171: a8 := JTF_VARCHAR2_TABLE_100();

167: a4 := JTF_DATE_TABLE();
168: a5 := JTF_DATE_TABLE();
169: a6 := JTF_DATE_TABLE();
170: a7 := JTF_DATE_TABLE();
171: a8 := JTF_VARCHAR2_TABLE_100();
172: a9 := JTF_VARCHAR2_TABLE_100();
173: a10 := JTF_NUMBER_TABLE();
174: a11 := JTF_VARCHAR2_TABLE_400();
175: if t.count > 0 then

Line 172: a9 := JTF_VARCHAR2_TABLE_100();

168: a5 := JTF_DATE_TABLE();
169: a6 := JTF_DATE_TABLE();
170: a7 := JTF_DATE_TABLE();
171: a8 := JTF_VARCHAR2_TABLE_100();
172: a9 := JTF_VARCHAR2_TABLE_100();
173: a10 := JTF_NUMBER_TABLE();
174: a11 := JTF_VARCHAR2_TABLE_400();
175: if t.count > 0 then
176: a0.extend(t.count);

Line 219: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

215: , x_return_status out nocopy VARCHAR2
216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_200
219: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
220: , p6_a2 out nocopy JTF_NUMBER_TABLE
221: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
222: , p6_a4 out nocopy JTF_DATE_TABLE
223: , p6_a5 out nocopy JTF_DATE_TABLE

Line 226: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

222: , p6_a4 out nocopy JTF_DATE_TABLE
223: , p6_a5 out nocopy JTF_DATE_TABLE
224: , p6_a6 out nocopy JTF_DATE_TABLE
225: , p6_a7 out nocopy JTF_DATE_TABLE
226: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a10 out nocopy JTF_NUMBER_TABLE
229: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400
230: , p5_a0 VARCHAR2 := fnd_api.g_miss_char

Line 227: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

223: , p6_a5 out nocopy JTF_DATE_TABLE
224: , p6_a6 out nocopy JTF_DATE_TABLE
225: , p6_a7 out nocopy JTF_DATE_TABLE
226: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
228: , p6_a10 out nocopy JTF_NUMBER_TABLE
229: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400
230: , p5_a0 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

Line 513: , p7_a5 JTF_VARCHAR2_TABLE_100

509: , p7_a1 JTF_NUMBER_TABLE
510: , p7_a2 JTF_NUMBER_TABLE
511: , p7_a3 JTF_NUMBER_TABLE
512: , p7_a4 JTF_DATE_TABLE
513: , p7_a5 JTF_VARCHAR2_TABLE_100
514: , p7_a6 JTF_NUMBER_TABLE
515: , p7_a7 JTF_NUMBER_TABLE
516: , p7_a8 JTF_VARCHAR2_TABLE_600
517: , p7_a9 JTF_VARCHAR2_TABLE_100

Line 517: , p7_a9 JTF_VARCHAR2_TABLE_100

513: , p7_a5 JTF_VARCHAR2_TABLE_100
514: , p7_a6 JTF_NUMBER_TABLE
515: , p7_a7 JTF_NUMBER_TABLE
516: , p7_a8 JTF_VARCHAR2_TABLE_600
517: , p7_a9 JTF_VARCHAR2_TABLE_100
518: , p7_a10 JTF_VARCHAR2_TABLE_100
519: , p7_a11 JTF_VARCHAR2_TABLE_200
520: , p7_a12 JTF_VARCHAR2_TABLE_100
521: , p7_a13 JTF_VARCHAR2_TABLE_100

Line 518: , p7_a10 JTF_VARCHAR2_TABLE_100

514: , p7_a6 JTF_NUMBER_TABLE
515: , p7_a7 JTF_NUMBER_TABLE
516: , p7_a8 JTF_VARCHAR2_TABLE_600
517: , p7_a9 JTF_VARCHAR2_TABLE_100
518: , p7_a10 JTF_VARCHAR2_TABLE_100
519: , p7_a11 JTF_VARCHAR2_TABLE_200
520: , p7_a12 JTF_VARCHAR2_TABLE_100
521: , p7_a13 JTF_VARCHAR2_TABLE_100
522: , p7_a14 JTF_VARCHAR2_TABLE_200

Line 520: , p7_a12 JTF_VARCHAR2_TABLE_100

516: , p7_a8 JTF_VARCHAR2_TABLE_600
517: , p7_a9 JTF_VARCHAR2_TABLE_100
518: , p7_a10 JTF_VARCHAR2_TABLE_100
519: , p7_a11 JTF_VARCHAR2_TABLE_200
520: , p7_a12 JTF_VARCHAR2_TABLE_100
521: , p7_a13 JTF_VARCHAR2_TABLE_100
522: , p7_a14 JTF_VARCHAR2_TABLE_200
523: , p7_a15 JTF_NUMBER_TABLE
524: , p7_a16 JTF_DATE_TABLE

Line 521: , p7_a13 JTF_VARCHAR2_TABLE_100

517: , p7_a9 JTF_VARCHAR2_TABLE_100
518: , p7_a10 JTF_VARCHAR2_TABLE_100
519: , p7_a11 JTF_VARCHAR2_TABLE_200
520: , p7_a12 JTF_VARCHAR2_TABLE_100
521: , p7_a13 JTF_VARCHAR2_TABLE_100
522: , p7_a14 JTF_VARCHAR2_TABLE_200
523: , p7_a15 JTF_NUMBER_TABLE
524: , p7_a16 JTF_DATE_TABLE
525: , p7_a17 JTF_NUMBER_TABLE

Line 613: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100

609: , p8_a81 out nocopy NUMBER
610: , p8_a82 out nocopy VARCHAR2
611: , p9_a0 out nocopy JTF_NUMBER_TABLE
612: , p9_a1 out nocopy JTF_NUMBER_TABLE
613: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
614: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
615: , p9_a4 out nocopy JTF_NUMBER_TABLE
616: , p9_a5 out nocopy JTF_NUMBER_TABLE
617: , p9_a6 out nocopy JTF_NUMBER_TABLE

Line 614: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

610: , p8_a82 out nocopy VARCHAR2
611: , p9_a0 out nocopy JTF_NUMBER_TABLE
612: , p9_a1 out nocopy JTF_NUMBER_TABLE
613: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
614: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
615: , p9_a4 out nocopy JTF_NUMBER_TABLE
616: , p9_a5 out nocopy JTF_NUMBER_TABLE
617: , p9_a6 out nocopy JTF_NUMBER_TABLE
618: , p9_a7 out nocopy JTF_NUMBER_TABLE

Line 621: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

617: , p9_a6 out nocopy JTF_NUMBER_TABLE
618: , p9_a7 out nocopy JTF_NUMBER_TABLE
619: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
620: , p9_a9 out nocopy JTF_NUMBER_TABLE
621: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
622: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
623: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
624: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
625: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 622: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100

618: , p9_a7 out nocopy JTF_NUMBER_TABLE
619: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
620: , p9_a9 out nocopy JTF_NUMBER_TABLE
621: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
622: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
623: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
624: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
625: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_500
626: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 623: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100

619: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
620: , p9_a9 out nocopy JTF_NUMBER_TABLE
621: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
622: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
623: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
624: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
625: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_500
626: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_500
627: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 624: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100

620: , p9_a9 out nocopy JTF_NUMBER_TABLE
621: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
622: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
623: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
624: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
625: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_500
626: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_500
627: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_500
628: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 651: , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100

647: , p9_a36 out nocopy JTF_NUMBER_TABLE
648: , p9_a37 out nocopy JTF_DATE_TABLE
649: , p9_a38 out nocopy JTF_NUMBER_TABLE
650: , p9_a39 out nocopy JTF_DATE_TABLE
651: , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100
652: , p9_a41 out nocopy JTF_NUMBER_TABLE
653: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
654: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
655: , p9_a44 out nocopy JTF_VARCHAR2_TABLE_200

Line 653: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100

649: , p9_a38 out nocopy JTF_NUMBER_TABLE
650: , p9_a39 out nocopy JTF_DATE_TABLE
651: , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100
652: , p9_a41 out nocopy JTF_NUMBER_TABLE
653: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
654: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
655: , p9_a44 out nocopy JTF_VARCHAR2_TABLE_200
656: , p9_a45 out nocopy JTF_NUMBER_TABLE
657: , p9_a46 out nocopy JTF_NUMBER_TABLE

Line 654: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100

650: , p9_a39 out nocopy JTF_DATE_TABLE
651: , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100
652: , p9_a41 out nocopy JTF_NUMBER_TABLE
653: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
654: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
655: , p9_a44 out nocopy JTF_VARCHAR2_TABLE_200
656: , p9_a45 out nocopy JTF_NUMBER_TABLE
657: , p9_a46 out nocopy JTF_NUMBER_TABLE
658: , p9_a47 out nocopy JTF_NUMBER_TABLE

Line 665: , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100

661: , p9_a50 out nocopy JTF_NUMBER_TABLE
662: , p9_a51 out nocopy JTF_NUMBER_TABLE
663: , p9_a52 out nocopy JTF_NUMBER_TABLE
664: , p9_a53 out nocopy JTF_VARCHAR2_TABLE_200
665: , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
666: , p9_a55 out nocopy JTF_VARCHAR2_TABLE_100
667: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a57 out nocopy JTF_NUMBER_TABLE
669: , p9_a58 out nocopy JTF_DATE_TABLE

Line 666: , p9_a55 out nocopy JTF_VARCHAR2_TABLE_100

662: , p9_a51 out nocopy JTF_NUMBER_TABLE
663: , p9_a52 out nocopy JTF_NUMBER_TABLE
664: , p9_a53 out nocopy JTF_VARCHAR2_TABLE_200
665: , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
666: , p9_a55 out nocopy JTF_VARCHAR2_TABLE_100
667: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a57 out nocopy JTF_NUMBER_TABLE
669: , p9_a58 out nocopy JTF_DATE_TABLE
670: , p9_a59 out nocopy JTF_DATE_TABLE

Line 667: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_100

663: , p9_a52 out nocopy JTF_NUMBER_TABLE
664: , p9_a53 out nocopy JTF_VARCHAR2_TABLE_200
665: , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
666: , p9_a55 out nocopy JTF_VARCHAR2_TABLE_100
667: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a57 out nocopy JTF_NUMBER_TABLE
669: , p9_a58 out nocopy JTF_DATE_TABLE
670: , p9_a59 out nocopy JTF_DATE_TABLE
671: , p9_a60 out nocopy JTF_NUMBER_TABLE