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.CN_QUOTA_PAY_ELEMENTS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out cn_quota_pay_elements_pvt.quota_pay_element_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

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

Line 27: , a5 JTF_VARCHAR2_TABLE_100

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

Line 32: , a10 JTF_VARCHAR2_TABLE_100

28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_200
34: , a12 JTF_VARCHAR2_TABLE_200
35: , a13 JTF_VARCHAR2_TABLE_200
36: , a14 JTF_VARCHAR2_TABLE_200

Line 92: , a1 out JTF_VARCHAR2_TABLE_100

88: end if;
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t cn_quota_pay_elements_pvt.quota_pay_element_tbl_type, a0 out JTF_NUMBER_TABLE
92: , a1 out JTF_VARCHAR2_TABLE_100
93: , a2 out JTF_VARCHAR2_TABLE_100
94: , a3 out JTF_DATE_TABLE
95: , a4 out JTF_DATE_TABLE
96: , a5 out JTF_VARCHAR2_TABLE_100

Line 93: , a2 out JTF_VARCHAR2_TABLE_100

89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t cn_quota_pay_elements_pvt.quota_pay_element_tbl_type, a0 out JTF_NUMBER_TABLE
92: , a1 out JTF_VARCHAR2_TABLE_100
93: , a2 out JTF_VARCHAR2_TABLE_100
94: , a3 out JTF_DATE_TABLE
95: , a4 out JTF_DATE_TABLE
96: , a5 out JTF_VARCHAR2_TABLE_100
97: , a6 out JTF_NUMBER_TABLE

Line 96: , a5 out JTF_VARCHAR2_TABLE_100

92: , a1 out JTF_VARCHAR2_TABLE_100
93: , a2 out JTF_VARCHAR2_TABLE_100
94: , a3 out JTF_DATE_TABLE
95: , a4 out JTF_DATE_TABLE
96: , a5 out JTF_VARCHAR2_TABLE_100
97: , a6 out JTF_NUMBER_TABLE
98: , a7 out JTF_NUMBER_TABLE
99: , a8 out JTF_DATE_TABLE
100: , a9 out JTF_DATE_TABLE

Line 101: , a10 out JTF_VARCHAR2_TABLE_100

97: , a6 out JTF_NUMBER_TABLE
98: , a7 out JTF_NUMBER_TABLE
99: , a8 out JTF_DATE_TABLE
100: , a9 out JTF_DATE_TABLE
101: , a10 out JTF_VARCHAR2_TABLE_100
102: , a11 out JTF_VARCHAR2_TABLE_200
103: , a12 out JTF_VARCHAR2_TABLE_200
104: , a13 out JTF_VARCHAR2_TABLE_200
105: , a14 out JTF_VARCHAR2_TABLE_200

Line 122: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 123: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 126: a5 := JTF_VARCHAR2_TABLE_100();

122: a1 := JTF_VARCHAR2_TABLE_100();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_DATE_TABLE();
125: a4 := JTF_DATE_TABLE();
126: a5 := JTF_VARCHAR2_TABLE_100();
127: a6 := JTF_NUMBER_TABLE();
128: a7 := JTF_NUMBER_TABLE();
129: a8 := JTF_DATE_TABLE();
130: a9 := JTF_DATE_TABLE();

Line 131: a10 := JTF_VARCHAR2_TABLE_100();

127: a6 := JTF_NUMBER_TABLE();
128: a7 := JTF_NUMBER_TABLE();
129: a8 := JTF_DATE_TABLE();
130: a9 := JTF_DATE_TABLE();
131: a10 := JTF_VARCHAR2_TABLE_100();
132: a11 := JTF_VARCHAR2_TABLE_200();
133: a12 := JTF_VARCHAR2_TABLE_200();
134: a13 := JTF_VARCHAR2_TABLE_200();
135: a14 := JTF_VARCHAR2_TABLE_200();

Line 149: a1 := JTF_VARCHAR2_TABLE_100();

145: a24 := JTF_VARCHAR2_TABLE_200();
146: a25 := JTF_VARCHAR2_TABLE_200();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_VARCHAR2_TABLE_100();
150: a2 := JTF_VARCHAR2_TABLE_100();
151: a3 := JTF_DATE_TABLE();
152: a4 := JTF_DATE_TABLE();
153: a5 := JTF_VARCHAR2_TABLE_100();

Line 150: a2 := JTF_VARCHAR2_TABLE_100();

146: a25 := JTF_VARCHAR2_TABLE_200();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_VARCHAR2_TABLE_100();
150: a2 := JTF_VARCHAR2_TABLE_100();
151: a3 := JTF_DATE_TABLE();
152: a4 := JTF_DATE_TABLE();
153: a5 := JTF_VARCHAR2_TABLE_100();
154: a6 := JTF_NUMBER_TABLE();

Line 153: a5 := JTF_VARCHAR2_TABLE_100();

149: a1 := JTF_VARCHAR2_TABLE_100();
150: a2 := JTF_VARCHAR2_TABLE_100();
151: a3 := JTF_DATE_TABLE();
152: a4 := JTF_DATE_TABLE();
153: a5 := JTF_VARCHAR2_TABLE_100();
154: a6 := JTF_NUMBER_TABLE();
155: a7 := JTF_NUMBER_TABLE();
156: a8 := JTF_DATE_TABLE();
157: a9 := JTF_DATE_TABLE();

Line 158: a10 := JTF_VARCHAR2_TABLE_100();

154: a6 := JTF_NUMBER_TABLE();
155: a7 := JTF_NUMBER_TABLE();
156: a8 := JTF_DATE_TABLE();
157: a9 := JTF_DATE_TABLE();
158: a10 := JTF_VARCHAR2_TABLE_100();
159: a11 := JTF_VARCHAR2_TABLE_200();
160: a12 := JTF_VARCHAR2_TABLE_200();
161: a13 := JTF_VARCHAR2_TABLE_200();
162: a14 := JTF_VARCHAR2_TABLE_200();

Line 243: , a3 JTF_VARCHAR2_TABLE_100

239:
240: procedure rosetta_table_copy_in_p5(t out cn_quota_pay_elements_pvt.quota_pay_element_out_tbl_type, a0 JTF_NUMBER_TABLE
241: , a1 JTF_NUMBER_TABLE
242: , a2 JTF_NUMBER_TABLE
243: , a3 JTF_VARCHAR2_TABLE_100
244: , a4 JTF_DATE_TABLE
245: , a5 JTF_DATE_TABLE
246: , a6 JTF_VARCHAR2_TABLE_100
247: , a7 JTF_VARCHAR2_TABLE_100

Line 246: , a6 JTF_VARCHAR2_TABLE_100

242: , a2 JTF_NUMBER_TABLE
243: , a3 JTF_VARCHAR2_TABLE_100
244: , a4 JTF_DATE_TABLE
245: , a5 JTF_DATE_TABLE
246: , a6 JTF_VARCHAR2_TABLE_100
247: , a7 JTF_VARCHAR2_TABLE_100
248: , a8 JTF_DATE_TABLE
249: , a9 JTF_DATE_TABLE
250: ) as

Line 247: , a7 JTF_VARCHAR2_TABLE_100

243: , a3 JTF_VARCHAR2_TABLE_100
244: , a4 JTF_DATE_TABLE
245: , a5 JTF_DATE_TABLE
246: , a6 JTF_VARCHAR2_TABLE_100
247: , a7 JTF_VARCHAR2_TABLE_100
248: , a8 JTF_DATE_TABLE
249: , a9 JTF_DATE_TABLE
250: ) as
251: ddindx binary_integer; indx binary_integer;

Line 280: , a3 out JTF_VARCHAR2_TABLE_100

276: end rosetta_table_copy_in_p5;
277: procedure rosetta_table_copy_out_p5(t cn_quota_pay_elements_pvt.quota_pay_element_out_tbl_type, a0 out JTF_NUMBER_TABLE
278: , a1 out JTF_NUMBER_TABLE
279: , a2 out JTF_NUMBER_TABLE
280: , a3 out JTF_VARCHAR2_TABLE_100
281: , a4 out JTF_DATE_TABLE
282: , a5 out JTF_DATE_TABLE
283: , a6 out JTF_VARCHAR2_TABLE_100
284: , a7 out JTF_VARCHAR2_TABLE_100

Line 283: , a6 out JTF_VARCHAR2_TABLE_100

279: , a2 out JTF_NUMBER_TABLE
280: , a3 out JTF_VARCHAR2_TABLE_100
281: , a4 out JTF_DATE_TABLE
282: , a5 out JTF_DATE_TABLE
283: , a6 out JTF_VARCHAR2_TABLE_100
284: , a7 out JTF_VARCHAR2_TABLE_100
285: , a8 out JTF_DATE_TABLE
286: , a9 out JTF_DATE_TABLE
287: ) as

Line 284: , a7 out JTF_VARCHAR2_TABLE_100

280: , a3 out JTF_VARCHAR2_TABLE_100
281: , a4 out JTF_DATE_TABLE
282: , a5 out JTF_DATE_TABLE
283: , a6 out JTF_VARCHAR2_TABLE_100
284: , a7 out JTF_VARCHAR2_TABLE_100
285: , a8 out JTF_DATE_TABLE
286: , a9 out JTF_DATE_TABLE
287: ) as
288: ddindx binary_integer; indx binary_integer;

Line 294: a3 := JTF_VARCHAR2_TABLE_100();

290: if t is null or t.count = 0 then
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
293: a2 := JTF_NUMBER_TABLE();
294: a3 := JTF_VARCHAR2_TABLE_100();
295: a4 := JTF_DATE_TABLE();
296: a5 := JTF_DATE_TABLE();
297: a6 := JTF_VARCHAR2_TABLE_100();
298: a7 := JTF_VARCHAR2_TABLE_100();

Line 297: a6 := JTF_VARCHAR2_TABLE_100();

293: a2 := JTF_NUMBER_TABLE();
294: a3 := JTF_VARCHAR2_TABLE_100();
295: a4 := JTF_DATE_TABLE();
296: a5 := JTF_DATE_TABLE();
297: a6 := JTF_VARCHAR2_TABLE_100();
298: a7 := JTF_VARCHAR2_TABLE_100();
299: a8 := JTF_DATE_TABLE();
300: a9 := JTF_DATE_TABLE();
301: else

Line 298: a7 := JTF_VARCHAR2_TABLE_100();

294: a3 := JTF_VARCHAR2_TABLE_100();
295: a4 := JTF_DATE_TABLE();
296: a5 := JTF_DATE_TABLE();
297: a6 := JTF_VARCHAR2_TABLE_100();
298: a7 := JTF_VARCHAR2_TABLE_100();
299: a8 := JTF_DATE_TABLE();
300: a9 := JTF_DATE_TABLE();
301: else
302: a0 := JTF_NUMBER_TABLE();

Line 305: a3 := JTF_VARCHAR2_TABLE_100();

301: else
302: a0 := JTF_NUMBER_TABLE();
303: a1 := JTF_NUMBER_TABLE();
304: a2 := JTF_NUMBER_TABLE();
305: a3 := JTF_VARCHAR2_TABLE_100();
306: a4 := JTF_DATE_TABLE();
307: a5 := JTF_DATE_TABLE();
308: a6 := JTF_VARCHAR2_TABLE_100();
309: a7 := JTF_VARCHAR2_TABLE_100();

Line 308: a6 := JTF_VARCHAR2_TABLE_100();

304: a2 := JTF_NUMBER_TABLE();
305: a3 := JTF_VARCHAR2_TABLE_100();
306: a4 := JTF_DATE_TABLE();
307: a5 := JTF_DATE_TABLE();
308: a6 := JTF_VARCHAR2_TABLE_100();
309: a7 := JTF_VARCHAR2_TABLE_100();
310: a8 := JTF_DATE_TABLE();
311: a9 := JTF_DATE_TABLE();
312: if t.count > 0 then

Line 309: a7 := JTF_VARCHAR2_TABLE_100();

305: a3 := JTF_VARCHAR2_TABLE_100();
306: a4 := JTF_DATE_TABLE();
307: a5 := JTF_DATE_TABLE();
308: a6 := JTF_VARCHAR2_TABLE_100();
309: a7 := JTF_VARCHAR2_TABLE_100();
310: a8 := JTF_DATE_TABLE();
311: a9 := JTF_DATE_TABLE();
312: if t.count > 0 then
313: a0.extend(t.count);

Line 617: , p12_a3 out JTF_VARCHAR2_TABLE_100

613: , p_order_by VARCHAR2
614: , p12_a0 out JTF_NUMBER_TABLE
615: , p12_a1 out JTF_NUMBER_TABLE
616: , p12_a2 out JTF_NUMBER_TABLE
617: , p12_a3 out JTF_VARCHAR2_TABLE_100
618: , p12_a4 out JTF_DATE_TABLE
619: , p12_a5 out JTF_DATE_TABLE
620: , p12_a6 out JTF_VARCHAR2_TABLE_100
621: , p12_a7 out JTF_VARCHAR2_TABLE_100

Line 620: , p12_a6 out JTF_VARCHAR2_TABLE_100

616: , p12_a2 out JTF_NUMBER_TABLE
617: , p12_a3 out JTF_VARCHAR2_TABLE_100
618: , p12_a4 out JTF_DATE_TABLE
619: , p12_a5 out JTF_DATE_TABLE
620: , p12_a6 out JTF_VARCHAR2_TABLE_100
621: , p12_a7 out JTF_VARCHAR2_TABLE_100
622: , p12_a8 out JTF_DATE_TABLE
623: , p12_a9 out JTF_DATE_TABLE
624: , x_total_records out NUMBER

Line 621: , p12_a7 out JTF_VARCHAR2_TABLE_100

617: , p12_a3 out JTF_VARCHAR2_TABLE_100
618: , p12_a4 out JTF_DATE_TABLE
619: , p12_a5 out JTF_DATE_TABLE
620: , p12_a6 out JTF_VARCHAR2_TABLE_100
621: , p12_a7 out JTF_VARCHAR2_TABLE_100
622: , p12_a8 out JTF_DATE_TABLE
623: , p12_a9 out JTF_DATE_TABLE
624: , x_total_records out NUMBER
625: , x_status out VARCHAR2