APPS.OKL_SETUPFMACONSTRAINTS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 152: , p5_a0 JTF_NUMBER_TABLE

148: , p_init_msg_list VARCHAR2
149: , x_return_status out nocopy VARCHAR2
150: , x_msg_count out nocopy NUMBER
151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_VARCHAR2_TABLE_800

Line 153: , p5_a1 JTF_NUMBER_TABLE

149: , x_return_status out nocopy VARCHAR2
150: , x_msg_count out nocopy NUMBER
151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_VARCHAR2_TABLE_800
157: , p5_a5 JTF_NUMBER_TABLE

Line 154: , p5_a2 JTF_NUMBER_TABLE

150: , x_msg_count out nocopy NUMBER
151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_VARCHAR2_TABLE_800
157: , p5_a5 JTF_NUMBER_TABLE
158: , p5_a6 JTF_DATE_TABLE

Line 155: , p5_a3 JTF_NUMBER_TABLE

151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_VARCHAR2_TABLE_800
157: , p5_a5 JTF_NUMBER_TABLE
158: , p5_a6 JTF_DATE_TABLE
159: , p5_a7 JTF_NUMBER_TABLE

Line 157: , p5_a5 JTF_NUMBER_TABLE

153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_VARCHAR2_TABLE_800
157: , p5_a5 JTF_NUMBER_TABLE
158: , p5_a6 JTF_DATE_TABLE
159: , p5_a7 JTF_NUMBER_TABLE
160: , p5_a8 JTF_DATE_TABLE
161: , p5_a9 JTF_NUMBER_TABLE

Line 159: , p5_a7 JTF_NUMBER_TABLE

155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_VARCHAR2_TABLE_800
157: , p5_a5 JTF_NUMBER_TABLE
158: , p5_a6 JTF_DATE_TABLE
159: , p5_a7 JTF_NUMBER_TABLE
160: , p5_a8 JTF_DATE_TABLE
161: , p5_a9 JTF_NUMBER_TABLE
162: );
163: procedure insert_fmaconstraints(p_api_version NUMBER

Line 161: , p5_a9 JTF_NUMBER_TABLE

157: , p5_a5 JTF_NUMBER_TABLE
158: , p5_a6 JTF_DATE_TABLE
159: , p5_a7 JTF_NUMBER_TABLE
160: , p5_a8 JTF_DATE_TABLE
161: , p5_a9 JTF_NUMBER_TABLE
162: );
163: procedure insert_fmaconstraints(p_api_version NUMBER
164: , p_init_msg_list VARCHAR2
165: , x_return_status out nocopy VARCHAR2

Line 168: , p6_a0 JTF_NUMBER_TABLE

164: , p_init_msg_list VARCHAR2
165: , x_return_status out nocopy VARCHAR2
166: , x_msg_count out nocopy NUMBER
167: , x_msg_data out nocopy VARCHAR2
168: , p6_a0 JTF_NUMBER_TABLE
169: , p6_a1 JTF_NUMBER_TABLE
170: , p6_a2 JTF_NUMBER_TABLE
171: , p6_a3 JTF_NUMBER_TABLE
172: , p6_a4 JTF_VARCHAR2_TABLE_800

Line 169: , p6_a1 JTF_NUMBER_TABLE

165: , x_return_status out nocopy VARCHAR2
166: , x_msg_count out nocopy NUMBER
167: , x_msg_data out nocopy VARCHAR2
168: , p6_a0 JTF_NUMBER_TABLE
169: , p6_a1 JTF_NUMBER_TABLE
170: , p6_a2 JTF_NUMBER_TABLE
171: , p6_a3 JTF_NUMBER_TABLE
172: , p6_a4 JTF_VARCHAR2_TABLE_800
173: , p6_a5 JTF_NUMBER_TABLE

Line 170: , p6_a2 JTF_NUMBER_TABLE

166: , x_msg_count out nocopy NUMBER
167: , x_msg_data out nocopy VARCHAR2
168: , p6_a0 JTF_NUMBER_TABLE
169: , p6_a1 JTF_NUMBER_TABLE
170: , p6_a2 JTF_NUMBER_TABLE
171: , p6_a3 JTF_NUMBER_TABLE
172: , p6_a4 JTF_VARCHAR2_TABLE_800
173: , p6_a5 JTF_NUMBER_TABLE
174: , p6_a6 JTF_DATE_TABLE

Line 171: , p6_a3 JTF_NUMBER_TABLE

167: , x_msg_data out nocopy VARCHAR2
168: , p6_a0 JTF_NUMBER_TABLE
169: , p6_a1 JTF_NUMBER_TABLE
170: , p6_a2 JTF_NUMBER_TABLE
171: , p6_a3 JTF_NUMBER_TABLE
172: , p6_a4 JTF_VARCHAR2_TABLE_800
173: , p6_a5 JTF_NUMBER_TABLE
174: , p6_a6 JTF_DATE_TABLE
175: , p6_a7 JTF_NUMBER_TABLE

Line 173: , p6_a5 JTF_NUMBER_TABLE

169: , p6_a1 JTF_NUMBER_TABLE
170: , p6_a2 JTF_NUMBER_TABLE
171: , p6_a3 JTF_NUMBER_TABLE
172: , p6_a4 JTF_VARCHAR2_TABLE_800
173: , p6_a5 JTF_NUMBER_TABLE
174: , p6_a6 JTF_DATE_TABLE
175: , p6_a7 JTF_NUMBER_TABLE
176: , p6_a8 JTF_DATE_TABLE
177: , p6_a9 JTF_NUMBER_TABLE

Line 175: , p6_a7 JTF_NUMBER_TABLE

171: , p6_a3 JTF_NUMBER_TABLE
172: , p6_a4 JTF_VARCHAR2_TABLE_800
173: , p6_a5 JTF_NUMBER_TABLE
174: , p6_a6 JTF_DATE_TABLE
175: , p6_a7 JTF_NUMBER_TABLE
176: , p6_a8 JTF_DATE_TABLE
177: , p6_a9 JTF_NUMBER_TABLE
178: , p7_a0 out nocopy JTF_NUMBER_TABLE
179: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 177: , p6_a9 JTF_NUMBER_TABLE

173: , p6_a5 JTF_NUMBER_TABLE
174: , p6_a6 JTF_DATE_TABLE
175: , p6_a7 JTF_NUMBER_TABLE
176: , p6_a8 JTF_DATE_TABLE
177: , p6_a9 JTF_NUMBER_TABLE
178: , p7_a0 out nocopy JTF_NUMBER_TABLE
179: , p7_a1 out nocopy JTF_NUMBER_TABLE
180: , p7_a2 out nocopy JTF_NUMBER_TABLE
181: , p7_a3 out nocopy JTF_NUMBER_TABLE

Line 178: , p7_a0 out nocopy JTF_NUMBER_TABLE

174: , p6_a6 JTF_DATE_TABLE
175: , p6_a7 JTF_NUMBER_TABLE
176: , p6_a8 JTF_DATE_TABLE
177: , p6_a9 JTF_NUMBER_TABLE
178: , p7_a0 out nocopy JTF_NUMBER_TABLE
179: , p7_a1 out nocopy JTF_NUMBER_TABLE
180: , p7_a2 out nocopy JTF_NUMBER_TABLE
181: , p7_a3 out nocopy JTF_NUMBER_TABLE
182: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800

Line 179: , p7_a1 out nocopy JTF_NUMBER_TABLE

175: , p6_a7 JTF_NUMBER_TABLE
176: , p6_a8 JTF_DATE_TABLE
177: , p6_a9 JTF_NUMBER_TABLE
178: , p7_a0 out nocopy JTF_NUMBER_TABLE
179: , p7_a1 out nocopy JTF_NUMBER_TABLE
180: , p7_a2 out nocopy JTF_NUMBER_TABLE
181: , p7_a3 out nocopy JTF_NUMBER_TABLE
182: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
183: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 180: , p7_a2 out nocopy JTF_NUMBER_TABLE

176: , p6_a8 JTF_DATE_TABLE
177: , p6_a9 JTF_NUMBER_TABLE
178: , p7_a0 out nocopy JTF_NUMBER_TABLE
179: , p7_a1 out nocopy JTF_NUMBER_TABLE
180: , p7_a2 out nocopy JTF_NUMBER_TABLE
181: , p7_a3 out nocopy JTF_NUMBER_TABLE
182: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
183: , p7_a5 out nocopy JTF_NUMBER_TABLE
184: , p7_a6 out nocopy JTF_DATE_TABLE

Line 181: , p7_a3 out nocopy JTF_NUMBER_TABLE

177: , p6_a9 JTF_NUMBER_TABLE
178: , p7_a0 out nocopy JTF_NUMBER_TABLE
179: , p7_a1 out nocopy JTF_NUMBER_TABLE
180: , p7_a2 out nocopy JTF_NUMBER_TABLE
181: , p7_a3 out nocopy JTF_NUMBER_TABLE
182: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
183: , p7_a5 out nocopy JTF_NUMBER_TABLE
184: , p7_a6 out nocopy JTF_DATE_TABLE
185: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 183: , p7_a5 out nocopy JTF_NUMBER_TABLE

179: , p7_a1 out nocopy JTF_NUMBER_TABLE
180: , p7_a2 out nocopy JTF_NUMBER_TABLE
181: , p7_a3 out nocopy JTF_NUMBER_TABLE
182: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
183: , p7_a5 out nocopy JTF_NUMBER_TABLE
184: , p7_a6 out nocopy JTF_DATE_TABLE
185: , p7_a7 out nocopy JTF_NUMBER_TABLE
186: , p7_a8 out nocopy JTF_DATE_TABLE
187: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 185: , p7_a7 out nocopy JTF_NUMBER_TABLE

181: , p7_a3 out nocopy JTF_NUMBER_TABLE
182: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
183: , p7_a5 out nocopy JTF_NUMBER_TABLE
184: , p7_a6 out nocopy JTF_DATE_TABLE
185: , p7_a7 out nocopy JTF_NUMBER_TABLE
186: , p7_a8 out nocopy JTF_DATE_TABLE
187: , p7_a9 out nocopy JTF_NUMBER_TABLE
188: , p5_a0 NUMBER := 0-1962.0724
189: , p5_a1 NUMBER := 0-1962.0724

Line 187: , p7_a9 out nocopy JTF_NUMBER_TABLE

183: , p7_a5 out nocopy JTF_NUMBER_TABLE
184: , p7_a6 out nocopy JTF_DATE_TABLE
185: , p7_a7 out nocopy JTF_NUMBER_TABLE
186: , p7_a8 out nocopy JTF_DATE_TABLE
187: , p7_a9 out nocopy JTF_NUMBER_TABLE
188: , p5_a0 NUMBER := 0-1962.0724
189: , p5_a1 NUMBER := 0-1962.0724
190: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a3 NUMBER := 0-1962.0724

Line 228: , p6_a0 JTF_NUMBER_TABLE

224: , p_init_msg_list VARCHAR2
225: , x_return_status out nocopy VARCHAR2
226: , x_msg_count out nocopy NUMBER
227: , x_msg_data out nocopy VARCHAR2
228: , p6_a0 JTF_NUMBER_TABLE
229: , p6_a1 JTF_NUMBER_TABLE
230: , p6_a2 JTF_NUMBER_TABLE
231: , p6_a3 JTF_NUMBER_TABLE
232: , p6_a4 JTF_VARCHAR2_TABLE_800

Line 229: , p6_a1 JTF_NUMBER_TABLE

225: , x_return_status out nocopy VARCHAR2
226: , x_msg_count out nocopy NUMBER
227: , x_msg_data out nocopy VARCHAR2
228: , p6_a0 JTF_NUMBER_TABLE
229: , p6_a1 JTF_NUMBER_TABLE
230: , p6_a2 JTF_NUMBER_TABLE
231: , p6_a3 JTF_NUMBER_TABLE
232: , p6_a4 JTF_VARCHAR2_TABLE_800
233: , p6_a5 JTF_NUMBER_TABLE

Line 230: , p6_a2 JTF_NUMBER_TABLE

226: , x_msg_count out nocopy NUMBER
227: , x_msg_data out nocopy VARCHAR2
228: , p6_a0 JTF_NUMBER_TABLE
229: , p6_a1 JTF_NUMBER_TABLE
230: , p6_a2 JTF_NUMBER_TABLE
231: , p6_a3 JTF_NUMBER_TABLE
232: , p6_a4 JTF_VARCHAR2_TABLE_800
233: , p6_a5 JTF_NUMBER_TABLE
234: , p6_a6 JTF_DATE_TABLE

Line 231: , p6_a3 JTF_NUMBER_TABLE

227: , x_msg_data out nocopy VARCHAR2
228: , p6_a0 JTF_NUMBER_TABLE
229: , p6_a1 JTF_NUMBER_TABLE
230: , p6_a2 JTF_NUMBER_TABLE
231: , p6_a3 JTF_NUMBER_TABLE
232: , p6_a4 JTF_VARCHAR2_TABLE_800
233: , p6_a5 JTF_NUMBER_TABLE
234: , p6_a6 JTF_DATE_TABLE
235: , p6_a7 JTF_NUMBER_TABLE

Line 233: , p6_a5 JTF_NUMBER_TABLE

229: , p6_a1 JTF_NUMBER_TABLE
230: , p6_a2 JTF_NUMBER_TABLE
231: , p6_a3 JTF_NUMBER_TABLE
232: , p6_a4 JTF_VARCHAR2_TABLE_800
233: , p6_a5 JTF_NUMBER_TABLE
234: , p6_a6 JTF_DATE_TABLE
235: , p6_a7 JTF_NUMBER_TABLE
236: , p6_a8 JTF_DATE_TABLE
237: , p6_a9 JTF_NUMBER_TABLE

Line 235: , p6_a7 JTF_NUMBER_TABLE

231: , p6_a3 JTF_NUMBER_TABLE
232: , p6_a4 JTF_VARCHAR2_TABLE_800
233: , p6_a5 JTF_NUMBER_TABLE
234: , p6_a6 JTF_DATE_TABLE
235: , p6_a7 JTF_NUMBER_TABLE
236: , p6_a8 JTF_DATE_TABLE
237: , p6_a9 JTF_NUMBER_TABLE
238: , p7_a0 out nocopy JTF_NUMBER_TABLE
239: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 237: , p6_a9 JTF_NUMBER_TABLE

233: , p6_a5 JTF_NUMBER_TABLE
234: , p6_a6 JTF_DATE_TABLE
235: , p6_a7 JTF_NUMBER_TABLE
236: , p6_a8 JTF_DATE_TABLE
237: , p6_a9 JTF_NUMBER_TABLE
238: , p7_a0 out nocopy JTF_NUMBER_TABLE
239: , p7_a1 out nocopy JTF_NUMBER_TABLE
240: , p7_a2 out nocopy JTF_NUMBER_TABLE
241: , p7_a3 out nocopy JTF_NUMBER_TABLE

Line 238: , p7_a0 out nocopy JTF_NUMBER_TABLE

234: , p6_a6 JTF_DATE_TABLE
235: , p6_a7 JTF_NUMBER_TABLE
236: , p6_a8 JTF_DATE_TABLE
237: , p6_a9 JTF_NUMBER_TABLE
238: , p7_a0 out nocopy JTF_NUMBER_TABLE
239: , p7_a1 out nocopy JTF_NUMBER_TABLE
240: , p7_a2 out nocopy JTF_NUMBER_TABLE
241: , p7_a3 out nocopy JTF_NUMBER_TABLE
242: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800

Line 239: , p7_a1 out nocopy JTF_NUMBER_TABLE

235: , p6_a7 JTF_NUMBER_TABLE
236: , p6_a8 JTF_DATE_TABLE
237: , p6_a9 JTF_NUMBER_TABLE
238: , p7_a0 out nocopy JTF_NUMBER_TABLE
239: , p7_a1 out nocopy JTF_NUMBER_TABLE
240: , p7_a2 out nocopy JTF_NUMBER_TABLE
241: , p7_a3 out nocopy JTF_NUMBER_TABLE
242: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
243: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 240: , p7_a2 out nocopy JTF_NUMBER_TABLE

236: , p6_a8 JTF_DATE_TABLE
237: , p6_a9 JTF_NUMBER_TABLE
238: , p7_a0 out nocopy JTF_NUMBER_TABLE
239: , p7_a1 out nocopy JTF_NUMBER_TABLE
240: , p7_a2 out nocopy JTF_NUMBER_TABLE
241: , p7_a3 out nocopy JTF_NUMBER_TABLE
242: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
243: , p7_a5 out nocopy JTF_NUMBER_TABLE
244: , p7_a6 out nocopy JTF_DATE_TABLE

Line 241: , p7_a3 out nocopy JTF_NUMBER_TABLE

237: , p6_a9 JTF_NUMBER_TABLE
238: , p7_a0 out nocopy JTF_NUMBER_TABLE
239: , p7_a1 out nocopy JTF_NUMBER_TABLE
240: , p7_a2 out nocopy JTF_NUMBER_TABLE
241: , p7_a3 out nocopy JTF_NUMBER_TABLE
242: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
243: , p7_a5 out nocopy JTF_NUMBER_TABLE
244: , p7_a6 out nocopy JTF_DATE_TABLE
245: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 243: , p7_a5 out nocopy JTF_NUMBER_TABLE

239: , p7_a1 out nocopy JTF_NUMBER_TABLE
240: , p7_a2 out nocopy JTF_NUMBER_TABLE
241: , p7_a3 out nocopy JTF_NUMBER_TABLE
242: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
243: , p7_a5 out nocopy JTF_NUMBER_TABLE
244: , p7_a6 out nocopy JTF_DATE_TABLE
245: , p7_a7 out nocopy JTF_NUMBER_TABLE
246: , p7_a8 out nocopy JTF_DATE_TABLE
247: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 245: , p7_a7 out nocopy JTF_NUMBER_TABLE

241: , p7_a3 out nocopy JTF_NUMBER_TABLE
242: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_800
243: , p7_a5 out nocopy JTF_NUMBER_TABLE
244: , p7_a6 out nocopy JTF_DATE_TABLE
245: , p7_a7 out nocopy JTF_NUMBER_TABLE
246: , p7_a8 out nocopy JTF_DATE_TABLE
247: , p7_a9 out nocopy JTF_NUMBER_TABLE
248: , p5_a0 NUMBER := 0-1962.0724
249: , p5_a1 NUMBER := 0-1962.0724

Line 247: , p7_a9 out nocopy JTF_NUMBER_TABLE

243: , p7_a5 out nocopy JTF_NUMBER_TABLE
244: , p7_a6 out nocopy JTF_DATE_TABLE
245: , p7_a7 out nocopy JTF_NUMBER_TABLE
246: , p7_a8 out nocopy JTF_DATE_TABLE
247: , p7_a9 out nocopy JTF_NUMBER_TABLE
248: , p5_a0 NUMBER := 0-1962.0724
249: , p5_a1 NUMBER := 0-1962.0724
250: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a3 NUMBER := 0-1962.0724