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_OFFR_QUAL_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offr_qual_pvt.ozf_offr_qual_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 ozf_offr_qual_pvt.ozf_offr_qual_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 24: , a2 JTF_NUMBER_TABLE

20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offr_qual_pvt.ozf_offr_qual_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE

Line 26: , a4 JTF_NUMBER_TABLE

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

Line 27: , a5 JTF_NUMBER_TABLE

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

Line 28: , a6 JTF_NUMBER_TABLE

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

Line 34: , a12 JTF_NUMBER_TABLE

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

Line 35: , a13 JTF_NUMBER_TABLE

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

Line 53: , a31 JTF_NUMBER_TABLE

49: , a27 JTF_VARCHAR2_TABLE_300
50: , a28 JTF_VARCHAR2_TABLE_300
51: , a29 JTF_VARCHAR2_TABLE_300
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if a0 is not null and a0.count > 0 then

Line 103: procedure rosetta_table_copy_out_p2(t ozf_offr_qual_pvt.ozf_offr_qual_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t ozf_offr_qual_pvt.ozf_offr_qual_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_DATE_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_DATE_TABLE
107: , a4 out nocopy JTF_NUMBER_TABLE

Line 105: , a2 out nocopy JTF_NUMBER_TABLE

101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t ozf_offr_qual_pvt.ozf_offr_qual_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_DATE_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_DATE_TABLE
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE

Line 107: , a4 out nocopy JTF_NUMBER_TABLE

103: procedure rosetta_table_copy_out_p2(t ozf_offr_qual_pvt.ozf_offr_qual_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_DATE_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_DATE_TABLE
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_VARCHAR2_TABLE_100
111: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a5 out nocopy JTF_NUMBER_TABLE

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

Line 109: , a6 out nocopy JTF_NUMBER_TABLE

105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_DATE_TABLE
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_NUMBER_TABLE
110: , a7 out nocopy JTF_VARCHAR2_TABLE_100
111: , a8 out nocopy JTF_VARCHAR2_TABLE_100
112: , a9 out nocopy JTF_VARCHAR2_TABLE_300
113: , a10 out nocopy JTF_DATE_TABLE

Line 115: , a12 out nocopy JTF_NUMBER_TABLE

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

Line 116: , a13 out nocopy JTF_NUMBER_TABLE

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

Line 134: , a31 out nocopy JTF_NUMBER_TABLE

130: , a27 out nocopy JTF_VARCHAR2_TABLE_300
131: , a28 out nocopy JTF_VARCHAR2_TABLE_300
132: , a29 out nocopy JTF_VARCHAR2_TABLE_300
133: , a30 out nocopy JTF_VARCHAR2_TABLE_100
134: , a31 out nocopy JTF_NUMBER_TABLE
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then

Line 139: a0 := JTF_NUMBER_TABLE();

135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_DATE_TABLE();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_DATE_TABLE();
143: a4 := JTF_NUMBER_TABLE();

Line 141: a2 := JTF_NUMBER_TABLE();

137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_DATE_TABLE();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_DATE_TABLE();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_NUMBER_TABLE();

Line 143: a4 := JTF_NUMBER_TABLE();

139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_DATE_TABLE();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_DATE_TABLE();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_NUMBER_TABLE();
146: a7 := JTF_VARCHAR2_TABLE_100();
147: a8 := JTF_VARCHAR2_TABLE_100();

Line 144: a5 := JTF_NUMBER_TABLE();

140: a1 := JTF_DATE_TABLE();
141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_DATE_TABLE();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_NUMBER_TABLE();
146: a7 := JTF_VARCHAR2_TABLE_100();
147: a8 := JTF_VARCHAR2_TABLE_100();
148: a9 := JTF_VARCHAR2_TABLE_300();

Line 145: a6 := JTF_NUMBER_TABLE();

141: a2 := JTF_NUMBER_TABLE();
142: a3 := JTF_DATE_TABLE();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_NUMBER_TABLE();
146: a7 := JTF_VARCHAR2_TABLE_100();
147: a8 := JTF_VARCHAR2_TABLE_100();
148: a9 := JTF_VARCHAR2_TABLE_300();
149: a10 := JTF_DATE_TABLE();

Line 151: a12 := JTF_NUMBER_TABLE();

147: a8 := JTF_VARCHAR2_TABLE_100();
148: a9 := JTF_VARCHAR2_TABLE_300();
149: a10 := JTF_DATE_TABLE();
150: a11 := JTF_DATE_TABLE();
151: a12 := JTF_NUMBER_TABLE();
152: a13 := JTF_NUMBER_TABLE();
153: a14 := JTF_VARCHAR2_TABLE_100();
154: a15 := JTF_VARCHAR2_TABLE_300();
155: a16 := JTF_VARCHAR2_TABLE_300();

Line 152: a13 := JTF_NUMBER_TABLE();

148: a9 := JTF_VARCHAR2_TABLE_300();
149: a10 := JTF_DATE_TABLE();
150: a11 := JTF_DATE_TABLE();
151: a12 := JTF_NUMBER_TABLE();
152: a13 := JTF_NUMBER_TABLE();
153: a14 := JTF_VARCHAR2_TABLE_100();
154: a15 := JTF_VARCHAR2_TABLE_300();
155: a16 := JTF_VARCHAR2_TABLE_300();
156: a17 := JTF_VARCHAR2_TABLE_300();

Line 170: a31 := JTF_NUMBER_TABLE();

166: a27 := JTF_VARCHAR2_TABLE_300();
167: a28 := JTF_VARCHAR2_TABLE_300();
168: a29 := JTF_VARCHAR2_TABLE_300();
169: a30 := JTF_VARCHAR2_TABLE_100();
170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_DATE_TABLE();
174: a2 := JTF_NUMBER_TABLE();

Line 172: a0 := JTF_NUMBER_TABLE();

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

Line 174: a2 := JTF_NUMBER_TABLE();

170: a31 := JTF_NUMBER_TABLE();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_DATE_TABLE();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_DATE_TABLE();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_NUMBER_TABLE();

Line 176: a4 := JTF_NUMBER_TABLE();

172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_DATE_TABLE();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_DATE_TABLE();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_VARCHAR2_TABLE_100();
180: a8 := JTF_VARCHAR2_TABLE_100();

Line 177: a5 := JTF_NUMBER_TABLE();

173: a1 := JTF_DATE_TABLE();
174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_DATE_TABLE();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_VARCHAR2_TABLE_100();
180: a8 := JTF_VARCHAR2_TABLE_100();
181: a9 := JTF_VARCHAR2_TABLE_300();

Line 178: a6 := JTF_NUMBER_TABLE();

174: a2 := JTF_NUMBER_TABLE();
175: a3 := JTF_DATE_TABLE();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_NUMBER_TABLE();
179: a7 := JTF_VARCHAR2_TABLE_100();
180: a8 := JTF_VARCHAR2_TABLE_100();
181: a9 := JTF_VARCHAR2_TABLE_300();
182: a10 := JTF_DATE_TABLE();

Line 184: a12 := JTF_NUMBER_TABLE();

180: a8 := JTF_VARCHAR2_TABLE_100();
181: a9 := JTF_VARCHAR2_TABLE_300();
182: a10 := JTF_DATE_TABLE();
183: a11 := JTF_DATE_TABLE();
184: a12 := JTF_NUMBER_TABLE();
185: a13 := JTF_NUMBER_TABLE();
186: a14 := JTF_VARCHAR2_TABLE_100();
187: a15 := JTF_VARCHAR2_TABLE_300();
188: a16 := JTF_VARCHAR2_TABLE_300();

Line 185: a13 := JTF_NUMBER_TABLE();

181: a9 := JTF_VARCHAR2_TABLE_300();
182: a10 := JTF_DATE_TABLE();
183: a11 := JTF_DATE_TABLE();
184: a12 := JTF_NUMBER_TABLE();
185: a13 := JTF_NUMBER_TABLE();
186: a14 := JTF_VARCHAR2_TABLE_100();
187: a15 := JTF_VARCHAR2_TABLE_300();
188: a16 := JTF_VARCHAR2_TABLE_300();
189: a17 := JTF_VARCHAR2_TABLE_300();

Line 203: a31 := JTF_NUMBER_TABLE();

199: a27 := JTF_VARCHAR2_TABLE_300();
200: a28 := JTF_VARCHAR2_TABLE_300();
201: a29 := JTF_VARCHAR2_TABLE_300();
202: a30 := JTF_VARCHAR2_TABLE_100();
203: a31 := JTF_NUMBER_TABLE();
204: if t.count > 0 then
205: a0.extend(t.count);
206: a1.extend(t.count);
207: a2.extend(t.count);