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.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 108: TYPE tab_ta_attribute IS TABLE OF hxc_time_attributes.attribute1%TYPE

104:
105: TYPE tab_ta_field_name IS TABLE OF hxc_mapping_components.field_name%TYPE
106: INDEX BY BINARY_INTEGER;
107:
108: TYPE tab_ta_attribute IS TABLE OF hxc_time_attributes.attribute1%TYPE
109: INDEX BY BINARY_INTEGER;
110:
111: -- global package variable in order to reference table.LAST in the procedure populate_attribute
112: t_attribute_fk_bb_id tab_ta_fk_bb_id;

Line 237: hxc_time_attributes att

233: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
234: l_detail_exists VARCHAR2 (400)
235: := '
236: EXISTS ( select 1 from hxc_time_attribute_usages usage,
237: hxc_time_attributes att
238: where usage.time_building_Block_id = detail_block.time_building_block_id AND
239: usage.time_building_block_ovn = detail_block.object_version_number
240: and
241: att.time_attribute_id = usage.time_attribute_id and

Line 246: hxc_time_attributes att

242: att.';
243: l_exists VARCHAR2 (400)
244: := '
245: EXISTS ( select 1 from hxc_time_attribute_usages usage,
246: hxc_time_attributes att
247: where usage.time_building_Block_id = timecard_block.time_building_block_id AND
248: usage.time_building_block_ovn = timecard_block.object_version_number
249: and
250: att.time_attribute_id = usage.time_attribute_id and

Line 2513: -- HXC_TIME_ATTRIBUTES.

2509: --
2510: -- description
2511: -- This procedure is used to populate the global PL/SQL tables which
2512: -- contain the attribution for each time building block stored in
2513: -- HXC_TIME_ATTRIBUTES.
2514: -- The procedure is called each time a new time attribute id is found
2515: -- when processing the rows returned in the main query. Then, for each
2516: -- segment/attribute in the mapping for the process, copies the associated
2517: -- value and field name to a global PL/SQL table for use later by the

Line 2540: l_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE;

2536: p_new VARCHAR2
2537: )
2538: IS
2539: l_att_cnt PLS_INTEGER;
2540: l_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE;
2541: l_attribute_category VARCHAR2 (100);
2542: l_proc VARCHAR2 (72)
2543: := g_package || 'populate_attributes';
2544: BEGIN

Line 3777: l_old_timecard_ta_id hxc_time_attributes.time_attribute_id%TYPE

3773: := -1;
3774: l_old_detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
3775: := -1;
3776: -- timecard scope attribute local variables
3777: l_old_timecard_ta_id hxc_time_attributes.time_attribute_id%TYPE
3778: := -1;
3779: l_old_day_ta_id hxc_time_attributes.time_attribute_id%TYPE
3780: := -1;
3781: l_old_detail_ta_id hxc_time_attributes.time_attribute_id%TYPE

Line 3779: l_old_day_ta_id hxc_time_attributes.time_attribute_id%TYPE

3775: := -1;
3776: -- timecard scope attribute local variables
3777: l_old_timecard_ta_id hxc_time_attributes.time_attribute_id%TYPE
3778: := -1;
3779: l_old_day_ta_id hxc_time_attributes.time_attribute_id%TYPE
3780: := -1;
3781: l_old_detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
3782: := -1;
3783: -- tables and temporary table local variables

Line 3781: l_old_detail_ta_id hxc_time_attributes.time_attribute_id%TYPE

3777: l_old_timecard_ta_id hxc_time_attributes.time_attribute_id%TYPE
3778: := -1;
3779: l_old_day_ta_id hxc_time_attributes.time_attribute_id%TYPE
3780: := -1;
3781: l_old_detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
3782: := -1;
3783: -- tables and temporary table local variables
3784: t_attribute_field_name tab_ta_field_name;
3785: t_attribute_value tab_ta_attribute;

Line 5465: hxc_time_attributes ta

5461: ta.attribute26, ta.attribute27, ta.attribute28,
5462: ta.attribute29, ta.attribute30
5463: FROM hxc_tmp_bld_blks tmp,
5464: hxc_time_attribute_usages tau,
5465: hxc_time_attributes ta
5466: WHERE tau.time_building_block_id = tmp.time_building_block_id
5467: AND tau.time_building_block_ovn = tmp.time_building_block_ovn
5468: AND ta.time_attribute_id = tau.time_attribute_id
5469: ORDER BY tmp.seq;

Line 5523: TYPE t_old_bld_blk_bb_info_type_id IS TABLE OF hxc_time_attributes.bld_blk_info_type_id%TYPE

5519:
5520: TYPE t_old_bld_blk_app_style_id IS TABLE OF hxc_time_building_blocks.approval_style_id%TYPE
5521: INDEX BY BINARY_INTEGER;
5522:
5523: TYPE t_old_bld_blk_bb_info_type_id IS TABLE OF hxc_time_attributes.bld_blk_info_type_id%TYPE
5524: INDEX BY BINARY_INTEGER;
5525:
5526: TYPE t_old_bld_blk_att_cat IS TABLE OF hxc_time_attributes.attribute_category%TYPE
5527: INDEX BY BINARY_INTEGER;

Line 5526: TYPE t_old_bld_blk_att_cat IS TABLE OF hxc_time_attributes.attribute_category%TYPE

5522:
5523: TYPE t_old_bld_blk_bb_info_type_id IS TABLE OF hxc_time_attributes.bld_blk_info_type_id%TYPE
5524: INDEX BY BINARY_INTEGER;
5525:
5526: TYPE t_old_bld_blk_att_cat IS TABLE OF hxc_time_attributes.attribute_category%TYPE
5527: INDEX BY BINARY_INTEGER;
5528:
5529: TYPE t_old_bld_blk_attribute1 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5530: INDEX BY BINARY_INTEGER;

Line 5529: TYPE t_old_bld_blk_attribute1 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5525:
5526: TYPE t_old_bld_blk_att_cat IS TABLE OF hxc_time_attributes.attribute_category%TYPE
5527: INDEX BY BINARY_INTEGER;
5528:
5529: TYPE t_old_bld_blk_attribute1 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5530: INDEX BY BINARY_INTEGER;
5531:
5532: TYPE t_old_bld_blk_attribute2 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5533: INDEX BY BINARY_INTEGER;

Line 5532: TYPE t_old_bld_blk_attribute2 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5528:
5529: TYPE t_old_bld_blk_attribute1 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5530: INDEX BY BINARY_INTEGER;
5531:
5532: TYPE t_old_bld_blk_attribute2 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5533: INDEX BY BINARY_INTEGER;
5534:
5535: TYPE t_old_bld_blk_attribute3 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5536: INDEX BY BINARY_INTEGER;

Line 5535: TYPE t_old_bld_blk_attribute3 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5531:
5532: TYPE t_old_bld_blk_attribute2 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5533: INDEX BY BINARY_INTEGER;
5534:
5535: TYPE t_old_bld_blk_attribute3 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5536: INDEX BY BINARY_INTEGER;
5537:
5538: TYPE t_old_bld_blk_attribute4 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5539: INDEX BY BINARY_INTEGER;

Line 5538: TYPE t_old_bld_blk_attribute4 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5534:
5535: TYPE t_old_bld_blk_attribute3 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5536: INDEX BY BINARY_INTEGER;
5537:
5538: TYPE t_old_bld_blk_attribute4 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5539: INDEX BY BINARY_INTEGER;
5540:
5541: TYPE t_old_bld_blk_attribute5 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5542: INDEX BY BINARY_INTEGER;

Line 5541: TYPE t_old_bld_blk_attribute5 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5537:
5538: TYPE t_old_bld_blk_attribute4 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5539: INDEX BY BINARY_INTEGER;
5540:
5541: TYPE t_old_bld_blk_attribute5 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5542: INDEX BY BINARY_INTEGER;
5543:
5544: TYPE t_old_bld_blk_attribute6 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5545: INDEX BY BINARY_INTEGER;

Line 5544: TYPE t_old_bld_blk_attribute6 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5540:
5541: TYPE t_old_bld_blk_attribute5 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5542: INDEX BY BINARY_INTEGER;
5543:
5544: TYPE t_old_bld_blk_attribute6 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5545: INDEX BY BINARY_INTEGER;
5546:
5547: TYPE t_old_bld_blk_attribute7 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5548: INDEX BY BINARY_INTEGER;

Line 5547: TYPE t_old_bld_blk_attribute7 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5543:
5544: TYPE t_old_bld_blk_attribute6 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5545: INDEX BY BINARY_INTEGER;
5546:
5547: TYPE t_old_bld_blk_attribute7 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5548: INDEX BY BINARY_INTEGER;
5549:
5550: TYPE t_old_bld_blk_attribute8 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5551: INDEX BY BINARY_INTEGER;

Line 5550: TYPE t_old_bld_blk_attribute8 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5546:
5547: TYPE t_old_bld_blk_attribute7 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5548: INDEX BY BINARY_INTEGER;
5549:
5550: TYPE t_old_bld_blk_attribute8 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5551: INDEX BY BINARY_INTEGER;
5552:
5553: TYPE t_old_bld_blk_attribute9 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5554: INDEX BY BINARY_INTEGER;

Line 5553: TYPE t_old_bld_blk_attribute9 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5549:
5550: TYPE t_old_bld_blk_attribute8 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5551: INDEX BY BINARY_INTEGER;
5552:
5553: TYPE t_old_bld_blk_attribute9 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5554: INDEX BY BINARY_INTEGER;
5555:
5556: TYPE t_old_bld_blk_attribute10 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5557: INDEX BY BINARY_INTEGER;

Line 5556: TYPE t_old_bld_blk_attribute10 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5552:
5553: TYPE t_old_bld_blk_attribute9 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5554: INDEX BY BINARY_INTEGER;
5555:
5556: TYPE t_old_bld_blk_attribute10 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5557: INDEX BY BINARY_INTEGER;
5558:
5559: TYPE t_old_bld_blk_attribute11 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5560: INDEX BY BINARY_INTEGER;

Line 5559: TYPE t_old_bld_blk_attribute11 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5555:
5556: TYPE t_old_bld_blk_attribute10 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5557: INDEX BY BINARY_INTEGER;
5558:
5559: TYPE t_old_bld_blk_attribute11 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5560: INDEX BY BINARY_INTEGER;
5561:
5562: TYPE t_old_bld_blk_attribute12 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5563: INDEX BY BINARY_INTEGER;

Line 5562: TYPE t_old_bld_blk_attribute12 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5558:
5559: TYPE t_old_bld_blk_attribute11 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5560: INDEX BY BINARY_INTEGER;
5561:
5562: TYPE t_old_bld_blk_attribute12 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5563: INDEX BY BINARY_INTEGER;
5564:
5565: TYPE t_old_bld_blk_attribute13 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5566: INDEX BY BINARY_INTEGER;

Line 5565: TYPE t_old_bld_blk_attribute13 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5561:
5562: TYPE t_old_bld_blk_attribute12 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5563: INDEX BY BINARY_INTEGER;
5564:
5565: TYPE t_old_bld_blk_attribute13 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5566: INDEX BY BINARY_INTEGER;
5567:
5568: TYPE t_old_bld_blk_attribute14 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5569: INDEX BY BINARY_INTEGER;

Line 5568: TYPE t_old_bld_blk_attribute14 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5564:
5565: TYPE t_old_bld_blk_attribute13 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5566: INDEX BY BINARY_INTEGER;
5567:
5568: TYPE t_old_bld_blk_attribute14 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5569: INDEX BY BINARY_INTEGER;
5570:
5571: TYPE t_old_bld_blk_attribute15 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5572: INDEX BY BINARY_INTEGER;

Line 5571: TYPE t_old_bld_blk_attribute15 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5567:
5568: TYPE t_old_bld_blk_attribute14 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5569: INDEX BY BINARY_INTEGER;
5570:
5571: TYPE t_old_bld_blk_attribute15 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5572: INDEX BY BINARY_INTEGER;
5573:
5574: TYPE t_old_bld_blk_attribute16 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5575: INDEX BY BINARY_INTEGER;

Line 5574: TYPE t_old_bld_blk_attribute16 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5570:
5571: TYPE t_old_bld_blk_attribute15 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5572: INDEX BY BINARY_INTEGER;
5573:
5574: TYPE t_old_bld_blk_attribute16 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5575: INDEX BY BINARY_INTEGER;
5576:
5577: TYPE t_old_bld_blk_attribute17 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5578: INDEX BY BINARY_INTEGER;

Line 5577: TYPE t_old_bld_blk_attribute17 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5573:
5574: TYPE t_old_bld_blk_attribute16 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5575: INDEX BY BINARY_INTEGER;
5576:
5577: TYPE t_old_bld_blk_attribute17 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5578: INDEX BY BINARY_INTEGER;
5579:
5580: TYPE t_old_bld_blk_attribute18 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5581: INDEX BY BINARY_INTEGER;

Line 5580: TYPE t_old_bld_blk_attribute18 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5576:
5577: TYPE t_old_bld_blk_attribute17 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5578: INDEX BY BINARY_INTEGER;
5579:
5580: TYPE t_old_bld_blk_attribute18 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5581: INDEX BY BINARY_INTEGER;
5582:
5583: TYPE t_old_bld_blk_attribute19 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5584: INDEX BY BINARY_INTEGER;

Line 5583: TYPE t_old_bld_blk_attribute19 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5579:
5580: TYPE t_old_bld_blk_attribute18 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5581: INDEX BY BINARY_INTEGER;
5582:
5583: TYPE t_old_bld_blk_attribute19 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5584: INDEX BY BINARY_INTEGER;
5585:
5586: TYPE t_old_bld_blk_attribute20 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5587: INDEX BY BINARY_INTEGER;

Line 5586: TYPE t_old_bld_blk_attribute20 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5582:
5583: TYPE t_old_bld_blk_attribute19 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5584: INDEX BY BINARY_INTEGER;
5585:
5586: TYPE t_old_bld_blk_attribute20 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5587: INDEX BY BINARY_INTEGER;
5588:
5589: TYPE t_old_bld_blk_attribute21 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5590: INDEX BY BINARY_INTEGER;

Line 5589: TYPE t_old_bld_blk_attribute21 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5585:
5586: TYPE t_old_bld_blk_attribute20 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5587: INDEX BY BINARY_INTEGER;
5588:
5589: TYPE t_old_bld_blk_attribute21 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5590: INDEX BY BINARY_INTEGER;
5591:
5592: TYPE t_old_bld_blk_attribute22 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5593: INDEX BY BINARY_INTEGER;

Line 5592: TYPE t_old_bld_blk_attribute22 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5588:
5589: TYPE t_old_bld_blk_attribute21 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5590: INDEX BY BINARY_INTEGER;
5591:
5592: TYPE t_old_bld_blk_attribute22 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5593: INDEX BY BINARY_INTEGER;
5594:
5595: TYPE t_old_bld_blk_attribute23 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5596: INDEX BY BINARY_INTEGER;

Line 5595: TYPE t_old_bld_blk_attribute23 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5591:
5592: TYPE t_old_bld_blk_attribute22 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5593: INDEX BY BINARY_INTEGER;
5594:
5595: TYPE t_old_bld_blk_attribute23 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5596: INDEX BY BINARY_INTEGER;
5597:
5598: TYPE t_old_bld_blk_attribute24 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5599: INDEX BY BINARY_INTEGER;

Line 5598: TYPE t_old_bld_blk_attribute24 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5594:
5595: TYPE t_old_bld_blk_attribute23 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5596: INDEX BY BINARY_INTEGER;
5597:
5598: TYPE t_old_bld_blk_attribute24 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5599: INDEX BY BINARY_INTEGER;
5600:
5601: TYPE t_old_bld_blk_attribute25 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5602: INDEX BY BINARY_INTEGER;

Line 5601: TYPE t_old_bld_blk_attribute25 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5597:
5598: TYPE t_old_bld_blk_attribute24 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5599: INDEX BY BINARY_INTEGER;
5600:
5601: TYPE t_old_bld_blk_attribute25 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5602: INDEX BY BINARY_INTEGER;
5603:
5604: TYPE t_old_bld_blk_attribute26 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5605: INDEX BY BINARY_INTEGER;

Line 5604: TYPE t_old_bld_blk_attribute26 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5600:
5601: TYPE t_old_bld_blk_attribute25 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5602: INDEX BY BINARY_INTEGER;
5603:
5604: TYPE t_old_bld_blk_attribute26 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5605: INDEX BY BINARY_INTEGER;
5606:
5607: TYPE t_old_bld_blk_attribute27 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5608: INDEX BY BINARY_INTEGER;

Line 5607: TYPE t_old_bld_blk_attribute27 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5603:
5604: TYPE t_old_bld_blk_attribute26 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5605: INDEX BY BINARY_INTEGER;
5606:
5607: TYPE t_old_bld_blk_attribute27 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5608: INDEX BY BINARY_INTEGER;
5609:
5610: TYPE t_old_bld_blk_attribute28 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5611: INDEX BY BINARY_INTEGER;

Line 5610: TYPE t_old_bld_blk_attribute28 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5606:
5607: TYPE t_old_bld_blk_attribute27 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5608: INDEX BY BINARY_INTEGER;
5609:
5610: TYPE t_old_bld_blk_attribute28 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5611: INDEX BY BINARY_INTEGER;
5612:
5613: TYPE t_old_bld_blk_attribute29 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5614: INDEX BY BINARY_INTEGER;

Line 5613: TYPE t_old_bld_blk_attribute29 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5609:
5610: TYPE t_old_bld_blk_attribute28 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5611: INDEX BY BINARY_INTEGER;
5612:
5613: TYPE t_old_bld_blk_attribute29 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5614: INDEX BY BINARY_INTEGER;
5615:
5616: TYPE t_old_bld_blk_attribute30 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5617: INDEX BY BINARY_INTEGER;

Line 5616: TYPE t_old_bld_blk_attribute30 IS TABLE OF hxc_time_attributes.attribute1%TYPE

5612:
5613: TYPE t_old_bld_blk_attribute29 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5614: INDEX BY BINARY_INTEGER;
5615:
5616: TYPE t_old_bld_blk_attribute30 IS TABLE OF hxc_time_attributes.attribute1%TYPE
5617: INDEX BY BINARY_INTEGER;
5618:
5619: t_old_bb_id t_old_bld_blk_bb_id;
5620: t_old_bb_ovn t_old_bld_blk_bb_ovn;

Line 6300: , Hxc_time_attributes detail_att';

6296: hxc_time_building_blocks timecard_block
6297: , hxc_time_building_blocks day_block
6298: , Hxc_time_building_blocks detail_block
6299: , Hxc_time_attribute_usages detail_usage
6300: , Hxc_time_attributes detail_att';
6301: l_inline_view_range VARCHAR2 (800)
6302: := '
6303: FROM
6304: (select /*+ no_merge ordered */

Line 6353: , Hxc_time_attributes detail_att

6349: := '
6350: ) tbb
6351: , Hxc_time_building_blocks detail_block
6352: , Hxc_time_attribute_usages detail_usage
6353: , Hxc_time_attributes detail_att
6354: , hxc_time_building_blocks day_block
6355: , hxc_time_building_blocks timecard_block
6356: , hxc_max_ovn detail_max_ovn';
6357: l_incremental_from VARCHAR2 (400)

Line 6363: , Hxc_time_attributes detail_att

6359: FROM
6360: hxc_retrieval_range_blks tbb
6361: , Hxc_time_building_blocks detail_block
6362: , Hxc_time_attribute_usages detail_usage
6363: , Hxc_time_attributes detail_att
6364: , hxc_time_building_blocks day_block
6365: , hxc_time_building_blocks timecard_block
6366: , hxc_latest_details hld
6367: , hxc_max_ovn detail_max_ovn';

Line 6438: hxc_time_attributes detail_att

6434: :p_end_date >= tbb_latest.start_time ';
6435: l_rerun VARCHAR2 (1100)
6436: := '
6437: FROM
6438: hxc_time_attributes detail_att
6439: , hxc_time_attribute_usages detail_usage
6440: , hxc_time_building_blocks detail_block
6441: , hxc_time_building_blocks day_block
6442: , hxc_time_attributes timecard_att

Line 6442: , hxc_time_attributes timecard_att

6438: hxc_time_attributes detail_att
6439: , hxc_time_attribute_usages detail_usage
6440: , hxc_time_building_blocks detail_block
6441: , hxc_time_building_blocks day_block
6442: , hxc_time_attributes timecard_att
6443: , hxc_transaction_details txd
6444: , hxc_transactions tx
6445: WHERE
6446: tx.transaction_code = :p_transaction_code