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

474:
475: l_chunk_size number;
476:
477:
478: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE;
479: TYPE VARCHARTABLE IS TABLE OF VARCHAR2(4000);
480:
481: tc_id_tab NUMTABLE;
482: tc_ovn_tab NUMTABLE;

Line 642: INSERT INTO hxc_time_building_blocks

638: p_thread_id );
639:
640:
641:
642: INSERT INTO hxc_time_building_blocks
643: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
644: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
645: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
646: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,

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

752: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
753: END IF;
754:
755:
756: INSERT INTO hxc_time_building_blocks
757: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
758: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
759: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
760: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,

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

865: AND thread_id = p_thread_id
866: AND ar.data_set_id = p_data_set_id ;
867:
868:
869: INSERT INTO hxc_time_building_blocks
870: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
871: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
872: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
873: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_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 950: INSERT INTO hxc_time_building_blocks

946: AND thread_id = p_thread_id
947: AND ar.data_set_id = p_data_set_id;
948:
949:
950: INSERT INTO hxc_time_building_blocks
951: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
952: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
953: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
954: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_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;

Line 1395: hxc_time_building_blocks hxc

1391: comment_text,
1392: day_start_time,
1393: day_stop_time
1394: FROM hxc_temp_timecard_chunks temp,
1395: hxc_time_building_blocks hxc
1396: WHERE temp.id = hxc.time_building_block_id
1397: AND temp.ref_ovn = hxc.object_version_number
1398: AND temp.scope = 'DETAIL'
1399: AND thread_id = p_thread_id ;