APPS.DPP_UIWRAPPER_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 4: , a1 JTF_VARCHAR2_TABLE_300

1: package dpp_uiwrapper_pvt_w AUTHID CURRENT_USER as
2: /* $Header: dppvuirs.pls 120.8.12010000.3 2010/03/26 11:44:15 rvkondur ship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy dpp_uiwrapper_pvt.search_criteria_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_300
5: );
6: procedure rosetta_table_copy_out_p5(t dpp_uiwrapper_pvt.search_criteria_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_300
8: );

Line 7: , a1 out nocopy JTF_VARCHAR2_TABLE_300

3: procedure rosetta_table_copy_in_p5(t out nocopy dpp_uiwrapper_pvt.search_criteria_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_300
5: );
6: procedure rosetta_table_copy_out_p5(t dpp_uiwrapper_pvt.search_criteria_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_300
8: );
9:
10: procedure rosetta_table_copy_in_p7(t out nocopy dpp_uiwrapper_pvt.vendor_tbl_type, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100

Line 12: , a2 JTF_VARCHAR2_TABLE_300

8: );
9:
10: procedure rosetta_table_copy_in_p7(t out nocopy dpp_uiwrapper_pvt.vendor_tbl_type, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_300
13: );
14: procedure rosetta_table_copy_out_p7(t dpp_uiwrapper_pvt.vendor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 16: , a2 out nocopy JTF_VARCHAR2_TABLE_300

12: , a2 JTF_VARCHAR2_TABLE_300
13: );
14: procedure rosetta_table_copy_out_p7(t dpp_uiwrapper_pvt.vendor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_300
17: );
18:
19: procedure rosetta_table_copy_in_p9(t out nocopy dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 JTF_NUMBER_TABLE
20: , a1 JTF_NUMBER_TABLE

Line 22: , a3 JTF_VARCHAR2_TABLE_300

18:
19: procedure rosetta_table_copy_in_p9(t out nocopy dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 JTF_NUMBER_TABLE
20: , a1 JTF_NUMBER_TABLE
21: , a2 JTF_VARCHAR2_TABLE_100
22: , a3 JTF_VARCHAR2_TABLE_300
23: , a4 JTF_VARCHAR2_TABLE_300
24: , a5 JTF_VARCHAR2_TABLE_300
25: , a6 JTF_VARCHAR2_TABLE_100
26: , a7 JTF_VARCHAR2_TABLE_200

Line 23: , a4 JTF_VARCHAR2_TABLE_300

19: procedure rosetta_table_copy_in_p9(t out nocopy dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 JTF_NUMBER_TABLE
20: , a1 JTF_NUMBER_TABLE
21: , a2 JTF_VARCHAR2_TABLE_100
22: , a3 JTF_VARCHAR2_TABLE_300
23: , a4 JTF_VARCHAR2_TABLE_300
24: , a5 JTF_VARCHAR2_TABLE_300
25: , a6 JTF_VARCHAR2_TABLE_100
26: , a7 JTF_VARCHAR2_TABLE_200
27: , a8 JTF_VARCHAR2_TABLE_100

Line 24: , a5 JTF_VARCHAR2_TABLE_300

20: , a1 JTF_NUMBER_TABLE
21: , a2 JTF_VARCHAR2_TABLE_100
22: , a3 JTF_VARCHAR2_TABLE_300
23: , a4 JTF_VARCHAR2_TABLE_300
24: , a5 JTF_VARCHAR2_TABLE_300
25: , a6 JTF_VARCHAR2_TABLE_100
26: , a7 JTF_VARCHAR2_TABLE_200
27: , a8 JTF_VARCHAR2_TABLE_100
28: , a9 JTF_VARCHAR2_TABLE_100

Line 33: , a3 out nocopy JTF_VARCHAR2_TABLE_300

29: );
30: procedure rosetta_table_copy_out_p9(t dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_VARCHAR2_TABLE_300
34: , a4 out nocopy JTF_VARCHAR2_TABLE_300
35: , a5 out nocopy JTF_VARCHAR2_TABLE_300
36: , a6 out nocopy JTF_VARCHAR2_TABLE_100
37: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 34: , a4 out nocopy JTF_VARCHAR2_TABLE_300

30: procedure rosetta_table_copy_out_p9(t dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_VARCHAR2_TABLE_300
34: , a4 out nocopy JTF_VARCHAR2_TABLE_300
35: , a5 out nocopy JTF_VARCHAR2_TABLE_300
36: , a6 out nocopy JTF_VARCHAR2_TABLE_100
37: , a7 out nocopy JTF_VARCHAR2_TABLE_200
38: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 35: , a5 out nocopy JTF_VARCHAR2_TABLE_300

31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_VARCHAR2_TABLE_300
34: , a4 out nocopy JTF_VARCHAR2_TABLE_300
35: , a5 out nocopy JTF_VARCHAR2_TABLE_300
36: , a6 out nocopy JTF_VARCHAR2_TABLE_100
37: , a7 out nocopy JTF_VARCHAR2_TABLE_200
38: , a8 out nocopy JTF_VARCHAR2_TABLE_100
39: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 72: , a2 JTF_VARCHAR2_TABLE_300

68: );
69:
70: procedure rosetta_table_copy_in_p15(t out nocopy dpp_uiwrapper_pvt.item_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_VARCHAR2_TABLE_300
73: );
74: procedure rosetta_table_copy_out_p15(t dpp_uiwrapper_pvt.item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 76: , a2 out nocopy JTF_VARCHAR2_TABLE_300

72: , a2 JTF_VARCHAR2_TABLE_300
73: );
74: procedure rosetta_table_copy_out_p15(t dpp_uiwrapper_pvt.item_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , a2 out nocopy JTF_VARCHAR2_TABLE_300
77: );
78:
79: procedure rosetta_table_copy_in_p17(t out nocopy dpp_uiwrapper_pvt.itemnum_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_VARCHAR2_TABLE_100

Line 81: , a2 JTF_VARCHAR2_TABLE_300

77: );
78:
79: procedure rosetta_table_copy_in_p17(t out nocopy dpp_uiwrapper_pvt.itemnum_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_300
82: , a3 JTF_VARCHAR2_TABLE_100
83: );
84: procedure rosetta_table_copy_out_p17(t dpp_uiwrapper_pvt.itemnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_300

Line 85: , a1 out nocopy JTF_VARCHAR2_TABLE_300

81: , a2 JTF_VARCHAR2_TABLE_300
82: , a3 JTF_VARCHAR2_TABLE_100
83: );
84: procedure rosetta_table_copy_out_p17(t dpp_uiwrapper_pvt.itemnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_300
86: , a2 out nocopy JTF_VARCHAR2_TABLE_300
87: , a3 out nocopy JTF_VARCHAR2_TABLE_300
88: );
89:

Line 86: , a2 out nocopy JTF_VARCHAR2_TABLE_300

82: , a3 JTF_VARCHAR2_TABLE_100
83: );
84: procedure rosetta_table_copy_out_p17(t dpp_uiwrapper_pvt.itemnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_300
86: , a2 out nocopy JTF_VARCHAR2_TABLE_300
87: , a3 out nocopy JTF_VARCHAR2_TABLE_300
88: );
89:
90: procedure rosetta_table_copy_in_p19(t out nocopy dpp_uiwrapper_pvt.warehouse_tbl_type, a0 JTF_NUMBER_TABLE

Line 87: , a3 out nocopy JTF_VARCHAR2_TABLE_300

83: );
84: procedure rosetta_table_copy_out_p17(t dpp_uiwrapper_pvt.itemnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_300
86: , a2 out nocopy JTF_VARCHAR2_TABLE_300
87: , a3 out nocopy JTF_VARCHAR2_TABLE_300
88: );
89:
90: procedure rosetta_table_copy_in_p19(t out nocopy dpp_uiwrapper_pvt.warehouse_tbl_type, a0 JTF_NUMBER_TABLE
91: , a1 JTF_VARCHAR2_TABLE_100

Line 92: , a2 JTF_VARCHAR2_TABLE_300

88: );
89:
90: procedure rosetta_table_copy_in_p19(t out nocopy dpp_uiwrapper_pvt.warehouse_tbl_type, a0 JTF_NUMBER_TABLE
91: , a1 JTF_VARCHAR2_TABLE_100
92: , a2 JTF_VARCHAR2_TABLE_300
93: );
94: procedure rosetta_table_copy_out_p19(t dpp_uiwrapper_pvt.warehouse_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_100
96: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 96: , a2 out nocopy JTF_VARCHAR2_TABLE_300

92: , a2 JTF_VARCHAR2_TABLE_300
93: );
94: procedure rosetta_table_copy_out_p19(t dpp_uiwrapper_pvt.warehouse_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_100
96: , a2 out nocopy JTF_VARCHAR2_TABLE_300
97: );
98:
99: procedure rosetta_table_copy_in_p22(t out nocopy dpp_uiwrapper_pvt.dpp_inv_cov_rct_tbl_type, a0 JTF_DATE_TABLE
100: , a1 JTF_NUMBER_TABLE

Line 166: , a12 JTF_VARCHAR2_TABLE_300

162: , a8 JTF_NUMBER_TABLE
163: , a9 JTF_NUMBER_TABLE
164: , a10 JTF_VARCHAR2_TABLE_500
165: , a11 JTF_NUMBER_TABLE
166: , a12 JTF_VARCHAR2_TABLE_300
167: , a13 JTF_VARCHAR2_TABLE_100
168: );
169: procedure rosetta_table_copy_out_p33(t dpp_uiwrapper_pvt.approverstable, a0 out nocopy JTF_NUMBER_TABLE
170: , a1 out nocopy JTF_NUMBER_TABLE

Line 181: , a12 out nocopy JTF_VARCHAR2_TABLE_300

177: , a8 out nocopy JTF_NUMBER_TABLE
178: , a9 out nocopy JTF_NUMBER_TABLE
179: , a10 out nocopy JTF_VARCHAR2_TABLE_500
180: , a11 out nocopy JTF_NUMBER_TABLE
181: , a12 out nocopy JTF_VARCHAR2_TABLE_300
182: , a13 out nocopy JTF_VARCHAR2_TABLE_100
183: );
184:
185: procedure rosetta_table_copy_in_p35(t out nocopy dpp_uiwrapper_pvt.dpp_txn_line_tbl_type, a0 JTF_NUMBER_TABLE);

Line 189: , p0_a1 JTF_VARCHAR2_TABLE_300

185: procedure rosetta_table_copy_in_p35(t out nocopy dpp_uiwrapper_pvt.dpp_txn_line_tbl_type, a0 JTF_NUMBER_TABLE);
186: procedure rosetta_table_copy_out_p35(t dpp_uiwrapper_pvt.dpp_txn_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
187:
188: procedure search_vendors(p0_a0 JTF_VARCHAR2_TABLE_100
189: , p0_a1 JTF_VARCHAR2_TABLE_300
190: , p1_a0 out nocopy JTF_NUMBER_TABLE
191: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
192: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
193: , x_rec_count out nocopy NUMBER

Line 192: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300

188: procedure search_vendors(p0_a0 JTF_VARCHAR2_TABLE_100
189: , p0_a1 JTF_VARCHAR2_TABLE_300
190: , p1_a0 out nocopy JTF_NUMBER_TABLE
191: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
192: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
193: , x_rec_count out nocopy NUMBER
194: , x_return_status out nocopy VARCHAR2
195: );
196: procedure search_vendor_sites(p0_a0 JTF_VARCHAR2_TABLE_100

Line 197: , p0_a1 JTF_VARCHAR2_TABLE_300

193: , x_rec_count out nocopy NUMBER
194: , x_return_status out nocopy VARCHAR2
195: );
196: procedure search_vendor_sites(p0_a0 JTF_VARCHAR2_TABLE_100
197: , p0_a1 JTF_VARCHAR2_TABLE_300
198: , p1_a0 out nocopy JTF_NUMBER_TABLE
199: , p1_a1 out nocopy JTF_NUMBER_TABLE
200: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
201: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300

Line 201: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300

197: , p0_a1 JTF_VARCHAR2_TABLE_300
198: , p1_a0 out nocopy JTF_NUMBER_TABLE
199: , p1_a1 out nocopy JTF_NUMBER_TABLE
200: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
201: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
202: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_300
203: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_300
204: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
205: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 202: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_300

198: , p1_a0 out nocopy JTF_NUMBER_TABLE
199: , p1_a1 out nocopy JTF_NUMBER_TABLE
200: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
201: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
202: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_300
203: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_300
204: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
205: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
206: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 203: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_300

199: , p1_a1 out nocopy JTF_NUMBER_TABLE
200: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
201: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
202: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_300
203: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_300
204: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
205: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
206: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100
207: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 212: , p0_a1 JTF_VARCHAR2_TABLE_300

208: , x_rec_count out nocopy NUMBER
209: , x_return_status out nocopy VARCHAR2
210: );
211: procedure search_vendor_contacts(p0_a0 JTF_VARCHAR2_TABLE_100
212: , p0_a1 JTF_VARCHAR2_TABLE_300
213: , p1_a0 out nocopy JTF_NUMBER_TABLE
214: , p1_a1 out nocopy JTF_NUMBER_TABLE
215: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
216: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 225: , p0_a1 JTF_VARCHAR2_TABLE_300

221: , x_rec_count out nocopy NUMBER
222: , x_return_status out nocopy VARCHAR2
223: );
224: procedure search_items(p0_a0 JTF_VARCHAR2_TABLE_100
225: , p0_a1 JTF_VARCHAR2_TABLE_300
226: , p1_a0 out nocopy JTF_NUMBER_TABLE
227: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_300
228: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
229: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300

Line 227: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_300

223: );
224: procedure search_items(p0_a0 JTF_VARCHAR2_TABLE_100
225: , p0_a1 JTF_VARCHAR2_TABLE_300
226: , p1_a0 out nocopy JTF_NUMBER_TABLE
227: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_300
228: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
229: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
230: , x_rec_count out nocopy NUMBER
231: , x_return_status out nocopy VARCHAR2

Line 228: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300

224: procedure search_items(p0_a0 JTF_VARCHAR2_TABLE_100
225: , p0_a1 JTF_VARCHAR2_TABLE_300
226: , p1_a0 out nocopy JTF_NUMBER_TABLE
227: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_300
228: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
229: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
230: , x_rec_count out nocopy NUMBER
231: , x_return_status out nocopy VARCHAR2
232: );

Line 229: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300

225: , p0_a1 JTF_VARCHAR2_TABLE_300
226: , p1_a0 out nocopy JTF_NUMBER_TABLE
227: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_300
228: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
229: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
230: , x_rec_count out nocopy NUMBER
231: , x_return_status out nocopy VARCHAR2
232: );
233: procedure search_customer_items(p0_a0 JTF_VARCHAR2_TABLE_100

Line 234: , p0_a1 JTF_VARCHAR2_TABLE_300

230: , x_rec_count out nocopy NUMBER
231: , x_return_status out nocopy VARCHAR2
232: );
233: procedure search_customer_items(p0_a0 JTF_VARCHAR2_TABLE_100
234: , p0_a1 JTF_VARCHAR2_TABLE_300
235: , p1_a0 out nocopy JTF_NUMBER_TABLE
236: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
237: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
238: , x_rec_count out nocopy NUMBER

Line 237: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300

233: procedure search_customer_items(p0_a0 JTF_VARCHAR2_TABLE_100
234: , p0_a1 JTF_VARCHAR2_TABLE_300
235: , p1_a0 out nocopy JTF_NUMBER_TABLE
236: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
237: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
238: , x_rec_count out nocopy NUMBER
239: , x_return_status out nocopy VARCHAR2
240: );
241:

Line 243: , p0_a1 JTF_VARCHAR2_TABLE_300

239: , x_return_status out nocopy VARCHAR2
240: );
241:
242: procedure search_customer_items_all(p0_a0 JTF_VARCHAR2_TABLE_100
243: , p0_a1 JTF_VARCHAR2_TABLE_300
244: , p1_a0 out nocopy JTF_NUMBER_TABLE
245: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
246: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
247: , x_rec_count out nocopy NUMBER

Line 246: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300

242: procedure search_customer_items_all(p0_a0 JTF_VARCHAR2_TABLE_100
243: , p0_a1 JTF_VARCHAR2_TABLE_300
244: , p1_a0 out nocopy JTF_NUMBER_TABLE
245: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
246: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
247: , x_rec_count out nocopy NUMBER
248: , x_return_status out nocopy VARCHAR2
249: );
250:

Line 252: , p0_a1 JTF_VARCHAR2_TABLE_300

248: , x_return_status out nocopy VARCHAR2
249: );
250:
251: procedure search_warehouses(p0_a0 JTF_VARCHAR2_TABLE_100
252: , p0_a1 JTF_VARCHAR2_TABLE_300
253: , p1_a0 out nocopy JTF_NUMBER_TABLE
254: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
255: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
256: , x_rec_count out nocopy NUMBER

Line 255: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300

251: procedure search_warehouses(p0_a0 JTF_VARCHAR2_TABLE_100
252: , p0_a1 JTF_VARCHAR2_TABLE_300
253: , p1_a0 out nocopy JTF_NUMBER_TABLE
254: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
255: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
256: , x_rec_count out nocopy NUMBER
257: , x_return_status out nocopy VARCHAR2
258: );
259: procedure get_inventorydetails(p0_a0 NUMBER

Line 283: , p0_a1 JTF_VARCHAR2_TABLE_300

279: , x_rec_count out nocopy NUMBER
280: , x_return_status out nocopy VARCHAR2
281: );
282: procedure search_customers(p0_a0 JTF_VARCHAR2_TABLE_100
283: , p0_a1 JTF_VARCHAR2_TABLE_300
284: , p1_a0 out nocopy JTF_NUMBER_TABLE
285: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
286: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_400
287: , x_rec_count out nocopy NUMBER

Line 292: , p0_a1 JTF_VARCHAR2_TABLE_300

288: , x_return_status out nocopy VARCHAR2
289: );
290:
291: procedure search_customers_all(p0_a0 JTF_VARCHAR2_TABLE_100
292: , p0_a1 JTF_VARCHAR2_TABLE_300
293: , p1_a0 out nocopy JTF_NUMBER_TABLE
294: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
295: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_400
296: , x_rec_count out nocopy NUMBER

Line 355: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300

351: , x_return_status out nocopy VARCHAR2
352: );
353: procedure get_warehouse(p0_a0 in out nocopy JTF_NUMBER_TABLE
354: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100
355: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300
356: , x_rec_count out nocopy NUMBER
357: , x_return_status out nocopy VARCHAR2
358: );
359: procedure get_customer(p0_a0 in out nocopy JTF_NUMBER_TABLE

Line 367: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300

363: , x_return_status out nocopy VARCHAR2
364: );
365: procedure get_product(p0_a0 in out nocopy JTF_NUMBER_TABLE
366: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100
367: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300
368: , p_org_id NUMBER
369: , x_rec_count out nocopy NUMBER
370: , x_return_status out nocopy VARCHAR2
371: );

Line 395: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_300

391: , p7_a8 out nocopy JTF_NUMBER_TABLE
392: , p7_a9 out nocopy JTF_NUMBER_TABLE
393: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
394: , p7_a11 out nocopy JTF_NUMBER_TABLE
395: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_300
396: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
397: );
398: procedure process_user_action(p_api_version NUMBER
399: , p_init_msg_list VARCHAR2