APPS.OKL_RTP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rtp_pvt.rtp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE

Line 18: , a4 out nocopy JTF_VARCHAR2_TABLE_100

14: procedure rosetta_table_copy_out_p2(t okl_rtp_pvt.rtp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_DATE_TABLE

Line 61: , p5_a4 JTF_VARCHAR2_TABLE_100

57: , p5_a0 JTF_NUMBER_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_NUMBER_TABLE
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_VARCHAR2_TABLE_100
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE

Line 71: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_NUMBER_TABLE
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE
75: , p6_a8 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 94: , p5_a4 JTF_VARCHAR2_TABLE_100

90: , p5_a0 JTF_NUMBER_TABLE
91: , p5_a1 JTF_NUMBER_TABLE
92: , p5_a2 JTF_NUMBER_TABLE
93: , p5_a3 JTF_NUMBER_TABLE
94: , p5_a4 JTF_VARCHAR2_TABLE_100
95: , p5_a5 JTF_NUMBER_TABLE
96: , p5_a6 JTF_DATE_TABLE
97: , p5_a7 JTF_NUMBER_TABLE
98: , p5_a8 JTF_DATE_TABLE

Line 104: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

100: , p6_a0 out nocopy JTF_NUMBER_TABLE
101: , p6_a1 out nocopy JTF_NUMBER_TABLE
102: , p6_a2 out nocopy JTF_NUMBER_TABLE
103: , p6_a3 out nocopy JTF_NUMBER_TABLE
104: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
105: , p6_a5 out nocopy JTF_NUMBER_TABLE
106: , p6_a6 out nocopy JTF_DATE_TABLE
107: , p6_a7 out nocopy JTF_NUMBER_TABLE
108: , p6_a8 out nocopy JTF_DATE_TABLE

Line 136: , p5_a4 JTF_VARCHAR2_TABLE_100

132: , p5_a0 JTF_NUMBER_TABLE
133: , p5_a1 JTF_NUMBER_TABLE
134: , p5_a2 JTF_NUMBER_TABLE
135: , p5_a3 JTF_NUMBER_TABLE
136: , p5_a4 JTF_VARCHAR2_TABLE_100
137: , p5_a5 JTF_NUMBER_TABLE
138: , p5_a6 JTF_DATE_TABLE
139: , p5_a7 JTF_NUMBER_TABLE
140: , p5_a8 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 159: , p5_a4 JTF_VARCHAR2_TABLE_100

155: , p5_a0 JTF_NUMBER_TABLE
156: , p5_a1 JTF_NUMBER_TABLE
157: , p5_a2 JTF_NUMBER_TABLE
158: , p5_a3 JTF_NUMBER_TABLE
159: , p5_a4 JTF_VARCHAR2_TABLE_100
160: , p5_a5 JTF_NUMBER_TABLE
161: , p5_a6 JTF_DATE_TABLE
162: , p5_a7 JTF_NUMBER_TABLE
163: , p5_a8 JTF_DATE_TABLE

Line 201: , p5_a4 JTF_VARCHAR2_TABLE_100

197: , p5_a0 JTF_NUMBER_TABLE
198: , p5_a1 JTF_NUMBER_TABLE
199: , p5_a2 JTF_NUMBER_TABLE
200: , p5_a3 JTF_NUMBER_TABLE
201: , p5_a4 JTF_VARCHAR2_TABLE_100
202: , p5_a5 JTF_NUMBER_TABLE
203: , p5_a6 JTF_DATE_TABLE
204: , p5_a7 JTF_NUMBER_TABLE
205: , p5_a8 JTF_DATE_TABLE

Line 211: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

207: , p6_a0 out nocopy JTF_NUMBER_TABLE
208: , p6_a1 out nocopy JTF_NUMBER_TABLE
209: , p6_a2 out nocopy JTF_NUMBER_TABLE
210: , p6_a3 out nocopy JTF_NUMBER_TABLE
211: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
212: , p6_a5 out nocopy JTF_NUMBER_TABLE
213: , p6_a6 out nocopy JTF_DATE_TABLE
214: , p6_a7 out nocopy JTF_NUMBER_TABLE
215: , p6_a8 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 234: , p5_a4 JTF_VARCHAR2_TABLE_100

230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_NUMBER_TABLE
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_VARCHAR2_TABLE_100
235: , p5_a5 JTF_NUMBER_TABLE
236: , p5_a6 JTF_DATE_TABLE
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE

Line 244: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

240: , p6_a0 out nocopy JTF_NUMBER_TABLE
241: , p6_a1 out nocopy JTF_NUMBER_TABLE
242: , p6_a2 out nocopy JTF_NUMBER_TABLE
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_DATE_TABLE
247: , p6_a7 out nocopy JTF_NUMBER_TABLE
248: , p6_a8 out nocopy JTF_DATE_TABLE

Line 276: , p5_a4 JTF_VARCHAR2_TABLE_100

272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_NUMBER_TABLE
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_VARCHAR2_TABLE_100
277: , p5_a5 JTF_NUMBER_TABLE
278: , p5_a6 JTF_DATE_TABLE
279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 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 299: , p5_a4 JTF_VARCHAR2_TABLE_100

295: , p5_a0 JTF_NUMBER_TABLE
296: , p5_a1 JTF_NUMBER_TABLE
297: , p5_a2 JTF_NUMBER_TABLE
298: , p5_a3 JTF_NUMBER_TABLE
299: , p5_a4 JTF_VARCHAR2_TABLE_100
300: , p5_a5 JTF_NUMBER_TABLE
301: , p5_a6 JTF_DATE_TABLE
302: , p5_a7 JTF_NUMBER_TABLE
303: , p5_a8 JTF_DATE_TABLE

Line 331: , p5_a4 JTF_VARCHAR2_TABLE_100

327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_NUMBER_TABLE
331: , p5_a4 JTF_VARCHAR2_TABLE_100
332: , p5_a5 JTF_NUMBER_TABLE
333: , p5_a6 JTF_DATE_TABLE
334: , p5_a7 JTF_NUMBER_TABLE
335: , p5_a8 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 354: , p5_a4 JTF_VARCHAR2_TABLE_100

350: , p5_a0 JTF_NUMBER_TABLE
351: , p5_a1 JTF_NUMBER_TABLE
352: , p5_a2 JTF_NUMBER_TABLE
353: , p5_a3 JTF_NUMBER_TABLE
354: , p5_a4 JTF_VARCHAR2_TABLE_100
355: , p5_a5 JTF_NUMBER_TABLE
356: , p5_a6 JTF_DATE_TABLE
357: , p5_a7 JTF_NUMBER_TABLE
358: , p5_a8 JTF_DATE_TABLE