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.IEM_AGENT_INBOX_MGMT_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy iem_agent_inbox_mgmt_pvt.message_tbl, 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 iem_agent_inbox_mgmt_pvt.message_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_VARCHAR2_TABLE_2000
17: , a4 JTF_VARCHAR2_TABLE_100

Line 14: , a1 JTF_NUMBER_TABLE

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

Line 20: , a7 JTF_NUMBER_TABLE

16: , a3 JTF_VARCHAR2_TABLE_2000
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_400
19: , a6 JTF_VARCHAR2_TABLE_500
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_400
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_NUMBER_TABLE

Line 21: , a8 JTF_NUMBER_TABLE

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

Line 23: , a10 JTF_NUMBER_TABLE

19: , a6 JTF_VARCHAR2_TABLE_500
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_400
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_DATE_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;

Line 24: , a11 JTF_NUMBER_TABLE

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

Line 56: procedure rosetta_table_copy_out_p1(t iem_agent_inbox_mgmt_pvt.message_tbl, 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 iem_agent_inbox_mgmt_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_300
59: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 63: , a7 out nocopy JTF_NUMBER_TABLE

59: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100
61: , a5 out nocopy JTF_VARCHAR2_TABLE_400
62: , a6 out nocopy JTF_VARCHAR2_TABLE_500
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_VARCHAR2_TABLE_400
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE

Line 64: , a8 out nocopy JTF_NUMBER_TABLE

60: , a4 out nocopy JTF_VARCHAR2_TABLE_100
61: , a5 out nocopy JTF_VARCHAR2_TABLE_400
62: , a6 out nocopy JTF_VARCHAR2_TABLE_500
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_VARCHAR2_TABLE_400
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_DATE_TABLE

Line 66: , a10 out nocopy JTF_NUMBER_TABLE

62: , a6 out nocopy JTF_VARCHAR2_TABLE_500
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_VARCHAR2_TABLE_400
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_DATE_TABLE
69: ) as
70: ddindx binary_integer; indx binary_integer;

Line 67: , a11 out nocopy JTF_NUMBER_TABLE

63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_VARCHAR2_TABLE_400
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_DATE_TABLE
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_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_VARCHAR2_TABLE_2000();
77: a4 := JTF_VARCHAR2_TABLE_100();

Line 74: a1 := JTF_NUMBER_TABLE();

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_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_VARCHAR2_TABLE_2000();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_400();

Line 80: a7 := JTF_NUMBER_TABLE();

76: a3 := JTF_VARCHAR2_TABLE_2000();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_400();
79: a6 := JTF_VARCHAR2_TABLE_500();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_VARCHAR2_TABLE_400();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();

Line 81: a8 := JTF_NUMBER_TABLE();

77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_400();
79: a6 := JTF_VARCHAR2_TABLE_500();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_VARCHAR2_TABLE_400();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: a12 := JTF_DATE_TABLE();

Line 83: a10 := JTF_NUMBER_TABLE();

79: a6 := JTF_VARCHAR2_TABLE_500();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_VARCHAR2_TABLE_400();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: a12 := JTF_DATE_TABLE();
86: else
87: a0 := JTF_NUMBER_TABLE();

Line 84: a11 := JTF_NUMBER_TABLE();

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

Line 87: a0 := JTF_NUMBER_TABLE();

83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: a12 := JTF_DATE_TABLE();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_NUMBER_TABLE();
89: a2 := JTF_VARCHAR2_TABLE_300();
90: a3 := JTF_VARCHAR2_TABLE_2000();
91: a4 := JTF_VARCHAR2_TABLE_100();

Line 88: a1 := JTF_NUMBER_TABLE();

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

Line 94: a7 := JTF_NUMBER_TABLE();

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

Line 95: a8 := JTF_NUMBER_TABLE();

91: a4 := JTF_VARCHAR2_TABLE_100();
92: a5 := JTF_VARCHAR2_TABLE_400();
93: a6 := JTF_VARCHAR2_TABLE_500();
94: a7 := JTF_NUMBER_TABLE();
95: a8 := JTF_NUMBER_TABLE();
96: a9 := JTF_VARCHAR2_TABLE_400();
97: a10 := JTF_NUMBER_TABLE();
98: a11 := JTF_NUMBER_TABLE();
99: a12 := JTF_DATE_TABLE();

Line 97: a10 := JTF_NUMBER_TABLE();

93: a6 := JTF_VARCHAR2_TABLE_500();
94: a7 := JTF_NUMBER_TABLE();
95: a8 := JTF_NUMBER_TABLE();
96: a9 := JTF_VARCHAR2_TABLE_400();
97: a10 := JTF_NUMBER_TABLE();
98: a11 := JTF_NUMBER_TABLE();
99: a12 := JTF_DATE_TABLE();
100: if t.count > 0 then
101: a0.extend(t.count);

Line 98: a11 := JTF_NUMBER_TABLE();

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

Line 140: procedure rosetta_table_copy_in_p3(t out nocopy iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE

136: end if;
137: end if;
138: end rosetta_table_copy_out_p1;
139:
140: procedure rosetta_table_copy_in_p3(t out nocopy iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
141: , a1 JTF_NUMBER_TABLE
142: , a2 JTF_VARCHAR2_TABLE_300
143: , a3 JTF_VARCHAR2_TABLE_2000
144: , a4 JTF_VARCHAR2_TABLE_100

Line 141: , a1 JTF_NUMBER_TABLE

137: end if;
138: end rosetta_table_copy_out_p1;
139:
140: procedure rosetta_table_copy_in_p3(t out nocopy iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
141: , a1 JTF_NUMBER_TABLE
142: , a2 JTF_VARCHAR2_TABLE_300
143: , a3 JTF_VARCHAR2_TABLE_2000
144: , a4 JTF_VARCHAR2_TABLE_100
145: , a5 JTF_VARCHAR2_TABLE_400

Line 148: , a8 JTF_NUMBER_TABLE

144: , a4 JTF_VARCHAR2_TABLE_100
145: , a5 JTF_VARCHAR2_TABLE_400
146: , a6 JTF_VARCHAR2_TABLE_500
147: , a7 JTF_VARCHAR2_TABLE_100
148: , a8 JTF_NUMBER_TABLE
149: , a9 JTF_VARCHAR2_TABLE_400
150: , a10 JTF_NUMBER_TABLE
151: , a11 JTF_NUMBER_TABLE
152: ) as

Line 150: , a10 JTF_NUMBER_TABLE

146: , a6 JTF_VARCHAR2_TABLE_500
147: , a7 JTF_VARCHAR2_TABLE_100
148: , a8 JTF_NUMBER_TABLE
149: , a9 JTF_VARCHAR2_TABLE_400
150: , a10 JTF_NUMBER_TABLE
151: , a11 JTF_NUMBER_TABLE
152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin

Line 151: , a11 JTF_NUMBER_TABLE

147: , a7 JTF_VARCHAR2_TABLE_100
148: , a8 JTF_NUMBER_TABLE
149: , a9 JTF_VARCHAR2_TABLE_400
150: , a10 JTF_NUMBER_TABLE
151: , a11 JTF_NUMBER_TABLE
152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin
155: if a0 is not null and a0.count > 0 then

Line 181: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE

177: end loop;
178: end if;
179: end if;
180: end rosetta_table_copy_in_p3;
181: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
182: , a1 out nocopy JTF_NUMBER_TABLE
183: , a2 out nocopy JTF_VARCHAR2_TABLE_300
184: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 182: , a1 out nocopy JTF_NUMBER_TABLE

178: end if;
179: end if;
180: end rosetta_table_copy_in_p3;
181: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
182: , a1 out nocopy JTF_NUMBER_TABLE
183: , a2 out nocopy JTF_VARCHAR2_TABLE_300
184: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , a5 out nocopy JTF_VARCHAR2_TABLE_400

Line 189: , a8 out nocopy JTF_NUMBER_TABLE

185: , a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , a5 out nocopy JTF_VARCHAR2_TABLE_400
187: , a6 out nocopy JTF_VARCHAR2_TABLE_500
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE
190: , a9 out nocopy JTF_VARCHAR2_TABLE_400
191: , a10 out nocopy JTF_NUMBER_TABLE
192: , a11 out nocopy JTF_NUMBER_TABLE
193: ) as

Line 191: , a10 out nocopy JTF_NUMBER_TABLE

187: , a6 out nocopy JTF_VARCHAR2_TABLE_500
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE
190: , a9 out nocopy JTF_VARCHAR2_TABLE_400
191: , a10 out nocopy JTF_NUMBER_TABLE
192: , a11 out nocopy JTF_NUMBER_TABLE
193: ) as
194: ddindx binary_integer; indx binary_integer;
195: begin

Line 192: , a11 out nocopy JTF_NUMBER_TABLE

188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE
190: , a9 out nocopy JTF_VARCHAR2_TABLE_400
191: , a10 out nocopy JTF_NUMBER_TABLE
192: , a11 out nocopy JTF_NUMBER_TABLE
193: ) as
194: ddindx binary_integer; indx binary_integer;
195: begin
196: if t is null or t.count = 0 then

Line 197: a0 := JTF_NUMBER_TABLE();

193: ) as
194: ddindx binary_integer; indx binary_integer;
195: begin
196: if t is null or t.count = 0 then
197: a0 := JTF_NUMBER_TABLE();
198: a1 := JTF_NUMBER_TABLE();
199: a2 := JTF_VARCHAR2_TABLE_300();
200: a3 := JTF_VARCHAR2_TABLE_2000();
201: a4 := JTF_VARCHAR2_TABLE_100();

Line 198: a1 := JTF_NUMBER_TABLE();

194: ddindx binary_integer; indx binary_integer;
195: begin
196: if t is null or t.count = 0 then
197: a0 := JTF_NUMBER_TABLE();
198: a1 := JTF_NUMBER_TABLE();
199: a2 := JTF_VARCHAR2_TABLE_300();
200: a3 := JTF_VARCHAR2_TABLE_2000();
201: a4 := JTF_VARCHAR2_TABLE_100();
202: a5 := JTF_VARCHAR2_TABLE_400();

Line 205: a8 := JTF_NUMBER_TABLE();

201: a4 := JTF_VARCHAR2_TABLE_100();
202: a5 := JTF_VARCHAR2_TABLE_400();
203: a6 := JTF_VARCHAR2_TABLE_500();
204: a7 := JTF_VARCHAR2_TABLE_100();
205: a8 := JTF_NUMBER_TABLE();
206: a9 := JTF_VARCHAR2_TABLE_400();
207: a10 := JTF_NUMBER_TABLE();
208: a11 := JTF_NUMBER_TABLE();
209: else

Line 207: a10 := JTF_NUMBER_TABLE();

203: a6 := JTF_VARCHAR2_TABLE_500();
204: a7 := JTF_VARCHAR2_TABLE_100();
205: a8 := JTF_NUMBER_TABLE();
206: a9 := JTF_VARCHAR2_TABLE_400();
207: a10 := JTF_NUMBER_TABLE();
208: a11 := JTF_NUMBER_TABLE();
209: else
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_NUMBER_TABLE();

Line 208: a11 := JTF_NUMBER_TABLE();

204: a7 := JTF_VARCHAR2_TABLE_100();
205: a8 := JTF_NUMBER_TABLE();
206: a9 := JTF_VARCHAR2_TABLE_400();
207: a10 := JTF_NUMBER_TABLE();
208: a11 := JTF_NUMBER_TABLE();
209: else
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_NUMBER_TABLE();
212: a2 := JTF_VARCHAR2_TABLE_300();

Line 210: a0 := JTF_NUMBER_TABLE();

206: a9 := JTF_VARCHAR2_TABLE_400();
207: a10 := JTF_NUMBER_TABLE();
208: a11 := JTF_NUMBER_TABLE();
209: else
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_NUMBER_TABLE();
212: a2 := JTF_VARCHAR2_TABLE_300();
213: a3 := JTF_VARCHAR2_TABLE_2000();
214: a4 := JTF_VARCHAR2_TABLE_100();

Line 211: a1 := JTF_NUMBER_TABLE();

207: a10 := JTF_NUMBER_TABLE();
208: a11 := JTF_NUMBER_TABLE();
209: else
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_NUMBER_TABLE();
212: a2 := JTF_VARCHAR2_TABLE_300();
213: a3 := JTF_VARCHAR2_TABLE_2000();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_VARCHAR2_TABLE_400();

Line 218: a8 := JTF_NUMBER_TABLE();

214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_VARCHAR2_TABLE_400();
216: a6 := JTF_VARCHAR2_TABLE_500();
217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_400();
220: a10 := JTF_NUMBER_TABLE();
221: a11 := JTF_NUMBER_TABLE();
222: if t.count > 0 then

Line 220: a10 := JTF_NUMBER_TABLE();

216: a6 := JTF_VARCHAR2_TABLE_500();
217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_400();
220: a10 := JTF_NUMBER_TABLE();
221: a11 := JTF_NUMBER_TABLE();
222: if t.count > 0 then
223: a0.extend(t.count);
224: a1.extend(t.count);

Line 221: a11 := JTF_NUMBER_TABLE();

217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_400();
220: a10 := JTF_NUMBER_TABLE();
221: a11 := JTF_NUMBER_TABLE();
222: if t.count > 0 then
223: a0.extend(t.count);
224: a1.extend(t.count);
225: a2.extend(t.count);

Line 260: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE

256: end if;
257: end if;
258: end rosetta_table_copy_out_p3;
259:
260: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
261: , a1 JTF_VARCHAR2_TABLE_200
262: , a2 JTF_NUMBER_TABLE
263: , a3 JTF_VARCHAR2_TABLE_500
264: ) as

Line 262: , a2 JTF_NUMBER_TABLE

258: end rosetta_table_copy_out_p3;
259:
260: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
261: , a1 JTF_VARCHAR2_TABLE_200
262: , a2 JTF_NUMBER_TABLE
263: , a3 JTF_VARCHAR2_TABLE_500
264: ) as
265: ddindx binary_integer; indx binary_integer;
266: begin

Line 285: procedure rosetta_table_copy_out_p5(t iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

281: end loop;
282: end if;
283: end if;
284: end rosetta_table_copy_in_p5;
285: procedure rosetta_table_copy_out_p5(t iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
286: , a1 out nocopy JTF_VARCHAR2_TABLE_200
287: , a2 out nocopy JTF_NUMBER_TABLE
288: , a3 out nocopy JTF_VARCHAR2_TABLE_500
289: ) as

Line 287: , a2 out nocopy JTF_NUMBER_TABLE

283: end if;
284: end rosetta_table_copy_in_p5;
285: procedure rosetta_table_copy_out_p5(t iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
286: , a1 out nocopy JTF_VARCHAR2_TABLE_200
287: , a2 out nocopy JTF_NUMBER_TABLE
288: , a3 out nocopy JTF_VARCHAR2_TABLE_500
289: ) as
290: ddindx binary_integer; indx binary_integer;
291: begin

Line 293: a0 := JTF_NUMBER_TABLE();

289: ) as
290: ddindx binary_integer; indx binary_integer;
291: begin
292: if t is null or t.count = 0 then
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_VARCHAR2_TABLE_200();
295: a2 := JTF_NUMBER_TABLE();
296: a3 := JTF_VARCHAR2_TABLE_500();
297: else

Line 295: a2 := JTF_NUMBER_TABLE();

291: begin
292: if t is null or t.count = 0 then
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_VARCHAR2_TABLE_200();
295: a2 := JTF_NUMBER_TABLE();
296: a3 := JTF_VARCHAR2_TABLE_500();
297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_VARCHAR2_TABLE_200();

Line 298: a0 := JTF_NUMBER_TABLE();

294: a1 := JTF_VARCHAR2_TABLE_200();
295: a2 := JTF_NUMBER_TABLE();
296: a3 := JTF_VARCHAR2_TABLE_500();
297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_VARCHAR2_TABLE_200();
300: a2 := JTF_NUMBER_TABLE();
301: a3 := JTF_VARCHAR2_TABLE_500();
302: if t.count > 0 then

Line 300: a2 := JTF_NUMBER_TABLE();

296: a3 := JTF_VARCHAR2_TABLE_500();
297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_VARCHAR2_TABLE_200();
300: a2 := JTF_NUMBER_TABLE();
301: a3 := JTF_VARCHAR2_TABLE_500();
302: if t.count > 0 then
303: a0.extend(t.count);
304: a1.extend(t.count);

Line 340: , p16_a0 out nocopy JTF_NUMBER_TABLE

336: , p_resource_id NUMBER
337: , p_page_flag NUMBER
338: , p_sort_column NUMBER
339: , p_sort_state VARCHAR2
340: , p16_a0 out nocopy JTF_NUMBER_TABLE
341: , p16_a1 out nocopy JTF_NUMBER_TABLE
342: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_300
343: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_2000
344: , p16_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 341: , p16_a1 out nocopy JTF_NUMBER_TABLE

337: , p_page_flag NUMBER
338: , p_sort_column NUMBER
339: , p_sort_state VARCHAR2
340: , p16_a0 out nocopy JTF_NUMBER_TABLE
341: , p16_a1 out nocopy JTF_NUMBER_TABLE
342: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_300
343: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_2000
344: , p16_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p16_a5 out nocopy JTF_VARCHAR2_TABLE_400

Line 347: , p16_a7 out nocopy JTF_NUMBER_TABLE

343: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_2000
344: , p16_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p16_a5 out nocopy JTF_VARCHAR2_TABLE_400
346: , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500
347: , p16_a7 out nocopy JTF_NUMBER_TABLE
348: , p16_a8 out nocopy JTF_NUMBER_TABLE
349: , p16_a9 out nocopy JTF_VARCHAR2_TABLE_400
350: , p16_a10 out nocopy JTF_NUMBER_TABLE
351: , p16_a11 out nocopy JTF_NUMBER_TABLE

Line 348: , p16_a8 out nocopy JTF_NUMBER_TABLE

344: , p16_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p16_a5 out nocopy JTF_VARCHAR2_TABLE_400
346: , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500
347: , p16_a7 out nocopy JTF_NUMBER_TABLE
348: , p16_a8 out nocopy JTF_NUMBER_TABLE
349: , p16_a9 out nocopy JTF_VARCHAR2_TABLE_400
350: , p16_a10 out nocopy JTF_NUMBER_TABLE
351: , p16_a11 out nocopy JTF_NUMBER_TABLE
352: , p16_a12 out nocopy JTF_DATE_TABLE

Line 350: , p16_a10 out nocopy JTF_NUMBER_TABLE

346: , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500
347: , p16_a7 out nocopy JTF_NUMBER_TABLE
348: , p16_a8 out nocopy JTF_NUMBER_TABLE
349: , p16_a9 out nocopy JTF_VARCHAR2_TABLE_400
350: , p16_a10 out nocopy JTF_NUMBER_TABLE
351: , p16_a11 out nocopy JTF_NUMBER_TABLE
352: , p16_a12 out nocopy JTF_DATE_TABLE
353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER

Line 351: , p16_a11 out nocopy JTF_NUMBER_TABLE

347: , p16_a7 out nocopy JTF_NUMBER_TABLE
348: , p16_a8 out nocopy JTF_NUMBER_TABLE
349: , p16_a9 out nocopy JTF_VARCHAR2_TABLE_400
350: , p16_a10 out nocopy JTF_NUMBER_TABLE
351: , p16_a11 out nocopy JTF_NUMBER_TABLE
352: , p16_a12 out nocopy JTF_DATE_TABLE
353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2

Line 451: , p9_a0 out nocopy JTF_NUMBER_TABLE

447: , p_sort_state VARCHAR2
448: , p_resource_role NUMBER
449: , p_resource_name VARCHAR2
450: , p_transferrer_id NUMBER
451: , p9_a0 out nocopy JTF_NUMBER_TABLE
452: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
453: , p9_a2 out nocopy JTF_NUMBER_TABLE
454: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_500
455: , x_return_status out nocopy VARCHAR2

Line 453: , p9_a2 out nocopy JTF_NUMBER_TABLE

449: , p_resource_name VARCHAR2
450: , p_transferrer_id NUMBER
451: , p9_a0 out nocopy JTF_NUMBER_TABLE
452: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
453: , p9_a2 out nocopy JTF_NUMBER_TABLE
454: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_500
455: , x_return_status out nocopy VARCHAR2
456: , x_msg_count out nocopy NUMBER
457: , x_msg_data out nocopy VARCHAR2