DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_MAN_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p7(t out nocopy okl_pay_invoices_man_pvt.man_inv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p7(t out nocopy okl_pay_invoices_man_pvt.man_inv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100

Line 29: , a7 JTF_VARCHAR2_TABLE_100

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

Line 30: , a8 JTF_VARCHAR2_TABLE_100

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

Line 34: , a12 JTF_VARCHAR2_TABLE_100

30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_300
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_300
36: ) as
37: ddindx binary_integer; indx binary_integer;
38: begin

Line 69: , a2 out nocopy JTF_VARCHAR2_TABLE_100

65: end if;
66: end rosetta_table_copy_in_p7;
67: procedure rosetta_table_copy_out_p7(t okl_pay_invoices_man_pvt.man_inv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_VARCHAR2_TABLE_100
72: , a5 out nocopy JTF_DATE_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE

Line 71: , a4 out nocopy JTF_VARCHAR2_TABLE_100

67: procedure rosetta_table_copy_out_p7(t okl_pay_invoices_man_pvt.man_inv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_VARCHAR2_TABLE_100
72: , a5 out nocopy JTF_DATE_TABLE
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_VARCHAR2_TABLE_100
75: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a7 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 75: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 79: , a12 out nocopy JTF_VARCHAR2_TABLE_100

75: , a8 out nocopy JTF_VARCHAR2_TABLE_100
76: , a9 out nocopy JTF_VARCHAR2_TABLE_300
77: , a10 out nocopy JTF_NUMBER_TABLE
78: , a11 out nocopy JTF_NUMBER_TABLE
79: , a12 out nocopy JTF_VARCHAR2_TABLE_100
80: , a13 out nocopy JTF_VARCHAR2_TABLE_300
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin

Line 87: a2 := JTF_VARCHAR2_TABLE_100();

83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_NUMBER_TABLE();
87: a2 := JTF_VARCHAR2_TABLE_100();
88: a3 := JTF_NUMBER_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_100();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_NUMBER_TABLE();

Line 89: a4 := JTF_VARCHAR2_TABLE_100();

85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_NUMBER_TABLE();
87: a2 := JTF_VARCHAR2_TABLE_100();
88: a3 := JTF_NUMBER_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_100();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_VARCHAR2_TABLE_100();
93: a8 := JTF_VARCHAR2_TABLE_100();

Line 92: a7 := JTF_VARCHAR2_TABLE_100();

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

Line 93: a8 := JTF_VARCHAR2_TABLE_100();

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

Line 97: a12 := JTF_VARCHAR2_TABLE_100();

93: a8 := JTF_VARCHAR2_TABLE_100();
94: a9 := JTF_VARCHAR2_TABLE_300();
95: a10 := JTF_NUMBER_TABLE();
96: a11 := JTF_NUMBER_TABLE();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: a13 := JTF_VARCHAR2_TABLE_300();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();

Line 102: a2 := JTF_VARCHAR2_TABLE_100();

98: a13 := JTF_VARCHAR2_TABLE_300();
99: else
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_VARCHAR2_TABLE_100();
103: a3 := JTF_NUMBER_TABLE();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_DATE_TABLE();
106: a6 := JTF_NUMBER_TABLE();

Line 104: a4 := JTF_VARCHAR2_TABLE_100();

100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_VARCHAR2_TABLE_100();
103: a3 := JTF_NUMBER_TABLE();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_DATE_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_VARCHAR2_TABLE_100();
108: a8 := JTF_VARCHAR2_TABLE_100();

Line 107: a7 := JTF_VARCHAR2_TABLE_100();

103: a3 := JTF_NUMBER_TABLE();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_DATE_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_VARCHAR2_TABLE_100();
108: a8 := JTF_VARCHAR2_TABLE_100();
109: a9 := JTF_VARCHAR2_TABLE_300();
110: a10 := JTF_NUMBER_TABLE();
111: a11 := JTF_NUMBER_TABLE();

Line 108: a8 := JTF_VARCHAR2_TABLE_100();

104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_DATE_TABLE();
106: a6 := JTF_NUMBER_TABLE();
107: a7 := JTF_VARCHAR2_TABLE_100();
108: a8 := JTF_VARCHAR2_TABLE_100();
109: a9 := JTF_VARCHAR2_TABLE_300();
110: a10 := JTF_NUMBER_TABLE();
111: a11 := JTF_NUMBER_TABLE();
112: a12 := JTF_VARCHAR2_TABLE_100();

Line 112: a12 := JTF_VARCHAR2_TABLE_100();

108: a8 := JTF_VARCHAR2_TABLE_100();
109: a9 := JTF_VARCHAR2_TABLE_300();
110: a10 := JTF_NUMBER_TABLE();
111: a11 := JTF_NUMBER_TABLE();
112: a12 := JTF_VARCHAR2_TABLE_100();
113: a13 := JTF_VARCHAR2_TABLE_300();
114: if t.count > 0 then
115: a0.extend(t.count);
116: a1.extend(t.count);

Line 258: , p5_a2 JTF_VARCHAR2_TABLE_100

254: , x_msg_count out nocopy NUMBER
255: , x_msg_data out nocopy VARCHAR2
256: , p5_a0 JTF_NUMBER_TABLE
257: , p5_a1 JTF_NUMBER_TABLE
258: , p5_a2 JTF_VARCHAR2_TABLE_100
259: , p5_a3 JTF_NUMBER_TABLE
260: , p5_a4 JTF_VARCHAR2_TABLE_100
261: , p5_a5 JTF_DATE_TABLE
262: , p5_a6 JTF_NUMBER_TABLE

Line 260: , p5_a4 JTF_VARCHAR2_TABLE_100

256: , p5_a0 JTF_NUMBER_TABLE
257: , p5_a1 JTF_NUMBER_TABLE
258: , p5_a2 JTF_VARCHAR2_TABLE_100
259: , p5_a3 JTF_NUMBER_TABLE
260: , p5_a4 JTF_VARCHAR2_TABLE_100
261: , p5_a5 JTF_DATE_TABLE
262: , p5_a6 JTF_NUMBER_TABLE
263: , p5_a7 JTF_VARCHAR2_TABLE_100
264: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 263: , p5_a7 JTF_VARCHAR2_TABLE_100

259: , p5_a3 JTF_NUMBER_TABLE
260: , p5_a4 JTF_VARCHAR2_TABLE_100
261: , p5_a5 JTF_DATE_TABLE
262: , p5_a6 JTF_NUMBER_TABLE
263: , p5_a7 JTF_VARCHAR2_TABLE_100
264: , p5_a8 JTF_VARCHAR2_TABLE_100
265: , p5_a9 JTF_VARCHAR2_TABLE_300
266: , p5_a10 JTF_NUMBER_TABLE
267: , p5_a11 JTF_NUMBER_TABLE

Line 264: , p5_a8 JTF_VARCHAR2_TABLE_100

260: , p5_a4 JTF_VARCHAR2_TABLE_100
261: , p5_a5 JTF_DATE_TABLE
262: , p5_a6 JTF_NUMBER_TABLE
263: , p5_a7 JTF_VARCHAR2_TABLE_100
264: , p5_a8 JTF_VARCHAR2_TABLE_100
265: , p5_a9 JTF_VARCHAR2_TABLE_300
266: , p5_a10 JTF_NUMBER_TABLE
267: , p5_a11 JTF_NUMBER_TABLE
268: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 268: , p5_a12 JTF_VARCHAR2_TABLE_100

264: , p5_a8 JTF_VARCHAR2_TABLE_100
265: , p5_a9 JTF_VARCHAR2_TABLE_300
266: , p5_a10 JTF_NUMBER_TABLE
267: , p5_a11 JTF_NUMBER_TABLE
268: , p5_a12 JTF_VARCHAR2_TABLE_100
269: , p5_a13 JTF_VARCHAR2_TABLE_300
270: , p6_a0 out nocopy JTF_NUMBER_TABLE
271: , p6_a1 out nocopy JTF_NUMBER_TABLE
272: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 272: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

268: , p5_a12 JTF_VARCHAR2_TABLE_100
269: , p5_a13 JTF_VARCHAR2_TABLE_300
270: , p6_a0 out nocopy JTF_NUMBER_TABLE
271: , p6_a1 out nocopy JTF_NUMBER_TABLE
272: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a3 out nocopy JTF_NUMBER_TABLE
274: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a5 out nocopy JTF_DATE_TABLE
276: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 274: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

270: , p6_a0 out nocopy JTF_NUMBER_TABLE
271: , p6_a1 out nocopy JTF_NUMBER_TABLE
272: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a3 out nocopy JTF_NUMBER_TABLE
274: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a5 out nocopy JTF_DATE_TABLE
276: , p6_a6 out nocopy JTF_NUMBER_TABLE
277: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
278: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 277: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

273: , p6_a3 out nocopy JTF_NUMBER_TABLE
274: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a5 out nocopy JTF_DATE_TABLE
276: , p6_a6 out nocopy JTF_NUMBER_TABLE
277: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
278: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
279: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
280: , p6_a10 out nocopy JTF_NUMBER_TABLE
281: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 278: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

274: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a5 out nocopy JTF_DATE_TABLE
276: , p6_a6 out nocopy JTF_NUMBER_TABLE
277: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
278: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
279: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
280: , p6_a10 out nocopy JTF_NUMBER_TABLE
281: , p6_a11 out nocopy JTF_NUMBER_TABLE
282: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 282: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

278: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
279: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
280: , p6_a10 out nocopy JTF_NUMBER_TABLE
281: , p6_a11 out nocopy JTF_NUMBER_TABLE
282: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
284: )
285:
286: as