DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT_W dependencies on JTF_NUMBER_TABLE

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

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_300

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_300
21: , a5 JTF_VARCHAR2_TABLE_100

Line 18: , a2 JTF_NUMBER_TABLE

14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_300
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE

Line 19: , a3 JTF_NUMBER_TABLE

15:
16: procedure rosetta_table_copy_in_p2(t out nocopy csp_parts_requirement.line_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_300
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100

Line 22: , a6 JTF_NUMBER_TABLE

18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_300
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100

Line 25: , a9 JTF_NUMBER_TABLE

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

Line 29: , a13 JTF_NUMBER_TABLE

25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_DATE_TABLE
32: , a16 JTF_DATE_TABLE
33: , a17 JTF_DATE_TABLE

Line 30: , a14 JTF_NUMBER_TABLE

26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_DATE_TABLE
32: , a16 JTF_DATE_TABLE
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_NUMBER_TABLE

Line 34: , a18 JTF_NUMBER_TABLE

30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_DATE_TABLE
32: , a16 JTF_DATE_TABLE
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_NUMBER_TABLE
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_VARCHAR2_TABLE_100

Line 35: , a19 JTF_NUMBER_TABLE

31: , a15 JTF_DATE_TABLE
32: , a16 JTF_DATE_TABLE
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_NUMBER_TABLE
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_VARCHAR2_TABLE_100
39: , a23 JTF_VARCHAR2_TABLE_100

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

111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 116: , a1 out nocopy JTF_NUMBER_TABLE

112: end if;
113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t csp_parts_requirement.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_VARCHAR2_TABLE_300
120: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , a2 out nocopy JTF_NUMBER_TABLE

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

Line 118: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 121: , a6 out nocopy JTF_NUMBER_TABLE

117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_NUMBER_TABLE
119: , a4 out nocopy JTF_VARCHAR2_TABLE_300
120: , a5 out nocopy JTF_VARCHAR2_TABLE_100
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_VARCHAR2_TABLE_100
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_NUMBER_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , a9 out nocopy JTF_NUMBER_TABLE

120: , a5 out nocopy JTF_VARCHAR2_TABLE_100
121: , a6 out nocopy JTF_NUMBER_TABLE
122: , a7 out nocopy JTF_VARCHAR2_TABLE_100
123: , a8 out nocopy JTF_VARCHAR2_TABLE_100
124: , a9 out nocopy JTF_NUMBER_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_VARCHAR2_TABLE_100
128: , a13 out nocopy JTF_NUMBER_TABLE

Line 128: , a13 out nocopy JTF_NUMBER_TABLE

124: , a9 out nocopy JTF_NUMBER_TABLE
125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_VARCHAR2_TABLE_100
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_DATE_TABLE
131: , a16 out nocopy JTF_DATE_TABLE
132: , a17 out nocopy JTF_DATE_TABLE

Line 129: , a14 out nocopy JTF_NUMBER_TABLE

125: , a10 out nocopy JTF_VARCHAR2_TABLE_100
126: , a11 out nocopy JTF_VARCHAR2_TABLE_100
127: , a12 out nocopy JTF_VARCHAR2_TABLE_100
128: , a13 out nocopy JTF_NUMBER_TABLE
129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_DATE_TABLE
131: , a16 out nocopy JTF_DATE_TABLE
132: , a17 out nocopy JTF_DATE_TABLE
133: , a18 out nocopy JTF_NUMBER_TABLE

Line 133: , a18 out nocopy JTF_NUMBER_TABLE

129: , a14 out nocopy JTF_NUMBER_TABLE
130: , a15 out nocopy JTF_DATE_TABLE
131: , a16 out nocopy JTF_DATE_TABLE
132: , a17 out nocopy JTF_DATE_TABLE
133: , a18 out nocopy JTF_NUMBER_TABLE
134: , a19 out nocopy JTF_NUMBER_TABLE
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_VARCHAR2_TABLE_100
137: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 134: , a19 out nocopy JTF_NUMBER_TABLE

130: , a15 out nocopy JTF_DATE_TABLE
131: , a16 out nocopy JTF_DATE_TABLE
132: , a17 out nocopy JTF_DATE_TABLE
133: , a18 out nocopy JTF_NUMBER_TABLE
134: , a19 out nocopy JTF_NUMBER_TABLE
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_VARCHAR2_TABLE_100
137: , a22 out nocopy JTF_VARCHAR2_TABLE_100
138: , a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 160: a0 := JTF_NUMBER_TABLE();

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

Line 161: a1 := JTF_NUMBER_TABLE();

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

Line 162: a2 := JTF_NUMBER_TABLE();

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

Line 163: a3 := JTF_NUMBER_TABLE();

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

Line 166: a6 := JTF_NUMBER_TABLE();

162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_NUMBER_TABLE();
164: a4 := JTF_VARCHAR2_TABLE_300();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_VARCHAR2_TABLE_100();
168: a8 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_NUMBER_TABLE();
170: a10 := JTF_VARCHAR2_TABLE_100();

Line 169: a9 := JTF_NUMBER_TABLE();

165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_NUMBER_TABLE();
167: a7 := JTF_VARCHAR2_TABLE_100();
168: a8 := JTF_VARCHAR2_TABLE_100();
169: a9 := JTF_NUMBER_TABLE();
170: a10 := JTF_VARCHAR2_TABLE_100();
171: a11 := JTF_VARCHAR2_TABLE_100();
172: a12 := JTF_VARCHAR2_TABLE_100();
173: a13 := JTF_NUMBER_TABLE();

Line 173: a13 := JTF_NUMBER_TABLE();

169: a9 := JTF_NUMBER_TABLE();
170: a10 := JTF_VARCHAR2_TABLE_100();
171: a11 := JTF_VARCHAR2_TABLE_100();
172: a12 := JTF_VARCHAR2_TABLE_100();
173: a13 := JTF_NUMBER_TABLE();
174: a14 := JTF_NUMBER_TABLE();
175: a15 := JTF_DATE_TABLE();
176: a16 := JTF_DATE_TABLE();
177: a17 := JTF_DATE_TABLE();

Line 174: a14 := JTF_NUMBER_TABLE();

170: a10 := JTF_VARCHAR2_TABLE_100();
171: a11 := JTF_VARCHAR2_TABLE_100();
172: a12 := JTF_VARCHAR2_TABLE_100();
173: a13 := JTF_NUMBER_TABLE();
174: a14 := JTF_NUMBER_TABLE();
175: a15 := JTF_DATE_TABLE();
176: a16 := JTF_DATE_TABLE();
177: a17 := JTF_DATE_TABLE();
178: a18 := JTF_NUMBER_TABLE();

Line 178: a18 := JTF_NUMBER_TABLE();

174: a14 := JTF_NUMBER_TABLE();
175: a15 := JTF_DATE_TABLE();
176: a16 := JTF_DATE_TABLE();
177: a17 := JTF_DATE_TABLE();
178: a18 := JTF_NUMBER_TABLE();
179: a19 := JTF_NUMBER_TABLE();
180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_VARCHAR2_TABLE_100();
182: a22 := JTF_VARCHAR2_TABLE_100();

Line 179: a19 := JTF_NUMBER_TABLE();

175: a15 := JTF_DATE_TABLE();
176: a16 := JTF_DATE_TABLE();
177: a17 := JTF_DATE_TABLE();
178: a18 := JTF_NUMBER_TABLE();
179: a19 := JTF_NUMBER_TABLE();
180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_VARCHAR2_TABLE_100();
182: a22 := JTF_VARCHAR2_TABLE_100();
183: a23 := JTF_VARCHAR2_TABLE_100();

Line 202: a0 := JTF_NUMBER_TABLE();

198: a38 := JTF_VARCHAR2_TABLE_200();
199: a39 := JTF_VARCHAR2_TABLE_200();
200: a40 := JTF_VARCHAR2_TABLE_200();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_NUMBER_TABLE();
205: a3 := JTF_NUMBER_TABLE();
206: a4 := JTF_VARCHAR2_TABLE_300();

Line 203: a1 := JTF_NUMBER_TABLE();

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

Line 204: a2 := JTF_NUMBER_TABLE();

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

Line 205: a3 := JTF_NUMBER_TABLE();

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

Line 208: a6 := JTF_NUMBER_TABLE();

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

Line 211: a9 := JTF_NUMBER_TABLE();

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

Line 215: a13 := JTF_NUMBER_TABLE();

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

Line 216: a14 := JTF_NUMBER_TABLE();

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

Line 220: a18 := JTF_NUMBER_TABLE();

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

Line 221: a19 := JTF_NUMBER_TABLE();

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

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

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

Line 340: , a1 JTF_NUMBER_TABLE

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

Line 342: , a3 JTF_NUMBER_TABLE

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

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

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

Line 365: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 367: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 372: a0 := JTF_NUMBER_TABLE();

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

Line 373: a1 := JTF_NUMBER_TABLE();

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

Line 375: a3 := JTF_NUMBER_TABLE();

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

Line 377: a0 := JTF_NUMBER_TABLE();

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

Line 378: a1 := JTF_NUMBER_TABLE();

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

Line 380: a3 := JTF_NUMBER_TABLE();

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

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

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

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

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

Line 427: a0 := JTF_NUMBER_TABLE();

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

Line 429: a0 := JTF_NUMBER_TABLE();

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

Line 447: , a1 JTF_NUMBER_TABLE

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

Line 468: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 474: a1 := JTF_NUMBER_TABLE();

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

Line 477: a1 := JTF_NUMBER_TABLE();

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

Line 543: , p4_a0 in out nocopy JTF_NUMBER_TABLE

539: , p3_a40 in out nocopy VARCHAR2
540: , p3_a41 in out nocopy VARCHAR2
541: , p3_a42 in out nocopy VARCHAR2
542: , p3_a43 in out nocopy NUMBER
543: , p4_a0 in out nocopy JTF_NUMBER_TABLE
544: , p4_a1 in out nocopy JTF_NUMBER_TABLE
545: , p4_a2 in out nocopy JTF_NUMBER_TABLE
546: , p4_a3 in out nocopy JTF_NUMBER_TABLE
547: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300

Line 544: , p4_a1 in out nocopy JTF_NUMBER_TABLE

540: , p3_a41 in out nocopy VARCHAR2
541: , p3_a42 in out nocopy VARCHAR2
542: , p3_a43 in out nocopy NUMBER
543: , p4_a0 in out nocopy JTF_NUMBER_TABLE
544: , p4_a1 in out nocopy JTF_NUMBER_TABLE
545: , p4_a2 in out nocopy JTF_NUMBER_TABLE
546: , p4_a3 in out nocopy JTF_NUMBER_TABLE
547: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
548: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 545: , p4_a2 in out nocopy JTF_NUMBER_TABLE

541: , p3_a42 in out nocopy VARCHAR2
542: , p3_a43 in out nocopy NUMBER
543: , p4_a0 in out nocopy JTF_NUMBER_TABLE
544: , p4_a1 in out nocopy JTF_NUMBER_TABLE
545: , p4_a2 in out nocopy JTF_NUMBER_TABLE
546: , p4_a3 in out nocopy JTF_NUMBER_TABLE
547: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
548: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
549: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 546: , p4_a3 in out nocopy JTF_NUMBER_TABLE

542: , p3_a43 in out nocopy NUMBER
543: , p4_a0 in out nocopy JTF_NUMBER_TABLE
544: , p4_a1 in out nocopy JTF_NUMBER_TABLE
545: , p4_a2 in out nocopy JTF_NUMBER_TABLE
546: , p4_a3 in out nocopy JTF_NUMBER_TABLE
547: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
548: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
549: , p4_a6 in out nocopy JTF_NUMBER_TABLE
550: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 549: , p4_a6 in out nocopy JTF_NUMBER_TABLE

545: , p4_a2 in out nocopy JTF_NUMBER_TABLE
546: , p4_a3 in out nocopy JTF_NUMBER_TABLE
547: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
548: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
549: , p4_a6 in out nocopy JTF_NUMBER_TABLE
550: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
551: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
552: , p4_a9 in out nocopy JTF_NUMBER_TABLE
553: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 552: , p4_a9 in out nocopy JTF_NUMBER_TABLE

548: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
549: , p4_a6 in out nocopy JTF_NUMBER_TABLE
550: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
551: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
552: , p4_a9 in out nocopy JTF_NUMBER_TABLE
553: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
554: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
555: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p4_a13 in out nocopy JTF_NUMBER_TABLE

Line 556: , p4_a13 in out nocopy JTF_NUMBER_TABLE

552: , p4_a9 in out nocopy JTF_NUMBER_TABLE
553: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
554: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
555: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p4_a13 in out nocopy JTF_NUMBER_TABLE
557: , p4_a14 in out nocopy JTF_NUMBER_TABLE
558: , p4_a15 in out nocopy JTF_DATE_TABLE
559: , p4_a16 in out nocopy JTF_DATE_TABLE
560: , p4_a17 in out nocopy JTF_DATE_TABLE

Line 557: , p4_a14 in out nocopy JTF_NUMBER_TABLE

553: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
554: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
555: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p4_a13 in out nocopy JTF_NUMBER_TABLE
557: , p4_a14 in out nocopy JTF_NUMBER_TABLE
558: , p4_a15 in out nocopy JTF_DATE_TABLE
559: , p4_a16 in out nocopy JTF_DATE_TABLE
560: , p4_a17 in out nocopy JTF_DATE_TABLE
561: , p4_a18 in out nocopy JTF_NUMBER_TABLE

Line 561: , p4_a18 in out nocopy JTF_NUMBER_TABLE

557: , p4_a14 in out nocopy JTF_NUMBER_TABLE
558: , p4_a15 in out nocopy JTF_DATE_TABLE
559: , p4_a16 in out nocopy JTF_DATE_TABLE
560: , p4_a17 in out nocopy JTF_DATE_TABLE
561: , p4_a18 in out nocopy JTF_NUMBER_TABLE
562: , p4_a19 in out nocopy JTF_NUMBER_TABLE
563: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
564: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
565: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100

Line 562: , p4_a19 in out nocopy JTF_NUMBER_TABLE

558: , p4_a15 in out nocopy JTF_DATE_TABLE
559: , p4_a16 in out nocopy JTF_DATE_TABLE
560: , p4_a17 in out nocopy JTF_DATE_TABLE
561: , p4_a18 in out nocopy JTF_NUMBER_TABLE
562: , p4_a19 in out nocopy JTF_NUMBER_TABLE
563: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
564: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
565: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100
566: , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_100

Line 847: , p4_a0 in out nocopy JTF_NUMBER_TABLE

843: , p3_a40 in out nocopy VARCHAR2
844: , p3_a41 in out nocopy VARCHAR2
845: , p3_a42 in out nocopy VARCHAR2
846: , p3_a43 in out nocopy NUMBER
847: , p4_a0 in out nocopy JTF_NUMBER_TABLE
848: , p4_a1 in out nocopy JTF_NUMBER_TABLE
849: , p4_a2 in out nocopy JTF_NUMBER_TABLE
850: , p4_a3 in out nocopy JTF_NUMBER_TABLE
851: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300

Line 848: , p4_a1 in out nocopy JTF_NUMBER_TABLE

844: , p3_a41 in out nocopy VARCHAR2
845: , p3_a42 in out nocopy VARCHAR2
846: , p3_a43 in out nocopy NUMBER
847: , p4_a0 in out nocopy JTF_NUMBER_TABLE
848: , p4_a1 in out nocopy JTF_NUMBER_TABLE
849: , p4_a2 in out nocopy JTF_NUMBER_TABLE
850: , p4_a3 in out nocopy JTF_NUMBER_TABLE
851: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
852: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 849: , p4_a2 in out nocopy JTF_NUMBER_TABLE

845: , p3_a42 in out nocopy VARCHAR2
846: , p3_a43 in out nocopy NUMBER
847: , p4_a0 in out nocopy JTF_NUMBER_TABLE
848: , p4_a1 in out nocopy JTF_NUMBER_TABLE
849: , p4_a2 in out nocopy JTF_NUMBER_TABLE
850: , p4_a3 in out nocopy JTF_NUMBER_TABLE
851: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
852: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
853: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 850: , p4_a3 in out nocopy JTF_NUMBER_TABLE

846: , p3_a43 in out nocopy NUMBER
847: , p4_a0 in out nocopy JTF_NUMBER_TABLE
848: , p4_a1 in out nocopy JTF_NUMBER_TABLE
849: , p4_a2 in out nocopy JTF_NUMBER_TABLE
850: , p4_a3 in out nocopy JTF_NUMBER_TABLE
851: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
852: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
853: , p4_a6 in out nocopy JTF_NUMBER_TABLE
854: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 853: , p4_a6 in out nocopy JTF_NUMBER_TABLE

849: , p4_a2 in out nocopy JTF_NUMBER_TABLE
850: , p4_a3 in out nocopy JTF_NUMBER_TABLE
851: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
852: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
853: , p4_a6 in out nocopy JTF_NUMBER_TABLE
854: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
855: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
856: , p4_a9 in out nocopy JTF_NUMBER_TABLE
857: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 856: , p4_a9 in out nocopy JTF_NUMBER_TABLE

852: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
853: , p4_a6 in out nocopy JTF_NUMBER_TABLE
854: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
855: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
856: , p4_a9 in out nocopy JTF_NUMBER_TABLE
857: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
858: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
859: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
860: , p4_a13 in out nocopy JTF_NUMBER_TABLE

Line 860: , p4_a13 in out nocopy JTF_NUMBER_TABLE

856: , p4_a9 in out nocopy JTF_NUMBER_TABLE
857: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
858: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
859: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
860: , p4_a13 in out nocopy JTF_NUMBER_TABLE
861: , p4_a14 in out nocopy JTF_NUMBER_TABLE
862: , p4_a15 in out nocopy JTF_DATE_TABLE
863: , p4_a16 in out nocopy JTF_DATE_TABLE
864: , p4_a17 in out nocopy JTF_DATE_TABLE

Line 861: , p4_a14 in out nocopy JTF_NUMBER_TABLE

857: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
858: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
859: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
860: , p4_a13 in out nocopy JTF_NUMBER_TABLE
861: , p4_a14 in out nocopy JTF_NUMBER_TABLE
862: , p4_a15 in out nocopy JTF_DATE_TABLE
863: , p4_a16 in out nocopy JTF_DATE_TABLE
864: , p4_a17 in out nocopy JTF_DATE_TABLE
865: , p4_a18 in out nocopy JTF_NUMBER_TABLE

Line 865: , p4_a18 in out nocopy JTF_NUMBER_TABLE

861: , p4_a14 in out nocopy JTF_NUMBER_TABLE
862: , p4_a15 in out nocopy JTF_DATE_TABLE
863: , p4_a16 in out nocopy JTF_DATE_TABLE
864: , p4_a17 in out nocopy JTF_DATE_TABLE
865: , p4_a18 in out nocopy JTF_NUMBER_TABLE
866: , p4_a19 in out nocopy JTF_NUMBER_TABLE
867: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
868: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
869: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100

Line 866: , p4_a19 in out nocopy JTF_NUMBER_TABLE

862: , p4_a15 in out nocopy JTF_DATE_TABLE
863: , p4_a16 in out nocopy JTF_DATE_TABLE
864: , p4_a17 in out nocopy JTF_DATE_TABLE
865: , p4_a18 in out nocopy JTF_NUMBER_TABLE
866: , p4_a19 in out nocopy JTF_NUMBER_TABLE
867: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
868: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
869: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1147: , p4_a0 in out nocopy JTF_NUMBER_TABLE

1143: , p3_a40 in out nocopy VARCHAR2
1144: , p3_a41 in out nocopy VARCHAR2
1145: , p3_a42 in out nocopy VARCHAR2
1146: , p3_a43 in out nocopy NUMBER
1147: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1148: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1149: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1150: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1151: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300

Line 1148: , p4_a1 in out nocopy JTF_NUMBER_TABLE

1144: , p3_a41 in out nocopy VARCHAR2
1145: , p3_a42 in out nocopy VARCHAR2
1146: , p3_a43 in out nocopy NUMBER
1147: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1148: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1149: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1150: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1151: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1152: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1149: , p4_a2 in out nocopy JTF_NUMBER_TABLE

1145: , p3_a42 in out nocopy VARCHAR2
1146: , p3_a43 in out nocopy NUMBER
1147: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1148: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1149: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1150: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1151: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1152: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1153: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 1150: , p4_a3 in out nocopy JTF_NUMBER_TABLE

1146: , p3_a43 in out nocopy NUMBER
1147: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1148: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1149: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1150: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1151: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1152: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1153: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1154: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1153: , p4_a6 in out nocopy JTF_NUMBER_TABLE

1149: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1150: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1151: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1152: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1153: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1154: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1155: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1156: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1157: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1156: , p4_a9 in out nocopy JTF_NUMBER_TABLE

1152: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1153: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1154: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1155: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1156: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1157: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1158: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1159: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1160: , p4_a13 in out nocopy JTF_NUMBER_TABLE

Line 1160: , p4_a13 in out nocopy JTF_NUMBER_TABLE

1156: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1157: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1158: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1159: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1160: , p4_a13 in out nocopy JTF_NUMBER_TABLE
1161: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1162: , p4_a15 in out nocopy JTF_DATE_TABLE
1163: , p4_a16 in out nocopy JTF_DATE_TABLE
1164: , p4_a17 in out nocopy JTF_DATE_TABLE

Line 1161: , p4_a14 in out nocopy JTF_NUMBER_TABLE

1157: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1158: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1159: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1160: , p4_a13 in out nocopy JTF_NUMBER_TABLE
1161: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1162: , p4_a15 in out nocopy JTF_DATE_TABLE
1163: , p4_a16 in out nocopy JTF_DATE_TABLE
1164: , p4_a17 in out nocopy JTF_DATE_TABLE
1165: , p4_a18 in out nocopy JTF_NUMBER_TABLE

Line 1165: , p4_a18 in out nocopy JTF_NUMBER_TABLE

1161: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1162: , p4_a15 in out nocopy JTF_DATE_TABLE
1163: , p4_a16 in out nocopy JTF_DATE_TABLE
1164: , p4_a17 in out nocopy JTF_DATE_TABLE
1165: , p4_a18 in out nocopy JTF_NUMBER_TABLE
1166: , p4_a19 in out nocopy JTF_NUMBER_TABLE
1167: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1168: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1169: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1166: , p4_a19 in out nocopy JTF_NUMBER_TABLE

1162: , p4_a15 in out nocopy JTF_DATE_TABLE
1163: , p4_a16 in out nocopy JTF_DATE_TABLE
1164: , p4_a17 in out nocopy JTF_DATE_TABLE
1165: , p4_a18 in out nocopy JTF_NUMBER_TABLE
1166: , p4_a19 in out nocopy JTF_NUMBER_TABLE
1167: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1168: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1169: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100
1170: , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1447: , p4_a0 in out nocopy JTF_NUMBER_TABLE

1443: , p3_a40 in out nocopy VARCHAR2
1444: , p3_a41 in out nocopy VARCHAR2
1445: , p3_a42 in out nocopy VARCHAR2
1446: , p3_a43 in out nocopy NUMBER
1447: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1448: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1449: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1450: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1451: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300

Line 1448: , p4_a1 in out nocopy JTF_NUMBER_TABLE

1444: , p3_a41 in out nocopy VARCHAR2
1445: , p3_a42 in out nocopy VARCHAR2
1446: , p3_a43 in out nocopy NUMBER
1447: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1448: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1449: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1450: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1451: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1452: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1449: , p4_a2 in out nocopy JTF_NUMBER_TABLE

1445: , p3_a42 in out nocopy VARCHAR2
1446: , p3_a43 in out nocopy NUMBER
1447: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1448: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1449: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1450: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1451: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1452: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1453: , p4_a6 in out nocopy JTF_NUMBER_TABLE

Line 1450: , p4_a3 in out nocopy JTF_NUMBER_TABLE

1446: , p3_a43 in out nocopy NUMBER
1447: , p4_a0 in out nocopy JTF_NUMBER_TABLE
1448: , p4_a1 in out nocopy JTF_NUMBER_TABLE
1449: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1450: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1451: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1452: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1453: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1454: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1453: , p4_a6 in out nocopy JTF_NUMBER_TABLE

1449: , p4_a2 in out nocopy JTF_NUMBER_TABLE
1450: , p4_a3 in out nocopy JTF_NUMBER_TABLE
1451: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
1452: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1453: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1454: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1455: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1456: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1457: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1456: , p4_a9 in out nocopy JTF_NUMBER_TABLE

1452: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1453: , p4_a6 in out nocopy JTF_NUMBER_TABLE
1454: , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1455: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1456: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1457: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1458: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1459: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1460: , p4_a13 in out nocopy JTF_NUMBER_TABLE

Line 1460: , p4_a13 in out nocopy JTF_NUMBER_TABLE

1456: , p4_a9 in out nocopy JTF_NUMBER_TABLE
1457: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1458: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1459: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1460: , p4_a13 in out nocopy JTF_NUMBER_TABLE
1461: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1462: , p4_a15 in out nocopy JTF_DATE_TABLE
1463: , p4_a16 in out nocopy JTF_DATE_TABLE
1464: , p4_a17 in out nocopy JTF_DATE_TABLE

Line 1461: , p4_a14 in out nocopy JTF_NUMBER_TABLE

1457: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
1458: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1459: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1460: , p4_a13 in out nocopy JTF_NUMBER_TABLE
1461: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1462: , p4_a15 in out nocopy JTF_DATE_TABLE
1463: , p4_a16 in out nocopy JTF_DATE_TABLE
1464: , p4_a17 in out nocopy JTF_DATE_TABLE
1465: , p4_a18 in out nocopy JTF_NUMBER_TABLE

Line 1465: , p4_a18 in out nocopy JTF_NUMBER_TABLE

1461: , p4_a14 in out nocopy JTF_NUMBER_TABLE
1462: , p4_a15 in out nocopy JTF_DATE_TABLE
1463: , p4_a16 in out nocopy JTF_DATE_TABLE
1464: , p4_a17 in out nocopy JTF_DATE_TABLE
1465: , p4_a18 in out nocopy JTF_NUMBER_TABLE
1466: , p4_a19 in out nocopy JTF_NUMBER_TABLE
1467: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1468: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1469: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1466: , p4_a19 in out nocopy JTF_NUMBER_TABLE

1462: , p4_a15 in out nocopy JTF_DATE_TABLE
1463: , p4_a16 in out nocopy JTF_DATE_TABLE
1464: , p4_a17 in out nocopy JTF_DATE_TABLE
1465: , p4_a18 in out nocopy JTF_NUMBER_TABLE
1466: , p4_a19 in out nocopy JTF_NUMBER_TABLE
1467: , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1468: , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1469: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_100
1470: , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1703: , p3_a0 in out nocopy JTF_NUMBER_TABLE

1699:
1700: procedure delete_rqmt_line(p_api_version NUMBER
1701: , p_init_msg_list VARCHAR2
1702: , p_commit VARCHAR2
1703: , p3_a0 in out nocopy JTF_NUMBER_TABLE
1704: , x_return_status out nocopy VARCHAR2
1705: , x_msg_count out nocopy NUMBER
1706: , x_msg_data out nocopy VARCHAR2
1707: )

Line 1748: , p4_a0 out nocopy JTF_NUMBER_TABLE

1744: procedure check_availability(p_api_version NUMBER
1745: , p_init_msg_list VARCHAR2
1746: , p_commit VARCHAR2
1747: , p_header_id NUMBER
1748: , p4_a0 out nocopy JTF_NUMBER_TABLE
1749: , p4_a1 out nocopy JTF_NUMBER_TABLE
1750: , p4_a2 out nocopy JTF_NUMBER_TABLE
1751: , p4_a3 out nocopy JTF_NUMBER_TABLE
1752: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 1749: , p4_a1 out nocopy JTF_NUMBER_TABLE

1745: , p_init_msg_list VARCHAR2
1746: , p_commit VARCHAR2
1747: , p_header_id NUMBER
1748: , p4_a0 out nocopy JTF_NUMBER_TABLE
1749: , p4_a1 out nocopy JTF_NUMBER_TABLE
1750: , p4_a2 out nocopy JTF_NUMBER_TABLE
1751: , p4_a3 out nocopy JTF_NUMBER_TABLE
1752: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1753: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1750: , p4_a2 out nocopy JTF_NUMBER_TABLE

1746: , p_commit VARCHAR2
1747: , p_header_id NUMBER
1748: , p4_a0 out nocopy JTF_NUMBER_TABLE
1749: , p4_a1 out nocopy JTF_NUMBER_TABLE
1750: , p4_a2 out nocopy JTF_NUMBER_TABLE
1751: , p4_a3 out nocopy JTF_NUMBER_TABLE
1752: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1753: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1754: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 1751: , p4_a3 out nocopy JTF_NUMBER_TABLE

1747: , p_header_id NUMBER
1748: , p4_a0 out nocopy JTF_NUMBER_TABLE
1749: , p4_a1 out nocopy JTF_NUMBER_TABLE
1750: , p4_a2 out nocopy JTF_NUMBER_TABLE
1751: , p4_a3 out nocopy JTF_NUMBER_TABLE
1752: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1753: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1754: , p4_a6 out nocopy JTF_NUMBER_TABLE
1755: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1754: , p4_a6 out nocopy JTF_NUMBER_TABLE

1750: , p4_a2 out nocopy JTF_NUMBER_TABLE
1751: , p4_a3 out nocopy JTF_NUMBER_TABLE
1752: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1753: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1754: , p4_a6 out nocopy JTF_NUMBER_TABLE
1755: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
1756: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1757: , p4_a9 out nocopy JTF_NUMBER_TABLE
1758: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1757: , p4_a9 out nocopy JTF_NUMBER_TABLE

1753: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1754: , p4_a6 out nocopy JTF_NUMBER_TABLE
1755: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
1756: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1757: , p4_a9 out nocopy JTF_NUMBER_TABLE
1758: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_100
1760: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1761: , p4_a13 out nocopy JTF_NUMBER_TABLE

Line 1761: , p4_a13 out nocopy JTF_NUMBER_TABLE

1757: , p4_a9 out nocopy JTF_NUMBER_TABLE
1758: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_100
1760: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1761: , p4_a13 out nocopy JTF_NUMBER_TABLE
1762: , p4_a14 out nocopy JTF_NUMBER_TABLE
1763: , p4_a15 out nocopy JTF_DATE_TABLE
1764: , p4_a16 out nocopy JTF_DATE_TABLE
1765: , p4_a17 out nocopy JTF_DATE_TABLE

Line 1762: , p4_a14 out nocopy JTF_NUMBER_TABLE

1758: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
1759: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_100
1760: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1761: , p4_a13 out nocopy JTF_NUMBER_TABLE
1762: , p4_a14 out nocopy JTF_NUMBER_TABLE
1763: , p4_a15 out nocopy JTF_DATE_TABLE
1764: , p4_a16 out nocopy JTF_DATE_TABLE
1765: , p4_a17 out nocopy JTF_DATE_TABLE
1766: , p4_a18 out nocopy JTF_NUMBER_TABLE

Line 1766: , p4_a18 out nocopy JTF_NUMBER_TABLE

1762: , p4_a14 out nocopy JTF_NUMBER_TABLE
1763: , p4_a15 out nocopy JTF_DATE_TABLE
1764: , p4_a16 out nocopy JTF_DATE_TABLE
1765: , p4_a17 out nocopy JTF_DATE_TABLE
1766: , p4_a18 out nocopy JTF_NUMBER_TABLE
1767: , p4_a19 out nocopy JTF_NUMBER_TABLE
1768: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1769: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1770: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 1767: , p4_a19 out nocopy JTF_NUMBER_TABLE

1763: , p4_a15 out nocopy JTF_DATE_TABLE
1764: , p4_a16 out nocopy JTF_DATE_TABLE
1765: , p4_a17 out nocopy JTF_DATE_TABLE
1766: , p4_a18 out nocopy JTF_NUMBER_TABLE
1767: , p4_a19 out nocopy JTF_NUMBER_TABLE
1768: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
1769: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
1770: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
1771: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 1879: , p4_a1 out nocopy JTF_NUMBER_TABLE

1875: , p_init_msg_list VARCHAR2
1876: , p_commit VARCHAR2
1877: , p_header_id NUMBER
1878: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
1879: , p4_a1 out nocopy JTF_NUMBER_TABLE
1880: , x_return_status out nocopy VARCHAR2
1881: , x_msg_count out nocopy NUMBER
1882: , x_msg_data out nocopy VARCHAR2
1883: )