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 252: hxc_time_attributes att

248: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
249: l_detail_exists VARCHAR2 (400)
250: := '
251: EXISTS ( select 1 from hxc_time_attribute_usages usage,
252: hxc_time_attributes att
253: where usage.time_building_Block_id = detail_block.time_building_block_id AND
254: usage.time_building_block_ovn = detail_block.object_version_number
255: and
256: att.time_attribute_id = usage.time_attribute_id and

Line 261: hxc_time_attributes att

257: att.';
258: l_exists VARCHAR2 (400)
259: := '
260: EXISTS ( select 1 from hxc_time_attribute_usages usage,
261: hxc_time_attributes att
262: where usage.time_building_Block_id = timecard_block.time_building_block_id AND
263: usage.time_building_block_ovn = timecard_block.object_version_number
264: and
265: att.time_attribute_id = usage.time_attribute_id and

Line 3143: -- HXC_TIME_ATTRIBUTES.

3139: --
3140: -- description
3141: -- This procedure is used to populate the global PL/SQL tables which
3142: -- contain the attribution for each time building block stored in
3143: -- HXC_TIME_ATTRIBUTES.
3144: -- The procedure is called each time a new time attribute id is found
3145: -- when processing the rows returned in the main query. Then, for each
3146: -- segment/attribute in the mapping for the process, copies the associated
3147: -- value and field name to a global PL/SQL table for use later by the

Line 3170: l_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE;

3166: p_new VARCHAR2
3167: )
3168: IS
3169: l_att_cnt PLS_INTEGER;
3170: l_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE;
3171: l_attribute_category VARCHAR2 (100);
3172: l_proc VARCHAR2 (72)
3173: := g_package || 'populate_attributes';
3174: BEGIN

Line 4407: l_old_timecard_ta_id hxc_time_attributes.time_attribute_id%TYPE

4403: := -1;
4404: l_old_detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
4405: := -1;
4406: -- timecard scope attribute local variables
4407: l_old_timecard_ta_id hxc_time_attributes.time_attribute_id%TYPE
4408: := -1;
4409: l_old_day_ta_id hxc_time_attributes.time_attribute_id%TYPE
4410: := -1;
4411: l_old_detail_ta_id hxc_time_attributes.time_attribute_id%TYPE

Line 4409: l_old_day_ta_id hxc_time_attributes.time_attribute_id%TYPE

4405: := -1;
4406: -- timecard scope attribute local variables
4407: l_old_timecard_ta_id hxc_time_attributes.time_attribute_id%TYPE
4408: := -1;
4409: l_old_day_ta_id hxc_time_attributes.time_attribute_id%TYPE
4410: := -1;
4411: l_old_detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
4412: := -1;
4413: -- tables and temporary table local variables

Line 4411: l_old_detail_ta_id hxc_time_attributes.time_attribute_id%TYPE

4407: l_old_timecard_ta_id hxc_time_attributes.time_attribute_id%TYPE
4408: := -1;
4409: l_old_day_ta_id hxc_time_attributes.time_attribute_id%TYPE
4410: := -1;
4411: l_old_detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
4412: := -1;
4413: -- tables and temporary table local variables
4414: t_attribute_field_name tab_ta_field_name;
4415: t_attribute_value tab_ta_attribute;

Line 4462: l_detail_attribute_category hxc_time_attributes.attribute_category%TYPE; -- Absences

4458: l_detail_bld_blk_idx PLS_INTEGER;
4459: l_bb_skipped_reason VARCHAR2(80);
4460:
4461: -- OTL-Absences Integration (Bug 8779478)
4462: l_detail_attribute_category hxc_time_attributes.attribute_category%TYPE; -- Absences
4463: abs_cnt PLS_INTEGER; -- Absences
4464:
4465:
4466: CURSOR csr_how_big_is_htbb

Line 6200: hxc_time_attributes ta

6196: ta.attribute26, ta.attribute27, ta.attribute28,
6197: ta.attribute29, ta.attribute30
6198: FROM hxc_tmp_bld_blks tmp,
6199: hxc_time_attribute_usages tau,
6200: hxc_time_attributes ta
6201: WHERE tau.time_building_block_id = tmp.time_building_block_id
6202: AND tau.time_building_block_ovn = tmp.time_building_block_ovn
6203: AND ta.time_attribute_id = tau.time_attribute_id
6204: ORDER BY tmp.seq;

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

6254:
6255: TYPE t_old_bld_blk_app_style_id IS TABLE OF hxc_time_building_blocks.approval_style_id%TYPE
6256: INDEX BY BINARY_INTEGER;
6257:
6258: TYPE t_old_bld_blk_bb_info_type_id IS TABLE OF hxc_time_attributes.bld_blk_info_type_id%TYPE
6259: INDEX BY BINARY_INTEGER;
6260:
6261: TYPE t_old_bld_blk_att_cat IS TABLE OF hxc_time_attributes.attribute_category%TYPE
6262: INDEX BY BINARY_INTEGER;

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

6257:
6258: TYPE t_old_bld_blk_bb_info_type_id IS TABLE OF hxc_time_attributes.bld_blk_info_type_id%TYPE
6259: INDEX BY BINARY_INTEGER;
6260:
6261: TYPE t_old_bld_blk_att_cat IS TABLE OF hxc_time_attributes.attribute_category%TYPE
6262: INDEX BY BINARY_INTEGER;
6263:
6264: TYPE t_old_bld_blk_attribute1 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6265: INDEX BY BINARY_INTEGER;

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

6260:
6261: TYPE t_old_bld_blk_att_cat IS TABLE OF hxc_time_attributes.attribute_category%TYPE
6262: INDEX BY BINARY_INTEGER;
6263:
6264: TYPE t_old_bld_blk_attribute1 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6265: INDEX BY BINARY_INTEGER;
6266:
6267: TYPE t_old_bld_blk_attribute2 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6268: INDEX BY BINARY_INTEGER;

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

6263:
6264: TYPE t_old_bld_blk_attribute1 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6265: INDEX BY BINARY_INTEGER;
6266:
6267: TYPE t_old_bld_blk_attribute2 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6268: INDEX BY BINARY_INTEGER;
6269:
6270: TYPE t_old_bld_blk_attribute3 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6271: INDEX BY BINARY_INTEGER;

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

6266:
6267: TYPE t_old_bld_blk_attribute2 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6268: INDEX BY BINARY_INTEGER;
6269:
6270: TYPE t_old_bld_blk_attribute3 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6271: INDEX BY BINARY_INTEGER;
6272:
6273: TYPE t_old_bld_blk_attribute4 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6274: INDEX BY BINARY_INTEGER;

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

6269:
6270: TYPE t_old_bld_blk_attribute3 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6271: INDEX BY BINARY_INTEGER;
6272:
6273: TYPE t_old_bld_blk_attribute4 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6274: INDEX BY BINARY_INTEGER;
6275:
6276: TYPE t_old_bld_blk_attribute5 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6277: INDEX BY BINARY_INTEGER;

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

6272:
6273: TYPE t_old_bld_blk_attribute4 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6274: INDEX BY BINARY_INTEGER;
6275:
6276: TYPE t_old_bld_blk_attribute5 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6277: INDEX BY BINARY_INTEGER;
6278:
6279: TYPE t_old_bld_blk_attribute6 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6280: INDEX BY BINARY_INTEGER;

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

6275:
6276: TYPE t_old_bld_blk_attribute5 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6277: INDEX BY BINARY_INTEGER;
6278:
6279: TYPE t_old_bld_blk_attribute6 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6280: INDEX BY BINARY_INTEGER;
6281:
6282: TYPE t_old_bld_blk_attribute7 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6283: INDEX BY BINARY_INTEGER;

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

6278:
6279: TYPE t_old_bld_blk_attribute6 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6280: INDEX BY BINARY_INTEGER;
6281:
6282: TYPE t_old_bld_blk_attribute7 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6283: INDEX BY BINARY_INTEGER;
6284:
6285: TYPE t_old_bld_blk_attribute8 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6286: INDEX BY BINARY_INTEGER;

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

6281:
6282: TYPE t_old_bld_blk_attribute7 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6283: INDEX BY BINARY_INTEGER;
6284:
6285: TYPE t_old_bld_blk_attribute8 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6286: INDEX BY BINARY_INTEGER;
6287:
6288: TYPE t_old_bld_blk_attribute9 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6289: INDEX BY BINARY_INTEGER;

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

6284:
6285: TYPE t_old_bld_blk_attribute8 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6286: INDEX BY BINARY_INTEGER;
6287:
6288: TYPE t_old_bld_blk_attribute9 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6289: INDEX BY BINARY_INTEGER;
6290:
6291: TYPE t_old_bld_blk_attribute10 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6292: INDEX BY BINARY_INTEGER;

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

6287:
6288: TYPE t_old_bld_blk_attribute9 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6289: INDEX BY BINARY_INTEGER;
6290:
6291: TYPE t_old_bld_blk_attribute10 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6292: INDEX BY BINARY_INTEGER;
6293:
6294: TYPE t_old_bld_blk_attribute11 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6295: INDEX BY BINARY_INTEGER;

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

6290:
6291: TYPE t_old_bld_blk_attribute10 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6292: INDEX BY BINARY_INTEGER;
6293:
6294: TYPE t_old_bld_blk_attribute11 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6295: INDEX BY BINARY_INTEGER;
6296:
6297: TYPE t_old_bld_blk_attribute12 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6298: INDEX BY BINARY_INTEGER;

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

6293:
6294: TYPE t_old_bld_blk_attribute11 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6295: INDEX BY BINARY_INTEGER;
6296:
6297: TYPE t_old_bld_blk_attribute12 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6298: INDEX BY BINARY_INTEGER;
6299:
6300: TYPE t_old_bld_blk_attribute13 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6301: INDEX BY BINARY_INTEGER;

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

6296:
6297: TYPE t_old_bld_blk_attribute12 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6298: INDEX BY BINARY_INTEGER;
6299:
6300: TYPE t_old_bld_blk_attribute13 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6301: INDEX BY BINARY_INTEGER;
6302:
6303: TYPE t_old_bld_blk_attribute14 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6304: INDEX BY BINARY_INTEGER;

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

6299:
6300: TYPE t_old_bld_blk_attribute13 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6301: INDEX BY BINARY_INTEGER;
6302:
6303: TYPE t_old_bld_blk_attribute14 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6304: INDEX BY BINARY_INTEGER;
6305:
6306: TYPE t_old_bld_blk_attribute15 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6307: INDEX BY BINARY_INTEGER;

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

6302:
6303: TYPE t_old_bld_blk_attribute14 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6304: INDEX BY BINARY_INTEGER;
6305:
6306: TYPE t_old_bld_blk_attribute15 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6307: INDEX BY BINARY_INTEGER;
6308:
6309: TYPE t_old_bld_blk_attribute16 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6310: INDEX BY BINARY_INTEGER;

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

6305:
6306: TYPE t_old_bld_blk_attribute15 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6307: INDEX BY BINARY_INTEGER;
6308:
6309: TYPE t_old_bld_blk_attribute16 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6310: INDEX BY BINARY_INTEGER;
6311:
6312: TYPE t_old_bld_blk_attribute17 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6313: INDEX BY BINARY_INTEGER;

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

6308:
6309: TYPE t_old_bld_blk_attribute16 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6310: INDEX BY BINARY_INTEGER;
6311:
6312: TYPE t_old_bld_blk_attribute17 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6313: INDEX BY BINARY_INTEGER;
6314:
6315: TYPE t_old_bld_blk_attribute18 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6316: INDEX BY BINARY_INTEGER;

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

6311:
6312: TYPE t_old_bld_blk_attribute17 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6313: INDEX BY BINARY_INTEGER;
6314:
6315: TYPE t_old_bld_blk_attribute18 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6316: INDEX BY BINARY_INTEGER;
6317:
6318: TYPE t_old_bld_blk_attribute19 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6319: INDEX BY BINARY_INTEGER;

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

6314:
6315: TYPE t_old_bld_blk_attribute18 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6316: INDEX BY BINARY_INTEGER;
6317:
6318: TYPE t_old_bld_blk_attribute19 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6319: INDEX BY BINARY_INTEGER;
6320:
6321: TYPE t_old_bld_blk_attribute20 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6322: INDEX BY BINARY_INTEGER;

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

6317:
6318: TYPE t_old_bld_blk_attribute19 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6319: INDEX BY BINARY_INTEGER;
6320:
6321: TYPE t_old_bld_blk_attribute20 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6322: INDEX BY BINARY_INTEGER;
6323:
6324: TYPE t_old_bld_blk_attribute21 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6325: INDEX BY BINARY_INTEGER;

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

6320:
6321: TYPE t_old_bld_blk_attribute20 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6322: INDEX BY BINARY_INTEGER;
6323:
6324: TYPE t_old_bld_blk_attribute21 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6325: INDEX BY BINARY_INTEGER;
6326:
6327: TYPE t_old_bld_blk_attribute22 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6328: INDEX BY BINARY_INTEGER;

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

6323:
6324: TYPE t_old_bld_blk_attribute21 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6325: INDEX BY BINARY_INTEGER;
6326:
6327: TYPE t_old_bld_blk_attribute22 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6328: INDEX BY BINARY_INTEGER;
6329:
6330: TYPE t_old_bld_blk_attribute23 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6331: INDEX BY BINARY_INTEGER;

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

6326:
6327: TYPE t_old_bld_blk_attribute22 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6328: INDEX BY BINARY_INTEGER;
6329:
6330: TYPE t_old_bld_blk_attribute23 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6331: INDEX BY BINARY_INTEGER;
6332:
6333: TYPE t_old_bld_blk_attribute24 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6334: INDEX BY BINARY_INTEGER;

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

6329:
6330: TYPE t_old_bld_blk_attribute23 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6331: INDEX BY BINARY_INTEGER;
6332:
6333: TYPE t_old_bld_blk_attribute24 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6334: INDEX BY BINARY_INTEGER;
6335:
6336: TYPE t_old_bld_blk_attribute25 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6337: INDEX BY BINARY_INTEGER;

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

6332:
6333: TYPE t_old_bld_blk_attribute24 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6334: INDEX BY BINARY_INTEGER;
6335:
6336: TYPE t_old_bld_blk_attribute25 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6337: INDEX BY BINARY_INTEGER;
6338:
6339: TYPE t_old_bld_blk_attribute26 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6340: INDEX BY BINARY_INTEGER;

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

6335:
6336: TYPE t_old_bld_blk_attribute25 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6337: INDEX BY BINARY_INTEGER;
6338:
6339: TYPE t_old_bld_blk_attribute26 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6340: INDEX BY BINARY_INTEGER;
6341:
6342: TYPE t_old_bld_blk_attribute27 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6343: INDEX BY BINARY_INTEGER;

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

6338:
6339: TYPE t_old_bld_blk_attribute26 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6340: INDEX BY BINARY_INTEGER;
6341:
6342: TYPE t_old_bld_blk_attribute27 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6343: INDEX BY BINARY_INTEGER;
6344:
6345: TYPE t_old_bld_blk_attribute28 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6346: INDEX BY BINARY_INTEGER;

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

6341:
6342: TYPE t_old_bld_blk_attribute27 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6343: INDEX BY BINARY_INTEGER;
6344:
6345: TYPE t_old_bld_blk_attribute28 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6346: INDEX BY BINARY_INTEGER;
6347:
6348: TYPE t_old_bld_blk_attribute29 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6349: INDEX BY BINARY_INTEGER;

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

6344:
6345: TYPE t_old_bld_blk_attribute28 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6346: INDEX BY BINARY_INTEGER;
6347:
6348: TYPE t_old_bld_blk_attribute29 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6349: INDEX BY BINARY_INTEGER;
6350:
6351: TYPE t_old_bld_blk_attribute30 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6352: INDEX BY BINARY_INTEGER;

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

6347:
6348: TYPE t_old_bld_blk_attribute29 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6349: INDEX BY BINARY_INTEGER;
6350:
6351: TYPE t_old_bld_blk_attribute30 IS TABLE OF hxc_time_attributes.attribute1%TYPE
6352: INDEX BY BINARY_INTEGER;
6353:
6354: t_old_bb_id t_old_bld_blk_bb_id;
6355: t_old_bb_ovn t_old_bld_blk_bb_ovn;

Line 7035: , Hxc_time_attributes detail_att';

7031: hxc_time_building_blocks timecard_block
7032: , hxc_time_building_blocks day_block
7033: , Hxc_time_building_blocks detail_block
7034: , Hxc_time_attribute_usages detail_usage
7035: , Hxc_time_attributes detail_att';
7036: l_inline_view_range VARCHAR2 (800)
7037: := '
7038: FROM
7039: (select /*+ no_merge ordered */

Line 7193: , Hxc_time_attributes detail_att

7189: := '
7190: ) tbb
7191: , Hxc_time_building_blocks detail_block
7192: , Hxc_time_attribute_usages detail_usage
7193: , Hxc_time_attributes detail_att
7194: , hxc_time_building_blocks day_block
7195: , hxc_time_building_blocks timecard_block
7196: , hxc_max_ovn detail_max_ovn';
7197: l_incremental_from VARCHAR2 (400)

Line 7203: , Hxc_time_attributes detail_att

7199: FROM
7200: hxc_retrieval_range_blks tbb
7201: , Hxc_time_building_blocks detail_block
7202: , Hxc_time_attribute_usages detail_usage
7203: , Hxc_time_attributes detail_att
7204: , hxc_time_building_blocks day_block
7205: , hxc_time_building_blocks timecard_block
7206: , hxc_latest_details hld
7207: , hxc_max_ovn detail_max_ovn';

Line 7224: , Hxc_time_attributes detail_att

7220: FROM
7221: hxc_retrieval_range_blks tbb
7222: , Hxc_time_building_blocks detail_block
7223: , Hxc_time_attribute_usages detail_usage
7224: , Hxc_time_attributes detail_att
7225: , hxc_time_building_blocks day_block
7226: , hxc_time_building_blocks timecard_block
7227: , hxc_pa_latest_details hld
7228: , hxc_max_ovn detail_max_ovn';

Line 7236: , Hxc_time_attributes detail_att

7232: FROM
7233: hxc_retrieval_range_blks tbb
7234: , Hxc_time_building_blocks detail_block
7235: , Hxc_time_attribute_usages detail_usage
7236: , Hxc_time_attributes detail_att
7237: , hxc_time_building_blocks day_block
7238: , hxc_time_building_blocks timecard_block
7239: , hxc_pay_latest_details hld
7240: , hxc_max_ovn detail_max_ovn';

Line 7305: hxc_time_attributes detail_att

7301: :p_end_date >= tbb_latest.start_time ';
7302: l_rerun VARCHAR2 (1100)
7303: := '
7304: FROM
7305: hxc_time_attributes detail_att
7306: , hxc_time_attribute_usages detail_usage
7307: , hxc_time_building_blocks detail_block
7308: , hxc_time_building_blocks day_block
7309: , hxc_time_attributes timecard_att

Line 7309: , hxc_time_attributes timecard_att

7305: hxc_time_attributes detail_att
7306: , hxc_time_attribute_usages detail_usage
7307: , hxc_time_building_blocks detail_block
7308: , hxc_time_building_blocks day_block
7309: , hxc_time_attributes timecard_att
7310: , hxc_transaction_details txd
7311: , hxc_transactions tx
7312: WHERE
7313: tx.transaction_code = :p_transaction_code