DBA Data[Home] [Help]

APPS.OKL_IRH_PVT_W dependencies on JTF_DATE_TABLE

Line 15: , a12 JTF_DATE_TABLE

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

Line 16: , a13 JTF_DATE_TABLE

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

Line 19: , a16 JTF_DATE_TABLE

15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: );

Line 21: , a18 JTF_DATE_TABLE

17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: );
24: procedure rosetta_table_copy_out_p1(t okl_irh_pvt.okl_irhv_tbl, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE

Line 36: , a12 out nocopy JTF_DATE_TABLE

32: , a8 out nocopy JTF_VARCHAR2_TABLE_100
33: , a9 out nocopy JTF_VARCHAR2_TABLE_100
34: , a10 out nocopy JTF_VARCHAR2_TABLE_100
35: , a11 out nocopy JTF_VARCHAR2_TABLE_100
36: , a12 out nocopy JTF_DATE_TABLE
37: , a13 out nocopy JTF_DATE_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_DATE_TABLE

Line 37: , a13 out nocopy JTF_DATE_TABLE

33: , a9 out nocopy JTF_VARCHAR2_TABLE_100
34: , a10 out nocopy JTF_VARCHAR2_TABLE_100
35: , a11 out nocopy JTF_VARCHAR2_TABLE_100
36: , a12 out nocopy JTF_DATE_TABLE
37: , a13 out nocopy JTF_DATE_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_DATE_TABLE
41: , a17 out nocopy JTF_NUMBER_TABLE

Line 40: , a16 out nocopy JTF_DATE_TABLE

36: , a12 out nocopy JTF_DATE_TABLE
37: , a13 out nocopy JTF_DATE_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_DATE_TABLE
41: , a17 out nocopy JTF_NUMBER_TABLE
42: , a18 out nocopy JTF_DATE_TABLE
43: , a19 out nocopy JTF_NUMBER_TABLE
44: );

Line 42: , a18 out nocopy JTF_DATE_TABLE

38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_DATE_TABLE
41: , a17 out nocopy JTF_NUMBER_TABLE
42: , a18 out nocopy JTF_DATE_TABLE
43: , a19 out nocopy JTF_NUMBER_TABLE
44: );
45:
46: procedure rosetta_table_copy_in_p3(t out nocopy okl_irh_pvt.okl_irh_tbl, a0 JTF_NUMBER_TABLE

Line 58: , a12 JTF_DATE_TABLE

54: , a8 JTF_VARCHAR2_TABLE_100
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_VARCHAR2_TABLE_100
57: , a11 JTF_VARCHAR2_TABLE_100
58: , a12 JTF_DATE_TABLE
59: , a13 JTF_DATE_TABLE
60: , a14 JTF_NUMBER_TABLE
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE

Line 59: , a13 JTF_DATE_TABLE

55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_VARCHAR2_TABLE_100
57: , a11 JTF_VARCHAR2_TABLE_100
58: , a12 JTF_DATE_TABLE
59: , a13 JTF_DATE_TABLE
60: , a14 JTF_NUMBER_TABLE
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE
63: , a17 JTF_NUMBER_TABLE

Line 62: , a16 JTF_DATE_TABLE

58: , a12 JTF_DATE_TABLE
59: , a13 JTF_DATE_TABLE
60: , a14 JTF_NUMBER_TABLE
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE
63: , a17 JTF_NUMBER_TABLE
64: , a18 JTF_DATE_TABLE
65: , a19 JTF_NUMBER_TABLE
66: );

Line 64: , a18 JTF_DATE_TABLE

60: , a14 JTF_NUMBER_TABLE
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE
63: , a17 JTF_NUMBER_TABLE
64: , a18 JTF_DATE_TABLE
65: , a19 JTF_NUMBER_TABLE
66: );
67: procedure rosetta_table_copy_out_p3(t okl_irh_pvt.okl_irh_tbl, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE

Line 79: , a12 out nocopy JTF_DATE_TABLE

75: , a8 out nocopy JTF_VARCHAR2_TABLE_100
76: , a9 out nocopy JTF_VARCHAR2_TABLE_100
77: , a10 out nocopy JTF_VARCHAR2_TABLE_100
78: , a11 out nocopy JTF_VARCHAR2_TABLE_100
79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_DATE_TABLE
81: , a14 out nocopy JTF_NUMBER_TABLE
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE

Line 80: , a13 out nocopy JTF_DATE_TABLE

76: , a9 out nocopy JTF_VARCHAR2_TABLE_100
77: , a10 out nocopy JTF_VARCHAR2_TABLE_100
78: , a11 out nocopy JTF_VARCHAR2_TABLE_100
79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_DATE_TABLE
81: , a14 out nocopy JTF_NUMBER_TABLE
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE
84: , a17 out nocopy JTF_NUMBER_TABLE

Line 83: , a16 out nocopy JTF_DATE_TABLE

79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_DATE_TABLE
81: , a14 out nocopy JTF_NUMBER_TABLE
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE
84: , a17 out nocopy JTF_NUMBER_TABLE
85: , a18 out nocopy JTF_DATE_TABLE
86: , a19 out nocopy JTF_NUMBER_TABLE
87: );

Line 85: , a18 out nocopy JTF_DATE_TABLE

81: , a14 out nocopy JTF_NUMBER_TABLE
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE
84: , a17 out nocopy JTF_NUMBER_TABLE
85: , a18 out nocopy JTF_DATE_TABLE
86: , a19 out nocopy JTF_NUMBER_TABLE
87: );
88:
89: procedure insert_row(p_api_version NUMBER

Line 152: , p5_a12 JTF_DATE_TABLE

148: , p5_a8 JTF_VARCHAR2_TABLE_100
149: , p5_a9 JTF_VARCHAR2_TABLE_100
150: , p5_a10 JTF_VARCHAR2_TABLE_100
151: , p5_a11 JTF_VARCHAR2_TABLE_100
152: , p5_a12 JTF_DATE_TABLE
153: , p5_a13 JTF_DATE_TABLE
154: , p5_a14 JTF_NUMBER_TABLE
155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE

Line 153: , p5_a13 JTF_DATE_TABLE

149: , p5_a9 JTF_VARCHAR2_TABLE_100
150: , p5_a10 JTF_VARCHAR2_TABLE_100
151: , p5_a11 JTF_VARCHAR2_TABLE_100
152: , p5_a12 JTF_DATE_TABLE
153: , p5_a13 JTF_DATE_TABLE
154: , p5_a14 JTF_NUMBER_TABLE
155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE
157: , p5_a17 JTF_NUMBER_TABLE

Line 156: , p5_a16 JTF_DATE_TABLE

152: , p5_a12 JTF_DATE_TABLE
153: , p5_a13 JTF_DATE_TABLE
154: , p5_a14 JTF_NUMBER_TABLE
155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE
157: , p5_a17 JTF_NUMBER_TABLE
158: , p5_a18 JTF_DATE_TABLE
159: , p5_a19 JTF_NUMBER_TABLE
160: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 158: , p5_a18 JTF_DATE_TABLE

154: , p5_a14 JTF_NUMBER_TABLE
155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE
157: , p5_a17 JTF_NUMBER_TABLE
158: , p5_a18 JTF_DATE_TABLE
159: , p5_a19 JTF_NUMBER_TABLE
160: , p6_a0 out nocopy JTF_NUMBER_TABLE
161: , p6_a1 out nocopy JTF_NUMBER_TABLE
162: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 172: , p6_a12 out nocopy JTF_DATE_TABLE

168: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
169: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
170: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
172: , p6_a12 out nocopy JTF_DATE_TABLE
173: , p6_a13 out nocopy JTF_DATE_TABLE
174: , p6_a14 out nocopy JTF_NUMBER_TABLE
175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE

Line 173: , p6_a13 out nocopy JTF_DATE_TABLE

169: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
170: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
172: , p6_a12 out nocopy JTF_DATE_TABLE
173: , p6_a13 out nocopy JTF_DATE_TABLE
174: , p6_a14 out nocopy JTF_NUMBER_TABLE
175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE
177: , p6_a17 out nocopy JTF_NUMBER_TABLE

Line 176: , p6_a16 out nocopy JTF_DATE_TABLE

172: , p6_a12 out nocopy JTF_DATE_TABLE
173: , p6_a13 out nocopy JTF_DATE_TABLE
174: , p6_a14 out nocopy JTF_NUMBER_TABLE
175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE
177: , p6_a17 out nocopy JTF_NUMBER_TABLE
178: , p6_a18 out nocopy JTF_DATE_TABLE
179: , p6_a19 out nocopy JTF_NUMBER_TABLE
180: );

Line 178: , p6_a18 out nocopy JTF_DATE_TABLE

174: , p6_a14 out nocopy JTF_NUMBER_TABLE
175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE
177: , p6_a17 out nocopy JTF_NUMBER_TABLE
178: , p6_a18 out nocopy JTF_DATE_TABLE
179: , p6_a19 out nocopy JTF_NUMBER_TABLE
180: );
181: procedure update_row(p_api_version NUMBER
182: , p_init_msg_list VARCHAR2

Line 244: , p5_a12 JTF_DATE_TABLE

240: , p5_a8 JTF_VARCHAR2_TABLE_100
241: , p5_a9 JTF_VARCHAR2_TABLE_100
242: , p5_a10 JTF_VARCHAR2_TABLE_100
243: , p5_a11 JTF_VARCHAR2_TABLE_100
244: , p5_a12 JTF_DATE_TABLE
245: , p5_a13 JTF_DATE_TABLE
246: , p5_a14 JTF_NUMBER_TABLE
247: , p5_a15 JTF_NUMBER_TABLE
248: , p5_a16 JTF_DATE_TABLE

Line 245: , p5_a13 JTF_DATE_TABLE

241: , p5_a9 JTF_VARCHAR2_TABLE_100
242: , p5_a10 JTF_VARCHAR2_TABLE_100
243: , p5_a11 JTF_VARCHAR2_TABLE_100
244: , p5_a12 JTF_DATE_TABLE
245: , p5_a13 JTF_DATE_TABLE
246: , p5_a14 JTF_NUMBER_TABLE
247: , p5_a15 JTF_NUMBER_TABLE
248: , p5_a16 JTF_DATE_TABLE
249: , p5_a17 JTF_NUMBER_TABLE

Line 248: , p5_a16 JTF_DATE_TABLE

244: , p5_a12 JTF_DATE_TABLE
245: , p5_a13 JTF_DATE_TABLE
246: , p5_a14 JTF_NUMBER_TABLE
247: , p5_a15 JTF_NUMBER_TABLE
248: , p5_a16 JTF_DATE_TABLE
249: , p5_a17 JTF_NUMBER_TABLE
250: , p5_a18 JTF_DATE_TABLE
251: , p5_a19 JTF_NUMBER_TABLE
252: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 250: , p5_a18 JTF_DATE_TABLE

246: , p5_a14 JTF_NUMBER_TABLE
247: , p5_a15 JTF_NUMBER_TABLE
248: , p5_a16 JTF_DATE_TABLE
249: , p5_a17 JTF_NUMBER_TABLE
250: , p5_a18 JTF_DATE_TABLE
251: , p5_a19 JTF_NUMBER_TABLE
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 264: , p6_a12 out nocopy JTF_DATE_TABLE

260: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a12 out nocopy JTF_DATE_TABLE
265: , p6_a13 out nocopy JTF_DATE_TABLE
266: , p6_a14 out nocopy JTF_NUMBER_TABLE
267: , p6_a15 out nocopy JTF_NUMBER_TABLE
268: , p6_a16 out nocopy JTF_DATE_TABLE

Line 265: , p6_a13 out nocopy JTF_DATE_TABLE

261: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a12 out nocopy JTF_DATE_TABLE
265: , p6_a13 out nocopy JTF_DATE_TABLE
266: , p6_a14 out nocopy JTF_NUMBER_TABLE
267: , p6_a15 out nocopy JTF_NUMBER_TABLE
268: , p6_a16 out nocopy JTF_DATE_TABLE
269: , p6_a17 out nocopy JTF_NUMBER_TABLE

Line 268: , p6_a16 out nocopy JTF_DATE_TABLE

264: , p6_a12 out nocopy JTF_DATE_TABLE
265: , p6_a13 out nocopy JTF_DATE_TABLE
266: , p6_a14 out nocopy JTF_NUMBER_TABLE
267: , p6_a15 out nocopy JTF_NUMBER_TABLE
268: , p6_a16 out nocopy JTF_DATE_TABLE
269: , p6_a17 out nocopy JTF_NUMBER_TABLE
270: , p6_a18 out nocopy JTF_DATE_TABLE
271: , p6_a19 out nocopy JTF_NUMBER_TABLE
272: );

Line 270: , p6_a18 out nocopy JTF_DATE_TABLE

266: , p6_a14 out nocopy JTF_NUMBER_TABLE
267: , p6_a15 out nocopy JTF_NUMBER_TABLE
268: , p6_a16 out nocopy JTF_DATE_TABLE
269: , p6_a17 out nocopy JTF_NUMBER_TABLE
270: , p6_a18 out nocopy JTF_DATE_TABLE
271: , p6_a19 out nocopy JTF_NUMBER_TABLE
272: );
273: procedure delete_row(p_api_version NUMBER
274: , p_init_msg_list VARCHAR2

Line 316: , p5_a12 JTF_DATE_TABLE

312: , p5_a8 JTF_VARCHAR2_TABLE_100
313: , p5_a9 JTF_VARCHAR2_TABLE_100
314: , p5_a10 JTF_VARCHAR2_TABLE_100
315: , p5_a11 JTF_VARCHAR2_TABLE_100
316: , p5_a12 JTF_DATE_TABLE
317: , p5_a13 JTF_DATE_TABLE
318: , p5_a14 JTF_NUMBER_TABLE
319: , p5_a15 JTF_NUMBER_TABLE
320: , p5_a16 JTF_DATE_TABLE

Line 317: , p5_a13 JTF_DATE_TABLE

313: , p5_a9 JTF_VARCHAR2_TABLE_100
314: , p5_a10 JTF_VARCHAR2_TABLE_100
315: , p5_a11 JTF_VARCHAR2_TABLE_100
316: , p5_a12 JTF_DATE_TABLE
317: , p5_a13 JTF_DATE_TABLE
318: , p5_a14 JTF_NUMBER_TABLE
319: , p5_a15 JTF_NUMBER_TABLE
320: , p5_a16 JTF_DATE_TABLE
321: , p5_a17 JTF_NUMBER_TABLE

Line 320: , p5_a16 JTF_DATE_TABLE

316: , p5_a12 JTF_DATE_TABLE
317: , p5_a13 JTF_DATE_TABLE
318: , p5_a14 JTF_NUMBER_TABLE
319: , p5_a15 JTF_NUMBER_TABLE
320: , p5_a16 JTF_DATE_TABLE
321: , p5_a17 JTF_NUMBER_TABLE
322: , p5_a18 JTF_DATE_TABLE
323: , p5_a19 JTF_NUMBER_TABLE
324: );

Line 322: , p5_a18 JTF_DATE_TABLE

318: , p5_a14 JTF_NUMBER_TABLE
319: , p5_a15 JTF_NUMBER_TABLE
320: , p5_a16 JTF_DATE_TABLE
321: , p5_a17 JTF_NUMBER_TABLE
322: , p5_a18 JTF_DATE_TABLE
323: , p5_a19 JTF_NUMBER_TABLE
324: );
325: end okl_irh_pvt_w;