APPS.HXC_ARCHIVE dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 506: hxc_time_attribute_usages ar

502: time_attribute_usage_id,
503: time_attribute_id,
504: ROWIDTOCHAR(ar.ROWID)
505: FROM hxc_temp_timecard_chunks temp,
506: hxc_time_attribute_usages ar
507: WHERE ar.time_building_block_id = temp.id
508: AND thread_id = p_thread_id ;
509:
510: CURSOR get_tbb_rowid (p_scope VARCHAR2)

Line 1525: INSERT INTO hxc_time_attribute_usages_ar

1521: usage_rowid_tab(i),
1522: p_thread_id );
1523:
1524:
1525: INSERT INTO hxc_time_attribute_usages_ar
1526: (DATA_SET_ID,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1527: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1528: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN)
1529: SELECT /*+ LEADING(temp) USE_NL(bkuptau) */

Line 1534: hxc_time_attribute_usages bkuptau

1530: p_data_set_id,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1531: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1532: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN
1533: FROM hxc_archive_temp temp,
1534: hxc_time_attribute_usages bkuptau
1535: WHERE bkuptau.ROWID = CHARTOROWID(temp.ref_rowid)
1536: AND thread_id = p_thread_id ;
1537:
1538: l_tau_count := l_tau_count + SQL%ROWCOUNT;

Line 1541: DELETE FROM hxc_time_attribute_usages

1537:
1538: l_tau_count := l_tau_count + SQL%ROWCOUNT;
1539:
1540: FORALL i IN usage_rowid_tab.FIRST..usage_rowid_tab.LAST
1541: DELETE FROM hxc_time_attribute_usages
1542: WHERE ROWID = CHARTOROWID(usage_rowid_tab(i)) ;
1543:
1544: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;
1545: