DBA Data[Home] [Help]

APPS.OKL_ASSET_CNDTNS_PUB_W dependencies on JTF_DATE_TABLE

Line 15: , p5_a7 JTF_DATE_TABLE

11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_NUMBER_TABLE
15: , p5_a7 JTF_DATE_TABLE
16: , p5_a8 JTF_VARCHAR2_TABLE_100
17: , p5_a9 JTF_VARCHAR2_TABLE_500
18: , p5_a10 JTF_VARCHAR2_TABLE_500
19: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 36: , p5_a28 JTF_DATE_TABLE

32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p5_a26 JTF_NUMBER_TABLE
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: , p5_a32 JTF_DATE_TABLE

Line 38: , p5_a30 JTF_DATE_TABLE

34: , p5_a26 JTF_NUMBER_TABLE
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: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 40: , p5_a32 JTF_DATE_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: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p6_a0 out nocopy JTF_NUMBER_TABLE
43: , p6_a1 out nocopy JTF_NUMBER_TABLE
44: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , p6_a7 out nocopy JTF_DATE_TABLE

45: , p6_a3 out nocopy JTF_NUMBER_TABLE
46: , p6_a4 out nocopy JTF_NUMBER_TABLE
47: , p6_a5 out nocopy JTF_NUMBER_TABLE
48: , p6_a6 out nocopy JTF_NUMBER_TABLE
49: , p6_a7 out nocopy JTF_DATE_TABLE
50: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
51: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
52: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
53: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 70: , p6_a28 out nocopy JTF_DATE_TABLE

66: , p6_a24 out nocopy JTF_NUMBER_TABLE
67: , p6_a25 out nocopy JTF_NUMBER_TABLE
68: , p6_a26 out nocopy JTF_NUMBER_TABLE
69: , p6_a27 out nocopy JTF_NUMBER_TABLE
70: , p6_a28 out nocopy JTF_DATE_TABLE
71: , p6_a29 out nocopy JTF_NUMBER_TABLE
72: , p6_a30 out nocopy JTF_DATE_TABLE
73: , p6_a31 out nocopy JTF_NUMBER_TABLE
74: , p6_a32 out nocopy JTF_DATE_TABLE

Line 72: , p6_a30 out nocopy JTF_DATE_TABLE

68: , p6_a26 out nocopy JTF_NUMBER_TABLE
69: , p6_a27 out nocopy JTF_NUMBER_TABLE
70: , p6_a28 out nocopy JTF_DATE_TABLE
71: , p6_a29 out nocopy JTF_NUMBER_TABLE
72: , p6_a30 out nocopy JTF_DATE_TABLE
73: , p6_a31 out nocopy JTF_NUMBER_TABLE
74: , p6_a32 out nocopy JTF_DATE_TABLE
75: , p6_a33 out nocopy JTF_NUMBER_TABLE
76: );

Line 74: , p6_a32 out nocopy JTF_DATE_TABLE

70: , p6_a28 out nocopy JTF_DATE_TABLE
71: , p6_a29 out nocopy JTF_NUMBER_TABLE
72: , p6_a30 out nocopy JTF_DATE_TABLE
73: , p6_a31 out nocopy JTF_NUMBER_TABLE
74: , p6_a32 out nocopy JTF_DATE_TABLE
75: , p6_a33 out nocopy JTF_NUMBER_TABLE
76: );
77: procedure insert_asset_cndtns(p_api_version NUMBER
78: , p_init_msg_list VARCHAR2

Line 163: , p5_a7 JTF_DATE_TABLE

159: , p5_a3 JTF_NUMBER_TABLE
160: , p5_a4 JTF_NUMBER_TABLE
161: , p5_a5 JTF_NUMBER_TABLE
162: , p5_a6 JTF_NUMBER_TABLE
163: , p5_a7 JTF_DATE_TABLE
164: , p5_a8 JTF_VARCHAR2_TABLE_100
165: , p5_a9 JTF_VARCHAR2_TABLE_500
166: , p5_a10 JTF_VARCHAR2_TABLE_500
167: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 184: , p5_a28 JTF_DATE_TABLE

180: , p5_a24 JTF_NUMBER_TABLE
181: , p5_a25 JTF_NUMBER_TABLE
182: , p5_a26 JTF_NUMBER_TABLE
183: , p5_a27 JTF_NUMBER_TABLE
184: , p5_a28 JTF_DATE_TABLE
185: , p5_a29 JTF_NUMBER_TABLE
186: , p5_a30 JTF_DATE_TABLE
187: , p5_a31 JTF_NUMBER_TABLE
188: , p5_a32 JTF_DATE_TABLE

Line 186: , p5_a30 JTF_DATE_TABLE

182: , p5_a26 JTF_NUMBER_TABLE
183: , p5_a27 JTF_NUMBER_TABLE
184: , p5_a28 JTF_DATE_TABLE
185: , p5_a29 JTF_NUMBER_TABLE
186: , p5_a30 JTF_DATE_TABLE
187: , p5_a31 JTF_NUMBER_TABLE
188: , p5_a32 JTF_DATE_TABLE
189: , p5_a33 JTF_NUMBER_TABLE
190: );

Line 188: , p5_a32 JTF_DATE_TABLE

184: , p5_a28 JTF_DATE_TABLE
185: , p5_a29 JTF_NUMBER_TABLE
186: , p5_a30 JTF_DATE_TABLE
187: , p5_a31 JTF_NUMBER_TABLE
188: , p5_a32 JTF_DATE_TABLE
189: , p5_a33 JTF_NUMBER_TABLE
190: );
191: procedure lock_asset_cndtns(p_api_version NUMBER
192: , p_init_msg_list VARCHAR2

Line 243: , p5_a7 JTF_DATE_TABLE

239: , p5_a3 JTF_NUMBER_TABLE
240: , p5_a4 JTF_NUMBER_TABLE
241: , p5_a5 JTF_NUMBER_TABLE
242: , p5_a6 JTF_NUMBER_TABLE
243: , p5_a7 JTF_DATE_TABLE
244: , p5_a8 JTF_VARCHAR2_TABLE_100
245: , p5_a9 JTF_VARCHAR2_TABLE_500
246: , p5_a10 JTF_VARCHAR2_TABLE_500
247: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 264: , p5_a28 JTF_DATE_TABLE

260: , p5_a24 JTF_NUMBER_TABLE
261: , p5_a25 JTF_NUMBER_TABLE
262: , p5_a26 JTF_NUMBER_TABLE
263: , p5_a27 JTF_NUMBER_TABLE
264: , p5_a28 JTF_DATE_TABLE
265: , p5_a29 JTF_NUMBER_TABLE
266: , p5_a30 JTF_DATE_TABLE
267: , p5_a31 JTF_NUMBER_TABLE
268: , p5_a32 JTF_DATE_TABLE

Line 266: , p5_a30 JTF_DATE_TABLE

262: , p5_a26 JTF_NUMBER_TABLE
263: , p5_a27 JTF_NUMBER_TABLE
264: , p5_a28 JTF_DATE_TABLE
265: , p5_a29 JTF_NUMBER_TABLE
266: , p5_a30 JTF_DATE_TABLE
267: , p5_a31 JTF_NUMBER_TABLE
268: , p5_a32 JTF_DATE_TABLE
269: , p5_a33 JTF_NUMBER_TABLE
270: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 268: , p5_a32 JTF_DATE_TABLE

264: , p5_a28 JTF_DATE_TABLE
265: , p5_a29 JTF_NUMBER_TABLE
266: , p5_a30 JTF_DATE_TABLE
267: , p5_a31 JTF_NUMBER_TABLE
268: , p5_a32 JTF_DATE_TABLE
269: , p5_a33 JTF_NUMBER_TABLE
270: , p6_a0 out nocopy JTF_NUMBER_TABLE
271: , p6_a1 out nocopy JTF_NUMBER_TABLE
272: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 277: , p6_a7 out nocopy JTF_DATE_TABLE

273: , p6_a3 out nocopy JTF_NUMBER_TABLE
274: , p6_a4 out nocopy JTF_NUMBER_TABLE
275: , p6_a5 out nocopy JTF_NUMBER_TABLE
276: , p6_a6 out nocopy JTF_NUMBER_TABLE
277: , p6_a7 out nocopy JTF_DATE_TABLE
278: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
279: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
280: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
281: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 298: , p6_a28 out nocopy JTF_DATE_TABLE

294: , p6_a24 out nocopy JTF_NUMBER_TABLE
295: , p6_a25 out nocopy JTF_NUMBER_TABLE
296: , p6_a26 out nocopy JTF_NUMBER_TABLE
297: , p6_a27 out nocopy JTF_NUMBER_TABLE
298: , p6_a28 out nocopy JTF_DATE_TABLE
299: , p6_a29 out nocopy JTF_NUMBER_TABLE
300: , p6_a30 out nocopy JTF_DATE_TABLE
301: , p6_a31 out nocopy JTF_NUMBER_TABLE
302: , p6_a32 out nocopy JTF_DATE_TABLE

Line 300: , p6_a30 out nocopy JTF_DATE_TABLE

296: , p6_a26 out nocopy JTF_NUMBER_TABLE
297: , p6_a27 out nocopy JTF_NUMBER_TABLE
298: , p6_a28 out nocopy JTF_DATE_TABLE
299: , p6_a29 out nocopy JTF_NUMBER_TABLE
300: , p6_a30 out nocopy JTF_DATE_TABLE
301: , p6_a31 out nocopy JTF_NUMBER_TABLE
302: , p6_a32 out nocopy JTF_DATE_TABLE
303: , p6_a33 out nocopy JTF_NUMBER_TABLE
304: );

Line 302: , p6_a32 out nocopy JTF_DATE_TABLE

298: , p6_a28 out nocopy JTF_DATE_TABLE
299: , p6_a29 out nocopy JTF_NUMBER_TABLE
300: , p6_a30 out nocopy JTF_DATE_TABLE
301: , p6_a31 out nocopy JTF_NUMBER_TABLE
302: , p6_a32 out nocopy JTF_DATE_TABLE
303: , p6_a33 out nocopy JTF_NUMBER_TABLE
304: );
305: procedure update_asset_cndtns(p_api_version NUMBER
306: , p_init_msg_list VARCHAR2

Line 391: , p5_a7 JTF_DATE_TABLE

387: , p5_a3 JTF_NUMBER_TABLE
388: , p5_a4 JTF_NUMBER_TABLE
389: , p5_a5 JTF_NUMBER_TABLE
390: , p5_a6 JTF_NUMBER_TABLE
391: , p5_a7 JTF_DATE_TABLE
392: , p5_a8 JTF_VARCHAR2_TABLE_100
393: , p5_a9 JTF_VARCHAR2_TABLE_500
394: , p5_a10 JTF_VARCHAR2_TABLE_500
395: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 412: , p5_a28 JTF_DATE_TABLE

408: , p5_a24 JTF_NUMBER_TABLE
409: , p5_a25 JTF_NUMBER_TABLE
410: , p5_a26 JTF_NUMBER_TABLE
411: , p5_a27 JTF_NUMBER_TABLE
412: , p5_a28 JTF_DATE_TABLE
413: , p5_a29 JTF_NUMBER_TABLE
414: , p5_a30 JTF_DATE_TABLE
415: , p5_a31 JTF_NUMBER_TABLE
416: , p5_a32 JTF_DATE_TABLE

Line 414: , p5_a30 JTF_DATE_TABLE

410: , p5_a26 JTF_NUMBER_TABLE
411: , p5_a27 JTF_NUMBER_TABLE
412: , p5_a28 JTF_DATE_TABLE
413: , p5_a29 JTF_NUMBER_TABLE
414: , p5_a30 JTF_DATE_TABLE
415: , p5_a31 JTF_NUMBER_TABLE
416: , p5_a32 JTF_DATE_TABLE
417: , p5_a33 JTF_NUMBER_TABLE
418: );

Line 416: , p5_a32 JTF_DATE_TABLE

412: , p5_a28 JTF_DATE_TABLE
413: , p5_a29 JTF_NUMBER_TABLE
414: , p5_a30 JTF_DATE_TABLE
415: , p5_a31 JTF_NUMBER_TABLE
416: , p5_a32 JTF_DATE_TABLE
417: , p5_a33 JTF_NUMBER_TABLE
418: );
419: procedure delete_asset_cndtns(p_api_version NUMBER
420: , p_init_msg_list VARCHAR2

Line 471: , p5_a7 JTF_DATE_TABLE

467: , p5_a3 JTF_NUMBER_TABLE
468: , p5_a4 JTF_NUMBER_TABLE
469: , p5_a5 JTF_NUMBER_TABLE
470: , p5_a6 JTF_NUMBER_TABLE
471: , p5_a7 JTF_DATE_TABLE
472: , p5_a8 JTF_VARCHAR2_TABLE_100
473: , p5_a9 JTF_VARCHAR2_TABLE_500
474: , p5_a10 JTF_VARCHAR2_TABLE_500
475: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 492: , p5_a28 JTF_DATE_TABLE

488: , p5_a24 JTF_NUMBER_TABLE
489: , p5_a25 JTF_NUMBER_TABLE
490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_NUMBER_TABLE
492: , p5_a28 JTF_DATE_TABLE
493: , p5_a29 JTF_NUMBER_TABLE
494: , p5_a30 JTF_DATE_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_DATE_TABLE

Line 494: , p5_a30 JTF_DATE_TABLE

490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_NUMBER_TABLE
492: , p5_a28 JTF_DATE_TABLE
493: , p5_a29 JTF_NUMBER_TABLE
494: , p5_a30 JTF_DATE_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_DATE_TABLE
497: , p5_a33 JTF_NUMBER_TABLE
498: );

Line 496: , p5_a32 JTF_DATE_TABLE

492: , p5_a28 JTF_DATE_TABLE
493: , p5_a29 JTF_NUMBER_TABLE
494: , p5_a30 JTF_DATE_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_DATE_TABLE
497: , p5_a33 JTF_NUMBER_TABLE
498: );
499: procedure validate_asset_cndtns(p_api_version NUMBER
500: , p_init_msg_list VARCHAR2