APPS.DPP_UIWRAPPER_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p5(t out nocopy dpp_uiwrapper_pvt.search_criteria_tbl_type, a0 JTF_VARCHAR2_TABLE_100

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

Line 6: procedure rosetta_table_copy_out_p5(t dpp_uiwrapper_pvt.search_criteria_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

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: );
9:
10: procedure rosetta_table_copy_in_p7(t out nocopy dpp_uiwrapper_pvt.vendor_tbl_type, a0 JTF_NUMBER_TABLE

Line 11: , a1 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
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

Line 15: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
17: );
18:
19: procedure rosetta_table_copy_in_p9(t out nocopy dpp_uiwrapper_pvt.vendor_site_tbl_type, a0 JTF_NUMBER_TABLE

Line 21: , a2 JTF_VARCHAR2_TABLE_100

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
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

Line 25: , a6 JTF_VARCHAR2_TABLE_100

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
29: );

Line 27: , a8 JTF_VARCHAR2_TABLE_100

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
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

Line 28: , a9 JTF_VARCHAR2_TABLE_100

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
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

Line 32: , a2 out nocopy JTF_VARCHAR2_TABLE_100

28: , a9 JTF_VARCHAR2_TABLE_100
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

Line 36: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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
40: );

Line 38: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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
40: );
41:
42: procedure rosetta_table_copy_in_p11(t out nocopy dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 JTF_NUMBER_TABLE

Line 39: , a9 out nocopy JTF_VARCHAR2_TABLE_100

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
40: );
41:
42: procedure rosetta_table_copy_in_p11(t out nocopy dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_NUMBER_TABLE

Line 44: , a2 JTF_VARCHAR2_TABLE_100

40: );
41:
42: procedure rosetta_table_copy_in_p11(t out nocopy dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_NUMBER_TABLE
44: , a2 JTF_VARCHAR2_TABLE_100
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_VARCHAR2_TABLE_100
47: , a5 JTF_VARCHAR2_TABLE_100
48: , a6 JTF_VARCHAR2_TABLE_2000

Line 45: , a3 JTF_VARCHAR2_TABLE_100

41:
42: procedure rosetta_table_copy_in_p11(t out nocopy dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_NUMBER_TABLE
44: , a2 JTF_VARCHAR2_TABLE_100
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_VARCHAR2_TABLE_100
47: , a5 JTF_VARCHAR2_TABLE_100
48: , a6 JTF_VARCHAR2_TABLE_2000
49: , a7 JTF_VARCHAR2_TABLE_100

Line 46: , a4 JTF_VARCHAR2_TABLE_100

42: procedure rosetta_table_copy_in_p11(t out nocopy dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_NUMBER_TABLE
44: , a2 JTF_VARCHAR2_TABLE_100
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_VARCHAR2_TABLE_100
47: , a5 JTF_VARCHAR2_TABLE_100
48: , a6 JTF_VARCHAR2_TABLE_2000
49: , a7 JTF_VARCHAR2_TABLE_100
50: );

Line 47: , a5 JTF_VARCHAR2_TABLE_100

43: , a1 JTF_NUMBER_TABLE
44: , a2 JTF_VARCHAR2_TABLE_100
45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_VARCHAR2_TABLE_100
47: , a5 JTF_VARCHAR2_TABLE_100
48: , a6 JTF_VARCHAR2_TABLE_2000
49: , a7 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p11(t dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 49: , a7 JTF_VARCHAR2_TABLE_100

45: , a3 JTF_VARCHAR2_TABLE_100
46: , a4 JTF_VARCHAR2_TABLE_100
47: , a5 JTF_VARCHAR2_TABLE_100
48: , a6 JTF_VARCHAR2_TABLE_2000
49: , a7 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p11(t dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , a2 out nocopy JTF_VARCHAR2_TABLE_100

49: , a7 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p11(t dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 54: , a3 out nocopy JTF_VARCHAR2_TABLE_100

50: );
51: procedure rosetta_table_copy_out_p11(t dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 55: , a4 out nocopy JTF_VARCHAR2_TABLE_100

51: procedure rosetta_table_copy_out_p11(t dpp_uiwrapper_pvt.vendor_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: );

Line 56: , a5 out nocopy JTF_VARCHAR2_TABLE_100

52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: );
60:

Line 58: , a7 out nocopy JTF_VARCHAR2_TABLE_100

54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: );
60:
61: procedure rosetta_table_copy_in_p13(t out nocopy dpp_uiwrapper_pvt.customer_tbl_type, a0 JTF_NUMBER_TABLE
62: , a1 JTF_VARCHAR2_TABLE_100

Line 62: , a1 JTF_VARCHAR2_TABLE_100

58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: );
60:
61: procedure rosetta_table_copy_in_p13(t out nocopy dpp_uiwrapper_pvt.customer_tbl_type, a0 JTF_NUMBER_TABLE
62: , a1 JTF_VARCHAR2_TABLE_100
63: , a2 JTF_VARCHAR2_TABLE_400
64: );
65: procedure rosetta_table_copy_out_p13(t dpp_uiwrapper_pvt.customer_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 66: , a1 out nocopy JTF_VARCHAR2_TABLE_100

62: , a1 JTF_VARCHAR2_TABLE_100
63: , a2 JTF_VARCHAR2_TABLE_400
64: );
65: procedure rosetta_table_copy_out_p13(t dpp_uiwrapper_pvt.customer_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_VARCHAR2_TABLE_100
67: , a2 out nocopy JTF_VARCHAR2_TABLE_400
68: );
69:
70: procedure rosetta_table_copy_in_p15(t out nocopy dpp_uiwrapper_pvt.item_tbl_type, a0 JTF_NUMBER_TABLE

Line 71: , a1 JTF_VARCHAR2_TABLE_100

67: , a2 out nocopy JTF_VARCHAR2_TABLE_400
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

Line 75: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
77: );
78:
79: procedure rosetta_table_copy_in_p17(t out nocopy dpp_uiwrapper_pvt.itemnum_tbl_type, a0 JTF_NUMBER_TABLE

Line 80: , a1 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
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

Line 82: , a3 JTF_VARCHAR2_TABLE_100

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
86: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 85: , a1 out nocopy 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
86: , a2 out nocopy JTF_VARCHAR2_TABLE_300
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: );
89:

Line 87: , a3 out nocopy 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
91: , a1 JTF_VARCHAR2_TABLE_100

Line 91: , a1 JTF_VARCHAR2_TABLE_100

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
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

Line 95: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 108: , a2 JTF_VARCHAR2_TABLE_100

104: );
105:
106: procedure rosetta_table_copy_in_p24(t out nocopy dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 JTF_NUMBER_TABLE
107: , a1 JTF_NUMBER_TABLE
108: , a2 JTF_VARCHAR2_TABLE_100
109: , a3 JTF_NUMBER_TABLE
110: , a4 JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p24(t dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 114: , a2 out nocopy JTF_VARCHAR2_TABLE_100

110: , a4 JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p24(t dpp_uiwrapper_pvt.inventorydetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: );
118:

Line 121: , a2 JTF_VARCHAR2_TABLE_100

117: );
118:
119: procedure rosetta_table_copy_in_p26(t out nocopy dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 JTF_NUMBER_TABLE
120: , a1 JTF_NUMBER_TABLE
121: , a2 JTF_VARCHAR2_TABLE_100
122: , a3 JTF_NUMBER_TABLE
123: );
124: procedure rosetta_table_copy_out_p26(t dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
125: , a1 out nocopy JTF_NUMBER_TABLE

Line 126: , a2 out nocopy JTF_VARCHAR2_TABLE_100

122: , a3 JTF_NUMBER_TABLE
123: );
124: procedure rosetta_table_copy_out_p26(t dpp_uiwrapper_pvt.dpp_cust_inv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
125: , a1 out nocopy JTF_NUMBER_TABLE
126: , a2 out nocopy JTF_VARCHAR2_TABLE_100
127: , a3 out nocopy JTF_NUMBER_TABLE
128: );
129:
130: procedure rosetta_table_copy_in_p28(t out nocopy dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 JTF_NUMBER_TABLE

Line 132: , a2 JTF_VARCHAR2_TABLE_100

128: );
129:
130: procedure rosetta_table_copy_in_p28(t out nocopy dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_NUMBER_TABLE
134: , a4 JTF_VARCHAR2_TABLE_100
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_NUMBER_TABLE

Line 134: , a4 JTF_VARCHAR2_TABLE_100

130: procedure rosetta_table_copy_in_p28(t out nocopy dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 JTF_NUMBER_TABLE
131: , a1 JTF_NUMBER_TABLE
132: , a2 JTF_VARCHAR2_TABLE_100
133: , a3 JTF_NUMBER_TABLE
134: , a4 JTF_VARCHAR2_TABLE_100
135: , a5 JTF_NUMBER_TABLE
136: , a6 JTF_NUMBER_TABLE
137: );
138: procedure rosetta_table_copy_out_p28(t dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 140: , a2 out nocopy JTF_VARCHAR2_TABLE_100

136: , a6 JTF_NUMBER_TABLE
137: );
138: procedure rosetta_table_copy_out_p28(t dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
139: , a1 out nocopy JTF_NUMBER_TABLE
140: , a2 out nocopy JTF_VARCHAR2_TABLE_100
141: , a3 out nocopy JTF_NUMBER_TABLE
142: , a4 out nocopy JTF_VARCHAR2_TABLE_100
143: , a5 out nocopy JTF_NUMBER_TABLE
144: , a6 out nocopy JTF_NUMBER_TABLE

Line 142: , a4 out nocopy JTF_VARCHAR2_TABLE_100

138: procedure rosetta_table_copy_out_p28(t dpp_uiwrapper_pvt.dpp_cust_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
139: , a1 out nocopy JTF_NUMBER_TABLE
140: , a2 out nocopy JTF_VARCHAR2_TABLE_100
141: , a3 out nocopy JTF_NUMBER_TABLE
142: , a4 out nocopy JTF_VARCHAR2_TABLE_100
143: , a5 out nocopy JTF_NUMBER_TABLE
144: , a6 out nocopy JTF_NUMBER_TABLE
145: );
146:

Line 158: , a4 JTF_VARCHAR2_TABLE_100

154: procedure rosetta_table_copy_in_p33(t out nocopy dpp_uiwrapper_pvt.approverstable, a0 JTF_NUMBER_TABLE
155: , a1 JTF_NUMBER_TABLE
156: , a2 JTF_VARCHAR2_TABLE_200
157: , a3 JTF_VARCHAR2_TABLE_200
158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_NUMBER_TABLE
162: , a8 JTF_NUMBER_TABLE

Line 159: , a5 JTF_VARCHAR2_TABLE_100

155: , a1 JTF_NUMBER_TABLE
156: , a2 JTF_VARCHAR2_TABLE_200
157: , a3 JTF_VARCHAR2_TABLE_200
158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_NUMBER_TABLE
162: , a8 JTF_NUMBER_TABLE
163: , a9 JTF_NUMBER_TABLE

Line 160: , a6 JTF_VARCHAR2_TABLE_100

156: , a2 JTF_VARCHAR2_TABLE_200
157: , a3 JTF_VARCHAR2_TABLE_200
158: , a4 JTF_VARCHAR2_TABLE_100
159: , a5 JTF_VARCHAR2_TABLE_100
160: , a6 JTF_VARCHAR2_TABLE_100
161: , a7 JTF_NUMBER_TABLE
162: , a8 JTF_NUMBER_TABLE
163: , a9 JTF_NUMBER_TABLE
164: , a10 JTF_VARCHAR2_TABLE_500

Line 167: , a13 JTF_VARCHAR2_TABLE_100

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
171: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 173: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
171: , a2 out nocopy JTF_VARCHAR2_TABLE_200
172: , a3 out nocopy JTF_VARCHAR2_TABLE_200
173: , a4 out nocopy JTF_VARCHAR2_TABLE_100
174: , a5 out nocopy JTF_VARCHAR2_TABLE_100
175: , a6 out nocopy JTF_VARCHAR2_TABLE_100
176: , a7 out nocopy JTF_NUMBER_TABLE
177: , a8 out nocopy JTF_NUMBER_TABLE

Line 174: , a5 out nocopy JTF_VARCHAR2_TABLE_100

170: , a1 out nocopy JTF_NUMBER_TABLE
171: , a2 out nocopy JTF_VARCHAR2_TABLE_200
172: , a3 out nocopy JTF_VARCHAR2_TABLE_200
173: , a4 out nocopy JTF_VARCHAR2_TABLE_100
174: , a5 out nocopy JTF_VARCHAR2_TABLE_100
175: , a6 out nocopy JTF_VARCHAR2_TABLE_100
176: , a7 out nocopy JTF_NUMBER_TABLE
177: , a8 out nocopy JTF_NUMBER_TABLE
178: , a9 out nocopy JTF_NUMBER_TABLE

Line 175: , a6 out nocopy JTF_VARCHAR2_TABLE_100

171: , a2 out nocopy JTF_VARCHAR2_TABLE_200
172: , a3 out nocopy JTF_VARCHAR2_TABLE_200
173: , a4 out nocopy JTF_VARCHAR2_TABLE_100
174: , a5 out nocopy JTF_VARCHAR2_TABLE_100
175: , a6 out nocopy JTF_VARCHAR2_TABLE_100
176: , a7 out nocopy JTF_NUMBER_TABLE
177: , a8 out nocopy JTF_NUMBER_TABLE
178: , a9 out nocopy JTF_NUMBER_TABLE
179: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 182: , a13 out nocopy JTF_VARCHAR2_TABLE_100

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);
186: procedure rosetta_table_copy_out_p35(t dpp_uiwrapper_pvt.dpp_txn_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

Line 188: procedure search_vendors(p0_a0 JTF_VARCHAR2_TABLE_100

184:
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

Line 191: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
194: , x_return_status out nocopy VARCHAR2
195: );

Line 196: procedure search_vendor_sites(p0_a0 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
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

Line 200: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 204: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
208: , x_rec_count out nocopy NUMBER

Line 206: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100

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
208: , x_rec_count out nocopy NUMBER
209: , x_return_status out nocopy VARCHAR2
210: );

Line 207: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 211: procedure search_vendor_contacts(p0_a0 JTF_VARCHAR2_TABLE_100

207: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 215: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
217: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
219: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 216: , p1_a3 out nocopy 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
217: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
219: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_2000
220: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 217: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
217: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
219: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_2000
220: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
221: , x_rec_count out nocopy NUMBER

Line 218: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
217: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
219: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_2000
220: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
221: , x_rec_count out nocopy NUMBER
222: , x_return_status out nocopy VARCHAR2

Line 220: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100

216: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
217: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
219: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_2000
220: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 224: procedure search_items(p0_a0 JTF_VARCHAR2_TABLE_100

220: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 227: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
230: , x_rec_count out nocopy NUMBER
231: , x_return_status out nocopy VARCHAR2

Line 229: , p1_a3 out nocopy 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: );
233: procedure search_customer_items(p0_a0 JTF_VARCHAR2_TABLE_100

Line 233: procedure search_customer_items(p0_a0 JTF_VARCHAR2_TABLE_100

229: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 236: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
239: , x_return_status out nocopy VARCHAR2
240: );

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

Line 244: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
247: , x_return_status out nocopy VARCHAR2
248: );

Line 255: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100

251: , p0_a2 DATE
252: , p0_a3 VARCHAR2
253: , p1_a0 in out nocopy JTF_NUMBER_TABLE
254: , p1_a1 in out nocopy JTF_NUMBER_TABLE
255: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
256: , p1_a3 in out nocopy JTF_NUMBER_TABLE
257: , p1_a4 in out nocopy JTF_NUMBER_TABLE
258: , x_rec_count out nocopy NUMBER
259: , x_return_status out nocopy VARCHAR2

Line 267: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100

263: , p0_a2 DATE
264: , p0_a3 VARCHAR2
265: , p1_a0 in out nocopy JTF_NUMBER_TABLE
266: , p1_a1 in out nocopy JTF_NUMBER_TABLE
267: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
268: , p1_a3 in out nocopy JTF_NUMBER_TABLE
269: , x_rec_count out nocopy NUMBER
270: , x_return_status out nocopy VARCHAR2
271: );

Line 272: procedure search_customers(p0_a0 JTF_VARCHAR2_TABLE_100

268: , p1_a3 in out nocopy JTF_NUMBER_TABLE
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

Line 275: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
278: , x_return_status out nocopy VARCHAR2
279: );

Line 286: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100

282: , p0_a2 DATE
283: , p0_a3 VARCHAR2
284: , p1_a0 in out nocopy JTF_NUMBER_TABLE
285: , p1_a1 in out nocopy JTF_NUMBER_TABLE
286: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
287: , p1_a3 in out nocopy JTF_NUMBER_TABLE
288: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100
289: , p1_a5 in out nocopy JTF_NUMBER_TABLE
290: , p1_a6 in out nocopy JTF_NUMBER_TABLE

Line 288: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100

284: , p1_a0 in out nocopy JTF_NUMBER_TABLE
285: , p1_a1 in out nocopy JTF_NUMBER_TABLE
286: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_100
287: , p1_a3 in out nocopy JTF_NUMBER_TABLE
288: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100
289: , p1_a5 in out nocopy JTF_NUMBER_TABLE
290: , p1_a6 in out nocopy JTF_NUMBER_TABLE
291: , x_rec_count out nocopy NUMBER
292: , x_return_status out nocopy VARCHAR2

Line 334: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100

330: , x_rec_count out nocopy NUMBER
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: );

Line 340: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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
340: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100
341: , p0_a2 in out nocopy JTF_VARCHAR2_TABLE_400
342: , x_rec_count out nocopy NUMBER
343: , x_return_status out nocopy VARCHAR2
344: );

Line 346: , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100

342: , x_rec_count out nocopy NUMBER
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

Line 367: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

363: , p7_a0 out nocopy JTF_NUMBER_TABLE
364: , p7_a1 out nocopy JTF_NUMBER_TABLE
365: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
366: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
367: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
370: , p7_a7 out nocopy JTF_NUMBER_TABLE
371: , p7_a8 out nocopy JTF_NUMBER_TABLE

Line 368: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

364: , p7_a1 out nocopy JTF_NUMBER_TABLE
365: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
366: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
367: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
370: , p7_a7 out nocopy JTF_NUMBER_TABLE
371: , p7_a8 out nocopy JTF_NUMBER_TABLE
372: , p7_a9 out nocopy JTF_NUMBER_TABLE

Line 369: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

365: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
366: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
367: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
368: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
369: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
370: , p7_a7 out nocopy JTF_NUMBER_TABLE
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

Line 376: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100

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
380: , p_commit VARCHAR2