APPS.CSP_SCH_INT_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: ) as
19: ddindx binary_integer; indx binary_integer;
20: begin

Line 41: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

37: end loop;
38: end if;
39: end if;
40: end rosetta_table_copy_in_p13;
41: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: ) as
44: ddindx binary_integer; indx binary_integer;
45: begin

Line 50: a0 := JTF_NUMBER_TABLE();

46: if t is null then
47: a0 := null;
48: a1 := null;
49: elsif t.count = 0 then
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();
52: else
53: a0 := JTF_NUMBER_TABLE();
54: a1 := JTF_VARCHAR2_TABLE_100();

Line 53: a0 := JTF_NUMBER_TABLE();

49: elsif t.count = 0 then
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();
52: else
53: a0 := JTF_NUMBER_TABLE();
54: a1 := JTF_VARCHAR2_TABLE_100();
55: if t.count > 0 then
56: a0.extend(t.count);
57: a1.extend(t.count);

Line 73: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE

69: end if;
70: end if;
71: end rosetta_table_copy_out_p13;
72:
73: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_DATE_TABLE
76: , a3 JTF_NUMBER_TABLE
77: , a4 JTF_NUMBER_TABLE

Line 76: , a3 JTF_NUMBER_TABLE

72:
73: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_DATE_TABLE
76: , a3 JTF_NUMBER_TABLE
77: , a4 JTF_NUMBER_TABLE
78: , a5 JTF_NUMBER_TABLE
79: , a6 JTF_VARCHAR2_TABLE_4000
80: , a7 JTF_VARCHAR2_TABLE_4000

Line 77: , a4 JTF_NUMBER_TABLE

73: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_DATE_TABLE
76: , a3 JTF_NUMBER_TABLE
77: , a4 JTF_NUMBER_TABLE
78: , a5 JTF_NUMBER_TABLE
79: , a6 JTF_VARCHAR2_TABLE_4000
80: , a7 JTF_VARCHAR2_TABLE_4000
81: , a8 JTF_VARCHAR2_TABLE_4000

Line 78: , a5 JTF_NUMBER_TABLE

74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_DATE_TABLE
76: , a3 JTF_NUMBER_TABLE
77: , a4 JTF_NUMBER_TABLE
78: , a5 JTF_NUMBER_TABLE
79: , a6 JTF_VARCHAR2_TABLE_4000
80: , a7 JTF_VARCHAR2_TABLE_4000
81: , a8 JTF_VARCHAR2_TABLE_4000
82: ) as

Line 112: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

108: end loop;
109: end if;
110: end if;
111: end rosetta_table_copy_in_p14;
112: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
114: , a2 out nocopy JTF_DATE_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE

Line 115: , a3 out nocopy JTF_NUMBER_TABLE

111: end rosetta_table_copy_in_p14;
112: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
114: , a2 out nocopy JTF_DATE_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_NUMBER_TABLE
118: , a6 out nocopy JTF_VARCHAR2_TABLE_4000
119: , a7 out nocopy JTF_VARCHAR2_TABLE_4000

Line 116: , a4 out nocopy JTF_NUMBER_TABLE

112: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
114: , a2 out nocopy JTF_DATE_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_NUMBER_TABLE
118: , a6 out nocopy JTF_VARCHAR2_TABLE_4000
119: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
120: , a8 out nocopy JTF_VARCHAR2_TABLE_4000

Line 117: , a5 out nocopy JTF_NUMBER_TABLE

113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
114: , a2 out nocopy JTF_DATE_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_NUMBER_TABLE
118: , a6 out nocopy JTF_VARCHAR2_TABLE_4000
119: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
120: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
121: ) as

Line 135: a0 := JTF_NUMBER_TABLE();

131: a6 := null;
132: a7 := null;
133: a8 := null;
134: elsif t.count = 0 then
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_VARCHAR2_TABLE_100();
137: a2 := JTF_DATE_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_NUMBER_TABLE();

Line 138: a3 := JTF_NUMBER_TABLE();

134: elsif t.count = 0 then
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_VARCHAR2_TABLE_100();
137: a2 := JTF_DATE_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_NUMBER_TABLE();
140: a5 := JTF_NUMBER_TABLE();
141: a6 := JTF_VARCHAR2_TABLE_4000();
142: a7 := JTF_VARCHAR2_TABLE_4000();

Line 139: a4 := JTF_NUMBER_TABLE();

135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_VARCHAR2_TABLE_100();
137: a2 := JTF_DATE_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_NUMBER_TABLE();
140: a5 := JTF_NUMBER_TABLE();
141: a6 := JTF_VARCHAR2_TABLE_4000();
142: a7 := JTF_VARCHAR2_TABLE_4000();
143: a8 := JTF_VARCHAR2_TABLE_4000();

Line 140: a5 := JTF_NUMBER_TABLE();

136: a1 := JTF_VARCHAR2_TABLE_100();
137: a2 := JTF_DATE_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_NUMBER_TABLE();
140: a5 := JTF_NUMBER_TABLE();
141: a6 := JTF_VARCHAR2_TABLE_4000();
142: a7 := JTF_VARCHAR2_TABLE_4000();
143: a8 := JTF_VARCHAR2_TABLE_4000();
144: else

Line 145: a0 := JTF_NUMBER_TABLE();

141: a6 := JTF_VARCHAR2_TABLE_4000();
142: a7 := JTF_VARCHAR2_TABLE_4000();
143: a8 := JTF_VARCHAR2_TABLE_4000();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();

Line 148: a3 := JTF_NUMBER_TABLE();

144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_VARCHAR2_TABLE_4000();
152: a7 := JTF_VARCHAR2_TABLE_4000();

Line 149: a4 := JTF_NUMBER_TABLE();

145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_VARCHAR2_TABLE_4000();
152: a7 := JTF_VARCHAR2_TABLE_4000();
153: a8 := JTF_VARCHAR2_TABLE_4000();

Line 150: a5 := JTF_NUMBER_TABLE();

146: a1 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_DATE_TABLE();
148: a3 := JTF_NUMBER_TABLE();
149: a4 := JTF_NUMBER_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_VARCHAR2_TABLE_4000();
152: a7 := JTF_VARCHAR2_TABLE_4000();
153: a8 := JTF_VARCHAR2_TABLE_4000();
154: if t.count > 0 then

Line 186: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE

182: end if;
183: end if;
184: end rosetta_table_copy_out_p14;
185:
186: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
187: , a1 JTF_VARCHAR2_TABLE_100
188: , a2 JTF_NUMBER_TABLE
189: , a3 JTF_NUMBER_TABLE
190: , a4 JTF_VARCHAR2_TABLE_100

Line 188: , a2 JTF_NUMBER_TABLE

184: end rosetta_table_copy_out_p14;
185:
186: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
187: , a1 JTF_VARCHAR2_TABLE_100
188: , a2 JTF_NUMBER_TABLE
189: , a3 JTF_NUMBER_TABLE
190: , a4 JTF_VARCHAR2_TABLE_100
191: , a5 JTF_VARCHAR2_TABLE_100
192: , a6 JTF_NUMBER_TABLE

Line 189: , a3 JTF_NUMBER_TABLE

185:
186: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
187: , a1 JTF_VARCHAR2_TABLE_100
188: , a2 JTF_NUMBER_TABLE
189: , a3 JTF_NUMBER_TABLE
190: , a4 JTF_VARCHAR2_TABLE_100
191: , a5 JTF_VARCHAR2_TABLE_100
192: , a6 JTF_NUMBER_TABLE
193: , a7 JTF_NUMBER_TABLE

Line 192: , a6 JTF_NUMBER_TABLE

188: , a2 JTF_NUMBER_TABLE
189: , a3 JTF_NUMBER_TABLE
190: , a4 JTF_VARCHAR2_TABLE_100
191: , a5 JTF_VARCHAR2_TABLE_100
192: , a6 JTF_NUMBER_TABLE
193: , a7 JTF_NUMBER_TABLE
194: , a8 JTF_NUMBER_TABLE
195: , a9 JTF_VARCHAR2_TABLE_100
196: ) as

Line 193: , a7 JTF_NUMBER_TABLE

189: , a3 JTF_NUMBER_TABLE
190: , a4 JTF_VARCHAR2_TABLE_100
191: , a5 JTF_VARCHAR2_TABLE_100
192: , a6 JTF_NUMBER_TABLE
193: , a7 JTF_NUMBER_TABLE
194: , a8 JTF_NUMBER_TABLE
195: , a9 JTF_VARCHAR2_TABLE_100
196: ) as
197: ddindx binary_integer; indx binary_integer;

Line 194: , a8 JTF_NUMBER_TABLE

190: , a4 JTF_VARCHAR2_TABLE_100
191: , a5 JTF_VARCHAR2_TABLE_100
192: , a6 JTF_NUMBER_TABLE
193: , a7 JTF_NUMBER_TABLE
194: , a8 JTF_NUMBER_TABLE
195: , a9 JTF_VARCHAR2_TABLE_100
196: ) as
197: ddindx binary_integer; indx binary_integer;
198: begin

Line 227: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

223: end loop;
224: end if;
225: end if;
226: end rosetta_table_copy_in_p15;
227: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
228: , a1 out nocopy JTF_VARCHAR2_TABLE_100
229: , a2 out nocopy JTF_NUMBER_TABLE
230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 229: , a2 out nocopy JTF_NUMBER_TABLE

225: end if;
226: end rosetta_table_copy_in_p15;
227: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
228: , a1 out nocopy JTF_VARCHAR2_TABLE_100
229: , a2 out nocopy JTF_NUMBER_TABLE
230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_VARCHAR2_TABLE_100
232: , a5 out nocopy JTF_VARCHAR2_TABLE_100
233: , a6 out nocopy JTF_NUMBER_TABLE

Line 230: , a3 out nocopy JTF_NUMBER_TABLE

226: end rosetta_table_copy_in_p15;
227: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
228: , a1 out nocopy JTF_VARCHAR2_TABLE_100
229: , a2 out nocopy JTF_NUMBER_TABLE
230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_VARCHAR2_TABLE_100
232: , a5 out nocopy JTF_VARCHAR2_TABLE_100
233: , a6 out nocopy JTF_NUMBER_TABLE
234: , a7 out nocopy JTF_NUMBER_TABLE

Line 233: , a6 out nocopy JTF_NUMBER_TABLE

229: , a2 out nocopy JTF_NUMBER_TABLE
230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_VARCHAR2_TABLE_100
232: , a5 out nocopy JTF_VARCHAR2_TABLE_100
233: , a6 out nocopy JTF_NUMBER_TABLE
234: , a7 out nocopy JTF_NUMBER_TABLE
235: , a8 out nocopy JTF_NUMBER_TABLE
236: , a9 out nocopy JTF_VARCHAR2_TABLE_100
237: ) as

Line 234: , a7 out nocopy JTF_NUMBER_TABLE

230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_VARCHAR2_TABLE_100
232: , a5 out nocopy JTF_VARCHAR2_TABLE_100
233: , a6 out nocopy JTF_NUMBER_TABLE
234: , a7 out nocopy JTF_NUMBER_TABLE
235: , a8 out nocopy JTF_NUMBER_TABLE
236: , a9 out nocopy JTF_VARCHAR2_TABLE_100
237: ) as
238: ddindx binary_integer; indx binary_integer;

Line 235: , a8 out nocopy JTF_NUMBER_TABLE

231: , a4 out nocopy JTF_VARCHAR2_TABLE_100
232: , a5 out nocopy JTF_VARCHAR2_TABLE_100
233: , a6 out nocopy JTF_NUMBER_TABLE
234: , a7 out nocopy JTF_NUMBER_TABLE
235: , a8 out nocopy JTF_NUMBER_TABLE
236: , a9 out nocopy JTF_VARCHAR2_TABLE_100
237: ) as
238: ddindx binary_integer; indx binary_integer;
239: begin

Line 252: a0 := JTF_NUMBER_TABLE();

248: a7 := null;
249: a8 := null;
250: a9 := null;
251: elsif t.count = 0 then
252: a0 := JTF_NUMBER_TABLE();
253: a1 := JTF_VARCHAR2_TABLE_100();
254: a2 := JTF_NUMBER_TABLE();
255: a3 := JTF_NUMBER_TABLE();
256: a4 := JTF_VARCHAR2_TABLE_100();

Line 254: a2 := JTF_NUMBER_TABLE();

250: a9 := null;
251: elsif t.count = 0 then
252: a0 := JTF_NUMBER_TABLE();
253: a1 := JTF_VARCHAR2_TABLE_100();
254: a2 := JTF_NUMBER_TABLE();
255: a3 := JTF_NUMBER_TABLE();
256: a4 := JTF_VARCHAR2_TABLE_100();
257: a5 := JTF_VARCHAR2_TABLE_100();
258: a6 := JTF_NUMBER_TABLE();

Line 255: a3 := JTF_NUMBER_TABLE();

251: elsif t.count = 0 then
252: a0 := JTF_NUMBER_TABLE();
253: a1 := JTF_VARCHAR2_TABLE_100();
254: a2 := JTF_NUMBER_TABLE();
255: a3 := JTF_NUMBER_TABLE();
256: a4 := JTF_VARCHAR2_TABLE_100();
257: a5 := JTF_VARCHAR2_TABLE_100();
258: a6 := JTF_NUMBER_TABLE();
259: a7 := JTF_NUMBER_TABLE();

Line 258: a6 := JTF_NUMBER_TABLE();

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

Line 259: a7 := JTF_NUMBER_TABLE();

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

Line 260: a8 := JTF_NUMBER_TABLE();

256: a4 := JTF_VARCHAR2_TABLE_100();
257: a5 := JTF_VARCHAR2_TABLE_100();
258: a6 := JTF_NUMBER_TABLE();
259: a7 := JTF_NUMBER_TABLE();
260: a8 := JTF_NUMBER_TABLE();
261: a9 := JTF_VARCHAR2_TABLE_100();
262: else
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_VARCHAR2_TABLE_100();

Line 263: a0 := JTF_NUMBER_TABLE();

259: a7 := JTF_NUMBER_TABLE();
260: a8 := JTF_NUMBER_TABLE();
261: a9 := JTF_VARCHAR2_TABLE_100();
262: else
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_VARCHAR2_TABLE_100();
265: a2 := JTF_NUMBER_TABLE();
266: a3 := JTF_NUMBER_TABLE();
267: a4 := JTF_VARCHAR2_TABLE_100();

Line 265: a2 := JTF_NUMBER_TABLE();

261: a9 := JTF_VARCHAR2_TABLE_100();
262: else
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_VARCHAR2_TABLE_100();
265: a2 := JTF_NUMBER_TABLE();
266: a3 := JTF_NUMBER_TABLE();
267: a4 := JTF_VARCHAR2_TABLE_100();
268: a5 := JTF_VARCHAR2_TABLE_100();
269: a6 := JTF_NUMBER_TABLE();

Line 266: a3 := JTF_NUMBER_TABLE();

262: else
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_VARCHAR2_TABLE_100();
265: a2 := JTF_NUMBER_TABLE();
266: a3 := JTF_NUMBER_TABLE();
267: a4 := JTF_VARCHAR2_TABLE_100();
268: a5 := JTF_VARCHAR2_TABLE_100();
269: a6 := JTF_NUMBER_TABLE();
270: a7 := JTF_NUMBER_TABLE();

Line 269: a6 := JTF_NUMBER_TABLE();

265: a2 := JTF_NUMBER_TABLE();
266: a3 := JTF_NUMBER_TABLE();
267: a4 := JTF_VARCHAR2_TABLE_100();
268: a5 := JTF_VARCHAR2_TABLE_100();
269: a6 := JTF_NUMBER_TABLE();
270: a7 := JTF_NUMBER_TABLE();
271: a8 := JTF_NUMBER_TABLE();
272: a9 := JTF_VARCHAR2_TABLE_100();
273: if t.count > 0 then

Line 270: a7 := JTF_NUMBER_TABLE();

266: a3 := JTF_NUMBER_TABLE();
267: a4 := JTF_VARCHAR2_TABLE_100();
268: a5 := JTF_VARCHAR2_TABLE_100();
269: a6 := JTF_NUMBER_TABLE();
270: a7 := JTF_NUMBER_TABLE();
271: a8 := JTF_NUMBER_TABLE();
272: a9 := JTF_VARCHAR2_TABLE_100();
273: if t.count > 0 then
274: a0.extend(t.count);

Line 271: a8 := JTF_NUMBER_TABLE();

267: a4 := JTF_VARCHAR2_TABLE_100();
268: a5 := JTF_VARCHAR2_TABLE_100();
269: a6 := JTF_NUMBER_TABLE();
270: a7 := JTF_NUMBER_TABLE();
271: a8 := JTF_NUMBER_TABLE();
272: a9 := JTF_VARCHAR2_TABLE_100();
273: if t.count > 0 then
274: a0.extend(t.count);
275: a1.extend(t.count);

Line 307: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE

303: end if;
304: end if;
305: end rosetta_table_copy_out_p15;
306:
307: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
308: , a1 JTF_VARCHAR2_TABLE_100
309: , a2 JTF_NUMBER_TABLE
310: , a3 JTF_NUMBER_TABLE
311: , a4 JTF_NUMBER_TABLE

Line 309: , a2 JTF_NUMBER_TABLE

305: end rosetta_table_copy_out_p15;
306:
307: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
308: , a1 JTF_VARCHAR2_TABLE_100
309: , a2 JTF_NUMBER_TABLE
310: , a3 JTF_NUMBER_TABLE
311: , a4 JTF_NUMBER_TABLE
312: , a5 JTF_NUMBER_TABLE
313: , a6 JTF_VARCHAR2_TABLE_100

Line 310: , a3 JTF_NUMBER_TABLE

306:
307: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
308: , a1 JTF_VARCHAR2_TABLE_100
309: , a2 JTF_NUMBER_TABLE
310: , a3 JTF_NUMBER_TABLE
311: , a4 JTF_NUMBER_TABLE
312: , a5 JTF_NUMBER_TABLE
313: , a6 JTF_VARCHAR2_TABLE_100
314: , a7 JTF_NUMBER_TABLE

Line 311: , a4 JTF_NUMBER_TABLE

307: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
308: , a1 JTF_VARCHAR2_TABLE_100
309: , a2 JTF_NUMBER_TABLE
310: , a3 JTF_NUMBER_TABLE
311: , a4 JTF_NUMBER_TABLE
312: , a5 JTF_NUMBER_TABLE
313: , a6 JTF_VARCHAR2_TABLE_100
314: , a7 JTF_NUMBER_TABLE
315: , a8 JTF_VARCHAR2_TABLE_100

Line 312: , a5 JTF_NUMBER_TABLE

308: , a1 JTF_VARCHAR2_TABLE_100
309: , a2 JTF_NUMBER_TABLE
310: , a3 JTF_NUMBER_TABLE
311: , a4 JTF_NUMBER_TABLE
312: , a5 JTF_NUMBER_TABLE
313: , a6 JTF_VARCHAR2_TABLE_100
314: , a7 JTF_NUMBER_TABLE
315: , a8 JTF_VARCHAR2_TABLE_100
316: , a9 JTF_NUMBER_TABLE

Line 314: , a7 JTF_NUMBER_TABLE

310: , a3 JTF_NUMBER_TABLE
311: , a4 JTF_NUMBER_TABLE
312: , a5 JTF_NUMBER_TABLE
313: , a6 JTF_VARCHAR2_TABLE_100
314: , a7 JTF_NUMBER_TABLE
315: , a8 JTF_VARCHAR2_TABLE_100
316: , a9 JTF_NUMBER_TABLE
317: , a10 JTF_NUMBER_TABLE
318: , a11 JTF_NUMBER_TABLE

Line 316: , a9 JTF_NUMBER_TABLE

312: , a5 JTF_NUMBER_TABLE
313: , a6 JTF_VARCHAR2_TABLE_100
314: , a7 JTF_NUMBER_TABLE
315: , a8 JTF_VARCHAR2_TABLE_100
316: , a9 JTF_NUMBER_TABLE
317: , a10 JTF_NUMBER_TABLE
318: , a11 JTF_NUMBER_TABLE
319: , a12 JTF_VARCHAR2_TABLE_100
320: , a13 JTF_DATE_TABLE

Line 317: , a10 JTF_NUMBER_TABLE

313: , a6 JTF_VARCHAR2_TABLE_100
314: , a7 JTF_NUMBER_TABLE
315: , a8 JTF_VARCHAR2_TABLE_100
316: , a9 JTF_NUMBER_TABLE
317: , a10 JTF_NUMBER_TABLE
318: , a11 JTF_NUMBER_TABLE
319: , a12 JTF_VARCHAR2_TABLE_100
320: , a13 JTF_DATE_TABLE
321: , a14 JTF_VARCHAR2_TABLE_100

Line 318: , a11 JTF_NUMBER_TABLE

314: , a7 JTF_NUMBER_TABLE
315: , a8 JTF_VARCHAR2_TABLE_100
316: , a9 JTF_NUMBER_TABLE
317: , a10 JTF_NUMBER_TABLE
318: , a11 JTF_NUMBER_TABLE
319: , a12 JTF_VARCHAR2_TABLE_100
320: , a13 JTF_DATE_TABLE
321: , a14 JTF_VARCHAR2_TABLE_100
322: , a15 JTF_NUMBER_TABLE

Line 322: , a15 JTF_NUMBER_TABLE

318: , a11 JTF_NUMBER_TABLE
319: , a12 JTF_VARCHAR2_TABLE_100
320: , a13 JTF_DATE_TABLE
321: , a14 JTF_VARCHAR2_TABLE_100
322: , a15 JTF_NUMBER_TABLE
323: , a16 JTF_VARCHAR2_TABLE_100
324: ) as
325: ddindx binary_integer; indx binary_integer;
326: begin

Line 362: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

358: end loop;
359: end if;
360: end if;
361: end rosetta_table_copy_in_p16;
362: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
363: , a1 out nocopy JTF_VARCHAR2_TABLE_100
364: , a2 out nocopy JTF_NUMBER_TABLE
365: , a3 out nocopy JTF_NUMBER_TABLE
366: , a4 out nocopy JTF_NUMBER_TABLE

Line 364: , a2 out nocopy JTF_NUMBER_TABLE

360: end if;
361: end rosetta_table_copy_in_p16;
362: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
363: , a1 out nocopy JTF_VARCHAR2_TABLE_100
364: , a2 out nocopy JTF_NUMBER_TABLE
365: , a3 out nocopy JTF_NUMBER_TABLE
366: , a4 out nocopy JTF_NUMBER_TABLE
367: , a5 out nocopy JTF_NUMBER_TABLE
368: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 365: , a3 out nocopy JTF_NUMBER_TABLE

361: end rosetta_table_copy_in_p16;
362: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
363: , a1 out nocopy JTF_VARCHAR2_TABLE_100
364: , a2 out nocopy JTF_NUMBER_TABLE
365: , a3 out nocopy JTF_NUMBER_TABLE
366: , a4 out nocopy JTF_NUMBER_TABLE
367: , a5 out nocopy JTF_NUMBER_TABLE
368: , a6 out nocopy JTF_VARCHAR2_TABLE_100
369: , a7 out nocopy JTF_NUMBER_TABLE

Line 366: , a4 out nocopy JTF_NUMBER_TABLE

362: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
363: , a1 out nocopy JTF_VARCHAR2_TABLE_100
364: , a2 out nocopy JTF_NUMBER_TABLE
365: , a3 out nocopy JTF_NUMBER_TABLE
366: , a4 out nocopy JTF_NUMBER_TABLE
367: , a5 out nocopy JTF_NUMBER_TABLE
368: , a6 out nocopy JTF_VARCHAR2_TABLE_100
369: , a7 out nocopy JTF_NUMBER_TABLE
370: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 367: , a5 out nocopy JTF_NUMBER_TABLE

363: , a1 out nocopy JTF_VARCHAR2_TABLE_100
364: , a2 out nocopy JTF_NUMBER_TABLE
365: , a3 out nocopy JTF_NUMBER_TABLE
366: , a4 out nocopy JTF_NUMBER_TABLE
367: , a5 out nocopy JTF_NUMBER_TABLE
368: , a6 out nocopy JTF_VARCHAR2_TABLE_100
369: , a7 out nocopy JTF_NUMBER_TABLE
370: , a8 out nocopy JTF_VARCHAR2_TABLE_100
371: , a9 out nocopy JTF_NUMBER_TABLE

Line 369: , a7 out nocopy JTF_NUMBER_TABLE

365: , a3 out nocopy JTF_NUMBER_TABLE
366: , a4 out nocopy JTF_NUMBER_TABLE
367: , a5 out nocopy JTF_NUMBER_TABLE
368: , a6 out nocopy JTF_VARCHAR2_TABLE_100
369: , a7 out nocopy JTF_NUMBER_TABLE
370: , a8 out nocopy JTF_VARCHAR2_TABLE_100
371: , a9 out nocopy JTF_NUMBER_TABLE
372: , a10 out nocopy JTF_NUMBER_TABLE
373: , a11 out nocopy JTF_NUMBER_TABLE

Line 371: , a9 out nocopy JTF_NUMBER_TABLE

367: , a5 out nocopy JTF_NUMBER_TABLE
368: , a6 out nocopy JTF_VARCHAR2_TABLE_100
369: , a7 out nocopy JTF_NUMBER_TABLE
370: , a8 out nocopy JTF_VARCHAR2_TABLE_100
371: , a9 out nocopy JTF_NUMBER_TABLE
372: , a10 out nocopy JTF_NUMBER_TABLE
373: , a11 out nocopy JTF_NUMBER_TABLE
374: , a12 out nocopy JTF_VARCHAR2_TABLE_100
375: , a13 out nocopy JTF_DATE_TABLE

Line 372: , a10 out nocopy JTF_NUMBER_TABLE

368: , a6 out nocopy JTF_VARCHAR2_TABLE_100
369: , a7 out nocopy JTF_NUMBER_TABLE
370: , a8 out nocopy JTF_VARCHAR2_TABLE_100
371: , a9 out nocopy JTF_NUMBER_TABLE
372: , a10 out nocopy JTF_NUMBER_TABLE
373: , a11 out nocopy JTF_NUMBER_TABLE
374: , a12 out nocopy JTF_VARCHAR2_TABLE_100
375: , a13 out nocopy JTF_DATE_TABLE
376: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 373: , a11 out nocopy JTF_NUMBER_TABLE

369: , a7 out nocopy JTF_NUMBER_TABLE
370: , a8 out nocopy JTF_VARCHAR2_TABLE_100
371: , a9 out nocopy JTF_NUMBER_TABLE
372: , a10 out nocopy JTF_NUMBER_TABLE
373: , a11 out nocopy JTF_NUMBER_TABLE
374: , a12 out nocopy JTF_VARCHAR2_TABLE_100
375: , a13 out nocopy JTF_DATE_TABLE
376: , a14 out nocopy JTF_VARCHAR2_TABLE_100
377: , a15 out nocopy JTF_NUMBER_TABLE

Line 377: , a15 out nocopy JTF_NUMBER_TABLE

373: , a11 out nocopy JTF_NUMBER_TABLE
374: , a12 out nocopy JTF_VARCHAR2_TABLE_100
375: , a13 out nocopy JTF_DATE_TABLE
376: , a14 out nocopy JTF_VARCHAR2_TABLE_100
377: , a15 out nocopy JTF_NUMBER_TABLE
378: , a16 out nocopy JTF_VARCHAR2_TABLE_100
379: ) as
380: ddindx binary_integer; indx binary_integer;
381: begin

Line 401: a0 := JTF_NUMBER_TABLE();

397: a14 := null;
398: a15 := null;
399: a16 := null;
400: elsif t.count = 0 then
401: a0 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_NUMBER_TABLE();
405: a4 := JTF_NUMBER_TABLE();

Line 403: a2 := JTF_NUMBER_TABLE();

399: a16 := null;
400: elsif t.count = 0 then
401: a0 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_NUMBER_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_NUMBER_TABLE();
407: a6 := JTF_VARCHAR2_TABLE_100();

Line 404: a3 := JTF_NUMBER_TABLE();

400: elsif t.count = 0 then
401: a0 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_NUMBER_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_NUMBER_TABLE();
407: a6 := JTF_VARCHAR2_TABLE_100();
408: a7 := JTF_NUMBER_TABLE();

Line 405: a4 := JTF_NUMBER_TABLE();

401: a0 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_NUMBER_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_NUMBER_TABLE();
407: a6 := JTF_VARCHAR2_TABLE_100();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_VARCHAR2_TABLE_100();

Line 406: a5 := JTF_NUMBER_TABLE();

402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_NUMBER_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_NUMBER_TABLE();
407: a6 := JTF_VARCHAR2_TABLE_100();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_VARCHAR2_TABLE_100();
410: a9 := JTF_NUMBER_TABLE();

Line 408: a7 := JTF_NUMBER_TABLE();

404: a3 := JTF_NUMBER_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_NUMBER_TABLE();
407: a6 := JTF_VARCHAR2_TABLE_100();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_VARCHAR2_TABLE_100();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_NUMBER_TABLE();

Line 410: a9 := JTF_NUMBER_TABLE();

406: a5 := JTF_NUMBER_TABLE();
407: a6 := JTF_VARCHAR2_TABLE_100();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_VARCHAR2_TABLE_100();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_NUMBER_TABLE();
413: a12 := JTF_VARCHAR2_TABLE_100();
414: a13 := JTF_DATE_TABLE();

Line 411: a10 := JTF_NUMBER_TABLE();

407: a6 := JTF_VARCHAR2_TABLE_100();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_VARCHAR2_TABLE_100();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_NUMBER_TABLE();
413: a12 := JTF_VARCHAR2_TABLE_100();
414: a13 := JTF_DATE_TABLE();
415: a14 := JTF_VARCHAR2_TABLE_100();

Line 412: a11 := JTF_NUMBER_TABLE();

408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_VARCHAR2_TABLE_100();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_NUMBER_TABLE();
413: a12 := JTF_VARCHAR2_TABLE_100();
414: a13 := JTF_DATE_TABLE();
415: a14 := JTF_VARCHAR2_TABLE_100();
416: a15 := JTF_NUMBER_TABLE();

Line 416: a15 := JTF_NUMBER_TABLE();

412: a11 := JTF_NUMBER_TABLE();
413: a12 := JTF_VARCHAR2_TABLE_100();
414: a13 := JTF_DATE_TABLE();
415: a14 := JTF_VARCHAR2_TABLE_100();
416: a15 := JTF_NUMBER_TABLE();
417: a16 := JTF_VARCHAR2_TABLE_100();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_100();

Line 419: a0 := JTF_NUMBER_TABLE();

415: a14 := JTF_VARCHAR2_TABLE_100();
416: a15 := JTF_NUMBER_TABLE();
417: a16 := JTF_VARCHAR2_TABLE_100();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_100();
421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_NUMBER_TABLE();

Line 421: a2 := JTF_NUMBER_TABLE();

417: a16 := JTF_VARCHAR2_TABLE_100();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_100();
421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_NUMBER_TABLE();
424: a5 := JTF_NUMBER_TABLE();
425: a6 := JTF_VARCHAR2_TABLE_100();

Line 422: a3 := JTF_NUMBER_TABLE();

418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_100();
421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_NUMBER_TABLE();
424: a5 := JTF_NUMBER_TABLE();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_NUMBER_TABLE();

Line 423: a4 := JTF_NUMBER_TABLE();

419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_100();
421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_NUMBER_TABLE();
424: a5 := JTF_NUMBER_TABLE();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_NUMBER_TABLE();
427: a8 := JTF_VARCHAR2_TABLE_100();

Line 424: a5 := JTF_NUMBER_TABLE();

420: a1 := JTF_VARCHAR2_TABLE_100();
421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_NUMBER_TABLE();
424: a5 := JTF_NUMBER_TABLE();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_NUMBER_TABLE();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();

Line 426: a7 := JTF_NUMBER_TABLE();

422: a3 := JTF_NUMBER_TABLE();
423: a4 := JTF_NUMBER_TABLE();
424: a5 := JTF_NUMBER_TABLE();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_NUMBER_TABLE();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_NUMBER_TABLE();

Line 428: a9 := JTF_NUMBER_TABLE();

424: a5 := JTF_NUMBER_TABLE();
425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_NUMBER_TABLE();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_NUMBER_TABLE();
431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_DATE_TABLE();

Line 429: a10 := JTF_NUMBER_TABLE();

425: a6 := JTF_VARCHAR2_TABLE_100();
426: a7 := JTF_NUMBER_TABLE();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_NUMBER_TABLE();
431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_DATE_TABLE();
433: a14 := JTF_VARCHAR2_TABLE_100();

Line 430: a11 := JTF_NUMBER_TABLE();

426: a7 := JTF_NUMBER_TABLE();
427: a8 := JTF_VARCHAR2_TABLE_100();
428: a9 := JTF_NUMBER_TABLE();
429: a10 := JTF_NUMBER_TABLE();
430: a11 := JTF_NUMBER_TABLE();
431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_DATE_TABLE();
433: a14 := JTF_VARCHAR2_TABLE_100();
434: a15 := JTF_NUMBER_TABLE();

Line 434: a15 := JTF_NUMBER_TABLE();

430: a11 := JTF_NUMBER_TABLE();
431: a12 := JTF_VARCHAR2_TABLE_100();
432: a13 := JTF_DATE_TABLE();
433: a14 := JTF_VARCHAR2_TABLE_100();
434: a15 := JTF_NUMBER_TABLE();
435: a16 := JTF_VARCHAR2_TABLE_100();
436: if t.count > 0 then
437: a0.extend(t.count);
438: a1.extend(t.count);

Line 484: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE

480: end if;
481: end if;
482: end rosetta_table_copy_out_p16;
483:
484: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
485: , a1 JTF_VARCHAR2_TABLE_100
486: , a2 JTF_VARCHAR2_TABLE_100
487: , a3 JTF_NUMBER_TABLE
488: , a4 JTF_VARCHAR2_TABLE_100

Line 487: , a3 JTF_NUMBER_TABLE

483:
484: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
485: , a1 JTF_VARCHAR2_TABLE_100
486: , a2 JTF_VARCHAR2_TABLE_100
487: , a3 JTF_NUMBER_TABLE
488: , a4 JTF_VARCHAR2_TABLE_100
489: , a5 JTF_NUMBER_TABLE
490: ) as
491: ddindx binary_integer; indx binary_integer;

Line 489: , a5 JTF_NUMBER_TABLE

485: , a1 JTF_VARCHAR2_TABLE_100
486: , a2 JTF_VARCHAR2_TABLE_100
487: , a3 JTF_NUMBER_TABLE
488: , a4 JTF_VARCHAR2_TABLE_100
489: , a5 JTF_NUMBER_TABLE
490: ) as
491: ddindx binary_integer; indx binary_integer;
492: begin
493: if a0 is not null and a0.count=0 then

Line 517: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

513: end loop;
514: end if;
515: end if;
516: end rosetta_table_copy_in_p17;
517: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
518: , a1 out nocopy JTF_VARCHAR2_TABLE_100
519: , a2 out nocopy JTF_VARCHAR2_TABLE_100
520: , a3 out nocopy JTF_NUMBER_TABLE
521: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 520: , a3 out nocopy JTF_NUMBER_TABLE

516: end rosetta_table_copy_in_p17;
517: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
518: , a1 out nocopy JTF_VARCHAR2_TABLE_100
519: , a2 out nocopy JTF_VARCHAR2_TABLE_100
520: , a3 out nocopy JTF_NUMBER_TABLE
521: , a4 out nocopy JTF_VARCHAR2_TABLE_100
522: , a5 out nocopy JTF_NUMBER_TABLE
523: ) as
524: ddindx binary_integer; indx binary_integer;

Line 522: , a5 out nocopy JTF_NUMBER_TABLE

518: , a1 out nocopy JTF_VARCHAR2_TABLE_100
519: , a2 out nocopy JTF_VARCHAR2_TABLE_100
520: , a3 out nocopy JTF_NUMBER_TABLE
521: , a4 out nocopy JTF_VARCHAR2_TABLE_100
522: , a5 out nocopy JTF_NUMBER_TABLE
523: ) as
524: ddindx binary_integer; indx binary_integer;
525: begin
526: if t is null then

Line 534: a0 := JTF_NUMBER_TABLE();

530: a3 := null;
531: a4 := null;
532: a5 := null;
533: elsif t.count = 0 then
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_100();
536: a2 := JTF_VARCHAR2_TABLE_100();
537: a3 := JTF_NUMBER_TABLE();
538: a4 := JTF_VARCHAR2_TABLE_100();

Line 537: a3 := JTF_NUMBER_TABLE();

533: elsif t.count = 0 then
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_100();
536: a2 := JTF_VARCHAR2_TABLE_100();
537: a3 := JTF_NUMBER_TABLE();
538: a4 := JTF_VARCHAR2_TABLE_100();
539: a5 := JTF_NUMBER_TABLE();
540: else
541: a0 := JTF_NUMBER_TABLE();

Line 539: a5 := JTF_NUMBER_TABLE();

535: a1 := JTF_VARCHAR2_TABLE_100();
536: a2 := JTF_VARCHAR2_TABLE_100();
537: a3 := JTF_NUMBER_TABLE();
538: a4 := JTF_VARCHAR2_TABLE_100();
539: a5 := JTF_NUMBER_TABLE();
540: else
541: a0 := JTF_NUMBER_TABLE();
542: a1 := JTF_VARCHAR2_TABLE_100();
543: a2 := JTF_VARCHAR2_TABLE_100();

Line 541: a0 := JTF_NUMBER_TABLE();

537: a3 := JTF_NUMBER_TABLE();
538: a4 := JTF_VARCHAR2_TABLE_100();
539: a5 := JTF_NUMBER_TABLE();
540: else
541: a0 := JTF_NUMBER_TABLE();
542: a1 := JTF_VARCHAR2_TABLE_100();
543: a2 := JTF_VARCHAR2_TABLE_100();
544: a3 := JTF_NUMBER_TABLE();
545: a4 := JTF_VARCHAR2_TABLE_100();

Line 544: a3 := JTF_NUMBER_TABLE();

540: else
541: a0 := JTF_NUMBER_TABLE();
542: a1 := JTF_VARCHAR2_TABLE_100();
543: a2 := JTF_VARCHAR2_TABLE_100();
544: a3 := JTF_NUMBER_TABLE();
545: a4 := JTF_VARCHAR2_TABLE_100();
546: a5 := JTF_NUMBER_TABLE();
547: if t.count > 0 then
548: a0.extend(t.count);

Line 546: a5 := JTF_NUMBER_TABLE();

542: a1 := JTF_VARCHAR2_TABLE_100();
543: a2 := JTF_VARCHAR2_TABLE_100();
544: a3 := JTF_NUMBER_TABLE();
545: a4 := JTF_VARCHAR2_TABLE_100();
546: a5 := JTF_NUMBER_TABLE();
547: if t.count > 0 then
548: a0.extend(t.count);
549: a1.extend(t.count);
550: a2.extend(t.count);

Line 573: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

569: end if;
570: end if;
571: end rosetta_table_copy_out_p17;
572:
573: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
574: , a1 JTF_VARCHAR2_TABLE_100
575: , a2 JTF_NUMBER_TABLE
576: , a3 JTF_NUMBER_TABLE
577: , a4 JTF_VARCHAR2_TABLE_100

Line 575: , a2 JTF_NUMBER_TABLE

571: end rosetta_table_copy_out_p17;
572:
573: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
574: , a1 JTF_VARCHAR2_TABLE_100
575: , a2 JTF_NUMBER_TABLE
576: , a3 JTF_NUMBER_TABLE
577: , a4 JTF_VARCHAR2_TABLE_100
578: , a5 JTF_NUMBER_TABLE
579: , a6 JTF_NUMBER_TABLE

Line 576: , a3 JTF_NUMBER_TABLE

572:
573: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
574: , a1 JTF_VARCHAR2_TABLE_100
575: , a2 JTF_NUMBER_TABLE
576: , a3 JTF_NUMBER_TABLE
577: , a4 JTF_VARCHAR2_TABLE_100
578: , a5 JTF_NUMBER_TABLE
579: , a6 JTF_NUMBER_TABLE
580: , a7 JTF_NUMBER_TABLE

Line 578: , a5 JTF_NUMBER_TABLE

574: , a1 JTF_VARCHAR2_TABLE_100
575: , a2 JTF_NUMBER_TABLE
576: , a3 JTF_NUMBER_TABLE
577: , a4 JTF_VARCHAR2_TABLE_100
578: , a5 JTF_NUMBER_TABLE
579: , a6 JTF_NUMBER_TABLE
580: , a7 JTF_NUMBER_TABLE
581: , a8 JTF_VARCHAR2_TABLE_100
582: , a9 JTF_DATE_TABLE

Line 579: , a6 JTF_NUMBER_TABLE

575: , a2 JTF_NUMBER_TABLE
576: , a3 JTF_NUMBER_TABLE
577: , a4 JTF_VARCHAR2_TABLE_100
578: , a5 JTF_NUMBER_TABLE
579: , a6 JTF_NUMBER_TABLE
580: , a7 JTF_NUMBER_TABLE
581: , a8 JTF_VARCHAR2_TABLE_100
582: , a9 JTF_DATE_TABLE
583: , a10 JTF_DATE_TABLE

Line 580: , a7 JTF_NUMBER_TABLE

576: , a3 JTF_NUMBER_TABLE
577: , a4 JTF_VARCHAR2_TABLE_100
578: , a5 JTF_NUMBER_TABLE
579: , a6 JTF_NUMBER_TABLE
580: , a7 JTF_NUMBER_TABLE
581: , a8 JTF_VARCHAR2_TABLE_100
582: , a9 JTF_DATE_TABLE
583: , a10 JTF_DATE_TABLE
584: , a11 JTF_VARCHAR2_TABLE_100

Line 585: , a12 JTF_NUMBER_TABLE

581: , a8 JTF_VARCHAR2_TABLE_100
582: , a9 JTF_DATE_TABLE
583: , a10 JTF_DATE_TABLE
584: , a11 JTF_VARCHAR2_TABLE_100
585: , a12 JTF_NUMBER_TABLE
586: , a13 JTF_NUMBER_TABLE
587: , a14 JTF_VARCHAR2_TABLE_100
588: , a15 JTF_VARCHAR2_TABLE_100
589: ) as

Line 586: , a13 JTF_NUMBER_TABLE

582: , a9 JTF_DATE_TABLE
583: , a10 JTF_DATE_TABLE
584: , a11 JTF_VARCHAR2_TABLE_100
585: , a12 JTF_NUMBER_TABLE
586: , a13 JTF_NUMBER_TABLE
587: , a14 JTF_VARCHAR2_TABLE_100
588: , a15 JTF_VARCHAR2_TABLE_100
589: ) as
590: ddindx binary_integer; indx binary_integer;

Line 626: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

622: end loop;
623: end if;
624: end if;
625: end rosetta_table_copy_in_p18;
626: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
627: , a1 out nocopy JTF_VARCHAR2_TABLE_100
628: , a2 out nocopy JTF_NUMBER_TABLE
629: , a3 out nocopy JTF_NUMBER_TABLE
630: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 628: , a2 out nocopy JTF_NUMBER_TABLE

624: end if;
625: end rosetta_table_copy_in_p18;
626: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
627: , a1 out nocopy JTF_VARCHAR2_TABLE_100
628: , a2 out nocopy JTF_NUMBER_TABLE
629: , a3 out nocopy JTF_NUMBER_TABLE
630: , a4 out nocopy JTF_VARCHAR2_TABLE_100
631: , a5 out nocopy JTF_NUMBER_TABLE
632: , a6 out nocopy JTF_NUMBER_TABLE

Line 629: , a3 out nocopy JTF_NUMBER_TABLE

625: end rosetta_table_copy_in_p18;
626: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
627: , a1 out nocopy JTF_VARCHAR2_TABLE_100
628: , a2 out nocopy JTF_NUMBER_TABLE
629: , a3 out nocopy JTF_NUMBER_TABLE
630: , a4 out nocopy JTF_VARCHAR2_TABLE_100
631: , a5 out nocopy JTF_NUMBER_TABLE
632: , a6 out nocopy JTF_NUMBER_TABLE
633: , a7 out nocopy JTF_NUMBER_TABLE

Line 631: , a5 out nocopy JTF_NUMBER_TABLE

627: , a1 out nocopy JTF_VARCHAR2_TABLE_100
628: , a2 out nocopy JTF_NUMBER_TABLE
629: , a3 out nocopy JTF_NUMBER_TABLE
630: , a4 out nocopy JTF_VARCHAR2_TABLE_100
631: , a5 out nocopy JTF_NUMBER_TABLE
632: , a6 out nocopy JTF_NUMBER_TABLE
633: , a7 out nocopy JTF_NUMBER_TABLE
634: , a8 out nocopy JTF_VARCHAR2_TABLE_100
635: , a9 out nocopy JTF_DATE_TABLE

Line 632: , a6 out nocopy JTF_NUMBER_TABLE

628: , a2 out nocopy JTF_NUMBER_TABLE
629: , a3 out nocopy JTF_NUMBER_TABLE
630: , a4 out nocopy JTF_VARCHAR2_TABLE_100
631: , a5 out nocopy JTF_NUMBER_TABLE
632: , a6 out nocopy JTF_NUMBER_TABLE
633: , a7 out nocopy JTF_NUMBER_TABLE
634: , a8 out nocopy JTF_VARCHAR2_TABLE_100
635: , a9 out nocopy JTF_DATE_TABLE
636: , a10 out nocopy JTF_DATE_TABLE

Line 633: , a7 out nocopy JTF_NUMBER_TABLE

629: , a3 out nocopy JTF_NUMBER_TABLE
630: , a4 out nocopy JTF_VARCHAR2_TABLE_100
631: , a5 out nocopy JTF_NUMBER_TABLE
632: , a6 out nocopy JTF_NUMBER_TABLE
633: , a7 out nocopy JTF_NUMBER_TABLE
634: , a8 out nocopy JTF_VARCHAR2_TABLE_100
635: , a9 out nocopy JTF_DATE_TABLE
636: , a10 out nocopy JTF_DATE_TABLE
637: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 638: , a12 out nocopy JTF_NUMBER_TABLE

634: , a8 out nocopy JTF_VARCHAR2_TABLE_100
635: , a9 out nocopy JTF_DATE_TABLE
636: , a10 out nocopy JTF_DATE_TABLE
637: , a11 out nocopy JTF_VARCHAR2_TABLE_100
638: , a12 out nocopy JTF_NUMBER_TABLE
639: , a13 out nocopy JTF_NUMBER_TABLE
640: , a14 out nocopy JTF_VARCHAR2_TABLE_100
641: , a15 out nocopy JTF_VARCHAR2_TABLE_100
642: ) as

Line 639: , a13 out nocopy JTF_NUMBER_TABLE

635: , a9 out nocopy JTF_DATE_TABLE
636: , a10 out nocopy JTF_DATE_TABLE
637: , a11 out nocopy JTF_VARCHAR2_TABLE_100
638: , a12 out nocopy JTF_NUMBER_TABLE
639: , a13 out nocopy JTF_NUMBER_TABLE
640: , a14 out nocopy JTF_VARCHAR2_TABLE_100
641: , a15 out nocopy JTF_VARCHAR2_TABLE_100
642: ) as
643: ddindx binary_integer; indx binary_integer;

Line 663: a0 := JTF_NUMBER_TABLE();

659: a13 := null;
660: a14 := null;
661: a15 := null;
662: elsif t.count = 0 then
663: a0 := JTF_NUMBER_TABLE();
664: a1 := JTF_VARCHAR2_TABLE_100();
665: a2 := JTF_NUMBER_TABLE();
666: a3 := JTF_NUMBER_TABLE();
667: a4 := JTF_VARCHAR2_TABLE_100();

Line 665: a2 := JTF_NUMBER_TABLE();

661: a15 := null;
662: elsif t.count = 0 then
663: a0 := JTF_NUMBER_TABLE();
664: a1 := JTF_VARCHAR2_TABLE_100();
665: a2 := JTF_NUMBER_TABLE();
666: a3 := JTF_NUMBER_TABLE();
667: a4 := JTF_VARCHAR2_TABLE_100();
668: a5 := JTF_NUMBER_TABLE();
669: a6 := JTF_NUMBER_TABLE();

Line 666: a3 := JTF_NUMBER_TABLE();

662: elsif t.count = 0 then
663: a0 := JTF_NUMBER_TABLE();
664: a1 := JTF_VARCHAR2_TABLE_100();
665: a2 := JTF_NUMBER_TABLE();
666: a3 := JTF_NUMBER_TABLE();
667: a4 := JTF_VARCHAR2_TABLE_100();
668: a5 := JTF_NUMBER_TABLE();
669: a6 := JTF_NUMBER_TABLE();
670: a7 := JTF_NUMBER_TABLE();

Line 668: a5 := JTF_NUMBER_TABLE();

664: a1 := JTF_VARCHAR2_TABLE_100();
665: a2 := JTF_NUMBER_TABLE();
666: a3 := JTF_NUMBER_TABLE();
667: a4 := JTF_VARCHAR2_TABLE_100();
668: a5 := JTF_NUMBER_TABLE();
669: a6 := JTF_NUMBER_TABLE();
670: a7 := JTF_NUMBER_TABLE();
671: a8 := JTF_VARCHAR2_TABLE_100();
672: a9 := JTF_DATE_TABLE();

Line 669: a6 := JTF_NUMBER_TABLE();

665: a2 := JTF_NUMBER_TABLE();
666: a3 := JTF_NUMBER_TABLE();
667: a4 := JTF_VARCHAR2_TABLE_100();
668: a5 := JTF_NUMBER_TABLE();
669: a6 := JTF_NUMBER_TABLE();
670: a7 := JTF_NUMBER_TABLE();
671: a8 := JTF_VARCHAR2_TABLE_100();
672: a9 := JTF_DATE_TABLE();
673: a10 := JTF_DATE_TABLE();

Line 670: a7 := JTF_NUMBER_TABLE();

666: a3 := JTF_NUMBER_TABLE();
667: a4 := JTF_VARCHAR2_TABLE_100();
668: a5 := JTF_NUMBER_TABLE();
669: a6 := JTF_NUMBER_TABLE();
670: a7 := JTF_NUMBER_TABLE();
671: a8 := JTF_VARCHAR2_TABLE_100();
672: a9 := JTF_DATE_TABLE();
673: a10 := JTF_DATE_TABLE();
674: a11 := JTF_VARCHAR2_TABLE_100();

Line 675: a12 := JTF_NUMBER_TABLE();

671: a8 := JTF_VARCHAR2_TABLE_100();
672: a9 := JTF_DATE_TABLE();
673: a10 := JTF_DATE_TABLE();
674: a11 := JTF_VARCHAR2_TABLE_100();
675: a12 := JTF_NUMBER_TABLE();
676: a13 := JTF_NUMBER_TABLE();
677: a14 := JTF_VARCHAR2_TABLE_100();
678: a15 := JTF_VARCHAR2_TABLE_100();
679: else

Line 676: a13 := JTF_NUMBER_TABLE();

672: a9 := JTF_DATE_TABLE();
673: a10 := JTF_DATE_TABLE();
674: a11 := JTF_VARCHAR2_TABLE_100();
675: a12 := JTF_NUMBER_TABLE();
676: a13 := JTF_NUMBER_TABLE();
677: a14 := JTF_VARCHAR2_TABLE_100();
678: a15 := JTF_VARCHAR2_TABLE_100();
679: else
680: a0 := JTF_NUMBER_TABLE();

Line 680: a0 := JTF_NUMBER_TABLE();

676: a13 := JTF_NUMBER_TABLE();
677: a14 := JTF_VARCHAR2_TABLE_100();
678: a15 := JTF_VARCHAR2_TABLE_100();
679: else
680: a0 := JTF_NUMBER_TABLE();
681: a1 := JTF_VARCHAR2_TABLE_100();
682: a2 := JTF_NUMBER_TABLE();
683: a3 := JTF_NUMBER_TABLE();
684: a4 := JTF_VARCHAR2_TABLE_100();

Line 682: a2 := JTF_NUMBER_TABLE();

678: a15 := JTF_VARCHAR2_TABLE_100();
679: else
680: a0 := JTF_NUMBER_TABLE();
681: a1 := JTF_VARCHAR2_TABLE_100();
682: a2 := JTF_NUMBER_TABLE();
683: a3 := JTF_NUMBER_TABLE();
684: a4 := JTF_VARCHAR2_TABLE_100();
685: a5 := JTF_NUMBER_TABLE();
686: a6 := JTF_NUMBER_TABLE();

Line 683: a3 := JTF_NUMBER_TABLE();

679: else
680: a0 := JTF_NUMBER_TABLE();
681: a1 := JTF_VARCHAR2_TABLE_100();
682: a2 := JTF_NUMBER_TABLE();
683: a3 := JTF_NUMBER_TABLE();
684: a4 := JTF_VARCHAR2_TABLE_100();
685: a5 := JTF_NUMBER_TABLE();
686: a6 := JTF_NUMBER_TABLE();
687: a7 := JTF_NUMBER_TABLE();

Line 685: a5 := JTF_NUMBER_TABLE();

681: a1 := JTF_VARCHAR2_TABLE_100();
682: a2 := JTF_NUMBER_TABLE();
683: a3 := JTF_NUMBER_TABLE();
684: a4 := JTF_VARCHAR2_TABLE_100();
685: a5 := JTF_NUMBER_TABLE();
686: a6 := JTF_NUMBER_TABLE();
687: a7 := JTF_NUMBER_TABLE();
688: a8 := JTF_VARCHAR2_TABLE_100();
689: a9 := JTF_DATE_TABLE();

Line 686: a6 := JTF_NUMBER_TABLE();

682: a2 := JTF_NUMBER_TABLE();
683: a3 := JTF_NUMBER_TABLE();
684: a4 := JTF_VARCHAR2_TABLE_100();
685: a5 := JTF_NUMBER_TABLE();
686: a6 := JTF_NUMBER_TABLE();
687: a7 := JTF_NUMBER_TABLE();
688: a8 := JTF_VARCHAR2_TABLE_100();
689: a9 := JTF_DATE_TABLE();
690: a10 := JTF_DATE_TABLE();

Line 687: a7 := JTF_NUMBER_TABLE();

683: a3 := JTF_NUMBER_TABLE();
684: a4 := JTF_VARCHAR2_TABLE_100();
685: a5 := JTF_NUMBER_TABLE();
686: a6 := JTF_NUMBER_TABLE();
687: a7 := JTF_NUMBER_TABLE();
688: a8 := JTF_VARCHAR2_TABLE_100();
689: a9 := JTF_DATE_TABLE();
690: a10 := JTF_DATE_TABLE();
691: a11 := JTF_VARCHAR2_TABLE_100();

Line 692: a12 := JTF_NUMBER_TABLE();

688: a8 := JTF_VARCHAR2_TABLE_100();
689: a9 := JTF_DATE_TABLE();
690: a10 := JTF_DATE_TABLE();
691: a11 := JTF_VARCHAR2_TABLE_100();
692: a12 := JTF_NUMBER_TABLE();
693: a13 := JTF_NUMBER_TABLE();
694: a14 := JTF_VARCHAR2_TABLE_100();
695: a15 := JTF_VARCHAR2_TABLE_100();
696: if t.count > 0 then

Line 693: a13 := JTF_NUMBER_TABLE();

689: a9 := JTF_DATE_TABLE();
690: a10 := JTF_DATE_TABLE();
691: a11 := JTF_VARCHAR2_TABLE_100();
692: a12 := JTF_NUMBER_TABLE();
693: a13 := JTF_NUMBER_TABLE();
694: a14 := JTF_VARCHAR2_TABLE_100();
695: a15 := JTF_VARCHAR2_TABLE_100();
696: if t.count > 0 then
697: a0.extend(t.count);

Line 742: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE

738: end if;
739: end if;
740: end rosetta_table_copy_out_p18;
741:
742: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
743: , a1 JTF_VARCHAR2_TABLE_100
744: , a2 JTF_NUMBER_TABLE
745: , a3 JTF_NUMBER_TABLE
746: , a4 JTF_VARCHAR2_TABLE_100

Line 744: , a2 JTF_NUMBER_TABLE

740: end rosetta_table_copy_out_p18;
741:
742: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
743: , a1 JTF_VARCHAR2_TABLE_100
744: , a2 JTF_NUMBER_TABLE
745: , a3 JTF_NUMBER_TABLE
746: , a4 JTF_VARCHAR2_TABLE_100
747: , a5 JTF_NUMBER_TABLE
748: , a6 JTF_NUMBER_TABLE

Line 745: , a3 JTF_NUMBER_TABLE

741:
742: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
743: , a1 JTF_VARCHAR2_TABLE_100
744: , a2 JTF_NUMBER_TABLE
745: , a3 JTF_NUMBER_TABLE
746: , a4 JTF_VARCHAR2_TABLE_100
747: , a5 JTF_NUMBER_TABLE
748: , a6 JTF_NUMBER_TABLE
749: , a7 JTF_NUMBER_TABLE

Line 747: , a5 JTF_NUMBER_TABLE

743: , a1 JTF_VARCHAR2_TABLE_100
744: , a2 JTF_NUMBER_TABLE
745: , a3 JTF_NUMBER_TABLE
746: , a4 JTF_VARCHAR2_TABLE_100
747: , a5 JTF_NUMBER_TABLE
748: , a6 JTF_NUMBER_TABLE
749: , a7 JTF_NUMBER_TABLE
750: , a8 JTF_VARCHAR2_TABLE_100
751: , a9 JTF_DATE_TABLE

Line 748: , a6 JTF_NUMBER_TABLE

744: , a2 JTF_NUMBER_TABLE
745: , a3 JTF_NUMBER_TABLE
746: , a4 JTF_VARCHAR2_TABLE_100
747: , a5 JTF_NUMBER_TABLE
748: , a6 JTF_NUMBER_TABLE
749: , a7 JTF_NUMBER_TABLE
750: , a8 JTF_VARCHAR2_TABLE_100
751: , a9 JTF_DATE_TABLE
752: , a10 JTF_DATE_TABLE

Line 749: , a7 JTF_NUMBER_TABLE

745: , a3 JTF_NUMBER_TABLE
746: , a4 JTF_VARCHAR2_TABLE_100
747: , a5 JTF_NUMBER_TABLE
748: , a6 JTF_NUMBER_TABLE
749: , a7 JTF_NUMBER_TABLE
750: , a8 JTF_VARCHAR2_TABLE_100
751: , a9 JTF_DATE_TABLE
752: , a10 JTF_DATE_TABLE
753: , a11 JTF_VARCHAR2_TABLE_100

Line 754: , a12 JTF_NUMBER_TABLE

750: , a8 JTF_VARCHAR2_TABLE_100
751: , a9 JTF_DATE_TABLE
752: , a10 JTF_DATE_TABLE
753: , a11 JTF_VARCHAR2_TABLE_100
754: , a12 JTF_NUMBER_TABLE
755: , a13 JTF_NUMBER_TABLE
756: , a14 JTF_VARCHAR2_TABLE_100
757: , a15 JTF_VARCHAR2_TABLE_100
758: ) as

Line 755: , a13 JTF_NUMBER_TABLE

751: , a9 JTF_DATE_TABLE
752: , a10 JTF_DATE_TABLE
753: , a11 JTF_VARCHAR2_TABLE_100
754: , a12 JTF_NUMBER_TABLE
755: , a13 JTF_NUMBER_TABLE
756: , a14 JTF_VARCHAR2_TABLE_100
757: , a15 JTF_VARCHAR2_TABLE_100
758: ) as
759: ddindx binary_integer; indx binary_integer;

Line 791: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE

787: end loop;
788: end if;
789: end if;
790: end rosetta_table_copy_in_p19;
791: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
792: , a1 out nocopy JTF_VARCHAR2_TABLE_100
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 793: , a2 out nocopy JTF_NUMBER_TABLE

789: end if;
790: end rosetta_table_copy_in_p19;
791: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
792: , a1 out nocopy JTF_VARCHAR2_TABLE_100
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_100
796: , a5 out nocopy JTF_NUMBER_TABLE
797: , a6 out nocopy JTF_NUMBER_TABLE

Line 794: , a3 out nocopy JTF_NUMBER_TABLE

790: end rosetta_table_copy_in_p19;
791: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
792: , a1 out nocopy JTF_VARCHAR2_TABLE_100
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_100
796: , a5 out nocopy JTF_NUMBER_TABLE
797: , a6 out nocopy JTF_NUMBER_TABLE
798: , a7 out nocopy JTF_NUMBER_TABLE

Line 796: , a5 out nocopy JTF_NUMBER_TABLE

792: , a1 out nocopy JTF_VARCHAR2_TABLE_100
793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_100
796: , a5 out nocopy JTF_NUMBER_TABLE
797: , a6 out nocopy JTF_NUMBER_TABLE
798: , a7 out nocopy JTF_NUMBER_TABLE
799: , a8 out nocopy JTF_VARCHAR2_TABLE_100
800: , a9 out nocopy JTF_DATE_TABLE

Line 797: , a6 out nocopy JTF_NUMBER_TABLE

793: , a2 out nocopy JTF_NUMBER_TABLE
794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_100
796: , a5 out nocopy JTF_NUMBER_TABLE
797: , a6 out nocopy JTF_NUMBER_TABLE
798: , a7 out nocopy JTF_NUMBER_TABLE
799: , a8 out nocopy JTF_VARCHAR2_TABLE_100
800: , a9 out nocopy JTF_DATE_TABLE
801: , a10 out nocopy JTF_DATE_TABLE

Line 798: , a7 out nocopy JTF_NUMBER_TABLE

794: , a3 out nocopy JTF_NUMBER_TABLE
795: , a4 out nocopy JTF_VARCHAR2_TABLE_100
796: , a5 out nocopy JTF_NUMBER_TABLE
797: , a6 out nocopy JTF_NUMBER_TABLE
798: , a7 out nocopy JTF_NUMBER_TABLE
799: , a8 out nocopy JTF_VARCHAR2_TABLE_100
800: , a9 out nocopy JTF_DATE_TABLE
801: , a10 out nocopy JTF_DATE_TABLE
802: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 803: , a12 out nocopy JTF_NUMBER_TABLE

799: , a8 out nocopy JTF_VARCHAR2_TABLE_100
800: , a9 out nocopy JTF_DATE_TABLE
801: , a10 out nocopy JTF_DATE_TABLE
802: , a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
805: , a14 out nocopy JTF_VARCHAR2_TABLE_100
806: , a15 out nocopy JTF_VARCHAR2_TABLE_100
807: ) as

Line 804: , a13 out nocopy JTF_NUMBER_TABLE

800: , a9 out nocopy JTF_DATE_TABLE
801: , a10 out nocopy JTF_DATE_TABLE
802: , a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , a12 out nocopy JTF_NUMBER_TABLE
804: , a13 out nocopy JTF_NUMBER_TABLE
805: , a14 out nocopy JTF_VARCHAR2_TABLE_100
806: , a15 out nocopy JTF_VARCHAR2_TABLE_100
807: ) as
808: ddindx binary_integer; indx binary_integer;

Line 811: a0 := JTF_NUMBER_TABLE();

807: ) as
808: ddindx binary_integer; indx binary_integer;
809: begin
810: if t is null or t.count = 0 then
811: a0 := JTF_NUMBER_TABLE();
812: a1 := JTF_VARCHAR2_TABLE_100();
813: a2 := JTF_NUMBER_TABLE();
814: a3 := JTF_NUMBER_TABLE();
815: a4 := JTF_VARCHAR2_TABLE_100();

Line 813: a2 := JTF_NUMBER_TABLE();

809: begin
810: if t is null or t.count = 0 then
811: a0 := JTF_NUMBER_TABLE();
812: a1 := JTF_VARCHAR2_TABLE_100();
813: a2 := JTF_NUMBER_TABLE();
814: a3 := JTF_NUMBER_TABLE();
815: a4 := JTF_VARCHAR2_TABLE_100();
816: a5 := JTF_NUMBER_TABLE();
817: a6 := JTF_NUMBER_TABLE();

Line 814: a3 := JTF_NUMBER_TABLE();

810: if t is null or t.count = 0 then
811: a0 := JTF_NUMBER_TABLE();
812: a1 := JTF_VARCHAR2_TABLE_100();
813: a2 := JTF_NUMBER_TABLE();
814: a3 := JTF_NUMBER_TABLE();
815: a4 := JTF_VARCHAR2_TABLE_100();
816: a5 := JTF_NUMBER_TABLE();
817: a6 := JTF_NUMBER_TABLE();
818: a7 := JTF_NUMBER_TABLE();

Line 816: a5 := JTF_NUMBER_TABLE();

812: a1 := JTF_VARCHAR2_TABLE_100();
813: a2 := JTF_NUMBER_TABLE();
814: a3 := JTF_NUMBER_TABLE();
815: a4 := JTF_VARCHAR2_TABLE_100();
816: a5 := JTF_NUMBER_TABLE();
817: a6 := JTF_NUMBER_TABLE();
818: a7 := JTF_NUMBER_TABLE();
819: a8 := JTF_VARCHAR2_TABLE_100();
820: a9 := JTF_DATE_TABLE();

Line 817: a6 := JTF_NUMBER_TABLE();

813: a2 := JTF_NUMBER_TABLE();
814: a3 := JTF_NUMBER_TABLE();
815: a4 := JTF_VARCHAR2_TABLE_100();
816: a5 := JTF_NUMBER_TABLE();
817: a6 := JTF_NUMBER_TABLE();
818: a7 := JTF_NUMBER_TABLE();
819: a8 := JTF_VARCHAR2_TABLE_100();
820: a9 := JTF_DATE_TABLE();
821: a10 := JTF_DATE_TABLE();

Line 818: a7 := JTF_NUMBER_TABLE();

814: a3 := JTF_NUMBER_TABLE();
815: a4 := JTF_VARCHAR2_TABLE_100();
816: a5 := JTF_NUMBER_TABLE();
817: a6 := JTF_NUMBER_TABLE();
818: a7 := JTF_NUMBER_TABLE();
819: a8 := JTF_VARCHAR2_TABLE_100();
820: a9 := JTF_DATE_TABLE();
821: a10 := JTF_DATE_TABLE();
822: a11 := JTF_VARCHAR2_TABLE_100();

Line 823: a12 := JTF_NUMBER_TABLE();

819: a8 := JTF_VARCHAR2_TABLE_100();
820: a9 := JTF_DATE_TABLE();
821: a10 := JTF_DATE_TABLE();
822: a11 := JTF_VARCHAR2_TABLE_100();
823: a12 := JTF_NUMBER_TABLE();
824: a13 := JTF_NUMBER_TABLE();
825: a14 := JTF_VARCHAR2_TABLE_100();
826: a15 := JTF_VARCHAR2_TABLE_100();
827: else

Line 824: a13 := JTF_NUMBER_TABLE();

820: a9 := JTF_DATE_TABLE();
821: a10 := JTF_DATE_TABLE();
822: a11 := JTF_VARCHAR2_TABLE_100();
823: a12 := JTF_NUMBER_TABLE();
824: a13 := JTF_NUMBER_TABLE();
825: a14 := JTF_VARCHAR2_TABLE_100();
826: a15 := JTF_VARCHAR2_TABLE_100();
827: else
828: a0 := JTF_NUMBER_TABLE();

Line 828: a0 := JTF_NUMBER_TABLE();

824: a13 := JTF_NUMBER_TABLE();
825: a14 := JTF_VARCHAR2_TABLE_100();
826: a15 := JTF_VARCHAR2_TABLE_100();
827: else
828: a0 := JTF_NUMBER_TABLE();
829: a1 := JTF_VARCHAR2_TABLE_100();
830: a2 := JTF_NUMBER_TABLE();
831: a3 := JTF_NUMBER_TABLE();
832: a4 := JTF_VARCHAR2_TABLE_100();

Line 830: a2 := JTF_NUMBER_TABLE();

826: a15 := JTF_VARCHAR2_TABLE_100();
827: else
828: a0 := JTF_NUMBER_TABLE();
829: a1 := JTF_VARCHAR2_TABLE_100();
830: a2 := JTF_NUMBER_TABLE();
831: a3 := JTF_NUMBER_TABLE();
832: a4 := JTF_VARCHAR2_TABLE_100();
833: a5 := JTF_NUMBER_TABLE();
834: a6 := JTF_NUMBER_TABLE();

Line 831: a3 := JTF_NUMBER_TABLE();

827: else
828: a0 := JTF_NUMBER_TABLE();
829: a1 := JTF_VARCHAR2_TABLE_100();
830: a2 := JTF_NUMBER_TABLE();
831: a3 := JTF_NUMBER_TABLE();
832: a4 := JTF_VARCHAR2_TABLE_100();
833: a5 := JTF_NUMBER_TABLE();
834: a6 := JTF_NUMBER_TABLE();
835: a7 := JTF_NUMBER_TABLE();

Line 833: a5 := JTF_NUMBER_TABLE();

829: a1 := JTF_VARCHAR2_TABLE_100();
830: a2 := JTF_NUMBER_TABLE();
831: a3 := JTF_NUMBER_TABLE();
832: a4 := JTF_VARCHAR2_TABLE_100();
833: a5 := JTF_NUMBER_TABLE();
834: a6 := JTF_NUMBER_TABLE();
835: a7 := JTF_NUMBER_TABLE();
836: a8 := JTF_VARCHAR2_TABLE_100();
837: a9 := JTF_DATE_TABLE();

Line 834: a6 := JTF_NUMBER_TABLE();

830: a2 := JTF_NUMBER_TABLE();
831: a3 := JTF_NUMBER_TABLE();
832: a4 := JTF_VARCHAR2_TABLE_100();
833: a5 := JTF_NUMBER_TABLE();
834: a6 := JTF_NUMBER_TABLE();
835: a7 := JTF_NUMBER_TABLE();
836: a8 := JTF_VARCHAR2_TABLE_100();
837: a9 := JTF_DATE_TABLE();
838: a10 := JTF_DATE_TABLE();

Line 835: a7 := JTF_NUMBER_TABLE();

831: a3 := JTF_NUMBER_TABLE();
832: a4 := JTF_VARCHAR2_TABLE_100();
833: a5 := JTF_NUMBER_TABLE();
834: a6 := JTF_NUMBER_TABLE();
835: a7 := JTF_NUMBER_TABLE();
836: a8 := JTF_VARCHAR2_TABLE_100();
837: a9 := JTF_DATE_TABLE();
838: a10 := JTF_DATE_TABLE();
839: a11 := JTF_VARCHAR2_TABLE_100();

Line 840: a12 := JTF_NUMBER_TABLE();

836: a8 := JTF_VARCHAR2_TABLE_100();
837: a9 := JTF_DATE_TABLE();
838: a10 := JTF_DATE_TABLE();
839: a11 := JTF_VARCHAR2_TABLE_100();
840: a12 := JTF_NUMBER_TABLE();
841: a13 := JTF_NUMBER_TABLE();
842: a14 := JTF_VARCHAR2_TABLE_100();
843: a15 := JTF_VARCHAR2_TABLE_100();
844: if t.count > 0 then

Line 841: a13 := JTF_NUMBER_TABLE();

837: a9 := JTF_DATE_TABLE();
838: a10 := JTF_DATE_TABLE();
839: a11 := JTF_VARCHAR2_TABLE_100();
840: a12 := JTF_NUMBER_TABLE();
841: a13 := JTF_NUMBER_TABLE();
842: a14 := JTF_VARCHAR2_TABLE_100();
843: a15 := JTF_VARCHAR2_TABLE_100();
844: if t.count > 0 then
845: a0.extend(t.count);

Line 890: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE

886: end if;
887: end if;
888: end rosetta_table_copy_out_p19;
889:
890: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
891: , a1 JTF_VARCHAR2_TABLE_100
892: , a2 JTF_VARCHAR2_TABLE_100
893: , a3 JTF_NUMBER_TABLE
894: , a4 JTF_VARCHAR2_TABLE_100

Line 893: , a3 JTF_NUMBER_TABLE

889:
890: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
891: , a1 JTF_VARCHAR2_TABLE_100
892: , a2 JTF_VARCHAR2_TABLE_100
893: , a3 JTF_NUMBER_TABLE
894: , a4 JTF_VARCHAR2_TABLE_100
895: , a5 JTF_NUMBER_TABLE
896: ) as
897: ddindx binary_integer; indx binary_integer;

Line 895: , a5 JTF_NUMBER_TABLE

891: , a1 JTF_VARCHAR2_TABLE_100
892: , a2 JTF_VARCHAR2_TABLE_100
893: , a3 JTF_NUMBER_TABLE
894: , a4 JTF_VARCHAR2_TABLE_100
895: , a5 JTF_NUMBER_TABLE
896: ) as
897: ddindx binary_integer; indx binary_integer;
898: begin
899: if a0 is not null and a0.count > 0 then

Line 919: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE

915: end loop;
916: end if;
917: end if;
918: end rosetta_table_copy_in_p20;
919: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
920: , a1 out nocopy JTF_VARCHAR2_TABLE_100
921: , a2 out nocopy JTF_VARCHAR2_TABLE_100
922: , a3 out nocopy JTF_NUMBER_TABLE
923: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 922: , a3 out nocopy JTF_NUMBER_TABLE

918: end rosetta_table_copy_in_p20;
919: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
920: , a1 out nocopy JTF_VARCHAR2_TABLE_100
921: , a2 out nocopy JTF_VARCHAR2_TABLE_100
922: , a3 out nocopy JTF_NUMBER_TABLE
923: , a4 out nocopy JTF_VARCHAR2_TABLE_100
924: , a5 out nocopy JTF_NUMBER_TABLE
925: ) as
926: ddindx binary_integer; indx binary_integer;

Line 924: , a5 out nocopy JTF_NUMBER_TABLE

920: , a1 out nocopy JTF_VARCHAR2_TABLE_100
921: , a2 out nocopy JTF_VARCHAR2_TABLE_100
922: , a3 out nocopy JTF_NUMBER_TABLE
923: , a4 out nocopy JTF_VARCHAR2_TABLE_100
924: , a5 out nocopy JTF_NUMBER_TABLE
925: ) as
926: ddindx binary_integer; indx binary_integer;
927: begin
928: if t is null or t.count = 0 then

Line 929: a0 := JTF_NUMBER_TABLE();

925: ) as
926: ddindx binary_integer; indx binary_integer;
927: begin
928: if t is null or t.count = 0 then
929: a0 := JTF_NUMBER_TABLE();
930: a1 := JTF_VARCHAR2_TABLE_100();
931: a2 := JTF_VARCHAR2_TABLE_100();
932: a3 := JTF_NUMBER_TABLE();
933: a4 := JTF_VARCHAR2_TABLE_100();

Line 932: a3 := JTF_NUMBER_TABLE();

928: if t is null or t.count = 0 then
929: a0 := JTF_NUMBER_TABLE();
930: a1 := JTF_VARCHAR2_TABLE_100();
931: a2 := JTF_VARCHAR2_TABLE_100();
932: a3 := JTF_NUMBER_TABLE();
933: a4 := JTF_VARCHAR2_TABLE_100();
934: a5 := JTF_NUMBER_TABLE();
935: else
936: a0 := JTF_NUMBER_TABLE();

Line 934: a5 := JTF_NUMBER_TABLE();

930: a1 := JTF_VARCHAR2_TABLE_100();
931: a2 := JTF_VARCHAR2_TABLE_100();
932: a3 := JTF_NUMBER_TABLE();
933: a4 := JTF_VARCHAR2_TABLE_100();
934: a5 := JTF_NUMBER_TABLE();
935: else
936: a0 := JTF_NUMBER_TABLE();
937: a1 := JTF_VARCHAR2_TABLE_100();
938: a2 := JTF_VARCHAR2_TABLE_100();

Line 936: a0 := JTF_NUMBER_TABLE();

932: a3 := JTF_NUMBER_TABLE();
933: a4 := JTF_VARCHAR2_TABLE_100();
934: a5 := JTF_NUMBER_TABLE();
935: else
936: a0 := JTF_NUMBER_TABLE();
937: a1 := JTF_VARCHAR2_TABLE_100();
938: a2 := JTF_VARCHAR2_TABLE_100();
939: a3 := JTF_NUMBER_TABLE();
940: a4 := JTF_VARCHAR2_TABLE_100();

Line 939: a3 := JTF_NUMBER_TABLE();

935: else
936: a0 := JTF_NUMBER_TABLE();
937: a1 := JTF_VARCHAR2_TABLE_100();
938: a2 := JTF_VARCHAR2_TABLE_100();
939: a3 := JTF_NUMBER_TABLE();
940: a4 := JTF_VARCHAR2_TABLE_100();
941: a5 := JTF_NUMBER_TABLE();
942: if t.count > 0 then
943: a0.extend(t.count);

Line 941: a5 := JTF_NUMBER_TABLE();

937: a1 := JTF_VARCHAR2_TABLE_100();
938: a2 := JTF_VARCHAR2_TABLE_100();
939: a3 := JTF_NUMBER_TABLE();
940: a4 := JTF_VARCHAR2_TABLE_100();
941: a5 := JTF_NUMBER_TABLE();
942: if t.count > 0 then
943: a0.extend(t.count);
944: a1.extend(t.count);
945: a2.extend(t.count);

Line 968: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

964: end if;
965: end if;
966: end rosetta_table_copy_out_p20;
967:
968: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
969: , a1 JTF_VARCHAR2_TABLE_100
970: , a2 JTF_NUMBER_TABLE
971: , a3 JTF_VARCHAR2_TABLE_100
972: , a4 JTF_VARCHAR2_TABLE_100

Line 970: , a2 JTF_NUMBER_TABLE

966: end rosetta_table_copy_out_p20;
967:
968: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
969: , a1 JTF_VARCHAR2_TABLE_100
970: , a2 JTF_NUMBER_TABLE
971: , a3 JTF_VARCHAR2_TABLE_100
972: , a4 JTF_VARCHAR2_TABLE_100
973: , a5 JTF_VARCHAR2_TABLE_300
974: , a6 JTF_NUMBER_TABLE

Line 974: , a6 JTF_NUMBER_TABLE

970: , a2 JTF_NUMBER_TABLE
971: , a3 JTF_VARCHAR2_TABLE_100
972: , a4 JTF_VARCHAR2_TABLE_100
973: , a5 JTF_VARCHAR2_TABLE_300
974: , a6 JTF_NUMBER_TABLE
975: , a7 JTF_VARCHAR2_TABLE_300
976: , a8 JTF_VARCHAR2_TABLE_100
977: , a9 JTF_VARCHAR2_TABLE_100
978: , a10 JTF_NUMBER_TABLE

Line 978: , a10 JTF_NUMBER_TABLE

974: , a6 JTF_NUMBER_TABLE
975: , a7 JTF_VARCHAR2_TABLE_300
976: , a8 JTF_VARCHAR2_TABLE_100
977: , a9 JTF_VARCHAR2_TABLE_100
978: , a10 JTF_NUMBER_TABLE
979: , a11 JTF_NUMBER_TABLE
980: , a12 JTF_VARCHAR2_TABLE_100
981: , a13 JTF_NUMBER_TABLE
982: , a14 JTF_NUMBER_TABLE

Line 979: , a11 JTF_NUMBER_TABLE

975: , a7 JTF_VARCHAR2_TABLE_300
976: , a8 JTF_VARCHAR2_TABLE_100
977: , a9 JTF_VARCHAR2_TABLE_100
978: , a10 JTF_NUMBER_TABLE
979: , a11 JTF_NUMBER_TABLE
980: , a12 JTF_VARCHAR2_TABLE_100
981: , a13 JTF_NUMBER_TABLE
982: , a14 JTF_NUMBER_TABLE
983: , a15 JTF_VARCHAR2_TABLE_100

Line 981: , a13 JTF_NUMBER_TABLE

977: , a9 JTF_VARCHAR2_TABLE_100
978: , a10 JTF_NUMBER_TABLE
979: , a11 JTF_NUMBER_TABLE
980: , a12 JTF_VARCHAR2_TABLE_100
981: , a13 JTF_NUMBER_TABLE
982: , a14 JTF_NUMBER_TABLE
983: , a15 JTF_VARCHAR2_TABLE_100
984: , a16 JTF_VARCHAR2_TABLE_100
985: , a17 JTF_DATE_TABLE

Line 982: , a14 JTF_NUMBER_TABLE

978: , a10 JTF_NUMBER_TABLE
979: , a11 JTF_NUMBER_TABLE
980: , a12 JTF_VARCHAR2_TABLE_100
981: , a13 JTF_NUMBER_TABLE
982: , a14 JTF_NUMBER_TABLE
983: , a15 JTF_VARCHAR2_TABLE_100
984: , a16 JTF_VARCHAR2_TABLE_100
985: , a17 JTF_DATE_TABLE
986: , a18 JTF_DATE_TABLE

Line 1031: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

1027: end loop;
1028: end if;
1029: end if;
1030: end rosetta_table_copy_in_p21;
1031: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
1032: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1033: , a2 out nocopy JTF_NUMBER_TABLE
1034: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1035: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1033: , a2 out nocopy JTF_NUMBER_TABLE

1029: end if;
1030: end rosetta_table_copy_in_p21;
1031: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
1032: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1033: , a2 out nocopy JTF_NUMBER_TABLE
1034: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1036: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1037: , a6 out nocopy JTF_NUMBER_TABLE

Line 1037: , a6 out nocopy JTF_NUMBER_TABLE

1033: , a2 out nocopy JTF_NUMBER_TABLE
1034: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1035: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1036: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1037: , a6 out nocopy JTF_NUMBER_TABLE
1038: , a7 out nocopy JTF_VARCHAR2_TABLE_300
1039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1041: , a10 out nocopy JTF_NUMBER_TABLE

Line 1041: , a10 out nocopy JTF_NUMBER_TABLE

1037: , a6 out nocopy JTF_NUMBER_TABLE
1038: , a7 out nocopy JTF_VARCHAR2_TABLE_300
1039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1041: , a10 out nocopy JTF_NUMBER_TABLE
1042: , a11 out nocopy JTF_NUMBER_TABLE
1043: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1044: , a13 out nocopy JTF_NUMBER_TABLE
1045: , a14 out nocopy JTF_NUMBER_TABLE

Line 1042: , a11 out nocopy JTF_NUMBER_TABLE

1038: , a7 out nocopy JTF_VARCHAR2_TABLE_300
1039: , a8 out nocopy JTF_VARCHAR2_TABLE_100
1040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1041: , a10 out nocopy JTF_NUMBER_TABLE
1042: , a11 out nocopy JTF_NUMBER_TABLE
1043: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1044: , a13 out nocopy JTF_NUMBER_TABLE
1045: , a14 out nocopy JTF_NUMBER_TABLE
1046: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1044: , a13 out nocopy JTF_NUMBER_TABLE

1040: , a9 out nocopy JTF_VARCHAR2_TABLE_100
1041: , a10 out nocopy JTF_NUMBER_TABLE
1042: , a11 out nocopy JTF_NUMBER_TABLE
1043: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1044: , a13 out nocopy JTF_NUMBER_TABLE
1045: , a14 out nocopy JTF_NUMBER_TABLE
1046: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1047: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1048: , a17 out nocopy JTF_DATE_TABLE

Line 1045: , a14 out nocopy JTF_NUMBER_TABLE

1041: , a10 out nocopy JTF_NUMBER_TABLE
1042: , a11 out nocopy JTF_NUMBER_TABLE
1043: , a12 out nocopy JTF_VARCHAR2_TABLE_100
1044: , a13 out nocopy JTF_NUMBER_TABLE
1045: , a14 out nocopy JTF_NUMBER_TABLE
1046: , a15 out nocopy JTF_VARCHAR2_TABLE_100
1047: , a16 out nocopy JTF_VARCHAR2_TABLE_100
1048: , a17 out nocopy JTF_DATE_TABLE
1049: , a18 out nocopy JTF_DATE_TABLE

Line 1078: a0 := JTF_NUMBER_TABLE();

1074: a18 := null;
1075: a19 := null;
1076: a20 := null;
1077: elsif t.count = 0 then
1078: a0 := JTF_NUMBER_TABLE();
1079: a1 := JTF_VARCHAR2_TABLE_100();
1080: a2 := JTF_NUMBER_TABLE();
1081: a3 := JTF_VARCHAR2_TABLE_100();
1082: a4 := JTF_VARCHAR2_TABLE_100();

Line 1080: a2 := JTF_NUMBER_TABLE();

1076: a20 := null;
1077: elsif t.count = 0 then
1078: a0 := JTF_NUMBER_TABLE();
1079: a1 := JTF_VARCHAR2_TABLE_100();
1080: a2 := JTF_NUMBER_TABLE();
1081: a3 := JTF_VARCHAR2_TABLE_100();
1082: a4 := JTF_VARCHAR2_TABLE_100();
1083: a5 := JTF_VARCHAR2_TABLE_300();
1084: a6 := JTF_NUMBER_TABLE();

Line 1084: a6 := JTF_NUMBER_TABLE();

1080: a2 := JTF_NUMBER_TABLE();
1081: a3 := JTF_VARCHAR2_TABLE_100();
1082: a4 := JTF_VARCHAR2_TABLE_100();
1083: a5 := JTF_VARCHAR2_TABLE_300();
1084: a6 := JTF_NUMBER_TABLE();
1085: a7 := JTF_VARCHAR2_TABLE_300();
1086: a8 := JTF_VARCHAR2_TABLE_100();
1087: a9 := JTF_VARCHAR2_TABLE_100();
1088: a10 := JTF_NUMBER_TABLE();

Line 1088: a10 := JTF_NUMBER_TABLE();

1084: a6 := JTF_NUMBER_TABLE();
1085: a7 := JTF_VARCHAR2_TABLE_300();
1086: a8 := JTF_VARCHAR2_TABLE_100();
1087: a9 := JTF_VARCHAR2_TABLE_100();
1088: a10 := JTF_NUMBER_TABLE();
1089: a11 := JTF_NUMBER_TABLE();
1090: a12 := JTF_VARCHAR2_TABLE_100();
1091: a13 := JTF_NUMBER_TABLE();
1092: a14 := JTF_NUMBER_TABLE();

Line 1089: a11 := JTF_NUMBER_TABLE();

1085: a7 := JTF_VARCHAR2_TABLE_300();
1086: a8 := JTF_VARCHAR2_TABLE_100();
1087: a9 := JTF_VARCHAR2_TABLE_100();
1088: a10 := JTF_NUMBER_TABLE();
1089: a11 := JTF_NUMBER_TABLE();
1090: a12 := JTF_VARCHAR2_TABLE_100();
1091: a13 := JTF_NUMBER_TABLE();
1092: a14 := JTF_NUMBER_TABLE();
1093: a15 := JTF_VARCHAR2_TABLE_100();

Line 1091: a13 := JTF_NUMBER_TABLE();

1087: a9 := JTF_VARCHAR2_TABLE_100();
1088: a10 := JTF_NUMBER_TABLE();
1089: a11 := JTF_NUMBER_TABLE();
1090: a12 := JTF_VARCHAR2_TABLE_100();
1091: a13 := JTF_NUMBER_TABLE();
1092: a14 := JTF_NUMBER_TABLE();
1093: a15 := JTF_VARCHAR2_TABLE_100();
1094: a16 := JTF_VARCHAR2_TABLE_100();
1095: a17 := JTF_DATE_TABLE();

Line 1092: a14 := JTF_NUMBER_TABLE();

1088: a10 := JTF_NUMBER_TABLE();
1089: a11 := JTF_NUMBER_TABLE();
1090: a12 := JTF_VARCHAR2_TABLE_100();
1091: a13 := JTF_NUMBER_TABLE();
1092: a14 := JTF_NUMBER_TABLE();
1093: a15 := JTF_VARCHAR2_TABLE_100();
1094: a16 := JTF_VARCHAR2_TABLE_100();
1095: a17 := JTF_DATE_TABLE();
1096: a18 := JTF_DATE_TABLE();

Line 1100: a0 := JTF_NUMBER_TABLE();

1096: a18 := JTF_DATE_TABLE();
1097: a19 := JTF_VARCHAR2_TABLE_100();
1098: a20 := JTF_VARCHAR2_TABLE_100();
1099: else
1100: a0 := JTF_NUMBER_TABLE();
1101: a1 := JTF_VARCHAR2_TABLE_100();
1102: a2 := JTF_NUMBER_TABLE();
1103: a3 := JTF_VARCHAR2_TABLE_100();
1104: a4 := JTF_VARCHAR2_TABLE_100();

Line 1102: a2 := JTF_NUMBER_TABLE();

1098: a20 := JTF_VARCHAR2_TABLE_100();
1099: else
1100: a0 := JTF_NUMBER_TABLE();
1101: a1 := JTF_VARCHAR2_TABLE_100();
1102: a2 := JTF_NUMBER_TABLE();
1103: a3 := JTF_VARCHAR2_TABLE_100();
1104: a4 := JTF_VARCHAR2_TABLE_100();
1105: a5 := JTF_VARCHAR2_TABLE_300();
1106: a6 := JTF_NUMBER_TABLE();

Line 1106: a6 := JTF_NUMBER_TABLE();

1102: a2 := JTF_NUMBER_TABLE();
1103: a3 := JTF_VARCHAR2_TABLE_100();
1104: a4 := JTF_VARCHAR2_TABLE_100();
1105: a5 := JTF_VARCHAR2_TABLE_300();
1106: a6 := JTF_NUMBER_TABLE();
1107: a7 := JTF_VARCHAR2_TABLE_300();
1108: a8 := JTF_VARCHAR2_TABLE_100();
1109: a9 := JTF_VARCHAR2_TABLE_100();
1110: a10 := JTF_NUMBER_TABLE();

Line 1110: a10 := JTF_NUMBER_TABLE();

1106: a6 := JTF_NUMBER_TABLE();
1107: a7 := JTF_VARCHAR2_TABLE_300();
1108: a8 := JTF_VARCHAR2_TABLE_100();
1109: a9 := JTF_VARCHAR2_TABLE_100();
1110: a10 := JTF_NUMBER_TABLE();
1111: a11 := JTF_NUMBER_TABLE();
1112: a12 := JTF_VARCHAR2_TABLE_100();
1113: a13 := JTF_NUMBER_TABLE();
1114: a14 := JTF_NUMBER_TABLE();

Line 1111: a11 := JTF_NUMBER_TABLE();

1107: a7 := JTF_VARCHAR2_TABLE_300();
1108: a8 := JTF_VARCHAR2_TABLE_100();
1109: a9 := JTF_VARCHAR2_TABLE_100();
1110: a10 := JTF_NUMBER_TABLE();
1111: a11 := JTF_NUMBER_TABLE();
1112: a12 := JTF_VARCHAR2_TABLE_100();
1113: a13 := JTF_NUMBER_TABLE();
1114: a14 := JTF_NUMBER_TABLE();
1115: a15 := JTF_VARCHAR2_TABLE_100();

Line 1113: a13 := JTF_NUMBER_TABLE();

1109: a9 := JTF_VARCHAR2_TABLE_100();
1110: a10 := JTF_NUMBER_TABLE();
1111: a11 := JTF_NUMBER_TABLE();
1112: a12 := JTF_VARCHAR2_TABLE_100();
1113: a13 := JTF_NUMBER_TABLE();
1114: a14 := JTF_NUMBER_TABLE();
1115: a15 := JTF_VARCHAR2_TABLE_100();
1116: a16 := JTF_VARCHAR2_TABLE_100();
1117: a17 := JTF_DATE_TABLE();

Line 1114: a14 := JTF_NUMBER_TABLE();

1110: a10 := JTF_NUMBER_TABLE();
1111: a11 := JTF_NUMBER_TABLE();
1112: a12 := JTF_VARCHAR2_TABLE_100();
1113: a13 := JTF_NUMBER_TABLE();
1114: a14 := JTF_NUMBER_TABLE();
1115: a15 := JTF_VARCHAR2_TABLE_100();
1116: a16 := JTF_VARCHAR2_TABLE_100();
1117: a17 := JTF_DATE_TABLE();
1118: a18 := JTF_DATE_TABLE();

Line 1178: , a1 JTF_NUMBER_TABLE

1174: end if;
1175: end rosetta_table_copy_out_p21;
1176:
1177: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1178: , a1 JTF_NUMBER_TABLE
1179: , a2 JTF_NUMBER_TABLE
1180: , a3 JTF_VARCHAR2_TABLE_100
1181: , a4 JTF_VARCHAR2_TABLE_100
1182: , a5 JTF_VARCHAR2_TABLE_300

Line 1179: , a2 JTF_NUMBER_TABLE

1175: end rosetta_table_copy_out_p21;
1176:
1177: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1178: , a1 JTF_NUMBER_TABLE
1179: , a2 JTF_NUMBER_TABLE
1180: , a3 JTF_VARCHAR2_TABLE_100
1181: , a4 JTF_VARCHAR2_TABLE_100
1182: , a5 JTF_VARCHAR2_TABLE_300
1183: ) as

Line 1211: , a1 out nocopy JTF_NUMBER_TABLE

1207: end if;
1208: end if;
1209: end rosetta_table_copy_in_p22;
1210: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1211: , a1 out nocopy JTF_NUMBER_TABLE
1212: , a2 out nocopy JTF_NUMBER_TABLE
1213: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1214: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1215: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1212: , a2 out nocopy JTF_NUMBER_TABLE

1208: end if;
1209: end rosetta_table_copy_in_p22;
1210: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1211: , a1 out nocopy JTF_NUMBER_TABLE
1212: , a2 out nocopy JTF_NUMBER_TABLE
1213: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1214: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1215: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1216: ) as

Line 1228: a1 := JTF_NUMBER_TABLE();

1224: a4 := null;
1225: a5 := null;
1226: elsif t.count = 0 then
1227: a0 := JTF_VARCHAR2_TABLE_100();
1228: a1 := JTF_NUMBER_TABLE();
1229: a2 := JTF_NUMBER_TABLE();
1230: a3 := JTF_VARCHAR2_TABLE_100();
1231: a4 := JTF_VARCHAR2_TABLE_100();
1232: a5 := JTF_VARCHAR2_TABLE_300();

Line 1229: a2 := JTF_NUMBER_TABLE();

1225: a5 := null;
1226: elsif t.count = 0 then
1227: a0 := JTF_VARCHAR2_TABLE_100();
1228: a1 := JTF_NUMBER_TABLE();
1229: a2 := JTF_NUMBER_TABLE();
1230: a3 := JTF_VARCHAR2_TABLE_100();
1231: a4 := JTF_VARCHAR2_TABLE_100();
1232: a5 := JTF_VARCHAR2_TABLE_300();
1233: else

Line 1235: a1 := JTF_NUMBER_TABLE();

1231: a4 := JTF_VARCHAR2_TABLE_100();
1232: a5 := JTF_VARCHAR2_TABLE_300();
1233: else
1234: a0 := JTF_VARCHAR2_TABLE_100();
1235: a1 := JTF_NUMBER_TABLE();
1236: a2 := JTF_NUMBER_TABLE();
1237: a3 := JTF_VARCHAR2_TABLE_100();
1238: a4 := JTF_VARCHAR2_TABLE_100();
1239: a5 := JTF_VARCHAR2_TABLE_300();

Line 1236: a2 := JTF_NUMBER_TABLE();

1232: a5 := JTF_VARCHAR2_TABLE_300();
1233: else
1234: a0 := JTF_VARCHAR2_TABLE_100();
1235: a1 := JTF_NUMBER_TABLE();
1236: a2 := JTF_NUMBER_TABLE();
1237: a3 := JTF_VARCHAR2_TABLE_100();
1238: a4 := JTF_VARCHAR2_TABLE_100();
1239: a5 := JTF_VARCHAR2_TABLE_300();
1240: if t.count > 0 then

Line 1266: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE

1262: end if;
1263: end if;
1264: end rosetta_table_copy_out_p22;
1265:
1266: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1267: , a1 JTF_VARCHAR2_TABLE_100
1268: , a2 JTF_VARCHAR2_TABLE_100
1269: , a3 JTF_NUMBER_TABLE
1270: , a4 JTF_NUMBER_TABLE

Line 1269: , a3 JTF_NUMBER_TABLE

1265:
1266: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1267: , a1 JTF_VARCHAR2_TABLE_100
1268: , a2 JTF_VARCHAR2_TABLE_100
1269: , a3 JTF_NUMBER_TABLE
1270: , a4 JTF_NUMBER_TABLE
1271: , a5 JTF_VARCHAR2_TABLE_100
1272: , a6 JTF_NUMBER_TABLE
1273: , a7 JTF_NUMBER_TABLE

Line 1270: , a4 JTF_NUMBER_TABLE

1266: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1267: , a1 JTF_VARCHAR2_TABLE_100
1268: , a2 JTF_VARCHAR2_TABLE_100
1269: , a3 JTF_NUMBER_TABLE
1270: , a4 JTF_NUMBER_TABLE
1271: , a5 JTF_VARCHAR2_TABLE_100
1272: , a6 JTF_NUMBER_TABLE
1273: , a7 JTF_NUMBER_TABLE
1274: ) as

Line 1272: , a6 JTF_NUMBER_TABLE

1268: , a2 JTF_VARCHAR2_TABLE_100
1269: , a3 JTF_NUMBER_TABLE
1270: , a4 JTF_NUMBER_TABLE
1271: , a5 JTF_VARCHAR2_TABLE_100
1272: , a6 JTF_NUMBER_TABLE
1273: , a7 JTF_NUMBER_TABLE
1274: ) as
1275: ddindx binary_integer; indx binary_integer;
1276: begin

Line 1273: , a7 JTF_NUMBER_TABLE

1269: , a3 JTF_NUMBER_TABLE
1270: , a4 JTF_NUMBER_TABLE
1271: , a5 JTF_VARCHAR2_TABLE_100
1272: , a6 JTF_NUMBER_TABLE
1273: , a7 JTF_NUMBER_TABLE
1274: ) as
1275: ddindx binary_integer; indx binary_integer;
1276: begin
1277: if a0 is not null and a0.count=0 then

Line 1303: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE

1299: end loop;
1300: end if;
1301: end if;
1302: end rosetta_table_copy_in_p23;
1303: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1304: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1305: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1306: , a3 out nocopy JTF_NUMBER_TABLE
1307: , a4 out nocopy JTF_NUMBER_TABLE

Line 1306: , a3 out nocopy JTF_NUMBER_TABLE

1302: end rosetta_table_copy_in_p23;
1303: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1304: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1305: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1306: , a3 out nocopy JTF_NUMBER_TABLE
1307: , a4 out nocopy JTF_NUMBER_TABLE
1308: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1309: , a6 out nocopy JTF_NUMBER_TABLE
1310: , a7 out nocopy JTF_NUMBER_TABLE

Line 1307: , a4 out nocopy JTF_NUMBER_TABLE

1303: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1304: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1305: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1306: , a3 out nocopy JTF_NUMBER_TABLE
1307: , a4 out nocopy JTF_NUMBER_TABLE
1308: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1309: , a6 out nocopy JTF_NUMBER_TABLE
1310: , a7 out nocopy JTF_NUMBER_TABLE
1311: ) as

Line 1309: , a6 out nocopy JTF_NUMBER_TABLE

1305: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1306: , a3 out nocopy JTF_NUMBER_TABLE
1307: , a4 out nocopy JTF_NUMBER_TABLE
1308: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1309: , a6 out nocopy JTF_NUMBER_TABLE
1310: , a7 out nocopy JTF_NUMBER_TABLE
1311: ) as
1312: ddindx binary_integer; indx binary_integer;
1313: begin

Line 1310: , a7 out nocopy JTF_NUMBER_TABLE

1306: , a3 out nocopy JTF_NUMBER_TABLE
1307: , a4 out nocopy JTF_NUMBER_TABLE
1308: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1309: , a6 out nocopy JTF_NUMBER_TABLE
1310: , a7 out nocopy JTF_NUMBER_TABLE
1311: ) as
1312: ddindx binary_integer; indx binary_integer;
1313: begin
1314: if t is null then

Line 1324: a0 := JTF_NUMBER_TABLE();

1320: a5 := null;
1321: a6 := null;
1322: a7 := null;
1323: elsif t.count = 0 then
1324: a0 := JTF_NUMBER_TABLE();
1325: a1 := JTF_VARCHAR2_TABLE_100();
1326: a2 := JTF_VARCHAR2_TABLE_100();
1327: a3 := JTF_NUMBER_TABLE();
1328: a4 := JTF_NUMBER_TABLE();

Line 1327: a3 := JTF_NUMBER_TABLE();

1323: elsif t.count = 0 then
1324: a0 := JTF_NUMBER_TABLE();
1325: a1 := JTF_VARCHAR2_TABLE_100();
1326: a2 := JTF_VARCHAR2_TABLE_100();
1327: a3 := JTF_NUMBER_TABLE();
1328: a4 := JTF_NUMBER_TABLE();
1329: a5 := JTF_VARCHAR2_TABLE_100();
1330: a6 := JTF_NUMBER_TABLE();
1331: a7 := JTF_NUMBER_TABLE();

Line 1328: a4 := JTF_NUMBER_TABLE();

1324: a0 := JTF_NUMBER_TABLE();
1325: a1 := JTF_VARCHAR2_TABLE_100();
1326: a2 := JTF_VARCHAR2_TABLE_100();
1327: a3 := JTF_NUMBER_TABLE();
1328: a4 := JTF_NUMBER_TABLE();
1329: a5 := JTF_VARCHAR2_TABLE_100();
1330: a6 := JTF_NUMBER_TABLE();
1331: a7 := JTF_NUMBER_TABLE();
1332: else

Line 1330: a6 := JTF_NUMBER_TABLE();

1326: a2 := JTF_VARCHAR2_TABLE_100();
1327: a3 := JTF_NUMBER_TABLE();
1328: a4 := JTF_NUMBER_TABLE();
1329: a5 := JTF_VARCHAR2_TABLE_100();
1330: a6 := JTF_NUMBER_TABLE();
1331: a7 := JTF_NUMBER_TABLE();
1332: else
1333: a0 := JTF_NUMBER_TABLE();
1334: a1 := JTF_VARCHAR2_TABLE_100();

Line 1331: a7 := JTF_NUMBER_TABLE();

1327: a3 := JTF_NUMBER_TABLE();
1328: a4 := JTF_NUMBER_TABLE();
1329: a5 := JTF_VARCHAR2_TABLE_100();
1330: a6 := JTF_NUMBER_TABLE();
1331: a7 := JTF_NUMBER_TABLE();
1332: else
1333: a0 := JTF_NUMBER_TABLE();
1334: a1 := JTF_VARCHAR2_TABLE_100();
1335: a2 := JTF_VARCHAR2_TABLE_100();

Line 1333: a0 := JTF_NUMBER_TABLE();

1329: a5 := JTF_VARCHAR2_TABLE_100();
1330: a6 := JTF_NUMBER_TABLE();
1331: a7 := JTF_NUMBER_TABLE();
1332: else
1333: a0 := JTF_NUMBER_TABLE();
1334: a1 := JTF_VARCHAR2_TABLE_100();
1335: a2 := JTF_VARCHAR2_TABLE_100();
1336: a3 := JTF_NUMBER_TABLE();
1337: a4 := JTF_NUMBER_TABLE();

Line 1336: a3 := JTF_NUMBER_TABLE();

1332: else
1333: a0 := JTF_NUMBER_TABLE();
1334: a1 := JTF_VARCHAR2_TABLE_100();
1335: a2 := JTF_VARCHAR2_TABLE_100();
1336: a3 := JTF_NUMBER_TABLE();
1337: a4 := JTF_NUMBER_TABLE();
1338: a5 := JTF_VARCHAR2_TABLE_100();
1339: a6 := JTF_NUMBER_TABLE();
1340: a7 := JTF_NUMBER_TABLE();

Line 1337: a4 := JTF_NUMBER_TABLE();

1333: a0 := JTF_NUMBER_TABLE();
1334: a1 := JTF_VARCHAR2_TABLE_100();
1335: a2 := JTF_VARCHAR2_TABLE_100();
1336: a3 := JTF_NUMBER_TABLE();
1337: a4 := JTF_NUMBER_TABLE();
1338: a5 := JTF_VARCHAR2_TABLE_100();
1339: a6 := JTF_NUMBER_TABLE();
1340: a7 := JTF_NUMBER_TABLE();
1341: if t.count > 0 then

Line 1339: a6 := JTF_NUMBER_TABLE();

1335: a2 := JTF_VARCHAR2_TABLE_100();
1336: a3 := JTF_NUMBER_TABLE();
1337: a4 := JTF_NUMBER_TABLE();
1338: a5 := JTF_VARCHAR2_TABLE_100();
1339: a6 := JTF_NUMBER_TABLE();
1340: a7 := JTF_NUMBER_TABLE();
1341: if t.count > 0 then
1342: a0.extend(t.count);
1343: a1.extend(t.count);

Line 1340: a7 := JTF_NUMBER_TABLE();

1336: a3 := JTF_NUMBER_TABLE();
1337: a4 := JTF_NUMBER_TABLE();
1338: a5 := JTF_VARCHAR2_TABLE_100();
1339: a6 := JTF_NUMBER_TABLE();
1340: a7 := JTF_NUMBER_TABLE();
1341: if t.count > 0 then
1342: a0.extend(t.count);
1343: a1.extend(t.count);
1344: a2.extend(t.count);

Line 1373: , p2_a0 JTF_NUMBER_TABLE

1369: end rosetta_table_copy_out_p23;
1370:
1371: procedure get_availability_options(p_api_version_number NUMBER
1372: , p_task_id NUMBER
1373: , p2_a0 JTF_NUMBER_TABLE
1374: , p2_a1 JTF_VARCHAR2_TABLE_100
1375: , p3_a0 DATE
1376: , p3_a1 DATE
1377: , p_likelihood NUMBER

Line 1382: , p9_a0 out nocopy JTF_NUMBER_TABLE

1378: , p_subinv_only number
1379: , p_mandatory number
1380: , p_trunk number
1381: , p_warehouse number
1382: , p9_a0 out nocopy JTF_NUMBER_TABLE
1383: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1384: , p9_a2 out nocopy JTF_DATE_TABLE
1385: , p9_a3 out nocopy JTF_NUMBER_TABLE
1386: , p9_a4 out nocopy JTF_NUMBER_TABLE

Line 1385: , p9_a3 out nocopy JTF_NUMBER_TABLE

1381: , p_warehouse number
1382: , p9_a0 out nocopy JTF_NUMBER_TABLE
1383: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1384: , p9_a2 out nocopy JTF_DATE_TABLE
1385: , p9_a3 out nocopy JTF_NUMBER_TABLE
1386: , p9_a4 out nocopy JTF_NUMBER_TABLE
1387: , p9_a5 out nocopy JTF_NUMBER_TABLE
1388: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_4000
1389: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_4000

Line 1386: , p9_a4 out nocopy JTF_NUMBER_TABLE

1382: , p9_a0 out nocopy JTF_NUMBER_TABLE
1383: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1384: , p9_a2 out nocopy JTF_DATE_TABLE
1385: , p9_a3 out nocopy JTF_NUMBER_TABLE
1386: , p9_a4 out nocopy JTF_NUMBER_TABLE
1387: , p9_a5 out nocopy JTF_NUMBER_TABLE
1388: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_4000
1389: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_4000
1390: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_4000

Line 1387: , p9_a5 out nocopy JTF_NUMBER_TABLE

1383: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1384: , p9_a2 out nocopy JTF_DATE_TABLE
1385: , p9_a3 out nocopy JTF_NUMBER_TABLE
1386: , p9_a4 out nocopy JTF_NUMBER_TABLE
1387: , p9_a5 out nocopy JTF_NUMBER_TABLE
1388: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_4000
1389: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_4000
1390: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_4000
1391: , x_return_status out nocopy VARCHAR2

Line 1589: , p4_a0 JTF_NUMBER_TABLE

1585: , p0_a1 VARCHAR2
1586: , p_organization_id NUMBER
1587: , p_subinv_code VARCHAR2
1588: , p_need_by_date date
1589: , p4_a0 JTF_NUMBER_TABLE
1590: , p4_a1 JTF_VARCHAR2_TABLE_100
1591: , p4_a2 JTF_VARCHAR2_TABLE_100
1592: , p4_a3 JTF_NUMBER_TABLE
1593: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 1592: , p4_a3 JTF_NUMBER_TABLE

1588: , p_need_by_date date
1589: , p4_a0 JTF_NUMBER_TABLE
1590: , p4_a1 JTF_VARCHAR2_TABLE_100
1591: , p4_a2 JTF_VARCHAR2_TABLE_100
1592: , p4_a3 JTF_NUMBER_TABLE
1593: , p4_a4 JTF_VARCHAR2_TABLE_100
1594: , p4_a5 JTF_NUMBER_TABLE
1595: , p_timezone_id NUMBER
1596: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 1594: , p4_a5 JTF_NUMBER_TABLE

1590: , p4_a1 JTF_VARCHAR2_TABLE_100
1591: , p4_a2 JTF_VARCHAR2_TABLE_100
1592: , p4_a3 JTF_NUMBER_TABLE
1593: , p4_a4 JTF_VARCHAR2_TABLE_100
1594: , p4_a5 JTF_NUMBER_TABLE
1595: , p_timezone_id NUMBER
1596: , p6_a0 out nocopy JTF_NUMBER_TABLE
1597: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1598: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 1596: , p6_a0 out nocopy JTF_NUMBER_TABLE

1592: , p4_a3 JTF_NUMBER_TABLE
1593: , p4_a4 JTF_VARCHAR2_TABLE_100
1594: , p4_a5 JTF_NUMBER_TABLE
1595: , p_timezone_id NUMBER
1596: , p6_a0 out nocopy JTF_NUMBER_TABLE
1597: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1598: , p6_a2 out nocopy JTF_NUMBER_TABLE
1599: , p6_a3 out nocopy JTF_NUMBER_TABLE
1600: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1598: , p6_a2 out nocopy JTF_NUMBER_TABLE

1594: , p4_a5 JTF_NUMBER_TABLE
1595: , p_timezone_id NUMBER
1596: , p6_a0 out nocopy JTF_NUMBER_TABLE
1597: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1598: , p6_a2 out nocopy JTF_NUMBER_TABLE
1599: , p6_a3 out nocopy JTF_NUMBER_TABLE
1600: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1601: , p6_a5 out nocopy JTF_NUMBER_TABLE
1602: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 1599: , p6_a3 out nocopy JTF_NUMBER_TABLE

1595: , p_timezone_id NUMBER
1596: , p6_a0 out nocopy JTF_NUMBER_TABLE
1597: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1598: , p6_a2 out nocopy JTF_NUMBER_TABLE
1599: , p6_a3 out nocopy JTF_NUMBER_TABLE
1600: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1601: , p6_a5 out nocopy JTF_NUMBER_TABLE
1602: , p6_a6 out nocopy JTF_NUMBER_TABLE
1603: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 1601: , p6_a5 out nocopy JTF_NUMBER_TABLE

1597: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1598: , p6_a2 out nocopy JTF_NUMBER_TABLE
1599: , p6_a3 out nocopy JTF_NUMBER_TABLE
1600: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1601: , p6_a5 out nocopy JTF_NUMBER_TABLE
1602: , p6_a6 out nocopy JTF_NUMBER_TABLE
1603: , p6_a7 out nocopy JTF_NUMBER_TABLE
1604: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a9 out nocopy JTF_DATE_TABLE

Line 1602: , p6_a6 out nocopy JTF_NUMBER_TABLE

1598: , p6_a2 out nocopy JTF_NUMBER_TABLE
1599: , p6_a3 out nocopy JTF_NUMBER_TABLE
1600: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1601: , p6_a5 out nocopy JTF_NUMBER_TABLE
1602: , p6_a6 out nocopy JTF_NUMBER_TABLE
1603: , p6_a7 out nocopy JTF_NUMBER_TABLE
1604: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a9 out nocopy JTF_DATE_TABLE
1606: , p6_a10 out nocopy JTF_DATE_TABLE

Line 1603: , p6_a7 out nocopy JTF_NUMBER_TABLE

1599: , p6_a3 out nocopy JTF_NUMBER_TABLE
1600: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1601: , p6_a5 out nocopy JTF_NUMBER_TABLE
1602: , p6_a6 out nocopy JTF_NUMBER_TABLE
1603: , p6_a7 out nocopy JTF_NUMBER_TABLE
1604: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a9 out nocopy JTF_DATE_TABLE
1606: , p6_a10 out nocopy JTF_DATE_TABLE
1607: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 1608: , p6_a12 out nocopy JTF_NUMBER_TABLE

1604: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p6_a9 out nocopy JTF_DATE_TABLE
1606: , p6_a10 out nocopy JTF_DATE_TABLE
1607: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p6_a12 out nocopy JTF_NUMBER_TABLE
1609: , p6_a13 out nocopy JTF_NUMBER_TABLE
1610: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1612: , x_return_status out nocopy VARCHAR2

Line 1609: , p6_a13 out nocopy JTF_NUMBER_TABLE

1605: , p6_a9 out nocopy JTF_DATE_TABLE
1606: , p6_a10 out nocopy JTF_DATE_TABLE
1607: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p6_a12 out nocopy JTF_NUMBER_TABLE
1609: , p6_a13 out nocopy JTF_NUMBER_TABLE
1610: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1612: , x_return_status out nocopy VARCHAR2
1613: , x_msg_data out nocopy VARCHAR2

Line 1738: , p0_a1 JTF_NUMBER_TABLE

1734: return ddrosetta_retval;
1735: end;
1736:
1737: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
1738: , p0_a1 JTF_NUMBER_TABLE
1739: , p0_a2 JTF_NUMBER_TABLE
1740: , p0_a3 JTF_VARCHAR2_TABLE_100
1741: , p0_a4 JTF_VARCHAR2_TABLE_100
1742: , p0_a5 JTF_VARCHAR2_TABLE_300

Line 1739: , p0_a2 JTF_NUMBER_TABLE

1735: end;
1736:
1737: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
1738: , p0_a1 JTF_NUMBER_TABLE
1739: , p0_a2 JTF_NUMBER_TABLE
1740: , p0_a3 JTF_VARCHAR2_TABLE_100
1741: , p0_a4 JTF_VARCHAR2_TABLE_100
1742: , p0_a5 JTF_VARCHAR2_TABLE_300
1743: , p1_a0 JTF_NUMBER_TABLE

Line 1743: , p1_a0 JTF_NUMBER_TABLE

1739: , p0_a2 JTF_NUMBER_TABLE
1740: , p0_a3 JTF_VARCHAR2_TABLE_100
1741: , p0_a4 JTF_VARCHAR2_TABLE_100
1742: , p0_a5 JTF_VARCHAR2_TABLE_300
1743: , p1_a0 JTF_NUMBER_TABLE
1744: , p1_a1 JTF_VARCHAR2_TABLE_100
1745: , p1_a2 JTF_VARCHAR2_TABLE_100
1746: , p1_a3 JTF_NUMBER_TABLE
1747: , p1_a4 JTF_VARCHAR2_TABLE_100

Line 1746: , p1_a3 JTF_NUMBER_TABLE

1742: , p0_a5 JTF_VARCHAR2_TABLE_300
1743: , p1_a0 JTF_NUMBER_TABLE
1744: , p1_a1 JTF_VARCHAR2_TABLE_100
1745: , p1_a2 JTF_VARCHAR2_TABLE_100
1746: , p1_a3 JTF_NUMBER_TABLE
1747: , p1_a4 JTF_VARCHAR2_TABLE_100
1748: , p1_a5 JTF_NUMBER_TABLE
1749: , p_include_alternate VARCHAR2
1750: , p3_a0 out nocopy JTF_NUMBER_TABLE

Line 1748: , p1_a5 JTF_NUMBER_TABLE

1744: , p1_a1 JTF_VARCHAR2_TABLE_100
1745: , p1_a2 JTF_VARCHAR2_TABLE_100
1746: , p1_a3 JTF_NUMBER_TABLE
1747: , p1_a4 JTF_VARCHAR2_TABLE_100
1748: , p1_a5 JTF_NUMBER_TABLE
1749: , p_include_alternate VARCHAR2
1750: , p3_a0 out nocopy JTF_NUMBER_TABLE
1751: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1752: , p3_a2 out nocopy JTF_NUMBER_TABLE

Line 1750: , p3_a0 out nocopy JTF_NUMBER_TABLE

1746: , p1_a3 JTF_NUMBER_TABLE
1747: , p1_a4 JTF_VARCHAR2_TABLE_100
1748: , p1_a5 JTF_NUMBER_TABLE
1749: , p_include_alternate VARCHAR2
1750: , p3_a0 out nocopy JTF_NUMBER_TABLE
1751: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1752: , p3_a2 out nocopy JTF_NUMBER_TABLE
1753: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1754: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1752: , p3_a2 out nocopy JTF_NUMBER_TABLE

1748: , p1_a5 JTF_NUMBER_TABLE
1749: , p_include_alternate VARCHAR2
1750: , p3_a0 out nocopy JTF_NUMBER_TABLE
1751: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1752: , p3_a2 out nocopy JTF_NUMBER_TABLE
1753: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1754: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1755: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1756: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 1756: , p3_a6 out nocopy JTF_NUMBER_TABLE

1752: , p3_a2 out nocopy JTF_NUMBER_TABLE
1753: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1754: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1755: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1756: , p3_a6 out nocopy JTF_NUMBER_TABLE
1757: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1758: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1760: , p3_a10 out nocopy JTF_NUMBER_TABLE

Line 1760: , p3_a10 out nocopy JTF_NUMBER_TABLE

1756: , p3_a6 out nocopy JTF_NUMBER_TABLE
1757: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1758: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1760: , p3_a10 out nocopy JTF_NUMBER_TABLE
1761: , p3_a11 out nocopy JTF_NUMBER_TABLE
1762: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1763: , p3_a13 out nocopy JTF_NUMBER_TABLE
1764: , p3_a14 out nocopy JTF_NUMBER_TABLE

Line 1761: , p3_a11 out nocopy JTF_NUMBER_TABLE

1757: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1758: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1760: , p3_a10 out nocopy JTF_NUMBER_TABLE
1761: , p3_a11 out nocopy JTF_NUMBER_TABLE
1762: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1763: , p3_a13 out nocopy JTF_NUMBER_TABLE
1764: , p3_a14 out nocopy JTF_NUMBER_TABLE
1765: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1763: , p3_a13 out nocopy JTF_NUMBER_TABLE

1759: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1760: , p3_a10 out nocopy JTF_NUMBER_TABLE
1761: , p3_a11 out nocopy JTF_NUMBER_TABLE
1762: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1763: , p3_a13 out nocopy JTF_NUMBER_TABLE
1764: , p3_a14 out nocopy JTF_NUMBER_TABLE
1765: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1766: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1767: , p3_a17 out nocopy JTF_DATE_TABLE

Line 1764: , p3_a14 out nocopy JTF_NUMBER_TABLE

1760: , p3_a10 out nocopy JTF_NUMBER_TABLE
1761: , p3_a11 out nocopy JTF_NUMBER_TABLE
1762: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1763: , p3_a13 out nocopy JTF_NUMBER_TABLE
1764: , p3_a14 out nocopy JTF_NUMBER_TABLE
1765: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1766: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1767: , p3_a17 out nocopy JTF_DATE_TABLE
1768: , p3_a18 out nocopy JTF_DATE_TABLE

Line 1847: , p2_a0 JTF_NUMBER_TABLE

1843: end;
1844:
1845: procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
1846: , p_resource_id NUMBER
1847: , p2_a0 JTF_NUMBER_TABLE
1848: , p2_a1 JTF_VARCHAR2_TABLE_100
1849: , p2_a2 JTF_VARCHAR2_TABLE_100
1850: , p2_a3 JTF_NUMBER_TABLE
1851: , p2_a4 JTF_VARCHAR2_TABLE_100

Line 1850: , p2_a3 JTF_NUMBER_TABLE

1846: , p_resource_id NUMBER
1847: , p2_a0 JTF_NUMBER_TABLE
1848: , p2_a1 JTF_VARCHAR2_TABLE_100
1849: , p2_a2 JTF_VARCHAR2_TABLE_100
1850: , p2_a3 JTF_NUMBER_TABLE
1851: , p2_a4 JTF_VARCHAR2_TABLE_100
1852: , p2_a5 JTF_NUMBER_TABLE
1853: , p_include_alternate VARCHAR2
1854: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 1852: , p2_a5 JTF_NUMBER_TABLE

1848: , p2_a1 JTF_VARCHAR2_TABLE_100
1849: , p2_a2 JTF_VARCHAR2_TABLE_100
1850: , p2_a3 JTF_NUMBER_TABLE
1851: , p2_a4 JTF_VARCHAR2_TABLE_100
1852: , p2_a5 JTF_NUMBER_TABLE
1853: , p_include_alternate VARCHAR2
1854: , p4_a0 out nocopy JTF_NUMBER_TABLE
1855: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1856: , p4_a2 out nocopy JTF_NUMBER_TABLE

Line 1854: , p4_a0 out nocopy JTF_NUMBER_TABLE

1850: , p2_a3 JTF_NUMBER_TABLE
1851: , p2_a4 JTF_VARCHAR2_TABLE_100
1852: , p2_a5 JTF_NUMBER_TABLE
1853: , p_include_alternate VARCHAR2
1854: , p4_a0 out nocopy JTF_NUMBER_TABLE
1855: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1856: , p4_a2 out nocopy JTF_NUMBER_TABLE
1857: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1858: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1856: , p4_a2 out nocopy JTF_NUMBER_TABLE

1852: , p2_a5 JTF_NUMBER_TABLE
1853: , p_include_alternate VARCHAR2
1854: , p4_a0 out nocopy JTF_NUMBER_TABLE
1855: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1856: , p4_a2 out nocopy JTF_NUMBER_TABLE
1857: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1858: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1859: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1860: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 1860: , p4_a6 out nocopy JTF_NUMBER_TABLE

1856: , p4_a2 out nocopy JTF_NUMBER_TABLE
1857: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1858: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1859: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1860: , p4_a6 out nocopy JTF_NUMBER_TABLE
1861: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1862: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1863: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1864: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 1864: , p4_a10 out nocopy JTF_NUMBER_TABLE

1860: , p4_a6 out nocopy JTF_NUMBER_TABLE
1861: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1862: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1863: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1864: , p4_a10 out nocopy JTF_NUMBER_TABLE
1865: , p4_a11 out nocopy JTF_NUMBER_TABLE
1866: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p4_a13 out nocopy JTF_NUMBER_TABLE
1868: , p4_a14 out nocopy JTF_NUMBER_TABLE

Line 1865: , p4_a11 out nocopy JTF_NUMBER_TABLE

1861: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1862: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1863: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1864: , p4_a10 out nocopy JTF_NUMBER_TABLE
1865: , p4_a11 out nocopy JTF_NUMBER_TABLE
1866: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p4_a13 out nocopy JTF_NUMBER_TABLE
1868: , p4_a14 out nocopy JTF_NUMBER_TABLE
1869: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1867: , p4_a13 out nocopy JTF_NUMBER_TABLE

1863: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1864: , p4_a10 out nocopy JTF_NUMBER_TABLE
1865: , p4_a11 out nocopy JTF_NUMBER_TABLE
1866: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p4_a13 out nocopy JTF_NUMBER_TABLE
1868: , p4_a14 out nocopy JTF_NUMBER_TABLE
1869: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1870: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1871: , p4_a17 out nocopy JTF_DATE_TABLE

Line 1868: , p4_a14 out nocopy JTF_NUMBER_TABLE

1864: , p4_a10 out nocopy JTF_NUMBER_TABLE
1865: , p4_a11 out nocopy JTF_NUMBER_TABLE
1866: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p4_a13 out nocopy JTF_NUMBER_TABLE
1868: , p4_a14 out nocopy JTF_NUMBER_TABLE
1869: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1870: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1871: , p4_a17 out nocopy JTF_DATE_TABLE
1872: , p4_a18 out nocopy JTF_DATE_TABLE

Line 1946: , p2_a0 JTF_NUMBER_TABLE

1942: end;
1943:
1944: procedure ws_check_organizations(p_resource_type VARCHAR2
1945: , p_resource_id NUMBER
1946: , p2_a0 JTF_NUMBER_TABLE
1947: , p2_a1 JTF_VARCHAR2_TABLE_100
1948: , p2_a2 JTF_VARCHAR2_TABLE_100
1949: , p2_a3 JTF_NUMBER_TABLE
1950: , p2_a4 JTF_VARCHAR2_TABLE_100

Line 1949: , p2_a3 JTF_NUMBER_TABLE

1945: , p_resource_id NUMBER
1946: , p2_a0 JTF_NUMBER_TABLE
1947: , p2_a1 JTF_VARCHAR2_TABLE_100
1948: , p2_a2 JTF_VARCHAR2_TABLE_100
1949: , p2_a3 JTF_NUMBER_TABLE
1950: , p2_a4 JTF_VARCHAR2_TABLE_100
1951: , p2_a5 JTF_NUMBER_TABLE
1952: , p_include_alternate VARCHAR2
1953: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 1951: , p2_a5 JTF_NUMBER_TABLE

1947: , p2_a1 JTF_VARCHAR2_TABLE_100
1948: , p2_a2 JTF_VARCHAR2_TABLE_100
1949: , p2_a3 JTF_NUMBER_TABLE
1950: , p2_a4 JTF_VARCHAR2_TABLE_100
1951: , p2_a5 JTF_NUMBER_TABLE
1952: , p_include_alternate VARCHAR2
1953: , p4_a0 out nocopy JTF_NUMBER_TABLE
1954: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1955: , p4_a2 out nocopy JTF_NUMBER_TABLE

Line 1953: , p4_a0 out nocopy JTF_NUMBER_TABLE

1949: , p2_a3 JTF_NUMBER_TABLE
1950: , p2_a4 JTF_VARCHAR2_TABLE_100
1951: , p2_a5 JTF_NUMBER_TABLE
1952: , p_include_alternate VARCHAR2
1953: , p4_a0 out nocopy JTF_NUMBER_TABLE
1954: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1955: , p4_a2 out nocopy JTF_NUMBER_TABLE
1956: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1957: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1955: , p4_a2 out nocopy JTF_NUMBER_TABLE

1951: , p2_a5 JTF_NUMBER_TABLE
1952: , p_include_alternate VARCHAR2
1953: , p4_a0 out nocopy JTF_NUMBER_TABLE
1954: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1955: , p4_a2 out nocopy JTF_NUMBER_TABLE
1956: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1957: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1958: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1959: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 1959: , p4_a6 out nocopy JTF_NUMBER_TABLE

1955: , p4_a2 out nocopy JTF_NUMBER_TABLE
1956: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1957: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1958: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1959: , p4_a6 out nocopy JTF_NUMBER_TABLE
1960: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1961: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1962: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1963: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 1963: , p4_a10 out nocopy JTF_NUMBER_TABLE

1959: , p4_a6 out nocopy JTF_NUMBER_TABLE
1960: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1961: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1962: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1963: , p4_a10 out nocopy JTF_NUMBER_TABLE
1964: , p4_a11 out nocopy JTF_NUMBER_TABLE
1965: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1966: , p4_a13 out nocopy JTF_NUMBER_TABLE
1967: , p4_a14 out nocopy JTF_NUMBER_TABLE

Line 1964: , p4_a11 out nocopy JTF_NUMBER_TABLE

1960: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1961: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1962: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1963: , p4_a10 out nocopy JTF_NUMBER_TABLE
1964: , p4_a11 out nocopy JTF_NUMBER_TABLE
1965: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1966: , p4_a13 out nocopy JTF_NUMBER_TABLE
1967: , p4_a14 out nocopy JTF_NUMBER_TABLE
1968: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1966: , p4_a13 out nocopy JTF_NUMBER_TABLE

1962: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1963: , p4_a10 out nocopy JTF_NUMBER_TABLE
1964: , p4_a11 out nocopy JTF_NUMBER_TABLE
1965: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1966: , p4_a13 out nocopy JTF_NUMBER_TABLE
1967: , p4_a14 out nocopy JTF_NUMBER_TABLE
1968: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1969: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1970: , p4_a17 out nocopy JTF_DATE_TABLE

Line 1967: , p4_a14 out nocopy JTF_NUMBER_TABLE

1963: , p4_a10 out nocopy JTF_NUMBER_TABLE
1964: , p4_a11 out nocopy JTF_NUMBER_TABLE
1965: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1966: , p4_a13 out nocopy JTF_NUMBER_TABLE
1967: , p4_a14 out nocopy JTF_NUMBER_TABLE
1968: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1969: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1970: , p4_a17 out nocopy JTF_DATE_TABLE
1971: , p4_a18 out nocopy JTF_DATE_TABLE

Line 2050: , p2_a0 in out nocopy JTF_NUMBER_TABLE

2046: , p0_a3 NUMBER
2047: , p0_a4 VARCHAR2
2048: , p0_a5 NUMBER
2049: , p_org_id NUMBER
2050: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2051: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2052: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2053: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2054: , p2_a4 in out nocopy JTF_NUMBER_TABLE

Line 2053: , p2_a3 in out nocopy JTF_NUMBER_TABLE

2049: , p_org_id NUMBER
2050: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2051: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2052: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2053: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2054: , p2_a4 in out nocopy JTF_NUMBER_TABLE
2055: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2056: , p2_a6 in out nocopy JTF_NUMBER_TABLE
2057: , p2_a7 in out nocopy JTF_NUMBER_TABLE

Line 2054: , p2_a4 in out nocopy JTF_NUMBER_TABLE

2050: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2051: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2052: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2053: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2054: , p2_a4 in out nocopy JTF_NUMBER_TABLE
2055: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2056: , p2_a6 in out nocopy JTF_NUMBER_TABLE
2057: , p2_a7 in out nocopy JTF_NUMBER_TABLE
2058: , x_return_status out nocopy VARCHAR2

Line 2056: , p2_a6 in out nocopy JTF_NUMBER_TABLE

2052: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2053: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2054: , p2_a4 in out nocopy JTF_NUMBER_TABLE
2055: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2056: , p2_a6 in out nocopy JTF_NUMBER_TABLE
2057: , p2_a7 in out nocopy JTF_NUMBER_TABLE
2058: , x_return_status out nocopy VARCHAR2
2059: , x_msg_data out nocopy VARCHAR2
2060: , x_msg_count out nocopy NUMBER

Line 2057: , p2_a7 in out nocopy JTF_NUMBER_TABLE

2053: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2054: , p2_a4 in out nocopy JTF_NUMBER_TABLE
2055: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2056: , p2_a6 in out nocopy JTF_NUMBER_TABLE
2057: , p2_a7 in out nocopy JTF_NUMBER_TABLE
2058: , x_return_status out nocopy VARCHAR2
2059: , x_msg_data out nocopy VARCHAR2
2060: , x_msg_count out nocopy NUMBER
2061: )

Line 2186: procedure spares_check2(p0_a0 JTF_NUMBER_TABLE

2182:
2183: return ddrosetta_retval;
2184: end;
2185:
2186: procedure spares_check2(p0_a0 JTF_NUMBER_TABLE
2187: , p0_a1 JTF_VARCHAR2_TABLE_100
2188: , p_task_id NUMBER
2189: , p_need_by_date date
2190: , p_trunk number

Line 2193: , p6_a0 out nocopy JTF_NUMBER_TABLE

2189: , p_need_by_date date
2190: , p_trunk number
2191: , p_warehouse number
2192: , p_mandatory number
2193: , p6_a0 out nocopy JTF_NUMBER_TABLE
2194: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2195: , p6_a2 out nocopy JTF_DATE_TABLE
2196: , p6_a3 out nocopy JTF_NUMBER_TABLE
2197: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 2196: , p6_a3 out nocopy JTF_NUMBER_TABLE

2192: , p_mandatory number
2193: , p6_a0 out nocopy JTF_NUMBER_TABLE
2194: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2195: , p6_a2 out nocopy JTF_DATE_TABLE
2196: , p6_a3 out nocopy JTF_NUMBER_TABLE
2197: , p6_a4 out nocopy JTF_NUMBER_TABLE
2198: , p6_a5 out nocopy JTF_NUMBER_TABLE
2199: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_4000
2200: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_4000

Line 2197: , p6_a4 out nocopy JTF_NUMBER_TABLE

2193: , p6_a0 out nocopy JTF_NUMBER_TABLE
2194: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2195: , p6_a2 out nocopy JTF_DATE_TABLE
2196: , p6_a3 out nocopy JTF_NUMBER_TABLE
2197: , p6_a4 out nocopy JTF_NUMBER_TABLE
2198: , p6_a5 out nocopy JTF_NUMBER_TABLE
2199: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_4000
2200: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_4000
2201: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_4000

Line 2198: , p6_a5 out nocopy JTF_NUMBER_TABLE

2194: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
2195: , p6_a2 out nocopy JTF_DATE_TABLE
2196: , p6_a3 out nocopy JTF_NUMBER_TABLE
2197: , p6_a4 out nocopy JTF_NUMBER_TABLE
2198: , p6_a5 out nocopy JTF_NUMBER_TABLE
2199: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_4000
2200: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_4000
2201: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_4000
2202: , x_return_status out nocopy VARCHAR2