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_SRP_DATA_PVT_W dependencies on JTF_VARCHAR2_TABLE_400

Line 14: , a1 JTF_VARCHAR2_TABLE_400

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_srp_data_pvt.srp_data_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_400
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100

Line 57: , a1 out nocopy JTF_VARCHAR2_TABLE_400

53: end if;
54: end if;
55: end rosetta_table_copy_in_p1;
56: procedure rosetta_table_copy_out_p1(t cn_get_srp_data_pvt.srp_data_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_400
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_DATE_TABLE
60: , a4 out nocopy JTF_DATE_TABLE
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: a1 := JTF_VARCHAR2_TABLE_400();

70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_400();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_DATE_TABLE();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();

Line 88: a1 := JTF_VARCHAR2_TABLE_400();

84: a11 := JTF_NUMBER_TABLE();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_VARCHAR2_TABLE_400();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_DATE_TABLE();
91: a4 := JTF_DATE_TABLE();
92: a5 := JTF_VARCHAR2_TABLE_100();

Line 141: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_400

137: end if;
138: end rosetta_table_copy_out_p1;
139:
140: procedure get_srp_list(p0_a0 out nocopy JTF_NUMBER_TABLE
141: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_400
142: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p0_a3 out nocopy JTF_DATE_TABLE
144: , p0_a4 out nocopy JTF_DATE_TABLE
145: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 193: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_400

189: , p_order_by NUMBER
190: , p_order_dir VARCHAR2
191: , x_total_rows out nocopy NUMBER
192: , p10_a0 out nocopy JTF_NUMBER_TABLE
193: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_400
194: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
195: , p10_a3 out nocopy JTF_DATE_TABLE
196: , p10_a4 out nocopy JTF_DATE_TABLE
197: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_400

264: end;
265:
266: procedure get_srp_data(p_srp_id NUMBER
267: , p1_a0 out nocopy JTF_NUMBER_TABLE
268: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_400
269: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p1_a3 out nocopy JTF_DATE_TABLE
271: , p1_a4 out nocopy JTF_DATE_TABLE
272: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 316: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_400

312: procedure get_managers(p_srp_id NUMBER
313: , p_date date
314: , p_comp_group_id NUMBER
315: , p3_a0 out nocopy JTF_NUMBER_TABLE
316: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_400
317: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p3_a3 out nocopy JTF_DATE_TABLE
319: , p3_a4 out nocopy JTF_DATE_TABLE
320: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100