eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_RAP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_rap_pvt_w as
2: /* $Header: OKLIRAPS.pls 120.0 2007/12/10 18:29:28 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rap_pvt.rap_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE

Line 16: , a2 out nocopy JTF_VARCHAR2_TABLE_100

12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_rap_pvt.rap_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE

Line 59: , p5_a2 JTF_VARCHAR2_TABLE_100

55: , x_msg_count out nocopy NUMBER
56: , x_msg_data out nocopy VARCHAR2
57: , p5_a0 JTF_NUMBER_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_VARCHAR2_TABLE_100
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_NUMBER_TABLE
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE

Line 69: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_NUMBER_TABLE
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE

Line 78: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

74: , p6_a7 out nocopy JTF_NUMBER_TABLE
75: , p6_a8 out nocopy JTF_DATE_TABLE
76: , p6_a9 out nocopy JTF_NUMBER_TABLE
77: , p7_a0 in out nocopy JTF_NUMBER_TABLE
78: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
79: , p7_a2 in out nocopy JTF_NUMBER_TABLE
80: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
81: , p7_a4 in out nocopy JTF_NUMBER_TABLE
82: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 82: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

78: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
79: , p7_a2 in out nocopy JTF_NUMBER_TABLE
80: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
81: , p7_a4 in out nocopy JTF_NUMBER_TABLE
82: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
83: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
84: );
85: procedure insert_row(p_api_version NUMBER
86: , p_init_msg_list VARCHAR2

Line 83: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

79: , p7_a2 in out nocopy JTF_NUMBER_TABLE
80: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
81: , p7_a4 in out nocopy JTF_NUMBER_TABLE
82: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
83: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
84: );
85: procedure insert_row(p_api_version NUMBER
86: , p_init_msg_list VARCHAR2
87: , x_return_status out nocopy VARCHAR2

Line 92: , p5_a2 JTF_VARCHAR2_TABLE_100

88: , x_msg_count out nocopy NUMBER
89: , x_msg_data out nocopy VARCHAR2
90: , p5_a0 JTF_NUMBER_TABLE
91: , p5_a1 JTF_NUMBER_TABLE
92: , p5_a2 JTF_VARCHAR2_TABLE_100
93: , p5_a3 JTF_NUMBER_TABLE
94: , p5_a4 JTF_NUMBER_TABLE
95: , p5_a5 JTF_NUMBER_TABLE
96: , p5_a6 JTF_DATE_TABLE

Line 102: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

98: , p5_a8 JTF_DATE_TABLE
99: , p5_a9 JTF_NUMBER_TABLE
100: , p6_a0 out nocopy JTF_NUMBER_TABLE
101: , p6_a1 out nocopy JTF_NUMBER_TABLE
102: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
103: , p6_a3 out nocopy JTF_NUMBER_TABLE
104: , p6_a4 out nocopy JTF_NUMBER_TABLE
105: , p6_a5 out nocopy JTF_NUMBER_TABLE
106: , p6_a6 out nocopy JTF_DATE_TABLE

Line 134: , p5_a2 JTF_VARCHAR2_TABLE_100

130: , x_msg_count out nocopy NUMBER
131: , x_msg_data out nocopy VARCHAR2
132: , p5_a0 JTF_NUMBER_TABLE
133: , p5_a1 JTF_NUMBER_TABLE
134: , p5_a2 JTF_VARCHAR2_TABLE_100
135: , p5_a3 JTF_NUMBER_TABLE
136: , p5_a4 JTF_NUMBER_TABLE
137: , p5_a5 JTF_NUMBER_TABLE
138: , p5_a6 JTF_DATE_TABLE

Line 143: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

139: , p5_a7 JTF_NUMBER_TABLE
140: , p5_a8 JTF_DATE_TABLE
141: , p5_a9 JTF_NUMBER_TABLE
142: , p6_a0 in out nocopy JTF_NUMBER_TABLE
143: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
144: , p6_a2 in out nocopy JTF_NUMBER_TABLE
145: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
146: , p6_a4 in out nocopy JTF_NUMBER_TABLE
147: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 147: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

143: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
144: , p6_a2 in out nocopy JTF_NUMBER_TABLE
145: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
146: , p6_a4 in out nocopy JTF_NUMBER_TABLE
147: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
149: );
150: procedure lock_row(p_api_version NUMBER
151: , p_init_msg_list VARCHAR2

Line 148: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

144: , p6_a2 in out nocopy JTF_NUMBER_TABLE
145: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
146: , p6_a4 in out nocopy JTF_NUMBER_TABLE
147: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
149: );
150: procedure lock_row(p_api_version NUMBER
151: , p_init_msg_list VARCHAR2
152: , x_return_status out nocopy VARCHAR2

Line 157: , p5_a2 JTF_VARCHAR2_TABLE_100

153: , x_msg_count out nocopy NUMBER
154: , x_msg_data out nocopy VARCHAR2
155: , p5_a0 JTF_NUMBER_TABLE
156: , p5_a1 JTF_NUMBER_TABLE
157: , p5_a2 JTF_VARCHAR2_TABLE_100
158: , p5_a3 JTF_NUMBER_TABLE
159: , p5_a4 JTF_NUMBER_TABLE
160: , p5_a5 JTF_NUMBER_TABLE
161: , p5_a6 JTF_DATE_TABLE

Line 199: , p5_a2 JTF_VARCHAR2_TABLE_100

195: , x_msg_count out nocopy NUMBER
196: , x_msg_data out nocopy VARCHAR2
197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_VARCHAR2_TABLE_100
200: , p5_a3 JTF_NUMBER_TABLE
201: , p5_a4 JTF_NUMBER_TABLE
202: , p5_a5 JTF_NUMBER_TABLE
203: , p5_a6 JTF_DATE_TABLE

Line 209: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

205: , p5_a8 JTF_DATE_TABLE
206: , p5_a9 JTF_NUMBER_TABLE
207: , p6_a0 out nocopy JTF_NUMBER_TABLE
208: , p6_a1 out nocopy JTF_NUMBER_TABLE
209: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a3 out nocopy JTF_NUMBER_TABLE
211: , p6_a4 out nocopy JTF_NUMBER_TABLE
212: , p6_a5 out nocopy JTF_NUMBER_TABLE
213: , p6_a6 out nocopy JTF_DATE_TABLE

Line 218: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

214: , p6_a7 out nocopy JTF_NUMBER_TABLE
215: , p6_a8 out nocopy JTF_DATE_TABLE
216: , p6_a9 out nocopy JTF_NUMBER_TABLE
217: , p7_a0 in out nocopy JTF_NUMBER_TABLE
218: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p7_a2 in out nocopy JTF_NUMBER_TABLE
220: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
221: , p7_a4 in out nocopy JTF_NUMBER_TABLE
222: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 222: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

218: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p7_a2 in out nocopy JTF_NUMBER_TABLE
220: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
221: , p7_a4 in out nocopy JTF_NUMBER_TABLE
222: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
224: );
225: procedure update_row(p_api_version NUMBER
226: , p_init_msg_list VARCHAR2

Line 223: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

219: , p7_a2 in out nocopy JTF_NUMBER_TABLE
220: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
221: , p7_a4 in out nocopy JTF_NUMBER_TABLE
222: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
224: );
225: procedure update_row(p_api_version NUMBER
226: , p_init_msg_list VARCHAR2
227: , x_return_status out nocopy VARCHAR2

Line 232: , p5_a2 JTF_VARCHAR2_TABLE_100

228: , x_msg_count out nocopy NUMBER
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_100
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_NUMBER_TABLE
236: , p5_a6 JTF_DATE_TABLE

Line 242: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

238: , p5_a8 JTF_DATE_TABLE
239: , p5_a9 JTF_NUMBER_TABLE
240: , p6_a0 out nocopy JTF_NUMBER_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE
242: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_NUMBER_TABLE
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_DATE_TABLE

Line 274: , p5_a2 JTF_VARCHAR2_TABLE_100

270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_NUMBER_TABLE
278: , p5_a6 JTF_DATE_TABLE

Line 283: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 JTF_DATE_TABLE
281: , p5_a9 JTF_NUMBER_TABLE
282: , p6_a0 in out nocopy JTF_NUMBER_TABLE
283: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a2 in out nocopy JTF_NUMBER_TABLE
285: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
286: , p6_a4 in out nocopy JTF_NUMBER_TABLE
287: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 287: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

283: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a2 in out nocopy JTF_NUMBER_TABLE
285: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
286: , p6_a4 in out nocopy JTF_NUMBER_TABLE
287: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
289: );
290: procedure delete_row(p_api_version NUMBER
291: , p_init_msg_list VARCHAR2

Line 288: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

284: , p6_a2 in out nocopy JTF_NUMBER_TABLE
285: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
286: , p6_a4 in out nocopy JTF_NUMBER_TABLE
287: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
289: );
290: procedure delete_row(p_api_version NUMBER
291: , p_init_msg_list VARCHAR2
292: , x_return_status out nocopy VARCHAR2

Line 297: , p5_a2 JTF_VARCHAR2_TABLE_100

293: , x_msg_count out nocopy NUMBER
294: , x_msg_data out nocopy VARCHAR2
295: , p5_a0 JTF_NUMBER_TABLE
296: , p5_a1 JTF_NUMBER_TABLE
297: , p5_a2 JTF_VARCHAR2_TABLE_100
298: , p5_a3 JTF_NUMBER_TABLE
299: , p5_a4 JTF_NUMBER_TABLE
300: , p5_a5 JTF_NUMBER_TABLE
301: , p5_a6 JTF_DATE_TABLE

Line 329: , p5_a2 JTF_VARCHAR2_TABLE_100

325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_VARCHAR2_TABLE_100
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_NUMBER_TABLE
333: , p5_a6 JTF_DATE_TABLE

Line 338: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

334: , p5_a7 JTF_NUMBER_TABLE
335: , p5_a8 JTF_DATE_TABLE
336: , p5_a9 JTF_NUMBER_TABLE
337: , p6_a0 in out nocopy JTF_NUMBER_TABLE
338: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a2 in out nocopy JTF_NUMBER_TABLE
340: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
341: , p6_a4 in out nocopy JTF_NUMBER_TABLE
342: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 342: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

338: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a2 in out nocopy JTF_NUMBER_TABLE
340: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
341: , p6_a4 in out nocopy JTF_NUMBER_TABLE
342: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
344: );
345: procedure validate_row(p_api_version NUMBER
346: , p_init_msg_list VARCHAR2

Line 343: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

339: , p6_a2 in out nocopy JTF_NUMBER_TABLE
340: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
341: , p6_a4 in out nocopy JTF_NUMBER_TABLE
342: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
344: );
345: procedure validate_row(p_api_version NUMBER
346: , p_init_msg_list VARCHAR2
347: , x_return_status out nocopy VARCHAR2

Line 352: , p5_a2 JTF_VARCHAR2_TABLE_100

348: , x_msg_count out nocopy NUMBER
349: , x_msg_data out nocopy VARCHAR2
350: , p5_a0 JTF_NUMBER_TABLE
351: , p5_a1 JTF_NUMBER_TABLE
352: , p5_a2 JTF_VARCHAR2_TABLE_100
353: , p5_a3 JTF_NUMBER_TABLE
354: , p5_a4 JTF_NUMBER_TABLE
355: , p5_a5 JTF_NUMBER_TABLE
356: , p5_a6 JTF_DATE_TABLE