DBA Data[Home] [Help]

APPS.IEM_QUEUE_MANAGEMENT_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 15: , a2 JTF_VARCHAR2_TABLE_300

11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy iem_queue_management_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

Line 54: , a2 out nocopy JTF_VARCHAR2_TABLE_300

50: end if;
51: end rosetta_table_copy_in_p1;
52: procedure rosetta_table_copy_out_p1(t iem_queue_management_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE
54: , a2 out nocopy JTF_VARCHAR2_TABLE_300
55: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: , a5 out nocopy JTF_VARCHAR2_TABLE_400
58: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 69: a2 := JTF_VARCHAR2_TABLE_300();

65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_VARCHAR2_TABLE_300();
70: a3 := JTF_VARCHAR2_TABLE_2000();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_VARCHAR2_TABLE_400();
73: a6 := JTF_VARCHAR2_TABLE_500();

Line 81: a2 := JTF_VARCHAR2_TABLE_300();

77: a10 := JTF_DATE_TABLE();
78: else
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_VARCHAR2_TABLE_300();
82: a3 := JTF_VARCHAR2_TABLE_2000();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_400();
85: a6 := JTF_VARCHAR2_TABLE_500();

Line 128: , a2 JTF_VARCHAR2_TABLE_300

124: end rosetta_table_copy_out_p1;
125:
126: procedure rosetta_table_copy_in_p3(t out nocopy iem_queue_management_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
127: , a1 JTF_NUMBER_TABLE
128: , a2 JTF_VARCHAR2_TABLE_300
129: , a3 JTF_VARCHAR2_TABLE_2000
130: , a4 JTF_VARCHAR2_TABLE_100
131: , a5 JTF_VARCHAR2_TABLE_400
132: , a6 JTF_VARCHAR2_TABLE_500

Line 165: , a2 out nocopy JTF_VARCHAR2_TABLE_300

161: end if;
162: end rosetta_table_copy_in_p3;
163: procedure rosetta_table_copy_out_p3(t iem_queue_management_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
164: , a1 out nocopy JTF_NUMBER_TABLE
165: , a2 out nocopy JTF_VARCHAR2_TABLE_300
166: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
167: , a4 out nocopy JTF_VARCHAR2_TABLE_100
168: , a5 out nocopy JTF_VARCHAR2_TABLE_400
169: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 179: a2 := JTF_VARCHAR2_TABLE_300();

175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_NUMBER_TABLE();
179: a2 := JTF_VARCHAR2_TABLE_300();
180: a3 := JTF_VARCHAR2_TABLE_2000();
181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_VARCHAR2_TABLE_400();
183: a6 := JTF_VARCHAR2_TABLE_500();

Line 190: a2 := JTF_VARCHAR2_TABLE_300();

186: a9 := JTF_VARCHAR2_TABLE_100();
187: else
188: a0 := JTF_NUMBER_TABLE();
189: a1 := JTF_NUMBER_TABLE();
190: a2 := JTF_VARCHAR2_TABLE_300();
191: a3 := JTF_VARCHAR2_TABLE_2000();
192: a4 := JTF_VARCHAR2_TABLE_100();
193: a5 := JTF_VARCHAR2_TABLE_400();
194: a6 := JTF_VARCHAR2_TABLE_500();

Line 376: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_300

372: , p_sort_column NUMBER
373: , p_sort_state VARCHAR2
374: , p14_a0 out nocopy JTF_NUMBER_TABLE
375: , p14_a1 out nocopy JTF_NUMBER_TABLE
376: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_300
377: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_2000
378: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
379: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_400
380: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_500