DBA Data[Home] [Help]

APPS.OKL_PRTFL_CONTRACTS_PUB_W dependencies on JTF_DATE_TABLE

Line 18: , p5_a10 JTF_DATE_TABLE

14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_DATE_TABLE
19: , p5_a11 JTF_VARCHAR2_TABLE_300
20: , p5_a12 JTF_VARCHAR2_TABLE_300
21: , p5_a13 JTF_VARCHAR2_TABLE_300
22: , p5_a14 JTF_VARCHAR2_TABLE_300

Line 36: , p5_a28 JTF_DATE_TABLE

32: , p5_a24 JTF_VARCHAR2_TABLE_300
33: , p5_a25 JTF_VARCHAR2_TABLE_300
34: , p5_a26 JTF_VARCHAR2_TABLE_300
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_DATE_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 38: , p5_a30 JTF_DATE_TABLE

34: , p5_a26 JTF_VARCHAR2_TABLE_300
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_DATE_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p6_a0 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 50: , p6_a10 out nocopy JTF_DATE_TABLE

46: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
47: , p6_a7 out nocopy JTF_NUMBER_TABLE
48: , p6_a8 out nocopy JTF_NUMBER_TABLE
49: , p6_a9 out nocopy JTF_NUMBER_TABLE
50: , p6_a10 out nocopy JTF_DATE_TABLE
51: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
52: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
53: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
54: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300

Line 68: , p6_a28 out nocopy JTF_DATE_TABLE

64: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
65: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
66: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
67: , p6_a27 out nocopy JTF_NUMBER_TABLE
68: , p6_a28 out nocopy JTF_DATE_TABLE
69: , p6_a29 out nocopy JTF_NUMBER_TABLE
70: , p6_a30 out nocopy JTF_DATE_TABLE
71: , p6_a31 out nocopy JTF_NUMBER_TABLE
72: );

Line 70: , p6_a30 out nocopy JTF_DATE_TABLE

66: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
67: , p6_a27 out nocopy JTF_NUMBER_TABLE
68: , p6_a28 out nocopy JTF_DATE_TABLE
69: , p6_a29 out nocopy JTF_NUMBER_TABLE
70: , p6_a30 out nocopy JTF_DATE_TABLE
71: , p6_a31 out nocopy JTF_NUMBER_TABLE
72: );
73: procedure insert_prtfl_contracts(p_api_version NUMBER
74: , p_init_msg_list VARCHAR2

Line 158: , p5_a10 JTF_DATE_TABLE

154: , p5_a6 JTF_VARCHAR2_TABLE_2000
155: , p5_a7 JTF_NUMBER_TABLE
156: , p5_a8 JTF_NUMBER_TABLE
157: , p5_a9 JTF_NUMBER_TABLE
158: , p5_a10 JTF_DATE_TABLE
159: , p5_a11 JTF_VARCHAR2_TABLE_300
160: , p5_a12 JTF_VARCHAR2_TABLE_300
161: , p5_a13 JTF_VARCHAR2_TABLE_300
162: , p5_a14 JTF_VARCHAR2_TABLE_300

Line 176: , p5_a28 JTF_DATE_TABLE

172: , p5_a24 JTF_VARCHAR2_TABLE_300
173: , p5_a25 JTF_VARCHAR2_TABLE_300
174: , p5_a26 JTF_VARCHAR2_TABLE_300
175: , p5_a27 JTF_NUMBER_TABLE
176: , p5_a28 JTF_DATE_TABLE
177: , p5_a29 JTF_NUMBER_TABLE
178: , p5_a30 JTF_DATE_TABLE
179: , p5_a31 JTF_NUMBER_TABLE
180: );

Line 178: , p5_a30 JTF_DATE_TABLE

174: , p5_a26 JTF_VARCHAR2_TABLE_300
175: , p5_a27 JTF_NUMBER_TABLE
176: , p5_a28 JTF_DATE_TABLE
177: , p5_a29 JTF_NUMBER_TABLE
178: , p5_a30 JTF_DATE_TABLE
179: , p5_a31 JTF_NUMBER_TABLE
180: );
181: procedure lock_prtfl_contracts(p_api_version NUMBER
182: , p_init_msg_list VARCHAR2

Line 234: , p5_a10 JTF_DATE_TABLE

230: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_DATE_TABLE
235: , p5_a11 JTF_VARCHAR2_TABLE_300
236: , p5_a12 JTF_VARCHAR2_TABLE_300
237: , p5_a13 JTF_VARCHAR2_TABLE_300
238: , p5_a14 JTF_VARCHAR2_TABLE_300

Line 252: , p5_a28 JTF_DATE_TABLE

248: , p5_a24 JTF_VARCHAR2_TABLE_300
249: , p5_a25 JTF_VARCHAR2_TABLE_300
250: , p5_a26 JTF_VARCHAR2_TABLE_300
251: , p5_a27 JTF_NUMBER_TABLE
252: , p5_a28 JTF_DATE_TABLE
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 254: , p5_a30 JTF_DATE_TABLE

250: , p5_a26 JTF_VARCHAR2_TABLE_300
251: , p5_a27 JTF_NUMBER_TABLE
252: , p5_a28 JTF_DATE_TABLE
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 266: , p6_a10 out nocopy JTF_DATE_TABLE

262: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
263: , p6_a7 out nocopy JTF_NUMBER_TABLE
264: , p6_a8 out nocopy JTF_NUMBER_TABLE
265: , p6_a9 out nocopy JTF_NUMBER_TABLE
266: , p6_a10 out nocopy JTF_DATE_TABLE
267: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
268: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
269: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
270: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300

Line 284: , p6_a28 out nocopy JTF_DATE_TABLE

280: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
281: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
282: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
283: , p6_a27 out nocopy JTF_NUMBER_TABLE
284: , p6_a28 out nocopy JTF_DATE_TABLE
285: , p6_a29 out nocopy JTF_NUMBER_TABLE
286: , p6_a30 out nocopy JTF_DATE_TABLE
287: , p6_a31 out nocopy JTF_NUMBER_TABLE
288: );

Line 286: , p6_a30 out nocopy JTF_DATE_TABLE

282: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
283: , p6_a27 out nocopy JTF_NUMBER_TABLE
284: , p6_a28 out nocopy JTF_DATE_TABLE
285: , p6_a29 out nocopy JTF_NUMBER_TABLE
286: , p6_a30 out nocopy JTF_DATE_TABLE
287: , p6_a31 out nocopy JTF_NUMBER_TABLE
288: );
289: procedure update_prtfl_contracts(p_api_version NUMBER
290: , p_init_msg_list VARCHAR2

Line 374: , p5_a10 JTF_DATE_TABLE

370: , p5_a6 JTF_VARCHAR2_TABLE_2000
371: , p5_a7 JTF_NUMBER_TABLE
372: , p5_a8 JTF_NUMBER_TABLE
373: , p5_a9 JTF_NUMBER_TABLE
374: , p5_a10 JTF_DATE_TABLE
375: , p5_a11 JTF_VARCHAR2_TABLE_300
376: , p5_a12 JTF_VARCHAR2_TABLE_300
377: , p5_a13 JTF_VARCHAR2_TABLE_300
378: , p5_a14 JTF_VARCHAR2_TABLE_300

Line 392: , p5_a28 JTF_DATE_TABLE

388: , p5_a24 JTF_VARCHAR2_TABLE_300
389: , p5_a25 JTF_VARCHAR2_TABLE_300
390: , p5_a26 JTF_VARCHAR2_TABLE_300
391: , p5_a27 JTF_NUMBER_TABLE
392: , p5_a28 JTF_DATE_TABLE
393: , p5_a29 JTF_NUMBER_TABLE
394: , p5_a30 JTF_DATE_TABLE
395: , p5_a31 JTF_NUMBER_TABLE
396: );

Line 394: , p5_a30 JTF_DATE_TABLE

390: , p5_a26 JTF_VARCHAR2_TABLE_300
391: , p5_a27 JTF_NUMBER_TABLE
392: , p5_a28 JTF_DATE_TABLE
393: , p5_a29 JTF_NUMBER_TABLE
394: , p5_a30 JTF_DATE_TABLE
395: , p5_a31 JTF_NUMBER_TABLE
396: );
397: procedure delete_prtfl_contracts(p_api_version NUMBER
398: , p_init_msg_list VARCHAR2

Line 450: , p5_a10 JTF_DATE_TABLE

446: , p5_a6 JTF_VARCHAR2_TABLE_2000
447: , p5_a7 JTF_NUMBER_TABLE
448: , p5_a8 JTF_NUMBER_TABLE
449: , p5_a9 JTF_NUMBER_TABLE
450: , p5_a10 JTF_DATE_TABLE
451: , p5_a11 JTF_VARCHAR2_TABLE_300
452: , p5_a12 JTF_VARCHAR2_TABLE_300
453: , p5_a13 JTF_VARCHAR2_TABLE_300
454: , p5_a14 JTF_VARCHAR2_TABLE_300

Line 468: , p5_a28 JTF_DATE_TABLE

464: , p5_a24 JTF_VARCHAR2_TABLE_300
465: , p5_a25 JTF_VARCHAR2_TABLE_300
466: , p5_a26 JTF_VARCHAR2_TABLE_300
467: , p5_a27 JTF_NUMBER_TABLE
468: , p5_a28 JTF_DATE_TABLE
469: , p5_a29 JTF_NUMBER_TABLE
470: , p5_a30 JTF_DATE_TABLE
471: , p5_a31 JTF_NUMBER_TABLE
472: );

Line 470: , p5_a30 JTF_DATE_TABLE

466: , p5_a26 JTF_VARCHAR2_TABLE_300
467: , p5_a27 JTF_NUMBER_TABLE
468: , p5_a28 JTF_DATE_TABLE
469: , p5_a29 JTF_NUMBER_TABLE
470: , p5_a30 JTF_DATE_TABLE
471: , p5_a31 JTF_NUMBER_TABLE
472: );
473: procedure validate_prtfl_contracts(p_api_version NUMBER
474: , p_init_msg_list VARCHAR2