327: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE
328: , a1 JTF_NUMBER_TABLE
329: , a2 JTF_NUMBER_TABLE
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_400
332: , a5 JTF_VARCHAR2_TABLE_100
333: , a6 JTF_DATE_TABLE
334: , a7 JTF_DATE_TABLE
335: ) as
360: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_NUMBER_TABLE
363: , a3 out nocopy JTF_VARCHAR2_TABLE_100
364: , a4 out nocopy JTF_VARCHAR2_TABLE_400
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_DATE_TABLE
367: , a7 out nocopy JTF_DATE_TABLE
368: ) as
372: a0 := JTF_NUMBER_TABLE();
373: a1 := JTF_NUMBER_TABLE();
374: a2 := JTF_NUMBER_TABLE();
375: a3 := JTF_VARCHAR2_TABLE_100();
376: a4 := JTF_VARCHAR2_TABLE_400();
377: a5 := JTF_VARCHAR2_TABLE_100();
378: a6 := JTF_DATE_TABLE();
379: a7 := JTF_DATE_TABLE();
380: else
381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_NUMBER_TABLE();
383: a2 := JTF_NUMBER_TABLE();
384: a3 := JTF_VARCHAR2_TABLE_100();
385: a4 := JTF_VARCHAR2_TABLE_400();
386: a5 := JTF_VARCHAR2_TABLE_100();
387: a6 := JTF_DATE_TABLE();
388: a7 := JTF_DATE_TABLE();
389: if t.count > 0 then
1199: , p4_a0 out nocopy JTF_NUMBER_TABLE
1200: , p4_a1 out nocopy JTF_NUMBER_TABLE
1201: , p4_a2 out nocopy JTF_NUMBER_TABLE
1202: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1203: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
1204: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1205: , p4_a6 out nocopy JTF_DATE_TABLE
1206: , p4_a7 out nocopy JTF_DATE_TABLE
1207: )