1: package body inv_transaction_flow_pub_w as
2: /* $Header: INVWICTB.pls 115.1 2003/12/18 16:13:46 sthamman noship $ */
3: procedure rosetta_table_copy_in_p9(t out nocopy inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package body inv_transaction_flow_pub_w as
2: /* $Header: INVWICTB.pls 115.1 2003/12/18 16:13:46 sthamman noship $ */
3: procedure rosetta_table_copy_in_p9(t out nocopy inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package body inv_transaction_flow_pub_w as
2: /* $Header: INVWICTB.pls 115.1 2003/12/18 16:13:46 sthamman noship $ */
3: procedure rosetta_table_copy_in_p9(t out nocopy inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: INVWICTB.pls 115.1 2003/12/18 16:13:46 sthamman noship $ */
3: procedure rosetta_table_copy_in_p9(t out nocopy inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p9(t out nocopy inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: ) as
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin
32: if a0 is not null and a0.count > 0 then
68: end loop;
69: end if;
70: end if;
71: end rosetta_table_copy_in_p9;
72: procedure rosetta_table_copy_out_p9(t inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
69: end if;
70: end if;
71: end rosetta_table_copy_in_p9;
72: procedure rosetta_table_copy_out_p9(t inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
70: end if;
71: end rosetta_table_copy_in_p9;
72: procedure rosetta_table_copy_out_p9(t inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
71: end rosetta_table_copy_in_p9;
72: procedure rosetta_table_copy_out_p9(t inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE
72: procedure rosetta_table_copy_out_p9(t inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_NUMBER_TABLE
81: , a9 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_NUMBER_TABLE
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_NUMBER_TABLE
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_DATE_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_NUMBER_TABLE
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_DATE_TABLE
84: , a12 out nocopy JTF_DATE_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_NUMBER_TABLE
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_DATE_TABLE
84: , a12 out nocopy JTF_DATE_TABLE
85: , a13 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_NUMBER_TABLE
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_DATE_TABLE
84: , a12 out nocopy JTF_DATE_TABLE
85: , a13 out nocopy JTF_NUMBER_TABLE
86: , a14 out nocopy JTF_NUMBER_TABLE
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_DATE_TABLE
84: , a12 out nocopy JTF_DATE_TABLE
85: , a13 out nocopy JTF_NUMBER_TABLE
86: , a14 out nocopy JTF_NUMBER_TABLE
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_NUMBER_TABLE
89: , a17 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_DATE_TABLE
84: , a12 out nocopy JTF_DATE_TABLE
85: , a13 out nocopy JTF_NUMBER_TABLE
86: , a14 out nocopy JTF_NUMBER_TABLE
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_NUMBER_TABLE
89: , a17 out nocopy JTF_NUMBER_TABLE
90: , a18 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_DATE_TABLE
84: , a12 out nocopy JTF_DATE_TABLE
85: , a13 out nocopy JTF_NUMBER_TABLE
86: , a14 out nocopy JTF_NUMBER_TABLE
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_NUMBER_TABLE
89: , a17 out nocopy JTF_NUMBER_TABLE
90: , a18 out nocopy JTF_NUMBER_TABLE
91: , a19 out nocopy JTF_NUMBER_TABLE
84: , a12 out nocopy JTF_DATE_TABLE
85: , a13 out nocopy JTF_NUMBER_TABLE
86: , a14 out nocopy JTF_NUMBER_TABLE
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_NUMBER_TABLE
89: , a17 out nocopy JTF_NUMBER_TABLE
90: , a18 out nocopy JTF_NUMBER_TABLE
91: , a19 out nocopy JTF_NUMBER_TABLE
92: , a20 out nocopy JTF_NUMBER_TABLE
85: , a13 out nocopy JTF_NUMBER_TABLE
86: , a14 out nocopy JTF_NUMBER_TABLE
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_NUMBER_TABLE
89: , a17 out nocopy JTF_NUMBER_TABLE
90: , a18 out nocopy JTF_NUMBER_TABLE
91: , a19 out nocopy JTF_NUMBER_TABLE
92: , a20 out nocopy JTF_NUMBER_TABLE
93: , a21 out nocopy JTF_NUMBER_TABLE
86: , a14 out nocopy JTF_NUMBER_TABLE
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_NUMBER_TABLE
89: , a17 out nocopy JTF_NUMBER_TABLE
90: , a18 out nocopy JTF_NUMBER_TABLE
91: , a19 out nocopy JTF_NUMBER_TABLE
92: , a20 out nocopy JTF_NUMBER_TABLE
93: , a21 out nocopy JTF_NUMBER_TABLE
94: , a22 out nocopy JTF_NUMBER_TABLE
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_NUMBER_TABLE
89: , a17 out nocopy JTF_NUMBER_TABLE
90: , a18 out nocopy JTF_NUMBER_TABLE
91: , a19 out nocopy JTF_NUMBER_TABLE
92: , a20 out nocopy JTF_NUMBER_TABLE
93: , a21 out nocopy JTF_NUMBER_TABLE
94: , a22 out nocopy JTF_NUMBER_TABLE
95: , a23 out nocopy JTF_VARCHAR2_TABLE_100
88: , a16 out nocopy JTF_NUMBER_TABLE
89: , a17 out nocopy JTF_NUMBER_TABLE
90: , a18 out nocopy JTF_NUMBER_TABLE
91: , a19 out nocopy JTF_NUMBER_TABLE
92: , a20 out nocopy JTF_NUMBER_TABLE
93: , a21 out nocopy JTF_NUMBER_TABLE
94: , a22 out nocopy JTF_NUMBER_TABLE
95: , a23 out nocopy JTF_VARCHAR2_TABLE_100
96: , a24 out nocopy JTF_NUMBER_TABLE
89: , a17 out nocopy JTF_NUMBER_TABLE
90: , a18 out nocopy JTF_NUMBER_TABLE
91: , a19 out nocopy JTF_NUMBER_TABLE
92: , a20 out nocopy JTF_NUMBER_TABLE
93: , a21 out nocopy JTF_NUMBER_TABLE
94: , a22 out nocopy JTF_NUMBER_TABLE
95: , a23 out nocopy JTF_VARCHAR2_TABLE_100
96: , a24 out nocopy JTF_NUMBER_TABLE
97: , a25 out nocopy JTF_NUMBER_TABLE
90: , a18 out nocopy JTF_NUMBER_TABLE
91: , a19 out nocopy JTF_NUMBER_TABLE
92: , a20 out nocopy JTF_NUMBER_TABLE
93: , a21 out nocopy JTF_NUMBER_TABLE
94: , a22 out nocopy JTF_NUMBER_TABLE
95: , a23 out nocopy JTF_VARCHAR2_TABLE_100
96: , a24 out nocopy JTF_NUMBER_TABLE
97: , a25 out nocopy JTF_NUMBER_TABLE
98: ) as
92: , a20 out nocopy JTF_NUMBER_TABLE
93: , a21 out nocopy JTF_NUMBER_TABLE
94: , a22 out nocopy JTF_NUMBER_TABLE
95: , a23 out nocopy JTF_VARCHAR2_TABLE_100
96: , a24 out nocopy JTF_NUMBER_TABLE
97: , a25 out nocopy JTF_NUMBER_TABLE
98: ) as
99: ddindx binary_integer; indx binary_integer;
100: begin
93: , a21 out nocopy JTF_NUMBER_TABLE
94: , a22 out nocopy JTF_NUMBER_TABLE
95: , a23 out nocopy JTF_VARCHAR2_TABLE_100
96: , a24 out nocopy JTF_NUMBER_TABLE
97: , a25 out nocopy JTF_NUMBER_TABLE
98: ) as
99: ddindx binary_integer; indx binary_integer;
100: begin
101: if t is null or t.count = 0 then
98: ) as
99: ddindx binary_integer; indx binary_integer;
100: begin
101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_NUMBER_TABLE();
99: ddindx binary_integer; indx binary_integer;
100: begin
101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_NUMBER_TABLE();
107: a5 := JTF_NUMBER_TABLE();
100: begin
101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_NUMBER_TABLE();
107: a5 := JTF_NUMBER_TABLE();
108: a6 := JTF_NUMBER_TABLE();
101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_NUMBER_TABLE();
107: a5 := JTF_NUMBER_TABLE();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_NUMBER_TABLE();
107: a5 := JTF_NUMBER_TABLE();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();
110: a8 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_NUMBER_TABLE();
107: a5 := JTF_NUMBER_TABLE();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();
110: a8 := JTF_NUMBER_TABLE();
111: a9 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_NUMBER_TABLE();
107: a5 := JTF_NUMBER_TABLE();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();
110: a8 := JTF_NUMBER_TABLE();
111: a9 := JTF_NUMBER_TABLE();
112: a10 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_NUMBER_TABLE();
107: a5 := JTF_NUMBER_TABLE();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();
110: a8 := JTF_NUMBER_TABLE();
111: a9 := JTF_NUMBER_TABLE();
112: a10 := JTF_NUMBER_TABLE();
113: a11 := JTF_DATE_TABLE();
106: a4 := JTF_NUMBER_TABLE();
107: a5 := JTF_NUMBER_TABLE();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();
110: a8 := JTF_NUMBER_TABLE();
111: a9 := JTF_NUMBER_TABLE();
112: a10 := JTF_NUMBER_TABLE();
113: a11 := JTF_DATE_TABLE();
114: a12 := JTF_DATE_TABLE();
107: a5 := JTF_NUMBER_TABLE();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();
110: a8 := JTF_NUMBER_TABLE();
111: a9 := JTF_NUMBER_TABLE();
112: a10 := JTF_NUMBER_TABLE();
113: a11 := JTF_DATE_TABLE();
114: a12 := JTF_DATE_TABLE();
115: a13 := JTF_NUMBER_TABLE();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();
110: a8 := JTF_NUMBER_TABLE();
111: a9 := JTF_NUMBER_TABLE();
112: a10 := JTF_NUMBER_TABLE();
113: a11 := JTF_DATE_TABLE();
114: a12 := JTF_DATE_TABLE();
115: a13 := JTF_NUMBER_TABLE();
116: a14 := JTF_NUMBER_TABLE();
111: a9 := JTF_NUMBER_TABLE();
112: a10 := JTF_NUMBER_TABLE();
113: a11 := JTF_DATE_TABLE();
114: a12 := JTF_DATE_TABLE();
115: a13 := JTF_NUMBER_TABLE();
116: a14 := JTF_NUMBER_TABLE();
117: a15 := JTF_NUMBER_TABLE();
118: a16 := JTF_NUMBER_TABLE();
119: a17 := JTF_NUMBER_TABLE();
112: a10 := JTF_NUMBER_TABLE();
113: a11 := JTF_DATE_TABLE();
114: a12 := JTF_DATE_TABLE();
115: a13 := JTF_NUMBER_TABLE();
116: a14 := JTF_NUMBER_TABLE();
117: a15 := JTF_NUMBER_TABLE();
118: a16 := JTF_NUMBER_TABLE();
119: a17 := JTF_NUMBER_TABLE();
120: a18 := JTF_NUMBER_TABLE();
113: a11 := JTF_DATE_TABLE();
114: a12 := JTF_DATE_TABLE();
115: a13 := JTF_NUMBER_TABLE();
116: a14 := JTF_NUMBER_TABLE();
117: a15 := JTF_NUMBER_TABLE();
118: a16 := JTF_NUMBER_TABLE();
119: a17 := JTF_NUMBER_TABLE();
120: a18 := JTF_NUMBER_TABLE();
121: a19 := JTF_NUMBER_TABLE();
114: a12 := JTF_DATE_TABLE();
115: a13 := JTF_NUMBER_TABLE();
116: a14 := JTF_NUMBER_TABLE();
117: a15 := JTF_NUMBER_TABLE();
118: a16 := JTF_NUMBER_TABLE();
119: a17 := JTF_NUMBER_TABLE();
120: a18 := JTF_NUMBER_TABLE();
121: a19 := JTF_NUMBER_TABLE();
122: a20 := JTF_NUMBER_TABLE();
115: a13 := JTF_NUMBER_TABLE();
116: a14 := JTF_NUMBER_TABLE();
117: a15 := JTF_NUMBER_TABLE();
118: a16 := JTF_NUMBER_TABLE();
119: a17 := JTF_NUMBER_TABLE();
120: a18 := JTF_NUMBER_TABLE();
121: a19 := JTF_NUMBER_TABLE();
122: a20 := JTF_NUMBER_TABLE();
123: a21 := JTF_NUMBER_TABLE();
116: a14 := JTF_NUMBER_TABLE();
117: a15 := JTF_NUMBER_TABLE();
118: a16 := JTF_NUMBER_TABLE();
119: a17 := JTF_NUMBER_TABLE();
120: a18 := JTF_NUMBER_TABLE();
121: a19 := JTF_NUMBER_TABLE();
122: a20 := JTF_NUMBER_TABLE();
123: a21 := JTF_NUMBER_TABLE();
124: a22 := JTF_NUMBER_TABLE();
117: a15 := JTF_NUMBER_TABLE();
118: a16 := JTF_NUMBER_TABLE();
119: a17 := JTF_NUMBER_TABLE();
120: a18 := JTF_NUMBER_TABLE();
121: a19 := JTF_NUMBER_TABLE();
122: a20 := JTF_NUMBER_TABLE();
123: a21 := JTF_NUMBER_TABLE();
124: a22 := JTF_NUMBER_TABLE();
125: a23 := JTF_VARCHAR2_TABLE_100();
118: a16 := JTF_NUMBER_TABLE();
119: a17 := JTF_NUMBER_TABLE();
120: a18 := JTF_NUMBER_TABLE();
121: a19 := JTF_NUMBER_TABLE();
122: a20 := JTF_NUMBER_TABLE();
123: a21 := JTF_NUMBER_TABLE();
124: a22 := JTF_NUMBER_TABLE();
125: a23 := JTF_VARCHAR2_TABLE_100();
126: a24 := JTF_NUMBER_TABLE();
119: a17 := JTF_NUMBER_TABLE();
120: a18 := JTF_NUMBER_TABLE();
121: a19 := JTF_NUMBER_TABLE();
122: a20 := JTF_NUMBER_TABLE();
123: a21 := JTF_NUMBER_TABLE();
124: a22 := JTF_NUMBER_TABLE();
125: a23 := JTF_VARCHAR2_TABLE_100();
126: a24 := JTF_NUMBER_TABLE();
127: a25 := JTF_NUMBER_TABLE();
120: a18 := JTF_NUMBER_TABLE();
121: a19 := JTF_NUMBER_TABLE();
122: a20 := JTF_NUMBER_TABLE();
123: a21 := JTF_NUMBER_TABLE();
124: a22 := JTF_NUMBER_TABLE();
125: a23 := JTF_VARCHAR2_TABLE_100();
126: a24 := JTF_NUMBER_TABLE();
127: a25 := JTF_NUMBER_TABLE();
128: else
122: a20 := JTF_NUMBER_TABLE();
123: a21 := JTF_NUMBER_TABLE();
124: a22 := JTF_NUMBER_TABLE();
125: a23 := JTF_VARCHAR2_TABLE_100();
126: a24 := JTF_NUMBER_TABLE();
127: a25 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
123: a21 := JTF_NUMBER_TABLE();
124: a22 := JTF_NUMBER_TABLE();
125: a23 := JTF_VARCHAR2_TABLE_100();
126: a24 := JTF_NUMBER_TABLE();
127: a25 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
125: a23 := JTF_VARCHAR2_TABLE_100();
126: a24 := JTF_NUMBER_TABLE();
127: a25 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
126: a24 := JTF_NUMBER_TABLE();
127: a25 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_NUMBER_TABLE();
127: a25 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_NUMBER_TABLE();
135: a6 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_NUMBER_TABLE();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_NUMBER_TABLE();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();
137: a8 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_NUMBER_TABLE();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();
137: a8 := JTF_NUMBER_TABLE();
138: a9 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_NUMBER_TABLE();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();
137: a8 := JTF_NUMBER_TABLE();
138: a9 := JTF_NUMBER_TABLE();
139: a10 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_NUMBER_TABLE();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();
137: a8 := JTF_NUMBER_TABLE();
138: a9 := JTF_NUMBER_TABLE();
139: a10 := JTF_NUMBER_TABLE();
140: a11 := JTF_DATE_TABLE();
133: a4 := JTF_NUMBER_TABLE();
134: a5 := JTF_NUMBER_TABLE();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();
137: a8 := JTF_NUMBER_TABLE();
138: a9 := JTF_NUMBER_TABLE();
139: a10 := JTF_NUMBER_TABLE();
140: a11 := JTF_DATE_TABLE();
141: a12 := JTF_DATE_TABLE();
134: a5 := JTF_NUMBER_TABLE();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();
137: a8 := JTF_NUMBER_TABLE();
138: a9 := JTF_NUMBER_TABLE();
139: a10 := JTF_NUMBER_TABLE();
140: a11 := JTF_DATE_TABLE();
141: a12 := JTF_DATE_TABLE();
142: a13 := JTF_NUMBER_TABLE();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();
137: a8 := JTF_NUMBER_TABLE();
138: a9 := JTF_NUMBER_TABLE();
139: a10 := JTF_NUMBER_TABLE();
140: a11 := JTF_DATE_TABLE();
141: a12 := JTF_DATE_TABLE();
142: a13 := JTF_NUMBER_TABLE();
143: a14 := JTF_NUMBER_TABLE();
138: a9 := JTF_NUMBER_TABLE();
139: a10 := JTF_NUMBER_TABLE();
140: a11 := JTF_DATE_TABLE();
141: a12 := JTF_DATE_TABLE();
142: a13 := JTF_NUMBER_TABLE();
143: a14 := JTF_NUMBER_TABLE();
144: a15 := JTF_NUMBER_TABLE();
145: a16 := JTF_NUMBER_TABLE();
146: a17 := JTF_NUMBER_TABLE();
139: a10 := JTF_NUMBER_TABLE();
140: a11 := JTF_DATE_TABLE();
141: a12 := JTF_DATE_TABLE();
142: a13 := JTF_NUMBER_TABLE();
143: a14 := JTF_NUMBER_TABLE();
144: a15 := JTF_NUMBER_TABLE();
145: a16 := JTF_NUMBER_TABLE();
146: a17 := JTF_NUMBER_TABLE();
147: a18 := JTF_NUMBER_TABLE();
140: a11 := JTF_DATE_TABLE();
141: a12 := JTF_DATE_TABLE();
142: a13 := JTF_NUMBER_TABLE();
143: a14 := JTF_NUMBER_TABLE();
144: a15 := JTF_NUMBER_TABLE();
145: a16 := JTF_NUMBER_TABLE();
146: a17 := JTF_NUMBER_TABLE();
147: a18 := JTF_NUMBER_TABLE();
148: a19 := JTF_NUMBER_TABLE();
141: a12 := JTF_DATE_TABLE();
142: a13 := JTF_NUMBER_TABLE();
143: a14 := JTF_NUMBER_TABLE();
144: a15 := JTF_NUMBER_TABLE();
145: a16 := JTF_NUMBER_TABLE();
146: a17 := JTF_NUMBER_TABLE();
147: a18 := JTF_NUMBER_TABLE();
148: a19 := JTF_NUMBER_TABLE();
149: a20 := JTF_NUMBER_TABLE();
142: a13 := JTF_NUMBER_TABLE();
143: a14 := JTF_NUMBER_TABLE();
144: a15 := JTF_NUMBER_TABLE();
145: a16 := JTF_NUMBER_TABLE();
146: a17 := JTF_NUMBER_TABLE();
147: a18 := JTF_NUMBER_TABLE();
148: a19 := JTF_NUMBER_TABLE();
149: a20 := JTF_NUMBER_TABLE();
150: a21 := JTF_NUMBER_TABLE();
143: a14 := JTF_NUMBER_TABLE();
144: a15 := JTF_NUMBER_TABLE();
145: a16 := JTF_NUMBER_TABLE();
146: a17 := JTF_NUMBER_TABLE();
147: a18 := JTF_NUMBER_TABLE();
148: a19 := JTF_NUMBER_TABLE();
149: a20 := JTF_NUMBER_TABLE();
150: a21 := JTF_NUMBER_TABLE();
151: a22 := JTF_NUMBER_TABLE();
144: a15 := JTF_NUMBER_TABLE();
145: a16 := JTF_NUMBER_TABLE();
146: a17 := JTF_NUMBER_TABLE();
147: a18 := JTF_NUMBER_TABLE();
148: a19 := JTF_NUMBER_TABLE();
149: a20 := JTF_NUMBER_TABLE();
150: a21 := JTF_NUMBER_TABLE();
151: a22 := JTF_NUMBER_TABLE();
152: a23 := JTF_VARCHAR2_TABLE_100();
145: a16 := JTF_NUMBER_TABLE();
146: a17 := JTF_NUMBER_TABLE();
147: a18 := JTF_NUMBER_TABLE();
148: a19 := JTF_NUMBER_TABLE();
149: a20 := JTF_NUMBER_TABLE();
150: a21 := JTF_NUMBER_TABLE();
151: a22 := JTF_NUMBER_TABLE();
152: a23 := JTF_VARCHAR2_TABLE_100();
153: a24 := JTF_NUMBER_TABLE();
146: a17 := JTF_NUMBER_TABLE();
147: a18 := JTF_NUMBER_TABLE();
148: a19 := JTF_NUMBER_TABLE();
149: a20 := JTF_NUMBER_TABLE();
150: a21 := JTF_NUMBER_TABLE();
151: a22 := JTF_NUMBER_TABLE();
152: a23 := JTF_VARCHAR2_TABLE_100();
153: a24 := JTF_NUMBER_TABLE();
154: a25 := JTF_NUMBER_TABLE();
147: a18 := JTF_NUMBER_TABLE();
148: a19 := JTF_NUMBER_TABLE();
149: a20 := JTF_NUMBER_TABLE();
150: a21 := JTF_NUMBER_TABLE();
151: a22 := JTF_NUMBER_TABLE();
152: a23 := JTF_VARCHAR2_TABLE_100();
153: a24 := JTF_NUMBER_TABLE();
154: a25 := JTF_NUMBER_TABLE();
155: if t.count > 0 then
149: a20 := JTF_NUMBER_TABLE();
150: a21 := JTF_NUMBER_TABLE();
151: a22 := JTF_NUMBER_TABLE();
152: a23 := JTF_VARCHAR2_TABLE_100();
153: a24 := JTF_NUMBER_TABLE();
154: a25 := JTF_NUMBER_TABLE();
155: if t.count > 0 then
156: a0.extend(t.count);
157: a1.extend(t.count);
150: a21 := JTF_NUMBER_TABLE();
151: a22 := JTF_NUMBER_TABLE();
152: a23 := JTF_VARCHAR2_TABLE_100();
153: a24 := JTF_NUMBER_TABLE();
154: a25 := JTF_NUMBER_TABLE();
155: if t.count > 0 then
156: a0.extend(t.count);
157: a1.extend(t.count);
158: a2.extend(t.count);
217: end if;
218: end if;
219: end rosetta_table_copy_out_p9;
220:
221: procedure rosetta_table_copy_in_p10(t out nocopy inv_transaction_flow_pub.number_tbl, a0 JTF_NUMBER_TABLE) as
222: ddindx binary_integer; indx binary_integer;
223: begin
224: if a0 is not null and a0.count > 0 then
225: if a0.count > 0 then
235: end loop;
236: end if;
237: end if;
238: end rosetta_table_copy_in_p10;
239: procedure rosetta_table_copy_out_p10(t inv_transaction_flow_pub.number_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
240: ddindx binary_integer; indx binary_integer;
241: begin
242: if t is null or t.count = 0 then
243: a0 := JTF_NUMBER_TABLE();
239: procedure rosetta_table_copy_out_p10(t inv_transaction_flow_pub.number_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
240: ddindx binary_integer; indx binary_integer;
241: begin
242: if t is null or t.count = 0 then
243: a0 := JTF_NUMBER_TABLE();
244: else
245: a0 := JTF_NUMBER_TABLE();
246: if t.count > 0 then
247: a0.extend(t.count);
241: begin
242: if t is null or t.count = 0 then
243: a0 := JTF_NUMBER_TABLE();
244: else
245: a0 := JTF_NUMBER_TABLE();
246: if t.count > 0 then
247: a0.extend(t.count);
248: ddindx := t.first;
249: indx := 1;
302:
303: procedure get_transaction_flow(x_return_status out nocopy VARCHAR2
304: , x_msg_data out nocopy VARCHAR2
305: , x_msg_count out nocopy NUMBER
306: , p3_a0 out nocopy JTF_NUMBER_TABLE
307: , p3_a1 out nocopy JTF_NUMBER_TABLE
308: , p3_a2 out nocopy JTF_NUMBER_TABLE
309: , p3_a3 out nocopy JTF_NUMBER_TABLE
310: , p3_a4 out nocopy JTF_NUMBER_TABLE
303: procedure get_transaction_flow(x_return_status out nocopy VARCHAR2
304: , x_msg_data out nocopy VARCHAR2
305: , x_msg_count out nocopy NUMBER
306: , p3_a0 out nocopy JTF_NUMBER_TABLE
307: , p3_a1 out nocopy JTF_NUMBER_TABLE
308: , p3_a2 out nocopy JTF_NUMBER_TABLE
309: , p3_a3 out nocopy JTF_NUMBER_TABLE
310: , p3_a4 out nocopy JTF_NUMBER_TABLE
311: , p3_a5 out nocopy JTF_NUMBER_TABLE
304: , x_msg_data out nocopy VARCHAR2
305: , x_msg_count out nocopy NUMBER
306: , p3_a0 out nocopy JTF_NUMBER_TABLE
307: , p3_a1 out nocopy JTF_NUMBER_TABLE
308: , p3_a2 out nocopy JTF_NUMBER_TABLE
309: , p3_a3 out nocopy JTF_NUMBER_TABLE
310: , p3_a4 out nocopy JTF_NUMBER_TABLE
311: , p3_a5 out nocopy JTF_NUMBER_TABLE
312: , p3_a6 out nocopy JTF_NUMBER_TABLE
305: , x_msg_count out nocopy NUMBER
306: , p3_a0 out nocopy JTF_NUMBER_TABLE
307: , p3_a1 out nocopy JTF_NUMBER_TABLE
308: , p3_a2 out nocopy JTF_NUMBER_TABLE
309: , p3_a3 out nocopy JTF_NUMBER_TABLE
310: , p3_a4 out nocopy JTF_NUMBER_TABLE
311: , p3_a5 out nocopy JTF_NUMBER_TABLE
312: , p3_a6 out nocopy JTF_NUMBER_TABLE
313: , p3_a7 out nocopy JTF_NUMBER_TABLE
306: , p3_a0 out nocopy JTF_NUMBER_TABLE
307: , p3_a1 out nocopy JTF_NUMBER_TABLE
308: , p3_a2 out nocopy JTF_NUMBER_TABLE
309: , p3_a3 out nocopy JTF_NUMBER_TABLE
310: , p3_a4 out nocopy JTF_NUMBER_TABLE
311: , p3_a5 out nocopy JTF_NUMBER_TABLE
312: , p3_a6 out nocopy JTF_NUMBER_TABLE
313: , p3_a7 out nocopy JTF_NUMBER_TABLE
314: , p3_a8 out nocopy JTF_NUMBER_TABLE
307: , p3_a1 out nocopy JTF_NUMBER_TABLE
308: , p3_a2 out nocopy JTF_NUMBER_TABLE
309: , p3_a3 out nocopy JTF_NUMBER_TABLE
310: , p3_a4 out nocopy JTF_NUMBER_TABLE
311: , p3_a5 out nocopy JTF_NUMBER_TABLE
312: , p3_a6 out nocopy JTF_NUMBER_TABLE
313: , p3_a7 out nocopy JTF_NUMBER_TABLE
314: , p3_a8 out nocopy JTF_NUMBER_TABLE
315: , p3_a9 out nocopy JTF_NUMBER_TABLE
308: , p3_a2 out nocopy JTF_NUMBER_TABLE
309: , p3_a3 out nocopy JTF_NUMBER_TABLE
310: , p3_a4 out nocopy JTF_NUMBER_TABLE
311: , p3_a5 out nocopy JTF_NUMBER_TABLE
312: , p3_a6 out nocopy JTF_NUMBER_TABLE
313: , p3_a7 out nocopy JTF_NUMBER_TABLE
314: , p3_a8 out nocopy JTF_NUMBER_TABLE
315: , p3_a9 out nocopy JTF_NUMBER_TABLE
316: , p3_a10 out nocopy JTF_NUMBER_TABLE
309: , p3_a3 out nocopy JTF_NUMBER_TABLE
310: , p3_a4 out nocopy JTF_NUMBER_TABLE
311: , p3_a5 out nocopy JTF_NUMBER_TABLE
312: , p3_a6 out nocopy JTF_NUMBER_TABLE
313: , p3_a7 out nocopy JTF_NUMBER_TABLE
314: , p3_a8 out nocopy JTF_NUMBER_TABLE
315: , p3_a9 out nocopy JTF_NUMBER_TABLE
316: , p3_a10 out nocopy JTF_NUMBER_TABLE
317: , p3_a11 out nocopy JTF_DATE_TABLE
310: , p3_a4 out nocopy JTF_NUMBER_TABLE
311: , p3_a5 out nocopy JTF_NUMBER_TABLE
312: , p3_a6 out nocopy JTF_NUMBER_TABLE
313: , p3_a7 out nocopy JTF_NUMBER_TABLE
314: , p3_a8 out nocopy JTF_NUMBER_TABLE
315: , p3_a9 out nocopy JTF_NUMBER_TABLE
316: , p3_a10 out nocopy JTF_NUMBER_TABLE
317: , p3_a11 out nocopy JTF_DATE_TABLE
318: , p3_a12 out nocopy JTF_DATE_TABLE
311: , p3_a5 out nocopy JTF_NUMBER_TABLE
312: , p3_a6 out nocopy JTF_NUMBER_TABLE
313: , p3_a7 out nocopy JTF_NUMBER_TABLE
314: , p3_a8 out nocopy JTF_NUMBER_TABLE
315: , p3_a9 out nocopy JTF_NUMBER_TABLE
316: , p3_a10 out nocopy JTF_NUMBER_TABLE
317: , p3_a11 out nocopy JTF_DATE_TABLE
318: , p3_a12 out nocopy JTF_DATE_TABLE
319: , p3_a13 out nocopy JTF_NUMBER_TABLE
312: , p3_a6 out nocopy JTF_NUMBER_TABLE
313: , p3_a7 out nocopy JTF_NUMBER_TABLE
314: , p3_a8 out nocopy JTF_NUMBER_TABLE
315: , p3_a9 out nocopy JTF_NUMBER_TABLE
316: , p3_a10 out nocopy JTF_NUMBER_TABLE
317: , p3_a11 out nocopy JTF_DATE_TABLE
318: , p3_a12 out nocopy JTF_DATE_TABLE
319: , p3_a13 out nocopy JTF_NUMBER_TABLE
320: , p3_a14 out nocopy JTF_NUMBER_TABLE
315: , p3_a9 out nocopy JTF_NUMBER_TABLE
316: , p3_a10 out nocopy JTF_NUMBER_TABLE
317: , p3_a11 out nocopy JTF_DATE_TABLE
318: , p3_a12 out nocopy JTF_DATE_TABLE
319: , p3_a13 out nocopy JTF_NUMBER_TABLE
320: , p3_a14 out nocopy JTF_NUMBER_TABLE
321: , p3_a15 out nocopy JTF_NUMBER_TABLE
322: , p3_a16 out nocopy JTF_NUMBER_TABLE
323: , p3_a17 out nocopy JTF_NUMBER_TABLE
316: , p3_a10 out nocopy JTF_NUMBER_TABLE
317: , p3_a11 out nocopy JTF_DATE_TABLE
318: , p3_a12 out nocopy JTF_DATE_TABLE
319: , p3_a13 out nocopy JTF_NUMBER_TABLE
320: , p3_a14 out nocopy JTF_NUMBER_TABLE
321: , p3_a15 out nocopy JTF_NUMBER_TABLE
322: , p3_a16 out nocopy JTF_NUMBER_TABLE
323: , p3_a17 out nocopy JTF_NUMBER_TABLE
324: , p3_a18 out nocopy JTF_NUMBER_TABLE
317: , p3_a11 out nocopy JTF_DATE_TABLE
318: , p3_a12 out nocopy JTF_DATE_TABLE
319: , p3_a13 out nocopy JTF_NUMBER_TABLE
320: , p3_a14 out nocopy JTF_NUMBER_TABLE
321: , p3_a15 out nocopy JTF_NUMBER_TABLE
322: , p3_a16 out nocopy JTF_NUMBER_TABLE
323: , p3_a17 out nocopy JTF_NUMBER_TABLE
324: , p3_a18 out nocopy JTF_NUMBER_TABLE
325: , p3_a19 out nocopy JTF_NUMBER_TABLE
318: , p3_a12 out nocopy JTF_DATE_TABLE
319: , p3_a13 out nocopy JTF_NUMBER_TABLE
320: , p3_a14 out nocopy JTF_NUMBER_TABLE
321: , p3_a15 out nocopy JTF_NUMBER_TABLE
322: , p3_a16 out nocopy JTF_NUMBER_TABLE
323: , p3_a17 out nocopy JTF_NUMBER_TABLE
324: , p3_a18 out nocopy JTF_NUMBER_TABLE
325: , p3_a19 out nocopy JTF_NUMBER_TABLE
326: , p3_a20 out nocopy JTF_NUMBER_TABLE
319: , p3_a13 out nocopy JTF_NUMBER_TABLE
320: , p3_a14 out nocopy JTF_NUMBER_TABLE
321: , p3_a15 out nocopy JTF_NUMBER_TABLE
322: , p3_a16 out nocopy JTF_NUMBER_TABLE
323: , p3_a17 out nocopy JTF_NUMBER_TABLE
324: , p3_a18 out nocopy JTF_NUMBER_TABLE
325: , p3_a19 out nocopy JTF_NUMBER_TABLE
326: , p3_a20 out nocopy JTF_NUMBER_TABLE
327: , p3_a21 out nocopy JTF_NUMBER_TABLE
320: , p3_a14 out nocopy JTF_NUMBER_TABLE
321: , p3_a15 out nocopy JTF_NUMBER_TABLE
322: , p3_a16 out nocopy JTF_NUMBER_TABLE
323: , p3_a17 out nocopy JTF_NUMBER_TABLE
324: , p3_a18 out nocopy JTF_NUMBER_TABLE
325: , p3_a19 out nocopy JTF_NUMBER_TABLE
326: , p3_a20 out nocopy JTF_NUMBER_TABLE
327: , p3_a21 out nocopy JTF_NUMBER_TABLE
328: , p3_a22 out nocopy JTF_NUMBER_TABLE
321: , p3_a15 out nocopy JTF_NUMBER_TABLE
322: , p3_a16 out nocopy JTF_NUMBER_TABLE
323: , p3_a17 out nocopy JTF_NUMBER_TABLE
324: , p3_a18 out nocopy JTF_NUMBER_TABLE
325: , p3_a19 out nocopy JTF_NUMBER_TABLE
326: , p3_a20 out nocopy JTF_NUMBER_TABLE
327: , p3_a21 out nocopy JTF_NUMBER_TABLE
328: , p3_a22 out nocopy JTF_NUMBER_TABLE
329: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
322: , p3_a16 out nocopy JTF_NUMBER_TABLE
323: , p3_a17 out nocopy JTF_NUMBER_TABLE
324: , p3_a18 out nocopy JTF_NUMBER_TABLE
325: , p3_a19 out nocopy JTF_NUMBER_TABLE
326: , p3_a20 out nocopy JTF_NUMBER_TABLE
327: , p3_a21 out nocopy JTF_NUMBER_TABLE
328: , p3_a22 out nocopy JTF_NUMBER_TABLE
329: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
330: , p3_a24 out nocopy JTF_NUMBER_TABLE
323: , p3_a17 out nocopy JTF_NUMBER_TABLE
324: , p3_a18 out nocopy JTF_NUMBER_TABLE
325: , p3_a19 out nocopy JTF_NUMBER_TABLE
326: , p3_a20 out nocopy JTF_NUMBER_TABLE
327: , p3_a21 out nocopy JTF_NUMBER_TABLE
328: , p3_a22 out nocopy JTF_NUMBER_TABLE
329: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
330: , p3_a24 out nocopy JTF_NUMBER_TABLE
331: , p3_a25 out nocopy JTF_NUMBER_TABLE
324: , p3_a18 out nocopy JTF_NUMBER_TABLE
325: , p3_a19 out nocopy JTF_NUMBER_TABLE
326: , p3_a20 out nocopy JTF_NUMBER_TABLE
327: , p3_a21 out nocopy JTF_NUMBER_TABLE
328: , p3_a22 out nocopy JTF_NUMBER_TABLE
329: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
330: , p3_a24 out nocopy JTF_NUMBER_TABLE
331: , p3_a25 out nocopy JTF_NUMBER_TABLE
332: , p_api_version NUMBER
326: , p3_a20 out nocopy JTF_NUMBER_TABLE
327: , p3_a21 out nocopy JTF_NUMBER_TABLE
328: , p3_a22 out nocopy JTF_NUMBER_TABLE
329: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
330: , p3_a24 out nocopy JTF_NUMBER_TABLE
331: , p3_a25 out nocopy JTF_NUMBER_TABLE
332: , p_api_version NUMBER
333: , p_init_msg_list VARCHAR2
334: , p_start_operating_unit NUMBER
327: , p3_a21 out nocopy JTF_NUMBER_TABLE
328: , p3_a22 out nocopy JTF_NUMBER_TABLE
329: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
330: , p3_a24 out nocopy JTF_NUMBER_TABLE
331: , p3_a25 out nocopy JTF_NUMBER_TABLE
332: , p_api_version NUMBER
333: , p_init_msg_list VARCHAR2
334: , p_start_operating_unit NUMBER
335: , p_end_operating_unit NUMBER
334: , p_start_operating_unit NUMBER
335: , p_end_operating_unit NUMBER
336: , p_flow_type NUMBER
337: , p_organization_id NUMBER
338: , p_qualifier_code_tbl JTF_NUMBER_TABLE
339: , p_qualifier_value_tbl JTF_NUMBER_TABLE
340: , p_transaction_date DATE
341: , p_get_default_cost_group VARCHAR2
342: )
335: , p_end_operating_unit NUMBER
336: , p_flow_type NUMBER
337: , p_organization_id NUMBER
338: , p_qualifier_code_tbl JTF_NUMBER_TABLE
339: , p_qualifier_value_tbl JTF_NUMBER_TABLE
340: , p_transaction_date DATE
341: , p_get_default_cost_group VARCHAR2
342: )
343:
404:
405: procedure get_transaction_flow(x_return_status out nocopy VARCHAR2
406: , x_msg_data out nocopy VARCHAR2
407: , x_msg_count out nocopy NUMBER
408: , p3_a0 out nocopy JTF_NUMBER_TABLE
409: , p3_a1 out nocopy JTF_NUMBER_TABLE
410: , p3_a2 out nocopy JTF_NUMBER_TABLE
411: , p3_a3 out nocopy JTF_NUMBER_TABLE
412: , p3_a4 out nocopy JTF_NUMBER_TABLE
405: procedure get_transaction_flow(x_return_status out nocopy VARCHAR2
406: , x_msg_data out nocopy VARCHAR2
407: , x_msg_count out nocopy NUMBER
408: , p3_a0 out nocopy JTF_NUMBER_TABLE
409: , p3_a1 out nocopy JTF_NUMBER_TABLE
410: , p3_a2 out nocopy JTF_NUMBER_TABLE
411: , p3_a3 out nocopy JTF_NUMBER_TABLE
412: , p3_a4 out nocopy JTF_NUMBER_TABLE
413: , p3_a5 out nocopy JTF_NUMBER_TABLE
406: , x_msg_data out nocopy VARCHAR2
407: , x_msg_count out nocopy NUMBER
408: , p3_a0 out nocopy JTF_NUMBER_TABLE
409: , p3_a1 out nocopy JTF_NUMBER_TABLE
410: , p3_a2 out nocopy JTF_NUMBER_TABLE
411: , p3_a3 out nocopy JTF_NUMBER_TABLE
412: , p3_a4 out nocopy JTF_NUMBER_TABLE
413: , p3_a5 out nocopy JTF_NUMBER_TABLE
414: , p3_a6 out nocopy JTF_NUMBER_TABLE
407: , x_msg_count out nocopy NUMBER
408: , p3_a0 out nocopy JTF_NUMBER_TABLE
409: , p3_a1 out nocopy JTF_NUMBER_TABLE
410: , p3_a2 out nocopy JTF_NUMBER_TABLE
411: , p3_a3 out nocopy JTF_NUMBER_TABLE
412: , p3_a4 out nocopy JTF_NUMBER_TABLE
413: , p3_a5 out nocopy JTF_NUMBER_TABLE
414: , p3_a6 out nocopy JTF_NUMBER_TABLE
415: , p3_a7 out nocopy JTF_NUMBER_TABLE
408: , p3_a0 out nocopy JTF_NUMBER_TABLE
409: , p3_a1 out nocopy JTF_NUMBER_TABLE
410: , p3_a2 out nocopy JTF_NUMBER_TABLE
411: , p3_a3 out nocopy JTF_NUMBER_TABLE
412: , p3_a4 out nocopy JTF_NUMBER_TABLE
413: , p3_a5 out nocopy JTF_NUMBER_TABLE
414: , p3_a6 out nocopy JTF_NUMBER_TABLE
415: , p3_a7 out nocopy JTF_NUMBER_TABLE
416: , p3_a8 out nocopy JTF_NUMBER_TABLE
409: , p3_a1 out nocopy JTF_NUMBER_TABLE
410: , p3_a2 out nocopy JTF_NUMBER_TABLE
411: , p3_a3 out nocopy JTF_NUMBER_TABLE
412: , p3_a4 out nocopy JTF_NUMBER_TABLE
413: , p3_a5 out nocopy JTF_NUMBER_TABLE
414: , p3_a6 out nocopy JTF_NUMBER_TABLE
415: , p3_a7 out nocopy JTF_NUMBER_TABLE
416: , p3_a8 out nocopy JTF_NUMBER_TABLE
417: , p3_a9 out nocopy JTF_NUMBER_TABLE
410: , p3_a2 out nocopy JTF_NUMBER_TABLE
411: , p3_a3 out nocopy JTF_NUMBER_TABLE
412: , p3_a4 out nocopy JTF_NUMBER_TABLE
413: , p3_a5 out nocopy JTF_NUMBER_TABLE
414: , p3_a6 out nocopy JTF_NUMBER_TABLE
415: , p3_a7 out nocopy JTF_NUMBER_TABLE
416: , p3_a8 out nocopy JTF_NUMBER_TABLE
417: , p3_a9 out nocopy JTF_NUMBER_TABLE
418: , p3_a10 out nocopy JTF_NUMBER_TABLE
411: , p3_a3 out nocopy JTF_NUMBER_TABLE
412: , p3_a4 out nocopy JTF_NUMBER_TABLE
413: , p3_a5 out nocopy JTF_NUMBER_TABLE
414: , p3_a6 out nocopy JTF_NUMBER_TABLE
415: , p3_a7 out nocopy JTF_NUMBER_TABLE
416: , p3_a8 out nocopy JTF_NUMBER_TABLE
417: , p3_a9 out nocopy JTF_NUMBER_TABLE
418: , p3_a10 out nocopy JTF_NUMBER_TABLE
419: , p3_a11 out nocopy JTF_DATE_TABLE
412: , p3_a4 out nocopy JTF_NUMBER_TABLE
413: , p3_a5 out nocopy JTF_NUMBER_TABLE
414: , p3_a6 out nocopy JTF_NUMBER_TABLE
415: , p3_a7 out nocopy JTF_NUMBER_TABLE
416: , p3_a8 out nocopy JTF_NUMBER_TABLE
417: , p3_a9 out nocopy JTF_NUMBER_TABLE
418: , p3_a10 out nocopy JTF_NUMBER_TABLE
419: , p3_a11 out nocopy JTF_DATE_TABLE
420: , p3_a12 out nocopy JTF_DATE_TABLE
413: , p3_a5 out nocopy JTF_NUMBER_TABLE
414: , p3_a6 out nocopy JTF_NUMBER_TABLE
415: , p3_a7 out nocopy JTF_NUMBER_TABLE
416: , p3_a8 out nocopy JTF_NUMBER_TABLE
417: , p3_a9 out nocopy JTF_NUMBER_TABLE
418: , p3_a10 out nocopy JTF_NUMBER_TABLE
419: , p3_a11 out nocopy JTF_DATE_TABLE
420: , p3_a12 out nocopy JTF_DATE_TABLE
421: , p3_a13 out nocopy JTF_NUMBER_TABLE
414: , p3_a6 out nocopy JTF_NUMBER_TABLE
415: , p3_a7 out nocopy JTF_NUMBER_TABLE
416: , p3_a8 out nocopy JTF_NUMBER_TABLE
417: , p3_a9 out nocopy JTF_NUMBER_TABLE
418: , p3_a10 out nocopy JTF_NUMBER_TABLE
419: , p3_a11 out nocopy JTF_DATE_TABLE
420: , p3_a12 out nocopy JTF_DATE_TABLE
421: , p3_a13 out nocopy JTF_NUMBER_TABLE
422: , p3_a14 out nocopy JTF_NUMBER_TABLE
417: , p3_a9 out nocopy JTF_NUMBER_TABLE
418: , p3_a10 out nocopy JTF_NUMBER_TABLE
419: , p3_a11 out nocopy JTF_DATE_TABLE
420: , p3_a12 out nocopy JTF_DATE_TABLE
421: , p3_a13 out nocopy JTF_NUMBER_TABLE
422: , p3_a14 out nocopy JTF_NUMBER_TABLE
423: , p3_a15 out nocopy JTF_NUMBER_TABLE
424: , p3_a16 out nocopy JTF_NUMBER_TABLE
425: , p3_a17 out nocopy JTF_NUMBER_TABLE
418: , p3_a10 out nocopy JTF_NUMBER_TABLE
419: , p3_a11 out nocopy JTF_DATE_TABLE
420: , p3_a12 out nocopy JTF_DATE_TABLE
421: , p3_a13 out nocopy JTF_NUMBER_TABLE
422: , p3_a14 out nocopy JTF_NUMBER_TABLE
423: , p3_a15 out nocopy JTF_NUMBER_TABLE
424: , p3_a16 out nocopy JTF_NUMBER_TABLE
425: , p3_a17 out nocopy JTF_NUMBER_TABLE
426: , p3_a18 out nocopy JTF_NUMBER_TABLE
419: , p3_a11 out nocopy JTF_DATE_TABLE
420: , p3_a12 out nocopy JTF_DATE_TABLE
421: , p3_a13 out nocopy JTF_NUMBER_TABLE
422: , p3_a14 out nocopy JTF_NUMBER_TABLE
423: , p3_a15 out nocopy JTF_NUMBER_TABLE
424: , p3_a16 out nocopy JTF_NUMBER_TABLE
425: , p3_a17 out nocopy JTF_NUMBER_TABLE
426: , p3_a18 out nocopy JTF_NUMBER_TABLE
427: , p3_a19 out nocopy JTF_NUMBER_TABLE
420: , p3_a12 out nocopy JTF_DATE_TABLE
421: , p3_a13 out nocopy JTF_NUMBER_TABLE
422: , p3_a14 out nocopy JTF_NUMBER_TABLE
423: , p3_a15 out nocopy JTF_NUMBER_TABLE
424: , p3_a16 out nocopy JTF_NUMBER_TABLE
425: , p3_a17 out nocopy JTF_NUMBER_TABLE
426: , p3_a18 out nocopy JTF_NUMBER_TABLE
427: , p3_a19 out nocopy JTF_NUMBER_TABLE
428: , p3_a20 out nocopy JTF_NUMBER_TABLE
421: , p3_a13 out nocopy JTF_NUMBER_TABLE
422: , p3_a14 out nocopy JTF_NUMBER_TABLE
423: , p3_a15 out nocopy JTF_NUMBER_TABLE
424: , p3_a16 out nocopy JTF_NUMBER_TABLE
425: , p3_a17 out nocopy JTF_NUMBER_TABLE
426: , p3_a18 out nocopy JTF_NUMBER_TABLE
427: , p3_a19 out nocopy JTF_NUMBER_TABLE
428: , p3_a20 out nocopy JTF_NUMBER_TABLE
429: , p3_a21 out nocopy JTF_NUMBER_TABLE
422: , p3_a14 out nocopy JTF_NUMBER_TABLE
423: , p3_a15 out nocopy JTF_NUMBER_TABLE
424: , p3_a16 out nocopy JTF_NUMBER_TABLE
425: , p3_a17 out nocopy JTF_NUMBER_TABLE
426: , p3_a18 out nocopy JTF_NUMBER_TABLE
427: , p3_a19 out nocopy JTF_NUMBER_TABLE
428: , p3_a20 out nocopy JTF_NUMBER_TABLE
429: , p3_a21 out nocopy JTF_NUMBER_TABLE
430: , p3_a22 out nocopy JTF_NUMBER_TABLE
423: , p3_a15 out nocopy JTF_NUMBER_TABLE
424: , p3_a16 out nocopy JTF_NUMBER_TABLE
425: , p3_a17 out nocopy JTF_NUMBER_TABLE
426: , p3_a18 out nocopy JTF_NUMBER_TABLE
427: , p3_a19 out nocopy JTF_NUMBER_TABLE
428: , p3_a20 out nocopy JTF_NUMBER_TABLE
429: , p3_a21 out nocopy JTF_NUMBER_TABLE
430: , p3_a22 out nocopy JTF_NUMBER_TABLE
431: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
424: , p3_a16 out nocopy JTF_NUMBER_TABLE
425: , p3_a17 out nocopy JTF_NUMBER_TABLE
426: , p3_a18 out nocopy JTF_NUMBER_TABLE
427: , p3_a19 out nocopy JTF_NUMBER_TABLE
428: , p3_a20 out nocopy JTF_NUMBER_TABLE
429: , p3_a21 out nocopy JTF_NUMBER_TABLE
430: , p3_a22 out nocopy JTF_NUMBER_TABLE
431: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
432: , p3_a24 out nocopy JTF_NUMBER_TABLE
425: , p3_a17 out nocopy JTF_NUMBER_TABLE
426: , p3_a18 out nocopy JTF_NUMBER_TABLE
427: , p3_a19 out nocopy JTF_NUMBER_TABLE
428: , p3_a20 out nocopy JTF_NUMBER_TABLE
429: , p3_a21 out nocopy JTF_NUMBER_TABLE
430: , p3_a22 out nocopy JTF_NUMBER_TABLE
431: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
432: , p3_a24 out nocopy JTF_NUMBER_TABLE
433: , p3_a25 out nocopy JTF_NUMBER_TABLE
426: , p3_a18 out nocopy JTF_NUMBER_TABLE
427: , p3_a19 out nocopy JTF_NUMBER_TABLE
428: , p3_a20 out nocopy JTF_NUMBER_TABLE
429: , p3_a21 out nocopy JTF_NUMBER_TABLE
430: , p3_a22 out nocopy JTF_NUMBER_TABLE
431: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
432: , p3_a24 out nocopy JTF_NUMBER_TABLE
433: , p3_a25 out nocopy JTF_NUMBER_TABLE
434: , p_api_version NUMBER
428: , p3_a20 out nocopy JTF_NUMBER_TABLE
429: , p3_a21 out nocopy JTF_NUMBER_TABLE
430: , p3_a22 out nocopy JTF_NUMBER_TABLE
431: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
432: , p3_a24 out nocopy JTF_NUMBER_TABLE
433: , p3_a25 out nocopy JTF_NUMBER_TABLE
434: , p_api_version NUMBER
435: , p_init_msg_list VARCHAR2
436: , p_header_id NUMBER
429: , p3_a21 out nocopy JTF_NUMBER_TABLE
430: , p3_a22 out nocopy JTF_NUMBER_TABLE
431: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
432: , p3_a24 out nocopy JTF_NUMBER_TABLE
433: , p3_a25 out nocopy JTF_NUMBER_TABLE
434: , p_api_version NUMBER
435: , p_init_msg_list VARCHAR2
436: , p_header_id NUMBER
437: , p_get_default_cost_group VARCHAR2
491: , p_start_operating_unit NUMBER
492: , p_end_operating_unit NUMBER
493: , p_flow_type NUMBER
494: , p_organization_id NUMBER
495: , p_qualifier_code_tbl JTF_NUMBER_TABLE
496: , p_qualifier_value_tbl JTF_NUMBER_TABLE
497: , p_transaction_date DATE
498: , x_return_status out nocopy VARCHAR2
499: , x_msg_count out nocopy NUMBER
492: , p_end_operating_unit NUMBER
493: , p_flow_type NUMBER
494: , p_organization_id NUMBER
495: , p_qualifier_code_tbl JTF_NUMBER_TABLE
496: , p_qualifier_value_tbl JTF_NUMBER_TABLE
497: , p_transaction_date DATE
498: , x_return_status out nocopy VARCHAR2
499: , x_msg_count out nocopy NUMBER
500: , x_msg_data out nocopy VARCHAR2
539: procedure create_transaction_flow(x_return_status out nocopy VARCHAR2
540: , x_msg_data out nocopy VARCHAR2
541: , x_msg_count out nocopy NUMBER
542: , x_header_id out nocopy NUMBER
543: , x_line_number_tbl out nocopy JTF_NUMBER_TABLE
544: , p_api_version NUMBER
545: , p_init_msg_list VARCHAR2
546: , p_validation_level NUMBER
547: , p_start_org_id NUMBER
570: , p_attribute12 VARCHAR2
571: , p_attribute13 VARCHAR2
572: , p_attribute14 VARCHAR2
573: , p_attribute15 VARCHAR2
574: , p_line_number_tbl JTF_NUMBER_TABLE
575: , p_from_org_id_tbl JTF_NUMBER_TABLE
576: , p_from_organization_id_tbl JTF_NUMBER_TABLE
577: , p_to_org_id_tbl JTF_NUMBER_TABLE
578: , p_to_organization_id_tbl JTF_NUMBER_TABLE
571: , p_attribute13 VARCHAR2
572: , p_attribute14 VARCHAR2
573: , p_attribute15 VARCHAR2
574: , p_line_number_tbl JTF_NUMBER_TABLE
575: , p_from_org_id_tbl JTF_NUMBER_TABLE
576: , p_from_organization_id_tbl JTF_NUMBER_TABLE
577: , p_to_org_id_tbl JTF_NUMBER_TABLE
578: , p_to_organization_id_tbl JTF_NUMBER_TABLE
579: , p_line_attribute_category_tbl JTF_VARCHAR2_TABLE_200
572: , p_attribute14 VARCHAR2
573: , p_attribute15 VARCHAR2
574: , p_line_number_tbl JTF_NUMBER_TABLE
575: , p_from_org_id_tbl JTF_NUMBER_TABLE
576: , p_from_organization_id_tbl JTF_NUMBER_TABLE
577: , p_to_org_id_tbl JTF_NUMBER_TABLE
578: , p_to_organization_id_tbl JTF_NUMBER_TABLE
579: , p_line_attribute_category_tbl JTF_VARCHAR2_TABLE_200
580: , p_line_attribute1_tbl JTF_VARCHAR2_TABLE_200
573: , p_attribute15 VARCHAR2
574: , p_line_number_tbl JTF_NUMBER_TABLE
575: , p_from_org_id_tbl JTF_NUMBER_TABLE
576: , p_from_organization_id_tbl JTF_NUMBER_TABLE
577: , p_to_org_id_tbl JTF_NUMBER_TABLE
578: , p_to_organization_id_tbl JTF_NUMBER_TABLE
579: , p_line_attribute_category_tbl JTF_VARCHAR2_TABLE_200
580: , p_line_attribute1_tbl JTF_VARCHAR2_TABLE_200
581: , p_line_attribute2_tbl JTF_VARCHAR2_TABLE_200
574: , p_line_number_tbl JTF_NUMBER_TABLE
575: , p_from_org_id_tbl JTF_NUMBER_TABLE
576: , p_from_organization_id_tbl JTF_NUMBER_TABLE
577: , p_to_org_id_tbl JTF_NUMBER_TABLE
578: , p_to_organization_id_tbl JTF_NUMBER_TABLE
579: , p_line_attribute_category_tbl JTF_VARCHAR2_TABLE_200
580: , p_line_attribute1_tbl JTF_VARCHAR2_TABLE_200
581: , p_line_attribute2_tbl JTF_VARCHAR2_TABLE_200
582: , p_line_attribute3_tbl JTF_VARCHAR2_TABLE_200
591: , p_line_attribute12_tbl JTF_VARCHAR2_TABLE_200
592: , p_line_attribute13_tbl JTF_VARCHAR2_TABLE_200
593: , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
594: , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
595: , p_ship_organization_id_tbl JTF_NUMBER_TABLE
596: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
597: , p_vendor_id_tbl JTF_NUMBER_TABLE
598: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
599: , p_customer_id_tbl JTF_NUMBER_TABLE
592: , p_line_attribute13_tbl JTF_VARCHAR2_TABLE_200
593: , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
594: , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
595: , p_ship_organization_id_tbl JTF_NUMBER_TABLE
596: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
597: , p_vendor_id_tbl JTF_NUMBER_TABLE
598: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
599: , p_customer_id_tbl JTF_NUMBER_TABLE
600: , p_address_id_tbl JTF_NUMBER_TABLE
593: , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
594: , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
595: , p_ship_organization_id_tbl JTF_NUMBER_TABLE
596: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
597: , p_vendor_id_tbl JTF_NUMBER_TABLE
598: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
599: , p_customer_id_tbl JTF_NUMBER_TABLE
600: , p_address_id_tbl JTF_NUMBER_TABLE
601: , p_customer_site_id_tbl JTF_NUMBER_TABLE
594: , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
595: , p_ship_organization_id_tbl JTF_NUMBER_TABLE
596: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
597: , p_vendor_id_tbl JTF_NUMBER_TABLE
598: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
599: , p_customer_id_tbl JTF_NUMBER_TABLE
600: , p_address_id_tbl JTF_NUMBER_TABLE
601: , p_customer_site_id_tbl JTF_NUMBER_TABLE
602: , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
595: , p_ship_organization_id_tbl JTF_NUMBER_TABLE
596: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
597: , p_vendor_id_tbl JTF_NUMBER_TABLE
598: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
599: , p_customer_id_tbl JTF_NUMBER_TABLE
600: , p_address_id_tbl JTF_NUMBER_TABLE
601: , p_customer_site_id_tbl JTF_NUMBER_TABLE
602: , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
603: , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
596: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
597: , p_vendor_id_tbl JTF_NUMBER_TABLE
598: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
599: , p_customer_id_tbl JTF_NUMBER_TABLE
600: , p_address_id_tbl JTF_NUMBER_TABLE
601: , p_customer_site_id_tbl JTF_NUMBER_TABLE
602: , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
603: , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
604: , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
597: , p_vendor_id_tbl JTF_NUMBER_TABLE
598: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
599: , p_customer_id_tbl JTF_NUMBER_TABLE
600: , p_address_id_tbl JTF_NUMBER_TABLE
601: , p_customer_site_id_tbl JTF_NUMBER_TABLE
602: , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
603: , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
604: , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
605: , p_ic_attribute2_tbl JTF_VARCHAR2_TABLE_200
598: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
599: , p_customer_id_tbl JTF_NUMBER_TABLE
600: , p_address_id_tbl JTF_NUMBER_TABLE
601: , p_customer_site_id_tbl JTF_NUMBER_TABLE
602: , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
603: , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
604: , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
605: , p_ic_attribute2_tbl JTF_VARCHAR2_TABLE_200
606: , p_ic_attribute3_tbl JTF_VARCHAR2_TABLE_200
616: , p_ic_attribute13_tbl JTF_VARCHAR2_TABLE_200
617: , p_ic_attribute14_tbl JTF_VARCHAR2_TABLE_200
618: , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
619: , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
620: , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
621: , p_inv_currency_code_tbl JTF_NUMBER_TABLE
622: , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
623: , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
624: , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
617: , p_ic_attribute14_tbl JTF_VARCHAR2_TABLE_200
618: , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
619: , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
620: , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
621: , p_inv_currency_code_tbl JTF_NUMBER_TABLE
622: , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
623: , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
624: , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
625: )
618: , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
619: , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
620: , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
621: , p_inv_currency_code_tbl JTF_NUMBER_TABLE
622: , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
623: , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
624: , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
625: )
626:
619: , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
620: , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
621: , p_inv_currency_code_tbl JTF_NUMBER_TABLE
622: , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
623: , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
624: , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
625: )
626:
627: as
620: , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
621: , p_inv_currency_code_tbl JTF_NUMBER_TABLE
622: , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
623: , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
624: , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
625: )
626:
627: as
628: ddx_line_number_tbl inv_transaction_flow_pub.number_tbl;
903: , p_attribute12 VARCHAR2
904: , p_attribute13 VARCHAR2
905: , p_attribute14 VARCHAR2
906: , p_attribute15 VARCHAR2
907: , p_line_number_tbl JTF_NUMBER_TABLE
908: , p_line_attribute_category_tbl JTF_VARCHAR2_TABLE_200
909: , p_line_attribute1_tbl JTF_VARCHAR2_TABLE_200
910: , p_line_attribute2_tbl JTF_VARCHAR2_TABLE_200
911: , p_line_attribute3_tbl JTF_VARCHAR2_TABLE_200
920: , p_line_attribute12_tbl JTF_VARCHAR2_TABLE_200
921: , p_line_attribute13_tbl JTF_VARCHAR2_TABLE_200
922: , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
923: , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
924: , p_ship_organization_id_tbl JTF_NUMBER_TABLE
925: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
926: , p_vendor_id_tbl JTF_NUMBER_TABLE
927: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
928: , p_customer_id_tbl JTF_NUMBER_TABLE
921: , p_line_attribute13_tbl JTF_VARCHAR2_TABLE_200
922: , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
923: , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
924: , p_ship_organization_id_tbl JTF_NUMBER_TABLE
925: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
926: , p_vendor_id_tbl JTF_NUMBER_TABLE
927: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
928: , p_customer_id_tbl JTF_NUMBER_TABLE
929: , p_address_id_tbl JTF_NUMBER_TABLE
922: , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
923: , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
924: , p_ship_organization_id_tbl JTF_NUMBER_TABLE
925: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
926: , p_vendor_id_tbl JTF_NUMBER_TABLE
927: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
928: , p_customer_id_tbl JTF_NUMBER_TABLE
929: , p_address_id_tbl JTF_NUMBER_TABLE
930: , p_customer_site_id_tbl JTF_NUMBER_TABLE
923: , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
924: , p_ship_organization_id_tbl JTF_NUMBER_TABLE
925: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
926: , p_vendor_id_tbl JTF_NUMBER_TABLE
927: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
928: , p_customer_id_tbl JTF_NUMBER_TABLE
929: , p_address_id_tbl JTF_NUMBER_TABLE
930: , p_customer_site_id_tbl JTF_NUMBER_TABLE
931: , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
924: , p_ship_organization_id_tbl JTF_NUMBER_TABLE
925: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
926: , p_vendor_id_tbl JTF_NUMBER_TABLE
927: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
928: , p_customer_id_tbl JTF_NUMBER_TABLE
929: , p_address_id_tbl JTF_NUMBER_TABLE
930: , p_customer_site_id_tbl JTF_NUMBER_TABLE
931: , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
932: , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
925: , p_sell_organization_id_tbl JTF_NUMBER_TABLE
926: , p_vendor_id_tbl JTF_NUMBER_TABLE
927: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
928: , p_customer_id_tbl JTF_NUMBER_TABLE
929: , p_address_id_tbl JTF_NUMBER_TABLE
930: , p_customer_site_id_tbl JTF_NUMBER_TABLE
931: , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
932: , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
933: , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
926: , p_vendor_id_tbl JTF_NUMBER_TABLE
927: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
928: , p_customer_id_tbl JTF_NUMBER_TABLE
929: , p_address_id_tbl JTF_NUMBER_TABLE
930: , p_customer_site_id_tbl JTF_NUMBER_TABLE
931: , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
932: , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
933: , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
934: , p_ic_attribute2_tbl JTF_VARCHAR2_TABLE_200
927: , p_vendor_site_id_tbl JTF_NUMBER_TABLE
928: , p_customer_id_tbl JTF_NUMBER_TABLE
929: , p_address_id_tbl JTF_NUMBER_TABLE
930: , p_customer_site_id_tbl JTF_NUMBER_TABLE
931: , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
932: , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
933: , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
934: , p_ic_attribute2_tbl JTF_VARCHAR2_TABLE_200
935: , p_ic_attribute3_tbl JTF_VARCHAR2_TABLE_200
945: , p_ic_attribute13_tbl JTF_VARCHAR2_TABLE_200
946: , p_ic_attribute14_tbl JTF_VARCHAR2_TABLE_200
947: , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
948: , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
949: , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
950: , p_inv_currency_code_tbl JTF_NUMBER_TABLE
951: , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
952: , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
953: , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
946: , p_ic_attribute14_tbl JTF_VARCHAR2_TABLE_200
947: , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
948: , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
949: , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
950: , p_inv_currency_code_tbl JTF_NUMBER_TABLE
951: , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
952: , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
953: , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
954: )
947: , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
948: , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
949: , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
950: , p_inv_currency_code_tbl JTF_NUMBER_TABLE
951: , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
952: , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
953: , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
954: )
955:
948: , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
949: , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
950: , p_inv_currency_code_tbl JTF_NUMBER_TABLE
951: , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
952: , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
953: , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
954: )
955:
956: as
949: , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
950: , p_inv_currency_code_tbl JTF_NUMBER_TABLE
951: , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
952: , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
953: , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
954: )
955:
956: as
957: ddp_line_number_tbl inv_transaction_flow_pub.number_tbl;