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_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_avail_pvt.rstab, a0 JTF_NUMBER_TABLE

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;

Line 26: procedure rosetta_table_copy_out_p1(t cac_view_avail_pvt.rstab, a0 out nocopy JTF_NUMBER_TABLE

22: end loop;
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;

Line 33: a0 := JTF_NUMBER_TABLE();

29: ) as
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();

Line 37: a0 := JTF_NUMBER_TABLE();

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();
40: if t.count > 0 then
41: a0.extend(t.count);

Line 60: procedure rosetta_table_copy_in_p3(t out nocopy cac_view_avail_pvt.avlbltb, a0 JTF_NUMBER_TABLE

56: end if;
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

Line 63: , a3 JTF_NUMBER_TABLE

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;
67: begin

Line 64: , a4 JTF_NUMBER_TABLE

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;
67: begin
68: if a0 is not null and a0.count > 0 then

Line 87: procedure rosetta_table_copy_out_p3(t cac_view_avail_pvt.avlbltb, a0 out nocopy JTF_NUMBER_TABLE

83: end loop;
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

Line 90: , a3 out nocopy JTF_NUMBER_TABLE

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;
94: begin

Line 91: , a4 out nocopy JTF_NUMBER_TABLE

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;
94: begin
95: if t is null or t.count = 0 then

Line 96: a0 := JTF_NUMBER_TABLE();

92: ) as
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();

Line 99: a3 := JTF_NUMBER_TABLE();

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();
103: a1 := JTF_VARCHAR2_TABLE_100();

Line 100: a4 := JTF_NUMBER_TABLE();

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();
103: a1 := JTF_VARCHAR2_TABLE_100();
104: a2 := JTF_VARCHAR2_TABLE_400();

Line 102: a0 := JTF_NUMBER_TABLE();

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

Line 105: a3 := 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);
109: a1.extend(t.count);

Line 106: a4 := JTF_NUMBER_TABLE();

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

Line 136: , p5_a0 JTF_NUMBER_TABLE

132: , p_init_msg_list VARCHAR2
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

Line 143: , p10_a0 out nocopy JTF_NUMBER_TABLE

139: , p_startdatetime DATE
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

Line 146: , p10_a3 out nocopy JTF_NUMBER_TABLE

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
150: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400

Line 147: , p10_a4 out nocopy JTF_NUMBER_TABLE

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
150: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400
151: , p11_a3 out nocopy JTF_NUMBER_TABLE

Line 148: , p11_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
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

Line 151: , p11_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:
155: as

Line 152: , p11_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:
155: as
156: ddp_rslist cac_view_avail_pvt.rstab;

Line 221: , p2_a0 JTF_NUMBER_TABLE

217: end;
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

Line 228: , p7_a0 out nocopy JTF_NUMBER_TABLE

224: , p_startdatetime DATE
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

Line 231: , p7_a3 out nocopy JTF_NUMBER_TABLE

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
235: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400

Line 232: , p7_a4 out nocopy JTF_NUMBER_TABLE

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
235: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
236: , p8_a3 out nocopy JTF_NUMBER_TABLE

Line 233: , p8_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
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

Line 236: , p8_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
240: , x_msg_data out nocopy VARCHAR2

Line 237: , p8_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
240: , x_msg_data out nocopy VARCHAR2
241: )

Line 314: , p7_a0 out nocopy JTF_NUMBER_TABLE

310: , p_startdatetime DATE
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

Line 317: , p7_a3 out nocopy JTF_NUMBER_TABLE

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
321: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400

Line 318: , p7_a4 out nocopy JTF_NUMBER_TABLE

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
321: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
322: , p8_a3 out nocopy JTF_NUMBER_TABLE

Line 319: , p8_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
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

Line 322: , p8_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
326: , x_msg_data out nocopy VARCHAR2

Line 323: , p8_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
326: , x_msg_data out nocopy VARCHAR2
327: )