APPS.AHL_SB_RULES_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_sb_rules_pvt.sb_rule_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_sb_rules_pvt_w as
2: /* $Header: AHLWSBRB.pls 120.0.12020000.2 2012/12/14 06:28:47 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_sb_rules_pvt.sb_rule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package body ahl_sb_rules_pvt_w as
2: /* $Header: AHLWSBRB.pls 120.0.12020000.2 2012/12/14 06:28:47 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_sb_rules_pvt.sb_rule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_sb_rules_pvt.sb_rule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

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

Line 12: , a9 JTF_NUMBER_TABLE

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

Line 13: , a10 JTF_NUMBER_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE

Line 14: , a11 JTF_NUMBER_TABLE

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

Line 15: , a12 JTF_NUMBER_TABLE

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

Line 18: , a15 JTF_NUMBER_TABLE

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200

Line 84: procedure rosetta_table_copy_out_p4(t ahl_sb_rules_pvt.sb_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

80: end loop;
81: end if;
82: end if;
83: end rosetta_table_copy_in_p4;
84: procedure rosetta_table_copy_out_p4(t ahl_sb_rules_pvt.sb_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_100
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_DATE_TABLE
88: , a4 out nocopy JTF_NUMBER_TABLE

Line 86: , a2 out nocopy JTF_NUMBER_TABLE

82: end if;
83: end rosetta_table_copy_in_p4;
84: procedure rosetta_table_copy_out_p4(t ahl_sb_rules_pvt.sb_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_100
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_DATE_TABLE
88: , a4 out nocopy JTF_NUMBER_TABLE
89: , a5 out nocopy JTF_DATE_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE

Line 88: , a4 out nocopy JTF_NUMBER_TABLE

84: procedure rosetta_table_copy_out_p4(t ahl_sb_rules_pvt.sb_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_100
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_DATE_TABLE
88: , a4 out nocopy JTF_NUMBER_TABLE
89: , a5 out nocopy JTF_DATE_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 90: , a6 out nocopy JTF_NUMBER_TABLE

86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_DATE_TABLE
88: , a4 out nocopy JTF_NUMBER_TABLE
89: , a5 out nocopy JTF_DATE_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_VARCHAR2_TABLE_100
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_NUMBER_TABLE

Line 91: , a7 out nocopy JTF_NUMBER_TABLE

87: , a3 out nocopy JTF_DATE_TABLE
88: , a4 out nocopy JTF_NUMBER_TABLE
89: , a5 out nocopy JTF_DATE_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_VARCHAR2_TABLE_100
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_NUMBER_TABLE
95: , a11 out nocopy JTF_NUMBER_TABLE

Line 93: , a9 out nocopy JTF_NUMBER_TABLE

89: , a5 out nocopy JTF_DATE_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_VARCHAR2_TABLE_100
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_NUMBER_TABLE
95: , a11 out nocopy JTF_NUMBER_TABLE
96: , a12 out nocopy JTF_NUMBER_TABLE
97: , a13 out nocopy JTF_DATE_TABLE

Line 94: , a10 out nocopy JTF_NUMBER_TABLE

90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_VARCHAR2_TABLE_100
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_NUMBER_TABLE
95: , a11 out nocopy JTF_NUMBER_TABLE
96: , a12 out nocopy JTF_NUMBER_TABLE
97: , a13 out nocopy JTF_DATE_TABLE
98: , a14 out nocopy JTF_DATE_TABLE

Line 95: , a11 out nocopy JTF_NUMBER_TABLE

91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_VARCHAR2_TABLE_100
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_NUMBER_TABLE
95: , a11 out nocopy JTF_NUMBER_TABLE
96: , a12 out nocopy JTF_NUMBER_TABLE
97: , a13 out nocopy JTF_DATE_TABLE
98: , a14 out nocopy JTF_DATE_TABLE
99: , a15 out nocopy JTF_NUMBER_TABLE

Line 96: , a12 out nocopy JTF_NUMBER_TABLE

92: , a8 out nocopy JTF_VARCHAR2_TABLE_100
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_NUMBER_TABLE
95: , a11 out nocopy JTF_NUMBER_TABLE
96: , a12 out nocopy JTF_NUMBER_TABLE
97: , a13 out nocopy JTF_DATE_TABLE
98: , a14 out nocopy JTF_DATE_TABLE
99: , a15 out nocopy JTF_NUMBER_TABLE
100: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 99: , a15 out nocopy JTF_NUMBER_TABLE

95: , a11 out nocopy JTF_NUMBER_TABLE
96: , a12 out nocopy JTF_NUMBER_TABLE
97: , a13 out nocopy JTF_DATE_TABLE
98: , a14 out nocopy JTF_DATE_TABLE
99: , a15 out nocopy JTF_NUMBER_TABLE
100: , a16 out nocopy JTF_VARCHAR2_TABLE_100
101: , a17 out nocopy JTF_VARCHAR2_TABLE_200
102: , a18 out nocopy JTF_VARCHAR2_TABLE_200
103: , a19 out nocopy JTF_VARCHAR2_TABLE_200

Line 120: a0 := JTF_NUMBER_TABLE();

116: ) as
117: ddindx binary_integer; indx binary_integer;
118: begin
119: if t is null or t.count = 0 then
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_VARCHAR2_TABLE_100();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_DATE_TABLE();
124: a4 := JTF_NUMBER_TABLE();

Line 122: a2 := JTF_NUMBER_TABLE();

118: begin
119: if t is null or t.count = 0 then
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_VARCHAR2_TABLE_100();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_DATE_TABLE();
124: a4 := JTF_NUMBER_TABLE();
125: a5 := JTF_DATE_TABLE();
126: a6 := JTF_NUMBER_TABLE();

Line 124: a4 := JTF_NUMBER_TABLE();

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

Line 126: a6 := JTF_NUMBER_TABLE();

122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_DATE_TABLE();
124: a4 := JTF_NUMBER_TABLE();
125: a5 := JTF_DATE_TABLE();
126: a6 := JTF_NUMBER_TABLE();
127: a7 := JTF_NUMBER_TABLE();
128: a8 := JTF_VARCHAR2_TABLE_100();
129: a9 := JTF_NUMBER_TABLE();
130: a10 := JTF_NUMBER_TABLE();

Line 127: a7 := JTF_NUMBER_TABLE();

123: a3 := JTF_DATE_TABLE();
124: a4 := JTF_NUMBER_TABLE();
125: a5 := JTF_DATE_TABLE();
126: a6 := JTF_NUMBER_TABLE();
127: a7 := JTF_NUMBER_TABLE();
128: a8 := JTF_VARCHAR2_TABLE_100();
129: a9 := JTF_NUMBER_TABLE();
130: a10 := JTF_NUMBER_TABLE();
131: a11 := JTF_NUMBER_TABLE();

Line 129: a9 := JTF_NUMBER_TABLE();

125: a5 := JTF_DATE_TABLE();
126: a6 := JTF_NUMBER_TABLE();
127: a7 := JTF_NUMBER_TABLE();
128: a8 := JTF_VARCHAR2_TABLE_100();
129: a9 := JTF_NUMBER_TABLE();
130: a10 := JTF_NUMBER_TABLE();
131: a11 := JTF_NUMBER_TABLE();
132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_DATE_TABLE();

Line 130: a10 := JTF_NUMBER_TABLE();

126: a6 := JTF_NUMBER_TABLE();
127: a7 := JTF_NUMBER_TABLE();
128: a8 := JTF_VARCHAR2_TABLE_100();
129: a9 := JTF_NUMBER_TABLE();
130: a10 := JTF_NUMBER_TABLE();
131: a11 := JTF_NUMBER_TABLE();
132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_DATE_TABLE();
134: a14 := JTF_DATE_TABLE();

Line 131: a11 := JTF_NUMBER_TABLE();

127: a7 := JTF_NUMBER_TABLE();
128: a8 := JTF_VARCHAR2_TABLE_100();
129: a9 := JTF_NUMBER_TABLE();
130: a10 := JTF_NUMBER_TABLE();
131: a11 := JTF_NUMBER_TABLE();
132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_DATE_TABLE();
134: a14 := JTF_DATE_TABLE();
135: a15 := JTF_NUMBER_TABLE();

Line 132: a12 := JTF_NUMBER_TABLE();

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

Line 135: a15 := JTF_NUMBER_TABLE();

131: a11 := JTF_NUMBER_TABLE();
132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_DATE_TABLE();
134: a14 := JTF_DATE_TABLE();
135: a15 := JTF_NUMBER_TABLE();
136: a16 := JTF_VARCHAR2_TABLE_100();
137: a17 := JTF_VARCHAR2_TABLE_200();
138: a18 := JTF_VARCHAR2_TABLE_200();
139: a19 := JTF_VARCHAR2_TABLE_200();

Line 153: a0 := JTF_NUMBER_TABLE();

149: a29 := JTF_VARCHAR2_TABLE_200();
150: a30 := JTF_VARCHAR2_TABLE_200();
151: a31 := JTF_VARCHAR2_TABLE_200();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_VARCHAR2_TABLE_100();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_DATE_TABLE();
157: a4 := JTF_NUMBER_TABLE();

Line 155: a2 := JTF_NUMBER_TABLE();

151: a31 := JTF_VARCHAR2_TABLE_200();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_VARCHAR2_TABLE_100();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_DATE_TABLE();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_DATE_TABLE();
159: a6 := JTF_NUMBER_TABLE();

Line 157: a4 := JTF_NUMBER_TABLE();

153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_VARCHAR2_TABLE_100();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_DATE_TABLE();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_DATE_TABLE();
159: a6 := JTF_NUMBER_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_VARCHAR2_TABLE_100();

Line 159: a6 := JTF_NUMBER_TABLE();

155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_DATE_TABLE();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_DATE_TABLE();
159: a6 := JTF_NUMBER_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();

Line 160: a7 := JTF_NUMBER_TABLE();

156: a3 := JTF_DATE_TABLE();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_DATE_TABLE();
159: a6 := JTF_NUMBER_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();

Line 162: a9 := JTF_NUMBER_TABLE();

158: a5 := JTF_DATE_TABLE();
159: a6 := JTF_NUMBER_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_NUMBER_TABLE();
166: a13 := JTF_DATE_TABLE();

Line 163: a10 := JTF_NUMBER_TABLE();

159: a6 := JTF_NUMBER_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_NUMBER_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_DATE_TABLE();

Line 164: a11 := JTF_NUMBER_TABLE();

160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_NUMBER_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_DATE_TABLE();
168: a15 := JTF_NUMBER_TABLE();

Line 165: a12 := JTF_NUMBER_TABLE();

161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_NUMBER_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_DATE_TABLE();
168: a15 := JTF_NUMBER_TABLE();
169: a16 := JTF_VARCHAR2_TABLE_100();

Line 168: a15 := JTF_NUMBER_TABLE();

164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_NUMBER_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_DATE_TABLE();
168: a15 := JTF_NUMBER_TABLE();
169: a16 := JTF_VARCHAR2_TABLE_100();
170: a17 := JTF_VARCHAR2_TABLE_200();
171: a18 := JTF_VARCHAR2_TABLE_200();
172: a19 := JTF_VARCHAR2_TABLE_200();

Line 263: procedure rosetta_table_copy_in_p6(t out nocopy ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 JTF_NUMBER_TABLE

259: end if;
260: end if;
261: end rosetta_table_copy_out_p4;
262:
263: procedure rosetta_table_copy_in_p6(t out nocopy ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_100
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_DATE_TABLE
267: , a4 JTF_NUMBER_TABLE

Line 265: , a2 JTF_NUMBER_TABLE

261: end rosetta_table_copy_out_p4;
262:
263: procedure rosetta_table_copy_in_p6(t out nocopy ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_100
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_DATE_TABLE
267: , a4 JTF_NUMBER_TABLE
268: , a5 JTF_DATE_TABLE
269: , a6 JTF_NUMBER_TABLE

Line 267: , a4 JTF_NUMBER_TABLE

263: procedure rosetta_table_copy_in_p6(t out nocopy ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_100
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_DATE_TABLE
267: , a4 JTF_NUMBER_TABLE
268: , a5 JTF_DATE_TABLE
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_NUMBER_TABLE
271: , a8 JTF_NUMBER_TABLE

Line 269: , a6 JTF_NUMBER_TABLE

265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_DATE_TABLE
267: , a4 JTF_NUMBER_TABLE
268: , a5 JTF_DATE_TABLE
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_NUMBER_TABLE
271: , a8 JTF_NUMBER_TABLE
272: , a9 JTF_NUMBER_TABLE
273: , a10 JTF_NUMBER_TABLE

Line 270: , a7 JTF_NUMBER_TABLE

266: , a3 JTF_DATE_TABLE
267: , a4 JTF_NUMBER_TABLE
268: , a5 JTF_DATE_TABLE
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_NUMBER_TABLE
271: , a8 JTF_NUMBER_TABLE
272: , a9 JTF_NUMBER_TABLE
273: , a10 JTF_NUMBER_TABLE
274: , a11 JTF_VARCHAR2_TABLE_100

Line 271: , a8 JTF_NUMBER_TABLE

267: , a4 JTF_NUMBER_TABLE
268: , a5 JTF_DATE_TABLE
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_NUMBER_TABLE
271: , a8 JTF_NUMBER_TABLE
272: , a9 JTF_NUMBER_TABLE
273: , a10 JTF_NUMBER_TABLE
274: , a11 JTF_VARCHAR2_TABLE_100
275: , a12 JTF_NUMBER_TABLE

Line 272: , a9 JTF_NUMBER_TABLE

268: , a5 JTF_DATE_TABLE
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_NUMBER_TABLE
271: , a8 JTF_NUMBER_TABLE
272: , a9 JTF_NUMBER_TABLE
273: , a10 JTF_NUMBER_TABLE
274: , a11 JTF_VARCHAR2_TABLE_100
275: , a12 JTF_NUMBER_TABLE
276: , a13 JTF_VARCHAR2_TABLE_100

Line 273: , a10 JTF_NUMBER_TABLE

269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_NUMBER_TABLE
271: , a8 JTF_NUMBER_TABLE
272: , a9 JTF_NUMBER_TABLE
273: , a10 JTF_NUMBER_TABLE
274: , a11 JTF_VARCHAR2_TABLE_100
275: , a12 JTF_NUMBER_TABLE
276: , a13 JTF_VARCHAR2_TABLE_100
277: , a14 JTF_VARCHAR2_TABLE_200

Line 275: , a12 JTF_NUMBER_TABLE

271: , a8 JTF_NUMBER_TABLE
272: , a9 JTF_NUMBER_TABLE
273: , a10 JTF_NUMBER_TABLE
274: , a11 JTF_VARCHAR2_TABLE_100
275: , a12 JTF_NUMBER_TABLE
276: , a13 JTF_VARCHAR2_TABLE_100
277: , a14 JTF_VARCHAR2_TABLE_200
278: , a15 JTF_VARCHAR2_TABLE_200
279: , a16 JTF_VARCHAR2_TABLE_200

Line 338: procedure rosetta_table_copy_out_p6(t ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

334: end loop;
335: end if;
336: end if;
337: end rosetta_table_copy_in_p6;
338: procedure rosetta_table_copy_out_p6(t ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
339: , a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , a2 out nocopy JTF_NUMBER_TABLE
341: , a3 out nocopy JTF_DATE_TABLE
342: , a4 out nocopy JTF_NUMBER_TABLE

Line 340: , a2 out nocopy JTF_NUMBER_TABLE

336: end if;
337: end rosetta_table_copy_in_p6;
338: procedure rosetta_table_copy_out_p6(t ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
339: , a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , a2 out nocopy JTF_NUMBER_TABLE
341: , a3 out nocopy JTF_DATE_TABLE
342: , a4 out nocopy JTF_NUMBER_TABLE
343: , a5 out nocopy JTF_DATE_TABLE
344: , a6 out nocopy JTF_NUMBER_TABLE

Line 342: , a4 out nocopy JTF_NUMBER_TABLE

338: procedure rosetta_table_copy_out_p6(t ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
339: , a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , a2 out nocopy JTF_NUMBER_TABLE
341: , a3 out nocopy JTF_DATE_TABLE
342: , a4 out nocopy JTF_NUMBER_TABLE
343: , a5 out nocopy JTF_DATE_TABLE
344: , a6 out nocopy JTF_NUMBER_TABLE
345: , a7 out nocopy JTF_NUMBER_TABLE
346: , a8 out nocopy JTF_NUMBER_TABLE

Line 344: , a6 out nocopy JTF_NUMBER_TABLE

340: , a2 out nocopy JTF_NUMBER_TABLE
341: , a3 out nocopy JTF_DATE_TABLE
342: , a4 out nocopy JTF_NUMBER_TABLE
343: , a5 out nocopy JTF_DATE_TABLE
344: , a6 out nocopy JTF_NUMBER_TABLE
345: , a7 out nocopy JTF_NUMBER_TABLE
346: , a8 out nocopy JTF_NUMBER_TABLE
347: , a9 out nocopy JTF_NUMBER_TABLE
348: , a10 out nocopy JTF_NUMBER_TABLE

Line 345: , a7 out nocopy JTF_NUMBER_TABLE

341: , a3 out nocopy JTF_DATE_TABLE
342: , a4 out nocopy JTF_NUMBER_TABLE
343: , a5 out nocopy JTF_DATE_TABLE
344: , a6 out nocopy JTF_NUMBER_TABLE
345: , a7 out nocopy JTF_NUMBER_TABLE
346: , a8 out nocopy JTF_NUMBER_TABLE
347: , a9 out nocopy JTF_NUMBER_TABLE
348: , a10 out nocopy JTF_NUMBER_TABLE
349: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 346: , a8 out nocopy JTF_NUMBER_TABLE

342: , a4 out nocopy JTF_NUMBER_TABLE
343: , a5 out nocopy JTF_DATE_TABLE
344: , a6 out nocopy JTF_NUMBER_TABLE
345: , a7 out nocopy JTF_NUMBER_TABLE
346: , a8 out nocopy JTF_NUMBER_TABLE
347: , a9 out nocopy JTF_NUMBER_TABLE
348: , a10 out nocopy JTF_NUMBER_TABLE
349: , a11 out nocopy JTF_VARCHAR2_TABLE_100
350: , a12 out nocopy JTF_NUMBER_TABLE

Line 347: , a9 out nocopy JTF_NUMBER_TABLE

343: , a5 out nocopy JTF_DATE_TABLE
344: , a6 out nocopy JTF_NUMBER_TABLE
345: , a7 out nocopy JTF_NUMBER_TABLE
346: , a8 out nocopy JTF_NUMBER_TABLE
347: , a9 out nocopy JTF_NUMBER_TABLE
348: , a10 out nocopy JTF_NUMBER_TABLE
349: , a11 out nocopy JTF_VARCHAR2_TABLE_100
350: , a12 out nocopy JTF_NUMBER_TABLE
351: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 348: , a10 out nocopy JTF_NUMBER_TABLE

344: , a6 out nocopy JTF_NUMBER_TABLE
345: , a7 out nocopy JTF_NUMBER_TABLE
346: , a8 out nocopy JTF_NUMBER_TABLE
347: , a9 out nocopy JTF_NUMBER_TABLE
348: , a10 out nocopy JTF_NUMBER_TABLE
349: , a11 out nocopy JTF_VARCHAR2_TABLE_100
350: , a12 out nocopy JTF_NUMBER_TABLE
351: , a13 out nocopy JTF_VARCHAR2_TABLE_100
352: , a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 350: , a12 out nocopy JTF_NUMBER_TABLE

346: , a8 out nocopy JTF_NUMBER_TABLE
347: , a9 out nocopy JTF_NUMBER_TABLE
348: , a10 out nocopy JTF_NUMBER_TABLE
349: , a11 out nocopy JTF_VARCHAR2_TABLE_100
350: , a12 out nocopy JTF_NUMBER_TABLE
351: , a13 out nocopy JTF_VARCHAR2_TABLE_100
352: , a14 out nocopy JTF_VARCHAR2_TABLE_200
353: , a15 out nocopy JTF_VARCHAR2_TABLE_200
354: , a16 out nocopy JTF_VARCHAR2_TABLE_200

Line 371: a0 := JTF_NUMBER_TABLE();

367: ) as
368: ddindx binary_integer; indx binary_integer;
369: begin
370: if t is null or t.count = 0 then
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_VARCHAR2_TABLE_100();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_DATE_TABLE();
375: a4 := JTF_NUMBER_TABLE();

Line 373: a2 := JTF_NUMBER_TABLE();

369: begin
370: if t is null or t.count = 0 then
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_VARCHAR2_TABLE_100();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_DATE_TABLE();
375: a4 := JTF_NUMBER_TABLE();
376: a5 := JTF_DATE_TABLE();
377: a6 := JTF_NUMBER_TABLE();

Line 375: a4 := JTF_NUMBER_TABLE();

371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_VARCHAR2_TABLE_100();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_DATE_TABLE();
375: a4 := JTF_NUMBER_TABLE();
376: a5 := JTF_DATE_TABLE();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_NUMBER_TABLE();
379: a8 := JTF_NUMBER_TABLE();

Line 377: a6 := JTF_NUMBER_TABLE();

373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_DATE_TABLE();
375: a4 := JTF_NUMBER_TABLE();
376: a5 := JTF_DATE_TABLE();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_NUMBER_TABLE();
379: a8 := JTF_NUMBER_TABLE();
380: a9 := JTF_NUMBER_TABLE();
381: a10 := JTF_NUMBER_TABLE();

Line 378: a7 := JTF_NUMBER_TABLE();

374: a3 := JTF_DATE_TABLE();
375: a4 := JTF_NUMBER_TABLE();
376: a5 := JTF_DATE_TABLE();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_NUMBER_TABLE();
379: a8 := JTF_NUMBER_TABLE();
380: a9 := JTF_NUMBER_TABLE();
381: a10 := JTF_NUMBER_TABLE();
382: a11 := JTF_VARCHAR2_TABLE_100();

Line 379: a8 := JTF_NUMBER_TABLE();

375: a4 := JTF_NUMBER_TABLE();
376: a5 := JTF_DATE_TABLE();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_NUMBER_TABLE();
379: a8 := JTF_NUMBER_TABLE();
380: a9 := JTF_NUMBER_TABLE();
381: a10 := JTF_NUMBER_TABLE();
382: a11 := JTF_VARCHAR2_TABLE_100();
383: a12 := JTF_NUMBER_TABLE();

Line 380: a9 := JTF_NUMBER_TABLE();

376: a5 := JTF_DATE_TABLE();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_NUMBER_TABLE();
379: a8 := JTF_NUMBER_TABLE();
380: a9 := JTF_NUMBER_TABLE();
381: a10 := JTF_NUMBER_TABLE();
382: a11 := JTF_VARCHAR2_TABLE_100();
383: a12 := JTF_NUMBER_TABLE();
384: a13 := JTF_VARCHAR2_TABLE_100();

Line 381: a10 := JTF_NUMBER_TABLE();

377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_NUMBER_TABLE();
379: a8 := JTF_NUMBER_TABLE();
380: a9 := JTF_NUMBER_TABLE();
381: a10 := JTF_NUMBER_TABLE();
382: a11 := JTF_VARCHAR2_TABLE_100();
383: a12 := JTF_NUMBER_TABLE();
384: a13 := JTF_VARCHAR2_TABLE_100();
385: a14 := JTF_VARCHAR2_TABLE_200();

Line 383: a12 := JTF_NUMBER_TABLE();

379: a8 := JTF_NUMBER_TABLE();
380: a9 := JTF_NUMBER_TABLE();
381: a10 := JTF_NUMBER_TABLE();
382: a11 := JTF_VARCHAR2_TABLE_100();
383: a12 := JTF_NUMBER_TABLE();
384: a13 := JTF_VARCHAR2_TABLE_100();
385: a14 := JTF_VARCHAR2_TABLE_200();
386: a15 := JTF_VARCHAR2_TABLE_200();
387: a16 := JTF_VARCHAR2_TABLE_200();

Line 401: a0 := JTF_NUMBER_TABLE();

397: a26 := JTF_VARCHAR2_TABLE_200();
398: a27 := JTF_VARCHAR2_TABLE_200();
399: a28 := JTF_VARCHAR2_TABLE_200();
400: else
401: a0 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_DATE_TABLE();
405: a4 := JTF_NUMBER_TABLE();

Line 403: a2 := JTF_NUMBER_TABLE();

399: a28 := JTF_VARCHAR2_TABLE_200();
400: else
401: a0 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_DATE_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_DATE_TABLE();
407: a6 := JTF_NUMBER_TABLE();

Line 405: a4 := JTF_NUMBER_TABLE();

401: a0 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_DATE_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_DATE_TABLE();
407: a6 := JTF_NUMBER_TABLE();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_NUMBER_TABLE();

Line 407: a6 := JTF_NUMBER_TABLE();

403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_DATE_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_DATE_TABLE();
407: a6 := JTF_NUMBER_TABLE();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_NUMBER_TABLE();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();

Line 408: a7 := JTF_NUMBER_TABLE();

404: a3 := JTF_DATE_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_DATE_TABLE();
407: a6 := JTF_NUMBER_TABLE();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_NUMBER_TABLE();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_VARCHAR2_TABLE_100();

Line 409: a8 := JTF_NUMBER_TABLE();

405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_DATE_TABLE();
407: a6 := JTF_NUMBER_TABLE();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_NUMBER_TABLE();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_VARCHAR2_TABLE_100();
413: a12 := JTF_NUMBER_TABLE();

Line 410: a9 := JTF_NUMBER_TABLE();

406: a5 := JTF_DATE_TABLE();
407: a6 := JTF_NUMBER_TABLE();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_NUMBER_TABLE();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_VARCHAR2_TABLE_100();
413: a12 := JTF_NUMBER_TABLE();
414: a13 := JTF_VARCHAR2_TABLE_100();

Line 411: a10 := JTF_NUMBER_TABLE();

407: a6 := JTF_NUMBER_TABLE();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_NUMBER_TABLE();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_VARCHAR2_TABLE_100();
413: a12 := JTF_NUMBER_TABLE();
414: a13 := JTF_VARCHAR2_TABLE_100();
415: a14 := JTF_VARCHAR2_TABLE_200();

Line 413: a12 := JTF_NUMBER_TABLE();

409: a8 := JTF_NUMBER_TABLE();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_VARCHAR2_TABLE_100();
413: a12 := JTF_NUMBER_TABLE();
414: a13 := JTF_VARCHAR2_TABLE_100();
415: a14 := JTF_VARCHAR2_TABLE_200();
416: a15 := JTF_VARCHAR2_TABLE_200();
417: a16 := JTF_VARCHAR2_TABLE_200();

Line 502: procedure rosetta_table_copy_in_p7(t out nocopy ahl_sb_rules_pvt.violated_inst_tbl_type, a0 JTF_NUMBER_TABLE) as

498: end if;
499: end if;
500: end rosetta_table_copy_out_p6;
501:
502: procedure rosetta_table_copy_in_p7(t out nocopy ahl_sb_rules_pvt.violated_inst_tbl_type, a0 JTF_NUMBER_TABLE) as
503: ddindx binary_integer; indx binary_integer;
504: begin
505: if a0 is not null and a0.count > 0 then
506: if a0.count > 0 then

Line 520: procedure rosetta_table_copy_out_p7(t ahl_sb_rules_pvt.violated_inst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

516: end loop;
517: end if;
518: end if;
519: end rosetta_table_copy_in_p7;
520: procedure rosetta_table_copy_out_p7(t ahl_sb_rules_pvt.violated_inst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
521: ddindx binary_integer; indx binary_integer;
522: begin
523: if t is null or t.count = 0 then
524: a0 := JTF_NUMBER_TABLE();

Line 524: a0 := JTF_NUMBER_TABLE();

520: procedure rosetta_table_copy_out_p7(t ahl_sb_rules_pvt.violated_inst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
521: ddindx binary_integer; indx binary_integer;
522: begin
523: if t is null or t.count = 0 then
524: a0 := JTF_NUMBER_TABLE();
525: else
526: a0 := JTF_NUMBER_TABLE();
527: if t.count > 0 then
528: a0.extend(t.count);

Line 526: a0 := JTF_NUMBER_TABLE();

522: begin
523: if t is null or t.count = 0 then
524: a0 := JTF_NUMBER_TABLE();
525: else
526: a0 := JTF_NUMBER_TABLE();
527: if t.count > 0 then
528: a0.extend(t.count);
529: ddindx := t.first;
530: indx := 1;

Line 543: procedure rosetta_table_copy_in_p8(t out nocopy ahl_sb_rules_pvt.affected_mc_tbl_type, a0 JTF_NUMBER_TABLE) as

539: end if;
540: end if;
541: end rosetta_table_copy_out_p7;
542:
543: procedure rosetta_table_copy_in_p8(t out nocopy ahl_sb_rules_pvt.affected_mc_tbl_type, a0 JTF_NUMBER_TABLE) as
544: ddindx binary_integer; indx binary_integer;
545: begin
546: if a0 is not null and a0.count > 0 then
547: if a0.count > 0 then

Line 561: procedure rosetta_table_copy_out_p8(t ahl_sb_rules_pvt.affected_mc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

557: end loop;
558: end if;
559: end if;
560: end rosetta_table_copy_in_p8;
561: procedure rosetta_table_copy_out_p8(t ahl_sb_rules_pvt.affected_mc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
562: ddindx binary_integer; indx binary_integer;
563: begin
564: if t is null or t.count = 0 then
565: a0 := JTF_NUMBER_TABLE();

Line 565: a0 := JTF_NUMBER_TABLE();

561: procedure rosetta_table_copy_out_p8(t ahl_sb_rules_pvt.affected_mc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
562: ddindx binary_integer; indx binary_integer;
563: begin
564: if t is null or t.count = 0 then
565: a0 := JTF_NUMBER_TABLE();
566: else
567: a0 := JTF_NUMBER_TABLE();
568: if t.count > 0 then
569: a0.extend(t.count);

Line 567: a0 := JTF_NUMBER_TABLE();

563: begin
564: if t is null or t.count = 0 then
565: a0 := JTF_NUMBER_TABLE();
566: else
567: a0 := JTF_NUMBER_TABLE();
568: if t.count > 0 then
569: a0.extend(t.count);
570: ddindx := t.first;
571: indx := 1;

Line 693: , x_violated_inst_tbl out nocopy JTF_NUMBER_TABLE

689: , p_init_msg_list VARCHAR2
690: , p_validation_level NUMBER
691: , p_module_type VARCHAR2
692: , p_uc_header_id NUMBER
693: , x_violated_inst_tbl out nocopy JTF_NUMBER_TABLE
694: , x_return_status out nocopy VARCHAR2
695: , x_msg_count out nocopy NUMBER
696: , x_msg_data out nocopy VARCHAR2
697: )

Line 742: , x_affected_mc_tbl out nocopy JTF_NUMBER_TABLE

738: , p_init_msg_list VARCHAR2
739: , p_validation_level NUMBER
740: , p_module_type VARCHAR2
741: , p_mr_header_id NUMBER
742: , x_affected_mc_tbl out nocopy JTF_NUMBER_TABLE
743: , x_return_status out nocopy VARCHAR2
744: , x_msg_count out nocopy NUMBER
745: , x_msg_data out nocopy VARCHAR2
746: )