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_ARCHIVE dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 485: hxc_time_attribute_usages ar

481: time_attribute_usage_id,
482: time_attribute_id,
483: ROWIDTOCHAR(ar.ROWID)
484: FROM hxc_temp_timecard_chunks temp,
485: hxc_time_attribute_usages ar
486: WHERE ar.time_building_block_id = temp.id
487: AND thread_id = p_thread_id ;
488:
489: CURSOR get_tbb_rowid (p_scope VARCHAR2)

Line 1310: INSERT INTO hxc_time_attribute_usages_ar

1306: usage_rowid_tab(i),
1307: p_thread_id );
1308:
1309:
1310: INSERT INTO hxc_time_attribute_usages_ar
1311: (DATA_SET_ID,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1312: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1313: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN)
1314: SELECT /*+ LEADING(temp) USE_NL(bkuptau) */

Line 1319: hxc_time_attribute_usages bkuptau

1315: p_data_set_id,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1316: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1317: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN
1318: FROM hxc_archive_temp temp,
1319: hxc_time_attribute_usages bkuptau
1320: WHERE bkuptau.ROWID = CHARTOROWID(temp.ref_rowid)
1321: AND thread_id = p_thread_id ;
1322:
1323: l_tau_count := l_tau_count + SQL%ROWCOUNT;

Line 1326: DELETE FROM hxc_time_attribute_usages

1322:
1323: l_tau_count := l_tau_count + SQL%ROWCOUNT;
1324:
1325: FORALL i IN usage_rowid_tab.FIRST..usage_rowid_tab.LAST
1326: DELETE FROM hxc_time_attribute_usages
1327: WHERE ROWID = CHARTOROWID(usage_rowid_tab(i)) ;
1328:
1329: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;
1330: