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.OZF_OFFER_PERFORMANCE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p3(t out nocopy ozf_offer_performance_pvt.offer_perf_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_p3(t out nocopy ozf_offer_performance_pvt.offer_perf_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ozf_offer_performance_pvt.offer_perf_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ozf_offer_performance_pvt.offer_perf_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE

Line 27: , a5 JTF_NUMBER_TABLE

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

Line 28: , a6 JTF_NUMBER_TABLE

24: , a2 JTF_DATE_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300

Line 29: , a7 JTF_NUMBER_TABLE

25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE

Line 33: , a11 JTF_NUMBER_TABLE

29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_DATE_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_VARCHAR2_TABLE_100

Line 36: , a14 JTF_NUMBER_TABLE

32: , a10 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_DATE_TABLE
35: , a13 JTF_DATE_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_200
40: , a18 JTF_VARCHAR2_TABLE_200

Line 54: , a32 JTF_NUMBER_TABLE

50: , a28 JTF_VARCHAR2_TABLE_200
51: , a29 JTF_VARCHAR2_TABLE_200
52: , a30 JTF_VARCHAR2_TABLE_200
53: , a31 JTF_VARCHAR2_TABLE_200
54: , a32 JTF_NUMBER_TABLE
55: , a33 JTF_VARCHAR2_TABLE_100
56: , a34 JTF_VARCHAR2_TABLE_100
57: , a35 JTF_VARCHAR2_TABLE_4000
58: ) as

Line 111: procedure rosetta_table_copy_out_p3(t ozf_offer_performance_pvt.offer_perf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

107: end loop;
108: end if;
109: end if;
110: end rosetta_table_copy_in_p3;
111: procedure rosetta_table_copy_out_p3(t ozf_offer_performance_pvt.offer_perf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_DATE_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_DATE_TABLE

Line 112: , a1 out nocopy JTF_NUMBER_TABLE

108: end if;
109: end if;
110: end rosetta_table_copy_in_p3;
111: procedure rosetta_table_copy_out_p3(t ozf_offer_performance_pvt.offer_perf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_DATE_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_DATE_TABLE
116: , a5 out nocopy JTF_NUMBER_TABLE

Line 114: , a3 out nocopy JTF_NUMBER_TABLE

110: end rosetta_table_copy_in_p3;
111: procedure rosetta_table_copy_out_p3(t ozf_offer_performance_pvt.offer_perf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_DATE_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_DATE_TABLE
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_NUMBER_TABLE
118: , a7 out nocopy JTF_NUMBER_TABLE

Line 116: , a5 out nocopy JTF_NUMBER_TABLE

112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_DATE_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_DATE_TABLE
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_NUMBER_TABLE
118: , a7 out nocopy JTF_NUMBER_TABLE
119: , a8 out nocopy JTF_VARCHAR2_TABLE_100
120: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , a6 out nocopy JTF_NUMBER_TABLE

113: , a2 out nocopy JTF_DATE_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_DATE_TABLE
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_NUMBER_TABLE
118: , a7 out nocopy JTF_NUMBER_TABLE
119: , a8 out nocopy JTF_VARCHAR2_TABLE_100
120: , a9 out nocopy JTF_VARCHAR2_TABLE_100
121: , a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 118: , a7 out nocopy JTF_NUMBER_TABLE

114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_DATE_TABLE
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_NUMBER_TABLE
118: , a7 out nocopy JTF_NUMBER_TABLE
119: , a8 out nocopy JTF_VARCHAR2_TABLE_100
120: , a9 out nocopy JTF_VARCHAR2_TABLE_100
121: , a10 out nocopy JTF_VARCHAR2_TABLE_300
122: , a11 out nocopy JTF_NUMBER_TABLE

Line 122: , a11 out nocopy JTF_NUMBER_TABLE

118: , a7 out nocopy JTF_NUMBER_TABLE
119: , a8 out nocopy JTF_VARCHAR2_TABLE_100
120: , a9 out nocopy JTF_VARCHAR2_TABLE_100
121: , a10 out nocopy JTF_VARCHAR2_TABLE_300
122: , a11 out nocopy JTF_NUMBER_TABLE
123: , a12 out nocopy JTF_DATE_TABLE
124: , a13 out nocopy JTF_DATE_TABLE
125: , a14 out nocopy JTF_NUMBER_TABLE
126: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 125: , a14 out nocopy JTF_NUMBER_TABLE

121: , a10 out nocopy JTF_VARCHAR2_TABLE_300
122: , a11 out nocopy JTF_NUMBER_TABLE
123: , a12 out nocopy JTF_DATE_TABLE
124: , a13 out nocopy JTF_DATE_TABLE
125: , a14 out nocopy JTF_NUMBER_TABLE
126: , a15 out nocopy JTF_VARCHAR2_TABLE_100
127: , a16 out nocopy JTF_VARCHAR2_TABLE_100
128: , a17 out nocopy JTF_VARCHAR2_TABLE_200
129: , a18 out nocopy JTF_VARCHAR2_TABLE_200

Line 143: , a32 out nocopy JTF_NUMBER_TABLE

139: , a28 out nocopy JTF_VARCHAR2_TABLE_200
140: , a29 out nocopy JTF_VARCHAR2_TABLE_200
141: , a30 out nocopy JTF_VARCHAR2_TABLE_200
142: , a31 out nocopy JTF_VARCHAR2_TABLE_200
143: , a32 out nocopy JTF_NUMBER_TABLE
144: , a33 out nocopy JTF_VARCHAR2_TABLE_100
145: , a34 out nocopy JTF_VARCHAR2_TABLE_100
146: , a35 out nocopy JTF_VARCHAR2_TABLE_4000
147: ) as

Line 151: a0 := JTF_NUMBER_TABLE();

147: ) as
148: ddindx binary_integer; indx binary_integer;
149: begin
150: if t is null or t.count = 0 then
151: a0 := JTF_NUMBER_TABLE();
152: a1 := JTF_NUMBER_TABLE();
153: a2 := JTF_DATE_TABLE();
154: a3 := JTF_NUMBER_TABLE();
155: a4 := JTF_DATE_TABLE();

Line 152: a1 := JTF_NUMBER_TABLE();

148: ddindx binary_integer; indx binary_integer;
149: begin
150: if t is null or t.count = 0 then
151: a0 := JTF_NUMBER_TABLE();
152: a1 := JTF_NUMBER_TABLE();
153: a2 := JTF_DATE_TABLE();
154: a3 := JTF_NUMBER_TABLE();
155: a4 := JTF_DATE_TABLE();
156: a5 := JTF_NUMBER_TABLE();

Line 154: a3 := JTF_NUMBER_TABLE();

150: if t is null or t.count = 0 then
151: a0 := JTF_NUMBER_TABLE();
152: a1 := JTF_NUMBER_TABLE();
153: a2 := JTF_DATE_TABLE();
154: a3 := JTF_NUMBER_TABLE();
155: a4 := JTF_DATE_TABLE();
156: a5 := JTF_NUMBER_TABLE();
157: a6 := JTF_NUMBER_TABLE();
158: a7 := JTF_NUMBER_TABLE();

Line 156: a5 := JTF_NUMBER_TABLE();

152: a1 := JTF_NUMBER_TABLE();
153: a2 := JTF_DATE_TABLE();
154: a3 := JTF_NUMBER_TABLE();
155: a4 := JTF_DATE_TABLE();
156: a5 := JTF_NUMBER_TABLE();
157: a6 := JTF_NUMBER_TABLE();
158: a7 := JTF_NUMBER_TABLE();
159: a8 := JTF_VARCHAR2_TABLE_100();
160: a9 := JTF_VARCHAR2_TABLE_100();

Line 157: a6 := JTF_NUMBER_TABLE();

153: a2 := JTF_DATE_TABLE();
154: a3 := JTF_NUMBER_TABLE();
155: a4 := JTF_DATE_TABLE();
156: a5 := JTF_NUMBER_TABLE();
157: a6 := JTF_NUMBER_TABLE();
158: a7 := JTF_NUMBER_TABLE();
159: a8 := JTF_VARCHAR2_TABLE_100();
160: a9 := JTF_VARCHAR2_TABLE_100();
161: a10 := JTF_VARCHAR2_TABLE_300();

Line 158: a7 := JTF_NUMBER_TABLE();

154: a3 := JTF_NUMBER_TABLE();
155: a4 := JTF_DATE_TABLE();
156: a5 := JTF_NUMBER_TABLE();
157: a6 := JTF_NUMBER_TABLE();
158: a7 := JTF_NUMBER_TABLE();
159: a8 := JTF_VARCHAR2_TABLE_100();
160: a9 := JTF_VARCHAR2_TABLE_100();
161: a10 := JTF_VARCHAR2_TABLE_300();
162: a11 := JTF_NUMBER_TABLE();

Line 162: a11 := JTF_NUMBER_TABLE();

158: a7 := JTF_NUMBER_TABLE();
159: a8 := JTF_VARCHAR2_TABLE_100();
160: a9 := JTF_VARCHAR2_TABLE_100();
161: a10 := JTF_VARCHAR2_TABLE_300();
162: a11 := JTF_NUMBER_TABLE();
163: a12 := JTF_DATE_TABLE();
164: a13 := JTF_DATE_TABLE();
165: a14 := JTF_NUMBER_TABLE();
166: a15 := JTF_VARCHAR2_TABLE_100();

Line 165: a14 := JTF_NUMBER_TABLE();

161: a10 := JTF_VARCHAR2_TABLE_300();
162: a11 := JTF_NUMBER_TABLE();
163: a12 := JTF_DATE_TABLE();
164: a13 := JTF_DATE_TABLE();
165: a14 := JTF_NUMBER_TABLE();
166: a15 := JTF_VARCHAR2_TABLE_100();
167: a16 := JTF_VARCHAR2_TABLE_100();
168: a17 := JTF_VARCHAR2_TABLE_200();
169: a18 := JTF_VARCHAR2_TABLE_200();

Line 183: a32 := JTF_NUMBER_TABLE();

179: a28 := JTF_VARCHAR2_TABLE_200();
180: a29 := JTF_VARCHAR2_TABLE_200();
181: a30 := JTF_VARCHAR2_TABLE_200();
182: a31 := JTF_VARCHAR2_TABLE_200();
183: a32 := JTF_NUMBER_TABLE();
184: a33 := JTF_VARCHAR2_TABLE_100();
185: a34 := JTF_VARCHAR2_TABLE_100();
186: a35 := JTF_VARCHAR2_TABLE_4000();
187: else

Line 188: a0 := JTF_NUMBER_TABLE();

184: a33 := JTF_VARCHAR2_TABLE_100();
185: a34 := JTF_VARCHAR2_TABLE_100();
186: a35 := JTF_VARCHAR2_TABLE_4000();
187: else
188: a0 := JTF_NUMBER_TABLE();
189: a1 := JTF_NUMBER_TABLE();
190: a2 := JTF_DATE_TABLE();
191: a3 := JTF_NUMBER_TABLE();
192: a4 := JTF_DATE_TABLE();

Line 189: a1 := JTF_NUMBER_TABLE();

185: a34 := JTF_VARCHAR2_TABLE_100();
186: a35 := JTF_VARCHAR2_TABLE_4000();
187: else
188: a0 := JTF_NUMBER_TABLE();
189: a1 := JTF_NUMBER_TABLE();
190: a2 := JTF_DATE_TABLE();
191: a3 := JTF_NUMBER_TABLE();
192: a4 := JTF_DATE_TABLE();
193: a5 := JTF_NUMBER_TABLE();

Line 191: a3 := JTF_NUMBER_TABLE();

187: else
188: a0 := JTF_NUMBER_TABLE();
189: a1 := JTF_NUMBER_TABLE();
190: a2 := JTF_DATE_TABLE();
191: a3 := JTF_NUMBER_TABLE();
192: a4 := JTF_DATE_TABLE();
193: a5 := JTF_NUMBER_TABLE();
194: a6 := JTF_NUMBER_TABLE();
195: a7 := JTF_NUMBER_TABLE();

Line 193: a5 := JTF_NUMBER_TABLE();

189: a1 := JTF_NUMBER_TABLE();
190: a2 := JTF_DATE_TABLE();
191: a3 := JTF_NUMBER_TABLE();
192: a4 := JTF_DATE_TABLE();
193: a5 := JTF_NUMBER_TABLE();
194: a6 := JTF_NUMBER_TABLE();
195: a7 := JTF_NUMBER_TABLE();
196: a8 := JTF_VARCHAR2_TABLE_100();
197: a9 := JTF_VARCHAR2_TABLE_100();

Line 194: a6 := JTF_NUMBER_TABLE();

190: a2 := JTF_DATE_TABLE();
191: a3 := JTF_NUMBER_TABLE();
192: a4 := JTF_DATE_TABLE();
193: a5 := JTF_NUMBER_TABLE();
194: a6 := JTF_NUMBER_TABLE();
195: a7 := JTF_NUMBER_TABLE();
196: a8 := JTF_VARCHAR2_TABLE_100();
197: a9 := JTF_VARCHAR2_TABLE_100();
198: a10 := JTF_VARCHAR2_TABLE_300();

Line 195: a7 := JTF_NUMBER_TABLE();

191: a3 := JTF_NUMBER_TABLE();
192: a4 := JTF_DATE_TABLE();
193: a5 := JTF_NUMBER_TABLE();
194: a6 := JTF_NUMBER_TABLE();
195: a7 := JTF_NUMBER_TABLE();
196: a8 := JTF_VARCHAR2_TABLE_100();
197: a9 := JTF_VARCHAR2_TABLE_100();
198: a10 := JTF_VARCHAR2_TABLE_300();
199: a11 := JTF_NUMBER_TABLE();

Line 199: a11 := JTF_NUMBER_TABLE();

195: a7 := JTF_NUMBER_TABLE();
196: a8 := JTF_VARCHAR2_TABLE_100();
197: a9 := JTF_VARCHAR2_TABLE_100();
198: a10 := JTF_VARCHAR2_TABLE_300();
199: a11 := JTF_NUMBER_TABLE();
200: a12 := JTF_DATE_TABLE();
201: a13 := JTF_DATE_TABLE();
202: a14 := JTF_NUMBER_TABLE();
203: a15 := JTF_VARCHAR2_TABLE_100();

Line 202: a14 := JTF_NUMBER_TABLE();

198: a10 := JTF_VARCHAR2_TABLE_300();
199: a11 := JTF_NUMBER_TABLE();
200: a12 := JTF_DATE_TABLE();
201: a13 := JTF_DATE_TABLE();
202: a14 := JTF_NUMBER_TABLE();
203: a15 := JTF_VARCHAR2_TABLE_100();
204: a16 := JTF_VARCHAR2_TABLE_100();
205: a17 := JTF_VARCHAR2_TABLE_200();
206: a18 := JTF_VARCHAR2_TABLE_200();

Line 220: a32 := JTF_NUMBER_TABLE();

216: a28 := JTF_VARCHAR2_TABLE_200();
217: a29 := JTF_VARCHAR2_TABLE_200();
218: a30 := JTF_VARCHAR2_TABLE_200();
219: a31 := JTF_VARCHAR2_TABLE_200();
220: a32 := JTF_NUMBER_TABLE();
221: a33 := JTF_VARCHAR2_TABLE_100();
222: a34 := JTF_VARCHAR2_TABLE_100();
223: a35 := JTF_VARCHAR2_TABLE_4000();
224: if t.count > 0 then