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

Line 22: procedure rosetta_table_copy_in_p3(t out nocopy okl_la_payments_pvt.pym_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 okl_la_payments_pvt.pym_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_500
24: , a2 JTF_VARCHAR2_TABLE_500
25: , a3 JTF_VARCHAR2_TABLE_500
26: , a4 JTF_VARCHAR2_TABLE_500

Line 53: procedure rosetta_table_copy_out_p3(t okl_la_payments_pvt.pym_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

49: end loop;
50: end if;
51: end if;
52: end rosetta_table_copy_in_p3;
53: procedure rosetta_table_copy_out_p3(t okl_la_payments_pvt.pym_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_VARCHAR2_TABLE_500
55: , a2 out nocopy JTF_VARCHAR2_TABLE_500
56: , a3 out nocopy JTF_VARCHAR2_TABLE_500
57: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 64: a0 := JTF_NUMBER_TABLE();

60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_500();
66: a2 := JTF_VARCHAR2_TABLE_500();
67: a3 := JTF_VARCHAR2_TABLE_500();
68: a4 := JTF_VARCHAR2_TABLE_500();

Line 72: a0 := JTF_NUMBER_TABLE();

68: a4 := JTF_VARCHAR2_TABLE_500();
69: a5 := JTF_VARCHAR2_TABLE_500();
70: a6 := JTF_VARCHAR2_TABLE_100();
71: else
72: a0 := JTF_NUMBER_TABLE();
73: a1 := JTF_VARCHAR2_TABLE_500();
74: a2 := JTF_VARCHAR2_TABLE_500();
75: a3 := JTF_VARCHAR2_TABLE_500();
76: a4 := JTF_VARCHAR2_TABLE_500();

Line 107: procedure rosetta_table_copy_in_p4(t out nocopy okl_la_payments_pvt.pym_del_tbl_type, a0 JTF_NUMBER_TABLE

103: end if;
104: end if;
105: end rosetta_table_copy_out_p3;
106:
107: procedure rosetta_table_copy_in_p4(t out nocopy okl_la_payments_pvt.pym_del_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_NUMBER_TABLE
110: ) as
111: ddindx binary_integer; indx binary_integer;

Line 108: , a1 JTF_NUMBER_TABLE

104: end if;
105: end rosetta_table_copy_out_p3;
106:
107: procedure rosetta_table_copy_in_p4(t out nocopy okl_la_payments_pvt.pym_del_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_NUMBER_TABLE
110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin

Line 109: , a2 JTF_NUMBER_TABLE

105: end rosetta_table_copy_out_p3;
106:
107: procedure rosetta_table_copy_in_p4(t out nocopy okl_la_payments_pvt.pym_del_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_NUMBER_TABLE
110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin
113: if a0 is not null and a0.count > 0 then

Line 130: procedure rosetta_table_copy_out_p4(t okl_la_payments_pvt.pym_del_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

126: end loop;
127: end if;
128: end if;
129: end rosetta_table_copy_in_p4;
130: procedure rosetta_table_copy_out_p4(t okl_la_payments_pvt.pym_del_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
131: , a1 out nocopy JTF_NUMBER_TABLE
132: , a2 out nocopy JTF_NUMBER_TABLE
133: ) as
134: ddindx binary_integer; indx binary_integer;

Line 131: , a1 out nocopy JTF_NUMBER_TABLE

127: end if;
128: end if;
129: end rosetta_table_copy_in_p4;
130: procedure rosetta_table_copy_out_p4(t okl_la_payments_pvt.pym_del_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
131: , a1 out nocopy JTF_NUMBER_TABLE
132: , a2 out nocopy JTF_NUMBER_TABLE
133: ) as
134: ddindx binary_integer; indx binary_integer;
135: begin

Line 132: , a2 out nocopy JTF_NUMBER_TABLE

128: end if;
129: end rosetta_table_copy_in_p4;
130: procedure rosetta_table_copy_out_p4(t okl_la_payments_pvt.pym_del_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
131: , a1 out nocopy JTF_NUMBER_TABLE
132: , a2 out nocopy JTF_NUMBER_TABLE
133: ) as
134: ddindx binary_integer; indx binary_integer;
135: begin
136: if t is null or t.count = 0 then

Line 137: a0 := JTF_NUMBER_TABLE();

133: ) as
134: ddindx binary_integer; indx binary_integer;
135: begin
136: if t is null or t.count = 0 then
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();

Line 138: a1 := JTF_NUMBER_TABLE();

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

Line 139: a2 := JTF_NUMBER_TABLE();

135: begin
136: if t is null or t.count = 0 then
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();

Line 141: a0 := JTF_NUMBER_TABLE();

137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: if t.count > 0 then
145: a0.extend(t.count);

Line 142: a1 := JTF_NUMBER_TABLE();

138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: if t.count > 0 then
145: a0.extend(t.count);
146: a1.extend(t.count);

Line 143: a2 := JTF_NUMBER_TABLE();

139: a2 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
144: if t.count > 0 then
145: a0.extend(t.count);
146: a1.extend(t.count);
147: a2.extend(t.count);

Line 173: , p10_a0 JTF_NUMBER_TABLE

169: , p_chr_id NUMBER
170: , p_service_fee_id NUMBER
171: , p_asset_id NUMBER
172: , p_payment_id NUMBER
173: , p10_a0 JTF_NUMBER_TABLE
174: , p10_a1 JTF_VARCHAR2_TABLE_500
175: , p10_a2 JTF_VARCHAR2_TABLE_500
176: , p10_a3 JTF_VARCHAR2_TABLE_500
177: , p10_a4 JTF_VARCHAR2_TABLE_500

Line 181: , p12_a0 out nocopy JTF_NUMBER_TABLE

177: , p10_a4 JTF_VARCHAR2_TABLE_500
178: , p10_a5 JTF_VARCHAR2_TABLE_500
179: , p10_a6 JTF_VARCHAR2_TABLE_100
180: , p_update_type VARCHAR2
181: , p12_a0 out nocopy JTF_NUMBER_TABLE
182: , p12_a1 out nocopy JTF_NUMBER_TABLE
183: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
184: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
185: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 182: , p12_a1 out nocopy JTF_NUMBER_TABLE

178: , p10_a5 JTF_VARCHAR2_TABLE_500
179: , p10_a6 JTF_VARCHAR2_TABLE_100
180: , p_update_type VARCHAR2
181: , p12_a0 out nocopy JTF_NUMBER_TABLE
182: , p12_a1 out nocopy JTF_NUMBER_TABLE
183: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
184: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
185: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 193: , p12_a12 out nocopy JTF_NUMBER_TABLE

189: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_200
190: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
191: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
192: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
193: , p12_a12 out nocopy JTF_NUMBER_TABLE
194: , p12_a13 out nocopy JTF_NUMBER_TABLE
195: , p12_a14 out nocopy JTF_NUMBER_TABLE
196: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
197: , p12_a16 out nocopy JTF_VARCHAR2_TABLE_2000

Line 194: , p12_a13 out nocopy JTF_NUMBER_TABLE

190: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
191: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
192: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
193: , p12_a12 out nocopy JTF_NUMBER_TABLE
194: , p12_a13 out nocopy JTF_NUMBER_TABLE
195: , p12_a14 out nocopy JTF_NUMBER_TABLE
196: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
197: , p12_a16 out nocopy JTF_VARCHAR2_TABLE_2000
198: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 195: , p12_a14 out nocopy JTF_NUMBER_TABLE

191: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
192: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
193: , p12_a12 out nocopy JTF_NUMBER_TABLE
194: , p12_a13 out nocopy JTF_NUMBER_TABLE
195: , p12_a14 out nocopy JTF_NUMBER_TABLE
196: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
197: , p12_a16 out nocopy JTF_VARCHAR2_TABLE_2000
198: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
199: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 215: , p12_a34 out nocopy JTF_NUMBER_TABLE

211: , p12_a30 out nocopy JTF_VARCHAR2_TABLE_500
212: , p12_a31 out nocopy JTF_VARCHAR2_TABLE_500
213: , p12_a32 out nocopy JTF_VARCHAR2_TABLE_500
214: , p12_a33 out nocopy JTF_VARCHAR2_TABLE_500
215: , p12_a34 out nocopy JTF_NUMBER_TABLE
216: , p12_a35 out nocopy JTF_DATE_TABLE
217: , p12_a36 out nocopy JTF_NUMBER_TABLE
218: , p12_a37 out nocopy JTF_DATE_TABLE
219: , p12_a38 out nocopy JTF_NUMBER_TABLE

Line 217: , p12_a36 out nocopy JTF_NUMBER_TABLE

213: , p12_a32 out nocopy JTF_VARCHAR2_TABLE_500
214: , p12_a33 out nocopy JTF_VARCHAR2_TABLE_500
215: , p12_a34 out nocopy JTF_NUMBER_TABLE
216: , p12_a35 out nocopy JTF_DATE_TABLE
217: , p12_a36 out nocopy JTF_NUMBER_TABLE
218: , p12_a37 out nocopy JTF_DATE_TABLE
219: , p12_a38 out nocopy JTF_NUMBER_TABLE
220: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
221: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_500

Line 219: , p12_a38 out nocopy JTF_NUMBER_TABLE

215: , p12_a34 out nocopy JTF_NUMBER_TABLE
216: , p12_a35 out nocopy JTF_DATE_TABLE
217: , p12_a36 out nocopy JTF_NUMBER_TABLE
218: , p12_a37 out nocopy JTF_DATE_TABLE
219: , p12_a38 out nocopy JTF_NUMBER_TABLE
220: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
221: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_500
222: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_500
223: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_500

Line 240: , p12_a59 out nocopy JTF_NUMBER_TABLE

236: , p12_a55 out nocopy JTF_VARCHAR2_TABLE_100
237: , p12_a56 out nocopy JTF_VARCHAR2_TABLE_100
238: , p12_a57 out nocopy JTF_VARCHAR2_TABLE_100
239: , p12_a58 out nocopy JTF_VARCHAR2_TABLE_100
240: , p12_a59 out nocopy JTF_NUMBER_TABLE
241: , p9_a0 VARCHAR2 := fnd_api.g_miss_char
242: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
243: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
244: , p9_a3 VARCHAR2 := fnd_api.g_miss_char

Line 385: , p10_a0 out nocopy JTF_NUMBER_TABLE

381: , p_service_fee_id NUMBER
382: , p_asset_id NUMBER
383: , p_payment_id NUMBER
384: , p_update_type VARCHAR2
385: , p10_a0 out nocopy JTF_NUMBER_TABLE
386: , p10_a1 out nocopy JTF_NUMBER_TABLE
387: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
388: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
389: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 386: , p10_a1 out nocopy JTF_NUMBER_TABLE

382: , p_asset_id NUMBER
383: , p_payment_id NUMBER
384: , p_update_type VARCHAR2
385: , p10_a0 out nocopy JTF_NUMBER_TABLE
386: , p10_a1 out nocopy JTF_NUMBER_TABLE
387: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
388: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
389: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
390: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 397: , p10_a12 out nocopy JTF_NUMBER_TABLE

393: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_200
394: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
395: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
396: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
397: , p10_a12 out nocopy JTF_NUMBER_TABLE
398: , p10_a13 out nocopy JTF_NUMBER_TABLE
399: , p10_a14 out nocopy JTF_NUMBER_TABLE
400: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_100
401: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_2000

Line 398: , p10_a13 out nocopy JTF_NUMBER_TABLE

394: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
395: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
396: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
397: , p10_a12 out nocopy JTF_NUMBER_TABLE
398: , p10_a13 out nocopy JTF_NUMBER_TABLE
399: , p10_a14 out nocopy JTF_NUMBER_TABLE
400: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_100
401: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_2000
402: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 399: , p10_a14 out nocopy JTF_NUMBER_TABLE

395: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
396: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
397: , p10_a12 out nocopy JTF_NUMBER_TABLE
398: , p10_a13 out nocopy JTF_NUMBER_TABLE
399: , p10_a14 out nocopy JTF_NUMBER_TABLE
400: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_100
401: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_2000
402: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
403: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 419: , p10_a34 out nocopy JTF_NUMBER_TABLE

415: , p10_a30 out nocopy JTF_VARCHAR2_TABLE_500
416: , p10_a31 out nocopy JTF_VARCHAR2_TABLE_500
417: , p10_a32 out nocopy JTF_VARCHAR2_TABLE_500
418: , p10_a33 out nocopy JTF_VARCHAR2_TABLE_500
419: , p10_a34 out nocopy JTF_NUMBER_TABLE
420: , p10_a35 out nocopy JTF_DATE_TABLE
421: , p10_a36 out nocopy JTF_NUMBER_TABLE
422: , p10_a37 out nocopy JTF_DATE_TABLE
423: , p10_a38 out nocopy JTF_NUMBER_TABLE

Line 421: , p10_a36 out nocopy JTF_NUMBER_TABLE

417: , p10_a32 out nocopy JTF_VARCHAR2_TABLE_500
418: , p10_a33 out nocopy JTF_VARCHAR2_TABLE_500
419: , p10_a34 out nocopy JTF_NUMBER_TABLE
420: , p10_a35 out nocopy JTF_DATE_TABLE
421: , p10_a36 out nocopy JTF_NUMBER_TABLE
422: , p10_a37 out nocopy JTF_DATE_TABLE
423: , p10_a38 out nocopy JTF_NUMBER_TABLE
424: , p10_a39 out nocopy JTF_VARCHAR2_TABLE_100
425: , p10_a40 out nocopy JTF_VARCHAR2_TABLE_500

Line 423: , p10_a38 out nocopy JTF_NUMBER_TABLE

419: , p10_a34 out nocopy JTF_NUMBER_TABLE
420: , p10_a35 out nocopy JTF_DATE_TABLE
421: , p10_a36 out nocopy JTF_NUMBER_TABLE
422: , p10_a37 out nocopy JTF_DATE_TABLE
423: , p10_a38 out nocopy JTF_NUMBER_TABLE
424: , p10_a39 out nocopy JTF_VARCHAR2_TABLE_100
425: , p10_a40 out nocopy JTF_VARCHAR2_TABLE_500
426: , p10_a41 out nocopy JTF_VARCHAR2_TABLE_500
427: , p10_a42 out nocopy JTF_VARCHAR2_TABLE_500

Line 444: , p10_a59 out nocopy JTF_NUMBER_TABLE

440: , p10_a55 out nocopy JTF_VARCHAR2_TABLE_100
441: , p10_a56 out nocopy JTF_VARCHAR2_TABLE_100
442: , p10_a57 out nocopy JTF_VARCHAR2_TABLE_100
443: , p10_a58 out nocopy JTF_VARCHAR2_TABLE_100
444: , p10_a59 out nocopy JTF_NUMBER_TABLE
445: )
446:
447: as
448: ddx_rulv_tbl okl_la_payments_pvt.rulv_tbl_type;

Line 556: , p5_a0 JTF_NUMBER_TABLE

552: , p_init_msg_list VARCHAR2
553: , x_return_status out nocopy VARCHAR2
554: , x_msg_count out nocopy NUMBER
555: , x_msg_data out nocopy VARCHAR2
556: , p5_a0 JTF_NUMBER_TABLE
557: , p5_a1 JTF_NUMBER_TABLE
558: , p5_a2 JTF_NUMBER_TABLE
559: )
560:

Line 557: , p5_a1 JTF_NUMBER_TABLE

553: , x_return_status out nocopy VARCHAR2
554: , x_msg_count out nocopy NUMBER
555: , x_msg_data out nocopy VARCHAR2
556: , p5_a0 JTF_NUMBER_TABLE
557: , p5_a1 JTF_NUMBER_TABLE
558: , p5_a2 JTF_NUMBER_TABLE
559: )
560:
561: as

Line 558: , p5_a2 JTF_NUMBER_TABLE

554: , x_msg_count out nocopy NUMBER
555: , x_msg_data out nocopy VARCHAR2
556: , p5_a0 JTF_NUMBER_TABLE
557: , p5_a1 JTF_NUMBER_TABLE
558: , p5_a2 JTF_NUMBER_TABLE
559: )
560:
561: as
562: ddp_del_pym_tbl okl_la_payments_pvt.pym_del_tbl_type;