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

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy ozf_mass_settlement_pvt.open_claim_tbl, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ozf_mass_settlement_pvt.open_claim_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_2000

Line 19: , a3 JTF_NUMBER_TABLE

15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ozf_mass_settlement_pvt.open_claim_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_2000
21: ) as
22: ddindx binary_integer; indx binary_integer;
23: begin

Line 43: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE

39: end loop;
40: end if;
41: end if;
42: end rosetta_table_copy_in_p2;
43: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_VARCHAR2_TABLE_100
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a3 out nocopy JTF_NUMBER_TABLE
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 46: , a3 out nocopy JTF_NUMBER_TABLE

42: end rosetta_table_copy_in_p2;
43: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_VARCHAR2_TABLE_100
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a3 out nocopy JTF_NUMBER_TABLE
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin

Line 52: a0 := JTF_NUMBER_TABLE();

48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: a3 := JTF_NUMBER_TABLE();
56: a4 := JTF_VARCHAR2_TABLE_2000();

Line 55: a3 := JTF_NUMBER_TABLE();

51: if t is null or t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: a3 := JTF_NUMBER_TABLE();
56: a4 := JTF_VARCHAR2_TABLE_2000();
57: else
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_100();

Line 58: a0 := JTF_NUMBER_TABLE();

54: a2 := JTF_VARCHAR2_TABLE_100();
55: a3 := JTF_NUMBER_TABLE();
56: a4 := JTF_VARCHAR2_TABLE_2000();
57: else
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_100();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_VARCHAR2_TABLE_2000();

Line 61: a3 := JTF_NUMBER_TABLE();

57: else
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_100();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_VARCHAR2_TABLE_2000();
63: if t.count > 0 then
64: a0.extend(t.count);
65: a1.extend(t.count);

Line 87: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE

83: end if;
84: end if;
85: end rosetta_table_copy_out_p2;
86:
87: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_NUMBER_TABLE

Line 88: , a1 JTF_NUMBER_TABLE

84: end if;
85: end rosetta_table_copy_out_p2;
86:
87: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_NUMBER_TABLE
92: ) as

Line 91: , a4 JTF_NUMBER_TABLE

87: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_NUMBER_TABLE
92: ) as
93: ddindx binary_integer; indx binary_integer;
94: begin
95: if a0 is not null and a0.count > 0 then

Line 114: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE

110: end loop;
111: end if;
112: end if;
113: end rosetta_table_copy_in_p4;
114: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_NUMBER_TABLE
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_VARCHAR2_TABLE_100
118: , a4 out nocopy JTF_NUMBER_TABLE

Line 115: , a1 out nocopy JTF_NUMBER_TABLE

111: end if;
112: end if;
113: end rosetta_table_copy_in_p4;
114: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_NUMBER_TABLE
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_VARCHAR2_TABLE_100
118: , a4 out nocopy JTF_NUMBER_TABLE
119: ) as

Line 118: , a4 out nocopy JTF_NUMBER_TABLE

114: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
115: , a1 out nocopy JTF_NUMBER_TABLE
116: , a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , a3 out nocopy JTF_VARCHAR2_TABLE_100
118: , a4 out nocopy JTF_NUMBER_TABLE
119: ) as
120: ddindx binary_integer; indx binary_integer;
121: begin
122: if t is null or t.count = 0 then

Line 123: a0 := JTF_NUMBER_TABLE();

119: ) as
120: ddindx binary_integer; indx binary_integer;
121: begin
122: if t is null or t.count = 0 then
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_VARCHAR2_TABLE_100();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_NUMBER_TABLE();

Line 124: a1 := JTF_NUMBER_TABLE();

120: ddindx binary_integer; indx binary_integer;
121: begin
122: if t is null or t.count = 0 then
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_VARCHAR2_TABLE_100();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_NUMBER_TABLE();
128: else

Line 127: a4 := JTF_NUMBER_TABLE();

123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_VARCHAR2_TABLE_100();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_VARCHAR2_TABLE_100();

Line 129: a0 := JTF_NUMBER_TABLE();

125: a2 := JTF_VARCHAR2_TABLE_100();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_VARCHAR2_TABLE_100();
132: a3 := JTF_VARCHAR2_TABLE_100();
133: a4 := JTF_NUMBER_TABLE();

Line 130: a1 := JTF_NUMBER_TABLE();

126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_NUMBER_TABLE();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_VARCHAR2_TABLE_100();
132: a3 := JTF_VARCHAR2_TABLE_100();
133: a4 := JTF_NUMBER_TABLE();
134: if t.count > 0 then

Line 133: a4 := JTF_NUMBER_TABLE();

129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_VARCHAR2_TABLE_100();
132: a3 := JTF_VARCHAR2_TABLE_100();
133: a4 := JTF_NUMBER_TABLE();
134: if t.count > 0 then
135: a0.extend(t.count);
136: a1.extend(t.count);
137: a2.extend(t.count);

Line 160: , a2 JTF_NUMBER_TABLE

156: end rosetta_table_copy_out_p4;
157:
158: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
159: , a1 JTF_DATE_TABLE
160: , a2 JTF_NUMBER_TABLE
161: , a3 JTF_NUMBER_TABLE
162: , a4 JTF_NUMBER_TABLE
163: , a5 JTF_VARCHAR2_TABLE_2000
164: ) as

Line 161: , a3 JTF_NUMBER_TABLE

157:
158: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
159: , a1 JTF_DATE_TABLE
160: , a2 JTF_NUMBER_TABLE
161: , a3 JTF_NUMBER_TABLE
162: , a4 JTF_NUMBER_TABLE
163: , a5 JTF_VARCHAR2_TABLE_2000
164: ) as
165: ddindx binary_integer; indx binary_integer;

Line 162: , a4 JTF_NUMBER_TABLE

158: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
159: , a1 JTF_DATE_TABLE
160: , a2 JTF_NUMBER_TABLE
161: , a3 JTF_NUMBER_TABLE
162: , a4 JTF_NUMBER_TABLE
163: , a5 JTF_VARCHAR2_TABLE_2000
164: ) as
165: ddindx binary_integer; indx binary_integer;
166: begin

Line 189: , a2 out nocopy JTF_NUMBER_TABLE

185: end if;
186: end rosetta_table_copy_in_p6;
187: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
188: , a1 out nocopy JTF_DATE_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
193: ) as

Line 190: , a3 out nocopy JTF_NUMBER_TABLE

186: end rosetta_table_copy_in_p6;
187: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
188: , a1 out nocopy JTF_DATE_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
193: ) as
194: ddindx binary_integer; indx binary_integer;

Line 191: , a4 out nocopy JTF_NUMBER_TABLE

187: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
188: , a1 out nocopy JTF_DATE_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_NUMBER_TABLE
192: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
193: ) as
194: ddindx binary_integer; indx binary_integer;
195: begin

Line 199: a2 := JTF_NUMBER_TABLE();

195: begin
196: if t is null or t.count = 0 then
197: a0 := JTF_VARCHAR2_TABLE_100();
198: a1 := JTF_DATE_TABLE();
199: a2 := JTF_NUMBER_TABLE();
200: a3 := JTF_NUMBER_TABLE();
201: a4 := JTF_NUMBER_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_2000();
203: else

Line 200: a3 := JTF_NUMBER_TABLE();

196: if t is null or t.count = 0 then
197: a0 := JTF_VARCHAR2_TABLE_100();
198: a1 := JTF_DATE_TABLE();
199: a2 := JTF_NUMBER_TABLE();
200: a3 := JTF_NUMBER_TABLE();
201: a4 := JTF_NUMBER_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_2000();
203: else
204: a0 := JTF_VARCHAR2_TABLE_100();

Line 201: a4 := JTF_NUMBER_TABLE();

197: a0 := JTF_VARCHAR2_TABLE_100();
198: a1 := JTF_DATE_TABLE();
199: a2 := JTF_NUMBER_TABLE();
200: a3 := JTF_NUMBER_TABLE();
201: a4 := JTF_NUMBER_TABLE();
202: a5 := JTF_VARCHAR2_TABLE_2000();
203: else
204: a0 := JTF_VARCHAR2_TABLE_100();
205: a1 := JTF_DATE_TABLE();

Line 206: a2 := JTF_NUMBER_TABLE();

202: a5 := JTF_VARCHAR2_TABLE_2000();
203: else
204: a0 := JTF_VARCHAR2_TABLE_100();
205: a1 := JTF_DATE_TABLE();
206: a2 := JTF_NUMBER_TABLE();
207: a3 := JTF_NUMBER_TABLE();
208: a4 := JTF_NUMBER_TABLE();
209: a5 := JTF_VARCHAR2_TABLE_2000();
210: if t.count > 0 then

Line 207: a3 := JTF_NUMBER_TABLE();

203: else
204: a0 := JTF_VARCHAR2_TABLE_100();
205: a1 := JTF_DATE_TABLE();
206: a2 := JTF_NUMBER_TABLE();
207: a3 := JTF_NUMBER_TABLE();
208: a4 := JTF_NUMBER_TABLE();
209: a5 := JTF_VARCHAR2_TABLE_2000();
210: if t.count > 0 then
211: a0.extend(t.count);

Line 208: a4 := JTF_NUMBER_TABLE();

204: a0 := JTF_VARCHAR2_TABLE_100();
205: a1 := JTF_DATE_TABLE();
206: a2 := JTF_NUMBER_TABLE();
207: a3 := JTF_NUMBER_TABLE();
208: a4 := JTF_NUMBER_TABLE();
209: a5 := JTF_VARCHAR2_TABLE_2000();
210: if t.count > 0 then
211: a0.extend(t.count);
212: a1.extend(t.count);

Line 254: , p8_a0 JTF_NUMBER_TABLE

250: , p7_a7 VARCHAR2
251: , p7_a8 NUMBER
252: , p7_a9 NUMBER
253: , p7_a10 VARCHAR2
254: , p8_a0 JTF_NUMBER_TABLE
255: , p8_a1 JTF_VARCHAR2_TABLE_100
256: , p8_a2 JTF_VARCHAR2_TABLE_100
257: , p8_a3 JTF_NUMBER_TABLE
258: , p8_a4 JTF_VARCHAR2_TABLE_2000

Line 257: , p8_a3 JTF_NUMBER_TABLE

253: , p7_a10 VARCHAR2
254: , p8_a0 JTF_NUMBER_TABLE
255: , p8_a1 JTF_VARCHAR2_TABLE_100
256: , p8_a2 JTF_VARCHAR2_TABLE_100
257: , p8_a3 JTF_NUMBER_TABLE
258: , p8_a4 JTF_VARCHAR2_TABLE_2000
259: , p9_a0 JTF_NUMBER_TABLE
260: , p9_a1 JTF_NUMBER_TABLE
261: , p9_a2 JTF_VARCHAR2_TABLE_100

Line 259: , p9_a0 JTF_NUMBER_TABLE

255: , p8_a1 JTF_VARCHAR2_TABLE_100
256: , p8_a2 JTF_VARCHAR2_TABLE_100
257: , p8_a3 JTF_NUMBER_TABLE
258: , p8_a4 JTF_VARCHAR2_TABLE_2000
259: , p9_a0 JTF_NUMBER_TABLE
260: , p9_a1 JTF_NUMBER_TABLE
261: , p9_a2 JTF_VARCHAR2_TABLE_100
262: , p9_a3 JTF_VARCHAR2_TABLE_100
263: , p9_a4 JTF_NUMBER_TABLE

Line 260: , p9_a1 JTF_NUMBER_TABLE

256: , p8_a2 JTF_VARCHAR2_TABLE_100
257: , p8_a3 JTF_NUMBER_TABLE
258: , p8_a4 JTF_VARCHAR2_TABLE_2000
259: , p9_a0 JTF_NUMBER_TABLE
260: , p9_a1 JTF_NUMBER_TABLE
261: , p9_a2 JTF_VARCHAR2_TABLE_100
262: , p9_a3 JTF_VARCHAR2_TABLE_100
263: , p9_a4 JTF_NUMBER_TABLE
264: , p10_a0 JTF_VARCHAR2_TABLE_100

Line 263: , p9_a4 JTF_NUMBER_TABLE

259: , p9_a0 JTF_NUMBER_TABLE
260: , p9_a1 JTF_NUMBER_TABLE
261: , p9_a2 JTF_VARCHAR2_TABLE_100
262: , p9_a3 JTF_VARCHAR2_TABLE_100
263: , p9_a4 JTF_NUMBER_TABLE
264: , p10_a0 JTF_VARCHAR2_TABLE_100
265: , p10_a1 JTF_DATE_TABLE
266: , p10_a2 JTF_NUMBER_TABLE
267: , p10_a3 JTF_NUMBER_TABLE

Line 266: , p10_a2 JTF_NUMBER_TABLE

262: , p9_a3 JTF_VARCHAR2_TABLE_100
263: , p9_a4 JTF_NUMBER_TABLE
264: , p10_a0 JTF_VARCHAR2_TABLE_100
265: , p10_a1 JTF_DATE_TABLE
266: , p10_a2 JTF_NUMBER_TABLE
267: , p10_a3 JTF_NUMBER_TABLE
268: , p10_a4 JTF_NUMBER_TABLE
269: , p10_a5 JTF_VARCHAR2_TABLE_2000
270: , x_claim_group_id out nocopy NUMBER

Line 267: , p10_a3 JTF_NUMBER_TABLE

263: , p9_a4 JTF_NUMBER_TABLE
264: , p10_a0 JTF_VARCHAR2_TABLE_100
265: , p10_a1 JTF_DATE_TABLE
266: , p10_a2 JTF_NUMBER_TABLE
267: , p10_a3 JTF_NUMBER_TABLE
268: , p10_a4 JTF_NUMBER_TABLE
269: , p10_a5 JTF_VARCHAR2_TABLE_2000
270: , x_claim_group_id out nocopy NUMBER
271: , x_claim_group_number out nocopy VARCHAR2

Line 268: , p10_a4 JTF_NUMBER_TABLE

264: , p10_a0 JTF_VARCHAR2_TABLE_100
265: , p10_a1 JTF_DATE_TABLE
266: , p10_a2 JTF_NUMBER_TABLE
267: , p10_a3 JTF_NUMBER_TABLE
268: , p10_a4 JTF_NUMBER_TABLE
269: , p10_a5 JTF_VARCHAR2_TABLE_2000
270: , x_claim_group_id out nocopy NUMBER
271: , x_claim_group_number out nocopy VARCHAR2
272: )