APPS.OKL_SETUPFMACONSTRAINTS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 151: , p5_a0 JTF_NUMBER_TABLE

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

Line 152: , p5_a1 JTF_NUMBER_TABLE

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

Line 153: , p5_a2 JTF_NUMBER_TABLE

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

Line 154: , p5_a3 JTF_NUMBER_TABLE

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

Line 156: , p5_a5 JTF_NUMBER_TABLE

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

Line 158: , p5_a7 JTF_NUMBER_TABLE

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

Line 160: , p5_a9 JTF_NUMBER_TABLE

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

Line 167: , p6_a0 JTF_NUMBER_TABLE

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

Line 168: , p6_a1 JTF_NUMBER_TABLE

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

Line 169: , p6_a2 JTF_NUMBER_TABLE

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

Line 170: , p6_a3 JTF_NUMBER_TABLE

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

Line 172: , p6_a5 JTF_NUMBER_TABLE

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

Line 174: , p6_a7 JTF_NUMBER_TABLE

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

Line 176: , p6_a9 JTF_NUMBER_TABLE

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

Line 177: , p7_a0 out nocopy JTF_NUMBER_TABLE

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

Line 178: , p7_a1 out nocopy JTF_NUMBER_TABLE

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

Line 179: , p7_a2 out nocopy JTF_NUMBER_TABLE

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

Line 180: , p7_a3 out nocopy JTF_NUMBER_TABLE

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

Line 182: , p7_a5 out nocopy JTF_NUMBER_TABLE

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

Line 184: , p7_a7 out nocopy JTF_NUMBER_TABLE

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

Line 186: , p7_a9 out nocopy JTF_NUMBER_TABLE

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

Line 227: , p6_a0 JTF_NUMBER_TABLE

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

Line 228: , p6_a1 JTF_NUMBER_TABLE

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

Line 229: , p6_a2 JTF_NUMBER_TABLE

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

Line 230: , p6_a3 JTF_NUMBER_TABLE

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

Line 232: , p6_a5 JTF_NUMBER_TABLE

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

Line 234: , p6_a7 JTF_NUMBER_TABLE

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

Line 236: , p6_a9 JTF_NUMBER_TABLE

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

Line 237: , p7_a0 out nocopy JTF_NUMBER_TABLE

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

Line 238: , p7_a1 out nocopy JTF_NUMBER_TABLE

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

Line 239: , p7_a2 out nocopy JTF_NUMBER_TABLE

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

Line 240: , p7_a3 out nocopy JTF_NUMBER_TABLE

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

Line 242: , p7_a5 out nocopy JTF_NUMBER_TABLE

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

Line 244: , p7_a7 out nocopy JTF_NUMBER_TABLE

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

Line 246: , p7_a9 out nocopy JTF_NUMBER_TABLE

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