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_RA_NR_PROFILE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_VARCHAR2_TABLE_100

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

Line 16: , a13 JTF_VARCHAR2_TABLE_100

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

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_300
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_200

Line 26: , a23 JTF_VARCHAR2_TABLE_100

22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE

Line 27: , a24 JTF_VARCHAR2_TABLE_100

23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100

Line 31: , a28 JTF_VARCHAR2_TABLE_100

27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: ) as
34: ddindx binary_integer; indx binary_integer;
35: begin

Line 32: , a29 JTF_VARCHAR2_TABLE_100

28: , a25 JTF_DATE_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: ) as
34: ddindx binary_integer; indx binary_integer;
35: begin
36: if a0 is not null and a0.count > 0 then

Line 88: , a8 out nocopy JTF_VARCHAR2_TABLE_100

84: , a4 out nocopy JTF_DATE_TABLE
85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_VARCHAR2_TABLE_100
89: , a9 out nocopy JTF_VARCHAR2_TABLE_100
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_VARCHAR2_TABLE_300
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 89: , a9 out nocopy JTF_VARCHAR2_TABLE_100

85: , a5 out nocopy JTF_NUMBER_TABLE
86: , a6 out nocopy JTF_NUMBER_TABLE
87: , a7 out nocopy JTF_NUMBER_TABLE
88: , a8 out nocopy JTF_VARCHAR2_TABLE_100
89: , a9 out nocopy JTF_VARCHAR2_TABLE_100
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_VARCHAR2_TABLE_300
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 92: , a12 out nocopy JTF_VARCHAR2_TABLE_100

88: , a8 out nocopy JTF_VARCHAR2_TABLE_100
89: , a9 out nocopy JTF_VARCHAR2_TABLE_100
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_VARCHAR2_TABLE_300
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_VARCHAR2_TABLE_100
94: , a14 out nocopy JTF_NUMBER_TABLE
95: , a15 out nocopy JTF_VARCHAR2_TABLE_300
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 93: , a13 out nocopy JTF_VARCHAR2_TABLE_100

89: , a9 out nocopy JTF_VARCHAR2_TABLE_100
90: , a10 out nocopy JTF_NUMBER_TABLE
91: , a11 out nocopy JTF_VARCHAR2_TABLE_300
92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_VARCHAR2_TABLE_100
94: , a14 out nocopy JTF_NUMBER_TABLE
95: , a15 out nocopy JTF_VARCHAR2_TABLE_300
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_NUMBER_TABLE

Line 96: , a16 out nocopy JTF_VARCHAR2_TABLE_100

92: , a12 out nocopy JTF_VARCHAR2_TABLE_100
93: , a13 out nocopy JTF_VARCHAR2_TABLE_100
94: , a14 out nocopy JTF_NUMBER_TABLE
95: , a15 out nocopy JTF_VARCHAR2_TABLE_300
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_NUMBER_TABLE
98: , a18 out nocopy JTF_NUMBER_TABLE
99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_VARCHAR2_TABLE_200

Line 103: , a23 out nocopy JTF_VARCHAR2_TABLE_100

99: , a19 out nocopy JTF_NUMBER_TABLE
100: , a20 out nocopy JTF_VARCHAR2_TABLE_200
101: , a21 out nocopy JTF_NUMBER_TABLE
102: , a22 out nocopy JTF_VARCHAR2_TABLE_200
103: , a23 out nocopy JTF_VARCHAR2_TABLE_100
104: , a24 out nocopy JTF_VARCHAR2_TABLE_100
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_NUMBER_TABLE

Line 104: , a24 out nocopy JTF_VARCHAR2_TABLE_100

100: , a20 out nocopy JTF_VARCHAR2_TABLE_200
101: , a21 out nocopy JTF_NUMBER_TABLE
102: , a22 out nocopy JTF_VARCHAR2_TABLE_200
103: , a23 out nocopy JTF_VARCHAR2_TABLE_100
104: , a24 out nocopy JTF_VARCHAR2_TABLE_100
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_NUMBER_TABLE
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a28 out nocopy JTF_VARCHAR2_TABLE_100

104: , a24 out nocopy JTF_VARCHAR2_TABLE_100
105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_NUMBER_TABLE
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin

Line 109: , a29 out nocopy JTF_VARCHAR2_TABLE_100

105: , a25 out nocopy JTF_DATE_TABLE
106: , a26 out nocopy JTF_DATE_TABLE
107: , a27 out nocopy JTF_NUMBER_TABLE
108: , a28 out nocopy JTF_VARCHAR2_TABLE_100
109: , a29 out nocopy JTF_VARCHAR2_TABLE_100
110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin
113: if t is null or t.count = 0 then

Line 122: a8 := JTF_VARCHAR2_TABLE_100();

118: a4 := JTF_DATE_TABLE();
119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_VARCHAR2_TABLE_100();
123: a9 := JTF_VARCHAR2_TABLE_100();
124: a10 := JTF_NUMBER_TABLE();
125: a11 := JTF_VARCHAR2_TABLE_300();
126: a12 := JTF_VARCHAR2_TABLE_100();

Line 123: a9 := JTF_VARCHAR2_TABLE_100();

119: a5 := JTF_NUMBER_TABLE();
120: a6 := JTF_NUMBER_TABLE();
121: a7 := JTF_NUMBER_TABLE();
122: a8 := JTF_VARCHAR2_TABLE_100();
123: a9 := JTF_VARCHAR2_TABLE_100();
124: a10 := JTF_NUMBER_TABLE();
125: a11 := JTF_VARCHAR2_TABLE_300();
126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_VARCHAR2_TABLE_100();

Line 126: a12 := JTF_VARCHAR2_TABLE_100();

122: a8 := JTF_VARCHAR2_TABLE_100();
123: a9 := JTF_VARCHAR2_TABLE_100();
124: a10 := JTF_NUMBER_TABLE();
125: a11 := JTF_VARCHAR2_TABLE_300();
126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_VARCHAR2_TABLE_100();
128: a14 := JTF_NUMBER_TABLE();
129: a15 := JTF_VARCHAR2_TABLE_300();
130: a16 := JTF_VARCHAR2_TABLE_100();

Line 127: a13 := JTF_VARCHAR2_TABLE_100();

123: a9 := JTF_VARCHAR2_TABLE_100();
124: a10 := JTF_NUMBER_TABLE();
125: a11 := JTF_VARCHAR2_TABLE_300();
126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_VARCHAR2_TABLE_100();
128: a14 := JTF_NUMBER_TABLE();
129: a15 := JTF_VARCHAR2_TABLE_300();
130: a16 := JTF_VARCHAR2_TABLE_100();
131: a17 := JTF_NUMBER_TABLE();

Line 130: a16 := JTF_VARCHAR2_TABLE_100();

126: a12 := JTF_VARCHAR2_TABLE_100();
127: a13 := JTF_VARCHAR2_TABLE_100();
128: a14 := JTF_NUMBER_TABLE();
129: a15 := JTF_VARCHAR2_TABLE_300();
130: a16 := JTF_VARCHAR2_TABLE_100();
131: a17 := JTF_NUMBER_TABLE();
132: a18 := JTF_NUMBER_TABLE();
133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_VARCHAR2_TABLE_200();

Line 137: a23 := JTF_VARCHAR2_TABLE_100();

133: a19 := JTF_NUMBER_TABLE();
134: a20 := JTF_VARCHAR2_TABLE_200();
135: a21 := JTF_NUMBER_TABLE();
136: a22 := JTF_VARCHAR2_TABLE_200();
137: a23 := JTF_VARCHAR2_TABLE_100();
138: a24 := JTF_VARCHAR2_TABLE_100();
139: a25 := JTF_DATE_TABLE();
140: a26 := JTF_DATE_TABLE();
141: a27 := JTF_NUMBER_TABLE();

Line 138: a24 := JTF_VARCHAR2_TABLE_100();

134: a20 := JTF_VARCHAR2_TABLE_200();
135: a21 := JTF_NUMBER_TABLE();
136: a22 := JTF_VARCHAR2_TABLE_200();
137: a23 := JTF_VARCHAR2_TABLE_100();
138: a24 := JTF_VARCHAR2_TABLE_100();
139: a25 := JTF_DATE_TABLE();
140: a26 := JTF_DATE_TABLE();
141: a27 := JTF_NUMBER_TABLE();
142: a28 := JTF_VARCHAR2_TABLE_100();

Line 142: a28 := JTF_VARCHAR2_TABLE_100();

138: a24 := JTF_VARCHAR2_TABLE_100();
139: a25 := JTF_DATE_TABLE();
140: a26 := JTF_DATE_TABLE();
141: a27 := JTF_NUMBER_TABLE();
142: a28 := JTF_VARCHAR2_TABLE_100();
143: a29 := JTF_VARCHAR2_TABLE_100();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();

Line 143: a29 := JTF_VARCHAR2_TABLE_100();

139: a25 := JTF_DATE_TABLE();
140: a26 := JTF_DATE_TABLE();
141: a27 := JTF_NUMBER_TABLE();
142: a28 := JTF_VARCHAR2_TABLE_100();
143: a29 := JTF_VARCHAR2_TABLE_100();
144: else
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_NUMBER_TABLE();
147: a2 := JTF_DATE_TABLE();

Line 153: a8 := JTF_VARCHAR2_TABLE_100();

149: a4 := JTF_DATE_TABLE();
150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_VARCHAR2_TABLE_100();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_VARCHAR2_TABLE_300();
157: a12 := JTF_VARCHAR2_TABLE_100();

Line 154: a9 := JTF_VARCHAR2_TABLE_100();

150: a5 := JTF_NUMBER_TABLE();
151: a6 := JTF_NUMBER_TABLE();
152: a7 := JTF_NUMBER_TABLE();
153: a8 := JTF_VARCHAR2_TABLE_100();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_VARCHAR2_TABLE_300();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();

Line 157: a12 := JTF_VARCHAR2_TABLE_100();

153: a8 := JTF_VARCHAR2_TABLE_100();
154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_VARCHAR2_TABLE_300();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
159: a14 := JTF_NUMBER_TABLE();
160: a15 := JTF_VARCHAR2_TABLE_300();
161: a16 := JTF_VARCHAR2_TABLE_100();

Line 158: a13 := JTF_VARCHAR2_TABLE_100();

154: a9 := JTF_VARCHAR2_TABLE_100();
155: a10 := JTF_NUMBER_TABLE();
156: a11 := JTF_VARCHAR2_TABLE_300();
157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
159: a14 := JTF_NUMBER_TABLE();
160: a15 := JTF_VARCHAR2_TABLE_300();
161: a16 := JTF_VARCHAR2_TABLE_100();
162: a17 := JTF_NUMBER_TABLE();

Line 161: a16 := JTF_VARCHAR2_TABLE_100();

157: a12 := JTF_VARCHAR2_TABLE_100();
158: a13 := JTF_VARCHAR2_TABLE_100();
159: a14 := JTF_NUMBER_TABLE();
160: a15 := JTF_VARCHAR2_TABLE_300();
161: a16 := JTF_VARCHAR2_TABLE_100();
162: a17 := JTF_NUMBER_TABLE();
163: a18 := JTF_NUMBER_TABLE();
164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_VARCHAR2_TABLE_200();

Line 168: a23 := JTF_VARCHAR2_TABLE_100();

164: a19 := JTF_NUMBER_TABLE();
165: a20 := JTF_VARCHAR2_TABLE_200();
166: a21 := JTF_NUMBER_TABLE();
167: a22 := JTF_VARCHAR2_TABLE_200();
168: a23 := JTF_VARCHAR2_TABLE_100();
169: a24 := JTF_VARCHAR2_TABLE_100();
170: a25 := JTF_DATE_TABLE();
171: a26 := JTF_DATE_TABLE();
172: a27 := JTF_NUMBER_TABLE();

Line 169: a24 := JTF_VARCHAR2_TABLE_100();

165: a20 := JTF_VARCHAR2_TABLE_200();
166: a21 := JTF_NUMBER_TABLE();
167: a22 := JTF_VARCHAR2_TABLE_200();
168: a23 := JTF_VARCHAR2_TABLE_100();
169: a24 := JTF_VARCHAR2_TABLE_100();
170: a25 := JTF_DATE_TABLE();
171: a26 := JTF_DATE_TABLE();
172: a27 := JTF_NUMBER_TABLE();
173: a28 := JTF_VARCHAR2_TABLE_100();

Line 173: a28 := JTF_VARCHAR2_TABLE_100();

169: a24 := JTF_VARCHAR2_TABLE_100();
170: a25 := JTF_DATE_TABLE();
171: a26 := JTF_DATE_TABLE();
172: a27 := JTF_NUMBER_TABLE();
173: a28 := JTF_VARCHAR2_TABLE_100();
174: a29 := JTF_VARCHAR2_TABLE_100();
175: if t.count > 0 then
176: a0.extend(t.count);
177: a1.extend(t.count);

Line 174: a29 := JTF_VARCHAR2_TABLE_100();

170: a25 := JTF_DATE_TABLE();
171: a26 := JTF_DATE_TABLE();
172: a27 := JTF_NUMBER_TABLE();
173: a28 := JTF_VARCHAR2_TABLE_100();
174: a29 := JTF_VARCHAR2_TABLE_100();
175: if t.count > 0 then
176: a0.extend(t.count);
177: a1.extend(t.count);
178: a2.extend(t.count);

Line 252: , a3 JTF_VARCHAR2_TABLE_100

248:
249: procedure rosetta_table_copy_in_p6(t out nocopy ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type, a0 JTF_NUMBER_TABLE
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_VARCHAR2_TABLE_100
253: ) as
254: ddindx binary_integer; indx binary_integer;
255: begin
256: if a0 is not null and a0.count > 0 then

Line 277: , a3 out nocopy JTF_VARCHAR2_TABLE_100

273: end rosetta_table_copy_in_p6;
274: procedure rosetta_table_copy_out_p6(t ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
275: , a1 out nocopy JTF_NUMBER_TABLE
276: , a2 out nocopy JTF_NUMBER_TABLE
277: , a3 out nocopy JTF_VARCHAR2_TABLE_100
278: ) as
279: ddindx binary_integer; indx binary_integer;
280: begin
281: if t is null or t.count = 0 then

Line 285: a3 := JTF_VARCHAR2_TABLE_100();

281: if t is null or t.count = 0 then
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_NUMBER_TABLE();
285: a3 := JTF_VARCHAR2_TABLE_100();
286: else
287: a0 := JTF_NUMBER_TABLE();
288: a1 := JTF_NUMBER_TABLE();
289: a2 := JTF_NUMBER_TABLE();

Line 290: a3 := JTF_VARCHAR2_TABLE_100();

286: else
287: a0 := JTF_NUMBER_TABLE();
288: a1 := JTF_NUMBER_TABLE();
289: a2 := JTF_NUMBER_TABLE();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: if t.count > 0 then
292: a0.extend(t.count);
293: a1.extend(t.count);
294: a2.extend(t.count);

Line 316: , a3 JTF_VARCHAR2_TABLE_100

312:
313: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type, a0 JTF_NUMBER_TABLE
314: , a1 JTF_NUMBER_TABLE
315: , a2 JTF_NUMBER_TABLE
316: , a3 JTF_VARCHAR2_TABLE_100
317: , a4 JTF_VARCHAR2_TABLE_100
318: ) as
319: ddindx binary_integer; indx binary_integer;
320: begin

Line 317: , a4 JTF_VARCHAR2_TABLE_100

313: procedure rosetta_table_copy_in_p8(t out nocopy ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type, a0 JTF_NUMBER_TABLE
314: , a1 JTF_NUMBER_TABLE
315: , a2 JTF_NUMBER_TABLE
316: , a3 JTF_VARCHAR2_TABLE_100
317: , a4 JTF_VARCHAR2_TABLE_100
318: ) as
319: ddindx binary_integer; indx binary_integer;
320: begin
321: if a0 is not null and a0.count > 0 then

Line 343: , a3 out nocopy JTF_VARCHAR2_TABLE_100

339: end rosetta_table_copy_in_p8;
340: procedure rosetta_table_copy_out_p8(t ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
341: , a1 out nocopy JTF_NUMBER_TABLE
342: , a2 out nocopy JTF_NUMBER_TABLE
343: , a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , a4 out nocopy JTF_VARCHAR2_TABLE_100
345: ) as
346: ddindx binary_integer; indx binary_integer;
347: begin

Line 344: , a4 out nocopy JTF_VARCHAR2_TABLE_100

340: procedure rosetta_table_copy_out_p8(t ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
341: , a1 out nocopy JTF_NUMBER_TABLE
342: , a2 out nocopy JTF_NUMBER_TABLE
343: , a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , a4 out nocopy JTF_VARCHAR2_TABLE_100
345: ) as
346: ddindx binary_integer; indx binary_integer;
347: begin
348: if t is null or t.count = 0 then

Line 352: a3 := JTF_VARCHAR2_TABLE_100();

348: if t is null or t.count = 0 then
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_VARCHAR2_TABLE_100();
353: a4 := JTF_VARCHAR2_TABLE_100();
354: else
355: a0 := JTF_NUMBER_TABLE();
356: a1 := JTF_NUMBER_TABLE();

Line 353: a4 := JTF_VARCHAR2_TABLE_100();

349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_NUMBER_TABLE();
351: a2 := JTF_NUMBER_TABLE();
352: a3 := JTF_VARCHAR2_TABLE_100();
353: a4 := JTF_VARCHAR2_TABLE_100();
354: else
355: a0 := JTF_NUMBER_TABLE();
356: a1 := JTF_NUMBER_TABLE();
357: a2 := JTF_NUMBER_TABLE();

Line 358: a3 := JTF_VARCHAR2_TABLE_100();

354: else
355: a0 := JTF_NUMBER_TABLE();
356: a1 := JTF_NUMBER_TABLE();
357: a2 := JTF_NUMBER_TABLE();
358: a3 := JTF_VARCHAR2_TABLE_100();
359: a4 := JTF_VARCHAR2_TABLE_100();
360: if t.count > 0 then
361: a0.extend(t.count);
362: a1.extend(t.count);

Line 359: a4 := JTF_VARCHAR2_TABLE_100();

355: a0 := JTF_NUMBER_TABLE();
356: a1 := JTF_NUMBER_TABLE();
357: a2 := JTF_NUMBER_TABLE();
358: a3 := JTF_VARCHAR2_TABLE_100();
359: a4 := JTF_VARCHAR2_TABLE_100();
360: if t.count > 0 then
361: a0.extend(t.count);
362: a1.extend(t.count);
363: a2.extend(t.count);

Line 394: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

390: , x_msg_data out nocopy VARCHAR2
391: , p7_a0 out nocopy JTF_NUMBER_TABLE
392: , p7_a1 out nocopy JTF_NUMBER_TABLE
393: , p7_a2 out nocopy JTF_NUMBER_TABLE
394: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
395: )
396:
397: as
398: ddx_prof_res_req_tbl ahl_ra_nr_profile_pvt.nrp_res_req_tbl_type;

Line 446: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

442: , x_msg_data out nocopy VARCHAR2
443: , p7_a0 out nocopy JTF_NUMBER_TABLE
444: , p7_a1 out nocopy JTF_NUMBER_TABLE
445: , p7_a2 out nocopy JTF_NUMBER_TABLE
446: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
447: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
448: )
449:
450: as

Line 447: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

443: , p7_a0 out nocopy JTF_NUMBER_TABLE
444: , p7_a1 out nocopy JTF_NUMBER_TABLE
445: , p7_a2 out nocopy JTF_NUMBER_TABLE
446: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
447: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
448: )
449:
450: as
451: ddx_prof_mat_req_tbl ahl_ra_nr_profile_pvt.nrp_mat_req_tbl_type;

Line 635: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100

631: , p7_a4 in out nocopy JTF_DATE_TABLE
632: , p7_a5 in out nocopy JTF_NUMBER_TABLE
633: , p7_a6 in out nocopy JTF_NUMBER_TABLE
634: , p7_a7 in out nocopy JTF_NUMBER_TABLE
635: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100
636: , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p7_a10 in out nocopy JTF_NUMBER_TABLE
638: , p7_a11 in out nocopy JTF_VARCHAR2_TABLE_300
639: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 636: , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_100

632: , p7_a5 in out nocopy JTF_NUMBER_TABLE
633: , p7_a6 in out nocopy JTF_NUMBER_TABLE
634: , p7_a7 in out nocopy JTF_NUMBER_TABLE
635: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100
636: , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p7_a10 in out nocopy JTF_NUMBER_TABLE
638: , p7_a11 in out nocopy JTF_VARCHAR2_TABLE_300
639: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
640: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 639: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100

635: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100
636: , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p7_a10 in out nocopy JTF_NUMBER_TABLE
638: , p7_a11 in out nocopy JTF_VARCHAR2_TABLE_300
639: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
640: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
641: , p7_a14 in out nocopy JTF_NUMBER_TABLE
642: , p7_a15 in out nocopy JTF_VARCHAR2_TABLE_300
643: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 640: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100

636: , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_100
637: , p7_a10 in out nocopy JTF_NUMBER_TABLE
638: , p7_a11 in out nocopy JTF_VARCHAR2_TABLE_300
639: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
640: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
641: , p7_a14 in out nocopy JTF_NUMBER_TABLE
642: , p7_a15 in out nocopy JTF_VARCHAR2_TABLE_300
643: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
644: , p7_a17 in out nocopy JTF_NUMBER_TABLE

Line 643: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100

639: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
640: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
641: , p7_a14 in out nocopy JTF_NUMBER_TABLE
642: , p7_a15 in out nocopy JTF_VARCHAR2_TABLE_300
643: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
644: , p7_a17 in out nocopy JTF_NUMBER_TABLE
645: , p7_a18 in out nocopy JTF_NUMBER_TABLE
646: , p7_a19 in out nocopy JTF_NUMBER_TABLE
647: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200

Line 650: , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_100

646: , p7_a19 in out nocopy JTF_NUMBER_TABLE
647: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
648: , p7_a21 in out nocopy JTF_NUMBER_TABLE
649: , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_200
650: , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_100
651: , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_100
652: , p7_a25 in out nocopy JTF_DATE_TABLE
653: , p7_a26 in out nocopy JTF_DATE_TABLE
654: , p7_a27 in out nocopy JTF_NUMBER_TABLE

Line 651: , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_100

647: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
648: , p7_a21 in out nocopy JTF_NUMBER_TABLE
649: , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_200
650: , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_100
651: , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_100
652: , p7_a25 in out nocopy JTF_DATE_TABLE
653: , p7_a26 in out nocopy JTF_DATE_TABLE
654: , p7_a27 in out nocopy JTF_NUMBER_TABLE
655: , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_100

Line 655: , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_100

651: , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_100
652: , p7_a25 in out nocopy JTF_DATE_TABLE
653: , p7_a26 in out nocopy JTF_DATE_TABLE
654: , p7_a27 in out nocopy JTF_NUMBER_TABLE
655: , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_100
656: , p7_a29 in out nocopy JTF_VARCHAR2_TABLE_100
657: )
658:
659: as

Line 656: , p7_a29 in out nocopy JTF_VARCHAR2_TABLE_100

652: , p7_a25 in out nocopy JTF_DATE_TABLE
653: , p7_a26 in out nocopy JTF_DATE_TABLE
654: , p7_a27 in out nocopy JTF_NUMBER_TABLE
655: , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_100
656: , p7_a29 in out nocopy JTF_VARCHAR2_TABLE_100
657: )
658:
659: as
660: ddp_x_nr_prof_est_tbl ahl_ra_nr_profile_pvt.nr_prof_est_tbl_type;