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 738: -- from HXC_TIME_ATTRIBUTES.

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

Line 807: hxc_time_attributes ha

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

Line 947: -- hxc_time_attributes ha

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

Line 1287: hxc_time_attributes ha

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

Line 1424: -- hxc_time_attributes ha

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

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

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