3: procedure rosetta_table_copy_in_p4(t out nocopy okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_200
11: ) as
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_200
11: ) as
12: ddindx binary_integer; indx binary_integer;
13: begin
36: procedure rosetta_table_copy_out_p4(t okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_200
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_VARCHAR2_TABLE_200
44: ) as
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_200
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_VARCHAR2_TABLE_200
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_VARCHAR2_TABLE_100();
53: a5 := JTF_VARCHAR2_TABLE_200();
54: a6 := JTF_VARCHAR2_TABLE_100();
55: a7 := JTF_VARCHAR2_TABLE_200();
56: else
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_VARCHAR2_TABLE_100();
53: a5 := JTF_VARCHAR2_TABLE_200();
54: a6 := JTF_VARCHAR2_TABLE_100();
55: a7 := JTF_VARCHAR2_TABLE_200();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_VARCHAR2_TABLE_200();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_200();
65: if t.count > 0 then
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_VARCHAR2_TABLE_200();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_200();
65: if t.count > 0 then
66: a0.extend(t.count);
67: a1.extend(t.count);
98: , p3_a0 out nocopy JTF_NUMBER_TABLE
99: , p3_a1 out nocopy JTF_NUMBER_TABLE
100: , p3_a2 out nocopy JTF_NUMBER_TABLE
101: , p3_a3 out nocopy JTF_NUMBER_TABLE
102: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_200
104: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
105: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_200
106: , x_return_status out nocopy VARCHAR2
100: , p3_a2 out nocopy JTF_NUMBER_TABLE
101: , p3_a3 out nocopy JTF_NUMBER_TABLE
102: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_200
104: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
105: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_200
106: , x_return_status out nocopy VARCHAR2
107: , x_msg_count out nocopy NUMBER
108: , x_msg_data out nocopy VARCHAR2
153: , p2_a0 JTF_NUMBER_TABLE
154: , p2_a1 JTF_NUMBER_TABLE
155: , p2_a2 JTF_NUMBER_TABLE
156: , p2_a3 JTF_NUMBER_TABLE
157: , p2_a4 JTF_VARCHAR2_TABLE_100
158: , p2_a5 JTF_VARCHAR2_TABLE_200
159: , p2_a6 JTF_VARCHAR2_TABLE_100
160: , p2_a7 JTF_VARCHAR2_TABLE_200
161: , x_return_status out nocopy VARCHAR2
155: , p2_a2 JTF_NUMBER_TABLE
156: , p2_a3 JTF_NUMBER_TABLE
157: , p2_a4 JTF_VARCHAR2_TABLE_100
158: , p2_a5 JTF_VARCHAR2_TABLE_200
159: , p2_a6 JTF_VARCHAR2_TABLE_100
160: , p2_a7 JTF_VARCHAR2_TABLE_200
161: , x_return_status out nocopy VARCHAR2
162: , x_msg_count out nocopy NUMBER
163: , x_msg_data out nocopy VARCHAR2