APPS.OKL_QLS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_qls_pvt_w as
2: /* $Header: OKLIQLSS.pls 120.2 2005/07/18 15:55:09 viselvar noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qls_pvt.qlsv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLIQLSS.pls 120.2 2005/07/18 15:55:09 viselvar noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qls_pvt.qlsv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE

Line 16: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 18: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 29: , a1 JTF_VARCHAR2_TABLE_100

25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE

Line 31: , a3 JTF_VARCHAR2_TABLE_100

27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_DATE_TABLE

Line 41: , a1 out nocopy JTF_VARCHAR2_TABLE_100

37: , a9 JTF_DATE_TABLE
38: , a10 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE

Line 43: , a3 out nocopy JTF_VARCHAR2_TABLE_100

39: );
40: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_DATE_TABLE

Line 87: , p5_a1 JTF_VARCHAR2_TABLE_100

83: , x_return_status out nocopy VARCHAR2
84: , x_msg_count out nocopy NUMBER
85: , x_msg_data out nocopy VARCHAR2
86: , p5_a0 JTF_NUMBER_TABLE
87: , p5_a1 JTF_VARCHAR2_TABLE_100
88: , p5_a2 JTF_NUMBER_TABLE
89: , p5_a3 JTF_VARCHAR2_TABLE_100
90: , p5_a4 JTF_NUMBER_TABLE
91: , p5_a5 JTF_NUMBER_TABLE

Line 89: , p5_a3 JTF_VARCHAR2_TABLE_100

85: , x_msg_data out nocopy VARCHAR2
86: , p5_a0 JTF_NUMBER_TABLE
87: , p5_a1 JTF_VARCHAR2_TABLE_100
88: , p5_a2 JTF_NUMBER_TABLE
89: , p5_a3 JTF_VARCHAR2_TABLE_100
90: , p5_a4 JTF_NUMBER_TABLE
91: , p5_a5 JTF_NUMBER_TABLE
92: , p5_a6 JTF_NUMBER_TABLE
93: , p5_a7 JTF_DATE_TABLE

Line 98: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

94: , p5_a8 JTF_NUMBER_TABLE
95: , p5_a9 JTF_DATE_TABLE
96: , p5_a10 JTF_NUMBER_TABLE
97: , p6_a0 out nocopy JTF_NUMBER_TABLE
98: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a2 out nocopy JTF_NUMBER_TABLE
100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , p6_a4 out nocopy JTF_NUMBER_TABLE
102: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

96: , p5_a10 JTF_NUMBER_TABLE
97: , p6_a0 out nocopy JTF_NUMBER_TABLE
98: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a2 out nocopy JTF_NUMBER_TABLE
100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , p6_a4 out nocopy JTF_NUMBER_TABLE
102: , p6_a5 out nocopy JTF_NUMBER_TABLE
103: , p6_a6 out nocopy JTF_NUMBER_TABLE
104: , p6_a7 out nocopy JTF_DATE_TABLE

Line 109: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

105: , p6_a8 out nocopy JTF_NUMBER_TABLE
106: , p6_a9 out nocopy JTF_DATE_TABLE
107: , p6_a10 out nocopy JTF_NUMBER_TABLE
108: , p7_a0 in out nocopy JTF_NUMBER_TABLE
109: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p7_a2 in out nocopy JTF_NUMBER_TABLE
111: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
112: , p7_a4 in out nocopy JTF_NUMBER_TABLE
113: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 113: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

109: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p7_a2 in out nocopy JTF_NUMBER_TABLE
111: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
112: , p7_a4 in out nocopy JTF_NUMBER_TABLE
113: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
115: );
116: procedure insert_row(p_api_version NUMBER
117: , p_init_msg_list VARCHAR2

Line 114: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

110: , p7_a2 in out nocopy JTF_NUMBER_TABLE
111: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
112: , p7_a4 in out nocopy JTF_NUMBER_TABLE
113: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
115: );
116: procedure insert_row(p_api_version NUMBER
117: , p_init_msg_list VARCHAR2
118: , x_return_status out nocopy VARCHAR2

Line 122: , p5_a1 JTF_VARCHAR2_TABLE_100

118: , x_return_status out nocopy VARCHAR2
119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_VARCHAR2_TABLE_100
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_VARCHAR2_TABLE_100
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_NUMBER_TABLE

Line 124: , p5_a3 JTF_VARCHAR2_TABLE_100

120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_VARCHAR2_TABLE_100
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_VARCHAR2_TABLE_100
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_NUMBER_TABLE
127: , p5_a6 JTF_NUMBER_TABLE
128: , p5_a7 JTF_DATE_TABLE

Line 133: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

129: , p5_a8 JTF_NUMBER_TABLE
130: , p5_a9 JTF_DATE_TABLE
131: , p5_a10 JTF_NUMBER_TABLE
132: , p6_a0 out nocopy JTF_NUMBER_TABLE
133: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 out nocopy JTF_NUMBER_TABLE
135: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a4 out nocopy JTF_NUMBER_TABLE
137: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 135: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

131: , p5_a10 JTF_NUMBER_TABLE
132: , p6_a0 out nocopy JTF_NUMBER_TABLE
133: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 out nocopy JTF_NUMBER_TABLE
135: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a4 out nocopy JTF_NUMBER_TABLE
137: , p6_a5 out nocopy JTF_NUMBER_TABLE
138: , p6_a6 out nocopy JTF_NUMBER_TABLE
139: , p6_a7 out nocopy JTF_DATE_TABLE

Line 167: , p5_a1 JTF_VARCHAR2_TABLE_100

163: , x_return_status out nocopy VARCHAR2
164: , x_msg_count out nocopy NUMBER
165: , x_msg_data out nocopy VARCHAR2
166: , p5_a0 JTF_NUMBER_TABLE
167: , p5_a1 JTF_VARCHAR2_TABLE_100
168: , p5_a2 JTF_NUMBER_TABLE
169: , p5_a3 JTF_VARCHAR2_TABLE_100
170: , p5_a4 JTF_NUMBER_TABLE
171: , p5_a5 JTF_NUMBER_TABLE

Line 169: , p5_a3 JTF_VARCHAR2_TABLE_100

165: , x_msg_data out nocopy VARCHAR2
166: , p5_a0 JTF_NUMBER_TABLE
167: , p5_a1 JTF_VARCHAR2_TABLE_100
168: , p5_a2 JTF_NUMBER_TABLE
169: , p5_a3 JTF_VARCHAR2_TABLE_100
170: , p5_a4 JTF_NUMBER_TABLE
171: , p5_a5 JTF_NUMBER_TABLE
172: , p5_a6 JTF_NUMBER_TABLE
173: , p5_a7 JTF_DATE_TABLE

Line 178: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

174: , p5_a8 JTF_NUMBER_TABLE
175: , p5_a9 JTF_DATE_TABLE
176: , p5_a10 JTF_NUMBER_TABLE
177: , p6_a0 in out nocopy JTF_NUMBER_TABLE
178: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a2 in out nocopy JTF_NUMBER_TABLE
180: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
181: , p6_a4 in out nocopy JTF_NUMBER_TABLE
182: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 182: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

178: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a2 in out nocopy JTF_NUMBER_TABLE
180: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
181: , p6_a4 in out nocopy JTF_NUMBER_TABLE
182: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
184: );
185: procedure lock_row(p_api_version NUMBER
186: , p_init_msg_list VARCHAR2

Line 183: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

179: , p6_a2 in out nocopy JTF_NUMBER_TABLE
180: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
181: , p6_a4 in out nocopy JTF_NUMBER_TABLE
182: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
184: );
185: procedure lock_row(p_api_version NUMBER
186: , p_init_msg_list VARCHAR2
187: , x_return_status out nocopy VARCHAR2

Line 191: , p5_a1 JTF_VARCHAR2_TABLE_100

187: , x_return_status out nocopy VARCHAR2
188: , x_msg_count out nocopy NUMBER
189: , x_msg_data out nocopy VARCHAR2
190: , p5_a0 JTF_NUMBER_TABLE
191: , p5_a1 JTF_VARCHAR2_TABLE_100
192: , p5_a2 JTF_NUMBER_TABLE
193: , p5_a3 JTF_VARCHAR2_TABLE_100
194: , p5_a4 JTF_NUMBER_TABLE
195: , p5_a5 JTF_NUMBER_TABLE

Line 193: , p5_a3 JTF_VARCHAR2_TABLE_100

189: , x_msg_data out nocopy VARCHAR2
190: , p5_a0 JTF_NUMBER_TABLE
191: , p5_a1 JTF_VARCHAR2_TABLE_100
192: , p5_a2 JTF_NUMBER_TABLE
193: , p5_a3 JTF_VARCHAR2_TABLE_100
194: , p5_a4 JTF_NUMBER_TABLE
195: , p5_a5 JTF_NUMBER_TABLE
196: , p5_a6 JTF_NUMBER_TABLE
197: , p5_a7 JTF_DATE_TABLE

Line 236: , p5_a1 JTF_VARCHAR2_TABLE_100

232: , x_return_status out nocopy VARCHAR2
233: , x_msg_count out nocopy NUMBER
234: , x_msg_data out nocopy VARCHAR2
235: , p5_a0 JTF_NUMBER_TABLE
236: , p5_a1 JTF_VARCHAR2_TABLE_100
237: , p5_a2 JTF_NUMBER_TABLE
238: , p5_a3 JTF_VARCHAR2_TABLE_100
239: , p5_a4 JTF_NUMBER_TABLE
240: , p5_a5 JTF_NUMBER_TABLE

Line 238: , p5_a3 JTF_VARCHAR2_TABLE_100

234: , x_msg_data out nocopy VARCHAR2
235: , p5_a0 JTF_NUMBER_TABLE
236: , p5_a1 JTF_VARCHAR2_TABLE_100
237: , p5_a2 JTF_NUMBER_TABLE
238: , p5_a3 JTF_VARCHAR2_TABLE_100
239: , p5_a4 JTF_NUMBER_TABLE
240: , p5_a5 JTF_NUMBER_TABLE
241: , p5_a6 JTF_NUMBER_TABLE
242: , p5_a7 JTF_DATE_TABLE

Line 247: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

243: , p5_a8 JTF_NUMBER_TABLE
244: , p5_a9 JTF_DATE_TABLE
245: , p5_a10 JTF_NUMBER_TABLE
246: , p6_a0 out nocopy JTF_NUMBER_TABLE
247: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a2 out nocopy JTF_NUMBER_TABLE
249: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
250: , p6_a4 out nocopy JTF_NUMBER_TABLE
251: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 249: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

245: , p5_a10 JTF_NUMBER_TABLE
246: , p6_a0 out nocopy JTF_NUMBER_TABLE
247: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a2 out nocopy JTF_NUMBER_TABLE
249: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
250: , p6_a4 out nocopy JTF_NUMBER_TABLE
251: , p6_a5 out nocopy JTF_NUMBER_TABLE
252: , p6_a6 out nocopy JTF_NUMBER_TABLE
253: , p6_a7 out nocopy JTF_DATE_TABLE

Line 258: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

254: , p6_a8 out nocopy JTF_NUMBER_TABLE
255: , p6_a9 out nocopy JTF_DATE_TABLE
256: , p6_a10 out nocopy JTF_NUMBER_TABLE
257: , p7_a0 in out nocopy JTF_NUMBER_TABLE
258: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p7_a2 in out nocopy JTF_NUMBER_TABLE
260: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
261: , p7_a4 in out nocopy JTF_NUMBER_TABLE
262: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 262: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

258: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p7_a2 in out nocopy JTF_NUMBER_TABLE
260: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
261: , p7_a4 in out nocopy JTF_NUMBER_TABLE
262: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
264: );
265: procedure update_row(p_api_version NUMBER
266: , p_init_msg_list VARCHAR2

Line 263: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

259: , p7_a2 in out nocopy JTF_NUMBER_TABLE
260: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
261: , p7_a4 in out nocopy JTF_NUMBER_TABLE
262: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
264: );
265: procedure update_row(p_api_version NUMBER
266: , p_init_msg_list VARCHAR2
267: , x_return_status out nocopy VARCHAR2

Line 271: , p5_a1 JTF_VARCHAR2_TABLE_100

267: , x_return_status out nocopy VARCHAR2
268: , x_msg_count out nocopy NUMBER
269: , x_msg_data out nocopy VARCHAR2
270: , p5_a0 JTF_NUMBER_TABLE
271: , p5_a1 JTF_VARCHAR2_TABLE_100
272: , p5_a2 JTF_NUMBER_TABLE
273: , p5_a3 JTF_VARCHAR2_TABLE_100
274: , p5_a4 JTF_NUMBER_TABLE
275: , p5_a5 JTF_NUMBER_TABLE

Line 273: , p5_a3 JTF_VARCHAR2_TABLE_100

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

Line 282: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

278: , p5_a8 JTF_NUMBER_TABLE
279: , p5_a9 JTF_DATE_TABLE
280: , p5_a10 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a2 out nocopy JTF_NUMBER_TABLE
284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a4 out nocopy JTF_NUMBER_TABLE
286: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

280: , p5_a10 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a2 out nocopy JTF_NUMBER_TABLE
284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a4 out nocopy JTF_NUMBER_TABLE
286: , p6_a5 out nocopy JTF_NUMBER_TABLE
287: , p6_a6 out nocopy JTF_NUMBER_TABLE
288: , p6_a7 out nocopy JTF_DATE_TABLE

Line 316: , p5_a1 JTF_VARCHAR2_TABLE_100

312: , x_return_status out nocopy VARCHAR2
313: , x_msg_count out nocopy NUMBER
314: , x_msg_data out nocopy VARCHAR2
315: , p5_a0 JTF_NUMBER_TABLE
316: , p5_a1 JTF_VARCHAR2_TABLE_100
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_NUMBER_TABLE

Line 318: , p5_a3 JTF_VARCHAR2_TABLE_100

314: , x_msg_data out nocopy VARCHAR2
315: , p5_a0 JTF_NUMBER_TABLE
316: , p5_a1 JTF_VARCHAR2_TABLE_100
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_NUMBER_TABLE
321: , p5_a6 JTF_NUMBER_TABLE
322: , p5_a7 JTF_DATE_TABLE

Line 327: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

323: , p5_a8 JTF_NUMBER_TABLE
324: , p5_a9 JTF_DATE_TABLE
325: , p5_a10 JTF_NUMBER_TABLE
326: , p6_a0 in out nocopy JTF_NUMBER_TABLE
327: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 in out nocopy JTF_NUMBER_TABLE
329: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
330: , p6_a4 in out nocopy JTF_NUMBER_TABLE
331: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 331: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

327: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 in out nocopy JTF_NUMBER_TABLE
329: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
330: , p6_a4 in out nocopy JTF_NUMBER_TABLE
331: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
333: );
334: procedure delete_row(p_api_version NUMBER
335: , p_init_msg_list VARCHAR2

Line 332: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

328: , p6_a2 in out nocopy JTF_NUMBER_TABLE
329: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
330: , p6_a4 in out nocopy JTF_NUMBER_TABLE
331: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
333: );
334: procedure delete_row(p_api_version NUMBER
335: , p_init_msg_list VARCHAR2
336: , x_return_status out nocopy VARCHAR2

Line 340: , p5_a1 JTF_VARCHAR2_TABLE_100

336: , x_return_status out nocopy VARCHAR2
337: , x_msg_count out nocopy NUMBER
338: , x_msg_data out nocopy VARCHAR2
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_VARCHAR2_TABLE_100
341: , p5_a2 JTF_NUMBER_TABLE
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE

Line 342: , p5_a3 JTF_VARCHAR2_TABLE_100

338: , x_msg_data out nocopy VARCHAR2
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_VARCHAR2_TABLE_100
341: , p5_a2 JTF_NUMBER_TABLE
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_DATE_TABLE

Line 374: , p5_a1 JTF_VARCHAR2_TABLE_100

370: , x_return_status out nocopy VARCHAR2
371: , x_msg_count out nocopy NUMBER
372: , x_msg_data out nocopy VARCHAR2
373: , p5_a0 JTF_NUMBER_TABLE
374: , p5_a1 JTF_VARCHAR2_TABLE_100
375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_NUMBER_TABLE
378: , p5_a5 JTF_NUMBER_TABLE

Line 376: , p5_a3 JTF_VARCHAR2_TABLE_100

372: , x_msg_data out nocopy VARCHAR2
373: , p5_a0 JTF_NUMBER_TABLE
374: , p5_a1 JTF_VARCHAR2_TABLE_100
375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_NUMBER_TABLE
378: , p5_a5 JTF_NUMBER_TABLE
379: , p5_a6 JTF_NUMBER_TABLE
380: , p5_a7 JTF_DATE_TABLE

Line 385: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

381: , p5_a8 JTF_NUMBER_TABLE
382: , p5_a9 JTF_DATE_TABLE
383: , p5_a10 JTF_NUMBER_TABLE
384: , p6_a0 in out nocopy JTF_NUMBER_TABLE
385: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p6_a2 in out nocopy JTF_NUMBER_TABLE
387: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
388: , p6_a4 in out nocopy JTF_NUMBER_TABLE
389: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 389: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 390: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 398: , p5_a1 JTF_VARCHAR2_TABLE_100

394: , x_return_status out nocopy VARCHAR2
395: , x_msg_count out nocopy NUMBER
396: , x_msg_data out nocopy VARCHAR2
397: , p5_a0 JTF_NUMBER_TABLE
398: , p5_a1 JTF_VARCHAR2_TABLE_100
399: , p5_a2 JTF_NUMBER_TABLE
400: , p5_a3 JTF_VARCHAR2_TABLE_100
401: , p5_a4 JTF_NUMBER_TABLE
402: , p5_a5 JTF_NUMBER_TABLE

Line 400: , p5_a3 JTF_VARCHAR2_TABLE_100

396: , x_msg_data out nocopy VARCHAR2
397: , p5_a0 JTF_NUMBER_TABLE
398: , p5_a1 JTF_VARCHAR2_TABLE_100
399: , p5_a2 JTF_NUMBER_TABLE
400: , p5_a3 JTF_VARCHAR2_TABLE_100
401: , p5_a4 JTF_NUMBER_TABLE
402: , p5_a5 JTF_NUMBER_TABLE
403: , p5_a6 JTF_NUMBER_TABLE
404: , p5_a7 JTF_DATE_TABLE