DBA Data[Home] [Help]

APPS.OKL_SRM_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 27: , a5 JTF_VARCHAR2_TABLE_200

23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_VARCHAR2_TABLE_1000
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_2000
30: , a8 JTF_VARCHAR2_TABLE_500
31: , a9 JTF_VARCHAR2_TABLE_500

Line 29: , a7 JTF_VARCHAR2_TABLE_2000

25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_VARCHAR2_TABLE_1000
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_2000
30: , a8 JTF_VARCHAR2_TABLE_500
31: , a9 JTF_VARCHAR2_TABLE_500
32: , a10 JTF_VARCHAR2_TABLE_500
33: , a11 JTF_VARCHAR2_TABLE_500

Line 102: , a5 out nocopy JTF_VARCHAR2_TABLE_200

98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_VARCHAR2_TABLE_100
100: , a3 out nocopy JTF_VARCHAR2_TABLE_300
101: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
102: , a5 out nocopy JTF_VARCHAR2_TABLE_200
103: , a6 out nocopy JTF_VARCHAR2_TABLE_100
104: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
105: , a8 out nocopy JTF_VARCHAR2_TABLE_500
106: , a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 104: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

100: , a3 out nocopy JTF_VARCHAR2_TABLE_300
101: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
102: , a5 out nocopy JTF_VARCHAR2_TABLE_200
103: , a6 out nocopy JTF_VARCHAR2_TABLE_100
104: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
105: , a8 out nocopy JTF_VARCHAR2_TABLE_500
106: , a9 out nocopy JTF_VARCHAR2_TABLE_500
107: , a10 out nocopy JTF_VARCHAR2_TABLE_500
108: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 135: a5 := JTF_VARCHAR2_TABLE_200();

131: a1 := JTF_NUMBER_TABLE();
132: a2 := JTF_VARCHAR2_TABLE_100();
133: a3 := JTF_VARCHAR2_TABLE_300();
134: a4 := JTF_VARCHAR2_TABLE_1000();
135: a5 := JTF_VARCHAR2_TABLE_200();
136: a6 := JTF_VARCHAR2_TABLE_100();
137: a7 := JTF_VARCHAR2_TABLE_2000();
138: a8 := JTF_VARCHAR2_TABLE_500();
139: a9 := JTF_VARCHAR2_TABLE_500();

Line 137: a7 := JTF_VARCHAR2_TABLE_2000();

133: a3 := JTF_VARCHAR2_TABLE_300();
134: a4 := JTF_VARCHAR2_TABLE_1000();
135: a5 := JTF_VARCHAR2_TABLE_200();
136: a6 := JTF_VARCHAR2_TABLE_100();
137: a7 := JTF_VARCHAR2_TABLE_2000();
138: a8 := JTF_VARCHAR2_TABLE_500();
139: a9 := JTF_VARCHAR2_TABLE_500();
140: a10 := JTF_VARCHAR2_TABLE_500();
141: a11 := JTF_VARCHAR2_TABLE_500();

Line 165: a5 := JTF_VARCHAR2_TABLE_200();

161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_VARCHAR2_TABLE_100();
163: a3 := JTF_VARCHAR2_TABLE_300();
164: a4 := JTF_VARCHAR2_TABLE_1000();
165: a5 := JTF_VARCHAR2_TABLE_200();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_VARCHAR2_TABLE_2000();
168: a8 := JTF_VARCHAR2_TABLE_500();
169: a9 := JTF_VARCHAR2_TABLE_500();

Line 167: a7 := JTF_VARCHAR2_TABLE_2000();

163: a3 := JTF_VARCHAR2_TABLE_300();
164: a4 := JTF_VARCHAR2_TABLE_1000();
165: a5 := JTF_VARCHAR2_TABLE_200();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_VARCHAR2_TABLE_2000();
168: a8 := JTF_VARCHAR2_TABLE_500();
169: a9 := JTF_VARCHAR2_TABLE_500();
170: a10 := JTF_VARCHAR2_TABLE_500();
171: a11 := JTF_VARCHAR2_TABLE_500();

Line 263: , a2 JTF_VARCHAR2_TABLE_2000

259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_srm_pvt.srmv_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_VARCHAR2_TABLE_100
263: , a2 JTF_VARCHAR2_TABLE_2000
264: , a3 JTF_VARCHAR2_TABLE_200
265: , a4 JTF_VARCHAR2_TABLE_1000
266: , a5 JTF_NUMBER_TABLE
267: , a6 JTF_VARCHAR2_TABLE_300

Line 264: , a3 JTF_VARCHAR2_TABLE_200

260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_srm_pvt.srmv_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_VARCHAR2_TABLE_100
263: , a2 JTF_VARCHAR2_TABLE_2000
264: , a3 JTF_VARCHAR2_TABLE_200
265: , a4 JTF_VARCHAR2_TABLE_1000
266: , a5 JTF_NUMBER_TABLE
267: , a6 JTF_VARCHAR2_TABLE_300
268: , a7 JTF_VARCHAR2_TABLE_100

Line 338: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

334: end if;
335: end rosetta_table_copy_in_p5;
336: procedure rosetta_table_copy_out_p5(t okl_srm_pvt.srmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
339: , a3 out nocopy JTF_VARCHAR2_TABLE_200
340: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
341: , a5 out nocopy JTF_NUMBER_TABLE
342: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 339: , a3 out nocopy JTF_VARCHAR2_TABLE_200

335: end rosetta_table_copy_in_p5;
336: procedure rosetta_table_copy_out_p5(t okl_srm_pvt.srmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
339: , a3 out nocopy JTF_VARCHAR2_TABLE_200
340: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
341: , a5 out nocopy JTF_NUMBER_TABLE
342: , a6 out nocopy JTF_VARCHAR2_TABLE_300
343: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 371: a2 := JTF_VARCHAR2_TABLE_2000();

367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_VARCHAR2_TABLE_100();
371: a2 := JTF_VARCHAR2_TABLE_2000();
372: a3 := JTF_VARCHAR2_TABLE_200();
373: a4 := JTF_VARCHAR2_TABLE_1000();
374: a5 := JTF_NUMBER_TABLE();
375: a6 := JTF_VARCHAR2_TABLE_300();

Line 372: a3 := JTF_VARCHAR2_TABLE_200();

368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_VARCHAR2_TABLE_100();
371: a2 := JTF_VARCHAR2_TABLE_2000();
372: a3 := JTF_VARCHAR2_TABLE_200();
373: a4 := JTF_VARCHAR2_TABLE_1000();
374: a5 := JTF_NUMBER_TABLE();
375: a6 := JTF_VARCHAR2_TABLE_300();
376: a7 := JTF_VARCHAR2_TABLE_100();

Line 401: a2 := JTF_VARCHAR2_TABLE_2000();

397: a28 := JTF_NUMBER_TABLE();
398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_100();
401: a2 := JTF_VARCHAR2_TABLE_2000();
402: a3 := JTF_VARCHAR2_TABLE_200();
403: a4 := JTF_VARCHAR2_TABLE_1000();
404: a5 := JTF_NUMBER_TABLE();
405: a6 := JTF_VARCHAR2_TABLE_300();

Line 402: a3 := JTF_VARCHAR2_TABLE_200();

398: else
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_100();
401: a2 := JTF_VARCHAR2_TABLE_2000();
402: a3 := JTF_VARCHAR2_TABLE_200();
403: a4 := JTF_VARCHAR2_TABLE_1000();
404: a5 := JTF_NUMBER_TABLE();
405: a6 := JTF_VARCHAR2_TABLE_300();
406: a7 := JTF_VARCHAR2_TABLE_100();

Line 662: , p5_a2 JTF_VARCHAR2_TABLE_2000

658: , x_msg_count out nocopy NUMBER
659: , x_msg_data out nocopy VARCHAR2
660: , p5_a0 JTF_NUMBER_TABLE
661: , p5_a1 JTF_VARCHAR2_TABLE_100
662: , p5_a2 JTF_VARCHAR2_TABLE_2000
663: , p5_a3 JTF_VARCHAR2_TABLE_200
664: , p5_a4 JTF_VARCHAR2_TABLE_1000
665: , p5_a5 JTF_NUMBER_TABLE
666: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 663: , p5_a3 JTF_VARCHAR2_TABLE_200

659: , x_msg_data out nocopy VARCHAR2
660: , p5_a0 JTF_NUMBER_TABLE
661: , p5_a1 JTF_VARCHAR2_TABLE_100
662: , p5_a2 JTF_VARCHAR2_TABLE_2000
663: , p5_a3 JTF_VARCHAR2_TABLE_200
664: , p5_a4 JTF_VARCHAR2_TABLE_1000
665: , p5_a5 JTF_NUMBER_TABLE
666: , p5_a6 JTF_VARCHAR2_TABLE_300
667: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 691: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000

687: , p5_a27 JTF_DATE_TABLE
688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
691: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
693: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
694: , p6_a5 out nocopy JTF_NUMBER_TABLE
695: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

688: , p5_a28 JTF_NUMBER_TABLE
689: , p6_a0 out nocopy JTF_NUMBER_TABLE
690: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
691: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
692: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
693: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
694: , p6_a5 out nocopy JTF_NUMBER_TABLE
695: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
696: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 912: , p5_a2 JTF_VARCHAR2_TABLE_2000

908: , x_msg_count out nocopy NUMBER
909: , x_msg_data out nocopy VARCHAR2
910: , p5_a0 JTF_NUMBER_TABLE
911: , p5_a1 JTF_VARCHAR2_TABLE_100
912: , p5_a2 JTF_VARCHAR2_TABLE_2000
913: , p5_a3 JTF_VARCHAR2_TABLE_200
914: , p5_a4 JTF_VARCHAR2_TABLE_1000
915: , p5_a5 JTF_NUMBER_TABLE
916: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 913: , p5_a3 JTF_VARCHAR2_TABLE_200

909: , x_msg_data out nocopy VARCHAR2
910: , p5_a0 JTF_NUMBER_TABLE
911: , p5_a1 JTF_VARCHAR2_TABLE_100
912: , p5_a2 JTF_VARCHAR2_TABLE_2000
913: , p5_a3 JTF_VARCHAR2_TABLE_200
914: , p5_a4 JTF_VARCHAR2_TABLE_1000
915: , p5_a5 JTF_NUMBER_TABLE
916: , p5_a6 JTF_VARCHAR2_TABLE_300
917: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1161: , p5_a2 JTF_VARCHAR2_TABLE_2000

1157: , x_msg_count out nocopy NUMBER
1158: , x_msg_data out nocopy VARCHAR2
1159: , p5_a0 JTF_NUMBER_TABLE
1160: , p5_a1 JTF_VARCHAR2_TABLE_100
1161: , p5_a2 JTF_VARCHAR2_TABLE_2000
1162: , p5_a3 JTF_VARCHAR2_TABLE_200
1163: , p5_a4 JTF_VARCHAR2_TABLE_1000
1164: , p5_a5 JTF_NUMBER_TABLE
1165: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 1162: , p5_a3 JTF_VARCHAR2_TABLE_200

1158: , x_msg_data out nocopy VARCHAR2
1159: , p5_a0 JTF_NUMBER_TABLE
1160: , p5_a1 JTF_VARCHAR2_TABLE_100
1161: , p5_a2 JTF_VARCHAR2_TABLE_2000
1162: , p5_a3 JTF_VARCHAR2_TABLE_200
1163: , p5_a4 JTF_VARCHAR2_TABLE_1000
1164: , p5_a5 JTF_NUMBER_TABLE
1165: , p5_a6 JTF_VARCHAR2_TABLE_300
1166: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1190: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000

1186: , p5_a27 JTF_DATE_TABLE
1187: , p5_a28 JTF_NUMBER_TABLE
1188: , p6_a0 out nocopy JTF_NUMBER_TABLE
1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1190: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1192: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
1193: , p6_a5 out nocopy JTF_NUMBER_TABLE
1194: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

1187: , p5_a28 JTF_NUMBER_TABLE
1188: , p6_a0 out nocopy JTF_NUMBER_TABLE
1189: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1190: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
1191: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1192: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
1193: , p6_a5 out nocopy JTF_NUMBER_TABLE
1194: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
1195: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1411: , p5_a2 JTF_VARCHAR2_TABLE_2000

1407: , x_msg_count out nocopy NUMBER
1408: , x_msg_data out nocopy VARCHAR2
1409: , p5_a0 JTF_NUMBER_TABLE
1410: , p5_a1 JTF_VARCHAR2_TABLE_100
1411: , p5_a2 JTF_VARCHAR2_TABLE_2000
1412: , p5_a3 JTF_VARCHAR2_TABLE_200
1413: , p5_a4 JTF_VARCHAR2_TABLE_1000
1414: , p5_a5 JTF_NUMBER_TABLE
1415: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 1412: , p5_a3 JTF_VARCHAR2_TABLE_200

1408: , x_msg_data out nocopy VARCHAR2
1409: , p5_a0 JTF_NUMBER_TABLE
1410: , p5_a1 JTF_VARCHAR2_TABLE_100
1411: , p5_a2 JTF_VARCHAR2_TABLE_2000
1412: , p5_a3 JTF_VARCHAR2_TABLE_200
1413: , p5_a4 JTF_VARCHAR2_TABLE_1000
1414: , p5_a5 JTF_NUMBER_TABLE
1415: , p5_a6 JTF_VARCHAR2_TABLE_300
1416: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 1598: , p5_a2 JTF_VARCHAR2_TABLE_2000

1594: , x_msg_count out nocopy NUMBER
1595: , x_msg_data out nocopy VARCHAR2
1596: , p5_a0 JTF_NUMBER_TABLE
1597: , p5_a1 JTF_VARCHAR2_TABLE_100
1598: , p5_a2 JTF_VARCHAR2_TABLE_2000
1599: , p5_a3 JTF_VARCHAR2_TABLE_200
1600: , p5_a4 JTF_VARCHAR2_TABLE_1000
1601: , p5_a5 JTF_NUMBER_TABLE
1602: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 1599: , p5_a3 JTF_VARCHAR2_TABLE_200

1595: , x_msg_data out nocopy VARCHAR2
1596: , p5_a0 JTF_NUMBER_TABLE
1597: , p5_a1 JTF_VARCHAR2_TABLE_100
1598: , p5_a2 JTF_VARCHAR2_TABLE_2000
1599: , p5_a3 JTF_VARCHAR2_TABLE_200
1600: , p5_a4 JTF_VARCHAR2_TABLE_1000
1601: , p5_a5 JTF_NUMBER_TABLE
1602: , p5_a6 JTF_VARCHAR2_TABLE_300
1603: , p5_a7 JTF_VARCHAR2_TABLE_100