APPS.HXC_RESTORE dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 485: hxc_time_attribute_usages_ar 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 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 529: hxc_time_attribute_usages hau,

525: ref_ovn,
526: attribute1,
527: attribute2
528: FROM hxc_temp_timecard_chunks temp,
529: hxc_time_attribute_usages hau,
530: hxc_time_attributes hta
531: WHERE thread_id = p_thread_id
532: AND temp.id = hau.time_building_block_id
533: AND temp.ref_ovn = hau.time_building_block_ovn

Line 1564: INSERT INTO hxc_time_attribute_usages

1560: usage_rowid_tab(i),
1561: p_thread_id );
1562:
1563:
1564: INSERT INTO hxc_time_attribute_usages
1565: (DATA_SET_ID,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1566: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1567: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN)
1568: SELECT /*+ LEADING(temp) USE_NL(bkuptau) */

Line 1573: hxc_time_attribute_usages_ar bkuptau

1569: bkuptau.DATA_SET_ID,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1570: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1571: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN
1572: FROM hxc_archive_temp temp,
1573: hxc_time_attribute_usages_ar bkuptau
1574: WHERE bkuptau.ROWID = CHARTOROWID(temp.ref_rowid)
1575: AND thread_id = p_thread_id
1576: AND bkuptau.data_set_id = p_data_set_id;
1577:

Line 1582: DELETE FROM hxc_time_attribute_usages_ar

1578:
1579: l_tau_count := l_tau_count + SQL%ROWCOUNT;
1580:
1581: FORALL i IN usage_rowid_tab.FIRST..usage_rowid_tab.LAST
1582: DELETE FROM hxc_time_attribute_usages_ar
1583: WHERE ROWID = CHARTOROWID(usage_rowid_tab(i))
1584: AND data_set_id = p_data_set_id;
1585:
1586: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;