1: package okl_rap_pvt_w as
2: /* $Header: OKLIRAPS.pls 120.0 2007/12/10 18:29:28 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rap_pvt.rap_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_rap_pvt_w as
2: /* $Header: OKLIRAPS.pls 120.0 2007/12/10 18:29:28 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rap_pvt.rap_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
2: /* $Header: OKLIRAPS.pls 120.0 2007/12/10 18:29:28 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rap_pvt.rap_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
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_rap_pvt.rap_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
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_rap_pvt.rap_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_rap_pvt.rap_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
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_rap_pvt.rap_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
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_rap_pvt.rap_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_rap_pvt.rap_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
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_rap_pvt.rap_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
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 insert_row(p_api_version NUMBER
27: , p_init_msg_list VARCHAR2
53: , p_init_msg_list VARCHAR2
54: , x_return_status out nocopy VARCHAR2
55: , x_msg_count out nocopy NUMBER
56: , x_msg_data out nocopy VARCHAR2
57: , p5_a0 JTF_NUMBER_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_VARCHAR2_TABLE_100
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_NUMBER_TABLE
54: , x_return_status out nocopy VARCHAR2
55: , x_msg_count out nocopy NUMBER
56: , x_msg_data out nocopy VARCHAR2
57: , p5_a0 JTF_NUMBER_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_VARCHAR2_TABLE_100
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_NUMBER_TABLE
62: , p5_a5 JTF_NUMBER_TABLE
56: , x_msg_data out nocopy VARCHAR2
57: , p5_a0 JTF_NUMBER_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_VARCHAR2_TABLE_100
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_NUMBER_TABLE
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
57: , p5_a0 JTF_NUMBER_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_VARCHAR2_TABLE_100
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_NUMBER_TABLE
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_VARCHAR2_TABLE_100
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_NUMBER_TABLE
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_NUMBER_TABLE
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_NUMBER_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_NUMBER_TABLE
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_NUMBER_TABLE
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_NUMBER_TABLE
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE
75: , p6_a8 out nocopy JTF_DATE_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_NUMBER_TABLE
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE
75: , p6_a8 out nocopy JTF_DATE_TABLE
76: , p6_a9 out nocopy JTF_NUMBER_TABLE
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_NUMBER_TABLE
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE
75: , p6_a8 out nocopy JTF_DATE_TABLE
76: , p6_a9 out nocopy JTF_NUMBER_TABLE
77: , p7_a0 in out nocopy JTF_NUMBER_TABLE
78: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE
75: , p6_a8 out nocopy JTF_DATE_TABLE
76: , p6_a9 out nocopy JTF_NUMBER_TABLE
77: , p7_a0 in out nocopy JTF_NUMBER_TABLE
78: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
79: , p7_a2 in out nocopy JTF_NUMBER_TABLE
80: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE
75: , p6_a8 out nocopy JTF_DATE_TABLE
76: , p6_a9 out nocopy JTF_NUMBER_TABLE
77: , p7_a0 in out nocopy JTF_NUMBER_TABLE
78: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
79: , p7_a2 in out nocopy JTF_NUMBER_TABLE
80: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
81: , p7_a4 in out nocopy JTF_NUMBER_TABLE
75: , p6_a8 out nocopy JTF_DATE_TABLE
76: , p6_a9 out nocopy JTF_NUMBER_TABLE
77: , p7_a0 in out nocopy JTF_NUMBER_TABLE
78: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
79: , p7_a2 in out nocopy JTF_NUMBER_TABLE
80: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
81: , p7_a4 in out nocopy JTF_NUMBER_TABLE
82: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
83: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
77: , p7_a0 in out nocopy JTF_NUMBER_TABLE
78: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
79: , p7_a2 in out nocopy JTF_NUMBER_TABLE
80: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
81: , p7_a4 in out nocopy JTF_NUMBER_TABLE
82: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
83: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
84: );
85: procedure insert_row(p_api_version NUMBER
86: , p_init_msg_list VARCHAR2
87: , x_return_status out nocopy VARCHAR2
88: , x_msg_count out nocopy NUMBER
89: , x_msg_data out nocopy VARCHAR2
90: , p5_a0 JTF_NUMBER_TABLE
91: , p5_a1 JTF_NUMBER_TABLE
92: , p5_a2 JTF_VARCHAR2_TABLE_100
93: , p5_a3 JTF_NUMBER_TABLE
94: , p5_a4 JTF_NUMBER_TABLE
87: , x_return_status out nocopy VARCHAR2
88: , x_msg_count out nocopy NUMBER
89: , x_msg_data out nocopy VARCHAR2
90: , p5_a0 JTF_NUMBER_TABLE
91: , p5_a1 JTF_NUMBER_TABLE
92: , p5_a2 JTF_VARCHAR2_TABLE_100
93: , p5_a3 JTF_NUMBER_TABLE
94: , p5_a4 JTF_NUMBER_TABLE
95: , p5_a5 JTF_NUMBER_TABLE
89: , x_msg_data out nocopy VARCHAR2
90: , p5_a0 JTF_NUMBER_TABLE
91: , p5_a1 JTF_NUMBER_TABLE
92: , p5_a2 JTF_VARCHAR2_TABLE_100
93: , p5_a3 JTF_NUMBER_TABLE
94: , p5_a4 JTF_NUMBER_TABLE
95: , p5_a5 JTF_NUMBER_TABLE
96: , p5_a6 JTF_DATE_TABLE
97: , p5_a7 JTF_NUMBER_TABLE
90: , p5_a0 JTF_NUMBER_TABLE
91: , p5_a1 JTF_NUMBER_TABLE
92: , p5_a2 JTF_VARCHAR2_TABLE_100
93: , p5_a3 JTF_NUMBER_TABLE
94: , p5_a4 JTF_NUMBER_TABLE
95: , p5_a5 JTF_NUMBER_TABLE
96: , p5_a6 JTF_DATE_TABLE
97: , p5_a7 JTF_NUMBER_TABLE
98: , p5_a8 JTF_DATE_TABLE
91: , p5_a1 JTF_NUMBER_TABLE
92: , p5_a2 JTF_VARCHAR2_TABLE_100
93: , p5_a3 JTF_NUMBER_TABLE
94: , p5_a4 JTF_NUMBER_TABLE
95: , p5_a5 JTF_NUMBER_TABLE
96: , p5_a6 JTF_DATE_TABLE
97: , p5_a7 JTF_NUMBER_TABLE
98: , p5_a8 JTF_DATE_TABLE
99: , p5_a9 JTF_NUMBER_TABLE
93: , p5_a3 JTF_NUMBER_TABLE
94: , p5_a4 JTF_NUMBER_TABLE
95: , p5_a5 JTF_NUMBER_TABLE
96: , p5_a6 JTF_DATE_TABLE
97: , p5_a7 JTF_NUMBER_TABLE
98: , p5_a8 JTF_DATE_TABLE
99: , p5_a9 JTF_NUMBER_TABLE
100: , p6_a0 out nocopy JTF_NUMBER_TABLE
101: , p6_a1 out nocopy JTF_NUMBER_TABLE
95: , p5_a5 JTF_NUMBER_TABLE
96: , p5_a6 JTF_DATE_TABLE
97: , p5_a7 JTF_NUMBER_TABLE
98: , p5_a8 JTF_DATE_TABLE
99: , p5_a9 JTF_NUMBER_TABLE
100: , p6_a0 out nocopy JTF_NUMBER_TABLE
101: , p6_a1 out nocopy JTF_NUMBER_TABLE
102: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a3 out nocopy JTF_NUMBER_TABLE
96: , p5_a6 JTF_DATE_TABLE
97: , p5_a7 JTF_NUMBER_TABLE
98: , p5_a8 JTF_DATE_TABLE
99: , p5_a9 JTF_NUMBER_TABLE
100: , p6_a0 out nocopy JTF_NUMBER_TABLE
101: , p6_a1 out nocopy JTF_NUMBER_TABLE
102: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a3 out nocopy JTF_NUMBER_TABLE
104: , p6_a4 out nocopy JTF_NUMBER_TABLE
97: , p5_a7 JTF_NUMBER_TABLE
98: , p5_a8 JTF_DATE_TABLE
99: , p5_a9 JTF_NUMBER_TABLE
100: , p6_a0 out nocopy JTF_NUMBER_TABLE
101: , p6_a1 out nocopy JTF_NUMBER_TABLE
102: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a3 out nocopy JTF_NUMBER_TABLE
104: , p6_a4 out nocopy JTF_NUMBER_TABLE
105: , p6_a5 out nocopy JTF_NUMBER_TABLE
99: , p5_a9 JTF_NUMBER_TABLE
100: , p6_a0 out nocopy JTF_NUMBER_TABLE
101: , p6_a1 out nocopy JTF_NUMBER_TABLE
102: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a3 out nocopy JTF_NUMBER_TABLE
104: , p6_a4 out nocopy JTF_NUMBER_TABLE
105: , p6_a5 out nocopy JTF_NUMBER_TABLE
106: , p6_a6 out nocopy JTF_DATE_TABLE
107: , p6_a7 out nocopy JTF_NUMBER_TABLE
100: , p6_a0 out nocopy JTF_NUMBER_TABLE
101: , p6_a1 out nocopy JTF_NUMBER_TABLE
102: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a3 out nocopy JTF_NUMBER_TABLE
104: , p6_a4 out nocopy JTF_NUMBER_TABLE
105: , p6_a5 out nocopy JTF_NUMBER_TABLE
106: , p6_a6 out nocopy JTF_DATE_TABLE
107: , p6_a7 out nocopy JTF_NUMBER_TABLE
108: , p6_a8 out nocopy JTF_DATE_TABLE
101: , p6_a1 out nocopy JTF_NUMBER_TABLE
102: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a3 out nocopy JTF_NUMBER_TABLE
104: , p6_a4 out nocopy JTF_NUMBER_TABLE
105: , p6_a5 out nocopy JTF_NUMBER_TABLE
106: , p6_a6 out nocopy JTF_DATE_TABLE
107: , p6_a7 out nocopy JTF_NUMBER_TABLE
108: , p6_a8 out nocopy JTF_DATE_TABLE
109: , p6_a9 out nocopy JTF_NUMBER_TABLE
103: , p6_a3 out nocopy JTF_NUMBER_TABLE
104: , p6_a4 out nocopy JTF_NUMBER_TABLE
105: , p6_a5 out nocopy JTF_NUMBER_TABLE
106: , p6_a6 out nocopy JTF_DATE_TABLE
107: , p6_a7 out nocopy JTF_NUMBER_TABLE
108: , p6_a8 out nocopy JTF_DATE_TABLE
109: , p6_a9 out nocopy JTF_NUMBER_TABLE
110: );
111: procedure lock_row(p_api_version NUMBER
105: , p6_a5 out nocopy JTF_NUMBER_TABLE
106: , p6_a6 out nocopy JTF_DATE_TABLE
107: , p6_a7 out nocopy JTF_NUMBER_TABLE
108: , p6_a8 out nocopy JTF_DATE_TABLE
109: , p6_a9 out nocopy JTF_NUMBER_TABLE
110: );
111: procedure lock_row(p_api_version NUMBER
112: , p_init_msg_list VARCHAR2
113: , x_return_status out nocopy VARCHAR2
128: , p_init_msg_list VARCHAR2
129: , x_return_status out nocopy VARCHAR2
130: , x_msg_count out nocopy NUMBER
131: , x_msg_data out nocopy VARCHAR2
132: , p5_a0 JTF_NUMBER_TABLE
133: , p5_a1 JTF_NUMBER_TABLE
134: , p5_a2 JTF_VARCHAR2_TABLE_100
135: , p5_a3 JTF_NUMBER_TABLE
136: , p5_a4 JTF_NUMBER_TABLE
129: , x_return_status out nocopy VARCHAR2
130: , x_msg_count out nocopy NUMBER
131: , x_msg_data out nocopy VARCHAR2
132: , p5_a0 JTF_NUMBER_TABLE
133: , p5_a1 JTF_NUMBER_TABLE
134: , p5_a2 JTF_VARCHAR2_TABLE_100
135: , p5_a3 JTF_NUMBER_TABLE
136: , p5_a4 JTF_NUMBER_TABLE
137: , p5_a5 JTF_NUMBER_TABLE
131: , x_msg_data out nocopy VARCHAR2
132: , p5_a0 JTF_NUMBER_TABLE
133: , p5_a1 JTF_NUMBER_TABLE
134: , p5_a2 JTF_VARCHAR2_TABLE_100
135: , p5_a3 JTF_NUMBER_TABLE
136: , p5_a4 JTF_NUMBER_TABLE
137: , p5_a5 JTF_NUMBER_TABLE
138: , p5_a6 JTF_DATE_TABLE
139: , p5_a7 JTF_NUMBER_TABLE
132: , p5_a0 JTF_NUMBER_TABLE
133: , p5_a1 JTF_NUMBER_TABLE
134: , p5_a2 JTF_VARCHAR2_TABLE_100
135: , p5_a3 JTF_NUMBER_TABLE
136: , p5_a4 JTF_NUMBER_TABLE
137: , p5_a5 JTF_NUMBER_TABLE
138: , p5_a6 JTF_DATE_TABLE
139: , p5_a7 JTF_NUMBER_TABLE
140: , p5_a8 JTF_DATE_TABLE
133: , p5_a1 JTF_NUMBER_TABLE
134: , p5_a2 JTF_VARCHAR2_TABLE_100
135: , p5_a3 JTF_NUMBER_TABLE
136: , p5_a4 JTF_NUMBER_TABLE
137: , p5_a5 JTF_NUMBER_TABLE
138: , p5_a6 JTF_DATE_TABLE
139: , p5_a7 JTF_NUMBER_TABLE
140: , p5_a8 JTF_DATE_TABLE
141: , p5_a9 JTF_NUMBER_TABLE
135: , p5_a3 JTF_NUMBER_TABLE
136: , p5_a4 JTF_NUMBER_TABLE
137: , p5_a5 JTF_NUMBER_TABLE
138: , p5_a6 JTF_DATE_TABLE
139: , p5_a7 JTF_NUMBER_TABLE
140: , p5_a8 JTF_DATE_TABLE
141: , p5_a9 JTF_NUMBER_TABLE
142: , p6_a0 in out nocopy JTF_NUMBER_TABLE
143: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
137: , p5_a5 JTF_NUMBER_TABLE
138: , p5_a6 JTF_DATE_TABLE
139: , p5_a7 JTF_NUMBER_TABLE
140: , p5_a8 JTF_DATE_TABLE
141: , p5_a9 JTF_NUMBER_TABLE
142: , p6_a0 in out nocopy JTF_NUMBER_TABLE
143: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
144: , p6_a2 in out nocopy JTF_NUMBER_TABLE
145: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
138: , p5_a6 JTF_DATE_TABLE
139: , p5_a7 JTF_NUMBER_TABLE
140: , p5_a8 JTF_DATE_TABLE
141: , p5_a9 JTF_NUMBER_TABLE
142: , p6_a0 in out nocopy JTF_NUMBER_TABLE
143: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
144: , p6_a2 in out nocopy JTF_NUMBER_TABLE
145: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
146: , p6_a4 in out nocopy JTF_NUMBER_TABLE
140: , p5_a8 JTF_DATE_TABLE
141: , p5_a9 JTF_NUMBER_TABLE
142: , p6_a0 in out nocopy JTF_NUMBER_TABLE
143: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
144: , p6_a2 in out nocopy JTF_NUMBER_TABLE
145: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
146: , p6_a4 in out nocopy JTF_NUMBER_TABLE
147: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
142: , p6_a0 in out nocopy JTF_NUMBER_TABLE
143: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
144: , p6_a2 in out nocopy JTF_NUMBER_TABLE
145: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
146: , p6_a4 in out nocopy JTF_NUMBER_TABLE
147: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
149: );
150: procedure lock_row(p_api_version NUMBER
151: , p_init_msg_list VARCHAR2
152: , x_return_status out nocopy VARCHAR2
153: , x_msg_count out nocopy NUMBER
154: , x_msg_data out nocopy VARCHAR2
155: , p5_a0 JTF_NUMBER_TABLE
156: , p5_a1 JTF_NUMBER_TABLE
157: , p5_a2 JTF_VARCHAR2_TABLE_100
158: , p5_a3 JTF_NUMBER_TABLE
159: , p5_a4 JTF_NUMBER_TABLE
152: , x_return_status out nocopy VARCHAR2
153: , x_msg_count out nocopy NUMBER
154: , x_msg_data out nocopy VARCHAR2
155: , p5_a0 JTF_NUMBER_TABLE
156: , p5_a1 JTF_NUMBER_TABLE
157: , p5_a2 JTF_VARCHAR2_TABLE_100
158: , p5_a3 JTF_NUMBER_TABLE
159: , p5_a4 JTF_NUMBER_TABLE
160: , p5_a5 JTF_NUMBER_TABLE
154: , x_msg_data out nocopy VARCHAR2
155: , p5_a0 JTF_NUMBER_TABLE
156: , p5_a1 JTF_NUMBER_TABLE
157: , p5_a2 JTF_VARCHAR2_TABLE_100
158: , p5_a3 JTF_NUMBER_TABLE
159: , p5_a4 JTF_NUMBER_TABLE
160: , p5_a5 JTF_NUMBER_TABLE
161: , p5_a6 JTF_DATE_TABLE
162: , p5_a7 JTF_NUMBER_TABLE
155: , p5_a0 JTF_NUMBER_TABLE
156: , p5_a1 JTF_NUMBER_TABLE
157: , p5_a2 JTF_VARCHAR2_TABLE_100
158: , p5_a3 JTF_NUMBER_TABLE
159: , p5_a4 JTF_NUMBER_TABLE
160: , p5_a5 JTF_NUMBER_TABLE
161: , p5_a6 JTF_DATE_TABLE
162: , p5_a7 JTF_NUMBER_TABLE
163: , p5_a8 JTF_DATE_TABLE
156: , p5_a1 JTF_NUMBER_TABLE
157: , p5_a2 JTF_VARCHAR2_TABLE_100
158: , p5_a3 JTF_NUMBER_TABLE
159: , p5_a4 JTF_NUMBER_TABLE
160: , p5_a5 JTF_NUMBER_TABLE
161: , p5_a6 JTF_DATE_TABLE
162: , p5_a7 JTF_NUMBER_TABLE
163: , p5_a8 JTF_DATE_TABLE
164: , p5_a9 JTF_NUMBER_TABLE
158: , p5_a3 JTF_NUMBER_TABLE
159: , p5_a4 JTF_NUMBER_TABLE
160: , p5_a5 JTF_NUMBER_TABLE
161: , p5_a6 JTF_DATE_TABLE
162: , p5_a7 JTF_NUMBER_TABLE
163: , p5_a8 JTF_DATE_TABLE
164: , p5_a9 JTF_NUMBER_TABLE
165: );
166: procedure update_row(p_api_version NUMBER
160: , p5_a5 JTF_NUMBER_TABLE
161: , p5_a6 JTF_DATE_TABLE
162: , p5_a7 JTF_NUMBER_TABLE
163: , p5_a8 JTF_DATE_TABLE
164: , p5_a9 JTF_NUMBER_TABLE
165: );
166: procedure update_row(p_api_version NUMBER
167: , p_init_msg_list VARCHAR2
168: , x_return_status out nocopy VARCHAR2
193: , p_init_msg_list VARCHAR2
194: , x_return_status out nocopy VARCHAR2
195: , x_msg_count out nocopy NUMBER
196: , x_msg_data out nocopy VARCHAR2
197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_VARCHAR2_TABLE_100
200: , p5_a3 JTF_NUMBER_TABLE
201: , p5_a4 JTF_NUMBER_TABLE
194: , x_return_status out nocopy VARCHAR2
195: , x_msg_count out nocopy NUMBER
196: , x_msg_data out nocopy VARCHAR2
197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_VARCHAR2_TABLE_100
200: , p5_a3 JTF_NUMBER_TABLE
201: , p5_a4 JTF_NUMBER_TABLE
202: , p5_a5 JTF_NUMBER_TABLE
196: , x_msg_data out nocopy VARCHAR2
197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_VARCHAR2_TABLE_100
200: , p5_a3 JTF_NUMBER_TABLE
201: , p5_a4 JTF_NUMBER_TABLE
202: , p5_a5 JTF_NUMBER_TABLE
203: , p5_a6 JTF_DATE_TABLE
204: , p5_a7 JTF_NUMBER_TABLE
197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_VARCHAR2_TABLE_100
200: , p5_a3 JTF_NUMBER_TABLE
201: , p5_a4 JTF_NUMBER_TABLE
202: , p5_a5 JTF_NUMBER_TABLE
203: , p5_a6 JTF_DATE_TABLE
204: , p5_a7 JTF_NUMBER_TABLE
205: , p5_a8 JTF_DATE_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_VARCHAR2_TABLE_100
200: , p5_a3 JTF_NUMBER_TABLE
201: , p5_a4 JTF_NUMBER_TABLE
202: , p5_a5 JTF_NUMBER_TABLE
203: , p5_a6 JTF_DATE_TABLE
204: , p5_a7 JTF_NUMBER_TABLE
205: , p5_a8 JTF_DATE_TABLE
206: , p5_a9 JTF_NUMBER_TABLE
200: , p5_a3 JTF_NUMBER_TABLE
201: , p5_a4 JTF_NUMBER_TABLE
202: , p5_a5 JTF_NUMBER_TABLE
203: , p5_a6 JTF_DATE_TABLE
204: , p5_a7 JTF_NUMBER_TABLE
205: , p5_a8 JTF_DATE_TABLE
206: , p5_a9 JTF_NUMBER_TABLE
207: , p6_a0 out nocopy JTF_NUMBER_TABLE
208: , p6_a1 out nocopy JTF_NUMBER_TABLE
202: , p5_a5 JTF_NUMBER_TABLE
203: , p5_a6 JTF_DATE_TABLE
204: , p5_a7 JTF_NUMBER_TABLE
205: , p5_a8 JTF_DATE_TABLE
206: , p5_a9 JTF_NUMBER_TABLE
207: , p6_a0 out nocopy JTF_NUMBER_TABLE
208: , p6_a1 out nocopy JTF_NUMBER_TABLE
209: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a3 out nocopy JTF_NUMBER_TABLE
203: , p5_a6 JTF_DATE_TABLE
204: , p5_a7 JTF_NUMBER_TABLE
205: , p5_a8 JTF_DATE_TABLE
206: , p5_a9 JTF_NUMBER_TABLE
207: , p6_a0 out nocopy JTF_NUMBER_TABLE
208: , p6_a1 out nocopy JTF_NUMBER_TABLE
209: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a3 out nocopy JTF_NUMBER_TABLE
211: , p6_a4 out nocopy JTF_NUMBER_TABLE
204: , p5_a7 JTF_NUMBER_TABLE
205: , p5_a8 JTF_DATE_TABLE
206: , p5_a9 JTF_NUMBER_TABLE
207: , p6_a0 out nocopy JTF_NUMBER_TABLE
208: , p6_a1 out nocopy JTF_NUMBER_TABLE
209: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a3 out nocopy JTF_NUMBER_TABLE
211: , p6_a4 out nocopy JTF_NUMBER_TABLE
212: , p6_a5 out nocopy JTF_NUMBER_TABLE
206: , p5_a9 JTF_NUMBER_TABLE
207: , p6_a0 out nocopy JTF_NUMBER_TABLE
208: , p6_a1 out nocopy JTF_NUMBER_TABLE
209: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a3 out nocopy JTF_NUMBER_TABLE
211: , p6_a4 out nocopy JTF_NUMBER_TABLE
212: , p6_a5 out nocopy JTF_NUMBER_TABLE
213: , p6_a6 out nocopy JTF_DATE_TABLE
214: , p6_a7 out nocopy JTF_NUMBER_TABLE
207: , p6_a0 out nocopy JTF_NUMBER_TABLE
208: , p6_a1 out nocopy JTF_NUMBER_TABLE
209: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a3 out nocopy JTF_NUMBER_TABLE
211: , p6_a4 out nocopy JTF_NUMBER_TABLE
212: , p6_a5 out nocopy JTF_NUMBER_TABLE
213: , p6_a6 out nocopy JTF_DATE_TABLE
214: , p6_a7 out nocopy JTF_NUMBER_TABLE
215: , p6_a8 out nocopy JTF_DATE_TABLE
208: , p6_a1 out nocopy JTF_NUMBER_TABLE
209: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a3 out nocopy JTF_NUMBER_TABLE
211: , p6_a4 out nocopy JTF_NUMBER_TABLE
212: , p6_a5 out nocopy JTF_NUMBER_TABLE
213: , p6_a6 out nocopy JTF_DATE_TABLE
214: , p6_a7 out nocopy JTF_NUMBER_TABLE
215: , p6_a8 out nocopy JTF_DATE_TABLE
216: , p6_a9 out nocopy JTF_NUMBER_TABLE
210: , p6_a3 out nocopy JTF_NUMBER_TABLE
211: , p6_a4 out nocopy JTF_NUMBER_TABLE
212: , p6_a5 out nocopy JTF_NUMBER_TABLE
213: , p6_a6 out nocopy JTF_DATE_TABLE
214: , p6_a7 out nocopy JTF_NUMBER_TABLE
215: , p6_a8 out nocopy JTF_DATE_TABLE
216: , p6_a9 out nocopy JTF_NUMBER_TABLE
217: , p7_a0 in out nocopy JTF_NUMBER_TABLE
218: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
212: , p6_a5 out nocopy JTF_NUMBER_TABLE
213: , p6_a6 out nocopy JTF_DATE_TABLE
214: , p6_a7 out nocopy JTF_NUMBER_TABLE
215: , p6_a8 out nocopy JTF_DATE_TABLE
216: , p6_a9 out nocopy JTF_NUMBER_TABLE
217: , p7_a0 in out nocopy JTF_NUMBER_TABLE
218: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p7_a2 in out nocopy JTF_NUMBER_TABLE
220: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
213: , p6_a6 out nocopy JTF_DATE_TABLE
214: , p6_a7 out nocopy JTF_NUMBER_TABLE
215: , p6_a8 out nocopy JTF_DATE_TABLE
216: , p6_a9 out nocopy JTF_NUMBER_TABLE
217: , p7_a0 in out nocopy JTF_NUMBER_TABLE
218: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p7_a2 in out nocopy JTF_NUMBER_TABLE
220: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
221: , p7_a4 in out nocopy JTF_NUMBER_TABLE
215: , p6_a8 out nocopy JTF_DATE_TABLE
216: , p6_a9 out nocopy JTF_NUMBER_TABLE
217: , p7_a0 in out nocopy JTF_NUMBER_TABLE
218: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p7_a2 in out nocopy JTF_NUMBER_TABLE
220: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
221: , p7_a4 in out nocopy JTF_NUMBER_TABLE
222: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
217: , p7_a0 in out nocopy JTF_NUMBER_TABLE
218: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p7_a2 in out nocopy JTF_NUMBER_TABLE
220: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
221: , p7_a4 in out nocopy JTF_NUMBER_TABLE
222: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
224: );
225: procedure update_row(p_api_version NUMBER
226: , p_init_msg_list VARCHAR2
227: , x_return_status out nocopy VARCHAR2
228: , x_msg_count out nocopy NUMBER
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_100
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
227: , x_return_status out nocopy VARCHAR2
228: , x_msg_count out nocopy NUMBER
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_100
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_NUMBER_TABLE
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_100
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_NUMBER_TABLE
236: , p5_a6 JTF_DATE_TABLE
237: , p5_a7 JTF_NUMBER_TABLE
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_100
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_NUMBER_TABLE
236: , p5_a6 JTF_DATE_TABLE
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_100
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_NUMBER_TABLE
236: , p5_a6 JTF_DATE_TABLE
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE
239: , p5_a9 JTF_NUMBER_TABLE
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_NUMBER_TABLE
236: , p5_a6 JTF_DATE_TABLE
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE
239: , p5_a9 JTF_NUMBER_TABLE
240: , p6_a0 out nocopy JTF_NUMBER_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE
235: , p5_a5 JTF_NUMBER_TABLE
236: , p5_a6 JTF_DATE_TABLE
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE
239: , p5_a9 JTF_NUMBER_TABLE
240: , p6_a0 out nocopy JTF_NUMBER_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE
242: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
236: , p5_a6 JTF_DATE_TABLE
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE
239: , p5_a9 JTF_NUMBER_TABLE
240: , p6_a0 out nocopy JTF_NUMBER_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE
242: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_NUMBER_TABLE
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE
239: , p5_a9 JTF_NUMBER_TABLE
240: , p6_a0 out nocopy JTF_NUMBER_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE
242: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_NUMBER_TABLE
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
239: , p5_a9 JTF_NUMBER_TABLE
240: , p6_a0 out nocopy JTF_NUMBER_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE
242: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_NUMBER_TABLE
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_DATE_TABLE
247: , p6_a7 out nocopy JTF_NUMBER_TABLE
240: , p6_a0 out nocopy JTF_NUMBER_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE
242: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_NUMBER_TABLE
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_DATE_TABLE
247: , p6_a7 out nocopy JTF_NUMBER_TABLE
248: , p6_a8 out nocopy JTF_DATE_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE
242: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_NUMBER_TABLE
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_DATE_TABLE
247: , p6_a7 out nocopy JTF_NUMBER_TABLE
248: , p6_a8 out nocopy JTF_DATE_TABLE
249: , p6_a9 out nocopy JTF_NUMBER_TABLE
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_NUMBER_TABLE
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_DATE_TABLE
247: , p6_a7 out nocopy JTF_NUMBER_TABLE
248: , p6_a8 out nocopy JTF_DATE_TABLE
249: , p6_a9 out nocopy JTF_NUMBER_TABLE
250: );
251: procedure delete_row(p_api_version NUMBER
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_DATE_TABLE
247: , p6_a7 out nocopy JTF_NUMBER_TABLE
248: , p6_a8 out nocopy JTF_DATE_TABLE
249: , p6_a9 out nocopy JTF_NUMBER_TABLE
250: );
251: procedure delete_row(p_api_version NUMBER
252: , p_init_msg_list VARCHAR2
253: , x_return_status out nocopy VARCHAR2
268: , p_init_msg_list VARCHAR2
269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_NUMBER_TABLE
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_NUMBER_TABLE
278: , p5_a6 JTF_DATE_TABLE
279: , p5_a7 JTF_NUMBER_TABLE
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_NUMBER_TABLE
278: , p5_a6 JTF_DATE_TABLE
279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 JTF_DATE_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_NUMBER_TABLE
278: , p5_a6 JTF_DATE_TABLE
279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 JTF_DATE_TABLE
281: , p5_a9 JTF_NUMBER_TABLE
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_NUMBER_TABLE
278: , p5_a6 JTF_DATE_TABLE
279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 JTF_DATE_TABLE
281: , p5_a9 JTF_NUMBER_TABLE
282: , p6_a0 in out nocopy JTF_NUMBER_TABLE
283: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p5_a5 JTF_NUMBER_TABLE
278: , p5_a6 JTF_DATE_TABLE
279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 JTF_DATE_TABLE
281: , p5_a9 JTF_NUMBER_TABLE
282: , p6_a0 in out nocopy JTF_NUMBER_TABLE
283: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a2 in out nocopy JTF_NUMBER_TABLE
285: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
278: , p5_a6 JTF_DATE_TABLE
279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 JTF_DATE_TABLE
281: , p5_a9 JTF_NUMBER_TABLE
282: , p6_a0 in out nocopy JTF_NUMBER_TABLE
283: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a2 in out nocopy JTF_NUMBER_TABLE
285: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
286: , p6_a4 in out nocopy JTF_NUMBER_TABLE
280: , p5_a8 JTF_DATE_TABLE
281: , p5_a9 JTF_NUMBER_TABLE
282: , p6_a0 in out nocopy JTF_NUMBER_TABLE
283: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a2 in out nocopy JTF_NUMBER_TABLE
285: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
286: , p6_a4 in out nocopy JTF_NUMBER_TABLE
287: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a0 in out nocopy JTF_NUMBER_TABLE
283: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a2 in out nocopy JTF_NUMBER_TABLE
285: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
286: , p6_a4 in out nocopy JTF_NUMBER_TABLE
287: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
289: );
290: procedure delete_row(p_api_version NUMBER
291: , p_init_msg_list VARCHAR2
292: , x_return_status out nocopy VARCHAR2
293: , x_msg_count out nocopy NUMBER
294: , x_msg_data out nocopy VARCHAR2
295: , p5_a0 JTF_NUMBER_TABLE
296: , p5_a1 JTF_NUMBER_TABLE
297: , p5_a2 JTF_VARCHAR2_TABLE_100
298: , p5_a3 JTF_NUMBER_TABLE
299: , p5_a4 JTF_NUMBER_TABLE
292: , x_return_status out nocopy VARCHAR2
293: , x_msg_count out nocopy NUMBER
294: , x_msg_data out nocopy VARCHAR2
295: , p5_a0 JTF_NUMBER_TABLE
296: , p5_a1 JTF_NUMBER_TABLE
297: , p5_a2 JTF_VARCHAR2_TABLE_100
298: , p5_a3 JTF_NUMBER_TABLE
299: , p5_a4 JTF_NUMBER_TABLE
300: , p5_a5 JTF_NUMBER_TABLE
294: , x_msg_data out nocopy VARCHAR2
295: , p5_a0 JTF_NUMBER_TABLE
296: , p5_a1 JTF_NUMBER_TABLE
297: , p5_a2 JTF_VARCHAR2_TABLE_100
298: , p5_a3 JTF_NUMBER_TABLE
299: , p5_a4 JTF_NUMBER_TABLE
300: , p5_a5 JTF_NUMBER_TABLE
301: , p5_a6 JTF_DATE_TABLE
302: , p5_a7 JTF_NUMBER_TABLE
295: , p5_a0 JTF_NUMBER_TABLE
296: , p5_a1 JTF_NUMBER_TABLE
297: , p5_a2 JTF_VARCHAR2_TABLE_100
298: , p5_a3 JTF_NUMBER_TABLE
299: , p5_a4 JTF_NUMBER_TABLE
300: , p5_a5 JTF_NUMBER_TABLE
301: , p5_a6 JTF_DATE_TABLE
302: , p5_a7 JTF_NUMBER_TABLE
303: , p5_a8 JTF_DATE_TABLE
296: , p5_a1 JTF_NUMBER_TABLE
297: , p5_a2 JTF_VARCHAR2_TABLE_100
298: , p5_a3 JTF_NUMBER_TABLE
299: , p5_a4 JTF_NUMBER_TABLE
300: , p5_a5 JTF_NUMBER_TABLE
301: , p5_a6 JTF_DATE_TABLE
302: , p5_a7 JTF_NUMBER_TABLE
303: , p5_a8 JTF_DATE_TABLE
304: , p5_a9 JTF_NUMBER_TABLE
298: , p5_a3 JTF_NUMBER_TABLE
299: , p5_a4 JTF_NUMBER_TABLE
300: , p5_a5 JTF_NUMBER_TABLE
301: , p5_a6 JTF_DATE_TABLE
302: , p5_a7 JTF_NUMBER_TABLE
303: , p5_a8 JTF_DATE_TABLE
304: , p5_a9 JTF_NUMBER_TABLE
305: );
306: procedure validate_row(p_api_version NUMBER
300: , p5_a5 JTF_NUMBER_TABLE
301: , p5_a6 JTF_DATE_TABLE
302: , p5_a7 JTF_NUMBER_TABLE
303: , p5_a8 JTF_DATE_TABLE
304: , p5_a9 JTF_NUMBER_TABLE
305: );
306: procedure validate_row(p_api_version NUMBER
307: , p_init_msg_list VARCHAR2
308: , x_return_status out nocopy VARCHAR2
323: , p_init_msg_list VARCHAR2
324: , x_return_status out nocopy VARCHAR2
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_VARCHAR2_TABLE_100
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
324: , x_return_status out nocopy VARCHAR2
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_VARCHAR2_TABLE_100
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_NUMBER_TABLE
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_VARCHAR2_TABLE_100
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_NUMBER_TABLE
333: , p5_a6 JTF_DATE_TABLE
334: , p5_a7 JTF_NUMBER_TABLE
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_VARCHAR2_TABLE_100
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_NUMBER_TABLE
333: , p5_a6 JTF_DATE_TABLE
334: , p5_a7 JTF_NUMBER_TABLE
335: , p5_a8 JTF_DATE_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_VARCHAR2_TABLE_100
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_NUMBER_TABLE
333: , p5_a6 JTF_DATE_TABLE
334: , p5_a7 JTF_NUMBER_TABLE
335: , p5_a8 JTF_DATE_TABLE
336: , p5_a9 JTF_NUMBER_TABLE
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_NUMBER_TABLE
333: , p5_a6 JTF_DATE_TABLE
334: , p5_a7 JTF_NUMBER_TABLE
335: , p5_a8 JTF_DATE_TABLE
336: , p5_a9 JTF_NUMBER_TABLE
337: , p6_a0 in out nocopy JTF_NUMBER_TABLE
338: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
332: , p5_a5 JTF_NUMBER_TABLE
333: , p5_a6 JTF_DATE_TABLE
334: , p5_a7 JTF_NUMBER_TABLE
335: , p5_a8 JTF_DATE_TABLE
336: , p5_a9 JTF_NUMBER_TABLE
337: , p6_a0 in out nocopy JTF_NUMBER_TABLE
338: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a2 in out nocopy JTF_NUMBER_TABLE
340: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
333: , p5_a6 JTF_DATE_TABLE
334: , p5_a7 JTF_NUMBER_TABLE
335: , p5_a8 JTF_DATE_TABLE
336: , p5_a9 JTF_NUMBER_TABLE
337: , p6_a0 in out nocopy JTF_NUMBER_TABLE
338: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a2 in out nocopy JTF_NUMBER_TABLE
340: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
341: , p6_a4 in out nocopy JTF_NUMBER_TABLE
335: , p5_a8 JTF_DATE_TABLE
336: , p5_a9 JTF_NUMBER_TABLE
337: , p6_a0 in out nocopy JTF_NUMBER_TABLE
338: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a2 in out nocopy JTF_NUMBER_TABLE
340: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
341: , p6_a4 in out nocopy JTF_NUMBER_TABLE
342: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a0 in out nocopy JTF_NUMBER_TABLE
338: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a2 in out nocopy JTF_NUMBER_TABLE
340: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
341: , p6_a4 in out nocopy JTF_NUMBER_TABLE
342: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
344: );
345: procedure validate_row(p_api_version NUMBER
346: , p_init_msg_list VARCHAR2
347: , x_return_status out nocopy VARCHAR2
348: , x_msg_count out nocopy NUMBER
349: , x_msg_data out nocopy VARCHAR2
350: , p5_a0 JTF_NUMBER_TABLE
351: , p5_a1 JTF_NUMBER_TABLE
352: , p5_a2 JTF_VARCHAR2_TABLE_100
353: , p5_a3 JTF_NUMBER_TABLE
354: , p5_a4 JTF_NUMBER_TABLE
347: , x_return_status out nocopy VARCHAR2
348: , x_msg_count out nocopy NUMBER
349: , x_msg_data out nocopy VARCHAR2
350: , p5_a0 JTF_NUMBER_TABLE
351: , p5_a1 JTF_NUMBER_TABLE
352: , p5_a2 JTF_VARCHAR2_TABLE_100
353: , p5_a3 JTF_NUMBER_TABLE
354: , p5_a4 JTF_NUMBER_TABLE
355: , p5_a5 JTF_NUMBER_TABLE
349: , x_msg_data out nocopy VARCHAR2
350: , p5_a0 JTF_NUMBER_TABLE
351: , p5_a1 JTF_NUMBER_TABLE
352: , p5_a2 JTF_VARCHAR2_TABLE_100
353: , p5_a3 JTF_NUMBER_TABLE
354: , p5_a4 JTF_NUMBER_TABLE
355: , p5_a5 JTF_NUMBER_TABLE
356: , p5_a6 JTF_DATE_TABLE
357: , p5_a7 JTF_NUMBER_TABLE
350: , p5_a0 JTF_NUMBER_TABLE
351: , p5_a1 JTF_NUMBER_TABLE
352: , p5_a2 JTF_VARCHAR2_TABLE_100
353: , p5_a3 JTF_NUMBER_TABLE
354: , p5_a4 JTF_NUMBER_TABLE
355: , p5_a5 JTF_NUMBER_TABLE
356: , p5_a6 JTF_DATE_TABLE
357: , p5_a7 JTF_NUMBER_TABLE
358: , p5_a8 JTF_DATE_TABLE
351: , p5_a1 JTF_NUMBER_TABLE
352: , p5_a2 JTF_VARCHAR2_TABLE_100
353: , p5_a3 JTF_NUMBER_TABLE
354: , p5_a4 JTF_NUMBER_TABLE
355: , p5_a5 JTF_NUMBER_TABLE
356: , p5_a6 JTF_DATE_TABLE
357: , p5_a7 JTF_NUMBER_TABLE
358: , p5_a8 JTF_DATE_TABLE
359: , p5_a9 JTF_NUMBER_TABLE
353: , p5_a3 JTF_NUMBER_TABLE
354: , p5_a4 JTF_NUMBER_TABLE
355: , p5_a5 JTF_NUMBER_TABLE
356: , p5_a6 JTF_DATE_TABLE
357: , p5_a7 JTF_NUMBER_TABLE
358: , p5_a8 JTF_DATE_TABLE
359: , p5_a9 JTF_NUMBER_TABLE
360: );
361: end okl_rap_pvt_w;
355: , p5_a5 JTF_NUMBER_TABLE
356: , p5_a6 JTF_DATE_TABLE
357: , p5_a7 JTF_NUMBER_TABLE
358: , p5_a8 JTF_DATE_TABLE
359: , p5_a9 JTF_NUMBER_TABLE
360: );
361: end okl_rap_pvt_w;