18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p14(t out nocopy okl_misc_trans_pvt.jrnl_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p14(t out nocopy okl_misc_trans_pvt.jrnl_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p14(t out nocopy okl_misc_trans_pvt.jrnl_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
21:
22: procedure rosetta_table_copy_in_p14(t out nocopy okl_misc_trans_pvt.jrnl_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_200
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_200
30: , a8 JTF_NUMBER_TABLE
31: ) as
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_200
30: , a8 JTF_NUMBER_TABLE
31: ) as
32: ddindx binary_integer; indx binary_integer;
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_200
30: , a8 JTF_NUMBER_TABLE
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
34: if a0 is not null and a0.count > 0 then
53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p14;
57: procedure rosetta_table_copy_out_p14(t okl_misc_trans_pvt.jrnl_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
54: end if;
55: end if;
56: end rosetta_table_copy_in_p14;
57: procedure rosetta_table_copy_out_p14(t okl_misc_trans_pvt.jrnl_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
55: end if;
56: end rosetta_table_copy_in_p14;
57: procedure rosetta_table_copy_out_p14(t okl_misc_trans_pvt.jrnl_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_NUMBER_TABLE
56: end rosetta_table_copy_in_p14;
57: procedure rosetta_table_copy_out_p14(t okl_misc_trans_pvt.jrnl_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_NUMBER_TABLE
64: , a7 out nocopy JTF_VARCHAR2_TABLE_200
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_NUMBER_TABLE
64: , a7 out nocopy JTF_VARCHAR2_TABLE_200
65: , a8 out nocopy JTF_NUMBER_TABLE
66: ) as
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_NUMBER_TABLE
64: , a7 out nocopy JTF_VARCHAR2_TABLE_200
65: , a8 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_NUMBER_TABLE
64: , a7 out nocopy JTF_VARCHAR2_TABLE_200
65: , a8 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_200();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_200();
78: a8 := JTF_NUMBER_TABLE();
79: else
72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_200();
78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_2000();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_200();
78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_VARCHAR2_TABLE_200();
78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
77: a7 := JTF_VARCHAR2_TABLE_200();
78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_NUMBER_TABLE();
87: a7 := JTF_VARCHAR2_TABLE_200();
81: a1 := JTF_NUMBER_TABLE();
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_NUMBER_TABLE();
87: a7 := JTF_VARCHAR2_TABLE_200();
88: a8 := JTF_NUMBER_TABLE();
89: if t.count > 0 then
82: a2 := JTF_NUMBER_TABLE();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_NUMBER_TABLE();
87: a7 := JTF_VARCHAR2_TABLE_200();
88: a8 := JTF_NUMBER_TABLE();
89: if t.count > 0 then
90: a0.extend(t.count);
84: a4 := JTF_VARCHAR2_TABLE_2000();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_NUMBER_TABLE();
87: a7 := JTF_VARCHAR2_TABLE_200();
88: a8 := JTF_NUMBER_TABLE();
89: if t.count > 0 then
90: a0.extend(t.count);
91: a1.extend(t.count);
92: a2.extend(t.count);
456: , p_init_msg_list VARCHAR2
457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: , p6_a0 JTF_NUMBER_TABLE
461: , p6_a1 JTF_NUMBER_TABLE
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: , p6_a0 JTF_NUMBER_TABLE
461: , p6_a1 JTF_NUMBER_TABLE
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: , p6_a0 JTF_NUMBER_TABLE
461: , p6_a1 JTF_NUMBER_TABLE
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
466: , p6_a6 JTF_NUMBER_TABLE
459: , x_msg_data out nocopy VARCHAR2
460: , p6_a0 JTF_NUMBER_TABLE
461: , p6_a1 JTF_NUMBER_TABLE
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
466: , p6_a6 JTF_NUMBER_TABLE
467: , p6_a7 JTF_VARCHAR2_TABLE_200
461: , p6_a1 JTF_NUMBER_TABLE
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
466: , p6_a6 JTF_NUMBER_TABLE
467: , p6_a7 JTF_VARCHAR2_TABLE_200
468: , p6_a8 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy NUMBER
462: , p6_a2 JTF_NUMBER_TABLE
463: , p6_a3 JTF_NUMBER_TABLE
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
466: , p6_a6 JTF_NUMBER_TABLE
467: , p6_a7 JTF_VARCHAR2_TABLE_200
468: , p6_a8 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy NUMBER
470: , p7_a1 out nocopy NUMBER
464: , p6_a4 JTF_VARCHAR2_TABLE_2000
465: , p6_a5 JTF_NUMBER_TABLE
466: , p6_a6 JTF_NUMBER_TABLE
467: , p6_a7 JTF_VARCHAR2_TABLE_200
468: , p6_a8 JTF_NUMBER_TABLE
469: , p7_a0 out nocopy NUMBER
470: , p7_a1 out nocopy NUMBER
471: , p7_a2 out nocopy NUMBER
472: , p7_a3 out nocopy NUMBER
554: , p_init_msg_list VARCHAR2
555: , x_return_status out nocopy VARCHAR2
556: , x_msg_count out nocopy NUMBER
557: , x_msg_data out nocopy VARCHAR2
558: , p6_a0 JTF_NUMBER_TABLE
559: , p6_a1 JTF_NUMBER_TABLE
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
555: , x_return_status out nocopy VARCHAR2
556: , x_msg_count out nocopy NUMBER
557: , x_msg_data out nocopy VARCHAR2
558: , p6_a0 JTF_NUMBER_TABLE
559: , p6_a1 JTF_NUMBER_TABLE
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
556: , x_msg_count out nocopy NUMBER
557: , x_msg_data out nocopy VARCHAR2
558: , p6_a0 JTF_NUMBER_TABLE
559: , p6_a1 JTF_NUMBER_TABLE
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
564: , p6_a6 JTF_NUMBER_TABLE
557: , x_msg_data out nocopy VARCHAR2
558: , p6_a0 JTF_NUMBER_TABLE
559: , p6_a1 JTF_NUMBER_TABLE
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
564: , p6_a6 JTF_NUMBER_TABLE
565: , p6_a7 JTF_VARCHAR2_TABLE_200
559: , p6_a1 JTF_NUMBER_TABLE
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
564: , p6_a6 JTF_NUMBER_TABLE
565: , p6_a7 JTF_VARCHAR2_TABLE_200
566: , p6_a8 JTF_NUMBER_TABLE
567: , p5_a0 NUMBER := 0-1962.0724
560: , p6_a2 JTF_NUMBER_TABLE
561: , p6_a3 JTF_NUMBER_TABLE
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
564: , p6_a6 JTF_NUMBER_TABLE
565: , p6_a7 JTF_VARCHAR2_TABLE_200
566: , p6_a8 JTF_NUMBER_TABLE
567: , p5_a0 NUMBER := 0-1962.0724
568: , p5_a1 NUMBER := 0-1962.0724
562: , p6_a4 JTF_VARCHAR2_TABLE_2000
563: , p6_a5 JTF_NUMBER_TABLE
564: , p6_a6 JTF_NUMBER_TABLE
565: , p6_a7 JTF_VARCHAR2_TABLE_200
566: , p6_a8 JTF_NUMBER_TABLE
567: , p5_a0 NUMBER := 0-1962.0724
568: , p5_a1 NUMBER := 0-1962.0724
569: , p5_a2 NUMBER := 0-1962.0724
570: , p5_a3 NUMBER := 0-1962.0724