81:
82: TYPE r_time_attributes IS RECORD (
83: bb_id hxc_time_building_blocks.time_building_block_id%TYPE
84: , field_name hxc_mapping_components.field_name%TYPE
85: , value hxc_time_attributes.attribute1%TYPE
86: , context hxc_bld_blk_info_types.bld_blk_info_type%TYPE
87: , category hxc_bld_blk_info_type_usages.building_block_category%TYPE );
88:
89: TYPE t_time_attribute IS TABLE OF r_time_attributes INDEX BY BINARY_INTEGER;
122: , detail_date_from hxc_time_building_blocks.date_from%TYPE
123: , detail_date_to hxc_time_building_blocks.date_to%TYPE
124: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
125: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
126: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
127: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
128: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
129: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
130: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
123: , detail_date_to hxc_time_building_blocks.date_to%TYPE
124: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
125: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
126: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
127: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
128: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
129: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
130: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
131: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
124: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
125: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
126: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
127: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
128: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
129: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
130: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
131: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
132: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
125: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
126: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
127: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
128: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
129: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
130: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
131: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
132: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
133: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
126: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
127: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
128: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
129: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
130: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
131: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
132: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
133: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
134: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
127: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
128: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
129: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
130: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
131: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
132: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
133: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
134: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
135: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
128: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
129: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
130: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
131: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
132: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
133: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
134: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
135: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
136: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
129: , detail_attribute2 hxc_time_attributes.attribute1%TYPE
130: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
131: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
132: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
133: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
134: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
135: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
136: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
137: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
130: , detail_attribute3 hxc_time_attributes.attribute1%TYPE
131: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
132: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
133: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
134: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
135: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
136: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
137: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
138: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
131: , detail_attribute4 hxc_time_attributes.attribute1%TYPE
132: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
133: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
134: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
135: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
136: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
137: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
138: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
139: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
132: , detail_attribute5 hxc_time_attributes.attribute1%TYPE
133: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
134: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
135: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
136: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
137: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
138: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
139: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
140: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
133: , detail_attribute6 hxc_time_attributes.attribute1%TYPE
134: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
135: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
136: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
137: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
138: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
139: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
140: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
141: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
134: , detail_attribute7 hxc_time_attributes.attribute1%TYPE
135: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
136: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
137: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
138: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
139: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
140: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
141: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
135: , detail_attribute8 hxc_time_attributes.attribute1%TYPE
136: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
137: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
138: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
139: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
140: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
141: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
136: , detail_attribute9 hxc_time_attributes.attribute1%TYPE
137: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
138: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
139: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
140: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
141: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
137: , detail_attribute10 hxc_time_attributes.attribute1%TYPE
138: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
139: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
140: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
141: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
138: , detail_attribute11 hxc_time_attributes.attribute1%TYPE
139: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
140: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
141: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
139: , detail_attribute12 hxc_time_attributes.attribute1%TYPE
140: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
141: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
140: , detail_attribute13 hxc_time_attributes.attribute1%TYPE
141: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
141: , detail_attribute14 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute15 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
143: , detail_attribute16 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
144: , detail_attribute17 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
145: , detail_attribute18 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
146: , detail_attribute19 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
147: , detail_attribute20 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
148: , detail_attribute21 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
149: , detail_attribute22 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
150: , detail_attribute23 hxc_time_attributes.attribute1%TYPE
151: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute_category hxc_time_attributes.attribute_category%TYPE );
151: , detail_attribute24 hxc_time_attributes.attribute1%TYPE
152: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute_category hxc_time_attributes.attribute_category%TYPE );
159:
152: , detail_attribute25 hxc_time_attributes.attribute1%TYPE
153: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute_category hxc_time_attributes.attribute_category%TYPE );
159:
160: TYPE t_all_building_blocks IS TABLE OF r_all_building_blocks INDEX BY BINARY_INTEGER;
153: , detail_attribute26 hxc_time_attributes.attribute1%TYPE
154: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute_category hxc_time_attributes.attribute_category%TYPE );
159:
160: TYPE t_all_building_blocks IS TABLE OF r_all_building_blocks INDEX BY BINARY_INTEGER;
161:
154: , detail_attribute27 hxc_time_attributes.attribute1%TYPE
155: , detail_attribute28 hxc_time_attributes.attribute1%TYPE
156: , detail_attribute29 hxc_time_attributes.attribute1%TYPE
157: , detail_attribute30 hxc_time_attributes.attribute1%TYPE
158: , detail_attribute_category hxc_time_attributes.attribute_category%TYPE );
159:
160: TYPE t_all_building_blocks IS TABLE OF r_all_building_blocks INDEX BY BINARY_INTEGER;
161:
162: t_bb t_all_building_blocks;