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_400

Line 5: , a2 JTF_VARCHAR2_TABLE_400

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
9: if a0 is not null and a0.count > 0 then

Line 28: , a2 out nocopy JTF_VARCHAR2_TABLE_400

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
32: if t is null or t.count = 0 then

Line 35: a2 := JTF_VARCHAR2_TABLE_400();

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();
39: a2 := JTF_VARCHAR2_TABLE_400();

Line 39: a2 := JTF_VARCHAR2_TABLE_400();

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);
43: a2.extend(t.count);

Line 62: , a2 JTF_VARCHAR2_TABLE_400

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

Line 89: , a2 out nocopy JTF_VARCHAR2_TABLE_400

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

Line 98: a2 := JTF_VARCHAR2_TABLE_400();

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

Line 104: a2 := JTF_VARCHAR2_TABLE_400();

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

Line 138: , p5_a2 JTF_VARCHAR2_TABLE_400

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
142: , x_numberofslots out nocopy NUMBER

Line 145: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_400

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
149: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 150: , p11_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: )
154:

Line 223: , p2_a2 JTF_VARCHAR2_TABLE_400

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
227: , x_numberofslots out nocopy NUMBER

Line 230: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400

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
234: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 235: , p8_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
239: , x_msg_count out nocopy NUMBER

Line 316: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400

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
320: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 321: , p8_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
325: , x_msg_count out nocopy NUMBER