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_GET_COMM_SUMM_DATA_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out cn_get_comm_summ_data.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_VARCHAR2_TABLE_100

21:
22: procedure rosetta_table_copy_in_p1(t out cn_get_comm_summ_data.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p1(t out cn_get_comm_summ_data.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE

Line 28: , a6 JTF_VARCHAR2_TABLE_100

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

Line 29: , a7 JTF_VARCHAR2_TABLE_100

25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as

Line 63: , a2 out JTF_VARCHAR2_TABLE_100

59: end if;
60: end rosetta_table_copy_in_p1;
61: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data.comm_summ_tbl_type, a0 out JTF_NUMBER_TABLE
62: , a1 out JTF_VARCHAR2_TABLE_300
63: , a2 out JTF_VARCHAR2_TABLE_100
64: , a3 out JTF_VARCHAR2_TABLE_100
65: , a4 out JTF_VARCHAR2_TABLE_100
66: , a5 out JTF_VARCHAR2_TABLE_300
67: , a6 out JTF_VARCHAR2_TABLE_100

Line 64: , a3 out JTF_VARCHAR2_TABLE_100

60: end rosetta_table_copy_in_p1;
61: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data.comm_summ_tbl_type, a0 out JTF_NUMBER_TABLE
62: , a1 out JTF_VARCHAR2_TABLE_300
63: , a2 out JTF_VARCHAR2_TABLE_100
64: , a3 out JTF_VARCHAR2_TABLE_100
65: , a4 out JTF_VARCHAR2_TABLE_100
66: , a5 out JTF_VARCHAR2_TABLE_300
67: , a6 out JTF_VARCHAR2_TABLE_100
68: , a7 out JTF_VARCHAR2_TABLE_100

Line 65: , a4 out JTF_VARCHAR2_TABLE_100

61: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data.comm_summ_tbl_type, a0 out JTF_NUMBER_TABLE
62: , a1 out JTF_VARCHAR2_TABLE_300
63: , a2 out JTF_VARCHAR2_TABLE_100
64: , a3 out JTF_VARCHAR2_TABLE_100
65: , a4 out JTF_VARCHAR2_TABLE_100
66: , a5 out JTF_VARCHAR2_TABLE_300
67: , a6 out JTF_VARCHAR2_TABLE_100
68: , a7 out JTF_VARCHAR2_TABLE_100
69: , a8 out JTF_NUMBER_TABLE

Line 67: , a6 out JTF_VARCHAR2_TABLE_100

63: , a2 out JTF_VARCHAR2_TABLE_100
64: , a3 out JTF_VARCHAR2_TABLE_100
65: , a4 out JTF_VARCHAR2_TABLE_100
66: , a5 out JTF_VARCHAR2_TABLE_300
67: , a6 out JTF_VARCHAR2_TABLE_100
68: , a7 out JTF_VARCHAR2_TABLE_100
69: , a8 out JTF_NUMBER_TABLE
70: , a9 out JTF_NUMBER_TABLE
71: , a10 out JTF_NUMBER_TABLE

Line 68: , a7 out JTF_VARCHAR2_TABLE_100

64: , a3 out JTF_VARCHAR2_TABLE_100
65: , a4 out JTF_VARCHAR2_TABLE_100
66: , a5 out JTF_VARCHAR2_TABLE_300
67: , a6 out JTF_VARCHAR2_TABLE_100
68: , a7 out JTF_VARCHAR2_TABLE_100
69: , a8 out JTF_NUMBER_TABLE
70: , a9 out JTF_NUMBER_TABLE
71: , a10 out JTF_NUMBER_TABLE
72: ) as

Line 78: a2 := JTF_VARCHAR2_TABLE_100();

74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_300();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_300();
82: a6 := JTF_VARCHAR2_TABLE_100();

Line 79: a3 := JTF_VARCHAR2_TABLE_100();

75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_300();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_300();
82: a6 := JTF_VARCHAR2_TABLE_100();
83: a7 := JTF_VARCHAR2_TABLE_100();

Line 80: a4 := JTF_VARCHAR2_TABLE_100();

76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_300();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_300();
82: a6 := JTF_VARCHAR2_TABLE_100();
83: a7 := JTF_VARCHAR2_TABLE_100();
84: a8 := JTF_NUMBER_TABLE();

Line 82: a6 := JTF_VARCHAR2_TABLE_100();

78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_300();
82: a6 := JTF_VARCHAR2_TABLE_100();
83: a7 := JTF_VARCHAR2_TABLE_100();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();

Line 83: a7 := JTF_VARCHAR2_TABLE_100();

79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_VARCHAR2_TABLE_300();
82: a6 := JTF_VARCHAR2_TABLE_100();
83: a7 := JTF_VARCHAR2_TABLE_100();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_NUMBER_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else

Line 90: a2 := JTF_VARCHAR2_TABLE_100();

86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_300();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_VARCHAR2_TABLE_300();
94: a6 := JTF_VARCHAR2_TABLE_100();

Line 91: a3 := JTF_VARCHAR2_TABLE_100();

87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_300();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_VARCHAR2_TABLE_300();
94: a6 := JTF_VARCHAR2_TABLE_100();
95: a7 := JTF_VARCHAR2_TABLE_100();

Line 92: a4 := JTF_VARCHAR2_TABLE_100();

88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_300();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_VARCHAR2_TABLE_300();
94: a6 := JTF_VARCHAR2_TABLE_100();
95: a7 := JTF_VARCHAR2_TABLE_100();
96: a8 := JTF_NUMBER_TABLE();

Line 94: a6 := JTF_VARCHAR2_TABLE_100();

90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_VARCHAR2_TABLE_300();
94: a6 := JTF_VARCHAR2_TABLE_100();
95: a7 := JTF_VARCHAR2_TABLE_100();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();

Line 95: a7 := JTF_VARCHAR2_TABLE_100();

91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_VARCHAR2_TABLE_300();
94: a6 := JTF_VARCHAR2_TABLE_100();
95: a7 := JTF_VARCHAR2_TABLE_100();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then

Line 135: procedure rosetta_table_copy_in_p3(t out cn_get_comm_summ_data.pe_info_tbl_type, a0 JTF_VARCHAR2_TABLE_100

131: end if;
132: end if;
133: end rosetta_table_copy_out_p1;
134:
135: procedure rosetta_table_copy_in_p3(t out cn_get_comm_summ_data.pe_info_tbl_type, a0 JTF_VARCHAR2_TABLE_100
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_NUMBER_TABLE
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_NUMBER_TABLE

Line 164: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data.pe_info_tbl_type, a0 out JTF_VARCHAR2_TABLE_100

160: end loop;
161: end if;
162: end if;
163: end rosetta_table_copy_in_p3;
164: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data.pe_info_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
165: , a1 out JTF_NUMBER_TABLE
166: , a2 out JTF_NUMBER_TABLE
167: , a3 out JTF_NUMBER_TABLE
168: , a4 out JTF_NUMBER_TABLE

Line 174: a0 := JTF_VARCHAR2_TABLE_100();

170: ) as
171: ddindx binary_integer; indx binary_integer;
172: begin
173: if t is null or t.count = 0 then
174: a0 := JTF_VARCHAR2_TABLE_100();
175: a1 := JTF_NUMBER_TABLE();
176: a2 := JTF_NUMBER_TABLE();
177: a3 := JTF_NUMBER_TABLE();
178: a4 := JTF_NUMBER_TABLE();

Line 181: a0 := JTF_VARCHAR2_TABLE_100();

177: a3 := JTF_NUMBER_TABLE();
178: a4 := JTF_NUMBER_TABLE();
179: a5 := JTF_NUMBER_TABLE();
180: else
181: a0 := JTF_VARCHAR2_TABLE_100();
182: a1 := JTF_NUMBER_TABLE();
183: a2 := JTF_NUMBER_TABLE();
184: a3 := JTF_NUMBER_TABLE();
185: a4 := JTF_NUMBER_TABLE();

Line 221: , p6_a2 out JTF_VARCHAR2_TABLE_100

217: , p_credit_type_id NUMBER
218: , x_total_rows out NUMBER
219: , p6_a0 out JTF_NUMBER_TABLE
220: , p6_a1 out JTF_VARCHAR2_TABLE_300
221: , p6_a2 out JTF_VARCHAR2_TABLE_100
222: , p6_a3 out JTF_VARCHAR2_TABLE_100
223: , p6_a4 out JTF_VARCHAR2_TABLE_100
224: , p6_a5 out JTF_VARCHAR2_TABLE_300
225: , p6_a6 out JTF_VARCHAR2_TABLE_100

Line 222: , p6_a3 out JTF_VARCHAR2_TABLE_100

218: , x_total_rows out NUMBER
219: , p6_a0 out JTF_NUMBER_TABLE
220: , p6_a1 out JTF_VARCHAR2_TABLE_300
221: , p6_a2 out JTF_VARCHAR2_TABLE_100
222: , p6_a3 out JTF_VARCHAR2_TABLE_100
223: , p6_a4 out JTF_VARCHAR2_TABLE_100
224: , p6_a5 out JTF_VARCHAR2_TABLE_300
225: , p6_a6 out JTF_VARCHAR2_TABLE_100
226: , p6_a7 out JTF_VARCHAR2_TABLE_100

Line 223: , p6_a4 out JTF_VARCHAR2_TABLE_100

219: , p6_a0 out JTF_NUMBER_TABLE
220: , p6_a1 out JTF_VARCHAR2_TABLE_300
221: , p6_a2 out JTF_VARCHAR2_TABLE_100
222: , p6_a3 out JTF_VARCHAR2_TABLE_100
223: , p6_a4 out JTF_VARCHAR2_TABLE_100
224: , p6_a5 out JTF_VARCHAR2_TABLE_300
225: , p6_a6 out JTF_VARCHAR2_TABLE_100
226: , p6_a7 out JTF_VARCHAR2_TABLE_100
227: , p6_a8 out JTF_NUMBER_TABLE

Line 225: , p6_a6 out JTF_VARCHAR2_TABLE_100

221: , p6_a2 out JTF_VARCHAR2_TABLE_100
222: , p6_a3 out JTF_VARCHAR2_TABLE_100
223: , p6_a4 out JTF_VARCHAR2_TABLE_100
224: , p6_a5 out JTF_VARCHAR2_TABLE_300
225: , p6_a6 out JTF_VARCHAR2_TABLE_100
226: , p6_a7 out JTF_VARCHAR2_TABLE_100
227: , p6_a8 out JTF_NUMBER_TABLE
228: , p6_a9 out JTF_NUMBER_TABLE
229: , p6_a10 out JTF_NUMBER_TABLE

Line 226: , p6_a7 out JTF_VARCHAR2_TABLE_100

222: , p6_a3 out JTF_VARCHAR2_TABLE_100
223: , p6_a4 out JTF_VARCHAR2_TABLE_100
224: , p6_a5 out JTF_VARCHAR2_TABLE_300
225: , p6_a6 out JTF_VARCHAR2_TABLE_100
226: , p6_a7 out JTF_VARCHAR2_TABLE_100
227: , p6_a8 out JTF_NUMBER_TABLE
228: , p6_a9 out JTF_NUMBER_TABLE
229: , p6_a10 out JTF_NUMBER_TABLE
230: )

Line 277: , p3_a0 out JTF_VARCHAR2_TABLE_100

273:
274: procedure get_pe_info(p_srp_plan_assign_id NUMBER
275: , p_period_id NUMBER
276: , p_credit_type_id NUMBER
277: , p3_a0 out JTF_VARCHAR2_TABLE_100
278: , p3_a1 out JTF_NUMBER_TABLE
279: , p3_a2 out JTF_NUMBER_TABLE
280: , p3_a3 out JTF_NUMBER_TABLE
281: , p3_a4 out JTF_NUMBER_TABLE

Line 283: , p4_a0 out JTF_VARCHAR2_TABLE_100

279: , p3_a2 out JTF_NUMBER_TABLE
280: , p3_a3 out JTF_NUMBER_TABLE
281: , p3_a4 out JTF_NUMBER_TABLE
282: , p3_a5 out JTF_NUMBER_TABLE
283: , p4_a0 out JTF_VARCHAR2_TABLE_100
284: , p4_a1 out JTF_NUMBER_TABLE
285: , p4_a2 out JTF_NUMBER_TABLE
286: , p4_a3 out JTF_NUMBER_TABLE
287: , p4_a4 out JTF_NUMBER_TABLE

Line 338: procedure get_group_codes(p0_a0 out JTF_VARCHAR2_TABLE_100

334:
335:
336: end;
337:
338: procedure get_group_codes(p0_a0 out JTF_VARCHAR2_TABLE_100
339: , p0_a1 out JTF_NUMBER_TABLE
340: , p0_a2 out JTF_NUMBER_TABLE
341: , p0_a3 out JTF_NUMBER_TABLE
342: , p0_a4 out JTF_NUMBER_TABLE