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.DPP_UIWRAPPER_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 4: , a1 JTF_VARCHAR2_TABLE_300

1: package dpp_uiwrapper_pvt_w as
2: /* $Header: dppvuirs.pls 120.8 2008/05/19 09:17:28 cthour noship $ */
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_100

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_100
86: , a2 out nocopy JTF_VARCHAR2_TABLE_300
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: );
89:
90: procedure rosetta_table_copy_in_p19(t out nocopy dpp_uiwrapper_pvt.warehouse_tbl_type, a0 JTF_NUMBER_TABLE

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_100
228: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
229: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100

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_100
228: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300
229: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
230: , x_rec_count out nocopy NUMBER
231: , x_return_status out nocopy VARCHAR2
232: );

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: procedure search_warehouses(p0_a0 JTF_VARCHAR2_TABLE_100

Line 242: , p0_a1 JTF_VARCHAR2_TABLE_300

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

Line 245: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 273: , p0_a1 JTF_VARCHAR2_TABLE_300

269: , x_rec_count out nocopy NUMBER
270: , x_return_status out nocopy VARCHAR2
271: );
272: procedure search_customers(p0_a0 JTF_VARCHAR2_TABLE_100
273: , p0_a1 JTF_VARCHAR2_TABLE_300
274: , p1_a0 out nocopy JTF_NUMBER_TABLE
275: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
276: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_400
277: , x_rec_count out nocopy NUMBER

Line 335: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300

331: , x_return_status out nocopy VARCHAR2
332: );
333: procedure get_warehouse(p0_a0 in out nocopy JTF_NUMBER_TABLE
334: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100
335: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300
336: , x_rec_count out nocopy NUMBER
337: , x_return_status out nocopy VARCHAR2
338: );
339: procedure get_customer(p0_a0 in out nocopy JTF_NUMBER_TABLE

Line 347: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300

343: , x_return_status out nocopy VARCHAR2
344: );
345: procedure get_product(p0_a0 in out nocopy JTF_NUMBER_TABLE
346: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100
347: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_300
348: , p_org_id NUMBER
349: , x_rec_count out nocopy NUMBER
350: , x_return_status out nocopy VARCHAR2
351: );

Line 375: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_300

371: , p7_a8 out nocopy JTF_NUMBER_TABLE
372: , p7_a9 out nocopy JTF_NUMBER_TABLE
373: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500
374: , p7_a11 out nocopy JTF_NUMBER_TABLE
375: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_300
376: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
377: );
378: procedure process_user_action(p_api_version NUMBER
379: , p_init_msg_list VARCHAR2