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: ) as

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: ) as
21: ddindx binary_integer; indx binary_integer;
22: begin
23: if a0 is not null and a0.count > 0 then

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

37: end loop;
38: end if;
39: end if;
40: end rosetta_table_copy_in_p2;
41: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_VARCHAR2_TABLE_100
44: , a3 out nocopy JTF_NUMBER_TABLE
45: ) as

Line 44: , a3 out nocopy JTF_NUMBER_TABLE

40: end rosetta_table_copy_in_p2;
41: procedure rosetta_table_copy_out_p2(t ozf_mass_settlement_pvt.open_claim_tbl, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_100
43: , a2 out nocopy JTF_VARCHAR2_TABLE_100
44: , a3 out nocopy JTF_NUMBER_TABLE
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then

Line 49: a0 := JTF_NUMBER_TABLE();

45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_NUMBER_TABLE();
53: else

Line 52: a3 := JTF_NUMBER_TABLE();

48: if t is null or t.count = 0 then
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_VARCHAR2_TABLE_100();
56: a2 := JTF_VARCHAR2_TABLE_100();

Line 54: a0 := JTF_NUMBER_TABLE();

50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_VARCHAR2_TABLE_100();
56: a2 := JTF_VARCHAR2_TABLE_100();
57: a3 := JTF_NUMBER_TABLE();
58: if t.count > 0 then

Line 57: a3 := JTF_NUMBER_TABLE();

53: else
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_VARCHAR2_TABLE_100();
56: a2 := JTF_VARCHAR2_TABLE_100();
57: a3 := JTF_NUMBER_TABLE();
58: if t.count > 0 then
59: a0.extend(t.count);
60: a1.extend(t.count);
61: a2.extend(t.count);

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

76: end if;
77: end if;
78: end rosetta_table_copy_out_p2;
79:
80: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_VARCHAR2_TABLE_100
83: , a3 JTF_VARCHAR2_TABLE_100
84: , a4 JTF_NUMBER_TABLE

Line 81: , a1 JTF_NUMBER_TABLE

77: end if;
78: end rosetta_table_copy_out_p2;
79:
80: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_VARCHAR2_TABLE_100
83: , a3 JTF_VARCHAR2_TABLE_100
84: , a4 JTF_NUMBER_TABLE
85: ) as

Line 84: , a4 JTF_NUMBER_TABLE

80: procedure rosetta_table_copy_in_p4(t out nocopy ozf_mass_settlement_pvt.open_transaction_tbl, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_VARCHAR2_TABLE_100
83: , a3 JTF_VARCHAR2_TABLE_100
84: , a4 JTF_NUMBER_TABLE
85: ) as
86: ddindx binary_integer; indx binary_integer;
87: begin
88: if a0 is not null and a0.count > 0 then

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

103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p4;
107: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , a4 out nocopy JTF_NUMBER_TABLE

Line 108: , a1 out nocopy JTF_NUMBER_TABLE

104: end if;
105: end if;
106: end rosetta_table_copy_in_p4;
107: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , a4 out nocopy JTF_NUMBER_TABLE
112: ) as

Line 111: , a4 out nocopy JTF_NUMBER_TABLE

107: procedure rosetta_table_copy_out_p4(t ozf_mass_settlement_pvt.open_transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , a4 out nocopy JTF_NUMBER_TABLE
112: ) as
113: ddindx binary_integer; indx binary_integer;
114: begin
115: if t is null or t.count = 0 then

Line 116: a0 := JTF_NUMBER_TABLE();

112: ) as
113: ddindx binary_integer; indx binary_integer;
114: begin
115: if t is null or t.count = 0 then
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_VARCHAR2_TABLE_100();
120: a4 := JTF_NUMBER_TABLE();

Line 117: a1 := JTF_NUMBER_TABLE();

113: ddindx binary_integer; indx binary_integer;
114: begin
115: if t is null or t.count = 0 then
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_VARCHAR2_TABLE_100();
120: a4 := JTF_NUMBER_TABLE();
121: else

Line 120: a4 := JTF_NUMBER_TABLE();

116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_VARCHAR2_TABLE_100();
120: a4 := JTF_NUMBER_TABLE();
121: else
122: a0 := JTF_NUMBER_TABLE();
123: a1 := JTF_NUMBER_TABLE();
124: a2 := JTF_VARCHAR2_TABLE_100();

Line 122: a0 := JTF_NUMBER_TABLE();

118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_VARCHAR2_TABLE_100();
120: a4 := JTF_NUMBER_TABLE();
121: else
122: a0 := JTF_NUMBER_TABLE();
123: a1 := JTF_NUMBER_TABLE();
124: a2 := JTF_VARCHAR2_TABLE_100();
125: a3 := JTF_VARCHAR2_TABLE_100();
126: a4 := JTF_NUMBER_TABLE();

Line 123: a1 := JTF_NUMBER_TABLE();

119: a3 := JTF_VARCHAR2_TABLE_100();
120: a4 := JTF_NUMBER_TABLE();
121: else
122: a0 := JTF_NUMBER_TABLE();
123: a1 := JTF_NUMBER_TABLE();
124: a2 := JTF_VARCHAR2_TABLE_100();
125: a3 := JTF_VARCHAR2_TABLE_100();
126: a4 := JTF_NUMBER_TABLE();
127: if t.count > 0 then

Line 126: a4 := JTF_NUMBER_TABLE();

122: a0 := JTF_NUMBER_TABLE();
123: a1 := JTF_NUMBER_TABLE();
124: a2 := JTF_VARCHAR2_TABLE_100();
125: a3 := JTF_VARCHAR2_TABLE_100();
126: a4 := JTF_NUMBER_TABLE();
127: if t.count > 0 then
128: a0.extend(t.count);
129: a1.extend(t.count);
130: a2.extend(t.count);

Line 153: , a2 JTF_NUMBER_TABLE

149: end rosetta_table_copy_out_p4;
150:
151: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
152: , a1 JTF_DATE_TABLE
153: , a2 JTF_NUMBER_TABLE
154: , a3 JTF_NUMBER_TABLE
155: , a4 JTF_NUMBER_TABLE
156: ) as
157: ddindx binary_integer; indx binary_integer;

Line 154: , a3 JTF_NUMBER_TABLE

150:
151: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
152: , a1 JTF_DATE_TABLE
153: , a2 JTF_NUMBER_TABLE
154: , a3 JTF_NUMBER_TABLE
155: , a4 JTF_NUMBER_TABLE
156: ) as
157: ddindx binary_integer; indx binary_integer;
158: begin

Line 155: , a4 JTF_NUMBER_TABLE

151: procedure rosetta_table_copy_in_p6(t out nocopy ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 JTF_VARCHAR2_TABLE_100
152: , a1 JTF_DATE_TABLE
153: , a2 JTF_NUMBER_TABLE
154: , a3 JTF_NUMBER_TABLE
155: , a4 JTF_NUMBER_TABLE
156: ) as
157: ddindx binary_integer; indx binary_integer;
158: begin
159: if a0 is not null and a0.count > 0 then

Line 180: , a2 out nocopy JTF_NUMBER_TABLE

176: end if;
177: end rosetta_table_copy_in_p6;
178: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
179: , a1 out nocopy JTF_DATE_TABLE
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE
183: ) as
184: ddindx binary_integer; indx binary_integer;

Line 181: , a3 out nocopy JTF_NUMBER_TABLE

177: end rosetta_table_copy_in_p6;
178: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
179: , a1 out nocopy JTF_DATE_TABLE
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE
183: ) as
184: ddindx binary_integer; indx binary_integer;
185: begin

Line 182: , a4 out nocopy JTF_NUMBER_TABLE

178: procedure rosetta_table_copy_out_p6(t ozf_mass_settlement_pvt.claim_payment_method_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
179: , a1 out nocopy JTF_DATE_TABLE
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE
183: ) as
184: ddindx binary_integer; indx binary_integer;
185: begin
186: if t is null or t.count = 0 then

Line 189: a2 := JTF_NUMBER_TABLE();

185: begin
186: if t is null or t.count = 0 then
187: a0 := JTF_VARCHAR2_TABLE_100();
188: a1 := JTF_DATE_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_NUMBER_TABLE();
192: else
193: a0 := JTF_VARCHAR2_TABLE_100();

Line 190: a3 := JTF_NUMBER_TABLE();

186: if t is null or t.count = 0 then
187: a0 := JTF_VARCHAR2_TABLE_100();
188: a1 := JTF_DATE_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_NUMBER_TABLE();
192: else
193: a0 := JTF_VARCHAR2_TABLE_100();
194: a1 := JTF_DATE_TABLE();

Line 191: a4 := JTF_NUMBER_TABLE();

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

Line 195: a2 := JTF_NUMBER_TABLE();

191: a4 := JTF_NUMBER_TABLE();
192: else
193: a0 := JTF_VARCHAR2_TABLE_100();
194: a1 := JTF_DATE_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_NUMBER_TABLE();
197: a4 := JTF_NUMBER_TABLE();
198: if t.count > 0 then
199: a0.extend(t.count);

Line 196: a3 := JTF_NUMBER_TABLE();

192: else
193: a0 := JTF_VARCHAR2_TABLE_100();
194: a1 := JTF_DATE_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_NUMBER_TABLE();
197: a4 := JTF_NUMBER_TABLE();
198: if t.count > 0 then
199: a0.extend(t.count);
200: a1.extend(t.count);

Line 197: a4 := JTF_NUMBER_TABLE();

193: a0 := JTF_VARCHAR2_TABLE_100();
194: a1 := JTF_DATE_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_NUMBER_TABLE();
197: a4 := JTF_NUMBER_TABLE();
198: if t.count > 0 then
199: a0.extend(t.count);
200: a1.extend(t.count);
201: a2.extend(t.count);

Line 239: , p8_a0 JTF_NUMBER_TABLE

235: , p7_a6 NUMBER
236: , p7_a7 VARCHAR2
237: , p7_a8 NUMBER
238: , p7_a9 NUMBER
239: , p8_a0 JTF_NUMBER_TABLE
240: , p8_a1 JTF_VARCHAR2_TABLE_100
241: , p8_a2 JTF_VARCHAR2_TABLE_100
242: , p8_a3 JTF_NUMBER_TABLE
243: , p9_a0 JTF_NUMBER_TABLE

Line 242: , p8_a3 JTF_NUMBER_TABLE

238: , p7_a9 NUMBER
239: , p8_a0 JTF_NUMBER_TABLE
240: , p8_a1 JTF_VARCHAR2_TABLE_100
241: , p8_a2 JTF_VARCHAR2_TABLE_100
242: , p8_a3 JTF_NUMBER_TABLE
243: , p9_a0 JTF_NUMBER_TABLE
244: , p9_a1 JTF_NUMBER_TABLE
245: , p9_a2 JTF_VARCHAR2_TABLE_100
246: , p9_a3 JTF_VARCHAR2_TABLE_100

Line 243: , p9_a0 JTF_NUMBER_TABLE

239: , p8_a0 JTF_NUMBER_TABLE
240: , p8_a1 JTF_VARCHAR2_TABLE_100
241: , p8_a2 JTF_VARCHAR2_TABLE_100
242: , p8_a3 JTF_NUMBER_TABLE
243: , p9_a0 JTF_NUMBER_TABLE
244: , p9_a1 JTF_NUMBER_TABLE
245: , p9_a2 JTF_VARCHAR2_TABLE_100
246: , p9_a3 JTF_VARCHAR2_TABLE_100
247: , p9_a4 JTF_NUMBER_TABLE

Line 244: , p9_a1 JTF_NUMBER_TABLE

240: , p8_a1 JTF_VARCHAR2_TABLE_100
241: , p8_a2 JTF_VARCHAR2_TABLE_100
242: , p8_a3 JTF_NUMBER_TABLE
243: , p9_a0 JTF_NUMBER_TABLE
244: , p9_a1 JTF_NUMBER_TABLE
245: , p9_a2 JTF_VARCHAR2_TABLE_100
246: , p9_a3 JTF_VARCHAR2_TABLE_100
247: , p9_a4 JTF_NUMBER_TABLE
248: , p10_a0 JTF_VARCHAR2_TABLE_100

Line 247: , p9_a4 JTF_NUMBER_TABLE

243: , p9_a0 JTF_NUMBER_TABLE
244: , p9_a1 JTF_NUMBER_TABLE
245: , p9_a2 JTF_VARCHAR2_TABLE_100
246: , p9_a3 JTF_VARCHAR2_TABLE_100
247: , p9_a4 JTF_NUMBER_TABLE
248: , p10_a0 JTF_VARCHAR2_TABLE_100
249: , p10_a1 JTF_DATE_TABLE
250: , p10_a2 JTF_NUMBER_TABLE
251: , p10_a3 JTF_NUMBER_TABLE

Line 250: , p10_a2 JTF_NUMBER_TABLE

246: , p9_a3 JTF_VARCHAR2_TABLE_100
247: , p9_a4 JTF_NUMBER_TABLE
248: , p10_a0 JTF_VARCHAR2_TABLE_100
249: , p10_a1 JTF_DATE_TABLE
250: , p10_a2 JTF_NUMBER_TABLE
251: , p10_a3 JTF_NUMBER_TABLE
252: , p10_a4 JTF_NUMBER_TABLE
253: , x_claim_group_id out nocopy NUMBER
254: , x_claim_group_number out nocopy VARCHAR2

Line 251: , p10_a3 JTF_NUMBER_TABLE

247: , p9_a4 JTF_NUMBER_TABLE
248: , p10_a0 JTF_VARCHAR2_TABLE_100
249: , p10_a1 JTF_DATE_TABLE
250: , p10_a2 JTF_NUMBER_TABLE
251: , p10_a3 JTF_NUMBER_TABLE
252: , p10_a4 JTF_NUMBER_TABLE
253: , x_claim_group_id out nocopy NUMBER
254: , x_claim_group_number out nocopy VARCHAR2
255: )

Line 252: , p10_a4 JTF_NUMBER_TABLE

248: , p10_a0 JTF_VARCHAR2_TABLE_100
249: , p10_a1 JTF_DATE_TABLE
250: , p10_a2 JTF_NUMBER_TABLE
251: , p10_a3 JTF_NUMBER_TABLE
252: , p10_a4 JTF_NUMBER_TABLE
253: , x_claim_group_id out nocopy NUMBER
254: , x_claim_group_number out nocopy VARCHAR2
255: )
256: