APPS.OZF_PRICELIST_PVT_W dependencies on JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package ozf_pricelist_pvt_w as
2: /* $Header: ozfwplts.pls 120.1 2005/08/17 17:56 appldev ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ozf_pricelist_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p3(t out nocopy ozf_pricelist_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_300

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_100

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_300

Line 37: , a1 out nocopy JTF_NUMBER_TABLE

33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_VARCHAR2_TABLE_300
35: );
36: procedure rosetta_table_copy_out_p3(t ozf_pricelist_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_DATE_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE

Line 40: , a4 out nocopy JTF_NUMBER_TABLE

36: procedure rosetta_table_copy_out_p3(t ozf_pricelist_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_DATE_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_VARCHAR2_TABLE_300
44: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 41: , a5 out nocopy JTF_NUMBER_TABLE

37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_DATE_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_VARCHAR2_TABLE_300
44: , a8 out nocopy JTF_VARCHAR2_TABLE_300
45: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a11 out nocopy JTF_NUMBER_TABLE

43: , a7 out nocopy JTF_VARCHAR2_TABLE_300
44: , a8 out nocopy JTF_VARCHAR2_TABLE_300
45: , a9 out nocopy JTF_VARCHAR2_TABLE_100
46: , a10 out nocopy JTF_VARCHAR2_TABLE_100
47: , a11 out nocopy JTF_NUMBER_TABLE
48: , a12 out nocopy JTF_NUMBER_TABLE
49: , a13 out nocopy JTF_NUMBER_TABLE
50: , a14 out nocopy JTF_DATE_TABLE
51: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 48: , a12 out nocopy JTF_NUMBER_TABLE

44: , a8 out nocopy JTF_VARCHAR2_TABLE_300
45: , a9 out nocopy JTF_VARCHAR2_TABLE_100
46: , a10 out nocopy JTF_VARCHAR2_TABLE_100
47: , a11 out nocopy JTF_NUMBER_TABLE
48: , a12 out nocopy JTF_NUMBER_TABLE
49: , a13 out nocopy JTF_NUMBER_TABLE
50: , a14 out nocopy JTF_DATE_TABLE
51: , a15 out nocopy JTF_VARCHAR2_TABLE_100
52: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , a13 out nocopy JTF_NUMBER_TABLE

45: , a9 out nocopy JTF_VARCHAR2_TABLE_100
46: , a10 out nocopy JTF_VARCHAR2_TABLE_100
47: , a11 out nocopy JTF_NUMBER_TABLE
48: , a12 out nocopy JTF_NUMBER_TABLE
49: , a13 out nocopy JTF_NUMBER_TABLE
50: , a14 out nocopy JTF_DATE_TABLE
51: , a15 out nocopy JTF_VARCHAR2_TABLE_100
52: , a16 out nocopy JTF_VARCHAR2_TABLE_100
53: , a17 out nocopy JTF_VARCHAR2_TABLE_300

Line 72: , a2 JTF_NUMBER_TABLE

68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy ozf_pricelist_pvt.price_list_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
71: , a1 JTF_DATE_TABLE
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_DATE_TABLE

Line 73: , a3 JTF_NUMBER_TABLE

69:
70: procedure rosetta_table_copy_in_p5(t out nocopy ozf_pricelist_pvt.price_list_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
71: , a1 JTF_DATE_TABLE
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_DATE_TABLE
77: , a7 JTF_VARCHAR2_TABLE_100

Line 74: , a4 JTF_NUMBER_TABLE

70: procedure rosetta_table_copy_in_p5(t out nocopy ozf_pricelist_pvt.price_list_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
71: , a1 JTF_DATE_TABLE
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_DATE_TABLE
77: , a7 JTF_VARCHAR2_TABLE_100
78: , a8 JTF_VARCHAR2_TABLE_100

Line 75: , a5 JTF_NUMBER_TABLE

71: , a1 JTF_DATE_TABLE
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_NUMBER_TABLE
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_DATE_TABLE
77: , a7 JTF_VARCHAR2_TABLE_100
78: , a8 JTF_VARCHAR2_TABLE_100
79: , a9 JTF_NUMBER_TABLE

Line 79: , a9 JTF_NUMBER_TABLE

75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_DATE_TABLE
77: , a7 JTF_VARCHAR2_TABLE_100
78: , a8 JTF_VARCHAR2_TABLE_100
79: , a9 JTF_NUMBER_TABLE
80: , a10 JTF_NUMBER_TABLE
81: , a11 JTF_NUMBER_TABLE
82: , a12 JTF_NUMBER_TABLE
83: , a13 JTF_VARCHAR2_TABLE_2000

Line 80: , a10 JTF_NUMBER_TABLE

76: , a6 JTF_DATE_TABLE
77: , a7 JTF_VARCHAR2_TABLE_100
78: , a8 JTF_VARCHAR2_TABLE_100
79: , a9 JTF_NUMBER_TABLE
80: , a10 JTF_NUMBER_TABLE
81: , a11 JTF_NUMBER_TABLE
82: , a12 JTF_NUMBER_TABLE
83: , a13 JTF_VARCHAR2_TABLE_2000
84: , a14 JTF_NUMBER_TABLE

Line 81: , a11 JTF_NUMBER_TABLE

77: , a7 JTF_VARCHAR2_TABLE_100
78: , a8 JTF_VARCHAR2_TABLE_100
79: , a9 JTF_NUMBER_TABLE
80: , a10 JTF_NUMBER_TABLE
81: , a11 JTF_NUMBER_TABLE
82: , a12 JTF_NUMBER_TABLE
83: , a13 JTF_VARCHAR2_TABLE_2000
84: , a14 JTF_NUMBER_TABLE
85: , a15 JTF_VARCHAR2_TABLE_100

Line 82: , a12 JTF_NUMBER_TABLE

78: , a8 JTF_VARCHAR2_TABLE_100
79: , a9 JTF_NUMBER_TABLE
80: , a10 JTF_NUMBER_TABLE
81: , a11 JTF_NUMBER_TABLE
82: , a12 JTF_NUMBER_TABLE
83: , a13 JTF_VARCHAR2_TABLE_2000
84: , a14 JTF_NUMBER_TABLE
85: , a15 JTF_VARCHAR2_TABLE_100
86: , a16 JTF_VARCHAR2_TABLE_300

Line 84: , a14 JTF_NUMBER_TABLE

80: , a10 JTF_NUMBER_TABLE
81: , a11 JTF_NUMBER_TABLE
82: , a12 JTF_NUMBER_TABLE
83: , a13 JTF_VARCHAR2_TABLE_2000
84: , a14 JTF_NUMBER_TABLE
85: , a15 JTF_VARCHAR2_TABLE_100
86: , a16 JTF_VARCHAR2_TABLE_300
87: , a17 JTF_VARCHAR2_TABLE_300
88: , a18 JTF_VARCHAR2_TABLE_300

Line 104: , a2 out nocopy JTF_NUMBER_TABLE

100: , a30 JTF_VARCHAR2_TABLE_300
101: );
102: procedure rosetta_table_copy_out_p5(t ozf_pricelist_pvt.price_list_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
103: , a1 out nocopy JTF_DATE_TABLE
104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_NUMBER_TABLE
107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_DATE_TABLE

Line 105: , a3 out nocopy JTF_NUMBER_TABLE

101: );
102: procedure rosetta_table_copy_out_p5(t ozf_pricelist_pvt.price_list_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
103: , a1 out nocopy JTF_DATE_TABLE
104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_NUMBER_TABLE
107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_DATE_TABLE
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 106: , a4 out nocopy JTF_NUMBER_TABLE

102: procedure rosetta_table_copy_out_p5(t ozf_pricelist_pvt.price_list_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
103: , a1 out nocopy JTF_DATE_TABLE
104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_NUMBER_TABLE
107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_DATE_TABLE
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 107: , a5 out nocopy JTF_NUMBER_TABLE

103: , a1 out nocopy JTF_DATE_TABLE
104: , a2 out nocopy JTF_NUMBER_TABLE
105: , a3 out nocopy JTF_NUMBER_TABLE
106: , a4 out nocopy JTF_NUMBER_TABLE
107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_DATE_TABLE
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_NUMBER_TABLE

Line 111: , a9 out nocopy JTF_NUMBER_TABLE

107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_DATE_TABLE
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_NUMBER_TABLE
113: , a11 out nocopy JTF_NUMBER_TABLE
114: , a12 out nocopy JTF_NUMBER_TABLE
115: , a13 out nocopy JTF_VARCHAR2_TABLE_2000

Line 112: , a10 out nocopy JTF_NUMBER_TABLE

108: , a6 out nocopy JTF_DATE_TABLE
109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_NUMBER_TABLE
113: , a11 out nocopy JTF_NUMBER_TABLE
114: , a12 out nocopy JTF_NUMBER_TABLE
115: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
116: , a14 out nocopy JTF_NUMBER_TABLE

Line 113: , a11 out nocopy JTF_NUMBER_TABLE

109: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_NUMBER_TABLE
113: , a11 out nocopy JTF_NUMBER_TABLE
114: , a12 out nocopy JTF_NUMBER_TABLE
115: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
116: , a14 out nocopy JTF_NUMBER_TABLE
117: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 114: , a12 out nocopy JTF_NUMBER_TABLE

110: , a8 out nocopy JTF_VARCHAR2_TABLE_100
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_NUMBER_TABLE
113: , a11 out nocopy JTF_NUMBER_TABLE
114: , a12 out nocopy JTF_NUMBER_TABLE
115: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
116: , a14 out nocopy JTF_NUMBER_TABLE
117: , a15 out nocopy JTF_VARCHAR2_TABLE_100
118: , a16 out nocopy JTF_VARCHAR2_TABLE_300

Line 116: , a14 out nocopy JTF_NUMBER_TABLE

112: , a10 out nocopy JTF_NUMBER_TABLE
113: , a11 out nocopy JTF_NUMBER_TABLE
114: , a12 out nocopy JTF_NUMBER_TABLE
115: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
116: , a14 out nocopy JTF_NUMBER_TABLE
117: , a15 out nocopy JTF_VARCHAR2_TABLE_100
118: , a16 out nocopy JTF_VARCHAR2_TABLE_300
119: , a17 out nocopy JTF_VARCHAR2_TABLE_300
120: , a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 135: procedure rosetta_table_copy_in_p7(t out nocopy ozf_pricelist_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE

131: , a29 out nocopy JTF_VARCHAR2_TABLE_300
132: , a30 out nocopy JTF_VARCHAR2_TABLE_300
133: );
134:
135: procedure rosetta_table_copy_in_p7(t out nocopy ozf_pricelist_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_VARCHAR2_TABLE_300

Line 138: , a3 JTF_NUMBER_TABLE

134:
135: procedure rosetta_table_copy_in_p7(t out nocopy ozf_pricelist_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_VARCHAR2_TABLE_100
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_VARCHAR2_TABLE_300
140: , a5 JTF_VARCHAR2_TABLE_300
141: , a6 JTF_VARCHAR2_TABLE_100
142: , a7 JTF_VARCHAR2_TABLE_100

Line 146: , a11 JTF_NUMBER_TABLE

142: , a7 JTF_VARCHAR2_TABLE_100
143: , a8 JTF_VARCHAR2_TABLE_300
144: , a9 JTF_VARCHAR2_TABLE_100
145: , a10 JTF_VARCHAR2_TABLE_100
146: , a11 JTF_NUMBER_TABLE
147: , a12 JTF_VARCHAR2_TABLE_100
148: , a13 JTF_NUMBER_TABLE
149: );
150: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 148: , a13 JTF_NUMBER_TABLE

144: , a9 JTF_VARCHAR2_TABLE_100
145: , a10 JTF_VARCHAR2_TABLE_100
146: , a11 JTF_NUMBER_TABLE
147: , a12 JTF_VARCHAR2_TABLE_100
148: , a13 JTF_NUMBER_TABLE
149: );
150: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
151: , a1 out nocopy JTF_VARCHAR2_TABLE_100
152: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 150: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

146: , a11 JTF_NUMBER_TABLE
147: , a12 JTF_VARCHAR2_TABLE_100
148: , a13 JTF_NUMBER_TABLE
149: );
150: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
151: , a1 out nocopy JTF_VARCHAR2_TABLE_100
152: , a2 out nocopy JTF_VARCHAR2_TABLE_100
153: , a3 out nocopy JTF_NUMBER_TABLE
154: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 153: , a3 out nocopy JTF_NUMBER_TABLE

149: );
150: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
151: , a1 out nocopy JTF_VARCHAR2_TABLE_100
152: , a2 out nocopy JTF_VARCHAR2_TABLE_100
153: , a3 out nocopy JTF_NUMBER_TABLE
154: , a4 out nocopy JTF_VARCHAR2_TABLE_300
155: , a5 out nocopy JTF_VARCHAR2_TABLE_300
156: , a6 out nocopy JTF_VARCHAR2_TABLE_100
157: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 161: , a11 out nocopy JTF_NUMBER_TABLE

157: , a7 out nocopy JTF_VARCHAR2_TABLE_100
158: , a8 out nocopy JTF_VARCHAR2_TABLE_300
159: , a9 out nocopy JTF_VARCHAR2_TABLE_100
160: , a10 out nocopy JTF_VARCHAR2_TABLE_100
161: , a11 out nocopy JTF_NUMBER_TABLE
162: , a12 out nocopy JTF_VARCHAR2_TABLE_100
163: , a13 out nocopy JTF_NUMBER_TABLE
164: );
165:

Line 163: , a13 out nocopy JTF_NUMBER_TABLE

159: , a9 out nocopy JTF_VARCHAR2_TABLE_100
160: , a10 out nocopy JTF_VARCHAR2_TABLE_100
161: , a11 out nocopy JTF_NUMBER_TABLE
162: , a12 out nocopy JTF_VARCHAR2_TABLE_100
163: , a13 out nocopy JTF_NUMBER_TABLE
164: );
165:
166: procedure rosetta_table_copy_in_p12(t out nocopy ozf_pricelist_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE);
167: procedure rosetta_table_copy_out_p12(t ozf_pricelist_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

Line 166: procedure rosetta_table_copy_in_p12(t out nocopy ozf_pricelist_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE);

162: , a12 out nocopy JTF_VARCHAR2_TABLE_100
163: , a13 out nocopy JTF_NUMBER_TABLE
164: );
165:
166: procedure rosetta_table_copy_in_p12(t out nocopy ozf_pricelist_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE);
167: procedure rosetta_table_copy_out_p12(t ozf_pricelist_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
168:
169: procedure process_price_list(p_api_version NUMBER
170: , p_init_msg_list VARCHAR2

Line 167: procedure rosetta_table_copy_out_p12(t ozf_pricelist_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

163: , a13 out nocopy JTF_NUMBER_TABLE
164: );
165:
166: procedure rosetta_table_copy_in_p12(t out nocopy ozf_pricelist_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE);
167: procedure rosetta_table_copy_out_p12(t ozf_pricelist_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
168:
169: procedure process_price_list(p_api_version NUMBER
170: , p_init_msg_list VARCHAR2
171: , p_commit VARCHAR2

Line 178: , p8_a2 JTF_NUMBER_TABLE

174: , x_msg_count out nocopy NUMBER
175: , x_msg_data out nocopy VARCHAR2
176: , p8_a0 JTF_VARCHAR2_TABLE_100
177: , p8_a1 JTF_DATE_TABLE
178: , p8_a2 JTF_NUMBER_TABLE
179: , p8_a3 JTF_NUMBER_TABLE
180: , p8_a4 JTF_NUMBER_TABLE
181: , p8_a5 JTF_NUMBER_TABLE
182: , p8_a6 JTF_DATE_TABLE

Line 179: , p8_a3 JTF_NUMBER_TABLE

175: , x_msg_data out nocopy VARCHAR2
176: , p8_a0 JTF_VARCHAR2_TABLE_100
177: , p8_a1 JTF_DATE_TABLE
178: , p8_a2 JTF_NUMBER_TABLE
179: , p8_a3 JTF_NUMBER_TABLE
180: , p8_a4 JTF_NUMBER_TABLE
181: , p8_a5 JTF_NUMBER_TABLE
182: , p8_a6 JTF_DATE_TABLE
183: , p8_a7 JTF_VARCHAR2_TABLE_100

Line 180: , p8_a4 JTF_NUMBER_TABLE

176: , p8_a0 JTF_VARCHAR2_TABLE_100
177: , p8_a1 JTF_DATE_TABLE
178: , p8_a2 JTF_NUMBER_TABLE
179: , p8_a3 JTF_NUMBER_TABLE
180: , p8_a4 JTF_NUMBER_TABLE
181: , p8_a5 JTF_NUMBER_TABLE
182: , p8_a6 JTF_DATE_TABLE
183: , p8_a7 JTF_VARCHAR2_TABLE_100
184: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 181: , p8_a5 JTF_NUMBER_TABLE

177: , p8_a1 JTF_DATE_TABLE
178: , p8_a2 JTF_NUMBER_TABLE
179: , p8_a3 JTF_NUMBER_TABLE
180: , p8_a4 JTF_NUMBER_TABLE
181: , p8_a5 JTF_NUMBER_TABLE
182: , p8_a6 JTF_DATE_TABLE
183: , p8_a7 JTF_VARCHAR2_TABLE_100
184: , p8_a8 JTF_VARCHAR2_TABLE_100
185: , p8_a9 JTF_NUMBER_TABLE

Line 185: , p8_a9 JTF_NUMBER_TABLE

181: , p8_a5 JTF_NUMBER_TABLE
182: , p8_a6 JTF_DATE_TABLE
183: , p8_a7 JTF_VARCHAR2_TABLE_100
184: , p8_a8 JTF_VARCHAR2_TABLE_100
185: , p8_a9 JTF_NUMBER_TABLE
186: , p8_a10 JTF_NUMBER_TABLE
187: , p8_a11 JTF_NUMBER_TABLE
188: , p8_a12 JTF_NUMBER_TABLE
189: , p8_a13 JTF_VARCHAR2_TABLE_2000

Line 186: , p8_a10 JTF_NUMBER_TABLE

182: , p8_a6 JTF_DATE_TABLE
183: , p8_a7 JTF_VARCHAR2_TABLE_100
184: , p8_a8 JTF_VARCHAR2_TABLE_100
185: , p8_a9 JTF_NUMBER_TABLE
186: , p8_a10 JTF_NUMBER_TABLE
187: , p8_a11 JTF_NUMBER_TABLE
188: , p8_a12 JTF_NUMBER_TABLE
189: , p8_a13 JTF_VARCHAR2_TABLE_2000
190: , p8_a14 JTF_NUMBER_TABLE

Line 187: , p8_a11 JTF_NUMBER_TABLE

183: , p8_a7 JTF_VARCHAR2_TABLE_100
184: , p8_a8 JTF_VARCHAR2_TABLE_100
185: , p8_a9 JTF_NUMBER_TABLE
186: , p8_a10 JTF_NUMBER_TABLE
187: , p8_a11 JTF_NUMBER_TABLE
188: , p8_a12 JTF_NUMBER_TABLE
189: , p8_a13 JTF_VARCHAR2_TABLE_2000
190: , p8_a14 JTF_NUMBER_TABLE
191: , p8_a15 JTF_VARCHAR2_TABLE_100

Line 188: , p8_a12 JTF_NUMBER_TABLE

184: , p8_a8 JTF_VARCHAR2_TABLE_100
185: , p8_a9 JTF_NUMBER_TABLE
186: , p8_a10 JTF_NUMBER_TABLE
187: , p8_a11 JTF_NUMBER_TABLE
188: , p8_a12 JTF_NUMBER_TABLE
189: , p8_a13 JTF_VARCHAR2_TABLE_2000
190: , p8_a14 JTF_NUMBER_TABLE
191: , p8_a15 JTF_VARCHAR2_TABLE_100
192: , p8_a16 JTF_VARCHAR2_TABLE_300

Line 190: , p8_a14 JTF_NUMBER_TABLE

186: , p8_a10 JTF_NUMBER_TABLE
187: , p8_a11 JTF_NUMBER_TABLE
188: , p8_a12 JTF_NUMBER_TABLE
189: , p8_a13 JTF_VARCHAR2_TABLE_2000
190: , p8_a14 JTF_NUMBER_TABLE
191: , p8_a15 JTF_VARCHAR2_TABLE_100
192: , p8_a16 JTF_VARCHAR2_TABLE_300
193: , p8_a17 JTF_VARCHAR2_TABLE_300
194: , p8_a18 JTF_VARCHAR2_TABLE_300

Line 207: , p9_a0 JTF_NUMBER_TABLE

203: , p8_a27 JTF_VARCHAR2_TABLE_300
204: , p8_a28 JTF_VARCHAR2_TABLE_300
205: , p8_a29 JTF_VARCHAR2_TABLE_300
206: , p8_a30 JTF_VARCHAR2_TABLE_300
207: , p9_a0 JTF_NUMBER_TABLE
208: , p9_a1 JTF_VARCHAR2_TABLE_100
209: , p9_a2 JTF_VARCHAR2_TABLE_100
210: , p9_a3 JTF_NUMBER_TABLE
211: , p9_a4 JTF_VARCHAR2_TABLE_300

Line 210: , p9_a3 JTF_NUMBER_TABLE

206: , p8_a30 JTF_VARCHAR2_TABLE_300
207: , p9_a0 JTF_NUMBER_TABLE
208: , p9_a1 JTF_VARCHAR2_TABLE_100
209: , p9_a2 JTF_VARCHAR2_TABLE_100
210: , p9_a3 JTF_NUMBER_TABLE
211: , p9_a4 JTF_VARCHAR2_TABLE_300
212: , p9_a5 JTF_VARCHAR2_TABLE_300
213: , p9_a6 JTF_VARCHAR2_TABLE_100
214: , p9_a7 JTF_VARCHAR2_TABLE_100

Line 218: , p9_a11 JTF_NUMBER_TABLE

214: , p9_a7 JTF_VARCHAR2_TABLE_100
215: , p9_a8 JTF_VARCHAR2_TABLE_300
216: , p9_a9 JTF_VARCHAR2_TABLE_100
217: , p9_a10 JTF_VARCHAR2_TABLE_100
218: , p9_a11 JTF_NUMBER_TABLE
219: , p9_a12 JTF_VARCHAR2_TABLE_100
220: , p9_a13 JTF_NUMBER_TABLE
221: , p10_a0 JTF_VARCHAR2_TABLE_100
222: , p10_a1 JTF_NUMBER_TABLE

Line 220: , p9_a13 JTF_NUMBER_TABLE

216: , p9_a9 JTF_VARCHAR2_TABLE_100
217: , p9_a10 JTF_VARCHAR2_TABLE_100
218: , p9_a11 JTF_NUMBER_TABLE
219: , p9_a12 JTF_VARCHAR2_TABLE_100
220: , p9_a13 JTF_NUMBER_TABLE
221: , p10_a0 JTF_VARCHAR2_TABLE_100
222: , p10_a1 JTF_NUMBER_TABLE
223: , p10_a2 JTF_DATE_TABLE
224: , p10_a3 JTF_VARCHAR2_TABLE_100

Line 222: , p10_a1 JTF_NUMBER_TABLE

218: , p9_a11 JTF_NUMBER_TABLE
219: , p9_a12 JTF_VARCHAR2_TABLE_100
220: , p9_a13 JTF_NUMBER_TABLE
221: , p10_a0 JTF_VARCHAR2_TABLE_100
222: , p10_a1 JTF_NUMBER_TABLE
223: , p10_a2 JTF_DATE_TABLE
224: , p10_a3 JTF_VARCHAR2_TABLE_100
225: , p10_a4 JTF_NUMBER_TABLE
226: , p10_a5 JTF_NUMBER_TABLE

Line 225: , p10_a4 JTF_NUMBER_TABLE

221: , p10_a0 JTF_VARCHAR2_TABLE_100
222: , p10_a1 JTF_NUMBER_TABLE
223: , p10_a2 JTF_DATE_TABLE
224: , p10_a3 JTF_VARCHAR2_TABLE_100
225: , p10_a4 JTF_NUMBER_TABLE
226: , p10_a5 JTF_NUMBER_TABLE
227: , p10_a6 JTF_VARCHAR2_TABLE_100
228: , p10_a7 JTF_VARCHAR2_TABLE_300
229: , p10_a8 JTF_VARCHAR2_TABLE_300

Line 226: , p10_a5 JTF_NUMBER_TABLE

222: , p10_a1 JTF_NUMBER_TABLE
223: , p10_a2 JTF_DATE_TABLE
224: , p10_a3 JTF_VARCHAR2_TABLE_100
225: , p10_a4 JTF_NUMBER_TABLE
226: , p10_a5 JTF_NUMBER_TABLE
227: , p10_a6 JTF_VARCHAR2_TABLE_100
228: , p10_a7 JTF_VARCHAR2_TABLE_300
229: , p10_a8 JTF_VARCHAR2_TABLE_300
230: , p10_a9 JTF_VARCHAR2_TABLE_100

Line 232: , p10_a11 JTF_NUMBER_TABLE

228: , p10_a7 JTF_VARCHAR2_TABLE_300
229: , p10_a8 JTF_VARCHAR2_TABLE_300
230: , p10_a9 JTF_VARCHAR2_TABLE_100
231: , p10_a10 JTF_VARCHAR2_TABLE_100
232: , p10_a11 JTF_NUMBER_TABLE
233: , p10_a12 JTF_NUMBER_TABLE
234: , p10_a13 JTF_NUMBER_TABLE
235: , p10_a14 JTF_DATE_TABLE
236: , p10_a15 JTF_VARCHAR2_TABLE_100

Line 233: , p10_a12 JTF_NUMBER_TABLE

229: , p10_a8 JTF_VARCHAR2_TABLE_300
230: , p10_a9 JTF_VARCHAR2_TABLE_100
231: , p10_a10 JTF_VARCHAR2_TABLE_100
232: , p10_a11 JTF_NUMBER_TABLE
233: , p10_a12 JTF_NUMBER_TABLE
234: , p10_a13 JTF_NUMBER_TABLE
235: , p10_a14 JTF_DATE_TABLE
236: , p10_a15 JTF_VARCHAR2_TABLE_100
237: , p10_a16 JTF_VARCHAR2_TABLE_100

Line 234: , p10_a13 JTF_NUMBER_TABLE

230: , p10_a9 JTF_VARCHAR2_TABLE_100
231: , p10_a10 JTF_VARCHAR2_TABLE_100
232: , p10_a11 JTF_NUMBER_TABLE
233: , p10_a12 JTF_NUMBER_TABLE
234: , p10_a13 JTF_NUMBER_TABLE
235: , p10_a14 JTF_DATE_TABLE
236: , p10_a15 JTF_VARCHAR2_TABLE_100
237: , p10_a16 JTF_VARCHAR2_TABLE_100
238: , p10_a17 JTF_VARCHAR2_TABLE_300

Line 300: , p_new_inv_item_id JTF_NUMBER_TABLE

296: , x_return_status out nocopy VARCHAR2
297: , x_msg_count out nocopy NUMBER
298: , x_msg_data out nocopy VARCHAR2
299: , p_org_inv_item_id NUMBER
300: , p_new_inv_item_id JTF_NUMBER_TABLE
301: );
302: end ozf_pricelist_pvt_w;