94:
95: TYPE r_time_attributes IS RECORD (
96: bb_id hxc_time_building_blocks.time_building_block_id%TYPE
97: , field_name hxc_mapping_components.field_name%TYPE
98: , value hxc_time_attributes.attribute1%TYPE
99: , context hxc_bld_blk_info_types.bld_blk_info_type%TYPE
100: , category hxc_bld_blk_info_type_usages.building_block_category%TYPE );
101:
102: TYPE t_time_attribute IS TABLE OF r_time_attributes INDEX BY BINARY_INTEGER;
135: , detail_date_from hxc_time_building_blocks.date_from%TYPE
136: , detail_date_to hxc_time_building_blocks.date_to%TYPE
137: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
138: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
139: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
140: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
141: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
136: , detail_date_to hxc_time_building_blocks.date_to%TYPE
137: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
138: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
139: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
140: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
141: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
137: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
138: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
139: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
140: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
141: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
138: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
139: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
140: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
141: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
139: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
140: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
141: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
140: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
141: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
141: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
159: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
159: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
160: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
159: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
160: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
161: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
159: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
160: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
161: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
162: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
159: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
160: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
161: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
162: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
163: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
159: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
160: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
161: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
162: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
163: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
164: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
159: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
160: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
161: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
162: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
163: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
164: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
165: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
159: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
160: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
161: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
162: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
163: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
164: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
165: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
166: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
159: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
160: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
161: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
162: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
163: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
164: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
165: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
166: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
167: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
160: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
161: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
162: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
163: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
164: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
165: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
166: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
167: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
168: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
161: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
162: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
163: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
164: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
165: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
166: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
167: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
168: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
169: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
162: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
163: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
164: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
165: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
166: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
167: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
168: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
169: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
170: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
163: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
164: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
165: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
166: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
167: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
168: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
169: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
170: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
171: , detail_attribute_category hxc_time_attributes.attribute_category%TYPE );
164: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
165: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
166: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
167: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
168: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
169: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
170: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
171: , detail_attribute_category hxc_time_attributes.attribute_category%TYPE );
172:
165: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
166: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
167: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
168: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
169: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
170: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
171: , detail_attribute_category hxc_time_attributes.attribute_category%TYPE );
172:
173: TYPE t_all_building_blocks IS TABLE OF r_all_building_blocks INDEX BY BINARY_INTEGER;
166: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
167: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
168: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
169: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
170: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
171: , detail_attribute_category hxc_time_attributes.attribute_category%TYPE );
172:
173: TYPE t_all_building_blocks IS TABLE OF r_all_building_blocks INDEX BY BINARY_INTEGER;
174:
167: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
168: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
169: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
170: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
171: , detail_attribute_category hxc_time_attributes.attribute_category%TYPE );
172:
173: TYPE t_all_building_blocks IS TABLE OF r_all_building_blocks INDEX BY BINARY_INTEGER;
174:
175: t_bb t_all_building_blocks;