APPS.HXC_RESTORE dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 438: hxc_time_attribute_usages_ar ar

434: time_attribute_usage_id,
435: time_attribute_id,
436: ROWIDTOCHAR(ar.ROWID)
437: FROM hxc_temp_timecard_chunks temp,
438: hxc_time_attribute_usages_ar ar
439: WHERE ar.time_building_block_id = temp.id
440: AND thread_id = p_thread_id ;
441:
442: CURSOR get_tbb_rowid (p_scope VARCHAR2)

Line 1195: INSERT INTO hxc_time_attribute_usages

1191: usage_rowid_tab(i),
1192: p_thread_id );
1193:
1194:
1195: INSERT INTO hxc_time_attribute_usages
1196: (DATA_SET_ID,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1197: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1198: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN)
1199: SELECT /*+ LEADING(temp) USE_NL(bkuptau) */

Line 1204: hxc_time_attribute_usages_ar bkuptau

1200: bkuptau.DATA_SET_ID,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1201: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1202: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN
1203: FROM hxc_archive_temp temp,
1204: hxc_time_attribute_usages_ar bkuptau
1205: WHERE bkuptau.ROWID = CHARTOROWID(temp.ref_rowid)
1206: AND thread_id = p_thread_id
1207: AND bkuptau.data_set_id = p_data_set_id;
1208:

Line 1213: DELETE FROM hxc_time_attribute_usages_ar

1209:
1210: l_tau_count := l_tau_count + SQL%ROWCOUNT;
1211:
1212: FORALL i IN usage_rowid_tab.FIRST..usage_rowid_tab.LAST
1213: DELETE FROM hxc_time_attribute_usages_ar
1214: WHERE ROWID = CHARTOROWID(usage_rowid_tab(i))
1215: AND data_set_id = p_data_set_id;
1216:
1217: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;