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_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_srp_data_pvt.srp_data_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
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

Line 19: , a6 JTF_NUMBER_TABLE

15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_VARCHAR2_TABLE_300
23: , a10 JTF_VARCHAR2_TABLE_100

Line 24: , a11 JTF_NUMBER_TABLE

20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_VARCHAR2_TABLE_300
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin

Line 56: procedure rosetta_table_copy_out_p1(t cn_get_srp_data_pvt.srp_data_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

52: end loop;
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

Line 62: , a6 out nocopy JTF_NUMBER_TABLE

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
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , a8 out nocopy JTF_VARCHAR2_TABLE_300
65: , a9 out nocopy JTF_VARCHAR2_TABLE_300
66: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 67: , a11 out nocopy JTF_NUMBER_TABLE

63: , a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , a8 out nocopy JTF_VARCHAR2_TABLE_300
65: , a9 out nocopy JTF_VARCHAR2_TABLE_300
66: , a10 out nocopy JTF_VARCHAR2_TABLE_100
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin

Line 73: a0 := JTF_NUMBER_TABLE();

69: ) as
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();

Line 79: a6 := JTF_NUMBER_TABLE();

75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_DATE_TABLE();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_VARCHAR2_TABLE_300();
82: a9 := JTF_VARCHAR2_TABLE_300();
83: a10 := JTF_VARCHAR2_TABLE_100();

Line 84: a11 := JTF_NUMBER_TABLE();

80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_VARCHAR2_TABLE_300();
82: a9 := JTF_VARCHAR2_TABLE_300();
83: a10 := JTF_VARCHAR2_TABLE_100();
84: a11 := JTF_NUMBER_TABLE();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_VARCHAR2_TABLE_400();

Line 87: a0 := JTF_NUMBER_TABLE();

83: a10 := JTF_VARCHAR2_TABLE_100();
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();

Line 93: a6 := JTF_NUMBER_TABLE();

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

Line 98: a11 := JTF_NUMBER_TABLE();

94: a7 := JTF_VARCHAR2_TABLE_100();
95: a8 := JTF_VARCHAR2_TABLE_300();
96: a9 := JTF_VARCHAR2_TABLE_300();
97: a10 := JTF_VARCHAR2_TABLE_100();
98: a11 := JTF_NUMBER_TABLE();
99: a12 := JTF_VARCHAR2_TABLE_100();
100: if t.count > 0 then
101: a0.extend(t.count);
102: a1.extend(t.count);

Line 140: procedure get_srp_list(p0_a0 out nocopy JTF_NUMBER_TABLE

136: end if;
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

Line 146: , p0_a6 out nocopy JTF_NUMBER_TABLE

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
146: , p0_a6 out nocopy JTF_NUMBER_TABLE
147: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p0_a9 out nocopy JTF_VARCHAR2_TABLE_300
150: , p0_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 151: , p0_a11 out nocopy JTF_NUMBER_TABLE

147: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p0_a9 out nocopy JTF_VARCHAR2_TABLE_300
150: , p0_a10 out nocopy JTF_VARCHAR2_TABLE_100
151: , p0_a11 out nocopy JTF_NUMBER_TABLE
152: , p0_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: )
154:
155: as

Line 192: , p10_a0 out nocopy JTF_NUMBER_TABLE

188: , p_search_group VARCHAR2
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

Line 198: , p10_a6 out nocopy JTF_NUMBER_TABLE

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
198: , p10_a6 out nocopy JTF_NUMBER_TABLE
199: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
200: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
201: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
202: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 203: , p10_a11 out nocopy JTF_NUMBER_TABLE

199: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
200: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
201: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
202: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
203: , p10_a11 out nocopy JTF_NUMBER_TABLE
204: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
205: )
206:
207: as

Line 267: , p1_a0 out nocopy JTF_NUMBER_TABLE

263: );
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

Line 273: , p1_a6 out nocopy JTF_NUMBER_TABLE

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
273: , p1_a6 out nocopy JTF_NUMBER_TABLE
274: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
275: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300
276: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_300
277: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 278: , p1_a11 out nocopy JTF_NUMBER_TABLE

274: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
275: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300
276: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_300
277: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100
278: , p1_a11 out nocopy JTF_NUMBER_TABLE
279: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_100
280: )
281:
282: as

Line 315: , p3_a0 out nocopy JTF_NUMBER_TABLE

311:
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

Line 321: , p3_a6 out nocopy JTF_NUMBER_TABLE

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
321: , p3_a6 out nocopy JTF_NUMBER_TABLE
322: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
323: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300
324: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_300
325: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 326: , p3_a11 out nocopy JTF_NUMBER_TABLE

322: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
323: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300
324: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_300
325: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
326: , p3_a11 out nocopy JTF_NUMBER_TABLE
327: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
328: )
329:
330: as