1: package okl_vp_cat_pvt_w as
2: /* $Header: OKLICARS.pls 120.2 2005/08/02 07:13:49 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vp_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package okl_vp_cat_pvt_w as
2: /* $Header: OKLICARS.pls 120.2 2005/08/02 07:13:49 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vp_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vp_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_vp_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_vp_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_vp_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE
36: procedure rosetta_table_copy_out_p2(t okl_vp_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_DATE_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_DATE_TABLE
47: , a11 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_DATE_TABLE
47: , a11 out nocopy JTF_NUMBER_TABLE
48: , a12 out nocopy JTF_DATE_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_DATE_TABLE
47: , a11 out nocopy JTF_NUMBER_TABLE
48: , a12 out nocopy JTF_DATE_TABLE
49: , a13 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_DATE_TABLE
47: , a11 out nocopy JTF_NUMBER_TABLE
48: , a12 out nocopy JTF_DATE_TABLE
49: , a13 out nocopy JTF_VARCHAR2_TABLE_100
50: , a14 out nocopy JTF_NUMBER_TABLE
51: , a15 out nocopy JTF_VARCHAR2_TABLE_100
46: , a10 out nocopy JTF_DATE_TABLE
47: , a11 out nocopy JTF_NUMBER_TABLE
48: , a12 out nocopy JTF_DATE_TABLE
49: , a13 out nocopy JTF_VARCHAR2_TABLE_100
50: , a14 out nocopy JTF_NUMBER_TABLE
51: , a15 out nocopy JTF_VARCHAR2_TABLE_100
52: , a16 out nocopy JTF_VARCHAR2_TABLE_500
53: , a17 out nocopy JTF_VARCHAR2_TABLE_500
54: , a18 out nocopy JTF_VARCHAR2_TABLE_500
63: , a27 out nocopy JTF_VARCHAR2_TABLE_500
64: , a28 out nocopy JTF_VARCHAR2_TABLE_500
65: , a29 out nocopy JTF_VARCHAR2_TABLE_500
66: , a30 out nocopy JTF_VARCHAR2_TABLE_500
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
66: , a30 out nocopy JTF_VARCHAR2_TABLE_500
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_VARCHAR2_TABLE_100
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_NUMBER_TABLE
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_VARCHAR2_TABLE_100
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_VARCHAR2_TABLE_2000
76: , a6 JTF_VARCHAR2_TABLE_300
77: , a7 JTF_VARCHAR2_TABLE_200
78: , a8 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_VARCHAR2_TABLE_2000
76: , a6 JTF_VARCHAR2_TABLE_300
77: , a7 JTF_VARCHAR2_TABLE_200
78: , a8 JTF_NUMBER_TABLE
79: , a9 JTF_DATE_TABLE
80: , a10 JTF_NUMBER_TABLE
81: , a11 JTF_DATE_TABLE
82: , a12 JTF_NUMBER_TABLE
76: , a6 JTF_VARCHAR2_TABLE_300
77: , a7 JTF_VARCHAR2_TABLE_200
78: , a8 JTF_NUMBER_TABLE
79: , a9 JTF_DATE_TABLE
80: , a10 JTF_NUMBER_TABLE
81: , a11 JTF_DATE_TABLE
82: , a12 JTF_NUMBER_TABLE
83: , a13 JTF_NUMBER_TABLE
84: , a14 JTF_VARCHAR2_TABLE_200
78: , a8 JTF_NUMBER_TABLE
79: , a9 JTF_DATE_TABLE
80: , a10 JTF_NUMBER_TABLE
81: , a11 JTF_DATE_TABLE
82: , a12 JTF_NUMBER_TABLE
83: , a13 JTF_NUMBER_TABLE
84: , a14 JTF_VARCHAR2_TABLE_200
85: );
86: procedure rosetta_table_copy_out_p5(t okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a9 JTF_DATE_TABLE
80: , a10 JTF_NUMBER_TABLE
81: , a11 JTF_DATE_TABLE
82: , a12 JTF_NUMBER_TABLE
83: , a13 JTF_NUMBER_TABLE
84: , a14 JTF_VARCHAR2_TABLE_200
85: );
86: procedure rosetta_table_copy_out_p5(t okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_VARCHAR2_TABLE_100
82: , a12 JTF_NUMBER_TABLE
83: , a13 JTF_NUMBER_TABLE
84: , a14 JTF_VARCHAR2_TABLE_200
85: );
86: procedure rosetta_table_copy_out_p5(t okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_VARCHAR2_TABLE_100
88: , a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , a3 out nocopy JTF_VARCHAR2_TABLE_100
90: , a4 out nocopy JTF_NUMBER_TABLE
86: procedure rosetta_table_copy_out_p5(t okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_VARCHAR2_TABLE_100
88: , a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , a3 out nocopy JTF_VARCHAR2_TABLE_100
90: , a4 out nocopy JTF_NUMBER_TABLE
91: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a6 out nocopy JTF_VARCHAR2_TABLE_300
93: , a7 out nocopy JTF_VARCHAR2_TABLE_200
94: , a8 out nocopy JTF_NUMBER_TABLE
90: , a4 out nocopy JTF_NUMBER_TABLE
91: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a6 out nocopy JTF_VARCHAR2_TABLE_300
93: , a7 out nocopy JTF_VARCHAR2_TABLE_200
94: , a8 out nocopy JTF_NUMBER_TABLE
95: , a9 out nocopy JTF_DATE_TABLE
96: , a10 out nocopy JTF_NUMBER_TABLE
97: , a11 out nocopy JTF_DATE_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
92: , a6 out nocopy JTF_VARCHAR2_TABLE_300
93: , a7 out nocopy JTF_VARCHAR2_TABLE_200
94: , a8 out nocopy JTF_NUMBER_TABLE
95: , a9 out nocopy JTF_DATE_TABLE
96: , a10 out nocopy JTF_NUMBER_TABLE
97: , a11 out nocopy JTF_DATE_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
99: , a13 out nocopy JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_VARCHAR2_TABLE_200
94: , a8 out nocopy JTF_NUMBER_TABLE
95: , a9 out nocopy JTF_DATE_TABLE
96: , a10 out nocopy JTF_NUMBER_TABLE
97: , a11 out nocopy JTF_DATE_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
99: , a13 out nocopy JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_VARCHAR2_TABLE_200
101: );
102:
95: , a9 out nocopy JTF_DATE_TABLE
96: , a10 out nocopy JTF_NUMBER_TABLE
97: , a11 out nocopy JTF_DATE_TABLE
98: , a12 out nocopy JTF_NUMBER_TABLE
99: , a13 out nocopy JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_VARCHAR2_TABLE_200
101: );
102:
103: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
99: , a13 out nocopy JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_VARCHAR2_TABLE_200
101: );
102:
103: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
104: , a1 JTF_NUMBER_TABLE
105: , a2 JTF_NUMBER_TABLE
106: , a3 JTF_NUMBER_TABLE
107: , a4 JTF_NUMBER_TABLE
100: , a14 out nocopy JTF_VARCHAR2_TABLE_200
101: );
102:
103: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
104: , a1 JTF_NUMBER_TABLE
105: , a2 JTF_NUMBER_TABLE
106: , a3 JTF_NUMBER_TABLE
107: , a4 JTF_NUMBER_TABLE
108: , a5 JTF_VARCHAR2_TABLE_100
101: );
102:
103: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
104: , a1 JTF_NUMBER_TABLE
105: , a2 JTF_NUMBER_TABLE
106: , a3 JTF_NUMBER_TABLE
107: , a4 JTF_NUMBER_TABLE
108: , a5 JTF_VARCHAR2_TABLE_100
109: , a6 JTF_NUMBER_TABLE
102:
103: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
104: , a1 JTF_NUMBER_TABLE
105: , a2 JTF_NUMBER_TABLE
106: , a3 JTF_NUMBER_TABLE
107: , a4 JTF_NUMBER_TABLE
108: , a5 JTF_VARCHAR2_TABLE_100
109: , a6 JTF_NUMBER_TABLE
110: , a7 JTF_VARCHAR2_TABLE_100
103: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
104: , a1 JTF_NUMBER_TABLE
105: , a2 JTF_NUMBER_TABLE
106: , a3 JTF_NUMBER_TABLE
107: , a4 JTF_NUMBER_TABLE
108: , a5 JTF_VARCHAR2_TABLE_100
109: , a6 JTF_NUMBER_TABLE
110: , a7 JTF_VARCHAR2_TABLE_100
111: , a8 JTF_VARCHAR2_TABLE_100
105: , a2 JTF_NUMBER_TABLE
106: , a3 JTF_NUMBER_TABLE
107: , a4 JTF_NUMBER_TABLE
108: , a5 JTF_VARCHAR2_TABLE_100
109: , a6 JTF_NUMBER_TABLE
110: , a7 JTF_VARCHAR2_TABLE_100
111: , a8 JTF_VARCHAR2_TABLE_100
112: , a9 JTF_NUMBER_TABLE
113: , a10 JTF_VARCHAR2_TABLE_2000
108: , a5 JTF_VARCHAR2_TABLE_100
109: , a6 JTF_NUMBER_TABLE
110: , a7 JTF_VARCHAR2_TABLE_100
111: , a8 JTF_VARCHAR2_TABLE_100
112: , a9 JTF_NUMBER_TABLE
113: , a10 JTF_VARCHAR2_TABLE_2000
114: , a11 JTF_VARCHAR2_TABLE_100
115: , a12 JTF_VARCHAR2_TABLE_300
116: , a13 JTF_VARCHAR2_TABLE_500
130: , a27 JTF_VARCHAR2_TABLE_500
131: , a28 JTF_VARCHAR2_TABLE_500
132: , a29 JTF_VARCHAR2_TABLE_500
133: , a30 JTF_VARCHAR2_TABLE_100
134: , a31 JTF_NUMBER_TABLE
135: , a32 JTF_DATE_TABLE
136: , a33 JTF_NUMBER_TABLE
137: , a34 JTF_DATE_TABLE
138: , a35 JTF_NUMBER_TABLE
132: , a29 JTF_VARCHAR2_TABLE_500
133: , a30 JTF_VARCHAR2_TABLE_100
134: , a31 JTF_NUMBER_TABLE
135: , a32 JTF_DATE_TABLE
136: , a33 JTF_NUMBER_TABLE
137: , a34 JTF_DATE_TABLE
138: , a35 JTF_NUMBER_TABLE
139: );
140: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
134: , a31 JTF_NUMBER_TABLE
135: , a32 JTF_DATE_TABLE
136: , a33 JTF_NUMBER_TABLE
137: , a34 JTF_DATE_TABLE
138: , a35 JTF_NUMBER_TABLE
139: );
140: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_NUMBER_TABLE
136: , a33 JTF_NUMBER_TABLE
137: , a34 JTF_DATE_TABLE
138: , a35 JTF_NUMBER_TABLE
139: );
140: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_NUMBER_TABLE
143: , a3 out nocopy JTF_NUMBER_TABLE
144: , a4 out nocopy JTF_NUMBER_TABLE
137: , a34 JTF_DATE_TABLE
138: , a35 JTF_NUMBER_TABLE
139: );
140: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_NUMBER_TABLE
143: , a3 out nocopy JTF_NUMBER_TABLE
144: , a4 out nocopy JTF_NUMBER_TABLE
145: , a5 out nocopy JTF_VARCHAR2_TABLE_100
138: , a35 JTF_NUMBER_TABLE
139: );
140: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_NUMBER_TABLE
143: , a3 out nocopy JTF_NUMBER_TABLE
144: , a4 out nocopy JTF_NUMBER_TABLE
145: , a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , a6 out nocopy JTF_NUMBER_TABLE
139: );
140: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_NUMBER_TABLE
143: , a3 out nocopy JTF_NUMBER_TABLE
144: , a4 out nocopy JTF_NUMBER_TABLE
145: , a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , a6 out nocopy JTF_NUMBER_TABLE
147: , a7 out nocopy JTF_VARCHAR2_TABLE_100
140: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_NUMBER_TABLE
143: , a3 out nocopy JTF_NUMBER_TABLE
144: , a4 out nocopy JTF_NUMBER_TABLE
145: , a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , a6 out nocopy JTF_NUMBER_TABLE
147: , a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , a8 out nocopy JTF_VARCHAR2_TABLE_100
142: , a2 out nocopy JTF_NUMBER_TABLE
143: , a3 out nocopy JTF_NUMBER_TABLE
144: , a4 out nocopy JTF_NUMBER_TABLE
145: , a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , a6 out nocopy JTF_NUMBER_TABLE
147: , a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , a8 out nocopy JTF_VARCHAR2_TABLE_100
149: , a9 out nocopy JTF_NUMBER_TABLE
150: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , a6 out nocopy JTF_NUMBER_TABLE
147: , a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , a8 out nocopy JTF_VARCHAR2_TABLE_100
149: , a9 out nocopy JTF_NUMBER_TABLE
150: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
151: , a11 out nocopy JTF_VARCHAR2_TABLE_100
152: , a12 out nocopy JTF_VARCHAR2_TABLE_300
153: , a13 out nocopy JTF_VARCHAR2_TABLE_500
167: , a27 out nocopy JTF_VARCHAR2_TABLE_500
168: , a28 out nocopy JTF_VARCHAR2_TABLE_500
169: , a29 out nocopy JTF_VARCHAR2_TABLE_500
170: , a30 out nocopy JTF_VARCHAR2_TABLE_100
171: , a31 out nocopy JTF_NUMBER_TABLE
172: , a32 out nocopy JTF_DATE_TABLE
173: , a33 out nocopy JTF_NUMBER_TABLE
174: , a34 out nocopy JTF_DATE_TABLE
175: , a35 out nocopy JTF_NUMBER_TABLE
169: , a29 out nocopy JTF_VARCHAR2_TABLE_500
170: , a30 out nocopy JTF_VARCHAR2_TABLE_100
171: , a31 out nocopy JTF_NUMBER_TABLE
172: , a32 out nocopy JTF_DATE_TABLE
173: , a33 out nocopy JTF_NUMBER_TABLE
174: , a34 out nocopy JTF_DATE_TABLE
175: , a35 out nocopy JTF_NUMBER_TABLE
176: );
177:
171: , a31 out nocopy JTF_NUMBER_TABLE
172: , a32 out nocopy JTF_DATE_TABLE
173: , a33 out nocopy JTF_NUMBER_TABLE
174: , a34 out nocopy JTF_DATE_TABLE
175: , a35 out nocopy JTF_NUMBER_TABLE
176: );
177:
178: procedure insert_row(p_api_version NUMBER
179: , p_init_msg_list VARCHAR2
257: , p_init_msg_list VARCHAR2
258: , x_return_status out nocopy VARCHAR2
259: , x_msg_count out nocopy NUMBER
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
258: , x_return_status out nocopy VARCHAR2
259: , x_msg_count out nocopy NUMBER
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_VARCHAR2_TABLE_100
259: , x_msg_count out nocopy NUMBER
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_VARCHAR2_TABLE_100
267: , p5_a6 JTF_NUMBER_TABLE
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_VARCHAR2_TABLE_100
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_VARCHAR2_TABLE_100
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_VARCHAR2_TABLE_100
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_VARCHAR2_TABLE_100
269: , p5_a8 JTF_VARCHAR2_TABLE_100
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_VARCHAR2_TABLE_100
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_VARCHAR2_TABLE_100
269: , p5_a8 JTF_VARCHAR2_TABLE_100
270: , p5_a9 JTF_NUMBER_TABLE
271: , p5_a10 JTF_VARCHAR2_TABLE_2000
266: , p5_a5 JTF_VARCHAR2_TABLE_100
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_VARCHAR2_TABLE_100
269: , p5_a8 JTF_VARCHAR2_TABLE_100
270: , p5_a9 JTF_NUMBER_TABLE
271: , p5_a10 JTF_VARCHAR2_TABLE_2000
272: , p5_a11 JTF_VARCHAR2_TABLE_100
273: , p5_a12 JTF_VARCHAR2_TABLE_300
274: , p5_a13 JTF_VARCHAR2_TABLE_500
288: , p5_a27 JTF_VARCHAR2_TABLE_500
289: , p5_a28 JTF_VARCHAR2_TABLE_500
290: , p5_a29 JTF_VARCHAR2_TABLE_500
291: , p5_a30 JTF_VARCHAR2_TABLE_100
292: , p5_a31 JTF_NUMBER_TABLE
293: , p5_a32 JTF_DATE_TABLE
294: , p5_a33 JTF_NUMBER_TABLE
295: , p5_a34 JTF_DATE_TABLE
296: , p5_a35 JTF_NUMBER_TABLE
290: , p5_a29 JTF_VARCHAR2_TABLE_500
291: , p5_a30 JTF_VARCHAR2_TABLE_100
292: , p5_a31 JTF_NUMBER_TABLE
293: , p5_a32 JTF_DATE_TABLE
294: , p5_a33 JTF_NUMBER_TABLE
295: , p5_a34 JTF_DATE_TABLE
296: , p5_a35 JTF_NUMBER_TABLE
297: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p5_a31 JTF_NUMBER_TABLE
293: , p5_a32 JTF_DATE_TABLE
294: , p5_a33 JTF_NUMBER_TABLE
295: , p5_a34 JTF_DATE_TABLE
296: , p5_a35 JTF_NUMBER_TABLE
297: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p6_a1 out nocopy JTF_NUMBER_TABLE
299: , p6_a2 out nocopy JTF_NUMBER_TABLE
300: , p6_a3 out nocopy JTF_NUMBER_TABLE
293: , p5_a32 JTF_DATE_TABLE
294: , p5_a33 JTF_NUMBER_TABLE
295: , p5_a34 JTF_DATE_TABLE
296: , p5_a35 JTF_NUMBER_TABLE
297: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p6_a1 out nocopy JTF_NUMBER_TABLE
299: , p6_a2 out nocopy JTF_NUMBER_TABLE
300: , p6_a3 out nocopy JTF_NUMBER_TABLE
301: , p6_a4 out nocopy JTF_NUMBER_TABLE
294: , p5_a33 JTF_NUMBER_TABLE
295: , p5_a34 JTF_DATE_TABLE
296: , p5_a35 JTF_NUMBER_TABLE
297: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p6_a1 out nocopy JTF_NUMBER_TABLE
299: , p6_a2 out nocopy JTF_NUMBER_TABLE
300: , p6_a3 out nocopy JTF_NUMBER_TABLE
301: , p6_a4 out nocopy JTF_NUMBER_TABLE
302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
295: , p5_a34 JTF_DATE_TABLE
296: , p5_a35 JTF_NUMBER_TABLE
297: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p6_a1 out nocopy JTF_NUMBER_TABLE
299: , p6_a2 out nocopy JTF_NUMBER_TABLE
300: , p6_a3 out nocopy JTF_NUMBER_TABLE
301: , p6_a4 out nocopy JTF_NUMBER_TABLE
302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a6 out nocopy JTF_NUMBER_TABLE
296: , p5_a35 JTF_NUMBER_TABLE
297: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p6_a1 out nocopy JTF_NUMBER_TABLE
299: , p6_a2 out nocopy JTF_NUMBER_TABLE
300: , p6_a3 out nocopy JTF_NUMBER_TABLE
301: , p6_a4 out nocopy JTF_NUMBER_TABLE
302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a6 out nocopy JTF_NUMBER_TABLE
304: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
297: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p6_a1 out nocopy JTF_NUMBER_TABLE
299: , p6_a2 out nocopy JTF_NUMBER_TABLE
300: , p6_a3 out nocopy JTF_NUMBER_TABLE
301: , p6_a4 out nocopy JTF_NUMBER_TABLE
302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a6 out nocopy JTF_NUMBER_TABLE
304: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
299: , p6_a2 out nocopy JTF_NUMBER_TABLE
300: , p6_a3 out nocopy JTF_NUMBER_TABLE
301: , p6_a4 out nocopy JTF_NUMBER_TABLE
302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a6 out nocopy JTF_NUMBER_TABLE
304: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
306: , p6_a9 out nocopy JTF_NUMBER_TABLE
307: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a6 out nocopy JTF_NUMBER_TABLE
304: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
306: , p6_a9 out nocopy JTF_NUMBER_TABLE
307: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
308: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
310: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
324: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
325: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
326: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
327: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a31 out nocopy JTF_NUMBER_TABLE
329: , p6_a32 out nocopy JTF_DATE_TABLE
330: , p6_a33 out nocopy JTF_NUMBER_TABLE
331: , p6_a34 out nocopy JTF_DATE_TABLE
332: , p6_a35 out nocopy JTF_NUMBER_TABLE
326: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
327: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a31 out nocopy JTF_NUMBER_TABLE
329: , p6_a32 out nocopy JTF_DATE_TABLE
330: , p6_a33 out nocopy JTF_NUMBER_TABLE
331: , p6_a34 out nocopy JTF_DATE_TABLE
332: , p6_a35 out nocopy JTF_NUMBER_TABLE
333: );
334: procedure lock_row(p_api_version NUMBER
328: , p6_a31 out nocopy JTF_NUMBER_TABLE
329: , p6_a32 out nocopy JTF_DATE_TABLE
330: , p6_a33 out nocopy JTF_NUMBER_TABLE
331: , p6_a34 out nocopy JTF_DATE_TABLE
332: , p6_a35 out nocopy JTF_NUMBER_TABLE
333: );
334: procedure lock_row(p_api_version NUMBER
335: , p_init_msg_list VARCHAR2
336: , x_return_status out nocopy VARCHAR2
377: , p_init_msg_list VARCHAR2
378: , x_return_status out nocopy VARCHAR2
379: , x_msg_count out nocopy NUMBER
380: , x_msg_data out nocopy VARCHAR2
381: , p5_a0 JTF_NUMBER_TABLE
382: , p5_a1 JTF_NUMBER_TABLE
383: , p5_a2 JTF_NUMBER_TABLE
384: , p5_a3 JTF_NUMBER_TABLE
385: , p5_a4 JTF_NUMBER_TABLE
378: , x_return_status out nocopy VARCHAR2
379: , x_msg_count out nocopy NUMBER
380: , x_msg_data out nocopy VARCHAR2
381: , p5_a0 JTF_NUMBER_TABLE
382: , p5_a1 JTF_NUMBER_TABLE
383: , p5_a2 JTF_NUMBER_TABLE
384: , p5_a3 JTF_NUMBER_TABLE
385: , p5_a4 JTF_NUMBER_TABLE
386: , p5_a5 JTF_VARCHAR2_TABLE_100
379: , x_msg_count out nocopy NUMBER
380: , x_msg_data out nocopy VARCHAR2
381: , p5_a0 JTF_NUMBER_TABLE
382: , p5_a1 JTF_NUMBER_TABLE
383: , p5_a2 JTF_NUMBER_TABLE
384: , p5_a3 JTF_NUMBER_TABLE
385: , p5_a4 JTF_NUMBER_TABLE
386: , p5_a5 JTF_VARCHAR2_TABLE_100
387: , p5_a6 JTF_NUMBER_TABLE
380: , x_msg_data out nocopy VARCHAR2
381: , p5_a0 JTF_NUMBER_TABLE
382: , p5_a1 JTF_NUMBER_TABLE
383: , p5_a2 JTF_NUMBER_TABLE
384: , p5_a3 JTF_NUMBER_TABLE
385: , p5_a4 JTF_NUMBER_TABLE
386: , p5_a5 JTF_VARCHAR2_TABLE_100
387: , p5_a6 JTF_NUMBER_TABLE
388: , p5_a7 JTF_VARCHAR2_TABLE_100
381: , p5_a0 JTF_NUMBER_TABLE
382: , p5_a1 JTF_NUMBER_TABLE
383: , p5_a2 JTF_NUMBER_TABLE
384: , p5_a3 JTF_NUMBER_TABLE
385: , p5_a4 JTF_NUMBER_TABLE
386: , p5_a5 JTF_VARCHAR2_TABLE_100
387: , p5_a6 JTF_NUMBER_TABLE
388: , p5_a7 JTF_VARCHAR2_TABLE_100
389: , p5_a8 JTF_VARCHAR2_TABLE_100
383: , p5_a2 JTF_NUMBER_TABLE
384: , p5_a3 JTF_NUMBER_TABLE
385: , p5_a4 JTF_NUMBER_TABLE
386: , p5_a5 JTF_VARCHAR2_TABLE_100
387: , p5_a6 JTF_NUMBER_TABLE
388: , p5_a7 JTF_VARCHAR2_TABLE_100
389: , p5_a8 JTF_VARCHAR2_TABLE_100
390: , p5_a9 JTF_NUMBER_TABLE
391: , p5_a10 JTF_VARCHAR2_TABLE_2000
386: , p5_a5 JTF_VARCHAR2_TABLE_100
387: , p5_a6 JTF_NUMBER_TABLE
388: , p5_a7 JTF_VARCHAR2_TABLE_100
389: , p5_a8 JTF_VARCHAR2_TABLE_100
390: , p5_a9 JTF_NUMBER_TABLE
391: , p5_a10 JTF_VARCHAR2_TABLE_2000
392: , p5_a11 JTF_VARCHAR2_TABLE_100
393: , p5_a12 JTF_VARCHAR2_TABLE_300
394: , p5_a13 JTF_VARCHAR2_TABLE_500
408: , p5_a27 JTF_VARCHAR2_TABLE_500
409: , p5_a28 JTF_VARCHAR2_TABLE_500
410: , p5_a29 JTF_VARCHAR2_TABLE_500
411: , p5_a30 JTF_VARCHAR2_TABLE_100
412: , p5_a31 JTF_NUMBER_TABLE
413: , p5_a32 JTF_DATE_TABLE
414: , p5_a33 JTF_NUMBER_TABLE
415: , p5_a34 JTF_DATE_TABLE
416: , p5_a35 JTF_NUMBER_TABLE
410: , p5_a29 JTF_VARCHAR2_TABLE_500
411: , p5_a30 JTF_VARCHAR2_TABLE_100
412: , p5_a31 JTF_NUMBER_TABLE
413: , p5_a32 JTF_DATE_TABLE
414: , p5_a33 JTF_NUMBER_TABLE
415: , p5_a34 JTF_DATE_TABLE
416: , p5_a35 JTF_NUMBER_TABLE
417: );
418: procedure update_row(p_api_version NUMBER
412: , p5_a31 JTF_NUMBER_TABLE
413: , p5_a32 JTF_DATE_TABLE
414: , p5_a33 JTF_NUMBER_TABLE
415: , p5_a34 JTF_DATE_TABLE
416: , p5_a35 JTF_NUMBER_TABLE
417: );
418: procedure update_row(p_api_version NUMBER
419: , p_init_msg_list VARCHAR2
420: , x_return_status out nocopy VARCHAR2
497: , p_init_msg_list VARCHAR2
498: , x_return_status out nocopy VARCHAR2
499: , x_msg_count out nocopy NUMBER
500: , x_msg_data out nocopy VARCHAR2
501: , p5_a0 JTF_NUMBER_TABLE
502: , p5_a1 JTF_NUMBER_TABLE
503: , p5_a2 JTF_NUMBER_TABLE
504: , p5_a3 JTF_NUMBER_TABLE
505: , p5_a4 JTF_NUMBER_TABLE
498: , x_return_status out nocopy VARCHAR2
499: , x_msg_count out nocopy NUMBER
500: , x_msg_data out nocopy VARCHAR2
501: , p5_a0 JTF_NUMBER_TABLE
502: , p5_a1 JTF_NUMBER_TABLE
503: , p5_a2 JTF_NUMBER_TABLE
504: , p5_a3 JTF_NUMBER_TABLE
505: , p5_a4 JTF_NUMBER_TABLE
506: , p5_a5 JTF_VARCHAR2_TABLE_100
499: , x_msg_count out nocopy NUMBER
500: , x_msg_data out nocopy VARCHAR2
501: , p5_a0 JTF_NUMBER_TABLE
502: , p5_a1 JTF_NUMBER_TABLE
503: , p5_a2 JTF_NUMBER_TABLE
504: , p5_a3 JTF_NUMBER_TABLE
505: , p5_a4 JTF_NUMBER_TABLE
506: , p5_a5 JTF_VARCHAR2_TABLE_100
507: , p5_a6 JTF_NUMBER_TABLE
500: , x_msg_data out nocopy VARCHAR2
501: , p5_a0 JTF_NUMBER_TABLE
502: , p5_a1 JTF_NUMBER_TABLE
503: , p5_a2 JTF_NUMBER_TABLE
504: , p5_a3 JTF_NUMBER_TABLE
505: , p5_a4 JTF_NUMBER_TABLE
506: , p5_a5 JTF_VARCHAR2_TABLE_100
507: , p5_a6 JTF_NUMBER_TABLE
508: , p5_a7 JTF_VARCHAR2_TABLE_100
501: , p5_a0 JTF_NUMBER_TABLE
502: , p5_a1 JTF_NUMBER_TABLE
503: , p5_a2 JTF_NUMBER_TABLE
504: , p5_a3 JTF_NUMBER_TABLE
505: , p5_a4 JTF_NUMBER_TABLE
506: , p5_a5 JTF_VARCHAR2_TABLE_100
507: , p5_a6 JTF_NUMBER_TABLE
508: , p5_a7 JTF_VARCHAR2_TABLE_100
509: , p5_a8 JTF_VARCHAR2_TABLE_100
503: , p5_a2 JTF_NUMBER_TABLE
504: , p5_a3 JTF_NUMBER_TABLE
505: , p5_a4 JTF_NUMBER_TABLE
506: , p5_a5 JTF_VARCHAR2_TABLE_100
507: , p5_a6 JTF_NUMBER_TABLE
508: , p5_a7 JTF_VARCHAR2_TABLE_100
509: , p5_a8 JTF_VARCHAR2_TABLE_100
510: , p5_a9 JTF_NUMBER_TABLE
511: , p5_a10 JTF_VARCHAR2_TABLE_2000
506: , p5_a5 JTF_VARCHAR2_TABLE_100
507: , p5_a6 JTF_NUMBER_TABLE
508: , p5_a7 JTF_VARCHAR2_TABLE_100
509: , p5_a8 JTF_VARCHAR2_TABLE_100
510: , p5_a9 JTF_NUMBER_TABLE
511: , p5_a10 JTF_VARCHAR2_TABLE_2000
512: , p5_a11 JTF_VARCHAR2_TABLE_100
513: , p5_a12 JTF_VARCHAR2_TABLE_300
514: , p5_a13 JTF_VARCHAR2_TABLE_500
528: , p5_a27 JTF_VARCHAR2_TABLE_500
529: , p5_a28 JTF_VARCHAR2_TABLE_500
530: , p5_a29 JTF_VARCHAR2_TABLE_500
531: , p5_a30 JTF_VARCHAR2_TABLE_100
532: , p5_a31 JTF_NUMBER_TABLE
533: , p5_a32 JTF_DATE_TABLE
534: , p5_a33 JTF_NUMBER_TABLE
535: , p5_a34 JTF_DATE_TABLE
536: , p5_a35 JTF_NUMBER_TABLE
530: , p5_a29 JTF_VARCHAR2_TABLE_500
531: , p5_a30 JTF_VARCHAR2_TABLE_100
532: , p5_a31 JTF_NUMBER_TABLE
533: , p5_a32 JTF_DATE_TABLE
534: , p5_a33 JTF_NUMBER_TABLE
535: , p5_a34 JTF_DATE_TABLE
536: , p5_a35 JTF_NUMBER_TABLE
537: , p6_a0 out nocopy JTF_NUMBER_TABLE
538: , p6_a1 out nocopy JTF_NUMBER_TABLE
532: , p5_a31 JTF_NUMBER_TABLE
533: , p5_a32 JTF_DATE_TABLE
534: , p5_a33 JTF_NUMBER_TABLE
535: , p5_a34 JTF_DATE_TABLE
536: , p5_a35 JTF_NUMBER_TABLE
537: , p6_a0 out nocopy JTF_NUMBER_TABLE
538: , p6_a1 out nocopy JTF_NUMBER_TABLE
539: , p6_a2 out nocopy JTF_NUMBER_TABLE
540: , p6_a3 out nocopy JTF_NUMBER_TABLE
533: , p5_a32 JTF_DATE_TABLE
534: , p5_a33 JTF_NUMBER_TABLE
535: , p5_a34 JTF_DATE_TABLE
536: , p5_a35 JTF_NUMBER_TABLE
537: , p6_a0 out nocopy JTF_NUMBER_TABLE
538: , p6_a1 out nocopy JTF_NUMBER_TABLE
539: , p6_a2 out nocopy JTF_NUMBER_TABLE
540: , p6_a3 out nocopy JTF_NUMBER_TABLE
541: , p6_a4 out nocopy JTF_NUMBER_TABLE
534: , p5_a33 JTF_NUMBER_TABLE
535: , p5_a34 JTF_DATE_TABLE
536: , p5_a35 JTF_NUMBER_TABLE
537: , p6_a0 out nocopy JTF_NUMBER_TABLE
538: , p6_a1 out nocopy JTF_NUMBER_TABLE
539: , p6_a2 out nocopy JTF_NUMBER_TABLE
540: , p6_a3 out nocopy JTF_NUMBER_TABLE
541: , p6_a4 out nocopy JTF_NUMBER_TABLE
542: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
535: , p5_a34 JTF_DATE_TABLE
536: , p5_a35 JTF_NUMBER_TABLE
537: , p6_a0 out nocopy JTF_NUMBER_TABLE
538: , p6_a1 out nocopy JTF_NUMBER_TABLE
539: , p6_a2 out nocopy JTF_NUMBER_TABLE
540: , p6_a3 out nocopy JTF_NUMBER_TABLE
541: , p6_a4 out nocopy JTF_NUMBER_TABLE
542: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
543: , p6_a6 out nocopy JTF_NUMBER_TABLE
536: , p5_a35 JTF_NUMBER_TABLE
537: , p6_a0 out nocopy JTF_NUMBER_TABLE
538: , p6_a1 out nocopy JTF_NUMBER_TABLE
539: , p6_a2 out nocopy JTF_NUMBER_TABLE
540: , p6_a3 out nocopy JTF_NUMBER_TABLE
541: , p6_a4 out nocopy JTF_NUMBER_TABLE
542: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
543: , p6_a6 out nocopy JTF_NUMBER_TABLE
544: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
537: , p6_a0 out nocopy JTF_NUMBER_TABLE
538: , p6_a1 out nocopy JTF_NUMBER_TABLE
539: , p6_a2 out nocopy JTF_NUMBER_TABLE
540: , p6_a3 out nocopy JTF_NUMBER_TABLE
541: , p6_a4 out nocopy JTF_NUMBER_TABLE
542: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
543: , p6_a6 out nocopy JTF_NUMBER_TABLE
544: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
545: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
539: , p6_a2 out nocopy JTF_NUMBER_TABLE
540: , p6_a3 out nocopy JTF_NUMBER_TABLE
541: , p6_a4 out nocopy JTF_NUMBER_TABLE
542: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
543: , p6_a6 out nocopy JTF_NUMBER_TABLE
544: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
545: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
546: , p6_a9 out nocopy JTF_NUMBER_TABLE
547: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
542: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
543: , p6_a6 out nocopy JTF_NUMBER_TABLE
544: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
545: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
546: , p6_a9 out nocopy JTF_NUMBER_TABLE
547: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
548: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
549: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
550: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
564: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
565: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
566: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
567: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a31 out nocopy JTF_NUMBER_TABLE
569: , p6_a32 out nocopy JTF_DATE_TABLE
570: , p6_a33 out nocopy JTF_NUMBER_TABLE
571: , p6_a34 out nocopy JTF_DATE_TABLE
572: , p6_a35 out nocopy JTF_NUMBER_TABLE
566: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
567: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a31 out nocopy JTF_NUMBER_TABLE
569: , p6_a32 out nocopy JTF_DATE_TABLE
570: , p6_a33 out nocopy JTF_NUMBER_TABLE
571: , p6_a34 out nocopy JTF_DATE_TABLE
572: , p6_a35 out nocopy JTF_NUMBER_TABLE
573: );
574: procedure delete_row(p_api_version NUMBER
568: , p6_a31 out nocopy JTF_NUMBER_TABLE
569: , p6_a32 out nocopy JTF_DATE_TABLE
570: , p6_a33 out nocopy JTF_NUMBER_TABLE
571: , p6_a34 out nocopy JTF_DATE_TABLE
572: , p6_a35 out nocopy JTF_NUMBER_TABLE
573: );
574: procedure delete_row(p_api_version NUMBER
575: , p_init_msg_list VARCHAR2
576: , x_return_status out nocopy VARCHAR2
617: , p_init_msg_list VARCHAR2
618: , x_return_status out nocopy VARCHAR2
619: , x_msg_count out nocopy NUMBER
620: , x_msg_data out nocopy VARCHAR2
621: , p5_a0 JTF_NUMBER_TABLE
622: , p5_a1 JTF_NUMBER_TABLE
623: , p5_a2 JTF_NUMBER_TABLE
624: , p5_a3 JTF_NUMBER_TABLE
625: , p5_a4 JTF_NUMBER_TABLE
618: , x_return_status out nocopy VARCHAR2
619: , x_msg_count out nocopy NUMBER
620: , x_msg_data out nocopy VARCHAR2
621: , p5_a0 JTF_NUMBER_TABLE
622: , p5_a1 JTF_NUMBER_TABLE
623: , p5_a2 JTF_NUMBER_TABLE
624: , p5_a3 JTF_NUMBER_TABLE
625: , p5_a4 JTF_NUMBER_TABLE
626: , p5_a5 JTF_VARCHAR2_TABLE_100
619: , x_msg_count out nocopy NUMBER
620: , x_msg_data out nocopy VARCHAR2
621: , p5_a0 JTF_NUMBER_TABLE
622: , p5_a1 JTF_NUMBER_TABLE
623: , p5_a2 JTF_NUMBER_TABLE
624: , p5_a3 JTF_NUMBER_TABLE
625: , p5_a4 JTF_NUMBER_TABLE
626: , p5_a5 JTF_VARCHAR2_TABLE_100
627: , p5_a6 JTF_NUMBER_TABLE
620: , x_msg_data out nocopy VARCHAR2
621: , p5_a0 JTF_NUMBER_TABLE
622: , p5_a1 JTF_NUMBER_TABLE
623: , p5_a2 JTF_NUMBER_TABLE
624: , p5_a3 JTF_NUMBER_TABLE
625: , p5_a4 JTF_NUMBER_TABLE
626: , p5_a5 JTF_VARCHAR2_TABLE_100
627: , p5_a6 JTF_NUMBER_TABLE
628: , p5_a7 JTF_VARCHAR2_TABLE_100
621: , p5_a0 JTF_NUMBER_TABLE
622: , p5_a1 JTF_NUMBER_TABLE
623: , p5_a2 JTF_NUMBER_TABLE
624: , p5_a3 JTF_NUMBER_TABLE
625: , p5_a4 JTF_NUMBER_TABLE
626: , p5_a5 JTF_VARCHAR2_TABLE_100
627: , p5_a6 JTF_NUMBER_TABLE
628: , p5_a7 JTF_VARCHAR2_TABLE_100
629: , p5_a8 JTF_VARCHAR2_TABLE_100
623: , p5_a2 JTF_NUMBER_TABLE
624: , p5_a3 JTF_NUMBER_TABLE
625: , p5_a4 JTF_NUMBER_TABLE
626: , p5_a5 JTF_VARCHAR2_TABLE_100
627: , p5_a6 JTF_NUMBER_TABLE
628: , p5_a7 JTF_VARCHAR2_TABLE_100
629: , p5_a8 JTF_VARCHAR2_TABLE_100
630: , p5_a9 JTF_NUMBER_TABLE
631: , p5_a10 JTF_VARCHAR2_TABLE_2000
626: , p5_a5 JTF_VARCHAR2_TABLE_100
627: , p5_a6 JTF_NUMBER_TABLE
628: , p5_a7 JTF_VARCHAR2_TABLE_100
629: , p5_a8 JTF_VARCHAR2_TABLE_100
630: , p5_a9 JTF_NUMBER_TABLE
631: , p5_a10 JTF_VARCHAR2_TABLE_2000
632: , p5_a11 JTF_VARCHAR2_TABLE_100
633: , p5_a12 JTF_VARCHAR2_TABLE_300
634: , p5_a13 JTF_VARCHAR2_TABLE_500
648: , p5_a27 JTF_VARCHAR2_TABLE_500
649: , p5_a28 JTF_VARCHAR2_TABLE_500
650: , p5_a29 JTF_VARCHAR2_TABLE_500
651: , p5_a30 JTF_VARCHAR2_TABLE_100
652: , p5_a31 JTF_NUMBER_TABLE
653: , p5_a32 JTF_DATE_TABLE
654: , p5_a33 JTF_NUMBER_TABLE
655: , p5_a34 JTF_DATE_TABLE
656: , p5_a35 JTF_NUMBER_TABLE
650: , p5_a29 JTF_VARCHAR2_TABLE_500
651: , p5_a30 JTF_VARCHAR2_TABLE_100
652: , p5_a31 JTF_NUMBER_TABLE
653: , p5_a32 JTF_DATE_TABLE
654: , p5_a33 JTF_NUMBER_TABLE
655: , p5_a34 JTF_DATE_TABLE
656: , p5_a35 JTF_NUMBER_TABLE
657: );
658: procedure validate_row(p_api_version NUMBER
652: , p5_a31 JTF_NUMBER_TABLE
653: , p5_a32 JTF_DATE_TABLE
654: , p5_a33 JTF_NUMBER_TABLE
655: , p5_a34 JTF_DATE_TABLE
656: , p5_a35 JTF_NUMBER_TABLE
657: );
658: procedure validate_row(p_api_version NUMBER
659: , p_init_msg_list VARCHAR2
660: , x_return_status out nocopy VARCHAR2
701: , p_init_msg_list VARCHAR2
702: , x_return_status out nocopy VARCHAR2
703: , x_msg_count out nocopy NUMBER
704: , x_msg_data out nocopy VARCHAR2
705: , p5_a0 JTF_NUMBER_TABLE
706: , p5_a1 JTF_NUMBER_TABLE
707: , p5_a2 JTF_NUMBER_TABLE
708: , p5_a3 JTF_NUMBER_TABLE
709: , p5_a4 JTF_NUMBER_TABLE
702: , x_return_status out nocopy VARCHAR2
703: , x_msg_count out nocopy NUMBER
704: , x_msg_data out nocopy VARCHAR2
705: , p5_a0 JTF_NUMBER_TABLE
706: , p5_a1 JTF_NUMBER_TABLE
707: , p5_a2 JTF_NUMBER_TABLE
708: , p5_a3 JTF_NUMBER_TABLE
709: , p5_a4 JTF_NUMBER_TABLE
710: , p5_a5 JTF_VARCHAR2_TABLE_100
703: , x_msg_count out nocopy NUMBER
704: , x_msg_data out nocopy VARCHAR2
705: , p5_a0 JTF_NUMBER_TABLE
706: , p5_a1 JTF_NUMBER_TABLE
707: , p5_a2 JTF_NUMBER_TABLE
708: , p5_a3 JTF_NUMBER_TABLE
709: , p5_a4 JTF_NUMBER_TABLE
710: , p5_a5 JTF_VARCHAR2_TABLE_100
711: , p5_a6 JTF_NUMBER_TABLE
704: , x_msg_data out nocopy VARCHAR2
705: , p5_a0 JTF_NUMBER_TABLE
706: , p5_a1 JTF_NUMBER_TABLE
707: , p5_a2 JTF_NUMBER_TABLE
708: , p5_a3 JTF_NUMBER_TABLE
709: , p5_a4 JTF_NUMBER_TABLE
710: , p5_a5 JTF_VARCHAR2_TABLE_100
711: , p5_a6 JTF_NUMBER_TABLE
712: , p5_a7 JTF_VARCHAR2_TABLE_100
705: , p5_a0 JTF_NUMBER_TABLE
706: , p5_a1 JTF_NUMBER_TABLE
707: , p5_a2 JTF_NUMBER_TABLE
708: , p5_a3 JTF_NUMBER_TABLE
709: , p5_a4 JTF_NUMBER_TABLE
710: , p5_a5 JTF_VARCHAR2_TABLE_100
711: , p5_a6 JTF_NUMBER_TABLE
712: , p5_a7 JTF_VARCHAR2_TABLE_100
713: , p5_a8 JTF_VARCHAR2_TABLE_100
707: , p5_a2 JTF_NUMBER_TABLE
708: , p5_a3 JTF_NUMBER_TABLE
709: , p5_a4 JTF_NUMBER_TABLE
710: , p5_a5 JTF_VARCHAR2_TABLE_100
711: , p5_a6 JTF_NUMBER_TABLE
712: , p5_a7 JTF_VARCHAR2_TABLE_100
713: , p5_a8 JTF_VARCHAR2_TABLE_100
714: , p5_a9 JTF_NUMBER_TABLE
715: , p5_a10 JTF_VARCHAR2_TABLE_2000
710: , p5_a5 JTF_VARCHAR2_TABLE_100
711: , p5_a6 JTF_NUMBER_TABLE
712: , p5_a7 JTF_VARCHAR2_TABLE_100
713: , p5_a8 JTF_VARCHAR2_TABLE_100
714: , p5_a9 JTF_NUMBER_TABLE
715: , p5_a10 JTF_VARCHAR2_TABLE_2000
716: , p5_a11 JTF_VARCHAR2_TABLE_100
717: , p5_a12 JTF_VARCHAR2_TABLE_300
718: , p5_a13 JTF_VARCHAR2_TABLE_500
732: , p5_a27 JTF_VARCHAR2_TABLE_500
733: , p5_a28 JTF_VARCHAR2_TABLE_500
734: , p5_a29 JTF_VARCHAR2_TABLE_500
735: , p5_a30 JTF_VARCHAR2_TABLE_100
736: , p5_a31 JTF_NUMBER_TABLE
737: , p5_a32 JTF_DATE_TABLE
738: , p5_a33 JTF_NUMBER_TABLE
739: , p5_a34 JTF_DATE_TABLE
740: , p5_a35 JTF_NUMBER_TABLE
734: , p5_a29 JTF_VARCHAR2_TABLE_500
735: , p5_a30 JTF_VARCHAR2_TABLE_100
736: , p5_a31 JTF_NUMBER_TABLE
737: , p5_a32 JTF_DATE_TABLE
738: , p5_a33 JTF_NUMBER_TABLE
739: , p5_a34 JTF_DATE_TABLE
740: , p5_a35 JTF_NUMBER_TABLE
741: );
742: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
736: , p5_a31 JTF_NUMBER_TABLE
737: , p5_a32 JTF_DATE_TABLE
738: , p5_a33 JTF_NUMBER_TABLE
739: , p5_a34 JTF_DATE_TABLE
740: , p5_a35 JTF_NUMBER_TABLE
741: );
742: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
743: , p0_a1 JTF_NUMBER_TABLE
744: , p0_a2 JTF_NUMBER_TABLE
738: , p5_a33 JTF_NUMBER_TABLE
739: , p5_a34 JTF_DATE_TABLE
740: , p5_a35 JTF_NUMBER_TABLE
741: );
742: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
743: , p0_a1 JTF_NUMBER_TABLE
744: , p0_a2 JTF_NUMBER_TABLE
745: , p0_a3 JTF_NUMBER_TABLE
746: , p0_a4 JTF_NUMBER_TABLE
739: , p5_a34 JTF_DATE_TABLE
740: , p5_a35 JTF_NUMBER_TABLE
741: );
742: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
743: , p0_a1 JTF_NUMBER_TABLE
744: , p0_a2 JTF_NUMBER_TABLE
745: , p0_a3 JTF_NUMBER_TABLE
746: , p0_a4 JTF_NUMBER_TABLE
747: , p0_a5 JTF_VARCHAR2_TABLE_100
740: , p5_a35 JTF_NUMBER_TABLE
741: );
742: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
743: , p0_a1 JTF_NUMBER_TABLE
744: , p0_a2 JTF_NUMBER_TABLE
745: , p0_a3 JTF_NUMBER_TABLE
746: , p0_a4 JTF_NUMBER_TABLE
747: , p0_a5 JTF_VARCHAR2_TABLE_100
748: , p0_a6 JTF_NUMBER_TABLE
741: );
742: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
743: , p0_a1 JTF_NUMBER_TABLE
744: , p0_a2 JTF_NUMBER_TABLE
745: , p0_a3 JTF_NUMBER_TABLE
746: , p0_a4 JTF_NUMBER_TABLE
747: , p0_a5 JTF_VARCHAR2_TABLE_100
748: , p0_a6 JTF_NUMBER_TABLE
749: , p0_a7 JTF_VARCHAR2_TABLE_100
742: procedure insert_row_upg(p0_a0 JTF_NUMBER_TABLE
743: , p0_a1 JTF_NUMBER_TABLE
744: , p0_a2 JTF_NUMBER_TABLE
745: , p0_a3 JTF_NUMBER_TABLE
746: , p0_a4 JTF_NUMBER_TABLE
747: , p0_a5 JTF_VARCHAR2_TABLE_100
748: , p0_a6 JTF_NUMBER_TABLE
749: , p0_a7 JTF_VARCHAR2_TABLE_100
750: , p0_a8 JTF_VARCHAR2_TABLE_100
744: , p0_a2 JTF_NUMBER_TABLE
745: , p0_a3 JTF_NUMBER_TABLE
746: , p0_a4 JTF_NUMBER_TABLE
747: , p0_a5 JTF_VARCHAR2_TABLE_100
748: , p0_a6 JTF_NUMBER_TABLE
749: , p0_a7 JTF_VARCHAR2_TABLE_100
750: , p0_a8 JTF_VARCHAR2_TABLE_100
751: , p0_a9 JTF_NUMBER_TABLE
752: , p0_a10 JTF_VARCHAR2_TABLE_2000
747: , p0_a5 JTF_VARCHAR2_TABLE_100
748: , p0_a6 JTF_NUMBER_TABLE
749: , p0_a7 JTF_VARCHAR2_TABLE_100
750: , p0_a8 JTF_VARCHAR2_TABLE_100
751: , p0_a9 JTF_NUMBER_TABLE
752: , p0_a10 JTF_VARCHAR2_TABLE_2000
753: , p0_a11 JTF_VARCHAR2_TABLE_100
754: , p0_a12 JTF_VARCHAR2_TABLE_300
755: , p0_a13 JTF_VARCHAR2_TABLE_500
769: , p0_a27 JTF_VARCHAR2_TABLE_500
770: , p0_a28 JTF_VARCHAR2_TABLE_500
771: , p0_a29 JTF_VARCHAR2_TABLE_500
772: , p0_a30 JTF_VARCHAR2_TABLE_100
773: , p0_a31 JTF_NUMBER_TABLE
774: , p0_a32 JTF_DATE_TABLE
775: , p0_a33 JTF_NUMBER_TABLE
776: , p0_a34 JTF_DATE_TABLE
777: , p0_a35 JTF_NUMBER_TABLE
771: , p0_a29 JTF_VARCHAR2_TABLE_500
772: , p0_a30 JTF_VARCHAR2_TABLE_100
773: , p0_a31 JTF_NUMBER_TABLE
774: , p0_a32 JTF_DATE_TABLE
775: , p0_a33 JTF_NUMBER_TABLE
776: , p0_a34 JTF_DATE_TABLE
777: , p0_a35 JTF_NUMBER_TABLE
778: );
779: end okl_vp_cat_pvt_w;
773: , p0_a31 JTF_NUMBER_TABLE
774: , p0_a32 JTF_DATE_TABLE
775: , p0_a33 JTF_NUMBER_TABLE
776: , p0_a34 JTF_DATE_TABLE
777: , p0_a35 JTF_NUMBER_TABLE
778: );
779: end okl_vp_cat_pvt_w;