APPS.CSP_PARTS_REQUIREMENT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_300

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_NUMBER_TABLE

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

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100

Line 28: , a6 JTF_NUMBER_TABLE

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

Line 31: , a9 JTF_NUMBER_TABLE

27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE

Line 35: , a13 JTF_NUMBER_TABLE

31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_DATE_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_NUMBER_TABLE

Line 36: , a14 JTF_NUMBER_TABLE

32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_DATE_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE

Line 39: , a17 JTF_NUMBER_TABLE

35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_DATE_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100

Line 40: , a18 JTF_NUMBER_TABLE

36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_DATE_TABLE
38: , a16 JTF_DATE_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_NUMBER_TABLE
41: , a19 JTF_VARCHAR2_TABLE_100
42: , a20 JTF_VARCHAR2_TABLE_100
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_VARCHAR2_TABLE_100

Line 119: procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

115: end loop;
116: end if;
117: end if;
118: end rosetta_table_copy_in_p2;
119: procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_NUMBER_TABLE
123: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 120: , a1 out nocopy JTF_NUMBER_TABLE

116: end if;
117: end if;
118: end rosetta_table_copy_in_p2;
119: procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_NUMBER_TABLE
123: , a4 out nocopy JTF_VARCHAR2_TABLE_300
124: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 121: , a2 out nocopy JTF_NUMBER_TABLE

117: end if;
118: end rosetta_table_copy_in_p2;
119: procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_NUMBER_TABLE
123: , a4 out nocopy JTF_VARCHAR2_TABLE_300
124: , a5 out nocopy JTF_VARCHAR2_TABLE_100
125: , a6 out nocopy JTF_NUMBER_TABLE

Line 122: , a3 out nocopy JTF_NUMBER_TABLE

118: end rosetta_table_copy_in_p2;
119: procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_NUMBER_TABLE
123: , a4 out nocopy JTF_VARCHAR2_TABLE_300
124: , a5 out nocopy JTF_VARCHAR2_TABLE_100
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 125: , a6 out nocopy JTF_NUMBER_TABLE

121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_NUMBER_TABLE
123: , a4 out nocopy JTF_VARCHAR2_TABLE_300
124: , a5 out nocopy JTF_VARCHAR2_TABLE_100
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 128: , a9 out nocopy JTF_NUMBER_TABLE

124: , a5 out nocopy JTF_VARCHAR2_TABLE_100
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , a8 out nocopy JTF_VARCHAR2_TABLE_100
128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , a11 out nocopy JTF_VARCHAR2_TABLE_100
131: , a12 out nocopy JTF_VARCHAR2_TABLE_100
132: , a13 out nocopy JTF_NUMBER_TABLE

Line 132: , a13 out nocopy JTF_NUMBER_TABLE

128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , a11 out nocopy JTF_VARCHAR2_TABLE_100
131: , a12 out nocopy JTF_VARCHAR2_TABLE_100
132: , a13 out nocopy JTF_NUMBER_TABLE
133: , a14 out nocopy JTF_NUMBER_TABLE
134: , a15 out nocopy JTF_DATE_TABLE
135: , a16 out nocopy JTF_DATE_TABLE
136: , a17 out nocopy JTF_NUMBER_TABLE

Line 133: , a14 out nocopy JTF_NUMBER_TABLE

129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , a11 out nocopy JTF_VARCHAR2_TABLE_100
131: , a12 out nocopy JTF_VARCHAR2_TABLE_100
132: , a13 out nocopy JTF_NUMBER_TABLE
133: , a14 out nocopy JTF_NUMBER_TABLE
134: , a15 out nocopy JTF_DATE_TABLE
135: , a16 out nocopy JTF_DATE_TABLE
136: , a17 out nocopy JTF_NUMBER_TABLE
137: , a18 out nocopy JTF_NUMBER_TABLE

Line 136: , a17 out nocopy JTF_NUMBER_TABLE

132: , a13 out nocopy JTF_NUMBER_TABLE
133: , a14 out nocopy JTF_NUMBER_TABLE
134: , a15 out nocopy JTF_DATE_TABLE
135: , a16 out nocopy JTF_DATE_TABLE
136: , a17 out nocopy JTF_NUMBER_TABLE
137: , a18 out nocopy JTF_NUMBER_TABLE
138: , a19 out nocopy JTF_VARCHAR2_TABLE_100
139: , a20 out nocopy JTF_VARCHAR2_TABLE_100
140: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 137: , a18 out nocopy JTF_NUMBER_TABLE

133: , a14 out nocopy JTF_NUMBER_TABLE
134: , a15 out nocopy JTF_DATE_TABLE
135: , a16 out nocopy JTF_DATE_TABLE
136: , a17 out nocopy JTF_NUMBER_TABLE
137: , a18 out nocopy JTF_NUMBER_TABLE
138: , a19 out nocopy JTF_VARCHAR2_TABLE_100
139: , a20 out nocopy JTF_VARCHAR2_TABLE_100
140: , a21 out nocopy JTF_VARCHAR2_TABLE_100
141: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 163: a0 := JTF_NUMBER_TABLE();

159: ) as
160: ddindx binary_integer; indx binary_integer;
161: begin
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_VARCHAR2_TABLE_300();

Line 164: a1 := JTF_NUMBER_TABLE();

160: ddindx binary_integer; indx binary_integer;
161: begin
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_VARCHAR2_TABLE_300();
168: a5 := JTF_VARCHAR2_TABLE_100();

Line 165: a2 := JTF_NUMBER_TABLE();

161: begin
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_VARCHAR2_TABLE_300();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_NUMBER_TABLE();

Line 166: a3 := JTF_NUMBER_TABLE();

162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_VARCHAR2_TABLE_300();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_NUMBER_TABLE();
170: a7 := JTF_VARCHAR2_TABLE_100();

Line 169: a6 := JTF_NUMBER_TABLE();

165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_NUMBER_TABLE();
167: a4 := JTF_VARCHAR2_TABLE_300();
168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_NUMBER_TABLE();
170: a7 := JTF_VARCHAR2_TABLE_100();
171: a8 := JTF_VARCHAR2_TABLE_100();
172: a9 := JTF_NUMBER_TABLE();
173: a10 := JTF_VARCHAR2_TABLE_100();

Line 172: a9 := JTF_NUMBER_TABLE();

168: a5 := JTF_VARCHAR2_TABLE_100();
169: a6 := JTF_NUMBER_TABLE();
170: a7 := JTF_VARCHAR2_TABLE_100();
171: a8 := JTF_VARCHAR2_TABLE_100();
172: a9 := JTF_NUMBER_TABLE();
173: a10 := JTF_VARCHAR2_TABLE_100();
174: a11 := JTF_VARCHAR2_TABLE_100();
175: a12 := JTF_VARCHAR2_TABLE_100();
176: a13 := JTF_NUMBER_TABLE();

Line 176: a13 := JTF_NUMBER_TABLE();

172: a9 := JTF_NUMBER_TABLE();
173: a10 := JTF_VARCHAR2_TABLE_100();
174: a11 := JTF_VARCHAR2_TABLE_100();
175: a12 := JTF_VARCHAR2_TABLE_100();
176: a13 := JTF_NUMBER_TABLE();
177: a14 := JTF_NUMBER_TABLE();
178: a15 := JTF_DATE_TABLE();
179: a16 := JTF_DATE_TABLE();
180: a17 := JTF_NUMBER_TABLE();

Line 177: a14 := JTF_NUMBER_TABLE();

173: a10 := JTF_VARCHAR2_TABLE_100();
174: a11 := JTF_VARCHAR2_TABLE_100();
175: a12 := JTF_VARCHAR2_TABLE_100();
176: a13 := JTF_NUMBER_TABLE();
177: a14 := JTF_NUMBER_TABLE();
178: a15 := JTF_DATE_TABLE();
179: a16 := JTF_DATE_TABLE();
180: a17 := JTF_NUMBER_TABLE();
181: a18 := JTF_NUMBER_TABLE();

Line 180: a17 := JTF_NUMBER_TABLE();

176: a13 := JTF_NUMBER_TABLE();
177: a14 := JTF_NUMBER_TABLE();
178: a15 := JTF_DATE_TABLE();
179: a16 := JTF_DATE_TABLE();
180: a17 := JTF_NUMBER_TABLE();
181: a18 := JTF_NUMBER_TABLE();
182: a19 := JTF_VARCHAR2_TABLE_100();
183: a20 := JTF_VARCHAR2_TABLE_100();
184: a21 := JTF_VARCHAR2_TABLE_100();

Line 181: a18 := JTF_NUMBER_TABLE();

177: a14 := JTF_NUMBER_TABLE();
178: a15 := JTF_DATE_TABLE();
179: a16 := JTF_DATE_TABLE();
180: a17 := JTF_NUMBER_TABLE();
181: a18 := JTF_NUMBER_TABLE();
182: a19 := JTF_VARCHAR2_TABLE_100();
183: a20 := JTF_VARCHAR2_TABLE_100();
184: a21 := JTF_VARCHAR2_TABLE_100();
185: a22 := JTF_VARCHAR2_TABLE_100();

Line 204: a0 := JTF_NUMBER_TABLE();

200: a37 := JTF_VARCHAR2_TABLE_200();
201: a38 := JTF_VARCHAR2_TABLE_200();
202: a39 := JTF_VARCHAR2_TABLE_200();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_NUMBER_TABLE();
207: a3 := JTF_NUMBER_TABLE();
208: a4 := JTF_VARCHAR2_TABLE_300();

Line 205: a1 := JTF_NUMBER_TABLE();

201: a38 := JTF_VARCHAR2_TABLE_200();
202: a39 := JTF_VARCHAR2_TABLE_200();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_NUMBER_TABLE();
207: a3 := JTF_NUMBER_TABLE();
208: a4 := JTF_VARCHAR2_TABLE_300();
209: a5 := JTF_VARCHAR2_TABLE_100();

Line 206: a2 := JTF_NUMBER_TABLE();

202: a39 := JTF_VARCHAR2_TABLE_200();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_NUMBER_TABLE();
207: a3 := JTF_NUMBER_TABLE();
208: a4 := JTF_VARCHAR2_TABLE_300();
209: a5 := JTF_VARCHAR2_TABLE_100();
210: a6 := JTF_NUMBER_TABLE();

Line 207: a3 := JTF_NUMBER_TABLE();

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

Line 210: a6 := JTF_NUMBER_TABLE();

206: a2 := JTF_NUMBER_TABLE();
207: a3 := JTF_NUMBER_TABLE();
208: a4 := JTF_VARCHAR2_TABLE_300();
209: a5 := JTF_VARCHAR2_TABLE_100();
210: a6 := JTF_NUMBER_TABLE();
211: a7 := JTF_VARCHAR2_TABLE_100();
212: a8 := JTF_VARCHAR2_TABLE_100();
213: a9 := JTF_NUMBER_TABLE();
214: a10 := JTF_VARCHAR2_TABLE_100();

Line 213: a9 := JTF_NUMBER_TABLE();

209: a5 := JTF_VARCHAR2_TABLE_100();
210: a6 := JTF_NUMBER_TABLE();
211: a7 := JTF_VARCHAR2_TABLE_100();
212: a8 := JTF_VARCHAR2_TABLE_100();
213: a9 := JTF_NUMBER_TABLE();
214: a10 := JTF_VARCHAR2_TABLE_100();
215: a11 := JTF_VARCHAR2_TABLE_100();
216: a12 := JTF_VARCHAR2_TABLE_100();
217: a13 := JTF_NUMBER_TABLE();

Line 217: a13 := JTF_NUMBER_TABLE();

213: a9 := JTF_NUMBER_TABLE();
214: a10 := JTF_VARCHAR2_TABLE_100();
215: a11 := JTF_VARCHAR2_TABLE_100();
216: a12 := JTF_VARCHAR2_TABLE_100();
217: a13 := JTF_NUMBER_TABLE();
218: a14 := JTF_NUMBER_TABLE();
219: a15 := JTF_DATE_TABLE();
220: a16 := JTF_DATE_TABLE();
221: a17 := JTF_NUMBER_TABLE();

Line 218: a14 := JTF_NUMBER_TABLE();

214: a10 := JTF_VARCHAR2_TABLE_100();
215: a11 := JTF_VARCHAR2_TABLE_100();
216: a12 := JTF_VARCHAR2_TABLE_100();
217: a13 := JTF_NUMBER_TABLE();
218: a14 := JTF_NUMBER_TABLE();
219: a15 := JTF_DATE_TABLE();
220: a16 := JTF_DATE_TABLE();
221: a17 := JTF_NUMBER_TABLE();
222: a18 := JTF_NUMBER_TABLE();

Line 221: a17 := JTF_NUMBER_TABLE();

217: a13 := JTF_NUMBER_TABLE();
218: a14 := JTF_NUMBER_TABLE();
219: a15 := JTF_DATE_TABLE();
220: a16 := JTF_DATE_TABLE();
221: a17 := JTF_NUMBER_TABLE();
222: a18 := JTF_NUMBER_TABLE();
223: a19 := JTF_VARCHAR2_TABLE_100();
224: a20 := JTF_VARCHAR2_TABLE_100();
225: a21 := JTF_VARCHAR2_TABLE_100();

Line 222: a18 := JTF_NUMBER_TABLE();

218: a14 := JTF_NUMBER_TABLE();
219: a15 := JTF_DATE_TABLE();
220: a16 := JTF_DATE_TABLE();
221: a17 := JTF_NUMBER_TABLE();
222: a18 := JTF_NUMBER_TABLE();
223: a19 := JTF_VARCHAR2_TABLE_100();
224: a20 := JTF_VARCHAR2_TABLE_100();
225: a21 := JTF_VARCHAR2_TABLE_100();
226: a22 := JTF_VARCHAR2_TABLE_100();

Line 338: procedure rosetta_table_copy_in_p4(t out nocopy csp_parts_requirement.line_detail_tbl_type, a0 JTF_NUMBER_TABLE

334: end if;
335: end if;
336: end rosetta_table_copy_out_p2;
337:
338: procedure rosetta_table_copy_in_p4(t out nocopy csp_parts_requirement.line_detail_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_VARCHAR2_TABLE_100
341: , a3 JTF_NUMBER_TABLE
342: ) as

Line 339: , a1 JTF_NUMBER_TABLE

335: end if;
336: end rosetta_table_copy_out_p2;
337:
338: procedure rosetta_table_copy_in_p4(t out nocopy csp_parts_requirement.line_detail_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_VARCHAR2_TABLE_100
341: , a3 JTF_NUMBER_TABLE
342: ) as
343: ddindx binary_integer; indx binary_integer;

Line 341: , a3 JTF_NUMBER_TABLE

337:
338: procedure rosetta_table_copy_in_p4(t out nocopy csp_parts_requirement.line_detail_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_VARCHAR2_TABLE_100
341: , a3 JTF_NUMBER_TABLE
342: ) as
343: ddindx binary_integer; indx binary_integer;
344: begin
345: if a0 is not null and a0.count > 0 then

Line 363: procedure rosetta_table_copy_out_p4(t csp_parts_requirement.line_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

359: end loop;
360: end if;
361: end if;
362: end rosetta_table_copy_in_p4;
363: procedure rosetta_table_copy_out_p4(t csp_parts_requirement.line_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_NUMBER_TABLE
365: , a2 out nocopy JTF_VARCHAR2_TABLE_100
366: , a3 out nocopy JTF_NUMBER_TABLE
367: ) as

Line 364: , a1 out nocopy JTF_NUMBER_TABLE

360: end if;
361: end if;
362: end rosetta_table_copy_in_p4;
363: procedure rosetta_table_copy_out_p4(t csp_parts_requirement.line_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_NUMBER_TABLE
365: , a2 out nocopy JTF_VARCHAR2_TABLE_100
366: , a3 out nocopy JTF_NUMBER_TABLE
367: ) as
368: ddindx binary_integer; indx binary_integer;

Line 366: , a3 out nocopy JTF_NUMBER_TABLE

362: end rosetta_table_copy_in_p4;
363: procedure rosetta_table_copy_out_p4(t csp_parts_requirement.line_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_NUMBER_TABLE
365: , a2 out nocopy JTF_VARCHAR2_TABLE_100
366: , a3 out nocopy JTF_NUMBER_TABLE
367: ) as
368: ddindx binary_integer; indx binary_integer;
369: begin
370: if t is null or t.count = 0 then

Line 371: a0 := JTF_NUMBER_TABLE();

367: ) as
368: ddindx binary_integer; indx binary_integer;
369: begin
370: if t is null or t.count = 0 then
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_NUMBER_TABLE();
373: a2 := JTF_VARCHAR2_TABLE_100();
374: a3 := JTF_NUMBER_TABLE();
375: else

Line 372: a1 := JTF_NUMBER_TABLE();

368: ddindx binary_integer; indx binary_integer;
369: begin
370: if t is null or t.count = 0 then
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_NUMBER_TABLE();
373: a2 := JTF_VARCHAR2_TABLE_100();
374: a3 := JTF_NUMBER_TABLE();
375: else
376: a0 := JTF_NUMBER_TABLE();

Line 374: a3 := JTF_NUMBER_TABLE();

370: if t is null or t.count = 0 then
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_NUMBER_TABLE();
373: a2 := JTF_VARCHAR2_TABLE_100();
374: a3 := JTF_NUMBER_TABLE();
375: else
376: a0 := JTF_NUMBER_TABLE();
377: a1 := JTF_NUMBER_TABLE();
378: a2 := JTF_VARCHAR2_TABLE_100();

Line 376: a0 := JTF_NUMBER_TABLE();

372: a1 := JTF_NUMBER_TABLE();
373: a2 := JTF_VARCHAR2_TABLE_100();
374: a3 := JTF_NUMBER_TABLE();
375: else
376: a0 := JTF_NUMBER_TABLE();
377: a1 := JTF_NUMBER_TABLE();
378: a2 := JTF_VARCHAR2_TABLE_100();
379: a3 := JTF_NUMBER_TABLE();
380: if t.count > 0 then

Line 377: a1 := JTF_NUMBER_TABLE();

373: a2 := JTF_VARCHAR2_TABLE_100();
374: a3 := JTF_NUMBER_TABLE();
375: else
376: a0 := JTF_NUMBER_TABLE();
377: a1 := JTF_NUMBER_TABLE();
378: a2 := JTF_VARCHAR2_TABLE_100();
379: a3 := JTF_NUMBER_TABLE();
380: if t.count > 0 then
381: a0.extend(t.count);

Line 379: a3 := JTF_NUMBER_TABLE();

375: else
376: a0 := JTF_NUMBER_TABLE();
377: a1 := JTF_NUMBER_TABLE();
378: a2 := JTF_VARCHAR2_TABLE_100();
379: a3 := JTF_NUMBER_TABLE();
380: if t.count > 0 then
381: a0.extend(t.count);
382: a1.extend(t.count);
383: a2.extend(t.count);

Line 402: procedure rosetta_table_copy_in_p6(t out nocopy csp_parts_requirement.rqmt_line_tbl_type, a0 JTF_NUMBER_TABLE

398: end if;
399: end if;
400: end rosetta_table_copy_out_p4;
401:
402: procedure rosetta_table_copy_in_p6(t out nocopy csp_parts_requirement.rqmt_line_tbl_type, a0 JTF_NUMBER_TABLE
403: ) as
404: ddindx binary_integer; indx binary_integer;
405: begin
406: if a0 is not null and a0.count > 0 then

Line 421: procedure rosetta_table_copy_out_p6(t csp_parts_requirement.rqmt_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

417: end loop;
418: end if;
419: end if;
420: end rosetta_table_copy_in_p6;
421: procedure rosetta_table_copy_out_p6(t csp_parts_requirement.rqmt_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
422: ) as
423: ddindx binary_integer; indx binary_integer;
424: begin
425: if t is null or t.count = 0 then

Line 426: a0 := JTF_NUMBER_TABLE();

422: ) as
423: ddindx binary_integer; indx binary_integer;
424: begin
425: if t is null or t.count = 0 then
426: a0 := JTF_NUMBER_TABLE();
427: else
428: a0 := JTF_NUMBER_TABLE();
429: if t.count > 0 then
430: a0.extend(t.count);

Line 428: a0 := JTF_NUMBER_TABLE();

424: begin
425: if t is null or t.count = 0 then
426: a0 := JTF_NUMBER_TABLE();
427: else
428: a0 := JTF_NUMBER_TABLE();
429: if t.count > 0 then
430: a0.extend(t.count);
431: ddindx := t.first;
432: indx := 1;

Line 446: , a1 JTF_NUMBER_TABLE

442: end if;
443: end rosetta_table_copy_out_p6;
444:
445: procedure rosetta_table_copy_in_p8(t out nocopy csp_parts_requirement.order_tbl_type, a0 JTF_VARCHAR2_TABLE_100
446: , a1 JTF_NUMBER_TABLE
447: ) as
448: ddindx binary_integer; indx binary_integer;
449: begin
450: if a0 is not null and a0.count > 0 then

Line 467: , a1 out nocopy JTF_NUMBER_TABLE

463: end if;
464: end if;
465: end rosetta_table_copy_in_p8;
466: procedure rosetta_table_copy_out_p8(t csp_parts_requirement.order_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
467: , a1 out nocopy JTF_NUMBER_TABLE
468: ) as
469: ddindx binary_integer; indx binary_integer;
470: begin
471: if t is null or t.count = 0 then

Line 473: a1 := JTF_NUMBER_TABLE();

469: ddindx binary_integer; indx binary_integer;
470: begin
471: if t is null or t.count = 0 then
472: a0 := JTF_VARCHAR2_TABLE_100();
473: a1 := JTF_NUMBER_TABLE();
474: else
475: a0 := JTF_VARCHAR2_TABLE_100();
476: a1 := JTF_NUMBER_TABLE();
477: if t.count > 0 then

Line 476: a1 := JTF_NUMBER_TABLE();

472: a0 := JTF_VARCHAR2_TABLE_100();
473: a1 := JTF_NUMBER_TABLE();
474: else
475: a0 := JTF_VARCHAR2_TABLE_100();
476: a1 := JTF_NUMBER_TABLE();
477: if t.count > 0 then
478: a0.extend(t.count);
479: a1.extend(t.count);
480: ddindx := t.first;

Line 534: , p4_a0 in out nocopy JTF_NUMBER_TABLE

530: , p3_a32 in out nocopy VARCHAR2
531: , p3_a33 in out nocopy VARCHAR2
532: , p3_a34 in out nocopy VARCHAR2
533: , p3_a35 in out nocopy VARCHAR2
534: , p4_a0 in out nocopy JTF_NUMBER_TABLE
535: , p4_a1 in out nocopy JTF_NUMBER_TABLE
536: , p4_a2 in out nocopy JTF_NUMBER_TABLE
537: , p4_a3 in out nocopy JTF_NUMBER_TABLE
538: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300

Line 535: , p4_a1 in out nocopy JTF_NUMBER_TABLE

531: , p3_a33 in out nocopy VARCHAR2
532: , p3_a34 in out nocopy VARCHAR2
533: , p3_a35 in out nocopy VARCHAR2
534: , p4_a0 in out nocopy JTF_NUMBER_TABLE
535: , p4_a1 in out nocopy JTF_NUMBER_TABLE
536: , p4_a2 in out nocopy JTF_NUMBER_TABLE
537: , p4_a3 in out nocopy JTF_NUMBER_TABLE
538: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
539: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 536: , p4_a2 in out nocopy JTF_NUMBER_TABLE

532: , p3_a34 in out nocopy VARCHAR2
533: , p3_a35 in out nocopy VARCHAR2
534: , p4_a0 in out nocopy JTF_NUMBER_TABLE
535: , p4_a1 in out nocopy JTF_NUMBER_TABLE
536: , p4_a2 in out nocopy JTF_NUMBER_TABLE
537: , p4_a3 in out nocopy JTF_NUMBER_TABLE
538: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
539: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
540: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 537: , p4_a3 in out nocopy JTF_NUMBER_TABLE

533: , p3_a35 in out nocopy VARCHAR2
534: , p4_a0 in out nocopy JTF_NUMBER_TABLE
535: , p4_a1 in out nocopy JTF_NUMBER_TABLE
536: , p4_a2 in out nocopy JTF_NUMBER_TABLE
537: , p4_a3 in out nocopy JTF_NUMBER_TABLE
538: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
539: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
540: , p4_a6 in out nocopy JTF_NUMBER_TABLE
541: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 540: , p4_a6 in out nocopy JTF_NUMBER_TABLE

536: , p4_a2 in out nocopy JTF_NUMBER_TABLE
537: , p4_a3 in out nocopy JTF_NUMBER_TABLE
538: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
539: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
540: , p4_a6 in out nocopy JTF_NUMBER_TABLE
541: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
542: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
543: , p4_a9 in out nocopy JTF_NUMBER_TABLE
544: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 543: , p4_a9 in out nocopy JTF_NUMBER_TABLE

539: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
540: , p4_a6 in out nocopy JTF_NUMBER_TABLE
541: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
542: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
543: , p4_a9 in out nocopy JTF_NUMBER_TABLE
544: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
546: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
547: , p4_a13 in out nocopy JTF_NUMBER_TABLE

Line 547: , p4_a13 in out nocopy JTF_NUMBER_TABLE

543: , p4_a9 in out nocopy JTF_NUMBER_TABLE
544: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
546: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
547: , p4_a13 in out nocopy JTF_NUMBER_TABLE
548: , p4_a14 in out nocopy JTF_NUMBER_TABLE
549: , p4_a15 in out nocopy JTF_DATE_TABLE
550: , p4_a16 in out nocopy JTF_DATE_TABLE
551: , p4_a17 in out nocopy JTF_NUMBER_TABLE

Line 548: , p4_a14 in out nocopy JTF_NUMBER_TABLE

544: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
546: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
547: , p4_a13 in out nocopy JTF_NUMBER_TABLE
548: , p4_a14 in out nocopy JTF_NUMBER_TABLE
549: , p4_a15 in out nocopy JTF_DATE_TABLE
550: , p4_a16 in out nocopy JTF_DATE_TABLE
551: , p4_a17 in out nocopy JTF_NUMBER_TABLE
552: , p4_a18 in out nocopy JTF_NUMBER_TABLE

Line 551: , p4_a17 in out nocopy JTF_NUMBER_TABLE

547: , p4_a13 in out nocopy JTF_NUMBER_TABLE
548: , p4_a14 in out nocopy JTF_NUMBER_TABLE
549: , p4_a15 in out nocopy JTF_DATE_TABLE
550: , p4_a16 in out nocopy JTF_DATE_TABLE
551: , p4_a17 in out nocopy JTF_NUMBER_TABLE
552: , p4_a18 in out nocopy JTF_NUMBER_TABLE
553: , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
554: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
555: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100

Line 552: , p4_a18 in out nocopy JTF_NUMBER_TABLE

548: , p4_a14 in out nocopy JTF_NUMBER_TABLE
549: , p4_a15 in out nocopy JTF_DATE_TABLE
550: , p4_a16 in out nocopy JTF_DATE_TABLE
551: , p4_a17 in out nocopy JTF_NUMBER_TABLE
552: , p4_a18 in out nocopy JTF_NUMBER_TABLE
553: , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
554: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
555: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100

Line 811: , p4_a0 in out nocopy JTF_NUMBER_TABLE

807: , p3_a32 in out nocopy VARCHAR2
808: , p3_a33 in out nocopy VARCHAR2
809: , p3_a34 in out nocopy VARCHAR2
810: , p3_a35 in out nocopy VARCHAR2
811: , p4_a0 in out nocopy JTF_NUMBER_TABLE
812: , p4_a1 in out nocopy JTF_NUMBER_TABLE
813: , p4_a2 in out nocopy JTF_NUMBER_TABLE
814: , p4_a3 in out nocopy JTF_NUMBER_TABLE
815: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300

Line 812: , p4_a1 in out nocopy JTF_NUMBER_TABLE

808: , p3_a33 in out nocopy VARCHAR2
809: , p3_a34 in out nocopy VARCHAR2
810: , p3_a35 in out nocopy VARCHAR2
811: , p4_a0 in out nocopy JTF_NUMBER_TABLE
812: , p4_a1 in out nocopy JTF_NUMBER_TABLE
813: , p4_a2 in out nocopy JTF_NUMBER_TABLE
814: , p4_a3 in out nocopy JTF_NUMBER_TABLE
815: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
816: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 813: , p4_a2 in out nocopy JTF_NUMBER_TABLE

809: , p3_a34 in out nocopy VARCHAR2
810: , p3_a35 in out nocopy VARCHAR2
811: , p4_a0 in out nocopy JTF_NUMBER_TABLE
812: , p4_a1 in out nocopy JTF_NUMBER_TABLE
813: , p4_a2 in out nocopy JTF_NUMBER_TABLE
814: , p4_a3 in out nocopy JTF_NUMBER_TABLE
815: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
816: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
817: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 814: , p4_a3 in out nocopy JTF_NUMBER_TABLE

810: , p3_a35 in out nocopy VARCHAR2
811: , p4_a0 in out nocopy JTF_NUMBER_TABLE
812: , p4_a1 in out nocopy JTF_NUMBER_TABLE
813: , p4_a2 in out nocopy JTF_NUMBER_TABLE
814: , p4_a3 in out nocopy JTF_NUMBER_TABLE
815: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
816: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
817: , p4_a6 in out nocopy JTF_NUMBER_TABLE
818: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 817: , p4_a6 in out nocopy JTF_NUMBER_TABLE

813: , p4_a2 in out nocopy JTF_NUMBER_TABLE
814: , p4_a3 in out nocopy JTF_NUMBER_TABLE
815: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
816: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
817: , p4_a6 in out nocopy JTF_NUMBER_TABLE
818: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
819: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
820: , p4_a9 in out nocopy JTF_NUMBER_TABLE
821: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 820: , p4_a9 in out nocopy JTF_NUMBER_TABLE

816: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
817: , p4_a6 in out nocopy JTF_NUMBER_TABLE
818: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
819: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
820: , p4_a9 in out nocopy JTF_NUMBER_TABLE
821: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
822: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
823: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
824: , p4_a13 in out nocopy JTF_NUMBER_TABLE

Line 824: , p4_a13 in out nocopy JTF_NUMBER_TABLE

820: , p4_a9 in out nocopy JTF_NUMBER_TABLE
821: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
822: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
823: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
824: , p4_a13 in out nocopy JTF_NUMBER_TABLE
825: , p4_a14 in out nocopy JTF_NUMBER_TABLE
826: , p4_a15 in out nocopy JTF_DATE_TABLE
827: , p4_a16 in out nocopy JTF_DATE_TABLE
828: , p4_a17 in out nocopy JTF_NUMBER_TABLE

Line 825: , p4_a14 in out nocopy JTF_NUMBER_TABLE

821: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
822: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
823: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
824: , p4_a13 in out nocopy JTF_NUMBER_TABLE
825: , p4_a14 in out nocopy JTF_NUMBER_TABLE
826: , p4_a15 in out nocopy JTF_DATE_TABLE
827: , p4_a16 in out nocopy JTF_DATE_TABLE
828: , p4_a17 in out nocopy JTF_NUMBER_TABLE
829: , p4_a18 in out nocopy JTF_NUMBER_TABLE

Line 828: , p4_a17 in out nocopy JTF_NUMBER_TABLE

824: , p4_a13 in out nocopy JTF_NUMBER_TABLE
825: , p4_a14 in out nocopy JTF_NUMBER_TABLE
826: , p4_a15 in out nocopy JTF_DATE_TABLE
827: , p4_a16 in out nocopy JTF_DATE_TABLE
828: , p4_a17 in out nocopy JTF_NUMBER_TABLE
829: , p4_a18 in out nocopy JTF_NUMBER_TABLE
830: , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
831: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
832: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100

Line 829: , p4_a18 in out nocopy JTF_NUMBER_TABLE

825: , p4_a14 in out nocopy JTF_NUMBER_TABLE
826: , p4_a15 in out nocopy JTF_DATE_TABLE
827: , p4_a16 in out nocopy JTF_DATE_TABLE
828: , p4_a17 in out nocopy JTF_NUMBER_TABLE
829: , p4_a18 in out nocopy JTF_NUMBER_TABLE
830: , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
831: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
832: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
833: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1084: , p4_a0 in out nocopy JTF_NUMBER_TABLE

1080: , p3_a32 in out nocopy VARCHAR2
1081: , p3_a33 in out nocopy VARCHAR2
1082: , p3_a34 in out nocopy VARCHAR2
1083: , p3_a35 in out nocopy VARCHAR2
1084: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1085: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1086: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1087: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1088: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300

Line 1085: , p4_a1 in out nocopy JTF_NUMBER_TABLE

1081: , p3_a33 in out nocopy VARCHAR2
1082: , p3_a34 in out nocopy VARCHAR2
1083: , p3_a35 in out nocopy VARCHAR2
1084: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1085: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1086: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1087: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1088: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1089: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1086: , p4_a2 in out nocopy JTF_NUMBER_TABLE

1082: , p3_a34 in out nocopy VARCHAR2
1083: , p3_a35 in out nocopy VARCHAR2
1084: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1085: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1086: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1087: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1088: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1089: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1090: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 1087: , p4_a3 in out nocopy JTF_NUMBER_TABLE

1083: , p3_a35 in out nocopy VARCHAR2
1084: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1085: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1086: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1087: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1088: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1089: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1090: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1091: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1090: , p4_a6 in out nocopy JTF_NUMBER_TABLE

1086: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1087: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1088: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1089: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1090: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1091: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1092: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1093: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1094: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1093: , p4_a9 in out nocopy JTF_NUMBER_TABLE

1089: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1090: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1091: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1092: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1093: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1094: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1095: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1096: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1097: , p4_a13 in out nocopy JTF_NUMBER_TABLE

Line 1097: , p4_a13 in out nocopy JTF_NUMBER_TABLE

1093: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1094: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1095: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1096: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1097: , p4_a13 in out nocopy JTF_NUMBER_TABLE
1098: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1099: , p4_a15 in out nocopy JTF_DATE_TABLE
1100: , p4_a16 in out nocopy JTF_DATE_TABLE
1101: , p4_a17 in out nocopy JTF_NUMBER_TABLE

Line 1098: , p4_a14 in out nocopy JTF_NUMBER_TABLE

1094: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1095: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1096: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1097: , p4_a13 in out nocopy JTF_NUMBER_TABLE
1098: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1099: , p4_a15 in out nocopy JTF_DATE_TABLE
1100: , p4_a16 in out nocopy JTF_DATE_TABLE
1101: , p4_a17 in out nocopy JTF_NUMBER_TABLE
1102: , p4_a18 in out nocopy JTF_NUMBER_TABLE

Line 1101: , p4_a17 in out nocopy JTF_NUMBER_TABLE

1097: , p4_a13 in out nocopy JTF_NUMBER_TABLE
1098: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1099: , p4_a15 in out nocopy JTF_DATE_TABLE
1100: , p4_a16 in out nocopy JTF_DATE_TABLE
1101: , p4_a17 in out nocopy JTF_NUMBER_TABLE
1102: , p4_a18 in out nocopy JTF_NUMBER_TABLE
1103: , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1104: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1105: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1102: , p4_a18 in out nocopy JTF_NUMBER_TABLE

1098: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1099: , p4_a15 in out nocopy JTF_DATE_TABLE
1100: , p4_a16 in out nocopy JTF_DATE_TABLE
1101: , p4_a17 in out nocopy JTF_NUMBER_TABLE
1102: , p4_a18 in out nocopy JTF_NUMBER_TABLE
1103: , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1104: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1105: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1106: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1357: , p4_a0 in out nocopy JTF_NUMBER_TABLE

1353: , p3_a32 in out nocopy VARCHAR2
1354: , p3_a33 in out nocopy VARCHAR2
1355: , p3_a34 in out nocopy VARCHAR2
1356: , p3_a35 in out nocopy VARCHAR2
1357: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1358: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1359: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1360: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1361: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300

Line 1358: , p4_a1 in out nocopy JTF_NUMBER_TABLE

1354: , p3_a33 in out nocopy VARCHAR2
1355: , p3_a34 in out nocopy VARCHAR2
1356: , p3_a35 in out nocopy VARCHAR2
1357: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1358: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1359: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1360: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1361: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1362: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1359: , p4_a2 in out nocopy JTF_NUMBER_TABLE

1355: , p3_a34 in out nocopy VARCHAR2
1356: , p3_a35 in out nocopy VARCHAR2
1357: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1358: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1359: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1360: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1361: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1362: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1363: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 1360: , p4_a3 in out nocopy JTF_NUMBER_TABLE

1356: , p3_a35 in out nocopy VARCHAR2
1357: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1358: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1359: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1360: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1361: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1362: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1363: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1364: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1363: , p4_a6 in out nocopy JTF_NUMBER_TABLE

1359: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1360: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1361: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1362: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1363: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1364: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1365: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1366: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1367: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1366: , p4_a9 in out nocopy JTF_NUMBER_TABLE

1362: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1363: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1364: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1365: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1366: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1367: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1368: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1369: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1370: , p4_a13 in out nocopy JTF_NUMBER_TABLE

Line 1370: , p4_a13 in out nocopy JTF_NUMBER_TABLE

1366: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1367: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1368: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1369: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1370: , p4_a13 in out nocopy JTF_NUMBER_TABLE
1371: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1372: , p4_a15 in out nocopy JTF_DATE_TABLE
1373: , p4_a16 in out nocopy JTF_DATE_TABLE
1374: , p4_a17 in out nocopy JTF_NUMBER_TABLE

Line 1371: , p4_a14 in out nocopy JTF_NUMBER_TABLE

1367: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1368: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1369: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1370: , p4_a13 in out nocopy JTF_NUMBER_TABLE
1371: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1372: , p4_a15 in out nocopy JTF_DATE_TABLE
1373: , p4_a16 in out nocopy JTF_DATE_TABLE
1374: , p4_a17 in out nocopy JTF_NUMBER_TABLE
1375: , p4_a18 in out nocopy JTF_NUMBER_TABLE

Line 1374: , p4_a17 in out nocopy JTF_NUMBER_TABLE

1370: , p4_a13 in out nocopy JTF_NUMBER_TABLE
1371: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1372: , p4_a15 in out nocopy JTF_DATE_TABLE
1373: , p4_a16 in out nocopy JTF_DATE_TABLE
1374: , p4_a17 in out nocopy JTF_NUMBER_TABLE
1375: , p4_a18 in out nocopy JTF_NUMBER_TABLE
1376: , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1377: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1378: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1375: , p4_a18 in out nocopy JTF_NUMBER_TABLE

1371: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1372: , p4_a15 in out nocopy JTF_DATE_TABLE
1373: , p4_a16 in out nocopy JTF_DATE_TABLE
1374: , p4_a17 in out nocopy JTF_NUMBER_TABLE
1375: , p4_a18 in out nocopy JTF_NUMBER_TABLE
1376: , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1377: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1378: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1379: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1594: , p3_a0 in out nocopy JTF_NUMBER_TABLE

1590:
1591: procedure delete_rqmt_line(p_api_version NUMBER
1592: , p_init_msg_list VARCHAR2
1593: , p_commit VARCHAR2
1594: , p3_a0 in out nocopy JTF_NUMBER_TABLE
1595: , x_return_status out nocopy VARCHAR2
1596: , x_msg_count out nocopy NUMBER
1597: , x_msg_data out nocopy VARCHAR2
1598: )

Line 1639: , p4_a0 out nocopy JTF_NUMBER_TABLE

1635: procedure check_availability(p_api_version NUMBER
1636: , p_init_msg_list VARCHAR2
1637: , p_commit VARCHAR2
1638: , p_header_id NUMBER
1639: , p4_a0 out nocopy JTF_NUMBER_TABLE
1640: , p4_a1 out nocopy JTF_NUMBER_TABLE
1641: , p4_a2 out nocopy JTF_NUMBER_TABLE
1642: , p4_a3 out nocopy JTF_NUMBER_TABLE
1643: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 1640: , p4_a1 out nocopy JTF_NUMBER_TABLE

1636: , p_init_msg_list VARCHAR2
1637: , p_commit VARCHAR2
1638: , p_header_id NUMBER
1639: , p4_a0 out nocopy JTF_NUMBER_TABLE
1640: , p4_a1 out nocopy JTF_NUMBER_TABLE
1641: , p4_a2 out nocopy JTF_NUMBER_TABLE
1642: , p4_a3 out nocopy JTF_NUMBER_TABLE
1643: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1644: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1641: , p4_a2 out nocopy JTF_NUMBER_TABLE

1637: , p_commit VARCHAR2
1638: , p_header_id NUMBER
1639: , p4_a0 out nocopy JTF_NUMBER_TABLE
1640: , p4_a1 out nocopy JTF_NUMBER_TABLE
1641: , p4_a2 out nocopy JTF_NUMBER_TABLE
1642: , p4_a3 out nocopy JTF_NUMBER_TABLE
1643: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1644: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1645: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 1642: , p4_a3 out nocopy JTF_NUMBER_TABLE

1638: , p_header_id NUMBER
1639: , p4_a0 out nocopy JTF_NUMBER_TABLE
1640: , p4_a1 out nocopy JTF_NUMBER_TABLE
1641: , p4_a2 out nocopy JTF_NUMBER_TABLE
1642: , p4_a3 out nocopy JTF_NUMBER_TABLE
1643: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1644: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1645: , p4_a6 out nocopy JTF_NUMBER_TABLE
1646: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1645: , p4_a6 out nocopy JTF_NUMBER_TABLE

1641: , p4_a2 out nocopy JTF_NUMBER_TABLE
1642: , p4_a3 out nocopy JTF_NUMBER_TABLE
1643: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1644: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1645: , p4_a6 out nocopy JTF_NUMBER_TABLE
1646: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
1647: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1648: , p4_a9 out nocopy JTF_NUMBER_TABLE
1649: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1648: , p4_a9 out nocopy JTF_NUMBER_TABLE

1644: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1645: , p4_a6 out nocopy JTF_NUMBER_TABLE
1646: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
1647: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1648: , p4_a9 out nocopy JTF_NUMBER_TABLE
1649: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
1650: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_100
1651: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1652: , p4_a13 out nocopy JTF_NUMBER_TABLE

Line 1652: , p4_a13 out nocopy JTF_NUMBER_TABLE

1648: , p4_a9 out nocopy JTF_NUMBER_TABLE
1649: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
1650: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_100
1651: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1652: , p4_a13 out nocopy JTF_NUMBER_TABLE
1653: , p4_a14 out nocopy JTF_NUMBER_TABLE
1654: , p4_a15 out nocopy JTF_DATE_TABLE
1655: , p4_a16 out nocopy JTF_DATE_TABLE
1656: , p4_a17 out nocopy JTF_NUMBER_TABLE

Line 1653: , p4_a14 out nocopy JTF_NUMBER_TABLE

1649: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
1650: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_100
1651: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1652: , p4_a13 out nocopy JTF_NUMBER_TABLE
1653: , p4_a14 out nocopy JTF_NUMBER_TABLE
1654: , p4_a15 out nocopy JTF_DATE_TABLE
1655: , p4_a16 out nocopy JTF_DATE_TABLE
1656: , p4_a17 out nocopy JTF_NUMBER_TABLE
1657: , p4_a18 out nocopy JTF_NUMBER_TABLE

Line 1656: , p4_a17 out nocopy JTF_NUMBER_TABLE

1652: , p4_a13 out nocopy JTF_NUMBER_TABLE
1653: , p4_a14 out nocopy JTF_NUMBER_TABLE
1654: , p4_a15 out nocopy JTF_DATE_TABLE
1655: , p4_a16 out nocopy JTF_DATE_TABLE
1656: , p4_a17 out nocopy JTF_NUMBER_TABLE
1657: , p4_a18 out nocopy JTF_NUMBER_TABLE
1658: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1659: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1660: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 1657: , p4_a18 out nocopy JTF_NUMBER_TABLE

1653: , p4_a14 out nocopy JTF_NUMBER_TABLE
1654: , p4_a15 out nocopy JTF_DATE_TABLE
1655: , p4_a16 out nocopy JTF_DATE_TABLE
1656: , p4_a17 out nocopy JTF_NUMBER_TABLE
1657: , p4_a18 out nocopy JTF_NUMBER_TABLE
1658: , p4_a19 out nocopy JTF_VARCHAR2_TABLE_100
1659: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1660: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1661: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 1768: , p4_a1 out nocopy JTF_NUMBER_TABLE

1764: , p_init_msg_list VARCHAR2
1765: , p_commit VARCHAR2
1766: , p_header_id NUMBER
1767: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1768: , p4_a1 out nocopy JTF_NUMBER_TABLE
1769: , x_return_status out nocopy VARCHAR2
1770: , x_msg_count out nocopy NUMBER
1771: , x_msg_data out nocopy VARCHAR2
1772: )