87: , p6_a24 out nocopy JTF_NUMBER_TABLE
88: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a0 NUMBER := 0-1962.0724
90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 DATE := fnd_api.g_miss_date
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
88: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
89: , p5_a0 NUMBER := 0-1962.0724
90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 DATE := fnd_api.g_miss_date
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 DATE := fnd_api.g_miss_date
90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 DATE := fnd_api.g_miss_date
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 DATE := fnd_api.g_miss_date
97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 DATE := fnd_api.g_miss_date
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 DATE := fnd_api.g_miss_date
97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 NUMBER := 0-1962.0724
92: , p5_a3 DATE := fnd_api.g_miss_date
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 DATE := fnd_api.g_miss_date
97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 NUMBER := 0-1962.0724
100: , p5_a11 NUMBER := 0-1962.0724
93: , p5_a4 NUMBER := 0-1962.0724
94: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 DATE := fnd_api.g_miss_date
97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 NUMBER := 0-1962.0724
100: , p5_a11 NUMBER := 0-1962.0724
101: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 NUMBER := 0-1962.0724
100: , p5_a11 NUMBER := 0-1962.0724
101: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a13 DATE := fnd_api.g_miss_date
103: , p5_a14 NUMBER := 0-1962.0724
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 NUMBER := 0-1962.0724
100: , p5_a11 NUMBER := 0-1962.0724
101: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a13 DATE := fnd_api.g_miss_date
103: , p5_a14 NUMBER := 0-1962.0724
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a13 DATE := fnd_api.g_miss_date
103: , p5_a14 NUMBER := 0-1962.0724
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a13 DATE := fnd_api.g_miss_date
103: , p5_a14 NUMBER := 0-1962.0724
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a14 NUMBER := 0-1962.0724
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
104: , p5_a15 NUMBER := 0-1962.0724
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
105: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
113: , p5_a24 NUMBER := 0-1962.0724
106: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
113: , p5_a24 NUMBER := 0-1962.0724
114: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
113: , p5_a24 NUMBER := 0-1962.0724
114: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
115: );
108: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
113: , p5_a24 NUMBER := 0-1962.0724
114: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
115: );
116: procedure update_period_status(p_api_version NUMBER
110: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a22 DATE := fnd_api.g_miss_date
112: , p5_a23 DATE := fnd_api.g_miss_date
113: , p5_a24 NUMBER := 0-1962.0724
114: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
115: );
116: procedure update_period_status(p_api_version NUMBER
117: , p_init_msg_list VARCHAR2
118: , x_return_status out nocopy VARCHAR2
151: , x_msg_count out nocopy NUMBER
152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 NUMBER := 0-1962.0724
154: , p5_a1 NUMBER := 0-1962.0724
155: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a3 DATE := fnd_api.g_miss_date
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 NUMBER := 0-1962.0724
154: , p5_a1 NUMBER := 0-1962.0724
155: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a3 DATE := fnd_api.g_miss_date
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
160: , p5_a7 DATE := fnd_api.g_miss_date
154: , p5_a1 NUMBER := 0-1962.0724
155: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a3 DATE := fnd_api.g_miss_date
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
160: , p5_a7 DATE := fnd_api.g_miss_date
161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724
155: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a3 DATE := fnd_api.g_miss_date
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
160: , p5_a7 DATE := fnd_api.g_miss_date
161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724
163: , p5_a10 NUMBER := 0-1962.0724
156: , p5_a3 DATE := fnd_api.g_miss_date
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
160: , p5_a7 DATE := fnd_api.g_miss_date
161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724
163: , p5_a10 NUMBER := 0-1962.0724
164: , p5_a11 NUMBER := 0-1962.0724
157: , p5_a4 NUMBER := 0-1962.0724
158: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a6 DATE := fnd_api.g_miss_date
160: , p5_a7 DATE := fnd_api.g_miss_date
161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724
163: , p5_a10 NUMBER := 0-1962.0724
164: , p5_a11 NUMBER := 0-1962.0724
165: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724
163: , p5_a10 NUMBER := 0-1962.0724
164: , p5_a11 NUMBER := 0-1962.0724
165: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a13 DATE := fnd_api.g_miss_date
167: , p5_a14 NUMBER := 0-1962.0724
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a9 NUMBER := 0-1962.0724
163: , p5_a10 NUMBER := 0-1962.0724
164: , p5_a11 NUMBER := 0-1962.0724
165: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a13 DATE := fnd_api.g_miss_date
167: , p5_a14 NUMBER := 0-1962.0724
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a13 DATE := fnd_api.g_miss_date
167: , p5_a14 NUMBER := 0-1962.0724
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a13 DATE := fnd_api.g_miss_date
167: , p5_a14 NUMBER := 0-1962.0724
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
167: , p5_a14 NUMBER := 0-1962.0724
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
168: , p5_a15 NUMBER := 0-1962.0724
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
169: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
177: , p5_a24 NUMBER := 0-1962.0724
170: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
177: , p5_a24 NUMBER := 0-1962.0724
178: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
171: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
177: , p5_a24 NUMBER := 0-1962.0724
178: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
179: );
172: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
173: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
177: , p5_a24 NUMBER := 0-1962.0724
178: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
179: );
180: end okl_perd_status_pvt_w;
174: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a22 DATE := fnd_api.g_miss_date
176: , p5_a23 DATE := fnd_api.g_miss_date
177: , p5_a24 NUMBER := 0-1962.0724
178: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
179: );
180: end okl_perd_status_pvt_w;