DBA Data[Home] [Help]

APPS.PV_OFFER_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_VARCHAR2_TABLE_100

21:
22: procedure rosetta_table_copy_in_p2(t out nocopy pv_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p2(t out nocopy pv_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE

Line 27: , a5 JTF_VARCHAR2_TABLE_100

23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100

Line 29: , a7 JTF_VARCHAR2_TABLE_100

25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: ) as
33: ddindx binary_integer; indx binary_integer;

Line 31: , a9 JTF_VARCHAR2_TABLE_100

27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
35: if a0 is not null and a0.count > 0 then

Line 62: , a3 out nocopy JTF_VARCHAR2_TABLE_100

58: end rosetta_table_copy_in_p2;
59: procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 63: , a4 out nocopy JTF_VARCHAR2_TABLE_100

59: procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: , a8 out nocopy JTF_NUMBER_TABLE

Line 64: , a5 out nocopy JTF_VARCHAR2_TABLE_100

60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: , a8 out nocopy JTF_NUMBER_TABLE
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 66: , a7 out nocopy JTF_VARCHAR2_TABLE_100

62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: , a8 out nocopy JTF_NUMBER_TABLE
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;

Line 68: , a9 out nocopy JTF_VARCHAR2_TABLE_100

64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: , a8 out nocopy JTF_NUMBER_TABLE
68: , a9 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then

Line 76: a3 := JTF_VARCHAR2_TABLE_100();

72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();

Line 77: a4 := JTF_VARCHAR2_TABLE_100();

73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_NUMBER_TABLE();

Line 78: a5 := JTF_VARCHAR2_TABLE_100();

74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_VARCHAR2_TABLE_100();

Line 80: a7 := JTF_VARCHAR2_TABLE_100();

76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_VARCHAR2_TABLE_100();
83: else
84: a0 := JTF_NUMBER_TABLE();

Line 82: a9 := JTF_VARCHAR2_TABLE_100();

78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_VARCHAR2_TABLE_100();
83: else
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();

Line 87: a3 := JTF_VARCHAR2_TABLE_100();

83: else
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_VARCHAR2_TABLE_100();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_VARCHAR2_TABLE_100();

Line 88: a4 := JTF_VARCHAR2_TABLE_100();

84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_VARCHAR2_TABLE_100();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_VARCHAR2_TABLE_100();
92: a8 := JTF_NUMBER_TABLE();

Line 89: a5 := JTF_VARCHAR2_TABLE_100();

85: a1 := JTF_NUMBER_TABLE();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_VARCHAR2_TABLE_100();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_VARCHAR2_TABLE_100();
92: a8 := JTF_NUMBER_TABLE();
93: a9 := JTF_VARCHAR2_TABLE_100();

Line 91: a7 := JTF_VARCHAR2_TABLE_100();

87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_VARCHAR2_TABLE_100();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_VARCHAR2_TABLE_100();
92: a8 := JTF_NUMBER_TABLE();
93: a9 := JTF_VARCHAR2_TABLE_100();
94: if t.count > 0 then
95: a0.extend(t.count);

Line 93: a9 := JTF_VARCHAR2_TABLE_100();

89: a5 := JTF_VARCHAR2_TABLE_100();
90: a6 := JTF_NUMBER_TABLE();
91: a7 := JTF_VARCHAR2_TABLE_100();
92: a8 := JTF_NUMBER_TABLE();
93: a9 := JTF_VARCHAR2_TABLE_100();
94: if t.count > 0 then
95: a0.extend(t.count);
96: a1.extend(t.count);
97: a2.extend(t.count);

Line 129: , a1 JTF_VARCHAR2_TABLE_100

125: end if;
126: end rosetta_table_copy_out_p2;
127:
128: procedure rosetta_table_copy_in_p4(t out nocopy pv_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_300
132: , a4 JTF_NUMBER_TABLE
133: , a5 JTF_VARCHAR2_TABLE_100

Line 130: , a2 JTF_VARCHAR2_TABLE_100

126: end rosetta_table_copy_out_p2;
127:
128: procedure rosetta_table_copy_in_p4(t out nocopy pv_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_300
132: , a4 JTF_NUMBER_TABLE
133: , a5 JTF_VARCHAR2_TABLE_100
134: ) as

Line 133: , a5 JTF_VARCHAR2_TABLE_100

129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_300
132: , a4 JTF_NUMBER_TABLE
133: , a5 JTF_VARCHAR2_TABLE_100
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if a0 is not null and a0.count > 0 then

Line 158: , a1 out nocopy JTF_VARCHAR2_TABLE_100

154: end if;
155: end if;
156: end rosetta_table_copy_in_p4;
157: procedure rosetta_table_copy_out_p4(t pv_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_VARCHAR2_TABLE_100
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_300
161: , a4 out nocopy JTF_NUMBER_TABLE
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 159: , a2 out nocopy JTF_VARCHAR2_TABLE_100

155: end if;
156: end rosetta_table_copy_in_p4;
157: procedure rosetta_table_copy_out_p4(t pv_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_VARCHAR2_TABLE_100
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_300
161: , a4 out nocopy JTF_NUMBER_TABLE
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: ) as

Line 162: , a5 out nocopy JTF_VARCHAR2_TABLE_100

158: , a1 out nocopy JTF_VARCHAR2_TABLE_100
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_300
161: , a4 out nocopy JTF_NUMBER_TABLE
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: ) as
164: ddindx binary_integer; indx binary_integer;
165: begin
166: if t is null or t.count = 0 then

Line 168: a1 := JTF_VARCHAR2_TABLE_100();

164: ddindx binary_integer; indx binary_integer;
165: begin
166: if t is null or t.count = 0 then
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_VARCHAR2_TABLE_100();
170: a3 := JTF_VARCHAR2_TABLE_300();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_VARCHAR2_TABLE_100();

Line 169: a2 := JTF_VARCHAR2_TABLE_100();

165: begin
166: if t is null or t.count = 0 then
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_VARCHAR2_TABLE_100();
170: a3 := JTF_VARCHAR2_TABLE_300();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_VARCHAR2_TABLE_100();
173: else

Line 172: a5 := JTF_VARCHAR2_TABLE_100();

168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_VARCHAR2_TABLE_100();
170: a3 := JTF_VARCHAR2_TABLE_300();
171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_VARCHAR2_TABLE_100();
173: else
174: a0 := JTF_NUMBER_TABLE();
175: a1 := JTF_VARCHAR2_TABLE_100();
176: a2 := JTF_VARCHAR2_TABLE_100();

Line 175: a1 := JTF_VARCHAR2_TABLE_100();

171: a4 := JTF_NUMBER_TABLE();
172: a5 := JTF_VARCHAR2_TABLE_100();
173: else
174: a0 := JTF_NUMBER_TABLE();
175: a1 := JTF_VARCHAR2_TABLE_100();
176: a2 := JTF_VARCHAR2_TABLE_100();
177: a3 := JTF_VARCHAR2_TABLE_300();
178: a4 := JTF_NUMBER_TABLE();
179: a5 := JTF_VARCHAR2_TABLE_100();

Line 176: a2 := JTF_VARCHAR2_TABLE_100();

172: a5 := JTF_VARCHAR2_TABLE_100();
173: else
174: a0 := JTF_NUMBER_TABLE();
175: a1 := JTF_VARCHAR2_TABLE_100();
176: a2 := JTF_VARCHAR2_TABLE_100();
177: a3 := JTF_VARCHAR2_TABLE_300();
178: a4 := JTF_NUMBER_TABLE();
179: a5 := JTF_VARCHAR2_TABLE_100();
180: if t.count > 0 then

Line 179: a5 := JTF_VARCHAR2_TABLE_100();

175: a1 := JTF_VARCHAR2_TABLE_100();
176: a2 := JTF_VARCHAR2_TABLE_100();
177: a3 := JTF_VARCHAR2_TABLE_300();
178: a4 := JTF_NUMBER_TABLE();
179: a5 := JTF_VARCHAR2_TABLE_100();
180: if t.count > 0 then
181: a0.extend(t.count);
182: a1.extend(t.count);
183: a2.extend(t.count);

Line 209: , a3 JTF_VARCHAR2_TABLE_100

205:
206: procedure rosetta_table_copy_in_p6(t out nocopy pv_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
207: , a1 JTF_NUMBER_TABLE
208: , a2 JTF_NUMBER_TABLE
209: , a3 JTF_VARCHAR2_TABLE_100
210: ) as
211: ddindx binary_integer; indx binary_integer;
212: begin
213: if a0 is not null and a0.count > 0 then

Line 234: , a3 out nocopy JTF_VARCHAR2_TABLE_100

230: end rosetta_table_copy_in_p6;
231: procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
232: , a1 out nocopy JTF_NUMBER_TABLE
233: , a2 out nocopy JTF_NUMBER_TABLE
234: , a3 out nocopy JTF_VARCHAR2_TABLE_100
235: ) as
236: ddindx binary_integer; indx binary_integer;
237: begin
238: if t is null or t.count = 0 then

Line 242: a3 := JTF_VARCHAR2_TABLE_100();

238: if t is null or t.count = 0 then
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_NUMBER_TABLE();
241: a2 := JTF_NUMBER_TABLE();
242: a3 := JTF_VARCHAR2_TABLE_100();
243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_NUMBER_TABLE();

Line 247: a3 := JTF_VARCHAR2_TABLE_100();

243: else
244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_NUMBER_TABLE();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: if t.count > 0 then
249: a0.extend(t.count);
250: a1.extend(t.count);
251: a2.extend(t.count);

Line 279: , p7_a3 JTF_VARCHAR2_TABLE_100

275: , p_offer_id NUMBER
276: , p7_a0 JTF_NUMBER_TABLE
277: , p7_a1 JTF_NUMBER_TABLE
278: , p7_a2 JTF_NUMBER_TABLE
279: , p7_a3 JTF_VARCHAR2_TABLE_100
280: , p8_a0 JTF_NUMBER_TABLE
281: , p8_a1 JTF_NUMBER_TABLE
282: , p8_a2 JTF_NUMBER_TABLE
283: , p8_a3 JTF_VARCHAR2_TABLE_100

Line 283: , p8_a3 JTF_VARCHAR2_TABLE_100

279: , p7_a3 JTF_VARCHAR2_TABLE_100
280: , p8_a0 JTF_NUMBER_TABLE
281: , p8_a1 JTF_NUMBER_TABLE
282: , p8_a2 JTF_NUMBER_TABLE
283: , p8_a3 JTF_VARCHAR2_TABLE_100
284: , p8_a4 JTF_VARCHAR2_TABLE_100
285: , p8_a5 JTF_VARCHAR2_TABLE_100
286: , p8_a6 JTF_NUMBER_TABLE
287: , p8_a7 JTF_VARCHAR2_TABLE_100

Line 284: , p8_a4 JTF_VARCHAR2_TABLE_100

280: , p8_a0 JTF_NUMBER_TABLE
281: , p8_a1 JTF_NUMBER_TABLE
282: , p8_a2 JTF_NUMBER_TABLE
283: , p8_a3 JTF_VARCHAR2_TABLE_100
284: , p8_a4 JTF_VARCHAR2_TABLE_100
285: , p8_a5 JTF_VARCHAR2_TABLE_100
286: , p8_a6 JTF_NUMBER_TABLE
287: , p8_a7 JTF_VARCHAR2_TABLE_100
288: , p8_a8 JTF_NUMBER_TABLE

Line 285: , p8_a5 JTF_VARCHAR2_TABLE_100

281: , p8_a1 JTF_NUMBER_TABLE
282: , p8_a2 JTF_NUMBER_TABLE
283: , p8_a3 JTF_VARCHAR2_TABLE_100
284: , p8_a4 JTF_VARCHAR2_TABLE_100
285: , p8_a5 JTF_VARCHAR2_TABLE_100
286: , p8_a6 JTF_NUMBER_TABLE
287: , p8_a7 JTF_VARCHAR2_TABLE_100
288: , p8_a8 JTF_NUMBER_TABLE
289: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 287: , p8_a7 JTF_VARCHAR2_TABLE_100

283: , p8_a3 JTF_VARCHAR2_TABLE_100
284: , p8_a4 JTF_VARCHAR2_TABLE_100
285: , p8_a5 JTF_VARCHAR2_TABLE_100
286: , p8_a6 JTF_NUMBER_TABLE
287: , p8_a7 JTF_VARCHAR2_TABLE_100
288: , p8_a8 JTF_NUMBER_TABLE
289: , p8_a9 JTF_VARCHAR2_TABLE_100
290: , p9_a0 JTF_NUMBER_TABLE
291: , p9_a1 JTF_VARCHAR2_TABLE_100

Line 289: , p8_a9 JTF_VARCHAR2_TABLE_100

285: , p8_a5 JTF_VARCHAR2_TABLE_100
286: , p8_a6 JTF_NUMBER_TABLE
287: , p8_a7 JTF_VARCHAR2_TABLE_100
288: , p8_a8 JTF_NUMBER_TABLE
289: , p8_a9 JTF_VARCHAR2_TABLE_100
290: , p9_a0 JTF_NUMBER_TABLE
291: , p9_a1 JTF_VARCHAR2_TABLE_100
292: , p9_a2 JTF_VARCHAR2_TABLE_100
293: , p9_a3 JTF_VARCHAR2_TABLE_300

Line 291: , p9_a1 JTF_VARCHAR2_TABLE_100

287: , p8_a7 JTF_VARCHAR2_TABLE_100
288: , p8_a8 JTF_NUMBER_TABLE
289: , p8_a9 JTF_VARCHAR2_TABLE_100
290: , p9_a0 JTF_NUMBER_TABLE
291: , p9_a1 JTF_VARCHAR2_TABLE_100
292: , p9_a2 JTF_VARCHAR2_TABLE_100
293: , p9_a3 JTF_VARCHAR2_TABLE_300
294: , p9_a4 JTF_NUMBER_TABLE
295: , p9_a5 JTF_VARCHAR2_TABLE_100

Line 292: , p9_a2 JTF_VARCHAR2_TABLE_100

288: , p8_a8 JTF_NUMBER_TABLE
289: , p8_a9 JTF_VARCHAR2_TABLE_100
290: , p9_a0 JTF_NUMBER_TABLE
291: , p9_a1 JTF_VARCHAR2_TABLE_100
292: , p9_a2 JTF_VARCHAR2_TABLE_100
293: , p9_a3 JTF_VARCHAR2_TABLE_300
294: , p9_a4 JTF_NUMBER_TABLE
295: , p9_a5 JTF_VARCHAR2_TABLE_100
296: , x_offer_id out nocopy NUMBER

Line 295: , p9_a5 JTF_VARCHAR2_TABLE_100

291: , p9_a1 JTF_VARCHAR2_TABLE_100
292: , p9_a2 JTF_VARCHAR2_TABLE_100
293: , p9_a3 JTF_VARCHAR2_TABLE_300
294: , p9_a4 JTF_NUMBER_TABLE
295: , p9_a5 JTF_VARCHAR2_TABLE_100
296: , x_offer_id out nocopy NUMBER
297: , x_qp_list_header_id out nocopy NUMBER
298: , x_error_location out nocopy NUMBER
299: , x_return_status out nocopy VARCHAR2