APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_TIME_ATTRIBUTES

Line 385: -- their layout_ids from HXC_TIME_ATTRIBUTES table.

381:
382:
383: -- UPDATE_LAYOUT_IDS
384: -- Updates the timecard records captured in HXC_RPT_TC_RESOURCE_TEMP with
385: -- their layout_ids from HXC_TIME_ATTRIBUTES table.
386:
387: PROCEDURE update_layout_ids
388: AS
389:

Line 393: INDEX(ha HXC_TIME_ATTRIBUTES_PK) */

389:
390: CURSOR get_layout_ids
391: IS SELECT /*+ LEADING(gt)
392: INDEX(hau HXC_TIME_ATTRIBUTE_USAGES_FK2)
393: INDEX(ha HXC_TIME_ATTRIBUTES_PK) */
394: gt.tc_bb_id,
395: ha.attribute1
396: FROM hxc_rpt_tc_resource_temp gt,
397: hxc_time_attribute_usages hau,

Line 398: hxc_time_attributes ha

394: gt.tc_bb_id,
395: ha.attribute1
396: FROM hxc_rpt_tc_resource_temp gt,
397: hxc_time_attribute_usages hau,
398: hxc_time_attributes ha
399: WHERE gt.tc_bb_id = hau.time_building_block_id
400: AND hau.time_building_block_ovn = 1
401: AND hau.time_attribute_id = ha.time_attribute_id
402: AND ha.attribute_category = 'LAYOUT';

Line 411: -- HXC_TIME_ATTRIBUTES to pick out Attribute1 from

407: BEGIN
408:
409: -- Public Procedure update_layout_ids
410: -- Join HXC_RPT_TC_RESOURCE_TEMP, HXC_TIME_ATTRIBUTE_USAGES, and
411: -- HXC_TIME_ATTRIBUTES to pick out Attribute1 from
412: -- LAYOUT Attribute_categroy. -- This is the layout_id.
413: -- Update HXC_RPT_TC_RESOURCE_TEMP with the corresponding layout_id
414: -- for each of the timecard records.
415:

Line 736: -- from HXC_TIME_ATTRIBUTES.

732:
733: -- POPULATE_ATTRIBUTES
734: -- For all the detail time loaded via this request into HXC_RPT_TC_DETAILS_ALL
735: -- populate the relevant (those visible to the user; no hidden values ) time attributes
736: -- from HXC_TIME_ATTRIBUTES.
737:
738:
739: PROCEDURE populate_attributes(p_layout_id IN NUMBER,
740: p_alias_tab OUT NOCOPY ALIASTAB )

Line 805: hxc_time_attributes ha

801: l_dynamic_cursor_where VARCHAR2(2000) := '
802: FROM hxc_rpt_tc_resource_temp gt,
803: hxc_rpt_tc_details_all det,
804: hxc_time_attribute_usages hau,
805: hxc_time_attributes ha
806: WHERE gt.tc_bb_id = det.tc_bb_id
807: AND gt.layout_id = curr_layout_id
808: AND gt.request_id = det.request_id
809: AND det.detail_bb_id = hau.time_building_block_id

Line 945: -- hxc_time_attributes ha

941: -- ,MAX(DECODE(ATTRIBUTE_CATEGORY,'Dummy Cost Context',ha.Attribute1))
942: -- FROM hxc_rpt_tc_resource_temp gt,
943: -- hxc_rpt_tc_details_all det,
944: -- hxc_time_attribute_usages hau,
945: -- hxc_time_attributes ha
946: -- WHERE gt.tc_bb_id = det.tc_bb_id
947: -- AND gt.layout_id = 7
948: -- AND gt.request_id = det.request_id
949: -- AND det.detail_bb_id = hau.time_building_block_id

Line 1285: hxc_time_attributes ha

1281: ' '' ''
1282: FROM hxc_rpt_tc_details_all det,
1283: hxc_rpt_tc_resource_temp gt,
1284: hxc_time_attribute_usages hau,
1285: hxc_time_attributes ha
1286: WHERE gt.tc_bb_id = det.tc_bb_id
1287: AND gt.layout_id = curr_layout_id
1288: AND gt.alias_definition_id = curr_alias_id
1289: AND gt.request_id = det.request_id

Line 1422: -- hxc_time_attributes ha

1418: -- ' '
1419: -- FROM hxc_rpt_tc_details_all det,
1420: -- hxc_rpt_tc_resource_temp gt,
1421: -- hxc_time_attribute_usages hau,
1422: -- hxc_time_attributes ha
1423: -- WHERE gt.tc_bb_id = det.tc_bb_id
1424: -- AND gt.layout_id = 7
1425: -- AND gt.request_id = det.request_id
1426: -- AND hau.time_building_block_id = detail_bb_id

Line 1480: -- to look at for the alias attributes in HXC_TIME_ATTRIBUTES.

1476: -- RPT_TC_DETAILS_ALL table.
1477: -- Find out the alias definition pref associated for all the resources, in this
1478: -- layout and attach them to the table.
1479: -- Open get_alias_columns, passing on this alias definition id, and get the columns
1480: -- to look at for the alias attributes in HXC_TIME_ATTRIBUTES.
1481: -- Attach this to the dynamic strings and do the formatting.
1482: -- Concatenate all the dynamic sql strings, and execute the pl/sql block.
1483:
1484: