DBA Data[Home] [Help]

APPS.IBU_ORDER_CAPTURE_W dependencies on JTF_VARCHAR2_TABLE_300

Line 24: , a2 JTF_VARCHAR2_TABLE_300

20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy ibu_order_capture.header_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE

Line 30: , a8 JTF_VARCHAR2_TABLE_300

26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100

Line 67: , a2 out nocopy JTF_VARCHAR2_TABLE_300

63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t ibu_order_capture.header_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_VARCHAR2_TABLE_300
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE

Line 73: , a8 out nocopy JTF_VARCHAR2_TABLE_300

69: , a4 out nocopy JTF_NUMBER_TABLE
70: , a5 out nocopy JTF_NUMBER_TABLE
71: , a6 out nocopy JTF_NUMBER_TABLE
72: , a7 out nocopy JTF_NUMBER_TABLE
73: , a8 out nocopy JTF_VARCHAR2_TABLE_300
74: , a9 out nocopy JTF_DATE_TABLE
75: , a10 out nocopy JTF_NUMBER_TABLE
76: , a11 out nocopy JTF_NUMBER_TABLE
77: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 84: a2 := JTF_VARCHAR2_TABLE_300();

80: begin
81: if t is null or t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_VARCHAR2_TABLE_300();
85: a3 := JTF_NUMBER_TABLE();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();

Line 90: a8 := JTF_VARCHAR2_TABLE_300();

86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_NUMBER_TABLE();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_VARCHAR2_TABLE_300();
91: a9 := JTF_DATE_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: a11 := JTF_NUMBER_TABLE();
94: a12 := JTF_VARCHAR2_TABLE_100();

Line 98: a2 := JTF_VARCHAR2_TABLE_300();

94: a12 := JTF_VARCHAR2_TABLE_100();
95: else
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_300();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();

Line 104: a8 := JTF_VARCHAR2_TABLE_300();

100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();
104: a8 := JTF_VARCHAR2_TABLE_300();
105: a9 := JTF_DATE_TABLE();
106: a10 := JTF_NUMBER_TABLE();
107: a11 := JTF_NUMBER_TABLE();
108: a12 := JTF_VARCHAR2_TABLE_100();

Line 295: , a5 JTF_VARCHAR2_TABLE_300

291: , a1 JTF_NUMBER_TABLE
292: , a2 JTF_VARCHAR2_TABLE_100
293: , a3 JTF_NUMBER_TABLE
294: , a4 JTF_NUMBER_TABLE
295: , a5 JTF_VARCHAR2_TABLE_300
296: , a6 JTF_VARCHAR2_TABLE_300
297: , a7 JTF_VARCHAR2_TABLE_300
298: , a8 JTF_VARCHAR2_TABLE_300
299: , a9 JTF_VARCHAR2_TABLE_100

Line 296: , a6 JTF_VARCHAR2_TABLE_300

292: , a2 JTF_VARCHAR2_TABLE_100
293: , a3 JTF_NUMBER_TABLE
294: , a4 JTF_NUMBER_TABLE
295: , a5 JTF_VARCHAR2_TABLE_300
296: , a6 JTF_VARCHAR2_TABLE_300
297: , a7 JTF_VARCHAR2_TABLE_300
298: , a8 JTF_VARCHAR2_TABLE_300
299: , a9 JTF_VARCHAR2_TABLE_100
300: ) as

Line 297: , a7 JTF_VARCHAR2_TABLE_300

293: , a3 JTF_NUMBER_TABLE
294: , a4 JTF_NUMBER_TABLE
295: , a5 JTF_VARCHAR2_TABLE_300
296: , a6 JTF_VARCHAR2_TABLE_300
297: , a7 JTF_VARCHAR2_TABLE_300
298: , a8 JTF_VARCHAR2_TABLE_300
299: , a9 JTF_VARCHAR2_TABLE_100
300: ) as
301: ddindx binary_integer; indx binary_integer;

Line 298: , a8 JTF_VARCHAR2_TABLE_300

294: , a4 JTF_NUMBER_TABLE
295: , a5 JTF_VARCHAR2_TABLE_300
296: , a6 JTF_VARCHAR2_TABLE_300
297: , a7 JTF_VARCHAR2_TABLE_300
298: , a8 JTF_VARCHAR2_TABLE_300
299: , a9 JTF_VARCHAR2_TABLE_100
300: ) as
301: ddindx binary_integer; indx binary_integer;
302: begin

Line 332: , a5 out nocopy JTF_VARCHAR2_TABLE_300

328: , a1 out nocopy JTF_NUMBER_TABLE
329: , a2 out nocopy JTF_VARCHAR2_TABLE_100
330: , a3 out nocopy JTF_NUMBER_TABLE
331: , a4 out nocopy JTF_NUMBER_TABLE
332: , a5 out nocopy JTF_VARCHAR2_TABLE_300
333: , a6 out nocopy JTF_VARCHAR2_TABLE_300
334: , a7 out nocopy JTF_VARCHAR2_TABLE_300
335: , a8 out nocopy JTF_VARCHAR2_TABLE_300
336: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 333: , a6 out nocopy JTF_VARCHAR2_TABLE_300

329: , a2 out nocopy JTF_VARCHAR2_TABLE_100
330: , a3 out nocopy JTF_NUMBER_TABLE
331: , a4 out nocopy JTF_NUMBER_TABLE
332: , a5 out nocopy JTF_VARCHAR2_TABLE_300
333: , a6 out nocopy JTF_VARCHAR2_TABLE_300
334: , a7 out nocopy JTF_VARCHAR2_TABLE_300
335: , a8 out nocopy JTF_VARCHAR2_TABLE_300
336: , a9 out nocopy JTF_VARCHAR2_TABLE_100
337: ) as

Line 334: , a7 out nocopy JTF_VARCHAR2_TABLE_300

330: , a3 out nocopy JTF_NUMBER_TABLE
331: , a4 out nocopy JTF_NUMBER_TABLE
332: , a5 out nocopy JTF_VARCHAR2_TABLE_300
333: , a6 out nocopy JTF_VARCHAR2_TABLE_300
334: , a7 out nocopy JTF_VARCHAR2_TABLE_300
335: , a8 out nocopy JTF_VARCHAR2_TABLE_300
336: , a9 out nocopy JTF_VARCHAR2_TABLE_100
337: ) as
338: ddindx binary_integer; indx binary_integer;

Line 335: , a8 out nocopy JTF_VARCHAR2_TABLE_300

331: , a4 out nocopy JTF_NUMBER_TABLE
332: , a5 out nocopy JTF_VARCHAR2_TABLE_300
333: , a6 out nocopy JTF_VARCHAR2_TABLE_300
334: , a7 out nocopy JTF_VARCHAR2_TABLE_300
335: , a8 out nocopy JTF_VARCHAR2_TABLE_300
336: , a9 out nocopy JTF_VARCHAR2_TABLE_100
337: ) as
338: ddindx binary_integer; indx binary_integer;
339: begin

Line 346: a5 := JTF_VARCHAR2_TABLE_300();

342: a1 := JTF_NUMBER_TABLE();
343: a2 := JTF_VARCHAR2_TABLE_100();
344: a3 := JTF_NUMBER_TABLE();
345: a4 := JTF_NUMBER_TABLE();
346: a5 := JTF_VARCHAR2_TABLE_300();
347: a6 := JTF_VARCHAR2_TABLE_300();
348: a7 := JTF_VARCHAR2_TABLE_300();
349: a8 := JTF_VARCHAR2_TABLE_300();
350: a9 := JTF_VARCHAR2_TABLE_100();

Line 347: a6 := JTF_VARCHAR2_TABLE_300();

343: a2 := JTF_VARCHAR2_TABLE_100();
344: a3 := JTF_NUMBER_TABLE();
345: a4 := JTF_NUMBER_TABLE();
346: a5 := JTF_VARCHAR2_TABLE_300();
347: a6 := JTF_VARCHAR2_TABLE_300();
348: a7 := JTF_VARCHAR2_TABLE_300();
349: a8 := JTF_VARCHAR2_TABLE_300();
350: a9 := JTF_VARCHAR2_TABLE_100();
351: else

Line 348: a7 := JTF_VARCHAR2_TABLE_300();

344: a3 := JTF_NUMBER_TABLE();
345: a4 := JTF_NUMBER_TABLE();
346: a5 := JTF_VARCHAR2_TABLE_300();
347: a6 := JTF_VARCHAR2_TABLE_300();
348: a7 := JTF_VARCHAR2_TABLE_300();
349: a8 := JTF_VARCHAR2_TABLE_300();
350: a9 := JTF_VARCHAR2_TABLE_100();
351: else
352: a0 := JTF_VARCHAR2_TABLE_100();

Line 349: a8 := JTF_VARCHAR2_TABLE_300();

345: a4 := JTF_NUMBER_TABLE();
346: a5 := JTF_VARCHAR2_TABLE_300();
347: a6 := JTF_VARCHAR2_TABLE_300();
348: a7 := JTF_VARCHAR2_TABLE_300();
349: a8 := JTF_VARCHAR2_TABLE_300();
350: a9 := JTF_VARCHAR2_TABLE_100();
351: else
352: a0 := JTF_VARCHAR2_TABLE_100();
353: a1 := JTF_NUMBER_TABLE();

Line 357: a5 := JTF_VARCHAR2_TABLE_300();

353: a1 := JTF_NUMBER_TABLE();
354: a2 := JTF_VARCHAR2_TABLE_100();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_NUMBER_TABLE();
357: a5 := JTF_VARCHAR2_TABLE_300();
358: a6 := JTF_VARCHAR2_TABLE_300();
359: a7 := JTF_VARCHAR2_TABLE_300();
360: a8 := JTF_VARCHAR2_TABLE_300();
361: a9 := JTF_VARCHAR2_TABLE_100();

Line 358: a6 := JTF_VARCHAR2_TABLE_300();

354: a2 := JTF_VARCHAR2_TABLE_100();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_NUMBER_TABLE();
357: a5 := JTF_VARCHAR2_TABLE_300();
358: a6 := JTF_VARCHAR2_TABLE_300();
359: a7 := JTF_VARCHAR2_TABLE_300();
360: a8 := JTF_VARCHAR2_TABLE_300();
361: a9 := JTF_VARCHAR2_TABLE_100();
362: if t.count > 0 then

Line 359: a7 := JTF_VARCHAR2_TABLE_300();

355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_NUMBER_TABLE();
357: a5 := JTF_VARCHAR2_TABLE_300();
358: a6 := JTF_VARCHAR2_TABLE_300();
359: a7 := JTF_VARCHAR2_TABLE_300();
360: a8 := JTF_VARCHAR2_TABLE_300();
361: a9 := JTF_VARCHAR2_TABLE_100();
362: if t.count > 0 then
363: a0.extend(t.count);

Line 360: a8 := JTF_VARCHAR2_TABLE_300();

356: a4 := JTF_NUMBER_TABLE();
357: a5 := JTF_VARCHAR2_TABLE_300();
358: a6 := JTF_VARCHAR2_TABLE_300();
359: a7 := JTF_VARCHAR2_TABLE_300();
360: a8 := JTF_VARCHAR2_TABLE_300();
361: a9 := JTF_VARCHAR2_TABLE_100();
362: if t.count > 0 then
363: a0.extend(t.count);
364: a1.extend(t.count);

Line 569: , p7_a5 JTF_VARCHAR2_TABLE_300

565: , p7_a1 JTF_NUMBER_TABLE
566: , p7_a2 JTF_VARCHAR2_TABLE_100
567: , p7_a3 JTF_NUMBER_TABLE
568: , p7_a4 JTF_NUMBER_TABLE
569: , p7_a5 JTF_VARCHAR2_TABLE_300
570: , p7_a6 JTF_VARCHAR2_TABLE_300
571: , p7_a7 JTF_VARCHAR2_TABLE_300
572: , p7_a8 JTF_VARCHAR2_TABLE_300
573: , p7_a9 JTF_VARCHAR2_TABLE_100

Line 570: , p7_a6 JTF_VARCHAR2_TABLE_300

566: , p7_a2 JTF_VARCHAR2_TABLE_100
567: , p7_a3 JTF_NUMBER_TABLE
568: , p7_a4 JTF_NUMBER_TABLE
569: , p7_a5 JTF_VARCHAR2_TABLE_300
570: , p7_a6 JTF_VARCHAR2_TABLE_300
571: , p7_a7 JTF_VARCHAR2_TABLE_300
572: , p7_a8 JTF_VARCHAR2_TABLE_300
573: , p7_a9 JTF_VARCHAR2_TABLE_100
574: , p8_a0 JTF_VARCHAR2_TABLE_100

Line 571: , p7_a7 JTF_VARCHAR2_TABLE_300

567: , p7_a3 JTF_NUMBER_TABLE
568: , p7_a4 JTF_NUMBER_TABLE
569: , p7_a5 JTF_VARCHAR2_TABLE_300
570: , p7_a6 JTF_VARCHAR2_TABLE_300
571: , p7_a7 JTF_VARCHAR2_TABLE_300
572: , p7_a8 JTF_VARCHAR2_TABLE_300
573: , p7_a9 JTF_VARCHAR2_TABLE_100
574: , p8_a0 JTF_VARCHAR2_TABLE_100
575: , p8_a1 JTF_NUMBER_TABLE

Line 572: , p7_a8 JTF_VARCHAR2_TABLE_300

568: , p7_a4 JTF_NUMBER_TABLE
569: , p7_a5 JTF_VARCHAR2_TABLE_300
570: , p7_a6 JTF_VARCHAR2_TABLE_300
571: , p7_a7 JTF_VARCHAR2_TABLE_300
572: , p7_a8 JTF_VARCHAR2_TABLE_300
573: , p7_a9 JTF_VARCHAR2_TABLE_100
574: , p8_a0 JTF_VARCHAR2_TABLE_100
575: , p8_a1 JTF_NUMBER_TABLE
576: , p8_a2 JTF_DATE_TABLE