1: package okl_ovt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIOVTS.pls 115.3 2002/12/24 04:07:12 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovt_pvt.ovt_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 okl_ovt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIOVTS.pls 115.3 2002/12/24 04:07:12 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovt_pvt.ovt_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 okl_ovt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIOVTS.pls 115.3 2002/12/24 04:07:12 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovt_pvt.ovt_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_DATE_TABLE
2: /* $Header: OKLIOVTS.pls 115.3 2002/12/24 04:07:12 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovt_pvt.ovt_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_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovt_pvt.ovt_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_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_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_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_ovt_pvt.ovt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_ovt_pvt.ovt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_ovt_pvt.ovt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_ovt_pvt.ovt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_ovt_pvt.ovt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_ovt_pvt.ovt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
14: procedure rosetta_table_copy_out_p2(t okl_ovt_pvt.ovt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_DATE_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_DATE_TABLE
23: , a9 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_DATE_TABLE
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_DATE_TABLE
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:
26: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovt_pvt.ovtv_tbl_type, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_DATE_TABLE
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:
26: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovt_pvt.ovtv_tbl_type, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:
26: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovt_pvt.ovtv_tbl_type, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
24: );
25:
26: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovt_pvt.ovtv_tbl_type, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_DATE_TABLE
25:
26: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovt_pvt.ovtv_tbl_type, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_DATE_TABLE
33: , a7 JTF_NUMBER_TABLE
26: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovt_pvt.ovtv_tbl_type, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_DATE_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_DATE_TABLE
27: , a1 JTF_NUMBER_TABLE
28: , a2 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_DATE_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_DATE_TABLE
35: , a9 JTF_NUMBER_TABLE
29: , a3 JTF_NUMBER_TABLE
30: , a4 JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_DATE_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_DATE_TABLE
35: , a9 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p5(t okl_ovt_pvt.ovtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_DATE_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_DATE_TABLE
35: , a9 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p5(t okl_ovt_pvt.ovtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_NUMBER_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_DATE_TABLE
35: , a9 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p5(t okl_ovt_pvt.ovtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_NUMBER_TABLE
34: , a8 JTF_DATE_TABLE
35: , a9 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p5(t okl_ovt_pvt.ovtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_NUMBER_TABLE
42: , a5 out nocopy JTF_NUMBER_TABLE
35: , a9 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p5(t okl_ovt_pvt.ovtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_NUMBER_TABLE
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_DATE_TABLE
36: );
37: procedure rosetta_table_copy_out_p5(t okl_ovt_pvt.ovtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_NUMBER_TABLE
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_DATE_TABLE
44: , a7 out nocopy JTF_NUMBER_TABLE
37: procedure rosetta_table_copy_out_p5(t okl_ovt_pvt.ovtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_NUMBER_TABLE
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_DATE_TABLE
44: , a7 out nocopy JTF_NUMBER_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_NUMBER_TABLE
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_DATE_TABLE
44: , a7 out nocopy JTF_NUMBER_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_NUMBER_TABLE
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_DATE_TABLE
44: , a7 out nocopy JTF_NUMBER_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_NUMBER_TABLE
47: );
48:
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_DATE_TABLE
44: , a7 out nocopy JTF_NUMBER_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_NUMBER_TABLE
47: );
48:
49: procedure insert_row(p_api_version NUMBER
50: , p_init_msg_list VARCHAR2
76: , p_init_msg_list VARCHAR2
77: , x_return_status out nocopy VARCHAR2
78: , x_msg_count out nocopy NUMBER
79: , x_msg_data out nocopy VARCHAR2
80: , p5_a0 JTF_NUMBER_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
77: , x_return_status out nocopy VARCHAR2
78: , x_msg_count out nocopy NUMBER
79: , x_msg_data out nocopy VARCHAR2
80: , p5_a0 JTF_NUMBER_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
78: , x_msg_count out nocopy NUMBER
79: , x_msg_data out nocopy VARCHAR2
80: , p5_a0 JTF_NUMBER_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_DATE_TABLE
79: , x_msg_data out nocopy VARCHAR2
80: , p5_a0 JTF_NUMBER_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_DATE_TABLE
87: , p5_a7 JTF_NUMBER_TABLE
80: , p5_a0 JTF_NUMBER_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_DATE_TABLE
87: , p5_a7 JTF_NUMBER_TABLE
88: , p5_a8 JTF_DATE_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_DATE_TABLE
87: , p5_a7 JTF_NUMBER_TABLE
88: , p5_a8 JTF_DATE_TABLE
89: , p5_a9 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_DATE_TABLE
87: , p5_a7 JTF_NUMBER_TABLE
88: , p5_a8 JTF_DATE_TABLE
89: , p5_a9 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_DATE_TABLE
87: , p5_a7 JTF_NUMBER_TABLE
88: , p5_a8 JTF_DATE_TABLE
89: , p5_a9 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_NUMBER_TABLE
86: , p5_a6 JTF_DATE_TABLE
87: , p5_a7 JTF_NUMBER_TABLE
88: , p5_a8 JTF_DATE_TABLE
89: , p5_a9 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_NUMBER_TABLE
94: , p6_a4 out nocopy JTF_NUMBER_TABLE
87: , p5_a7 JTF_NUMBER_TABLE
88: , p5_a8 JTF_DATE_TABLE
89: , p5_a9 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_NUMBER_TABLE
94: , p6_a4 out nocopy JTF_NUMBER_TABLE
95: , p6_a5 out nocopy JTF_NUMBER_TABLE
88: , p5_a8 JTF_DATE_TABLE
89: , p5_a9 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_NUMBER_TABLE
94: , p6_a4 out nocopy JTF_NUMBER_TABLE
95: , p6_a5 out nocopy JTF_NUMBER_TABLE
96: , p6_a6 out nocopy JTF_DATE_TABLE
89: , p5_a9 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_NUMBER_TABLE
94: , p6_a4 out nocopy JTF_NUMBER_TABLE
95: , p6_a5 out nocopy JTF_NUMBER_TABLE
96: , p6_a6 out nocopy JTF_DATE_TABLE
97: , p6_a7 out nocopy JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_NUMBER_TABLE
94: , p6_a4 out nocopy JTF_NUMBER_TABLE
95: , p6_a5 out nocopy JTF_NUMBER_TABLE
96: , p6_a6 out nocopy JTF_DATE_TABLE
97: , p6_a7 out nocopy JTF_NUMBER_TABLE
98: , p6_a8 out nocopy JTF_DATE_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_NUMBER_TABLE
94: , p6_a4 out nocopy JTF_NUMBER_TABLE
95: , p6_a5 out nocopy JTF_NUMBER_TABLE
96: , p6_a6 out nocopy JTF_DATE_TABLE
97: , p6_a7 out nocopy JTF_NUMBER_TABLE
98: , p6_a8 out nocopy JTF_DATE_TABLE
99: , p6_a9 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_NUMBER_TABLE
94: , p6_a4 out nocopy JTF_NUMBER_TABLE
95: , p6_a5 out nocopy JTF_NUMBER_TABLE
96: , p6_a6 out nocopy JTF_DATE_TABLE
97: , p6_a7 out nocopy JTF_NUMBER_TABLE
98: , p6_a8 out nocopy JTF_DATE_TABLE
99: , p6_a9 out nocopy JTF_NUMBER_TABLE
100: );
101: procedure lock_row(p_api_version NUMBER
95: , p6_a5 out nocopy JTF_NUMBER_TABLE
96: , p6_a6 out nocopy JTF_DATE_TABLE
97: , p6_a7 out nocopy JTF_NUMBER_TABLE
98: , p6_a8 out nocopy JTF_DATE_TABLE
99: , p6_a9 out nocopy JTF_NUMBER_TABLE
100: );
101: procedure lock_row(p_api_version NUMBER
102: , p_init_msg_list VARCHAR2
103: , x_return_status out nocopy VARCHAR2
118: , p_init_msg_list VARCHAR2
119: , x_return_status out nocopy VARCHAR2
120: , x_msg_count out nocopy NUMBER
121: , x_msg_data out nocopy VARCHAR2
122: , p5_a0 JTF_NUMBER_TABLE
123: , p5_a1 JTF_NUMBER_TABLE
124: , p5_a2 JTF_NUMBER_TABLE
125: , p5_a3 JTF_NUMBER_TABLE
126: , p5_a4 JTF_NUMBER_TABLE
119: , x_return_status out nocopy VARCHAR2
120: , x_msg_count out nocopy NUMBER
121: , x_msg_data out nocopy VARCHAR2
122: , p5_a0 JTF_NUMBER_TABLE
123: , p5_a1 JTF_NUMBER_TABLE
124: , p5_a2 JTF_NUMBER_TABLE
125: , p5_a3 JTF_NUMBER_TABLE
126: , p5_a4 JTF_NUMBER_TABLE
127: , p5_a5 JTF_NUMBER_TABLE
120: , x_msg_count out nocopy NUMBER
121: , x_msg_data out nocopy VARCHAR2
122: , p5_a0 JTF_NUMBER_TABLE
123: , p5_a1 JTF_NUMBER_TABLE
124: , p5_a2 JTF_NUMBER_TABLE
125: , p5_a3 JTF_NUMBER_TABLE
126: , p5_a4 JTF_NUMBER_TABLE
127: , p5_a5 JTF_NUMBER_TABLE
128: , p5_a6 JTF_DATE_TABLE
121: , x_msg_data out nocopy VARCHAR2
122: , p5_a0 JTF_NUMBER_TABLE
123: , p5_a1 JTF_NUMBER_TABLE
124: , p5_a2 JTF_NUMBER_TABLE
125: , p5_a3 JTF_NUMBER_TABLE
126: , p5_a4 JTF_NUMBER_TABLE
127: , p5_a5 JTF_NUMBER_TABLE
128: , p5_a6 JTF_DATE_TABLE
129: , p5_a7 JTF_NUMBER_TABLE
122: , p5_a0 JTF_NUMBER_TABLE
123: , p5_a1 JTF_NUMBER_TABLE
124: , p5_a2 JTF_NUMBER_TABLE
125: , p5_a3 JTF_NUMBER_TABLE
126: , p5_a4 JTF_NUMBER_TABLE
127: , p5_a5 JTF_NUMBER_TABLE
128: , p5_a6 JTF_DATE_TABLE
129: , p5_a7 JTF_NUMBER_TABLE
130: , p5_a8 JTF_DATE_TABLE
123: , p5_a1 JTF_NUMBER_TABLE
124: , p5_a2 JTF_NUMBER_TABLE
125: , p5_a3 JTF_NUMBER_TABLE
126: , p5_a4 JTF_NUMBER_TABLE
127: , p5_a5 JTF_NUMBER_TABLE
128: , p5_a6 JTF_DATE_TABLE
129: , p5_a7 JTF_NUMBER_TABLE
130: , p5_a8 JTF_DATE_TABLE
131: , p5_a9 JTF_NUMBER_TABLE
125: , p5_a3 JTF_NUMBER_TABLE
126: , p5_a4 JTF_NUMBER_TABLE
127: , p5_a5 JTF_NUMBER_TABLE
128: , p5_a6 JTF_DATE_TABLE
129: , p5_a7 JTF_NUMBER_TABLE
130: , p5_a8 JTF_DATE_TABLE
131: , p5_a9 JTF_NUMBER_TABLE
132: );
133: procedure update_row(p_api_version NUMBER
127: , p5_a5 JTF_NUMBER_TABLE
128: , p5_a6 JTF_DATE_TABLE
129: , p5_a7 JTF_NUMBER_TABLE
130: , p5_a8 JTF_DATE_TABLE
131: , p5_a9 JTF_NUMBER_TABLE
132: );
133: procedure update_row(p_api_version NUMBER
134: , p_init_msg_list VARCHAR2
135: , x_return_status out nocopy VARCHAR2
160: , p_init_msg_list VARCHAR2
161: , x_return_status out nocopy VARCHAR2
162: , x_msg_count out nocopy NUMBER
163: , x_msg_data out nocopy VARCHAR2
164: , p5_a0 JTF_NUMBER_TABLE
165: , p5_a1 JTF_NUMBER_TABLE
166: , p5_a2 JTF_NUMBER_TABLE
167: , p5_a3 JTF_NUMBER_TABLE
168: , p5_a4 JTF_NUMBER_TABLE
161: , x_return_status out nocopy VARCHAR2
162: , x_msg_count out nocopy NUMBER
163: , x_msg_data out nocopy VARCHAR2
164: , p5_a0 JTF_NUMBER_TABLE
165: , p5_a1 JTF_NUMBER_TABLE
166: , p5_a2 JTF_NUMBER_TABLE
167: , p5_a3 JTF_NUMBER_TABLE
168: , p5_a4 JTF_NUMBER_TABLE
169: , p5_a5 JTF_NUMBER_TABLE
162: , x_msg_count out nocopy NUMBER
163: , x_msg_data out nocopy VARCHAR2
164: , p5_a0 JTF_NUMBER_TABLE
165: , p5_a1 JTF_NUMBER_TABLE
166: , p5_a2 JTF_NUMBER_TABLE
167: , p5_a3 JTF_NUMBER_TABLE
168: , p5_a4 JTF_NUMBER_TABLE
169: , p5_a5 JTF_NUMBER_TABLE
170: , p5_a6 JTF_DATE_TABLE
163: , x_msg_data out nocopy VARCHAR2
164: , p5_a0 JTF_NUMBER_TABLE
165: , p5_a1 JTF_NUMBER_TABLE
166: , p5_a2 JTF_NUMBER_TABLE
167: , p5_a3 JTF_NUMBER_TABLE
168: , p5_a4 JTF_NUMBER_TABLE
169: , p5_a5 JTF_NUMBER_TABLE
170: , p5_a6 JTF_DATE_TABLE
171: , p5_a7 JTF_NUMBER_TABLE
164: , p5_a0 JTF_NUMBER_TABLE
165: , p5_a1 JTF_NUMBER_TABLE
166: , p5_a2 JTF_NUMBER_TABLE
167: , p5_a3 JTF_NUMBER_TABLE
168: , p5_a4 JTF_NUMBER_TABLE
169: , p5_a5 JTF_NUMBER_TABLE
170: , p5_a6 JTF_DATE_TABLE
171: , p5_a7 JTF_NUMBER_TABLE
172: , p5_a8 JTF_DATE_TABLE
165: , p5_a1 JTF_NUMBER_TABLE
166: , p5_a2 JTF_NUMBER_TABLE
167: , p5_a3 JTF_NUMBER_TABLE
168: , p5_a4 JTF_NUMBER_TABLE
169: , p5_a5 JTF_NUMBER_TABLE
170: , p5_a6 JTF_DATE_TABLE
171: , p5_a7 JTF_NUMBER_TABLE
172: , p5_a8 JTF_DATE_TABLE
173: , p5_a9 JTF_NUMBER_TABLE
167: , p5_a3 JTF_NUMBER_TABLE
168: , p5_a4 JTF_NUMBER_TABLE
169: , p5_a5 JTF_NUMBER_TABLE
170: , p5_a6 JTF_DATE_TABLE
171: , p5_a7 JTF_NUMBER_TABLE
172: , p5_a8 JTF_DATE_TABLE
173: , p5_a9 JTF_NUMBER_TABLE
174: , p6_a0 out nocopy JTF_NUMBER_TABLE
175: , p6_a1 out nocopy JTF_NUMBER_TABLE
169: , p5_a5 JTF_NUMBER_TABLE
170: , p5_a6 JTF_DATE_TABLE
171: , p5_a7 JTF_NUMBER_TABLE
172: , p5_a8 JTF_DATE_TABLE
173: , p5_a9 JTF_NUMBER_TABLE
174: , p6_a0 out nocopy JTF_NUMBER_TABLE
175: , p6_a1 out nocopy JTF_NUMBER_TABLE
176: , p6_a2 out nocopy JTF_NUMBER_TABLE
177: , p6_a3 out nocopy JTF_NUMBER_TABLE
170: , p5_a6 JTF_DATE_TABLE
171: , p5_a7 JTF_NUMBER_TABLE
172: , p5_a8 JTF_DATE_TABLE
173: , p5_a9 JTF_NUMBER_TABLE
174: , p6_a0 out nocopy JTF_NUMBER_TABLE
175: , p6_a1 out nocopy JTF_NUMBER_TABLE
176: , p6_a2 out nocopy JTF_NUMBER_TABLE
177: , p6_a3 out nocopy JTF_NUMBER_TABLE
178: , p6_a4 out nocopy JTF_NUMBER_TABLE
171: , p5_a7 JTF_NUMBER_TABLE
172: , p5_a8 JTF_DATE_TABLE
173: , p5_a9 JTF_NUMBER_TABLE
174: , p6_a0 out nocopy JTF_NUMBER_TABLE
175: , p6_a1 out nocopy JTF_NUMBER_TABLE
176: , p6_a2 out nocopy JTF_NUMBER_TABLE
177: , p6_a3 out nocopy JTF_NUMBER_TABLE
178: , p6_a4 out nocopy JTF_NUMBER_TABLE
179: , p6_a5 out nocopy JTF_NUMBER_TABLE
172: , p5_a8 JTF_DATE_TABLE
173: , p5_a9 JTF_NUMBER_TABLE
174: , p6_a0 out nocopy JTF_NUMBER_TABLE
175: , p6_a1 out nocopy JTF_NUMBER_TABLE
176: , p6_a2 out nocopy JTF_NUMBER_TABLE
177: , p6_a3 out nocopy JTF_NUMBER_TABLE
178: , p6_a4 out nocopy JTF_NUMBER_TABLE
179: , p6_a5 out nocopy JTF_NUMBER_TABLE
180: , p6_a6 out nocopy JTF_DATE_TABLE
173: , p5_a9 JTF_NUMBER_TABLE
174: , p6_a0 out nocopy JTF_NUMBER_TABLE
175: , p6_a1 out nocopy JTF_NUMBER_TABLE
176: , p6_a2 out nocopy JTF_NUMBER_TABLE
177: , p6_a3 out nocopy JTF_NUMBER_TABLE
178: , p6_a4 out nocopy JTF_NUMBER_TABLE
179: , p6_a5 out nocopy JTF_NUMBER_TABLE
180: , p6_a6 out nocopy JTF_DATE_TABLE
181: , p6_a7 out nocopy JTF_NUMBER_TABLE
174: , p6_a0 out nocopy JTF_NUMBER_TABLE
175: , p6_a1 out nocopy JTF_NUMBER_TABLE
176: , p6_a2 out nocopy JTF_NUMBER_TABLE
177: , p6_a3 out nocopy JTF_NUMBER_TABLE
178: , p6_a4 out nocopy JTF_NUMBER_TABLE
179: , p6_a5 out nocopy JTF_NUMBER_TABLE
180: , p6_a6 out nocopy JTF_DATE_TABLE
181: , p6_a7 out nocopy JTF_NUMBER_TABLE
182: , p6_a8 out nocopy JTF_DATE_TABLE
175: , p6_a1 out nocopy JTF_NUMBER_TABLE
176: , p6_a2 out nocopy JTF_NUMBER_TABLE
177: , p6_a3 out nocopy JTF_NUMBER_TABLE
178: , p6_a4 out nocopy JTF_NUMBER_TABLE
179: , p6_a5 out nocopy JTF_NUMBER_TABLE
180: , p6_a6 out nocopy JTF_DATE_TABLE
181: , p6_a7 out nocopy JTF_NUMBER_TABLE
182: , p6_a8 out nocopy JTF_DATE_TABLE
183: , p6_a9 out nocopy JTF_NUMBER_TABLE
177: , p6_a3 out nocopy JTF_NUMBER_TABLE
178: , p6_a4 out nocopy JTF_NUMBER_TABLE
179: , p6_a5 out nocopy JTF_NUMBER_TABLE
180: , p6_a6 out nocopy JTF_DATE_TABLE
181: , p6_a7 out nocopy JTF_NUMBER_TABLE
182: , p6_a8 out nocopy JTF_DATE_TABLE
183: , p6_a9 out nocopy JTF_NUMBER_TABLE
184: );
185: procedure delete_row(p_api_version NUMBER
179: , p6_a5 out nocopy JTF_NUMBER_TABLE
180: , p6_a6 out nocopy JTF_DATE_TABLE
181: , p6_a7 out nocopy JTF_NUMBER_TABLE
182: , p6_a8 out nocopy JTF_DATE_TABLE
183: , p6_a9 out nocopy JTF_NUMBER_TABLE
184: );
185: procedure delete_row(p_api_version NUMBER
186: , p_init_msg_list VARCHAR2
187: , x_return_status out nocopy VARCHAR2
202: , p_init_msg_list VARCHAR2
203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_NUMBER_TABLE
210: , p5_a4 JTF_NUMBER_TABLE
203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_NUMBER_TABLE
210: , p5_a4 JTF_NUMBER_TABLE
211: , p5_a5 JTF_NUMBER_TABLE
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_NUMBER_TABLE
210: , p5_a4 JTF_NUMBER_TABLE
211: , p5_a5 JTF_NUMBER_TABLE
212: , p5_a6 JTF_DATE_TABLE
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_NUMBER_TABLE
210: , p5_a4 JTF_NUMBER_TABLE
211: , p5_a5 JTF_NUMBER_TABLE
212: , p5_a6 JTF_DATE_TABLE
213: , p5_a7 JTF_NUMBER_TABLE
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_NUMBER_TABLE
210: , p5_a4 JTF_NUMBER_TABLE
211: , p5_a5 JTF_NUMBER_TABLE
212: , p5_a6 JTF_DATE_TABLE
213: , p5_a7 JTF_NUMBER_TABLE
214: , p5_a8 JTF_DATE_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_NUMBER_TABLE
210: , p5_a4 JTF_NUMBER_TABLE
211: , p5_a5 JTF_NUMBER_TABLE
212: , p5_a6 JTF_DATE_TABLE
213: , p5_a7 JTF_NUMBER_TABLE
214: , p5_a8 JTF_DATE_TABLE
215: , p5_a9 JTF_NUMBER_TABLE
209: , p5_a3 JTF_NUMBER_TABLE
210: , p5_a4 JTF_NUMBER_TABLE
211: , p5_a5 JTF_NUMBER_TABLE
212: , p5_a6 JTF_DATE_TABLE
213: , p5_a7 JTF_NUMBER_TABLE
214: , p5_a8 JTF_DATE_TABLE
215: , p5_a9 JTF_NUMBER_TABLE
216: );
217: procedure validate_row(p_api_version NUMBER
211: , p5_a5 JTF_NUMBER_TABLE
212: , p5_a6 JTF_DATE_TABLE
213: , p5_a7 JTF_NUMBER_TABLE
214: , p5_a8 JTF_DATE_TABLE
215: , p5_a9 JTF_NUMBER_TABLE
216: );
217: procedure validate_row(p_api_version NUMBER
218: , p_init_msg_list VARCHAR2
219: , x_return_status out nocopy VARCHAR2
234: , p_init_msg_list VARCHAR2
235: , x_return_status out nocopy VARCHAR2
236: , x_msg_count out nocopy NUMBER
237: , x_msg_data out nocopy VARCHAR2
238: , p5_a0 JTF_NUMBER_TABLE
239: , p5_a1 JTF_NUMBER_TABLE
240: , p5_a2 JTF_NUMBER_TABLE
241: , p5_a3 JTF_NUMBER_TABLE
242: , p5_a4 JTF_NUMBER_TABLE
235: , x_return_status out nocopy VARCHAR2
236: , x_msg_count out nocopy NUMBER
237: , x_msg_data out nocopy VARCHAR2
238: , p5_a0 JTF_NUMBER_TABLE
239: , p5_a1 JTF_NUMBER_TABLE
240: , p5_a2 JTF_NUMBER_TABLE
241: , p5_a3 JTF_NUMBER_TABLE
242: , p5_a4 JTF_NUMBER_TABLE
243: , p5_a5 JTF_NUMBER_TABLE
236: , x_msg_count out nocopy NUMBER
237: , x_msg_data out nocopy VARCHAR2
238: , p5_a0 JTF_NUMBER_TABLE
239: , p5_a1 JTF_NUMBER_TABLE
240: , p5_a2 JTF_NUMBER_TABLE
241: , p5_a3 JTF_NUMBER_TABLE
242: , p5_a4 JTF_NUMBER_TABLE
243: , p5_a5 JTF_NUMBER_TABLE
244: , p5_a6 JTF_DATE_TABLE
237: , x_msg_data out nocopy VARCHAR2
238: , p5_a0 JTF_NUMBER_TABLE
239: , p5_a1 JTF_NUMBER_TABLE
240: , p5_a2 JTF_NUMBER_TABLE
241: , p5_a3 JTF_NUMBER_TABLE
242: , p5_a4 JTF_NUMBER_TABLE
243: , p5_a5 JTF_NUMBER_TABLE
244: , p5_a6 JTF_DATE_TABLE
245: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a0 JTF_NUMBER_TABLE
239: , p5_a1 JTF_NUMBER_TABLE
240: , p5_a2 JTF_NUMBER_TABLE
241: , p5_a3 JTF_NUMBER_TABLE
242: , p5_a4 JTF_NUMBER_TABLE
243: , p5_a5 JTF_NUMBER_TABLE
244: , p5_a6 JTF_DATE_TABLE
245: , p5_a7 JTF_NUMBER_TABLE
246: , p5_a8 JTF_DATE_TABLE
239: , p5_a1 JTF_NUMBER_TABLE
240: , p5_a2 JTF_NUMBER_TABLE
241: , p5_a3 JTF_NUMBER_TABLE
242: , p5_a4 JTF_NUMBER_TABLE
243: , p5_a5 JTF_NUMBER_TABLE
244: , p5_a6 JTF_DATE_TABLE
245: , p5_a7 JTF_NUMBER_TABLE
246: , p5_a8 JTF_DATE_TABLE
247: , p5_a9 JTF_NUMBER_TABLE
241: , p5_a3 JTF_NUMBER_TABLE
242: , p5_a4 JTF_NUMBER_TABLE
243: , p5_a5 JTF_NUMBER_TABLE
244: , p5_a6 JTF_DATE_TABLE
245: , p5_a7 JTF_NUMBER_TABLE
246: , p5_a8 JTF_DATE_TABLE
247: , p5_a9 JTF_NUMBER_TABLE
248: );
249: end okl_ovt_pvt_w;
243: , p5_a5 JTF_NUMBER_TABLE
244: , p5_a6 JTF_DATE_TABLE
245: , p5_a7 JTF_NUMBER_TABLE
246: , p5_a8 JTF_DATE_TABLE
247: , p5_a9 JTF_NUMBER_TABLE
248: );
249: end okl_ovt_pvt_w;