APPS.CSP_SCH_INT_PVT_W dependencies on JTF_NUMBER_TABLE

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

1: package body csp_sch_int_pvt_w as
2: /* $Header: cspvscib.pls 115.12 2004/02/25 01:32:48 jjalla noship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin

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

24: end loop;
25: end if;
26: end if;
27: end rosetta_table_copy_in_p13;
28: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin

Line 37: a0 := JTF_NUMBER_TABLE();

33: if t is null then
34: a0 := null;
35: a1 := null;
36: elsif t.count = 0 then
37: a0 := JTF_NUMBER_TABLE();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: else
40: a0 := JTF_NUMBER_TABLE();
41: a1 := JTF_VARCHAR2_TABLE_100();

Line 40: a0 := JTF_NUMBER_TABLE();

36: elsif t.count = 0 then
37: a0 := JTF_NUMBER_TABLE();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: else
40: a0 := JTF_NUMBER_TABLE();
41: a1 := JTF_VARCHAR2_TABLE_100();
42: if t.count > 0 then
43: a0.extend(t.count);
44: a1.extend(t.count);

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

56: end if;
57: end if;
58: end rosetta_table_copy_out_p13;
59:
60: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
61: , a1 JTF_VARCHAR2_TABLE_100
62: , a2 JTF_DATE_TABLE
63: , a3 JTF_NUMBER_TABLE
64: ) as

Line 63: , a3 JTF_NUMBER_TABLE

59:
60: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
61: , a1 JTF_VARCHAR2_TABLE_100
62: , a2 JTF_DATE_TABLE
63: , a3 JTF_NUMBER_TABLE
64: ) as
65: ddindx binary_integer; indx binary_integer;
66: begin
67: if a0 is not null and a0.count=0 then

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

85: end loop;
86: end if;
87: end if;
88: end rosetta_table_copy_in_p14;
89: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_VARCHAR2_TABLE_100
91: , a2 out nocopy JTF_DATE_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: ) as

Line 92: , a3 out nocopy JTF_NUMBER_TABLE

88: end rosetta_table_copy_in_p14;
89: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_VARCHAR2_TABLE_100
91: , a2 out nocopy JTF_DATE_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null then

Line 102: a0 := JTF_NUMBER_TABLE();

98: a1 := null;
99: a2 := null;
100: a3 := null;
101: elsif t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_VARCHAR2_TABLE_100();
104: a2 := JTF_DATE_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: else

Line 105: a3 := JTF_NUMBER_TABLE();

101: elsif t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_VARCHAR2_TABLE_100();
104: a2 := JTF_DATE_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: else
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_VARCHAR2_TABLE_100();
109: a2 := JTF_DATE_TABLE();

Line 107: a0 := JTF_NUMBER_TABLE();

103: a1 := JTF_VARCHAR2_TABLE_100();
104: a2 := JTF_DATE_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: else
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_VARCHAR2_TABLE_100();
109: a2 := JTF_DATE_TABLE();
110: a3 := JTF_NUMBER_TABLE();
111: if t.count > 0 then

Line 110: a3 := JTF_NUMBER_TABLE();

106: else
107: a0 := JTF_NUMBER_TABLE();
108: a1 := JTF_VARCHAR2_TABLE_100();
109: a2 := JTF_DATE_TABLE();
110: a3 := JTF_NUMBER_TABLE();
111: if t.count > 0 then
112: a0.extend(t.count);
113: a1.extend(t.count);
114: a2.extend(t.count);

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

129: end if;
130: end if;
131: end rosetta_table_copy_out_p14;
132:
133: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_VARCHAR2_TABLE_100
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_VARCHAR2_TABLE_100

Line 135: , a2 JTF_NUMBER_TABLE

131: end rosetta_table_copy_out_p14;
132:
133: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_VARCHAR2_TABLE_100
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_VARCHAR2_TABLE_100
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_NUMBER_TABLE

Line 136: , a3 JTF_NUMBER_TABLE

132:
133: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_VARCHAR2_TABLE_100
135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_VARCHAR2_TABLE_100
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_NUMBER_TABLE
140: , a7 JTF_NUMBER_TABLE

Line 139: , a6 JTF_NUMBER_TABLE

135: , a2 JTF_NUMBER_TABLE
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_VARCHAR2_TABLE_100
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_NUMBER_TABLE
140: , a7 JTF_NUMBER_TABLE
141: , a8 JTF_NUMBER_TABLE
142: , a9 JTF_VARCHAR2_TABLE_100
143: ) as

Line 140: , a7 JTF_NUMBER_TABLE

136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_VARCHAR2_TABLE_100
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_NUMBER_TABLE
140: , a7 JTF_NUMBER_TABLE
141: , a8 JTF_NUMBER_TABLE
142: , a9 JTF_VARCHAR2_TABLE_100
143: ) as
144: ddindx binary_integer; indx binary_integer;

Line 141: , a8 JTF_NUMBER_TABLE

137: , a4 JTF_VARCHAR2_TABLE_100
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_NUMBER_TABLE
140: , a7 JTF_NUMBER_TABLE
141: , a8 JTF_NUMBER_TABLE
142: , a9 JTF_VARCHAR2_TABLE_100
143: ) as
144: ddindx binary_integer; indx binary_integer;
145: begin

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

170: end loop;
171: end if;
172: end if;
173: end rosetta_table_copy_in_p15;
174: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 176: , a2 out nocopy JTF_NUMBER_TABLE

172: end if;
173: end rosetta_table_copy_in_p15;
174: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_VARCHAR2_TABLE_100
179: , a5 out nocopy JTF_VARCHAR2_TABLE_100
180: , a6 out nocopy JTF_NUMBER_TABLE

Line 177: , a3 out nocopy JTF_NUMBER_TABLE

173: end rosetta_table_copy_in_p15;
174: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_VARCHAR2_TABLE_100
179: , a5 out nocopy JTF_VARCHAR2_TABLE_100
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_NUMBER_TABLE

Line 180: , a6 out nocopy JTF_NUMBER_TABLE

176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_VARCHAR2_TABLE_100
179: , a5 out nocopy JTF_VARCHAR2_TABLE_100
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_NUMBER_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_VARCHAR2_TABLE_100
184: ) as

Line 181: , a7 out nocopy JTF_NUMBER_TABLE

177: , a3 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_VARCHAR2_TABLE_100
179: , a5 out nocopy JTF_VARCHAR2_TABLE_100
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_NUMBER_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_VARCHAR2_TABLE_100
184: ) as
185: ddindx binary_integer; indx binary_integer;

Line 182: , a8 out nocopy JTF_NUMBER_TABLE

178: , a4 out nocopy JTF_VARCHAR2_TABLE_100
179: , a5 out nocopy JTF_VARCHAR2_TABLE_100
180: , a6 out nocopy JTF_NUMBER_TABLE
181: , a7 out nocopy JTF_NUMBER_TABLE
182: , a8 out nocopy JTF_NUMBER_TABLE
183: , a9 out nocopy JTF_VARCHAR2_TABLE_100
184: ) as
185: ddindx binary_integer; indx binary_integer;
186: begin

Line 199: a0 := JTF_NUMBER_TABLE();

195: a7 := null;
196: a8 := null;
197: a9 := null;
198: elsif t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_VARCHAR2_TABLE_100();
201: a2 := JTF_NUMBER_TABLE();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();

Line 201: a2 := JTF_NUMBER_TABLE();

197: a9 := null;
198: elsif t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_VARCHAR2_TABLE_100();
201: a2 := JTF_NUMBER_TABLE();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();

Line 202: a3 := JTF_NUMBER_TABLE();

198: elsif t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_VARCHAR2_TABLE_100();
201: a2 := JTF_NUMBER_TABLE();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();

Line 205: a6 := JTF_NUMBER_TABLE();

201: a2 := JTF_NUMBER_TABLE();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_NUMBER_TABLE();
208: a9 := JTF_VARCHAR2_TABLE_100();
209: else

Line 206: a7 := JTF_NUMBER_TABLE();

202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_NUMBER_TABLE();
208: a9 := JTF_VARCHAR2_TABLE_100();
209: else
210: a0 := JTF_NUMBER_TABLE();

Line 207: a8 := JTF_NUMBER_TABLE();

203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_NUMBER_TABLE();
208: a9 := JTF_VARCHAR2_TABLE_100();
209: else
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();

Line 210: a0 := JTF_NUMBER_TABLE();

206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_NUMBER_TABLE();
208: a9 := JTF_VARCHAR2_TABLE_100();
209: else
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_NUMBER_TABLE();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();

Line 212: a2 := JTF_NUMBER_TABLE();

208: a9 := JTF_VARCHAR2_TABLE_100();
209: else
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_NUMBER_TABLE();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_VARCHAR2_TABLE_100();
216: a6 := JTF_NUMBER_TABLE();

Line 213: a3 := JTF_NUMBER_TABLE();

209: else
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_NUMBER_TABLE();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_VARCHAR2_TABLE_100();
216: a6 := JTF_NUMBER_TABLE();
217: a7 := JTF_NUMBER_TABLE();

Line 216: a6 := JTF_NUMBER_TABLE();

212: a2 := JTF_NUMBER_TABLE();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_VARCHAR2_TABLE_100();
216: a6 := JTF_NUMBER_TABLE();
217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: if t.count > 0 then

Line 217: a7 := JTF_NUMBER_TABLE();

213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_VARCHAR2_TABLE_100();
216: a6 := JTF_NUMBER_TABLE();
217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: if t.count > 0 then
221: a0.extend(t.count);

Line 218: a8 := JTF_NUMBER_TABLE();

214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_VARCHAR2_TABLE_100();
216: a6 := JTF_NUMBER_TABLE();
217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: if t.count > 0 then
221: a0.extend(t.count);
222: a1.extend(t.count);

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

250: end if;
251: end if;
252: end rosetta_table_copy_out_p15;
253:
254: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_VARCHAR2_TABLE_100
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_NUMBER_TABLE
258: , a4 JTF_NUMBER_TABLE

Line 256: , a2 JTF_NUMBER_TABLE

252: end rosetta_table_copy_out_p15;
253:
254: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_VARCHAR2_TABLE_100
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_NUMBER_TABLE
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100

Line 257: , a3 JTF_NUMBER_TABLE

253:
254: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_VARCHAR2_TABLE_100
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_NUMBER_TABLE
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100
261: , a7 JTF_NUMBER_TABLE

Line 258: , a4 JTF_NUMBER_TABLE

254: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_VARCHAR2_TABLE_100
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_NUMBER_TABLE
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100
261: , a7 JTF_NUMBER_TABLE
262: , a8 JTF_VARCHAR2_TABLE_100

Line 259: , a5 JTF_NUMBER_TABLE

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

Line 261: , a7 JTF_NUMBER_TABLE

257: , a3 JTF_NUMBER_TABLE
258: , a4 JTF_NUMBER_TABLE
259: , a5 JTF_NUMBER_TABLE
260: , a6 JTF_VARCHAR2_TABLE_100
261: , a7 JTF_NUMBER_TABLE
262: , a8 JTF_VARCHAR2_TABLE_100
263: , a9 JTF_NUMBER_TABLE
264: , a10 JTF_NUMBER_TABLE
265: , a11 JTF_NUMBER_TABLE

Line 263: , a9 JTF_NUMBER_TABLE

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

Line 264: , a10 JTF_NUMBER_TABLE

260: , a6 JTF_VARCHAR2_TABLE_100
261: , a7 JTF_NUMBER_TABLE
262: , a8 JTF_VARCHAR2_TABLE_100
263: , a9 JTF_NUMBER_TABLE
264: , a10 JTF_NUMBER_TABLE
265: , a11 JTF_NUMBER_TABLE
266: , a12 JTF_VARCHAR2_TABLE_100
267: , a13 JTF_DATE_TABLE
268: , a14 JTF_VARCHAR2_TABLE_100

Line 265: , a11 JTF_NUMBER_TABLE

261: , a7 JTF_NUMBER_TABLE
262: , a8 JTF_VARCHAR2_TABLE_100
263: , a9 JTF_NUMBER_TABLE
264: , a10 JTF_NUMBER_TABLE
265: , a11 JTF_NUMBER_TABLE
266: , a12 JTF_VARCHAR2_TABLE_100
267: , a13 JTF_DATE_TABLE
268: , a14 JTF_VARCHAR2_TABLE_100
269: , a15 JTF_NUMBER_TABLE

Line 269: , a15 JTF_NUMBER_TABLE

265: , a11 JTF_NUMBER_TABLE
266: , a12 JTF_VARCHAR2_TABLE_100
267: , a13 JTF_DATE_TABLE
268: , a14 JTF_VARCHAR2_TABLE_100
269: , a15 JTF_NUMBER_TABLE
270: ) as
271: ddindx binary_integer; indx binary_integer;
272: begin
273: if a0 is not null and a0.count=0 then

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

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

Line 309: , a2 out nocopy JTF_NUMBER_TABLE

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

Line 310: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 311: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 312: , a5 out nocopy JTF_NUMBER_TABLE

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

Line 314: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 316: , a9 out nocopy JTF_NUMBER_TABLE

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

Line 317: , a10 out nocopy JTF_NUMBER_TABLE

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

Line 318: , a11 out nocopy JTF_NUMBER_TABLE

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

Line 322: , a15 out nocopy JTF_NUMBER_TABLE

318: , a11 out nocopy JTF_NUMBER_TABLE
319: , a12 out nocopy JTF_VARCHAR2_TABLE_100
320: , a13 out nocopy JTF_DATE_TABLE
321: , a14 out nocopy JTF_VARCHAR2_TABLE_100
322: , a15 out nocopy JTF_NUMBER_TABLE
323: ) as
324: ddindx binary_integer; indx binary_integer;
325: begin
326: if t is null then

Line 344: a0 := JTF_NUMBER_TABLE();

340: a13 := null;
341: a14 := null;
342: a15 := null;
343: elsif t.count = 0 then
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_NUMBER_TABLE();
347: a3 := JTF_NUMBER_TABLE();
348: a4 := JTF_NUMBER_TABLE();

Line 346: a2 := JTF_NUMBER_TABLE();

342: a15 := null;
343: elsif t.count = 0 then
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_NUMBER_TABLE();
347: a3 := JTF_NUMBER_TABLE();
348: a4 := JTF_NUMBER_TABLE();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_VARCHAR2_TABLE_100();

Line 347: a3 := JTF_NUMBER_TABLE();

343: elsif t.count = 0 then
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_NUMBER_TABLE();
347: a3 := JTF_NUMBER_TABLE();
348: a4 := JTF_NUMBER_TABLE();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_VARCHAR2_TABLE_100();
351: a7 := JTF_NUMBER_TABLE();

Line 348: a4 := JTF_NUMBER_TABLE();

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

Line 349: a5 := JTF_NUMBER_TABLE();

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

Line 351: a7 := JTF_NUMBER_TABLE();

347: a3 := JTF_NUMBER_TABLE();
348: a4 := JTF_NUMBER_TABLE();
349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_VARCHAR2_TABLE_100();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_VARCHAR2_TABLE_100();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_NUMBER_TABLE();

Line 353: a9 := JTF_NUMBER_TABLE();

349: a5 := JTF_NUMBER_TABLE();
350: a6 := JTF_VARCHAR2_TABLE_100();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_VARCHAR2_TABLE_100();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_NUMBER_TABLE();
356: a12 := JTF_VARCHAR2_TABLE_100();
357: a13 := JTF_DATE_TABLE();

Line 354: a10 := JTF_NUMBER_TABLE();

350: a6 := JTF_VARCHAR2_TABLE_100();
351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_VARCHAR2_TABLE_100();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_NUMBER_TABLE();
356: a12 := JTF_VARCHAR2_TABLE_100();
357: a13 := JTF_DATE_TABLE();
358: a14 := JTF_VARCHAR2_TABLE_100();

Line 355: a11 := JTF_NUMBER_TABLE();

351: a7 := JTF_NUMBER_TABLE();
352: a8 := JTF_VARCHAR2_TABLE_100();
353: a9 := JTF_NUMBER_TABLE();
354: a10 := JTF_NUMBER_TABLE();
355: a11 := JTF_NUMBER_TABLE();
356: a12 := JTF_VARCHAR2_TABLE_100();
357: a13 := JTF_DATE_TABLE();
358: a14 := JTF_VARCHAR2_TABLE_100();
359: a15 := JTF_NUMBER_TABLE();

Line 359: a15 := JTF_NUMBER_TABLE();

355: a11 := JTF_NUMBER_TABLE();
356: a12 := JTF_VARCHAR2_TABLE_100();
357: a13 := JTF_DATE_TABLE();
358: a14 := JTF_VARCHAR2_TABLE_100();
359: a15 := JTF_NUMBER_TABLE();
360: else
361: a0 := JTF_NUMBER_TABLE();
362: a1 := JTF_VARCHAR2_TABLE_100();
363: a2 := JTF_NUMBER_TABLE();

Line 361: a0 := JTF_NUMBER_TABLE();

357: a13 := JTF_DATE_TABLE();
358: a14 := JTF_VARCHAR2_TABLE_100();
359: a15 := JTF_NUMBER_TABLE();
360: else
361: a0 := JTF_NUMBER_TABLE();
362: a1 := JTF_VARCHAR2_TABLE_100();
363: a2 := JTF_NUMBER_TABLE();
364: a3 := JTF_NUMBER_TABLE();
365: a4 := JTF_NUMBER_TABLE();

Line 363: a2 := JTF_NUMBER_TABLE();

359: a15 := JTF_NUMBER_TABLE();
360: else
361: a0 := JTF_NUMBER_TABLE();
362: a1 := JTF_VARCHAR2_TABLE_100();
363: a2 := JTF_NUMBER_TABLE();
364: a3 := JTF_NUMBER_TABLE();
365: a4 := JTF_NUMBER_TABLE();
366: a5 := JTF_NUMBER_TABLE();
367: a6 := JTF_VARCHAR2_TABLE_100();

Line 364: a3 := JTF_NUMBER_TABLE();

360: else
361: a0 := JTF_NUMBER_TABLE();
362: a1 := JTF_VARCHAR2_TABLE_100();
363: a2 := JTF_NUMBER_TABLE();
364: a3 := JTF_NUMBER_TABLE();
365: a4 := JTF_NUMBER_TABLE();
366: a5 := JTF_NUMBER_TABLE();
367: a6 := JTF_VARCHAR2_TABLE_100();
368: a7 := JTF_NUMBER_TABLE();

Line 365: a4 := JTF_NUMBER_TABLE();

361: a0 := JTF_NUMBER_TABLE();
362: a1 := JTF_VARCHAR2_TABLE_100();
363: a2 := JTF_NUMBER_TABLE();
364: a3 := JTF_NUMBER_TABLE();
365: a4 := JTF_NUMBER_TABLE();
366: a5 := JTF_NUMBER_TABLE();
367: a6 := JTF_VARCHAR2_TABLE_100();
368: a7 := JTF_NUMBER_TABLE();
369: a8 := JTF_VARCHAR2_TABLE_100();

Line 366: a5 := JTF_NUMBER_TABLE();

362: a1 := JTF_VARCHAR2_TABLE_100();
363: a2 := JTF_NUMBER_TABLE();
364: a3 := JTF_NUMBER_TABLE();
365: a4 := JTF_NUMBER_TABLE();
366: a5 := JTF_NUMBER_TABLE();
367: a6 := JTF_VARCHAR2_TABLE_100();
368: a7 := JTF_NUMBER_TABLE();
369: a8 := JTF_VARCHAR2_TABLE_100();
370: a9 := JTF_NUMBER_TABLE();

Line 368: a7 := JTF_NUMBER_TABLE();

364: a3 := JTF_NUMBER_TABLE();
365: a4 := JTF_NUMBER_TABLE();
366: a5 := JTF_NUMBER_TABLE();
367: a6 := JTF_VARCHAR2_TABLE_100();
368: a7 := JTF_NUMBER_TABLE();
369: a8 := JTF_VARCHAR2_TABLE_100();
370: a9 := JTF_NUMBER_TABLE();
371: a10 := JTF_NUMBER_TABLE();
372: a11 := JTF_NUMBER_TABLE();

Line 370: a9 := JTF_NUMBER_TABLE();

366: a5 := JTF_NUMBER_TABLE();
367: a6 := JTF_VARCHAR2_TABLE_100();
368: a7 := JTF_NUMBER_TABLE();
369: a8 := JTF_VARCHAR2_TABLE_100();
370: a9 := JTF_NUMBER_TABLE();
371: a10 := JTF_NUMBER_TABLE();
372: a11 := JTF_NUMBER_TABLE();
373: a12 := JTF_VARCHAR2_TABLE_100();
374: a13 := JTF_DATE_TABLE();

Line 371: a10 := JTF_NUMBER_TABLE();

367: a6 := JTF_VARCHAR2_TABLE_100();
368: a7 := JTF_NUMBER_TABLE();
369: a8 := JTF_VARCHAR2_TABLE_100();
370: a9 := JTF_NUMBER_TABLE();
371: a10 := JTF_NUMBER_TABLE();
372: a11 := JTF_NUMBER_TABLE();
373: a12 := JTF_VARCHAR2_TABLE_100();
374: a13 := JTF_DATE_TABLE();
375: a14 := JTF_VARCHAR2_TABLE_100();

Line 372: a11 := JTF_NUMBER_TABLE();

368: a7 := JTF_NUMBER_TABLE();
369: a8 := JTF_VARCHAR2_TABLE_100();
370: a9 := JTF_NUMBER_TABLE();
371: a10 := JTF_NUMBER_TABLE();
372: a11 := JTF_NUMBER_TABLE();
373: a12 := JTF_VARCHAR2_TABLE_100();
374: a13 := JTF_DATE_TABLE();
375: a14 := JTF_VARCHAR2_TABLE_100();
376: a15 := JTF_NUMBER_TABLE();

Line 376: a15 := JTF_NUMBER_TABLE();

372: a11 := JTF_NUMBER_TABLE();
373: a12 := JTF_VARCHAR2_TABLE_100();
374: a13 := JTF_DATE_TABLE();
375: a14 := JTF_VARCHAR2_TABLE_100();
376: a15 := JTF_NUMBER_TABLE();
377: if t.count > 0 then
378: a0.extend(t.count);
379: a1.extend(t.count);
380: a2.extend(t.count);

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

419: end if;
420: end if;
421: end rosetta_table_copy_out_p16;
422:
423: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_VARCHAR2_TABLE_100
425: , a2 JTF_VARCHAR2_TABLE_100
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_VARCHAR2_TABLE_100

Line 426: , a3 JTF_NUMBER_TABLE

422:
423: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_VARCHAR2_TABLE_100
425: , a2 JTF_VARCHAR2_TABLE_100
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_VARCHAR2_TABLE_100
428: , a5 JTF_NUMBER_TABLE
429: ) as
430: ddindx binary_integer; indx binary_integer;

Line 428: , a5 JTF_NUMBER_TABLE

424: , a1 JTF_VARCHAR2_TABLE_100
425: , a2 JTF_VARCHAR2_TABLE_100
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_VARCHAR2_TABLE_100
428: , a5 JTF_NUMBER_TABLE
429: ) as
430: ddindx binary_integer; indx binary_integer;
431: begin
432: if a0 is not null and a0.count=0 then

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

452: end loop;
453: end if;
454: end if;
455: end rosetta_table_copy_in_p17;
456: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
457: , a1 out nocopy JTF_VARCHAR2_TABLE_100
458: , a2 out nocopy JTF_VARCHAR2_TABLE_100
459: , a3 out nocopy JTF_NUMBER_TABLE
460: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 459: , a3 out nocopy JTF_NUMBER_TABLE

455: end rosetta_table_copy_in_p17;
456: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
457: , a1 out nocopy JTF_VARCHAR2_TABLE_100
458: , a2 out nocopy JTF_VARCHAR2_TABLE_100
459: , a3 out nocopy JTF_NUMBER_TABLE
460: , a4 out nocopy JTF_VARCHAR2_TABLE_100
461: , a5 out nocopy JTF_NUMBER_TABLE
462: ) as
463: ddindx binary_integer; indx binary_integer;

Line 461: , a5 out nocopy JTF_NUMBER_TABLE

457: , a1 out nocopy JTF_VARCHAR2_TABLE_100
458: , a2 out nocopy JTF_VARCHAR2_TABLE_100
459: , a3 out nocopy JTF_NUMBER_TABLE
460: , a4 out nocopy JTF_VARCHAR2_TABLE_100
461: , a5 out nocopy JTF_NUMBER_TABLE
462: ) as
463: ddindx binary_integer; indx binary_integer;
464: begin
465: if t is null then

Line 473: a0 := JTF_NUMBER_TABLE();

469: a3 := null;
470: a4 := null;
471: a5 := null;
472: elsif t.count = 0 then
473: a0 := JTF_NUMBER_TABLE();
474: a1 := JTF_VARCHAR2_TABLE_100();
475: a2 := JTF_VARCHAR2_TABLE_100();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_VARCHAR2_TABLE_100();

Line 476: a3 := JTF_NUMBER_TABLE();

472: elsif t.count = 0 then
473: a0 := JTF_NUMBER_TABLE();
474: a1 := JTF_VARCHAR2_TABLE_100();
475: a2 := JTF_VARCHAR2_TABLE_100();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_VARCHAR2_TABLE_100();
478: a5 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();

Line 478: a5 := JTF_NUMBER_TABLE();

474: a1 := JTF_VARCHAR2_TABLE_100();
475: a2 := JTF_VARCHAR2_TABLE_100();
476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_VARCHAR2_TABLE_100();
478: a5 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_VARCHAR2_TABLE_100();
482: a2 := JTF_VARCHAR2_TABLE_100();

Line 480: a0 := JTF_NUMBER_TABLE();

476: a3 := JTF_NUMBER_TABLE();
477: a4 := JTF_VARCHAR2_TABLE_100();
478: a5 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_VARCHAR2_TABLE_100();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_VARCHAR2_TABLE_100();

Line 483: a3 := JTF_NUMBER_TABLE();

479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_VARCHAR2_TABLE_100();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_VARCHAR2_TABLE_100();
485: a5 := JTF_NUMBER_TABLE();
486: if t.count > 0 then
487: a0.extend(t.count);

Line 485: a5 := JTF_NUMBER_TABLE();

481: a1 := JTF_VARCHAR2_TABLE_100();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_VARCHAR2_TABLE_100();
485: a5 := JTF_NUMBER_TABLE();
486: if t.count > 0 then
487: a0.extend(t.count);
488: a1.extend(t.count);
489: a2.extend(t.count);

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

508: end if;
509: end if;
510: end rosetta_table_copy_out_p17;
511:
512: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
513: , a1 JTF_VARCHAR2_TABLE_100
514: , a2 JTF_NUMBER_TABLE
515: , a3 JTF_NUMBER_TABLE
516: , a4 JTF_VARCHAR2_TABLE_100

Line 514: , a2 JTF_NUMBER_TABLE

510: end rosetta_table_copy_out_p17;
511:
512: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
513: , a1 JTF_VARCHAR2_TABLE_100
514: , a2 JTF_NUMBER_TABLE
515: , a3 JTF_NUMBER_TABLE
516: , a4 JTF_VARCHAR2_TABLE_100
517: , a5 JTF_NUMBER_TABLE
518: , a6 JTF_NUMBER_TABLE

Line 515: , a3 JTF_NUMBER_TABLE

511:
512: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
513: , a1 JTF_VARCHAR2_TABLE_100
514: , a2 JTF_NUMBER_TABLE
515: , a3 JTF_NUMBER_TABLE
516: , a4 JTF_VARCHAR2_TABLE_100
517: , a5 JTF_NUMBER_TABLE
518: , a6 JTF_NUMBER_TABLE
519: , a7 JTF_NUMBER_TABLE

Line 517: , a5 JTF_NUMBER_TABLE

513: , a1 JTF_VARCHAR2_TABLE_100
514: , a2 JTF_NUMBER_TABLE
515: , a3 JTF_NUMBER_TABLE
516: , a4 JTF_VARCHAR2_TABLE_100
517: , a5 JTF_NUMBER_TABLE
518: , a6 JTF_NUMBER_TABLE
519: , a7 JTF_NUMBER_TABLE
520: , a8 JTF_VARCHAR2_TABLE_100
521: , a9 JTF_DATE_TABLE

Line 518: , a6 JTF_NUMBER_TABLE

514: , a2 JTF_NUMBER_TABLE
515: , a3 JTF_NUMBER_TABLE
516: , a4 JTF_VARCHAR2_TABLE_100
517: , a5 JTF_NUMBER_TABLE
518: , a6 JTF_NUMBER_TABLE
519: , a7 JTF_NUMBER_TABLE
520: , a8 JTF_VARCHAR2_TABLE_100
521: , a9 JTF_DATE_TABLE
522: , a10 JTF_DATE_TABLE

Line 519: , a7 JTF_NUMBER_TABLE

515: , a3 JTF_NUMBER_TABLE
516: , a4 JTF_VARCHAR2_TABLE_100
517: , a5 JTF_NUMBER_TABLE
518: , a6 JTF_NUMBER_TABLE
519: , a7 JTF_NUMBER_TABLE
520: , a8 JTF_VARCHAR2_TABLE_100
521: , a9 JTF_DATE_TABLE
522: , a10 JTF_DATE_TABLE
523: , a11 JTF_VARCHAR2_TABLE_100

Line 524: , a12 JTF_NUMBER_TABLE

520: , a8 JTF_VARCHAR2_TABLE_100
521: , a9 JTF_DATE_TABLE
522: , a10 JTF_DATE_TABLE
523: , a11 JTF_VARCHAR2_TABLE_100
524: , a12 JTF_NUMBER_TABLE
525: , a13 JTF_NUMBER_TABLE
526: , a14 JTF_VARCHAR2_TABLE_100
527: , a15 JTF_VARCHAR2_TABLE_100
528: ) as

Line 525: , a13 JTF_NUMBER_TABLE

521: , a9 JTF_DATE_TABLE
522: , a10 JTF_DATE_TABLE
523: , a11 JTF_VARCHAR2_TABLE_100
524: , a12 JTF_NUMBER_TABLE
525: , a13 JTF_NUMBER_TABLE
526: , a14 JTF_VARCHAR2_TABLE_100
527: , a15 JTF_VARCHAR2_TABLE_100
528: ) as
529: ddindx binary_integer; indx binary_integer;

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

561: end loop;
562: end if;
563: end if;
564: end rosetta_table_copy_in_p18;
565: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
566: , a1 out nocopy JTF_VARCHAR2_TABLE_100
567: , a2 out nocopy JTF_NUMBER_TABLE
568: , a3 out nocopy JTF_NUMBER_TABLE
569: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 567: , a2 out nocopy JTF_NUMBER_TABLE

563: end if;
564: end rosetta_table_copy_in_p18;
565: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
566: , a1 out nocopy JTF_VARCHAR2_TABLE_100
567: , a2 out nocopy JTF_NUMBER_TABLE
568: , a3 out nocopy JTF_NUMBER_TABLE
569: , a4 out nocopy JTF_VARCHAR2_TABLE_100
570: , a5 out nocopy JTF_NUMBER_TABLE
571: , a6 out nocopy JTF_NUMBER_TABLE

Line 568: , a3 out nocopy JTF_NUMBER_TABLE

564: end rosetta_table_copy_in_p18;
565: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
566: , a1 out nocopy JTF_VARCHAR2_TABLE_100
567: , a2 out nocopy JTF_NUMBER_TABLE
568: , a3 out nocopy JTF_NUMBER_TABLE
569: , a4 out nocopy JTF_VARCHAR2_TABLE_100
570: , a5 out nocopy JTF_NUMBER_TABLE
571: , a6 out nocopy JTF_NUMBER_TABLE
572: , a7 out nocopy JTF_NUMBER_TABLE

Line 570: , a5 out nocopy JTF_NUMBER_TABLE

566: , a1 out nocopy JTF_VARCHAR2_TABLE_100
567: , a2 out nocopy JTF_NUMBER_TABLE
568: , a3 out nocopy JTF_NUMBER_TABLE
569: , a4 out nocopy JTF_VARCHAR2_TABLE_100
570: , a5 out nocopy JTF_NUMBER_TABLE
571: , a6 out nocopy JTF_NUMBER_TABLE
572: , a7 out nocopy JTF_NUMBER_TABLE
573: , a8 out nocopy JTF_VARCHAR2_TABLE_100
574: , a9 out nocopy JTF_DATE_TABLE

Line 571: , a6 out nocopy JTF_NUMBER_TABLE

567: , a2 out nocopy JTF_NUMBER_TABLE
568: , a3 out nocopy JTF_NUMBER_TABLE
569: , a4 out nocopy JTF_VARCHAR2_TABLE_100
570: , a5 out nocopy JTF_NUMBER_TABLE
571: , a6 out nocopy JTF_NUMBER_TABLE
572: , a7 out nocopy JTF_NUMBER_TABLE
573: , a8 out nocopy JTF_VARCHAR2_TABLE_100
574: , a9 out nocopy JTF_DATE_TABLE
575: , a10 out nocopy JTF_DATE_TABLE

Line 572: , a7 out nocopy JTF_NUMBER_TABLE

568: , a3 out nocopy JTF_NUMBER_TABLE
569: , a4 out nocopy JTF_VARCHAR2_TABLE_100
570: , a5 out nocopy JTF_NUMBER_TABLE
571: , a6 out nocopy JTF_NUMBER_TABLE
572: , a7 out nocopy JTF_NUMBER_TABLE
573: , a8 out nocopy JTF_VARCHAR2_TABLE_100
574: , a9 out nocopy JTF_DATE_TABLE
575: , a10 out nocopy JTF_DATE_TABLE
576: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 577: , a12 out nocopy JTF_NUMBER_TABLE

573: , a8 out nocopy JTF_VARCHAR2_TABLE_100
574: , a9 out nocopy JTF_DATE_TABLE
575: , a10 out nocopy JTF_DATE_TABLE
576: , a11 out nocopy JTF_VARCHAR2_TABLE_100
577: , a12 out nocopy JTF_NUMBER_TABLE
578: , a13 out nocopy JTF_NUMBER_TABLE
579: , a14 out nocopy JTF_VARCHAR2_TABLE_100
580: , a15 out nocopy JTF_VARCHAR2_TABLE_100
581: ) as

Line 578: , a13 out nocopy JTF_NUMBER_TABLE

574: , a9 out nocopy JTF_DATE_TABLE
575: , a10 out nocopy JTF_DATE_TABLE
576: , a11 out nocopy JTF_VARCHAR2_TABLE_100
577: , a12 out nocopy JTF_NUMBER_TABLE
578: , a13 out nocopy JTF_NUMBER_TABLE
579: , a14 out nocopy JTF_VARCHAR2_TABLE_100
580: , a15 out nocopy JTF_VARCHAR2_TABLE_100
581: ) as
582: ddindx binary_integer; indx binary_integer;

Line 602: a0 := JTF_NUMBER_TABLE();

598: a13 := null;
599: a14 := null;
600: a15 := null;
601: elsif t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();
603: a1 := JTF_VARCHAR2_TABLE_100();
604: a2 := JTF_NUMBER_TABLE();
605: a3 := JTF_NUMBER_TABLE();
606: a4 := JTF_VARCHAR2_TABLE_100();

Line 604: a2 := JTF_NUMBER_TABLE();

600: a15 := null;
601: elsif t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();
603: a1 := JTF_VARCHAR2_TABLE_100();
604: a2 := JTF_NUMBER_TABLE();
605: a3 := JTF_NUMBER_TABLE();
606: a4 := JTF_VARCHAR2_TABLE_100();
607: a5 := JTF_NUMBER_TABLE();
608: a6 := JTF_NUMBER_TABLE();

Line 605: a3 := JTF_NUMBER_TABLE();

601: elsif t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();
603: a1 := JTF_VARCHAR2_TABLE_100();
604: a2 := JTF_NUMBER_TABLE();
605: a3 := JTF_NUMBER_TABLE();
606: a4 := JTF_VARCHAR2_TABLE_100();
607: a5 := JTF_NUMBER_TABLE();
608: a6 := JTF_NUMBER_TABLE();
609: a7 := JTF_NUMBER_TABLE();

Line 607: a5 := JTF_NUMBER_TABLE();

603: a1 := JTF_VARCHAR2_TABLE_100();
604: a2 := JTF_NUMBER_TABLE();
605: a3 := JTF_NUMBER_TABLE();
606: a4 := JTF_VARCHAR2_TABLE_100();
607: a5 := JTF_NUMBER_TABLE();
608: a6 := JTF_NUMBER_TABLE();
609: a7 := JTF_NUMBER_TABLE();
610: a8 := JTF_VARCHAR2_TABLE_100();
611: a9 := JTF_DATE_TABLE();

Line 608: a6 := JTF_NUMBER_TABLE();

604: a2 := JTF_NUMBER_TABLE();
605: a3 := JTF_NUMBER_TABLE();
606: a4 := JTF_VARCHAR2_TABLE_100();
607: a5 := JTF_NUMBER_TABLE();
608: a6 := JTF_NUMBER_TABLE();
609: a7 := JTF_NUMBER_TABLE();
610: a8 := JTF_VARCHAR2_TABLE_100();
611: a9 := JTF_DATE_TABLE();
612: a10 := JTF_DATE_TABLE();

Line 609: a7 := JTF_NUMBER_TABLE();

605: a3 := JTF_NUMBER_TABLE();
606: a4 := JTF_VARCHAR2_TABLE_100();
607: a5 := JTF_NUMBER_TABLE();
608: a6 := JTF_NUMBER_TABLE();
609: a7 := JTF_NUMBER_TABLE();
610: a8 := JTF_VARCHAR2_TABLE_100();
611: a9 := JTF_DATE_TABLE();
612: a10 := JTF_DATE_TABLE();
613: a11 := JTF_VARCHAR2_TABLE_100();

Line 614: a12 := JTF_NUMBER_TABLE();

610: a8 := JTF_VARCHAR2_TABLE_100();
611: a9 := JTF_DATE_TABLE();
612: a10 := JTF_DATE_TABLE();
613: a11 := JTF_VARCHAR2_TABLE_100();
614: a12 := JTF_NUMBER_TABLE();
615: a13 := JTF_NUMBER_TABLE();
616: a14 := JTF_VARCHAR2_TABLE_100();
617: a15 := JTF_VARCHAR2_TABLE_100();
618: else

Line 615: a13 := JTF_NUMBER_TABLE();

611: a9 := JTF_DATE_TABLE();
612: a10 := JTF_DATE_TABLE();
613: a11 := JTF_VARCHAR2_TABLE_100();
614: a12 := JTF_NUMBER_TABLE();
615: a13 := JTF_NUMBER_TABLE();
616: a14 := JTF_VARCHAR2_TABLE_100();
617: a15 := JTF_VARCHAR2_TABLE_100();
618: else
619: a0 := JTF_NUMBER_TABLE();

Line 619: a0 := JTF_NUMBER_TABLE();

615: a13 := JTF_NUMBER_TABLE();
616: a14 := JTF_VARCHAR2_TABLE_100();
617: a15 := JTF_VARCHAR2_TABLE_100();
618: else
619: a0 := JTF_NUMBER_TABLE();
620: a1 := JTF_VARCHAR2_TABLE_100();
621: a2 := JTF_NUMBER_TABLE();
622: a3 := JTF_NUMBER_TABLE();
623: a4 := JTF_VARCHAR2_TABLE_100();

Line 621: a2 := JTF_NUMBER_TABLE();

617: a15 := JTF_VARCHAR2_TABLE_100();
618: else
619: a0 := JTF_NUMBER_TABLE();
620: a1 := JTF_VARCHAR2_TABLE_100();
621: a2 := JTF_NUMBER_TABLE();
622: a3 := JTF_NUMBER_TABLE();
623: a4 := JTF_VARCHAR2_TABLE_100();
624: a5 := JTF_NUMBER_TABLE();
625: a6 := JTF_NUMBER_TABLE();

Line 622: a3 := JTF_NUMBER_TABLE();

618: else
619: a0 := JTF_NUMBER_TABLE();
620: a1 := JTF_VARCHAR2_TABLE_100();
621: a2 := JTF_NUMBER_TABLE();
622: a3 := JTF_NUMBER_TABLE();
623: a4 := JTF_VARCHAR2_TABLE_100();
624: a5 := JTF_NUMBER_TABLE();
625: a6 := JTF_NUMBER_TABLE();
626: a7 := JTF_NUMBER_TABLE();

Line 624: a5 := JTF_NUMBER_TABLE();

620: a1 := JTF_VARCHAR2_TABLE_100();
621: a2 := JTF_NUMBER_TABLE();
622: a3 := JTF_NUMBER_TABLE();
623: a4 := JTF_VARCHAR2_TABLE_100();
624: a5 := JTF_NUMBER_TABLE();
625: a6 := JTF_NUMBER_TABLE();
626: a7 := JTF_NUMBER_TABLE();
627: a8 := JTF_VARCHAR2_TABLE_100();
628: a9 := JTF_DATE_TABLE();

Line 625: a6 := JTF_NUMBER_TABLE();

621: a2 := JTF_NUMBER_TABLE();
622: a3 := JTF_NUMBER_TABLE();
623: a4 := JTF_VARCHAR2_TABLE_100();
624: a5 := JTF_NUMBER_TABLE();
625: a6 := JTF_NUMBER_TABLE();
626: a7 := JTF_NUMBER_TABLE();
627: a8 := JTF_VARCHAR2_TABLE_100();
628: a9 := JTF_DATE_TABLE();
629: a10 := JTF_DATE_TABLE();

Line 626: a7 := JTF_NUMBER_TABLE();

622: a3 := JTF_NUMBER_TABLE();
623: a4 := JTF_VARCHAR2_TABLE_100();
624: a5 := JTF_NUMBER_TABLE();
625: a6 := JTF_NUMBER_TABLE();
626: a7 := JTF_NUMBER_TABLE();
627: a8 := JTF_VARCHAR2_TABLE_100();
628: a9 := JTF_DATE_TABLE();
629: a10 := JTF_DATE_TABLE();
630: a11 := JTF_VARCHAR2_TABLE_100();

Line 631: a12 := JTF_NUMBER_TABLE();

627: a8 := JTF_VARCHAR2_TABLE_100();
628: a9 := JTF_DATE_TABLE();
629: a10 := JTF_DATE_TABLE();
630: a11 := JTF_VARCHAR2_TABLE_100();
631: a12 := JTF_NUMBER_TABLE();
632: a13 := JTF_NUMBER_TABLE();
633: a14 := JTF_VARCHAR2_TABLE_100();
634: a15 := JTF_VARCHAR2_TABLE_100();
635: if t.count > 0 then

Line 632: a13 := JTF_NUMBER_TABLE();

628: a9 := JTF_DATE_TABLE();
629: a10 := JTF_DATE_TABLE();
630: a11 := JTF_VARCHAR2_TABLE_100();
631: a12 := JTF_NUMBER_TABLE();
632: a13 := JTF_NUMBER_TABLE();
633: a14 := JTF_VARCHAR2_TABLE_100();
634: a15 := JTF_VARCHAR2_TABLE_100();
635: if t.count > 0 then
636: a0.extend(t.count);

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

677: end if;
678: end if;
679: end rosetta_table_copy_out_p18;
680:
681: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
682: , a1 JTF_VARCHAR2_TABLE_100
683: , a2 JTF_NUMBER_TABLE
684: , a3 JTF_NUMBER_TABLE
685: , a4 JTF_VARCHAR2_TABLE_100

Line 683: , a2 JTF_NUMBER_TABLE

679: end rosetta_table_copy_out_p18;
680:
681: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
682: , a1 JTF_VARCHAR2_TABLE_100
683: , a2 JTF_NUMBER_TABLE
684: , a3 JTF_NUMBER_TABLE
685: , a4 JTF_VARCHAR2_TABLE_100
686: , a5 JTF_NUMBER_TABLE
687: , a6 JTF_NUMBER_TABLE

Line 684: , a3 JTF_NUMBER_TABLE

680:
681: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
682: , a1 JTF_VARCHAR2_TABLE_100
683: , a2 JTF_NUMBER_TABLE
684: , a3 JTF_NUMBER_TABLE
685: , a4 JTF_VARCHAR2_TABLE_100
686: , a5 JTF_NUMBER_TABLE
687: , a6 JTF_NUMBER_TABLE
688: , a7 JTF_NUMBER_TABLE

Line 686: , a5 JTF_NUMBER_TABLE

682: , a1 JTF_VARCHAR2_TABLE_100
683: , a2 JTF_NUMBER_TABLE
684: , a3 JTF_NUMBER_TABLE
685: , a4 JTF_VARCHAR2_TABLE_100
686: , a5 JTF_NUMBER_TABLE
687: , a6 JTF_NUMBER_TABLE
688: , a7 JTF_NUMBER_TABLE
689: , a8 JTF_VARCHAR2_TABLE_100
690: , a9 JTF_DATE_TABLE

Line 687: , a6 JTF_NUMBER_TABLE

683: , a2 JTF_NUMBER_TABLE
684: , a3 JTF_NUMBER_TABLE
685: , a4 JTF_VARCHAR2_TABLE_100
686: , a5 JTF_NUMBER_TABLE
687: , a6 JTF_NUMBER_TABLE
688: , a7 JTF_NUMBER_TABLE
689: , a8 JTF_VARCHAR2_TABLE_100
690: , a9 JTF_DATE_TABLE
691: , a10 JTF_DATE_TABLE

Line 688: , a7 JTF_NUMBER_TABLE

684: , a3 JTF_NUMBER_TABLE
685: , a4 JTF_VARCHAR2_TABLE_100
686: , a5 JTF_NUMBER_TABLE
687: , a6 JTF_NUMBER_TABLE
688: , a7 JTF_NUMBER_TABLE
689: , a8 JTF_VARCHAR2_TABLE_100
690: , a9 JTF_DATE_TABLE
691: , a10 JTF_DATE_TABLE
692: , a11 JTF_VARCHAR2_TABLE_100

Line 693: , a12 JTF_NUMBER_TABLE

689: , a8 JTF_VARCHAR2_TABLE_100
690: , a9 JTF_DATE_TABLE
691: , a10 JTF_DATE_TABLE
692: , a11 JTF_VARCHAR2_TABLE_100
693: , a12 JTF_NUMBER_TABLE
694: , a13 JTF_NUMBER_TABLE
695: , a14 JTF_VARCHAR2_TABLE_100
696: , a15 JTF_VARCHAR2_TABLE_100
697: ) as

Line 694: , a13 JTF_NUMBER_TABLE

690: , a9 JTF_DATE_TABLE
691: , a10 JTF_DATE_TABLE
692: , a11 JTF_VARCHAR2_TABLE_100
693: , a12 JTF_NUMBER_TABLE
694: , a13 JTF_NUMBER_TABLE
695: , a14 JTF_VARCHAR2_TABLE_100
696: , a15 JTF_VARCHAR2_TABLE_100
697: ) as
698: ddindx binary_integer; indx binary_integer;

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

726: end loop;
727: end if;
728: end if;
729: end rosetta_table_copy_in_p19;
730: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
731: , a1 out nocopy JTF_VARCHAR2_TABLE_100
732: , a2 out nocopy JTF_NUMBER_TABLE
733: , a3 out nocopy JTF_NUMBER_TABLE
734: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 732: , a2 out nocopy JTF_NUMBER_TABLE

728: end if;
729: end rosetta_table_copy_in_p19;
730: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
731: , a1 out nocopy JTF_VARCHAR2_TABLE_100
732: , a2 out nocopy JTF_NUMBER_TABLE
733: , a3 out nocopy JTF_NUMBER_TABLE
734: , a4 out nocopy JTF_VARCHAR2_TABLE_100
735: , a5 out nocopy JTF_NUMBER_TABLE
736: , a6 out nocopy JTF_NUMBER_TABLE

Line 733: , a3 out nocopy JTF_NUMBER_TABLE

729: end rosetta_table_copy_in_p19;
730: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
731: , a1 out nocopy JTF_VARCHAR2_TABLE_100
732: , a2 out nocopy JTF_NUMBER_TABLE
733: , a3 out nocopy JTF_NUMBER_TABLE
734: , a4 out nocopy JTF_VARCHAR2_TABLE_100
735: , a5 out nocopy JTF_NUMBER_TABLE
736: , a6 out nocopy JTF_NUMBER_TABLE
737: , a7 out nocopy JTF_NUMBER_TABLE

Line 735: , a5 out nocopy JTF_NUMBER_TABLE

731: , a1 out nocopy JTF_VARCHAR2_TABLE_100
732: , a2 out nocopy JTF_NUMBER_TABLE
733: , a3 out nocopy JTF_NUMBER_TABLE
734: , a4 out nocopy JTF_VARCHAR2_TABLE_100
735: , a5 out nocopy JTF_NUMBER_TABLE
736: , a6 out nocopy JTF_NUMBER_TABLE
737: , a7 out nocopy JTF_NUMBER_TABLE
738: , a8 out nocopy JTF_VARCHAR2_TABLE_100
739: , a9 out nocopy JTF_DATE_TABLE

Line 736: , a6 out nocopy JTF_NUMBER_TABLE

732: , a2 out nocopy JTF_NUMBER_TABLE
733: , a3 out nocopy JTF_NUMBER_TABLE
734: , a4 out nocopy JTF_VARCHAR2_TABLE_100
735: , a5 out nocopy JTF_NUMBER_TABLE
736: , a6 out nocopy JTF_NUMBER_TABLE
737: , a7 out nocopy JTF_NUMBER_TABLE
738: , a8 out nocopy JTF_VARCHAR2_TABLE_100
739: , a9 out nocopy JTF_DATE_TABLE
740: , a10 out nocopy JTF_DATE_TABLE

Line 737: , a7 out nocopy JTF_NUMBER_TABLE

733: , a3 out nocopy JTF_NUMBER_TABLE
734: , a4 out nocopy JTF_VARCHAR2_TABLE_100
735: , a5 out nocopy JTF_NUMBER_TABLE
736: , a6 out nocopy JTF_NUMBER_TABLE
737: , a7 out nocopy JTF_NUMBER_TABLE
738: , a8 out nocopy JTF_VARCHAR2_TABLE_100
739: , a9 out nocopy JTF_DATE_TABLE
740: , a10 out nocopy JTF_DATE_TABLE
741: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 742: , a12 out nocopy JTF_NUMBER_TABLE

738: , a8 out nocopy JTF_VARCHAR2_TABLE_100
739: , a9 out nocopy JTF_DATE_TABLE
740: , a10 out nocopy JTF_DATE_TABLE
741: , a11 out nocopy JTF_VARCHAR2_TABLE_100
742: , a12 out nocopy JTF_NUMBER_TABLE
743: , a13 out nocopy JTF_NUMBER_TABLE
744: , a14 out nocopy JTF_VARCHAR2_TABLE_100
745: , a15 out nocopy JTF_VARCHAR2_TABLE_100
746: ) as

Line 743: , a13 out nocopy JTF_NUMBER_TABLE

739: , a9 out nocopy JTF_DATE_TABLE
740: , a10 out nocopy JTF_DATE_TABLE
741: , a11 out nocopy JTF_VARCHAR2_TABLE_100
742: , a12 out nocopy JTF_NUMBER_TABLE
743: , a13 out nocopy JTF_NUMBER_TABLE
744: , a14 out nocopy JTF_VARCHAR2_TABLE_100
745: , a15 out nocopy JTF_VARCHAR2_TABLE_100
746: ) as
747: ddindx binary_integer; indx binary_integer;

Line 750: a0 := JTF_NUMBER_TABLE();

746: ) as
747: ddindx binary_integer; indx binary_integer;
748: begin
749: if t is null or t.count = 0 then
750: a0 := JTF_NUMBER_TABLE();
751: a1 := JTF_VARCHAR2_TABLE_100();
752: a2 := JTF_NUMBER_TABLE();
753: a3 := JTF_NUMBER_TABLE();
754: a4 := JTF_VARCHAR2_TABLE_100();

Line 752: a2 := JTF_NUMBER_TABLE();

748: begin
749: if t is null or t.count = 0 then
750: a0 := JTF_NUMBER_TABLE();
751: a1 := JTF_VARCHAR2_TABLE_100();
752: a2 := JTF_NUMBER_TABLE();
753: a3 := JTF_NUMBER_TABLE();
754: a4 := JTF_VARCHAR2_TABLE_100();
755: a5 := JTF_NUMBER_TABLE();
756: a6 := JTF_NUMBER_TABLE();

Line 753: a3 := JTF_NUMBER_TABLE();

749: if t is null or t.count = 0 then
750: a0 := JTF_NUMBER_TABLE();
751: a1 := JTF_VARCHAR2_TABLE_100();
752: a2 := JTF_NUMBER_TABLE();
753: a3 := JTF_NUMBER_TABLE();
754: a4 := JTF_VARCHAR2_TABLE_100();
755: a5 := JTF_NUMBER_TABLE();
756: a6 := JTF_NUMBER_TABLE();
757: a7 := JTF_NUMBER_TABLE();

Line 755: a5 := JTF_NUMBER_TABLE();

751: a1 := JTF_VARCHAR2_TABLE_100();
752: a2 := JTF_NUMBER_TABLE();
753: a3 := JTF_NUMBER_TABLE();
754: a4 := JTF_VARCHAR2_TABLE_100();
755: a5 := JTF_NUMBER_TABLE();
756: a6 := JTF_NUMBER_TABLE();
757: a7 := JTF_NUMBER_TABLE();
758: a8 := JTF_VARCHAR2_TABLE_100();
759: a9 := JTF_DATE_TABLE();

Line 756: a6 := JTF_NUMBER_TABLE();

752: a2 := JTF_NUMBER_TABLE();
753: a3 := JTF_NUMBER_TABLE();
754: a4 := JTF_VARCHAR2_TABLE_100();
755: a5 := JTF_NUMBER_TABLE();
756: a6 := JTF_NUMBER_TABLE();
757: a7 := JTF_NUMBER_TABLE();
758: a8 := JTF_VARCHAR2_TABLE_100();
759: a9 := JTF_DATE_TABLE();
760: a10 := JTF_DATE_TABLE();

Line 757: a7 := JTF_NUMBER_TABLE();

753: a3 := JTF_NUMBER_TABLE();
754: a4 := JTF_VARCHAR2_TABLE_100();
755: a5 := JTF_NUMBER_TABLE();
756: a6 := JTF_NUMBER_TABLE();
757: a7 := JTF_NUMBER_TABLE();
758: a8 := JTF_VARCHAR2_TABLE_100();
759: a9 := JTF_DATE_TABLE();
760: a10 := JTF_DATE_TABLE();
761: a11 := JTF_VARCHAR2_TABLE_100();

Line 762: a12 := JTF_NUMBER_TABLE();

758: a8 := JTF_VARCHAR2_TABLE_100();
759: a9 := JTF_DATE_TABLE();
760: a10 := JTF_DATE_TABLE();
761: a11 := JTF_VARCHAR2_TABLE_100();
762: a12 := JTF_NUMBER_TABLE();
763: a13 := JTF_NUMBER_TABLE();
764: a14 := JTF_VARCHAR2_TABLE_100();
765: a15 := JTF_VARCHAR2_TABLE_100();
766: else

Line 763: a13 := JTF_NUMBER_TABLE();

759: a9 := JTF_DATE_TABLE();
760: a10 := JTF_DATE_TABLE();
761: a11 := JTF_VARCHAR2_TABLE_100();
762: a12 := JTF_NUMBER_TABLE();
763: a13 := JTF_NUMBER_TABLE();
764: a14 := JTF_VARCHAR2_TABLE_100();
765: a15 := JTF_VARCHAR2_TABLE_100();
766: else
767: a0 := JTF_NUMBER_TABLE();

Line 767: a0 := JTF_NUMBER_TABLE();

763: a13 := JTF_NUMBER_TABLE();
764: a14 := JTF_VARCHAR2_TABLE_100();
765: a15 := JTF_VARCHAR2_TABLE_100();
766: else
767: a0 := JTF_NUMBER_TABLE();
768: a1 := JTF_VARCHAR2_TABLE_100();
769: a2 := JTF_NUMBER_TABLE();
770: a3 := JTF_NUMBER_TABLE();
771: a4 := JTF_VARCHAR2_TABLE_100();

Line 769: a2 := JTF_NUMBER_TABLE();

765: a15 := JTF_VARCHAR2_TABLE_100();
766: else
767: a0 := JTF_NUMBER_TABLE();
768: a1 := JTF_VARCHAR2_TABLE_100();
769: a2 := JTF_NUMBER_TABLE();
770: a3 := JTF_NUMBER_TABLE();
771: a4 := JTF_VARCHAR2_TABLE_100();
772: a5 := JTF_NUMBER_TABLE();
773: a6 := JTF_NUMBER_TABLE();

Line 770: a3 := JTF_NUMBER_TABLE();

766: else
767: a0 := JTF_NUMBER_TABLE();
768: a1 := JTF_VARCHAR2_TABLE_100();
769: a2 := JTF_NUMBER_TABLE();
770: a3 := JTF_NUMBER_TABLE();
771: a4 := JTF_VARCHAR2_TABLE_100();
772: a5 := JTF_NUMBER_TABLE();
773: a6 := JTF_NUMBER_TABLE();
774: a7 := JTF_NUMBER_TABLE();

Line 772: a5 := JTF_NUMBER_TABLE();

768: a1 := JTF_VARCHAR2_TABLE_100();
769: a2 := JTF_NUMBER_TABLE();
770: a3 := JTF_NUMBER_TABLE();
771: a4 := JTF_VARCHAR2_TABLE_100();
772: a5 := JTF_NUMBER_TABLE();
773: a6 := JTF_NUMBER_TABLE();
774: a7 := JTF_NUMBER_TABLE();
775: a8 := JTF_VARCHAR2_TABLE_100();
776: a9 := JTF_DATE_TABLE();

Line 773: a6 := JTF_NUMBER_TABLE();

769: a2 := JTF_NUMBER_TABLE();
770: a3 := JTF_NUMBER_TABLE();
771: a4 := JTF_VARCHAR2_TABLE_100();
772: a5 := JTF_NUMBER_TABLE();
773: a6 := JTF_NUMBER_TABLE();
774: a7 := JTF_NUMBER_TABLE();
775: a8 := JTF_VARCHAR2_TABLE_100();
776: a9 := JTF_DATE_TABLE();
777: a10 := JTF_DATE_TABLE();

Line 774: a7 := JTF_NUMBER_TABLE();

770: a3 := JTF_NUMBER_TABLE();
771: a4 := JTF_VARCHAR2_TABLE_100();
772: a5 := JTF_NUMBER_TABLE();
773: a6 := JTF_NUMBER_TABLE();
774: a7 := JTF_NUMBER_TABLE();
775: a8 := JTF_VARCHAR2_TABLE_100();
776: a9 := JTF_DATE_TABLE();
777: a10 := JTF_DATE_TABLE();
778: a11 := JTF_VARCHAR2_TABLE_100();

Line 779: a12 := JTF_NUMBER_TABLE();

775: a8 := JTF_VARCHAR2_TABLE_100();
776: a9 := JTF_DATE_TABLE();
777: a10 := JTF_DATE_TABLE();
778: a11 := JTF_VARCHAR2_TABLE_100();
779: a12 := JTF_NUMBER_TABLE();
780: a13 := JTF_NUMBER_TABLE();
781: a14 := JTF_VARCHAR2_TABLE_100();
782: a15 := JTF_VARCHAR2_TABLE_100();
783: if t.count > 0 then

Line 780: a13 := JTF_NUMBER_TABLE();

776: a9 := JTF_DATE_TABLE();
777: a10 := JTF_DATE_TABLE();
778: a11 := JTF_VARCHAR2_TABLE_100();
779: a12 := JTF_NUMBER_TABLE();
780: a13 := JTF_NUMBER_TABLE();
781: a14 := JTF_VARCHAR2_TABLE_100();
782: a15 := JTF_VARCHAR2_TABLE_100();
783: if t.count > 0 then
784: a0.extend(t.count);

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

825: end if;
826: end if;
827: end rosetta_table_copy_out_p19;
828:
829: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
830: , a1 JTF_VARCHAR2_TABLE_100
831: , a2 JTF_VARCHAR2_TABLE_100
832: , a3 JTF_NUMBER_TABLE
833: , a4 JTF_VARCHAR2_TABLE_100

Line 832: , a3 JTF_NUMBER_TABLE

828:
829: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
830: , a1 JTF_VARCHAR2_TABLE_100
831: , a2 JTF_VARCHAR2_TABLE_100
832: , a3 JTF_NUMBER_TABLE
833: , a4 JTF_VARCHAR2_TABLE_100
834: , a5 JTF_NUMBER_TABLE
835: ) as
836: ddindx binary_integer; indx binary_integer;

Line 834: , a5 JTF_NUMBER_TABLE

830: , a1 JTF_VARCHAR2_TABLE_100
831: , a2 JTF_VARCHAR2_TABLE_100
832: , a3 JTF_NUMBER_TABLE
833: , a4 JTF_VARCHAR2_TABLE_100
834: , a5 JTF_NUMBER_TABLE
835: ) as
836: ddindx binary_integer; indx binary_integer;
837: begin
838: if a0 is not null and a0.count > 0 then

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

854: end loop;
855: end if;
856: end if;
857: end rosetta_table_copy_in_p20;
858: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
859: , a1 out nocopy JTF_VARCHAR2_TABLE_100
860: , a2 out nocopy JTF_VARCHAR2_TABLE_100
861: , a3 out nocopy JTF_NUMBER_TABLE
862: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 861: , a3 out nocopy JTF_NUMBER_TABLE

857: end rosetta_table_copy_in_p20;
858: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
859: , a1 out nocopy JTF_VARCHAR2_TABLE_100
860: , a2 out nocopy JTF_VARCHAR2_TABLE_100
861: , a3 out nocopy JTF_NUMBER_TABLE
862: , a4 out nocopy JTF_VARCHAR2_TABLE_100
863: , a5 out nocopy JTF_NUMBER_TABLE
864: ) as
865: ddindx binary_integer; indx binary_integer;

Line 863: , a5 out nocopy JTF_NUMBER_TABLE

859: , a1 out nocopy JTF_VARCHAR2_TABLE_100
860: , a2 out nocopy JTF_VARCHAR2_TABLE_100
861: , a3 out nocopy JTF_NUMBER_TABLE
862: , a4 out nocopy JTF_VARCHAR2_TABLE_100
863: , a5 out nocopy JTF_NUMBER_TABLE
864: ) as
865: ddindx binary_integer; indx binary_integer;
866: begin
867: if t is null or t.count = 0 then

Line 868: a0 := JTF_NUMBER_TABLE();

864: ) as
865: ddindx binary_integer; indx binary_integer;
866: begin
867: if t is null or t.count = 0 then
868: a0 := JTF_NUMBER_TABLE();
869: a1 := JTF_VARCHAR2_TABLE_100();
870: a2 := JTF_VARCHAR2_TABLE_100();
871: a3 := JTF_NUMBER_TABLE();
872: a4 := JTF_VARCHAR2_TABLE_100();

Line 871: a3 := JTF_NUMBER_TABLE();

867: if t is null or t.count = 0 then
868: a0 := JTF_NUMBER_TABLE();
869: a1 := JTF_VARCHAR2_TABLE_100();
870: a2 := JTF_VARCHAR2_TABLE_100();
871: a3 := JTF_NUMBER_TABLE();
872: a4 := JTF_VARCHAR2_TABLE_100();
873: a5 := JTF_NUMBER_TABLE();
874: else
875: a0 := JTF_NUMBER_TABLE();

Line 873: a5 := JTF_NUMBER_TABLE();

869: a1 := JTF_VARCHAR2_TABLE_100();
870: a2 := JTF_VARCHAR2_TABLE_100();
871: a3 := JTF_NUMBER_TABLE();
872: a4 := JTF_VARCHAR2_TABLE_100();
873: a5 := JTF_NUMBER_TABLE();
874: else
875: a0 := JTF_NUMBER_TABLE();
876: a1 := JTF_VARCHAR2_TABLE_100();
877: a2 := JTF_VARCHAR2_TABLE_100();

Line 875: a0 := JTF_NUMBER_TABLE();

871: a3 := JTF_NUMBER_TABLE();
872: a4 := JTF_VARCHAR2_TABLE_100();
873: a5 := JTF_NUMBER_TABLE();
874: else
875: a0 := JTF_NUMBER_TABLE();
876: a1 := JTF_VARCHAR2_TABLE_100();
877: a2 := JTF_VARCHAR2_TABLE_100();
878: a3 := JTF_NUMBER_TABLE();
879: a4 := JTF_VARCHAR2_TABLE_100();

Line 878: a3 := JTF_NUMBER_TABLE();

874: else
875: a0 := JTF_NUMBER_TABLE();
876: a1 := JTF_VARCHAR2_TABLE_100();
877: a2 := JTF_VARCHAR2_TABLE_100();
878: a3 := JTF_NUMBER_TABLE();
879: a4 := JTF_VARCHAR2_TABLE_100();
880: a5 := JTF_NUMBER_TABLE();
881: if t.count > 0 then
882: a0.extend(t.count);

Line 880: a5 := JTF_NUMBER_TABLE();

876: a1 := JTF_VARCHAR2_TABLE_100();
877: a2 := JTF_VARCHAR2_TABLE_100();
878: a3 := JTF_NUMBER_TABLE();
879: a4 := JTF_VARCHAR2_TABLE_100();
880: a5 := JTF_NUMBER_TABLE();
881: if t.count > 0 then
882: a0.extend(t.count);
883: a1.extend(t.count);
884: a2.extend(t.count);

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

903: end if;
904: end if;
905: end rosetta_table_copy_out_p20;
906:
907: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
908: , a1 JTF_VARCHAR2_TABLE_100
909: , a2 JTF_NUMBER_TABLE
910: , a3 JTF_VARCHAR2_TABLE_100
911: , a4 JTF_VARCHAR2_TABLE_100

Line 909: , a2 JTF_NUMBER_TABLE

905: end rosetta_table_copy_out_p20;
906:
907: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
908: , a1 JTF_VARCHAR2_TABLE_100
909: , a2 JTF_NUMBER_TABLE
910: , a3 JTF_VARCHAR2_TABLE_100
911: , a4 JTF_VARCHAR2_TABLE_100
912: , a5 JTF_VARCHAR2_TABLE_300
913: , a6 JTF_NUMBER_TABLE

Line 913: , a6 JTF_NUMBER_TABLE

909: , a2 JTF_NUMBER_TABLE
910: , a3 JTF_VARCHAR2_TABLE_100
911: , a4 JTF_VARCHAR2_TABLE_100
912: , a5 JTF_VARCHAR2_TABLE_300
913: , a6 JTF_NUMBER_TABLE
914: , a7 JTF_VARCHAR2_TABLE_300
915: , a8 JTF_VARCHAR2_TABLE_100
916: , a9 JTF_VARCHAR2_TABLE_100
917: , a10 JTF_NUMBER_TABLE

Line 917: , a10 JTF_NUMBER_TABLE

913: , a6 JTF_NUMBER_TABLE
914: , a7 JTF_VARCHAR2_TABLE_300
915: , a8 JTF_VARCHAR2_TABLE_100
916: , a9 JTF_VARCHAR2_TABLE_100
917: , a10 JTF_NUMBER_TABLE
918: , a11 JTF_NUMBER_TABLE
919: , a12 JTF_VARCHAR2_TABLE_100
920: , a13 JTF_NUMBER_TABLE
921: , a14 JTF_NUMBER_TABLE

Line 918: , a11 JTF_NUMBER_TABLE

914: , a7 JTF_VARCHAR2_TABLE_300
915: , a8 JTF_VARCHAR2_TABLE_100
916: , a9 JTF_VARCHAR2_TABLE_100
917: , a10 JTF_NUMBER_TABLE
918: , a11 JTF_NUMBER_TABLE
919: , a12 JTF_VARCHAR2_TABLE_100
920: , a13 JTF_NUMBER_TABLE
921: , a14 JTF_NUMBER_TABLE
922: , a15 JTF_VARCHAR2_TABLE_100

Line 920: , a13 JTF_NUMBER_TABLE

916: , a9 JTF_VARCHAR2_TABLE_100
917: , a10 JTF_NUMBER_TABLE
918: , a11 JTF_NUMBER_TABLE
919: , a12 JTF_VARCHAR2_TABLE_100
920: , a13 JTF_NUMBER_TABLE
921: , a14 JTF_NUMBER_TABLE
922: , a15 JTF_VARCHAR2_TABLE_100
923: , a16 JTF_VARCHAR2_TABLE_100
924: , a17 JTF_DATE_TABLE

Line 921: , a14 JTF_NUMBER_TABLE

917: , a10 JTF_NUMBER_TABLE
918: , a11 JTF_NUMBER_TABLE
919: , a12 JTF_VARCHAR2_TABLE_100
920: , a13 JTF_NUMBER_TABLE
921: , a14 JTF_NUMBER_TABLE
922: , a15 JTF_VARCHAR2_TABLE_100
923: , a16 JTF_VARCHAR2_TABLE_100
924: , a17 JTF_DATE_TABLE
925: , a18 JTF_DATE_TABLE

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

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

Line 972: , a2 out nocopy JTF_NUMBER_TABLE

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

Line 976: , a6 out nocopy JTF_NUMBER_TABLE

972: , a2 out nocopy JTF_NUMBER_TABLE
973: , a3 out nocopy JTF_VARCHAR2_TABLE_100
974: , a4 out nocopy JTF_VARCHAR2_TABLE_100
975: , a5 out nocopy JTF_VARCHAR2_TABLE_300
976: , a6 out nocopy JTF_NUMBER_TABLE
977: , a7 out nocopy JTF_VARCHAR2_TABLE_300
978: , a8 out nocopy JTF_VARCHAR2_TABLE_100
979: , a9 out nocopy JTF_VARCHAR2_TABLE_100
980: , a10 out nocopy JTF_NUMBER_TABLE

Line 980: , a10 out nocopy JTF_NUMBER_TABLE

976: , a6 out nocopy JTF_NUMBER_TABLE
977: , a7 out nocopy JTF_VARCHAR2_TABLE_300
978: , a8 out nocopy JTF_VARCHAR2_TABLE_100
979: , a9 out nocopy JTF_VARCHAR2_TABLE_100
980: , a10 out nocopy JTF_NUMBER_TABLE
981: , a11 out nocopy JTF_NUMBER_TABLE
982: , a12 out nocopy JTF_VARCHAR2_TABLE_100
983: , a13 out nocopy JTF_NUMBER_TABLE
984: , a14 out nocopy JTF_NUMBER_TABLE

Line 981: , a11 out nocopy JTF_NUMBER_TABLE

977: , a7 out nocopy JTF_VARCHAR2_TABLE_300
978: , a8 out nocopy JTF_VARCHAR2_TABLE_100
979: , a9 out nocopy JTF_VARCHAR2_TABLE_100
980: , a10 out nocopy JTF_NUMBER_TABLE
981: , a11 out nocopy JTF_NUMBER_TABLE
982: , a12 out nocopy JTF_VARCHAR2_TABLE_100
983: , a13 out nocopy JTF_NUMBER_TABLE
984: , a14 out nocopy JTF_NUMBER_TABLE
985: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 983: , a13 out nocopy JTF_NUMBER_TABLE

979: , a9 out nocopy JTF_VARCHAR2_TABLE_100
980: , a10 out nocopy JTF_NUMBER_TABLE
981: , a11 out nocopy JTF_NUMBER_TABLE
982: , a12 out nocopy JTF_VARCHAR2_TABLE_100
983: , a13 out nocopy JTF_NUMBER_TABLE
984: , a14 out nocopy JTF_NUMBER_TABLE
985: , a15 out nocopy JTF_VARCHAR2_TABLE_100
986: , a16 out nocopy JTF_VARCHAR2_TABLE_100
987: , a17 out nocopy JTF_DATE_TABLE

Line 984: , a14 out nocopy JTF_NUMBER_TABLE

980: , a10 out nocopy JTF_NUMBER_TABLE
981: , a11 out nocopy JTF_NUMBER_TABLE
982: , a12 out nocopy JTF_VARCHAR2_TABLE_100
983: , a13 out nocopy JTF_NUMBER_TABLE
984: , a14 out nocopy JTF_NUMBER_TABLE
985: , a15 out nocopy JTF_VARCHAR2_TABLE_100
986: , a16 out nocopy JTF_VARCHAR2_TABLE_100
987: , a17 out nocopy JTF_DATE_TABLE
988: , a18 out nocopy JTF_DATE_TABLE

Line 1017: a0 := JTF_NUMBER_TABLE();

1013: a18 := null;
1014: a19 := null;
1015: a20 := null;
1016: elsif t.count = 0 then
1017: a0 := JTF_NUMBER_TABLE();
1018: a1 := JTF_VARCHAR2_TABLE_100();
1019: a2 := JTF_NUMBER_TABLE();
1020: a3 := JTF_VARCHAR2_TABLE_100();
1021: a4 := JTF_VARCHAR2_TABLE_100();

Line 1019: a2 := JTF_NUMBER_TABLE();

1015: a20 := null;
1016: elsif t.count = 0 then
1017: a0 := JTF_NUMBER_TABLE();
1018: a1 := JTF_VARCHAR2_TABLE_100();
1019: a2 := JTF_NUMBER_TABLE();
1020: a3 := JTF_VARCHAR2_TABLE_100();
1021: a4 := JTF_VARCHAR2_TABLE_100();
1022: a5 := JTF_VARCHAR2_TABLE_300();
1023: a6 := JTF_NUMBER_TABLE();

Line 1023: a6 := JTF_NUMBER_TABLE();

1019: a2 := JTF_NUMBER_TABLE();
1020: a3 := JTF_VARCHAR2_TABLE_100();
1021: a4 := JTF_VARCHAR2_TABLE_100();
1022: a5 := JTF_VARCHAR2_TABLE_300();
1023: a6 := JTF_NUMBER_TABLE();
1024: a7 := JTF_VARCHAR2_TABLE_300();
1025: a8 := JTF_VARCHAR2_TABLE_100();
1026: a9 := JTF_VARCHAR2_TABLE_100();
1027: a10 := JTF_NUMBER_TABLE();

Line 1027: a10 := JTF_NUMBER_TABLE();

1023: a6 := JTF_NUMBER_TABLE();
1024: a7 := JTF_VARCHAR2_TABLE_300();
1025: a8 := JTF_VARCHAR2_TABLE_100();
1026: a9 := JTF_VARCHAR2_TABLE_100();
1027: a10 := JTF_NUMBER_TABLE();
1028: a11 := JTF_NUMBER_TABLE();
1029: a12 := JTF_VARCHAR2_TABLE_100();
1030: a13 := JTF_NUMBER_TABLE();
1031: a14 := JTF_NUMBER_TABLE();

Line 1028: a11 := JTF_NUMBER_TABLE();

1024: a7 := JTF_VARCHAR2_TABLE_300();
1025: a8 := JTF_VARCHAR2_TABLE_100();
1026: a9 := JTF_VARCHAR2_TABLE_100();
1027: a10 := JTF_NUMBER_TABLE();
1028: a11 := JTF_NUMBER_TABLE();
1029: a12 := JTF_VARCHAR2_TABLE_100();
1030: a13 := JTF_NUMBER_TABLE();
1031: a14 := JTF_NUMBER_TABLE();
1032: a15 := JTF_VARCHAR2_TABLE_100();

Line 1030: a13 := JTF_NUMBER_TABLE();

1026: a9 := JTF_VARCHAR2_TABLE_100();
1027: a10 := JTF_NUMBER_TABLE();
1028: a11 := JTF_NUMBER_TABLE();
1029: a12 := JTF_VARCHAR2_TABLE_100();
1030: a13 := JTF_NUMBER_TABLE();
1031: a14 := JTF_NUMBER_TABLE();
1032: a15 := JTF_VARCHAR2_TABLE_100();
1033: a16 := JTF_VARCHAR2_TABLE_100();
1034: a17 := JTF_DATE_TABLE();

Line 1031: a14 := JTF_NUMBER_TABLE();

1027: a10 := JTF_NUMBER_TABLE();
1028: a11 := JTF_NUMBER_TABLE();
1029: a12 := JTF_VARCHAR2_TABLE_100();
1030: a13 := JTF_NUMBER_TABLE();
1031: a14 := JTF_NUMBER_TABLE();
1032: a15 := JTF_VARCHAR2_TABLE_100();
1033: a16 := JTF_VARCHAR2_TABLE_100();
1034: a17 := JTF_DATE_TABLE();
1035: a18 := JTF_DATE_TABLE();

Line 1039: a0 := JTF_NUMBER_TABLE();

1035: a18 := JTF_DATE_TABLE();
1036: a19 := JTF_VARCHAR2_TABLE_100();
1037: a20 := JTF_VARCHAR2_TABLE_100();
1038: else
1039: a0 := JTF_NUMBER_TABLE();
1040: a1 := JTF_VARCHAR2_TABLE_100();
1041: a2 := JTF_NUMBER_TABLE();
1042: a3 := JTF_VARCHAR2_TABLE_100();
1043: a4 := JTF_VARCHAR2_TABLE_100();

Line 1041: a2 := JTF_NUMBER_TABLE();

1037: a20 := JTF_VARCHAR2_TABLE_100();
1038: else
1039: a0 := JTF_NUMBER_TABLE();
1040: a1 := JTF_VARCHAR2_TABLE_100();
1041: a2 := JTF_NUMBER_TABLE();
1042: a3 := JTF_VARCHAR2_TABLE_100();
1043: a4 := JTF_VARCHAR2_TABLE_100();
1044: a5 := JTF_VARCHAR2_TABLE_300();
1045: a6 := JTF_NUMBER_TABLE();

Line 1045: a6 := JTF_NUMBER_TABLE();

1041: a2 := JTF_NUMBER_TABLE();
1042: a3 := JTF_VARCHAR2_TABLE_100();
1043: a4 := JTF_VARCHAR2_TABLE_100();
1044: a5 := JTF_VARCHAR2_TABLE_300();
1045: a6 := JTF_NUMBER_TABLE();
1046: a7 := JTF_VARCHAR2_TABLE_300();
1047: a8 := JTF_VARCHAR2_TABLE_100();
1048: a9 := JTF_VARCHAR2_TABLE_100();
1049: a10 := JTF_NUMBER_TABLE();

Line 1049: a10 := JTF_NUMBER_TABLE();

1045: a6 := JTF_NUMBER_TABLE();
1046: a7 := JTF_VARCHAR2_TABLE_300();
1047: a8 := JTF_VARCHAR2_TABLE_100();
1048: a9 := JTF_VARCHAR2_TABLE_100();
1049: a10 := JTF_NUMBER_TABLE();
1050: a11 := JTF_NUMBER_TABLE();
1051: a12 := JTF_VARCHAR2_TABLE_100();
1052: a13 := JTF_NUMBER_TABLE();
1053: a14 := JTF_NUMBER_TABLE();

Line 1050: a11 := JTF_NUMBER_TABLE();

1046: a7 := JTF_VARCHAR2_TABLE_300();
1047: a8 := JTF_VARCHAR2_TABLE_100();
1048: a9 := JTF_VARCHAR2_TABLE_100();
1049: a10 := JTF_NUMBER_TABLE();
1050: a11 := JTF_NUMBER_TABLE();
1051: a12 := JTF_VARCHAR2_TABLE_100();
1052: a13 := JTF_NUMBER_TABLE();
1053: a14 := JTF_NUMBER_TABLE();
1054: a15 := JTF_VARCHAR2_TABLE_100();

Line 1052: a13 := JTF_NUMBER_TABLE();

1048: a9 := JTF_VARCHAR2_TABLE_100();
1049: a10 := JTF_NUMBER_TABLE();
1050: a11 := JTF_NUMBER_TABLE();
1051: a12 := JTF_VARCHAR2_TABLE_100();
1052: a13 := JTF_NUMBER_TABLE();
1053: a14 := JTF_NUMBER_TABLE();
1054: a15 := JTF_VARCHAR2_TABLE_100();
1055: a16 := JTF_VARCHAR2_TABLE_100();
1056: a17 := JTF_DATE_TABLE();

Line 1053: a14 := JTF_NUMBER_TABLE();

1049: a10 := JTF_NUMBER_TABLE();
1050: a11 := JTF_NUMBER_TABLE();
1051: a12 := JTF_VARCHAR2_TABLE_100();
1052: a13 := JTF_NUMBER_TABLE();
1053: a14 := JTF_NUMBER_TABLE();
1054: a15 := JTF_VARCHAR2_TABLE_100();
1055: a16 := JTF_VARCHAR2_TABLE_100();
1056: a17 := JTF_DATE_TABLE();
1057: a18 := JTF_DATE_TABLE();

Line 1117: , a1 JTF_NUMBER_TABLE

1113: end if;
1114: end rosetta_table_copy_out_p21;
1115:
1116: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1117: , a1 JTF_NUMBER_TABLE
1118: , a2 JTF_NUMBER_TABLE
1119: , a3 JTF_VARCHAR2_TABLE_100
1120: , a4 JTF_VARCHAR2_TABLE_100
1121: , a5 JTF_VARCHAR2_TABLE_300

Line 1118: , a2 JTF_NUMBER_TABLE

1114: end rosetta_table_copy_out_p21;
1115:
1116: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
1117: , a1 JTF_NUMBER_TABLE
1118: , a2 JTF_NUMBER_TABLE
1119: , a3 JTF_VARCHAR2_TABLE_100
1120: , a4 JTF_VARCHAR2_TABLE_100
1121: , a5 JTF_VARCHAR2_TABLE_300
1122: ) as

Line 1150: , a1 out nocopy JTF_NUMBER_TABLE

1146: end if;
1147: end if;
1148: end rosetta_table_copy_in_p22;
1149: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1150: , a1 out nocopy JTF_NUMBER_TABLE
1151: , a2 out nocopy JTF_NUMBER_TABLE
1152: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1153: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1154: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 1151: , a2 out nocopy JTF_NUMBER_TABLE

1147: end if;
1148: end rosetta_table_copy_in_p22;
1149: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1150: , a1 out nocopy JTF_NUMBER_TABLE
1151: , a2 out nocopy JTF_NUMBER_TABLE
1152: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1153: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1154: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1155: ) as

Line 1167: a1 := JTF_NUMBER_TABLE();

1163: a4 := null;
1164: a5 := null;
1165: elsif t.count = 0 then
1166: a0 := JTF_VARCHAR2_TABLE_100();
1167: a1 := JTF_NUMBER_TABLE();
1168: a2 := JTF_NUMBER_TABLE();
1169: a3 := JTF_VARCHAR2_TABLE_100();
1170: a4 := JTF_VARCHAR2_TABLE_100();
1171: a5 := JTF_VARCHAR2_TABLE_300();

Line 1168: a2 := JTF_NUMBER_TABLE();

1164: a5 := null;
1165: elsif t.count = 0 then
1166: a0 := JTF_VARCHAR2_TABLE_100();
1167: a1 := JTF_NUMBER_TABLE();
1168: a2 := JTF_NUMBER_TABLE();
1169: a3 := JTF_VARCHAR2_TABLE_100();
1170: a4 := JTF_VARCHAR2_TABLE_100();
1171: a5 := JTF_VARCHAR2_TABLE_300();
1172: else

Line 1174: a1 := JTF_NUMBER_TABLE();

1170: a4 := JTF_VARCHAR2_TABLE_100();
1171: a5 := JTF_VARCHAR2_TABLE_300();
1172: else
1173: a0 := JTF_VARCHAR2_TABLE_100();
1174: a1 := JTF_NUMBER_TABLE();
1175: a2 := JTF_NUMBER_TABLE();
1176: a3 := JTF_VARCHAR2_TABLE_100();
1177: a4 := JTF_VARCHAR2_TABLE_100();
1178: a5 := JTF_VARCHAR2_TABLE_300();

Line 1175: a2 := JTF_NUMBER_TABLE();

1171: a5 := JTF_VARCHAR2_TABLE_300();
1172: else
1173: a0 := JTF_VARCHAR2_TABLE_100();
1174: a1 := JTF_NUMBER_TABLE();
1175: a2 := JTF_NUMBER_TABLE();
1176: a3 := JTF_VARCHAR2_TABLE_100();
1177: a4 := JTF_VARCHAR2_TABLE_100();
1178: a5 := JTF_VARCHAR2_TABLE_300();
1179: if t.count > 0 then

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

1201: end if;
1202: end if;
1203: end rosetta_table_copy_out_p22;
1204:
1205: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1206: , a1 JTF_VARCHAR2_TABLE_100
1207: , a2 JTF_VARCHAR2_TABLE_100
1208: , a3 JTF_NUMBER_TABLE
1209: , a4 JTF_NUMBER_TABLE

Line 1208: , a3 JTF_NUMBER_TABLE

1204:
1205: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1206: , a1 JTF_VARCHAR2_TABLE_100
1207: , a2 JTF_VARCHAR2_TABLE_100
1208: , a3 JTF_NUMBER_TABLE
1209: , a4 JTF_NUMBER_TABLE
1210: , a5 JTF_VARCHAR2_TABLE_100
1211: , a6 JTF_NUMBER_TABLE
1212: , a7 JTF_NUMBER_TABLE

Line 1209: , a4 JTF_NUMBER_TABLE

1205: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
1206: , a1 JTF_VARCHAR2_TABLE_100
1207: , a2 JTF_VARCHAR2_TABLE_100
1208: , a3 JTF_NUMBER_TABLE
1209: , a4 JTF_NUMBER_TABLE
1210: , a5 JTF_VARCHAR2_TABLE_100
1211: , a6 JTF_NUMBER_TABLE
1212: , a7 JTF_NUMBER_TABLE
1213: ) as

Line 1211: , a6 JTF_NUMBER_TABLE

1207: , a2 JTF_VARCHAR2_TABLE_100
1208: , a3 JTF_NUMBER_TABLE
1209: , a4 JTF_NUMBER_TABLE
1210: , a5 JTF_VARCHAR2_TABLE_100
1211: , a6 JTF_NUMBER_TABLE
1212: , a7 JTF_NUMBER_TABLE
1213: ) as
1214: ddindx binary_integer; indx binary_integer;
1215: begin

Line 1212: , a7 JTF_NUMBER_TABLE

1208: , a3 JTF_NUMBER_TABLE
1209: , a4 JTF_NUMBER_TABLE
1210: , a5 JTF_VARCHAR2_TABLE_100
1211: , a6 JTF_NUMBER_TABLE
1212: , a7 JTF_NUMBER_TABLE
1213: ) as
1214: ddindx binary_integer; indx binary_integer;
1215: begin
1216: if a0 is not null and a0.count=0 then

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

1238: end loop;
1239: end if;
1240: end if;
1241: end rosetta_table_copy_in_p23;
1242: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1243: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1244: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1245: , a3 out nocopy JTF_NUMBER_TABLE
1246: , a4 out nocopy JTF_NUMBER_TABLE

Line 1245: , a3 out nocopy JTF_NUMBER_TABLE

1241: end rosetta_table_copy_in_p23;
1242: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1243: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1244: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1245: , a3 out nocopy JTF_NUMBER_TABLE
1246: , a4 out nocopy JTF_NUMBER_TABLE
1247: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1248: , a6 out nocopy JTF_NUMBER_TABLE
1249: , a7 out nocopy JTF_NUMBER_TABLE

Line 1246: , a4 out nocopy JTF_NUMBER_TABLE

1242: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
1243: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1244: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1245: , a3 out nocopy JTF_NUMBER_TABLE
1246: , a4 out nocopy JTF_NUMBER_TABLE
1247: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1248: , a6 out nocopy JTF_NUMBER_TABLE
1249: , a7 out nocopy JTF_NUMBER_TABLE
1250: ) as

Line 1248: , a6 out nocopy JTF_NUMBER_TABLE

1244: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1245: , a3 out nocopy JTF_NUMBER_TABLE
1246: , a4 out nocopy JTF_NUMBER_TABLE
1247: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1248: , a6 out nocopy JTF_NUMBER_TABLE
1249: , a7 out nocopy JTF_NUMBER_TABLE
1250: ) as
1251: ddindx binary_integer; indx binary_integer;
1252: begin

Line 1249: , a7 out nocopy JTF_NUMBER_TABLE

1245: , a3 out nocopy JTF_NUMBER_TABLE
1246: , a4 out nocopy JTF_NUMBER_TABLE
1247: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1248: , a6 out nocopy JTF_NUMBER_TABLE
1249: , a7 out nocopy JTF_NUMBER_TABLE
1250: ) as
1251: ddindx binary_integer; indx binary_integer;
1252: begin
1253: if t is null then

Line 1263: a0 := JTF_NUMBER_TABLE();

1259: a5 := null;
1260: a6 := null;
1261: a7 := null;
1262: elsif t.count = 0 then
1263: a0 := JTF_NUMBER_TABLE();
1264: a1 := JTF_VARCHAR2_TABLE_100();
1265: a2 := JTF_VARCHAR2_TABLE_100();
1266: a3 := JTF_NUMBER_TABLE();
1267: a4 := JTF_NUMBER_TABLE();

Line 1266: a3 := JTF_NUMBER_TABLE();

1262: elsif t.count = 0 then
1263: a0 := JTF_NUMBER_TABLE();
1264: a1 := JTF_VARCHAR2_TABLE_100();
1265: a2 := JTF_VARCHAR2_TABLE_100();
1266: a3 := JTF_NUMBER_TABLE();
1267: a4 := JTF_NUMBER_TABLE();
1268: a5 := JTF_VARCHAR2_TABLE_100();
1269: a6 := JTF_NUMBER_TABLE();
1270: a7 := JTF_NUMBER_TABLE();

Line 1267: a4 := JTF_NUMBER_TABLE();

1263: a0 := JTF_NUMBER_TABLE();
1264: a1 := JTF_VARCHAR2_TABLE_100();
1265: a2 := JTF_VARCHAR2_TABLE_100();
1266: a3 := JTF_NUMBER_TABLE();
1267: a4 := JTF_NUMBER_TABLE();
1268: a5 := JTF_VARCHAR2_TABLE_100();
1269: a6 := JTF_NUMBER_TABLE();
1270: a7 := JTF_NUMBER_TABLE();
1271: else

Line 1269: a6 := JTF_NUMBER_TABLE();

1265: a2 := JTF_VARCHAR2_TABLE_100();
1266: a3 := JTF_NUMBER_TABLE();
1267: a4 := JTF_NUMBER_TABLE();
1268: a5 := JTF_VARCHAR2_TABLE_100();
1269: a6 := JTF_NUMBER_TABLE();
1270: a7 := JTF_NUMBER_TABLE();
1271: else
1272: a0 := JTF_NUMBER_TABLE();
1273: a1 := JTF_VARCHAR2_TABLE_100();

Line 1270: a7 := JTF_NUMBER_TABLE();

1266: a3 := JTF_NUMBER_TABLE();
1267: a4 := JTF_NUMBER_TABLE();
1268: a5 := JTF_VARCHAR2_TABLE_100();
1269: a6 := JTF_NUMBER_TABLE();
1270: a7 := JTF_NUMBER_TABLE();
1271: else
1272: a0 := JTF_NUMBER_TABLE();
1273: a1 := JTF_VARCHAR2_TABLE_100();
1274: a2 := JTF_VARCHAR2_TABLE_100();

Line 1272: a0 := JTF_NUMBER_TABLE();

1268: a5 := JTF_VARCHAR2_TABLE_100();
1269: a6 := JTF_NUMBER_TABLE();
1270: a7 := JTF_NUMBER_TABLE();
1271: else
1272: a0 := JTF_NUMBER_TABLE();
1273: a1 := JTF_VARCHAR2_TABLE_100();
1274: a2 := JTF_VARCHAR2_TABLE_100();
1275: a3 := JTF_NUMBER_TABLE();
1276: a4 := JTF_NUMBER_TABLE();

Line 1275: a3 := JTF_NUMBER_TABLE();

1271: else
1272: a0 := JTF_NUMBER_TABLE();
1273: a1 := JTF_VARCHAR2_TABLE_100();
1274: a2 := JTF_VARCHAR2_TABLE_100();
1275: a3 := JTF_NUMBER_TABLE();
1276: a4 := JTF_NUMBER_TABLE();
1277: a5 := JTF_VARCHAR2_TABLE_100();
1278: a6 := JTF_NUMBER_TABLE();
1279: a7 := JTF_NUMBER_TABLE();

Line 1276: a4 := JTF_NUMBER_TABLE();

1272: a0 := JTF_NUMBER_TABLE();
1273: a1 := JTF_VARCHAR2_TABLE_100();
1274: a2 := JTF_VARCHAR2_TABLE_100();
1275: a3 := JTF_NUMBER_TABLE();
1276: a4 := JTF_NUMBER_TABLE();
1277: a5 := JTF_VARCHAR2_TABLE_100();
1278: a6 := JTF_NUMBER_TABLE();
1279: a7 := JTF_NUMBER_TABLE();
1280: if t.count > 0 then

Line 1278: a6 := JTF_NUMBER_TABLE();

1274: a2 := JTF_VARCHAR2_TABLE_100();
1275: a3 := JTF_NUMBER_TABLE();
1276: a4 := JTF_NUMBER_TABLE();
1277: a5 := JTF_VARCHAR2_TABLE_100();
1278: a6 := JTF_NUMBER_TABLE();
1279: a7 := JTF_NUMBER_TABLE();
1280: if t.count > 0 then
1281: a0.extend(t.count);
1282: a1.extend(t.count);

Line 1279: a7 := JTF_NUMBER_TABLE();

1275: a3 := JTF_NUMBER_TABLE();
1276: a4 := JTF_NUMBER_TABLE();
1277: a5 := JTF_VARCHAR2_TABLE_100();
1278: a6 := JTF_NUMBER_TABLE();
1279: a7 := JTF_NUMBER_TABLE();
1280: if t.count > 0 then
1281: a0.extend(t.count);
1282: a1.extend(t.count);
1283: a2.extend(t.count);

Line 1312: , p2_a0 JTF_NUMBER_TABLE

1308: end rosetta_table_copy_out_p23;
1309:
1310: procedure get_availability_options(p_api_version_number NUMBER
1311: , p_task_id NUMBER
1312: , p2_a0 JTF_NUMBER_TABLE
1313: , p2_a1 JTF_VARCHAR2_TABLE_100
1314: , p3_a0 DATE
1315: , p3_a1 DATE
1316: , p_likelihood NUMBER

Line 1318: , p6_a0 out nocopy JTF_NUMBER_TABLE

1314: , p3_a0 DATE
1315: , p3_a1 DATE
1316: , p_likelihood NUMBER
1317: , p_subinv_only number
1318: , p6_a0 out nocopy JTF_NUMBER_TABLE
1319: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1320: , p6_a2 out nocopy JTF_DATE_TABLE
1321: , p6_a3 out nocopy JTF_NUMBER_TABLE
1322: , x_return_status out nocopy VARCHAR2

Line 1321: , p6_a3 out nocopy JTF_NUMBER_TABLE

1317: , p_subinv_only number
1318: , p6_a0 out nocopy JTF_NUMBER_TABLE
1319: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1320: , p6_a2 out nocopy JTF_DATE_TABLE
1321: , p6_a3 out nocopy JTF_NUMBER_TABLE
1322: , x_return_status out nocopy VARCHAR2
1323: , x_msg_data out nocopy VARCHAR2
1324: , x_msg_count out nocopy NUMBER
1325: )

Line 1442: , p4_a0 JTF_NUMBER_TABLE

1438: , p0_a1 VARCHAR2
1439: , p_organization_id NUMBER
1440: , p_subinv_code VARCHAR2
1441: , p_need_by_date DATE
1442: , p4_a0 JTF_NUMBER_TABLE
1443: , p4_a1 JTF_VARCHAR2_TABLE_100
1444: , p4_a2 JTF_VARCHAR2_TABLE_100
1445: , p4_a3 JTF_NUMBER_TABLE
1446: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 1445: , p4_a3 JTF_NUMBER_TABLE

1441: , p_need_by_date DATE
1442: , p4_a0 JTF_NUMBER_TABLE
1443: , p4_a1 JTF_VARCHAR2_TABLE_100
1444: , p4_a2 JTF_VARCHAR2_TABLE_100
1445: , p4_a3 JTF_NUMBER_TABLE
1446: , p4_a4 JTF_VARCHAR2_TABLE_100
1447: , p4_a5 JTF_NUMBER_TABLE
1448: , p_timezone_id NUMBER
1449: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 1447: , p4_a5 JTF_NUMBER_TABLE

1443: , p4_a1 JTF_VARCHAR2_TABLE_100
1444: , p4_a2 JTF_VARCHAR2_TABLE_100
1445: , p4_a3 JTF_NUMBER_TABLE
1446: , p4_a4 JTF_VARCHAR2_TABLE_100
1447: , p4_a5 JTF_NUMBER_TABLE
1448: , p_timezone_id NUMBER
1449: , p6_a0 out nocopy JTF_NUMBER_TABLE
1450: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1451: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 1449: , p6_a0 out nocopy JTF_NUMBER_TABLE

1445: , p4_a3 JTF_NUMBER_TABLE
1446: , p4_a4 JTF_VARCHAR2_TABLE_100
1447: , p4_a5 JTF_NUMBER_TABLE
1448: , p_timezone_id NUMBER
1449: , p6_a0 out nocopy JTF_NUMBER_TABLE
1450: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1451: , p6_a2 out nocopy JTF_NUMBER_TABLE
1452: , p6_a3 out nocopy JTF_NUMBER_TABLE
1453: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1451: , p6_a2 out nocopy JTF_NUMBER_TABLE

1447: , p4_a5 JTF_NUMBER_TABLE
1448: , p_timezone_id NUMBER
1449: , p6_a0 out nocopy JTF_NUMBER_TABLE
1450: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1451: , p6_a2 out nocopy JTF_NUMBER_TABLE
1452: , p6_a3 out nocopy JTF_NUMBER_TABLE
1453: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1454: , p6_a5 out nocopy JTF_NUMBER_TABLE
1455: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 1452: , p6_a3 out nocopy JTF_NUMBER_TABLE

1448: , p_timezone_id NUMBER
1449: , p6_a0 out nocopy JTF_NUMBER_TABLE
1450: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1451: , p6_a2 out nocopy JTF_NUMBER_TABLE
1452: , p6_a3 out nocopy JTF_NUMBER_TABLE
1453: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1454: , p6_a5 out nocopy JTF_NUMBER_TABLE
1455: , p6_a6 out nocopy JTF_NUMBER_TABLE
1456: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 1454: , p6_a5 out nocopy JTF_NUMBER_TABLE

1450: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1451: , p6_a2 out nocopy JTF_NUMBER_TABLE
1452: , p6_a3 out nocopy JTF_NUMBER_TABLE
1453: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1454: , p6_a5 out nocopy JTF_NUMBER_TABLE
1455: , p6_a6 out nocopy JTF_NUMBER_TABLE
1456: , p6_a7 out nocopy JTF_NUMBER_TABLE
1457: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1458: , p6_a9 out nocopy JTF_DATE_TABLE

Line 1455: , p6_a6 out nocopy JTF_NUMBER_TABLE

1451: , p6_a2 out nocopy JTF_NUMBER_TABLE
1452: , p6_a3 out nocopy JTF_NUMBER_TABLE
1453: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1454: , p6_a5 out nocopy JTF_NUMBER_TABLE
1455: , p6_a6 out nocopy JTF_NUMBER_TABLE
1456: , p6_a7 out nocopy JTF_NUMBER_TABLE
1457: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1458: , p6_a9 out nocopy JTF_DATE_TABLE
1459: , p6_a10 out nocopy JTF_DATE_TABLE

Line 1456: , p6_a7 out nocopy JTF_NUMBER_TABLE

1452: , p6_a3 out nocopy JTF_NUMBER_TABLE
1453: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1454: , p6_a5 out nocopy JTF_NUMBER_TABLE
1455: , p6_a6 out nocopy JTF_NUMBER_TABLE
1456: , p6_a7 out nocopy JTF_NUMBER_TABLE
1457: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1458: , p6_a9 out nocopy JTF_DATE_TABLE
1459: , p6_a10 out nocopy JTF_DATE_TABLE
1460: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 1461: , p6_a12 out nocopy JTF_NUMBER_TABLE

1457: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1458: , p6_a9 out nocopy JTF_DATE_TABLE
1459: , p6_a10 out nocopy JTF_DATE_TABLE
1460: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1461: , p6_a12 out nocopy JTF_NUMBER_TABLE
1462: , p6_a13 out nocopy JTF_NUMBER_TABLE
1463: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1465: , x_return_status out nocopy VARCHAR2

Line 1462: , p6_a13 out nocopy JTF_NUMBER_TABLE

1458: , p6_a9 out nocopy JTF_DATE_TABLE
1459: , p6_a10 out nocopy JTF_DATE_TABLE
1460: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1461: , p6_a12 out nocopy JTF_NUMBER_TABLE
1462: , p6_a13 out nocopy JTF_NUMBER_TABLE
1463: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1464: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1465: , x_return_status out nocopy VARCHAR2
1466: , x_msg_data out nocopy VARCHAR2

Line 1589: , p0_a1 JTF_NUMBER_TABLE

1585: return ddrosetta_retval;
1586: end;
1587:
1588: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
1589: , p0_a1 JTF_NUMBER_TABLE
1590: , p0_a2 JTF_NUMBER_TABLE
1591: , p0_a3 JTF_VARCHAR2_TABLE_100
1592: , p0_a4 JTF_VARCHAR2_TABLE_100
1593: , p0_a5 JTF_VARCHAR2_TABLE_300

Line 1590: , p0_a2 JTF_NUMBER_TABLE

1586: end;
1587:
1588: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
1589: , p0_a1 JTF_NUMBER_TABLE
1590: , p0_a2 JTF_NUMBER_TABLE
1591: , p0_a3 JTF_VARCHAR2_TABLE_100
1592: , p0_a4 JTF_VARCHAR2_TABLE_100
1593: , p0_a5 JTF_VARCHAR2_TABLE_300
1594: , p1_a0 JTF_NUMBER_TABLE

Line 1594: , p1_a0 JTF_NUMBER_TABLE

1590: , p0_a2 JTF_NUMBER_TABLE
1591: , p0_a3 JTF_VARCHAR2_TABLE_100
1592: , p0_a4 JTF_VARCHAR2_TABLE_100
1593: , p0_a5 JTF_VARCHAR2_TABLE_300
1594: , p1_a0 JTF_NUMBER_TABLE
1595: , p1_a1 JTF_VARCHAR2_TABLE_100
1596: , p1_a2 JTF_VARCHAR2_TABLE_100
1597: , p1_a3 JTF_NUMBER_TABLE
1598: , p1_a4 JTF_VARCHAR2_TABLE_100

Line 1597: , p1_a3 JTF_NUMBER_TABLE

1593: , p0_a5 JTF_VARCHAR2_TABLE_300
1594: , p1_a0 JTF_NUMBER_TABLE
1595: , p1_a1 JTF_VARCHAR2_TABLE_100
1596: , p1_a2 JTF_VARCHAR2_TABLE_100
1597: , p1_a3 JTF_NUMBER_TABLE
1598: , p1_a4 JTF_VARCHAR2_TABLE_100
1599: , p1_a5 JTF_NUMBER_TABLE
1600: , p_include_alternate VARCHAR2
1601: , p3_a0 out nocopy JTF_NUMBER_TABLE

Line 1599: , p1_a5 JTF_NUMBER_TABLE

1595: , p1_a1 JTF_VARCHAR2_TABLE_100
1596: , p1_a2 JTF_VARCHAR2_TABLE_100
1597: , p1_a3 JTF_NUMBER_TABLE
1598: , p1_a4 JTF_VARCHAR2_TABLE_100
1599: , p1_a5 JTF_NUMBER_TABLE
1600: , p_include_alternate VARCHAR2
1601: , p3_a0 out nocopy JTF_NUMBER_TABLE
1602: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1603: , p3_a2 out nocopy JTF_NUMBER_TABLE

Line 1601: , p3_a0 out nocopy JTF_NUMBER_TABLE

1597: , p1_a3 JTF_NUMBER_TABLE
1598: , p1_a4 JTF_VARCHAR2_TABLE_100
1599: , p1_a5 JTF_NUMBER_TABLE
1600: , p_include_alternate VARCHAR2
1601: , p3_a0 out nocopy JTF_NUMBER_TABLE
1602: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1603: , p3_a2 out nocopy JTF_NUMBER_TABLE
1604: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1603: , p3_a2 out nocopy JTF_NUMBER_TABLE

1599: , p1_a5 JTF_NUMBER_TABLE
1600: , p_include_alternate VARCHAR2
1601: , p3_a0 out nocopy JTF_NUMBER_TABLE
1602: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1603: , p3_a2 out nocopy JTF_NUMBER_TABLE
1604: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1606: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1607: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 1607: , p3_a6 out nocopy JTF_NUMBER_TABLE

1603: , p3_a2 out nocopy JTF_NUMBER_TABLE
1604: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1605: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1606: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
1607: , p3_a6 out nocopy JTF_NUMBER_TABLE
1608: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1609: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1610: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p3_a10 out nocopy JTF_NUMBER_TABLE

Line 1611: , p3_a10 out nocopy JTF_NUMBER_TABLE

1607: , p3_a6 out nocopy JTF_NUMBER_TABLE
1608: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1609: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1610: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p3_a10 out nocopy JTF_NUMBER_TABLE
1612: , p3_a11 out nocopy JTF_NUMBER_TABLE
1613: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1614: , p3_a13 out nocopy JTF_NUMBER_TABLE
1615: , p3_a14 out nocopy JTF_NUMBER_TABLE

Line 1612: , p3_a11 out nocopy JTF_NUMBER_TABLE

1608: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
1609: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1610: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p3_a10 out nocopy JTF_NUMBER_TABLE
1612: , p3_a11 out nocopy JTF_NUMBER_TABLE
1613: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1614: , p3_a13 out nocopy JTF_NUMBER_TABLE
1615: , p3_a14 out nocopy JTF_NUMBER_TABLE
1616: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1614: , p3_a13 out nocopy JTF_NUMBER_TABLE

1610: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1611: , p3_a10 out nocopy JTF_NUMBER_TABLE
1612: , p3_a11 out nocopy JTF_NUMBER_TABLE
1613: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1614: , p3_a13 out nocopy JTF_NUMBER_TABLE
1615: , p3_a14 out nocopy JTF_NUMBER_TABLE
1616: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1618: , p3_a17 out nocopy JTF_DATE_TABLE

Line 1615: , p3_a14 out nocopy JTF_NUMBER_TABLE

1611: , p3_a10 out nocopy JTF_NUMBER_TABLE
1612: , p3_a11 out nocopy JTF_NUMBER_TABLE
1613: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1614: , p3_a13 out nocopy JTF_NUMBER_TABLE
1615: , p3_a14 out nocopy JTF_NUMBER_TABLE
1616: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1618: , p3_a17 out nocopy JTF_DATE_TABLE
1619: , p3_a18 out nocopy JTF_DATE_TABLE

Line 1698: , p2_a0 JTF_NUMBER_TABLE

1694: end;
1695:
1696: procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
1697: , p_resource_id NUMBER
1698: , p2_a0 JTF_NUMBER_TABLE
1699: , p2_a1 JTF_VARCHAR2_TABLE_100
1700: , p2_a2 JTF_VARCHAR2_TABLE_100
1701: , p2_a3 JTF_NUMBER_TABLE
1702: , p2_a4 JTF_VARCHAR2_TABLE_100

Line 1701: , p2_a3 JTF_NUMBER_TABLE

1697: , p_resource_id NUMBER
1698: , p2_a0 JTF_NUMBER_TABLE
1699: , p2_a1 JTF_VARCHAR2_TABLE_100
1700: , p2_a2 JTF_VARCHAR2_TABLE_100
1701: , p2_a3 JTF_NUMBER_TABLE
1702: , p2_a4 JTF_VARCHAR2_TABLE_100
1703: , p2_a5 JTF_NUMBER_TABLE
1704: , p_include_alternate VARCHAR2
1705: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 1703: , p2_a5 JTF_NUMBER_TABLE

1699: , p2_a1 JTF_VARCHAR2_TABLE_100
1700: , p2_a2 JTF_VARCHAR2_TABLE_100
1701: , p2_a3 JTF_NUMBER_TABLE
1702: , p2_a4 JTF_VARCHAR2_TABLE_100
1703: , p2_a5 JTF_NUMBER_TABLE
1704: , p_include_alternate VARCHAR2
1705: , p4_a0 out nocopy JTF_NUMBER_TABLE
1706: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1707: , p4_a2 out nocopy JTF_NUMBER_TABLE

Line 1705: , p4_a0 out nocopy JTF_NUMBER_TABLE

1701: , p2_a3 JTF_NUMBER_TABLE
1702: , p2_a4 JTF_VARCHAR2_TABLE_100
1703: , p2_a5 JTF_NUMBER_TABLE
1704: , p_include_alternate VARCHAR2
1705: , p4_a0 out nocopy JTF_NUMBER_TABLE
1706: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1707: , p4_a2 out nocopy JTF_NUMBER_TABLE
1708: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1709: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1707: , p4_a2 out nocopy JTF_NUMBER_TABLE

1703: , p2_a5 JTF_NUMBER_TABLE
1704: , p_include_alternate VARCHAR2
1705: , p4_a0 out nocopy JTF_NUMBER_TABLE
1706: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1707: , p4_a2 out nocopy JTF_NUMBER_TABLE
1708: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1709: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1710: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1711: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 1711: , p4_a6 out nocopy JTF_NUMBER_TABLE

1707: , p4_a2 out nocopy JTF_NUMBER_TABLE
1708: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1709: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1710: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1711: , p4_a6 out nocopy JTF_NUMBER_TABLE
1712: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1713: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1714: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1715: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 1715: , p4_a10 out nocopy JTF_NUMBER_TABLE

1711: , p4_a6 out nocopy JTF_NUMBER_TABLE
1712: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1713: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1714: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1715: , p4_a10 out nocopy JTF_NUMBER_TABLE
1716: , p4_a11 out nocopy JTF_NUMBER_TABLE
1717: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1718: , p4_a13 out nocopy JTF_NUMBER_TABLE
1719: , p4_a14 out nocopy JTF_NUMBER_TABLE

Line 1716: , p4_a11 out nocopy JTF_NUMBER_TABLE

1712: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1713: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1714: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1715: , p4_a10 out nocopy JTF_NUMBER_TABLE
1716: , p4_a11 out nocopy JTF_NUMBER_TABLE
1717: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1718: , p4_a13 out nocopy JTF_NUMBER_TABLE
1719: , p4_a14 out nocopy JTF_NUMBER_TABLE
1720: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1718: , p4_a13 out nocopy JTF_NUMBER_TABLE

1714: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1715: , p4_a10 out nocopy JTF_NUMBER_TABLE
1716: , p4_a11 out nocopy JTF_NUMBER_TABLE
1717: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1718: , p4_a13 out nocopy JTF_NUMBER_TABLE
1719: , p4_a14 out nocopy JTF_NUMBER_TABLE
1720: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1721: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1722: , p4_a17 out nocopy JTF_DATE_TABLE

Line 1719: , p4_a14 out nocopy JTF_NUMBER_TABLE

1715: , p4_a10 out nocopy JTF_NUMBER_TABLE
1716: , p4_a11 out nocopy JTF_NUMBER_TABLE
1717: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1718: , p4_a13 out nocopy JTF_NUMBER_TABLE
1719: , p4_a14 out nocopy JTF_NUMBER_TABLE
1720: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1721: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1722: , p4_a17 out nocopy JTF_DATE_TABLE
1723: , p4_a18 out nocopy JTF_DATE_TABLE

Line 1797: , p2_a0 JTF_NUMBER_TABLE

1793: end;
1794:
1795: procedure ws_check_organizations(p_resource_type VARCHAR2
1796: , p_resource_id NUMBER
1797: , p2_a0 JTF_NUMBER_TABLE
1798: , p2_a1 JTF_VARCHAR2_TABLE_100
1799: , p2_a2 JTF_VARCHAR2_TABLE_100
1800: , p2_a3 JTF_NUMBER_TABLE
1801: , p2_a4 JTF_VARCHAR2_TABLE_100

Line 1800: , p2_a3 JTF_NUMBER_TABLE

1796: , p_resource_id NUMBER
1797: , p2_a0 JTF_NUMBER_TABLE
1798: , p2_a1 JTF_VARCHAR2_TABLE_100
1799: , p2_a2 JTF_VARCHAR2_TABLE_100
1800: , p2_a3 JTF_NUMBER_TABLE
1801: , p2_a4 JTF_VARCHAR2_TABLE_100
1802: , p2_a5 JTF_NUMBER_TABLE
1803: , p_include_alternate VARCHAR2
1804: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 1802: , p2_a5 JTF_NUMBER_TABLE

1798: , p2_a1 JTF_VARCHAR2_TABLE_100
1799: , p2_a2 JTF_VARCHAR2_TABLE_100
1800: , p2_a3 JTF_NUMBER_TABLE
1801: , p2_a4 JTF_VARCHAR2_TABLE_100
1802: , p2_a5 JTF_NUMBER_TABLE
1803: , p_include_alternate VARCHAR2
1804: , p4_a0 out nocopy JTF_NUMBER_TABLE
1805: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1806: , p4_a2 out nocopy JTF_NUMBER_TABLE

Line 1804: , p4_a0 out nocopy JTF_NUMBER_TABLE

1800: , p2_a3 JTF_NUMBER_TABLE
1801: , p2_a4 JTF_VARCHAR2_TABLE_100
1802: , p2_a5 JTF_NUMBER_TABLE
1803: , p_include_alternate VARCHAR2
1804: , p4_a0 out nocopy JTF_NUMBER_TABLE
1805: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1806: , p4_a2 out nocopy JTF_NUMBER_TABLE
1807: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1808: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1806: , p4_a2 out nocopy JTF_NUMBER_TABLE

1802: , p2_a5 JTF_NUMBER_TABLE
1803: , p_include_alternate VARCHAR2
1804: , p4_a0 out nocopy JTF_NUMBER_TABLE
1805: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1806: , p4_a2 out nocopy JTF_NUMBER_TABLE
1807: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1808: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1809: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1810: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 1810: , p4_a6 out nocopy JTF_NUMBER_TABLE

1806: , p4_a2 out nocopy JTF_NUMBER_TABLE
1807: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1808: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
1809: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1810: , p4_a6 out nocopy JTF_NUMBER_TABLE
1811: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1812: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1813: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1814: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 1814: , p4_a10 out nocopy JTF_NUMBER_TABLE

1810: , p4_a6 out nocopy JTF_NUMBER_TABLE
1811: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1812: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1813: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1814: , p4_a10 out nocopy JTF_NUMBER_TABLE
1815: , p4_a11 out nocopy JTF_NUMBER_TABLE
1816: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1817: , p4_a13 out nocopy JTF_NUMBER_TABLE
1818: , p4_a14 out nocopy JTF_NUMBER_TABLE

Line 1815: , p4_a11 out nocopy JTF_NUMBER_TABLE

1811: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
1812: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1813: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1814: , p4_a10 out nocopy JTF_NUMBER_TABLE
1815: , p4_a11 out nocopy JTF_NUMBER_TABLE
1816: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1817: , p4_a13 out nocopy JTF_NUMBER_TABLE
1818: , p4_a14 out nocopy JTF_NUMBER_TABLE
1819: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1817: , p4_a13 out nocopy JTF_NUMBER_TABLE

1813: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1814: , p4_a10 out nocopy JTF_NUMBER_TABLE
1815: , p4_a11 out nocopy JTF_NUMBER_TABLE
1816: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1817: , p4_a13 out nocopy JTF_NUMBER_TABLE
1818: , p4_a14 out nocopy JTF_NUMBER_TABLE
1819: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1820: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1821: , p4_a17 out nocopy JTF_DATE_TABLE

Line 1818: , p4_a14 out nocopy JTF_NUMBER_TABLE

1814: , p4_a10 out nocopy JTF_NUMBER_TABLE
1815: , p4_a11 out nocopy JTF_NUMBER_TABLE
1816: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1817: , p4_a13 out nocopy JTF_NUMBER_TABLE
1818: , p4_a14 out nocopy JTF_NUMBER_TABLE
1819: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
1820: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1821: , p4_a17 out nocopy JTF_DATE_TABLE
1822: , p4_a18 out nocopy JTF_DATE_TABLE

Line 1901: , p2_a0 in out nocopy JTF_NUMBER_TABLE

1897: , p0_a3 NUMBER
1898: , p0_a4 VARCHAR2
1899: , p0_a5 NUMBER
1900: , p_org_id NUMBER
1901: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1902: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1903: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1904: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1905: , p2_a4 in out nocopy JTF_NUMBER_TABLE

Line 1904: , p2_a3 in out nocopy JTF_NUMBER_TABLE

1900: , p_org_id NUMBER
1901: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1902: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1903: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1904: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1905: , p2_a4 in out nocopy JTF_NUMBER_TABLE
1906: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1907: , p2_a6 in out nocopy JTF_NUMBER_TABLE
1908: , p2_a7 in out nocopy JTF_NUMBER_TABLE

Line 1905: , p2_a4 in out nocopy JTF_NUMBER_TABLE

1901: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1902: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1903: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1904: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1905: , p2_a4 in out nocopy JTF_NUMBER_TABLE
1906: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1907: , p2_a6 in out nocopy JTF_NUMBER_TABLE
1908: , p2_a7 in out nocopy JTF_NUMBER_TABLE
1909: , x_return_status out nocopy VARCHAR2

Line 1907: , p2_a6 in out nocopy JTF_NUMBER_TABLE

1903: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1904: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1905: , p2_a4 in out nocopy JTF_NUMBER_TABLE
1906: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1907: , p2_a6 in out nocopy JTF_NUMBER_TABLE
1908: , p2_a7 in out nocopy JTF_NUMBER_TABLE
1909: , x_return_status out nocopy VARCHAR2
1910: , x_msg_data out nocopy VARCHAR2
1911: , x_msg_count out nocopy NUMBER

Line 1908: , p2_a7 in out nocopy JTF_NUMBER_TABLE

1904: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1905: , p2_a4 in out nocopy JTF_NUMBER_TABLE
1906: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1907: , p2_a6 in out nocopy JTF_NUMBER_TABLE
1908: , p2_a7 in out nocopy JTF_NUMBER_TABLE
1909: , x_return_status out nocopy VARCHAR2
1910: , x_msg_data out nocopy VARCHAR2
1911: , x_msg_count out nocopy NUMBER
1912: )