18: , p5_a10 DATE
19: , p5_a11 NUMBER
20: , p5_a12 DATE
21: , p5_a13 NUMBER
22: , p6_a0 JTF_NUMBER_TABLE
23: , p6_a1 JTF_NUMBER_TABLE
24: , p6_a2 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
19: , p5_a11 NUMBER
20: , p5_a12 DATE
21: , p5_a13 NUMBER
22: , p6_a0 JTF_NUMBER_TABLE
23: , p6_a1 JTF_NUMBER_TABLE
24: , p6_a2 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
20: , p5_a12 DATE
21: , p5_a13 NUMBER
22: , p6_a0 JTF_NUMBER_TABLE
23: , p6_a1 JTF_NUMBER_TABLE
24: , p6_a2 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
21: , p5_a13 NUMBER
22: , p6_a0 JTF_NUMBER_TABLE
23: , p6_a1 JTF_NUMBER_TABLE
24: , p6_a2 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
23: , p6_a1 JTF_NUMBER_TABLE
24: , p6_a2 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
32: , p6_a10 JTF_NUMBER_TABLE
33: , p6_a11 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
32: , p6_a10 JTF_NUMBER_TABLE
33: , p6_a11 JTF_NUMBER_TABLE
34: , p7_a0 out nocopy NUMBER
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
32: , p6_a10 JTF_NUMBER_TABLE
33: , p6_a11 JTF_NUMBER_TABLE
34: , p7_a0 out nocopy NUMBER
35: , p7_a1 out nocopy NUMBER
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
32: , p6_a10 JTF_NUMBER_TABLE
33: , p6_a11 JTF_NUMBER_TABLE
34: , p7_a0 out nocopy NUMBER
35: , p7_a1 out nocopy NUMBER
36: , p7_a2 out nocopy NUMBER
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
32: , p6_a10 JTF_NUMBER_TABLE
33: , p6_a11 JTF_NUMBER_TABLE
34: , p7_a0 out nocopy NUMBER
35: , p7_a1 out nocopy NUMBER
36: , p7_a2 out nocopy NUMBER
37: , p7_a3 out nocopy NUMBER
44: , p7_a10 out nocopy DATE
45: , p7_a11 out nocopy NUMBER
46: , p7_a12 out nocopy DATE
47: , p7_a13 out nocopy NUMBER
48: , p8_a0 out nocopy JTF_NUMBER_TABLE
49: , p8_a1 out nocopy JTF_NUMBER_TABLE
50: , p8_a2 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
45: , p7_a11 out nocopy NUMBER
46: , p7_a12 out nocopy DATE
47: , p7_a13 out nocopy NUMBER
48: , p8_a0 out nocopy JTF_NUMBER_TABLE
49: , p8_a1 out nocopy JTF_NUMBER_TABLE
50: , p8_a2 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
46: , p7_a12 out nocopy DATE
47: , p7_a13 out nocopy NUMBER
48: , p8_a0 out nocopy JTF_NUMBER_TABLE
49: , p8_a1 out nocopy JTF_NUMBER_TABLE
50: , p8_a2 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
47: , p7_a13 out nocopy NUMBER
48: , p8_a0 out nocopy JTF_NUMBER_TABLE
49: , p8_a1 out nocopy JTF_NUMBER_TABLE
50: , p8_a2 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
49: , p8_a1 out nocopy JTF_NUMBER_TABLE
50: , p8_a2 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
58: , p8_a10 out nocopy JTF_NUMBER_TABLE
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
58: , p8_a10 out nocopy JTF_NUMBER_TABLE
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
60: );
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
58: , p8_a10 out nocopy JTF_NUMBER_TABLE
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
60: );
61: procedure update_rcs(p_api_version NUMBER
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
58: , p8_a10 out nocopy JTF_NUMBER_TABLE
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
60: );
61: procedure update_rcs(p_api_version NUMBER
62: , p_init_msg_list VARCHAR2
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
58: , p8_a10 out nocopy JTF_NUMBER_TABLE
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
60: );
61: procedure update_rcs(p_api_version NUMBER
62: , p_init_msg_list VARCHAR2
63: , x_return_status out nocopy VARCHAR2
76: , p5_a10 DATE
77: , p5_a11 NUMBER
78: , p5_a12 DATE
79: , p5_a13 NUMBER
80: , p6_a0 JTF_NUMBER_TABLE
81: , p6_a1 JTF_NUMBER_TABLE
82: , p6_a2 JTF_NUMBER_TABLE
83: , p6_a3 JTF_NUMBER_TABLE
84: , p6_a4 JTF_DATE_TABLE
77: , p5_a11 NUMBER
78: , p5_a12 DATE
79: , p5_a13 NUMBER
80: , p6_a0 JTF_NUMBER_TABLE
81: , p6_a1 JTF_NUMBER_TABLE
82: , p6_a2 JTF_NUMBER_TABLE
83: , p6_a3 JTF_NUMBER_TABLE
84: , p6_a4 JTF_DATE_TABLE
85: , p6_a5 JTF_NUMBER_TABLE
78: , p5_a12 DATE
79: , p5_a13 NUMBER
80: , p6_a0 JTF_NUMBER_TABLE
81: , p6_a1 JTF_NUMBER_TABLE
82: , p6_a2 JTF_NUMBER_TABLE
83: , p6_a3 JTF_NUMBER_TABLE
84: , p6_a4 JTF_DATE_TABLE
85: , p6_a5 JTF_NUMBER_TABLE
86: , p6_a6 JTF_DATE_TABLE
79: , p5_a13 NUMBER
80: , p6_a0 JTF_NUMBER_TABLE
81: , p6_a1 JTF_NUMBER_TABLE
82: , p6_a2 JTF_NUMBER_TABLE
83: , p6_a3 JTF_NUMBER_TABLE
84: , p6_a4 JTF_DATE_TABLE
85: , p6_a5 JTF_NUMBER_TABLE
86: , p6_a6 JTF_DATE_TABLE
87: , p6_a7 JTF_NUMBER_TABLE
81: , p6_a1 JTF_NUMBER_TABLE
82: , p6_a2 JTF_NUMBER_TABLE
83: , p6_a3 JTF_NUMBER_TABLE
84: , p6_a4 JTF_DATE_TABLE
85: , p6_a5 JTF_NUMBER_TABLE
86: , p6_a6 JTF_DATE_TABLE
87: , p6_a7 JTF_NUMBER_TABLE
88: , p6_a8 JTF_NUMBER_TABLE
89: , p6_a9 JTF_NUMBER_TABLE
83: , p6_a3 JTF_NUMBER_TABLE
84: , p6_a4 JTF_DATE_TABLE
85: , p6_a5 JTF_NUMBER_TABLE
86: , p6_a6 JTF_DATE_TABLE
87: , p6_a7 JTF_NUMBER_TABLE
88: , p6_a8 JTF_NUMBER_TABLE
89: , p6_a9 JTF_NUMBER_TABLE
90: , p6_a10 JTF_NUMBER_TABLE
91: , p6_a11 JTF_NUMBER_TABLE
84: , p6_a4 JTF_DATE_TABLE
85: , p6_a5 JTF_NUMBER_TABLE
86: , p6_a6 JTF_DATE_TABLE
87: , p6_a7 JTF_NUMBER_TABLE
88: , p6_a8 JTF_NUMBER_TABLE
89: , p6_a9 JTF_NUMBER_TABLE
90: , p6_a10 JTF_NUMBER_TABLE
91: , p6_a11 JTF_NUMBER_TABLE
92: , p7_a0 out nocopy NUMBER
85: , p6_a5 JTF_NUMBER_TABLE
86: , p6_a6 JTF_DATE_TABLE
87: , p6_a7 JTF_NUMBER_TABLE
88: , p6_a8 JTF_NUMBER_TABLE
89: , p6_a9 JTF_NUMBER_TABLE
90: , p6_a10 JTF_NUMBER_TABLE
91: , p6_a11 JTF_NUMBER_TABLE
92: , p7_a0 out nocopy NUMBER
93: , p7_a1 out nocopy NUMBER
86: , p6_a6 JTF_DATE_TABLE
87: , p6_a7 JTF_NUMBER_TABLE
88: , p6_a8 JTF_NUMBER_TABLE
89: , p6_a9 JTF_NUMBER_TABLE
90: , p6_a10 JTF_NUMBER_TABLE
91: , p6_a11 JTF_NUMBER_TABLE
92: , p7_a0 out nocopy NUMBER
93: , p7_a1 out nocopy NUMBER
94: , p7_a2 out nocopy NUMBER
87: , p6_a7 JTF_NUMBER_TABLE
88: , p6_a8 JTF_NUMBER_TABLE
89: , p6_a9 JTF_NUMBER_TABLE
90: , p6_a10 JTF_NUMBER_TABLE
91: , p6_a11 JTF_NUMBER_TABLE
92: , p7_a0 out nocopy NUMBER
93: , p7_a1 out nocopy NUMBER
94: , p7_a2 out nocopy NUMBER
95: , p7_a3 out nocopy NUMBER
122: , p5_a10 DATE
123: , p5_a11 NUMBER
124: , p5_a12 DATE
125: , p5_a13 NUMBER
126: , p6_a0 JTF_NUMBER_TABLE
127: , p6_a1 JTF_NUMBER_TABLE
128: , p6_a2 JTF_NUMBER_TABLE
129: , p6_a3 JTF_NUMBER_TABLE
130: , p6_a4 JTF_DATE_TABLE
123: , p5_a11 NUMBER
124: , p5_a12 DATE
125: , p5_a13 NUMBER
126: , p6_a0 JTF_NUMBER_TABLE
127: , p6_a1 JTF_NUMBER_TABLE
128: , p6_a2 JTF_NUMBER_TABLE
129: , p6_a3 JTF_NUMBER_TABLE
130: , p6_a4 JTF_DATE_TABLE
131: , p6_a5 JTF_NUMBER_TABLE
124: , p5_a12 DATE
125: , p5_a13 NUMBER
126: , p6_a0 JTF_NUMBER_TABLE
127: , p6_a1 JTF_NUMBER_TABLE
128: , p6_a2 JTF_NUMBER_TABLE
129: , p6_a3 JTF_NUMBER_TABLE
130: , p6_a4 JTF_DATE_TABLE
131: , p6_a5 JTF_NUMBER_TABLE
132: , p6_a6 JTF_DATE_TABLE
125: , p5_a13 NUMBER
126: , p6_a0 JTF_NUMBER_TABLE
127: , p6_a1 JTF_NUMBER_TABLE
128: , p6_a2 JTF_NUMBER_TABLE
129: , p6_a3 JTF_NUMBER_TABLE
130: , p6_a4 JTF_DATE_TABLE
131: , p6_a5 JTF_NUMBER_TABLE
132: , p6_a6 JTF_DATE_TABLE
133: , p6_a7 JTF_NUMBER_TABLE
127: , p6_a1 JTF_NUMBER_TABLE
128: , p6_a2 JTF_NUMBER_TABLE
129: , p6_a3 JTF_NUMBER_TABLE
130: , p6_a4 JTF_DATE_TABLE
131: , p6_a5 JTF_NUMBER_TABLE
132: , p6_a6 JTF_DATE_TABLE
133: , p6_a7 JTF_NUMBER_TABLE
134: , p6_a8 JTF_NUMBER_TABLE
135: , p6_a9 JTF_NUMBER_TABLE
129: , p6_a3 JTF_NUMBER_TABLE
130: , p6_a4 JTF_DATE_TABLE
131: , p6_a5 JTF_NUMBER_TABLE
132: , p6_a6 JTF_DATE_TABLE
133: , p6_a7 JTF_NUMBER_TABLE
134: , p6_a8 JTF_NUMBER_TABLE
135: , p6_a9 JTF_NUMBER_TABLE
136: , p6_a10 JTF_NUMBER_TABLE
137: , p6_a11 JTF_NUMBER_TABLE
130: , p6_a4 JTF_DATE_TABLE
131: , p6_a5 JTF_NUMBER_TABLE
132: , p6_a6 JTF_DATE_TABLE
133: , p6_a7 JTF_NUMBER_TABLE
134: , p6_a8 JTF_NUMBER_TABLE
135: , p6_a9 JTF_NUMBER_TABLE
136: , p6_a10 JTF_NUMBER_TABLE
137: , p6_a11 JTF_NUMBER_TABLE
138: , p7_a0 out nocopy NUMBER
131: , p6_a5 JTF_NUMBER_TABLE
132: , p6_a6 JTF_DATE_TABLE
133: , p6_a7 JTF_NUMBER_TABLE
134: , p6_a8 JTF_NUMBER_TABLE
135: , p6_a9 JTF_NUMBER_TABLE
136: , p6_a10 JTF_NUMBER_TABLE
137: , p6_a11 JTF_NUMBER_TABLE
138: , p7_a0 out nocopy NUMBER
139: , p7_a1 out nocopy NUMBER
132: , p6_a6 JTF_DATE_TABLE
133: , p6_a7 JTF_NUMBER_TABLE
134: , p6_a8 JTF_NUMBER_TABLE
135: , p6_a9 JTF_NUMBER_TABLE
136: , p6_a10 JTF_NUMBER_TABLE
137: , p6_a11 JTF_NUMBER_TABLE
138: , p7_a0 out nocopy NUMBER
139: , p7_a1 out nocopy NUMBER
140: , p7_a2 out nocopy NUMBER
133: , p6_a7 JTF_NUMBER_TABLE
134: , p6_a8 JTF_NUMBER_TABLE
135: , p6_a9 JTF_NUMBER_TABLE
136: , p6_a10 JTF_NUMBER_TABLE
137: , p6_a11 JTF_NUMBER_TABLE
138: , p7_a0 out nocopy NUMBER
139: , p7_a1 out nocopy NUMBER
140: , p7_a2 out nocopy NUMBER
141: , p7_a3 out nocopy NUMBER
154: , p_init_msg_list VARCHAR2
155: , x_return_status out nocopy VARCHAR2
156: , x_msg_count out nocopy NUMBER
157: , x_msg_data out nocopy VARCHAR2
158: , p5_a0 JTF_NUMBER_TABLE
159: , p5_a1 JTF_NUMBER_TABLE
160: , p5_a2 JTF_NUMBER_TABLE
161: , p5_a3 JTF_NUMBER_TABLE
162: , p5_a4 JTF_DATE_TABLE
155: , x_return_status out nocopy VARCHAR2
156: , x_msg_count out nocopy NUMBER
157: , x_msg_data out nocopy VARCHAR2
158: , p5_a0 JTF_NUMBER_TABLE
159: , p5_a1 JTF_NUMBER_TABLE
160: , p5_a2 JTF_NUMBER_TABLE
161: , p5_a3 JTF_NUMBER_TABLE
162: , p5_a4 JTF_DATE_TABLE
163: , p5_a5 JTF_NUMBER_TABLE
156: , x_msg_count out nocopy NUMBER
157: , x_msg_data out nocopy VARCHAR2
158: , p5_a0 JTF_NUMBER_TABLE
159: , p5_a1 JTF_NUMBER_TABLE
160: , p5_a2 JTF_NUMBER_TABLE
161: , p5_a3 JTF_NUMBER_TABLE
162: , p5_a4 JTF_DATE_TABLE
163: , p5_a5 JTF_NUMBER_TABLE
164: , p5_a6 JTF_DATE_TABLE
157: , x_msg_data out nocopy VARCHAR2
158: , p5_a0 JTF_NUMBER_TABLE
159: , p5_a1 JTF_NUMBER_TABLE
160: , p5_a2 JTF_NUMBER_TABLE
161: , p5_a3 JTF_NUMBER_TABLE
162: , p5_a4 JTF_DATE_TABLE
163: , p5_a5 JTF_NUMBER_TABLE
164: , p5_a6 JTF_DATE_TABLE
165: , p5_a7 JTF_NUMBER_TABLE
159: , p5_a1 JTF_NUMBER_TABLE
160: , p5_a2 JTF_NUMBER_TABLE
161: , p5_a3 JTF_NUMBER_TABLE
162: , p5_a4 JTF_DATE_TABLE
163: , p5_a5 JTF_NUMBER_TABLE
164: , p5_a6 JTF_DATE_TABLE
165: , p5_a7 JTF_NUMBER_TABLE
166: , p5_a8 JTF_NUMBER_TABLE
167: , p5_a9 JTF_NUMBER_TABLE
161: , p5_a3 JTF_NUMBER_TABLE
162: , p5_a4 JTF_DATE_TABLE
163: , p5_a5 JTF_NUMBER_TABLE
164: , p5_a6 JTF_DATE_TABLE
165: , p5_a7 JTF_NUMBER_TABLE
166: , p5_a8 JTF_NUMBER_TABLE
167: , p5_a9 JTF_NUMBER_TABLE
168: , p5_a10 JTF_NUMBER_TABLE
169: , p5_a11 JTF_NUMBER_TABLE
162: , p5_a4 JTF_DATE_TABLE
163: , p5_a5 JTF_NUMBER_TABLE
164: , p5_a6 JTF_DATE_TABLE
165: , p5_a7 JTF_NUMBER_TABLE
166: , p5_a8 JTF_NUMBER_TABLE
167: , p5_a9 JTF_NUMBER_TABLE
168: , p5_a10 JTF_NUMBER_TABLE
169: , p5_a11 JTF_NUMBER_TABLE
170: );
163: , p5_a5 JTF_NUMBER_TABLE
164: , p5_a6 JTF_DATE_TABLE
165: , p5_a7 JTF_NUMBER_TABLE
166: , p5_a8 JTF_NUMBER_TABLE
167: , p5_a9 JTF_NUMBER_TABLE
168: , p5_a10 JTF_NUMBER_TABLE
169: , p5_a11 JTF_NUMBER_TABLE
170: );
171: end okl_resi_cat_sets_pvt_w;
164: , p5_a6 JTF_DATE_TABLE
165: , p5_a7 JTF_NUMBER_TABLE
166: , p5_a8 JTF_NUMBER_TABLE
167: , p5_a9 JTF_NUMBER_TABLE
168: , p5_a10 JTF_NUMBER_TABLE
169: , p5_a11 JTF_NUMBER_TABLE
170: );
171: end okl_resi_cat_sets_pvt_w;
165: , p5_a7 JTF_NUMBER_TABLE
166: , p5_a8 JTF_NUMBER_TABLE
167: , p5_a9 JTF_NUMBER_TABLE
168: , p5_a10 JTF_NUMBER_TABLE
169: , p5_a11 JTF_NUMBER_TABLE
170: );
171: end okl_resi_cat_sets_pvt_w;