1: package okl_aet_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIAETS.pls 120.2 2005/12/02 12:56:30 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_aet_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIAETS.pls 120.2 2005/12/02 12:56:30 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_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_NUMBER_TABLE
7: , a4 JTF_NUMBER_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_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_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_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_DATE_TABLE
26: , a4 out nocopy JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_DATE_TABLE
26: , a4 out nocopy JTF_NUMBER_TABLE
27: , a5 out nocopy JTF_VARCHAR2_TABLE_100
22: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_DATE_TABLE
26: , a4 out nocopy JTF_NUMBER_TABLE
27: , a5 out nocopy JTF_VARCHAR2_TABLE_100
28: , a6 out nocopy JTF_NUMBER_TABLE
29: , a7 out nocopy JTF_VARCHAR2_TABLE_100
30: , a8 out nocopy JTF_NUMBER_TABLE
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_DATE_TABLE
26: , a4 out nocopy JTF_NUMBER_TABLE
27: , a5 out nocopy JTF_VARCHAR2_TABLE_100
28: , a6 out nocopy JTF_NUMBER_TABLE
29: , a7 out nocopy JTF_VARCHAR2_TABLE_100
30: , a8 out nocopy JTF_NUMBER_TABLE
31: , a9 out nocopy JTF_NUMBER_TABLE
32: , a10 out nocopy JTF_NUMBER_TABLE
26: , a4 out nocopy JTF_NUMBER_TABLE
27: , a5 out nocopy JTF_VARCHAR2_TABLE_100
28: , a6 out nocopy JTF_NUMBER_TABLE
29: , a7 out nocopy JTF_VARCHAR2_TABLE_100
30: , a8 out nocopy JTF_NUMBER_TABLE
31: , a9 out nocopy JTF_NUMBER_TABLE
32: , a10 out nocopy JTF_NUMBER_TABLE
33: , a11 out nocopy JTF_DATE_TABLE
34: , a12 out nocopy JTF_NUMBER_TABLE
27: , a5 out nocopy JTF_VARCHAR2_TABLE_100
28: , a6 out nocopy JTF_NUMBER_TABLE
29: , a7 out nocopy JTF_VARCHAR2_TABLE_100
30: , a8 out nocopy JTF_NUMBER_TABLE
31: , a9 out nocopy JTF_NUMBER_TABLE
32: , a10 out nocopy JTF_NUMBER_TABLE
33: , a11 out nocopy JTF_DATE_TABLE
34: , a12 out nocopy JTF_NUMBER_TABLE
35: , a13 out nocopy JTF_NUMBER_TABLE
28: , a6 out nocopy JTF_NUMBER_TABLE
29: , a7 out nocopy JTF_VARCHAR2_TABLE_100
30: , a8 out nocopy JTF_NUMBER_TABLE
31: , a9 out nocopy JTF_NUMBER_TABLE
32: , a10 out nocopy JTF_NUMBER_TABLE
33: , a11 out nocopy JTF_DATE_TABLE
34: , a12 out nocopy JTF_NUMBER_TABLE
35: , a13 out nocopy JTF_NUMBER_TABLE
36: , a14 out nocopy JTF_DATE_TABLE
30: , a8 out nocopy JTF_NUMBER_TABLE
31: , a9 out nocopy JTF_NUMBER_TABLE
32: , a10 out nocopy JTF_NUMBER_TABLE
33: , a11 out nocopy JTF_DATE_TABLE
34: , a12 out nocopy JTF_NUMBER_TABLE
35: , a13 out nocopy JTF_NUMBER_TABLE
36: , a14 out nocopy JTF_DATE_TABLE
37: , a15 out nocopy JTF_NUMBER_TABLE
38: , a16 out nocopy JTF_DATE_TABLE
31: , a9 out nocopy JTF_NUMBER_TABLE
32: , a10 out nocopy JTF_NUMBER_TABLE
33: , a11 out nocopy JTF_DATE_TABLE
34: , a12 out nocopy JTF_NUMBER_TABLE
35: , a13 out nocopy JTF_NUMBER_TABLE
36: , a14 out nocopy JTF_DATE_TABLE
37: , a15 out nocopy JTF_NUMBER_TABLE
38: , a16 out nocopy JTF_DATE_TABLE
39: , a17 out nocopy JTF_NUMBER_TABLE
33: , a11 out nocopy JTF_DATE_TABLE
34: , a12 out nocopy JTF_NUMBER_TABLE
35: , a13 out nocopy JTF_NUMBER_TABLE
36: , a14 out nocopy JTF_DATE_TABLE
37: , a15 out nocopy JTF_NUMBER_TABLE
38: , a16 out nocopy JTF_DATE_TABLE
39: , a17 out nocopy JTF_NUMBER_TABLE
40: );
41:
35: , a13 out nocopy JTF_NUMBER_TABLE
36: , a14 out nocopy JTF_DATE_TABLE
37: , a15 out nocopy JTF_NUMBER_TABLE
38: , a16 out nocopy JTF_DATE_TABLE
39: , a17 out nocopy JTF_NUMBER_TABLE
40: );
41:
42: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_NUMBER_TABLE
38: , a16 out nocopy JTF_DATE_TABLE
39: , a17 out nocopy JTF_NUMBER_TABLE
40: );
41:
42: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_NUMBER_TABLE
44: , a2 JTF_NUMBER_TABLE
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_DATE_TABLE
39: , a17 out nocopy JTF_NUMBER_TABLE
40: );
41:
42: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_NUMBER_TABLE
44: , a2 JTF_NUMBER_TABLE
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_DATE_TABLE
47: , a5 JTF_NUMBER_TABLE
40: );
41:
42: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_NUMBER_TABLE
44: , a2 JTF_NUMBER_TABLE
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_DATE_TABLE
47: , a5 JTF_NUMBER_TABLE
48: , a6 JTF_VARCHAR2_TABLE_100
43: , a1 JTF_NUMBER_TABLE
44: , a2 JTF_NUMBER_TABLE
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_DATE_TABLE
47: , a5 JTF_NUMBER_TABLE
48: , a6 JTF_VARCHAR2_TABLE_100
49: , a7 JTF_NUMBER_TABLE
50: , a8 JTF_VARCHAR2_TABLE_100
51: , a9 JTF_NUMBER_TABLE
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_DATE_TABLE
47: , a5 JTF_NUMBER_TABLE
48: , a6 JTF_VARCHAR2_TABLE_100
49: , a7 JTF_NUMBER_TABLE
50: , a8 JTF_VARCHAR2_TABLE_100
51: , a9 JTF_NUMBER_TABLE
52: , a10 JTF_NUMBER_TABLE
53: , a11 JTF_DATE_TABLE
47: , a5 JTF_NUMBER_TABLE
48: , a6 JTF_VARCHAR2_TABLE_100
49: , a7 JTF_NUMBER_TABLE
50: , a8 JTF_VARCHAR2_TABLE_100
51: , a9 JTF_NUMBER_TABLE
52: , a10 JTF_NUMBER_TABLE
53: , a11 JTF_DATE_TABLE
54: , a12 JTF_NUMBER_TABLE
55: , a13 JTF_NUMBER_TABLE
48: , a6 JTF_VARCHAR2_TABLE_100
49: , a7 JTF_NUMBER_TABLE
50: , a8 JTF_VARCHAR2_TABLE_100
51: , a9 JTF_NUMBER_TABLE
52: , a10 JTF_NUMBER_TABLE
53: , a11 JTF_DATE_TABLE
54: , a12 JTF_NUMBER_TABLE
55: , a13 JTF_NUMBER_TABLE
56: , a14 JTF_DATE_TABLE
50: , a8 JTF_VARCHAR2_TABLE_100
51: , a9 JTF_NUMBER_TABLE
52: , a10 JTF_NUMBER_TABLE
53: , a11 JTF_DATE_TABLE
54: , a12 JTF_NUMBER_TABLE
55: , a13 JTF_NUMBER_TABLE
56: , a14 JTF_DATE_TABLE
57: , a15 JTF_NUMBER_TABLE
58: , a16 JTF_DATE_TABLE
51: , a9 JTF_NUMBER_TABLE
52: , a10 JTF_NUMBER_TABLE
53: , a11 JTF_DATE_TABLE
54: , a12 JTF_NUMBER_TABLE
55: , a13 JTF_NUMBER_TABLE
56: , a14 JTF_DATE_TABLE
57: , a15 JTF_NUMBER_TABLE
58: , a16 JTF_DATE_TABLE
59: , a17 JTF_NUMBER_TABLE
53: , a11 JTF_DATE_TABLE
54: , a12 JTF_NUMBER_TABLE
55: , a13 JTF_NUMBER_TABLE
56: , a14 JTF_DATE_TABLE
57: , a15 JTF_NUMBER_TABLE
58: , a16 JTF_DATE_TABLE
59: , a17 JTF_NUMBER_TABLE
60: );
61: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a13 JTF_NUMBER_TABLE
56: , a14 JTF_DATE_TABLE
57: , a15 JTF_NUMBER_TABLE
58: , a16 JTF_DATE_TABLE
59: , a17 JTF_NUMBER_TABLE
60: );
61: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
57: , a15 JTF_NUMBER_TABLE
58: , a16 JTF_DATE_TABLE
59: , a17 JTF_NUMBER_TABLE
60: );
61: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_DATE_TABLE
58: , a16 JTF_DATE_TABLE
59: , a17 JTF_NUMBER_TABLE
60: );
61: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_DATE_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
59: , a17 JTF_NUMBER_TABLE
60: );
61: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_DATE_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_DATE_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_DATE_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_DATE_TABLE
66: , a5 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_DATE_TABLE
73: , a12 out nocopy JTF_NUMBER_TABLE
74: , a13 out nocopy JTF_NUMBER_TABLE
67: , a6 out nocopy JTF_VARCHAR2_TABLE_100
68: , a7 out nocopy JTF_NUMBER_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_DATE_TABLE
73: , a12 out nocopy JTF_NUMBER_TABLE
74: , a13 out nocopy JTF_NUMBER_TABLE
75: , a14 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_VARCHAR2_TABLE_100
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_DATE_TABLE
73: , a12 out nocopy JTF_NUMBER_TABLE
74: , a13 out nocopy JTF_NUMBER_TABLE
75: , a14 out nocopy JTF_DATE_TABLE
76: , a15 out nocopy JTF_NUMBER_TABLE
77: , a16 out nocopy JTF_DATE_TABLE
70: , a9 out nocopy JTF_NUMBER_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_DATE_TABLE
73: , a12 out nocopy JTF_NUMBER_TABLE
74: , a13 out nocopy JTF_NUMBER_TABLE
75: , a14 out nocopy JTF_DATE_TABLE
76: , a15 out nocopy JTF_NUMBER_TABLE
77: , a16 out nocopy JTF_DATE_TABLE
78: , a17 out nocopy JTF_NUMBER_TABLE
72: , a11 out nocopy JTF_DATE_TABLE
73: , a12 out nocopy JTF_NUMBER_TABLE
74: , a13 out nocopy JTF_NUMBER_TABLE
75: , a14 out nocopy JTF_DATE_TABLE
76: , a15 out nocopy JTF_NUMBER_TABLE
77: , a16 out nocopy JTF_DATE_TABLE
78: , a17 out nocopy JTF_NUMBER_TABLE
79: );
80:
74: , a13 out nocopy JTF_NUMBER_TABLE
75: , a14 out nocopy JTF_DATE_TABLE
76: , a15 out nocopy JTF_NUMBER_TABLE
77: , a16 out nocopy JTF_DATE_TABLE
78: , a17 out nocopy JTF_NUMBER_TABLE
79: );
80:
81: procedure insert_row(p_api_version NUMBER
82: , p_init_msg_list VARCHAR2
124: , p_init_msg_list VARCHAR2
125: , x_return_status out nocopy VARCHAR2
126: , x_msg_count out nocopy NUMBER
127: , x_msg_data out nocopy VARCHAR2
128: , p5_a0 JTF_NUMBER_TABLE
129: , p5_a1 JTF_NUMBER_TABLE
130: , p5_a2 JTF_NUMBER_TABLE
131: , p5_a3 JTF_VARCHAR2_TABLE_100
132: , p5_a4 JTF_DATE_TABLE
125: , x_return_status out nocopy VARCHAR2
126: , x_msg_count out nocopy NUMBER
127: , x_msg_data out nocopy VARCHAR2
128: , p5_a0 JTF_NUMBER_TABLE
129: , p5_a1 JTF_NUMBER_TABLE
130: , p5_a2 JTF_NUMBER_TABLE
131: , p5_a3 JTF_VARCHAR2_TABLE_100
132: , p5_a4 JTF_DATE_TABLE
133: , p5_a5 JTF_NUMBER_TABLE
126: , x_msg_count out nocopy NUMBER
127: , x_msg_data out nocopy VARCHAR2
128: , p5_a0 JTF_NUMBER_TABLE
129: , p5_a1 JTF_NUMBER_TABLE
130: , p5_a2 JTF_NUMBER_TABLE
131: , p5_a3 JTF_VARCHAR2_TABLE_100
132: , p5_a4 JTF_DATE_TABLE
133: , p5_a5 JTF_NUMBER_TABLE
134: , p5_a6 JTF_VARCHAR2_TABLE_100
129: , p5_a1 JTF_NUMBER_TABLE
130: , p5_a2 JTF_NUMBER_TABLE
131: , p5_a3 JTF_VARCHAR2_TABLE_100
132: , p5_a4 JTF_DATE_TABLE
133: , p5_a5 JTF_NUMBER_TABLE
134: , p5_a6 JTF_VARCHAR2_TABLE_100
135: , p5_a7 JTF_NUMBER_TABLE
136: , p5_a8 JTF_VARCHAR2_TABLE_100
137: , p5_a9 JTF_NUMBER_TABLE
131: , p5_a3 JTF_VARCHAR2_TABLE_100
132: , p5_a4 JTF_DATE_TABLE
133: , p5_a5 JTF_NUMBER_TABLE
134: , p5_a6 JTF_VARCHAR2_TABLE_100
135: , p5_a7 JTF_NUMBER_TABLE
136: , p5_a8 JTF_VARCHAR2_TABLE_100
137: , p5_a9 JTF_NUMBER_TABLE
138: , p5_a10 JTF_NUMBER_TABLE
139: , p5_a11 JTF_DATE_TABLE
133: , p5_a5 JTF_NUMBER_TABLE
134: , p5_a6 JTF_VARCHAR2_TABLE_100
135: , p5_a7 JTF_NUMBER_TABLE
136: , p5_a8 JTF_VARCHAR2_TABLE_100
137: , p5_a9 JTF_NUMBER_TABLE
138: , p5_a10 JTF_NUMBER_TABLE
139: , p5_a11 JTF_DATE_TABLE
140: , p5_a12 JTF_NUMBER_TABLE
141: , p5_a13 JTF_NUMBER_TABLE
134: , p5_a6 JTF_VARCHAR2_TABLE_100
135: , p5_a7 JTF_NUMBER_TABLE
136: , p5_a8 JTF_VARCHAR2_TABLE_100
137: , p5_a9 JTF_NUMBER_TABLE
138: , p5_a10 JTF_NUMBER_TABLE
139: , p5_a11 JTF_DATE_TABLE
140: , p5_a12 JTF_NUMBER_TABLE
141: , p5_a13 JTF_NUMBER_TABLE
142: , p5_a14 JTF_DATE_TABLE
136: , p5_a8 JTF_VARCHAR2_TABLE_100
137: , p5_a9 JTF_NUMBER_TABLE
138: , p5_a10 JTF_NUMBER_TABLE
139: , p5_a11 JTF_DATE_TABLE
140: , p5_a12 JTF_NUMBER_TABLE
141: , p5_a13 JTF_NUMBER_TABLE
142: , p5_a14 JTF_DATE_TABLE
143: , p5_a15 JTF_NUMBER_TABLE
144: , p5_a16 JTF_DATE_TABLE
137: , p5_a9 JTF_NUMBER_TABLE
138: , p5_a10 JTF_NUMBER_TABLE
139: , p5_a11 JTF_DATE_TABLE
140: , p5_a12 JTF_NUMBER_TABLE
141: , p5_a13 JTF_NUMBER_TABLE
142: , p5_a14 JTF_DATE_TABLE
143: , p5_a15 JTF_NUMBER_TABLE
144: , p5_a16 JTF_DATE_TABLE
145: , p5_a17 JTF_NUMBER_TABLE
139: , p5_a11 JTF_DATE_TABLE
140: , p5_a12 JTF_NUMBER_TABLE
141: , p5_a13 JTF_NUMBER_TABLE
142: , p5_a14 JTF_DATE_TABLE
143: , p5_a15 JTF_NUMBER_TABLE
144: , p5_a16 JTF_DATE_TABLE
145: , p5_a17 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
141: , p5_a13 JTF_NUMBER_TABLE
142: , p5_a14 JTF_DATE_TABLE
143: , p5_a15 JTF_NUMBER_TABLE
144: , p5_a16 JTF_DATE_TABLE
145: , p5_a17 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
142: , p5_a14 JTF_DATE_TABLE
143: , p5_a15 JTF_NUMBER_TABLE
144: , p5_a16 JTF_DATE_TABLE
145: , p5_a17 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , p6_a4 out nocopy JTF_DATE_TABLE
143: , p5_a15 JTF_NUMBER_TABLE
144: , p5_a16 JTF_DATE_TABLE
145: , p5_a17 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , p6_a4 out nocopy JTF_DATE_TABLE
151: , p6_a5 out nocopy JTF_NUMBER_TABLE
144: , p5_a16 JTF_DATE_TABLE
145: , p5_a17 JTF_NUMBER_TABLE
146: , p6_a0 out nocopy JTF_NUMBER_TABLE
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , p6_a4 out nocopy JTF_DATE_TABLE
151: , p6_a5 out nocopy JTF_NUMBER_TABLE
152: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
147: , p6_a1 out nocopy JTF_NUMBER_TABLE
148: , p6_a2 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , p6_a4 out nocopy JTF_DATE_TABLE
151: , p6_a5 out nocopy JTF_NUMBER_TABLE
152: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a7 out nocopy JTF_NUMBER_TABLE
154: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , p6_a9 out nocopy JTF_NUMBER_TABLE
149: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , p6_a4 out nocopy JTF_DATE_TABLE
151: , p6_a5 out nocopy JTF_NUMBER_TABLE
152: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a7 out nocopy JTF_NUMBER_TABLE
154: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , p6_a9 out nocopy JTF_NUMBER_TABLE
156: , p6_a10 out nocopy JTF_NUMBER_TABLE
157: , p6_a11 out nocopy JTF_DATE_TABLE
151: , p6_a5 out nocopy JTF_NUMBER_TABLE
152: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a7 out nocopy JTF_NUMBER_TABLE
154: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , p6_a9 out nocopy JTF_NUMBER_TABLE
156: , p6_a10 out nocopy JTF_NUMBER_TABLE
157: , p6_a11 out nocopy JTF_DATE_TABLE
158: , p6_a12 out nocopy JTF_NUMBER_TABLE
159: , p6_a13 out nocopy JTF_NUMBER_TABLE
152: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a7 out nocopy JTF_NUMBER_TABLE
154: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , p6_a9 out nocopy JTF_NUMBER_TABLE
156: , p6_a10 out nocopy JTF_NUMBER_TABLE
157: , p6_a11 out nocopy JTF_DATE_TABLE
158: , p6_a12 out nocopy JTF_NUMBER_TABLE
159: , p6_a13 out nocopy JTF_NUMBER_TABLE
160: , p6_a14 out nocopy JTF_DATE_TABLE
154: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
155: , p6_a9 out nocopy JTF_NUMBER_TABLE
156: , p6_a10 out nocopy JTF_NUMBER_TABLE
157: , p6_a11 out nocopy JTF_DATE_TABLE
158: , p6_a12 out nocopy JTF_NUMBER_TABLE
159: , p6_a13 out nocopy JTF_NUMBER_TABLE
160: , p6_a14 out nocopy JTF_DATE_TABLE
161: , p6_a15 out nocopy JTF_NUMBER_TABLE
162: , p6_a16 out nocopy JTF_DATE_TABLE
155: , p6_a9 out nocopy JTF_NUMBER_TABLE
156: , p6_a10 out nocopy JTF_NUMBER_TABLE
157: , p6_a11 out nocopy JTF_DATE_TABLE
158: , p6_a12 out nocopy JTF_NUMBER_TABLE
159: , p6_a13 out nocopy JTF_NUMBER_TABLE
160: , p6_a14 out nocopy JTF_DATE_TABLE
161: , p6_a15 out nocopy JTF_NUMBER_TABLE
162: , p6_a16 out nocopy JTF_DATE_TABLE
163: , p6_a17 out nocopy JTF_NUMBER_TABLE
157: , p6_a11 out nocopy JTF_DATE_TABLE
158: , p6_a12 out nocopy JTF_NUMBER_TABLE
159: , p6_a13 out nocopy JTF_NUMBER_TABLE
160: , p6_a14 out nocopy JTF_DATE_TABLE
161: , p6_a15 out nocopy JTF_NUMBER_TABLE
162: , p6_a16 out nocopy JTF_DATE_TABLE
163: , p6_a17 out nocopy JTF_NUMBER_TABLE
164: );
165: procedure lock_row(p_api_version NUMBER
159: , p6_a13 out nocopy JTF_NUMBER_TABLE
160: , p6_a14 out nocopy JTF_DATE_TABLE
161: , p6_a15 out nocopy JTF_NUMBER_TABLE
162: , p6_a16 out nocopy JTF_DATE_TABLE
163: , p6_a17 out nocopy JTF_NUMBER_TABLE
164: );
165: procedure lock_row(p_api_version NUMBER
166: , p_init_msg_list VARCHAR2
167: , x_return_status out nocopy VARCHAR2
190: , p_init_msg_list VARCHAR2
191: , x_return_status out nocopy VARCHAR2
192: , x_msg_count out nocopy NUMBER
193: , x_msg_data out nocopy VARCHAR2
194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
191: , x_return_status out nocopy VARCHAR2
192: , x_msg_count out nocopy NUMBER
193: , x_msg_data out nocopy VARCHAR2
194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_NUMBER_TABLE
192: , x_msg_count out nocopy NUMBER
193: , x_msg_data out nocopy VARCHAR2
194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
195: , p5_a1 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
201: , p5_a7 JTF_NUMBER_TABLE
202: , p5_a8 JTF_VARCHAR2_TABLE_100
203: , p5_a9 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
201: , p5_a7 JTF_NUMBER_TABLE
202: , p5_a8 JTF_VARCHAR2_TABLE_100
203: , p5_a9 JTF_NUMBER_TABLE
204: , p5_a10 JTF_NUMBER_TABLE
205: , p5_a11 JTF_DATE_TABLE
199: , p5_a5 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
201: , p5_a7 JTF_NUMBER_TABLE
202: , p5_a8 JTF_VARCHAR2_TABLE_100
203: , p5_a9 JTF_NUMBER_TABLE
204: , p5_a10 JTF_NUMBER_TABLE
205: , p5_a11 JTF_DATE_TABLE
206: , p5_a12 JTF_NUMBER_TABLE
207: , p5_a13 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
201: , p5_a7 JTF_NUMBER_TABLE
202: , p5_a8 JTF_VARCHAR2_TABLE_100
203: , p5_a9 JTF_NUMBER_TABLE
204: , p5_a10 JTF_NUMBER_TABLE
205: , p5_a11 JTF_DATE_TABLE
206: , p5_a12 JTF_NUMBER_TABLE
207: , p5_a13 JTF_NUMBER_TABLE
208: , p5_a14 JTF_DATE_TABLE
202: , p5_a8 JTF_VARCHAR2_TABLE_100
203: , p5_a9 JTF_NUMBER_TABLE
204: , p5_a10 JTF_NUMBER_TABLE
205: , p5_a11 JTF_DATE_TABLE
206: , p5_a12 JTF_NUMBER_TABLE
207: , p5_a13 JTF_NUMBER_TABLE
208: , p5_a14 JTF_DATE_TABLE
209: , p5_a15 JTF_NUMBER_TABLE
210: , p5_a16 JTF_DATE_TABLE
203: , p5_a9 JTF_NUMBER_TABLE
204: , p5_a10 JTF_NUMBER_TABLE
205: , p5_a11 JTF_DATE_TABLE
206: , p5_a12 JTF_NUMBER_TABLE
207: , p5_a13 JTF_NUMBER_TABLE
208: , p5_a14 JTF_DATE_TABLE
209: , p5_a15 JTF_NUMBER_TABLE
210: , p5_a16 JTF_DATE_TABLE
211: , p5_a17 JTF_NUMBER_TABLE
205: , p5_a11 JTF_DATE_TABLE
206: , p5_a12 JTF_NUMBER_TABLE
207: , p5_a13 JTF_NUMBER_TABLE
208: , p5_a14 JTF_DATE_TABLE
209: , p5_a15 JTF_NUMBER_TABLE
210: , p5_a16 JTF_DATE_TABLE
211: , p5_a17 JTF_NUMBER_TABLE
212: );
213: procedure update_row(p_api_version NUMBER
207: , p5_a13 JTF_NUMBER_TABLE
208: , p5_a14 JTF_DATE_TABLE
209: , p5_a15 JTF_NUMBER_TABLE
210: , p5_a16 JTF_DATE_TABLE
211: , p5_a17 JTF_NUMBER_TABLE
212: );
213: procedure update_row(p_api_version NUMBER
214: , p_init_msg_list VARCHAR2
215: , x_return_status out nocopy VARCHAR2
256: , p_init_msg_list VARCHAR2
257: , x_return_status out nocopy VARCHAR2
258: , x_msg_count out nocopy NUMBER
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_NUMBER_TABLE
263: , p5_a3 JTF_VARCHAR2_TABLE_100
264: , p5_a4 JTF_DATE_TABLE
257: , x_return_status out nocopy VARCHAR2
258: , x_msg_count out nocopy NUMBER
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_NUMBER_TABLE
263: , p5_a3 JTF_VARCHAR2_TABLE_100
264: , p5_a4 JTF_DATE_TABLE
265: , p5_a5 JTF_NUMBER_TABLE
258: , x_msg_count out nocopy NUMBER
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_NUMBER_TABLE
263: , p5_a3 JTF_VARCHAR2_TABLE_100
264: , p5_a4 JTF_DATE_TABLE
265: , p5_a5 JTF_NUMBER_TABLE
266: , p5_a6 JTF_VARCHAR2_TABLE_100
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_NUMBER_TABLE
263: , p5_a3 JTF_VARCHAR2_TABLE_100
264: , p5_a4 JTF_DATE_TABLE
265: , p5_a5 JTF_NUMBER_TABLE
266: , p5_a6 JTF_VARCHAR2_TABLE_100
267: , p5_a7 JTF_NUMBER_TABLE
268: , p5_a8 JTF_VARCHAR2_TABLE_100
269: , p5_a9 JTF_NUMBER_TABLE
263: , p5_a3 JTF_VARCHAR2_TABLE_100
264: , p5_a4 JTF_DATE_TABLE
265: , p5_a5 JTF_NUMBER_TABLE
266: , p5_a6 JTF_VARCHAR2_TABLE_100
267: , p5_a7 JTF_NUMBER_TABLE
268: , p5_a8 JTF_VARCHAR2_TABLE_100
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_NUMBER_TABLE
271: , p5_a11 JTF_DATE_TABLE
265: , p5_a5 JTF_NUMBER_TABLE
266: , p5_a6 JTF_VARCHAR2_TABLE_100
267: , p5_a7 JTF_NUMBER_TABLE
268: , p5_a8 JTF_VARCHAR2_TABLE_100
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_NUMBER_TABLE
271: , p5_a11 JTF_DATE_TABLE
272: , p5_a12 JTF_NUMBER_TABLE
273: , p5_a13 JTF_NUMBER_TABLE
266: , p5_a6 JTF_VARCHAR2_TABLE_100
267: , p5_a7 JTF_NUMBER_TABLE
268: , p5_a8 JTF_VARCHAR2_TABLE_100
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_NUMBER_TABLE
271: , p5_a11 JTF_DATE_TABLE
272: , p5_a12 JTF_NUMBER_TABLE
273: , p5_a13 JTF_NUMBER_TABLE
274: , p5_a14 JTF_DATE_TABLE
268: , p5_a8 JTF_VARCHAR2_TABLE_100
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_NUMBER_TABLE
271: , p5_a11 JTF_DATE_TABLE
272: , p5_a12 JTF_NUMBER_TABLE
273: , p5_a13 JTF_NUMBER_TABLE
274: , p5_a14 JTF_DATE_TABLE
275: , p5_a15 JTF_NUMBER_TABLE
276: , p5_a16 JTF_DATE_TABLE
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_NUMBER_TABLE
271: , p5_a11 JTF_DATE_TABLE
272: , p5_a12 JTF_NUMBER_TABLE
273: , p5_a13 JTF_NUMBER_TABLE
274: , p5_a14 JTF_DATE_TABLE
275: , p5_a15 JTF_NUMBER_TABLE
276: , p5_a16 JTF_DATE_TABLE
277: , p5_a17 JTF_NUMBER_TABLE
271: , p5_a11 JTF_DATE_TABLE
272: , p5_a12 JTF_NUMBER_TABLE
273: , p5_a13 JTF_NUMBER_TABLE
274: , p5_a14 JTF_DATE_TABLE
275: , p5_a15 JTF_NUMBER_TABLE
276: , p5_a16 JTF_DATE_TABLE
277: , p5_a17 JTF_NUMBER_TABLE
278: , p6_a0 out nocopy JTF_NUMBER_TABLE
279: , p6_a1 out nocopy JTF_NUMBER_TABLE
273: , p5_a13 JTF_NUMBER_TABLE
274: , p5_a14 JTF_DATE_TABLE
275: , p5_a15 JTF_NUMBER_TABLE
276: , p5_a16 JTF_DATE_TABLE
277: , p5_a17 JTF_NUMBER_TABLE
278: , p6_a0 out nocopy JTF_NUMBER_TABLE
279: , p6_a1 out nocopy JTF_NUMBER_TABLE
280: , p6_a2 out nocopy JTF_NUMBER_TABLE
281: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a14 JTF_DATE_TABLE
275: , p5_a15 JTF_NUMBER_TABLE
276: , p5_a16 JTF_DATE_TABLE
277: , p5_a17 JTF_NUMBER_TABLE
278: , p6_a0 out nocopy JTF_NUMBER_TABLE
279: , p6_a1 out nocopy JTF_NUMBER_TABLE
280: , p6_a2 out nocopy JTF_NUMBER_TABLE
281: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a4 out nocopy JTF_DATE_TABLE
275: , p5_a15 JTF_NUMBER_TABLE
276: , p5_a16 JTF_DATE_TABLE
277: , p5_a17 JTF_NUMBER_TABLE
278: , p6_a0 out nocopy JTF_NUMBER_TABLE
279: , p6_a1 out nocopy JTF_NUMBER_TABLE
280: , p6_a2 out nocopy JTF_NUMBER_TABLE
281: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a4 out nocopy JTF_DATE_TABLE
283: , p6_a5 out nocopy JTF_NUMBER_TABLE
276: , p5_a16 JTF_DATE_TABLE
277: , p5_a17 JTF_NUMBER_TABLE
278: , p6_a0 out nocopy JTF_NUMBER_TABLE
279: , p6_a1 out nocopy JTF_NUMBER_TABLE
280: , p6_a2 out nocopy JTF_NUMBER_TABLE
281: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a4 out nocopy JTF_DATE_TABLE
283: , p6_a5 out nocopy JTF_NUMBER_TABLE
284: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
279: , p6_a1 out nocopy JTF_NUMBER_TABLE
280: , p6_a2 out nocopy JTF_NUMBER_TABLE
281: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a4 out nocopy JTF_DATE_TABLE
283: , p6_a5 out nocopy JTF_NUMBER_TABLE
284: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a7 out nocopy JTF_NUMBER_TABLE
286: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a9 out nocopy JTF_NUMBER_TABLE
281: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a4 out nocopy JTF_DATE_TABLE
283: , p6_a5 out nocopy JTF_NUMBER_TABLE
284: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a7 out nocopy JTF_NUMBER_TABLE
286: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a9 out nocopy JTF_NUMBER_TABLE
288: , p6_a10 out nocopy JTF_NUMBER_TABLE
289: , p6_a11 out nocopy JTF_DATE_TABLE
283: , p6_a5 out nocopy JTF_NUMBER_TABLE
284: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a7 out nocopy JTF_NUMBER_TABLE
286: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a9 out nocopy JTF_NUMBER_TABLE
288: , p6_a10 out nocopy JTF_NUMBER_TABLE
289: , p6_a11 out nocopy JTF_DATE_TABLE
290: , p6_a12 out nocopy JTF_NUMBER_TABLE
291: , p6_a13 out nocopy JTF_NUMBER_TABLE
284: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a7 out nocopy JTF_NUMBER_TABLE
286: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a9 out nocopy JTF_NUMBER_TABLE
288: , p6_a10 out nocopy JTF_NUMBER_TABLE
289: , p6_a11 out nocopy JTF_DATE_TABLE
290: , p6_a12 out nocopy JTF_NUMBER_TABLE
291: , p6_a13 out nocopy JTF_NUMBER_TABLE
292: , p6_a14 out nocopy JTF_DATE_TABLE
286: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a9 out nocopy JTF_NUMBER_TABLE
288: , p6_a10 out nocopy JTF_NUMBER_TABLE
289: , p6_a11 out nocopy JTF_DATE_TABLE
290: , p6_a12 out nocopy JTF_NUMBER_TABLE
291: , p6_a13 out nocopy JTF_NUMBER_TABLE
292: , p6_a14 out nocopy JTF_DATE_TABLE
293: , p6_a15 out nocopy JTF_NUMBER_TABLE
294: , p6_a16 out nocopy JTF_DATE_TABLE
287: , p6_a9 out nocopy JTF_NUMBER_TABLE
288: , p6_a10 out nocopy JTF_NUMBER_TABLE
289: , p6_a11 out nocopy JTF_DATE_TABLE
290: , p6_a12 out nocopy JTF_NUMBER_TABLE
291: , p6_a13 out nocopy JTF_NUMBER_TABLE
292: , p6_a14 out nocopy JTF_DATE_TABLE
293: , p6_a15 out nocopy JTF_NUMBER_TABLE
294: , p6_a16 out nocopy JTF_DATE_TABLE
295: , p6_a17 out nocopy JTF_NUMBER_TABLE
289: , p6_a11 out nocopy JTF_DATE_TABLE
290: , p6_a12 out nocopy JTF_NUMBER_TABLE
291: , p6_a13 out nocopy JTF_NUMBER_TABLE
292: , p6_a14 out nocopy JTF_DATE_TABLE
293: , p6_a15 out nocopy JTF_NUMBER_TABLE
294: , p6_a16 out nocopy JTF_DATE_TABLE
295: , p6_a17 out nocopy JTF_NUMBER_TABLE
296: );
297: procedure delete_row(p_api_version NUMBER
291: , p6_a13 out nocopy JTF_NUMBER_TABLE
292: , p6_a14 out nocopy JTF_DATE_TABLE
293: , p6_a15 out nocopy JTF_NUMBER_TABLE
294: , p6_a16 out nocopy JTF_DATE_TABLE
295: , p6_a17 out nocopy JTF_NUMBER_TABLE
296: );
297: procedure delete_row(p_api_version NUMBER
298: , p_init_msg_list VARCHAR2
299: , x_return_status out nocopy VARCHAR2
322: , p_init_msg_list VARCHAR2
323: , x_return_status out nocopy VARCHAR2
324: , x_msg_count out nocopy NUMBER
325: , x_msg_data out nocopy VARCHAR2
326: , p5_a0 JTF_NUMBER_TABLE
327: , p5_a1 JTF_NUMBER_TABLE
328: , p5_a2 JTF_NUMBER_TABLE
329: , p5_a3 JTF_VARCHAR2_TABLE_100
330: , p5_a4 JTF_DATE_TABLE
323: , x_return_status out nocopy VARCHAR2
324: , x_msg_count out nocopy NUMBER
325: , x_msg_data out nocopy VARCHAR2
326: , p5_a0 JTF_NUMBER_TABLE
327: , p5_a1 JTF_NUMBER_TABLE
328: , p5_a2 JTF_NUMBER_TABLE
329: , p5_a3 JTF_VARCHAR2_TABLE_100
330: , p5_a4 JTF_DATE_TABLE
331: , p5_a5 JTF_NUMBER_TABLE
324: , x_msg_count out nocopy NUMBER
325: , x_msg_data out nocopy VARCHAR2
326: , p5_a0 JTF_NUMBER_TABLE
327: , p5_a1 JTF_NUMBER_TABLE
328: , p5_a2 JTF_NUMBER_TABLE
329: , p5_a3 JTF_VARCHAR2_TABLE_100
330: , p5_a4 JTF_DATE_TABLE
331: , p5_a5 JTF_NUMBER_TABLE
332: , p5_a6 JTF_VARCHAR2_TABLE_100
327: , p5_a1 JTF_NUMBER_TABLE
328: , p5_a2 JTF_NUMBER_TABLE
329: , p5_a3 JTF_VARCHAR2_TABLE_100
330: , p5_a4 JTF_DATE_TABLE
331: , p5_a5 JTF_NUMBER_TABLE
332: , p5_a6 JTF_VARCHAR2_TABLE_100
333: , p5_a7 JTF_NUMBER_TABLE
334: , p5_a8 JTF_VARCHAR2_TABLE_100
335: , p5_a9 JTF_NUMBER_TABLE
329: , p5_a3 JTF_VARCHAR2_TABLE_100
330: , p5_a4 JTF_DATE_TABLE
331: , p5_a5 JTF_NUMBER_TABLE
332: , p5_a6 JTF_VARCHAR2_TABLE_100
333: , p5_a7 JTF_NUMBER_TABLE
334: , p5_a8 JTF_VARCHAR2_TABLE_100
335: , p5_a9 JTF_NUMBER_TABLE
336: , p5_a10 JTF_NUMBER_TABLE
337: , p5_a11 JTF_DATE_TABLE
331: , p5_a5 JTF_NUMBER_TABLE
332: , p5_a6 JTF_VARCHAR2_TABLE_100
333: , p5_a7 JTF_NUMBER_TABLE
334: , p5_a8 JTF_VARCHAR2_TABLE_100
335: , p5_a9 JTF_NUMBER_TABLE
336: , p5_a10 JTF_NUMBER_TABLE
337: , p5_a11 JTF_DATE_TABLE
338: , p5_a12 JTF_NUMBER_TABLE
339: , p5_a13 JTF_NUMBER_TABLE
332: , p5_a6 JTF_VARCHAR2_TABLE_100
333: , p5_a7 JTF_NUMBER_TABLE
334: , p5_a8 JTF_VARCHAR2_TABLE_100
335: , p5_a9 JTF_NUMBER_TABLE
336: , p5_a10 JTF_NUMBER_TABLE
337: , p5_a11 JTF_DATE_TABLE
338: , p5_a12 JTF_NUMBER_TABLE
339: , p5_a13 JTF_NUMBER_TABLE
340: , p5_a14 JTF_DATE_TABLE
334: , p5_a8 JTF_VARCHAR2_TABLE_100
335: , p5_a9 JTF_NUMBER_TABLE
336: , p5_a10 JTF_NUMBER_TABLE
337: , p5_a11 JTF_DATE_TABLE
338: , p5_a12 JTF_NUMBER_TABLE
339: , p5_a13 JTF_NUMBER_TABLE
340: , p5_a14 JTF_DATE_TABLE
341: , p5_a15 JTF_NUMBER_TABLE
342: , p5_a16 JTF_DATE_TABLE
335: , p5_a9 JTF_NUMBER_TABLE
336: , p5_a10 JTF_NUMBER_TABLE
337: , p5_a11 JTF_DATE_TABLE
338: , p5_a12 JTF_NUMBER_TABLE
339: , p5_a13 JTF_NUMBER_TABLE
340: , p5_a14 JTF_DATE_TABLE
341: , p5_a15 JTF_NUMBER_TABLE
342: , p5_a16 JTF_DATE_TABLE
343: , p5_a17 JTF_NUMBER_TABLE
337: , p5_a11 JTF_DATE_TABLE
338: , p5_a12 JTF_NUMBER_TABLE
339: , p5_a13 JTF_NUMBER_TABLE
340: , p5_a14 JTF_DATE_TABLE
341: , p5_a15 JTF_NUMBER_TABLE
342: , p5_a16 JTF_DATE_TABLE
343: , p5_a17 JTF_NUMBER_TABLE
344: );
345: procedure validate_row(p_api_version NUMBER
339: , p5_a13 JTF_NUMBER_TABLE
340: , p5_a14 JTF_DATE_TABLE
341: , p5_a15 JTF_NUMBER_TABLE
342: , p5_a16 JTF_DATE_TABLE
343: , p5_a17 JTF_NUMBER_TABLE
344: );
345: procedure validate_row(p_api_version NUMBER
346: , p_init_msg_list VARCHAR2
347: , x_return_status out nocopy VARCHAR2
370: , p_init_msg_list VARCHAR2
371: , x_return_status out nocopy VARCHAR2
372: , x_msg_count out nocopy NUMBER
373: , x_msg_data out nocopy VARCHAR2
374: , p5_a0 JTF_NUMBER_TABLE
375: , p5_a1 JTF_NUMBER_TABLE
376: , p5_a2 JTF_NUMBER_TABLE
377: , p5_a3 JTF_VARCHAR2_TABLE_100
378: , p5_a4 JTF_DATE_TABLE
371: , x_return_status out nocopy VARCHAR2
372: , x_msg_count out nocopy NUMBER
373: , x_msg_data out nocopy VARCHAR2
374: , p5_a0 JTF_NUMBER_TABLE
375: , p5_a1 JTF_NUMBER_TABLE
376: , p5_a2 JTF_NUMBER_TABLE
377: , p5_a3 JTF_VARCHAR2_TABLE_100
378: , p5_a4 JTF_DATE_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
372: , x_msg_count out nocopy NUMBER
373: , x_msg_data out nocopy VARCHAR2
374: , p5_a0 JTF_NUMBER_TABLE
375: , p5_a1 JTF_NUMBER_TABLE
376: , p5_a2 JTF_NUMBER_TABLE
377: , p5_a3 JTF_VARCHAR2_TABLE_100
378: , p5_a4 JTF_DATE_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
380: , p5_a6 JTF_VARCHAR2_TABLE_100
375: , p5_a1 JTF_NUMBER_TABLE
376: , p5_a2 JTF_NUMBER_TABLE
377: , p5_a3 JTF_VARCHAR2_TABLE_100
378: , p5_a4 JTF_DATE_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
380: , p5_a6 JTF_VARCHAR2_TABLE_100
381: , p5_a7 JTF_NUMBER_TABLE
382: , p5_a8 JTF_VARCHAR2_TABLE_100
383: , p5_a9 JTF_NUMBER_TABLE
377: , p5_a3 JTF_VARCHAR2_TABLE_100
378: , p5_a4 JTF_DATE_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
380: , p5_a6 JTF_VARCHAR2_TABLE_100
381: , p5_a7 JTF_NUMBER_TABLE
382: , p5_a8 JTF_VARCHAR2_TABLE_100
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_NUMBER_TABLE
385: , p5_a11 JTF_DATE_TABLE
379: , p5_a5 JTF_NUMBER_TABLE
380: , p5_a6 JTF_VARCHAR2_TABLE_100
381: , p5_a7 JTF_NUMBER_TABLE
382: , p5_a8 JTF_VARCHAR2_TABLE_100
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_NUMBER_TABLE
385: , p5_a11 JTF_DATE_TABLE
386: , p5_a12 JTF_NUMBER_TABLE
387: , p5_a13 JTF_NUMBER_TABLE
380: , p5_a6 JTF_VARCHAR2_TABLE_100
381: , p5_a7 JTF_NUMBER_TABLE
382: , p5_a8 JTF_VARCHAR2_TABLE_100
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_NUMBER_TABLE
385: , p5_a11 JTF_DATE_TABLE
386: , p5_a12 JTF_NUMBER_TABLE
387: , p5_a13 JTF_NUMBER_TABLE
388: , p5_a14 JTF_DATE_TABLE
382: , p5_a8 JTF_VARCHAR2_TABLE_100
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_NUMBER_TABLE
385: , p5_a11 JTF_DATE_TABLE
386: , p5_a12 JTF_NUMBER_TABLE
387: , p5_a13 JTF_NUMBER_TABLE
388: , p5_a14 JTF_DATE_TABLE
389: , p5_a15 JTF_NUMBER_TABLE
390: , p5_a16 JTF_DATE_TABLE
383: , p5_a9 JTF_NUMBER_TABLE
384: , p5_a10 JTF_NUMBER_TABLE
385: , p5_a11 JTF_DATE_TABLE
386: , p5_a12 JTF_NUMBER_TABLE
387: , p5_a13 JTF_NUMBER_TABLE
388: , p5_a14 JTF_DATE_TABLE
389: , p5_a15 JTF_NUMBER_TABLE
390: , p5_a16 JTF_DATE_TABLE
391: , p5_a17 JTF_NUMBER_TABLE
385: , p5_a11 JTF_DATE_TABLE
386: , p5_a12 JTF_NUMBER_TABLE
387: , p5_a13 JTF_NUMBER_TABLE
388: , p5_a14 JTF_DATE_TABLE
389: , p5_a15 JTF_NUMBER_TABLE
390: , p5_a16 JTF_DATE_TABLE
391: , p5_a17 JTF_NUMBER_TABLE
392: );
393: end okl_aet_pvt_w;
387: , p5_a13 JTF_NUMBER_TABLE
388: , p5_a14 JTF_DATE_TABLE
389: , p5_a15 JTF_NUMBER_TABLE
390: , p5_a16 JTF_DATE_TABLE
391: , p5_a17 JTF_NUMBER_TABLE
392: );
393: end okl_aet_pvt_w;