DBA Data[Home] [Help]

APPS.OKL_RPP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_rpp_pvt_w as
2: /* $Header: OKLIRPPS.pls 120.0 2007/12/10 18:28:44 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpp_pvt.rpp_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_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE

Line 18: , a2 out nocopy JTF_VARCHAR2_TABLE_100

14: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p2(t okl_rpp_pvt.rpp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_VARCHAR2_TABLE_300
21: , a5 out nocopy JTF_DATE_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE

Line 23: , a7 out nocopy JTF_VARCHAR2_TABLE_100

19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_VARCHAR2_TABLE_300
21: , a5 out nocopy JTF_DATE_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_VARCHAR2_TABLE_100
24: , a8 out nocopy JTF_DATE_TABLE
25: , a9 out nocopy JTF_NUMBER_TABLE
26: , a10 out nocopy JTF_DATE_TABLE
27: , a11 out nocopy JTF_NUMBER_TABLE

Line 67: , p5_a2 JTF_VARCHAR2_TABLE_100

63: , x_msg_count out nocopy NUMBER
64: , x_msg_data out nocopy VARCHAR2
65: , p5_a0 JTF_NUMBER_TABLE
66: , p5_a1 JTF_NUMBER_TABLE
67: , p5_a2 JTF_VARCHAR2_TABLE_100
68: , p5_a3 JTF_NUMBER_TABLE
69: , p5_a4 JTF_VARCHAR2_TABLE_300
70: , p5_a5 JTF_DATE_TABLE
71: , p5_a6 JTF_NUMBER_TABLE

Line 72: , p5_a7 JTF_VARCHAR2_TABLE_100

68: , p5_a3 JTF_NUMBER_TABLE
69: , p5_a4 JTF_VARCHAR2_TABLE_300
70: , p5_a5 JTF_DATE_TABLE
71: , p5_a6 JTF_NUMBER_TABLE
72: , p5_a7 JTF_VARCHAR2_TABLE_100
73: , p5_a8 JTF_DATE_TABLE
74: , p5_a9 JTF_NUMBER_TABLE
75: , p5_a10 JTF_DATE_TABLE
76: , p5_a11 JTF_NUMBER_TABLE

Line 79: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

75: , p5_a10 JTF_DATE_TABLE
76: , p5_a11 JTF_NUMBER_TABLE
77: , p6_a0 out nocopy JTF_NUMBER_TABLE
78: , p6_a1 out nocopy JTF_NUMBER_TABLE
79: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a3 out nocopy JTF_NUMBER_TABLE
81: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
82: , p6_a5 out nocopy JTF_DATE_TABLE
83: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 84: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

80: , p6_a3 out nocopy JTF_NUMBER_TABLE
81: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
82: , p6_a5 out nocopy JTF_DATE_TABLE
83: , p6_a6 out nocopy JTF_NUMBER_TABLE
84: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
85: , p6_a8 out nocopy JTF_DATE_TABLE
86: , p6_a9 out nocopy JTF_NUMBER_TABLE
87: , p6_a10 out nocopy JTF_DATE_TABLE
88: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 90: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

86: , p6_a9 out nocopy JTF_NUMBER_TABLE
87: , p6_a10 out nocopy JTF_DATE_TABLE
88: , p6_a11 out nocopy JTF_NUMBER_TABLE
89: , p7_a0 in out nocopy JTF_NUMBER_TABLE
90: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
91: , p7_a2 in out nocopy JTF_NUMBER_TABLE
92: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
93: , p7_a4 in out nocopy JTF_NUMBER_TABLE
94: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 94: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

90: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
91: , p7_a2 in out nocopy JTF_NUMBER_TABLE
92: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
93: , p7_a4 in out nocopy JTF_NUMBER_TABLE
94: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
95: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
96: );
97: procedure insert_row(p_api_version NUMBER
98: , p_init_msg_list VARCHAR2

Line 95: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

91: , p7_a2 in out nocopy JTF_NUMBER_TABLE
92: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
93: , p7_a4 in out nocopy JTF_NUMBER_TABLE
94: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
95: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
96: );
97: procedure insert_row(p_api_version NUMBER
98: , p_init_msg_list VARCHAR2
99: , x_return_status out nocopy VARCHAR2

Line 104: , p5_a2 JTF_VARCHAR2_TABLE_100

100: , x_msg_count out nocopy NUMBER
101: , x_msg_data out nocopy VARCHAR2
102: , p5_a0 JTF_NUMBER_TABLE
103: , p5_a1 JTF_NUMBER_TABLE
104: , p5_a2 JTF_VARCHAR2_TABLE_100
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_VARCHAR2_TABLE_300
107: , p5_a5 JTF_DATE_TABLE
108: , p5_a6 JTF_NUMBER_TABLE

Line 109: , p5_a7 JTF_VARCHAR2_TABLE_100

105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_VARCHAR2_TABLE_300
107: , p5_a5 JTF_DATE_TABLE
108: , p5_a6 JTF_NUMBER_TABLE
109: , p5_a7 JTF_VARCHAR2_TABLE_100
110: , p5_a8 JTF_DATE_TABLE
111: , p5_a9 JTF_NUMBER_TABLE
112: , p5_a10 JTF_DATE_TABLE
113: , p5_a11 JTF_NUMBER_TABLE

Line 116: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

112: , p5_a10 JTF_DATE_TABLE
113: , p5_a11 JTF_NUMBER_TABLE
114: , p6_a0 out nocopy JTF_NUMBER_TABLE
115: , p6_a1 out nocopy JTF_NUMBER_TABLE
116: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , p6_a3 out nocopy JTF_NUMBER_TABLE
118: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
119: , p6_a5 out nocopy JTF_DATE_TABLE
120: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 121: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

117: , p6_a3 out nocopy JTF_NUMBER_TABLE
118: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
119: , p6_a5 out nocopy JTF_DATE_TABLE
120: , p6_a6 out nocopy JTF_NUMBER_TABLE
121: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
122: , p6_a8 out nocopy JTF_DATE_TABLE
123: , p6_a9 out nocopy JTF_NUMBER_TABLE
124: , p6_a10 out nocopy JTF_DATE_TABLE
125: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 152: , p5_a2 JTF_VARCHAR2_TABLE_100

148: , x_msg_count out nocopy NUMBER
149: , x_msg_data out nocopy VARCHAR2
150: , p5_a0 JTF_NUMBER_TABLE
151: , p5_a1 JTF_NUMBER_TABLE
152: , p5_a2 JTF_VARCHAR2_TABLE_100
153: , p5_a3 JTF_NUMBER_TABLE
154: , p5_a4 JTF_VARCHAR2_TABLE_300
155: , p5_a5 JTF_DATE_TABLE
156: , p5_a6 JTF_NUMBER_TABLE

Line 157: , p5_a7 JTF_VARCHAR2_TABLE_100

153: , p5_a3 JTF_NUMBER_TABLE
154: , p5_a4 JTF_VARCHAR2_TABLE_300
155: , p5_a5 JTF_DATE_TABLE
156: , p5_a6 JTF_NUMBER_TABLE
157: , p5_a7 JTF_VARCHAR2_TABLE_100
158: , p5_a8 JTF_DATE_TABLE
159: , p5_a9 JTF_NUMBER_TABLE
160: , p5_a10 JTF_DATE_TABLE
161: , p5_a11 JTF_NUMBER_TABLE

Line 163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

159: , p5_a9 JTF_NUMBER_TABLE
160: , p5_a10 JTF_DATE_TABLE
161: , p5_a11 JTF_NUMBER_TABLE
162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
169: );
170: procedure lock_row(p_api_version NUMBER
171: , p_init_msg_list VARCHAR2

Line 168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
169: );
170: procedure lock_row(p_api_version NUMBER
171: , p_init_msg_list VARCHAR2
172: , x_return_status out nocopy VARCHAR2

Line 177: , p5_a2 JTF_VARCHAR2_TABLE_100

173: , x_msg_count out nocopy NUMBER
174: , x_msg_data out nocopy VARCHAR2
175: , p5_a0 JTF_NUMBER_TABLE
176: , p5_a1 JTF_NUMBER_TABLE
177: , p5_a2 JTF_VARCHAR2_TABLE_100
178: , p5_a3 JTF_NUMBER_TABLE
179: , p5_a4 JTF_VARCHAR2_TABLE_300
180: , p5_a5 JTF_DATE_TABLE
181: , p5_a6 JTF_NUMBER_TABLE

Line 182: , p5_a7 JTF_VARCHAR2_TABLE_100

178: , p5_a3 JTF_NUMBER_TABLE
179: , p5_a4 JTF_VARCHAR2_TABLE_300
180: , p5_a5 JTF_DATE_TABLE
181: , p5_a6 JTF_NUMBER_TABLE
182: , p5_a7 JTF_VARCHAR2_TABLE_100
183: , p5_a8 JTF_DATE_TABLE
184: , p5_a9 JTF_NUMBER_TABLE
185: , p5_a10 JTF_DATE_TABLE
186: , p5_a11 JTF_NUMBER_TABLE

Line 225: , p5_a2 JTF_VARCHAR2_TABLE_100

221: , x_msg_count out nocopy NUMBER
222: , x_msg_data out nocopy VARCHAR2
223: , p5_a0 JTF_NUMBER_TABLE
224: , p5_a1 JTF_NUMBER_TABLE
225: , p5_a2 JTF_VARCHAR2_TABLE_100
226: , p5_a3 JTF_NUMBER_TABLE
227: , p5_a4 JTF_VARCHAR2_TABLE_300
228: , p5_a5 JTF_DATE_TABLE
229: , p5_a6 JTF_NUMBER_TABLE

Line 230: , p5_a7 JTF_VARCHAR2_TABLE_100

226: , p5_a3 JTF_NUMBER_TABLE
227: , p5_a4 JTF_VARCHAR2_TABLE_300
228: , p5_a5 JTF_DATE_TABLE
229: , p5_a6 JTF_NUMBER_TABLE
230: , p5_a7 JTF_VARCHAR2_TABLE_100
231: , p5_a8 JTF_DATE_TABLE
232: , p5_a9 JTF_NUMBER_TABLE
233: , p5_a10 JTF_DATE_TABLE
234: , p5_a11 JTF_NUMBER_TABLE

Line 237: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

233: , p5_a10 JTF_DATE_TABLE
234: , p5_a11 JTF_NUMBER_TABLE
235: , p6_a0 out nocopy JTF_NUMBER_TABLE
236: , p6_a1 out nocopy JTF_NUMBER_TABLE
237: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a3 out nocopy JTF_NUMBER_TABLE
239: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
240: , p6_a5 out nocopy JTF_DATE_TABLE
241: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 242: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

238: , p6_a3 out nocopy JTF_NUMBER_TABLE
239: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
240: , p6_a5 out nocopy JTF_DATE_TABLE
241: , p6_a6 out nocopy JTF_NUMBER_TABLE
242: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a8 out nocopy JTF_DATE_TABLE
244: , p6_a9 out nocopy JTF_NUMBER_TABLE
245: , p6_a10 out nocopy JTF_DATE_TABLE
246: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 248: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

244: , p6_a9 out nocopy JTF_NUMBER_TABLE
245: , p6_a10 out nocopy JTF_DATE_TABLE
246: , p6_a11 out nocopy JTF_NUMBER_TABLE
247: , p7_a0 in out nocopy JTF_NUMBER_TABLE
248: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p7_a2 in out nocopy JTF_NUMBER_TABLE
250: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
251: , p7_a4 in out nocopy JTF_NUMBER_TABLE
252: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 252: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

248: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p7_a2 in out nocopy JTF_NUMBER_TABLE
250: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
251: , p7_a4 in out nocopy JTF_NUMBER_TABLE
252: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
253: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
254: );
255: procedure update_row(p_api_version NUMBER
256: , p_init_msg_list VARCHAR2

Line 253: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

249: , p7_a2 in out nocopy JTF_NUMBER_TABLE
250: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
251: , p7_a4 in out nocopy JTF_NUMBER_TABLE
252: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
253: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
254: );
255: procedure update_row(p_api_version NUMBER
256: , p_init_msg_list VARCHAR2
257: , x_return_status out nocopy VARCHAR2

Line 262: , p5_a2 JTF_VARCHAR2_TABLE_100

258: , x_msg_count out nocopy NUMBER
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_VARCHAR2_TABLE_100
263: , p5_a3 JTF_NUMBER_TABLE
264: , p5_a4 JTF_VARCHAR2_TABLE_300
265: , p5_a5 JTF_DATE_TABLE
266: , p5_a6 JTF_NUMBER_TABLE

Line 267: , p5_a7 JTF_VARCHAR2_TABLE_100

263: , p5_a3 JTF_NUMBER_TABLE
264: , p5_a4 JTF_VARCHAR2_TABLE_300
265: , p5_a5 JTF_DATE_TABLE
266: , p5_a6 JTF_NUMBER_TABLE
267: , p5_a7 JTF_VARCHAR2_TABLE_100
268: , p5_a8 JTF_DATE_TABLE
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_DATE_TABLE
271: , p5_a11 JTF_NUMBER_TABLE

Line 274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

270: , p5_a10 JTF_DATE_TABLE
271: , p5_a11 JTF_NUMBER_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
277: , p6_a5 out nocopy JTF_DATE_TABLE
278: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 279: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
277: , p6_a5 out nocopy JTF_DATE_TABLE
278: , p6_a6 out nocopy JTF_NUMBER_TABLE
279: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a8 out nocopy JTF_DATE_TABLE
281: , p6_a9 out nocopy JTF_NUMBER_TABLE
282: , p6_a10 out nocopy JTF_DATE_TABLE
283: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 310: , p5_a2 JTF_VARCHAR2_TABLE_100

306: , x_msg_count out nocopy NUMBER
307: , x_msg_data out nocopy VARCHAR2
308: , p5_a0 JTF_NUMBER_TABLE
309: , p5_a1 JTF_NUMBER_TABLE
310: , p5_a2 JTF_VARCHAR2_TABLE_100
311: , p5_a3 JTF_NUMBER_TABLE
312: , p5_a4 JTF_VARCHAR2_TABLE_300
313: , p5_a5 JTF_DATE_TABLE
314: , p5_a6 JTF_NUMBER_TABLE

Line 315: , p5_a7 JTF_VARCHAR2_TABLE_100

311: , p5_a3 JTF_NUMBER_TABLE
312: , p5_a4 JTF_VARCHAR2_TABLE_300
313: , p5_a5 JTF_DATE_TABLE
314: , p5_a6 JTF_NUMBER_TABLE
315: , p5_a7 JTF_VARCHAR2_TABLE_100
316: , p5_a8 JTF_DATE_TABLE
317: , p5_a9 JTF_NUMBER_TABLE
318: , p5_a10 JTF_DATE_TABLE
319: , p5_a11 JTF_NUMBER_TABLE

Line 321: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

317: , p5_a9 JTF_NUMBER_TABLE
318: , p5_a10 JTF_DATE_TABLE
319: , p5_a11 JTF_NUMBER_TABLE
320: , p6_a0 in out nocopy JTF_NUMBER_TABLE
321: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a2 in out nocopy JTF_NUMBER_TABLE
323: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
324: , p6_a4 in out nocopy JTF_NUMBER_TABLE
325: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 325: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

321: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a2 in out nocopy JTF_NUMBER_TABLE
323: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
324: , p6_a4 in out nocopy JTF_NUMBER_TABLE
325: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
327: );
328: procedure delete_row(p_api_version NUMBER
329: , p_init_msg_list VARCHAR2

Line 326: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

322: , p6_a2 in out nocopy JTF_NUMBER_TABLE
323: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
324: , p6_a4 in out nocopy JTF_NUMBER_TABLE
325: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
327: );
328: procedure delete_row(p_api_version NUMBER
329: , p_init_msg_list VARCHAR2
330: , x_return_status out nocopy VARCHAR2

Line 335: , p5_a2 JTF_VARCHAR2_TABLE_100

331: , x_msg_count out nocopy NUMBER
332: , x_msg_data out nocopy VARCHAR2
333: , p5_a0 JTF_NUMBER_TABLE
334: , p5_a1 JTF_NUMBER_TABLE
335: , p5_a2 JTF_VARCHAR2_TABLE_100
336: , p5_a3 JTF_NUMBER_TABLE
337: , p5_a4 JTF_VARCHAR2_TABLE_300
338: , p5_a5 JTF_DATE_TABLE
339: , p5_a6 JTF_NUMBER_TABLE

Line 340: , p5_a7 JTF_VARCHAR2_TABLE_100

336: , p5_a3 JTF_NUMBER_TABLE
337: , p5_a4 JTF_VARCHAR2_TABLE_300
338: , p5_a5 JTF_DATE_TABLE
339: , p5_a6 JTF_NUMBER_TABLE
340: , p5_a7 JTF_VARCHAR2_TABLE_100
341: , p5_a8 JTF_DATE_TABLE
342: , p5_a9 JTF_NUMBER_TABLE
343: , p5_a10 JTF_DATE_TABLE
344: , p5_a11 JTF_NUMBER_TABLE

Line 371: , p5_a2 JTF_VARCHAR2_TABLE_100

367: , x_msg_count out nocopy NUMBER
368: , x_msg_data out nocopy VARCHAR2
369: , p5_a0 JTF_NUMBER_TABLE
370: , p5_a1 JTF_NUMBER_TABLE
371: , p5_a2 JTF_VARCHAR2_TABLE_100
372: , p5_a3 JTF_NUMBER_TABLE
373: , p5_a4 JTF_VARCHAR2_TABLE_300
374: , p5_a5 JTF_DATE_TABLE
375: , p5_a6 JTF_NUMBER_TABLE

Line 376: , p5_a7 JTF_VARCHAR2_TABLE_100

372: , p5_a3 JTF_NUMBER_TABLE
373: , p5_a4 JTF_VARCHAR2_TABLE_300
374: , p5_a5 JTF_DATE_TABLE
375: , p5_a6 JTF_NUMBER_TABLE
376: , p5_a7 JTF_VARCHAR2_TABLE_100
377: , p5_a8 JTF_DATE_TABLE
378: , p5_a9 JTF_NUMBER_TABLE
379: , p5_a10 JTF_DATE_TABLE
380: , p5_a11 JTF_NUMBER_TABLE

Line 382: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

378: , p5_a9 JTF_NUMBER_TABLE
379: , p5_a10 JTF_DATE_TABLE
380: , p5_a11 JTF_NUMBER_TABLE
381: , p6_a0 in out nocopy JTF_NUMBER_TABLE
382: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a2 in out nocopy JTF_NUMBER_TABLE
384: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a4 in out nocopy JTF_NUMBER_TABLE
386: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 386: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

382: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a2 in out nocopy JTF_NUMBER_TABLE
384: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a4 in out nocopy JTF_NUMBER_TABLE
386: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
388: );
389: procedure validate_row(p_api_version NUMBER
390: , p_init_msg_list VARCHAR2

Line 387: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

383: , p6_a2 in out nocopy JTF_NUMBER_TABLE
384: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a4 in out nocopy JTF_NUMBER_TABLE
386: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
388: );
389: procedure validate_row(p_api_version NUMBER
390: , p_init_msg_list VARCHAR2
391: , x_return_status out nocopy VARCHAR2

Line 396: , p5_a2 JTF_VARCHAR2_TABLE_100

392: , x_msg_count out nocopy NUMBER
393: , x_msg_data out nocopy VARCHAR2
394: , p5_a0 JTF_NUMBER_TABLE
395: , p5_a1 JTF_NUMBER_TABLE
396: , p5_a2 JTF_VARCHAR2_TABLE_100
397: , p5_a3 JTF_NUMBER_TABLE
398: , p5_a4 JTF_VARCHAR2_TABLE_300
399: , p5_a5 JTF_DATE_TABLE
400: , p5_a6 JTF_NUMBER_TABLE

Line 401: , p5_a7 JTF_VARCHAR2_TABLE_100

397: , p5_a3 JTF_NUMBER_TABLE
398: , p5_a4 JTF_VARCHAR2_TABLE_300
399: , p5_a5 JTF_DATE_TABLE
400: , p5_a6 JTF_NUMBER_TABLE
401: , p5_a7 JTF_VARCHAR2_TABLE_100
402: , p5_a8 JTF_DATE_TABLE
403: , p5_a9 JTF_NUMBER_TABLE
404: , p5_a10 JTF_DATE_TABLE
405: , p5_a11 JTF_NUMBER_TABLE