1: package okl_stm_pvt_w as
2: /* $Header: OKLISTMS.pls 120.2 2005/10/30 04:18:39 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_stm_pvt.stm_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
1: package okl_stm_pvt_w as
2: /* $Header: OKLISTMS.pls 120.2 2005/10/30 04:18:39 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_stm_pvt.stm_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_100
1: package okl_stm_pvt_w as
2: /* $Header: OKLISTMS.pls 120.2 2005/10/30 04:18:39 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_stm_pvt.stm_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_100
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLISTMS.pls 120.2 2005/10/30 04:18:39 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_stm_pvt.stm_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_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_VARCHAR2_TABLE_2000
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_VARCHAR2_TABLE_2000
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_VARCHAR2_TABLE_2000
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_stm_pvt.stm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_stm_pvt.stm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_stm_pvt.stm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_stm_pvt.stm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_stm_pvt.stm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_stm_pvt.stm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , a8 out nocopy JTF_NUMBER_TABLE
41: , a9 out nocopy JTF_NUMBER_TABLE
42: , a10 out nocopy JTF_DATE_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , a8 out nocopy JTF_NUMBER_TABLE
41: , a9 out nocopy JTF_NUMBER_TABLE
42: , a10 out nocopy JTF_DATE_TABLE
43: , a11 out nocopy JTF_NUMBER_TABLE
44: , a12 out nocopy JTF_DATE_TABLE
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , a8 out nocopy JTF_NUMBER_TABLE
41: , a9 out nocopy JTF_NUMBER_TABLE
42: , a10 out nocopy JTF_DATE_TABLE
43: , a11 out nocopy JTF_NUMBER_TABLE
44: , a12 out nocopy JTF_DATE_TABLE
45: , a13 out nocopy JTF_DATE_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , a8 out nocopy JTF_NUMBER_TABLE
41: , a9 out nocopy JTF_NUMBER_TABLE
42: , a10 out nocopy JTF_DATE_TABLE
43: , a11 out nocopy JTF_NUMBER_TABLE
44: , a12 out nocopy JTF_DATE_TABLE
45: , a13 out nocopy JTF_DATE_TABLE
46: , a14 out nocopy JTF_DATE_TABLE
47: , a15 out nocopy JTF_DATE_TABLE
45: , a13 out nocopy JTF_DATE_TABLE
46: , a14 out nocopy JTF_DATE_TABLE
47: , a15 out nocopy JTF_DATE_TABLE
48: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a17 out nocopy JTF_NUMBER_TABLE
50: , a18 out nocopy JTF_NUMBER_TABLE
51: , a19 out nocopy JTF_NUMBER_TABLE
52: , a20 out nocopy JTF_DATE_TABLE
53: , a21 out nocopy JTF_NUMBER_TABLE
46: , a14 out nocopy JTF_DATE_TABLE
47: , a15 out nocopy JTF_DATE_TABLE
48: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a17 out nocopy JTF_NUMBER_TABLE
50: , a18 out nocopy JTF_NUMBER_TABLE
51: , a19 out nocopy JTF_NUMBER_TABLE
52: , a20 out nocopy JTF_DATE_TABLE
53: , a21 out nocopy JTF_NUMBER_TABLE
54: , a22 out nocopy JTF_VARCHAR2_TABLE_100
47: , a15 out nocopy JTF_DATE_TABLE
48: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a17 out nocopy JTF_NUMBER_TABLE
50: , a18 out nocopy JTF_NUMBER_TABLE
51: , a19 out nocopy JTF_NUMBER_TABLE
52: , a20 out nocopy JTF_DATE_TABLE
53: , a21 out nocopy JTF_NUMBER_TABLE
54: , a22 out nocopy JTF_VARCHAR2_TABLE_100
55: , a23 out nocopy JTF_NUMBER_TABLE
49: , a17 out nocopy JTF_NUMBER_TABLE
50: , a18 out nocopy JTF_NUMBER_TABLE
51: , a19 out nocopy JTF_NUMBER_TABLE
52: , a20 out nocopy JTF_DATE_TABLE
53: , a21 out nocopy JTF_NUMBER_TABLE
54: , a22 out nocopy JTF_VARCHAR2_TABLE_100
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_NUMBER_TABLE
57: , a25 out nocopy JTF_VARCHAR2_TABLE_100
51: , a19 out nocopy JTF_NUMBER_TABLE
52: , a20 out nocopy JTF_DATE_TABLE
53: , a21 out nocopy JTF_NUMBER_TABLE
54: , a22 out nocopy JTF_VARCHAR2_TABLE_100
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_NUMBER_TABLE
57: , a25 out nocopy JTF_VARCHAR2_TABLE_100
58: , a26 out nocopy JTF_NUMBER_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
52: , a20 out nocopy JTF_DATE_TABLE
53: , a21 out nocopy JTF_NUMBER_TABLE
54: , a22 out nocopy JTF_VARCHAR2_TABLE_100
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_NUMBER_TABLE
57: , a25 out nocopy JTF_VARCHAR2_TABLE_100
58: , a26 out nocopy JTF_NUMBER_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
54: , a22 out nocopy JTF_VARCHAR2_TABLE_100
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_NUMBER_TABLE
57: , a25 out nocopy JTF_VARCHAR2_TABLE_100
58: , a26 out nocopy JTF_NUMBER_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_stm_pvt.stmv_tbl_type, a0 JTF_NUMBER_TABLE
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_NUMBER_TABLE
57: , a25 out nocopy JTF_VARCHAR2_TABLE_100
58: , a26 out nocopy JTF_NUMBER_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_stm_pvt.stmv_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_NUMBER_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_stm_pvt.stmv_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_NUMBER_TABLE
66: , a4 JTF_VARCHAR2_TABLE_100
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_stm_pvt.stmv_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_NUMBER_TABLE
66: , a4 JTF_VARCHAR2_TABLE_100
67: , a5 JTF_VARCHAR2_TABLE_100
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_stm_pvt.stmv_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_NUMBER_TABLE
66: , a4 JTF_VARCHAR2_TABLE_100
67: , a5 JTF_VARCHAR2_TABLE_100
68: , a6 JTF_NUMBER_TABLE
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_stm_pvt.stmv_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_NUMBER_TABLE
66: , a4 JTF_VARCHAR2_TABLE_100
67: , a5 JTF_VARCHAR2_TABLE_100
68: , a6 JTF_NUMBER_TABLE
69: , a7 JTF_VARCHAR2_TABLE_100
64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_NUMBER_TABLE
66: , a4 JTF_VARCHAR2_TABLE_100
67: , a5 JTF_VARCHAR2_TABLE_100
68: , a6 JTF_NUMBER_TABLE
69: , a7 JTF_VARCHAR2_TABLE_100
70: , a8 JTF_NUMBER_TABLE
71: , a9 JTF_NUMBER_TABLE
72: , a10 JTF_DATE_TABLE
66: , a4 JTF_VARCHAR2_TABLE_100
67: , a5 JTF_VARCHAR2_TABLE_100
68: , a6 JTF_NUMBER_TABLE
69: , a7 JTF_VARCHAR2_TABLE_100
70: , a8 JTF_NUMBER_TABLE
71: , a9 JTF_NUMBER_TABLE
72: , a10 JTF_DATE_TABLE
73: , a11 JTF_NUMBER_TABLE
74: , a12 JTF_DATE_TABLE
67: , a5 JTF_VARCHAR2_TABLE_100
68: , a6 JTF_NUMBER_TABLE
69: , a7 JTF_VARCHAR2_TABLE_100
70: , a8 JTF_NUMBER_TABLE
71: , a9 JTF_NUMBER_TABLE
72: , a10 JTF_DATE_TABLE
73: , a11 JTF_NUMBER_TABLE
74: , a12 JTF_DATE_TABLE
75: , a13 JTF_DATE_TABLE
69: , a7 JTF_VARCHAR2_TABLE_100
70: , a8 JTF_NUMBER_TABLE
71: , a9 JTF_NUMBER_TABLE
72: , a10 JTF_DATE_TABLE
73: , a11 JTF_NUMBER_TABLE
74: , a12 JTF_DATE_TABLE
75: , a13 JTF_DATE_TABLE
76: , a14 JTF_DATE_TABLE
77: , a15 JTF_DATE_TABLE
75: , a13 JTF_DATE_TABLE
76: , a14 JTF_DATE_TABLE
77: , a15 JTF_DATE_TABLE
78: , a16 JTF_VARCHAR2_TABLE_2000
79: , a17 JTF_NUMBER_TABLE
80: , a18 JTF_NUMBER_TABLE
81: , a19 JTF_NUMBER_TABLE
82: , a20 JTF_DATE_TABLE
83: , a21 JTF_NUMBER_TABLE
76: , a14 JTF_DATE_TABLE
77: , a15 JTF_DATE_TABLE
78: , a16 JTF_VARCHAR2_TABLE_2000
79: , a17 JTF_NUMBER_TABLE
80: , a18 JTF_NUMBER_TABLE
81: , a19 JTF_NUMBER_TABLE
82: , a20 JTF_DATE_TABLE
83: , a21 JTF_NUMBER_TABLE
84: , a22 JTF_VARCHAR2_TABLE_100
77: , a15 JTF_DATE_TABLE
78: , a16 JTF_VARCHAR2_TABLE_2000
79: , a17 JTF_NUMBER_TABLE
80: , a18 JTF_NUMBER_TABLE
81: , a19 JTF_NUMBER_TABLE
82: , a20 JTF_DATE_TABLE
83: , a21 JTF_NUMBER_TABLE
84: , a22 JTF_VARCHAR2_TABLE_100
85: , a23 JTF_NUMBER_TABLE
79: , a17 JTF_NUMBER_TABLE
80: , a18 JTF_NUMBER_TABLE
81: , a19 JTF_NUMBER_TABLE
82: , a20 JTF_DATE_TABLE
83: , a21 JTF_NUMBER_TABLE
84: , a22 JTF_VARCHAR2_TABLE_100
85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_NUMBER_TABLE
87: , a25 JTF_VARCHAR2_TABLE_100
81: , a19 JTF_NUMBER_TABLE
82: , a20 JTF_DATE_TABLE
83: , a21 JTF_NUMBER_TABLE
84: , a22 JTF_VARCHAR2_TABLE_100
85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_NUMBER_TABLE
87: , a25 JTF_VARCHAR2_TABLE_100
88: , a26 JTF_NUMBER_TABLE
89: , a27 JTF_NUMBER_TABLE
82: , a20 JTF_DATE_TABLE
83: , a21 JTF_NUMBER_TABLE
84: , a22 JTF_VARCHAR2_TABLE_100
85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_NUMBER_TABLE
87: , a25 JTF_VARCHAR2_TABLE_100
88: , a26 JTF_NUMBER_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
84: , a22 JTF_VARCHAR2_TABLE_100
85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_NUMBER_TABLE
87: , a25 JTF_VARCHAR2_TABLE_100
88: , a26 JTF_NUMBER_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_stm_pvt.stmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_NUMBER_TABLE
87: , a25 JTF_VARCHAR2_TABLE_100
88: , a26 JTF_NUMBER_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_stm_pvt.stmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
87: , a25 JTF_VARCHAR2_TABLE_100
88: , a26 JTF_NUMBER_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_stm_pvt.stmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_NUMBER_TABLE
95: , a4 out nocopy JTF_VARCHAR2_TABLE_100
88: , a26 JTF_NUMBER_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_stm_pvt.stmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_NUMBER_TABLE
95: , a4 out nocopy JTF_VARCHAR2_TABLE_100
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_stm_pvt.stmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_NUMBER_TABLE
95: , a4 out nocopy JTF_VARCHAR2_TABLE_100
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_stm_pvt.stmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_NUMBER_TABLE
95: , a4 out nocopy JTF_VARCHAR2_TABLE_100
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_NUMBER_TABLE
98: , a7 out nocopy JTF_VARCHAR2_TABLE_100
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_NUMBER_TABLE
95: , a4 out nocopy JTF_VARCHAR2_TABLE_100
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_NUMBER_TABLE
98: , a7 out nocopy JTF_VARCHAR2_TABLE_100
99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_NUMBER_TABLE
101: , a10 out nocopy JTF_DATE_TABLE
95: , a4 out nocopy JTF_VARCHAR2_TABLE_100
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_NUMBER_TABLE
98: , a7 out nocopy JTF_VARCHAR2_TABLE_100
99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_NUMBER_TABLE
101: , a10 out nocopy JTF_DATE_TABLE
102: , a11 out nocopy JTF_NUMBER_TABLE
103: , a12 out nocopy JTF_DATE_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_NUMBER_TABLE
98: , a7 out nocopy JTF_VARCHAR2_TABLE_100
99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_NUMBER_TABLE
101: , a10 out nocopy JTF_DATE_TABLE
102: , a11 out nocopy JTF_NUMBER_TABLE
103: , a12 out nocopy JTF_DATE_TABLE
104: , a13 out nocopy JTF_DATE_TABLE
98: , a7 out nocopy JTF_VARCHAR2_TABLE_100
99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_NUMBER_TABLE
101: , a10 out nocopy JTF_DATE_TABLE
102: , a11 out nocopy JTF_NUMBER_TABLE
103: , a12 out nocopy JTF_DATE_TABLE
104: , a13 out nocopy JTF_DATE_TABLE
105: , a14 out nocopy JTF_DATE_TABLE
106: , a15 out nocopy JTF_DATE_TABLE
104: , a13 out nocopy JTF_DATE_TABLE
105: , a14 out nocopy JTF_DATE_TABLE
106: , a15 out nocopy JTF_DATE_TABLE
107: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
108: , a17 out nocopy JTF_NUMBER_TABLE
109: , a18 out nocopy JTF_NUMBER_TABLE
110: , a19 out nocopy JTF_NUMBER_TABLE
111: , a20 out nocopy JTF_DATE_TABLE
112: , a21 out nocopy JTF_NUMBER_TABLE
105: , a14 out nocopy JTF_DATE_TABLE
106: , a15 out nocopy JTF_DATE_TABLE
107: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
108: , a17 out nocopy JTF_NUMBER_TABLE
109: , a18 out nocopy JTF_NUMBER_TABLE
110: , a19 out nocopy JTF_NUMBER_TABLE
111: , a20 out nocopy JTF_DATE_TABLE
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_VARCHAR2_TABLE_100
106: , a15 out nocopy JTF_DATE_TABLE
107: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
108: , a17 out nocopy JTF_NUMBER_TABLE
109: , a18 out nocopy JTF_NUMBER_TABLE
110: , a19 out nocopy JTF_NUMBER_TABLE
111: , a20 out nocopy JTF_DATE_TABLE
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_VARCHAR2_TABLE_100
114: , a23 out nocopy JTF_NUMBER_TABLE
108: , a17 out nocopy JTF_NUMBER_TABLE
109: , a18 out nocopy JTF_NUMBER_TABLE
110: , a19 out nocopy JTF_NUMBER_TABLE
111: , a20 out nocopy JTF_DATE_TABLE
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_VARCHAR2_TABLE_100
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_NUMBER_TABLE
116: , a25 out nocopy JTF_VARCHAR2_TABLE_100
110: , a19 out nocopy JTF_NUMBER_TABLE
111: , a20 out nocopy JTF_DATE_TABLE
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_VARCHAR2_TABLE_100
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_NUMBER_TABLE
116: , a25 out nocopy JTF_VARCHAR2_TABLE_100
117: , a26 out nocopy JTF_NUMBER_TABLE
118: , a27 out nocopy JTF_NUMBER_TABLE
111: , a20 out nocopy JTF_DATE_TABLE
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_VARCHAR2_TABLE_100
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_NUMBER_TABLE
116: , a25 out nocopy JTF_VARCHAR2_TABLE_100
117: , a26 out nocopy JTF_NUMBER_TABLE
118: , a27 out nocopy JTF_NUMBER_TABLE
119: );
113: , a22 out nocopy JTF_VARCHAR2_TABLE_100
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_NUMBER_TABLE
116: , a25 out nocopy JTF_VARCHAR2_TABLE_100
117: , a26 out nocopy JTF_NUMBER_TABLE
118: , a27 out nocopy JTF_NUMBER_TABLE
119: );
120:
121: procedure insert_row(p_api_version NUMBER
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_NUMBER_TABLE
116: , a25 out nocopy JTF_VARCHAR2_TABLE_100
117: , a26 out nocopy JTF_NUMBER_TABLE
118: , a27 out nocopy JTF_NUMBER_TABLE
119: );
120:
121: procedure insert_row(p_api_version NUMBER
122: , p_init_msg_list VARCHAR2
184: , p_init_msg_list VARCHAR2
185: , x_return_status out nocopy VARCHAR2
186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_VARCHAR2_TABLE_100
185: , x_return_status out nocopy VARCHAR2
186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_VARCHAR2_TABLE_100
193: , p5_a5 JTF_VARCHAR2_TABLE_100
186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_VARCHAR2_TABLE_100
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_NUMBER_TABLE
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_VARCHAR2_TABLE_100
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_NUMBER_TABLE
195: , p5_a7 JTF_VARCHAR2_TABLE_100
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_VARCHAR2_TABLE_100
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_NUMBER_TABLE
195: , p5_a7 JTF_VARCHAR2_TABLE_100
196: , p5_a8 JTF_NUMBER_TABLE
197: , p5_a9 JTF_NUMBER_TABLE
198: , p5_a10 JTF_DATE_TABLE
192: , p5_a4 JTF_VARCHAR2_TABLE_100
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_NUMBER_TABLE
195: , p5_a7 JTF_VARCHAR2_TABLE_100
196: , p5_a8 JTF_NUMBER_TABLE
197: , p5_a9 JTF_NUMBER_TABLE
198: , p5_a10 JTF_DATE_TABLE
199: , p5_a11 JTF_NUMBER_TABLE
200: , p5_a12 JTF_DATE_TABLE
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_NUMBER_TABLE
195: , p5_a7 JTF_VARCHAR2_TABLE_100
196: , p5_a8 JTF_NUMBER_TABLE
197: , p5_a9 JTF_NUMBER_TABLE
198: , p5_a10 JTF_DATE_TABLE
199: , p5_a11 JTF_NUMBER_TABLE
200: , p5_a12 JTF_DATE_TABLE
201: , p5_a13 JTF_DATE_TABLE
195: , p5_a7 JTF_VARCHAR2_TABLE_100
196: , p5_a8 JTF_NUMBER_TABLE
197: , p5_a9 JTF_NUMBER_TABLE
198: , p5_a10 JTF_DATE_TABLE
199: , p5_a11 JTF_NUMBER_TABLE
200: , p5_a12 JTF_DATE_TABLE
201: , p5_a13 JTF_DATE_TABLE
202: , p5_a14 JTF_DATE_TABLE
203: , p5_a15 JTF_DATE_TABLE
201: , p5_a13 JTF_DATE_TABLE
202: , p5_a14 JTF_DATE_TABLE
203: , p5_a15 JTF_DATE_TABLE
204: , p5_a16 JTF_VARCHAR2_TABLE_2000
205: , p5_a17 JTF_NUMBER_TABLE
206: , p5_a18 JTF_NUMBER_TABLE
207: , p5_a19 JTF_NUMBER_TABLE
208: , p5_a20 JTF_DATE_TABLE
209: , p5_a21 JTF_NUMBER_TABLE
202: , p5_a14 JTF_DATE_TABLE
203: , p5_a15 JTF_DATE_TABLE
204: , p5_a16 JTF_VARCHAR2_TABLE_2000
205: , p5_a17 JTF_NUMBER_TABLE
206: , p5_a18 JTF_NUMBER_TABLE
207: , p5_a19 JTF_NUMBER_TABLE
208: , p5_a20 JTF_DATE_TABLE
209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_VARCHAR2_TABLE_100
203: , p5_a15 JTF_DATE_TABLE
204: , p5_a16 JTF_VARCHAR2_TABLE_2000
205: , p5_a17 JTF_NUMBER_TABLE
206: , p5_a18 JTF_NUMBER_TABLE
207: , p5_a19 JTF_NUMBER_TABLE
208: , p5_a20 JTF_DATE_TABLE
209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_VARCHAR2_TABLE_100
211: , p5_a23 JTF_NUMBER_TABLE
205: , p5_a17 JTF_NUMBER_TABLE
206: , p5_a18 JTF_NUMBER_TABLE
207: , p5_a19 JTF_NUMBER_TABLE
208: , p5_a20 JTF_DATE_TABLE
209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_VARCHAR2_TABLE_100
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_NUMBER_TABLE
213: , p5_a25 JTF_VARCHAR2_TABLE_100
207: , p5_a19 JTF_NUMBER_TABLE
208: , p5_a20 JTF_DATE_TABLE
209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_VARCHAR2_TABLE_100
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_NUMBER_TABLE
213: , p5_a25 JTF_VARCHAR2_TABLE_100
214: , p5_a26 JTF_NUMBER_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
208: , p5_a20 JTF_DATE_TABLE
209: , p5_a21 JTF_NUMBER_TABLE
210: , p5_a22 JTF_VARCHAR2_TABLE_100
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_NUMBER_TABLE
213: , p5_a25 JTF_VARCHAR2_TABLE_100
214: , p5_a26 JTF_NUMBER_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p5_a22 JTF_VARCHAR2_TABLE_100
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_NUMBER_TABLE
213: , p5_a25 JTF_VARCHAR2_TABLE_100
214: , p5_a26 JTF_NUMBER_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_NUMBER_TABLE
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_NUMBER_TABLE
213: , p5_a25 JTF_VARCHAR2_TABLE_100
214: , p5_a26 JTF_NUMBER_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_NUMBER_TABLE
219: , p6_a3 out nocopy JTF_NUMBER_TABLE
212: , p5_a24 JTF_NUMBER_TABLE
213: , p5_a25 JTF_VARCHAR2_TABLE_100
214: , p5_a26 JTF_NUMBER_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_NUMBER_TABLE
219: , p6_a3 out nocopy JTF_NUMBER_TABLE
220: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
213: , p5_a25 JTF_VARCHAR2_TABLE_100
214: , p5_a26 JTF_NUMBER_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_NUMBER_TABLE
219: , p6_a3 out nocopy JTF_NUMBER_TABLE
220: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
214: , p5_a26 JTF_NUMBER_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_NUMBER_TABLE
219: , p6_a3 out nocopy JTF_NUMBER_TABLE
220: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a6 out nocopy JTF_NUMBER_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_NUMBER_TABLE
219: , p6_a3 out nocopy JTF_NUMBER_TABLE
220: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a6 out nocopy JTF_NUMBER_TABLE
223: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
218: , p6_a2 out nocopy JTF_NUMBER_TABLE
219: , p6_a3 out nocopy JTF_NUMBER_TABLE
220: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a6 out nocopy JTF_NUMBER_TABLE
223: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
224: , p6_a8 out nocopy JTF_NUMBER_TABLE
225: , p6_a9 out nocopy JTF_NUMBER_TABLE
226: , p6_a10 out nocopy JTF_DATE_TABLE
220: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a6 out nocopy JTF_NUMBER_TABLE
223: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
224: , p6_a8 out nocopy JTF_NUMBER_TABLE
225: , p6_a9 out nocopy JTF_NUMBER_TABLE
226: , p6_a10 out nocopy JTF_DATE_TABLE
227: , p6_a11 out nocopy JTF_NUMBER_TABLE
228: , p6_a12 out nocopy JTF_DATE_TABLE
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a6 out nocopy JTF_NUMBER_TABLE
223: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
224: , p6_a8 out nocopy JTF_NUMBER_TABLE
225: , p6_a9 out nocopy JTF_NUMBER_TABLE
226: , p6_a10 out nocopy JTF_DATE_TABLE
227: , p6_a11 out nocopy JTF_NUMBER_TABLE
228: , p6_a12 out nocopy JTF_DATE_TABLE
229: , p6_a13 out nocopy JTF_DATE_TABLE
223: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
224: , p6_a8 out nocopy JTF_NUMBER_TABLE
225: , p6_a9 out nocopy JTF_NUMBER_TABLE
226: , p6_a10 out nocopy JTF_DATE_TABLE
227: , p6_a11 out nocopy JTF_NUMBER_TABLE
228: , p6_a12 out nocopy JTF_DATE_TABLE
229: , p6_a13 out nocopy JTF_DATE_TABLE
230: , p6_a14 out nocopy JTF_DATE_TABLE
231: , p6_a15 out nocopy JTF_DATE_TABLE
229: , p6_a13 out nocopy JTF_DATE_TABLE
230: , p6_a14 out nocopy JTF_DATE_TABLE
231: , p6_a15 out nocopy JTF_DATE_TABLE
232: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
233: , p6_a17 out nocopy JTF_NUMBER_TABLE
234: , p6_a18 out nocopy JTF_NUMBER_TABLE
235: , p6_a19 out nocopy JTF_NUMBER_TABLE
236: , p6_a20 out nocopy JTF_DATE_TABLE
237: , p6_a21 out nocopy JTF_NUMBER_TABLE
230: , p6_a14 out nocopy JTF_DATE_TABLE
231: , p6_a15 out nocopy JTF_DATE_TABLE
232: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
233: , p6_a17 out nocopy JTF_NUMBER_TABLE
234: , p6_a18 out nocopy JTF_NUMBER_TABLE
235: , p6_a19 out nocopy JTF_NUMBER_TABLE
236: , p6_a20 out nocopy JTF_DATE_TABLE
237: , p6_a21 out nocopy JTF_NUMBER_TABLE
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a15 out nocopy JTF_DATE_TABLE
232: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
233: , p6_a17 out nocopy JTF_NUMBER_TABLE
234: , p6_a18 out nocopy JTF_NUMBER_TABLE
235: , p6_a19 out nocopy JTF_NUMBER_TABLE
236: , p6_a20 out nocopy JTF_DATE_TABLE
237: , p6_a21 out nocopy JTF_NUMBER_TABLE
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
233: , p6_a17 out nocopy JTF_NUMBER_TABLE
234: , p6_a18 out nocopy JTF_NUMBER_TABLE
235: , p6_a19 out nocopy JTF_NUMBER_TABLE
236: , p6_a20 out nocopy JTF_DATE_TABLE
237: , p6_a21 out nocopy JTF_NUMBER_TABLE
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_NUMBER_TABLE
241: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
235: , p6_a19 out nocopy JTF_NUMBER_TABLE
236: , p6_a20 out nocopy JTF_DATE_TABLE
237: , p6_a21 out nocopy JTF_NUMBER_TABLE
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_NUMBER_TABLE
241: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
242: , p6_a26 out nocopy JTF_NUMBER_TABLE
243: , p6_a27 out nocopy JTF_NUMBER_TABLE
236: , p6_a20 out nocopy JTF_DATE_TABLE
237: , p6_a21 out nocopy JTF_NUMBER_TABLE
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_NUMBER_TABLE
241: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
242: , p6_a26 out nocopy JTF_NUMBER_TABLE
243: , p6_a27 out nocopy JTF_NUMBER_TABLE
244: );
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_NUMBER_TABLE
241: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
242: , p6_a26 out nocopy JTF_NUMBER_TABLE
243: , p6_a27 out nocopy JTF_NUMBER_TABLE
244: );
245: procedure lock_row(p_api_version NUMBER
246: , p_init_msg_list VARCHAR2
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_NUMBER_TABLE
241: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
242: , p6_a26 out nocopy JTF_NUMBER_TABLE
243: , p6_a27 out nocopy JTF_NUMBER_TABLE
244: );
245: procedure lock_row(p_api_version NUMBER
246: , p_init_msg_list VARCHAR2
247: , x_return_status out nocopy VARCHAR2
280: , p_init_msg_list VARCHAR2
281: , x_return_status out nocopy VARCHAR2
282: , x_msg_count out nocopy NUMBER
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_VARCHAR2_TABLE_100
281: , x_return_status out nocopy VARCHAR2
282: , x_msg_count out nocopy NUMBER
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_VARCHAR2_TABLE_100
289: , p5_a5 JTF_VARCHAR2_TABLE_100
282: , x_msg_count out nocopy NUMBER
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_VARCHAR2_TABLE_100
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_NUMBER_TABLE
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_VARCHAR2_TABLE_100
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_NUMBER_TABLE
291: , p5_a7 JTF_VARCHAR2_TABLE_100
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_VARCHAR2_TABLE_100
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_NUMBER_TABLE
291: , p5_a7 JTF_VARCHAR2_TABLE_100
292: , p5_a8 JTF_NUMBER_TABLE
293: , p5_a9 JTF_NUMBER_TABLE
294: , p5_a10 JTF_DATE_TABLE
288: , p5_a4 JTF_VARCHAR2_TABLE_100
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_NUMBER_TABLE
291: , p5_a7 JTF_VARCHAR2_TABLE_100
292: , p5_a8 JTF_NUMBER_TABLE
293: , p5_a9 JTF_NUMBER_TABLE
294: , p5_a10 JTF_DATE_TABLE
295: , p5_a11 JTF_NUMBER_TABLE
296: , p5_a12 JTF_DATE_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_NUMBER_TABLE
291: , p5_a7 JTF_VARCHAR2_TABLE_100
292: , p5_a8 JTF_NUMBER_TABLE
293: , p5_a9 JTF_NUMBER_TABLE
294: , p5_a10 JTF_DATE_TABLE
295: , p5_a11 JTF_NUMBER_TABLE
296: , p5_a12 JTF_DATE_TABLE
297: , p5_a13 JTF_DATE_TABLE
291: , p5_a7 JTF_VARCHAR2_TABLE_100
292: , p5_a8 JTF_NUMBER_TABLE
293: , p5_a9 JTF_NUMBER_TABLE
294: , p5_a10 JTF_DATE_TABLE
295: , p5_a11 JTF_NUMBER_TABLE
296: , p5_a12 JTF_DATE_TABLE
297: , p5_a13 JTF_DATE_TABLE
298: , p5_a14 JTF_DATE_TABLE
299: , p5_a15 JTF_DATE_TABLE
297: , p5_a13 JTF_DATE_TABLE
298: , p5_a14 JTF_DATE_TABLE
299: , p5_a15 JTF_DATE_TABLE
300: , p5_a16 JTF_VARCHAR2_TABLE_2000
301: , p5_a17 JTF_NUMBER_TABLE
302: , p5_a18 JTF_NUMBER_TABLE
303: , p5_a19 JTF_NUMBER_TABLE
304: , p5_a20 JTF_DATE_TABLE
305: , p5_a21 JTF_NUMBER_TABLE
298: , p5_a14 JTF_DATE_TABLE
299: , p5_a15 JTF_DATE_TABLE
300: , p5_a16 JTF_VARCHAR2_TABLE_2000
301: , p5_a17 JTF_NUMBER_TABLE
302: , p5_a18 JTF_NUMBER_TABLE
303: , p5_a19 JTF_NUMBER_TABLE
304: , p5_a20 JTF_DATE_TABLE
305: , p5_a21 JTF_NUMBER_TABLE
306: , p5_a22 JTF_VARCHAR2_TABLE_100
299: , p5_a15 JTF_DATE_TABLE
300: , p5_a16 JTF_VARCHAR2_TABLE_2000
301: , p5_a17 JTF_NUMBER_TABLE
302: , p5_a18 JTF_NUMBER_TABLE
303: , p5_a19 JTF_NUMBER_TABLE
304: , p5_a20 JTF_DATE_TABLE
305: , p5_a21 JTF_NUMBER_TABLE
306: , p5_a22 JTF_VARCHAR2_TABLE_100
307: , p5_a23 JTF_NUMBER_TABLE
301: , p5_a17 JTF_NUMBER_TABLE
302: , p5_a18 JTF_NUMBER_TABLE
303: , p5_a19 JTF_NUMBER_TABLE
304: , p5_a20 JTF_DATE_TABLE
305: , p5_a21 JTF_NUMBER_TABLE
306: , p5_a22 JTF_VARCHAR2_TABLE_100
307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_NUMBER_TABLE
309: , p5_a25 JTF_VARCHAR2_TABLE_100
303: , p5_a19 JTF_NUMBER_TABLE
304: , p5_a20 JTF_DATE_TABLE
305: , p5_a21 JTF_NUMBER_TABLE
306: , p5_a22 JTF_VARCHAR2_TABLE_100
307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_NUMBER_TABLE
309: , p5_a25 JTF_VARCHAR2_TABLE_100
310: , p5_a26 JTF_NUMBER_TABLE
311: , p5_a27 JTF_NUMBER_TABLE
304: , p5_a20 JTF_DATE_TABLE
305: , p5_a21 JTF_NUMBER_TABLE
306: , p5_a22 JTF_VARCHAR2_TABLE_100
307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_NUMBER_TABLE
309: , p5_a25 JTF_VARCHAR2_TABLE_100
310: , p5_a26 JTF_NUMBER_TABLE
311: , p5_a27 JTF_NUMBER_TABLE
312: );
306: , p5_a22 JTF_VARCHAR2_TABLE_100
307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_NUMBER_TABLE
309: , p5_a25 JTF_VARCHAR2_TABLE_100
310: , p5_a26 JTF_NUMBER_TABLE
311: , p5_a27 JTF_NUMBER_TABLE
312: );
313: procedure update_row(p_api_version NUMBER
314: , p_init_msg_list VARCHAR2
307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_NUMBER_TABLE
309: , p5_a25 JTF_VARCHAR2_TABLE_100
310: , p5_a26 JTF_NUMBER_TABLE
311: , p5_a27 JTF_NUMBER_TABLE
312: );
313: procedure update_row(p_api_version NUMBER
314: , p_init_msg_list VARCHAR2
315: , x_return_status out nocopy VARCHAR2
376: , p_init_msg_list VARCHAR2
377: , x_return_status out nocopy VARCHAR2
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_NUMBER_TABLE
384: , p5_a4 JTF_VARCHAR2_TABLE_100
377: , x_return_status out nocopy VARCHAR2
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_NUMBER_TABLE
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_VARCHAR2_TABLE_100
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_NUMBER_TABLE
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_VARCHAR2_TABLE_100
386: , p5_a6 JTF_NUMBER_TABLE
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_NUMBER_TABLE
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_VARCHAR2_TABLE_100
386: , p5_a6 JTF_NUMBER_TABLE
387: , p5_a7 JTF_VARCHAR2_TABLE_100
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_NUMBER_TABLE
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_VARCHAR2_TABLE_100
386: , p5_a6 JTF_NUMBER_TABLE
387: , p5_a7 JTF_VARCHAR2_TABLE_100
388: , p5_a8 JTF_NUMBER_TABLE
389: , p5_a9 JTF_NUMBER_TABLE
390: , p5_a10 JTF_DATE_TABLE
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_VARCHAR2_TABLE_100
386: , p5_a6 JTF_NUMBER_TABLE
387: , p5_a7 JTF_VARCHAR2_TABLE_100
388: , p5_a8 JTF_NUMBER_TABLE
389: , p5_a9 JTF_NUMBER_TABLE
390: , p5_a10 JTF_DATE_TABLE
391: , p5_a11 JTF_NUMBER_TABLE
392: , p5_a12 JTF_DATE_TABLE
385: , p5_a5 JTF_VARCHAR2_TABLE_100
386: , p5_a6 JTF_NUMBER_TABLE
387: , p5_a7 JTF_VARCHAR2_TABLE_100
388: , p5_a8 JTF_NUMBER_TABLE
389: , p5_a9 JTF_NUMBER_TABLE
390: , p5_a10 JTF_DATE_TABLE
391: , p5_a11 JTF_NUMBER_TABLE
392: , p5_a12 JTF_DATE_TABLE
393: , p5_a13 JTF_DATE_TABLE
387: , p5_a7 JTF_VARCHAR2_TABLE_100
388: , p5_a8 JTF_NUMBER_TABLE
389: , p5_a9 JTF_NUMBER_TABLE
390: , p5_a10 JTF_DATE_TABLE
391: , p5_a11 JTF_NUMBER_TABLE
392: , p5_a12 JTF_DATE_TABLE
393: , p5_a13 JTF_DATE_TABLE
394: , p5_a14 JTF_DATE_TABLE
395: , p5_a15 JTF_DATE_TABLE
393: , p5_a13 JTF_DATE_TABLE
394: , p5_a14 JTF_DATE_TABLE
395: , p5_a15 JTF_DATE_TABLE
396: , p5_a16 JTF_VARCHAR2_TABLE_2000
397: , p5_a17 JTF_NUMBER_TABLE
398: , p5_a18 JTF_NUMBER_TABLE
399: , p5_a19 JTF_NUMBER_TABLE
400: , p5_a20 JTF_DATE_TABLE
401: , p5_a21 JTF_NUMBER_TABLE
394: , p5_a14 JTF_DATE_TABLE
395: , p5_a15 JTF_DATE_TABLE
396: , p5_a16 JTF_VARCHAR2_TABLE_2000
397: , p5_a17 JTF_NUMBER_TABLE
398: , p5_a18 JTF_NUMBER_TABLE
399: , p5_a19 JTF_NUMBER_TABLE
400: , p5_a20 JTF_DATE_TABLE
401: , p5_a21 JTF_NUMBER_TABLE
402: , p5_a22 JTF_VARCHAR2_TABLE_100
395: , p5_a15 JTF_DATE_TABLE
396: , p5_a16 JTF_VARCHAR2_TABLE_2000
397: , p5_a17 JTF_NUMBER_TABLE
398: , p5_a18 JTF_NUMBER_TABLE
399: , p5_a19 JTF_NUMBER_TABLE
400: , p5_a20 JTF_DATE_TABLE
401: , p5_a21 JTF_NUMBER_TABLE
402: , p5_a22 JTF_VARCHAR2_TABLE_100
403: , p5_a23 JTF_NUMBER_TABLE
397: , p5_a17 JTF_NUMBER_TABLE
398: , p5_a18 JTF_NUMBER_TABLE
399: , p5_a19 JTF_NUMBER_TABLE
400: , p5_a20 JTF_DATE_TABLE
401: , p5_a21 JTF_NUMBER_TABLE
402: , p5_a22 JTF_VARCHAR2_TABLE_100
403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p5_a25 JTF_VARCHAR2_TABLE_100
399: , p5_a19 JTF_NUMBER_TABLE
400: , p5_a20 JTF_DATE_TABLE
401: , p5_a21 JTF_NUMBER_TABLE
402: , p5_a22 JTF_VARCHAR2_TABLE_100
403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p5_a25 JTF_VARCHAR2_TABLE_100
406: , p5_a26 JTF_NUMBER_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
400: , p5_a20 JTF_DATE_TABLE
401: , p5_a21 JTF_NUMBER_TABLE
402: , p5_a22 JTF_VARCHAR2_TABLE_100
403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p5_a25 JTF_VARCHAR2_TABLE_100
406: , p5_a26 JTF_NUMBER_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
402: , p5_a22 JTF_VARCHAR2_TABLE_100
403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p5_a25 JTF_VARCHAR2_TABLE_100
406: , p5_a26 JTF_NUMBER_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_NUMBER_TABLE
403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p5_a25 JTF_VARCHAR2_TABLE_100
406: , p5_a26 JTF_NUMBER_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_NUMBER_TABLE
411: , p6_a3 out nocopy JTF_NUMBER_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p5_a25 JTF_VARCHAR2_TABLE_100
406: , p5_a26 JTF_NUMBER_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_NUMBER_TABLE
411: , p6_a3 out nocopy JTF_NUMBER_TABLE
412: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
405: , p5_a25 JTF_VARCHAR2_TABLE_100
406: , p5_a26 JTF_NUMBER_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_NUMBER_TABLE
411: , p6_a3 out nocopy JTF_NUMBER_TABLE
412: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
406: , p5_a26 JTF_NUMBER_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_NUMBER_TABLE
411: , p6_a3 out nocopy JTF_NUMBER_TABLE
412: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a6 out nocopy JTF_NUMBER_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_NUMBER_TABLE
411: , p6_a3 out nocopy JTF_NUMBER_TABLE
412: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a6 out nocopy JTF_NUMBER_TABLE
415: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
410: , p6_a2 out nocopy JTF_NUMBER_TABLE
411: , p6_a3 out nocopy JTF_NUMBER_TABLE
412: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a6 out nocopy JTF_NUMBER_TABLE
415: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a8 out nocopy JTF_NUMBER_TABLE
417: , p6_a9 out nocopy JTF_NUMBER_TABLE
418: , p6_a10 out nocopy JTF_DATE_TABLE
412: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a6 out nocopy JTF_NUMBER_TABLE
415: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a8 out nocopy JTF_NUMBER_TABLE
417: , p6_a9 out nocopy JTF_NUMBER_TABLE
418: , p6_a10 out nocopy JTF_DATE_TABLE
419: , p6_a11 out nocopy JTF_NUMBER_TABLE
420: , p6_a12 out nocopy JTF_DATE_TABLE
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a6 out nocopy JTF_NUMBER_TABLE
415: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a8 out nocopy JTF_NUMBER_TABLE
417: , p6_a9 out nocopy JTF_NUMBER_TABLE
418: , p6_a10 out nocopy JTF_DATE_TABLE
419: , p6_a11 out nocopy JTF_NUMBER_TABLE
420: , p6_a12 out nocopy JTF_DATE_TABLE
421: , p6_a13 out nocopy JTF_DATE_TABLE
415: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a8 out nocopy JTF_NUMBER_TABLE
417: , p6_a9 out nocopy JTF_NUMBER_TABLE
418: , p6_a10 out nocopy JTF_DATE_TABLE
419: , p6_a11 out nocopy JTF_NUMBER_TABLE
420: , p6_a12 out nocopy JTF_DATE_TABLE
421: , p6_a13 out nocopy JTF_DATE_TABLE
422: , p6_a14 out nocopy JTF_DATE_TABLE
423: , p6_a15 out nocopy JTF_DATE_TABLE
421: , p6_a13 out nocopy JTF_DATE_TABLE
422: , p6_a14 out nocopy JTF_DATE_TABLE
423: , p6_a15 out nocopy JTF_DATE_TABLE
424: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
425: , p6_a17 out nocopy JTF_NUMBER_TABLE
426: , p6_a18 out nocopy JTF_NUMBER_TABLE
427: , p6_a19 out nocopy JTF_NUMBER_TABLE
428: , p6_a20 out nocopy JTF_DATE_TABLE
429: , p6_a21 out nocopy JTF_NUMBER_TABLE
422: , p6_a14 out nocopy JTF_DATE_TABLE
423: , p6_a15 out nocopy JTF_DATE_TABLE
424: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
425: , p6_a17 out nocopy JTF_NUMBER_TABLE
426: , p6_a18 out nocopy JTF_NUMBER_TABLE
427: , p6_a19 out nocopy JTF_NUMBER_TABLE
428: , p6_a20 out nocopy JTF_DATE_TABLE
429: , p6_a21 out nocopy JTF_NUMBER_TABLE
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a15 out nocopy JTF_DATE_TABLE
424: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
425: , p6_a17 out nocopy JTF_NUMBER_TABLE
426: , p6_a18 out nocopy JTF_NUMBER_TABLE
427: , p6_a19 out nocopy JTF_NUMBER_TABLE
428: , p6_a20 out nocopy JTF_DATE_TABLE
429: , p6_a21 out nocopy JTF_NUMBER_TABLE
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
425: , p6_a17 out nocopy JTF_NUMBER_TABLE
426: , p6_a18 out nocopy JTF_NUMBER_TABLE
427: , p6_a19 out nocopy JTF_NUMBER_TABLE
428: , p6_a20 out nocopy JTF_DATE_TABLE
429: , p6_a21 out nocopy JTF_NUMBER_TABLE
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_NUMBER_TABLE
433: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a19 out nocopy JTF_NUMBER_TABLE
428: , p6_a20 out nocopy JTF_DATE_TABLE
429: , p6_a21 out nocopy JTF_NUMBER_TABLE
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_NUMBER_TABLE
433: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
434: , p6_a26 out nocopy JTF_NUMBER_TABLE
435: , p6_a27 out nocopy JTF_NUMBER_TABLE
428: , p6_a20 out nocopy JTF_DATE_TABLE
429: , p6_a21 out nocopy JTF_NUMBER_TABLE
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_NUMBER_TABLE
433: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
434: , p6_a26 out nocopy JTF_NUMBER_TABLE
435: , p6_a27 out nocopy JTF_NUMBER_TABLE
436: );
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_NUMBER_TABLE
433: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
434: , p6_a26 out nocopy JTF_NUMBER_TABLE
435: , p6_a27 out nocopy JTF_NUMBER_TABLE
436: );
437: procedure delete_row(p_api_version NUMBER
438: , p_init_msg_list VARCHAR2
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_NUMBER_TABLE
433: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
434: , p6_a26 out nocopy JTF_NUMBER_TABLE
435: , p6_a27 out nocopy JTF_NUMBER_TABLE
436: );
437: procedure delete_row(p_api_version NUMBER
438: , p_init_msg_list VARCHAR2
439: , x_return_status out nocopy VARCHAR2
472: , p_init_msg_list VARCHAR2
473: , x_return_status out nocopy VARCHAR2
474: , x_msg_count out nocopy NUMBER
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_NUMBER_TABLE
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_100
473: , x_return_status out nocopy VARCHAR2
474: , x_msg_count out nocopy NUMBER
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_NUMBER_TABLE
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_100
481: , p5_a5 JTF_VARCHAR2_TABLE_100
474: , x_msg_count out nocopy NUMBER
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_NUMBER_TABLE
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_100
481: , p5_a5 JTF_VARCHAR2_TABLE_100
482: , p5_a6 JTF_NUMBER_TABLE
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_NUMBER_TABLE
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_100
481: , p5_a5 JTF_VARCHAR2_TABLE_100
482: , p5_a6 JTF_NUMBER_TABLE
483: , p5_a7 JTF_VARCHAR2_TABLE_100
478: , p5_a2 JTF_NUMBER_TABLE
479: , p5_a3 JTF_NUMBER_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_100
481: , p5_a5 JTF_VARCHAR2_TABLE_100
482: , p5_a6 JTF_NUMBER_TABLE
483: , p5_a7 JTF_VARCHAR2_TABLE_100
484: , p5_a8 JTF_NUMBER_TABLE
485: , p5_a9 JTF_NUMBER_TABLE
486: , p5_a10 JTF_DATE_TABLE
480: , p5_a4 JTF_VARCHAR2_TABLE_100
481: , p5_a5 JTF_VARCHAR2_TABLE_100
482: , p5_a6 JTF_NUMBER_TABLE
483: , p5_a7 JTF_VARCHAR2_TABLE_100
484: , p5_a8 JTF_NUMBER_TABLE
485: , p5_a9 JTF_NUMBER_TABLE
486: , p5_a10 JTF_DATE_TABLE
487: , p5_a11 JTF_NUMBER_TABLE
488: , p5_a12 JTF_DATE_TABLE
481: , p5_a5 JTF_VARCHAR2_TABLE_100
482: , p5_a6 JTF_NUMBER_TABLE
483: , p5_a7 JTF_VARCHAR2_TABLE_100
484: , p5_a8 JTF_NUMBER_TABLE
485: , p5_a9 JTF_NUMBER_TABLE
486: , p5_a10 JTF_DATE_TABLE
487: , p5_a11 JTF_NUMBER_TABLE
488: , p5_a12 JTF_DATE_TABLE
489: , p5_a13 JTF_DATE_TABLE
483: , p5_a7 JTF_VARCHAR2_TABLE_100
484: , p5_a8 JTF_NUMBER_TABLE
485: , p5_a9 JTF_NUMBER_TABLE
486: , p5_a10 JTF_DATE_TABLE
487: , p5_a11 JTF_NUMBER_TABLE
488: , p5_a12 JTF_DATE_TABLE
489: , p5_a13 JTF_DATE_TABLE
490: , p5_a14 JTF_DATE_TABLE
491: , p5_a15 JTF_DATE_TABLE
489: , p5_a13 JTF_DATE_TABLE
490: , p5_a14 JTF_DATE_TABLE
491: , p5_a15 JTF_DATE_TABLE
492: , p5_a16 JTF_VARCHAR2_TABLE_2000
493: , p5_a17 JTF_NUMBER_TABLE
494: , p5_a18 JTF_NUMBER_TABLE
495: , p5_a19 JTF_NUMBER_TABLE
496: , p5_a20 JTF_DATE_TABLE
497: , p5_a21 JTF_NUMBER_TABLE
490: , p5_a14 JTF_DATE_TABLE
491: , p5_a15 JTF_DATE_TABLE
492: , p5_a16 JTF_VARCHAR2_TABLE_2000
493: , p5_a17 JTF_NUMBER_TABLE
494: , p5_a18 JTF_NUMBER_TABLE
495: , p5_a19 JTF_NUMBER_TABLE
496: , p5_a20 JTF_DATE_TABLE
497: , p5_a21 JTF_NUMBER_TABLE
498: , p5_a22 JTF_VARCHAR2_TABLE_100
491: , p5_a15 JTF_DATE_TABLE
492: , p5_a16 JTF_VARCHAR2_TABLE_2000
493: , p5_a17 JTF_NUMBER_TABLE
494: , p5_a18 JTF_NUMBER_TABLE
495: , p5_a19 JTF_NUMBER_TABLE
496: , p5_a20 JTF_DATE_TABLE
497: , p5_a21 JTF_NUMBER_TABLE
498: , p5_a22 JTF_VARCHAR2_TABLE_100
499: , p5_a23 JTF_NUMBER_TABLE
493: , p5_a17 JTF_NUMBER_TABLE
494: , p5_a18 JTF_NUMBER_TABLE
495: , p5_a19 JTF_NUMBER_TABLE
496: , p5_a20 JTF_DATE_TABLE
497: , p5_a21 JTF_NUMBER_TABLE
498: , p5_a22 JTF_VARCHAR2_TABLE_100
499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_NUMBER_TABLE
501: , p5_a25 JTF_VARCHAR2_TABLE_100
495: , p5_a19 JTF_NUMBER_TABLE
496: , p5_a20 JTF_DATE_TABLE
497: , p5_a21 JTF_NUMBER_TABLE
498: , p5_a22 JTF_VARCHAR2_TABLE_100
499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_NUMBER_TABLE
501: , p5_a25 JTF_VARCHAR2_TABLE_100
502: , p5_a26 JTF_NUMBER_TABLE
503: , p5_a27 JTF_NUMBER_TABLE
496: , p5_a20 JTF_DATE_TABLE
497: , p5_a21 JTF_NUMBER_TABLE
498: , p5_a22 JTF_VARCHAR2_TABLE_100
499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_NUMBER_TABLE
501: , p5_a25 JTF_VARCHAR2_TABLE_100
502: , p5_a26 JTF_NUMBER_TABLE
503: , p5_a27 JTF_NUMBER_TABLE
504: );
498: , p5_a22 JTF_VARCHAR2_TABLE_100
499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_NUMBER_TABLE
501: , p5_a25 JTF_VARCHAR2_TABLE_100
502: , p5_a26 JTF_NUMBER_TABLE
503: , p5_a27 JTF_NUMBER_TABLE
504: );
505: procedure validate_row(p_api_version NUMBER
506: , p_init_msg_list VARCHAR2
499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_NUMBER_TABLE
501: , p5_a25 JTF_VARCHAR2_TABLE_100
502: , p5_a26 JTF_NUMBER_TABLE
503: , p5_a27 JTF_NUMBER_TABLE
504: );
505: procedure validate_row(p_api_version NUMBER
506: , p_init_msg_list VARCHAR2
507: , x_return_status out nocopy VARCHAR2
540: , p_init_msg_list VARCHAR2
541: , x_return_status out nocopy VARCHAR2
542: , x_msg_count out nocopy NUMBER
543: , x_msg_data out nocopy VARCHAR2
544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_NUMBER_TABLE
547: , p5_a3 JTF_NUMBER_TABLE
548: , p5_a4 JTF_VARCHAR2_TABLE_100
541: , x_return_status out nocopy VARCHAR2
542: , x_msg_count out nocopy NUMBER
543: , x_msg_data out nocopy VARCHAR2
544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_NUMBER_TABLE
547: , p5_a3 JTF_NUMBER_TABLE
548: , p5_a4 JTF_VARCHAR2_TABLE_100
549: , p5_a5 JTF_VARCHAR2_TABLE_100
542: , x_msg_count out nocopy NUMBER
543: , x_msg_data out nocopy VARCHAR2
544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_NUMBER_TABLE
547: , p5_a3 JTF_NUMBER_TABLE
548: , p5_a4 JTF_VARCHAR2_TABLE_100
549: , p5_a5 JTF_VARCHAR2_TABLE_100
550: , p5_a6 JTF_NUMBER_TABLE
543: , x_msg_data out nocopy VARCHAR2
544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_NUMBER_TABLE
547: , p5_a3 JTF_NUMBER_TABLE
548: , p5_a4 JTF_VARCHAR2_TABLE_100
549: , p5_a5 JTF_VARCHAR2_TABLE_100
550: , p5_a6 JTF_NUMBER_TABLE
551: , p5_a7 JTF_VARCHAR2_TABLE_100
546: , p5_a2 JTF_NUMBER_TABLE
547: , p5_a3 JTF_NUMBER_TABLE
548: , p5_a4 JTF_VARCHAR2_TABLE_100
549: , p5_a5 JTF_VARCHAR2_TABLE_100
550: , p5_a6 JTF_NUMBER_TABLE
551: , p5_a7 JTF_VARCHAR2_TABLE_100
552: , p5_a8 JTF_NUMBER_TABLE
553: , p5_a9 JTF_NUMBER_TABLE
554: , p5_a10 JTF_DATE_TABLE
548: , p5_a4 JTF_VARCHAR2_TABLE_100
549: , p5_a5 JTF_VARCHAR2_TABLE_100
550: , p5_a6 JTF_NUMBER_TABLE
551: , p5_a7 JTF_VARCHAR2_TABLE_100
552: , p5_a8 JTF_NUMBER_TABLE
553: , p5_a9 JTF_NUMBER_TABLE
554: , p5_a10 JTF_DATE_TABLE
555: , p5_a11 JTF_NUMBER_TABLE
556: , p5_a12 JTF_DATE_TABLE
549: , p5_a5 JTF_VARCHAR2_TABLE_100
550: , p5_a6 JTF_NUMBER_TABLE
551: , p5_a7 JTF_VARCHAR2_TABLE_100
552: , p5_a8 JTF_NUMBER_TABLE
553: , p5_a9 JTF_NUMBER_TABLE
554: , p5_a10 JTF_DATE_TABLE
555: , p5_a11 JTF_NUMBER_TABLE
556: , p5_a12 JTF_DATE_TABLE
557: , p5_a13 JTF_DATE_TABLE
551: , p5_a7 JTF_VARCHAR2_TABLE_100
552: , p5_a8 JTF_NUMBER_TABLE
553: , p5_a9 JTF_NUMBER_TABLE
554: , p5_a10 JTF_DATE_TABLE
555: , p5_a11 JTF_NUMBER_TABLE
556: , p5_a12 JTF_DATE_TABLE
557: , p5_a13 JTF_DATE_TABLE
558: , p5_a14 JTF_DATE_TABLE
559: , p5_a15 JTF_DATE_TABLE
557: , p5_a13 JTF_DATE_TABLE
558: , p5_a14 JTF_DATE_TABLE
559: , p5_a15 JTF_DATE_TABLE
560: , p5_a16 JTF_VARCHAR2_TABLE_2000
561: , p5_a17 JTF_NUMBER_TABLE
562: , p5_a18 JTF_NUMBER_TABLE
563: , p5_a19 JTF_NUMBER_TABLE
564: , p5_a20 JTF_DATE_TABLE
565: , p5_a21 JTF_NUMBER_TABLE
558: , p5_a14 JTF_DATE_TABLE
559: , p5_a15 JTF_DATE_TABLE
560: , p5_a16 JTF_VARCHAR2_TABLE_2000
561: , p5_a17 JTF_NUMBER_TABLE
562: , p5_a18 JTF_NUMBER_TABLE
563: , p5_a19 JTF_NUMBER_TABLE
564: , p5_a20 JTF_DATE_TABLE
565: , p5_a21 JTF_NUMBER_TABLE
566: , p5_a22 JTF_VARCHAR2_TABLE_100
559: , p5_a15 JTF_DATE_TABLE
560: , p5_a16 JTF_VARCHAR2_TABLE_2000
561: , p5_a17 JTF_NUMBER_TABLE
562: , p5_a18 JTF_NUMBER_TABLE
563: , p5_a19 JTF_NUMBER_TABLE
564: , p5_a20 JTF_DATE_TABLE
565: , p5_a21 JTF_NUMBER_TABLE
566: , p5_a22 JTF_VARCHAR2_TABLE_100
567: , p5_a23 JTF_NUMBER_TABLE
561: , p5_a17 JTF_NUMBER_TABLE
562: , p5_a18 JTF_NUMBER_TABLE
563: , p5_a19 JTF_NUMBER_TABLE
564: , p5_a20 JTF_DATE_TABLE
565: , p5_a21 JTF_NUMBER_TABLE
566: , p5_a22 JTF_VARCHAR2_TABLE_100
567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_NUMBER_TABLE
569: , p5_a25 JTF_VARCHAR2_TABLE_100
563: , p5_a19 JTF_NUMBER_TABLE
564: , p5_a20 JTF_DATE_TABLE
565: , p5_a21 JTF_NUMBER_TABLE
566: , p5_a22 JTF_VARCHAR2_TABLE_100
567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_NUMBER_TABLE
569: , p5_a25 JTF_VARCHAR2_TABLE_100
570: , p5_a26 JTF_NUMBER_TABLE
571: , p5_a27 JTF_NUMBER_TABLE
564: , p5_a20 JTF_DATE_TABLE
565: , p5_a21 JTF_NUMBER_TABLE
566: , p5_a22 JTF_VARCHAR2_TABLE_100
567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_NUMBER_TABLE
569: , p5_a25 JTF_VARCHAR2_TABLE_100
570: , p5_a26 JTF_NUMBER_TABLE
571: , p5_a27 JTF_NUMBER_TABLE
572: );
566: , p5_a22 JTF_VARCHAR2_TABLE_100
567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_NUMBER_TABLE
569: , p5_a25 JTF_VARCHAR2_TABLE_100
570: , p5_a26 JTF_NUMBER_TABLE
571: , p5_a27 JTF_NUMBER_TABLE
572: );
573: end okl_stm_pvt_w;
567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_NUMBER_TABLE
569: , p5_a25 JTF_VARCHAR2_TABLE_100
570: , p5_a26 JTF_NUMBER_TABLE
571: , p5_a27 JTF_NUMBER_TABLE
572: );
573: end okl_stm_pvt_w;