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

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body ahl_completions_pvt_w as
2: /* $Header: AHLWPRCB.pls 120.1 2005/07/04 10:48 rroy noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWPRCB.pls 120.1 2005/07/04 10:48 rroy noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 15: , a12 JTF_VARCHAR2_TABLE_100

11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE

Line 16: , a13 JTF_VARCHAR2_TABLE_100

12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100

Line 20: , a17 JTF_VARCHAR2_TABLE_100

16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100

Line 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: ) as

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;

Line 25: , a22 JTF_VARCHAR2_TABLE_100

21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin

Line 70: , a2 out nocopy JTF_VARCHAR2_TABLE_100

66: end if;
67: end rosetta_table_copy_in_p1;
68: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_NUMBER_TABLE

Line 71: , a3 out nocopy JTF_VARCHAR2_TABLE_100

67: end rosetta_table_copy_in_p1;
68: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_NUMBER_TABLE
75: , a7 out nocopy JTF_NUMBER_TABLE

Line 80: , a12 out nocopy JTF_VARCHAR2_TABLE_100

76: , a8 out nocopy JTF_DATE_TABLE
77: , a9 out nocopy JTF_DATE_TABLE
78: , a10 out nocopy JTF_DATE_TABLE
79: , a11 out nocopy JTF_DATE_TABLE
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , a14 out nocopy JTF_NUMBER_TABLE
83: , a15 out nocopy JTF_NUMBER_TABLE
84: , a16 out nocopy JTF_NUMBER_TABLE

Line 81: , a13 out nocopy JTF_VARCHAR2_TABLE_100

77: , a9 out nocopy JTF_DATE_TABLE
78: , a10 out nocopy JTF_DATE_TABLE
79: , a11 out nocopy JTF_DATE_TABLE
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100
81: , a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , a14 out nocopy JTF_NUMBER_TABLE
83: , a15 out nocopy JTF_NUMBER_TABLE
84: , a16 out nocopy JTF_NUMBER_TABLE
85: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 85: , a17 out nocopy JTF_VARCHAR2_TABLE_100

81: , a13 out nocopy JTF_VARCHAR2_TABLE_100
82: , a14 out nocopy JTF_NUMBER_TABLE
83: , a15 out nocopy JTF_NUMBER_TABLE
84: , a16 out nocopy JTF_NUMBER_TABLE
85: , a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 87: , a19 out nocopy JTF_VARCHAR2_TABLE_100

83: , a15 out nocopy JTF_NUMBER_TABLE
84: , a16 out nocopy JTF_NUMBER_TABLE
85: , a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_100
90: , a22 out nocopy JTF_VARCHAR2_TABLE_100
91: , a23 out nocopy JTF_NUMBER_TABLE

Line 88: , a20 out nocopy JTF_VARCHAR2_TABLE_100

84: , a16 out nocopy JTF_NUMBER_TABLE
85: , a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_100
90: , a22 out nocopy JTF_VARCHAR2_TABLE_100
91: , a23 out nocopy JTF_NUMBER_TABLE
92: ) as

Line 89: , a21 out nocopy JTF_VARCHAR2_TABLE_100

85: , a17 out nocopy JTF_VARCHAR2_TABLE_100
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_100
90: , a22 out nocopy JTF_VARCHAR2_TABLE_100
91: , a23 out nocopy JTF_NUMBER_TABLE
92: ) as
93: ddindx binary_integer; indx binary_integer;

Line 90: , a22 out nocopy JTF_VARCHAR2_TABLE_100

86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_VARCHAR2_TABLE_100
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_100
90: , a22 out nocopy JTF_VARCHAR2_TABLE_100
91: , a23 out nocopy JTF_NUMBER_TABLE
92: ) as
93: ddindx binary_integer; indx binary_integer;
94: begin

Line 98: a2 := JTF_VARCHAR2_TABLE_100();

94: begin
95: if t is null or t.count = 0 then
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_VARCHAR2_TABLE_100();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();

Line 99: a3 := JTF_VARCHAR2_TABLE_100();

95: if t is null or t.count = 0 then
96: a0 := JTF_NUMBER_TABLE();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_VARCHAR2_TABLE_100();
100: a4 := JTF_NUMBER_TABLE();
101: a5 := JTF_NUMBER_TABLE();
102: a6 := JTF_NUMBER_TABLE();
103: a7 := JTF_NUMBER_TABLE();

Line 108: a12 := JTF_VARCHAR2_TABLE_100();

104: a8 := JTF_DATE_TABLE();
105: a9 := JTF_DATE_TABLE();
106: a10 := JTF_DATE_TABLE();
107: a11 := JTF_DATE_TABLE();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: a13 := JTF_VARCHAR2_TABLE_100();
110: a14 := JTF_NUMBER_TABLE();
111: a15 := JTF_NUMBER_TABLE();
112: a16 := JTF_NUMBER_TABLE();

Line 109: a13 := JTF_VARCHAR2_TABLE_100();

105: a9 := JTF_DATE_TABLE();
106: a10 := JTF_DATE_TABLE();
107: a11 := JTF_DATE_TABLE();
108: a12 := JTF_VARCHAR2_TABLE_100();
109: a13 := JTF_VARCHAR2_TABLE_100();
110: a14 := JTF_NUMBER_TABLE();
111: a15 := JTF_NUMBER_TABLE();
112: a16 := JTF_NUMBER_TABLE();
113: a17 := JTF_VARCHAR2_TABLE_100();

Line 113: a17 := JTF_VARCHAR2_TABLE_100();

109: a13 := JTF_VARCHAR2_TABLE_100();
110: a14 := JTF_NUMBER_TABLE();
111: a15 := JTF_NUMBER_TABLE();
112: a16 := JTF_NUMBER_TABLE();
113: a17 := JTF_VARCHAR2_TABLE_100();
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_VARCHAR2_TABLE_100();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_100();

Line 115: a19 := JTF_VARCHAR2_TABLE_100();

111: a15 := JTF_NUMBER_TABLE();
112: a16 := JTF_NUMBER_TABLE();
113: a17 := JTF_VARCHAR2_TABLE_100();
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_VARCHAR2_TABLE_100();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_100();
118: a22 := JTF_VARCHAR2_TABLE_100();
119: a23 := JTF_NUMBER_TABLE();

Line 116: a20 := JTF_VARCHAR2_TABLE_100();

112: a16 := JTF_NUMBER_TABLE();
113: a17 := JTF_VARCHAR2_TABLE_100();
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_VARCHAR2_TABLE_100();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_100();
118: a22 := JTF_VARCHAR2_TABLE_100();
119: a23 := JTF_NUMBER_TABLE();
120: else

Line 117: a21 := JTF_VARCHAR2_TABLE_100();

113: a17 := JTF_VARCHAR2_TABLE_100();
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_VARCHAR2_TABLE_100();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_100();
118: a22 := JTF_VARCHAR2_TABLE_100();
119: a23 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();

Line 118: a22 := JTF_VARCHAR2_TABLE_100();

114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_VARCHAR2_TABLE_100();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_100();
118: a22 := JTF_VARCHAR2_TABLE_100();
119: a23 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();

Line 123: a2 := JTF_VARCHAR2_TABLE_100();

119: a23 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_NUMBER_TABLE();
127: a6 := JTF_NUMBER_TABLE();

Line 124: a3 := JTF_VARCHAR2_TABLE_100();

120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_NUMBER_TABLE();
127: a6 := JTF_NUMBER_TABLE();
128: a7 := JTF_NUMBER_TABLE();

Line 133: a12 := JTF_VARCHAR2_TABLE_100();

129: a8 := JTF_DATE_TABLE();
130: a9 := JTF_DATE_TABLE();
131: a10 := JTF_DATE_TABLE();
132: a11 := JTF_DATE_TABLE();
133: a12 := JTF_VARCHAR2_TABLE_100();
134: a13 := JTF_VARCHAR2_TABLE_100();
135: a14 := JTF_NUMBER_TABLE();
136: a15 := JTF_NUMBER_TABLE();
137: a16 := JTF_NUMBER_TABLE();

Line 134: a13 := JTF_VARCHAR2_TABLE_100();

130: a9 := JTF_DATE_TABLE();
131: a10 := JTF_DATE_TABLE();
132: a11 := JTF_DATE_TABLE();
133: a12 := JTF_VARCHAR2_TABLE_100();
134: a13 := JTF_VARCHAR2_TABLE_100();
135: a14 := JTF_NUMBER_TABLE();
136: a15 := JTF_NUMBER_TABLE();
137: a16 := JTF_NUMBER_TABLE();
138: a17 := JTF_VARCHAR2_TABLE_100();

Line 138: a17 := JTF_VARCHAR2_TABLE_100();

134: a13 := JTF_VARCHAR2_TABLE_100();
135: a14 := JTF_NUMBER_TABLE();
136: a15 := JTF_NUMBER_TABLE();
137: a16 := JTF_NUMBER_TABLE();
138: a17 := JTF_VARCHAR2_TABLE_100();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_VARCHAR2_TABLE_100();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_100();

Line 140: a19 := JTF_VARCHAR2_TABLE_100();

136: a15 := JTF_NUMBER_TABLE();
137: a16 := JTF_NUMBER_TABLE();
138: a17 := JTF_VARCHAR2_TABLE_100();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_VARCHAR2_TABLE_100();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_100();
143: a22 := JTF_VARCHAR2_TABLE_100();
144: a23 := JTF_NUMBER_TABLE();

Line 141: a20 := JTF_VARCHAR2_TABLE_100();

137: a16 := JTF_NUMBER_TABLE();
138: a17 := JTF_VARCHAR2_TABLE_100();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_VARCHAR2_TABLE_100();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_100();
143: a22 := JTF_VARCHAR2_TABLE_100();
144: a23 := JTF_NUMBER_TABLE();
145: if t.count > 0 then

Line 142: a21 := JTF_VARCHAR2_TABLE_100();

138: a17 := JTF_VARCHAR2_TABLE_100();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_VARCHAR2_TABLE_100();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_100();
143: a22 := JTF_VARCHAR2_TABLE_100();
144: a23 := JTF_NUMBER_TABLE();
145: if t.count > 0 then
146: a0.extend(t.count);

Line 143: a22 := JTF_VARCHAR2_TABLE_100();

139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_VARCHAR2_TABLE_100();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_100();
143: a22 := JTF_VARCHAR2_TABLE_100();
144: a23 := JTF_NUMBER_TABLE();
145: if t.count > 0 then
146: a0.extend(t.count);
147: a1.extend(t.count);

Line 210: , a3 JTF_VARCHAR2_TABLE_100

206:
207: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
208: , a1 JTF_NUMBER_TABLE
209: , a2 JTF_NUMBER_TABLE
210: , a3 JTF_VARCHAR2_TABLE_100
211: , a4 JTF_NUMBER_TABLE
212: , a5 JTF_NUMBER_TABLE
213: , a6 JTF_NUMBER_TABLE
214: , a7 JTF_VARCHAR2_TABLE_2000

Line 221: , a14 JTF_VARCHAR2_TABLE_100

217: , a10 JTF_DATE_TABLE
218: , a11 JTF_DATE_TABLE
219: , a12 JTF_DATE_TABLE
220: , a13 JTF_DATE_TABLE
221: , a14 JTF_VARCHAR2_TABLE_100
222: , a15 JTF_VARCHAR2_TABLE_100
223: ) as
224: ddindx binary_integer; indx binary_integer;
225: begin

Line 222: , a15 JTF_VARCHAR2_TABLE_100

218: , a11 JTF_DATE_TABLE
219: , a12 JTF_DATE_TABLE
220: , a13 JTF_DATE_TABLE
221: , a14 JTF_VARCHAR2_TABLE_100
222: , a15 JTF_VARCHAR2_TABLE_100
223: ) as
224: ddindx binary_integer; indx binary_integer;
225: begin
226: if a0 is not null and a0.count > 0 then

Line 259: , a3 out nocopy JTF_VARCHAR2_TABLE_100

255: end rosetta_table_copy_in_p3;
256: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
257: , a1 out nocopy JTF_NUMBER_TABLE
258: , a2 out nocopy JTF_NUMBER_TABLE
259: , a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , a4 out nocopy JTF_NUMBER_TABLE
261: , a5 out nocopy JTF_NUMBER_TABLE
262: , a6 out nocopy JTF_NUMBER_TABLE
263: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 270: , a14 out nocopy JTF_VARCHAR2_TABLE_100

266: , a10 out nocopy JTF_DATE_TABLE
267: , a11 out nocopy JTF_DATE_TABLE
268: , a12 out nocopy JTF_DATE_TABLE
269: , a13 out nocopy JTF_DATE_TABLE
270: , a14 out nocopy JTF_VARCHAR2_TABLE_100
271: , a15 out nocopy JTF_VARCHAR2_TABLE_100
272: ) as
273: ddindx binary_integer; indx binary_integer;
274: begin

Line 271: , a15 out nocopy JTF_VARCHAR2_TABLE_100

267: , a11 out nocopy JTF_DATE_TABLE
268: , a12 out nocopy JTF_DATE_TABLE
269: , a13 out nocopy JTF_DATE_TABLE
270: , a14 out nocopy JTF_VARCHAR2_TABLE_100
271: , a15 out nocopy JTF_VARCHAR2_TABLE_100
272: ) as
273: ddindx binary_integer; indx binary_integer;
274: begin
275: if t is null or t.count = 0 then

Line 279: a3 := JTF_VARCHAR2_TABLE_100();

275: if t is null or t.count = 0 then
276: a0 := JTF_NUMBER_TABLE();
277: a1 := JTF_NUMBER_TABLE();
278: a2 := JTF_NUMBER_TABLE();
279: a3 := JTF_VARCHAR2_TABLE_100();
280: a4 := JTF_NUMBER_TABLE();
281: a5 := JTF_NUMBER_TABLE();
282: a6 := JTF_NUMBER_TABLE();
283: a7 := JTF_VARCHAR2_TABLE_2000();

Line 290: a14 := JTF_VARCHAR2_TABLE_100();

286: a10 := JTF_DATE_TABLE();
287: a11 := JTF_DATE_TABLE();
288: a12 := JTF_DATE_TABLE();
289: a13 := JTF_DATE_TABLE();
290: a14 := JTF_VARCHAR2_TABLE_100();
291: a15 := JTF_VARCHAR2_TABLE_100();
292: else
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_NUMBER_TABLE();

Line 291: a15 := JTF_VARCHAR2_TABLE_100();

287: a11 := JTF_DATE_TABLE();
288: a12 := JTF_DATE_TABLE();
289: a13 := JTF_DATE_TABLE();
290: a14 := JTF_VARCHAR2_TABLE_100();
291: a15 := JTF_VARCHAR2_TABLE_100();
292: else
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_NUMBER_TABLE();
295: a2 := JTF_NUMBER_TABLE();

Line 296: a3 := JTF_VARCHAR2_TABLE_100();

292: else
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_NUMBER_TABLE();
295: a2 := JTF_NUMBER_TABLE();
296: a3 := JTF_VARCHAR2_TABLE_100();
297: a4 := JTF_NUMBER_TABLE();
298: a5 := JTF_NUMBER_TABLE();
299: a6 := JTF_NUMBER_TABLE();
300: a7 := JTF_VARCHAR2_TABLE_2000();

Line 307: a14 := JTF_VARCHAR2_TABLE_100();

303: a10 := JTF_DATE_TABLE();
304: a11 := JTF_DATE_TABLE();
305: a12 := JTF_DATE_TABLE();
306: a13 := JTF_DATE_TABLE();
307: a14 := JTF_VARCHAR2_TABLE_100();
308: a15 := JTF_VARCHAR2_TABLE_100();
309: if t.count > 0 then
310: a0.extend(t.count);
311: a1.extend(t.count);

Line 308: a15 := JTF_VARCHAR2_TABLE_100();

304: a11 := JTF_DATE_TABLE();
305: a12 := JTF_DATE_TABLE();
306: a13 := JTF_DATE_TABLE();
307: a14 := JTF_VARCHAR2_TABLE_100();
308: a15 := JTF_VARCHAR2_TABLE_100();
309: if t.count > 0 then
310: a0.extend(t.count);
311: a1.extend(t.count);
312: a2.extend(t.count);

Line 357: , a2 JTF_VARCHAR2_TABLE_100

353: end rosetta_table_copy_out_p3;
354:
355: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
356: , a1 JTF_NUMBER_TABLE
357: , a2 JTF_VARCHAR2_TABLE_100
358: , a3 JTF_VARCHAR2_TABLE_100
359: , a4 JTF_NUMBER_TABLE
360: , a5 JTF_NUMBER_TABLE
361: , a6 JTF_VARCHAR2_TABLE_100

Line 358: , a3 JTF_VARCHAR2_TABLE_100

354:
355: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
356: , a1 JTF_NUMBER_TABLE
357: , a2 JTF_VARCHAR2_TABLE_100
358: , a3 JTF_VARCHAR2_TABLE_100
359: , a4 JTF_NUMBER_TABLE
360: , a5 JTF_NUMBER_TABLE
361: , a6 JTF_VARCHAR2_TABLE_100
362: , a7 JTF_VARCHAR2_TABLE_200

Line 361: , a6 JTF_VARCHAR2_TABLE_100

357: , a2 JTF_VARCHAR2_TABLE_100
358: , a3 JTF_VARCHAR2_TABLE_100
359: , a4 JTF_NUMBER_TABLE
360: , a5 JTF_NUMBER_TABLE
361: , a6 JTF_VARCHAR2_TABLE_100
362: , a7 JTF_VARCHAR2_TABLE_200
363: , a8 JTF_NUMBER_TABLE
364: , a9 JTF_NUMBER_TABLE
365: , a10 JTF_NUMBER_TABLE

Line 398: , a2 out nocopy JTF_VARCHAR2_TABLE_100

394: end if;
395: end rosetta_table_copy_in_p7;
396: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_NUMBER_TABLE
398: , a2 out nocopy JTF_VARCHAR2_TABLE_100
399: , a3 out nocopy JTF_VARCHAR2_TABLE_100
400: , a4 out nocopy JTF_NUMBER_TABLE
401: , a5 out nocopy JTF_NUMBER_TABLE
402: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 399: , a3 out nocopy JTF_VARCHAR2_TABLE_100

395: end rosetta_table_copy_in_p7;
396: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_NUMBER_TABLE
398: , a2 out nocopy JTF_VARCHAR2_TABLE_100
399: , a3 out nocopy JTF_VARCHAR2_TABLE_100
400: , a4 out nocopy JTF_NUMBER_TABLE
401: , a5 out nocopy JTF_NUMBER_TABLE
402: , a6 out nocopy JTF_VARCHAR2_TABLE_100
403: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 402: , a6 out nocopy JTF_VARCHAR2_TABLE_100

398: , a2 out nocopy JTF_VARCHAR2_TABLE_100
399: , a3 out nocopy JTF_VARCHAR2_TABLE_100
400: , a4 out nocopy JTF_NUMBER_TABLE
401: , a5 out nocopy JTF_NUMBER_TABLE
402: , a6 out nocopy JTF_VARCHAR2_TABLE_100
403: , a7 out nocopy JTF_VARCHAR2_TABLE_200
404: , a8 out nocopy JTF_NUMBER_TABLE
405: , a9 out nocopy JTF_NUMBER_TABLE
406: , a10 out nocopy JTF_NUMBER_TABLE

Line 414: a2 := JTF_VARCHAR2_TABLE_100();

410: begin
411: if t is null or t.count = 0 then
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_NUMBER_TABLE();
414: a2 := JTF_VARCHAR2_TABLE_100();
415: a3 := JTF_VARCHAR2_TABLE_100();
416: a4 := JTF_NUMBER_TABLE();
417: a5 := JTF_NUMBER_TABLE();
418: a6 := JTF_VARCHAR2_TABLE_100();

Line 415: a3 := JTF_VARCHAR2_TABLE_100();

411: if t is null or t.count = 0 then
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_NUMBER_TABLE();
414: a2 := JTF_VARCHAR2_TABLE_100();
415: a3 := JTF_VARCHAR2_TABLE_100();
416: a4 := JTF_NUMBER_TABLE();
417: a5 := JTF_NUMBER_TABLE();
418: a6 := JTF_VARCHAR2_TABLE_100();
419: a7 := JTF_VARCHAR2_TABLE_200();

Line 418: a6 := JTF_VARCHAR2_TABLE_100();

414: a2 := JTF_VARCHAR2_TABLE_100();
415: a3 := JTF_VARCHAR2_TABLE_100();
416: a4 := JTF_NUMBER_TABLE();
417: a5 := JTF_NUMBER_TABLE();
418: a6 := JTF_VARCHAR2_TABLE_100();
419: a7 := JTF_VARCHAR2_TABLE_200();
420: a8 := JTF_NUMBER_TABLE();
421: a9 := JTF_NUMBER_TABLE();
422: a10 := JTF_NUMBER_TABLE();

Line 427: a2 := JTF_VARCHAR2_TABLE_100();

423: a11 := JTF_DATE_TABLE();
424: else
425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_NUMBER_TABLE();
427: a2 := JTF_VARCHAR2_TABLE_100();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: a4 := JTF_NUMBER_TABLE();
430: a5 := JTF_NUMBER_TABLE();
431: a6 := JTF_VARCHAR2_TABLE_100();

Line 428: a3 := JTF_VARCHAR2_TABLE_100();

424: else
425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_NUMBER_TABLE();
427: a2 := JTF_VARCHAR2_TABLE_100();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: a4 := JTF_NUMBER_TABLE();
430: a5 := JTF_NUMBER_TABLE();
431: a6 := JTF_VARCHAR2_TABLE_100();
432: a7 := JTF_VARCHAR2_TABLE_200();

Line 431: a6 := JTF_VARCHAR2_TABLE_100();

427: a2 := JTF_VARCHAR2_TABLE_100();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: a4 := JTF_NUMBER_TABLE();
430: a5 := JTF_NUMBER_TABLE();
431: a6 := JTF_VARCHAR2_TABLE_100();
432: a7 := JTF_VARCHAR2_TABLE_200();
433: a8 := JTF_NUMBER_TABLE();
434: a9 := JTF_NUMBER_TABLE();
435: a10 := JTF_NUMBER_TABLE();

Line 481: , a6 JTF_VARCHAR2_TABLE_100

477: , a2 JTF_NUMBER_TABLE
478: , a3 JTF_NUMBER_TABLE
479: , a4 JTF_NUMBER_TABLE
480: , a5 JTF_NUMBER_TABLE
481: , a6 JTF_VARCHAR2_TABLE_100
482: , a7 JTF_NUMBER_TABLE
483: ) as
484: ddindx binary_integer; indx binary_integer;
485: begin

Line 514: , a6 out nocopy JTF_VARCHAR2_TABLE_100

510: , a2 out nocopy JTF_NUMBER_TABLE
511: , a3 out nocopy JTF_NUMBER_TABLE
512: , a4 out nocopy JTF_NUMBER_TABLE
513: , a5 out nocopy JTF_NUMBER_TABLE
514: , a6 out nocopy JTF_VARCHAR2_TABLE_100
515: , a7 out nocopy JTF_NUMBER_TABLE
516: ) as
517: ddindx binary_integer; indx binary_integer;
518: begin

Line 526: a6 := JTF_VARCHAR2_TABLE_100();

522: a2 := JTF_NUMBER_TABLE();
523: a3 := JTF_NUMBER_TABLE();
524: a4 := JTF_NUMBER_TABLE();
525: a5 := JTF_NUMBER_TABLE();
526: a6 := JTF_VARCHAR2_TABLE_100();
527: a7 := JTF_NUMBER_TABLE();
528: else
529: a0 := JTF_NUMBER_TABLE();
530: a1 := JTF_NUMBER_TABLE();

Line 535: a6 := JTF_VARCHAR2_TABLE_100();

531: a2 := JTF_NUMBER_TABLE();
532: a3 := JTF_NUMBER_TABLE();
533: a4 := JTF_NUMBER_TABLE();
534: a5 := JTF_NUMBER_TABLE();
535: a6 := JTF_VARCHAR2_TABLE_100();
536: a7 := JTF_NUMBER_TABLE();
537: if t.count > 0 then
538: a0.extend(t.count);
539: a1.extend(t.count);

Line 609: , a1 JTF_VARCHAR2_TABLE_100

605: end if;
606: end rosetta_table_copy_out_p10;
607:
608: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
609: , a1 JTF_VARCHAR2_TABLE_100
610: , a2 JTF_NUMBER_TABLE
611: , a3 JTF_NUMBER_TABLE
612: , a4 JTF_NUMBER_TABLE
613: , a5 JTF_NUMBER_TABLE

Line 616: , a8 JTF_VARCHAR2_TABLE_100

612: , a4 JTF_NUMBER_TABLE
613: , a5 JTF_NUMBER_TABLE
614: , a6 JTF_NUMBER_TABLE
615: , a7 JTF_NUMBER_TABLE
616: , a8 JTF_VARCHAR2_TABLE_100
617: , a9 JTF_NUMBER_TABLE
618: , a10 JTF_NUMBER_TABLE
619: ) as
620: ddindx binary_integer; indx binary_integer;

Line 648: , a1 out nocopy JTF_VARCHAR2_TABLE_100

644: end if;
645: end if;
646: end rosetta_table_copy_in_p18;
647: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
648: , a1 out nocopy JTF_VARCHAR2_TABLE_100
649: , a2 out nocopy JTF_NUMBER_TABLE
650: , a3 out nocopy JTF_NUMBER_TABLE
651: , a4 out nocopy JTF_NUMBER_TABLE
652: , a5 out nocopy JTF_NUMBER_TABLE

Line 655: , a8 out nocopy JTF_VARCHAR2_TABLE_100

651: , a4 out nocopy JTF_NUMBER_TABLE
652: , a5 out nocopy JTF_NUMBER_TABLE
653: , a6 out nocopy JTF_NUMBER_TABLE
654: , a7 out nocopy JTF_NUMBER_TABLE
655: , a8 out nocopy JTF_VARCHAR2_TABLE_100
656: , a9 out nocopy JTF_NUMBER_TABLE
657: , a10 out nocopy JTF_NUMBER_TABLE
658: ) as
659: ddindx binary_integer; indx binary_integer;

Line 663: a1 := JTF_VARCHAR2_TABLE_100();

659: ddindx binary_integer; indx binary_integer;
660: begin
661: if t is null or t.count = 0 then
662: a0 := JTF_NUMBER_TABLE();
663: a1 := JTF_VARCHAR2_TABLE_100();
664: a2 := JTF_NUMBER_TABLE();
665: a3 := JTF_NUMBER_TABLE();
666: a4 := JTF_NUMBER_TABLE();
667: a5 := JTF_NUMBER_TABLE();

Line 670: a8 := JTF_VARCHAR2_TABLE_100();

666: a4 := JTF_NUMBER_TABLE();
667: a5 := JTF_NUMBER_TABLE();
668: a6 := JTF_NUMBER_TABLE();
669: a7 := JTF_NUMBER_TABLE();
670: a8 := JTF_VARCHAR2_TABLE_100();
671: a9 := JTF_NUMBER_TABLE();
672: a10 := JTF_NUMBER_TABLE();
673: else
674: a0 := JTF_NUMBER_TABLE();

Line 675: a1 := JTF_VARCHAR2_TABLE_100();

671: a9 := JTF_NUMBER_TABLE();
672: a10 := JTF_NUMBER_TABLE();
673: else
674: a0 := JTF_NUMBER_TABLE();
675: a1 := JTF_VARCHAR2_TABLE_100();
676: a2 := JTF_NUMBER_TABLE();
677: a3 := JTF_NUMBER_TABLE();
678: a4 := JTF_NUMBER_TABLE();
679: a5 := JTF_NUMBER_TABLE();

Line 682: a8 := JTF_VARCHAR2_TABLE_100();

678: a4 := JTF_NUMBER_TABLE();
679: a5 := JTF_NUMBER_TABLE();
680: a6 := JTF_NUMBER_TABLE();
681: a7 := JTF_NUMBER_TABLE();
682: a8 := JTF_VARCHAR2_TABLE_100();
683: a9 := JTF_NUMBER_TABLE();
684: a10 := JTF_NUMBER_TABLE();
685: if t.count > 0 then
686: a0.extend(t.count);

Line 956: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100

952: , x_msg_data out nocopy VARCHAR2
953: , p3_a0 in out nocopy JTF_NUMBER_TABLE
954: , p3_a1 in out nocopy JTF_NUMBER_TABLE
955: , p3_a2 in out nocopy JTF_NUMBER_TABLE
956: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
957: , p3_a4 in out nocopy JTF_NUMBER_TABLE
958: , p3_a5 in out nocopy JTF_NUMBER_TABLE
959: , p3_a6 in out nocopy JTF_NUMBER_TABLE
960: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 967: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100

963: , p3_a10 in out nocopy JTF_DATE_TABLE
964: , p3_a11 in out nocopy JTF_DATE_TABLE
965: , p3_a12 in out nocopy JTF_DATE_TABLE
966: , p3_a13 in out nocopy JTF_DATE_TABLE
967: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
968: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
969: )
970:
971: as

Line 968: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100

964: , p3_a11 in out nocopy JTF_DATE_TABLE
965: , p3_a12 in out nocopy JTF_DATE_TABLE
966: , p3_a13 in out nocopy JTF_DATE_TABLE
967: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
968: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
969: )
970:
971: as
972: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;

Line 1031: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100

1027: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
1028: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1029: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1030: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1031: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1033: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1034: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 1042: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100

1038: , p1_a10 in out nocopy JTF_DATE_TABLE
1039: , p1_a11 in out nocopy JTF_DATE_TABLE
1040: , p1_a12 in out nocopy JTF_DATE_TABLE
1041: , p1_a13 in out nocopy JTF_DATE_TABLE
1042: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1044: )
1045:
1046: as

Line 1043: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100

1039: , p1_a11 in out nocopy JTF_DATE_TABLE
1040: , p1_a12 in out nocopy JTF_DATE_TABLE
1041: , p1_a13 in out nocopy JTF_DATE_TABLE
1042: , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043: , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1044: )
1045:
1046: as
1047: ddp_x_operation_tbl ahl_completions_pvt.operation_tbl_type;