APPS.AHL_LTP_MATRL_AVAL_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE

Line 24: , a8 JTF_VARCHAR2_TABLE_100

20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_NUMBER_TABLE

Line 25: , a9 JTF_VARCHAR2_TABLE_100

21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE

Line 26: , a10 JTF_VARCHAR2_TABLE_100

22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_DATE_TABLE

Line 31: , a15 JTF_VARCHAR2_TABLE_100

27: , a11 JTF_DATE_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_DATE_TABLE
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_2000
34: , a18 JTF_VARCHAR2_TABLE_100
35: ) as

Line 34: , a18 JTF_VARCHAR2_TABLE_100

30: , a14 JTF_DATE_TABLE
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_2000
34: , a18 JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin
38: if a0 is not null and a0.count > 0 then

Line 74: , a3 out nocopy JTF_VARCHAR2_TABLE_100

70: end rosetta_table_copy_in_p3;
71: procedure rosetta_table_copy_out_p3(t ahl_ltp_matrl_aval_pub.material_availability_tbl, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_NUMBER_TABLE

Line 79: , a8 out nocopy JTF_VARCHAR2_TABLE_100

75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_NUMBER_TABLE
79: , a8 out nocopy JTF_VARCHAR2_TABLE_100
80: , a9 out nocopy JTF_VARCHAR2_TABLE_100
81: , a10 out nocopy JTF_VARCHAR2_TABLE_100
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_NUMBER_TABLE

Line 80: , a9 out nocopy JTF_VARCHAR2_TABLE_100

76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_NUMBER_TABLE
79: , a8 out nocopy JTF_VARCHAR2_TABLE_100
80: , a9 out nocopy JTF_VARCHAR2_TABLE_100
81: , a10 out nocopy JTF_VARCHAR2_TABLE_100
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_NUMBER_TABLE
84: , a13 out nocopy JTF_NUMBER_TABLE

Line 81: , a10 out nocopy JTF_VARCHAR2_TABLE_100

77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_NUMBER_TABLE
79: , a8 out nocopy JTF_VARCHAR2_TABLE_100
80: , a9 out nocopy JTF_VARCHAR2_TABLE_100
81: , a10 out nocopy JTF_VARCHAR2_TABLE_100
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_NUMBER_TABLE
84: , a13 out nocopy JTF_NUMBER_TABLE
85: , a14 out nocopy JTF_DATE_TABLE

Line 86: , a15 out nocopy JTF_VARCHAR2_TABLE_100

82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_NUMBER_TABLE
84: , a13 out nocopy JTF_NUMBER_TABLE
85: , a14 out nocopy JTF_DATE_TABLE
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: , a16 out nocopy JTF_NUMBER_TABLE
88: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
89: , a18 out nocopy JTF_VARCHAR2_TABLE_100
90: ) as

Line 89: , a18 out nocopy JTF_VARCHAR2_TABLE_100

85: , a14 out nocopy JTF_DATE_TABLE
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: , a16 out nocopy JTF_NUMBER_TABLE
88: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
89: , a18 out nocopy JTF_VARCHAR2_TABLE_100
90: ) as
91: ddindx binary_integer; indx binary_integer;
92: begin
93: if t is null or t.count = 0 then

Line 97: a3 := JTF_VARCHAR2_TABLE_100();

93: if t is null or t.count = 0 then
94: a0 := JTF_NUMBER_TABLE();
95: a1 := JTF_NUMBER_TABLE();
96: a2 := JTF_NUMBER_TABLE();
97: a3 := JTF_VARCHAR2_TABLE_100();
98: a4 := JTF_NUMBER_TABLE();
99: a5 := JTF_NUMBER_TABLE();
100: a6 := JTF_NUMBER_TABLE();
101: a7 := JTF_NUMBER_TABLE();

Line 102: a8 := JTF_VARCHAR2_TABLE_100();

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

Line 103: a9 := JTF_VARCHAR2_TABLE_100();

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

Line 104: a10 := JTF_VARCHAR2_TABLE_100();

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

Line 109: a15 := JTF_VARCHAR2_TABLE_100();

105: a11 := JTF_DATE_TABLE();
106: a12 := JTF_NUMBER_TABLE();
107: a13 := JTF_NUMBER_TABLE();
108: a14 := JTF_DATE_TABLE();
109: a15 := JTF_VARCHAR2_TABLE_100();
110: a16 := JTF_NUMBER_TABLE();
111: a17 := JTF_VARCHAR2_TABLE_2000();
112: a18 := JTF_VARCHAR2_TABLE_100();
113: else

Line 112: a18 := JTF_VARCHAR2_TABLE_100();

108: a14 := JTF_DATE_TABLE();
109: a15 := JTF_VARCHAR2_TABLE_100();
110: a16 := JTF_NUMBER_TABLE();
111: a17 := JTF_VARCHAR2_TABLE_2000();
112: a18 := JTF_VARCHAR2_TABLE_100();
113: else
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();

Line 117: a3 := JTF_VARCHAR2_TABLE_100();

113: else
114: a0 := JTF_NUMBER_TABLE();
115: a1 := JTF_NUMBER_TABLE();
116: a2 := JTF_NUMBER_TABLE();
117: a3 := JTF_VARCHAR2_TABLE_100();
118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();

Line 122: a8 := JTF_VARCHAR2_TABLE_100();

118: a4 := JTF_NUMBER_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_VARCHAR2_TABLE_100();
123: a9 := JTF_VARCHAR2_TABLE_100();
124: a10 := JTF_VARCHAR2_TABLE_100();
125: a11 := JTF_DATE_TABLE();
126: a12 := JTF_NUMBER_TABLE();

Line 123: a9 := JTF_VARCHAR2_TABLE_100();

119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_VARCHAR2_TABLE_100();
123: a9 := JTF_VARCHAR2_TABLE_100();
124: a10 := JTF_VARCHAR2_TABLE_100();
125: a11 := JTF_DATE_TABLE();
126: a12 := JTF_NUMBER_TABLE();
127: a13 := JTF_NUMBER_TABLE();

Line 124: a10 := JTF_VARCHAR2_TABLE_100();

120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_VARCHAR2_TABLE_100();
123: a9 := JTF_VARCHAR2_TABLE_100();
124: a10 := JTF_VARCHAR2_TABLE_100();
125: a11 := JTF_DATE_TABLE();
126: a12 := JTF_NUMBER_TABLE();
127: a13 := JTF_NUMBER_TABLE();
128: a14 := JTF_DATE_TABLE();

Line 129: a15 := JTF_VARCHAR2_TABLE_100();

125: a11 := JTF_DATE_TABLE();
126: a12 := JTF_NUMBER_TABLE();
127: a13 := JTF_NUMBER_TABLE();
128: a14 := JTF_DATE_TABLE();
129: a15 := JTF_VARCHAR2_TABLE_100();
130: a16 := JTF_NUMBER_TABLE();
131: a17 := JTF_VARCHAR2_TABLE_2000();
132: a18 := JTF_VARCHAR2_TABLE_100();
133: if t.count > 0 then

Line 132: a18 := JTF_VARCHAR2_TABLE_100();

128: a14 := JTF_DATE_TABLE();
129: a15 := JTF_VARCHAR2_TABLE_100();
130: a16 := JTF_NUMBER_TABLE();
131: a17 := JTF_VARCHAR2_TABLE_2000();
132: a18 := JTF_VARCHAR2_TABLE_100();
133: if t.count > 0 then
134: a0.extend(t.count);
135: a1.extend(t.count);
136: a2.extend(t.count);

Line 188: , a3 JTF_VARCHAR2_TABLE_100

184:
185: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 JTF_NUMBER_TABLE
186: , a1 JTF_NUMBER_TABLE
187: , a2 JTF_NUMBER_TABLE
188: , a3 JTF_VARCHAR2_TABLE_100
189: , a4 JTF_VARCHAR2_TABLE_100
190: , a5 JTF_VARCHAR2_TABLE_100
191: , a6 JTF_NUMBER_TABLE
192: , a7 JTF_NUMBER_TABLE

Line 189: , a4 JTF_VARCHAR2_TABLE_100

185: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 JTF_NUMBER_TABLE
186: , a1 JTF_NUMBER_TABLE
187: , a2 JTF_NUMBER_TABLE
188: , a3 JTF_VARCHAR2_TABLE_100
189: , a4 JTF_VARCHAR2_TABLE_100
190: , a5 JTF_VARCHAR2_TABLE_100
191: , a6 JTF_NUMBER_TABLE
192: , a7 JTF_NUMBER_TABLE
193: , a8 JTF_NUMBER_TABLE

Line 190: , a5 JTF_VARCHAR2_TABLE_100

186: , a1 JTF_NUMBER_TABLE
187: , a2 JTF_NUMBER_TABLE
188: , a3 JTF_VARCHAR2_TABLE_100
189: , a4 JTF_VARCHAR2_TABLE_100
190: , a5 JTF_VARCHAR2_TABLE_100
191: , a6 JTF_NUMBER_TABLE
192: , a7 JTF_NUMBER_TABLE
193: , a8 JTF_NUMBER_TABLE
194: , a9 JTF_VARCHAR2_TABLE_100

Line 194: , a9 JTF_VARCHAR2_TABLE_100

190: , a5 JTF_VARCHAR2_TABLE_100
191: , a6 JTF_NUMBER_TABLE
192: , a7 JTF_NUMBER_TABLE
193: , a8 JTF_NUMBER_TABLE
194: , a9 JTF_VARCHAR2_TABLE_100
195: , a10 JTF_DATE_TABLE
196: , a11 JTF_VARCHAR2_TABLE_100
197: , a12 JTF_NUMBER_TABLE
198: , a13 JTF_DATE_TABLE

Line 196: , a11 JTF_VARCHAR2_TABLE_100

192: , a7 JTF_NUMBER_TABLE
193: , a8 JTF_NUMBER_TABLE
194: , a9 JTF_VARCHAR2_TABLE_100
195: , a10 JTF_DATE_TABLE
196: , a11 JTF_VARCHAR2_TABLE_100
197: , a12 JTF_NUMBER_TABLE
198: , a13 JTF_DATE_TABLE
199: , a14 JTF_VARCHAR2_TABLE_300
200: , a15 JTF_NUMBER_TABLE

Line 237: , a3 out nocopy JTF_VARCHAR2_TABLE_100

233: end rosetta_table_copy_in_p4;
234: procedure rosetta_table_copy_out_p4(t ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
235: , a1 out nocopy JTF_NUMBER_TABLE
236: , a2 out nocopy JTF_NUMBER_TABLE
237: , a3 out nocopy JTF_VARCHAR2_TABLE_100
238: , a4 out nocopy JTF_VARCHAR2_TABLE_100
239: , a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , a6 out nocopy JTF_NUMBER_TABLE
241: , a7 out nocopy JTF_NUMBER_TABLE

Line 238: , a4 out nocopy JTF_VARCHAR2_TABLE_100

234: procedure rosetta_table_copy_out_p4(t ahl_ltp_matrl_aval_pub.task_req_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
235: , a1 out nocopy JTF_NUMBER_TABLE
236: , a2 out nocopy JTF_NUMBER_TABLE
237: , a3 out nocopy JTF_VARCHAR2_TABLE_100
238: , a4 out nocopy JTF_VARCHAR2_TABLE_100
239: , a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , a6 out nocopy JTF_NUMBER_TABLE
241: , a7 out nocopy JTF_NUMBER_TABLE
242: , a8 out nocopy JTF_NUMBER_TABLE

Line 239: , a5 out nocopy JTF_VARCHAR2_TABLE_100

235: , a1 out nocopy JTF_NUMBER_TABLE
236: , a2 out nocopy JTF_NUMBER_TABLE
237: , a3 out nocopy JTF_VARCHAR2_TABLE_100
238: , a4 out nocopy JTF_VARCHAR2_TABLE_100
239: , a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , a6 out nocopy JTF_NUMBER_TABLE
241: , a7 out nocopy JTF_NUMBER_TABLE
242: , a8 out nocopy JTF_NUMBER_TABLE
243: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 243: , a9 out nocopy JTF_VARCHAR2_TABLE_100

239: , a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , a6 out nocopy JTF_NUMBER_TABLE
241: , a7 out nocopy JTF_NUMBER_TABLE
242: , a8 out nocopy JTF_NUMBER_TABLE
243: , a9 out nocopy JTF_VARCHAR2_TABLE_100
244: , a10 out nocopy JTF_DATE_TABLE
245: , a11 out nocopy JTF_VARCHAR2_TABLE_100
246: , a12 out nocopy JTF_NUMBER_TABLE
247: , a13 out nocopy JTF_DATE_TABLE

Line 245: , a11 out nocopy JTF_VARCHAR2_TABLE_100

241: , a7 out nocopy JTF_NUMBER_TABLE
242: , a8 out nocopy JTF_NUMBER_TABLE
243: , a9 out nocopy JTF_VARCHAR2_TABLE_100
244: , a10 out nocopy JTF_DATE_TABLE
245: , a11 out nocopy JTF_VARCHAR2_TABLE_100
246: , a12 out nocopy JTF_NUMBER_TABLE
247: , a13 out nocopy JTF_DATE_TABLE
248: , a14 out nocopy JTF_VARCHAR2_TABLE_300
249: , a15 out nocopy JTF_NUMBER_TABLE

Line 257: a3 := JTF_VARCHAR2_TABLE_100();

253: if t is null or t.count = 0 then
254: a0 := JTF_NUMBER_TABLE();
255: a1 := JTF_NUMBER_TABLE();
256: a2 := JTF_NUMBER_TABLE();
257: a3 := JTF_VARCHAR2_TABLE_100();
258: a4 := JTF_VARCHAR2_TABLE_100();
259: a5 := JTF_VARCHAR2_TABLE_100();
260: a6 := JTF_NUMBER_TABLE();
261: a7 := JTF_NUMBER_TABLE();

Line 258: a4 := JTF_VARCHAR2_TABLE_100();

254: a0 := JTF_NUMBER_TABLE();
255: a1 := JTF_NUMBER_TABLE();
256: a2 := JTF_NUMBER_TABLE();
257: a3 := JTF_VARCHAR2_TABLE_100();
258: a4 := JTF_VARCHAR2_TABLE_100();
259: a5 := JTF_VARCHAR2_TABLE_100();
260: a6 := JTF_NUMBER_TABLE();
261: a7 := JTF_NUMBER_TABLE();
262: a8 := JTF_NUMBER_TABLE();

Line 259: a5 := JTF_VARCHAR2_TABLE_100();

255: a1 := JTF_NUMBER_TABLE();
256: a2 := JTF_NUMBER_TABLE();
257: a3 := JTF_VARCHAR2_TABLE_100();
258: a4 := JTF_VARCHAR2_TABLE_100();
259: a5 := JTF_VARCHAR2_TABLE_100();
260: a6 := JTF_NUMBER_TABLE();
261: a7 := JTF_NUMBER_TABLE();
262: a8 := JTF_NUMBER_TABLE();
263: a9 := JTF_VARCHAR2_TABLE_100();

Line 263: a9 := JTF_VARCHAR2_TABLE_100();

259: a5 := JTF_VARCHAR2_TABLE_100();
260: a6 := JTF_NUMBER_TABLE();
261: a7 := JTF_NUMBER_TABLE();
262: a8 := JTF_NUMBER_TABLE();
263: a9 := JTF_VARCHAR2_TABLE_100();
264: a10 := JTF_DATE_TABLE();
265: a11 := JTF_VARCHAR2_TABLE_100();
266: a12 := JTF_NUMBER_TABLE();
267: a13 := JTF_DATE_TABLE();

Line 265: a11 := JTF_VARCHAR2_TABLE_100();

261: a7 := JTF_NUMBER_TABLE();
262: a8 := JTF_NUMBER_TABLE();
263: a9 := JTF_VARCHAR2_TABLE_100();
264: a10 := JTF_DATE_TABLE();
265: a11 := JTF_VARCHAR2_TABLE_100();
266: a12 := JTF_NUMBER_TABLE();
267: a13 := JTF_DATE_TABLE();
268: a14 := JTF_VARCHAR2_TABLE_300();
269: a15 := JTF_NUMBER_TABLE();

Line 274: a3 := JTF_VARCHAR2_TABLE_100();

270: else
271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_NUMBER_TABLE();
274: a3 := JTF_VARCHAR2_TABLE_100();
275: a4 := JTF_VARCHAR2_TABLE_100();
276: a5 := JTF_VARCHAR2_TABLE_100();
277: a6 := JTF_NUMBER_TABLE();
278: a7 := JTF_NUMBER_TABLE();

Line 275: a4 := JTF_VARCHAR2_TABLE_100();

271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_NUMBER_TABLE();
274: a3 := JTF_VARCHAR2_TABLE_100();
275: a4 := JTF_VARCHAR2_TABLE_100();
276: a5 := JTF_VARCHAR2_TABLE_100();
277: a6 := JTF_NUMBER_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_NUMBER_TABLE();

Line 276: a5 := JTF_VARCHAR2_TABLE_100();

272: a1 := JTF_NUMBER_TABLE();
273: a2 := JTF_NUMBER_TABLE();
274: a3 := JTF_VARCHAR2_TABLE_100();
275: a4 := JTF_VARCHAR2_TABLE_100();
276: a5 := JTF_VARCHAR2_TABLE_100();
277: a6 := JTF_NUMBER_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_NUMBER_TABLE();
280: a9 := JTF_VARCHAR2_TABLE_100();

Line 280: a9 := JTF_VARCHAR2_TABLE_100();

276: a5 := JTF_VARCHAR2_TABLE_100();
277: a6 := JTF_NUMBER_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_NUMBER_TABLE();
280: a9 := JTF_VARCHAR2_TABLE_100();
281: a10 := JTF_DATE_TABLE();
282: a11 := JTF_VARCHAR2_TABLE_100();
283: a12 := JTF_NUMBER_TABLE();
284: a13 := JTF_DATE_TABLE();

Line 282: a11 := JTF_VARCHAR2_TABLE_100();

278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_NUMBER_TABLE();
280: a9 := JTF_VARCHAR2_TABLE_100();
281: a10 := JTF_DATE_TABLE();
282: a11 := JTF_VARCHAR2_TABLE_100();
283: a12 := JTF_NUMBER_TABLE();
284: a13 := JTF_DATE_TABLE();
285: a14 := JTF_VARCHAR2_TABLE_300();
286: a15 := JTF_NUMBER_TABLE();

Line 336: , a3 JTF_VARCHAR2_TABLE_100

332:
333: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 JTF_NUMBER_TABLE
334: , a1 JTF_NUMBER_TABLE
335: , a2 JTF_NUMBER_TABLE
336: , a3 JTF_VARCHAR2_TABLE_100
337: , a4 JTF_NUMBER_TABLE
338: , a5 JTF_NUMBER_TABLE
339: , a6 JTF_NUMBER_TABLE
340: , a7 JTF_VARCHAR2_TABLE_300

Line 341: , a8 JTF_VARCHAR2_TABLE_100

337: , a4 JTF_NUMBER_TABLE
338: , a5 JTF_NUMBER_TABLE
339: , a6 JTF_NUMBER_TABLE
340: , a7 JTF_VARCHAR2_TABLE_300
341: , a8 JTF_VARCHAR2_TABLE_100
342: , a9 JTF_VARCHAR2_TABLE_100
343: , a10 JTF_VARCHAR2_TABLE_100
344: , a11 JTF_DATE_TABLE
345: , a12 JTF_NUMBER_TABLE

Line 342: , a9 JTF_VARCHAR2_TABLE_100

338: , a5 JTF_NUMBER_TABLE
339: , a6 JTF_NUMBER_TABLE
340: , a7 JTF_VARCHAR2_TABLE_300
341: , a8 JTF_VARCHAR2_TABLE_100
342: , a9 JTF_VARCHAR2_TABLE_100
343: , a10 JTF_VARCHAR2_TABLE_100
344: , a11 JTF_DATE_TABLE
345: , a12 JTF_NUMBER_TABLE
346: , a13 JTF_NUMBER_TABLE

Line 343: , a10 JTF_VARCHAR2_TABLE_100

339: , a6 JTF_NUMBER_TABLE
340: , a7 JTF_VARCHAR2_TABLE_300
341: , a8 JTF_VARCHAR2_TABLE_100
342: , a9 JTF_VARCHAR2_TABLE_100
343: , a10 JTF_VARCHAR2_TABLE_100
344: , a11 JTF_DATE_TABLE
345: , a12 JTF_NUMBER_TABLE
346: , a13 JTF_NUMBER_TABLE
347: , a14 JTF_DATE_TABLE

Line 348: , a15 JTF_VARCHAR2_TABLE_100

344: , a11 JTF_DATE_TABLE
345: , a12 JTF_NUMBER_TABLE
346: , a13 JTF_NUMBER_TABLE
347: , a14 JTF_DATE_TABLE
348: , a15 JTF_VARCHAR2_TABLE_100
349: , a16 JTF_VARCHAR2_TABLE_100
350: , a17 JTF_VARCHAR2_TABLE_100
351: , a18 JTF_NUMBER_TABLE
352: , a19 JTF_VARCHAR2_TABLE_2000

Line 349: , a16 JTF_VARCHAR2_TABLE_100

345: , a12 JTF_NUMBER_TABLE
346: , a13 JTF_NUMBER_TABLE
347: , a14 JTF_DATE_TABLE
348: , a15 JTF_VARCHAR2_TABLE_100
349: , a16 JTF_VARCHAR2_TABLE_100
350: , a17 JTF_VARCHAR2_TABLE_100
351: , a18 JTF_NUMBER_TABLE
352: , a19 JTF_VARCHAR2_TABLE_2000
353: ) as

Line 350: , a17 JTF_VARCHAR2_TABLE_100

346: , a13 JTF_NUMBER_TABLE
347: , a14 JTF_DATE_TABLE
348: , a15 JTF_VARCHAR2_TABLE_100
349: , a16 JTF_VARCHAR2_TABLE_100
350: , a17 JTF_VARCHAR2_TABLE_100
351: , a18 JTF_NUMBER_TABLE
352: , a19 JTF_VARCHAR2_TABLE_2000
353: ) as
354: ddindx binary_integer; indx binary_integer;

Line 393: , a3 out nocopy JTF_VARCHAR2_TABLE_100

389: end rosetta_table_copy_in_p5;
390: procedure rosetta_table_copy_out_p5(t ahl_ltp_matrl_aval_pub.planned_matrl_tbl, a0 out nocopy JTF_NUMBER_TABLE
391: , a1 out nocopy JTF_NUMBER_TABLE
392: , a2 out nocopy JTF_NUMBER_TABLE
393: , a3 out nocopy JTF_VARCHAR2_TABLE_100
394: , a4 out nocopy JTF_NUMBER_TABLE
395: , a5 out nocopy JTF_NUMBER_TABLE
396: , a6 out nocopy JTF_NUMBER_TABLE
397: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 398: , a8 out nocopy JTF_VARCHAR2_TABLE_100

394: , a4 out nocopy JTF_NUMBER_TABLE
395: , a5 out nocopy JTF_NUMBER_TABLE
396: , a6 out nocopy JTF_NUMBER_TABLE
397: , a7 out nocopy JTF_VARCHAR2_TABLE_300
398: , a8 out nocopy JTF_VARCHAR2_TABLE_100
399: , a9 out nocopy JTF_VARCHAR2_TABLE_100
400: , a10 out nocopy JTF_VARCHAR2_TABLE_100
401: , a11 out nocopy JTF_DATE_TABLE
402: , a12 out nocopy JTF_NUMBER_TABLE

Line 399: , a9 out nocopy JTF_VARCHAR2_TABLE_100

395: , a5 out nocopy JTF_NUMBER_TABLE
396: , a6 out nocopy JTF_NUMBER_TABLE
397: , a7 out nocopy JTF_VARCHAR2_TABLE_300
398: , a8 out nocopy JTF_VARCHAR2_TABLE_100
399: , a9 out nocopy JTF_VARCHAR2_TABLE_100
400: , a10 out nocopy JTF_VARCHAR2_TABLE_100
401: , a11 out nocopy JTF_DATE_TABLE
402: , a12 out nocopy JTF_NUMBER_TABLE
403: , a13 out nocopy JTF_NUMBER_TABLE

Line 400: , a10 out nocopy JTF_VARCHAR2_TABLE_100

396: , a6 out nocopy JTF_NUMBER_TABLE
397: , a7 out nocopy JTF_VARCHAR2_TABLE_300
398: , a8 out nocopy JTF_VARCHAR2_TABLE_100
399: , a9 out nocopy JTF_VARCHAR2_TABLE_100
400: , a10 out nocopy JTF_VARCHAR2_TABLE_100
401: , a11 out nocopy JTF_DATE_TABLE
402: , a12 out nocopy JTF_NUMBER_TABLE
403: , a13 out nocopy JTF_NUMBER_TABLE
404: , a14 out nocopy JTF_DATE_TABLE

Line 405: , a15 out nocopy JTF_VARCHAR2_TABLE_100

401: , a11 out nocopy JTF_DATE_TABLE
402: , a12 out nocopy JTF_NUMBER_TABLE
403: , a13 out nocopy JTF_NUMBER_TABLE
404: , a14 out nocopy JTF_DATE_TABLE
405: , a15 out nocopy JTF_VARCHAR2_TABLE_100
406: , a16 out nocopy JTF_VARCHAR2_TABLE_100
407: , a17 out nocopy JTF_VARCHAR2_TABLE_100
408: , a18 out nocopy JTF_NUMBER_TABLE
409: , a19 out nocopy JTF_VARCHAR2_TABLE_2000

Line 406: , a16 out nocopy JTF_VARCHAR2_TABLE_100

402: , a12 out nocopy JTF_NUMBER_TABLE
403: , a13 out nocopy JTF_NUMBER_TABLE
404: , a14 out nocopy JTF_DATE_TABLE
405: , a15 out nocopy JTF_VARCHAR2_TABLE_100
406: , a16 out nocopy JTF_VARCHAR2_TABLE_100
407: , a17 out nocopy JTF_VARCHAR2_TABLE_100
408: , a18 out nocopy JTF_NUMBER_TABLE
409: , a19 out nocopy JTF_VARCHAR2_TABLE_2000
410: ) as

Line 407: , a17 out nocopy JTF_VARCHAR2_TABLE_100

403: , a13 out nocopy JTF_NUMBER_TABLE
404: , a14 out nocopy JTF_DATE_TABLE
405: , a15 out nocopy JTF_VARCHAR2_TABLE_100
406: , a16 out nocopy JTF_VARCHAR2_TABLE_100
407: , a17 out nocopy JTF_VARCHAR2_TABLE_100
408: , a18 out nocopy JTF_NUMBER_TABLE
409: , a19 out nocopy JTF_VARCHAR2_TABLE_2000
410: ) as
411: ddindx binary_integer; indx binary_integer;

Line 417: a3 := JTF_VARCHAR2_TABLE_100();

413: if t is null or t.count = 0 then
414: a0 := JTF_NUMBER_TABLE();
415: a1 := JTF_NUMBER_TABLE();
416: a2 := JTF_NUMBER_TABLE();
417: a3 := JTF_VARCHAR2_TABLE_100();
418: a4 := JTF_NUMBER_TABLE();
419: a5 := JTF_NUMBER_TABLE();
420: a6 := JTF_NUMBER_TABLE();
421: a7 := JTF_VARCHAR2_TABLE_300();

Line 422: a8 := JTF_VARCHAR2_TABLE_100();

418: a4 := JTF_NUMBER_TABLE();
419: a5 := JTF_NUMBER_TABLE();
420: a6 := JTF_NUMBER_TABLE();
421: a7 := JTF_VARCHAR2_TABLE_300();
422: a8 := JTF_VARCHAR2_TABLE_100();
423: a9 := JTF_VARCHAR2_TABLE_100();
424: a10 := JTF_VARCHAR2_TABLE_100();
425: a11 := JTF_DATE_TABLE();
426: a12 := JTF_NUMBER_TABLE();

Line 423: a9 := JTF_VARCHAR2_TABLE_100();

419: a5 := JTF_NUMBER_TABLE();
420: a6 := JTF_NUMBER_TABLE();
421: a7 := JTF_VARCHAR2_TABLE_300();
422: a8 := JTF_VARCHAR2_TABLE_100();
423: a9 := JTF_VARCHAR2_TABLE_100();
424: a10 := JTF_VARCHAR2_TABLE_100();
425: a11 := JTF_DATE_TABLE();
426: a12 := JTF_NUMBER_TABLE();
427: a13 := JTF_NUMBER_TABLE();

Line 424: a10 := JTF_VARCHAR2_TABLE_100();

420: a6 := JTF_NUMBER_TABLE();
421: a7 := JTF_VARCHAR2_TABLE_300();
422: a8 := JTF_VARCHAR2_TABLE_100();
423: a9 := JTF_VARCHAR2_TABLE_100();
424: a10 := JTF_VARCHAR2_TABLE_100();
425: a11 := JTF_DATE_TABLE();
426: a12 := JTF_NUMBER_TABLE();
427: a13 := JTF_NUMBER_TABLE();
428: a14 := JTF_DATE_TABLE();

Line 429: a15 := JTF_VARCHAR2_TABLE_100();

425: a11 := JTF_DATE_TABLE();
426: a12 := JTF_NUMBER_TABLE();
427: a13 := JTF_NUMBER_TABLE();
428: a14 := JTF_DATE_TABLE();
429: a15 := JTF_VARCHAR2_TABLE_100();
430: a16 := JTF_VARCHAR2_TABLE_100();
431: a17 := JTF_VARCHAR2_TABLE_100();
432: a18 := JTF_NUMBER_TABLE();
433: a19 := JTF_VARCHAR2_TABLE_2000();

Line 430: a16 := JTF_VARCHAR2_TABLE_100();

426: a12 := JTF_NUMBER_TABLE();
427: a13 := JTF_NUMBER_TABLE();
428: a14 := JTF_DATE_TABLE();
429: a15 := JTF_VARCHAR2_TABLE_100();
430: a16 := JTF_VARCHAR2_TABLE_100();
431: a17 := JTF_VARCHAR2_TABLE_100();
432: a18 := JTF_NUMBER_TABLE();
433: a19 := JTF_VARCHAR2_TABLE_2000();
434: else

Line 431: a17 := JTF_VARCHAR2_TABLE_100();

427: a13 := JTF_NUMBER_TABLE();
428: a14 := JTF_DATE_TABLE();
429: a15 := JTF_VARCHAR2_TABLE_100();
430: a16 := JTF_VARCHAR2_TABLE_100();
431: a17 := JTF_VARCHAR2_TABLE_100();
432: a18 := JTF_NUMBER_TABLE();
433: a19 := JTF_VARCHAR2_TABLE_2000();
434: else
435: a0 := JTF_NUMBER_TABLE();

Line 438: a3 := JTF_VARCHAR2_TABLE_100();

434: else
435: a0 := JTF_NUMBER_TABLE();
436: a1 := JTF_NUMBER_TABLE();
437: a2 := JTF_NUMBER_TABLE();
438: a3 := JTF_VARCHAR2_TABLE_100();
439: a4 := JTF_NUMBER_TABLE();
440: a5 := JTF_NUMBER_TABLE();
441: a6 := JTF_NUMBER_TABLE();
442: a7 := JTF_VARCHAR2_TABLE_300();

Line 443: a8 := JTF_VARCHAR2_TABLE_100();

439: a4 := JTF_NUMBER_TABLE();
440: a5 := JTF_NUMBER_TABLE();
441: a6 := JTF_NUMBER_TABLE();
442: a7 := JTF_VARCHAR2_TABLE_300();
443: a8 := JTF_VARCHAR2_TABLE_100();
444: a9 := JTF_VARCHAR2_TABLE_100();
445: a10 := JTF_VARCHAR2_TABLE_100();
446: a11 := JTF_DATE_TABLE();
447: a12 := JTF_NUMBER_TABLE();

Line 444: a9 := JTF_VARCHAR2_TABLE_100();

440: a5 := JTF_NUMBER_TABLE();
441: a6 := JTF_NUMBER_TABLE();
442: a7 := JTF_VARCHAR2_TABLE_300();
443: a8 := JTF_VARCHAR2_TABLE_100();
444: a9 := JTF_VARCHAR2_TABLE_100();
445: a10 := JTF_VARCHAR2_TABLE_100();
446: a11 := JTF_DATE_TABLE();
447: a12 := JTF_NUMBER_TABLE();
448: a13 := JTF_NUMBER_TABLE();

Line 445: a10 := JTF_VARCHAR2_TABLE_100();

441: a6 := JTF_NUMBER_TABLE();
442: a7 := JTF_VARCHAR2_TABLE_300();
443: a8 := JTF_VARCHAR2_TABLE_100();
444: a9 := JTF_VARCHAR2_TABLE_100();
445: a10 := JTF_VARCHAR2_TABLE_100();
446: a11 := JTF_DATE_TABLE();
447: a12 := JTF_NUMBER_TABLE();
448: a13 := JTF_NUMBER_TABLE();
449: a14 := JTF_DATE_TABLE();

Line 450: a15 := JTF_VARCHAR2_TABLE_100();

446: a11 := JTF_DATE_TABLE();
447: a12 := JTF_NUMBER_TABLE();
448: a13 := JTF_NUMBER_TABLE();
449: a14 := JTF_DATE_TABLE();
450: a15 := JTF_VARCHAR2_TABLE_100();
451: a16 := JTF_VARCHAR2_TABLE_100();
452: a17 := JTF_VARCHAR2_TABLE_100();
453: a18 := JTF_NUMBER_TABLE();
454: a19 := JTF_VARCHAR2_TABLE_2000();

Line 451: a16 := JTF_VARCHAR2_TABLE_100();

447: a12 := JTF_NUMBER_TABLE();
448: a13 := JTF_NUMBER_TABLE();
449: a14 := JTF_DATE_TABLE();
450: a15 := JTF_VARCHAR2_TABLE_100();
451: a16 := JTF_VARCHAR2_TABLE_100();
452: a17 := JTF_VARCHAR2_TABLE_100();
453: a18 := JTF_NUMBER_TABLE();
454: a19 := JTF_VARCHAR2_TABLE_2000();
455: if t.count > 0 then

Line 452: a17 := JTF_VARCHAR2_TABLE_100();

448: a13 := JTF_NUMBER_TABLE();
449: a14 := JTF_DATE_TABLE();
450: a15 := JTF_VARCHAR2_TABLE_100();
451: a16 := JTF_VARCHAR2_TABLE_100();
452: a17 := JTF_VARCHAR2_TABLE_100();
453: a18 := JTF_NUMBER_TABLE();
454: a19 := JTF_VARCHAR2_TABLE_2000();
455: if t.count > 0 then
456: a0.extend(t.count);

Line 517: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100

513: , p_module_type VARCHAR2
514: , p5_a0 in out nocopy JTF_NUMBER_TABLE
515: , p5_a1 in out nocopy JTF_NUMBER_TABLE
516: , p5_a2 in out nocopy JTF_NUMBER_TABLE
517: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p5_a4 in out nocopy JTF_NUMBER_TABLE
519: , p5_a5 in out nocopy JTF_NUMBER_TABLE
520: , p5_a6 in out nocopy JTF_NUMBER_TABLE
521: , p5_a7 in out nocopy JTF_NUMBER_TABLE

Line 522: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100

518: , p5_a4 in out nocopy JTF_NUMBER_TABLE
519: , p5_a5 in out nocopy JTF_NUMBER_TABLE
520: , p5_a6 in out nocopy JTF_NUMBER_TABLE
521: , p5_a7 in out nocopy JTF_NUMBER_TABLE
522: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
525: , p5_a11 in out nocopy JTF_DATE_TABLE
526: , p5_a12 in out nocopy JTF_NUMBER_TABLE

Line 523: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100

519: , p5_a5 in out nocopy JTF_NUMBER_TABLE
520: , p5_a6 in out nocopy JTF_NUMBER_TABLE
521: , p5_a7 in out nocopy JTF_NUMBER_TABLE
522: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
525: , p5_a11 in out nocopy JTF_DATE_TABLE
526: , p5_a12 in out nocopy JTF_NUMBER_TABLE
527: , p5_a13 in out nocopy JTF_NUMBER_TABLE

Line 524: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100

520: , p5_a6 in out nocopy JTF_NUMBER_TABLE
521: , p5_a7 in out nocopy JTF_NUMBER_TABLE
522: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
525: , p5_a11 in out nocopy JTF_DATE_TABLE
526: , p5_a12 in out nocopy JTF_NUMBER_TABLE
527: , p5_a13 in out nocopy JTF_NUMBER_TABLE
528: , p5_a14 in out nocopy JTF_DATE_TABLE

Line 529: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100

525: , p5_a11 in out nocopy JTF_DATE_TABLE
526: , p5_a12 in out nocopy JTF_NUMBER_TABLE
527: , p5_a13 in out nocopy JTF_NUMBER_TABLE
528: , p5_a14 in out nocopy JTF_DATE_TABLE
529: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
530: , p5_a16 in out nocopy JTF_NUMBER_TABLE
531: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_2000
532: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
533: , x_return_status out nocopy VARCHAR2

Line 532: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100

528: , p5_a14 in out nocopy JTF_DATE_TABLE
529: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
530: , p5_a16 in out nocopy JTF_NUMBER_TABLE
531: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_2000
532: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100
533: , x_return_status out nocopy VARCHAR2
534: , x_msg_count out nocopy NUMBER
535: , x_msg_data out nocopy VARCHAR2
536: )

Line 624: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

620: , p_visit_id NUMBER
621: , p6_a0 out nocopy JTF_NUMBER_TABLE
622: , p6_a1 out nocopy JTF_NUMBER_TABLE
623: , p6_a2 out nocopy JTF_NUMBER_TABLE
624: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a6 out nocopy JTF_NUMBER_TABLE
628: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 625: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

621: , p6_a0 out nocopy JTF_NUMBER_TABLE
622: , p6_a1 out nocopy JTF_NUMBER_TABLE
623: , p6_a2 out nocopy JTF_NUMBER_TABLE
624: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a6 out nocopy JTF_NUMBER_TABLE
628: , p6_a7 out nocopy JTF_NUMBER_TABLE
629: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 626: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

622: , p6_a1 out nocopy JTF_NUMBER_TABLE
623: , p6_a2 out nocopy JTF_NUMBER_TABLE
624: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
626: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a6 out nocopy JTF_NUMBER_TABLE
628: , p6_a7 out nocopy JTF_NUMBER_TABLE
629: , p6_a8 out nocopy JTF_NUMBER_TABLE
630: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 630: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

626: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
627: , p6_a6 out nocopy JTF_NUMBER_TABLE
628: , p6_a7 out nocopy JTF_NUMBER_TABLE
629: , p6_a8 out nocopy JTF_NUMBER_TABLE
630: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a10 out nocopy JTF_DATE_TABLE
632: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a12 out nocopy JTF_NUMBER_TABLE
634: , p6_a13 out nocopy JTF_DATE_TABLE

Line 632: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

628: , p6_a7 out nocopy JTF_NUMBER_TABLE
629: , p6_a8 out nocopy JTF_NUMBER_TABLE
630: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
631: , p6_a10 out nocopy JTF_DATE_TABLE
632: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a12 out nocopy JTF_NUMBER_TABLE
634: , p6_a13 out nocopy JTF_DATE_TABLE
635: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
636: , p6_a15 out nocopy JTF_NUMBER_TABLE

Line 708: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

704: , p_visit_id NUMBER
705: , p6_a0 out nocopy JTF_NUMBER_TABLE
706: , p6_a1 out nocopy JTF_NUMBER_TABLE
707: , p6_a2 out nocopy JTF_NUMBER_TABLE
708: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a4 out nocopy JTF_NUMBER_TABLE
710: , p6_a5 out nocopy JTF_NUMBER_TABLE
711: , p6_a6 out nocopy JTF_NUMBER_TABLE
712: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 713: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

709: , p6_a4 out nocopy JTF_NUMBER_TABLE
710: , p6_a5 out nocopy JTF_NUMBER_TABLE
711: , p6_a6 out nocopy JTF_NUMBER_TABLE
712: , p6_a7 out nocopy JTF_NUMBER_TABLE
713: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
716: , p6_a11 out nocopy JTF_DATE_TABLE
717: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 714: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

710: , p6_a5 out nocopy JTF_NUMBER_TABLE
711: , p6_a6 out nocopy JTF_NUMBER_TABLE
712: , p6_a7 out nocopy JTF_NUMBER_TABLE
713: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
716: , p6_a11 out nocopy JTF_DATE_TABLE
717: , p6_a12 out nocopy JTF_NUMBER_TABLE
718: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 715: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

711: , p6_a6 out nocopy JTF_NUMBER_TABLE
712: , p6_a7 out nocopy JTF_NUMBER_TABLE
713: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
714: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
716: , p6_a11 out nocopy JTF_DATE_TABLE
717: , p6_a12 out nocopy JTF_NUMBER_TABLE
718: , p6_a13 out nocopy JTF_NUMBER_TABLE
719: , p6_a14 out nocopy JTF_DATE_TABLE

Line 720: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

716: , p6_a11 out nocopy JTF_DATE_TABLE
717: , p6_a12 out nocopy JTF_NUMBER_TABLE
718: , p6_a13 out nocopy JTF_NUMBER_TABLE
719: , p6_a14 out nocopy JTF_DATE_TABLE
720: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
721: , p6_a16 out nocopy JTF_NUMBER_TABLE
722: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
723: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
724: , x_return_status out nocopy VARCHAR2

Line 723: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

719: , p6_a14 out nocopy JTF_DATE_TABLE
720: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
721: , p6_a16 out nocopy JTF_NUMBER_TABLE
722: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
723: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
724: , x_return_status out nocopy VARCHAR2
725: , x_msg_count out nocopy NUMBER
726: , x_msg_data out nocopy VARCHAR2
727: )

Line 797: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100

793: , p_module_type VARCHAR2
794: , p5_a0 in out nocopy JTF_NUMBER_TABLE
795: , p5_a1 in out nocopy JTF_NUMBER_TABLE
796: , p5_a2 in out nocopy JTF_NUMBER_TABLE
797: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
798: , p5_a4 in out nocopy JTF_NUMBER_TABLE
799: , p5_a5 in out nocopy JTF_NUMBER_TABLE
800: , p5_a6 in out nocopy JTF_NUMBER_TABLE
801: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_300

Line 802: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100

798: , p5_a4 in out nocopy JTF_NUMBER_TABLE
799: , p5_a5 in out nocopy JTF_NUMBER_TABLE
800: , p5_a6 in out nocopy JTF_NUMBER_TABLE
801: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_300
802: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
803: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
804: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
805: , p5_a11 in out nocopy JTF_DATE_TABLE
806: , p5_a12 in out nocopy JTF_NUMBER_TABLE

Line 803: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100

799: , p5_a5 in out nocopy JTF_NUMBER_TABLE
800: , p5_a6 in out nocopy JTF_NUMBER_TABLE
801: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_300
802: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
803: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
804: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
805: , p5_a11 in out nocopy JTF_DATE_TABLE
806: , p5_a12 in out nocopy JTF_NUMBER_TABLE
807: , p5_a13 in out nocopy JTF_NUMBER_TABLE

Line 804: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100

800: , p5_a6 in out nocopy JTF_NUMBER_TABLE
801: , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_300
802: , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_100
803: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
804: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
805: , p5_a11 in out nocopy JTF_DATE_TABLE
806: , p5_a12 in out nocopy JTF_NUMBER_TABLE
807: , p5_a13 in out nocopy JTF_NUMBER_TABLE
808: , p5_a14 in out nocopy JTF_DATE_TABLE

Line 809: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100

805: , p5_a11 in out nocopy JTF_DATE_TABLE
806: , p5_a12 in out nocopy JTF_NUMBER_TABLE
807: , p5_a13 in out nocopy JTF_NUMBER_TABLE
808: , p5_a14 in out nocopy JTF_DATE_TABLE
809: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
810: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
811: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
812: , p5_a18 in out nocopy JTF_NUMBER_TABLE
813: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 810: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100

806: , p5_a12 in out nocopy JTF_NUMBER_TABLE
807: , p5_a13 in out nocopy JTF_NUMBER_TABLE
808: , p5_a14 in out nocopy JTF_DATE_TABLE
809: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
810: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
811: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
812: , p5_a18 in out nocopy JTF_NUMBER_TABLE
813: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_2000
814: , x_return_status out nocopy VARCHAR2

Line 811: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100

807: , p5_a13 in out nocopy JTF_NUMBER_TABLE
808: , p5_a14 in out nocopy JTF_DATE_TABLE
809: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
810: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
811: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
812: , p5_a18 in out nocopy JTF_NUMBER_TABLE
813: , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_2000
814: , x_return_status out nocopy VARCHAR2
815: , x_msg_count out nocopy NUMBER

Line 907: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

903: , p_visit_id NUMBER
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_NUMBER_TABLE
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 912: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_NUMBER_TABLE
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
912: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a11 out nocopy JTF_DATE_TABLE
916: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_NUMBER_TABLE
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
912: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a11 out nocopy JTF_DATE_TABLE
916: , p6_a12 out nocopy JTF_NUMBER_TABLE
917: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

910: , p6_a6 out nocopy JTF_NUMBER_TABLE
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
912: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a11 out nocopy JTF_DATE_TABLE
916: , p6_a12 out nocopy JTF_NUMBER_TABLE
917: , p6_a13 out nocopy JTF_NUMBER_TABLE
918: , p6_a14 out nocopy JTF_DATE_TABLE

Line 919: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

915: , p6_a11 out nocopy JTF_DATE_TABLE
916: , p6_a12 out nocopy JTF_NUMBER_TABLE
917: , p6_a13 out nocopy JTF_NUMBER_TABLE
918: , p6_a14 out nocopy JTF_DATE_TABLE
919: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
920: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
921: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
922: , p6_a18 out nocopy JTF_NUMBER_TABLE
923: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000

Line 920: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

916: , p6_a12 out nocopy JTF_NUMBER_TABLE
917: , p6_a13 out nocopy JTF_NUMBER_TABLE
918: , p6_a14 out nocopy JTF_DATE_TABLE
919: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
920: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
921: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
922: , p6_a18 out nocopy JTF_NUMBER_TABLE
923: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000
924: , x_return_status out nocopy VARCHAR2

Line 921: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

917: , p6_a13 out nocopy JTF_NUMBER_TABLE
918: , p6_a14 out nocopy JTF_DATE_TABLE
919: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
920: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
921: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
922: , p6_a18 out nocopy JTF_NUMBER_TABLE
923: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000
924: , x_return_status out nocopy VARCHAR2
925: , x_msg_count out nocopy NUMBER