DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_STAGES_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_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_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_DATE_TABLE

Line 19: , a3 JTF_NUMBER_TABLE

15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_DATE_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100

Line 24: , a8 JTF_NUMBER_TABLE

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

Line 26: , a10 JTF_NUMBER_TABLE

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

Line 87: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

83: end loop;
84: end if;
85: end if;
86: end rosetta_table_copy_in_p5;
87: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_NUMBER_TABLE
89: , a2 out nocopy JTF_VARCHAR2_TABLE_100
90: , a3 out nocopy JTF_NUMBER_TABLE
91: , a4 out nocopy JTF_DATE_TABLE

Line 88: , a1 out nocopy JTF_NUMBER_TABLE

84: end if;
85: end if;
86: end rosetta_table_copy_in_p5;
87: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_NUMBER_TABLE
89: , a2 out nocopy JTF_VARCHAR2_TABLE_100
90: , a3 out nocopy JTF_NUMBER_TABLE
91: , a4 out nocopy JTF_DATE_TABLE
92: , a5 out nocopy JTF_DATE_TABLE

Line 90: , a3 out nocopy JTF_NUMBER_TABLE

86: end rosetta_table_copy_in_p5;
87: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_NUMBER_TABLE
89: , a2 out nocopy JTF_VARCHAR2_TABLE_100
90: , a3 out nocopy JTF_NUMBER_TABLE
91: , a4 out nocopy JTF_DATE_TABLE
92: , a5 out nocopy JTF_DATE_TABLE
93: , a6 out nocopy JTF_DATE_TABLE
94: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 95: , a8 out nocopy JTF_NUMBER_TABLE

91: , a4 out nocopy JTF_DATE_TABLE
92: , a5 out nocopy JTF_DATE_TABLE
93: , a6 out nocopy JTF_DATE_TABLE
94: , a7 out nocopy JTF_VARCHAR2_TABLE_100
95: , a8 out nocopy JTF_NUMBER_TABLE
96: , a9 out nocopy JTF_DATE_TABLE
97: , a10 out nocopy JTF_NUMBER_TABLE
98: , a11 out nocopy JTF_VARCHAR2_TABLE_100
99: , a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 97: , a10 out nocopy JTF_NUMBER_TABLE

93: , a6 out nocopy JTF_DATE_TABLE
94: , a7 out nocopy JTF_VARCHAR2_TABLE_100
95: , a8 out nocopy JTF_NUMBER_TABLE
96: , a9 out nocopy JTF_DATE_TABLE
97: , a10 out nocopy JTF_NUMBER_TABLE
98: , a11 out nocopy JTF_VARCHAR2_TABLE_100
99: , a12 out nocopy JTF_VARCHAR2_TABLE_200
100: , a13 out nocopy JTF_VARCHAR2_TABLE_200
101: , a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 118: a0 := JTF_NUMBER_TABLE();

114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_DATE_TABLE();

Line 119: a1 := JTF_NUMBER_TABLE();

115: ddindx binary_integer; indx binary_integer;
116: begin
117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_DATE_TABLE();
123: a5 := JTF_DATE_TABLE();

Line 121: a3 := JTF_NUMBER_TABLE();

117: if t is null or t.count = 0 then
118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_VARCHAR2_TABLE_100();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_DATE_TABLE();
123: a5 := JTF_DATE_TABLE();
124: a6 := JTF_DATE_TABLE();
125: a7 := JTF_VARCHAR2_TABLE_100();

Line 126: a8 := JTF_NUMBER_TABLE();

122: a4 := JTF_DATE_TABLE();
123: a5 := JTF_DATE_TABLE();
124: a6 := JTF_DATE_TABLE();
125: a7 := JTF_VARCHAR2_TABLE_100();
126: a8 := JTF_NUMBER_TABLE();
127: a9 := JTF_DATE_TABLE();
128: a10 := JTF_NUMBER_TABLE();
129: a11 := JTF_VARCHAR2_TABLE_100();
130: a12 := JTF_VARCHAR2_TABLE_200();

Line 128: a10 := JTF_NUMBER_TABLE();

124: a6 := JTF_DATE_TABLE();
125: a7 := JTF_VARCHAR2_TABLE_100();
126: a8 := JTF_NUMBER_TABLE();
127: a9 := JTF_DATE_TABLE();
128: a10 := JTF_NUMBER_TABLE();
129: a11 := JTF_VARCHAR2_TABLE_100();
130: a12 := JTF_VARCHAR2_TABLE_200();
131: a13 := JTF_VARCHAR2_TABLE_200();
132: a14 := JTF_VARCHAR2_TABLE_200();

Line 146: a0 := JTF_NUMBER_TABLE();

142: a24 := JTF_VARCHAR2_TABLE_200();
143: a25 := JTF_VARCHAR2_TABLE_200();
144: a26 := JTF_VARCHAR2_TABLE_200();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_VARCHAR2_TABLE_100();
149: a3 := JTF_NUMBER_TABLE();
150: a4 := JTF_DATE_TABLE();

Line 147: a1 := JTF_NUMBER_TABLE();

143: a25 := JTF_VARCHAR2_TABLE_200();
144: a26 := JTF_VARCHAR2_TABLE_200();
145: else
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_NUMBER_TABLE();
148: a2 := JTF_VARCHAR2_TABLE_100();
149: a3 := JTF_NUMBER_TABLE();
150: a4 := JTF_DATE_TABLE();
151: a5 := JTF_DATE_TABLE();

Line 149: a3 := JTF_NUMBER_TABLE();

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

Line 154: a8 := JTF_NUMBER_TABLE();

150: a4 := JTF_DATE_TABLE();
151: a5 := JTF_DATE_TABLE();
152: a6 := JTF_DATE_TABLE();
153: a7 := JTF_VARCHAR2_TABLE_100();
154: a8 := JTF_NUMBER_TABLE();
155: a9 := JTF_DATE_TABLE();
156: a10 := JTF_NUMBER_TABLE();
157: a11 := JTF_VARCHAR2_TABLE_100();
158: a12 := JTF_VARCHAR2_TABLE_200();

Line 156: a10 := JTF_NUMBER_TABLE();

152: a6 := JTF_DATE_TABLE();
153: a7 := JTF_VARCHAR2_TABLE_100();
154: a8 := JTF_NUMBER_TABLE();
155: a9 := JTF_DATE_TABLE();
156: a10 := JTF_NUMBER_TABLE();
157: a11 := JTF_VARCHAR2_TABLE_100();
158: a12 := JTF_VARCHAR2_TABLE_200();
159: a13 := JTF_VARCHAR2_TABLE_200();
160: a14 := JTF_VARCHAR2_TABLE_200();

Line 241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE

237: end if;
238: end if;
239: end rosetta_table_copy_out_p5;
240:
241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE

Line 242: , a1 JTF_NUMBER_TABLE

238: end if;
239: end rosetta_table_copy_out_p5;
240:
241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE
246: , a5 JTF_NUMBER_TABLE

Line 244: , a3 JTF_NUMBER_TABLE

240:
241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE
246: , a5 JTF_NUMBER_TABLE
247: , a6 JTF_DATE_TABLE
248: , a7 JTF_DATE_TABLE

Line 245: , a4 JTF_NUMBER_TABLE

241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE
246: , a5 JTF_NUMBER_TABLE
247: , a6 JTF_DATE_TABLE
248: , a7 JTF_DATE_TABLE
249: , a8 JTF_DATE_TABLE

Line 246: , a5 JTF_NUMBER_TABLE

242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE
246: , a5 JTF_NUMBER_TABLE
247: , a6 JTF_DATE_TABLE
248: , a7 JTF_DATE_TABLE
249: , a8 JTF_DATE_TABLE
250: ) as

Line 276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

272: end loop;
273: end if;
274: end if;
275: end rosetta_table_copy_in_p6;
276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE

Line 277: , a1 out nocopy JTF_NUMBER_TABLE

273: end if;
274: end if;
275: end rosetta_table_copy_in_p6;
276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE
281: , a5 out nocopy JTF_NUMBER_TABLE

Line 279: , a3 out nocopy JTF_NUMBER_TABLE

275: end rosetta_table_copy_in_p6;
276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE
281: , a5 out nocopy JTF_NUMBER_TABLE
282: , a6 out nocopy JTF_DATE_TABLE
283: , a7 out nocopy JTF_DATE_TABLE

Line 280: , a4 out nocopy JTF_NUMBER_TABLE

276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE
281: , a5 out nocopy JTF_NUMBER_TABLE
282: , a6 out nocopy JTF_DATE_TABLE
283: , a7 out nocopy JTF_DATE_TABLE
284: , a8 out nocopy JTF_DATE_TABLE

Line 281: , a5 out nocopy JTF_NUMBER_TABLE

277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE
281: , a5 out nocopy JTF_NUMBER_TABLE
282: , a6 out nocopy JTF_DATE_TABLE
283: , a7 out nocopy JTF_DATE_TABLE
284: , a8 out nocopy JTF_DATE_TABLE
285: ) as

Line 289: a0 := JTF_NUMBER_TABLE();

285: ) as
286: ddindx binary_integer; indx binary_integer;
287: begin
288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_100();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_NUMBER_TABLE();

Line 290: a1 := JTF_NUMBER_TABLE();

286: ddindx binary_integer; indx binary_integer;
287: begin
288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_100();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();

Line 292: a3 := JTF_NUMBER_TABLE();

288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_100();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_DATE_TABLE();

Line 293: a4 := JTF_NUMBER_TABLE();

289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_100();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_DATE_TABLE();
297: a8 := JTF_DATE_TABLE();

Line 294: a5 := JTF_NUMBER_TABLE();

290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_100();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_DATE_TABLE();
297: a8 := JTF_DATE_TABLE();
298: else

Line 299: a0 := JTF_NUMBER_TABLE();

295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_DATE_TABLE();
297: a8 := JTF_DATE_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();

Line 300: a1 := JTF_NUMBER_TABLE();

296: a7 := JTF_DATE_TABLE();
297: a8 := JTF_DATE_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();

Line 302: a3 := JTF_NUMBER_TABLE();

298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_DATE_TABLE();
306: a7 := JTF_DATE_TABLE();

Line 303: a4 := JTF_NUMBER_TABLE();

299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_DATE_TABLE();
306: a7 := JTF_DATE_TABLE();
307: a8 := JTF_DATE_TABLE();

Line 304: a5 := JTF_NUMBER_TABLE();

300: a1 := JTF_NUMBER_TABLE();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_NUMBER_TABLE();
303: a4 := JTF_NUMBER_TABLE();
304: a5 := JTF_NUMBER_TABLE();
305: a6 := JTF_DATE_TABLE();
306: a7 := JTF_DATE_TABLE();
307: a8 := JTF_DATE_TABLE();
308: if t.count > 0 then

Line 340: procedure rosetta_table_copy_in_p7(t out nocopy ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 JTF_NUMBER_TABLE

336: end if;
337: end if;
338: end rosetta_table_copy_out_p6;
339:
340: procedure rosetta_table_copy_in_p7(t out nocopy ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 JTF_NUMBER_TABLE
341: , a1 JTF_NUMBER_TABLE
342: , a2 JTF_VARCHAR2_TABLE_100
343: , a3 JTF_VARCHAR2_TABLE_100
344: ) as

Line 341: , a1 JTF_NUMBER_TABLE

337: end if;
338: end rosetta_table_copy_out_p6;
339:
340: procedure rosetta_table_copy_in_p7(t out nocopy ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 JTF_NUMBER_TABLE
341: , a1 JTF_NUMBER_TABLE
342: , a2 JTF_VARCHAR2_TABLE_100
343: , a3 JTF_VARCHAR2_TABLE_100
344: ) as
345: ddindx binary_integer; indx binary_integer;

Line 365: procedure rosetta_table_copy_out_p7(t ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

361: end loop;
362: end if;
363: end if;
364: end rosetta_table_copy_in_p7;
365: procedure rosetta_table_copy_out_p7(t ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
366: , a1 out nocopy JTF_NUMBER_TABLE
367: , a2 out nocopy JTF_VARCHAR2_TABLE_100
368: , a3 out nocopy JTF_VARCHAR2_TABLE_100
369: ) as

Line 366: , a1 out nocopy JTF_NUMBER_TABLE

362: end if;
363: end if;
364: end rosetta_table_copy_in_p7;
365: procedure rosetta_table_copy_out_p7(t ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
366: , a1 out nocopy JTF_NUMBER_TABLE
367: , a2 out nocopy JTF_VARCHAR2_TABLE_100
368: , a3 out nocopy JTF_VARCHAR2_TABLE_100
369: ) as
370: ddindx binary_integer; indx binary_integer;

Line 373: a0 := JTF_NUMBER_TABLE();

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

Line 374: a1 := JTF_NUMBER_TABLE();

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

Line 378: a0 := JTF_NUMBER_TABLE();

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

Line 379: a1 := JTF_NUMBER_TABLE();

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

Line 404: procedure rosetta_table_copy_in_p8(t out nocopy ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 JTF_NUMBER_TABLE

400: end if;
401: end if;
402: end rosetta_table_copy_out_p7;
403:
404: procedure rosetta_table_copy_in_p8(t out nocopy ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 JTF_NUMBER_TABLE
405: , a1 JTF_NUMBER_TABLE
406: , a2 JTF_VARCHAR2_TABLE_100
407: ) as
408: ddindx binary_integer; indx binary_integer;

Line 405: , a1 JTF_NUMBER_TABLE

401: end if;
402: end rosetta_table_copy_out_p7;
403:
404: procedure rosetta_table_copy_in_p8(t out nocopy ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 JTF_NUMBER_TABLE
405: , a1 JTF_NUMBER_TABLE
406: , a2 JTF_VARCHAR2_TABLE_100
407: ) as
408: ddindx binary_integer; indx binary_integer;
409: begin

Line 427: procedure rosetta_table_copy_out_p8(t ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

423: end loop;
424: end if;
425: end if;
426: end rosetta_table_copy_in_p8;
427: procedure rosetta_table_copy_out_p8(t ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
428: , a1 out nocopy JTF_NUMBER_TABLE
429: , a2 out nocopy JTF_VARCHAR2_TABLE_100
430: ) as
431: ddindx binary_integer; indx binary_integer;

Line 428: , a1 out nocopy JTF_NUMBER_TABLE

424: end if;
425: end if;
426: end rosetta_table_copy_in_p8;
427: procedure rosetta_table_copy_out_p8(t ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
428: , a1 out nocopy JTF_NUMBER_TABLE
429: , a2 out nocopy JTF_VARCHAR2_TABLE_100
430: ) as
431: ddindx binary_integer; indx binary_integer;
432: begin

Line 434: a0 := JTF_NUMBER_TABLE();

430: ) as
431: ddindx binary_integer; indx binary_integer;
432: begin
433: if t is null or t.count = 0 then
434: a0 := JTF_NUMBER_TABLE();
435: a1 := JTF_NUMBER_TABLE();
436: a2 := JTF_VARCHAR2_TABLE_100();
437: else
438: a0 := JTF_NUMBER_TABLE();

Line 435: a1 := JTF_NUMBER_TABLE();

431: ddindx binary_integer; indx binary_integer;
432: begin
433: if t is null or t.count = 0 then
434: a0 := JTF_NUMBER_TABLE();
435: a1 := JTF_NUMBER_TABLE();
436: a2 := JTF_VARCHAR2_TABLE_100();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();

Line 438: a0 := JTF_NUMBER_TABLE();

434: a0 := JTF_NUMBER_TABLE();
435: a1 := JTF_NUMBER_TABLE();
436: a2 := JTF_VARCHAR2_TABLE_100();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: if t.count > 0 then
442: a0.extend(t.count);

Line 439: a1 := JTF_NUMBER_TABLE();

435: a1 := JTF_NUMBER_TABLE();
436: a2 := JTF_VARCHAR2_TABLE_100();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: if t.count > 0 then
442: a0.extend(t.count);
443: a1.extend(t.count);

Line 461: procedure rosetta_table_copy_in_p9(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 JTF_NUMBER_TABLE

457: end if;
458: end if;
459: end rosetta_table_copy_out_p8;
460:
461: procedure rosetta_table_copy_in_p9(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 JTF_NUMBER_TABLE
462: , a1 JTF_NUMBER_TABLE
463: ) as
464: ddindx binary_integer; indx binary_integer;
465: begin

Line 462: , a1 JTF_NUMBER_TABLE

458: end if;
459: end rosetta_table_copy_out_p8;
460:
461: procedure rosetta_table_copy_in_p9(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 JTF_NUMBER_TABLE
462: , a1 JTF_NUMBER_TABLE
463: ) as
464: ddindx binary_integer; indx binary_integer;
465: begin
466: if a0 is not null and a0.count > 0 then

Line 482: procedure rosetta_table_copy_out_p9(t ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

478: end loop;
479: end if;
480: end if;
481: end rosetta_table_copy_in_p9;
482: procedure rosetta_table_copy_out_p9(t ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
483: , a1 out nocopy JTF_NUMBER_TABLE
484: ) as
485: ddindx binary_integer; indx binary_integer;
486: begin

Line 483: , a1 out nocopy JTF_NUMBER_TABLE

479: end if;
480: end if;
481: end rosetta_table_copy_in_p9;
482: procedure rosetta_table_copy_out_p9(t ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
483: , a1 out nocopy JTF_NUMBER_TABLE
484: ) as
485: ddindx binary_integer; indx binary_integer;
486: begin
487: if t is null or t.count = 0 then

Line 488: a0 := JTF_NUMBER_TABLE();

484: ) as
485: ddindx binary_integer; indx binary_integer;
486: begin
487: if t is null or t.count = 0 then
488: a0 := JTF_NUMBER_TABLE();
489: a1 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();

Line 489: a1 := JTF_NUMBER_TABLE();

485: ddindx binary_integer; indx binary_integer;
486: begin
487: if t is null or t.count = 0 then
488: a0 := JTF_NUMBER_TABLE();
489: a1 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: if t.count > 0 then

Line 491: a0 := JTF_NUMBER_TABLE();

487: if t is null or t.count = 0 then
488: a0 := JTF_NUMBER_TABLE();
489: a1 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: if t.count > 0 then
494: a0.extend(t.count);
495: a1.extend(t.count);

Line 492: a1 := JTF_NUMBER_TABLE();

488: a0 := JTF_NUMBER_TABLE();
489: a1 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: if t.count > 0 then
494: a0.extend(t.count);
495: a1.extend(t.count);
496: ddindx := t.first;

Line 517: , p6_a0 in out nocopy JTF_NUMBER_TABLE

513: , p_commit VARCHAR2
514: , p_validation_level NUMBER
515: , p_module_type VARCHAR2
516: , p_visit_id NUMBER
517: , p6_a0 in out nocopy JTF_NUMBER_TABLE
518: , p6_a1 in out nocopy JTF_NUMBER_TABLE
519: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a3 in out nocopy JTF_NUMBER_TABLE
521: , p6_a4 in out nocopy JTF_DATE_TABLE

Line 518: , p6_a1 in out nocopy JTF_NUMBER_TABLE

514: , p_validation_level NUMBER
515: , p_module_type VARCHAR2
516: , p_visit_id NUMBER
517: , p6_a0 in out nocopy JTF_NUMBER_TABLE
518: , p6_a1 in out nocopy JTF_NUMBER_TABLE
519: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a3 in out nocopy JTF_NUMBER_TABLE
521: , p6_a4 in out nocopy JTF_DATE_TABLE
522: , p6_a5 in out nocopy JTF_DATE_TABLE

Line 520: , p6_a3 in out nocopy JTF_NUMBER_TABLE

516: , p_visit_id NUMBER
517: , p6_a0 in out nocopy JTF_NUMBER_TABLE
518: , p6_a1 in out nocopy JTF_NUMBER_TABLE
519: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a3 in out nocopy JTF_NUMBER_TABLE
521: , p6_a4 in out nocopy JTF_DATE_TABLE
522: , p6_a5 in out nocopy JTF_DATE_TABLE
523: , p6_a6 in out nocopy JTF_DATE_TABLE
524: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 525: , p6_a8 in out nocopy JTF_NUMBER_TABLE

521: , p6_a4 in out nocopy JTF_DATE_TABLE
522: , p6_a5 in out nocopy JTF_DATE_TABLE
523: , p6_a6 in out nocopy JTF_DATE_TABLE
524: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a8 in out nocopy JTF_NUMBER_TABLE
526: , p6_a9 in out nocopy JTF_DATE_TABLE
527: , p6_a10 in out nocopy JTF_NUMBER_TABLE
528: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200

Line 527: , p6_a10 in out nocopy JTF_NUMBER_TABLE

523: , p6_a6 in out nocopy JTF_DATE_TABLE
524: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a8 in out nocopy JTF_NUMBER_TABLE
526: , p6_a9 in out nocopy JTF_DATE_TABLE
527: , p6_a10 in out nocopy JTF_NUMBER_TABLE
528: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
530: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
531: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200

Line 544: , p7_a0 in out nocopy JTF_NUMBER_TABLE

540: , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_200
541: , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
542: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_200
543: , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_200
544: , p7_a0 in out nocopy JTF_NUMBER_TABLE
545: , p7_a1 in out nocopy JTF_NUMBER_TABLE
546: , x_return_status out nocopy VARCHAR2
547: , x_msg_count out nocopy NUMBER
548: , x_msg_data out nocopy VARCHAR2

Line 545: , p7_a1 in out nocopy JTF_NUMBER_TABLE

541: , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
542: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_200
543: , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_200
544: , p7_a0 in out nocopy JTF_NUMBER_TABLE
545: , p7_a1 in out nocopy JTF_NUMBER_TABLE
546: , x_return_status out nocopy VARCHAR2
547: , x_msg_count out nocopy NUMBER
548: , x_msg_data out nocopy VARCHAR2
549: )

Line 665: , p8_a0 out nocopy JTF_NUMBER_TABLE

661: , p_module_type VARCHAR2
662: , p_visit_id NUMBER
663: , p_start_row NUMBER
664: , p_rows_per_page NUMBER
665: , p8_a0 out nocopy JTF_NUMBER_TABLE
666: , p8_a1 out nocopy JTF_NUMBER_TABLE
667: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
668: , p8_a3 out nocopy JTF_NUMBER_TABLE
669: , p8_a4 out nocopy JTF_DATE_TABLE

Line 666: , p8_a1 out nocopy JTF_NUMBER_TABLE

662: , p_visit_id NUMBER
663: , p_start_row NUMBER
664: , p_rows_per_page NUMBER
665: , p8_a0 out nocopy JTF_NUMBER_TABLE
666: , p8_a1 out nocopy JTF_NUMBER_TABLE
667: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
668: , p8_a3 out nocopy JTF_NUMBER_TABLE
669: , p8_a4 out nocopy JTF_DATE_TABLE
670: , p8_a5 out nocopy JTF_DATE_TABLE

Line 668: , p8_a3 out nocopy JTF_NUMBER_TABLE

664: , p_rows_per_page NUMBER
665: , p8_a0 out nocopy JTF_NUMBER_TABLE
666: , p8_a1 out nocopy JTF_NUMBER_TABLE
667: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
668: , p8_a3 out nocopy JTF_NUMBER_TABLE
669: , p8_a4 out nocopy JTF_DATE_TABLE
670: , p8_a5 out nocopy JTF_DATE_TABLE
671: , p8_a6 out nocopy JTF_DATE_TABLE
672: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 673: , p8_a8 out nocopy JTF_NUMBER_TABLE

669: , p8_a4 out nocopy JTF_DATE_TABLE
670: , p8_a5 out nocopy JTF_DATE_TABLE
671: , p8_a6 out nocopy JTF_DATE_TABLE
672: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
673: , p8_a8 out nocopy JTF_NUMBER_TABLE
674: , p8_a9 out nocopy JTF_DATE_TABLE
675: , p8_a10 out nocopy JTF_NUMBER_TABLE
676: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
677: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 675: , p8_a10 out nocopy JTF_NUMBER_TABLE

671: , p8_a6 out nocopy JTF_DATE_TABLE
672: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
673: , p8_a8 out nocopy JTF_NUMBER_TABLE
674: , p8_a9 out nocopy JTF_DATE_TABLE
675: , p8_a10 out nocopy JTF_NUMBER_TABLE
676: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
677: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
678: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_200
679: , p8_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 781: , p6_a0 in out nocopy JTF_NUMBER_TABLE

777: , p_commit VARCHAR2
778: , p_validation_level NUMBER
779: , p_module_type VARCHAR2
780: , p_visit_id NUMBER
781: , p6_a0 in out nocopy JTF_NUMBER_TABLE
782: , p6_a1 in out nocopy JTF_NUMBER_TABLE
783: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
784: , p6_a3 in out nocopy JTF_NUMBER_TABLE
785: , p6_a4 in out nocopy JTF_DATE_TABLE

Line 782: , p6_a1 in out nocopy JTF_NUMBER_TABLE

778: , p_validation_level NUMBER
779: , p_module_type VARCHAR2
780: , p_visit_id NUMBER
781: , p6_a0 in out nocopy JTF_NUMBER_TABLE
782: , p6_a1 in out nocopy JTF_NUMBER_TABLE
783: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
784: , p6_a3 in out nocopy JTF_NUMBER_TABLE
785: , p6_a4 in out nocopy JTF_DATE_TABLE
786: , p6_a5 in out nocopy JTF_DATE_TABLE

Line 784: , p6_a3 in out nocopy JTF_NUMBER_TABLE

780: , p_visit_id NUMBER
781: , p6_a0 in out nocopy JTF_NUMBER_TABLE
782: , p6_a1 in out nocopy JTF_NUMBER_TABLE
783: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
784: , p6_a3 in out nocopy JTF_NUMBER_TABLE
785: , p6_a4 in out nocopy JTF_DATE_TABLE
786: , p6_a5 in out nocopy JTF_DATE_TABLE
787: , p6_a6 in out nocopy JTF_DATE_TABLE
788: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 789: , p6_a8 in out nocopy JTF_NUMBER_TABLE

785: , p6_a4 in out nocopy JTF_DATE_TABLE
786: , p6_a5 in out nocopy JTF_DATE_TABLE
787: , p6_a6 in out nocopy JTF_DATE_TABLE
788: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
789: , p6_a8 in out nocopy JTF_NUMBER_TABLE
790: , p6_a9 in out nocopy JTF_DATE_TABLE
791: , p6_a10 in out nocopy JTF_NUMBER_TABLE
792: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200

Line 791: , p6_a10 in out nocopy JTF_NUMBER_TABLE

787: , p6_a6 in out nocopy JTF_DATE_TABLE
788: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
789: , p6_a8 in out nocopy JTF_NUMBER_TABLE
790: , p6_a9 in out nocopy JTF_DATE_TABLE
791: , p6_a10 in out nocopy JTF_NUMBER_TABLE
792: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
793: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
794: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
795: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200

Line 915: , p6_a0 in out nocopy JTF_NUMBER_TABLE

911: , p_commit VARCHAR2
912: , p_validation_level NUMBER
913: , p_module_type VARCHAR2
914: , p_visit_id NUMBER
915: , p6_a0 in out nocopy JTF_NUMBER_TABLE
916: , p6_a1 in out nocopy JTF_NUMBER_TABLE
917: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a3 in out nocopy JTF_NUMBER_TABLE
919: , p6_a4 in out nocopy JTF_DATE_TABLE

Line 916: , p6_a1 in out nocopy JTF_NUMBER_TABLE

912: , p_validation_level NUMBER
913: , p_module_type VARCHAR2
914: , p_visit_id NUMBER
915: , p6_a0 in out nocopy JTF_NUMBER_TABLE
916: , p6_a1 in out nocopy JTF_NUMBER_TABLE
917: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a3 in out nocopy JTF_NUMBER_TABLE
919: , p6_a4 in out nocopy JTF_DATE_TABLE
920: , p6_a5 in out nocopy JTF_DATE_TABLE

Line 918: , p6_a3 in out nocopy JTF_NUMBER_TABLE

914: , p_visit_id NUMBER
915: , p6_a0 in out nocopy JTF_NUMBER_TABLE
916: , p6_a1 in out nocopy JTF_NUMBER_TABLE
917: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a3 in out nocopy JTF_NUMBER_TABLE
919: , p6_a4 in out nocopy JTF_DATE_TABLE
920: , p6_a5 in out nocopy JTF_DATE_TABLE
921: , p6_a6 in out nocopy JTF_DATE_TABLE
922: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 923: , p6_a8 in out nocopy JTF_NUMBER_TABLE

919: , p6_a4 in out nocopy JTF_DATE_TABLE
920: , p6_a5 in out nocopy JTF_DATE_TABLE
921: , p6_a6 in out nocopy JTF_DATE_TABLE
922: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
923: , p6_a8 in out nocopy JTF_NUMBER_TABLE
924: , p6_a9 in out nocopy JTF_DATE_TABLE
925: , p6_a10 in out nocopy JTF_NUMBER_TABLE
926: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
927: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200

Line 925: , p6_a10 in out nocopy JTF_NUMBER_TABLE

921: , p6_a6 in out nocopy JTF_DATE_TABLE
922: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
923: , p6_a8 in out nocopy JTF_NUMBER_TABLE
924: , p6_a9 in out nocopy JTF_DATE_TABLE
925: , p6_a10 in out nocopy JTF_NUMBER_TABLE
926: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
927: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
928: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
929: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1047: , p4_a0 JTF_NUMBER_TABLE

1043: procedure process_stagetyp_assoc(p_api_version NUMBER
1044: , p_init_msg_list VARCHAR2
1045: , p_commit VARCHAR2
1046: , p_validation_level NUMBER
1047: , p4_a0 JTF_NUMBER_TABLE
1048: , p4_a1 JTF_NUMBER_TABLE
1049: , p4_a2 JTF_VARCHAR2_TABLE_100
1050: , p4_a3 JTF_VARCHAR2_TABLE_100
1051: , x_return_status out nocopy VARCHAR2

Line 1048: , p4_a1 JTF_NUMBER_TABLE

1044: , p_init_msg_list VARCHAR2
1045: , p_commit VARCHAR2
1046: , p_validation_level NUMBER
1047: , p4_a0 JTF_NUMBER_TABLE
1048: , p4_a1 JTF_NUMBER_TABLE
1049: , p4_a2 JTF_VARCHAR2_TABLE_100
1050: , p4_a3 JTF_VARCHAR2_TABLE_100
1051: , x_return_status out nocopy VARCHAR2
1052: , x_msg_count out nocopy NUMBER