18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy okl_cure_req_amt_pvt.cure_req_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: ) as
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy okl_cure_req_amt_pvt.cure_req_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy okl_cure_req_amt_pvt.cure_req_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy okl_cure_req_amt_pvt.cure_req_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if a0 is not null and a0.count > 0 then
43: end loop;
44: end if;
45: end if;
46: end rosetta_table_copy_in_p3;
47: procedure rosetta_table_copy_out_p3(t okl_cure_req_amt_pvt.cure_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as
44: end if;
45: end if;
46: end rosetta_table_copy_in_p3;
47: procedure rosetta_table_copy_out_p3(t okl_cure_req_amt_pvt.cure_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
45: end if;
46: end rosetta_table_copy_in_p3;
47: procedure rosetta_table_copy_out_p3(t okl_cure_req_amt_pvt.cure_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
46: end rosetta_table_copy_in_p3;
47: procedure rosetta_table_copy_out_p3(t okl_cure_req_amt_pvt.cure_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then
57: a2 := JTF_NUMBER_TABLE();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then
65: a0.extend(t.count);
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then
65: a0.extend(t.count);
66: a1.extend(t.count);
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then
65: a0.extend(t.count);
66: a1.extend(t.count);
67: a2.extend(t.count);
87: , p_init_msg_list VARCHAR2
88: , x_return_status out nocopy VARCHAR2
89: , x_msg_count out nocopy NUMBER
90: , x_msg_data out nocopy VARCHAR2
91: , p5_a0 JTF_NUMBER_TABLE
92: , p5_a1 JTF_NUMBER_TABLE
93: , p5_a2 JTF_NUMBER_TABLE
94: , p5_a3 JTF_NUMBER_TABLE
95: , p6_a0 out nocopy JTF_NUMBER_TABLE
88: , x_return_status out nocopy VARCHAR2
89: , x_msg_count out nocopy NUMBER
90: , x_msg_data out nocopy VARCHAR2
91: , p5_a0 JTF_NUMBER_TABLE
92: , p5_a1 JTF_NUMBER_TABLE
93: , p5_a2 JTF_NUMBER_TABLE
94: , p5_a3 JTF_NUMBER_TABLE
95: , p6_a0 out nocopy JTF_NUMBER_TABLE
96: , p6_a1 out nocopy JTF_NUMBER_TABLE
89: , x_msg_count out nocopy NUMBER
90: , x_msg_data out nocopy VARCHAR2
91: , p5_a0 JTF_NUMBER_TABLE
92: , p5_a1 JTF_NUMBER_TABLE
93: , p5_a2 JTF_NUMBER_TABLE
94: , p5_a3 JTF_NUMBER_TABLE
95: , p6_a0 out nocopy JTF_NUMBER_TABLE
96: , p6_a1 out nocopy JTF_NUMBER_TABLE
97: , p6_a2 out nocopy JTF_NUMBER_TABLE
90: , x_msg_data out nocopy VARCHAR2
91: , p5_a0 JTF_NUMBER_TABLE
92: , p5_a1 JTF_NUMBER_TABLE
93: , p5_a2 JTF_NUMBER_TABLE
94: , p5_a3 JTF_NUMBER_TABLE
95: , p6_a0 out nocopy JTF_NUMBER_TABLE
96: , p6_a1 out nocopy JTF_NUMBER_TABLE
97: , p6_a2 out nocopy JTF_NUMBER_TABLE
98: , p6_a3 out nocopy JTF_NUMBER_TABLE
91: , p5_a0 JTF_NUMBER_TABLE
92: , p5_a1 JTF_NUMBER_TABLE
93: , p5_a2 JTF_NUMBER_TABLE
94: , p5_a3 JTF_NUMBER_TABLE
95: , p6_a0 out nocopy JTF_NUMBER_TABLE
96: , p6_a1 out nocopy JTF_NUMBER_TABLE
97: , p6_a2 out nocopy JTF_NUMBER_TABLE
98: , p6_a3 out nocopy JTF_NUMBER_TABLE
99: )
92: , p5_a1 JTF_NUMBER_TABLE
93: , p5_a2 JTF_NUMBER_TABLE
94: , p5_a3 JTF_NUMBER_TABLE
95: , p6_a0 out nocopy JTF_NUMBER_TABLE
96: , p6_a1 out nocopy JTF_NUMBER_TABLE
97: , p6_a2 out nocopy JTF_NUMBER_TABLE
98: , p6_a3 out nocopy JTF_NUMBER_TABLE
99: )
100:
93: , p5_a2 JTF_NUMBER_TABLE
94: , p5_a3 JTF_NUMBER_TABLE
95: , p6_a0 out nocopy JTF_NUMBER_TABLE
96: , p6_a1 out nocopy JTF_NUMBER_TABLE
97: , p6_a2 out nocopy JTF_NUMBER_TABLE
98: , p6_a3 out nocopy JTF_NUMBER_TABLE
99: )
100:
101: as
94: , p5_a3 JTF_NUMBER_TABLE
95: , p6_a0 out nocopy JTF_NUMBER_TABLE
96: , p6_a1 out nocopy JTF_NUMBER_TABLE
97: , p6_a2 out nocopy JTF_NUMBER_TABLE
98: , p6_a3 out nocopy JTF_NUMBER_TABLE
99: )
100:
101: as
102: ddp_cure_req_tbl okl_cure_req_amt_pvt.cure_req_tbl_type;