DBA Data[Home] [Help]

APPS.OKL_ETH_PVT_W dependencies on JTF_DATE_TABLE

Line 14: , a11 JTF_DATE_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500

Line 15: , a12 JTF_DATE_TABLE

11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500

Line 33: , a30 JTF_DATE_TABLE

29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );

Line 35: , a32 JTF_DATE_TABLE

31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE

Line 49: , a11 out nocopy JTF_DATE_TABLE

45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_VARCHAR2_TABLE_100
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_DATE_TABLE
50: , a12 out nocopy JTF_DATE_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500
53: , a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 50: , a12 out nocopy JTF_DATE_TABLE

46: , a8 out nocopy JTF_VARCHAR2_TABLE_100
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_DATE_TABLE
50: , a12 out nocopy JTF_DATE_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500
53: , a15 out nocopy JTF_VARCHAR2_TABLE_500
54: , a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 68: , a30 out nocopy JTF_DATE_TABLE

64: , a26 out nocopy JTF_VARCHAR2_TABLE_500
65: , a27 out nocopy JTF_VARCHAR2_TABLE_500
66: , a28 out nocopy JTF_VARCHAR2_TABLE_500
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );

Line 70: , a32 out nocopy JTF_DATE_TABLE

66: , a28 out nocopy JTF_VARCHAR2_TABLE_500
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE

Line 84: , a10 JTF_DATE_TABLE

80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_VARCHAR2_TABLE_100
82: , a8 JTF_NUMBER_TABLE
83: , a9 JTF_VARCHAR2_TABLE_100
84: , a10 JTF_DATE_TABLE
85: , a11 JTF_DATE_TABLE
86: , a12 JTF_VARCHAR2_TABLE_100
87: , a13 JTF_VARCHAR2_TABLE_500
88: , a14 JTF_VARCHAR2_TABLE_500

Line 85: , a11 JTF_DATE_TABLE

81: , a7 JTF_VARCHAR2_TABLE_100
82: , a8 JTF_NUMBER_TABLE
83: , a9 JTF_VARCHAR2_TABLE_100
84: , a10 JTF_DATE_TABLE
85: , a11 JTF_DATE_TABLE
86: , a12 JTF_VARCHAR2_TABLE_100
87: , a13 JTF_VARCHAR2_TABLE_500
88: , a14 JTF_VARCHAR2_TABLE_500
89: , a15 JTF_VARCHAR2_TABLE_500

Line 103: , a29 JTF_DATE_TABLE

99: , a25 JTF_VARCHAR2_TABLE_500
100: , a26 JTF_VARCHAR2_TABLE_500
101: , a27 JTF_VARCHAR2_TABLE_500
102: , a28 JTF_NUMBER_TABLE
103: , a29 JTF_DATE_TABLE
104: , a30 JTF_NUMBER_TABLE
105: , a31 JTF_DATE_TABLE
106: , a32 JTF_NUMBER_TABLE
107: );

Line 105: , a31 JTF_DATE_TABLE

101: , a27 JTF_VARCHAR2_TABLE_500
102: , a28 JTF_NUMBER_TABLE
103: , a29 JTF_DATE_TABLE
104: , a30 JTF_NUMBER_TABLE
105: , a31 JTF_DATE_TABLE
106: , a32 JTF_NUMBER_TABLE
107: );
108: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
109: , a1 out nocopy JTF_NUMBER_TABLE

Line 118: , a10 out nocopy JTF_DATE_TABLE

114: , a6 out nocopy JTF_NUMBER_TABLE
115: , a7 out nocopy JTF_VARCHAR2_TABLE_100
116: , a8 out nocopy JTF_NUMBER_TABLE
117: , a9 out nocopy JTF_VARCHAR2_TABLE_100
118: , a10 out nocopy JTF_DATE_TABLE
119: , a11 out nocopy JTF_DATE_TABLE
120: , a12 out nocopy JTF_VARCHAR2_TABLE_100
121: , a13 out nocopy JTF_VARCHAR2_TABLE_500
122: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 119: , a11 out nocopy JTF_DATE_TABLE

115: , a7 out nocopy JTF_VARCHAR2_TABLE_100
116: , a8 out nocopy JTF_NUMBER_TABLE
117: , a9 out nocopy JTF_VARCHAR2_TABLE_100
118: , a10 out nocopy JTF_DATE_TABLE
119: , a11 out nocopy JTF_DATE_TABLE
120: , a12 out nocopy JTF_VARCHAR2_TABLE_100
121: , a13 out nocopy JTF_VARCHAR2_TABLE_500
122: , a14 out nocopy JTF_VARCHAR2_TABLE_500
123: , a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 137: , a29 out nocopy JTF_DATE_TABLE

133: , a25 out nocopy JTF_VARCHAR2_TABLE_500
134: , a26 out nocopy JTF_VARCHAR2_TABLE_500
135: , a27 out nocopy JTF_VARCHAR2_TABLE_500
136: , a28 out nocopy JTF_NUMBER_TABLE
137: , a29 out nocopy JTF_DATE_TABLE
138: , a30 out nocopy JTF_NUMBER_TABLE
139: , a31 out nocopy JTF_DATE_TABLE
140: , a32 out nocopy JTF_NUMBER_TABLE
141: );

Line 139: , a31 out nocopy JTF_DATE_TABLE

135: , a27 out nocopy JTF_VARCHAR2_TABLE_500
136: , a28 out nocopy JTF_NUMBER_TABLE
137: , a29 out nocopy JTF_DATE_TABLE
138: , a30 out nocopy JTF_NUMBER_TABLE
139: , a31 out nocopy JTF_DATE_TABLE
140: , a32 out nocopy JTF_NUMBER_TABLE
141: );
142:
143: procedure rosetta_table_copy_in_p5(t out nocopy okl_eth_pvt.okl_ethtl_tbl, a0 JTF_NUMBER_TABLE

Line 149: , a6 JTF_DATE_TABLE

145: , a2 JTF_VARCHAR2_TABLE_100
146: , a3 JTF_VARCHAR2_TABLE_100
147: , a4 JTF_VARCHAR2_TABLE_100
148: , a5 JTF_NUMBER_TABLE
149: , a6 JTF_DATE_TABLE
150: , a7 JTF_NUMBER_TABLE
151: , a8 JTF_DATE_TABLE
152: , a9 JTF_NUMBER_TABLE
153: );

Line 151: , a8 JTF_DATE_TABLE

147: , a4 JTF_VARCHAR2_TABLE_100
148: , a5 JTF_NUMBER_TABLE
149: , a6 JTF_DATE_TABLE
150: , a7 JTF_NUMBER_TABLE
151: , a8 JTF_DATE_TABLE
152: , a9 JTF_NUMBER_TABLE
153: );
154: procedure rosetta_table_copy_out_p5(t okl_eth_pvt.okl_ethtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
155: , a1 out nocopy JTF_VARCHAR2_TABLE_2000

Line 160: , a6 out nocopy JTF_DATE_TABLE

156: , a2 out nocopy JTF_VARCHAR2_TABLE_100
157: , a3 out nocopy JTF_VARCHAR2_TABLE_100
158: , a4 out nocopy JTF_VARCHAR2_TABLE_100
159: , a5 out nocopy JTF_NUMBER_TABLE
160: , a6 out nocopy JTF_DATE_TABLE
161: , a7 out nocopy JTF_NUMBER_TABLE
162: , a8 out nocopy JTF_DATE_TABLE
163: , a9 out nocopy JTF_NUMBER_TABLE
164: );

Line 162: , a8 out nocopy JTF_DATE_TABLE

158: , a4 out nocopy JTF_VARCHAR2_TABLE_100
159: , a5 out nocopy JTF_NUMBER_TABLE
160: , a6 out nocopy JTF_DATE_TABLE
161: , a7 out nocopy JTF_NUMBER_TABLE
162: , a8 out nocopy JTF_DATE_TABLE
163: , a9 out nocopy JTF_NUMBER_TABLE
164: );
165:
166: procedure insert_row(p_api_version NUMBER

Line 256: , p5_a11 JTF_DATE_TABLE

252: , p5_a7 JTF_NUMBER_TABLE
253: , p5_a8 JTF_VARCHAR2_TABLE_100
254: , p5_a9 JTF_NUMBER_TABLE
255: , p5_a10 JTF_VARCHAR2_TABLE_100
256: , p5_a11 JTF_DATE_TABLE
257: , p5_a12 JTF_DATE_TABLE
258: , p5_a13 JTF_VARCHAR2_TABLE_100
259: , p5_a14 JTF_VARCHAR2_TABLE_500
260: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 257: , p5_a12 JTF_DATE_TABLE

253: , p5_a8 JTF_VARCHAR2_TABLE_100
254: , p5_a9 JTF_NUMBER_TABLE
255: , p5_a10 JTF_VARCHAR2_TABLE_100
256: , p5_a11 JTF_DATE_TABLE
257: , p5_a12 JTF_DATE_TABLE
258: , p5_a13 JTF_VARCHAR2_TABLE_100
259: , p5_a14 JTF_VARCHAR2_TABLE_500
260: , p5_a15 JTF_VARCHAR2_TABLE_500
261: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 275: , p5_a30 JTF_DATE_TABLE

271: , p5_a26 JTF_VARCHAR2_TABLE_500
272: , p5_a27 JTF_VARCHAR2_TABLE_500
273: , p5_a28 JTF_VARCHAR2_TABLE_500
274: , p5_a29 JTF_NUMBER_TABLE
275: , p5_a30 JTF_DATE_TABLE
276: , p5_a31 JTF_NUMBER_TABLE
277: , p5_a32 JTF_DATE_TABLE
278: , p5_a33 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 277: , p5_a32 JTF_DATE_TABLE

273: , p5_a28 JTF_VARCHAR2_TABLE_500
274: , p5_a29 JTF_NUMBER_TABLE
275: , p5_a30 JTF_DATE_TABLE
276: , p5_a31 JTF_NUMBER_TABLE
277: , p5_a32 JTF_DATE_TABLE
278: , p5_a33 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 290: , p6_a11 out nocopy JTF_DATE_TABLE

286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a9 out nocopy JTF_NUMBER_TABLE
289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a11 out nocopy JTF_DATE_TABLE
291: , p6_a12 out nocopy JTF_DATE_TABLE
292: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
293: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
294: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 291: , p6_a12 out nocopy JTF_DATE_TABLE

287: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a9 out nocopy JTF_NUMBER_TABLE
289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a11 out nocopy JTF_DATE_TABLE
291: , p6_a12 out nocopy JTF_DATE_TABLE
292: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
293: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
294: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
295: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 309: , p6_a30 out nocopy JTF_DATE_TABLE

305: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
306: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
307: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
308: , p6_a29 out nocopy JTF_NUMBER_TABLE
309: , p6_a30 out nocopy JTF_DATE_TABLE
310: , p6_a31 out nocopy JTF_NUMBER_TABLE
311: , p6_a32 out nocopy JTF_DATE_TABLE
312: , p6_a33 out nocopy JTF_NUMBER_TABLE
313: );

Line 311: , p6_a32 out nocopy JTF_DATE_TABLE

307: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
308: , p6_a29 out nocopy JTF_NUMBER_TABLE
309: , p6_a30 out nocopy JTF_DATE_TABLE
310: , p6_a31 out nocopy JTF_NUMBER_TABLE
311: , p6_a32 out nocopy JTF_DATE_TABLE
312: , p6_a33 out nocopy JTF_NUMBER_TABLE
313: );
314: procedure update_row(p_api_version NUMBER
315: , p_init_msg_list VARCHAR2

Line 404: , p5_a11 JTF_DATE_TABLE

400: , p5_a7 JTF_NUMBER_TABLE
401: , p5_a8 JTF_VARCHAR2_TABLE_100
402: , p5_a9 JTF_NUMBER_TABLE
403: , p5_a10 JTF_VARCHAR2_TABLE_100
404: , p5_a11 JTF_DATE_TABLE
405: , p5_a12 JTF_DATE_TABLE
406: , p5_a13 JTF_VARCHAR2_TABLE_100
407: , p5_a14 JTF_VARCHAR2_TABLE_500
408: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 405: , p5_a12 JTF_DATE_TABLE

401: , p5_a8 JTF_VARCHAR2_TABLE_100
402: , p5_a9 JTF_NUMBER_TABLE
403: , p5_a10 JTF_VARCHAR2_TABLE_100
404: , p5_a11 JTF_DATE_TABLE
405: , p5_a12 JTF_DATE_TABLE
406: , p5_a13 JTF_VARCHAR2_TABLE_100
407: , p5_a14 JTF_VARCHAR2_TABLE_500
408: , p5_a15 JTF_VARCHAR2_TABLE_500
409: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 423: , p5_a30 JTF_DATE_TABLE

419: , p5_a26 JTF_VARCHAR2_TABLE_500
420: , p5_a27 JTF_VARCHAR2_TABLE_500
421: , p5_a28 JTF_VARCHAR2_TABLE_500
422: , p5_a29 JTF_NUMBER_TABLE
423: , p5_a30 JTF_DATE_TABLE
424: , p5_a31 JTF_NUMBER_TABLE
425: , p5_a32 JTF_DATE_TABLE
426: , p5_a33 JTF_NUMBER_TABLE
427: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 425: , p5_a32 JTF_DATE_TABLE

421: , p5_a28 JTF_VARCHAR2_TABLE_500
422: , p5_a29 JTF_NUMBER_TABLE
423: , p5_a30 JTF_DATE_TABLE
424: , p5_a31 JTF_NUMBER_TABLE
425: , p5_a32 JTF_DATE_TABLE
426: , p5_a33 JTF_NUMBER_TABLE
427: , p6_a0 out nocopy JTF_NUMBER_TABLE
428: , p6_a1 out nocopy JTF_NUMBER_TABLE
429: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 438: , p6_a11 out nocopy JTF_DATE_TABLE

434: , p6_a7 out nocopy JTF_NUMBER_TABLE
435: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
436: , p6_a9 out nocopy JTF_NUMBER_TABLE
437: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
438: , p6_a11 out nocopy JTF_DATE_TABLE
439: , p6_a12 out nocopy JTF_DATE_TABLE
440: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
441: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500

Line 439: , p6_a12 out nocopy JTF_DATE_TABLE

435: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
436: , p6_a9 out nocopy JTF_NUMBER_TABLE
437: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
438: , p6_a11 out nocopy JTF_DATE_TABLE
439: , p6_a12 out nocopy JTF_DATE_TABLE
440: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
441: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
443: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500

Line 457: , p6_a30 out nocopy JTF_DATE_TABLE

453: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
454: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
455: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
456: , p6_a29 out nocopy JTF_NUMBER_TABLE
457: , p6_a30 out nocopy JTF_DATE_TABLE
458: , p6_a31 out nocopy JTF_NUMBER_TABLE
459: , p6_a32 out nocopy JTF_DATE_TABLE
460: , p6_a33 out nocopy JTF_NUMBER_TABLE
461: );

Line 459: , p6_a32 out nocopy JTF_DATE_TABLE

455: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
456: , p6_a29 out nocopy JTF_NUMBER_TABLE
457: , p6_a30 out nocopy JTF_DATE_TABLE
458: , p6_a31 out nocopy JTF_NUMBER_TABLE
459: , p6_a32 out nocopy JTF_DATE_TABLE
460: , p6_a33 out nocopy JTF_NUMBER_TABLE
461: );
462: procedure delete_row(p_api_version NUMBER
463: , p_init_msg_list VARCHAR2

Line 518: , p5_a11 JTF_DATE_TABLE

514: , p5_a7 JTF_NUMBER_TABLE
515: , p5_a8 JTF_VARCHAR2_TABLE_100
516: , p5_a9 JTF_NUMBER_TABLE
517: , p5_a10 JTF_VARCHAR2_TABLE_100
518: , p5_a11 JTF_DATE_TABLE
519: , p5_a12 JTF_DATE_TABLE
520: , p5_a13 JTF_VARCHAR2_TABLE_100
521: , p5_a14 JTF_VARCHAR2_TABLE_500
522: , p5_a15 JTF_VARCHAR2_TABLE_500

Line 519: , p5_a12 JTF_DATE_TABLE

515: , p5_a8 JTF_VARCHAR2_TABLE_100
516: , p5_a9 JTF_NUMBER_TABLE
517: , p5_a10 JTF_VARCHAR2_TABLE_100
518: , p5_a11 JTF_DATE_TABLE
519: , p5_a12 JTF_DATE_TABLE
520: , p5_a13 JTF_VARCHAR2_TABLE_100
521: , p5_a14 JTF_VARCHAR2_TABLE_500
522: , p5_a15 JTF_VARCHAR2_TABLE_500
523: , p5_a16 JTF_VARCHAR2_TABLE_500

Line 537: , p5_a30 JTF_DATE_TABLE

533: , p5_a26 JTF_VARCHAR2_TABLE_500
534: , p5_a27 JTF_VARCHAR2_TABLE_500
535: , p5_a28 JTF_VARCHAR2_TABLE_500
536: , p5_a29 JTF_NUMBER_TABLE
537: , p5_a30 JTF_DATE_TABLE
538: , p5_a31 JTF_NUMBER_TABLE
539: , p5_a32 JTF_DATE_TABLE
540: , p5_a33 JTF_NUMBER_TABLE
541: );

Line 539: , p5_a32 JTF_DATE_TABLE

535: , p5_a28 JTF_VARCHAR2_TABLE_500
536: , p5_a29 JTF_NUMBER_TABLE
537: , p5_a30 JTF_DATE_TABLE
538: , p5_a31 JTF_NUMBER_TABLE
539: , p5_a32 JTF_DATE_TABLE
540: , p5_a33 JTF_NUMBER_TABLE
541: );
542: end okl_eth_pvt_w;