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 745: SELECT /+ LEADING(temp) INDEX(bkup HXC_TIME_BUILDING_BLOCKS_AR_PK)/

741: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,
742: RESOURCE_TYPE,APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,
743: PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
744: TRANSLATION_DISPLAY_KEY)
745: SELECT /*+ LEADING(temp) INDEX(bkup HXC_TIME_BUILDING_BLOCKS_AR_PK)*/
746: bkup.DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
747: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
748: bkup.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
749: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,

Line 753: hxc_time_building_blocks_ar bkup

749: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
750: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
751: TRANSLATION_DISPLAY_KEY
752: FROM hxc_temp_timecard_chunks temp,
753: hxc_time_building_blocks_ar bkup
754: WHERE bkup.scope = 'TIMECARD'
755: AND bkup.time_building_block_id = temp.id
756: AND bkup.object_version_number = temp.ref_ovn
757: AND bkup.data_set_id = p_data_set_id

Line 765: FROM hxc_time_building_blocks_ar

761:
762:
763: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
764: DELETE
765: FROM hxc_time_building_blocks_ar
766: WHERE time_building_block_id = tc_id_tab(i)
767: AND object_version_number = tc_ovn_tab(i)
768: AND data_set_id = p_data_set_id ;
769:

Line 865: FROM hxc_time_building_blocks_ar appbkup

861: appbkup.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
862: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
863: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,
864: APPLICATION_SET_ID,TRANSLATION_DISPLAY_KEY
865: FROM hxc_time_building_blocks_ar appbkup
866: WHERE appbkup.scope = 'APPLICATION_PERIOD'
867: AND appbkup.data_set_id = p_data_set_id
868: AND appbkup.time_building_block_id IN ( SELECT id
869: FROM hxc_temp_timecard_chunks temp

Line 877: DELETE FROM hxc_time_building_blocks_ar

873:
874:
875: l_app_period_count := SQL%ROWCOUNT;
876:
877: DELETE FROM hxc_time_building_blocks_ar
878: WHERE time_building_block_id IN ( SELECT id
879: FROM hxc_temp_timecard_chunks
880: WHERE scope IN
881: ('APPLICATION_PERIOD')

Line 956: hxc_time_building_blocks_ar ar

952: ar.start_time,
953: ar.stop_time,
954: thread_id
955: FROM hxc_temp_timecard_chunks temp,
956: hxc_time_building_blocks_ar ar
957: WHERE parent_building_block_id = temp.id
958: AND parent_building_block_ovn = temp.ref_ovn
959: AND temp.scope = 'TIMECARD'
960: AND thread_id = p_thread_id

Line 979: hxc_time_building_blocks_ar bkupday

975: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
976: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
977: TRANSLATION_DISPLAY_KEY
978: FROM hxc_temp_timecard_chunks temp,
979: hxc_time_building_blocks_ar bkupday
980: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
981: AND temp.scope = 'DAY'
982: AND thread_id = p_thread_id
983: AND bkupday.data_set_id = p_data_set_id ;

Line 999: DELETE FROM hxc_time_building_blocks_ar

995:
996: EXIT WHEN rowid_tab.COUNT = 0;
997:
998: FORALL i IN rowid_tab.FIRST..rowid_tab.LAST
999: DELETE FROM hxc_time_building_blocks_ar
1000: WHERE ROWID = CHARTOROWID(rowid_tab(i))
1001: AND data_set_id = p_data_set_id;
1002:
1003: l_day_del_count := l_day_del_count + SQL%ROWCOUNT;

Line 1037: hxc_time_building_blocks_ar ar

1033: nvl(day_stop_time,ar.stop_time),
1034: ROWIDTOCHAR(ar.ROWID),
1035: thread_id
1036: FROM hxc_temp_timecard_chunks temp,
1037: hxc_time_building_blocks_ar ar
1038: WHERE parent_building_block_id = temp.id
1039: AND parent_building_block_ovn = temp.ref_ovn
1040: AND temp.scope = 'DAY'
1041: AND thread_id = p_thread_id

Line 1060: hxc_time_building_blocks_ar bkupday

1056: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
1057: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
1058: TRANSLATION_DISPLAY_KEY
1059: FROM hxc_temp_timecard_chunks temp,
1060: hxc_time_building_blocks_ar bkupday
1061: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
1062: AND temp.scope = 'DETAIL'
1063: AND thread_id = p_thread_id
1064: AND bkupday.data_set_id = p_data_set_id;

Line 1079: DELETE FROM hxc_time_building_blocks_ar

1075:
1076: EXIT WHEN rowid_tab.COUNT = 0;
1077:
1078: FORALL i IN rowid_tab.FIRST..rowid_tab.LAST
1079: DELETE FROM hxc_time_building_blocks_ar
1080: WHERE ROWID = CHARTOROWID(rowid_tab(i))
1081: AND data_set_id = p_data_set_id;
1082:
1083: l_det_del_count := l_det_del_count + SQL%ROWCOUNT;