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_PSUM_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_psum_pvt.psum_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_psum_pvt.psum_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_400
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100

Line 15: , a2 JTF_NUMBER_TABLE

11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_psum_pvt.psum_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_400
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE

Line 16: , a3 JTF_NUMBER_TABLE

12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_psum_pvt.psum_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_400
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100

Line 19: , a6 JTF_NUMBER_TABLE

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

Line 21: , a8 JTF_NUMBER_TABLE

17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100

Line 29: , a16 JTF_NUMBER_TABLE

25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_DATE_TABLE
28: , a15 JTF_DATE_TABLE
29: , a16 JTF_NUMBER_TABLE
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin
33: if a0 is not null and a0.count > 0 then

Line 64: procedure rosetta_table_copy_out_p1(t cn_psum_pvt.psum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

60: end loop;
61: end if;
62: end if;
63: end rosetta_table_copy_in_p1;
64: procedure rosetta_table_copy_out_p1(t cn_psum_pvt.psum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_VARCHAR2_TABLE_400
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_NUMBER_TABLE
68: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 66: , a2 out nocopy JTF_NUMBER_TABLE

62: end if;
63: end rosetta_table_copy_in_p1;
64: procedure rosetta_table_copy_out_p1(t cn_psum_pvt.psum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_VARCHAR2_TABLE_400
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_NUMBER_TABLE
68: , a4 out nocopy JTF_VARCHAR2_TABLE_100
69: , a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , a6 out nocopy JTF_NUMBER_TABLE

Line 67: , a3 out nocopy JTF_NUMBER_TABLE

63: end rosetta_table_copy_in_p1;
64: procedure rosetta_table_copy_out_p1(t cn_psum_pvt.psum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_VARCHAR2_TABLE_400
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_NUMBER_TABLE
68: , a4 out nocopy JTF_VARCHAR2_TABLE_100
69: , a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , a6 out nocopy JTF_NUMBER_TABLE
71: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 70: , a6 out nocopy JTF_NUMBER_TABLE

66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_NUMBER_TABLE
68: , a4 out nocopy JTF_VARCHAR2_TABLE_100
69: , a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , a6 out nocopy JTF_NUMBER_TABLE
71: , a7 out nocopy JTF_VARCHAR2_TABLE_100
72: , a8 out nocopy JTF_NUMBER_TABLE
73: , a9 out nocopy JTF_VARCHAR2_TABLE_100
74: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 72: , a8 out nocopy JTF_NUMBER_TABLE

68: , a4 out nocopy JTF_VARCHAR2_TABLE_100
69: , a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , a6 out nocopy JTF_NUMBER_TABLE
71: , a7 out nocopy JTF_VARCHAR2_TABLE_100
72: , a8 out nocopy JTF_NUMBER_TABLE
73: , a9 out nocopy JTF_VARCHAR2_TABLE_100
74: , a10 out nocopy JTF_VARCHAR2_TABLE_100
75: , a11 out nocopy JTF_VARCHAR2_TABLE_100
76: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 80: , a16 out nocopy JTF_NUMBER_TABLE

76: , a12 out nocopy JTF_VARCHAR2_TABLE_100
77: , a13 out nocopy JTF_VARCHAR2_TABLE_100
78: , a14 out nocopy JTF_DATE_TABLE
79: , a15 out nocopy JTF_DATE_TABLE
80: , a16 out nocopy JTF_NUMBER_TABLE
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then

Line 85: a0 := JTF_NUMBER_TABLE();

81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_400();
87: a2 := JTF_NUMBER_TABLE();
88: a3 := JTF_NUMBER_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_100();

Line 87: a2 := JTF_NUMBER_TABLE();

83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_400();
87: a2 := JTF_NUMBER_TABLE();
88: a3 := JTF_NUMBER_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_100();
90: a5 := JTF_VARCHAR2_TABLE_100();
91: a6 := JTF_NUMBER_TABLE();

Line 88: a3 := JTF_NUMBER_TABLE();

84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_400();
87: a2 := JTF_NUMBER_TABLE();
88: a3 := JTF_NUMBER_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_100();
90: a5 := JTF_VARCHAR2_TABLE_100();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_VARCHAR2_TABLE_100();

Line 91: a6 := JTF_NUMBER_TABLE();

87: a2 := JTF_NUMBER_TABLE();
88: a3 := JTF_NUMBER_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_100();
90: a5 := JTF_VARCHAR2_TABLE_100();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_VARCHAR2_TABLE_100();
93: a8 := JTF_NUMBER_TABLE();
94: a9 := JTF_VARCHAR2_TABLE_100();
95: a10 := JTF_VARCHAR2_TABLE_100();

Line 93: a8 := JTF_NUMBER_TABLE();

89: a4 := JTF_VARCHAR2_TABLE_100();
90: a5 := JTF_VARCHAR2_TABLE_100();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_VARCHAR2_TABLE_100();
93: a8 := JTF_NUMBER_TABLE();
94: a9 := JTF_VARCHAR2_TABLE_100();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_100();
97: a12 := JTF_VARCHAR2_TABLE_100();

Line 101: a16 := JTF_NUMBER_TABLE();

97: a12 := JTF_VARCHAR2_TABLE_100();
98: a13 := JTF_VARCHAR2_TABLE_100();
99: a14 := JTF_DATE_TABLE();
100: a15 := JTF_DATE_TABLE();
101: a16 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: a1 := JTF_VARCHAR2_TABLE_400();
105: a2 := JTF_NUMBER_TABLE();

Line 103: a0 := JTF_NUMBER_TABLE();

99: a14 := JTF_DATE_TABLE();
100: a15 := JTF_DATE_TABLE();
101: a16 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: a1 := JTF_VARCHAR2_TABLE_400();
105: a2 := JTF_NUMBER_TABLE();
106: a3 := JTF_NUMBER_TABLE();
107: a4 := JTF_VARCHAR2_TABLE_100();

Line 105: a2 := JTF_NUMBER_TABLE();

101: a16 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: a1 := JTF_VARCHAR2_TABLE_400();
105: a2 := JTF_NUMBER_TABLE();
106: a3 := JTF_NUMBER_TABLE();
107: a4 := JTF_VARCHAR2_TABLE_100();
108: a5 := JTF_VARCHAR2_TABLE_100();
109: a6 := JTF_NUMBER_TABLE();

Line 106: a3 := JTF_NUMBER_TABLE();

102: else
103: a0 := JTF_NUMBER_TABLE();
104: a1 := JTF_VARCHAR2_TABLE_400();
105: a2 := JTF_NUMBER_TABLE();
106: a3 := JTF_NUMBER_TABLE();
107: a4 := JTF_VARCHAR2_TABLE_100();
108: a5 := JTF_VARCHAR2_TABLE_100();
109: a6 := JTF_NUMBER_TABLE();
110: a7 := JTF_VARCHAR2_TABLE_100();

Line 109: a6 := JTF_NUMBER_TABLE();

105: a2 := JTF_NUMBER_TABLE();
106: a3 := JTF_NUMBER_TABLE();
107: a4 := JTF_VARCHAR2_TABLE_100();
108: a5 := JTF_VARCHAR2_TABLE_100();
109: a6 := JTF_NUMBER_TABLE();
110: a7 := JTF_VARCHAR2_TABLE_100();
111: a8 := JTF_NUMBER_TABLE();
112: a9 := JTF_VARCHAR2_TABLE_100();
113: a10 := JTF_VARCHAR2_TABLE_100();

Line 111: a8 := JTF_NUMBER_TABLE();

107: a4 := JTF_VARCHAR2_TABLE_100();
108: a5 := JTF_VARCHAR2_TABLE_100();
109: a6 := JTF_NUMBER_TABLE();
110: a7 := JTF_VARCHAR2_TABLE_100();
111: a8 := JTF_NUMBER_TABLE();
112: a9 := JTF_VARCHAR2_TABLE_100();
113: a10 := JTF_VARCHAR2_TABLE_100();
114: a11 := JTF_VARCHAR2_TABLE_100();
115: a12 := JTF_VARCHAR2_TABLE_100();

Line 119: a16 := JTF_NUMBER_TABLE();

115: a12 := JTF_VARCHAR2_TABLE_100();
116: a13 := JTF_VARCHAR2_TABLE_100();
117: a14 := JTF_DATE_TABLE();
118: a15 := JTF_DATE_TABLE();
119: a16 := JTF_NUMBER_TABLE();
120: if t.count > 0 then
121: a0.extend(t.count);
122: a1.extend(t.count);
123: a2.extend(t.count);

Line 179: , p11_a0 out nocopy JTF_NUMBER_TABLE

175: , p_mgr_id NUMBER
176: , p_comp_group_id NUMBER
177: , p_mgr_dtl_flag VARCHAR2
178: , p_effective_date date
179: , p11_a0 out nocopy JTF_NUMBER_TABLE
180: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_400
181: , p11_a2 out nocopy JTF_NUMBER_TABLE
182: , p11_a3 out nocopy JTF_NUMBER_TABLE
183: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 181: , p11_a2 out nocopy JTF_NUMBER_TABLE

177: , p_mgr_dtl_flag VARCHAR2
178: , p_effective_date date
179: , p11_a0 out nocopy JTF_NUMBER_TABLE
180: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_400
181: , p11_a2 out nocopy JTF_NUMBER_TABLE
182: , p11_a3 out nocopy JTF_NUMBER_TABLE
183: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
184: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
185: , p11_a6 out nocopy JTF_NUMBER_TABLE

Line 182: , p11_a3 out nocopy JTF_NUMBER_TABLE

178: , p_effective_date date
179: , p11_a0 out nocopy JTF_NUMBER_TABLE
180: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_400
181: , p11_a2 out nocopy JTF_NUMBER_TABLE
182: , p11_a3 out nocopy JTF_NUMBER_TABLE
183: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
184: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
185: , p11_a6 out nocopy JTF_NUMBER_TABLE
186: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 185: , p11_a6 out nocopy JTF_NUMBER_TABLE

181: , p11_a2 out nocopy JTF_NUMBER_TABLE
182: , p11_a3 out nocopy JTF_NUMBER_TABLE
183: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
184: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
185: , p11_a6 out nocopy JTF_NUMBER_TABLE
186: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
187: , p11_a8 out nocopy JTF_NUMBER_TABLE
188: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
189: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 187: , p11_a8 out nocopy JTF_NUMBER_TABLE

183: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
184: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
185: , p11_a6 out nocopy JTF_NUMBER_TABLE
186: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
187: , p11_a8 out nocopy JTF_NUMBER_TABLE
188: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
189: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
190: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
191: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 195: , p11_a16 out nocopy JTF_NUMBER_TABLE

191: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
192: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
193: , p11_a14 out nocopy JTF_DATE_TABLE
194: , p11_a15 out nocopy JTF_DATE_TABLE
195: , p11_a16 out nocopy JTF_NUMBER_TABLE
196: , x_total_rows out nocopy NUMBER
197: )
198:
199: as

Line 280: , p12_a0 out nocopy JTF_NUMBER_TABLE

276: , p_comp_group_id NUMBER
277: , p_mgr_dtl_flag VARCHAR2
278: , p_effective_date date
279: , p_is_multiorg VARCHAR2
280: , p12_a0 out nocopy JTF_NUMBER_TABLE
281: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_400
282: , p12_a2 out nocopy JTF_NUMBER_TABLE
283: , p12_a3 out nocopy JTF_NUMBER_TABLE
284: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 282: , p12_a2 out nocopy JTF_NUMBER_TABLE

278: , p_effective_date date
279: , p_is_multiorg VARCHAR2
280: , p12_a0 out nocopy JTF_NUMBER_TABLE
281: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_400
282: , p12_a2 out nocopy JTF_NUMBER_TABLE
283: , p12_a3 out nocopy JTF_NUMBER_TABLE
284: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
285: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
286: , p12_a6 out nocopy JTF_NUMBER_TABLE

Line 283: , p12_a3 out nocopy JTF_NUMBER_TABLE

279: , p_is_multiorg VARCHAR2
280: , p12_a0 out nocopy JTF_NUMBER_TABLE
281: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_400
282: , p12_a2 out nocopy JTF_NUMBER_TABLE
283: , p12_a3 out nocopy JTF_NUMBER_TABLE
284: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
285: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
286: , p12_a6 out nocopy JTF_NUMBER_TABLE
287: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 286: , p12_a6 out nocopy JTF_NUMBER_TABLE

282: , p12_a2 out nocopy JTF_NUMBER_TABLE
283: , p12_a3 out nocopy JTF_NUMBER_TABLE
284: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
285: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
286: , p12_a6 out nocopy JTF_NUMBER_TABLE
287: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
288: , p12_a8 out nocopy JTF_NUMBER_TABLE
289: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
290: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 288: , p12_a8 out nocopy JTF_NUMBER_TABLE

284: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
285: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
286: , p12_a6 out nocopy JTF_NUMBER_TABLE
287: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
288: , p12_a8 out nocopy JTF_NUMBER_TABLE
289: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
290: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
291: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
292: , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 296: , p12_a16 out nocopy JTF_NUMBER_TABLE

292: , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100
293: , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100
294: , p12_a14 out nocopy JTF_DATE_TABLE
295: , p12_a15 out nocopy JTF_DATE_TABLE
296: , p12_a16 out nocopy JTF_NUMBER_TABLE
297: , x_total_rows out nocopy NUMBER
298: )
299:
300: as