APPS.AS_OPPORTUNITY_PUB_W4 dependencies on JTF_VARCHAR2_TABLE_100

Line 22: , p5_a14 JTF_VARCHAR2_TABLE_100

18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_NUMBER_TABLE
20: , p5_a12 JTF_NUMBER_TABLE
21: , p5_a13 JTF_NUMBER_TABLE
22: , p5_a14 JTF_VARCHAR2_TABLE_100
23: , p5_a15 JTF_VARCHAR2_TABLE_100
24: , p5_a16 JTF_VARCHAR2_TABLE_100
25: , p5_a17 JTF_VARCHAR2_TABLE_300
26: , p5_a18 JTF_NUMBER_TABLE

Line 23: , p5_a15 JTF_VARCHAR2_TABLE_100

19: , p5_a11 JTF_NUMBER_TABLE
20: , p5_a12 JTF_NUMBER_TABLE
21: , p5_a13 JTF_NUMBER_TABLE
22: , p5_a14 JTF_VARCHAR2_TABLE_100
23: , p5_a15 JTF_VARCHAR2_TABLE_100
24: , p5_a16 JTF_VARCHAR2_TABLE_100
25: , p5_a17 JTF_VARCHAR2_TABLE_300
26: , p5_a18 JTF_NUMBER_TABLE
27: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 24: , p5_a16 JTF_VARCHAR2_TABLE_100

20: , p5_a12 JTF_NUMBER_TABLE
21: , p5_a13 JTF_NUMBER_TABLE
22: , p5_a14 JTF_VARCHAR2_TABLE_100
23: , p5_a15 JTF_VARCHAR2_TABLE_100
24: , p5_a16 JTF_VARCHAR2_TABLE_100
25: , p5_a17 JTF_VARCHAR2_TABLE_300
26: , p5_a18 JTF_NUMBER_TABLE
27: , p5_a19 JTF_VARCHAR2_TABLE_100
28: , p5_a20 JTF_VARCHAR2_TABLE_100

Line 27: , p5_a19 JTF_VARCHAR2_TABLE_100

23: , p5_a15 JTF_VARCHAR2_TABLE_100
24: , p5_a16 JTF_VARCHAR2_TABLE_100
25: , p5_a17 JTF_VARCHAR2_TABLE_300
26: , p5_a18 JTF_NUMBER_TABLE
27: , p5_a19 JTF_VARCHAR2_TABLE_100
28: , p5_a20 JTF_VARCHAR2_TABLE_100
29: , p5_a21 JTF_VARCHAR2_TABLE_100
30: , p5_a22 JTF_VARCHAR2_TABLE_100
31: , p5_a23 JTF_VARCHAR2_TABLE_100

Line 28: , p5_a20 JTF_VARCHAR2_TABLE_100

24: , p5_a16 JTF_VARCHAR2_TABLE_100
25: , p5_a17 JTF_VARCHAR2_TABLE_300
26: , p5_a18 JTF_NUMBER_TABLE
27: , p5_a19 JTF_VARCHAR2_TABLE_100
28: , p5_a20 JTF_VARCHAR2_TABLE_100
29: , p5_a21 JTF_VARCHAR2_TABLE_100
30: , p5_a22 JTF_VARCHAR2_TABLE_100
31: , p5_a23 JTF_VARCHAR2_TABLE_100
32: , p5_a24 JTF_NUMBER_TABLE

Line 29: , p5_a21 JTF_VARCHAR2_TABLE_100

25: , p5_a17 JTF_VARCHAR2_TABLE_300
26: , p5_a18 JTF_NUMBER_TABLE
27: , p5_a19 JTF_VARCHAR2_TABLE_100
28: , p5_a20 JTF_VARCHAR2_TABLE_100
29: , p5_a21 JTF_VARCHAR2_TABLE_100
30: , p5_a22 JTF_VARCHAR2_TABLE_100
31: , p5_a23 JTF_VARCHAR2_TABLE_100
32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_VARCHAR2_TABLE_100

Line 30: , p5_a22 JTF_VARCHAR2_TABLE_100

26: , p5_a18 JTF_NUMBER_TABLE
27: , p5_a19 JTF_VARCHAR2_TABLE_100
28: , p5_a20 JTF_VARCHAR2_TABLE_100
29: , p5_a21 JTF_VARCHAR2_TABLE_100
30: , p5_a22 JTF_VARCHAR2_TABLE_100
31: , p5_a23 JTF_VARCHAR2_TABLE_100
32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_VARCHAR2_TABLE_100
34: , p5_a26 JTF_VARCHAR2_TABLE_100

Line 31: , p5_a23 JTF_VARCHAR2_TABLE_100

27: , p5_a19 JTF_VARCHAR2_TABLE_100
28: , p5_a20 JTF_VARCHAR2_TABLE_100
29: , p5_a21 JTF_VARCHAR2_TABLE_100
30: , p5_a22 JTF_VARCHAR2_TABLE_100
31: , p5_a23 JTF_VARCHAR2_TABLE_100
32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_VARCHAR2_TABLE_100
34: , p5_a26 JTF_VARCHAR2_TABLE_100
35: , p5_a27 JTF_NUMBER_TABLE

Line 33: , p5_a25 JTF_VARCHAR2_TABLE_100

29: , p5_a21 JTF_VARCHAR2_TABLE_100
30: , p5_a22 JTF_VARCHAR2_TABLE_100
31: , p5_a23 JTF_VARCHAR2_TABLE_100
32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_VARCHAR2_TABLE_100
34: , p5_a26 JTF_VARCHAR2_TABLE_100
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_VARCHAR2_TABLE_100
37: , p5_a29 JTF_VARCHAR2_TABLE_200

Line 34: , p5_a26 JTF_VARCHAR2_TABLE_100

30: , p5_a22 JTF_VARCHAR2_TABLE_100
31: , p5_a23 JTF_VARCHAR2_TABLE_100
32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_VARCHAR2_TABLE_100
34: , p5_a26 JTF_VARCHAR2_TABLE_100
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_VARCHAR2_TABLE_100
37: , p5_a29 JTF_VARCHAR2_TABLE_200
38: , p5_a30 JTF_VARCHAR2_TABLE_200

Line 36: , p5_a28 JTF_VARCHAR2_TABLE_100

32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_VARCHAR2_TABLE_100
34: , p5_a26 JTF_VARCHAR2_TABLE_100
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_VARCHAR2_TABLE_100
37: , p5_a29 JTF_VARCHAR2_TABLE_200
38: , p5_a30 JTF_VARCHAR2_TABLE_200
39: , p5_a31 JTF_VARCHAR2_TABLE_200
40: , p5_a32 JTF_VARCHAR2_TABLE_200

Line 56: , p11_a0 JTF_VARCHAR2_TABLE_100

52: , p_check_access_flag VARCHAR2
53: , p_admin_flag VARCHAR2
54: , p_admin_group_id NUMBER
55: , p_partner_cont_party_id NUMBER
56: , p11_a0 JTF_VARCHAR2_TABLE_100
57: , p11_a1 JTF_VARCHAR2_TABLE_300
58: , p12_a0 out nocopy JTF_NUMBER_TABLE
59: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
60: , x_return_status out nocopy VARCHAR2

Line 59: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100

55: , p_partner_cont_party_id NUMBER
56: , p11_a0 JTF_VARCHAR2_TABLE_100
57: , p11_a1 JTF_VARCHAR2_TABLE_300
58: , p12_a0 out nocopy JTF_NUMBER_TABLE
59: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
60: , x_return_status out nocopy VARCHAR2
61: , x_msg_count out nocopy NUMBER
62: , x_msg_data out nocopy VARCHAR2
63: , p6_a0 DATE := fnd_api.g_miss_date

Line 183: , p5_a14 JTF_VARCHAR2_TABLE_100

179: , p5_a10 JTF_NUMBER_TABLE
180: , p5_a11 JTF_NUMBER_TABLE
181: , p5_a12 JTF_NUMBER_TABLE
182: , p5_a13 JTF_NUMBER_TABLE
183: , p5_a14 JTF_VARCHAR2_TABLE_100
184: , p5_a15 JTF_VARCHAR2_TABLE_100
185: , p5_a16 JTF_VARCHAR2_TABLE_100
186: , p5_a17 JTF_VARCHAR2_TABLE_300
187: , p5_a18 JTF_NUMBER_TABLE

Line 184: , p5_a15 JTF_VARCHAR2_TABLE_100

180: , p5_a11 JTF_NUMBER_TABLE
181: , p5_a12 JTF_NUMBER_TABLE
182: , p5_a13 JTF_NUMBER_TABLE
183: , p5_a14 JTF_VARCHAR2_TABLE_100
184: , p5_a15 JTF_VARCHAR2_TABLE_100
185: , p5_a16 JTF_VARCHAR2_TABLE_100
186: , p5_a17 JTF_VARCHAR2_TABLE_300
187: , p5_a18 JTF_NUMBER_TABLE
188: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 185: , p5_a16 JTF_VARCHAR2_TABLE_100

181: , p5_a12 JTF_NUMBER_TABLE
182: , p5_a13 JTF_NUMBER_TABLE
183: , p5_a14 JTF_VARCHAR2_TABLE_100
184: , p5_a15 JTF_VARCHAR2_TABLE_100
185: , p5_a16 JTF_VARCHAR2_TABLE_100
186: , p5_a17 JTF_VARCHAR2_TABLE_300
187: , p5_a18 JTF_NUMBER_TABLE
188: , p5_a19 JTF_VARCHAR2_TABLE_100
189: , p5_a20 JTF_VARCHAR2_TABLE_100

Line 188: , p5_a19 JTF_VARCHAR2_TABLE_100

184: , p5_a15 JTF_VARCHAR2_TABLE_100
185: , p5_a16 JTF_VARCHAR2_TABLE_100
186: , p5_a17 JTF_VARCHAR2_TABLE_300
187: , p5_a18 JTF_NUMBER_TABLE
188: , p5_a19 JTF_VARCHAR2_TABLE_100
189: , p5_a20 JTF_VARCHAR2_TABLE_100
190: , p5_a21 JTF_VARCHAR2_TABLE_100
191: , p5_a22 JTF_VARCHAR2_TABLE_100
192: , p5_a23 JTF_VARCHAR2_TABLE_100

Line 189: , p5_a20 JTF_VARCHAR2_TABLE_100

185: , p5_a16 JTF_VARCHAR2_TABLE_100
186: , p5_a17 JTF_VARCHAR2_TABLE_300
187: , p5_a18 JTF_NUMBER_TABLE
188: , p5_a19 JTF_VARCHAR2_TABLE_100
189: , p5_a20 JTF_VARCHAR2_TABLE_100
190: , p5_a21 JTF_VARCHAR2_TABLE_100
191: , p5_a22 JTF_VARCHAR2_TABLE_100
192: , p5_a23 JTF_VARCHAR2_TABLE_100
193: , p5_a24 JTF_NUMBER_TABLE

Line 190: , p5_a21 JTF_VARCHAR2_TABLE_100

186: , p5_a17 JTF_VARCHAR2_TABLE_300
187: , p5_a18 JTF_NUMBER_TABLE
188: , p5_a19 JTF_VARCHAR2_TABLE_100
189: , p5_a20 JTF_VARCHAR2_TABLE_100
190: , p5_a21 JTF_VARCHAR2_TABLE_100
191: , p5_a22 JTF_VARCHAR2_TABLE_100
192: , p5_a23 JTF_VARCHAR2_TABLE_100
193: , p5_a24 JTF_NUMBER_TABLE
194: , p5_a25 JTF_VARCHAR2_TABLE_100

Line 191: , p5_a22 JTF_VARCHAR2_TABLE_100

187: , p5_a18 JTF_NUMBER_TABLE
188: , p5_a19 JTF_VARCHAR2_TABLE_100
189: , p5_a20 JTF_VARCHAR2_TABLE_100
190: , p5_a21 JTF_VARCHAR2_TABLE_100
191: , p5_a22 JTF_VARCHAR2_TABLE_100
192: , p5_a23 JTF_VARCHAR2_TABLE_100
193: , p5_a24 JTF_NUMBER_TABLE
194: , p5_a25 JTF_VARCHAR2_TABLE_100
195: , p5_a26 JTF_VARCHAR2_TABLE_100

Line 192: , p5_a23 JTF_VARCHAR2_TABLE_100

188: , p5_a19 JTF_VARCHAR2_TABLE_100
189: , p5_a20 JTF_VARCHAR2_TABLE_100
190: , p5_a21 JTF_VARCHAR2_TABLE_100
191: , p5_a22 JTF_VARCHAR2_TABLE_100
192: , p5_a23 JTF_VARCHAR2_TABLE_100
193: , p5_a24 JTF_NUMBER_TABLE
194: , p5_a25 JTF_VARCHAR2_TABLE_100
195: , p5_a26 JTF_VARCHAR2_TABLE_100
196: , p5_a27 JTF_NUMBER_TABLE

Line 194: , p5_a25 JTF_VARCHAR2_TABLE_100

190: , p5_a21 JTF_VARCHAR2_TABLE_100
191: , p5_a22 JTF_VARCHAR2_TABLE_100
192: , p5_a23 JTF_VARCHAR2_TABLE_100
193: , p5_a24 JTF_NUMBER_TABLE
194: , p5_a25 JTF_VARCHAR2_TABLE_100
195: , p5_a26 JTF_VARCHAR2_TABLE_100
196: , p5_a27 JTF_NUMBER_TABLE
197: , p5_a28 JTF_VARCHAR2_TABLE_100
198: , p5_a29 JTF_VARCHAR2_TABLE_200

Line 195: , p5_a26 JTF_VARCHAR2_TABLE_100

191: , p5_a22 JTF_VARCHAR2_TABLE_100
192: , p5_a23 JTF_VARCHAR2_TABLE_100
193: , p5_a24 JTF_NUMBER_TABLE
194: , p5_a25 JTF_VARCHAR2_TABLE_100
195: , p5_a26 JTF_VARCHAR2_TABLE_100
196: , p5_a27 JTF_NUMBER_TABLE
197: , p5_a28 JTF_VARCHAR2_TABLE_100
198: , p5_a29 JTF_VARCHAR2_TABLE_200
199: , p5_a30 JTF_VARCHAR2_TABLE_200

Line 197: , p5_a28 JTF_VARCHAR2_TABLE_100

193: , p5_a24 JTF_NUMBER_TABLE
194: , p5_a25 JTF_VARCHAR2_TABLE_100
195: , p5_a26 JTF_VARCHAR2_TABLE_100
196: , p5_a27 JTF_NUMBER_TABLE
197: , p5_a28 JTF_VARCHAR2_TABLE_100
198: , p5_a29 JTF_VARCHAR2_TABLE_200
199: , p5_a30 JTF_VARCHAR2_TABLE_200
200: , p5_a31 JTF_VARCHAR2_TABLE_200
201: , p5_a32 JTF_VARCHAR2_TABLE_200

Line 217: , p10_a0 JTF_VARCHAR2_TABLE_100

213: , p_check_access_flag VARCHAR2
214: , p_admin_flag VARCHAR2
215: , p_admin_group_id NUMBER
216: , p_partner_cont_party_id NUMBER
217: , p10_a0 JTF_VARCHAR2_TABLE_100
218: , p10_a1 JTF_VARCHAR2_TABLE_300
219: , p11_a0 out nocopy JTF_NUMBER_TABLE
220: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
221: , x_return_status out nocopy VARCHAR2

Line 220: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100

216: , p_partner_cont_party_id NUMBER
217: , p10_a0 JTF_VARCHAR2_TABLE_100
218: , p10_a1 JTF_VARCHAR2_TABLE_300
219: , p11_a0 out nocopy JTF_NUMBER_TABLE
220: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: );

Line 244: , p5_a14 JTF_VARCHAR2_TABLE_100

240: , p5_a10 JTF_NUMBER_TABLE
241: , p5_a11 JTF_NUMBER_TABLE
242: , p5_a12 JTF_NUMBER_TABLE
243: , p5_a13 JTF_NUMBER_TABLE
244: , p5_a14 JTF_VARCHAR2_TABLE_100
245: , p5_a15 JTF_VARCHAR2_TABLE_100
246: , p5_a16 JTF_VARCHAR2_TABLE_100
247: , p5_a17 JTF_VARCHAR2_TABLE_300
248: , p5_a18 JTF_NUMBER_TABLE

Line 245: , p5_a15 JTF_VARCHAR2_TABLE_100

241: , p5_a11 JTF_NUMBER_TABLE
242: , p5_a12 JTF_NUMBER_TABLE
243: , p5_a13 JTF_NUMBER_TABLE
244: , p5_a14 JTF_VARCHAR2_TABLE_100
245: , p5_a15 JTF_VARCHAR2_TABLE_100
246: , p5_a16 JTF_VARCHAR2_TABLE_100
247: , p5_a17 JTF_VARCHAR2_TABLE_300
248: , p5_a18 JTF_NUMBER_TABLE
249: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 246: , p5_a16 JTF_VARCHAR2_TABLE_100

242: , p5_a12 JTF_NUMBER_TABLE
243: , p5_a13 JTF_NUMBER_TABLE
244: , p5_a14 JTF_VARCHAR2_TABLE_100
245: , p5_a15 JTF_VARCHAR2_TABLE_100
246: , p5_a16 JTF_VARCHAR2_TABLE_100
247: , p5_a17 JTF_VARCHAR2_TABLE_300
248: , p5_a18 JTF_NUMBER_TABLE
249: , p5_a19 JTF_VARCHAR2_TABLE_100
250: , p5_a20 JTF_VARCHAR2_TABLE_100

Line 249: , p5_a19 JTF_VARCHAR2_TABLE_100

245: , p5_a15 JTF_VARCHAR2_TABLE_100
246: , p5_a16 JTF_VARCHAR2_TABLE_100
247: , p5_a17 JTF_VARCHAR2_TABLE_300
248: , p5_a18 JTF_NUMBER_TABLE
249: , p5_a19 JTF_VARCHAR2_TABLE_100
250: , p5_a20 JTF_VARCHAR2_TABLE_100
251: , p5_a21 JTF_VARCHAR2_TABLE_100
252: , p5_a22 JTF_VARCHAR2_TABLE_100
253: , p5_a23 JTF_VARCHAR2_TABLE_100

Line 250: , p5_a20 JTF_VARCHAR2_TABLE_100

246: , p5_a16 JTF_VARCHAR2_TABLE_100
247: , p5_a17 JTF_VARCHAR2_TABLE_300
248: , p5_a18 JTF_NUMBER_TABLE
249: , p5_a19 JTF_VARCHAR2_TABLE_100
250: , p5_a20 JTF_VARCHAR2_TABLE_100
251: , p5_a21 JTF_VARCHAR2_TABLE_100
252: , p5_a22 JTF_VARCHAR2_TABLE_100
253: , p5_a23 JTF_VARCHAR2_TABLE_100
254: , p5_a24 JTF_NUMBER_TABLE

Line 251: , p5_a21 JTF_VARCHAR2_TABLE_100

247: , p5_a17 JTF_VARCHAR2_TABLE_300
248: , p5_a18 JTF_NUMBER_TABLE
249: , p5_a19 JTF_VARCHAR2_TABLE_100
250: , p5_a20 JTF_VARCHAR2_TABLE_100
251: , p5_a21 JTF_VARCHAR2_TABLE_100
252: , p5_a22 JTF_VARCHAR2_TABLE_100
253: , p5_a23 JTF_VARCHAR2_TABLE_100
254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100

Line 252: , p5_a22 JTF_VARCHAR2_TABLE_100

248: , p5_a18 JTF_NUMBER_TABLE
249: , p5_a19 JTF_VARCHAR2_TABLE_100
250: , p5_a20 JTF_VARCHAR2_TABLE_100
251: , p5_a21 JTF_VARCHAR2_TABLE_100
252: , p5_a22 JTF_VARCHAR2_TABLE_100
253: , p5_a23 JTF_VARCHAR2_TABLE_100
254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100
256: , p5_a26 JTF_VARCHAR2_TABLE_100

Line 253: , p5_a23 JTF_VARCHAR2_TABLE_100

249: , p5_a19 JTF_VARCHAR2_TABLE_100
250: , p5_a20 JTF_VARCHAR2_TABLE_100
251: , p5_a21 JTF_VARCHAR2_TABLE_100
252: , p5_a22 JTF_VARCHAR2_TABLE_100
253: , p5_a23 JTF_VARCHAR2_TABLE_100
254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100
256: , p5_a26 JTF_VARCHAR2_TABLE_100
257: , p5_a27 JTF_NUMBER_TABLE

Line 255: , p5_a25 JTF_VARCHAR2_TABLE_100

251: , p5_a21 JTF_VARCHAR2_TABLE_100
252: , p5_a22 JTF_VARCHAR2_TABLE_100
253: , p5_a23 JTF_VARCHAR2_TABLE_100
254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100
256: , p5_a26 JTF_VARCHAR2_TABLE_100
257: , p5_a27 JTF_NUMBER_TABLE
258: , p5_a28 JTF_VARCHAR2_TABLE_100
259: , p5_a29 JTF_VARCHAR2_TABLE_200

Line 256: , p5_a26 JTF_VARCHAR2_TABLE_100

252: , p5_a22 JTF_VARCHAR2_TABLE_100
253: , p5_a23 JTF_VARCHAR2_TABLE_100
254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100
256: , p5_a26 JTF_VARCHAR2_TABLE_100
257: , p5_a27 JTF_NUMBER_TABLE
258: , p5_a28 JTF_VARCHAR2_TABLE_100
259: , p5_a29 JTF_VARCHAR2_TABLE_200
260: , p5_a30 JTF_VARCHAR2_TABLE_200

Line 258: , p5_a28 JTF_VARCHAR2_TABLE_100

254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100
256: , p5_a26 JTF_VARCHAR2_TABLE_100
257: , p5_a27 JTF_NUMBER_TABLE
258: , p5_a28 JTF_VARCHAR2_TABLE_100
259: , p5_a29 JTF_VARCHAR2_TABLE_200
260: , p5_a30 JTF_VARCHAR2_TABLE_200
261: , p5_a31 JTF_VARCHAR2_TABLE_200
262: , p5_a32 JTF_VARCHAR2_TABLE_200

Line 278: , p10_a0 JTF_VARCHAR2_TABLE_100

274: , p_check_access_flag VARCHAR2
275: , p_admin_flag VARCHAR2
276: , p_admin_group_id NUMBER
277: , p_partner_cont_party_id NUMBER
278: , p10_a0 JTF_VARCHAR2_TABLE_100
279: , p10_a1 JTF_VARCHAR2_TABLE_300
280: , p11_a0 out nocopy JTF_NUMBER_TABLE
281: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
282: , x_return_status out nocopy VARCHAR2

Line 281: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100

277: , p_partner_cont_party_id NUMBER
278: , p10_a0 JTF_VARCHAR2_TABLE_100
279: , p10_a1 JTF_VARCHAR2_TABLE_300
280: , p11_a0 out nocopy JTF_NUMBER_TABLE
281: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
282: , x_return_status out nocopy VARCHAR2
283: , x_msg_count out nocopy NUMBER
284: , x_msg_data out nocopy VARCHAR2
285: );

Line 296: , p4_a6 JTF_VARCHAR2_TABLE_100

292: , p4_a2 JTF_NUMBER_TABLE
293: , p4_a3 JTF_DATE_TABLE
294: , p4_a4 JTF_NUMBER_TABLE
295: , p4_a5 JTF_NUMBER_TABLE
296: , p4_a6 JTF_VARCHAR2_TABLE_100
297: , p4_a7 JTF_VARCHAR2_TABLE_100
298: , p4_a8 JTF_VARCHAR2_TABLE_100
299: , p4_a9 JTF_NUMBER_TABLE
300: , p4_a10 JTF_NUMBER_TABLE

Line 297: , p4_a7 JTF_VARCHAR2_TABLE_100

293: , p4_a3 JTF_DATE_TABLE
294: , p4_a4 JTF_NUMBER_TABLE
295: , p4_a5 JTF_NUMBER_TABLE
296: , p4_a6 JTF_VARCHAR2_TABLE_100
297: , p4_a7 JTF_VARCHAR2_TABLE_100
298: , p4_a8 JTF_VARCHAR2_TABLE_100
299: , p4_a9 JTF_NUMBER_TABLE
300: , p4_a10 JTF_NUMBER_TABLE
301: , p4_a11 JTF_NUMBER_TABLE

Line 298: , p4_a8 JTF_VARCHAR2_TABLE_100

294: , p4_a4 JTF_NUMBER_TABLE
295: , p4_a5 JTF_NUMBER_TABLE
296: , p4_a6 JTF_VARCHAR2_TABLE_100
297: , p4_a7 JTF_VARCHAR2_TABLE_100
298: , p4_a8 JTF_VARCHAR2_TABLE_100
299: , p4_a9 JTF_NUMBER_TABLE
300: , p4_a10 JTF_NUMBER_TABLE
301: , p4_a11 JTF_NUMBER_TABLE
302: , p4_a12 JTF_NUMBER_TABLE

Line 304: , p4_a14 JTF_VARCHAR2_TABLE_100

300: , p4_a10 JTF_NUMBER_TABLE
301: , p4_a11 JTF_NUMBER_TABLE
302: , p4_a12 JTF_NUMBER_TABLE
303: , p4_a13 JTF_VARCHAR2_TABLE_300
304: , p4_a14 JTF_VARCHAR2_TABLE_100
305: , p4_a15 JTF_VARCHAR2_TABLE_100
306: , p4_a16 JTF_VARCHAR2_TABLE_300
307: , p4_a17 JTF_VARCHAR2_TABLE_100
308: , p4_a18 JTF_NUMBER_TABLE

Line 305: , p4_a15 JTF_VARCHAR2_TABLE_100

301: , p4_a11 JTF_NUMBER_TABLE
302: , p4_a12 JTF_NUMBER_TABLE
303: , p4_a13 JTF_VARCHAR2_TABLE_300
304: , p4_a14 JTF_VARCHAR2_TABLE_100
305: , p4_a15 JTF_VARCHAR2_TABLE_100
306: , p4_a16 JTF_VARCHAR2_TABLE_300
307: , p4_a17 JTF_VARCHAR2_TABLE_100
308: , p4_a18 JTF_NUMBER_TABLE
309: , p4_a19 JTF_VARCHAR2_TABLE_100

Line 307: , p4_a17 JTF_VARCHAR2_TABLE_100

303: , p4_a13 JTF_VARCHAR2_TABLE_300
304: , p4_a14 JTF_VARCHAR2_TABLE_100
305: , p4_a15 JTF_VARCHAR2_TABLE_100
306: , p4_a16 JTF_VARCHAR2_TABLE_300
307: , p4_a17 JTF_VARCHAR2_TABLE_100
308: , p4_a18 JTF_NUMBER_TABLE
309: , p4_a19 JTF_VARCHAR2_TABLE_100
310: , p4_a20 JTF_NUMBER_TABLE
311: , p4_a21 JTF_NUMBER_TABLE

Line 309: , p4_a19 JTF_VARCHAR2_TABLE_100

305: , p4_a15 JTF_VARCHAR2_TABLE_100
306: , p4_a16 JTF_VARCHAR2_TABLE_300
307: , p4_a17 JTF_VARCHAR2_TABLE_100
308: , p4_a18 JTF_NUMBER_TABLE
309: , p4_a19 JTF_VARCHAR2_TABLE_100
310: , p4_a20 JTF_NUMBER_TABLE
311: , p4_a21 JTF_NUMBER_TABLE
312: , p4_a22 JTF_VARCHAR2_TABLE_100
313: , p4_a23 JTF_VARCHAR2_TABLE_100

Line 312: , p4_a22 JTF_VARCHAR2_TABLE_100

308: , p4_a18 JTF_NUMBER_TABLE
309: , p4_a19 JTF_VARCHAR2_TABLE_100
310: , p4_a20 JTF_NUMBER_TABLE
311: , p4_a21 JTF_NUMBER_TABLE
312: , p4_a22 JTF_VARCHAR2_TABLE_100
313: , p4_a23 JTF_VARCHAR2_TABLE_100
314: , p4_a24 JTF_VARCHAR2_TABLE_100
315: , p4_a25 JTF_VARCHAR2_TABLE_100
316: , p4_a26 JTF_VARCHAR2_TABLE_100

Line 313: , p4_a23 JTF_VARCHAR2_TABLE_100

309: , p4_a19 JTF_VARCHAR2_TABLE_100
310: , p4_a20 JTF_NUMBER_TABLE
311: , p4_a21 JTF_NUMBER_TABLE
312: , p4_a22 JTF_VARCHAR2_TABLE_100
313: , p4_a23 JTF_VARCHAR2_TABLE_100
314: , p4_a24 JTF_VARCHAR2_TABLE_100
315: , p4_a25 JTF_VARCHAR2_TABLE_100
316: , p4_a26 JTF_VARCHAR2_TABLE_100
317: , p4_a27 JTF_VARCHAR2_TABLE_100

Line 314: , p4_a24 JTF_VARCHAR2_TABLE_100

310: , p4_a20 JTF_NUMBER_TABLE
311: , p4_a21 JTF_NUMBER_TABLE
312: , p4_a22 JTF_VARCHAR2_TABLE_100
313: , p4_a23 JTF_VARCHAR2_TABLE_100
314: , p4_a24 JTF_VARCHAR2_TABLE_100
315: , p4_a25 JTF_VARCHAR2_TABLE_100
316: , p4_a26 JTF_VARCHAR2_TABLE_100
317: , p4_a27 JTF_VARCHAR2_TABLE_100
318: , p4_a28 JTF_NUMBER_TABLE

Line 315: , p4_a25 JTF_VARCHAR2_TABLE_100

311: , p4_a21 JTF_NUMBER_TABLE
312: , p4_a22 JTF_VARCHAR2_TABLE_100
313: , p4_a23 JTF_VARCHAR2_TABLE_100
314: , p4_a24 JTF_VARCHAR2_TABLE_100
315: , p4_a25 JTF_VARCHAR2_TABLE_100
316: , p4_a26 JTF_VARCHAR2_TABLE_100
317: , p4_a27 JTF_VARCHAR2_TABLE_100
318: , p4_a28 JTF_NUMBER_TABLE
319: , p4_a29 JTF_NUMBER_TABLE

Line 316: , p4_a26 JTF_VARCHAR2_TABLE_100

312: , p4_a22 JTF_VARCHAR2_TABLE_100
313: , p4_a23 JTF_VARCHAR2_TABLE_100
314: , p4_a24 JTF_VARCHAR2_TABLE_100
315: , p4_a25 JTF_VARCHAR2_TABLE_100
316: , p4_a26 JTF_VARCHAR2_TABLE_100
317: , p4_a27 JTF_VARCHAR2_TABLE_100
318: , p4_a28 JTF_NUMBER_TABLE
319: , p4_a29 JTF_NUMBER_TABLE
320: , p4_a30 JTF_DATE_TABLE

Line 317: , p4_a27 JTF_VARCHAR2_TABLE_100

313: , p4_a23 JTF_VARCHAR2_TABLE_100
314: , p4_a24 JTF_VARCHAR2_TABLE_100
315: , p4_a25 JTF_VARCHAR2_TABLE_100
316: , p4_a26 JTF_VARCHAR2_TABLE_100
317: , p4_a27 JTF_VARCHAR2_TABLE_100
318: , p4_a28 JTF_NUMBER_TABLE
319: , p4_a29 JTF_NUMBER_TABLE
320: , p4_a30 JTF_DATE_TABLE
321: , p4_a31 JTF_VARCHAR2_TABLE_300

Line 324: , p4_a34 JTF_VARCHAR2_TABLE_100

320: , p4_a30 JTF_DATE_TABLE
321: , p4_a31 JTF_VARCHAR2_TABLE_300
322: , p4_a32 JTF_DATE_TABLE
323: , p4_a33 JTF_NUMBER_TABLE
324: , p4_a34 JTF_VARCHAR2_TABLE_100
325: , p4_a35 JTF_VARCHAR2_TABLE_100
326: , p4_a36 JTF_VARCHAR2_TABLE_200
327: , p4_a37 JTF_VARCHAR2_TABLE_200
328: , p4_a38 JTF_VARCHAR2_TABLE_200

Line 325: , p4_a35 JTF_VARCHAR2_TABLE_100

321: , p4_a31 JTF_VARCHAR2_TABLE_300
322: , p4_a32 JTF_DATE_TABLE
323: , p4_a33 JTF_NUMBER_TABLE
324: , p4_a34 JTF_VARCHAR2_TABLE_100
325: , p4_a35 JTF_VARCHAR2_TABLE_100
326: , p4_a36 JTF_VARCHAR2_TABLE_200
327: , p4_a37 JTF_VARCHAR2_TABLE_200
328: , p4_a38 JTF_VARCHAR2_TABLE_200
329: , p4_a39 JTF_VARCHAR2_TABLE_200

Line 341: , p4_a51 JTF_VARCHAR2_TABLE_100

337: , p4_a47 JTF_VARCHAR2_TABLE_200
338: , p4_a48 JTF_VARCHAR2_TABLE_200
339: , p4_a49 JTF_VARCHAR2_TABLE_200
340: , p4_a50 JTF_VARCHAR2_TABLE_200
341: , p4_a51 JTF_VARCHAR2_TABLE_100
342: , p4_a52 JTF_VARCHAR2_TABLE_100
343: , p4_a53 JTF_VARCHAR2_TABLE_100
344: , p4_a54 JTF_NUMBER_TABLE
345: , p4_a55 JTF_NUMBER_TABLE

Line 342: , p4_a52 JTF_VARCHAR2_TABLE_100

338: , p4_a48 JTF_VARCHAR2_TABLE_200
339: , p4_a49 JTF_VARCHAR2_TABLE_200
340: , p4_a50 JTF_VARCHAR2_TABLE_200
341: , p4_a51 JTF_VARCHAR2_TABLE_100
342: , p4_a52 JTF_VARCHAR2_TABLE_100
343: , p4_a53 JTF_VARCHAR2_TABLE_100
344: , p4_a54 JTF_NUMBER_TABLE
345: , p4_a55 JTF_NUMBER_TABLE
346: , p4_a56 JTF_VARCHAR2_TABLE_100

Line 343: , p4_a53 JTF_VARCHAR2_TABLE_100

339: , p4_a49 JTF_VARCHAR2_TABLE_200
340: , p4_a50 JTF_VARCHAR2_TABLE_200
341: , p4_a51 JTF_VARCHAR2_TABLE_100
342: , p4_a52 JTF_VARCHAR2_TABLE_100
343: , p4_a53 JTF_VARCHAR2_TABLE_100
344: , p4_a54 JTF_NUMBER_TABLE
345: , p4_a55 JTF_NUMBER_TABLE
346: , p4_a56 JTF_VARCHAR2_TABLE_100
347: , p4_a57 JTF_VARCHAR2_TABLE_100

Line 346: , p4_a56 JTF_VARCHAR2_TABLE_100

342: , p4_a52 JTF_VARCHAR2_TABLE_100
343: , p4_a53 JTF_VARCHAR2_TABLE_100
344: , p4_a54 JTF_NUMBER_TABLE
345: , p4_a55 JTF_NUMBER_TABLE
346: , p4_a56 JTF_VARCHAR2_TABLE_100
347: , p4_a57 JTF_VARCHAR2_TABLE_100
348: , p4_a58 JTF_VARCHAR2_TABLE_100
349: , p4_a59 JTF_VARCHAR2_TABLE_100
350: , p_check_access_flag VARCHAR2

Line 347: , p4_a57 JTF_VARCHAR2_TABLE_100

343: , p4_a53 JTF_VARCHAR2_TABLE_100
344: , p4_a54 JTF_NUMBER_TABLE
345: , p4_a55 JTF_NUMBER_TABLE
346: , p4_a56 JTF_VARCHAR2_TABLE_100
347: , p4_a57 JTF_VARCHAR2_TABLE_100
348: , p4_a58 JTF_VARCHAR2_TABLE_100
349: , p4_a59 JTF_VARCHAR2_TABLE_100
350: , p_check_access_flag VARCHAR2
351: , p_admin_flag VARCHAR2

Line 348: , p4_a58 JTF_VARCHAR2_TABLE_100

344: , p4_a54 JTF_NUMBER_TABLE
345: , p4_a55 JTF_NUMBER_TABLE
346: , p4_a56 JTF_VARCHAR2_TABLE_100
347: , p4_a57 JTF_VARCHAR2_TABLE_100
348: , p4_a58 JTF_VARCHAR2_TABLE_100
349: , p4_a59 JTF_VARCHAR2_TABLE_100
350: , p_check_access_flag VARCHAR2
351: , p_admin_flag VARCHAR2
352: , p_admin_group_id NUMBER

Line 349: , p4_a59 JTF_VARCHAR2_TABLE_100

345: , p4_a55 JTF_NUMBER_TABLE
346: , p4_a56 JTF_VARCHAR2_TABLE_100
347: , p4_a57 JTF_VARCHAR2_TABLE_100
348: , p4_a58 JTF_VARCHAR2_TABLE_100
349: , p4_a59 JTF_VARCHAR2_TABLE_100
350: , p_check_access_flag VARCHAR2
351: , p_admin_flag VARCHAR2
352: , p_admin_group_id NUMBER
353: , p_identity_salesforce_id NUMBER

Line 355: , p10_a0 JTF_VARCHAR2_TABLE_100

351: , p_admin_flag VARCHAR2
352: , p_admin_group_id NUMBER
353: , p_identity_salesforce_id NUMBER
354: , p_partner_cont_party_id NUMBER
355: , p10_a0 JTF_VARCHAR2_TABLE_100
356: , p10_a1 JTF_VARCHAR2_TABLE_300
357: , x_return_status out nocopy VARCHAR2
358: , x_msg_count out nocopy NUMBER
359: , x_msg_data out nocopy VARCHAR2

Line 381: , p20_a0 JTF_VARCHAR2_TABLE_100

377: , p_admin_group_id NUMBER
378: , p_identity_salesforce_id NUMBER
379: , p_salesgroup_id NUMBER
380: , p_partner_cont_party_id NUMBER
381: , p20_a0 JTF_VARCHAR2_TABLE_100
382: , p20_a1 JTF_VARCHAR2_TABLE_300
383: , x_return_status out nocopy VARCHAR2
384: , x_msg_count out nocopy NUMBER
385: , x_msg_data out nocopy VARCHAR2

Line 388: procedure get_access_profiles(p0_a0 JTF_VARCHAR2_TABLE_100

384: , x_msg_count out nocopy NUMBER
385: , x_msg_data out nocopy VARCHAR2
386: , x_lead_id out nocopy NUMBER
387: );
388: procedure get_access_profiles(p0_a0 JTF_VARCHAR2_TABLE_100
389: , p0_a1 JTF_VARCHAR2_TABLE_300
390: , p1_a0 out nocopy VARCHAR2
391: , p1_a1 out nocopy VARCHAR2
392: , p1_a2 out nocopy VARCHAR2

Line 396: function get_profile(p0_a0 JTF_VARCHAR2_TABLE_100

392: , p1_a2 out nocopy VARCHAR2
393: , p1_a3 out nocopy VARCHAR2
394: , p1_a4 out nocopy VARCHAR2
395: );
396: function get_profile(p0_a0 JTF_VARCHAR2_TABLE_100
397: , p0_a1 JTF_VARCHAR2_TABLE_300
398: , p_profile_name VARCHAR2
399: ) return varchar2;
400: end as_opportunity_pub_w4;