DBA Data[Home] [Help]

APPS.OKL_SRT_PVT_W dependencies on JTF_DATE_TABLE

Line 17: , a14 JTF_DATE_TABLE

13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_500

Line 18: , a15 JTF_DATE_TABLE

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500

Line 37: , a34 JTF_DATE_TABLE

33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );

Line 39: , a36 JTF_DATE_TABLE

35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p1(t okl_srt_pvt.okl_srtv_tbl, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_300

Line 56: , a14 out nocopy JTF_DATE_TABLE

52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_VARCHAR2_TABLE_100
55: , a13 out nocopy JTF_VARCHAR2_TABLE_100
56: , a14 out nocopy JTF_DATE_TABLE
57: , a15 out nocopy JTF_DATE_TABLE
58: , a16 out nocopy JTF_NUMBER_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_100
60: , a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 57: , a15 out nocopy JTF_DATE_TABLE

53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_VARCHAR2_TABLE_100
55: , a13 out nocopy JTF_VARCHAR2_TABLE_100
56: , a14 out nocopy JTF_DATE_TABLE
57: , a15 out nocopy JTF_DATE_TABLE
58: , a16 out nocopy JTF_NUMBER_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_100
60: , a18 out nocopy JTF_VARCHAR2_TABLE_500
61: , a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 76: , a34 out nocopy JTF_DATE_TABLE

72: , a30 out nocopy JTF_VARCHAR2_TABLE_500
73: , a31 out nocopy JTF_VARCHAR2_TABLE_500
74: , a32 out nocopy JTF_VARCHAR2_TABLE_500
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );

Line 78: , a36 out nocopy JTF_DATE_TABLE

74: , a32 out nocopy JTF_VARCHAR2_TABLE_500
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p3(t out nocopy okl_srt_pvt.okl_srtb_tbl, a0 JTF_NUMBER_TABLE

Line 95: , a13 JTF_DATE_TABLE

91: , a9 JTF_VARCHAR2_TABLE_100
92: , a10 JTF_NUMBER_TABLE
93: , a11 JTF_VARCHAR2_TABLE_100
94: , a12 JTF_VARCHAR2_TABLE_100
95: , a13 JTF_DATE_TABLE
96: , a14 JTF_DATE_TABLE
97: , a15 JTF_NUMBER_TABLE
98: , a16 JTF_VARCHAR2_TABLE_100
99: , a17 JTF_VARCHAR2_TABLE_500

Line 96: , a14 JTF_DATE_TABLE

92: , a10 JTF_NUMBER_TABLE
93: , a11 JTF_VARCHAR2_TABLE_100
94: , a12 JTF_VARCHAR2_TABLE_100
95: , a13 JTF_DATE_TABLE
96: , a14 JTF_DATE_TABLE
97: , a15 JTF_NUMBER_TABLE
98: , a16 JTF_VARCHAR2_TABLE_100
99: , a17 JTF_VARCHAR2_TABLE_500
100: , a18 JTF_VARCHAR2_TABLE_500

Line 115: , a33 JTF_DATE_TABLE

111: , a29 JTF_VARCHAR2_TABLE_500
112: , a30 JTF_VARCHAR2_TABLE_500
113: , a31 JTF_VARCHAR2_TABLE_500
114: , a32 JTF_NUMBER_TABLE
115: , a33 JTF_DATE_TABLE
116: , a34 JTF_NUMBER_TABLE
117: , a35 JTF_DATE_TABLE
118: , a36 JTF_NUMBER_TABLE
119: );

Line 117: , a35 JTF_DATE_TABLE

113: , a31 JTF_VARCHAR2_TABLE_500
114: , a32 JTF_NUMBER_TABLE
115: , a33 JTF_DATE_TABLE
116: , a34 JTF_NUMBER_TABLE
117: , a35 JTF_DATE_TABLE
118: , a36 JTF_NUMBER_TABLE
119: );
120: procedure rosetta_table_copy_out_p3(t okl_srt_pvt.okl_srtb_tbl, a0 out nocopy JTF_NUMBER_TABLE
121: , a1 out nocopy JTF_VARCHAR2_TABLE_300

Line 133: , a13 out nocopy JTF_DATE_TABLE

129: , a9 out nocopy JTF_VARCHAR2_TABLE_100
130: , a10 out nocopy JTF_NUMBER_TABLE
131: , a11 out nocopy JTF_VARCHAR2_TABLE_100
132: , a12 out nocopy JTF_VARCHAR2_TABLE_100
133: , a13 out nocopy JTF_DATE_TABLE
134: , a14 out nocopy JTF_DATE_TABLE
135: , a15 out nocopy JTF_NUMBER_TABLE
136: , a16 out nocopy JTF_VARCHAR2_TABLE_100
137: , a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 134: , a14 out nocopy JTF_DATE_TABLE

130: , a10 out nocopy JTF_NUMBER_TABLE
131: , a11 out nocopy JTF_VARCHAR2_TABLE_100
132: , a12 out nocopy JTF_VARCHAR2_TABLE_100
133: , a13 out nocopy JTF_DATE_TABLE
134: , a14 out nocopy JTF_DATE_TABLE
135: , a15 out nocopy JTF_NUMBER_TABLE
136: , a16 out nocopy JTF_VARCHAR2_TABLE_100
137: , a17 out nocopy JTF_VARCHAR2_TABLE_500
138: , a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 153: , a33 out nocopy JTF_DATE_TABLE

149: , a29 out nocopy JTF_VARCHAR2_TABLE_500
150: , a30 out nocopy JTF_VARCHAR2_TABLE_500
151: , a31 out nocopy JTF_VARCHAR2_TABLE_500
152: , a32 out nocopy JTF_NUMBER_TABLE
153: , a33 out nocopy JTF_DATE_TABLE
154: , a34 out nocopy JTF_NUMBER_TABLE
155: , a35 out nocopy JTF_DATE_TABLE
156: , a36 out nocopy JTF_NUMBER_TABLE
157: );

Line 155: , a35 out nocopy JTF_DATE_TABLE

151: , a31 out nocopy JTF_VARCHAR2_TABLE_500
152: , a32 out nocopy JTF_NUMBER_TABLE
153: , a33 out nocopy JTF_DATE_TABLE
154: , a34 out nocopy JTF_NUMBER_TABLE
155: , a35 out nocopy JTF_DATE_TABLE
156: , a36 out nocopy JTF_NUMBER_TABLE
157: );
158:
159: procedure rosetta_table_copy_in_p5(t out nocopy okl_srt_pvt.okl_srttl_tbl, a0 JTF_NUMBER_TABLE

Line 165: , a6 JTF_DATE_TABLE

161: , a2 JTF_VARCHAR2_TABLE_100
162: , a3 JTF_VARCHAR2_TABLE_100
163: , a4 JTF_VARCHAR2_TABLE_100
164: , a5 JTF_NUMBER_TABLE
165: , a6 JTF_DATE_TABLE
166: , a7 JTF_NUMBER_TABLE
167: , a8 JTF_DATE_TABLE
168: , a9 JTF_NUMBER_TABLE
169: );

Line 167: , a8 JTF_DATE_TABLE

163: , a4 JTF_VARCHAR2_TABLE_100
164: , a5 JTF_NUMBER_TABLE
165: , a6 JTF_DATE_TABLE
166: , a7 JTF_NUMBER_TABLE
167: , a8 JTF_DATE_TABLE
168: , a9 JTF_NUMBER_TABLE
169: );
170: procedure rosetta_table_copy_out_p5(t okl_srt_pvt.okl_srttl_tbl, a0 out nocopy JTF_NUMBER_TABLE
171: , a1 out nocopy JTF_VARCHAR2_TABLE_2000

Line 176: , a6 out nocopy JTF_DATE_TABLE

172: , a2 out nocopy JTF_VARCHAR2_TABLE_100
173: , a3 out nocopy JTF_VARCHAR2_TABLE_100
174: , a4 out nocopy JTF_VARCHAR2_TABLE_100
175: , a5 out nocopy JTF_NUMBER_TABLE
176: , a6 out nocopy JTF_DATE_TABLE
177: , a7 out nocopy JTF_NUMBER_TABLE
178: , a8 out nocopy JTF_DATE_TABLE
179: , a9 out nocopy JTF_NUMBER_TABLE
180: );

Line 178: , a8 out nocopy JTF_DATE_TABLE

174: , a4 out nocopy JTF_VARCHAR2_TABLE_100
175: , a5 out nocopy JTF_NUMBER_TABLE
176: , a6 out nocopy JTF_DATE_TABLE
177: , a7 out nocopy JTF_NUMBER_TABLE
178: , a8 out nocopy JTF_DATE_TABLE
179: , a9 out nocopy JTF_NUMBER_TABLE
180: );
181:
182: procedure insert_row(p_api_version NUMBER

Line 283: , p5_a14 JTF_DATE_TABLE

279: , p5_a10 JTF_VARCHAR2_TABLE_100
280: , p5_a11 JTF_NUMBER_TABLE
281: , p5_a12 JTF_VARCHAR2_TABLE_100
282: , p5_a13 JTF_VARCHAR2_TABLE_100
283: , p5_a14 JTF_DATE_TABLE
284: , p5_a15 JTF_DATE_TABLE
285: , p5_a16 JTF_NUMBER_TABLE
286: , p5_a17 JTF_VARCHAR2_TABLE_100
287: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 284: , p5_a15 JTF_DATE_TABLE

280: , p5_a11 JTF_NUMBER_TABLE
281: , p5_a12 JTF_VARCHAR2_TABLE_100
282: , p5_a13 JTF_VARCHAR2_TABLE_100
283: , p5_a14 JTF_DATE_TABLE
284: , p5_a15 JTF_DATE_TABLE
285: , p5_a16 JTF_NUMBER_TABLE
286: , p5_a17 JTF_VARCHAR2_TABLE_100
287: , p5_a18 JTF_VARCHAR2_TABLE_500
288: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 303: , p5_a34 JTF_DATE_TABLE

299: , p5_a30 JTF_VARCHAR2_TABLE_500
300: , p5_a31 JTF_VARCHAR2_TABLE_500
301: , p5_a32 JTF_VARCHAR2_TABLE_500
302: , p5_a33 JTF_NUMBER_TABLE
303: , p5_a34 JTF_DATE_TABLE
304: , p5_a35 JTF_NUMBER_TABLE
305: , p5_a36 JTF_DATE_TABLE
306: , p5_a37 JTF_NUMBER_TABLE
307: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 305: , p5_a36 JTF_DATE_TABLE

301: , p5_a32 JTF_VARCHAR2_TABLE_500
302: , p5_a33 JTF_NUMBER_TABLE
303: , p5_a34 JTF_DATE_TABLE
304: , p5_a35 JTF_NUMBER_TABLE
305: , p5_a36 JTF_DATE_TABLE
306: , p5_a37 JTF_NUMBER_TABLE
307: , p6_a0 out nocopy JTF_NUMBER_TABLE
308: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
309: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000

Line 321: , p6_a14 out nocopy JTF_DATE_TABLE

317: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
318: , p6_a11 out nocopy JTF_NUMBER_TABLE
319: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a14 out nocopy JTF_DATE_TABLE
322: , p6_a15 out nocopy JTF_DATE_TABLE
323: , p6_a16 out nocopy JTF_NUMBER_TABLE
324: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 322: , p6_a15 out nocopy JTF_DATE_TABLE

318: , p6_a11 out nocopy JTF_NUMBER_TABLE
319: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a14 out nocopy JTF_DATE_TABLE
322: , p6_a15 out nocopy JTF_DATE_TABLE
323: , p6_a16 out nocopy JTF_NUMBER_TABLE
324: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
326: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 341: , p6_a34 out nocopy JTF_DATE_TABLE

337: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
338: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
339: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
340: , p6_a33 out nocopy JTF_NUMBER_TABLE
341: , p6_a34 out nocopy JTF_DATE_TABLE
342: , p6_a35 out nocopy JTF_NUMBER_TABLE
343: , p6_a36 out nocopy JTF_DATE_TABLE
344: , p6_a37 out nocopy JTF_NUMBER_TABLE
345: );

Line 343: , p6_a36 out nocopy JTF_DATE_TABLE

339: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
340: , p6_a33 out nocopy JTF_NUMBER_TABLE
341: , p6_a34 out nocopy JTF_DATE_TABLE
342: , p6_a35 out nocopy JTF_NUMBER_TABLE
343: , p6_a36 out nocopy JTF_DATE_TABLE
344: , p6_a37 out nocopy JTF_NUMBER_TABLE
345: );
346: procedure update_row(p_api_version NUMBER
347: , p_init_msg_list VARCHAR2

Line 447: , p5_a14 JTF_DATE_TABLE

443: , p5_a10 JTF_VARCHAR2_TABLE_100
444: , p5_a11 JTF_NUMBER_TABLE
445: , p5_a12 JTF_VARCHAR2_TABLE_100
446: , p5_a13 JTF_VARCHAR2_TABLE_100
447: , p5_a14 JTF_DATE_TABLE
448: , p5_a15 JTF_DATE_TABLE
449: , p5_a16 JTF_NUMBER_TABLE
450: , p5_a17 JTF_VARCHAR2_TABLE_100
451: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 448: , p5_a15 JTF_DATE_TABLE

444: , p5_a11 JTF_NUMBER_TABLE
445: , p5_a12 JTF_VARCHAR2_TABLE_100
446: , p5_a13 JTF_VARCHAR2_TABLE_100
447: , p5_a14 JTF_DATE_TABLE
448: , p5_a15 JTF_DATE_TABLE
449: , p5_a16 JTF_NUMBER_TABLE
450: , p5_a17 JTF_VARCHAR2_TABLE_100
451: , p5_a18 JTF_VARCHAR2_TABLE_500
452: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 467: , p5_a34 JTF_DATE_TABLE

463: , p5_a30 JTF_VARCHAR2_TABLE_500
464: , p5_a31 JTF_VARCHAR2_TABLE_500
465: , p5_a32 JTF_VARCHAR2_TABLE_500
466: , p5_a33 JTF_NUMBER_TABLE
467: , p5_a34 JTF_DATE_TABLE
468: , p5_a35 JTF_NUMBER_TABLE
469: , p5_a36 JTF_DATE_TABLE
470: , p5_a37 JTF_NUMBER_TABLE
471: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 469: , p5_a36 JTF_DATE_TABLE

465: , p5_a32 JTF_VARCHAR2_TABLE_500
466: , p5_a33 JTF_NUMBER_TABLE
467: , p5_a34 JTF_DATE_TABLE
468: , p5_a35 JTF_NUMBER_TABLE
469: , p5_a36 JTF_DATE_TABLE
470: , p5_a37 JTF_NUMBER_TABLE
471: , p6_a0 out nocopy JTF_NUMBER_TABLE
472: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
473: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000

Line 485: , p6_a14 out nocopy JTF_DATE_TABLE

481: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
482: , p6_a11 out nocopy JTF_NUMBER_TABLE
483: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
485: , p6_a14 out nocopy JTF_DATE_TABLE
486: , p6_a15 out nocopy JTF_DATE_TABLE
487: , p6_a16 out nocopy JTF_NUMBER_TABLE
488: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500

Line 486: , p6_a15 out nocopy JTF_DATE_TABLE

482: , p6_a11 out nocopy JTF_NUMBER_TABLE
483: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
485: , p6_a14 out nocopy JTF_DATE_TABLE
486: , p6_a15 out nocopy JTF_DATE_TABLE
487: , p6_a16 out nocopy JTF_NUMBER_TABLE
488: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
490: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500

Line 505: , p6_a34 out nocopy JTF_DATE_TABLE

501: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
502: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
503: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
504: , p6_a33 out nocopy JTF_NUMBER_TABLE
505: , p6_a34 out nocopy JTF_DATE_TABLE
506: , p6_a35 out nocopy JTF_NUMBER_TABLE
507: , p6_a36 out nocopy JTF_DATE_TABLE
508: , p6_a37 out nocopy JTF_NUMBER_TABLE
509: );

Line 507: , p6_a36 out nocopy JTF_DATE_TABLE

503: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
504: , p6_a33 out nocopy JTF_NUMBER_TABLE
505: , p6_a34 out nocopy JTF_DATE_TABLE
506: , p6_a35 out nocopy JTF_NUMBER_TABLE
507: , p6_a36 out nocopy JTF_DATE_TABLE
508: , p6_a37 out nocopy JTF_NUMBER_TABLE
509: );
510: procedure delete_row(p_api_version NUMBER
511: , p_init_msg_list VARCHAR2

Line 573: , p5_a14 JTF_DATE_TABLE

569: , p5_a10 JTF_VARCHAR2_TABLE_100
570: , p5_a11 JTF_NUMBER_TABLE
571: , p5_a12 JTF_VARCHAR2_TABLE_100
572: , p5_a13 JTF_VARCHAR2_TABLE_100
573: , p5_a14 JTF_DATE_TABLE
574: , p5_a15 JTF_DATE_TABLE
575: , p5_a16 JTF_NUMBER_TABLE
576: , p5_a17 JTF_VARCHAR2_TABLE_100
577: , p5_a18 JTF_VARCHAR2_TABLE_500

Line 574: , p5_a15 JTF_DATE_TABLE

570: , p5_a11 JTF_NUMBER_TABLE
571: , p5_a12 JTF_VARCHAR2_TABLE_100
572: , p5_a13 JTF_VARCHAR2_TABLE_100
573: , p5_a14 JTF_DATE_TABLE
574: , p5_a15 JTF_DATE_TABLE
575: , p5_a16 JTF_NUMBER_TABLE
576: , p5_a17 JTF_VARCHAR2_TABLE_100
577: , p5_a18 JTF_VARCHAR2_TABLE_500
578: , p5_a19 JTF_VARCHAR2_TABLE_500

Line 593: , p5_a34 JTF_DATE_TABLE

589: , p5_a30 JTF_VARCHAR2_TABLE_500
590: , p5_a31 JTF_VARCHAR2_TABLE_500
591: , p5_a32 JTF_VARCHAR2_TABLE_500
592: , p5_a33 JTF_NUMBER_TABLE
593: , p5_a34 JTF_DATE_TABLE
594: , p5_a35 JTF_NUMBER_TABLE
595: , p5_a36 JTF_DATE_TABLE
596: , p5_a37 JTF_NUMBER_TABLE
597: );

Line 595: , p5_a36 JTF_DATE_TABLE

591: , p5_a32 JTF_VARCHAR2_TABLE_500
592: , p5_a33 JTF_NUMBER_TABLE
593: , p5_a34 JTF_DATE_TABLE
594: , p5_a35 JTF_NUMBER_TABLE
595: , p5_a36 JTF_DATE_TABLE
596: , p5_a37 JTF_NUMBER_TABLE
597: );
598: end okl_srt_pvt_w;