DBA Data[Home] [Help]

APPS.PV_OFFER_PUB_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy pv_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
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

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
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

Line 24: , a2 JTF_NUMBER_TABLE

20: end;
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

Line 28: , a6 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
32: ) as

Line 30: , a8 JTF_NUMBER_TABLE

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;
34: begin

Line 59: procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

55: end loop;
56: end if;
57: end if;
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

Line 60: , a1 out nocopy JTF_NUMBER_TABLE

56: end if;
57: end if;
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

Line 61: , a2 out nocopy JTF_NUMBER_TABLE

57: end if;
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

Line 65: , a6 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
69: ) as

Line 67: , a8 out nocopy JTF_NUMBER_TABLE

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;
71: begin

Line 73: a0 := JTF_NUMBER_TABLE();

69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
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();

Line 74: a1 := JTF_NUMBER_TABLE();

70: ddindx binary_integer; indx binary_integer;
71: begin
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();

Line 75: a2 := JTF_NUMBER_TABLE();

71: begin
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();

Line 79: a6 := 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();
83: else

Line 81: a8 := JTF_NUMBER_TABLE();

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();
85: a1 := JTF_NUMBER_TABLE();

Line 84: a0 := 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();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_VARCHAR2_TABLE_100();

Line 85: a1 := JTF_NUMBER_TABLE();

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();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_VARCHAR2_TABLE_100();

Line 86: a2 := 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();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_VARCHAR2_TABLE_100();
89: a5 := JTF_VARCHAR2_TABLE_100();
90: a6 := JTF_NUMBER_TABLE();

Line 90: a6 := 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();
94: if t.count > 0 then

Line 92: a8 := JTF_NUMBER_TABLE();

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);
96: a1.extend(t.count);

Line 128: procedure rosetta_table_copy_in_p4(t out nocopy pv_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE

124: end if;
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

Line 132: , a4 JTF_NUMBER_TABLE

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
135: ddindx binary_integer; indx binary_integer;
136: begin

Line 157: procedure rosetta_table_copy_out_p4(t pv_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

153: end loop;
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

Line 161: , a4 out nocopy JTF_NUMBER_TABLE

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
164: ddindx binary_integer; indx binary_integer;
165: begin

Line 167: a0 := JTF_NUMBER_TABLE();

163: ) as
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();

Line 171: a4 := JTF_NUMBER_TABLE();

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
174: a0 := JTF_NUMBER_TABLE();
175: a1 := JTF_VARCHAR2_TABLE_100();

Line 174: a0 := JTF_NUMBER_TABLE();

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();
177: a3 := JTF_VARCHAR2_TABLE_300();
178: a4 := JTF_NUMBER_TABLE();

Line 178: a4 := JTF_NUMBER_TABLE();

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
181: a0.extend(t.count);
182: a1.extend(t.count);

Line 206: procedure rosetta_table_copy_in_p6(t out nocopy pv_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE

202: end if;
203: end if;
204: end rosetta_table_copy_out_p4;
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

Line 207: , a1 JTF_NUMBER_TABLE

203: end if;
204: end rosetta_table_copy_out_p4;
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;

Line 208: , a2 JTF_NUMBER_TABLE

204: end rosetta_table_copy_out_p4;
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

Line 231: procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

227: end loop;
228: end if;
229: end if;
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

Line 232: , a1 out nocopy JTF_NUMBER_TABLE

228: end if;
229: end if;
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;

Line 233: , a2 out nocopy JTF_NUMBER_TABLE

229: end if;
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

Line 239: a0 := JTF_NUMBER_TABLE();

235: ) as
236: ddindx binary_integer; indx binary_integer;
237: begin
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

Line 240: a1 := JTF_NUMBER_TABLE();

236: ddindx binary_integer; indx binary_integer;
237: begin
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();

Line 241: a2 := JTF_NUMBER_TABLE();

237: begin
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();

Line 244: 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();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: if t.count > 0 then

Line 245: 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();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: if t.count > 0 then
249: a0.extend(t.count);

Line 246: 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();
247: a3 := JTF_VARCHAR2_TABLE_100();
248: if t.count > 0 then
249: a0.extend(t.count);
250: a1.extend(t.count);

Line 276: , p7_a0 JTF_NUMBER_TABLE

272: , p_commit VARCHAR2
273: , p_benefit_id NUMBER
274: , p_operation VARCHAR2
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

Line 277: , p7_a1 JTF_NUMBER_TABLE

273: , p_benefit_id NUMBER
274: , p_operation VARCHAR2
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

Line 278: , p7_a2 JTF_NUMBER_TABLE

274: , p_operation VARCHAR2
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

Line 280: , p8_a0 JTF_NUMBER_TABLE

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
284: , p8_a4 JTF_VARCHAR2_TABLE_100

Line 281: , p8_a1 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
284: , p8_a4 JTF_VARCHAR2_TABLE_100
285: , p8_a5 JTF_VARCHAR2_TABLE_100

Line 282: , p8_a2 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
284: , p8_a4 JTF_VARCHAR2_TABLE_100
285: , p8_a5 JTF_VARCHAR2_TABLE_100
286: , p8_a6 JTF_NUMBER_TABLE

Line 286: , p8_a6 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
290: , p9_a0 JTF_NUMBER_TABLE

Line 288: , p8_a8 JTF_NUMBER_TABLE

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
292: , p9_a2 JTF_VARCHAR2_TABLE_100

Line 290: , p9_a0 JTF_NUMBER_TABLE

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
294: , p9_a4 JTF_NUMBER_TABLE

Line 294: , p9_a4 JTF_NUMBER_TABLE

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
297: , x_qp_list_header_id out nocopy NUMBER
298: , x_error_location out nocopy NUMBER