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

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 75: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE;

71:
72:
73: l_chunk_size number;
74:
75: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE;
76: TYPE VARCHARTABLE IS TABLE OF VARCHAR2(4000);
77:
78:
79: TYPE NUMBERTABLE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 555: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE;

551:
552: l_chunk_size number;
553:
554:
555: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE;
556: TYPE VARCHARTABLE IS TABLE OF VARCHAR2(4000);
557:
558: tc_id_tab NUMTABLE;
559: tc_ovn_tab NUMTABLE;

Line 737: INSERT INTO hxc_time_building_blocks

733: p_thread_id );
734:
735:
736:
737: INSERT INTO hxc_time_building_blocks
738: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
739: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
740: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
741: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,

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 851: INSERT INTO hxc_time_building_blocks

847: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
848: END IF;
849:
850:
851: INSERT INTO hxc_time_building_blocks
852: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
853: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
854: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
855: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,

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 964: INSERT INTO hxc_time_building_blocks

960: AND thread_id = p_thread_id
961: AND ar.data_set_id = p_data_set_id ;
962:
963:
964: INSERT INTO hxc_time_building_blocks
965: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
966: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
967: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
968: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_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 1045: INSERT INTO hxc_time_building_blocks

1041: AND thread_id = p_thread_id
1042: AND ar.data_set_id = p_data_set_id;
1043:
1044:
1045: INSERT INTO hxc_time_building_blocks
1046: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
1047: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
1048: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
1049: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_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;

Line 1894: hxc_time_building_blocks hxc

1890: comment_text,
1891: day_start_time,
1892: day_stop_time
1893: FROM hxc_temp_timecard_chunks temp,
1894: hxc_time_building_blocks hxc
1895: WHERE temp.id = hxc.time_building_block_id
1896: AND temp.ref_ovn = hxc.object_version_number
1897: AND temp.scope = 'DETAIL'
1898: AND thread_id = p_thread_id ;