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.CAC_VIEW_AVAIL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body cac_view_avail_pvt_w as
2: /* $Header: cacwavb.pls 115.0 2003/10/28 00:59:35 cjang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_avail_pvt.rstab, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: ) as
7: ddindx binary_integer; indx binary_integer;
8: begin

Line 27: , a1 out nocopy JTF_VARCHAR2_TABLE_100

23: end if;
24: end if;
25: end rosetta_table_copy_in_p1;
26: procedure rosetta_table_copy_out_p1(t cac_view_avail_pvt.rstab, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_VARCHAR2_TABLE_100
28: , a2 out nocopy JTF_VARCHAR2_TABLE_400
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin

Line 34: a1 := JTF_VARCHAR2_TABLE_100();

30: ddindx binary_integer; indx binary_integer;
31: begin
32: if t is null or t.count = 0 then
33: a0 := JTF_NUMBER_TABLE();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: a2 := JTF_VARCHAR2_TABLE_400();
36: else
37: a0 := JTF_NUMBER_TABLE();
38: a1 := JTF_VARCHAR2_TABLE_100();

Line 38: a1 := JTF_VARCHAR2_TABLE_100();

34: a1 := JTF_VARCHAR2_TABLE_100();
35: a2 := JTF_VARCHAR2_TABLE_400();
36: else
37: a0 := JTF_NUMBER_TABLE();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: a2 := JTF_VARCHAR2_TABLE_400();
40: if t.count > 0 then
41: a0.extend(t.count);
42: a1.extend(t.count);

Line 61: , a1 JTF_VARCHAR2_TABLE_100

57: end if;
58: end rosetta_table_copy_out_p1;
59:
60: procedure rosetta_table_copy_in_p3(t out nocopy cac_view_avail_pvt.avlbltb, a0 JTF_NUMBER_TABLE
61: , a1 JTF_VARCHAR2_TABLE_100
62: , a2 JTF_VARCHAR2_TABLE_400
63: , a3 JTF_NUMBER_TABLE
64: , a4 JTF_NUMBER_TABLE
65: ) as

Line 88: , a1 out nocopy JTF_VARCHAR2_TABLE_100

84: end if;
85: end if;
86: end rosetta_table_copy_in_p3;
87: procedure rosetta_table_copy_out_p3(t cac_view_avail_pvt.avlbltb, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_VARCHAR2_TABLE_100
89: , a2 out nocopy JTF_VARCHAR2_TABLE_400
90: , a3 out nocopy JTF_NUMBER_TABLE
91: , a4 out nocopy JTF_NUMBER_TABLE
92: ) as

Line 97: a1 := JTF_VARCHAR2_TABLE_100();

93: ddindx binary_integer; indx binary_integer;
94: begin
95: if t is null or t.count = 0 then
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_VARCHAR2_TABLE_100();
98: a2 := JTF_VARCHAR2_TABLE_400();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: else

Line 103: a1 := JTF_VARCHAR2_TABLE_100();

99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_NUMBER_TABLE();
101: else
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_VARCHAR2_TABLE_100();
104: a2 := JTF_VARCHAR2_TABLE_400();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_NUMBER_TABLE();
107: if t.count > 0 then

Line 137: , p5_a1 JTF_VARCHAR2_TABLE_100

133: , x_return_status out nocopy VARCHAR2
134: , x_msg_count out nocopy NUMBER
135: , x_msg_data out nocopy VARCHAR2
136: , p5_a0 JTF_NUMBER_TABLE
137: , p5_a1 JTF_VARCHAR2_TABLE_100
138: , p5_a2 JTF_VARCHAR2_TABLE_400
139: , p_startdatetime DATE
140: , p_enddatetime DATE
141: , p_slotsize NUMBER

Line 144: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100

140: , p_enddatetime DATE
141: , p_slotsize NUMBER
142: , x_numberofslots out nocopy NUMBER
143: , p10_a0 out nocopy JTF_NUMBER_TABLE
144: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
145: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_400
146: , p10_a3 out nocopy JTF_NUMBER_TABLE
147: , p10_a4 out nocopy JTF_NUMBER_TABLE
148: , p11_a0 out nocopy JTF_NUMBER_TABLE

Line 149: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100

145: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_400
146: , p10_a3 out nocopy JTF_NUMBER_TABLE
147: , p10_a4 out nocopy JTF_NUMBER_TABLE
148: , p11_a0 out nocopy JTF_NUMBER_TABLE
149: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
150: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400
151: , p11_a3 out nocopy JTF_NUMBER_TABLE
152: , p11_a4 out nocopy JTF_NUMBER_TABLE
153: )

Line 222: , p2_a1 JTF_VARCHAR2_TABLE_100

218:
219: procedure check_availability(p_api_version NUMBER
220: , p_init_msg_list VARCHAR2
221: , p2_a0 JTF_NUMBER_TABLE
222: , p2_a1 JTF_VARCHAR2_TABLE_100
223: , p2_a2 JTF_VARCHAR2_TABLE_400
224: , p_startdatetime DATE
225: , p_enddatetime DATE
226: , p_slotsize NUMBER

Line 229: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

225: , p_enddatetime DATE
226: , p_slotsize NUMBER
227: , x_numberofslots out nocopy NUMBER
228: , p7_a0 out nocopy JTF_NUMBER_TABLE
229: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
230: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400
231: , p7_a3 out nocopy JTF_NUMBER_TABLE
232: , p7_a4 out nocopy JTF_NUMBER_TABLE
233: , p8_a0 out nocopy JTF_NUMBER_TABLE

Line 234: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

230: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400
231: , p7_a3 out nocopy JTF_NUMBER_TABLE
232: , p7_a4 out nocopy JTF_NUMBER_TABLE
233: , p8_a0 out nocopy JTF_NUMBER_TABLE
234: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
235: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
236: , p8_a3 out nocopy JTF_NUMBER_TABLE
237: , p8_a4 out nocopy JTF_NUMBER_TABLE
238: , x_return_status out nocopy VARCHAR2

Line 315: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

311: , p_enddatetime DATE
312: , p_slotsize NUMBER
313: , x_numberofslots out nocopy NUMBER
314: , p7_a0 out nocopy JTF_NUMBER_TABLE
315: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
316: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400
317: , p7_a3 out nocopy JTF_NUMBER_TABLE
318: , p7_a4 out nocopy JTF_NUMBER_TABLE
319: , p8_a0 out nocopy JTF_NUMBER_TABLE

Line 320: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

316: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400
317: , p7_a3 out nocopy JTF_NUMBER_TABLE
318: , p7_a4 out nocopy JTF_NUMBER_TABLE
319: , p8_a0 out nocopy JTF_NUMBER_TABLE
320: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
321: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
322: , p8_a3 out nocopy JTF_NUMBER_TABLE
323: , p8_a4 out nocopy JTF_NUMBER_TABLE
324: , x_return_status out nocopy VARCHAR2