DBA Data[Home] [Help]

APPS.IEM_AGENT_INBOX_MGMT_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 16: , a3 JTF_VARCHAR2_TABLE_2000

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
19: , a6 JTF_VARCHAR2_TABLE_500
20: , a7 JTF_NUMBER_TABLE

Line 59: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

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
62: , a6 out nocopy JTF_VARCHAR2_TABLE_500
63: , a7 out nocopy JTF_NUMBER_TABLE

Line 76: a3 := JTF_VARCHAR2_TABLE_2000();

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();
79: a6 := JTF_VARCHAR2_TABLE_500();
80: a7 := JTF_NUMBER_TABLE();

Line 90: a3 := JTF_VARCHAR2_TABLE_2000();

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();
93: a6 := JTF_VARCHAR2_TABLE_500();
94: a7 := JTF_NUMBER_TABLE();

Line 143: , a3 JTF_VARCHAR2_TABLE_2000

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
146: , a6 JTF_VARCHAR2_TABLE_500
147: , a7 JTF_VARCHAR2_TABLE_100

Line 184: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

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
187: , a6 out nocopy JTF_VARCHAR2_TABLE_500
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 200: a3 := JTF_VARCHAR2_TABLE_2000();

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();
203: a6 := JTF_VARCHAR2_TABLE_500();
204: a7 := JTF_VARCHAR2_TABLE_100();

Line 213: a3 := JTF_VARCHAR2_TABLE_2000();

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();
216: a6 := JTF_VARCHAR2_TABLE_500();
217: a7 := JTF_VARCHAR2_TABLE_100();

Line 261: , a1 JTF_VARCHAR2_TABLE_200

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
265: ddindx binary_integer; indx binary_integer;

Line 286: , a1 out nocopy JTF_VARCHAR2_TABLE_200

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
290: ddindx binary_integer; indx binary_integer;

Line 294: a1 := JTF_VARCHAR2_TABLE_200();

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
298: a0 := JTF_NUMBER_TABLE();

Line 299: 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
303: a0.extend(t.count);

Line 343: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_2000

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
346: , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500
347: , p16_a7 out nocopy JTF_NUMBER_TABLE

Line 452: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200

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
456: , x_msg_count out nocopy NUMBER