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_RESTORE dependencies on HXC_TIME_BUILDING_BLOCKS_AR

Line 30: FROM hxc_time_building_blocks_ar ar

26: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
27: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
28: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,APPLICATION_SET_ID,DATA_SET_ID,
29: TRANSLATION_DISPLAY_KEY
30: FROM hxc_time_building_blocks_ar ar
31: WHERE data_set_id = p_data_set_id
32: AND scope = 'TIMECARD'
33: ORDER BY time_building_block_id;
34:

Line 650: SELECT /+ LEADING(temp) INDEX(bkup HXC_TIME_BUILDING_BLOCKS_AR_PK)/

646: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,
647: RESOURCE_TYPE,APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,
648: PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
649: TRANSLATION_DISPLAY_KEY)
650: SELECT /*+ LEADING(temp) INDEX(bkup HXC_TIME_BUILDING_BLOCKS_AR_PK)*/
651: bkup.DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
652: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
653: bkup.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
654: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,

Line 658: hxc_time_building_blocks_ar bkup

654: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
655: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
656: TRANSLATION_DISPLAY_KEY
657: FROM hxc_temp_timecard_chunks temp,
658: hxc_time_building_blocks_ar bkup
659: WHERE bkup.scope = 'TIMECARD'
660: AND bkup.time_building_block_id = temp.id
661: AND bkup.object_version_number = temp.ref_ovn
662: AND bkup.data_set_id = p_data_set_id

Line 670: FROM hxc_time_building_blocks_ar

666:
667:
668: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
669: DELETE
670: FROM hxc_time_building_blocks_ar
671: WHERE time_building_block_id = tc_id_tab(i)
672: AND object_version_number = tc_ovn_tab(i)
673: AND data_set_id = p_data_set_id ;
674:

Line 770: FROM hxc_time_building_blocks_ar appbkup

766: appbkup.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
767: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
768: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,
769: APPLICATION_SET_ID,TRANSLATION_DISPLAY_KEY
770: FROM hxc_time_building_blocks_ar appbkup
771: WHERE appbkup.scope = 'APPLICATION_PERIOD'
772: AND appbkup.data_set_id = p_data_set_id
773: AND appbkup.time_building_block_id IN ( SELECT id
774: FROM hxc_temp_timecard_chunks temp

Line 782: DELETE FROM hxc_time_building_blocks_ar

778:
779:
780: l_app_period_count := SQL%ROWCOUNT;
781:
782: DELETE FROM hxc_time_building_blocks_ar
783: WHERE time_building_block_id IN ( SELECT id
784: FROM hxc_temp_timecard_chunks
785: WHERE scope IN
786: ('APPLICATION_PERIOD')

Line 861: hxc_time_building_blocks_ar ar

857: ar.start_time,
858: ar.stop_time,
859: thread_id
860: FROM hxc_temp_timecard_chunks temp,
861: hxc_time_building_blocks_ar ar
862: WHERE parent_building_block_id = temp.id
863: AND parent_building_block_ovn = temp.ref_ovn
864: AND temp.scope = 'TIMECARD'
865: AND thread_id = p_thread_id

Line 884: hxc_time_building_blocks_ar bkupday

880: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
881: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
882: TRANSLATION_DISPLAY_KEY
883: FROM hxc_temp_timecard_chunks temp,
884: hxc_time_building_blocks_ar bkupday
885: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
886: AND temp.scope = 'DAY'
887: AND thread_id = p_thread_id
888: AND bkupday.data_set_id = p_data_set_id ;

Line 904: DELETE FROM hxc_time_building_blocks_ar

900:
901: EXIT WHEN rowid_tab.COUNT = 0;
902:
903: FORALL i IN rowid_tab.FIRST..rowid_tab.LAST
904: DELETE FROM hxc_time_building_blocks_ar
905: WHERE ROWID = CHARTOROWID(rowid_tab(i))
906: AND data_set_id = p_data_set_id;
907:
908: l_day_del_count := l_day_del_count + SQL%ROWCOUNT;

Line 942: hxc_time_building_blocks_ar ar

938: nvl(day_stop_time,ar.stop_time),
939: ROWIDTOCHAR(ar.ROWID),
940: thread_id
941: FROM hxc_temp_timecard_chunks temp,
942: hxc_time_building_blocks_ar ar
943: WHERE parent_building_block_id = temp.id
944: AND parent_building_block_ovn = temp.ref_ovn
945: AND temp.scope = 'DAY'
946: AND thread_id = p_thread_id

Line 965: hxc_time_building_blocks_ar bkupday

961: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
962: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
963: TRANSLATION_DISPLAY_KEY
964: FROM hxc_temp_timecard_chunks temp,
965: hxc_time_building_blocks_ar bkupday
966: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
967: AND temp.scope = 'DETAIL'
968: AND thread_id = p_thread_id
969: AND bkupday.data_set_id = p_data_set_id;

Line 984: DELETE FROM hxc_time_building_blocks_ar

980:
981: EXIT WHEN rowid_tab.COUNT = 0;
982:
983: FORALL i IN rowid_tab.FIRST..rowid_tab.LAST
984: DELETE FROM hxc_time_building_blocks_ar
985: WHERE ROWID = CHARTOROWID(rowid_tab(i))
986: AND data_set_id = p_data_set_id;
987:
988: l_det_del_count := l_det_del_count + SQL%ROWCOUNT;